你现在的位置:首页 > PHP网站建设知识库 > ZenCart > 正文

zencart如何清空商品演示数据和没有商品数据的

清空zencart商品商品、属性、分类 
 
TRUNCATE TABLE categories; 
TRUNCATE TABLE categories_description; 
# 清空商品和属性 
TRUNCATE TABLE media_clips; 
TRUNCATE TABLE media_manager; 
TRUNCATE TABLE media_to_products; 
TRUNCATE TABLE media_types; 
TRUNCATE TABLE music_genre; 
TRUNCATE TABLE product_music_extra; 
TRUNCATE TABLE product_types_to_category; 
TRUNCATE TABLE products; 
TRUNCATE TABLE products_attributes; 
TRUNCATE TABLE products_attributes_download; 
TRUNCATE TABLE products_description; 
TRUNCATE TABLE products_discount_quantity; 
TRUNCATE TABLE products_notifications; 
TRUNCATE TABLE products_options; 
TRUNCATE TABLE products_options_types; 
TRUNCATE TABLE products_options_values; 
TRUNCATE TABLE products_options_values_to_products_options; 
TRUNCATE TABLE products_to_categories; 
TRUNCATE TABLE record_artists; 
TRUNCATE TABLE record_artists_info; 
TRUNCATE TABLE record_company; 
TRUNCATE TABLE record_company_info; 
# 清空客户评论 
TRUNCATE TABLE reviews; 
TRUNCATE TABLE reviews_description; 
# 清空推荐商品 
TRUNCATE TABLE featured; 
# 清空厂家及资料 
TRUNCATE TABLE manufacturers; 
TRUNCATE TABLE manufacturers_info; 
# 清空团体价格 
TRUNCATE TABLE group_pricing; 
# 清空促销商品 
TRUNCATE TABLE salemaker_sales; 
# 清空特价商品 
TRUNCATE TABLE specials;