Amazon Flat File Guide (2026): Templates, Variations & Errors

↑ Real output. Try it →
Table of contents
An Amazon flat file is a category-specific spreadsheet template that you download from Seller Central, fill in with one row per product, and upload to create or edit listings in bulk. To use one well you need four things: the right template for your product type, the required columns filled exactly as the Valid Values tab expects, correct parent and child rows if you sell variations, and a habit of reading the processing report after every upload. This guide walks through each step, explains the columns that matter most, and covers the error codes sellers hit most often.
For the wider picture of every bulk route in Seller Central, start with our CSV and bulk upload guide. This post is the deep dive on the flat file itself.
What a flat file is (and what Amazon calls it now)
"Flat file" is the long-standing seller name for Amazon's inventory file templates. Inside Seller Central you will see several labels for the same idea, and Amazon renames them often: inventory files, category templates, listing spreadsheets or product templates. They all work the same way. You download an Excel workbook built for one or more product types, fill in the Template sheet, and upload it through the bulk upload page.
A typical template workbook contains:
| Sheet | What it is for |
|---|---|
| Instructions | How the template works and how to upload it |
| Template | The sheet you fill in, one row per SKU |
| Data Definitions | Every column, whether it is required, and its format |
| Valid Values | The exact accepted values for dropdown fields, including variation themes |
| Example | Sample rows, often including a parent and child family |
Column names differ between template generations. Older templates use short headers such as item_sku, parent_child and generic_keywords. Newer templates generated per product type show friendlier labels (for example Seller SKU, Parentage Level, Parent SKU) above longer machine attribute names; integration providers such as Lengow describe names like parentage_level and child_parent_sku_relationship in these files. The logic is identical, so this guide uses the familiar short names and you should map them to whatever headers your downloaded template shows.
Flat file vs single listing form vs other bulk tools
Amazon gives you more than one way to create listings. Picking the right one saves hours.
| Method | Best for | Watch out for |
|---|---|---|
| Single listing form (Add a Product) | 1 to 5 new products, or quick one-off edits | Slow at scale; variations are fiddly |
| Flat file / category template | New products in bulk, variation families, catalog-wide content changes | Strict valid values; one wrong column can fail many rows |
| Bulk offer upload (search by product ID) | Adding your offer to ASINs that already exist | You cannot change catalog content this way |
| Category Listings Report | Downloading your existing catalog as a spreadsheet to edit and re-upload | Access may need to be requested; read it carefully before re-uploading |
| Price and quantity files | Changing only price or stock | Not for titles, bullets or images |
Rule of thumb: if you are creating new ASINs, building variations or changing content on more than a handful of SKUs, use a flat file. If you only resell existing ASINs or change prices, the lighter bulk tools are faster.
Step 1: Download the right template
- In Seller Central, open Catalog, then Add Products via Upload.
- Choose the option to download or generate a template (often a spreadsheet or inventory file tab).
- Search for your product type, for example "water bottle" or "yoga mat", and add every product type you plan to list in this file.
- Select the marketplace (Amazon.com, Amazon.in and so on). Templates are marketplace-specific because valid values and limits differ.
- If offered, choose a template mode that includes all attributes rather than a minimal one, so you do not miss category-required fields.
- Generate and download the Excel file.
Always download a fresh template for each new batch. Amazon updates required attributes and valid values, and an old file can fail on columns that no longer exist or miss ones that are now required.
Step 2: Understand the key columns
You will not fill every column. Focus on the required ones (usually highlighted or bolded at the top of the Template sheet, and marked Required in Data Definitions) plus the content fields that drive search and conversion.
| Column (classic name) | What to enter | Notes |
|---|---|---|
| feed_product_type | The product type, from Valid Values | Newer templates often prefill it per product type |
| item_sku | Your unique SKU | Never reuse a SKU for a different product |
| brand_name / brand | Your brand exactly as registered | Must match Brand Registry and, for GTINs, the GS1 record |
| external_product_id | UPC, EAN, GTIN or ISBN | Brand owners may use a GTIN exemption instead, if approved |
| external_product_id_type | UPC, EAN, GTIN, ISBN | Must match the ID you entered |
| item_name | Product title | See the 75-character rule below |
| manufacturer | Manufacturer name | Often the same as brand for private label |
| parent_child | parent or child | Blank for standalone products |
| parent_sku | The parent's item_sku | Child rows only |
| relationship_type | Variation | Child rows only, in most templates |
| variation_theme | e.g. Size, Color, SizeColor | Must be a value from Valid Values |
| update_delete | Update, PartialUpdate or Delete | Controls what the upload does |
| bullet_point1 to bullet_point5 | Key product benefits | Check your category's character guidance |
| product_description | Plain-text description | A+ Content replaces it on the page for many brands |
| generic_keywords | Backend search terms | Byte-limited, see below |
| main_image_url, other_image_url1 onward | Public image URLs | Or upload images separately |
| standard_price, quantity | Price and stock | Can also be managed in separate files |
Category templates add their own required fields, such as size_name and color_name for apparel, unit counts for grocery, or battery details for electronics. If an upload fails on a field you have never heard of, it is almost always a category-required attribute listed in Data Definitions.
Try zonfy
Generate Amazon listings in 90 seconds
Title, 5 bullets, description, backend keywords, and 7 gallery images — generated in 90 seconds. Drop straight into Seller Central.
Generate Full Listing →Plans from ₹749/month · cancel anytime.
Step 3: Build parent-child variations, step by step
A variation listing is one parent (which is never sold, it only groups the family) and two or more children (the buyable size or color options). For the strategy side, such as which themes to use and when not to vary, see our guide to Amazon variations and parent-child setup. Here is how to build one in a flat file.
- Pick the variation theme. Open Valid Values and find the themes allowed for your product type. Common ones include Size, Color and SizeColor, but names vary by template, so copy the exact spelling.
- Create the parent row. Give it its own SKU (for example BRAND-BOTTLE-PARENT), set parent_child to parent, leave parent_sku blank, and enter the variation theme. Add brand, product type and the shared title and content. Leave child-specific fields such as product ID, price, size and color blank.
- Create one row per child. Give each a unique SKU (BRAND-BOTTLE-750-BLK), set parent_child to child, put the parent's SKU in parent_sku exactly as written, set relationship_type to Variation and use the same variation theme as the parent.
- Fill every theme attribute on every child. If the theme is SizeColor, each child needs both a size value and a color value. A blank theme attribute is one of the most common reasons a child fails to attach.
- Give each child its own product ID, price, stock and main image. Children cannot share a UPC or EAN.
- Avoid duplicate combinations. Two children with the same size and color in the same family will fail or collide.
- Upload parents and children together, with the parent row above its children, and read the processing report before fixing anything else.
Example layout for a two-size, two-color family:
| item_sku | parent_child | parent_sku | relationship_type | variation_theme | size_name | color_name |
|---|---|---|---|---|---|---|
| BRAND-BOTTLE-PARENT | parent | SizeColor | ||||
| BRAND-BOTTLE-500-BLK | child | BRAND-BOTTLE-PARENT | Variation | SizeColor | 500 ml | Black |
| BRAND-BOTTLE-500-WHT | child | BRAND-BOTTLE-PARENT | Variation | SizeColor | 500 ml | White |
| BRAND-BOTTLE-750-BLK | child | BRAND-BOTTLE-PARENT | Variation | SizeColor | 750 ml | Black |
Some templates expect a value in relationship_type on the parent too, so check the Example sheet in your own download. To add a child to an existing family later, upload just the new child row with the existing parent SKU; you do not need to resend the whole family.
Step 4: Upload and read the processing report
- Go back to Catalog, then Add Products via Upload, and use the upload option.
- Choose the file type that matches your template, select the file and upload. Keep the Excel format Amazon gave you unless the instructions say otherwise.
- Track progress in the upload status or monitor section of the same page.
- When processing finishes, download the processing report. It lists how many rows succeeded, which rows have errors and which have warnings, with the SKU, column and error code for each.
Processing time depends on file size and Amazon's queue, from minutes for a small file to hours for a large one. Treat warnings seriously: a row can process "successfully" while an attribute was ignored. Fix the failed rows in your original file, delete the rows that succeeded, and re-upload only the corrections.
Common flat file errors and how to fix them
Error wording changes over time and the processing report always has the final word, but these codes come up again and again.
| Code | What it means | How to fix it |
|---|---|---|
| 8541 | Your product ID matched an existing ASIN, but your attribute values (such as brand or title) conflict with the catalog | Look up the ASIN; align your data, or open a case if you own the brand and the catalog is wrong |
| 8560 | The SKU did not match an ASIN, and creating a new one requires attributes you left blank | Fill the missing attributes named in the report (often brand, product type or other required fields) |
| 8572 | Amazon could not verify your GTIN as belonging to the brand on the listing, based on the GS1 database | Use GTINs licensed from GS1 to your brand, make sure brand names match exactly, or provide proof to Seller Support |
| 5665 | You need approval to list under that brand | Apply for Brand Registry for your own brand, or get approval or authorization through Seller Support |
| 8058 | A required value is missing or invalid, for example a weight without its unit of measure | Check the field named in the report against Data Definitions and add the missing paired field |
| 90057 | A field contains a value Amazon does not accept, often the variation theme | Replace it with an exact value from Valid Values; these are case-sensitive |
A few non-code problems also cause trouble:
- Copy-pasted data from other sheets can bring hidden line breaks, tabs or smart quotes that shift columns. Paste values only.
- Edited header rows. Never rename, delete or reorder the header rows. Hide unused columns if you must, but keep them.
- Wrong marketplace template. A US template uploaded to Amazon.in (or the other way round) fails on valid values and units.
- Image URLs that need a login or expire. Amazon must be able to fetch every image URL directly.
Editing existing listings with a flat file (partial update)
You do not have to rebuild listings to change them. For edits:
- Download your current data, either through the Category Listings Report (under inventory reports, where available) or by filling a fresh template with your SKUs.
- Keep only the rows you want to change.
- Set update_delete to PartialUpdate on each row.
- Fill item_sku, the product type, and only the columns you are changing. Leave everything else blank.
- Upload and check the processing report.
The difference matters:
| update_delete value | What happens |
|---|---|
| Update (or blank) | Creates or fully replaces the listing; blank cells can clear existing data |
| PartialUpdate | Changes only the columns you filled; blanks are ignored |
| Delete | Removes your offer for that SKU |
Partial updates are ideal for catalog-wide jobs like shortening titles, refreshing bullets or rewriting search terms. Back up your catalog first, then test on five to ten SKUs before running the whole file.
2026 rules to respect in your flat file
Templates can lag behind policy, so these rules are worth checking against every row.
- Titles: 75 characters for most categories. Since July 27, 2026, Amazon is reported by several trade publications and listing software providers to cap titles at 75 characters, spaces included, for all categories except media. The supporting details move to a separate Item Highlights field (reported at up to 125 characters) where your template or Seller Central supports it. Run your item_name column through our free Amazon title checker before uploading.
- Backend search terms are measured in bytes. For Amazon.com and most marketplaces, generic_keywords must stay under 250 bytes; Amazon.in has historically used a lower limit, around 200 bytes. Going over can stop the field being indexed. Our backend search terms guide covers formatting and what to leave out.
- Bullets and description. Character guidance varies by category and is shown in Data Definitions. Keep each bullet to one clear benefit and avoid prohibited claims.
- Images and naming. If you upload image files rather than URLs, Amazon matches them by file name: identifier, period, slot code, period, extension, such as B0XXXXXXXX.MAIN.jpg and B0XXXXXXXX.PT01.jpg for the first gallery image. Our free bulk Amazon image processor resizes images and packs them into a correctly named ZIP.
- Product IDs. GTINs should be licensed from GS1 and match the brand on the listing, or you need an approved GTIN exemption.
Writing the content before it goes in the file
The flat file is only the delivery format. Rankings and conversion still depend on what you put in item_name, the bullets, the description and the search terms. Many sellers draft that copy first and paste it into the template in one pass. If you are writing for many SKUs at once, zonfy can turn a product link or photos into a full listing (title, bullets, description and backend search terms) that you can paste straight into the matching columns.
Flat file checklist
- Download a fresh template for the right product type and marketplace.
- Read Data Definitions and note every required column for your category.
- Fill SKU, product type, brand, product ID and ID type for every row.
- Copy dropdown values exactly from Valid Values, including capitalisation.
- For variations, add one parent row and child rows with matching parent_sku, theme and Variation relationship.
- Give every child a unique SKU, product ID and full set of theme attributes.
- Keep non-media titles within 75 characters and search terms under the byte limit.
- Check that every image URL is public, or name image files correctly for bulk upload.
- Set update_delete correctly: PartialUpdate for edits, Update only when you mean to replace.
- Upload a small test batch first and read the processing report.
- Fix failed rows, remove successful ones, and re-upload only the corrections.
- Keep a dated copy of every file you upload.
Get those twelve steps right and a flat file becomes the fastest, most consistent way to manage a growing Amazon catalog.
Free tools for this topic
See all free tools →Frequently asked questions
What is an Amazon flat file?
An Amazon flat file is a category-specific spreadsheet template (Excel, or tab-delimited text) that you download from Seller Central, fill with one row per product, and upload to create, update or delete listings in bulk. Each column is a listing attribute, such as SKU, brand, product ID, title, bullet points, search terms and image URLs.
Where do I download an Amazon flat file template?
In Seller Central, go to Catalog, then Add Products via Upload, and use the template or spreadsheet download option. Search for your product type, select the marketplace and any other product types you need, and generate the file. Amazon renames these menus from time to time, so if a label differs in your account, look for the bulk upload or spreadsheet option under Catalog.
How do I create a variation listing with a flat file?
Add one parent row with its own SKU, the parent value in the parentage column, the parent SKU field blank and a variation theme. Then add one row per child with its own SKU and product ID, the child value in the parentage column, the parent's SKU in the parent SKU field, the same variation theme, the Variation relationship type and a value for every theme attribute, such as size or color.
How do I edit existing Amazon listings with a flat file without overwriting them?
Set the update_delete column (Update Delete in newer templates) to PartialUpdate and include only the SKU plus the columns you want to change. A full Update replaces the listing with what is in the row, so blank cells can wipe existing data.
What does Amazon error 8541 mean?
Error 8541 means the product ID in your file matched an existing ASIN, but some of the attribute values you sent, such as brand or title, conflict with what is already in Amazon's catalog. Check the ASIN it matched and either align your data with the catalog or, if you own the brand and the catalog is wrong, raise a case with Seller Support.
Is the title limit in flat files now 75 characters?
Since July 27, 2026, Amazon is reported to cap titles at 75 characters, spaces included, for all categories except media. Templates may still show older maximums in the Data Definitions tab, so write to the 75-character rule for non-media products and confirm your category's current guidance.