zencart SQL命令一键清空全部商品数据 适用最新版1.5.6c

TRUNCATE TABLE categories;
TRUNCATE TABLE categories_description;
TRUNCATE TABLE meta_tags_categories_description;

TRUNCATE TABLE products;
TRUNCATE TABLE products_attributes;
TRUNCATE TABLE products_description;
TRUNCATE TABLE products_to_categories;
TRUNCATE TABLE meta_tags_products_description;

TRUNCATE TABLE featured;
TRUNCATE TABLE specials;

TRUNCATE TABLE reviews;
TRUNCATE TABLE reviews_description;

 

复制上面命令，网站后台登录，tools-install sql patch