2025-08-08 20:00:01 [INFO]: Execution Started 2025-08-08 20:00:01 [INFO]: old server sucessfully connected 2025-08-08 20:00:01 [INFO]: sqs client sucess created 2025-08-08 20:00:02 [INFO]: Number of messages in the queue: 2 2025-08-08 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:00:03 [INFO]: item found in queue is 14409 2025-08-08 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBgfJAFmj7uTrdijKmF+P1uSeq8hVsWcxB4YzBPh+c0O67lGhaFj1EMeJUF2tbzxTOAGK6U2cysOW/SEaZaB6qGCOkMir+NoQgzdf6OmwlwOwoNiRxvXwtw4fj7AB7+1sd04aSbCzm/dHh6+mxAjD/7akcoBpXiCVJ1czioNuVh/DFLKrE5TjU8ukMxYnoA6JyEn0YysUwLQPCQz7CzC6YlMS2tFoBt7b+Anh6/FUqhEhWWdBvdqqXv47nieFAx0luAxKfRn6QLkYSAeNKTY9KUP4UZJWTdItWuhIN/117rNFLZSzJlvPJ0QnTOgsoIFgK+AuwJdyFclpUYl6WcuZu8Ho4eL02x0X3U8Z515vdJF/fWaPQ5LwtGZisgNoT2pXaJXPsIIhnWhMLAQIdGaQvmgrzqdczwj17fMR0AHjkkMK+xpxM1MH7IiEhyL1jMcBL 2025-08-08 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:00:03 [INFO]: item found in queue is 14409 2025-08-08 20:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB+8isnPnN20xM+gfOT0cXiB2/CcZpi3X8eJCIWZnENd7/HeSvM4qhc3cKAV+eYxtih14lLYKt3vWkxXzQmGDMxaRYGQnzsrbPYgRHlAHCkJjSkuezWRdEvJlm02A1/BTuAbgKQLDgkdOmPZH278UtK3KqSPsnK9SLSNGoXvddGIGZp1UpgwzhZSQDJxqrUZc/e3r2mOWlknSETOAAsCgrKljEjNCIpUvIm8H0sn7WcjXyifb7V1Pd1QAmp4lDgSjMZmkWxSNniCF2Kg0UTg+fQ7eiSWOoqOBjVWtKy4uka5Kc+JOWwF50VFZD7lSyiAiQI6RyKIoiwf769VYH481iY4cTSzeiCF1slfiaHLbE6K0EWJUrb/yjlyN4yg9DZS+CU9SLN3t3sfPq7mCJe56RxC9aFdOySrxmT5wpISNdmvtFC+ojYaKAYeqghtxz7jTR 2025-08-08 20:00:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-08 20:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 20:00:04 [INFO]: inside itemsold and closed 14409 2025-08-08 20:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:00:05 [INFO]: Ebay item id :: 305868057262 exists in Database 2025-08-08 20:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:00:05 [INFO]: inside itemsold and closed 14409 2025-08-08 20:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:00:07 [INFO]: Ebay item id :: 286132615583 exists in Database 2025-08-08 20:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:00:07 [INFO]: in processold action queue is array for {"44595178":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595178","ebayitemid":"305868057262","shopifyproductid":"8073954656478","variants":[{"price":"62.99","quantity":0,"weight":"3","shopifyproductid":"8073954656478","shopifyvariantid":"44249632997598","shopifyinventoryid":"46346787258590","shopifylocationid":"","product_id":"44595178","variant_id":"77487887","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595169":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595169","ebayitemid":"286132615583","shopifyproductid":"8063018500318","variants":[{"price":"62.99","quantity":0,"weight":"3","shopifyproductid":"8063018500318","shopifyvariantid":"44231079821534","shopifyinventoryid":"46328201380062","shopifylocationid":"","product_id":"44595169","variant_id":"77487878","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 20:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 20:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:00:07 [INFO]: Shopify Inventory id 46346787258590 2025-08-08 20:00:07 [INFO]: Shopify Location id 58450641063 2025-08-08 20:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:00:07Z","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 20:00:07 [INFO]: Change: available | Delta: -1 2025-08-08 20:00:07 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595178 and user_id = 14409 2025-08-08 20:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487887 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:00:07 [INFO]: Shopify Inventory id 46328201380062 2025-08-08 20:00:07 [INFO]: Shopify Location id 58450641063 2025-08-08 20:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:00:08Z","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 20:00:08 [INFO]: Change: available | Delta: -1 2025-08-08 20:00:08 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595169 and user_id = 14409 2025-08-08 20:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487878 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:00:08 [INFO]: updateIdsQuantity -> ["77487887","77487878"] 2025-08-08 20:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-08 20:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77487887 THEN 0 WHEN id = 77487878 THEN 0 END, quantityflag = CASE WHEN id = 77487887 THEN 0 WHEN id = 77487878 THEN 0 END WHERE user_id = 14409 AND id IN (77487887,77487878) 2025-08-08 20:00:08 [INFO]: QUANTITY Updated IDs: 77487887, 77487878 2025-08-08 20:00:08 [INFO]: Successfully processed data for user 14409 2025-08-08 20:00:08 [INFO]: Execution Started 2025-08-08 20:00:08 [INFO]: Execution Finished 2025-08-08 20:10:01 [INFO]: Execution Started 2025-08-08 20:10:01 [INFO]: old server sucessfully connected 2025-08-08 20:10:01 [INFO]: sqs client sucess created 2025-08-08 20:10:02 [INFO]: Number of messages in the queue: 1 2025-08-08 20:10:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:10:03 [INFO]: item found in queue is 14409 2025-08-08 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBju12YSshh7m4LTx+IRSjaBgLBSiSzIUcWCZABoyrf9bpxxSGWPGZxR2P3h2QrmaJDR/cirWqm52S+PwBw4GsD7Ty9pjOIJXK9a6qjqXehLGdqMSNFbqStV7/YLfR1zAfy8wLG6gO7X/udQlUIGFxFAzd9FK7FmOj8dPXMN7jGJFM2fa/X+5IgiCPak66zIa0V314VQBXt9kgVAVa+llftc2agBRQEOs4YAVOqVbrnleTCxRH54BTxmK3v9/7Nd0FaqGeaTKp8J25MthXixzI7Zia/1bCF1+32xCTO6qIgDeUPAfEDbu4yaCAqfcFkL4wYpq7bQ282/9UdoSdFcw9fl++6XpUK1KBlmoLbb0nMem4nE9fFViISYlidioIrkcwTL09N6loQ+fHW/wfAe8tBikeFbK39y75VliR1sbZyvzFd4hNzy3nwfeZe+6O5cfs 2025-08-08 20:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 20:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 20:10:03 [INFO]: inside itemsold and closed 14409 2025-08-08 20:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:10:05 [INFO]: Ebay item id :: 335329977229 exists in Database 2025-08-08 20:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:10:05 [INFO]: in processold action queue is array for {"44554208":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554208","ebayitemid":"335329977229","shopifyproductid":"8359024754910","variants":[{"price":"85.99","quantity":0,"weight":"2","shopifyproductid":"8359024754910","shopifyvariantid":"45047083434206","shopifyinventoryid":"47144882569438","shopifylocationid":"","product_id":"44554208","variant_id":"77446888","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 20:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 20:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:10:05 [INFO]: Shopify Inventory id 47144882569438 2025-08-08 20:10:05 [INFO]: Shopify Location id 58450641063 2025-08-08 20:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:10: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 20:10:05 [INFO]: Change: available | Delta: -1 2025-08-08 20:10:05 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554208 and user_id = 14409 2025-08-08 20:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77446888 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:10:05 [INFO]: updateIdsQuantity -> ["77446888"] 2025-08-08 20:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 20:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77446888 THEN 0 END, quantityflag = CASE WHEN id = 77446888 THEN 0 END WHERE user_id = 14409 AND id IN (77446888) 2025-08-08 20:10:05 [INFO]: QUANTITY Updated IDs: 77446888 2025-08-08 20:10:05 [INFO]: Successfully processed data for user 14409 2025-08-08 20:10:05 [INFO]: Execution Started 2025-08-08 20:10:05 [INFO]: Execution Finished 2025-08-08 20:20:01 [INFO]: Execution Started 2025-08-08 20:20:01 [INFO]: old server sucessfully connected 2025-08-08 20:20:01 [INFO]: sqs client sucess created 2025-08-08 20:20:02 [INFO]: Number of messages in the queue: 2 2025-08-08 20:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:20:03 [INFO]: item found in queue is 14409 2025-08-08 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQHR7Ox5ICwG5RrmV/d3J/WCZzLwNcWxH2S6YdLSFRUIM+atKJMh87ELV8Wlo2vaLD7QuFLcdMB+RyYH5Vni2XQ5nBD3i/sJ8X8vCIGWj1IoaAagVInRUKsASJQ0VPbsyvYWjtUrgdY3DXnqfu5TTwtoJAAeKnIUC/DX7rxRI5E3tWy7+2IO1fQwwL0bt5vGKp+FRmPWie8OyTTSEu7cHh7AVMtDxXMoGHMR+N8ZNNjB/H5iKKp0PyR8sGiMEKEJKZVvigFDl/obThaKxcFR0LGG87S3hYI5vU97xLPQFmcVpdTjzmD93HCxgz2BIR5xzeU3539zqOXBxNmBiEioqaI2wFJ9Alqrsdkg129xmlpsNfoVVYYB90j/uoFR7AMz7z2yh8pmV/h5SFy5DSRZD3cq09eBF3bmAVDHDZ3D0hYfrcL975Hxw5u0146bT5KBd 2025-08-08 20:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:20:03 [INFO]: item found in queue is 14409 2025-08-08 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBG8kKl8VVf7FuTdQ2P0HqMUcQwKqo4xNmGCJF+oWPcEX4DHuzofEcWF0f7cJCDcMA8DoO+JqsHjLL33KQQ1t1FoVoIjXD8DNR6ImtZxNb4wGwE1beJYnvJybDVR82NXmU/ENVrmqYGr0CEJvwBwGPUdSPzBRohbebKNf6DMSca8HPY+VG8fit0UTzBxBNUeJJXH2OFyX2tikhgTHvh/Wuia2CdeImwZgfp42VPuCRmwQ1XhVXqPj1eabkLBDeDrriUQ4CFC+yQQ7Y8m3tCtdIeliBJ9purY88Jde01P+O8hpoeRbIpFUu6dew5+oewrBFYNKTCFsIDbns5kJQ8QrRwElM5gu5LoJftGQiD5iF7jhuDKlXAWJoLWJ1220Ll2oQ8SsukL0BTjXIzHEisx5qnGjqMhdBGp+KrtSsAzo44Nh0zyxpaL+6QJnV2FV0I3Dq 2025-08-08 20:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-08 20:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 20:20:03 [INFO]: inside itemsold and closed 14409 2025-08-08 20:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:20:05 [INFO]: Ebay item id :: 286135589412 exists in Database 2025-08-08 20:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:20:05 [INFO]: inside itemsold and closed 14409 2025-08-08 20:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:20:07 [INFO]: Ebay item id :: 286157496010 exists in Database 2025-08-08 20:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:20:07 [INFO]: in processold action queue is array for {"44597400":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44597400","ebayitemid":"286135589412","shopifyproductid":"8720587784414","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"8720587784414","shopifyvariantid":"45996695355614","shopifyinventoryid":"48095073009886","shopifylocationid":"","product_id":"44597400","variant_id":"77490109","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44567434":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567434","ebayitemid":"286157496010","shopifyproductid":"8731505983710","variants":[{"price":"169.99","quantity":0,"weight":"2","shopifyproductid":"8731505983710","shopifyvariantid":"46030472708318","shopifyinventoryid":"48129083441374","shopifylocationid":"","product_id":"44567434","variant_id":"77460114","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 20:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 20:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:20:07 [INFO]: Shopify Inventory id 48095073009886 2025-08-08 20:20:07 [INFO]: Shopify Location id 58450641063 2025-08-08 20:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:20:07Z","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 20:20:07 [INFO]: Change: available | Delta: -1 2025-08-08 20:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44597400 and user_id = 14409 2025-08-08 20:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490109 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:20:07 [INFO]: Shopify Inventory id 48129083441374 2025-08-08 20:20:07 [INFO]: Shopify Location id 58450641063 2025-08-08 20:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:20:07Z","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 20:20:07 [INFO]: Change: available | Delta: -1 2025-08-08 20:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567434 and user_id = 14409 2025-08-08 20:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77460114 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:20:07 [INFO]: updateIdsQuantity -> ["77490109","77460114"] 2025-08-08 20:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-08 20:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77490109 THEN 0 WHEN id = 77460114 THEN 0 END, quantityflag = CASE WHEN id = 77490109 THEN 0 WHEN id = 77460114 THEN 0 END WHERE user_id = 14409 AND id IN (77490109,77460114) 2025-08-08 20:20:07 [INFO]: QUANTITY Updated IDs: 77490109, 77460114 2025-08-08 20:20:07 [INFO]: Successfully processed data for user 14409 2025-08-08 20:20:07 [INFO]: Execution Started 2025-08-08 20:20:07 [INFO]: Execution Finished 2025-08-08 20:30:01 [INFO]: Execution Started 2025-08-08 20:30:01 [INFO]: old server sucessfully connected 2025-08-08 20:30:01 [INFO]: sqs client sucess created 2025-08-08 20:30:02 [INFO]: Number of messages in the queue: 1 2025-08-08 20:30:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:30:03 [INFO]: item found in queue is 14409 2025-08-08 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPa6sOjr1gh1Z6U2uTLIVM9tzbtRa5bRDzLdOphxuM0UhdVemoJdJZNbyJQcJauSOPl+MMB7dc5GOnVpBSx20jc2M/MmUSINXrJ/9KlMY/EiO4VZO/ga456V7yC38CRYZC5Nc/VwU8LndQ2v2k0Lwu60aWBQx5YFJGWmyaIurd29DPplADGUnXnGXVOixH0TZvQYaP027rVBg5pcoES3ZHd0clurASfVmoSOj4zzghyKWIubI0RU/FA/2WZFrUYd5eMs1stlKL9lFyedOz7jtj8/EeudVfTcCOnzIEAAJ3GaPqop72pdckS9hZvpQH7T085gg9hklA+WPp2VW+ypjWCAu0XnJvukF2Fu+TdwwFV1POgITqV7KkjyzlAarTAwfiZH+Z6QQBtaf54/bN/DJxaYBjVhPjyyp98Htvle5YzdZgfBR3DmylsNE0WWOERm8 2025-08-08 20:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 20:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 20:30:03 [INFO]: inside itemsold and closed 14409 2025-08-08 20:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:30:05 [INFO]: Ebay item id :: 335670286060 exists in Database 2025-08-08 20:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:30:05 [INFO]: in processold action queue is array for {"44568865":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44568865","ebayitemid":"335670286060","shopifyproductid":"8733220372702","variants":[{"price":"155.99","quantity":0,"weight":"2","shopifyproductid":"8733220372702","shopifyvariantid":"46035700416734","shopifyinventoryid":"48134393331934","shopifylocationid":"","product_id":"44568865","variant_id":"77461549","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 20:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 20:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:30:05 [INFO]: Shopify Inventory id 48134393331934 2025-08-08 20:30:05 [INFO]: Shopify Location id 58450641063 2025-08-08 20:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:30: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 20:30:05 [INFO]: Change: available | Delta: -1 2025-08-08 20:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44568865 and user_id = 14409 2025-08-08 20:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77461549 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:30:05 [INFO]: updateIdsQuantity -> ["77461549"] 2025-08-08 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77461549 THEN 0 END, quantityflag = CASE WHEN id = 77461549 THEN 0 END WHERE user_id = 14409 AND id IN (77461549) 2025-08-08 20:30:05 [INFO]: QUANTITY Updated IDs: 77461549 2025-08-08 20:30:05 [INFO]: Successfully processed data for user 14409 2025-08-08 20:30:05 [INFO]: Execution Started 2025-08-08 20:30:05 [INFO]: Execution Finished 2025-08-08 20:40:01 [INFO]: Execution Started 2025-08-08 20:40:01 [INFO]: old server sucessfully connected 2025-08-08 20:40:01 [INFO]: sqs client sucess created 2025-08-08 20:40:02 [INFO]: Number of messages in the queue: 3 2025-08-08 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:40:03 [INFO]: item found in queue is 14409 2025-08-08 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBuuxGm0STsqpzOYdUTFeXcT+NPUTCC07+d93w9hPZKkdxQxtyEOUuRPVFWNA+TnjGP7N5jsI6Ig0YdKFtS5Kct6sMjCm97/WzLE4uRVguSLOHINEcn0KHinph71xovA30RoXa7PWn1pqM4DCridsk0Rv1wmPvvszzuBEcWd8bh/TyKIk3iVpmtx/9KXgF2iH6AwLlPtVvnPSVcUU1nTWW2CznCxvJouRrpjJ/t5zI7wp4YGQX+fgTJO2f00Z6vNCZhzVa9DecDSXMWatIym2GPC/s753rkJMz3gc1x1uOyj1pjCnGq57tUfQq1J1gLrlVW2eS2NgS/AYPSOyH7qMfKftv/qJRinaHFpcWtozB4IiMl527RykEXtcq1LsovezOqhg/snJedw7a7zdL4lwKOdnffj1jK3t5lL3EmRq+R/6mDSNgJ/VUvd6fQz9QFZG2 2025-08-08 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:40:03 [INFO]: item found in queue is 14409 2025-08-08 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB6D03rsgRFiAR7oCHb364jp2bG7z8RFE78fouIBIsmgIYdB9QzOMnnfCV5vKaVnQkOolvyJrGr8psNM1ueabDYV8ziPU6lWMeyzGpNMw38dnrPC1dr77e/4n6A1cK4Z1kxQbG7uGUPnoscCUIRyYdDSzg5/Vap4YaUPXerpIUCRS0v9C+CLbczBYlhwsMKjyef1MpmYQs8PSyrtq1yzc9uR/p3oEUydcvWPnGDdMWI1l7KR3HO+sKei8zvY0+t7jphw+q8SKasr1dLpfnGvzmK0VYxA27luUwCth/SZvXOXNC0isbkDJss2XqNY1rkmoo9xPI7XsyvvSqBQ2T2pSvSj0vqTJOhWfGGnzSMtj8qAOcn6SO8BKnOOQRE4PxnPIvEgBTRU/RB8wpI0YCBbdAojn3OSFaVArVoTGaB8mri10WZ1jVOiRKKt6FHpxgUcHy 2025-08-08 20:40:04 [INFO]: item found in queue is if condition 14409 2025-08-08 20:40:04 [INFO]: item found in queue is 14409 2025-08-08 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB4nYynPaohBaowx3ukQ8WBqHI7ADH8Jget2tP4BNzuZdQ0s4C2oQFKoFxrxPvDfzIAp6ccMUprYso/2mthzCaNm9LtC4ODPIphr9+TVyGxd30F/T9qfuzUldQtgdptIa/zDixLPvG0MPI+BsECoykbhPii6OETMLswBL4JOyuye9vqA3SGSt0ujcmzO2jRX9ebkETw4EedN5gr58D3Y7CbZ2RssbSDYE0igF+0pCZ8JpR0+F9W+cfyjuvSCX5AQxQCCRmaUapgOw4325kj1MdJf00RgzIheZNyx1k1I4ZxDqlbuXEu7eukJkx3S/LGOwItHGkULmuAN8iI9WAMFU4TCskAOLm5QSnbrlO1BnOr35XyEZu+jmoST0EyYEss4PRMnJVPsz1Acd3wR358Jxr3UYa74LUVbXw8dq6eIJ989flZ7+ROfxrs8vY9DW7ul+d 2025-08-08 20:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-08 20:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 20:40:04 [INFO]: inside itemsold and closed 14409 2025-08-08 20:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:40:06 [INFO]: Ebay item id :: 282886817452 exists in Database 2025-08-08 20:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:40:06 [INFO]: inside itemsold and closed 14409 2025-08-08 20:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:40:08 [INFO]: Ebay item id :: 286177198863 exists in Database 2025-08-08 20:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:40:08 [INFO]: inside itemsold and closed 14409 2025-08-08 20:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:40:09 [INFO]: Ebay item id :: 257020895408 exists in Database 2025-08-08 20:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:40:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-08 20:40:09 [INFO]: in processold action queue is array for {"44647639":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44647639","ebayitemid":"282886817452","shopifyproductid":"6640437559463","variants":[{"price":"10.00","quantity":0,"weight":"0.5","shopifyproductid":"6640437559463","shopifyvariantid":"39674041532583","shopifyinventoryid":"41768747630759","shopifylocationid":"","product_id":"44647639","variant_id":"77552828","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44638802":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638802","ebayitemid":"286177198863","shopifyproductid":"8286070374622","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8286070374622","shopifyvariantid":"44806703677662","shopifyinventoryid":"46904731107550","shopifylocationid":"","product_id":"44638802","variant_id":"77543991","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45241212":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45241212","ebayitemid":"257020895408","deleted":1}}} 2025-08-08 20:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 20:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:40:10 [INFO]: productIds WHich are having null productid -> [45241212] 2025-08-08 20:40:10 [INFO]: ebayItemIds WHich are not imported-> ["257020895408"] 2025-08-08 20:40:10 [INFO]: Entered in bulkUpdateProducts function 2025-08-08 20:40:10 [INFO]: Transaction started for bulkUpdateProducts 2025-08-08 20:40:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45241212) 2025-08-08 20:40:10 [INFO]: Query executed successfully. Affected rows: 0 2025-08-08 20:40:10 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-08 20:40:10 [INFO]: Transaction committed successfully. 2025-08-08 20:40:10 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-08 20:40:10 [INFO]: Shopify Inventory id 41768747630759 2025-08-08 20:40:10 [INFO]: Shopify Location id 58450641063 2025-08-08 20:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:40:10 [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 20:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44647639 and user_id = 14409 2025-08-08 20:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77552828 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:40:10 [INFO]: Shopify Inventory id 46904731107550 2025-08-08 20:40:10 [INFO]: Shopify Location id 58450641063 2025-08-08 20:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:40:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 20:40:10 [INFO]: Change: available | Delta: -2 2025-08-08 20:40:10 [INFO]: Change: on_hand | Delta: -2 2025-08-08 20:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638802 and user_id = 14409 2025-08-08 20:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77543991 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:40:10 [INFO]: updateIdsQuantity -> ["77552828","77543991"] 2025-08-08 20:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-08 20:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77552828 THEN 0 WHEN id = 77543991 THEN 0 END, quantityflag = CASE WHEN id = 77552828 THEN 0 WHEN id = 77543991 THEN 0 END WHERE user_id = 14409 AND id IN (77552828,77543991) 2025-08-08 20:40:10 [INFO]: QUANTITY Updated IDs: 77552828, 77543991 2025-08-08 20:40:10 [INFO]: Successfully processed data for user 14409 2025-08-08 20:40:10 [INFO]: Execution Started 2025-08-08 20:40:10 [INFO]: Execution Finished 2025-08-08 20:50:01 [INFO]: Execution Started 2025-08-08 20:50:01 [INFO]: old server sucessfully connected 2025-08-08 20:50:01 [INFO]: sqs client sucess created 2025-08-08 20:50:02 [INFO]: Number of messages in the queue: 3 2025-08-08 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:50:03 [INFO]: item found in queue is 14409 2025-08-08 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8RLraCjxJOzHbkS/wt59/9khXMDZ36RTOnFoloI3IzTL2Ve3QKRQBxhtfnaEtj0cPUfp+8QqHt71LTFXN4jGl+hzbsTVbustLDUbQ2Je412435Wa0QMEARrL/G78J9lsBtlymHmhlL5qrqg2tRyOqSu2BT0KVFbF5LGfrytQNvmE80p7EERD8+PT3kGmqmvClDs3ng8Ad1UAnxn/9VenNWWDNWsTuGSgHIwEmiGk/IP5+BZ1ueG2D+207nUq1a3P5mNjIioQ6mOitoX4CM4ZoJw1zl8dWsHjEXrQLP/kC65gaiV7IhF7y+IvQO3rwKmUZQDKO50AHbPxsjWhWb0eU/2XRIgLriK50/j16xBoenF1ig68vbulYQ3AZ8skjMScv6OYGFbZAekrJ1UEyDObQ6xlYhvy3bVzjotntjqQQhIopCgUgV5jYVC3s6IOF6iw 2025-08-08 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:50:03 [INFO]: item found in queue is 14409 2025-08-08 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKRf3b0LGbnChLCr7Z8tealxROZ6/h0mgidtjeb0ekNLgHWZVI+xVU8K99Hl8FTicl+BS50e/qKmwJRGmzZKghBVZjcSMA2kGJS/ASgZgR+VkWkRog8Bv20Kl8r2G6r8ziwW6OiJp7t2/UkRaAMsYKhBk7A8Y57HBKjes4HKyhHxZCl+myNliBaJPuZXDOrXV7IUjsahh1RIVh111ntBCW8yvXgoB18zGp+NYreBxapxsq6JJ1uaN1d7HqzX7rLqSO/2FJpGcE6LPC6zrD1lIgcr6FRksi2ZkdiTKukLuV+I7EtZteKEwpMQPb0zgUCAdc3L+LwyDqG7jP52A7OmN6Y3Hl3jGngz5YclPhSD9k+7f7szZSnaIGyMQ2SVVZ3yUwUyuYLRVQq7jHrzaYNSrSoKuoDIHiHV8vkcCUkzRHHFCcrhKdtJ2nyDsIt/ZHTi8 2025-08-08 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 20:50:03 [INFO]: item found in queue is 14409 2025-08-08 20:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBIJAm8IbkwsKQiO+9WuXFI34Epv2ZA8bczfaH25iMfx+cgzT6+eZW8lxAhEeRX172sSLdUG3FqeWu16EXgcTgAONh9qMyjswloc9UvbiZm9cubAfHaFujn/B7CrC1LU9I+rmjgiZDXFhjftT5cZAJEFY99CS5vG1A/9X9TnVtGwLKW3eRwjyk3pput4VrkDyWZmXZZbMVo8zRY2GbeFpUtcMFBfGiRdhuEAeTa0N5okkb+XV1f2icg2K1uMaea0KcBi/PLexOpyqnM4L1aRxttQSiIk9KdgX+Sqk03kNIXvbom9gDm4KUvHcb2vKO0v+g/F0km2+KgQymXARh6m+/wx38hRqAFP3/wTnUtHbVzyZf36V8GcyDd3Sy71qNALUuX8D39lNNyYg0+/MeSUegNxErHpP1YSFm8Mb+MlgGIkjtWBm9Hjc4EdRzY/K91yvX 2025-08-08 20:50:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-08 20:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 20:50:04 [INFO]: inside itemsold and closed 14409 2025-08-08 20:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:50:06 [INFO]: Ebay item id :: 305935846307 exists in Database 2025-08-08 20:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:50:06 [INFO]: inside itemsold and closed 14409 2025-08-08 20:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:50:07 [INFO]: Ebay item id :: 286492550379 exists in Database 2025-08-08 20:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:50:07 [INFO]: inside itemsold and closed 14409 2025-08-08 20:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 20:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 20:50:09 [INFO]: Ebay item id :: 305942149215 exists in Database 2025-08-08 20:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 20:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 20:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 20:50:09 [INFO]: in processold action queue is array for {"44592272":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592272","ebayitemid":"305935846307","shopifyproductid":"8747840536798","variants":[{"price":"64.99","quantity":0,"weight":"2","shopifyproductid":"8747840536798","shopifyvariantid":"46109145170142","shopifyinventoryid":"48208083845342","shopifylocationid":"","product_id":"44592272","variant_id":"77484981","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44647347":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44647347","ebayitemid":"286492550379","shopifyproductid":"8878300725470","variants":[{"price":"20.99","quantity":0,"weight":"0.5","shopifyproductid":"8878300725470","shopifyvariantid":"46619998814430","shopifyinventoryid":"48722893570270","shopifylocationid":"","product_id":"44647347","variant_id":"77552536","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44596731":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596731","ebayitemid":"305942149215","shopifyproductid":"7699952730334","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"7699952730334","shopifyvariantid":"42997123350750","shopifyinventoryid":"45092322705630","shopifylocationid":"","product_id":"44596731","variant_id":"77489440","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 20:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 20:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 20:50:09 [INFO]: Shopify Inventory id 48208083845342 2025-08-08 20:50:09 [INFO]: Shopify Location id 58450641063 2025-08-08 20:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:50:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 20:50:10 [INFO]: Change: available | Delta: -2 2025-08-08 20:50:10 [INFO]: Change: on_hand | Delta: -2 2025-08-08 20:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592272 and user_id = 14409 2025-08-08 20:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484981 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:50:10 [INFO]: Shopify Inventory id 48722893570270 2025-08-08 20:50:10 [INFO]: Shopify Location id 58450641063 2025-08-08 20:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:50:10Z","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 20:50:10 [INFO]: Change: available | Delta: -1 2025-08-08 20:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44647347 and user_id = 14409 2025-08-08 20:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77552536 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:50:10 [INFO]: Shopify Inventory id 45092322705630 2025-08-08 20:50:10 [INFO]: Shopify Location id 58450641063 2025-08-08 20:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 20:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T20:50:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1929,"restoreRate":100}}}} 2025-08-08 20:50:10 [INFO]: Change: available | Delta: -1 2025-08-08 20:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-08 20:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 20:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596731 and user_id = 14409 2025-08-08 20:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489440 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 20:50:10 [INFO]: updateIdsQuantity -> ["77484981","77552536","77489440"] 2025-08-08 20:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-08 20:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77484981 THEN 0 WHEN id = 77552536 THEN 0 WHEN id = 77489440 THEN 0 END, quantityflag = CASE WHEN id = 77484981 THEN 0 WHEN id = 77552536 THEN 0 WHEN id = 77489440 THEN 0 END WHERE user_id = 14409 AND id IN (77484981,77552536,77489440) 2025-08-08 20:50:10 [INFO]: QUANTITY Updated IDs: 77484981, 77552536, 77489440 2025-08-08 20:50:10 [INFO]: Successfully processed data for user 14409 2025-08-08 20:50:10 [INFO]: Execution Started 2025-08-08 20:50:10 [INFO]: Execution Finished