Zencart如何清空商品演示数据?

2010-06-21 at 11:26 上午 kk

通常情况下,有些安装好zen-cart的朋友有安装演示数据或者已经有其它数据需要清空,一般的操作是通过后台的产品管理,一个一个来删除,操作起来比较麻烦。以下是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;

------------------------------------------------------------------------------------------
作者:
宽宽@网站策划运营
本站所有文章均为宽宽原创。
版权所有。转载时必须以链接形式注明作者和原始出处及本声明。

Leave a Reply