2025-08-07 01:00:01 [INFO]: Execution Started
2025-08-07 01:00:01 [INFO]: old server sucessfully connected
2025-08-07 01:00:01 [INFO]: sqs client sucess created
2025-08-07 01:00:02 [INFO]: Number of messages in the queue: 0
2025-08-07 01:00:23 [INFO]: Execution Started
2025-08-07 01:00:23 [INFO]: Execution Finished
2025-08-07 01:10:01 [INFO]: Execution Started
2025-08-07 01:10:01 [INFO]: old server sucessfully connected
2025-08-07 01:10:01 [INFO]: sqs client sucess created
2025-08-07 01:10:02 [INFO]: Number of messages in the queue: 0
2025-08-07 01:10:22 [INFO]: Execution Started
2025-08-07 01:10:22 [INFO]: Execution Finished
2025-08-07 01:20:01 [INFO]: Execution Started
2025-08-07 01:20:01 [INFO]: old server sucessfully connected
2025-08-07 01:20:01 [INFO]: sqs client sucess created
2025-08-07 01:20:02 [INFO]: Number of messages in the queue: 2
2025-08-07 01:20:02 [INFO]: item found in queue is if condition  14409
2025-08-07 01:20:02 [INFO]: item found in queue is  14409
2025-08-07 01:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBe+VCBI5crNWF8E/j17uYCYrFZ/S1YMlnKlEzltOm6OImD6ub30K7SOlbPShIsmefDnRpJznH26dphqh7gq9ZEeW5JG7wMIkYxmESSKTdimLkQiYpH1fymtgygnZ0rzdM8A3q/iGX1SaRZozByIiJcFX4BUIQZq3eRhs01PELE5EQ63I9xpuxOzPVBmsd7oQEsE0dYq2yQFf8j4Zi8v5UJ3v2FK7L7YqY6SDNqlMq4TBMV7D/evAW8p6f+AztTu0wDO5Dd2/Dslbi4I3EK2Vb2PCMjh/RgqtM49qx0V15MLl51Mp5yi0BgfK9nO5KrmxpQX252Ak1ccZMa06dJ7uHohziIy6s9WXznbNgViDCP+w757CbneaVyPHSEops5B9dUY9kFzIDOUMBimykEADfzQXL0/6phQABsmXuLph7RPi1/YSSNHOGYTuAqQ09Hwsq
2025-08-07 01:20:03 [INFO]: item found in queue is if condition  14409
2025-08-07 01:20:03 [INFO]: item found in queue is  14409
2025-08-07 01:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBsQO8WkbLAfz9mcIaNod+ySZGw7ZTd3ihK++kAZJ9foeSa4ZXt5ADzgh/ubMREUSjWtBV0idl2XHHA1yr30DFqshH6kcPXceNWM3vKTeSmrDXo6XTYC3YyRYLi1xconO9Ks1HJFzKYvPqVfoksRZUu+oZV0n9BTDHg8Cj/Ivohy22tH3ASfP+atrEIRJf7Hz8+w1LMba+uhZCx+7qjES7rRV9YIdM66Z6EiZx0Y7UylNDOaSotkn9h0rDqRbrokC2y2ffpjYv6D+BsmbNwWvo/3MWb3ArS1MPsxlK4UgTRHWlMr1qveX6BGIofhD9naefUCgHVUgVV5roIrBAt+HD3j5E/jKhN0mMRX5NhQ1Yi7e4n4KLw1BpUVOap1UoMpvx9lX8peB74p1IMm4z2J82cQFdZHlDeqG9oSp07A9P66pYge87iV8kfu0wWCTPXoGN
2025-08-07 01:20:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-07 01:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 01:20:03 [INFO]: inside itemsold and closed 14409
2025-08-07 01:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 01:20:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 01:20:05 [INFO]: Ebay item id :: 326666325166 exists in Database
2025-08-07 01:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 01:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-07 01:20:05 [INFO]: inside itemsold and closed 14409
2025-08-07 01:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 01:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-07 01:20:07 [INFO]: Ebay item id :: 326505299653 exists in Database
2025-08-07 01:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 01:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 01:20:07 [INFO]: in processold action queue is array    for {"45181612":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45181612","ebayitemid":"326666325166","deleted":1}}}
2025-08-07 01:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 01:20:07 [INFO]: productIds WHich are having null productid -> [45181612]
2025-08-07 01:20:07 [INFO]: ebayItemIds WHich are not imported-> ["326666325166"]
2025-08-07 01:20:07 [INFO]: Entered in bulkUpdateProducts function
2025-08-07 01:20:07 [INFO]: Transaction started for bulkUpdateProducts
2025-08-07 01:20:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45181612)
2025-08-07 01:20:07 [INFO]: Query executed successfully. Affected rows: 0
2025-08-07 01:20:07 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-07 01:20:07 [INFO]: Transaction committed successfully.
2025-08-07 01:20:07 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-07 01:20:07 [INFO]: Successfully processed data for user 14409
2025-08-07 01:20:07 [INFO]: Execution Started
2025-08-07 01:20:07 [INFO]: Execution Finished
2025-08-07 01:30:01 [INFO]: Execution Started
2025-08-07 01:30:01 [INFO]: old server sucessfully connected
2025-08-07 01:30:01 [INFO]: sqs client sucess created
2025-08-07 01:30:02 [INFO]: Number of messages in the queue: 1
2025-08-07 01:30:02 [INFO]: item found in queue is if condition  14409
2025-08-07 01:30:02 [INFO]: item found in queue is  14409
2025-08-07 01:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBtExAufdYZgApqZ/PLWOnrVv7DBNnS9Hkx35al7/O2rO5O70z31EfzNTV9O5KuzTrbkgis2wym3Qkz31BdKzzzifMLMLMOxu2xObxGe6Dndr81ehjgCaPpNMbYsjzTUMPdaSrnNNHqU/MaFEhxXKk4JMSlED5atHYZNwk3fZcizoPi+nEJLDRTH+eZmuVLJlA/m7OkQTVPJ2XUq135NMX/8nYtTaWYnA4kFmv+JOOLv70WOI/5gtNI3d95+H2BypYTMrZ5dBVwr2Fkomdzskb9y+SVmXJmzLuPEh0K6bqCjvxIB1bFtbamqQSC2deVCTIY2XLS1VkPwcVsY9HDNqd6FMZMgIGT338qLNhf5E4GHVyzm+s0mR9FTzCKbODN/Y1lRMsgSAZ3ziH/7DQMF4bEsdUDLqOapbxOkJY5gDckf2V2HBS6sMMii5m30U6jhmr
2025-08-07 01:30:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 01:30:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 01:30:03 [INFO]: inside itemsold and closed 14409
2025-08-07 01:30:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 01:30:04 [INFO]: autolink for user_id 14409 is 1
2025-08-07 01:30:04 [INFO]: Ebay item id :: 226720531348 exists in Database
2025-08-07 01:30:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 01:30:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 01:30:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 01:30:04 [INFO]: in processold action queue is array    for {"44674806":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674806","ebayitemid":"226720531348","shopifyproductid":"8885236269278","variants":[{"price":"28.99","quantity":0,"weight":"3","shopifyproductid":"8885236269278","shopifyvariantid":"46639659286750","shopifyinventoryid":"48742624723166","shopifylocationid":"","product_id":"44674806","variant_id":"77580026","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 01:30:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 01:30:04 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 01:30:04 [INFO]: Shopify Inventory id 48742624723166
2025-08-07 01:30:04 [INFO]: Shopify Location id 58450641063
2025-08-07 01:30:04 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 01:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T01:30: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-07 01:30:05 [INFO]: Change: available | Delta: -1
2025-08-07 01:30:05 [INFO]: Change: on_hand | Delta: -1
2025-08-07 01:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 01:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674806 and user_id = 14409 
2025-08-07 01:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580026 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 01:30:05 [INFO]: updateIdsQuantity -> ["77580026"]
2025-08-07 01:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 01:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77580026 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77580026 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77580026)
2025-08-07 01:30:05 [INFO]: QUANTITY Updated IDs: 77580026
2025-08-07 01:30:05 [INFO]: Successfully processed data for user 14409
2025-08-07 01:30:05 [INFO]: Execution Started
2025-08-07 01:30:05 [INFO]: Execution Finished
2025-08-07 01:40:01 [INFO]: Execution Started
2025-08-07 01:40:01 [INFO]: old server sucessfully connected
2025-08-07 01:40:02 [INFO]: sqs client sucess created
2025-08-07 01:40:03 [INFO]: Number of messages in the queue: 2
2025-08-07 01:40:03 [INFO]: item found in queue is if condition  14409
2025-08-07 01:40:03 [INFO]: item found in queue is  14409
2025-08-07 01:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHXrHJ12VirhzX5uYIpRFY7NHsiwoKXEezVab5w9i6OIfacW9qnf5MteNAbVo18lguQQyNbWFi0/hfPcohzGfXgiSfyade4YBx8xTn+BTD8nFTcE7eU+h+gUkLD8O2ezttqwrcDAXZ9+Yk991QVou7W1wFUocpVNIDmHaMz1ktWz97l7fSpROUkJMlP6D4ASekaYfNFr/QXyNBBqxk+dVAqin6mJRY34ncgxX4wzzMSfvHcwj1mrv6DzldmE86Cp6kBueEWkPzaxgZKKI5OIC+a6NE9+//YXf+w2arxUzwgwT9wYZTQAwGivteS8vNusiFXzyaRvfyx+2fsoyfQ9p8YTRaW+IVxqUl43mPFwQebgoT2a4RzoVwm8fL11HCGCwfdKHkGoPV1jE5HMrlWKxuMeRvijkiTlaq68UM12o33AAu4PdHBIsWSpL7Vpjim6n
2025-08-07 01:40:03 [INFO]: item found in queue is if condition  14409
2025-08-07 01:40:03 [INFO]: item found in queue is  14409
2025-08-07 01:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBpuURPbpooLDOtWC5Edn2U1gBpDYRSUIz2Ps98dzMtb9X5tAzoLiqCP2/Mve5M8/czc/Mis7a853/ikTQ626E69my+wT7VCLTK2+yDqfFTd/abnaNWlifUjXvqaiHbcDuWZUCjCcBBJztFsa8uxl12gpO/gIMmGLIjlly5sP5JRdpmHvD0IbF0+vOXtb6t5KynEM6Sj0trxRAxA7u/ICaUL3GMQBNX3msxsgRY8vBYL1arGLiBztR+3SHCAeycL5zueVc6C9Qu//yKEjPiku1djMUO91srEtuDJYLWBkLRFXXAsq81OIbkClbNwdydn0sWPOTUzD8v5iLG588B4r6VsoMr+9hLatqJVg17Hhxav13H+XNqtQUZANjNjRnLSEf/eWpuWtQn0MFo3RZ+n0VAUfZdIcH/pc/LTNFC5WcEIJJ/RpX5APHAp0ZgrqazHU/
2025-08-07 01:40:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-07 01:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 01:40:04 [INFO]: inside itemsold and closed 14409
2025-08-07 01:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 01:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 01:40:05 [INFO]: Ebay item id :: 286423609877 exists in Database
2025-08-07 01:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 01:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 01:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 01:40:05 [INFO]: inside itemsold and closed 14409
2025-08-07 01:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 01:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-07 01:40:07 [INFO]: Ebay item id :: 401647215404 exists in Database
2025-08-07 01:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 01:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 01:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 01:40:07 [INFO]: in processold action queue is array    for {"44660881":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44660881","ebayitemid":"286423609877","shopifyproductid":"8028592439518","variants":[{"price":"44.99","quantity":0,"weight":"3","shopifyproductid":"8028592439518","shopifyvariantid":"44164495802590","shopifyinventoryid":"46261480849630","shopifylocationid":"","product_id":"44660881","variant_id":"77566101","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44741739":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44741739","ebayitemid":"401647215404","shopifyproductid":"6637997850791","variants":[{"price":"10.00","quantity":0,"weight":"0.75","shopifyproductid":"6637997850791","shopifyvariantid":"39667437174951","shopifyinventoryid":"41762141438119","shopifylocationid":"","product_id":"44741739","variant_id":"77649908","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 01:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 01:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 01:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 01:40:07 [INFO]: Shopify Inventory id 46261480849630
2025-08-07 01:40:07 [INFO]: Shopify Location id 58450641063
2025-08-07 01:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 01:40: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-07 01:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 01:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44660881 and user_id = 14409 
2025-08-07 01:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566101 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 01:40:07 [INFO]: Shopify Inventory id 41762141438119
2025-08-07 01:40:07 [INFO]: Shopify Location id 58450641063
2025-08-07 01:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 01:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T01:40: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-07 01:40:08 [INFO]: Change: available | Delta: -1
2025-08-07 01:40:08 [INFO]: Change: on_hand | Delta: -1
2025-08-07 01:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 01:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44741739 and user_id = 14409 
2025-08-07 01:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77649908 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 01:40:08 [INFO]: updateIdsQuantity -> ["77566101","77649908"]
2025-08-07 01:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-07 01:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77566101 THEN 0 WHEN id = 77649908 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77566101 THEN 0 WHEN id = 77649908 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77566101,77649908)
2025-08-07 01:40:08 [INFO]: QUANTITY Updated IDs: 77566101, 77649908
2025-08-07 01:40:08 [INFO]: Successfully processed data for user 14409
2025-08-07 01:40:08 [INFO]: Execution Started
2025-08-07 01:40:08 [INFO]: Execution Finished
2025-08-07 01:50:02 [INFO]: Execution Started
2025-08-07 01:50:02 [INFO]: old server sucessfully connected
2025-08-07 01:50:02 [INFO]: sqs client sucess created
2025-08-07 01:50:03 [INFO]: Number of messages in the queue: 0
2025-08-07 01:50:23 [INFO]: Execution Started
2025-08-07 01:50:23 [INFO]: Execution Finished