How to Filter WooCommerce Product Export Data Using Advanced Filters

The Product Import Export Plugin for WooCommerce allows you to export products, product categories, tags, and reviews using advanced filter options. Each export type includes its own set of filters, allowing you to export only the required data rather than the entire dataset. This article explains how to filter each product-related export type to export only the data you need.

Navigate to WebToffee Import Export (Pro) → Export.

1. Select the required post type (Product, Product Categories, Product Tags, or Product Reviews).
2. Choose Advanced export as the export method.
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 to Export WooCommerce Products to learn more about the overall export process.

You can filter product exports using the following elements:

• Product – Select specific products to export
• Product type – Filter by types such as Simple, Variable, etc.
• Category – Export products from selected categories
• Product tags – Filter products by assigned tags
• Stock status – Include products based on stock availability
• Product status – Filter by publish status (Published, Draft, etc.)

You can also add additional filters by clicking Add new filter and selecting the required element.

Example: To export only “Black Hoodie” and “Blue Jeans,” select those products from the list.
Only products matching the selected criteria will be exported.

You can filter product categories using:

• Category name – Select specific categories
• Type – Filter based on category type

Example: To export only the “Clothing & Accessories” category, select it from the list.
Only matching categories will be exported.

You can filter product tags using:

• Tag name – Select specific tags to export

Example: To export products tagged as “Summer Collection,” select that tag.
Only selected tags will be included in the export.

You can filter product reviews using:

• Products – Export reviews for specific products
• Stars – Filter by rating (e.g., 4-star, 5-star)
• Status – Filter by review status
• Customer/Guest Review – Choose review type
• Include Replies – Include or exclude replies

Example: To export only 5-star reviews for specific products, select the required product and set the rating to 5 stars.
Only reviews matching the selected filters will be exported.

You can combine multiple filters within each export type to refine the results further.

For example:

• Export only published products that are in stock
• Export only 5-star reviews for specific products

Only data matching all applied filters will be included in the export.

The filter options for each product-related export type allow you to export precisely what you need:

• Products – Filter by product, type, category, tags, stock status, and publish status.
• Product Tags – Filter by tag name.
• Product Categories – Filter by category name and type.
• Product Reviews – Filter by product, star rating, status, customer/guest type, and include/exclude replies.