Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
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

Lifetime licenses are only available for a short time!

SPECIAL OFFER 
Save 50% OFF For a Limited Time!
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing lifetime licenses will be unaffected so get in while you can!
  • 90-Day Money-Back Guarantee
  • Fast World Class Support
  • Unlimited Sites
  • Free Lifetime Updates
  • Easy to Use
  • Developer Friendly
Risk free! Cancel at any time with our 90-day guarantee.
"All Import/Export is an awesome suite of tools. It gets me out of some tough challenges."
Eric Karkovack, Freelance Writer
"WP All Import - Versatile, and I have saved so much time with it over the years."
Matt Andrews, Full Stack Web Developer
"@WPAllImport just let me import 3000 products from some arbitrary Excel to WooCommerce w/ a few clicks, including images and categories."
Joris Witteman, Developer / Designer

Wait, Don’t Miss Your Chance for a Lifetime License!

@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.

World Class Support

Over 9 years experience with WordPress imports and exports.

Your Last Chance for a Lifetime License!

We are soon moving to yearly licenses only. Once lifetime licenses are gone, they're gone forever.
@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.

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.php#datetime.formats.relative.

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

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.

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

Lifetime support. Lifetime updates. Pay once.

Import
Pro Package
$199
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
Export
Pro Package
$199
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