Product variations & variation listings can prove to be quite the challenge, and sometimes are a ridiculous quirk of SellerCentral – especially if you’re a new Amazon FBA seller or if you haven’t created a variation listing before.
But fear no more! In this article, we’ll go through the steps to creating variation listings like a pro – by using an Inventory File and uploading it through SellerCentral to make changes to our listings.
Here are the steps that we will follow:
- Navigate to the Inventory Upload page
- Download the inventory file for your category
- Create our parent listing row in the file
- Fill-in our child listing rows in the file
- Save the file as tab-delimited .txt
- Upload the file through SellerCentral
- Check our processing report & new listing structure
Download an Inventory File Template:
The first thing we want to do is download an Inventory File from SellerCentral. This file includes a template which allows us to simply fill out the fields we need without having to worry about everything else.
Navigate to ‘Inventory’ then ‘Add Products via Upload’
Go to the ‘Download an Inventory File’ tab
Select your product’s category (item-type)
There’s two ways to select the item-type of your listing:
1) You can use the search feature to quickly locate your item’s category. This is particularly useful if you already know your product’s category or if you know the category your product should end up it. When using this search feature make sure to select the correct category path from the results – sometime the same browse node (most specific category) can be found in multiple higher-level categories, some of which might be incorrect for your product.
2) If you are using this Variation Listing method to create a listing for a new product, it’s probably a better idea to use the ‘Product Classifier’ section to find the right category for your product. It’s fairly self explanatory: just keep going down the category rabbit-hole until you’re met with a ‘Select’ button.
*Note: If you’re unsure of your products category, you can head to ‘Inventory’ > ‘Manage Inventory’ and click the Product Name (listing title) to open your listing on Amazon.com. Provided you’re signed into your SellerCentral account, the full Category path for your listing should be displayed at the top of the page – right above the product images & title.
Generate your Inventory File Template
For the mode simply select ‘Advanced’. This should be the option that is selected by default. It will include all possible data fields – many of which won’t even apply to your product, but for the purpose of creating a new listing or variation it does not make a difference.
Open your Inventory File Template using Excel
Go ahead and open up your Inventory File Template using Excel or any other spreadsheet software of your choice.
The file might seem a bit overwhelming at first if you aren’t used to dealing with big data or haven’t worked a lot with spreadsheets. Don’t worry though – most of it just supplemental information & instructions to help you fill out the template successfully.
The main tab we will be focusing on is the ‘Template’ tab.
Filling out the Inventory File Template
Once you open up the ‘Template’ tab you’ll see what seems to be a never-ending amount of columns dedicated to all sorts of data Amazon might gather for a single listing. Once again – most of it probably doesn’t apply to your product/listing and therefore we don’t need to worry about it. We’ll mainly be focusing on the Required and Variation sections, and one or two data fields in the Basic and Discovery sections.
Select the Product Type
Product Type or
feed_product_type should be available for you to select from the drop-down if you’ve chosen your product category correctly when generating the Inventory File Template.