2024-10-10 23:59:02 -- == sync_order start == 2024-10-10 23:59:02 -- start:2024-10-10,end:2024-10-10 2024-10-10 23:59:02 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-10-10%' OR l.modify_date like '2024-10-10%'; 2024-10-10 23:59:03 -- == sync omo_order_list == 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '328910', process_status = '2', pay_status = '1', totalprice_after = '2130', lunar_date = '2024-08-28', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24090294313' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '10570', process_status = '2', pay_status = '1', totalprice_after = '2400', lunar_date = '2024-09-04', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100020933' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424388', process_status = '2', pay_status = '1', totalprice_after = '1850', lunar_date = '2024-09-05', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100022790' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '1', totalprice_after = '87648', lunar_date = '2024-09-06', invoice_status = '0',category_name = '團媽訂單', category_id = '3' where ordernumber = 'S24100027260' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424728', process_status = '2', pay_status = '1', totalprice_after = '2400', lunar_date = '2024-09-06', invoice_status = '0',category_name = '美村門市訂單', category_id = '32' where ordernumber = 'S24100027322' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '384225', process_status = '2', pay_status = '1', totalprice_after = '2310', lunar_date = '2024-09-06', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100028336' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '420830', process_status = '2', pay_status = '1', totalprice_after = '1080', lunar_date = '2024-09-06', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24090227619RB' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424829', process_status = '2', pay_status = '1', totalprice_after = '3845', lunar_date = '2024-09-06', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100029468' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '0', totalprice_after = '250', lunar_date = '2024-09-07', invoice_status = '0',category_name = '蝦皮選物', category_id = '41' where ordernumber = 'S24100030457' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424785', process_status = '2', pay_status = '1', totalprice_after = '18000', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100030547' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424846', process_status = '2', pay_status = '1', totalprice_after = '1490', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100030663' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424866', process_status = '2', pay_status = '1', totalprice_after = '520', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100031171' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '56991', process_status = '2', pay_status = '1', totalprice_after = '1590', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100031225' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '422614', process_status = '2', pay_status = '1', totalprice_after = '1310', lunar_date = '2024-09-07', invoice_status = '0',category_name = '電話訂單', category_id = '12' where ordernumber = 'S24100031333' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '1', totalprice_after = '1830', lunar_date = '2024-09-07', invoice_status = '0',category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'S24100031468' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424884', process_status = '2', pay_status = '1', totalprice_after = '1490', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100031592' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '168397', process_status = '2', pay_status = '0', totalprice_after = '13752', lunar_date = '2024-09-07', invoice_status = '0',category_name = '通路訂單', category_id = '5' where ordernumber = 'S24100031798' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '168397', process_status = '2', pay_status = '0', totalprice_after = '13753', lunar_date = '2024-09-07', invoice_status = '0',category_name = '通路訂單', category_id = '5' where ordernumber = 'S24100031814' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424733', process_status = '2', pay_status = '1', totalprice_after = '1590', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100032062' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424951', process_status = '2', pay_status = '1', totalprice_after = '5930', lunar_date = '2024-09-07', invoice_status = '0',category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'S24100032116' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '423395', process_status = '2', pay_status = '1', totalprice_after = '5800', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100032399' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424790', process_status = '2', pay_status = '1', totalprice_after = '420', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100032540' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '424980', process_status = '2', pay_status = '1', totalprice_after = '1325', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100032692' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '423755', process_status = '1', pay_status = '0', totalprice_after = '10450', lunar_date = '2024-09-07', invoice_status = '1',category_name = ',101專櫃訂單', category_id = ',48' where ordernumber = 'S24100032724' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '210151', process_status = '2', pay_status = '1', totalprice_after = '4800', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100032830' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '425006', process_status = '2', pay_status = '1', totalprice_after = '1240', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100033113' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '425009', process_status = '2', pay_status = '1', totalprice_after = '3660', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100033277' 2024-10-10 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '425010', process_status = '2', pay_status = '1', totalprice_after = '1805', lunar_date = '2024-09-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24100033336' 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388726','425011',1,'','','O24100033498','2','11','1','1','2','','','0','0000-00-00','0','0','0','','280','30','570','111','台北市','士林區','893','金門縣','金城鎮','820','2024-10-10 00:19:57','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388729','425014',1,'','','O24100033559','1','11','1','1','2','','','0','0000-00-00','0','0','0','','150','0','300','408','台中市','南屯區','408','台中市','南屯區','450','2024-10-10 01:00:08','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388732','425017',1,'','','O24100033674','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','30','480','302','新竹縣','竹北市','302','新竹縣','竹北市','600','2024-10-10 01:37:37','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388075','424365',1,'','','O24100033746','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2390','825','高雄市','橋頭區','825','高雄市','橋頭區','2540','2024-10-10 05:12:41','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388732','425017',1,'','','O24100033876','1','11','1','1','2','','','0','0000-00-00','0','0','0','','150','0','480','302','新竹縣','竹北市','302','新竹縣','竹北市','630','2024-10-10 07:27:15','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388734','425019',1,'','','O24100033932','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','990','824','高雄市','燕巢區','824','高雄市','燕巢區','1140','2024-10-10 09:31:50','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388722','425007',1,'','','O24100034076','1','11','1','1','1','','','0','0000-00-00','0','0','0','','0','30','6920','717','台南市','仁德區','717','台南市','仁德區','6890','2024-10-10 10:52:57','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('127418','95961',1,'','','O24100034193','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1120','632','雲林縣','虎尾鎮','632','雲林縣','虎尾鎮','1270','2024-10-10 11:39:25','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388767','425052',1,'','','O24100034250','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1080','812','高雄市','小港區','812','高雄市','小港區','1200','2024-10-10 12:29:18','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('386098','422411',1,'','','O24100034393','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','800','242','新北市','新莊區','242','新北市','新莊區','920','2024-10-10 12:34:45','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388791','425076',1,'永康門市訂單','31','S24100034453','1','1','6','1','3','','','1','2024-10-10','0','0','0','','0','0','3285','106','台北市','大安區','106','台北市','大安區','3285','2024-10-10 13:24:28','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('378543','414949',1,'','','O24100034555','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','420','924','屏東縣','崁頂鄉','924','屏東縣','崁頂鄉','570','2024-10-10 14:48:52','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388919','425204',1,'','','O24100034639','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','480','973','花蓮縣','吉安鄉','973','花蓮縣','吉安鄉','600','2024-10-10 17:12:35','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('271792','309401',1,'','','O24100034732','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','550','545','南投縣','埔里鎮','545','南投縣','埔里鎮','700','2024-10-10 17:13:21','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('371609','408113',1,'','','O24100034833','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1180','249','新北市','八里區','249','新北市','八里區','1330','2024-10-10 17:39:41','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388848','425133',1,'','','O24100034943','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2610','334','桃園市','八德區','334','桃園市','八德區','2730','2024-10-10 17:53:03','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('387519','423819',1,'','','O24100035032','1','2','1','0','0','25838526','高雄縣立仁武高級中學家長會','0','0000-00-00','1200','0','0','','0','30','24000','833','高雄市','鳥松區','814','高雄市','仁武區','22770','2024-10-10 18:24:46','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388949','425234',1,'','','O24100035144','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','0','300','330','桃園市','桃園區','330','桃園市','桃園區','450','2024-10-10 18:54:12','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('299500','336839',1,'','','O24100035222','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1270','510','彰化縣','員林市','510','彰化縣','員林市','1420','2024-10-10 19:48:27','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('372913','409399',1,'','','O24100035398','1','1','1','0','0','','','0','0000-00-00','0','0','0','','0','0','6000','260','宜蘭縣','宜蘭市','260','宜蘭縣','宜蘭市','6000','2024-10-10 20:50:45','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388969','425254',1,'','','O24100035417','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1035','300','新竹市','東區','300','新竹市','東區','1155','2024-10-10 21:02:16','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('261707','299406',1,'','','O24100035564','1','11','1','1','1','01022397','國際獅子會中華民國總會台北市第二支會','0','0000-00-00','2265','0','0','','0','0','45300','242','新北市','新莊區','104','台北市','中山區','43035','2024-10-10 21:43:46','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('299330','336669',1,'','','O24100035639','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','885','542','南投縣','草屯鎮','424','台中市','和平區','1035','2024-10-10 21:58:11','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388973','425258',1,'','','O24100035777','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','30','19500','300','新竹市','北區','300','新竹市','北區','19470','2024-10-10 22:06:55','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('388972','425257',1,'','','O24100035883','1','1','1','1','1','47829091','胤泰企業社','0','0000-00-00','0','0','0','','150','30','2980','710','台南市','永康區','710','台南市','永康區','3100','2024-10-10 22:37:33','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('159912','127248',1,'','','O24100035933','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2820','710','台南市','永康區','710','台南市','永康區','2970','2024-10-10 23:35:24','2024-09-08') 2024-10-10 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('354207','390873',1,'','','O24100036048','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','3570','100','台北市','中正區','100','台北市','中正區','3720','2024-10-10 23:45:03','2024-09-08') 2024-10-10 23:59:04 -- == sync_order end == 2024-10-10 23:59:04 -- == sync_order_detail start == 2024-10-10 23:59:04 -- start:2024-10-10,end:2024-10-10 2024-10-10 23:59:04 -- == sync omo_order_detail == 2024-10-10 23:59:04 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-10-10%' OR modify_date like '2024-10-10%' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090294313' and product_code = 'DG0105126-07' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249291',`firm_id` = '8',`ordernumber` = 'O24090294313', `product_name` = '【官網限定】SNOOPY經典蛋捲3入組',`product_code` = 'DG0105126-07',`product_sn` = 'DG0105126',`product_spec` = '原味+芝麻x2+SNOOPY心意提袋',`invoice_name` = '組合-32入原味+32入芝麻x2+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-10-15',`create_date` = '2024-09-30 15:34:23',`modify_date` = '2024-10-10 09:14:12',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-28'where ordernumber = 'O24090294313' and product_code = 'DG0105126-07' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090294313' and product_code = 'DG0105103-08' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249291',`firm_id` = '8',`ordernumber` = 'O24090294313', `product_name` = 'SNOOPY美好心意-蛋捲三入組',`product_code` = 'DG0105103-08',`product_sn` = 'DG0105103',`product_spec` = '原味+芝麻+海苔',`invoice_name` = '組合-32入(原味+芝麻+海苔)+SNOOPY美好提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-10-15',`create_date` = '2024-09-30 15:34:23',`modify_date` = '2024-10-10 09:14:12',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-28'where ordernumber = 'O24090294313' and product_code = 'DG0105103-08' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100027322' and product_code = 'DG0105142-01' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249591',`firm_id` = '8',`ordernumber` = 'S24100027322', `product_name` = '澎派蛋捲10入組(原味x1+咖啡x5+巧克力x4)',`product_code` = 'DG0105142-01',`product_sn` = 'DG0105142',`product_spec` = '32入原味蛋捲+32入咖啡蛋捲+32入咖啡蛋捲+32入咖啡蛋',`invoice_name` = '組合-32入(原味x1+咖啡x5+巧克力x4)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '2250',`etd` = '2024-10-12',`create_date` = '2024-10-08 11:42:50',`modify_date` = '2024-10-10 15:59:46',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-06'where ordernumber = 'S24100027322' and product_code = 'DG0105142-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090227619RB' and product_code = 'DG010312-02' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249602',`firm_id` = '8',`ordernumber` = 'O24090227619RB', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-10-14',`create_date` = '2024-09-12 17:14:10',`modify_date` = '2024-10-10 08:29:24',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-10'where ordernumber = 'O24090227619RB' and product_code = 'DG010312-02' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100032724' and product_code = 'DG010265-01' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249647',`firm_id` = '8',`ordernumber` = 'S24100032724', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`product_spec` = '原味',`invoice_name` = '提盒-SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '9',`total_price` = '2700',`etd` = '2024-10-21',`create_date` = '2024-10-09 19:24:45',`modify_date` = '2024-10-10 15:43:07',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-07'where ordernumber = 'S24100032724' and product_code = 'DG010265-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100032724' and product_code = 'DG010265-02' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249647',`firm_id` = '8',`ordernumber` = 'S24100032724', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-02',`product_sn` = 'DG010265',`product_spec` = '芝麻',`invoice_name` = '提盒-SNOOPY(粉)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '9',`total_price` = '2700',`etd` = '2024-10-21',`create_date` = '2024-10-09 19:24:45',`modify_date` = '2024-10-10 15:43:07',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-07'where ordernumber = 'S24100032724' and product_code = 'DG010265-02' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100032724' and product_code = 'DG010265-03' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249647',`firm_id` = '8',`ordernumber` = 'S24100032724', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-03',`product_sn` = 'DG010265',`product_spec` = '咖啡',`invoice_name` = '提盒-SNOOPY(粉)-40入咖啡',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-10-21',`create_date` = '2024-10-09 19:24:45',`modify_date` = '2024-10-10 15:43:07',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-07'where ordernumber = 'S24100032724' and product_code = 'DG010265-03' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100032724' and product_code = 'DG010265-04' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249647',`firm_id` = '8',`ordernumber` = 'S24100032724', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-04',`product_sn` = 'DG010265',`product_spec` = '海苔',`invoice_name` = '提盒-SNOOPY(粉)-40入海苔',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-10-21',`create_date` = '2024-10-09 19:24:45',`modify_date` = '2024-10-10 15:43:07',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-07'where ordernumber = 'S24100032724' and product_code = 'DG010265-04' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100032724' and product_code = 'DG010265-05' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249647',`firm_id` = '8',`ordernumber` = 'S24100032724', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-05',`product_sn` = 'DG010265',`product_spec` = '巧克力',`invoice_name` = '提盒-SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '13',`total_price` = '3900',`etd` = '2024-10-21',`create_date` = '2024-10-09 19:24:45',`modify_date` = '2024-10-10 15:43:07',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-07'where ordernumber = 'S24100032724' and product_code = 'DG010265-05' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100032724' and product_code = 'DG0103188-11' 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249647',`firm_id` = '8',`ordernumber` = 'S24100032724', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-11',`product_sn` = 'DG0103188',`product_spec` = '芝麻蛋捲.海苔蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【芝麻+海苔】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-10-21',`create_date` = '2024-10-09 19:24:45',`modify_date` = '2024-10-10 15:43:07',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-07'where ordernumber = 'S24100032724' and product_code = 'DG0103188-11' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033498' and product_code = 'DG0103195-136' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249654','8','O24100033498','【吳淡如聯名】樂饗-8結隨享禮盒','DG0103195-136','DG0103195','原味+芝麻,南棗核桃糕,黑松露腰果','禮盒-吳淡如【原味+芝麻】+南棗核桃糕+黑松露腰果','570','570','0','0','0','0','1','0.0','1','570','2024-10-14','2024-10-10 00:19:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249654',`firm_id` = '8',`ordernumber` = 'O24100033498', `product_name` = '【吳淡如聯名】樂饗-8結隨享禮盒',`product_code` = 'DG0103195-136',`product_sn` = 'DG0103195',`product_spec` = '原味+芝麻,南棗核桃糕,黑松露腰果',`invoice_name` = '禮盒-吳淡如【原味+芝麻】+南棗核桃糕+黑松露腰果',`listprice` = '570',`sellingprice` = '570',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '570',`etd` = '2024-10-14',`create_date` = '2024-10-10 00:19:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033498' and product_code = 'DG0103195-136' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033559' and product_code = 'BP010184-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249655','8','O24100033559','SNOOPY盥洗收納包','BP010184-01','BP010184','SNOOPY盥洗收納包','SNOOPY盥洗收納包','300','300','0','0','0','0','1','0.0','1','300','2024-10-15','2024-10-10 01:00:08','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249655',`firm_id` = '8',`ordernumber` = 'O24100033559', `product_name` = 'SNOOPY盥洗收納包',`product_code` = 'BP010184-01',`product_sn` = 'BP010184',`product_spec` = 'SNOOPY盥洗收納包',`invoice_name` = 'SNOOPY盥洗收納包',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-15',`create_date` = '2024-10-10 01:00:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033559' and product_code = 'BP010184-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033674' and product_code = 'DG010312-09' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249656','8','O24100033674','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-10-14','2024-10-10 01:37:37','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249656',`firm_id` = '8',`ordernumber` = 'O24100033674', `product_name` = '【芝麻+巧克力】金8結禮盒',`product_code` = 'DG010312-09',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-10 01:37:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033674' and product_code = 'DG010312-09' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033746' and product_code = 'BP010178-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249657','8','O24100033746','SNOOPY美好提袋','BP010178-01','BP010178','SNOOPY美好提袋','SNOOPY美好提袋','490','490','0','0','0','0','1','0.0','1','490','2024-10-14','2024-10-10 05:12:41','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249657',`firm_id` = '8',`ordernumber` = 'O24100033746', `product_name` = 'SNOOPY美好提袋',`product_code` = 'BP010178-01',`product_sn` = 'BP010178',`product_spec` = 'SNOOPY美好提袋',`invoice_name` = 'SNOOPY美好提袋',`listprice` = '490',`sellingprice` = '490',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '490',`etd` = '2024-10-14',`create_date` = '2024-10-10 05:12:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033746' and product_code = 'BP010178-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033746' and product_code = 'DG0103188-06' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249657','8','O24100033746','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-06','DG0103188','原味蛋捲,芝麻蛋捲','禮盒-SNOOPY(橘)【原味+芝麻】','500','500','0','0','0','0','1','0.0','1','500','2024-10-14','2024-10-10 05:12:41','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249657',`firm_id` = '8',`ordernumber` = 'O24100033746', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-06',`product_sn` = 'DG0103188',`product_spec` = '原味蛋捲,芝麻蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【原味+芝麻】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-10-14',`create_date` = '2024-10-10 05:12:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033746' and product_code = 'DG0103188-06' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033746' and product_code = 'BP010179-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249657','8','O24100033746','[加購]加購-SNOOPY美好提袋','BP010179-01','BP010179','-','加購-SNOOPY美好提袋','390','390','1','1','390','0','0','0.0','2','780','2024-10-14','2024-10-10 05:12:41','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249657',`firm_id` = '8',`ordernumber` = 'O24100033746', `product_name` = '[加購]加購-SNOOPY美好提袋',`product_code` = 'BP010179-01',`product_sn` = 'BP010179',`product_spec` = '-',`invoice_name` = '加購-SNOOPY美好提袋',`listprice` = '390',`sellingprice` = '390',`isadd` = '1',`isbaby` = '1',`addprice` = '390',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '780',`etd` = '2024-10-14',`create_date` = '2024-10-10 05:12:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033746' and product_code = 'BP010179-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033746' and product_code = 'BP010185-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249657','8','O24100033746','[加購]加購-SNOOPY盥洗收納包','BP010185-01','BP010185','-','加購-SNOOPY盥洗收納包','250','250','1','1','250','0','0','0.0','2','500','2024-10-14','2024-10-10 05:12:41','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249657',`firm_id` = '8',`ordernumber` = 'O24100033746', `product_name` = '[加購]加購-SNOOPY盥洗收納包',`product_code` = 'BP010185-01',`product_sn` = 'BP010185',`product_spec` = '-',`invoice_name` = '加購-SNOOPY盥洗收納包',`listprice` = '250',`sellingprice` = '250',`isadd` = '1',`isbaby` = '1',`addprice` = '250',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '500',`etd` = '2024-10-14',`create_date` = '2024-10-10 05:12:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033746' and product_code = 'BP010185-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033746' and product_code = 'BP010182-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249657','8','O24100033746','[加購]加購-SNOOPY飲料提袋','BP010182-01','BP010182','-','加購-SNOOPY飲料提袋','120','120','1','1','120','0','0','0.0','1','120','2024-10-14','2024-10-10 05:12:41','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249657',`firm_id` = '8',`ordernumber` = 'O24100033746', `product_name` = '[加購]加購-SNOOPY飲料提袋',`product_code` = 'BP010182-01',`product_sn` = 'BP010182',`product_spec` = '-',`invoice_name` = '加購-SNOOPY飲料提袋',`listprice` = '120',`sellingprice` = '120',`isadd` = '1',`isbaby` = '1',`addprice` = '120',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '120',`etd` = '2024-10-14',`create_date` = '2024-10-10 05:12:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033746' and product_code = 'BP010182-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033876' and product_code = 'DG010312-09' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249658','8','O24100033876','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-10-14','2024-10-10 07:27:15','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249658',`firm_id` = '8',`ordernumber` = 'O24100033876', `product_name` = '【芝麻+巧克力】金8結禮盒',`product_code` = 'DG010312-09',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-10 07:27:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033876' and product_code = 'DG010312-09' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100033932' and product_code = 'DG0105103-22' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249659','8','O24100033932','SNOOPY美好心意-蛋捲三入組','DG0105103-22','DG0105103','芝麻+咖啡+巧克力','組合-32入(芝麻+咖啡+巧克力)+SNOOPY美好提袋','990','990','0','0','0','1','1','0.0','1','990','2024-10-16','2024-10-10 09:31:50','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249659',`firm_id` = '8',`ordernumber` = 'O24100033932', `product_name` = 'SNOOPY美好心意-蛋捲三入組',`product_code` = 'DG0105103-22',`product_sn` = 'DG0105103',`product_spec` = '芝麻+咖啡+巧克力',`invoice_name` = '組合-32入(芝麻+咖啡+巧克力)+SNOOPY美好提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-10-16',`create_date` = '2024-10-10 09:31:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100033932' and product_code = 'DG0105103-22' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'DG010101-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','10','2800','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '10',`total_price` = '2800',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'DG010101-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'DG010101-02' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'DG010101-02' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'DG010101-03' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','5','1400','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '5',`total_price` = '1400',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'DG010101-03' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'DG010101-04' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`product_sn` = 'DG010101',`product_spec` = '單盒',`invoice_name` = '40入海苔蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'DG010101-04' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'DG010101-05' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','6','1680','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '6',`total_price` = '1680',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'DG010101-05' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'DG010107-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','2','480','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'DG010107-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034076' and product_code = 'ZP010146-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249660','8','O24100034076','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-10 10:52:57','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249660',`firm_id` = '8',`ordernumber` = 'O24100034076', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-10 10:52:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034076' and product_code = 'ZP010146-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034193' and product_code = 'DG010101-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249661','8','O24100034193','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2024-10-14','2024-10-10 11:39:25','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249661',`firm_id` = '8',`ordernumber` = 'O24100034193', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '4',`total_price` = '1120',`etd` = '2024-10-14',`create_date` = '2024-10-10 11:39:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034193' and product_code = 'DG010101-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034250' and product_code = 'DG010107-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249662','8','O24100034250','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','1','240','2024-10-16','2024-10-10 12:29:18','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249662',`firm_id` = '8',`ordernumber` = 'O24100034250', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-10-16',`create_date` = '2024-10-10 12:29:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034250' and product_code = 'DG010107-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034250' and product_code = 'DG010101-05' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249662','8','O24100034250','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-16','2024-10-10 12:29:18','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249662',`firm_id` = '8',`ordernumber` = 'O24100034250', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-16',`create_date` = '2024-10-10 12:29:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034250' and product_code = 'DG010101-05' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034250' and product_code = 'DG010101-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249662','8','O24100034250','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-16','2024-10-10 12:29:18','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249662',`firm_id` = '8',`ordernumber` = 'O24100034250', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-16',`create_date` = '2024-10-10 12:29:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034250' and product_code = 'DG010101-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034250' and product_code = 'DG010101-03' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249662','8','O24100034250','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-16','2024-10-10 12:29:18','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249662',`firm_id` = '8',`ordernumber` = 'O24100034250', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-16',`create_date` = '2024-10-10 12:29:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034250' and product_code = 'DG010101-03' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034393' and product_code = 'TE010101-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249663','8','O24100034393','棗香枸杞茶','TE010101-01','TE010101','6入紅棗枸杞茶包','(盒)枸杞茶','160','160','0','0','0','0','1','160.0','5','800','2024-10-14','2024-10-10 12:34:45','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249663',`firm_id` = '8',`ordernumber` = 'O24100034393', `product_name` = '棗香枸杞茶',`product_code` = 'TE010101-01',`product_sn` = 'TE010101',`product_spec` = '6入紅棗枸杞茶包',`invoice_name` = '(盒)枸杞茶',`listprice` = '160',`sellingprice` = '160',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '160.0',`amount` = '5',`total_price` = '800',`etd` = '2024-10-14',`create_date` = '2024-10-10 12:34:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034393' and product_code = 'TE010101-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100034453' and product_code = 'DG0103182-106' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249664','8','S24100034453','金巧8結禮盒','DG0103182-106','DG0103182','芝麻.鳳梨酥.鳳梨酥','禮盒-金巧8結【(芝麻)-鳳梨酥+鳳梨酥】','595','595','0','0','0','0','1','0.0','5','2975','2024-10-10','2024-10-10 13:24:28','2024-10-10 23:59:06',0,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249664',`firm_id` = '8',`ordernumber` = 'S24100034453', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-106',`product_sn` = 'DG0103182',`product_spec` = '芝麻.鳳梨酥.鳳梨酥',`invoice_name` = '禮盒-金巧8結【(芝麻)-鳳梨酥+鳳梨酥】',`listprice` = '595',`sellingprice` = '595',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '2975',`etd` = '2024-10-10',`create_date` = '2024-10-10 13:24:28',`modify_date` = '2024-10-10 13:40:55',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'S24100034453' and product_code = 'DG0103182-106' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100034453' and product_code = 'FL010104-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249664','8','S24100034453','加購－一口鳳梨酥','FL010104-01','FL010104','8入鳳梨酥','加購-(盒)鳳梨酥','155','155','1','0','155','1','1','0.0','2','310','2024-10-10','2024-10-10 13:24:28','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249664',`firm_id` = '8',`ordernumber` = 'S24100034453', `product_name` = '加購－一口鳳梨酥',`product_code` = 'FL010104-01',`product_sn` = 'FL010104',`product_spec` = '8入鳳梨酥',`invoice_name` = '加購-(盒)鳳梨酥',`listprice` = '155',`sellingprice` = '155',`isadd` = '1',`isbaby` = '0',`addprice` = '155',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '310',`etd` = '2024-10-10',`create_date` = '2024-10-10 13:24:28',`modify_date` = '2024-10-10 13:40:55',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'S24100034453' and product_code = 'FL010104-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034555' and product_code = 'DG010101-02' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249665','8','O24100034555','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-31','2024-10-10 14:48:52','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249665',`firm_id` = '8',`ordernumber` = 'O24100034555', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-31',`create_date` = '2024-10-10 14:48:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034555' and product_code = 'DG010101-02' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034555' and product_code = 'TG010115-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249665','8','O24100034555','[加購]加購－黑曜芝麻糕(盒裝12入)','TG010115-01','TG010115','-','加購-(盒)芝麻糕','140','140','1','1','140','0','0','0.0','1','140','2024-10-31','2024-10-10 14:48:52','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249665',`firm_id` = '8',`ordernumber` = 'O24100034555', `product_name` = '[加購]加購－黑曜芝麻糕(盒裝12入)',`product_code` = 'TG010115-01',`product_sn` = 'TG010115',`product_spec` = '-',`invoice_name` = '加購-(盒)芝麻糕',`listprice` = '140',`sellingprice` = '140',`isadd` = '1',`isbaby` = '1',`addprice` = '140',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '140',`etd` = '2024-10-31',`create_date` = '2024-10-10 14:48:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034555' and product_code = 'TG010115-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034639' and product_code = 'DG010312-05' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249666','8','O24100034639','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-10-14','2024-10-10 17:12:35','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249666',`firm_id` = '8',`ordernumber` = 'O24100034639', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-10 17:12:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034639' and product_code = 'DG010312-05' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034732' and product_code = 'BP010184-01' 2024-10-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249667','8','O24100034732','SNOOPY盥洗收納包','BP010184-01','BP010184','SNOOPY盥洗收納包','SNOOPY盥洗收納包','300','300','0','0','0','0','1','0.0','1','300','2024-10-15','2024-10-10 17:13:21','2024-10-10 23:59:06',null,'1','2024-09-08') 2024-10-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249667',`firm_id` = '8',`ordernumber` = 'O24100034732', `product_name` = 'SNOOPY盥洗收納包',`product_code` = 'BP010184-01',`product_sn` = 'BP010184',`product_spec` = 'SNOOPY盥洗收納包',`invoice_name` = 'SNOOPY盥洗收納包',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-15',`create_date` = '2024-10-10 17:13:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034732' and product_code = 'BP010184-01' 2024-10-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034732' and product_code = 'BP010188-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249667','8','O24100034732','[加購]加購-SNOOPY面紙套','BP010188-01','BP010188','-','加購-SNOOPY面紙套','250','250','1','1','250','0','0','0.0','1','250','2024-10-15','2024-10-10 17:13:21','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249667',`firm_id` = '8',`ordernumber` = 'O24100034732', `product_name` = '[加購]加購-SNOOPY面紙套',`product_code` = 'BP010188-01',`product_sn` = 'BP010188',`product_spec` = '-',`invoice_name` = '加購-SNOOPY面紙套',`listprice` = '250',`sellingprice` = '250',`isadd` = '1',`isbaby` = '1',`addprice` = '250',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '250',`etd` = '2024-10-15',`create_date` = '2024-10-10 17:13:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034732' and product_code = 'BP010188-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034833' and product_code = 'DG0103132-02' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249668','8','O24100034833','8結肉酥酥【紅提袋裝】','DG0103132-02','DG0103132','原味+原辣肉酥酥','組合-40入原味+原辣肉酥酥+紅色提袋','590','590','0','0','0','0','1','0.0','1','590','2024-10-14','2024-10-10 17:39:41','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249668',`firm_id` = '8',`ordernumber` = 'O24100034833', `product_name` = '8結肉酥酥【紅提袋裝】',`product_code` = 'DG0103132-02',`product_sn` = 'DG0103132',`product_spec` = '原味+原辣肉酥酥',`invoice_name` = '組合-40入原味+原辣肉酥酥+紅色提袋',`listprice` = '590',`sellingprice` = '590',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '590',`etd` = '2024-10-14',`create_date` = '2024-10-10 17:39:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034833' and product_code = 'DG0103132-02' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034833' and product_code = 'DG0103132-08' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249668','8','O24100034833','8結肉酥酥【紅提袋裝】','DG0103132-08','DG0103132','咖啡+原辣肉酥酥','組合-40入咖啡+原辣肉酥酥+紅色提袋','590','590','0','0','0','0','1','0.0','1','590','2024-10-14','2024-10-10 17:39:41','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249668',`firm_id` = '8',`ordernumber` = 'O24100034833', `product_name` = '8結肉酥酥【紅提袋裝】',`product_code` = 'DG0103132-08',`product_sn` = 'DG0103132',`product_spec` = '咖啡+原辣肉酥酥',`invoice_name` = '組合-40入咖啡+原辣肉酥酥+紅色提袋',`listprice` = '590',`sellingprice` = '590',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '590',`etd` = '2024-10-14',`create_date` = '2024-10-10 17:39:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034833' and product_code = 'DG0103132-08' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034943' and product_code = 'DG0105127-214' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249669','8','O24100034943','【官網限定】熱銷蛋捲6入組','DG0105127-214','DG0105127','原味+咖啡x2+巧克力x2+阿薩姆紅茶+紅色提袋x2','組合-32入(原味x1+咖啡x2+巧克力x2+阿薩姆紅茶x1)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-18','2024-10-10 17:53:03','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249669',`firm_id` = '8',`ordernumber` = 'O24100034943', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-214',`product_sn` = 'DG0105127',`product_spec` = '原味+咖啡x2+巧克力x2+阿薩姆紅茶+紅色提袋x2',`invoice_name` = '組合-32入(原味x1+咖啡x2+巧克力x2+阿薩姆紅茶x1)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-18',`create_date` = '2024-10-10 17:53:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034943' and product_code = 'DG0105127-214' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034943' and product_code = 'DG010101-02' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249669','8','O24100034943','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-18','2024-10-10 17:53:03','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249669',`firm_id` = '8',`ordernumber` = 'O24100034943', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-18',`create_date` = '2024-10-10 17:53:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034943' and product_code = 'DG010101-02' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034943' and product_code = 'DG010312-06' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249669','8','O24100034943','【芝麻＋芝麻】金8結禮盒','DG010312-06','DG010312','金8結盒','禮盒-金8結【芝麻+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-10-18','2024-10-10 17:53:03','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249669',`firm_id` = '8',`ordernumber` = 'O24100034943', `product_name` = '【芝麻＋芝麻】金8結禮盒',`product_code` = 'DG010312-06',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-18',`create_date` = '2024-10-10 17:53:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034943' and product_code = 'DG010312-06' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100034943' and product_code = 'DG010312-14' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249669','8','O24100034943','【海苔+巧克力】金8結禮盒','DG010312-14','DG010312','金8結盒','禮盒-金8結【海苔+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-10-18','2024-10-10 17:53:03','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249669',`firm_id` = '8',`ordernumber` = 'O24100034943', `product_name` = '【海苔+巧克力】金8結禮盒',`product_code` = 'DG010312-14',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【海苔+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-18',`create_date` = '2024-10-10 17:53:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100034943' and product_code = 'DG010312-14' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-02' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','8','3840','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '8',`total_price` = '3840',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-02' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-03' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','7','3360','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '7',`total_price` = '3360',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-03' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-05' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','7','3360','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '7',`total_price` = '3360',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-05' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-07' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【芝麻+咖啡】金8結禮盒','DG010312-07','DG010312','金8結盒','禮盒-金8結【芝麻+咖啡】','590','480','0','0','0','0','1','480.0','7','3360','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【芝麻+咖啡】金8結禮盒',`product_code` = 'DG010312-07',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '7',`total_price` = '3360',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-07' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-08' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【芝麻+海苔】金8結禮盒','DG010312-08','DG010312','金8結盒','禮盒-金8結【芝麻+海苔】','590','480','0','0','0','0','1','480.0','7','3360','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【芝麻+海苔】金8結禮盒',`product_code` = 'DG010312-08',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '7',`total_price` = '3360',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-08' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-12' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','7','3360','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【咖啡+巧克力】金8結禮盒',`product_code` = 'DG010312-12',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '7',`total_price` = '3360',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-12' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'DG010312-11' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','【咖啡+海苔】金8結禮盒','DG010312-11','DG010312','金8結盒','禮盒-金8結【咖啡+海苔】','590','480','0','0','0','0','1','480.0','7','3360','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '【咖啡+海苔】金8結禮盒',`product_code` = 'DG010312-11',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '7',`total_price` = '3360',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'DG010312-11' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035032' and product_code = 'ZP010527-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249670','8','O24100035032','贈品-南棗核桃糕分享包x6','ZP010527-01','ZP010527','一組','贈品-(紅袋)南棗核桃糕x6','0','0','0','0','0','0','1','0.0','1','0','2024-10-15','2024-10-10 18:24:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249670',`firm_id` = '8',`ordernumber` = 'O24100035032', `product_name` = '贈品-南棗核桃糕分享包x6',`product_code` = 'ZP010527-01',`product_sn` = 'ZP010527',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕x6',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-15',`create_date` = '2024-10-10 18:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035032' and product_code = 'ZP010527-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035144' and product_code = 'BP010184-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249671','8','O24100035144','SNOOPY盥洗收納包','BP010184-01','BP010184','SNOOPY盥洗收納包','SNOOPY盥洗收納包','300','300','0','0','0','0','1','0.0','1','300','2024-10-14','2024-10-10 18:54:12','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249671',`firm_id` = '8',`ordernumber` = 'O24100035144', `product_name` = 'SNOOPY盥洗收納包',`product_code` = 'BP010184-01',`product_sn` = 'BP010184',`product_spec` = 'SNOOPY盥洗收納包',`invoice_name` = 'SNOOPY盥洗收納包',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-14',`create_date` = '2024-10-10 18:54:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035144' and product_code = 'BP010184-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035222' and product_code = 'DG0105126-11' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249672','8','O24100035222','【官網限定】SNOOPY經典蛋捲3入組','DG0105126-11','DG0105126','原味+芝麻+阿薩姆紅茶+SNOOPY心意提袋','組合-32入原味+32入芝麻+32入阿薩姆紅茶+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-10-21','2024-10-10 19:48:27','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249672',`firm_id` = '8',`ordernumber` = 'O24100035222', `product_name` = '【官網限定】SNOOPY經典蛋捲3入組',`product_code` = 'DG0105126-11',`product_sn` = 'DG0105126',`product_spec` = '原味+芝麻+阿薩姆紅茶+SNOOPY心意提袋',`invoice_name` = '組合-32入原味+32入芝麻+32入阿薩姆紅茶+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-10-21',`create_date` = '2024-10-10 19:48:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035222' and product_code = 'DG0105126-11' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035222' and product_code = 'DG010101-05' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249672','8','O24100035222','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-21','2024-10-10 19:48:27','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249672',`firm_id` = '8',`ordernumber` = 'O24100035222', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-21',`create_date` = '2024-10-10 19:48:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035222' and product_code = 'DG010101-05' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035398' and product_code = 'DG010265-02' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249673','8','O24100035398','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-02','DG010265','芝麻','提盒-SNOOPY(粉)-40入芝麻','300','300','0','0','0','0','1','0.0','20','6000','2024-10-14','2024-10-10 20:50:45','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249673',`firm_id` = '8',`ordernumber` = 'O24100035398', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-02',`product_sn` = 'DG010265',`product_spec` = '芝麻',`invoice_name` = '提盒-SNOOPY(粉)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '20',`total_price` = '6000',`etd` = '2024-10-14',`create_date` = '2024-10-10 20:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035398' and product_code = 'DG010265-02' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035398' and product_code = 'ZP010146-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249673','8','O24100035398','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-10 20:50:45','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249673',`firm_id` = '8',`ordernumber` = 'O24100035398', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-10 20:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035398' and product_code = 'ZP010146-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035417' and product_code = 'GG010504-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249674','8','O24100035417','手工腰果脆糖提盒','GG010504-01','GG010504','一組','提盒-手工腰果脆糖(100gx2)','540','540','0','0','0','0','1','0.0','1','540','2024-10-15','2024-10-10 21:02:16','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249674',`firm_id` = '8',`ordernumber` = 'O24100035417', `product_name` = '手工腰果脆糖提盒',`product_code` = 'GG010504-01',`product_sn` = 'GG010504',`product_spec` = '一組',`invoice_name` = '提盒-手工腰果脆糖(100gx2)',`listprice` = '540',`sellingprice` = '540',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '540',`etd` = '2024-10-15',`create_date` = '2024-10-10 21:02:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035417' and product_code = 'GG010504-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035417' and product_code = 'FL010308-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249674','8','O24100035417','一口酥24入家庭號禮盒','FL010308-01','12586','24入鳳梨酥','禮盒-24入家庭號【鳳梨酥】','495','495','0','0','0','0','1','0.0','1','495','2024-10-15','2024-10-10 21:02:16','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249674',`firm_id` = '8',`ordernumber` = 'O24100035417', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010308-01',`product_sn` = '12586',`product_spec` = '24入鳳梨酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2024-10-15',`create_date` = '2024-10-10 21:02:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035417' and product_code = 'FL010308-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035564' and product_code = 'DG010313-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249675','8','O24100035564','金8結雙蜜禮盒','DG010313-01','DG010313','原味蛋捲+醇蜜2瓶','禮盒-金8結【原味+雙蜜】','755','755','0','0','0','0','1','755.0','60','45300','2024-10-21','2024-10-10 21:43:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249675',`firm_id` = '8',`ordernumber` = 'O24100035564', `product_name` = '金8結雙蜜禮盒',`product_code` = 'DG010313-01',`product_sn` = 'DG010313',`product_spec` = '原味蛋捲+醇蜜2瓶',`invoice_name` = '禮盒-金8結【原味+雙蜜】',`listprice` = '755',`sellingprice` = '755',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '755.0',`amount` = '60',`total_price` = '45300',`etd` = '2024-10-21',`create_date` = '2024-10-10 21:43:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035564' and product_code = 'DG010313-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035564' and product_code = 'ZP010533-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249675','8','O24100035564','贈品-南棗核桃糕分享包x12','ZP010533-01','ZP010533','一組','贈品-(紅袋)南棗核桃糕x12','0','0','0','0','0','0','1','0.0','1','0','2024-10-21','2024-10-10 21:43:46','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249675',`firm_id` = '8',`ordernumber` = 'O24100035564', `product_name` = '贈品-南棗核桃糕分享包x12',`product_code` = 'ZP010533-01',`product_sn` = 'ZP010533',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕x12',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-21',`create_date` = '2024-10-10 21:43:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035564' and product_code = 'ZP010533-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035639' and product_code = 'DG010206-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249676','8','O24100035639','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','2','590','2024-10-14','2024-10-10 21:58:11','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249676',`firm_id` = '8',`ordernumber` = 'O24100035639', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '590',`etd` = '2024-10-14',`create_date` = '2024-10-10 21:58:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035639' and product_code = 'DG010206-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035639' and product_code = 'DG010206-02' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249676','8','O24100035639','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','1','295','2024-10-14','2024-10-10 21:58:11','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249676',`firm_id` = '8',`ordernumber` = 'O24100035639', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-02',`product_sn` = 'DG010206',`product_spec` = '芝麻',`invoice_name` = '提盒-品牌(紅)-40入芝麻蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-10-14',`create_date` = '2024-10-10 21:58:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035639' and product_code = 'DG010206-02' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035777' and product_code = 'DG0105123-09' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249677','8','O24100035777','【期間限定】8結核桃糕提袋組(32入蛋捲2+核桃糕+品牌提袋','DG0105123-09','DG0105123','芝麻+海苔+(盒)南棗核桃糕+紅色提袋','組合-32入芝麻+32入海苔+(盒)南棗核桃糕+紅色提袋','650','650','0','0','0','1','1','0.0','28','18200','2024-10-31','2024-10-10 22:06:55','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249677',`firm_id` = '8',`ordernumber` = 'O24100035777', `product_name` = '【期間限定】8結核桃糕提袋組(32入蛋捲2+核桃糕+品牌提袋',`product_code` = 'DG0105123-09',`product_sn` = 'DG0105123',`product_spec` = '芝麻+海苔+(盒)南棗核桃糕+紅色提袋',`invoice_name` = '組合-32入芝麻+32入海苔+(盒)南棗核桃糕+紅色提袋',`listprice` = '650',`sellingprice` = '650',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '28',`total_price` = '18200',`etd` = '2024-10-31',`create_date` = '2024-10-10 22:06:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035777' and product_code = 'DG0105123-09' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035777' and product_code = 'DG0105123-06' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249677','8','O24100035777','【期間限定】8結核桃糕提袋組(32入蛋捲2+核桃糕+品牌提袋','DG0105123-06','DG0105123','原味+阿薩姆紅茶+(盒)南棗核桃糕+紅色提袋','組合-32入原味+32入阿薩姆紅茶+(盒)南棗核桃糕+紅色提袋','650','650','0','0','0','1','1','0.0','1','650','2024-10-31','2024-10-10 22:06:55','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249677',`firm_id` = '8',`ordernumber` = 'O24100035777', `product_name` = '【期間限定】8結核桃糕提袋組(32入蛋捲2+核桃糕+品牌提袋',`product_code` = 'DG0105123-06',`product_sn` = 'DG0105123',`product_spec` = '原味+阿薩姆紅茶+(盒)南棗核桃糕+紅色提袋',`invoice_name` = '組合-32入原味+32入阿薩姆紅茶+(盒)南棗核桃糕+紅色提袋',`listprice` = '650',`sellingprice` = '650',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '650',`etd` = '2024-10-31',`create_date` = '2024-10-10 22:06:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035777' and product_code = 'DG0105123-06' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035777' and product_code = 'DG0105123-17' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249677','8','O24100035777','【期間限定】8結核桃糕提袋組(32入蛋捲2+核桃糕+品牌提袋','DG0105123-17','DG0105123','海苔+巧克力+(盒)南棗核桃糕+紅色提袋','組合-32入海苔+32入巧克力+(盒)南棗核桃糕+紅色提袋','650','650','0','0','0','1','1','0.0','1','650','2024-10-31','2024-10-10 22:06:55','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249677',`firm_id` = '8',`ordernumber` = 'O24100035777', `product_name` = '【期間限定】8結核桃糕提袋組(32入蛋捲2+核桃糕+品牌提袋',`product_code` = 'DG0105123-17',`product_sn` = 'DG0105123',`product_spec` = '海苔+巧克力+(盒)南棗核桃糕+紅色提袋',`invoice_name` = '組合-32入海苔+32入巧克力+(盒)南棗核桃糕+紅色提袋',`listprice` = '650',`sellingprice` = '650',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '650',`etd` = '2024-10-31',`create_date` = '2024-10-10 22:06:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035777' and product_code = 'DG0105123-17' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035777' and product_code = 'ZP010526-01' 2024-10-10 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249677','8','O24100035777','贈品-南棗核桃糕分享包x5','ZP010526-01','ZP010526','一組','贈品-(紅袋)南棗核桃糕x5','0','0','0','0','0','0','1','0.0','1','0','2024-10-31','2024-10-10 22:06:55','2024-10-10 23:59:07',null,'1','2024-09-08') 2024-10-10 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249677',`firm_id` = '8',`ordernumber` = 'O24100035777', `product_name` = '贈品-南棗核桃糕分享包x5',`product_code` = 'ZP010526-01',`product_sn` = 'ZP010526',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕x5',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-31',`create_date` = '2024-10-10 22:06:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035777' and product_code = 'ZP010526-01' 2024-10-10 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035883' and product_code = 'DG010107-01' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249678','8','O24100035883','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','1','240','2024-10-14','2024-10-10 22:37:33','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249678',`firm_id` = '8',`ordernumber` = 'O24100035883', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-10-14',`create_date` = '2024-10-10 22:37:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035883' and product_code = 'DG010107-01' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035883' and product_code = 'DG0105127-19' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249678','8','O24100035883','【官網限定】熱銷蛋捲6入組','DG0105127-19','DG0105127','原味x4+巧克力x2+紅色提袋x2','組合-32入(原味x4+巧克力x2)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-10 22:37:33','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249678',`firm_id` = '8',`ordernumber` = 'O24100035883', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-19',`product_sn` = 'DG0105127',`product_spec` = '原味x4+巧克力x2+紅色提袋x2',`invoice_name` = '組合-32入(原味x4+巧克力x2)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-10 22:37:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035883' and product_code = 'DG0105127-19' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035883' and product_code = 'DG0105127-01' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249678','8','O24100035883','【官網限定】熱銷蛋捲6入組','DG0105127-01','DG0105127','原味x6+紅色提袋x2','組合-32入(原味x6)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-10 22:37:33','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249678',`firm_id` = '8',`ordernumber` = 'O24100035883', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-01',`product_sn` = 'DG0105127',`product_spec` = '原味x6+紅色提袋x2',`invoice_name` = '組合-32入(原味x6)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-10 22:37:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035883' and product_code = 'DG0105127-01' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035933' and product_code = 'DG0105127-379' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249679','8','O24100035933','【官網限定】熱銷蛋捲6入組','DG0105127-379','DG0105127','咖啡x6+紅色提袋x2','組合-32入(咖啡x6)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-11-01','2024-10-10 23:35:24','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249679',`firm_id` = '8',`ordernumber` = 'O24100035933', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-379',`product_sn` = 'DG0105127',`product_spec` = '咖啡x6+紅色提袋x2',`invoice_name` = '組合-32入(咖啡x6)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-11-01',`create_date` = '2024-10-10 23:35:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035933' and product_code = 'DG0105127-379' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035933' and product_code = 'DG0105127-456' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249679','8','O24100035933','【官網限定】熱銷蛋捲6入組','DG0105127-456','DG0105127','巧克力x6+紅色提袋x2','組合-32入(巧克力x6)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-11-01','2024-10-10 23:35:24','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249679',`firm_id` = '8',`ordernumber` = 'O24100035933', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-456',`product_sn` = 'DG0105127',`product_spec` = '巧克力x6+紅色提袋x2',`invoice_name` = '組合-32入(巧克力x6)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-11-01',`create_date` = '2024-10-10 23:35:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035933' and product_code = 'DG0105127-456' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035933' and product_code = 'BP010128-01' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249679','8','O24100035933','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','6','60','2024-11-01','2024-10-10 23:35:24','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249679',`firm_id` = '8',`ordernumber` = 'O24100035933', `product_name` = '8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '提袋/個',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '60',`etd` = '2024-11-01',`create_date` = '2024-10-10 23:35:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035933' and product_code = 'BP010128-01' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100035933' and product_code = 'DG010404-01' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249679','8','O24100035933','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','2','20','2024-11-01','2024-10-10 23:35:24','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249679',`firm_id` = '8',`ordernumber` = 'O24100035933', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '20',`etd` = '2024-11-01',`create_date` = '2024-10-10 23:35:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100035933' and product_code = 'DG010404-01' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100036048' and product_code = 'DG0105135-07' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249680','8','O24100036048','【官網限定】澎派蛋捲10入組','DG0105135-07','DG0105135','巧克力x5+阿薩姆紅茶x5','組合-32入(巧克力x5+阿薩姆紅茶x5)','2250','2250','0','0','0','1','1','0.0','1','2250','2024-10-14','2024-10-10 23:45:03','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249680',`firm_id` = '8',`ordernumber` = 'O24100036048', `product_name` = '【官網限定】澎派蛋捲10入組',`product_code` = 'DG0105135-07',`product_sn` = 'DG0105135',`product_spec` = '巧克力x5+阿薩姆紅茶x5',`invoice_name` = '組合-32入(巧克力x5+阿薩姆紅茶x5)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '2250',`etd` = '2024-10-14',`create_date` = '2024-10-10 23:45:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100036048' and product_code = 'DG0105135-07' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100036048' and product_code = 'DG010312-06' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249680','8','O24100036048','【芝麻＋芝麻】金8結禮盒','DG010312-06','DG010312','金8結盒','禮盒-金8結【芝麻+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-10-14','2024-10-10 23:45:03','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249680',`firm_id` = '8',`ordernumber` = 'O24100036048', `product_name` = '【芝麻＋芝麻】金8結禮盒',`product_code` = 'DG010312-06',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-10 23:45:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100036048' and product_code = 'DG010312-06' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100036048' and product_code = 'DG010101-01' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249680','8','O24100036048','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-10-14','2024-10-10 23:45:03','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249680',`firm_id` = '8',`ordernumber` = 'O24100036048', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-10-14',`create_date` = '2024-10-10 23:45:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100036048' and product_code = 'DG010101-01' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100036048' and product_code = 'DG010101-02' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249680','8','O24100036048','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-10 23:45:03','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249680',`firm_id` = '8',`ordernumber` = 'O24100036048', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-10 23:45:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100036048' and product_code = 'DG010101-02' 2024-10-10 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100036048' and product_code = 'ZP010146-01' 2024-10-10 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249680','8','O24100036048','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-10 23:45:03','2024-10-10 23:59:08',null,'1','2024-09-08') 2024-10-10 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249680',`firm_id` = '8',`ordernumber` = 'O24100036048', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-10 23:45:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-08'where ordernumber = 'O24100036048' and product_code = 'ZP010146-01' 2024-10-10 23:59:08 -- == sync_order_detail end == 2024-10-10 23:59:08 -- == sync_order start == 2024-10-10 23:59:08 -- start:2024-10-10,end:2024-10-10 2024-10-10 23:59:08 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-10-10%' OR l.modify_date like '2024-10-10%'; 2024-10-10 23:59:08 -- == sync omo_order_list == 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '423287', process_status = '3', pay_status = '8', totalprice_after = '400', lunar_date = '2024-08-25', invoice_status = '1', category_name = '彌月試吃,FB訂單', category_id = '2,10' where ordernumber = 'M24090033895' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '1', totalprice_after = '21060', lunar_date = '2024-09-02', invoice_status = '0', category_name = ',正式彌,LINE@訂單', category_id = ',1,9' where ordernumber = 'M24100002397' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '424046', process_status = '2', pay_status = '1', totalprice_after = '11400', lunar_date = '2024-09-02', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M24100002599' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '1', totalprice_after = '365', lunar_date = '2024-09-05', invoice_status = '0', category_name = ',正式彌,LINE@訂單', category_id = ',1,9' where ordernumber = 'M24100004185' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '424645', process_status = '3', pay_status = '1', totalprice_after = '200', lunar_date = '2024-09-05', invoice_status = '1', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M24100005060' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '424681', process_status = '3', pay_status = '1', totalprice_after = '400', lunar_date = '2024-09-05', invoice_status = '1', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M24100005356' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '413875', process_status = '2', pay_status = '1', totalprice_after = '1230', lunar_date = '2024-09-06', invoice_status = '0', category_name = '', category_id = '' where ordernumber = 'B24100006078' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '424759', process_status = '2', pay_status = '1', totalprice_after = '960', lunar_date = '2024-09-06', invoice_status = '0', category_name = '', category_id = '' where ordernumber = 'B24100006585' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '424812', process_status = '2', pay_status = '1', totalprice_after = '9850', lunar_date = '2024-09-06', invoice_status = '0', category_name = '', category_id = '' where ordernumber = 'B24100007198' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '424847', process_status = '2', pay_status = '1', totalprice_after = '705', lunar_date = '2024-09-07', invoice_status = '0', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M24100007531' 2024-10-10 23:59:08 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '0', lunar_date = '2024-09-07', invoice_status = '2', category_name = ',補寄訂單,公關訂單', category_id = ',7,6' where ordernumber = 'M24100007983' 2024-10-10 23:59:08 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('149035','425087',2,'','','B24100008020','1','1','1','1','1','','','0','0000-00-00','600','0','0','','0','30','12000','302','新竹縣','竹北市','302','新竹縣','竹北市','11370','2024-10-10 14:05:35','2024-09-08') 2024-10-10 23:59:08 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('149128','425180',2,'','','B24100008187','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2080','907','屏東縣','鹽埔鄉','907','屏東縣','鹽埔鄉','2230','2024-10-10 16:25:42','2024-09-08') 2024-10-10 23:59:08 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('146559','422643',2,'','','B24100008222','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','30','5700','221','新北市','汐止區','221','新北市','汐止區','5670','2024-10-10 17:25:42','2024-09-08') 2024-10-10 23:59:08 -- == sync_order end == 2024-10-10 23:59:08 -- == sync_order_detail start == 2024-10-10 23:59:08 -- start:2024-10-10,end:2024-10-10 2024-10-10 23:59:08 -- == sync omo_order_detail == 2024-10-10 23:59:08 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-10-10%' OR modify_date like '2024-10-10%' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24090033895' and product_code = 'DG0103190-05' 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32917',`firm_id` = '11',`ordernumber` = 'M24090033895', `product_name` = 'SNOOPY美好探尋禮盒(橘)-彌月試吃【B2】',`product_code` = 'DG0103190-05',`product_sn` = 'DG0103190',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-彌月SNOOPY(橘)【原味+巧克力】(試吃)',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-10-10',`create_date` = '2024-09-27 17:58:32',`modify_date` = '2024-10-10 13:12:45',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24090033895' and product_code = 'DG0103190-05', `lunar_date` = '2024-08-25' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24100005060' and product_code = 'DG010267-01' 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33001',`firm_id` = '11',`ordernumber` = 'M24100005060', `product_name` = 'SNOOPY獨特心意提盒(粉)-彌月試吃【A2】',`product_code` = 'DG010267-01',`product_sn` = 'DG010267',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入原味(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-10',`create_date` = '2024-10-07 15:07:54',`modify_date` = '2024-10-10 15:57:22',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24100005060' and product_code = 'DG010267-01', `lunar_date` = '2024-09-05' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24100005356' and product_code = 'DG0103190-05' 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33004',`firm_id` = '11',`ordernumber` = 'M24100005356', `product_name` = 'SNOOPY美好探尋禮盒(橘)-彌月試吃【B2】',`product_code` = 'DG0103190-05',`product_sn` = 'DG0103190',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-彌月SNOOPY(橘)【原味+巧克力】(試吃)',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-10-10',`create_date` = '2024-10-07 18:03:08',`modify_date` = '2024-10-10 18:30:12',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24100005356' and product_code = 'DG0103190-05', `lunar_date` = '2024-09-05' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24100007983' and product_code = 'DG010266-02' 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33030',`firm_id` = '8',`ordernumber` = 'M24100007983', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-02',`product_sn` = 'DG010266',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '36',`total_price` = '10800',`etd` = '2024-10-10',`create_date` = '2024-10-09 17:33:56',`modify_date` = '2024-10-10 08:02:55',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24100007983' and product_code = 'DG010266-02', `lunar_date` = '2024-09-07' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008020' and product_code = 'DG0103189-05' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33031','8','B24100008020','SNOOPY美好探尋-8結彌月禮盒','DG0103189-05','DG0103189','原味+巧克力','禮盒-彌月SNOOPY(橘)【原味+巧克力】','500','500','0','1','0','0','1','0.0','15','7500','2024-10-21','2024-10-10 14:05:35','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33031',`firm_id` = '8',`ordernumber` = 'B24100008020', `product_name` = 'SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-05',`product_sn` = 'DG0103189',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-彌月SNOOPY(橘)【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '15',`total_price` = '7500',`etd` = '2024-10-21',`create_date` = '2024-10-10 14:05:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008020' and product_code = 'DG0103189-05', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008020' and product_code = 'DG010266-01' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33031','8','B24100008020','SNOOPY獨特心意-8結彌月提盒','DG010266-01','DG010266','原味','提盒-彌月SNOOPY(粉)-40入原味','300','300','0','1','0','0','1','0.0','15','4500','2024-10-21','2024-10-10 14:05:35','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33031',`firm_id` = '8',`ordernumber` = 'B24100008020', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-01',`product_sn` = 'DG010266',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '15',`total_price` = '4500',`etd` = '2024-10-21',`create_date` = '2024-10-10 14:05:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008020' and product_code = 'DG010266-01', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008020' and product_code = 'ZP010520-01' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33031','8','B24100008020','贈品-SNOOPY寶寶貼心組','ZP010520-01','ZP010520','SNOOPY提把水瓶+sNug寶寶襪/童襪(款式隨機)0~6','組合-SNOOPY提把水瓶+sNug寶寶襪*3','0','0','0','0','0','0','1','0.0','1','0','2024-10-21','2024-10-10 14:05:35','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33031',`firm_id` = '8',`ordernumber` = 'B24100008020', `product_name` = '贈品-SNOOPY寶寶貼心組',`product_code` = 'ZP010520-01',`product_sn` = 'ZP010520',`product_spec` = 'SNOOPY提把水瓶+sNug寶寶襪/童襪(款式隨機)0~6',`invoice_name` = '組合-SNOOPY提把水瓶+sNug寶寶襪*3',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-21',`create_date` = '2024-10-10 14:05:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008020' and product_code = 'ZP010520-01', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008187' and product_code = 'DG010316-06' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33032','8','B24100008187','8結彌月禮盒-樂芙','DG010316-06','DG010316','芝麻+芝麻','禮盒-彌月樂芙【芝麻+芝麻】','500','500','0','1','0','0','1','500.0','1','500','2024-11-22','2024-10-10 16:25:42','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33032',`firm_id` = '8',`ordernumber` = 'B24100008187', `product_name` = '8結彌月禮盒-樂芙',`product_code` = 'DG010316-06',`product_sn` = 'DG010316',`product_spec` = '芝麻+芝麻',`invoice_name` = '禮盒-彌月樂芙【芝麻+芝麻】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '500.0',`amount` = '1',`total_price` = '500',`etd` = '2024-11-22',`create_date` = '2024-10-10 16:25:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008187' and product_code = 'DG010316-06', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008187' and product_code = 'BP010161-01' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33032','8','B24100008187','[加購]加購-SNOOPY熱壓三明治機','BP010161-01','BP010161','-','加購-SNOOPY熱壓三明治機','1580','1580','1','1','1580','0','0','0.0','1','1580','2024-11-22','2024-10-10 16:25:42','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33032',`firm_id` = '8',`ordernumber` = 'B24100008187', `product_name` = '[加購]加購-SNOOPY熱壓三明治機',`product_code` = 'BP010161-01',`product_sn` = 'BP010161',`product_spec` = '-',`invoice_name` = '加購-SNOOPY熱壓三明治機',`listprice` = '1580',`sellingprice` = '1580',`isadd` = '1',`isbaby` = '1',`addprice` = '1580',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '1580',`etd` = '2024-11-22',`create_date` = '2024-10-10 16:25:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008187' and product_code = 'BP010161-01', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008222' and product_code = 'DG010266-01' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33033','8','B24100008222','SNOOPY獨特心意-8結彌月提盒','DG010266-01','DG010266','原味','提盒-彌月SNOOPY(粉)-40入原味','300','300','0','1','0','0','1','0.0','4','1200','2024-10-21','2024-10-10 17:25:42','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33033',`firm_id` = '8',`ordernumber` = 'B24100008222', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-01',`product_sn` = 'DG010266',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1200',`etd` = '2024-10-21',`create_date` = '2024-10-10 17:25:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008222' and product_code = 'DG010266-01', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008222' and product_code = 'DG010266-02' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33033','8','B24100008222','SNOOPY獨特心意-8結彌月提盒','DG010266-02','DG010266','芝麻','提盒-彌月SNOOPY(粉)-40入芝麻','300','300','0','1','0','0','1','0.0','13','3900','2024-10-21','2024-10-10 17:25:42','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33033',`firm_id` = '8',`ordernumber` = 'B24100008222', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-02',`product_sn` = 'DG010266',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '13',`total_price` = '3900',`etd` = '2024-10-21',`create_date` = '2024-10-10 17:25:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008222' and product_code = 'DG010266-02', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008222' and product_code = 'DG010266-04' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33033','8','B24100008222','SNOOPY獨特心意-8結彌月提盒','DG010266-04','DG010266','海苔','提盒-彌月SNOOPY(粉)-40入海苔','300','300','0','1','0','0','1','0.0','1','300','2024-10-21','2024-10-10 17:25:42','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33033',`firm_id` = '8',`ordernumber` = 'B24100008222', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-04',`product_sn` = 'DG010266',`product_spec` = '海苔',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入海苔',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-21',`create_date` = '2024-10-10 17:25:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008222' and product_code = 'DG010266-04', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24100008222' and product_code = 'DG010266-03' 2024-10-10 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'33033','8','B24100008222','SNOOPY獨特心意-8結彌月提盒','DG010266-03','DG010266','咖啡','提盒-彌月SNOOPY(粉)-40入咖啡','300','300','0','1','0','0','1','0.0','1','300','2024-10-21','2024-10-10 17:25:42','2024-10-10 23:59:09',null,'1','2024-09-08') 2024-10-10 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33033',`firm_id` = '8',`ordernumber` = 'B24100008222', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-03',`product_sn` = 'DG010266',`product_spec` = '咖啡',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入咖啡',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-21',`create_date` = '2024-10-10 17:25:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24100008222' and product_code = 'DG010266-03', `lunar_date` = '2024-09-08' 2024-10-10 23:59:09 -- == sync_order_detail end == 2024-10-10 23:59:09 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2024-10-10' OR o.updated_at = '2024-10-10') and o.deleted_at is null 2024-10-10 23:59:09 -- == sync_order_detail start == 2024-10-10 23:59:09 -- start:2024-10-10,end:2024-10-10 2024-10-10 23:59:09 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-10-10 23:59:10 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-10-10 23:59:14 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-10-10%';