Export Catalog Product With Custom Attributes In Magento 2

magento 2 export product attributes

Export Catalog Product With Custom Attributes In Magento 2

Built for the large and even massive quantity of selling products, Magento 2 supports well the needs of product management of an online store by the act of import/export product attributes.


In this tutorial video, viewers get to the know-how to export custom product attributes in downloaded .csv catalogue product file just by this quick operation in Admin Panel.

If that is not enough, read in written lines the upcoming parts: an overview of Magento export products, the drawback of Magento export product custom attributes, how to get custom attributes in separate columns when implementing Magento 2 export products.

CHECK NOW Everything You Should Know about Magento to learn everything about Magento in hand.

Overview of Magento 2 Export Products

At the backend, please go to System ⇒ Export to start Magento export product data in Admin Panel.

Export Custom Product Attributes magento 2
System > Export

In Entity Type, choose Product to start setting up the data you need for the exported file.


In the Entity Attributes, you will find all available product attributes for exporting. By default, Magento 2 exports product attributes with all of these here. However, you can exclude unnecessary attributes or set a filter for them.

Custom-Product-Attribute-export-for-Magento 2-overview-2

In the final step, you just need to scroll down the attribute list and click Continue for the CSV file download popup to appear.


Drawback of Default Exporting Custom Product Attributes

The exported CSV includes all selected products attributes in neat columns as below:

magento 2 export product attributes csv sample
Magento 2 export attributes CSV sample

However, the format of the file only goes well with the default attributes of Magento. With the custom attributes created by admins, the file will show them in only one column named “additional_attributes” separated by a comma.

magento 2 export product attributes csv additional attributes
.csv additional attributes

Separate custom attributes now into individual columns

We offer a Custom Product Attribute Export for Magento 2 extension to help store owners fix the problem by just a few clicks at the backend.

DOWNLOAD Magento 2 Export Custom Attribute module for FREE to arrange custom attributes in separate columns!

After installing the extension, go to Store ⇒ Configuration ⇒  BSS Extension ⇒ Product Export Column, you will see two configs:

magento 2 export product attributes backend

In Allowed Attributes, a list of all custom attributes will be shown. Admins can choose all or specific attributes that will be in separate columns while exporting products.


For example, in the above settings, the admin chooses “height,” “sw_featured,” “volts.” Hence, the exported product attributes file will have each of these in different columns.

magento 2 export product attributes frontend

Moreover, to perform Magento 2 export product attributes quickly, this Magento 2 Import Export Product Attributes extension is an ideal solution to overcome the drawback of the default.

  • Import product attributes via a CSV file
  • Import associated information of multiple products attributes into a website
  • Implement Magento 2 export attributes promptly within 1 click
  • Support multiple store views

GET READY TO INSTALL Magento 2 Import Export Product Attribute extension to free yourself from manual tasks!

More thoughts

With the FREE Custom Product Attribute Export for Magento 2, we hope to bring Magento 2 admin an effective solution in exporting custom product attributes without changing the core code. 


We will continue our series for more Magento tips and recommendations so don’t forget to visit us often or subscribe to our newsletter. If you have any questions regarding Magento or suggest a new topic, we are thrilled to have your thoughts in the comment section.


Here are some Magento 2 import export extensions that may be helpful for you:

Write A Comment


( 3 ) Comments