Advance Import and Export for WooCommerce DocumentationAdvance Import and Export for WooCommerce Documentation
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start
    • Features
    • Installation
    • First-Time Setup
    • CSV Preparation
    • Sample Files
    • Use Cases
    • Common Mistakes
  • Tutorials

    • Google Sheets Live Sync
    • Shopify Migration
    • Daily Backup to S3
    • Multi-Store Sync
  • Using the Plugin

    • Dashboard
    • Quick Import Wizard
    • Quick Export
    • Settings
    • Compatibility
  • Import In Detail

    • Import Sources
    • Import Modes
    • Column Mapping
    • Transformations
    • Migration Presets
    • Delta Import
  • Export In Detail

    • Export Features
    • Export Destinations
    • Browser Download
    • Server Path (REST / CLI)
  • Data Types

    • Products
    • Variable Products
    • Orders
    • Customers
    • Categories & Tags
    • Coupons
    • Reviews
    • Posts
    • Pages
    • Users
    • Subscriptions
    • Bookings
    • Memberships
    • Menus
  • Automation

    • Scheduled Jobs
    • History & Logs
    • Rollback
    • Health Check
  • Cloud Service Setup

    • Google API Setup
    • Amazon S3 Setup
    • Dropbox Setup
    • Email / SMTP Setup
  • Server Configuration

    • PHP Configuration
    • Server Cron Setup
    • Image Handling
  • Developer

    • REST API
    • WP-CLI Commands
  • Compare

    • vs WP All Import
    • vs Product Import Export (WebToffee)
  • Help

    • Troubleshooting
    • FAQ
    • Glossary
    • Security
    • Changelog
Support
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start
    • Features
    • Installation
    • First-Time Setup
    • CSV Preparation
    • Sample Files
    • Use Cases
    • Common Mistakes
  • Tutorials

    • Google Sheets Live Sync
    • Shopify Migration
    • Daily Backup to S3
    • Multi-Store Sync
  • Using the Plugin

    • Dashboard
    • Quick Import Wizard
    • Quick Export
    • Settings
    • Compatibility
  • Import In Detail

    • Import Sources
    • Import Modes
    • Column Mapping
    • Transformations
    • Migration Presets
    • Delta Import
  • Export In Detail

    • Export Features
    • Export Destinations
    • Browser Download
    • Server Path (REST / CLI)
  • Data Types

    • Products
    • Variable Products
    • Orders
    • Customers
    • Categories & Tags
    • Coupons
    • Reviews
    • Posts
    • Pages
    • Users
    • Subscriptions
    • Bookings
    • Memberships
    • Menus
  • Automation

    • Scheduled Jobs
    • History & Logs
    • Rollback
    • Health Check
  • Cloud Service Setup

    • Google API Setup
    • Amazon S3 Setup
    • Dropbox Setup
    • Email / SMTP Setup
  • Server Configuration

    • PHP Configuration
    • Server Cron Setup
    • Image Handling
  • Developer

    • REST API
    • WP-CLI Commands
  • Compare

    • vs WP All Import
    • vs Product Import Export (WebToffee)
  • Help

    • Troubleshooting
    • FAQ
    • Glossary
    • Security
    • Changelog
