How to Create Amazon Variation Listings Using a Flat File Template

If you sell a product in multiple sizes, colors, or styles, creating separate listings for each version is one of the most common mistakes new Amazon sellers make. It splits your reviews, your sales history, and your search ranking across multiple ASINs instead of building one strong listing.

A variation listing solves this by grouping all versions of a product under one parent, with each version as a child ASIN that customers can select from a dropdown. While Amazon lets you create variations manually through the Add a Product workflow, the flat file method is the faster and more reliable approach when you have multiple variations to set up at once.

This guide walks through exactly how to build a variation listing using Amazon’s flat file template, including the required fields, a worked example, and the most common errors that cause uploads to fail.

Table of Contents

1. What is a Parent-Child Relationship?
2. How to Download the Right Flat File Template
3. Key Columns You Need to Fill In
4. Step-by-Step: Building the Parent Row
5. Step-by-Step: Building the Child Rows
6. Worked Example
7. How to Upload and Check Status
8. Common Errors and How to Fix Them

What is a Parent-Child Relationship?

A Parent ASIN is a container that is not directly purchasable. It exists only to group related products together. A Child ASIN is an actual, buyable product, such as one specific size and color combination.

When a customer visits the listing, they see the parent’s main content (title, main image, brand) along with a dropdown to select the size, color, or other variation they want. Selecting a different option shows that child’s specific price, images, and availability without leaving the page.

Amazon allows up to 2,000 child ASINs under a single parent. In practice, keep your variation count reasonable. A listing with too many options can overwhelm customers rather than help them.

How to Download the Right Flat File Template

1. In Seller Central, go to Inventory > Add Products via Upload.
2. Select Download Product Spreadsheet

3. Choose your product category and select Advanced.
4. Download the Excel file. It contains multiple tabs, including Instructions, Images, Valid Values, and the Template sheet. We need to complete and fill in the Template tab 

Always download a fresh template rather than reusing an old one.Amazon updates field requirements and validation rules periodically, and an outdated template is one of the most common causes of upload errors.

Before building your file, check the Valid Values tab to confirm which variation themes (Size, Color, SizeColor, Style, Flavor, etc.) are supported for your category. If no variation theme is listed for your product type, variations are not supported in that category.

Key Columns You Need to Fill In

These are the core columns that control the parent-child structure. They appear in every category template, though exact column positions vary.

• SKU: Your unique identifier for each row (parent and every child)
• Parent SKU: Links a child to its parent. Left blank for the parent row.
• Parentage: Set to “Parent” for the parent row, “Child” for every child row
• Variation Theme: Set on both the parent row and every child row. Must be identical across all rows in the family.
• Variation attribute columns: The actual values being varied, for example size_name or color_name, filled in only on child rows

Step-by-Step: Building the Parent Row

The parent row defines the listing as a whole but is never directly sold.

5. Create a unique SKU for the parent. A common convention is to prefix it, for example PARENT-TSHIRT-001.
6. Leave the Parent SKU column completely empty.
7. Set Parentage to “Parent”.
8. Set Variation Theme to the theme you confirmed earlier, for example “SizeColor”.
9. Fill in shared attributes that apply to the whole family: brand, product title (representing the family, not one variation), product description, and bullet points.
10. Do not fill in: price, quantity, weight, dimensions, or any image fields. These belong only on child rows since they differ per variation.

Step-by-Step: Building the Child Rows

Each child row represents one actual, sellable product.

11. Create a unique SKU for each child, ideally following a pattern that relates to the parent, for example TSHIRT-001-RED-M.
12. In the Parent SKU column, enter the exact SKU of the parent row. This value must be identical, character for character, across all child rows. Watch for typos or extra spaces, this is one of the most common causes of broken relationships.
13. Set Parentage to “Child”.
14. Set Variation Theme to the same value used on the parent row.
15. Fill in the variation attribute columns relevant to your theme. For example, if your theme is SizeColor, fill in both the size_name and color_name columns with this specific child’s values.
16. Fill in all standard product fields for this specific child: price, quantity, weight, dimensions, and main image. Each child needs its own main image showing that specific variation.
17. Give each child a unique Product ID (UPC, EAN, or similar). Amazon requires every child to have its own unique identifier. Reusing a UPC across multiple children will cause the upload to fail.

Worked Example

Here is how this looks for a t-shirt sold in two colors and two sizes, using the SizeColor variation theme.

Parent row

• SKU: PARENT-TSHIRT-001
• Parent SKU: (blank)
• Parentage: Parent
• Variation Theme: SizeColor
• Title: Cotton Crew Neck T-Shirt

Child row 1

• SKU: TSHIRT-001-BLK-S
• Parent SKU: PARENT-TSHIRT-001
• Parentage: Child
• Variation Theme: SizeColor
• color_name: Black
• size_name: Small
• Price, quantity, image: specific to this child

Child row 2

• SKU: TSHIRT-001-BLK-M
• Parent SKU: PARENT-TSHIRT-001
• Parentage: Child
• Variation Theme: SizeColor
• color_name: Black
• size_name: Medium
• Price, quantity, image: specific to this child

Continue this pattern for every size and color combination you carry.

How to Upload and Check Status

18. Save your completed file. Most templates need to be saved as the format specified in the template instructions, often a tab-delimited .txt file rather than .xlsx.
19. Go to Inventory > Add Products via Upload.
20. Select Upload your inventory file, choose your file, give the upload a name, and select your marketplace.
21. Go to the Monitor Upload Status tab to track processing. This shows how many rows succeeded, how many had warnings, and how many failed, with specific error messages for each.
22. If any rows failed, fix the specific issue in your file and re-upload. You can re-upload just the corrected rows; you do not need to resubmit the entire catalog.

Common Errors and How to Fix Them

• Wrong or unsupported variation theme: Each category only allows specific themes. Check the Valid Values tab in your template for the themes supported in your category before building the file.
• Parent SKU missing Variation Theme: Even though the parent row is not buyable, it still needs the Variation Theme field filled in. A blank Variation Theme on the parent row is a common rejection cause.
• Child SKUs not matching the parent SKU exactly: Every child’s Parent SKU value must match the parent row’s SKU exactly, including case and spacing. Even a single extra space will break the relationship.
• Duplicate Product IDs: Each child must have its own unique UPC, EAN, or other identifier. Reusing the same code across multiple children causes the upload to fail.
• Inconsistent attributes across children: All children in the same family should share the same core attributes aside from the variation itself. If your theme is SizeColor, every child needs both a size_name and color_name filled in, using values from the approved list in the Valid Values tab.