Don’t miss the Amazon Seller Offer! All new customers who subscribe from May 01 to August 31, 2022 get the Amazon SP-API data connector permanently for the price of 99$/ month (in annual payment plan | 119$ in monthly payment plan).

Article contents

Share Article

Amazon SP-API migration

Migrate to the Amazon SP-API now

The deactivation of MWS starts on July 31 2022

The migration to the Amazon SP-API is urgent, as the first Amazon MWS API sections will be deprecated in July. Amazon is starting the end of the Marketplace Web Service for all third-party tools with the deprecation of the MWS Merchant Fulfillment, Orders, and Reports API section on July 31, 2022. Followed by the MWS Products section on September 30, 2022 and finally all other MWS sections on December 31, 2022.

Who should migrate to the SP-API?

Since Amazon will keep up MWS for Sellers who directly integrate with the Marketplace Web Service through a self-developed connection, not everyone needs to migrate to the Selling Partner API. 

You should migrate to the SP-API when you:

  • use a third-party (public) application to connect to Amazon’s MWS currently
  • want to benefit from a maintained state-of-the-art API and all its future developments
  • are an Amazon Vendor and would like to access your Amazon data via an API for the first time

SP-API migration made easy with Pipes

Re-configuration of existing MWS data pipelines is unavoidable

Amazon decided that the efficiency of the SP-API, like the naming of the API sections, should reflect the present day situation better. Due to these differences between the SP-API and the MWS, there will be compatibility issues when migrating to the Selling Partner API. The data, while representing the same objects, e.g. orders, financial events, inventory items, etc., is provided by the new Amazon API in a different way.

Consequently, it will not be possible to reconfigure existing data pipelines from the new SP-API connector into existing tables populated by the MWS connector. Because of this, migration to the new connector, and the new API, requires that the current Amazon MWS data pipelines for the SP-API be re-created from scratch.

See here how the MWS API sections map to the SP-API operations:

Amazon MWS sections Amazon SP-API sections
Feeds API section Feeds API
Finances API section Finances API
Fulfillment Inbound Shipment API section Fulfillment Inbound API
Fulfillment Inventory API section FBA Inventory API
Fulfillment Outbound Shipment API section Fulfillment Outbound API
Merchant Fulfillment API section Merchant Fulfillment API
Orders API section Orders API
Products API section: Product Fees Product Fees API
Products API section: Product Listings Catalog Items API
Products API section: Product Pricing Product Pricing API
Recommendations API section Deprecated in the SP-API
Reports API section Reports API
Sellers API section Sellers API
Subscriptions API section Notifications API

With Pipes, you can easily migrate to the Selling Partner API through:

Ready-to-use SP-API data connector:

It doesn’t matter if you’re an Amazon Seller or Vendor. With the ready-to-use Amazon data connectors from Pipes, you’re able to connect to the SP-API in just a few clicks. You only need your Amazon Seller or Vendor account credentials (or you are just already logged in).

Pre-built SP-API data templates:​

With the pre-built selling partner data templates, we bundled meaningful connected metrics of an Amazon selling business. You can check the metrics and the structure with which the table is created in your data warehouse before you configure a constant data pipeline between the SP-API and your data warehouse.

SP-API best-practices templates:​

For a really quick and easy migration to the SP-API, we provide best-practices templates based on our experience with a variety of Amazon selling partners. These SP-API best-practices templates configure several data pipelines and schedules at once, according to the known best practices for our Selling Partner API connector. This way you cover the most important Amazon data on your business with just a few clicks.

