Taxonomy Meta & Images

Taxonomy Meta & Images

Most often you will want to import categories and tags and other taxonomies as part of an import that is creating posts. There are times, however, when you will want to import just the taxonomies on their own. This is especially helpful when you have meta like images, custom fields, and content that need to be imported into the taxonomies themselves. This is only possible by creating an import for taxonomies.

Just like posts, you can import new taxonomies, or you can add meta and content to existing taxonomies.

To get started, select 『Taxonomies』 in Step 1:

Taxonomies in drop down

Then select the taxonomy to import into from the 2nd drop down box that appears on the page:

Select Taxonomy

Then in Step 3 of the import process you can drag and drop your import data just like any other import. Supported fields include the name, description, images term meta (custom fields), and the parent term.

The parent term settings are in the 「Other Category Options」 section:

Other Category Options

And you can also choose whether to manually set the slug for the category, or let a slug be automatically generated.

Note: When importing non-hierarchical taxonomies (e.g. Tags), only the option to set the slug will appear in this section.

Nested, Hierarchical Taxonomies

Nested, Hierarchical Taxonomies

WP All Import provides two options to import hierarchical or nested taxonomies, also known as 「parent」 and 「child」 taxonomies.

Example A

If you have a file where the taxonomy structure is specified in a single column or element, use 「An element in my file contains the entire hierarchy」.

Example – you have a column in your file with the value 「Ski Resorts > Colorado > Aspen > Aspen Highlands」

Ski Resorts is the parent, Colorado is a child of Ski Resorts, Aspen is a child of Colorado, and Aspen Highlands is a child of Aspen.

Nested Category Example

Click the Preview button to see what your taxonomy structure will look like after it is imported.

Nested Preview

Example B

If you have a file with many different columns or elements containing your taxonomies, choose the 「Manually design the hierarchy with drag & drop」 option.

Drag the four-pointed arrows to the left or right to make a category a parent or child, or drag up and down to re-order.

Drag and Drop Example

Troubleshooting Guide

Troubleshooting Guide

Is WP All Import not working as expected?

This process will solve pretty much any problem you』re having:

Make sure you are using the latest versions of WordPress, WP All Import and any add-ons and other plugins you have installed. You can get the latest versions of WP All Import and its add-ons in the customer portal.Eliminate other themes and plugins as the potential cause of a conflict. Deactivate all other active WordPress plugins and activate the WordPress default theme.Test out your import on our debugging server. If the import works on our debugging server, but not on yours, you know it』s a problem on your end – most likely with your server settings.Ask your host to check your server』s error log to see if something is stopping WP All Import from working properly. Often, artificial limits on script execution time or MySQL queries prevent WP All Import from finishing imports. Read our guide on terminated imports.

Common Issues

Drag and drop not working? Admin screens look strange? 

First, try clearing your browser cache or using a different web browser. If the problem persists, the issue is usually a theme or plugin conflict. Improperly coded WordPress themes and plugins may load their own JavaScript or CSS files on WP All Import's admin screens, potentially breaking them. See our guide on testing for theme and plugin conflicts: Plugin & Theme Conflicts.

Can』t get from Step 1 to Step 2, Step 2 to Step 3, etc?

Broken PHP session settings will prevent you from being able to move between the different steps of the import process. If you suspect this is the cause, you』ll need to contact your host.

Running in to a Security Check error?

Clear your browser cache or try using a different browser.

Trying to increase import speed?

Read our guide on slow imports.

Import isn』t finishing?

Read our guide on terminated imports.

Concerned your server isn』t properly configured?

If your imports complete successfully, your server is properly configured. If you』re not able to successfully complete an import, it may be that your server is missing necessary components.

We』ve put a lot of effort into getting WP All Import to function on as many different server configurations as possible, and generally speaking, if WordPress works, WP All Import will work.

WP All Import server requirements:

PHP 5.4 or greaterMySQL 5.5 or greatercURLlibxmlSimpleXMLxmlreaderxmlwriterZipArchive

These are all commonly found on servers provided by the vast majority of hosts.

For a list of web hosts that are confirmed to work great with WP All Import, see our recommended hosts page.

