Bulk Coupon Creator Tool for BigCommerce

To create coupon codes using the wizard, select "Create via Wizard" from the drop down menu.

This will bring up the wizard which allows you to select various formatting options for your coupon codes, which include:

• Coupon Length: a numerical value between 3 and 20.  Keep in mind, BigCommerce allows a maximum coupon code length of 50 characters, and this will include any prefix, suffix, or delimiter you may add.
• Number of Coupons to Generate: a numerical value between 1 and 500,000
• Coupon Prefix: allows you to set an optional set of characters to prepend to your coupon code such as “VIP” or “JULY.”
  • Allowed characters:
    • a-z
    • A-Z
    • 0-9
    • Underscore and hyphen ( _ and - )
• Coupon Suffix: allows you to set an optional set of characters to append to your coupon code such as “THANKS” or “2023.”
  • Allowed characters:
    • a-z
    • A-Z
    • 0-9
    • Underscore and hyphen ( _ and - )
• Character Set: allows you to set the formatting and character sets for the coupon code such as:
  • Allowing or disallowing upper and lower case letters
  • Allowing or disallowing numerical digits
• Coupon Delimiter: allows you to set a delimiter that will separate elements of the code such as a hyphen.
  • Allowed characters:
    • a-z
    • A-Z
    • 0-9
    • Underscore and hyphen ( _ and - )
• Coupon Split Length: allows you to set the number of characters where the code will be split by the delimiter. For example, if you have a 16-digit coupon code, you can set the length to 4 so the code would be split such as “1234-5678-9012-3456.”
• Max Uses Per Code: the maximum number of times the coupon code can be used. This should be a numerical value between 1 and 10,000.
• Max Uses Per Customer: the maximum number of times the coupon code can be used by a single customer. This should be a numerical value between 1 and 1000.

Once your formatting options have been selected, a sample of the coupon code will be shown in the example box at the bottom of the screen.

Once you have verified the coupon details are correct, click Next.

By default, Your Store Tools will provide a notification on the dashboard as well as a notification via email when the job is complete.  If you choose not to receive a notification via email, you can turn this option off on this screen, or change the email address it will be sent to.

It's important to note that depending on the number of coupon codes you are creating, it can take several minutes for the process to complete.

Once your selection is made, click Submit to finish.

By accessing the stacked menu in the upper right corner of the tool's tile from the dashboard, you can access the following:

• View Promotions:
  • Displays a list of all current promotions set up in BigCommerce as well as their details including:
    • Name: The name given to the promotion in BigCommerce.
    • Status: Whether the promotion is marked as enabled or disabled in BigCommerce.
    • Redemption Type
    • Max Uses: The number of maximum uses set in the default (non-unique) coupon code.  Unique coupon codes can have alternate values for this field.
    • Current Uses: The number of times the default (non-unique) coupon code has been used.
    • Start Date
    • End Date
  • Allows you to export an Excel or CSV file of all bulk coupon code usage for a select date range.
• History - a list of the last 7 days of processing history for this tool.
• Help - a link to this support document.

The Bulk Coupon Creator allows you to upload up to 500,000 unique bulk coupon codes that you generated outside the app.

To begin, you will first need to create a CSV file with your coupon data.  It's important to note that BigCommerce only supports the following characters for coupon codes, this includes the code, any prefix or suffix, or delimiters.

• a-z
•  A-Z
•  0-9
• Underscore and hyphen ( _ and - )

Your CSV file must contain a header row with the following fields:

• Coupon Code: The pre-generated, unique coupon code.  Keep in mind, BigCommerce allows a maximum coupon code length of 50 characters.
• Max Uses Per Code – the maximum number of times the coupon code can be used. This should be a numerical value between 1 and 1000.
• Max Uses Per Customer – the maximum number of times the coupon code can be used by a single customer. This should be a numerical value between 1 and 1000.

To begin, launch the Bulk Coupon Creator Tool from the tile on the Your Store Tools dashboard.

Then, select which storefront you want to run this tool on along with the existing promotion you want to create coupon codes for.

Once your promotion is selected, you can click on View Promotion Details to view more information about the promotion you're creating coupons for.  Details displayed include:

