2025-08-01 14:00:01 [INFO]: Execution Started
2025-08-01 14:00:01 [INFO]: old server sucessfully connected
2025-08-01 14:00:01 [INFO]: sqs client sucess created
2025-08-01 14:00:03 [INFO]: Number of messages in the queue: 0
2025-08-01 14:00:23 [INFO]: Execution Started
2025-08-01 14:00:23 [INFO]: Execution Finished
2025-08-01 14:10:01 [INFO]: Execution Started
2025-08-01 14:10:01 [INFO]: old server sucessfully connected
2025-08-01 14:10:01 [INFO]: sqs client sucess created
2025-08-01 14:10:03 [INFO]: Number of messages in the queue: 1
2025-08-01 14:10:03 [INFO]: item found in queue is if condition  14409
2025-08-01 14:10:03 [INFO]: item found in queue is  14409
2025-08-01 14:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBKljtSLnfrHQII68oiQEtY/WXzj27WQYaL6m8RWJ/wdEAoIi3Z/ycnM98KcUTchRH86G3Kraw3LpOhzo2/W8JbgmH12GyzM9QhchPPrltJA76D0k2XOIfeXRwE53cVK/yHxQBkakV2u+gPnEA5M9VWnuFOWiDfQsIlDAlikbzU7Dpy9dGNKb8fS5UOCEAM9WZ+ts+C8W7B7Z9JjOxgsqXD4WA8t9OwmrLrCJRj/VmjqY0AHKMqY5wFRj3JUquZ9f+APDhUDu9vuc0M18XrbOqO44Q/PQ2fQXX7OfUnppa6Rn5iB+EQd3feCwKvSiROTgP/QR3sp9cDu6bbg5g4weWzkzSlW812upLDh5mOjOD3Hlx9Ej0DppPGgVNBZsErCc+2ggVIWdga5ampeOOGNQtP9CyvaAEzoxzjY/ojjxr+5aNmnK3slO82SqBXu2M2Mnn
2025-08-01 14:10:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-01 14:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 14:10:04 [INFO]: inside itemsold and closed 14409
2025-08-01 14:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 14:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-01 14:10:05 [INFO]: Ebay item id :: 326238723311 exists in Database
2025-08-01 14:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 14:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 14:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 14:10:05 [INFO]: in processold action queue is array    for {"44660197":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44660197","ebayitemid":"326238723311","shopifyproductid":"8708434854110","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8708434854110","shopifyvariantid":"45966856814814","shopifyinventoryid":"48065601208542","shopifylocationid":"","product_id":"44660197","variant_id":"77565417","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 14:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 14:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 14:10:05 [INFO]: Shopify Inventory id 48065601208542
2025-08-01 14:10:05 [INFO]: Shopify Location id 58450641063
2025-08-01 14:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 14:10:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T14: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-01 14:10:06 [INFO]: Change: available | Delta: -1
2025-08-01 14:10:06 [INFO]: Change: on_hand | Delta: -1
2025-08-01 14:10:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 14:10:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44660197 and user_id = 14409 
2025-08-01 14:10:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77565417 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 14:10:06 [INFO]: updateIdsQuantity -> ["77565417"]
2025-08-01 14:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-01 14:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77565417 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77565417 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77565417)
2025-08-01 14:10:06 [INFO]: QUANTITY Updated IDs: 77565417
2025-08-01 14:10:06 [INFO]: Successfully processed data for user 14409
2025-08-01 14:10:06 [INFO]: Execution Started
2025-08-01 14:10:06 [INFO]: Execution Finished
2025-08-01 14:20:01 [INFO]: Execution Started
2025-08-01 14:20:01 [INFO]: old server sucessfully connected
2025-08-01 14:20:01 [INFO]: sqs client sucess created
2025-08-01 14:20:03 [INFO]: Number of messages in the queue: 1
2025-08-01 14:20:04 [INFO]: item found in queue is if condition  14409
2025-08-01 14:20:04 [INFO]: item found in queue is  14409
2025-08-01 14:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBJo/IlZsBEeRIKBMg9Nuzstb+W94piQsUvuqPmYahCYM+n6FQ1sqldltcnbnSECsJ6iMhizobVuJhpArlo2Oz4SIp3iODCScrI+uH3sfhiCPfRi86ZFwhormh/+A0Db/4zhJ9SCK+QJRDoJgVsSBL3IgbkfyFStSbz/wKWh7A1+CY7+fI3SWMOl+xSwRBuh/v1TruWrVbt+IJuLSBgQzQC2ezkpGdKrAFSZMH1PefRO1o615J16f9cxDxlXnQIsLGyqCOnKkz9cCybwZrnrVm8KDIBeXJKswvSENY+/pUiC10Fzz/dleGE+aUG+HEOcWMjx97XNyvicKGdpJ9z/45RcmRTcFcyS8oTZ6jtWFyCGYHD8gpeLH4ZaTAm4kDBeaON7IjOK0w67JKkrJWpXSuQre8uXc2lKfd2Hm5dZEqs601zXlHS/GY0hDy31gb4Sz9
2025-08-01 14:20:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-01 14:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 14:20:04 [INFO]: inside itemsold and closed 14409
2025-08-01 14:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 14:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-01 14:20:06 [INFO]: Ebay item id :: 324853536477 exists in Database
2025-08-01 14:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 14:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 14:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 14:20:06 [INFO]: in processold action queue is array    for {"44682643":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682643","ebayitemid":"324853536477","shopifyproductid":"7129695322279","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7129695322279","shopifyvariantid":"41635783082151","shopifyinventoryid":"43732725694631","shopifylocationid":"","product_id":"44682643","variant_id":"77587868","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 14:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 14:20:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 14:20:06 [INFO]: Shopify Inventory id 43732725694631
2025-08-01 14:20:06 [INFO]: Shopify Location id 58450641063
2025-08-01 14:20:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 14:20:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T14:20:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-01 14:20:06 [INFO]: Change: available | Delta: -1
2025-08-01 14:20:06 [INFO]: Change: on_hand | Delta: -1
2025-08-01 14:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 14:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682643 and user_id = 14409 
2025-08-01 14:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77587868 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 14:20:06 [INFO]: updateIdsQuantity -> ["77587868"]
2025-08-01 14:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-01 14:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77587868 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77587868 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77587868)
2025-08-01 14:20:06 [INFO]: QUANTITY Updated IDs: 77587868
2025-08-01 14:20:06 [INFO]: Successfully processed data for user 14409
2025-08-01 14:20:06 [INFO]: Execution Started
2025-08-01 14:20:06 [INFO]: Execution Finished
2025-08-01 14:30:01 [INFO]: Execution Started
2025-08-01 14:30:01 [INFO]: old server sucessfully connected
2025-08-01 14:30:01 [INFO]: sqs client sucess created
2025-08-01 14:30:03 [INFO]: Number of messages in the queue: 2
2025-08-01 14:30:04 [INFO]: item found in queue is if condition  14409
2025-08-01 14:30:04 [INFO]: item found in queue is  14409
2025-08-01 14:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBTppbOhxWnRO6aFpSQ1O3qkL9Vj1HPNvtjawku9lF8UKrRFd1O3WAoSGNV9bpWJVqjoXo0WuU8fTdoHioK9dX2NtqvQNZ/EscGfLQiTConkV3+ehDK+gezKuGQnpuVlMiHYLjzhkWVZ/YZavTl+kbU8u7qpCxKhSD71A4CRzl2rd6ZGM7EhtkeoUHCcDZ00w8aW/9XdLYg+XqHLonwqr7cXmJhH2t5xlxa5qfeKEixBTEWUGGZieeOo6vm3ZYcTK3X6qJ0ZD85v4YO+XMH0X1FaXBiJpz3+PzB2E9/5Qw1FZBzcao9yxGPxPPe9xTtt+Qu80DMbXmMYuH+CIepvTdRkF6bdfslR/ofjsIJL/fhtYAmTMpu56J3Des/WgG9tXdKjipsN/ET9wNopkj4D4MOEjLwmjwTpceGmj0PPV7LXErxDbGMkr0yUjTig+I/Wdg
2025-08-01 14:30:05 [INFO]: item found in queue is if condition  14409
2025-08-01 14:30:05 [INFO]: item found in queue is  14409
2025-08-01 14:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBP2BZXqcb5XgcqajAat8zAuyogM48k0zGVkJJSPPx0Xm/Pg2V1OMBVWBS8caDwAqKb1/qTwezdxLveh35SKrZeA/0p6kNN6K9tVqds8/IW6Foqpl891AZ4fnlf5nXjyLYVGaOcTSuaboG89E59heNhGk03g7T/NgfXUCOGOb+uj7Yco28AksHpPwmVZui99d8BsgLfydPpTLMyihWSpDw6HH1KZQ2CRSUUP3Ltdf2DYK3qy6/UTRRtOoQcTY4LW0fXPsJKpu2kkNk0upiTJFlcq7/M+8NVL5NKJm7jBjS6Z6E/RegIzUyxUl53OuOz75oe9LlGJ0mR0PNZ+ROVubO6NJPnsmgtsS70t6XkWl/y1W+9i4hxyd/smE+Fgs84TAEpq7EVC1nF03JLBXETLAiniAMWIglwOMYevuZ6NqPjBg/7dDG77AXkfDDlAXd3r0k
2025-08-01 14:30:05 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-01 14:30:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 14:30:05 [INFO]: inside itemsold and closed 14409
2025-08-01 14:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 14:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-01 14:30:07 [INFO]: Ebay item id :: 306369576701 exists in Database
2025-08-01 14:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 14:30:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-01 14:30:07 [INFO]: inside itemsold and closed 14409
2025-08-01 14:30:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 14:30:08 [INFO]: autolink for user_id 14409 is 1
2025-08-01 14:30:08 [INFO]: Ebay item id :: 326494792662 exists in Database
2025-08-01 14:30:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 14:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 14:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 14:30:08 [INFO]: in processold action queue is array    for {"45167956":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45167956","ebayitemid":"306369576701","deleted":1}},"44662507":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662507","ebayitemid":"326494792662","shopifyproductid":"8032684114142","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8032684114142","shopifyvariantid":"44172912558302","shopifyinventoryid":"46269918380254","shopifylocationid":"","product_id":"44662507","variant_id":"77567727","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 14:30:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 14:30:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 14:30:08 [INFO]: productIds WHich are having null productid -> [45167956]
2025-08-01 14:30:08 [INFO]: ebayItemIds WHich are not imported-> ["306369576701"]
2025-08-01 14:30:08 [INFO]: Entered in bulkUpdateProducts function
2025-08-01 14:30:08 [INFO]: Transaction started for bulkUpdateProducts
2025-08-01 14:30:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45167956)
2025-08-01 14:30:08 [INFO]: Query executed successfully. Affected rows: 0
2025-08-01 14:30:08 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-01 14:30:08 [INFO]: Transaction committed successfully.
2025-08-01 14:30:08 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-01 14:30:08 [INFO]: Shopify Inventory id 46269918380254
2025-08-01 14:30:08 [INFO]: Shopify Location id 58450641063
2025-08-01 14:30:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 14:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T14: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-01 14:30:09 [INFO]: Change: available | Delta: -1
2025-08-01 14:30:09 [INFO]: Change: on_hand | Delta: -1
2025-08-01 14:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 14:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662507 and user_id = 14409 
2025-08-01 14:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567727 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 14:30:09 [INFO]: updateIdsQuantity -> ["77567727"]
2025-08-01 14:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-01 14:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77567727 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77567727 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77567727)
2025-08-01 14:30:09 [INFO]: QUANTITY Updated IDs: 77567727
2025-08-01 14:30:09 [INFO]: Successfully processed data for user 14409
2025-08-01 14:30:09 [INFO]: Execution Started
2025-08-01 14:30:09 [INFO]: Execution Finished
2025-08-01 14:40:01 [INFO]: Execution Started
2025-08-01 14:40:01 [INFO]: old server sucessfully connected
2025-08-01 14:40:01 [INFO]: sqs client sucess created
2025-08-01 14:40:03 [INFO]: Number of messages in the queue: 2
2025-08-01 14:40:03 [INFO]: item found in queue is if condition  14409
2025-08-01 14:40:03 [INFO]: item found in queue is  14409
2025-08-01 14:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBUH/U/3bbLxl2IEgtZkg8eBnVxo3lBOEtUXycQHsWGZWbtSkSkxY9MDu6LwehC7j6UrWBqQy3ZkSHu/QT7r2RxqFU/2w567YwNLubm1JVinAQgtnV6Ow3PvA1PbPqDVmpwya1kVwE2+CUnKOWQvcuOvz7rkpkOlBTsYi2Jifg+i30dNlOI/gsxuoOpfDjhjodGaSS3DoOB85flmU2C3Nh0/HwsLANOI5dSjNlOXF4xzjL95sUwmnhd18+M9dfAjHehTiRFwTiVtUT/YQS2YBsQng2oOK47vFhHqagXfIMjZmPescVPlVfBujQsjI+A8sFdf++VWvjmiZ9pRoc/XMWSS5TxVGK/fIUsVSNB094HRNG+VAy+yJ709ogUXG/Ofxgc7dog50XCSmtp5ALJ7uFmXN2H77Xlj8meXMJTclbLuteKjIg3eReM3ppsHXBwDfv
2025-08-01 14:40:04 [INFO]: item found in queue is if condition  14409
2025-08-01 14:40:04 [INFO]: item found in queue is  14409
2025-08-01 14:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBya5U8WQpOzLs2GLpzlvUouNL2ZtegfSljuxu1jE5kCt0nkcqL7YyxwcpBPJneNGc0SEEFo3lHIMCwrlO7W0oSiEa1Ytrjgyb6j9gw79RvzuqNDxfteB6+Qn2J9Jhhrqpn36XeKPCd15ycgDXCinlMlTBp3WZcLWT9A+h8+G+hW4+QJhKunfEO+NbI7/GKjaHTbVDu3mIBALIHzuANuBkKQaRYofqe6u14MgRs9b2J5tkiTYnFfCnsWTGYN/bGcIXqg6+8MQVGknHBg+WPdTsMCI8Y+2dnO8gcY7Sz15CnzCfESUzzqdVhmTD3HL5I5Riv3bH9C7xWcmpzb8F82AC+JlGzdqdzGvUlRvId3SSjuBe9D2maGaglYqGWglU3erhuw0xh5WEFG0t1WJrsfaavH7cdM4vZ5urkigaRbbsE4gDpVLEy2R9h8m4rPpV9EEh
2025-08-01 14:40:05 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-01 14:40:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 14:40:05 [INFO]: inside itemsold and closed 14409
2025-08-01 14:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 14:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-01 14:40:07 [INFO]: Ebay item id :: 226678369671 exists in Database
2025-08-01 14:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 14:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 14:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 14:40:07 [INFO]: inside itemsold and closed 14409
2025-08-01 14:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 14:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-01 14:40:08 [INFO]: Ebay item id :: 326701430866 exists in Database
2025-08-01 14:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 14:40:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-01 14:40:08 [INFO]: in processold action queue is array    for {"44711562":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44711562","ebayitemid":"226678369671","shopifyproductid":"8862166974686","variants":[{"price":"21.99","quantity":0,"weight":"1","shopifyproductid":"8862166974686","shopifyvariantid":"46517449621726","shopifyinventoryid":"48619821498590","shopifylocationid":"","product_id":"44711562","variant_id":"77619175","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45289353":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45289353","ebayitemid":"326701430866","deleted":1}}}
2025-08-01 14:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 14:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 14:40:09 [INFO]: productIds WHich are having null productid -> [45289353]
2025-08-01 14:40:09 [INFO]: ebayItemIds WHich are not imported-> ["326701430866"]
2025-08-01 14:40:09 [INFO]: Entered in bulkUpdateProducts function
2025-08-01 14:40:09 [INFO]: Transaction started for bulkUpdateProducts
2025-08-01 14:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45289353)
2025-08-01 14:40:09 [INFO]: Query executed successfully. Affected rows: 0
2025-08-01 14:40:09 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-01 14:40:09 [INFO]: Transaction committed successfully.
2025-08-01 14:40:09 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-01 14:40:09 [INFO]: Shopify Inventory id 48619821498590
2025-08-01 14:40:09 [INFO]: Shopify Location id 58450641063
2025-08-01 14:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 14:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-01 14:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 14:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44711562 and user_id = 14409 
2025-08-01 14:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77619175 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 14:40:09 [INFO]: updateIdsQuantity -> ["77619175"]
2025-08-01 14:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-01 14:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77619175 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77619175 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77619175)
2025-08-01 14:40:09 [INFO]: QUANTITY Updated IDs: 77619175
2025-08-01 14:40:09 [INFO]: Successfully processed data for user 14409
2025-08-01 14:40:09 [INFO]: Execution Started
2025-08-01 14:40:09 [INFO]: Execution Finished
2025-08-01 14:50:01 [INFO]: Execution Started
2025-08-01 14:50:01 [INFO]: old server sucessfully connected
2025-08-01 14:50:01 [INFO]: sqs client sucess created
2025-08-01 14:50:03 [INFO]: Number of messages in the queue: 0
2025-08-01 14:50:24 [INFO]: Execution Started
2025-08-01 14:50:24 [INFO]: Execution Finished