File uploads acting weird? Strange caching issues?

Issues with caching can be hard to diagnose. Often they will show themselves if you upload a new import file but WP All Import shows you an older, unrelated import file. There are other symptoms as well, but this is the most common one.

If you』re having a problem with WP All Import and use some form of server side caching, try your import on one of our testing servers. If you aren』t able to reproduce the problem on a testing server, the issue might be related to your caching configuration. We especially see these types of issues with users hosted by WP Engine and Pantheon, or when Varnish tries to cache admin pages.

If you are able to successfully run your import with caching disabled, work with your host to figure out how to configure their caching so that when WP All Import asks for a file or makes a SQL query, the correct result is returned instead of an incorrect, cached result.

Other strange behavior?

Broken WP All Import database tables can stop the import from working correctly.

Try restoring the database tables form a backup, or deleting the WP All Import database tables and reinstalling WP All Import (you will lose all of the data associated with your previous imports).Deactivate and reactivate WP All Import.Test on a fresh WordPress installation with a newly created MySQL database.

Encoding & Character Sets

Encoding & Character Sets

XML Files Can Have Any Character Encoding

XML files can be saved with any character encoding. That character encoding should be defined at the top of the XML file, per XML standards on specifying the character encoding of an XML document.

If special characters in your XML file aren』t appearing correctly in the posts created by WP All Import, it means that the encoding specified in your XML file is probably incorrect – maybe your XML file is claiming to be a UTF-8 when it really is a Windows-1252, or similar.

If you're sure that your XML file is valid, it's not using UTF-8 encoding, and WP All Import is still rejecting it, try adding this code snippet inside your child theme's functions.php file (or in a plugin like Code Snippets):

add_filter( 'is_xml_preprocess_enabled', 'wpai_is_xml_preprocess_enabled', 10, 1 );
function wpai_is_xml_preprocess_enabled( $is_enabled ) {
return false;
}

CSV Files Must Be UTF-8 Or UTF-8 Compatible

Since there is no way to specify the character encoding for a CSV file, WP All Import just assumes all uploaded CSV files are UTF-8, which is the standard character encoding for the web.

This works the vast majority of the time, but if you are importing a CSV file with special characters (things like umlauts, non-Latin characters, etc.) and those special characters aren』t appearing correctly in the posts created by WP All Import, try opening your CSV file in a text editor using the correct encoding, and then re-save it using UTF-8.

On a Mac, our favorite way to do this is using Sublime Text 2.

Plugin & Theme Conflicts

Plugin & Theme Conflicts

Sometimes an issue can be hard to diagnose because it』s being caused by another plugin or your theme. Follow these steps to test for a plugin or theme conflict:

Deactivate all plugins other than WP All Import, WP All Export, and any WP All Import/Export Add-Ons you are using. If you』re importing data into WooCommerce, ACF, or something similar you should leave that plugin active.Switch to a default, unmodified, WordPress theme. If you』re using an add-on to import into a theme, you can leave the theme active.Run your import/export and check the results. If the problem no longer occurs then we know that one of the deactivated plugins or your theme is the cause of the problem.

If there is a conflict, then slowly begin reactivating your old theme and plugins and running the import/export. When the problem returns, whatever you just activated is the cause of the problem.

If you find that deactivating all other plugins and switching to a default theme does not fix the issue, then there』s no conflict. If this is the case, submit a support request and we』ll help you track down the cause of the problem.

Problems with Import Files

Problems with Import Files

This could be happening for a number of reasons, but the troubleshooting process always started the same:

Contact your host and have them check your server』s error log. They will be able to see exactly why your server is rejecting your import file and they will know exactly how to fix it. There isn』t anything we can do to help until your host has checked the error log and we know exactly what the issue is.

Common Server Configuration Issues

Import files are usually rejected because the file you』re trying to upload exceeds your server』s hard limits on file size. Here are the most common hard limits that users encounter:

Maximum Upload File Size (PHP): This is set in php.ini with upload_max_filesize. It determines the maximum file size that your server will allow to be uploaded. This value must be larger than the size of the file you wish to upload to WP All Import.