SP-API best-practices template I: Order data, popular FBA reports and settlement data
Detailed Active Listings Report
Parameter Description
marketplace_id The encrypted marketplace value
item_name The item name
item_description The item description
listing_id The listing id
seller_sku Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller
price Price per item in the currency of the marketplace where you are listing the product. Do not include the currency symbol. This field is required. You must provide a price to make the product available for purchase on Amazon
quantity The total number of units reimbursed for this line item
open_date Open date
image_url The image url
item_is_marketplace Item is marketplace
product_id_type The type of product id
zshop_shipping_fee Zshop shipping fee
item_note The item note
item_condition Numeric entry that indicates the condition of the product. This field is required. Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines
zshop_category1 Zshop category1
zshop_browse_path Zshop browse path
zshop_storefront_feature Zshop storefront feature
asin1 The Amazon Standard Identification Number (ASIN) of the item
asin2 The Amazon Standard Identification Number (ASIN) of the item
asin3 The Amazon Standard Identification Number (ASIN) of the item
will_ship_internationally Will ship internationally
expedited_shipping Expedited shipping
zshop_boldface Zshop boldface
product_id The product id
bid_for_featured_placement The bid for featured placement
add_delete Add delete
pending_quantity Pending quantity
fulfillment_channel Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)
Business_Price A special price that is available only for Amazon Business orders
Quantity_Price_Type Quantity price type
Quantity_Lower_Bound_1 Quantity lower bound
Quantity_Price_1 Quantity price
Quantity_Lower_Bound_2 Quantity lower bound
Quantity_Price_2 Quantity price
Quantity_Lower_Bound_3 Quantity lower bound
Quantity_Price_3 Quantity price
Quantity_Lower_Bound_4 Quantity lower bound
Quantity_Price_4 Quantity price
Quantity_Lower_Bound_5 Quantity lower bound
Quantity_Price_5 Quantity price
merchant_shipping_group The merchant shipping group
Progressive_Price_Type Progressive price type
Progressive_Lower_Bound_1 Progressive lower bound
Progressive_Price_1 Progressive price
Progressive_Lower_Bound_2 Progressive lower bound
Progressive_Price_2 Progressive price
Progressive_Lower_Bound_3 Progressive lower bound
Progressive_Price_3 Progressive price

Estimated Amazon Selling and Fulfillment Fees for the seller’s FBA inventory with active offers

ParameterDescription
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
product_groupThe Amazon department or category
brandThe brand of your product
fulfilled_byThe entity that fulfilled the item
your_priceYour current selling price
sales_priceYour current promotional price
longest_sideMeasurement of the longest side of your product including its packaging
median_sideMeasurement of the side that is neither the longest nor the shortest side of your product including its packaging
shortest_sideMeasurement of the shortest side of your product including its packaging
length_and_girthThe longest side of your product, including its packaging, plus the girth, a unit measure, equivalent to 2 x (median side + shortest side)
unit_of_dimensionThe unit of dimension
item_package_weightThe item package weight
unit_of_weightThe unit of weight used in weight measurement
product_size_tierThe size tier assigned to your product by FBA based on its dimensions and weight
currencyThe currency in which the fee is calculated
estimated_fee_totalThe estimated fulfillment and Selling on Amazon fee
estimated_referral_fee_per_unitThe estimated Selling on Amazon Referral Fee
estimated_variable_closing_feeThe estimated Variable Closing Fee for your product
estimated_order_handling_fee_per_orderThe estimated Order Handling Fee per order
estimated_pick_pack_fee_per_unitEstimated pick pack fee per unit
estimated_weight_handling_fee_per_unitThe estimated Weight Handling Fee for your product based on the Outbound Shipping Weight
expected_fulfillment_fee_per_unitExpected fulfillment fee per unit

Current details of active (not archived) inventory

ParameterDescription
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_exists“Yes” 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_exists“Yes” 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

Number of reserved units in a seller’s inventory

ParameterDescription
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

Financial Events

