Integrations
Import your Excel or CSV into WooCommerce Products
WooCommerce's built-in product CSV importer expects specific column names (Name, SKU, Regular price, Categories, Images…), numeric prices without currency symbols, and image URLs it can fetch. A raw catalogue export usually needs reshaping first. Importly maps your columns to WooCommerce's product fields, formats prices and weights, and cleans category and image values — so the importer loads your catalogue without errors.
Column headers Importly recognises for WooCommerce Products
Whatever your source file calls them, Importly matches your columns to the fields WooCommerce Products expects:
| Field in WooCommerce Products | Recognised from headers like |
|---|---|
| Name | name, title, product name, nom, nom du produit, titre… |
| SKU | sku, reference, référence, ref, réf, mpn… |
| Description | description, desc, detail, détail, product description, description produit… |
| Regular price | price, prix, tarif, amount, montant, unit price… |
| Categories | category, categorie, catégorie, categories, catégories, type… |
| Weight (kg) | weight, poids, grams, mass, masse, weight (kg)… |
| Stock | quantity, quantite, quantité, qty, qte, qté… |
| Images | image, images, photo, photos, picture, visuel… |
How to import your file into WooCommerce Products
- 1 Upload your Excel or CSV and pick the WooCommerce Products profile.
- 2 Importly renames the columns, cleans every value — dates, phone numbers, amounts, countries — and drops duplicates and empty rows.
- 3 Download the cleaned file and import it into WooCommerce Products. It maps on the first try.
Frequently asked questions
What columns does a WooCommerce product CSV need?
At least a Name and, ideally, an SKU and Regular price; Categories and Images are mapped when present. Importly renames your columns to WooCommerce's field names so the importer recognises them automatically.
Why won't my product CSV import into WooCommerce?
Common causes are mismatched column names, prices with currency symbols or comma decimals, category paths in the wrong format, or unreachable image URLs. Importly normalises all of these before you upload.
Does Importly format prices and categories for WooCommerce?
Yes — it converts prices to plain decimals, standardises weights, and formats category hierarchies the way WooCommerce expects, so variants and categories import correctly.
Stop reformatting exports by hand.
Try Importly free