2025-08-12 19:00:01 [INFO]: Execution Started 2025-08-12 19:00:01 [INFO]: old server sucessfully connected 2025-08-12 19:00:01 [INFO]: sqs client sucess created 2025-08-12 19:00:02 [INFO]: Number of messages in the queue: 1 2025-08-12 19:00:02 [INFO]: item found in queue is if condition 14409 2025-08-12 19:00:02 [INFO]: item found in queue is 14409 2025-08-12 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBUM0NdyZRr/MpSuioFYwMa39Ins4BNxPsFa7rEzzDp3hh8w7IagfxJ6hESFAJ2zaUHVyRWaV6XGUFJkrPtrYfqXpg9DA4pAHgLviLKCQ0UjHI1JeQgeke0dZGH6q4+JZko5kWRb1v3ZwGSfj2LQ9SGnmjkpSIV5v/oWcwF9gX4sBlRqkQ3f98c/6Fp77P4Rjt+xBf4MOJbnDTHLDnzxjaZVD0zeoqGrq4sqw2f1L3FQnDyRvxziN84/7lF/VifzxqaMX/jVyUbafD9EpIVOOeyHecK5WyXGviPtgoWF4nJT1gFv9zuM8kD5SkiPz/nhG+gSYjDdTcvKYja1c+oENW5VeCZjbEKakMo0/h1WlomcMwqSyA0dnWrfcbAxI9xN4tqNMf8KKK7+Xn3DHbe7aGiVevhDpPCNhfGhyBV5TKLX7AJTDT0XH/8v3gwzskGiyd 2025-08-12 19:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 19:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 19:00:03 [INFO]: inside itemsold and closed 14409 2025-08-12 19:00:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:00:04 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:00:04 [INFO]: Ebay item id :: 305996065211 exists in Database 2025-08-12 19:00:04 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:00:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:00:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:00:04 [INFO]: in processold action queue is array for {"44639772":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44639772","ebayitemid":"305996065211","shopifyproductid":"8069552439518","variants":[{"price":"33.99","quantity":0,"weight":"2","shopifyproductid":"8069552439518","shopifyvariantid":"44242866340062","shopifyinventoryid":"46340010148062","shopifylocationid":"","product_id":"44639772","variant_id":"77544961","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 19:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 19:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:00:05 [INFO]: Shopify Inventory id 46340010148062 2025-08-12 19:00:05 [INFO]: Shopify Location id 58450641063 2025-08-12 19:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:00:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 19:00:05 [INFO]: Change: available | Delta: -1 2025-08-12 19:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44639772 and user_id = 14409 2025-08-12 19:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77544961 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:00:05 [INFO]: updateIdsQuantity -> ["77544961"] 2025-08-12 19:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 19:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77544961 THEN 0 END, quantityflag = CASE WHEN id = 77544961 THEN 0 END WHERE user_id = 14409 AND id IN (77544961) 2025-08-12 19:00:05 [INFO]: QUANTITY Updated IDs: 77544961 2025-08-12 19:00:05 [INFO]: Successfully processed data for user 14409 2025-08-12 19:00:05 [INFO]: Execution Started 2025-08-12 19:00:05 [INFO]: Execution Finished 2025-08-12 19:10:01 [INFO]: Execution Started 2025-08-12 19:10:01 [INFO]: old server sucessfully connected 2025-08-12 19:10:01 [INFO]: sqs client sucess created 2025-08-12 19:10:02 [INFO]: Number of messages in the queue: 3 2025-08-12 19:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:10:03 [INFO]: item found in queue is 14409 2025-08-12 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQxpNY+ml+2EkYD8zmUuEriW+zuDrdLNAkiZ/5CawQNbz0bWb1Uh48IL2QM6aRAegAUU9I9dbYDtsUY7qis/esSJa4F9clQjwPcgXrYDIliw6OpcxxIJieLYCAqpRX/I1hnbNnsujA4rMSrV5hHv6lQdmOBm1hRfJn/IpT/CxeD8BT60C2kqItZvrNRguE/T/Jc+uDZSLf0EnklqkXIiHc0lCih5HTFcXkGCf3yuv/iLq+TznylW1pUQKsYnhu1DH0MOM9P8vQhz5U20gHfmk4bXh00pXnLHyGOp6hKLMOWu+L/M7T5b1OzkmuCtPkwGqmkF5XqP2e5UGSIhfECN/2u1tA7fTuUkMH93SoIGgZVvgY5gm238SescJ2+SBFtJ7I7fOM91AYCUa7vEuyIsYV0Y8f2u4Ap5OlndscEcMkHkm1tPAQqJmKuimsEKHBs8W 2025-08-12 19:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:10:03 [INFO]: item found in queue is 14409 2025-08-12 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1RqZZwtpJZgwOFVOYbYPqCUJB2GhJXUZLCLO+FnMZXeEWbJeC7g+WXt00wI9XReeJPEUhA7u29tH670LhFbzSHWsdt49kRc+geOX3RhgBUtQUZ6siMJpxBONDy2zs0jxVFthJAEp3WbZj9c5wY5PJRy0Yw32FuEEgox9Od5j/ctGJWrEpGToU6nmH2yvMmZi3wxrRwwNOjjK3r13ku7g2ZwhSc5dqg0ZdWp1F5g2/ZWW+gPzpJTfz/CP/CEtdiZVDgTenC7WOGP0cM4EwDwCuAxosn29LPzbG+BLvNsxZbbQHSqc3iRq5V7zjVS8/QgIUoTMstLAizyG6DP0Sz7TSglayNiTfs5lYUVKlnN58zwvEXwgxn8ZuJ7zOuVqVLVMMvfdFdA3QDMDS4jJiEKQxvBi5z2d1m7DpjDc6szKaePkDdYkv/omgJdOi1tdDhbb 2025-08-12 19:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:10:03 [INFO]: item found in queue is 14409 2025-08-12 19:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB5YSyiDIF8kaq3o/o27eXr6GDlJujrUr6zMYE4z1gm1xfLNU6VKhiwQF4JLQ+x8hwTN7pQs6AYlgs0RXJK/4dWyWu0rz92s3P1+ar3/pDhCdofsCW0NtPZwU2ni0hotqoXqLdNGJ9ZPxaQiyUMGiYB19oDfnCCzHxD/sz53zsm7M1Jc3B0sYC76BcPtXJMBLcFzG55gfUHqUMHtmzK/SU/0oh6GOwpgbhlU4pUlHqF1sRHHbNhPLZP50B/etiMWd30m+QuRJDkDawT8rMydyifqkqgNMQpGWCUqTU8IN8Jcb/qIFi8571wlhS/AREWcXVt3KJCL0fkInvx2GGI+vYNOiIKoTdRju5N7+CV9RT//aGmQWOT8Td9THutj8Dcx7SHYjVWoDDoxSJIxUHZq+JStfgTOYgVSJZ6ASq5qjQkl6vTQ+1100KAkFoX/VBtNMo 2025-08-12 19:10:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 19:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 19:10:04 [INFO]: inside itemsold and closed 14409 2025-08-12 19:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:10:05 [INFO]: Ebay item id :: 305634265608 exists in Database 2025-08-12 19:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:10:05 [INFO]: inside itemsold and closed 14409 2025-08-12 19:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:10:07 [INFO]: Ebay item id :: 335790798846 exists in Database 2025-08-12 19:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:10:07 [INFO]: inside itemsold and closed 14409 2025-08-12 19:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:10:09 [INFO]: Ebay item id :: 326592086789 exists in Database 2025-08-12 19:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:10:09 [INFO]: in processold action queue is array for {"44585742":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44585742","ebayitemid":"305634265608","shopifyproductid":"7586900771038","variants":[{"price":"94.99","quantity":0,"weight":"3","shopifyproductid":"7586900771038","shopifyvariantid":"42570736140510","shopifyinventoryid":"44664781111518","shopifylocationid":"","product_id":"44585742","variant_id":"77478451","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44598082":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598082","ebayitemid":"335790798846","shopifyproductid":"8703027577054","variants":[{"price":"130.99","quantity":0,"weight":"3","shopifyproductid":"8703027577054","shopifyvariantid":"45953609564382","shopifyinventoryid":"48052211089630","shopifylocationid":"","product_id":"44598082","variant_id":"77490791","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44817051":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44817051","ebayitemid":"326592086789","shopifyproductid":"8926416208094","variants":[{"price":"10.99","quantity":0,"weight":"1","shopifyproductid":"8926416208094","shopifyvariantid":"46838152200414","shopifyinventoryid":"48936641233118","shopifylocationid":"58450641063","product_id":"44817051","variant_id":"77727589","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 19:10:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 19:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:10:09 [INFO]: Shopify Inventory id 44664781111518 2025-08-12 19:10:09 [INFO]: Shopify Location id 58450641063 2025-08-12 19:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:10: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-12 19:10:09 [INFO]: Change: available | Delta: -1 2025-08-12 19:10:09 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44585742 and user_id = 14409 2025-08-12 19:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77478451 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:10:09 [INFO]: Shopify Inventory id 48052211089630 2025-08-12 19:10:09 [INFO]: Shopify Location id 58450641063 2025-08-12 19:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:10:10 [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 19:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598082 and user_id = 14409 2025-08-12 19:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490791 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:10:10 [INFO]: Shopify Inventory id 48936641233118 2025-08-12 19:10:10 [INFO]: Shopify Location id 58450641063 2025-08-12 19:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:10:10Z","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-12 19:10:10 [INFO]: Change: available | Delta: -2 2025-08-12 19:10:10 [INFO]: Change: on_hand | Delta: -2 2025-08-12 19:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44817051 and user_id = 14409 2025-08-12 19:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77727589 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:10:10 [INFO]: updateIdsQuantity -> ["77478451","77490791","77727589"] 2025-08-12 19:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 2 2025-08-12 19:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77478451 THEN 0 WHEN id = 77490791 THEN 0 WHEN id = 77727589 THEN 0 END, quantityflag = CASE WHEN id = 77478451 THEN 0 WHEN id = 77490791 THEN 0 WHEN id = 77727589 THEN 0 END WHERE user_id = 14409 AND id IN (77478451,77490791,77727589) 2025-08-12 19:10:10 [INFO]: QUANTITY Updated IDs: 77478451, 77490791, 77727589 2025-08-12 19:10:10 [INFO]: Successfully processed data for user 14409 2025-08-12 19:10:10 [INFO]: Execution Started 2025-08-12 19:10:10 [INFO]: Execution Finished 2025-08-12 19:20:01 [INFO]: Execution Started 2025-08-12 19:20:01 [INFO]: old server sucessfully connected 2025-08-12 19:20:01 [INFO]: sqs client sucess created 2025-08-12 19:20:02 [INFO]: Number of messages in the queue: 3 2025-08-12 19:20:02 [INFO]: item found in queue is if condition 14409 2025-08-12 19:20:02 [INFO]: item found in queue is 14409 2025-08-12 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBEeZa5getzrHrjUbxZRgQ2J/GhR2XXdb/SjlBJa+eLMeDocuY/n+dKi3U2muO5tSiAfamJeK+vcWqUxD7+lm0q9Z/RkjQiPD1bOLDX2jscqiQnHmMnVCsJOY5SA+jt+h897kQODUfTa+GdD8t6z4d5xS8gd2aV5IjrRDudj+lSCz1NXj2Xh9AuN8LhyVRvNM/77IK58kWYI+V0hVqELDVnYSYwZZ3vYEnindYVvimwHNfXTK0UfnNwjo2BoBz9GWUmrn8k2GuqYesX9cRp1LeJHh8l2ZQKGDCmc23OicXburovbyQovBM9hdUQKOFWfk8ABtpZDR+eBpeJ1YoSNQhlqqESI4jVmcogZ8vBPRGfqFVixFQZ9Qb36D7CewpFQ1Mk+280INZA3EaRmgQXUA9fbe+WX8okQnjTUO1btBj6ey0kD/sNUg7gE4GT3BeKv1u 2025-08-12 19:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:20:03 [INFO]: item found in queue is 14409 2025-08-12 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBo5zjkh7eAIy88FAVIHfbwA/ep+WrT27dBrgPGdrjXWA2SHmfUan7aZotgx6PPLU2UbKBZftK7pEyHdS/B5JwecpB4MOFHew86BfKx4B4vpDzFNhpfrqkCurf4ZuldEBC9yrJTBKgf7bLHx+wIe8O9WpUs0Bjrxdem5iW+QcCRfXrzbw84O8Ca45dCc24O6/4j5MYNZhotx56C801+JqNfgERRQS/fJRzlLqHK8J57XqcrskQonyrtUfc+W53uiGktt6a2icrfvv+/EsABDoYkED+VZ8KtckDRrZrpyHAAeYSdmacdx3qzDwpzMcY02FxAwoGLznizOYfLeuQQvy2OVkrxeYlMd+Og9YKVyl/ulBIO6KCGOxL+QHQY4SiPNotOOCUwzLyQm30RNpEt6nD82eUOtXLPtBCERmdcbxzIeZ1v7jW/fRgAq6gAx1F5+KB 2025-08-12 19:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:20:03 [INFO]: item found in queue is 14409 2025-08-12 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBYhsoIGnnVsKkE5WVDmovX0PbWQ1tAYjGb/06bUfjCRhmRVFwAZXFWZkTUpIGWKx34CMgGVmy3hg0Iv0mnGbnMW/HCwbdCqOOuYLTlggdMs0PbU4UINDHaiOnDTEom5sHHSObQ1Fi56eNfmYTVxeFa78xdVL0pXE4+Lb2vM5FqfUA+7jvmiUsoqJFfbezk7FGvVN+FOBY77ATw+ajmwhlXZ4D/o6Tk/zOorpyIxJaXgtDHaYo8iasyb4UZkF2BEJssTTI7r9/DfFQdbxSVTMqUvwN+Xga71LM7OpmhnysAwsBwgsfYBN6GlFTt1OJWmygbCw00OW887wwp9iJeedQ9wCgIqyAIxB+seyJoBN2sTMDVP2YwCWGg1rR8IpEJiRB3sRhv1ieAiIFZTx0i8aIJlqoYCE1tHZiiHhxxljPrZT5i5NIzgRUlcLZ8E45P+fl 2025-08-12 19:20:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 19:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 19:20:04 [INFO]: inside itemsold and closed 14409 2025-08-12 19:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:20:05 [INFO]: Ebay item id :: 326675018837 exists in Database 2025-08-12 19:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 19:20:05 [INFO]: inside itemsold and closed 14409 2025-08-12 19:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:20:07 [INFO]: Ebay item id :: 335674274107 exists in Database 2025-08-12 19:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:20:07 [INFO]: inside itemsold and closed 14409 2025-08-12 19:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:20:09 [INFO]: Ebay item id :: 326288360842 exists in Database 2025-08-12 19:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:20:09 [INFO]: in processold action queue is array for {"45196939":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45196939","ebayitemid":"326675018837","deleted":1}},"44572405":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572405","ebayitemid":"335674274107","shopifyproductid":"8735773524190","variants":[{"price":"60.99","quantity":0,"weight":"2","shopifyproductid":"8735773524190","shopifyvariantid":"46050205204702","shopifyinventoryid":"48148928921822","shopifylocationid":"","product_id":"44572405","variant_id":"77465089","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 19:20:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 19:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:20:09 [INFO]: productIds WHich are having null productid -> [45196939] 2025-08-12 19:20:09 [INFO]: ebayItemIds WHich are not imported-> ["326675018837"] 2025-08-12 19:20:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 19:20:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 19:20:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45196939) 2025-08-12 19:20:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 19:20:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 19:20:09 [INFO]: Transaction committed successfully. 2025-08-12 19:20:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 19:20:09 [INFO]: Shopify Inventory id 48148928921822 2025-08-12 19:20:09 [INFO]: Shopify Location id 58450641063 2025-08-12 19:20:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:20:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:20: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-12 19:20:09 [INFO]: Change: available | Delta: -1 2025-08-12 19:20:09 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:20:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:20:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572405 and user_id = 14409 2025-08-12 19:20:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465089 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:20:09 [INFO]: updateIdsQuantity -> ["77465089"] 2025-08-12 19:20:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 19:20:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77465089 THEN 0 END, quantityflag = CASE WHEN id = 77465089 THEN 0 END WHERE user_id = 14409 AND id IN (77465089) 2025-08-12 19:20:09 [INFO]: QUANTITY Updated IDs: 77465089 2025-08-12 19:20:09 [INFO]: Successfully processed data for user 14409 2025-08-12 19:20:09 [INFO]: Execution Started 2025-08-12 19:20:09 [INFO]: Execution Finished 2025-08-12 19:30:01 [INFO]: Execution Started 2025-08-12 19:30:01 [INFO]: old server sucessfully connected 2025-08-12 19:30:01 [INFO]: sqs client sucess created 2025-08-12 19:30:02 [INFO]: Number of messages in the queue: 1 2025-08-12 19:30:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:30:03 [INFO]: item found in queue is 14409 2025-08-12 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBt+Wq9yNB9oNZ00jdIMfYN4utpwFD2Ud+1G9XJTGU86ug12+ed917Kes2NJwQx9RNVwZEc/r2XtLpKYd0hovBrIIPzmPHuZfOlgjKk1yzWxP5uK3vXRfeV7P9wiVtAiWF3vI33GnjGdDAoLWPN1YfX+VOEIx+5tSjn86+w6nIiKeVoxRwgaF75nTgr2SkJXaKEIBRBIHopDVFQAMUA41V8vbVztD1MRn5tmx17+0LpdAGdq2jLB6JdDiMqYpnfqQYU0g+JNId11OfD6bg46Fb13EVP3FiVeZQEewE/MJmv4+OYNlly9mKfg5JgwuOdIFnC3AKIErJ0ywQwz7Ki5Ce7aM5Yy94AjfP7SQrv15mI2PowhFWbPrhAPGWOXyHP3I/cnmsldzEm2jM9Hz9Y7cACPdDHnJVQ4DXyDopS3e4Yn/XXiwvpfuWQZkVaJ9su/I6 2025-08-12 19:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 19:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 19:30:03 [INFO]: inside itemsold and closed 14409 2025-08-12 19:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:30:05 [INFO]: Ebay item id :: 335401503367 exists in Database 2025-08-12 19:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:30:05 [INFO]: in processold action queue is array for {"44583014":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44583014","ebayitemid":"335401503367","shopifyproductid":"8492578210014","variants":[{"price":"53.99","quantity":0,"weight":"2","shopifyproductid":"8492578210014","shopifyvariantid":"45396249411806","shopifyinventoryid":"47494225985758","shopifylocationid":"","product_id":"44583014","variant_id":"77475723","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 19:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 19:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:30:05 [INFO]: Shopify Inventory id 47494225985758 2025-08-12 19:30:05 [INFO]: Shopify Location id 58450641063 2025-08-12 19:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:30: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 19:30:05 [INFO]: Change: available | Delta: -1 2025-08-12 19:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44583014 and user_id = 14409 2025-08-12 19:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475723 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:30:05 [INFO]: updateIdsQuantity -> ["77475723"] 2025-08-12 19:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 19:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77475723 THEN 0 END, quantityflag = CASE WHEN id = 77475723 THEN 0 END WHERE user_id = 14409 AND id IN (77475723) 2025-08-12 19:30:05 [INFO]: QUANTITY Updated IDs: 77475723 2025-08-12 19:30:05 [INFO]: Successfully processed data for user 14409 2025-08-12 19:30:05 [INFO]: Execution Started 2025-08-12 19:30:05 [INFO]: Execution Finished 2025-08-12 19:40:01 [INFO]: Execution Started 2025-08-12 19:40:01 [INFO]: old server sucessfully connected 2025-08-12 19:40:01 [INFO]: sqs client sucess created 2025-08-12 19:40:02 [INFO]: Number of messages in the queue: 3 2025-08-12 19:40:02 [INFO]: item found in queue is if condition 14409 2025-08-12 19:40:02 [INFO]: item found in queue is 14409 2025-08-12 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNIQ3ogLqnlPPoNob9Z2TERpkCYtK866l1NjN7zhte19KYCs7TEZuuIIWNf3KUkB9hJrrRG+0Yn2Q+eMdfos/G8wmd6qoIx6jkCk8v1wEHeIbzygj3UT1IxzLYaR5u9Yl/hzaVH812ssuc3J/J2/7fq+NaIe8zDI4JuFxvlwnyUAVuqEb7B+zwXog35JXfYR5SV6uSJudlhWDGCBHLPZUZKw4LpCcmKsjZMpagmitCV/B+Z8srzW5JkdMR3KniD5GjyetTyH9Bl3X9uQkq8BW/N8yFfVeiz9/Om06leAs+OFndes9GbXwIp0gkaaQJ2ILsqx2B0AGY+C1/BqQCPOO+aLEpyUmn0bYBv08D4UYFJN9b79KdgxtnsqeSA0lEsn9Jz4YyND5G10kN64HmcYUHI8Z7kcdKycdGmb2/mXz51QHD7N67u/ipOptiU3pi3z6 2025-08-12 19:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:40:03 [INFO]: item found in queue is 14409 2025-08-12 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBkVnIS73w2QYOavfNj+jLXNJwS67aX4u/3/MD+tdT/X5n0q6oM8rf/8wqItuE3bS9cHBBDkxSnfF+72KXwcLimx/lrwTieV/42LwKfvhlRErEO1l5M6rEKsH1yvrOHF2LPu+t1eCsMVWk3OypDK/A6eAbIxL1I+06jUrT6ln1LRxGQ1YvTNE3PpHckpi8LqvVQ+uwER7ymG5B6EiTNEDoXUUs0CU+BO6WQkNmWnsn3uiVATmyPltsKvmHlA/vT71Orf6t1oO6g/xQeiPHH+Gmqi2vrfTVNXGcbGSES/U5sUsqh4EnahPljxS2dw36Z8TrliYdVsbCdwEAukRZ2RaLQY7QevMTYILjSSNNSw4tFRS2tWMFb/9/rlC5HOyGFEFRB3/5Ksdt8Q1gAEyL9j6NOR1RZhRxWT5f7kL4bBhpVNB5RdsHBN/gmYsAefTGxMQN 2025-08-12 19:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:40:03 [INFO]: item found in queue is 14409 2025-08-12 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBP+5s/qrbCUtFGxofae8zIYCTjns/TPxTCzEh2Pp1PTrHnO907oML9lVLxXpA7DFSKBS5TDTn3FUDAJADm+mEy0WikrbbwLgVYxalgsh8wC8QM60FLZCUOSXtITFqbuffpQ0HDSKk8Ep6M71TzJs/heiBKAVL51qL4Sst7LAQFJ0o7CKbV0tK5aDjnnktey2eE7pCklmzT4STm54Kmsd1ZQW4gkBXgQugoKzTaIqn8ptwirsnTnfO4//y099Jf/G0kc90Q6JJ1ub86oN6uVzWe0esTngRN1f13IBWo6Pz4xlLWafjYsyG7BGgBXVwa13cxsdoHJAMtCdiiW3wAxcoarprpI1QY6TRRK1ggfvUpVjXSA2u7hiLxBvAuN6DJzc/TyjYqsBJbZOAXv+YMHMYf5qwZHFWjIThQBnDFOqJdE0LAIzxSs5hAIR14vwKHvXv 2025-08-12 19:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 19:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 19:40:04 [INFO]: inside itemsold and closed 14409 2025-08-12 19:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:40:05 [INFO]: Ebay item id :: 285991161127 exists in Database 2025-08-12 19:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:40:05 [INFO]: inside itemsold and closed 14409 2025-08-12 19:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:40:08 [INFO]: Ebay item id :: 286159824760 exists in Database 2025-08-12 19:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:40:08 [INFO]: inside itemsold and closed 14409 2025-08-12 19:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:40:09 [INFO]: Ebay item id :: 335999566451 exists in Database 2025-08-12 19:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:40:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 19:40:09 [INFO]: in processold action queue is array for {"44600560":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600560","ebayitemid":"285991161127","shopifyproductid":"8697459769566","variants":[{"price":"32.99","quantity":0,"weight":"2","shopifyproductid":"8697459769566","shopifyvariantid":"45939230802142","shopifyinventoryid":"48037687263454","shopifylocationid":"","product_id":"44600560","variant_id":"77493269","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44569723":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569723","ebayitemid":"286159824760","shopifyproductid":"7559453802718","variants":[{"price":"47.99","quantity":0,"weight":"2","shopifyproductid":"7559453802718","shopifyvariantid":"42473288761566","shopifyinventoryid":"44567282286814","shopifylocationid":"","product_id":"44569723","variant_id":"77462407","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45113470":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113470","ebayitemid":"335999566451","deleted":1}}} 2025-08-12 19:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:40:09 [INFO]: productIds WHich are having null productid -> [45113470] 2025-08-12 19:40:09 [INFO]: ebayItemIds WHich are not imported-> ["335999566451"] 2025-08-12 19:40:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 19:40:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 19:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113470) 2025-08-12 19:40:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 19:40:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 19:40:09 [INFO]: Transaction committed successfully. 2025-08-12 19:40:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 19:40:09 [INFO]: Shopify Inventory id 48037687263454 2025-08-12 19:40:09 [INFO]: Shopify Location id 58450641063 2025-08-12 19:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:40: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-12 19:40:10 [INFO]: Change: available | Delta: -1 2025-08-12 19:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600560 and user_id = 14409 2025-08-12 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77493269 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:40:10 [INFO]: Shopify Inventory id 44567282286814 2025-08-12 19:40:10 [INFO]: Shopify Location id 58450641063 2025-08-12 19:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:40: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-12 19:40:10 [INFO]: Change: available | Delta: -1 2025-08-12 19:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569723 and user_id = 14409 2025-08-12 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462407 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:40:10 [INFO]: updateIdsQuantity -> ["77493269","77462407"] 2025-08-12 19:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 19:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77493269 THEN 0 WHEN id = 77462407 THEN 0 END, quantityflag = CASE WHEN id = 77493269 THEN 0 WHEN id = 77462407 THEN 0 END WHERE user_id = 14409 AND id IN (77493269,77462407) 2025-08-12 19:40:10 [INFO]: QUANTITY Updated IDs: 77493269, 77462407 2025-08-12 19:40:10 [INFO]: Successfully processed data for user 14409 2025-08-12 19:40:10 [INFO]: Execution Started 2025-08-12 19:40:10 [INFO]: Execution Finished 2025-08-12 19:50:01 [INFO]: Execution Started 2025-08-12 19:50:01 [INFO]: old server sucessfully connected 2025-08-12 19:50:01 [INFO]: sqs client sucess created 2025-08-12 19:50:03 [INFO]: Number of messages in the queue: 4 2025-08-12 19:50:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:50:03 [INFO]: item found in queue is 14409 2025-08-12 19:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBqX91GASEJX7KsRYYJWVzlDEegJgqigaA+8BoQB0d3kCEevZp+dYM1fcjoEJW+c2j82E/qP6jdOdxNrpiBoRvGxnbvffchusZQH2RCWtBl8M4uRlQM4L5y09arEdwnZfS5yQMIrtwv7ocYdReIgF9iKaG3lEniyrDm11Vq5NFswgKaFIweroNQp6Nl243S8qNdFfacbMdG/UWTmN8XUlebkHZZRw9RQhXgI6bh1bmefjSLm+AqWXdVAzsfa57e2LNQ/gL5Xwd0pJ6w77C/U3VQdPKlRCN162eU+/yIAqCsgOG4X4bwp+Zzrl0gUtgyrg78qbR6cbe8cwb/9aDEpeCk+rrpJYZXA26sOVxb3SP8vZo+0zvEbysvxEpHCkjnjVNNX3rpjQ9J1/bhghPmqP/vwJvLQBzPlF9CkXDBJq6TlHqAniGSsXX0p7vf9gW91TE 2025-08-12 19:50:03 [INFO]: item found in queue is if condition 14409 2025-08-12 19:50:03 [INFO]: item found in queue is 14409 2025-08-12 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB7IjJTK2wIgVa4MOl3JkwrSTwM/m4rXgGCDlNtYS3x2lpIxwjudQu+nCl3qsJeGvz4Y2XD7qWEFBq9kj4DVnf0edHfVFKlqrXZzWRgoH3PFK9LnxMlmEPkX9KIxOAjWHgV6Vhx0sl2wyQJSPvJRT3OeCzmLrXdYWVT19y2QnxedlSufq5iQ/3YhlJBFUJAtfM/KZksBGulfk91vKk0+b3lM7+tk1Tiqck+d2ZuB8Z3UVeY2jI3vr24ncSp+nInvJbxg4rLk9PJaLP/IsajCvBIhiJaMDdrRLm0M0Xb9pYbz/F0OSNL4CpKL6sNkTZnxQ1VJ6PyViBgbzGMOGHEX7tG7n88WzgJl7vBh5sTHXRDfjmv6TQqryEiVastl8qrWBn1HyIhzOIzKBmbFw/16xJ6uRfknA/KnASzu2KL9qYtb+xjmuxv7MYIpjAMVqzsXmt 2025-08-12 19:50:04 [INFO]: item found in queue is if condition 14409 2025-08-12 19:50:04 [INFO]: item found in queue is 14409 2025-08-12 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB9bmMBiWIt3ST47N0BQxXLedg0L+uLtO70ktS+VArzs1QcXWYV+aTXVjYAysSB4+mttVc5sX9DHTNJl1LlNm16aa3vDvd0u5zK5r+cjaA5j2OIXDkej93HBWiEfmrR+Xf5lM7fpS7vagkPvj2T0UGNckuXtpD6x1Vcg0RTqFjbOfBTtQE/jdU+qIArTY6DOtL9UBlO0n/DZ3cvrIaLUu18ePTEiFhN+Ezx6Q8NoGdAy5P6LRWC21k0uZs6hWMZrqFX075SggJiw3c6OxV3sJ1DFuX08o6PN3hb6BmSv2OMAuhsJut0IvOQld2APg3MF9DxJ3bYpjBnAulg36qNQGB7rtQh+UFoF6C58238I7XzdIRc5oN1qSv0EFhBiSYfGcrjv9A+FxCLZ8VD+I5E4mIhFc8qKPoDt+3lOeW9jf1DGrqjjt4HdibDruPGAEXg1Hv 2025-08-12 19:50:04 [INFO]: item found in queue is if condition 14409 2025-08-12 19:50:04 [INFO]: item found in queue is 14409 2025-08-12 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBPfaFh413ZYKqIyVhlgEkcRy8BdpOsagRD3Hgu0O4PuMbWSgLa0CebJ69iMCgwXvvb/UFWzTMP6jwZxhz+kyzdAh5Q8hryb4w77LIiN1xi6Fr+2dSjWBxs33GB8O9fcZurxl46pDjOQHaZpI6bl+qgJ5CLZax0w2WzOdfYnIgyC1ZFKkjFXrmnkmbG64Ae7IejU1IPdxO11bWp1XTYBQrnby4+uKj8jjUDCcldynmT9nNkeuaqFAjUmjiI4RtPSYfajynnjpmE67Fvhz6KMQa4kTkN+AyroLIbWQYyhmoxP4rCP8FSLFwnsh4JSahEcR7uicxrSwi8iRNkmLnEN6Sp5dmKZNVUWC9z8mLyKjT1gn+WFbY3Ath256yOXhek1RudvMesvR5BQF2kF5O4w6fKQafCws8T2pq7zsQfliQ1UrNoyBsFVTbWbWdAG67vuKM 2025-08-12 19:50:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-12 19:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 19:50:04 [INFO]: inside itemsold and closed 14409 2025-08-12 19:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:50:06 [INFO]: Ebay item id :: 286197140439 exists in Database 2025-08-12 19:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:50:06 [INFO]: inside itemsold and closed 14409 2025-08-12 19:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:50:09 [INFO]: Ebay item id :: 305753666860 exists in Database 2025-08-12 19:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:50:09 [INFO]: inside itemsold and closed 14409 2025-08-12 19:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:50:10 [INFO]: Ebay item id :: 286207143323 exists in Database 2025-08-12 19:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 19:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 19:50:10 [INFO]: inside itemsold and closed 14409 2025-08-12 19:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 19:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-12 19:50:12 [INFO]: Ebay item id :: 286693784942 exists in Database 2025-08-12 19:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-12 19:50:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 19:50:12 [INFO]: in processold action queue is array for {"44555521":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555521","ebayitemid":"286197140439","shopifyproductid":"8753373216990","variants":[{"price":"40.99","quantity":0,"weight":"2","shopifyproductid":"8753373216990","shopifyvariantid":"46122711613662","shopifyinventoryid":"48221813047518","shopifylocationid":"","product_id":"44555521","variant_id":"77448201","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595311":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595311","ebayitemid":"305753666860","shopifyproductid":"8696101667038","variants":[{"price":"45.99","quantity":0,"weight":"2","shopifyproductid":"8696101667038","shopifyvariantid":"45936208183518","shopifyinventoryid":"48034657140958","shopifylocationid":"","product_id":"44595311","variant_id":"77488020","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44565354":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44565354","ebayitemid":"286207143323","shopifyproductid":"7662338015454","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7662338015454","shopifyvariantid":"42842019791070","shopifyinventoryid":"44936640200926","shopifylocationid":"","product_id":"44565354","variant_id":"77458034","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45197432":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45197432","ebayitemid":"286693784942","deleted":1}}} 2025-08-12 19:50:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 19:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 19:50:12 [INFO]: productIds WHich are having null productid -> [45197432] 2025-08-12 19:50:12 [INFO]: ebayItemIds WHich are not imported-> ["286693784942"] 2025-08-12 19:50:12 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 19:50:12 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 19:50:12 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45197432) 2025-08-12 19:50:12 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 19:50:12 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 19:50:12 [INFO]: Transaction committed successfully. 2025-08-12 19:50:12 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 19:50:12 [INFO]: Shopify Inventory id 48221813047518 2025-08-12 19:50:12 [INFO]: Shopify Location id 58450641063 2025-08-12 19:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:50: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-12 19:50:12 [INFO]: Change: available | Delta: -1 2025-08-12 19:50:12 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555521 and user_id = 14409 2025-08-12 19:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448201 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:50:12 [INFO]: Shopify Inventory id 48034657140958 2025-08-12 19:50:12 [INFO]: Shopify Location id 58450641063 2025-08-12 19:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T19:50: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 19:50:13 [INFO]: Change: available | Delta: -1 2025-08-12 19:50:13 [INFO]: Change: on_hand | Delta: -1 2025-08-12 19:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595311 and user_id = 14409 2025-08-12 19:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488020 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:50:13 [INFO]: Shopify Inventory id 44936640200926 2025-08-12 19:50:13 [INFO]: Shopify Location id 58450641063 2025-08-12 19:50:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 19:50: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-12 19:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 19:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44565354 and user_id = 14409 2025-08-12 19:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458034 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 19:50:13 [INFO]: updateIdsQuantity -> ["77448201","77488020","77458034"] 2025-08-12 19:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-12 19:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77448201 THEN 0 WHEN id = 77488020 THEN 0 WHEN id = 77458034 THEN 0 END, quantityflag = CASE WHEN id = 77448201 THEN 0 WHEN id = 77488020 THEN 0 WHEN id = 77458034 THEN 0 END WHERE user_id = 14409 AND id IN (77448201,77488020,77458034) 2025-08-12 19:50:13 [INFO]: QUANTITY Updated IDs: 77448201, 77488020, 77458034 2025-08-12 19:50:13 [INFO]: Successfully processed data for user 14409 2025-08-12 19:50:13 [INFO]: Execution Started 2025-08-12 19:50:13 [INFO]: Execution Finished