You can now apply or remove SKUs in multiple countries in the same region 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:
b. Open the file you have just saved in Text Edit.
c. Resave the file by clicking on File and Duplicate.
d. In the Plain Text Encoding box, select Unicode (UTF-8).
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, maximum-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 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.
This field is mandatory 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 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 tracks the various countries in which the SKU is listed. To identify the correct country, provide the two-letter code. Valid values are UK, FR, IT, ES, DE, TR.
This field denotes the currency used in the country of the SKU. Valid values for currency are GBP for UK, EUR for DE, IT, ES, FR, and TRY for TR.
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 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.
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.