Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Pricing

You may have seen some references on our site to annual licensing or renewals.

All plugins currently come with a lifetime license, no matter what the site says.

We’re currently running tests before we make the switch to annual pricing. Check the Discounts tab to purchase our other plugins and get a lifetime license before they’re gone.

I Understand I Have a Lifetime License
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How to Export WooCommerce Coupons

To export WooCommerce coupons, go to All Export › New Export and select WooCommerce Coupons. Use our Drag & Drop tool to choose your coupon fields, then run your export and download your exported coupons.

Table of Contents

Advanced Topics

Step 1: Create a New WooCommerce Coupon Export

Navigate to All Export › New Export and select WooCommerce Coupons as the export post type.

Export WooCommerce Coupons Create New Export

WP All Export will display the number of coupons to export. You can also Add Filtering Options in this part.

Click Customize Export File to continue.

Step 2: Drag and Drop the Export Columns

You now see the Drag & Drop interface, where you can build your export file. To add columns to your export, drag them from the Available Data section on the right to the column selection area on the left:

Export WooCommerce Coupons Drag and Drop Section

Basic coupon data is in Available Data › Standard:

  • Coupon ID: The coupon ID, assigned by WordPress.
  • Coupon Code: The coupon code itself, used by users to receive the discount.
  • Coupon Description: A description of the coupon, written by the creator of the coupon.
  • Discount Type: One of several preset values. Percentage discounts are exported as percent, fixed cart discounts as fixed_cart, and discounts on specific products as fixed_product.
  • Coupon Amount: The amount to be discounted. Based on the discount type, this is either a percentage or a fixed amount.
  • Expiry Date: Date when the coupon expires and is no longer available, in y-m-d format.
  • Free Shipping: Whether this coupon grants free shipping or not, exports either yes or no.
  • Exclude Sale Items: Whether this coupon works on sale items or not, exports either yes or no.

Other WooCommerce Coupon Data

Less used coupon data is in Available Data › Other. For example, data on who created the coupon, along with the following fields:

  • usage_limit: The total number of times the coupon can be used.
  • usage_limit_per_user: The number of times each customer can use the coupon.
  • limit_usage_to_x_items: The maximum number of items allowed in the cart when using the coupon.
  • usage_count: The number of times the coupon has been used.
  • minimum_amount: Minimum cart amount required to apply the coupon.
  • maximum_amount: Maximum cart amount allowed to apply the coupon.
Export WooCommerce Coupons Other Section and Continue

Once you've selected all your export columns, click Continue.

Step 3: Configure the Export Settings and Run The Export

The Export Settings screen appears, where you can configure your export options. There are two panels available, Scheduling Options and Advanced Options, but you can leave them with their default settings for now.

Export WooCommerce Coupons Settings

Click Confirm & Run Export or Save & Run Export to run the export.

Step 4: Download the Exported Coupons

Once the export finishes, you'll see the Export Complete screen. Here, you can Click to Download the exported WooCommerce coupons, as well as access other options within WP All Export.

Export WooCommerce Coupons Export Complete

To import your exported coupons into another site using WP All Import, download the Bundle file.

Export WooCommerce Coupons — Advanced Topics

Send Exported Coupons Via Email

You can send your newly exported WooCommerce coupons via email using our Zapier integration, either with their native Email integration or using other third-party services such as Gmail. Learn more in Send Exported WordPress Data via Email using Zapier.

You can also send the exported WooCommerce coupons via email using custom code (see documentation) that uses our API (see documentation). Here's a working example snippet: Send Export File via Email.

Filter the Coupons to Export

Our plugin allows you to filter your WooCommerce coupon exports. For example, there are three different types of coupons available: Percentage discount (percent), Fixed cart discount (fixed_cart), and Fixed product discount (fixed_product). If you want to export only WooCommerce coupons with a coupon type of "percent", create this filter:

Export WooCommerce Coupons Filter What to Export

Schedule WooCommerce Coupons Export

When you export WooCommerce coupons, you can automate that export to run automatically using either of our available options:

  1. Automatic Scheduling Service. This is an optional and paid service that allows you to set up exports directly within our plugin. It provides an interface to let you easily define when to run your scheduled export and costs USD 9 per month. Learn more and subscribe here: Run WordPress Export on a Schedule.
  2. Manual Scheduling. This option is included without any extra costs and lets you schedule your export to run automatically using cron jobs. These cron jobs can be defined in your server, i.e., with cPanel or Plesk. Learn more here: Schedule WordPress Exports Using Cron Jobs.

Export WooCommerce Coupons — Frequently Asked Questions

How Do I Bulk Edit WooCommerce Coupons?

  1. Export your WooCommerce coupons.
  2. Edit the export file in your favorite spreadsheet.
  3. Go to All Export › Manage Exports and search for your coupons export.
  4. Use the Import with WP All Import option to upload your modified file.
  5. Complete the import process.

You can learn more about the bulk edit process here: How to Bulk Edit WooCommerce and WordPress Data.

How Do I Migrate Coupons Across Sites?

  1. In the source site, go to All Export › New Export.
  2. Select WooCommerce Coupons and choose to Migrate Coupons.
  3. Run the export and download the exported Bundle file.
  4. In the destination site, go to All Import › New Import.
  5. Upload the import file and complete the import.

You can learn more about the whole migration process here: How to Migrate WooCommerce and WordPress Data.

How Do I Bulk Upload Coupon Codes in WooCommerce?

  1. Create an import file with all WooCommerce coupons to upload.
  2. Navigate to All Import › New Import and upload that file.
  3. Choose WooCommerce Coupons as your import type.
  4. Map the incoming data elements to the appropriate coupon data fields.
  5. Run the import and check the imported data.

For more information, see How to Import WooCommerce Coupons.

What Order Should I Use When Importing or Migrating WooCommerce Data?

When you import or migrate WooCommerce data, keep the following order while importing to ensure that all data is imported correctly:

  1. WooCommerce Products
  2. WooCommerce Customers
  3. WooCommerce Coupons
  4. WooCommerce Orders
  5. WooCommerce Reviews

If you're not importing any specific WooCommerce data from that list, you can simply ignore it and move on to the next one.

Where Are WooCommerce Coupons Stored?

WooCommerce Coupons are stored in your WordPress site's database, specifically in the wp_post table, and their specific details in the wp_postmeta table. Our plugin is able to read your database and obtain the data from this table to allow you to export WooCommerce coupons easily.

What Add-Ons Do I Need to Export WooCommerce Coupons?

To export WooCommerce coupons, you need to have the WooCommerce Export Add-On active on your site, along with WP All Export.

Export WooCommerce Coupons — Related Docs

Export WooCommerce Products into a CSV or XML file.

Export your WooCommerce Reviews.

Schedule and automate your export using cron jobs.

Export WooCommerce Coupons — Related Videos

The best import export plugin for WordPress & WooCommerce.

Complete, granular control of your data with an easy to use drag & drop interface.
  • 90 Day Money Back Guarantee
  • Unlimited Installs
  • Lifetime Licence
  • Fast, World-Class Support
Get Started
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$399
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$199
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Import
Pro Package
$199
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export
Pro Package
$199
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross