How to create vouchers in bulk

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

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

   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 voucher on. ASIN list should be semi-colon separated. If you add a parent ASIN, all child ASINs will be automatically added to the Voucher.
   B	Discount type (£ off or % off)	Choose between Money Off OR Percentage Off.
   C	Voucher discount ‘% Off’ value	Fill in 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 voucher. Discount percentage should be between 5% - 80%.
   D	Voucher 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 voucher. Discount value must be greater than 0.
   E	Voucher title	Amazon automatically generates the beginning of your Voucher 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. 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 voucher titles are prohibited and can result in your voucher being deactivated.
   F	Voucher budget	Enter the budget amount that you want to add to the voucher. Minimum is £100. Note that voucher budgets are not hard limits. For details, refer to Why is my spend higher than my budget?.
   G	Voucher start date	Choose a start date within the next 180 days. Use DD/MM/YYYY date format. Your voucher will start at midnight of the start date. Please note that vouchers may take up to 4-6 hours to show on website after they go live.
   H	Voucher end date	Choose an end date within three months from voucher start date. Use DD/MM/YYYY date format. Vouchers end at 11:59 PM on the end date.
   I	Limit redemption to one per customer	Select Yes to limit redemption of your voucher to one per customer. Select No to allow your voucher to be redeemed multiple times per customer.
   J	Targeted Segment	Specify the customer segment your voucher should be visible to. For example, if you choose All customers, your voucher will be seen by all customers. If you choose Amazon Prime, your voucher will only be visible to Amazon Prime customers.

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

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

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

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

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

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