2025-08-05 03:00:02 [INFO]: Execution Started 2025-08-05 03:00:02 [INFO]: old server sucessfully connected 2025-08-05 03:00:02 [INFO]: sqs client sucess created 2025-08-05 03:00:03 [INFO]: Number of messages in the queue: 1 2025-08-05 03:00:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:00:03 [INFO]: item found in queue is 14409 2025-08-05 03:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxKE4tNfzRbhHDmn9IMvV7WPBEp39GPcKisLijK1YXTkRdTQNun64tp2WeJqNwRydCGI7yDlqedm5zLhZucOQs3m3ywOa15M27FGiAalSIhcCiwSeKZbjaq9j0OsC7yB2NdONzEmSrdcPJULj4RfYarU8khY4S7xck5BKJ77Dr/VB6Pdg8KN3HAnDmcaa5gpB7yrhaqRAbvrMNMp1amPwfSL2zHLWTgptL6oDnkK6stpgwZYFVcOI5D2jWoKeeMFVfPMyr2T5yERxpD0BUY6492y6IFQkjDPBJ1V05kyaVjT/iWgBPkXfkr6AlKbl5MwWi/ouuRPCw/BOmxM7UUn+fAm5Haeh2EF/PjCNeU1kzo9JJQuQ48gn/J5w5dZ+kIPIxBDadFMz2cWavgAMn18XnSNJDUBA/ACmmgrOrUqanFK9sWIH9WxIYvuhwhjg6ZBL 2025-08-05 03:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 03:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 03:00:03 [INFO]: inside itemsold and closed 14409 2025-08-05 03:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:00:06 [INFO]: Ebay item id :: 285741389397 exists in Database 2025-08-05 03:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:00:06 [INFO]: in processold action queue is array for {"44771847":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771847","ebayitemid":"285741389397","shopifyproductid":"8303401107678","variants":[{"price":"44.99","quantity":0,"weight":"3","shopifyproductid":"8303401107678","shopifyvariantid":"44852048298206","shopifyinventoryid":"46950092636382","shopifylocationid":"","product_id":"44771847","variant_id":"77680389","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 03:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 03:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:00:06 [INFO]: Shopify Inventory id 46950092636382 2025-08-05 03:00:06 [INFO]: Shopify Location id 58450641063 2025-08-05 03:00:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:00:06Z","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-05 03:00:06 [INFO]: Change: available | Delta: -1 2025-08-05 03:00:06 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771847 and user_id = 14409 2025-08-05 03:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680389 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:00:06 [INFO]: updateIdsQuantity -> ["77680389"] 2025-08-05 03:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 03:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680389 THEN 0 END, quantityflag = CASE WHEN id = 77680389 THEN 0 END WHERE user_id = 14409 AND id IN (77680389) 2025-08-05 03:00:06 [INFO]: QUANTITY Updated IDs: 77680389 2025-08-05 03:00:06 [INFO]: Successfully processed data for user 14409 2025-08-05 03:00:06 [INFO]: Execution Started 2025-08-05 03:00:06 [INFO]: Execution Finished 2025-08-05 03:10:01 [INFO]: Execution Started 2025-08-05 03:10:01 [INFO]: old server sucessfully connected 2025-08-05 03:10:01 [INFO]: sqs client sucess created 2025-08-05 03:10:02 [INFO]: Number of messages in the queue: 4 2025-08-05 03:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:10:03 [INFO]: item found in queue is 14409 2025-08-05 03:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBqDVzQvO1kSVqOPUShuM2ozyxsJcBo4FEFKfbx/edH0RZhSritcXu4v1/LKJSX3EBeSEF4vtVeDs8763v/1hCX0GjS2iwskQaoOrIZjqSNmqXcHQhHWGasy8d7p9ktAOs2hjLqbREfgZ/q9wVd1lceGcsLs90hm9GIVWtT4P9P1iDk3kWHsQ0tUDZkHSuf3mjZvaPck6YdEdJUnWkNEgg+cdJb46Ux/k5Vjgwvl50e+s11cwL0LF84SpbDuGHvC/8DFxsH0lJd9sbc1igygfu5HGdO79Ovm7AfTNBxI/N5Fpht8P3BanzLOv48vphCgJ1P15fHoqrSKDbItOO5v89vQ8N4joDM66p95XrqR7MLfzne8i6F0sdh8OWLFh5UEmk3CShWyUxys+CphufGI/ltBUDPrNMm/s5kFhhey9t4yQxsnleXeIgXscCxzJ1IAXP 2025-08-05 03:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:10:03 [INFO]: item found in queue is 14409 2025-08-05 03:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBkgZ/cDvHOaL2SafnRytp4OhJSIenChdVHRFR7CZUBA2OP5gsupaSKZVhCLRSy4fduzBDZS//vUkUhU9wO9wBBBI7dGlGl759nhamL6jUC52crYRGJaC34FACVJBKz6lxVDKgpaMxs22S+rOitQrlTmxbY1UNVgfbYaZ6l66T6sjoiiJn4xo+DmKh4v0GGcd2s4Vo/eReN4A8CllBa74srxfH/xjyBLNsgFVNIpuPrrCKSQfsE1JtPxXSkIer6b5NHdV3Yn7sLpFwBAN0tHXjoi3hxo9mmQr8ymv3q8oYhz89Cmfx5ipva58jfDCXI4xQJm6XKM8Z8Nw+arMdYZeoxk2shrHMMOYI2JNAvfGrRCKrJPlB2xHa7fGGZWIvnF/uazhuQMk53EQtW6z6yeoBTeWDLIcyPzXnenegY12to6my2XmNQ0Jv6A7MnsS8/z9M 2025-08-05 03:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 03:10:04 [INFO]: item found in queue is 14409 2025-08-05 03:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBthwE9uVWwOWMKHVgf44/oT41spZxzTmZ4mhMjlUBLh3iXKztsmOVLS6RFTABMAewTj9m+OqNhPzn9lwj72APrdXcOddofF839opPM0XHQEV0G4D4AJTqRvY3Vi4USxhvUcOHRJvQwUImR1BYIUiHyZLqUZHnRfj/CCT7s/hbK/iZpm7pjJE8zoVmrl4Y+3wxSMtavnHuqm6PaaNQxkAa9gtjZRtcHdQg0u7pViwuuQ6uo7rt30oJ1PkJqie6ConyyaESamrkX6gWRnE8eKTpMRZMeftZ/TWqcAYpXNB9aVsCXVVgebL2NwKvDvPjEIsNcO49kNWi1r4OogNwSSKrMM3cLjd/OD96e5Br3Ki4u8GLbhQ2tMC7JpeMS4HZdVSF+JAXjG/3yB/z+YlC6EOL1BxxRsG7wWM8Jvpn5x7lP58PtfM175s6vHsERkHfOJDO 2025-08-05 03:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 03:10:04 [INFO]: item found in queue is 14409 2025-08-05 03:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBLMaRXUbgSLQk+Z67RkFNmFinTPuEVIYYY9h536ex2/dWXskXpKLyyebtQv4JACLZB8zvbefYGF+EdOwVZUEQGGqMxc3zMMk3QlWcwzsknhwEPeF6BgLW6lAEsdamOXJSwaU6B1GccHckN6dftqmK2oLOL5TYf/AZkxF5y83N5zIAY8gmNKFMC3iKdIftZdGMc8QGy/loSbwNxi7hsUXv3i0eKJAv9S0hk+kv0M5TotNe3Nr/o/Yguo46SHOrlnH8bSj6TfclwyKXOSHFvWmk7qO8bmQKzoCYNIWn6ib/NPFsm7bKk89TG/7bQvD+NmVx5qYARbmU/dC/kyUfcPUtHodD2bCNvDJplF/blhHoViHvhgd8vFFS/IEiEpug/fF5dgDjA4i4qZfR8l+l/mn/H3P7l/zR6iLiyoyEY5+9E4irpcLOjzplyXye2XaPwam+ 2025-08-05 03:10:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 03:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 03:10:05 [INFO]: inside itemsold and closed 14409 2025-08-05 03:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:10:06 [INFO]: Ebay item id :: 404838056717 exists in Database 2025-08-05 03:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:10:06 [INFO]: inside itemsold and closed 14409 2025-08-05 03:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:10:08 [INFO]: Ebay item id :: 285751192782 exists in Database 2025-08-05 03:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:10:08 [INFO]: inside itemsold and closed 14409 2025-08-05 03:10:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:10:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:10:10 [INFO]: Ebay item id :: 256420304363 exists in Database 2025-08-05 03:10:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:10:10 [INFO]: inside itemsold and closed 14409 2025-08-05 03:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:10:11 [INFO]: Ebay item id :: 256436797074 exists in Database 2025-08-05 03:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:10:11 [INFO]: in processold action queue is array for {"44771865":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771865","ebayitemid":"404838056717","shopifyproductid":"8303340060894","variants":[{"price":"72.99","quantity":0,"weight":"3","shopifyproductid":"8303340060894","shopifyvariantid":"44851910377694","shopifyinventoryid":"46949954748638","shopifylocationid":"","product_id":"44771865","variant_id":"77680407","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772080":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772080","ebayitemid":"285751192782","shopifyproductid":"8307632242910","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8307632242910","shopifyvariantid":"44865727103198","shopifyinventoryid":"46963775045854","shopifylocationid":"","product_id":"44772080","variant_id":"77680622","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44690452":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44690452","ebayitemid":"256420304363","shopifyproductid":"8696048517342","variants":[{"price":"72.99","quantity":0,"weight":"3","shopifyproductid":"8696048517342","shopifyvariantid":"45936017342686","shopifyinventoryid":"48034465579230","shopifylocationid":"","product_id":"44690452","variant_id":"77595704","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772034":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772034","ebayitemid":"256436797074","shopifyproductid":"8306704056542","variants":[{"price":"66.99","quantity":0,"weight":"2","shopifyproductid":"8306704056542","shopifyvariantid":"44861881712862","shopifyinventoryid":"46959931621598","shopifylocationid":"","product_id":"44772034","variant_id":"77680576","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 03:10:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 03:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:10:12 [INFO]: Shopify Inventory id 46949954748638 2025-08-05 03:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:10:12Z","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-05 03:10:12 [INFO]: Change: available | Delta: -1 2025-08-05 03:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771865 and user_id = 14409 2025-08-05 03:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680407 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:10:12 [INFO]: Shopify Inventory id 46963775045854 2025-08-05 03:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:10:12Z","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-05 03:10:12 [INFO]: Change: available | Delta: -1 2025-08-05 03:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772080 and user_id = 14409 2025-08-05 03:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680622 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:10:12 [INFO]: Shopify Inventory id 48034465579230 2025-08-05 03:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:10:12Z","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-05 03:10:12 [INFO]: Change: available | Delta: -1 2025-08-05 03:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44690452 and user_id = 14409 2025-08-05 03:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77595704 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:10:12 [INFO]: Shopify Inventory id 46959931621598 2025-08-05 03:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 03:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:10:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:10: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-05 03:10:13 [INFO]: Change: available | Delta: -1 2025-08-05 03:10:13 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772034 and user_id = 14409 2025-08-05 03:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680576 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:10:13 [INFO]: updateIdsQuantity -> ["77680407","77680622","77595704","77680576"] 2025-08-05 03:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-05 03:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680407 THEN 0 WHEN id = 77680622 THEN 0 WHEN id = 77595704 THEN 0 WHEN id = 77680576 THEN 0 END, quantityflag = CASE WHEN id = 77680407 THEN 0 WHEN id = 77680622 THEN 0 WHEN id = 77595704 THEN 0 WHEN id = 77680576 THEN 0 END WHERE user_id = 14409 AND id IN (77680407,77680622,77595704,77680576) 2025-08-05 03:10:13 [INFO]: QUANTITY Updated IDs: 77680407, 77680622, 77595704, 77680576 2025-08-05 03:10:13 [INFO]: Successfully processed data for user 14409 2025-08-05 03:10:13 [INFO]: Execution Started 2025-08-05 03:10:13 [INFO]: Execution Finished 2025-08-05 03:20:02 [INFO]: Execution Started 2025-08-05 03:20:02 [INFO]: old server sucessfully connected 2025-08-05 03:20:02 [INFO]: sqs client sucess created 2025-08-05 03:20:03 [INFO]: Number of messages in the queue: 1 2025-08-05 03:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:20:03 [INFO]: item found in queue is 14409 2025-08-05 03:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBcoJRpv91wdHFHY/69ODcVrqTNCuA7U38N+TbUGwk81YsC2SUuN2SY0g7jUvqq30M0Ma1Vnn3QxaDJmhG7SzbeGXu9uAtLa0dLLlOmW1FnnAXM0LGG7G0K5CnGvklnfNULwp5z1w36rpybQyfe70WWvHu+3N2K3FIQjecCWcyPRvmdDgIr32IcMI81oRNFnLqtXW861ZDd5N1V70wrLX9QYwAOgF2hDwIpxVyLW6b5vWcMP227W05mREsPX6A9wOsV1uI5n8UNNQcJAF9/nj8OnrNJ0GSzYhFPX5/BR9W94XtOnKx+Enj9PY2r1FNrGKf+bdI3eDctLaSpE/DAeUN7QyfciOZpFx3YRiyETjjrCw9kUbwsixoLFuv4gMEsyJt67Xa07HHK4a8GJxf4RE+6Uovaq0O6bRAjqoXy5IJBIalQikPbyKZtammvcEnAP/h 2025-08-05 03:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 03:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 03:20:03 [INFO]: inside itemsold and closed 14409 2025-08-05 03:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:20:05 [INFO]: Ebay item id :: 256437751907 exists in Database 2025-08-05 03:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:20:05 [INFO]: in processold action queue is array for {"44772093":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772093","ebayitemid":"256437751907","shopifyproductid":"8307679887582","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8307679887582","shopifyvariantid":"44865936326878","shopifyinventoryid":"46963984236766","shopifylocationid":"","product_id":"44772093","variant_id":"77680635","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 03:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 03:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:20:05 [INFO]: Shopify Inventory id 46963984236766 2025-08-05 03:20:05 [INFO]: Shopify Location id 58450641063 2025-08-05 03:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:20:05Z","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-05 03:20:05 [INFO]: Change: available | Delta: -2 2025-08-05 03:20:05 [INFO]: Change: on_hand | Delta: -2 2025-08-05 03:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772093 and user_id = 14409 2025-08-05 03:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680635 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:20:05 [INFO]: updateIdsQuantity -> ["77680635"] 2025-08-05 03:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 03:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680635 THEN 0 END, quantityflag = CASE WHEN id = 77680635 THEN 0 END WHERE user_id = 14409 AND id IN (77680635) 2025-08-05 03:20:05 [INFO]: QUANTITY Updated IDs: 77680635 2025-08-05 03:20:05 [INFO]: Successfully processed data for user 14409 2025-08-05 03:20:05 [INFO]: Execution Started 2025-08-05 03:20:05 [INFO]: Execution Finished 2025-08-05 03:30:01 [INFO]: Execution Started 2025-08-05 03:30:01 [INFO]: old server sucessfully connected 2025-08-05 03:30:01 [INFO]: sqs client sucess created 2025-08-05 03:30:02 [INFO]: Number of messages in the queue: 3 2025-08-05 03:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:30:03 [INFO]: item found in queue is 14409 2025-08-05 03:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBAs5m6nFJg0cpeeN98vy8XH0H3Et7uLMaQHl2QBbQ7fPvkb714U3+JWQRs7z9FyIOfwZWj1dMGWdly+ug7AApW5bUSOKVIBp5pIlbHu/if358jzBkyY2FBwY/N7gr4DGtjLI0YlG1EpzejaVGGh0r6oEzaEUL9opRIAexuUksu7NTZ6gOnjEdxlARSXtAWIuIUPLQgvqNUBX1Fy2JJpot4NKSSakQvySFKK8fMmleI496MlcbWs8xUFRNiFVJHdFIcSMYygrgHHqn7Vc7iIipDfvqT01pdnuFkP6fG7zzGqPrmfpDjpNHOBDS3IotYODl2A2LvBoffGjLfwjJnkaeLJTVm06y8NZWnPlopXaFz50jvyRrsnXbAR18+bNIlaLWapV6h0dSez5rIY/bYbaJz+aU29FmNJgqxPjgAb/PmC6NkW8tqa70vGQYOVAns0jK 2025-08-05 03:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:30:03 [INFO]: item found in queue is 14409 2025-08-05 03:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBos3lg1WXEwpcXt4yTRsolbM0owz+tV2y3wrJExWHdllXcxIGXihVDJIT889eQnSqmHxhH+HOO2917YiGsSaz6CpmZoukXVMSW57FEK84DCHUp2/l7ufNesyE139tPeKp30g9lSIyerPSs3n/vkIsp+NKPiYvawEEUNNttHFHsjjfOSbzQom92ImCtOirRZHF3A+TZQwtGFiOaVFE3TvyzFhGBy6BZTtYWdhb771Me3ZJ1RmQTMTabiQKoQMZucNaXMCh0nM/jiZmFDiyA7BD5jy4djmS7AA6ItDcLKapkndEwLynACvp2yiQH6wDbJJ7WJr9O9nBuUz/cTVpTasdX+2S5X/jzqjQLxRMLWmBzA3gI4O+YButTFy3DZTo1tWtQGbEh6DPvpUkRotFfQct+JaoFS9mFs9/WTtVwMKEnv19XKmkp2TiDoQOdyBsmURy 2025-08-05 03:30:04 [INFO]: item found in queue is if condition 14409 2025-08-05 03:30:04 [INFO]: item found in queue is 14409 2025-08-05 03:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB3YnQkvfDYWsUdFIu9CYh13ng17QjmFG4B5OSwzFFJrbgSue+Vw6E/RDTYNnG9uexujqMCrt5qnk0usCQkQGKqttj34hGKkKiP1E3kK4FgL2gWonUUxBePMsQU04dc8m9l5jzz4LdI/zMVHCr6Yb2srFyrZJ39/U+RaThuzUfqCbBU4l8g19PfESy02pV8mFY8tfhh68QZMl5Ve7UNrjJKsoKYQj6Gf1BGaSjFldb7VOpYCNiBN1eYHCYk4Vx4jYd0G0L7uk5gzoC3DGIdZe8+C4PJSlzkU/7oF8bs+tMjuXpbF6YgIAYDjo5a2IUx3fNyqXIgos4CxtO6yNPt37orMTeR6aJZoXcxuvTAOaCc+Q1PC7X8a3o7W+RNzVgCALzZvDhP4XtxVPNdWxLn16QtdmBigZKwenIApxsJ8VNyZ87gkgUm+61I1xcXRm7QIkV 2025-08-05 03:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 03:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 03:30:04 [INFO]: inside itemsold and closed 14409 2025-08-05 03:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:30:06 [INFO]: Ebay item id :: 256438017708 exists in Database 2025-08-05 03:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:30:06 [INFO]: inside itemsold and closed 14409 2025-08-05 03:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:30:08 [INFO]: Ebay item id :: 284811624049 exists in Database 2025-08-05 03:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:30:08 [INFO]: inside itemsold and closed 14409 2025-08-05 03:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:30:09 [INFO]: Ebay item id :: 404930233990 exists in Database 2025-08-05 03:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:30:09 [INFO]: in processold action queue is array for {"44772126":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772126","ebayitemid":"256438017708","shopifyproductid":"8307784712414","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8307784712414","shopifyvariantid":"44866264563934","shopifyinventoryid":"46964312441054","shopifylocationid":"","product_id":"44772126","variant_id":"77680668","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44569063":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569063","ebayitemid":"284811624049","shopifyproductid":"6665548726439","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"6665548726439","shopifyvariantid":"39792602939559","shopifyinventoryid":"41887407341735","shopifylocationid":"","product_id":"44569063","variant_id":"77461747","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44653970":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653970","ebayitemid":"404930233990","shopifyproductid":"8920834834654","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8920834834654","shopifyvariantid":"46785946779870","shopifyinventoryid":"48884460552414","shopifylocationid":"58450641063","product_id":"44653970","variant_id":"77559159","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 03:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 03:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:30:09 [INFO]: Shopify Inventory id 46964312441054 2025-08-05 03:30:09 [INFO]: Shopify Location id 58450641063 2025-08-05 03:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:30:09Z","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-05 03:30:10 [INFO]: Change: available | Delta: -1 2025-08-05 03:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772126 and user_id = 14409 2025-08-05 03:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680668 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:30:10 [INFO]: Shopify Inventory id 41887407341735 2025-08-05 03:30:10 [INFO]: Shopify Location id 58450641063 2025-08-05 03:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:30: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-05 03:30:10 [INFO]: Change: available | Delta: -1 2025-08-05 03:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569063 and user_id = 14409 2025-08-05 03:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77461747 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:30:10 [INFO]: Shopify Inventory id 48884460552414 2025-08-05 03:30:10 [INFO]: Shopify Location id 58450641063 2025-08-05 03:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:30:10Z","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-05 03:30:10 [INFO]: Change: available | Delta: -4 2025-08-05 03:30:10 [INFO]: Change: on_hand | Delta: -4 2025-08-05 03:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653970 and user_id = 14409 2025-08-05 03:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77559159 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:30:10 [INFO]: updateIdsQuantity -> ["77680668","77461747","77559159"] 2025-08-05 03:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 03:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680668 THEN 0 WHEN id = 77461747 THEN 0 WHEN id = 77559159 THEN 0 END, quantityflag = CASE WHEN id = 77680668 THEN 0 WHEN id = 77461747 THEN 0 WHEN id = 77559159 THEN 0 END WHERE user_id = 14409 AND id IN (77680668,77461747,77559159) 2025-08-05 03:30:10 [INFO]: QUANTITY Updated IDs: 77680668, 77461747, 77559159 2025-08-05 03:30:10 [INFO]: Successfully processed data for user 14409 2025-08-05 03:30:10 [INFO]: Execution Started 2025-08-05 03:30:10 [INFO]: Execution Finished 2025-08-05 03:40:01 [INFO]: Execution Started 2025-08-05 03:40:01 [INFO]: old server sucessfully connected 2025-08-05 03:40:01 [INFO]: sqs client sucess created 2025-08-05 03:40:02 [INFO]: Number of messages in the queue: 4 2025-08-05 03:40:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:40:03 [INFO]: item found in queue is 14409 2025-08-05 03:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmSTlwGgsMnWEDIleTOloWk7UsJI9e7fXfEB1l6mSUpDm+XAC2gSCi9PkU4vJBjIzfvBh0WZqWGN/F1/JeWf4I15gkwZA2H6zi29p5EF2lYB24qav7vsfT7vcl92n/IwurFjpEOThoMwAcOyy/5+ksWMVE4v1osmp/PE/Ff8g5A8pScxQqGVO5OzDduqsHiYvCgL/SnTYXKT8wPWpnshe6Cg5hdsph5orl950j7V+np6LnDjnSqGTQb6ayYffHMDzs804avVPbhw9uT3SbqszcQStx2rNfwpc1jR1ikvrEHwrTWGxkuiwSnrNTZ64//G32pK9JNorgsQP7wsUvw5oqlKgUwWRgOR8ALAyVvjiu51tyYZjhfAw1LmYOAakNdxgR3ttb/vBMUA4XqIhy7wGsoIxgwTSXcOyyR3O/niph+ETXPxPq3tB5vIWh0ZSBnf7 2025-08-05 03:40:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:40:03 [INFO]: item found in queue is 14409 2025-08-05 03:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBYK/9jvom1Pg+1+h02H4hEteksEZsljh/KGD3M3Y+K2FRkyuOMyGZbfcm/ishgnmrq5dOGOlC8Y6pLXJTDmyZ9vwLXiLMWZOLWctpqmfPCeyrhmf7oJ+2Vbpx1ZHwTx2C9a3Dr3+dyx5HbOJDDCoKjtlgTMZw7yiM/DtBC6wseJj0Ek6kJ0DBkT78l7vMJ6U7HBGsHBf9RGq24xHYy9aA80TB5tEfUzBnf0qvj8FBNe8gAEEM3nQnVU7DUzrTMO33Jn2SNO5/woD4rAaU1O4LJe6oaDg+6XKvk8w9wcCsLHhqgaN+14/X6X4ftFvduNZRI993L2USDzG9A32pBJCF4kjO/qC+Q7gJuY5Iac4QTkloJDk4GLE4PF4GYdqO/WP9eZ6ivX+CwysdYb1AMKePFl0WhUhnQLKx+YbEfXrEnkgW/nLdyEVdKrrH1Xzj0XnH 2025-08-05 03:40:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:40:03 [INFO]: item found in queue is 14409 2025-08-05 03:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBm5ZbrRfBbV2Ed5gssHTRVlMTOihZ1f77WGYzqauwXeaSb5rt9nx76AiwiMgzjSuNBHvd+r5ZjSrDrGo7tOpVEliyjhuCvYXzMvlSaTGITHjubXHS9SbWHW+05jkL6KvNppiAghycCT0dtzS+QKqK+h4ovqfI1uDC/2gs9BXUitmns+D+0w4RKVYWl7Ea8vZXDmRSz9ibaSCVYHromkgrtEXK4y/6tjbNSI3LDNJxNOwIAHekyIde+fUpO3cWc59D6aDWLx2h948bNr7XsnPL1r+DhG9Fjva8fuW3D27TJ8J/qTbd3u51llYe/MbGPN7899bCFZqLVE26k6OaU8u3ypLTIAmHcPTXN60aKVQrxNBb/XVJf5AllXq1F8xcrPOqjLSUKXrvuHtmo8KbD4qkwglpksxCQZT26sp11hiNJbRPzggdqLfFb6PpknzfiUmT 2025-08-05 03:40:04 [INFO]: item found in queue is if condition 14409 2025-08-05 03:40:04 [INFO]: item found in queue is 14409 2025-08-05 03:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBukQIvUVV0ChDINDWwtYRrjv/k434jYQpUH0nnNYLEazV7pXo9+Ee48jvVsy4qJoUItjnsNBmUuELwf+lhYn3ImNHFShSU9jzmyISCsudzvRI8JlnzeOzNjkOVOd0FqLiJZapp1x/PjdEJ9bwFm8oHS2E9+mixkCXGqjiGSmAtvIwiCmtWgThTMMwJaDxOgbIoMvNv1748cZvbEcyhUyHFgu8zsia/3Yg5l7IoFLDwXyC7Rzb+neCpsGLXEnvciYk3XApkafo6bYCe6lbUv3iX/GEdp/xvJUiyu8nmAb3dHQ9Wx4KAio5i8RAsbUhDZkrqc0Q3N6a1sXseawoE0KYAuua3SS+Dw0S51cm/ZmAxDBnrqlUBI3oJ97EVBsoah0jl1Ld8kvlet1C6M33gHqacoCRGBiDGLuM/7Xtjw3sMv/xPiI4oALpnvxgk1wwRjtR 2025-08-05 03:40:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 03:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 03:40:04 [INFO]: inside itemsold and closed 14409 2025-08-05 03:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:40:06 [INFO]: Ebay item id :: 256877945187 exists in Database 2025-08-05 03:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:40:06 [INFO]: inside itemsold and closed 14409 2025-08-05 03:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:40:08 [INFO]: Ebay item id :: 404796639557 exists in Database 2025-08-05 03:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:40:08 [INFO]: inside itemsold and closed 14409 2025-08-05 03:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:40:09 [INFO]: Ebay item id :: 285774857332 exists in Database 2025-08-05 03:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:40:09 [INFO]: inside itemsold and closed 14409 2025-08-05 03:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:40:11 [INFO]: Ebay item id :: 306300137562 exists in Database 2025-08-05 03:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:40:11 [INFO]: in processold action queue is array for {"44785229":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44785229","ebayitemid":"256877945187","shopifyproductid":"8861044801758","variants":[{"price":"66.99","quantity":0,"weight":"3","shopifyproductid":"8861044801758","shopifyvariantid":"46514871238878","shopifyinventoryid":"48617202647262","shopifylocationid":"","product_id":"44785229","variant_id":"77694669","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44638055":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638055","ebayitemid":"404796639557","shopifyproductid":"8695066788062","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8695066788062","shopifyvariantid":"45933892763870","shopifyinventoryid":"48032344146142","shopifylocationid":"","product_id":"44638055","variant_id":"77543243","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662401":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662401","ebayitemid":"285774857332","shopifyproductid":"8333378060510","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8333378060510","shopifyvariantid":"44952668733662","shopifyinventoryid":"47050450338014","shopifylocationid":"","product_id":"44662401","variant_id":"77567621","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44791273":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44791273","ebayitemid":"306300137562","shopifyproductid":"8918151299294","variants":[{"price":"214.27","quantity":0,"weight":"10","shopifyproductid":"8918151299294","shopifyvariantid":"46733810958558","shopifyinventoryid":"48832298221790","shopifylocationid":"58450641063","product_id":"44791273","variant_id":"77701526","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 03:40:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 03:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:40:11 [INFO]: Shopify Inventory id 48617202647262 2025-08-05 03:40:11 [INFO]: Shopify Location id 58450641063 2025-08-05 03:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:40: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-05 03:40:11 [INFO]: Change: available | Delta: -1 2025-08-05 03:40:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44785229 and user_id = 14409 2025-08-05 03:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77694669 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:40:11 [INFO]: Shopify Inventory id 48032344146142 2025-08-05 03:40:11 [INFO]: Shopify Location id 58450641063 2025-08-05 03:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:40:12Z","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-05 03:40:12 [INFO]: Change: available | Delta: -1 2025-08-05 03:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638055 and user_id = 14409 2025-08-05 03:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77543243 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:40:12 [INFO]: Shopify Inventory id 47050450338014 2025-08-05 03:40:12 [INFO]: Shopify Location id 58450641063 2025-08-05 03:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:40:12Z","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-05 03:40:12 [INFO]: Change: available | Delta: -1 2025-08-05 03:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662401 and user_id = 14409 2025-08-05 03:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567621 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:40:12 [INFO]: Shopify Inventory id 48832298221790 2025-08-05 03:40:12 [INFO]: Shopify Location id 58450641063 2025-08-05 03:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:40:12Z","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-05 03:40:12 [INFO]: Change: available | Delta: -2 2025-08-05 03:40:12 [INFO]: Change: on_hand | Delta: -2 2025-08-05 03:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44791273 and user_id = 14409 2025-08-05 03:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77701526 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:40:12 [INFO]: updateIdsQuantity -> ["77694669","77543243","77567621","77701526"] 2025-08-05 03:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-05 03:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77694669 THEN 0 WHEN id = 77543243 THEN 0 WHEN id = 77567621 THEN 0 WHEN id = 77701526 THEN 0 END, quantityflag = CASE WHEN id = 77694669 THEN 0 WHEN id = 77543243 THEN 0 WHEN id = 77567621 THEN 0 WHEN id = 77701526 THEN 0 END WHERE user_id = 14409 AND id IN (77694669,77543243,77567621,77701526) 2025-08-05 03:40:12 [INFO]: QUANTITY Updated IDs: 77694669, 77543243, 77567621, 77701526 2025-08-05 03:40:12 [INFO]: Successfully processed data for user 14409 2025-08-05 03:40:12 [INFO]: Execution Started 2025-08-05 03:40:12 [INFO]: Execution Finished 2025-08-05 03:50:01 [INFO]: Execution Started 2025-08-05 03:50:01 [INFO]: old server sucessfully connected 2025-08-05 03:50:01 [INFO]: sqs client sucess created 2025-08-05 03:50:02 [INFO]: Number of messages in the queue: 4 2025-08-05 03:50:02 [INFO]: item found in queue is if condition 14409 2025-08-05 03:50:02 [INFO]: item found in queue is 14409 2025-08-05 03:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEBwzOKagSmOu6OpEtubL4bZsrjvMXGk+NXB38VtzKX5QhoapVc6K+al5295EEEldmTvN/KP1YBSNL/lVszcG7gMnTKq2xynVPXwOrSgMw/epO73qWhr4ImXnyJ5dMcBy0Bo9dZdOagezIMExtlm4Zq5LlnNswsAJBViXd7mbk/3BbNsEp758qn29/MG+okefjB/8nWbQEejWSByGnzmHmu6ywctYMhz6HOheifK+NxoN3Vzqj51hVKQyUZS/5hIjYP9qgg2l2SdVlwoaC+TGk94YApVvb4dIESlnxIXAeQR2K3FvSQ5geM1evLVN2/JN1hbnVsHI4v1QHKUI1I/g0KhphU1MPsvdRl6d5RgjjhRyiRwz58wquiIMMXkKvPXdF3H8CcRShvCY9oPt4fBD4gmCC+uF77fOG17yjvoOKJPVGt4FPqp5AiB2ExS8NhpYPu 2025-08-05 03:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:50:03 [INFO]: item found in queue is 14409 2025-08-05 03:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBCy/cTsKWppckMGOYUh+a+l5f7VrvkVy9jq2hJlsLjpSZhvAnmedSH9ak6KOkDPcDpjIkCSsyO1TNUTC50zlQpyxuh6sipGloUkIKYShnd5tpRgCby9YCQEkExUQfHdCAKf6SXDBurjsyOneUw6gtVeqeWjr9Zuq2/lEl9H2kc/XmuMiIpep3GD8PHr4DmZnnFJ/o9VQ5cT+t7mPulLfTLGuovWy3hLEvSoIYoM932YkcMtia5VWgXDBL9YjkrkA2nJbfsWlZ+uJgxDYQ68wXHs9vAChgaPd23VHp7Jw4jBdYDpYFl/YHe+GG9bGsju1EbshMfjg17WH+7QLTf+nBxjyz8wA6xJ5rH1cQspGsJr/ae73Tp0xDhEpp2Nh3AaxJGJYmVwhnNnU2zja82ld4DlfoYIf+vgGX9Ambqidaav/psaBd6gsAsUi3cB4hqBeY 2025-08-05 03:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 03:50:03 [INFO]: item found in queue is 14409 2025-08-05 03:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPcP4cKiQgDAxOtQ83o0Z3c93dXUps9g7sXMulxEjjx2YIGt+CxX6BR+Pe/mJ+L2R/lfogmJTUPvRLl4u8LxbhB10j6fC825/Cnao/T4hiC1PkALNn7wB8i2DRCjqJSNC11ElNnyu6mP0TIn+xKDXe4Md/r6BV37VhBToRok0bYl8CpaJcjrmTQ9fuZ+I35S4dk55uN0fnBgo4l+FzZhk5xPb5EvdDu70CtWqpuNW6gkmZpJq/WJWUXPt+3zCjf58CV2IN8laxvhYhB/pLoZAbscMjPw+5cO9jAwbu0+JvVVe/mNodzD8uTanGP1Ib7CSpRx/BvHQxwgZF/GMLAIeJeiUQPxfA9VJ5WNv4D2W11tHT0/FMZQGO76CxHcpmK3X693JfkM/HoHiqV5sZu0wBLYTRbHeV4dDPpx4Js5N5HpJitSXoumX8zWxiu0Bkud2 2025-08-05 03:50:04 [INFO]: item found in queue is if condition 14409 2025-08-05 03:50:04 [INFO]: item found in queue is 14409 2025-08-05 03:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB5uBUKV/djvNmXbAwr+RYNRD/Zngw/G/s+Li+o9P4TyzgmZ15M2Op87mb3yOYfoAwn12PS3IYanENGZ5esRbpqIUgJr2/yd2YB/EZzndJUZoad36O5GZ01+Ky+9pNtjGCZmuDkebAJZAItAT+CdOPBzeBj+az2aexlMsXizUYK9atKQuW0z07sLRVEnzxZw1z9FHcxux+McZLyGvdpCKLX2sAyolJD5i4C7Y6FxVibQmbKEPFkoS5a//KyA6yd+wrc9XTzHNvbIEn+N+u2mCWE7FNYBD8gzGT8X6JeTiD359ubzl+PA6woLFrzRlUGT5k5I7aLRqlnj1PHj9YqyvR9+te72z8Umg0r3wa1wgbpfh8BcqbVF+9BlgSjEk/h8B2JxnoQOhN1SfLrsPsGkB+Xa2J8TeKGoKpIXqd+xgahKaQR0KdYXDkLJaofemJJJ4/ 2025-08-05 03:50:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 03:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 03:50:04 [INFO]: inside itemsold and closed 14409 2025-08-05 03:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:50:06 [INFO]: Ebay item id :: 285974071579 exists in Database 2025-08-05 03:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:50:06 [INFO]: inside itemsold and closed 14409 2025-08-05 03:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:50:07 [INFO]: Ebay item id :: 285785521224 exists in Database 2025-08-05 03:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:50:07 [INFO]: inside itemsold and closed 14409 2025-08-05 03:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:50:09 [INFO]: Ebay item id :: 405750020939 exists in Database 2025-08-05 03:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 03:50:09 [INFO]: inside itemsold and closed 14409 2025-08-05 03:50:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 03:50:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 03:50:11 [INFO]: Ebay item id :: 286501645193 exists in Database 2025-08-05 03:50:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 03:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 03:50:11 [INFO]: in processold action queue is array for {"44670968":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670968","ebayitemid":"285974071579","shopifyproductid":"8695025107166","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8695025107166","shopifyvariantid":"45933801996510","shopifyinventoryid":"48032253411550","shopifylocationid":"","product_id":"44670968","variant_id":"77576188","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44684452":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684452","ebayitemid":"285785521224","shopifyproductid":"8342532456670","variants":[{"price":"79.99","quantity":0,"weight":"2","shopifyproductid":"8342532456670","shopifyvariantid":"44988145434846","shopifyinventoryid":"47085936574686","shopifylocationid":"","product_id":"44684452","variant_id":"77589677","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44892418":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44892418","ebayitemid":"405750020939","shopifyproductid":"8929152401630","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8929152401630","shopifyvariantid":"46853127438558","shopifyinventoryid":"48964564910302","shopifylocationid":"58450641063","product_id":"44892418","variant_id":"77806104","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 03:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 03:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 03:50:11 [INFO]: Shopify Inventory id 48032253411550 2025-08-05 03:50:11 [INFO]: Shopify Location id 58450641063 2025-08-05 03:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:50: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-05 03:50:11 [INFO]: Change: available | Delta: -1 2025-08-05 03:50:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670968 and user_id = 14409 2025-08-05 03:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576188 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:50:11 [INFO]: Shopify Inventory id 47085936574686 2025-08-05 03:50:11 [INFO]: Shopify Location id 58450641063 2025-08-05 03:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T03:50: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-05 03:50:11 [INFO]: Change: available | Delta: -1 2025-08-05 03:50:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 03:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684452 and user_id = 14409 2025-08-05 03:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589677 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:50:11 [INFO]: Shopify Inventory id 48964564910302 2025-08-05 03:50:11 [INFO]: Shopify Location id 58450641063 2025-08-05 03:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 03:50:12 [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-05 03:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 03:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44892418 and user_id = 14409 2025-08-05 03:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77806104 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 03:50:12 [INFO]: updateIdsQuantity -> ["77576188","77589677","77806104"] 2025-08-05 03:50:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 03:50:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77576188 THEN 0 WHEN id = 77589677 THEN 0 WHEN id = 77806104 THEN 0 END, quantityflag = CASE WHEN id = 77576188 THEN 0 WHEN id = 77589677 THEN 0 WHEN id = 77806104 THEN 0 END WHERE user_id = 14409 AND id IN (77576188,77589677,77806104) 2025-08-05 03:50:12 [INFO]: QUANTITY Updated IDs: 77576188, 77589677, 77806104 2025-08-05 03:50:12 [INFO]: Successfully processed data for user 14409 2025-08-05 03:50:12 [INFO]: Execution Started 2025-08-05 03:50:12 [INFO]: Execution Finished