Instructors: How to Resolve CSV Upload Errors for the Bulk Coupons Tool

Content of file could not be parsed. Try again and if issue repeats again please contact support. 

Empty file / incorrect file / unexpected error

Try uploading a CSV file with the required inputs again.

Required column(s) course_id, coupon_type, coupon_code are missing

The file is missing required column(s)

Add the required columns

Course ______: cannot exceed the number of coupons allowed for the month 

• There have already been 3 coupons created for the calendar month for this course, which is the maximum amount allowed.

• Double-check your course information to confirm how many coupons you have remaining. If the maximum amount of coupons has been reached, you will not be able to create new coupons for the course until next month. 

course_id is invalid in rows ___

• course_id is blank
• course_id is not an integer value
• the instructor account doesn’t have permission to create coupons for this course_id
• You may have copied and pasted info into cells and then deleted the cells. These cells will now contain blank fields.

• Check your course_id in your course information file. Only use valid course_id values that you have “manage” permissions for.
• Open your file in a text editor and see if there are rows that look like “,,,,,,,,,”. If there are, either delete them in the text editor, or open Excel and delete the entire row (by highlighting the rows on the left side and clicking Delete).

coupon_type is invalid in rows ___

• coupon_type is blank
• coupon_type is not one of the 4 allowed values: best_price, custom_price, free_open, free_targeted

• Ensure that coupon_type is filled out and that these are the only options used, entered exactly like this: 
  • best_price
  • custom_price
  • free_open
  • free_targeted

coupon_code is invalid in rows ___

• coupon_code is blank
• coupon_code was already used for the same course in the past
• coupon_code is used more than once for the same course_id in the CSV upload
• Coupon code is not in the correct format (review the requirements for custom coupon codes).

• Ensure that you have a coupon code in the correct format that is unique at the course level.

start_date is invalid in rows ___

• start_date is in the past
• start_date is beyond the current month
• start_date is not entered in YYYY-MM-DD format 

• Ensure that your start date is in the current month and is on today’s date or later.

• Note: Excel can automatically change date formats. Enter your date with a leading apostrophe in the cell (e.g. ‘2022-03-20) or select the cells, right-click, click “Format Cells” and make sure “Text” is selected. Then fix the dates.

• Open the saved file with a text editor to check if the date formats are properly saved.

• Note: if the field is left blank, the tool will automatically use today’s date.

start_time is invalid in rows ___

• start_time is not entered in HH:MM (or H:MM) format

• Correct the start_time format to HH:MM or H:MM (e.g. 03:30, 3:30)

• Note: if the field is left blank, the tool will automatically use midnight (00:00). Or if the time is in the past, 00:00 will be entered.

custom_price is invalid in rows ___

• coupon_type = custom_price and no value was entered
• coupon_type = custom_price and custom_price is not entered as either a decimal value or as “min” or “max”
• custom_price is less than the allowed minimum
• custom_price is higher than the allowed maximum

• If you entered custom_price as the coupon_type, make sure you have a value. Check your course information to make sure your value is within the minimum and maximum range for that course.