2025-08-08 03:00:02 [INFO]: Execution Started 2025-08-08 03:00:02 [INFO]: old server sucessfully connected 2025-08-08 03:00:02 [INFO]: sqs client sucess created 2025-08-08 03:00:03 [INFO]: Number of messages in the queue: 0 2025-08-08 03:00:23 [INFO]: Execution Started 2025-08-08 03:00:23 [INFO]: Execution Finished 2025-08-08 03:10:01 [INFO]: Execution Started 2025-08-08 03:10:01 [INFO]: old server sucessfully connected 2025-08-08 03:10:01 [INFO]: sqs client sucess created 2025-08-08 03:10:03 [INFO]: Number of messages in the queue: 0 2025-08-08 03:10:23 [INFO]: Execution Started 2025-08-08 03:10:23 [INFO]: Execution Finished 2025-08-08 03:20:02 [INFO]: Execution Started 2025-08-08 03:20:02 [INFO]: old server sucessfully connected 2025-08-08 03:20:02 [INFO]: sqs client sucess created 2025-08-08 03:20:03 [INFO]: Number of messages in the queue: 1 2025-08-08 03:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 03:20:03 [INFO]: item found in queue is 14409 2025-08-08 03:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBE0dkECm6VTmbSkUUPTNOjjX1F6+WLIbdIgT7UGbsg4lghW5aYeCJN98JIkIxCxYvf/xE5yUjQ1fwAsq4/COJijog5yPuZSMwhfRQk7YvD2e7gF4ykpuffbr/9EgrtHC74WKN0h6LkwlSXKvRlOxHMx0D1LwtIKpuN0VeBB0gbIQFcPPCATudAFfwFtUtYDnrPpO8prsMvb/gz6r2Vy3mmzAnAruD32l9UFvdiaczJCFCiAJ6kAZ3YMpzplpmkroAJ4ujkTj9LjxvKMbrQFO7jITP89WjTdVJkivk4vVi/yGusPkCKwpw1Ogpxm4BmaLdsYe8cL6oDDlMSrzd3e317evwIzUUYxOIbWuZPaeICvcdZgq13PrlUGlWNWxdAWaFI1Y50jQrHUiRUe/kfon89MsIXdyRVtP7H+Tqo2AwfxR0ZtQ+rjPMBXrYn7kGkIv0 2025-08-08 03:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 03:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 03:20:03 [INFO]: inside itemsold and closed 14409 2025-08-08 03:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 03:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 03:20:05 [INFO]: Ebay item id :: 285401986150 exists in Database 2025-08-08 03:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 03:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 03:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 03:20:05 [INFO]: in processold action queue is array for {"44591921":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591921","ebayitemid":"285401986150","shopifyproductid":"8096258818270","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8096258818270","shopifyvariantid":"44284715008222","shopifyinventoryid":"46381901316318","shopifylocationid":"","product_id":"44591921","variant_id":"77484630","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 03:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 03:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 03:20:05 [INFO]: Shopify Inventory id 46381901316318 2025-08-08 03:20:05 [INFO]: Shopify Location id 58450641063 2025-08-08 03:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 03:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T03:20:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 03:20:05 [INFO]: Change: available | Delta: -1 2025-08-08 03:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-08 03:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 03:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591921 and user_id = 14409 2025-08-08 03:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484630 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 03:20:05 [INFO]: updateIdsQuantity -> ["77484630"] 2025-08-08 03:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 03:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77484630 THEN 0 END, quantityflag = CASE WHEN id = 77484630 THEN 0 END WHERE user_id = 14409 AND id IN (77484630) 2025-08-08 03:20:05 [INFO]: QUANTITY Updated IDs: 77484630 2025-08-08 03:20:05 [INFO]: Successfully processed data for user 14409 2025-08-08 03:20:05 [INFO]: Execution Started 2025-08-08 03:20:05 [INFO]: Execution Finished 2025-08-08 03:30:01 [INFO]: Execution Started 2025-08-08 03:30:01 [INFO]: old server sucessfully connected 2025-08-08 03:30:01 [INFO]: sqs client sucess created 2025-08-08 03:30:02 [INFO]: Number of messages in the queue: 0 2025-08-08 03:30:23 [INFO]: Execution Started 2025-08-08 03:30:23 [INFO]: Execution Finished 2025-08-08 03:40:01 [INFO]: Execution Started 2025-08-08 03:40:01 [INFO]: old server sucessfully connected 2025-08-08 03:40:01 [INFO]: sqs client sucess created 2025-08-08 03:40:02 [INFO]: Number of messages in the queue: 1 2025-08-08 03:40:03 [INFO]: item found in queue is if condition 14409 2025-08-08 03:40:03 [INFO]: item found in queue is 14409 2025-08-08 03:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBokYPjhd6rwHDZcrDGa17u+zGALiD4D/cTm/VxQEemaZau0a1gv01mdkXhyVIbdtt2DJbY9DT4h7Rjp9VAR9s9tzO+b9OHIya42gLVKyPoJ1K2AA475YSOv8kljHFailCPPKKrxFiT13zq71Qsfc4mJZ8FDER0QN8rsuD2pvyos1+hebCAMljyeBYcGpFMD6Wis2Evn4bDUHsTY3heZCEg0HNZsTxZz0TiC6zBLS+/0DTMXhwhzQJWXrEYSjm676GBXyFWsqTrZSqvB4GpxPJr2v0nIorBavl9UZaMJfnUnu0lWrIAq+hPnGpoTVmuhRpKFxa2NEfiyk1wmM73JPwJN0261YDmmS8Zw7Y2hKsXJG1D5Dc9uHhD89fYNBlD+4WrOGXN2Rr7s6AjlZh91lHUQPYQkU4Inz7KYfh6M0DhwEzduDXqDe21pdi3h/n+8YS 2025-08-08 03:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 03:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 03:40:03 [INFO]: inside itemsold and closed 14409 2025-08-08 03:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 03:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 03:40:05 [INFO]: Ebay item id :: 224183986129 exists in Database 2025-08-08 03:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 03:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 03:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 03:40:05 [INFO]: in processold action queue is array for {"44728545":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44728545","ebayitemid":"224183986129","shopifyproductid":"6634416701607","variants":[{"price":"9.67","quantity":0,"weight":"0.5","shopifyproductid":"6634416701607","shopifyvariantid":"39653990138023","shopifyinventoryid":"41748633452711","shopifylocationid":"","product_id":"44728545","variant_id":"77636423","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 03:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 03:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 03:40:05 [INFO]: Shopify Inventory id 41748633452711 2025-08-08 03:40:05 [INFO]: Shopify Location id 58450641063 2025-08-08 03:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 03:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-08 03:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 03:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44728545 and user_id = 14409 2025-08-08 03:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77636423 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 03:40:05 [INFO]: updateIdsQuantity -> ["77636423"] 2025-08-08 03:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 03:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77636423 THEN 0 END, quantityflag = CASE WHEN id = 77636423 THEN 0 END WHERE user_id = 14409 AND id IN (77636423) 2025-08-08 03:40:05 [INFO]: QUANTITY Updated IDs: 77636423 2025-08-08 03:40:05 [INFO]: Successfully processed data for user 14409 2025-08-08 03:40:05 [INFO]: Execution Started 2025-08-08 03:40:05 [INFO]: Execution Finished 2025-08-08 03:50:02 [INFO]: Execution Started 2025-08-08 03:50:02 [INFO]: old server sucessfully connected 2025-08-08 03:50:02 [INFO]: sqs client sucess created 2025-08-08 03:50:03 [INFO]: Number of messages in the queue: 1 2025-08-08 03:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 03:50:03 [INFO]: item found in queue is 14409 2025-08-08 03:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBrKUO+iNmmSYa7OjQggZwww6ZM5n2xcOrfa8Eg4/C2XnG+ZoZeW2o+HfhAStHSE1PgHJSr+7agtfPrQffqwfWSILhNdBgf64BbbDVw/zBmCu7rTOySalCipTb8Kb8ENNxwEmXO209qYcx1s970ERRnTLAURDMohggp+cDjsJPe08u+iwtxnaxugckH5TesvzSSbsKyqmuCndEByOjkEscTHESdFVyH5EOxabmlja8hBnXwgWZAFzOQZ694X6SpEeMwRNvGlFUvATb6woYRQeCVrVYu4WE9MEFipTE8YDKhGtKIesLrqGZyRVPX84nT9gqGRJoYRRpPpOF9YekxwKqig2J8MsoDOEQ+RSoyOir6YlTdXBhUlrE4SITU+7MaJPeobkwCSowVoAx0pgUQIAcl6rmJwDWqZxPMTq2Su/d/qJoCgqRYUozyMDVVSSnDbML 2025-08-08 03:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 03:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 03:50:03 [INFO]: inside itemsold and closed 14409 2025-08-08 03:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 03:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 03:50:05 [INFO]: Ebay item id :: 325858933889 exists in Database 2025-08-08 03:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 03:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 03:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 03:50:05 [INFO]: in processold action queue is array for {"44670261":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670261","ebayitemid":"325858933889","shopifyproductid":"8165545246942","variants":[{"price":"24.99","quantity":0,"weight":"3","shopifyproductid":"8165545246942","shopifyvariantid":"44441373704414","shopifyinventoryid":"46539303780574","shopifylocationid":"","product_id":"44670261","variant_id":"77575481","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 03:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 03:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 03:50:05 [INFO]: Shopify Inventory id 46539303780574 2025-08-08 03:50:05 [INFO]: Shopify Location id 58450641063 2025-08-08 03:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 03:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-08 03:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 03:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670261 and user_id = 14409 2025-08-08 03:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575481 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 03:50:05 [INFO]: updateIdsQuantity -> ["77575481"] 2025-08-08 03:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 03:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77575481 THEN 0 END, quantityflag = CASE WHEN id = 77575481 THEN 0 END WHERE user_id = 14409 AND id IN (77575481) 2025-08-08 03:50:05 [INFO]: QUANTITY Updated IDs: 77575481 2025-08-08 03:50:05 [INFO]: Successfully processed data for user 14409 2025-08-08 03:50:05 [INFO]: Execution Started 2025-08-08 03:50:05 [INFO]: Execution Finished