2012-10-06 17:22

修改类的ID,要修改的表有:

categories - categories_id

categories_description - categories_id

products_to_categories - categories_id

非常重要的另一个表:

products - master_categories_id

update products set master_categories_id= master_categories_id+29;

修改产品的ID:

products - products_id

products_attributes - products_id

products_description - products_id

products_to_categories - products_id

推荐,特价,Meta 据需要而改

===================

第一步:

update categories set categories_id = 2 where categories_id=476;

update categories_description set categories_id = categories_id - 468 where categories_id=469;

update products_to_categories set categories_id = categories_id - 468 where categories_id=469;

update products set master_categories_id= master_categories_id -468 where master_categories_id=469 ;

update categories set parent_id= parent_id + 135 where parent_id >0;　(有子类)

第二步:

update products set products_id = products_id -6968 where products_id=6978;

update products_attributes set products_id = products_id -696
信息来自:http://hi.baidu.com/chrilisa