Parent SKU in Variations Over-Written

Amazon is now (for whatever stupid reason) overriding Parent SKUs at creation.

To explain better: When I create a new Parent, I’ve always used a unique coded identifier for the SKU on the ‘Offer’ page so I can look at all of my listings in a particular category or type if needed (by searching the inventory list). I do the same with the child variations.

Well as of maybe a week ago (?) those unique identifiers are ignored and they’re built with a generic Amazon SKU. I tried creating from scratch and copying an existing. It does the same. No idea why.

:roll_eyes: :rage: :face_with_symbols_over_mouth:

BUT WHY THO?!?! Ugh, Amazon needs to get its bot fingers out of 3P listing minutiae and focus on the big problems :rage:


It makes zero sense. And sure, it could be a bug - but can you imagine even trying to explain this to a support person? Not even going to try. So annoying.

1 Like

File upload or Variation Wizard?


Well as of maybe a week ago (?) those unique identifiers are ignored and they’re built with a generic Amazon SKU.

It’s only the parent SKU, right? The self-assigned SKU’s you give the children stay as you put them? Can you just ignore the parent SKU issue since a parent isn’t a sellable item? As long as they’re leaving your child SKU’s alone, you should still be able to view all your listings. :crossed_fingers:

I also build codes into my SKU’s, so I hope they’re just overriding the parent. :grimacing:

1 Like

Variation Wizard - I think? I just do Add a product, and add variations while creating the parent.

Yes, just the Parent. But I have over 200 Parents & all of my variations are sizes (5-7 each), so I really liked being able to search for just the parents in each of my product categories - much more condensed, rather than a huge list of all the child listings. :confused: Alas.


I hope this isn’t something “new” from Amazon, so that they can control the parents.

I would try one with a template, or wait a few days to see if Amazon fixes it next week.

Sadly, I just looked at dates and it’s been like this for awhile - I just didn’t notice until now, when I was searching for something and couldn’t find it.

I’ve never used a template, my guess is I’ll just have to live with it. :confused:

You shouldn’t unless this is permanent.

I can help you with the template. It’s really easy after the pages are created to delete the parent and create a new parent. The data needed is minimal.

I would pick a small group to test on and download the category template from here: NEW BTG’s and Inventory File Templates (scroll down past "Use Global Sku’s)


I’m taking a look - eep - never used a template since I always create new products one at a time. Trying to find the template for handmade now - maybe one of my handmade friends knows which it is.

First for @oneida_books and @Roxy your hand held out to @LR72 is kind, gentle, honorable and amazing.

One dynamic here is Up until about a year ago, Amazon Handmade could not even do variations. So you will see those in Handmade struggling with the concept. Especially with the Flat Files, that is the only way we have always done it on the commercial side.

I am making some assumptions LR, and I hope you don’t mind. I just thought it would be good for everyone to know.

I am fortunate enough to have grown a longtime team member to handle the catalog page creation, so I can run other things.

For this conversation, I will call her my engineer, however she is more than that. I need to find a way to have her contribute, if not to the soon to be open part of the forum, to the locked forum of founders.

My fear she, like me, may spend to much time here. When she helps in production, I am always saying, “Get back in your seat and make money.”

It is complicated with our family first requirement for team members. Unlike I who work any 12 hour period a day I pick, they have weekends and holidays off no exceptions.


So try this instead to get the right template:


And then select -


It should land you here:

I am able to get to this by typing in handmade, so I believe you can get the template you need.



Haha - Assume away! And yes, I created every parent/child individually. Now it’s only new products and I can knock out a parent/child in about 10 minutes.

And yes, thank you SO MUCH for your help! Off to daughter’s soccer game - I am going to dig into this when I get back. I’m always up for an easier way and definitely want to test this out!

1 Like

When I go to ‘Get Product Template’ then it downloads the listing loader - I don’t have the page to type in Handmade. Will have to look more to find it.

Try the direct link I put up.


That worked - I tried that first and it gave me a page not found (stupid Amazon). Working now. Thank you!

EDIT: Needless to say, I feel pretty dumb for not figuring this out and using it from the get-go. Would have made duplicating various fields and information much easier. Oy vey.


Notes - Since the children exist already, and should have the relevant fields already filled in you should be able to go minimal on the fields needed.

  • Category
  • sku
  • parentage/variation info
    A test on the first set will give you all that is needed if you upload and then check the results. (I’ll edit this to show you what to expect)

For existing a Variation Relationship:

  1. Build the template with the parent to recreate and copy all it’s info in
  2. Add the children
  3. Delete the old parent
  4. Upload


So you’ll see this in the upload tab.


After upload, if it doesn’t switch, you go to the far right tab.


Check the far right button:

It will give you info on errors to fix.


Speaking of children, @LR72 aren’t you late for the soccer game!


No - daughter already left on her own, so we have a reprieve!


All this talk about templates and file uploads confuses the heck out of me (I’ll resist until the very end… :laughing: ) but when I create variations manually, I never think to add a unique SKU for the parent, so all of mine have Amazon’s randomly assigned number. I long ago learned to search by titles instead of SKU’s when looking for a parent.

If overriding parent SKU’s is a permanent “fix” by Amazon, maybe you can include a specific keyword in each parent’s title, so you can still look them up by the groupings you want. Just a backup suggestion if the file uploads don’t take your own parent SKU.

1 Like