In this guide, we\u2019ll show you how to import coupons into WooCommerce using two practical methods:<\/p>\n
- \n
- Import WooCommerce coupons from CSV with Smart Coupons;<\/strong><\/li>\n
- Import and map coupon data with WP All Import.<\/strong><\/li>\n<\/ul>\n
We\u2019ll also explain what to do if your coupons are part of a complete store migration to WooCommerce. Let’s get started!<\/p>\n
\nCan You Import Coupons Directly into WooCommerce?<\/h2>\n
WooCommerce includes built-in tools for creating and managing coupons. From your WordPress dashboard, you can go to Marketing > Coupons<\/strong> to create coupon codes manually and configure their discount type, amount, expiry date, usage restrictions, and usage limits.<\/p>\n
This approach works well when you only need a few coupon codes. However, for bulk WooCommerce coupon imports, you\u2019ll need an extension or third-party tool that can process coupon data from a CSV file.<\/p>\n
Before importing, your file should contain the coupon information you want to preserve, such as:<\/p>\n
- \n
- Coupon code;<\/li>\n
- Discount type and amount;<\/li>\n
- Expiry date;<\/li>\n
- Minimum and maximum spend;<\/li>\n
- Product or category restrictions;<\/li>\n
- Usage limits;<\/li>\n
- Customer email restrictions;<\/li>\n
- Free shipping settings, if applicable.<\/li>\n<\/ul>\n
The exact column names and accepted values depend on the importer you use, so it\u2019s best to prepare your CSV based on the template provided by that tool.<\/p>\n
\nHow to Import WooCommerce Coupons from CSV with Smart Coupons?<\/h2>\n
One of the most straightforward ways for WooCommerce import coupons in bulk is Smart Coupons<\/a>, an extension available from WooCommerce.<\/p>\n
Besides extending WooCommerce coupon functionality, Smart Coupons adds a dedicated CSV import feature under Marketing > Coupons<\/strong>. This makes it suitable when your coupon data is already prepared in a spreadsheet or CSV file.<\/p>\n
![\"Smart](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/smart-coupons.webp\")
Smart Coupons plugin<\/figcaption><\/figure>\n Step 1: Install Smart Coupons<\/h3>\n
First, install and activate the Smart Coupons extension on your WooCommerce store. Once activated, it adds additional coupon management features, including bulk coupon importing.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/search-smart-coupons.webp\")
Step 1: Install Smart Coupons plugin<\/figcaption><\/figure>\n After activation, go to Marketing > Coupons<\/strong>. You should now see additional options provided by Smart Coupons, including the Import Coupons<\/strong> tab.<\/p>\n
Step 2: Prepare your coupon CSV file<\/h3>\n
Smart Coupons includes a sample.csv<\/a> file that you can use as a template. Instead of building the CSV structure from scratch, start with this sample and replace the example data with your own coupon information.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/smart-coupons-csv-template.webp\")
Step 2: Format the template CSV file<\/figcaption><\/figure>\n Some of the main fields you may see in the CSV include:<\/p>\n
- \n
- post_title:<\/strong> The coupon code customers enter at checkout, such as SUMMER10.<\/li>\n
- post_excerpt:<\/strong> An optional internal description that helps you identify the coupon or campaign.<\/li>\n
- post_status:<\/strong> The status of the coupon. For example, publish makes the coupon active.<\/li>\n
- menu_order:<\/strong> Controls the order of coupons in the admin area and can normally be left at 0.<\/li>\n
- post_date:<\/strong> The date and time associated with the coupon.<\/li>\n
- discount_type:<\/strong> Defines how the discount works, such as a percentage, fixed-cart, or fixed-product discount.<\/li>\n
- coupon_amount:<\/strong> The discount value. For example, 10 represents 10% when using a percentage discount.<\/li>\n
- free_shipping:<\/strong> Determines whether the coupon enables free shipping.<\/li>\n
- expiry_date:<\/strong> Specifies when the coupon expires.<\/li>\n
- minimum_amount:<\/strong> Sets the minimum cart subtotal required to use the coupon.<\/li>\n
- maximum_amount:<\/strong> Sets the maximum cart subtotal allowed for the coupon.<\/li>\n<\/ul>\n
Important:<\/strong> If your WooCommerce store uses a language other than English, make sure the values in the discount_type<\/strong> column match the translated discount-type values used by your site. Otherwise, the coupon may not be imported with the intended discount logic.<\/p>\n
Before continuing, review your file carefully for missing coupon codes, invalid values, duplicate entries, and incorrect restrictions. It\u2019s also a good idea to back up your WooCommerce store before running a large import.<\/p>\n
Step 3: Upload and import the CSV file<\/h3>\n
Once your CSV file is ready, go to Marketing > Coupons > Import Coupons<\/strong> from your WordPress dashboard. Click Choose a CSV file<\/strong>, select the coupon file from your computer, and then click Upload file<\/strong>.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/choose-CSV-file-for-upload.webp\")
Step 3.1: Choose CSV file for upload<\/figcaption><\/figure>\n Smart Coupons can also send imported coupon codes to customers when email addresses are included through Usage restrictions > Allowed emails<\/strong>. This can be useful when importing customer-specific rewards or promotional codes.<\/p>\n
When everything is ready, click Import<\/strong> and wait for the import process to finish.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/woocommerce-smart-coupons-import-step-2.webp\")
Step 3.2: Begin import coupons to WooCommerce<\/figcaption><\/figure>\n After the import completes, return to Marketing > Coupons<\/strong> and check several imported coupons manually. Confirm that the coupon code, amount, discount type, expiry date, restrictions, and usage limits match your source file.<\/p>\n
Step 4: Import WooCommerce coupons with categories (optional)<\/h3>\n
Smart Coupons also lets you organize imported coupons into categories. This can be useful when you manage separate groups of codes for holiday sales, affiliate campaigns, loyalty rewards, partnerships, or other promotions.<\/p>\n
Here\u2019s how to include coupon categories in your import:<\/p>\n
1. Go to Marketing > Coupons > Import Coupons<\/strong> and download the sample CSV file for reference.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/woocommerce-smart-coupons-csv-import-file.webp\")
Step 4.1: Download the sample CSV file<\/figcaption><\/figure>\n 2. Make sure your CSV file includes a column named sc_coupon_category<\/strong>.<\/p>\n
![\"Add](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/woocommerce-smart-coupons-category-column-name.webp\")
Step 4.2: Add a column to the file<\/figcaption><\/figure>\n 3. Go to Marketing > Coupons<\/strong> and click Manage Coupon Categories<\/strong>. From there, create or manage the coupon categories you want to use.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/woocommerce-smart-coupons-access-coupon-categories.webp\")
Step 4.3: Manage coupon categories<\/figcaption><\/figure>\n 4. After creating the categories, note their category IDs<\/strong>.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/woocommerce-smart-coupons-category-ids.webp\")
Step 4.4: Note down their category IDs<\/figcaption><\/figure>\n 5. Add the corresponding category ID to the sc_coupon_category<\/strong> column for each coupon in your CSV file.<\/p>\n
- \n
- To assign more than one category, separate the IDs with a pipe symbol (|).<\/li>\n
- Example:<\/strong> 38|37|36<\/li>\n<\/ul>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2025\/09\/woocommerce-smart-coupons-categories-ids.webp\")
Step 4.5: Add the corresponding ID<\/figcaption><\/figure>\n Save the updated CSV file and upload it again through Marketing > Coupons > Import Coupons<\/strong>. Smart Coupons will import the coupon data together with the assigned category information.<\/p>\n
\nHow to Import WooCommerce Coupons with WP All Import?<\/h2>\n
Another option is WP All Import<\/a>. This method is useful when your CSV structure doesn\u2019t match a fixed template and you want more control over how individual source fields are mapped to WooCommerce coupon data. To import WooCommerce coupons this way, you need WP All Import<\/strong> together with its WooCommerce Import Add-On<\/strong>.<\/p>\n
Step 1: Create a new coupon import<\/h3>\n
Go to All Import > New Import<\/strong> in WordPress and upload your coupon file. Then select WooCommerce Coupons<\/strong> as the data type you want to import.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/woocommerce-import-wp-all-import.webp\")
Step 1: Create a new coupon import<\/figcaption><\/figure>\n Review the records detected in your source file before continuing. If the data is incomplete or incorrectly formatted, it\u2019s better to fix the source file first.<\/p>\n
Step 2: Map your coupon data<\/h3>\n
WP All Import provides a drag-and-drop interface that lets you map fields from your source file to the corresponding WooCommerce coupon fields.<\/p>\n
Typically, the coupon code is mapped as the title, while other coupon settings can be mapped to fields such as:<\/p>\n
- \n
- discount_type<\/strong> for the coupon discount type;<\/li>\n
- coupon_amount<\/strong> for the discount value;<\/li>\n
- expiry_date<\/strong> for the expiration date;<\/li>\n
- free_shipping<\/strong> for free shipping eligibility;<\/li>\n
- individual_use<\/strong> for coupons that cannot be combined with others;<\/li>\n
- usage_limit<\/strong> and usage_limit_per_user<\/strong> for redemption limits;<\/li>\n
- product_ids<\/strong> and exclude_product_ids<\/strong> for product restrictions;<\/li>\n
- minimum_amount<\/strong> and maximum_amount<\/strong> for cart value restrictions;<\/li>\n
- customer_email<\/strong> for customer email restrictions.<\/li>\n<\/ul>\n
This mapping process makes WP All Import particularly useful when you already have coupon data exported from another system but the column names don\u2019t match WooCommerce directly.<\/p>\n
Step 3: Configure and run the import<\/h3>\n
After mapping the required fields, configure the import settings and define a unique identifier so WP All Import can track each coupon record.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/configure-wp-all-import-settings.webp\")
Step 3.1: Configure the import settings<\/figcaption><\/figure>\n Then review the import summary and click Confirm & Run Import<\/strong>. Once the process finishes, go to Marketing > Coupons<\/strong> and verify that the imported codes and their settings are correct.<\/p>\n
![\"Step](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2026\/07\/run-wp-all-import-coupons.webp\")
Step 3.2: Run the import WooCommerce coupons<\/figcaption><\/figure>\n
\nSmart Coupons vs WP All Import: Which Method Should You Use?<\/h2>\n
Both methods can handle bulk WooCommerce import coupons, but they suit slightly different situations.<\/p>\n
- \n
- Use Smart Coupons<\/strong> if you\u2019re already managing promotions inside WooCommerce and want a straightforward CSV-based workflow. Its sample file gives you a predefined structure, and the import process happens directly from the Coupons area.<\/li>\n
- Use WP All Import<\/strong> if your coupon data comes from a custom spreadsheet, feed, or another system and you need to map source columns to WooCommerce fields manually. Its flexible field mapping can reduce the amount of spreadsheet restructuring required before import.<\/li>\n<\/ul>\n
Whichever method you choose, test the process with a small group of coupons first before importing your full dataset.<\/p>\n
\nHow to Migrate Coupons from Another Store to WooCommerce?<\/h2>\n
The methods above work best when you already have a coupon file and only need to import it into WooCommerce. If your coupons are still stored on another eCommerce platform and form part of a complete store migration, transferring them separately can mean additional exporting, restructuring, and field mapping.<\/p>\n
With LitExtension, you can migrate supported coupons alongside products, customers, orders, and other store data in three steps:<\/p>\n
- \n
- Connect your stores: <\/strong>Set your current platform as the Source Cart and WooCommerce as the Target Cart, then provide the required connection details.<\/li>\n
- Configure the migration:<\/strong> Select Coupons and any other entities you want to transfer. Then, configure the Additional Options<\/strong> and available mapping settings.<\/li>\n
- Run the Full Migration:<\/strong> Start the migration and let LitExtension transfer the selected data to your WooCommerce store. You can run a Free Demo Migration beforehand to preview the results.<\/li>\n<\/ul>\n
This approach keeps your coupons within the complete store migration, so you do not have to export, restructure, and import each data type separately.<\/p>\n
\n\nSeamlessly migrate your store to WooCommerce!<\/h2>\n
LitExtension can safely transfer your data to unlock more growth on WooCommerce.<\/p>\n
FREE DEMO NOW<\/a><\/p>\n<\/div>\n
![\"How](\"https:\/\/litextension.com\/blog\/wp-content\/uploads\/2024\/09\/2-08-1.png\")
<\/div>\n<\/div>\n
\nWhat to Check After Importing WooCommerce Coupons?<\/h2>\n
A successful WooCommerce import coupons doesn\u2019t necessarily mean every coupon is configured exactly as intended. Before using the imported coupons in a live campaign, review a sample of them in Marketing > Coupons<\/strong>.<\/p>\n
Pay particular attention to:<\/p>\n
- \n
- Coupon code:<\/strong> Check that the code was imported correctly and contains no unwanted spaces or characters.<\/li>\n
- Discount type and value:<\/strong> Confirm that percentage and fixed discounts use the intended settings.<\/li>\n
- Expiry date:<\/strong> Make sure active coupons haven\u2019t been assigned an incorrect expiration date.<\/li>\n
- Usage restrictions:<\/strong> Review minimum and maximum spend, product restrictions, category restrictions, and email restrictions.<\/li>\n
- Usage limits:<\/strong> Check the total usage limit and per-user limit where applicable.<\/li>\n
- Free shipping:<\/strong> Verify whether coupons intended to provide free shipping have the setting enabled.<\/li>\n<\/ul>\n
Finally, test several coupon codes on your storefront or a staging site. This helps confirm that WooCommerce applies each discount under the expected conditions before you distribute the codes to customers.<\/p>\n
\nWooCommerce Import Coupons: FAQs<\/h2>\n
\n\nHow do I bulk-add coupon codes to WooCommerce?<\/summary>\n
\nWooCommerce does not include a built-in bulk coupon importer, so you will need a compatible plugin. Prepare your coupon codes and settings in a CSV file, install an import plugin such as Smart Coupons or WP All Import, upload the file, map its columns to the corresponding coupon fields, and run the import. Test a small batch before importing the full list.<\/p>\n<\/div>\n<\/details>\n
\nCan I update existing WooCommerce coupons through CSV?<\/summary>\n
\nYes, provided your import plugin supports record updates. You will normally need to match each row to an existing coupon using its coupon code, ID, or another unique identifier. Before running the import, choose the option to update existing coupons instead of creating new ones, or you may end up with duplicate records.<\/p>\n<\/div>\n<\/details>\n
\nCan I import used coupon counts and usage limits?<\/summary>\n
\nYes, some WooCommerce import coupons plugins support fields such as
usage_count, usage_limit, usage_limit_per_user, and limit_usage_to_x_items<\/code>. However, field names and supported values vary between tools. Check your plugin\u2019s CSV template and confirm whether it can preserve historical usage data, not just future usage limits.<\/p>\n<\/div>\n<\/details>\n\nWhy are my imported coupons not working?<\/summary>\n
\nImported coupons may fail if the CSV contains an unsupported discount type, incorrect expiry date, inactive status, invalid product IDs, or improperly formatted restrictions. The coupon may also have reached its usage limit or fail the minimum-spend, customer-email, or product eligibility rules. Open the coupon under Marketing > Coupons<\/strong>, check each setting, and test it in the cart with an eligible product and customer account.<\/p>\n<\/div>\n<\/details>\n
\nWhat plugins can import WooCommerce coupons?<\/summary>\n
\nCommon options include:<\/p>\n
- \n
- WooCommerce Smart Coupons<\/strong> for structured CSV imports and bulk campaign management.<\/li>\n
- Import Export Suite for WooCommerce<\/strong> for importing, exporting, mapping, and updating coupon records.<\/li>\n
- Customer\/Order\/Coupon CSV Import Suite<\/strong> for importing coupons alongside customer and order data.<\/li>\n
- WP All Import<\/strong> with the WooCommerce Import Add-On for custom CSV or XML files that require flexible field mapping.<\/li>\n<\/ul>\n
The right option depends on your file structure, required coupon fields, update needs, and whether coupons are being imported separately or as part of a complete store transfer.<\/p>\n<\/div>\n<\/details>\n<\/div>\n
\nConclusion<\/h2>\n
WooCommerce gives you built-in tools for creating coupons individually, while bulk coupon imports are better handled with a dedicated import extension. If your coupon data is already in CSV format, Smart Coupons provides a straightforward import workflow, while WP All Import offers more flexibility when your source fields need custom mapping.<\/p>\n
If WooCommerce import coupons are only one part of a complete store migration, transferring them together with the rest of your eCommerce data using our WooCommerce migration tool<\/strong><\/a> can be more efficient. The right method ultimately depends on where your coupon data currently lives and how much control you need over the import process.<\/p>\n
- Import Export Suite for WooCommerce<\/strong> for importing, exporting, mapping, and updating coupon records.<\/li>\n
- Discount type and value:<\/strong> Confirm that percentage and fixed discounts use the intended settings.<\/li>\n
- Configure the migration:<\/strong> Select Coupons and any other entities you want to transfer. Then, configure the Additional Options<\/strong> and available mapping settings.<\/li>\n
- Use WP All Import<\/strong> if your coupon data comes from a custom spreadsheet, feed, or another system and you need to map source columns to WooCommerce fields manually. Its flexible field mapping can reduce the amount of spreadsheet restructuring required before import.<\/li>\n<\/ul>\n
- coupon_amount<\/strong> for the discount value;<\/li>\n
- discount_type<\/strong> for the coupon discount type;<\/li>\n
- post_excerpt:<\/strong> An optional internal description that helps you identify the coupon or campaign.<\/li>\n
- post_title:<\/strong> The coupon code customers enter at checkout, such as SUMMER10.<\/li>\n
- Import and map coupon data with WP All Import.<\/strong><\/li>\n<\/ul>\n