How to export WooCommerce products with categories?

In this article, you’ll learn 3 ways to export products with product categories in WooCommerce. I will mainly focus on the export options. The article also shows the options to customize the product export by choosing the WooCommerce product types, fields to export, attributes, or images using a plugin.

WordPress and WooCommerce give you 2 free options to export products in WooCommerce (including product categories). What these two tools lack is a way to modify the output of the feed 🙁.

Today, you will see 3 methods to export products and product categories in WooCommerce 🙂. One of them is the plugin to export WooCommerce products with categories that can adjust the exported data. For example, before migration or to copy WooCommerce products from one site to another. Let’s begin 🚀!

Table of contents

• 3 methods to export WooCommerce products
• Export WooCommerce products with product categories (plugin options)
• Adjust the exported data for categories
• Dropshipping Export Products for WooCommerce - plugin features
• More export features & how to import the products
• Summary

3 methods to export WooCommerce products

The first two methods are available in standalone WordPress and WooCommerce. The third option is the most advanced (a paid plugin).

And of course, I will focus on categories. So, I will show you how each option lets you export WooCommerce products with categories.

Export products in WordPress

WordPress lets you export all or selected data to XML files:

You may also export WooCommerce products with their categories. The exported XML file will contain all information and meta of products. You will get product categories as well in the category nodes.

The downside of this approach is that you cannot adjust the exported data.

Export products in WooCommerce

But you may use the default WooCommerce product exporter to create a CSV file. And here you can choose the product data you need. So, you can choose to export WooCommerce products with product categories. What’s more, you may select to get products only from specific categories or product types.

So, WooCommerce lets you choose the product data and create a customized CSV file.

Export WooCommerce products with a PRO plugin

Finally, you can use a plugin to export WooCommerce products with categories. I will use Dropshipping Export Products for WooCommerce below.

After the installation, you may create and adjust multiple files (XML and CSV). You can choose the product types as well. The extension comes with tools and options to customize settings before exporting WooCommerce products (also with images).

It seems it’s quite similar to the default WooCommerce exporter, right? Not quite, as the most important features lie ahead 🙂. Let’s see them.

Export WooCommerce products with product categories (plugin options)

1️⃣ First, thanks to conditional logic, you’re able to choose specific conditions for exported data.

2️⃣ Next, you can choose the product data to export (choosing and naming the fields). You may also use options for attributes or price, and stock modifiers.

3️⃣ Finally, you may set the automatic schedule for exports and some other options. They may be very useful if you want to synchronize products with different stores for dropshipping.

These additional options inside the plugin give you much more flexibility and customization.

Adjust the exported data for categories

Let's see the first two features to export WooCommerce products with categories.

Thanks to conditional logic, I’m able to define which products will be exported based on their categories, price, stock, etc.

With product fields mapper and price/ stock modifiers, I can create a customized file for a retailer, dropshipping, or migration purposes.

As you can see, the plugin lets me adjust the data and export WooCommerce products with categories. I may also change the export settings fast, copy, or create multiple export files easily.

Dropshipping Export Products for WooCommerce - plugin features

It's possible to choose the conditions before the export.

The exporter also allows adjusting the specific product data fields to export with an easy drag&drop editor.

Export product data options

It's possible to select specific product data before exporting (or migrating) WooCommerce products with categories.

For example, it's possible to choose the product data to export product's:

• ID
• Parent ID (for variable products)
• Name
• Price
• Sale price
• SKU
• Stock quantity
• Attributes
• Category
• Images
• Description
• Short description

As you can see, one may also choose the column for product categories or change the field name. Not only that, as the extension can narrow the export data to specific WooCommerce product categories.

Finally, it's worth mentioning that the exporter can get data for all product types. For example, it's possible to export only simple and variable products with WooCommerce product categories.

Troubleshooting (exporting products)

A short checklist of things to check first if the product export does not work properly.

• Location has write permissions
• WordPress and WooCommerce logs
• FTP path on the server
• Memory limit
• Schedule settings
• Cron settings on the server
• PHP version
• or plugin conflict

More export features & how to import the products

Let’s assume one wants to export all products from 2 categories with the price between $100 and $200. The migration goal could be to import them to a new store designed for selected products only. The Dropshipping Export Products for WooCommerce allows this scenario.

You’ve already seen how to use conditional logic for price. After exporting WooCommerce products with categories one may need to import them to a new store e.g. during the migration process. The one below is a free plugin to import WooCommerce products with categories.

Product import in WooCommerce is possible for free with a WordPress importer, WooCommerce product importer, or a plugin. I encourage you to use this free plugin.

Export WooCommerce products with product categories - summary

Today, you’ve learned how to export (and import) WooCommerce products with categories using 3 methods. I encourage you to use the extension to have better options. Bulk editing product data can be one of efficient way of product management before exporting (or migration) WooCommerce products. The export can then be used to adjust product fields, bulk edit prices, stock, or transfer products.

Customizing products with filters or specific product attributes before migrating them from WooCommerce. Save a lot of time on bulk editing product fields and prepare the product feed with automated schedule.

Visit the extension and check out all its features in the plugin documentation →

If you have any questions let us know.