Overview

Amazon sellers who need to create multiple coupons at once can use a bulk spreadsheet upload process through Seller Central. Rather than building each coupon individually, this method lets you define dozens or even hundreds of coupons in a single file, saving considerable time during promotional campaigns or seasonal sales events.

Key Points / What Sellers Need to Know

• Spreadsheet format required - Amazon provides a downloadable template file that must be filled out and saved as an XLS file before uploading.
• Each row equals one coupon - Every row in the spreadsheet represents a separate coupon, and multiple ASINs for the same coupon should be listed in a single cell separated by semicolons.
• ASIN limits apply - Each coupon must include between 15 and 2,900 ASINs. Adding a parent ASIN automatically includes all child ASINs. For coupons with fewer than 15 child ASINs, use the standard coupon creation workflow instead.
• Budget minimums and soft caps - The minimum coupon budget is $100, but keep in mind that coupon budgets are not hard spending limits, meaning actual spend may exceed your set budget.
• Activation delay - It can take four to six hours after creation for a coupon to become active in the store, so plan your start dates accordingly.

How the Spreadsheet Works

The bulk coupon template includes columns A through L, each controlling a different aspect of your coupon. Column A holds your ASIN list, while columns B through D define the discount structure. You can choose between a percentage-off discount (ranging from 5% to 50%) or a fixed dollar-off amount (which must be greater than zero). Column E is where you complete your coupon title, keeping in mind that Amazon automatically generates the beginning of the title with your discount value. Titles are limited to 80 characters, and sellers should use brand and product names rather than promotional language. Amazon prohibits specific words, discount percentages, and references to events like Prime Day or Black Friday in coupon titles, and violations can result in coupon deactivation.

Scheduling and Duration Rules