Getting Started
Advanced Coupon Options
Store Credit
Bulk Generate
Import Coupons
BOGO discounts
Nth Order Discount
Abandoned Cart Discount
Sales Countdown Timer
FAQ
Changelog
Signup CouponsSmart Coupon 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.
Let us see how coupons are imported in bulk using a structured CSV file.
Get started
- First of all, install and activate the plugin.
- From your WordPress dashboard, go to the Smart Coupons > Import Coupons.
Accepting coupon data
The coupon column headers of the CSV and their expected values are explained below.
Download a Sample Coupon CSV.
| Column header | Required | Default | Values |
|---|---|---|---|
| post_title | Yes | n/a | Unique coupon code used to identify a coupon. Checks for match to merge with an existing coupon |
| post_excerpt | No | n/a | Optional coupon description |
| post_status | No | — | Refers to coupon status; can be publish, private or draft |
| post_date | No | — | Coupon created date |
| _wt_sc_shipping_methods | No | — | Refers to shipping method; can be flat_rate, free_shipping |
| _wt_sc_payment_methods | No | — | Refers to payment method; can be cod |
| _wt_category_condition | No | ‘or’ | Refers to category condition, if any. It can be ‘or’, ‘and’ |
| _wt_product_condition | No | ‘or’ | Refers to product condition, if any. It can be ‘or’, ‘and’ |
| _wt_free_product_ids | No | — | Comma-separated list of product IDs of giveaway product assigned to the coupon |
| _wt_min_matching_product_qty | No | — | Number of minimum matching products to use the coupon |
| _wt_max_matching_product_qty | No | — | Number of maximum matching products to use the coupon |
| _wt_min_matching_product_subtotal | No | — | Minimum subtotal amount to use the coupon |
| _wt_max_matching_product_subtotal | No | — | Maximum subtotal amount to use the coupon |
| discount_type | Yes | — | Represents coupon type; can be fixed_cart (cart $), percent (cart %), store credit |
| coupon_amount | No | — | Refers to the amount / value of the coupon |
| individual_use | No | 0 | ‘Yes’ if the coupon cannot be used with others |
| product_ids | No | — | Comma-separated list of product IDs that need to be in the cart to use this coupon. |
| exclude_product_ids | No | — | Comma-separated list of product IDs that shouldn’t be in the cart to use this coupon. |
| minimum_amount | No | — | The minimum subtotal needed to use the coupon |
| maximum_amount | No | — | The maximum subtotal allowed to use the coupon |
| customer_email | No | — | Comma-separated list of email addresses to restrict this coupon to specific billing and user emails. |
| usage_limit | No | — | Number of times the coupon can be used |
| limit_usage_to_x_items | No | — | Maximum number of individual items the coupon can apply to when using product discounts |
| usage_limit_per_user | No | — | Number of times this coupon can be used by an individual user. |
| expiry_date | No | — | Date the coupon expires |
| _wt_coupon_start_date | No | — | Date the coupon can be used |
| _wt_make_auto_coupon | No | ‘No’ | ‘Yes’ to auto-apply coupon |
| _wc_make_coupon_available | No | — | To show coupon; can be my_account, checkout, cart |
| wt_apply_discount_before_tax_calculation | No | ‘No’ | ‘Yes’ to apply discount before tax calculation |
| _wt_need_check_location_in | No | — | Restrict coupon based on location; can be shipping, billing |
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.
Then, click on Map columns for import button to proceed to mapping window.
Finally, click on the Import coupons button. The list of coupons imported successfully will be shown as below:
Now, head on to the coupons tab. The imported coupons added in your store can be viewed as shown below:
Related articles:
- Was this article helpful?
- Yes, thanks!Not really
Comments (5)
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.