2025-08-01 11:00:02 [INFO]: Execution Started
2025-08-01 11:00:02 [INFO]: old server sucessfully connected
2025-08-01 11:00:02 [INFO]: sqs client sucess created
2025-08-01 11:00:03 [INFO]: Number of messages in the queue: 0
2025-08-01 11:00:23 [INFO]: Execution Started
2025-08-01 11:00:23 [INFO]: Execution Finished
2025-08-01 11:10:02 [INFO]: Execution Started
2025-08-01 11:10:02 [INFO]: old server sucessfully connected
2025-08-01 11:10:02 [INFO]: sqs client sucess created
2025-08-01 11:10:03 [INFO]: Number of messages in the queue: 0
2025-08-01 11:10:23 [INFO]: Execution Started
2025-08-01 11:10:23 [INFO]: Execution Finished
2025-08-01 11:20:01 [INFO]: Execution Started
2025-08-01 11:20:01 [INFO]: old server sucessfully connected
2025-08-01 11:20:01 [INFO]: sqs client sucess created
2025-08-01 11:20:02 [INFO]: Number of messages in the queue: 0
2025-08-01 11:20:23 [INFO]: Execution Started
2025-08-01 11:20:23 [INFO]: Execution Finished
2025-08-01 11:30:02 [INFO]: Execution Started
2025-08-01 11:30:02 [INFO]: old server sucessfully connected
2025-08-01 11:30:02 [INFO]: sqs client sucess created
2025-08-01 11:30:03 [INFO]: Number of messages in the queue: 2
2025-08-01 11:30:04 [INFO]: item found in queue is if condition  14409
2025-08-01 11:30:04 [INFO]: item found in queue is  14409
2025-08-01 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBC5snaG5+qWlwBMwUknWmhUqPPnfHnYWBCEw8ShL7FoP6UDyGKlzf3oI/vAY5lA+8wB5epCbVVdFPUux/z8acTYkHvVM7PB2kMcLNm/OvlmqSa7CVGDdTgjbEDIVNNqH3tJx/easiVcxCfEByf3CbM3Pms+bXBScqkFrMmBMYpDllkbdycsoAgbLxJ+FD3yBMG4UGUjVk4Xh+mMpZju+t6pBN49rOoCdmImbQ6nIKZRixly/X7fxtuJjVXq6z2erMUjjWAUpVbvZuYxHRAELu2CQu0kPrYsZdfN0er5UgkWswdT2755rij8adJ0XOYntPPQzv40rQCu8Vd7YoJ8rm2xVVoipgGyRLgTA7ZLDp8fF+9NoGD8m3GCBAtE468HsiRwUbwIKpiZyd5reUv5i/qaOKGmCuumSguz1nG5wzCNCel8paYGqaCKsUoa6xK20m
2025-08-01 11:30:04 [INFO]: item found in queue is if condition  14409
2025-08-01 11:30:04 [INFO]: item found in queue is  14409
2025-08-01 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBq0q+vtWmLGIJHnC3oNabEaMVD2kJuKH3YQt1sB4R87sM/Lbh5BwhnCUXw37U0+RDX9sxCDedY4wRiIh4vpngkRWgGiYXGwWcS7ctFIsAjUhpCgXh46UP5Ee5veOlHajdcDAR3Eqr7JQcFgU0CAvorQ7LrMh5HJBrefdPrZE/Z4NGKy9Wcq7KKi286BYZUilVHcUq2SDtqcEaBCp3YyKFK1bGeDh61rnz9V84IXeeQ36STjBySu5uplmLTmtoW6V1Upa0Erj6Sbw+ghVC+w2zgSAiJ85Y39DYRVJNpGEBhYi0Lf51uy8BV7i63PEtAWa73kFmcQ7uys89ZmdFSXC8CWH1FSvoT/4JXl81ICVf5u2rlbDJjn8PnZRYp7jwGDhQlrDgu+/P6dMzELWhQf00A8/REGiS/2z/ng8at/+hXOCOSh5Wkrs/s5L2+hyM/DVZ
2025-08-01 11:30:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-01 11:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 11:30:04 [INFO]: inside itemsold and closed 14409
2025-08-01 11:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:30:07 [INFO]: Ebay item id :: 326224407523 exists in Database
2025-08-01 11:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:30:07 [INFO]: inside itemsold and closed 14409
2025-08-01 11:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:30:09 [INFO]: Ebay item id :: 326231212720 exists in Database
2025-08-01 11:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:30:09 [INFO]: in processold action queue is array    for {"44735294":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735294","ebayitemid":"326224407523","shopifyproductid":"8694996566238","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8694996566238","shopifyvariantid":"45933734363358","shopifyinventoryid":"48032185778398","shopifylocationid":"","product_id":"44735294","variant_id":"77643201","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641827":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641827","ebayitemid":"326231212720","shopifyproductid":"8047619571934","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8047619571934","shopifyvariantid":"44200716173534","shopifyinventoryid":"46297791430878","shopifylocationid":"","product_id":"44641827","variant_id":"77547016","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 11:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 11:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:30:09 [INFO]: Shopify Inventory id 48032185778398
2025-08-01 11:30:09 [INFO]: Shopify Location id 58450641063
2025-08-01 11:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11: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 11:30:09 [INFO]: Change: available | Delta: -1
2025-08-01 11:30:09 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735294 and user_id = 14409 
2025-08-01 11:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643201 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:30:09 [INFO]: Shopify Inventory id 46297791430878
2025-08-01 11:30:09 [INFO]: Shopify Location id 58450641063
2025-08-01 11:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11: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 11:30:09 [INFO]: Change: available | Delta: -1
2025-08-01 11:30:09 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641827 and user_id = 14409 
2025-08-01 11:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547016 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:30:09 [INFO]: updateIdsQuantity -> ["77643201","77547016"]
2025-08-01 11:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-01 11:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77643201 THEN 0 WHEN id = 77547016 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77643201 THEN 0 WHEN id = 77547016 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77643201,77547016)
2025-08-01 11:30:09 [INFO]: QUANTITY Updated IDs: 77643201, 77547016
2025-08-01 11:30:09 [INFO]: Successfully processed data for user 14409
2025-08-01 11:30:09 [INFO]: Execution Started
2025-08-01 11:30:09 [INFO]: Execution Finished
2025-08-01 11:40:01 [INFO]: Execution Started
2025-08-01 11:40:01 [INFO]: old server sucessfully connected
2025-08-01 11:40:02 [INFO]: sqs client sucess created
2025-08-01 11:40:03 [INFO]: Number of messages in the queue: 0
2025-08-01 11:40:23 [INFO]: Execution Started
2025-08-01 11:40:23 [INFO]: Execution Finished
2025-08-01 11:50:02 [INFO]: Execution Started
2025-08-01 11:50:02 [INFO]: old server sucessfully connected
2025-08-01 11:50:02 [INFO]: sqs client sucess created
2025-08-01 11:50:03 [INFO]: Number of messages in the queue: 5
2025-08-01 11:50:03 [INFO]: item found in queue is if condition  14409
2025-08-01 11:50:03 [INFO]: item found in queue is  14409
2025-08-01 11:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBkkuznj67mPkaQ15ZLzkL4a0lCnE33pNh/BUHzc8L5a9RkDztNLx7DwJAuKbiqBwcPPhacDUezW4VM3qMeJlO4ikR12SsgQtmOsh0rK7HnRAdwJkiypdQZ4WgaBciZrgPD0id7Tn+KMdDMRlcoiRvpFzhHjYhmqSnk0ftVrhkVnpB8to3WwxJsUU9L2oWWhD2Uo0zY8y/7mL6cZdsvh7MiPkWSc+uIvEZG8Meksas+wXFPY8Ne/xHOikuCy7q281EJ/+H7PF4ZIF3jW3ybRS1Jxjv9ZEX73LUX5GFPzoIOxP86Ogab3vVZSRxrqpX4x/n/JWtDIllqpiT61zG5PvJBj5nu+96iE3sEePwBaZry3U1nPitgggH0hqFJa/jT715UUegBWywhafNVLv8wps6yeeES14AdlQmVCKKkUPm4pCVM1BNmeEeq6Y3Xewb96hq
2025-08-01 11:50:04 [INFO]: item found in queue is if condition  14409
2025-08-01 11:50:04 [INFO]: item found in queue is  14409
2025-08-01 11:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBTTnfUWy2wMG++ugxpnppQJZNMnwsiGDvkdLogwQ5ItdjfDbzhI6jKOxCehLVqh5mpcxZr/dk1/ujyncbHD3busbPTRK0CGLCDR4xV+6RIU32rXqONIiDqMTk7LeM6Yn5BsOV3H/hDJuydw/JEu40zQ5NBX68dE04ynv7hZBEoqw/HsLxnPDXrc9QTL7HWThWI6ha1/ayP/mg13j2xtph5cPHuWzBGtf04kd+m5n6/5OuInhUVWVCsbu18iENzGi3L8fAJhoz6yob+al4C6ms+1dpb/jbmjfr2PMZeBOszKRHCqHRiCQzSPdtBT6oV/O/SjZtwEtv+RWH2ohO636gFyxh4/sPsxp/guRPGvzWM5cvRwO0lMkdfpTH3DABU/1Y2yDhChhNUMmp3OwcQKNFdoAuXj7pg/D0DGLt4yNBITIrpEMftgOJnwYifR+p8Rdt
2025-08-01 11:50:04 [INFO]: item found in queue is if condition  14409
2025-08-01 11:50:04 [INFO]: item found in queue is  14409
2025-08-01 11:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB/qORUl5CzwfVCkI75D+h18xm0T4H4TUkY1/IIyvN5zwM8BmHM74LZz9phs8lUUUNcxN/seWXB94B8CZ3EuG6lgCoNYBAXqTNrDqigvuM5atnbbg749x1aKwdD+M+P4orEtSAq6qGxjj8n/pAgU3OYZjogbVXHAX45MU8XWYpl5P+VZV4+x/UXk37S9mrDddB1UnFJxQV8tjcRZbkPCrM/le4nFSldYpMlFv5q5l21+hcVLw8MXAtOXyWWKLn2zzPKNO0DI60jXpK6TW9KmEo4m/PYWlK0oUiXZ7PWl5EJPHhHBUlt/20Xo2t5hK1qPSG7E5dbmVzUs2ftsJFzpT6BQmOHcknHdO8U6oR1jCZBhBm4mTvbOBoU0CCzv7UBYoqzGTRaepd35TBeHRW7Hw6bQw2eRaB0RTR9zOHgaxQ1ppbIIGYdrhJodjh2e+LOEFv
2025-08-01 11:50:05 [INFO]: item found in queue is if condition  14409
2025-08-01 11:50:05 [INFO]: item found in queue is  14409
2025-08-01 11:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBvcVNr2SC9zmIbJmduQiPnY1e8W95/DsYRVl8G9RGGR0bYQoRUVWZyd3u6o3yG3TkfWISyMpkXmpMo0O6mTiqAhFnnVSKL9M+RnjsT3mM8jUGJoQY4Pd+BOkbgG6AawHvUHqq7jHp6TKx3VZWo0TmdK2vFOlCYBne4we7YwcdeJsgFj4H1GsyAzVdaG5Xq1pmz7nCLUAmTiL0cDr9Cr/p3vx2eHKM85GMeJ7TTaN5oyxeCVeah899jN3XvCF1+FVDRn+2bRMgOkZu+tNMWgFX80XPCvUQc8M2fsyWlWGCqGFEBIaWsklYySYRPogujVFd9A3few+XOEapeS6ODYqhrkHBGU9gxlB5CI81yzyRlyFYZ2cyCN3243paHN/y79eW0L9P6O0PtB0Ck/IaPd2F89/56HGpPaCIutxNPlHP5DCgiMZolRDAtOI0yHiS4Z9g
2025-08-01 11:50:05 [INFO]: item found in queue is if condition  14409
2025-08-01 11:50:05 [INFO]: item found in queue is  14409
2025-08-01 11:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBXpmjKpcCZRyzHHyCPCwtFIlw8W1fP4CBxnCJoc1TDwaZVhL7KbgFv//CPxRyB6YSqI9tknmPIITQ1Kh4ss2Sj6V42nazyki/WUO9j61BRaKheT8+hDnEO67sMcBUaiu2e9Ef7QELhllP2rwUliYp67wWTcS/bOwvoZe6qhZ6wB9/6bBfGongqYIMSkEEdXCKaKp6wpgDZ6ZjvejmNVsxc96eKlqUvEITFlGsTvrUVtzGVar6Vlo0+O0YXND86vY3d+W3o0xtYzzB9wW5jYPoz/kgj4WUZBtR5fBq2FsVb9ludLu9YXSBoYJOu/nAzyOxtOi2AiTqVNvtQWyIi6a2KW7Gl1ylLZoUey58O5Q1d/BlbsqmiUSfaoSB6zwAjN0aeFit2KGd24sbPtTJpxjxb0iH3xQzgGxB9RRxwxkke2Ek0P6BON88Gf47rP9jkG+j
2025-08-01 11:50:05 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-01 11:50:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-01 11:50:05 [INFO]: inside itemsold and closed 14409
2025-08-01 11:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:50:07 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:50:07 [INFO]: Ebay item id :: 326231215887 exists in Database
2025-08-01 11:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:50:07 [INFO]: inside itemsold and closed 14409
2025-08-01 11:50:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:50:10 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:50:10 [INFO]: Ebay item id :: 326231214509 exists in Database
2025-08-01 11:50:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:50:10 [INFO]: inside itemsold and closed 14409
2025-08-01 11:50:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:50:11 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:50:11 [INFO]: Ebay item id :: 226290330467 exists in Database
2025-08-01 11:50:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:50:11 [INFO]: inside itemsold and closed 14409
2025-08-01 11:50:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:50:13 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:50:13 [INFO]: Ebay item id :: 226290328554 exists in Database
2025-08-01 11:50:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:50:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:50:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:50:13 [INFO]: inside itemsold and closed 14409
2025-08-01 11:50:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-01 11:50:15 [INFO]: autolink for user_id 14409 is 1
2025-08-01 11:50:15 [INFO]: Ebay item id :: 326231220238 exists in Database
2025-08-01 11:50:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-01 11:50:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-01 11:50:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-01 11:50:15 [INFO]: in processold action queue is array    for {"44641831":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641831","ebayitemid":"326231215887","shopifyproductid":"8091353841886","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8091353841886","shopifyvariantid":"44275708133598","shopifyinventoryid":"46372874682590","shopifylocationid":"","product_id":"44641831","variant_id":"77547020","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641829":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641829","ebayitemid":"326231214509","shopifyproductid":"7109084774567","variants":[{"price":"117.99","quantity":0,"weight":"3","shopifyproductid":"7109084774567","shopifyvariantid":"41573457395879","shopifyinventoryid":"43670052602023","shopifylocationid":"","product_id":"44641829","variant_id":"77547018","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641837":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641837","ebayitemid":"226290330467","shopifyproductid":"8105344172254","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8105344172254","shopifyvariantid":"44301327597790","shopifyinventoryid":"46398685544670","shopifylocationid":"","product_id":"44641837","variant_id":"77547026","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641835":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641835","ebayitemid":"226290328554","shopifyproductid":"8091477999838","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8091477999838","shopifyvariantid":"44275918405854","shopifyinventoryid":"46373084987614","shopifylocationid":"","product_id":"44641835","variant_id":"77547024","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641839":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641839","ebayitemid":"326231220238","shopifyproductid":"8920746754270","variants":[{"price":"116.99","quantity":0,"weight":"3","shopifyproductid":"8920746754270","shopifyvariantid":"46785288863966","shopifyinventoryid":"48883800572126","shopifylocationid":"58450641063","product_id":"44641839","variant_id":"77547028","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-01 11:50:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-01 11:50:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:50:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:50:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:50:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:50:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-01 11:50:15 [INFO]: Shopify Inventory id 46372874682590
2025-08-01 11:50:15 [INFO]: Shopify Location id 58450641063
2025-08-01 11:50:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:50:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11:50:16Z","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 11:50:16 [INFO]: Change: available | Delta: -1
2025-08-01 11:50:16 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:50:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:50:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641831 and user_id = 14409 
2025-08-01 11:50:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547020 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:50:16 [INFO]: Shopify Inventory id 43670052602023
2025-08-01 11:50:16 [INFO]: Shopify Location id 58450641063
2025-08-01 11:50:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:50:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11:50:16Z","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 11:50:16 [INFO]: Change: available | Delta: -1
2025-08-01 11:50:16 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:50:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:50:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641829 and user_id = 14409 
2025-08-01 11:50:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547018 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:50:16 [INFO]: Shopify Inventory id 46398685544670
2025-08-01 11:50:16 [INFO]: Shopify Location id 58450641063
2025-08-01 11:50:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:50:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11:50:16Z","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 11:50:16 [INFO]: Change: available | Delta: -1
2025-08-01 11:50:16 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:50:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:50:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641837 and user_id = 14409 
2025-08-01 11:50:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547026 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:50:16 [INFO]: Shopify Inventory id 46373084987614
2025-08-01 11:50:16 [INFO]: Shopify Location id 58450641063
2025-08-01 11:50:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:50:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11:50:16Z","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 11:50:17 [INFO]: Change: available | Delta: -1
2025-08-01 11:50:17 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:50:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:50:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641835 and user_id = 14409 
2025-08-01 11:50:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547024 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:50:17 [INFO]: Shopify Inventory id 48883800572126
2025-08-01 11:50:17 [INFO]: Shopify Location id 58450641063
2025-08-01 11:50:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-01 11:50:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T11:50:17Z","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 11:50:17 [INFO]: Change: available | Delta: -1
2025-08-01 11:50:17 [INFO]: Change: on_hand | Delta: -1
2025-08-01 11:50:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-01 11:50:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641839 and user_id = 14409 
2025-08-01 11:50:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547028 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-01 11:50:17 [INFO]: updateIdsQuantity -> ["77547020","77547018","77547026","77547024","77547028"]
2025-08-01 11:50:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5
2025-08-01 11:50:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77547020 THEN 0 WHEN id = 77547018 THEN 0 WHEN id = 77547026 THEN 0 WHEN id = 77547024 THEN 0 WHEN id = 77547028 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77547020 THEN 0 WHEN id = 77547018 THEN 0 WHEN id = 77547026 THEN 0 WHEN id = 77547024 THEN 0 WHEN id = 77547028 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77547020,77547018,77547026,77547024,77547028)
2025-08-01 11:50:17 [INFO]: QUANTITY Updated IDs: 77547020, 77547018, 77547026, 77547024, 77547028
2025-08-01 11:50:17 [INFO]: Successfully processed data for user 14409
2025-08-01 11:50:17 [INFO]: Execution Started
2025-08-01 11:50:17 [INFO]: Execution Finished