Amazon Flat File Upload Errors: Why Your Catalog Won’t Import
Published 2026-05-08
Amazon’s flat file upload system is notoriously unforgiving. A single wrong value in any column causes the entire batch to fail with a vague error. Here are the most common causes — and how to diagnose them.
Error: “Invalid value for [column_name]”
The most common error. Amazon validates each column against a list of accepted values. The usual culprits:
- item_type_keyword: Must exactly match one of Amazon’s category-specific values. A typo or a term that doesn’t exist in the category returns this error. Download the category-specific template from Seller Central and copy the exact value.
- color_map: Must be one of Amazon’s standard color names (not your brand’s custom color names). “Midnight Navy” → “Navy”; “Chalk White” → “White.”
- bullet_point fields: Cannot contain HTML or special characters like <, >, &. Strip all markup.
Error: “The SKU already exists”
You’re trying to upload a new product but a SKU from a previous upload (even a failed one) is already registered. Either use a new SKU or go to Manage Inventory and delete the orphaned listing first.
Error: “Parent SKU not found”
This appears on child (variant) rows when the parent row is missing or malformed. Check that:
- The parent row exists and comes before the child rows in the file
- The parent_sku value on child rows exactly matches the item_sku on the parent row
- The parentage_level is set to “parent” on the parent row and “child” on child rows
Error: Feed stuck in “In Progress” for hours
Amazon processes large batches asynchronously. Files over 1,000 rows can take 2–4 hours. Under 100 rows is usually 15–30 minutes. If it’s been over 6 hours, download the processing report — it will show which rows failed and why.
Why Shopify→Amazon conversion is particularly hard
If you’re going the other direction (Shopify to Amazon), you face all of the above plus you’re constructing the Amazon structure from scratch. The bullet points don’t exist in Shopify, the item_type_keyword requires knowledge of the Amazon category taxonomy, and you need to split Shopify’s combined variant attributes into separate Amazon columns. csvtocsv.com/amazon-to-shopify handles the Amazon→Shopify direction; a Shopify→Amazon adapter is on the roadmap.