Amazon Flat Files: How to Build, Upload, and Fix Bulk Listings

TL;DR: How Flat Files Work From Template to Upload

The short version:

• Bulk templates: Edit many listings in one upload.

• Back up first: Save a Category Listings Report.

• Use PartialUpdate for edits: Blank cells won't wipe live content.

• Match variation data: Parents and children share one theme.

• Read the processing report: It shows which rows failed.

What Is an Amazon Flat File?

An Amazon flat file is a spreadsheet template you fill in to create or change listings in bulk. Amazon officially calls it an inventory file template, and sellers use the two names interchangeably.

Each template is built for a specific category, so the columns change with the type of product you sell. A footwear template and a kitchen template ask for very different attributes.

Inside the workbook, three tabs do most of the work:

• Template: The tab you fill in, with one row per SKU.

• Data Definitions: A field-by-field explanation of each column, including whether it is required for your product type.

• Valid Values: The accepted entries for fields with a fixed list, such as variation themes.

Amazon also notes that macros in inventory file templates are no longer supported. If you still work from an older template that relied on built-in automation, switch to a current version before your next upload.

When Should You Use a Flat File Over Add a Product?

Add a Product is Amazon's one-listing-at-a-time form, and it works well for a few SKUs. Amazon's help page on creating listings one at a time notes that this form cannot add multiple listings at once and is unavailable for some categories.

A flat file is the better tool in these situations:

• Launching many SKUs at once: You can build an entire product line in one file and upload it in a single step.

• Editing the same field across many listings: Bullet points, search terms, or images can change across a whole category without opening each listing.

• Building variation families: Parent and child relationships are easier to define and check in a spreadsheet.

• Listing in several marketplaces: Amazon's multi-marketplace template lets you select your marketplaces before you generate the file.

• Keeping a record of your catalog data: Amazon recommends saving a backup copy of every completed file, which gives you a reference for what you sent.

This is the day-to-day work our team manages inside Seller Central. A careful bulk process is where most of the time savings come from.

Which Template Do You Need?

The right template depends on whether your product already exists in Amazon's catalog. Picking the right one first saves a round of avoidable errors.

Here are the main options Amazon offers:

• Category-specific product template: Use this to create detail pages for products that are not yet in the catalog, or to change product data on existing ones.

• Pre-filled template for existing products: Search by product ID for items already in the catalog, and Amazon generates a template with those products filled in.

• Inventory Loader: This one is built for media products that already exist in the catalog, and a single file can cover several categories.

• Variation Wizard template: Amazon auto-populates this template to help you create parent-child relationships in bulk.

If you sell in more than one marketplace, select every marketplace you need before you generate the template.

How to Create and Upload an Amazon Flat File

The five steps below take you from a blank template to a confirmed upload, with a safety check built into each one:

Step 1: Save a Backup of Your Current Listing Data

Before you change anything live, download a copy of what Amazon currently holds for your SKUs. The Category Listings Report does this, and you will find it under Reports → Inventory Reports.

If the report is missing from your dropdown, Amazon directs sellers to contact Seller Support to enable it for their categories.

Step 2: Generate a Fresh Template

Go to Catalog → Add Products via Upload, choose your product type, and select your marketplaces before you generate the file. In some accounts, the same tool appears under Add Products → Spreadsheet.

Download a new template for every bulk job. Amazon revises its templates and required fields over time, so a copy saved from an earlier project can be missing columns it now expects.

Step 3: Complete the Template Tab

Work through the Template tab one row per SKU, and check the Data Definitions tab for any field you are unsure about.

These columns deserve extra attention:

• SKU: Your own identifier for the listing, which Amazon uses to connect the row to your inventory record.

• Product ID and ID type: The UPC, EAN, or other identifier that tells Amazon which product the row describes.

• Update/Delete: The operation Amazon performs on that row, covered in Step 4.

• Search terms: Backend keywords shoppers never see, limited to under 250 bytes in most marketplaces. An entry over the limit can be ignored entirely.

• Required attributes: Any field the Data Definitions tab marks as required for your product type.

For any field with a fixed list, copy the entry exactly from the Valid Values tab. A close match with different spelling still counts as an invalid value.

If you are sourcing product codes for a new brand, it is worth reading up on GS1 barcodes before you fill in the product ID column.

Step 4: Choose the Right Update Mode

The Update Delete column controls what Amazon does with each row. A wrong choice here can undo good listing content in a single upload.

Pick the mode that matches the job:

• Update: Creates the listing if it does not exist, or replaces the existing record with the data in your row. Blank cells can wipe out content that was live before the upload.

• PartialUpdate: Changes only the fields you include and leaves everything else alone. Amazon requires this exact spelling and capitalization.

• Delete: Removes the SKU from your inventory.

A lot of sellers assume Update only changes the cells they filled in. In practice, a targeted edit such as new bullet points belongs in a PartialUpdate row with the SKU, the product ID fields, and only the columns you are changing.

Step 5: Upload the File and Read the Processing Report

