Amazon CSV Fixer
Fix Amazon inventory loader CSV files before upload. StriveFormats validates flat-file fields—SKU length, condition codes, price formatting, fulfillment channel, and boolean fields—and auto-fixes safe issues.
Amazon flat-file uploads fail when SKUs are too long, condition codes are unrecognized, prices include currency symbols, or fulfillment channel values don't match expected constants. This tool catches those issues before submission.
What it catches
- Missing required columns (sku, item-name, price, quantity)
- SKUs exceeding Amazon's 40-character limit
- Invalid or unrecognized item-condition codes
- Unrecognized product-id-type values (ASIN, UPC, EAN, etc.)
- Invalid fulfillment-channel values
- Invalid add-delete operation codes
- Image URLs that aren't valid http(s) addresses
- Boolean fields (will-ship-internationally, expedited-shipping) with invalid values
What it auto-fixes (safe only)
- Trims hidden whitespace
- Normalizes price formatting (removes currency symbols)
- Normalizes product-id-type to uppercase (e.g., "asin" → "ASIN")
- Normalizes add-delete to lowercase (e.g., "A" → "a")
- Enforces canonical Amazon flat-file column order
Anything that could change meaning stays as a flagged issue for manual review.
How to use it
- Download your inventory file from Amazon Seller Central or prepare a flat-file template.
- Upload the CSV in the app with the Amazon Inventory Loader preset selected.
- Resolve blocking errors (missing SKU, invalid price) then review warnings.
- Export a cleaned file and upload it to Seller Central.
FAQ
What is an Amazon inventory loader flat-file?
Amazon Seller Central supports uploading product listings and inventory in bulk via tab-delimited or comma-delimited flat files. This fixer targets the inventory loader format, validating fields like SKU, price, quantity, condition, and fulfillment channel.
What fulfillment-channel values are valid?
Use DEFAULT for Merchant Fulfilled (you ship the orders) or AMAZON_NA for Fulfillment by Amazon (FBA). Other regional FBA values include AMAZON_EU and AMAZON_FE.
What are valid item-condition codes?
Amazon uses numeric codes: 11=New, 10=Refurbished, 1=Used Like New, 2=Used Very Good, 3=Used Good, 4=Used Acceptable. The fixer flags any unrecognized condition codes.