Back to blog
3 min read Product Updates

Import from Shopify: What’s New in Import Export by RockStarLab 2.1.24

Import Export by RockStarLab 2.1.24 and the PRO add-on 2.1.4 add an import for stores that are moving from Shopify to WooCommerce. You export products and customers in Shopify, upload the files in WordPress without changing them, and the plugin turns them into WooCommerce products and customers.

Shopify products, as Shopify exports them

A Shopify product export has one row per variant and one row per extra image. A coffee sold in two sizes takes two rows, and only the first row has the title and description. When you upload that file as WooCommerce Products, the plugin recognizes it and combines the rows of each product before the preview:

Upload File step: Shopify product export detected, 8 rows were combined into 4 products with 5 variations
The upload step shows what was found in the Shopify file.
  • Products with options become variable products. Each Shopify variant becomes a variation with its own SKU, price, stock and weight.
  • A compare-at price becomes the regular price, and the Shopify price becomes the sale price, so the product shows as on sale.
  • The first image becomes the product image, and the others go to the gallery in Shopify’s order. Variant images are kept.
  • Status sets Published or Draft, the URL handle becomes the slug, Type becomes the category, Tags become product tags and Vendor becomes the brand.
  • Weight and packed dimensions are converted to your store’s units. SEO title and description go to Yoast SEO when it is active.

Auto Map then matches every column. Importing the same file again updates the products instead of creating copies, so you can import once more after prices or stock change on Shopify. Both the current Shopify column names and the older ones are supported.

Shopify customers

The Shopify customer export works the same way: choose WooCommerce Customers and upload the file.

Upload File step: Shopify customer export detected, 5 customers, 1 without an email address
Customers without an email address are counted on upload.
  • Each customer becomes a WooCommerce customer. The default address is used as the billing and the shipping address.
  • A customer whose email already exists in WordPress is updated, not duplicated. Administrators and editors keep their roles.
  • The Shopify customer ID, tags, note, marketing consent, tax exemption and order totals are kept with the customer, so you can filter by them later.
  • Customers without an email address are listed as failed rows, because a WordPress account needs an email.

What is not imported

Orders, collections, metafields, inventory per location and reviews are not part of this import. Passwords cannot be moved, because Shopify does not export them; customers set a new one with “Lost your password?”. The import sends no emails, so you decide when to tell customers about the move.

Importing WooCommerce products and customers requires the PRO add-on.

Also in this release

  • Status columns with values such as TRUE, FALSE, active or archived now import as a WordPress status (Published or Draft). Values WordPress does not know are ignored, so the default status is used.
  • Auto Map maps a “Status” column to Status and “Type” to Product Type.
  • WooCommerce products can be matched by Slug, and matching by SKU also finds a variable product through the SKUs of its variations.
  • The customer import follows “If Match Found: Skip” and “If No Match Found: Skip”.

Try it

The step-by-step guide with a test store, screenshots and every column mapping: Shopify to WooCommerce: Import Products via CSV.

Update Import Export by RockStarLab from Plugins in WordPress or download it from WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE