WooCommerce – Create Coupons from a List of Emails or User Names

Our loyal customers play an important role in the growth and development of our WooCommerce stores. And it wouldn’t be a bad idea to reward them once in a while with a discount coupon. In addition to rewarding their loyalty, we would motivate them to buy in the future.

And that doesn’t have to be a headache. We want to show you how to create coupons from an email list. This email list must be in a spreadsheet with an additional column to add the discount amount you will apply to the coupons. It can be the same amount or a different one for each customer.

woocommerce-create-coupons-from-list-emails-user-names

To create the coupons, we will use the WP Sheet Editor Coupons Spreadsheet plugin. This tool allows you to manage every aspect of your coupons from a simple spreadsheet. You can apply changes to hundreds of products in seconds with the Bulk Edit tool.

After installing and activating the plugin, you will see all your coupons displayed in a spreadsheet like this one:

woocommerce-create-coupons-from-list-emails-user-names

Now just follow these simple steps.

1- Open the Import tool

We’re going to import the coupons from a CSV file that, as we told you at the beginning of the article, contains two columns: emails and amounts. For this, click on the Import tool, which is located on the top toolbar.

woocommerce-create-coupons-from-list-emails-user-names

2- Upload the CSV file from your computer

Now you need to select the following values:

  • Source: CSV file from my computer
  • CSV file: Select the file from your computer
  • Click on Next

woocommerce-create-coupons-from-list-emails-user-names

Now you need to select the columns to import. Basically, you’ll match how the columns will be imported. If your CSV column containing the emails is entitled Emails, then you need to select the Title column in WordPress field.

Therefore, select on which WP fields your CSV columns will be imported.

woocommerce-create-coupons-from-list-emails-user-names

Now you need to select these values:

  • Do you want to update or create items: Only create new items, ignore existing items.
  • Click on Next.

woocommerce-create-coupons-from-list-emails-user-names

3- Import the new coupons

Finally, click on The preview is fine, start import, and your import process will start. In some seconds, your new coupons will appear in the spreadsheet. Now let your customers know that they have received a gift and that the coupon code is their email address.

woocommerce-create-coupons-from-list-emails-user-names

Done!

It’s really simple to create coupons from an email list. You can apply this and hundreds of other changes to your coupons with the WP Sheet Editor Coupons Spreadsheet plugin.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.