An Amazon flat file is a category-specific tab-delimited spreadsheet template (typically .txt or .xls) sellers use to create, update, or delete listings in bulk. It exposes fields that are not available in the standard Add-a-Product form and is the fastest way to manage catalogs at scale.
How Flat Files Work
- In Seller Central, navigate to Catalog → Add Products via Upload → Download an Inventory File.
- Select the product category — each category has its own template with unique required and optional fields.
- Fill the Template tab: SKU, product-id, product-id-type (UPC/EAN/ASIN), item-name, brand, and all attributes required for the category.
- Save as tab-delimited text (.txt) and upload via the Upload Products & Inventory tool.
- Check the Monitor Uploads report — Amazon returns row-level success, warning, or error messages.
Common Flat File Field Types
| Field Type | Example | Notes |
|---|---|---|
| Identifier | SKU, product-id, external-product-id | SKU is your internal reference; product-id links to Amazon’s catalog |
| Descriptive | item-name, brand, manufacturer, product-description | Governed by category style guides |
| Discoverability | generic-keywords (backend), item-type-keyword | Where search-term optimization happens |
| Variation | parent-child, variation-theme, size, color | Groups a family into a parent-child relationship |
| Compliance | country-of-origin, safety-warning, batteries-required | Category-dependent; missing values can suppress the listing |
When Sellers Use Flat Files
- Launching 50+ SKUs at once — the manual form is too slow beyond a handful of variations.
- Building a variation family — parent-child structure is easier to define in a spreadsheet than click-by-click.
- Correcting bad data across many listings — one column update, one upload, done.
- Backend-keyword updates in bulk — the generic-keywords field is exposed as a column.
- Category migrations — moving SKUs from the wrong browse node to the right one.
How SellerSonar Helps
- The Catalog Management tool tracks which SKUs are live and flags listing suppressions triggered by bad flat-file uploads.
- Retail Issues Alerts surface unauthorized listing changes that a flat-file upload — yours or someone else’s — may have caused.
Start your free SellerSonar trial today.
Related Terms
- Backend Keywords — the generic-keywords column in a flat file is where these live
- Parent-Child Variations — the variation family structure defined in flat-file columns
- Listing Suppression — a common consequence of missing or invalid flat-file fields