Sell on Amazon Sign in
This article applies to selling in: India

Manage SKUs using the Automate Pricing file

Individual sellers: This feature is available to sellers with Professional selling plans.

You can now apply or remove SKUs from Automate Pricing rules using the 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, here you will have the option to download either:
    • Option 1 - a pre-populated file (recommended)
    Note: This will have the list of all Active SKUs not added on Automate Pricing & available fields pre-populated in the descending order of customer views
    • Option 2 - a blank feed file.

    If you choose Option 1- pre-populated file (recommended):

  4. You will get the option to select Number of SKUs (Top 500, 5000 or 15000) you want in your file. Default selection is Top 5000 SKUs. Post making this choice, you need to click on Request file.
  5. 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 on 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.
  6. 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.
  7. File will have auto-populated fields (refer Data Definitions) for SKU1, Item Name2, Country Code5, Currency Code6, Rule Action8, MRP with tax9, Current Selling Price10, Shipping Price11, Customer View Share12.
  8. Field number 9 to 12 are only for your information & need not be filled
  9. 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.
  10. To remove an SKU from Automate Pricing, change rule-action field to STOP.
  11. After you have filled the template, go to the "Automate Pricing Template" tab, and save the sheet in UTF-8 text format file.
  12. 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 typebox: 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.
  13. 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).
  14. To upload your file, go to the upload center, click Browse and select the Unicode test file (.txt) you created earlier.
  15. After you select your file, click Upload. When you upload your file, a status box confirms that your file has been received.

    If you choose Option 2 – Blank feed file:

  16. Enter the SKUs that you wish to automate.
  17. 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.
  18. (Optional) Enter the maximum price you want to keep your 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).
  19. Enter the country code for the country in which the SKU is listed. Note:
    Note: The country code is a two-letter code. The valid values for the code is IN.
  20. Enter the currency code for the country in which the SKU is listed.
  21. 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.
  22. To assign the SKU to a repricing rule, enter START in the rule-action field or, 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 an SKU from one rule to another.
  23. To remove an 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.
  24. To edit the minimum and maximum prices, maintain the same SKU, marketplace currency, rule name and START in the rule-action field, and adjust your minimum and maximum price values.
  25. Go to Automate Pricing Template tab and save the sheet in UTF-8 text format file (use steps 11 & 12 above)

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.

minimum-seller-allowed-price

This field is mandatory when running an Automate Pricing rule on an SKU, and ensures that Automate Pricing keeps your item price above the minimum item price you set. If you attempt to set your price for the product below your minimum allowable price, your offer will become inactive and you will be notified via email.

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

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

country-code

This field tracks the various countries in which the SKU is listed. To identify the correct country, provide the two-letter code. The valid value is IN.

currency-code

This field denotes the currency used in the country of the SKU. The valid value for currency is INR.

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.

mrp-with-tax

(Information only field) This is the Maximum Retail Price inclusive of taxes. You may use this field as a reference to fill other fields.

current-selling-price

(Information only field) This is your current selling price at the time of feed download. You may use this field as a reference to fill other fields.

shipping-price

(Information only field) This is your current shipping price at the time of feed download. You may use this field as a reference to fill other fields.

customer-views-share

(Information only field) This field gives you an idea around how important is that ASIN in downloaded file list from a customer view perspective. E.g. If your downloaded file has 100 ASINs & they collectively garner 1000 customer views. For an ASIN, which gets 200 customer views, customer view share would be 20% i.e. 200/1000. You can use this column for prioritization.

Information only fields (available in pre-populated file)

Troubleshooting

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

Missing information

Please enter a valid value for all the fields. If you enter an invalid input (for example, an invalid SKU, a character in the minimum/maximum price field, invalid rule name, or input besides START or STOP in the rule-action field), then the row will remain unprocessed.

Invalid minimum or maximum price

We run validations on minimum and maximum prices in Automate Pricing. If your minimum or maximum prices 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 30,000 rows per upload. If you input more than 30,000 rows, then all the rows beyond 30,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. Learn more

For more information on Best Price Rule, please click here.

Note: Business Pricing is paused only after submitting Business Price or Quantity Discount manually.

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-2021, Amazon.com, Inc. or its affiliates