Back to blog
10 min read Import Guides

Shopify to WooCommerce: Import Products via CSV

Shopify gives you every product in one CSV file. WooCommerce cannot read it as it is: Shopify writes one row per variant and one row per extra image, so a coffee sold in two sizes takes two rows, and a mug with two photos takes two rows too. Imported row by row, that becomes half-empty products with no variations. Below: Shopify products into WooCommerce from the CSV file, with variations, sale prices, stock, images and categories, then the customers with their addresses.

We tested it with Shopify-format exports of 4 products (8 rows) and 5 customers using Import Export by RockStarLab 2.1.24 with the PRO add-on 2.1.4, WooCommerce 11.2 and WordPress 7.1. Importing WooCommerce products and customers is a PRO feature.

Short Answer

  1. In Shopify, go to Products → Export, choose All products and a CSV format. Shopify emails you the file.
  2. Back up the WordPress site.
  3. In WordPress, open Import Export → Import, choose WooCommerce Products and upload the Shopify file as it is. The plugin recognizes it and combines the rows into products.
  4. Click Auto Map. Every column is matched.
  5. Set Check for Existing Items by Field to SKU, keep Automatically Import Media Files on, and start the import.
  6. Customers: export them in Shopify under Customers → Export and import the file the same way as WooCommerce Customers.

What Is in a Shopify Product Export

Our test file, products_export_1.csv, has Shopify’s current column names (URL handle, SKU, Price, Compare-at price, Inventory quantity and so on) and 8 rows for 4 products:

Rows of a Shopify products_export_1.csv: 8 rows for 4 products, with URL handle, title, option values, SKU, price, compare-at price, inventory quantity, image URL and status
A Shopify product export: one row per variant or extra image, linked by the URL handle.
  • Kenya Nyeri AA: one option (Size) with two variants. The 1 kg bag is on sale: price 54, compare-at price 60. It also has a second image.
  • Ethiopia Yirgacheffe: two options, Size and Grind, three variants.
  • Roastery Mug: no options. Shopify still writes a variant called Default Title. The second row only carries the second photo.
  • Colombia Huila (pre-order): status Draft, 0 in stock.

The rows of one product are linked only by the URL handle column (Handle in older exports). The title, description, tags and SEO fields are filled in on the first row only.

Why a Plain CSV Import Gets It Wrong

A generic CSV importer treats each row as a product. With this file you would get products without a title for every second variant, a separate product for the extra mug photo, simple products instead of variable ones, and the compare-at price lost. The status column also needs translating: Shopify writes Active, Draft or Archived, WordPress expects publish or draft.

The PRO import reads the file the way Shopify meant it. When you upload a Shopify product export, it combines the rows of each product before the preview, so you map and import 4 products, not 8 rows.

Step 1: Export Products from Shopify

In the Shopify admin, open Products and click Export. Choose All products, pick either CSV file type, and click Export products. An export of all products is sent to the store owner’s email; save the attached file, usually called products_export_1.csv.

Do not open and re-save the file in a spreadsheet before importing. Excel can change SKUs that look like numbers and break the encoding of accented characters. If you have to edit it, save it again as CSV UTF-8.

The CSV contains image links, not image files. The images stay on Shopify’s CDN and the import downloads them from there, so keep the Shopify store and its products in place until the import is finished.

Step 2: Back Up WordPress

The import creates products, variations, categories, tags and media files. Make a backup first: UpdraftPlus Backup Now, your host’s backup, or ask an AI agent to run rsl-ie/updraftplus-backup-start. See How to Create a WordPress Website Backup and Restore It.

Step 3: Upload the Shopify File

Go to Import Export → Import, choose WooCommerce Products, and upload the file. Keep the comma delimiter. After the upload the plugin reports what it found:

Upload File step with products_export_1.csv: Shopify product export detected, 8 rows were combined into 4 products with 5 variations
After the upload: 8 Shopify rows combined into 4 products with 5 variations.

The 8 rows became 4 products with 5 variations. The next step, Preview Data, already shows one line per product.

Step 4: Auto Map

On Field Mapping, click Auto Map. The combined file uses the importer’s own field names, so all 25 columns map without any changes:

