2025-08-12 17:00:02 [INFO]: Execution Started 2025-08-12 17:00:02 [INFO]: old server sucessfully connected 2025-08-12 17:00:02 [INFO]: sqs client sucess created 2025-08-12 17:00:03 [INFO]: Number of messages in the queue: 4 2025-08-12 17:00:03 [INFO]: item found in queue is if condition 14409 2025-08-12 17:00:03 [INFO]: item found in queue is 14409 2025-08-12 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBy0YLzuo4X2+zLQ8h/8CUAFawIYnuORTdJLFSMiSK+V9d4GzNbmZx++NGoMNTC3K3ZKLbvx0s/tj/c43EzeEkO+Q/NDGFw3Yk12aGrqDM5egc+UkWlkimN5bBWw1pE/Re/QbwqDZz4BrLV7tCj5cyMlzaGW8KyyMUFn+dbV6+RVKJGfegj+qJTlPeg/kuk+aXbyCFMZU0LUMYLZhYa1jnA+5tgdHCohZiu5KpCPGWT8yGNh8jD3abUKU7iu4OkMt/I+NnebUW7NWzeO87rfWhNa7+58W3DSEV1QswhsEueSx6sJtsIs00Rqp0U2URGl4xSiHPfwZEKe/gyGH4uFvKm0dgT3fCBaihyItV0Bvkg4Kb0XqitFt25uY1FfxcNmxD+6fhqBeBOyEtCtZsCbSI0JSDPOfzcwxLYIwrLOgrtXM2L/jtz8gCZoM25ms1eDLf 2025-08-12 17:00:04 [INFO]: item found in queue is if condition 14409 2025-08-12 17:00:04 [INFO]: item found in queue is 14409 2025-08-12 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBLVOFW3kRfxuZ4oAqJSXSg0bZr4peFOxnYTea7nFq71/7Pq+jJJgPJmlY5QsoX6EmKS73CyxF8EpP51MYouQlAG7/MXigD6y1Z4Wkvz8FU+rP4Bz8VygtqPt57yGvWeNbH4EnT1seCrC5Nyro6YGLFzbTMwRDgmWP3QDR7r1MaYOVmr/mnoBCN5SsEw7/NqWaFA/EFzqy0vI95+lScyPFfC38JvSZ6H8JwEiiWwg5k6mcmclZTGoGOhC4EkKC1Cl9s31dNn6MsgCzRYvxDqe7GfhXCFc9ngUdG5zcgvevpgjpAc9lc2U4wB8zyYJb9NaCTDObA8jcIV5jb5c2iSg8S4hRAmaR7uklbU7fl39sRfd6KkCxLdyv2wSuXfltxW6F5bppEtBYzSUuKf4JEGQXO+6zpgNI707R0xq4liiVoE2pFovA5rmhyMkvAyYP/+X7 2025-08-12 17:00:05 [INFO]: item found in queue is if condition 14409 2025-08-12 17:00:05 [INFO]: item found in queue is 14409 2025-08-12 17:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBRomxGEOCz2nV18VW7wSHtq5lP1rgwKpR9rSqG1f+YJd/+LaRlaxb34P8mteQ/UVqGH7Zz1JeREd9928cNlqaVCGtNwbsd6dSq3hucSzebJh9P+uJ+3sY/OuFFMwp4yCPBdWD3am8PfrCTKEciWT4+EyuK6NHHEFehSS1BZGz8nNMk5N3Jfw1ghrXI5R+3VScHdq8YSU3ats+uF1Q0GuZz7J6dVsQgkqeq/LCYT+CCVyCAiB0dAm9DL+i0H7Q13xUtGwzli/A10EKq8W3zouy0J2kATzq9iCGt3icSprX1Dss6y1H81oIEd9IjWQ2L3SLND8u3fLM3yN2lunJhxfP+fLovX8ajXEenJVyMh1ozGjbe+E+4Mlefyqvlgj2gDa3yAqCY2HMERWYBj+752P9zkoMFPszBLra6tycV5j79wGddElDQW0+5yUuHuIzxNWd 2025-08-12 17:00:05 [INFO]: item found in queue is if condition 14409 2025-08-12 17:00:05 [INFO]: item found in queue is 14409 2025-08-12 17:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnqalcesjEpHwlB201jE6UM7TeOL5pHYE0qf/9zn0rcc4K2ZWv3VbuJyFXboQ9X2qKLBWv0wsa+Bd7zS4sHWL/qMkepANlpUz4PeOh5s2KLAJLbKaGVX3vOxR4CbzBBdO56/Ic2liiKAW1YXZSZX+VYwswSu0Q1sSDcKdEOtETGGTGU/A4cwi28n93TdTzdBBBxFDglreT5DIkhVd3hyVDjfjWA8BnM3zSxhe42dOs3Ult0BrkR7VEDtUsnTB+L+2xLexmBcE/v5GixkhFyu3hnvxStvfuiMoIIFrzud+DaiEAzFSHk1KTZsqE8PY1ZVhnGMOTKGqWO+++CsKA/KiFLIoHyu4L6aOPhWSp8v4PuRVyffKF38gMMUFy7C7GqROqgwZvDDJpp8St9bAzjy/hVFHhPgxwK8SB9BXZQXJN3PFb6b7fEwxU6Xm2mcU6+E2 2025-08-12 17:00:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-12 17:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 17:00:05 [INFO]: inside itemsold and closed 14409 2025-08-12 17:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:00:07 [INFO]: Ebay item id :: 306112753367 exists in Database 2025-08-12 17:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:00:07 [INFO]: inside itemsold and closed 14409 2025-08-12 17:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:00:09 [INFO]: Ebay item id :: 405807863704 exists in Database 2025-08-12 17:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:00:09 [INFO]: inside itemsold and closed 14409 2025-08-12 17:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:00:11 [INFO]: Ebay item id :: 305692604478 exists in Database 2025-08-12 17:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:00:11 [INFO]: inside itemsold and closed 14409 2025-08-12 17:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:00:12 [INFO]: Ebay item id :: 286699004784 exists in Database 2025-08-12 17:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:00:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 17:00:12 [INFO]: in processold action queue is array for {"44571603":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571603","ebayitemid":"306112753367","shopifyproductid":"8817212915934","variants":[{"price":"386.99","quantity":0,"weight":"18","shopifyproductid":"8817212915934","shopifyvariantid":"46289351901406","shopifyinventoryid":"48390275563742","shopifylocationid":"","product_id":"44571603","variant_id":"77464287","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44677480":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677480","ebayitemid":"405807863704","shopifyproductid":"8885219197150","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8885219197150","shopifyvariantid":"46639617769694","shopifyinventoryid":"48742583206110","shopifylocationid":"","product_id":"44677480","variant_id":"77582700","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44590788":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44590788","ebayitemid":"305692604478","shopifyproductid":"8703172542686","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8703172542686","shopifyvariantid":"45953999110366","shopifyinventoryid":"48052599029982","shopifylocationid":"","product_id":"44590788","variant_id":"77483497","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45212237":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45212237","ebayitemid":"286699004784","deleted":1}}} 2025-08-12 17:00:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 17:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:00:13 [INFO]: productIds WHich are having null productid -> [45212237] 2025-08-12 17:00:13 [INFO]: ebayItemIds WHich are not imported-> ["286699004784"] 2025-08-12 17:00:13 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 17:00:13 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 17:00:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45212237) 2025-08-12 17:00:13 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 17:00:13 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 17:00:13 [INFO]: Transaction committed successfully. 2025-08-12 17:00:13 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 17:00:13 [INFO]: Shopify Inventory id 48390275563742 2025-08-12 17:00:13 [INFO]: Shopify Location id 58450641063 2025-08-12 17:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T17:00:13Z","reason":"correction","changes":[{"name":"available","delta":-6},{"name":"on_hand","delta":-6}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 17:00:13 [INFO]: Change: available | Delta: -6 2025-08-12 17:00:13 [INFO]: Change: on_hand | Delta: -6 2025-08-12 17:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571603 and user_id = 14409 2025-08-12 17:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464287 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:00:13 [INFO]: Shopify Inventory id 48742583206110 2025-08-12 17:00:13 [INFO]: Shopify Location id 58450641063 2025-08-12 17:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T17: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 17:00:13 [INFO]: Change: available | Delta: -1 2025-08-12 17:00:13 [INFO]: Change: on_hand | Delta: -1 2025-08-12 17:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677480 and user_id = 14409 2025-08-12 17:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582700 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:00:13 [INFO]: Shopify Inventory id 48052599029982 2025-08-12 17:00:13 [INFO]: Shopify Location id 58450641063 2025-08-12 17:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T17:00:14Z","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 17:00:14 [INFO]: Change: available | Delta: 1 2025-08-12 17:00:14 [INFO]: Change: on_hand | Delta: 1 2025-08-12 17:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44590788 and user_id = 14409 2025-08-12 17:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77483497 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:00:14 [INFO]: updateIdsQuantity -> ["77464287","77582700","77483497"] 2025-08-12 17:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-12 17:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77464287 THEN 0 WHEN id = 77582700 THEN 0 WHEN id = 77483497 THEN 0 END, quantityflag = CASE WHEN id = 77464287 THEN 0 WHEN id = 77582700 THEN 0 WHEN id = 77483497 THEN 0 END WHERE user_id = 14409 AND id IN (77464287,77582700,77483497) 2025-08-12 17:00:14 [INFO]: QUANTITY Updated IDs: 77464287, 77582700, 77483497 2025-08-12 17:00:14 [INFO]: Successfully processed data for user 14409 2025-08-12 17:00:14 [INFO]: Execution Started 2025-08-12 17:00:14 [INFO]: Execution Finished 2025-08-12 17:10:02 [INFO]: Execution Started 2025-08-12 17:10:02 [INFO]: old server sucessfully connected 2025-08-12 17:10:02 [INFO]: sqs client sucess created 2025-08-12 17:10:03 [INFO]: Number of messages in the queue: 1 2025-08-12 17:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 17:10:03 [INFO]: item found in queue is 14409 2025-08-12 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBn71dRidWEVuiK3jpe19Y/AWuttDcz+3OJr3QEx/KLMGt7BbEjMompsGdi6DDoyac5zs+bgJGnG9MKg6LQn19hL6GkWetlS6hFWPxWJMLMzyQ0FicH5nNJCMAl0D8Rh84LuwY9W4X6aVL4mgUQnGyMOFYUCIscXROBrqcFK/Gr+KwN+dW119o85l9reGKfA/XXx1eBEuebmhft7ZSeLZ9DsUouYkTPK9RqUlNVVecAjHhGR1c5QUdX0h4MGw3dvVEif7PfiHBBxGt7Ptw7OpDBkbN70Bqp3SyPZm3IAzj6Hp2Wo83ir5pToyy1YmHMGZD2iTMU8c5ojzz8vTGf3bYSYQcVeH6ZNs6H2iVGhk/ahmjULHpWk90wkhOIp2KqTb5zYbVIXOt2kgsOW3lFydEGa8wFjuDWUZxE4LcXSEdpsl7YbaXwCmbK1dmxNIg34kl 2025-08-12 17:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 17:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 17:10:03 [INFO]: inside itemsold and closed 14409 2025-08-12 17:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:10:05 [INFO]: Ebay item id :: 326337038464 exists in Database 2025-08-12 17:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:10:05 [INFO]: in processold action queue is array for {"44641787":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641787","ebayitemid":"326337038464","shopifyproductid":"8734182605022","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8734182605022","shopifyvariantid":"46042110951646","shopifyinventoryid":"48140816351454","shopifylocationid":"","product_id":"44641787","variant_id":"77546977","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 17:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 17:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:10:05 [INFO]: Shopify Inventory id 48140816351454 2025-08-12 17:10:05 [INFO]: Shopify Location id 58450641063 2025-08-12 17:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T17: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-12 17:10:05 [INFO]: Change: available | Delta: -1 2025-08-12 17:10:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 17:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641787 and user_id = 14409 2025-08-12 17:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77546977 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:10:05 [INFO]: updateIdsQuantity -> ["77546977"] 2025-08-12 17:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 17:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77546977 THEN 0 END, quantityflag = CASE WHEN id = 77546977 THEN 0 END WHERE user_id = 14409 AND id IN (77546977) 2025-08-12 17:10:05 [INFO]: QUANTITY Updated IDs: 77546977 2025-08-12 17:10:05 [INFO]: Successfully processed data for user 14409 2025-08-12 17:10:05 [INFO]: Execution Started 2025-08-12 17:10:05 [INFO]: Execution Finished 2025-08-12 17:20:01 [INFO]: Execution Started 2025-08-12 17:20:01 [INFO]: old server sucessfully connected 2025-08-12 17:20:01 [INFO]: sqs client sucess created 2025-08-12 17:20:02 [INFO]: Number of messages in the queue: 2 2025-08-12 17:20:02 [INFO]: item found in queue is if condition 14409 2025-08-12 17:20:02 [INFO]: item found in queue is 14409 2025-08-12 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBfioV5HHgZnFVgnTIvdaOnXe5gt0OgiPxE/nd6r+72QeQkOP0BqS7DkFQVQ2PVqzFRtTf6oMu2jXNMohXM09IuIBNKDzxuA6Dfypz+p82A08XvvHKgiz32EPxqnrRx1+sTZRuvDiEFn1dYYwBt1l5Aq7FLvjt4huGYR5UPdG22kOV/FGXKd2x5c52MUlz3Q9x8kOnwtB7YODykBvJg3XR0fgUdaXfBNThJev1ESXoOAudNUgT2Fxt5spc5Xl45fyz24NABWUuuoET5WA9a6odGnvLryUoMjTyklsIkwOUqJLj9xVfGwi0ewWmHlY8+yEi6TMg7GAZjn9Z7keHY8yrT2yk50EHfTcSMRUpGZ9pnz1kVLjRG7NzViFl6xoZjBcXHM6U4w5X74FdAFsu3oz0IPQL6qIrqL9+e6vzz5GO3SfsrQ2XYztjpKhUGSi8SgpB 2025-08-12 17:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 17:20:03 [INFO]: item found in queue is 14409 2025-08-12 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBM67AfOaVLzqwxcoUv919FRtyhqi5tT18hdDvbeZomZDLDcoz3cslYt2wlRKobVeLY14jrxD+w3l8HXNvdVYM0e48Vi2YnbU4hFpjpRQln2N+ZS7alnU5SeJVtw+5rsP/OoRwlhfVHps4lS98g6YP6Top79d9IlcuhL+uxpbtRJs+ZVJzPQ6uS4F+8wL6XAaCpB9BHb8DPrj5MUy3iyeR/SRsAo1QhZxXKl0ugIiK9g3JdGuj/zS6rD+Qc/A0C5ng6qFuas5Ru4mlPgZ4cTNgMz8fdOeVBaz4yc8D0FnldwAyzpVhffdjnrdn7v3VrciWTCbQS/66NfC81ViLEly4JvsME3OfgddY0O6HcMkYb7tNcO4sRQuQ0MeTKY5HkQixCFSnfiV9yd9M/Puuv70O+bIGIws1QGNIr5ZyeoZnOyc8xKW3hRS3rfkCB0DKp3I1 2025-08-12 17:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 17:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 17:20:03 [INFO]: inside itemsold and closed 14409 2025-08-12 17:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:20:05 [INFO]: Ebay item id :: 225256398591 exists in Database 2025-08-12 17:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:20:05 [INFO]: inside itemsold and closed 14409 2025-08-12 17:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:20:06 [INFO]: Ebay item id :: 285743401160 exists in Database 2025-08-12 17:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:20:06 [INFO]: in processold action queue is array for {"44653626":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653626","ebayitemid":"225256398591","shopifyproductid":"8920576262366","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8920576262366","shopifyvariantid":"46782486839518","shopifyinventoryid":"48881000874206","shopifylocationid":"58450641063","product_id":"44653626","variant_id":"77558815","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554441":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554441","ebayitemid":"285743401160","shopifyproductid":"8303431287006","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8303431287006","shopifyvariantid":"44852140605662","shopifyinventoryid":"46950184943838","shopifylocationid":"","product_id":"44554441","variant_id":"77447121","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 17:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:20:07 [INFO]: Shopify Inventory id 48881000874206 2025-08-12 17:20:07 [INFO]: Shopify Location id 58450641063 2025-08-12 17:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17: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 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653626 and user_id = 14409 2025-08-12 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558815 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:20:07 [INFO]: Shopify Inventory id 46950184943838 2025-08-12 17:20:07 [INFO]: Shopify Location id 58450641063 2025-08-12 17:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17: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 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554441 and user_id = 14409 2025-08-12 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447121 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:20:07 [INFO]: updateIdsQuantity -> ["77558815","77447121"] 2025-08-12 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77558815 THEN 0 WHEN id = 77447121 THEN 0 END, quantityflag = CASE WHEN id = 77558815 THEN 0 WHEN id = 77447121 THEN 0 END WHERE user_id = 14409 AND id IN (77558815,77447121) 2025-08-12 17:20:07 [INFO]: QUANTITY Updated IDs: 77558815, 77447121 2025-08-12 17:20:07 [INFO]: Successfully processed data for user 14409 2025-08-12 17:20:07 [INFO]: Execution Started 2025-08-12 17:20:07 [INFO]: Execution Finished 2025-08-12 17:30:02 [INFO]: Execution Started 2025-08-12 17:30:02 [INFO]: old server sucessfully connected 2025-08-12 17:30:02 [INFO]: sqs client sucess created 2025-08-12 17:30:03 [INFO]: Number of messages in the queue: 5 2025-08-12 17:30:04 [INFO]: item found in queue is if condition 14409 2025-08-12 17:30:04 [INFO]: item found in queue is 14409 2025-08-12 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBotjs7U2751XLkCchlJ8cdLV1LdMEbEA4qCww7FQ2dmVsNaeU3lePgya531j737FzV0xq6EFvKebCELFtFJv/UIYqQXzvnO3i4Vv4YsnA0RniopPL76qSIMwb/uxNewoMHFxdkZto3CmTOyCvXM+T5PmeAelMOgeicPvnWWs5ykXT73SnUSvmRzAwkcZdfBl9dEtCqKfAi8xexySCLWUyN4iX/avtKHROXvZf254qDQnTyggaOdaU98XQH33y6s2nnOGAXW6fhiY9D9tmF5M/t/xVyh9cjN5vXsSMsT92tje21QWpDgq/zip3TUT6TscDW0/uhjjdcMvT9TqAkInNU4SgSiZDQt+ZxAVCbkA0CipJG5xqrxkImktAi/OPrFT8cixcwbR6DbuOrH0ZpAo0Qypbv43uQ/gkk8SmQHvgh1/3TSPH9QMAjfFjRBrYOODJ 2025-08-12 17:30:04 [INFO]: item found in queue is if condition 14409 2025-08-12 17:30:04 [INFO]: item found in queue is 14409 2025-08-12 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB2cQ9Y4rFYWLYW7r93YgQrKIRS3E2s+YMMfl4d7TYS7FJHakNIvojLY21/RYd0RpQrN1pNhD9SOCcUxscMZLQ0P+fg+uD0Dwv2pKlYIp3KBSMP8ZWXYGVOmO9UKG8WJz73a2wi5pugvSCD3d4K0aOAbvOHLEoNaRjiqwo0TO6TMdfORT2AfIqsjqRa/KCTSQGIamuZSqcYSH8rijN2fes74PtwszLUKJF/8l2lkBJfiwiAoTF/TFaIjN6fHFQGZ9vu7xZY4Keo9leEL2hMsLKdSUywi+TE6nyhwYJVRB0QSWZMA/7/FUYj2lLKJjY58aQP7gW+JxAnyx8mPbsfxsaXkZ8iXqk6LWs/D1LF6WW/ks1C+HASijlfqBP75FzgTUOuNXWHZ5WqFpzUp7iSqyvBlqZ9aK3VyZojAuSTk1g6Ml97EXSROuMEk1MpOTGUMsC 2025-08-12 17:30:04 [INFO]: item found in queue is if condition 14409 2025-08-12 17:30:04 [INFO]: item found in queue is 14409 2025-08-12 17:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnIRq7EIUzcR66HmFRka871mSpUzEOoRIKtgwi3hiIBC/8Ax19NzGDc5ySDGDsxJJ66m0KkpDRLLn5FYnfiinw03zb9LoMW/n4wKtxBIhR4nBX7t8NErXjqlNHlkJjeBdkb+Ob3hS2kHx3xdGV9zlzC8cg5PAPxYxjv2B08IHy//g1Cfdc6EY2DlgY9uQRmPWtbkjocEVqu0uuvi27i8ML7MdLQ0KEMBwW9J/lBu0wPgykaK6/RULcsSDX5JWSO381A8inth7BLQUmUmEtl6tG9fOxoRxqvEFgvkrFAawGowHTHeS64n0sWurBP10UsMGWFubfzDCsDTePbbVJ2gbrMSYnkJoSCIn7s/jYkva8Kb6Pv+CzBKRq28D9peueRozM0iOBvokDLLa+OLDU6dU9/RF/EFnJWYUle1lLmvN9vVzWao2uCp0ChfQCXz1+k98 2025-08-12 17:30:05 [INFO]: item found in queue is if condition 14409 2025-08-12 17:30:05 [INFO]: item found in queue is 14409 2025-08-12 17:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBIezlvcKQGhCfaNocYDGPEcaiXYUNLpbTBgQ4AiMgKCGdNyHEfeDkJ/elzZo7ytZr1KyQbVaHVni2iwQ86jmnUluA56VMTmi4Mi0Dvn6gwQSCe6TWCLGBli+xfUFOqnDm/Hbxj+tGNLwgLda+msPozsGSaBIRBwy2g5bZffvUcJn9YOJHUSgOcakLHk428WradXHjI6pak+UXz9zco6eUoSDZgdfEvJWQFJVsOGi34xb1ls/isfn5J85LW1QP1Lvaqrjo2UDSX2LK7uecV3EJryJXyFlzZyuIQe3sxGb3kSsDCcltCOTDgDMhXhrumHNIujYP/y48qAzOsa9bwAtqEZCbA2pGdQNoOaMkPV4FDNAaIuakpnqMOnQhUCBm/VjtnjbXGidMuIZwyOi9u1gDtL5hFdPb6j1zuTLnn4rOH7RrJKwVHJjbCF5i9LYkwuBM 2025-08-12 17:30:05 [INFO]: item found in queue is if condition 14409 2025-08-12 17:30:05 [INFO]: item found in queue is 14409 2025-08-12 17:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEB1mXAjuhchaYIqT9GjbrwtBx4xIoXjtJuC6giOwPWolDgqdt830t6lTeAkQYeyJUpBZWg9dljGVNsbKySvXI6CbvKHy5iMPT5E9pCSt20DszzQOBGvdUMv5H5+MBtkuRbUVShd52vITIRm3zhSgkVe3nlNxeM+RZ6fM4MhUWdrBBv4XslV5yZbXJJN1V98q71+uycRYXEcRI0nRY5VLi7tQetSBzADg0AtFPh1jZPbfuP3R9uru3RBoRDj8klJexLCnt0w+T72I9fKPXXLLFL3OQX3Mylwycm7ehi5Yc/AYYuvbkb4m51LBiWK2gMsRDkNec6u0pxK9GZ5aK0iDEZq3RL7ADGoVNvK1uek4vO01+Z/VsWGqcHNbVnyESw7049UP+CczaMISjfKtjx+sxeKRfk66WwUBxOfGun24eo0/WCbwPaAnLaVQZTAlzKOqQw 2025-08-12 17:30:06 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-12 17:30:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 17:30:06 [INFO]: inside itemsold and closed 14409 2025-08-12 17:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:30:07 [INFO]: Ebay item id :: 405837393822 exists in Database 2025-08-12 17:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:30:07 [INFO]: inside itemsold and closed 14409 2025-08-12 17:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:30:09 [INFO]: Ebay item id :: 326350616765 exists in Database 2025-08-12 17:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:30:09 [INFO]: inside itemsold and closed 14409 2025-08-12 17:30:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:30:11 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:30:11 [INFO]: Ebay item id :: 286088495359 exists in Database 2025-08-12 17:30:11 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:30:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 17:30:11 [INFO]: inside itemsold and closed 14409 2025-08-12 17:30:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:30:13 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:30:13 [INFO]: Ebay item id :: 286740469895 exists in Database 2025-08-12 17:30:13 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:30:13 [INFO]: inside itemsold and closed 14409 2025-08-12 17:30:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:30:15 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:30:15 [INFO]: Ebay item id :: 326656246226 exists in Database 2025-08-12 17:30:15 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:30:15 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 17:30:15 [INFO]: in processold action queue is array for {"44798120":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44798120","ebayitemid":"405837393822","shopifyproductid":"8003225944286","variants":[{"price":"15.99","quantity":0,"weight":"0.5","shopifyproductid":"8003225944286","shopifyvariantid":"44122056753374","shopifyinventoryid":"46218918199518","shopifylocationid":"","product_id":"44798120","variant_id":"77708537","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674074":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674074","ebayitemid":"326350616765","shopifyproductid":"8028593455326","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8028593455326","shopifyvariantid":"44164497866974","shopifyinventoryid":"46261482914014","shopifylocationid":"","product_id":"44674074","variant_id":"77579294","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45141059":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45141059","ebayitemid":"286088495359","deleted":1}},"45312889":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45312889","ebayitemid":"286740469895","shopifyproductid":"8976163406046","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8976163406046","shopifyvariantid":"47182699692254","shopifyinventoryid":"49294535983326","shopifylocationid":"58450641063","product_id":"45312889","variant_id":"78265402","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45156915":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45156915","ebayitemid":"326656246226","deleted":1}}} 2025-08-12 17:30:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 17:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:30:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:30:15 [INFO]: productIds WHich are having null productid -> [45141059,45156915] 2025-08-12 17:30:15 [INFO]: ebayItemIds WHich are not imported-> ["286088495359","326656246226"] 2025-08-12 17:30:15 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 17:30:15 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 17:30:15 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45141059,45156915) 2025-08-12 17:30:15 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 17:30:15 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 17:30:15 [INFO]: Transaction committed successfully. 2025-08-12 17:30:15 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 17:30:15 [INFO]: Shopify Inventory id 46218918199518 2025-08-12 17:30:15 [INFO]: Shopify Location id 58450641063 2025-08-12 17:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:30: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-12 17:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44798120 and user_id = 14409 2025-08-12 17:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77708537 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:30:15 [INFO]: Shopify Inventory id 46261482914014 2025-08-12 17:30:15 [INFO]: Shopify Location id 58450641063 2025-08-12 17:30:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:30:16 [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 17:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674074 and user_id = 14409 2025-08-12 17:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579294 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:30:16 [INFO]: Shopify Inventory id 49294535983326 2025-08-12 17:30:16 [INFO]: Shopify Location id 58450641063 2025-08-12 17:30:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T17:30:16Z","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 17:30:16 [INFO]: Change: available | Delta: -1 2025-08-12 17:30:16 [INFO]: Change: on_hand | Delta: -1 2025-08-12 17:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45312889 and user_id = 14409 2025-08-12 17:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265402 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:30:16 [INFO]: updateIdsQuantity -> ["77708537","77579294","78265402"] 2025-08-12 17:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-12 17:30:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77708537 THEN 0 WHEN id = 77579294 THEN 0 WHEN id = 78265402 THEN 0 END, quantityflag = CASE WHEN id = 77708537 THEN 0 WHEN id = 77579294 THEN 0 WHEN id = 78265402 THEN 0 END WHERE user_id = 14409 AND id IN (77708537,77579294,78265402) 2025-08-12 17:30:16 [INFO]: QUANTITY Updated IDs: 77708537, 77579294, 78265402 2025-08-12 17:30:16 [INFO]: Successfully processed data for user 14409 2025-08-12 17:30:16 [INFO]: Execution Started 2025-08-12 17:30:16 [INFO]: Execution Finished 2025-08-12 17:40:01 [INFO]: Execution Started 2025-08-12 17:40:01 [INFO]: old server sucessfully connected 2025-08-12 17:40:01 [INFO]: sqs client sucess created 2025-08-12 17:40:02 [INFO]: Number of messages in the queue: 1 2025-08-12 17:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 17:40:03 [INFO]: item found in queue is 14409 2025-08-12 17:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBv2//K1gEfIOwlBl8hBV1x3R/ATukS5T9+JwOBDEATJB0xSRmndCwy7diMX4EKI9/3LFwlP17YZUG98qbcwKVMOfOPsu7Rqt5B3KVIRT8Mp+6S9vNlcsH4d1+k0GKB7SU1R/sq0IbcdzsYHwKTsu9x/VYsPcF+YI0E3zBxmP1eoxx6BJMZ3QQaselbZO1ktOoL0rw5Yg/+IU+7EEJEMI7L60t/yKPpYu0Rc5kvNUp90JzZTNcwMWOKFBQWwsMvKvLnSDgce8WCsNwTJWTmYPPDqIdqDGrbXTfaPNb7hOX7XG5OOo8h9rFaVJPEa7bN5uGfuto/cdCSvcDFzATw8Wes99TOy7K4OTOSsY7zFdr5U2Kf8SP6dtA5b04/3iddkqaX/ZkeRx05jkMxYeRrcvkBDpSfXG/Vu2egjrosLPGn2U3aDYBTujcMcsi5XCFnM7J 2025-08-12 17:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 17:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 17:40:03 [INFO]: inside itemsold and closed 14409 2025-08-12 17:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:40:05 [INFO]: Ebay item id :: 305900631653 exists in Database 2025-08-12 17:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:40:05 [INFO]: in processold action queue is array for {"44568141":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44568141","ebayitemid":"305900631653","shopifyproductid":"7998591008990","variants":[{"price":"15.99","quantity":0,"weight":"2","shopifyproductid":"7998591008990","shopifyvariantid":"44103750942942","shopifyinventoryid":"46200599150814","shopifylocationid":"","product_id":"44568141","variant_id":"77460825","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 17:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 17:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:40:05 [INFO]: Shopify Inventory id 46200599150814 2025-08-12 17:40:05 [INFO]: Shopify Location id 58450641063 2025-08-12 17:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:40:05 [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 17:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44568141 and user_id = 14409 2025-08-12 17:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77460825 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:40:05 [INFO]: updateIdsQuantity -> ["77460825"] 2025-08-12 17:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 17:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77460825 THEN 0 END, quantityflag = CASE WHEN id = 77460825 THEN 0 END WHERE user_id = 14409 AND id IN (77460825) 2025-08-12 17:40:05 [INFO]: QUANTITY Updated IDs: 77460825 2025-08-12 17:40:05 [INFO]: Successfully processed data for user 14409 2025-08-12 17:40:05 [INFO]: Execution Started 2025-08-12 17:40:05 [INFO]: Execution Finished 2025-08-12 17:50:02 [INFO]: Execution Started 2025-08-12 17:50:02 [INFO]: old server sucessfully connected 2025-08-12 17:50:02 [INFO]: sqs client sucess created 2025-08-12 17:50:03 [INFO]: Number of messages in the queue: 2 2025-08-12 17:50:03 [INFO]: item found in queue is if condition 14409 2025-08-12 17:50:03 [INFO]: item found in queue is 14409 2025-08-12 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHVUvtnQ5DziE+yWZCMC3eIwMOtr52Gafp5y9PZlxfoWem12xoloXHTpRyENcbAyK/zc+1NWdYdSBtidd8H4W48+zUpa8Jg0LFCr2mPBCYtnQGM0QyWQjEthoYmKMKtXMWoVHdnileA/zD6FX7xsNpDduw4mfplw51Fk5LhooNnTIbEyBh91R8GC3sgCWR4vUrOS+6IxU4k+SkFwUJcIlMQQBmBZ1elDPSZq09IsF3MvVazprABL+RcEGeQyHJhZj3ryuD3nAFGWBsl82CuFYgCwYQAMw1cPfvEfE7HCvFH61zmqXkFrJBh5bTP4sjsQIzgI8Wyp9OUgmFzufa3adnl8P9jQjR39hFvMnNQZoDT31uKKP7Ew7BMMc1i69INllkYHJ7aN5Dvo5giZfOFoY7OlsHfhKxWLgofERIGtVlc1WS+rIZnFgMhQ0pinNn5Im 2025-08-12 17:50:04 [INFO]: item found in queue is if condition 14409 2025-08-12 17:50:04 [INFO]: item found in queue is 14409 2025-08-12 17:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvQx0AptOjZG1Oxhwuc4F+qI3rhz9YeIvmV6rhnZcd03hNTp1SQUah7Izn6/dq0vOSAEfNyrxTifOnGRnuSuDDO29cii2W9gckejISr/Mh8wsZJ3cv2i4lw7tFYEmSxYYkTY2g9hmap3FRqARr9sKltvoDMzgRd0vCzTXu46WqFc553WSmBp7AnopPx7Pb1HfObWhU49BvM35BiWiGoSU+7wpFYtWFvzBMg5AXjobzUU8r1PIBUnbWsIh0Gsff71KKNCh8/ishucT3vKLW9kHRznLO+FzfrCNQ4zufcaz/59YUfHiTsqOTvtlixyN6FD/58bCDrB5y4sjAApUZ/vcVsCMhn71c1i4qnKNsaYWbZM0eY5qwIAjcW8hz+UZG3Y6+h94sHOlbIoWTYRpSd/08vqNgETW9OwSXzOev2OkHDKFrNn0PW4PoiUqZ6V+CPD9 2025-08-12 17:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 17:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 17:50:04 [INFO]: inside itemsold and closed 14409 2025-08-12 17:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:50:06 [INFO]: Ebay item id :: 286476226323 exists in Database 2025-08-12 17:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:50:06 [INFO]: inside itemsold and closed 14409 2025-08-12 17:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 17:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 17:50:07 [INFO]: Ebay item id :: 286097819121 exists in Database 2025-08-12 17:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 17:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 17:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 17:50:07 [INFO]: in processold action queue is array for {"44566180":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566180","ebayitemid":"286476226323","shopifyproductid":"8872253161694","variants":[{"price":"99.99","quantity":0,"weight":"3","shopifyproductid":"8872253161694","shopifyvariantid":"46599115538654","shopifyinventoryid":"48701929095390","shopifylocationid":"","product_id":"44566180","variant_id":"77458860","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44775963":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775963","ebayitemid":"286097819121","shopifyproductid":"8019821396190","variants":[{"price":"13.99","quantity":0,"weight":"2","shopifyproductid":"8019821396190","shopifyvariantid":"44149763571934","shopifyinventoryid":"46246726598878","shopifylocationid":"","product_id":"44775963","variant_id":"77684505","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 17:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 17:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 17:50:07 [INFO]: Shopify Inventory id 48701929095390 2025-08-12 17:50:07 [INFO]: Shopify Location id 58450641063 2025-08-12 17:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T17:50: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-12 17:50:08 [INFO]: Change: available | Delta: -1 2025-08-12 17:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-12 17:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566180 and user_id = 14409 2025-08-12 17:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458860 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:50:08 [INFO]: Shopify Inventory id 46246726598878 2025-08-12 17:50:08 [INFO]: Shopify Location id 58450641063 2025-08-12 17:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 17:50:08 [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 17:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 17:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775963 and user_id = 14409 2025-08-12 17:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684505 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 17:50:08 [INFO]: updateIdsQuantity -> ["77458860","77684505"] 2025-08-12 17:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 17:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77458860 THEN 0 WHEN id = 77684505 THEN 0 END, quantityflag = CASE WHEN id = 77458860 THEN 0 WHEN id = 77684505 THEN 0 END WHERE user_id = 14409 AND id IN (77458860,77684505) 2025-08-12 17:50:08 [INFO]: QUANTITY Updated IDs: 77458860, 77684505 2025-08-12 17:50:08 [INFO]: Successfully processed data for user 14409 2025-08-12 17:50:08 [INFO]: Execution Started 2025-08-12 17:50:08 [INFO]: Execution Finished