一.清除后台商品+库存+订单流水等数据

打开PHPMyadmin或者Navicate等Mysql数据库可视化工具,执行一下SQL语句即可:

TRUNCATE `ice_account`;

TRUNCATE `ice_account_info`;

TRUNCATE `ice_bd_item_combsplit`;

TRUNCATE `ice_bd_item_combsplit_breakpoint`;

TRUNCATE `ice_pm_sheet_detail`;

TRUNCATE `ice_pm_sheet_master`;

TRUNCATE `ice_pos_branch_stock`;

TRUNCATE `ice_im_check_detail`;

TRUNCATE `ice_im_check_init`;

TRUNCATE `ice_im_check_master`;

TRUNCATE `ice_im_check_sum`;

TRUNCATE `ice_im_sheet_detail`;

TRUNCATE `ice_im_sheet_master`;

TRUNCATE `ice_pc_branch_price`;

TRUNCATE `ice_pc_branch_price_breakpoint`;

TRUNCATE `ice_pos_feedback`;

TRUNCATE `ice_pc_price_flow_detail`;

TRUNCATE `ice_pc_price_flow_master`;

TRUNCATE `ice_pos_pay`;

TRUNCATE `ice_pos_payflow`;

TRUNCATE `ice_pos_saleflow`;

TRUNCATE `ice_pos_viplist`;

TRUNCATE `ice_stock_flow`;

TRUNCATE `ice_integral`;

TRUNCATE `ice_integral_member`;

TRUNCATE `ice_news`;

TRUNCATE `ice_news_type`;

TRUNCATE `ice_item_cls`;

TRUNCATE `ice_member`;

TRUNCATE `ice_member_level`;

TRUNCATE `ice_member_money`;

TRUNCATE `ice_pos_account`;

TRUNCATE `ice_pos_branch_info`;

TRUNCATE `ice_pos_branch_stock_breakpoint`;

TRUNCATE `ice_pos_daysum`;

TRUNCATE `ice_pos_status`;

TRUNCATE `ice_pos_sync`;

TRUNCATE `ice_sp_infos`;

TRUNCATE `ice_sp_infos_breakpoint`;

TRUNCATE `ice_api_webservice`;

TRUNCATE `ice_pos_sync`;

TRUNCATE `ice_bd_item_cls`;

TRUNCATE `ice_bd_item_cls_breakpoint`;

TRUNCATE `ice_bd_item_info`;

TRUNCATE `ice_bd_item_info_breakpoint`;

TRUNCATE `ice_pos_branch_stock`;

TRUNCATE `ice_pos_branch_stock_breakpoint`;

TRUNCATE `ice_stock_flow`;

TRUNCATE `ice_pc_branch_price`;

TRUNCATE `ice_pc_price_flow_detail`;

TRUNCATE `ice_pc_price_flow_master`;

二.重置C#客户端的数据和配置文件

１. 删除配置文件

　　Application.xml、flowno.isf、ICEPOS.ini

 2. 删除数据库文件

       item.db (商品、门店、配置信息等离线数据库) 、sale.db （销售流水、会员消费等离线数据）