Skip to main content
Updates / Import Products from Shopify to WooCommerce: Easy Steps
← All updates
 
Blog

Import Products from Shopify to WooCommerce: Easy Steps

I’ve migrated Shopify stores to WooCommerce with product catalogs ranging from a handful of items to several thousand SKUs, and manual data entry isn’t an option once you’re past a dozen products. WP All Import solves this by mapping a Shopify export file directly onto WooCommerce’s product fields, either automatically through its Automatic Setup feature or manually with its drag-and-drop interface.

In this article, I cover why store owners leave Shopify for WooCommerce, then walk through both import methods step by step.

Why Migrate From Shopify to WooCommerce

Many store owners cite the same handful of reasons for making the move from Shopify to WooCommerce, and they hold up when comparing the two platforms directly.

  • WooCommerce gives store owners full control over their store’s code, design, and data, since WordPress runs on a self-hosted installation instead of Shopify’s servers.
  • WooCommerce costs less to run long-term. The core plugin is free, and premium extensions start around $29/year, while Shopify’s entry-level plan runs $39/month billed monthly, or $29/month billed annually.
  • WooCommerce charges no transaction fees on top of the payment processor’s rate. Shopify adds a separate transaction fee on top of card processing unless Shopify Payments is used exclusively.
  • WooCommerce provides access to thousands of free and premium plugins through the WordPress ecosystem, on top of anything available in Shopify’s app store.
  • WooCommerce allows direct customization of the checkout process. Shopify restricts checkout customization to its higher-tier plans.
  • WooCommerce works with dedicated SEO plugins like Yoast SEO and RankMath, giving store owners more direct control over technical SEO than Shopify’s built-in tools.

Once the decision to migrate has been made, the real work starts: moving the product catalog without breaking anything.

Best Method to Import Shopify Products to WooCommerce

There are multiple ways available to import Shopify products into WooCommerce. You can use the default WooCommerce importer or use a third-party plugin. 

WooCommerce Native Importer

WooCommerce includes a built-in CSV product importer, accessible from Products > Import. It supports all product types, including variations, and can add or update products in batches.

WooCommerce native product importer

A Shopify migration, however, runs into several specific constraints with it:

  • The importer only accepts CSV or TXT files. Shopify exports in CSV by default, so this isn’t a blocker on its own, but any Excel or XML product file needs converting first.
  • External image URLs import correctly only when they point directly to the image file. URLs behind redirects, including some cloud-storage share links, fail to import.
  • The importer cannot add or update image alt text.
  • Custom field data imports only when the CSV column header uses the exact meta: prefix followed by the field’s internal meta key. There’s no visual mapping interface for arbitrary custom fields. This means that the meta key has to be known and typed correctly.
  • There’s no option to filter which rows import, no scheduling for recurring imports, and no way to pull the file from a URL or FTP server. Every import must start with a manual upload.

These constraints may not matter as much for a one-time import of a small catalog. They, however, add friction on a full store migration involving thousands of SKUs, custom fields, and product images.

This is why you need to choose the right plugin for importing your Shopify products to WooCommerce.

Introducing WP All Import – The Best WooCommerce Import Plugin

WP All Import offers two ways to map a Shopify product export onto WooCommerce fields: Automatic Setup, which generates the field mapping from an uploaded file without manual configuration, and a manual drag-and-drop interface for field-level control.

WP All Import plugin to import WooCommerce product data

WP All Import’s Automatic Setup accepts files uploaded directly, downloaded from a URL, pulled from FTP/SFTP, or reused from a previous import. Most Shopify migrations can run entirely through Automatic Setup, with the manual interface available for imports that need adjustments Automatic Setup doesn’t cover.

Here are some of the key features of WP All Import: 

  • Maps uploaded product files onto WooCommerce fields automatically through Automatic Setup, without manual drag-and-drop configuration
  • Provides a manual drag-and-drop interface for field-level control when Automatic Setup needs adjusting
  • Imports product data from Excel, CSV, XML, JSON, and Google Sheets files
  • Filters which products import using rules like “greater than,” “contains,” or “is not empty” applied to any column in the source file
  • Processes files of any size and any column structure
  • Imports data into custom fields created by any theme or plugin, without requiring a predefined meta key
  • Imports variable products, including parent-child relationships between variations, in the same import as simple products
  • Schedules recurring imports on a daily, weekly, or monthly basis, or pulls files automatically from a URL or FTP/SFTP server
  • Applies PHP functions to modify field data during import, such as reformatting SKUs or converting currency values

How to Export Your Product Data from Shopify Successfully

Before you migrate your products to WooCommerce, you need to export the products from your Shopify store first. 

Here are the steps: 

  • From your Shopify admin, go to Products and click on Export.
  • Choose the products that you want to export from the dialog box. 
  • Select the type of CSV file you want to export. Our recommendation is to choose a CSV file for Excel, Numbers, or another spreadsheet program. 
  • Click Export Products. 

Point to be noted, you should keep your Shopify store live until the migration to WooCommerce is complete. It’s easy to import product images to WooCommerce via image URLs. If you disable your Shopify store before the migration, the Shopify image URLs won’t work. 

How to Import Products from Shopify to WooCommerce

Now that the Shopify export file is ready, the only remaining step is importing it into WooCommerce to complete the migration. This walkthrough uses WP All Import, which maps a Shopify product export onto WooCommerce fields either automatically through its Automatic Setup feature or manually through a drag-and-drop interface.

Install the WP All Import Plugin

Start by purchasing WP All Import Pro with the WooCommerce Import Add-On. The WooCommerce Import Add-On adds support for all standard WooCommerce fields.

After purchase, download the latest version of the plugin from WP All Import’s customer portal.

Once the zip file is downloaded, install the plugin in WordPress. Go to Plugins › Add New, select Upload Plugin, and upload the zip file. Click Install Now, followed by Activate Plugin.

install wp all import

The same steps install the WooCommerce Import Add-On.

Method 1: Automatic Setup

To start an Automatic Setup import, go to All Import › New Import. On the New Import screen, click Set up automatically in the highlighted box at the top.

1. Select Your Import File

Automatic Setup opens on a file selection screen with four source options: uploading a file directly, downloading from a URL, using a file already in the account, or pulling from FTP/SFTP.

wp-all-import-automatic-setup-choose-import-file

WP All Import accepts XML, CSV, JSON, TXT, ZIP, and GZ files up to 256MB through this screen. Shopify delivers the export file as a downloadable CSV file, either directly from the admin or via an email link. Once it’s saved locally, select Upload File and choose it from the computer.

2. Choose What to Import

Once the file loads, WP All Import presents its import categories on the next screen: WooCommerce, Posts & Pages, Taxonomies, Users, and Comments. Selecting WooCommerce expands a second set of options: Products, Orders, Coupons, Customers, and Reviews.

wp-all-import-automatic-setup-woocommerce-product-import-type-selection

Select Products, then click Start Automatic Setup. An optional Add Setup Instructions field is also available for specifying details about the file’s structure before the automatic mapping runs. Add any relevant notes about your file here.

3. Review Your Auto-Mapped Fields

After clicking Start Automatic Setup, WP All Import analyzes the file in real time, displaying a running percentage alongside status messages as it works through the file’s structure. Once analysis finishes, it lands on a “Your Import Is Ready” screen showing how many fields it mapped from the file and how many records will be imported.

wp-all-import-automatic-setup-import-ready-screen

Clicking Field Mappings expands the full breakdown, which splits into Core WordPress Fields like Post Title and Post Content and WooCommerce Import Add-On fields such as Product Type, Product ID, Parent Product ID, Product SKU, and Regular Price.

wp-all-import-automatic-setup-expanded-field-mappings

From this screen, WP All Import offers Manual Setup, which switches to the manual drag-and-drop wizard covered in Method 2, and Run Import, which starts the import using the mapping Automatic Setup generated.

4. Run the Import

Clicking Run Import starts the import immediately. WP All Import displays a progress modal with the option to cancel mid-run.

wp-all-import-automatic-setup-import-in-progress

When the import finishes, WP All Import reports how many records were created, updated, and skipped.

wp-all-import-automatic-setup-import-completed

To confirm the import, go to Products › All Products in the WordPress menu and check the imported product data against the original Shopify export.

Method 2: Manual Drag and Drop Mapping

Manual Setup maps each Shopify field to its corresponding WooCommerce field individually through a drag-and-drop interface, rather than relying on the mapping Automatic Setup generates. This gives full control over field-level matching, which is useful for catalogs with non-standard fields or custom data that Automatic Setup doesn’t map as expected.

1. Create a New Shopify to WooCommerce Product Import

To start the import process, upload the file you exported from your Shopify store to WP All Import. 

In the main WordPress menu, navigate to All Import › New Import. 

You’ll see multiple options to import your WooCommerce product data. Select Upload a file. 

three ways to load data in WP All Import

The other two options are Download a file and Use existing file. With the Download a file option, you can add a file from a URL or an FTP/sFTP server. Point to be noted, you can use this option to add Spreadsheet files from Google Sheets or Dropbox. The Use existing file option lets you use an existing file you previously uploaded to WP All Import. 

Once you have uploaded your Shopify products CSV file, under New Items choose WooCommerce Products as the import type. WP All Import also supports Excel or XML files.

upload Shopify product data to WP All Import

Next, Click Continue to Step 2 to move to the next step. 

2. Review Uploaded Shopify Product Data and Apply Filters

You’ll now see the Review Import File Screen. It will show the number of products you are going to import and display the data in a table. This allows you to check if the data you uploaded is correct. You can navigate between different records using the arrows on both sides. 

This step also allows you to filter the data to modify your import even further. You may not want to import every product from your Shopify store, and this is where WP All Import’s powerful filtering process comes in handy. 

Let’s see how to apply filtering rules. 

Step 1: Select an Import Element

The first step in applying the filter is to select the column based on which you want to filter the products. Let’s take the following example, where I want to import products with valid images. 

apply filter to select specific type of products

Step 2: Add a Filter Rule

The second step is to select the rule you want to apply. You can do this in the Rule selection box. For our example, I’ll select is not empty. This means that I’ll import products where the Image_URL element has data. 

select the filter rule to apply the filters

For most filters, you need to specify a Value. For example, if you want to filter products that cost more than $50, you need to choose greater than in the Rule selection box and put 50 in the Value field. 

For our example, a Value is not needed. 

Click the Add Rule button. 

Step 3: Apply Filters to XPath

The filter you created will then appear in the lower section. Click Apply Filters to XPath to apply the filter. 

Apply filters to xpath

Your filter will then be applied to your import. 

WP All Import allows you to add more than one filter rule. For multiple filter rules, you need to connect them using the logical operators AND(&&) and OR(||). 

The AND(&&) operator filters out the products that satisfy both rules, and the OR(II) operator filters out the elements that satisfy either of the rules. 

Here’s an example where I filtered products with images that cost more than 50. 

apply multiple filters with AND and OR conditions

Click Continue to Step 3 when you are done reviewing your import file and applying your filter rule/s. 

click continue to step 3

3. Map Shopify Product Data to the Corresponding WooCommerce Fields

In the next step, you’ll find the Drag & Drop screen. Here, you can build and configure the import template. WP All Import makes it really easy to map product fields using the drag-and-drop interface. 

WP All Import will list your Shopify product data in a table on the right, while the WooCommerce fields will be listed on the left.

Now let’s look at some different panels to map WooCommerce product information. 

Map Product Title and Description

The Title and Description section is pretty much self-explanatory. Here, we’ll drag and drop the product name, description, and short description element from the right panel to the relevant fields. 

map product title, description and short description

Then comes the most important part of the mapping process. Below the Title and Description section, you’ll find the WooCommerce Add-On section.  

WooCommerce Add-On Section

Expand the WooCommerce Add-On section next. 

This is the section where you need to define the Product Type. It’s set as Simple Product by default, but you can change it to different product types, including grouped, external, and variable products. You can even set your preferred product type with XPath. 

Below Product Type, you’ll find several tabs to configure your import. I’ll describe some of the most frequently used tabs. 

The General Tab is selected by default. It includes general product information such as SKU, sale price, regular price, tax status, and more. 

map WooCommerce add-on panel fields

The Inventory tab includes the settings related to stock availability. 

map inventory tab in the WooCommerce add-on panel

The Attributes tab lets you add different attributes like color, size, shape, etc. 

map attributes tab of the WooCommerce add-on panel

The other tabs let you configure shipping, linked products, and advanced settings. 

If you want to learn how to configure the WooCommerce Add-On for variable products, you should read the documentation on importing variable products to WooCommerce from Shopify.

