Get the data
Amazon’s prefilled fileDownload the family spreadsheet
Hopted + Google SheetsImport listings and relationships into your Sheet
All use cases / Variation families
Build and repair Amazon variation families from Google Sheets.
Connect standalone listings or reconnect separated children to the right parent in bulk.
Bring your variations together
Keep related sizes, colors and other valid variations in the family where customers can find them.
Build a family
Connect existing standalone listings under the right parent.
Repair a broken family
Reconnect children that have become separated from their intended parent.
Set up another marketplace
Prepare the family relationships for listings in the destination marketplace.
Manage family relationships in one Google Sheet
Edit families in bulk
Fill the parent SKU down the intended child rows. Prepare several families in one sheet.
See the current relationships
Compare existing parent SKUs and variation themes with the changes you want to make.
Review before sending
Check each SKU, marketplace and edited field before an account admin submits the changes.
Work across marketplaces
Manage your destination listings in Google Sheets, with the right parent and variation theme for each marketplace.
Build or repair a family in three steps
01
Import the existing child listings and current family relationships.
02
Assign the intended Parent SKU and check Variation Theme and required attributes.
03
Review the selected edits, submit through Writebacks, then check the resulting family.
Missing a parent SKU? Create one directly from Google Sheets using Hopted, then connect your child listings.
Amazon’s file workflow vs. Hopted
Update variation families from Google Sheets, without downloading and uploading files.
Make edits
Amazon’s prefilled fileUpdate the downloaded file
Hopted + Google SheetsFilter, paste, and fill cells in Google Sheets
Send changes
Amazon’s prefilled fileUpload the file in Seller Central
Hopted + Google SheetsSelect cells, review changes, and submit from your Sheet
Questions & Answers
Yes. Enter the existing parent SKU in the intended children’s editable Parent SKU cells. Check the variation theme and required attributes, then review and submit the changes through Writebacks.
Yes. Give each child the parent SKU for its own family, then review the selected edits together. Check every destination account and marketplace before submitting.
Yes. Use the listings for each destination marketplace. The parent SKU, variation theme and required attributes must be valid for the product in that marketplace. Amazon validates the changes.
Create the missing parent first, confirm it is ready, then connect the children. Follow the parent SKU guide for that separate step.