Rating 0 stars - 0 votes

WooCommerce Product Import: Step by Step Tutorial

WooCommerce product import is indispensable for creating and updating store catalog. That's why it's so important to find a good import tool. The tool simple in daily usage and robust enough to solve your tasks. One of such tools is Store Manager for WooCommerce. Let's see how it works by performing a typical task - creating products via import.

Store Manager is a downloadable application that enhances the default WooCommerce functionality. It offers tools for bulk edits, advanced import/export, database backup, data generation, and others.

If you don’t have Store Manager yet, download a free trial and install it on your computer. Connect the application to your store database and enjoy the simplicity of your store administration.

How to Prepare a File for WooCommerce Product Import

The Store Manager Import Products tool is very flexible when it comes to the file structure and doesn't have strict requirements.

To create new products via import, you would want to include more fields to most fully present the products in the catalog. These are title, description, category, image, price, SKU, stock, product type, visibility, brand, etc. Though if needed, you can create products with minimum fields in the file and add more details later. Here is a file we're going to import. Store Manager allows importing external images, so we entered image URLs in the file. Also, pay attention that you should input the full category path:

WooCommerce Store Manager Import Products File

For the update of existing products, your import file may contain just an identification field (SKU or ID) and the fields that have to be updated (for example, price or stock).

Steps of WooCommerce Product Import

To launch WooCommerce Import Wizard, navigate to Store Manager > Catalog > Products and click the Import button:

WooCommerce Store Manager Import Products Launch Wizard

Determine the settings on each step suggested by the wizard.

Step 1. Select file source

Store Manager lets you import data from a file stored locally and externally.

To upload an external file, specify an HTTP URL or connect to an FTP server (fill in server address, login, password). If you want to import data from a Google Sheet, connect to Google Drive and select the document.

To upload a file stored locally, just select it on your computer:

File Source Selection for WooCommerce Products Import
File Source Selection for WooCommerce Products Import

Step 2. Specify the delimiters used in your import file.

Data in CSV file is detached by delimiters, usually, it's a comma or semicolon. In this step, you should state the delimiters that are used in your case. If you specified correct delimiters, the data in the preview will look as a table. If you specified incorrect delimiters, data will be messed up. Note, that if you open a CSV file for editing in a spreadsheet editor and then save the file as CSV, the delimiters can change. So you should check the delimiters opening the file in a Notepad or another plain text editor.

WooCommerce Product Import File Delimiters
WooCommerce Product Import File Delimiters

Step 3. Map Fields

Also in this step, you have to link columns from your import file to the correct database fields. The window has two sections: the left section shows product database fields and the right section shows your file columns. To map fields, select a database field on the left and click a corresponding column from your file on the right. You can also use automapping by clicking the Auto Link All button.

Field Links Step During WooCommerce Product Import
Field Links Step During WooCommerce Product Import

Step 4. Configure Product Import Options

In this step, you should first select the import method:

  • Add and Modify - create new and update existing products.
  • Add Only - don't update existing products, only create new products.
  • Modify Only - only update existing products, don't create new products.
  • Just Add - don't check if the imported products exist and import products from the file as new.

WooCommerce Product Import Options
WooCommerce Product Import Options

Expand advanced options to see more settings:

  • Multiple values separator - if some column in your import file contains several values, they should be detached by a separator. This very separator should be specified in the field.

  • Begin import from row/End import at row - you might need to import the file partially, you may indicate initial and end row. Products listed in these rows will be imported only, the others will be ignored.

  • Category path delimiter - indicate what separator will be used to detach categories in the category path.

  • Path to image folder - uploading product pictures, you are obliged to specify a path to the folder they are stored in at your computer.

  • In up-/cross-sells column I have - mind this field when you want to link up-sell or cross-sell products in course of WooCommerce import

  • Advanced Settings at WooCommerce Product Import Options Step
    Advanced Settings at WooCommerce Product Import Options Step

Preview data and confirm the procedure by pressing the "Import" button in the wizard. After the import has been completed, you will get import logs showing you the changes that have been implemented. Now you may close the wizard and check the products. Here is how they look in Store Manager:

WooCommerce Store Manager Import Products View Grid

If you had connected Store Manager to your store database directly, the changes will be reflected in your store admin and therefore at the frontend automatically.

If you connected Store Manager to your store via the bridge connector, you need to post the changes to your store:

WooCommerce Store Manager Import Products Publish

Now you can check the imported products will appear in your store admin:

WooCommerce Store Manager Import Products Published

That's what the import of products with Store Manager for WooCommerce import wizard looks like. Write in the comments below if you have any specific task to solve via import and we'll try to help you.

Use Store Manager for WooCommerce Product Import

Try FREE Now
Related Articles:
Card image
WooCommerce Excel Import Tutorial

Follow the tutorial to import WooCommerce products from Excel.

Card image
WooCommerce CSV Product Import

A detailed instruction on how to import WooCommerce products from CSV. Read More...

Card image
Tutorial on WooCommerce Variable Products Import

Learn how to import WooCommerce variable products instead of adding variations manually. Read More...

Card image
Fix WooCommerce Import Error “Sorry, this file type is not permitted”

How to fix WooCommerce import error “Sorry, this file type is not permitted for security reasons”.Read More...

Be the first to comment.
Be the first to comment.