2025-08-14 04:00:01 [INFO]: Execution Started
2025-08-14 04:00:01 [INFO]: old server sucessfully connected
2025-08-14 04:00:01 [INFO]: sqs client sucess created
2025-08-14 04:00:02 [INFO]: Number of messages in the queue: 1
2025-08-14 04:00:03 [INFO]: item found in queue is if condition  14409
2025-08-14 04:00:03 [INFO]: item found in queue is  14409
2025-08-14 04:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHEZMjj6zGohBvBPqtx5Eauk20GjCAq9ZKgPBEphnfvKanSjVodzfCSyX71o9JdXQGG9E6tOs9REW4bR+MWws3TfaikG8kzC5V4IB1HchYSMBjOHxIIYtttZRDqSyPdQUfXcz7w5PuKOlMdVxLQiOCsinAKxhAi1Nc70wC0gSFdtXi5BE9pk8jf2Eyt+2mB3LHAQ+42aGGRV18zUTrWypuhomtnPwQcHc6EqXeg3m5PWvJtNy2Z5UcBoO8k49N/hC3Q3WqJOGXXqsCVVwBUKjKQVwWhYpyXkM+Wyyxf0uziicSo/7CcSVtz1HvF2pOaFVP0QKtW6pCu7H0tUEbRlfvWjN4FYQPWX/94PO9ADUvx1+KNcnG61k8270RyAQ0ic45nRkKTR/ZUaeEPeItonGTWjbMWiuZeSJqqhBmumc/5pX4uA5RsxkBQvoN+UJEQdM
2025-08-14 04:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 04:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 04:00:03 [INFO]: inside itemsold and closed 14409
2025-08-14 04:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 04:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-14 04:00:05 [INFO]: Ebay item id :: 305831344239 exists in Database
2025-08-14 04:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 04:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 04:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 04:00:05 [INFO]: in processold action queue is array    for {"44567169":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567169","ebayitemid":"305831344239","shopifyproductid":"6948859805863","variants":[{"price":"14.99","quantity":0,"weight":"3","shopifyproductid":"6948859805863","shopifyvariantid":"40852173979815","shopifyinventoryid":"42948104552615","shopifylocationid":"","product_id":"44567169","variant_id":"77459849","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 04:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 04:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 04:00:05 [INFO]: Shopify Inventory id 42948104552615
2025-08-14 04:00:05 [INFO]: Shopify Location id 58450641063
2025-08-14 04:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 04:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T04:00: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-14 04:00:05 [INFO]: Change: available | Delta: -1
2025-08-14 04:00:05 [INFO]: Change: on_hand | Delta: -1
2025-08-14 04:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 04:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567169 and user_id = 14409 
2025-08-14 04:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459849 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 04:00:05 [INFO]: updateIdsQuantity -> ["77459849"]
2025-08-14 04:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-14 04:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77459849 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77459849 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77459849)
2025-08-14 04:00:05 [INFO]: QUANTITY Updated IDs: 77459849
2025-08-14 04:00:05 [INFO]: Successfully processed data for user 14409
2025-08-14 04:00:05 [INFO]: Execution Started
2025-08-14 04:00:05 [INFO]: Execution Finished
2025-08-14 04:10:01 [INFO]: Execution Started
2025-08-14 04:10:01 [INFO]: old server sucessfully connected
2025-08-14 04:10:01 [INFO]: sqs client sucess created
2025-08-14 04:10:02 [INFO]: Number of messages in the queue: 0
2025-08-14 04:10:23 [INFO]: Execution Started
2025-08-14 04:10:23 [INFO]: Execution Finished
2025-08-14 04:20:02 [INFO]: Execution Started
2025-08-14 04:20:02 [INFO]: old server sucessfully connected
2025-08-14 04:20:02 [INFO]: sqs client sucess created
2025-08-14 04:20:03 [INFO]: Number of messages in the queue: 1
2025-08-14 04:20:04 [INFO]: item found in queue is if condition  14409
2025-08-14 04:20:04 [INFO]: item found in queue is  14409
2025-08-14 04:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBC3uqGQoDzdNTv5u9wsLUiJswF8SxOAknLGwbVlZjcsCAAyOJS/qi7yxfmkpaN9fkvFdrfMGRpDP6Reg/IaQuv78/P0Dycjr4Be8+1TPgMoU2TPFWKBZIfw99S8XqkPngd9cqXvfSwgk3mHLvyJBOzMKGgJbIDak4p1L6C74Lw+SlqAy+u+xtOkAbksp9h2XqcmIke5GKHPJfVX1L6EHsWGhq5G2MqLuMxX1aZ93ElidQzAh2F/Uv/z2acexxjpYo64zm8kOgV6v1v7Tlk5yAK3H5R0tQN1/T26Vjo8580qh8DoZcBzd29XM3v5xX0t9Ntai3XSrqKONEGOqyOaPaSBcZf/a/3RHGKx1bcCWeo8k0YpILq8m/Xnk0qFrf+mDx/J5WRDMN7TDsQtMA1xjJwANlyDQ1RBo0kkyHCC76LY4EeulBhxPInn/If7aAET6g
2025-08-14 04:20:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 04:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 04:20:04 [INFO]: inside itemsold and closed 14409
2025-08-14 04:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 04:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-14 04:20:06 [INFO]: Ebay item id :: 256477536597 exists in Database
2025-08-14 04:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 04:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 04:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 04:20:06 [INFO]: in processold action queue is array    for {"44772663":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772663","ebayitemid":"256477536597","shopifyproductid":"8395666948318","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8395666948318","shopifyvariantid":"45145868730590","shopifyinventoryid":"47243738317022","shopifylocationid":"","product_id":"44772663","variant_id":"77681205","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 04:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 04:20:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 04:20:06 [INFO]: Shopify Inventory id 47243738317022
2025-08-14 04:20:06 [INFO]: Shopify Location id 58450641063
2025-08-14 04:20:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 04:20:06 [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-14 04:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 04:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772663 and user_id = 14409 
2025-08-14 04:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681205 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 04:20:06 [INFO]: updateIdsQuantity -> ["77681205"]
2025-08-14 04:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-14 04:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77681205 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77681205 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77681205)
2025-08-14 04:20:06 [INFO]: QUANTITY Updated IDs: 77681205
2025-08-14 04:20:06 [INFO]: Successfully processed data for user 14409
2025-08-14 04:20:06 [INFO]: Execution Started
2025-08-14 04:20:06 [INFO]: Execution Finished
2025-08-14 04:30:01 [INFO]: Execution Started
2025-08-14 04:30:01 [INFO]: old server sucessfully connected
2025-08-14 04:30:01 [INFO]: sqs client sucess created
2025-08-14 04:30:02 [INFO]: Number of messages in the queue: 0
2025-08-14 04:30:22 [INFO]: Execution Started
2025-08-14 04:30:22 [INFO]: Execution Finished
2025-08-14 04:40:01 [INFO]: Execution Started
2025-08-14 04:40:01 [INFO]: old server sucessfully connected
2025-08-14 04:40:01 [INFO]: sqs client sucess created
2025-08-14 04:40:03 [INFO]: Number of messages in the queue: 1
2025-08-14 04:40:03 [INFO]: item found in queue is if condition  14409
2025-08-14 04:40:03 [INFO]: item found in queue is  14409
2025-08-14 04:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBwPPwOfCZdXEkxQT6FU3To/tmFIV9Vi7rzkmd8Br0ZQyhWWQDSwzPCJ/bb4IRELeYKMzi2fUdmlS5oB99O6EB7gNzP3fS41iTh/ONSmXw9SEQ07sSMVOH6mgjY0ts3kf6mZL+IBrhTpzUDBdyZchcRkf1s/yWnGckjLlS/plfzqhZXaNnNpdUkh2muLTdRii2UY8aHyLpb4GVa7AJC2hj0JHNc7yTYwzxAN4O21EX+ENZjgcGPz7bzQbC0jBQyMTyHOz/e9XWF8wFy6oTmvNuM0GJi85g3fcdGgKS4MWclbqNA+KINJ8MI3ul9kf18rGEHLSG2IEHSZE3/ZlqXPqrxnxc/K4rqwRpQOJ8XBPKspGXkKDsII7EOHt+Ws9LwRD79PYoW/1fhnxrhBz6x0yfT2ctRsdkKbp6XU8IKpzRo61tG7E2Stg3g3EJ7Uxadb1W
2025-08-14 04:40:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 04:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 04:40:04 [INFO]: inside itemsold and closed 14409
2025-08-14 04:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 04:40:06 [INFO]: autolink for user_id 14409 is 1
2025-08-14 04:40:06 [INFO]: Ebay item id :: 326690061699 exists in Database
2025-08-14 04:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 04:40:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 04:40:06 [INFO]: in processold action queue is array    for {"45239782":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45239782","ebayitemid":"326690061699","deleted":1}}}
2025-08-14 04:40:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 04:40:06 [INFO]: productIds WHich are having null productid -> [45239782]
2025-08-14 04:40:06 [INFO]: ebayItemIds WHich are not imported-> ["326690061699"]
2025-08-14 04:40:06 [INFO]: Entered in bulkUpdateProducts function
2025-08-14 04:40:06 [INFO]: Transaction started for bulkUpdateProducts
2025-08-14 04:40:06 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45239782)
2025-08-14 04:40:06 [INFO]: Query executed successfully. Affected rows: 0
2025-08-14 04:40:06 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-14 04:40:06 [INFO]: Transaction committed successfully.
2025-08-14 04:40:06 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-14 04:40:06 [INFO]: Successfully processed data for user 14409
2025-08-14 04:40:06 [INFO]: Execution Started
2025-08-14 04:40:06 [INFO]: Execution Finished
2025-08-14 04:50:01 [INFO]: Execution Started
2025-08-14 04:50:01 [INFO]: old server sucessfully connected
2025-08-14 04:50:01 [INFO]: sqs client sucess created
2025-08-14 04:50:03 [INFO]: Number of messages in the queue: 0
2025-08-14 04:50:23 [INFO]: Execution Started
2025-08-14 04:50:23 [INFO]: Execution Finished