ParameterDescription
PostedDateThe date and time when the financial event was posted
EventName 
ASINThe Amazon Standard Identification Number (ASIN) of the item
AdjustmentAmount_CurrencyAmountThe monetary value
AdjustmentAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
AdjustmentTypeThe 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;
AmazonOrderIdAn Amazon-defined identifier for an order
AmountDescriptionA short description of this payment event
BaseExpense_CurrencyAmountThe monetary value
BaseExpense_CurrencyCodeThe three-digit currency code in ISO 4217 format
BaseTax_CurrencyAmountThe monetary value
BaseTax_CurrencyCodeThe three-digit currency code in ISO 4217 format
BaseValue_CurrencyAmountThe monetary value
BaseValue_CurrencyCodeThe three-digit currency code in ISO 4217 format
BusinessObjectTypeThe type of business object
ChargeComponent_ChargeAmount_CurrencyAmo… 
ChargeComponent_ChargeAmount_CurrencyCod… 
ChargeComponent_ChargeType 
Charge_ChargeAmount_CurrencyAmount 
Charge_ChargeAmount_CurrencyCode 
Charge_ChargeType 
ClipOrRedemptionCountThe number of coupon clips or redemptions
CouponIdA coupon identifier
DealDescriptionThe internal description of the deal
DealIdThe unique identifier of the deal
DebtRecoveryTypeThe debt recovery type. Possible values: DebtPayment; DebtPaymentFailure; DebtAdjustment;
EnrollmentIdAn enrollment identifier
EventTypeThe type of event: SellerDealComplete
ExtensionLengthThe number of days that the buyer extended an already rented item. This value is only returned for RentalCustomerPayment-Extension and RentalCustomerRefund-Extension events
FeeAmount_CurrencyAmountThe monetary value
FeeAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
FeeComponent_FeeAmount_CurrencyAmountThe monetary value
FeeComponent_FeeAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
FeeComponent_FeeTypeThe 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
FeeDescriptionA short description of the service fee event
FeeReasonA short description of the service fee reason
FeeTypeThe type of fee: RunLightningDealFee
FnSKUA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
FulfillmentChannelThe fulfillment channel. Possible values: AFN – Amazon Fulfillment Network (Fulfillment by Amazon); MFN – Merchant Fulfillment Network (self-fulfilled);
ImagingRequestBillingItemIDThe identifier for the imaging services request
InvoiceIdIdentifier for the invoice that the transaction appears in
LiquidationFeeAmount_CurrencyAmountThe monetary value
LiquidationFeeAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
LiquidationProceedsAmount_CurrencyAmountThe monetary value
LiquidationProceedsAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
LoanAmount_CurrencyAmountThe monetary value
LoanAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
MarketplaceCountryCodeThe two-letter country code of the country associated with the marketplace where the order was placed
MarketplaceIdAn encrypted, Amazon-defined marketplace identifier
MarketplaceNameThe name of the marketplace where the event occurred
NetCoTransactionIDThe identifier for the network item swap
OriginalRemovalOrderIdThe identifier for the original removal order
OverPaymentCredit_CurrencyAmountThe monetary value
OverPaymentCredit_CurrencyCodeThe three-digit currency code in ISO 4217 format
ParentASINThe Amazon Standard Identification Number (ASIN) of the item that was enrolled in the Early Reviewer Program
PaymentAmountTypeThe type of payment. Possible values: Sales;
PaymentEventIdA payment event identifier
ProviderIdThe Amazon-defined identifier of the solution provider
ProviderStoreNameThe store name where the payment event occurred
ProviderTransactionTypeThe transaction type
ReasonCodeIndicates why the seller was reimbursed
RecoveryAmount_CurrencyAmountThe monetary value
RecoveryAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
ReimbursedAmount_CurrencyAmountThe monetary value
ReimbursedAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
RentalEventTypeThe 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_CurrencyAmountThe monetary value
RentalInitialValue_CurrencyCodeThe three-digit currency code in ISO 4217 format
RentalReimbursement_CurrencyAmountThe monetary value
RentalReimbursement_CurrencyCodeThe three-digit currency code in ISO 4217 format
RetrochargeEventTypeThe type of event. Possible values: Retrocharge; RetrochargeReversal;
SAFETClaimIdA SAFE-T claim identifier
SalesChannelThe sales channel for the transaction
SellerCouponDescriptionThe description provided by the seller when they created the coupon
SellerIdThe Amazon-defined identifier of the seller
SellerOrderIdA seller-defined identifier for an order
SellerSKUThe 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
SellerStoreNameThe store name where the payment event occurred
ShippingTax_CurrencyAmountThe monetary value
ShippingTax_CurrencyCodeThe three-digit currency code in ISO 4217 format
SourceBusinessEventTypeThe type of event. Possible values: LoanAdvance; LoanPayment; LoanRefund;
StoreNameThe store name where the event occurred
SwapReasonThe reason for the network item swap
TaxAmount_CurrencyAmountThe monetary value
TaxAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
TaxExclusiveAmount_CurrencyAmountThe monetary value
TaxExclusiveAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
TaxTypeCGST_CurrencyAmountThe monetary value
TaxTypeCGST_CurrencyCodeThe three-digit currency code in ISO 4217 format
TaxTypeIGST_CurrencyAmountThe monetary value
TaxTypeIGST_CurrencyCodeThe three-digit currency code in ISO 4217 format
TaxTypeSGST_CurrencyAmountThe monetary value
TaxTypeSGST_CurrencyCodeThe three-digit currency code in ISO 4217 format
TaxValue_CurrencyAmountThe monetary value
TaxValue_CurrencyCodeThe three-digit currency code in ISO 4217 format
TotalAmount_CurrencyAmountThe monetary value
TotalAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
TotalExpense_CurrencyAmountThe monetary value
TotalExpense_CurrencyCodeThe three-digit currency code in ISO 4217 format
TransactionAmount_CurrencyAmountThe monetary value
TransactionAmount_CurrencyCodeThe three-digit currency code in ISO 4217 format
TransactionCreationDateThe date and time that the credit transaction was created, in ISO 8601 date time format
TransactionPostedDateThe date and time when the payment transaction is posted. In ISO 8601 date time format
TransactionTypeIndicates if the transaction is for a charge or a refund. Possible values: charge – Charge; refund – Refund;
TransactionValue_CurrencyAmountThe monetary value
TransactionValue_CurrencyCodeThe three-digit currency code in ISO 4217 format

