诗语，作者 WP All Import 文档

Yoast WordPress SEO

In this tutorial you』ll learn how to import posts into WordPress along with their settings for the Yoast WordPress SEO plugin. WP All Import makes it easy to import into almost any plugin or theme.

You can complete this import manually, as described below, or you can use the Yoast Add-On for WP All Import: https://wordpress.org/plugins/yoast-seo-settings-xml-csv-import/

The settings for Yoast are stored in Custom Fields attached to every post. Watch the video tutorial below to see how easy it is to import these settings:

Just like importing other Custom Fields, you can manually enter the field name into WP All Import or you can choose to have WP All Import auto detect all of the Custom Fields attached to the post type you』re importing to. Remember, in order for WP All Import to detect these Custom Fields there must be at least one post on your site using them.

Yoast uses thirteen different Custom Fields to store settings for your posts. If you don』t import a value to a Custom Field then Yoast WordPress SEO will simply assign your post the default for that field.

NameCustom FieldValuesFocus Keyword_yoast_wpseo_focuskwText stringSEO Title_yoast_wpseo_titleText stringMeta Description_yoast_wpseo_metadescText stringMeta Robots Index_yoast_wpseo_meta-robots-noindexBlank for default, 1 for noindex, or 2 for indexMeta Robots Follow_yoast_wpseo_meta-robots-nofollowBlank for follow, 1 for nofollowMeta Robots Advanced_yoast_wpseo_meta-robots-advBlank for default, none, noodp, noydir, noimageindex, noarchive, or nosnippetInclude in Sitemap_yoast_wpseo_sitemap-includeBlank for auto, always, or neverSitemap Priority_yoast_wpseo_sitemap-prioBlank for auto, 1 to .1Canonical URL_yoast_wpseo_canonicalCanonical URL of post301 Redirect_yoast_wpseo_redirectURL to redirect post toFacebook Title_yoast_wpseo_opengraph-titleText stringFacebook Description_yoast_wpseo_opengraph-descriptionText stringFacebook Image_yoast_wpseo_opengraph-imageURL to imageTwitter Title_yoast_wpseo_twitter-titleText stringTwitter Description_yoast_wpseo_twitter-descriptionText string

Here』s an example of how your import template might look while importing Yoast WordPress SEO settings:

Yoast Custom Fields

Importing SEO data for Taxonomies

Yoast stores taxonomy SEO data via the Options API, so the Term Meta section won』t work – instead, you』ll need to use our add-on for Yoast: https://wordpress.org/plugins/yoast-seo-settings-xml-csv-import/. In the import settings, you』ll still use the term meta section to decide which fields to update. Here are all of the available taxonomy fields:

NameCustom FieldValuesFocus Keywordwpseo_focuskwText stringSEO Titlewpseo_titleText stringMeta Descriptionwpseo_descText stringMeta Robots Indexwpseo_noindexBlank for default, 1 for noindex, or 2 for indexInclude in Sitemapwpseo_sitemap_includeBlank for auto, always, or neverCanonical URLwpseo_canonicalCanonical URL of postFacebook Titlewpseo_opengraph-titleText stringFacebook Descriptionwpseo_opengraph-descriptionText stringFacebook Imagewpseo_opengraph-imageURL to imageTwitter Titlewpseo_twitter-titleText stringTwitter Descriptionwpseo_twitter-descriptionText stringTwitter Imagewpseo_twitter-imageURL to image

Bulk Edit

You can quickly bulk edit posts using WP All Import and WP All Export along with your favorite spreadsheet program (Excel, Numbers, etc). The data is first exported with WP All Export. Then make your changes and upload it with WP All Import.

Step 1: Select What You Want to Export

You must first decide which post type or taxonomy you want to edit. You'll see all of the available options in the dropdown at the start of a new export.

Step 2: Decide Which Data to Edit

You'll see all of the data available to export on the right. Drag over the fields you need to edit and they'll be included in the export file. Certain fields are required depending on the post type being exported, you'll see a message if you're missing any of those.

Step 3: Confirm & Run Export

Run the export.

Step 4: Download Export File

Once the export completes you'll need to download the generated CSV file.

Step 5: Update the Exported Data

Using the program of your choice open the export file and make any updates necessary. Don't remove any columns or data will be missing after the import runs.

Step 6: Generate a New Import

Using the 'Import with WP All Import' button will start the creation of a new import. This option automatically configures the import settings for you. Your import will be created based on the fields you set when exporting.

Step 7: Upload the Updated File

Choose the option to 'Upload a file' and select the CSV you just modified. Your file will be uploaded and you'll be taken directly to Step 2 of the new import.

Step 8: Review the Data to Update

Here the data to be updated is already mapped to the appropriate import fields. You can take a look at what was mapped, or just continue to Step 4.