Field Mapping step after Auto Map: 25 of 25 fields mapped, post_title to Product Title, post_name to Slug, post_status to Status
Auto Map matches every column of the combined file.

Here is where each Shopify column ends up:

Shopify column WooCommerce
Title, Description Product name and description (HTML kept)
URL handle Product slug, so the URL stays /product/kenya-nyeri-aa/
Status (Published on online store in old files without Status) Active → Published; Draft and Archived → Draft
Option1–3 name and value Product attributes used for variations; one variation per variant
SKU, Price SKU and regular price of the variation (or of a simple product)
Compare-at price If it is higher than Price: regular price = compare-at, sale price = Price
Inventory tracker, Inventory quantity Manage stock and stock quantity; no tracker → stock not managed, in stock
Continue selling when out of stock continue → backorders allowed; deny → not allowed
Weight value (grams) Weight, converted to the store’s weight unit
Packed product length, width, height Dimensions, converted to the store’s dimension unit
Charge tax, Requires shipping, Gift card Tax status (taxable or none) and Virtual
Product image URL, Image position Image 1 → product image; the rest → product gallery, in order
Variant image URL Variation image
Type Product category (if Type is empty: the last level of Product category)
Tags Product tags
Vendor Brand
SEO title, SEO description Yoast SEO title and meta description, when Yoast SEO is active

Not imported with products: cost per item, barcodes, unit prices, Google Shopping columns, metafields, collections, inventory per location, orders and reviews. Customers have their own export; see Import Shopify Customers below.

Step 5: Choose Options and Import

On Import Options:

  • Check for Existing Items by Field: SKU. A variable product has no SKU of its own, so the plugin finds it through the SKUs of its variations. Running the same file again then updates the products instead of creating copies. Slug works too.
  • If Match Found: Update. If No Match Found: Create.
  • Automatically Import Media Files: on. This downloads the images from Shopify into the Media Library.
Import Options: Check for Existing Items by Field set to SKU, If Match Found Update, If No Match Found Create, Automatically Import Media Files checked
Match by SKU and keep media import on, so the images are downloaded from Shopify.

Click Start Import. Our 4 products were created in 3 seconds, images included:

Import Completed Successfully: 4 successful, 0 updated, 4 created, 0 skipped, 0 failed, duration 3s
Four products created.

Step 6: Check the Products

In Products, the two coffees with options are variable products with a price range, the mug is a simple product with stock 25, and the pre-order coffee is a draft, out of stock. Categories, tags and the brand came from Type, Tags and Vendor:

WooCommerce Products list: Colombia Huila draft out of stock, Roastery Mug in stock 25, Ethiopia Yirgacheffe 15 to 50, Kenya Nyeri AA 16 to 54, categories Coffee and Merch, brand Example Roastery
The imported products with status, stock, price ranges, categories, tags and brand.

Open a variable product and go to Product data → Variations. Ethiopia Yirgacheffe has the three variants from Shopify, each with its SKU, price, stock and weight. Shopify’s 250 g became 0.551 lbs because this store uses pounds:

Variations of Ethiopia Yirgacheffe: three variations 250 g Whole bean, 250 g Filter, 1 kg Whole bean; first one with SKU ETH-YIR-250-WB, price 15, stock 30, weight 0.551 lbs
Each Shopify variant became a variation with its own SKU, price, stock and weight.

On the product page, Kenya Nyeri AA lists the sizes from Shopify. The 1 kg bag shows 54.00 with 60.00 crossed out, and 12 in stock, as it was on Shopify. The second image from the export is in the gallery:

Kenya Nyeri AA product page with size 1 kg selected: price 54.00, regular price 60.00 crossed out, 12 in stock, SKU KEN-NYE-1000, two gallery images
The compare-at price from Shopify shows as the crossed-out regular price.

Before you switch the domain, compare a few products with Shopify, including one with options, one on sale and one draft.

Import Shopify Customers

Customers are a separate file. In Shopify, open Customers, click Export, choose All customers and a CSV type, and click Export customers. Up to 50 customers download at once; a larger export is emailed. The file has one row per customer with the default address, phone, marketing consent, tags, note and totals.

In WordPress, choose WooCommerce Customers on the first import step and upload the file as it is. Our test file had 5 customers; one of them was a walk-in customer from the point of sale with a phone number but no email:

