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	string	—	-
`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	string	—	-
`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	string	—	-
`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	string	—	-
`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	string	—	-
`transactionType` default	string	—	-

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	-
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

Field	Type	Relations	Description
`availability`	string	—	-
`shipToLocationAvailability`	string	—	-
`condition` default	string	—	-
`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	string	—	-
`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	Yes	Filter offers by SKU (required by eBay)
`limit`	number	No	Rows per page (max 200) Default: 50

Donnees retournees dans Excel

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

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.

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	-
`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	string	—	-
`orderId` default	id	—	-
`orderPaymentStatus` default	string	—	-
`pricingSummary`	string	—	-
`total`	string	—	-