Risk Free, Backed By Our 90-Day Money Back Guarantee
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Risk Free, Backed By Our 90-Day Money Back Guarantee
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
Docs Menu

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

Filter Exported WordPress Data

You configure filters in the Add Filtering Options section, which is available when creating and editing exports. Each filter consists of an element, a rule, and a value.

For example, if you want to export all WooCommerce products that cost less than $10, select Price as the element, less than for the rule, and 10 as the value.

With this type of filter, you can selectively export:

  • Every WooCommerce order over $100
  • Users who have registered in the last week
  • All of the green shirts in your WooCommerce store
  • Every page created by a certain user
  • All of the posts written in 2014

Step 1: Select an Element to Filter Export Data

Select the element for your filter. Available elements will change when you export different types of data. You can select any data associated with the records you are exporting, such as:

  • Date
  • Title
  • Price
  • Order Total
  • Address
  • Author
  • Categories and tags
  • Custom fields
  • Any exportable data

Step 2: Add a Filter Rule

Select the comparison rule for your filter. You can use any of the following rules, depending on what the selected element allows:

  • equals
  • doesn't equal
  • greater than
  • equal to or greater than
  • less than
  • equal to or less than
  • contains
  • doesn't contain
  • is empty
  • is not empty

Step 3: Enter a Filter Value

Input the value for your filter. You should input values that follow the same format as the element selected in Step 1.

Some rules may not need a value, such as the is empty rule.

Once you're finished, click Add Rule to apply the new filter.

Export WordPress to any CSV, XML, or Excel

  • Import back to WordPress
  • Any theme or plugin
  • Custom fields
  • Zapier integration
  • Woo, ACF, Meta Box, JetEngine

Adding Multiple Rules when Filtering Exported Data

You can add as many filter rules as required. Use the AND or OR operators to specify how rules should interact with each other. After that, only records matching all your specified rules will be exported.

When your export runs again, WP All Export will rebuild your export file based on your filter rules.

Filter Export Data Advanced Topics

Filtering By Date and Relative Dates

When exporting data that contains dates, you can use relative dates.

For example, to export a subset of your WooCommerce orders, first expand the Add Filtering Options panel near the bottom of the New Export screen.

Then, set your filter using the following:

Element = Order Date

Rule = equal to or newer than

Value = 01/01/2018

Single Filter

This is equivalent to saying, “Export WooCommerce orders with an order date equal to or newer than January 01, 2018.” The format to use is MM/DD/YYYY. For example, 12/31/2022 would be December 31st, 2022.

You can also combine multiple filter rules. For example, to export only orders from last month, you can use these rules:

Export only orders from last month

Since these are relative date rules, you won't have to update them monthly. Learn about the syntax for date filters here: https://www.php.net/manual/en/datetime.formats.php#datetime.formats.relative.

Filter Export Data with Multiple Values (Taxonomies and Attributes)

When the element selected to filter is a taxonomy or an attribute, the only two rules available are In and Not In. If you're filtering by Product categories, you would have In Product Cat and Not In Product Cat available:

Filter Exported WordPress Data Multiple Values

With such rules, you can provide multiple values separated by a comma.

For example, you can set up a filter to export only WooCommerce products that are in the categories Classic, Large, and Extra Large:

Filter Exported WordPress Data Multiple Values Example

Filtering WooCommerce Product Export by Product Visibility (also known as Catalog Visibility)

The following instructions only apply when you export WooCommerce products via WP All Export.

While you see Shop and search results or Hidden when assigning the product's catalog visibility, the data stored by WooCommerce is a bit different than what you would expect.

To filter by the desired catalog visibility, a pair of filters must be assigned. Here's a list of the filters you would need to set up for each case:

  • Product Visibility › Not In Product Visibility › exclude-from-search
  • Product Visibility › Not In Product Visibility › exclude-from-catalog

Shop only:

  • Product Visibility › In Product Visibility › exclude-from-search
  • Product Visibility › Not In Product Visibility › exclude-from-catalog

Search results only:

  • Product Visibility › In Product Visibility › exclude-from-catalog
  • Product Visibility › Not In Product Visibility › exclude-from-search

Hidden:

  • Product Visibility › In Product Visibility › exclude-from-search
  • Product Visibility › In Product Visibility › exclude-from-catalog

Related Docs

Create more complex filters using WP_Query.

Integrate WP All Export with countless apps and services using Zapier.

Execute custom code to modify the export data on the fly.

Learn about WP All Export's API and hooks.

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

Unlimited Installs.
World-Class Support. Money Back Guarantee.

Packages
Standalone
Import
Pro Package
$199
.00
/yr
Save $494, 71% Discount
  • 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
$693 If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Import + Export Pro Package
$299
.00
/yr
Save $1087, 78% Discount
  • 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
$1386 If Purchased Individually
Buy Now
90 Day Money Back Guarantee
WooCommerce Import Package
$169
.00
/yr
Save $29, 15% Discount
  • 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
$198 If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Lifetime License
$999
One-Time Payment
  • Import Pro + Export Pro
  • All Current Add-Ons
  • All Future Add-Ons
  • Lifetime Support
  • Lifetime Updates
  • No Renewal Fees
Buy Now
90 Day Money Back Guarantee
Import Standalone
$99
.00
/yr
  • 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
Buy Now
90 Day Money Back Guarantee
Import + Export Standalone
$169
.00
/yr
  • 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
Buy Now
90 Day Money Back Guarantee
Export Standalone
$99
.00
/yr
  • 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
Buy Now
90 Day Money Back Guarantee
Packages
Standalone
Import
Pro Package
$16.58
per month, billed annually
Save $494/yr, 71% Discount
  • 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
$693/yr If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Import + Export Pro Package
$24.92
per month, billed annually
Save $1087/yr, 78% Discount
  • 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
$1386/yr If Purchased Individually
Buy Now
90 Day Money Back Guarantee
WooCommerce Import Package
$14.08
per month, billed annually
Save $29/yr, 15% Discount
  • 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
$198/yr If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Lifetime License
$999
One-Time Payment
  • Import Pro + Export Pro
  • All Current Add-Ons
  • All Future Add-Ons
  • Lifetime Support
  • Lifetime Updates
  • No Renewal Fees
Buy Now
90 Day Money Back Guarantee
Import Standalone
$8.25
per month, billed annually
  • 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
Buy Now
90 Day Money Back Guarantee
Import + Export Standalone
$14.08
per month, billed annually
  • 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
Buy Now
90 Day Money Back Guarantee
Export Standalone
$8.25
per month, billed annually
  • 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
Buy Now
90 Day Money Back Guarantee
cross