zen cart 常用

#清空客户和定单信息

TRUNCATE TABLE `customers`;

TRUNCATE TABLE `customers_basket`;

TRUNCATE TABLE `customers_basket_attributes`;

TRUNCATE TABLE `customers_info`;

TRUNCATE TABLE `orders`;

TRUNCATE TABLE `orders_products`;

TRUNCATE TABLE `orders_status_history`;

TRUNCATE TABLE `orders_products_attributes`;

TRUNCATE TABLE `orders_total`;

TRUNCATE TABLE admin_activity_log ;

TRUNCATE TABLE address_book ;

TRUNCATE TABLE counter ;

TRUNCATE TABLE counter_history ;

TRUNCATE TABLE coupons_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_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 categories;

TRUNCATE TABLE categories_description;

TRUNCATE TABLE  meta_tags_categories_description;

TRUNCATE TABLE  meta_tags_products_description;

TRUNCATE TABLE coupons;

TRUNCATE TABLE coupon_redeem_track;

TRUNCATE TABLE coupon_gv_customer;

TRUNCATE TABLE coupon_email_track ;

# 清空客户评论

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;

#广告

TRUNCATE TABLE  banners;

TRUNCATE TABLE banners_history;

#插件SEO

TRUNCATE TABLE  seo_cache ;