Skip to content

Product category_ids missing from migrated attribute sets #89

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
kassner opened this issue May 30, 2016 · 10 comments
Closed

Product category_ids missing from migrated attribute sets #89

kassner opened this issue May 30, 2016 · 10 comments

Comments

@kassner
Copy link

kassner commented May 30, 2016

Hi,

Magento 2 uses an attribute called category_ids to display the category selector in the product edit form in admin, but still stores data into catalog_category_product table, the same way as Magento 1.

This table is populated correctly during migration (tested migration from patched 1.6.2.0 to 2.0.5), but the category_ids is not added to all copied attribute sets, so if you edit a product after the migration, it loses its categories association (rows are deleted from catalog_category_product) and breadcrumbs URLs (category/subcategory/product.html) is also lost (deleted from url_rewrite table), leading to a lot of 404 URLs.

It is possible to avoid losing the data if we add the category_ids attribute back to the attribute sets before editing the products in the admin.

Thanks,
Rafael Kassner.

@vektor-dev
Copy link

Hey Rafael,

We've got the same problem and will let you know if/when we fix it.

Pete

@phronesis
Copy link

I got the same problems, any progress on this?

@victor-v-rad
Copy link
Collaborator

@kassner @vektor-dev @phronesis I have not manage to reproduce your issue
You could share your DB dump of the next Magento 1 tables:
eav_attribute_group
eav_attribute_set
eav_attribute
eav_entity_attribute
catalog_eav_attribute
customer_eav_attribute
eav_entity_type
You can send it through the email (find it in my profile https://github.com/victor-v-rad)
We will try to migrate it

@phronesis
Copy link

Thank you Victor. I'll send it across shortly. Thanks.

On Fri, Jul 29, 2016 at 1:53 PM, Victor Rad [email protected]
wrote:

@kassner https://github.com/kassner @vektor-dev
https://github.com/vektor-dev @phronesis https://github.com/phronesis
I have not manage to reproduce your issue
You could share your DB dump of the next Magento 1 tables:
eav_attribute_group
eav_attribute_set
eav_attribute
eav_entity_attribute
catalog_eav_attribute
customer_eav_attribute
eav_entity_type
You can send it through the email (find it in my profile
https://github.com/victor-v-rad)
We will try to migrate it


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#89 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAtGF8JgFtGV5Gjr7dGQ4JMrXvwun22dks5qaffTgaJpZM4Ip9dv
.

@victor-v-rad
Copy link
Collaborator

@kassner @phronesis
Please recheck the issue on the latest version of the tool and close if it is fixed

@Gorkyman
Copy link

Gorkyman commented Nov 9, 2016

@victor-v-rad this is still an issue with the latest version of the tool. My wild guess would be, that this happens when you have a "General" attribute group renamed to something else. We have a client that has all default groups renamed and this happened.

@victor-v-rad
Copy link
Collaborator

victor-v-rad commented Nov 10, 2016

@Gorkyman

that this happens when you have a "General" attribute group renamed

In this case you should have seen the error:The product attribute set "..." does not contain all required attribute group names "..." I do not know why it has not happened. The good way to find it out is to send me (find it in my profile https://github.com/victor-v-rad) your DB (without user passwords) and we will try to migrate and see results.

@deepikajaniyani
Copy link

We are also facing the same issue, i.e. the category_id is not getting associated with the migrated attribute set, due to which categories are not shown up while editing products from admin.

Category associations with products are getting migrated and products are shown against the categories in front-end. But as soon as we edit the product and save it, the products and category association gets removed.

We also observed that in the migrated product data, " Attribute Set" is also editable from admin.

We are using the latest version of data migration tool, and Magento EE 2.1.1

@anethum
Copy link

anethum commented Dec 19, 2016

Hi @victor-v-rad we have also the same issue as @Gorkyman.
What was the solution?`
We are using the Version 2.1.3
the previouse v. 2.1.1 working fine

@dfelton
Copy link
Contributor

dfelton commented Jan 2, 2017

This is still an outstanding issue in version 2.1.3.
Please see issue #212 for more details.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

8 participants