LOGS (72)
------------
[22-08-17 09:32:47]: Will start again after 3321443 ms
[22-08-17 09:32:47]: Updated adjustments: { '20220802': 20220802, '20220809': 20220809, '20220811': 20220811, '20220813': 20220813, '20220814': 20220814, '20220815': 20220815, '20220816': 20220816 }
[22-08-17 09:32:47]: Updated sales: { '20220802': 20220802, '20220809': 20220809, '20220811': 20220811, '20220813': 20220813, '20220814': 20220814, '20220815': 20220815, '20220816': 20220816 }
[22-08-17 09:32:47]: Updated orders: { '20220802': 20220802, '20220809': 20220809, '20220811': 20220811, '20220813': 20220813, '20220814': 20220814, '20220815': 20220815, '20220816': 20220816 }
[22-08-17 09:32:46]: SELECT DISTINCT [고객] AS customer_name ,[거래처분류] AS etype ,[마감일자] AS deadline ,[거래구분] AS transaction_class ,[환종] AS foreign_currency ,[품번] AS sku ,[품명] AS product_name ,[수량] AS quantity ,[외화단가] AS unitprice_foreign_currency ,[외화금액] AS foreign_currency_amount ,[단가] AS unit_price ,[원화금액] AS won_Amount ,[프로젝트] AS project ,[제품그룹] AS product_group ,[대분류] AS main_category ,[중분류] AS middle_classification ,[소분류] AS subcategory FROM [DZICUBE].[dbo].[VIEW_LSALECLS] as Sales WHERE ([거래처분류] = 'DISTY' OR [거래처분류] = 'OEM' OR [거래처분류] = 'ODM') AND ([마감일자] >= 20220808 AND [마감일자] <= 20220817 ) ORDER BY [마감일자] DESC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY
[22-08-17 09:32:46]: ERP :: sale :: Transaction 0 :: offset = 0 and limit = 1000
[22-08-17 09:32:46]: ERP :: sale :: Start date after conversion ... 20220808
[22-08-17 09:32:46]: SELECT DISTINCT [고객] AS customer_name ,[거래처분류] AS etype ,[출고일자] AS deadline ,[거래구분] AS transaction_class ,[환종] AS foreign_currency ,[품번] AS sku ,[품명] AS product_name ,[수량] AS quantity ,[외화단가] AS unitprice_foreign_currency ,[외화금액] AS foreign_currency_amount ,[단가] AS unit_price ,[원화금액] AS won_Amount ,[프로젝트] AS project ,[제품그룹] AS product_group ,[대분류] AS main_category ,[중분류] AS middle_classification ,[소분류] AS subcategory FROM [DZICUBE].[dbo].[VIEW_LDELIVER] AS DLVRY WHERE ([거래처분류] = 'DISTY' OR [거래처분류] = 'OEM' OR [거래처분류] = 'ODM') AND ([출고일자] >= 20220808 AND [출고일자] <= 20220817 ) ORDER BY [출고일자] DESC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY
[22-08-17 09:32:46]: ERP :: order :: Transaction 0 :: offset = 0 and limit = 1000
[22-08-17 09:32:46]: ERP :: order :: Start date after conversion ... 20220808
[22-08-17 09:32:46]: Fetching from ERP System
[22-08-17 09:32:45]: MSSQL Connection ERROR ::
[22-08-17 09:32:44]: lastSeqNumber :: 1659917966186
[22-08-17 09:32:44]: fetchSalesFromERPSystem :: initiated ::
[22-08-17 09:32:44]: mConfig.lastFetchTime :: 0
[22-08-17 09:32:43]: connecting to shopify ::
[22-08-17 09:32:43]: Done for Wed Aug 17 2022 03:52:44 GMT+0000
[22-08-17 09:32:42]: 0
[22-08-17 09:32:24]: Sales for: amazon_na 2022-08-17T03:52:44.442Z 2022-08-17T04:00:51.245Z
[22-08-17 09:32:24]: Done for Wed Aug 17 2022 03:52:42 GMT+0000
[22-08-17 09:32:23]: 0
[22-08-17 09:32:26]: Sales for: amazon_au 2022-08-17T03:52:42.314Z 2022-08-17T04:00:49.261Z
[22-08-17 09:32:25]: Done for Wed Aug 17 2022 03:52:40 GMT+0000
[22-08-17 09:32:24]: 0
[22-08-17 09:32:14]: Sales for: amazon_sg 2022-08-17T03:52:40.210Z 2022-08-17T04:00:47.146Z
[22-08-17 09:32:14]: Done for Wed Aug 17 2022 03:52:38 GMT+0000
[22-08-17 09:32:13]: 0
[22-08-17 09:32:16]: Sales for: amazon_jp 2022-08-17T03:52:38.096Z 2022-08-17T04:00:45.163Z
[22-08-17 09:32:16]: ERROR: Error: Invalid Input
[22-08-17 09:32:88]: Sales for: amazon_in 2022-07-08T05:40:42.392Z 2022-07-15T05:40:42.392Z
[22-08-17 09:32:88]: Done for Wed Aug 17 2022 03:52:29 GMT+0000
[22-08-17 09:32:87]: 0
[22-08-17 09:32:22]: Sales for: amazon_eu 2022-08-17T03:52:29.323Z 2022-08-17T04:00:37.221Z
[22-08-17 09:32:20]: Done fetch from EZAdmin
[22-08-17 09:32:16]: Last sequence number from DB: 353166, from EZ: 345163
[22-08-17 09:32:16]: Orders received: 7748/7748
[22-08-17 09:32:92]: action=get_order_info&date_type=order_date&limit=1000&page=8&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:32:83]: action=get_order_info&date_type=order_date&limit=1000&page=7&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:32:45]: action=get_order_info&date_type=order_date&limit=1000&page=6&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:32:37]: action=get_order_info&date_type=order_date&limit=1000&page=5&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:52]: action=get_order_info&date_type=order_date&limit=1000&page=4&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:60]: action=get_order_info&date_type=order_date&limit=1000&page=3&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:17]: action=get_order_info&date_type=order_date&limit=1000&page=2&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:62]: action=get_order_info&date_type=order_date&limit=1000&page=1&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:62]: Fetching from ezadmin
[22-08-17 09:31:62]: Done for: amazon_na 2022-08-17T03:52:59.820Z 2022-08-17T04:01:07.885Z
[22-08-17 09:31:50]: 14
[22-08-17 09:31:26]: { reportId: '269760019221' }
[22-08-17 09:31:88]: Fetching: amazon_na 2022-08-17T03:52:59.820Z 2022-08-17T04:01:07.885Z
[22-08-17 09:31:88]: Done for: amazon_au 2022-08-17T03:52:25.773Z 2022-08-17T04:00:34.097Z
[22-08-17 09:31:87]: 0
[22-08-17 09:30:17]: { reportId: '60369019221' }
[22-08-17 09:30:09]: Fetching: amazon_au 2022-08-17T03:52:25.773Z 2022-08-17T04:00:34.097Z
[22-08-17 09:30:09]: Done for: amazon_sg 2022-08-17T03:51:51.797Z 2022-08-17T04:00:00.159Z
[22-08-17 09:30:08]: 0
[22-08-17 09:30:42]: { reportId: '60703019221' }
[22-08-17 09:30:15]: Fetching: amazon_sg 2022-08-17T03:51:51.797Z 2022-08-17T04:00:00.159Z
[22-08-17 09:30:15]: Done for: amazon_jp 2022-08-17T03:51:17.757Z 2022-08-17T03:59:26.091Z
[22-08-17 09:30:14]: 0
[22-08-17 09:29:42]: { reportId: '138406019221' }
[22-08-17 09:29:09]: Fetching: amazon_jp 2022-08-17T03:51:17.757Z 2022-08-17T03:59:26.091Z
[22-08-17 09:29:08]: Done for: amazon_in 2022-08-17T03:50:42.474Z 2022-08-17T03:58:50.695Z
[22-08-17 09:29:07]: 0
[22-08-17 09:28:17]: { reportId: '104093019221' }
[22-08-17 09:28:69]: Fetching: amazon_in 2022-08-17T03:50:42.474Z 2022-08-17T03:58:50.695Z
[22-08-17 09:28:69]: Done for: amazon_eu 2022-08-17T03:50:06.482Z 2022-08-17T03:58:14.945Z
[22-08-17 09:28:64]: 2
[22-08-17 09:28:73]: { reportId: '290757019221' }
[22-08-17 09:28:94]: Fetching: amazon_eu 2022-08-17T03:50:06.482Z 2022-08-17T03:58:14.945Z
[22-08-17 09:28:93]: Exchange rates { USD: 1302.380384, EUR: 1336.70016, JPY: 9.760301, INR: 16.355319, SGD: 949.900448, AUD: 928.163162, CAD: 1019.355811, MXN: 65.683038, BRL: 256.555691, CNY: 193.148287, GBP: 1581.3177, CHF: 1383.171473, SEK: 127.622537, NZD: 840.627919 }
[22-08-17 09:28:91]: Starting service at Wed Aug 17 2022 03:58:13 GMT+0000
[22-08-17 09:28:91]: USING PORT: 8080