2025-08-07 12:00:01 [INFO]: Execution Started
2025-08-07 12:00:01 [INFO]: old server sucessfully connected
2025-08-07 12:00:01 [INFO]: sqs client sucess created
2025-08-07 12:00:02 [INFO]: Number of messages in the queue: 3
2025-08-07 12:00:03 [INFO]: item found in queue is if condition  14409
2025-08-07 12:00:03 [INFO]: item found in queue is  14409
2025-08-07 12:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8ZlgljF8MFck1uZpwK9RIuR9hjvRvBBm+MrY+DFvSaV77a6sLUB3vYX7tD6h3IvY/wtZyuBDsmP5RVJiGmm3gQkDx7U2Ty8rLn6KjQ9/pPMNa6LSe5YDVI9M+uZEjfNrkUsgBnzAH6LGfsqkZzcxsquO9D3+WpBMPQqR4tsE6zCpqjI+8lExs5aAileH19BVm2VQo57nHiPGntiT1WjRQ3ZKdv/Bubw+jlzU0pyFV7J352OIhSnAnxmQq4cwLFhYxa0pFVgRGZmWpem4TkLWo9euq922QmuAtgy4mVd1AkOhHR+mU6wp1YJleV5LZ3KVExRICze+xi17XKpuWu/iih1ERQwhr2wmYeacB23So9jcqPxOgYAkuxbBsI5Ok5dgvM0eq/itODLN30s6Td7aDr5qwO1H//oUdb/I48gV3dfMa+3aWZ7g26rZ3Tx8Ikrz
2025-08-07 12:00:03 [INFO]: item found in queue is if condition  14409
2025-08-07 12:00:03 [INFO]: item found in queue is  14409
2025-08-07 12:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBlyEsOl41D890C+0vwo4mpdq4nx2BcyN9+BQcf/FxLtw+q+73b0Vpf2Cbp7g1CX2XISRKylxu+5wV/vBXUs8zOde/XWa3+K8x8djOjjKKpFcI2HwU5yhAPKLG+9zRW6isqpsnd6xR918OJh64PKeGCFLX916UWhyz9L+uFGKajkTjoRDdbZsgNAG3f43Ys7cQwOR7CQ6MNzcH5cQ7jUG/aHvTeyUS0SGAPccBSu0iKIboxJuVaVCYxV7Gd2L3N3y9B31RKeMsONn55nHnFZ5aJlIJs3gS7bPZeYbPMxwKeEp1T1P1Zsx8WYjphkr+LQgoylg7kGITEMau0PBay8Zu5ozxxHWta4WZA9IK4IqXZtj9oLr5oe/eglMzSl/7mWHkerpdgVzWbX/MaV1Uav3fYGW8NdiEEBGw/+a3bDGD+WOpzL2liZH8DUfRW7mmj6w8
2025-08-07 12:00:04 [INFO]: item found in queue is if condition  14409
2025-08-07 12:00:04 [INFO]: item found in queue is  14409
2025-08-07 12:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBu9usbhIdKmQ4JC4ojHOW/jPeuJNKhsd1zIizu7WDX2iUzvFARdKerO3hWDmSmzRWkijB34HxSI6wOmXG+jzIU7JWuJwiOAaJQ6AM9V0o0t/OMj08tE7C06DDohEQnOPhXMEpNqVHxsAxpg1bKOGI264uOrcRW1d8zDZI8UKdDKsRwP16egZLD1MjLjiVDkj+swSRcIgx/Y+kZg/+BK/UX7coSrvUoJyn0arM4JVBfS+jGKi2gvQ3hDhKzuPwdWgy/jxDyuZ2nSGtWn6D41BdjTnSJWJAao2Qy/rNHfHW+u9M3B3vEhu86tN0icTl7sBCufJQ2Z9kuLxL2w68npleU11iy/hDeRvG+GgsvFhuwk04sFu32eSR7C8a1FHCbh0YPdL6FRD/XHH4+Utaf7/jth/fc6qJFoENmo1yvTjH3ZG//Yd2j95cwI0VtgUSWAdW
2025-08-07 12:00:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-07 12:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 12:00:04 [INFO]: inside itemsold and closed 14409
2025-08-07 12:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:00:06 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:00:06 [INFO]: Ebay item id :: 405377550069 exists in Database
2025-08-07 12:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:00:06 [INFO]: inside itemsold and closed 14409
2025-08-07 12:00:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:00:09 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:00:09 [INFO]: Ebay item id :: 404882743604 exists in Database
2025-08-07 12:00:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:00:09 [INFO]: inside itemsold and closed 14409
2025-08-07 12:00:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:00:11 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:00:11 [INFO]: Ebay item id :: 256592592972 exists in Database
2025-08-07 12:00:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:00:11 [INFO]: in processold action queue is array    for {"44676836":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44676836","ebayitemid":"405377550069","shopifyproductid":"8696091869406","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8696091869406","shopifyvariantid":"45936164602078","shopifyinventoryid":"48034613559518","shopifylocationid":"","product_id":"44676836","variant_id":"77582056","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44679625":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44679625","ebayitemid":"404882743604","shopifyproductid":"8339113672926","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8339113672926","shopifyvariantid":"44982772629726","shopifyinventoryid":"47080559476958","shopifylocationid":"","product_id":"44679625","variant_id":"77584845","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44774499":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44774499","ebayitemid":"256592592972","shopifyproductid":"8696082858206","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8696082858206","shopifyvariantid":"45936142549214","shopifyinventoryid":"48034591506654","shopifylocationid":"","product_id":"44774499","variant_id":"77683041","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 12:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 12:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:00:11 [INFO]: Shopify Inventory id 48034613559518
2025-08-07 12:00:11 [INFO]: Shopify Location id 58450641063
2025-08-07 12:00:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:00: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 12:00:11 [INFO]: Change: available | Delta: -1
2025-08-07 12:00:11 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44676836 and user_id = 14409 
2025-08-07 12:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582056 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:00:11 [INFO]: Shopify Inventory id 47080559476958
2025-08-07 12:00:11 [INFO]: Shopify Location id 58450641063
2025-08-07 12:00:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:00: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 12:00:11 [INFO]: Change: available | Delta: -1
2025-08-07 12:00:11 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44679625 and user_id = 14409 
2025-08-07 12:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77584845 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:00:11 [INFO]: Shopify Inventory id 48034591506654
2025-08-07 12:00:11 [INFO]: Shopify Location id 58450641063
2025-08-07 12:00:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:00: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 12:00:12 [INFO]: Change: available | Delta: -1
2025-08-07 12:00:12 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44774499 and user_id = 14409 
2025-08-07 12:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77683041 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:00:12 [INFO]: updateIdsQuantity -> ["77582056","77584845","77683041"]
2025-08-07 12:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-07 12:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77582056 THEN 0 WHEN id = 77584845 THEN 0 WHEN id = 77683041 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77582056 THEN 0 WHEN id = 77584845 THEN 0 WHEN id = 77683041 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77582056,77584845,77683041)
2025-08-07 12:00:12 [INFO]: QUANTITY Updated IDs: 77582056, 77584845, 77683041
2025-08-07 12:00:12 [INFO]: Successfully processed data for user 14409
2025-08-07 12:00:12 [INFO]: Execution Started
2025-08-07 12:00:12 [INFO]: Execution Finished
2025-08-07 12:10:01 [INFO]: Execution Started
2025-08-07 12:10:01 [INFO]: old server sucessfully connected
2025-08-07 12:10:01 [INFO]: sqs client sucess created
2025-08-07 12:10:02 [INFO]: Number of messages in the queue: 5
2025-08-07 12:10:03 [INFO]: item found in queue is if condition  14409
2025-08-07 12:10:03 [INFO]: item found in queue is  14409
2025-08-07 12:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBqrMtcrhHejE/fp9/jl9P3iAQLZwpOLbQv0UhD0FojcWz5k7NycU+lLuhVQL1lUNvlxVNTJfqcxfHIPswqCXNhV1Xz+iRhDFc+p8soty55wJxf/dhw1k345qb9sJmcFQ0t+f9eJ4AtlmCnhYENF+UNoaaVScesubHTUvyN5e4vO0I8eC12v61hombXVh3SE4hs7SpZmyneq1SKSGCONR9guZI5fP8s5nsTPphDkn3eBrVIug61zcpPckCZd0KY6KPUv6f1C4OGT9zYSrejzZfadQOrphHmmHijDwDs83KdXqYzIrV09OBX1erFEthlLk/3Unzx7FsaR5zoSszYO2xmrgZo6zP5YIBq0bjhoT+Z7xrRCKjsN8fUSb8e8m3z7PeqMj0cyXQJsIcLJdiY4zKTDh+ItCVzcU5x7F489qcxArRYJITTySl/Gg3/E3Q0l7K
2025-08-07 12:10:03 [INFO]: item found in queue is if condition  14409
2025-08-07 12:10:03 [INFO]: item found in queue is  14409
2025-08-07 12:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBU0rNCzZinE+fp3k1OJVrBlosN5tLBQAn8TkcM+qej7vaGjPZrKmPBunqdMGEctcpnwWn2lUQ48XXkgnxRbWtK/M6/WEfUDUAwZNV1/sVUJBSH4ByvdFd86/7x+FpHto5hPoWyOzLhVP2dpc8g/wLyqUWuVUtlg5ABccnisooyq8sz3KhK3qHp5OIb05kmtHBGU0joz1S9wUtHRO7YqEO/9gpHbbMNdqM2mNAEM1QPdnN4KrwB5k9GEmaPw2IIjeUHhzPeepLauP6kKXfrnuoCkpbs6mQ6Tp/Z/uatWrTjEJsG1DrAVRF53nFVnonhD+mywRLjjUOe7T2Vv7p8QFcWRvsNyiuNwYNPHLNTG1EBeJDC5OSb6GrNAB7yW3HRdHzmt3qugOyCYnaWDr7SYS6ZCewuyWr/9XoaCzQTrONQGdZtJKjc/uwMeFhHhBVRDWp
2025-08-07 12:10:04 [INFO]: item found in queue is if condition  14409
2025-08-07 12:10:04 [INFO]: item found in queue is  14409
2025-08-07 12:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB96nGXowIkSIPZ7zJUvcO7CkdleXgjbTNwKsRSCNDckfBu+gXqgkI4JASZ0jXYrpvb7Kp5uw6O8KD3s7ffPqXzCkWrH1/Clkg1bYNF3TvnOjUKudIudsmpauoGZsqqqajcBzn+VMy3MTGKhOxA1ok6eqrUkSnoRHmrytnes9Id4C9AS1DnmMj8iswBXka60lTLpR+Uw8RMdfn7rtXsZNWctsxdyEjsanjMXkHr0DB3c+acXePi6SyUXv11C++7+c474lBybC5i1J6DBMkrpGfpzWNbDLV01weeuFj1ZBE8Enrlyoy0i3J3MFvRjt1JjJUtHDTYUyp1J+IbevZ9wvqnQ40HH5REskItLpzNt8ws4n+YmQg8Fhp2vIhe4k1syMlr9Y6JJhc5D8f3kHu43wqImy6JYDrxNGksvxffbe8vuiXImZdrrWczb2so3HtWFDy
2025-08-07 12:10:04 [INFO]: item found in queue is if condition  14409
2025-08-07 12:10:04 [INFO]: item found in queue is  14409
2025-08-07 12:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBKz9G7sR1KItrzVZmtAzNJcerHxcvqQroYC/vh4NnEyt0OvgKQFLjlriifrTAwl5/x1LJgmKnGX+g9HCx2WNXcy+ROqU4TOTyLDQwJwrKTEL2QqLISD4kEJQDhSi6ZgvzIHbpKeW4m78pGYwx20GaVU2iflvToACPcvnJ4kj1eRuIobwUZ1XKE8+ntW1PAKTLIsMcAaftaWFXi1ZeCAvZ/59mFO+0xc3VsgP17167WtMv/jM28dMaeoOtL+ApjaI0pd632+cUrQepFsGoSaUZFhBIM8P70L70APZx1Qd3Cc79wFZtvdSeP+2/+4mj7Yp4m4bMZUBdCvoucbSKapjVr7kKvRhWYWYBrUngWqX89DCsDqlWZ2sL80O2Z+VQSg7XEqXTEE9oyYUR+mzC4km470Am3lYxBLPFWVxE2+WUhnZZFrTGD+EK9dqw7ZiPYWxq
2025-08-07 12:10:05 [INFO]: item found in queue is if condition  14409
2025-08-07 12:10:05 [INFO]: item found in queue is  14409
2025-08-07 12:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEB4K+So3bJfxgSN12pMexTPKXeCjef/S5xjXClkddg63vitJgrIRjVDUrgKKetW2GhrX/JaEJhkM4SF4K9c9gS4Hpw0vITuc7wFfsAxLld4tnlEZlyiW9AyDfw2tA/5GP7snctOPjA/wSvsUABJwxS5UOojhqQeRXQ7N6R1XLB9F64dBmhS+2OEIygPZ6ZF7q9cC9R456IVD/EAac0Pgrk+9Jyb5CO7xVqBA4cydPffpw2Kk/rtSx9X+HH2eUvp/F2mMpfeOVZg5G4eLnAMeDbn96jgFUNWJVQVfUVL5x4JxRSSg/WpsD7kJzQKigD4wlP9XdvKLwEAKa50NgZ7YhuKKCuUuuLCAIfWlq2oeiyZcoU+sz2pLIiIAaPYZiaxokLnVHPV/bGTcpYeUJF3EeIErR5rkS0FZMrTnITZd/4h5VB5aFoqGqG9k9sGxsxILIi
2025-08-07 12:10:05 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-07 12:10:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 12:10:05 [INFO]: inside itemsold and closed 14409
2025-08-07 12:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:10:07 [INFO]: Ebay item id :: 404799763939 exists in Database
2025-08-07 12:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:10:07 [INFO]: inside itemsold and closed 14409
2025-08-07 12:10:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:10:08 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:10:08 [INFO]: Ebay item id :: 286230452783 exists in Database
2025-08-07 12:10:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:10:08 [INFO]: inside itemsold and closed 14409
2025-08-07 12:10:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:10:10 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:10:10 [INFO]: Ebay item id :: 256295545509 exists in Database
2025-08-07 12:10:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:10:10 [INFO]: inside itemsold and closed 14409
2025-08-07 12:10:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:10:12 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:10:12 [INFO]: Ebay item id :: 326701429158 exists in Database
2025-08-07 12:10:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:10:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-07 12:10:12 [INFO]: inside itemsold and closed 14409
2025-08-07 12:10:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:10:13 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:10:13 [INFO]: Ebay item id :: 285704343516 exists in Database
2025-08-07 12:10:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:10:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:10:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:10:13 [INFO]: in processold action queue is array    for {"44644525":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644525","ebayitemid":"404799763939","shopifyproductid":"8696102650078","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8696102650078","shopifyvariantid":"45936209658078","shopifyinventoryid":"48034658615518","shopifylocationid":"","product_id":"44644525","variant_id":"77549714","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45289365":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45289365","ebayitemid":"326701429158","deleted":1}},"44644359":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644359","ebayitemid":"285704343516","shopifyproductid":"8696105631966","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8696105631966","shopifyvariantid":"45936214704350","shopifyinventoryid":"48034663661790","shopifylocationid":"","product_id":"44644359","variant_id":"77549548","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 12:10:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 12:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:10:13 [INFO]: productIds WHich are having null productid -> [45289365]
2025-08-07 12:10:13 [INFO]: ebayItemIds WHich are not imported-> ["326701429158"]
2025-08-07 12:10:13 [INFO]: Entered in bulkUpdateProducts function
2025-08-07 12:10:13 [INFO]: Transaction started for bulkUpdateProducts
2025-08-07 12:10:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45289365)
2025-08-07 12:10:13 [INFO]: Query executed successfully. Affected rows: 0
2025-08-07 12:10:13 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-07 12:10:13 [INFO]: Transaction committed successfully.
2025-08-07 12:10:13 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-07 12:10:13 [INFO]: Shopify Inventory id 48034658615518
2025-08-07 12:10:13 [INFO]: Shopify Location id 58450641063
2025-08-07 12:10:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:10:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:10: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 12:10:14 [INFO]: Change: available | Delta: -1
2025-08-07 12:10:14 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644525 and user_id = 14409 
2025-08-07 12:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549714 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:10:14 [INFO]: Shopify Inventory id 48034663661790
2025-08-07 12:10:14 [INFO]: Shopify Location id 58450641063
2025-08-07 12:10:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:10:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:10: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 12:10:14 [INFO]: Change: available | Delta: -1
2025-08-07 12:10:14 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644359 and user_id = 14409 
2025-08-07 12:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549548 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:10:14 [INFO]: updateIdsQuantity -> ["77549714","77549548"]
2025-08-07 12:10:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-07 12:10:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77549714 THEN 0 WHEN id = 77549548 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77549714 THEN 0 WHEN id = 77549548 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77549714,77549548)
2025-08-07 12:10:14 [INFO]: QUANTITY Updated IDs: 77549714, 77549548
2025-08-07 12:10:14 [INFO]: Successfully processed data for user 14409
2025-08-07 12:10:14 [INFO]: Execution Started
2025-08-07 12:10:14 [INFO]: Execution Finished
2025-08-07 12:20:01 [INFO]: Execution Started
2025-08-07 12:20:01 [INFO]: old server sucessfully connected
2025-08-07 12:20:01 [INFO]: sqs client sucess created
2025-08-07 12:20:09 [INFO]: Number of messages in the queue: 0
2025-08-07 12:20:30 [INFO]: Execution Started
2025-08-07 12:20:30 [INFO]: Execution Finished
2025-08-07 12:30:01 [INFO]: Execution Started
2025-08-07 12:30:01 [INFO]: old server sucessfully connected
2025-08-07 12:30:01 [INFO]: sqs client sucess created
2025-08-07 12:30:05 [INFO]: Number of messages in the queue: 5
2025-08-07 12:30:05 [INFO]: item found in queue is if condition  14409
2025-08-07 12:30:05 [INFO]: item found in queue is  14409
2025-08-07 12:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEB3mEa5LCKnxbbMo0Gj/i+XbHflWdXLQOLKn9jDGCNer3qYN4Oky8jIRGVV76j6tM16Ju3oBFOMmurSwgR7CudSGyFa3ewmSrvesDW+WnGpLtqGbE8gPs7ha1wpuYxvKh8MKuhLSW1MgYOdnyLN7s5aP76471XILeMr3oTmyHDIe2qn0u2Y234P+OfsVkULKttFq19MAQD0EJX17Zw9UcNOI8OyWc1krqm1fdY5woExHzfIXPRU0g7+uYuN0gSwrSkDMQlQIWXT0TGsfiyeB8svH4Pa5Fyaa/82HT9ayZcQzw8MqcVCbzmT7s10bizZ3R2kSOB5hPOZVFfe0ylihBh7Z+/LgGYl13r33lDc+FEquYMvZOsG+Xe4ttrE6Qi7W49GSXGvKV2ydWaFZFaP3Ni87ixZa2hTBWspUHOWMI0YInaOzdVnsEziIv9BunNoKBx
2025-08-07 12:30:06 [INFO]: item found in queue is if condition  14409
2025-08-07 12:30:06 [INFO]: item found in queue is  14409
2025-08-07 12:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBqntnLrUyw756k2pFqIwhTdD8r+sg91NG/BhAx2dnfkHn+AS5DC31Fj85qj0ZBNkpKwcaEQQrr7z3KwEH10o1p/XuYVOxcGYc5wQVItvbFce9aZXPLTEEUbSp1tiWTAWMBng/MKuzIjulos1JfA5e0NOnYGg/8FcWtPI8Zgm6YBaTdQ9si0dSW93/mD4WuePVGubuKzlhYxLqsjjLGGGGwTBNiPqg6tGbtMz6kwFrhD670/l+pq07Enwsp146QUTJVL67XZhrRH8YggsQIaI3kJPUMIYj2Ua5v61/ZbGUDHnBXdl0VjXr6s2BXwnqmdf9v2OO1u2y3XuKkp75PWIyaH7tRIWdovTmuEt5+T+dsRLqMx6HUtLlY3S2IMCxQmx0LJ/sJZcMORmwkP1q8Cs0f+f19RaZZuiqnwHWpbpLnbf1Lv+PuzIA1XLC2iS2S+lw
2025-08-07 12:30:07 [INFO]: item found in queue is if condition  14409
2025-08-07 12:30:07 [INFO]: item found in queue is  14409
2025-08-07 12:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBdz9iDllDMVeZXTnoEzn2vatKOmByFcjFXpvohf9TiQdzPutM6QJDqEPq7u/XbquS0veg/bH+rWRfmEJ8/3JEJ6TxqNpShr3TWnMQgM5b6lG3UVO+tMYqG+A/iLcMJoYL3ofGYNsiHRgN+LGSaW3BXSk69cKliNXOJl0ow6CQvZq8OBSH1aCD5HV74/hw0I9q178LyBhOb/oSONB8x0GkdhWqsBA2wwpehmI9aKp/DjD4n1t3Nhxq6J2o2mepMB9AtlEyryksivMYDju7RRvDP6ar8CtHtmVU9yFqLE8Z8K4Bof55sfgEtILelcGo17wUWoMvcduaskTLsANqtyCVpJ2Ddx1GKYGQz4ZonnC9ADcZBtHU9oiq1RddAufYyp2dMjrAhSEqgdatDKqmOqNpURoOsaNB9uQBqPwEG66dih4YZDnjcINwdnaj/aOAkySH
2025-08-07 12:30:08 [INFO]: item found in queue is if condition  14409
2025-08-07 12:30:08 [INFO]: item found in queue is  14409
2025-08-07 12:30:08 [INFO]: Message deleted from the queue for receipt handle: AQEBps2i+1uTDhitQRRrWXc1CFKBS9QU9LIgqFVmiU8XOw55+PITnZFRX3UPfRgyh0rPvv9uPG1CWrc8GVsfag1HkRWbopNm3V9oJ3wPbNhY2z7nYAjX9rAIBVMNAeW9YQ8HlBnhksReKJ8sqQP7kYKHjrUVuMNLYWs8WhZlqI9dl96OQ1IZabLNFbkkZGUeVIiy+C7jR9GIKs4tC01Wv7lOsa7fVD6O7bM60SpZRt61V+oNdmemUCfetYEx9QOK4QYYUGoGrDC0B0Y3kg6nUJfFkWWlnVPxuaTU1pwBxHc/eLZPcpkA/FT/FwOjPYJLQm39RvDFcyo6zEDf858pSblu7GztSLk2sVYJLmnR7/1NwND2JPbkE5L+9bTf+pDz6eOolHYEoxF31EhlvpnrhfiZNA7Iiz6JR+tMi2RZlrKSinJvdXCgCffiw1GMpZ1XCP0J
2025-08-07 12:30:08 [INFO]: item found in queue is if condition  14409
2025-08-07 12:30:08 [INFO]: item found in queue is  14409
2025-08-07 12:30:10 [INFO]: Message deleted from the queue for receipt handle: AQEBv7rSEHq9TtReNHdqe17n3MTf1aE7/ToP3+hVsxgpQoAK96GgIMEBm7FcnJbDwPv75v0PTLD7nFEk1izazkiQ4FWvBxjwjr88x8ooZLpmyb58KIiiXmGCVFtXpPkIkS80UNoSspD4nxzyQTlfgUrUznb0tP4xnJGb0DqzW++cnPnUkAevaPLKfhyiTDGN9ODNO8vBF4zcG5RMS6x9girfiB9tJKpH4XGogQwGbWUe2e4TrsKbK3Jbt8rCviWuWWHW//w3q4UKUfUZbGF16OKO4wGJSCQtlc/MU6N+i4tNOdl79QZKhNkYA0S5bYRX4NRVi4fXHKKzamPU/1PS7eEhKwtulD+VnCyjiybt6uQV6a6K3vyDq3u5cMHKRmUksfCyLAwJ7uP3h3LED5k4zisIpNOxG7ucIZpdcsidfopIC1ZHR0lYNHbw21s2gEhpVssF
2025-08-07 12:30:10 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-07 12:30:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 12:30:10 [INFO]: inside itemsold and closed 14409
2025-08-07 12:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:30:12 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:30:12 [INFO]: Ebay item id :: 256413497187 exists in Database
2025-08-07 12:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:30:12 [INFO]: inside itemsold and closed 14409
2025-08-07 12:30:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:30:13 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:30:13 [INFO]: Ebay item id :: 404812401743 exists in Database
2025-08-07 12:30:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:30:13 [INFO]: inside itemsold and closed 14409
2025-08-07 12:30:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:30:15 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:30:15 [INFO]: Ebay item id :: 404812401743 exists in Database
2025-08-07 12:30:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:30:15 [INFO]: inside itemsold and closed 14409
2025-08-07 12:30:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:30:17 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:30:17 [INFO]: Ebay item id :: 256413559071 exists in Database
2025-08-07 12:30:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:30:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:30:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:30:17 [INFO]: inside itemsold and closed 14409
2025-08-07 12:30:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:30:18 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:30:18 [INFO]: Ebay item id :: 256413583972 exists in Database
2025-08-07 12:30:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:30:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:30:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:30:18 [INFO]: in processold action queue is array    for {"44644898":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644898","ebayitemid":"256413497187","shopifyproductid":"8696105664734","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8696105664734","shopifyvariantid":"45936214737118","shopifyinventoryid":"48034663694558","shopifylocationid":"","product_id":"44644898","variant_id":"77550087","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44666299":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44666299","ebayitemid":"404812401743","shopifyproductid":"8050954436830","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8050954436830","shopifyvariantid":"44208109912286","shopifyinventoryid":"46305193230558","shopifylocationid":"","product_id":"44666299","variant_id":"77571519","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44645231":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44645231","ebayitemid":"256413559071","shopifyproductid":"8696105697502","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8696105697502","shopifyvariantid":"45936214769886","shopifyinventoryid":"48034663727326","shopifylocationid":"","product_id":"44645231","variant_id":"77550420","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44645375":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44645375","ebayitemid":"256413583972","shopifyproductid":"8696102584542","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8696102584542","shopifyvariantid":"45936209428702","shopifyinventoryid":"48034658386142","shopifylocationid":"","product_id":"44645375","variant_id":"77550564","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 12:30:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 12:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:30:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:30:18 [INFO]: Shopify Inventory id 48034663694558
2025-08-07 12:30:18 [INFO]: Shopify Location id 58450641063
2025-08-07 12:30:18 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:30:19Z","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 12:30:19 [INFO]: Change: available | Delta: -1
2025-08-07 12:30:19 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:30:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644898 and user_id = 14409 
2025-08-07 12:30:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77550087 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:30:19 [INFO]: Shopify Inventory id 46305193230558
2025-08-07 12:30:19 [INFO]: Shopify Location id 58450641063
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:30:19Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-07 12:30:19 [INFO]: Change: available | Delta: -2
2025-08-07 12:30:19 [INFO]: Change: on_hand | Delta: -2
2025-08-07 12:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:30:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44666299 and user_id = 14409 
2025-08-07 12:30:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77571519 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:30:19 [INFO]: Shopify Inventory id 48034663727326
2025-08-07 12:30:19 [INFO]: Shopify Location id 58450641063
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:30:19Z","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 12:30:19 [INFO]: Change: available | Delta: -1
2025-08-07 12:30:19 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:30:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44645231 and user_id = 14409 
2025-08-07 12:30:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77550420 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:30:19 [INFO]: Shopify Inventory id 48034658386142
2025-08-07 12:30:19 [INFO]: Shopify Location id 58450641063
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:30:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12:30:19Z","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 12:30:19 [INFO]: Change: available | Delta: -1
2025-08-07 12:30:19 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:30:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:30:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44645375 and user_id = 14409 
2025-08-07 12:30:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77550564 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:30:20 [INFO]: updateIdsQuantity -> ["77550087","77571519","77550420","77550564"]
2025-08-07 12:30:20 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-07 12:30:20 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77550087 THEN 0 WHEN id = 77571519 THEN 0 WHEN id = 77550420 THEN 0 WHEN id = 77550564 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77550087 THEN 0 WHEN id = 77571519 THEN 0 WHEN id = 77550420 THEN 0 WHEN id = 77550564 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77550087,77571519,77550420,77550564)
2025-08-07 12:30:20 [INFO]: QUANTITY Updated IDs: 77550087, 77571519, 77550420, 77550564
2025-08-07 12:30:20 [INFO]: Successfully processed data for user 14409
2025-08-07 12:30:20 [INFO]: Execution Started
2025-08-07 12:30:20 [INFO]: Execution Finished
2025-08-07 12:40:01 [INFO]: Execution Started
2025-08-07 12:40:01 [INFO]: old server sucessfully connected
2025-08-07 12:40:01 [INFO]: sqs client sucess created
2025-08-07 12:40:03 [INFO]: Number of messages in the queue: 1
2025-08-07 12:40:05 [INFO]: item found in queue is if condition  14409
2025-08-07 12:40:05 [INFO]: item found in queue is  14409
2025-08-07 12:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBOSm6Kj0EbKKunD9btbOOAZFLHaNJvGWhR2YB72/b7mFYgOlpm6mdJBTxKbt+3eDcfgmhs5UX5667LMWT/VUKkEXIaIq0+vkp9U0jE7K88NyVvS6SqNKn+ugSS38Oe6RewKE6ed5R96ICUAn50CEIMaHAsRDbKTVv8wlXWOowVRebS9M04YrKT90rR6bVSrKO8c29LprGwtM6FMDgmU+Jw4fWBb4SLF6KbdlnPDVL1+Fytiv67Dgb4323ibmrUez8szAkN3RARLTK6EpDFgfrACFQyFjk5vGQ0sfqbixMjLE0ytcRST2RbIstsuDx25cmNRSOV3fLLltc1CYUB9VRiKq2yzHba34a9wd3EgdsT8L36jHh7RrNRWF/ggZkStHxltNZYSeGR35SzlaZStbzMe+cKstT2FPh7PAhAaRBZ1XiFf6j71ItrPzsd1pQ2+67
2025-08-07 12:40:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 12:40:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 12:40:06 [INFO]: inside itemsold and closed 14409
2025-08-07 12:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 12:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-07 12:40:08 [INFO]: Ebay item id :: 305890147440 exists in Database
2025-08-07 12:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 12:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 12:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 12:40:08 [INFO]: in processold action queue is array    for {"44560350":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560350","ebayitemid":"305890147440","shopifyproductid":"8726851027166","variants":[{"price":"20.99","quantity":0,"weight":"0.5","shopifyproductid":"8726851027166","shopifyvariantid":"46015309480158","shopifyinventoryid":"48113828298974","shopifylocationid":"","product_id":"44560350","variant_id":"77453030","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 12:40:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 12:40:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 12:40:08 [INFO]: Shopify Inventory id 48113828298974
2025-08-07 12:40:08 [INFO]: Shopify Location id 58450641063
2025-08-07 12:40:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 12:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T12: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 12:40:08 [INFO]: Change: available | Delta: -1
2025-08-07 12:40:08 [INFO]: Change: on_hand | Delta: -1
2025-08-07 12:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 12:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560350 and user_id = 14409 
2025-08-07 12:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77453030 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 12:40:08 [INFO]: updateIdsQuantity -> ["77453030"]
2025-08-07 12:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 12:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77453030 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77453030 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77453030)
2025-08-07 12:40:08 [INFO]: QUANTITY Updated IDs: 77453030
2025-08-07 12:40:08 [INFO]: Successfully processed data for user 14409
2025-08-07 12:40:08 [INFO]: Execution Started
2025-08-07 12:40:08 [INFO]: Execution Finished
2025-08-07 12:50:01 [INFO]: Execution Started
2025-08-07 12:50:01 [INFO]: old server sucessfully connected
2025-08-07 12:50:01 [INFO]: sqs client sucess created
2025-08-07 12:50:04 [INFO]: Number of messages in the queue: 0
2025-08-07 12:50:25 [INFO]: Execution Started
2025-08-07 12:50:25 [INFO]: Execution Finished