2025-07-31 15:00:02 [INFO]: Execution Started 2025-07-31 15:00:02 [INFO]: old server sucessfully connected 2025-07-31 15:00:02 [INFO]: sqs client sucess created 2025-07-31 15:00:04 [INFO]: Number of messages in the queue: 3 2025-07-31 15:00:05 [INFO]: item found in queue is if condition 14409 2025-07-31 15:00:05 [INFO]: item found in queue is 14409 2025-07-31 15:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBCl7Zd3HM0OSLEnWkfyt1ENxSP03bQex5GfMwrGWhj3/+9xKkgBNnR4PQaDWNPYKbdzb2JRWFFC1+7CdFl5PogbS23nXw05FkzUIm/c8r+uVIyVxIRH5HJpFPmCP12/a67q4vvkG0un4ewqj/JLXHbPlHNCPgArmNhZhQIfs8moZ7jSQ6ZV54vOG6CwAXiZNSM+Rt0+7xCMwoNL/YLofwkWL/vMxmvQAQpsGkCMyDux8DGq2pVXzcYjVP0i0a9PGZ8CGSjT/j2k5B3zMupG+DpgFqVDUzh66mG2gSNmPgaFjc9gW6eAIE00mJPmpdk2BDJN4TBpPLiAwcvLZGhnmFyT0KcSRcYdQVGMD2brphGEKgZZMc2Cr5c/Z+TM9EKZa35LPZQrLHYjr120muIcEo2SHfQgtxm70wVAx86fYn0geCNGSeHgBDRMflsV6THYFD 2025-07-31 15:00:05 [INFO]: item found in queue is if condition 14409 2025-07-31 15:00:05 [INFO]: item found in queue is 14409 2025-07-31 15:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEB3aW7sgBFEGwOqs26bpvTL0nAXwRPpdpMtZrLvpSt2BackwxGKY5a3NqmJ6BGk0ylabiV7BU/PKHNAExPKKutFYzaJvOVRISAjcZA1kW50EJg1AdJQT/qlbv6AP3m8dCUZ+nJBdKyoZ6HrUX/4gOcIjRfJCsRjHAl5dWA0SfqxgVglktGLSYNJ2t/pErBn7B90Vb96qihoEjoyNQmxWp4NiYH9Q6JkROSrjj4hYQsLPGnle864p6D/eCBSbuZHGYm2XcmwoR2ZKxze/56XQGyhibZa6Sw9KdVeiN4Kj69I6IwURMp0CpitnjmWFD9mIR+eIEQutbVkoLFjpuReZIr1q0hevTq3MCUeNg9j27bLIaWCiUqCMpfhdwiI6UAvaR7iYiS0DAweNJem3OcFHC8IlUMRB+BHDORTwPMzMcal4GBuLGMkm2VzcSbj6hMuwzo 2025-07-31 15:00:06 [INFO]: item found in queue is if condition 14409 2025-07-31 15:00:06 [INFO]: item found in queue is 14409 2025-07-31 15:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBO1GYT9yZb3StwZPKhOd9CMCdiXs2TzF69p+Bq3+kFZ3Qq/ql+UMi+wj6Evc00LmimefOHtxX7L85ISnql26epBIJlp7Xun7Wdy7ACLg3XSZDnAuVXViN/Hr2TPaVHYWshP6Eatx0QyVR7YECTI4lwVwbI6vHlG+embNtkvHqmToO/Lc5AK8NFL4pCELCSdJXw/DgPJhIH96THhV0O21hGyZzz6TBmNFDZUZtfHTwH8d3hMjKFA13VSISU2p+GMLq8l8yr3ibAtur+ORwHxPWq0G0XiudK1VRtJVNaQUdWK9FujyNER9lPVG35dF6VUY0vRRBEEwDgiOgIcM12oek8NpMSDn1gl2zcw2aCLpm4zYv/UXv2/tK9sZVGzFzAs/s+4xXa7T2aZvja/mybK/jj0aL/6lTiSaQx1or6vxXTQDChlY7bVvC8uHS1++HrTYf 2025-07-31 15:00:07 [INFO]: Processed 3 messages, reached the limit of 3. 2025-07-31 15:00:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 15:00:07 [INFO]: inside itemsold and closed 14409 2025-07-31 15:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:00:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:00:08 [INFO]: Ebay item id :: 226715758373 exists in Database 2025-07-31 15:00:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:00:08 [INFO]: inside itemsold and closed 14409 2025-07-31 15:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:00:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:00:10 [INFO]: Ebay item id :: 404798638546 exists in Database 2025-07-31 15:00:10 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:00:10 [INFO]: inside itemsold and closed 14409 2025-07-31 15:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:00:12 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:00:12 [INFO]: Ebay item id :: 404798638546 exists in Database 2025-07-31 15:00:12 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:00:12 [INFO]: in processold action queue is array for {"44710040":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710040","ebayitemid":"226715758373","shopifyproductid":"8885236498654","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8885236498654","shopifyvariantid":"46639659483358","shopifyinventoryid":"48742624919774","shopifylocationid":"","product_id":"44710040","variant_id":"77617653","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44642667":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642667","ebayitemid":"404798638546","shopifyproductid":"8920753012958","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8920753012958","shopifyvariantid":"46785365672158","shopifyinventoryid":"48883879411934","shopifylocationid":"58450641063","product_id":"44642667","variant_id":"77547856","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 15:00:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 15:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:00:12 [INFO]: Shopify Inventory id 48742624919774 2025-07-31 15:00:12 [INFO]: Shopify Location id 58450641063 2025-07-31 15:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:00: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-07-31 15:00:12 [INFO]: Change: available | Delta: 1 2025-07-31 15:00:12 [INFO]: Change: on_hand | Delta: 1 2025-07-31 15:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710040 and user_id = 14409 2025-07-31 15:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77617653 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:00:12 [INFO]: Shopify Inventory id 48883879411934 2025-07-31 15:00:12 [INFO]: Shopify Location id 58450641063 2025-07-31 15:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:00:13Z","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-07-31 15:00:13 [INFO]: Change: available | Delta: -2 2025-07-31 15:00:13 [INFO]: Change: on_hand | Delta: -2 2025-07-31 15:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642667 and user_id = 14409 2025-07-31 15:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547856 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:00:13 [INFO]: updateIdsQuantity -> ["77617653","77547856"] 2025-07-31 15:00:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 15:00:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77617653 THEN 0 WHEN id = 77547856 THEN 0 END, quantityflag = CASE WHEN id = 77617653 THEN 0 WHEN id = 77547856 THEN 0 END WHERE user_id = 14409 AND id IN (77617653,77547856) 2025-07-31 15:00:13 [INFO]: QUANTITY Updated IDs: 77617653, 77547856 2025-07-31 15:00:13 [INFO]: Successfully processed data for user 14409 2025-07-31 15:00:13 [INFO]: Execution Started 2025-07-31 15:00:13 [INFO]: Execution Finished 2025-07-31 15:10:01 [INFO]: Execution Started 2025-07-31 15:10:01 [INFO]: old server sucessfully connected 2025-07-31 15:10:01 [INFO]: sqs client sucess created 2025-07-31 15:10:03 [INFO]: Number of messages in the queue: 2 2025-07-31 15:10:04 [INFO]: item found in queue is if condition 14409 2025-07-31 15:10:04 [INFO]: item found in queue is 14409 2025-07-31 15:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB8YzB8lMbq2BT8pGLQKXOJgI4B8mvmB1XdRLxKcCqsInd3v5ZpAV10NA1R9eD36mTWlnjdsj9s9XTquEg7OgM6ynbM8ZdnFquPpcC8FH3xrYxu7vYNUq4u2re0E5GZeH/4i9nCHg9nMyQoL2dX6ShBq8q4i7sstevasU/Y7cCdnv8MGpruqtc+lVAkHWjVkWgkFYBJuYCImtdQOuFcHPl+ZYxJWreHp5rPEQmm8wE0pFl14meOC42b/291pRBk/HaHB0FaoMAXoKrckPRF3KSnb9EIl00MtXZWE8VsDOtb/Qpl8PdkKd8GQCgNrZ6YLCo+3JBNzHvTgqDkhGVvFZd9pDdv4OD9guEOUDvhQ87eLWFxtfC8lCqdEZSR6WFOSLLPiEqgUfrG3xWjoop64Y0bSwdGm9517I0J5GwzEXoaECgNVL8OHlo3h/nZAFrwxm9 2025-07-31 15:10:04 [INFO]: item found in queue is if condition 14409 2025-07-31 15:10:04 [INFO]: item found in queue is 14409 2025-07-31 15:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBht9+oyNNn5J3WdKveEwy7eldx9Ms20/3uBxaJ6mXM9B0CfyRmFyzeFrO840PTONPXfnHs9nrSn7yhllCG/mDaNEjOCSxeXg46Pz3X3FjS3NRaePNtRddS+MpHe6o2FN4qLiGFoLxVhFsG8fz8xeAqHjxDzV2nFEHTNBwvOVb4lL7TRaW4LVLNw+BZEUDpbnfddt9cQrO/sia7xlvljLVWpBterEaxlLM3mYYjQzrEY/ApG1AA1ldIiCFwQR6vj+5/rha34tlWFM7g7my3NuwnEIG40z6SbRst6l7QDQHKXDREcpcvFWbXP9Mv7UVrzYrYVDaMBXOLi7YVhv71FJ7WjCFORxQH6Hb5yFS6s2XmljCw9y/fp0T/6jiXsCb8f6F1DQQDVGR/lkPCVfc9sknk/9jo/vGNeZyq2iX7odfBMtpkftMem4F1knQoTgqoxy1 2025-07-31 15:10:05 [INFO]: Processed 2 messages, reached the limit of 2. 2025-07-31 15:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 15:10:05 [INFO]: inside itemsold and closed 14409 2025-07-31 15:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:10:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:10:07 [INFO]: Ebay item id :: 285688908391 exists in Database 2025-07-31 15:10:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:10:07 [INFO]: inside itemsold and closed 14409 2025-07-31 15:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:10:09 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:10:09 [INFO]: Ebay item id :: 256413551630 exists in Database 2025-07-31 15:10:09 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:10:09 [INFO]: in processold action queue is array for {"44771469":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771469","ebayitemid":"285688908391","shopifyproductid":"8696047567070","variants":[{"price":"52.99","quantity":0,"weight":"3","shopifyproductid":"8696047567070","shopifyvariantid":"45936014983390","shopifyinventoryid":"48034463219934","shopifylocationid":"","product_id":"44771469","variant_id":"77680011","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44645171":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44645171","ebayitemid":"256413551630","shopifyproductid":"8697504563422","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8697504563422","shopifyvariantid":"45939307413726","shopifyinventoryid":"48037767119070","shopifylocationid":"","product_id":"44645171","variant_id":"77550360","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 15:10:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 15:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:10:09 [INFO]: Shopify Inventory id 48034463219934 2025-07-31 15:10:09 [INFO]: Shopify Location id 58450641063 2025-07-31 15:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15: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-07-31 15:10:09 [INFO]: Change: available | Delta: -1 2025-07-31 15:10:09 [INFO]: Change: on_hand | Delta: -1 2025-07-31 15:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771469 and user_id = 14409 2025-07-31 15:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680011 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:10:09 [INFO]: Shopify Inventory id 48037767119070 2025-07-31 15:10:09 [INFO]: Shopify Location id 58450641063 2025-07-31 15:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:10:09Z","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-07-31 15:10:09 [INFO]: Change: available | Delta: -2 2025-07-31 15:10:09 [INFO]: Change: on_hand | Delta: -2 2025-07-31 15:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44645171 and user_id = 14409 2025-07-31 15:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77550360 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:10:09 [INFO]: updateIdsQuantity -> ["77680011","77550360"] 2025-07-31 15:10:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 15:10:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77680011 THEN 0 WHEN id = 77550360 THEN 0 END, quantityflag = CASE WHEN id = 77680011 THEN 0 WHEN id = 77550360 THEN 0 END WHERE user_id = 14409 AND id IN (77680011,77550360) 2025-07-31 15:10:09 [INFO]: QUANTITY Updated IDs: 77680011, 77550360 2025-07-31 15:10:09 [INFO]: Successfully processed data for user 14409 2025-07-31 15:10:09 [INFO]: Execution Started 2025-07-31 15:10:09 [INFO]: Execution Finished 2025-07-31 15:20:01 [INFO]: Execution Started 2025-07-31 15:20:01 [INFO]: old server sucessfully connected 2025-07-31 15:20:01 [INFO]: sqs client sucess created 2025-07-31 15:20:03 [INFO]: Number of messages in the queue: 1 2025-07-31 15:20:03 [INFO]: item found in queue is if condition 14409 2025-07-31 15:20:03 [INFO]: item found in queue is 14409 2025-07-31 15:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB2llDDWDCqsnp1sofk3+pPY4/hWms/Z0F5dURF9iLrLHVliWbf7WkNKfmtdDtmbISExWvfUQRcdqZ87g+nNn6A7/ytSkh5w4xVz6eZnl+VswQoQls+idXbIXYUJWjwCl/LxVtARsHn4pxE+EOSCi+V34rGYiXrmBzvJZUKYTRJ/Q/RNkS+Nk3eiy7FXRzwxhcTd2kg44e8cmfhgxvM18fCAOsAAGrUoRPXyuyUDe9Z5I3sjhs/hl18TJbAW3Rz0Gvm7jd5cs9cM9GTiWsMS2vlS/+c1GGXWpXD/p1ks5nh4CZW8Sf9KPfjXPdVP0j7YvFTq8426JvIJ6yA2AOSf9O8BIIpWBkd4JbyNW936HTQRR9gV4+V6DuYhrhOPa2wd6hD1g3+h+64pPsp+fFJGXmP6Dxw5LkEZoIWCGg7ZRBw50LrAHeGrTmQnzE/zttmB3u 2025-07-31 15:20:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 15:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 15:20:04 [INFO]: inside itemsold and closed 14409 2025-07-31 15:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:20:06 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:20:06 [INFO]: Ebay item id :: 226869055791 exists in Database 2025-07-31 15:20:06 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:20:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 15:20:06 [INFO]: in processold action queue is array for {"45237121":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45237121","ebayitemid":"226869055791","deleted":1}}} 2025-07-31 15:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 15:20:06 [INFO]: productIds WHich are having null productid -> [45237121] 2025-07-31 15:20:06 [INFO]: ebayItemIds WHich are not imported-> ["226869055791"] 2025-07-31 15:20:06 [INFO]: Entered in bulkUpdateProducts function 2025-07-31 15:20:06 [INFO]: Transaction started for bulkUpdateProducts 2025-07-31 15:20:06 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45237121) 2025-07-31 15:20:06 [INFO]: Query executed successfully. Affected rows: 0 2025-07-31 15:20:06 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-07-31 15:20:06 [INFO]: Transaction committed successfully. 2025-07-31 15:20:06 [INFO]: Transaction ended for bulkUpdateProducts 2025-07-31 15:20:06 [INFO]: Successfully processed data for user 14409 2025-07-31 15:20:06 [INFO]: Execution Started 2025-07-31 15:20:06 [INFO]: Execution Finished 2025-07-31 15:30:02 [INFO]: Execution Started 2025-07-31 15:30:02 [INFO]: old server sucessfully connected 2025-07-31 15:30:02 [INFO]: sqs client sucess created 2025-07-31 15:30:03 [INFO]: Number of messages in the queue: 1 2025-07-31 15:30:03 [INFO]: item found in queue is if condition 14409 2025-07-31 15:30:03 [INFO]: item found in queue is 14409 2025-07-31 15:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBRtDYznA6yeXr4F4xhlIQQKKQdc7165NdjopH6y6f9snKsy6zkho6dotXAtQBSZISkyflW9+AITIUHWmA2tI92xfiwwnpHm8Z8whIPqw0+hGOCD68U8Qy0Skawiv4aNXimK3oIRBqplPvGZmRwQXLKxI0t1xVxs9gV8+aODZE46Nkob4i3NPy8/c3L3aQJ0X4iuVlex7rbWA3bm1OGxJetev+zcu/dTuMqARubNS9tOat08upo1bzkC7T1+70yTl4GCpV0cIejlI8oFTz05BopgkEYueeB+rTPDNcgWx9uDp58iWrVsnDFIaO4RTCfdn+xaFamqoeS3x/Lq/gc+Zib41dOIGWBbaSsvwM1TLAz9vEquj128Lc/Su0es9+Vl4jM7zKg7vva53gt0pGRm6vPDoyqJLDyEm81H9fBjLaGuuf1MIx37MbGizeC9FVpQHG 2025-07-31 15:30:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 15:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 15:30:04 [INFO]: inside itemsold and closed 14409 2025-07-31 15:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:30:06 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:30:06 [INFO]: Ebay item id :: 303747337396 exists in Database 2025-07-31 15:30:06 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:30:06 [INFO]: in processold action queue is array for {"44598258":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598258","ebayitemid":"303747337396","shopifyproductid":"6690656420007","variants":[{"price":"9.84","quantity":0,"weight":"0.75","shopifyproductid":"6690656420007","shopifyvariantid":"39937833435303","shopifyinventoryid":"42032787357863","shopifylocationid":"","product_id":"44598258","variant_id":"77490967","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 15:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 15:30:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:30:06 [INFO]: Shopify Inventory id 42032787357863 2025-07-31 15:30:06 [INFO]: Shopify Location id 58450641063 2025-07-31 15:30:06 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:30:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:30: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-07-31 15:30:06 [INFO]: Change: available | Delta: 1 2025-07-31 15:30:06 [INFO]: Change: on_hand | Delta: 1 2025-07-31 15:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598258 and user_id = 14409 2025-07-31 15:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490967 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:30:06 [INFO]: updateIdsQuantity -> ["77490967"] 2025-07-31 15:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 15:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77490967 THEN 0 END, quantityflag = CASE WHEN id = 77490967 THEN 0 END WHERE user_id = 14409 AND id IN (77490967) 2025-07-31 15:30:06 [INFO]: QUANTITY Updated IDs: 77490967 2025-07-31 15:30:06 [INFO]: Successfully processed data for user 14409 2025-07-31 15:30:06 [INFO]: Execution Started 2025-07-31 15:30:06 [INFO]: Execution Finished 2025-07-31 15:40:01 [INFO]: Execution Started 2025-07-31 15:40:01 [INFO]: old server sucessfully connected 2025-07-31 15:40:01 [INFO]: sqs client sucess created 2025-07-31 15:40:03 [INFO]: Number of messages in the queue: 1 2025-07-31 15:40:03 [INFO]: item found in queue is if condition 14409 2025-07-31 15:40:03 [INFO]: item found in queue is 14409 2025-07-31 15:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+yD4BK6+NVPNzc6Io2OXV6TiFgyWK7tnPIhRm9slIoJzfgZCO0UWumHbvxqMpO+ZuY+YbBaYgZgTVqwZ0gLLvo1bEO4Nref1D0Bea0h5NfgDLzeHttok0drsDYryBZguqUi/f9bG9FK3+rdjOmMhtw8Y6yzM7YCbFLN3HXfM3S1ZGjV0EtGOF2ARRvjX4kL246aYsOPCjSu/wX5M922wWn9M54n4r+fDzwLKj35UlnjB7OYPnhKjSIPJgDjAsEbww4195DuY+61dqEE536K/YqgMGsHX8IwtkMyNycn0MYnHf9q2nDI5XcITZ/btBY3EBDDNyRO0pEHG65wWPLjaRF7VrX90POpBHygQwuTFwwXYd6yp3/NCPh/OAw5JUtB6ORTiUbqMWNaBlnseJsx82kJykA4DNouC6Vz1yQAooLIDkdS9V9fLOlKWlwHZ5+2m 2025-07-31 15:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 15:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 15:40:03 [INFO]: inside itemsold and closed 14409 2025-07-31 15:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:40:05 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:40:05 [INFO]: Ebay item id :: 335538449327 exists in Database 2025-07-31 15:40:05 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:40:05 [INFO]: in processold action queue is array for {"44582809":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582809","ebayitemid":"335538449327","shopifyproductid":"8697425821918","variants":[{"price":"42.99","quantity":0,"weight":"2","shopifyproductid":"8697425821918","shopifyvariantid":"45939166806238","shopifyinventoryid":"48037623267550","shopifylocationid":"","product_id":"44582809","variant_id":"77475518","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 15:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 15:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:40:05 [INFO]: Shopify Inventory id 48037623267550 2025-07-31 15:40:05 [INFO]: Shopify Location id 58450641063 2025-07-31 15:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:40: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-07-31 15:40:05 [INFO]: Change: available | Delta: -1 2025-07-31 15:40:05 [INFO]: Change: on_hand | Delta: -1 2025-07-31 15:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582809 and user_id = 14409 2025-07-31 15:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475518 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:40:05 [INFO]: updateIdsQuantity -> ["77475518"] 2025-07-31 15:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 15:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77475518 THEN 0 END, quantityflag = CASE WHEN id = 77475518 THEN 0 END WHERE user_id = 14409 AND id IN (77475518) 2025-07-31 15:40:05 [INFO]: QUANTITY Updated IDs: 77475518 2025-07-31 15:40:05 [INFO]: Successfully processed data for user 14409 2025-07-31 15:40:05 [INFO]: Execution Started 2025-07-31 15:40:05 [INFO]: Execution Finished 2025-07-31 15:50:02 [INFO]: Execution Started 2025-07-31 15:50:02 [INFO]: old server sucessfully connected 2025-07-31 15:50:02 [INFO]: sqs client sucess created 2025-07-31 15:50:03 [INFO]: Number of messages in the queue: 2 2025-07-31 15:50:04 [INFO]: item found in queue is if condition 14409 2025-07-31 15:50:04 [INFO]: item found in queue is 14409 2025-07-31 15:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB71ylPn6mEzjVu/8GHJqlCt9S3wpaieprZQQ6OhWCyjDQ6Rl4d0gjgBF+o9IKfAXovpYuMVYKdhnUsm8OpaW3ROdZBiREgS1HX9dy5nsbLODmvzwK84lpdulsc2WDCFgPnEvGNMSm/USSEgNM0z8COykp4g0V4HT/AcPfmC2RjQmDACY58nigW+a9jcsr9UDFtS09Ipes2lVBVyHh2B0ZkhdwW7OohOVhuC91787y7nETWJjLiPYLmGEQJlsRGvXcsP+EpcL0Sqz1QAtGDao//PJvHp2ZmfnUhrM/1vUJqIgwJnfKivLEgUREq/AUADJWtN1zZpGZqPF4Lbc63wjdN+i0Tsoc/bl6LAEPFhUAMKNqtrJz9kGdI9No6+Pi97oUZCO/gyZBfBdiYHx9zW79Aq+jxVu5zcMXdX5j7jGB6ynOdmeM4jkj0M48KnTOnTYN 2025-07-31 15:50:04 [INFO]: item found in queue is if condition 14409 2025-07-31 15:50:04 [INFO]: item found in queue is 14409 2025-07-31 15:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBB7KAENbFOci+BanVyJUvQ0v1ex1OZCSJBtIN47D7DMaSEp1u8i2aTN+ykoz1YWDuVqyF72Mq+dRG8ccSqKFNvFmbGSi8VqHNBwPqQxuUkjdsA9i9cfLiDjcIdWch201jjDJro0dMNEnd18TJ0PIeaAf8bia/Ek7OX7eUu0r9mS1VcM/AxTcRWtsmp40sY6hulY19K7dXnZIj4fJKrJ22YQ9VICpQZ3vHWGlWrSQ7dnmgn+NVkTt0LRjmKpjed2whOIk4uCGwkbOQbuwxGP5d1YjHrRout5dkVr/Rze3gQQXSn5sGw4IhbqRolXysaOBGb+Jw2zeVrlGTUAIGv6fE6Qzg3f8JxBZ3CGsMdfw/qwdGmbse3qCCUXdCRH/Y8BpSPxMb9fsPp/jlfNPq+M40eGxVTQC1pv0g1QpqjDzhgLYkMoVAU2R0Tyyon5pIAdX9 2025-07-31 15:50:05 [INFO]: Processed 2 messages, reached the limit of 2. 2025-07-31 15:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 15:50:05 [INFO]: inside itemsold and closed 14409 2025-07-31 15:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:50:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:50:07 [INFO]: Ebay item id :: 335223398851 exists in Database 2025-07-31 15:50:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:50:07 [INFO]: inside itemsold and closed 14409 2025-07-31 15:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 15:50:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 15:50:08 [INFO]: Ebay item id :: 305118795499 exists in Database 2025-07-31 15:50:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 15:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 15:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 15:50:08 [INFO]: in processold action queue is array for {"44587358":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587358","ebayitemid":"335223398851","shopifyproductid":"8262002770142","variants":[{"price":"13.99","quantity":0,"weight":"0.75","shopifyproductid":"8262002770142","shopifyvariantid":"44700668199134","shopifyinventoryid":"46798632648926","shopifylocationid":"","product_id":"44587358","variant_id":"77480067","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44557956":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557956","ebayitemid":"305118795499","shopifyproductid":"8122502578398","variants":[{"price":"13.99","quantity":0,"weight":"0.75","shopifyproductid":"8122502578398","shopifyvariantid":"44335067398366","shopifyinventoryid":"46432746766558","shopifylocationid":"","product_id":"44557956","variant_id":"77450636","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 15:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 15:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 15:50:08 [INFO]: Shopify Inventory id 46798632648926 2025-07-31 15:50:08 [INFO]: Shopify Location id 58450641063 2025-07-31 15:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:50: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-07-31 15:50:09 [INFO]: Change: available | Delta: -1 2025-07-31 15:50:09 [INFO]: Change: on_hand | Delta: -1 2025-07-31 15:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587358 and user_id = 14409 2025-07-31 15:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480067 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:50:09 [INFO]: Shopify Inventory id 46432746766558 2025-07-31 15:50:09 [INFO]: Shopify Location id 58450641063 2025-07-31 15:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 15:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T15:50: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-07-31 15:50:09 [INFO]: Change: available | Delta: -1 2025-07-31 15:50:09 [INFO]: Change: on_hand | Delta: -1 2025-07-31 15:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 15:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557956 and user_id = 14409 2025-07-31 15:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77450636 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 15:50:09 [INFO]: updateIdsQuantity -> ["77480067","77450636"] 2025-07-31 15:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-07-31 15:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77480067 THEN 0 WHEN id = 77450636 THEN 0 END, quantityflag = CASE WHEN id = 77480067 THEN 0 WHEN id = 77450636 THEN 0 END WHERE user_id = 14409 AND id IN (77480067,77450636) 2025-07-31 15:50:09 [INFO]: QUANTITY Updated IDs: 77480067, 77450636 2025-07-31 15:50:09 [INFO]: Successfully processed data for user 14409 2025-07-31 15:50:09 [INFO]: Execution Started 2025-07-31 15:50:09 [INFO]: Execution Finished