Connexion Amazon Seller Central pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

180

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

Marketplaces

The Amazon marketplaces the seller sells in, in this connection’s region: their currency, language and domain.

Utilise comme filtre par

Catalog Items · marketplaceId

FBA Stock · marketplaceId

Stock (FBM) · marketplaceId

Listing Offers · marketplaceId

Listings · marketplaceId

Order Items · marketplaceId

Orders · marketplaceId

Reports · marketplaceId

Transactions · marketplaceId

Lecture

Marketplaces

The Amazon marketplaces the seller sells in, in this connection’s region: their currency, language and domain.

Route: GET /marketplaces

Formule Excel: =LF.amazon.marketplaces("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`countryCode` default	string	—	-
`defaultCurrencyCode` default	string	—	-
`domainName` default	string	—	-
`isParticipating` default	boolean	—	-

Catalog

Catalog Items

Amazon’s catalogue, searched by keywords or identifiers: an ASIN’s title, brand, classification and sales ranks.

Lecture

Catalog Items

Amazon’s catalogue, searched by keywords or identifiers: an ASIN’s title, brand, classification and sales ranks.

Route: GET /catalogItems

Formule Excel: =LF.amazon.catalogItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Amazon’s refusal.
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`keywords`	string	No	Words the items hold, comma-separated. This or Identifiers is required.
`identifiers`	string	No	Identifiers of the type named, comma-separated (up to 20). This or Keywords is required.
`identifiersType`	enum	No	What Identifiers are. SKU searches the seller’s own. Values: ASIN, EAN, GTIN, ISBN, JAN
`brandNames`	string	No	Only these brands, comma-separated (with Keywords).
`pageSize`	number	No	Rows per page (max 20). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`itemName` default	string	—	-
`brand` default	string	—	-
`manufacturer`	string	—	-
`modelNumber`	string	—	-
`color`	string	—	-
`size`	string	—	-
`browseNode` default	string	—	-
`itemClassification`	string	—	-
`marketplaceId`	id	→ marketplaces	-
`identifiers`	string	—	-
`salesRanks`	string	—	-

FBA Stock

The stock Amazon holds for the seller in its fulfillment centres, by SKU: fulfillable, inbound, reserved, unfulfillable. Read only.

Lecture

FBA Stock

The stock Amazon holds for the seller in its fulfillment centres, by SKU: fulfillable, inbound, reserved, unfulfillable. Read only.

Route: GET /fbaInventory

Formule Excel: =LF.amazon.fbaInventory("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`skus`	string	No	Only these seller SKUs, comma-separated (up to 50).
`updatedFrom`	string	No	Only the SKUs whose stock changed at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`asin` default	string	—	-
`fnSku`	string	—	-
`productName` default	string	—	-
`condition`	string	—	-
`inventoryDetails`	string	—	-
`fulfillableQuantity` default	number	—	-
`inboundWorkingQuantity`	number	—	-
`inboundShippedQuantity`	number	—	-
`inboundReceivingQuantity`	number	—	-
`reservedQuantity`	string	—	-
`unfulfillableQuantity`	string	—	-
`researchingQuantity`	string	—	-
`totalQuantity` default	number	—	-
`lastUpdatedTime`	date	—	-

Listing Offers

The offers competing on one of the seller’s listings: each seller’s price, shipping, fulfillment and who holds the Buy Box.

Lecture

Listing Offers

The offers competing on one of the seller’s listings: each seller’s price, shipping, fulfillment and who holds the Buy Box.

Route: GET /listingOffers

Formule Excel: =LF.amazon.listingOffers("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`sku`	id	Yes	The seller SKU whose competing offers are read.
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`itemCondition`	enum	No	Default: New Values: New, Used, Collectible, Refurbished, Club
`pageSize`	number	No	Rows per page (max 20). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`sku` default	string	→ listings	-
`SellerId` default	string	—	-
`MyOffer` default	boolean	—	-
`Amount` default	string	—	-
`CurrencyCode` default	string	—	-
`IsBuyBoxWinner` default	boolean	—	-

Listings

The seller’s listings in a marketplace, one per SKU: title, ASIN, status, price, how it is fulfilled and its issues.

Utilise comme filtre par

Listing Offers · sku

Lecture

Listings

The seller’s listings in a marketplace, one per SKU: title, ASIN, status, price, how it is fulfilled and its issues.

Route: GET /listings

Formule Excel: =LF.amazon.listings("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Amazon’s refusal.
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`skus`	string	No	Only these seller SKUs, comma-separated (up to 20), as the seller spelled them.
`withStatus`	enum	No	Only the listings holding this status: BUYABLE (can be bought), DISCOVERABLE (can be found). Values: BUYABLE, DISCOVERABLE
`updatedFrom`	string	No	Updated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`updatedTo`	string	No	Updated at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdFrom`	string	No	Created at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdTo`	string	No	Created at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 20). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`sku` default	string	—	-
`asin` default	string	—	-
`itemName` default	string	—	-
`status` default	string	—	-
`price` default	string	—	-
`currency` default	string	—	-
`fulfilledBy` default	string	—	-
`lastUpdatedDate` default	date	—	-

Modification

Set Price

Route: PATCH /mutation/listings

Entrees configurables

Name	Type	Required	Description
`currency`	string	No	-
`id`	id	Yes	-
`marketplaceId`	id	No	-
`price`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Stock (FBM)

The quantity each listing the seller ships itself makes available in a marketplace. FBA listings are read here, never set: Amazon holds that stock.

Lecture

Stock (FBM)

The quantity each listing the seller ships itself makes available in a marketplace. FBA listings are read here, never set: Amazon holds that stock.

Route: GET /inventoryLevels

Formule Excel: =LF.amazon.inventoryLevels("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Amazon’s refusal.
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`skus`	string	No	Only these seller SKUs, comma-separated (up to 20), as the seller spelled them.
`withStatus`	enum	No	Only the listings holding this status: BUYABLE (can be bought), DISCOVERABLE (can be found). Values: BUYABLE, DISCOVERABLE
`updatedFrom`	string	No	Updated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`updatedTo`	string	No	Updated at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdFrom`	string	No	Created at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdTo`	string	No	Created at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 20). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`sku` default	string	—	-
`asin` default	string	—	-
`itemName` default	string	—	-
`quantity` default	number	—	-
`fulfilledBy` default	string	—	-
`lastUpdatedDate` default	date	—	-

Modification

Set Stock

Route: PATCH /mutation/inventoryLevels

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`marketplaceId`	id	No	-
`quantity`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Finance

Settlements

The seller’s settlement periods (financial event groups): when each opened and closed, its total, and the transfer to the bank.

Utilise comme filtre par

Transactions · financialEventGroupId

Lecture

Settlements

The seller’s settlement periods (financial event groups): when each opened and closed, its total, and the transfer to the bank.

Route: GET /financialEventGroups

Formule Excel: =LF.amazon.financialEventGroups("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`startedFrom`	string	No	Only the groups opened at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`startedTo`	string	No	Only the groups opened before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`ProcessingStatus` default	string	—	-
`FundTransferStatus` default	string	—	-
`CurrencyAmount` default	string	—	-
`CurrencyCode` default	string	—	-
`FundTransferDate` default	date	—	-
`FinancialEventGroupStart` default	date	—	-

Transactions

Every amount posted to the seller’s Amazon account — orders paid, refunds, fees, adjustments — with its order and its settlement.

Lecture

Transactions

Every amount posted to the seller’s Amazon account — orders paid, refunds, fees, adjustments — with its order and its settlement.

Route: GET /transactions

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`postedFrom`	string	No	Only the transactions posted at or after this moment. Empty: the last 30 days (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`postedTo`	string	No	Only the transactions posted before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`transactionStatus`	enum	No	Values: DEFERRED, RELEASED, DEFERRED_RELEASED
`orderId`	string	No	Only the transactions of this order.
`financialEventGroupId`	string	No	Only the transactions of this settlement period (not with Order).
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`transactionType` default	string	—	-
`description` default	string	—	-
`transactionStatus` default	string	—	-
`currencyAmount` default	string	—	-
`currencyCode` default	string	—	-
`orderId` default	id	→ orders	-
`financialEventGroupId` default	string	→ financialEventGroups	-
`postedDate` default	date	—	-

Fulfillment

FBA Inbound Plans

The seller’s plans to send stock into Amazon’s fulfillment centres: name, status and marketplaces.

Lecture

FBA Inbound Plans

The seller’s plans to send stock into Amazon’s fulfillment centres: name, status and marketplaces.

Route: GET /inboundPlans

Formule Excel: =LF.amazon.inboundPlans("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`status`	enum	No	Only the plans in this status. Values: ACTIVE, VOIDED, SHIPPED
`pageSize`	number	No	Rows per page (max 30). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`status` default	string	—	-
`marketplaceIds`	string	—	-
`createdAt` default	date	—	-
`lastUpdatedAt`	date	—	-

Reports

The reports Amazon builds for the seller — settlements, returns, inventory, listings — their status and period. Request one here.

Lecture

Reports

The reports Amazon builds for the seller — settlements, returns, inventory, listings — their status and period. Request one here.

Route: GET /reports

Formule Excel: =LF.amazon.reports("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Amazon’s refusal.
`reportTypes`	string	No	The report types, comma-separated (up to 10). Empty: the settlement reports (GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2).
`processingStatus`	enum	No	Values: IN_QUEUE, IN_PROGRESS, DONE, CANCELLED, FATAL
`marketplaceId`	id	No	The Amazon marketplace to read (A13V1IB3VIYZZH, Amazon.fr), among the seller’s. Empty: the connection’s own.
`createdFrom`	string	No	Only the reports requested at or after this moment (90 days at most) (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdTo`	string	No	Only the reports requested before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`reportType` default	string	—	-
`processingStatus` default	string	—	-
`dataStartTime` default	date	—	-
`dataEndTime` default	date	—	-
`createdTime` default	date	—	-

Creation

Request Report

Route: POST /mutation/reports

Entrees configurables

Name	Type	Required	Description
`dataEndTime`	string	No	-
`dataStartTime`	string	No	-
`marketplaceId`	id	No	-
`reportOptions`	string	No	-
`reportType`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales

Confirm Shipment

Tells Amazon this FBM order shipped, with its carrier and tracking number: the items named, or every item not shipped yet.

Creation

Confirm Shipment

Route: POST /mutation/orderConfirmShipment

Entrees configurables

Name	Type	Required	Description
`carrierCode`	string	Yes	-
`carrierName`	string	No	-
`marketplaceId`	id	No	-
`orderId`	id	Yes	-
`orderItemIds`	string	No	-
`shipDate`	string	No	-
`shippingMethod`	string	No	-
`trackingNumber`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Order Items

The items of the seller’s orders, one row each: SKU, ASIN, quantity ordered and shipped, price and proceeds.

Lecture

Order Items

The items of the seller’s orders, one row each: SKU, ASIN, quantity ordered and shipped, price and proceeds.

Route: GET /orderItems

Formule Excel: =LF.amazon.orderItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketplaceId`	id	No	Only the orders of this marketplace. Empty: every marketplace of the seller in this region.
`fulfillmentStatus`	enum	No	Only the orders in this status. Values: PENDING_AVAILABILITY, PENDING, UNSHIPPED, PARTIALLY_SHIPPED, SHIPPED
`fulfilledBy`	enum	No	MERCHANT (FBM) or AMAZON (FBA). Values: MERCHANT, AMAZON
`updatedFrom`	string	No	Updated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`updatedTo`	string	No	Updated at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdFrom`	string	No	Created at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdTo`	string	No	Created at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`orderId` default	id	→ orders	-
`sellerSku` default	string	—	-
`title` default	string	—	-
`quantityOrdered` default	number	—	-
`orderStatus` default	string	—	-

Orders

The seller’s orders in this region: status, who fulfils it, what the seller receives, its items and its packages. Never the buyer.

Utilise comme filtre par

Transactions · orderId

Lecture

Orders

The seller’s orders in this region: status, who fulfils it, what the seller receives, its items and its packages. Never the buyer.

Route: GET /orders

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Amazon’s refusal.
`marketplaceId`	id	No	Only the orders of this marketplace. Empty: every marketplace of the seller in this region.
`fulfillmentStatus`	enum	No	Only the orders in this status. Values: PENDING_AVAILABILITY, PENDING, UNSHIPPED, PARTIALLY_SHIPPED, SHIPPED
`fulfilledBy`	enum	No	MERCHANT (FBM) or AMAZON (FBA). Values: MERCHANT, AMAZON
`updatedFrom`	string	No	Updated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`updatedTo`	string	No	Updated at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdFrom`	string	No	Created at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`createdTo`	string	No	Created at or before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
`pageSize`	number	No	Rows per page (max 100). Default: 20
`pageToken`	string	No	The token the previous page answered (nextToken): empty for the first page.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	string	—	-
`fulfilledBy` default	string	—	-
`marketplaceId` default	id	→ marketplaces	-
`itemCount` default	number	—	-
`createdTime` default	date	—	-

← PrécédentStock et commandes Amazon Suivant →LinkyFlow pour les partenaires Shopify