How to Export WooCommerce Customers to CSV
Export WooCommerce customers to CSV with account, billing, and shipping fields, safe spreadsheet handling, and migration provenance.
Guides
Step-by-step tutorials for WooCommerce and WPML imports
How to Import WooCommerce Customers from CSV
Import WooCommerce customers from CSV with safe matching, billing and shipping fields, password protection, and controlled invite emails.
Importing 8,500 WooCommerce Products in 4 WPML Languages
A scoped owner measurement of an 8,500-product, 1,040-category, four-language WPML Matrix import, with server context and image bottlenecks.
WPML Database Bloat, WooCommerce, and Import Hygiene
Diagnose multilingual WooCommerce data growth: check duplicates, translation relationships, category hierarchy, imports, and staging cleanup.
WPML and WooCommerce CSV Templates for Matrix Mode
Start with small Matrix CSV shapes for translated products, categories, variable products, prices, and SEO fields, then map and verify them on staging.
How to Choose a WooCommerce WPML Import Plugin
Choose a WooCommerce WPML import workflow by testing product identity, translations, variations, categories, Google Sheets, automation, and QA.
Understanding the WPML icl_translations Table (and Why You Shouldn’t Hand-Edit It)
WPML icl_translations Table Explained: TRID and Safe Checks The WPML icl_translations table records the language and translation group of translatable WordPress objects. If a WooCommerce product appears in the wrong language, a translated category is not connected, or a language switcher points to an unexpected item, this table can show what WPML currently knows. Use … Read more
Import WooCommerce Products from Google Sheets
You can import WooCommerce products from Google Sheets with Shirely without downloading a CSV to your computer. Start a run on demand, or save a supported Google Sheets import as an Automation slot. Editing a cell in the spreadsheet does not itself update WooCommerce. An Automation slot can run … Read more
Matrix Mode Explained: How to Map CSV Columns to WooCommerce + WPML Fields
Matrix Mode: Map CSV Columns to WooCommerce and WPML Fields Matrix Mode is Shirely’s format for importing multilingual WooCommerce catalog data with WPML. Translated fields use language-suffixed column names, while shared fields stay as ordinary columns. The column pattern sku,title|en,title|pl,description|en,description|pl,regular_price DRILL-100,Power Drill,Wiertarka,18V drill,Mocna wiertarka 18V,149.99 The part before the pipe is the field. The part … Read more
5 Most Common WPML + WooCommerce Import Problems (And How to Fix Them)
Most multilingual WooCommerce import problems come from a small set of causes: missing WPML relationships, unstable identifiers, category hierarchy errors, wrong language context, or variation data that is not tied back to the right parent product. 1. Products import but translations are not linked WPML needs translation rows for each language version. In Shirely, use … Read more