How to Import Export WooCommerce Products with Excel (Step-by-Step Guide)

Imagine you own a physical store with thousands of products. Every time you want to add a new item, update a price, change or add a new description, you would have to walk around all the store to edit everything by your hand, sounds exhausting, right?

The same thing happens when you try to manage WooCommerce products manually or through CSV files, it’s complicated, takes a lot of time and effort, and results in a lot of errors.

This is why the WooCommerce Products Import & Export with Excel plugin is here! Now you can manage everything with simple Excel sheets, without the need to deal with any CSV files or do any manual editing. Easily import, export, update products prices, descriptions, and schedule automated tasks with just a few clicks.

Step5:

➡ Delete Products

This option allows the possibility of deleting products in bulk via an Excel file.

1. Download the sample Excel file

First, download the sample file, this file usually contains key columns such as Product ID or SKU 

2. Filling out the file 

Here, enter the products you want to delete in the file (via product ID or SKU).

3. Upload the file 

Then, upload the file using the form under the same option, the system will read the file and delete the specified products.

Step6:

➡Import Terms

This option allows you to import categories or attribute values for products in WooCommerce via an Excel file.

So, you can upload a file containing a list of product categories to be directly added to the store. Instead of entering the categories manually, you upload the file, and all of them will be added at once.

The file can typically contain:

• Category Name

• Description

• Parent Category

• Category Image

The PRODUCT CATEGORIES SAMPLE WITH IMAGE file is an example of a ready file that shows you how the data should be written.

• Select Taxonomy

This is an option from which you can choose the type of Taxonomy you want to upload the data to:

• Product Categories

• Product Tags

• Attributes

All you have to do is download the sample file, upload the attributes and categories you want for the file, and then re-upload it.

Step7:

➡Delete Terms

This option allows the possibility of deleting terms in bulk via an Excel file.

First, download the sample file. Enter the terms/ attributes you want to delete in the file, then upload the file using the form under the same option, the system will read the file and delete the specified terms.

Step8:

➡System

From here, you can control the general settings of the plugin.

• Main

You can specify who can use the plugin based on their role:

• Editor

• Author

• Customer

• Subscriber

• Import / Export Custom Fields

This option activates or deactivates the handling of custom fields during import/export. If you encounter an issue (Like slowness or conflicts with other plugins), you can deactivate it.

• Manually add custom field

If you have a specific custom field name (like brand, material, custom_sku), you can manually write them separated by commas.

• Img/Gallery ACF – custom fields

This is intended for using ACF (Advanced Custom Fields) to add images or a gallery. You can write the names of the fields for the images or gallery, separated by commas.

• Alternative Export Method

An additional option is to use an alternative export method if the regular method causes issues (like a timeout or data loss). I usually use different queries or split the data into smaller batches.

• Enable Import Log File

If you enable this option, a record will be generated for each import operation.

• Separator for multiple values import

If you have a dedicated field with multiple values (for example, multiple colors: red, blue, green), you need to specify the separator between the values. It is usually:

1. Comma

2. Slash |

Example: red, blue, green OR red|blue|green

• Products Import Template

The product import template simply means the template/structure that the system will follow when you import products from an Excel file.

You can specify the columns along with the appropriate fields from here.

The Products Import Template saves time and prevents errors. Instead of redefining the columns every time, you use the pre-made template.

• Product Import Schedule

From here, you can schedule the products you want to import, which means they will be imported automatically at the scheduled time.

• Index Products

From here, you can choose the option to index your products, meaning to re-read the product data from the database.

Update the index to include all products along with their details (SKU, downloadable, virtual…).

Result:

• Faster search

• Import/export becomes more accurate

• Fewer errors.

Final Thoughts 

Managing and editing every single product, its price, and description manually is exhausting, and imagine doing this for thousands of products. I think it’s pure madness.

This is why the “WooCommerce Products Import & Export with Excel” plugin is an amazing tool. With this tool, you have the ability to manage your store efficiently, which saves your time, effort and helps you to reduce errors.

This tool allows you to import, export, update products, manage attributes & categories, and schedule importing tasks in just a few clicks!

Whether you are managing two products or thousands, this tool makes managing your store much easier.

You may be interested in:

How to Edit Your Prices in Bulk in WooCommerce? How to Add Multiple Currencies in WooCommerce? How to Generate Custom Product XML Feeds in WooCommerce