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

Filtering Import Data with XPath

You can configure filters in the Manage Filtering Options section, available in Step 2 when creating an import, or in the Edit Template page when editing an existing import. Filters allow you to define which records to import.

WP All Import filters data using XPath. The visual filter designer lets you visually construct an XPath expression. In this article, we'll describe how to use this designer.

Step 1: Select an Import Element

You can choose any of the import file elements in this step. For example, if you only want to import products with valid images, choose Image_URL as the Element.

Manage Filtering Options Image URL

Step 2: Add a Filter Rule

The Rule selection box lets you choose which rule to use for the filter. In this example, we have selected is not empty, which means that we want to import only products where the Image_URL element has data.

Manage Filtering Options Is Not Empty

For most filters, you must also specify a Value. However, when using either the is empty or is not empty, a Value is not required.

Click the Add Rule button to continue. The new filter will appear in the lower section and can be reviewed. If all looks well, click Apply Filters to XPath to apply the new filter. The XPath field will then update.

Manage Filtering Options Apply To XPath

Step 3: Enter a Filter Value

When required, input the Value that you want to filter by. For example, you could filter out any images with names that include the ".jpg" extension:

Manage Filtering Options Value

Otherwise, the Add Rule process is the same.

You can also manually write an XPath expression to filter your file. Learn more at https://www.w3schools.com/xml/xpath_syntax.asp.

Adding Multiple Filter Rules

You can add multiple filter rules and then connect them using the logical operators AND (&&) and OR (||). The AND (&&) operator is used to match records that satisfy both conditions, while the OR (||) operator is used to match records that satisfy either condition.

Here's an example showing how to filter products when image URLs are not empty and the sale price is higher than 50:

Manage Filtering Options Second Example

You can add as many filter rules as you need, giving you full control over your import data.

Filter Import Data — Advanced Topics

Add Indentation to Create Nested Filters

When working with multiple filter rules, you can nest or group rules simply by indenting them:

Manage Filtering Options Indentation, AND OR

This is equivalent to using parentheses and allows you to create logic such as (A AND B) OR (C AND D). In fact, by combining AND, OR, and nesting, you can create any filter logic you desire.

Modify Existing Import Filters

You can modify filters for an existing import by using this procedure:

  1. Navigate to All Import › Manage Imports.
  2. Locate the import in question.
  3. Click Edit Template.
  4. Modify your filter in the Manage Filtering Options section.
  5. Save the import template.

Filter Import Data — Related Docs

Quickstart guide that explains how to use WP All Import.

Execute custom code to modify the import 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