Sell on Amazon Sign In
This article applies to selling in: Saudi Arabia

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 bulk from Automate Pricing rules using the Automate Pricing file template once you have created your rule in the Automate Pricing tool. The file supports up to 5,000 SKUs per load, 3 uploads per day. 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

  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. Download the Automate Pricing file template.
  4. Enter the SKUs that you wish to automate.
  5. 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.
  6. (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).
  7. 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.
  8. To assign the SKU to a repricing rule, enter START in the rule-action field.
  9. To assign the SKU to Automate Pricing, enter the SKU, minimum price, maximum price, rule name, and START in the rule-action field. This is the same process as moving a SKU from one rule to another.
  10. To remove a SKU from Automate Pricing, enter the SKU and STOP in the rule-action field. If you also enter a minimum and maximum price, we will adjust your minimum and maximum price, even though repricing has stopped on the SKU.
  11. To edit minimum and maximum price, maintain the same SKU, rule name, and START in the rule-action field, and adjust your minimum and maximum price values.
  12. After you have filled out the template, go to the "Automate Pricing Template" tab and save the sheet as a "Tab Delimited Text (.txt)" file.
  13. To upload your file, go to the Check and Upload your Inventory File tab. Under Step 2 in the File Type section, use the drop-down to select the Automate Pricing file type.
  14. In the File Upload section, click Browse, and select the tab-delimited file (.txt) you created earlier. After you select your file, click Upload. When you upload your file, a status box confirms that we have received your file.

Fields in the Automate Pricing file

Fields in the Automate Pricing file

If you are assigning a SKU to a rule, or adjusting a SKU already associated with a rule, the sku, minimum-seller-allowed-price, rule-name, and rule-action fields are mandatory. If you are removing a SKU from a rule, we require the sku and rule-action fields (with STOP).

Mandatory fields

sku

We use this field (Stock Keeping Unit) to track inventory. You must provide a SKU in your Price & Quantity file.

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)

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

Once you have associated an SKU to an Automate Pricing rule, uploading the price via the Price & Quantity file will pause repricing. When you update price via another file or an interactive page like Manage Inventory, your repricing is paused until you resume, either via this file or by resuming in the Automate Pricing tool. You can still use the Price & Quantity file to update your inventory quantity, minimum price, and maximum price. After uploading SKUs via this file, remove price values from the Price & Quantity file.

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