WP All Import plugin lets in you to import posts, pages, WooCommerce merchandise, and different custom submit kinds in bulk from CSV documents. You also can import content material in a couple of languages.
On This Page
How to import your multilingual content material:
Before Importing
Prepare Your CSV Files for Importing
Create Your Taxonomies in WordPress
How To Import Posts
How To Import WooCommerce Products
This article additionally covers:
Exporting Posts
Importing a Custom Database Design Into WordPress
Known Issues with WPML All Import
Getting Help
Getting Started
Start with the aid of using putting in and activating the subsequent plugins:
WP All Import plugin
WPML middle plugin
WPML All Import upload-on (to be had out of your WPML Downloads page)
If you need to import WooCommerce merchandise, you’ll additionally want WooCommerce Import Add-On Pro.
New to WPML? Check out our Getting Started Guide. It fast walks you thru one-of-a-kind translation alternatives you could use.
If selected, WPML’s Translate Everything function routinely translate all your webweb page’s present day content material and any new content material this is created.
To manually import translations with the WPML All Import plugin, pick to Translate Some of your content material. This choice offers you the cappotential to pick which content material you need to translate.
Before Importing
Before you begin with any uploading, visit WP All Import → Manage Imports and disable the choice Increase velocity with the aid of using disabling do_action calls in wp_insert_post at some point of import.
This could be very critical due to the fact having this feature enabled at the same time as jogging your imports may motive issues.
Prepare Your CSV Files for Importing
Create a spreadsheet to comprise your default language submit titles and content material, and keep it as a CSV record. Give it a significant filename, as this may assist become aware of the record from a listing later withinside the system:
Sample default language CSV organized for uploading
Sample default language CSV organized for uploading
Prepare separate spreadsheets for every extra language:
Sample separate CSV record in a secondary language
Sample extra language CSV organized for uploading
Add a Unique Identifier
When you import the documents later, WP All Import will want a manner to fit the default language posts to their corresponding translations withinside the different documents.
To try this, you want to specify a completely unique identifier for every submit. Assign an ID wide variety to one in every of your posts for your default language. Then, use that identical ID wide variety for the identical submit for your secondary language documents. By searching at this ID, you could inform which submit is the interpretation of any other with the aid of using locating the identical ID wide variety for your documents.
For example, withinside the screenshots above, you could see that, “Hello World!” has a Polish translation of “Witaj świecie!” due to the fact they’ve the identical particular identifier.
Create Your Taxonomies in WordPress
If you’re uploading translated posts with taxonomies (categories, tags, or custom taxonomies), you need to create the precise identical taxonomies for your WordPress webweb page earlier than uploading the submit documents. This may be completed in ways:
Create the phrases manually and translate them. Make positive the phrases which you create in each your default and secondary languages fit the phrases you operate for your CSV documents exactly. If you’ve got got a variety of phrases to translate, you could take a look at our manual on translating all taxonomy phrases at once.
Import the phrases the usage of WP All Import. To try this, put together new CSV documents to import the taxonomies and their translations. Add the particular identifier column to all CSV documents to hyperlink every taxonomy time period with its translation. You can observe WP All Import’s manual on uploading taxonomies, however make sure to set the import language as defined withinside the phase later on this article.
Each time you import posts with taxonomies, you want to create the taxonomy phrases first, then import the posts. Once the taxonomy phrases and translations exist and fit the phrases for your CSV record, WP Import might be capable of set the perfect taxonomy for posts you import.
Matching Taxonomy Translations After Import
As formerly stated, we notably endorse developing your taxonomy phrases and translations earlier than uploading your CSV documents. If you do now no longer create your taxonomies earlier than uploading your CSV documents, your secondary language taxonomy phrases will now no longer be related as translations of the default language phrases. You will want to edit every of your translated taxonomy phrases to fit them with the perfect default language taxonomy time period.
To try this:
Go to Posts → Categories (or whichever taxonomy kind you’re correcting).
Switch for your secondary language the usage of the language switcher on the pinnacle of the page.
Edit the taxonomy time period you want to fix.
Editing a taxonomy time period in a secondary language
Editing a taxonomy time period in a secondary language
At the lowest of the page, pick which default language taxonomy time period the present day time period is a translation of.
Mapping a translated taxonomy time period to its default language value
Mapping a translated taxonomy time period to its default language value
Taxonomy phrases need to in no way have the precise identical call withinside the default and secondary languages. Otherwise, the import of the translated phrases will now no longer characteristic properly.
If phrases have the identical call in a couple of languages, we endorse which you extrade the translated phrases to some thing else earlier than uploading them. After a success import, you could extrade the translated time period again to be similar to the default language time period.
How To Import Posts
Once your taxonomies and their translations are in place, you’re geared up to import your CSV documents. Be positive to import your default language documents first, observed with the aid of using your secondary language documents. We will summarize the stairs below. For greater designated documentation, please see WP All Import’s article on a way to import documents.
First, Import the Default Language File
To import your default language record:
Go to WP All Import → New Import, and click on Upload a record to add your default language CSV record. Choose whether or not you’re importing new or current items, and what kind of detail you’re uploading.
On the subsequent display, you could evaluate every row for your CSV record. If all of it seems correct, click on Continue to Step 3.
Map your column titles from the proper sidebar to the perfect fields with the aid of using dragging and losing them. Expand the WPML All Import metabox and pick your default language. Then, click on Continue to Step 4.
Mapping the default language fields withinside the WP All Import wizard
Mapping the default language fields withinside the WP All Import wizard
Map the particular identifier to the perfect detail for your CSV or XML record. Click Continue to view a precis of your import, then click on Confirm & Run Import to import your default language posts.
Setting the particular identifier value
Setting the particular identifier value
Next, Import the Secondary Language File
Repeat the import system together along with your secondary language record with some exceptions:
In the WPML All Import metabox, pick the perfect secondary language.
Expand the Automatic Record Matching to Translate phase and pick the record which you used to import the default language posts.
Drag the sphere which you are the usage of because the particular identifier to the Unique Identifier area. This area and the Unique Identifier area on the subsequent display desires to be similar to the only you selected at some point of the default language import.
Setting the secondary language, figure import, and particular identifier
Setting the secondary language, figure import, and particular identifier
Setting the identical particular identifier for the secondary language
Setting the identical particular identifier for the secondary language
This import will create posts in secondary languages and join them because the translations of the default language.
Adding Translations When the Default Language Content Already Exists at the Site
Because WP All Import is based at the particular identifier to attach translated posts with their corresponding default language submit, you can’t add the secondary language record to feature translations to pre-current default language content material. If you try this, WP All Import will now no longer recognise which posts the translations belong to.
To upload translations whilst default language content material already exists at the webweb page:
Export your default language content material the usage of WP All Export.
Edit the newly created CSV to feature a column for the particular identifier.
Delete the authentic content material from the webweb page.
Import the default language CSV record with the particular identifier column. Make positive to import it as New items.
Once the default language record has been imported, you could hold together along with your secondary language record as formerly explained.
How To Import WooCommerce Products
WooCommerce Import Add-On Pro is needed for uploading easy and variable WooCommerce merchandise. Once you’ve got got bought WP All Import, you could discover the hyperlink to down load WooCommerce Import Add-On Pro for your WP All Import downloads page.
You can import WooCommerce easy merchandise with the aid of using following the system defined above for developing taxonomies and uploading posts.
If you want to import WooCommerce variable merchandise, there are a few extra steps. Follow WP All Import’s educational for commands on a way to import variable WooCommmerce merchandise. Don’t overlook to feature the particular identifier column!
You can then import your translations the identical manner, paying near interest to the greater concerns as mentioned withinside the educational. Be positive to create all of your product taxonomy phrases and translations earlier than uploading your CSV documents.
How To Manually Import Products With Prices in Other Currencies
To import merchandise with manually set expenses for different currencies, make certain to set the applicable fields withinside the WooCommerce Add-On phase for the default language import. This consists of the normal fee and sale fee.
Setting the WooCommerce import fields
You additionally want to feature the subsequent custom fields withinside the default language import so as for the expenses to expose effectively at the product pages in secondary languages. In our example, we’ve manually set expenses for merchandise in Euros. Hence, we’ve introduced the subsequent custom fields:
_regular_price_EUR
_sale_price_EUR
_price_EUR
_sale_price_dates_to_EUR
_sale_price_dates_from_EUR
_wcml_schedule_EUR
_wcml_custom_prices_status
Adding the custom fields
Depending at the foreign money you’ve got got set expenses for, you want to extrade the suffix of numerous of the custom fields to fit the foreign money code. To get the foreign money code:
Go to WooCommerce → WooCommerce Multilingual.
Go to the Multi-foreign money tab and click on at the Add foreign money button.
Select the foreign money to get its code.
Getting the foreign money code
If you’re uploading merchandise in a couple of language and all of them have manually set expenses for all different currencies, make certain to feature custom fields related to all of the foreign money suffixes.
Exporting Posts
WPML and WP All Import do now no longer have an choice to export posts from a WordPress installation.
We do now no longer endorse the usage of the usual WordPress choice to export content material to XML documents (Tools → Export). You will should cut up the ones documents into many (one for every language) and upload an XML detail with a Translation Group ID. XML documents aren’t clean to edit, so it could be a prolonged system.
If you need to keep a backup of your posts, we endorse the usage of an export plugin like WP All Export. These plugins export CSV documents, which make it simpler to cut up documents in keeping with language and upload facts approximately the Translation Group ID.
You can try this manually, or in case you are a programmer, you could parse the ones documents in PHP. For each row, you could take a look at the interpretation of the given submit the usage of the wpml_object_id filter.

Code:iE63nf0_ykrypisc5175YPaxSZ1G9IZL5VfurwGEYOk