Rating 5 stars - 1 votes

How to export products by category in Magento 2 (Magento Open Source 2, Adobe Commerce)

The need to export products from specific categories in Magento 2 (Magento Open Source 2, Adobe Commerce) usually occurs when only certain goods from the catalog need to be selected out and copied to file for further modifications, to be sent to supplier for stock notifications or other purposes.

How to See Goods Belonging to Certain Magento Category?

In Magento 2 (Magento Open Source 2, Adobe Commerce) back-end go to Catalog -> Categories .

In this window you will see category tree on the left and information on selected category on the right. To see goods assigned to this category, open 'Products in Category’ tab

Products in Category Adobe Commerce

Now you might need to export products belonging to this category.

Is There a Way Export Products by Category in Magento Back-End?

Unfortunately, Magento 2 (Magento Open Source 2, Adobe Commerce) does not offer you ability to export only certain goods that you have filtered or selected in any other way.

So, if you go to Import/Export and export goods to file, after it was opened in any spreadsheet program you will see ‘_category’ field with category path. You can manually remove from file goods belonging to categories you do not need.

Adobe Commerce Export by Category File

However, in case you have hundreds or thousands of goods this task seems pretty time-consuming. That is why you might be interested in an alternative.

Export Filtered or Goods from Specific Category

If you don’t want to deal with the entire list in a CSV, you can use Store Manager for Magento application.

It allows you to export products by category (if you have selected it before import) or by any filter you have applied before exporting.

Download Store Manager and get the CSV with goods by categories in seconds! Export FREE

Open ‘Categories & Products’ section of Store Manager for Magento. On the left you can see tree with categories and subcategories.

Categories and Products Grid in Store Manager

Select built-in filter ‘Show products from selected categories’ in order to see goods assigned to selected categories on the right pane of the window.

Show Products from Selected Category in Store Manager

This way moving through your category list you will be able to see the goods belonging to those categories - this is very useful filter.

After that you can export filtered by category Magento products. To do that run Import/Export Wizard of Store Manager form the context menu or from product toolbar.

Launch Import Wizard in Store Manager

At the step ‘Select Product to Export’ you can indicate whether you would like to see in exported CSV whole product list, only selected or filtered products.

Since we have previously filtered products by categories, to export goods from specific category choose option - ‘Only filtered products’.

Export Products from Selected Category Option

With Store Manager you can not only decide what exactly products to export to CSV from Magento catalog, but also select our the information to be added to file.

You can choose what fields to get in output spreadsheet: just drag necessary attributes from the left and drop to the right.

Select Fields for Export with Store Manager

After export settings are made, you can choose whether you want to open and view the received file right away, check folder it was placed to or do nothing.

Export File Preview

Export products belonging to certain categories in a few clicks! Try FREE

Related Articles:

magento export categories article

Magento – Export Categories

Export Magento categories (all categories or specific ones) into a .csv file with a possibility to select particular fields to be exported. Read More...

how to assign multiple products to categories

How to Assign Multiple Products to Categories

Guides on every method of oerforming bulk assign of products to a categories (video tutorial included). Read More...

list of magento products without category

Get a List of Magento Products Without Category

Check the methods of detecting Magento products not assigned to any category of your store and find out the reasons why they appear. Read More...

how to export multi component products from magento

How to Export Multi-Component Products from Magento

Use these tips to avoid breaking product relations when performing export of Magento multi-component products. Read More...

Live Chat