Hi. It took me a while to notice after importing my data from M1.9 to M2.2.5, but I’ve noticed an issue with updating Category Information. I imported both Categories and Products together, but only Categories are affected.
If I go into an imported category, I can change any of the values. However, the changes aren’t reflected on the frontend.
If I add a new category to an imported category, all changes I make show just fine on the frontend.
I’ve done the obvious like Clear Cache/Reindex/Enable and Disable Flat Tables but it doesn’t make a difference.
I did a deep dive into the DB. I discovered that tables are being updated correctly. However, the catalog_category_flat_store_1 remains incorrect ever after reindexing. So, I then decided to TRUNCATE the table and reindex Magento. After reindexing, the table is refilled with the old values again.
I have no idea where this old data is being pulled from to re-populate the table. Plus, Magento shouldn’t even be pulling from the table because ‘Use Flat Catalog Category’ is set to ‘No’.
Thoughts?
3 answers
Hi there,
If I go into an imported category, I can change any of the values. However, the changes aren’t reflected on the frontend.
Please provide me more information about that issue. Seem that issue relates to Magento core issue?
Regards.
Mall.
I’d would agree, however it only affects the Categories that I’ve imported via ‘UB Data Migration Pro’. I’ve gone into more detail here: https://magento.stackexchange.com/questions/234982/magento-flat-category-table-contains-incorrect-data-even-after-reindexing
Hi there,
We’re terribly sorry for our delay in responding to you.
As we have 4 days off till this Sunday for a local festival event, please give us a bit more time to follow up your case. We will try to get back to you as soon as possible within this week though.
Thanks for your patience and support.
Sincerely,
Ubertheme team