Getting Started
Advanced Coupon Options
Store Credit
Bulk Generate
Import Coupons
Volume/Quantity based coupon
Nth Order Discount
SignUp Coupon
Abandoned Cart Discount
Sales Countdown Timer
FAQ
ChangelogSmart 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