Step 9: Review the Data to Update

Here you can modify what data to update when the import runs. Usually, it shouldn't be changed.

Step 9: Confirm & Run Import

Now it's time to run your import.

Migrate

Migrating data between sites is possible using the integration between WP All Export and WP All Import. You can migrate posts, pages, WooCommerce products, orders, and custom post types from any theme or plugin.

Step 1: Select What You Want to Export

You must first decide which post type or taxonomy you want to migrate. You'll see all of the available options in the dropdown at the start of a new export.

Step 2: Decide Which Data to Migrate

The fields available to export are listed on the right. Drag over those you want or click 'Add All' to include everything.

Step 3: Confirm & Run Export

Run the export.

Step 4: Download the Export Bundle

Download the export bundle ZIP file using the 'Bundle' button. Don't unzip the archive.

Step 5: Upload Export Bundle to WP All Import

Start a new import at All Import > New Import on your destination site. Then upload the ZIP archive you downloaded from WP All Export.

Step 6: Skip to Step 4

The export bundle automatically configures the import, allowing you to skip straight to Step 4.

Step 7: Confirm & Run Import

Step 4 shouldn't need any changes, just click Continue. Then run the import.

Scheduling Imports Using Cron Jobs

Each time the cron is run, WP All Import will download your XML or CSV file from the specified URL and update, delete, and create posts on your site according to your settings.

To set up a recurring import using cron jobs, specify the URL to your XML or CSV file on the Import Settings page.

Then, visit the Scheduling Options link on the Manage Imports page to open the Scheduling Options Popup.

You will need to choose the 「Manual Scheduling」 option here:

Manual Scheduling

Each import has two cron URLs – a trigger URL, and a processing URL.

The trigger URL will look something like this:http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger

The processing URL will look something like this:http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=processing

You can find your secret key on the All Import -> Settings screen, and the import ID on the Manage Imports screen.

If you want to run your import every 24 hours, you should run the trigger URL every 24 hours. If you want to run your import once per week, you should run the trigger URL every week.

The processing URL should be run every two minutes because it may not finish your import in one run. The reason is that many hosts have maximum script execution times in place, so its only possible for the processing script to finish only a small percentage of your import before it is timed out.

If this is the case and the processing script is run again after two minutes, it checks to see if your import is finished, or if there』s still work to be done. If there』s work to be done, it will import posts for as long as it can, or two minutes, whichever is longer.

Then, on the next run of the processing script, it will see if more work needs to be done on the import – and if so, it will do it. If not, it will 「untrigger」 the import. And now the processing script will have no effect until the import is triggered again by the next run of the trigger script.

Setting Up Cron Jobs

The instructions for setting up cron jobs vary across hosts. Commonly, you can do it in your web hosting control panel.

To create a cron job that hits the cron URLs, commonly the wget command is used. Examples are on the Manage Imports -> Cron Scheduling screen of WP All Import.

Below are a few cron command examples (not all options work with all hosts, ask your host for help as needed):

wget --spider "http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger&rand="$RANDOM

wget -q -O - "http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger&rand="$RANDOM

curl "http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger&rand="$RANDOM

lynx "http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger&rand="$RANDOM

To ask your web hosting provider to set up the cron for you, use this e-mail template:

Hi Support,

Please set up two cron jobs.

CRON JOB 1Fetch this URL every 24 hours: http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger

CRON JOB 2Fetch this URL every 2 minutes: http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=processing

Thanks,Your Name

If your web host doesn』t have a cron feature, you can use an external service like EasyCron.

Call Cron URLs from the Command Line

You can call the WP All Import and WP All Export cron URLs from the command line. This may be necessary if your site's configuration won't allow inbound calls to the regular cron URLs.

It'd look something like this:

/path/to/your/php-cgi /path/to/yourwordpressinstall/wp-load.php import_key=ABC123 import_id=5 action=trigger
/path/to/your/php-cgi /path/to/yourwordpressinstall/wp-load.php import_key=ABC123 import_id=5 action=processing

Note: The php-cgi binary must be used or the parameters won't be passed correctly.

Manual Record Matching

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

Run WordPress Export on a Schedule

The Automatic Scheduling service allows you to set up exports with just a couple of clicks. Rather than setting up cron jobs on your server, you can set schedules directly within WP All Export. The Automatic Scheduling service will then contact your site at the scheduled time to run your exports, and check in to make sure they've completed correctly.

Automatic Scheduling vs Manual Scheduling

WP All Export offers two ways to schedule or automate exports. The first option is to manually create the cron jobs in the server. The second option is to use our paid Automatic Scheduling Service, which is integrated within WP All Export and doesn't require any setup.

This guide focuses on Automatic Scheduling.

