7

I refer Magento 2 - Export/Import Product Attributes but no one answered :(

I have already created new Attribute Set & it's Attributes. I have checked Magento Default Import/Export for Products. It will do with all products.

I just want to export My newly created Attribute Set & it's Attributes. I have added in my Local. Now want to upload on a server. Can't override DB/Table.

Can manage through CSV or Custom Code?

  • you can replace database from local to live, if your local repo are same as server. first backup live db and try with above – Rakesh Jesadiya Oct 7 '16 at 9:01
  • @Rakesh Is you see from question i Can't orverride DB/Table. – Jackson Oct 7 '16 at 9:08
  • Why Down Vote? Provide Reason please – Jackson Oct 7 '16 at 9:08
  • @Rakesh If need to do using database then what will be query from which tables? – Jackson Oct 7 '16 at 9:15
  • you have to just replace entire database from old to new one into sever, Also i am not believe in downvote. – Rakesh Jesadiya Oct 7 '16 at 9:16
0

You could try inserting the data manually by exporting the data from your local database, and running a SQL command like this for each of the tables you need to import with the data from your local table.

INSERT INTO catalog_eav_attribute (attribute_id, frontend_input_renderer, is_global, is_visible, is_searchable, is_filterable, is_comparable, is_visible_on_front, is_html_allowed_on_front, is_used_for_price_rules, is_filterable_in_search, used_in_product_listing, used_for_sort_by, apply_to, is_visible_in_advanced_search, position, is_wysiwyg_enabled, is_used_for_promo_rules, is_required_in_admin_store, is_used_in_grid, is_visible_in_grid, is_filterable_in_grid, search_weight, additional_data) VALUES

There are obviously more than just one table that will require your attention, but this is the fastest solution that I found.

| improve this answer | |
  • HI @Collin Blake can you give me more hint on this as I know along with catalog_eav_attribute table you need eav_attribute table for import product attribute.I am trying to create a module for this but on validation i got error.Thanks .. – Bibhu Asish Sep 21 '17 at 11:08
0

Default magento does not provide this feature.

if you have large store and you wants to import / export all attributes and update then you can simply use the any plugin for this feature.

You can use some extensions to use this feature in community version:

https://marketplace.magento.com/mageaurigait-importexport.html https://marketplace.magento.com/code007-attribute-import-export.html https://marketplace.magento.com/commerceextensions-module-productattributes-import-export.html

| improve this answer | |
  • every time I bump into this I still cannot believe it is not an option in default export. The FIRST choice you have to make when creating a product is product type and attribute set they should be the main options you can filter an export by. – iphigenie Jun 27 at 15:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.