ECShopX/docker-dev/demo/bbc.sql

INSERT INTO `goods_items_rel_cats` (`item_id`, `category_id`, `company_id`, `created`, `updated`) VALUES
(1,2,1,1773754863,1773754863),
(2,2,1,1773754891,1773754891),
(3,3,1,1773754944,1773754944),
(5,3,1,1773754975,1773754975),
(7,1,1,1773755021,1773755021),
(8,1,1,1773755046,1773755046);

INSERT INTO `items` (`item_id`, `item_type`, `item_category`, `consume_type`, `item_name`, `item_bn`, `barcode`, `brief`, `company_id`, `price`, `cost_price`, `item_unit`, `special_type`, `item_address_province`, `item_address_city`, `regions_id`, `store`, `sales`, `rebate_conf`, `rebate`, `rebate_type`, `approve_status`, `audit_status`, `audit_reason`, `market_price`, `goods_function`, `goods_series`, `goods_color`, `goods_brand`, `is_default`, `default_item_id`, `goods_id`, `nospec`, `weight`, `sort`, `templates_id`, `pics`, `pics_create_qrcode`, `video_type`, `videos`, `video_pic_url`, `intro`, `purchase_agreement`, `is_show_specimg`, `enable_agreement`, `date_type`, `begin_date`, `end_date`, `fixed_term`, `brand_logo`, `is_point`, `point`, `distributor_id`, `volume`, `item_source`, `brand_id`, `tax_rate`, `crossborder_tax_rate`, `profit_type`, `origincountry_id`, `taxstrategy_id`, `taxation_num`, `profit_fee`, `type`, `is_profit`, `created`, `updated`, `is_gift`, `is_package`, `tdk_content`, `is_epidemic`, `regions`, `supplier_id`, `is_market`, `goods_bn`, `supplier_goods_bn`, `audit_date`, `is_medicine`, `is_prescription`, `supplier_item_id`, `start_num`, `delivery_time`, `is_taobao`) VALUES
(1,'normal','12','every','棕色手提包','KC26031700000036','','',1,300000,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,1,1,1,'true',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/562b0cc89605a55e825132f8ef7308711773754832988.经典包海报款---prd.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773754863,1773754863,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000030',NULL,1773754863,0,0,0,0,0,0),
(2,'normal','12','every','黑色手提包','KC26031700000037','','',1,300000,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,1,2,2,'true',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/847172a8516c8dae3656ad01e68f5d1c1773754842460.托特包黑色--prd.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773754891,1773754891,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000031',NULL,1773754891,0,0,0,0,0,0),
(3,'normal','9','every','口红银色','KC26031700000038','','',1,59900,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,1,3,3,'false',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/065ebf19b4affdf373ad50024253fc9a1773754917352.口红 --prd.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773754944,1773754944,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000032',NULL,1773754944,0,0,0,0,0,0),
(4,'normal','9','every','口红银色','KC26031700000039','','',1,59900,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,0,3,3,'false',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/065ebf19b4affdf373ad50024253fc9a1773754917352.口红 --prd.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773754944,1773754944,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000033',NULL,1773754944,0,0,0,0,0,0),
(5,'normal','9','every','口红黑色','KC26031700000040','','',1,69900,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,1,5,5,'false',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/065ebf19b4affdf373ad50024253fc9a1773754917354.口红--prd2.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773754975,1773754975,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000034',NULL,1773754975,0,0,0,0,0,0),
(6,'normal','9','every','口红黑色','KC26031700000041','','',1,69900,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,0,5,5,'false',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/065ebf19b4affdf373ad50024253fc9a1773754917354.口红--prd2.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773754975,1773754975,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000035',NULL,1773754975,0,0,0,0,0,0),
(7,'normal','6','every','夹克A','KC26031700000042','','',1,400000,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,1,7,7,'true',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/34f41f5e5518aaede5501559fa5fb9181773755007752.4.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773755021,1773755021,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000036',NULL,1773755020,0,0,0,0,0,0),
(8,'normal','6','every','夹克B','KC26031700000043','','',1,400000,0,'','normal','','','',1,NULL,NULL,0,'default','onsale','approved',NULL,0,NULL,NULL,NULL,NULL,1,8,8,'true',0,1,1,'[\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/17/34f41f5e5518aaede5501559fa5fb9181773755007759.5.jpg\"]','[false]','local','',NULL,'','',0,0,'',0,0,0,NULL,NULL,0,0,NULL,'mall',1,0,'',0,0,0,0,0,0,0,1773755045,1773755046,0,0,'{\"title\":\"\",\"mate_description\":\"\",\"mate_keywords\":\"\"}',0,'',0,0,'PC26031700000037',NULL,1773755045,0,0,0,0,0,0);

INSERT INTO `items_attribute_values` (`attribute_value_id`, `attribute_id`, `company_id`, `shop_id`, `attribuattribute_valuete_name`, `sort`, `image_url`, `created`, `updated`, `oms_value_id`) VALUES
(1,2,1,0,'黑色','0','',1773754651,1773754651,NULL),
(2,2,1,0,'白色','1','',1773754651,1773754651,NULL),
(3,3,1,0,'1#','0','',1773754665,1773754665,NULL),
(4,3,1,0,'2#','1','',1773754665,1773754665,NULL),
(5,4,1,0,'39','0','',1773754683,1773754683,NULL),
(6,4,1,0,'40','1','',1773754683,1773754683,NULL),
(7,4,1,0,'40.5','2','',1773754683,1773754683,NULL),
(8,4,1,0,'41','3','',1773754683,1773754683,NULL),
(9,4,1,0,'41.5','4','',1773754683,1773754683,NULL);

INSERT INTO `items_attributes` (`attribute_id`, `company_id`, `shop_id`, `attribute_type`, `attribute_name`, `attribute_memo`, `attribute_sort`, `distributor_id`, `is_show`, `is_image`, `image_url`, `created`, `updated`, `attribute_code`, `attribute_show`) VALUES
(1,1,0,'brand','品牌','','1',0,'true','true','',1773754689,1773754689,NULL,'select'),
(2,1,0,'item_spec','颜色','','1',0,'true','','',1773754651,1773754651,NULL,'select'),
(3,1,0,'item_spec','色号','','1',0,'true','','',1773754665,1773754665,NULL,'select'),
(4,1,0,'item_spec','尺码','','1',0,'true','','',1773754683,1773754683,NULL,'select');

INSERT INTO `items_category` (`category_id`, `company_id`, `category_name`, `category_code`, `parent_id`, `category_level`, `is_main_category`, `path`, `distributor_id`, `sort`, `goods_params`, `goods_spec`, `image_url`, `crossborder_tax_rate`, `created`, `updated`, `customize_page_id`, `commission_ratio`, `category_id_taobao`, `parent_id_taobao`, `taobao_category_info`, `invoice_tax_rate_id`, `invoice_tax_rate`, `regionauth_id`, `is_show_front`) VALUES
(1,1,'户外运动',NULL,0,1,0,'1',0,0,NULL,NULL,'',NULL,1773754699,1773754699,0,0,0,0,NULL,NULL,NULL,0,1),
(2,1,'包袋',NULL,0,1,0,'2',0,0,NULL,NULL,'',NULL,1773754708,1773754708,0,0,0,0,NULL,NULL,NULL,0,1),
(3,1,'美妆',NULL,0,1,0,'3',0,0,NULL,NULL,'',NULL,1773754714,1773754714,0,0,0,0,NULL,NULL,NULL,0,1),
(4,1,'户外运动',NULL,0,1,1,'4',0,0,NULL,NULL,'',NULL,1773754723,1773754723,0,0,0,0,NULL,NULL,NULL,0,1),
(5,1,'系列',NULL,4,2,1,'4,5',0,0,NULL,NULL,'',NULL,1773754732,1773754732,0,0,0,0,NULL,NULL,NULL,0,1),
(6,1,'品类',NULL,5,3,1,'4,5,6',0,0,NULL,'[\"2\"]','',NULL,1773754738,1773754747,0,0,0,0,NULL,NULL,NULL,0,1),
(7,1,'彩妆',NULL,0,1,1,'7',0,0,NULL,NULL,'',NULL,1773754755,1773754755,0,0,0,0,NULL,NULL,NULL,0,1),
(8,1,'品类',NULL,7,2,1,'7,8',0,0,NULL,NULL,'',NULL,1773754763,1773754763,0,0,0,0,NULL,NULL,NULL,0,1),
(9,1,'系列',NULL,8,3,1,'7,8,9',0,0,NULL,'[\"3\"]','',NULL,1773754768,1773754773,0,0,0,0,NULL,NULL,NULL,0,1),
(10,1,'包袋',NULL,0,1,1,'10',0,0,NULL,NULL,'',NULL,1773754780,1773754780,0,0,0,0,NULL,NULL,NULL,0,1),
(11,1,'品类',NULL,10,2,1,'10,11',0,0,NULL,NULL,'',NULL,1773754786,1773754786,0,0,0,0,NULL,NULL,NULL,0,1),
(12,1,'系列',NULL,11,3,1,'10,11,12',0,0,NULL,NULL,'',NULL,1773754791,1773754791,0,0,0,0,NULL,NULL,NULL,0,1);

INSERT INTO `items_rel_attributes` (`id`, `company_id`, `item_id`, `attribute_sort`, `attribute_id`, `attribute_type`, `attribute_value_id`, `custom_attribute_value`, `image_url`) VALUES
(1,1,1,NULL,1,'brand',NULL,NULL,NULL),
(2,1,2,NULL,1,'brand',NULL,NULL,NULL),
(3,1,3,0,3,'item_spec',3,NULL,NULL),
(4,1,4,0,3,'item_spec',4,NULL,NULL),
(5,1,3,NULL,1,'brand',NULL,NULL,NULL),
(6,1,5,0,3,'item_spec',3,NULL,NULL),
(7,1,6,0,3,'item_spec',4,NULL,NULL),
(8,1,5,NULL,1,'brand',NULL,NULL,NULL),
(9,1,7,NULL,1,'brand',NULL,NULL,NULL),
(10,1,8,NULL,1,'brand',NULL,NULL,NULL);

INSERT INTO `pages_template` (`pages_template_id`, `company_id`, `distributor_id`, `template_title`, `template_name`, `template_pic`, `template_type`, `element_edit_status`, `status`, `timer_status`, `timer_time`, `template_status_modify_time`, `weapp_pages`, `template_content`, `created_at`, `updated_at`, `deleted_at`, `lang`, `regionauth_id`) VALUES
(1,1,0,'bbc','yykweishop','https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/b378f798c31d84eb4c1566c3d1711f571773469148138.bbc--logo.JPG',0,2,1,2,NULL,1773469152,'index','{\"content\":[{\"id\":\"1\",\"name\":\"page\",\"base\":{\"navigateBackgroundColor\":\"#fff\",\"navigateBackgroundImage\":\"\",\"titleStyle\":\"1\",\"titleColor\":\"#000\",\"titleBackgroundImage\":\"\",\"showSearchButton\":true,\"searchButtonColor\":{\"bgColor\":\"#1F1D1D\",\"textColor\":\"#FFFFFF\"},\"pageBackgroundColor\":\"#f5f5f5\",\"pageBackgroundImage\":\"\",\"isImmersive\":false,\"immersiveScrollBgColor\":\"#ffffff\",\"pTitleHotSetting\":{\"type\":\"hotzone\",\"hotzone\":{\"imgUrl\":\"\",\"data\":[]}}},\"tags\":{\"type\":\"2\",\"meber_tags\":[],\"no_meber_tags\":[]},\"tagsType\":\"2\",\"meber_tags\":[],\"no_meber_tags\":[]},{\"id\":\"2\",\"name\":\"slider\",\"base\":{\"outerMargin\":{\"paddedt\":0,\"paddedb\":0,\"paddedl\":0,\"paddedr\":0}},\"config\":{\"interval\":3000,\"dot\":true,\"dotLocation\":\"center\",\"dotColor\":\"dark\",\"shape\":\"rectangle\",\"dotCover\":false,\"rounded\":false,\"autoplay\":false,\"firstScreenWidth\":375,\"firstScreenHeight\":686},\"data\":[{\"imgUrl\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2aa214642208db41280c1c6de67fb53e1773468852870.u622au5c4f2026-01-17 16.32.55.png\",\"videoUrl\":\"\",\"media_type\":\"img\",\"hotData\":[],\"autoplay\":false,\"interact\":\"reset\",\"overlay\":\"\",\"overlayWidth\":100,\"overlaybuttom\":0,\"overlayLeft\":0,\"overlayHotData\":[]},{\"imgUrl\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/00d41d4dbdd66f82e51f736ba10c42321773468837462.u5305u888b.png\",\"videoUrl\":\"\",\"media_type\":\"img\",\"hotData\":[],\"autoplay\":false,\"interact\":\"reset\",\"overlay\":\"\",\"overlayWidth\":100,\"overlaybuttom\":0,\"overlayLeft\":0,\"overlayHotData\":[]}],\"track\":\"\",\"tags\":{\"type\":\"2\",\"meber_tags\":[],\"no_meber_tags\":[]},\"tagsType\":\"2\",\"meber_tags\":[],\"no_meber_tags\":[]},{\"name\":\"contentPartition\",\"meber_tags\":[],\"no_meber_tags\":[],\"tagsType\":\"2\",\"base\":{\"track\":\"\",\"animate\":\"horizontal\",\"navSticky\":true,\"statusBarBgColor\":\"#DFD8D8\",\"navitemheight\":80,\"navitemmargin\":80,\"leftimgUrl\":\"\",\"rightimgUrl\":\"\",\"navitemborder\":\"true\",\"navitemradius\":0,\"navitembordercolor\":\"#1C1A1A\",\"navitemarea\":[],\"outerMargin\":{\"paddedt\":0,\"paddedb\":0,\"paddedl\":0,\"paddedr\":0}},\"data\":{\"data\":[{\"navItemName\":\"u670du9970\",\"navitemtype\":\"text\",\"imgUrl\":\"\",\"navitemactiveimg\":\"\",\"navitemcolor\":\"#666666\",\"navitembg\":\"\",\"navitemactivecolor\":\"#1A1A1A\",\"navitemactivebg\":\"\",\"navactivebg\":\"\",\"navactivebgimg\":\"\",\"isActive\":false,\"no_meber_tags\":[],\"meber_tags\":[],\"tagsType\":\"2\",\"configType\":\"widget\",\"children\":[{\"name\":\"goods\",\"base\":{\"outerMargin\":{\"paddedt\":0,\"paddedb\":0,\"paddedl\":0,\"paddedr\":0},\"innerPadding\":{\"paddedt\":32,\"paddedb\":32,\"paddedl\":32,\"paddedr\":32},\"track\":\"\",\"dataType\":\"items\",\"dataCount\":4,\"goodsLayout\":\"one\",\"titleText\":{\"type\":\"text\",\"text\":\"u65b0u54c1u63a8u8350\",\"image\":\"\"},\"titleColor\":\"#000000\",\"moreBtn\":{\"show\":true,\"color\":\"#000000\"},\"moreLink\":[]},\"data\":{\"id\":\"7,8\",\"info\":{\"length\":2,\"type\":\"group_id\"}},\"meber_tags\":[],\"no_meber_tags\":[],\"tagsType\":\"2\",\"wgtName\":\"u5546u54c1\"}]},{\"navItemName\":\"u5305u888b\",\"navitemtype\":\"text\",\"imgUrl\":\"\",\"navitemactiveimg\":\"\",\"navitemcolor\":\"#666666\",\"navitembg\":\"\",\"navitemactivecolor\":\"#1A1A1A\",\"navitemactivebg\":\"\",\"navactivebg\":\"\",\"navactivebgimg\":\"\",\"isActive\":false,\"no_meber_tags\":[],\"meber_tags\":[],\"tagsType\":\"2\",\"configType\":\"widget\",\"children\":[{\"name\":\"goods\",\"base\":{\"outerMargin\":{\"paddedt\":0,\"paddedb\":0,\"paddedl\":0,\"paddedr\":0},\"innerPadding\":{\"paddedt\":32,\"paddedb\":32,\"paddedl\":32,\"paddedr\":32},\"track\":\"\",\"dataType\":\"items\",\"dataCount\":4,\"goodsLayout\":\"two\",\"titleText\":{\"type\":\"text\",\"text\":\"u65b0u54c1u63a8u8350\",\"image\":\"\"},\"titleColor\":\"#000000\",\"moreBtn\":{\"show\":true,\"color\":\"#000000\"},\"moreLink\":[]},\"data\":{\"id\":\"2,1\",\"info\":{\"length\":2,\"type\":\"group_id\"}},\"meber_tags\":[],\"no_meber_tags\":[],\"tagsType\":\"2\",\"wgtName\":\"u5546u54c1\"}]},{\"navItemName\":\"u5f69u5986\",\"navitemtype\":\"text\",\"imgUrl\":\"\",\"navitemactiveimg\":\"\",\"navitemcolor\":\"#666666\",\"navitembg\":\"\",\"navitemactivecolor\":\"#1A1A1A\",\"navitemactivebg\":\"\",\"navactivebg\":\"\",\"navactivebgimg\":\"\",\"isActive\":false,\"no_meber_tags\":[],\"meber_tags\":[],\"tagsType\":\"2\",\"configType\":\"widget\",\"children\":[{\"name\":\"goods\",\"base\":{\"outerMargin\":{\"paddedt\":0,\"paddedb\":0,\"paddedl\":0,\"paddedr\":0},\"innerPadding\":{\"paddedt\":32,\"paddedb\":32,\"paddedl\":32,\"paddedr\":32},\"track\":\"\",\"dataType\":\"items\",\"dataCount\":4,\"goodsLayout\":\"two\",\"titleText\":{\"type\":\"text\",\"text\":\"u65b0u54c1u63a8u8350\",\"image\":\"\"},\"titleColor\":\"#000000\",\"moreBtn\":{\"show\":true,\"color\":\"#000000\"},\"moreLink\":[]},\"data\":{\"id\":\"2,1\",\"info\":{\"length\":2,\"type\":\"group_id\"}},\"meber_tags\":[],\"no_meber_tags\":[],\"tagsType\":\"2\",\"wgtName\":\"u5546u54c1\"}]}]},\"id\":\"3\"}]}','2026-03-14 14:19:12','2026-03-17 21:47:32',NULL,NULL,0);

INSERT INTO `pages_template_set` (`id`, `company_id`, `index_type`, `is_enforce_sync`, `is_open_recommend`, `is_open_wechatapp_location`, `is_open_scan_qrcode`, `is_open_official_account`, `tab_bar`, `created_at`, `updated_at`, `pages_template_id`, `regionauth_id`) VALUES
(1,1,1,2,2,1,2,2,'{\"name\":\"tabs\",\"config\":{\"backgroundColor\":\"#ffffff\",\"color\":\"#827E7E\",\"selectedColor\":\"#020202\"},\"data\":[{\"pagePath\":\"/pages/index\",\"text\":\"首页\",\"name\":\"home\",\"iconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2f16a2a28de9b76387a5f1fba2b60e531773469193438.首页1.png\",\"selectedIconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2f16a2a28de9b76387a5f1fba2b60e531773469193437.截屏2026-01-17 13.00.39_副本.png\"},{\"pagePath\":\"/pages/category/index\",\"text\":\"分类\",\"name\":\"category\",\"iconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2f16a2a28de9b76387a5f1fba2b60e531773469193433.分类1.png\",\"selectedIconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2f16a2a28de9b76387a5f1fba2b60e531773469193431.分类.png\"},{\"pagePath\":\"/pages/cart/espier-index\",\"text\":\"购物车\",\"name\":\"cart\",\"iconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/4f26d2a9ee7d4fa644b00dfebaea525e1773469193435.购物车1.png\",\"selectedIconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2f16a2a28de9b76387a5f1fba2b60e531773469193434.购物车.png\"},{\"pagePath\":\"/pages/member/index\",\"text\":\"我的\",\"name\":\"member\",\"iconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/4f26d2a9ee7d4fa644b00dfebaea525e1773469193442.我的1.png\",\"selectedIconPath\":\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/4f26d2a9ee7d4fa644b00dfebaea525e1773469193440.我的.png\"}]}','2026-03-14 14:18:58','2026-03-14 14:20:27',0,0);

INSERT INTO `shipping_templates` (`template_id`, `company_id`, `name`, `is_free`, `distributor_id`, `valuation`, `protect`, `protect_rate`, `minprice`, `status`, `fee_conf`, `nopost_conf`, `free_conf`, `create_time`, `update_time`, `supplier_id`) VALUES
(1,1,'按件数','0',0,'2',NULL,NULL,NULL,1,'[{\"add_fee\":\"0\",\"add_standard\":\"1\",\"start_fee\":\"1\",\"start_standard\":\"1\"}]','[]','[{\"freetype\":\"1\",\"upquantity\":\"\",\"upmoney\":\"\"}]',1773754624,1773754624,0);

INSERT INTO `wechat_weapp_customize_page` (`id`, `template_name`, `company_id`, `page_name`, `page_description`, `page_share_title`, `page_share_desc`, `page_share_imageUrl`, `is_open`, `page_type`, `regionauth_id`) VALUES
(1,'yykweishop',1,'个人中心','个人中心','个人中心','','',1,'my',0);

INSERT INTO `wechat_weapp_setting` (`id`, `template_name`, `company_id`, `page_name`, `name`, `version`, `params`, `pages_template_id`, `sort_by`) VALUES
(1,'yykweishop',1,'index','page','v1.0.2','a:7:{s:2:\"id\";s:1:\"1\";s:4:\"name\";s:4:\"page\";s:4:\"base\";a:12:{s:23:\"navigateBackgroundColor\";s:4:\"#fff\";s:23:\"navigateBackgroundImage\";s:0:\"\";s:10:\"titleStyle\";s:1:\"1\";s:10:\"titleColor\";s:4:\"#000\";s:20:\"titleBackgroundImage\";s:0:\"\";s:16:\"showSearchButton\";b:1;s:17:\"searchButtonColor\";a:2:{s:7:\"bgColor\";s:7:\"#1F1D1D\";s:9:\"textColor\";s:7:\"#FFFFFF\";}s:19:\"pageBackgroundColor\";s:7:\"#f5f5f5\";s:19:\"pageBackgroundImage\";s:0:\"\";s:11:\"isImmersive\";b:0;s:22:\"immersiveScrollBgColor\";s:7:\"#ffffff\";s:16:\"pTitleHotSetting\";a:2:{s:4:\"type\";s:7:\"hotzone\";s:7:\"hotzone\";a:2:{s:6:\"imgUrl\";s:0:\"\";s:4:\"data\";a:0:{}}}}s:4:\"tags\";a:3:{s:4:\"type\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}s:8:\"tagsType\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}',1,1),
(2,'yykweishop',1,'index','slider','v1.0.2','a:10:{s:2:\"id\";s:1:\"2\";s:4:\"name\";s:6:\"slider\";s:4:\"base\";a:1:{s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:0;s:7:\"paddedb\";i:0;s:7:\"paddedl\";i:0;s:7:\"paddedr\";i:0;}}s:6:\"config\";a:10:{s:8:\"interval\";i:3000;s:3:\"dot\";b:1;s:11:\"dotLocation\";s:6:\"center\";s:8:\"dotColor\";s:4:\"dark\";s:5:\"shape\";s:9:\"rectangle\";s:8:\"dotCover\";b:0;s:7:\"rounded\";b:0;s:8:\"autoplay\";b:0;s:16:\"firstScreenWidth\";i:375;s:17:\"firstScreenHeight\";i:686;}s:4:\"data\";a:2:{i:0;a:11:{s:6:\"imgUrl\";s:172:\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/2aa214642208db41280c1c6de67fb53e1773468852870.截屏2026-01-17 16.32.55.png\";s:8:\"videoUrl\";s:0:\"\";s:10:\"media_type\";s:3:\"img\";s:7:\"hotData\";a:0:{}s:8:\"autoplay\";b:0;s:8:\"interact\";s:5:\"reset\";s:7:\"overlay\";s:0:\"\";s:12:\"overlayWidth\";i:100;s:13:\"overlaybuttom\";i:0;s:11:\"overlayLeft\";i:0;s:14:\"overlayHotData\";a:0:{}}i:1;a:11:{s:6:\"imgUrl\";s:153:\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/00d41d4dbdd66f82e51f736ba10c42321773468837462.包袋.png\";s:8:\"videoUrl\";s:0:\"\";s:10:\"media_type\";s:3:\"img\";s:7:\"hotData\";a:0:{}s:8:\"autoplay\";b:0;s:8:\"interact\";s:5:\"reset\";s:7:\"overlay\";s:0:\"\";s:12:\"overlayWidth\";i:100;s:13:\"overlaybuttom\";i:0;s:11:\"overlayLeft\";i:0;s:14:\"overlayHotData\";a:0:{}}}s:5:\"track\";s:0:\"\";s:4:\"tags\";a:3:{s:4:\"type\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}s:8:\"tagsType\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}',1,2),
(3,'yykweishop',1,'index','contentPartition','v1.0.2','a:7:{s:4:\"name\";s:16:\"contentPartition\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:4:\"base\";a:13:{s:5:\"track\";s:0:\"\";s:7:\"animate\";s:10:\"horizontal\";s:9:\"navSticky\";b:1;s:16:\"statusBarBgColor\";s:7:\"#DFD8D8\";s:13:\"navitemheight\";i:80;s:13:\"navitemmargin\";i:80;s:10:\"leftimgUrl\";s:0:\"\";s:11:\"rightimgUrl\";s:0:\"\";s:13:\"navitemborder\";s:4:\"true\";s:13:\"navitemradius\";i:0;s:18:\"navitembordercolor\";s:7:\"#1C1A1A\";s:11:\"navitemarea\";a:0:{}s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:0;s:7:\"paddedb\";i:0;s:7:\"paddedl\";i:0;s:7:\"paddedr\";i:0;}}s:4:\"data\";a:1:{s:4:\"data\";a:3:{i:0;a:16:{s:11:\"navItemName\";s:6:\"服饰\";s:11:\"navitemtype\";s:4:\"text\";s:6:\"imgUrl\";s:0:\"\";s:16:\"navitemactiveimg\";s:0:\"\";s:12:\"navitemcolor\";s:7:\"#666666\";s:9:\"navitembg\";s:0:\"\";s:18:\"navitemactivecolor\";s:7:\"#1A1A1A\";s:15:\"navitemactivebg\";s:0:\"\";s:11:\"navactivebg\";s:0:\"\";s:14:\"navactivebgimg\";s:0:\"\";s:8:\"isActive\";b:0;s:13:\"no_meber_tags\";a:0:{}s:10:\"meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:10:\"configType\";s:6:\"widget\";s:8:\"children\";a:1:{i:0;a:7:{s:4:\"name\";s:5:\"goods\";s:4:\"base\";a:10:{s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:0;s:7:\"paddedb\";i:0;s:7:\"paddedl\";i:0;s:7:\"paddedr\";i:0;}s:12:\"innerPadding\";a:4:{s:7:\"paddedt\";i:32;s:7:\"paddedb\";i:32;s:7:\"paddedl\";i:32;s:7:\"paddedr\";i:32;}s:5:\"track\";s:0:\"\";s:8:\"dataType\";s:5:\"items\";s:9:\"dataCount\";i:4;s:11:\"goodsLayout\";s:3:\"one\";s:9:\"titleText\";a:3:{s:4:\"type\";s:4:\"text\";s:4:\"text\";s:12:\"新品推荐\";s:5:\"image\";s:0:\"\";}s:10:\"titleColor\";s:7:\"#000000\";s:7:\"moreBtn\";a:2:{s:4:\"show\";b:1;s:5:\"color\";s:7:\"#000000\";}s:8:\"moreLink\";a:0:{}}s:4:\"data\";a:2:{s:2:\"id\";s:3:\"7,8\";s:4:\"info\";a:2:{s:6:\"length\";i:2;s:4:\"type\";s:8:\"group_id\";}}s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:7:\"wgtName\";s:6:\"商品\";}}}i:1;a:16:{s:11:\"navItemName\";s:6:\"包袋\";s:11:\"navitemtype\";s:4:\"text\";s:6:\"imgUrl\";s:0:\"\";s:16:\"navitemactiveimg\";s:0:\"\";s:12:\"navitemcolor\";s:7:\"#666666\";s:9:\"navitembg\";s:0:\"\";s:18:\"navitemactivecolor\";s:7:\"#1A1A1A\";s:15:\"navitemactivebg\";s:0:\"\";s:11:\"navactivebg\";s:0:\"\";s:14:\"navactivebgimg\";s:0:\"\";s:8:\"isActive\";b:0;s:13:\"no_meber_tags\";a:0:{}s:10:\"meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:10:\"configType\";s:6:\"widget\";s:8:\"children\";a:1:{i:0;a:7:{s:4:\"name\";s:5:\"goods\";s:4:\"base\";a:10:{s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:0;s:7:\"paddedb\";i:0;s:7:\"paddedl\";i:0;s:7:\"paddedr\";i:0;}s:12:\"innerPadding\";a:4:{s:7:\"paddedt\";i:32;s:7:\"paddedb\";i:32;s:7:\"paddedl\";i:32;s:7:\"paddedr\";i:32;}s:5:\"track\";s:0:\"\";s:8:\"dataType\";s:5:\"items\";s:9:\"dataCount\";i:4;s:11:\"goodsLayout\";s:3:\"two\";s:9:\"titleText\";a:3:{s:4:\"type\";s:4:\"text\";s:4:\"text\";s:12:\"新品推荐\";s:5:\"image\";s:0:\"\";}s:10:\"titleColor\";s:7:\"#000000\";s:7:\"moreBtn\";a:2:{s:4:\"show\";b:1;s:5:\"color\";s:7:\"#000000\";}s:8:\"moreLink\";a:0:{}}s:4:\"data\";a:2:{s:2:\"id\";s:3:\"2,1\";s:4:\"info\";a:2:{s:6:\"length\";i:2;s:4:\"type\";s:8:\"group_id\";}}s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:7:\"wgtName\";s:6:\"商品\";}}}i:2;a:16:{s:11:\"navItemName\";s:6:\"彩妆\";s:11:\"navitemtype\";s:4:\"text\";s:6:\"imgUrl\";s:0:\"\";s:16:\"navitemactiveimg\";s:0:\"\";s:12:\"navitemcolor\";s:7:\"#666666\";s:9:\"navitembg\";s:0:\"\";s:18:\"navitemactivecolor\";s:7:\"#1A1A1A\";s:15:\"navitemactivebg\";s:0:\"\";s:11:\"navactivebg\";s:0:\"\";s:14:\"navactivebgimg\";s:0:\"\";s:8:\"isActive\";b:0;s:13:\"no_meber_tags\";a:0:{}s:10:\"meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:10:\"configType\";s:6:\"widget\";s:8:\"children\";a:1:{i:0;a:7:{s:4:\"name\";s:5:\"goods\";s:4:\"base\";a:10:{s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:0;s:7:\"paddedb\";i:0;s:7:\"paddedl\";i:0;s:7:\"paddedr\";i:0;}s:12:\"innerPadding\";a:4:{s:7:\"paddedt\";i:32;s:7:\"paddedb\";i:32;s:7:\"paddedl\";i:32;s:7:\"paddedr\";i:32;}s:5:\"track\";s:0:\"\";s:8:\"dataType\";s:5:\"items\";s:9:\"dataCount\";i:4;s:11:\"goodsLayout\";s:3:\"two\";s:9:\"titleText\";a:3:{s:4:\"type\";s:4:\"text\";s:4:\"text\";s:12:\"新品推荐\";s:5:\"image\";s:0:\"\";}s:10:\"titleColor\";s:7:\"#000000\";s:7:\"moreBtn\";a:2:{s:4:\"show\";b:1;s:5:\"color\";s:7:\"#000000\";}s:8:\"moreLink\";a:0:{}}s:4:\"data\";a:2:{s:2:\"id\";s:3:\"2,1\";s:4:\"info\";a:2:{s:6:\"length\";i:2;s:4:\"type\";s:8:\"group_id\";}}s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}s:8:\"tagsType\";s:1:\"2\";s:7:\"wgtName\";s:6:\"商品\";}}}}}s:2:\"id\";s:1:\"3\";}',1,3),
(4,'yykweishop',1,'custom_1','page','v1.0.1','a:7:{s:2:\"id\";s:1:\"4\";s:4:\"name\";s:4:\"page\";s:4:\"base\";a:11:{s:23:\"navigateBackgroundColor\";s:4:\"#fff\";s:23:\"navigateBackgroundImage\";s:0:\"\";s:10:\"titleStyle\";s:1:\"0\";s:10:\"titleColor\";s:4:\"#000\";s:20:\"titleBackgroundImage\";s:0:\"\";s:16:\"showSearchButton\";b:1;s:17:\"searchButtonColor\";a:2:{s:7:\"bgColor\";s:7:\"#1F1D1D\";s:9:\"textColor\";s:7:\"#FFFFFF\";}s:19:\"pageBackgroundColor\";s:7:\"#f5f5f5\";s:19:\"pageBackgroundImage\";s:0:\"\";s:11:\"isImmersive\";b:1;s:16:\"pTitleHotSetting\";a:2:{s:4:\"type\";s:4:\"none\";s:7:\"hotzone\";a:2:{s:6:\"imgUrl\";s:0:\"\";s:4:\"data\";a:0:{}}}}s:4:\"tags\";a:3:{s:4:\"type\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}s:8:\"tagsType\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}',0,1),
(5,'yykweishop',1,'custom_1','orderNavigation','v1.0.1','a:9:{s:4:\"name\";s:15:\"orderNavigation\";s:4:\"base\";a:4:{s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:32;s:7:\"paddedb\";i:32;s:7:\"paddedl\";i:32;s:7:\"paddedr\";i:32;}s:5:\"title\";s:0:\"\";s:6:\"padded\";b:1;s:10:\"titleColor\";s:4:\"#000\";}s:4:\"data\";a:4:{i:0;a:2:{s:7:\"content\";s:15:\"cff31093.818d78\";s:6:\"imgUrl\";s:0:\"\";}i:1;a:2:{s:7:\"content\";s:15:\"cff31093.4933ca\";s:6:\"imgUrl\";s:0:\"\";}i:2;a:2:{s:7:\"content\";s:15:\"cff31093.a48b28\";s:6:\"imgUrl\";s:0:\"\";}i:3;a:2:{s:7:\"content\";s:15:\"cff31093.59bd68\";s:6:\"imgUrl\";s:0:\"\";}}s:5:\"track\";s:0:\"\";s:4:\"tags\";a:3:{s:4:\"type\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}s:8:\"tagsType\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}s:2:\"id\";s:1:\"5\";}',0,2),
(6,'yykweishop',1,'custom_1','imgHotzone','v1.0.1','a:10:{s:4:\"name\";s:10:\"imgHotzone\";s:4:\"base\";a:3:{s:9:\"animation\";s:10:\"horizontal\";s:9:\"imgHeight\";i:312;s:11:\"outerMargin\";a:4:{s:7:\"paddedt\";i:32;s:7:\"paddedb\";i:32;s:7:\"paddedl\";i:32;s:7:\"paddedr\";i:32;}}s:6:\"config\";a:3:{s:6:\"imgUrl\";s:168:\"https://shopex-onex-yundian-image.oss-cn-shanghai.aliyuncs.com/demo-ecshopx/image/153/2026/03/14/1e861dec37adcc9400e9030e6e8d53e11773468924308.个人中心菜单ALL.jpg\";s:8:\"imgWidth\";i:750;s:9:\"imgHeight\";i:570;}s:4:\"data\";a:10:{i:0;a:7:{s:9:\"heightPer\";d:0.2762;s:8:\"widthPer\";d:0.2101;s:7:\"leftPer\";d:0.0213;s:6:\"topPer\";d:0.0625;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"报名活动\";s:2:\"id\";s:14:\"registActivity\";}i:1;a:7:{s:9:\"heightPer\";d:0.2622;s:8:\"widthPer\";d:0.1915;s:7:\"leftPer\";d:0.266;s:6:\"topPer\";d:0.0695;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"积分商城\";s:2:\"id\";s:9:\"pointShop\";}i:2;a:7:{s:9:\"heightPer\";d:0.2657;s:8:\"widthPer\";d:0.1915;s:7:\"leftPer\";d:0.5346;s:6:\"topPer\";d:0.066;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"我的收藏\";s:2:\"id\";s:10:\"my_collect\";}i:3;a:7:{s:9:\"heightPer\";d:0.2622;s:8:\"widthPer\";d:0.2074;s:7:\"leftPer\";d:0.7819;s:6:\"topPer\";d:0.0765;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:6:\"客服\";s:2:\"id\";s:15:\"customerService\";}i:4;a:7:{s:9:\"heightPer\";d:0.2483;s:8:\"widthPer\";d:0.1888;s:7:\"leftPer\";d:0.0372;s:6:\"topPer\";d:0.3912;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:6:\"设置\";s:2:\"id\";s:8:\"settings\";}i:5;a:7:{s:9:\"heightPer\";d:0.2587;s:8:\"widthPer\";d:0.1915;s:7:\"leftPer\";d:0.2793;s:6:\"topPer\";d:0.3807;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"地址管理\";s:2:\"id\";s:7:\"address\";}i:6;a:7:{s:9:\"heightPer\";d:0.2308;s:8:\"widthPer\";d:0.2048;s:7:\"leftPer\";d:0.5239;s:6:\"topPer\";d:0.3947;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"我的拼团\";s:2:\"id\";s:5:\"group\";}i:7;a:7:{s:9:\"heightPer\";d:0.2626;s:8:\"widthPer\";d:0.1729;s:7:\"leftPer\";d:0.3005;s:6:\"topPer\";d:0.7374;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"自提订单\";s:2:\"id\";s:9:\"zitiOrder\";}i:8;a:7:{s:9:\"heightPer\";d:0.2451;s:8:\"widthPer\";d:0.1835;s:7:\"leftPer\";d:0.5266;s:6:\"topPer\";d:0.7444;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"种草列表\";s:2:\"id\";s:8:\"hottopic\";}i:9;a:7:{s:9:\"heightPer\";d:0.2451;s:8:\"widthPer\";d:0.1835;s:7:\"leftPer\";d:0.5266;s:6:\"topPer\";d:0.7444;s:8:\"linkPage\";s:4:\"link\";s:5:\"title\";s:12:\"会员开通\";s:2:\"id\";s:9:\"vipgrades\";}}s:5:\"track\";s:0:\"\";s:4:\"tags\";a:3:{s:4:\"type\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}}s:8:\"tagsType\";s:1:\"2\";s:10:\"meber_tags\";a:0:{}s:13:\"no_meber_tags\";a:0:{}s:2:\"id\";s:1:\"6\";}',0,3);