Marketing

Top Ways: How to Export WooCommerce Products

Let’s begin this with a question.

What if you wake up one day and lose all your online store data?

No customers, no orders, no products, nothing. Scary!!!

Thinking about it for a second frightened you. So it would be devastating if this happens for real. Thus, you need to make sure even if you lose your data, you have a backup to restore things again.

Well, there are plenty of things in a WooCommerce store that can be backed up. Explaining each one of them would be tranquilizing and off-topic.

So in this post, I’ll explain how you can export(as well as import) your WooCommerce products only. Why do you need to export them? How to do it (manually and through plugins), and more.

You can use the table of contents section below to jump to your favorite point.

Why Export Your WooCommerce Products?

Here are some scenarios where you need to export your WooCommerce products:

  • Migrating website to a new domain and host: If you’re looking to migrate your WordPress website to a new platform, exporting your WooCommerce products will be helpful. Exporting them will act as a backup which you will be able to restore on your new website by uploading them there.
  • Send product data to someone: Sometimes it happens that you need to send your product data with every detail to someone. Exporting your WooCommerce products comes handy in such cases. You can export the data in a CSV file and send it to the recipient so they can check all the details about your products.
  • Creating backup while updating your website: Another case where you need to export WooCommerce products. While updating your website, you can’t predict everything will go well. And the last thing you want is to lose any of your data. So to make sure you don’t lose your product data, you must export it as a backup.

Those were not the only cases. Many necessities occur where you need to export your WooCommerce product data. I can’t explain each one here. But the things are clear, I guess.

So jump to the next point that is…

How To Export WooCommerce Products?

Enough clearing basics. Let’s discuss what you clicked on this post for. There are two different ways you can export your WooCommerce product data. Either manually through the default process, or by using a plugin.

I’ll talk about both of them in this post. So let’s begin with the arduous method first.

The Manual Way

The manual method is obviously where you do not get any dedicated tool to execute this task. You export the products straight from your default WooCommerce system.

And here are the steps you need to follow to do this:

  • Login to your WordPress Dashboard.
  • Click on Products in the left panel.

woocommerce products

  • On top, click on the Export button.

export woocommerce products

  • Once you click Export, you will see a form asking if you need to export some specific product values only. Here are these questions to be precise:
    • Which columns should be exported: If your products contain multiple attributes, they will be separated into multiple columns. For example, your products have only 4 attributes that are ID, SKU, Price, and Category. When you export the data, the .csv file will contain 4 columns representing ID, SKU, Price, and Category of each product.
    • Which product types should be exported: Through this field, you can select what type of products you want to export. For example, if you want to export only simple and downloadable products, you can select them and generate your CSV file.
    • Which product category should be exported: This is obvious. If you want to export products that belong to some specific categories, you can select them and export.
    • Export custom meta: Enabling this checkbox will display any custom meta like custom fields (if you have created any) in your .csv file.
  • Choose accordingly and click on Generate CSV and a .csv file containing all the data of your WooCommerce products will be downloaded.

So that was how you can export your WooCommerce product data without any tool. Exhausting? Not really. But this is a method you all must know about. If you don’t have a plugin or don’t want to use one, this method will act as a saviour.

But this method may not intrigue some of you. Some would like a smoother way to perform the same job with fewer efforts. Well, don’t worry then. The next solution covers exactly the same.

The Automated Way

Here comes the easier method. In this method, you require a plugin that will help you perform the same task in lesser clicks.

Let’s dive deeper into it to know how you can export WooCommerce products with a plugin.

But here’s a caveat.

There are multiple plugins available that let you do that. Each one has different steps and I can’t tell you all of them. But one of the most reliable and popular plugins to export WooCommerce products is “Product CSV Import Suite”. It’s reliable because it is developed by WooCommerce itself. You got my point.

But remember, this is a paid plugin. However, there are many free alternatives available. I’ve talked about them in this post in Top Plugins To Export WooCommerce Products section.

So let’s talk about how you can export your WooCommerce products using the Product CSV Import Suite plugin.

Here are the steps you need to follow to do this:

  • Login to your WordPress Dashboard.
  • Navigate to WooCommerce > CSV Import Suite from the left panel.
  • Select the Export Products tab from the top.

export products with plugin

  • On the Export Products tab, you will see multiple fields. Let me explain them:
    • Limit: In this field, you can specify how many products you want to export. For example, if you want to export a list of only 500 products, enter 500 in this field.
    • Offset: Through this field, you can specify how many products you want to skip before exporting. For example, if you have 1000 products but want to export the last 200 products data only, enter 800 in this field.
    • Columns: Through this field, you can select the columns you want to export in your .csv file.
    • Include hidden meta data: This is similar to Export Custom Meta I told you about in the manual method.
  • Once done with entering values in the field, click on the Export Products button.

