Term:Amazon tab format

From MediaSell

[edit] Overview

The Amazon format is described here:

http://www.amazon.com/exec/obidos/tg/browse/-/1161314

We require the following fields in order for your file to be accepted:

• sku
• product-id
• product-id-type
• item-condition
• price
• quantity

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

• cost
• location

[edit] Condition Codes

The condition must take one of the following values:

• 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)
• 11 = New

[edit] Amazon fulfillment 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.