2025-08-14 22:00:01 [INFO]: Execution Started 2025-08-14 22:00:01 [INFO]: old server sucessfully connected 2025-08-14 22:00:01 [INFO]: sqs client sucess created 2025-08-14 22:00:02 [INFO]: Number of messages in the queue: 1 2025-08-14 22:00:02 [INFO]: item found in queue is if condition 14409 2025-08-14 22:00:02 [INFO]: item found in queue is 14409 2025-08-14 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBDqC075d0O0rtuqsAX+SYpH4ZSabz+F1GAzdSd8aW72xbjVV13Vo6b4LdoHNJmJly7jToNXRMHXmjJPtso7ZepbLgcjhWA3vHGd52aJUXVjfzKX7KSAcVfIvX2GVOdyTd/kBbR2+fi61Yzt8uoz+GhD0PLpYJWZTorvvW/Mt7CPyo7kEtWuAzN3RZgtXKs9aj7cw/nwEHNqhRw5uj6nPt7BflCC4eN+J/8nEZ7oQoqP8sHbT3HZ11PYdbLEV8QNReqp+JGBWWucZaQrIZXv47EYKwQlCXXEWgjEUKMA9ElVYIQSJv8aCyaLmh3YnF8MNgxEBmKFGuqKIl4FjcPXa3mWOM37Nir2LSS1UGYkqa4qR+42CQTwqsxgWlZFAOJ+WEbUaJauAx/e0RnoPgRrWnKiKOyxMT3NYKcfAZO1d6puymNu8HMHVGTavJ2dWBp+1p 2025-08-14 22:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 22:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 22:00:03 [INFO]: inside itemsold and closed 14409 2025-08-14 22:00:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:00:04 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:00:04 [INFO]: Ebay item id :: 285309125092 exists in Database 2025-08-14 22:00:04 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:00:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 22:00:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 22:00:04 [INFO]: in processold action queue is array for {"44763125":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44763125","ebayitemid":"285309125092","shopifyproductid":"8052421656798","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8052421656798","shopifyvariantid":"44210340692190","shopifyinventoryid":"46307427877086","shopifylocationid":"","product_id":"44763125","variant_id":"77671667","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 22:00:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 22:00:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 22:00:04 [INFO]: Shopify Inventory id 46307427877086 2025-08-14 22:00:04 [INFO]: Shopify Location id 58450641063 2025-08-14 22:00:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 22:00: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-14 22:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 22:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44763125 and user_id = 14409 2025-08-14 22:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77671667 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 22:00:05 [INFO]: updateIdsQuantity -> ["77671667"] 2025-08-14 22:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-14 22:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77671667 THEN 0 END, quantityflag = CASE WHEN id = 77671667 THEN 0 END WHERE user_id = 14409 AND id IN (77671667) 2025-08-14 22:00:05 [INFO]: QUANTITY Updated IDs: 77671667 2025-08-14 22:00:05 [INFO]: Successfully processed data for user 14409 2025-08-14 22:00:05 [INFO]: Execution Started 2025-08-14 22:00:05 [INFO]: Execution Finished 2025-08-14 22:10:01 [INFO]: Execution Started 2025-08-14 22:10:01 [INFO]: old server sucessfully connected 2025-08-14 22:10:01 [INFO]: sqs client sucess created 2025-08-14 22:10:02 [INFO]: Number of messages in the queue: 2 2025-08-14 22:10:03 [INFO]: item found in queue is if condition 14409 2025-08-14 22:10:03 [INFO]: item found in queue is 14409 2025-08-14 22:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBG0bXmLeyArYVuiWU+YDGhpL+Xh0m/wrWLh78OSpzHvBYYauIp5+5p86hRyx/FwQxmHQ9YoloKjY5T+nY09mu+T1agStBHFshxo+YhEEvaop/iqijhOZ7ixRG5DdM5ZZpRDclPHL0gRciE5wS9HwrEO83KAp7VwVhG122kCdj+owcbvYeCbexGxbsm4e9N1wBEDVOb2XokNFhmJbuF2Upd1I48vdaIdATl7xpQ373Z1Aj5p2eE3TzdTj2Ir+1TTwxevgC0Cqs9bgs4u6+6i4p5TAyOoNTWlvx/SmD7Hpi2mkoUm6MZnhh9ZMbtqIhusrcXMaSL7veNC7TgV5kVkxeId5S5U9hOaQJNk3/1KQnjAWXsdpE3Ci5Oz3smy4zEXe3zSHFw1zm2raQ2dVX7msN2TpW4CjhBwMLGtG1O/PBacV/jbosGVGD3B6Lk5gUNAWy 2025-08-14 22:10:03 [INFO]: item found in queue is if condition 14409 2025-08-14 22:10:03 [INFO]: item found in queue is 14409 2025-08-14 22:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBrk64NfbGHYE8qGlyDttux/vhsc93GBWrbqDb04K5+/YuwEUpEqyVfrb0MXoFPpJznuiiVEZ0cdu0qwwZrVT68PnIg7SWL/BPfpUGg2t0t+daNESBLzbippOyJMSwFwIlmIfetZNnGwOBu2U8JbJX/Trd20Hkb71eoHIuhQ+NtirCkFnWDW9FP/4CGkzUWMH877mOMjWmeA6nQ8lvd8CepVXgOScHMsAvKwmCKDY2Lt7p1RbHB9iKYSltuNKky4mh2YKnnJtSgtka5ZeG7lMsMQWfKRUnB25VBGkGBAywfqe+7CA+r1Jc6VH57Qkv1ut96BARfnSJ46lhw8AuesV/Ce1TRT7LgXFoluPluKZWh9TP8xQdwW+H30yB4zHHKda5dw5FjAS5q6sn1zD8i3cntaZG4zp4Sc+F0/+6TkyzY79RMVQAzBZT5ATASMQc4pm+ 2025-08-14 22:10:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 22:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 22:10:04 [INFO]: inside itemsold and closed 14409 2025-08-14 22:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:10:05 [INFO]: Ebay item id :: 226489979531 exists in Database 2025-08-14 22:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 22:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 22:10:05 [INFO]: inside itemsold and closed 14409 2025-08-14 22:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:10:07 [INFO]: Ebay item id :: 286109456477 exists in Database 2025-08-14 22:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 22:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 22:10:07 [INFO]: in processold action queue is array for {"44736318":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736318","ebayitemid":"226489979531","shopifyproductid":"8759863607518","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8759863607518","shopifyvariantid":"46139174781150","shopifyinventoryid":"48238398046430","shopifylocationid":"","product_id":"44736318","variant_id":"77644255","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44573435":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573435","ebayitemid":"286109456477","shopifyproductid":"8706620752094","variants":[{"price":"15.99","quantity":0,"weight":"0.75","shopifyproductid":"8706620752094","shopifyvariantid":"45962852171998","shopifyinventoryid":"48061541744862","shopifylocationid":"","product_id":"44573435","variant_id":"77466142","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 22:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 22:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 22:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 22:10:07 [INFO]: Shopify Inventory id 48238398046430 2025-08-14 22:10:07 [INFO]: Shopify Location id 58450641063 2025-08-14 22:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 22:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1986,"restoreRate":100}}}} 2025-08-14 22:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 22:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736318 and user_id = 14409 2025-08-14 22:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644255 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 22:10:08 [INFO]: Shopify Inventory id 48061541744862 2025-08-14 22:10:08 [INFO]: Shopify Location id 58450641063 2025-08-14 22:10:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 22:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T22:10:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1982,"restoreRate":100}}}} 2025-08-14 22:10:08 [INFO]: Change: available | Delta: -1 2025-08-14 22:10:08 [INFO]: Change: on_hand | Delta: -1 2025-08-14 22:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 22:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573435 and user_id = 14409 2025-08-14 22:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466142 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 22:10:08 [INFO]: updateIdsQuantity -> ["77644255","77466142"] 2025-08-14 22:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-14 22:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644255 THEN 0 WHEN id = 77466142 THEN 0 END, quantityflag = CASE WHEN id = 77644255 THEN 0 WHEN id = 77466142 THEN 0 END WHERE user_id = 14409 AND id IN (77644255,77466142) 2025-08-14 22:10:08 [INFO]: QUANTITY Updated IDs: 77644255, 77466142 2025-08-14 22:10:08 [INFO]: Successfully processed data for user 14409 2025-08-14 22:10:08 [INFO]: Execution Started 2025-08-14 22:10:08 [INFO]: Execution Finished 2025-08-14 22:20:01 [INFO]: Execution Started 2025-08-14 22:20:01 [INFO]: old server sucessfully connected 2025-08-14 22:20:01 [INFO]: sqs client sucess created 2025-08-14 22:20:03 [INFO]: Number of messages in the queue: 2 2025-08-14 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-14 22:20:03 [INFO]: item found in queue is 14409 2025-08-14 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8VTojlWybzrK8JdKNH1OkzlZ62KoHec9XVeZ5B3iRwF14dnlDoEgK9ztbLNZGcE48AIevl0rm6AwoanIexCg7EQC8TQPt7+mkFxDGwce9j/urhQGgYDFKVvYyf3Xwu2BowTQTmZIoENFovL0F2pCwU+fuE8B4tnKbksLcyGBDsy4IyMfG44SHcYaKGs5mY+KTwkC/c6wvoPOLvWs4uIierI3Ij5xVdZ71VAjQu2kg4oTvb0HFDbSom+DIBRp4hCu1lf99sZPIuVMwrvk0P1qYiQMtsbIiqsDpez1x6N2obKg0PRM04yiop+r8pOYDaUqmrWkKaSJILilDsGMT1RGLJ0Ysey6nTnq+QsdMYMCZ1dSaPSuLgLCleSt+PTbVxx+WktOMcewU8X5ERTjePQsG4N+7coRMgKaQiN0Hcjhf6J1gXtvlPcQUd7JqAaViR3e 2025-08-14 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-14 22:20:03 [INFO]: item found in queue is 14409 2025-08-14 22:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBA9A06NDYWvl8f8h50egxY+lmsNdVbbzodabCJ9zrsjVC0UnR4yha+rRfvoiS2F2AgA60QPojgvDPHPbOuHMci2DReN5KXTpmZ+WX+tNeNIVL0XSNwC+LWyWmBnnA8ahSa0NLExTY6hFkh7C1PVrY7e/ZpPH2jDUZZ6BIDCoMJFD9wo7Hfs24e9MiF9aNhh6uZg5/CJf1zCXZ+QEWO/vfrLbFogQflzmkT3LPl7wqyPM6q1H/IW671LTqM48sxTinXkHPthmUBtvnZ7cKIMr6AjlVNSH7/SoLmceRI6Vk/ugG36E/dX/kJ8KGBmNLZa2mdwtL1Ia56Yl9Vyh21I50Gn/2TNZhbvi+4usMukeMvzcWYhitx1CcQfapq2QpSyUTppQd1P4QA1WAtNY0gQjl0pSpS833q+PCi8ssN8U4t8znV2sD6tPIw4o+rj1x7izJ 2025-08-14 22:20:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-14 22:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 22:20:04 [INFO]: inside itemsold and closed 14409 2025-08-14 22:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:20:05 [INFO]: Ebay item id :: 285677459389 exists in Database 2025-08-14 22:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 22:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 22:20:05 [INFO]: inside itemsold and closed 14409 2025-08-14 22:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:20:07 [INFO]: Ebay item id :: 286278187233 exists in Database 2025-08-14 22:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 22:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 22:20:07 [INFO]: in processold action queue is array for {"44597406":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44597406","ebayitemid":"285677459389","shopifyproductid":"8270198767838","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8270198767838","shopifyvariantid":"44744819015902","shopifyinventoryid":"46842826588382","shopifylocationid":"","product_id":"44597406","variant_id":"77490115","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44586872":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586872","ebayitemid":"286278187233","shopifyproductid":"8705148649694","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8705148649694","shopifyvariantid":"45959078871262","shopifyinventoryid":"48057711460574","shopifylocationid":"","product_id":"44586872","variant_id":"77479581","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-14 22:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 22:20:07 [INFO]: Shopify Inventory id 46842826588382 2025-08-14 22:20:07 [INFO]: Shopify Location id 58450641063 2025-08-14 22:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 22:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1979,"restoreRate":100}}}} 2025-08-14 22:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 22:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44597406 and user_id = 14409 2025-08-14 22:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490115 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 22:20:07 [INFO]: Shopify Inventory id 48057711460574 2025-08-14 22:20:07 [INFO]: Shopify Location id 58450641063 2025-08-14 22:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 22:20: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-14 22:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 22:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586872 and user_id = 14409 2025-08-14 22:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479581 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 22:20:08 [INFO]: updateIdsQuantity -> ["77490115","77479581"] 2025-08-14 22:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 1 2025-08-14 22:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77490115 THEN 0 WHEN id = 77479581 THEN 0 END, quantityflag = CASE WHEN id = 77490115 THEN 0 WHEN id = 77479581 THEN 0 END WHERE user_id = 14409 AND id IN (77490115,77479581) 2025-08-14 22:20:08 [INFO]: QUANTITY Updated IDs: 77490115, 77479581 2025-08-14 22:20:08 [INFO]: Successfully processed data for user 14409 2025-08-14 22:20:08 [INFO]: Execution Started 2025-08-14 22:20:08 [INFO]: Execution Finished 2025-08-14 22:30:01 [INFO]: Execution Started 2025-08-14 22:30:01 [INFO]: old server sucessfully connected 2025-08-14 22:30:01 [INFO]: sqs client sucess created 2025-08-14 22:30:02 [INFO]: Number of messages in the queue: 0 2025-08-14 22:30:23 [INFO]: Execution Started 2025-08-14 22:30:23 [INFO]: Execution Finished 2025-08-14 22:40:02 [INFO]: Execution Started 2025-08-14 22:40:02 [INFO]: old server sucessfully connected 2025-08-14 22:40:02 [INFO]: sqs client sucess created 2025-08-14 22:40:03 [INFO]: Number of messages in the queue: 4 2025-08-14 22:40:03 [INFO]: item found in queue is if condition 14409 2025-08-14 22:40:03 [INFO]: item found in queue is 14409 2025-08-14 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNUOJGyKDaqetwiKIRhU+PTx6k14NF1uJ49M2ePDZeXuNM/azXN5nuV6R5+FU3+lgTw4WagJgyj7QDbUX0OsyEn0mCUhEtEiR5fuiJmqercSSNTsJ7sNe83PyqY3D47s1GGlwqgN+Q848MYt/wIurhSeTvrDhjTlolq+Ue0iNnXYrrqHto0iDr7s/uIa0DUYvmYZ+wJF9e141Bmr8ngKxO4RSbDj0Bh6/eYIYCcFbqKkZcCpCETYThz9I4fue0kL981kagKIH4bMC70PEkwLE6L1NZXINRHUbZeX2EyUmJ4SAlekTUqJnnovVCUVUfuW3OaIij0ibvnctEPNfvhLM6/NL90uhUxcvy4nq+1rQn+1ADQtOubPAjB3pSE0e2a9gMm8fy4qgfLGPI6epC71lkgGLI/ESmUX4POwzjvKVQUyYr91FRn/2/xwhhutb8l1x 2025-08-14 22:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 22:40:04 [INFO]: item found in queue is 14409 2025-08-14 22:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBy3i5GkOr4/RNWDdKDdUv8M1T8wO1xel2LEIPhjJyYkTtIZ3XYNKVJ7GxzcX0tJYlzdF2brtnvK0osFXQAoWq4MB2B277H6X2CcZgVBFPQSnytZ0lwJfNStj//zoWKZvpP08Fo6rENLSS2IrLJxRFK7RnHpU3JGFZ7X3jFC3gpzms+hGHq3GyUHAwL3qjIGPWQ3i5Wny252yBdjXej4T9+sr+rw+0PqTSykAPlP/+eAMjTR+n6TWyIT6VMjNNKyZL9Emh2CBc76WhyO0WlQH+CWBhoEQFDl1tf2rJluwnHnuuvDQDc79Ad7gkN1lriKOcDlL+0YxAa9NAR2XYyVQpzruT7vi/bJIffKL7A7QiF2Xi2x6DsTBbXArtBOXF6A6EGqGZTsYlDagUYfDZal+imHoxklfuXhayxKsVRRjQwU3daNI+ve4mHha718YIpiHc 2025-08-14 22:40:04 [INFO]: item found in queue is if condition 14409 2025-08-14 22:40:04 [INFO]: item found in queue is 14409 2025-08-14 22:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB5TBsktzyFrjju8QH6pBddHRMdTf5Q2V/0LMrE4F5mqeP6WQAe3Uw68bP1wctOPuADWtFuRp11LoLMEWst/MHvdOT6EATahcUUmsP6pvCLNxZs/ySMsBQgh9CRKHB/IbtqEOXwJp7td8sicAMS90kWht4XIiKIqetpnhOlgskAlB9GaHZ0A0kGrCsDq0GSbpIh+ygvHXBcTHcBFPMrfOiA9gdAWkUyJJONx4yU1Dxh5//rskSxuTND53+LU5BFsgkdUWlkbqDGqmLz7a7xxcaDlag0euv5p4W7GRUyCBMpT4d4wH4CZbDuBjA5reF8JfjulI+V6PFCx2tLqAjohmv259OSlagDuCu1E9QVpFRAAzzDYKgsVRa+2o6hw0QU/Kc5t2RYIqBQeR0nCbWZyhKgxOdhweqBPRJgA3513V2qseg/VfulWHcx4Tug3CjLeu3 2025-08-14 22:40:05 [INFO]: item found in queue is if condition 14409 2025-08-14 22:40:05 [INFO]: item found in queue is 14409 2025-08-14 22:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBtyPjbGMiuk/44xcOOBRc4Z3xsDQkM67w2bDTn/im4QCTvniDHgwx2RSzEVyGPup7fwmMzpdkkm8MWACCKaPsy0x/auAUnK+umodMbDcFP6ntJXrx9Iffua9FNFprawCPmZ479Zi9dAa1a0Bi5pHevyAOmpL4ntwa8QhROm6fQpQQhgLQfgavK9w4h8A2pmBHSUvsqw0JQkWM9porZUrEaB/5o1oiPV2yAykLeD21ZvKRIpVf8/bnTINcvfwae0WmgMvFUz6zwUqM5n7KT4KiZqt0L2TVEGUkWBngOj6nqKSrqKSdYYpJMDZx+K6Y6aZ+fG/a3QIpna6r4/DvQUtMpHlgXTgN/QdT5JF88yen4tKcQLQVqSVAy4j6Xyu6jEd4SiwcLYVmfcdMcIT6gXgd6xRV/vS/1CEMcmA5no381TzhSxCw3iXV7/kEN2ce0WJV 2025-08-14 22:40:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-14 22:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 22:40:05 [INFO]: inside itemsold and closed 14409 2025-08-14 22:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:40:07 [INFO]: Ebay item id :: 226490301085 exists in Database 2025-08-14 22:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-14 22:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-14 22:40:07 [INFO]: inside itemsold and closed 14409 2025-08-14 22:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:40:09 [INFO]: Ebay item id :: 336125093888 exists in Database 2025-08-14 22:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:40:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-14 22:40:09 [INFO]: inside itemsold and closed 14409 2025-08-14 22:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:40:11 [INFO]: Ebay item id :: 286097822045 exists in Database 2025-08-14 22:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:40:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-14 22:40:11 [INFO]: inside itemsold and closed 14409 2025-08-14 22:40:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:40:13 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:40:13 [INFO]: Ebay item id :: 286732541742 exists in Database 2025-08-14 22:40:13 [INFO]: Item is reliested :: exists in Database 2025-08-14 22:40:13 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-14 22:40:13 [INFO]: in processold action queue is array for {"44736340":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736340","ebayitemid":"226490301085","shopifyproductid":"8760020173022","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8760020173022","shopifyvariantid":"46139544699102","shopifyinventoryid":"48238774550750","shopifylocationid":"","product_id":"44736340","variant_id":"77644277","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45314481":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45314481","ebayitemid":"336125093888","deleted":1}},"45144580":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45144580","ebayitemid":"286097822045","deleted":1}},"45301260":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45301260","ebayitemid":"286732541742","deleted":1}}} 2025-08-14 22:40:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-14 22:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-14 22:40:13 [INFO]: productIds WHich are having null productid -> [45314481,45144580,45301260] 2025-08-14 22:40:13 [INFO]: ebayItemIds WHich are not imported-> ["336125093888","286097822045","286732541742"] 2025-08-14 22:40:13 [INFO]: Entered in bulkUpdateProducts function 2025-08-14 22:40:13 [INFO]: Transaction started for bulkUpdateProducts 2025-08-14 22:40:13 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45314481,45144580,45301260) 2025-08-14 22:40:13 [INFO]: Query executed successfully. Affected rows: 0 2025-08-14 22:40:13 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-14 22:40:13 [INFO]: Transaction committed successfully. 2025-08-14 22:40:13 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-14 22:40:13 [INFO]: Shopify Inventory id 48238774550750 2025-08-14 22:40:13 [INFO]: Shopify Location id 58450641063 2025-08-14 22:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-14 22:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-14 22:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-14 22:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736340 and user_id = 14409 2025-08-14 22:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644277 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-14 22:40:13 [INFO]: updateIdsQuantity -> ["77644277"] 2025-08-14 22:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0 2025-08-14 22:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644277 THEN 0 END, quantityflag = CASE WHEN id = 77644277 THEN 0 END WHERE user_id = 14409 AND id IN (77644277) 2025-08-14 22:40:13 [INFO]: QUANTITY Updated IDs: 2025-08-14 22:40:13 [INFO]: Successfully processed data for user 14409 2025-08-14 22:40:13 [INFO]: Execution Started 2025-08-14 22:40:13 [INFO]: Execution Finished 2025-08-14 22:50:01 [INFO]: Execution Started 2025-08-14 22:50:01 [INFO]: old server sucessfully connected 2025-08-14 22:50:02 [INFO]: sqs client sucess created 2025-08-14 22:50:03 [INFO]: Number of messages in the queue: 1 2025-08-14 22:50:03 [INFO]: item found in queue is if condition 14409 2025-08-14 22:50:03 [INFO]: item found in queue is 14409 2025-08-14 22:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBOP91/fJ2G2iZOnVQAtcEjqOYkvGOWPbUxjM1iZ7ihDLRDPIz8JF6hkkfpS3h7Qu3WeRiDcjRCo2WzqoODf8UmiFPebUsbAGRZ6dIGgUehCW9PPyzUAVCfvwYWoGnyevIuCYDcAYRNR/WxAr2r0b/xcrxQzGfNYfxmN6uw7T8YvwXD4WdaoKuR//5MMkABAy8IfmpwgUHqWiYu3fKZAwb17Lg88oeo+MoT0+Eojdozf/s90Nqaa42nkjkAnf8AXcyggFNGE96QIZxABKbfsUxyfhHvW+RyRhgr311vtS50WO+zkBPrkhh2oDYT+4PKQh4Ys7Jx8SL7RfhJYyNS7R89kQAgdWMMzDFhOtZgEt7etK33WEPd7s2vefWkEkUBcieYylDE7hGNeLGEnQ3P8GD9r1+xGmCI7CeJnZBFhR1QOcgzidVZHlI/XWEumQLsz9W 2025-08-14 22:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-14 22:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-14 22:50:03 [INFO]: inside itemsold and closed 14409 2025-08-14 22:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-14 22:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-14 22:50:05 [INFO]: not in db for user_id 14409 and the ebayitemid306421893975 2025-08-14 22:50:05 [INFO]: in processold action queue is array for [] 2025-08-14 22:50:05 [INFO]: Successfully processed data for user 14409 2025-08-14 22:50:05 [INFO]: Execution Started 2025-08-14 22:50:05 [INFO]: Execution Finished