How to Migrate Shopify to WooCommerce

How to Migrate Shopify to WooCommerce

The WooCommerce plugin for WordPress has become one of the most popular ways to run an eCommerce business, and as a result many merchants are moving to WooCommerce from other platforms. In this guide, we go over the best options for moving your online store from Shopify to WooCommerce.

When migrating from Shopify to WooCommerce, you can either export and import your products manually or use a third-party plugin. With a manual migration, you export all your products from Shopify, prepare them in a spreadsheet that WooCommerce can read, and then import them all at once. Migrating orders and customers follows a similar process.

In this guide:

Step 1: Export products from Shopify

If you export up to one page of products (up to 50 products), the CSV file is downloaded by your browser. If you export more than one page (51 or more products), the CSV file is emailed to the store owner's email address.

Steps:

  1. From your Shopify admin, go to Products > All products.
  2. Click Export.
  3. In the dialog box, choose which products you want to export:
    • The current page of products
    • All products
    • Products you have selected
    • Products that match your search and filters
  4. Select which type of CSV file you want to export:
    • CSV for Excel, Numbers, or other spreadsheet programs: use this format if you plan to edit your product CSV in a spreadsheet program.
    • Plain CSV file: use this format if you plan to use a plain-text editor with your product CSV.
  5. Click Export products.

Access your product image files

Product images are not included in the exported CSV file. When you import the products into a new store, the images are only fetched if they are still viewable on a publicly accessible website.

Important: Keep your Shopify store and its product listings live until you have finished importing into WooCommerce. If you close the store or delete products first, your new store won't be able to pull in the product images.

Filter and export your products list

You can use filters to narrow down your products list before exporting. If you only need to move or change some of your products, a shorter CSV is much easier to work with than your entire catalog.

  1. On the Products page in Shopify, add a filter with conditions that list only the products you need.
  2. Export your products list, making sure you select the option to export only the products that match your filter.
  3. A CSV file containing only the filtered products is exported.

Step 2: Import products into WooCommerce

Now that you have your store data, the next step is getting it into your WooCommerce store. WooCommerce has a built-in CSV importer for products, which is useful but has some limits. Shopify's CSV columns don't match WooCommerce's, so for every import you'll need to map each field yourself (for example, the product title and the SKU).

To import a CSV file, go to WooCommerce > Products and click Import. Choose your CSV file, confirm the field mapping, then run the importer.

The WooCommerce product CSV importer with the column mapping screen

Alternative: use WP All Import

If you'd rather not map every field by hand for each import, WP All Import is an excellent paid WordPress plugin that can import products, orders and customers. It works with two add-ons: the WooCommerce Add-On imports products and orders, and the User Import Add-On imports customers. You'll need to purchase and install WP All Import before following these steps.

WP All Import also lets you use templates, which save your field mapping so you don't have to repeat it. You can download a ready-made product import template (TXT file) that maps all the product fields for a Shopify product import.

  1. Open the plugin and go to All Import > Settings.
  2. In the Import/Export Templates section, select the template TXT file and import it. Once it has imported correctly, the template appears in the list.

    WP All Import settings page showing the imported product template

  3. Go to All Import > New Import. Select your Shopify product CSV file, choose New Items, and select WooCommerce Products as the type.

    WP All Import New Import screen with WooCommerce Products selected

  4. Confirm the number of rows to be imported, then continue to Step 3.

    WP All Import confirming the number of rows to import

  5. Continue through the import. All products exported from your Shopify store are imported into WooCommerce.

During the import, the product images from your Shopify store are downloaded into your WordPress media library and attached to the right products, so each product arrives with its correct data and featured image.

Customers and orders can also be exported from Shopify as CSV files. Customers can be imported with WP All Import Pro and the User Import Add-On, and orders with WP All Import Pro and the WooCommerce Add-On.

Ready-made migration tools

If you'd prefer an out-of-the-box solution, these tools can migrate your store from Shopify to WooCommerce:

Step 3: Export Shopify orders to a CSV file

You can export a CSV spreadsheet of your orders from the Orders page of your Shopify admin. You can export orders together with their transaction histories, or export only the transaction histories. Transaction histories include captured payment data only; authorization data is not included.

Steps:

  1. Sort and filter your orders.
  2. From the Orders page, click Export.
  3. In the Export orders window, select which orders you want to export. For example, to export orders by date, click Export orders by date and set the start and end dates.
  4. Choose the file format for your export.
  5. Click Export orders to download all of your order information, or Export transaction histories to download only the transaction information.

What happens next depends on the size of your export:

  • If you export up to one full page of orders (up to 50 orders), the CSV file is downloaded by your browser.
  • If you export more than one page (51 or more orders), the CSV file is emailed to you and to the store owner.
  • If the export fails, you'll receive an email letting you know.

Step 4: Import orders into WooCommerce

To import your Shopify orders into WooCommerce, follow the instructions in the Customer/Order/Coupon CSV Import Suite documentation. Alternatively, use WP All Import Pro with the WooCommerce Add-On as described above.

Step 5: Export customers from Shopify

Steps:

  1. From your Shopify admin, go to Customers.
  2. Click Export.
  3. Choose one of the following export options:
    • Current page to export the customers shown on the current page of your admin
    • All customers to export every customer in your store
    • Selected customers to export only the customers you have selected
    • Current search to export a filtered list of customers
  4. Select a file format:
    • CSV for Excel, Numbers, or other spreadsheet programs if you plan to open the file in a spreadsheet program
    • Plain CSV file if you plan to use a plain-text editor
  5. Click Export customers.

Step 6: Import customers into WooCommerce

To import your customer CSV into WooCommerce, follow the instructions in the Customer/Order/Coupon CSV Import Suite documentation, or use WP All Import Pro with the User Import Add-On.

Tip: Customer passwords can't be exported from Shopify, so your customers will need to reset their passwords the first time they log in to your new WooCommerce store. It's a good idea to email them about this after the move.