Find out the story behind Optimal Workshop’s NZ$10m investment 🚀   Read More

MAG My Amazon Guy logo capitalized

It’s Always the UPC Field – How we Fixed 🔨 Parentage for eLhook!

eLhook, a universal video cam wall-mount product, needed the parentage rebuilt because the parent for the black and the white colors wasn’t connected.

First Things First
If you go into Seller Central and have a data issue, the most important thing you need to check is that UPC/EAN is enabled (Do this on the far right-hand side where you see a drop-down column for UPC/EAN). If it’s not, go up to the ‘Preferences’ column in the top right and Enable UPC.

When loading a product and using an ASIN in the GTIN field instead of using the UPC or the EAN, you may potentially cause massive catalog problems.

What to Look For
If you click edit on the listing and then ‘Vital Info’ and see the ‘Product Id’ field is grayed out, that means it cannot be changed manually.

The Solution
You will then need to do a full template upload. If you have experience, go ahead and do this, but it can be somewhat daunting for those unfamiliar with the process, and you’re probably better off hiring an expert.

  • On Seller Central, go over to ‘Inventory’ 
  • Click ‘Add Products via Upload’
  • The select ‘Download an Inventory File’
  • Once downloaded, you can choose the file from ‘PREVIOUSLY GENERATED TEMPLATES’ at the bottom and physically download it
  • Click on ‘Help’ > ‘Get support’

Because Amazon’s ticketing process isn’t always great, it’s advisable to message the catalog team directly as they have permission to enable this report:

  • Select ‘Selling on Amazon’ and then scroll down to ‘or, browse for your issue in the menu’ at the bottom
  • Click on the ‘Products, Listings, or Inventory’ option
  • Then choose ‘Inventory file upload issue’

Where you’re asked to describe your issue, type “Hi, can you please enable my full category export inventory report” and then simply scroll down and hit submit.

 When you receive it:

  • Go back to ‘Inventory’ on Seller Central 
  • Select ‘Inventory reports’ 
  • Click ‘Select Report Type’
  • Choose ‘Category Listings Report’


Once you receive this category listings export, it will be complete with all of your products. Go ahead and remove every product that doesn’t have an issue and leave the ones that do. You’ll now need to switch the Product ID field from ASIN to UPC:

In some instances, you may not know your UPC. If that’s the case, you may need to assign a new code, resulting in an error message. They will then produce the old original code, and you can simply go back to it. 

In this instance, to connect the black and white colors to the parent, go into the Excel file and make the parentage with a new SKU. We’re trying to connect a white and black color (the child ASIN’s).

  • Under “Variation” in Column T, select “Parent” and “Child” as necessary
  • List out the parent SKU to reference and connect the children to the parents
  • Under “Relationship Type” leave the Parent blank and make the Children “Variation”
  • Below “Variation Theme” select “ColorName”
  • If you’re not doing a full update, under “Update Delete” you need to switch this to “PartialUpdate” 
  • Whatever variation you’re using here, you’ll need to scroll over and fill it in 
  • In this case, we did the color name and white and black 
  • Next, you’re going to go into seller central and put your cursor under inventory and upload the file in question 
  • Put your email alert on here and hit upload file
  • This particular ticket took less than 10 minutes to process and Amazon enabled the report

Problem Solved!

I was fortunate to be part of MAG's first batch of its Advertising Internship Program. The timing was perfect for me as I was looking for an opportunity to learn more about Amazon PPC and at the same time to have hands-on training to work on accounts.  


When I started my internship, I listed down the things I wanted to learn. And I am happy to say that I've ticked all the boxes! My most favorite was "Optimization Using Bulk Files”. Bulk files and I, we did not get along at first, it was so scary seeing all those data! But I had a great mentor who guided me along the way. He patiently taught me step by step on how to process the data. He was very enthusiastic in answering all of my questions. He supported me until I gained the confidence in uploading my first, second, third (and so on) bulk uploads. 


The biggest advantage in working with MAG (and I must say one thing that I always look forward to every week) is its Weekly Ads Training. Every week, we discuss various topics about PPC. Interns/Ads Specialists/Ads Managers, we all share knowledge, information, and updates about PPC. During our discussions, we exchange ideas and feedback. It became an avenue not just to learn a skill, but also to clear any vague or ambiguous PPC topics. 


For me, the biggest disadvantage is the work schedule. As an Intern, I have to follow EST timing. The time difference from my location was only 8 hours, but being a morning person, I really struggled to keep myself awake. But if you are a night owl, then this will not be a problem for you.


So if you are considering joining the MAG Advertising Internship Program, my advice to you is to take action - APPLY NOW! The knowledge that you will gain and the skill that you will develop from this program will be invaluable. And who knows? From being an Intern, you might be the next one to be promoted as Jr. Ads Specialist! 

Maria Victoria Piedad