Amazon Fulfillment Report File Format

The Amazon fulfillment report file format includes the columns listed below.

Columns should be:

  • separated with tabs
  • should follow the CSV convention
  • should not contain extra spaces before or after header names

Note: Columns in GREEN are required.

Header Data
payment-status should have a value of paid_ship_now for the order to be picked up
order-id unique numeric ID for the order on FillZ. If an order has multiple line items, there will be multiple records with the same ID and they will appear contiguously in the file
order-item_id  
payments-date date the customer paid for the order Date Format: yyyy-mm-dd hh:mm:ss (Example: 2007-05-24 13:32:15)
product-id ISBN/UPC/ASIN/EAN
item-name title of item
listing-id  
sku this is the only field you should use to match your internal database
price this field is reliable for all markets, but it is only the customer facing amount, without any deductions for fees. It should be multiplied by the “quantity_purchased” field for a sub-total
shipping-fee  
quantity-purchased indicates how many items should be shipped
purchase-date date the order was placed
buyer-email  
buyer-name  
recipient-name  
ship-address-1  
ship-address-2  
ship-city  
ship-state  
ship-zip  
ship-country  
ship-method If “Standard” appears anywhere in this field, regardless of case (upper/lower), you should ship using your “slow” method. If “Standard” does not appear, you should ship using a “fast” method. Other text in the field is informational only and should not be used to make shipping method decisions

 

Have more questions? Submit a request