Bulk Import Coupons in WooCommerce

Last updated on June 5, 2023

Smart Coupons for WooCommerce is an ideal solution for importing coupons to your WooCommerce store. You can import any number of coupons using a single CSV file.

This article will explain how to import coupons in bulk using a structured CSV file.

Getting started

First of all, install and activate the plugin.
From your WordPress dashboard, go to the Smart Coupons > Import Coupons.

Smart Coupons for WooCommerce - Coupons bulk import page — Smart Coupons for WooCommerce – Coupons bulk import page

Accepting coupon data

The CSV file must contain some specific coupon data in order for it to properly get imported. To know more about the coupon data, click here.

Download a Sample Coupon CSV.

Importing process

From the Import coupon tab, click on the Upload button and choose 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.

Smart Coupons for WooCommerce - Coupons bulk import — Smart Coupons for WooCommerce – Coupons bulk import

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:

Smart Coupons for WooCommerce - All coupons page — Smart Coupons for WooCommerce – All coupons page

Was this article helpful?
Yes, thanks!Not really

This article posted in Documentation, Import Coupons, Smart Coupons for WooCommerce

Written by

Shesna

Shesna is a technical content writer for WebToffee. She is familiar in working closely with the SMEs to break down complex technical information into a concise, easy to understand manner.

Comments (6)

Guillaume Plouin

June 9, 2022

How is it possible to set-up free shipping included for a coupon in the csv ?

Reply
- 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.
  
  Reply
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 ??????????????

Reply
- Massimo De Alessandri
  
  May 4, 2022
  
  I had the same issue. What happened?
  
  Reply
  - 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.
    
    Reply
- Sylvain Vanderhaegen
  
  August 22, 2022
  
  I have the same issue. Date fields for start and expiry are all reset to 1/1/1970
  
  Reply

Cookie	Description
__cfruid	Cloudflare sets this cookie to identify trusted web traffic.
__stripe_mid	Stripe sets this cookie cookie to process payments.
__stripe_sid	Stripe sets this cookie cookie to process payments.
cookielawinfo-checkbox-advertisement	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analytics	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Analytics" category .
cookielawinfo-checkbox-necessary	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Necessary" category .
cookielawinfo-checkbox-preferences	This cookie is set by the GDPR Cookie Consent plugin to check if the user has given consent to use cookies under the "Preferences" category.
CookieLawInfoConsent	Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
PHPSESSID	This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policy	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.

Cookie	Description
_ga	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_ga_BQH8MSKD4M	This cookie is installed by Google Analytics.
_gat_gtag	Identification code of website for tracking visits.
_gid	This cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjAbsoluteSessionInProgress	Hotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.
_hjFirstSeen	Hotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.
_hjid	Hotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInPageviewSample	Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.
_hjIncludedInSample	This cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
_hjIncludedInSessionSample	Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.
_hjTLDTest	To determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.
CONSENT	YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
has_recent_activity	This cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_ai	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lr	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_or	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qs	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
VISITOR_INFO1_LIVE	A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSC	YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devices	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-id	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.

Cookie	Duration	Description
_hjSession_1376571	30 minutes	No description
_hjSessionUser_1376571	1 year	No description
_octo	1 year	No description available.
_zendesk_authenticated	past	No description
_zendesk_session	session	No description available.
_zendesk_shared_session	session	No description available.
edd_wp_session	12 hours	No description available.
logged_in	1 year	No description available.
m	2 years	No description available.

Bulk Import Coupons in WooCommerce

Getting started

Accepting coupon data

Importing process

Written by

Comments (6)

Got any query? Please leave a comment or reach out to our support
Cancel reply

Got any query? Please leave a comment or reach out to our support

Our plugins

Bulk Import Coupons in WooCommerce

Getting started

Accepting coupon data

Importing process

Written by

Comments (6)

Got any query? Please leave a comment or reach out to our support Cancel reply

Got any query? Please leave a comment or reach out to our support

Got any query? Please leave a comment or reach out to our support
Cancel reply