Maximum Post Size (PHP): This is set in php.ini with post_max_size. It determines the maximum file size allowed to be used in PHP process. This should be set higher than upload_max_filesize.

Memory Limit (PHP): This is set in php.ini with memory_limit. It determines how much memory a script is able to allocate. This should be set higher than post_max_size.

"There's a problem with your import file."

This error is usually encountered when the import file is not valid. There are a number of common reasons that this may be the case:

No Import File: Open the URL in your web browser. It should either download or display a valid import file. If anything else happens then WP All Import will not be able to import the data.

Changed Import File: If the structure of the import file changes then WP All Import will no longer be able to find the data that it is supposed to import. You can either create a new import with the new file, or you can adjust the XPath setting in Import Settings ▸ Advanced Options, and then reconfigure your import in Manage Imports ▸ Edit Import.

Character Encoding: Sometimes the file in encoded in such a way that it may look valid but it』s really not. Other times, a file will declare that it is encoded in one way but really it』s encoded in a different way. Read more on our guide to character encoding.

Incorrect feed type detected: If you're downloading a feed via URL, and there's no file extension, it's possible that WP All Import will guess the incorrect file type. To fix it, you can add "#/" at the end of the URL, then put a fake file name with the real extension, e.g.: https://example.com/?action=getfeed&results=100#/feed.json

Does Not Pass Validation: There are pretty strict rules that XML, CSV, and JSON files must conform to in order for them to work. You can validate your data and URL using one of the following free online services:

XML: http://codebeautify.org/xmlvalidator

CSV: http://csvlint.io

JSON: http://jsonlint.com

Recommended Hosts

Recommended Hosts

While many hosts work well with WP All Import, if you are looking for a specific recommendation Liquid Web and Nexcess work exceptionally well with WP All Import and we've partnered with them to offer a discount for new users. To take advantage of this discount, use the coupon code WPALLIMPORT35 for 35% off your first 3mo when signing up.

Managed Hosting Plans

Nexcess offers two products that we recommend, one tuned for general purpose WordPress sites, and another specifically tuned for WooCommerce sites. Both plans start at $19/mo and work great with WP All Import.

Nexcess Managed WordPress Hosting

Nexcess Managed WooCommerce Hosting

VPS, Cloud, and Dedicated Servers

If you need more horsepower, flexibility, or control over your hosting environment, then you probably want to go with one of Liquid Web's hosting options. They have a variety of options to choose from, with VPS hosting starting at $39/mo, cloud hosting at $51/mo, and dedicated servers at $140/mo.

Liquid Web VPS Hosting

Liquid Web Cloud Hosting

Liquid Web Dedicated Servers

Which one is best for me?

If you aren't sure, the managed hosting options from Nexcess will probably serve your needs very well. If you have a large site or need more flexibility than a managed hosting plan can offer, then you should get in touch with Liquid Web to discuss their VPS, cloud, and dedicated hosting options.

Managed Hosting vs VPS Hosting

Managed Hosting: The hosting company has many sites from different customers all running on the same server inside the same operating system, competing for the same resources. Think of it like sharing a house with roommates. Everyone shares the same kitchen, living room, and bathroom. If the same person spends four hours a day showering or fills the refrigerator with their groceries, you』re going to have a problem. Like landlords, some shared hosts are better about mitigating these issues, but you are still sharing a bathroom with many other people.

VPS & Cloud Hosting: Sites from different customers are still running on the same server, but on separate operating systems, in virtual computers. Another piece of software called a hypervisor makes sure that each operating system always has the same amount of resources available to it. Think of it like living in an apartment complex. You still have a lot of neighbors technically living in the same building, but no matter how many people are taking a shower at the same time, yours is always available.

Dedicated Hosting: You are renting out an entire server and are not sharing it with anyone. This is overkill for the vast majority of sites, but if you need complete control over your hosting environment, then renting a dedicated server is a good option.

Imports & Server Resources

Imports require a lot of server resources, especially if you are importing a lot of data or have a large database. Hosting review sites cover speed, reliability, and customer service but rarely let you know which hosts will throttle your processing power or limit your SQL queries.

