Overview

Amazon's price discount template allows sellers to manage discounts for up to 500 SKUs at once through a simple spreadsheet upload. Rather than manually entering each product's discount one by one, this bulk tool streamlines the process of creating and editing price discounts directly from the Seller Central dashboard.

Key Points / What Sellers Need to Know

• Bulk upload capacity - The template supports up to 500 SKUs per upload, making it practical for sellers with large catalogs who want to run promotions across many products simultaneously.
• Two discount types available - Sellers can choose between fixed-price discounts (setting a specific sale price) or percent-off discounts (applying a percentage reduction), and the template adjusts its fields accordingly.
• Error handling built in - Amazon provides a way to download error reports directly into the template, so sellers can quickly identify and fix issues without starting from scratch.
• Uploads replace existing data - When uploading to an existing price discount campaign, the new file completely replaces all previous SKUs, discount amounts, and committed units. This is not an additive process.
• File format requirement - The template must be saved and uploaded in .xlsx format. Amazon will not accept any other file type.

How to Create a Price Discount Using the Template

To get started, navigate to the price discount dashboard in Seller Central and click to create a new price discount. Complete all required fields in the first step, which covers campaign details such as the discount type, schedule, and other settings. In the second step, select the products section and choose the upload option to download the spreadsheet template. The specific template you receive will depend on whether you selected a fixed-price or percent-off discount type during setup.

Filling Out the Template Correctly

Before entering any data, sellers should carefully review the instructions tab and the definitions tab included in the downloaded template. These tabs contain field definitions and examples that clarify what information is expected in each column. For fixed-price discounts, the required fields are SKUs, discounted prices, and committed units. For percent-off discounts, sellers need to enter SKUs, the percent-off amount, a minimum discounted price, and committed units. It is critical not to modify any header rows or delete any columns in the spreadsheet, as doing so will cause the upload to fail validation.