Order data delivered by the fast reporting API, less detail than slow orders API

ParameterDescription
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
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

ParameterDescription
AmazonOrderIdAn 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_CityThe city
AssignedShipFromLocationAddress_CountryC…The country code. A two-character country code, in ISO 3166-1 alpha-2 format
AssignedShipFromLocationAddress_CountyThe county
AssignedShipFromLocationAddress_DistrictThe district
AssignedShipFromLocationAddress_Municipa…The municipality
AssignedShipFromLocationAddress_NameThe name
AssignedShipFromLocationAddress_PhoneThe phone number. Not returned for Fulfillment by Amazon (FBA) orders
AssignedShipFromLocationAddress_PostalCo…The postal code
AssignedShipFromLocationAddress_StateOrR…The state or region
CbaDisplayableShippingLabelCustom ship label for Checkout by Amazon (CBA)
EarliestDeliveryDateThe 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
EarliestShipDateThe 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
EasyShipShipmentStatusThe 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
FulfillmentChannelWhether 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
IsBusinessOrderWhen true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer
IsEstimatedShipDateSetWhen true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders
IsGlobalExpressEnabledWhen true, the order is a GlobalExpress order
IsPremiumOrderWhen 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
IsPrimeWhen true, the order is a seller-fulfilled Amazon Prime order
IsReplacementOrderWhen true, this is a replacement order
IsSoldByABWhen 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
LastUpdateDateThe 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
LatestDeliveryDateThe 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
LatestShipDateThe 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
MarketplaceIdThe identifier for the marketplace where the order was placed
NumberOfItemsShippedThe number of items shipped
NumberOfItemsUnshippedThe number of items unshipped
OrderChannelThe order channel of the first item in the order
OrderStatusThe current order status
OrderTotal_AmountThe currency amount
OrderTotal_CurrencyCodeThe three-digit currency code. In ISO 4217 format
OrderTypeThe type of the order
PaymentMethodThe 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
PaymentMethodDetailsA list of payment methods for the order
PromiseResponseDueDateIndicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders
PurchaseDateThe date when the order was created
ReplacedOrderIdThe order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true
SalesChannelThe sales channel of the first item in the order
SellerOrderIdA seller-defined order identifier
ShipServiceLevelThe shipment service level of the order
ShipmentServiceLevelCategoryThe shipment service level category of the order. Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard

