2025-08-06 11:00:01 [INFO]: Execution Started
2025-08-06 11:00:01 [INFO]: old server sucessfully connected
2025-08-06 11:00:01 [INFO]: sqs client sucess created
2025-08-06 11:00:03 [INFO]: Number of messages in the queue: 7
2025-08-06 11:00:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:04 [INFO]: item found in queue is  14409
2025-08-06 11:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEB7JZDgFbJtJfpms0Nw3fLrhtsyWsLuccE8Hd8SHPW4oeELzFX7rpCr59fdYqaCvJaHbi0790sYxjAoBdimgxWkbgQteAhvVepPfLf008+R1dDLf6cElGih7dOkHzBFL63IgsX7b1+6o1fWFJN6GwLdi0kLR4NWRTWSHMtm8Mtrx/o781CM17p4tTBXW5SyZIr/47MYFXnq/lYjOAPP6vb8oLVHA1VVHFn7pYFgoOKh0zvR+9HWOEf24tDtgfjv+WZDynNXNzXtNJKcTFtz7ecaL0RLVsWrzUS1xKxIXAvVK9dZoM7nDlr4PM/jIbW4rXXny8CYr11L5c+41Bq+Ip39jL6QERbuZUDC8AFiwK6cbZLs6YqTu3UyQFD2E4WibCact0ZnVz3pmuDDx7GuW9AgEr7PBb0gy1b+2kzHO4McjmODJY2JLdSK2/9Z/P1ykpJ
2025-08-06 11:00:05 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:05 [INFO]: item found in queue is  14409
2025-08-06 11:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBogOmkfZnGNwZOFEG/P5pGU0owRGfvxNN6fdhh/tpGk1eQYbpu2mEn7J5nJHlQjvzLtKAPXzXW3RzaQybuKRPk3BBV61HWLovQrVn1TelmAlQ7JsU+Vw+aefYhnol2RwxBh5rCY7amHb12bt1HDe3jwMMz/nspqw9dSBe7+UEpAzxv8IPWbkmwM9Mkg3l2eTp1h/pHGPxb19mFLQEeIWb3G99NYdUyI5WzTernFZyfjmO+wSGshZfAQ4Nh/JGv0HUQw/co+alXLzeuPbYm26PyJ0EOObYQklGNld+MR56WY2c8O0Z7roXbzRkjBeKqUwgMNE2+Zagc5LFsfsHaghG9OwUM/WR/eYCScVKAJb5aOwaWG98Zk4OXLZLzJhr6HY+tTYzJgsvBmsWi1OLdcAJO9FSZQjUuiAOuexiqSv1h3Kwjjs57lpIrIVfPuhEPZim
2025-08-06 11:00:06 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:06 [INFO]: item found in queue is  14409
2025-08-06 11:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBKlw1OZ9c+9sj5BjyEIeCBCfOedZoaYPjAHX5uEwNesmYWcQeT5XhKTRKCmIacI9a+hO9BEW6Pe+oAn5CZ8DMlfDLv9rlFInT0xZ+prLp88PcG5labiitgU1qUPE19cbOmun/84BsixVaZJUj2n+wvU6To5sSgc9NWi66SDUNhRdVzeWOf7+wKwD6Oap2YdzsxVUUbXHClObtdLTs+9eKezFLGISpwBZrRBk2+mnnmkjP8WSx+3ZHwnHNQg5F9rqWgnQUJLxRxwptsYKtvblJQk2saoNIR0goSfYM4AEPUKN4t4vyBqlKq3lApaRbqQ4bYWiARBEP6CphOaahHQBygACmz//LDbhSWBEzmYqkodYqlW0HwcdkWE7j/LV+ksx9r/BVhuN/sKAbggLAnLydPvDnh4bWdy9wtUpNLgMjuUzatVpXKlnW2b2MaotBI4pl
2025-08-06 11:00:07 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:07 [INFO]: item found in queue is  14409
2025-08-06 11:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBequVl8m6b7cTjH2mfwmZ7G4kFKN/PC5tIRdlJWPIqyVgkTB9HlySPTse9H+XDoFv0SFay5YTUTnSgNYsjp/auygc4K6cMNsNpLfirKSiGO4J/ellsO9jfmqEejR7MQoSlsJkx6MDjz4eELS9LBYmsvoNykch0zqdm07L+XzV+F6W5zQddajAtpET3f+qY6QmYrm5eRLkhptR996f1eJzIOZxZFUh87N44A/Mm3yw17MFqEw3fAhhzDMB8WYMU+HDvsL0s5Za9Ak5k9fOXjOaEb4N2KsWK4/c4Uxql68zJZEqNqZ70CBBaw28RZKADSh4Bq1CnpQDiap4X6KxY58uHlq0yaRPjhcMqFt3wfDzeimD/31CRsrrR52uN6dImGh/2yEm2gxyK98fwiWPN9b2Xmz6eGgqZxr/Yhj0qs8pnDcNq8FGoqt/aNQ5RhoLOlLl
2025-08-06 11:00:08 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:08 [INFO]: item found in queue is  14409
2025-08-06 11:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEBfbINW+XwkWNiU5L9b4WmiikG75L9NTUFayyU3o4iP0r1nwA1ZTlU0bkzlyK8szZZi43R0vuMMuLiBLv4P1hY60nQjwr9YnA0BTgpwVuAa31meHCYu3m5nGIW85AY8fS1JQk450xL370TspST6hu8OLFrXA4dcn+aZuD3FANxTgWZkXawv/MZsW6WBICM+QpulXLn22YEU23jTmuTilJWgxFvBiqKDc65XFemRIYZqgF4R6bjBFPI8bQEs3f2K8+qv1WlhgmpYuzUQmEyfxl3N9JKR6Nqa9IG03JGkxiQANSqTgsawebuoO9s3881mp2H7VjFS70fQtsHO4AwLVWtFA+OmyYDm6CqBRoXgJKkr7DZG9toGNrAL3z3wfph3vA+LqbAomfoJYKpTxogGKnKmmNijHP8dEkG19+QhwrQFtfeL0MZ3WxB2OM1CQrBbQac
2025-08-06 11:00:09 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:09 [INFO]: item found in queue is  14409
2025-08-06 11:00:09 [INFO]: Message deleted from the queue for receipt handle: AQEBYooyBybjfRivYYll3kA7iJG2KQIMiBCcyriV61Z/ZOutzhO+WD5B/Xhn3bGkeR0tRfxiS7OhzjDVUzELX1fBdCzc32tn4vAf2lFId2kWp4VhaAwY3xd595JbHL76GoYtQG7No7c7IOaI/o1taImXXK5MBQAYAOpay3/8nLpFu6BBlSzw8Tk6vZ7AZ6s3/AZ/8tXCb1MJTradWd7Tuo3ogattj93Y03k7ceXwbkbv8td0SDqU3hbQs7G0vTn57oqWU6hEg8N8LCN+n3dvdnmcpYtIBMpOLN9PLk/qgYCUQcVAEBUsQaT7Km+/stfNeZks1IES2NoII1NsTE0VWugiC6mQOJikfwDwAFWuzxltRpOEtZDAHGoh3Ts57ixpvTt7IYAjg12z74FlqNGvl8AQzbToXA7b3iW2IKtilH1vSDfbP8PnI/71gtkILkze2kJR
2025-08-06 11:00:10 [INFO]: item found in queue is if condition  14409
2025-08-06 11:00:10 [INFO]: item found in queue is  14409
2025-08-06 11:00:10 [INFO]: Message deleted from the queue for receipt handle: AQEBK0sshditlkeW1XKhc8JjUWpQNbZOcQrC4yNYYdIckZRev7qOhSfuvS2nuzPXhFf8KzrbQN84aQIM7762q+GcqXIOpksdSHMjFNboOGlbe6HxPNq84pFp/3Ijrajo+yIIaEcuRm32Pw/i0G8oP9Jy8pmB4q08AJAJP9u1nQlI2b5aUr/w1+8ncJsEVe11YjSDcirKFRxWbf5HsUs0zX/yMCRqIqWHpYk3OSX0/YCwaD3kATTC+Vub+0sVga2VvEyXsznM7+6vF15hr+T21OFakB1Vr2jWvEsSXAuHLjIQ1mDxEgHH379LzjFGrt7P4duOONskqWj2HvaS/ORkUXwsuVN/PoFtjNme5I2JVHxiDOjdAsti8TacEvxYiOspkVSdhBLtkyJ5tNgjzxhy3Nr7qdV/oatDo356rUIOUBc64bQBqoCFUSNXdPC2WETxh7GD
2025-08-06 11:00:10 [INFO]: Processed 7 messages, reached the limit of 7.
2025-08-06 11:00:10 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 11:00:10 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:12 [INFO]: Ebay item id :: 285656105250 exists in Database
2025-08-06 11:00:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:12 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:14 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:14 [INFO]: Ebay item id :: 225879711698 exists in Database
2025-08-06 11:00:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:14 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:15 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:15 [INFO]: Ebay item id :: 325893984376 exists in Database
2025-08-06 11:00:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:15 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:17 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:17 [INFO]: Ebay item id :: 256436739045 exists in Database
2025-08-06 11:00:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:17 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:19 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:19 [INFO]: Ebay item id :: 325419503085 exists in Database
2025-08-06 11:00:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:19 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:21 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:21 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:21 [INFO]: Ebay item id :: 325893849127 exists in Database
2025-08-06 11:00:21 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:21 [INFO]: inside itemsold and closed 14409
2025-08-06 11:00:23 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:00:23 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:00:23 [INFO]: Ebay item id :: 285839112161 exists in Database
2025-08-06 11:00:23 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:00:23 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:00:23 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:00:23 [INFO]: in processold action queue is array    for {"44647286":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44647286","ebayitemid":"285656105250","shopifyproductid":"8254646157534","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8254646157534","shopifyvariantid":"44675166240990","shopifyinventoryid":"46773124956382","shopifylocationid":"","product_id":"44647286","variant_id":"77552475","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662826":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662826","ebayitemid":"225879711698","shopifyproductid":"8211589398750","variants":[{"price":"181.99","quantity":0,"weight":"2","shopifyproductid":"8211589398750","shopifyvariantid":"44536562024670","shopifyinventoryid":"46634514415838","shopifylocationid":"","product_id":"44662826","variant_id":"77568046","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662771":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662771","ebayitemid":"325893984376","shopifyproductid":"8211590086878","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8211590086878","shopifyvariantid":"44536564089054","shopifyinventoryid":"46634516480222","shopifylocationid":"","product_id":"44662771","variant_id":"77567991","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772017":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772017","ebayitemid":"256436739045","shopifyproductid":"8306621186270","variants":[{"price":"55.99","quantity":0,"weight":"3","shopifyproductid":"8306621186270","shopifyvariantid":"44861609935070","shopifyinventoryid":"46959659843806","shopifylocationid":"","product_id":"44772017","variant_id":"77680559","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44732478":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44732478","ebayitemid":"325419503085","shopifyproductid":"7869466411230","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"7869466411230","shopifyvariantid":"43641136840926","shopifyinventoryid":"45736898560222","shopifylocationid":"","product_id":"44732478","variant_id":"77640363","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662480":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662480","ebayitemid":"325893849127","shopifyproductid":"8211476840670","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8211476840670","shopifyvariantid":"44536214880478","shopifyinventoryid":"46634167271646","shopifylocationid":"","product_id":"44662480","variant_id":"77567700","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772863":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772863","ebayitemid":"285839112161","shopifyproductid":"8461623001310","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8461623001310","shopifyvariantid":"45305959055582","shopifyinventoryid":"47403883790558","shopifylocationid":"","product_id":"44772863","variant_id":"77681405","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 11:00:23 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:00:23 [INFO]: Shopify Inventory id 46773124956382
2025-08-06 11:00:23 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:23 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:23Z","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 11:00:23 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:23 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44647286 and user_id = 14409 
2025-08-06 11:00:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77552475 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:23 [INFO]: Shopify Inventory id 46634514415838
2025-08-06 11:00:23 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:23 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:23Z","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 11:00:24 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:24 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:24 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:24 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662826 and user_id = 14409 
2025-08-06 11:00:24 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77568046 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:24 [INFO]: Shopify Inventory id 46634516480222
2025-08-06 11:00:24 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:24Z","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 11:00:24 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:24 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:24 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:24 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662771 and user_id = 14409 
2025-08-06 11:00:24 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567991 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:24 [INFO]: Shopify Inventory id 46959659843806
2025-08-06 11:00:24 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:24Z","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 11:00:24 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:24 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:24 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:24 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772017 and user_id = 14409 
2025-08-06 11:00:24 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680559 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:24 [INFO]: Shopify Inventory id 45736898560222
2025-08-06 11:00:24 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:24Z","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 11:00:24 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:24 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:24 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:24 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44732478 and user_id = 14409 
2025-08-06 11:00:24 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77640363 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:24 [INFO]: Shopify Inventory id 46634167271646
2025-08-06 11:00:24 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:24 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:25 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:25Z","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 11:00:25 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:25 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662480 and user_id = 14409 
2025-08-06 11:00:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567700 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:25 [INFO]: Shopify Inventory id 47403883790558
2025-08-06 11:00:25 [INFO]: Shopify Location id 58450641063
2025-08-06 11:00:25 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:00:25 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:00:25Z","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 11:00:25 [INFO]: Change: available | Delta: -1
2025-08-06 11:00:25 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:00:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:00:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772863 and user_id = 14409 
2025-08-06 11:00:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681405 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:00:25 [INFO]: updateIdsQuantity -> ["77552475","77568046","77567991","77680559","77640363","77567700","77681405"]
2025-08-06 11:00:25 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 7. Affected rows: 7
2025-08-06 11:00:25 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77552475 THEN 0 WHEN id = 77568046 THEN 0 WHEN id = 77567991 THEN 0 WHEN id = 77680559 THEN 0 WHEN id = 77640363 THEN 0 WHEN id = 77567700 THEN 0 WHEN id = 77681405 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77552475 THEN 0 WHEN id = 77568046 THEN 0 WHEN id = 77567991 THEN 0 WHEN id = 77680559 THEN 0 WHEN id = 77640363 THEN 0 WHEN id = 77567700 THEN 0 WHEN id = 77681405 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77552475,77568046,77567991,77680559,77640363,77567700,77681405)
2025-08-06 11:00:25 [INFO]: QUANTITY Updated IDs: 77552475, 77568046, 77567991, 77680559, 77640363, 77567700, 77681405
2025-08-06 11:00:25 [INFO]: Successfully processed data for user 14409
2025-08-06 11:00:25 [INFO]: Execution Started
2025-08-06 11:00:25 [INFO]: Execution Finished
2025-08-06 11:10:01 [INFO]: Execution Started
2025-08-06 11:10:01 [INFO]: old server sucessfully connected
2025-08-06 11:10:01 [INFO]: sqs client sucess created
2025-08-06 11:10:02 [INFO]: Number of messages in the queue: 4
2025-08-06 11:10:02 [INFO]: item found in queue is if condition  14409
2025-08-06 11:10:02 [INFO]: item found in queue is  14409
2025-08-06 11:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBUMJ+DEtGa7Z3yWe8mKXXg+bj7vsuNTLJbeLG3NrXH7U4i0H+fV6/kBodZj2Bzmho9CoatdQdF28zBsRD4Daajb/tABBTfRB5YiGx+95YmAFPqzVkyJfEvPBDnBu4jnNHVJDGSUkCCgU12oRmdUB+XuwKkJoas/4RaVn7cNhFjj8otkmXuBNbLtric6B4tDLI1aZGxbOotEFPAN4GWwhK7ytk+RgZB4M35qyMW85Xx4Atm7ysZa24XaaJ3RhsjjqJfFkAWQSXmotSN1WPsUCCtaveXsMkAIE35vxvFkXqX0CLSy+eWR4REQXBF27WMpC/y023ZOpKXv35G0wp7tQuF92BOp0ZWkHpShmVePxqobYh5Yw8TsP2iItpLEx6lzjFDItFpH5jQ3gExNRjZWW7uFVVdSccRRh/i8TwR1+5Knta0zQ/0os7sEOwh0oyeyZs
2025-08-06 11:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 11:10:03 [INFO]: item found in queue is  14409
2025-08-06 11:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBOv328klhllCHIjw7rGE6mNoizmZj8QxmASueixHLVO84fM8ffW4l1gsq/E5UufVF/g02YQlFOatduu43XYoMPi5OwHWRDtmNFWJRCNQHxV9UVC0m8T1XPNNThIm3Emg22WVIXmxnfJFvwB3wJiYFfOi2foZssB0O65V8pZGdK3xkKkt315w+XFZvWhMEM8/qHz3R2MKuG8HlJX51owtlTQ6Gu/BkW9L6cjlHdPg/eHnJ39+WRzgjFX0aHzfurckgCUH7DmUJpNOAgWoePrCOr2NCfuEk8FposbrXT3h5adIgIz1L5ML8mZpnGdV5ehNa477gtt5mgpOSoBHt4ziPEhariGVTuct4lda34dygRKeJbwNN1MEvuRdtizdUqkoVXL825eCBUYs2RUh+fjHwDOalroaTjrTucUSBsnWYppQADo6LwHrur00cEV+8vcEe
2025-08-06 11:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 11:10:03 [INFO]: item found in queue is  14409
2025-08-06 11:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBpZG8dfIZaRvggYE/ppeHK6q/vONSTQ6zFEIuxn8Uk/fgVUzllDCKfxnKDT6jpkKfNodKHrpRRuGglnjw4VRhZ+ZOYHpKydP/TMwGDIZH21r8C84fjB3LvgBE2Ewce8BWnI64a0mCwH2kcJjqeQiPkRu6jNhTPf0gx1oDa21v38asgopc7n5sZAib3k4FMOmg0drhKS7KI3gbbf+teJpX/U5UWaOix9Bel0Vy9+xg32j/pvI5CeBEvbLL3bEyQ5DdWHylZtRLCJraWyTVPhUpbQSXjefeYquqOxp0dx+IfGyY+B17cAzYdgnUlH6RZYwnJwCEeKGJj6yPYKqd/474gXNLmypxBFIgGQL+2Y0NBZEzkhiRhQ+lvTqj2vvEdfbMKQWzZntNrJXF5Z4wcZHHzd0OGjP9V5ZNcXX5Qd9OP2kQTgFr6BkzAtxTotLE8XVk
2025-08-06 11:10:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:10:04 [INFO]: item found in queue is  14409
2025-08-06 11:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBxF28M3KMON1hAGWcedFBnh3IdYu9licWCH8xA4P3wkBk0FX6rfK2C8ASMni0NvpTrLHBS+Yw7PrFKRagoOzG9MLRiqIW2ybWV1Y2w0nQ3/U5uCVBB3WCugeA1ZkkiOh/Q+hDLGt5AIXU9M/CkXZ3EKOMP1/b/R+6udKvVRcdIYfX4AAXVOWAUG6heIsTecOOUQUUEXMMA9zQrJp1uVdKbFNPZFROTc8nc3QggXy0V3CwBzYrnEmDxoAWeKVG+BZV8+kq5vs6Nx+cbgND8NKtMsbqkfEp35NYQzBqZ+Q6MWJDsTeUpSzUCYRFHkKU9z6WK6eWG3rKAexrxtRgOrO3o5RyMv2chmNAdBM7Edm4h/IfRbuEUI2z2WhtLIoCbpUVC1famY+lOSPaOoFd9fxB5T2KJT3O7DmHu2HBz+KWus0FwuSY22C80GwkQW5w8Ob0
2025-08-06 11:10:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-06 11:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 11:10:04 [INFO]: inside itemsold and closed 14409
2025-08-06 11:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:10:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:10:06 [INFO]: Ebay item id :: 404877099099 exists in Database
2025-08-06 11:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:10:06 [INFO]: inside itemsold and closed 14409
2025-08-06 11:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:10:07 [INFO]: Ebay item id :: 285784056262 exists in Database
2025-08-06 11:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:10:07 [INFO]: inside itemsold and closed 14409
2025-08-06 11:10:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:10:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:10:09 [INFO]: Ebay item id :: 256458005118 exists in Database
2025-08-06 11:10:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:10:09 [INFO]: inside itemsold and closed 14409
2025-08-06 11:10:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:10:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:10:11 [INFO]: Ebay item id :: 225884516313 exists in Database
2025-08-06 11:10:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:10:11 [INFO]: in processold action queue is array    for {"44668388":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44668388","ebayitemid":"404877099099","shopifyproductid":"8338776752350","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8338776752350","shopifyvariantid":"44980058161374","shopifyinventoryid":"47077843894494","shopifylocationid":"","product_id":"44668388","variant_id":"77573608","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681219":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681219","ebayitemid":"285784056262","shopifyproductid":"8340559429854","variants":[{"price":"111.99","quantity":0,"weight":"2","shopifyproductid":"8340559429854","shopifyvariantid":"44984716099806","shopifyinventoryid":"47082503143646","shopifylocationid":"","product_id":"44681219","variant_id":"77586444","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44679177":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44679177","ebayitemid":"256458005118","shopifyproductid":"8228326539486","variants":[{"price":"46.99","quantity":0,"weight":"2","shopifyproductid":"8228326539486","shopifyvariantid":"44586001858782","shopifyinventoryid":"46683967324382","shopifylocationid":"","product_id":"44679177","variant_id":"77584397","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44671096":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44671096","ebayitemid":"225884516313","shopifyproductid":"7926915006686","variants":[{"price":"109.99","quantity":0,"weight":"2","shopifyproductid":"7926915006686","shopifyvariantid":"43882307944670","shopifyinventoryid":"45978452787422","shopifylocationid":"","product_id":"44671096","variant_id":"77576316","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 11:10:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 11:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:10:11 [INFO]: Shopify Inventory id 47077843894494
2025-08-06 11:10:11 [INFO]: Shopify Location id 58450641063
2025-08-06 11:10:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:10: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 11:10:11 [INFO]: Change: available | Delta: -1
2025-08-06 11:10:11 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44668388 and user_id = 14409 
2025-08-06 11:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77573608 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:10:11 [INFO]: Shopify Inventory id 47082503143646
2025-08-06 11:10:11 [INFO]: Shopify Location id 58450641063
2025-08-06 11:10:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:10: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 11:10:11 [INFO]: Change: available | Delta: -1
2025-08-06 11:10:11 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681219 and user_id = 14409 
2025-08-06 11:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586444 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:10:11 [INFO]: Shopify Inventory id 46683967324382
2025-08-06 11:10:11 [INFO]: Shopify Location id 58450641063
2025-08-06 11:10:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:10: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-06 11:10:12 [INFO]: Change: available | Delta: -1
2025-08-06 11:10:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44679177 and user_id = 14409 
2025-08-06 11:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77584397 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:10:12 [INFO]: Shopify Inventory id 45978452787422
2025-08-06 11:10:12 [INFO]: Shopify Location id 58450641063
2025-08-06 11:10:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:10: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-06 11:10:12 [INFO]: Change: available | Delta: -1
2025-08-06 11:10:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44671096 and user_id = 14409 
2025-08-06 11:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576316 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:10:12 [INFO]: updateIdsQuantity -> ["77573608","77586444","77584397","77576316"]
2025-08-06 11:10:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-06 11:10:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77573608 THEN 0 WHEN id = 77586444 THEN 0 WHEN id = 77584397 THEN 0 WHEN id = 77576316 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77573608 THEN 0 WHEN id = 77586444 THEN 0 WHEN id = 77584397 THEN 0 WHEN id = 77576316 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77573608,77586444,77584397,77576316)
2025-08-06 11:10:12 [INFO]: QUANTITY Updated IDs: 77573608, 77586444, 77584397, 77576316
2025-08-06 11:10:12 [INFO]: Successfully processed data for user 14409
2025-08-06 11:10:12 [INFO]: Execution Started
2025-08-06 11:10:12 [INFO]: Execution Finished
2025-08-06 11:20:02 [INFO]: Execution Started
2025-08-06 11:20:02 [INFO]: old server sucessfully connected
2025-08-06 11:20:02 [INFO]: sqs client sucess created
2025-08-06 11:20:03 [INFO]: Number of messages in the queue: 4
2025-08-06 11:20:03 [INFO]: item found in queue is if condition  14409
2025-08-06 11:20:03 [INFO]: item found in queue is  14409
2025-08-06 11:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBo/k7c4bh7e4MZ3mvy60T+Oe98pfJ94GncutExG6bJhAb64BwW2RGJUXLafZ0T7swn8vIcAes/HmmX9mYt/iL8MVZiG9vOoqwxFlOQFwZHwukTIFRRJocE4KlDYd1xfYtm6neBvo3SOtxar52Vl8dU0ZSChUhXItDjjV7R+EJDWtM8k2NfUKDVhVZ2AlbVJTYxv2aNUTF8vfE+4GXedN2deob8ly79CjU1HaIQoJUj5OQ3IojKkT8Ypvzu5KSXMKvA/WxaShlmE5iHn/qSIlg2llXQDxMu8EDgVLK+MRR1gnIEbn0yBqfMNAhZpPLE3tmfu+UJG4e1Bx5G+b2rzRsqFtjyoA3K3vJS59rgSixMf+4mL9ZUuty1ZSBxxks8BeIDXSvLdE1gGbp8y0Rk8FNiubnaWHNsaLN8PpZwTpjS5roy7PbA6srM0I5uabcQl94
2025-08-06 11:20:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:20:04 [INFO]: item found in queue is  14409
2025-08-06 11:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB+VkFPzoYd5ik+NLDn+y50vyFbjep/NQyDV5Y+0ErrGImqPaRhcBP1VIuYboWG+DlRkwLnhFfkKA9ou8cGz5imwvHST6lVZtENpFVglO1fu3KZX8FjKnepEz5NZ3YnHC8K2qSYaANsQsLPL0Oj2MEu/sJkHTjI89ZQpGDIbfOQbplJt4hjX/7+N9nNvyVtHhw+eMBW8dPH9/e6OpZFoKcEgELsxWvRGihKNUce8ufO0N8WKNad6t0OG8k/D9mWKaQ8FNJe3TVydPrz1p7DYyuUdUCP1M9jIMA0dfiBsRaiLiURxhWwpqwTgbV93rP9kGcrP1IpmEDRIFAqtSJT2l7rpoJQmpT4xyN51ew1WtACbczQD6/b5R0/T3U+QHPPyAS/vgtakYM+qOhwqhL/ZOQ4xtLwp/iec0fU0DbHnvrGvpj+mlwX/WcKyhfXlH6HOAo
2025-08-06 11:20:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:20:04 [INFO]: item found in queue is  14409
2025-08-06 11:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBrMoBA83JaRd6m4RZiLIrL2jj3cwhp8OMheagKAhT2GDmWWUKg65cmd6W3CUqfX8HbfrEKjh/p0YwGaMQ2FUycZxC9fxzXh6mZs+Jfc/2qiD1zZciBNhHpWCb17rpGl6aLXePhxy+a1I+S37KNUMU5HsCVsCQPPyDPNKLJSkP3zCG7FCsrVju3QWn9LNZzhE5p+Mn8KkZ7UDRHHzmCogN3p3ZGb1AOa4sARf5eyWKv5APP5laWxQeIpyrNrVqpaNNx8tgChArUTb3/cJSD+aD+PkgqhXYcHZ92ofb5LHCgVW0mYvhAHL9KjuUg1HaGX1w87d2T0G5yyA9jvQkEx1X3lySn1LB4cVnJQ3l51i9dyiplSHI7A/HceTy+PD/Kgeihurg+xtrmM0MpaqWxAcAvaqUlcfLcM1lXX2QeLsz/CRCioPLxrgzhlltLvdawx/+
2025-08-06 11:20:05 [INFO]: item found in queue is if condition  14409
2025-08-06 11:20:05 [INFO]: item found in queue is  14409
2025-08-06 11:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBAegBt65imBHCHHNgjoBCso9g7T+mWEYQqIRab4AOIgc1U8Q6+pnj3xWddDVCOUs2nHUfH/aFPtV77vnBPTV/XxaYGPu7eLoVEU9vBX9wM9xgjfjRNXxmqEy0Gg/IxckOUEWqA44AQ4SfwIctBxEvFkZxtEkiXlCZWJjBLsjkKJZaQZG6q9ww+r3A87WNZPmkzTS2uRaI+rDxYr8YhGNpmknW8IY64TmE8cr3TJCdfBc87zN+HO6OFaNy2hJO98T1cL9JPbaJWYnrR4PL8zBw+QLvKGFbcH9szTgZbk8wyxbkcueqxjYMHGfKBlf0qOspQkj/vJWKIHa6/8NrX8gbK8okE62x11WBHKPofnqSZdafoLPC2ggUuhmI3595vpDQ1/rKCDbCPKandWmcNn6h+19t+VRplgMVZTBtt6twwdV7viAyBSnjhcOo8n7vXEsH
2025-08-06 11:20:05 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-06 11:20:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 11:20:05 [INFO]: inside itemsold and closed 14409
2025-08-06 11:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:20:07 [INFO]: Ebay item id :: 225884503199 exists in Database
2025-08-06 11:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:20:07 [INFO]: inside itemsold and closed 14409
2025-08-06 11:20:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:20:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:20:08 [INFO]: Ebay item id :: 325056841510 exists in Database
2025-08-06 11:20:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:20:08 [INFO]: inside itemsold and closed 14409
2025-08-06 11:20:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:20:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:20:10 [INFO]: Ebay item id :: 225884510599 exists in Database
2025-08-06 11:20:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:20:10 [INFO]: inside itemsold and closed 14409
2025-08-06 11:20:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:20:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:20:12 [INFO]: Ebay item id :: 224582862843 exists in Database
2025-08-06 11:20:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:20:12 [INFO]: in processold action queue is array    for {"44671087":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44671087","ebayitemid":"225884503199","shopifyproductid":"7926765060318","variants":[{"price":"25.99","quantity":0,"weight":"0.5","shopifyproductid":"7926765060318","shopifyvariantid":"43881777594590","shopifyinventoryid":"45977921028318","shopifylocationid":"","product_id":"44671087","variant_id":"77576307","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44655667":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44655667","ebayitemid":"325056841510","shopifyproductid":"7563408113886","variants":[{"price":"18.99","quantity":0,"weight":"2","shopifyproductid":"7563408113886","shopifyvariantid":"42489877561566","shopifyinventoryid":"44583806304478","shopifylocationid":"","product_id":"44655667","variant_id":"77560856","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44671094":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44671094","ebayitemid":"225884510599","shopifyproductid":"7926915039454","variants":[{"price":"27.99","quantity":0,"weight":"0.9375","shopifyproductid":"7926915039454","shopifyvariantid":"43882307977438","shopifyinventoryid":"45978452820190","shopifylocationid":"","product_id":"44671094","variant_id":"77576314","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44670162":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670162","ebayitemid":"224582862843","shopifyproductid":"6985491054759","variants":[{"price":"18.99","quantity":0,"weight":"2","shopifyproductid":"6985491054759","shopifyvariantid":"41035958714535","shopifyinventoryid":"43131992866983","shopifylocationid":"","product_id":"44670162","variant_id":"77575382","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 11:20:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 11:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:20:12 [INFO]: Shopify Inventory id 45977921028318
2025-08-06 11:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 11:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:20: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-06 11:20:12 [INFO]: Change: available | Delta: -1
2025-08-06 11:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44671087 and user_id = 14409 
2025-08-06 11:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576307 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:20:12 [INFO]: Shopify Inventory id 44583806304478
2025-08-06 11:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 11:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:20: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-06 11:20:12 [INFO]: Change: available | Delta: -1
2025-08-06 11:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44655667 and user_id = 14409 
2025-08-06 11:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77560856 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:20:12 [INFO]: Shopify Inventory id 45978452820190
2025-08-06 11:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 11:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:20:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:20:13Z","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 11:20:13 [INFO]: Change: available | Delta: -1
2025-08-06 11:20:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:20:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:20:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44671094 and user_id = 14409 
2025-08-06 11:20:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576314 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:20:13 [INFO]: Shopify Inventory id 43131992866983
2025-08-06 11:20:13 [INFO]: Shopify Location id 58450641063
2025-08-06 11:20:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:20:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:20:13Z","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 11:20:13 [INFO]: Change: available | Delta: -1
2025-08-06 11:20:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:20:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:20:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670162 and user_id = 14409 
2025-08-06 11:20:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575382 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:20:13 [INFO]: updateIdsQuantity -> ["77576307","77560856","77576314","77575382"]
2025-08-06 11:20:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-06 11:20:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77576307 THEN 0 WHEN id = 77560856 THEN 0 WHEN id = 77576314 THEN 0 WHEN id = 77575382 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77576307 THEN 0 WHEN id = 77560856 THEN 0 WHEN id = 77576314 THEN 0 WHEN id = 77575382 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77576307,77560856,77576314,77575382)
2025-08-06 11:20:13 [INFO]: QUANTITY Updated IDs: 77576307, 77560856, 77576314, 77575382
2025-08-06 11:20:13 [INFO]: Successfully processed data for user 14409
2025-08-06 11:20:13 [INFO]: Execution Started
2025-08-06 11:20:13 [INFO]: Execution Finished
2025-08-06 11:30:01 [INFO]: Execution Started
2025-08-06 11:30:01 [INFO]: old server sucessfully connected
2025-08-06 11:30:01 [INFO]: sqs client sucess created
2025-08-06 11:30:03 [INFO]: Number of messages in the queue: 4
2025-08-06 11:30:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:30:04 [INFO]: item found in queue is  14409
2025-08-06 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB10zpM+DOM23ji/dIwmg3GnlgdwN8TOTwPuorW6z2A4bVf5cXrr3k0ChiyzWYwzogizy8nmPC6kW++UQ0W2YhFOwEcoojk41qqft8Vp66771pryJUKOh1r6+b3L5hEDqdeq8ZZc6pKjZlusoxtUOkMb6bRQMfQNwHVVqV63rw4wBb2q76+VBtbcG+iqa2iQYjmU85ayzlyVE+o8H8ZNDVOQGNWBq02ud3aSzRF78KGCDVkFZ5HMYNOe5Gkvcv/gnpxCoV9P9p1EifTyKeOvOzD+6pE4Vg3jInZwqXhTTQrYhuTLCV+YU8gqlISOoug7wm2j2UwQhDlWjQdtWN73d/cshdcqQRS0d5lClDNx3V6eSjD5nbbgjeD2SI68B8NfkS4VjBHBXvwYulBGNtkKoI9526JuXZcQpa5zMlSWLLThGIM4Jzn4g8AaD2pYK+3bL2
2025-08-06 11:30:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:30:04 [INFO]: item found in queue is  14409
2025-08-06 11:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBxhD1KWKwrnL8QjG+pSoufaZMgovxvfkddEGDP5DLNdFVJo4fci75tGzLJCsezNhkkkLDTe7wUSaQ57Mhwqy5ya6agAcbFHf2GW0X2iHZJhSt/E2Dz85gGNQy3uQmHvLOIuyaURZa2Hl6SH79mvk3qSzeNIIdX/2Gf8Q955B2/87DkXwfGs56ec8GRF9k5VihZPqDoP3c714t5xp49QjhUyeadCPsakw1ZkQN9yqUVN1elbMwwdPhUdu2MjzR/gf0QtnKrcwby9R8iZ79aGFaUS71gFHXBeoRCL1kCdH9BvnxQgKmflS1iGyYVC1jEpLKPgV+uhylA3fNtsj//Nuc+Bn51Nox7MelpA84SPMV70kr/3GVKzWaCBpMYewY0cOlaIQYrNg6mDzMgusJS5MCY6vkN5dtcb0lHZDHEpIEPtEqL7HgdMcaYxFLSsGGzfW/
2025-08-06 11:30:05 [INFO]: item found in queue is if condition  14409
2025-08-06 11:30:05 [INFO]: item found in queue is  14409
2025-08-06 11:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBnFwdzB/vVp3XdpDK2y+knljDOXZRzIht5YY0h/JrLFvS1FE4JRKU7b7fiApDUYgwubzGmq7Dn5XfZQpXjI+mQjJBukfJ/ZoitMnTQR6iOPPr4LnY5OEQ6Eeio5OBMTuFcYOgVILVO7zKItE2MdQqNkVNR4mAT2NbBQr0Nmd18QtESCmkcGABjsxrkzX2lKqy747IunZCev5D6izkkxDDcDtzYyo5FM4QniWId3mXhjdyZ09XGiTTZhwZ1DXRhgWMD2tBOaAoqFutRKkd4Wd+ACUV9qkI4rBhOGYQRGjqqWH84lfchpj5o6WPDnpvWJS8apYmx4f/4cMIzNLAk6THNAFDaOUvZ/+wyISgDWQcdkqfov4bQpyV0/W85KfBLjQ21jOaCKWlqTt5D804Ji9rrzKPE152oUu3Qq+ZKI9ozNRel4/g9IIs2LPRduDxN4He
2025-08-06 11:30:06 [INFO]: item found in queue is if condition  14409
2025-08-06 11:30:06 [INFO]: item found in queue is  14409
2025-08-06 11:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBQBY0y52jyC8tSR8G6GLPT3hIp5Ga0RqIWsQyNdx/jbF2evU+69ZWov9V0efMYrpppqayBJis33lomHbuuLPly2YJrAm50fNENTy4UrCkAfKZk3YoKEiRdZQUYrF1dITji8RhhbR2gYAOxCoouQirXamuLmgsbndGPeJzOsGHIjQsaRqlIKOPs1zzQDUKmuN6NDEJpvLFzIOPZ4ivXTgI5nDr2C/nAfuPmix0YUYcQOYOUwU4s2O/pPRfaQGd5sxsKujP2Eo8fzztiEF5P6alGriEWL4LhCAd3VBk4HcwS7V/qKwIurGScdpOyFaGvufzBxSHeI1Wt3YMHexjLhypKKd+B8diDKtuCjmyvZZdgAEF1DjCb3rbu+l3GdpwYL+/5WqvjbyCgPPIjIPpssJXSElXzBnCZJPRFjperFwTZsAfyagri6kbLzlgTN4BdkKP
2025-08-06 11:30:06 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-06 11:30:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 11:30:06 [INFO]: inside itemsold and closed 14409
2025-08-06 11:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:30:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:30:09 [INFO]: Ebay item id :: 225885683938 exists in Database
2025-08-06 11:30:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:30:09 [INFO]: inside itemsold and closed 14409
2025-08-06 11:30:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:30:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:30:11 [INFO]: Ebay item id :: 325899301899 exists in Database
2025-08-06 11:30:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:30:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:30:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:30:11 [INFO]: inside itemsold and closed 14409
2025-08-06 11:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:30:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:30:12 [INFO]: Ebay item id :: 326030581737 exists in Database
2025-08-06 11:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:30:12 [INFO]: inside itemsold and closed 14409
2025-08-06 11:30:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:30:14 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:30:14 [INFO]: Ebay item id :: 226021720948 exists in Database
2025-08-06 11:30:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:30:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:30:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:30:14 [INFO]: in processold action queue is array    for {"44672948":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44672948","ebayitemid":"225885683938","shopifyproductid":"7026783617191","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"7026783617191","shopifyvariantid":"41222783140007","shopifyinventoryid":"43318854189223","shopifylocationid":"","product_id":"44672948","variant_id":"77578168","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673151":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673151","ebayitemid":"325899301899","shopifyproductid":"7050547167399","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"7050547167399","shopifyvariantid":"41347588194471","shopifyinventoryid":"43443599343783","shopifylocationid":"","product_id":"44673151","variant_id":"77578371","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681656":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681656","ebayitemid":"326030581737","shopifyproductid":"8303317254366","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8303317254366","shopifyvariantid":"44851862601950","shopifyinventoryid":"46949906972894","shopifylocationid":"","product_id":"44681656","variant_id":"77586881","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681660":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681660","ebayitemid":"226021720948","shopifyproductid":"6985537749159","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"6985537749159","shopifyvariantid":"41036168102055","shopifyinventoryid":"43132202254503","shopifylocationid":"","product_id":"44681660","variant_id":"77586885","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 11:30:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:30:14 [INFO]: Shopify Inventory id 43318854189223
2025-08-06 11:30:14 [INFO]: Shopify Location id 58450641063
2025-08-06 11:30:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:30:15Z","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 11:30:15 [INFO]: Change: available | Delta: -1
2025-08-06 11:30:15 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44672948 and user_id = 14409 
2025-08-06 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578168 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:30:15 [INFO]: Shopify Inventory id 43443599343783
2025-08-06 11:30:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:30:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:30:15Z","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 11:30:15 [INFO]: Change: available | Delta: -1
2025-08-06 11:30:15 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673151 and user_id = 14409 
2025-08-06 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578371 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:30:15 [INFO]: Shopify Inventory id 46949906972894
2025-08-06 11:30:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:30:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:30:15Z","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 11:30:15 [INFO]: Change: available | Delta: -1
2025-08-06 11:30:15 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681656 and user_id = 14409 
2025-08-06 11:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586881 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:30:15 [INFO]: Shopify Inventory id 43132202254503
2025-08-06 11:30:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:30:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:30:15Z","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 11:30:16 [INFO]: Change: available | Delta: -1
2025-08-06 11:30:16 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681660 and user_id = 14409 
2025-08-06 11:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586885 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:30:16 [INFO]: updateIdsQuantity -> ["77578168","77578371","77586881","77586885"]
2025-08-06 11:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-06 11:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77578168 THEN 0 WHEN id = 77578371 THEN 0 WHEN id = 77586881 THEN 0 WHEN id = 77586885 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77578168 THEN 0 WHEN id = 77578371 THEN 0 WHEN id = 77586881 THEN 0 WHEN id = 77586885 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77578168,77578371,77586881,77586885)
2025-08-06 11:30:16 [INFO]: QUANTITY Updated IDs: 77578168, 77578371, 77586881, 77586885
2025-08-06 11:30:16 [INFO]: Successfully processed data for user 14409
2025-08-06 11:30:16 [INFO]: Execution Started
2025-08-06 11:30:16 [INFO]: Execution Finished
2025-08-06 11:40:01 [INFO]: Execution Started
2025-08-06 11:40:01 [INFO]: old server sucessfully connected
2025-08-06 11:40:02 [INFO]: sqs client sucess created
2025-08-06 11:40:03 [INFO]: Number of messages in the queue: 5
2025-08-06 11:40:03 [INFO]: item found in queue is if condition  14409
2025-08-06 11:40:03 [INFO]: item found in queue is  14409
2025-08-06 11:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxMfYVtlEk7jknyLbnFRILPfge8/kjTslmz0m9MbLq4neabK29Wc44coFkBgt5qFT6a+7DlwDdtAtzjbHE0s++9qiNpGbfNQZC2O+kKq5P9qohJ1C0OjuQWA9nAOAFjyZOIV1D+xxDV//gr9O6zeRwf+5cR1T6KGwagbhEMY7mYS91UyXoibSD9dHirqzYbroX08c95WTVDLS/WOF/faQhoYRUVT78bB0MKM4QRI39asDbAF58h+JmFYIW9vLvILV/4g+Uaomgn3n1EwygcREMA6OKe5BUea84T3v+eEq4bQR6YN54DFCOu1Q1aXj1JcZvsl/KNrUS7tDV1h5DUP9SBu4ER5kurRnw4LKbtVbl9hOS86mQfWW/3WX0XCv1ObAchlukr+VojIcSU+AzVoSWrN1Wuxv72MxDo1VbHP7gk7pZ2spHLIVLUK20+IzDxwH
2025-08-06 11:40:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:40:04 [INFO]: item found in queue is  14409
2025-08-06 11:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBw5u3LSg5Yg4bM4V17xfvCZxQjoHg+6Y/MJ9/n8brfikSzPIqmSJptzAaqOoG/dk+HwiiXUzOuprFUH/ru27EV5fSaZ3jTPtntqJfYj0GyVzrLDHEJ3m1QRbKDtugrF30acsI6Dl9LEA/Ou/an7nYLKKxAYwOS5VSQi4KbHTB0vOmxBQHO0RnDBhdDwvdz9wZ4E2EmnNBvcKGo/FP7LDuaPEas6bowsFAzSxSUkhdAgpcplExOTkm57kHBpe6mA9D1mNxGAryxy7iyoHMkncFv9lXV7zf7YvQjeYYbpA0KsvSU5nsV+N+/RJVWl1Khe/x0dggsp2l6DKnnxF0HNdRC51FwI7n1bb8zeTjAEXzBQFvP0M2DPYC3Bxqm2w/DTiJ+Ep6d3k2d0I+hI0ClY09LGAupZr+34RZ0qtWDdFF6pySlZ7GjDTfdfA2gyrU0R9h
2025-08-06 11:40:04 [INFO]: item found in queue is if condition  14409
2025-08-06 11:40:04 [INFO]: item found in queue is  14409
2025-08-06 11:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBuoa7i6GXv5bw49B5lA8y3PajvqPCay5Qsd6eVHRcf2ux1eowrp34mWnkL0gATdNbNHdwKUMhTEFwZeRVIetI6zyoSJ/pn6yyoj5mflQanIdT6dSfoiDq2w/MeXvtes56chQTLg43DJbZ8WCCtse0LPDFP47YKrpjl2+rYgeVq2j7ih3P6H6DWMPiwhee9oaQGu5ufB/HarY80goI/r6YQS1Iizz3D77F78KznQdZ166kAJnThsxb9A5SEwC1Zz2r2kFoLPrIx//4h6dB6x7Ev4KQ4eXScqhAfRhwYv+5Se2AteAX341GV95I2thSU/P39mEl6/7EJNLe7R212XqE1mukQPcUgzB+paj3u5zRTNW5Ic/t7KpE3pTxmMr1i2t6BXNPH8fGYLgDEmWUljWxzo+thBvFT32CKKxzI/Oy4r/mNcUlFnI+UeSaFq4VFoaM
2025-08-06 11:40:05 [INFO]: item found in queue is if condition  14409
2025-08-06 11:40:05 [INFO]: item found in queue is  14409
2025-08-06 11:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB5dZ7wEKZYuM1eIP/1nAcaZxH7u6M2yRkciupf/tMmq74CXl4IbeuZcWmhmokXoul+L2HymBZpDMjrWfq2Xb8XySUV65j3JKpiOjTUJe9IHi5+jww5kjII42KcXtXByYGI38CVtb9DTj5ALAgoVqMnU97dqyckB+cca357dyL4stc/bABR3ldcNgQ0tBxDVEBvfL9tfjAH6T8YPb5vBxRdX+1O5891WAcwX79dX38iS8766wnFWwNqOgLqFkJtfAFYfENEnTAKr6rA42wikBfX9QWff1aWeh8SeF+Afhh+lKQmPAWUtBuR1IOLrd5ObRIisxEykWzo/WtdAMLQSEQsA60FJ4b0lumnGKmzKPogiSyu3uGytzhh3qmPdSExT8SaE/gjg1BHcCY7JEhJq31OJr5+uAoPZmo5FHVUpOA7yr1zNNEObZ+Zc4DP2EUyYMS
2025-08-06 11:40:05 [INFO]: item found in queue is if condition  14409
2025-08-06 11:40:05 [INFO]: item found in queue is  14409
2025-08-06 11:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB5aDWHR+GgG1XYDJA5nmvKw/JhlkHzs4shrJnCx1Yt17sOa7LMBem/1HpOSlMsdUnjmK+BezCXG+64AJulk0b652jI4vtyzUHEMHiUXLMtKElJWt9/EU+w1iVGRMjxEF1HGvW7LfoNUEsXnVeoEUSDFmV+944pQL/H/srXpOcE5jEre01pjtd70JV2GZzz9/Rp8qnE+QNv/pZ6kuoJN8lS/eoblsOgk550Ol6b7sInH+/dwIaDS4atlP7ekCy+Ety086suyPfocs3QcbZ2c7znHuyzMY7PNbGdnJoWs4iuSykKejzaL9vcNMysLzmVRBM4966wNRiOvNdmhxtrb/oqKvOi9IDUvTOoCJPhxyzIZFRhX+aE2zTr9Cl4qC07GaK++EuC/p+SC9FjrTX3o+hAE5cKni3gK5mVxwXPvTrvRLZrWVM87wko2X5HwZs4CIQ
2025-08-06 11:40:05 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-06 11:40:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 11:40:05 [INFO]: inside itemsold and closed 14409
2025-08-06 11:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:40:07 [INFO]: Ebay item id :: 256473948364 exists in Database
2025-08-06 11:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:40:07 [INFO]: inside itemsold and closed 14409
2025-08-06 11:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:40:09 [INFO]: Ebay item id :: 226283449112 exists in Database
2025-08-06 11:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:40:09 [INFO]: inside itemsold and closed 14409
2025-08-06 11:40:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:40:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:40:11 [INFO]: Ebay item id :: 256469998402 exists in Database
2025-08-06 11:40:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:40:11 [INFO]: inside itemsold and closed 14409
2025-08-06 11:40:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:40:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:40:12 [INFO]: Ebay item id :: 326292868745 exists in Database
2025-08-06 11:40:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:40:12 [INFO]: inside itemsold and closed 14409
2025-08-06 11:40:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:40:14 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:40:14 [INFO]: Ebay item id :: 404950052440 exists in Database
2025-08-06 11:40:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:40:14 [INFO]: in processold action queue is array    for {"44772477":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772477","ebayitemid":"256473948364","shopifyproductid":"8917750776030","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8917750776030","shopifyvariantid":"46726699286750","shopifyinventoryid":"48825189171422","shopifylocationid":"58450641063","product_id":"44772477","variant_id":"77681019","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735367":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735367","ebayitemid":"226283449112","shopifyproductid":"8700463481054","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8700463481054","shopifyvariantid":"45946992328926","shopifyinventoryid":"48045549551838","shopifylocationid":"","product_id":"44735367","variant_id":"77643274","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772388":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772388","ebayitemid":"256469998402","shopifyproductid":"8369981915358","variants":[{"price":"69.99","quantity":0,"weight":"3","shopifyproductid":"8369981915358","shopifyvariantid":"45070830174430","shopifyinventoryid":"47168689701086","shopifylocationid":"","product_id":"44772388","variant_id":"77680930","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735664":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735664","ebayitemid":"326292868745","shopifyproductid":"7944196587742","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"7944196587742","shopifyvariantid":"43956262633694","shopifyinventoryid":"46052713267422","shopifylocationid":"","product_id":"44735664","variant_id":"77643571","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772768":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772768","ebayitemid":"404950052440","shopifyproductid":"8917751431390","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8917751431390","shopifyvariantid":"46726700269790","shopifyinventoryid":"48825190121694","shopifylocationid":"58450641063","product_id":"44772768","variant_id":"77681310","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 11:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 11:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:40:14 [INFO]: Shopify Inventory id 48825189171422
2025-08-06 11:40:14 [INFO]: Shopify Location id 58450641063
2025-08-06 11:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:40:14Z","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-06 11:40:14 [INFO]: Change: available | Delta: -2
2025-08-06 11:40:14 [INFO]: Change: on_hand | Delta: -2
2025-08-06 11:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772477 and user_id = 14409 
2025-08-06 11:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681019 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:40:14 [INFO]: Shopify Inventory id 48045549551838
2025-08-06 11:40:14 [INFO]: Shopify Location id 58450641063
2025-08-06 11:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:40:14Z","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-06 11:40:15 [INFO]: Change: available | Delta: -2
2025-08-06 11:40:15 [INFO]: Change: on_hand | Delta: -2
2025-08-06 11:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735367 and user_id = 14409 
2025-08-06 11:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643274 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:40:15 [INFO]: Shopify Inventory id 47168689701086
2025-08-06 11:40:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:40:15Z","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 11:40:15 [INFO]: Change: available | Delta: -1
2025-08-06 11:40:15 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772388 and user_id = 14409 
2025-08-06 11:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680930 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:40:15 [INFO]: Shopify Inventory id 46052713267422
2025-08-06 11:40:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:40:15Z","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-06 11:40:15 [INFO]: Change: available | Delta: -2
2025-08-06 11:40:15 [INFO]: Change: on_hand | Delta: -2
2025-08-06 11:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735664 and user_id = 14409 
2025-08-06 11:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643571 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:40:15 [INFO]: Shopify Inventory id 48825190121694
2025-08-06 11:40:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:40:15Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 11:40:15 [INFO]: Change: available | Delta: -3
2025-08-06 11:40:15 [INFO]: Change: on_hand | Delta: -3
2025-08-06 11:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772768 and user_id = 14409 
2025-08-06 11:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681310 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:40:15 [INFO]: updateIdsQuantity -> ["77681019","77643274","77680930","77643571","77681310"]
2025-08-06 11:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5
2025-08-06 11:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77681019 THEN 0 WHEN id = 77643274 THEN 0 WHEN id = 77680930 THEN 0 WHEN id = 77643571 THEN 0 WHEN id = 77681310 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77681019 THEN 0 WHEN id = 77643274 THEN 0 WHEN id = 77680930 THEN 0 WHEN id = 77643571 THEN 0 WHEN id = 77681310 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77681019,77643274,77680930,77643571,77681310)
2025-08-06 11:40:15 [INFO]: QUANTITY Updated IDs: 77681019, 77643274, 77680930, 77643571, 77681310
2025-08-06 11:40:15 [INFO]: Successfully processed data for user 14409
2025-08-06 11:40:15 [INFO]: Execution Started
2025-08-06 11:40:15 [INFO]: Execution Finished
2025-08-06 11:50:01 [INFO]: Execution Started
2025-08-06 11:50:01 [INFO]: old server sucessfully connected
2025-08-06 11:50:01 [INFO]: sqs client sucess created
2025-08-06 11:50:06 [INFO]: Number of messages in the queue: 3
2025-08-06 11:50:07 [INFO]: item found in queue is if condition  14409
2025-08-06 11:50:07 [INFO]: item found in queue is  14409
2025-08-06 11:50:08 [INFO]: Message deleted from the queue for receipt handle: AQEBk0faMD4aEU+pMIPqDYf0C0o4x6QNwJ7+dSiUcXWTY3a5oy+4e//UMHxia4o4SdYmaLG/cERaANYRSPK3iB/gKpVKwb8Ubnc0IOl8fgpKKBokdxlbNjbM3Yh8whrHn5LkxdTHB/RbmSchdpWs9f2m/ol1kHtt9ISjJRKWsBNwi0pG2EbkwH32luHm84FEmOPFNeFMBl8Wt7npe45ZWTyBnbrbNlkMH9y4nMJnXOT6Uc/LppS4FSh3mfkWPFHPeAMr2CaqfZBPMEoPbOTUKJC25JlxvImUHqjNk+MC0Y5TToLYsDWG2fVpXj7QgrYbpZYjC50P5E+VoPs2zhzXRGOZ+16SI6QZai26UvNPZdTVlGI22QK9N/wB13qaVAfTJzMQA6/xp+lThVRAVSjnEG5MVjDPy82G3UDCTp7I0SaV4OLSKefp85dfSuX3QdlqdXx1
2025-08-06 11:50:08 [INFO]: item found in queue is if condition  14409
2025-08-06 11:50:08 [INFO]: item found in queue is  14409
2025-08-06 11:50:08 [INFO]: Message deleted from the queue for receipt handle: AQEBBrWNmXr+jfPYs6nZnq1IdgcTx95ZF/ZeAkcF61oYcIaHNUC84E2TdyJB4nSr7RfSf9ocCe/KUoL8ROMY2QLtUKzjpE4KdqUSFVXQdbTvYWdejO6NV2pBRj3EVxzNbPTNDOX6JFury9Uby2RkY/ccGlxE9XTuA4s7u58g2EESYRdIk7lZ1SjZNbl0rBaZZtwEgVSwqk/Bfx5/h5naMXf23aYnRIdpZQ/ULuw0TL/ldrD87XBFDkzWthq5iOoPE3K18X5AUoszbrz7uT9KD/t114tTRctH9K8UffpIduEvqUzbFtuZIVd+Vbvk2kEd1KmuRVdVNNO6fXVvXePM8HBPffAyNXtX0eWmH0S9y6do3UsnyubaZyUs7CvM8ChAv36Cvkr17XnanbTlB/f5Yevb9u0KXgt0VnmoE2+yw707yN4/Uy3v4g/tYfAzJ9qqQ43M
2025-08-06 11:50:09 [INFO]: item found in queue is if condition  14409
2025-08-06 11:50:09 [INFO]: item found in queue is  14409
2025-08-06 11:50:09 [INFO]: Message deleted from the queue for receipt handle: AQEB25pVYmo/rWcOwnjlwNm3TyYSkIpuT30YjoCY+DcXvhX1PdNXs6Qq7Q3TJUURcTEFImu6DvFGNNuinIvyuwBN++b0ISB820q+A8RLxS5MmqjxgfbJyqNiyypz7E8lwP97iojsFiG/vaB37EEKA9gdTwCn+WWrGRXbXGpxmaSUuf1Oo7B6OAizcDC22hsqA6E2eCyYB/P/A8E7QDp3H7/TMwlHuExSnb1n5iMXjTNGe9O2pgbez2n3ARHLMbZyqTvnjk0KLPEBYk+87Ob89gABKaEY4CwrxjmA6bK43XnRB59NCXwTu5EsZA93lqCGOVRssq0haUsvguQc1ZLfS0hcRjaR3oU5ZNSvAE4KsZPiWGGLY+D33omPMncjc97tHX6xp9OyVlp8V+thEHGAVOnLdd7oVO3a+z8uHbvNhdr7TWBcwF9n5i5vHZKKEVUSxy/5
2025-08-06 11:50:09 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-06 11:50:09 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 11:50:09 [INFO]: inside itemsold and closed 14409
2025-08-06 11:50:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:50:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:50:11 [INFO]: Ebay item id :: 286170070327 exists in Database
2025-08-06 11:50:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:50:11 [INFO]: inside itemsold and closed 14409
2025-08-06 11:50:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:50:13 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:50:13 [INFO]: Ebay item id :: 405092035306 exists in Database
2025-08-06 11:50:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:50:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:50:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:50:13 [INFO]: inside itemsold and closed 14409
2025-08-06 11:50:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 11:50:14 [INFO]: autolink for user_id 14409 is 1
2025-08-06 11:50:14 [INFO]: Ebay item id :: 405344495375 exists in Database
2025-08-06 11:50:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 11:50:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 11:50:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 11:50:14 [INFO]: in processold action queue is array    for {"44579131":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579131","ebayitemid":"286170070327","shopifyproductid":"8739957080286","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"8739957080286","shopifyvariantid":"46072224940254","shopifyinventoryid":"48170974019806","shopifylocationid":"","product_id":"44579131","variant_id":"77471838","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44774084":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44774084","ebayitemid":"405092035306","shopifyproductid":"8694960128222","variants":[{"price":"111.99","quantity":0,"weight":"2","shopifyproductid":"8694960128222","shopifyvariantid":"45933649363166","shopifyinventoryid":"48032100548830","shopifylocationid":"","product_id":"44774084","variant_id":"77682626","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776723":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776723","ebayitemid":"405344495375","shopifyproductid":"8917794423006","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8917794423006","shopifyvariantid":"46726768525534","shopifyinventoryid":"48825257951454","shopifylocationid":"58450641063","product_id":"44776723","variant_id":"77685265","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 11:50:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 11:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:50:14 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 11:50:14 [INFO]: Shopify Inventory id 48170974019806
2025-08-06 11:50:14 [INFO]: Shopify Location id 58450641063
2025-08-06 11:50:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:50:15 [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 11:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579131 and user_id = 14409 
2025-08-06 11:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471838 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:50:15 [INFO]: Shopify Inventory id 48032100548830
2025-08-06 11:50:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:50:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:50:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:50:15Z","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 11:50:15 [INFO]: Change: available | Delta: -1
2025-08-06 11:50:15 [INFO]: Change: on_hand | Delta: -1
2025-08-06 11:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44774084 and user_id = 14409 
2025-08-06 11:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77682626 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:50:15 [INFO]: Shopify Inventory id 48825257951454
2025-08-06 11:50:15 [INFO]: Shopify Location id 58450641063
2025-08-06 11:50:15 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 11:50:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T11:50:15Z","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-06 11:50:15 [INFO]: Change: available | Delta: -2
2025-08-06 11:50:15 [INFO]: Change: on_hand | Delta: -2
2025-08-06 11:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 11:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776723 and user_id = 14409 
2025-08-06 11:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685265 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 11:50:15 [INFO]: updateIdsQuantity -> ["77471838","77682626","77685265"]
2025-08-06 11:50:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 11:50:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77471838 THEN 0 WHEN id = 77682626 THEN 0 WHEN id = 77685265 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77471838 THEN 0 WHEN id = 77682626 THEN 0 WHEN id = 77685265 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77471838,77682626,77685265)
2025-08-06 11:50:15 [INFO]: QUANTITY Updated IDs: 77471838, 77682626, 77685265
2025-08-06 11:50:15 [INFO]: Successfully processed data for user 14409
2025-08-06 11:50:15 [INFO]: Execution Started
2025-08-06 11:50:15 [INFO]: Execution Finished