Upload File step with customers_export.csv: Shopify customer export detected, 5 customers, 1 without an email address
The Shopify customer export is recognized on upload.

Click Auto Map on the mapping step; all 26 columns match. Customers are matched by email, so keep If Match Found: Update. Start the import:

Import Completed with Errors: 4 successful, 1 updated, 3 created, 1 failed with the message A valid customer email is required (rows: 5)
Three customers created, one existing account updated, and the customer without an email reported.
  • 3 created: new WooCommerce customers with the role Customer.
  • 1 updated: Anna already had an account in WordPress with the same email. Her address was updated, and no second account was created. A user with another role, such as an administrator or editor, keeps that role.
  • 1 failed: the customer without an email. WordPress accounts need an email address, so add one in the file or create that customer by hand.
WordPress Users list filtered by Customer: anna.k, james.carter, marta.silva and oliver.bennett with role Customer
The imported customers in Users. Anna's existing account was updated, not duplicated.

The Shopify default address becomes both the billing and the shipping address, with company and phone:

Customer billing address of Marta Silva: company Cafe Lume, Rua das Flores 40, Loja 2, Porto, 4050-262, Portugal
The Shopify default address, now the WooCommerce billing and shipping address.

Data that WooCommerce has no field for is kept with the customer as user meta: shopify_customer_id, shopify_tags, shopify_note, shopify_accepts_email_marketing, shopify_accepts_sms_marketing, shopify_tax_exempt, shopify_total_spent and shopify_total_orders. You can export or filter by them later, for example to find customers who agreed to email marketing before you import them into your newsletter tool.

Passwords cannot be moved: Shopify does not export them. Customers set a new password with Lost your password? on the My Account page. The import does not send any emails, so tell your customers about the move yourself.

Orders are not part of this import. Keep the Shopify order export as your archive.

Importing Again After Changes

A migration rarely happens in one go. If prices or stock change on Shopify while you build the WooCommerce store, export again and import the new file with the same options. We imported the same file a second time: all 4 products were updated, none were created, and the images were reused instead of downloaded again.

Second import of the same file: 4 successful, 4 updated, 0 created, 0 failed
Importing the same file again updates the 4 products instead of creating copies.

Variations follow the Shopify file. A variant that was deleted on Shopify is removed from the WooCommerce product on the next import, and a new variant is added.

Only importing new prices and stock for products that are already in WooCommerce? See How to Update WooCommerce Prices and Stock by SKU from CSV.

Common Mistakes

  • Splitting the export into several files. Keep all rows of a product in the same file and next to each other, as Shopify writes them. If the rows of one product are separated, the upload stops with a message that asks you to sort the file by handle.
  • Re-saving the file in Excel. SKUs like 000123 lose their zeros, and accented letters can break. Upload Shopify’s file without changes.
  • Closing the Shopify store before the import. The images are downloaded from Shopify’s CDN during the import.
  • Matching by title. Two products with the same name would be merged into one. Use SKU or Slug.
  • Forgetting redirects. Shopify product URLs are /products/handle, WooCommerce uses /product/handle. The handle is kept as the slug, so one redirect rule covers all products.

FAQ

Does it work with older Shopify exports?

Yes. Files with the older column names (Handle, Body (HTML), Variant SKU, Variant Price, Image Src) are recognized the same way.

Are the attributes global?

No, each product gets its own attributes (Size, Grind), as in Shopify, where options belong to the product. If you want global attributes for filtering, see How to Import WooCommerce Global Attributes and Terms from CSV.

What happens to the Shopify product category?

Shopify’s Product category comes from its standard taxonomy and is used for US tax rates. The plugin uses your own Type as the WooCommerce category and falls back to the last level of the Shopify category when Type is empty.

Can I import products from a WooCommerce CSV the same way?

Yes, that is the ordinary product import: How to Import WooCommerce Products from CSV or Excel, and for variations How to Import WooCommerce Variable Products from CSV.

Can I import Shopify orders?

Not from the Shopify order export. Products and customers are enough to start selling; keep the Shopify order export for your records and for returns of older orders.

Do I need PRO?

Yes, importing WooCommerce products and customers requires the PRO add-on. Posts and pages import with the free version.

Get the free plugin on 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