Sell on Amazon Sign in
This article applies to selling in: United States

Manage SKUs using the Automate Pricing file

Individual sellers: This feature is only available to sellers with a Professional selling plan. Learn more by visiting Selling plan comparison.

You can now apply or remove SKUs in multiple countries in the same region from Automate Pricing rules using the Regional Automate Pricing file template, once you have created your rule in the Automate Pricing tool. You can manage up to 30,000 SKUs per 24 hour period. There is no limit on the number of files you can submit . As soon as the feed is processed, your SKUs are applied to the rule you set, and Automate Pricing adjusts your price according to the rule, minimum price, and maximum price you enter.

The Automate Pricing file enables you to:

  • Assign SKUs to a pricing rule.
  • Upload modifications to your minimum price, maximum price (optional), assigned automated pricing rule.
  • Start or stop running automated pricing on a rule.
  • Onboard hundreds or thousands of SKUs to Automate Pricing at the same time, instead of being constrained to up to 100 SKUs at a time in the Automate Pricing tool.
Note: The Automate Pricing file is available to upload as a .txt file.

Using the Automate Pricing file

Note: You can refer to the “Sample” tab in the Automate Pricing file for details on how to fill out the file.
  1. Create your rule in the Automate Pricing tool. Learn more about how to Create a pricing rule.
  2. Click on Save & Select SKUs button after rule creation. Or, Edit SKUs for adding more SKUs.
  3. In the Edit SKU page, click on Manage SKUs via file upload. You will reach the Download center.
  4. Select the type of template file you want to download. There are 2 options:
    • Option 1 - a pre-populated file (recommended)
    • Option 2 - a blank template.
    Note: Option 1 will contain the list of all Active SKUs not added on Automate Pricing, along with some mandatory fields that are already pre-populated. You can download up to 5 pre-populated files in a 24-hour period.
    • Follow steps 5-16 if you choose Option 1- Prepopulated file.
    • Follow steps 17-30 if you choose Option 2 – Blank template.

    If you choose Option 1 – Pre-populated file:

  5. Select the number of SKUs that you want to download in your file. You can choose to download 500 SKUs, 5000 SKUs, or 15000 SKUs.
  6. Click the Request Automated Pricing File button.
  7. You can track the status of your request in the report library that is right below the download section. Once the pre-populated file is ready for you to download, you can click the download button. In the report library, you will be able to see the list of all files requested in the day and you can re-download the file at any given point.
  8. Downloaded file will have the list of all your SKUs not added on Automate Pricing in the descending order of views they receive from customers.
  9. File will have auto-populated fields (refer Data Definitions) for SKU1, Item Name2, Country Code5, Currency Code6, Rule Action8, Current Selling Price9, Shipping Price10, Buy Box Price + Shipping11, Lowest Price + Shipping12, Fulfillment Channel13, Condition14, and Sales Rank15.
  10. Field number 9 to 12 are only for your information and need not be filled.
  11. Enter the rule name, verbatim, from the rule you set in the Automate Pricing tool in your ready to upload file and add Minimum Seller Allowed Price3, Maximum Seller Allowed Price4 basis reference fields 9, 10 & 11 above.
  12. To remove an SKU from Automate Pricing, change rule-action field to STOP.
  13. After you have filled the template, go to the "Automate Pricing Template" tab, and save the sheet in UTF-8 text format file.
  14. If you are using Windows, go to the Save As dialog box next to the Save button and follow the steps below:
    1. In the Save as type box: select Unicode Text (*.txt)
    2. Click Tools and Web Options.
    3. Click Encoding. In the Save this document as box, select Unicode (UTF-8).
    4. Open the file you have just saved in Notepad.
    5. Resave the file by selecting File and Save as.
    6. In the Encoding box, select UTF-8.
  15. For Mac, follow the steps below:
    1. In the save as dialog box in the File Format drop-down menu, select Text EditUTF-16 Unicode Text (.txt) under Specialty Formats.
      Important: Take the following steps to convert the encoding from UTF-16 to UTF-8. Submitting the file in UTF-16 will result in a processing error.
    2. Open the file you have just saved in .
    3. Resave the file by clicking on File and Duplicate.
    4. In the Plain Text Encoding box, select Unicode (UTF-8).
  16. After you saved the changes, you need to upload your file. Proceed to step 31.

    If you choose Option 2 – Blank file:

  17. Click the Download Automated Pricing File button.
  18. Enter the SKUs that you wish to automate.
  19. For each SKU, enter the minimum item price you wish to keep your price above in the minimum-seller-allowed-price field. This will ensure Automate Pricing does not price the item below this value.
  20. (Optional) Enter the maximum price you want to keep you price below in the maximum-seller-allowed-price field. This will ensure Automate Pricing does not price the item above this value. If you do not set a maximum price, Automate Pricing will protect customer trust on your behalf by ensuring that your offers are not priced significantly higher than recent prices so that your offers remain eligible to become the Featured Offer (Buy Box).
  21. Enter the country code for the regions in which the SKU is listed. Note: The country code is a two-letter code. Valid values for the code is US.
  22. Enter the currency code for the country in which the SKU is listed.
  23. Enter the rule name, verbatim, from the rule you set in the Automate Pricing tool. You can copy and paste the rule from the tool.
  24. To assign the SKU to a repricing rule, enter START in the rule-action field.
  25. To assign the SKU to Automate Pricing, enter the SKU, minimum price, maximum price, country, currency, rule name and START in the rule-action field. This is the same process as moving a SKU from one rule to another.
  26. To remove a SKU from Automate Pricing, enter the SKU, country code, and STOP in the rule-action field. If you also enter other fields such as minimum price and maximum price, these will be ignored by the system and will not adjust your minimum and maximum prices.
  27. To edit the minimum and maximum prices, maintain the same SKU, country currency, rule name and START in the rule-action field, and adjust your minimum and maximum price values.
  28. Go to Automate Pricing Template tab and save the sheet in UTF-8 text format file.
  29. If you are using Windows, go to the Save As dialog box next to the Save button and follow the steps below:
    1. In the Save as type box: select Unicode Text (*.txt)
    2. Click Tools and Web Options.
    3. Click Encoding. In the Save this document as box, select Unicode (UTF-8).
    4. Open the file you have just saved in Notepad.
    5. Resave the file by selecting File and Save as.
    6. In the Encoding box, select UTF-8.
  30. For Mac, follow the steps below:
    1. In the "Save as" dialog box in the File Format drop-down menu, select UTF-16 Unicode Text (.txt) under Specialty Formats.
      Important: Take the following steps to convert the encoding from UTF-16 to UTF-8. Submitting the file in UTF-16 will result in a processing error.
    2. Open the file you have just saved in Text Edit.
    3. Resave the file by clicking on File and Duplicate.
    4. In the Plain Text Encoding box, select Unicode (UTF-8).

    After you saved the changes, you need to upload your file. Follow the below steps:

  31. Go to Pricing and select Automate Pricing.
  32. Click Edit SKUs for the rule you have created.
  33. Select Manage SKUs via file upload button and go to Upload Center tab.
  34. In the File Upload section, click Choose File button and select the tab-delimited file (.txt) you created earlier.
  35. Click Upload Automate Pricing File. When you upload your file, a status box confirms that your file has been received.

