Sell on Amazon Sign in
This article applies to selling in: India

How to fix coupon upload spreadsheet errors?

After our system processes your upload spreadsheet, it allows you to download a status file with details of upload status and errors on each coupon. Please see details on errors and how to correct them:

Error: Invalid ASIN. Please correct it before uploading again.

You have provided a value in Column A which is not a valid ASIN. Please review the semi-colon separated ASIN list to make sure that all the ASINs are valid.

Error: Maximum ASIN limit (200 parent ASINs and 8,000 child ASINs) exceeded. Please remove some ASINs to adhere to the parent and child ASIN limit, and submit again.

A single coupon has a limit of 200 parent ASINs and 8,000 child ASINs. When you add a parent ASIN to a Coupon, all the child ASINs are automatically added. You can encounter Maximum ASIN limit exceeded error in the following scenarios:

Adding only child ASINs: If you are adding more than 8,000 child ASINs to the coupon, then your coupon will not be created. Please remove some child ASINs to stay within the 8,000 limit, and submit the spreadsheet again.

Adding only parent ASINs: If you are adding only 200 parent ASINs and are still encountering this error, then it is because the total number of child ASINs for the selected parent ASINs is exceeding 8,000. For example, if you add 200 parent ASINs with 50 child ASINs each, then you are trying to add 10,000 child ASINs to the Coupon which exceeds the 8,000 child ASINs limit. In this case, you need to remove 40 parent ASINs to adhere to the limit.

Adding a mix of parent and child ASINs: If you are adding a mix of parent and child ASINs, then the total number of child ASINs for the selected ASINs is exceeding 8,000. For example, if you are trying to create a coupon with 100 parent ASINs (50 child ASINs each) and 4,000 child ASINs, then you are trying to create a coupon with 9,000 child ASINs ((100 parent ASINs X 50 child ASINs) + 4,000 child ASINs). You can either remove some parent ASINs or some child ASINs to stick to the 8,000 limit, and submit the spreadsheet again.

Error: Maximum number of rows (100) exceeded.

You can create up to 100 coupons through one spreadsheet upload. Please do not enter any data in row 120 and beyond.

Error: An ASIN can only have one active coupon at a time. At least one of your ASINs is already scheduled for another coupon at an overlapping time. Please remove ASIN(s) with overlapping coupons and upload again.

An ASIN can only have one active coupon at a time. Either cancel the existing coupon that is scheduled, or remove the ASIN with the overlapping coupon from the upload spreadsheet.

Error: Start date of coupon cannot be more than 180 days from the day of creation.

Coupons can be created up to 6 months in advance. Please update your start date to fall within this time frame.

Error: Coupon title should only have alphanumeric characters.

Coupon titles can contain only alphanumeric characters. Please remove any special characters or symbols from Coupon title.

Error: Spreadsheet has missing input in required columns. Please provide all the required information and submit again.

All required columns are in red in the spreadsheet and must be filled before upload.

Error: Maximum Title character limit (80 characters) exceeded.

Coupon title should not be more than 80 characters. Please reduce the length of the coupon title.

Error: Start date cannot be in the past.

The earliest start date for a coupon can be the date of creation.

Error: End date of the coupon cannot be more than 90 days from the coupon start date.

A coupon can run up to 90 days. Coupon end date should not be more than 90 days from coupon start date.

Error: Coupon end date cannot be the same as start date.

The earliest end date for a coupon can be 1 day after coupon start date.

Error: Maximum budget allowed is ₹800,000,000. Please revise the budget and upload again.

Revise the coupon budget to be within the maximum limit.

Error: Minimum budget required is ₹1000. Please revise the budget and upload again.

Increase the coupon budget to at least the minimum required.

Sign in to use the tool and get personalized help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling On Amazon


© 1999-2022, Amazon.com, Inc. or its affiliates