Term:Amazon tab format

From FillZ

Jump to: navigation, search
The Amazon-Tab Separated format for INVENTORY is described here:

Click here to see field definitions on Amazon.

Be sure to include headers in the top row of your file, using the values in the left column below. If you will not be providing data for a column, do not add a header (for example, if you will not be including cost information in your file, do not include a header for "cost"). 

We require the following fields in order for your file to be accepted:
  sku                     (unique identifier for a listing - can contain letters and/or numbers)
  product-id              (ISBN/ASIN/UPC)                          
  product-id-type         (1 = ASIN / 2 = ISBN / 3 = UPC / 4 = EAN)
  item-condition          (numerical value, see below for examples)
  price
  quantity

We support the following additional fields, as an extension to the Amazon format:
  cost
  location

If you are uploading listings through your online account, you can also use source as an additional field. Please note that this field isn't accepted via FTP. 

These fields are optional:
  will-ship-internationally (1 or n / 2 or y)
  expedited-shipping        (0 or n / 1 or y)
  item-name                 (title)
  item-note                 (description)  
  image-url                 (a url if you have a picture hosted online)


item-condition must be one of the following numerical values:

  • 11 = New
  • 1 = Used; Like New
  • 2 = Used; Very Good
  • 3 = Used; Good
  • 4 = Used; Acceptable
  • 5 = Collectible; Like New
  • 6 = Collectible; Very Good
  • 7 = Collectible; Good
  • 8 = Collectible; Acceptable
  • 9 = Used; Refurbished (for Electronics and Camera & Photo only)
  • 10 = Refurbished (for Computers, Kitchen & Housewares, Electronics, and Camera & Photo only)



Amazon format for ORDERS

The CSV format is explicit in the need to escape double-quote characters. Unfortunately, Amazon does not enforce this which in turn caused some software vendors to generate sloppily formatted files. Some other vendors (e.g. FillZ) are strict in their parsing of the format and will reject records with bare double-quotes.

See a more detailed description of the CSV standard.

If you are unable to obtain a fix for your software, the only solution is to refrain from using double quotes in any field.


Back to Glossary

Retrieved from "http://wiki.fillz.com/wiki/index.php/Term:Amazon_tab_format"
Personal tools