Instead of editing every SKU one by one, you can prefer the “bulk update” option.
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.
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.
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.
The downloaded template has three sheets which respectively are “HELP“, “Example”, and “Bulk Update“. Please see Figure 4 below.
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.
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.
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.
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.
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.
After choosing the filters, go and click on “Export as Filtered” button on the upper right side. Please see Figure 9below.
The csv file will be downloaded to you computer with the information of the SKUs you filtered.