• Name: The name given to the promotion in BigCommerce.
• Status: Whether the promotion is marked as enabled or disabled in BigCommerce.
• Redemption Type
• Max Uses: The number of maximum uses set in the default (non-unique) coupon code.  Unique coupon codes can have alternate values for this field.
• Current Uses: The number of times the default (non-unique) coupon code has been used.
• Start Date
• End Date

When you're ready to proceed to the next step, click Next.

Select "Import from File" from the drop down menu.

Upload your CSV file.

Click Next.

Map the columns in your CSV file to the appropriate fields, then click Next.

By default, Your Store Tools will provide a notification on the dashboard as well as a notification via email when the job is complete.  If you choose not to receive a notification via email, you can turn this option off on this screen, or change the email address it will be sent to.

Once your selection is made, click Submit to finish.

By accessing the stacked menu in the upper right corner of the tool's tile from the dashboard, you can access the following:

• View Promotions:
  • Displays a list of all current promotions set up in BigCommerce as well as their details including:
    • Name: The name given to the promotion in BigCommerce.
    • Status: Whether the promotion is marked as enabled or disabled in BigCommerce.
    • Redemption Type
    • Max Uses: The number of maximum uses set in the default (non-unique) coupon code.  Unique coupon codes can have alternate values for this field.
    • Current Uses: The number of times the default (non-unique) coupon code has been used.
    • Start Date
    • End Date
  • Allows you to export an Excel or CSV file of all bulk coupon code usage for a select date range.
• History - a list of the last 7 days of processing history for this tool.
• Help - a link to this support document.

Premium subscribers have access to schedule tools to run in advance.  This option will be displayed after you set your notification type.

By default, the scheduling option is set to No.  If you do not want to schedule the tool, click Submit.

If you want to schedule the tool to run at a later time, click Yes.

From here you can select to schedule the tool to run at a specific date and time:

The scheduled start time is the time the tool will run, not complete.

Once you set the day and time for the tool to run, click Submit.

Premium subscribers have access to schedule tools to run in advance.  This option will be displayed after you set your notification type.

By default, the scheduling option is set to No.  If you do not want to schedule the tool, click Submit.

If you want to schedule the tool to run at a later time, click Yes.

From here you can select to run the tool on a recurring basis:

Options for recurring jobs include:

• Schedule Start Date and Time: The day and time the first instance will run.
• Repeat: The recurring schedule for this tool, which can be:
  • Daily
  • Weekly
  • Monthly
• Specify Hour: The hour of the day the tool will run.
  • Times are based on the time zone set up in your Company Profile.
  • Recurring runs can only be schedule at the top of the hour.
• Ends: When the recurring job should stop. Options include:
  • Never
  • After a set number of runs have completed
  • On a specific date and time

The scheduled start time is the time the tool will run, not complete.

Once your recurring options are set, click Submit.

In addition to the regular scheduling option available on all tools with the premium plan, the Update Guest Order tool allows store owners an additional scheduling option for checking historical orders on a regular, recurring basis.

This additional schedule, allows you to do the following:

• Schedule a daily run to check and associate orders from the previous day.
• Schedule a weekly run to check and associate orders from the previous day, week, two weeks, or three weeks.
• Schedule a monthly run to check and associate orders from the previous day, week, two weeks, three weeks, month, two months, or three months.

In order to use this method for scheduling, you must set the schedule by going to the tool's tile in the Your Store Tools dashboard and select Create Schedule from the stacked menu:

From there you can schedule the tool to run on a daily, weekly, or monthly basis.

Unfortunately, once a unique, bulk coupon code is created, there is no way to delete it.  This is due to two factors:

1. BigCommerce does not allow bulk coupons to be viewed, edited, or deleted within the store's control panel.
2. Our Bulk Coupon Creator does not allow the option to delete a single or multiple coupon codes to be deleted due to the number of API calls that would be required to locate and delete individual codes.

BigCommerce restricts coupon codes to only contain the following characters:

• a-z
• A-Z
• 0-9
• Underscore and hyphen ( _ and - )

This applies to the prefix, code, delimiters, and suffix whether created via the wizard or uploaded via a CSV file.

If you created a promotion within BigCommerce and it's not showing up in the drop-down list of promotions in Bulk Coupon Creator, you need to clear the BigCommerce API cache.

To do this, simply click on the clear cache button at the top of the screen:

Once this is done, your promotion should appear in the drop down list.