---
title: How to Bulk Import WooCommerce Product Translations with Excel for WPML
description: Bulk import WooCommerce product translations for WPML from Excel, linked to the original products.
url: "https://wpfactory.com/docs/how-to-bulk-import-woocommerce-product-translations-with-excel-for-wpml/"
updated: "2026-10-05"
category: How to
---

# How to Bulk Import WooCommerce Product Translations with Excel for WPML

To bulk import WooCommerce product translations for WPML, add **Original Title** and **Language Code** columns to your Excel file and map them in the **WPML TRANSLATIONS** section on the **Import/Update Products** tab at **WPFactory > Product Import/Export** in [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/). Each translated row is linked to its original product.

## Before you start

- WooCommerce, active.
- WPML installed and active. The **WPML TRANSLATIONS** section only appears while WPML is active.
- [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/), active.

## Step by step

1. In your import Excel file, add two columns: **Original Title** and **Language Code**.
2. For your source-language products, the Original Title is not required and the default language set in WPML is used.
3. For each translated product, set the Language Code and point Original Title at the source product's title (or ID).
4. Put the source-language rows above their translations, or import them first, so the original exists when its translation is processed.
5. Open **WPFactory > Product Import/Export**, upload the file on the **Import/Update Products** tab, and map these columns to the **ORIGINAL TITLE or ID** and **LANGUAGE CODE** fields in the **WPML TRANSLATIONS** section, either by drag and drop or with **Auto Match Columns**.
6. Run the import.

## Example rows

| Title | Original Title | Language Code |
| --- | --- | --- |
| Blue T-Shirt |  | en |
| Blaues T-Shirt | Blue T-Shirt | de |
| T-shirt bleu | Blue T-Shirt | fr |

Use the language codes configured in **WPML > Languages**.

A WPML sample file is linked at the top of the Import/Update Products screen when WPML is active.

## How the link is made

- An empty **Language Code** means the WPML default language.
- An empty **Original Title** makes the row an original, not a translation.
- A title is matched to an existing product with that exact title and then to its default-language version. You can use the original product's ID instead.

## If it does not work

- **No WPML TRANSLATIONS section:** WPML is not active.
- **Translations appear as separate products:** the Original Title does not match the source title exactly. Use the product ID instead.
- **Wrong language assigned:** the code does not match a WPML language code.

## FAQ

### Can I translate categories and attributes this way?

This mapping links products. Translate terms in WPML, or create them with the Import Terms tab first.

### Can I use the product ID as the original?

Yes. The field accepts the original title or ID.

Related: [Getting Started: Install and Run Your First Product Import](https://wpfactory.com/docs/getting-started-product-import-export/) and [Import Mapping Options Reference](https://wpfactory.com/docs/import-mapping-options-reference/).

### Get the most from Products Import & Export with Excel

[WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/) imports translated products and keeps them linked to their originals in WPML. [See everything it can do](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/).

Need a hand? Our team answers every ticket on the [Products Import & Export with Excel support forum](https://wpfactory.com/support/item/woocommerce-products-import-export-with-excel/).

Related articles

- [How to Import Affiliate and External Products with Excel](https://wpfactory.com/docs/import-affiliate-external-products-with-excel/)
- [How to Delete WooCommerce Products in Bulk with Excel](https://wpfactory.com/docs/delete-woocommerce-products-with-excel/)
- [How to Import a Variable Product in WooCommerce from One Excel Row](https://wpfactory.com/docs/how-to-import-variable-product-in-woocommerce-with-1-excel-row/)
- [How to Bulk Edit, Import and Export Yoast SEO Meta with Excel](https://wpfactory.com/docs/how-to-bulk-import-export-products-yoast-seo-meta-with-excel/)
- [How to Import WooCommerce Products and Assign Category Terms with Excel](https://wpfactory.com/docs/taxonomy-structure-how-to-import-woocommerce-products-and-caterogory-terms-with-excel/)