Quick Rule Summary · Updated November 2026
When converting WooCommerce exports to Shopify, invert Sale price vs. Regular price (if a sale is active, Sale price → Price and Regular price → Compare-at price; otherwise Regular price → Price) and filter Type = simple rows separately from parent/child variable + variation schemas.
01 / INTERACTIVE PRICE TRANSLATORWhy blind column renaming turns catalog prices blank or $0.00.
WooCommerce stores full retail price in Regular price and leaves Sale price empty unless a discount is active. Shopify works in reverse: Price is always the active checkout price, and Compare-at price holds the higher original price only during a sale. Test any pair of values below:
On-sale inversion applied: WooCommerce Sale price (55.00) becomes Shopify’s active checkout Price, while Regular price (65.00) moves to Compare-at price for strikethrough display.
Spreadsheet formula tip: for clean simple-product rows, set Shopify Price = IF(ISBLANK(Sale_Price), Regular_Price, Sale_Price) and Compare-at price = IF(AND(NOT(ISBLANK(Sale_Price)), Sale_Price < Regular_Price), Regular_Price, "").
02 / ROW-TYPE SAFETY GATEInspect WooCommerce’s Type column before mapping.
Unlike Shopify, a single WooCommerce CSV mixes standalone SKUs, parent variable shells, child variations, bundle collections, and external affiliate buttons via its Type column. Click each row type below to see what transfers cleanly and what must be separated:
Type = simple (1 row = 1 standalone SKU)
Simple WooCommerce rows map cleanly 1-to-1 into Shopify product rows once you resolve Sale price vs. Regular price, Published (1 → active / TRUE), and Weight (lbs → grams).
Type,SKU,Name,Published,Sale price,Regular price,Images
simple,woo-beanie,Beanie,1,18,20,https://example.com/beanie.jpg
Filter your WooCommerce export to Type = simple first, then map columns locally—or inspect our 12-item simple WooCommerce sample in Workspace ↗.
03 / COLUMN-BY-COLUMN REFERENCEWooCommerce native headers vs. Shopify canonical columns.
When exporting from WordPress Admin (Products → All Products → Export), here is how WooCommerce’s core columns align with Shopify’s current canonical CSV headers:
| WooCommerce column | Shopify canonical target | Conversion rule & watchout |
|---|---|---|
Name | Title | Required on every standalone product’s primary row; leave blank on subsequent Shopify variant/gallery rows. |
SKU | SKU (or Variant SKU) | Preserved verbatim as plain text; format spreadsheet column as Text first so leading zeros are never stripped. |
Description / Short description | Description (Body (HTML)) | Shopify has a single HTML product description field; combine or pick Description rather than mapping both to the same header. |
Sale price + Regular price | Price + Compare-at price | If Sale price is present and lower than Regular price, put Sale in Price and Regular in Compare-at price; otherwise put Regular in Price and leave Compare-at blank. |
Published (1, 0, -1) | Status + Published | WooCommerce uses numeric flags (1 published, 0 private, -1 draft); Shopify uses active / draft in Status and TRUE / FALSE in Published. |
In stock? / Stock | Inventory tracker + Inventory quantity | Set Inventory tracker = shopify when migrating numeric stock counts; verify multi-location inventory separately if you run multiple warehouses. |
Weight (lbs) (or kg) | Weight value (grams) | Convert store units to grams (lbs × 453.592, kg × 1000) and set Weight unit for display (lb, kg, g, oz). |
Categories (Clothing > Hoodies) | Type / Tags | WooCommerce exports hierarchical breadcrumbs; turn leaf categories into Type or comma-separated Tags for Automated Collections in Shopify. |
Images (comma-separated URLs) | Product image URL | Split multi-URL cells into one URL per row sharing the same URL handle, and confirm old WordPress /wp-content/uploads/ URLs remain publicly reachable during import. |
04 / STEP-BY-STEP PREFLIGHTClean simple SKUs locally before touching Shopify Admin.
- Export UTF-8 CSV from WooCommerce: In WordPress Admin, open Products → Export. Export
simpleproducts as a clean batch first rather than mixing simple SKUs with complex variable/grouped items. - Resolve Sale vs. Regular prices & strip HTML shortcodes: Apply the fallback price rule above and check
Descriptionfor WordPress[gallery]or page-builder shortcodes (like[vc_row]) that render as raw bracket text on Shopify. - Preflight in Row & Record: Open your CSV in our local browser workspace (or install the Row & Record Chrome Extension ↗) to map headers, catch blank or non-numeric prices (price check guide), and download both a clean Shopify CSV and a source-preserving audit copy.
- Test 3–5 products in Shopify first: Import a small slice into Shopify Admin and verify storefront prices, strikethrough compare-at values, weights, and gallery images before importing your full catalog.
Official WooCommerce sample files included for testing. Inspect 12 simple WooCommerce items or the complex variable/grouped WooCommerce export directly in Row & Record (download raw woocommerce-official.csv, GPL-2.0-or-later).
Common questions.
Can I upload a WooCommerce product CSV directly into Shopify without changing columns?
No. Shopify’s native Product CSV importer expects Shopify headers (such as URL handle, Title, and Price) and a shared-handle row structure. Uploading an unedited WooCommerce export fails header validation or drops Regular price, Published status, and gallery images.
How do WooCommerce Regular price and Sale price map to Shopify?
When an item is on sale, map WooCommerce Sale price to Shopify Price and Regular price to Shopify Compare-at price. When an item is not on sale (Sale price is blank), map Regular price to Shopify Price and leave Compare-at price completely blank—never 0.00.
Why does Row & Record block WooCommerce variable, variation, and grouped rows?
WooCommerce links child variations to a parent variable shell via a Parent SKU column and stores pipe-separated option lists on the parent row, whereas Shopify groups variants by repeating an identical URL handle across consecutive rows with blank Title/Description on child rows. Blocking blind 1-to-1 column renames prevents zero-dollar parent shells and broken variant trees.
Will my WordPress /wp-content/uploads/ product images transfer to Shopify?
Yes, as long as your old WordPress site remains publicly accessible without hotlink blocking while Shopify’s import job downloads and re-hosts each HTTPS image URL onto Shopify’s CDN. Do not take your old WordPress server offline until all product images have finished importing in Shopify Admin.
RELATED CSV TOOLSMore storefront-to-Shopify CSV converters
Ready to preflight your WooCommerce simple-SKU CSV?
Map columns, inspect prices, and export a verified UTF-8 Shopify CSV in your browser—zero uploads.
Verified November 2026 against WooCommerce’s built-in Product CSV Importer/Exporter schema and Shopify’s Product CSV specification.
WooCommerce Product CSV schemaShopify product CSV column referenceRow & Record Chrome Extension ↗