In a previous tutorial, we show you how to translate WooCommerce products using a spreadsheet bulk editor.
In this tutorial, we will show you how to translate hundreds of WooCommerce product categories and tags using an intuitive spreadsheet. This will save you a lot of time because you won’t have to open and edit your translated product categories and tags one by one.
We will do this using Taxonomy Terms Spreadsheet. This plugin allows you to edit any category or tag in a spreadsheet specially created for each taxonomy term: a sheet for product categories, a sheet for product tags, a sheet for product colors, a sheet for product sizes, and so on.
In each of these spreadsheets, you can do advanced searches by keyword, parent keyword, display type, product count, etc. You can also apply massive changes to all your categories or tags: delete all of them, remove duplicates, merge terms, and so on. In addition, you can export all your categories to Excel or Google Sheets and import categories and changes applied offline.
To translate your product categories and tags, you need to follow these simple steps.
Step 1. Translate all your products with WP Sheet Editor
You don’t need to spend hundreds of hours creating the product translation one by one and then editing those translations with a lot of tabs open. You can create and edit the translations quickly using WP Sheet Editor.
In the following tutorial, we show you how to translate all your products into several languages in minutes.
WP Sheet Editor will create translations for all your products, together with their categories, tags, and attributes.
Step 2. Install the “Taxonomy Terms Spreadsheet” plugin
With Taxonomy Terms Spreadsheet, you can edit hundreds of categories, and in this case you’ll edit hundreds of taxonomy translations. The product taxonomies are automatically translated by WP Sheet Editor when you translate products.
You can download the plugin here:
Once installed and activated, you need to continue to the next step.
Step 3. Open the categories or tags spreadsheet
As the Taxonomy Terms Spreadsheet plugin creates a spreadsheet for each taxonomy term, you need to select which spreadsheet you’ll use.
Go to WP Sheet Editor > Edit categories, tags, attributes, taxonomies and select the spreadsheet you’ll use.
- To open the product categories spreadsheet: Edit Product categories
- To open the product tags spreadsheet: Edit Product tags.
We’ll select Edit Product categories to use it as an example, but you can apply the same steps to the tags spreadsheet.
The content shown in the spreadsheet will depend on the language you select. If you select English, the spreadsheet will show the categories in English only.
If you select the Spanish language, the spreadsheet will show you the translations created for that language. The number of categories may vary in relationship to the main language because only the categories and tags used by the translated products will be translated.
If you select the Italian language, the spreadsheet will show the category translations for that language only.
We’ll use the Italian spreadsheet as an example of how to translate all your categories quickly.
Step 4. Translate the category or tag titles
We’re using the Italian translations as an example.
To translate the category or tag titles, you just need to go to the Name column and translate the titles, also you can translate the category description. Once done, click on Save to apply the changes.
You don’t have to open and edit the category translations one by one, so you can save a lot of time!
Step 5. Edit the category or tag slugs
To edit the category or tag slugs, you could edit the content in the Slug column, but we’ll show you how to do it quickly using the Bulk Edit tool. We will automatically generate the slug from the translated names.
For that, open the Bulk Edit tool with one click on the toolbar.
Now select these values to copy the content from the Name column into the Slug column.
- Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows).
- What field do you want to edit: Slug
- Select type of edit: Copy from other columns
- Copy from this column: Name ($name$)
- Click on Run search.
After applying these values, you’ll see that the content in the Slug column will be edited. Now your slugs are in Italian.
Translating thousands of categories and tags is really simple with the Taxonomy Terms Spreadsheet. You just need to edit the category titles and then copy that content to the Slug column. It only takes some minutes and you don’t have to open your categories and tags one by one.
You can export your taxonomies to Excel or Google Sheets to edit the CSV offline or give it to your translators and import them back to WooCommerce using that same CSV file.
You can download the plugin here: