Rating 0 stars - 0 votes

How to Export WooCommerce Products By Category?

Sometimes, the possibility to export WooCommerce products by category to .csv seems to be essential. It can save so much time and efforts as you don't have to search among the exported products the ones related to specific category manually.

By now, WooCommerce admin does not support such feature, so WooCommerce merchants resort to using some special modules or applications.

In this article, we will show you how to export WooCommerce goods from specific category to .csv in few clicks using Store Manager for WooCommerce application.

How to Export WooCommerce Products by Category?

  1. Go to Store => Products & Categories
  2. Find Filter drop-down menu and select 'Filter by selected category' or 'Filter by selected category and nested categories' depending on what you need.

  3. If you press 'Export data' button, there will appear export wizard containing 4 stages.

  4. On the first step specify the place to save the export file to by pressing the browse button.

  5. On the second step select the delimiter that will be used to separate fields data and check quote string values box (recommended).

  6. On the next stage select the fields to be exported by simply double-clicking on them or using the right-pointing arrow. If you want the export file to contain all the fields, use the double right-pointing arrow. You can also use expression editor to apply changes to your product updates.

  7. On the last step of configuration confirm what records should be exported (all records or selected ones) and press 'Export'.

  8. Preview the file and check if the data is properly formatted. Select the action to be performed after the export will be completed:
    • Nothing
    • Open directory containing result file
    • Open result file

    If you want, you can save the configuration and use it when performing the next product exports.

    Now when you have WooCommerce products exported by category, you can modify them and import back to the store. You can find instructions on performing WooCommerce CSV import and a .csv file sample in this article WooCommerce CSV Import.

Export WooCommerce productds by category for 14 days free Try now

Be the first to comment.

Privacy Preference Center

Strictly Necessary

These cookies are necessary fro the site ot function.

woocommerce_cart_hash, woocommerce_items_in_card, wp_woocommerce_session_{hash}


These are used to track user interaction and detect potential problems. These help us improve our services by providing analytical data on how users use this site.

_ga, _gid, _gat-_UA-326982215-25, LaSID, LaVisitorId, __utma, __utmc, __utmv, __utmz

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?