Support
  • Getting Started

    • Introduction
    • Quick Start — Your First Import in 5 Minutes
    • Features — Full Tour
    • Installation — Full Setup Guide
    • First-Time Setup — Complete Checklist
    • CSV Preparation — How to Make a Good Import File
    • Sample Files — Download Ready-to-Use Templates
    • Use Cases — "I Want To..." Quick Reference
    • Common Mistakes — Things To Watch Out For
  • Tutorials

    • Tutorial — Google Sheets Live Sync
    • Tutorial — Migrate from Shopify to WooCommerce
    • Tutorial — Daily Backup to Amazon S3
    • Tutorial — Sync Between Two WooCommerce Stores
  • Using the Plugin

    • Dashboard — What You See First
    • Quick Import Wizard — 5 Steps to Import Any File
    • Quick Export — One-Page Export Tool
    • Settings — Every Option Explained
    • Compatibility — Third-Party Plugin Support
  • Import In Detail

    • Import Sources — 11 Ways to Pull Data In
    • Import Modes — Create, Update, Delete, Replace
    • Column Mapping — Connect Your Columns to WooCommerce
    • Transformations — Change Values During Import
    • Migration Presets — Move From Shopify, Magento, BigCommerce
    • Delta Import — Skip Unchanged Rows
  • Export In Detail

    • Export Features
    • Export Destinations — Where Your Files Go
    • Export Download — One-Click Browser Download
    • Export to Server Path — WP-CLI
  • Data Types

    • Products Import — Full Field Reference
    • Variable Products — The Complete Guide
    • Orders Import — Historical Orders and Line Items
    • Customers Import — With Addresses and Notes
    • Categories and Tags Import
    • Coupons Import — Discount Codes
    • Reviews Import — Product Reviews and Ratings
    • Posts Import — WordPress Blog Posts
    • Pages Import — WordPress Pages
    • Users Import — WordPress User Accounts
    • Subscriptions Import — WooCommerce Subscriptions
    • Bookings Import — WooCommerce Bookings
    • Memberships Import — WooCommerce Memberships
    • Menus Import — WordPress Navigation Menus
  • Automation

    • Jobs — Saved and Scheduled Imports and Exports
    • History — Every Run You Have Ever Done
    • Rollback — Undo Any Import in One Click
    • Health Check — Data Integrity Checks With Auto-Fix
  • Cloud Service Setup

    • Google API Setup — Sheets, Drive, OAuth
    • Amazon S3 Setup — IAM User and Bucket Permissions
    • Dropbox Setup — API Token for Private Files
    • Email Setup — Making Notifications Actually Work
  • Server Configuration

    • PHP Configuration — Memory, Execution Time, Upload Size
    • Server Cron Setup — Reliable Scheduled Imports
    • Image Handling — Download, Resize, Watermark
  • Developer

    • REST API — Developer Reference
    • WP-CLI Commands — Command Line Automation
  • Compare

    • Advance Import and Export vs WP All Import
    • Advance Import and Export vs Product Import Export for WooCommerce
  • Help

    • Troubleshooting — Fix Common Problems
    • FAQ — Common Questions
    • Glossary — Every Term Explained
    • Security — How Your Data Is Protected
    • Changelog — What Changed

Tutorial — Shopify to WooCommerce Migration

This tutorial walks you through migrating a complete Shopify store to WooCommerce. Products, customers, orders, images — everything.

Migration Timeline

Most small stores (under 1,000 products) migrate in 2-4 hours. Medium stores (10,000 products): half a day. Large stores (100,000+ products): full day with image download.

What Moves

WhatWorks
Products (simple, variable, etc.)Yes
Product imagesYes (downloaded to WC Media Library)
Categories (Shopify "collections")Yes (become WC categories)
CustomersYes (with billing/shipping addresses)
OrdersYes (historical orders preserved)
Coupons (Shopify "discount codes")Yes
Reviews (with the Shopify Reviews app)Yes
Blog postsYes
PagesYes

What Does NOT Move

WhatWhy
Theme / designShopify themes do not work in WooCommerce. Pick a WC theme
Apps / featuresFind WordPress equivalents
URLs (if you changed domains)Set up 301 redirects separately
Payment processor setupConfigure WC payments separately
Shipping rulesSet up in WooCommerce

Part 1 — Set Up WooCommerce

Before migrating, install WordPress and WooCommerce.

Step 1

If you don't have WordPress yet, install it on your host. Most hosts offer one-click install.

Step 2

Install WooCommerce:

  1. WordPress admin → Plugins → Add New
  2. Search for WooCommerce
  3. Install and Activate
  4. Run the WooCommerce setup wizard

Step 3

Install this import plugin:

  1. Plugins → Add New → Upload Plugin
  2. Upload advance-import-and-export-for-woocommerce.zip
  3. Activate

Part 2 — Export from Shopify

Export Products

  1. Shopify admin → Products → All Products
  2. Click Export (top-right)
  3. Pick All products → CSV
  4. Download products_export.csv

Export Customers

  1. Shopify admin → Customers
  2. Click Export
  3. Pick All customers
  4. Download customers_export.csv

