Author 诗语

Password Protected Files

Password Protected Files

WP All Import can import XML & CSV files that are protected by HTTP Authentication.

In Step 1, choose the Download  From URL option.

Then enter the URL to your file like so:

http://username:password@link-to-file

In the example below, you』ll find 3 parts in the link format.

http://louis:[email protected]/soflyy/feed.xml

Username: louisPassword: znxah&jfja_Link To File: some-site.com/soflyy/feed.xml

To find out if your password-protected file is using HTTP authentication, just enter the URL to it with the username and password specified in the above format into your browser.

If the file begins to show or download, it is using HTTP Authentication.

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.

Server Configuration

Server Configuration

If your server can successfully complete an import then it is properly configured. We have guides on import speed, terminated imports, and file upload errors.

If your server cannot successfully complete an import then you should read our troubleshooting guide.

To learn about web hosts that we recommend, please see our recommended hosts page.

Server Requirements

There are no server hardware requirements for WP All Import. If you are maxing out your server』s available resources during the import process, upgrading to a more powerful server will help to increase your import speed. If you are not maxing out your server』s available resources then you will probably not benefit from upgrading to a more powerful server.

Generally speaking, if your server can run WordPress then it can run WP All Import. Your server will need the following software packages installed:

PHP 7.0 or greaterMySQL 5.5 or greatercURLlibxmlSimpleXMLxmlreaderxmlwriterZipArchive

Recommended Server Settings

The following settings are recommendations to help avoid server errors. If you aren』t running in to any errors during the import process then you don』t need to worry about these settings.

Maximum Input Variables (PHP): This is set in php.ini with max_input_vars. It determines the maximum numbers of input variables that PHP will allow. In our experience 6000 is sufficient, but you may wish to raise this limit if you are importing a large amount of product attributes.

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.

Maximum Execution Time (PHP): This is set in php.ini with max_execution_time. It determines how long a process is allowed to run before it』s terminated. You can ask your host to increase the limit, but first you should lower the 『Records per iteration』 setting in WP All Import.

FCGID Timeouts (Apache): This is set in httpd.conf with FcgidIOTimeout. It determines how long mod_fcgid will wait while trying to perform a read or write. It should be set as high as your host will allow. In our experience 90 seconds is sufficient.

Update Existing Posts

Update Existing Posts

WP All Import can import data to posts that already exist on your site, even if they were manually created instead of imported by WP All Import.

You need something in your import file that WP All Import can use to 「match」 the 「records」 in your import file to the posts that already exist on your site – that』s why it』s called Manual Record Matching.

When importing into existing records, you can specify which data WP All Import will update or overwrite, and which will be left alone.

Follow along with the below example to get a complete understanding of how to import data into existing posts on your site.

Example – Updating Multiple Property Listings With New Prices

I have a few property listings with outdated prices.

Example Properties

I have a CSV file with the MLS numbers of the properties, and the new prices.

CSV File

I』ve entered the MLS number of each property in my theme, so we can use the MLS number as the 「matcher」 so that WP All Import Import knows which price should be assigned to which property.

MLS Number

To do the import, upload your CSV in Step 1, and choose Existing Items.

Step 1 Existing Items

Continue to Step 2 and then to Step 3. In Step 3, set the price Custom Field to the price from your file.

Setting the price

The only field we want to import data to is the price. So just leave all the other fields blank. WP All Import Import will warn you that your post title and content are blank, but that』s fine – you can continue anyway. We don』t want to update the title or content here, just the price.

Now it』s time for the most important part – telling WP All Import Import how to match the records in our CSV file with the existing property listings already on our site. We』re going to match by the MLS number – since we have the MLS number in both places – on our site, and in our file.

Choose 「Match by Custom Field」 and click in the Name box to see a dropdown list of Custom Fields available to match by. Then choose 「mls_value」 – the Custom Field name the theme uses internally for the MLS field.

Record Matching

Then drag & drop the MLS column in your CSV file to the Value textbox.

MLS Value

Now, for each record in your file, WP All Import will look for a property on your site with an mls_value Custom Field that equals {mlsno[1]} from your file, and then import the price to it.

To ensure WP All Import only imports the price, and doesn』t overwrite the title, content, and other fields we left empty with blank values, we specify which data points we wanted updated, and which we want ignored.

Choose which data to update

Here』s the result after running the import – our 3 posts were updated with the new prices.

Import Summary

Data Updated

Combine and Process Multiple Data Elements into a Custom Export Field

Combine and Process Multiple Data Elements into a Custom Export Field

Custom export fields can be used to combine any number of data elements, function calls, and static text into the same export field.

Create a Custom Export Field

To create a custom export field, click Add Field and select Custom export field.

After selecting Custom export field, drag elements from the Available Data section on the right into the export field editor on the left. Unlike normal export fields, you can combine multiple fields together. For example, you can drag the First Name and Last Name elements to create a Full Name in a Users export.

Here's the result:

Using Static Data

You can include any type of static text or data required in your export. For example, you can include the currency symbol next to your prices when exporting products.

Here's the result:

Using PHP functions

You can use functions directly inside the Custom export field. Moreover, you can call functions with as many arguments as required.

Following the previous example, you can use a function to apply a 20% discount if the product price is above 100 USD and the product category is clothing. This function would take in two parameters: a price, and a category.

Here's the result: