One of the most common questions that is asked by Amazon Central Sellers is “How do I add a Parent to my existing products?” Unless you have manually created a parent and child products simultaneously there is no ability to go back and manually do so later. The solution is to do a Flat File upload that creates a new SKU for the parent and lists it as such for both of the current child products.
The reasons for doing this is because it makes it easier for your customer to choose size/color/options. If your products are all listed separately, a customer may come along and find a blue shirt, but then have to search your store or re-search on Amazon to find a red one. If the products are all listed under one parentage you are likely to increase sales of variations products.
Here’s how you do it:
- Login to Amazon Seller Central
- Go to Inventory – Add Products Via Upload
- Select “Download Template”
- Download the File Template and Browse Tree Guide of your current product listing
Open your File Template and populate the following information for the parent: (specifically all bold fields which are required)
- SKU (Typically this will be your child SKU’s with the variation left off ie: for ABC-1000-XL, etc., you would do ABC-1000)
- Leave Product ID and Product ID Type BLANK (Amazon will assign an ASIN and there is no UPC)
- Product Name, Brand Name, Manufacturer, Manufacturer Part Number
- Product Type (Select from Drop Down)
- Item Type Keyword (from Browse Tree Guide)
- Product ID: ASIN
- Product ID Type: ASIN
- Update/Delete: PartialUpdate
*Note that your child variations need to have unique names, like the “Product name – Size”
Enter the Information for the Varation like in the chart below. Choose the correct variation theme for both parent and child (always the same).
|Variation – Populate these attributes if your product is available in different variations (for example color or wattage)|
|Parentage||Parent SKU||Relationship Type||Variation Theme|
Lastly, fill out the section that you chose for Variation Theme. If you chose SizeName for variation theme, be sure to fill out the Size column for all child products. If you choose Color, be sure to fill out the Color and Color-Map (if applicable).
Save As Type Text (Tab Delimited) and upload the file by choosing Inventory for Non-Media Categories (if non-media) and select Upload Now. If all information is entered correctly it should create a variation parent that then houses the variation children.
Note that some sizes may not appear in order and there is nothing that is in Amazon’s system that allows you to correct for this currently. Once the Upload Status is Complete download your Processing Report. if the number of records activated equals the number of records uploaded the upload was successful. You may get an error in the report that a Main Image URL, Product Feature or Product Description but this is not needed for the parent.
Congratulations on creating or separating your first variation parentage on Amazon and happy sales…
Remove a Child ASIN from a Parent in Amazon
While adding child variations to a parent is somewhat complex, removing a child ASIN typically just requires a call to Amazon Seller Support, speaking with someone in the Amazon Catalog department, and asking them to manually separate the ASIN from the parentage. Updates should be visible on the listing page within 10-15 minutes.
Occasionally the catalog department will be unable to separate the ASIN and you will need to delete the parent and child products and re-upload them. Typically Amazon requires that you wait 24 to 48 hours before re-uploading the same SKU, but you can ask that they refresh the system on the backend to allow you to re-upload sooner to avoid loss of sales.
Note that before you delete any product or parent you should have seller support turn on the Category Listing Report and download it for every category you sell products in. Yes will allow you to easily create Excel spreadsheets to re-upload the products. Note that by simply deleting a parent ASIN any child variation will result in a 404 not found page error and will not be visible on Amazon.com.