Export Orders

  1. Shopify admin → Orders
  2. Click Export
  3. Pick a date range (Shopify limits to 1 year at a time for large stores)
  4. Download orders_export.csv

Export Images

Shopify does not export images directly. Images stay on Shopify's CDN. You have two options:

  • Option A — Keep URLs: Link to Shopify CDN URLs. Risk: if Shopify site goes down, images break
  • Option B — Download: Use a tool like ShopifyFD or a custom script

For this tutorial, we use Option A (faster). The plugin will download images to WooCommerce later.

Part 3 — Import Customers First

Always customers first. Then orders can link to them.

Quick Import wizard Step 1Step 1 of the Quick Import wizard — pick entity, mode, file format, source, and migration preset in one screen.

Step 1

Quick Import Wizard.

Step 2 — Step 1 of Wizard

FieldValue
Entity TypeCustomers
Import ModeCreate + Update
File FormatCSV
Source TypeFile Upload
Uploadcustomers_export.csv

Click Next.

Step 3 — Column Mapping

Shopify columns should auto-map to WooCommerce fields. Verify:

ShopifyWooCommerce
Emailemail
First Namefirst_name
Last Namelast_name
Companybilling_company
Address1billing_address_1
Address2billing_address_2
Citybilling_city
Provincebilling_state
Countrybilling_country
Zipbilling_postcode
Phonebilling_phone

Any unmapped columns (like "Accepts Marketing") can be stored as custom meta or ignored.

Click Next.

Step 4 — Password Handling

Shopify does not export customer passwords (security). Plugin will auto-generate.

In Step 3 of the wizard:

  • Password Mode: Auto-generate
  • Send Welcome Email: Yes

Each customer will get a welcome email with a password reset link.

Step 5 — Import

Click Start Import. Watch Step 4 progress.

Typical speed: 1,000 customers per minute.

Part 4 — Import Products

Step 1

Quick Import Wizard → Entity Type: Products.

Step 2 — Use Shopify Preset

On Step 1, find the Migration Preset dropdown.

Migration preset dropdownMigration preset dropdown — Shopify, Magento 1/2, BigCommerce, PrestaShop, OpenCart, Amazon, eBay, Google Shopping, and WooCommerce export are all ready to go.

Pick Shopify.

This auto-configures column mapping for Shopify's CSV format.

Step 3

Upload products_export.csv. Click Next.

Step 4 — Column Mapping

With the Shopify preset, this is mostly auto-done:

ShopifyWooCommerce
HandleSlug
TitleName
Body (HTML)Description
VendorBrand (if brands plugin active)
TypeProduct type
TagsTags
PublishedStatus
Option1 NameAttribute 1 name
Option1 ValueAttribute 1 values
Variant SKUSKU
Variant GramsWeight (converted to kg automatically)
Variant PriceRegular price
Variant Compare At PriceRegular price (if price becomes sale price)
Image SrcFeatured + gallery images

Step 5 — Variable Products

Shopify stores variants as separate rows with the same Handle. The plugin automatically groups them into variable products.

You should NOT have to do anything special. It just works.

Step 6 — Preview

Step 3 shows a summary. Verify:

  • Row count matches expected
  • Variable products: correct count
  • Variations: correct count
  • Simple products: correct count

Step 7 — Start Import

Click Start Import. This is the big one.

For 1,000 products with images: 10-30 minutes. For 10,000 products with images: 2-4 hours.

Step 5 Import ResultsStep 5 shows the final Import Results — created, updated, skipped, failed counts, plus Save as Job and Rollback buttons.

Part 5 — Import Orders

Step 1

Quick Import Wizard → Entity Type: Orders.

Step 2 — Preset

Pick Shopify preset (auto-configures mapping).

Step 3

Upload orders_export.csv. Click Next.

Step 4 — Column Mapping

Verify key mappings:

ShopifyWooCommerce
Name (order number)Order Number
EmailCustomer Email
Financial StatusOrder Status (needs mapping)
Fulfillment Status(custom meta)
TotalTotal
SubtotalSubtotal
ShippingShipping Total
TaxesTax Total
Discount AmountDiscount Total

