2025-08-05 17:00:01 [INFO]: Execution Started 2025-08-05 17:00:01 [INFO]: old server sucessfully connected 2025-08-05 17:00:01 [INFO]: sqs client sucess created 2025-08-05 17:00:03 [INFO]: Number of messages in the queue: 0 2025-08-05 17:00:24 [INFO]: Execution Started 2025-08-05 17:00:24 [INFO]: Execution Finished 2025-08-05 17:10:01 [INFO]: Execution Started 2025-08-05 17:10:01 [INFO]: old server sucessfully connected 2025-08-05 17:10:01 [INFO]: sqs client sucess created 2025-08-05 17:10:03 [INFO]: Number of messages in the queue: 1 2025-08-05 17:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 17:10:04 [INFO]: item found in queue is 14409 2025-08-05 17:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBZech+TMMxQ7b6M5fXVafFbIYqeLa6szfVOay3gFiG+lWN+o1mSoVCzUf+h300k5eUThKrwwBeoDt9dcFZV+Viq/o2/llqsL5/EWKw/79GjWu7UpBJ1rTZ9OPh4R99UFGeSuuvuypsy/0DW8R3qmStpbayEEaScQR8bSrYA7k4lj9+3q0GDkvNXLfp0IwUNMRWri7rVIHAMqRUWwdEH880/DQ+T3Vx1Nj3q1J2TeAKwamm3BM5E4bnz+LByzSYzY4zgF+e/9oU58PSQKcZvzP+Ep3HOewHidytO1tHlfSN2MaK3Ryn50/UipG6GgDMuo7oVt3Kjz9sofu6ZmJo6IBnNTt5CaEAw2tfLJHdDkEP3ygKn/B9sYIj7P+xXtAvSAhoyUjGwBpI2mOrARrXFBO6iSBUbGhEFhTE6+Z3gg4SD7Lk9Ay1CQ72Vp/VKHI9+0j 2025-08-05 17:10:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 17:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 17:10:05 [INFO]: inside itemsold and closed 14409 2025-08-05 17:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 17:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 17:10:06 [INFO]: Ebay item id :: 286563627644 exists in Database 2025-08-05 17:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 17:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 17:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 17:10:06 [INFO]: in processold action queue is array for {"44791253":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44791253","ebayitemid":"286563627644","shopifyproductid":"8918150185182","variants":[{"price":"275.49","quantity":0,"weight":"10","shopifyproductid":"8918150185182","shopifyvariantid":"46733806797022","shopifyinventoryid":"48832294060254","shopifylocationid":"58450641063","product_id":"44791253","variant_id":"77701502","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 17:10:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 17:10:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 17:10:06 [INFO]: Shopify Inventory id 48832294060254 2025-08-05 17:10:06 [INFO]: Shopify Location id 58450641063 2025-08-05 17:10:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 17:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T17:10:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 17:10:07 [INFO]: Change: available | Delta: -1 2025-08-05 17:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-05 17:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 17:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44791253 and user_id = 14409 2025-08-05 17:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77701502 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 17:10:07 [INFO]: updateIdsQuantity -> ["77701502"] 2025-08-05 17:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 17:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77701502 THEN 0 END, quantityflag = CASE WHEN id = 77701502 THEN 0 END WHERE user_id = 14409 AND id IN (77701502) 2025-08-05 17:10:07 [INFO]: QUANTITY Updated IDs: 77701502 2025-08-05 17:10:07 [INFO]: Successfully processed data for user 14409 2025-08-05 17:10:07 [INFO]: Execution Started 2025-08-05 17:10:07 [INFO]: Execution Finished 2025-08-05 17:20:01 [INFO]: Execution Started 2025-08-05 17:20:01 [INFO]: old server sucessfully connected 2025-08-05 17:20:01 [INFO]: sqs client sucess created 2025-08-05 17:20:03 [INFO]: Number of messages in the queue: 1 2025-08-05 17:20:04 [INFO]: item found in queue is if condition 14409 2025-08-05 17:20:04 [INFO]: item found in queue is 14409 2025-08-05 17:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB5cGD8tctS4lKFH8YLWaOvaH6e7/J7JG0p+w6Lkn+77OgTxh7IrpdM9apuAATFHEe3/3J5wGpTYwMzLC+CJEYJ/1SX/iCPdpRqLqMb0XaPxNcCLG5HtomkIwtxYa4Ib6LByTsJ+hm19zM2krKDNrCkwcsdAy4aduHltgm3FXVNrHwXCj3OD0anD9/5OAR0TcWL+j2GnoVe4y5llmua0jldpU8MiXal1djFytPNhuJ/d4ZP9EUDzKefg90sI2G8RH5NC8x5CGtU/qnB3swkAz19h+nro+0D8kgKLzbEBjjvtjoJrJYPVgmPwx1CLWUmYWwsgT5dvx9iLuWZ63FADW85hSifA+pzlHO5muBRth8/zDJ56P+raXm1cv1I6j9jNA5u/oy3anqPgzKZtc3MOZxCHfuv1nV5MJXEdoFJRrLtFAu+nv4/60+HAF/u+19Ax2+ 2025-08-05 17:20:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 17:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 17:20:04 [INFO]: inside itemsold and closed 14409 2025-08-05 17:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 17:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 17:20:06 [INFO]: Ebay item id :: 256209940984 exists in Database 2025-08-05 17:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 17:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 17:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 17:20:06 [INFO]: in processold action queue is array for {"44765868":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44765868","ebayitemid":"256209940984","shopifyproductid":"8123942699230","variants":[{"price":"11.99","quantity":0,"weight":"0.5","shopifyproductid":"8123942699230","shopifyvariantid":"44337918410974","shopifyinventoryid":"46435604955358","shopifylocationid":"","product_id":"44765868","variant_id":"77674410","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 17:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 17:20:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 17:20:06 [INFO]: Shopify Inventory id 46435604955358 2025-08-05 17:20:06 [INFO]: Shopify Location id 58450641063 2025-08-05 17:20:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 17:20:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T17:20:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 17:20:06 [INFO]: Change: available | Delta: -1 2025-08-05 17:20:06 [INFO]: Change: on_hand | Delta: -1 2025-08-05 17:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 17:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44765868 and user_id = 14409 2025-08-05 17:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77674410 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 17:20:06 [INFO]: updateIdsQuantity -> ["77674410"] 2025-08-05 17:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 17:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77674410 THEN 0 END, quantityflag = CASE WHEN id = 77674410 THEN 0 END WHERE user_id = 14409 AND id IN (77674410) 2025-08-05 17:20:06 [INFO]: QUANTITY Updated IDs: 77674410 2025-08-05 17:20:06 [INFO]: Successfully processed data for user 14409 2025-08-05 17:20:06 [INFO]: Execution Started 2025-08-05 17:20:06 [INFO]: Execution Finished 2025-08-05 17:30:01 [INFO]: Execution Started 2025-08-05 17:30:01 [INFO]: old server sucessfully connected 2025-08-05 17:30:02 [INFO]: sqs client sucess created 2025-08-05 17:30:03 [INFO]: Number of messages in the queue: 0 2025-08-05 17:30:23 [INFO]: Execution Started 2025-08-05 17:30:23 [INFO]: Execution Finished 2025-08-05 17:40:01 [INFO]: Execution Started 2025-08-05 17:40:01 [INFO]: old server sucessfully connected 2025-08-05 17:40:01 [INFO]: sqs client sucess created 2025-08-05 17:40:03 [INFO]: Number of messages in the queue: 0 2025-08-05 17:40:24 [INFO]: Execution Started 2025-08-05 17:40:24 [INFO]: Execution Finished 2025-08-05 17:50:01 [INFO]: Execution Started 2025-08-05 17:50:01 [INFO]: old server sucessfully connected 2025-08-05 17:50:02 [INFO]: sqs client sucess created 2025-08-05 17:50:03 [INFO]: Number of messages in the queue: 3 2025-08-05 17:50:04 [INFO]: item found in queue is if condition 14409 2025-08-05 17:50:04 [INFO]: item found in queue is 14409 2025-08-05 17:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBCayhQPKlMkRwuCcN8DMORV68BJ4mgc4hdW2O6642F9uX4w2YG+wxMXVdOABKuPBZMrH9YtN5Y6LVvzSgafDbLuX5b3FutDW20ibaWqAhxux+mGfWnn1K4aZFoo39AkK2iVmqX8bi7J3PaN0gN0qNdDcc/rrbJJcy9XeP/7+I0H+dxeoPAWCCFLHXHDBG2jqQluQQSdUo+w26wRHyQWzyXZi1Jt1dr2WDKD8KtQx0FgcWxVu5YUH1bbrWj3uss4ypX6suzZXr/u7GYArrdlHVKDa5upioMaMSq437arpLtMHpoEWSKhEddRYIGnqGF81tNmnxQY+rdqZgTrCtTSZpF8HFHOZ3/CWG+nLaQ4c0axrPUs2AHK3re6iii6glXjA1mSvnca8YttmlcMP4QPnYaQLhsj3ZMXGL9jV5E4fXW/EpWQM1vGH7kz9zNmykRqLh 2025-08-05 17:50:05 [INFO]: item found in queue is if condition 14409 2025-08-05 17:50:05 [INFO]: item found in queue is 14409 2025-08-05 17:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEB/kI63YQxsNDQVg03eyqhBrPLuwy+H23hcvVHpVZpKjvziaxevugheZGERzc/71GRkU+S95yY4ja5g61Ix8unqeYg+Fob8Enq5SVhqPfkjUsVRBhOeYbKMaja6lG7U6V9RoSNX8wOlfyTlDIBuGmgyD6mWL2PrpMOAaLO3eQxjUncWQHCtH5lYDbZkF4oCjrPC8jeo0jb1INowljlfyPXGLkGYelrmnFVMNGdXMdUBaZBokxguptvNwpSGVLuoUQYY/C2dr7q53zknuzukNGsq8KgZyHNyvjzj+XNd2eErHa7Hat4d9SuYvbkfECradNPUiQ+OJ4xQnFe0EMaF3VlhVZoYYAPI9aaJVwEEglZByEAoHPLFiiBsITBnvK67epYqrrsT1K4PiHHFAR7pscFu9DpzFSgWsQ5Ivah8w3awPd9LKhAWlIZ2RkhCgGiQROv 2025-08-05 17:50:05 [INFO]: item found in queue is if condition 14409 2025-08-05 17:50:05 [INFO]: item found in queue is 14409 2025-08-05 17:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEBf0jKYKgJO3Fergq5bNqowaYUb+xtFckAAl2cAwMiS3wLo1x+3NHjeNhKsWlvxK6QJE8oyFsz3GAvhkycJStIJqvYSwEYE9dTZKIx3W81o2pFrEcOjO/UMC7iLvVtEd/VhU+XXTXXhPQuJxE80ipVmtv9GSTUWxypo26egpOUlq/O/7LzOVra/xuoMI65UNR54LMRm0zRlby/3jyr4CwyMSRKRJNgf9DSJmt/NPKB4qMStWkbwIYejW5EEWK3edau+RwaJQXnTA6yhwCoBqc2XXLohqmIdu3uFKFG5D1wTLCYVCiAVTcw3VaR0oy8nuK5Mp79qoYaFichKPdsdISpyagR63KgBNjSOOcT3qFU7tWAQvd3U+Ny7g/iZd37H7uJhp0gL7O62dDS/SSXiR4rnAgqmH8XtGlFjxzhr7ZObVnN0uTpFh1kG8Abg7ayQbHA 2025-08-05 17:50:06 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 17:50:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 17:50:06 [INFO]: inside itemsold and closed 14409 2025-08-05 17:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 17:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 17:50:07 [INFO]: Ebay item id :: 305464368981 exists in Database 2025-08-05 17:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 17:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 17:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 17:50:07 [INFO]: inside itemsold and closed 14409 2025-08-05 17:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 17:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 17:50:09 [INFO]: Ebay item id :: 336084081231 exists in Database 2025-08-05 17:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 17:50:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 17:50:09 [INFO]: inside itemsold and closed 14409 2025-08-05 17:50:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 17:50:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 17:50:11 [INFO]: Ebay item id :: 305462846635 exists in Database 2025-08-05 17:50:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 17:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 17:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 17:50:11 [INFO]: in processold action queue is array for {"44584112":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44584112","ebayitemid":"305464368981","shopifyproductid":"8333652099294","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8333652099294","shopifyvariantid":"44954266697950","shopifyinventoryid":"47052048203998","shopifylocationid":"","product_id":"44584112","variant_id":"77476821","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45278617":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45278617","ebayitemid":"336084081231","deleted":1}},"44582342":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582342","ebayitemid":"305462846635","shopifyproductid":"8332128616670","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8332128616670","shopifyvariantid":"44946128240862","shopifyinventoryid":"47043909910750","shopifylocationid":"","product_id":"44582342","variant_id":"77475051","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 17:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 17:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 17:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 17:50:11 [INFO]: productIds WHich are having null productid -> [45278617] 2025-08-05 17:50:11 [INFO]: ebayItemIds WHich are not imported-> ["336084081231"] 2025-08-05 17:50:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 17:50:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 17:50:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45278617) 2025-08-05 17:50:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 17:50:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 17:50:11 [INFO]: Transaction committed successfully. 2025-08-05 17:50:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 17:50:11 [INFO]: Shopify Inventory id 47052048203998 2025-08-05 17:50:11 [INFO]: Shopify Location id 58450641063 2025-08-05 17:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 17:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T17:50:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 17:50:11 [INFO]: Change: available | Delta: -1 2025-08-05 17:50:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 17:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 17:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44584112 and user_id = 14409 2025-08-05 17:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77476821 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 17:50:11 [INFO]: Shopify Inventory id 47043909910750 2025-08-05 17:50:11 [INFO]: Shopify Location id 58450641063 2025-08-05 17:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 17:50:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T17:50:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 17:50:11 [INFO]: Change: available | Delta: -1 2025-08-05 17:50:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 17:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 17:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582342 and user_id = 14409 2025-08-05 17:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475051 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 17:50:11 [INFO]: updateIdsQuantity -> ["77476821","77475051"] 2025-08-05 17:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 17:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77476821 THEN 0 WHEN id = 77475051 THEN 0 END, quantityflag = CASE WHEN id = 77476821 THEN 0 WHEN id = 77475051 THEN 0 END WHERE user_id = 14409 AND id IN (77476821,77475051) 2025-08-05 17:50:11 [INFO]: QUANTITY Updated IDs: 77476821, 77475051 2025-08-05 17:50:11 [INFO]: Successfully processed data for user 14409 2025-08-05 17:50:11 [INFO]: Execution Started 2025-08-05 17:50:11 [INFO]: Execution Finished