My client's WooCommerce store had variable products with comma-separated image URLs crammed into single cells. Shopify needs each image on its own row. The converter split every image correctly and matched them to the right handles. Would have taken me two days to do by hand.
WooCommerce to Shopify Migration - Products
or drop files here .csv, .xls, .xlsx, .xlsm (up to 50 MB)
Free 5-row preview · No sign-up required
Invoice import blocked if Sales Tax enabled in QBO
Migrate Complete
Your converted file is ready!
Download now before closing this page
Shopify Products CSV Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
valid rows
invalid rows skipped from preview
credits
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
Use credits to download
Click any download button to use your credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Want to save on credits?
Buy bundles and get up to 27% off. Perfect for recurring monthly conversions.
Liked the preview?
Upload your actual file to get the real conversion
Convert your WooCommerce product catalog to Shopify CSV format. Handles variable products, attributes, and image URLs. No WordPress plugins required.
Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start
Download Sample WooCommerce Export
Example WooCommerce product export to test the converter
How WooCommerce → Shopify Migration Works
1
Export from Woocommerce
Products → All Products → Export products
2
Upload and Configure
Upload Products Export CSV and choose Product Import format
3
Preview and Download
Review converted data, download Shopify-ready file
4
Import to Shopify
Products → Import
Every row and field is preserved in Shopify Products CSV format — ready to load into the target platform immediately.
How People Use WooCommerce → Shopify
We ran ongoing sales in WooCommerce with separate Regular and Sale price fields. After switching to Shopify everything needed to map to Variant Price and Compare At Price. The tool handled the price logic perfectly — our storefront launched with accurate sale badges from day one.
Category hierarchies in WooCommerce never import cleanly into Shopify. This converter flattened them into tags so we could set up automated collections immediately. Cut our migration timeline from a week to a single afternoon per store.
WooCommerce → Shopify Migration Questions
What WooCommerce export should I use?
Use WooCommerce → Products → Export (or Products → All Products → Export). Make sure to export all fields including images, categories, tags, and attributes.
How are product images handled?
WooCommerce exports images as comma-separated URLs in one cell. We split them into separate Shopify rows with the same Handle, properly numbered by position.
Can I migrate customer data and orders?
This tool migrates products only. WooCommerce customer and order migration typically requires Shopify apps or API-based tools.
Why WooCommerce Products Don't Import Directly to Shopify
The Image and Structure Problem
WooCommerce exports all product images as comma-separated URLs in a single cell.
Shopify requires each image as a separate row with the same Handle identifier.
WooCommerce variable products use a parent-child structure with attributes.
Shopify uses a flatter variant model with Option1/2/3 columns.
Field Name Incompatibilities
WooCommerce uses WordPress conventions (Name, Regular price, Weight (kg)).
Shopify requires exact column names (Title, Variant Price, Variant Grams).
Direct CSV import fails with "missing columns" or imports incomplete product data.
What This Tool Does
We restructure your WooCommerce export:
- Images: Comma URLs → separate Shopify rows
- Fields: WooCommerce → Shopify columns
- Weights: Kilograms → grams (× 1000)
- Handles: Names → URL-safe slugs
- Prices: Sale → Variant + Compare At
- Categories: Hierarchy → Shopify tags
- Descriptions: Short + full merged
- Inventory → Shopify policies
Import succeeds with complete data, images, and pricing.
Secure WooCommerce → Shopify Migration
Nothing Left Behind
Every row and every field preserved. No data dropped during migration.
Runs in Your Browser
All migration logic runs locally. Your data stays on your machine.
GDPR Compliant
Zero data retention. Full EU privacy compliance.
// PRICING //
Choose the plan that fits your needs
Pay as you go
Just start processing on any tool page
$1/credit
Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.
OR
Credit Bundles
$
/Credit
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Monthly Bundles Pro
$
/Credit
Best for professionals and content creators
Annual Discount
Per month, billed annually:
Save 20% more
- Credits refresh monthly
- Priority processing
Purchase Credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Do unused credits expire?
One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.
Is my data secure?
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Can I get a refund?
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Powered by
Paddle
Terms of service applies. VAT included where applicable.
More credits - more savings
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
Field Mapping
How Woocommerce Products fields map to Shopify Products
| Woocommerce Products | Source Value | Shopify Products | Target Value | Note | |
|---|---|---|---|---|---|
Name |
Blue Widget |
→ | Title |
Blue Widget
|
Product name |
SKU |
PROD-001 |
→ | Variant SKU |
PROD-001
|
Stock keeping unit |
Description |
<p>Premium widget with lifetime warranty</p> |
→ | Body (HTML) |
<p>Premium widget with lifetime warranty</p>
|
Full description with HTML |
Short description |
A high-quality blue widget |
→ | Body (HTML) |
A high-quality blue widget
|
Prepended to description |
Regular price |
29.99 |
→ | Variant Price |
29.99
|
Base price or compare at |
Sale price |
24.99 |
→ | Variant Price |
24.99
|
Active sale → variant price |
Weight (kg) |
10.5 |
→ | Variant Grams |
250
|
Convert kg to grams × 1000 |
Stock |
100 |
→ | Variant Inventory Qty |
100
|
Stock quantity |
In stock? |
1 |
→ | Variant Inventory Policy |
deny
|
Stock status → policy |
Categories |
Electronics, Widgets |
→ | Tags |
Electronics, Widgets
|
Category hierarchy → flat tags |
Tags |
featured, bestseller |
→ | Tags |
featured, bestseller
|
Merged with category tags |
Images |
https://example.com/image1.jpg, https://example.com/image2.jpg |
→ | Image Src |
https://example.com/image1.jpg, https://example.com/image2.jpg
|
Split comma-separated → rows |
Published |
1 |
→ | Published |
TRUE
|
Visibility status |
Why Use WooCommerce → Shopify Migration?
Image URL Splitting
Automatically splits comma-separated image URLs into separate Shopify rows with proper positioning.
Variable Product Support
Handles WooCommerce variable products and converts attributes to Shopify options.
Weight Conversion
Converts WooCommerce weights from kilograms to Shopify's required grams format.
URL-Safe Handles
Generates clean, SEO-friendly product handles from names. Auto-numbers duplicates.
Price Mapping
Intelligently maps Sale price → Variant Price and Regular price → Compare At Price.
Category Flattening
Converts WooCommerce category hierarchies (Category > Subcategory) to flat Shopify tags.
Data Transformation
Each WooCommerce product becomes multiple Shopify rows (base + images)
Input
WooCommerce Product
Single row with comma-separated image URLs
Key columns:
Name,
SKU,
Regular price,
Images
1:N — One input row creates multiple output rows
Output
Shopify Product Rows
1 + number of images rows per
input
Main product row + additional image rows
Main Product Row
Complete product data
SPL
Additional Image Rows
Separate row per image
All rows share same Handle
Common Product Import Errors
Issues you might encounter when importing Products Export data to Product Import - and how we solve them
Missing Product Name
Name column is required but empty
Empty Name field
Classic T-Shirt
Ensure all products have names in WooCommerce
Generate names from SKU if missing
Image URL Format
WooCommerce exports images as comma-separated URLs
image1.jpg, image2.jpg, image3.jpg
Separate Shopify rows for each image
Tool automatically splits and creates image rows
Ensure image URLs are publicly accessible
Variable Products
WooCommerce variable products need special handling
Parent row + variation rows
Shopify variant rows with Option columns
Tool groups variations by Parent ID
Review variants in preview before import
Frequently Asked Questions
You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
Use WooCommerce → Products → Export (or Products → All Products → Export). Make sure to export all fields including images, categories, tags, and attributes.
WooCommerce exports images as comma-separated URLs in one cell. We split them into separate Shopify rows with the same Handle, properly numbered by position.
Basic variable products are converted. For complex variations with multiple attributes, you may need to configure some options in Shopify after import.
We generate Shopify handles from WooCommerce product names. WordPress permalinks won't match exactly. Set up 301 redirects in Shopify or use a redirect app for SEO preservation.
WooCommerce categories (including hierarchy with >) and tags are merged into Shopify tags. Create Shopify Collections manually and use tag-based automation rules.
WooCommerce has short and full descriptions. We merge them (short description first) into Shopify's Body (HTML) field with proper spacing.
If a Sale price exists and is lower than Regular price, we set Variant Price = Sale price and Compare At Price = Regular price to show sale pricing in Shopify.
This tool migrates products only. WooCommerce customer and order migration typically requires Shopify apps or API-based tools.
Standard attributes (Size, Color) are mapped to Shopify options. Custom meta fields require Shopify apps or metafield configuration.
Shopify limits products to 3 options. Products with more options need to be merged or use third-party apps and metafields for additional variations.
Woocommerce → Shopify Data Ecosystem
All available data flows from Woocommerce to Shopify
Also available as
This platform pair is available in 1 other hub
Learn More:
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus