2025-08-07 06:00:01 [INFO]: Execution Started 2025-08-07 06:00:01 [INFO]: old server sucessfully connected 2025-08-07 06:00:02 [INFO]: sqs client sucess created 2025-08-07 06:00:03 [INFO]: Number of messages in the queue: 1 2025-08-07 06:00:03 [INFO]: item found in queue is if condition 14409 2025-08-07 06:00:03 [INFO]: item found in queue is 14409 2025-08-07 06:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBCVsCJqizl7vzI3d4yV2QDwp5lNpM8//409pkK4Zci2U5+BJ+388b9GkOyox8S4mGU/aQrlz7tsfrwWSMbo4cYSeFmis7HsG85LAHzDrdPawB2kxYrDOr2dm20bhzG0e3pld9W2UHQ666nToOMtVD+svlv7RJiU7COKAZo4CfD3KQUHfS4MS6IZr2k1MQ+Q0f4LbUULuNkQY+dkupGpBMCVwYpLsKeXjxIuqh0Klb4WDKNwSH5Lchg/dK1Ekj/6FtmUKslk+Rg7HaI0xDWcJS6DrCUOcwOaBaWX2ajS+sbHniHnq6eb1ymH39+wE40yk7FS+kQx+P/YyE2ZOZqY7jE8YES12GINBnB1ANQ9ARqqKIOi65Hdxfgi1RRK2V9e3c3hoSZXgfOrFerCG5iwc0EDx6mQfJLLejI4fk31OQ9wsfJP/Iuq6nLE8yx/I2D0FN 2025-08-07 06:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 06:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 06:00:03 [INFO]: inside itemsold and closed 14409 2025-08-07 06:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:00:05 [INFO]: Ebay item id :: 402993137709 exists in Database 2025-08-07 06:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:00:05 [INFO]: in processold action queue is array for {"44642908":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642908","ebayitemid":"402993137709","shopifyproductid":"6638292271271","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"6638292271271","shopifyvariantid":"39668485030055","shopifyinventoryid":"41763189915815","shopifylocationid":"","product_id":"44642908","variant_id":"77548097","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 06:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 06:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:00:05 [INFO]: Shopify Inventory id 41763189915815 2025-08-07 06:00:05 [INFO]: Shopify Location id 58450641063 2025-08-07 06:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06: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-07 06:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642908 and user_id = 14409 2025-08-07 06:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77548097 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:00:05 [INFO]: updateIdsQuantity -> ["77548097"] 2025-08-07 06:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 06:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77548097 THEN 0 END, quantityflag = CASE WHEN id = 77548097 THEN 0 END WHERE user_id = 14409 AND id IN (77548097) 2025-08-07 06:00:05 [INFO]: QUANTITY Updated IDs: 77548097 2025-08-07 06:00:05 [INFO]: Successfully processed data for user 14409 2025-08-07 06:00:05 [INFO]: Execution Started 2025-08-07 06:00:05 [INFO]: Execution Finished 2025-08-07 06:10:01 [INFO]: Execution Started 2025-08-07 06:10:01 [INFO]: old server sucessfully connected 2025-08-07 06:10:01 [INFO]: sqs client sucess created 2025-08-07 06:10:03 [INFO]: Number of messages in the queue: 0 2025-08-07 06:10:23 [INFO]: Execution Started 2025-08-07 06:10:23 [INFO]: Execution Finished 2025-08-07 06:20:01 [INFO]: Execution Started 2025-08-07 06:20:01 [INFO]: old server sucessfully connected 2025-08-07 06:20:01 [INFO]: sqs client sucess created 2025-08-07 06:20:02 [INFO]: Number of messages in the queue: 4 2025-08-07 06:20:02 [INFO]: item found in queue is if condition 14409 2025-08-07 06:20:02 [INFO]: item found in queue is 14409 2025-08-07 06:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEByGWrQju9SEF36bSE9KmP2eDGK8/pFIAgBjHTkNsdVyDN6aozQi4n4b598ufKFe4XdzlfU0FRLabpFvbmVylvYcFMQFqx6hp6+HHHCkJZZbQ49qghHqJrzcE4dr1RoHyVbzRrurYcKUFbmP+/3GSbSnZwiSNygKg1S57j91c8/kIFUgkkvrYoHJ53+vcPl3ls9D+IZfyw0eVj7Dnbkst8Q7PBQ2yHQTfpX5WSrN3QeOCMiW6jHPrgVF6QkMBGaqvviuuMEDRICwxWJTrpNV7/l1mBzVeX5rNzP35KV9O12ISfwEwm/69YPPBaECoM8YCpWsIzfSqYmPQC8Qf7BVfWqUmf76Z/rYCKps8gqx7Ph6mD8uaYHCNkKIqUwjOL+X2K+BVB3c6/eka/U74Fy/Oylj03BE4Y7UIK6Lfv3aqjbkHM3EvaNxJXoqCjjdIJX6Av 2025-08-07 06:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 06:20:03 [INFO]: item found in queue is 14409 2025-08-07 06:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBRWsLiCiGYcYWBL8rHDVD438DE3n0AAF6OKYHpXghxagYylw4k61DmrtehfQSKsCyigD+Xjg+i4HTILCDleaYDANa42sgKc9eGcA6nvm2GOS9X+Y4K1hNrD9QaTz7Cq69K7yYnjpzVo+wmwRnSVS/LpT0WeHTvBHSg+ehfexuRXXHVzrieKVaeIDaU+qHk1FmoipIzhYr2slH/UkBf3v0YhcVdiPm01ykJv087E2NrWnxxptJY1R8QtaOI/vhbI6Tl0DOUu+vA6Do+Gd79U0mEsGgL5ktpEo/ashocgqt70w6Bsww/1WI70VxqN+Bup2jccCMii7LItnqqkWhY6DIJNK/pPI3xZ+jBUATkaJR3fSNjCzEYalhpRGFU/mnUogUjHtmohOdWKgBzlxjiH595RdvgBW9vrRR2h4Kdjzw80Vh5oSPj2ghTuk1lqFwHLg3 2025-08-07 06:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 06:20:03 [INFO]: item found in queue is 14409 2025-08-07 06:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB0pkXE0iralLi2SkD+8wphFA+7lOlYFfDxoo9OZav9bK+gjfnr9w9obVTx7RnmOCe4D4P2K3FI5T9AlkOWVyir7gaZTKCAoKjGao9y8ezlQfmi6jzMvy0xkwU7txDkEdM+fi8yfI02rN397JDXd+BVmMGmxrfTX8USf/d7s28Edi5a2FBU9pL7bqyFb74SOG7+W2gXEzHCf5FwW0T67zQykGRied9ih3MUqTG/0oroZQPX4zvjurmfEw30vXxeYPTT3F4hJb3AJQE4VTeTq7LdIzpm16b35uoFHSKEc3n+Oa7agtJURjMDc/5o44PyKmjH6Dptfa4Ygk0LzxZTYIOPyq1TeA0D/7+xmjIQq2pZpPcRgljQx+mf4VV0z26UkcxRHm4Go/mb1/ghjH3TediLuEU8j11rqFfXvsp8b7C094F8rwUEyTvjpIgYRRZLsY4 2025-08-07 06:20:04 [INFO]: item found in queue is if condition 14409 2025-08-07 06:20:04 [INFO]: item found in queue is 14409 2025-08-07 06:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB8TXkqT5krN5zrJLgrX0+mPIGxBniCspYGp7o8iedkOBMTUXbuaHVDBs9fIwrxbYlfl/8PoX/sqLBPqMUGI2UpOVQ0SAAm0lpjYxqISxyMSUeAmIc3H9VO5RVfZOhICp6N6e874ZAxL+T6Y6w+ijAUufzVTjZpI9VNQ5gTIBgcVE5KQrS+AbS5alYGJNv54d5clfQ01lzw9CHLDANYNmm4V6RHLUTkm/MyKx2av/okZT89f95eWUQwXcUJpIqDcSbv+JcS5HGTkBxegdsvYXIGwxUmfH6FNCvMMnEdI4yDmB6ORZkUoxFz5L/EVExIwrSu162BqJVURtgWRaZvbWM6c0l4iWYDq6ATBGLECl/UuFFwAtOkLAMQXepdsCgihNvg4/ujbcJJ9Y0ev9Q0GVgfvcuon3aykpqYvoFTGkDvrBdsAzm9L3Gg6ciD6xoTK37 2025-08-07 06:20:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-07 06:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 06:20:04 [INFO]: inside itemsold and closed 14409 2025-08-07 06:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:20:06 [INFO]: Ebay item id :: 325447145698 exists in Database 2025-08-07 06:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:20:06 [INFO]: inside itemsold and closed 14409 2025-08-07 06:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:20:08 [INFO]: Ebay item id :: 225277730929 exists in Database 2025-08-07 06:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:20:08 [INFO]: inside itemsold and closed 14409 2025-08-07 06:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:20:09 [INFO]: Ebay item id :: 326147055437 exists in Database 2025-08-07 06:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:20:09 [INFO]: inside itemsold and closed 14409 2025-08-07 06:20:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:20:11 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:20:11 [INFO]: Ebay item id :: 286670302096 exists in Database 2025-08-07 06:20:11 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:20:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 06:20:11 [INFO]: in processold action queue is array for {"44710739":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710739","ebayitemid":"325447145698","shopifyproductid":"7955800195294","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7955800195294","shopifyvariantid":"43996623143134","shopifyinventoryid":"46093144588510","shopifylocationid":"","product_id":"44710739","variant_id":"77618352","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44710729":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710729","ebayitemid":"225277730929","shopifyproductid":"7955791708382","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7955791708382","shopifyvariantid":"43996612198622","shopifyinventoryid":"46093133643998","shopifylocationid":"","product_id":"44710729","variant_id":"77618342","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44689354":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44689354","ebayitemid":"326147055437","shopifyproductid":"7945338061022","variants":[{"price":"199.99","quantity":0,"weight":"2","shopifyproductid":"7945338061022","shopifyvariantid":"43960399266014","shopifyinventoryid":"46056854028510","shopifylocationid":"","product_id":"44689354","variant_id":"77594606","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45141468":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45141468","ebayitemid":"286670302096","deleted":1}}} 2025-08-07 06:20:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 06:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:20:11 [INFO]: productIds WHich are having null productid -> [45141468] 2025-08-07 06:20:11 [INFO]: ebayItemIds WHich are not imported-> ["286670302096"] 2025-08-07 06:20:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 06:20:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 06:20:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45141468) 2025-08-07 06:20:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 06:20:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 06:20:11 [INFO]: Transaction committed successfully. 2025-08-07 06:20:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 06:20:11 [INFO]: Shopify Inventory id 46093144588510 2025-08-07 06:20:11 [INFO]: Shopify Location id 58450641063 2025-08-07 06:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:20:11Z","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-07 06:20:11 [INFO]: Change: available | Delta: -1 2025-08-07 06:20:11 [INFO]: Change: on_hand | Delta: -1 2025-08-07 06:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710739 and user_id = 14409 2025-08-07 06:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77618352 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:20:11 [INFO]: Shopify Inventory id 46093133643998 2025-08-07 06:20:11 [INFO]: Shopify Location id 58450641063 2025-08-07 06:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:20:12Z","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-07 06:20:12 [INFO]: Change: available | Delta: -1 2025-08-07 06:20:12 [INFO]: Change: on_hand | Delta: -1 2025-08-07 06:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710729 and user_id = 14409 2025-08-07 06:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77618342 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:20:12 [INFO]: Shopify Inventory id 46056854028510 2025-08-07 06:20:12 [INFO]: Shopify Location id 58450641063 2025-08-07 06:20:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:20:12Z","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-07 06:20:12 [INFO]: Change: available | Delta: -1 2025-08-07 06:20:12 [INFO]: Change: on_hand | Delta: -1 2025-08-07 06:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44689354 and user_id = 14409 2025-08-07 06:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77594606 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:20:12 [INFO]: updateIdsQuantity -> ["77618352","77618342","77594606"] 2025-08-07 06:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 06:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77618352 THEN 0 WHEN id = 77618342 THEN 0 WHEN id = 77594606 THEN 0 END, quantityflag = CASE WHEN id = 77618352 THEN 0 WHEN id = 77618342 THEN 0 WHEN id = 77594606 THEN 0 END WHERE user_id = 14409 AND id IN (77618352,77618342,77594606) 2025-08-07 06:20:12 [INFO]: QUANTITY Updated IDs: 77618352, 77618342, 77594606 2025-08-07 06:20:12 [INFO]: Successfully processed data for user 14409 2025-08-07 06:20:12 [INFO]: Execution Started 2025-08-07 06:20:12 [INFO]: Execution Finished 2025-08-07 06:30:01 [INFO]: Execution Started 2025-08-07 06:30:01 [INFO]: old server sucessfully connected 2025-08-07 06:30:01 [INFO]: sqs client sucess created 2025-08-07 06:30:05 [INFO]: Number of messages in the queue: 3 2025-08-07 06:30:06 [INFO]: item found in queue is if condition 14409 2025-08-07 06:30:06 [INFO]: item found in queue is 14409 2025-08-07 06:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBPw1xISoe9n9wJlrTJQ6l88Crlwhh1P6ll9yiT6IZroz0mXPUwacgRgXIjlGfD/8E/DgKcgRFIdcMlmVKHPFHfpbvdsbTl9k31CaP8ifmLGvhUBC7+CyPHCLEssEta6tjIBxbZXdrEpahfxg61xFSFswazvhyx7wIbVOqtixTZV1fBmRLOajhZxL07hR1iiadagrDcdLUApGAMDJnhodVr0/33U7TjT9HZ4elCerUMjvqxLiShKWN0Qs2Zqmt7RM6OTjr1iC2HiD4BbpRSxhxCz6aAQL1xClFKCNrfuwOH8wL9HlDzHdYdBUowy12Yr6rtwfTjZTAbDnPaYuA6tM0tAbwySQYnOlM5m2v+G5nqPPDUFMhw/HPyQeBRm0nmf7ngtYlWOZBpfT0xcDaXmA2Do9giKafNK7V8390TO+LPtT/X8AFyiHYpB66nmCV3xgX 2025-08-07 06:30:07 [INFO]: item found in queue is if condition 14409 2025-08-07 06:30:07 [INFO]: item found in queue is 14409 2025-08-07 06:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEByGx5uGcApi6MBMQMHy/pjKt45d6Ef1wFkmXH+f8QLPqyCke6btqxYbIUmJY2WoiwVEswiwlwZgaE7uPaGQz2VGPek28bl36cBQZpfiX4OlsUHs0nW2jXBklP0pC9dJh8CiCvAdNHwPZHZqC9Bac5GGzvnL/nCRDjXRqKxZooAtJEnZtzpXSRCqeKgmMa4pIsqIVo0tNg5yQOSyrOwXKBv2+LLH4kRmsVqBODpzIrkV6hI7ltcQAPL2ACE6fwrZgHEOZcMyRNpbMuprrzGa05+K3j438frpTszIhx7/Ry8tOxncQd7hNCKXTfchhpSu6uqeUAvqTn2r7CO+NxJiwkCsiVeqkRtW/KgUX2FKH4tlVGceyrzwvK/MHavqhiXclwqaOBP/h/NNqWAE2XctcOI6VxukCQ/NF+XAXSQJv6uHP2OdTmGySzMFbl0nWYiSHg 2025-08-07 06:30:08 [INFO]: item found in queue is if condition 14409 2025-08-07 06:30:08 [INFO]: item found in queue is 14409 2025-08-07 06:30:08 [INFO]: Message deleted from the queue for receipt handle: AQEB1+4IZmO0lEvcV9BUEeRM/ofN126Ec+/Yc+gYRwfefonV7hmNYQVZJ66w2F/fSAJ4ewRThE+Nn8uUNVMXYkhGinAh6kMtypYhf+Pmp0XOA0lCyj1/aiSJ6IKQNYi6CAzbcWCYLvq5p9EE3163j/1u2nqNUtlCSBCyjWqcnNlyobneVTippgp4JbK2Tpc4maqEQ8QaDL2xmdElXQXjq/Mw1h3q8bHnpHL95iPPuf7QiaNIthRQtQ0cNXBDPntdUhiTAERpFwtHj4ToocfLRus2LSo1eI0Ke253WUTqVuUiq6Wd7vZ3QjjC4ARzzNBCoGDVht11hUpeTFlOZXMEfEN9HjUSKl4ueIeTTVZEbWHAtMhHu52vhBaDBCdzOoJ0O9W0FDU574JOOEh9SygFQEj8h08Qi+FjJouV95i896Os+wNup9u7RI1fydm6JENvRVOW 2025-08-07 06:30:08 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 06:30:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 06:30:08 [INFO]: inside itemsold and closed 14409 2025-08-07 06:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:30:10 [INFO]: Ebay item id :: 324641645765 exists in Database 2025-08-07 06:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:30:10 [INFO]: inside itemsold and closed 14409 2025-08-07 06:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:30:12 [INFO]: Ebay item id :: 325360740950 exists in Database 2025-08-07 06:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:30:12 [INFO]: inside itemsold and closed 14409 2025-08-07 06:30:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:30:14 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:30:14 [INFO]: Ebay item id :: 225879561972 exists in Database 2025-08-07 06:30:14 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:30:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:30:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:30:14 [INFO]: in processold action queue is array for {"44673965":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673965","ebayitemid":"324641645765","shopifyproductid":"6792368685223","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"6792368685223","shopifyvariantid":"40156306931879","shopifyinventoryid":"42251545247911","shopifylocationid":"","product_id":"44673965","variant_id":"77579185","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44683761":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44683761","ebayitemid":"325360740950","shopifyproductid":"8923141112030","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8923141112030","shopifyvariantid":"46827895161054","shopifyinventoryid":"48926357192926","shopifylocationid":"58450641063","product_id":"44683761","variant_id":"77588986","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662424":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662424","ebayitemid":"225879561972","shopifyproductid":"8211477823710","variants":[{"price":"10.99","quantity":0,"weight":"0.75","shopifyproductid":"8211477823710","shopifyvariantid":"44536217698526","shopifyinventoryid":"46634170089694","shopifylocationid":"","product_id":"44662424","variant_id":"77567644","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 06:30:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 06:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:30:14 [INFO]: Shopify Inventory id 42251545247911 2025-08-07 06:30:14 [INFO]: Shopify Location id 58450641063 2025-08-07 06:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:30:14Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 06:30:14 [INFO]: Change: available | Delta: -3 2025-08-07 06:30:14 [INFO]: Change: on_hand | Delta: -3 2025-08-07 06:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673965 and user_id = 14409 2025-08-07 06:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579185 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:30:14 [INFO]: Shopify Inventory id 48926357192926 2025-08-07 06:30:14 [INFO]: Shopify Location id 58450641063 2025-08-07 06:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:30:14Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 06:30:14 [INFO]: Change: available | Delta: -3 2025-08-07 06:30:14 [INFO]: Change: on_hand | Delta: -3 2025-08-07 06:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44683761 and user_id = 14409 2025-08-07 06:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77588986 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:30:14 [INFO]: Shopify Inventory id 46634170089694 2025-08-07 06:30:14 [INFO]: Shopify Location id 58450641063 2025-08-07 06:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:30:15Z","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-07 06:30:15 [INFO]: Change: available | Delta: -1 2025-08-07 06:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 06:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662424 and user_id = 14409 2025-08-07 06:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567644 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:30:15 [INFO]: updateIdsQuantity -> ["77579185","77588986","77567644"] 2025-08-07 06:30:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 06:30:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77579185 THEN 0 WHEN id = 77588986 THEN 0 WHEN id = 77567644 THEN 0 END, quantityflag = CASE WHEN id = 77579185 THEN 0 WHEN id = 77588986 THEN 0 WHEN id = 77567644 THEN 0 END WHERE user_id = 14409 AND id IN (77579185,77588986,77567644) 2025-08-07 06:30:15 [INFO]: QUANTITY Updated IDs: 77579185, 77588986, 77567644 2025-08-07 06:30:15 [INFO]: Successfully processed data for user 14409 2025-08-07 06:30:15 [INFO]: Execution Started 2025-08-07 06:30:15 [INFO]: Execution Finished 2025-08-07 06:40:01 [INFO]: Execution Started 2025-08-07 06:40:02 [INFO]: old server sucessfully connected 2025-08-07 06:40:02 [INFO]: sqs client sucess created 2025-08-07 06:40:03 [INFO]: Number of messages in the queue: 2 2025-08-07 06:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 06:40:03 [INFO]: item found in queue is 14409 2025-08-07 06:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB5FsBOX/pLuoQKn65Px9Dee9tilN6lAk1U2ugStZYXGYjTfJnOMJO2swlcKuxgVcR8A+EaQSYjbfb+zhyqpKMu9YSfO5vCNNOT/S2teH9jb1ryNYVK+SAlQqqgGBMqPBSxsuXo1TWzw9M9JEXzwVb/v4YXliEUcqmhcdEU+PTr/k0Xt2OByDxurHL9n+BZihfWqYbiTU1vI1Ty/GdHf8LSA0jYHSazQ7k4mi6sj7GWHQb5U6pjpPZmerOKLYlxfHvoM+1o4LgT3QoE38G3AmjVYRJor4tBT2B/9QowIP3JDTBSRBTbl6HjYlogXCOJ1jGrYVZGP+RWXXlXx0GVAKAwm10YLkATe97SNFKwp/ik5T7u6sLM+rfcgS3XUz94vDnMsclGBQhCNoALAuZ5j2jY/pTEuBfPmzGsAzV+f9Dz6JsQEH73eIg6vS/0jsc4Fz0 2025-08-07 06:40:04 [INFO]: item found in queue is if condition 14409 2025-08-07 06:40:04 [INFO]: item found in queue is 14409 2025-08-07 06:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBGcEMUNjGEpTnrARuJ0ytLd+lcJjitPqJa5ilF5F6k7AZx/33DLKj16dfqWGK+QKSkqfdRHUTdMlHaVpAzwGR466HGa+iU6SAbtcyc0xhrNQUgYETtnReHQ7wCFwPG5BaaRv3gVZGuZmJ36fWcNwK+AddPTtMII5ZzrKiIQLlSKT820zca1vzICN60pWsctQ2XEipwlg2Uqb1n+xa5OaL1tgI9o7uhS1iSAZe5vVf+Pi2/UbhvfbQAdCgrbk68dwZH/klKqP39VFlb51DmLTdp0u1aqO/uQDlq2fe7wZwCvw8WHZ6pLct7D9rXdTYQmtPRO19U4oNVFpGPZVEj4It1SDYtuo5FLdrqs8aRpyHWRkPS/QrTyPLWYiVJnIoc/0U855NmOY9xBmAZvFEFomjSUmx7FRiHfFJ3Bd1MlElkwVf5t7CaRv1M0yZ130vL6Rw 2025-08-07 06:40:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 06:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 06:40:04 [INFO]: inside itemsold and closed 14409 2025-08-07 06:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:40:06 [INFO]: Ebay item id :: 224465830228 exists in Database 2025-08-07 06:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:40:06 [INFO]: inside itemsold and closed 14409 2025-08-07 06:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:40:08 [INFO]: Ebay item id :: 325360761129 exists in Database 2025-08-07 06:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:40:08 [INFO]: in processold action queue is array for {"44656038":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656038","ebayitemid":"224465830228","shopifyproductid":"6746924482727","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"6746924482727","shopifyvariantid":"40066670395559","shopifyinventoryid":"42161896194215","shopifylocationid":"","product_id":"44656038","variant_id":"77561227","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44683845":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44683845","ebayitemid":"325360761129","shopifyproductid":"7859721896158","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"7859721896158","shopifyvariantid":"43606547005662","shopifyinventoryid":"45702234243294","shopifylocationid":"","product_id":"44683845","variant_id":"77589070","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 06:40:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 06:40:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:40:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:40:08 [INFO]: Shopify Inventory id 42161896194215 2025-08-07 06:40:08 [INFO]: Shopify Location id 58450641063 2025-08-07 06:40:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:40: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-07 06:40:08 [INFO]: Change: available | Delta: -1 2025-08-07 06:40:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 06:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656038 and user_id = 14409 2025-08-07 06:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561227 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:40:08 [INFO]: Shopify Inventory id 45702234243294 2025-08-07 06:40:08 [INFO]: Shopify Location id 58450641063 2025-08-07 06:40:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:40:08Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 06:40:08 [INFO]: Change: available | Delta: -4 2025-08-07 06:40:08 [INFO]: Change: on_hand | Delta: -4 2025-08-07 06:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44683845 and user_id = 14409 2025-08-07 06:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589070 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:40:08 [INFO]: updateIdsQuantity -> ["77561227","77589070"] 2025-08-07 06:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 06:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561227 THEN 0 WHEN id = 77589070 THEN 0 END, quantityflag = CASE WHEN id = 77561227 THEN 0 WHEN id = 77589070 THEN 0 END WHERE user_id = 14409 AND id IN (77561227,77589070) 2025-08-07 06:40:08 [INFO]: QUANTITY Updated IDs: 77561227, 77589070 2025-08-07 06:40:08 [INFO]: Successfully processed data for user 14409 2025-08-07 06:40:08 [INFO]: Execution Started 2025-08-07 06:40:08 [INFO]: Execution Finished 2025-08-07 06:50:01 [INFO]: Execution Started 2025-08-07 06:50:01 [INFO]: old server sucessfully connected 2025-08-07 06:50:01 [INFO]: sqs client sucess created 2025-08-07 06:50:03 [INFO]: Number of messages in the queue: 4 2025-08-07 06:50:04 [INFO]: item found in queue is if condition 14409 2025-08-07 06:50:04 [INFO]: item found in queue is 14409 2025-08-07 06:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBWwpyjoVsjhCBGnkHEFO2H27qOQYlEZ8O+/8KozETijHWMlp7rvon3dTDfpAnBZ/YbsV/jCdXzARjeu5lLH0rCRab/ZcmFAznSev4lOMLHg34HLHMhs5s7WxX6+IW1rOQP0Hmz5y2TJbCvpaKip1hVv/Bm31lZylm5d9vrJvPusFc3w7hKfX0/kuTc50pJwxLweAjReWFkWb/wnRxpFSNsTHVn5tcz2bGUUKonzqTSo2JFRi/Rs2lQlf2MQTl0mBg8ewm5etCmv+/RgUIKsU5HNdxu7G00wQppoHj24p2UpZ70CzhKUhbhZEaW6HJSRrD1VckYWf914EWjkAXjXFVzdZzI2C7JRsZMlHiRXFQai/Xi9OZLuMVFyFhexwRt1cGdCJm/D814CsqORj7S9izRNEW2zJnp60ZYNc5putfmjyhCpFcrz2IHkOlBrQpm6zY 2025-08-07 06:50:04 [INFO]: item found in queue is if condition 14409 2025-08-07 06:50:04 [INFO]: item found in queue is 14409 2025-08-07 06:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBb7eJZdGTfIEGz36zhNnFlulIrilh8fsAvjPdPqlqe3O9ecMUuYzNsRTnv1DNFsbsGh9yGelZ4wzH39UtDt006SiyQ7PVRvG/Ck8phQZd+pL9RxyPVudgvKhRUvgb1QoIVv1nBZzOQC2tigoG/AFr6/F2CZOGhUkqXQpsjgjHZvU9XU5aj/ktwtIbrZDSjcuKXktsWOBTN8aYY5dUJ6dn4/vOenOxDOdufNER8XYENysbjJ8PIWEK+keIcfiZVdbWN5LXf+8B1WgpiZXU2ouhzarMVTDqujVlI4auM8iljAR+nonvQgBr7v1xOATQch4zwwU7gp8ohUTJEbW5upO9bAhiXcncg47ff4HPYdlaEMpoCiET9OqOwL0x0tbyCSHPyPAH/dpjsKrU6IGBiOBsjkGNHBVEaCh+VWjIhPj1HkL/yVW/6AEHr8hnvgvJpABv 2025-08-07 06:50:05 [INFO]: item found in queue is if condition 14409 2025-08-07 06:50:05 [INFO]: item found in queue is 14409 2025-08-07 06:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBu8iCtmz3XPMTMw2q22H25I5oiB+C7NFlaKx/48juNp3Seyt1lYkxjB6yAE+oAPZ/A8uDfcQ8p9DQH/pzAcCQzmxmxqqSVRwxOmVDin//ffCFvsovV46Ob7ZXMaqhaDKYLGYzBxxphvb2lEWmvXV5pHn/E6lJ64L6YZPMvtmuMkA4pydx9SiM+xAczJCZIyo2Ho93KOtcfPAcTBywJa2u0xav3hlhmeqNgS+3rRr0OlMkWtYbZQNm7ed0LdL20gNi5aIrYcprPjea9eiucnddVXebJh/l7UibWXR0OIzSjzvIMfOftbAJtSXk0yKf2N5qOq/FE92FAA2D5NjsrzGI2expEPwzmA/5Q+4PZJCBBybeX1aUAXD5gUujAGrHZYWUO5jyk7Q07pRY3MQ1FjXVilCXWYKDVCT5vGrGaFMG3/Bz5KZQFJaF28is4gY3IQam 2025-08-07 06:50:06 [INFO]: item found in queue is if condition 14409 2025-08-07 06:50:06 [INFO]: item found in queue is 14409 2025-08-07 06:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBQWlFqEELwvM54IKwZhF6xZN4j9K2wQQMotK+ExuiPY6EVO3Gea+YL9aZnBFO6HAkrrx7EcMe0LIykX7cr+n/9le9nrKNRX4VQfcRxlVIJDYxQ+CxFyhod4dfBDvszH5mXPCEbhrimNIZJEIqZgm3rZKwLhzCJwwjFXtO296qqjaGTI2UpDnhSpZjxd0En3F8IAC2Y9rfyd3/ayH5OBKC7ubg/0ZpRDWBhpCj5vhudJSrR2eYhuXKp6OVWtli93XG5fIHj2Yl0uOKqOHvCOYvfFiv0zjDPJcTO5aDHmLs1X8wZACEWWRrcg0d+hWTlOwm9BswpretODubPwkoHROMAuUU71iuE7s2oS5arsco1q/+tNcWIuCCXiiiHQtAaMYkKj5FDkuxhcgFiwyH3c6MJXU6t+q/+5X39XWJwNKiVifbWiBD3p3fL14o0Ca2IPYi 2025-08-07 06:50:06 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-07 06:50:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 06:50:06 [INFO]: inside itemsold and closed 14409 2025-08-07 06:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:50:08 [INFO]: Ebay item id :: 325640913364 exists in Database 2025-08-07 06:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:50:08 [INFO]: inside itemsold and closed 14409 2025-08-07 06:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:50:10 [INFO]: Ebay item id :: 325399203662 exists in Database 2025-08-07 06:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:50:10 [INFO]: inside itemsold and closed 14409 2025-08-07 06:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:50:12 [INFO]: Ebay item id :: 325399203662 exists in Database 2025-08-07 06:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 06:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 06:50:12 [INFO]: inside itemsold and closed 14409 2025-08-07 06:50:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 06:50:13 [INFO]: autolink for user_id 14409 is 1 2025-08-07 06:50:13 [INFO]: Ebay item id :: 325434372254 exists in Database 2025-08-07 06:50:13 [INFO]: Item is reliested :: exists in Database 2025-08-07 06:50:13 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 06:50:13 [INFO]: in processold action queue is array for {"44712593":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44712593","ebayitemid":"325640913364","shopifyproductid":"8033162133726","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8033162133726","shopifyvariantid":"44174404813022","shopifyinventoryid":"46271414010078","shopifylocationid":"","product_id":"44712593","variant_id":"77620208","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44677851":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677851","ebayitemid":"325399203662","shopifyproductid":"7857244340446","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"7857244340446","shopifyvariantid":"43594900308190","shopifyinventoryid":"45690568900830","shopifylocationid":"","product_id":"44677851","variant_id":"77583071","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45146655":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45146655","ebayitemid":"325434372254","deleted":1}}} 2025-08-07 06:50:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 06:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 06:50:13 [INFO]: productIds WHich are having null productid -> [45146655] 2025-08-07 06:50:13 [INFO]: ebayItemIds WHich are not imported-> ["325434372254"] 2025-08-07 06:50:13 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 06:50:13 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 06:50:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45146655) 2025-08-07 06:50:13 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 06:50:13 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 06:50:13 [INFO]: Transaction committed successfully. 2025-08-07 06:50:13 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 06:50:13 [INFO]: Shopify Inventory id 46271414010078 2025-08-07 06:50:13 [INFO]: Shopify Location id 58450641063 2025-08-07 06:50:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:50:14Z","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-07 06:50:14 [INFO]: Change: available | Delta: -1 2025-08-07 06:50:14 [INFO]: Change: on_hand | Delta: -1 2025-08-07 06:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44712593 and user_id = 14409 2025-08-07 06:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77620208 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:50:14 [INFO]: Shopify Inventory id 45690568900830 2025-08-07 06:50:14 [INFO]: Shopify Location id 58450641063 2025-08-07 06:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 06:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T06:50:14Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 06:50:14 [INFO]: Change: available | Delta: -4 2025-08-07 06:50:14 [INFO]: Change: on_hand | Delta: -4 2025-08-07 06:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 06:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677851 and user_id = 14409 2025-08-07 06:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77583071 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 06:50:14 [INFO]: updateIdsQuantity -> ["77620208","77583071"] 2025-08-07 06:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 06:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77620208 THEN 0 WHEN id = 77583071 THEN 0 END, quantityflag = CASE WHEN id = 77620208 THEN 0 WHEN id = 77583071 THEN 0 END WHERE user_id = 14409 AND id IN (77620208,77583071) 2025-08-07 06:50:14 [INFO]: QUANTITY Updated IDs: 77620208, 77583071 2025-08-07 06:50:14 [INFO]: Successfully processed data for user 14409 2025-08-07 06:50:14 [INFO]: Execution Started 2025-08-07 06:50:14 [INFO]: Execution Finished