Hey there.
I clear SQL with this script.
That works perfect.
Now i have no product online. But when i check categories at the backend there is a amount of products deposited.
I add a screenshot.
Can someone know how can i clear all old categorie staff but keep them (empty) with same ID.
screenshot -> http://imgur.com/SDVzqof
Thx.
Solved! Go to Solution.
That SQL works for me.
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_category_product`; TRUNCATE TABLE `catalog_category_product_index`; SET FOREIGN_KEY_CHECKS = 1;