Category created as "Default Category Migrated"

Hi support team,
After migration from M1 to M2, our default category is created as a New Root Category name “Default Category Migrated”.
We need to show the newly created category in our Navigation menu. Since we have numerous categories and products we can’t able to set newly created category, “Default Category Migrated” as the Root Category under System->All stores->Main website store . 
While trying to set Root Category from the above option, we are facing Time out errors, as well as memory exceeds error. We changed memory_limit and max_execution_time too, still its taking long time to set the newly created category as the Default Root category.
Could you please advice, Is any other option available to make “Default Category Migrated” as the default Root category for our website.

5 answers

Profile photo of Mall Staff 127680.00 $tone December 7, 2019
Public

Hi there,

While trying to set Root Category from the above option, we are facing Time out errors, as well as memory exceeds error. We changed memory_limit and max_execution_time too, still its taking long time to set the newly created category as the Default Root category.

That because your database has big volume of categories and associated products. For that case, you must contact to your hosting provider to increases the PHP memory_limit and max_execution_time in Server’s settings.
And then, you can assign the new Root category for the default Store of default website in your M2 instance.
Regards,
Mall.

#1
Profile photo of lakvenkat 590.00 $tone December 7, 2019
Public

Hi Mall,
Thanks for your response.
We have increased our memory_limit & max_exec_time. But somehow its giving timeout error. While viewing in front we encountered error message saying “Item Magento\Catalog\Model\Category\Interceptor) with the same ID “387” already exists.”.
Could you please advice, what is the cause for this error?
We want to show all our category in our storefront in Navigation Menu.
Since its taking more time to make newly created category as the Root category, Can we have those category menus in a static block ? Is that advisable ? If we do so, the categories won’t populate dynamically. We are more concerned about it. 
Or Is there any option to update the Root category and its associated products in DB level ? 
Since we have got another Root category after migration, do we have any impact in other tables ?
Please advise, How should we proceed further, to show all categories in navigation menu.  

#2
Profile photo of Mall Staff 127680.00 $tone December 7, 2019
Public

Hi there,

While viewing in front we encountered error message saying “Item Magento\Catalog\Model\Category\Interceptor) with the same ID “387” already exists.”.
Could you please advice, what is the cause for this error?

Let try with steps as following:
1 -- In categories management, create a new root category named ‘Temp Root Category’
2 -- Open Stores management, edit the default Store of the default Website and set the ‘Root Category’ form field to the newly added root category ‘Temp Root Category’ and click Save button.
3 -- Once done, open Stores management once again, edit the default Store of the default Website and set the Root Category form field to the main root category which you want to publish in the storefront again and click Save button.
Magento will regenerates categories and associate products URLs rewrite in this step. It might take sometime to complete this task (It depends on the volume of categories and associated products)
And then, re-index the data and clean the Magento cache.
Hope that helps.
Regards,
Mall.

#3
Profile photo of lakvenkat 590.00 $tone December 7, 2019
Public

Hi Mall,
We have already tried the above solution as you suggested. Still we got the above mentioned error as well as its loaded for around 4 hours to save the store and ended up with some timeout errors.

#4
Profile photo of Mall Staff 127680.00 $tone December 9, 2019
Public

Hi there,

Still we got the above mentioned error as well as its loaded for around 4 hours to save the store and ended up with some timeout errors.

It seems that you had a big volume of categories and associated products. And your current server’s performance couldn’t handle that volume. Could you consider to upgrade your server?

Regards,
Mall.

#5

Please login or Register to Submit Answer

Written By

Comments