2025-08-01 23:00:01 [INFO]: Execution Started 2025-08-01 23:00:01 [INFO]: old server sucessfully connected 2025-08-01 23:00:01 [INFO]: sqs client sucess created 2025-08-01 23:00:02 [INFO]: Number of messages in the queue: 1 2025-08-01 23:00:02 [INFO]: item found in queue is if condition 14409 2025-08-01 23:00:02 [INFO]: item found in queue is 14409 2025-08-01 23:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBgPhOfn+OWsa9go0CqhQ/+WZwDOATjnyW6MYLOjQZuFYGrOC8rHgi+evU1x1yCbRkrZOOLeJ1CXPNOP8XDDn/3sluKcxdtSXy3nJ7p/QU1uHq5PSmjVIwJNGRMtLWrBYHgZvCjoz5bWYp77W6SLUzWJozcSFku7bEqLpr/ivUQtlhlsf2bYdWWNrxy4n8R9CHSBfKyXhdMqc08DnhQ0YWG9aoU0yNe9LhY0WGi8ewh+Sa4Ei7vl+kxYWIFrKYbhz8YypAqcHBUoQoBKmTJ8A790aZvUDOg+8mCULjSqVHKkeaXf4FQYNLNzZddlquiWxq/J/+l1eBrrwheP7RQjRZtP/YPW4k0SV24HU/BaX28GJ5rgZjdIEU5xHTP/U4VRaA/njEf4mKRKYGikHNvursLBFh/co+7aDq3013ewWTlIrqUDd8wVURm6GmC90fJO+m 2025-08-01 23:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 23:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 23:00:03 [INFO]: inside itemsold and closed 14409 2025-08-01 23:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 23:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 23:00:05 [INFO]: Ebay item id :: 326215740133 exists in Database 2025-08-01 23:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 23:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 23:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 23:00:05 [INFO]: in processold action queue is array for {"44686674":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44686674","ebayitemid":"326215740133","shopifyproductid":"8700426944734","variants":[{"price":"11.99","quantity":0,"weight":"1","shopifyproductid":"8700426944734","shopifyvariantid":"45946941440222","shopifyinventoryid":"48045498663134","shopifylocationid":"","product_id":"44686674","variant_id":"77591899","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 23:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 23:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 23:00:05 [INFO]: Shopify Inventory id 48045498663134 2025-08-01 23:00:05 [INFO]: Shopify Location id 58450641063 2025-08-01 23:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 23:00: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-01 23:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 23:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44686674 and user_id = 14409 2025-08-01 23:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77591899 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 23:00:05 [INFO]: updateIdsQuantity -> ["77591899"] 2025-08-01 23:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 23:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77591899 THEN 0 END, quantityflag = CASE WHEN id = 77591899 THEN 0 END WHERE user_id = 14409 AND id IN (77591899) 2025-08-01 23:00:05 [INFO]: QUANTITY Updated IDs: 77591899 2025-08-01 23:00:05 [INFO]: Successfully processed data for user 14409 2025-08-01 23:00:05 [INFO]: Execution Started 2025-08-01 23:00:05 [INFO]: Execution Finished 2025-08-01 23:10:02 [INFO]: Execution Started 2025-08-01 23:10:02 [INFO]: old server sucessfully connected 2025-08-01 23:10:02 [INFO]: sqs client sucess created 2025-08-01 23:10:03 [INFO]: Number of messages in the queue: 1 2025-08-01 23:10:03 [INFO]: item found in queue is if condition 14409 2025-08-01 23:10:03 [INFO]: item found in queue is 14409 2025-08-01 23:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBuQ1knOo9hs4C05AxSLYUnHSxsMR5GbRVevsGmNQ8iGpZiou/DNF/cpcfUKMEqj3gKIoVfwFSUY0QFXop5YaV2oYxK/I8+K0KDIdD3xGlJYvNO7OOmEmaUVeQ9iIN+C/lnTTOk1ZgzXUseeUmNGdRyA5xfYV8JdlBQn3Evd1IIKE5fd28QQ/CA5yd+todtH5ybirlIJWHGofXLgxTw2IuCzjx0e0qLUoPmbRp6U8y2ja6ALtFMeVMW93Rt4bStC+n/ariL+4MticR2alckElmFvVKEPgEwTlC+xM4yZt9bss7LLBkcWWCgnPxvBcPIXdjrwbPfmdcDWy933r8X8dxPtcsbz1e+CBc95PrS5gIeYhNHuHs/B+PyU/0ewEafWiO9PTcQqCUL6nVCl8j9dis8YmROlPTRoR8vgl1xaitrGk7uGnWKlwvupEKV6r+XQ35 2025-08-01 23:10:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 23:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 23:10:04 [INFO]: inside itemsold and closed 14409 2025-08-01 23:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 23:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 23:10:05 [INFO]: Ebay item id :: 286724640921 exists in Database 2025-08-01 23:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 23:10:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 23:10:05 [INFO]: in processold action queue is array for {"45278865":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45278865","ebayitemid":"286724640921","deleted":1}}} 2025-08-01 23:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 23:10:05 [INFO]: productIds WHich are having null productid -> [45278865] 2025-08-01 23:10:05 [INFO]: ebayItemIds WHich are not imported-> ["286724640921"] 2025-08-01 23:10:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 23:10:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 23:10:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45278865) 2025-08-01 23:10:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 23:10:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 23:10:05 [INFO]: Transaction committed successfully. 2025-08-01 23:10:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 23:10:05 [INFO]: Successfully processed data for user 14409 2025-08-01 23:10:05 [INFO]: Execution Started 2025-08-01 23:10:05 [INFO]: Execution Finished 2025-08-01 23:15:17 [INFO]: Execution Started 2025-08-01 23:15:17 [INFO]: old server sucessfully connected 2025-08-01 23:15:17 [INFO]: sqs client sucess created 2025-08-01 23:15:18 [INFO]: Number of messages in the queue: 0 2025-08-01 23:15:39 [INFO]: Execution Started 2025-08-01 23:15:39 [INFO]: Execution Finished 2025-08-01 23:20:01 [INFO]: Execution Started 2025-08-01 23:20:01 [INFO]: old server sucessfully connected 2025-08-01 23:20:01 [INFO]: sqs client sucess created 2025-08-01 23:20:02 [INFO]: Number of messages in the queue: 0 2025-08-01 23:20:22 [INFO]: Execution Started 2025-08-01 23:20:22 [INFO]: Execution Finished 2025-08-01 23:30:01 [INFO]: Execution Started 2025-08-01 23:30:01 [INFO]: old server sucessfully connected 2025-08-01 23:30:01 [INFO]: sqs client sucess created 2025-08-01 23:30:02 [INFO]: Number of messages in the queue: 0 2025-08-01 23:30:22 [INFO]: Execution Started 2025-08-01 23:30:22 [INFO]: Execution Finished 2025-08-01 23:40:01 [INFO]: Execution Started 2025-08-01 23:40:01 [INFO]: old server sucessfully connected 2025-08-01 23:40:01 [INFO]: sqs client sucess created 2025-08-01 23:40:02 [INFO]: Number of messages in the queue: 1 2025-08-01 23:40:03 [INFO]: item found in queue is if condition 14409 2025-08-01 23:40:03 [INFO]: item found in queue is 14409 2025-08-01 23:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBmBWuk7cSAxx5MkcSzOkh7WMgXHuFPZKQGSzqJmjcDg1FLRKqiYrgBdVMggxSGTBIwCekhkVYRunzIAJI5dx6HU0vm/Sfcvpc+qY6z2ViUcS5JyXhSZvaLAt0MF0qDQS+cJKXAgus3lNP/piIMDB6rbdYSLCVwLjndJrFarTS3K0/wDkk/7GIwbfEAPuhFXf6ZtdWIHx83dnbI1qQRdXSbA9cpMUCLMN8Zq7FqMKHrktmT9YLDe70rB8vYhfCmz3w7YlcQgqeCeFLEqexIWD1C+FuD2cS9RYR8ocyOnJrwzAQKSBWw0W5hkjtTM8/+DUSTq9mEuci0gfG6oZZxaaZDKSS+Fw04UNLBo3ppoyhGSQa2hdSStqbKTupHNMRphhwLY2T1fT4UYJgauISGLnne48ucZMcuSoskzDlIgZUwnvednwWOeHO23FqrL9Ve4y 2025-08-01 23:40:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 23:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 23:40:04 [INFO]: inside itemsold and closed 14409 2025-08-01 23:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 23:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 23:40:05 [INFO]: Ebay item id :: 306103802149 exists in Database 2025-08-01 23:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 23:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 23:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 23:40:05 [INFO]: in processold action queue is array for {"44565944":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44565944","ebayitemid":"306103802149","shopifyproductid":"8817222320350","variants":[{"price":"10.99","quantity":0,"weight":"0.9375","shopifyproductid":"8817222320350","shopifyvariantid":"46289378803934","shopifyinventoryid":"48390302925022","shopifylocationid":"","product_id":"44565944","variant_id":"77458624","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 23:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 23:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 23:40:05 [INFO]: Shopify Inventory id 48390302925022 2025-08-01 23:40:05 [INFO]: Shopify Location id 58450641063 2025-08-01 23:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 23:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T23:40: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-01 23:40:06 [INFO]: Change: available | Delta: -1 2025-08-01 23:40:06 [INFO]: Change: on_hand | Delta: -1 2025-08-01 23:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 23:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44565944 and user_id = 14409 2025-08-01 23:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458624 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 23:40:06 [INFO]: updateIdsQuantity -> ["77458624"] 2025-08-01 23:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 23:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77458624 THEN 0 END, quantityflag = CASE WHEN id = 77458624 THEN 0 END WHERE user_id = 14409 AND id IN (77458624) 2025-08-01 23:40:06 [INFO]: QUANTITY Updated IDs: 77458624 2025-08-01 23:40:06 [INFO]: Successfully processed data for user 14409 2025-08-01 23:40:06 [INFO]: Execution Started 2025-08-01 23:40:06 [INFO]: Execution Finished 2025-08-01 23:50:01 [INFO]: Execution Started 2025-08-01 23:50:01 [INFO]: old server sucessfully connected 2025-08-01 23:50:01 [INFO]: sqs client sucess created 2025-08-01 23:50:02 [INFO]: Number of messages in the queue: 1 2025-08-01 23:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 23:50:03 [INFO]: item found in queue is 14409 2025-08-01 23:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB3mgJFKvfeMPUtiJ79LrUa6IWW+Px725Brl43hS5wOTviawIHX/Z6lSz3kQTCzF4eKAPK4q3+ZpLVQDtzvAj11/gbqJV+wSViNkychEoynnXdl1ofA5waqm/uRPsMKESO7aSIbGaK9WvSX3pHYKlTJ41PrKTF07jDFCOSFiAgEqy6gGU5bxF9k9C8OSrCKgFpoaCAdswVC86PYf9j4QVueeYzfRIWxiyxGKJpOx7VrF/70odpkBofTomgjop3gM/qele5bKzPZGhM2+fN49cUWescAA6YNK7a4BnXCv5/oJECCpLG1O/j0X/7EzL9wAwQlIevNESBX6GZKSHW04C8IhpQVk3ekrr4wL3L/awFRTH6kCOVgpAy5p7waJu/qrsrDXFBHtzPHhSE1sW1PKs4PUTsTTqlrbVpFNxK1olShhPKsbCl7eNFjoyWhAKqNXqF 2025-08-01 23:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 23:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 23:50:03 [INFO]: inside itemsold and closed 14409 2025-08-01 23:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 23:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 23:50:05 [INFO]: Ebay item id :: 225843310286 exists in Database 2025-08-01 23:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 23:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 23:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 23:50:05 [INFO]: in processold action queue is array for {"44687821":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687821","ebayitemid":"225843310286","shopifyproductid":"8177211736286","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8177211736286","shopifyvariantid":"44462453063902","shopifyinventoryid":"46560381108446","shopifylocationid":"","product_id":"44687821","variant_id":"77593067","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 23:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 23:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 23:50:05 [INFO]: Shopify Inventory id 46560381108446 2025-08-01 23:50:05 [INFO]: Shopify Location id 58450641063 2025-08-01 23:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 23:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T23:50: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-01 23:50:05 [INFO]: Change: available | Delta: -1 2025-08-01 23:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-01 23:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 23:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687821 and user_id = 14409 2025-08-01 23:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593067 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 23:50:05 [INFO]: updateIdsQuantity -> ["77593067"] 2025-08-01 23:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 23:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77593067 THEN 0 END, quantityflag = CASE WHEN id = 77593067 THEN 0 END WHERE user_id = 14409 AND id IN (77593067) 2025-08-01 23:50:05 [INFO]: QUANTITY Updated IDs: 77593067 2025-08-01 23:50:05 [INFO]: Successfully processed data for user 14409 2025-08-01 23:50:05 [INFO]: Execution Started 2025-08-01 23:50:05 [INFO]: Execution Finished