Blog

Blog

How to Import WooCommerce Orders from CSV (HPOS-Safe)

How to Import WooCommerce Orders from CSV Shirely imports WooCommerce orders from CSV through WooCommerce order objects. That supports both legacy order storage and High-Performance Order Storage (HPOS); it does not write orders directly to the posts table. Use this workflow for a controlled migration or a reviewed, on-demand update. Start with a backup and … Read more

Understanding the WPML icl_translations Table (and Why You Shouldn’t Hand-Edit It)

Shirely import field mapping in Matrix Mode: a trid column mapped to WPML translation-group ID (TRID), and name|en, name|fr, name|pl columns mapped to the Name field per language

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

Shirely dashboard - WooCommerce WPML import export overview

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