2025-08-11 17:00:01 [INFO]: Execution Started
2025-08-11 17:00:01 [INFO]: old server sucessfully connected
2025-08-11 17:00:01 [INFO]: sqs client sucess created
2025-08-11 17:00:05 [INFO]: Number of messages in the queue: 1
2025-08-11 17:00:07 [INFO]: item found in queue is if condition  14409
2025-08-11 17:00:07 [INFO]: item found in queue is  14409
2025-08-11 17:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEB+LprDdWJXH2oXm3kn0d6t1+LSsqyPGgb+INgxiCf5z/TAd4MbRxqJt1fl543uxhmdQBs43XyN1gVh9U/CoeoXSs4JmQ/rhrbPBPC7EACaI35RxURR08ntirEGFGxwotEnVZjeVJuHliVxsBjoWLos3lP2YXvg58F7x9+DVOzBuhpdZG+O313cCfMFV1R76evlNyeYs1bPkDHHxLzkZd+o4mnPqC9FISRz3ZT03ltERAs7XZDNZSFZTboTm5iSFQDsGJzumrnkblubhmIAqEUgHDZmcZugLEUlZPOFIWN0kluQShCHwPWkb5HgH7/l8WUIqGdoTxqa6r/5vfE1q8WVvNsX8WmTWtvsHPolrWtzVcYoTziQZGsJANVTX5ecRZZ2eTkcMKdFidrQ8nuB9QDHKKa64dLFKy2VYUJ9c47ESnw0srLLzsKB9JNMIjKSwwL
2025-08-11 17:00:07 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-11 17:00:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-11 17:00:07 [INFO]: inside itemsold and closed 14409
2025-08-11 17:00:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:00:09 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:00:09 [INFO]: Ebay item id :: 335519993374 exists in Database
2025-08-11 17:00:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:00:09 [INFO]: in processold action queue is array    for []
2025-08-11 17:00:09 [INFO]: Successfully processed data for user 14409
2025-08-11 17:00:09 [INFO]: Execution Started
2025-08-11 17:00:09 [INFO]: Execution Finished
2025-08-11 17:10:01 [INFO]: Execution Started
2025-08-11 17:10:01 [INFO]: old server sucessfully connected
2025-08-11 17:10:01 [INFO]: sqs client sucess created
2025-08-11 17:10:04 [INFO]: Number of messages in the queue: 3
2025-08-11 17:10:07 [INFO]: item found in queue is if condition  14409
2025-08-11 17:10:07 [INFO]: item found in queue is  14409
2025-08-11 17:10:08 [INFO]: Message deleted from the queue for receipt handle: AQEBQ84MWxbwiZVP/mdKXMbqEdI8UjUAM9a5gmMh+FVBq4qogmC8ysSptUoajVGvHYV9Ubrok2q/Q0XdWEzWi6SMuy1X6W3G6M5RqXiO2U0/xrRNUfsM494W4/gFWIu7vdgy9fGRWI9x9ufh8WQx4MvFzN+olfeGqvYoKfpDdZn0eSGwRQ2/JOqmmaYSbXCaSpvCB7zZDw9AK/pi2N6Wy/qgdukWd3nkIcv6mJ8p8a74bSRHVlDGb+wO0g33gXLK455+glDIyFDaOsIiYktRYHXlPVbgx0dZmRBjXkIMiMXL1Frwb3WR5MuGB1NjXxbqH9ly+rsqJLZ+WnOKS71D9ZJ6dP0X+7Xetbso6swbcW0N5225+kMsFMrDcNKFtYdYJI2A5DPLRMj7xqfsopqGMS0dq9fiN4taxoBVkU46KzRAT2YivGpRgHzNxNkr2iED6SNC
2025-08-11 17:10:08 [INFO]: item found in queue is if condition  14409
2025-08-11 17:10:08 [INFO]: item found in queue is  14409
2025-08-11 17:10:09 [INFO]: Message deleted from the queue for receipt handle: AQEBZUf373ttFq8AY9+ZbKlGkHU/5WkGHhq5KK8bVO6IcgPBqdyahiLTqy4W+rCSf0M3I2thSI+Khxn2Z7RN6JsIzoSp9Fv6tNwGx515afXhS6qLFj5zVf0MLRvmjY21yUlugftAUtnioVblYs5ALIMwEl89soisgVTjiam5ldVS19s3ig0KgEaPkUoEjyQT88jWAhAy1XHXjdNqOl0pbGXjIGcOF9KbVfiorEILYza45OqYZUG687Tm4feXksmUJE2H3IuIApAhmDURi30KqKlUjKmltIWMJfEvRbi+qtE+qzLSlkZkPMKD+Tr+epn1yU7rfxqg98RnM7e4cFWHp27AsW4qr7K4T3Z4qI0k5+sgEKt5ExiNZs7ZAMmWEfXtwYogaQKrRRKsZfG+jno5p49QQZ0X7iWhCIaF2ZEBmhC4bc2nW1GVhZm5C0gNKegO559K
2025-08-11 17:10:11 [INFO]: item found in queue is if condition  14409
2025-08-11 17:10:11 [INFO]: item found in queue is  14409
2025-08-11 17:10:11 [INFO]: Message deleted from the queue for receipt handle: AQEBgI8uanYVrHKmx701DZOXy1izSHsPok9qI8tB7zNldCWF9XRtdIaUayeKdfUsBAMpEKdGlms2GtTFMPRwl5+3gxOx5iYTtmY03DZVCdl0xzQPb294IsvAASYga2IJA1b9rAxr5MxT+8Fbw5HrGbUy09FnzMhFio1IrSZIE89I9UuFzi6mu9c9lv9nvIOEwKOgFT5OXu4EtazlYC2LQ+oTsdZyIepDLuc1pxp2XM5ZWS7L5V0nQOHl3HNHC2rqGQSSWzbvFzSRU339ZWBoLziBBEby3Js/wwqpG5tEtn8eMD0Tnbmi3227t5EQ11UyP6t2nQ40a/jg5wWWTJcW0NHlGJCm10/Qy8TWVxFouJw+qy7rjXSqT+Y3cq2bHdyuE3e6CtBsGL4yCC35mWgOXqFUDa4ZNKyhjpfbbqb4rsFn5eC2D5ZnfxgEhqrZ944H6AmA
2025-08-11 17:10:11 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-11 17:10:11 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-11 17:10:11 [INFO]: inside itemsold and closed 14409
2025-08-11 17:10:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:10:13 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:10:13 [INFO]: Ebay item id :: 286755267972 exists in Database
2025-08-11 17:10:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:10:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:10:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:10:13 [INFO]: inside itemsold and closed 14409
2025-08-11 17:10:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:10:15 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:10:15 [INFO]: Ebay item id :: 336114639844 exists in Database
2025-08-11 17:10:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:10:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:10:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:10:15 [INFO]: inside itemsold and closed 14409
2025-08-11 17:10:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:10:17 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:10:17 [INFO]: Ebay item id :: 336114639844 exists in Database
2025-08-11 17:10:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:10:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:10:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:10:17 [INFO]: in processold action queue is array    for {"45313900":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313900","ebayitemid":"286755267972","shopifyproductid":"8983662002398","variants":[{"price":"299.99","quantity":0,"weight":"18","shopifyproductid":"8983662002398","shopifyvariantid":"47433568190686","shopifyinventoryid":"49545400516830","shopifylocationid":"58450641063","product_id":"45313900","variant_id":"78266413","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313898":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313898","ebayitemid":"336114639844","shopifyproductid":"8983661838558","variants":[{"price":"344.55","quantity":0,"weight":"18","shopifyproductid":"8983661838558","shopifyvariantid":"47433567797470","shopifyinventoryid":"49545400123614","shopifylocationid":"58450641063","product_id":"45313898","variant_id":"78266411","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-11 17:10:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-11 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-11 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-11 17:10:17 [INFO]: Shopify Inventory id 49545400516830
2025-08-11 17:10:17 [INFO]: Shopify Location id 58450641063
2025-08-11 17:10:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-11 17:10:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T17:10:17Z","reason":"correction","changes":[{"name":"available","delta":-45},{"name":"on_hand","delta":-45}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-11 17:10:17 [INFO]: Change: available | Delta: -45
2025-08-11 17:10:17 [INFO]: Change: on_hand | Delta: -45
2025-08-11 17:10:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-11 17:10:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313900 and user_id = 14409 
2025-08-11 17:10:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266413 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-11 17:10:17 [INFO]: Shopify Inventory id 49545400123614
2025-08-11 17:10:17 [INFO]: Shopify Location id 58450641063
2025-08-11 17:10:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-11 17:10:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T17:10:17Z","reason":"correction","changes":[{"name":"available","delta":-38},{"name":"on_hand","delta":-38}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-11 17:10:17 [INFO]: Change: available | Delta: -38
2025-08-11 17:10:17 [INFO]: Change: on_hand | Delta: -38
2025-08-11 17:10:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-11 17:10:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313898 and user_id = 14409 
2025-08-11 17:10:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266411 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-11 17:10:17 [INFO]: updateIdsQuantity -> ["78266413","78266411"]
2025-08-11 17:10:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-11 17:10:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78266413 THEN 0 WHEN id = 78266411 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78266413 THEN 0 WHEN id = 78266411 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78266413,78266411)
2025-08-11 17:10:17 [INFO]: QUANTITY Updated IDs: 78266413, 78266411
2025-08-11 17:10:17 [INFO]: Successfully processed data for user 14409
2025-08-11 17:10:17 [INFO]: Execution Started
2025-08-11 17:10:17 [INFO]: Execution Finished
2025-08-11 17:20:01 [INFO]: Execution Started
2025-08-11 17:20:01 [INFO]: old server sucessfully connected
2025-08-11 17:20:01 [INFO]: sqs client sucess created
2025-08-11 17:20:03 [INFO]: Number of messages in the queue: 8
2025-08-11 17:20:05 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:05 [INFO]: item found in queue is  14409
2025-08-11 17:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBa7LLN7hUJ0eGkPDAPAHzYBuDY5LcvLkP/x120B+Db19gAKJvOKigAunK+PNl3hJgnkVg1O+juGFecOGs52FwkVD5+egqAY5HxKSUuuKihrR3uJr4eSpG68RffRS1zJ/5kz5rNaMkwUa35xpYaXdMp16xM6IY/uwLzhZO799uVpD2q/Delt0wNjsjT9ymFCf+8ubAD34XPJsg5u/3sBq0RjIWYW+8HqFaqXRJQT67A8x3nLChRqcydHEl8gYIF2aWVCmh4W45Au8o2YV5mBma5DmcrQIWAtYxafJMFKbYzolsmjjGIkGU5vfPvzPCYlk0qzIUrUyYUGwJcgsvxiXlQk1UJj614nei4MOc/JHv4D1yjTQKuGRj2HgULWFtcwnTV+iyLaakeL05KeiPLH4ppiMitlmfvlHWJpjSYL1xCadt9qK1OIvSKnqEku5V4PMR
2025-08-11 17:20:06 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:06 [INFO]: item found in queue is  14409
2025-08-11 17:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEBlpJx8gqvFwYLXz82Ht5gQHU/lvMf/sWPfAeK2rNR8nZdD20Bo6ZtFVTWm4jsJ417WmeMCuC1in47Lj9NDwOnQ/auWDSJU5DIRgMA7whEEfZ+yzFaaRkm82hEVIWGFpaKwibaWdiq/oJzM2GxMrlDv9sFf4PbIfFe1GtXel6YxxXhQoipEaZh4P3nLJ6f7f0W1I7G/Y6L7P1FD17N0cx3aS5yUPHsChAgXYsnAHuCX/7vTjFQJDXgv+CFqsNsvhIMQZHJ3L55lFsS5+Ph9zWwpx8urTxK5xyaxqOq01EtC9tqOkGxWAw6eb4F1rhgdJNo8C49lj9FYg5/fHwXBVHMiXE290Gy4XqhJTfZUixgXh3TiwNR6o+JkbEi5O1CNmMxqOOxABnj4Fsn8s91egdngClOa0gUuDeX9T1hVAsQYw+bbihStcuVl5nsGKv+5Hi/
2025-08-11 17:20:07 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:07 [INFO]: item found in queue is  14409
2025-08-11 17:20:09 [INFO]: Message deleted from the queue for receipt handle: AQEBZP1FttpplNFQLQH0lAx+JnGg5tEjOabNHlQC/4mjEQpZZGUfmm38mAtiX7dng9H+YmXjQKT6SmE6tHKfM2T6hDOsd6bsARJksSrejZ2DLHQEbiBuKIAN6VzD9tA7WEF27pQRbmbjztUoy44+Uk/inKnCq2vLwKLAAjoTeSQX/6eC1kSV0PhslJ+FvInQQTgOvLyav4Y0TT72E8TBnF80Z/5LuolijfBIs1fVGCxTbo/TjR8suP6u44gAkpQmJqym09Q9r2xukgezNvgs1ZIG8X887l1Ie7PU6N/cStQVEhjnhU/OiVH9iesdTBLjESufQ3jC2NIYA/5wMvT4dryS0la3+bcboCu7NRsEcQQbbWQXrE5h2/0AsnCrtbpNlb8bmMIrWdVoxjKpu3e/wf3BIUWpe7yzBO30tlRIOX4vuwwlkCY3dkr6c1mnwEA++tVL
2025-08-11 17:20:10 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:10 [INFO]: item found in queue is  14409
2025-08-11 17:20:11 [INFO]: Message deleted from the queue for receipt handle: AQEBcc5vTUazOHPE7AG6ppcXjULCaUxU1hfnQw0YuIRI6Tfi7+6tOkOBZEmfaEYeZ3jcSPLvnIQ/Z+4+QeVTqIetfW5lkCceWJ1RnEhVbdUPe9N4p2KKg1SLZ1ETjJrm6G8x9PvzAWSfzlTvZV0xk/1z/TNOPkVyFE2jGbupnQJk9hcJVdmZPJAsh3SHsnT/XVTEJ7ZTd/WIZhV+dveJ5J9nSIrjrQbQ41HBTwEG1NPQrSv8mtms8XBMmf+QKkMzPf/0FeUODAdnZ0i9xs1qKudzOMFUiVN2Dn0Wk79Xql9WWZiMFd5yUzYB3COUWsbacXxbRMKnyphLf6SByqlAEwsFdMQIeBSeKKXvvFdka09JwQFa+mfj4Z2JUHqiJunv6QpMqmt+d5v0iVubXghGUzVmQntZh9FnX+HuhzvLWfN9thfnNjdHD/X9eAnE75fGx+SN
2025-08-11 17:20:11 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:11 [INFO]: item found in queue is  14409
2025-08-11 17:20:12 [INFO]: Message deleted from the queue for receipt handle: AQEBqDMXrA3vu3//wG0jk9xKZis0bIqKlv0HGgtqVnd4h4hPeH7f4BvPiG5Dp/7ZAutaEuAR/+WrRfFPl9fwS6H1Y1ue5CjOi5buDFyfOGcZ7HRYaf7VeHKocYcKmAlWOrDmaIHxc85PM8Qo/LvGv7V1U5PM0Hlt2uVy4qrWamOdQD8S6FHxUwjBGPDnwLBUqcted6Rq2iWslMhI6dzeKfMarGPEibmPEFTmAKKseyHyjIlL7clFG9o+fOFYGdcAnuCmqmd6iLhtslugVYG3DI7eoTKl+o7f9D0KM0s/8gsx/Js/GGnsIvlEgBbevNWktvH29V1WoEVBok6z+IujskeJDdoQ8/KFi3TNtJ62oOY/zjZq9ax8pMH5AdrSMi4+qtM6HvF8zqRlttqVaGcfRjyrQrhtMtMibBanE7OabWsUyHzJzWvFALfLlLnq/c9jSuDp
2025-08-11 17:20:13 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:13 [INFO]: item found in queue is  14409
2025-08-11 17:20:14 [INFO]: Message deleted from the queue for receipt handle: AQEB5FaQ+D6xgRuqOY4MR1oxC1kL3syvuOmZfGt8N5vBLVeQkl+kp0ouG+rnY6jU+ytNyViqMNzR5neeBdO7TVCl7vJqRUUGMHSrzHWewZz7+qrlIKVybh6+1oeZmZnck2e3kfokSkUbngZRs6HCggT6q5gMMHY5Ls6bHn/GWBd83hPK94t+IzYTZnLlYz8qCjaecOvKxg5O30XWyeHj1PGD3ZaBFzOaEzbtq9aS/Tm0yJ+Udk7rNlqWbQs2OgAQRpRjtJPIpFpsfulci3KMCAX/dwDJl32YPOHPPXhVOHlzjZXqN6dX8QFRGzVivD5FUCrOFQv/HXsgM5Vmh/QpDETzXuYhA4xtRDjLlOTkTQclk0jZMQ6HgZgl13Hkis5Ra7ahwKR23exKSh19jnJs/U+/A/moWJplIvQtPAsjvV+sAPAKyvhdS5wZJiFyO+1C1MrJ
2025-08-11 17:20:14 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:14 [INFO]: item found in queue is  14409
2025-08-11 17:20:15 [INFO]: Message deleted from the queue for receipt handle: AQEBtJvqR+HAK4ge4SswvcK9YYY4suvEz0mPZLlmFWeEBc6uIYWWzqiCMG3T1UbwS2FLJSE7/yp8tnOU+J3sYmDXi438OO8AB1wZKCjdvkIcnHFmsiLa3MMooz9oEzifsKjFew94WYAHEBhfggWRHiBqjjPbpV58fTJKFtciYI2NCPByIeHrBXhtjEgs8J8GxFn17Be3iobAv7eH57FM7ZOeXXocfgO+x3rS/8Ztucc07g/ZjiD/cnq2C7aulLZoAlTYoQGaESOua7hqJ83hd3q229dZO1na+5+k0nl455DMDRqZzaNdxbrU6f/GLsJ84owGODseiR5B/+0TVKEsISAxq0IJPt0o4VCt5gViOXgD4qp+kjiD1pnRX+kF4Qx9qUL9AybOf3k5l59k8sUZ3EpkcPWYvq2+WRPKUV/tGfxmfymg+6lS9QI9z1+IzWuBr8xE
2025-08-11 17:20:15 [INFO]: item found in queue is if condition  14409
2025-08-11 17:20:15 [INFO]: item found in queue is  14409
2025-08-11 17:20:16 [INFO]: Message deleted from the queue for receipt handle: AQEBpjGW4k2XP1rmUdmIlcV1szPFeKFBU9VdtnbaeXpj/ifNBU5JQHIZCebcKwp/r/WTUR6RRYSIqDMcJemrqVVvwXBx3gvVAKstEe9vKngEOU68uMl7vnv+2ypcz+IfuP2WsMI9+x/y6byetJSJMl01bgYqcczgdIp52q/7RWbjkHlgzAjw30XfrITnhEpno7oeDC+2+siWy7vmTvLwru23G3DKOHsyIex8ZxCc6yX4tv6UbmWhz5XhR/StgXLm37dgbUhPCsV53YpKbM038q8HSyirU5gjBAMyEMOpEbf8nHIosw/cT5UrOnf2iH27wvy19dqgfYkrzD//vwIR7MAgMRw9p83BmcYkFto+k6kJnyPSZu96iNliadtIKzAUCzpXt34ROWAGvGV+kJH2E+gk0HpfP+6PGnyLAY7h2rlXsUo6u7+SFlqg8YUxQEbOYGUO
2025-08-11 17:20:16 [INFO]: Processed 8 messages, reached the limit of 8.
2025-08-11 17:20:16 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-11 17:20:16 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:18 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:18 [INFO]: Ebay item id :: 286066782996 exists in Database
2025-08-11 17:20:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:20:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:20:18 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:19 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:19 [INFO]: Ebay item id :: 306438550006 exists in Database
2025-08-11 17:20:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:20:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:20:19 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:21 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:21 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:21 [INFO]: Ebay item id :: 305790913865 exists in Database
2025-08-11 17:20:21 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:21 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-11 17:20:21 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:23 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:23 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:23 [INFO]: Ebay item id :: 305790913865 exists in Database
2025-08-11 17:20:23 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:23 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-11 17:20:23 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:25 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:25 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:25 [INFO]: Ebay item id :: 335779442653 exists in Database
2025-08-11 17:20:25 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:25 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:20:25 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:20:25 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:27 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:27 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:27 [INFO]: Ebay item id :: 334087469358 exists in Database
2025-08-11 17:20:27 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:27 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:20:27 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:29 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:29 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:29 [INFO]: Ebay item id :: 335779442653 exists in Database
2025-08-11 17:20:29 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:29 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:20:29 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:20:29 [INFO]: inside itemsold and closed 14409
2025-08-11 17:20:31 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:20:31 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:20:31 [INFO]: Ebay item id :: 334087469358 exists in Database
2025-08-11 17:20:31 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:20:31 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:20:31 [INFO]: in processold action queue is array    for {"44579054":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579054","ebayitemid":"286066782996","shopifyproductid":"8695051714782","variants":[{"price":"436.89","quantity":0,"weight":"18","shopifyproductid":"8695051714782","shopifyvariantid":"45933863370974","shopifyinventoryid":"48032314753246","shopifylocationid":"","product_id":"44579054","variant_id":"77471761","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313896":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313896","ebayitemid":"306438550006","shopifyproductid":"8983661740254","variants":[{"price":"345.99","quantity":0,"weight":"18","shopifyproductid":"8983661740254","shopifyvariantid":"47433566159070","shopifyinventoryid":"49545398485214","shopifylocationid":"58450641063","product_id":"45313896","variant_id":"78266409","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45143515":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45143515","ebayitemid":"305790913865","deleted":1}},"44585632":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44585632","ebayitemid":"335779442653","shopifyproductid":"8919602430174","variants":[{"price":"386.99","quantity":0,"weight":"18","shopifyproductid":"8919602430174","shopifyvariantid":"46759512834270","shopifyinventoryid":"48858022740190","shopifylocationid":"58450641063","product_id":"44585632","variant_id":"77478341","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-11 17:20:31 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-11 17:20:31 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-11 17:20:31 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-11 17:20:31 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-11 17:20:31 [INFO]: productIds WHich are having null productid -> [45143515]
2025-08-11 17:20:31 [INFO]: ebayItemIds WHich are not imported-> ["305790913865"]
2025-08-11 17:20:31 [INFO]: Entered in bulkUpdateProducts function
2025-08-11 17:20:31 [INFO]: Transaction started for bulkUpdateProducts
2025-08-11 17:20:31 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45143515)
2025-08-11 17:20:31 [INFO]: Query executed successfully. Affected rows: 0
2025-08-11 17:20:31 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-11 17:20:31 [INFO]: Transaction committed successfully.
2025-08-11 17:20:31 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-11 17:20:31 [INFO]: Shopify Inventory id 48032314753246
2025-08-11 17:20:31 [INFO]: Shopify Location id 58450641063
2025-08-11 17:20:31 [INFO]: QUANTITY FOR UPDATE 0
2025-08-11 17:20:31 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T17:20:31Z","reason":"correction","changes":[{"name":"available","delta":-42},{"name":"on_hand","delta":-42}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-11 17:20:31 [INFO]: Change: available | Delta: -42
2025-08-11 17:20:31 [INFO]: Change: on_hand | Delta: -42
2025-08-11 17:20:31 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-11 17:20:31 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579054 and user_id = 14409 
2025-08-11 17:20:31 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471761 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-11 17:20:31 [INFO]: Shopify Inventory id 49545398485214
2025-08-11 17:20:31 [INFO]: Shopify Location id 58450641063
2025-08-11 17:20:31 [INFO]: QUANTITY FOR UPDATE 0
2025-08-11 17:20:31 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T17:20:31Z","reason":"correction","changes":[{"name":"available","delta":-45},{"name":"on_hand","delta":-45}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-11 17:20:31 [INFO]: Change: available | Delta: -45
2025-08-11 17:20:31 [INFO]: Change: on_hand | Delta: -45
2025-08-11 17:20:31 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-11 17:20:31 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313896 and user_id = 14409 
2025-08-11 17:20:31 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266409 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-11 17:20:31 [INFO]: Shopify Inventory id 48858022740190
2025-08-11 17:20:31 [INFO]: Shopify Location id 58450641063
2025-08-11 17:20:31 [INFO]: QUANTITY FOR UPDATE 0
2025-08-11 17:20:32 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T17:20:32Z","reason":"correction","changes":[{"name":"available","delta":-42},{"name":"on_hand","delta":-42}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-11 17:20:32 [INFO]: Change: available | Delta: -42
2025-08-11 17:20:32 [INFO]: Change: on_hand | Delta: -42
2025-08-11 17:20:32 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-11 17:20:32 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44585632 and user_id = 14409 
2025-08-11 17:20:32 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77478341 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-11 17:20:32 [INFO]: updateIdsQuantity -> ["77471761","78266409","77478341"]
2025-08-11 17:20:32 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-11 17:20:32 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77471761 THEN 0 WHEN id = 78266409 THEN 0 WHEN id = 77478341 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77471761 THEN 0 WHEN id = 78266409 THEN 0 WHEN id = 77478341 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77471761,78266409,77478341)
2025-08-11 17:20:32 [INFO]: QUANTITY Updated IDs: 77471761, 78266409, 77478341
2025-08-11 17:20:32 [INFO]: Successfully processed data for user 14409
2025-08-11 17:20:32 [INFO]: Execution Started
2025-08-11 17:20:32 [INFO]: Execution Finished
2025-08-11 17:30:02 [INFO]: Execution Started
2025-08-11 17:30:02 [INFO]: old server sucessfully connected
2025-08-11 17:30:02 [INFO]: sqs client sucess created
2025-08-11 17:30:03 [INFO]: Number of messages in the queue: 0
2025-08-11 17:30:23 [INFO]: Execution Started
2025-08-11 17:30:23 [INFO]: Execution Finished
2025-08-11 17:40:01 [INFO]: Execution Started
2025-08-11 17:40:01 [INFO]: old server sucessfully connected
2025-08-11 17:40:01 [INFO]: sqs client sucess created
2025-08-11 17:40:04 [INFO]: Number of messages in the queue: 0
2025-08-11 17:40:24 [INFO]: Execution Started
2025-08-11 17:40:24 [INFO]: Execution Finished
2025-08-11 17:50:01 [INFO]: Execution Started
2025-08-11 17:50:01 [INFO]: old server sucessfully connected
2025-08-11 17:50:02 [INFO]: sqs client sucess created
2025-08-11 17:50:05 [INFO]: Number of messages in the queue: 1
2025-08-11 17:50:05 [INFO]: item found in queue is if condition  14409
2025-08-11 17:50:05 [INFO]: item found in queue is  14409
2025-08-11 17:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBIDaYBxV+e5/XFyhp5cIK3/ybPBofxU00CWtqOEYFf0iDujCrA6fH9QHoJlBRH99fw22rZi7Psm7KCvc6njzMC/kgNi0lHDXgCTPR+5HmhjcnJJV+xfaZ1FBrf7o2hrerNWDpG/Bkz22V4nlssttYJJmPtbJbL2xA4yqJQ8D0lkmo+Im/IVsFA44qMinJ/F0IjwGzK4iv+SJix092Z7Cdp0p9smtlc4arNMp3JsEfz6V6Z1t6cR1KnzMSPUyXxBJ5TCqNqRlu1e2mhp2sTJGmMhBLlx+3sD4mY1TZKrATPTa90y2SWhMh+HQ8czw5K+czvek7wOno8va4nmSxsUyoO/cOOfmALpeh4/lRg3/XtVKKxqFpUxtoU3Jcn2lFzBWsdpNEV1Em9ZpoTfkLmC8QDOkVAnRG+Ie10jG9kB4mBC00PdUERBNx2pVXDkW1zwD+
2025-08-11 17:50:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-11 17:50:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-11 17:50:06 [INFO]: inside itemsold and closed 14409
2025-08-11 17:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-11 17:50:07 [INFO]: autolink for user_id 14409 is 1
2025-08-11 17:50:07 [INFO]: Ebay item id :: 226915274941 exists in Database
2025-08-11 17:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-11 17:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-11 17:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-11 17:50:07 [INFO]: in processold action queue is array    for {"44669939":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44669939","ebayitemid":"226915274941","shopifyproductid":"8885226078430","variants":[{"price":"49.99","quantity":0,"weight":"0.5","shopifyproductid":"8885226078430","shopifyvariantid":"46639635038430","shopifyinventoryid":"48742600474846","shopifylocationid":"","product_id":"44669939","variant_id":"77575159","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-11 17:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-11 17:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-11 17:50:08 [INFO]: Shopify Inventory id 48742600474846
2025-08-11 17:50:08 [INFO]: Shopify Location id 58450641063
2025-08-11 17:50:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-11 17:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T17:50: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-11 17:50:08 [INFO]: Change: available | Delta: -1
2025-08-11 17:50:08 [INFO]: Change: on_hand | Delta: -1
2025-08-11 17:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-11 17:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44669939 and user_id = 14409 
2025-08-11 17:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575159 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-11 17:50:08 [INFO]: updateIdsQuantity -> ["77575159"]
2025-08-11 17:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-11 17:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77575159 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77575159 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77575159)
2025-08-11 17:50:08 [INFO]: QUANTITY Updated IDs: 77575159
2025-08-11 17:50:08 [INFO]: Successfully processed data for user 14409
2025-08-11 17:50:08 [INFO]: Execution Started
2025-08-11 17:50:08 [INFO]: Execution Finished