Connect to the Amazon Selling Partner API and get all your Amazon Business data automatically
Get central access to all your Amazon data
Automate your data workflows
Become a truly data-driven Amazon seller
The Amazon Selling Partner API data connector from Pipes
Amazon’s Selling Partner API includes several interfaces for automatic transmission of different information about your Amazon business. For the first time, both Sellers and Vendors have access to their Amazon data via an API. With its Amazon SP-API data connector, Data Virtuality Pipes offers you the possibility to automatically retrieve this data according to a schedule defined by you.
Below you find the information that each section of the Amazon SP API can provide:
Orders API
With the Orders API section, you can get any order-related information you need, such as order date, order status, fulfillment channel, payment method and more. This information helps you to optimize your order management process, your resource planning and your whole business intelligence.
Products API
Through the Products API sections, you can obtain information like certain product attributes, categories, current prices, fee estimations and other information related to products and listings. Using this information, you can match your products on Amazon Marketplace with those already listed on Amazon in order to make sourcing and pricing decisions for them.
Fulfillment API
The three Fulfillment API sections (inbound, outbound and inventory) enable you to obtain lists of inbound and outbound shipments or shipment items and related information, such as preparation instructions, transport information, package labels, carrier name and many more for all your shipments in Amazon's fulfillment network.
Finances API
With the Finances API section, you can download financial events for certain orders or financial event groups, as well as for a date range, even if the statement period has not closed yet. And you can also obtain financial event groups for a certain date range.
Reports API
The Reports API provides you with a variety of reports and best practices that can help you analyze, prioritize and manage your Amazon business.
Feeds API
Through the Feeds API section, you can get information about the processing of feed submissions in the past 90 days.
Sellers API
With the Sellers API section, you can retrieve information about your seller account, e.g. the marketplaces you participate in, suspended listings in these marketplaces, the default language, the default currency and more.
For a detailed look at the available Seller and Vendor data, check out the Amazon Selling Partner API documentation here.
How Pipes works
Three simple steps in less than three minutes.
Connect Your
Data Warehouse
Connect Your
Sources
Create Your
Pipelines
Play Video
Watch this 3 min demo to
learn how Amazon SP-API works
Pipes is an official Software Partner and Service Partner of Amazon
Pipes enables Amazon Sellers and Vendors to access the Amazon SP-API to load all their Amazon data automatically into their data warehouse on a regular basis.
The Amazon Seller and Vendor data templates from Pipes
For easy and convenient configuration of constant Amazon data pipelines, Pipes provide you with pre-built data templates. These contain data schemas of meaningfully related metrics of Amazon Seller or Vendor businesses. Select the templates of your choice, set a replication frequency and create and execute your data pipelines. See below the Amazon SP-API data templates and what data they contain.
Amazon Seller Central data templates:
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| contentReferenceKey | A unique reference key for the A+ Content document. A content reference key cannot form a permalink and may change in the future. A content reference key is not guaranteed to match any A+ content identifier |
| contentMetadata_badgeSet | The set of content badges |
| contentMetadata_marketplaceId | The identifier for the marketplace where the A+ Content is published |
| contentMetadata_name | The A+ Content document name |
| contentMetadata_status | The submission status of the content document |
| contentMetadata_updateTime | The approximate age of the A+ Content document and metadata |
Detailed Active Listings Report
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| item_name | The item name |
| item_description | The item description |
| listing_id | The listing id |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| quantity | The total number of units reimbursed for this line item |
| open_date | Open date |
| image_url | The image url |
| item_is_marketplace | Item is marketplace |
| product_id_type | The type of product id |
| zshop_shipping_fee | Zshop shipping fee |
| item_note | The item note |
| item_condition | Numeric entry that indicates the condition of the product. This field is required. Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines |
| zshop_category1 | Zshop category1 |
| zshop_browse_path | Zshop browse path |
| zshop_storefront_feature | Zshop storefront feature |
| asin1 | The Amazon Standard Identification Number (ASIN) of the item |
| asin2 | The Amazon Standard Identification Number (ASIN) of the item |
| asin3 | The Amazon Standard Identification Number (ASIN) of the item |
| will_ship_internationally | Will ship internationally |
| expedited_shipping | Expedited shipping |
| zshop_boldface | Zshop boldface |
| product_id | The product id |
| bid_for_featured_placement | The bid for featured placement |
| add_delete | Add delete |
| pending_quantity | Pending quantity |
| fulfillment_channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| Business_Price | A special price that is available only for Amazon Business orders |
| Quantity_Price_Type | Quantity price type |
| Quantity_Lower_Bound_1 | Quantity lower bound |
| Quantity_Price_1 | Quantity price |
| Quantity_Lower_Bound_2 | Quantity lower bound |
| Quantity_Price_2 | Quantity price |
| Quantity_Lower_Bound_3 | Quantity lower bound |
| Quantity_Price_3 | Quantity price |
| Quantity_Lower_Bound_4 | Quantity lower bound |
| Quantity_Price_4 | Quantity price |
| Quantity_Lower_Bound_5 | Quantity lower bound |
| Quantity_Price_5 | Quantity price |
| merchant_shipping_group | The merchant shipping group |
| Progressive_Price_Type | Progressive price type |
| Progressive_Lower_Bound_1 | Progressive lower bound |
| Progressive_Price_1 | Progressive price |
| Progressive_Lower_Bound_2 | Progressive lower bound |
| Progressive_Price_2 | Progressive price |
| Progressive_Lower_Bound_3 | Progressive lower bound |
| Progressive_Price_3 | Progressive price |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| item_name | The item name |
| item_description | The item description |
| listing_id | The listing id |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| quantity | The total number of units reimbursed for this line item |
| open_date | Open date |
| image_url | The image url |
| item_is_marketplace | Item is marketplace |
| product_id_type | The type of product id |
| zshop_shipping_fee | Zshop shipping fee |
| item_note | The item note |
| item_condition | Numeric entry that indicates the condition of the product. This field is required. Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines |
| zshop_category1 | Zshop category1 |
| zshop_browse_path | Zshop browse path |
| zshop_storefront_feature | Zshop storefront feature |
| asin1 | The Amazon Standard Identification Number (ASIN) of the item |
| asin2 | The Amazon Standard Identification Number (ASIN) of the item |
| asin3 | The Amazon Standard Identification Number (ASIN) of the item |
| will_ship_internationally | Will ship internationally |
| expedited_shipping | Expedited shipping |
| zshop_boldface | Zshop boldface |
| product_id | Product id |
| bid_for_featured_placement | Bid for featured placement |
| add_delete | Add delete |
| pending_quantity | Pending quantity |
| fulfillment_channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| merchant_shipping_group | Merchant shipping group |
| status | Current status of this item within the order |
| Minimum_order_quantity | Minimum order quantity |
| Sell_remainder | Sell remainder |
| Parameter | Description |
| UNIQUE_ACCOUNT_IDENTIFIER | A unique alphanumeric identifier for your account |
| ACTIVITY_PERIOD | Year and Month where activity is contained within the report |
| SALES_CHANNEL | The channel where the transaction originated. – “MFN” – Merchant Fulfillment Network: These are shipments fulfilled directly by the seller for sales placed on Amazon’s websites. “AFN” – Amazon Fulfillment Network: These are shipments fulfilled by Amazon on the seller’s behalf for sales placed on Amazon’s websites |
| MARKETPLACE | The marketplace in which the order was placed |
| PROGRAM_TYPE | This column identifies the program type pertaining to the transaction. There are business teams within Amazon that launch programs catering to different use cases for Amazon and the seller. AVTR includes such programs when the corresponding activities are relevant for the seller’s VAT reporting. – “LIQUIDATION”: Liquidation sales of excess inventory initiated by a seller. For more details, refer to FBA Liquidations. – “DONATION”: Donation of excess inventory to a charitable organization through the Fulfillment by Amazon donations program. For more details, refer to FBA Donations. – “COMMINGLING”: Acquisition or disposal of a product from/to another FBA seller (or Amazon Retail), participating in the Commingling Program. For more details, refer to Commingling FAQs. – “REGULAR”: Any transaction to which the above program types do not apply |
| TRANSACTION_TYPE | Shipment, Refund, Retrocharge, Order Fee, etc |
| TRANSACTION_EVENT_ID | Transaction Event ID is an ID that relates to the entire transaction. – This ID can be used to search for transactional level information in Seller Central. – Transaction event IDs can appear more than once if there are sales, refunds, returns, and/or multiple items in an order |
| ACTIVITY_TRANSACTION_ID | Activity Transaction ID is an identifier that relates to lower-level activity within a transaction event. For example, multiple shipments or refunds for one order. – This ID cannot be used to search for transactional level information in Seller Central. – Activity Transaction IDs can appear more than once if there are multiple items related the activity level |
| TAX_CALCULATION_DATE | The date that is used to determine the VAT details |
| TRANSACTION_DEPART_DATE | Date associated with the departure (outbound) movement to the final destination. This date may be in a different month from the arrival month. Date used to determine the month in which the activity will be contained in the transaction report is the TRANSACTION_COMPLETE_DATE. – MFN/AFN: “Sale”- Shipment Date (seller to buyer shipments). This is also the date the buyer’s payment instrument is charged. – AFN: “Commingling_Sell” & “Commingling_Buy” – Shipment Date (seller-to-buyer shipments). – AFN: “Liquidation_Sale” – Shipment date (seller-to-buyer shipments). – AFN: “Donation” – Shipment date (seller-to-buyer shipments). – AFN: “Return”- Date good(s) sent back. This field will be blank if the data is not provided to Amazon by the buyer or Carrier. – AFN: “FC_Transfer”- Process Date: The date inventory began its movement from a Fulfillment Center. – AFN: “Inbound”- The date in which you create shipment in “Manage FBA Shipments” page. – MFN/AFN: “Refund”- Blank. There is a monetary change and the date is reflected in TRANSACTION_COMPLETE_DATE. – NOTE: Product movement will be reflected in the Return section |
| TRANSACTION_ARRIVAL_DATE | Date associated with the final destination (inbound) movement. This date may be in a different month from the arrival month. Date used to determine the month in which the activity will be contained in the transaction report is the TRANSACTION_COMPLETE_DATE_UTC. – MFN/AFN: “Sale”- Delivery date (seller to buyer shipments). This field will be blank if the data is not provided to Amazon by the Carrier. – AFN: “Commingling_Sell” & “Commingling_Buy” – Delivery Date (seller-to-buyer shipments). – AFN: “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – Empty. – AFN: “Return”- Date return arrived at Fulfillment Center. (buyer to seller returns) . – AFN: “FC_Transfer”- Date items arrive at the Fulfillment Center receiving dock and are pending check-in. – AFN: “Inbounds”- Date items arrive at the Fulfillment Center receiving dock and completed check-in. – MFN/AFN: “Refund”- Blank. There is a monetary change and the date is reflected in TRANSACTION_COMPLETE_DATE. – NOTE: Product movement will be reflected in the Return section |
| TRANSACTION_COMPLETE_DATE | Date used to determine the month in which the activity will be contained in the transaction report. – MFN/AFN: “Sale”, “Liquidation_Sale”, “Donation” – Shipment Date (seller to Buyer shipments). This is also the date the buyer’s payment instrument is charged. – AFN: “Commingling_Sell” & “Commingling_Buy” – Shipment Date (seller-to-buyer shipments). – AFN: “Return”- Date return arrived at Fulfillment Center. (Buyer to seller returns) . – MFN/AFN: “Refund”, “Liquidation_Refund” – Date the refund of monetary values was completed. – NOTE: Product movement will be reflected in the Return section. – AFN: “FC_Transfer”- Received Date, the date the inventory was checked into the receiving Fulfillment Center. – AFN: “Inbounds”- Received Date, the date the inventory is checked into the receiving Fulfillment Center |
| SELLER_SKU | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that are assigned to Amazon by the seller to make it easier for them to identify their products. Seller SKUs are required when listing an item. If SKU available, populated. If unavailable, populated as ‘Not Available’ |
| ASIN | The Amazon Standard Identification Number of the item |
| ITEM_DESCRIPTION | The product description based on the Amazon Marketplace in which the item transacted. – “FC_Transfer” & “Inbound”: The product description based on seller’s home market place. This field will be blank if product description not available in seller’s home market place |
| ITEM_MANUFACTURE_COUNTRY | Two character country code where the product was originally made or manufactured; this is not the location where the item is sold |
| QTY | The total number of units in reserved status |
| ITEM_WEIGHT | The weight of each individual SKU item in kilograms (kg). – All Transactions – Except MFN/AFN “Refund”: The unit weight in kilograms (kg). – “FC_Transfer” & “Inbound”: The weight of each individual SKU item in kilograms (kg) based on seller’s home market place. – This field will be blank if not available in seller’s home market place. – MFN/AFN: “Refund”, “Liquidation_Refund” – Refunds only reflect financial movement, so this value will be 0. Product movement will be reflected in the “Return” section |
| TOTAL_ACTIVITY_WEIGHT | Total weight of the units moved for this activity line. The unit will be in kilograms (kg). – All Use Cases: “QUANTITY” x “ITEM_WEIGHT”. – “FC_Transfer” & “Inbound”: Total weight of the units moved for this activity line in kilograms (kg) based on seller’s home market place. – This field will be blank if not available in seller’s home market place |
| COST_PRICE_OF_ITEMS | The cost price of the item (amount paid to acquire the item) as provided by the seller |
| PRICE_OF_ITEMS_AMT_VAT_EXCL | The total price of items for all units (quantity) in the activity type, excluding VAT, Shipping, Gift Wrap, and Promotion amounts. Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts |
| PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL | The promotion amount applied to the transaction type for all units (quantity) in the activity type, Excluding VAT, Shipping, Gift Wrap, and Price of Item amounts. – Sales are reflected as negative amounts, and returns/refunds are reflected as positive amounts |
| TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL | The total value of the item price paid by the buyer, excluding VAT, Shipping, and Gift Wrap. – “PRICE_OF_ITEMS_AMT_VAT_EXCL” + “PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL” |
| SHIP_CHARGE_AMT_VAT_EXCL | The amount of shipping charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Gift Wrap, and Promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts |
| PROMO_SHIP_CHARGE_AMT_VAT_EXCL | The promotion amount applied to shipping charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Shipping Charge, and Gift Wrap amounts. – Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts |
| TOTAL_SHIP_CHARGE_AMT_VAT_EXCL | The total value of shipping paid or refunded to the buyer, excluding VAT, Price of Items, and Gift Wrap,. – “SHIP_CHARGE_AMT_VAT_EXCL” + “PROMO_SHIP_CHG_AMT_VAT_EXCL” |
| GIFT_WRAP_AMT_VAT_EXCL | The amount of gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Shipping, and Promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts |
| PROMO_GIFT_WRAP_AMT_VAT_EXCL | The promotion amount applied to gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, and Shipping amounts. – Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts |
| TOTAL_GIFT_WRAP_AMT_VAT_EXCL | The total value of gift wrap paid or refunded to the buyer, excluding VAT, Price of Items, and Shipping. – “GIFT_WRAP_AMT_VAT_EXCL” + “PROMO_GIFT_WRAP_AMT_VAT_EXCL” |
| TOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL | The total value of the activity, excluding VAT. – “TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL” + “TOTAL_SHIP_CHARGE_AMT_VAT_EXCL” + “TOTAL_GIFT_WRAP_AMT_VAT_EXCL” |
| PRICE_OF_ITEMS_VAT_RATE_PERCENT | The VAT rate percentage applied to the activity. The rate percentage is provided as decimal value (e.g.0.20=20%, 0.02=2%) |
| PRICE_OF_ITEMS_VAT_AMT | The VAT amount charged or refunded to the buyer from the seller on the items in the activity based on the PRICE_OF_ITEMS_VAT_RATE_PERCENT. – This amount excludes shipping, gift wrap, promotions, and PRICE_OF_ITEMS_VAT_EXCL |
| PROMO_PRICE_OF_ITEMS_VAT_AMT | The VAT amount charged or refunded to the buyer from the seller on the promotional amount applied to the items in the activity based on the PRICE_OF_ITEMS_VAT_RATE_PERCENT. – This amount excludes shipping, gift wrap, PRICE_OF_ITEMS_VAT_EXCL, and PRICE_OF_ITEMS_VAT_AMT |
| TOTAL_PRICE_OF_ITEMS_VAT_AMT | The total VAT amount charged/refunded to the buyer from the seller on the items in the activity. – “PRICE_OF_ITEMS_VAT_AMT” + “PROMO_PRICE_OF_ITEMS_VAT_AMT” |
| SHIP_CHARGE_VAT_RATE_PERCENT | The VAT rate percentage applied to the shipping charged/refunded to the buyer for the activity. – The rate percentage is provided as decimal value (e.g.0.20=20%, 0.02=2%) |
| SHIP_CHARGE_VAT_AMT | The VAT amount charged or refunded to the buyer from the seller on the shipping amount based on the SHIP_CHARGE_VAT_RATE_PERCENT. – This amount excludes price of items, gift wrap, promotions, and SHIP_CHARGE_AMT_VAT_EXCL |
| PROMO_SHIP_CHARGE_VAT_AMT | The VAT amount charged or refunded to the buyer from the seller on the promotional amount applied to the shipping amount, based on the SHIP_CHARGE_VAT_RATE_PERCENT. – This amount excludes price of items, gift wrap, and SHIP_CHARGE_AMT_VAT_EXCL |
| TOTAL_SHIP_CHARGE_VAT_AMT | The total VAT amount charged/refunded to the buyer from the seller on the shipping amount for the activity. – “SHIP_CHARGE_VAT_AMT” + “PROMO_SHIP_CHARGE_VAT_AMT” |
| GIFT_WRAP_VAT_RATE_PERCENT | The VAT rate percentage applied to the gift wrap charged/refunded to the buyer for the activity. – The rate percentage is provided as decimal value (e.g.0.20=20%, 0.02=2%) |
| GIFT_WRAP_VAT_AMT | The VAT rate percentage applied to the gift wrap charged/refunded to the buyer for the activity. – The rate percentage is provided as decimal value (e.g.0.20=20%, 0.02=2%) |
| PROMO_GIFT_WRAP_VAT_AMT | The VAT amount charged or refunded to the buyer from the seller on the promotional amount applied to Gift Wrap, based on the GIFT_WRAP_VAT_RATE_PERCENT. – This amount excludes price of items, shipping, and GIFT_WRAP_AMT_VAT_EXCL |
| TOTAL_GIFT_WRAP_VAT_AMT | The total VAT amount charged/refunded to the buyer from the seller on the gift wrap for the activity. – “GIFT_WRAP_VAT_AMT” + “PROMO_GIFT_WRAP_VAT_AMT” |
| TOTAL_ACTIVITY_VALUE_VAT_AMT | The total VAT for the activity. – “TOTAL_PRICE_OF_ITEMS_VAT_AMT” + “TOTAL_SHIP_CHARGE_VAT_AMT” + “TOTAL_GIFT_WRAP_VAT_AMT” |
| PRICE_OF_ITEMS_AMT_VAT_INCL | The total price of items for all units (quantity) in the activity type, including VAT and excluding Shipping, Gift Wrap, and Promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”, “Liquidation_Sale”: The total VAT inclusive amount of the items in the activity. – “Donation” – This will be blank. – AFN “Commingling_Buy” & “Commingling_Sell”: The total VAT-inclusive amount of the items in the activity. – MFN/AFN “Refund”, “Liquidation_Refund”: The total VAT inclusive amount of the items in the activity. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds”. – This will be blank. The service made available by Amazon does not currently capture this information from sellers. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL | The total promotion price of items for all units (quantity) in the activity type, including VAT and excluding price of items, shipping, and gift wrap. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: The total VAT inclusive promotional amount of the items in the activity. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – AFN: “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no promotional amounts applied to Commingling transactions. – MFN/AFN “Refund”: The total VAT inclusive promotional amount of the items in the activity. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds”: There are no promotional amounts applied to Inbound and Transfer activity. There are no financial movements between the seller and Amazon. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL | The total price of items for all units (quantity) in the activity type, including VAT and excluding Shipping and Gift Wrap charges. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”, “Liquidation_Sale”: PRICE_OF_ITEMS_AMT_VAT_INCL + PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL. – AFN “Commingling_Buy” & “Commingling_Sell”: PRICE_OF_ITEMS_AMT_VAT_INCL. – MFN/AFN “Refund”, “Liquidation_Refund”: PRICE_OF_ITEMS_AMT_VAT_INCL + PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds” & “Return” & “Return” & “Donation”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| SHIP_CHARGE_AMT_VAT_INCL | The amount of shipping charged/refunded to the buyer for all units (quantity) in the activity type, including VAT, but excluding price of items, gift wrap, and promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: The total VAT inclusive amount of the shipping in the activity. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – MFN/AFN “Refund”: The total VAT inclusive amount of the shipping in the activity. – AFN “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no shipping charges for Commingling transactions. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds”: This value will be 0. The buyer is not charged on movement between Fulfillment Centers. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| PROMO_SHIP_CHARGE_AMT_VAT_INCL | The promotion amount for shipping charges for all units (quantity) in the activity type, including VAT and excluding price of items, and gift wrap. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: The total VAT inclusive amount of the promotion amount on shipping charges in the activity. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – MFN/AFN “Refund”: The total VAT inclusive amount of the promotion amount on shipping charges in the activity. – AFN “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no shipping charges for Commingling transactions. – NOTE: Product movement will be reflected in the Return section. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – AFN “FC_Transfer” & “Inbounds”: There are no promotional amounts applied to Inbound and Transfer activity. There are no financial movements between the seller and Amazon. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| TOTAL_SHIP_CHARGE_AMT_VAT_INCL | The total shipping charges for all units (quantity) in the activity type, including VAT and excluding Price of Items, Gift Wrap, and Promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: “SHIP_CHG_VAT_INCL” + “PROMO_SHIP_CHG_VAT_INCL”. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – MFN/AFN “Refund”: “SHIP_CHG_VAT_INCL” + “PROMO_SHIP_CHG_VAT_INCL”. – AFN “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no shipping charges for Commingling transactions. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds”: This value will be 0. The buyer is not charged on movement between Fulfillment Centers. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| GIFT_WRAP_AMT_VAT_INCL | The amount of gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, including VAT, but excluding price of items, shipping and promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: The total VAT inclusive amount of the gift wrap charges in the activity. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – MFN/AFN “Refund”: The total VAT inclusive amount of the gift wrap charges in the activity. – AFN “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no gift wrapping charges for Commingling transactions. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds”: This value will be 0. The buyer is not charged on movement between Fulfillment Centers. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| PROMO_GIFT_WRAP_AMT_VAT_INCL | The promotion amount for gift wrap charges for all units (quantity) in the activity type, including VAT and excluding price of items, shipping, and gift wrap. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: The total VAT inclusive amount of the promotion amount on shipping charges in the activity. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – MFN/AFN “Refund”: The total VAT inclusive amount of the promotion amount on shipping charges in the activity. – AFN “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no gift wrapping charges for Commingling transactions. – NOTE: Product movement will be reflected in the Return section. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – AFN “FC_Transfer” & “Inbounds”: There are no promotional amounts applied to Inbound and Transfer activity. There are no financial movements between the seller and Amazon. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| TOTAL_GIFT_WRAP_AMT_VAT_INCL | The total gift wrap charges for all units (quantity) in the activity type, including VAT and excluding price of items, shipping, and promotion amounts. – Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts. – MFN/AFN “Sale”: “GIFT_WRAP_CHG_VAT_INCL” + “PROMO_GIFT_WRAP_VAT_INCL”. – “Liquidation_Sale”, “Liquidation_Refund”, “Donation” – This will be blank. – MFN/AFN “Refund”: “GIFT_WRAP_CHG_VAT_INCL” + “PROMO_GIFT_WRAP_VAT_INCL”. – AFN “Commingling_Buy” & “Commingling_Sell”: This will be blank. There are no gift wrapping charges for Commingling transactions. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds”: This value will be 0. The buyer is not charged on movement between Fulfillment Centers. – AFN “Return”: This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| TOTAL_ACTIVITY_VALUE_AMT_VAT_INCL | The total VAT inclusive amount for the activity inclusive of Price of Items, Gift Wrap, Shipping, and Promotion Amounts. – “TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL” + “TOTAL_SHIP_CHARGE_AMT_VAT_INCL” + “TOTAL_GIFT_WRAP_AMT_VAT_INCL”. – MFN/AFN “Sale”, “Liquidation_Sale”: The amount charged or refunded to the buyer for this activity. – MFN/AFN “Refund”, “Liquidation_Refund”: The amount charged or refunded to the buyer for this activity. – AFN “Commingling_Buy” & “Commingling_Sell”: The amount charged to the buyer for this activity. – NOTE: Product movement will be reflected in the Return section. – AFN “FC_Transfer” & “Inbounds” & “Return” & “Donation” : This will be blank. The service made available by Amazon does not currently capture this information from sellers. – Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers |
| TRANSACTION_CURRENCY_CODE | Currency code that relates to the activity. – MFN/AFN: “Sale”, “Liquidation_Sale”, “Refund”, “Liquidation_Refund”, & “Donation” – The currency of the marketplace in which the item was sold. – AFN: “Commingling_Buy” & “Commingling_Sell” – The currency of the marketplace in which the item was sold |
| COMMODITY_CODE | An eight digit numeric code provided by the European Government that identifies a group of goods |
| STATISTICAL_CODE_DEPART | Additional national statistic code required for certain products departing from specific countries. – For example, in CZ, additional statistical codes relate to fuels related commodities and in FR, additional statistical codes relate to meats, wines, and aircrafts related commodities |
| STATISTICAL_CODE_ARRIVAL | Additional national statistic code required for certain products delivered to specific countries. – For example, in CZ, additional statistical codes relate to fuels related commodities and in FR, additional statistical codes relate to meats, wines, and aircrafts related commodities |
| COMMODITY_CODE_SUPPLEMENTARY_UNIT | Supplementary unit for certain Commodity Codes. – For example, carats for diamonds |
| ITEM_QTY_SUPPLEMENTARY_UNIT | COMMODITY_CODE_SUPPLEMENTARY_UNIT quantity in the transaction. – For example, 10 if it is a 10 carat diamond |
| TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT | Total supplementary weight of the transaction. – For example, if there are 3 diamonds in this order and each diamond is 10. Carats, this will be 30. – “ITEM_QTY_SUPPLEMENTARY_UNIT” x “QTY” |
| PRODUCT_TAX_CODE | A standard code to identify the tax properties of a product |
| DEPATURE_CITY | City associated with the departure location for the transaction. – AFN: “Sale”, “Liquidation_Sale”, “Donation” – Amazon Fulfillment Center region where the items departed from. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre region where the transfer took place. – AFN: “FC_Transfer” – Amazon Fulfillment Center region where the items departed from |
| DEPARTURE_COUNTRY | Two character country code associated with the departure location for the transaction. – AFN: “Sale”, “Liquidation_Sale”, “Donation” – Amazon Fulfillment Center country where the items departed from. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre country where the transfer took place. – AFN: “FC_Transfer” – Amazon Fulfillment Center country where the items departed from |
| DEPARTURE_POST_CODE | Post Code associated with the departure location for the transaction. – AFN: “Sale”, “Liquidation_Sale”, “Donation” – Amazon Fulfillment Center postcode where the items departed from. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre postcode where the transfer took place. – AFN: “FC_Transfer” – Amazon Fulfillment Center post code where the items departed from |
| ARRIVAL_CITY | City associated with the arrival location for the transaction. – MFN/AFN: “Sale”, “Liquidation_Sale”, “Donation” – Region where the shipment was delivered. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre region where the transfer took place. – AFN: “Return”: Amazon Fulfillment Center region where the return items arrived. – AFN: “FC_Transfer” & Inbound – Amazon Fulfillment Center region where the inbound items arrived |
| ARRIVAL_COUNTRY | Two character country code associated with the arrival location for the transaction. – MFN/AFN: “Sale”, “Liquidation_Sale”, “Donation” – Country where the shipment was delivered. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre country where the transfer took place. – AFN: “Return”: Amazon Fulfillment Center country where the return items arrived. – AFN: “FC_Transfer” & Inbound – Amazon Fulfillment Center country where the inbound items arrived |
| ARRIVAL_POST_CODE | Post Code associated with the arrival location for the transaction. – MFN/AFN: “Sale”, “Liquidation_Sale”, “Donation” – Post code where the shipment was delivered. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre postcode where the transfer took place. – AFN: “Return”: Amazon Fulfillment Center post code where the return items arrived. – AFN: “FC_Transfer” & Inbound – Amazon Fulfillment Center post code where the inbound items arrived |
| SALE_DEPART_COUNTRY | Two character departure country code associated with the original sale. – AFN: “Sale”, “Return”, “Refund”, “Liquidation_Sale”, “Liquidation_Refund” – Amazon Fulfillment Center country where the items departed from. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre country where the transfer took place |
| SALE_ARRIVAL_COUNTRY | Two character arrival country code associated with the original sale. – AFN/MFN: “Sale”, “Return”, “Refund”, “Liquidation_Sale”, “Liquidation_Refund” – Buyer’s delivery country associated with the original sale. – AFN: “Commingling_Buy” & “Commingling_Sell” – Amazon Fulfilment Centre country where the transfer took place |
| TRANSPORTATION_MODE | The way goods are moved between destinations. – AFN: “FC_Transfer”, “Donation” – Transport by Road |
| DELIVERY_CONDITIONS | The delivery conditions (Incoterms) used to communicate the condition in which the product was delivered. – Incoterms are a series of pre-defined commercial terms published by the International Chamber of Commerce (ICC). The Incoterms are intended to clearly communicate the tasks, costs, and risks associated with the transportation and delivery of goods. – MFN: “Sale” – Amazon does not have the information as the transaction originated from the seller and these values will be blank. – MFN/AFN: “Refund”, “Liquidation_Refund” – There is no product movement related to a Refund and these values will be blank |
| SELLER_DEPART_VAT_NUMBER_COUNTRY | The country associated with the seller’s VAT number in relation to the departure country. This is represented as a two character country code |
| SELLER_DEPART_COUNTRY_VAT_NUMBER | The seller’s VAT number in relation to the departure country |
| SELLER_ARRIVAL_VAT_NUMBER_COUNTRY | The country associated with the seller’s VAT number in relation to the arrival country. This is represented as a two character country code |
| SELLER_ARRIVAL_COUNTRY_VAT_NUMBER | The seller’s VAT number in relation to the arrival country |
| TRANSACTION_SELLER_VAT_NUMBER_COUNTRY | The country associated with the seller’s VAT number used for this transaction. This is represented as a two character country code |
| TRANSACTION_SELLER_VAT_NUMBER | Seller’s VAT number provided for this transaction and is also reflected on the VAT Invoice. – The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as seller has not activated VAT Calculation Services and this must be filled in by the seller if applicable |
| BUYER_VAT_NUMBER_COUNTRY | The country associated with the buyer’s VAT number provided for this transaction. This is represented as a two character country code |
| BUYER_VAT_NUMBER | Buyer’s VAT number provided for this transaction |
| VAT_CALCULATION_IMPUTATION_COUNTRY | The country which was used to back VAT out of the VAT inclusive price. This is represented as a two character country code |
| TAXABLE_JURISDICTION | Indicates the jurisdictional value where a tax calculation was performed. For example, Country, Territory, etc |
| TAXABLE_JURISDICTION_LEVEL | Indicates at which jurisdictional level a tax calculation was performed. For example, Country, Territory, etc |
| VAT_INV_NUMBER | Indicates the sequential number assigned to the tax document, if applicable. E.g. the sequential VAT invoice number or credit note number |
| VAT_INV_CONVERTED_AMT | Indicates the total invoice-level VAT amount converted into the local taxed jurisdiction’s currency, where that currency differs to that of the marketplace |
| VAT_INV_CURRENCY_CODE | Indicates the currency code of the local taxed jurisdiction’s currency, where that currency differs to that of the marketplace |
| VAT_INV_EXCHANGE_RATE | Indicates the exchange rate used to convert the total VAT amount in the marketplace currency to that of the local taxed jurisdiction’s currency. The exchange rates are provided by the European Central Bank |
| VAT_INV_EXCHANGE_RATE_DATE | Indicates the date of the exchange rate used to convert the total VAT amount in the marketplace currency to that of the local taxed jurisdiction’s currency |
| EXPORT_OUTSIDE_EU | Indicates whether or not an item was shipped from a EU28 member country to a country outside the EU28 member countries |
| INVOICE_URL | This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services |
| BUYER_NAME | This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services |
| ARRIVAL_ADDRESS | This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services |
| SUPPLIER_NAME | This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services |
| SUPPLIER_VAT_NUMBER | Supplier’s VAT number |
| TAX_REPORTING_SCHEME | This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services |
| TAX_COLLECTION_RESPONSIBILITY | This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| brand | The brand name of the product |
| category | The primary product category (on Amazon) |
| partNumber | The Manufacturer Part Number(MPN) of the product |
| ean | The European Article Number(EAN) of the product |
| upc | The Universal Product Code(UPC) of the product |
| modelNumber | The Model Number of the product |
| isbn | The International Standard Book Number, or ISBN, of each product |
| itemName | The title of the product |
| initialB2bBuyerIndustry | The industry of the first customer who requested the product |
| initialB2bBuyerRequestedDate | The date we learned this product may not be on Amazon as the result of a customer request |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| brand | The brand name of the product |
| lowestPriceInTheLastWeek_amount | The lowest price in the last week amount |
| category | The primary product category (on Amazon) |
| lowestPriceInTheLastWeek_CurrencyCode | Three-digit currency code in ISO 4217 format |
| partNumber | The Manufacturer Part Number(MPN) of the product |
| ean | The European Article Number(EAN) of the product |
| upc | The Universal Product Code(UPC) of the product |
| modelNumber | The Model Number of the product |
| isbn | The International Standard Book Number, or ISBN, of each product |
| ASIN | The Amazon Standard Identification Number of the item |
| link | A hyperlink to the Amazon product detail page |
| itemName | The title of the product |
| subCategory | It is the secondary product category |
| hasFBAOffer | A value of ‘true’ means at least one Fulfillment by Amazon (FBA) offer exists on the product. A ‘false’ means there are no Fulfillment by Amazon (FBA) offers for the product |
| offerCount | The total number of active offers on each product (including Amazon Retail) |
| reviewCount | This shows the total number of customer reviews on each product |
| b2bSalesRank | It is the sales rank of each product at the category level. The metric is based only on Amazon Business customer purchases |
| b2bSalesRankGrowth | It measures the growth of business sales rank over the past 30 days. It can be ‘High,’ ‘Medium,’ or ‘Low.’ ‘High’ means that the product’s business sales rank has grown over 33% from the previous month. ‘Medium’ means that it has grown from 0% to 33%. ‘Low’ means that the Business Sales Rank has decreased (growth less than 0%) |
| pageViews | It measures the number of times that the specific product has been viewed in the past 30 days. It can be ‘High,’ ‘Medium,’ or ‘Low.’ |
| isBrandYouOffer | true: It means the product shares a brand with at least one of your active offers, false: It means the product does not share a brand with any of your active offers |
| isCategoryYouOffer | true: It shows that the product shares a category with at least one of your active offers, false: It shows that the product does not share a category with any of your active offers |
| productPerformance | It measures the product sales to Amazon Business customers over the past 30 days. It can be Tier 1, Tier 2, or Tier 3 |
| isProductOnAmazon | Is product on Amazon |
| hasAmazonOffer | True: It means that an active Amazon offer exists on the product. False: It means there are no active Amazon offers for the product |
| hasOfferWithVatInvoiceGeneration | This field will be equal to ‘true’ only if it has at least one offer from a seller who has adopted an automated solution for VAT invoice generation. This type of offer will guarantee that the buyer will have access to a downloadable VAT invoice |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| item_name | The item name |
| item_description | The item description |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| quantity | The total number of units reimbursed for this line item |
| image_url | The image url |
| item_is_marketplace | Item is marketplace |
| product_id_type | The type of product id |
| zshop_shipping_fee | Zshop shipping fee |
| item_note | The item note |
| item_condition | Numeric entry that indicates the condition of the product. This field is required. Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines |
| zshop_category1 | Zshop category1 |
| zshop_browse_path | Zshop browse path |
| zshop_storefront_feature | Zshop storefront feature |
| asin1 | The Amazon Standard Identification Number (ASIN) of the item |
| asin2 | The Amazon Standard Identification Number (ASIN) of the item |
| asin3 | The Amazon Standard Identification Number (ASIN) of the item |
| will_ship_internationally | Will ship internationally |
| expedited_shipping | Expedited shipping |
| zshop_boldface | Zshop boldface |
| product_id | The product id |
| add_delete | Add delete |
| Business_Price | A special price that is available only for Amazon Business orders |
| Quantity_Price_Type | Quantity price type |
| Quantity_Lower_Bound_1 | Quantity lower bound |
| Quantity_Price_1 | Quantity price |
| Quantity_Lower_Bound_2 | Quantity lower bound |
| Quantity_Price_2 | Quantity price |
| Quantity_Lower_Bound_3 | Quantity lower bound |
| Quantity_Price_3 | Quantity price |
| Quantity_Lower_Bound_4 | Quantity lower bound |
| Quantity_Price_4 | Quantity price |
| Quantity_Lower_Bound_5 | Quantity lower bound |
| Quantity_Price_5 | Quantity price |
| merchant_shipping_group | The merchant shipping group |
| Progressive_Price_Type | Progressive price type |
| Progressive_Lower_Bound_1 | Progressive lower bound |
| Progressive_Price_1 | Progressive price |
| Progressive_Lower_Bound_2 | Progressive lower bound |
| Progressive_Price_2 | Progressive price |
| Progressive_Lower_Bound_3 | Progressive lower bound |
| Progressive_Price_3 | Progressive price |
| Parameter | Description |
| marketplaceId | Amazon marketplace identifier |
| asin | Amazon Standard Identification Number (ASIN) is the unique identifier for an item in the Amazon catalog |
| brandName | Name of the brand associated with an Amazon catalog item |
| browseNode | Identifier of the browse node associated with an Amazon catalog item |
| itemName | Name, or title, associated with an Amazon catalog item |
| manufacturer | Name of the manufacturer associated with an Amazon catalog item |
| Parameter | Description |
| marketplaceId | The identifier of the marketplace |
| ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| Product_AttributeSets | A list of product attributes if they are applicable to the product that is returned |
| Product_CompetitivePricing_NumberOfOffer… | The number of active offer listings for the item that was submitted. The listing count is returned by condition, one for each listing condition value that is returned |
| Product_CompetitivePricing_TradeInValue_… | The monetary value |
| Product_CompetitivePricing_TradeInValue_… | The currency code in ISO 4217 format |
| Product_Identifiers_MarketplaceASIN_ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| Product_Identifiers_MarketplaceASIN_Mark… | A marketplace identifier |
| Product_Identifiers_SKUIdentifier_Market… | A marketplace identifier |
| Product_Identifiers_SKUIdentifier_Seller… | The seller identifier submitted for the operation |
| Product_Identifiers_SKUIdentifier_Seller… | The seller stock keeping unit (SKU) of the item |
| Product_Relationships | A list that contains product variation information, if applicable |
| Product_SalesRankings | A list of sales rank information for the item, by category |
| SellerSKU | The seller stock keeping unit (SKU) of the item |
| status | The status of the operation |
| Parameter | Description |
| destinationId | The destination identifier generated when you created the destination |
| name | The developer-defined name for this destination |
| resource_eventBridge_accountId | The identifier for the AWS account that is responsible for charges related to receiving notifications |
| resource_eventBridge_name | The name of the partner event source associated with the destination |
| resource_eventBridge_region | The AWS region in which you receive the notifications. For AWS regions that are supported in Amazon EventBridge, see https://docs.aws.amazon.com/general/latest/gr/ev.html |
| resource_sqs_arn | The Amazon Resource Name (ARN) associated with the SQS queue. Pattern : “^arn:aws:sqs:S+:S+:S+” |
| Parameter | Description |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| fulfillment_channel_sku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| asin | The Amazon Standard Identification Number of the item |
| condition_type | The condition of your inventory |
| Warehouse_Condition_code | Code assigned in Amazon”s fulfillment center to listings matching the ASIN and the seller”s condition-type |
| Quantity_Available | Quantity available |
| Parameter | Description |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| fulfillment_channel_sku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| asin | The Amazon Standard Identification Number of the item |
| condition_type | The condition of your inventory |
| Warehouse_Condition_code | Code assigned in Amazon”s fulfillment center to listings matching the ASIN and the seller”s condition-type |
| Quantity_Available | Quantity available |
| Parameter | Description |
| shipment_date | The date the shipment was completed (shipped) by the fulfillment center |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| fnsku | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| asin | The Amazon Standard Identification Number of the item |
| fulfillment_center_id | The fulfillment center where the problem is identified |
| quantity | The total number of units reimbursed for this line item |
| amazon_order_id | The unique identifier assigned to the customer order. This field is empty if the reimbursement is not associated with an order |
| currency | The currency of the removal fee |
| item_price_per_unit | Item price per unit |
| shipping_price | The amount that the buyer paid for shipping. Amount is aggregate of the quantity, not unit price |
| gift_wrap_price | The amount that the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price |
| ship_city | The city of a standard address |
| ship_state | The state or region of a standard address |
| ship_postal_code | The postal (ZIP) code of a standard address |
| Parameter | Description |
| snapshot_date | Report data are current as of the date in this field |
| fnsku | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| product_name | The title of your product |
| quantity | The total number of units reimbursed for this line item |
| fulfillment_center_id | The fulfillment center where the problem is identified |
| detailed_disposition | Status of the product (examples: sellable, damaged) |
| country | Country in which your products are stored |
Estimated Amazon Selling and Fulfillment Fees for the seller’s FBA inventory with active offers
| Parameter | Description |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller |
| fnsku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify products. ASINs are assigned by Amazon. You can find the ASIN on the product detail page |
| product_name | The title of your product |
| product_group | The Amazon department or category |
| brand | The brand of your product |
| fulfilled_by | The entity that fulfilled the item |
| your_price | Your current selling price |
| sales_price | Your current promotional price |
| longest_side | Measurement of the longest side of your product including its packaging |
| median_side | Measurement of the side that is neither the longest nor the shortest side of your product including its packaging |
| shortest_side | Measurement of the shortest side of your product including its packaging |
| length_and_girth | The longest side of your product, including its packaging, plus the girth, a unit measure, equivalent to 2 x (median side + shortest side) |
| unit_of_dimension | The unit of dimension |
| item_package_weight | The item package weight |
| unit_of_weight | The unit of weight used in weight measurement |
| product_size_tier | The size tier assigned to your product by FBA based on its dimensions and weight |
| currency | The currency in which the fee is calculated |
| estimated_fee_total | The estimated fulfillment and Selling on Amazon fee |
| estimated_referral_fee_per_unit | The estimated Selling on Amazon Referral Fee |
| estimated_variable_closing_fee | The estimated Variable Closing Fee for your product |
| estimated_order_handling_fee_per_order | The estimated Order Handling Fee per order |
| estimated_pick_pack_fee_per_unit | Estimated pick pack fee per unit |
| estimated_weight_handling_fee_per_unit | The estimated Weight Handling Fee for your product based on the Outbound Shipping Weight |
| expected_fulfillment_fee_per_unit | Expected fulfillment fee per unit |
| Parameter | Description |
| adjusted_date | Adjusted date |
| transaction_item_id | Unique ID assigned to the item within the order |
| fnsku | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| product_name | The title of your product |
| fulfillment_center_id | The fulfillment center where the problem is identified |
| quantity | The total number of units reimbursed for this line item |
| reason | The reason for the reimbursement (for example, Damaged: Warehouse) |
| disposition | The status of the unit |
| reconciled | Number of units reconciled with other adjustment events |
| unreconciled | Number of units not reconciled with other adjustment events |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| snapshot_date | Report data is current as of the date in this field |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller |
| fnsku | Unique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center |
| asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page |
| product_name | The title of your product |
| condition | The condition of your item |
| avaliable_quantity_sellable_ | Avaliable quantity (sellable) |
| qty_with_removals_in_progress | The number of Units in inventory that you have requested be removed |
| inv_age_0_to_90_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 0-90 days |
| inv_age_91_to_180_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 91 – 180 days |
| inv_age_181_to_270_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 181 – 270 days |
| inv_age_271_to_365_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 271 – 365 days |
| inv_age_365_plus_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 365+ days |
| currency | The currency of the removal fee |
| qty_to_be_charged_ltsf_6_mo | The number of sellable units that will have been in the fulfillment center for 180 to 365 days and are eligible for the LTSF charge. As of February 2019, standard FBA units will not be charged 180-day LTSF. For example, FBA Small and Light fees are not affected by the February 2019 fee change. For more details, see the Program Fees section of FBA Small and Light |
| projected_ltsf_6_mo_cur | Currency of the projected long-term storage fee that will be charged for eligible units that have been in fulfillment centers for 180 to 365 days on the next charge date |
| projected_ltsf_6_mo | The projected long-term storage fee that will be charged for eligible units that have been in fulfillment centers for 180 to 365 days on the next charge date. As of February 2019, standard FBA units will not be charged 180-day LTSF. For example, FBA Small and Light fees are not affected by the February 2019 fee change. For more details, see the Program Fees section of FBA Small and Light |
| qty_to_be_charged_ltsf_12_mo | The number of sellable units that will have been in the fulfillment center for more than 365 days as of the next LTSF charge date (monthly on the 15th in the US; February 15th and August 15th in Canada) |
| projected_ltsf_12_mo_cur | Currency of the projected long-term storage fee that will be charged for units that have been in fulfillment centers for more than 365 days |
| projected_ltsf_12_mo | The projected long-term storage fee that will be charged for units that have been in fulfillment centers for more than 365 days on the next LTSF charge date (monthly on the 15th in the US; February 15th and August 15th in Canada) |
| units_shipped_last_7_days | Sales of this item in last 7 days |
| units_shipped_last_30_days | Sales of this item in last 30 days |
| units_shipped_last_60_days | Sales of this item in last 60 days |
| units_shipped_last_90_days | Sales of this item in last 90 days |
| alert | The alert |
| your_price_cur | Currency of your current selling price |
| your_price | Your current selling price |
| sales_price_cur | Currency of sales price |
| sales_price | Sales price |
| lowest_price_new_cur | Currency of lowest price new |
| lowest_price_new | Lowest price new |
| lowest_price_used_cur | Currency of lowest price used |
| lowest_price_used | Lowest price used |
| Recommended_action | Recommended action |
| Healthy_Inventory_Level | Healthy Inventory Level |
| Recommended_sales_price | Recommended sales price |
| Recommended_sale_duration_days_ | Recommended sale duration (days) |
| Recommended_Removal_Quantity | Recommended removal quantity |
| estimated_cost_savings_of_recommended_ac… | Estimated cost savings of recommended actions |
| sell_through | Sell through |
| item_volume | Item volume |
| volume_units | Volume units |
| storage_type | Storage type |
| Parameter | Description |
| snapshot_date | Date of request |
| transaction_type | Shipment, Refund, Retrocharge, Order Fee, etc |
| fnsku | Unique item ID assigned by Amazon and used by the fulfillment center |
| sku | Unique item ID assigned by the seller |
| product_name | Name of the product as listed on Amazon |
| fulfillment_center_id | Fulfillment center where the adjustment is being made |
| quantity | Number of units adjusted |
| disposition | Whether the item is in sellable or unsellable/unfulfillable condition |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| snapshot_date | Report data is current as of the date in this field |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller |
| fnsku | Unique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center |
| asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page |
| product_name | The title of your product |
| condition | The condition of your item |
| sales_rank | The Sales Rank calculation is based on Amazon sales and is updated daily to reflect recent and historical sales of the item sold on Amazon. The Sales Rank displayed here is for the Product Group within which the item is featured. Note: if there is no Sales Ranking for the ASIN on Amazon, there will be no ranking in the report |
| product_group | The Amazon department or category for which the Sales Rank in the previous field is applicable |
| total_quantity | The number of Units you have for a SKU in sellable condition in our fulfillment network |
| sellable_quantity | The number of Units you have for a SKU in sellable condition in our fulfillment network |
| unsellable_quantity | The number of units you have for a SKU in unsellable condition in our fulfillment network |
| inv_age_0_to_90_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 0-90 days |
| inv_age_91_to_180_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 91 – 180 days |
| inv_age_181_to_270_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 181 – 270 days |
| inv_age_271_to_365_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 271 – 365 days |
| inv_age_365_plus_days | The number of sellable Units you have for a SKU that have been in the fulfillment center for the last 365+ days |
| units_shipped_last_24_hrs | Sales of this item in last 24 hours |
| units_shipped_last_7_days | Sales of this item in last 7 days |
| units_shipped_last_30_days | Sales of this item in last 30 days |
| units_shipped_last_90_days | Sales of this item in last 90 days |
| units_shipped_last_180_days | Sales of this item in last 180 days |
| units_shipped_last_365_days | Sales for this item in last 365 days |
| weeks_of_cover_t7 | Based on your sales in the last 7 days, the weeks of cover of sellable inventory that you have in the fulfillment centers. For example, if you sold 10 units in the last 7 days and had 20 Sellable units in Amazon fulfillment centers, you would have 2 weeks of cover |
| weeks_of_cover_t30 | Based on your sales in the last 30 days, the weeks of cover of sellable inventory that you have in the fulfillment center |
| weeks_of_cover_t90 | Based on your sales in the last 90 days, the weeks of cover of sellable inventory that you have in the fulfillment center |
| weeks_of_cover_t180 | Based on your sales in the last 180 days, the weeks of cover of sellable inventory that you have in the fulfillment center |
| weeks_of_cover_t365 | Based on your sales in the last 365 days, the weeks of cover of sellable inventory that you have in the fulfillment center |
| num_afn_new_sellers | The number of sellers with FBA offers that are in New condition |
| num_afn_used_sellers | The number of sellers with FBA offers that are in Used condition |
| currency | The currency of the removal fee |
| your_price | Your current selling price |
| sales_price | Your current promotional price |
| lowest_afn_new_price | The lowest fulfilled by Amazon price for items in New condition, including any offers from Amazon |
| lowest_afn_used_price | The lowest FBA price for items in Used condition |
| lowest_mfn_new_price | The lowest price for items in New condition that are fulfilled by a seller. This includes the seller’s shipping cost |
| lowest_mfn_used_price | The lowest price for items in Used condition that are fulfilled by a seller. This includes the seller’s shipping cost |
| qty_to_be_charged_ltsf_12_mo | The number of sellable units that will have been in the fulfillment center for more than 365 days as of the next LTSF charge date (monthly on the 15th in the US; February 15th and August 15th in Canada) |
| qty_in_long_term_storage_program | The number of sellable units that have previously been charged the Long-Term Storage Fee |
| qty_with_removals_in_progress | The number of Units in inventory that you have requested be removed |
| projected_ltsf_12_mo | The projected long-term storage fee that will be charged for units that have been in fulfillment centers for more than 365 days on the next LTSF charge date (monthly on the 15th in the US; February 15th and August 15th in Canada) |
| per_unit_volume | The volume in cubic footage of each inventory unit |
| is_hazmat | If your ASIN is considered Hazmat. Please see Hazardous Materials (Hazmat) to see if your products qualify |
| in_bound_quantity | In bound quantity |
| asin_limit | Your inventory limit for ASINs where we apply an inventory capacity limit. Please see ASIN Quantity Limits for more information |
| inbound_recommend_quantity | Inbound recommend quantity |
| qty_to_be_charged_ltsf_6_mo | The number of sellable units that will have been in the fulfillment center for 180 to 365 days and are eligible for the LTSF charge. As of February 2019, standard FBA units will not be charged 180-day LTSF. For example, FBA Small and Light fees are not affected by the February 2019 fee change. For more details, see the Program Fees section of FBA Small and Light |
| projected_ltsf_6_mo | The projected long-term storage fee that will be charged for eligible units that have been in fulfillment centers for 180 to 365 days on the next charge date. As of February 2019, standard FBA units will not be charged 180-day LTSF. For example, FBA Small and Light fees are not affected by the February 2019 fee change. For more details, see the Program Fees section of FBA Small and Light |
Current details of active (not archived) inventory
| Parameter | Description |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products |
| fnsku | Fulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers |
| asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page |
| product_name | The title of your product |
| condition | The condition of your product |
| your_price | Your current selling price |
| mfn_listing_exists | “Yes” indicates that the product is listed for fulfillment by you as the seller |
| mfn_fulfillable_quantity | The quantity in your fulfillment network that can be picked, packed, and shipped |
| afn_listing_exists | “Yes” indicates that the item is listed for Fulfillment by Amazon |
| afn_warehouse_quantity | The number of units you have for an SKU in Amazon fulfillment centers that have been processed: (afn-warehouse-quantity) = (afn-fulfillable-quantity) + (afn-unsellable-quantity) + (afn-reserved-quantity) |
| afn_fulfillable_quantity | The number of units you have for a SKU in Amazon fulfillment centers that can be picked, packed, and shipped |
| afn_unsellable_quantity | The number of units you have for a SKU in Amazon fulfillment centers in unsellable condition |
| afn_reserved_quantity | The number of units you have for a SKU in Amazon fulfillment centers that are currently being picked, packed, and shipped or are sidelined for measurement, sampling, or other internal processes |
| afn_total_quantity | The total number of units you have for a SKU in an inbound shipment or in Amazon fulfillment centers: (afn-total-quantity) = (afn-warehouse-quantity) + (afn-inbound-working-quantity) + (afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity) |
| per_unit_volume | The volume in cubic feet of one unit (to the nearest 1/100 of an inch) |
| afn_inbound_working_quantity | The number of units you have for a SKU in an inbound shipment that you have notified Amazon about |
| afn_inbound_shipped_quantity | The number of units you have for a SKU in an inbound shipment that you have notified Amazon about and provided a tracking number |
| afn_inbound_receiving_quantity | The number of units you have for a SKU that have not yet been received at an Amazon fulfillment center for processing, but are part of an inbound shipment with some units that have already been received and processed |
| afn_researching_quantity | Afn researching quantity |
| afn_reserved_future_supply | The number of units that customers have purchased while inventory is on its way to an Amazon fulfillment center through In-Stock Head Start |
| afn_future_supply_buyable | The number of units available for customers to find and buy while inventory is on its way to an Amazon fulfillment center through In-Stock Head Start |
| Parameter | Description |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| fulfillment_channel_sku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| asin | The Amazon Standard Identification Number of the item |
| condition_type | The condition of your inventory |
| country | Country in which your products are stored |
| quantity_for_local_fulfillment | Quantity for local fulfillment |
| Parameter | Description |
| shipment_date | Date the item shipped to the customer |
| currency | Local currency for the transaction |
| item_promotion_discount | Promotion value applied to this shipment item |
| item_promotion_id | Unique identifier for this promotion |
| description | Description of the promotion |
| promotion_rule_value | Maximum net value of the promotion |
| amazon_order_id | Order id of shipment to which the promotion was applied |
| shipment_id | Unique identifier for this item in this shipment |
| shipment_item_id | Unique identifier–pertains only to this item in this shipment |
| Parameter | Description |
| received_date | Date the receive process was completed for the shipment, DD-MON-YYYY |
| fnsku | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| product_name | The title of your product |
| quantity | The total number of units reimbursed for this line item |
| fba_shipment_id | Shipment ID in which the problem was identified |
| fulfillment_center_id | The fulfillment center where the problem is identified |
| Parameter | Description |
| snapshot_date | Report data are current as of the date in this field |
| sku | Stock keeping units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller |
| fnsku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify products. ASINs are assigned by Amazon. You can find the ASIN on the product detail page |
| product_name | The title of your product |
| condition | The condition of your product |
| sellable_quantity | The number of units you have for a SKU in sellable condition in our fulfillment network |
| sellable_271_365_days | The number of sellable units you have for a SKU that have been in the fulfillment center for the last 271 to 365 days |
| sellable_365__days | he number of sellable units you have for a SKU that have been in the fulfillment center for 365 days |
| sellable_removal_quantity | The number of sellable units you have for a SKU that will have been in the fulfillment center for 181 to 365 days or 365 days or more on the next Inventory Cleanup date and need to be removed (assuming no further sales) to avoid the long-term storage fee |
| unsellable_quantity | The number of unsellable units you have for a SKU in our fulfillment network |
| unsellable_0_7_days | The number of units that have been unsellable for zero to seven days |
| unsellable_8_60_days | The number of units that have been unsellable for eight to 60 days |
| unsellable_61_90_days | The number of units that have been unsellable for 61 to 90 days |
| sellable_121_180_days | The number of sellable units you have for a SKU that have been in the fulfillment center for the past 121 to 180 days |
| sellable_181_270_days | The number of sellable units you have for a SKU that have been in the fulfillment center for the past 181 to 270 days |
| Parameter | Description |
| approval_date | The date the reimbursement was approved |
| reimbursement_id | The unique identifier for this reimbursement. Each reimbursement may include multiple line items |
| case_id | The unique identifier assigned to the case when you request a reimbursement |
| amazon_order_id | The unique identifier assigned to the customer order. This field is empty if the reimbursement is not associated with an order |
| reason | The reason for the reimbursement (for example, Damaged: Warehouse) |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| fnsku | fnsku |
| asin | An ASIN (Amazon Standard Identification Numbers) is a unique identifier assigned by Amazon to products in the Amazon product catalog. The ASIN can be found on the product detail page |
| product_name | The title of your product |
| condition | The condition of your item (for example, New) |
| currency_unit | The currency for the applicable marketplace |
| amount_per_unit | The per-unit reimbursement amount for this line item |
| amount_total | The total amount of the cash reimbursement for this line item |
| quantity_reimbursed_cash | The total number of units reimbursed with cash |
| quantity_reimbursed_inventory | The number of units reimbursed with inventory |
| quantity_reimbursed_total | The total number of units reimbursed with either cash or inventory (Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]) |
| original_reimbursement_id | The number of units reimbursed with id |
| original_reimbursement_type | The number of units reimbursed with type |
| Parameter | Description |
| request_date | Date the removal order was submitted |
| last_updated_date | Date of the most recent order update |
| order_id | Amazon’s unique, displayable identifier for an order. This is an alphanumeric value. Go to Manage Orders to search for an order ID that includes letters, as they are not searchable in all tools |
| currency | Currency code for the marketplace, which is also the currency code for all prices listed in the records |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| cancelled_quantity | The total number of units of this FNSKU cancelled from the removal order |
| disposed_quantity | The total number of units for this FNSKU that were disposed of |
| disposition | The status of the unit |
| fnsku | Amazon’s Fulfillment network SKU identifier |
| in_process_quantity | The total number of units for this FNSKU that are in process |
| order_status | Removal order status |
| order_type | Removal order type (Return, Disposal) |
| removal_fee | The total removal fee for all the units of this FNSKU Note: If this cell is blank, no fee was found or the order is incomplete |
| requested_quantity | The number of units of this FNSKU requested in the removal order |
| shipped_quantity | The total number of units for this FNSKU that were shipped for this return |
| Parameter | Description |
| request_date | Date the removal order was submitted |
| shipment_date | Date of the shipment confirmation |
| order_id | Amazon’s unique, displayable identifier for an order. This is an alphanumeric value. Go to Manage Orders to search for an order ID that includes letters, as they are not searchable in all tools |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| carrier | The name of the carrier the package was shipped with. Multiple carriers may be used for a single removal order |
| disposition | The status of the unit |
| fnsku | Amazon’s Fulfillment network SKU identifier |
| removal_order_type | |
| shipped_quantity | The total number of units for this FNSKU that were shipped for this return |
| tracking_number | The carrier’s tracking number for the package, if available. Multiple tracking IDs may exist for a single removal order |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller |
| fnsku | Unique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center |
| asin | Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page |
| product_name | The title of your product |
| reserved_qty | The total number of units in reserved status |
| reserved_customerorders | The number of units reserved for customer orders |
| reserved_fc_transfers | The number of units being transferred from one fulfillment center to another |
| reserved_fc_processing | The number of units that have been sidelined at the fulfillment center for additional processing |
| Parameter | Description |
| return_date | Return date |
| order_id | Amazon”s unique identifying number for the order. Used for shipping confirmation and post-order processing |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| asin | The Amazon Standard Identification Number of the item |
| fnsku | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| product_name | The title of your product |
| quantity | The total number of units reimbursed for this line item |
| fulfillment_center_id | The fulfillment center where the problem is identified |
| detailed_disposition | Status of the product (examples: sellable, damaged) |
| reason | The reason for the reimbursement (for example, Damaged: Warehouse) |
| status | Current status of this item within the order |
| license_plate_number | License plate number |
| customer_comments | Customer comments |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| primary_action | Action needed to bring your inventory out of stranded status. The possible actions are: Relist: For products that have been listed previously but do not have an active offer, click Add a Product in the Inventory drop-down menu to create an offer. If you see a message indicating that your product is already listed but needs to be edited, click the provided link to update your listing. Create removal order: For products you no longer want to sell, go to the Manage FBA Inventory page, select the product, and choose Create Removal Order from the drop-down menu on top. Change to Fulfilled by Amazon: If you have an offer, but it is for a product that you fulfill yourself, none of your FBA inventory for that product will be available for sale. On your Manage Inventory page, select the product and click Change to Fulfilled by Amazon in the Action drop-down menu to enable FBA to pick, pack, and ship those products. Create a new listing: If you have FBA inventory of a product that has never been listed, create a listing for your SKU by clicking Add a Product in the Inventory drop-down menu. Note: When relisting a product or creating a listing, the following information must match the units in your FBA inventory: ASIN Condition Merchant SKU If these fields don’t match, the stranded inventory in the fulfillment center won’t be associated with the new listing |
| date_stranded | This date shows how long your inventory has been stranded and without an active offer |
| Date_to_take_auto_removal | Date to take auto removal |
| status_primary | Identifies whether the offer is active, inactive, or incomplete. Incomplete offers are those missing price or condition |
| status_secondary | For inactive offers, this field identifies the reasons – for example, blocked or out of stock |
| error_message | For select inactive offers, additional information is displayed here – for example, quality alerts |
| stranded_reason | Stranded reason |
| asin | The Amazon Standard Identification Number of the item |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller’s products. SKUs are assigned by the seller |
| fnsku | fnsku |
| product_name | The title of your product |
| condition | The condition of your product |
| fulfilled_by | The entity that fulfilled the item |
| fulfillable_qty | The number of units of a SKU that you have in Amazon fulfillment centers and that are in unsellable condition |
| your_price | Your current selling price |
| unfulfillable_qty | The number of units of a SKU that you have in Amazon fulfillment centers and that are in unsellable condition |
| reserved_quantity | The number of units of a SKU that you have in Amazon fulfillment centers and that are currently being picked, packed, and shipped or that are sidelined for measurement, sampling, or other internal processes |
| inbound_shipped_qty | The number of units of a SKU that you have shipped to Amazon and that are in transit |
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| featureDescription | The feature description |
| featureName | The feature name |
| sellerEligible | When true, indicates that the seller is eligible to use the feature |
| Parameter | Description |
| createdTime | The date and time when the feed was created, in ISO 8601 date time format |
| feedId | The identifier for the feed. This identifier is unique only in combination with a seller ID |
| feedType | The feed type |
| marketplaceIds | A list of identifiers for the marketplaces that the feed is applied to |
| processingEndTime | The date and time when feed processing completed, in ISO 8601 date time format |
| processingStartTime | The date and time when feed processing started, in ISO 8601 date time format |
| processingStatus | The processing status of the feed |
| resultFeedDocumentId | The identifier for the feed document. This identifier is unique only in combination with a seller ID |
Financial Events
| Parameter | Description |
| PostedDate | The date and time when the financial event was posted |
| EventName | |
| ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| AdjustmentAmount_CurrencyAmount | The monetary value |
| AdjustmentAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| AdjustmentType | The type of adjustment. Possible values: FBAInventoryReimbursement – An FBA inventory reimbursement to a seller’s account. This occurs if a seller’s inventory is damaged; ReserveEvent – A reserve event that is generated at the time of a settlement period closing. This occurs when some money from a seller’s account is held back; PostageBilling – The amount paid by a seller for shipping labels; PostageRefund – The reimbursement of shipping labels purchased for orders that were canceled or refunded; LostOrDamagedReimbursement – An Amazon Easy Ship reimbursement to a seller’s account for a package that we lost or damaged; CanceledButPickedUpReimbursement – An Amazon Easy Ship reimbursement to a seller’s account. This occurs when a package is picked up and the order is subsequently canceled. This value is used only in the India marketplace; ReimbursementClawback – An Amazon Easy Ship reimbursement clawback from a seller’s account. This occurs when a prior reimbursement is reversed. This value is used only in the India marketplace; SellerRewards – An award credited to a seller’s account for their participation in an offer in the Seller Rewards program. Applies only to the India marketplace; |
| AmazonOrderId | An Amazon-defined identifier for an order |
| AmountDescription | A short description of this payment event |
| BaseExpense_CurrencyAmount | The monetary value |
| BaseExpense_CurrencyCode | The three-digit currency code in ISO 4217 format |
| BaseTax_CurrencyAmount | The monetary value |
| BaseTax_CurrencyCode | The three-digit currency code in ISO 4217 format |
| BaseValue_CurrencyAmount | The monetary value |
| BaseValue_CurrencyCode | The three-digit currency code in ISO 4217 format |
| BusinessObjectType | The type of business object |
| ChargeComponent_ChargeAmount_CurrencyAmo… | |
| ChargeComponent_ChargeAmount_CurrencyCod… | |
| ChargeComponent_ChargeType | |
| Charge_ChargeAmount_CurrencyAmount | |
| Charge_ChargeAmount_CurrencyCode | |
| Charge_ChargeType | |
| ClipOrRedemptionCount | The number of coupon clips or redemptions |
| CouponId | A coupon identifier |
| DealDescription | The internal description of the deal |
| DealId | The unique identifier of the deal |
| DebtRecoveryType | The debt recovery type. Possible values: DebtPayment; DebtPaymentFailure; DebtAdjustment; |
| EnrollmentId | An enrollment identifier |
| EventType | The type of event: SellerDealComplete |
| ExtensionLength | The number of days that the buyer extended an already rented item. This value is only returned for RentalCustomerPayment-Extension and RentalCustomerRefund-Extension events |
| FeeAmount_CurrencyAmount | The monetary value |
| FeeAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| FeeComponent_FeeAmount_CurrencyAmount | The monetary value |
| FeeComponent_FeeAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| FeeComponent_FeeType | The type of fee. For more information about Selling on Amazon fees, see Selling on Amazon Fee Schedule on Seller Central. For more information about Fulfillment by Amazon fees, see FBA features, services and fees on Seller Central |
| FeeDescription | A short description of the service fee event |
| FeeReason | A short description of the service fee reason |
| FeeType | The type of fee: RunLightningDealFee |
| FnSKU | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| FulfillmentChannel | The fulfillment channel. Possible values: AFN – Amazon Fulfillment Network (Fulfillment by Amazon); MFN – Merchant Fulfillment Network (self-fulfilled); |
| ImagingRequestBillingItemID | The identifier for the imaging services request |
| InvoiceId | Identifier for the invoice that the transaction appears in |
| LiquidationFeeAmount_CurrencyAmount | The monetary value |
| LiquidationFeeAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| LiquidationProceedsAmount_CurrencyAmount | The monetary value |
| LiquidationProceedsAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| LoanAmount_CurrencyAmount | The monetary value |
| LoanAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| MarketplaceCountryCode | The two-letter country code of the country associated with the marketplace where the order was placed |
| MarketplaceId | An encrypted, Amazon-defined marketplace identifier |
| MarketplaceName | The name of the marketplace where the event occurred |
| NetCoTransactionID | The identifier for the network item swap |
| OriginalRemovalOrderId | The identifier for the original removal order |
| OverPaymentCredit_CurrencyAmount | The monetary value |
| OverPaymentCredit_CurrencyCode | The three-digit currency code in ISO 4217 format |
| ParentASIN | The Amazon Standard Identification Number (ASIN) of the item that was enrolled in the Early Reviewer Program |
| PaymentAmountType | The type of payment. Possible values: Sales; |
| PaymentEventId | A payment event identifier |
| ProviderId | The Amazon-defined identifier of the solution provider |
| ProviderStoreName | The store name where the payment event occurred |
| ProviderTransactionType | The transaction type |
| ReasonCode | Indicates why the seller was reimbursed |
| RecoveryAmount_CurrencyAmount | The monetary value |
| RecoveryAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| ReimbursedAmount_CurrencyAmount | The monetary value |
| ReimbursedAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| RentalEventType | The type of rental event. Possible values: RentalCustomerPayment-Buyout – Transaction type that represents when the customer wants to buy out a rented item; RentalCustomerPayment-Extension – Transaction type that represents when the customer wants to extend the rental period; RentalCustomerRefund-Buyout – Transaction type that represents when the customer requests a refund for the buyout of the rented item; RentalCustomerRefund-Extension – Transaction type that represents when the customer requests a refund over the extension on the rented item; RentalHandlingFee – Transaction type that represents the fee that Amazon charges sellers who rent through Amazon; RentalChargeFailureReimbursement – Transaction type that represents when Amazon sends money to the seller to compensate for a failed charge; RentalLostItemReimbursement – Transaction type that represents when Amazon sends money to the seller to compensate for a lost item; |
| RentalInitialValue_CurrencyAmount | The monetary value |
| RentalInitialValue_CurrencyCode | The three-digit currency code in ISO 4217 format |
| RentalReimbursement_CurrencyAmount | The monetary value |
| RentalReimbursement_CurrencyCode | The three-digit currency code in ISO 4217 format |
| RetrochargeEventType | The type of event. Possible values: Retrocharge; RetrochargeReversal; |
| SAFETClaimId | A SAFE-T claim identifier |
| SalesChannel | The sales channel for the transaction |
| SellerCouponDescription | The description provided by the seller when they created the coupon |
| SellerId | The Amazon-defined identifier of the seller |
| SellerOrderId | A seller-defined identifier for an order |
| SellerSKU | The seller SKU of the item. The seller SKU is qualified by the seller’s seller ID, which is included with every call to the Selling Partner API |
| SellerStoreName | The store name where the payment event occurred |
| ShippingTax_CurrencyAmount | The monetary value |
| ShippingTax_CurrencyCode | The three-digit currency code in ISO 4217 format |
| SourceBusinessEventType | The type of event. Possible values: LoanAdvance; LoanPayment; LoanRefund; |
| StoreName | The store name where the event occurred |
| SwapReason | The reason for the network item swap |
| TaxAmount_CurrencyAmount | The monetary value |
| TaxAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TaxExclusiveAmount_CurrencyAmount | The monetary value |
| TaxExclusiveAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TaxTypeCGST_CurrencyAmount | The monetary value |
| TaxTypeCGST_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TaxTypeIGST_CurrencyAmount | The monetary value |
| TaxTypeIGST_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TaxTypeSGST_CurrencyAmount | The monetary value |
| TaxTypeSGST_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TaxValue_CurrencyAmount | The monetary value |
| TaxValue_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TotalAmount_CurrencyAmount | The monetary value |
| TotalAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TotalExpense_CurrencyAmount | The monetary value |
| TotalExpense_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TransactionAmount_CurrencyAmount | The monetary value |
| TransactionAmount_CurrencyCode | The three-digit currency code in ISO 4217 format |
| TransactionCreationDate | The date and time that the credit transaction was created, in ISO 8601 date time format |
| TransactionPostedDate | The date and time when the payment transaction is posted. In ISO 8601 date time format |
| TransactionType | Indicates if the transaction is for a charge or a refund. Possible values: charge – Charge; refund – Refund; |
| TransactionValue_CurrencyAmount | The monetary value |
| TransactionValue_CurrencyCode | The three-digit currency code in ISO 4217 format |
| Parameter | Description |
| TraceId | The trace identifier used by sellers to look up transactions externally |
| AccountTail | The account tail of the payment instrument |
| BeginningBalance_CurrencyAmount | The monetary value |
| BeginningBalance_CurrencyCode | The three-digit currency code in ISO 4217 format |
| ConvertedTotal_CurrencyAmount | The monetary value |
| ConvertedTotal_CurrencyCode | The three-digit currency code in ISO 4217 format |
| FinancialEventGroupEnd | The date and time at which the financial event group is closed. In ISO 8601 date time format |
| FinancialEventGroupId | A unique identifier for the financial event group |
| FinancialEventGroupStart | The date and time at which the financial event group is opened. In ISO 8601 date time format |
| FundTransferDate | The date and time when the disbursement or charge was initiated. Only present for closed settlements. In ISO 8601 date time format |
| FundTransferStatus | The status of the fund transfer |
| OriginalTotal_CurrencyAmount | The monetary value |
| OriginalTotal_CurrencyCode | The three-digit currency code in ISO 4217 format |
| ProcessingStatus | The processing status of the financial event group indicates whether the balance of the financial event group is settled. Possible values: Open; Closed; |
| Parameter | Description |
| marketplaceId | The identifier for the marketplace the fulfillment order is placed against |
| displayableOrderId | A fulfillment order identifier submitted with the createFulfillmentOrder operation. Displays as the order identifier in recipient-facing materials such as the packing slip |
| deliveryWindow | The time range within which a Scheduled Delivery fulfillment order should be delivered |
| displayableOrderComment | A text block submitted with the createFulfillmentOrder operation. Displays in recipient-facing materials such as the packing slip |
| displayableOrderDate | A date and time submitted with the createFulfillmentOrder operation. Displays as the order date in recipient-facing materials such as the packing slip |
| featureConstraints | A list of features and their fulfillment policies to apply to the order |
| fulfillmentAction | Specifies whether the fulfillment order should ship now or have an order hold put on it |
| fulfillmentOrderStatus | The current status of the fulfillment order |
| fulfillmentPolicy | The FulfillmentPolicy value specified when you submitted the createFulfillmentOrder operation |
| notificationEmails | A list of email addresses that the seller provides that are used by Amazon to send ship-complete notifications to recipients on behalf of the seller |
| receivedDate | The date and time that the fulfillment order was received by an Amazon fulfillment center |
| sellerFulfillmentOrderId | The fulfillment order identifier submitted with the createFulfillmentOrder operation |
| shippingSpeedCategory | The shipping method used for the fulfillment order |
| statusUpdatedDate | The date and time that the status of the fulfillment order last changed, in ISO 8601 date time format |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| item_name | The item name |
| item_description | The item description |
| listing_id | The listing id |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| quantity | The total number of units reimbursed for this line item |
| open_date | Open date |
| image_url | The image url |
| item_is_marketplace | Item is marketplace |
| product_id_type | The product id type |
| zshop_shipping_fee | Zshop shipping fee |
| item_note | The item note |
| item_condition | Numeric entry that indicates the condition of the product. This field is required. Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines |
| zshop_category1 | Zshop category1 |
| zshop_browse_path | Zshop browse path |
| zshop_storefront_feature | Zshop storefront feature |
| asin1 | asin1 |
| asin2 | asin2 |
| asin3 | asin3 |
| will_ship_internationally | Will ship internationally |
| expedited_shipping | Expedited shipping |
| zshop_boldface | Zshop boldface |
| product_id | Product id |
| bid_for_featured_placement | Bid for featured placement |
| add_delete | Add delete |
| pending_quantity | Pending quantity |
| fulfillment_channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| merchant_shipping_group | Merchant shipping group |
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| ShipmentId | The shipment identifier submitted in the request |
| ShipmentName | The name for the inbound shipment |
| ShipmentStatus | Indicates the status of the inbound shipment. When used with the createInboundShipment operation, WORKING is the only valid value. When used with the updateInboundShipment operation, possible values are WORKING, SHIPPED or CANCELLED |
| AreCasesRequired | Indicates whether or not an inbound shipment contains case-packed boxes. When AreCasesRequired = true for an inbound shipment, all items in the inbound shipment must be case packed |
| BoxContentsSource | Where the seller provided box contents information for a shipment |
| ConfirmedNeedByDate | Date by which the shipment must arrive at the Amazon fulfillment center to avoid delivery promise breaks for pre-ordered items |
| DestinationFulfillmentCenterId | An Amazon fulfillment center identifier created by Amazon |
| EstimatedBoxContentsFee_FeePerUnit_Curre… | The currency code |
| EstimatedBoxContentsFee_FeePerUnit_Value | The amount |
| EstimatedBoxContentsFee_TotalFee_Currenc… | The currency code |
| EstimatedBoxContentsFee_TotalFee_Value | The amount |
| EstimatedBoxContentsFee_TotalUnits | The number of units to ship |
| LabelPrepType | The type of label preparation that is required for the inbound shipment |
| ShipFromAddress_AddressLine1 | The street address information |
| ShipFromAddress_AddressLine2 | Additional street address information, if required |
| ShipFromAddress_City | The city |
| ShipFromAddress_CountryCode | The country code in two-character ISO 3166-1 alpha-2 format |
| ShipFromAddress_DistrictOrCounty | The district or county |
| ShipFromAddress_Name | Name of the individual or business |
| ShipFromAddress_PostalCode | The postal code. If postal codes are used in your marketplace, we recommended that you include one with your request. This helps Amazon select the most appropriate Amazon fulfillment center for the inbound shipment plan |
| ShipFromAddress_StateOrProvinceCode | The state or province code. If state or province codes are used in your marketplace, it is recommended that you include one with your request. This helps Amazon to select the most appropriate Amazon fulfillment center for your inbound shipment plan |
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| featureName | The name of the feature |
| fnSku | The unique SKU used by Amazon’s fulfillment network |
| overlappingSkus | Other seller SKUs that are shared across the same inventory |
| sellerSku | Used to identify an item in the given marketplace. SellerSKU is qualified by the seller’s SellerId, which is included with every operation that you submit |
| skuCount | The number of SKUs available for this service |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller’s products. SKUs are assigned by the seller |
| asin | The Amazon Standard Identification Number of the item |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| quantity | The total number of units reimbursed for this line item |
| Business_Price | A special price that is available only for Amazon Business orders |
| Quantity_Price_Type | Quantity price type |
| Quantity_Lower_Bound_1 | Quantity lower bound |
| Quantity_Price_1 | Quantity price |
| Quantity_Lower_Bound_2 | Quantity lower bound |
| Quantity_Price_2 | Quantity price |
| Quantity_Lower_Bound_3 | Quantity lower bound |
| Quantity_Price_3 | Quantity price |
| Quantity_Lower_Bound_4 | Quantity lower bound |
| Quantity_Price_4 | Quantity price |
| Quantity_Lower_Bound_5 | Quantity lower bound |
| Quantity_Price_5 | Quantity price |
| Progressive_Price_Type | Progressive price type |
| Progressive_Lower_Bound_1 | Progressive lower bound |
| Progressive_Price_1 | Progressive price |
| Progressive_Lower_Bound_2 | Progressive lower bound |
| Progressive_Price_2 | Progressive price |
| Progressive_Lower_Bound_3 | Progressive lower bound |
| Progressive_Price_3 | Progressive price |
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| ASIN | The Amazon Standard Identification Number (ASIN) of an item |
| condition | The condition of the item as described by the seller (for example, New Item) |
| fnSku | Amazon’s fulfillment network SKU identifier |
| granularityId | The granularity ID for the specified granularity type. When granularityType is Marketplace, specify the marketplaceId |
| granularityType | The granularity type for the inventory aggregation level |
| inventoryDetails_fulfillableQuantity | The item quantity that can be picked, packed, and shipped |
| inventoryDetails_futureSupplyQuantity_fu… | The future item quantity that can be picked, packed, and shipped |
| inventoryDetails_futureSupplyQuantity_re… | The reserved item quantity that can be picked, packed, and shipped |
| inventoryDetails_inboundReceivingQuantit… | The number of units that have not yet been received at an Amazon fulfillment center for processing, but are part of an inbound shipment with some units that have already been received and processed |
| inventoryDetails_inboundShippedQuantity | The number of units in an inbound shipment that you have notified Amazon about and have provided a tracking number |
| inventoryDetails_inboundWorkingQuantity | The number of units in an inbound shipment for which you have notified Amazon |
| inventoryDetails_researchingQuantity_res… | A list of quantity details for items currently being researched |
| inventoryDetails_researchingQuantity_tot… | The total number of units currently being researched in Amazon’s fulfillment network |
| inventoryDetails_reservedQuantity_fcProc… | The number of units that have been sidelined at the fulfillment center for additional processing |
| inventoryDetails_reservedQuantity_pendin… | The number of units reserved for customer orders |
| inventoryDetails_reservedQuantity_pendin… | The number of units being transferred from one fulfillment center to another |
| inventoryDetails_reservedQuantity_totalR… | The total number of units in Amazon’s fulfillment network that are currently being picked, packed, and shipped; or are sidelined for measurement, sampling, or other internal processes |
| inventoryDetails_unfulfillableQuantity_c… | The number of units in carrier damaged disposition |
| inventoryDetails_unfulfillableQuantity_c… | The number of units in customer damaged disposition |
| inventoryDetails_unfulfillableQuantity_d… | The number of units in defective disposition |
| inventoryDetails_unfulfillableQuantity_d… | The number of units in distributor damaged disposition |
| inventoryDetails_unfulfillableQuantity_e… | The number of units in expired disposition |
| inventoryDetails_unfulfillableQuantity_t… | The total number of units in Amazon’s fulfillment network in unsellable condition |
| inventoryDetails_unfulfillableQuantity_w… | The number of units in warehouse damaged disposition |
| lastUpdatedTime | The date and time that any quantity was last updated |
| productName | The localized language product title of the item within the specific marketplace |
| sellerSku | The seller SKU of the item |
| totalQuantity | The total number of units in an inbound shipment or in Amazon fulfillment centers |
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| Identifiers_MarketplaceASIN_ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| Identifiers_MarketplaceASIN_MarketplaceI… | A marketplace identifier |
| Identifiers_SKUIdentifier_MarketplaceId | A marketplace identifier |
| Identifiers_SKUIdentifier_SellerId | The seller identifier submitted for the operation |
| Identifiers_SKUIdentifier_SellerSKU | The seller stock keeping unit (SKU) of the item |
| AttributeSets_Actor | The actor attributes of the item |
| AttributeSets_Artist | The artist attributes of the item |
| AttributeSets_AspectRatio | The aspect ratio attribute of the item |
| AttributeSets_AudienceRating | The audience rating attribute of the item |
| AttributeSets_Author | The author attributes of the item |
| AttributeSets_BackFinding | The back finding attribute of the item |
| AttributeSets_BandMaterialType | The band material type attribute of the item |
| AttributeSets_Binding | The binding attribute of the item |
| AttributeSets_BlurayRegion | The Bluray region attribute of the item |
| AttributeSets_Brand | The brand attribute of the item |
| AttributeSets_CeroAgeRating | The CERO age rating attribute of the item |
| AttributeSets_ChainType | The chain type attribute of the item |
| AttributeSets_ClaspType | The clasp type attribute of the item |
| AttributeSets_Color | The color attribute of the item |
| AttributeSets_CpuManufacturer | The CPU manufacturer attribute of the item |
| AttributeSets_CpuSpeed_Units | The unit of the decimal value |
| AttributeSets_CpuSpeed_value | The decimal value |
| AttributeSets_CpuType | The CPU type attribute of the item |
| AttributeSets_Department | The department attribute of the item |
| AttributeSets_Director | The director attributes of the item |
| AttributeSets_DisplaySize_Units | The unit of the decimal value |
| AttributeSets_DisplaySize_value | The decimal value |
| AttributeSets_Edition | The edition attribute of the item |
| AttributeSets_EpisodeSequence | The episode sequence attribute of the item |
| AttributeSets_EsrbAgeRating | The ESRB age rating attribute of the item |
| AttributeSets_Feature | The feature attributes of the item |
| AttributeSets_Flavor | The flavor attribute of the item |
| AttributeSets_Format | The format attributes of the item |
| AttributeSets_GemType | The gem type attributes of the item |
| AttributeSets_Genre | The genre attribute of the item |
| AttributeSets_GolfClubFlex | The golf club flex attribute of the item |
| AttributeSets_GolfClubLoft_Units | The unit of the decimal value |
| AttributeSets_GolfClubLoft_value | The decimal value |
| AttributeSets_HandOrientation | The hand orientation attribute of the item |
| AttributeSets_HardDiskInterface | The hard disk interface attribute of the item |
| AttributeSets_HardDiskSize_Units | The unit of the decimal value |
| AttributeSets_HardDiskSize_value | The decimal value |
| AttributeSets_HardwarePlatform | The hardware platform attribute of the item |
| AttributeSets_HazardousMaterialType | The hazardous material type attribute of the item |
| AttributeSets_IsAdultProduct | The adult product attribute of the item |
| AttributeSets_IsAutographed | The autographed attribute of the item |
| AttributeSets_IsEligibleForTradeIn | The is eligible for trade in attribute of the item |
| AttributeSets_IsMemorabilia | The is memorabilia attribute of the item |
| AttributeSets_IssuesPerYear | The issues per year attribute of the item |
| AttributeSets_ItemDimensions_Height_Unit… | The unit of the decimal value |
| AttributeSets_ItemDimensions_Height_valu… | The decimal value |
| AttributeSets_ItemDimensions_Length_Unit… | The unit of the decimal value |
| AttributeSets_ItemDimensions_Length_valu… | The decimal value |
| AttributeSets_ItemDimensions_Weight_Unit… | The unit of the decimal value |
| AttributeSets_ItemDimensions_Weight_valu… | The decimal value |
| AttributeSets_ItemDimensions_Width_Units | The unit of the decimal value |
| AttributeSets_ItemDimensions_Width_value | The decimal value |
| AttributeSets_ItemPartNumber | The item part number attribute of the item |
| AttributeSets_Label | The label attribute of the item |
| AttributeSets_LegalDisclaimer | The legal disclaimer attribute of the item |
| AttributeSets_ListPrice_Amount | The amount |
| AttributeSets_ListPrice_CurrencyCode | The currency code of the amount |
| AttributeSets_Manufacturer | The manufacturer attribute of the item |
| AttributeSets_ManufacturerMaximumAge_Uni… | The unit of the decimal value |
| AttributeSets_ManufacturerMaximumAge_val… | The decimal value |
| AttributeSets_ManufacturerMinimumAge_Uni… | The unit of the decimal value |
| AttributeSets_ManufacturerMinimumAge_val… | The decimal value |
| AttributeSets_ManufacturerPartsWarrantyD… | The manufacturer parts warranty description attribute of the item |
| AttributeSets_MaterialType | The material type attributes of the item |
| AttributeSets_MaximumResolution_Units | The unit of the decimal value |
| AttributeSets_MaximumResolution_value | The decimal value |
| AttributeSets_MediaType | The media type attributes of the item |
| AttributeSets_MetalStamp | The metal stamp attribute of the item |
| AttributeSets_MetalType | The metal type attribute of the item |
| AttributeSets_Model | The model attribute of the item |
| AttributeSets_NumberOfDiscs | The number of discs attribute of the item |
| AttributeSets_NumberOfIssues | The number of issues attribute of the item |
| AttributeSets_NumberOfItems | The number of items attribute of the item |
| AttributeSets_NumberOfPages | The number of pages attribute of the item |
| AttributeSets_NumberOfTracks | The number of tracks attribute of the item |
| AttributeSets_OperatingSystem | The operating system attributes of the item |
| AttributeSets_OpticalZoom_Units | The unit of the decimal value |
| AttributeSets_OpticalZoom_value | The decimal value |
| AttributeSets_PackageDimensions_Height_U… | The unit of the decimal value |
| AttributeSets_PackageDimensions_Height_v… | The decimal value |
| AttributeSets_PackageDimensions_Length_U… | The unit of the decimal value |
| AttributeSets_PackageDimensions_Length_v… | The decimal value |
| AttributeSets_PackageDimensions_Weight_U… | The unit of the decimal value |
| AttributeSets_PackageDimensions_Weight_v… | The decimal value |
| AttributeSets_PackageDimensions_Width_Un… | The unit of the decimal value |
| AttributeSets_PackageDimensions_Width_va… | The decimal value |
| AttributeSets_PackageQuantity | The package quantity attribute of the item |
| AttributeSets_PartNumber | The part number attribute of the item |
| AttributeSets_PegiRating | The PEGI rating attribute of the item |
| AttributeSets_Platform | The platform attributes of the item |
| AttributeSets_ProcessorCount | The processor count attribute of the item |
| AttributeSets_ProductGroup | The product group attribute of the item |
| AttributeSets_ProductTypeName | The product type name attribute of the item |
| AttributeSets_ProductTypeSubcategory | The product type subcategory attribute of the item |
| AttributeSets_PublicationDate | The publication date attribute of the item |
| AttributeSets_Publisher | The publisher attribute of the item |
| AttributeSets_RegionCode | The region code attribute of the item |
| AttributeSets_ReleaseDate | The release date attribute of the item |
| AttributeSets_RingSize | The ring size attribute of the item |
| AttributeSets_RunningTime_Units | The unit of the decimal value |
| AttributeSets_RunningTime_value | The decimal value |
| AttributeSets_Scent | The scent attribute of the item |
| AttributeSets_SeasonSequence | The season sequence attribute of the item |
| AttributeSets_SeikodoProductCode | The Seikodo product code attribute of the item |
| AttributeSets_ShaftMaterial | The shaft material attribute of the item |
| AttributeSets_Size | The size attribute of the item |
| AttributeSets_SizePerPearl | The size per pearl attribute of the item |
| AttributeSets_SmallImage_Height_Units | The unit of the decimal value |
| AttributeSets_SmallImage_Height_value | The decimal value |
| AttributeSets_SmallImage_URL | The image URL attribute of the item |
| AttributeSets_SmallImage_Width_Units | The unit of the decimal value |
| AttributeSets_SmallImage_Width_value | The decimal value |
| AttributeSets_Studio | The studio attribute of the item |
| AttributeSets_SubscriptionLength_Units | The unit of the decimal value |
| AttributeSets_SubscriptionLength_value | The decimal value |
| AttributeSets_SystemMemorySize_Units | The unit of the decimal value |
| AttributeSets_SystemMemorySize_value | The decimal value |
| AttributeSets_SystemMemoryType | The system memory type attribute of the item |
| AttributeSets_TheatricalReleaseDate | The theatrical release date attribute of the item |
| AttributeSets_Title | The title attribute of the item |
| AttributeSets_TotalDiamondWeight_Units | The unit of the decimal value |
| AttributeSets_TotalDiamondWeight_value | The decimal value |
| AttributeSets_TotalGemWeight_Units | The unit of the decimal value |
| AttributeSets_TotalGemWeight_value | The decimal value |
| AttributeSets_Warranty | The warranty attribute of the item |
| AttributeSets_WeeeTaxValue_Amount | The amount |
| AttributeSets_WeeeTaxValue_CurrencyCode | The currency code of the amount |
| Creator | The creator attributes of the item |
| Languages | The languages attribute of the item |
| Parameter | Description |
| marketplaceId | Amazon marketplace identifier |
| sellerId | A selling partner identifier, such as a merchant account or vendor code |
| asin | Amazon Standard Identification Number (ASIN) of the listings item |
| sku | A selling partner provided identifier for an Amazon listing |
| conditionType | Identifies the condition of the listings item |
| fnSku | Fulfillment network stock keeping unit is an identifier used by Amazon fulfillment centers to identify each unique item |
| itemName | Name, or title, associated with an Amazon catalog item |
| mainImage_height | Height of the image in pixels |
| mainImage_link | Link, or URL, for the image |
| mainImage_width | Width of the image in pixels |
| productType | The Amazon product type of the listings item |
| status | Statuses that apply to the listings item |
| createdDate | Date the listings item was created, in ISO 8601 format |
| lastUpdatedDate | Date the listings item was last updated, in ISO 8601 format |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| sku | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller’s products. SKUs are assigned by the seller |
| product_name | The title of your product |
| asin | The Amazon Standard Identification Number of the item |
| field_name | Field name |
| alert_type | Alert type |
| current_value | Current value |
| last_updated | Last updated |
| alert_name | Alert name |
| status | Current status of this item within the order |
| explanation | Explanation |
| Parameter | Description |
| asin | The Amazon Standard Identification Number (ASIN) of the item |
| marketplaceId | A marketplace identifier. Identifies the Amazon marketplace where the restriction is enforced |
| conditionType | The condition that applies to the restriction |
| message | A message describing the reason for the restriction |
| reasonCode | A code indicating why the listing is restricted |
| Parameter | Description |
| MarketplaceId | A marketplace identifier |
| ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| ItemCondition | The condition of the item |
| Offers_IsBuyBoxWinner | When true, the offer is currently in the Buy Box. There can be up to two Buy Box winners at any time per ASIN, one that is eligible for Prime and one that is not eligible for Prime |
| Offers_IsFeaturedMerchant | When true, the seller of the item is eligible to win the Buy Box |
| Offers_IsFulfilledByAmazon | When true, the offer is fulfilled by Amazon |
| Offers_ListingPrice_Amount | The monetary value |
| Offers_ListingPrice_CurrencyCode | The currency code in ISO 4217 format |
| Offers_MyOffer | When true, this is the seller’s offer |
| Offers_offerType | Indicates the type of customer that the offer is valid for |
| Offers_Points_PointsMonetaryValue_Amount | The monetary value |
| Offers_Points_PointsMonetaryValue_Curren… | The currency code in ISO 4217 format |
| Offers_Points_PointsNumber | The number of points |
| Offers_PrimeInformation_IsNationalPrime | Indicates whether the offer is an Amazon Prime offer throughout the entire marketplace where it is listed |
| Offers_PrimeInformation_IsPrime | Indicates whether the offer is an Amazon Prime offer |
| Offers_QuantityDiscountPrices_ListingPri… | The monetary value |
| Offers_QuantityDiscountPrices_ListingPri… | The currency code in ISO 4217 format |
| Offers_QuantityDiscountPrices_price_Amou… | The monetary value |
| Offers_QuantityDiscountPrices_price_Curr… | The currency code in ISO 4217 format |
| Offers_QuantityDiscountPrices_quantityDi… | Indicates the type of quantity discount this price applies to |
| Offers_QuantityDiscountPrices_quantityTi… | Indicates at what quantity this price becomes active |
| Offers_SellerFeedbackRating_FeedbackCoun… | The number of ratings received about the seller |
| Offers_SellerFeedbackRating_SellerPositi… | The percentage of positive feedback for the seller in the past 365 days |
| Offers_SellerId | The seller identifier for the offer |
| Offers_Shipping_Amount | The monetary value |
| Offers_Shipping_CurrencyCode | The currency code in ISO 4217 format |
| Offers_ShippingTime_availabilityType | Indicates whether the item is available for shipping now, or on a known or an unknown date in the future. If known, the availableDate property indicates the date that the item will be available for shipping. Possible values: NOW, FUTURE_WITHOUT_DATE, FUTURE_WITH_DATE |
| Offers_ShippingTime_availableDate | The date when the item will be available for shipping. Only displayed for items that are not currently available for shipping |
| Offers_ShippingTime_maximumHours | The maximum time, in hours, that the item will likely be shipped after the order has been placed |
| Offers_ShippingTime_minimumHours | The minimum time, in hours, that the item will likely be shipped after the order has been placed |
| Offers_ShipsFrom_Country | The country from where the item is shipped |
| Offers_ShipsFrom_State | The state from where the item is shipped |
| Offers_SubCondition | The subcondition of the item. Subcondition values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, or Other |
| status | The status of the operation |
| Summary_BuyBoxEligibleOffers | A list that contains the total number of offers that are eligible for the Buy Box for the given conditions and fulfillment channels |
| Summary_NumberOfOffers | A list that contains the total number of offers for the item for the given conditions and fulfillment channels |
| Summary_SalesRankings | A list of sales rank information for the item, by category |
| Summary_TotalOfferCount | The number of unique offers contained in NumberOfOffers |
| Parameter | Description |
| MarketplaceId | A marketplace identifier |
| ItemCondition | The condition of the item |
| Offers_IsBuyBoxWinner | When true, the offer is currently in the Buy Box. There can be up to two Buy Box winners at any time per ASIN, one that is eligible for Prime and one that is not eligible for Prime |
| Offers_IsFeaturedMerchant | When true, the seller of the item is eligible to win the Buy Box |
| Offers_IsFulfilledByAmazon | When true, the offer is fulfilled by Amazon |
| Offers_ListingPrice_Amount | The monetary value |
| Offers_ListingPrice_CurrencyCode | The currency code in ISO 4217 format |
| Offers_MyOffer | When true, this is the seller’s offer |
| Offers_offerType | Indicates the type of customer that the offer is valid for |
| Offers_Points_PointsMonetaryValue_Amount | The monetary value |
| Offers_Points_PointsMonetaryValue_Curren… | The currency code in ISO 4217 format |
| Offers_Points_PointsNumber | The number of points |
| Offers_PrimeInformation_IsNationalPrime | Indicates whether the offer is an Amazon Prime offer throughout the entire marketplace where it is listed |
| Offers_PrimeInformation_IsPrime | Indicates whether the offer is an Amazon Prime offer |
| Offers_QuantityDiscountPrices_ListingPri… | The monetary value |
| Offers_QuantityDiscountPrices_ListingPri… | The currency code in ISO 4217 format |
| Offers_QuantityDiscountPrices_price_Amou… | The monetary value |
| Offers_QuantityDiscountPrices_price_Curr… | The currency code in ISO 4217 format |
| Offers_QuantityDiscountPrices_quantityDi… | Indicates the type of quantity discount this price applies to |
| Offers_QuantityDiscountPrices_quantityTi… | Indicates at what quantity this price becomes active |
| Offers_SellerFeedbackRating_FeedbackCoun… | The number of ratings received about the seller |
| Offers_SellerFeedbackRating_SellerPositi… | The percentage of positive feedback for the seller in the past 365 days |
| Offers_SellerId | The seller identifier for the offer |
| Offers_Shipping_Amount | The monetary value |
| Offers_Shipping_CurrencyCode | The currency code in ISO 4217 format |
| Offers_ShippingTime_availabilityType | Indicates whether the item is available for shipping now, or on a known or an unknown date in the future. If known, the availableDate property indicates the date that the item will be available for shipping. Possible values: NOW, FUTURE_WITHOUT_DATE, FUTURE_WITH_DATE |
| Offers_ShippingTime_availableDate | The date when the item will be available for shipping. Only displayed for items that are not currently available for shipping |
| Offers_ShippingTime_maximumHours | The maximum time, in hours, that the item will likely be shipped after the order has been placed |
| Offers_ShippingTime_minimumHours | The minimum time, in hours, that the item will likely be shipped after the order has been placed |
| Offers_ShipsFrom_Country | The country from where the item is shipped |
| Offers_ShipsFrom_State | The state from where the item is shipped |
| Offers_SubCondition | The subcondition of the item. Subcondition values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, or Other |
| SKU | The stock keeping unit (SKU) of the item |
| status | The status of the operation |
| Summary_BuyBoxEligibleOffers | A list that contains the total number of offers that are eligible for the Buy Box for the given conditions and fulfillment channels |
| Summary_NumberOfOffers | A list that contains the total number of offers for the item for the given conditions and fulfillment channels |
| Summary_SalesRankings | A list of sales rank information for the item, by category |
| Summary_TotalOfferCount | The number of unique offers contained in NumberOfOffers |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| item_name | The item name |
| item_description | The item description |
| listing_id | The listing id |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| quantity | The total number of units reimbursed for this line item |
| open_date | Open date |
| image_url | The image url |
| item_is_marketplace | Item is marketplace |
| product_id_type | The type of product id |
| zshop_shipping_fee | Zshop shipping fee |
| item_note | The item note |
| item_condition | Numeric entry that indicates the condition of the product. This field is required. Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines |
| zshop_category1 | Zshop category1 |
| zshop_browse_path | Zshop browse path |
| zshop_storefront_feature | Zshop storefront feature |
| asin1 | Asin1 |
| asin2 | Asin2 |
| asin3 | Asin3 |
| will_ship_internationally | Will ship internationally |
| expedited_shipping | Expedited shipping |
| zshop_boldface | Zshop boldface |
| product_id | Product id |
| bid_for_featured_placement | Bid for featured placement |
| add_delete | Add delete |
| pending_quantity | Pending quantity |
| fulfillment_channel | Fulfillment channel |
| Business_Price | A special price that is available only for Amazon Business orders |
| Quantity_Price_Type | Quantity price type |
| Quantity_Lower_Bound_1 | Quantity lower bound |
| Quantity_Price_1 | Quantity price |
| Quantity_Lower_Bound_2 | Quantity lower bound |
| Quantity_Price_2 | Quantity price |
| Quantity_Lower_Bound_3 | Quantity lower bound |
| Quantity_Price_3 | Quantity price |
| Quantity_Lower_Bound_4 | Quantity lower bound |
| Quantity_Price_4 | Quantity price |
| Quantity_Lower_Bound_5 | Quantity lower bound |
| Quantity_Price_5 | Quantity price |
| merchant_shipping_group | Merchant shipping group |
| Progressive_Price_Type | Progressive price type |
| Progressive_Lower_Bound_1 | Progressive lower bound |
| Progressive_Price_1 | Progressive price |
| Progressive_Lower_Bound_2 | Progressive lower bound |
| Progressive_Price_2 | Progressive price |
| Progressive_Lower_Bound_3 | Progressive lower bound |
| Progressive_Price_3 | Progressive price |
| Minimum_order_quantity | Minimum order quantity |
| Sell_remainder | Sell remainder |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| quantity | The total number of units reimbursed for this line item |
| price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| product_id | |
| Business_Price | A special price that is available only for Amazon Business orders |
| Quantity_Price_Type | Quantity price type |
| Quantity_Lower_Bound_1 | Quantity lower bound |
| Quantity_Price_1 | Quantity price |
| Quantity_Lower_Bound_2 | Quantity lower bound |
| Quantity_Price_2 | Quantity price |
| Quantity_Lower_Bound_3 | Quantity lower bound |
| Quantity_Price_3 | Quantity price |
| Quantity_Lower_Bound_4 | Quantity lower bound |
| Quantity_Price_4 | Quantity price |
| Quantity_Lower_Bound_5 | Quantity lower bound |
| Quantity_Price_5 | Quantity price |
| Progressive_Price_Type | Progressive price type |
| Progressive_Lower_Bound_1 | Progressive lower bound |
| Progressive_Price_1 | Progressive price |
| Progressive_Lower_Bound_2 | Progressive lower bound |
| Progressive_Price_2 | Progressive price |
| Progressive_Lower_Bound_3 | Progressive lower bound |
| Progressive_Price_3 | Progressive price |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| seller_sku | Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller |
| quantity | The total number of units reimbursed for this line item |
| Parameter | Description |
| AmazonOrderId | An Amazon-defined order identifier, in 3-7-7 format |
| AssignedShipFromLocationAddress_AddressL… | The street address |
| AssignedShipFromLocationAddress_AddressL… | Additional street address information, if required |
| AssignedShipFromLocationAddress_AddressL… | Additional street address information, if required |
| AssignedShipFromLocationAddress_AddressT… | The address type of the shipping address |
| AssignedShipFromLocationAddress_City | The city |
| AssignedShipFromLocationAddress_CountryC… | The country code. A two-character country code, in ISO 3166-1 alpha-2 format |
| AssignedShipFromLocationAddress_County | The county |
| AssignedShipFromLocationAddress_District | The district |
| AssignedShipFromLocationAddress_Municipa… | The municipality |
| AssignedShipFromLocationAddress_Name | The name |
| AssignedShipFromLocationAddress_Phone | The phone number. Not returned for Fulfillment by Amazon (FBA) orders |
| AssignedShipFromLocationAddress_PostalCo… | The postal code |
| AssignedShipFromLocationAddress_StateOrR… | The state or region |
| CbaDisplayableShippingLabel | Custom ship label for Checkout by Amazon (CBA) |
| EarliestDeliveryDate | The start of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders |
| EarliestShipDate | The start of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders. Note: EarliestShipDate might not be returned for orders placed before February 1, 2013 |
| EasyShipShipmentStatus | The status of the Amazon Easy Ship order. This property is included only for Amazon Easy Ship orders. Possible values: PendingPickUp, LabelCanceled, PickedUp, OutForDelivery, Damaged, Delivered, RejectedByBuyer, Undeliverable, ReturnedToSeller, ReturningToSeller |
| FulfillmentChannel | Whether the order was fulfilled by Amazon (AFN) or by the seller (MFN) |
| FulfillmentInstruction_FulfillmentSupply… | Denotes the recommended sourceId where the order should be fulfilled from |
| IsBusinessOrder | When true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer |
| IsEstimatedShipDateSet | When true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders |
| IsGlobalExpressEnabled | When true, the order is a GlobalExpress order |
| IsPremiumOrder | When true, the order has a Premium Shipping Service Level Agreement. For more information about Premium Shipping orders, see “Premium Shipping Options” in the Seller Central Help for your marketplace |
| IsPrime | When true, the order is a seller-fulfilled Amazon Prime order |
| IsReplacementOrder | When true, this is a replacement order |
| IsSoldByAB | When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU). By buying and instantly re-selling your items, ABEU becomes the seller of record, making your inventory available for sale to customers who would not otherwise purchase from a third-party seller |
| LastUpdateDate | The date when the order was last updated. Note: LastUpdateDate is returned with an incorrect date for orders that were last updated before 2009-04-01 |
| LatestDeliveryDate | The end of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders that do not have a PendingAvailability, Pending, or Canceled status |
| LatestShipDate | The end of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders. Note: LatestShipDate might not be returned for orders placed before February 1, 2013 |
| MarketplaceId | The identifier for the marketplace where the order was placed |
| NumberOfItemsShipped | The number of items shipped |
| NumberOfItemsUnshipped | The number of items unshipped |
| OrderChannel | The order channel of the first item in the order |
| OrderStatus | The current order status |
| OrderTotal_Amount | The currency amount |
| OrderTotal_CurrencyCode | The three-digit currency code. In ISO 4217 format |
| OrderType | The type of the order |
| PaymentMethod | The payment method for the order. This property is limited to Cash On Delivery (COD) and Convenience Store (CVS) payment methods. Unless you need the specific COD payment information provided by the PaymentExecutionDetailItem object, we recommend using the PaymentMethodDetails property to get payment method information |
| PaymentMethodDetails | A list of payment methods for the order |
| PromiseResponseDueDate | Indicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders |
| PurchaseDate | The date when the order was created |
| ReplacedOrderId | The order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true |
| SalesChannel | The sales channel of the first item in the order |
| SellerOrderId | A seller-defined order identifier |
| ShipServiceLevel | The shipment service level of the order |
| ShipmentServiceLevelCategory | The shipment service level category of the order. Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard |
Order data delivered by the fast reporting API, less detail than slow orders API
| Parameter | Description |
| AmazonOrderID | Amazon Order ID |
| MerchantOrderID | Merchant Order ID |
| PurchaseDate | Purchase Date |
| LastUpdatedDate | Last Updated Date |
| OrderStatus | Order Status |
| SalesChannel | Sales Channel |
| FulfillmentData_FulfillmentChannel | Fulfillment Channe lD |
| FulfillmentData_ShipServiceLevel | Fulfillment Data: Address City |
| FulfillmentData_Address_Country | Fulfillment Data: Address Country |
| FulfillmentData_Address_State | Fulfillment Data: Address State |
| FulfillmentData_Address_PostalCode | FulfillmentData Address PostalCode |
| FulfillmentData_Address_City | Fulfillment Data: Address City |
| IsBusinessOrder | Is Business Order |
| Parameter | Description |
| AmazonOrderID | Amazon Order ID |
| MerchantOrderID | Merchant Order ID |
| PurchaseDate | Purchase Date |
| LastUpdatedDate | Last Updated Date |
| OrderStatus | Order Status |
| SalesChannel | Sales Channel |
| FulfillmentData_FulfillmentChannel | Fulfillment Channe lD |
| FulfillmentData_ShipServiceLevel | Fulfillment Data: Address City |
| FulfillmentData_Address_Country | Fulfillment Data: Address Country |
| FulfillmentData_Address_State | Fulfillment Data: Address State |
| FulfillmentData_Address_PostalCode | FulfillmentData Address PostalCode |
| FulfillmentData_Address_City | Fulfillment Data: Address City |
| IsBusinessOrder | Is Business Order |
| Parameter | Description |
| amazon_order_id | Amazon”s unique, displayable identifier for an order |
| merchant_order_id | A unique identifier optionally supplied for the order by the Merchant |
| purchase_date | The date the order was placed |
| last_updated_date | The date of the most recent order update |
| order_status | Current status of the customer order |
| fulfillment_channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| sales_channel | Channel through which the order was purchased |
| order_channel | The sub channel through which a sale was made for CBA/WBA orders |
| ship_service_level | An enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., standard versus expedited) |
| product_name | The short title for the product, displayed in bold on the detail web page and in the title bar of the browser window |
| sku | A merchant-defined unique identifier for a product |
| asin | Amazon inventory ID |
| item_status | Current status of this item within the order |
| quantity | The number of this item that were purchased |
| currency | The currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY |
| item_price | The amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price |
| item_tax | The amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price |
| shipping_price | The amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price |
| shipping_tax | The amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price |
| gift_wrap_price | The amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price |
| gift_wrap_tax | The amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price |
| item_promotion_discount | Total of all promotion discounts applied to the order item |
| ship_promotion_discount | Promotion discount applied to shipping |
| ship_city | The city of a standard address |
| ship_state | The state or region of a standard address |
| ship_postal_code | The postal (zip) code of a standard address |
| ship_country | ISO 3166 standard two-letter country code |
| promotion_ids | List of all item promotions applied to this order item |
| is_business_order | Is business order |
| purchase_order_number | |
| price_designation |
| Parameter | Description |
| MarketplaceId | The identifier for the marketplace |
| interval_start | The interval of time based on requested granularity (ex. Hour, Day, etc.) If this is the first or the last interval from the list, it might contain incomplete data if the requested interval doesn’t align with the requested granularity (ex. request interval 2018-09-01T02:00:00Z–2018-09-04T19:00:00Z and granularity day will result in Sept 1st UTC day and Sept 4th UTC days having partial data) |
| interval_end | The interval of time based on requested granularity (ex. Hour, Day, etc.) If this is the first or the last interval from the list, it might contain incomplete data if the requested interval doesn’t align with the requested granularity (ex. request interval 2018-09-01T02:00:00Z–2018-09-04T19:00:00Z and granularity day will result in Sept 1st UTC day and Sept 4th UTC days having partial data) |
| averageUnitPrice_amount | The currency amount |
| averageUnitPrice_CurrencyCode | Three-digit currency code. In ISO 4217 format |
| orderCount | The number of orders based on the specified filters |
| orderItemCount | The number of order items based on the specified filters |
| totalSales_amount | The currency amount |
| totalSales_CurrencyCode | Three-digit currency code. In ISO 4217 format |
| unitCount | The number of units in orders based on the specified filters |
| Parameter | Description |
| amazon_order_id | Amazon”s unique, displayable identifier for an order |
| merchant_order_id | A unique identifier optionally supplied for the order by the Merchant |
| purchase_date | The date the order was placed |
| last_updated_date | The date of the most recent order update |
| order_status | Current status of the customer order |
| fulfillment_channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| sales_channel | Channel through which the order was purchased |
| order_channel | The sub channel through which a sale was made for CBA/WBA orders |
| ship_service_level | An enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., standard versus expedited) |
| product_name | The short title for the product, displayed in bold on the detail web page and in the title bar of the browser window |
| sku | A merchant-defined unique identifier for a product |
| asin | Amazon inventory ID |
| item_status | Current status of this item within the order |
| quantity | The number of this item that were purchased |
| currency | The currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY |
| item_price | The amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price |
| item_tax | The amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price |
| shipping_price | The amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price |
| shipping_tax | The amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price |
| gift_wrap_price | The amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price |
| gift_wrap_tax | The amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price |
| item_promotion_discount | Total of all promotion discounts applied to the order item |
| ship_promotion_discount | Promotion discount applied to shipping |
| ship_city | The city of a standard address |
| ship_state | The state or region of a standard address |
| ship_postal_code | The postal (zip) code of a standard address |
| ship_country | ISO 3166 standard two-letter country code |
| promotion_ids | List of all item promotions applied to this order item |
| is_business_order | Is business order |
| purchase_order_number | Purchase order number |
| price_designation | Price designation |
| Parameter | Description |
| amazon_order_id | Amazon”s unique, displayable identifier for an order |
| merchant_order_id | A unique identifier optionally supplied for the order by the Merchant |
| purchase_date | The date the order was placed |
| last_updated_date | The date of the most recent order update |
| order_status | Current status of the customer order |
| fulfillment_channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| sales_channel | Channel through which the order was purchased |
| order_channel | The sub channel through which a sale was made for CBA/WBA orders |
| ship_service_level | An enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., standard versus expedited) |
| product_name | The short title for the product, displayed in bold on the detail web page and in the title bar of the browser window |
| sku | A merchant-defined unique identifier for a product |
| asin | Amazon inventory ID |
| item_status | Current status of this item within the order |
| quantity | The number of this item that were purchased |
| currency | The currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY |
| item_price | The amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price |
| item_tax | The amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price |
| shipping_price | The amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price |
| shipping_tax | The amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price |
| gift_wrap_price | The amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price |
| gift_wrap_tax | The amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price |
| item_promotion_discount | Total of all promotion discounts applied to the order item |
| ship_promotion_discount | Promotion discount applied to shipping |
| ship_city | The city of a standard address |
| ship_state | The state or region of a standard address |
| ship_postal_code | The postal (zip) code of a standard address |
| ship_country | ISO 3166 standard two-letter country code |
| promotion_ids | List of all item promotions applied to this order item |
| is_business_order | Is business order |
| purchase_order_number | Purchase order number |
| price_designation | Price designation |
| Parameter | Description |
| marketplaceId | The identifier of the marketplace |
| ProductCategoryId | The identifier for the product category (or browse node) |
| ProductCategoryName | The name of the product category (or browse node) |
| parent | The parent product category |
| Parameter | Description |
| marketplaceId | The identifier of the marketplace |
| ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| Product_Identifiers_MarketplaceASIN_ASIN | The Amazon Standard Identification Number (ASIN) of the item |
| Product_Identifiers_MarketplaceASIN_Mark… | A marketplace identifier |
| Product_Identifiers_SKUIdentifier_Market… | A marketplace identifier |
| Product_Identifiers_SKUIdentifier_Seller… | The seller identifier submitted for the operation |
| Product_Identifiers_SKUIdentifier_Seller… | The seller stock keeping unit (SKU) of the item |
| Product_Offers_BuyingPrice_LandedPrice_A… | The monetary value |
| Product_Offers_BuyingPrice_LandedPrice_C… | The currency code in ISO 4217 format |
| Product_Offers_BuyingPrice_ListingPrice_… | The monetary value |
| Product_Offers_BuyingPrice_ListingPrice_… | The currency code in ISO 4217 format |
| Product_Offers_BuyingPrice_Points_Points… | |
| Product_Offers_BuyingPrice_Points_Points… | |
| Product_Offers_BuyingPrice_Points_Points… | The number of points |
| Product_Offers_BuyingPrice_Shipping_Amou… | The monetary value |
| Product_Offers_BuyingPrice_Shipping_Curr… | The currency code in ISO 4217 format |
| Product_Offers_FulfillmentChannel | The fulfillment channel for the offer listing. Possible values: Amazon – Fulfilled by Amazon; Merchant – Fulfilled by the seller; |
| Product_Offers_ItemCondition | The item condition for the offer listing. Possible values: New, Used, Collectible, Refurbished, or Club |
| Product_Offers_ItemSubCondition | The item subcondition for the offer listing. Possible values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, or Other |
| Product_Offers_RegularPrice_Amount | The monetary value |
| Product_Offers_RegularPrice_CurrencyCode | The currency code in ISO 4217 format |
| Product_Offers_SellerSKU | The seller stock keeping unit (SKU) of the item |
| status | The status of the operation |
| Parameter | Description |
| AmazonOrderID | Amazon Order ID |
| MerchantOrderID | Merchant Order ID |
| PurchaseDate | Purchase Date |
| LastUpdatedDate | Last Updated Date |
| OrderStatus | Order Status |
| SalesChannel | Sales Channel |
| FulfillmentData_FulfillmentChannel | Fulfillment Channe lD |
| FulfillmentData_ShipServiceLevel | Fulfillment Data: Address City |
| FulfillmentData_Address_Country | Fulfillment Data: Address Country |
| FulfillmentData_Address_State | Fulfillment Data: Address State |
| FulfillmentData_Address_PostalCode | FulfillmentData Address PostalCode |
| FulfillmentData_Address_City | Fulfillment Data: Address City |
| IsBusinessOrder | Is Business Order |
| Parameter | Description |
| reportId | The identifier for the report. This identifier is unique only in combination with a seller ID |
| reportDocumentId | The identifier for the report document. Pass this into the getReportDocument operation to get the information you will need to retrieve and decrypt the report document’s contents |
| reportType | The report type |
| reportScheduleId | The identifier of the report schedule that created this report (if any). This identifier is unique only in combination with a seller ID |
| createdTime | The date and time when the report was created |
| dataStartTime | The start of a date and time range used for selecting the data to report |
| dataEndTime | The end of a date and time range used for selecting the data to report |
| marketplaceIds | A list of marketplace identifiers used to filter reports. The reports returned will match at least one of the marketplaces that you specify. Min count : 1 Max count : 10 |
| processingStartTime | The date and time when the report processing started, in ISO 8601 date time format |
| processingEndTime | The date and time when the report processing completed, in ISO 8601 date time format |
| processingStatus | The processing status of the report |
Recommendations on products to restock
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| Country | Country in which your products are stored |
| Product_Name | Product Name |
| FNSKU | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| Merchant_SKU | Merchant SKU |
| ASIN | The Amazon Standard Identification Number of the item |
| Condition | The condition of your product |
| Supplier | Supplier |
| Supplier_part_no_ | Supplier part no |
| Currency_code | Currency code |
| Price | Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon |
| Sales_last_30_days | Sales last 30 days |
| Units_Sold_Last_30_Days | Units Sold Last 30 Days |
| Total_Units | Total Units |
| Inbound | Inbound |
| Available | Available |
| FC_transfer | FC transfer |
| FC_Processing | FC Processing |
| Customer_Order | Customer Order |
| Unfulfillable | Unfulfillable |
| Fulfilled_by | Fulfilled by |
| Days_of_Supply | Days of Supply |
| Alert | Alert |
| Recommended_replenishment_qty | Recommended replenishment qty |
| Recommended_ship_date | Recommended ship date |
| Inventory_level_thresholds_published_Cur… | Inventory level threshold’s published – Current Month |
| Current_month_Very_low_inventory_thresho… | Current month – Very low inventory threshold |
| Current_month_Minimum_inventory_threshol… | Current month – Minimum inventory threshold |
| Current_month_Maximum_inventory_threshol… | Current month – Maximum inventory threshold |
| Current_month_Very_high_inventory_thresh… | Current month – Very high inventory threshold |
| Inventor_level_thresholds_published_Next… | Next month – Very low inventory threshold |
| Next_month_Very_low_inventory_threshold | Inventory level threshold’s published – Next Month |
| Next_month_Minimum_inventory_threshold | Next month – Minimum inventory threshold |
| Next_month_Maximum_inventory_threshold | Next month – Maximum inventory threshold |
| Next_month_Very_high_inventory_threshold | Next month – Very high inventory threshold |
| Utilization | Utilization |
| Maximum_shipment_quantity | Maximum shipment quantity |
| Parameter | Description |
| Header_DocumentVersion | Header DocumentVersion |
| MessageType | Message Type |
| Message | For select inactive offers, additional information is displayed here – for example, quality alerts |
| Parameter | Description |
| marketplaceId | Specifies the marketplace |
| accountStatus | Account status |
| performanceMetric | Performance metric |
| fulfillmentType | Fulfillment type |
| reportingDateFrom | Reporting date from |
| reportingDateTo | Reporting date to |
| status | Status for performance metric |
| targetCondition | Target condition |
| targetValue | Target value |
| rate | Rate |
| defectsCount | Defects count |
| cancellationCount | Cancellation count |
| chargebacksCount | Chargebacks count |
| chargebacksStatus | Chargebacks status |
| claimsCount | Claims count |
| claimsStatus | Claims status |
| invoiceDefectCount | Invoice defect count |
| invoiceDefectStatus | Invoice defect status |
| lateInvoiceCount | Late invoice count |
| lateInvoiceStatus | Late invoice status |
| lateShipmentCount | Late shipment count |
| missingInvoiceCount | Missing invoice count |
| missingInvoiceStatus | Missing invoice status |
| negativeFeedbackCount | Negative feedback count |
| negativeFeedbackStatus | Negative feedback status |
| onTimeDeliveryCount | On time delivery count |
| orderCount | Order count |
| orderWithDefectsCount | Order with defects count |
| orderWithDefectsStatus | Order with defects status |
| shipmentCount | Shipment count |
| shipmentCountWithValidTracking | shipment count with valid tracking |
| validTrackingCount | Valid tracking count |
| Parameter | Description |
| MarketplaceId | The marketplace identifier |
| serviceJobId | The service job identifier |
| serviceOrderId | The Amazon-defined identifier for an order placed by the buyer, in 3-7-7 format |
| buyer_buyerId | The identifier of the buyer. Pattern : “^[A-Z0-9] |
| buyer_isPrimeMember | When true, the service is for an Amazon Prime buyer |
| buyer_name | The name of the buyer |
| buyer_phone | The phone number of the buyer |
| createTime | The date and time of the creation of the job, in ISO 8601 format |
| preferredAppointmentTimes | A list of appointment windows preferred by the buyer. Included only if the buyer selected appointment windows when creating the order |
| scopeOfWork_asin | The Amazon Standard Identification Number (ASIN) of the service job |
| scopeOfWork_quantity | The number of service jobs |
| scopeOfWork_requiredSkills | A list of skills required to perform the job |
| scopeOfWork_title | The title of the service job |
| seller_sellerId | The identifier of the seller of the service job. Pattern : “^[A-Z0-9] |
| serviceJobProvider_serviceJobProviderId | The identifier of the service job provider. Pattern : “^[A-Z0-9] |
| serviceJobStatus | The status of the service job |
| serviceLocation_address_addressLine1 | The first line of the address |
| serviceLocation_address_addressLine2 | Additional address information, if required |
| serviceLocation_address_addressLine3 | Additional address information, if required |
| serviceLocation_address_city | The city |
| serviceLocation_address_CountryCode | The two digit country code, in ISO 3166-1 alpha-2 format |
| serviceLocation_address_county | The county |
| serviceLocation_address_district | The district |
| serviceLocation_address_name | The name of the person, business, or institution |
| serviceLocation_address_phone | The phone number |
| serviceLocation_address_postalCode | The postal code. This can contain letters, digits, spaces, and/or punctuation |
| serviceLocation_address_stateOrRegion | The state or region |
| serviceLocation_serviceLocationType | The location of the service job |
| Parameter | Description |
| reportId | The identifier for the report. This identifier is unique only in combination with a seller ID |
| reportCreatedTime | The date and time when the report was created |
| order_id | Amazon’s unique, displayable identifier for an order. This is an alphanumeric value. Go to Manage Orders to search for an order ID that includes letters, as they are not searchable in all tools |
| posted_date | The date that the item (order, adjustment, misc or other) was debited or credited to the seller’s account. This is an alphanumeric value. The total number of characters is 25 |
| settlement_id | Amazon’s unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number is 20 |
| settlement_start_date | The start date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| settlement_end_date | The end date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| deposit_date | The date that the fund transfer for the settlement period will be sent to the seller’s bank account. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| total_amount | The sales amount to be deposited into the seller’s bank account |
| currency | Currency code for the marketplace, which is also the currency code for all prices listed in the records |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| adjustment_id | Transaction ID for Adjustments |
| direct_payment_amount | Direct payment amount |
| direct_payment_type | Direct payment type |
| fulfillment_id | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| item_related_fee_amount | The amount of a particular fee charged in relation to this item |
| item_related_fee_type | The type of fee charged in the item-related-fee-amount column |
| marketplace_name | The name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters |
| merchant_adjustment_item_id | Merchant adjustment item id |
| merchant_order_id | ID assigned by Amazon or sellers |
| merchant_order_item_id | Merchant order item id |
| misc_fee_amount | No longer used |
| order_fee_amount | The amount of a particular fee charged for this order. This is a numeric value, with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point |
| order_fee_type | The type of fee charged in the order-fee-amount column |
| order_item_code | Amazon’s unique, displayable identifier for an item within the order. This is a numeric value. The total number of digits is 14 |
| other_amount | Additional charges or credits that do not fall under the Order or Adjustment transaction types. The transaction type for this amount will be specified in the transaction-type column |
| other_fee_amount | The amount of miscellaneous fees charged to your seller account |
| other_fee_reason_description | Miscellaneous fees that are not related to the monthly selling plan |
| price_amount | The amount that the buyer paid for the type of price specified in the price-type column. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point |
| price_type | The type of price specified in the price-amount column |
| promotion_amount | The amount of promotional discount applied to the item due to the promotion specified in the promotion-id column. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point |
| promotion_id | Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50 |
| promotion_type | The type of promotion referred to by the values in the promotion-id and promotion-amount columns |
| quantity_purchased | The number of these items that were purchased. This is a numeric value. The maximum number of digits is 12 |
| shipment_fee_amount | The amount of the shipping fee |
| shipment_fee_type | The type of shipping Fee as Order, Adjustment, or MiscEvent |
| shipment_id | Order transaction type ID |
| transaction_type | Text description of transaction type |
| Parameter | Description |
| reportId | The identifier for the report. This identifier is unique only in combination with a seller ID |
| reportCreatedTime | The date and time when the report was created |
| order_id | Amazon’s unique, displayable identifier for an order. This is an alphanumeric value. Go to Manage Orders to search for an order ID that includes letters, as they are not searchable in all tools |
| posted_date | The date that the item (order, adjustment, misc or other) was debited or credited to the seller’s account. This is an alphanumeric value. The total number of characters is 25 |
| settlement_id | Amazon’s unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number is 20 |
| settlement_start_date | The start date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| settlement_end_date | The end date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| deposit_date | The date that the fund transfer for the settlement period will be sent to the seller’s bank account. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| total_amount | The sales amount to be deposited into the seller’s bank account |
| currency | Currency code for the marketplace, which is also the currency code for all prices listed in the records |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| adjustment_id | Transaction ID for Adjustments |
| direct_payment_amount | Direct payment amount |
| direct_payment_type | Direct payment type |
| fulfillment_id | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| item_related_fee_amount | The amount of a particular fee charged in relation to this item |
| item_related_fee_type | The type of fee charged in the item-related-fee-amount column |
| marketplace_name | The name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters |
| merchant_adjustment_item_id | Merchant adjustment item id |
| merchant_order_id | ID assigned by Amazon or sellers |
| merchant_order_item_id | Merchant order item id |
| misc_fee_amount | No longer used |
| order_fee_amount | The amount of a particular fee charged for this order. This is a numeric value, with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point |
| order_fee_type | The type of fee charged in the order-fee-amount column |
| order_item_code | Amazon’s unique, displayable identifier for an item within the order. This is a numeric value. The total number of digits is 14 |
| other_amount | Additional charges or credits that do not fall under the Order or Adjustment transaction types. The transaction type for this amount will be specified in the transaction-type column |
| other_fee_amount | The amount of miscellaneous fees charged to your seller account |
| other_fee_reason_description | Miscellaneous fees that are not related to the monthly selling plan |
| price_amount | The amount that the buyer paid for the type of price specified in the price-type column. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point |
| price_type | The type of price specified in the price-amount column |
| promotion_amount | The amount of promotional discount applied to the item due to the promotion specified in the promotion-id column. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point |
| promotion_id | Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50 |
| promotion_type | The type of promotion referred to by the values in the promotion-id and promotion-amount columns |
| quantity_purchased | The number of these items that were purchased. This is a numeric value. The maximum number of digits is 12 |
| shipment_fee_amount | The amount of the shipping fee |
| shipment_fee_type | The type of shipping Fee as Order, Adjustment, or MiscEvent |
| shipment_id | Order transaction type ID |
| transaction_type | Text description of transaction type |
| Parameter | Description |
| reportId | The identifier for the report. This identifier is unique only in combination with a seller ID |
| reportCreatedTime | The date and time when the report was created |
| order_id | Amazon’s unique, displayable identifier for an order. This is an alphanumeric value. Go to Manage Orders to search for an order ID that includes letters, as they are not searchable in all tools |
| posted_date | The date that the item (order, adjustment, misc or other) was debited or credited to the seller’s account |
| settlement_id | Amazon’s unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number is 20 |
| settlement_start_date | The start date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| settlement_end_date | The end date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| deposit_date | The date that the fund transfer for the settlement period will be sent to the seller’s bank account. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| total_amount | The sales amount to be deposited into the seller’s bank account |
| currency | Currency code for the marketplace, which is also the currency code for all prices listed in the records |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| adjustment_id | Transaction ID for Adjustments |
| amount | Tax amount paid by customer |
| amount_description | Amount description |
| amount_type | Amount type |
| fulfillment_id | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) |
| marketplace_name | The name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters |
| merchant_adjustment_item_id | Merchant adjustment item id |
| merchant_order_id | ID assigned by Amazon or sellers |
| merchant_order_item_id | Merchant order item id |
| order_item_code | Amazon’s unique, displayable identifier for an item within the order. This is a numeric value. The total number of digits is 14 |
| posted_date_time | The date that the item (order, adjustment, misc or other) was debited or credited to the seller’s account |
| promotion_id | Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50 |
| quantity_purchased | The number of these items that were purchased. This is a numeric value. The maximum number of digits is 12 |
| shipment_id | Order transaction type ID |
| transaction_type | Text description of transaction type |
| Parameter | Description |
| MarketplaceId | The identifier of the marketplace |
| ShipmentId | A shipment identifier originally returned by the createInboundShipmentPlan operation |
| FulfillmentNetworkSKU | Amazon’s fulfillment network SKU of the item |
| QuantityInCase | The item quantity in each case, for case-packed items. Note that QuantityInCase multiplied by the number of boxes in the inbound shipment equals QuantityShipped. Also note that all of the boxes of an inbound shipment must either be case packed or individually packed. For that reason, when you submit the createInboundShipment or the updateInboundShipment operation, the value of QuantityInCase must be provided for every item in the shipment or for none of the items in the shipment |
| QuantityReceived | The item quantity that has been received at an Amazon fulfillment center |
| QuantityShipped | The item quantity that you are shipping |
| ReleaseDate | The date that a pre-order item will be available for sale |
| SellerSKU | The seller SKU of the item |
| Parameter | Description |
| SKU | Stock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller |
| FNSKU | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
| ASIN | The Amazon Standard Identification Number of the item |
| Product_Name | Product Name |
| Enrolled_in_SnL_ | Enrolled in SnL |
| Marketplace | The marketplace in which the order was placed |
| Your_SnL_Price | Your SnL Price |
| Inventory_in_SnL_FC_units_ | Inventory in SnL FC (units) |
| Inventory_in_Non_SnL_FC_units_ | Inventory in Non-SnL FC (units) |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| snapshot_date | Report data are current as of the date in this field |
| week_1_start_date | Week 1 start date |
| product_name | The title of your product |
| active_subscriptions | Total number of active subscriptions for this SKU |
| asin | The Amazon Standard Identification Number of the item |
| country | Country in which your products are stored |
| estimated_avg_sns_discount_next_8_weeks | Estimated average discount expected to be applied to your Subscribe & Save orders over the next 8 weeks |
| fnsku | Amazon’s Fulfillment network SKU identifier |
| offer_state | Offer state |
| scheduled_sns_units_week_1 | Number of Subscribe & Save items scheduled for week 1 |
| scheduled_sns_units_week_2 | Number of Subscribe & Save items scheduled for week 2 |
| scheduled_sns_units_week_3 | Number of Subscribe & Save items scheduled for week 3 |
| scheduled_sns_units_week_4 | Number of Subscribe & Save items scheduled for week 4 |
| scheduled_sns_units_week_5 | Number of Subscribe & Save items scheduled for week 5 |
| scheduled_sns_units_week_6 | Number of Subscribe & Save items scheduled for week 6 |
| scheduled_sns_units_week_7 | Number of Subscribe & Save items scheduled for week 7 |
| scheduled_sns_units_week_8 | Number of Subscribe & Save items scheduled for week 8 |
| Parameter | Description |
| marketplace_id | The encrypted marketplace value |
| sku | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| snapshot_date | Report data are current as of the date in this field |
| week_1_start_date | Week 1 start date |
| product_name | The title of your product |
| asin | The Amazon Standard Identification Number of the item |
| country | Country in which your products are stored |
| fnsku | Amazon’s Fulfillment network SKU identifier |
| offer_state | Offer state |
| oos_rate_week_1 | Out-of-stock rate for week 1 |
| oos_rate_week_2 | Out-of-stock rate for week 2 |
| oos_rate_week_3 | Out-of-stock rate for week 3 |
| oos_rate_week_4 | Out-of-stock rate for week 4 |
| sns_discount_week_1 | Average discount applied to your orders for week 1 |
| sns_discount_week_2 | Average discount applied to your orders for week 2 |
| sns_discount_week_3 | Average discount applied to your orders for week 3 |
| sns_discount_week_4 | Average discount applied to your orders for week 4 |
| sns_sale_price_week_1 | Average sale price for items shipped for week 1 |
| sns_sale_price_week_2 | Average sale price for items shipped for week 2 |
| sns_sale_price_week_3 | Average sale price for items shipped for week 3 |
| sns_sale_price_week_4 | Average sale price for items shipped for week 4 |
| sns_units_shipped_week_1 | Number of items shipped for week 1 |
| sns_units_shipped_week_2 | Number of items shipped for week 2 |
| sns_units_shipped_week_3 | Number of items shipped for week 3 |
| sns_units_shipped_week_4 | Number of items shipped for week 4 |
| Parameter | Description |
| destinationId | The identifier for the destination where notifications will be delivered |
| payloadVersion | The version of the payload object to be used in the notification |
| subscriptionId | The subscription identifier generated when the subscription is created |
| Parameter | Description |
| reportId | The identifier for the report. This identifier is unique only in combination with a seller ID |
| reportCreatedTime | The date and time when the report was created |
| PostedDate | The date and time that the item (order, adjustment, misc or other) was debited or credited to the seller’s account |
| RecordType | Record Type |
| ItemType | Item Type |
| AdjustmentID | Adjustment ID |
| AmazonOrderID | Amazon Order ID |
| AmazonOrderItemCode | OrderItem Amazon Order Item Code |
| Amount | Tax amount paid by customer |
| Amount_Currency | Currency of Fee Amount |
| Amount_Type | Amount type |
| Count | The total number of active offers on each product (including Amazon Retail) |
| CouponFee_Amount | CouponFee Amount |
| CouponFee_Type | CouponFee Type |
| CouponID | Coupon ID |
| InvoiceId | Invoice Id |
| MarketplaceName | Marketplace Name |
| MerchantAdjustmentItemID | Merchant Adjustment Item ID |
| MerchantFulfillmentID | Merchant Fulfillment ID |
| MerchantOrderID | Merchant Order ID |
| MerchantPromotionID | Merchant Promotion ID |
| PaymentReason | Payment Reason |
| Quantity | The number of these items that were purchased |
| SKU | The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product |
| ShipmentID | Shipment ID |
| SellerCouponPayment_PaymentReason | Seller Coupon Payment, Payment Reason |
| SellerCouponPayment_Count | Seller Coupon, Payment Count |
| BaseAmount | Base Amount |
| BaseAmount_Currency | Base Amount Currency |
| TaxAmount | Tax Amount |
| TaxAmount_Currency | Tax Amount Currency |
| TransactionAmount | Transaction Amount |
| TransactionAmount_Currency | Transaction Amount Currency |
| TransactionID | Transaction ID |
| TransactionType | Transaction Type |
| OtherTransactionItem_Amount | Other Transaction Item Amount |
| OtherTransactionItem_Amount_Currency | Other Transaction Item Amount Currency |
| OtherTransactionItem_Quantity | Other Transaction Item Quantity |
| OtherTransactionItem_SKU | Other Transaction Item SKU |
| SettlementData_AmazonSettlementID | Amazon’s unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number is 20 |
| SettlementData_StartDate | The start date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| SettlementData_EndDate | The end date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| SettlementData_DepositDate | The date that the fund transfer for the settlement period will be sent to the seller’s bank account. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time) |
| SettlementData_TotalAmount | The sales amount to be deposited into the seller’s bank account |
| SettlementData_TotalAmount_Currency | The currency for the transaction. All order, adjustment, fee and event data will have the same currency |
Amazon Vendor Central data templates:
| Parameter | Description |
| asin | The Amazon Standard Identification Number of the item |
| startDate | The date the data for this report became available |
| endDate | The date the data for this report became available |
| purchasedAsin | ASIN of purchased item |
| purchasedPct | Purchased pct |
| purchasedRank | Purchased rank |
| Parameter | Description |
| asin | The Amazon Standard Identification Number of the item |
| startDate | The date the data for this report became available |
| endDate | The date the data for this report became available |
| comparedAsin | ASIN of compared item |
| comparedPct | Compared pct |
| comparedRank | Compared rank |
| Parameter | Description |
| asin | The Amazon Standard Identification Number of the item |
| startDate | The date the data for this report became available |
| endDate | The date the data for this report became available |
| purchasedWithAsin | Purchased with ASIN |
| purchasedWithRank | Purchased with rank |
| combinationPct | Combination pct |
| Parameter | Description |
| marketplace_name | The name of the marketplace |
| marketplace_id | The identifier of the marketplace |
| Parameter | Description |
| asin | The Amazon Standard Identification Number of the item |
| startDate | The date the data for this report became available |
| endDate | The date the data for this report became available |
| type | |
| netPureProductMargin | The Net PPM allows you to know the level of profitability of Amazon on your products. If the Net PPM decreases, it means that Amazon is losing profitability on the product and may stop selling it |
| Parameter | Description |
| distributorView | Specifies the distributor view of the report. Values include MANUFACTURING and SOURCING |
| marketplaceIds | Marketplace ids |
| part | Part of the report |
| asin | The Amazon Standard Identification Number of the item |
| startDate | Start date of the date range |
| endDate | End date of the date range |
| aged90PlusDaysSellableInventoryCost_amou… | Amount of the aged 90+ days sellable inventory cost |
| aged90PlusDaysSellableInventoryCost_curr… | Currency code of the aged 90+ Days sellable inventory cost |
| aged90PlusDaysSellableInventoryUnits | Units of the aged 90+ days sellable inventory |
| averageVendorLeadTimeDays | Average vendor lead time days |
| netReceivedInventoryCost_amount | Amount of the aged net received inventory cost |
| netReceivedInventoryCost_currencyCode | Currency code of the net received inventory cost |
| netReceivedInventoryUnits | Units of the net received inventory |
| openPurchaseOrderUnits | Open purchase order units |
| sellableOnHandInventoryCost_amount | Amount of the sellable on hand inventory cost |
| sellableOnHandInventoryCost_currencyCode | Currency code of the sellable on hand inventory cost |
| sellableOnHandInventoryUnits | Units of the sellable on hand inventory |
| sellThroughRate | Sell through rate |
| unfilledCustomerOrderedUnits | Unfilled customer ordered units |
| unhealthyInventoryCost_amount | Amount of the unhealthy inventory cost |
| unhealthyInventoryCost_currencyCode | Currency code of the unhealthy inventory cost |
| unhealthyInventoryUnits | Units of the unhealthy inventory |
| unsellableOnHandInventoryCost_amount | Amount of the unsellable on hand inventory cost |
| unsellableOnHandInventoryCost_currencyCo… | Currency code of the unsellable on hand inventory cost |
| unsellableOnHandInventoryUnits | Units of the unsellable on hand inventory |
| Parameter | Description |
| purchaseOrderNumber | The purchase order number for this order. Formatting Notes: 8-character alpha-numeric code |
| purchaseOrderState | This field will contain the current state of the purchase order |
| orderDetails_purchaseOrderDate | The date the purchase order was placed |
| orderDetails_purchaseOrderStateChangedDa… | The date when current purchase order state was changed. Current purchase order state is available in the field ‘purchaseOrderState’ |
| orderDetails_purchaseOrderType | Type of purchase order |
| orderDetails_paymentMethod | Payment method used |
| orderDetails_buyingParty_partyId | Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details |
| orderDetails_sellingParty_partyId | Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details |
| orderDetails_shipToParty_partyId | Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details |
| orderDetails_billToParty_partyId | Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details |
| orderDetails_deliveryWindow_from | This indicates the delivery window ‘from’ border |
| orderDetails_deliveryWindow_to | This indicates the delivery window ‘to’ border |
| orderDetails_items_amazonProductIdentifi… | Amazon Standard Identification Number (ASIN) of an item |
| orderDetails_items_isBackOrderAllowed | When true, we will accept backorder confirmations for this item |
| orderDetails_items_itemSequenceNumber | Numbering of the item on the purchase order. The first item will be 1, the second 2, and so on |
| orderDetails_items_listPrice_amount | A decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies |
| orderDetails_items_listPrice_currencyCod… | Three digit currency code in ISO 4217 format. String of length 3 |
| orderDetails_items_netCost_amount | A decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies |
| orderDetails_items_netCost_currencyCode | Three digit currency code in ISO 4217 format. String of length 3 |
| orderDetails_items_orderedQuantity_amoun… | Acknowledged quantity. This value should not be zero |
| orderDetails_items_orderedQuantity_unitO… | Unit of measure for the acknowledged quantity |
| orderDetails_items_orderedQuantity_unitS… | The case size, in the event that we ordered using cases |
| orderDetails_items_vendorProductIdentifi… | The vendor selected product identification of the item |
| Parameter | Description |
| purchaseOrderNumber | The buyer’s purchase order number for this order. Formatting Notes: 8-character alpha-numeric code |
| purchaseOrderStatus | The status of the buyer’s purchase order for this order |
| purchaseOrderDate | The date the purchase order was placed |
| lastUpdatedDate | The date when the purchase order was last updated |
| sellingParty_partyId | Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details |
| shipToParty_partyId | Assigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details |
| acknowledgementStatus_acceptedQuantity_a… | Acknowledged quantity. This value should not be zero |
| acknowledgementStatus_acceptedQuantity_u… | Unit of measure for the acknowledged quantity |
| acknowledgementStatus_acceptedQuantity_u… | The case size, in the event that we ordered using cases |
| acknowledgementStatus_confirmationStatus | Confirmation status of line item |
| acknowledgementStatus_rejectedQuantity_a… | Acknowledged quantity. This value should not be zero |
| acknowledgementStatus_rejectedQuantity_u… | Unit of measure for the acknowledged quantity |
| acknowledgementStatus_rejectedQuantity_u… | The case size, in the event that we ordered using cases |
| buyerProductIdentifier | Buyer’s Standard Identification Number (ASIN) of an item |
| itemSequenceNumber | Numbering of the item on the purchase order. The first item will be 1, the second 2, and so on |
| listPrice_amount | A decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies |
| listPrice_currencyCode | Three digit currency code in ISO 4217 format. String of length 3 |
| netCost_amount | A decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies |
| netCost_currencyCode | Three digit currency code in ISO 4217 format. String of length 3 |
| orderedQuantity_orderedQuantity_amount | Acknowledged quantity. This value should not be zero |
| orderedQuantity_orderedQuantity_unitOfMe… | Unit of measure for the acknowledged quantity |
| orderedQuantity_orderedQuantity_unitSize | The case size, in the event that we ordered using cases |
| receivingStatus_receiveStatus | Receive status of the line item |
| receivingStatus_receivedQuantity_amount | Acknowledged quantity. This value should not be zero |
| receivingStatus_receivedQuantity_unitOfM… | Unit of measure for the acknowledged quantity |
| receivingStatus_receivedQuantity_unitSiz… | The case size, in the event that we ordered using cases |
| vendorProductIdentifier | The vendor selected product identification of the item |
| Parameter | Description |
| distributorView | Specifies the distributor view of the report. Values include MANUFACTURING and SOURCING |
| marketplaceIds | Marketplace ids |
| part | Part of the report |
| asin | The Amazon Standard Identification Number of the item |
| startDate | Start date of the date range |
| endDate | End date of the date range |
| customerReturns | Goods returned by customers are the number of units returned by customers |
| orderedRevenue_amount | Ordered Revenue is the number of units ordered multiplied by the average retail price of each unit. It’s how much revenue you can expect based on orders that have been actually placed, but these units have not necessarily shipped |
| orderedRevenue_currencyCode | Currency code of the Ordered Revenue |
| orderedUnits | Ordered Units |
| shippedCogs_amount | Shipped COGS (cost of goods sold) is shipped units multiplied by the average wholesale price of units. Shipped COGS tends to be the number most brands care about the most because it relates the most to their sales |
| shippedCogs_currencyCode | Currency code of the Shipped COGS |
| shippedRevenue_amount | Shipped Revenue is also important, but is not as important to vendors as shipped COGS because it is a measure of revenue going to Amazon – not the vendor. Shipped COGS specifically refers to the revenue that goes to the vendor |
| shippedRevenue_currencyCode | Currency code of the Shipped Revenue |
| shippedUnits | Number of product units shipped to Amazon customers |
| Parameter | Description |
| marketplaceIds | Marketplace ids |
| part | Part of the report |
| asin | The Amazon Standard Identification Number of the item |
| startDate | Start date of the date range |
| endDate | End date of the date range |
| glanceViews | A glance view if the number of times someone viewed your Product Detail Page |
Ready-to-use data connectors
We have developed data connectors to 200+ APIs and web services. Can’t find your connector? Reach out to us through our chat. We are continuously developing new connectors.