export products paid plugin

  • Once you click on the Export Products button, a .csv file containing all your WooCommerce products data will be exported.

Apart from exporting products only, this plugin also allows you to export product variations.

export product variation

This helps you in cases where you sell products that come in different shapes, sizes, or prices. For example, footwear. There could be a pair of sneakers in your online store that comes in multiple sizes and colors.

Exporting variations will also export all the product variations in your .csv file.


Phew. Too much explanation. I hope you have understood how to export WooCommerce products with and without a plugin. But we should see the flip side too, shouldn’t we? And this thought brings me to explain the importing process too.

How To Import WooCommerce Products

If I’ve talked this much about exporting data, I thought it would be better to explain the import process as well.

To import WooCommerce products:

  • Login to your WordPress Dashboard.
  • Click on Products in the left panel.
  • Then click on the Import button on the top.
  • Click on Choose File button to browse your file that contains the data of your WooCommerce products.

import woocommerce product

  • After selecting the file, click on Continue.
  • Once you click on Continue, you’ll see a form asking you to map your CSV fields to products. Map the fields if needed otherwise leave it as it is and click on Run The Importer at the bottom.
  • The importing process will start by now and once done, you will see a message of successful import.

successful woocommerce product import

Top Plugins To Export WooCommerce Products

The manual method isn’t always the choice. With the manual method, exporting product variations could be challenging. Moreover, the default method only exports your products in a .csv file. And if you need the data in another type of file, the default method may not work for you.

Thus you need to rely on plugins to unlock more advanced methods to export your WooCommerce products. But what plugins? Let’s talk about that.

There are both(paid and free) sort of plugins available to export/import WooCommerce products. So, I’ll first talk about the paid ones and then move to the free ones.

Paid

Here are some of the best paid plugins to import/export WooCommerce products:

Product CSV Import Suite

The first plugin is the one I’ve already talked about. Product CSV Import Suite is a plugin you can try if you’re willing to spend a minimal amount. It is developed by WooCommerce so you won’t need to think about the quality or credibility of it before trying. Download Now – $49

WP All Import

Another name on the list is WP All Import. When I looked at this plugin, I found it to be the most robust and feature-loaded. It is developed by WP All Import and comes in both package and standalone solutions. You can use this tool to get the exported file in either .csv, .xml, or even in an excel file. Download Now – $99 *Either Import or Export Only. For both features, pay $169.

Product Import Export for WooCommerce

The last paid plugin in this list is Product Import Export for WooCommerce. It helps you import/export your WooCommerce orders, products, product types, product reviews, subscriptions, etc. depending on the plan you purchase. It is developed by Webtoffee which also has a free version on wordpress.org for the same with over 60k downloads. Download Now – $69/year. Single site

Free

Here are some of the best free plugins to import/export WooCommerce products:

Product Import Export for WooCommerce

Webtoffee again. They have created a free plugin to help you import or export your WooCommerce products. You can download the plugin for free from WordPress.

Note: You can only import/export simple products through this plugin. Download Now

Export any WordPress data to XML/CSV

I found this plugin developed by Soflyy on WordPress and simply loved it. It offers you many features like exporting your WordPress data into a CSV, XLS, or XML file. Moreover, provides a simple drag and drop interface where you can simply put a meta field into the section to get those fields’ data. You can also preview it before exporting to make sure everything is perfect. Download Now

WordPress Product Excel Import & Export

Developed by extendWP, this plugin lets you import/export your WooCommerce products into an excel file. But remember, the excel file is the only option available here. Another caveat – you can only import or export simple products through this plugin. Download Now

Conclusion

With almost 30% of the market share, WooCommerce is the most used eCommerce platform across the globe, according to Statista. Most of the users are using it happily. But everyone doesn’t have the same needs.

Sometimes people need a more robust store with technically dexterous support. And these needs drive them towards a different platform. And to migrate your existing online store to a different platform, the first thing you need is a backup of all your store data. Quite basic.

So in this post, I’ve explained how you can export your WooCommerce products, importing them, the best tools, and steps for it. But if you want to dive deeper into this, you can check out our guide on how to backup a WooCommerce store. It covers the process of backing up your whole WooCommerce store.

Apart from that, if you need any sort of assistance for your WordPress/WooCommerce store, you can always contact us. We are an agency possessing over 7 years of experience in WordPress/WooCommerce solutions.

Need WordPress/WooCommerce Assistance?

Connect With Us

Show More

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button