Connexion eBay pour LinkyFlow

LinkyFlow connecte Excel a eBay pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

Account

Fulfillment Policies

Shipping / fulfillment business policies.

Lecture

Fulfillment Policies

Shipping / fulfillment business policies.

Route: GET /fulfillmentPolicies

Formule Excel: =LF.ebay.fulfillmentPolicies("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketplace_id`	enum	Yes	eBay marketplace id Values: EBAY_US, EBAY_GB, EBAY_DE, EBAY_FR, EBAY_IT
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`description`	string	—	-
`fulfillmentPolicyId` default	id	—	-
`marketplaceId` default	enum	—	-
`name` default	string	—	-

Payment Policies

Payment business policies.

Lecture

Payment Policies

Payment business policies.

Route: GET /paymentPolicies

Formule Excel: =LF.ebay.paymentPolicies("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketplace_id`	enum	Yes	eBay marketplace id Values: EBAY_US, EBAY_GB, EBAY_DE, EBAY_FR, EBAY_IT
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`description`	string	—	-
`marketplaceId` default	enum	—	-
`name` default	string	—	-
`paymentPolicyId` default	id	—	-

Return Policies

Return business policies.

Lecture

Return Policies

Return business policies.

Route: GET /returnPolicies

Formule Excel: =LF.ebay.returnPolicies("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketplace_id`	enum	Yes	eBay marketplace id Values: EBAY_US, EBAY_GB, EBAY_DE, EBAY_FR, EBAY_IT
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`description`	string	—	-
`marketplaceId` default	enum	—	-
`name` default	string	—	-
`returnPolicyId` default	id	—	-
`returnsAccepted` default	boolean	—	-

Finances

Payouts

Payouts to your bank account from the eBay Finances API.

Lecture

Payouts

Payouts to your bank account from the eBay Finances API.

Route: GET /payouts

Formule Excel: =LF.ebay.payouts("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`filter`	string	No	eBay filter (e.g. payoutStatus:{SUCCEEDED})
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount`	string	—	-
`currency` default	string	—	-
`value` default	number	—	-
`payoutDate` default	string	—	-
`payoutId` default	id	—	-
`payoutInstrument`	string	—	-
`instrumentType`	string	—	-
`nickname`	string	—	-
`payoutStatus` default	enum	—	-
`transactionCount`	number	—	-

Transactions

Monetary transactions from the eBay Finances API.

Lecture

Transactions

Monetary transactions from the eBay Finances API.

Route: GET /transactions

Formule Excel: =LF.ebay.transactions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`filter`	string	No	eBay filter (e.g. transactionStatus:{FUNDS_AVAILABLE_FOR_PAYOUT})
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`currency` default	string	—	-
`value` default	number	—	-
`transactionDate` default	string	—	-
`transactionId` default	id	—	-
`transactionStatus` default	enum	—	-
`transactionType` default	enum	—	-

Inventory

Inventory Items

SKU-level inventory items (quantity, condition, product details).

Utilise comme filtre par

Offers · sku

Lecture

Inventory Items

SKU-level inventory items (quantity, condition, product details).

Route: GET /inventoryItems

Formule Excel: =LF.ebay.inventoryItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`sku`	string	No	Read exactly this item. Answers one row, or none.
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`availability`	string	—	-
`shipToLocationAvailability`	string	—	-
`condition` default	enum	—	-
`locale`	string	—	-
`product`	string	—	-
`brand`	string	—	-
`description`	string	—	-
`mpn`	string	—	-
`title` default	string	—	-
`sku` default	string	—	-

Creation

Create / Replace Inventory Item

Route: POST /mutation/inventoryItems

Entrees configurables

Name	Type	Required	Description
`availability.shipToLocationAvailability.quantity`	number	No	-
`condition`	enum	No	Values: NEW, LIKE_NEW, USED_EXCELLENT, USED_VERY_GOOD, USED_GOOD
`product.brand`	string	No	-
`product.description`	string	No	-
`product.mpn`	string	No	-
`product.title`	string	Yes	-
`sku`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Inventory Item

Route: PATCH /mutation/inventoryItems

Entrees configurables

Name	Type	Required	Description
`availability.shipToLocationAvailability.quantity`	number	No	-
`condition`	enum	No	Values: NEW, LIKE_NEW, USED_EXCELLENT, USED_VERY_GOOD, USED_GOOD
`product.brand`	string	No	-
`product.description`	string	No	-
`product.mpn`	string	No	-
`product.title`	string	Yes	-
`sku`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Inventory Item

Route: DELETE /mutation/inventoryItems

Entrees configurables

Name	Type	Required	Description
`availability.shipToLocationAvailability.quantity`	number	No	-
`condition`	enum	No	Values: NEW, LIKE_NEW, USED_EXCELLENT, USED_VERY_GOOD, USED_GOOD
`product.brand`	string	No	-
`product.description`	string	No	-
`product.mpn`	string	No	-
`product.title`	string	Yes	-
`sku`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Inventory Locations

Warehouses / store locations that fulfil inventory.

Lecture

Inventory Locations

Warehouses / store locations that fulfil inventory.

Route: GET /inventoryLocations

Formule Excel: =LF.ebay.inventoryLocations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`location`	string	—	-
`address`	string	—	-
`merchantLocationKey` default	id	—	-
`merchantLocationStatus` default	enum	—	-
`name` default	string	—	-

Offers

Marketplace offers that turn inventory items into listings.

Lecture

Offers

Marketplace offers that turn inventory items into listings.

Route: GET /offers

Formule Excel: =LF.ebay.offers("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`sku`	id	No	Offers of these SKUs (eBay reads one at a time). Required unless offerId is given.
`offerId`	id	No	Read exactly this offer. Answers one row, or none.
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`availableQuantity` default	number	—	-
`format` default	enum	—	-
`marketplaceId` default	enum	—	-
`offerId` default	id	—	-
`sku` default	string	→ inventoryItems	-
`status` default	enum	—	-

Creation

Create Offer

Route: POST /mutation/offers

Entrees configurables

Name	Type	Required	Description
`availableQuantity`	number	No	-
`categoryId`	id	No	-
`format`	enum	Yes	Values: FIXED_PRICE, AUCTION
`listingDescription`	string	No	-
`listingPolicies.fulfillmentPolicyId`	id	No	-
`listingPolicies.paymentPolicyId`	id	No	-
`listingPolicies.returnPolicyId`	id	No	-
`marketplaceId`	enum	Yes	Values: EBAY_US, EBAY_GB, EBAY_DE, EBAY_FR, EBAY_IT
`merchantLocationKey`	string	No	-
`pricingSummary.price.currency`	string	No	-
`pricingSummary.price.value`	number	No	-
`sku`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Offer

Route: PATCH /mutation/offers

Entrees configurables

Name	Type	Required	Description
`availableQuantity`	number	No	-
`categoryId`	id	No	-
`format`	enum	Yes	Values: FIXED_PRICE, AUCTION
`listingDescription`	string	No	-
`listingPolicies.fulfillmentPolicyId`	id	No	-
`listingPolicies.paymentPolicyId`	id	No	-
`listingPolicies.returnPolicyId`	id	No	-
`marketplaceId`	enum	Yes	Values: EBAY_US, EBAY_GB, EBAY_DE, EBAY_FR, EBAY_IT
`merchantLocationKey`	string	No	-
`pricingSummary.price.currency`	string	No	-
`pricingSummary.price.value`	number	No	-
`sku`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Offer

Route: DELETE /mutation/offers

Entrees configurables

Name	Type	Required	Description
`availableQuantity`	number	No	-
`categoryId`	id	No	-
`format`	enum	Yes	Values: FIXED_PRICE, AUCTION
`listingDescription`	string	No	-
`listingPolicies.fulfillmentPolicyId`	id	No	-
`listingPolicies.paymentPolicyId`	id	No	-
`listingPolicies.returnPolicyId`	id	No	-
`marketplaceId`	enum	Yes	Values: EBAY_US, EBAY_GB, EBAY_DE, EBAY_FR, EBAY_IT
`merchantLocationKey`	string	No	-
`pricingSummary.price.currency`	string	No	-
`pricingSummary.price.value`	number	No	-
`sku`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Publish Offer

Publishes an offer as a live eBay listing. Buyers can see it, and eBay may charge an insertion fee.

Creation

Publish Offer

Route: POST /mutation/offerPublish

Entrees configurables

Name	Type	Required	Description
`offerId`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Withdraw Offer

Ends the live listing for an offer. The offer itself is kept and can be published again.

Creation

Withdraw Offer

Route: POST /mutation/offerWithdraw

Entrees configurables

Name	Type	Required	Description
`offerId`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales

Orders

Orders placed by buyers.

Lecture

Orders

Orders placed by buyers.

Route: GET /orders

Formule Excel: =LF.ebay.orders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`orderIds`	string	No	Exact order id(s), comma-separated. Mutually exclusive with filter/limit/offset.
`filter`	string	No	eBay filter expression (e.g. creationdate:[2024-01-01T00:00:00.000Z..])
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`buyer`	string	—	-
`username` default	string	—	-
`creationDate` default	string	—	-
`legacyOrderId`	id	—	-
`orderFulfillmentStatus` default	enum	—	-
`orderId` default	id	—	-
`orderPaymentStatus` default	enum	—	-
`pricingSummary`	string	—	-
`total`	string	—	-