Visser Labs – WooCommerce Plugins
  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. How to filter exports by language with WPML in Store Exporter Deluxe
  1. Home
  2. Knowledge Base
  3. Integrations
  4. How to filter exports by language with WPML in Store Exporter Deluxe

How to filter exports by language with WPML in Store Exporter Deluxe

Requires WPML Multilingual CMS. The Products filter and the Language field also need WooCommerce Multilingual.

Selling in more than one language means WPML keeps a separate copy of every product, category and tag for each language. When you only need one language in your file, for a translator, a regional marketplace or a price check, you don’t want to clean up the extra rows by hand.

Store Exporter Deluxe can filter your export by WPML language and add a Language column to it. This guide shows you how to confirm the integration is on, filter Products, Categories and Tags by language, and run the same Products filter on a schedule.

Prerequisites

RequirementDetails
PluginStore Exporter Deluxe 5.4.6 or later is active and licensed
Multilingual pluginsWPML Multilingual CMS is active. WooCommerce Multilingual is also active for the Products filter and the Language field
LanguagesAt least two languages are set up in WPML, and your products, categories or tags have translations

How it works

When WPML Multilingual CMS and WooCommerce Multilingual are both active, Store Exporter Deluxe adds two things. You get a Language filter on Products exports, and a Language field you can add to Products, Orders, Categories and Tags exports.

The Language field shows each item’s language by its English name, such as French. The language list in the filter shows each language by its own name, such as Français.

Categories and Tags exports get their own Language filter in Quick Export. It appears when WPML translates that taxonomy and your store has more than one language. This filter works with WPML Multilingual CMS or Polylang, and it doesn’t need WooCommerce Multilingual. If you don’t pick a language, a Categories or Tags export only includes terms in your current WPML admin language.

Step 1: Confirm the integration is active

  1. Go to WooCommerce → Store Export.
  2. Click Export Modules in the sidebar.
  3. Click Refresh Status.
  4. Click the Active tab.
  5. Check that WPML Multilingual CMS and WooCommerce Multilingual both show Active.
The Export Modules screen with the Active tab selected, showing WPML Multilingual CMS and WooCommerce Multilingual with Active badges, and the Refresh Status button outlined

Step 2: Filter a Quick Export by language

Choose the export type

  1. Click Quick Export in the sidebar.
  2. Under Select Export Type, select Products, Categories or Tags.
The Quick Export Select Export Type step with the Products tile selected and the Categories and Tags tiles outlined

Add the Language field

This step is optional. Add the field if you want a column in your file that shows each row’s language.

  1. On the Export Fields step, click Add more fields.
  2. In the Select Export Fields popup, type Language in the search box.
  3. Tick Language.
  4. Click Save Fields.
  5. Click Continue.
The Select Export Fields popup with Language typed in the search box and the Language field ticked, with the Save Fields button outlined

Pick the languages to export

  1. On the Filters & Sorting step, find the Language card.
  2. Tick the checkbox on the left of the Language card.
  3. Click the card to open it.
  4. Under Select Languages, tick each language you want to export.
  5. Click Continue.
The Filters and Sorting step with the Language card ticked and open, showing the Select Languages list with Español ticked

Run the export

  1. On the Export Options step, choose a File Format.
  2. Click Continue.
  3. Click Run Export.
  4. When the dialog shows Export Complete, click Download File.
The Export Complete dialog with the Download File button outlined

Step 3: Filter a scheduled Products export by language

The Products Language filter also works on scheduled exports. The Categories and Tags Language filter is only in Quick Export.

  1. Click Scheduled Exports in the sidebar.
  2. If you see Scheduled exports are currently disabled at the top of the page, click Enable Scheduled Exports.
  3. Click New Schedule.
  4. On the General step, set Export Type to Products.
  5. On the Filters step, open the Product Filters group.
  6. In the Languages row, open the Select Languages… dropdown and pick each language you want.
  7. Finish the Method, Scheduling and Advanced steps.
  8. Click Create Schedule.
The Add New Scheduled Export Filters step with the Product Filters group open and Español picked in the Languages field

Troubleshooting

The Language filter doesn’t appear on a Products export
Go to Export Modules, click Refresh Status, and check that WPML Multilingual CMS and WooCommerce Multilingual both show Active. The Products filter needs both plugins, and it only appears when WPML returns at least one language.
The Language filter doesn’t appear on a Categories or Tags export
Check that WPML or Polylang translates product categories or product tags, and that your store has more than one language. This filter is only in Quick Export, so you won’t see it when you set up a scheduled Categories or Tags export.
The Language field isn’t in Add more fields
Activate WooCommerce Multilingual. The Language field only appears when WPML Multilingual CMS and WooCommerce Multilingual are both active.
My Categories or Tags export only has one language
Open the Language card on the Filters & Sorting step and tick every language you want. With no language picked, WPML limits the export to your current admin language.

Frequently asked questions

Can I filter an Orders export by language?
There’s no Language filter for orders. Add the Language field to your Orders export instead, then sort or filter that column in your spreadsheet.
If I filter orders by a product, are orders for its translations included?
Yes. With WPML and WooCommerce Multilingual active, Store Exporter Deluxe matches orders for every translation of the products you pick.
Does this work with Polylang?
Partly. The Categories and Tags Language filter works with Polylang. The Products Language filter and the Language field need WPML Multilingual CMS and WooCommerce Multilingual.

Need help?

If you have a question or run into any issues, we’re here to help.

Was this article helpful?

Related Articles

Resources & Help