Configure a Scheduled WordPress Export

To set up the Automatic Scheduling Service on an existing export, navigate to the Manage Exports page. Then, click on Scheduling Options › Automatic Scheduling:

The same Scheduling Options menu appears when creating a new export.

There you decide whether you'd like your export to run weekly or monthly. Then you select the days and times that you would like your export to run.

This service costs $9 USD per month, and allows for unlimited exports to run on an unlimited amount of sites. Subscribe to the Automatic Scheduling service.

Schedule WordPress Exports Using Cron Jobs

To run a WordPress export on a schedule, create two cron jobs on your server. Set one cron job to run every 2 minutes and execute the processing URL from WP All Export. Then, set up another cron job that executes the trigger URL and runs however often you want the export to run.

Manual Scheduling vs Automatic Scheduling

This guide focuses on Manual Scheduling.

Manual Scheduling Uses Cron Jobs

Cron jobs are like reminders for your web server. When you create a cron job, you are basically telling your server that you want to do a specific thing over and over at specific times.

These cron jobs consist of two things: a time and a command. The way they handle time is a little weird, but there are tools like https://crontab.guru/ that make it easy to understand. When the cron job is triggered, the web server will execute the command you provided. In this case, you'll tell the server to open a URL that will trigger your export to run.

To set up an export with Manual Scheduling, WP All Export actually uses two cron jobs to make sure they run on time and finish the export.

Trigger URLs and Processing URLs

Each scheduled export requires two cron jobs. The first one uses the trigger URL, which will fire whenever you want the export to run. The second uses the processing URL, which will fire every two minutes. Web servers generally don't like processes running in the background for a long time, and will kill them after a few minutes. The processing URL goes through and checks to make sure that your export has completed running. If it hasn't, it will start it up again.

To get your trigger URL and processing, navigate to the Manage Exports page, then click on Scheduling Options:

Once there, select the Manual Scheduling option. There you will find the trigger URL and processing URL. There's also a File URL, and a Bundle URL, used to retrieve the latest export files:

The trigger URL is structured like this: https://[YOUR-WEBSITE].com/wp-load.php?export_key=[YOUR_SECRET_KEY]&export_id=[YOUR_EXPORT_ID]&action=trigger

The processing URL is structured like this:https://[YOUR-WEBSITE].com/wp-load.php?export_key=[YOUR_SECRET_KEY]&export_id=[YOUR_EXPORT_ID]&action=processing

Your secret key can be accessed and reset from All Export › Settings.

The trigger cron should be set to run however often you want your export to run.

The processing cron should be set to run every two minutes.

Example Cron Jobs

You should be able to create your cron job in your web hosting control panel. To create a cron job that hits the cron URLs, commonly the wget command is used.

wget -q -O - /dev/null "https://example.com/wp-load.php?export_key=ph2Pyi_dMN&export_id=1&action=trigger"
wget -q -O - /dev/null "https://example.com/wp-load.php?export_key=ph2Pyi_dMN&export_id=1&action=processing"

Alternatively, you can use cURL.

curl -s "https://example.com/wp-load.php?export_key=ph2Pyi_dMN&export_id=1&action=trigger" > /dev/null
curl -s "https://example.com/wp-load.php?export_key=ph2Pyi_dMN&export_id=1&action=processing" > /dev/null

Please note that in both cases, the URLs need to be in quotes. Here's how these cron jobs would look in cPanel:

Get Help From Your Host

If you're not sure how to create these cron jobs manually, your web host support team will be able to set them up for you. Here's an e-mail template you can use:

Please set up two cron jobs.

CRON JOB 1
Fetch this URL every 24 hours:
https://[YOUR-WEBSITE.com]/wp-load.php?export_key=[YOUR_SECRET_KEY]&export_id=[YOUR_EXPORT_ID]&action=trigger

CRON JOB 2
https://[YOUR-WEBSITE.com]/wp-load.php?export_key=[YOUR_SECRET_KEY]&export_id=[YOUR_EXPORT_ID]&action=processing

If your web host doesn』t have a cron feature, you can use an external service such as EasyCron.

Call Cron URLs from the Command Line

You can also call the WP All Export cron URLs from the command line. This may be necessary if your site's configuration doesn't allow inbound calls to the regular cron URLs.

It'd look something like this:

/path/to/your/php-cgi /path/to/your/wordpress/install/wp-load.php export_key=[YOUR_EXPORT_KEY] export_id=[YOUR_EXPORT_ID] action=trigger
/path/to/your/php-cgi /path/to/your/wordpress/install/wp-load.php export_key=[YOUR_EXPORT_KEY] export_id=[YOUR_EXPORT_ID] action=processing

Send Exported WordPress Data via Email using Zapier

