Exporting Products by Category – WooCommerce Product Import Export

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Product Categories help you to sort and organize your product. Webtoffee Product Import-Export plugin enables you to export products filtered by Product Category. With this plugin, you can export your products belonging to specific category(s) that you select on Admin settings page. All these product details are exported in a CSV file.

While exporting, if the product has multiple categories then Product categories are separated by ‘|‘. If the product has a category with a hierarchical structure, categories are separated with ‘>‘.

For more information about CSV format, see Setting Up Product Import Export Plugin For WooCommerce.

Now, let’s understand exporting of products under a specified Category through an example.

Suppose, Individual Product page with multiple categories is as shown below:individual product page 1

Individual Product page with hierarchical categories is as shown below:individual product page 2

  1. Navigate to Admin settings (WooCommerce > Product Im-Ex) of Plugin. Under the Product tab, the Export window appears as shown below:product export set up
  • Offset: Enter an offset value that lets you skip a specific number of products before exporting. This number will be one less than the product row number at which you wish to start the export. If you wish to start the export from product number 11, your offset value should be 10.
  • Limit: Enter the number of products that you wish to export. If your Offset value is 10 and Limit is 50, products from 11 to 60 will be exported.
  • Product Categories: Select the product category(s) so that the plugin exports only products which are assigned to this selected category. A Sample list of categories is as shown below:Product Categories
  • Product Types: Select the products type(s), so that the plugin exports products which are assigned to specific product types.
  • Sort Columns: Enter the column name(s) by which you want to sort the products in CSV file. If you want to sort the products by more than one column name, enter Comma (‘,’) in between the column names.
  • Delimiter: Specify the delimiter for your file. The CSV file format uses comma as the delimiter. You can change the delimiter to a few specified characters.
  • Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
  • Include hidden meta data: Select the checkbox if you want to show hidden metadata of your products in the CSV file.  To get thumbnail IDs of the product images, select this checkbox.
  • Click Export Products, the CSV file gets auto-downloaded to your computer. The sample products CSV file is as shown below:sample csvNote: You can download the Sample Exported CSV.

To know more about other features of the plugin, read the documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

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