2025-08-04 16:00:01 [INFO]: Execution Started
2025-08-04 16:00:01 [INFO]: old server sucessfully connected
2025-08-04 16:00:02 [INFO]: sqs client sucess created
2025-08-04 16:00:03 [INFO]: Number of messages in the queue: 2
2025-08-04 16:00:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:00:03 [INFO]: item found in queue is  14409
2025-08-04 16:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMDjWdPkFWQTaIN4PlGLJJAYMDd256CzcPQ5smYjEn1GSdcwwxyJfTSKyeLhl4re/Hr7UfqqErQ6KhFslSff5G73zkWU+dQ+zKX6KA5K5MymRAUP9hWUtHXH1IPJbGEJqxyIVYW89hf30wubNBliW4YIJIhWpbDSIwl99rKlcSp+UoWqgnjXZJVq2AsrVrnZQTiA0opW4BRQzNXZrq30VpDLNpoEOorkXMwAxwRsJmH1HRJ1izH/5wcVEucxtAzaiXQiqNhj7fOznnS3/db57KjVz6YdZ1939ZVD/4GzMkHr8U8X/cFo/t+Uo/lhvqpSAGM24H1e43Vs+Y1ILmvwD6FV4U1R0Xnmj5TYoCKqaYfg9BX2zc+YqFxJM+4q5q0b6ojzv3zyb8eoYH5mIVuLYpfxxMYec2FBLtjQqSQJBgIrIRc0GY7M0N5fKcnBa2Ry4
2025-08-04 16:00:04 [INFO]: item found in queue is if condition  14409
2025-08-04 16:00:04 [INFO]: item found in queue is  14409
2025-08-04 16:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBlISJMywIYdeie00Nt2YCbBzJ9lmAvu7XWZOmxAIYGN8jm0ir50aZM4u+wg9RUYNWBKmQj+VVZnkabsrLZaSEWnDsQ5nNQLxh8QGkvzkQUuR6RqfR2GjDW0Yy99+PLl+g5L97d8Ngsdeq/Jeeshw69HF8kjDFyw8l6UYNaRjkUNBqHQh0q7uHwWoIQvUpjrtZUwHJtTxeDTdmu0PJIHnuEXMUfoAf4UEYQbwSJsOX7aw/2/uoaU2uGFjlr/lrfYK0fbzBYWOgN7LwzjQ+Rc7oBG3PkJDh64ZF18crjvdfIU3gqQI7hxDCsWqXO04fPNDWnGro3KVJ0xeD6+sYXdL6PHJo6T79EMjmM+rIWnuQJ7XbpnKbCE4EhVQGIea90VYtc9PTymahCHSp3FNlmy4FBbOfXNj/VYkT5LQnPYewLke42ozSMs3QmHd6ig2QXqaR
2025-08-04 16:00:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-04 16:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 16:00:04 [INFO]: inside itemsold and closed 14409
2025-08-04 16:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:00:05 [INFO]: Ebay item id :: 306000032446 exists in Database
2025-08-04 16:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:00:05 [INFO]: inside itemsold and closed 14409
2025-08-04 16:00:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:00:07 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:00:07 [INFO]: Ebay item id :: 306000028491 exists in Database
2025-08-04 16:00:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:00:07 [INFO]: in processold action queue is array    for {"44592238":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592238","ebayitemid":"306000032446","shopifyproductid":"8803883516126","variants":[{"price":"69.99","quantity":0,"weight":"3","shopifyproductid":"8803883516126","shopifyvariantid":"46254940487902","shopifyinventoryid":"48355563372766","shopifylocationid":"","product_id":"44592238","variant_id":"77484947","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44592233":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592233","ebayitemid":"306000028491","shopifyproductid":"7950262927582","variants":[{"price":"69.99","quantity":0,"weight":"3","shopifyproductid":"7950262927582","shopifyvariantid":"43978883301598","shopifyinventoryid":"46075357003998","shopifylocationid":"","product_id":"44592233","variant_id":"77484942","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-04 16:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 16:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:00:07 [INFO]: Shopify Inventory id 48355563372766
2025-08-04 16:00:07 [INFO]: Shopify Location id 58450641063
2025-08-04 16:00:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:00:07Z","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-04 16:00:07 [INFO]: Change: available | Delta: -1
2025-08-04 16:00:07 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592238 and user_id = 14409 
2025-08-04 16:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484947 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:00:07 [INFO]: Shopify Inventory id 46075357003998
2025-08-04 16:00:07 [INFO]: Shopify Location id 58450641063
2025-08-04 16:00:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16: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-04 16:00:08 [INFO]: Change: available | Delta: -1
2025-08-04 16:00:08 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592233 and user_id = 14409 
2025-08-04 16:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484942 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:00:08 [INFO]: updateIdsQuantity -> ["77484947","77484942"]
2025-08-04 16:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-04 16:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77484947 THEN 0 WHEN id = 77484942 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77484947 THEN 0 WHEN id = 77484942 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77484947,77484942)
2025-08-04 16:00:08 [INFO]: QUANTITY Updated IDs: 77484947, 77484942
2025-08-04 16:00:08 [INFO]: Successfully processed data for user 14409
2025-08-04 16:00:08 [INFO]: Execution Started
2025-08-04 16:00:08 [INFO]: Execution Finished
2025-08-04 16:10:01 [INFO]: Execution Started
2025-08-04 16:10:01 [INFO]: old server sucessfully connected
2025-08-04 16:10:01 [INFO]: sqs client sucess created
2025-08-04 16:10:02 [INFO]: Number of messages in the queue: 1
2025-08-04 16:10:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:10:03 [INFO]: item found in queue is  14409
2025-08-04 16:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwXZECqBZuSJ22rc4C4XnHdgGgILrWSpXL/7f90VgzXb6hAIteOK1LwRN5HkCRvPPlTLCQYfgr7dA8MhqPe1Q8fTTrQIUJI/F1wUYVlaerN+fPYcdlWwiqvpDhdDuCt909ns5+wBPPFfrOQdH6qI+9WlV2DkYhOQK6eXgeu35XYkQAW1QXUVI/gIpy67Ko98BqexvrgJu4ZJaM+7OAQplXAXFANs+UW8Dp2nx3qXiGt/c0TXdJ1tV+Hw1ZQxMp7dEIKj6PAzXDVvbc8iUzcWBu/RM/ZBLhvlMayiw/R1/ymSZ7DRgxx0EU/oRJF2yzNZ6RJx6OKP0p7Dt2FCedPMmPKcdwKlKg3rZ9Vzr8y97n6PViNIWkFcFg8HNIT/j89MHXVVp6SbV8jtU5Inf4TcfdyU/ZU5Xb3WY5YqI5ETVwQkDdPhfh970/MS9kgP49lMF
2025-08-04 16:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-04 16:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 16:10:03 [INFO]: inside itemsold and closed 14409
2025-08-04 16:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:10:05 [INFO]: Ebay item id :: 286747395770 exists in Database
2025-08-04 16:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:10:05 [INFO]: in processold action queue is array    for {"45313104":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313104","ebayitemid":"286747395770","shopifyproductid":"8979656802526","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8979656802526","shopifyvariantid":"47292287549662","shopifyinventoryid":"49404107129054","shopifylocationid":"58450641063","product_id":"45313104","variant_id":"78265617","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-04 16:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 16:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:10:05 [INFO]: Shopify Inventory id 49404107129054
2025-08-04 16:10:05 [INFO]: Shopify Location id 58450641063
2025-08-04 16:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:10:05Z","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-04 16:10:05 [INFO]: Change: available | Delta: -1
2025-08-04 16:10:05 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313104 and user_id = 14409 
2025-08-04 16:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265617 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:10:05 [INFO]: updateIdsQuantity -> ["78265617"]
2025-08-04 16:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-04 16:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78265617 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78265617 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78265617)
2025-08-04 16:10:05 [INFO]: QUANTITY Updated IDs: 78265617
2025-08-04 16:10:05 [INFO]: Successfully processed data for user 14409
2025-08-04 16:10:05 [INFO]: Execution Started
2025-08-04 16:10:05 [INFO]: Execution Finished
2025-08-04 16:20:01 [INFO]: Execution Started
2025-08-04 16:20:01 [INFO]: old server sucessfully connected
2025-08-04 16:20:01 [INFO]: sqs client sucess created
2025-08-04 16:20:03 [INFO]: Number of messages in the queue: 0
2025-08-04 16:20:23 [INFO]: Execution Started
2025-08-04 16:20:23 [INFO]: Execution Finished
2025-08-04 16:30:01 [INFO]: Execution Started
2025-08-04 16:30:01 [INFO]: old server sucessfully connected
2025-08-04 16:30:01 [INFO]: sqs client sucess created
2025-08-04 16:30:02 [INFO]: Number of messages in the queue: 6
2025-08-04 16:30:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:30:03 [INFO]: item found in queue is  14409
2025-08-04 16:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFm5FfGXZilwPb1uRk6vn1ILYszXdKQSfWzBYNsFOwzi7V+fzppKoaIgnzw0lW6mKS+8ETfMwZM4Xtd8Q+B+UbCQPofbwTQKVhdZ4iqMK5q00hXU4lNEzkOrqFfsxUYV4tt3QdLOJ8Xs7xOGr/0ZKhpTTp7ddH8amM9X4qZ7AURkVUNOwsPuSo/d5WuL9PPHDFP5keRFz6TLwaqLMr98C2jPUP2rYK8HxWGZBzVkNqXj9OrtL3X4jJsa6gVtELMxOGvRFX9q96lG6R0MBQ+G8HUCNyjyT1X3wD2zCp8gpkiTT6q1RuCe2l4J/8HBZW0hWDv25gJQrMkLeCRKKU7sL+FWLi/yluz6M+LyiJrWHv3ux/heawLupjCynMkeQ+zPPMf+BAHJ+6w4zsL3i7L5qmr/oHvPSls6FlbFjJ+OyTy9oMIQCAyER7e3yq6Q0JO+K
2025-08-04 16:30:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:30:03 [INFO]: item found in queue is  14409
2025-08-04 16:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBqQDUWNsWulql/Izkc0BbH6EbF0/1FCnJiCeD3IGpLJ1BOGYKxxSglBBOppNJE2m70VbsSf0qy9oNHaagIQrTQETe2LuXha6ha0sKuMLKjbMBnYW4AycnROtgBS0D0kDGu7+LJNm2lUJ7u22Q2LuNbFfF/wXNHnrTDQqJEtAZmU87G7fLLay4Sclq+vhLHmm1JQaryxJ1yurVL+NOMC4bKei8AqnKaQAGQoBgDqCSEUK9GWCB68K0WKexH1X9U3z5+6eHn9STeZ3JDQjXn+DkuYYxK9rjVziZ+nBvTnQJ2Au6hiXD10em98AixVu4zGLyJdFtcOR+VWa/qLqW1foP0GxLp62a8oV02jHn/MCTjAaA8oug/zVVoDktmfzQw3oWYsn/7U8Sav1mbccGqWcWHiLnilO3jk4L3higHa1T+6/kDlgGmZFYKNFmkErxirRM
2025-08-04 16:30:04 [INFO]: item found in queue is if condition  14409
2025-08-04 16:30:04 [INFO]: item found in queue is  14409
2025-08-04 16:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB+/p3Tse1dqT4LQwzaBjcYRhuf7Vd+iNcirZY4WZWftfasuylil/+x9GtZn2KEkWWsMdFObBquupfy75doQf4YVNo7/pnPrm3a7rwAOO8bK401MZh2cnmFUZQ90IXo6cQUMwptYrXmJEFC2dWgfazZYzpsQpuHA2udf0ki9UmJ2dt7pkzzrz3YuumipCH0DaDluRbYKuOYz3DAXC32Fh8vZtkyZbo0LrujAgLEUY2vNreHHZwpwyaYYpDKEYpvL3o5SLaqUz2OPwv455YOUFmsjsm5r/ptJifqxdJm3A5fvJQpvwi+B7g4+kAJjNtMEMl2QVoTWLAOBsYCHRIdC+pl+JzBKdkOcuiel58piES/nkG+250ZQmYn90RCTstlKVubDnxu7lWK5JbGFwbGqhSlE5+yeTZeDfDK22BG1fpsNTYgwi4k5MrNggTzc7UECoF
2025-08-04 16:30:04 [INFO]: item found in queue is if condition  14409
2025-08-04 16:30:04 [INFO]: item found in queue is  14409
2025-08-04 16:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBr7VvWyYrABdPGEm8m1TI/+d/WS68VBbCqcsr6E/lzVxdZb7sW1xrEbXw5rAnuM+EJKBGPhrUyPY5S3E1BaQmJ778bGtZ68A5DbVoAmGTuojQUfb0t/6xU90Ukd/qnkCcvNLHZiiHOsQ9XERJ17ksHpM8YS1jCvl8RAs73VuswxbTiJe3TAdb4r7r2dLQB7DjpyyNltm/3+UahLfxUD2imeCOn6At8EZObl3Gox6PF49ejaJ+tXJVn5VDwLrRYLIrzEyMCctTCg56Panz4BGQTBRzMh4ajvBiHiIIM2+JPkzZz8Pnanf8iBzrqj3FycAt2GcUN05bIUtNN7Uag8f7tHgIASRS5sRz9c0njUi5HVIjhJWPl9jLy11tw7BJfgW3Jd2TmShxIfxh4rIqVhp4T7T1NVdWkdm5kVpzQYsgcXn4gVm0Sm187XDTVliaDJxj
2025-08-04 16:30:05 [INFO]: item found in queue is if condition  14409
2025-08-04 16:30:05 [INFO]: item found in queue is  14409
2025-08-04 16:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBQg6S/ccjq4fMexMROFPSmBKkroX97ETrCWl+fb/Ouw3Yn7DCrbn1zQFzAUYTPGHZSxl6NNcecEcqGX1ckmdmaCwPhTQfB0HYQQWeLgHa2wW6NzWnvANtJ8axiexs9e3elYVIRF2hAUhym3QIG0tM6qMCLobtwB2T4YBz8VBoAnSvK2aWtc8kttvkDNlaItVdrgbn5hcDfmr7kxfmPPvLG68L8jAwQmmM918NlhTSWxa/TO8UObqV5dgapgW5xopbccLi1B5ibLShhCr+ooV1GR4I1SLnwz7ROjau9g/MJpqfKBDtgrq1GGejfA3N0jI6cJ9Na48M+XB+jPIjPnT/+qWjij+LWH+B1VcZZRbJUFtB4K93rippnDbymq+AICy2ksWTRG/WrVdrXT3XBQheiqROkoRqgWeCVlmP1ELcgpSKV3wYcahnV0L/jBZR9vvl
2025-08-04 16:30:05 [INFO]: item found in queue is if condition  14409
2025-08-04 16:30:05 [INFO]: item found in queue is  14409
2025-08-04 16:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB8xAkoL8+tGuEUt92UVzFNlZHdTocQdmBCYLwKroY1bmWU3QYBWxLBPI/EneDOGFbdc4hNWZS6yXc4zT0IHRHjqxPKlY0AH64YfkVS2bAtts+JhCasd6viXNShNkXrC2GVGW1SOkjAnhlRoYwoQeDiqhN2ix/Bs5Y6mEdo//Er7K17Il2sO7YQeKxGVaUjzCYhh+fpRA83+MrQpqnta90T0gmpJSt+leJCoqGOQKbyGE5t213rKXQLSue8I9VaUma1mjGk9A5Ba6OKsgH3TIzQ+KmayA5J5Pank1Z6oPJ+Et/xASJgJlUmWY+Xt6lPg8WT/JWJEaujGSndaYnD33YDunr6/x+he9W0SxGyOKui+C6x0Ws+RizkS9yvTOzRpgO11lylES6VXlQGnM5yLRMTTUQBe2QaJX97sMNVQMuOuTQsi/IqwdVLUt/NuNbag+E
2025-08-04 16:30:05 [INFO]: Processed 6 messages, reached the limit of 6.
2025-08-04 16:30:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 16:30:05 [INFO]: inside itemsold and closed 14409
2025-08-04 16:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:30:07 [INFO]: Ebay item id :: 286048413452 exists in Database
2025-08-04 16:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:30:07 [INFO]: inside itemsold and closed 14409
2025-08-04 16:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:30:09 [INFO]: Ebay item id :: 325737130349 exists in Database
2025-08-04 16:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:30:09 [INFO]: inside itemsold and closed 14409
2025-08-04 16:30:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:30:10 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:30:10 [INFO]: Ebay item id :: 405871616163 exists in Database
2025-08-04 16:30:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:30:10 [INFO]: inside itemsold and closed 14409
2025-08-04 16:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:30:12 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:30:12 [INFO]: Ebay item id :: 335422308955 exists in Database
2025-08-04 16:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:30:12 [INFO]: inside itemsold and closed 14409
2025-08-04 16:30:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:30:14 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:30:14 [INFO]: Ebay item id :: 326382374660 exists in Database
2025-08-04 16:30:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:30:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:30:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:30:14 [INFO]: inside itemsold and closed 14409
2025-08-04 16:30:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:30:15 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:30:15 [INFO]: Ebay item id :: 325745811863 exists in Database
2025-08-04 16:30:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:30:15 [INFO]: in processold action queue is array    for {"44560053":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560053","ebayitemid":"286048413452","shopifyproductid":"8697498042590","variants":[{"price":"37.99","quantity":0,"weight":"2","shopifyproductid":"8697498042590","shopifyvariantid":"45939297190110","shopifyinventoryid":"48037756895454","shopifylocationid":"","product_id":"44560053","variant_id":"77452733","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44658601":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44658601","ebayitemid":"325737130349","shopifyproductid":"8090466189534","variants":[{"price":"124.99","quantity":0,"weight":"3","shopifyproductid":"8090466189534","shopifyvariantid":"44274100371678","shopifyinventoryid":"46371240345822","shopifylocationid":"","product_id":"44658601","variant_id":"77563821","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44989779":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44989779","ebayitemid":"405871616163","shopifyproductid":"8938594894046","variants":[{"price":"12.99","quantity":0,"weight":"2","shopifyproductid":"8938594894046","shopifyvariantid":"46995068158174","shopifyinventoryid":"49106460901598","shopifylocationid":"58450641063","product_id":"44989779","variant_id":"77910753","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554646":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554646","ebayitemid":"335422308955","shopifyproductid":"8532369637598","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8532369637598","shopifyvariantid":"45479578042590","shopifyinventoryid":"47577562480862","shopifylocationid":"","product_id":"44554646","variant_id":"77447326","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673400":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673400","ebayitemid":"326382374660","shopifyproductid":"8784625959134","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8784625959134","shopifyvariantid":"46206094508254","shopifyinventoryid":"48305915822302","shopifylocationid":"","product_id":"44673400","variant_id":"77578620","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44677680":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677680","ebayitemid":"325745811863","shopifyproductid":"8096015646942","variants":[{"price":"147.99","quantity":0,"weight":"2","shopifyproductid":"8096015646942","shopifyvariantid":"44284258222302","shopifyinventoryid":"46381443186910","shopifylocationid":"","product_id":"44677680","variant_id":"77582900","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-04 16:30:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:30:15 [INFO]: Shopify Inventory id 48037756895454
2025-08-04 16:30:15 [INFO]: Shopify Location id 58450641063
2025-08-04 16:30:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:30: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-04 16:30:16 [INFO]: Change: available | Delta: -1
2025-08-04 16:30:16 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560053 and user_id = 14409 
2025-08-04 16:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452733 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:30:16 [INFO]: Shopify Inventory id 46371240345822
2025-08-04 16:30:16 [INFO]: Shopify Location id 58450641063
2025-08-04 16:30:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:30: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-04 16:30:16 [INFO]: Change: available | Delta: -1
2025-08-04 16:30:16 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44658601 and user_id = 14409 
2025-08-04 16:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563821 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:30:16 [INFO]: Shopify Inventory id 49106460901598
2025-08-04 16:30:16 [INFO]: Shopify Location id 58450641063
2025-08-04 16:30:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:30: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-04 16:30:16 [INFO]: Change: available | Delta: -1
2025-08-04 16:30:16 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44989779 and user_id = 14409 
2025-08-04 16:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77910753 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:30:16 [INFO]: Shopify Inventory id 47577562480862
2025-08-04 16:30:16 [INFO]: Shopify Location id 58450641063
2025-08-04 16:30:16 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:30:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:30: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-04 16:30:17 [INFO]: Change: available | Delta: -1
2025-08-04 16:30:17 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:30:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:30:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554646 and user_id = 14409 
2025-08-04 16:30:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447326 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:30:17 [INFO]: Shopify Inventory id 48305915822302
2025-08-04 16:30:17 [INFO]: Shopify Location id 58450641063
2025-08-04 16:30:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:30:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:30: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-04 16:30:17 [INFO]: Change: available | Delta: -1
2025-08-04 16:30:17 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:30:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:30:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673400 and user_id = 14409 
2025-08-04 16:30:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578620 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:30:17 [INFO]: Shopify Inventory id 46381443186910
2025-08-04 16:30:17 [INFO]: Shopify Location id 58450641063
2025-08-04 16:30:17 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:30:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:30: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-04 16:30:17 [INFO]: Change: available | Delta: -1
2025-08-04 16:30:17 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:30:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:30:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677680 and user_id = 14409 
2025-08-04 16:30:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582900 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:30:17 [INFO]: updateIdsQuantity -> ["77452733","77563821","77910753","77447326","77578620","77582900"]
2025-08-04 16:30:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6
2025-08-04 16:30:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77452733 THEN 0 WHEN id = 77563821 THEN 0 WHEN id = 77910753 THEN 0 WHEN id = 77447326 THEN 0 WHEN id = 77578620 THEN 0 WHEN id = 77582900 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77452733 THEN 0 WHEN id = 77563821 THEN 0 WHEN id = 77910753 THEN 0 WHEN id = 77447326 THEN 0 WHEN id = 77578620 THEN 0 WHEN id = 77582900 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77452733,77563821,77910753,77447326,77578620,77582900)
2025-08-04 16:30:17 [INFO]: QUANTITY Updated IDs: 77452733, 77563821, 77910753, 77447326, 77578620, 77582900
2025-08-04 16:30:17 [INFO]: Successfully processed data for user 14409
2025-08-04 16:30:17 [INFO]: Execution Started
2025-08-04 16:30:17 [INFO]: Execution Finished
2025-08-04 16:40:01 [INFO]: Execution Started
2025-08-04 16:40:01 [INFO]: old server sucessfully connected
2025-08-04 16:40:01 [INFO]: sqs client sucess created
2025-08-04 16:40:02 [INFO]: Number of messages in the queue: 4
2025-08-04 16:40:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:40:03 [INFO]: item found in queue is  14409
2025-08-04 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBm8iJY9wQNqVWmWz4Qkkp5ULMgnHBMHM06vglUVKnLVKFqtiiD1wOfi9PgyoB86i2/P83bZ5QD8rvHAk0b5S24zrxNocgutqkPGFbdy2/DwrJIlziIgT8qT7/X1JWXSs0GnKGBwpgcdBW4ZQUhGUjSfaSUesq1xdjy5f5n76Dhq4NlEnoIVTO/ZAj8M9meEEIbGaVJuJ6j9+Vy5T6oe9e4XGA3aIx+hAj5QiECWQW6mxsg1QzWlkBjUbYogtgPKBlc87Y088B1JqzRKpCbHmvnOAVtjgf05eEpCgdG3Ohz1E+bbZqrIOrTf/EqJVWgpUhaFDiNlNjuJAFVoqVHmxvv/NXnere7Bm1txvjUW1gOCPO1eiiRrJStrv058zgonh/n6C4zHESKJlHo09Ayz2OE+cg0jCvHKkamFdXh5Xdnbax2K3A9Hzb01jmHoVzLLA3
2025-08-04 16:40:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:40:03 [INFO]: item found in queue is  14409
2025-08-04 16:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBS0K3fw/vcts9gWQYR+gxJUVsWz6r3TDBW3xUdl9S5L5MQj6odw3nc+uPOOl6ClRsIQTsr9/97/UyHLEK3+4jsmcfI+dHpz1s7DQdMBGB27XeGFJ8yJsTeEgz8rGO4ZMRO5hd1xUxOorRWA4ySfw8d6hfB4XfVKwoV8HY70qYmj33CmHdLBWesYO8EU4KNNc7wGYh1MQC9oCOWHdWOMp+XrXDWiS5ouJVx1WrWoR51dDR2KHv0vd/Si/ZplsOSqc4JTgiPnanofdwaIumw+U0MqLp5iANHvob0wWGyxyBKGWudzQrtCcHypFcRQla2pbxcOkfTgwC2qQMsIuLAHbXqc05rtiq3xM1+9FFnFm93tIAaKhIA7zgzQB4BInpIAa84IRG1hlCwAIFkQhcNgA6reGCLqSJOeO1xRG64Kg8s0683jpti6GqjokwoOTuNC2t
2025-08-04 16:40:04 [INFO]: item found in queue is if condition  14409
2025-08-04 16:40:04 [INFO]: item found in queue is  14409
2025-08-04 16:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBa+0IGEHJ6FCo2uXR21HkQFewOWCHL8rA7KBXaYfT7UfyE11xrjCRyV78S20lnPND7f5bxYlpEZz7EkUPESJbRAjnNza5GFhuu3CbfblT8cKqju6pWEbhdu8n7sAAFOj/MdV3sUdWG+6ISdSjeFy1z0ucdaLyA4vfMYtFNrPZiDHVU6BfKOVhAax7cDGxZ23PrQUkSfo/ggTL9YIEt4jrtKaWay0yz6oD3iOi6YV7gFMnp2TEPUeDnSFHTKbPeH1Iig0VPu8v1zWN6Bx+d1pkvG6cVcybzBc37nQLTDxFYpmVSc12BEaZ6K3sxv2aRpyWkFmjA+C6TX8zuMvSWA+Gl3Txwvoo+3Yizso5VqZMekSo1m3N/2UvLTjX5HYYO/VhbkEMu8p4P1udxxSVfhjgoMaCXjX4mTFWta4YQ7oXUsdqMiV1cbMe/kD5UOjyMy7H
2025-08-04 16:40:04 [INFO]: item found in queue is if condition  14409
2025-08-04 16:40:04 [INFO]: item found in queue is  14409
2025-08-04 16:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBkOA6EAP3IitWcAo6GGi4zQeobnGhZOxW758CWJvUdiZHbhZbhFFbIEN7Ot+5V7VpS/9obVPkaJ21QGsoFcNXZOyAhhcRmXrpRk50bPeYnHbIkopW4EQs1c7Epu3d4cnWwpvkDdfsz70obf2a/IrOhs2Ga1TjesFybFW6uzfpowuNWoqUIDZr1BMGy1/iIH+NE9vic4EHh9tGOxeKf3C5YeTrIYR5RZxkk3nbRetU5OUXwDLhRQbk+j9nlRQogpZOflsFGpU08kcAh+HYwtHBxE0FInF2tXIo5Xpu8PQ/AYOq1Gp7sRUpcvjgkYwPDeH1lwmTIwstfJXvlZsq3rLGA1DlxT7own3Va/5jMWuXIyrRerD/xYGu1Y/xena6YTGunzK1TE1+UEdeKmsXFT0haeQ+wfp/NUbmAzKnAHOmGE5UJwT3aDmdHpjRu1rZ94Aq
2025-08-04 16:40:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-04 16:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 16:40:04 [INFO]: inside itemsold and closed 14409
2025-08-04 16:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:40:06 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:40:06 [INFO]: Ebay item id :: 285930234559 exists in Database
2025-08-04 16:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:40:06 [INFO]: inside itemsold and closed 14409
2025-08-04 16:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:40:08 [INFO]: Ebay item id :: 335552484941 exists in Database
2025-08-04 16:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:40:08 [INFO]: inside itemsold and closed 14409
2025-08-04 16:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:40:09 [INFO]: Ebay item id :: 225692288755 exists in Database
2025-08-04 16:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:40:09 [INFO]: inside itemsold and closed 14409
2025-08-04 16:40:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:40:11 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:40:11 [INFO]: Ebay item id :: 335973905889 exists in Database
2025-08-04 16:40:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:40:11 [INFO]: in processold action queue is array    for {"44592962":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592962","ebayitemid":"285930234559","shopifyproductid":"8699162034398","variants":[{"price":"17.99","quantity":0,"weight":"2","shopifyproductid":"8699162034398","shopifyvariantid":"45943393878238","shopifyinventoryid":"48041884975326","shopifylocationid":"","product_id":"44592962","variant_id":"77485671","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595551":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595551","ebayitemid":"335552484941","shopifyproductid":"8700387524830","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8700387524830","shopifyvariantid":"45946875281630","shopifyinventoryid":"48045431521502","shopifylocationid":"","product_id":"44595551","variant_id":"77488260","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44677573":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677573","ebayitemid":"225692288755","shopifyproductid":"8096015745246","variants":[{"price":"11.99","quantity":0,"weight":"0.5","shopifyproductid":"8096015745246","shopifyvariantid":"44284258353374","shopifyinventoryid":"46381443317982","shopifylocationid":"","product_id":"44677573","variant_id":"77582793","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44835336":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44835336","ebayitemid":"335973905889","shopifyproductid":"8926440227038","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8926440227038","shopifyvariantid":"46838187851998","shopifyinventoryid":"48936676917470","shopifylocationid":"58450641063","product_id":"44835336","variant_id":"77746195","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-04 16:40:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 16:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:40:11 [INFO]: Shopify Inventory id 48041884975326
2025-08-04 16:40:11 [INFO]: Shopify Location id 58450641063
2025-08-04 16:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:40: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-04 16:40:11 [INFO]: Change: available | Delta: -1
2025-08-04 16:40:11 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592962 and user_id = 14409 
2025-08-04 16:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485671 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:40:11 [INFO]: Shopify Inventory id 48045431521502
2025-08-04 16:40:11 [INFO]: Shopify Location id 58450641063
2025-08-04 16:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:40:12Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-04 16:40:12 [INFO]: Change: available | Delta: -1
2025-08-04 16:40:12 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595551 and user_id = 14409 
2025-08-04 16:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488260 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:40:12 [INFO]: Shopify Inventory id 46381443317982
2025-08-04 16:40:12 [INFO]: Shopify Location id 58450641063
2025-08-04 16:40:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:40:12Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-04 16:40:12 [INFO]: Change: available | Delta: -1
2025-08-04 16:40:12 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677573 and user_id = 14409 
2025-08-04 16:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582793 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:40:12 [INFO]: Shopify Inventory id 48936676917470
2025-08-04 16:40:12 [INFO]: Shopify Location id 58450641063
2025-08-04 16:40:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:40:12 [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-04 16:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44835336 and user_id = 14409 
2025-08-04 16:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77746195 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:40:12 [INFO]: updateIdsQuantity -> ["77485671","77488260","77582793","77746195"]
2025-08-04 16:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-04 16:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77485671 THEN 0 WHEN id = 77488260 THEN 0 WHEN id = 77582793 THEN 0 WHEN id = 77746195 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77485671 THEN 0 WHEN id = 77488260 THEN 0 WHEN id = 77582793 THEN 0 WHEN id = 77746195 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77485671,77488260,77582793,77746195)
2025-08-04 16:40:12 [INFO]: QUANTITY Updated IDs: 77485671, 77488260, 77582793, 77746195
2025-08-04 16:40:12 [INFO]: Successfully processed data for user 14409
2025-08-04 16:40:12 [INFO]: Execution Started
2025-08-04 16:40:12 [INFO]: Execution Finished
2025-08-04 16:50:01 [INFO]: Execution Started
2025-08-04 16:50:01 [INFO]: old server sucessfully connected
2025-08-04 16:50:01 [INFO]: sqs client sucess created
2025-08-04 16:50:02 [INFO]: Number of messages in the queue: 7
2025-08-04 16:50:02 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:02 [INFO]: item found in queue is  14409
2025-08-04 16:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBp5kb8pDLKcrlHFM3Ske0oF1oEW15LJfQu5/1b5XsE5oN+nqSjJIVKTq4VA+gIA7Al+VHgmjvVPHlIEwLuPn7fbrb78y4n9d650sU7vO+dnz/ST7ZMmXN1YXm2698+P6+Qwe5Pcggs9hX/2B3v5f/tOzN/SDmtmGhKTSvmc8jopk6Rgrb6q5J15DsR8g82tHuCgUeK+7Sjt3Q92c3K2LyfVF4EKPoVMvdlNMBNgZXQHKP5pi6ZnvUbkrWYV96fTEi2bRmSX3RaSuRW/o+6CiUCyVtoJUEu8q8UQpY2wi4JBVeuEho0EgxSvDCOakAYmYFfvcXBRfIG/2VzOO7khIg3ntFi5Q7KJchffKLhswuJ2ZnlyPsUuIURsUGCrWnrKhMowd4ULadnI+oLi9chbfl2vDlJRwHozh1BfELw3bI54fHL6PfWD/tX014nG9GXzes
2025-08-04 16:50:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:03 [INFO]: item found in queue is  14409
2025-08-04 16:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBM2iTvTqUj1A4xLUjn9n3K7+dqKW801miJzd4LWT7xuyuaNfiB9S5bIw2imO1Vm+K4ExMWoakX4JaIx36TqCnuqp+tl5Rxv+VI0+CpqwWCcn+IR6BVpV2wZVVlRCnznKLCzVtGnvszJGeAvohNFCgaqBs+NtTkw//wIa61Nj8dvL7Vz6S9R1iD6HP4hsqccXmshOiesdW3SFAJ9QJ89Q64N4X9YeCBYVXAgFSdyLeKoHBaYhv368b8hM/rhyhsPizTdKy6RtrHYVs9/out55FjscPqCpZUUOqWOKaDBYsKD7KyxMOBZTaow9Ia5XdcCTqfbGaraY9t4y1jZMRJ39fidHfWY5b9m5f3N9zvi+NQnyh4tKg4fyA4T4zek+Mn5AMcZ9iFZDe4pVRUihMgSNI2mIpOD1d/UcDUa3lOPequlXLKWLwCNHsUYPsiWMdHNy8
2025-08-04 16:50:03 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:03 [INFO]: item found in queue is  14409
2025-08-04 16:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBFK9LRRQYVmI0FLo+LRREaXvN3KPT6Tob4GlbHiFf9Rd/C8GTmPLKKslhTe81+eJ8si2I7HVbgyPh9d89UbYbl6vojQjCf+Kzvzm4rqI6mM8tiuUspu5Z5T70qb59PNtdkvJmyfKsFk/XTFdl2er8/G6WfbaNjT4Ne8K7fzX8I6afTpYigbJ1tuGtMEHVn2P1/9reP8i8jPr3Mm9h1MLRnMy6oF/p7u5q5hJ7+zndKIA35aJcJ8DoZ7Bmd3pTJEjWXNbQ1ELYlrvWVg0/diXCg5D805u17VCcH4iSCI5cn+Y0D83JGCNDD5vG+6Uzdlv5Z7vmLEfs3JwAH9OogoPPVceTfg21hIBgs/ST8iLV9GG5PlfPvdXxUQHnepnqSA99teozs98ThjM5qZTnY/m7jyrIYZv+ErIeqfnr4XwKzfVjWSV5bjr7eNj7xhtdkmYR
2025-08-04 16:50:04 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:04 [INFO]: item found in queue is  14409
2025-08-04 16:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBwBtVP3VloxFbRIzn+IpXfr9oNQ8rQSOZzNIGP7WZpwCuSKYNIZBF32AvkcQJXRwJeggmxgSnLV5lUZN+ElTcE2dKzx7rEz4ztbIhAaQYBUWhlnCIJMFOhlf3ZuAhImmNmTTCnyBhzKDtugdRgoIqrXLgc2rv87+yRTPdvQ54Ts6B0lAfQZk/zOONqZCZ0WrCWskd2phcCcdMtxjw6OPm2kKyNjXLYTfJi5grlyvq7e16nPWpIn/ETh2LnR83jdkOz0QIuZ11UI1J/fE/I/NxaB7C+220MY2Zlwngpz5hGLKq1rc99Km6QMl7KO9r7ud/YDPvp/lubVd7foo8ZFYkfZ5FUGFoxyMTjuaTQfh7ndV32kn2VISrJv5A4PvIUsWPtDgl/odWvLeWcLFboB5Nrj2nG77me0IzISlANMH0i7NC142mATCGtf7hHlerxGN0
2025-08-04 16:50:05 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:05 [INFO]: item found in queue is  14409
2025-08-04 16:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBev5fMu4QPSJ2Brzz2UiLWAFCd26HHFVjhlNz5lTlVXCc84eFu1nirQyWwuUVr8gLekXHO2pjkVB0Wwj3Inf0cM7GJYHDnfrauiFjH0EIpjiZ2YmeXmsrhuX12TYPHU497235G8tSvVQOXf3lfzyYxpciuddPu+Exf6T0+BnO/BzhddTu5XhjBgDpbzr/sRKWdYMIubwdQ+uEprEA+XfL1rcsKE3/E8Geth0c0vDosQC4NEB9K6lBj8YJFaVdXYOC7NfagpyIgFAkjTyN8QzDsARxmUOXImQ7ABbWzlkeCCq3DrWBXgmMqzuo5vyxuy2W3DIyWI2eHyC1XjNiuaUxnJPFB2cOi12D75FLrJmYnvyPmggMFn/JwJoSMHh1OCcXKj4PjUBcSY4sb1iNehU4TwrLO6Pmvxq89w5Mc7mtqz921K3cIOyC4ggR3LZDi/bR
2025-08-04 16:50:05 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:05 [INFO]: item found in queue is  14409
2025-08-04 16:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEB6ymfS7iT/w158DYUv85XWDEJZaM9tLTPdtPm1miBHKTMB/oMN74e0ndznROAISCsm/m6DMlq5jjv5tBvL0z9OhJxMIr5nDGNKX8JKSg79jL/AOu5sPFOAXA2BYm5BtZTfEG1zu8WmwjBcjxiWwbjTke+4tShFTehm7UTIDDmeKJ5SwkCTmpxYIfiHrR7z0htnJ/AWABWYW8CznKcjtQPP1+hP5HF4FPXMxBsPaK+DO2YLCHfZ7NoLyh6pjaohUqXiwFeZKVBuGYImBK2iNdlAdLuvR1o9wyKTSFF2CtapQmR6zvnsfi5eBofWPezA0jqOFyPFWLlJxqp6dUznyNQCq7TG7lo0sNpesCxvy+JNs+DrZztXZnoquVGyWtbhF6++kEJ9TTVeGBz/fzXerJBwwWMEWHW984QbKS1NjU9SoZu9xteNpM9TNfFnFN89l/C
2025-08-04 16:50:05 [INFO]: item found in queue is if condition  14409
2025-08-04 16:50:05 [INFO]: item found in queue is  14409
2025-08-04 16:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBAJ3/bpItFxdmg2PPPHJFdqnlyIOVbMMabgVbj1OHesZ/M1McyU3dKCdWZ+Euq1eaeviBJOkYH/Ax2ROwSlOcX+QMjjj0+ZVaUslEEfJIYlpLuevg/uE+Tj8EdH3hk7ucC5zOU4kARLq2GkZcMsbLSY6PEj7DqGrf9oj8hqBwSKRJbfDreAwHRoHfVwERPHBGHlwGJ/UYF3WMCrr/zuMUnaWWPWFFAcDocsgG6x1hNvKJuibW+RXllUwOFGh+ELX1Ah58mOvxPpTOdasBaS+hT3iaOzZzgARNqaxOvKFjp5bxiTqTEK2hn+x09FQtWahT/xD9glKa+VW4/uYaYrxh7VAbgpXCNTIpc+bBumhXxqfyUuGS/xcoWIRPF3PdHw4HO0sC0OE8qVV+GWnScGz+6EBsR+Hbqp1Jx2LpPVDMxS1lSRc3Pqm/Ypltz6PdEQZ7
2025-08-04 16:50:06 [INFO]: Processed 7 messages, reached the limit of 7.
2025-08-04 16:50:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 16:50:06 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:09 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:09 [INFO]: Ebay item id :: 334956135982 exists in Database
2025-08-04 16:50:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:09 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:11 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:11 [INFO]: Ebay item id :: 225500793320 exists in Database
2025-08-04 16:50:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:11 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:13 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:13 [INFO]: Ebay item id :: 326382378715 exists in Database
2025-08-04 16:50:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:13 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:14 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:14 [INFO]: Ebay item id :: 226511578538 exists in Database
2025-08-04 16:50:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:14 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:16 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:16 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:16 [INFO]: Ebay item id :: 326382378715 exists in Database
2025-08-04 16:50:16 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:16 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:18 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:18 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:18 [INFO]: Ebay item id :: 326141856587 exists in Database
2025-08-04 16:50:18 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:18 [INFO]: inside itemsold and closed 14409
2025-08-04 16:50:20 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 16:50:20 [INFO]: autolink for user_id 14409 is 1
2025-08-04 16:50:20 [INFO]: Ebay item id :: 225692354037 exists in Database
2025-08-04 16:50:20 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 16:50:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 16:50:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 16:50:20 [INFO]: in processold action queue is array    for {"44582088":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582088","ebayitemid":"334956135982","shopifyproductid":"8090908426462","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8090908426462","shopifyvariantid":"44274946572510","shopifyinventoryid":"46372086612190","shopifylocationid":"","product_id":"44582088","variant_id":"77474797","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44686452":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44686452","ebayitemid":"225500793320","shopifyproductid":"8000853704926","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8000853704926","shopifyvariantid":"44111345680606","shopifyinventoryid":"46208201228510","shopifylocationid":"","product_id":"44686452","variant_id":"77591677","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673418":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673418","ebayitemid":"326382378715","shopifyproductid":"8922103840990","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8922103840990","shopifyvariantid":"46811560837342","shopifyinventoryid":"48910031093982","shopifylocationid":"58450641063","product_id":"44673418","variant_id":"77578638","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673413":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673413","ebayitemid":"226511578538","shopifyproductid":"8922103546078","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8922103546078","shopifyvariantid":"46811558084830","shopifyinventoryid":"48910028341470","shopifylocationid":"58450641063","product_id":"44673413","variant_id":"77578633","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681645":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681645","ebayitemid":"326141856587","shopifyproductid":"8512659488990","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8512659488990","shopifyvariantid":"45434940326110","shopifyinventoryid":"47532919488734","shopifylocationid":"","product_id":"44681645","variant_id":"77586870","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44677758":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677758","ebayitemid":"225692354037","shopifyproductid":"8096043696350","variants":[{"price":"11.99","quantity":0,"weight":"0.5","shopifyproductid":"8096043696350","shopifyvariantid":"44284298297566","shopifyinventoryid":"46381483262174","shopifylocationid":"","product_id":"44677758","variant_id":"77582978","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-04 16:50:20 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 16:50:20 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:50:20 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:50:20 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:50:20 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:50:20 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:50:20 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 16:50:20 [INFO]: Shopify Inventory id 46372086612190
2025-08-04 16:50:20 [INFO]: Shopify Location id 58450641063
2025-08-04 16:50:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:50:20 [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-04 16:50:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:50:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582088 and user_id = 14409 
2025-08-04 16:50:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77474797 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:50:20 [INFO]: Shopify Inventory id 46208201228510
2025-08-04 16:50:20 [INFO]: Shopify Location id 58450641063
2025-08-04 16:50:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:50:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:50:20Z","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-04 16:50:20 [INFO]: Change: available | Delta: -1
2025-08-04 16:50:20 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:50:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:50:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44686452 and user_id = 14409 
2025-08-04 16:50:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77591677 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:50:20 [INFO]: Shopify Inventory id 48910031093982
2025-08-04 16:50:20 [INFO]: Shopify Location id 58450641063
2025-08-04 16:50:20 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:50:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:50:21Z","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-04 16:50:21 [INFO]: Change: available | Delta: -1
2025-08-04 16:50:21 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:50:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:50:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673418 and user_id = 14409 
2025-08-04 16:50:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578638 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:50:21 [INFO]: Shopify Inventory id 48910028341470
2025-08-04 16:50:21 [INFO]: Shopify Location id 58450641063
2025-08-04 16:50:21 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:50:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:50:21Z","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-04 16:50:21 [INFO]: Change: available | Delta: -2
2025-08-04 16:50:21 [INFO]: Change: on_hand | Delta: -2
2025-08-04 16:50:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:50:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673413 and user_id = 14409 
2025-08-04 16:50:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578633 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:50:21 [INFO]: Shopify Inventory id 47532919488734
2025-08-04 16:50:21 [INFO]: Shopify Location id 58450641063
2025-08-04 16:50:21 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:50:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:50:21Z","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-04 16:50:21 [INFO]: Change: available | Delta: -1
2025-08-04 16:50:21 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:50:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:50:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681645 and user_id = 14409 
2025-08-04 16:50:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586870 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:50:21 [INFO]: Shopify Inventory id 46381483262174
2025-08-04 16:50:21 [INFO]: Shopify Location id 58450641063
2025-08-04 16:50:21 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 16:50:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T16:50:22Z","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-04 16:50:22 [INFO]: Change: available | Delta: -1
2025-08-04 16:50:22 [INFO]: Change: on_hand | Delta: -1
2025-08-04 16:50:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 16:50:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677758 and user_id = 14409 
2025-08-04 16:50:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582978 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 16:50:22 [INFO]: updateIdsQuantity -> ["77474797","77591677","77578638","77578633","77586870","77582978"]
2025-08-04 16:50:22 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6
2025-08-04 16:50:22 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77474797 THEN 0 WHEN id = 77591677 THEN 0 WHEN id = 77578638 THEN 0 WHEN id = 77578633 THEN 0 WHEN id = 77586870 THEN 0 WHEN id = 77582978 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77474797 THEN 0 WHEN id = 77591677 THEN 0 WHEN id = 77578638 THEN 0 WHEN id = 77578633 THEN 0 WHEN id = 77586870 THEN 0 WHEN id = 77582978 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77474797,77591677,77578638,77578633,77586870,77582978)
2025-08-04 16:50:22 [INFO]: QUANTITY Updated IDs: 77474797, 77591677, 77578638, 77578633, 77586870, 77582978
2025-08-04 16:50:22 [INFO]: Successfully processed data for user 14409
2025-08-04 16:50:22 [INFO]: Execution Started
2025-08-04 16:50:22 [INFO]: Execution Finished