2025-08-06 21:00:02 [INFO]: Execution Started
2025-08-06 21:00:02 [INFO]: old server sucessfully connected
2025-08-06 21:00:02 [INFO]: sqs client sucess created
2025-08-06 21:00:03 [INFO]: Number of messages in the queue: 2
2025-08-06 21:00:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:00:03 [INFO]: item found in queue is  14409
2025-08-06 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBrZYMq3hinEzz+beekV5fifK31WWy8+9tMmNt98fL7Ey+ZYwpPy0izRJ7CIHSLpS2tNPDWYBwvaMzsDG59GPPBSTAEk5EOvJN/u3zR7HLonhAVEumGYEt4jF4YpPIhRrudFr1sJPCLRfiBuE3rAWDS+ayrDj2/s8BBZwjIxgug0EDpscCmKkHNDwlOF1F0BhUVI5lXWMBfdp7EQnc1DKn/ZOyv9sH2O+aaqYPdw+oXrdlXxMgvIrQCxRhfvKoTJrViiVD88pxPxukD7q60UnB0M3mTa8VDtTz5D+gKE2YUYxY4gQvgKFf2uAe5z5Vq+G8UvGF2tEpI2qZHoF/a62sM7eYOHQP7KlXorG35/MovBRFUiqgK/liiz0o+tC+FGWF6S9gGCk1CDjikD1l2TUU0PO11XLsDU+w+VyZl6cjrXTVYfrepZafjv+6TTTLmCPX
2025-08-06 21:00:04 [INFO]: item found in queue is if condition  14409
2025-08-06 21:00:04 [INFO]: item found in queue is  14409
2025-08-06 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBcAIKtK+mlz2KXpwY5yAFAyfWrx4Mi7Hrg0Dy9lzIu93dUhWzzFYSmZlcdfaPDC8FBixqGqhxxz6rtXTVkUcu6eceO4sNC9fF4KwjSgIPfkP8EVj0cGpb/IPYPqOL259O2UMkyDELXPVFK3l+c9gnGGhjEfbwWcGoyS3AjeTdBq/fUlWlSODepOss1WnkeKEGLFrXCG1XsBbF6ciFxkcGho4MutcOa9ATxiEt1gLBLEak1uBQDCXAYBtFnv4b2DmcJ7ISGoktxQlI24OqDN1fVp1eLJ3ozN6uKI037qkyZTzUTjm8RnSuFppYABfJjXpOGUv89DUXugPozagHee5vIaRXji1E/I0ADr3uuQANwqxAkkTJsJIvkSOP1Rj492rXxtOwXGP36exh8I2cPqRlE+qKX6l/THjsPXd8L/ISyrZ47lzePhd1bYxpl3PZh6nY
2025-08-06 21:00:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-06 21:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 21:00:04 [INFO]: inside itemsold and closed 14409
2025-08-06 21:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:00:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:00:06 [INFO]: Ebay item id :: 335522739321 exists in Database
2025-08-06 21:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:00:06 [INFO]: inside itemsold and closed 14409
2025-08-06 21:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:00:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:00:08 [INFO]: Ebay item id :: 305714031926 exists in Database
2025-08-06 21:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:00:08 [INFO]: in processold action queue is array    for {"44563658":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44563658","ebayitemid":"335522739321","shopifyproductid":"8695020355806","variants":[{"price":"119.99","quantity":0,"weight":"2","shopifyproductid":"8695020355806","shopifyvariantid":"45933790494942","shopifyinventoryid":"48032241909982","shopifylocationid":"","product_id":"44563658","variant_id":"77456338","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44559987":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559987","ebayitemid":"305714031926","shopifyproductid":"8695042212062","variants":[{"price":"182.99","quantity":0,"weight":"2","shopifyproductid":"8695042212062","shopifyvariantid":"45933844791518","shopifyinventoryid":"48032296206558","shopifylocationid":"","product_id":"44559987","variant_id":"77452667","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 21:00:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 21:00:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:00:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:00:08 [INFO]: Shopify Inventory id 48032241909982
2025-08-06 21:00:08 [INFO]: Shopify Location id 58450641063
2025-08-06 21:00:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:00: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-06 21:00:08 [INFO]: Change: available | Delta: -1
2025-08-06 21:00:08 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44563658 and user_id = 14409 
2025-08-06 21:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77456338 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:00:08 [INFO]: Shopify Inventory id 48032296206558
2025-08-06 21:00:08 [INFO]: Shopify Location id 58450641063
2025-08-06 21:00:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:00:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:00: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-06 21:00:09 [INFO]: Change: available | Delta: -1
2025-08-06 21:00:09 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559987 and user_id = 14409 
2025-08-06 21:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452667 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:00:09 [INFO]: updateIdsQuantity -> ["77456338","77452667"]
2025-08-06 21:00:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-06 21:00:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77456338 THEN 0 WHEN id = 77452667 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77456338 THEN 0 WHEN id = 77452667 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77456338,77452667)
2025-08-06 21:00:09 [INFO]: QUANTITY Updated IDs: 77456338, 77452667
2025-08-06 21:00:09 [INFO]: Successfully processed data for user 14409
2025-08-06 21:00:09 [INFO]: Execution Started
2025-08-06 21:00:09 [INFO]: Execution Finished
2025-08-06 21:10:01 [INFO]: Execution Started
2025-08-06 21:10:01 [INFO]: old server sucessfully connected
2025-08-06 21:10:01 [INFO]: sqs client sucess created
2025-08-06 21:10:02 [INFO]: Number of messages in the queue: 2
2025-08-06 21:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:10:03 [INFO]: item found in queue is  14409
2025-08-06 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBnuefEzHjR91uyOPP91KZb1lp9QobmTq65r8F+S8q2AvPDDuCysKaX7+6HMFfWskzxkAKU/ebRRnXJQ4GTdgn8ztFHcstQbgKl9Y5TAqzIbVVcj+p6W8vUoFp7oC6lNxdVN6KUATmXfslcQf8xbX3mGrkKoO5XO3ZKVD3Xb75anQybKzoBUVk5Z/XOxv4lzST/RLi2Nn4k1WmdYDg8evbTS/bVOU10acQSwzmjVcblCKyvApzLZc+PGw84jEUd53vfGkd42AN+1xvckH8FLFmx8XZsbA68d6IuDnsYjBjYt2Cx20xYSt+ng8YBJApfxq0DMtIXfrt4TVHc0Ep/jzOu9QcVJLC7mZkus3G77bT7TRt4nIpjJNXKoqWDlEy+cq43EASxIVZxWb4fNvibjkQjstm3PZbmFxqfF60esWiVmx6mLoCVkRMi6fVOdsdBA9s
2025-08-06 21:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:10:03 [INFO]: item found in queue is  14409
2025-08-06 21:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB7+uAjLlbzDGSlwhpRUxLHJHgokn1gMrjQrU2vXel7Q9WTi+/AsAvH1/FIvhEV5YLnRDoAEmRYpUfkIhXfYFhTCIwypWeq2TvMFPE1fvzS9VBZnsDXcH+YhGUBVmxLJO6vH3kzwqZF8WtaCHbcL41sF7lqeHmk9oOX81YgGCcm0zZ0INy0DiLMa0AKB/4xQe0oQsgz6UNzLAGb4AciCE+2XJkpq7V7yAMl1fpyRhFH595os2cYgGUFG1LCAu0j9mtqzkt64b3MILJbyL4YXC+N1vcWW+5QoD7ZsxF8tSkKi0nlKCGBs02I7OxFFj/8jxqNz/N3c/Lxc/HUfh8JsJfHXAUTM0iU8KoPjgr32tvU0oA8bil0UMKOx0MRhWboN/VTIDfGR5atn1NBeQGiX/v9Qq2AznmwiZTmG+igoSQToEJ76OtRl3CDMfER/+tkv37
2025-08-06 21:10:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-06 21:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 21:10:04 [INFO]: inside itemsold and closed 14409
2025-08-06 21:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:10:05 [INFO]: Ebay item id :: 286033621508 exists in Database
2025-08-06 21:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:10:05 [INFO]: inside itemsold and closed 14409
2025-08-06 21:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:10:07 [INFO]: Ebay item id :: 286035156970 exists in Database
2025-08-06 21:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:10:07 [INFO]: in processold action queue is array    for {"44594441":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594441","ebayitemid":"286033621508","shopifyproductid":"8696067555550","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8696067555550","shopifyvariantid":"45936105980126","shopifyinventoryid":"48034554904798","shopifylocationid":"","product_id":"44594441","variant_id":"77487150","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595924":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595924","ebayitemid":"286035156970","shopifyproductid":"8697591857374","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8697591857374","shopifyvariantid":"45939464077534","shopifyinventoryid":"48037927026910","shopifylocationid":"","product_id":"44595924","variant_id":"77488633","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 21:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:10:07 [INFO]: Shopify Inventory id 48034554904798
2025-08-06 21:10:07 [INFO]: Shopify Location id 58450641063
2025-08-06 21:10:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:10: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-06 21:10:08 [INFO]: Change: available | Delta: -1
2025-08-06 21:10:08 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594441 and user_id = 14409 
2025-08-06 21:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487150 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:10:08 [INFO]: Shopify Inventory id 48037927026910
2025-08-06 21:10:08 [INFO]: Shopify Location id 58450641063
2025-08-06 21:10:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:10: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-06 21:10:08 [INFO]: Change: available | Delta: -1
2025-08-06 21:10:08 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595924 and user_id = 14409 
2025-08-06 21:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488633 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:10:08 [INFO]: updateIdsQuantity -> ["77487150","77488633"]
2025-08-06 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-06 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77487150 THEN 0 WHEN id = 77488633 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77487150 THEN 0 WHEN id = 77488633 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77487150,77488633)
2025-08-06 21:10:08 [INFO]: QUANTITY Updated IDs: 77487150, 77488633
2025-08-06 21:10:08 [INFO]: Successfully processed data for user 14409
2025-08-06 21:10:08 [INFO]: Execution Started
2025-08-06 21:10:08 [INFO]: Execution Finished
2025-08-06 21:20:02 [INFO]: Execution Started
2025-08-06 21:20:02 [INFO]: old server sucessfully connected
2025-08-06 21:20:02 [INFO]: sqs client sucess created
2025-08-06 21:20:03 [INFO]: Number of messages in the queue: 3
2025-08-06 21:20:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:20:03 [INFO]: item found in queue is  14409
2025-08-06 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBbxJacl31+nLdi4FZlN4gJnzwpBcAjPzi7BKiXvpbjeY1VT/eW3PpTcylURvmAtwANFD+b4AGvUGUCosPLhqKNBcW7NGIasxlFZ9ONUK+uoB8XDxXmrxu6FYw94ypBbCGEAeMzfqdGLhTZvpMnUrJ0qEvuK7JdpoBqF2Qp3aYGbxC/CAoq84ZFrRxGGMKkqeYzgJhU/ifPFzhT15/AQPKB3rgziBIBXViIQ73JmvNWRu/dq0URUH4ZyMQDzjmuZ0k1tspEQVp7rm32FbVeBLLfmwDbQ6idBIRVefE3VOcm7WX1SmFFKzngiBY8JEJKKDZ4PHBZgvz64dgVCgESChaCycTR5xeN77OxYtHrj0OA/TX0pnD33QoCe1iHTsyrkkYRLJRssL4Re47zDl0XW6PEktCFrHPLKTQ8EHue4Lzz/l49acRRQHllI1vPE+Q6zJb
2025-08-06 21:20:04 [INFO]: item found in queue is if condition  14409
2025-08-06 21:20:04 [INFO]: item found in queue is  14409
2025-08-06 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB33J91+donJGO7Dg/TC4bS0gLd0fOd61fhXchgZeGfOJ5Dv5UgYDqkzvYCNNyq4BQlPoqpeBKeRgJAO5F2M76t0c8EzQ0GbWarEG9FEZPaLo2N/UTksF7yON0fbZgwCmlqR1oUSYBSfbWaIRCMrq3GuVXPBlNow0Z639+GAXFrdwYurcVzxxKt4mnT55x6JME1gWpdGgJymBIKexjH8RObJHbkG28joiYGFGaID9BQIELM69p3Uwr1gOs1zrWvkz8TT9Uc1iPx9Ie/un+JR+bVOA9idMfzuJWB8XU2+vIRCiA6msiO8eZ9Bj1EKYvwbt1sB1q7Aa/KZt3sGrDXK5x2C/+C7wzWDgOTMuD4ces/iZTARs7VKjp87r8A9yQ8vxT9nry6KKrWn5/5aXahOmMdoTKbyLoPghH9wEoyEAjCIDQDZcgp31RplNn2yFpmeBU
2025-08-06 21:20:04 [INFO]: item found in queue is if condition  14409
2025-08-06 21:20:04 [INFO]: item found in queue is  14409
2025-08-06 21:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBVsimVoxyw3ZGMoCnzwnEc+c5DaKj5bowDA0mR1hV1MTi8A2+HnkQBXqQ+IvaY2g73KJDkIX3H2G/uQACRD9MaSvnNl83OpBve2XQz8hm0hWCTb6FfEH1TDCYi7sd2IYzH7EwDwUZpw0zMBcJ1awXHe7e02QLViaCQ7//pvnqv/aLDEGTDjDgDfd9IaECbDdslmcNCpTLwUj3W2dn/xo2L805jFhSUmSBgUty28YQk0B52tFR34AJBFoqoPfHbuEt66YdEDB9sR5Bf1PFIHNtEgR1BoqpmWfa8t1FGcKVKyeGqPTVceTqT5dysv54dO983MGyyKo8lQziBf2JDtSFTqdeA+paf5Cm5fVvVac5u0zYfTXcEKcE1LU+emtkDXjE5JE5UG/L0G6uy+V/zdAULdFLXHxH1XvnVZZr7Ja3GHVx3stdTn5Jq2+u6W2h9WMC
2025-08-06 21:20:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-06 21:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 21:20:04 [INFO]: inside itemsold and closed 14409
2025-08-06 21:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:20:06 [INFO]: Ebay item id :: 256831695200 exists in Database
2025-08-06 21:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:20:06 [INFO]: inside itemsold and closed 14409
2025-08-06 21:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:20:07 [INFO]: Ebay item id :: 305767085899 exists in Database
2025-08-06 21:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:20:07 [INFO]: inside itemsold and closed 14409
2025-08-06 21:20:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:20:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:20:09 [INFO]: Ebay item id :: 286057442221 exists in Database
2025-08-06 21:20:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:20:09 [INFO]: in processold action queue is array    for {"44677333":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677333","ebayitemid":"256831695200","shopifyproductid":"8827763589342","variants":[{"price":"149.99","quantity":0,"weight":"2","shopifyproductid":"8827763589342","shopifyvariantid":"46322327748830","shopifyinventoryid":"48423441170654","shopifylocationid":"","product_id":"44677333","variant_id":"77582553","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44558888":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44558888","ebayitemid":"305767085899","shopifyproductid":"8696047829214","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8696047829214","shopifyvariantid":"45936015638750","shopifyinventoryid":"48034463875294","shopifylocationid":"","product_id":"44558888","variant_id":"77451568","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44570027":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570027","ebayitemid":"286057442221","shopifyproductid":"8694992437470","variants":[{"price":"119.99","quantity":0,"weight":"2","shopifyproductid":"8694992437470","shopifyvariantid":"45933720994014","shopifyinventoryid":"48032172179678","shopifylocationid":"","product_id":"44570027","variant_id":"77462711","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 21:20:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 21:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:20:09 [INFO]: Shopify Inventory id 48423441170654
2025-08-06 21:20:09 [INFO]: Shopify Location id 58450641063
2025-08-06 21:20:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:20:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-06 21:20:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:20:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677333 and user_id = 14409 
2025-08-06 21:20:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582553 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:20:09 [INFO]: Shopify Inventory id 48034463875294
2025-08-06 21:20:09 [INFO]: Shopify Location id 58450641063
2025-08-06 21:20:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:20: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-06 21:20:10 [INFO]: Change: available | Delta: -1
2025-08-06 21:20:10 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44558888 and user_id = 14409 
2025-08-06 21:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77451568 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:20:10 [INFO]: Shopify Inventory id 48032172179678
2025-08-06 21:20:10 [INFO]: Shopify Location id 58450641063
2025-08-06 21:20:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:20: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-06 21:20:10 [INFO]: Change: available | Delta: -1
2025-08-06 21:20:10 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570027 and user_id = 14409 
2025-08-06 21:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462711 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:20:10 [INFO]: updateIdsQuantity -> ["77582553","77451568","77462711"]
2025-08-06 21:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 21:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77582553 THEN 0 WHEN id = 77451568 THEN 0 WHEN id = 77462711 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77582553 THEN 0 WHEN id = 77451568 THEN 0 WHEN id = 77462711 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77582553,77451568,77462711)
2025-08-06 21:20:10 [INFO]: QUANTITY Updated IDs: 77582553, 77451568, 77462711
2025-08-06 21:20:10 [INFO]: Successfully processed data for user 14409
2025-08-06 21:20:10 [INFO]: Execution Started
2025-08-06 21:20:10 [INFO]: Execution Finished
2025-08-06 21:30:01 [INFO]: Execution Started
2025-08-06 21:30:01 [INFO]: old server sucessfully connected
2025-08-06 21:30:02 [INFO]: sqs client sucess created
2025-08-06 21:30:03 [INFO]: Number of messages in the queue: 0
2025-08-06 21:30:23 [INFO]: Execution Started
2025-08-06 21:30:23 [INFO]: Execution Finished
2025-08-06 21:40:01 [INFO]: Execution Started
2025-08-06 21:40:01 [INFO]: old server sucessfully connected
2025-08-06 21:40:01 [INFO]: sqs client sucess created
2025-08-06 21:40:02 [INFO]: Number of messages in the queue: 3
2025-08-06 21:40:02 [INFO]: item found in queue is if condition  14409
2025-08-06 21:40:02 [INFO]: item found in queue is  14409
2025-08-06 21:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBujJDGGAGlxlhnPRsIH2uxjq19h4FWUzn0TFaU2hXvLRbQJ+cYrKcM+9gfeW3jd6K495rPQc5mA8DliseFETs8rKYyf0z0/effA9ZQRbxnqPs0Vuv9IKKyGYsIZ1iMFeCVzdUqvtclmAUVFbM7aXQHBxnkURPdH1w/1A1gbb0/doaBHnkzpPicQ69tgWnzXteee6+a4cG1yKY7jjmTVUfGhJfYaLK06XhOi/EWcjjXzL1X7YexJ7t0PrYpwAyCvzQuNFsRLOeBRGPceJvU+DfOS/I05Za0DVcTigaAxLyVRyYGv5duMiYsWbfsFVrWe67UgRs4Q0xAXv7VXvafT7Vi42UWGR+Xjf5RsGC0NR3cbmevJc7fE5wlTaEUj2JHH1hRweFWrkG42447ztT2R4bHix7bQol3rwRocHuehjy8JmUaKss71pco7cpBVB55XoF
2025-08-06 21:40:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:40:03 [INFO]: item found in queue is  14409
2025-08-06 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBev68M31cElOdL4YydVGBN/pp/ef1KxH0SLkQPo/obnpu13VWDwHJDb9Yghqj72xsXcBcrunvanpPqjvs6UfgumLNUz+2Mjc264q80o/x6mFdginFTYzGjfYZdvfsMqz5LvZX+aE6T7Xb4z0n1hkt9X8Zp/LC9HI1D+5NdMVVoecj4jrkGYpZCQxznz8LhrC7T6doWYJ6hlomRIbQNss0sHS0+FUc9IPM6kZuxE1YiqgotdjBu5S05Bg3h4QHXTQPZA4YfAItgy/SBOkXW/AciTrixQeNDRDQTeVfzETe4BLH0bvdR+GLHwTCjRdSO4Xw7P2ak1VjwGLoBMXbHvd2DH2rsVQOISfO1Vs9sVuBCcF0iOfJGZc4a9isvBqK5eXszSz3Lt/31Q9AW+PD3ucUGDzrPtrXXpYvWqd9ZR7/zFw2LNhkvfWYeSOPEiJ8SX3M
2025-08-06 21:40:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:40:03 [INFO]: item found in queue is  14409
2025-08-06 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBb6P7KFeRjRK/GOj+kJHFTjU9pP7By+nkncG18UY34OiaPn5xBOAlSSmsf25VlkSL1iTtJJeGDFvnDLA3UjpZPFJv0UcfTzJCF/OSzN5XvXZfwUN6MnVyKH+3f0fWZzE8Qv6ONY5Z4PhswSCkDT4dRJgx0NgTRrILSMGSDUPi0QLqjI3+MJziRR12emE1dbAhbX7k3SXAc3g/WnA+uDTaCIncpiX/wm5hWpNIjLy438Qt28dRXXI+YWoK2NJ2dMofp5pfl2vtIYGikV6j90VEL1WEqqQCrPqD1bfMKtWNrlnf5egsghB2fiecl1tlaStljck9c/rv0jUw/BewgQnuOVdgulwSa4OEqkCKSq12ZewByuIA5f1S/4LjPpKewkNWRS4vWCAGYm0/PG/LHeOyulvzda2S0KyZ7n4bYMEEsj+/KJs6PqrLbUjogBaB9hz4
2025-08-06 21:40:03 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-06 21:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 21:40:03 [INFO]: inside itemsold and closed 14409
2025-08-06 21:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:40:05 [INFO]: Ebay item id :: 335668781669 exists in Database
2025-08-06 21:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:40:05 [INFO]: inside itemsold and closed 14409
2025-08-06 21:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:40:07 [INFO]: Ebay item id :: 335582896020 exists in Database
2025-08-06 21:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:40:07 [INFO]: inside itemsold and closed 14409
2025-08-06 21:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:40:09 [INFO]: Ebay item id :: 335590972046 exists in Database
2025-08-06 21:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:40:09 [INFO]: in processold action queue is array    for {"44567829":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567829","ebayitemid":"335668781669","shopifyproductid":"8058715406558","variants":[{"price":"79.99","quantity":0,"weight":"2","shopifyproductid":"8058715406558","shopifyvariantid":"44220145238238","shopifyinventoryid":"46317246251230","shopifylocationid":"","product_id":"44567829","variant_id":"77460509","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44584291":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44584291","ebayitemid":"335582896020","shopifyproductid":"8696069751006","variants":[{"price":"57.99","quantity":0,"weight":"2","shopifyproductid":"8696069751006","shopifyvariantid":"45936112697566","shopifyinventoryid":"48034561622238","shopifylocationid":"","product_id":"44584291","variant_id":"77477000","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44591959":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591959","ebayitemid":"335590972046","shopifyproductid":"8695102406878","variants":[{"price":"79.99","quantity":0,"weight":"2","shopifyproductid":"8695102406878","shopifyvariantid":"45933962199262","shopifyinventoryid":"48032413581534","shopifylocationid":"","product_id":"44591959","variant_id":"77484668","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 21:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 21:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:40:09 [INFO]: Shopify Inventory id 46317246251230
2025-08-06 21:40:09 [INFO]: Shopify Location id 58450641063
2025-08-06 21:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:40:09Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1930,"restoreRate":100}}}}
2025-08-06 21:40:09 [INFO]: Change: available | Delta: -1
2025-08-06 21:40:09 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567829 and user_id = 14409 
2025-08-06 21:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77460509 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:40:09 [INFO]: Shopify Inventory id 48034561622238
2025-08-06 21:40:09 [INFO]: Shopify Location id 58450641063
2025-08-06 21:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:40: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-06 21:40:09 [INFO]: Change: available | Delta: -1
2025-08-06 21:40:09 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44584291 and user_id = 14409 
2025-08-06 21:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77477000 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:40:09 [INFO]: Shopify Inventory id 48032413581534
2025-08-06 21:40:09 [INFO]: Shopify Location id 58450641063
2025-08-06 21:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21: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-06 21:40:10 [INFO]: Change: available | Delta: -1
2025-08-06 21:40:10 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591959 and user_id = 14409 
2025-08-06 21:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484668 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:40:10 [INFO]: updateIdsQuantity -> ["77460509","77477000","77484668"]
2025-08-06 21:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 21:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77460509 THEN 0 WHEN id = 77477000 THEN 0 WHEN id = 77484668 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77460509 THEN 0 WHEN id = 77477000 THEN 0 WHEN id = 77484668 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77460509,77477000,77484668)
2025-08-06 21:40:10 [INFO]: QUANTITY Updated IDs: 77460509, 77477000, 77484668
2025-08-06 21:40:10 [INFO]: Successfully processed data for user 14409
2025-08-06 21:40:10 [INFO]: Execution Started
2025-08-06 21:40:10 [INFO]: Execution Finished
2025-08-06 21:50:02 [INFO]: Execution Started
2025-08-06 21:50:02 [INFO]: old server sucessfully connected
2025-08-06 21:50:02 [INFO]: sqs client sucess created
2025-08-06 21:50:03 [INFO]: Number of messages in the queue: 3
2025-08-06 21:50:03 [INFO]: item found in queue is if condition  14409
2025-08-06 21:50:03 [INFO]: item found in queue is  14409
2025-08-06 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBdmsG3nb0VNhs2dmDBpmNwNkqoXnujoqr0ayP/4FDJhsJ45y3rGjl1Bpsjbjw3ZmkZaP+3Ybx0Qp651xByQnPcmQZpGwcPYgSW9IwsrYD0aSIQ44OF0NuD2ezqJavQbiGzmUpVEBTnDdXvyesve/gw6lpwh6NkpTMBSRGEoiRGZzpVwn138Ax4LI5E4EcOoLq8VI9QJZvxcGmc+NOUVbXvtJ0+KDjR/kyJo0VtX2vGvmUxq28oqBDjbtRocNgmi0E4f2MMIK25oe6wNA8olInlmVXH6Qk+5hZeI+Nf4wilo28b9w6qkZRIRBfdgveRzCjqyuFg3rPySrXhNTlmP4esolZXajYxIb+4H/hh9tmGWC668Ufrb2rqfpcGExjeIwcNEHv6OZSLmUZ2yaiSiptzywmTGqByfrc8sLW0mOE5/LF4Fa80DBgxovCYnIBOPCJ
2025-08-06 21:50:04 [INFO]: item found in queue is if condition  14409
2025-08-06 21:50:04 [INFO]: item found in queue is  14409
2025-08-06 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBkg/fpCmI32lLAOyIsF8x5QaMW2MB7MU6VI9X27mzh8dUA9YxMCmM2sF6DYJc/srA28g2/yEHe/KRJFRRn6VyiEc523m5/tMA4Rkk4ecuhjFiRdta9VbJwf+KGpLiOhPJvZ/8Q+QisoP7hpGz2yYyEzP6a6RV3I6yL+uTJgfgVAeTgqBbQAC0/xQN8OJTgfYDkf0oqU40Ua4ySTvNkrY9w6+xSUn7LcOHTeZrhPM9CGj2/9LyHPFN64RunJDNvt8mLHzmN61J0By5E1uI7eYdQXMBPHsakD1XcQKw4Q3jSj1r28m4x/QHR+TdAlorumLbI9W9gKk4n+aclwrOVvwA/23e1mROX3TN2TevgwidiDGX3ruBdlA1a4bfgKhrtYr9zAgnVITwzRT0uVp/iaepVN42e/CfSoPzpvrhQkR/TvmjllCkKKWCP15ML9Uqyx7p
2025-08-06 21:50:04 [INFO]: item found in queue is if condition  14409
2025-08-06 21:50:04 [INFO]: item found in queue is  14409
2025-08-06 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBnK9hYBCug+t1PeP+MJUSQQ41dAWVVw3RUoaU17LMjDMpK9awyPhuMFvOgkCmhKwPFd2I7n6OIJ8BbT8YQIViH+ieb443l1e9ArF+mwb+TQ1BMKoH2Iz9hIwPEOY7yobxzIrdv7rVyrEYqO5K6L8xXqYNC+CKgLARAtj+dcDJnubH6rkE+xnl/kbdwAzw/d7w5ULVhoXY2x+ujQCOKDGpwCnauB1GrwfCrbnThy2rLvhkXGQjjkRHRYLl8jfToK+Kg1KZscpKjyrgmCr8YnN0V9No2TSn263s05Mzg+kbkY0uXQbkA64yOceOlf87Fbi3qFffFgLutLtIA9+jcD+raFe5XaayXANXcV6haR5TVMqy2nt0kiDpTK5fqw2SYjE3crxmdr+3Kwg+1x/RXIahlxtBjE2h3mlfDjVupT9J6yBDo2qoUXF8KCxGFqxM2de+
2025-08-06 21:50:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-06 21:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 21:50:04 [INFO]: inside itemsold and closed 14409
2025-08-06 21:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:50:06 [INFO]: Ebay item id :: 405165938731 exists in Database
2025-08-06 21:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:50:06 [INFO]: inside itemsold and closed 14409
2025-08-06 21:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:50:08 [INFO]: Ebay item id :: 305397053458 exists in Database
2025-08-06 21:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:50:08 [INFO]: inside itemsold and closed 14409
2025-08-06 21:50:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 21:50:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 21:50:10 [INFO]: Ebay item id :: 304192783431 exists in Database
2025-08-06 21:50:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 21:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 21:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 21:50:10 [INFO]: in processold action queue is array    for {"44690084":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44690084","ebayitemid":"405165938731","shopifyproductid":"8696080662750","variants":[{"price":"43.99","quantity":0,"weight":"0.75","shopifyproductid":"8696080662750","shopifyvariantid":"45936136945886","shopifyinventoryid":"48034585903326","shopifylocationid":"","product_id":"44690084","variant_id":"77595336","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44570296":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570296","ebayitemid":"305397053458","shopifyproductid":"8285918626014","variants":[{"price":"13.99","quantity":0,"weight":"0.75","shopifyproductid":"8285918626014","shopifyvariantid":"44805574131934","shopifyinventoryid":"46903601561822","shopifylocationid":"","product_id":"44570296","variant_id":"77462980","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44583087":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44583087","ebayitemid":"304192783431","shopifyproductid":"7115568152743","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7115568152743","shopifyvariantid":"41591760388263","shopifyinventoryid":"43688383578279","shopifylocationid":"","product_id":"44583087","variant_id":"77475796","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 21:50:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 21:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 21:50:10 [INFO]: Shopify Inventory id 48034585903326
2025-08-06 21:50:10 [INFO]: Shopify Location id 58450641063
2025-08-06 21:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:50: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-06 21:50:10 [INFO]: Change: available | Delta: -1
2025-08-06 21:50:10 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44690084 and user_id = 14409 
2025-08-06 21:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77595336 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:50:10 [INFO]: Shopify Inventory id 46903601561822
2025-08-06 21:50:10 [INFO]: Shopify Location id 58450641063
2025-08-06 21:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:50:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1984,"restoreRate":100}}}}
2025-08-06 21:50:10 [INFO]: Change: available | Delta: -1
2025-08-06 21:50:10 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570296 and user_id = 14409 
2025-08-06 21:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462980 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:50:10 [INFO]: Shopify Inventory id 43688383578279
2025-08-06 21:50:10 [INFO]: Shopify Location id 58450641063
2025-08-06 21:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 21:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T21:50: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-06 21:50:11 [INFO]: Change: available | Delta: -1
2025-08-06 21:50:11 [INFO]: Change: on_hand | Delta: -1
2025-08-06 21:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 21:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44583087 and user_id = 14409 
2025-08-06 21:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475796 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 21:50:11 [INFO]: updateIdsQuantity -> ["77595336","77462980","77475796"]
2025-08-06 21:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 21:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77595336 THEN 0 WHEN id = 77462980 THEN 0 WHEN id = 77475796 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77595336 THEN 0 WHEN id = 77462980 THEN 0 WHEN id = 77475796 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77595336,77462980,77475796)
2025-08-06 21:50:11 [INFO]: QUANTITY Updated IDs: 77595336, 77462980, 77475796
2025-08-06 21:50:11 [INFO]: Successfully processed data for user 14409
2025-08-06 21:50:11 [INFO]: Execution Started
2025-08-06 21:50:11 [INFO]: Execution Finished