Amazon Seller Data Reference

Orders

One row per Amazon order. Date range: filtered by purchase date. Large presets may take longer because of Amazon rate limits. Buyer and shipping address fields are coming soon for new exports.

Column	Description
Amazon Order ID	Amazon order ID (e.g. `123-4567890-1234567`).
Purchase Date	When the gift certificate was purchased.
Last Updated Date	When Amazon last updated the order record.
Order Status	Amazon order status (e.g. Shipped, Pending, Canceled).
Fulfillment Channel	Who fulfills the order (`AFN` = FBA, `MFN` = seller fulfilled).
Sales Channel	Marketplace sales channel (e.g. Amazon.com).
Ship Service Level	Shipping service level selected for the order.
Currency	ISO 4217 currency code (e.g. `USD`).
Order Total	Order total amount.
Items Shipped	Count of items already shipped on the order.
Items Unshipped	Count of items not yet shipped.
Payment Method	How the order was paid.
Marketplace ID	Amazon marketplace identifier.
Is Premium Order	Whether the order is a premium order.
Is Business Order	Whether the order is an Amazon Business order.
Is Prime	Whether the order is a Prime order.
Order Type	Amazon order type.
Earliest Ship Date	Earliest ship-by date for the order.
Latest Ship Date	Latest ship-by date for the order.
Earliest Delivery Date	Earliest promised delivery date.
Latest Delivery Date	Latest promised delivery date.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Coming soon for new exports: Buyer Email, Buyer Name, Ship City, Ship State, Ship Postal Code, Ship Country. Existing exports that already selected these columns continue to receive them when Amazon provides the data.

Order Items

One row per order line item. Date range: uses the selected date range (aligned with the Orders window).

Column	Description
Amazon Order ID	Amazon order ID (e.g. `123-4567890-1234567`).
Order Item ID	Amazon order item ID for this line.
ASIN	Amazon Standard Identification Number.
Seller SKU	Your SKU for the offer.
Title	Listing or item title.
Quantity Ordered	Units ordered on this line.
Currency	ISO 4217 currency code (e.g. `USD`).
Item Price	Line item price (before tax).
Item Tax	Tax on the item price.
Shipping Price	Shipping charged for the line.
Shipping Tax	Tax on shipping.
Shipping Discount	Shipping discount applied to the line.
Promotion Discount	Promotion discount applied to the line.
Promotion ID	Promotion ID applied to the line, when present.
Condition	Item condition (e.g. New).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

FBA Inventory

One row per FBA inventory SKU. Full export each run: current FBA inventory snapshot; the date range does not apply.

Column	Description
Seller SKU	Your SKU for the offer.
FNSKU	Fulfillment Network SKU used by Amazon FBA.
ASIN	Amazon Standard Identification Number.
Product Name	Product title from Amazon.
Condition	Item condition (e.g. New).
Fulfillable Quantity	FBA units available to sell.
Inbound Working	Units in inbound shipments being prepared.
Inbound Shipped	Units shipped inbound to Amazon.
Inbound Receiving	Units being received at Amazon.
Reserved Quantity	Units reserved (e.g. pending orders).
Total Quantity	Total FBA units across fulfillable, inbound, reserved, etc.
Unsellable Quantity	Units marked unsellable.
Per Unit Volume	Cubic volume per unit used for storage fees.
Researching Quantity	Units under research / investigation.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Listings

One row per active listing/offer. Full export each run: current listings snapshot; the date range does not apply.

Column	Description
Seller SKU	Your SKU for the offer.
ASIN	Amazon Standard Identification Number.
Item Name	Listing title.
Item Description	Listing description.
Listing ID	Amazon listing ID.
Price	Unit or listing price in the row currency.
Currency	ISO 4217 currency code (e.g. `USD`).
Quantity	Available or ordered quantity.
Open Date	When the listing was opened.
Product ID Type	Product identifier type on the listing.
Item Condition	Listed item condition.
Status	Order or record status as reported by the platform.
Fulfillment Channel	Who fulfills the order (`AFN` = FBA, `MFN` = seller fulfilled).
Business Price	Business / Amazon Business price when set.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Settlement Reports

