2025-08-13 18:00:01 [INFO]: Execution Started 2025-08-13 18:00:01 [INFO]: old server sucessfully connected 2025-08-13 18:00:01 [INFO]: sqs client sucess created 2025-08-13 18:00:03 [INFO]: Number of messages in the queue: 0 2025-08-13 18:00:23 [INFO]: Execution Started 2025-08-13 18:00:23 [INFO]: Execution Finished 2025-08-13 18:10:01 [INFO]: Execution Started 2025-08-13 18:10:01 [INFO]: old server sucessfully connected 2025-08-13 18:10:01 [INFO]: sqs client sucess created 2025-08-13 18:10:03 [INFO]: Number of messages in the queue: 1 2025-08-13 18:10:05 [INFO]: item found in queue is if condition 14409 2025-08-13 18:10:05 [INFO]: item found in queue is 14409 2025-08-13 18:10:06 [INFO]: Message deleted from the queue for receipt handle: AQEB5IMvsSUfI1oMX/hOLAz+k9Pwgx6w2FjrmkANeH+SIZuWXpHROk4lzk7MhovKPmYSFGWAXrOsQXuuFx7EvMpaYpTR/+6BNrRP1hYcCV+ciqZlw6hgnarkRD23eME2J1GPNViYtbBtlPCYid90HXP/RZhE7uqJ/fEegdpi1a/ZjCLAa0k53SPWUSaMqSO9V2Fb4PxN8RyTNUK/1C4uVRXDav5MvMTBAIpEYJ00eorI3xiDp/RpOuc7uwxRCci/u3VAMu0Pdw3U0B1emmKCB1jDEJzaHHe9V2YyyNVUFeqt/xlSpOH6k0fzbh0uLf+d+fnNpZcu4UPGYEkAlrjWcL+3xnZBG52yKkwLXr457mJbktnyI5Ad3oBNC171h92n29X3n5LF+ph06mkoP3lv9XQ5nKsXGqY91d1ZIFSA5zr/zgXDbv53noC3TfWoBOguGv0D 2025-08-13 18:10:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 18:10:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 18:10:06 [INFO]: inside itemsold and closed 14409 2025-08-13 18:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 18:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 18:10:07 [INFO]: Ebay item id :: 286763203142 exists in Database 2025-08-13 18:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 18:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 18:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 18:10:07 [INFO]: in processold action queue is array for {"45314271":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45314271","ebayitemid":"286763203142","shopifyproductid":"8986104070366","variants":[{"price":"169.99","quantity":0,"weight":"15","shopifyproductid":"8986104070366","shopifyvariantid":"47442802802910","shopifyinventoryid":"49554695880926","shopifylocationid":"58450641063","product_id":"45314271","variant_id":"78266784","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 18:10:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 18:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 18:10:08 [INFO]: Shopify Inventory id 49554695880926 2025-08-13 18:10:08 [INFO]: Shopify Location id 58450641063 2025-08-13 18:10:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 18:10: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-13 18:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 18:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45314271 and user_id = 14409 2025-08-13 18:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266784 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 18:10:08 [INFO]: updateIdsQuantity -> ["78266784"] 2025-08-13 18:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0 2025-08-13 18:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266784 THEN 0 END, quantityflag = CASE WHEN id = 78266784 THEN 0 END WHERE user_id = 14409 AND id IN (78266784) 2025-08-13 18:10:08 [INFO]: QUANTITY Updated IDs: 2025-08-13 18:10:08 [INFO]: Successfully processed data for user 14409 2025-08-13 18:10:08 [INFO]: Execution Started 2025-08-13 18:10:08 [INFO]: Execution Finished 2025-08-13 18:20:01 [INFO]: Execution Started 2025-08-13 18:20:01 [INFO]: old server sucessfully connected 2025-08-13 18:20:01 [INFO]: sqs client sucess created 2025-08-13 18:20:03 [INFO]: Number of messages in the queue: 2 2025-08-13 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-13 18:20:03 [INFO]: item found in queue is 14409 2025-08-13 18:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB04mxWDfq5qin4hGzowZ8uc+wjVjSfZDDsMyUTOEd3sgUurVO9kUPWhXXdNLfdrailFlgel9CVx1g4tXVDDPvirYiNp7Dg12EZgh7TBKYL3xl8qdkuJy/Im0ERuHWTl5uSCgIqqz+PvDznCMfjb9Le9AK3Duthspd0+1t3z6Z3/5v4SmjmXMX6ZC76rcGijCGnlxzne+lgDHur5J3YchwQrL5OXJ2TH6UOS2N+m/bfrTZeHIF1Jj9oymh49PNG2SK+JZWN04vk73L5b0kTzxahIInMtp/bXEUQ4+0FMn4vNOf7mgas658eL79Fw5H82O0/aBkg3Fh9cKYI1QBQbC5Qu5P3i29BFhobovZTMes5xt/8FnKErfIBn6Xg9x+nBK6Ux1xyiMJECtkxcj224YqV2O/kTPxcUi1am9kOHQPkRr/SbbRvFQon0YEVJWMrzrA 2025-08-13 18:20:04 [INFO]: item found in queue is if condition 14409 2025-08-13 18:20:04 [INFO]: item found in queue is 14409 2025-08-13 18:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBAUkwhRbnarOFiHECq8GiFhwUTUkCR0e2a4OBA9YXFIe/IZM2nN2A0LODs5Hmi/tT68kJwkPhvbR+l8QAQUlDNSlS67LHAnOXzU9GC46W8R5NzHly8mefnDbauDc46pxbioPKiH0Xf0WM8Tr+WSYrWYGL1ZO1AErohq3kuk6nopRdnzWbQD/YLUum2in6zlDJ8sweowyMIpdb4nYSEWhYqwxwhqexOA4bKK5XZrOgnxusGw2OrVypf0D4gXIs0i6EL/KVzTjs1Sf37UGuh/HZAsHA/ASCUXs1zeldJfsNukMr4SJOHK6I/Vauu54m0h4BLMy2TL8iukxOUxqwFizIToKiJtFCvfOjS5oIw+WV2439LqK9HLnbs6/Lko/NMXPhZlFVqAaI9U6Kw3UJPzpWSCL/261trGskVcqvqmT/yxPCrmeSyRa/CYCOuF1Hz+TJ 2025-08-13 18:20:05 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 18:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 18:20:05 [INFO]: inside itemsold and closed 14409 2025-08-13 18:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 18:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 18:20:07 [INFO]: Ebay item id :: 405294726241 exists in Database 2025-08-13 18:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 18:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 18:20:07 [INFO]: inside itemsold and closed 14409 2025-08-13 18:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 18:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-13 18:20:08 [INFO]: Ebay item id :: 286651424471 exists in Database 2025-08-13 18:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-13 18:20:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 18:20:08 [INFO]: in processold action queue is array for {"44656185":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656185","ebayitemid":"405294726241","shopifyproductid":"8015357870302","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8015357870302","shopifyvariantid":"44142430453982","shopifyinventoryid":"46239336235230","shopifylocationid":"","product_id":"44656185","variant_id":"77561374","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45115918":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115918","ebayitemid":"286651424471","deleted":1}}} 2025-08-13 18:20:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 18:20:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 18:20:08 [INFO]: productIds WHich are having null productid -> [45115918] 2025-08-13 18:20:08 [INFO]: ebayItemIds WHich are not imported-> ["286651424471"] 2025-08-13 18:20:08 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 18:20:08 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 18:20:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115918) 2025-08-13 18:20:08 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 18:20:08 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 18:20:08 [INFO]: Transaction committed successfully. 2025-08-13 18:20:08 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 18:20:08 [INFO]: Shopify Inventory id 46239336235230 2025-08-13 18:20:08 [INFO]: Shopify Location id 58450641063 2025-08-13 18:20:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 18:20:09 [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-13 18:20:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 18:20:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656185 and user_id = 14409 2025-08-13 18:20:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561374 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 18:20:09 [INFO]: updateIdsQuantity -> ["77561374"] 2025-08-13 18:20:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 18:20:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561374 THEN 0 END, quantityflag = CASE WHEN id = 77561374 THEN 0 END WHERE user_id = 14409 AND id IN (77561374) 2025-08-13 18:20:09 [INFO]: QUANTITY Updated IDs: 77561374 2025-08-13 18:20:09 [INFO]: Successfully processed data for user 14409 2025-08-13 18:20:09 [INFO]: Execution Started 2025-08-13 18:20:09 [INFO]: Execution Finished 2025-08-13 18:30:01 [INFO]: Execution Started 2025-08-13 18:30:01 [INFO]: old server sucessfully connected 2025-08-13 18:30:01 [INFO]: sqs client sucess created 2025-08-13 18:30:02 [INFO]: Number of messages in the queue: 0 2025-08-13 18:30:22 [INFO]: Execution Started 2025-08-13 18:30:22 [INFO]: Execution Finished 2025-08-13 18:40:01 [INFO]: Execution Started 2025-08-13 18:40:01 [INFO]: old server sucessfully connected 2025-08-13 18:40:01 [INFO]: sqs client sucess created 2025-08-13 18:40:02 [INFO]: Number of messages in the queue: 1 2025-08-13 18:40:02 [INFO]: item found in queue is if condition 14409 2025-08-13 18:40:02 [INFO]: item found in queue is 14409 2025-08-13 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBC4BlBXUOvJIq6ijzeRUi+ZkrbSPUAj4k1irF36++JAMcz3aybJN2liU3M3qqJg+LN+oy+gEiUxCPh36t/QoaCbDI3wfvQ+TMVO4NOrak8IKTVyfy7kHkaZfHqEcRE7VRze3O7Ps4n8W7bzWKrgmVQDtFuQcgKyU+IHyk/l8IKUcncTlXTntzCIz+0caJMal3BcnU93Ee7NB+BIyUmYj1SB6BWZ7dRdmcGFIRzx9DZqufbPqvtbmpYGAKb4RVbiSm6NH/Fuhe/At8RoGU5/IYrJtKnKxsENWqOqTDJCqNbVVXx5XtBdKscZuW9vGzgp/V7UghUpGaDPAtB7W/P0KCuIluRg2rW6/tNPEJiy3XXmydomEgG7mbjLw07Y/dv42zBkTiZgaQn6oBoDtj3fYJ/M4ukCy+FJlVLTBJW7LE8PWs29/ZNqhVDGhdhxHbaDS8 2025-08-13 18:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 18:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 18:40:03 [INFO]: inside itemsold and closed 14409 2025-08-13 18:40:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 18:40:04 [INFO]: autolink for user_id 14409 is 1 2025-08-13 18:40:04 [INFO]: Ebay item id :: 336019869247 exists in Database 2025-08-13 18:40:04 [INFO]: Item is reliested :: exists in Database 2025-08-13 18:40:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 18:40:04 [INFO]: in processold action queue is array for {"45115729":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115729","ebayitemid":"336019869247","deleted":1}}} 2025-08-13 18:40:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 18:40:04 [INFO]: productIds WHich are having null productid -> [45115729] 2025-08-13 18:40:04 [INFO]: ebayItemIds WHich are not imported-> ["336019869247"] 2025-08-13 18:40:04 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 18:40:04 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 18:40:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115729) 2025-08-13 18:40:04 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 18:40:04 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 18:40:04 [INFO]: Transaction committed successfully. 2025-08-13 18:40:04 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 18:40:04 [INFO]: Successfully processed data for user 14409 2025-08-13 18:40:04 [INFO]: Execution Started 2025-08-13 18:40:04 [INFO]: Execution Finished 2025-08-13 18:50:01 [INFO]: Execution Started 2025-08-13 18:50:01 [INFO]: old server sucessfully connected 2025-08-13 18:50:01 [INFO]: sqs client sucess created 2025-08-13 18:50:02 [INFO]: Number of messages in the queue: 0 2025-08-13 18:50:23 [INFO]: Execution Started 2025-08-13 18:50:23 [INFO]: Execution Finished