This article applies to selling in: Australia

How to fix coupon upload spreadsheet errors?

After our system has processed your uploaded spreadsheet, it allows you to download a status file with details on 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 that 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 a Maximum ASIN limit exceeded error in the following scenarios:

Only adding child ASINs: If you are adding more than 8000 child ASINs to the coupon, your coupon will not be created. Remove some child ASINs to stay within the 8000 limit and submit the spreadsheet again.

Only adding parent ASINs: If you are only adding 200 parent ASINs and still running into this error, it is because the total number of child ASINs for the selected parent ASINs has exceeded 8000. 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 8000 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 has exceeded 8000. For example, if you are trying to create a coupon with 100 parent ASINs (50 child ASINs each) and 4000 child ASINs, then you are trying to create a coupon with 9000 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 adhere to the 8000 limit and submit the spreadsheet again.

Error: Maximum number of rows (100) exceeded.

You can create up to 100 coupons in 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 uploaded spreadsheet.

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

Coupons can be created up to six months in advance. Update your start date to fall within this time frame.

Error: Coupon title should only have alphanumeric characters.

Coupon titles can only contain alphanumeric characters. Remove any special characters or symbols from the 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 in 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 for up to 90 days. Coupon end date should not be more than 90 days from the coupon start date.

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

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

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

Revise the coupon budget to be within the maximum limit.

Error: Minimum budget required is $100. 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 personalised help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling On Amazon


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