Magento Category Movement

All the new category changes are done on staging server, and now i wanted to move it to live. I cannot move complete database, since both the database are not synchronized and i don't want to loss sales/order/customer data.

If i only move table that are specific to category, will this work without any issue? I also wanted to retain category ID after moving it to production server.

Can anyone please guide which all table i need to move to make this category migration successful.

Thank You.


Yes, just export all tables starting catalog_ (check 'disable foreign key checks' and 'add drop tables if exist') in database and import into the other database. This will ensure the necessary relationships between products and categories still remain intact (to clarify, this will import all products and what categories they are assigned to etc).

This then won't touch sales/orders/customers etc but just import everything related to the catalog.

You may find this useful as well.

Similar questions

how to display a new root category except default category in magento?
In my website I have a default menu which always shows in the header part. Now I want to add another root category which will show up in a specific page(not all pages). I already created a new root category from magento admin but don't know how to show only this category in frontend. point that my new category id is '12' I tried but this only shows...
Does Magento have a default category ID for all "New" products regardless of main category?
I would like to have a "New" products carousel on my home page. I've got them for other items in specific categories but I would like one that lists all items that are new regardless of category.
magento - how to show only configurable product in main category, simple product in sub-category
I want to know how can I do this. I want to when i click main category, just show configurable product in page, and when i click sub-category, show simple product in page. Please help me in this, it will be really appreciated. i'm newbie Thanks
Magento CSV Product Import Set Parent Category URL Key for use on Catalog list Category page
-- Update -- I think the issue is in the category list view. It generates the product link to the product, for the page, in a loop. I have it getting the product categories, and using that to build the URL. I am thinking I will have to define which one i want to be the parent in an additional attribute, and then check that attribute for the categor...
search result page showing error while trying to show current category and child category in sidebar of magento
I used the following code to show current category and child category on each page it working well but when i search any term in the search box then it will show product but in sidebar it will show fatal error. so any one can suggest me the solution of this problem any help will be important for me.
Append new category to existing category list via Magento Dataprofile Import
I have a situation where i need to create a new Category ( say Promotional ) and add around 1000+ product to it. I tried it by creating a csv file as below format. But instead of appending new category, it has replaced existing category. Is their a way were i can append category to existing category list? Thank You

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.