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

How to Customize Your WordPress Export with WP_Query

WP_Query is a WordPress class that allows you to fetch posts directly from the database. It's powerful enough for developers to perform extremely complex queries, but simple enough for a regular WordPress user to learn.

You can learn more about WP_Query and all of its parameters here: https://developer.wordpress.org/reference/classes/wp_query/

Rather than writing these WP_Query expressions by hand, you can use https://generatewp.com/wp_query/ to create them for you.

Using WP_Query in WP All Export

Go to All Export › New Export and select the WP_Query Results option. Then select the query type from the drop-down. All of the custom post types available for export are added here automatically. In our default install, there are three options:

  • Post Type Query
  • User Query
  • Comment Query

These options use WP_Query, WP_User_Query and WP_Comment_Query.

In this example we're going to choose Post Type Query.

Post Type Query

Building the Query

The most basic query would include a post type and a post status. For example, to get all published posts in the default WordPress "Posts" post type, the query would be:

"post_type" => "post",
"post_status" => "publish"
Simple Posts Query

Alternatively you could export all Media Library items like images and attachments with this query:

"post_type" => "attachment", "post_status" => "inherit"

If you need to define multiple post types and multiple post statuses, you can use arrays. For example, you can get all pages and posts that are either pending, published, or drafts with the following query:

"post_type" => array( "post", "page" ),
"post_status" => array( "publish", "draft", "pending" )
Query multiple post types and statuses

Advanced WP_Query Example

The WP_Query class has the ability to do custom field queries, taxonomy queries, author checks, and much more. There's no way that we can cover all of the possibilities in this article, but here we'll cover some more advanced queries just to showcase the power of this feature.

Specific criteria for WooCommerce Products
For this example, we'll export a set of variable WooCommerce products with the following rules:

  • Product must be published.
  • Stock value is higher than 0.
  • Products are sorted by title in ascending order.

The query:

"post_type" => array( "product", "product_variation" ),
"post_status" => "publish",
"orderby" => "post_title",
"order" => "ASC",
"meta_query" => array( array(
     "key" => "_stock",
     "value" => 0,
     "compare" => ">"
) )

Custom Post Type Search
For this example, we'll search all posts in the post type properties added by a real estate theme. The criteria:

  • Post type is properties
  • Status is publish
  • Author ID is 3, which is a real estate agent
  • The property has the For Sale category assigned to it
  • Custom field _featured is set to 1, making it a featured property in the theme

The query:

"post_type" => "properties",
"post_status" => "publish",
"author" => 3,
"tax_query" => array( array(
     "taxonomy" =>      "property_category",
     "field" => "slug",
     "terms" => "for-sale",
) ),
"meta_query" => array( array(
     "key" => "featured",
     "value" => "1",
     "compare" => "=",
) )

Related Docs

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

Use filters to tell WP All Export which data should be exported specifically.

Client Mode allows you to give access to other user roles to run/download specific exports.

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