Effortless Product Import & Export for Multilingual WooCommerce Stores

Expanding your WooCommerce store to a global audience? Managing multilingual product data can be challenging, but the Product Import Export Plugin for WooCommerce simplifies the process. This powerful plugin allows you to effortlessly import and export products, reviews, tags, and categories, saving time and ensuring data consistency. Now fully integrated with WPML (WordPress Multilingual Plugin), this plugin enables smooth compatibility with multilingual WooCommerce websites.

Make sure you have:

• Installed and activated the Import Export Plugin for WooCommerce.
• Installed and configured the WPML core plugin.
• Activated the WPML String Translation add-on.

The Article Flows as follows:

1. Translating the plugin content.
   1. Translate static content
   2. Translate dynamic content (To be added soon)
2. Translate products for export
3. Import translated product

Before starting the translation process, scan the plugin to identify translatable strings.

1. Navigate to WPML > Theme and Plugins Localization in your WordPress dashboard.
2. Scroll to the Scan strings in themes, plugins, and WordPress section.
3. Under the Plugins section, locate and select GDPR Cookie Consent plugin.
4. Click Scan selected components for strings to start scanning.
5. Wait for WPML to complete the scanning process. A pop-up will display the total number of detected strings.
6. Once the scan is complete, WPML will add the identified strings to the translations table.

Hardcoded text in your plugin is called static content. They are hardcoded in PHP files. UI elements include buttons, labels, messages, and form field placeholders. These texts do not change based on user input.

1. Navigate to WPML > Translation Management.
2. Scroll down until you find the Other Texts (Strings) section, which allows you to translate text from themes, plugins, and additional elements.
3. Click on the All domains filter and select the relevant domain. The static contents of the WebToffee’s Product Import Export plugin are listed in the textdomain: wt-import-export-for-woo.

4. Use the search bar to find the specific text you want to translate.
5. Check the boxes next to the strings that require translation.
6. After selecting the required strings, scroll to the Translate your content section.
7. WPML will take you to the Translation Controls interface, where you can configure how the plugin should translate the selected strings.
8. Click on the dropdown menu next to All languages to select the translation method:

9. WPML offers review options before publishing translations. Select the preferred review type.
10. If WPML detects previously translated content, choose whether to keep existing translations or overwrite them.
11. Once everything is configured, click the Translate button to finalize the translation process.

In a multilingual site, products listed under different categories can be viewed by changing the site’s language. Navigate to Dashboard > Products. Under the English option,  you can see all the added products in English. Under the Bengali option, you can see all the added products of the German language. Here is an example of the sample product: Wheels.

1. To translate all the products from English to Bengali, navigate to Translation management in the WPML plugin. In step 1, Click on the Product.

2. This lists all the products and the related taxonomies, such as product categories and tags.

3. Select the product you need to translate and move to Step 2: Translate your Content. Now select Bengali as the language and select the preferred translation methods. Here, we have chosen Translate myself.

4. Now, click on Translate. The manual translation will be listed in the translation queue. You can also choose other translation methods, such as one Translation service and Automatic translation.
5. Select the product from the translation queue, and the translation window will appear. In the translated content, enter it manually, and click on Complete translation.

5. Now, we have the product Wheels added under bengali.

6. From the WordPress admin panel, navigate to the WebToffee Import Export (Pro) menu. Click on Export and In Step 1: Select post type,specify the post type as Product.

7. In Step 2 : Select an export method, select an export method.
8. Proceed to Step 3: Filter data, and filter the data.
9. Map, edit, and re-order the export columns in Step 4: Map and reorder export columns.
10. In the next step, use the advanced options for export and scheduling export.
11. Click on Export, and the CSV file gets downloaded to your computer.

With the Product Import Export Plugin for WooCommerce, you can easily import multilingual products following the steps mentioned below.

1. Install, Activate and configure the WPML Plugins.
2. Prepare the CSV to be imported.

The product Import Export plugin facilitates the import of multilingual products with the help of a CSV file. For Importing multilingual products, apart from the default columns, these additional columns must be included in the CSV:

• wpml:language_code
• wpml:original_product_id
  (or)
  wpml:original_product_sku

During import, only one of these columns(wpml:original_product_id, wpml:original_product_sku) is required i.e you can either import using product id or product sku . You can either import using product id or product sku. The name of the columns and its format (underscore and colon) should be specified precisely in the same manner as given above.

• In the wpml:language_code column, enter the code of the language to which the site has to be translated.
• The product ID of the products can be entered in the wpml:original_product_id column.
• Similarly, the product SKU can be entered in the wpml:original_product_sku column.

In the above example, you can see a product with parent SKU as A11 and product_id as 111. In order to import this product in English, Italian and German, you will have to include three additional columns wpml:language_code, wpml:original_product_id, wpml:original_product_sku.
Then, enter the code ‘en’ for English, ‘it’ for Italian, ‘de’ for German in the wpml:language_code column and enter 111 in the wpml:original_product_id column.

3. From the WordPress admin panel, navigate to the menu: WebToffee Import Export (Pro). Click on Import and specify the post type as Product.
4. In Step 2, select an import method.
5. Next, in Step 3: Map the import columns.
6. In the next step, use the Advanced options for import and scheduling import.
7. Click on Import, and the CSV file gets imported.