Connect to the Amazon Selling Partner API and get all your Amazon Business data automatically

amazon

Get central access to all your Amazon data

Automate your data workflows

Become a truly data-driven Amazon seller

Amazon Selling Partner API | SP-API connector

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

Amazon Account

Create Your

Data Jobs

Play Video

Watch this quick demo to learn
how the Amazon SP-API connector 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.

Pipes | Amazon Software Partner
Pipes| Amazon Service Partner

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:

Amazon A+ content (a.k.a. Enhanced Brand Content (EBC)) is an enhanced product description format that allows sellers to create more visually appealing and informative content that includes rich media, comparison charts, sizing guides, and other relevant information. It is available to professional sellers on Amazon for additional fees.
 
ParameterDescription
MarketplaceIdThe identifier of the marketplace
contentReferenceKeyA 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_badgeSetThe set of content badges
contentMetadata_marketplaceIdThe identifier for the marketplace where the A+ Content is published
contentMetadata_nameThe A+ Content document name
contentMetadata_statusThe submission status of the content document
contentMetadata_updateTimeThe approximate age of the A+ Content document and metadata
Detailed Active Listings Report

ParameterDescription
marketplace_idThe encrypted marketplace value
item_nameThe item name
item_descriptionThe item description
listing_idThe listing id
seller_skuStock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller
pricePrice 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
quantityThe total number of units reimbursed for this line item
open_dateOpen date
image_urlThe image url
item_is_marketplaceItem is marketplace
product_id_typeThe type of product id
zshop_shipping_feeZshop shipping fee
item_noteThe item note
item_conditionNumeric 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_category1Zshop category1
zshop_browse_pathZshop browse path
zshop_storefront_featureZshop storefront feature
asin1The Amazon Standard Identification Number (ASIN) of the item
asin2The Amazon Standard Identification Number (ASIN) of the item
asin3The Amazon Standard Identification Number (ASIN) of the item
will_ship_internationallyWill ship internationally
expedited_shippingExpedited shipping
zshop_boldfaceZshop boldface
product_idThe product id
bid_for_featured_placementThe bid for featured placement
add_deleteAdd delete
pending_quantityPending quantity
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
Business_PriceA special price that is available only for Amazon Business orders
Quantity_Price_TypeQuantity price type
Quantity_Lower_Bound_1Quantity lower bound
Quantity_Price_1Quantity price
Quantity_Lower_Bound_2Quantity lower bound
Quantity_Price_2Quantity price
Quantity_Lower_Bound_3Quantity lower bound
Quantity_Price_3Quantity price
Quantity_Lower_Bound_4Quantity lower bound
Quantity_Price_4Quantity price
Quantity_Lower_Bound_5Quantity lower bound
Quantity_Price_5Quantity price
merchant_shipping_groupThe merchant shipping group
Progressive_Price_TypeProgressive price type
Progressive_Lower_Bound_1Progressive lower bound
Progressive_Price_1Progressive price
Progressive_Lower_Bound_2Progressive lower bound
Progressive_Price_2Progressive price
Progressive_Lower_Bound_3Progressive lower bound
Progressive_Price_3Progressive 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
marketplace_idThe encrypted marketplace value
startDateStart date
endDateEnd date
clickedAsinAsin (Amazon Standard Identification Number) of the clicked item
clickedItemNameName of the clicked item
clickShareClick share
clickShareRankClick share rank
conversionShareConversion share
departmentNameName of the department
searchFrequencyRankSearch frequency rank
searchTermSearch term
Parameter Description
UNIQUE_ACCOUNT_IDENTIFIERA unique alphanumeric identifier for your account
ACTIVITY_PERIODYear and Month where activity is contained within the report
SALES_CHANNELThe 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
MARKETPLACEThe marketplace in which the order was placed
PROGRAM_TYPEThis 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_TYPEShipment, Refund, Retrocharge, Order Fee, etc
TRANSACTION_EVENT_IDTransaction 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_IDActivity 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_DATEThe date that is used to determine the VAT details
TRANSACTION_DEPART_DATEDate 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_DATEDate 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_DATEDate 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_SKUStock 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’
ASINThe Amazon Standard Identification Number of the item
ITEM_DESCRIPTIONThe 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_COUNTRYTwo character country code where the product was originally made or manufactured; this is not the location where the item is sold
QTYThe total number of units in reserved status
ITEM_WEIGHTThe 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_WEIGHTTotal 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_ITEMSThe cost price of the item (amount paid to acquire the item) as provided by the seller
PRICE_OF_ITEMS_AMT_VAT_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_EXCLThe 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_PERCENTThe 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_AMTThe 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_AMTThe 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_AMTThe 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_PERCENTThe 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_AMTThe 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_AMTThe 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_AMTThe 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_PERCENTThe 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_AMTThe 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_AMTThe 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_AMTThe 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_AMTThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_INCLThe 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_CODECurrency 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_CODEAn eight digit numeric code provided by the European Government that identifies a group of goods
STATISTICAL_CODE_DEPARTAdditional 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_ARRIVALAdditional 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_UNITSupplementary unit for certain Commodity Codes. – For example, carats for diamonds
ITEM_QTY_SUPPLEMENTARY_UNITCOMMODITY_CODE_SUPPLEMENTARY_UNIT quantity in the transaction. – For example, 10 if it is a 10 carat diamond
TOTAL_ACTIVITY_SUPPLEMENTARY_UNITTotal 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_CODEA standard code to identify the tax properties of a product
DEPATURE_CITYCity 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_COUNTRYTwo 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_CODEPost 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_CITYCity 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_COUNTRYTwo 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_CODEPost 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_COUNTRYTwo 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_COUNTRYTwo 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_MODEThe way goods are moved between destinations. – AFN: “FC_Transfer”, “Donation” – Transport by Road
DELIVERY_CONDITIONSThe 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_COUNTRYThe 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_NUMBERThe seller’s VAT number in relation to the departure country
SELLER_ARRIVAL_VAT_NUMBER_COUNTRYThe 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_NUMBERThe seller’s VAT number in relation to the arrival country
TRANSACTION_SELLER_VAT_NUMBER_COUNTRYThe country associated with the seller’s VAT number used for this transaction. This is represented as a two character country code
TRANSACTION_SELLER_VAT_NUMBERSeller’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_COUNTRYThe country associated with the buyer’s VAT number provided for this transaction. This is represented as a two character country code
BUYER_VAT_NUMBERBuyer’s VAT number provided for this transaction
VAT_CALCULATION_IMPUTATION_COUNTRYThe country which was used to back VAT out of the VAT inclusive price. This is represented as a two character country code
TAXABLE_JURISDICTIONIndicates the jurisdictional value where a tax calculation was performed. For example, Country, Territory, etc
TAXABLE_JURISDICTION_LEVELIndicates at which jurisdictional level a tax calculation was performed. For example, Country, Territory, etc
VAT_INV_NUMBERIndicates the sequential number assigned to the tax document, if applicable. E.g. the sequential VAT invoice number or credit note number
VAT_INV_CONVERTED_AMTIndicates 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_CODEIndicates the currency code of the local taxed jurisdiction’s currency, where that currency differs to that of the marketplace
VAT_INV_EXCHANGE_RATEIndicates 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_DATEIndicates 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_EUIndicates whether or not an item was shipped from a EU28 member country to a country outside the EU28 member countries
INVOICE_URLThis field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services
BUYER_NAMEThis field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services
ARRIVAL_ADDRESSThis field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services
SUPPLIER_NAMEThis 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_NUMBERSupplier’s VAT number
TAX_REPORTING_SCHEMEThis 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_RESPONSIBILITYThis 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_idThe encrypted marketplace value
item_nameThe item name
item_descriptionThe item description
seller_skuStock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller
pricePrice 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
quantityThe total number of units reimbursed for this line item
image_urlThe image url
item_is_marketplaceItem is marketplace
product_id_typeThe type of product id
zshop_shipping_feeZshop shipping fee
item_noteThe item note
item_conditionNumeric 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_category1Zshop category1
zshop_browse_pathZshop browse path
zshop_storefront_featureZshop storefront feature
asin1The Amazon Standard Identification Number (ASIN) of the item
asin2The Amazon Standard Identification Number (ASIN) of the item
asin3The Amazon Standard Identification Number (ASIN) of the item
will_ship_internationallyWill ship internationally
expedited_shippingExpedited shipping
zshop_boldfaceZshop boldface
product_idThe product id
add_deleteAdd delete
Business_PriceA special price that is available only for Amazon Business orders
Quantity_Price_TypeQuantity price type
Quantity_Lower_Bound_1Quantity lower bound
Quantity_Price_1Quantity price
Quantity_Lower_Bound_2Quantity lower bound
Quantity_Price_2Quantity price
Quantity_Lower_Bound_3Quantity lower bound
Quantity_Price_3Quantity price
Quantity_Lower_Bound_4Quantity lower bound
Quantity_Price_4Quantity price
Quantity_Lower_Bound_5Quantity lower bound
Quantity_Price_5Quantity price
merchant_shipping_groupThe merchant shipping group
Progressive_Price_TypeProgressive price type
Progressive_Lower_Bound_1Progressive lower bound
Progressive_Price_1Progressive price
Progressive_Lower_Bound_2Progressive lower bound
Progressive_Price_2Progressive price
Progressive_Lower_Bound_3Progressive lower bound
Progressive_Price_3Progressive price
Parameter Description
marketplaceIdAmazon marketplace identifier
asinAmazon Standard Identification Number (ASIN) is the unique identifier for an item in the Amazon catalog
brandNameName of the brand associated with an Amazon catalog item
browseNodeIdentifier of the browse node associated with an Amazon catalog item
itemNameName, or title, associated with an Amazon catalog item
manufacturerName 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
destinationIdThe destination identifier generated when you created the destination
nameThe developer-defined name for this destination
resource_eventBridge_accountIdThe identifier for the AWS account that is responsible for charges related to receiving notifications
resource_eventBridge_nameThe name of the partner event source associated with the destination
resource_eventBridge_regionThe 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_arnThe Amazon Resource Name (ARN) associated with the SQS queue. Pattern : “^arn:aws:sqs:S+:S+:S+”
Parameter Description
seller_skuStock 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_skuUnique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
asinThe Amazon Standard Identification Number of the item
condition_typeThe condition of your inventory
Warehouse_Condition_codeCode assigned in Amazon”s fulfillment center to listings matching the ASIN and the seller”s condition-type
Quantity_AvailableQuantity available
Parameter Description
amazon_order_idAmazon”s unique, displayable identifier for an order
merchant_order_idA unique identifier optionally supplied for the order by the Merchant
shipment_idEncrypted Amazon shipment id
shipment_item_idEncrypted Amazon shipment item id
amazon_order_item_idAmazon”s unique, displayable identifier for an item within the order
merchant_order_item_idA unique identifier for an item within the order
purchase_dateThe date the order was placed
payments_dateThe date the buyer”s credit card was charged and order processing was completed
shipment_dateThe date the shipment was completed (shipped) by the fulfillment center
reporting_dateThe date the data for this report became available in the FBA data store
buyer_emailThe encrypted email address of the buyer
buyer_nameThe full name of the buyer
buyer_phone_numberThe phone number of the buyer
skuA merchant-defined unique identifier for a product
product_nameThe short title for the product, displayed in bold on the detail web page and in the title bar of the browser window
quantity_shippedThe number of this item that were shipped
currencyThe currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY
item_priceThe amount that the buyer paid for the item. Amount is aggregate of the quantity, not unit price
item_taxThe amount that the buyer paid for item tax. Amount is aggregate of the quantity, not unit price
shipping_priceThe amount that the buyer paid for shipping. Amount is aggregate of the quantity, not unit price
shipping_taxThe amount that the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price
gift_wrap_priceThe amount that the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price
gift_wrap_taxThe amount that the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price
ship_service_levelAn enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., Standard v. Expedited)
recipient_nameName field of a standard address
ship_address_1The first line of a standard address
ship_address_2The second line of a standard address
ship_address_3The third line of a standard address
ship_cityThe city of a standard address
ship_stateThe state or region of a standard address
ship_postal_codeThe postal (ZIP) code of a standard address
ship_countryISO 3166 standard two-letter country code
ship_phone_numberThe phone number associated with the ship-to address
bill_address_1The first line of a standard address
bill_address_2The second line of a standard address
bill_address_3The third line of a standard address
bill_cityThe city of a standard address
bill_stateThe state or region of a standard address
bill_postal_codeThe postal (zip) code of a standard address
bill_countryISO 3166 standard two-letter country code
item_promotion_discountPromotion discount applied to the order item
ship_promotion_discountPromotion discount applied to shipping
carrierThe name of the carrier the package was shipped with
tracking_numberThe carrier”s tracking number for the package
estimated_arrival_dateThe estimated date of delivery to the customer
fulfillment_center_idThe unique identifier from which fulfillment center the order was shipped
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
sales_channelThe source of the order
Parameter Description
marketplace_idThe encrypted marketplace value
amazon_order_idAmazon’s unique, displayable identifier for an order
merchant_order_idA unique identifier optionally supplied for the order by the Merchant
shipment_idAmazon shipment ID
shipment_item_idUnique identifier–pertains only to this item in this shipment
amazon_order_item_idAmazon”s unique, displayable identifier for an item within the order
merchant_order_item_idA unique identifier for an item within the order
purchase_dateThe date the order was placed
payments_dateThe date the buyer”s credit card was charged and order processing was completed
shipment_dateDate of the shipment
reporting_dateThe date the data for this report became available in the FBA data store
buyer_emailThe encrypted email address of the buyer
buyer_nameThe full name of the buyer
buyer_phone_numberThe phone number of the buyer
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
product_nameThe name of your product
quantity_shippedThe number of this item that were shipped
currencyThe currency used for the purchase. Supported currencies include CDN, USD, GBP, EUR, and JPY
item_pricePrice set for an item, minus VAT
item_taxThe amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price
shipping_priceThe amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price
shipping_taxThe amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price
gift_wrap_priceThe amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price
gift_wrap_taxThe amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price
ship_service_levelAn enumerated value that determines the type of fulfilment service that the buyer expects the merchant to use (e.g., Standard vs. Expedited)
recipient_nameName field of a standard address
ship_address_1The first line of a standard address
ship_address_2The second line of a standard address
ship_address_3The third line of a standard address
ship_cityThe city of a standard address
ship_stateThe state or region of a standard address
ship_postal_codeThe postal (ZIP) code of a standard address
ship_countryISO 3166 standard two-letter country code
ship_phone_numberThe phone number associated with the ship-to address
bill_address_1The first line of a standard address
bill_address_2The second line of a standard address
bill_address_3The third line of a standard address
bill_cityThe city of a standard address
bill_stateThe state or region of a standard address
bill_postal_codeThe postal (zip) code of a standard address
bill_countryISO 3166 standard two-letter country code
item_promotion_discountPromotion discount applied to the order item
ship_promotion_discountPromotion discount applied to shipping
carrierThe name of the carrier the package was shipped with. Multiple carriers may be used for a single removal order
tracking_numberThe carrier”s tracking number for the package, if available. Multiple tracking IDs may exist for a single removal order
estimated_arrival_dateThe estimated date of delivery to the customer
fulfillment_center_idFulfillment center where inventory is stored
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
sales_channelThe source of the order. Will be either Amazon.com or Non Amazon. Non Amazon means the order was not placed on Amazon, but it was fulfilled by Amazon
Parameter Description
shipment_dateThe date the shipment was completed (shipped) by the fulfillment center
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
fnskuA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
asinThe Amazon Standard Identification Number of the item
fulfillment_center_idThe fulfillment center where the problem is identified
quantityThe total number of units reimbursed for this line item
amazon_order_idThe unique identifier assigned to the customer order. This field is empty if the reimbursement is not associated with an order
currencyThe currency of the removal fee
item_price_per_unitItem price per unit
shipping_priceThe amount that the buyer paid for shipping. Amount is aggregate of the quantity, not unit price
gift_wrap_priceThe amount that the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price
ship_cityThe city of a standard address
ship_stateThe state or region of a standard address
ship_postal_codeThe postal (ZIP) code of a standard address
Parameter Description
snapshot_dateReport data are current as of the date in this field
fnskuA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
product_nameThe title of your product
quantityThe total number of units reimbursed for this line item
fulfillment_center_idThe fulfillment center where the problem is identified
detailed_dispositionStatus of the product (examples: sellable, damaged)
countryCountry 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
marketplace_idThe encrypted marketplace value
issue_reported_dateDate shipment problem was resolved
asinAmazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
alert_statusIndicates whether the problem has been acknowledged
coaching_levelThe coaching level for a particular problem group. One of the following: Standard, Elevated, Critical
currencyThe currency used for the purchase. Supported currencies include CDN, USD, GBP, EUR, and JPY
expected_quantityThe number of units we expected to receive at the fulfillment center
fba_carton_idBox ID in which the problem was identified
fba_shipment_idShipment ID in which the problem was identified
fee_totalThe total unplanned Service fees charged
fee_typeOne of the following: Unplanned Service fee, Unplanned Service fee (Preview), Exempt, Refund
fnskuFulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers
fulfillment_center_idThe fulfillment center where the problem is identified
performance_measurement_unitThe unit of measurement for the particular problem type. For example, whether the problem occurred at the unit, box, or shipment level
problem_levelThe level of problem. One of the following: Units, Shipment
problem_quantityNumber of units to which the problem applies
problem_typeThe type of problem identified, for example: Barcode cannot be scanned, Item label missing
product_nameThe name of your product
received_quantityThe number of units we received at the fulfillment center
shipment_creation_dateThe date you created the shipment
Parameter Description
adjusted_dateAdjusted date
transaction_item_idUnique ID assigned to the item within the order
fnskuA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
product_nameThe title of your product
fulfillment_center_idThe fulfillment center where the problem is identified
quantityThe total number of units reimbursed for this line item
reasonThe reason for the reimbursement (for example, Damaged: Warehouse)
dispositionThe status of the unit
reconciledNumber of units reconciled with other adjustment events
unreconciledNumber of units not reconciled with other adjustment events
Parameter Description
marketplace_idThe encrypted marketplace value
snapshot_dateReport data is current as of the date in this field
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller
fnskuUnique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center
asinAmazon 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_nameThe title of your product
conditionThe condition of your item
avaliable_quantity_sellable_Avaliable quantity (sellable)
qty_with_removals_in_progressThe number of Units in inventory that you have requested be removed
inv_age_0_to_90_daysThe 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_daysThe 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_daysThe 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_daysThe 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_daysThe number of sellable Units you have for a SKU that have been in the fulfillment center for the last 365+ days
currencyThe currency of the removal fee
qty_to_be_charged_ltsf_6_moThe 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_curCurrency 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_moThe 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_moThe 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_curCurrency 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_moThe 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_daysSales of this item in last 7 days
units_shipped_last_30_daysSales of this item in last 30 days
units_shipped_last_60_daysSales of this item in last 60 days
units_shipped_last_90_daysSales of this item in last 90 days
alertThe alert
your_price_curCurrency of your current selling price
your_priceYour current selling price
sales_price_curCurrency of sales price
sales_priceSales price
lowest_price_new_curCurrency of lowest price new
lowest_price_newLowest price new
lowest_price_used_curCurrency of lowest price used
lowest_price_usedLowest price used
Recommended_actionRecommended action
Healthy_Inventory_LevelHealthy Inventory Level
Recommended_sales_priceRecommended sales price
Recommended_sale_duration_days_Recommended sale duration (days)
Recommended_Removal_QuantityRecommended removal quantity
estimated_cost_savings_of_recommended_ac…Estimated cost savings of recommended actions
sell_throughSell through
item_volumeItem volume
volume_unitsVolume units
storage_typeStorage type
Parameter Description
snapshot_dateDate of request
transaction_typeShipment, Refund, Retrocharge, Order Fee, etc
fnskuUnique item ID assigned by Amazon and used by the fulfillment center
skuUnique item ID assigned by the seller
product_nameName of the product as listed on Amazon
fulfillment_center_idFulfillment center where the adjustment is being made
quantityNumber of units adjusted
dispositionWhether the item is in sellable or unsellable/unfulfillable condition
Parameter Description
marketplace_idThe encrypted marketplace value
snapshot_dateReport data is current as of the date in this field
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller
fnskuUnique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center
asinAmazon 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_nameThe title of your product
conditionThe condition of your item
sales_rankThe 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_groupThe Amazon department or category for which the Sales Rank in the previous field is applicable
total_quantityThe number of Units you have for a SKU in sellable condition in our fulfillment network
sellable_quantityThe number of Units you have for a SKU in sellable condition in our fulfillment network
unsellable_quantityThe number of units you have for a SKU in unsellable condition in our fulfillment network
inv_age_0_to_90_daysThe 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_daysThe 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_daysThe 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_daysThe 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_daysThe 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_hrsSales of this item in last 24 hours
units_shipped_last_7_daysSales of this item in last 7 days
units_shipped_last_30_daysSales of this item in last 30 days
units_shipped_last_90_daysSales of this item in last 90 days
units_shipped_last_180_daysSales of this item in last 180 days
units_shipped_last_365_daysSales for this item in last 365 days
weeks_of_cover_t7Based 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_t30Based 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_t90Based 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_t180Based 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_t365Based 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_sellersThe number of sellers with FBA offers that are in New condition
num_afn_used_sellersThe number of sellers with FBA offers that are in Used condition
currencyThe currency of the removal fee
your_priceYour current selling price
sales_priceYour current promotional price
lowest_afn_new_priceThe lowest fulfilled by Amazon price for items in New condition, including any offers from Amazon
lowest_afn_used_priceThe lowest FBA price for items in Used condition
lowest_mfn_new_priceThe lowest price for items in New condition that are fulfilled by a seller. This includes the seller’s shipping cost
lowest_mfn_used_priceThe 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_moThe 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_programThe number of sellable units that have previously been charged the Long-Term Storage Fee
qty_with_removals_in_progressThe number of Units in inventory that you have requested be removed
projected_ltsf_12_moThe 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_volumeThe volume in cubic footage of each inventory unit
is_hazmatIf your ASIN is considered Hazmat. Please see Hazardous Materials (Hazmat) to see if your products qualify
in_bound_quantityIn bound quantity
asin_limitYour inventory limit for ASINs where we apply an inventory capacity limit. Please see ASIN Quantity Limits for more information
inbound_recommend_quantityInbound recommend quantity
qty_to_be_charged_ltsf_6_moThe 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_moThe 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

