- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2016
06:20 AM
01-19-2016
06:20 AM
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.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2016
09:45 AM
01-19-2016
09:45 AM
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;
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2016
09:45 AM