update product id category id
#第一步:
#18是分类个数
update categories set categories_id = categories_id+18;
update categories_description set categories_id = categories_id+18;
update products_to_categories set categories_id = categories_id+18;
update products set master_categories_id= master_categories_id+18 ;
#有子类,1是有子分类的一级目录个数
update categories set parent_id= parent_id + 1 where parent_id >0;
#第二步:
#610是商品个数
update products set products_id = products_id+610;
update products_attributes set products_id = products_id+610;
update products_description set products_id = products_id+610;
update products_to_categories set products_id = products_id+610;
#推荐
update featured set products_id = products_id+610;
#特价
update specials set products_id = products_id +610;
浙公网安备 33010602011771号