How to create coupons in bulk

To use spreadsheets to create coupons, follow the steps below:

1. Go to Advertising, and then select Coupons.
2. Click Create a new coupon on the dashboard.
3. In the Create in bulk section on the right, click Download template file.
4. Open the file and fill out the spreadsheet according to the instructions provided below.
   Note: Each row in the spreadsheet is a separate coupon. If you want to add multiple ASINs to the same coupon, add them in the same cell in column A, separated by a semicolon.

   Spreadsheet column	Column title	Details
   A	ASIN list	Enter up to 200 parent ASINs or 8,000 child ASINs that you want to run a coupon on. ASIN list should be separated by a semicolon. If you add a parent ASIN, all child ASINs will be automatically added to the coupon.
   B	Discount type ($ off or % off)	Choose between Money Off OR Percentage Off.
   C	Coupon discount “% off” value	Fill this section only if you selected % off in Column B. Leave blank if you selected $ off. Enter the discount percentage amount that you want to offer on the coupon. Discount percentage should be between 5% and 80%.
   D	Coupon discount “$ off” value	Fill this section if you selected $ off in Column B. Leave blank if you selected % off. Enter the discount percentage amount that you want to offer on the coupon. Discount value must be greater than 0.
   E	Coupon title	Amazon automatically generates the beginning of your coupon title with the discount that you selected (example: Save 10% on). Input the rest of the title that will be displayed to customers. Using brand and product name is recommended. The limit is 80 characters. Please note that entering offensive words, discount amounts/percentages, referring to events (such as Prime Day or Black Friday), or using languages that are not supported in the given marketplace in coupon titles are prohibited and can result in your coupon being deactivated.
   F	Coupon budget	Enter the budget amount that you want to add to the coupon. Minimum is 50 units. Note that coupon budgets are not hard limits. For details, see Why is my spend higher than my budget?.
   G	Coupon start date	Choose a start date within the next 180 days. Use MM/DD/YYYY date format. Your coupon will start at midnight of the start date. Please note that coupons may take up to 4-6 hours to show on website after they go live.
   H	Coupon end date	Choose an end date within three months from coupon start date. Use MM/DD/YYYY date format. Coupons end at 11:59 PM on the end date.
   I	Limit redemption to one per customer	Select Yes to limit redemption of your coupon to one per customer. Select No to allow your coupon to be redeemed multiple times per customer.
   J	Targeted segment	Specify the customer segment that your coupon should be visible to. For example, if you choose All customers, your coupon will be seen by all customers. If you choose Amazon Prime, your coupon will only be visible to Amazon Prime customers.

5. Save your file as a .xls spreadsheet.
6. Click Choose file, select the .xls file you saved in previous step, and click Upload.
7. Our system will start to process your spreadsheet. Refer to Recent uploads to review the status of your coupon spreadsheet:

   Processing: Spreadsheetis going through basic validations. Status will change to Success or Error.

   Success: Spreadsheet was processed successfully and coupons were created. Note that this does not mean that your coupon will run. After a spreadsheet has been processed successfully, our system will run a number of validations on the coupon. Monitor the status of the coupon in the coupons dashboard.

   Errors: There were errors in creating coupons. Download the ‘Status file’ to review the errors and take the required actions to correct them. For details, see How to fix coupon upload spreadsheet errors?.
   Note: The earliest a coupon can go live is six hours after creation. Coupons created with a same day start date will require at least six hours for our system to run a number of validation rules on your coupon to make sure that it offers a good value to our customers. We currently do not allow the creation of coupons more than six months in advance (Start date of coupon cannot be more than six months from the day of creation).

   Cancelling a coupon: At any time, you can cancel any of your coupons by clicking the Deactivate button on your dashboard.

   Note: Cancellations might not be immediate because customers who have already clipped your coupon before cancellation will be allowed to check out with those coupons for approximately 30 minutes.