Exporting Products by Category – WooCommerce Product Import Export

[vc_cta h2=”The Best Product Import Export Plugin for WooCommerce” add_buttory With 30,000+ Active Installs
#1 in Customer Satisfaction With Most 5 Star Reviews
XAdapter Guarantee: Get Your Money Back if You Are Not Satisfied With The Product
[/vc_cta] Product Categories help you 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
Individual Product Page

Individual Product page with hierarchical categories is as shown below:

Individual Product Page
Individual Product Page
  1. Navigate dow appears as shown below:

  • 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 from product number 11, your offset value should be 10.
  • Limit: Enter the number of products that you wish 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. Sample list of categories is as shown below:

  • Product Types: Select the products type(s), so that 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 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 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 meta data 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 your computer. The sample products CSV file is as shown below:
    Exported Sample CSV
    Exported Sample CSV

    Note: You can download the Sample Exported CSV.

To know more about other features of the plugin, read documentation.
[vc_cta h2=”The Best Product Import Export Plugin for WooCommerce” add_buttory With 30,000+ Active Installs
#1 in Customer Satisfaction With Most 5 Star Reviews
XAdapter Guarantee: Get Your Money Back if You Are Not Satisfied With The Product
[/vc_cta]

Scroll to Top