WooCommerce to Shopify Migration - Products

🥦

Migrate Complete

Shopify Products CSV Format
valid rows

Convert your WooCommerce product catalog to Shopify CSV format. Handles variable products, attributes, and image URLs. No WordPress plugins required.

Free preview, Pay only to download
Your data stays in your browser
Run on Google Cloud Platform

Download Sample WooCommerce Export

Example WooCommerce product export to test the converter

Sample Products

Tool Rating

4.7 / 5 (189 votes)

How It 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

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 automatically restructure and transform your WooCommerce export: - Image Splitting: Comma-separated URLs → separate Shopify image rows - Field Mapping: WooCommerce names → exact Shopify column names - Weight Conversion: Kilograms → grams (multiply by 1000) - Handle Generation: Product names → URL-safe slugs - Price Mapping: Sale price logic → Variant Price + Compare At Price - Categories: WooCommerce hierarchy → Shopify tags - Descriptions: Short + full descriptions merged - Inventory: Stock status → Shopify inventory policies Your Shopify import succeeds with complete product data, images, and pricing.

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

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 This Tool?

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

Want to save on credits?

Buy bundles and get up to 27% off. Check our pricing options below.

// PRICING //

Choose the plan that fits your needs

5,381 reviews, Excellent

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

Visa Mastercard PayPal Apple Pay Google Pay
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle

How are credits calculated?

Credits are based on rows in your file. Each tool shows its rate (e.g., 2,000 rows = 4 credits). We round up to the nearest step. Minimum 1 credit per conversion.

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.

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
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.
Alternative Tools (5)

Other solutions available for WooCommerce → Shopify:

  • Cart2Cart — Fully automated WooCommerce to Shopify migration tool that allows you to migrate your store data—products, customers, or...
  • Amasty — Takes a backup of your WooCommerce store and securely migrates essential data (products, customers, orders, CMS pages, S...
  • Matrixify — Takes data directly from WooCommerce API which means access to more data and less room for error. Matrixify migrates nea...
  • Cart2Cart — Comprehensive migration guide offering WooCommerce to Shopify migration solutions as part of a broader shopping cart mig...
  • Cart2Cart (.net) — Alternative domain for Cart2Cart offering fully automated WooCommerce to Shopify migration with zero downtime and SEO-pr...

Also available as

This platform pair is available in 2 other hubs