Wait!

Lifetime licenses are only available for a short time, don't miss out!

Any File Type

No need to reorganize your data, just upload your file to WP All Import and it'll sort it out.

Complete Customization

Granular control over every single piece of data. Think your import is too complicated? Think again.

Import Huge Datasets

It doesn't matter how big your site is or how much data you need to import, WP All Import can handle it. 

Multilingual Imports

Importing data to multilingual sites has never been easier, with support from the WPML team.

Scheduled Imports

Run imports automatically on a schedule. Subscribe to our point and click scheduling service, or set up cron jobs.

Developer Friendly

Write and test PHP right inside WP All Import when setting up your import, with tons of snippets to get you started.
@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."
90-Day Guarantee
Not 100% happy? Let us know and we’ll promptly send you a refund.
Free Updates For Life
Pay once for unlimited installs, even client sites. No renewal fees.
Fast, World Class Support
Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

Filter Exported WordPress Data

You can configure your filters in the Add Filtering Options section, available when creating and editing exports. If we wanted to export all of our WooCommerce products that cost less than $10, we would select first Price as our element to filter by. Then for our rule we would select less than, with 10 for our value.

With these filters you can easily do things like 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

Select the element that you want to filter your exported records by. Available elements will change when you export different types of data. You can select any data associated with the records you are exporting, like:

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

Step 2: Add a Rule

Select which comparison rule you want to use with 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 Value

Input the value to filter your data by. 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 done, click Add Rule to apply your new filtering rule. You can add as many filtering rules as required. After that, only records matching your specified rules will be exported.

Adding Multiple Rules

You can add as many rules as you like. Use the AND or OR operators to specify how rules should interact with each other.

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 most certainly 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 a filter by selecting an Element, a Rule, and a Value:

Single Filter

In this case, we are setting:

Element = Order Date

Rule = equal to or newer than

Value = 01/01/2018

This is equivalent to saying, “Export WooCommerce orders with an order date equal to or newer than January 01, 2018.”

You can also combine multiple filter rules. Let's say that you want to only export 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 you can use in date filters here: https://www.php.net/manual/en/datetime.formats.relative.php.

Filter 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. Let's say 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 export WooCommerce products and set up the filter to only export products that are in the categories Classic, Large and Extra Large. You can input multiple categories separated by commas, like so:

Filter Exported WordPress Data Multiple Values Example

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.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
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
WooCommerce Import Package
$149
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 Standalone
$99
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 Standalone
$169
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 Standalone
$99
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