To use spreadsheets to create coupons, 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 coupon on. ASIN list should be semi-colon separated. 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% - 50%.
|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. 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 ¥10000. 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 YYYY/MM/DD 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 3 months from coupon start date. Use YYYY/MM/DDdate 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 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.|
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?.
Cancelling a coupon: At any time, you can cancel any of your coupons by clicking the Deactivate button on your dashboard.