Migration guide
Import WooCommerce Products to Shopify
WooCommerce and Shopify both speak CSV, but their columns don't match. Export your products from WordPress, rename and reshape the columns using the mapping below, then import the file into Shopify.
1. Export your products from WooCommerce
- In WordPress, go to Products → All Products and click Export.
- Choose all columns and all product types, and tick Export custom meta if you use it.
- Click Generate CSV and save the file.
2. Map WooCommerce columns to Shopify
Shopify's importer only reads its own column names. Copy each WooCommerce column into the matching column of the Shopify product CSV template.
| WooCommerce column | Shopify column | Note |
|---|---|---|
Name | Title | |
(product slug) | Handle | Keep the WooCommerce slug so redirects are simple |
Description + Short description | Body (HTML) | |
Type = variable / variation | Rows with the same Handle | One row per variation |
SKU | Variant SKU | |
Regular price | Variant Price | Or Variant Compare At Price when there's a sale price |
Sale price | Variant Price | When set, move Regular price to Compare At |
Stock | Variant Inventory Qty | |
Weight (kg) | Variant Grams | Multiply by 1,000 |
Attribute 1 name / value(s) | Option1 Name / Option1 Value | |
Images (comma-separated) | Image Src | One row per image |
Tags | Tags | |
Categories | Tags or Product Category | Then build collections from tags |
Published (1 / 0) | Status (active / draft) |
3. Import the file into Shopify
- Copy your data into Shopify's product CSV template, using the mapping table.
- Give each variation its own row with the parent's Handle, and fill in the Option columns.
- Check the file with a CSV checker, then go to Products → Import in Shopify admin.
- Preview, import, and spot-check a few products with variants.
- Add 301 redirects from /product/{slug}/ to /products/{handle} before you switch your domain.
4. Common WooCommerce migration problems
- WooCommerce lists variations as separate products with a Parent column. Shopify needs them as rows that share the parent's Handle.
- Shopify allows 3 options per product. If you use more attributes, merge some together or add them as tags.
- Image URLs must still be reachable when Shopify imports them, so keep the old site online until the import is done.
- WooCommerce product URLs (/product/…/) change to /products/… on Shopify, so redirect every old URL to keep your rankings.
FAQ
WooCommerce to Shopify: FAQ
Still stuck? Email contact@ecomfusion.net.
Can 1Click import WooCommerce products directly?
No. 1Click imports from Amazon, AliExpress, eBay and Shopify stores you manage. To move a WooCommerce catalog, use Shopify's CSV import with the mapping on this page.
Is there a free way to move WooCommerce products to Shopify?
Yes. WooCommerce's built-in exporter and Shopify's CSV import are both free. The work is reshaping the columns, which the mapping table helps with.
How do I keep my SEO when moving from WooCommerce to Shopify?
Keep the same product slugs as Shopify handles, copy SEO titles and descriptions into the SEO columns, and create a 301 redirect from each old URL to its new one.
Does this work for WordPress stores?
Yes. If your WordPress site sells products, it almost certainly uses WooCommerce, and these steps apply.
Other migrations
Keep adding products after you move
1Click imports from Amazon, AliExpress, eBay and your other Shopify stores, with AI rewriting. Free for 3 imports.