2025-08-02 17:00:01 [INFO]: Execution Started
2025-08-02 17:00:01 [INFO]: old server sucessfully connected
2025-08-02 17:00:01 [INFO]: sqs client sucess created
2025-08-02 17:00:03 [INFO]: Number of messages in the queue: 3
2025-08-02 17:00:03 [INFO]: item found in queue is if condition  14409
2025-08-02 17:00:03 [INFO]: item found in queue is  14409
2025-08-02 17:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJJxe2L82rxlP36ybLOYDtNa7bAb+pAgo6oPxO+RjCYDGfa20txGeHKEvovYFNPveyAWePDJguuElK27mnPEssMaHQ4H+SeXo+GwLo6Yx/870yuhPuU/tVRsaVBBaGDjSCDRv6EtUXPBoZWabL6bn+aINoVto4SKzvYsMOr5klVbDFfI0rBkUMRnei6MM+Fv+Y8geY5sgAaG6lsk5ES6ZPfCaW+4uckreUAiWRHkhRumNH4jA2NNxmFJVGR+nIqFQu+iks1nlVwiGuH10xi9eaQ/ZEgYBBchFE8N7Gp2NNP87/nuR4u6iNtdEUr72nMX/o/bs9GAGZr7Nr4h+r3xdo0RwFjRLZ3Hpycv5NPvLB6S1GgJzFpASEMU1CHpGwvy2WlguGDgBn7oQ9w2sLkQZEFpw0RAaDBDNEvyIj5I/imZB/ReZdpEIT6UIZTSoB9XA
2025-08-02 17:00:03 [INFO]: item found in queue is if condition  14409
2025-08-02 17:00:03 [INFO]: item found in queue is  14409
2025-08-02 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBQG+aL1sCG/onScyUBpibc1lIisTEZ8Gv+ag9SnDkH98Fb1uEQgInBKPXyBuPeLI6Wm7ZnRZzlJszueYFKBCpns/5OsCH1zVb6RqYsCzZFvAFIZ0hkS20X59FKKolrter5KonmFnZEyIBynPk80iUCFEXz78Yh2uizLjv2TpSY8fdVkm8bPooo9GzsHcLhhgTTDxRLZ1/yUp7F4JsipO7Pi9FZnBiE9/mENGebkuwLMsGObSXC7zmd8bFg9nuNWm0J/Tyxwv7HUTSkxpsAunLtz2BTS2LVMTLcWK2ixrqltclUmOdj+48JODzI2hNajdryK0gVrzyn537IEjarWya6Edxm8WQl+0wvZao/kfe5kFEkP4+Oc0m6hJeX370O5acuj4DsJFEq2CIlZY9iJwo0JnE6HYaLEQLd+54or/4Lmalsf3NSCk+86PvabXrb8o
2025-08-02 17:00:04 [INFO]: item found in queue is if condition  14409
2025-08-02 17:00:04 [INFO]: item found in queue is  14409
2025-08-02 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBe7a7Kk4LOzukJgHA+QxaY+kJpWXTXw99qg7IYYK608kkxm6Ww6mHPUSV+lbfQPTNNmn+thuDuojI7tz+8qRGcbpW5ENaXxjLodfireFpOoSE7QjaREBAdgGd8ki2pb0xWiFq95R14v/rR2sIXt+TpRZwa+uSxnpkdQ6V/Vl4Bt5D5PNK+yRvlZ9k8r0G5Ynp/0DY3LNaBdpFnAv1obRjMEPS+QGTmz3jTO0ctzxX4y2mzXoaleMjLJC/+pKYu9sYAUNT5L0tF3m0OtW6J5U1quklVkEfKVV/caswCRZ4Q7LqgUruYk/ilDbkIjHys+DUyqn904sB5f8InM6SL8vfX0ByjljpBAiJYAK3ygMU638JS/6KTHG3lajc4qcRRh5N5hXY3s2NxxSxygoK05A9EmFKN7PxHhJauJSG8j+yYkLtt3Rv98PKIK89qCb+Q/QN
2025-08-02 17:00:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-02 17:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-02 17:00:04 [INFO]: inside itemsold and closed 14409
2025-08-02 17:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:00:06 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:00:06 [INFO]: Ebay item id :: 336074282662 exists in Database
2025-08-02 17:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:00:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-02 17:00:06 [INFO]: inside itemsold and closed 14409
2025-08-02 17:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:00:08 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:00:08 [INFO]: Ebay item id :: 286553679045 exists in Database
2025-08-02 17:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 17:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 17:00:08 [INFO]: inside itemsold and closed 14409
2025-08-02 17:00:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:00:09 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:00:09 [INFO]: Ebay item id :: 284530134545 exists in Database
2025-08-02 17:00:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 17:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 17:00:09 [INFO]: in processold action queue is array    for {"45256428":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45256428","ebayitemid":"336074282662","deleted":1}},"44554710":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554710","ebayitemid":"286553679045","shopifyproductid":"8695015768286","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"8695015768286","shopifyvariantid":"45933778436318","shopifyinventoryid":"48032229851358","shopifylocationid":"","product_id":"44554710","variant_id":"77447390","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44646083":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44646083","ebayitemid":"284530134545","shopifyproductid":"7448530682078","variants":[{"price":"9.99","quantity":0,"weight":"0","shopifyproductid":"7448530682078","shopifyvariantid":"42060807864542","shopifyinventoryid":"44154772422878","shopifylocationid":"","product_id":"44646083","variant_id":"77551272","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-02 17:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-02 17:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 17:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 17:00:10 [INFO]: productIds WHich are having null productid -> [45256428]
2025-08-02 17:00:10 [INFO]: ebayItemIds WHich are not imported-> ["336074282662"]
2025-08-02 17:00:10 [INFO]: Entered in bulkUpdateProducts function
2025-08-02 17:00:10 [INFO]: Transaction started for bulkUpdateProducts
2025-08-02 17:00:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45256428)
2025-08-02 17:00:10 [INFO]: Query executed successfully. Affected rows: 0
2025-08-02 17:00:10 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-02 17:00:10 [INFO]: Transaction committed successfully.
2025-08-02 17:00:10 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-02 17:00:10 [INFO]: Shopify Inventory id 48032229851358
2025-08-02 17:00:10 [INFO]: Shopify Location id 58450641063
2025-08-02 17:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 17:00: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-02 17:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 17:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554710 and user_id = 14409 
2025-08-02 17:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447390 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 17:00:10 [INFO]: Shopify Inventory id 44154772422878
2025-08-02 17:00:10 [INFO]: Shopify Location id 58450641063
2025-08-02 17:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 17:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T17:00: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-02 17:00:10 [INFO]: Change: available | Delta: -1
2025-08-02 17:00:10 [INFO]: Change: on_hand | Delta: -1
2025-08-02 17:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 17:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44646083 and user_id = 14409 
2025-08-02 17:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77551272 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 17:00:10 [INFO]: updateIdsQuantity -> ["77447390","77551272"]
2025-08-02 17:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 1
2025-08-02 17:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77447390 THEN 0 WHEN id = 77551272 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77447390 THEN 0 WHEN id = 77551272 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77447390,77551272)
2025-08-02 17:00:10 [INFO]: QUANTITY Updated IDs: 77447390, 77551272
2025-08-02 17:00:10 [INFO]: Successfully processed data for user 14409
2025-08-02 17:00:10 [INFO]: Execution Started
2025-08-02 17:00:10 [INFO]: Execution Finished
2025-08-02 17:10:01 [INFO]: Execution Started
2025-08-02 17:10:01 [INFO]: old server sucessfully connected
2025-08-02 17:10:01 [INFO]: sqs client sucess created
2025-08-02 17:10:02 [INFO]: Number of messages in the queue: 0
2025-08-02 17:10:22 [INFO]: Execution Started
2025-08-02 17:10:22 [INFO]: Execution Finished
2025-08-02 17:20:01 [INFO]: Execution Started
2025-08-02 17:20:01 [INFO]: old server sucessfully connected
2025-08-02 17:20:01 [INFO]: sqs client sucess created
2025-08-02 17:20:02 [INFO]: Number of messages in the queue: 0
2025-08-02 17:20:22 [INFO]: Execution Started
2025-08-02 17:20:22 [INFO]: Execution Finished
2025-08-02 17:30:01 [INFO]: Execution Started
2025-08-02 17:30:01 [INFO]: old server sucessfully connected
2025-08-02 17:30:01 [INFO]: sqs client sucess created
2025-08-02 17:30:02 [INFO]: Number of messages in the queue: 3
2025-08-02 17:30:03 [INFO]: item found in queue is if condition  14409
2025-08-02 17:30:03 [INFO]: item found in queue is  14409
2025-08-02 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBW4NregDidgnYJtzI5JICJJmwKm/KBQm19xel2uNNw4yd3KBrCs1Kna28KISJuRFV4a+gdydfdC5G+9KDohsb88R8NEn89qrTtZxLbaNAGRcwfJUgtE2P9a9kKKnAcyh7KgPYyVEDyqU/k0tPjVb3pwYma9Yx5ripVOIfBU+cpXuqHkRCJCS4ZrClCK3BUGRkP/JeO4Xvwlk9gn9RE1kJLTbY/y9Wj2rB8/R8VC9NvuNajeoUhkazaYa5xnfGmTVjkstlPNZYvgy02zsmxJjIX2sDSyNHoicBXPbQF+0g0stvAp3GKZ6ZcVP0h9hpjwWBTw9o+ZmbNDpat/EJHE1YrvuiE0PB4ZWtLflbJRvQ160yqJPCboeXgGDhTyb0wBur7sW/EICPZ0e71DyN0t19DJyKMvYGwLVsrJ4CBvHETQaLrujqprVXLOiNr4rbtWhB
2025-08-02 17:30:03 [INFO]: item found in queue is if condition  14409
2025-08-02 17:30:03 [INFO]: item found in queue is  14409
2025-08-02 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBrl3bc361xMvkKiJOfTZ4FIiY/H+gWUxm9KEQlNoueG22Qhmit4rLbd9fKypuuIHMEC9CCBoqX8dnjEVPC2/yilxia1pw/iR0Vi4Q9cjEsyOSZdzhADdBXtU07RSwkPkklK21GnqupnEeB71mUjfge+wsKpEIeGDwleH08jhQ3z5st466eSdD0W9ivIFDiy4L4/QfjgIuZ0OPN4VnzyCvoD5+9YOmS3QXlb3ecI1oTrKfgv+v/bp53Xb8oPluc4aix2aQibRkF9iPp9hbg/Eeb4WNYCp17TMpmEk5YdOigfh+rIw1jlSyqukQ2qjAgL3/PHfMPF7P6D5vWf+YAAGG2733Dql0VuJMgtYknwiN/vqVGUrV+wZwJFgSRXl+qS29l37p8M1E/8kxnWLrKZr1IC+6Ele7J85H6Dwq9/YvkluOo1nZJQ41BNHMDYgpboNs
2025-08-02 17:30:04 [INFO]: item found in queue is if condition  14409
2025-08-02 17:30:04 [INFO]: item found in queue is  14409
2025-08-02 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBOqc2jpoMoMtuGPz/0DE7/A8qSrqlAmWd1J3nFJfGBKKtcrCL7NA5c4S9Alijfsph3rC2NMJzT132j4/IKiGzFrQ6+GRzvyHPtQQjcKd7zFjcEWgvvlIswxoYv7Z4k1jcT9o5GC6WzSlRB4LLVAhwtIi9Gz/irUmzBuKCDoKk8jS8SVO9vMzg0r2Xwt885xSvg1C/UxO0sjHBg+weE/7i3XLj2Ba0bZ35n19x4v/OwpPZYz6CsIc6SR2u/ZSswio5cSq6dkBB8GTolHVNDbeMOaK569aY7BHYFq4kO5J4alV2rP2/u03F7+Ziv+pSXkN8iGgzha7RodKZxdu3uIvh45HwIwWGdUctlsWRfVFe1aGBr4WltGVGaO+XnWm8UvAaSxZQugI1WNPFnkbSZMU7MNkETCPIePh8pLOgRbEfLgb5RiRav4gNca2CB8LaUwul
2025-08-02 17:30:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-02 17:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-02 17:30:04 [INFO]: inside itemsold and closed 14409
2025-08-02 17:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:30:06 [INFO]: Ebay item id :: 225061684923 exists in Database
2025-08-02 17:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 17:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 17:30:06 [INFO]: inside itemsold and closed 14409
2025-08-02 17:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:30:07 [INFO]: Ebay item id :: 286520155195 exists in Database
2025-08-02 17:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 17:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 17:30:07 [INFO]: inside itemsold and closed 14409
2025-08-02 17:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:30:09 [INFO]: Ebay item id :: 336053224913 exists in Database
2025-08-02 17:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:30:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-02 17:30:09 [INFO]: in processold action queue is array    for {"44731855":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731855","ebayitemid":"225061684923","shopifyproductid":"7715213148382","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7715213148382","shopifyvariantid":"43064901402846","shopifyinventoryid":"45160236220638","shopifylocationid":"","product_id":"44731855","variant_id":"77639740","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44679292":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44679292","ebayitemid":"286520155195","shopifyproductid":"8246704963806","variants":[{"price":"33.99","quantity":0,"weight":"2","shopifyproductid":"8246704963806","shopifyvariantid":"44641995260126","shopifyinventoryid":"46739978977502","shopifylocationid":"","product_id":"44679292","variant_id":"77584512","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45196329":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45196329","ebayitemid":"336053224913","deleted":1}}}
2025-08-02 17:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-02 17:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 17:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 17:30:09 [INFO]: productIds WHich are having null productid -> [45196329]
2025-08-02 17:30:09 [INFO]: ebayItemIds WHich are not imported-> ["336053224913"]
2025-08-02 17:30:09 [INFO]: Entered in bulkUpdateProducts function
2025-08-02 17:30:09 [INFO]: Transaction started for bulkUpdateProducts
2025-08-02 17:30:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45196329)
2025-08-02 17:30:09 [INFO]: Query executed successfully. Affected rows: 0
2025-08-02 17:30:09 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-02 17:30:09 [INFO]: Transaction committed successfully.
2025-08-02 17:30:09 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-02 17:30:09 [INFO]: Shopify Inventory id 45160236220638
2025-08-02 17:30:09 [INFO]: Shopify Location id 58450641063
2025-08-02 17:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 17:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T17:30:09Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-02 17:30:09 [INFO]: Change: available | Delta: -1
2025-08-02 17:30:09 [INFO]: Change: on_hand | Delta: -1
2025-08-02 17:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 17:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731855 and user_id = 14409 
2025-08-02 17:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639740 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 17:30:09 [INFO]: Shopify Inventory id 46739978977502
2025-08-02 17:30:09 [INFO]: Shopify Location id 58450641063
2025-08-02 17:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 17:30: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-02 17:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 17:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44679292 and user_id = 14409 
2025-08-02 17:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77584512 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 17:30:10 [INFO]: updateIdsQuantity -> ["77639740","77584512"]
2025-08-02 17:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-02 17:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77639740 THEN 0 WHEN id = 77584512 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77639740 THEN 0 WHEN id = 77584512 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77639740,77584512)
2025-08-02 17:30:10 [INFO]: QUANTITY Updated IDs: 77639740, 77584512
2025-08-02 17:30:10 [INFO]: Successfully processed data for user 14409
2025-08-02 17:30:10 [INFO]: Execution Started
2025-08-02 17:30:10 [INFO]: Execution Finished
2025-08-02 17:40:01 [INFO]: Execution Started
2025-08-02 17:40:01 [INFO]: old server sucessfully connected
2025-08-02 17:40:01 [INFO]: sqs client sucess created
2025-08-02 17:40:02 [INFO]: Number of messages in the queue: 0
2025-08-02 17:40:22 [INFO]: Execution Started
2025-08-02 17:40:22 [INFO]: Execution Finished
2025-08-02 17:50:02 [INFO]: Execution Started
2025-08-02 17:50:02 [INFO]: old server sucessfully connected
2025-08-02 17:50:02 [INFO]: sqs client sucess created
2025-08-02 17:50:03 [INFO]: Number of messages in the queue: 1
2025-08-02 17:50:03 [INFO]: item found in queue is if condition  14409
2025-08-02 17:50:03 [INFO]: item found in queue is  14409
2025-08-02 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBVpqXNoS+aRC3ycs8WgxBY0a8ooXY9cM5UZS0yRXzlNHIspEngcDA2px1IkBFaMok9KTbYn3LAJt2eaEC6tvGWKxAJRkvVJ5ylcpBZl/z+ek52YqMBjLnv8+XEwvmjDz6LfdCArVwcrv+6gGt1rl4sDXtpSBBrOXKqhMZNGhO01CDsD3cLc0THno+UwQtwzCmtq8Gcpz6Yoa1D8gGa9Z9oXB7ByMwmbZG7yYjqRfuKPSnZFesIQnr7972OD4BIAM35U+JyEOC5CKREC9SFDGTBrVRyinUSo2QovJpMoQs/dvsE9QuxPAXpFXfan6yh0+OQDx4B+Fa4y0T+4Iz9Q7aV1K9k2lexL6dAybPWiZONuJebA49IwI09ijAuIgp728ubHHJv/RTnp3dYMYWwyZ8MvfqpUTwYvq+M4XbAK5JDdKBe4ckXSVcnXxUO7xOp4kt
2025-08-02 17:50:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-02 17:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-02 17:50:03 [INFO]: inside itemsold and closed 14409
2025-08-02 17:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-02 17:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-02 17:50:05 [INFO]: Ebay item id :: 405862656158 exists in Database
2025-08-02 17:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-02 17:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-02 17:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-02 17:50:05 [INFO]: in processold action queue is array    for {"44894856":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44894856","ebayitemid":"405862656158","shopifyproductid":"8929187397854","variants":[{"price":"13.99","quantity":0,"weight":"0.5","shopifyproductid":"8929187397854","shopifyvariantid":"46853306417374","shopifyinventoryid":"48964743889118","shopifylocationid":"58450641063","product_id":"44894856","variant_id":"77812007","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-02 17:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-02 17:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-02 17:50:05 [INFO]: Shopify Inventory id 48964743889118
2025-08-02 17:50:05 [INFO]: Shopify Location id 58450641063
2025-08-02 17:50:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-02 17:50: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-02 17:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-02 17:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44894856 and user_id = 14409 
2025-08-02 17:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77812007 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-02 17:50:05 [INFO]: updateIdsQuantity -> ["77812007"]
2025-08-02 17:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-02 17:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77812007 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77812007 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77812007)
2025-08-02 17:50:05 [INFO]: QUANTITY Updated IDs: 77812007
2025-08-02 17:50:05 [INFO]: Successfully processed data for user 14409
2025-08-02 17:50:05 [INFO]: Execution Started
2025-08-02 17:50:05 [INFO]: Execution Finished