Zapier can be used to send an export file via email. Connect Zapier to WP All Export and create the required trigger and action. The trigger would execute whenever a new export is found. The action would be sending the export file via email using Gmail.

Trigger: New Export File in WP All Export Pro

Learn more about connecting to Zapier and setting up the trigger here: https://www.wpallimport.com/documentation/external-app-integration/.

Action: Send Email in Gmail

Choose app & event

Once the trigger is configured and tested, Zapier will prompt to select an action.

Choose Gmail as the app and Send Email as the event, then click Continue.

Choose Account

Zapier will ask for the Gmail account to use. If there's no account connected, select + Connect a new account from the dropdown list and follow the steps.

Once the account is selected, click Continue.

Set up action

This section allows setting up the email that will be sent.

The following can be configured:

To: Who will this email be sent to? Multiple email addresses can be entered as a comma separated list.Cc: Who should be cc'd on this email? Multiple email addresses can be entered as a comma separated list.Bcc: Who should be bcc'd on this email? Multiple email addresses can be entered as a comma separated list.From: Select an email address or alias from your Gmail Account. Defaults to the primary email address.From Name: Used to define a different "From" name for the email. Reply To: Specify a single reply address other than your own.Subject: Email's subject or title.Body Type: Type of content found in the body, plain or HTML. Body: Body or content of the email.Signature: Include a default signature with the email? Will be placed at end of the message after a line break and another "--" line. Label/Mailbox: Used to define a label to sort the email.Attachments: The file to be attached. Select Export File from the dropdown list to attach the actual export file.

Click Continue to move onto the following step.

Test action

Once the email has been configured, Zapier will attempt to test the action. Select Skip Test to avoid this step.

Review all information about the email and click Test & Continue.

Once the test has been completed, click on Turn on Zap to enable the newly created zap.

Send WordPress Export File to Dropbox using Zapier

Zapier can send the export file to Dropbox. Connect WP All Export to Zapier and create the required trigger and action. The trigger would execute when a new export is found. The action would be uploading the export file to Dropbox.

Trigger: New Export File in WP All Export Pro

Connect to Zapier and set up the trigger as explained here: https://www.wpallimport.com/documentation/external-app-integration/.

Action: Upload a File in Dropbox

Choose app & event

After the trigger is set up, Zapier will prompt for an app and action.

Select Dropbox as the app, and Upload File as the action event.

Choose account

In this step, Zapier connects to the Dropbox account where the export file will be uploaded.

If no account has been connected, add one using + Connect a new account from the dropdown list. Click Continue after the account is selected.

Set up action

Define how the Dropbox action will behave in this section:

The next fields can be configured:

Folder: Where the file should be saved.File: File to save. Select Export File to include the latest export file.Overwrite: If there's an existing file with the same name, should Zapier overwrite it? Defaults to No.Specify File Name: The original filename is kept unless a different name is specified here. The file extension is kept.Specify File Extension: If a different filename is specified, this field allows to define a different file extension.

Once configured, click Continue.

Test action

After the Dropbox action is configured, Zapier will attempt to test it. Click Skip Test to avoid this step, or click Test & Continue to proceed.

Enable this Zap by clicking on Turn on Zap.

Send WordPress Export File to Google Drive using Zapier

Zapier can be used to send an export file to a Google Drive account. Connect Zapier to WP All Export and create the required trigger and action. The trigger would execute whenever a new export is found. The action would be sending the export file towards the Google Drive designated.

Trigger: New Export File in WP All Export Pro

Learn more about connecting to Zapier and setting up the trigger here: https://www.wpallimport.com/documentation/external-app-integration/.

Action: Upload File in Google Drive

Choose app & event

Zapier will ask to set up an action after the trigger is configured.

Select Google Drive as the app and Upload File as the action event, then click on Continue. This event will upload the export file into the selected Google Drive account.

Choose Account

Select the Google Drive account to use. If there's no account added, select + Connect a new account from the dropdown list and follow the steps.

Once an account has been chosen, click Continue.

Set up action

This section allows configuring in which Google Drive and folder the export file will be saved.

The following can be configured:

Drive: The drive to use. The personal Google Drive is used by default.Folder: Folder where to place the file. If left blank, defaults to the top-level folder.File: The file to be uploaded. Select Export File from the drop-down list to add the actual export file.Convert To Document?: If enabled, tells Google to convert the file into an editable document.File Name: Define the new file name. By default, uses the original filename.File Extension: Only used if a different filename is specified.

Click Continue to move onto the following step.

Test action

Once the Google Drive integration has been configured, Zapier will try to test it. Select Skip Test to avoid this step.

Test the newly created Zap by clicking on Test & Continue.

Once the test is done, enable this Zap by clicking on Turn on Zap.