Convert your WooCommerce product export CSV into a Shopify-compatible product CSV in seconds. Upload the file, review the column mapping, and download a ready-to-import file that preserves your titles, descriptions, prices, images, inventory, and categories.
Migrating from WooCommerce to Shopify is one of the most common platform switches in ecommerce. According to BuiltWith data, thousands of stores make this transition each month, driven by Shopify’s simpler management, better uptime, and lower maintenance overhead. But the two platforms use completely different CSV formats. WooCommerce exports columns like “Regular price” and “Categories” while Shopify expects “Variant Price” and “Product Type.” Manually remapping hundreds or thousands of rows in a spreadsheet is slow, error-prone, and risks losing data.
Everything happens in your browser. Your product data is never uploaded to any server. Simply export your WooCommerce products as CSV from WordPress, upload the file here, verify the mapping preview, and download a perfectly formatted Shopify CSV. The entire process takes under a minute regardless of catalog size.
This converter handles the most critical column transformations automatically: product names to titles, regular and sale prices to Shopify’s dual-price system, WooCommerce categories to Shopify product types and tags, image URLs, SKUs, stock quantities, and weight conversions. It produces a clean CSV that you can import directly into Shopify or run through our CSV Validator for an additional quality check.
The financial savings are significant. Third-party migration services charge $50 to $500+ depending on catalog size, and migration apps typically cost $30-80 for a one-time use. By converting the CSV yourself with this free tool, you maintain full control over the process, can inspect every mapped field, and re-run the conversion as many times as needed until the result is perfect.
| WooCommerce to Shopify Migration: Key Facts | |
|---|---|
| WooCommerce Column: Name | Maps to Shopify: Title |
| WooCommerce Column: Description | Maps to Shopify: Body (HTML) |
| WooCommerce Column: Regular price | Maps to Shopify: Variant Price (or Compare At Price if sale exists) |
| WooCommerce Column: Sale price | Maps to Shopify: Variant Price (when active sale) |
| WooCommerce Column: Categories | Maps to Shopify: Product Type + Tags |
| WooCommerce Column: Images | Maps to Shopify: Image Src (first image) |
| WooCommerce Column: Weight | Maps to Shopify: Variant Grams (kg to grams) |
| Handle Generation | Auto-generated from product name (slugified) |
| Processing | 100% browser-based, no data uploaded |
Export from WooCommerce: Products → All Products → Export. Select CSV format.
How This Tool Works
The converter reads your WooCommerce CSV file using the browser’s FileReader API and parses every row and column. It then applies a mapping that translates WooCommerce column names to their Shopify equivalents. For example, “Name” becomes “Title,” “Description” becomes “Body (HTML),” “Regular price” becomes “Variant Price,” and “Images” becomes “Image Src.”
Categories from WooCommerce are split and mapped to both the Product Type field (using the first category) and the Tags field (using all categories). Sale prices are mapped to Shopify’s “Variant Compare At Price” field, which creates the strikethrough pricing effect on your product pages. Weight is converted to grams for Shopify’s Variant Grams field.
After conversion, the tool shows a preview table of the first several products so you can verify the mapping looks correct. It also reports any rows that had missing or problematic data. Click Download to save the converted CSV, then import it into Shopify through the Products section of your admin dashboard.
Step-by-Step Migration Guide: WooCommerce to Shopify
- Export your WooCommerce products. In your WordPress admin, go to Products > All Products, click the “Export” button at the top. Select all columns and all products. Choose CSV format and click “Generate CSV.” Save the downloaded file.
- Back up your WooCommerce site. Before making any changes, create a full backup of your WordPress site including the database. This ensures you can restore everything if needed during the migration process.
- Upload the CSV to this converter. Click the file upload button above and select the WooCommerce export CSV. The file is processed entirely in your browser. No product data leaves your computer.
- Review the conversion preview. The tool displays the first 20 converted products in a table. Verify that titles, prices, SKUs, and product types look correct. Check that sale prices are mapped correctly (WooCommerce regular price should appear as Shopify’s Compare At Price when a sale price exists).
- Download the Shopify CSV. Click the download button to save the converted file. The output is a standard Shopify product CSV with 17 columns that is ready for import.
- Validate the converted CSV (recommended). Run the downloaded file through our CSV Validator to catch any edge cases like missing prices, invalid image URLs, or handle duplicates.
- Import into Shopify. In your Shopify admin, go to Products > Import. Upload the CSV file. Shopify will show a preview of products to be created. Review the preview and click “Import products” to proceed.
- Verify products after import. Spot-check at least 10-20 products in your Shopify admin. Verify titles, descriptions, prices, images, and variants are correct. Pay special attention to products that had sale prices and those with multiple variations.
- Set up redirects. Use our Redirect Generator to create 301 redirects from your old WooCommerce URLs to the new Shopify URLs. This preserves your SEO rankings and prevents broken links.
- Keep WooCommerce live until images download. Shopify downloads images from the URLs in your CSV during import. Keep your WordPress site running until the import is fully complete, otherwise images will fail to download.
Why This Matters for Your Shopify Store
A clean migration preserves your SEO value, product relationships, and pricing structure. Errors during migration can result in products with missing descriptions, incorrect prices, or lost inventory counts. Fixing these issues after import is far more time-consuming than getting the CSV right in the first place.
This tool also saves you from purchasing expensive migration apps or hiring a developer. Third-party migration services charge anywhere from $50 to $500+ depending on catalog size. By converting the CSV yourself with accurate column mapping, you maintain full control over the process and can re-run the conversion as many times as needed until the result is perfect.
The SEO implications of a poor migration are particularly costly. If your product URLs change during migration and you do not set up 301 redirects, you lose all the search engine authority those pages have accumulated. For a store with established organic traffic, this can mean months of lost revenue while Google re-indexes your new URLs. A proper migration workflow (convert, validate, import, redirect) protects this investment.
Real-World Migration Examples
Example 1: Fashion Boutique (800 products, 3,200 variants)
A fashion store migrating from WooCommerce to Shopify had products with color and size variations:
| WooCommerce Field | Original Value | Shopify Field | Converted Value |
|---|---|---|---|
| Name | Floral Summer Dress | Title | Floral Summer Dress |
| Regular price | 89.99 | Variant Compare At Price | 89.99 |
| Sale price | 64.99 | Variant Price | 64.99 |
| Categories | Dresses > Summer > Floral | Product Type / Tags | Dresses / Dresses, Summer, Floral |
| Weight (kg) | 0.35 | Variant Grams | 350 |
| Images | https://oldsite.com/img1.jpg, img2.jpg | Image Src | https://oldsite.com/img1.jpg |
Key learning: The store’s WooCommerce sale prices were correctly mapped to Shopify’s pricing model where the sale price becomes the Variant Price and the regular price becomes Compare At Price. This preserved the “was $89.99, now $64.99” display.
Example 2: Electronics Store (2,500 products, simple products)
An electronics retailer with mostly simple (non-variant) products had clean data but needed careful handling of descriptions:
| Challenge | WooCommerce Source | Solution After Conversion |
|---|---|---|
| Shortcodes in descriptions | [product_specs id=”123″] | Manually replaced with actual HTML specs after import |
| No sale prices (regular pricing only) | Regular price: 299.99, Sale price: (empty) | Correctly mapped to Variant Price: 299.99, Compare At: (empty) |
| Multiple images per product | 5 image URLs per product | First image used as Image Src; remaining added manually post-import |
Example 3: Supplement Store (450 products with custom attributes)
A health supplement store had custom WooCommerce fields that needed special attention:
| Custom Field | WooCommerce | Shopify Equivalent | Post-Migration Action |
|---|---|---|---|
| Serving Size | Custom attribute | No direct column | Added as Shopify metafield |
| Nutrition Facts | Custom tab content | No direct column | Appended to product description HTML |
| FDA Disclaimer | Custom field | No direct column | Added via Shopify theme section |
Custom WooCommerce fields do not have Shopify column equivalents and require post-migration work. Plan for this when estimating migration timelines.
WooCommerce to Shopify Converter vs. Other Migration Methods
| Method | Cost | Products Handled | Custom Fields | Variants | Privacy |
|---|---|---|---|---|---|
| This Tool | Free | Unlimited | Standard fields only | Basic mapping | 100% browser-based |
| Cart2Cart | $69-299+ | Plan-based limits | Partial | Full | Data on their servers |
| LitExtension | $79-199+ | Plan-based limits | Partial | Full | Data on their servers |
| Matrixify (Excelify) | $20/mo+ | Unlimited | Full (manual mapping) | Full | Shopify app |
| Hired Developer | $200-2,000+ | Unlimited | Full | Full | Varies |
| Manual Spreadsheet Rework | Free (your time) | Unlimited | Full | Error-prone | Local |
This tool is ideal for stores with standard product data (titles, descriptions, prices, images, categories) that do not rely heavily on custom WooCommerce plugins or complex variable products with dozens of attributes. For stores with extensive custom fields, consider using this tool for the base conversion and handling custom data as a separate post-migration step.
Common Mistakes to Avoid During Migration
- Taking the old site offline before import completes. Shopify downloads product images from the URLs in your CSV during import. If you deactivate your WordPress site before images finish downloading, products will import without images. Keep your WooCommerce site running for at least 48 hours after import.
- Forgetting to set up 301 redirects. WooCommerce and Shopify use different URL structures. Without redirects, all your Google rankings, backlinks, and bookmarked URLs break. Use our Redirect Generator to create a redirect CSV mapping old WooCommerce URLs to new Shopify URLs.
- Not checking sale price logic. WooCommerce stores “Regular price” and “Sale price” separately. In Shopify, the current selling price is “Variant Price” and the original price is “Compare At Price.” If both prices are the same, or if the mapping is inverted, your sale formatting will be wrong.
- Ignoring WooCommerce shortcodes in descriptions. WooCommerce plugins often inject shortcodes like [gallery], [product_specs], or [tabs] into product descriptions. These render as plain text in Shopify since they are WordPress-specific. Scan your converted descriptions for square brackets and replace shortcode content with actual HTML.
- Not exporting all columns from WooCommerce. When exporting from WooCommerce, make sure you select “All” for the column filter. A partial export will produce a CSV missing important fields like weight, stock, or categories, resulting in an incomplete Shopify import.
- Skipping the validation step. Even after conversion, the CSV may have edge cases like empty prices (from WooCommerce products with no price set), unusually long descriptions, or duplicate slugs. Run the converted file through our CSV Validator before importing.
- Not planning for WooCommerce-specific features. Features like product bundles, subscription products, bookings, and custom product types built with WooCommerce plugins do not have direct Shopify equivalents. Plan how you will handle these products on Shopify before migrating, not after.
When to Use This Tool
| Scenario | Catalog Size | Recommended Approach |
|---|---|---|
| Full platform migration | Any size | Convert all products, validate, import, set up redirects |
| Partial migration (testing Shopify) | 10-50 products | Convert a subset, import to dev store, evaluate Shopify |
| Running both platforms simultaneously | Any size | Convert full catalog, keep WooCommerce as backup |
| Client migration (agency work) | Varies | Convert, validate, present converted preview to client |
| WooCommerce backup in Shopify format | Any size | Convert and store Shopify-format CSV as backup |
Tips and Best Practices
- Export all product data from WooCommerce. Before converting, go to WooCommerce Products, click Export, and make sure all columns are selected. The more data in the source file, the more complete your Shopify import will be.
- Check your images after import. WooCommerce image URLs point to your WordPress media library. Make sure your WordPress site stays live until Shopify has finished downloading all images during the import process. Alternatively, re-upload images to a CDN and update the URLs.
- Review categories and tags. WooCommerce uses a nested category hierarchy (e.g., Clothing > Men > T-Shirts) while Shopify uses flat collections and tags. After import, you may need to set up Shopify collections based on the tags that were created from your WooCommerce categories.
- Handle variable products carefully. WooCommerce variations map to Shopify variants. Verify that option names (Size, Color) and their values transferred correctly, especially if you used custom attribute names in WooCommerce.
- Do a test import first. Import the converted CSV into a Shopify development store or use a small subset of products to verify everything looks correct before importing your entire catalog into your live store.
- Plan your collection structure before importing. Shopify uses collections instead of WooCommerce categories. Map out which WooCommerce categories will become Shopify collections, and set up automated collection rules based on the tags this converter creates from your category data.
- Update your SEO metadata post-migration. WooCommerce SEO plugins (like Yoast or Rank Math) store SEO titles and meta descriptions in custom fields that do not transfer directly. After import, manually set SEO titles and descriptions for your top-traffic pages in Shopify.
Related Tools
- CSV Validator – Validate the converted Shopify CSV before importing to catch edge cases and formatting issues.
- Product CSV Generator – Build new Shopify product CSVs from scratch for products not included in your WooCommerce export.
- Redirect Generator – Create 301 redirect CSVs to map old WooCommerce URLs to new Shopify URLs, preserving SEO value.
Our Shopify Apps
Rubik Variant Images Rubik Combined ListingsSmart Bulk Image Upload Export Product Images Bulk Delete Products
What WooCommerce columns are mapped to Shopify?
The converter maps these columns: Name to Title, Description to Body (HTML), Regular price to Variant Price, Sale price to Variant Compare At Price, SKU to Variant SKU, Categories to Product Type and Tags, Images to Image Src, Stock to Variant Inventory Qty, and Weight to Variant Grams. The Handle is generated from the product name.
Does this tool upload my data to a server?
No. The entire conversion happens in your browser using JavaScript. Your CSV file is read locally and never leaves your computer. No data is transmitted to any external server. You can verify this by disconnecting from the internet and running the conversion, it will still work.
Can I convert variable products with multiple variations?
Yes. The converter detects WooCommerce variation rows and maps them to Shopify’s multi-row variant format. The parent product row contains the title, description, and other product-level data, while child variation rows contain variant-specific prices, SKUs, and option values.
What if my WooCommerce export has custom columns?
Custom columns that do not match standard WooCommerce fields will be ignored during conversion. If you have critical data in custom fields, you will need to manually add those as Shopify metafields after import. The preview table helps you verify which data was successfully mapped.
How do I export products from WooCommerce?
In your WordPress admin, go to Products, click the Export button at the top. Select “All” for columns and products, choose CSV as the format, and click Generate CSV. The downloaded file is what you upload to this converter.
Will my product descriptions transfer correctly?
Yes. WooCommerce descriptions are stored as HTML, and Shopify’s Body (HTML) column accepts HTML directly. Your formatting, links, and embedded media references will transfer. However, shortcodes used by WooCommerce plugins will appear as plain text in Shopify since they are WordPress-specific.
What happens to my sale prices?
WooCommerce sale prices are mapped to Shopify’s Compare At Price field. In Shopify, the Compare At Price is the original (higher) price shown with a strikethrough, and the Variant Price is the current selling price. The converter places your regular price in Compare At Price and your sale price in Variant Price when a sale price exists.
Can I convert a very large product catalog?
The converter processes files entirely in the browser, so performance depends on your computer’s memory. Files with up to 10,000 rows convert almost instantly on modern hardware. For very large catalogs (50,000+ rows), consider splitting the WooCommerce export into smaller batches and converting each one separately.
Do I need to install anything to use this tool?
No. This tool runs entirely in your web browser with no plugins, extensions, or downloads required. It works on any modern browser including Chrome, Firefox, Safari, and Edge on both desktop and mobile devices.
What should I do after importing into Shopify?
After importing, review several products in your Shopify admin to verify titles, descriptions, prices, and images look correct. Set up your collections based on product types and tags. Check that variant options display properly on product pages. Finally, verify inventory counts match your actual stock levels.
How do WooCommerce categories translate to Shopify?
WooCommerce uses hierarchical categories (e.g., Clothing > Men > T-Shirts). Shopify does not have hierarchical categories. Instead, this converter takes the first (top-level) category and maps it to Shopify’s Product Type field, and maps all categories as comma-separated Tags. You can then create Shopify automated collections based on these tags to replicate your category structure.
What about customer data, orders, and reviews?
This tool converts product data only. Customer accounts, order history, and product reviews are separate data types that require different migration methods. Shopify has a Customer CSV import feature, and several apps specialize in migrating orders and reviews. Consider using a dedicated migration service for complete store migration.
Will my WooCommerce coupons transfer?
No. Coupon/discount codes are not part of the product CSV and need to be recreated manually in Shopify’s Discounts section. Record your active WooCommerce coupons before migration and recreate them in Shopify with the same codes and rules.
How do I handle WooCommerce product images with multiple gallery images?
WooCommerce exports multiple image URLs in a single cell, separated by commas. This converter uses the first image as the primary Image Src in Shopify. Additional gallery images need to be added as separate rows in the CSV (same handle, different Image Src) or uploaded manually through the Shopify admin after import.
Can I migrate from WooCommerce to Shopify without any downtime?
Yes. The recommended approach is to set up your Shopify store on a development or trial plan, import all products, configure your theme and settings, then switch your domain DNS when everything is ready. The actual DNS switch takes minutes. Keep your WooCommerce store live throughout the setup process to avoid any customer-facing downtime.