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. 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:
If you choose Option 1 – Pre-populated file:
If you choose Option 2 – Blank file:
After you saved the changes, you need to upload your file. Follow the below steps:
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.
This field (Stock Keeping Unit) is used to track inventory. You must provide an SKU in your Automate Pricing file.
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.
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.
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.
This field contains your item price at the time of feed download.
This field contains your shipping price at the time of feed download.
This field contains the price + shipping of the buy box winning offer for this listing’s ASIN at the time of feed download.
This field contains the lowest price + shipping for this listing’s ASIN at the time of feed download.
This field contains the fulfillment channel (seller or Amazon) for your product.
This field contains the item condition of your product.
This field contains the sales rank of this listing’s ASIN.
This section describes the ways in which you can troubleshoot some of the common errors you might find when using the Automate Pricing file.
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.
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.
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.
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.