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 catalog product file just by these quick operation in Admin Panel.
If that is not enough, read in written lines the upcoming parts: an overview of exporting products in Magento2, drawback of exporting product custom attributes, how to get custom attributes in separate column when exporting products in Magento 2.
*Useful tip: Sweep this article to learn everything about Magento in hand – Everything You Should Know about Magento.
Overview of Exporting Products in Magento 2
At the backend, please go to System ⇒ Export to start exporting data in Admin Panel.
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 will export all of these. However, you can exclude the unnecessary attributes or set a filter for them.
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:
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.
Separate custom attributes now into individual columns
We offer a FREE MODULE to help store owners fix the problem by just a few clicks at the backend. After installing the extension, go to Store ⇒ Configuration ⇒ BSS Extension ⇒ Product Export Column, you will see two configs:
In Allowed Attributes, a list of all custom attribute will be shown. Admins can choose all or specific attributes which will be in separate columns while exporting products.
For example, in the above settings, admin chooses “height,” “sw_featured,” “volts.” Hence, the exported product attributes file will have each of these in different columns.
Moreover, to import and export product attributes quickly, this Magento 2 Import/Export Product Attributes extension is an ideal solution to overcome the drawback of the default.
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. You can also check out other Magento 2 modules from us HERE.
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 question regarding Magento or suggest a new topic, we are thrilled to have your thoughts in the comment section.
Relevant to this subject, to know how to import and export product attributes into Magento 2 websites, let’s take a look out blog post:Must-have Import/Export Product Reviews Extension for Magento 2 Site, or read more about Import and Export Product Reviews in Magento 2 and How to Import and Export URL Rewrites in Magento 2