Filter WooCommerce Order Export by Coupon, Product, Status, and Date Range

The WooCommerce Order / Coupon / Subscription Export Import Plugin allows you to export orders into a CSV or XML file with various filter options. This article explains how to filter order exports by coupon, ordered products, order status, and date range.

Navigate to WebToffee Import Export (Pro) > Export.

1. Select the post type as Order.
2. Select Advanced export as the export method to avail filter options
3. In Step 3 – Filter Data, configure the required filters.
4. In Step 4 – Map and Reorder Export Columns, map the required fields.
5. Configure Advanced Options, Batch Export, or Scheduling if required, and complete the export.

Refer Export WooCommerce Orders to know more about the export process.

Follow the steps below to export orders associated with specific coupons:

1. Select Order as the post type.
2. Choose the Advanced Export method.
3. In Step 3, expand the Filter Data section.
4. Enter one or more coupon codes under the element Coupon.

5. Proceed to mapping and complete the export.

Only orders that used the specified coupons will be included in the exported file.

You can filter orders based on specific products purchased.

1. Select Order as the post type.
2. Choose the Advanced Export method.
3. In Step 3, expand Filter Data.
4. Under Item ordered, select one or more products from the list.

5. Continue to Step 4 to map and export the file.

Orders containing any of the selected products will be exported.

 For example, if you want to export orders containing the products Black Hoodie and Jeans, select only those products from the product list.

To export orders of specific statuses:

1. Select Order as the post type.
2. Choose Advanced Export.
3. In Step 3, expand Filter Data.
4. Under the element Order Status, select one or more statuses such as Processing, On hold, etc.

5. Proceed to mapping and download the exported file.

Only orders matching the selected status(es) will be exported.

For example, if you want to export orders with statuses: Completed and Processing, then select only those values from the field. This will export only orders with the Processing and Completed statuses.

You can export orders created within a specified date range.

1. Select Order as the post type.
2. Choose Advanced Export.
3. In Step 3, expand Filter Data.
4. Under the Order Date filter, enter the From Date and To Date.

5. Complete the remaining steps to export the orders.

Only orders created within the specified date range will be included in the export.