Bulk Update

Instead of editing every SKU one by one, you can prefer the “bulk update” option.

Request Template

To do so, go to the “Pricing Management” page. On the upper right side, there are three buttons which respectively are “Request Template“, “Upload Template” and “Export as Filtered“. Please see Figure 1 below.

Bulk Update Buttons
Figure 1 Bulk Update Buttons

To create a template for your store, click on the Request Template” button. Once your request is put in process, the button will show “In Progress” till the request is completed. Please see Figure 2 below.

In Progress
Figure 2 In Progress

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

Download Template
Figure 3 Download Template

The downloaded template has three sheets which respectively are “HELP“, “Example”, and “Bulk Update“. Please see Figure 4 below.

Three Sheets
Figure 4 Three Sheets

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. To see the detailed explanation, go and double-click on the related column. Please see Figure 5 below.

Help Sheet
Figure 5 Help Sheet

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

Bulk Update” sheet is the one on which you need to make changes. “SKU”, “ASIN” and “FULFILMENT CHANNEL” fields are automatically filled in. Fill in the other required fields as explained on the “HELP” sheet and save the changes.

Upload Template

To proceed with the bulk update option, you have to upload the template on which you made changes. To do so, click on the “Upload Template” button. A pop-up screen will appear. Drag or browse your file here. The process takes a while depending on the number of your listings. Please see Figure 6 below.

Pop Up Screen
Figure 6 Pop Up Screen

The upload status is shown on the right side of the pop-up screen. If there are any failed SKUs, you can download these SKUs by clicking on the “Download Failed SKUs” button and after making the necessary changes, upload them again by following the same steps. Please see Figure 7 below.

Upload Status
Figure 7 Upload Status And Download Failed Skus

Export as Filtered

You can export a “csv” file which provides detailed information for each SKU such as “Current Price“, “Buy Box Price“, “Quantity Available“, “Quantity Inbound” and many more.

You can filter the SKUs that you want to be in this csv file. To do so, go to”Filter by” field and choose the filter options as you need. Please see Figure 8below.

Filter By
Figure 8 Filter By

After choosing the filters, go and click on “Export as Filtered” button on the upper right side. Please see Figure 9below.

Export As Filtered Button
Figure 9 Export As Filtered Button

The csv file will be downloaded to you computer with the information of the SKUs you filtered.

Was This Article Helpful?
YesNo

Reach Us Anytime Via Live Chat for a Quick Response 24/7

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