Fields in the Automate Pricing file

Fields in the Automate Pricing file

If you are assigning an SKU to a rule, or adjusting an SKU already associated with a rule, the sku, minimum-seller-set-price, country-code, currency-code, rule-name and rule-action fields are mandatory. If you are removing an SKU from a rule, the sku, country-code and rule-action fields (with STOP) are required.

Mandatory fields

sku

This field (Stock Keeping Unit) is used to track inventory. You must provide an SKU in your Automate Pricing file.

country-code

This field tracks the various countries in which the SKU is listed. To identify the correct country, provide the two-letter code. Valid values are US, CA, MX.

currency-code

This field denotes the currency used in the country of the SKU. Valid values for currency are, MXN for Mexico marketplace, USD for US marketplace and CAD for Canada.

rule-name

This field assigns your SKU to the Automate Pricing rule you choose. To assign a rule, choose the name of the rule you created using the Automate Pricing tool. To avoid errors, copy and paste the rule name from the tool. When creating a rule, do not use symbols in the rule name.

rule-action

This field allows you to start repricing on the rule you select, or stop repricing. To start repricing an SKU, enter START in this field after you have entered the SKU, minimum price, maximum price, and rule name in the respective fields. To stop repricing an SKU, enter STOP in this field after you have specified the SKU name. If you enter additional fields, we will process them at the same time as removing the SKU from the rule. For more information on these fields, see the Data Definitions tab of the Automate Pricing file.

Information only fields (available in pre-populated file)

maximum-seller-allowed-price

This field is optional when running an Automate Pricing rule on an SKU, and ensures that Automate Pricing keeps your item price below the maximum item price you set. If you did not set a maximum price, Automate Pricing will protect customer trust on your behalf by ensuring that your offers are not priced significantly higher than recent prices so that your offers remain eligible to become the Featured Offer (Buy Box). If you attempt to set your price for the product above your maximum allowable price, your offer will become inactive and you will be notified via email.

To change your maximum allowable price, modify the value in this field and upload the updated file. If you enter "STOP" in the rule-action field, your maximum price will not be updated; we will only remove the SKU.

Note: To remove the maximum price value for an item, use the Price & Quantity file and enter the value "delete" in this field. Do not enter "0" or other numeric values. If you include this field but do not provide a value for an item, no change will be made to your existing maximum price value.

current-selling-price

This field contains your item price at the time of feed download.

Shipping-price

This field contains your shipping price at the time of feed download.

Buybox-landed-price

This field contains the price + shipping of the buy box winning offer for this listing’s ASIN at the time of feed download.

Lowest-landed-price

This field contains the lowest price + shipping for this listing’s ASIN at the time of feed download.

Fulfillment-channel

This field contains the fulfillment channel (seller or Amazon) for your product.

Condition

This field contains the item condition of your product.

Sales-rank

This field contains the sales rank of this listing’s ASIN.

Troubleshooting

This section describes the ways in which you can troubleshoot some of the common errors you might find when using the Automate Pricing file.

Missing information

Enter a valid value for all the fields. If you enter an invalid input (for example, an invalid SKU, a character in the min/max field, invalid rule name, or input besides START or STOP in the rule-action field), then the row will not be processed.

Invalid minimum or maximum price

We run validations on minimum and maximum price in Automate Pricing. If your minimum or maximum price are outside of the accepted threshold, then the row will not be processed. Learn more about Minimum and Maximum price validation.

Exceed row limit

The Automate Pricing file supports up to 5,000 rows per upload. If you input more than 5,000 rows to be processed, all rows beyond 5,000 rows will not be processed.

Pause due to manual update

You can now choose to continue repricing or pause repricing after submitting a manual price update. To learn more, refer to Continue or Pause Repricing After Manual Price update.

Sign in to use the tool and get personalized help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling On Amazon


© 1999-2020, Amazon.com, Inc. or its affiliates