2025-08-11 18:00:02 [INFO]: Execution Started 2025-08-11 18:00:02 [INFO]: old server sucessfully connected 2025-08-11 18:00:02 [INFO]: sqs client sucess created 2025-08-11 18:00:04 [INFO]: Number of messages in the queue: 2 2025-08-11 18:00:04 [INFO]: item found in queue is if condition 14409 2025-08-11 18:00:04 [INFO]: item found in queue is 14409 2025-08-11 18:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBaZP7fmdYqi7+1nhN2X9T2pI3L2B2S5IHRKgVYHbsf4hMrXXi9k2UQXzDk4+MnW3wx6Cmi+Rt9Ip8i+iCXRuQFvm7PQKIUMmQX8jIeE/npQ0afRpoBwUZmhiMxUyTZq4Z8hOCsYIl3O+Knwc4tDDwv344kYTDmLcYverNXCIhoz8nHq5oXTjLS0pHI+8ZrRobyTQ+KTTglYTKkqQroA2gTtx0fXsE0FG0rvxSuNWgzLK5OnO4t/jfAK1lzblZBX6kkptXnUAKY4ohSrU258XLdOqo1x/QQYzoRht+IWmqb2aNTZ4tFNe1gK8Zh++dwvwSQJIIax7JYs5WpRNpltNCgmWSMVAnMK2cxG8RHuivsyDc5J1i+H//T9/mXm5wtyM4AjWRKXQG38HLVTHVBngKss8C4fWVCI/Ed59tqbnGF05gxqtgV7b25vbS7v4/2pFV 2025-08-11 18:00:05 [INFO]: item found in queue is if condition 14409 2025-08-11 18:00:05 [INFO]: item found in queue is 14409 2025-08-11 18:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBq5jHgtqo+Pqxg7P4q/i90F6zURksbgi0R/517YCvQXPd9iad9YH5knkoHhG6uTNxSLIGiarB4OIrbrsqorT4IpniT1gzsMZgRAQfZtZwNRyasf90on/b8ba8Vc5tLa8eqTM39P2UsLj3g9EcZc3x9LaXt5Q2PKqJA3EDq6u/0/PICvW4fiP6zgENceiuBjk6U2GaZQeJ4SwSUuqz/I5CrDawCo7TtdGlTJFPOTnqPVM8oBPCsdwlS7ZVqb1aqzGO1fVHJRq1/Sw3FRx1jl4SrqaACwosPgCunJAz1QfdYzcUCmwKX1BUHCYZtqXeobdrANlC1sPpIQGmh/sYO+IU1m8tN+xgONPcp4SJQq+7wsxodAhtwsC+bT0DU0jyoSYc0Ycya5KKdxa8GsXrmuSAmsDqg+8ta7+vXJMbYw7VdxTJVfHz+4szh0eWoNkmQ+O7 2025-08-11 18:00:06 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-11 18:00:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 18:00:06 [INFO]: inside itemsold and closed 14409 2025-08-11 18:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:00:07 [INFO]: Ebay item id :: 226726548856 exists in Database 2025-08-11 18:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:00:07 [INFO]: inside itemsold and closed 14409 2025-08-11 18:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:00:10 [INFO]: Ebay item id :: 286089796128 exists in Database 2025-08-11 18:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:00:10 [INFO]: in processold action queue is array for {"44685490":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44685490","ebayitemid":"226726548856","shopifyproductid":"7674769604830","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7674769604830","shopifyvariantid":"42897849319646","shopifyinventoryid":"44992703758558","shopifylocationid":"","product_id":"44685490","variant_id":"77590715","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44775797":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775797","ebayitemid":"286089796128","shopifyproductid":"8694878470366","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8694878470366","shopifyvariantid":"45933505806558","shopifyinventoryid":"48031956762846","shopifylocationid":"","product_id":"44775797","variant_id":"77684339","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 18:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 18:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:00:10 [INFO]: Shopify Inventory id 44992703758558 2025-08-11 18:00:10 [INFO]: Shopify Location id 58450641063 2025-08-11 18:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T18:00: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-11 18:00:10 [INFO]: Change: available | Delta: -1 2025-08-11 18:00:10 [INFO]: Change: on_hand | Delta: -1 2025-08-11 18:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44685490 and user_id = 14409 2025-08-11 18:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590715 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:00:10 [INFO]: Shopify Inventory id 48031956762846 2025-08-11 18:00:10 [INFO]: Shopify Location id 58450641063 2025-08-11 18:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T18:00: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-11 18:00:10 [INFO]: Change: available | Delta: -1 2025-08-11 18:00:10 [INFO]: Change: on_hand | Delta: -1 2025-08-11 18:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775797 and user_id = 14409 2025-08-11 18:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684339 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:00:10 [INFO]: updateIdsQuantity -> ["77590715","77684339"] 2025-08-11 18:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 18:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77590715 THEN 0 WHEN id = 77684339 THEN 0 END, quantityflag = CASE WHEN id = 77590715 THEN 0 WHEN id = 77684339 THEN 0 END WHERE user_id = 14409 AND id IN (77590715,77684339) 2025-08-11 18:00:10 [INFO]: QUANTITY Updated IDs: 77590715, 77684339 2025-08-11 18:00:10 [INFO]: Successfully processed data for user 14409 2025-08-11 18:00:10 [INFO]: Execution Started 2025-08-11 18:00:10 [INFO]: Execution Finished 2025-08-11 18:10:01 [INFO]: Execution Started 2025-08-11 18:10:01 [INFO]: old server sucessfully connected 2025-08-11 18:10:01 [INFO]: sqs client sucess created 2025-08-11 18:10:03 [INFO]: Number of messages in the queue: 1 2025-08-11 18:10:04 [INFO]: item found in queue is if condition 14409 2025-08-11 18:10:04 [INFO]: item found in queue is 14409 2025-08-11 18:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBODL0gWspN9gf5mn19AbbYocgKy9zoc/yiHHjYkSbGNFpSv1+YroNkKAKPsNXHTCx58ApkNY7bPBdIP0h7FPRtNnIepQBmcw0PxshIr7u/4ygSYhO4gtfffZdd3V27qqD2EbPEHzm8vkyFtS3PwhsuhMhH+fuZEMPGnxiu+ug+qxWRTW1fBfaYD8UiQB+lXmoYm8fgGGL4t9yxeT6yTRK1OGmEub5JSdRUU5e5daJr4vmg7YjL7gCiCWCNyUAmGybWIHPpiAorx6e4Oux7pwIPMjKv5iLYuCYrrOZLkNBBqHmLwXoiyFceACmsJ32T7yYx3b2rMzHGDJNXBFuHce6VGwwlTXHyCjHwZHeut0m4/yeiVkPGgd79zLWiHqsZnU2R7f6BMAUM0aZgljnzQeGk9WOlBxYUSu8WHYd9frh1nSLU4xQDTzI74Q3ISMGzxHY 2025-08-11 18:10:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 18:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 18:10:04 [INFO]: inside itemsold and closed 14409 2025-08-11 18:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:10:06 [INFO]: Ebay item id :: 404814674312 exists in Database 2025-08-11 18:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:10:06 [INFO]: in processold action queue is array for {"44670303":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670303","ebayitemid":"404814674312","shopifyproductid":"7537955176670","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"7537955176670","shopifyvariantid":"42406527533278","shopifyinventoryid":"44500587217118","shopifylocationid":"","product_id":"44670303","variant_id":"77575523","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 18:10:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 18:10:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:10:06 [INFO]: Shopify Inventory id 44500587217118 2025-08-11 18:10:06 [INFO]: Shopify Location id 58450641063 2025-08-11 18:10:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:10:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T18:10: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-11 18:10:06 [INFO]: Change: available | Delta: -1 2025-08-11 18:10:06 [INFO]: Change: on_hand | Delta: -1 2025-08-11 18:10:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:10:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670303 and user_id = 14409 2025-08-11 18:10:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575523 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:10:06 [INFO]: updateIdsQuantity -> ["77575523"] 2025-08-11 18:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 18:10:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77575523 THEN 0 END, quantityflag = CASE WHEN id = 77575523 THEN 0 END WHERE user_id = 14409 AND id IN (77575523) 2025-08-11 18:10:06 [INFO]: QUANTITY Updated IDs: 77575523 2025-08-11 18:10:06 [INFO]: Successfully processed data for user 14409 2025-08-11 18:10:06 [INFO]: Execution Started 2025-08-11 18:10:06 [INFO]: Execution Finished 2025-08-11 18:20:01 [INFO]: Execution Started 2025-08-11 18:20:01 [INFO]: old server sucessfully connected 2025-08-11 18:20:01 [INFO]: sqs client sucess created 2025-08-11 18:20:02 [INFO]: Number of messages in the queue: 2 2025-08-11 18:20:02 [INFO]: item found in queue is if condition 14409 2025-08-11 18:20:02 [INFO]: item found in queue is 14409 2025-08-11 18:20:02 [INFO]: Message deleted from the queue for receipt handle: AQEBSZQfYjeBp6wbfmYqR6787VZCqMK2v4Y0xiJ6nnBdP3hFV3ufPqGe19fis3IH8nw1ly67D2uhv39UYmnPAvxvWP//Q7Azs8z/YLdCJjLLP9jplwRV0rF5ixppuF827+TcKhki3EHLtqtrzVtTV4Ek001oAaiO4giwG1rmq8fo5Ht8XZq0UKM+eYkicIdcyEV/lvds61WE4/voQITZtMOrwukr/Wg1OmP4dTisHaZg+aY7WVULF6uRgyY18hGMnhjguZIkR5HAqlMGyw6g0bM5heA9z06WRYsT415T3gvxaKX8K/b03zX37nFDvn6RIhY4IkhcGt4Xaq9gLUX2H2L/mJr5ZVDg5WX3TzjhnkGEp+MQB7HdnrPdphOtDxpjuaxLpg7uW7H8rcDUvqq5id0phO5T1O9VSVw+LGgPIpBrupIF/fh4+B0+aqCIPKtpwn8p 2025-08-11 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-11 18:20:03 [INFO]: item found in queue is 14409 2025-08-11 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBE2i5J00HvmHHJueeP6XaFxf7GBQ8QDiWPqPL9/wTWGSnLVWOzPnvCseDIWjCLvTYvM1h+OstvHxmVVhYU1COkqwFTC7HdgBlYm/7vMOGFUfbPdh2K96WScxr9fBi0fOj4QdKDNMqopyB7NhYFtMtLEYhEKw8U2F7OejO+ULQAbgMsw3I4EP9mHsasBtd5cw/ukTTmIX/HhQiS4T1Zskodi3QFqwW+h4qdY9zznN79A21QErpr9fDDSvluiP6MCXRTSLMic3te15xQ/Fbm546nq2jB9wzW1IhyDC4dnz9laQJA4RKm/Z87I+MQ8DFjHijhXASlHQQidKjboapy7VtQtp67alhUHZIPPa+wNn65ruBFyxNu+tFnXbcIEC/U3J3tnAnlGz4/odCWYlXPp4l/FWY/6m7+ePRF9cseRlWD4GN4QdVphd0xswFjgyC8VYY 2025-08-11 18:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-11 18:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 18:20:03 [INFO]: inside itemsold and closed 14409 2025-08-11 18:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:20:05 [INFO]: Ebay item id :: 226866196797 exists in Database 2025-08-11 18:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 18:20:05 [INFO]: inside itemsold and closed 14409 2025-08-11 18:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:20:07 [INFO]: Ebay item id :: 404622568129 exists in Database 2025-08-11 18:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:20:07 [INFO]: in processold action queue is array for {"45224662":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45224662","ebayitemid":"226866196797","deleted":1}}} 2025-08-11 18:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 18:20:07 [INFO]: productIds WHich are having null productid -> [45224662] 2025-08-11 18:20:07 [INFO]: ebayItemIds WHich are not imported-> ["226866196797"] 2025-08-11 18:20:07 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 18:20:07 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 18:20:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45224662) 2025-08-11 18:20:07 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 18:20:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 18:20:07 [INFO]: Transaction committed successfully. 2025-08-11 18:20:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 18:20:07 [INFO]: Successfully processed data for user 14409 2025-08-11 18:20:07 [INFO]: Execution Started 2025-08-11 18:20:07 [INFO]: Execution Finished 2025-08-11 18:30:01 [INFO]: Execution Started 2025-08-11 18:30:01 [INFO]: old server sucessfully connected 2025-08-11 18:30:01 [INFO]: sqs client sucess created 2025-08-11 18:30:02 [INFO]: Number of messages in the queue: 1 2025-08-11 18:30:02 [INFO]: item found in queue is if condition 14409 2025-08-11 18:30:02 [INFO]: item found in queue is 14409 2025-08-11 18:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBT3hj6ypcBBBSrYKgIxa849mAgWtLobJw6XVqVUlgOKeuFV/rKe/nUn1weulYww3d8hIYuzzT3mK0zJ8OMS2/jGk8reMFBIIXTnZhgu/kNKWURCEYrJjuvTLC1UkHtXdZb+ru/HCSGczMUBdscnSTg0DicTSBNKEEBeRsoTk2Wt5pM+JeRrxDw+GeTMXkfBViOj5cusWMWBSRwYmxHcwluGIEIy7LgppskXALC0rJ+xm3n4ceIFvMBIXyYf7gme+iqvI1BCAseYUgKi0AVUxXPcNqePrhj41iRjbSW4Ml+U9hlFjM6QwQncRsEvEDcp3uXSpqKOW+AhI2xnRcRC3UY1Ft0VGNl7qNOVRjQjQ4KqaUFHToNPA3dQCp/Xdni9U7EXi4J7/Ixm92Ute6RSsNiRbXYsqRcq2m2uXjPXOR7VSAF9DD8ljwYXH+tbpk4QJk 2025-08-11 18:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 18:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 18:30:03 [INFO]: inside itemsold and closed 14409 2025-08-11 18:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:30:05 [INFO]: Ebay item id :: 256681339827 exists in Database 2025-08-11 18:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:30:05 [INFO]: in processold action queue is array for {"44655987":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44655987","ebayitemid":"256681339827","shopifyproductid":"7699949945054","variants":[{"price":"19.99","quantity":0,"weight":"3","shopifyproductid":"7699949945054","shopifyvariantid":"42997120270558","shopifyinventoryid":"45092319625438","shopifylocationid":"","product_id":"44655987","variant_id":"77561176","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 18:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 18:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:30:05 [INFO]: Shopify Inventory id 45092319625438 2025-08-11 18:30:05 [INFO]: Shopify Location id 58450641063 2025-08-11 18:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T18: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-11 18:30:05 [INFO]: Change: available | Delta: -1 2025-08-11 18:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 18:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44655987 and user_id = 14409 2025-08-11 18:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561176 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:30:05 [INFO]: updateIdsQuantity -> ["77561176"] 2025-08-11 18:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 18:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561176 THEN 0 END, quantityflag = CASE WHEN id = 77561176 THEN 0 END WHERE user_id = 14409 AND id IN (77561176) 2025-08-11 18:30:05 [INFO]: QUANTITY Updated IDs: 77561176 2025-08-11 18:30:05 [INFO]: Successfully processed data for user 14409 2025-08-11 18:30:05 [INFO]: Execution Started 2025-08-11 18:30:05 [INFO]: Execution Finished 2025-08-11 18:40:01 [INFO]: Execution Started 2025-08-11 18:40:01 [INFO]: old server sucessfully connected 2025-08-11 18:40:01 [INFO]: sqs client sucess created 2025-08-11 18:40:02 [INFO]: Number of messages in the queue: 3 2025-08-11 18:40:02 [INFO]: item found in queue is if condition 14409 2025-08-11 18:40:02 [INFO]: item found in queue is 14409 2025-08-11 18:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEB9byls/KRJEtps//PP0ttYxrNca2sw5cNMOUIBF8KnHIvSbpYee/NuFbeH28F3jEW35xfKjSlb1rKwdEuBIpK9FFZDtcDghtu/h+/N8O4/L9A06HQbH9irI15Fw5bNaYCt2VcLF8BmYfz8Th3cqbVG5YZ+P01A2C3YfAx+vAhlPmZ9910tLN+bE4YOQvER8CUv9jvvsUlQdm/CArFnZNG3Icxw2z/EH3QPQMJsbr1OfJMd6AYHzATjE4zbpx0xThbvT+UGtmdD9Q+zWVat2S2PayLWqPxr+GMUDp/obB5L6dJORx/PNyGTnc5VjAiW+x43iFZ738djgsHRIt/gjx/wVNdh4A/FTqWupegbdhpbNR2xjCbrIk/v0VoGi6vZD4V/2niJmaHlxskmIth12myXoQpFHC/GWZ+Ez5HpD2EXxFSHMsx4Q8zNmP+oXYdxQmh 2025-08-11 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 18:40:03 [INFO]: item found in queue is 14409 2025-08-11 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmZSiMvUk7CH/+eisvz/nQLWKWFSqfJRTCFRGwUjXwurEO5ox3JYl2ltJfS34RlzGzc7Qehsgn9AjigFsQCeVcU735PKLNtl6AE6KNL7TMXdso5xo4iivZGyGWQILccxDgsVBf7eBVQyQiQQ/PuAuHHfKBlhqRGOQ9f1tf4s/QVSWL2Iwfg7ZmHK+56FZqQZ8Oli3AiEJSaT0YP5sWy7ljobQy7lQSh0JN70atoiboVyFve9OpvjZ+u7ity11v38wQLhUvtTZ1Om2yLrK+wwUyBj9/5GZLaK/AyL6yEVCX2dy+44CiQQQEp8E1GNd905jsl/VZHOYyOu97CrYgQLy83uasTLvjFO1T8IMhfeecI9vm7Fj5di/7X4CZ4ffzg2F2QR9yBsMm40zb7hZHB47HPlEv8DSTiZrPGX/EaWPl1TytuQ8crB6FNf9KJfyog5l 2025-08-11 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 18:40:03 [INFO]: item found in queue is 14409 2025-08-11 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBRyiaxioIFAXfk1AZ+gcQU87DlkB9TYNCr29Kaj+YSod9YP+ZL3xXHb1MyW1CTre7RMG/W3YcZvjEHKsV00Q+aeIZqwCCFantSAF4GDToKKlAeW4fxE97Jm1BddSseW+UfIyvGGqdQM3Xe0a3YFZZgDpkB4Th7brbSg9tuPafftd8Ftp76/MiBkIlII0YeKS6dKWA/Qj/tEZT4Dk23Ku/eC/X+nWx69hfXEgalEi3Qzy9cioOuqAeXt+yRwh7bIU1GlkKTYqYuKcVCbwJqwkr6tzy6WnokU/W85ePRsQp9uCMJWhip+lUpt0D5rfV5zCrBp4hv7LIc2MY+jeylTJuOjDrJHwbutYcZxEMDg7HAAQqg1wYl9HR/onDqikZP2J4iPZ2oj4zKh+e56bIN95/VbdSELzr4RBQwboTbKD0A8cXaQChLucvcCKxoACOpYDH 2025-08-11 18:40:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 18:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 18:40:03 [INFO]: inside itemsold and closed 14409 2025-08-11 18:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:40:05 [INFO]: Ebay item id :: 326577259202 exists in Database 2025-08-11 18:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:40:05 [INFO]: inside itemsold and closed 14409 2025-08-11 18:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:40:07 [INFO]: Ebay item id :: 286132020554 exists in Database 2025-08-11 18:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:40:07 [INFO]: inside itemsold and closed 14409 2025-08-11 18:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:40:09 [INFO]: Ebay item id :: 405746828070 exists in Database 2025-08-11 18:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:40:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 18:40:09 [INFO]: in processold action queue is array for {"44738062":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44738062","ebayitemid":"326577259202","shopifyproductid":"7964950724830","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7964950724830","shopifyvariantid":"44024681496798","shopifyinventoryid":"46121288564958","shopifylocationid":"","product_id":"44738062","variant_id":"77645999","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44714436":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44714436","ebayitemid":"286132020554","shopifyproductid":"8718640152798","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8718640152798","shopifyvariantid":"45990871597278","shopifyinventoryid":"48089206259934","shopifylocationid":"","product_id":"44714436","variant_id":"77622049","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44873170":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"44873170","ebayitemid":"405746828070","deleted":1}}} 2025-08-11 18:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 18:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:40:09 [INFO]: productIds WHich are having null productid -> [44873170] 2025-08-11 18:40:09 [INFO]: ebayItemIds WHich are not imported-> ["405746828070"] 2025-08-11 18:40:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 18:40:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 18:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (44873170) 2025-08-11 18:40:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 18:40:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 18:40:09 [INFO]: Transaction committed successfully. 2025-08-11 18:40:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 18:40:09 [INFO]: Shopify Inventory id 46121288564958 2025-08-11 18:40:09 [INFO]: Shopify Location id 58450641063 2025-08-11 18:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:40: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-11 18:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44738062 and user_id = 14409 2025-08-11 18:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645999 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:40:09 [INFO]: Shopify Inventory id 48089206259934 2025-08-11 18:40:09 [INFO]: Shopify Location id 58450641063 2025-08-11 18:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T18:40: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-11 18:40:09 [INFO]: Change: available | Delta: -1 2025-08-11 18:40:09 [INFO]: Change: on_hand | Delta: -1 2025-08-11 18:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44714436 and user_id = 14409 2025-08-11 18:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77622049 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:40:09 [INFO]: updateIdsQuantity -> ["77645999","77622049"] 2025-08-11 18:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 18:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77645999 THEN 0 WHEN id = 77622049 THEN 0 END, quantityflag = CASE WHEN id = 77645999 THEN 0 WHEN id = 77622049 THEN 0 END WHERE user_id = 14409 AND id IN (77645999,77622049) 2025-08-11 18:40:09 [INFO]: QUANTITY Updated IDs: 77645999, 77622049 2025-08-11 18:40:09 [INFO]: Successfully processed data for user 14409 2025-08-11 18:40:09 [INFO]: Execution Started 2025-08-11 18:40:09 [INFO]: Execution Finished 2025-08-11 18:50:01 [INFO]: Execution Started 2025-08-11 18:50:01 [INFO]: old server sucessfully connected 2025-08-11 18:50:02 [INFO]: sqs client sucess created 2025-08-11 18:50:03 [INFO]: Number of messages in the queue: 1 2025-08-11 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-11 18:50:03 [INFO]: item found in queue is 14409 2025-08-11 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB06EeQAfkDvprM8O7725wMp9lWCplYeHvRGDjd8SqBvxHauaotKLaxwk3y6piyTLqUv54tCdAKhaWeKrMSPzpDD4DKZ8mR2VjEg6+fwXmOH1quTRoudO+B69CNFxyhhG6lUXtbPabW7MlmBxcFTLCH2kyu4tPdERSlfdui9CdD97amMkPmstC2oGCw7iwtQcbFAcHIucJS3a7J5FWWb7RCWhjovRFS9p8h8pCHJpYkvnH2JmaQOX+D1uww+PerEkj90/rLaTlHTSjyvNCHycUfIefeny7SB33YDjnzSuxBvfHOpJG5VF3heM4T8T4px8H6kbtPfsrKu/FRY41aO6n6T7x3S9QJPD14lAEBRBYG1KfuzTXq18GxbNnKLJ2NQ0RPpfNJ1VYimVvQeW6xyQqyEeO4qkpm5POH9SCE0BYU106qSeBK+PHtAfus2x/lObM 2025-08-11 18:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 18:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 18:50:03 [INFO]: inside itemsold and closed 14409 2025-08-11 18:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 18:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 18:50:05 [INFO]: Ebay item id :: 225760893916 exists in Database 2025-08-11 18:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 18:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 18:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 18:50:05 [INFO]: in processold action queue is array for {"44733481":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733481","ebayitemid":"225760893916","shopifyproductid":"8123425587422","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8123425587422","shopifyvariantid":"44336865902814","shopifyinventoryid":"46434546647262","shopifylocationid":"","product_id":"44733481","variant_id":"77641366","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 18:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 18:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 18:50:05 [INFO]: Shopify Inventory id 46434546647262 2025-08-11 18:50:05 [INFO]: Shopify Location id 58450641063 2025-08-11 18:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 18:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T18:50: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-11 18:50:05 [INFO]: Change: available | Delta: -1 2025-08-11 18:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 18:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 18:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733481 and user_id = 14409 2025-08-11 18:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641366 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 18:50:05 [INFO]: updateIdsQuantity -> ["77641366"] 2025-08-11 18:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 18:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641366 THEN 0 END, quantityflag = CASE WHEN id = 77641366 THEN 0 END WHERE user_id = 14409 AND id IN (77641366) 2025-08-11 18:50:05 [INFO]: QUANTITY Updated IDs: 77641366 2025-08-11 18:50:05 [INFO]: Successfully processed data for user 14409 2025-08-11 18:50:05 [INFO]: Execution Started 2025-08-11 18:50:05 [INFO]: Execution Finished