Term:Amazon fulfillment report file format-FTP Order Downloads

From MediaSell

Jump to: navigation, search

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

Field Headers:

  • payment_status - should have a value of paid_ship_now for the order to be picked up by FillZ. This field is blank when FillZ exports orders to sellers
  • 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 - provided by the marketplace
  • payments_transaction_id
  • product_id - ISBN/ASIN
  • item_name - title of item
  • listing_id - this field can be ignored
  • sku - merchant's unique ID for the physical item
  • 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 - only reliable for Amazon and Biblio
  • quantity_purchased - indicates how many items should be shipped
  • total_price
  • purchase_date - identical to payments_date but may be earlier
  • batch_id
  • buyer_email
  • buyer_name
  • recipient_name
  • ship_address_1
  • ship_address_2
  • ship_city
  • ship_state
  • ship_zip
  • ship_country
  • special_comments - this field will contain the marketplace name followed by a slash (/) and the marketplace order identifier
  • upc - this field will be filled in for non-book items
  • 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
  • status
  • location - locater code with is provided by the seller
  • tracking - will be filled in if provided to us using the order confirmation process
  • buyer_note- will be filled in if the buyer has provided a note
  • seller_note - will be filled in if you use this field on the web interface

Note: In addition to the fields above, we will also provide these fields in the files:

  • payment_method - This may contain the payment method from the marketplace
  • item_condition - This will contain the numerical number for the item's condition (as per Amazon condition codes)
  • item_source - If you provided the source for the inventory item, it will be displayed in this field.
  • cost - If you provided a cost for the inventory item, it will be displayed in this field.
Retrieved from "http://wiki.fillz.com/wiki/index.php/Term:Amazon_fulfillment_report_file_format-FTP_Order_Downloads"
Personal tools