Some hosts will pack many customers into small, underpowered, servers. Sites that consume a lot of resources will eat up all of the available processing power, leaving none for you and your import. Alternatively, some hosts will proactively kill your import process to protect other people』s sites.

We』ve tested a lot of hosts and out of all of them, Liquid Web and Nexcess are the two we』ve had the best experiences with. Both are fast, reliable, have well-reviewed 24/7 customer support, and work great with WP All Import.

How To Export WooCommerce Coupons to CSV or XML

How To Export WooCommerce Coupons to CSV or XML

To export WooCommerce coupons, go to WP All Export › New Export and select WooCommerce Coupons. Next, drag and drop to customize your CSV/XML file with your coupon data. Then, run your export and download your file.

Drag and Drop to Export WooCommerce Coupons

Basic coupon data is in Available Data › Standard:

Coupon ID: The coupon ID, assigned by WordPress.Coupon Code: The coupon code itself, used by users to receive the discount.Coupon Description: A description of the coupon, written by the creator of the coupon.Discount Type: One of several preset values. Percentage discounts are exported as percent, fixed cart discounts as fixed_cart, and discounts on specific products as fixed_product.Coupon Amount: The amount to be discounted. Based on the discount type, this is either a percentage or a fixed amount.Expiry Date: Date when the coupon expires and is no longer available, in y-m-d format.Free Shipping: Whether this coupon grants free shipping or not, exports either yes or no. Exclude Sale Items: Whether this coupon works on sale items or not, exports either yes or no.

Other WooCommerce Coupon Data

Less used coupon data is in Available Data › Other. For example, who created the coupon, along with the following fields:

usage_limit: The total number of times the coupon can be used. usage_limit_per_user: The number of times each customer can use the coupon.limit_usage_to_x_items: The maximum number of items allowed in the cart when using the coupon.usage_count: The number of times the coupon has been used.minimum_amount: Minimum cart amount required to apply the coupon.maximum_amount: Maximum cart amount allowed to apply the coupon.

How To Export WooCommerce Customers to CSV or XML

How To Export WooCommerce Customers to CSV or XML

To export your customers, go to WP All Export › New Export and select WooCommerce Customers. Next, drag and drop from the Available Data section to create your export file. Then run the export and download your CSV or XML.

WordPress Users vs WooCommerce Customers

A WooCommerce customer is a specific type of WordPress user.

When someone visits your WooCommerce site and creates a purchase, WooCommerce creates a user account for them. This user account is assigned the role customer, with a set of WooCommerce specific data attached to their account.

Drag and Drop to Export WooCommerce Customer Data

All data tied to WooCommerce customers is in the Available Data section. Drag and drop data elements from right to left to customize your export file.

Exporting WooCommerce Customer Data

WooCommerce customer data is divided into four different sections: Standard, Address, Custom Fields, and Other.

Standard

All basic export fields tied to your WooCommerce customers are in Available Data › Standard. This data is standard for all WordPress user accounts:

ID: Customer ID, which is actually the user ID assigned by WordPressUsername: The username the user chose when creating their accountUser Email: Email address associated with the customer accountFirst Name: Customer's first nameLast Name: Customer's last nameUser Registered: Date when the customer registeredUser Nicename: Sanitized version of the usernameUser URL: Website associated with the customer accountDisplay Name: The name to be displayed publicly, which is selected in WordPress as either the username, first/last, or nicknameNickname: A name chosen by the user to be displayed on the frontendDescription: A description of the user, also labeled as Biographical Info in WordPress

Address

Address fields tied to your WooCommerce customers in Available Data › Address. These address fields are added by WooCommerce and stored in WordPress as custom user meta.

Every customer in WooCommerce has a billing address and a shipping address. Both sets of addresses are organized in the same way:

First NameLast NameCompanyAddress 1Address 2CityPostcodeCountryStateEmailPhone

Custom Fields

Custom fields added to your WooCommerce Customers are in Available Data › Custom Fields. Custom fields are extra information (or metadata) added by your plugins or themes, and they are automatically detected by WP All Export.

For example, WooCommerce adds an "_order_count" custom field which keeps track of how many orders a customer has done.

Other

Other less used export fields tied to your WooCommerce customers are in Available Data › Other.

