Free forever · No account · Your file never leaves your device
Amazon Flat File Fixer
Amazon answers a bad upload afterwards, with a processing report full of numbers. Drop your flat file in first instead: every row is checked against the faults that fill those reports — SKUs, product IDs, prices, quantities, conditions — the mechanical mistakes are repaired, and the rest is explained in plain words, row by row, with the SKU and the line named.
Drop your Amazon flat file here
A tab-delimited .txt — the inventory or category upload file you are about to send Amazon, template settings rows and all.
Your file is read by your own browser, on this computer. Your file never leaves your device.
What it checks, in plain words
SKUs, the anchor of every row
Every row hangs on its SKU. A row with no SKU, a SKU over Amazon’s 40 characters, or the same SKU used on two rows is named — a duplicate names both lines, because the second row fights the first.
Product IDs that check out
UPC, EAN, GTIN and ISBN numbers carry a check digit, and the fixer verifies it — a wrong digit is named, never guessed at. Type words are corrected to the exact capitals (upc becomes UPC), and an ID with no type named earns a warning: Amazon needs the type to know what kind of number it is.
Prices in Amazon’s shape
A plain number with exactly two decimal places: $25.5 becomes 25.50, thousands commas come out. Minimum and maximum seller allowed prices are compared against each other, and a new listing — add-delete “a” — with no price is named before Amazon fails it.
Quantities Amazon can count
Whole numbers only: 10.0 becomes 10, a negative is an error. And when a row is fulfilled by Amazon itself, the warning says what sellers learn the hard way — Amazon counts that stock in its own warehouses, so the quantity on the row is ignored.
Conditions in both dialects
Amazon templates speak two languages for condition: the numbers 1 to 11, and the words — New, Used - Like New, and the rest. Both are accepted, the words are corrected to their exact spelling and capitals, and anything outside the two is named with what Amazon accepts instead.
The small switches, and the column names
add-delete reads exactly a, x or d; will-ship-internationally and expedited-shipping read y or n; handling time gets a warning past the 30-day cap most categories set. And a column headed with a near-miss spelling — “quantitiy” — earns a warning, because Amazon ignores columns it does not know and that data never arrives.
About the file shape — stated plainly
Your template settings rows are never touched. The rows at the top of a flat file, above the column names, tell Amazon which template the file belongs to. They are carried into the fixed file exactly as they were — the fixer reads them to find where the columns start, and changes nothing in them.
Tab-delimited in, tab-delimited out. That is the shape Amazon’s loader reads. If your copy was saved by a spreadsheet with commas or semicolons between the columns, the fixer converts it and says so in the report.
Meeting the numbered errors themselves? The plain-words guide to Amazon upload error codes →
Questions
What is a flat file, exactly?
Amazon’s spreadsheet-shaped upload: a plain text file, columns separated by tabs, with a few template settings rows at the top and one row per product underneath. Sellers meet it in Seller Central under Add Products via Upload — and meet its failures in the processing report Amazon sends back afterwards, written in error numbers.
Will my template settings rows survive?
Yes. The rows above the column row — TemplateType, Version and their companions — tell Amazon which template the file belongs to, so the fixer carries them over exactly as they were, byte for byte, and never edits them. Only the product rows are checked and fixed.
My barcode was flagged as wrong. Can’t you just fix the digit?
No — and be careful with any tool that offers to. A barcode’s last digit is a check on all the others; when it fails, one digit was typed wrong somewhere, and guessing which one could attach your product to somebody else’s. Copy the number from the barcode again — that is the whole fix.
Where does my file go?
Nowhere. Like every tool on this site, the fixer runs inside your web browser, on your computer. Your file never leaves your device, so we could not look at your products even if we wanted to.