2025-08-07 19:00:02 [INFO]: Execution Started 2025-08-07 19:00:02 [INFO]: old server sucessfully connected 2025-08-07 19:00:02 [INFO]: sqs client sucess created 2025-08-07 19:00:03 [INFO]: Number of messages in the queue: 0 2025-08-07 19:00:23 [INFO]: Execution Started 2025-08-07 19:00:23 [INFO]: Execution Finished 2025-08-07 19:10:01 [INFO]: Execution Started 2025-08-07 19:10:01 [INFO]: old server sucessfully connected 2025-08-07 19:10:01 [INFO]: sqs client sucess created 2025-08-07 19:10:02 [INFO]: Number of messages in the queue: 1 2025-08-07 19:10:02 [INFO]: item found in queue is if condition 14409 2025-08-07 19:10:02 [INFO]: item found in queue is 14409 2025-08-07 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBfjPyglAcG35bcqIjwhlbWUAVE9gMG40cse21YwucKzNL2xtKSIZpMT1l1zIn23xCg4ftd32TXIGiW+W23o1Mj37JrByCqc7bh5GAXoVpmE/EfyX0H01lW9n7RLbtCIEu6FkK0bJXIHFTi4TBekoYZHNO1+HrIwoInCbtPT21/8wFrjxp9teJzufRawIoCqfaY3qbqozHo7UrRawu2tEHJMr1e7IplrS1jTUl0kK8NiZda66NFrHx5y8hximKm0oOZkUq2XgL54Xyr0HmxbiUGH3XpztPm7XfmyaieiAd0lUTN49qWcN5L6V4rsvzBJ7pbGK56hG21gejEB5HZY4YImgYnaGaB3RS2AZ4ekmax/gLqPqA+NptcdtmpRXTtXB8/JDKSKDvTYQtsBQVYU2mRPS4YjW1aYuJ8tkfMgdtf0KNh7VGhum933toGrjeUW06 2025-08-07 19:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 19:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 19:10:03 [INFO]: inside itemsold and closed 14409 2025-08-07 19:10:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:10:04 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:10:04 [INFO]: Ebay item id :: 325452898746 exists in Database 2025-08-07 19:10:04 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 19:10:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 19:10:04 [INFO]: in processold action queue is array for {"44732542":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44732542","ebayitemid":"325452898746","shopifyproductid":"7955782271198","variants":[{"price":"14.99","quantity":0,"weight":"0.5","shopifyproductid":"7955782271198","shopifyvariantid":"43996600664286","shopifyinventoryid":"46093122109662","shopifylocationid":"","product_id":"44732542","variant_id":"77640427","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 19:10:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 19:10:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 19:10:04 [INFO]: Shopify Inventory id 46093122109662 2025-08-07 19:10:04 [INFO]: Shopify Location id 58450641063 2025-08-07 19:10:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 19:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T19: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-07 19:10:05 [INFO]: Change: available | Delta: -1 2025-08-07 19:10:05 [INFO]: Change: on_hand | Delta: -1 2025-08-07 19:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 19:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44732542 and user_id = 14409 2025-08-07 19:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77640427 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 19:10:05 [INFO]: updateIdsQuantity -> ["77640427"] 2025-08-07 19:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 19:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77640427 THEN 0 END, quantityflag = CASE WHEN id = 77640427 THEN 0 END WHERE user_id = 14409 AND id IN (77640427) 2025-08-07 19:10:05 [INFO]: QUANTITY Updated IDs: 77640427 2025-08-07 19:10:05 [INFO]: Successfully processed data for user 14409 2025-08-07 19:10:05 [INFO]: Execution Started 2025-08-07 19:10:05 [INFO]: Execution Finished 2025-08-07 19:20:02 [INFO]: Execution Started 2025-08-07 19:20:02 [INFO]: old server sucessfully connected 2025-08-07 19:20:02 [INFO]: sqs client sucess created 2025-08-07 19:20:03 [INFO]: Number of messages in the queue: 1 2025-08-07 19:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 19:20:03 [INFO]: item found in queue is 14409 2025-08-07 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBUAQZGyme2SikhjXs4d4n6s6GDUGt6Z7ytEeBADfA19I5iNQBgyG+uxQxbn0BmybzWdyJvkcyWX1h6bvzbmF0sxEtfWckhI6L1ZfnsPk/nujla/u4aIFX18afoPzsQWEjfKEBCDmfmv50og6huegbkHFd0csSm6N8nsz3Q+FhLj7SiMWdYnixSPVr4vXZzzfhEiu+Auopz6RppSpbSKTCuh2Kj4QOtLzWe96TxuKMLxvlIma48odleFAUz/yu/eeKNo/S2cjGg5qwOQ7q0GfVZZiaInkl8klYuDxtbCB+K9+kAZOfu/y2J8xFVge0HFuy7/kfLxROO6iiNaLMhb7kgw50ToaNYzKJ38Dn1cd6rCC2oCpum9a0IE9hBAJKYEjf3ouIdM9ELlhwdQxYrrnHMIMIJE9X8+Ku+vCKqbb81Minj0PwA95/FBpIEkD27sRg 2025-08-07 19:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 19:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 19:20:03 [INFO]: inside itemsold and closed 14409 2025-08-07 19:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:20:05 [INFO]: Ebay item id :: 336065796290 exists in Database 2025-08-07 19:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 19:20:05 [INFO]: in processold action queue is array for {"45221242":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45221242","ebayitemid":"336065796290","deleted":1}}} 2025-08-07 19:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 19:20:05 [INFO]: productIds WHich are having null productid -> [45221242] 2025-08-07 19:20:05 [INFO]: ebayItemIds WHich are not imported-> ["336065796290"] 2025-08-07 19:20:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 19:20:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 19:20:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45221242) 2025-08-07 19:20:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 19:20:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 19:20:05 [INFO]: Transaction committed successfully. 2025-08-07 19:20:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 19:20:05 [INFO]: Successfully processed data for user 14409 2025-08-07 19:20:05 [INFO]: Execution Started 2025-08-07 19:20:05 [INFO]: Execution Finished 2025-08-07 19:30:01 [INFO]: Execution Started 2025-08-07 19:30:01 [INFO]: old server sucessfully connected 2025-08-07 19:30:01 [INFO]: sqs client sucess created 2025-08-07 19:30:03 [INFO]: Number of messages in the queue: 4 2025-08-07 19:30:03 [INFO]: item found in queue is if condition 14409 2025-08-07 19:30:03 [INFO]: item found in queue is 14409 2025-08-07 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBns0wTdjPq6hLI6ygURwafpPqD03IM/D+jwSqebmh+YDab18crkNuY2jyftLclwPEqdG+x8Vc23mE9YFNrnP6SP2a32VAPBm0FhiUi0C4FxUkvtuNeYMzfQS2i1NgKzY/rgWMUUCjHGTpiQx/8UYZzfZnDyy/FFs27BxtjDRtpnMRllpjW2twZtzwPhb1mTSdGKwU32maLsJxGBQVXY0sAO5VxB6yeXKnyuUBcvEq5oEZMi289OyIWjqwFRDjfa4hCottN3SK8jEEQQ6usP4azyV7mTh5hDNjdeUkJWj31bnQhEpjYBWeNA4wUvROgVDs5F2+1KCLBUKc0ACQoEGXQIhynMVHPA/UXVkIG0lGcdk73We1VL7SaSDobCA/qpnfKVYRgQK1X8NtYDfxFME0PuzCmSX4cWM1YnfyC56CQpbAH2jmalqyNa/APHV/fzs/ 2025-08-07 19:30:04 [INFO]: item found in queue is if condition 14409 2025-08-07 19:30:04 [INFO]: item found in queue is 14409 2025-08-07 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBbhxa5Njb1tZEPvy8JEFYVAzmcX9ruVnXE3Jd6FiRgSUKaltuGc1qgUdCc1NzuMncJR2HbzYlKd0oUYC+gDrViV+CfpwI4bmst9vGviqAxWYYbJesH/i+1MpvM5Hc0TMATJA8JNe6oRX/uzAV8YNGYML601CA5StLhxxns9R8/QB2ItNz/PkHhjGkdNj8RE4kaHybjLpxVtd5183fOXASCUHo3DzmZgmCEXsFYlat6OtrzXUbBN0rgB6KR5Ot5UKkyKKxVhRKe9JbuxEWMWcYMZgl7TILCur6IncSlT3j38aBUHbT1/2vZeObjhtRmdNgTAKhAgBbrqQWp/dLIUWhYC39Ru2tSh9saeIx1gXAr5CJ3+rmOTM8dYqo65kSCC4Zf571DHaHtmU/b2QXc3P0GKsE1QbmRZZDL6JK3agyx6bfh5OpzqQ7PvqdJ26SklIr 2025-08-07 19:30:04 [INFO]: item found in queue is if condition 14409 2025-08-07 19:30:04 [INFO]: item found in queue is 14409 2025-08-07 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBS6oTMSLM8BU2pDK0fKVSxzD20QgNWs/VcEN/zT+A5Sp6UjTnzOhtivAIyoqq/CFxMdplPqMpAqEu4toZ9Aw6s3YUQ/F39Z1L8jCwsYQgS3T1dBEhDs/W7pAJXGWtLKri610w/h57R+5UZLCcXx81YpJccG/6upLdJ9ykpp17K/qvggpEQXD9aFlnSASe8tFh8TQZ3sqbiCPZJP/UFYEjsVscM2BPoCqpvwpL77kbr6dgooyM80uwlj7rb92MIOcZwl6sm9Kp4eREWh47DoK1MwNx0Yt6TFEfOC50eUTwNoM8Mcl+bPOMeXoRlKTHqLRwzysay58eI+nSQVu0/rt2FCcgvAp/fXedG+WkFveRysHqB8LCtUAJNFcw79r/8T2xSAnnB1KjLir4VmH8x9/pCsf4vmlXNSac3APq1j30ic4Kr5DdHS7rv3f5Bm+Ki74S 2025-08-07 19:30:04 [INFO]: item found in queue is if condition 14409 2025-08-07 19:30:04 [INFO]: item found in queue is 14409 2025-08-07 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBWqCW6dHs+Ho/3bFPDS60vV5V03WKKBIGtDxU0gWVyViV/xNbj8eLMSPs4EH5jTBxDjrSs8hX1duN1iD1ZmTqBIBkz2PnuzckHf+7q+Kzxp+1A/S/rk85yje1hM8sulFQVlXoIyRXj9eatLQnNAJ4aNIh1UGSnfvbHeot4IJZZ9+ZUlpitFl/u/Ob0oYajHzWUeK4w8SYH7uwrO6/BvwRwCYZBmHieFzi7z8SKoypAwF/f5Ic1a6i0uZopEtkTgsxi8s62/AcVYot6roWpVpBX+ekSSz8GHOZxazg4TrPHiaxHxZ5lI0B8RViOcBeekr4K8C9A5q6m2/bBp14jrPX/nC3hBQ0hCRFOlOZ9Qg3IshHg2jAFkvc2oFeuxzdZsom3fdyNPCkEeMJm2rA0yc+L0Gtt3gmBZJhRdqmcBq0eIn+yVQxcF8jFO7sqyTuUnuE 2025-08-07 19:30:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-07 19:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 19:30:04 [INFO]: inside itemsold and closed 14409 2025-08-07 19:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:30:06 [INFO]: Ebay item id :: 326720154707 exists in Database 2025-08-07 19:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 19:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 19:30:06 [INFO]: inside itemsold and closed 14409 2025-08-07 19:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:30:08 [INFO]: Ebay item id :: 306436793212 exists in Database 2025-08-07 19:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:30:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 19:30:08 [INFO]: inside itemsold and closed 14409 2025-08-07 19:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:30:10 [INFO]: Ebay item id :: 226464943562 exists in Database 2025-08-07 19:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 19:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 19:30:10 [INFO]: inside itemsold and closed 14409 2025-08-07 19:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:30:12 [INFO]: Ebay item id :: 286129232962 exists in Database 2025-08-07 19:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 19:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 19:30:12 [INFO]: in processold action queue is array for {"45313512":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313512","ebayitemid":"326720154707","shopifyproductid":"8982122528990","variants":[{"price":"74.99","quantity":0,"weight":"2","shopifyproductid":"8982122528990","shopifyvariantid":"47386612302046","shopifyinventoryid":"49498432766174","shopifylocationid":"58450641063","product_id":"45313512","variant_id":"78266025","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45115817":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115817","ebayitemid":"306436793212","deleted":1}},"44673909":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673909","ebayitemid":"226464943562","shopifyproductid":"8746137977054","variants":[{"price":"174.99","quantity":0,"weight":"2","shopifyproductid":"8746137977054","shopifyvariantid":"46103716364510","shopifyinventoryid":"48202595041502","shopifylocationid":"","product_id":"44673909","variant_id":"77579129","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44682650":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682650","ebayitemid":"286129232962","shopifyproductid":"8717488095454","variants":[{"price":"289.99","quantity":0,"weight":"4","shopifyproductid":"8717488095454","shopifyvariantid":"45987639886046","shopifyinventoryid":"48086400991454","shopifylocationid":"","product_id":"44682650","variant_id":"77587875","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 19:30:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 19:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 19:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 19:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 19:30:12 [INFO]: productIds WHich are having null productid -> [45115817] 2025-08-07 19:30:12 [INFO]: ebayItemIds WHich are not imported-> ["306436793212"] 2025-08-07 19:30:12 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 19:30:12 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 19:30:12 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115817) 2025-08-07 19:30:12 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 19:30:12 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 19:30:12 [INFO]: Transaction committed successfully. 2025-08-07 19:30:12 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 19:30:12 [INFO]: Shopify Inventory id 49498432766174 2025-08-07 19:30:12 [INFO]: Shopify Location id 58450641063 2025-08-07 19:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 19:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T19:30: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 19:30:12 [INFO]: Change: available | Delta: -1 2025-08-07 19:30:12 [INFO]: Change: on_hand | Delta: -1 2025-08-07 19:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 19:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313512 and user_id = 14409 2025-08-07 19:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266025 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 19:30:12 [INFO]: Shopify Inventory id 48202595041502 2025-08-07 19:30:12 [INFO]: Shopify Location id 58450641063 2025-08-07 19:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 19:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T19:30: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 19:30:12 [INFO]: Change: available | Delta: -1 2025-08-07 19:30:12 [INFO]: Change: on_hand | Delta: -1 2025-08-07 19:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 19:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673909 and user_id = 14409 2025-08-07 19:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579129 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 19:30:12 [INFO]: Shopify Inventory id 48086400991454 2025-08-07 19:30:12 [INFO]: Shopify Location id 58450641063 2025-08-07 19:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 19:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T19:30:13Z","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 19:30:13 [INFO]: Change: available | Delta: -1 2025-08-07 19:30:13 [INFO]: Change: on_hand | Delta: -1 2025-08-07 19:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 19:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682650 and user_id = 14409 2025-08-07 19:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77587875 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 19:30:13 [INFO]: updateIdsQuantity -> ["78266025","77579129","77587875"] 2025-08-07 19:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 19:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266025 THEN 0 WHEN id = 77579129 THEN 0 WHEN id = 77587875 THEN 0 END, quantityflag = CASE WHEN id = 78266025 THEN 0 WHEN id = 77579129 THEN 0 WHEN id = 77587875 THEN 0 END WHERE user_id = 14409 AND id IN (78266025,77579129,77587875) 2025-08-07 19:30:13 [INFO]: QUANTITY Updated IDs: 78266025, 77579129, 77587875 2025-08-07 19:30:13 [INFO]: Successfully processed data for user 14409 2025-08-07 19:30:13 [INFO]: Execution Started 2025-08-07 19:30:13 [INFO]: Execution Finished 2025-08-07 19:40:01 [INFO]: Execution Started 2025-08-07 19:40:01 [INFO]: old server sucessfully connected 2025-08-07 19:40:01 [INFO]: sqs client sucess created 2025-08-07 19:40:02 [INFO]: Number of messages in the queue: 0 2025-08-07 19:40:22 [INFO]: Execution Started 2025-08-07 19:40:22 [INFO]: Execution Finished 2025-08-07 19:50:01 [INFO]: Execution Started 2025-08-07 19:50:01 [INFO]: old server sucessfully connected 2025-08-07 19:50:01 [INFO]: sqs client sucess created 2025-08-07 19:50:02 [INFO]: Number of messages in the queue: 1 2025-08-07 19:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 19:50:03 [INFO]: item found in queue is 14409 2025-08-07 19:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBinPUqDgDchLRX/7ssnenDTyDoWGhF93aFDOzldVy91CcphEfm0uUryXW2a4jxD6l95tyBrSAOG7txnAVdK2DFZW7xv8Z27+EgjabrLN2rCiDATbsMdawUcpQY6vQQO+wE3jpFrB9w+vA3uB056jtypfDQS5uVel1Kohn09bQVHqXd6wmZJ6x+r+a7MvHqfrntjz6aSDx6hYSamH26rGxi2h0fuxBZZp/h/sEaNNSWyi68+nO6jncEAY8UsFo4H/fa/wYIMo0j5Mjjm8QaF/ljxHvPE9Q2Ho48wq4Z6u6F9WZGkSqS0DiQohWeXruSrgTQQcDIEBt6Xm7fo+b3MP9rPbJO767U8I8pIrmHJB6e9l85Hqwlitnd/dBzf4U2QE3NMAOmFv6L924aaPPZQ0IvqRRMf31dRi5MTWPv+DqUvyag/+6f43HbY2vNZzgKl+h 2025-08-07 19:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 19:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 19:50:03 [INFO]: inside itemsold and closed 14409 2025-08-07 19:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 19:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 19:50:05 [INFO]: Ebay item id :: 257052993662 exists in Database 2025-08-07 19:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 19:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 19:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 19:50:05 [INFO]: in processold action queue is array for {"45313487":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313487","ebayitemid":"257052993662","shopifyproductid":"8981497315550","variants":[{"price":"77.99","quantity":0,"weight":"0.5","shopifyproductid":"8981497315550","shopifyvariantid":"47347014369502","shopifyinventoryid":"49458810093790","shopifylocationid":"58450641063","product_id":"45313487","variant_id":"78266000","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 19:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 19:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 19:50:05 [INFO]: Shopify Inventory id 49458810093790 2025-08-07 19:50:05 [INFO]: Shopify Location id 58450641063 2025-08-07 19:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 19:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T19: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-07 19:50:05 [INFO]: Change: available | Delta: -1 2025-08-07 19:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-07 19:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 19:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313487 and user_id = 14409 2025-08-07 19:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266000 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 19:50:05 [INFO]: updateIdsQuantity -> ["78266000"] 2025-08-07 19:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 19:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266000 THEN 0 END, quantityflag = CASE WHEN id = 78266000 THEN 0 END WHERE user_id = 14409 AND id IN (78266000) 2025-08-07 19:50:05 [INFO]: QUANTITY Updated IDs: 78266000 2025-08-07 19:50:05 [INFO]: Successfully processed data for user 14409 2025-08-07 19:50:05 [INFO]: Execution Started 2025-08-07 19:50:05 [INFO]: Execution Finished