To use spreadsheets to create vouchers, follow the steps below:
|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. 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 YYYY-MM-DD date format. Your voucher will start at midnight of the start date. 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 YYYY-MM-DD 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.|
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?.
Cancelling a voucher: At any time, you can cancel any of your vouchers by clicking on the Deactivate button on your dashboard.