2025-08-11 21:00:01 [INFO]: Execution Started 2025-08-11 21:00:01 [INFO]: old server sucessfully connected 2025-08-11 21:00:01 [INFO]: sqs client sucess created 2025-08-11 21:00:02 [INFO]: Number of messages in the queue: 1 2025-08-11 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-11 21:00:03 [INFO]: item found in queue is 14409 2025-08-11 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjIk8j8sgtiMMco6bkcFB9IAXI6uxnuZxQtsHuTXpWxSKMchoes+dgNaQVx4PRQrjgvBV3q4c+30Q6lrJscvXDsgoLPlCFv7hQK7rwY4vhpZ1SE/uakjzH1fanjL1q1BJMdnSSM6ANRLF06dfx0FMDA4ZbcO/8rfYH2Gbnwn/ETulZILuDwIgMTAOaQhrW2Fy7i5vlsfVWKTE4lnlzB5Z8wXrpJNN15H+qLo6evuYcsAnjn+MUKPatd1ZOO/TSQobrPWYoxoEK0G6HsGTrgTw9z4jO25oe8GJE7MDdgEEiKsnGe12Fg1hQNR0VxIEKFlNO0rdnckiFv8CdkrtdeRr7p8D02XhIk3E19z5XXUTaTlQ8IagHJ5TEolKwMKvHi/Kk9zsxP1WceYFONu0tA4Ng4A9tIJU6BB62D+OzhltiOBvYVY3mCdcqZUZjAupNwuC 2025-08-11 21:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 21:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 21:00:03 [INFO]: inside itemsold and closed 14409 2025-08-11 21:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:00:05 [INFO]: Ebay item id :: 326134999484 exists in Database 2025-08-11 21:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:00:05 [INFO]: in processold action queue is array for {"44666017":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44666017","ebayitemid":"326134999484","shopifyproductid":"8495983362270","variants":[{"price":"10.99","quantity":0,"weight":"0.9375","shopifyproductid":"8495983362270","shopifyvariantid":"45402489422046","shopifyinventoryid":"47500468027614","shopifylocationid":"","product_id":"44666017","variant_id":"77571237","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 21:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 21:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:00:05 [INFO]: Shopify Inventory id 47500468027614 2025-08-11 21:00:05 [INFO]: Shopify Location id 58450641063 2025-08-11 21:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T21:00: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 21:00:06 [INFO]: Change: available | Delta: -1 2025-08-11 21:00:06 [INFO]: Change: on_hand | Delta: -1 2025-08-11 21:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44666017 and user_id = 14409 2025-08-11 21:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77571237 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:00:06 [INFO]: updateIdsQuantity -> ["77571237"] 2025-08-11 21:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 21:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77571237 THEN 0 END, quantityflag = CASE WHEN id = 77571237 THEN 0 END WHERE user_id = 14409 AND id IN (77571237) 2025-08-11 21:00:06 [INFO]: QUANTITY Updated IDs: 77571237 2025-08-11 21:00:06 [INFO]: Successfully processed data for user 14409 2025-08-11 21:00:06 [INFO]: Execution Started 2025-08-11 21:00:06 [INFO]: Execution Finished 2025-08-11 21:10:01 [INFO]: Execution Started 2025-08-11 21:10:01 [INFO]: old server sucessfully connected 2025-08-11 21:10:01 [INFO]: sqs client sucess created 2025-08-11 21:10:02 [INFO]: Number of messages in the queue: 1 2025-08-11 21:10:02 [INFO]: item found in queue is if condition 14409 2025-08-11 21:10:02 [INFO]: item found in queue is 14409 2025-08-11 21:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEBLqYCSrehIf9eBq/jQrBsa7QZGbPVRQkc+pmMgBL9A4em5WAaIvKMMsWrXbQgMLtncc7QvdEFaNmMSq463xXRZpU30DJ3CdgoxPX8bu6RIicqQJ+PDP5DbRvIiWVeobbHA+O/L7rwwdqXWoyAiMrv2dyzrtbbSIq4ppVA3ywMjVqJ90JY0uxCviQS7JbNRd2Dsg8gTy0iDLQi13iZ7udImMq2CpnOnuokAcgXlkPJ7CQl3fcmF3v7w+9q9kdBwi+4B1q5BBLrbfgaDQPZG9DDdHw2vUZTS/yAKpt4HouI70HYnbVWi9Zv6rXjeMpoxd/Ayr1o3hxsAkKpOUJqX/yjUmfKIIqxD6Lhd1IwfdCch2b0oxLbvkzU5HaFMwmj/8zePkPfc8Y4HE5F1pBmw7w3ZaKHKv9b+oXfDBiQJyFfSxehvkuUqGL766TLTsLInH9c 2025-08-11 21:10:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 21:10:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 21:10:02 [INFO]: inside itemsold and closed 14409 2025-08-11 21:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:10:05 [INFO]: Ebay item id :: 286054080269 exists in Database 2025-08-11 21:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:10:05 [INFO]: in processold action queue is array for {"44775496":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44775496","ebayitemid":"286054080269","shopifyproductid":"8699672854750","variants":[{"price":"14.99","quantity":0,"weight":"0.5","shopifyproductid":"8699672854750","shopifyvariantid":"45944517132510","shopifyinventoryid":"48043051614430","shopifylocationid":"","product_id":"44775496","variant_id":"77684038","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 21:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 21:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:10:05 [INFO]: Shopify Inventory id 48043051614430 2025-08-11 21:10:05 [INFO]: Shopify Location id 58450641063 2025-08-11 21:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:10: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-11 21:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44775496 and user_id = 14409 2025-08-11 21:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77684038 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:10:05 [INFO]: updateIdsQuantity -> ["77684038"] 2025-08-11 21:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 21:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77684038 THEN 0 END, quantityflag = CASE WHEN id = 77684038 THEN 0 END WHERE user_id = 14409 AND id IN (77684038) 2025-08-11 21:10:05 [INFO]: QUANTITY Updated IDs: 77684038 2025-08-11 21:10:05 [INFO]: Successfully processed data for user 14409 2025-08-11 21:10:05 [INFO]: Execution Started 2025-08-11 21:10:05 [INFO]: Execution Finished 2025-08-11 21:20:01 [INFO]: Execution Started 2025-08-11 21:20:01 [INFO]: old server sucessfully connected 2025-08-11 21:20:01 [INFO]: sqs client sucess created 2025-08-11 21:20:02 [INFO]: Number of messages in the queue: 0 2025-08-11 21:20:23 [INFO]: Execution Started 2025-08-11 21:20:23 [INFO]: Execution Finished 2025-08-11 21:30:02 [INFO]: Execution Started 2025-08-11 21:30:02 [INFO]: old server sucessfully connected 2025-08-11 21:30:02 [INFO]: sqs client sucess created 2025-08-11 21:30:03 [INFO]: Number of messages in the queue: 1 2025-08-11 21:30:03 [INFO]: item found in queue is if condition 14409 2025-08-11 21:30:03 [INFO]: item found in queue is 14409 2025-08-11 21:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/kTJWZY99FSJltV+hHlwKHkeEVd7Eju13NsXNQDfI4uFiP8+lhqf6z0EHy1AFHx4PFC7tiZ2t3uBLwP0GWi9uh+YPrSZntYmKeHgomgU1jdUrB14fvN6TvdoOtOt8HKvnv8DBKq6gntQ9mfVYDgBaY19y5XP1M8sbzKi4kMy+hrQl++ubY7E1n31YQyZbPiHZomvNH3Yui+g5W6LsZXJ3rOXaOS6VLf4uuyNmJ63zwnxJ0/8uyfQaiIDGz7fbEFEXpJOoqbL7EV8gHmGyJAOmzDXSVGa3hgOWg8hTBOBp0PeYrexTy+I41LPnQk+wT1ER9CMocj4LsMrZV9vi0qKBGnJ87xG9F362MVxdAZkLCRgAUW3QTqm/CmeosDfKdGGLgf7dnSmf7q5oriT1MtipQQjIa/ozceJ18cl/Gh38SvKTm02K5a24t7B1isUKZdd 2025-08-11 21:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 21:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 21:30:03 [INFO]: inside itemsold and closed 14409 2025-08-11 21:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:30:05 [INFO]: Ebay item id :: 335647387360 exists in Database 2025-08-11 21:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:30:05 [INFO]: in processold action queue is array for {"44598442":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598442","ebayitemid":"335647387360","shopifyproductid":"8721423204574","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8721423204574","shopifyvariantid":"45999585689822","shopifyinventoryid":"48097988411614","shopifylocationid":"","product_id":"44598442","variant_id":"77491151","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 21:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 21:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:30:05 [INFO]: Shopify Inventory id 48097988411614 2025-08-11 21:30:05 [INFO]: Shopify Location id 58450641063 2025-08-11 21:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T21: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 21:30:05 [INFO]: Change: available | Delta: -1 2025-08-11 21:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 21:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598442 and user_id = 14409 2025-08-11 21:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77491151 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:30:05 [INFO]: updateIdsQuantity -> ["77491151"] 2025-08-11 21:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 21:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77491151 THEN 0 END, quantityflag = CASE WHEN id = 77491151 THEN 0 END WHERE user_id = 14409 AND id IN (77491151) 2025-08-11 21:30:05 [INFO]: QUANTITY Updated IDs: 77491151 2025-08-11 21:30:05 [INFO]: Successfully processed data for user 14409 2025-08-11 21:30:05 [INFO]: Execution Started 2025-08-11 21:30:05 [INFO]: Execution Finished 2025-08-11 21:40:02 [INFO]: Execution Started 2025-08-11 21:40:02 [INFO]: old server sucessfully connected 2025-08-11 21:40:02 [INFO]: sqs client sucess created 2025-08-11 21:40:03 [INFO]: Number of messages in the queue: 2 2025-08-11 21:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 21:40:03 [INFO]: item found in queue is 14409 2025-08-11 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxhtC0zICrGs30sUnf91SXP9xztgJqd2U+CcJnwX7N8nVY802Y22aFxTe2K61Tr035F5YtrHLF0OHnW+p0rosD0xaXVFRlWCxaH5X3KWEhu1OQ7fsm62e9s/Lo1ZRui00xq16rn/E6uEiHOFknSKjn2tDLE47uBjWsx9a5zglJro3LnM6RaVbtSTilgHY1q8+9EhsDlvXrQ7lA9G24wlpWSG7tT4uQ25NcNBfRpFAaGD2ee8DZehduAr8twP5BvDpkJ4hIJe7DThJEWjvD+WSezkNXq1rgo1npzEjoGy/8Hq8V0TqYyOUUqHibSql343z6czeQEFUFLymA7RvMQpZTfxfPB6gBWyvIIbZyP/GH541AuWp4dZAWroRRL9A5o58JzPLYuicyqSlZpK79uEw2hmpn/CFYfz6LRTiKDxIqNMVLece76ICgm5dyONbTi6m 2025-08-11 21:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 21:40:03 [INFO]: item found in queue is 14409 2025-08-11 21:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBl1cl/m6U3DW+kjZhknkDuJD2Og2l0QlsSVBzoWzM4RQgSmzJd0lW283kIfXxwHNmOKKnzMTE5lPN1k+BLwsQJFVBTIfIII/f5jk6Moo7BAAiiCVJnVJtZ+jmgnQGuLyAY2eR3TI55eZyZV6hwLeW6Ehce1/VYg51o/GcDDYq6ba9yXuUJIzY9k/Dlh5s8gMmgVJLQDeTG4AWZdx5KK/mRs+jpZ7tA5Bd1vhEmezgX3xhc3SgKu5dCwlaLFC/Aj79Wy/6hcT/ya3taXBLWQ78mewoJu9dAceAL0/Pn/kmdvBBu9Z3Ouvq+RNk/eMCQNHMuY1MJkj03mJjYmZmVOG2UqbsNGgubu08iKtbzY9Vqhp8/FmKEjvYr4/UPsV9fTfGFORquA55eNIynBItGQgrGVvIqYCbAHgYTR1opiCtsP5+JHZ+g/KpiOZHt2SMDTwc 2025-08-11 21:40:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-11 21:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 21:40:04 [INFO]: inside itemsold and closed 14409 2025-08-11 21:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:40:06 [INFO]: Ebay item id :: 325829734321 exists in Database 2025-08-11 21:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:40:06 [INFO]: inside itemsold and closed 14409 2025-08-11 21:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:40:07 [INFO]: Ebay item id :: 335723626914 exists in Database 2025-08-11 21:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:40:07 [INFO]: in processold action queue is array for {"44684253":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684253","ebayitemid":"325829734321","shopifyproductid":"8138280829150","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8138280829150","shopifyvariantid":"44367206514910","shopifyinventoryid":"46465009287390","shopifylocationid":"","product_id":"44684253","variant_id":"77589478","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44567320":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567320","ebayitemid":"335723626914","shopifyproductid":"8760706236638","variants":[{"price":"139.99","quantity":0,"weight":"3","shopifyproductid":"8760706236638","shopifyvariantid":"46142306025694","shopifyinventoryid":"48241546985694","shopifylocationid":"","product_id":"44567320","variant_id":"77460000","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 21:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 21:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:40:07 [INFO]: Shopify Inventory id 46465009287390 2025-08-11 21:40:07 [INFO]: Shopify Location id 58450641063 2025-08-11 21:40:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T21:40:08Z","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-11 21:40:08 [INFO]: Change: available | Delta: -2 2025-08-11 21:40:08 [INFO]: Change: on_hand | Delta: -2 2025-08-11 21:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684253 and user_id = 14409 2025-08-11 21:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589478 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:40:08 [INFO]: Shopify Inventory id 48241546985694 2025-08-11 21:40:08 [INFO]: Shopify Location id 58450641063 2025-08-11 21:40:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T21:40:08Z","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 21:40:08 [INFO]: Change: available | Delta: -1 2025-08-11 21:40:08 [INFO]: Change: on_hand | Delta: -1 2025-08-11 21:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567320 and user_id = 14409 2025-08-11 21:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77460000 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:40:08 [INFO]: updateIdsQuantity -> ["77589478","77460000"] 2025-08-11 21:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 21:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77589478 THEN 0 WHEN id = 77460000 THEN 0 END, quantityflag = CASE WHEN id = 77589478 THEN 0 WHEN id = 77460000 THEN 0 END WHERE user_id = 14409 AND id IN (77589478,77460000) 2025-08-11 21:40:08 [INFO]: QUANTITY Updated IDs: 77589478, 77460000 2025-08-11 21:40:08 [INFO]: Successfully processed data for user 14409 2025-08-11 21:40:08 [INFO]: Execution Started 2025-08-11 21:40:08 [INFO]: Execution Finished 2025-08-11 21:50:01 [INFO]: Execution Started 2025-08-11 21:50:01 [INFO]: old server sucessfully connected 2025-08-11 21:50:01 [INFO]: sqs client sucess created 2025-08-11 21:50:02 [INFO]: Number of messages in the queue: 3 2025-08-11 21:50:02 [INFO]: item found in queue is if condition 14409 2025-08-11 21:50:02 [INFO]: item found in queue is 14409 2025-08-11 21:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEBomIJ8YrrrkhbzuoRXc2NMXIVjpDN9XmAHMW3t/69OUY8DNM70zUTlZMR9ECOd6TOfXTCSBXLBkhUM5V9OadmNNhqm+R4Igd5zWG+3P9o2EsHkHswT0JO5QxqrNm4ldzJt4F0SYdpVuN19LbwWQV0y31RG/np1CAkMHBUBVPqDz3sgewRcMcNmbs4JJp7NWaUTq6wCBYVyWTpvR+FLzrw5N3TritpesL7tznVC3Hfeq5Z99H1/7FZmxNfJcmzuvB4iNfVPe0cDekW/ElDJvA0hEM2RdYbApE+4AEDna4/oKO5v30kTdoCc4Z4R0DyJQXZs+hfU8GRB2xO2TlKNCen4fh7+y2oObisC8I/slPSpb/uTqi8xRpIClBWw/p9cufPngoi/Bsut1BOj5ZJC5ARh6d+URx1IapUt8Lxy6Dfrb9f6X3BMqT0KlQapQdMLWVB 2025-08-11 21:50:03 [INFO]: item found in queue is if condition 14409 2025-08-11 21:50:03 [INFO]: item found in queue is 14409 2025-08-11 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBeRhAXYuF6Hc6XScvPz6bWlUxnniQEIP9ZKrbF9O+VeC3Ui3YB+9hp+rwuO6Kz77oKmXdO53I2lBnL51hfUAdT5juOxmb5gj0oLbA+Gi8n/k43beigrc4/rgVJ9WajnJLxpNdJ5SAlxPQHERUuiXSWhF5DsobCUiMUajOQcHGLPy/gJHhZDXU9Texu2QW9IBNW7kmsEP96U3q74VtC6lNWt/A8X/AFNJJf4xK9r12MJA/uVzrtWug+qQHnfX+RsXryh5VtnaVG+6DXWVv0H7QyDifHwjJ4r/Nd4teAY/3Lm3N0m516DSKA8Gz6BkkFZTYVFMSglsFzTytawmadtq54iM65vgrHSFvOWKYYgv9YfCCSuvIVrWHSMNRDyDuEn5vH8gDIC+DoDCu6CetFeS/TAemvNIRZCkNZInG8ZmZdI41z7KToUw9dYJA0OQtJxYZ 2025-08-11 21:50:04 [INFO]: item found in queue is if condition 14409 2025-08-11 21:50:04 [INFO]: item found in queue is 14409 2025-08-11 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB88euiHHyx+2uyl2bvKIU2aPgN/apZDFxPvVLZfsF7AjywUNwKorufebYQx/v/1BEhE4eBCfvSkLNGZtUXGtOt7dZIBfuMRLQaSKQsFzr304ulx07b1nXTMe0BcBMLBirBIXQqRDkDhAzb2yC8aImCD1FsEc/H33myBcQSHPMJYHpBO8fZ56u+WLRDkvUDYSI5G0UMmS1FK6ygmkSkE5f4MRfn5T1XudAzDa/paoqD/dJdk8sEPw7D6mQUte3mVvocCNe9Z+RKF1LrVk4SWmxACDEDvASdwOd+zGqsyY6PI6sHHdihQ3ts7esP5TBv9isymuESoxwTv+PU2Cs49tE2moS6STdqVS0OERvD6v0BVH2kdAH+opwQduJZPIkYMwMoI8x25sIrtOeOrLk+qjB7pWFqRtE6ZVwBfS54gCkINfOY+etj7OV2wNiJp4YS/xX 2025-08-11 21:50:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 21:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 21:50:04 [INFO]: inside itemsold and closed 14409 2025-08-11 21:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:50:06 [INFO]: Ebay item id :: 335738152612 exists in Database 2025-08-11 21:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:50:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 21:50:06 [INFO]: inside itemsold and closed 14409 2025-08-11 21:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:50:08 [INFO]: Ebay item id :: 306004447739 exists in Database 2025-08-11 21:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:50:08 [INFO]: inside itemsold and closed 14409 2025-08-11 21:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 21:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 21:50:09 [INFO]: Ebay item id :: 335538981649 exists in Database 2025-08-11 21:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 21:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 21:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 21:50:09 [INFO]: in processold action queue is array for {"45143030":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45143030","ebayitemid":"335738152612","deleted":1}},"44595336":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595336","ebayitemid":"306004447739","shopifyproductid":"8784578740446","variants":[{"price":"119.99","quantity":0,"weight":"3","shopifyproductid":"8784578740446","shopifyvariantid":"46206036705502","shopifyinventoryid":"48305858019550","shopifylocationid":"","product_id":"44595336","variant_id":"77488045","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44583996":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44583996","ebayitemid":"335538981649","shopifyproductid":"8695010394334","variants":[{"price":"642.99","quantity":0,"weight":"18","shopifyproductid":"8695010394334","shopifyvariantid":"45933767393502","shopifyinventoryid":"48032218808542","shopifylocationid":"","product_id":"44583996","variant_id":"77476705","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 21:50:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 21:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 21:50:10 [INFO]: productIds WHich are having null productid -> [45143030] 2025-08-11 21:50:10 [INFO]: ebayItemIds WHich are not imported-> ["335738152612"] 2025-08-11 21:50:10 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 21:50:10 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 21:50:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45143030) 2025-08-11 21:50:10 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 21:50:10 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 21:50:10 [INFO]: Transaction committed successfully. 2025-08-11 21:50:10 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 21:50:10 [INFO]: Shopify Inventory id 48305858019550 2025-08-11 21:50:10 [INFO]: Shopify Location id 58450641063 2025-08-11 21:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T21:50: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 21:50:10 [INFO]: Change: available | Delta: -1 2025-08-11 21:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-11 21:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595336 and user_id = 14409 2025-08-11 21:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488045 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:50:10 [INFO]: Shopify Inventory id 48032218808542 2025-08-11 21:50:10 [INFO]: Shopify Location id 58450641063 2025-08-11 21:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 21:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T21:50:10Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-11 21:50:10 [INFO]: Change: available | Delta: -4 2025-08-11 21:50:10 [INFO]: Change: on_hand | Delta: -4 2025-08-11 21:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 21:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44583996 and user_id = 14409 2025-08-11 21:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77476705 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 21:50:10 [INFO]: updateIdsQuantity -> ["77488045","77476705"] 2025-08-11 21:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 21:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77488045 THEN 0 WHEN id = 77476705 THEN 0 END, quantityflag = CASE WHEN id = 77488045 THEN 0 WHEN id = 77476705 THEN 0 END WHERE user_id = 14409 AND id IN (77488045,77476705) 2025-08-11 21:50:10 [INFO]: QUANTITY Updated IDs: 77488045, 77476705 2025-08-11 21:50:10 [INFO]: Successfully processed data for user 14409 2025-08-11 21:50:10 [INFO]: Execution Started 2025-08-11 21:50:10 [INFO]: Execution Finished