Bulk Update

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

Request Template

To do so, you can go to the “Pricing Management” page. On the upper right side, there are four buttons; “Request Template“, “Upload Template“, “Export as Filtered”, and “Template History“. See Figure 1.

Image 13
Figure 1 – Pricing Management and Template Buttons

To create a template for your store, hover on the “Request Template” button. There, you will see four template options which are “Pricing Template as Excel“, “Pricing Template as CSV“, “Advanced Settings Template as Excel” and “Advanced Settings Template as CSV“. See Figure 2.

Please noted that for your stores that have SKU numbers higher than 50K you need to proceed bulk update process by “Pricing Template as CSV” and “Advanced Settings Template as CSV“. On the other hand, the “Pricing Template as Excel” and “Advanced Settings Template as Excel” options are only valid for stores that have SKU numbers less than 50K.

Image 33
Figure 2: Pricing Templates and Advanced Pricing Templates

To request a template, first, click on the one that you prefer. 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 3.

Image 15
Figure 3: In Progress

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 4.

Image 16
Figure 4: Download Template

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

Bulk Update
Figure 5: “HELP”, “Example” and “Bulk Update” 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. See Figure 6 below.

Help Sheet
Figure 6: “Help” Sheet

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

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

Export as Filtered

You can export a CSV file that 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. First, go to the “Filter by” section, and second, choose the filter options you need. See Figure 9 below.

To do so, first, go to the “Filter by” section, and second, choose the filter options you need. See Figure 9 below.

Bulk Update 3 2
Figure 9: “Filter By” Section

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

Bulk Update 4
Figure 10: “Export As Filtered” Button

The CSV will be downloaded to your computer with the information of the SKUs you filtered.

Moreover, you can bulk update the filtered SKUs by the settings below:

  • Minimum Price
  • Maximum Price
  • MAP Price
  • Fixed Price
  • Cost
  • ROI(%)
  • Margin(%)
  • Enable ROI or Margin
  • VAT on Product Cost
  • VAT on Sales
  • FBM Shipping
  • Shipping to FBA Cost
  • Additional Cost
  • FBA Fee
  • Enable Repricing

You may check the Upload Template section below for more detailed information about the bulk update process. Please be aware that you should select the “Pricing Template as CSV” option to upload the “Export as a Filtered” file.

Upload Template

To proceed with the bulk update option, you have to upload the template on which you made changes. To do so, hover on the “Upload Template” button. There, you will see four template options which are “Pricing Template as Excel“, “Pricing Template as CSV“, “Advanced Settings Template as Excel” and “Advanced Settings Template as CSV“, please proceed by selecting the appropriate option. See Figure 7.

Image 34
Figure 7: Pricing Templates and Advanced Pricing Templates

Once you selected the appropriate template, 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 7 below.

Bulk Update 2 1
Figure 7: “Upload Files” 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. See Figure 8 below.

Upload Status
Figure 8: Upload Status And Download Failed SKUs

Pricing Template as Excel & CSV

Pricing Template” is the template for the general information of your SKU. This template includes the settings below;

  • Minimum Price
  • Maximum Price
  • MAP Price
  • Fixed Price
  • Cost
  • ROI(%)
  • Margin(%)
  • Enable ROI or Margin
  • VAT on Product Cost
  • VAT on Sales
  • FBM Shipping
  • Shipping to FBA Cost
  • Additional Cost
  • FBA Fee
  • Enable Repricing

Advanced Settings Template Excel & CSV

Advanced Settings Template” is the template that involves the settings on the “Advanced Pricing Settings“. This template includes the settings below.

  • Enable Buybox Sharing
  • Minimum Buybox Ownership(%)
  • Enable Fulfillment Channel Competition
  • Inventory Protection Days
  • SKU or Store Level for Inventory Protection Days
  • Enable Price Rounding
  • SKU or Store Level for Price Rounding
  • Price Rounding First Digit
  • Price Rounding Last Digit
  • Enable Target Velocity
  • Target Velocity Initial Price
  • Target Velocity Unit Target
  • Target Velocity Unit Interval
  • Target Velocity Increase (%)
  • Enable YoYo
  • SKU or Store Level for YoYo
  • YoYo Increase By
  • YoYo Increase Value
  • YoYo Trigger Hour Interval
  • YoYo Wait Minute Interval
  • Enable Brand Competition Strategy
  • SKU or Store Level for Brand Competition Strategy
  • Enable Competitor Pricing Threshold
  • SKU or Store Level for Competitor Pricing Threshold
  • Enable Scheduled Pricing
  • Increase or Decrease for Min Price
  • The Threshold for Min Price Increase
  • The Threshold for Min Price Decrease
  • Rate of Min Price
  • Unit Threshold for Scheduled Pricing
  • Time Interval to Check
  • Enable Amazon Competition
  • SKU or Store Level for Amazon Competition
  • Amazon Competition Increase By
  • Amazon Competition Type
  • Amazon Competition Value

Please keep in mind that if your store has more than 50K SKUs, you must perform a bulk update using the “Pricing Template as CSV” and “Advanced Settings Template as CSV” options. The “Pricing Template as Excel” and “Advanced Settings Template as Excel” options are only available for stores with fewer than 50K SKUs.
Important Note: Due to some Excel limitations and settings, when you download an Advanced Settings Template, you may encounter this error shown below screenshot when opening the file, if so please click “Yes” and continue, the file will be working smoothly.

Image 60
Image 60

Template History

This area is for you to display the template history in 3 sections; “Upload History”, “Downloaded History” and “Export as Filtered History”. To do so, click on “Template History”, and a pop-up screen will appear. Please see Figure 9 below.

Image 35
Figure 9: Template History

Upload History

To check your uploaded template history, click on the first section “Upload History” from the pop-up screen. You can display the details as User, Request Time, Complete Time, Uploaded SKUs, Failed SKUs, Status, and Templated ID. Please see Figure 10 below.

Image 37
Figure 10: Upload History

Download History

This area for you to display the downloaded template history. You can click on “Download Report” to download the past template. Please see Figure 11 below.

Image 36
Figure 11: Download History

Export as Filtered History

This area for you to display the Export as Filtered History. You can click on “Download Report” to download the past template. Please see Figure 12 below.

Image 38
Figure 12: Export as Filtered History
Was This Article Helpful?
YesNo

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!