Amazon Flat File Template: The Complete Upload Guide (Free Download)

Amazon's flat file upload is a rite of passage for every FBA seller. You download the category-specific template from Seller Central, open it, see 200+ columns, and close it. Then you try again three days later, fill in what looks right, upload it, and get back 47 errors.

I've formatted flat files for hundreds of Amazon listings. The errors are predictable. The fixes are simple once you know what Amazon actually expects.

What is a flat file

A flat file is Amazon's term for a spreadsheet template used to create or update product listings in bulk. Instead of filling out each listing form manually in Seller Central, you fill in one row per product (or variant), upload the file, and Amazon processes it.

The template I built is a generic flat file that works for most product categories. It has parent-child variation setup, FBA fulfillment configuration, and two realistic example products with 4 variants each.

The five errors that break every upload

These are the causes of 90% of flat file failures. If you've gotten a batch of errors back, one of these is almost certainly the problem.

1. Product ID mismatches

Every child listing needs a valid UPC, EAN, or GTIN in the external_product_id column, and the external_product_id_type column must match. UPC in the ID field but EAN in the type column? Rejected.

The more common version: you buy UPCs from GS1, paste them into your flat file, accidentally shift one row, and now every product has the wrong UPC. Amazon validates check digits on upload. One wrong digit and the batch fails.

2. Variation theme errors

The variation_theme column tells Amazon how your variants differ. SizeColor, Size, Color, SizeName-ColorName. The problem: valid variation themes depend on your product category. SizeColor works for clothing, not for electronics.

Pick the wrong theme and Amazon either rejects the upload or creates 8 separate listings instead of 1 listing with 8 variants.

3. Missing required attributes

Amazon's error messages are vague: "Error 8015: value is missing for required attribute." The usual suspects are brand_name, bullet_point1, and item_name. Unlike Shopify, Amazon needs the item name on every child row, not just the parent. Leave any of these blank on a child row and that row gets rejected.

4. FBA fulfillment channel flip

This one is subtle and expensive. The fulfillment_channel_code column controls whether Amazon ships the order or you do. AMAZON_NA = FBA. DEFAULT = merchant fulfilled.

Leave it blank and Amazon defaults to merchant fulfilled. Your listings go live, customers order, and you start getting shipping notifications for inventory that's sitting in Amazon's warehouse. You scramble, miss the shipping window, and tank your seller metrics.

5. Excel auto-formatting destroying data

Excel tries to be helpful. It is not.

UPCs become scientific notation: 012345678901 turns into 1.23457E+10. SKUs that look like dates get converted: 3/4 becomes "March 4." Leading zeros get stripped: 012345678901 becomes 12345678901, breaking the check digit.

Format every column as Text before entering data. Or use Google Sheets, which handles all of this correctly by default.

How the parent-child structure works

Amazon's variation system uses parent rows and child rows. The parent is not a buyable product. It's a container that groups the children under one listing. The children are the actual products customers can buy.

Here's a 4-variant product (2 sizes, 2 colors):

The parent row is sparse: just SKU and parent flags. No price, no inventory, no images. All of that goes on the child rows, along with parent_sku pointing back to the parent.

This is almost the inverse of Shopify CSVs: in Shopify, the first variant row carries all the product data. In Amazon, the parent is the skeleton and children carry everything. If you've moved data between platforms, this is where things get confusing.

Using the template

Open it in Google Sheets. (Excel works, but format all columns as Text first to prevent auto-formatting damage.) Study the 2 example products and how the parent-child rows relate. Delete the examples. Change feed_product_type to match your category, then set fulfillment_channel_code to AMAZON_NA or DEFAULT on every child row. Replace the example UPCs with your real ones from GS1.

If flat files and bulk uploads are not how you want to spend your week, send me what you have at flash@tryflash.ai. Product data in any format: spreadsheets, supplier PDFs, screenshots of competitor listings. I format the flat file, upload it, and verify every listing goes live correctly. First 3 jobs are free.

Frequently asked questions

What is an Amazon flat file? A flat file is Amazon's term for the category-specific spreadsheet template used to create or update product listings in bulk via Seller Central. Each product category has its own template with required and optional columns. You download the template for your category, fill it in, and upload it via the Add Products via Upload tool. It's more powerful than the standard Add a Product form but significantly harder to use correctly.

What is the difference between a parent ASIN and child ASIN in a flat file? The parent ASIN is a non-buyable container that groups variations together (e.g., a shirt in multiple sizes). The child ASINs are the actual buyable listings — each size, color, or variation gets its own child row. In the flat file, the parent row has parent in the parent-child column and variation in the relationship-type column. Every child row must reference the parent's SKU. If the parent row is missing or has an error, all children fail to link.

Why does my Amazon flat file keep getting errors after upload? The most common causes: (1) variation theme mismatch — the variation_theme value must match exactly what Amazon's browse node allows for that category (e.g., "Size" not "size"); (2) blank fulfillment_channel_code — this causes listings to default to FBM even if you intended FBA; (3) duplicate UPC — Amazon rejects any UPC already registered to a different ASIN; (4) wrong feed_product_type — this value must match your category exactly and is case-sensitive. The error report downloads as a separate file from Seller Central's Upload Status page.

How do I set up FBA fulfillment in a flat file? Set fulfillment_channel_code to AMAZON_NA on every child row (not the parent). For the FBA quantity fields, set quantity to 0 on upload — Amazon will update inventory once you create a shipment. If you accidentally set fulfillment_channel_code to DEFAULT, the listing flips to FBM and you'll need to convert it in Seller Central manually.

What is variation theme mismatch (Error 8016) in Amazon flat files? Error 8016 occurs when the variation_theme value you've set doesn't match what Amazon's browse node accepts for that category. For example, Clothing might accept "Size-Color" but reject "SizeColor" or "size-color." Get the exact allowed values from the valid-values tab of the downloaded flat file template. This is one of the most common silent failures — the upload succeeds but no variation structure is created.

Can I use a flat file to update existing Amazon listings? Yes. Upload with the existing parent SKU and child SKUs, and Amazon will update the matching listings rather than create duplicates. Only the columns you fill in get updated — blank cells are ignored. This makes flat files useful for bulk edits: update prices, bullet points, or images across 100 ASINs at once. For images, the update may take 24-48 hours to reflect on the live listing.