One row per settlement report line. Uses Amazon-generated settlement flat files only (separate from Financial Events). Older history is limited by Amazon report retention (about 90 days). The date preset filters by when Amazon created each report file, not the settlement period inside it.

Column	Description
Settlement ID	Settlement / payout statement ID.
Settlement Start Date	Start of the settlement period.
Settlement End Date	End of the settlement period.
Deposit Date	When Amazon deposited (or scheduled) the settlement.
Total Amount	Settlement or event total amount.
Currency	Currency code for monetary fields on the row.
Transaction Type	Transaction type within the settlement or event stream.
Order ID	Parent order ID.
Merchant Order ID	Merchant / seller order ID when provided.
SKU	SKU for the product, variant, or line.
Quantity Purchased	Units associated with the financial line.
Marketplace	Marketplace name for the financial line.
Amount Type	Amount classification (e.g. ItemPrice, Principal, Commission).
Amount Description	Human-readable description of the amount line.
Amount	Coupon amount or gift certificate face value / monetary amount.
Fulfillment ID	Fulfillment channel or ID on the financial line.
Posted Date	When the financial event was posted.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Financial Events

One row per Finances API event line (charges, fees, refunds, adjustments). Date range: filtered by posted date. Separate from Settlement Reports. How far back Amazon returns data varies; use append mode on scheduled exports to build history in your destination.

Column	Description
Event Type	Financial event category (e.g. Shipment, Refund, Adjustment).
Financial Event Group ID	Financial event group ID from the Finances API.
Settlement ID	Settlement / payout statement ID.
Settlement Start Date	Start of the settlement period.
Settlement End Date	End of the settlement period.
Deposit Date	When Amazon deposited (or scheduled) the settlement.
Total Amount	Settlement or event total amount.
Currency	Currency code for monetary fields on the row.
Transaction Type	Transaction type within the settlement or event stream.
Order ID	Parent order ID.
Merchant Order ID	Merchant / seller order ID when provided.
SKU	SKU for the product, variant, or line.
Quantity Purchased	Units associated with the financial line.
Marketplace	Marketplace name for the financial line.
Amount Type	Amount classification (e.g. ItemPrice, Principal, Commission).
Amount Description	Human-readable description of the amount line.
Amount	Coupon amount or gift certificate face value / monetary amount.
Fulfillment ID	Fulfillment channel or ID on the financial line.
Posted Date	When the financial event was posted.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Returns

One row per FBA customer return. Date range: uses the selected date range. FBA-only.

Column	Description
Return Date	When the FBA return was recorded.
Order ID	Parent order ID.
Seller SKU	Your SKU for the offer.
ASIN	Amazon Standard Identification Number.
FNSKU	Fulfillment Network SKU used by Amazon FBA.
Product Name	Product title from Amazon.
Quantity	Available or ordered quantity.
Fulfillment Center ID	Amazon fulfillment center that received the return.
Detailed Disposition	Disposition of the returned unit (e.g. SELLABLE).
Return Reason	Return or reimbursement reason.
Status	Order or record status as reported by the platform.
License Plate Number	LPN barcode for the returned unit when present.
Customer Comments	Customer comments on the return, if any.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

FBA Storage Fees

One row per ASIN/SKU in the monthly FBA storage fee report. The selected date range does not backfill full history.

