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.
|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|
|payments-date||date the customer paid for the order Date Format: yyyy-mm-dd hh:mm:ss (Example: 2007-05-24 13:32:15)|
|item-name||title of item|
|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|
|quantity-purchased||indicates how many items should be shipped|
|purchase-date||date the order was placed|
|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|