Upload the completed file from the same Add Products via Upload area, then watch the upload status section until processing finishes. Processing time depends on the size of the file.

Once it completes, download the processing report. The summary at the top shows how many records were processed and how many succeeded, and each issue falls into one of two types:

• Errors: The record could not be processed, so that row's changes did not go through.

• Warnings: The record processed, but the data might not display the way you intended.

Amazon does not count the first two rows of the template as records, so an error on Record 1 points to line 3 of your file. Fix only the rows that failed, then re-upload them in a smaller file.

Running these five steps once is manageable. Repeating them for every category, marketplace, and catalog change is where the hours add up.

At Seller Candy, we are the done-for-you operations team for brands and resellers selling products on Amazon, handling listings, catalog fixes, cases, reimbursements, and reinstatements. As an Official Amazon Service Provider working on an unlimited-tasks model, our team turns bulk uploads around fast.

So if working through processing reports is eating into your week, hand your next upload to us.

Book a free consultation, and our team will handle your next flat file upload from template to final processing report.

How to Build Variation Families in a Flat File

Variations, also called parent-child relationships, group closely related products such as sizes or colors under one detail page. The parent is a non-buyable listing that ties the family together, and each child is a version shoppers can buy.

Start with the parent row:

• Parent SKU: Leave this field blank.

• Parentage: Enter "parent."

• Variation theme: Pick a theme from the Valid Values tab, such as size, color, or a combined size-color theme.

Then complete each child row:

• Parent SKU: Enter the parent's SKU, identical on every child.

• Parentage and relationship type: Enter "child" and "variation."

• Variation theme: Match the parent's theme exactly.

• Theme attributes: Fill the columns the theme depends on, so a size-color child needs both a size and a color value.

Keep the product type the same across the parent and every child. If the Valid Values tab lists no variation theme for your category, Amazon does not allow variations there.

Family size has a ceiling too, since Amazon does not display variation families with more than 2,000 child ASINs on the detail page. Amazon's variation setup steps cover the full rules.

If you only need to attach one new child to a live family, you can also add a variation to an existing listing directly in Seller Central.

Common Upload Errors and How to Fix Them

Here are the errors to check first, along with the fix for each:

• Outdated template: Columns are missing or renamed because the template is old. Generate a fresh copy and move your data across.

• Invalid value: A field holds text Amazon does not accept for that column. Replace it with an exact entry from the Valid Values tab.

• Missing required attribute: A field marked required for your product type was left blank. Check the Data Definitions tab and complete it.

• Content wiped after upload: A full Update row had empty cells over live content. Restore the data from your Category Listings Report backup and resend it as a PartialUpdate.

• Variation not forming: The theme, parentage, or product type does not match across the family. Align all three and confirm the theme attributes are filled.

• Search terms ignored: The field runs over the byte limit. Trim it below the limit and remove repeated words.

• Product ID rejected: The code is invalid or already tied to a different product. Look it up in Verified by GS1 to confirm which company it is licensed to before you re-upload.

If a listing went inactive after an upload, the steps for fixing suppressed Amazon listings apply here too.

What Happens When a Flat File Upload Goes Wrong?

One upload can change every SKU in the file, so a single mistake travels just as far.

The damage usually shows up in a few ways:

• Lost listing content: Titles, bullets, or images disappear when a full Update overwrites them with blank cells.

• Suppressed or inactive listings: Listings missing required data can stop selling until you fill the gaps.

• Broken variation families: Children that fall out of a family lose the shared detail page shoppers use to compare options.

• Hours of cleanup: Each affected SKU then needs its own correction, often through more uploads or Seller Support cases.

When a family splits, reviews can end up scattered across separate pages. That is why split reviews and orphaned ASINs deserve a quick check after any variation upload.

Are Flat Files Being Phased Out?

Not for sellers who upload templates in Seller Central. Amazon has retired flat file and XML listing feeds for software that connects through its Selling Partner API, moving those integrations to JSON-based listing tools.

Amazon's Selling Partner API announcement states that the change does not affect listing files sellers upload directly in Seller Central. If a third-party tool manages your listings, ask the provider whether it has moved to Amazon's newer listings API.

How to Keep Flat File Uploads Safe Over Time

A few habits keep bulk uploads predictable from one project to the next:

• Start every job with a fresh template: Old copies may be missing fields Amazon now requires.

• Back up before every upload: Save a Category Listings Report so you can restore anything that changes unexpectedly.

• Test a small batch first: Upload a handful of rows, read the processing report, then send the rest.

• Default to PartialUpdate for edits: Save full Update rows for new listings or complete rewrites.

• Keep a master file: Store your latest approved data for each category in one place, with dated versions.

• Review every processing report: Clear warnings as well as errors, since warnings flag data that may not display as intended.

As your catalog grows across SKUs and marketplaces, dedicated Amazon catalog management support can take templates, variation fixes, and upload troubleshooting off your list.

Frequently Asked Questions (FAQs)

Below are the questions brands and resellers selling products on Amazon commonly ask about flat files: