2025-08-12 13:00:02 [INFO]: Execution Started
2025-08-12 13:00:02 [INFO]: old server sucessfully connected
2025-08-12 13:00:02 [INFO]: sqs client sucess created
2025-08-12 13:00:04 [INFO]: Number of messages in the queue: 3
2025-08-12 13:00:05 [INFO]: item found in queue is if condition  14409
2025-08-12 13:00:05 [INFO]: item found in queue is  14409
2025-08-12 13:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBlvh2igjx/Ubf7k/MFpdclmxL52Iyhlpec/+PDPAqPyYCyHYNFjXpzjw+e2awSJK2sKltBLoEZvuoGpPg+NFi2puvzbYkoUaI+WxKExo5pTEPzXtHkBXUx/PcJKFRHHLiiJqOOOKnTbH1HTlKjAyTt/vYPr/Gs6Miu27YbaqvIIzntYjmMsxuv3lPwQ87sUcVuAUcUitsvTA51A9Iz28avuzCU0YgPzkJ7hcJ7oAvz5Q0kt/9RumGST5cflK5I9wYkW9yZL+JI8hV2AIp8/VAs0KsNynWvJpMHEfuSAFMjcAMqk6BNu3G/i7gMDFNYmwoM5/5JlYjI4wOnjQPzK1qU3pBs5dRL50PZdLacimr82YOuuhAzwHjp48ICkzv8qDdg9EGlofzoa3bVKKB1qzGYYa+5UBdc89Gsa9AxF+twudOfSVK5Jc8CASP1tKrwBbw
2025-08-12 13:00:06 [INFO]: item found in queue is if condition  14409
2025-08-12 13:00:06 [INFO]: item found in queue is  14409
2025-08-12 13:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEB2GBck/0nzi+CQaZr5Dku1LOJ0iGJTL5k+uabVnQwWIt6AxwjUCNaSGqbtUHEVLEbY9Bg/anH7sRWs1aJYuiBhsFw+/Ub2sfRww7JFLWM/GsBW6EtTme06tGkFIJGRBFeovwY+fbFEn3wQ/p/syi1qGeL9wXS6MYyD46adm7Sc4+0BTGP3MidjFili9pOivuC1r1us5DOgwruKJO3x2VW5iDEO06Q4AbkTfR5Q8aTTRiGcgCkjDRNWfzWM3q5Nx3JETkSXHeqx6jQLdq5d+jczrHN6aHvvhvIlRz2NNH9JO4QAqSexs3U8amUDH/DXOvvRr1X2swaibUtZMvS7ynO/VLDuADyfmzcYj6KBFzAeAw+OJCn6nDwUtnP6V2MUHc1ss427vjBrg+ar5c+eElPeJX759YsPuc3mzRjYxAwqS3pq233zr3Vt74NmcWlNrgX
2025-08-12 13:00:07 [INFO]: item found in queue is if condition  14409
2025-08-12 13:00:07 [INFO]: item found in queue is  14409
2025-08-12 13:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEBkwfwCyqqYL+i0d4874e3Q9L+d3RDKyGjV5O3p2PxKzVialJKTKRjh83lZh38mJ6g9ymHL9ek0z5H9724ZlY0D8ct0gI0y6n6PAR1/z0mbPJi9kcT8IT7CXXR8mj0TNKnuRsV+qNSU4b/2VRrL/OO2fdkMNA5N8j2QaNh/iwkYx/r26XXh7PJHsBY+QPB6RWd9vxlRNUxSx03Ot+lAgcqRAbd3ZR1orDaCI86BVjtTsOPUZKQ7wosGdTV4WycosgM8Ue0DJjw02AUR09ggKzOruFhV2Ox2HsoyEa0BzyuZ6VaserBGt8dLlaJLwG4N5TLcIlDOlIIfRy5QA/t3R/n8uUJhkzEa6/VWZCcC8//oKbabZJd7kBCO1NiDhmGMYuG/LDvfBkTBY+UKB73cNKC9AD2geJpQ7/QAL7fn0TjYnNGUct+WAKwZnl5LbDSDJ9w
2025-08-12 13:00:08 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-12 13:00:08 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 13:00:08 [INFO]: inside itemsold and closed 14409
2025-08-12 13:00:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:00:10 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:00:10 [INFO]: Ebay item id :: 256490157990 exists in Database
2025-08-12 13:00:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:00:10 [INFO]: inside itemsold and closed 14409
2025-08-12 13:00:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:00:12 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:00:12 [INFO]: Ebay item id :: 285829715761 exists in Database
2025-08-12 13:00:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:00:12 [INFO]: inside itemsold and closed 14409
2025-08-12 13:00:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:00:13 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:00:13 [INFO]: Ebay item id :: 285829715761 exists in Database
2025-08-12 13:00:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:00:13 [INFO]: in processold action queue is array    for {"44675309":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675309","ebayitemid":"256490157990","shopifyproductid":"8439914987742","variants":[{"price":"122.99","quantity":0,"weight":"2","shopifyproductid":"8439914987742","shopifyvariantid":"45256994029790","shopifyinventoryid":"47354910736606","shopifylocationid":"","product_id":"44675309","variant_id":"77580529","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44678563":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44678563","ebayitemid":"285829715761","shopifyproductid":"8696068931806","variants":[{"price":"59.00","quantity":0,"weight":"2","shopifyproductid":"8696068931806","shopifyvariantid":"45936109846750","shopifyinventoryid":"48034558771422","shopifylocationid":"","product_id":"44678563","variant_id":"77583783","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 13:00:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 13:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 13:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 13:00:13 [INFO]: Shopify Inventory id 47354910736606
2025-08-12 13:00:13 [INFO]: Shopify Location id 58450641063
2025-08-12 13:00:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 13:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T13:00: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-12 13:00:14 [INFO]: Change: available | Delta: -1
2025-08-12 13:00:14 [INFO]: Change: on_hand | Delta: -1
2025-08-12 13:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 13:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675309 and user_id = 14409 
2025-08-12 13:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580529 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 13:00:14 [INFO]: Shopify Inventory id 48034558771422
2025-08-12 13:00:14 [INFO]: Shopify Location id 58450641063
2025-08-12 13:00:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 13:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T13:00:14Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-12 13:00:14 [INFO]: Change: available | Delta: -4
2025-08-12 13:00:14 [INFO]: Change: on_hand | Delta: -4
2025-08-12 13:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 13:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44678563 and user_id = 14409 
2025-08-12 13:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77583783 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 13:00:14 [INFO]: updateIdsQuantity -> ["77580529","77583783"]
2025-08-12 13:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-12 13:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77580529 THEN 0 WHEN id = 77583783 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77580529 THEN 0 WHEN id = 77583783 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77580529,77583783)
2025-08-12 13:00:14 [INFO]: QUANTITY Updated IDs: 77580529, 77583783
2025-08-12 13:00:14 [INFO]: Successfully processed data for user 14409
2025-08-12 13:00:14 [INFO]: Execution Started
2025-08-12 13:00:14 [INFO]: Execution Finished
2025-08-12 13:10:01 [INFO]: Execution Started
2025-08-12 13:10:01 [INFO]: old server sucessfully connected
2025-08-12 13:10:01 [INFO]: sqs client sucess created
2025-08-12 13:10:02 [INFO]: Number of messages in the queue: 3
2025-08-12 13:10:03 [INFO]: item found in queue is if condition  14409
2025-08-12 13:10:03 [INFO]: item found in queue is  14409
2025-08-12 13:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBzdaFNYZm8Nbhf2Bi8M+Lb79lSTQkZdtnzcxtK1GSvfvqy4xbI21LyWmmkh0xd5pa/decZWGzfR5BB/5K6jftpiJAY+O0LQqhxryJbLyxKr6hbfgqrnixHDAuSU3HaTDsKMx6YGl9R3DgMjdYbD/VMQ6/wPXOixFJSvR1ZPmUDCFHXiQ0GFh+Ky8oCzMeUuCrV1F/j+/wOfkjMNRxJorik6oTXzUFgGhxqqo5Emn2AjnS3bl1GqooP0FV2fFaktW3ImzTsWw19QRwu4XytFTRmrO7qo7xsugpcm+rVOYvaqPauUwfiYwp70nTQK1v+ZzvwHJ2DRVVMs0R+9PqIuAwDkdE2xzEi/3eFC5txSwWedzBAPY1mjG5XwSDEgBecBf8FXkiglug1zqDBMiPmUctxgfue5y/EdKal9QqImMe776P8uxizVSOR4X4E+abnp4b
2025-08-12 13:10:04 [INFO]: item found in queue is if condition  14409
2025-08-12 13:10:04 [INFO]: item found in queue is  14409
2025-08-12 13:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBTabfm8P64yBV7GrQQd0SPvYPqIHstvGZmkgrZQW5RnIaGsQTLujMF2A7+eYkfq7Ot4sVdAUclK9m5LHagec3+7yNQZ64iOARYSs/VBwtkH2CNk9nc6w879Yk82ohN147o2c/rQcsEugwQVGIg594Lh91vdC+QKK/iTFWYcVODYG725fgyczoyRBvk5aiC9sEQucfLyeFFx3yNPNPqiPBapkO/zLDUuvJMf6NM5WymzppVIz7rF5825e7twMNX/FBvfj/XbyMCPuC+sHBRfGylQBg/ndvDjt+SUyP4aLzED/WEIk8K8kMjrBEwO9bOR7DFHPdIoY3eoOFDOpqEojgiBmr8fZlqQhBLRkjPPxTc1rFQ6jb3VBbg6qhSZ3FhUXYxMbqfaroYnFEb8bdEQhcrkcSeuhyRk59zl5qZaHf2njdWngmiRfplYnrIdvtPKno
2025-08-12 13:10:04 [INFO]: item found in queue is if condition  14409
2025-08-12 13:10:04 [INFO]: item found in queue is  14409
2025-08-12 13:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBX0CuimRrIrmvk9vGE6VpvTF79WtF/h2phcRzo1vszJ4LZqUbeMFzX4yAhrQwYk8gl3D1T6Ye1B0u5WGNppgDKrygHVEUKfkh+nnwZh+p/SMADlmS24HPqlhWefULxgDBuT2FWjxPzTYGa4wfGcI/Ez+9YI+x4NywisNY0SOLAdcjBh16Zvohh5LaGclAZpupPxfD/CiXM+lhdolUSPISR/LrElWw9c6T+3gQiERPFBe7kjmtrsWZPdlATdlzjIWcRIwfVXSExW2OYjveV6LhQ3uwespwfsFoXos4Xmhgv9TH9eIVPL9l7taVo2NAcFrdPHhlKXK9qP3Q+t5HlDWXjXPyehL85+k2qsNdJ8o34Y3ZHedYl8fIAz6ommk2W/OGtXSvBGnEZSLqwIvydH7h9Tdw9xn4URmkMkE3UI3995intrOOLLC4JZu+KQ4+rsD3
2025-08-12 13:10:05 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-12 13:10:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 13:10:05 [INFO]: inside itemsold and closed 14409
2025-08-12 13:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:10:06 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:10:06 [INFO]: Ebay item id :: 405223910105 exists in Database
2025-08-12 13:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:10:06 [INFO]: inside itemsold and closed 14409
2025-08-12 13:10:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:10:08 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:10:08 [INFO]: Ebay item id :: 286055828522 exists in Database
2025-08-12 13:10:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:10:08 [INFO]: inside itemsold and closed 14409
2025-08-12 13:10:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:10:10 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:10:10 [INFO]: Ebay item id :: 405890790404 exists in Database
2025-08-12 13:10:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:10:10 [INFO]: in processold action queue is array    for {"44775544":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775544","ebayitemid":"405223910105","shopifyproductid":"7446859776222","variants":[{"price":"59.00","quantity":0,"weight":"2","shopifyproductid":"7446859776222","shopifyvariantid":"42054068207838","shopifyinventoryid":"44147996229854","shopifylocationid":"","product_id":"44775544","variant_id":"77684086","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44775541":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775541","ebayitemid":"286055828522","shopifyproductid":"8696075092190","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8696075092190","shopifyvariantid":"45936124788958","shopifyinventoryid":"48034573746398","shopifylocationid":"","product_id":"44775541","variant_id":"77684083","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44858451":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44858451","ebayitemid":"405890790404","shopifyproductid":"8927182651614","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8927182651614","shopifyvariantid":"46846584553694","shopifyinventoryid":"48958029201630","shopifylocationid":"58450641063","product_id":"44858451","variant_id":"77769552","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 13:10:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 13:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 13:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 13:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 13:10:10 [INFO]: Shopify Inventory id 44147996229854
2025-08-12 13:10:10 [INFO]: Shopify Location id 58450641063
2025-08-12 13:10:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 13:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T13:10:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-12 13:10:10 [INFO]: Change: available | Delta: -1
2025-08-12 13:10:10 [INFO]: Change: on_hand | Delta: -1
2025-08-12 13:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 13:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775544 and user_id = 14409 
2025-08-12 13:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684086 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 13:10:10 [INFO]: Shopify Inventory id 48034573746398
2025-08-12 13:10:10 [INFO]: Shopify Location id 58450641063
2025-08-12 13:10:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 13:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T13:10:10Z","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-12 13:10:10 [INFO]: Change: available | Delta: -2
2025-08-12 13:10:10 [INFO]: Change: on_hand | Delta: -2
2025-08-12 13:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 13:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775541 and user_id = 14409 
2025-08-12 13:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684083 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 13:10:10 [INFO]: Shopify Inventory id 48958029201630
2025-08-12 13:10:10 [INFO]: Shopify Location id 58450641063
2025-08-12 13:10:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 13:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T13: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-12 13:10:11 [INFO]: Change: available | Delta: -1
2025-08-12 13:10:11 [INFO]: Change: on_hand | Delta: -1
2025-08-12 13:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 13:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44858451 and user_id = 14409 
2025-08-12 13:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77769552 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 13:10:11 [INFO]: updateIdsQuantity -> ["77684086","77684083","77769552"]
2025-08-12 13:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-12 13:10:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77684086 THEN 0 WHEN id = 77684083 THEN 0 WHEN id = 77769552 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77684086 THEN 0 WHEN id = 77684083 THEN 0 WHEN id = 77769552 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77684086,77684083,77769552)
2025-08-12 13:10:11 [INFO]: QUANTITY Updated IDs: 77684086, 77684083, 77769552
2025-08-12 13:10:11 [INFO]: Successfully processed data for user 14409
2025-08-12 13:10:11 [INFO]: Execution Started
2025-08-12 13:10:11 [INFO]: Execution Finished
2025-08-12 13:20:01 [INFO]: Execution Started
2025-08-12 13:20:01 [INFO]: old server sucessfully connected
2025-08-12 13:20:01 [INFO]: sqs client sucess created
2025-08-12 13:20:04 [INFO]: Number of messages in the queue: 1
2025-08-12 13:20:04 [INFO]: item found in queue is if condition  14409
2025-08-12 13:20:04 [INFO]: item found in queue is  14409
2025-08-12 13:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBdoZURwWXd+W7GReJFC9M5bd3/ZmLjEnlUNjf0rVZxLDQ2+3sY54gWye4Sf23cCpqTJV6nmNKl3G6V2dj6tntYTRhYxCdNVCvBeAkVac6qIGT7kR0MfMLSTOW9EDVRMLJ6ggM4QliUlwfFA1a9N3bIFt5j0dDkS7qVcFVe/754n/2Ysm/LURacPrpE1ylu1bnzZ88Bg6Z7ewXZHqGxzfQ7Zvid43rTi+ZckU+1WWI0mp3YKiQbkDZn7h2RB9dmInNMerhRb9tsyoh9eVvYIb5sIN5wJsvFkJav8ymeHqiRppY4nJLWEJqkKohlxXaCGYIeG0N25QmLixbviqaI1ZOoZGsTIA46juP76ary3xfau78DbnX8eGhBUj2fY9rq2fA7lk/RVqJxjEWa0eMw83ZKJ1lT+BWOzUwHrQrhYER0J3MI7XsTWI0XLOiOd52jCnY
2025-08-12 13:20:05 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 13:20:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 13:20:05 [INFO]: inside itemsold and closed 14409
2025-08-12 13:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 13:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-12 13:20:07 [INFO]: Ebay item id :: 256930493670 exists in Database
2025-08-12 13:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 13:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 13:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 13:20:07 [INFO]: in processold action queue is array    for {"44894761":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44894761","ebayitemid":"256930493670","shopifyproductid":"8929185235166","variants":[{"price":"13.99","quantity":0,"weight":"2","shopifyproductid":"8929185235166","shopifyvariantid":"46853288329438","shopifyinventoryid":"48964725801182","shopifylocationid":"58450641063","product_id":"44894761","variant_id":"77811805","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 13:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 13:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 13:20:07 [INFO]: Shopify Inventory id 48964725801182
2025-08-12 13:20:07 [INFO]: Shopify Location id 58450641063
2025-08-12 13:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 13:20:07 [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-12 13:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 13:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44894761 and user_id = 14409 
2025-08-12 13:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77811805 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 13:20:07 [INFO]: updateIdsQuantity -> ["77811805"]
2025-08-12 13:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 13:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77811805 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77811805 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77811805)
2025-08-12 13:20:07 [INFO]: QUANTITY Updated IDs: 77811805
2025-08-12 13:20:07 [INFO]: Successfully processed data for user 14409
2025-08-12 13:20:07 [INFO]: Execution Started
2025-08-12 13:20:07 [INFO]: Execution Finished
2025-08-12 13:30:01 [INFO]: Execution Started
2025-08-12 13:30:01 [INFO]: old server sucessfully connected
2025-08-12 13:30:01 [INFO]: sqs client sucess created
2025-08-12 13:30:08 [INFO]: Number of messages in the queue: 0
2025-08-12 13:30:29 [INFO]: Execution Started
2025-08-12 13:30:29 [INFO]: Execution Finished
2025-08-12 13:40:02 [INFO]: Execution Started
2025-08-12 13:40:02 [INFO]: old server sucessfully connected
2025-08-12 13:40:02 [INFO]: sqs client sucess created
2025-08-12 13:40:03 [INFO]: Number of messages in the queue: 0
2025-08-12 13:40:24 [INFO]: Execution Started
2025-08-12 13:40:24 [INFO]: Execution Finished
2025-08-12 13:50:01 [INFO]: Execution Started
2025-08-12 13:50:01 [INFO]: old server sucessfully connected
2025-08-12 13:50:01 [INFO]: sqs client sucess created
2025-08-12 13:50:05 [INFO]: Number of messages in the queue: 0
2025-08-12 13:50:25 [INFO]: Execution Started
2025-08-12 13:50:25 [INFO]: Execution Finished