2025-08-14 18:00:02 [INFO]: Execution Started 2025-08-14 18:00:02 [INFO]: old server sucessfully connected 2025-08-14 18:00:02 [INFO]: sqs client sucess created 2025-08-14 18:00:04 [INFO]: Number of messages in the queue: 0 2025-08-14 18:00:25 [INFO]: Execution Started 2025-08-14 18:00:25 [INFO]: Execution Finished 2025-08-14 18:10:02 [INFO]: Execution Started 2025-08-14 18:10:02 [INFO]: old server sucessfully connected 2025-08-14 18:10:02 [INFO]: sqs client sucess created 2025-08-14 18:10:04 [INFO]: Number of messages in the queue: 0 2025-08-14 18:10:25 [INFO]: Execution Started 2025-08-14 18:10:25 [INFO]: Execution Finished 2025-08-14 18:20:01 [INFO]: Execution Started 2025-08-14 18:20:01 [INFO]: old server sucessfully connected 2025-08-14 18:20:01 [INFO]: sqs client sucess created 2025-08-14 18:20:02 [INFO]: Number of messages in the queue: 0 2025-08-14 18:20:23 [INFO]: Execution Started 2025-08-14 18:20:23 [INFO]: Execution Finished 2025-08-14 18:30:02 [INFO]: Execution Started 2025-08-14 18:30:02 [INFO]: old server sucessfully connected 2025-08-14 18:30:02 [INFO]: sqs client sucess created 2025-08-14 18:30:04 [INFO]: Number of messages in the queue: 1 2025-08-14 18:30:05 [INFO]: item found in queue is if condition 14409 2025-08-14 18:30:05 [INFO]: item found in queue is 14409 2025-08-14 18:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBRlkhz8m9TF7wi1W5gJrQzu52g9gqN6+MM24Kjt0T1Afgg1F6H0AvsxLS7riOHkpRv/4frIZUDLLoCzaAbhtoqQSRg+kQAR8zm0dn/U2ekKYnzoHZOQLptRjXNx+PxJwQcm5WhmCXtmdYTTJh9pL6rEu8WhBXUSdH0b4OMw2jsG6nrfDs9B4MNv4SmWPLGWogd304vvKMSg47SKzMdyyqEntkGGblPHzCjzLYb1bgsl6Vf+HP0j3h1vVG19nhGMG0wRXfQLZ9I1c6Q85gnkBb8Lnmx56XkVl2XsW3jhKxQg6LDgG60iV2/t4YwVwSdMwytRPD1Kp5NbOwJbKRgoFvKbCcPbUFdg3IqT9+Gnd2hxzO/JnZObC53ONCiDqVzzRbXJJf4+xoy31WDINrEzEoO/WscKR7uBZ60oNUOzpTcHFaQX0pP3lPreoHB0AQuRz0 2025-08-14 18:30:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 18:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 18:30:05 [INFO]: inside itemsold and closed 14409 2025-08-14 18:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 18:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-14 18:30:07 [INFO]: Ebay item id :: 306448262079 exists in Database 2025-08-14 18:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-14 18:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 18:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 18:30:07 [INFO]: in processold action queue is array for {"45314369":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45314369","ebayitemid":"306448262079","shopifyproductid":"8986460094686","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8986460094686","shopifyvariantid":"47444859453662","shopifyinventoryid":"49556802732254","shopifylocationid":"58450641063","product_id":"45314369","variant_id":"78266882","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 18:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 18:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 18:30:07 [INFO]: Shopify Inventory id 49556802732254 2025-08-14 18:30:07 [INFO]: Shopify Location id 58450641063 2025-08-14 18:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 18:30:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1980,"restoreRate":100}}}} 2025-08-14 18:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 18:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45314369 and user_id = 14409 2025-08-14 18:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266882 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 18:30:07 [INFO]: updateIdsQuantity -> ["78266882"] 2025-08-14 18:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 18:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266882 THEN 0 END, quantityflag = CASE WHEN id = 78266882 THEN 0 END WHERE user_id = 14409 AND id IN (78266882) 2025-08-14 18:30:07 [INFO]: QUANTITY Updated IDs: 78266882 2025-08-14 18:30:07 [INFO]: Successfully processed data for user 14409 2025-08-14 18:30:07 [INFO]: Execution Started 2025-08-14 18:30:07 [INFO]: Execution Finished 2025-08-14 18:40:01 [INFO]: Execution Started 2025-08-14 18:40:01 [INFO]: old server sucessfully connected 2025-08-14 18:40:01 [INFO]: sqs client sucess created 2025-08-14 18:40:03 [INFO]: Number of messages in the queue: 1 2025-08-14 18:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 18:40:04 [INFO]: item found in queue is 14409 2025-08-14 18:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBR8g/hhHZEQ5MKv69wEljjU+U+K/v+vLfmv3vqPHdGhWFkobE17Co6yG4HyiXZhqLwL3w7ENlHfK/6WnChdM2tNyH6gC/U1ABcvthbuMWE69eNih5RExaJWSYqQjRs5VeECYNQXDQr0ca1JaThX1F88xTH8QynKJEKFmYNFaU4b/QmDGaKX6f8V8yHtw8tIFS5+KdyWI+XmtJsIG/7QiUyV9SX8oD8vLLhvXkwbuVTUcq/R3/qMiB15IgQZDKPBmHiUP2f0KMI6A08pAH0S8D2+FFh9wVyM+2G8XQud+Y5a4FHBDxQxKpWtCfJJSmLnEmPWfnovsvA+o2sICSPc0BfjGd1EluUsCIIHrMGHNw73BmPJMHgAUVW4JtBHX9cZ8K1/SQTfNoj48K2LIOIkx55M9/DhMAgbq1LrgFdmV5GsiBf/zy1Lz5+v6gVAHFXZML 2025-08-14 18:40:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 18:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 18:40:04 [INFO]: inside itemsold and closed 14409 2025-08-14 18:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 18:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-14 18:40:06 [INFO]: Ebay item id :: 404843314417 exists in Database 2025-08-14 18:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-14 18:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 18:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 18:40:06 [INFO]: in processold action queue is array for {"44772047":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772047","ebayitemid":"404843314417","shopifyproductid":"6806419210407","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"6806419210407","shopifyvariantid":"40226305638567","shopifyinventoryid":"42321566367911","shopifylocationid":"","product_id":"44772047","variant_id":"77680589","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 18:40:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 18:40:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 18:40:06 [INFO]: Shopify Inventory id 42321566367911 2025-08-14 18:40:06 [INFO]: Shopify Location id 58450641063 2025-08-14 18:40:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 18:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1977,"restoreRate":100}}}} 2025-08-14 18:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 18:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772047 and user_id = 14409 2025-08-14 18:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680589 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 18:40:06 [INFO]: updateIdsQuantity -> ["77680589"] 2025-08-14 18:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 18:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680589 THEN 0 END, quantityflag = CASE WHEN id = 77680589 THEN 0 END WHERE user_id = 14409 AND id IN (77680589) 2025-08-14 18:40:06 [INFO]: QUANTITY Updated IDs: 77680589 2025-08-14 18:40:06 [INFO]: Successfully processed data for user 14409 2025-08-14 18:40:06 [INFO]: Execution Started 2025-08-14 18:40:06 [INFO]: Execution Finished 2025-08-14 18:50:01 [INFO]: Execution Started 2025-08-14 18:50:01 [INFO]: old server sucessfully connected 2025-08-14 18:50:01 [INFO]: sqs client sucess created 2025-08-14 18:50:03 [INFO]: Number of messages in the queue: 2 2025-08-14 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-14 18:50:03 [INFO]: item found in queue is 14409 2025-08-14 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPDjTdXd/vryJjiT51/1zHtZrKxQGzbAkVDtv07hYA8+Ltu6z9hLedQTtqXgGtY70aGGiKZ+kJO6u4U4BLKdP41lki1DJ/K4NnQvzADNK4iwEoeSKpXOYELy98ON+Et24e70MQiMv2NsobVt73fifUK3Udx5GnrC2xlQKkLg/yJCmlqzalX3DNhe8IQ1D0+NVW/37gLXgUV6qSaQ3DbXkJGE5bu6+pTX3/ThTxzW0FL5xzDUtx+TOqtX0Sdij4nYtQ7oygpIl7YXWBa2E0JV+rApU20aLJBkVezWwDvKZnmJSKvE89Ug1B6NIulKfP5RSAS04LoOVhQT6ZxGS+nS5rRjhnvT19d4v1C1jUp8U5PQEiewO+hoVlZTeKzMG/IqtVZnd8mP19eaLokyPeO4tK4R5ASxjhB5/qqqksq57fHYgXsNGTrT8xBU1xwzuEhzE 2025-08-14 18:50:04 [INFO]: item found in queue is if condition 14409 2025-08-14 18:50:04 [INFO]: item found in queue is 14409 2025-08-14 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB1hDaSea+sbSPPP/MfvVpCRAFl5u+Xe1GGAlb+sGsKI2wRrj9ZUG9ORSdA/hyZdbcjFb+jpFG1SKTnIsJeZv+txsFZn1YjxWM7VMDsGuolxocOILb294u6Eor+jRu+hsV9+INk+pUW1Fi7Wm8aajiJXEYHjFX1zbAWvOmC9AplxMns3239lz53Du1pfwlpcHZY5/dvOHd5ulojja8S2XDiecDKVf0Mzd7w+bLi9uD7WiKxgLbq1aEFESdJOxx3Gryh/aWYKBFiJH+ytrQG+Bdolqbojtuqh8zXgfSTuYV65lSjD9b+Wu4QMHh2iffo1zP5X4fQBFyDu/U6X/UdZ0WIM3KKSlW5BSIxPDRfe35Guq7nFscHiJc/faL6gQhgeNOu575H9AMyW6WLyUlJj88ZrwqP6hcT2e7pj9r8IsLmxPbaff5TJaZgZHNouAJinOZ 2025-08-14 18:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 18:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 18:50:04 [INFO]: inside itemsold and closed 14409 2025-08-14 18:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 18:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-14 18:50:06 [INFO]: Ebay item id :: 306435249884 exists in Database 2025-08-14 18:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-14 18:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 18:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 18:50:06 [INFO]: inside itemsold and closed 14409 2025-08-14 18:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 18:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-14 18:50:08 [INFO]: Ebay item id :: 405496531587 exists in Database 2025-08-14 18:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-14 18:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 18:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 18:50:08 [INFO]: in processold action queue is array for {"45313621":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313621","ebayitemid":"306435249884","shopifyproductid":"8982154707166","variants":[{"price":"189.00","quantity":0,"weight":"10","shopifyproductid":"8982154707166","shopifyvariantid":"47388779544798","shopifyinventoryid":"49500598796510","shopifylocationid":"58450641063","product_id":"45313621","variant_id":"78266134","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44670668":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670668","ebayitemid":"405496531587","shopifyproductid":"8797460529374","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8797460529374","shopifyvariantid":"46239286427870","shopifyinventoryid":"48339713163486","shopifylocationid":"","product_id":"44670668","variant_id":"77575888","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 18:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 18:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 18:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 18:50:08 [INFO]: Shopify Inventory id 49500598796510 2025-08-14 18:50:08 [INFO]: Shopify Location id 58450641063 2025-08-14 18:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 18:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1978,"restoreRate":100}}}} 2025-08-14 18:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 18:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313621 and user_id = 14409 2025-08-14 18:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266134 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 18:50:08 [INFO]: Shopify Inventory id 48339713163486 2025-08-14 18:50:08 [INFO]: Shopify Location id 58450641063 2025-08-14 18:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 18:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T18:50:09Z","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-14 18:50:09 [INFO]: Change: available | Delta: -1 2025-08-14 18:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-14 18:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 18:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670668 and user_id = 14409 2025-08-14 18:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575888 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 18:50:09 [INFO]: updateIdsQuantity -> ["78266134","77575888"] 2025-08-14 18:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 1 2025-08-14 18:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266134 THEN 0 WHEN id = 77575888 THEN 0 END, quantityflag = CASE WHEN id = 78266134 THEN 0 WHEN id = 77575888 THEN 0 END WHERE user_id = 14409 AND id IN (78266134,77575888) 2025-08-14 18:50:09 [INFO]: QUANTITY Updated IDs: 78266134, 77575888 2025-08-14 18:50:09 [INFO]: Successfully processed data for user 14409 2025-08-14 18:50:09 [INFO]: Execution Started 2025-08-14 18:50:09 [INFO]: Execution Finished