2025-08-09 00:00:01 [INFO]: Execution Started
2025-08-09 00:00:01 [INFO]: old server sucessfully connected
2025-08-09 00:00:01 [INFO]: sqs client sucess created
2025-08-09 00:00:02 [INFO]: Number of messages in the queue: 0
2025-08-09 00:00:22 [INFO]: Execution Started
2025-08-09 00:00:22 [INFO]: Execution Finished
2025-08-09 00:10:01 [INFO]: Execution Started
2025-08-09 00:10:01 [INFO]: old server sucessfully connected
2025-08-09 00:10:01 [INFO]: sqs client sucess created
2025-08-09 00:10:02 [INFO]: Number of messages in the queue: 1
2025-08-09 00:10:03 [INFO]: item found in queue is if condition  14409
2025-08-09 00:10:03 [INFO]: item found in queue is  14409
2025-08-09 00:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBgoLe0pvyi39hfcjFOpmldePsG8+ZGpHeAK2ndgzBGDMtzE5NeP6fpNaRpGN8C8A1wtRcql389RAVqQjFvcV3uBEgJR0QNtbeAJSeHMiRCb2WaIXRll/kzaiMMa1QZSkTttvxdL4E8LIEOsbr8bRknYFoPU+0WqczwDUJBohxJOaYdQYSFNQpuaQBcO3qIS5iGnMVkJyg/oswwWNHz+pfGeSZZV9dAEkz7llTcP0zdgj4lDafQS3bR2oZJGDVb/6Porz+dqo9c+5h51+Q6BqFBlqfpjza314bO3bKYD7U7vWmhV4n77jPlSdaM/fZXsBPEe2ugzn8/kS15NS/MivVpAT4B8G2E/NcpmRK2a8XvhQfOfh/TRQM9rk9gX4RRDIE/2jLqHcaLDun+VL/I2mk41jfEQZ8t/ajvifapcV+LH6EKTRtEAbpSIXLbJoE1VX2
2025-08-09 00:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-09 00:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-09 00:10:03 [INFO]: inside itemsold and closed 14409
2025-08-09 00:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-09 00:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-09 00:10:05 [INFO]: Ebay item id :: 286457774805 exists in Database
2025-08-09 00:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-09 00:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-09 00:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-09 00:10:05 [INFO]: in processold action queue is array    for {"44555016":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555016","ebayitemid":"286457774805","shopifyproductid":"8863224430814","variants":[{"price":"300.00","quantity":0,"weight":"18","shopifyproductid":"8863224430814","shopifyvariantid":"46520402870494","shopifyinventoryid":"48622814658782","shopifylocationid":"","product_id":"44555016","variant_id":"77447696","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-09 00:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-09 00:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-09 00:10:05 [INFO]: Shopify Inventory id 48622814658782
2025-08-09 00:10:05 [INFO]: Shopify Location id 58450641063
2025-08-09 00:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-09 00:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T00:10:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-09 00:10:05 [INFO]: Change: available | Delta: -1
2025-08-09 00:10:05 [INFO]: Change: on_hand | Delta: -1
2025-08-09 00:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-09 00:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555016 and user_id = 14409 
2025-08-09 00:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447696 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-09 00:10:05 [INFO]: updateIdsQuantity -> ["77447696"]
2025-08-09 00:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-09 00:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77447696 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77447696 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77447696)
2025-08-09 00:10:05 [INFO]: QUANTITY Updated IDs: 77447696
2025-08-09 00:10:05 [INFO]: Successfully processed data for user 14409
2025-08-09 00:10:05 [INFO]: Execution Started
2025-08-09 00:10:05 [INFO]: Execution Finished
2025-08-09 00:20:02 [INFO]: Execution Started
2025-08-09 00:20:02 [INFO]: old server sucessfully connected
2025-08-09 00:20:02 [INFO]: sqs client sucess created
2025-08-09 00:20:03 [INFO]: Number of messages in the queue: 2
2025-08-09 00:20:03 [INFO]: item found in queue is if condition  14409
2025-08-09 00:20:03 [INFO]: item found in queue is  14409
2025-08-09 00:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKXL816OkzZKbnJvx3sOxa6xE9GgO9Pru8HxTH9nLtBINluaufkbYHFr50d5jbAQFCU/YVU/ORUdJumYWR92cRMoLQPBLpVLisp04PYG4njqm7fx9dEQk85Zk1Uc9uqOjLvWqSrJ6CSIp0WZxuoEqtCS3jLdX/YDuluz5nxjD4aaTuyfFoOPNOgN3U2xmyQL9t4c820pNQwXcRouZVgubEriFdQJXpwb8U3VFcKrCEX4g6YSaQ9wDPmg7hpDz3hOEhogv1XP/Lje/Z5JpPPgmV40PjYV2zkTVwSlP4fhJt6kTtgwIGZ1USNcxEaKHuOglGDqRVM3/UuPGp7NV7m5H0DJWwtl6R1DrTwnzUO5E69if3c9PHYolzd/zYng20erswyKCM/U3cI7RCG3pwFc4WPoO9kf27H7KTH2yw1lxxf4SxKjn3NLs4eR25LnMUo4v
2025-08-09 00:20:04 [INFO]: item found in queue is if condition  14409
2025-08-09 00:20:04 [INFO]: item found in queue is  14409
2025-08-09 00:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBw46IO0oQxniqX+0pWzTA6ZyKfipE2/9ygS2qT2Fs34T+6y5zBrDwLT7v9vVEHZx4HZYu5cYvFJS26AwpeyXiKTfE+ICAetUyqtEH1CVtzexQ04SoTTVDVEJU12gIqgSwCXomgyDZYMFP0g4oI/YWvCLT6cWz1/PNchYpHMgtGhP/1LNPMUuDkqytpt2WkN8SfkVfCt3K4OEyLkpzj2iQmU0OJMTi1y0n/lGeyzcc7vWvNQXL9t4P0F6rva37uYfLfTIX2CfeWZ/HUEP8eNcBs/n3wTd6ipINoIGXXc7Gh71Dy4Bjl28k/yL4/Ba1HdnwA5lXAErxmTl50hXVjnGNiAVSEWeIySFRYlCYNgA6TzecPe0OqCFPX3E3MA8mbLSg/GnOHvXi69CT6FaWbMnoe/LEFbM2fHDhkP4Zh7VHdOqkDVPaaBhqwNt1uFn7/m7u
2025-08-09 00:20:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-09 00:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-09 00:20:04 [INFO]: inside itemsold and closed 14409
2025-08-09 00:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-09 00:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-09 00:20:06 [INFO]: Ebay item id :: 326521919459 exists in Database
2025-08-09 00:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-09 00:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-09 00:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-09 00:20:06 [INFO]: inside itemsold and closed 14409
2025-08-09 00:20:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-09 00:20:08 [INFO]: autolink for user_id 14409 is 1
2025-08-09 00:20:08 [INFO]: Ebay item id :: 286623942820 exists in Database
2025-08-09 00:20:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-09 00:20:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-09 00:20:08 [INFO]: in processold action queue is array    for {"44737544":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737544","ebayitemid":"326521919459","shopifyproductid":"8867616030942","variants":[{"price":"684.99","quantity":0,"weight":"2","shopifyproductid":"8867616030942","shopifyvariantid":"46584483872990","shopifyinventoryid":"48687000781022","shopifylocationid":"","product_id":"44737544","variant_id":"77645481","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45113356":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113356","ebayitemid":"286623942820","deleted":1}}}
2025-08-09 00:20:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-09 00:20:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-09 00:20:08 [INFO]: productIds WHich are having null productid -> [45113356]
2025-08-09 00:20:08 [INFO]: ebayItemIds WHich are not imported-> ["286623942820"]
2025-08-09 00:20:08 [INFO]: Entered in bulkUpdateProducts function
2025-08-09 00:20:08 [INFO]: Transaction started for bulkUpdateProducts
2025-08-09 00:20:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113356)
2025-08-09 00:20:08 [INFO]: Query executed successfully. Affected rows: 0
2025-08-09 00:20:08 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-09 00:20:08 [INFO]: Transaction committed successfully.
2025-08-09 00:20:08 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-09 00:20:08 [INFO]: Shopify Inventory id 48687000781022
2025-08-09 00:20:08 [INFO]: Shopify Location id 58450641063
2025-08-09 00:20:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-09 00:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T00:20:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-09 00:20:08 [INFO]: Change: available | Delta: -1
2025-08-09 00:20:08 [INFO]: Change: on_hand | Delta: -1
2025-08-09 00:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-09 00:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737544 and user_id = 14409 
2025-08-09 00:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645481 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-09 00:20:08 [INFO]: updateIdsQuantity -> ["77645481"]
2025-08-09 00:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-09 00:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77645481 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77645481 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77645481)
2025-08-09 00:20:08 [INFO]: QUANTITY Updated IDs: 77645481
2025-08-09 00:20:08 [INFO]: Successfully processed data for user 14409
2025-08-09 00:20:08 [INFO]: Execution Started
2025-08-09 00:20:08 [INFO]: Execution Finished
2025-08-09 00:30:01 [INFO]: Execution Started
2025-08-09 00:30:01 [INFO]: old server sucessfully connected
2025-08-09 00:30:01 [INFO]: sqs client sucess created
2025-08-09 00:30:02 [INFO]: Number of messages in the queue: 0
2025-08-09 00:30:23 [INFO]: Execution Started
2025-08-09 00:30:23 [INFO]: Execution Finished
2025-08-09 00:40:02 [INFO]: Execution Started
2025-08-09 00:40:02 [INFO]: old server sucessfully connected
2025-08-09 00:40:02 [INFO]: sqs client sucess created
2025-08-09 00:40:03 [INFO]: Number of messages in the queue: 1
2025-08-09 00:40:03 [INFO]: item found in queue is if condition  14409
2025-08-09 00:40:03 [INFO]: item found in queue is  14409
2025-08-09 00:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7t888AglgIh/BiTRglbnECTC8vGCPC9HiRutR1D1NsoBdxGRuNFqq6ZULWe6uWqKCSPiGU/95OR+vKKEJPlaqwizJIwe+sohH6M+69x8h0NOCFZ9K2WUf1W1NTUpKLc/e1sXpd2SR/eAX5knnitAsqPg7MAsp+gcPxZNx5/V485/MxPMY1OKFZGcuJYGLedo59015GFZG2KuH2GBf8bu1LvLh5Yj7cFYEEzdWhkr+0pe1Jk3coHYWZWQqlbUYejIrQj76BO9J1NBvImLw6SvygWpwzXndHBQZIcV50lz/IFrqK9lTCQMIlYdN4GLapqFu6xstWgxfyKPywKodz57jAWE7Semedvhy41Nkd0d0VNO87hSBXAHk+LDLRfNR7b9StxoRGk0GD7z/hUJN0VNAECSQO/IfXCSjCy6V+QyUfsA831awbZp1CLUQE9RhtG6
2025-08-09 00:40:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-09 00:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-09 00:40:03 [INFO]: inside itemsold and closed 14409
2025-08-09 00:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-09 00:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-09 00:40:05 [INFO]: Ebay item id :: 286444739945 exists in Database
2025-08-09 00:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-09 00:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-09 00:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-09 00:40:05 [INFO]: in processold action queue is array    for {"44595116":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595116","ebayitemid":"286444739945","shopifyproductid":"8857303711966","variants":[{"price":"260.99","quantity":0,"weight":"18","shopifyproductid":"8857303711966","shopifyvariantid":"46493190127838","shopifyinventoryid":"48595401244894","shopifylocationid":"","product_id":"44595116","variant_id":"77487825","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-09 00:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-09 00:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-09 00:40:05 [INFO]: Shopify Inventory id 48595401244894
2025-08-09 00:40:05 [INFO]: Shopify Location id 58450641063
2025-08-09 00:40:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-09 00:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-09T00:40:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-09 00:40:06 [INFO]: Change: available | Delta: -1
2025-08-09 00:40:06 [INFO]: Change: on_hand | Delta: -1
2025-08-09 00:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-09 00:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595116 and user_id = 14409 
2025-08-09 00:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487825 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-09 00:40:06 [INFO]: updateIdsQuantity -> ["77487825"]
2025-08-09 00:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-09 00:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77487825 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77487825 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77487825)
2025-08-09 00:40:06 [INFO]: QUANTITY Updated IDs: 77487825
2025-08-09 00:40:06 [INFO]: Successfully processed data for user 14409
2025-08-09 00:40:06 [INFO]: Execution Started
2025-08-09 00:40:06 [INFO]: Execution Finished
2025-08-09 00:50:01 [INFO]: Execution Started
2025-08-09 00:50:01 [INFO]: old server sucessfully connected
2025-08-09 00:50:01 [INFO]: sqs client sucess created
2025-08-09 00:50:02 [INFO]: Number of messages in the queue: 0
2025-08-09 00:50:22 [INFO]: Execution Started
2025-08-09 00:50:22 [INFO]: Execution Finished