Exporting WooCommerce Customer Passwords

To export a WooCommerce customer password, include the User Pass export field from Available Data › Other.

These are hashes of the passwords, not the passwords themselves. Hashing is a one-way action that irreversibly scrambles a string of text. It is not possible to reverse the hashing process and reveal the original password. You can, however, import the hashed passwords back into WordPress and customers will be able to log in with their old password.

How to Export WooCommerce Products to CSV or XML

How to Export WooCommerce Products to CSV or XML

To export your products, go to All Export › New Export and select WooCommerce Products. Next, drag and drop the elements on the right to build your CSV or XML export file. Then, run the export to create your product's export.

Step 1:  Select WooCommerce Products

First, go to All Export › New Export and choose to export WooCommerce Products. Click Customize Export File to continue.

Step 2: Customise Your WooCommerce Products Export File

All data related to your WooCommerce Products is in Available Data section. Drag and drop data elements from right to left to customize your export file.

This data is divided into the following sections: Standard, Product Data, Media, Taxonomies, Custom Fields, and Other.

Standard

Basic WooCommerce Product data is in Available Data › Standard:

ID: The post ID, a unique number given to every post in WordPress.Title: The title or name of the product.Content: A description of the product.Short Description: Similar to the excerpt for posts, usually a summary of the content section.Date: The date the product was published, in y-m-d format.Post Type: The post type being exported, which is product in this case.Permalink: The URL of the product.Parent Product ID: Variable products are attached to a parent product, and this exports the post ID of that parent product (A 0 is exported for products without a parent).

Product Data

More detailed WooCommerce Product data is in Available Data › Product Data:

Sku: A product code used to reference and differentiate products. Price: The product's current price, which is the regular price unless the sale price is active and lower.Regular Price: The regular, full price of the product.Sale Price: The sale price of the product.Stock Status: One of several preset values. The default WooCommerce stock statuses are instock, outofstock, and onbackorder. Stock: The number of products currently in stock and available for sale.External Product URL: The affiliate link for external products.Total Sales: Number of times the product has been sold.Attributes: This will export the attribute's name, value, if it's is used in variations, if it's visible, and if it's a taxonomy or not. This data is more easily exported in the Attributes section.Shipping Class: If configured, it exports the name of the product's shipping class.

If your product has attributes like size or color, they will be automatically detected and added to the Attributes section, at the bottom of Product Data.

Media

Images and file attachments associated with your WooCommerce Products are in Available Data › Media. Images and files are treated the same by WordPress. There are two sections inside the Media section, Images and Attachments. Both contain the same types of fields:

URL: The URL of the file or image.Filename: The filename of the file or full size image.Path: The path, or location on the server of the file or image.ID: The attachment ID of the file or image, similar to a post ID. TitleCaption DescriptionAlt TextFeatured: The URL of the featured image

Taxonomies

The categories and tags that the products are attached to are in Available Data › Taxonomies. By default, there are only two, but all custom taxonomies will be automatically detected and available here.

Product categoriesProduct tags

Custom Fields

Custom fields are in Available Data › Custom Fields. For example, data added to Yoast SEO would appear here.

Other

Other, less used product data is in Available Data › Other. This is an incomplete list, with the more important export fields:

Status: Similar to the post status. The default product statuses are publish, draft, and private.Slug: The database friendy name of the product, used in the product URL.Downloadable: Whether the product is downloadable or not.Downloadable Files: Contains the files for that product if the product is downloadable.Sale Price Dates From: When the sale date starts.Sale Price Dates To: When the sale date ends.Manage Stock: If the product handles stock or not, exports yes or no.Up-SellsCross-SellsTax StatusTax ClassWeightLengthWidthHeight

Step 3: Download Your Exported Products

Once you've configured your product's export as required, click Continue to verify your export settings. Next, click Confirm & Run Export when you're ready to run your export.

After your export is done, download the WooCommerce Product export. You can download the export file directly, or you can download a Bundle. The Bundle contains your exports data and a settings file for WP All Import. Upload the Bundle to WP All Import on another site to quickly import these WooCommerce Products.

Here's a quick look at a fairly standard WooCommerce product export: