How to Import Products to WooCommerce: With or Without Plugins (With Video)

store icon

Last updated - June 17, 2020

When online shopping started becoming popular, people tried it because of its convenience, availability, and speed. But for many consumers these days, there’s no need for a reason to hop online and make a purchase; it’s second nature to them. So it’s only logical that you want to start an eCommerce business or take your storefront online as well. And if you’ve already set up a WordPress website and installed the WooCommerce plugin, the hard part is over. Now, all you have to do is import products to WooCommerce and showcase them in front of your customers.

There are two ways you can go about it — either use the built-in product CSV importer in WooCommerce or install a third-party plugin. Both of these options are just as easy and quick to import products to WooCommerce, with the only difference being some added features in the plugin.

But before we get into detail, the first step to importing your products is…

Creating a Product CSV File

A CSV or a comma-separated values file is a delimited text file that uses a comma to separate values. Each line of the file is a data record and each record consists of one or more fields, separated by commas. 

While CSV files help newbies set up shop within minutes, existing store owners can use CSV files to update up to hundreds of products with new info or put them on sale. CSV files are also great for syncing up multiple storefronts.

Here’s how you can create a CSV file containing all of your product information:

If you have an existing online store, you can simply export your entire product catalog as a pre-filled CSV file. The process can slightly vary depending on platforms, but it mostly involves clicking the ‘Export’ button somewhere in your settings or product management page.

If you’re starting from scratch and don’t have your products uploaded anywhere, you can begin by creating an XLSX file using Microsoft Excel. Title the columns based on the product information you want to display.

For example, you’ll need the following columns:

  • Type – Type of product — simple, variable, grouped, or external.
  • SKU – Unique identifying number of the product.
  • Name – Name of the product.
  • Description – Detailed information about the product.
  • Short Description
  • Regular Price
  • Sale Price
  • Category – Which category does the product belong to — clothing appliance, music, etc.
  • Images – URLs of images you want to be displayed for the product.
excel sheet with product information
A typical product CSV file has all product information like type, SKU, name, and price.

Depending on what you need, there may be many more columns in your CSV file. After you’ve filled out your columns, you can save the file in CSV format. But you can speed up this process by downloading our template of the CSV file here.

Guidelines for filling out CSV

While filling out the CSV file, make sure you follow these guidelines:

  1. CSV Files should be in UTF-8 format – While saving the file in CSV format, click on ‘Tools’ and go to ‘Web options’. Here, switch to the ‘Encoding’ tab and select ‘Unicode UFT-8’ from the dropdown.
  2. Dates should be defined in store’s local timezone – You may have to use dates in your CSV file while, for example, specifying the start and end of sales. When entering dates, define them according to the store’s local timezone.
  3. Use 1 or 0 for Boolean values – For example, in the Stock availability column, you’ll type 1 if the product is in stock and 0 if it’s not.
  4. Separate multiple values using commas – If a field has multiple values, separate them using commas. In case the comma is part of the value, you can enclose the value in quotes.
  5. Use URLs for product images – Images cannot be directly uploaded into CSV files. To get around this, you can upload the images to the cloud and paste their links in the fields.

Importing Products to WooCommerce Using Built-in Feature

When your CSV file is ready, follow these steps to import your products to your WooCommerce store:

  1. Go to your WordPress dashboard and click on the ‘Products’ tab.
  2. On the next screen, click on ‘Import’ to get started.
  3. Click on the ‘Choose File’ button and select the CSV file from your system. In the advanced options, you can even enter the path to retrieve products from a CSV file that you have on your server.
  4. Enable the update existing products option if you want to update existing product details with new info, like putting a sale price or changing a tax class. When a product in your CSV file has a similar SKU or product ID, its information is automatically updated.
  5. Below that, you can specify a CSV Delimiter you used to separate items in your CSV file.
  6. The next step is mapping your columns, where WooCommerce automatically attempts to match the column names in your CSV to its existing fields. If you used our template, you should face no issue during this step. You can use the drop-down menus on the right side to adjust fields or tell WooCommerce not to import a field entirely.
  7. Finally, run the importer and wait for the import to be finished.
white box with text on it showing product importer user interface
The built-in WooCommerce importer can be found in the ‘Products’ tab.

Importing Products Using Plugin: Product Import Export for WooCommerce

While the built-in importer works just fine, you can use the Product Import Export for WooCommerce plugin if you want a little more flexibility.

After installing the plugin, it will appear under your WooCommerce tab as Product Import-Export. Click it and switch over to Product Import to start the process.

From here on, the process is quite similar to using the built-in WooCommerce importer.

Select a CSV file from your computer. choose a delimiter. map your columns. and click on import. The Product Import Export plugin also comes with a premium version that boasts features like importing from an FTP server, support for all types of products, and scheduled imports.

white boxes with text showing Product Import Export for WooCommerce plugin
The Product Import Export for WooCommerce plugin makes things very easy.

Importing Products Using Plugin: WooCommerce Add-on for WP All Import

WP All Import is the ultimate WordPress data import and export solution. This plugin supports various file formats, file sizes, and file structures. Moreover, it is even compatible with custom plugin and theme fields.

And WP All Import’s WooCommerce add-on gives eCommerce store owners like you granular control over your data. Here’s how you use it:

  1. After installing it, an ‘All Import’ tab is created in your WordPress dashboard.
  2. On the next page, you’ll see that while the plugin supports the standard file input methods like uploading a file or choosing one via FTP, it offers a third option, downloading from an URL.
  3. Using this option along with the import scheduling feature, you can update your products by simply making changes to your CSV file.
  4. Next, click on the drop-down, select WooCommerce products and click Continue. The plugin will automatically detect your products.
  5. On the following page, you can effectively design the front end of your product pages using drag-and-drop functionality.

    white boxes with text showing WP All Import's drag and drop feature
    WP All Import lets you design your front end using a drag-and-drop feature.
  6. Below that, you’ll find an exact replica of WooCommerce’s built-in product adding page, so you’ll be able to add products in no time.
  7. As a cherry on top, WP All Import supports custom fields, categories, and many more options. You can access even more advanced features like in-depth image upload and management options in WP All Import’s premium plans.

Importing Products to WooCommerce Using Extension: Product CSV Import Suite

Our last solution to your product import needs comes from WooCommerce itself. The Product CSV Import Suite is a WooCommerce extension designed for advanced shop owners. This paid extension lets you create, upload, or update thousands of products at once, including complex products.

text on white background showing Product CSV Import Suite's features
With various plugin compatibilities, the Product CSV Import Suite opens up a lot of opportunities.

With out-of-the-box compatibility with other WooCommerce plugins like WooCommerce Bookings, Product Vendors, WooCommerce Brands, WooCommerce Subscriptions, WooCommerce photography, WooCommerce Composite Products, and Google Product Feed, you have the tools to sell any product or service you want, the way you want it.

Whether you use the built-in feature or one of the plugins, your products will be imported within a few minutes and ready to be displayed in your online store. Leave a comment if you have any doubts and we’ll be happy to make sure running your online business is a smooth sailing experience.

Check out the video below:

Further reading

2 COMMENTS

  1. Hi Sagar,

    For some reason, images are not getting uploaded using the default WooCommerce product importer in case of external links. I’m not using any plugin.
    Woocommerce – 5.5.1
    WordPress – 4.5.2
    Php – 7.4

    How to upload images along using CSV file.

LEAVE A REPLY