ParameterDescription
marketplace_idThe encrypted marketplace value
asinAmazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
conditionThe condition of your product
countryCountry in which your products are stored
currencyThe currency used for the purchase. Supported currencies include CDN, USD, GBP, EUR, and JPY
enrolled_in_small_and_lightEnrolled in small and light
fnskuFulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers
long_time_range_long_term_storage_feeQty charged long time range long term storage fee
per_unit_volumeThe volume in cubic feet of each inventory unit assessed the Long-Term Storage Fee
product_nameThe name of your product
qty_charged_long_time_range_long_term_st…Qty charged long time range long term storage fee
qty_charged_short_time_range_long_term_s…Qty charged short time range long term storage fee
short_time_range_long_term_storage_feeShort time range long term storage fee
snapshot_dateThe date the report was generated
volume_unitVolume unit
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
Details of archived inventory
Parameter Description
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products
fnskuFulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers
asinAmazon 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_nameThe title of your product
conditionThe condition of your product
your_priceYour current selling price
mfn_listing_existsYes indicates that the product is listed for fulfillment by you as the seller
mfn_fulfillable_quantityThe quantity in your fulfillment network that can be picked, packed, and shipped
afn_listing_existsYes indicates that the item is listed for Fulfillment by Amazon
afn_warehouse_quantityThe 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_quantityThe number of units you have for a SKU in Amazon fulfillment centers that can be picked, packed, and shipped
afn_unsellable_quantityThe number of units you have for a SKU in Amazon fulfillment centers in unsellable condition
afn_reserved_quantityThe 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_quantityThe 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_volumeThe volume in cubic feet of one unit (to the nearest 1/100 of an inch)
afn_inbound_working_quantityThe number of units you have for a SKU in an inbound shipment that you have notified Amazon about
afn_inbound_shipped_quantityThe 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_quantityThe 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_quantityAfn researching quantity
afn_reserved_future_supplyThe 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_buyableThe 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
marketplace_idThe encrypted marketplace value
asinAmazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
alertShows when an item has a low traffic or low conversion alert. Low traffic indicates that a low number of potential buyers have seen the listings. Low conversion indicates that potential buyers are viewing the listing but do not follow through to purchase the product
availableAvailable
conditionThe condition of your product
currencyThe currency used for the purchase. Supported currencies include CDN, USD, GBP, EUR, and JPY
days_of_supplyDays of Supply
estimated_cost_savings_of_recommended_ac…Estimated cost savings between taking the recommended action versus the storage fees you would incur on that inventory by taking no action
estimated_excess_quantityEstimated excess units are overstocked units based on your current sales velocity and customer demand forecast. It’s costing you more to keep these units on hand and pay storage fees than to reduce the number of units through a price reduction or removal
estimated_ltsf_next_chargeEstimated ltsf next charge
estimated_storage_cost_next_monthEstimated storage fees (monthly storage + long-term storage) that you would incur 30 days from today, based on your current sales rate
featuredoffer_priceOffer displayed on a product detail page with an Add to Cart button
fnskuFulfillment Network Stock Keeping Units (FNSKUs) are unique identifiers assigned by Amazon to products stored in and fulfilled from Amazon fulfillment centers
healthy_inventory_levelQuantity of inventory that is not considered excess based on product demand and your costs. Our recommendations are based on helping you reach this level of inventory
inbound_quantityInbound quantity = inbound-working + inbound-shipped + inbound receiving
inbound_receivedShipments in receiving status
inbound_shippedShipments in shipped status
inbound_workingShipments in working status
inv_age_0_to_30_daysThe number of sellable units that have been in the fulfillment center for the last 0-30 days
inv_age_0_to_90_daysThe number of sellable units that have been in the fulfillment center for the last 0-90 days
inv_age_181_to_270_daysThe number of sellable units that have been in the fulfillment center for the last 181-270 days
inv_age_181_to_330_daysThe number of sellable units that have been in the fulfillment center for the last 181-330 days
inv_age_271_to_365_daysThe number of sellable units that have been in the fulfillment center for the last 271-365 days
inv_age_31_to_60_daysThe number of sellable units that have been in the fulfillment center for the last 31-60 days
inv_age_331_to_365_daysThe number of sellable units that have been in the fulfillment center for the last 331-365 days
inv_age_365_plus_daysThe number of sellable units that have been in the fulfillment center for the last 365+ days
inv_age_61_to_90_daysThe number of sellable units that have been in the fulfillment center for the last 61-90 days
inv_age_91_to_180_daysThe number of sellable units that have been in the fulfillment center for the last 91-180 days
item_volumeItem volume
lowest_price_new_plus_shippingThe lowest price (including shipping) for this item in new condition on Amazon
lowest_price_usedThe lowest price (including shipping) for this item in used condition on Amazon
marketplaceThe marketplace where an item is listed
no_sale_last_6_monthsInventory that has not sold in six or more consecutive months and that have been in fulfillment centers for more than 180 days. These units will be automatically removed during the next removal cycle if you are opted in to automated fulfillable inventory removals
pending_removal_quantityThe number of units that you have asked to be returned to you or disposed of
product_groupDistinct product grouping distinguishing products like books, from watches or video games
product_nameThe name of your product
projected_ltsf_9_moThe projected long-term storage fee for units that have been in fulfillment centers (9 months)
qty_to_be_charged_ltsf_12_moThe number of sellable units that are in the fulfillment center for 365 days or more, as of the next assessment (Starting August 2019, LTSF will be assessed on the 15th of each month)
qty_to_be_charged_ltsf_9_moThe number of sellable units that are in the fulfillment center for (9 to 12 months)
recommended_actionThe action recommended for your inventory. Recommendations are based on your current customer demand and on whether it would cost you less to take an action than to do nothing
recommended_removal_quantityEstimated number of units that would likely benefit from removal instead of being charged storage fees
recommended_sale_duration_daysIf a sale is recommended, this is the estimated sale duration in days that would likely help you sell through your excess inventory
recommended_sales_priceSales price recommended to help you sell through your inventory based on your current inventory settings. This value may be different from the lowest price or Featured Offer price. We recommend that you keep your product at this price until you have sold through your excess inventory
sales_priceYour sale price if you are running a sale on the product
sales_rankThe current rank for your product. The change in sales rank value is the plus or minus change in the past 7 days
sales_shipped_last_30_daysShipped_unit sales in the last 30 days
sales_shipped_last_60_daysShipped_unit sales in the last 60 days
sales_shipped_last_7_daysShipped_unit sales in the last 7 days
sales_shipped_last_90_daysShipped_unit sales in the last 90 days
sell_throughThe rate at which your units sold and shipped over the past 90 days divided by the average inventory available at fulfillment centers during that time period. Tracking your sell-through rate can help you determine whether you need to take action to improve traffic or conversion for your products
snapshot_dateThe date the report was generated
storage_typeStorage type category of the product for which storage limits are set. There are six storage types: standard-size, oversize, apparel, footwear, flammable or aerosol
storage_volumeStorage volume is the total usage for this product in our fulfillment centers minus inventory that is pending removal
units_shipped_t30Units shipped in the last 30 days
units_shipped_t60Units shipped in the last 60 days
units_shipped_t7Units shipped in the last 7 days
units_shipped_t90Units shipped in the last 90 days
volume_unit_measurementUnit of measurement for the volume of the item
weeks_of_cover_t30Your historical trailing 30-day on-hand inventory average divided by your units sold over the same time period divided by 4 weeks. If you sold 400 units of a given item in the last 30 days (4 weeks) and had 100 sellable units in fulfillment centers, your weeks of cover last 30 days would be 1
weeks_of_cover_t90Your historical trailing 90-day on-hand inventory average divided by your units sold over the same time period divided by 12 weeks. If you sold 400 units of a given item in the last 90 days (12 weeks) and had an average of 10 sellable units in fulfillment centers, your weeks of cover last 90 days would be 3.33
your_priceYour listed price
Parameter Description
seller_skuStock 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_skuUnique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
asinThe Amazon Standard Identification Number of the item
condition_typeThe condition of your inventory
countryCountry in which your products are stored
quantity_for_local_fulfillmentQuantity for local fulfillment
Parameter Description
shipment_dateDate the item shipped to the customer
currencyLocal currency for the transaction
item_promotion_discountPromotion value applied to this shipment item
item_promotion_idUnique identifier for this promotion
descriptionDescription of the promotion
promotion_rule_valueMaximum net value of the promotion
amazon_order_idOrder id of shipment to which the promotion was applied
shipment_idUnique identifier for this item in this shipment
shipment_item_idUnique identifier–pertains only to this item in this shipment
Parameter Description
received_dateDate the receive process was completed for the shipment, DD-MON-YYYY
fnskuA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
product_nameThe title of your product
quantityThe total number of units reimbursed for this line item
fba_shipment_idShipment ID in which the problem was identified
fulfillment_center_idThe fulfillment center where the problem is identified
Parameter Description
snapshot_dateReport data are current as of the date in this field
skuStock keeping units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller
fnskuUnique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
asinAmazon 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_nameThe title of your product
conditionThe condition of your product
sellable_quantityThe number of units you have for a SKU in sellable condition in our fulfillment network
sellable_271_365_daysThe 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__dayshe number of sellable units you have for a SKU that have been in the fulfillment center for 365 days
sellable_removal_quantityThe 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_quantityThe number of unsellable units you have for a SKU in our fulfillment network
unsellable_0_7_daysThe number of units that have been unsellable for zero to seven days
unsellable_8_60_daysThe number of units that have been unsellable for eight to 60 days
unsellable_61_90_daysThe number of units that have been unsellable for 61 to 90 days
sellable_121_180_daysThe 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_daysThe 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_dateThe date the reimbursement was approved
reimbursement_idThe unique identifier for this reimbursement. Each reimbursement may include multiple line items
case_idThe unique identifier assigned to the case when you request a reimbursement
amazon_order_idThe unique identifier assigned to the customer order. This field is empty if the reimbursement is not associated with an order
reasonThe reason for the reimbursement (for example, Damaged: Warehouse)
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
fnskufnsku
asinAn 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_nameThe title of your product
conditionThe condition of your item (for example, New)
currency_unitThe currency for the applicable marketplace
amount_per_unitThe per-unit reimbursement amount for this line item
amount_totalThe total amount of the cash reimbursement for this line item
quantity_reimbursed_cashThe total number of units reimbursed with cash
quantity_reimbursed_inventoryThe number of units reimbursed with inventory
quantity_reimbursed_totalThe total number of units reimbursed with either cash or inventory (Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory])
original_reimbursement_idThe number of units reimbursed with id
original_reimbursement_typeThe number of units reimbursed with type
Parameter Description
request_dateDate the removal order was submitted
last_updated_dateDate of the most recent order update
order_idAmazon’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
currencyCurrency code for the marketplace, which is also the currency code for all prices listed in the records
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
cancelled_quantityThe total number of units of this FNSKU cancelled from the removal order
disposed_quantityThe total number of units for this FNSKU that were disposed of
dispositionThe status of the unit
fnskuAmazon’s Fulfillment network SKU identifier
in_process_quantityThe total number of units for this FNSKU that are in process
order_statusRemoval order status
order_typeRemoval order type (Return, Disposal)
removal_feeThe 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_quantityThe number of units of this FNSKU requested in the removal order
shipped_quantityThe 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_idThe encrypted marketplace value
asinAmazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
original_amazon_order_idOrder ID of original shipment
fulfillment_center_idFulfillment center shipping this unit
original_fulfillment_center_idOriginal fulfillment center shipping free replaced item
quantityQuantity of an item ordered
replacement_amazon_order_idOrder ID of the replacement order
replacement_reason_codeReason for replacement: see Free Replacement Reasons
shipment_dateDate of free replacement shipment
Parameter Description
marketplace_idThe encrypted marketplace value
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify your products. SKUs are assigned by you as the seller
fnskuUnique identifier assigned by Amazon to items stored in and fulfilled from an Amazon fulfillment center
asinAmazon 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_nameThe title of your product
reserved_qtyThe total number of units in reserved status
reserved_customerordersThe number of units reserved for customer orders
reserved_fc_transfersThe number of units being transferred from one fulfillment center to another
reserved_fc_processingThe number of units that have been sidelined at the fulfillment center for additional processing
Parameter Description
return_dateReturn date
order_idAmazon”s unique identifying number for the order. Used for shipping confirmation and post-order processing
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
asinThe Amazon Standard Identification Number of the item
fnskuA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
product_nameThe title of your product
quantityThe total number of units reimbursed for this line item
fulfillment_center_idThe fulfillment center where the problem is identified
detailed_dispositionStatus of the product (examples: sellable, damaged)
reasonThe reason for the reimbursement (for example, Damaged: Warehouse)
statusCurrent status of this item within the order
license_plate_numberLicense plate number
customer_commentsCustomer comments
Parameter Description
marketplace_idThe encrypted marketplace value
primary_actionAction 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_strandedThis date shows how long your inventory has been stranded and without an active offer
Date_to_take_auto_removalDate to take auto removal
status_primaryIdentifies whether the offer is active, inactive, or incomplete. Incomplete offers are those missing price or condition
status_secondaryFor inactive offers, this field identifies the reasons – for example, blocked or out of stock
error_messageFor select inactive offers, additional information is displayed here – for example, quality alerts
stranded_reasonStranded reason
asinThe Amazon Standard Identification Number of the item
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller’s products. SKUs are assigned by the seller
fnskufnsku
product_nameThe title of your product
conditionThe condition of your product
fulfilled_byThe entity that fulfilled the item
fulfillable_qtyThe number of units of a SKU that you have in Amazon fulfillment centers and that are in unsellable condition
your_priceYour current selling price
unfulfillable_qtyThe number of units of a SKU that you have in Amazon fulfillment centers and that are in unsellable condition
reserved_quantityThe 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_qtyThe number of units of a SKU that you have shipped to Amazon and that are in transit
Parameter Description
MarketplaceIdThe identifier of the marketplace
featureDescriptionThe feature description
featureNameThe feature name
sellerEligibleWhen true, indicates that the seller is eligible to use the feature
Parameter Description
createdTimeThe date and time when the feed was created, in ISO 8601 date time format
feedIdThe identifier for the feed. This identifier is unique only in combination with a seller ID
feedTypeThe feed type
marketplaceIdsA list of identifiers for the marketplaces that the feed is applied to
processingEndTimeThe date and time when feed processing completed, in ISO 8601 date time format
processingStartTimeThe date and time when feed processing started, in ISO 8601 date time format
processingStatusThe processing status of the feed
resultFeedDocumentIdThe identifier for the feed document. This identifier is unique only in combination with a seller ID
Parameter Description
marketplace_idThe encrypted marketplace value
DateDate
Order_IDAmazon order number
CommentsComments
Rater_EmailRater Email
RatingRating on a scale of 1-5, but the API presently only provides Ratings of 3-5
ResponseResponse
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
TraceIdThe trace identifier used by sellers to look up transactions externally
AccountTailThe account tail of the payment instrument
BeginningBalance_CurrencyAmountThe monetary value
BeginningBalance_CurrencyCodeThe three-digit currency code in ISO 4217 format
ConvertedTotal_CurrencyAmountThe monetary value
ConvertedTotal_CurrencyCodeThe three-digit currency code in ISO 4217 format
FinancialEventGroupEndThe date and time at which the financial event group is closed. In ISO 8601 date time format
FinancialEventGroupIdA unique identifier for the financial event group
FinancialEventGroupStartThe date and time at which the financial event group is opened. In ISO 8601 date time format
FundTransferDateThe date and time when the disbursement or charge was initiated. Only present for closed settlements. In ISO 8601 date time format
FundTransferStatusThe status of the fund transfer
OriginalTotal_CurrencyAmountThe monetary value
OriginalTotal_CurrencyCodeThe three-digit currency code in ISO 4217 format
ProcessingStatusThe processing status of the financial event group indicates whether the balance of the financial event group is settled. Possible values: Open; Closed;
Parameter Description
marketplaceIdThe identifier for the marketplace the fulfillment order is placed against
displayableOrderIdA fulfillment order identifier submitted with the createFulfillmentOrder operation. Displays as the order identifier in recipient-facing materials such as the packing slip
deliveryWindowThe time range within which a Scheduled Delivery fulfillment order should be delivered
displayableOrderCommentA text block submitted with the createFulfillmentOrder operation. Displays in recipient-facing materials such as the packing slip
displayableOrderDateA date and time submitted with the createFulfillmentOrder operation. Displays as the order date in recipient-facing materials such as the packing slip
featureConstraintsA list of features and their fulfillment policies to apply to the order
fulfillmentActionSpecifies whether the fulfillment order should ship now or have an order hold put on it
fulfillmentOrderStatusThe current status of the fulfillment order
fulfillmentPolicyThe FulfillmentPolicy value specified when you submitted the createFulfillmentOrder operation
notificationEmailsA 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
receivedDateThe date and time that the fulfillment order was received by an Amazon fulfillment center
sellerFulfillmentOrderIdThe fulfillment order identifier submitted with the createFulfillmentOrder operation
shippingSpeedCategoryThe shipping method used for the fulfillment order
statusUpdatedDateThe date and time that the status of the fulfillment order last changed, in ISO 8601 date time format
Parameter Description
marketplace_idThe encrypted marketplace value
item_nameThe item name
item_descriptionThe item description
listing_idThe listing id
seller_skuStock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller
pricePrice 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
quantityThe total number of units reimbursed for this line item
open_dateOpen date
image_urlThe image url
item_is_marketplaceItem is marketplace
product_id_typeThe product id type
zshop_shipping_feeZshop shipping fee
item_noteThe item note
item_conditionNumeric 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_category1Zshop category1
zshop_browse_pathZshop browse path
zshop_storefront_featureZshop storefront feature
asin1asin1
asin2asin2
asin3asin3
will_ship_internationallyWill ship internationally
expedited_shippingExpedited shipping
zshop_boldfaceZshop boldface
product_idProduct id
bid_for_featured_placementBid for featured placement
add_deleteAdd delete
pending_quantityPending quantity
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
merchant_shipping_groupMerchant shipping group
Parameter Description
MarketplaceIdThe identifier of the marketplace
ShipmentIdThe shipment identifier submitted in the request
ShipmentNameThe name for the inbound shipment
ShipmentStatusIndicates 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
AreCasesRequiredIndicates 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
BoxContentsSourceWhere the seller provided box contents information for a shipment
ConfirmedNeedByDateDate by which the shipment must arrive at the Amazon fulfillment center to avoid delivery promise breaks for pre-ordered items
DestinationFulfillmentCenterIdAn Amazon fulfillment center identifier created by Amazon
EstimatedBoxContentsFee_FeePerUnit_Curre…The currency code
EstimatedBoxContentsFee_FeePerUnit_ValueThe amount
EstimatedBoxContentsFee_TotalFee_Currenc…The currency code
EstimatedBoxContentsFee_TotalFee_ValueThe amount
EstimatedBoxContentsFee_TotalUnitsThe number of units to ship
LabelPrepTypeThe type of label preparation that is required for the inbound shipment
ShipFromAddress_AddressLine1The street address information
ShipFromAddress_AddressLine2Additional street address information, if required
ShipFromAddress_CityThe city
ShipFromAddress_CountryCodeThe country code in two-character ISO 3166-1 alpha-2 format
ShipFromAddress_DistrictOrCountyThe district or county
ShipFromAddress_NameName of the individual or business
ShipFromAddress_PostalCodeThe 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_StateOrProvinceCodeThe 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
MarketplaceIdThe identifier of the marketplace
ASINThe Amazon Standard Identification Number (ASIN) of the item
featureNameThe name of the feature
fnSkuThe unique SKU used by Amazon’s fulfillment network
overlappingSkusOther seller SKUs that are shared across the same inventory
sellerSkuUsed 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
skuCountThe number of SKUs available for this service
Parameter Description
DateDate
FNSKUAmazon”s Fulfillment network SKU identifier
ASINThe Amazon Standard Identification Number of the item
MSKUUnique identifier that you assign to products
TitleThe title of your product
Event_TypeType of event that caused a change in inventory (shipment, receipt, vendor return, warehouse transfer, adjustment, or customer return)
Reference_IDTransaction ID (such as a shipment ID or adjustment ID)
QuantityThe total number of units reimbursed for this line item
Fulfillment_CenterFulfillment center where the inventory is stored
DispositionThe status of the unit
ReasonThe downloaded report displays codes, while the online report shows descriptions. See the Adjustment types and reason codes table at the top of Inventory adjustments for a full list of codes and descriptions
CountryCountry in which your products are stored
Parameter Description
DateDate
FNSKUAmazon”s Fulfillment network SKU identifier
ASINThe Amazon Standard Identification Number of the item
MSKUUnique identifier that you assign to products
TitleThe title of your product
DispositionThe status of the unit
Starting_Warehouse_BalanceUnits available for this product in Amazon fulfillment centers at the start of the time period
Customer_ShipmentsCompleted deliveries of customer orders that Amazon has fulfilled
Customer_ReturnsUnits that have been returned to Amazon fulfillment centers by customers and that have been returned to your inventory
Vendor_ReturnsVendor Returns are transactions that show what Items are shipped by you back to the Vendor
Warehouse_Transfer_In_OutAggregated number of units transshipped in and out from Amazon fulfillment centers
FoundUnits that were missing but have been found and returned to your inventory
LostUnits that are missing from your inventory in Amazon fulfillment centers and that may be eligible for reimbursement or have already been reimbursed
Damaged
DisposedUnits removed from your inventory and disposed of
Other_EventsUnits that were identified as damaged and that may be eligible for reimbursement or have already been reimbursed, as well as all other inventory dispositions that may not be covered under the other definitions
Ending_Warehouse_BalanceUnits available for this product in Amazon fulfillment centers at the end of the time period
Unknown_EventsUnits for which the specific event type is not known. This is primarily caused by parts of an event occurring across different reporting time periods. Expanding the reporting time period can reduce the number of unknown event units
LocationThe country or fulfillment center where your inventory is located, depending on your selection for the Inventory location parameter
In_Transit_Between_WarehousesUnits that are in transit between Amazon fulfillment centers
ReceiptsUnits received in shipments to Amazon fulfillment centers
Parameter Description
marketplace_idThe encrypted marketplace value
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller’s products. SKUs are assigned by the seller
asinThe Amazon Standard Identification Number of the item
pricePrice 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
quantityThe total number of units reimbursed for this line item
Business_PriceA special price that is available only for Amazon Business orders
Quantity_Price_TypeQuantity price type
Quantity_Lower_Bound_1Quantity lower bound
Quantity_Price_1Quantity price
Quantity_Lower_Bound_2Quantity lower bound
Quantity_Price_2Quantity price
Quantity_Lower_Bound_3Quantity lower bound
Quantity_Price_3Quantity price
Quantity_Lower_Bound_4Quantity lower bound
Quantity_Price_4Quantity price
Quantity_Lower_Bound_5Quantity lower bound
Quantity_Price_5Quantity price
Progressive_Price_TypeProgressive price type
Progressive_Lower_Bound_1Progressive lower bound
Progressive_Price_1Progressive price
Progressive_Lower_Bound_2Progressive lower bound
Progressive_Price_2Progressive price
Progressive_Lower_Bound_3Progressive lower bound
Progressive_Price_3Progressive price
Parameter Description
MarketplaceIdThe identifier of the marketplace
ASINThe Amazon Standard Identification Number (ASIN) of an item
conditionThe condition of the item as described by the seller (for example, New Item)
fnSkuAmazon’s fulfillment network SKU identifier
granularityIdThe granularity ID for the specified granularity type. When granularityType is Marketplace, specify the marketplaceId
granularityTypeThe granularity type for the inventory aggregation level
inventoryDetails_fulfillableQuantityThe 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_inboundShippedQuantityThe number of units in an inbound shipment that you have notified Amazon about and have provided a tracking number
inventoryDetails_inboundWorkingQuantityThe 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
lastUpdatedTimeThe date and time that any quantity was last updated
productNameThe localized language product title of the item within the specific marketplace
sellerSkuThe seller SKU of the item
totalQuantityThe total number of units in an inbound shipment or in Amazon fulfillment centers
Parameter Description
MarketplaceIdThe identifier of the marketplace
Identifiers_MarketplaceASIN_ASINThe Amazon Standard Identification Number (ASIN) of the item
Identifiers_MarketplaceASIN_MarketplaceI…A marketplace identifier
Identifiers_SKUIdentifier_MarketplaceIdA marketplace identifier
Identifiers_SKUIdentifier_SellerIdThe seller identifier submitted for the operation
Identifiers_SKUIdentifier_SellerSKUThe seller stock keeping unit (SKU) of the item
AttributeSets_ActorThe actor attributes of the item
AttributeSets_ArtistThe artist attributes of the item
AttributeSets_AspectRatioThe aspect ratio attribute of the item
AttributeSets_AudienceRatingThe audience rating attribute of the item
AttributeSets_AuthorThe author attributes of the item
AttributeSets_BackFindingThe back finding attribute of the item
AttributeSets_BandMaterialTypeThe band material type attribute of the item
AttributeSets_BindingThe binding attribute of the item
AttributeSets_BlurayRegionThe Bluray region attribute of the item
AttributeSets_BrandThe brand attribute of the item
AttributeSets_CeroAgeRatingThe CERO age rating attribute of the item
AttributeSets_ChainTypeThe chain type attribute of the item
AttributeSets_ClaspTypeThe clasp type attribute of the item
AttributeSets_ColorThe color attribute of the item
AttributeSets_CpuManufacturerThe CPU manufacturer attribute of the item
AttributeSets_CpuSpeed_UnitsThe unit of the decimal value
AttributeSets_CpuSpeed_valueThe decimal value
AttributeSets_CpuTypeThe CPU type attribute of the item
AttributeSets_DepartmentThe department attribute of the item
AttributeSets_DirectorThe director attributes of the item
AttributeSets_DisplaySize_UnitsThe unit of the decimal value
AttributeSets_DisplaySize_valueThe decimal value
AttributeSets_EditionThe edition attribute of the item
AttributeSets_EpisodeSequenceThe episode sequence attribute of the item
AttributeSets_EsrbAgeRatingThe ESRB age rating attribute of the item
AttributeSets_FeatureThe feature attributes of the item
AttributeSets_FlavorThe flavor attribute of the item
AttributeSets_FormatThe format attributes of the item
AttributeSets_GemTypeThe gem type attributes of the item
AttributeSets_GenreThe genre attribute of the item
AttributeSets_GolfClubFlexThe golf club flex attribute of the item
AttributeSets_GolfClubLoft_UnitsThe unit of the decimal value
AttributeSets_GolfClubLoft_valueThe decimal value
AttributeSets_HandOrientationThe hand orientation attribute of the item
AttributeSets_HardDiskInterfaceThe hard disk interface attribute of the item
AttributeSets_HardDiskSize_UnitsThe unit of the decimal value
AttributeSets_HardDiskSize_valueThe decimal value
AttributeSets_HardwarePlatformThe hardware platform attribute of the item
AttributeSets_HazardousMaterialTypeThe hazardous material type attribute of the item
AttributeSets_IsAdultProductThe adult product attribute of the item
AttributeSets_IsAutographedThe autographed attribute of the item
AttributeSets_IsEligibleForTradeInThe is eligible for trade in attribute of the item
AttributeSets_IsMemorabiliaThe is memorabilia attribute of the item
AttributeSets_IssuesPerYearThe 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_UnitsThe unit of the decimal value
AttributeSets_ItemDimensions_Width_valueThe decimal value
AttributeSets_ItemPartNumberThe item part number attribute of the item
AttributeSets_LabelThe label attribute of the item
AttributeSets_LegalDisclaimerThe legal disclaimer attribute of the item
AttributeSets_ListPrice_AmountThe amount
AttributeSets_ListPrice_CurrencyCodeThe currency code of the amount
AttributeSets_ManufacturerThe 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_MaterialTypeThe material type attributes of the item
AttributeSets_MaximumResolution_UnitsThe unit of the decimal value
AttributeSets_MaximumResolution_valueThe decimal value
AttributeSets_MediaTypeThe media type attributes of the item
AttributeSets_MetalStampThe metal stamp attribute of the item
AttributeSets_MetalTypeThe metal type attribute of the item
AttributeSets_ModelThe model attribute of the item
AttributeSets_NumberOfDiscsThe number of discs attribute of the item
AttributeSets_NumberOfIssuesThe number of issues attribute of the item
AttributeSets_NumberOfItemsThe number of items attribute of the item
AttributeSets_NumberOfPagesThe number of pages attribute of the item
AttributeSets_NumberOfTracksThe number of tracks attribute of the item
AttributeSets_OperatingSystemThe operating system attributes of the item
AttributeSets_OpticalZoom_UnitsThe unit of the decimal value
AttributeSets_OpticalZoom_valueThe 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_PackageQuantityThe package quantity attribute of the item
AttributeSets_PartNumberThe part number attribute of the item
AttributeSets_PegiRatingThe PEGI rating attribute of the item
AttributeSets_PlatformThe platform attributes of the item
AttributeSets_ProcessorCountThe processor count attribute of the item
AttributeSets_ProductGroupThe product group attribute of the item
AttributeSets_ProductTypeNameThe product type name attribute of the item
AttributeSets_ProductTypeSubcategoryThe product type subcategory attribute of the item
AttributeSets_PublicationDateThe publication date attribute of the item
AttributeSets_PublisherThe publisher attribute of the item
AttributeSets_RegionCodeThe region code attribute of the item
AttributeSets_ReleaseDateThe release date attribute of the item
AttributeSets_RingSizeThe ring size attribute of the item
AttributeSets_RunningTime_UnitsThe unit of the decimal value
AttributeSets_RunningTime_valueThe decimal value
AttributeSets_ScentThe scent attribute of the item
AttributeSets_SeasonSequenceThe season sequence attribute of the item
AttributeSets_SeikodoProductCodeThe Seikodo product code attribute of the item
AttributeSets_ShaftMaterialThe shaft material attribute of the item
AttributeSets_SizeThe size attribute of the item
AttributeSets_SizePerPearlThe size per pearl attribute of the item
AttributeSets_SmallImage_Height_UnitsThe unit of the decimal value
AttributeSets_SmallImage_Height_valueThe decimal value
AttributeSets_SmallImage_URLThe image URL attribute of the item
AttributeSets_SmallImage_Width_UnitsThe unit of the decimal value
AttributeSets_SmallImage_Width_valueThe decimal value
AttributeSets_StudioThe studio attribute of the item
AttributeSets_SubscriptionLength_UnitsThe unit of the decimal value
AttributeSets_SubscriptionLength_valueThe decimal value
AttributeSets_SystemMemorySize_UnitsThe unit of the decimal value
AttributeSets_SystemMemorySize_valueThe decimal value
AttributeSets_SystemMemoryTypeThe system memory type attribute of the item
AttributeSets_TheatricalReleaseDateThe theatrical release date attribute of the item
AttributeSets_TitleThe title attribute of the item
AttributeSets_TotalDiamondWeight_UnitsThe unit of the decimal value
AttributeSets_TotalDiamondWeight_valueThe decimal value
AttributeSets_TotalGemWeight_UnitsThe unit of the decimal value
AttributeSets_TotalGemWeight_valueThe decimal value
AttributeSets_WarrantyThe warranty attribute of the item
AttributeSets_WeeeTaxValue_AmountThe amount
AttributeSets_WeeeTaxValue_CurrencyCodeThe currency code of the amount
CreatorThe creator attributes of the item
LanguagesThe languages attribute of the item
Parameter Description
marketplace_idThe encrypted marketplace value
skuStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller’s products. SKUs are assigned by the seller
product_nameThe title of your product
asinThe Amazon Standard Identification Number of the item
field_nameField name
alert_typeAlert type
current_valueCurrent value
last_updatedLast updated
alert_nameAlert name
statusCurrent status of this item within the order
explanationExplanation
Parameter Description
asinThe Amazon Standard Identification Number (ASIN) of the item
marketplaceIdA marketplace identifier. Identifies the Amazon marketplace where the restriction is enforced
conditionTypeThe condition that applies to the restriction
messageA message describing the reason for the restriction
reasonCodeA code indicating why the listing is restricted
Parameter Description
marketplaceIdAmazon marketplace identifier
sellerIdA selling partner identifier, such as a merchant account or vendor code
asinAmazon Standard Identification Number (ASIN) of the listings item
skuA selling partner provided identifier for an Amazon listing
conditionTypeIdentifies the condition of the listings item
fnSkuFulfillment network stock keeping unit is an identifier used by Amazon fulfillment centers to identify each unique item
itemNameName, or title, associated with an Amazon catalog item
mainImage_heightHeight of the image in pixels
mainImage_linkLink, or URL, for the image
mainImage_widthWidth of the image in pixels
productTypeThe Amazon product type of the listings item
statusStatuses that apply to the listings item
createdDateDate the listings item was created, in ISO 8601 format
lastUpdatedDateDate the listings item was last updated, in ISO 8601 format
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_idThe encrypted marketplace value
item_nameThe item name
item_descriptionThe item description
listing_idThe listing id
seller_skuStock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller
pricePrice 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
quantityThe total number of units reimbursed for this line item
open_dateOpen date
image_urlThe image url
item_is_marketplaceItem is marketplace
product_id_typeThe type of product id
zshop_shipping_feeZshop shipping fee
item_noteThe item note
item_conditionNumeric 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_category1Zshop category1
zshop_browse_pathZshop browse path
zshop_storefront_featureZshop storefront feature
asin1Asin1
asin2Asin2
asin3Asin3
will_ship_internationallyWill ship internationally
expedited_shippingExpedited shipping
zshop_boldfaceZshop boldface
product_idProduct id
bid_for_featured_placementBid for featured placement
add_deleteAdd delete
pending_quantityPending quantity
fulfillment_channelFulfillment channel
Business_PriceA special price that is available only for Amazon Business orders
Quantity_Price_TypeQuantity price type
Quantity_Lower_Bound_1Quantity lower bound
Quantity_Price_1Quantity price
Quantity_Lower_Bound_2Quantity lower bound
Quantity_Price_2Quantity price
Quantity_Lower_Bound_3Quantity lower bound
Quantity_Price_3Quantity price
Quantity_Lower_Bound_4Quantity lower bound
Quantity_Price_4Quantity price
Quantity_Lower_Bound_5Quantity lower bound
Quantity_Price_5Quantity price
merchant_shipping_groupMerchant shipping group
Progressive_Price_TypeProgressive price type
Progressive_Lower_Bound_1Progressive lower bound
Progressive_Price_1Progressive price
Progressive_Lower_Bound_2Progressive lower bound
Progressive_Price_2Progressive price
Progressive_Lower_Bound_3Progressive lower bound
Progressive_Price_3Progressive price
Minimum_order_quantityMinimum order quantity
Sell_remainderSell remainder
Parameter Description
marketplace_idThe encrypted marketplace value
seller_skuStock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller
quantityThe total number of units reimbursed for this line item
pricePrice 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_PriceA special price that is available only for Amazon Business orders
Quantity_Price_TypeQuantity price type
Quantity_Lower_Bound_1Quantity lower bound
Quantity_Price_1Quantity price
Quantity_Lower_Bound_2Quantity lower bound
Quantity_Price_2Quantity price
Quantity_Lower_Bound_3Quantity lower bound
Quantity_Price_3Quantity price
Quantity_Lower_Bound_4Quantity lower bound
Quantity_Price_4Quantity price
Quantity_Lower_Bound_5Quantity lower bound
Quantity_Price_5Quantity price
Progressive_Price_TypeProgressive price type
Progressive_Lower_Bound_1Progressive lower bound
Progressive_Price_1Progressive price
Progressive_Lower_Bound_2Progressive lower bound
Progressive_Price_2Progressive price
Progressive_Lower_Bound_3Progressive lower bound
Progressive_Price_3Progressive 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
MarketplaceIdThe identifier for the marketplace
interval_startThe 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_endThe 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_amountThe currency amount
averageUnitPrice_CurrencyCodeThree-digit currency code. In ISO 4217 format
orderCountThe number of orders based on the specified filters
orderItemCountThe number of order items based on the specified filters
totalSales_amountThe currency amount
totalSales_CurrencyCodeThree-digit currency code. In ISO 4217 format
unitCountThe number of units in orders based on the specified filters
Fine order data, delivered via slow API, with expected rate of 10-15k orders per 24h. Note that on large accounts this job can take several days or weeks to complete
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
Parameter Description
amazon_order_idAmazon”s unique, displayable identifier for an order
merchant_order_idA unique identifier optionally supplied for the order by the Merchant
purchase_dateThe date the order was placed
last_updated_dateThe date of the most recent order update
order_statusCurrent status of the customer order
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
sales_channelChannel through which the order was purchased
order_channelThe sub channel through which a sale was made for CBA/WBA orders
ship_service_levelAn enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., standard versus expedited)
product_nameThe short title for the product, displayed in bold on the detail web page and in the title bar of the browser window
skuA merchant-defined unique identifier for a product
asinAmazon inventory ID
item_statusCurrent status of this item within the order
quantityThe number of this item that were purchased
currencyThe currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY
item_priceThe amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price
item_taxThe amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price
shipping_priceThe amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price
shipping_taxThe amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price
gift_wrap_priceThe amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price
gift_wrap_taxThe amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price
item_promotion_discountTotal of all promotion discounts applied to the order item
ship_promotion_discountPromotion discount applied to shipping
ship_cityThe city of a standard address
ship_stateThe state or region of a standard address
ship_postal_codeThe postal (zip) code of a standard address
ship_countryISO 3166 standard two-letter country code
promotion_idsList of all item promotions applied to this order item
is_business_orderIs business order
purchase_order_number
price_designation
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
AmazonOrderIDAmazon Order ID
MerchantOrderIDMerchant Order ID
PurchaseDatePurchase Date
LastUpdatedDateLast Updated Date
OrderStatusOrder Status
SalesChannelSales Channel
FulfillmentData_FulfillmentChannelFulfillment Channe lD
FulfillmentData_ShipServiceLevelFulfillment Data: Address City
FulfillmentData_Address_CountryFulfillment Data: Address Country
FulfillmentData_Address_StateFulfillment Data: Address State
FulfillmentData_Address_PostalCodeFulfillmentData Address PostalCode
FulfillmentData_Address_CityFulfillment Data: Address City
IsBusinessOrderIs Business Order
Parameter Description
amazon_order_idAmazon”s unique, displayable identifier for an order
merchant_order_idA unique identifier optionally supplied for the order by the Merchant
purchase_dateThe date the order was placed
last_updated_dateThe date of the most recent order update
order_statusCurrent status of the customer order
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
sales_channelChannel through which the order was purchased
order_channelThe sub channel through which a sale was made for CBA/WBA orders
ship_service_levelAn enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., standard versus expedited)
product_nameThe short title for the product, displayed in bold on the detail web page and in the title bar of the browser window
skuA merchant-defined unique identifier for a product
asinAmazon inventory ID
item_statusCurrent status of this item within the order
quantityThe number of this item that were purchased
currencyThe currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY
item_priceThe amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price
item_taxThe amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price
shipping_priceThe amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price
shipping_taxThe amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price
gift_wrap_priceThe amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price
gift_wrap_taxThe amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price
item_promotion_discountTotal of all promotion discounts applied to the order item
ship_promotion_discountPromotion discount applied to shipping
ship_cityThe city of a standard address
ship_stateThe state or region of a standard address
ship_postal_codeThe postal (zip) code of a standard address
ship_countryISO 3166 standard two-letter country code
promotion_idsList of all item promotions applied to this order item
is_business_orderIs business order
purchase_order_numberPurchase order number
price_designationPrice designation
Parameter Description
amazon_order_idAmazon”s unique, displayable identifier for an order
merchant_order_idA unique identifier optionally supplied for the order by the Merchant
purchase_dateThe date the order was placed
last_updated_dateThe date of the most recent order update
order_statusCurrent status of the customer order
fulfillment_channelIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
sales_channelChannel through which the order was purchased
order_channelThe sub channel through which a sale was made for CBA/WBA orders
ship_service_levelAn enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., standard versus expedited)
product_nameThe short title for the product, displayed in bold on the detail web page and in the title bar of the browser window
skuA merchant-defined unique identifier for a product
asinAmazon inventory ID
item_statusCurrent status of this item within the order
quantityThe number of this item that were purchased
currencyThe currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY
item_priceThe amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price
item_taxThe amount the buyer paid for item tax. Amount is aggregate of the quantity, not unit price
shipping_priceThe amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price
shipping_taxThe amount the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price
gift_wrap_priceThe amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price
gift_wrap_taxThe amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price
item_promotion_discountTotal of all promotion discounts applied to the order item
ship_promotion_discountPromotion discount applied to shipping
ship_cityThe city of a standard address
ship_stateThe state or region of a standard address
ship_postal_codeThe postal (zip) code of a standard address
ship_countryISO 3166 standard two-letter country code
promotion_idsList of all item promotions applied to this order item
is_business_orderIs business order
purchase_order_numberPurchase order number
price_designationPrice designation
Properties for Parent categories to which an item belongs, based on the specified ASIN or SellerSKU
Parameter Description
marketplaceIdThe identifier of the marketplace
ProductCategoryIdThe identifier for the product category (or browse node)
ProductCategoryNameThe name of the product category (or browse node)
parentThe parent product category
Parameter Description
marketplaceIdThe identifier of the marketplace
ASINThe Amazon Standard Identification Number (ASIN) of the item
Product_Identifiers_MarketplaceASIN_ASINThe 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_FulfillmentChannelThe fulfillment channel for the offer listing. Possible values: Amazon – Fulfilled by Amazon; Merchant – Fulfilled by the seller;
Product_Offers_ItemConditionThe item condition for the offer listing. Possible values: New, Used, Collectible, Refurbished, or Club
Product_Offers_ItemSubConditionThe 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_AmountThe monetary value
Product_Offers_RegularPrice_CurrencyCodeThe currency code in ISO 4217 format
Product_Offers_SellerSKUThe seller stock keeping unit (SKU) of the item
statusThe status of the operation
Parameter Description
marketplace_idThe encrypted marketplace value
createdDateTimeCreated Date Time
endDateTimeEnd Date Time
glanceViewsGlance views refers to the number of times a PDP (Product Detail Page) is viewed
lastUpdatedDateTimeLast Updated Date Time
marketplaceIdMarketplace Id
merchantIdmerchant Id
promotionIdPromotion Id
promotionNamePromotion Name
revenueRevenue
revenueCurrencyCodeRevenue Currency Code
startDateTimeStart Date Time
statusStatus
typeType
unitsSoldUnits Sold
Parameter Description
AmazonOrderIDAmazon Order ID
MerchantOrderIDMerchant Order ID
PurchaseDatePurchase Date
LastUpdatedDateLast Updated Date
OrderStatusOrder Status
SalesChannelSales Channel
FulfillmentData_FulfillmentChannelFulfillment Channe lD
FulfillmentData_ShipServiceLevelFulfillment Data: Address City
FulfillmentData_Address_CountryFulfillment Data: Address Country
FulfillmentData_Address_StateFulfillment Data: Address State
FulfillmentData_Address_PostalCodeFulfillmentData Address PostalCode
FulfillmentData_Address_CityFulfillment Data: Address City
IsBusinessOrderIs Business Order
Parameter Description
marketplace_idThe encrypted marketplace value
startDate
endDate
asinAmazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page
ordersThe number of orders
repeatCustomersPctTotalRepeat customers pct total
repeatPurchaseRevenue_amountRepeat purchase revenue amount
repeatPurchaseRevenue_currencyCodeRepeat purchase revenue currency code
repeatPurchaseRevenuePctTotalRepeat purchase revenue pct total
uniqueCustomersUnique customers
Parameter Description
reportIdThe identifier for the report. This identifier is unique only in combination with a seller ID
reportDocumentIdThe 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
reportTypeThe report type
reportScheduleIdThe identifier of the report schedule that created this report (if any). This identifier is unique only in combination with a seller ID
createdTimeThe date and time when the report was created
dataStartTimeThe start of a date and time range used for selecting the data to report
dataEndTimeThe end of a date and time range used for selecting the data to report
marketplaceIdsA 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
processingStartTimeThe date and time when the report processing started, in ISO 8601 date time format
processingEndTimeThe date and time when the report processing completed, in ISO 8601 date time format
processingStatusThe 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_DocumentVersionHeader DocumentVersion
MessageTypeMessage Type
MessageFor select inactive offers, additional information is displayed here – for example, quality alerts
Parameter Description
marketplace_idThe encrypted marketplace value
order_idAmazon order number
a_to_z_claimIndicates whether an A-To-Z Claim was filed by the buyer. Either N for No or Y for Yes
amazon_rma_idThe RMA Id assigned by Amazon
is_primeNotes whether or not the item purchased was a Prime order or not. Will report Y for Prime and N for not Prime
label_to_be_paid_byIdentifies who will pay for the return label. Will report Customer if customer will pay and Seller if seller will pay
order_amountRevenue of item for returns reporting
order_dateAmazon order date
order_quantityQuantity ordered for Returns reporting, but not the quantity returned. Use Return Quantity to compare this metric to actual amount returned
return_request_dateReturn request date
return_request_statusThe status of the Return (Approved, etc.)
return_typeThe type of return. Will typically report C-Returns for a customer return
Parameter Description
marketplace_idThe encrypted marketplace value
dateDate
childAsinChild Asin
parentAsinParent Asin
skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
salesByAsin_orderedProductSales_amountOrdered Product Sales Amount
salesByAsin_orderedProductSales_currency…Ordered Product Sales Currency Code
salesByAsin_orderedProductSalesB2B_amoun…Ordered Product Sales B2B Amount
salesByAsin_orderedProductSalesB2B_curre…Ordered Product Sales B2B Currency Code
salesByAsin_totalOrderItemsTotal Ordered
salesByAsin_totalOrderItemsB2BTotal Ordered B2B
salesByAsin_unitsOrderedUnits Ordered
salesByAsin_unitsOrderedB2BUnits Ordered B2B
salesByDate_averageSalesPerOrderItem_amo…Average Sales Per Order Item Amount
salesByDate_averageSalesPerOrderItem_cur…Average Sales Per Order Item Currency Code
salesByDate_averageSalesPerOrderItemB2B_…Average Sales Per Order Item B2B Amount
salesByDate_averageSalesPerOrderItemB2B_…
salesByDate_averageSellingPrice_amountAverage Selling Price Amount
salesByDate_averageSellingPrice_currency…Average Selling Price Currency Code
salesByDate_averageSellingPriceB2B_amoun…Average Selling Price B2B Amount
salesByDate_averageSellingPriceB2B_curre…Average Selling Price B2B Currency Code
salesByDate_averageUnitsPerOrderItemAverage Units Per Order Item
salesByDate_averageUnitsPerOrderItemB2BAverage Units Per Order Item B2B
salesByDate_claimsAmount_amountClaims Amount
salesByDate_claimsAmount_currencyCodeClaims Amount Currency Code
salesByDate_claimsGrantedClaims Granted
salesByDate_orderedProductSales_amountOrdered Product Sales Amount
salesByDate_orderedProductSales_currency…Ordered Product Sales Currency Code
salesByDate_orderedProductSalesB2B_amoun…Ordered Product Sales B2B Amount
salesByDate_orderedProductSalesB2B_curre…Ordered Product Sales B2B Currency Code
salesByDate_ordersShippedOrders Shipped
salesByDate_refundRateRefundvRate
salesByDate_shippedProductSales_amountShipped Product Sales Amount
salesByDate_shippedProductSales_currency…Shipped Product Sales Currency Code
salesByDate_totalOrderItemsTotal Order Items
salesByDate_totalOrderItemsB2BTotal Order Items B2B
salesByDate_unitsOrderedUnits Ordered
salesByDate_unitsOrderedB2BUnits Ordered B2B
salesByDate_unitsRefundedUnits Refunded
salesByDate_unitsShippedUnits Shipped
trafficByAsin_browserPageViewsBrowser Page Views
trafficByAsin_browserPageViewsPercentageBrowser Page Views Percentage
trafficByAsin_browserSessionPercentageBrowser Sessions Percentage
trafficByAsin_browserSessionsBrowser Sessions
trafficByAsin_buyBoxPercentageBuy Box Percentage
trafficByAsin_mobileAppPageViewsMobile App Page Views
trafficByAsin_mobileAppPageViewsPercenta…Mobile App Page Views Percentage
trafficByAsin_mobileAppSessionPercentageMobile App Sessions Percentage
trafficByAsin_mobileAppSessionsMobile App Sessions
trafficByAsin_pageViewsPage Views
trafficByAsin_pageViewsPercentagePage Views Percentage
trafficByAsin_sessionPercentageSessions Percentage
trafficByAsin_sessionsSessions
trafficByAsin_unitSessionPercentageUnit Session Percentage
trafficByAsin_unitSessionPercentageB2BUnit Session Percentage B2B
trafficByDate_averageOfferCountAverage Offer Count
trafficByDate_averageParentItemsAverage Parent Items
trafficByDate_browserPageViewsBrowser Page Views
trafficByDate_browserSessionsBrowser Sessions
trafficByDate_buyBoxPercentageBuy Box Percentage
trafficByDate_feedbackReceivedFeedback Received
trafficByDate_mobileAppPageViewsMobile App Page Views
trafficByDate_mobileAppSessionsMobile App Sessions
trafficByDate_negativeFeedbackReceivedNegative Feedback Received
trafficByDate_orderItemSessionPercentageOrder Item Session Percentage
trafficByDate_orderItemSessionPercentage…Order Item Session Percentage B2B
trafficByDate_pageViewsPage Views
trafficByDate_receivedNegativeFeedbackRa…Received Negative Feedback Rate
trafficByDate_sessionsSessions
trafficByDate_unitSessionPercentageUnit Session Percentage
trafficByDate_unitSessionPercentageB2BUnit Session Percentage B2B
Parameter Description
marketplaceIdSpecifies the marketplace
accountStatusAccount status
performanceMetricPerformance metric
fulfillmentTypeFulfillment type
reportingDateFromReporting date from
reportingDateToReporting date to
statusStatus for performance metric
targetConditionTarget condition
targetValueTarget value
rateRate
defectsCountDefects count
cancellationCountCancellation count
chargebacksCountChargebacks count
chargebacksStatusChargebacks status
claimsCountClaims count
claimsStatusClaims status
invoiceDefectCountInvoice defect count
invoiceDefectStatusInvoice defect status
lateInvoiceCountLate invoice count
lateInvoiceStatusLate invoice status
lateShipmentCountLate shipment count
missingInvoiceCountMissing invoice count
missingInvoiceStatusMissing invoice status
negativeFeedbackCountNegative feedback count
negativeFeedbackStatusNegative feedback status
onTimeDeliveryCountOn time delivery count
orderCountOrder count
orderWithDefectsCountOrder with defects count
orderWithDefectsStatusOrder with defects status
shipmentCountShipment count
shipmentCountWithValidTrackingshipment count with valid tracking
validTrackingCountValid tracking count
Parameter Description
MarketplaceIdThe marketplace identifier
serviceJobIdThe service job identifier
serviceOrderIdThe Amazon-defined identifier for an order placed by the buyer, in 3-7-7 format
buyer_buyerIdThe identifier of the buyer. Pattern : “^[A-Z0-9]
  • $”
  • buyer_isPrimeMemberWhen true, the service is for an Amazon Prime buyer
    buyer_nameThe name of the buyer
    buyer_phoneThe phone number of the buyer
    createTimeThe date and time of the creation of the job, in ISO 8601 format
    preferredAppointmentTimesA list of appointment windows preferred by the buyer. Included only if the buyer selected appointment windows when creating the order
    scopeOfWork_asinThe Amazon Standard Identification Number (ASIN) of the service job
    scopeOfWork_quantityThe number of service jobs
    scopeOfWork_requiredSkillsA list of skills required to perform the job
    scopeOfWork_titleThe title of the service job
    seller_sellerIdThe identifier of the seller of the service job. Pattern : “^[A-Z0-9]
  • $”
  • serviceJobProvider_serviceJobProviderIdThe identifier of the service job provider. Pattern : “^[A-Z0-9]
  • $”
  • serviceJobStatusThe status of the service job
    serviceLocation_address_addressLine1The first line of the address
    serviceLocation_address_addressLine2Additional address information, if required
    serviceLocation_address_addressLine3Additional address information, if required
    serviceLocation_address_cityThe city
    serviceLocation_address_CountryCodeThe two digit country code, in ISO 3166-1 alpha-2 format
    serviceLocation_address_countyThe county
    serviceLocation_address_districtThe district
    serviceLocation_address_nameThe name of the person, business, or institution
    serviceLocation_address_phoneThe phone number
    serviceLocation_address_postalCodeThe postal code. This can contain letters, digits, spaces, and/or punctuation
    serviceLocation_address_stateOrRegionThe state or region
    serviceLocation_serviceLocationTypeThe location of the service job
    Settlement report, delivered via Flat File V2 Settlement report
    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
    reportIdThe identifier for the report. This identifier is unique only in combination with a seller ID
    reportCreatedTimeThe date and time when the report was created
    order_idAmazon’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_dateThe 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_idAmazon’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_dateThe start date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time)
    settlement_end_dateThe end date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time)
    deposit_dateThe 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_amountThe sales amount to be deposited into the seller’s bank account
    currencyCurrency code for the marketplace, which is also the currency code for all prices listed in the records
    skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
    adjustment_idTransaction ID for Adjustments
    direct_payment_amountDirect payment amount
    direct_payment_typeDirect payment type
    fulfillment_idIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
    item_related_fee_amountThe amount of a particular fee charged in relation to this item
    item_related_fee_typeThe type of fee charged in the item-related-fee-amount column
    marketplace_nameThe name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters
    merchant_adjustment_item_idMerchant adjustment item id
    merchant_order_idID assigned by Amazon or sellers
    merchant_order_item_idMerchant order item id
    misc_fee_amountNo longer used
    order_fee_amountThe 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_typeThe type of fee charged in the order-fee-amount column
    order_item_codeAmazon’s unique, displayable identifier for an item within the order. This is a numeric value. The total number of digits is 14
    other_amountAdditional 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_amountThe amount of miscellaneous fees charged to your seller account
    other_fee_reason_descriptionMiscellaneous fees that are not related to the monthly selling plan
    price_amountThe 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_typeThe type of price specified in the price-amount column
    promotion_amountThe 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_idSeller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50
    promotion_typeThe type of promotion referred to by the values in the promotion-id and promotion-amount columns
    quantity_purchasedThe number of these items that were purchased. This is a numeric value. The maximum number of digits is 12
    shipment_fee_amountThe amount of the shipping fee
    shipment_fee_typeThe type of shipping Fee as Order, Adjustment, or MiscEvent
    shipment_idOrder transaction type ID
    transaction_typeText description of transaction type
    Parameter Description
    reportIdThe identifier for the report. This identifier is unique only in combination with a seller ID
    reportCreatedTimeThe date and time when the report was created
    order_idAmazon’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_dateThe date that the item (order, adjustment, misc or other) was debited or credited to the seller’s account
    settlement_idAmazon’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_dateThe start date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time)
    settlement_end_dateThe end date of the settlement period. This is an alphanumeric value. The total number of characters is 25. (Greenwich Mean Time)
    deposit_dateThe 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_amountThe sales amount to be deposited into the seller’s bank account
    currencyCurrency code for the marketplace, which is also the currency code for all prices listed in the records
    skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
    adjustment_idTransaction ID for Adjustments
    amountTax amount paid by customer
    amount_descriptionAmount description
    amount_typeAmount type
    fulfillment_idIndicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
    marketplace_nameThe name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters
    merchant_adjustment_item_idMerchant adjustment item id
    merchant_order_idID assigned by Amazon or sellers
    merchant_order_item_idMerchant order item id
    order_item_codeAmazon’s unique, displayable identifier for an item within the order. This is a numeric value. The total number of digits is 14
    posted_date_timeThe date that the item (order, adjustment, misc or other) was debited or credited to the seller’s account
    promotion_idSeller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50
    quantity_purchasedThe number of these items that were purchased. This is a numeric value. The maximum number of digits is 12
    shipment_idOrder transaction type ID
    transaction_typeText description of transaction type
    Parameter Description
    MarketplaceIdThe identifier of the marketplace
    ShipmentIdA shipment identifier originally returned by the createInboundShipmentPlan operation
    FulfillmentNetworkSKUAmazon’s fulfillment network SKU of the item
    QuantityInCaseThe 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
    QuantityReceivedThe item quantity that has been received at an Amazon fulfillment center
    QuantityShippedThe item quantity that you are shipping
    ReleaseDateThe date that a pre-order item will be available for sale
    SellerSKUThe seller SKU of the item
    Parameter Description
    SKUStock Keeping Units (SKUs) are unique blocks of letters or numbers that identify each seller”s products. SKUs are assigned by the seller
    FNSKUA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
    ASINThe Amazon Standard Identification Number of the item
    Product_NameProduct Name
    Enrolled_in_SnL_Enrolled in SnL
    MarketplaceThe marketplace in which the order was placed
    Your_SnL_PriceYour 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_idThe encrypted marketplace value
    skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
    snapshot_dateReport data are current as of the date in this field
    week_1_start_dateWeek 1 start date
    product_nameThe title of your product
    active_subscriptionsTotal number of active subscriptions for this SKU
    asinThe Amazon Standard Identification Number of the item
    countryCountry in which your products are stored
    estimated_avg_sns_discount_next_8_weeksEstimated average discount expected to be applied to your Subscribe & Save orders over the next 8 weeks
    fnskuAmazon’s Fulfillment network SKU identifier
    offer_stateOffer state
    scheduled_sns_units_week_1Number of Subscribe & Save items scheduled for week 1
    scheduled_sns_units_week_2Number of Subscribe & Save items scheduled for week 2
    scheduled_sns_units_week_3Number of Subscribe & Save items scheduled for week 3
    scheduled_sns_units_week_4Number of Subscribe & Save items scheduled for week 4
    scheduled_sns_units_week_5Number of Subscribe & Save items scheduled for week 5
    scheduled_sns_units_week_6Number of Subscribe & Save items scheduled for week 6
    scheduled_sns_units_week_7Number of Subscribe & Save items scheduled for week 7
    scheduled_sns_units_week_8Number of Subscribe & Save items scheduled for week 8
    Parameter Description
    marketplace_idThe encrypted marketplace value
    skuThe merchant SKU (stock keeping unit) is the unique identifier you assigned to your product
    snapshot_dateReport data are current as of the date in this field
    week_1_start_dateWeek 1 start date
    product_nameThe title of your product
    asinThe Amazon Standard Identification Number of the item
    countryCountry in which your products are stored
    fnskuAmazon’s Fulfillment network SKU identifier
    offer_stateOffer state
    oos_rate_week_1Out-of-stock rate for week 1
    oos_rate_week_2Out-of-stock rate for week 2
    oos_rate_week_3Out-of-stock rate for week 3
    oos_rate_week_4Out-of-stock rate for week 4
    sns_discount_week_1Average discount applied to your orders for week 1
    sns_discount_week_2Average discount applied to your orders for week 2
    sns_discount_week_3Average discount applied to your orders for week 3
    sns_discount_week_4Average discount applied to your orders for week 4
    sns_sale_price_week_1Average sale price for items shipped for week 1
    sns_sale_price_week_2Average sale price for items shipped for week 2
    sns_sale_price_week_3Average sale price for items shipped for week 3
    sns_sale_price_week_4Average sale price for items shipped for week 4
    sns_units_shipped_week_1Number of items shipped for week 1
    sns_units_shipped_week_2Number of items shipped for week 2
    sns_units_shipped_week_3Number of items shipped for week 3
    sns_units_shipped_week_4Number of items shipped for week 4
    Parameter Description
    destinationIdThe identifier for the destination where notifications will be delivered
    payloadVersionThe version of the payload object to be used in the notification
    subscriptionIdThe 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:


    ParameterDescription
    asinThe Amazon Standard Identification Number of the item
    startDateThe date the data for this report became available
    endDateThe date the data for this report became available
    purchasedAsinASIN of purchased item
    purchasedPctPurchased pct
    purchasedRankPurchased rank
    Parameter Description
    orderDateThe date the order was placed. This field is expected to be in ISO-8601 date/time format, for example:2018-07-16T23:00:00Z/ 2018-07-16T23:00:00-05:00 /2018-07-16T23:00:00-08:00. If no time zone is specified, UTC should be assumed
    purchaseOrderNumberThe purchase order number for this order. Formatting Notes: alpha-numeric code
    customerOrderNumberThe customer order number
    orderStatusCurrent status of the order
    billToParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    sellingParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    shipFromParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    shipmentDetails_isGiftWhen true, the order contain a gift. Include the gift message and gift wrap information
    shipmentDetails_isPriorityShipmentWhen true, this is a priority shipment
    shipmentDetails_isPslipRequiredWhen true, a packing slip is required to be sent to the customer
    shipmentDetails_isScheduledDeliveryShipm…When true, this order is part of a scheduled delivery program
    shipmentDetails_shipmentDates_promisedDe…Delivery date promised to the Amazon customer
    shipmentDetails_shipmentDates_requiredSh…Time by which the vendor is required to ship the order
    shipmentDetails_shipMethodShip method to be used for shipping the order. Amazon defines ship method codes indicating the shipping carrier and shipment service level. To see the full list of ship methods in use, including both the code and the friendly name, search the ‘Help’ section on Vendor Central for ‘ship methods’
    shipToParty_addressLine1First line of the address
    shipToParty_addressLine2Additional address information, if required
    shipToParty_addressLine3Additional address information, if required
    shipToParty_cityThe city where the person, business or institution is located
    shipToParty_countryCodeThe two digit country code. In ISO 3166-1 alpha-2 format
    shipToParty_countyThe county where person, business or institution is located
    shipToParty_nameThe name of the person, business or institution at that address
    shipToParty_phoneThe phone number of the person, business or institution located at that address
    shipToParty_postalCodeThe postal code of that address. It contains a series of letters or digits or both, sometimes including spaces or punctuation
    shipToParty_stateOrRegionThe state or region where person, business or institution is located
    Parameter Description
    asinThe Amazon Standard Identification Number of the item
    startDateThe date the data for this report became available
    endDateThe date the data for this report became available
    comparedAsinASIN of compared item
    comparedPctCompared pct
    comparedRankCompared rank
    Parameter Description
    asinThe Amazon Standard Identification Number of the item
    startDateThe date the data for this report became available
    endDateThe date the data for this report became available
    purchasedWithAsinPurchased with ASIN
    purchasedWithRankPurchased with rank
    combinationPctCombination pct
    Parameter Description
    marketplace_name The name of the marketplace
    marketplace_id The identifier of the marketplace
    Parameter Description
    asinThe Amazon Standard Identification Number of the item
    startDateThe date the data for this report became available
    endDateThe date the data for this report became available
    type
    netPureProductMarginThe 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
    distributorViewSpecifies the distributor view of the report. Values include MANUFACTURING and SOURCING
    marketplaceIdsMarketplace ids
    partPart of the report
    asinThe Amazon Standard Identification Number of the item
    startDateStart date of the date range
    endDateEnd 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
    aged90PlusDaysSellableInventoryUnitsUnits of the aged 90+ days sellable inventory
    averageVendorLeadTimeDaysAverage vendor lead time days
    netReceivedInventoryCost_amountAmount of the aged net received inventory cost
    netReceivedInventoryCost_currencyCodeCurrency code of the net received inventory cost
    netReceivedInventoryUnitsUnits of the net received inventory
    openPurchaseOrderUnitsOpen purchase order units
    sellableOnHandInventoryCost_amountAmount of the sellable on hand inventory cost
    sellableOnHandInventoryCost_currencyCodeCurrency code of the sellable on hand inventory cost
    sellableOnHandInventoryUnitsUnits of the sellable on hand inventory
    sellThroughRateSell through rate
    unfilledCustomerOrderedUnitsUnfilled customer ordered units
    unhealthyInventoryCost_amountAmount of the unhealthy inventory cost
    unhealthyInventoryCost_currencyCodeCurrency code of the unhealthy inventory cost
    unhealthyInventoryUnitsUnits of the unhealthy inventory
    unsellableOnHandInventoryCost_amountAmount of the unsellable on hand inventory cost
    unsellableOnHandInventoryCost_currencyCo…Currency code of the unsellable on hand inventory cost
    unsellableOnHandInventoryUnitsUnits of the unsellable on hand inventory
    Parameter Description
    purchaseOrderNumberThe purchase order number for this order. Formatting Notes: 8-character alpha-numeric code
    purchaseOrderStateThis field will contain the current state of the purchase order
    orderDetails_purchaseOrderDateThe 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_purchaseOrderTypeType of purchase order
    orderDetails_paymentMethodPayment method used
    orderDetails_buyingParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    orderDetails_sellingParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    orderDetails_shipToParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    orderDetails_billToParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    orderDetails_deliveryWindow_fromThis indicates the delivery window ‘from’ border
    orderDetails_deliveryWindow_toThis indicates the delivery window ‘to’ border
    orderDetails_items_amazonProductIdentifi…Amazon Standard Identification Number (ASIN) of an item
    orderDetails_items_isBackOrderAllowedWhen true, we will accept backorder confirmations for this item
    orderDetails_items_itemSequenceNumberNumbering of the item on the purchase order. The first item will be 1, the second 2, and so on
    orderDetails_items_listPrice_amountA 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_amountA decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies
    orderDetails_items_netCost_currencyCodeThree 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
    purchaseOrderNumberThe buyer’s purchase order number for this order. Formatting Notes: 8-character alpha-numeric code
    purchaseOrderStatusThe status of the buyer’s purchase order for this order
    purchaseOrderDateThe date the purchase order was placed
    lastUpdatedDateThe date when the purchase order was last updated
    sellingParty_partyIdAssigned identification for the party. For example, warehouse code or vendor code. Please refer to specific party for more details
    shipToParty_partyIdAssigned 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_confirmationStatusConfirmation 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
    buyerProductIdentifierBuyer’s Standard Identification Number (ASIN) of an item
    itemSequenceNumberNumbering of the item on the purchase order. The first item will be 1, the second 2, and so on
    listPrice_amountA decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies
    listPrice_currencyCodeThree digit currency code in ISO 4217 format. String of length 3
    netCost_amountA decimal number with no loss of precision. Useful when precision loss is unacceptable, as with currencies
    netCost_currencyCodeThree digit currency code in ISO 4217 format. String of length 3
    orderedQuantity_orderedQuantity_amountAcknowledged quantity. This value should not be zero
    orderedQuantity_orderedQuantity_unitOfMe…Unit of measure for the acknowledged quantity
    orderedQuantity_orderedQuantity_unitSizeThe case size, in the event that we ordered using cases
    receivingStatus_receiveStatusReceive status of the line item
    receivingStatus_receivedQuantity_amountAcknowledged 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
    vendorProductIdentifierThe vendor selected product identification of the item
    Parameter Description
    distributorViewSpecifies the distributor view of the report. Values include MANUFACTURING and SOURCING
    marketplaceIdsMarketplace ids
    partPart of the report
    asinThe Amazon Standard Identification Number of the item
    startDateStart date of the date range
    endDateEnd date of the date range
    customerReturnsGoods returned by customers are the number of units returned by customers
    orderedRevenue_amountOrdered 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_currencyCodeCurrency code of the Ordered Revenue
    orderedUnitsOrdered Units
    shippedCogs_amountShipped 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_currencyCodeCurrency code of the Shipped COGS
    shippedRevenue_amountShipped 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_currencyCodeCurrency code of the Shipped Revenue
    shippedUnitsNumber of product units shipped to Amazon customers
    Parameter Description
    marketplaceIdsMarketplace ids
    partPart of the report
    asinThe Amazon Standard Identification Number of the item
    startDateStart date of the date range
    endDateEnd date of the date range
    glanceViewsA 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.

    Start Your Free Trial

    Try Pipes for 14 days, no credit card required.