Map Shopify Images to WooCommerce

The Images panel lets you set up how you want to import the product images. You can import images from multiple sources — images hosted elsewhere, images currently in the Media Library, and images currently uploaded in wp-contents/uploads/wpallimport/files/. 

map product images in the images panel

Among the other sections, Custom Fields is noteworthy. With WP All Import, you can import custom fields data to any theme or plugin, including WooCommerce.

Once you are done mapping all the WooCommerce fields, click Continue to Step 4. 

4. Configure Additional WooCommerce Product Import Setting

At this step, you’ll see the Import Settings screen, which includes some additional settings to optimize your import further. 

To begin with, you’ll need to first set a unique identifier for your import. A unique identifier is usually an element that’s unique for every product. For example, if every product in your Excel file has a unique SKU, then the SKU is a unique identifier. This is important as it allows you to prevent duplicate product entries in your store.

You can click the Auto-detect button to automatically select it or use the drag-and-drop interface to set it manually. 

set the unique identifier for the product import

Below it, you’ll find two more panels – Scheduling Options and Configure Advanced Settings. 

The Scheduling Options panel lets you automatically run your import on a daily, weekly, or monthly basis. 

set scheduling options for product import

In Configure Advanced Settings, you can control how WP All Import splits your file into chunks and processes your import.

configure advanced product import settings

Once you have configured the advanced settings, click Continue to move to the final step. 

5. Import Products From Shopify to WooCommerce

The last step in the Shopify to WooCommerce product import process is the Confirm and Run screen. Here, WP All Import will display a summary of the import settings you are about to run. 

configure advanced product import settings

Click Confirm & Run Import to start the import. When the import is done, WP All Import will show you a summary of the new products that have been created, or if any of the existing products got updated. You’ll also be able to see the number of skipped products in case your import file has any missing information. 

shopify to WooComemrce product import complete

To review if your products were imported properly, go to Products › All Products in the WordPress menu. You should check the product data tab of some products at random to confirm the import. 

There you go! Product migration from Shopify to WooCommerce is complete! Get the WP All Import plugin today to enjoy seamless product migration to WooCommerce and many other features. 

Import Products from Shopify to WooCommerce- FAQs 

Why Migrate From Shopify to WooCommerce?

Store owners migrate from Shopify to WooCommerce for lower long-term platform costs, full control over their store’s code and data, and no added transaction fees on top of their payment processor’s rate. WP All Import supports every WooCommerce product type during the migration, including through its Automatic Setup feature, which builds the field mapping without manual configuration.

How Do I Import a CSV File From Shopify to WooCommerce

To import a CSV file from Shopify to WooCommerce, upload the file to WP All Import and let Automatic Setup generate the field mapping.

  1. Export the product data from Shopify in CSV format.
  2. Go to All Import › New Import and click Set up automatically.
  3. Upload the CSV file, then select WooCommerce > Products.
  4. Review the auto-mapped fields, then click Run Import.

Manual drag-and-drop mapping remains available for imports that need field-level control.

How Do I Add Products to WooCommerce Easily?

To add products to WooCommerce easily, use WooCommerce’s default product screen for a single product, or WP All Import for bulk products.

  1. Go to All Import › New Import and click Set up automatically.
  2. Upload the file, then select WooCommerce > Products.
  3. Review the generated field mapping.
  4. Click Run Import.

How Do I Import Shopify Orders Into WooCommerce?

To import Shopify orders into WooCommerce, export the order data from Shopify and run it through WP All Import. Automatic Setup applies to orders the same way it does to products.

  1. Export the order data from Shopify in CSV format.
  2. Go to All Import › New Import and click Set up automatically.
  3. Upload the file, then select WooCommerce > Orders.
  4. Review the generated field mapping, then click Run Import.

Can I Bulk Upload Products to WooCommerce?

Yes. WP All Import bulk uploads products to WooCommerce through Automatic Setup, which maps the import file to WooCommerce fields without manual configuration.

  1. Go to All Import › New Import and click Set up automatically.
  2. Upload the file containing the bulk product data, then select WooCommerce > Products.
  3. Review the generated field mapping.
  4. Click Run Import.

Get Oxygen

Build it your way with Oxygen.

$199.50 once — unlimited sites, no renewal

Not per year, not per site, not per seat. 60 day money back guarantee.