Column	Description
ASIN	Amazon Standard Identification Number.
FNSKU	Fulfillment Network SKU used by Amazon FBA.
Product Name	Product title from Amazon.
Fulfillment Center	Fulfillment Center.
Country Code	Country Code.
Longest Side	Longest Side.
Median Side	Median Side.
Shortest Side	Shortest Side.
Measurement Units	Measurement Units.
Weight	Weight.
Weight Units	Weight Units.
Item Volume	Item Volume.
Volume Units	Volume Units.
Product Size Tier	Product Size Tier.
Average Quantity On Hand	Average Quantity On Hand.
Average Quantity Pending Removal	Average Quantity Pending Removal.
Estimated Total Item Volume	Estimated Total Item Volume in the row currency unless noted otherwise.
Month Of Charge	Month the storage fee applies to.
Storage Rate	Storage rate used for the fee calculation.
Currency	Currency code for monetary fields on the row.
Estimated Monthly Storage Fee	Estimated monthly FBA storage fee for the row.
Dangerous Goods Storage Type	Dangerous Goods Storage Type.
Eligible For Inventory Discount	Eligible For Inventory Discount in the row currency unless noted otherwise.
Qualifies For Inventory Discount	Qualifies For Inventory Discount in the row currency unless noted otherwise.
Total Incentive Fee Amount	Total Incentive Fee Amount in the row currency unless noted otherwise.
Breakdown Incentive Fee Amount	Breakdown Incentive Fee Amount in the row currency unless noted otherwise.
Average Quantity Customer Orders	Average Quantity Customer Orders.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

FBA Long-Term Storage Fees

One row per long-term storage fee charge. Date range: uses the selected date range.

Column	Description
Snapshot Date	Date of the long-term storage fee snapshot.
SKU	SKU for the product, variant, or line.
FNSKU	Fulfillment Network SKU used by Amazon FBA.
ASIN	Amazon Standard Identification Number.
Product Name	Product title from Amazon.
Condition	Item condition (e.g. New).
Per Unit Volume	Cubic volume per unit used for storage fees.
Currency	Currency code for monetary fields on the row.
Volume Unit	Volume Unit.
Country	Country.
Quantity Charged	Quantity charged long-term storage fees.
Amount Charged	Long-term storage fee amount charged.
Surcharge Age Tier	Age tier used for the long-term storage surcharge.
Rate Surcharge	Surcharge rate applied.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

FBA Fee Preview

One row per active FBA offer with estimated fees. Current snapshot: not historical; Amazon typically allows this report about once per day.

Column	Description
SKU	SKU for the product, variant, or line.
FNSKU	Fulfillment Network SKU used by Amazon FBA.
ASIN	Amazon Standard Identification Number.
Product Name	Product title from Amazon.
Product Group	Product Group.
Brand	Brand.
Fulfilled By	Fulfilled By.
Has Local Inventory	Boolean: Has Local Inventory.
Your Price	Your Price in the row currency unless noted otherwise.
Sales Price	Sales Price in the row currency unless noted otherwise.
Longest Side	Longest Side.
Median Side	Median Side.
Shortest Side	Shortest Side.
Length And Girth	Length And Girth.
Unit Of Dimension	Unit Of Dimension.
Item Package Weight	Item Package Weight.
Unit Of Weight	Unit Of Weight.
Product Size Weight Band	Product Size Weight Band.
Currency	Currency code for monetary fields on the row.
Estimated Fee Total	Estimated total FBA fees for the offer.
Estimated Referral Fee Per Unit	Estimated referral fee per unit.
Estimated Variable Closing Fee	Estimated variable closing fee.
Expected Domestic Fulfilment Fee Per Unit	Expected domestic FBA fulfillment fee per unit.
Expected EFN Fulfilment Fee Per Unit UK	Expected EFN Fulfilment Fee Per Unit UK in the row currency unless noted otherwise.
Expected EFN Fulfilment Fee Per Unit DE	Expected EFN Fulfilment Fee Per Unit DE in the row currency unless noted otherwise.
Expected EFN Fulfilment Fee Per Unit FR	Expected EFN Fulfilment Fee Per Unit FR in the row currency unless noted otherwise.
Expected EFN Fulfilment Fee Per Unit IT	Expected EFN Fulfilment Fee Per Unit IT in the row currency unless noted otherwise.
Expected EFN Fulfilment Fee Per Unit ES	Expected EFN Fulfilment Fee Per Unit ES in the row currency unless noted otherwise.
Expected EFN Fulfilment Fee Per Unit SE	Expected EFN Fulfilment Fee Per Unit SE in the row currency unless noted otherwise.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

