I would like to copy categories attributes (e.g title, search engine optimization text like url_key, contents, description etc) from a store view navigation to the default navigation.
In other words, I would like to use the categories in All Store View instead of my store view. However, I have been mistakenly editing the store view categories instead of the global ones and it's time-consuming to re-update that manually.
How to copy these:
Therefore what is a good approach to do this?
I'm not sure if doing this is correct, but I tried editing directly the table. Not sure if there are other considerations I need to put into mind when editing the table directly.
I thought to copy all records from store id 1 to store id 0 and then delete everything in store id 0 in order to reset it to use (Use Default Value)
INSERT INTO `catalog_category_entity_text` ( `attribute_id`, `store_id`, `entity_id`, `value` ) SELECT `attribute_id`, "0", `entity_id`, `value` FROM `catalog_category_entity_text_1` src WHERE src.`store_id` = 1 AND src.value IS NOT NULL ON DUPLICATE KEY UPDATE `catalog_category_entity_text`.`value` = src.`value` ;