Recommendations on products to restock

ParameterDescription
marketplace_idThe encrypted marketplace value
CountryCountry in which your products are stored
Product_NameProduct Name
FNSKUA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
Merchant_SKUMerchant SKU
ASINThe Amazon Standard Identification Number of the item
ConditionThe condition of your product
SupplierSupplier
Supplier_part_no_Supplier part no
Currency_codeCurrency code
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
Sales_last_30_daysSales last 30 days
Units_Sold_Last_30_DaysUnits Sold Last 30 Days
Total_UnitsTotal Units
InboundInbound
AvailableAvailable
FC_transferFC transfer
FC_ProcessingFC Processing
Customer_OrderCustomer Order
UnfulfillableUnfulfillable
Fulfilled_byFulfilled by
Days_of_SupplyDays of Supply
AlertAlert
Recommended_replenishment_qtyRecommended replenishment qty
Recommended_ship_dateRecommended 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_thresholdInventory level threshold’s published – Next Month
Next_month_Minimum_inventory_thresholdNext month – Minimum inventory threshold
Next_month_Maximum_inventory_thresholdNext month – Maximum inventory threshold
Next_month_Very_high_inventory_thresholdNext month – Very high inventory threshold
UtilizationUtilization
Maximum_shipment_quantityMaximum shipment quantity
Settlement report, delivered via Flat File V2 Settlement report

ParameterDescription
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
SP-API best-practices template II: Fine order data, delivered via slow API
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

ParameterDescription
AmazonOrderIdAn 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_CityThe city
AssignedShipFromLocationAddress_CountryC…The country code. A two-character country code, in ISO 3166-1 alpha-2 format
AssignedShipFromLocationAddress_CountyThe county
AssignedShipFromLocationAddress_DistrictThe district
AssignedShipFromLocationAddress_Municipa…The municipality
AssignedShipFromLocationAddress_NameThe name
AssignedShipFromLocationAddress_PhoneThe phone number. Not returned for Fulfillment by Amazon (FBA) orders
AssignedShipFromLocationAddress_PostalCo…The postal code
AssignedShipFromLocationAddress_StateOrR…The state or region
CbaDisplayableShippingLabelCustom ship label for Checkout by Amazon (CBA)
EarliestDeliveryDateThe 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
EarliestShipDateThe 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
EasyShipShipmentStatusThe 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
FulfillmentChannelWhether 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
IsBusinessOrderWhen true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer
IsEstimatedShipDateSetWhen true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders
IsGlobalExpressEnabledWhen true, the order is a GlobalExpress order
IsPremiumOrderWhen 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
IsPrimeWhen true, the order is a seller-fulfilled Amazon Prime order
IsReplacementOrderWhen true, this is a replacement order
IsSoldByABWhen 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
LastUpdateDateThe 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
LatestDeliveryDateThe 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
LatestShipDateThe 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
MarketplaceIdThe identifier for the marketplace where the order was placed
NumberOfItemsShippedThe number of items shipped
NumberOfItemsUnshippedThe number of items unshipped
OrderChannelThe order channel of the first item in the order
OrderStatusThe current order status
OrderTotal_AmountThe currency amount
OrderTotal_CurrencyCodeThe three-digit currency code. In ISO 4217 format
OrderTypeThe type of the order
PaymentMethodThe 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
PaymentMethodDetailsA list of payment methods for the order
PromiseResponseDueDateIndicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders
PurchaseDateThe date when the order was created
ReplacedOrderIdThe order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true
SalesChannelThe sales channel of the first item in the order
SellerOrderIdA seller-defined order identifier
ShipServiceLevelThe shipment service level of the order
ShipmentServiceLevelCategoryThe shipment service level category of the order. Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard

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.

You may also interested in....

Play Video

More interesting articles