Visser Labs – WooCommerce Plugins

  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. Data Exports
  5. How to export orders by multiple coupons in Store Exporter Deluxe
  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. How to export orders by multiple coupons in Store Exporter Deluxe

How to export orders by multiple coupons in Store Exporter Deluxe

You ran a spring sale with three coupon codes, and now you need every order that used any of them in one spreadsheet. Exporting them one code at a time means three files to stitch together, and it’s easy to miss an order along the way.

The Coupon Code filter in Store Exporter Deluxe handles this in a single export. Type your codes into one box, separated by commas, and the file contains every order that used at least one of them.

This article covers a one-off Quick Export. For the full order export walkthrough, see How to export WooCommerce orders with Store Exporter Deluxe.

Prerequisites

RequirementDetails
PluginStore Exporter Deluxe 5.4.4 or later, installed and active
WooCommerceActive, with orders that used the coupons you want
Coupon codesThe exact codes you want to include, such as save10 and flat5

This guide needs Store Exporter Deluxe 5.4.4 or later. On older versions, a multi-coupon filter can return the wrong orders. See the troubleshooting section below.

Step 1: Open Quick Export and choose Orders

  1. Go to WooCommerce → Store Export.
  2. Click Quick Export in the sidebar.
  3. On the Select Export Type step, click the Orders tile.

Step 2: Add the Coupon Code field

The coupon code isn’t part of the default column set, so add it yourself. Without it, your file lists the matching orders but doesn’t show which coupon each one used.

  1. On the Export Fields step, click Add more fields.
  2. In the Select Export Fields popup, open the Coupons group.
  3. Tick Coupon Code.
  4. Click Save Fields.

The Coupons group also has Coupon Expiry Date and Coupon Description if you want them in the same file.

The Select Export Fields popup filtered to the Coupons group, with the Coupon Code checkbox ticked

Step 3: Filter by your coupon codes

  1. Open the Filters & Sorting step.
  2. Tick the Coupon Code card (“Include orders that used a specific coupon code”).
  3. In the Coupon code box, type your codes separated by commas, for example save10,save20,flat5.

Here’s how the box treats what you type:

  • Any of the codes matches: an order is included if it used at least one of the codes you list. It doesn’t need to have used all of them.
  • Spaces are fine: save10, save20, flat5 works the same as save10,save20,flat5.
  • Capitals don’t matter: WooCommerce stores coupon codes in lowercase, and the filter matches them the same way, so SAVE10 finds orders that used save10.
  • Commas are the only separator: don’t use semicolons or line breaks between codes.
  • Deleted coupons still work: you can filter on a code you’ve since deleted from WooCommerce, because the filter reads the code recorded on each order.

The filter only looks at the coupon code. Combine it with other cards, such as Order Date or Order Status, to narrow the file further.

The Filters and Sorting step with the Coupon Code card ticked and save10,save20,flat5 typed in the Coupon code box

Step 4: Choose a format and run the export

  1. Open the Export Options step.
  2. Pick a format under File Format. CSV suits most jobs.
  3. Check the summary bar. The filter count now reads 1.
  4. Click Run Export.

What the exported file looks like

You get one row per matching order. The Coupon Code column shows the code that order used. With the three-code example above, the relevant columns look like this:

Order IDCoupon Code
167save10
168save20
169flat5

If a single order used more than one coupon, all of its codes sit in the same cell, joined by the category separator. By default that’s a pipe, so you see save10|flat5. You can change the separator in the plugin’s Settings screen.

Common uses

  • Campaign reporting: export every order from a promotion that ran under several codes, then total the results in a spreadsheet.
  • Affiliate or partner codes: pull all orders for a group of related codes in one pass.
  • Staff or wholesale discount audits: check who used which internal discount code.
  • Recurring reports: use the same filter in a scheduled export. Go to Scheduled Exports, create a schedule with Export Type set to Orders, and add the Coupon Code filter on the Filters step. For detailed instructions, see How to schedule exports.

Troubleshooting

The file has orders for only one coupon, or every order
Update Store Exporter Deluxe to 5.4.4 or later from Plugins → Installed Plugins, then run the export again. Older versions can return the wrong orders for this filter. Versions before 5.4.1 export the orders for only one of the codes, and 5.4.3 ignores the filter and exports every order.
The file is empty
None of the orders in your store used the codes you typed, or another filter card is ruling them out. Check each code against the coupons listed on your orders. Then untick any other filter cards, such as Order Date or Order Status, one at a time to see which one removes the rows.
Orders show up but there’s no coupon column
The Coupon Code field isn’t selected by default. Go back to the Export Fields step and add it from the Coupons group, as in Step 2.
Codes separated by semicolons or spaces return nothing
The box only splits codes on commas. A value like save10;save20 or save10 save20 is read as one code that doesn’t exist, so no orders match. Replace the semicolons or spaces with commas.

FAQ

Does it return orders that used all of my coupons, or any of them?
Any of them. An order is included if it used at least one of the codes you list.
Can I filter by coupon code and export the coupons themselves?
They’re separate exports. The Coupon Code filter selects orders. To export the coupons and their settings, choose the Coupons tile on the Select Export Type step instead.

Need more help?

If you’re using Store Exporter Deluxe and hit something this article doesn’t cover, open a support ticket and our team will help you get your coupon export working.

If you’re using the free Store Exporter plugin, ask on the WordPress.org support forum and our team will get back to you there.

Was this article helpful?

Related Articles

Resources & Help