Bulk Update for Parent ASIN Management

Parent ASIN Pricing allows our customers to configure each of their Child ASIN’s prices according to the Parent ASIN. By choosing a Parent ASIN and Child ASIN, you will be able to apply any extra charges or lower prices to the Child ASINs. You may need different pricing solutions according to the size, color, and different batches of the items. Instead of editing every SKU one by one, you can prefer the “Bulk Update” option that is now integrated with Parent ASIN Management.

Request Template

First, you need to hover over to the menu on the left side of the app and click on the Parent ASIN Management tab on the “Pricing Management” page

On the upper right side, there are four options; “Request Template“, “Upload Template“, “Export Data, and “Template History“. See Figure 1 below.

Parent Asin Management 1
Figure 1 – Parent Asin Management

To create a template, hover on the “Request Template” button. And choose “Pricing Template as Excel“.

Second, it will be ready after some time depending on your SKU count. Meanwhile, you will see “In Progress” while your template is getting ready. See Figure 2.

In Progres
Figure 2 – In Progres

Once the request is completed, the button will turn into the “Download Template” button. To download the created template for your store, click on the button. See Figure 3.

Download Template
Figure 3 – Download Template

The template has three sheets which respectively are “HELP“, “Example“, and “Bulk Update“.

On the “Help” sheet, you can find the explanation of the columns on the “Bulk Update” sheet. If you are not sure what kind of information you should enter into a column, you can consult this sheet. See Figure 4 below.

Image 26
Figure 4 – Template

On the “Example” sheet, you can see an illustration of a filled-up template. See Figure 5.

The “Bulk Update” sheet is the one you should make changes to. “PARENT ASIN“, “CHILD SKU”, PARENT ASIN PRICING“ and “INVENTORY PROTECTION TYPE” are automatically filled in. Fill in the other required fields as explained on the “HELP” sheet and save the changes.

2022 09 23 17 06 22 Aqs5sy72tbyes Amazon.co .uk 9 23 2022 114659 1 Repaired Excel
Figure 5 – Example

P.S. For the “C” column, select the desired option (enabled, disabled) for all of the Child SKUs.
For the “D” column, you must enter only 1 value for the Master SKU.
For the “E” column, you must enter the same value for all the related cells.

Need More Help? Let Our Team Guide You To Success!

Was This Article Helpful?

Reach Our Experts Anytime via Chat, We Are Willing to Help You!

Can't find what you need in our Help Documentation? Get in touch with one of our Amazon Experts now!