• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Essential Premium WooCommerce Plugins - WP Desk
  • Plugins
  • Bundle
  • Support
  • Blog
  • My Account
  • 0

Stay updated on our how-to articles

WP Desk news, WooCommerce tips, promo codes - right to your inbox.

By entering your e-mail, you agree to our Terms & Conditions and Privacy Policy.

Damian Machnik

How to export WooCommerce products to CSV file (the easy way)

Updated: May 02, 2023 / News, Plugin Tutorials

There are multiple situations where exporting WooCommerce products may be useful or even required. For example, if you decide to migrate your WooCommerce store, and move all or some of your products to a different ecommerce store. Exporting products to a CSV file may be useful if you decide to create a backup file with your products.

Why to use Dropshipping Export Products for WooCommerce?

WooCommerce may be helpful, but at the same time it has some limitations. That’s why we decided to create a plugin which has some advantages over WooCommerce in terms of exporting products - not only to CSV files.

Our WordPress plugin lets you export WooCommerce products like a PRO. There are no limitations on a number of products to export. You are welcome to export even thousands of products to one CSV file. And yes - it works for variable products as well.

Dropshipping Export Products for WooCommerce £79

Export products from WooCommerce to CSV or XML file in an easy way. With Dropshipping Export Products for WooCommerce it's child's play!

Add to cart or View Details
WP Desk
Plugins used by 236,831+ shops
Last Updated: 2023-04-27
Works with WooCommerce 7.1 - 7.5.x

How to export WooCommerce products to CSV - step-by-step guide

I’m not a fan of super long introductory parts, so let’s dive into the crème de la crème of this article, which is a short guide, how to export products to an external CSV file. By short, I do not mean that it will lack of explanation. It is short because I like to keep things easy, and do not overcomplicate. Not to mention, that exporting products with our plugin is a piece of cake, and literally, anyone can do it.

Step 1. Select types of products to export

We’ll start with selecting product types. By default, all product types will be selected. However, you can limit your product export to, let’s say, simple or variable products only. Besides those, Dropshipping Export Products for WooCommerce supports grouped and external products as well.

I decided to go the easy way, and simply export all products:

Export all products
Export WooCommerce products to CSV
HINT. If, for any reason, you’d change your mind, and you'd like to export your products to an XML file instead of CSV, you’re good to go. Simply choose the XML radio button.

Step 2. Conditional logic

Exporting WooCommerce products with conditional logic
Conditional logic in the Dropshipping Export Products plugin

It is an optional step, which means that you can simply hit the Go to the next step button, and move to the next step.

However, a word of explanation, for those who are interested in conditional logic and want to have full control over which products should have been exported.

In this step, you can set a number of conditions, which apply to your export. For this tutorial, we will go the easy way, so I won’t select any conditional logic here. If you decide to choose a similar path, your screen should look like this:

Exporting WooCommerce products without conditional logic
Conditional logic is optional. You can move to the next step

Hit the Go to the next step button to move further.

Step 3. Product mapper in Dropshipping Export Products for WooCommerce

In this step, you’ll see a big table which can look a bit overwhelming at first, but no need to worry. I’ll shortly explain these fields to you. First, let’s take a brief look at the screenshot:

Product mapper
Basic product mapper look

Product fields are simply data and values associated with your products. We assume that you’d like to export all of them to a CSV file. However, it is entirely up to you. If, for any reason, you decide that you do not need to export, let’s say, the Product ID, just uncheck this field.

Similarly, for product fields on the top-right part of the screen. Here, you can select some additional fields like size, color, shape or simply select all, to export all fields.

Lastly, advanced fields. These are a bit more advanced (hence the name), so in this tutorial we’ll only scratch the surface, and move along.

Advanced fields are basically a mix of conditions, which you can apply to the exported file. You can do it when you do not want to simply create a 1:1 export of your product, but you’d like to make some modifications to it.

Let’s take a look at the screenshot:

Product mapper advanced
Advanced product mapper options

As you can see, there are tons of available options. Super useful feature, and I can imagine thousands of use-cases for it. However, let’s keep this guide as simply as possible. In such a case… you are right. Click on the Go to the next step button.

Step 4. Product export options

We’re almost there! The final step, in which we’ll make some decisions. Here’s how product export options look like:

Exporting products from WooCommerce. Options
Final export options

From the top to bottom, you can:

  • Choose the name of your newly created CSV file.
  • Decide for how many batches you want to split your products. If you decide to go for 100, and have fewer products, they will be simply exported at once. I’d say that this setting becomes more useful if you have numerous products. And its usefulness gradually increases with the number of products. Thanks to it, exports will be as smooth as possible.
  • Choose separator field. I’d suggest going for comma, but you are welcome to choose pipeline | or semicolon ; or any other.
  • Cron settings. This setting deserves a separate article. It is so useful! You can do it to create a recurring Cron event, which will create a CSV file with exported products automatically, like every Monday at 6pm.
  • Next up is the file location. Select a place where you want to save a CSV product file. It can be your server or external server.
  • Lastly, if you’d like to export images as well, all you need to do is select the checkbox.

If you filled all the necessary fields, simply click the Start Export button.

Summary of export WooCommerce products to CSV

Exporting products from WooCommerce. Conclusion
Export summary

On this screen, you can see a summary of the product export. As you probably noticed, we like to keep things simple, so this screen is no different. Basic information, for a better look at what is going on with your products.

Two things worth mentioning are the option to cancel and logs. Obviously, you can cancel your export when it is still in progress. Secondly, if anything goes wrong, the export log will tell you a bit more about what happened. If you send that log to us, we’d gladly tell you even more about it.

Designing products to be easy to use does not mean that they have to be simple. That’s why when your export is finished, you’ll not only receive a CSV file, but it will be saved as a template, which you can access anytime by navigating to Dropshipping Export > Export Manager.

Here are all of your exports, and here you can edit, clone, change or simple start a new export.

Conclusion

All good things end quickly ;)

My goal was to answer the question, how to export WooCommerce products to a CSV file. I hope that, beside the answer to this question, you saw that exporting products with Dropshipping Export Products for WooCommerce (even in more advanced scenarios!) is super easy.

However, if you have any questions, contact us. We’re waiting for your questions and valuable feedback.

Tweet

4 minutes read272 views

Damian Machnik

Product Manager at WP Desk. Every day I try to create better and more interesting products. If you have any questions, go ahead and email me!

Powered by WP Desk

WP Desk brings you great WooCommerce plugins. We strive to save your time and money by speeding up your processes. Use our plugins to build a better store. Awesome support included in the package.

Premium WooCommerce Plugins →

Stay updated on our how-to articles

WP Desk news, WooCommerce tips, promo codes - right to your inbox.

By entering your e-mail, you agree to our Terms & Conditions and Privacy Policy.

WP Desk › Plugin Tutorials › How to export WooCommerce products to CSV file (the easy way)

Footer

WP Desk - WooCommerce Plugins

At WP Desk we create great WooCommerce plugins with awesome support. Save time and money with our e-commerce solutions. See how we can help you improve your e-store →

Secured by Comodo

WP Desk

  • About us
  • Giving Back
  • Blog
  • Contact us

Products

  • Premium Plugins
  • Get Support
  • WooCommerce Invoices
  • Email Marketing
  • Octolize

Legal

  • Terms & Conditions
  • Refund Policy
  • Support Policy
  • Privacy Policy

© 2023 WP Desk