FBA Reimbursements

One row per FBA reimbursement. Date range: uses the selected date range. FBA-only.

Column	Description
Approval Date	When the reimbursement was approved.
Reimbursement ID	Amazon reimbursement ID.
Case ID	Support case ID related to the reimbursement.
Amazon Order ID	Amazon order ID (e.g. `123-4567890-1234567`).
Reason	Return or reimbursement reason.
SKU	SKU for the product, variant, or line.
FNSKU	Fulfillment Network SKU used by Amazon FBA.
ASIN	Amazon Standard Identification Number.
Product Name	Product title from Amazon.
Condition	Item condition (e.g. New).
Currency	Currency (ISO 4217 when applicable).
Amount Per Unit	Reimbursement amount per unit.
Amount Total	Total reimbursement amount.
Quantity Reimbursed Cash	Units reimbursed as cash.
Quantity Reimbursed Inventory	Units reimbursed as inventory.
Quantity Reimbursed Total	Total units reimbursed.
Original Reimbursement ID	Original Reimbursement ID from the source platform.
Original Reimbursement Type	Original Reimbursement Type.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Promotions

One row per promotion (and ASIN breakdown fields when present). Lightning Deal and Best Deal performance for promotions that start in the selected date range. Requires Brand Registry eligibility.

Column	Description
Promotion ID	Amazon promotion ID.
Promotion Name	Promotion display name.
Marketplace ID	Amazon marketplace identifier.
Merchant ID	Seller / merchant ID.
Promotion Type	Promotion type (e.g. Lightning Deal, Best Deal).
Status	Order or record status as reported by the platform.
Creation Channel	Channel used to create the promotion.
Glance Views	Glance views attributed to the promotion.
Units Sold	Units sold under the promotion.
Revenue	Revenue attributed to the promotion.
Revenue Currency	Currency for promotion revenue.
Amount Spent	Amount spent on the promotion.
Amount Spent Currency	Currency for amount spent.
Start Date	Promotion or coupon start datetime.
End Date	Promotion or coupon end datetime.
Created Date	When the promotion was created.
Last Updated Date	When the promotion was last updated.
Funding Agreement ID	Funding agreement ID when applicable.
Vendor Code	Vendor code when applicable.
ASIN	Amazon Standard Identification Number.
Product Name	Product title from Amazon.
Product Glance Views	Glance views for this ASIN under the promotion.
Product Units Sold	Units sold for this ASIN under the promotion.
Product Revenue	Revenue for this ASIN under the promotion.
Product Revenue Currency	Currency for product revenue.
Product Amount Spent	Amount spent for this ASIN under the promotion.
Product Amount Spent Currency	Currency for product amount spent.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Coupons

One row per coupon campaign. Stats for coupons whose start date falls in the selected range (Brand Analytics role; may be empty if your account is ineligible).

Column	Description
Coupon ID	Amazon coupon ID.
Merchant ID	Seller / merchant ID.
Marketplace ID	Amazon marketplace identifier.
Currency	ISO 4217 currency code (e.g. `USD`).
Coupon Name	Buyer or entity display name.
Website Message	Customer-facing coupon message on the site.
Start Date	Promotion or coupon start datetime.
End Date	Promotion or coupon end datetime.
Customer Segment	Customer segment targeted by the coupon.
Discount Type	Coupon discount type.
Discount Amount	Discount amount on the order.
Clips	Number of times the coupon was clipped.
Redemptions	Number of coupon redemptions.
Budget	Coupon budget.
Total Discount	Total discount given via the coupon.
Budget Spent	Budget spent so far.
Budget Remaining	Budget remaining.
Budget Percentage Used	Percent of budget used.
Sales	Sales attributed to the coupon.
ASINs	ASINs covered by the coupon.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).