By using the Smart Coupons for WooCommerce plugin, you can import coupon data, including discount types, amounts, and usage limits, in three simple steps: upload your CSV, map the headers to coupon fields, and execute the import. This method is the most efficient way to manage large-scale promotional campaigns or migrate coupons from another platform. This article explains how to import coupons in bulk using a structured CSV file.
Getting started
- First, install and activate the plugin.
- From your WordPress dashboard, go to the Smart Coupons > Import Coupons.
Accepting coupon data
The CSV file must contain specific coupon data for the import to succeed. To learn more about the coupon data, refer to Bulk Import Coupons in WooCommerce – Coupon Data.
>> Download sample CSVImporting process
In the Import coupon tab, click Upload, then select a CSV file from your system.
Next, to email coupons to users specified within the CSV, tick the checkbox. The coupons will be emailed to users on import.
For a clean import, the CSV must include the header and adhere to the format as indicated in our sample file. Columns post_title and discount_type are mandatory for the import. Duplicate coupons will be skipped during import.
Then, click on Next: Map columns for import button to proceed to the mapping window.
Finally, click on the Import Coupons button. Now, the list of imported coupons will be displayed as follows.
Now, head on to the Smart Coupons > All Coupons tab. The store will display the imported coupons as shown below:
Guillaume Plouin
June 9, 2022
How is it possible to set-up free shipping included for a coupon in the csv ?
Shesna
June 10, 2022
Hi Guillaume,
Thanks for reaching out. You may create a new column header named free_shipping in your CSV. By entering ‘yes’ to respective coupons, you can enable free shipping for those coupons only. Kindly leave the cells blank if you do not want to allow free shipping.
Mel
January 10, 2022
Have just exported 50 voucher codes with an expiry date as 30 August 2022 and then imported them and the have all changed to 1970-01-01 ??????????????
Massimo De Alessandri
May 4, 2022
I had the same issue. What happened?
Shesna
May 6, 2022
Hi,
Sorry to know that you are experiencing this way. Please feel free to get in touch with our support team for direct assistance.
Sylvain Vanderhaegen
August 22, 2022
I have the same issue. Date fields for start and expiry are all reset to 1/1/1970
K
November 16, 2023
This is still happening. Dates are being reverted to 1970-01-01
Arjun
December 12, 2023
Hi K,
Thank you for reaching out to us. Sorry to know that you are experiencing this issue. Please feel free to get in touch with our support team for direct assistance.