← Back
← Back

Create a missing Amazon parent SKU

When Amazon expands a variation family into another marketplace, it may copy the parent and child ASINs and create the child seller SKUs, but leave the parent seller SKU missing.

Without that SKU, you cannot submit the expected parent-child relationships from your seller account, and Amazon may eventually treat the children as standalone listings. This guide shows how to create the missing parent SKU from Google Sheets. Once it is ready, repair the variation family.

Before you begin

  • Choose an existing child listing in the destination Amazon seller account and marketplace.
  • Use variations with the same brand and a variation theme supported for the product.
  • Make sure an admin of your Hopted account can review and submit the Writebacks.

Get started with the template

The template adds the configured columns and a START HERE guide to your Google spreadsheet.

  1. In your Google spreadsheet, open Hopted → Pre-made solutions.
  2. Find Create Parent SKUs (Writebacks) and select Use solution.
Full Pre-made solutions gallery in Google Sheets, with Create Parent SKUs (Writebacks) and its Use solution button in the first row
Choose Create Parent SKUs (Writebacks) from the Pre-made solutions gallery.
  1. Choose your Amazon Seller Central account and destination marketplaces when prompted.
  2. Open the copied Parent SKU Manager tab and wait for the child listings to sync.
Full Google Sheets view of the Parent SKU Manager template, with its configured column headers and START HERE tab
Blue headers mark the editable columns in this template. Command Status and Result is view-only.

Once the child rows have loaded, continue with Create the parent. The template already includes the columns described in the manual setup below.

1. Add the columns

To choose the columns yourself:

  1. Create an Amazon Seller Central sync or edit an existing sync for the destination account and marketplace.
  2. First add a field from Listing Details to make it the primary source for the existing child rows. Include SKU, ASIN, and Marketplace Country Code so you can identify each destination.
  3. In the field picker, add Command and Command Status and Result from Listing Commands. The Command column is editable; the result column is view-only.
  4. Save the sync and wait for the child rows to import. If you use several sheet tabs, configure and save each sync separately.

If Listing Commands is missing from the field picker, contact Hopted to enable access.

Full Hopted field picker over Google Sheets, showing Listing Details as the primary source and Command and Command Status and Result selected from Listing Commands
Add Command and Command Status and Result from Listing Commands after selecting Listing Details as the primary source.

2. Create the parent

  1. Choose one existing child row from the intended family in the destination marketplace.
  2. In that row’s Command cell, enter the command below, replacing DEMO-PARENT-SA with the real parent SKU you want to create. Use the seller SKU, not the parent ASIN.
CREATE_PARENT_SKU: DEMO-PARENT-SA
Google Sheets with synced child listings and CREATE_PARENT_SKU: DEMO-PARENT-SA entered in the first row’s Command cell
Enter the command in one existing child row. This example uses DEMO-PARENT-SA in marketplace SA.

The parent SKU must contain 1–40 characters and no tabs or line breaks. Submit once per parent, seller account, and marketplace; you do not need the command on every child row.

  1. Select only the Command cell. Open Hopted → Writebacks → Edits in selected range.
  2. Wait for the review to load. Check the source child SKU, destination account, marketplace, and command. Exclude unrelated edits.
Full Writebacks review dialog over the populated Google Sheet, showing the selected child SKU, marketplace SA and CREATE_PARENT_SKU command before submission
Writebacks shows the selected command and its destination marketplace before submission.
  1. Have an account admin select Submit changes.

Hopted uses your seller listing information first, with Amazon catalog information as a fallback. Typing a new row into the sheet does not create the parent; submitting the command does.

  1. To create parents in bulk, enter one command per parent, seller account and marketplace on the appropriate child rows.
  2. Review and submit them together through Writebacks.

3. Check the result and parent readiness

  1. Read Command Status and Result on the source child row.
  2. Double-click the cell to expand it. Status can be Pending, Processing, Completed, or Failed.

Completed does not always mean the parent is ready.

  1. If the result says Amazon accepted the submission for processing, wait and check the exact parent SKU in Seller Central for that marketplace.
  2. Confirm that the parent exists and has no blocking errors before continuing. A compatible existing parent is reported with its actual ASIN.

Next: connect the children

Creating the parent does not connect its children. Once the parent is ready, follow Build or repair Amazon variation families to submit the child relationships separately.

If the command fails

  • Source SKU not found: use a child that exists in the selected seller account and destination marketplace.
  • Parent already exists but is incompatible or has blocking errors: check that SKU in Seller Central and resolve the reported problem before retrying.
  • Missing product information or variation theme: correct the source listing or use another suitable child from the same family. Read the full result for the missing requirement.
  • Temporary Amazon error: Hopted may retry automatically. Check the current result before submitting the same command again.

If you need help resolving an error, see Troubleshoot Writebacks.