2025-08-13 17:00:01 [INFO]: Execution Started
2025-08-13 17:00:01 [INFO]: old server sucessfully connected
2025-08-13 17:00:02 [INFO]: sqs client sucess created
2025-08-13 17:00:04 [INFO]: Number of messages in the queue: 1
2025-08-13 17:00:04 [INFO]: item found in queue is if condition  14409
2025-08-13 17:00:04 [INFO]: item found in queue is  14409
2025-08-13 17:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBWQwX52lFhAeF33kf1N2yich8zPxbxEatOc6PazEbQDw4L5XjzAwxkHzQzhKsxu4zXYforWzmtt1L4hc+kfEXTpK8n5FzhihTpRnZ2P32ZU0sQtJFvdpvSpFtXIBLOnde8O3nndfFkhpmSa7TKN6SJQts0oN6z8BtU8S7aOnzN38U2CBbhDIHqVYBOYpMoACQZ1rCKMOe5ncx//ObN6iONbt4yTC2fi7uMjIJHVLnWraxpd5VBGyntzEPU28LPnV3nY3NoRiQWxwRduGVlHZqtJaJxyg0buczJxjgfDcHiT4tJIvtKP+MzMV/CGCTwr0bYsgYCr9p1LaPfXR80hjT7qKzjFli5roXkaP0i7k9w2Y6ZtJ89igyjzev/EwQhTZCzh5e+rYtFI4OidkJNZvgmvsaJdOc0y17vpXMGWMktMOju7+1FBBIhelLmv4zff7j
2025-08-13 17:00:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-13 17:00:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 17:00:06 [INFO]: inside itemsold and closed 14409
2025-08-13 17:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:00:08 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:00:08 [INFO]: Ebay item id :: 326565920754 exists in Database
2025-08-13 17:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:00:08 [INFO]: in processold action queue is array    for {"44737823":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737823","ebayitemid":"326565920754","shopifyproductid":"8925465116894","variants":[{"price":"11.99","quantity":0,"weight":"0.75","shopifyproductid":"8925465116894","shopifyvariantid":"46835547275486","shopifyinventoryid":"48934035259614","shopifylocationid":"58450641063","product_id":"44737823","variant_id":"77645760","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 17:00:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 17:00:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:00:08 [INFO]: Shopify Inventory id 48934035259614
2025-08-13 17:00:08 [INFO]: Shopify Location id 58450641063
2025-08-13 17:00:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:00:08 [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-13 17:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737823 and user_id = 14409 
2025-08-13 17:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645760 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:00:08 [INFO]: updateIdsQuantity -> ["77645760"]
2025-08-13 17:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-13 17:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77645760 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77645760 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77645760)
2025-08-13 17:00:08 [INFO]: QUANTITY Updated IDs: 77645760
2025-08-13 17:00:08 [INFO]: Successfully processed data for user 14409
2025-08-13 17:00:08 [INFO]: Execution Started
2025-08-13 17:00:08 [INFO]: Execution Finished
2025-08-13 17:10:01 [INFO]: Execution Started
2025-08-13 17:10:01 [INFO]: old server sucessfully connected
2025-08-13 17:10:01 [INFO]: sqs client sucess created
2025-08-13 17:10:02 [INFO]: Number of messages in the queue: 1
2025-08-13 17:10:02 [INFO]: item found in queue is if condition  14409
2025-08-13 17:10:02 [INFO]: item found in queue is  14409
2025-08-13 17:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEBlAElRMdGvMOZP3yQILjUumvArhbwZM10J6e8MAndrFe1smApKkHzijR2xpWBEEWTtGYd0pVTH3ZwE0NFLyrZ/bwdKvK3ekGjMyc+ikjBzaeu2/cofnrYrhVVYS1wbzh8OM2FfyTcSpITgg30KuvjFyqCO1lZXOSLp04NgX9rg7GKhSFyqBKNoYEUmc1RJkW2rR+YIjiueHNAVlxMRw/S2DfPr4fwSZ8hz/m1aOyblLRF2gg2L26o8NR9jDgK33A6mG8As3CX7X1q6dWpaodFw3/1VGikl4nVODCm2DRKv6J4VoirDCNNnwjvsxvfopjq2Xp/M1R8toRioq7iBgOPv+PVMzxo05286WGrRgKvhiZQKUHZvfJsCu5PO0lXDnQiIsa9wXwDN13MuhHVqZC5UcrITEQOOqQqXbnXoL+3PUDYkagclNzPm1i36M3KoCyX
2025-08-13 17:10:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-13 17:10:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 17:10:02 [INFO]: inside itemsold and closed 14409
2025-08-13 17:10:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:10:04 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:10:04 [INFO]: Ebay item id :: 405497297339 exists in Database
2025-08-13 17:10:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:10:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:10:04 [INFO]: in processold action queue is array    for {"44672467":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44672467","ebayitemid":"405497297339","shopifyproductid":"7039596101799","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"7039596101799","shopifyvariantid":"41288284078247","shopifyinventoryid":"43384549474471","shopifylocationid":"","product_id":"44672467","variant_id":"77577687","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 17:10:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 17:10:04 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:10:04 [INFO]: Shopify Inventory id 43384549474471
2025-08-13 17:10:04 [INFO]: Shopify Location id 58450641063
2025-08-13 17:10:04 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-13 17:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44672467 and user_id = 14409 
2025-08-13 17:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77577687 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:10:05 [INFO]: updateIdsQuantity -> ["77577687"]
2025-08-13 17:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-13 17:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77577687 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77577687 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77577687)
2025-08-13 17:10:05 [INFO]: QUANTITY Updated IDs: 77577687
2025-08-13 17:10:05 [INFO]: Successfully processed data for user 14409
2025-08-13 17:10:05 [INFO]: Execution Started
2025-08-13 17:10:05 [INFO]: Execution Finished
2025-08-13 17:20:01 [INFO]: Execution Started
2025-08-13 17:20:01 [INFO]: old server sucessfully connected
2025-08-13 17:20:01 [INFO]: sqs client sucess created
2025-08-13 17:20:04 [INFO]: Number of messages in the queue: 0
2025-08-13 17:20:24 [INFO]: Execution Started
2025-08-13 17:20:24 [INFO]: Execution Finished
2025-08-13 17:30:01 [INFO]: Execution Started
2025-08-13 17:30:01 [INFO]: old server sucessfully connected
2025-08-13 17:30:01 [INFO]: sqs client sucess created
2025-08-13 17:30:02 [INFO]: Number of messages in the queue: 3
2025-08-13 17:30:02 [INFO]: item found in queue is if condition  14409
2025-08-13 17:30:02 [INFO]: item found in queue is  14409
2025-08-13 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8zrAOPQwN+y81vgph8ZlhVp/tp4/1l1K+sgF1x1BD/vua37Jik8uXlbNoPswDkzUmwnhsOU5E4PV6L40UDkeefD93zMjsWi34pgM+LExDioZKKTI60/RDTQLQ0NuV+ON1ORk/8ie5GKsMmotG4FLfiUv89OobHq++8tPd+E/ifeFCI1Q4RIjppyKi3s4D/+4F66xYLo75T05l1NUc8RXq734NUoFCHvuR5TZeUCWNYBmr2JjMvmXnJJgXAG/fccCZLNnb16/Y5MnGP/4XzP/NXuQ0eeajARggwLUg/slBLbfObbEsyeQ+XbP79mFq+cJH0nWWNEMb2omHYybD40C8HAqbXP+tnOT3GFElXaK/p4tJVg7gfGKb9RUwhUEypzSPW67nrVR0I4chs5kbKnjymcMezhbrqhf/0KVLR9gGymGvDUDzNfPn6FxYLNAONSq
2025-08-13 17:30:03 [INFO]: item found in queue is if condition  14409
2025-08-13 17:30:03 [INFO]: item found in queue is  14409
2025-08-13 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWuwleULWXS77bVPuwIf/BGa22z/3pTTK/mGJJ8ts+yrOGZJMv8lgZ7hGPCb6ccmaXkr7z5AVJmvQkcw2Lpa8fIN0fPOfhH5aHf9TGmAwGNorrstXXIzVn1Ckr91EUc+2Bd3KFNRnm8WxzTiVUexEG3avRdl1/SzN0r+xvEmuW/VyfYtuqe8jCHvY1USuq7oVA2cx4eT3Kf1zxccDBbZMv0pl32CK8DuoxV4EFTYU8HHOBS8MVLLKLamaG9vxGAoI/QinaKr7TSdZdX1itUSMqVRTxQ8D4VYpzZgdrQa+I3kFs7ZLuv5TCX0zKoTvHPX5XrrQG/9WaBycPoAlQ1rbtWrn7GlVtTZKVRG1qlD0nxVPsP4nwv6/5ZXMDspBH+N2hdVRkvn4u3JBx6d/RxIzQB24fdDJjjYr6uZcjyyCH0dxd3as4Y/66LR1peZM8IIb
2025-08-13 17:30:03 [INFO]: item found in queue is if condition  14409
2025-08-13 17:30:03 [INFO]: item found in queue is  14409
2025-08-13 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB6BA2wcL3HjvzTQOTBL3Yld6UYlhXu/5zQ8Xlt8oe1cFn2koliW/wS/1I7a4pa9gHo2FkpnoBOngWdcgkQ7E8V7j79BK3425x3eJwAPF4fTzh8cLFS6FRx3FeTffF1E35FbD50gdqGnXcp/JKx8lM2wcQJj3ZNrZW9ORp+7NrRwf4uePJfdCNiA1eYSNEDCfEZoP/P7uFQLSRBJ2ehc+XHn0r6FXcBi0kyG6ZuLcl+rtOi9g9A/NmcLBYYZKiwH7yFaVHlY0BsNdkAtFxAA19YISWvLYYqyLEzU7D2eajfpgqOxUOkxFT057N67rLNkndDH4NZkMpJRo8eqjPjkz5lVhDl5eqFeOxeOdd3KNSCjUpH8vxTAwHLaBSkXD/2NjHsTj93+ac7M3pb4gFVp2cENyeZxrg5TehxVavmeuAYYukI4/L7Gv+T6QjMXfL8SDs
2025-08-13 17:30:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-13 17:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 17:30:04 [INFO]: inside itemsold and closed 14409
2025-08-13 17:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:30:06 [INFO]: Ebay item id :: 335471404314 exists in Database
2025-08-13 17:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:30:06 [INFO]: inside itemsold and closed 14409
2025-08-13 17:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:30:07 [INFO]: Ebay item id :: 404907977077 exists in Database
2025-08-13 17:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:30:07 [INFO]: inside itemsold and closed 14409
2025-08-13 17:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:30:09 [INFO]: Ebay item id :: 286056560327 exists in Database
2025-08-13 17:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:30:09 [INFO]: in processold action queue is array    for {"44557749":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557749","ebayitemid":"335471404314","shopifyproductid":"7563418894558","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7563418894558","shopifyvariantid":"42489924157662","shopifyinventoryid":"44583852507358","shopifylocationid":"","product_id":"44557749","variant_id":"77450429","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772396":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772396","ebayitemid":"404907977077","shopifyproductid":"8378540687582","variants":[{"price":"122.99","quantity":0,"weight":"3","shopifyproductid":"8378540687582","shopifyvariantid":"45093953765598","shopifyinventoryid":"47191816896734","shopifylocationid":"","product_id":"44772396","variant_id":"77680938","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44775574":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775574","ebayitemid":"286056560327","shopifyproductid":"8697465241822","variants":[{"price":"39.99","quantity":0,"weight":"4","shopifyproductid":"8697465241822","shopifyvariantid":"45939238306014","shopifyinventoryid":"48037694767326","shopifylocationid":"","product_id":"44775574","variant_id":"77684116","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 17:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 17:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:30:09 [INFO]: Shopify Inventory id 44583852507358
2025-08-13 17:30:09 [INFO]: Shopify Location id 58450641063
2025-08-13 17:30:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-13 17:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557749 and user_id = 14409 
2025-08-13 17:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77450429 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:30:10 [INFO]: Shopify Inventory id 47191816896734
2025-08-13 17:30:10 [INFO]: Shopify Location id 58450641063
2025-08-13 17:30:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T17:30:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-13 17:30:10 [INFO]: Change: available | Delta: -1
2025-08-13 17:30:10 [INFO]: Change: on_hand | Delta: -1
2025-08-13 17:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772396 and user_id = 14409 
2025-08-13 17:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680938 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:30:10 [INFO]: Shopify Inventory id 48037694767326
2025-08-13 17:30:10 [INFO]: Shopify Location id 58450641063
2025-08-13 17:30:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T17:30:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-13 17:30:10 [INFO]: Change: available | Delta: -1
2025-08-13 17:30:10 [INFO]: Change: on_hand | Delta: -1
2025-08-13 17:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775574 and user_id = 14409 
2025-08-13 17:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684116 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:30:10 [INFO]: updateIdsQuantity -> ["77450429","77680938","77684116"]
2025-08-13 17:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-13 17:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77450429 THEN 0 WHEN id = 77680938 THEN 0 WHEN id = 77684116 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77450429 THEN 0 WHEN id = 77680938 THEN 0 WHEN id = 77684116 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77450429,77680938,77684116)
2025-08-13 17:30:10 [INFO]: QUANTITY Updated IDs: 77450429, 77680938, 77684116
2025-08-13 17:30:10 [INFO]: Successfully processed data for user 14409
2025-08-13 17:30:10 [INFO]: Execution Started
2025-08-13 17:30:10 [INFO]: Execution Finished
2025-08-13 17:40:02 [INFO]: Execution Started
2025-08-13 17:40:02 [INFO]: old server sucessfully connected
2025-08-13 17:40:02 [INFO]: sqs client sucess created
2025-08-13 17:40:03 [INFO]: Number of messages in the queue: 3
2025-08-13 17:40:03 [INFO]: item found in queue is if condition  14409
2025-08-13 17:40:03 [INFO]: item found in queue is  14409
2025-08-13 17:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+hYnJ3wGfhuf0BGwwxAr+y5LwG4ganAoxqSV+Af9KslDVobb6vTjg6dwqjtApTDcHAfIvhybNSz9YW7YYnzR9VkM0bUGfzcAMjN4MMA8SI9dcYJMZRHiGEA8//PudaFIcdxzUXOye9jsO+xRUopC9PaJnGI9F+h0GmpCzGoB80s+cD+kdJbnHamDGjk+YzWWwnqI1Psr08+TTrlTXcblSTn8+Zn8FVJeCa+UO6VKGvM2Leswfm7mjXBToZlRYhmIuQmbxB9jKN2UWu9Ik3+siOVxDZQNXs8CCUYqCjUKnLK/ddorLrUHqBHxCK2urw5MpG7/oD+BEbiA4uxd8ch3FxOUHIHQrkz7VJ9tiu9U7jvTlY+2lgm4VVQlSwCexpeLJDSiTtgtOOwmVCa6cgMj3qcLasTA1zPePENTRoKVKXthJQVJbhgUXCO0QhXPY6Ox
2025-08-13 17:40:04 [INFO]: item found in queue is if condition  14409
2025-08-13 17:40:04 [INFO]: item found in queue is  14409
2025-08-13 17:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBOzBB8MdieAc6pWxOrslIlcWwz/ak7Th4ju6DrXX3FksMLeA+fkCKemyZZ0uyVtUhWE8MIiRA8+WQxil+pQ4ZPA+mRrb2+Jjf3taymsUX8PkKoVi0Te/OCFRx1im2+HmGmOJzkQB7wKGu92Hh6+J+O/a59bMiAcnaDp44FjUpMMBbIMydoYxqO7grKXvA/KMf7pvgnIOc70xHKDoNDdXR/uXO5QxvIqFDXsfH2UGTkMVeuflkf8Fy78L9DXf4k38XK6m/gUIsEPceQQ+K7gYu8nHVrUs4HKieOgDmETdBhS6vmfXyn0ZP/OayvRLPEukJil3lyxROFmi++26h6ndf2JfFv614i3IopvQGNcdXqom7uc7cDS0lAPPS++j59nnt8R9Lzt0HTg9XNKf0kO28yFnZ+7SCN0m696rZzGNWaQwRGG6HrwKfRqQDpKE/Nes8
2025-08-13 17:40:04 [INFO]: item found in queue is if condition  14409
2025-08-13 17:40:04 [INFO]: item found in queue is  14409
2025-08-13 17:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBrd0Mu3MZ9K86nSVpYmFEPvziXoJN5Byce3anauiTXdbARfzsiZ6/Km7fSSHeE/3imsJwEHVR9H94mSkS2j9+wfmIz4g8zNY2hWA7a/TFSMaSpIvGGZOhDxUzzw+dmcDnwLJ68v3U02TS5vDZ/UvbjAJOHR8DeUrX5NCuelCEU9qhVI8iO9rDFoAyCQJEl1wqqaJnYToNkanMWd0wdlxEGzhqfWwVyt0i6wxGGMQoQ7xZYq8atVTc38pjhZLw5MWM6vtj+q3xoysgU6rE6MpD/LNemhM5RCaTw+3rFWJuIVLne3B/yYHZb70M1Qpc1ASzs3eMJQxmVSQSesvXr25+OX+K+DzOJMaoWL1p0x+T595+kadkhnFnXZ1uNF8LJ1id3C96ZPRLPjvoJzSaoD3wM6BxoJcvCBibwkTgN3lnr3D61iqf/38Uvkk7YFtH/+5
2025-08-13 17:40:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-13 17:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 17:40:04 [INFO]: inside itemsold and closed 14409
2025-08-13 17:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:40:06 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:40:06 [INFO]: Ebay item id :: 226730663021 exists in Database
2025-08-13 17:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:40:06 [INFO]: inside itemsold and closed 14409
2025-08-13 17:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:40:08 [INFO]: Ebay item id :: 226211248892 exists in Database
2025-08-13 17:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:40:08 [INFO]: inside itemsold and closed 14409
2025-08-13 17:40:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 17:40:10 [INFO]: autolink for user_id 14409 is 1
2025-08-13 17:40:10 [INFO]: Ebay item id :: 404940180248 exists in Database
2025-08-13 17:40:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 17:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 17:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 17:40:10 [INFO]: in processold action queue is array    for {"44710569":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710569","ebayitemid":"226730663021","shopifyproductid":"8923332903134","variants":[{"price":"32.99","quantity":0,"weight":"0.75","shopifyproductid":"8923332903134","shopifyvariantid":"46828240699614","shopifyinventoryid":"48926702665950","shopifylocationid":"58450641063","product_id":"44710569","variant_id":"77618182","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674472":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674472","ebayitemid":"226211248892","shopifyproductid":"8700438085854","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8700438085854","shopifyvariantid":"45946952483038","shopifyinventoryid":"48045509705950","shopifylocationid":"","product_id":"44674472","variant_id":"77579692","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674667":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674667","ebayitemid":"404940180248","shopifyproductid":"8922442301662","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8922442301662","shopifyvariantid":"46822844137694","shopifyinventoryid":"48921308135646","shopifylocationid":"58450641063","product_id":"44674667","variant_id":"77579887","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 17:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 17:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 17:40:10 [INFO]: Shopify Inventory id 48926702665950
2025-08-13 17:40:10 [INFO]: Shopify Location id 58450641063
2025-08-13 17:40:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-13 17:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710569 and user_id = 14409 
2025-08-13 17:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77618182 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:40:10 [INFO]: Shopify Inventory id 48045509705950
2025-08-13 17:40:10 [INFO]: Shopify Location id 58450641063
2025-08-13 17:40:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T17:40:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-13 17:40:10 [INFO]: Change: available | Delta: -1
2025-08-13 17:40:10 [INFO]: Change: on_hand | Delta: -1
2025-08-13 17:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674472 and user_id = 14409 
2025-08-13 17:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579692 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:40:10 [INFO]: Shopify Inventory id 48921308135646
2025-08-13 17:40:10 [INFO]: Shopify Location id 58450641063
2025-08-13 17:40:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 17:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T17:40:11Z","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-13 17:40:11 [INFO]: Change: available | Delta: -2
2025-08-13 17:40:11 [INFO]: Change: on_hand | Delta: -2
2025-08-13 17:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 17:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674667 and user_id = 14409 
2025-08-13 17:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579887 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 17:40:11 [INFO]: updateIdsQuantity -> ["77618182","77579692","77579887"]
2025-08-13 17:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-13 17:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77618182 THEN 0 WHEN id = 77579692 THEN 0 WHEN id = 77579887 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77618182 THEN 0 WHEN id = 77579692 THEN 0 WHEN id = 77579887 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77618182,77579692,77579887)
2025-08-13 17:40:11 [INFO]: QUANTITY Updated IDs: 77618182, 77579692, 77579887
2025-08-13 17:40:11 [INFO]: Successfully processed data for user 14409
2025-08-13 17:40:11 [INFO]: Execution Started
2025-08-13 17:40:11 [INFO]: Execution Finished
2025-08-13 17:50:02 [INFO]: Execution Started
2025-08-13 17:50:02 [INFO]: old server sucessfully connected
2025-08-13 17:50:02 [INFO]: sqs client sucess created
2025-08-13 17:50:03 [INFO]: Number of messages in the queue: 0
2025-08-13 17:50:23 [INFO]: Execution Started
2025-08-13 17:50:23 [INFO]: Execution Finished