cancel
Showing results for 
Search instead for 
Did you mean: 

Import - Export of attributes and attribute sets

Import - Export of attributes and attribute sets

Hello,

 I want to know two things:-

[A] What are the tables in database that are associated with attributes and attribute sets ?

I have searched the database and found these table names: -

 Attrib.png

[B] My question is,

Let I export these tables using PhpMyAdmin from my site;

Then I import this file in my magento database at another site;

Should I expect that, in this way, my custom created attributes and attribute sets are transferred to my other site ?

Magento Version: 2.1.9 and 2.1.11

Thanks.

2 REPLIES

Re: Import - Export of attributes and attribute sets

Not sure this is good idea. Tables are very often interrelated and linked with other info. In case you already have some products on another store, ids of attributes might change and then cause problems with products.

Maybe free extension will be a solution for one-time operation? Here is the article describing the one with necessary functionality working for Magento 2 -

https://www.mag-manager.com/useful-articles/magento-attribute-management/magento-export-product-attr...

 

Re: Import - Export of attributes and attribute sets

Thanks for reply.

I appreciate this very much.