Step 5 — Status Mapping

Shopify uses paid, pending, refunded. WooCommerce uses processing, completed, cancelled, refunded, etc.

In Step 2 → Transformations → Order Status column:

ShopifyWooCommerce
paidcompleted
pendingon-hold
refundedrefunded
voidedcancelled
authorizedprocessing

Step 6 — Line Items

Shopify exports line items as a specific format. The preset handles this.

Each order row has:

  • Lineitem sku
  • Lineitem quantity
  • Lineitem price
  • Lineitem name

Plugin combines these into the order's line items.

Step 7 — Import

Start Import. Watch progress.

Orders with many line items take longer (each item creates a database row).

Part 6 — Import Categories (Collections)

Shopify "collections" become WooCommerce categories.

Step 1

Export collections from Shopify (some apps needed, or use Products CSV's "Product Category" column).

Step 2

Quick Import → Entity: Categories → Upload.

Categories auto-create from Products already. This step is optional.

Part 7 — Import Coupons

Shopify calls these "discount codes."

Step 1

Shopify admin → Discounts → Export. Download CSV.

Step 2

Quick Import → Entity: Coupons → Upload.

Map Shopify's fields:

ShopifyWooCommerce
CodeCode
TitleDescription
ValueAmount
Value TypeDiscount Type
Starts At(custom meta)
Ends Atdate_expires

Part 8 — Post-Migration Checks

Step 1 — Run Health Check

Webkul WC Addons → Health Check → Run Health Check.

Review the 23 checks. Fix any issues with auto-fix.

Step 2 — Spot Check Products

Pick 10 random products. Verify:

  • Name, description, price correct
  • Images display
  • Categories assigned
  • Stock correct
  • Variations work

Step 3 — Spot Check Orders

Pick 5 random orders. Verify:

  • Order total matches Shopify
  • Customer linked
  • Line items with correct quantities
  • Status shown correctly

Step 4 — Spot Check Customers

Pick 10 random customers. Verify:

  • Email exists
  • Billing/shipping addresses filled
  • Login works (use "Forgot Password" to reset)

Step 5 — Test Checkout

Place a test order:

  1. Add product to cart
  2. Checkout
  3. Use test payment method (or Cash on Delivery)
  4. Verify order shows in WooCommerce admin

Part 9 — Set Up 301 Redirects

Shopify URLs look like /products/widget-name.

WooCommerce URLs look like /product/widget-name.

Set up redirects so customers' old bookmarks work.

Use a plugin like Redirection.

Or add to .htaccess:

RewriteRule ^products/(.*)$ /product/$1 [R=301,L]
RewriteRule ^collections/(.*)$ /product-category/$1 [R=301,L]

Part 10 — Go Live

Pre-Launch Checklist

  • [ ] All products imported
  • [ ] All customers imported
  • [ ] All orders imported (or at least last 1-2 years)
  • [ ] Coupons imported
  • [ ] Health Check passes
  • [ ] Test checkout works
  • [ ] Email notifications work
  • [ ] Payment gateway configured
  • [ ] Shipping configured
  • [ ] Tax configured
  • [ ] 301 redirects set up
  • [ ] Theme customized
  • [ ] SEO plugin configured (Yoast, RankMath)

Switch DNS

Once you are confident, switch your domain DNS to point to the WooCommerce server.

Customers land on the new site. Old URLs redirect. Nothing breaks.

Troubleshooting

ProblemFix
Variable products did not groupHandle column missing. Re-export from Shopify with all columns
Images brokenURLs did not download. Check Settings → Image & Media → Download Images
Customer count mismatchesShopify export may have filters. Re-export
Order statuses look wrongRun the status mapping transformation (Part 5, Step 5)
Prices off by a factor of 100Shopify cents vs dollars. Divide by 100 in transformation
Tax did not importConfigure WC tax first, then re-import orders

Related Pages

  • Migration Presets — Other platforms
  • Products Import — Products deep dive
  • Orders Import — Orders deep dive
  • Customers Import — Customers deep dive
  • Health Check — Verify integrity
Prev
Tutorial — Google Sheets Live Sync
Next
Tutorial — Daily Backup to Amazon S3