Amazon Seller Central connection for LinkyFlow

LinkyFlow brings Amazon Seller Central ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

180

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Account

Marketplaces

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

Used as filter by

Catalog Items · marketplaceId

FBA Stock · marketplaceId

Stock (FBM) · marketplaceId

Listing Offers · marketplaceId

Listings · marketplaceId

Order Items · marketplaceId

Orders · marketplaceId

Reports · marketplaceId

Transactions · marketplaceId

Read

Marketplaces

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

Route: GET /marketplaces

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

Inputs you can set

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.

Data returned in 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.

Read

Catalog Items

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

Route: GET /catalogItems

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

Inputs you can set

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.

Data returned in 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.

Read

FBA Stock

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

Route: GET /fbaInventory

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

Inputs you can set

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.

Data returned in 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.

Read

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

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

Inputs you can set

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.

Data returned in 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.

Used as filter by

Listing Offers · sku

Read

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

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

Inputs you can set

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.

Data returned in 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	—	-

Edit

Set Price

Route: PATCH /mutation/listings

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

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.

Read

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

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

Inputs you can set

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.

Data returned in 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	—	-

Edit

Set Stock

Route: PATCH /mutation/inventoryLevels

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Finance

Settlements

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

Used as filter by

Transactions · financialEventGroupId

Read

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

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

Inputs you can set

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.

Data returned in 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.

Read

Transactions

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

Route: GET /transactions

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

Inputs you can set

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.

Data returned in 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.

Read

FBA Inbound Plans

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

Route: GET /inboundPlans

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

Inputs you can set

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.

Data returned in 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.

Read

Reports

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

Route: GET /reports

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

Inputs you can set

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.

Data returned in Excel

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

Create

Request Report

Route: POST /mutation/reports

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Sales

Confirm Shipment

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

Create

Confirm Shipment

Route: POST /mutation/orderConfirmShipment

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Order Items

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

Read

Order Items

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

Route: GET /orderItems

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

Inputs you can set

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.

Data returned in 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.

Used as filter by

Transactions · orderId

Read

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

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

Inputs you can set

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.

Data returned in Excel

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

← PreviousAmazon stock and orders Next →LinkyFlow for Shopify Partners