SET FOREIGN_KEY_CHECKS=0; INSERT INTO `ls_activity_area` (`id`,`name`,`title`,`image`,`status`,`create_time`,`update_time`,`del`) VALUES (1,'热销榜单','开学季必备','/uploads/images/background/20201210/a3bf099101793a2e0bfe087b92e51403.png',1,1607587777,1607588071,0); INSERT INTO `ls_activity_area` (`id`,`name`,`title`,`image`,`status`,`create_time`,`update_time`,`del`) VALUES (2,'品牌闪购','享惊喜折扣','/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png',1,1607588059,NULL,0); INSERT INTO `ls_activity_area` (`id`,`name`,`title`,`image`,`status`,`create_time`,`update_time`,`del`) VALUES (3,'新品首发','抢惊喜福利','/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png',1,1607588142,NULL,0); INSERT INTO `ls_activity_goods` ( `id`, `activity_id`, `goods_id`, `create_time`, `update_time`, `del` ) VALUES ( 1, 1, 1, 1607588194, NULL, 0 ); INSERT INTO `ls_activity_goods` ( `id`, `activity_id`, `goods_id`, `create_time`, `update_time`, `del` ) VALUES ( 2, 2, 9, 1607588206, NULL, 0 ); INSERT INTO `ls_activity_goods` ( `id`, `activity_id`, `goods_id`, `create_time`, `update_time`, `del` ) VALUES ( 3, 3, 10, 1607588218, NULL, 0 ); INSERT INTO `ls_activity_goods` ( `id`, `activity_id`, `goods_id`, `create_time`, `update_time`, `del` ) VALUES ( 4, 1, 8, 1607588231, NULL, 0 ); INSERT INTO `ls_activity_goods` ( `id`, `activity_id`, `goods_id`, `create_time`, `update_time`, `del` ) VALUES ( 5, 2, 3, 1607588241, NULL, 0 ); INSERT INTO `ls_activity_goods` ( `id`, `activity_id`, `goods_id`, `create_time`, `update_time`, `del` ) VALUES ( 6, 3, 7, 1607588250, NULL, 0 ); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (1,'妥妥的',1,1,'/uploads/images/background/20201210/1fd2fe53cd9953f78dc312165713dd2d.png',1,'0',NULL,1,0,0,50,1605520417,1607589473,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (2,'分销会员',3,3,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1605521571,1607589667,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (3,'广告广告',2,2,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1605521876,1607589488,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (7,'秒杀广告',16,2,'/uploads/images/background/20201210/1fd2fe53cd9953f78dc312165713dd2d.png',1,'0',NULL,1,0,0,50,1605580755,1607589707,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (8,'热销榜单',17,2,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1605581057,1607589703,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (9,'分类',6,3,'/uploads/images/background/20201210/1fd2fe53cd9953f78dc312165713dd2d.png',1,'1',NULL,1,0,0,50,1605583712,1607589673,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (10,'秒杀',18,2,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1605592289,1607589692,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (11,'味儿',18,2,'/uploads/images/background/20201210/1fd2fe53cd9953f78dc312165713dd2d.png',1,'0',NULL,1,0,0,50,1605592579,1607589688,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (12,'测试',4,1,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1605775436,1607589463,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (13,'智能',16,2,'/uploads/images/background/20201210/1fd2fe53cd9953f78dc312165713dd2d.png',1,'0',NULL,1,0,0,50,1605854094,1607589699,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (14,'秒杀广告位',14,1,'/uploads/images/background/20201210/a664cf34b0a5f5de424ab24701f41c5a.jpeg',1,'0',NULL,1,0,0,50,1605855781,1607589445,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (15,'秒杀广告2',14,1,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1605855818,1607589423,0); INSERT INTO `ls_ad` (`id`,`name`,`pid`,`client`,`image`,`link_type`,`link`,`category_id`,`status`,`start_time`,`end_time`,`sort`,`create_time`,`update_time`,`del`) VALUES (16,'活动开启',4,1,'/uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1,'0',NULL,1,0,0,50,1606443246,1607589404,0); INSERT INTO `ls_article` (`id`,`cid`,`title`,`synopsis`,`image`,`is_notice`,`content`,`visit`,`sort`,`is_show`,`create_time`,`update_time`,`del`,`likes`) VALUES (1,1,'电商商城管理规章制度','电商商城管理规章制度','/uploads/images/background/20201210/5b82112f4d294b11b80da87edd422772.jpg',1,'

今年，以直播带货为代表的“内容+电商”成为淘宝、京东等电商平台和以央视为代表的媒体共同探索的变现新渠道。

作为产业门类齐全、产业规模庞大的新型主流媒体及综合文化产业集团，SMG如何利用广电平台多渠道流量矩阵创新全域营销玩法？

一切都在11月27日B+商城举办的“没内容，不电商”发布会上揭晓。从7月初成立至今，B+商城以东方购物视频电商为基础，依托SMG既有的相关服务能力和体系，面向都市成熟人群和家庭需求，正在向“魔都”生活第一入口的方向迈进。它的成长体现了SMG内容和渠道打通、大屏和小屏联动所发挥的巨大效应。


',2,10,1,1607568471,NULL,0,0); INSERT INTO `ls_article` (`id`,`cid`,`title`,`synopsis`,`image`,`is_notice`,`content`,`visit`,`sort`,`is_show`,`create_time`,`update_time`,`del`,`likes`) VALUES (2,1,'双12活动预告~~~','双12活动预告~~~','/uploads/images/background/20201210/a664cf34b0a5f5de424ab24701f41c5a.jpeg',1,'

LikeShop商城定于2020-12-12日开启限量五折活动，不要错过哦！！！

届时会有大牌明星在线派送现金礼包！！！

',1,9,1,1607568882,NULL,0,0); INSERT INTO `ls_article_category` (`id`,`name`,`sort`,`is_show`,`create_time`,`update_time`,`del`) VALUES (1,'商城公告',0,1,1607568395,NULL,0); INSERT INTO `ls_article_category` (`id`,`name`,`sort`,`is_show`,`create_time`,`update_time`,`del`) VALUES (2,'用户公告',0,1,1607568405,NULL,0); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (1,'marketing','invited_award_integral','10',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (2,'marketing','order_award_integral','20',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (3,'marketing','register_award_integral_status','1',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (4,'marketing','register_award_integral','20',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (5,'marketing','register_award_coupon_status','1',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (6,'marketing','register_award_coupon','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (7,'marketing','integral_deduction_status','1',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (8,'marketing','integral_deduction_money','0.01',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (9,'sign_rule','instructions','1.每天签到可以获得每天签到奖励；\n2.每日最多可签到1次，断签则会重新计算连签天数，达到连续天数后即可获得连续奖励；\n3.活动以及奖励最终解释权归商家所有。',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (10,'mnp','name','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (11,'mnp','original_id','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (12,'mnp','qr_code','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (13,'mnp','business_domain','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (14,'mnp','url','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (15,'mnp','token','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (16,'mnp','encoding_ses_key','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (17,'mnp','encryption_type','',NULL); INSERT INTO `ls_config` (`id`,`type`,`name`,`value`,`update_time`) VALUES (18,'mnp','data_type','',NULL); INSERT INTO `ls_coupon` (`id`,`name`,`send_time_start`,`send_time_end`,`money`,`condition_type`,`condition_money`,`send_total_type`,`send_total`,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,`get_type`,`get_num_type`,`get_num`,`use_goods_type`,`status`,`create_time`,`update_time`,`del`) VALUES (1,'满500可用',1607588307,1639065600,500.00,2,500.00,1,0,1,1607588325,1639065600,0,1,1,0,1,1,1607588370,1607588370,0); INSERT INTO `ls_coupon` (`id`,`name`,`send_time_start`,`send_time_end`,`money`,`condition_type`,`condition_money`,`send_total_type`,`send_total`,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,`get_type`,`get_num_type`,`get_num`,`use_goods_type`,`status`,`create_time`,`update_time`,`del`) VALUES (2,'满50可用',1607588378,1623945600,5.00,2,50.00,2,2000,2,0,0,10,1,2,10,1,1,1607588445,1607588445,0); INSERT INTO `ls_coupon` (`id`,`name`,`send_time_start`,`send_time_end`,`money`,`condition_type`,`condition_money`,`send_total_type`,`send_total`,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,`get_type`,`get_num_type`,`get_num`,`use_goods_type`,`status`,`create_time`,`update_time`,`del`) VALUES (3,'新人专享',1607588457,1671783661,10.00,2,10.00,1,0,2,0,0,10,1,2,1,1,1,1607588498,1607588498,0); INSERT INTO `ls_coupon` (`id`,`name`,`send_time_start`,`send_time_end`,`money`,`condition_type`,`condition_money`,`send_total_type`,`send_total`,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,`get_type`,`get_num_type`,`get_num`,`use_goods_type`,`status`,`create_time`,`update_time`,`del`) VALUES (4,'大牌商品专享',1607588529,1619107200,500.00,2,5000.00,2,600,2,0,0,10,1,3,0,2,1,1607588599,1607588599,0); INSERT INTO `ls_coupon` (`id`,`name`,`send_time_start`,`send_time_end`,`money`,`condition_type`,`condition_money`,`send_total_type`,`send_total`,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,`get_type`,`get_num_type`,`get_num`,`use_goods_type`,`status`,`create_time`,`update_time`,`del`) VALUES (5,'后台赠送',1607588613,1640361600,500.00,1,0.00,1,0,2,0,0,10,2,1,0,1,1,1607588676,1607588676,0); INSERT INTO `ls_coupon_goods` (`id`,`coupon_id`,`goods_id`,`create_time`) VALUES (1,4,9,1607588599); INSERT INTO `ls_dev_region` (`id`,`parent_id`,`level`,`name`,`short`,`city_code`,`zip_code`,`gcj02_lng`,`gcj02_lat`,`db09_lng`,`db09_lat`,`remark1`,`remark2`) VALUES (100000,0,0,'中国','中国',NULL,NULL,'116.3683244','39.915085','116.374821','39.92105','行政区',NULL); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (1,'home_icon_@3x.png',0,1,'uploads/images/background/20201210/b80089e7224871ee70ef7014453b6a28.png',1607566134,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (2,'home_icon_collect@3x(1).png',0,1,'uploads/images/background/20201210/643833719ae963e6a9035e4b98a6279c.png',1607566134,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (3,'home_icon_member@3x.png',0,1,'uploads/images/background/20201210/1fbb2fb37597896efd7b95506ed7cdda.png',1607566134,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (4,'home_icon_collect@3x.png',0,1,'uploads/images/background/20201210/3a3228fcfdb8fa0808a9e67b6c43df53.png',1607566134,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (5,'home_icon_coupon@3x.png',0,1,'uploads/images/background/20201210/520c72e1a1d48cb088b0f070d77bc031.png',1607566134,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (6,'home_icon_newproduct@3x.png',0,1,'uploads/images/background/20201210/1668b4385dd0296ae033da6e6ad5f125.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (7,'home_icon_newproduct@3x(1).png',0,1,'uploads/images/background/20201210/bbd816d5b586cdeca8e87dd7c06e2fcf.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (8,'home_icon_sale@3x.png',0,1,'uploads/images/background/20201210/94a0d54ab18f3d93072c73a1e0dcba17.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (9,'home_icon_news@3x.png',0,1,'uploads/images/background/20201210/06332ce973851322e050de07a7b7631f.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (10,'home_icon_signIn@3x.png',0,1,'uploads/images/background/20201210/0158588a36f9f0ae6a58509f6dd0d80e.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (11,'banner@3x.png',0,1,'uploads/images/background/20201210/f0f1dc5b175b270c69ee86c52c37f00e.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (12,'icon_toutiao@3x.png',0,1,'uploads/images/background/20201210/c104274c93fc677e1705197574ac5be9.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (13,'No.1@3x.png',0,1,'uploads/images/background/20201210/2065def29f8a34d94635eb37422191c2.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (14,'No.2@3x.png',0,1,'uploads/images/background/20201210/d5ea0605f6c904aca66dca006694e088.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (15,'No.3@3x.png',0,1,'uploads/images/background/20201210/83294baa4cfa0fbc1e03653007828c67.png',1607566135,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (16,'icon_my_wallet@3x.png',0,1,'uploads/images/background/20201210/d650559b128bfca62870205445365ac8.png',1607567013,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (17,'icon_my_address@3x.png',0,1,'uploads/images/background/20201210/dd7b3e6885221f0c94a7092dc95e1f8f.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (18,'icon_my_collection@3x.png',0,1,'uploads/images/background/20201210/ad841b1109ad0d5a8f40585d47ecd8f2.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (19,'icon_my_huiyuan@3x.png',0,1,'uploads/images/background/20201210/29474ae22229ae68460c51466e47ce56.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (20,'icon_my_coupon@3x.png',0,1,'uploads/images/background/20201210/c03fd3359bcb6a575a479dc41a013fff.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (21,'icon_my_fahuo@3x.png',0,1,'uploads/images/background/20201210/f36785f5c21da9b0e2522b341b7d2daf.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (22,'icon_my_help@3x.png',0,1,'uploads/images/background/20201210/f6189105a4bfb39631e193a83047ad7a.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (23,'icon_my_kanjia@3x.png',0,1,'uploads/images/background/20201210/d01e2ab0defbad866f19420e6483f7b2.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (24,'icon_my_fenxiao@3x.png',0,1,'uploads/images/background/20201210/1226785362c5f02ef2616be8a1a5737a.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (25,'icon_my_payment@3x.png',0,1,'uploads/images/background/20201210/6658970c34316982a317f16a7a573a3d.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (26,'icon_my_pingjia@3x.png',0,1,'uploads/images/background/20201210/ead90dc1a6bb3c9a2ec20cb968c409ee.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (27,'icon_my_shouhou@3x.png',0,1,'uploads/images/background/20201210/739f6f1223c71a5ead9064ef61e48ab4.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (28,'icon_my_shouhuo@3x.png',0,1,'uploads/images/background/20201210/db7bb9bcd979c260cc9e4497ce260444.png',1607567023,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (29,'1212.jpg',0,1,'uploads/images/background/20201210/5b82112f4d294b11b80da87edd422772.jpg',1607568456,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (30,'1acd6abcaba4b25bcf91f2c8525905ed',0,1,'uploads/images/background/20201210/a664cf34b0a5f5de424ab24701f41c5a.jpeg',1607568678,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (31,'签到.png',0,1,'uploads/images/background/20201210/f7c7bdc7e0b7fc3d7fbd25d67bd6f7d3.png',1607568975,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (32,'icon_discount@3x.png',0,1,'uploads/images/background/20201210/35e522faf28bee80048703f4a9f97f99.png',1607569362,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (33,'icon_yunfei@3x.png',0,1,'uploads/images/background/20201210/001258dae3fb475ceecb294dfb0314fd.png',1607569362,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (34,'icon_customer@3x.png',0,1,'uploads/images/background/20201210/b993e87092f20dbc7b32536d6a867ccb.png',1607569362,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (35,'icon_coupon@3x.png',0,1,'uploads/images/background/20201210/a98c5a589526627f9458bdf4ed640bd9.png',1607569362,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (36,'icon_grade4@3x.png',0,1,'uploads/images/background/20201210/1bf35b2f5eacab8ac547b64218a6fdc9.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (37,'icon_grade3@3x.png',0,1,'uploads/images/background/20201210/79ee4347c8066f965c9ce7034f249cea.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (38,'icon_grade2@3x.png',0,1,'uploads/images/background/20201210/eab147f969fce1475d4892c57256f8ec.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (39,'bg_silverMember@3x.png',0,1,'uploads/images/background/20201210/b3ea3f1db613eecfe7ae8e0cf2c155b3.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (40,'5443.png',0,1,'uploads/images/background/20201210/263af68dbb3a7beb43d13273abddef59.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (41,'icon_grade@3x.png',0,1,'uploads/images/background/20201210/d74e01d4a8b86f331fcca2f485080353.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (42,'34532.png',0,1,'uploads/images/background/20201210/2bb17478228b324a613ffa3565a48737.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (43,'12424.png',0,1,'uploads/images/background/20201210/e00c91e6d52bcf8fc117bf9d4cc8213d.png',1607569662,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (44,'1607569881(1).png',0,1,'uploads/images/background/20201210/dd2610485ad76c0d24f88f8ce58d3dd5.png',1607569911,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (45,'1607570636(1).png',0,1,'uploads/images/background/20201210/2dad83f2345046d47045c160a3db6896.png',1607570661,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (46,'1607570777(1).png',0,1,'uploads/images/background/20201210/10b16861c6eeb1e9a744b86dd69b051f.png',1607570792,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (47,'1607570850(1).png',0,1,'uploads/images/background/20201210/8529fda6cb6c3cf62c084df9c7c911a9.png',1607570882,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (48,'1607570949(1).png',0,1,'uploads/images/background/20201210/720a002e5c6bdf95a2dd3c31737d0e57.png',1607571037,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (49,'晨光中性笔.png',0,1,'uploads/images/background/20201210/dceddf4cb321cf612eee441477d3b93f.png',1607571355,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (50,'晨光铅笔.png',0,1,'uploads/images/background/20201210/47829c77b7b5135de799182d1c197746.png',1607571557,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (51,'1607571648(1).png',0,1,'uploads/images/background/20201210/45b6bb2224e4051ecf407cabb54cd781.png',1607571735,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (52,'1607571666(1).png',0,1,'uploads/images/background/20201210/910e9d4fc9f10c7a11825315785c555d.png',1607571735,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (53,'1607571971(1).png',0,1,'uploads/images/background/20201210/e645ff4cbef1fae6a6169624029eb214.png',1607572040,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (54,'1607571961(1).png',0,1,'uploads/images/background/20201210/c55d952325ac38959c57e127d97c5592.png',1607572040,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (55,'1607571942(1).png',0,1,'uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png',1607572040,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (56,'1607571984(1).png',0,1,'uploads/images/background/20201210/3261d7a8935ca47e0f19b354a36bab79.png',1607572040,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (57,'1607572189(1).png',0,1,'uploads/images/background/20201210/a3bf099101793a2e0bfe087b92e51403.png',1607572240,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (58,'1607572177(1).png',0,1,'uploads/images/background/20201210/6515fd4b2e7a1932f76ec5232fe22fdf.png',1607572240,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (59,'1607572168(1).png',0,1,'uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png',1607572240,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (60,'1607572367(1).png',0,1,'uploads/images/background/20201210/d97a7d56854eb8cd5afa228b1d9608c3.png',1607572407,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (61,'1607572344(1).png',0,1,'uploads/images/background/20201210/956e95bc35d0a8005255889036e9aae5.png',1607572407,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (62,'1607572356(1).png',0,1,'uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png',1607572407,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (63,'1607572740(1).png',0,1,'uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png',1607572887,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (64,'1607572776(1).png',0,1,'uploads/images/background/20201210/532a61a9cb3294ea13015c11e51d243f.png',1607572887,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (65,'1607572754(1).png',0,1,'uploads/images/background/20201210/2ff3147b913abbcbb39646de816eb5d2.png',1607572887,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (66,'1607580094(1).png',0,1,'uploads/images/background/20201210/ccd5fe4fe21804ee7e33174cf347bbb2.png',1607580122,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (67,'1607580094.png',0,1,'uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png',1607580122,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (68,'1607580094(2).png',0,1,'uploads/images/background/20201210/6c7921165fab863c86018878e839bc60.png',1607580122,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (69,'1607584417(1).png',0,1,'uploads/images/background/20201210/5e11c751c7e662764764e132ab6a8f72.png',1607584436,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (70,'1607584630(1).png',0,1,'uploads/images/background/20201210/4985ef90fea9fc132e37af97a1f0597f.png',1607584686,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (71,'1607584620.png',0,1,'uploads/images/background/20201210/3f25d88bc10820af2fb3583484de06c8.png',1607584686,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (72,'1607585000(1).png',0,1,'uploads/images/background/20201210/63d91cdfdb659e57a10a99d1cf44567e.png',1607585026,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (73,'1607585522.png',0,1,'uploads/images/background/20201210/1860d0763b8703121d93cf0b8a3e1e1e.png',1607585551,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (74,'1607585516(1).png',0,1,'uploads/images/background/20201210/989bbc585e0eaa435d1c0486008ad52a.png',1607585551,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (75,'1607585516(2).png',0,1,'uploads/images/background/20201210/f245c44d136296f80071a26765e93cdf.png',1607585551,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (76,'1607585816(1).png',0,1,'uploads/images/background/20201210/254590f48981940296d63640c64cae83.png',1607585908,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (77,'1607585802(1).png',0,1,'uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png',1607585908,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (78,'1607585829(1).png',0,1,'uploads/images/background/20201210/930d0719e718db9bfaf2f3acacc1fbe8.png',1607585908,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (79,'88bc1a42240ee3aba127b3fc3410d9a5',0,1,'uploads/images/background/20201210/386e909e5887dcaffe99a6200d591394.png',1607589348,0,0); INSERT INTO `ls_file` (`id`,`name`,`cate_id`,`type`,`uri`,`create_time`,`del`,`partner_id`) VALUES (80,'1acd6abcaba4b25bcf91f2c8525905ed',0,1,'uploads/images/background/20201210/1fd2fe53cd9953f78dc312165713dd2d.png',1607589434,0,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (1,'晨光中性笔笔芯黑0.5mm黑色碳素签字笔GP-1008按动式水笔学生考试用蓝黑医生处方笔教师专用红笔圆珠笔文具','2646541621',1,4,9,1,1,1,'/uploads/images/background/20201210/45b6bb2224e4051ecf407cabb54cd781.png',NULL,NULL,'耐用好书写','
品牌名称：M＆G/晨光

产品参数：


',0,0,6873,5,1,44.82,44.82,55.00,9863,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607571853,1607571834,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (2,'晨光文具速干中性笔直液式签字笔学生考试大容量全针管子弹头水笔直液式笔黑色0.5/0.38','75687',1,4,9,1,1,1,'/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png',NULL,NULL,'好用','
品牌名称：M＆G/晨光

产品参数：

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

',0,0,6863,1,1,43.90,43.90,78.00,8676,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607572135,1607572125,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (3,'晨光文具经典六角木杆铅笔中小学生考试绘图铅笔 2B铅笔练字笔20支 AWP35715','654161',1,4,10,1,1,1,'/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png',NULL,NULL,'好用','
品牌名称：M＆G/晨光

产品参数：

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

',0,0,35368,3,1,13.50,13.50,21.00,56832,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607572312,1607572580,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (4,'晨光文具可削铅笔 六角2B 红黑抽条 木杆铅笔 儿童铅笔 AWP30804','62649526',1,4,10,1,1,1,'/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png',NULL,NULL,'好用','
品牌名称：M＆G/晨光

产品参数：

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

',0,0,43675,3,1,7.00,7.00,8.00,66533,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607572484,1607572580,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (5,'小米文具可削铅笔 六角2B 红黑抽条 木杆铅笔 儿童铅笔 AWP30804','57687878',1,5,12,4,1,1,'/uploads/images/background/20201210/956e95bc35d0a8005255889036e9aae5.png',NULL,NULL,'好用','
品牌名称：小米

产品参数：

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

',0,0,3263,1,1,6.00,6.00,7.00,9999,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607573007,1607572973,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (6,'小米大容量一体式全针管中性笔办公签字笔5倍书写长度学生考试刷题作业神器水笔1支顶5支','65682',1,5,11,4,1,1,'/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png',NULL,NULL,'好用','
品牌名称：小米

产品参数：

温馨提示：商品外盒或塑封仅作为包装材料使用，在快递运输过程中可能出现不同程度的变形或损坏，均为正常现象，不作为售后理由处理，望亲见谅！

',0,0,12352,0,1,29.00,29.00,69.00,36589,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,0,0,0,0,0,NULL,1607573028,1607572975,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (7,'得力直液式走珠笔0.5mm红色黑色中性笔学生用子弹头碳素笔全针管签字笔黑红笔水笔考试专用笔批发直液水性笔','2354385',1,6,13,3,1,1,'/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png',NULL,NULL,'好用','
品牌名称：Deli/得力

产品参数：

',0,0,1365,0,1,32.80,32.80,32.80,3556,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607583199,1607586217,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (8,'HERO/英雄钢笔HS208女神钢笔成人女士商务高档礼盒装办公时尚练字女生专用精致送礼官方正品代写贺卡','356161',1,7,14,5,1,1,'/uploads/images/background/20201210/5e11c751c7e662764764e132ab6a8f72.png',NULL,NULL,'好用高雅','
品牌名称：HERO/英雄

产品参数：

\"\"
\"\"\"\"
\"\"\"\"\"\"
\"\"\"\"\"\"\"\"

\"刻字\"
1709484353
',0,0,352,4,1,1359.00,1359.00,2598.00,1069,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607584899,1607586217,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (9,'日本进口pilot百乐贵客钢笔 硬橡胶生漆18k金笔fkv-88sr莳绘30号金尖限定万年笔商务礼品套装','65986',1,8,15,2,1,1,'/uploads/images/background/20201210/f245c44d136296f80071a26765e93cdf.png',NULL,NULL,'好用好看实用','
品牌名称：PILOT/百乐

产品参数：







自定义内容区

',0,0,98,0,1,6860.00,6860.00,9800.00,1260,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607585729,1607586216,0); INSERT INTO `ls_goods` (`id`,`name`,`code`,`first_category_id`,`second_category_id`,`third_category_id`,`brand_id`,`supplier_id`,`status`,`image`,`video`,`poster`,`remark`,`content`,`sort`,`sales_sum`,`virtual_sales_sum`,`click_count`,`spec_type`,`max_price`,`min_price`,`market_price`,`stock`,`stock_warn`,`is_show_stock`,`free_shipping_type`,`free_shipping`,`free_shipping_template_id`,`is_commission`,`first_ratio`,`second_ratio`,`three_ratio`,`is_share_bouns`,`region_ratio`,`shareholder_ratio`,`is_new`,`is_best`,`is_like`,`is_team`,`is_integral`,`is_member`,`give_integral_type`,`give_integral`,`create_time`,`update_time`,`del`) VALUES (10,'顺丰包邮 12期免息日本PILOT百乐Justus 95钢笔14K金尖FJ-3MR可调书写软硬金笔成人书法练字商务办公送礼盒装','656251',1,8,15,2,1,1,'/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png',NULL,NULL,'好看','
品牌名称：PILOT/百乐

产品参数：










自定义内容区

',0,0,685,0,1,1680.00,1680.00,2400.00,2369,0,1,1,0.00,0,1,'','','',0,NULL,NULL,1,1,1,0,0,0,0,NULL,1607586032,1607586216,0); INSERT INTO `ls_goods_brand` (`id`,`name`,`image`,`initial`,`is_show`,`sort`,`remark`,`create_time`,`update_time`,`del`) VALUES (1,'晨光文具','/uploads/images/background/20201210/dd2610485ad76c0d24f88f8ce58d3dd5.png','C',1,0,'文具专卖品牌',1607569933,1607570803,0); INSERT INTO `ls_goods_brand` (`id`,`name`,`image`,`initial`,`is_show`,`sort`,`remark`,`create_time`,`update_time`,`del`) VALUES (2,'百乐','/uploads/images/background/20201210/2dad83f2345046d47045c160a3db6896.png','B',1,0,'',1607570669,NULL,0); INSERT INTO `ls_goods_brand` (`id`,`name`,`image`,`initial`,`is_show`,`sort`,`remark`,`create_time`,`update_time`,`del`) VALUES (3,'得力','/uploads/images/background/20201210/10b16861c6eeb1e9a744b86dd69b051f.png','D',1,0,'',1607570799,NULL,0); INSERT INTO `ls_goods_brand` (`id`,`name`,`image`,`initial`,`is_show`,`sort`,`remark`,`create_time`,`update_time`,`del`) VALUES (4,'小米','/uploads/images/background/20201210/8529fda6cb6c3cf62c084df9c7c911a9.png','X',1,0,'',1607570889,NULL,0); INSERT INTO `ls_goods_brand` (`id`,`name`,`image`,`initial`,`is_show`,`sort`,`remark`,`create_time`,`update_time`,`del`) VALUES (5,'英雄','/uploads/images/background/20201210/720a002e5c6bdf95a2dd3c31737d0e57.png','Y',1,0,'',1607571044,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (1,'文具',0,1,0,1,0,'/uploads/images/background/20201210/d74e01d4a8b86f331fcca2f485080353.png','',1607570112,1607570568,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (2,'专场推荐',0,1,0,1,0,'/uploads/images/background/20201210/eab147f969fce1475d4892c57256f8ec.png','',1607570127,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (3,'热门分类',0,1,0,1,0,'/uploads/images/background/20201210/79ee4347c8066f965c9ce7034f249cea.png','',1607570147,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (4,'晨光',1,2,0,1,0,'/uploads/images/background/20201210/dd2610485ad76c0d24f88f8ce58d3dd5.png','',1607570328,1607570603,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (5,'小米',1,2,0,1,0,'/uploads/images/background/20201210/8529fda6cb6c3cf62c084df9c7c911a9.png','',1607571143,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (6,'得力',1,2,0,1,0,'/uploads/images/background/20201210/10b16861c6eeb1e9a744b86dd69b051f.png','',1607571159,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (7,'英雄',1,2,0,1,0,'/uploads/images/background/20201210/720a002e5c6bdf95a2dd3c31737d0e57.png','',1607571185,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (8,'百乐',1,2,0,1,0,'/uploads/images/background/20201210/2dad83f2345046d47045c160a3db6896.png','',1607571205,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (9,'中性笔',4,3,0,1,0,'/uploads/images/background/20201210/dceddf4cb321cf612eee441477d3b93f.png','',1607571364,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (10,'铅笔',4,3,0,1,0,'/uploads/images/background/20201210/47829c77b7b5135de799182d1c197746.png','',1607571564,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (11,'小米中性笔',5,3,0,1,0,'/uploads/images/background/20201210/3261d7a8935ca47e0f19b354a36bab79.png','',1607572533,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (12,'小米铅笔',5,3,0,1,0,'/uploads/images/background/20201210/d97a7d56854eb8cd5afa228b1d9608c3.png','',1607572560,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (13,'得力中性笔',6,3,0,1,0,'/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png','',1607580133,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (14,'英雄钢笔',7,3,0,1,0,'/uploads/images/background/20201210/5e11c751c7e662764764e132ab6a8f72.png','',1607584443,NULL,0); INSERT INTO `ls_goods_category` (`id`,`name`,`pid`,`level`,`sort`,`is_show`,`is_recommend`,`image`,`remark`,`create_time`,`update_time`,`del`) VALUES (15,'百乐钢笔',8,3,0,1,0,'/uploads/images/background/20201210/63d91cdfdb659e57a10a99d1cf44567e.png','',1607585040,NULL,0); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (4,1,'/uploads/images/background/20201210/910e9d4fc9f10c7a11825315785c555d.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (5,1,'/uploads/images/background/20201210/45b6bb2224e4051ecf407cabb54cd781.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (6,1,'/uploads/images/background/20201210/dceddf4cb321cf612eee441477d3b93f.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (11,2,'/uploads/images/background/20201210/3261d7a8935ca47e0f19b354a36bab79.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (12,2,'/uploads/images/background/20201210/e645ff4cbef1fae6a6169624029eb214.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (13,2,'/uploads/images/background/20201210/c55d952325ac38959c57e127d97c5592.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (14,2,'/uploads/images/background/20201210/5a23d75c44ef8c293aa2a1bed1f10e41.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (15,3,'/uploads/images/background/20201210/6515fd4b2e7a1932f76ec5232fe22fdf.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (16,3,'/uploads/images/background/20201210/a3bf099101793a2e0bfe087b92e51403.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (17,3,'/uploads/images/background/20201210/2d62627fef767a38034162c066f9c253.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (18,4,'/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (19,4,'/uploads/images/background/20201210/d97a7d56854eb8cd5afa228b1d9608c3.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (20,4,'/uploads/images/background/20201210/956e95bc35d0a8005255889036e9aae5.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (27,5,'/uploads/images/background/20201210/4b06036c7e6c8f653a51fd94d4cb5bc5.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (28,5,'/uploads/images/background/20201210/d97a7d56854eb8cd5afa228b1d9608c3.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (29,5,'/uploads/images/background/20201210/956e95bc35d0a8005255889036e9aae5.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (30,6,'/uploads/images/background/20201210/532a61a9cb3294ea13015c11e51d243f.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (31,6,'/uploads/images/background/20201210/551c831039db5df10f16bbd40ba0ebc0.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (32,6,'/uploads/images/background/20201210/2ff3147b913abbcbb39646de816eb5d2.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (33,7,'/uploads/images/background/20201210/6c7921165fab863c86018878e839bc60.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (34,7,'/uploads/images/background/20201210/ccd5fe4fe21804ee7e33174cf347bbb2.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (35,7,'/uploads/images/background/20201210/d0fd78d3b5de45b870f43b6db3d5a0be.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (36,8,'/uploads/images/background/20201210/3f25d88bc10820af2fb3583484de06c8.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (37,8,'/uploads/images/background/20201210/4985ef90fea9fc132e37af97a1f0597f.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (38,8,'/uploads/images/background/20201210/5e11c751c7e662764764e132ab6a8f72.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (39,9,'/uploads/images/background/20201210/989bbc585e0eaa435d1c0486008ad52a.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (40,9,'/uploads/images/background/20201210/63d91cdfdb659e57a10a99d1cf44567e.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (41,9,'/uploads/images/background/20201210/1860d0763b8703121d93cf0b8a3e1e1e.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (42,9,'/uploads/images/background/20201210/f245c44d136296f80071a26765e93cdf.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (43,10,'/uploads/images/background/20201210/6768915899c1f445e43c886ad5e8668a.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (44,10,'/uploads/images/background/20201210/254590f48981940296d63640c64cae83.png'); INSERT INTO `ls_goods_image` (`id`,`goods_id`,`uri`) VALUES (45,10,'/uploads/images/background/20201210/930d0719e718db9bfaf2f3acacc1fbe8.png'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (1,'',1,'1','默认',55.00,44.82,23.00,9863,2.000,2.000,'22353'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (2,'',2,'2','默认',78.00,43.90,23.00,8676,2.000,2.000,'265368'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (3,'',3,'3','默认',21.00,13.50,3.00,56832,2.000,2.000,'1535838'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (4,'',4,'4','默认',8.00,7.00,2.00,66533,2.000,2.000,'6368369'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (5,'',5,'5','默认',7.00,6.00,2.00,9999,2.000,2.000,'635636'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (6,'',6,'6','默认',69.00,29.00,5.00,36589,2.000,2.000,'36838'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (7,'',7,'7','默认',32.80,32.80,16.00,3556,2.000,2.000,'5554554'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (8,'',8,'8','默认',2598.00,1359.00,823.00,1069,2.000,2.000,'5387398'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (9,'',9,'9','默认',9800.00,6860.00,2635.00,1260,2.000,2.000,'2266543'); INSERT INTO `ls_goods_item` (`id`,`image`,`goods_id`,`spec_value_ids`,`spec_value_str`,`market_price`,`price`,`cost_price`,`stock`,`volume`,`weight`,`bar_code`) VALUES (10,'',10,'10','默认',2400.00,1680.00,768.00,2369,2.000,2.000,'36555'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (1,1,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (2,2,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (3,3,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (4,4,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (5,5,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (6,6,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (7,7,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (8,8,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (9,9,'默认'); INSERT INTO `ls_goods_spec` (`id`,`goods_id`,`name`) VALUES (10,10,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (1,1,1,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (2,2,2,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (3,3,3,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (4,4,4,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (5,5,5,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (6,6,6,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (7,7,7,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (8,8,8,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (9,9,9,'默认'); INSERT INTO `ls_goods_spec_value` (`id`,`goods_id`,`spec_id`,`value`) VALUES (10,10,10,'默认'); INSERT INTO `ls_help` (`id`,`cid`,`title`,`synopsis`,`image`,`content`,`visit`,`sort`,`is_show`,`create_time`,`update_time`,`del`,`likes`) VALUES (1,1,'LikeShop商城使用手册','使用手册','/uploads/images/background/20201210/f7c7bdc7e0b7fc3d7fbd25d67bd6f7d3.png','

快速上手指南\nLikeShop使用手册\n1\n好象股份有限公司版权所有\nV 2.33\n快速上手指南\n尊敬的客户：\n欢迎使用LikeShop商城，此文档为快速上手指南，帮助您便捷、高效的完成商品采购。\n2\n目录 Contents\n*采购员进入03页阅读 *审批员进入25页阅读\n1、如何登录LikeShop商城·································P04\n采购员、审批员、管理员登录方式一致\n2、如何查找需要采购的商品····················P05\n多种方式找商品，快速便捷\n3、如何将商品加入购物车··················P06/09\n多种方式找商品，快速便捷\n4、如何结算购物车···································P10\n将购物车中的商品进行结算核对、提交\n5、如何提交采购订单··························P11/14\n采购订单提交给审批人审批\n6、如何查看自己的采购订单···················P15\n查看自己提交过的采购订单\n8、如何取消采购订单································P17\n取消不想要的订单\n10、如何查看订单统计·····························P19\n7、如何查看订单进展以及物流信息········P16\n在线追踪订单审批以及物流配送进度\n9、如何在线确认收货·································P18\n在线签收 部门统计、采购人统计、时间统计\n快速上手指南 3\n11、如何查看订单详情························P20\n部门、个人、商品订单详情\n15、如何修改密码、设置个人信息···P27 16、常见问题与回答··························P28\n修改密码、修改头像、设置信息\n14、如何审批订单························P25/26\n审批人员三种审批方式\n13、如何联系在线客服·······················P24\n在线客服咨询\n12、如何在线申请开票················P21/23\n支持专票、普票、电子发票\n快速上手指南 4\n➢ 如何登录LikeShop商城？\n当您需要登录LikeShop商城进行商品采购时：\n第1步：在浏览器中打开①LikeShop商城。\n第2步：点击页面顶端的②请登录，跳转到登录界面。\n第3步：在登录界面中输入③账号和密码，点击④登录即可。\n1\n2\n3\n4\n登录成功标志\n注意事项：\n如果忘记密码，请联系管\n理员，帮助您重置密码。\n快速上手指南 5\n➢ 如何查找需要采购的商品？\n当您需要查找办公用品时：\n方法一：账号登陆后，在首页①搜索框输入产品名称或型号或编号，再点击②搜索按钮。\n1\n2\n方法二：账号登陆后，鼠标悬停③商品分类中的主分类，再移动到次级分类，再点击④三级分类。\n3\n4\n说明：a、搜索或选择完成后，均直接进入商品列表页面。\nb、直接点击商品分类中的主分类后，跳转至该主分类下所有商品列表页面。\n快速上手指南 6\n方法一：商品列表页单个选购，在商品列表页面，鼠标停在商品图片上时，会浮现出购买商品的黄色\n图标，调整商品数量①调整商品数量，然后点击②加入购物车，此商品就选购完成。\n1 2\n➢ 如何将商品加入购物车\n当您需要将想采购的办公用品加入购物车时：\n快速上手指南 7\n方法二：商品详情页选购，在商品列表页面，直接点击商品后，进入商品详情页。\n在商品详情页面，根据自身需要①选择好商品的各项参数后，点击②加入购物车，完成商品选购。\n说明：当您直接点击“立即购买”时，商城直接跳转到提交订单页面。\n1\n2\n快速上手指南 8\n方法三：商品列表页批量选购，在商品列表页面，鼠标停在商品图片上时，点击①图片左上角的\n勾选框，然后再点击商品列表右上方的②批量加入购物车，在弹出的页面中③调整好商品的数量，\n然后再点击④确认加入购物车。\n1\n2\n3\n4\n这个是弹窗\n快速上手指南 9\n当您需要将想采购的办公用品加入购物车时：\n方法四：快速批量提交，页面顶部点击①快速下单，在跳转后的页面点击②批量快速下单，再点击\n③下载Excel模板。在模板中的最后一列内，④填入需要购买的数量，保存后回到商城页面点击\n⑤上传文件，完成这些后，Excel模板中的填入的商品就会自动加入购物车。\n1\n2\n3\n5\n表格模板下载打开的样例\n4\n快速上手指南 10\n➢ 如何结算购物车\n当您需要将购物车内的商品进行结算时：\n第1步：点击页面①顶部的购物车或者页面①右侧的购物车，进入购物车。\n第2步：②勾选需要的商品，并按需③调整数量。然后点击④去结算，系统将跳转到提交订单页面。\n1\n1\n2 3\n4\n说明：\n点击导出按钮可将购物车\n清单导出为Excel表格\n快速上手指南 11\n➢ 如何提交采购订单\n当您需要将采购订单提交时：\n第1步：商品结算后，自动进入订单提交页面。选择①采购部门，选择完成后自动弹出审批人。\n第2步：点选②收件人，确定收货信息。\n第3步：确定③支付方式，一般不会变化。\n第4步：查看④剩余预算，是否充足。\n注意事项：\n当预算不足时，无法提交订单。您可以选择\n联系管理员增加预算或删减商品，再提交。\n1\n2\n3\n4\n快速上手指南 12\n第5步：⑤核对商品清单列表，商品、数量、规格、颜色等是否有误。\n第6步：确定无误，点击⑥提交订单，完成页面跳转到提交完成的⑦提示页面。\n5\n6\n7 跳转后页面提示\n快速上手指南 13\n选择收货时，也可以实时新增地址：\n① ：在选择部门时，部分客户户只能选择自己，无法查看到其他人。\n② ：在收货地址一栏中，部分客户可点击右侧的新增收货地址来实时新增。\n1\n2\n说明：新增收货地址功能为可选功能。\n快速上手指南 14\n提交订单时，可以添加附件以及备注：\n① 提交订单时，可以对订单进行备注，备注的信息订单处理人员将会关注到。\n② 提交订单时，可以添加审批附件，附件内容支持多种常见的文件形式。\n说明：添加的附件，在审批订单时可以查看到。\n1\n2\n快速上手指南 15\n➢ 如何查看自己的采购订单\n当您需要查看采购订单时：\n第1步：点击页面顶部①我的订单或者商城首页右侧的我的订单，进入订单中心。\n第2步：通过各项筛选功能筛选后，查看自己的订单记录。\n1\n说明：可根据“采购部门”、“订单状态”“下单时间”“订单号”等不同维度进行筛选。\n快速上手指南 16\n➢ 如何查看采购订单进展以及物流信息\n当您需要查看采购订单进度以及物流信息时：\n第1步：进入订单中心后，点击订单栏中的①查看，进入该订单状态页面。\n第2步：进入到订单状态页后，可查看②订单的处理进展，可查看③物流信息，可查看④审\n批状态以及相应审批负责人。\n2\n4\n3\n1\n快速上手指南 17\n➢ 如何取消采购订单\n当您需要将采购订单取消时：\n第1步：进入订单中心。\n第2步：点击订单右侧的①取消，页面弹出确认对话框，点击②确定，接口完成订单取消。\n注意：当订单被审批通过后，就不能被取消了。\n1\n2\n快速上手指南 18\n➢ 如何在线确认收货\n当您需要在线确认收货时：\n第1步：进入订单中心后，通过订单状态中选择①已发货，将订单筛选出来。\n第2步：点击订单右侧的②确认收货，完成在线的签收确认。\n1\n2\n快速上手指南 19\n➢ 如何查看订单统计\n当您需要查看订单统计时：\n第1步：进入订单中心。\n第2步：点击左侧①订单报表，然后选择②筛选条件，再点击③统计，就会展现出统计结果。\n说明：可根据“所属公司”、“订单时间”“统计维度”三个方面进行统计。\n其中，统计维度包含“部门统计”、“员工统计”、“商品统计”等不同角度的统计逻辑。\n2\n3\n1\n快速上手指南 20\n➢ 如何查看订单详情\n当您需要查看订单详情时：\n第1步：进入订单中心。\n第2步：点击左侧①订单明细报表，然后选择②筛选条件，再点击③查询，就会展现出查询结果。\n说明：可根据“订单创建时间”、“订单归属部门”“客户商品分类”、“商品名称”四个方面\n进行筛选查询，亦可到处至表格。\n2\n3\n1\n快速上手指南 21\n➢ 如何在线申请开票\n当您需要在线申请开发票时：\n第1步：在进入个人中心后，点击左侧① 待开票订单申请。\n第2步：在右侧的②筛选项中，筛选出需要开票的订单，然后点击③查询。\n说明：\na、当您需要批量开票时，请勾选订单后，点击批量开票申请按钮。\nb、当您需要导出明细时，点击导出待开票订单明细按钮。\nc、只有当订单状态为已签收时，才可以在线申请开票。\n第3步：点击④开票申请，对单笔订单进行开票。\n2 3\n4\n1\n说明：\n在线申请开票为可选功能，\n可根据需要进行开通\n快速上手指南 22\n在弹出页面填入信息：\n说明：\na、可开增值税专票、普票、电子普票，可开企业、个人类型。\nb、带红色星号的选项为必填项。\n快速上手指南 23\n添加寄送地址与提交申请\n第1步：在开票申请页面，点击左侧① 新增地址。输入信息后点击②保存。\n第2步：确认信息没问题后，点击③提交申请，完成开票申请。\n说明：\na、如果已经有新增过地址，那么可以直接勾选地址。\nb、您可以点击订单中的查看，来确定订单详情是否正确。\n1\n2\n3\n快速上手指南 24\n➢ 如何联系在线客服\n当您需要咨询问题服务时：\n第1步：点击页面左上角的logo进入商城首页，然后右侧的①客服\n说明：\na、提供订单号、下单平台及个人信息，可以让客服更好的为您服务。\n快速上手指南 25\n➢ 如何审批订单\n当您需要审批订单时：\n第1步：审批员登录账号并进入订单中心后，点击①订单审批。\n方式一：批量进行审批，\n第2步：②勾选需要审批的订单，点击右侧的③批量通过或批量拒绝按钮，会弹出对话框。\n第3步：在弹出的对话框中，填入④审批意见，然后点击⑤确定，完成审批。\n1\n2\n3\n4\n5\n快速上手指南 26\n方式二：列表页单个订单审批\n第1步：直接点击待审批订单右侧的①通过。\n第2步：在弹出的对话框中，点击②确定，通过审批。然后在再次点击③确定，完成审批。\n方式三：详情页中单个订单审批\n第1步：点击待审批订单右侧的①查看。\n第2步：在跳转的页面的②审批备注中输入备注，然后③点击通过或拒绝来完成审批。\n1\n3\n2\n1\n2\n3\n快速上手指南 27\n➢ 如何修改密码，设置个人信息\n当您需要修改密码或个人信息设置时：\n第1步：点击页面顶端的①账户昵称，进入个人中心页面，点击左侧菜单栏中的①设置。\n第2步：点击个人资料进入，修改个人资料。\n第3步：点击修改密码，进入修改个人密码页面。\n第4步：点击修改头像，进入修改个人头像页面。\n快速上手指南 28\n常见问题以及解答\n1、怎样快速回到首页？\n答：在任何页面中，点击左上角的企采商城LOGO图标，即可回到首页\n2、密码忘记了怎么办？\n答：请联系您的管理员，为您重置密码。\n3、为什么提交订单按钮点不了？\n答：（1）查看预算是否够，不够请联系管理员增加预算，或删减商品。\n（2）有没有填写部门，如果没有填写部门的话是不能提交订单的。\n（3）若以上都没问题，请将页面截图并反馈给对接人。\n4、审批人员可以采购吗？\n答：可以采购，一个账号可以有多种角色权限。

',0,0,1,1607569138,NULL,0,0); INSERT INTO `ls_help_category` (`id`,`name`,`is_show`,`create_time`,`update_time`,`del`) VALUES (1,'使用手册',1,1607568906,NULL,0); INSERT INTO `ls_recharge_template` (`id`,`money`,`give_money`,`sort`,`is_recommend`,`create_time`,`update_time`,`del`) VALUES (1,50.00,0.00,6,0,1607589130,1607589153,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (1,4,5,5,3.00,0,1607588970,1607588970,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (2,1,1,1,33.00,0,1607589023,1607589023,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (3,2,2,2,39.00,0,1607589057,1607589057,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (4,3,8,8,999.00,0,1607589070,1607589070,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (5,3,1,1,40.30,0,1607589942,1607589942,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (6,3,4,4,6.00,0,1607589955,1607589955,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (7,3,3,3,9.90,0,1607589973,1607589973,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (8,5,10,10,999.00,0,1607590140,1607590140,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (9,3,7,7,29.00,0,1607590153,1607590153,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (10,3,1,1,40.00,0,1607590164,1607590164,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (11,3,3,3,9.90,0,1607590177,1607590177,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (12,2,7,7,29.00,0,1607590189,1607590189,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (13,2,1,1,39.00,0,1607590198,1607590198,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (14,2,3,3,9.90,0,1607590207,1607590207,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (15,1,8,8,999.00,0,1607590218,1607590218,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (16,1,2,2,39.00,0,1607590245,1607590245,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (17,1,9,9,4999.00,0,1607590259,1607590259,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (18,4,6,6,29.00,0,1607590270,1607590270,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (19,4,3,3,9.90,0,1607590289,1607590289,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (20,4,8,8,999.00,0,1607590299,1607590299,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (21,5,6,6,26.90,0,1607590394,1607590394,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (22,5,7,7,29.90,0,1607590406,1607590406,0); INSERT INTO `ls_seckill_goods` (`id`,`seckill_id`,`goods_id`,`item_id`,`price`,`sales_sum`,`create_time`,`update_time`,`del`) VALUES (23,5,3,3,9.90,0,1607590418,1607590418,0); INSERT INTO `ls_seckill_time` (`id`,`start_time`,`end_time`,`create_time`,`update_time`,`del`) VALUES (1,'08:00','12:28',1607588823,1607590054,0); INSERT INTO `ls_sign_daily` (`id`,`type`,`integral`,`integral_status`,`growth_status`,`days`,`create_time`,`update_time`,`del`,`growth`) VALUES (1,'2',10,1,1,2,1607588705,1607588727,0,10); INSERT INTO `ls_supplier` (`id`,`name`,`del`,`create_time`,`update_time`,`tel`,`contact`,`remark`,`province_id`,`city_id`,`district_id`,`address`) VALUES (1,'文具旗舰店',0,1607570262,1607570274,'13648795627','晨先生','文具专卖供货商',NULL,NULL,NULL,'北京朝阳北巷3街道'); INSERT INTO `ls_user_distribution` (`id`,`user_id`,`distribution_order_num`,`distribution_money`,`fans`,`order_num`,`order_amount`,`create_time`,`update_time`) VALUES (1,1,0,0.00,0,0,0.00,1607597684,NULL); INSERT INTO `ls_user_distribution` (`id`,`user_id`,`distribution_order_num`,`distribution_money`,`fans`,`order_num`,`order_amount`,`create_time`,`update_time`) VALUES (2,2,0,0.00,0,0,0.00,1607597860,NULL); INSERT INTO `ls_user_distribution` (`id`,`user_id`,`distribution_order_num`,`distribution_money`,`fans`,`order_num`,`order_amount`,`create_time`,`update_time`) VALUES (3,3,0,0.00,0,0,0.00,1607650297,NULL); INSERT INTO `ls_user_distribution` (`id`,`user_id`,`distribution_order_num`,`distribution_money`,`fans`,`order_num`,`order_amount`,`create_time`,`update_time`) VALUES (4,4,0,0.00,0,0,0.00,1607654072,NULL); INSERT INTO `ls_user_distribution` (`id`,`user_id`,`distribution_order_num`,`distribution_money`,`fans`,`order_num`,`order_amount`,`create_time`,`update_time`) VALUES (5,5,0,0.00,0,0,0.00,1607655080,NULL); SET FOREIGN_KEY_CHECKS=1;