Sell on Amazon Sign In
This article applies to selling in: Italy

How to fix coupon upload spreadsheet errors?

After our system processes your upload spreadsheet, it allows you to download a status file with details upload status and errors on each coupon. 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. Review the semi-colon separated ASIN list to make sure all ASINs are valid.

Error: Maximum ASIN limit (200 parent ASINs and 8000 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 8000 child ASINs. When you add a parent ASIN to a Coupon, all child ASINs are automatically added. You can run into 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, your coupon will not be created. 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 still running into this error, 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, you are trying to add 10,000 child ASINs to the Coupon which exceeds the 8,000 child ASIN 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. 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. Update your start date to fall within this timeframe.

Error: Coupon title should only have alphanumeric characters.

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

Error: Spreadsheet is missing input in required columns. Please provide all 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. 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: The 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 more than 90 days from coupon start date.

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

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

Error: Maximum budget allowed is €10,000,000. Please revise budget and upload again.

Revise the coupon budget to be within the maximum limit.

Error: Minimum budget required is €100. Please revise 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-2021, Amazon.com, Inc. or its affiliates