2025-08-07 15:00:02 [INFO]: Execution Started 2025-08-07 15:00:02 [INFO]: old server sucessfully connected 2025-08-07 15:00:02 [INFO]: sqs client sucess created 2025-08-07 15:00:05 [INFO]: Number of messages in the queue: 2 2025-08-07 15:00:07 [INFO]: item found in queue is if condition 14409 2025-08-07 15:00:07 [INFO]: item found in queue is 14409 2025-08-07 15:00:14 [INFO]: Message deleted from the queue for receipt handle: AQEByTT7dFgQLihp6HAXlGsUoS0xRKB2s/6kjOrx3wbknoLaYYCb2hiHYxn6uE3YeybKZA8A/2iJfol5YzjqSiDyXc9fK9NQs3ky7B1iBVOiEb/gcHxYpB67I9nIb1Y9oypdW1LcaW/Py2KEbrL3YtCJ9AWAOBctonEjmngOLBRh+fkt7NCjomSIsdsSji/0Lpnk9Df7QGi4dFt+Z8JCjnUf7Q4sfJScWBPxJiu5iUuJtRwUy3k9PE60YrBcTPCn8EznypcmPMpqEXNutg4K2h3B6K/IS8PzWKSP131zrn4Ji/t3JYuxB97QRaqOm7bRmsmOriac9vCIQ52fm8CCYFPNxXLbV1H4IWrT6+zTnQZYXDzQbR4r5TsNBgI/mKbiPWExVFTw+JAHnXZpE2FGWtdKoGF0248tY4JlV2ONaIhfs+0ygm71Dytfh8bqmpBRW19k 2025-08-07 15:00:15 [INFO]: item found in queue is if condition 14409 2025-08-07 15:00:15 [INFO]: item found in queue is 14409 2025-08-07 15:00:17 [INFO]: Message deleted from the queue for receipt handle: AQEBbHtAuOiEP9dR3CMxe5596i7cgJtQ6NLalqnzyNJuPMqgjbuwlM3uaYsr064U+FGXFrZlSXHv64XieoY7tMm1s7BjZvS9lR3dvxliVAEZMxAj31B5FVSGwuaU4Ut+xayAIDiwr/yy95TNgX9pFAtmbSauAQCKx4+XdPnP4GvWnOIjtcZsmGnbbZGPtSsZF79DFsjQy/+r5AMARK65s+XiIxnkcsCpcqfK49zbV1ha3uysCvP5uxx3n6i6bxntUCLTIW5piBRCGgeECgdLxY66TaURF5bb8qKVWyJwvKpS4i0l/bXk6BQ7u05+N2B7ved4yYv6pVIunwBcf+gxeA6eW4JtDi68/Q1KaJ8xjdzzoyYLUDQyqdMQFD18X7h+ftT2tmX3sCJvs9h0D8ztfW2vt44sVockryi13fM/Y7cTEGetm+868l/P5HF3wFHANES4 2025-08-07 15:00:17 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 15:00:17 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 15:00:17 [INFO]: inside itemsold and closed 14409 2025-08-07 15:00:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:00:19 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:00:19 [INFO]: Ebay item id :: 226896190546 exists in Database 2025-08-07 15:00:19 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:00:19 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 15:00:19 [INFO]: inside itemsold and closed 14409 2025-08-07 15:00:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:00:20 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:00:20 [INFO]: Ebay item id :: 335669135253 exists in Database 2025-08-07 15:00:20 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:00:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:00:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:00:20 [INFO]: in processold action queue is array for {"45312840":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45312840","ebayitemid":"226896190546","deleted":1}},"44568353":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44568353","ebayitemid":"335669135253","shopifyproductid":"8111148531934","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8111148531934","shopifyvariantid":"44312758288606","shopifyinventoryid":"46410251993310","shopifylocationid":"","product_id":"44568353","variant_id":"77461037","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 15:00:20 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 15:00:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:00:20 [INFO]: productIds WHich are having null productid -> [45312840] 2025-08-07 15:00:20 [INFO]: ebayItemIds WHich are not imported-> ["226896190546"] 2025-08-07 15:00:20 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 15:00:20 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 15:00:20 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45312840) 2025-08-07 15:00:20 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 15:00:20 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 15:00:20 [INFO]: Transaction committed successfully. 2025-08-07 15:00:20 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 15:00:20 [INFO]: Shopify Inventory id 46410251993310 2025-08-07 15:00:20 [INFO]: Shopify Location id 58450641063 2025-08-07 15:00:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:00:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:00:21Z","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-07 15:00:21 [INFO]: Change: available | Delta: -1 2025-08-07 15:00:21 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:00:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:00:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44568353 and user_id = 14409 2025-08-07 15:00:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77461037 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:00:21 [INFO]: updateIdsQuantity -> ["77461037"] 2025-08-07 15:00:21 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 15:00:21 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77461037 THEN 0 END, quantityflag = CASE WHEN id = 77461037 THEN 0 END WHERE user_id = 14409 AND id IN (77461037) 2025-08-07 15:00:21 [INFO]: QUANTITY Updated IDs: 77461037 2025-08-07 15:00:21 [INFO]: Successfully processed data for user 14409 2025-08-07 15:00:21 [INFO]: Execution Started 2025-08-07 15:00:21 [INFO]: Execution Finished 2025-08-07 15:10:01 [INFO]: Execution Started 2025-08-07 15:10:01 [INFO]: old server sucessfully connected 2025-08-07 15:10:01 [INFO]: sqs client sucess created 2025-08-07 15:10:06 [INFO]: Number of messages in the queue: 3 2025-08-07 15:10:08 [INFO]: item found in queue is if condition 14409 2025-08-07 15:10:08 [INFO]: item found in queue is 14409 2025-08-07 15:10:09 [INFO]: Message deleted from the queue for receipt handle: AQEBRtkKP5wRmVsjtKFbUA68wXXyazxO0LoKjtCuPwQQKGgQvDuXu5kmH+pUruUrzr2Z3xU4n4Tp2rNJnbKc8wlY1ANsfiXsiBytSbOj7slg80RPhqucfkzjOwV3kE8T7FLlNel4qipbA9k5jtw4RNrPew5zxp/IPYazJ5VbQkJLSW1i8R1bFnqcftC2EVoMPQCrKFBv385xogHp+/v+f8BqRhmlTmMOupI/c9lFiY7epqQupDAowr5ov8S+y4z+fk0uRw6DOXw+iURGwYrzwptwDaJhzI9gX02qS/KwNYoCztHytwoQtIdtBo8k/P170iW1IlvXH15q1sVIamfzX4TLX6xyPf/3Sv5h+YgKzhX17V8UH+YigC26Axha4UPS+IIiihQCjTxtLGkCGWlyb0LwExbzRcuIP9TYL2lzRwR6ySYSqI9kAF44eYQ0nQ2AYYQI 2025-08-07 15:10:09 [INFO]: item found in queue is if condition 14409 2025-08-07 15:10:09 [INFO]: item found in queue is 14409 2025-08-07 15:10:11 [INFO]: Message deleted from the queue for receipt handle: AQEB2cOW4H3oAjk874WjXOspUS5wCERSBsvKadR0kBkzWy8akBA29PL03VVuXsmql44F1ELbpfbdrqAPamgpMXqToUSFuZRjzPVBnFDJEEOdzRfy1lDNQehtzc2RjR+TfQA0w32rAEMMT86A54C9bZTUtc8ijgAjL9Njogkp6aFge1OJLrFdB+hst1sbMRZ4p4CsPCmpODAtoUu4Id7iC+s2vjCq80Qi+3kdPwX3Mi+g9P5puZI2HmA6IyOykiTuaqA4ZJWvIM5s8akZqKHzFNzvxWjn4FqbT0h+8+qYA54wXmfdonpQus7micGYl0klurpyp8Et/k90/ZmRemC6R141i7uU7BfUl2pUojF20WnEja6t20HS1iO9qPmGKeGt2P03MWTvqbQeptuO+I7KHlhSkAH562hhFVkxVdWILN/9V5C6dFPSEKvrUq3HE6cJYHNT 2025-08-07 15:10:15 [INFO]: item found in queue is if condition 14409 2025-08-07 15:10:15 [INFO]: item found in queue is 14409 2025-08-07 15:10:16 [INFO]: Message deleted from the queue for receipt handle: AQEBL7I0GXwExdQmzlDZIwRH3IehxB2HMB/lF9zy8zrbVhn96GczztdgXAbUxg6YxKAbdAe9Nk9rF7RBHYa/y5IctvYkwlEFfDavPSd7Gu6+bKucwc6D9uuPC5H0SeBrOBXJnc9GFieBztpkjKytacMLjIQISYjkjs6GlofNTNcN+qU2EhMuG+nwkaOxs+u3GAoDzY4IfC+xtBsSUv6FvuD94xnWvBVJRBuG51EmQZWEEJteOOVqcP87MR6QcmoOyi/sXAH4M8FcMOzNExOsBvIWIr1YVmGzvCrt7xzBttfls9MiBGz7vxj4I0DShGyvl94X7zf5hrZElUQrdRV6aUvL/Ig3IwJjihlBDGxHn2QOtlMrmRjqgTmJCp5F9qqpZZfZYqhxkmiOol4Tupa+D2dXMbrz/CNboYsxeQTcxaXao/4Eb8s0pRXmK5Q6HKYBIgjg 2025-08-07 15:10:16 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 15:10:16 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 15:10:16 [INFO]: inside itemsold and closed 14409 2025-08-07 15:10:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:10:17 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:10:17 [INFO]: Ebay item id :: 286158135971 exists in Database 2025-08-07 15:10:17 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:10:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:10:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:10:17 [INFO]: inside itemsold and closed 14409 2025-08-07 15:10:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:10:19 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:10:19 [INFO]: Ebay item id :: 226897942390 exists in Database 2025-08-07 15:10:19 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:10:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:10:19 [INFO]: inside itemsold and closed 14409 2025-08-07 15:10:21 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:10:21 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:10:21 [INFO]: Ebay item id :: 286366639707 exists in Database 2025-08-07 15:10:21 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:10:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:10:21 [INFO]: in processold action queue is array for {"44568368":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44568368","ebayitemid":"286158135971","shopifyproductid":"8286029152478","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8286029152478","shopifyvariantid":"44806484623582","shopifyinventoryid":"46904512053470","shopifylocationid":"","product_id":"44568368","variant_id":"77461052","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 15:10:21 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 15:10:21 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:10:21 [INFO]: Shopify Inventory id 46904512053470 2025-08-07 15:10:21 [INFO]: Shopify Location id 58450641063 2025-08-07 15:10:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:10:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:10:21Z","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-07 15:10:21 [INFO]: Change: available | Delta: -1 2025-08-07 15:10:21 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:10:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:10:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44568368 and user_id = 14409 2025-08-07 15:10:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77461052 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:10:21 [INFO]: updateIdsQuantity -> ["77461052"] 2025-08-07 15:10:21 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 15:10:21 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77461052 THEN 0 END, quantityflag = CASE WHEN id = 77461052 THEN 0 END WHERE user_id = 14409 AND id IN (77461052) 2025-08-07 15:10:21 [INFO]: QUANTITY Updated IDs: 77461052 2025-08-07 15:10:21 [INFO]: Successfully processed data for user 14409 2025-08-07 15:10:21 [INFO]: Execution Started 2025-08-07 15:10:21 [INFO]: Execution Finished 2025-08-07 15:20:01 [INFO]: Execution Started 2025-08-07 15:20:01 [INFO]: old server sucessfully connected 2025-08-07 15:20:01 [INFO]: sqs client sucess created 2025-08-07 15:20:03 [INFO]: Number of messages in the queue: 6 2025-08-07 15:20:04 [INFO]: item found in queue is if condition 14409 2025-08-07 15:20:04 [INFO]: item found in queue is 14409 2025-08-07 15:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnwk13bP3Ug49l9kvikGuE/i0ikXL2kDZ3L+Okxr8rcIbws76lsgjzp2mZEKhG9YdRMKMdk8d48vqi7fPSehtdprTXbn+urIuOSJ1ESI6BEFiB4IVgRU1cKPs9znSSkw5fdHexyXrBJq3/t6dGIHtzUlxwwETy/ExP3WV9Ioz6hl1HBlZg5h/ZxQn+GoNhCTmtgNTtctz863RqhI8E5bV6w0sDlAVJ807duQ1iHV3kSfUgIb5WyXb61FyPy4xQT5y5BIpvoiOWRO3EHJDwuiBMJz2/GRLxwlYdCiysPF42iHo1djBp7U01/DEDSFmYKI5pARpRp20d2LbfaWa6ktKt/5VO/H0r9BjAbP4TuS5vPdJAXKu5QXxdclUfePBi9SksDpldrYtnzjI8pD0uFmazGnxSUzYBgf+SlU8hr7QItFvzE+BvUSaGn1fsj7TSmOS 2025-08-07 15:20:05 [INFO]: item found in queue is if condition 14409 2025-08-07 15:20:05 [INFO]: item found in queue is 14409 2025-08-07 15:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBAvP/AtzdsgVoQkzkU++MnHiNRegl0v5jtRLmN9XcT7/ZWW45OxvsY98OwLXsWmVgUPY4irUCoo/NpHjdxxkY/h3N7pNDIQb3HW7WHyS//vjNYuF8e+etji3rAVLn1IYoEZGCwQXnXDV7wcB9IRTj/WTwGgIx6lSxKmx0bjm6IZZ4WQW9RT2ATXkt8fXfmNtCBs6uMtu7GY5LJVZtE7Eme4QHCcdObeLGkCzxgzrvHJVmB1KYZysBlcd5DQhylerFVeE8ZeLGaDqioP05S6ldH760JL+CKo8iZvvw7WkKG0UoKn4g/r3yUAcbIvWuW7Z3seGcJU69J2whET/NYPbfO53+grFvBrHuwkICn6uPS2Nc7v3ly353O2spK/iBvjj8OV/RKxLXcbCgm6ftpTIF3BLoNMm6AYIBBZHyfRhUXnn+afKg91V4f+ekWbX+5PSy 2025-08-07 15:20:06 [INFO]: item found in queue is if condition 14409 2025-08-07 15:20:06 [INFO]: item found in queue is 14409 2025-08-07 15:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBVdUZzYklp8xKhGQmJhwobkHXi6sT9fhA35j1/cgRc5ygxdt4N2ETQfPPYs2eLBOMwTEzSWUmQwVMI53tMzfHPHl+wkDf8IwjRhfAlVpgAJSbYnDoZpGf/PLBHbjOZwEUnnECKVsUWqfeMi+LAMija6AjB73C7aXbBQO6vGjRDJfKqM/01/vYxpWfjN1+2dfMtrWeAwC1W4UB1MBYcUqbDQNIzB83EoX5PoQhidSIFaeD0+1tcxnuZy55zuoFfb1M+lXCf3yCChm4WbeSmiVkftRe0TTuEghXyf4tivrhdeOZRyHIGAppZpTvlJtP3AB4en1a8OLGMQrlQNueoYGcLIdG93juF5jGJ2j+BTW1eirbJlyOkVdKRyy1KLXozReA9oWeOjer4HXQpppCy7mmoondzT3wkBTQR18fMP8XiU4fXT49JYxp67HxfjJMBeJZ 2025-08-07 15:20:07 [INFO]: item found in queue is if condition 14409 2025-08-07 15:20:07 [INFO]: item found in queue is 14409 2025-08-07 15:20:08 [INFO]: Message deleted from the queue for receipt handle: AQEBCfQImSlKTdQAIA4Yh6rvnLfjYB5Tb7/0MRKQeTOdX61O2IFEeW75F29YcCJDgd8fTwDSRwu698ESeu6HDpA/QDHweJDymsFPxsexDTUeYZzdDLzMHehwSZVQeH4Bqz+LPSSgY6lYjjhSn0DizCnKiy/5WDGeEClGxn1ckF3az18cTbsrVpzDD27YQMrsevYpVkeQabe1oFXeQKNIcEAGbV5vHy+Xf2fAwfVCq/bk3bPPyoV0KEf2qPhIXI8z5lPhJE2EoCFZjWqjBf9D6xUJSxy/Cek47OMjcXGMAeGu0bVpNem4OaZEBcHTIS8dzL7tc5XTDRD4hJ9t93dV8CrO6ljga3TKKGq0aJP5Yx6OQ4qYZG7iMHjIolTLC2FHMvwqnSWdBaP51HWuzSOryw3i8dYVLu2myz/bYeLWKTPmfRPiEg7UwSGXh+62HWHPvFMT 2025-08-07 15:20:08 [INFO]: item found in queue is if condition 14409 2025-08-07 15:20:08 [INFO]: item found in queue is 14409 2025-08-07 15:20:09 [INFO]: Message deleted from the queue for receipt handle: AQEBWCvNm8unLDgugcg0Ykv6JmIgbDrzfs8JI+PPK9/C5N9Fxheec8tqmgEKuZN5LYsjzTBxYuAvTfI58hFYd0IoOKQiABuXq1oE0RWg18AZeUfDwoZdTWygJB6gaKJG/lW64N1HKKFjmIz0veUZYkTtnRLJoZPmNSpWrVW7w51fKaE/N88C0WTe6Ushfoy2kT/tEoIf5kVX8JxmLpv1CHubBPMVKEEwygkUF68scpLmO4ygMc1gX+A/KaDODpO3xWmU6scWccdGHFycflGklYO8hFMWbbRWgOpgfANTaM/QIwsusD6Z9wWp67Ox3v5aWWT9nrm5SSMqvmUz40225EndYu0hoxm1VylE/yxINJZVvCWHSyXmD4+qY0+wXJ35cTGKQ1w9ZrRDZolTDUmQyoRMfbpCF1EWncLZwZ66PPEp0ImGaWxk4hBP3e4Uxbp/K08n 2025-08-07 15:20:10 [INFO]: item found in queue is if condition 14409 2025-08-07 15:20:10 [INFO]: item found in queue is 14409 2025-08-07 15:20:10 [INFO]: Message deleted from the queue for receipt handle: AQEBLV+cLlHt6WD1j6PsrcQvJ8/nIx3cMbc0pusnaSS+sABHkbz6oSzk8HYDc8YLfSIZg95A6pl5CDY783t8X23dx+Ub2p1sOPSBzsft0V3tMJVrvtSX3kUNNxPR/U/t48/X6eREPKUIcb6S6LbzRVqx+4mhnLlOs36ARNvBJFsHSw5EYZ+mU/OdPadiFSL3Pogq0aFwT1y7sruOsvZ1NxerqGc754Jv9jWtg/u6euuah2JmfYjgcD8oBmF/lvK05dtPzbLw87L4sgbgv9Rp2Ma7N7Mqk/2ejU2wy4fUgPFWX2724+Z4Ekz/67N352kXvGHTfgSBL1LHs4h/okoabpohsqqpH8V/dompZDkhOjYmo1viXGBB3RfZi88c4+x+3R19rN0M3+5gDMhbBB0HqU9ig8i13B42Hbu+Cbw7rN0hAFl0I9/B/nxgfL58SrOtOxg6 2025-08-07 15:20:10 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-07 15:20:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 15:20:10 [INFO]: inside itemsold and closed 14409 2025-08-07 15:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:20:12 [INFO]: Ebay item id :: 305764072652 exists in Database 2025-08-07 15:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:20:12 [INFO]: inside itemsold and closed 14409 2025-08-07 15:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:20:14 [INFO]: Ebay item id :: 254269832491 exists in Database 2025-08-07 15:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:20:14 [INFO]: inside itemsold and closed 14409 2025-08-07 15:20:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:20:15 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:20:15 [INFO]: Ebay item id :: 306343600691 exists in Database 2025-08-07 15:20:15 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:20:15 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 15:20:15 [INFO]: inside itemsold and closed 14409 2025-08-07 15:20:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:20:17 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:20:17 [INFO]: Ebay item id :: 335707552878 exists in Database 2025-08-07 15:20:17 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:20:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:20:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:20:17 [INFO]: inside itemsold and closed 14409 2025-08-07 15:20:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:20:19 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:20:19 [INFO]: Ebay item id :: 286195225926 exists in Database 2025-08-07 15:20:19 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:20:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:20:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:20:19 [INFO]: inside itemsold and closed 14409 2025-08-07 15:20:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:20:20 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:20:20 [INFO]: Ebay item id :: 256967617055 exists in Database 2025-08-07 15:20:20 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:20:20 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 15:20:20 [INFO]: in processold action queue is array for {"44555906":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555906","ebayitemid":"305764072652","shopifyproductid":"7868482257118","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"7868482257118","shopifyvariantid":"43636569669854","shopifyinventoryid":"45732324868318","shopifylocationid":"","product_id":"44555906","variant_id":"77448586","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44660933":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44660933","ebayitemid":"254269832491","shopifyproductid":"6640418914471","variants":[{"price":"9.95","quantity":0,"weight":"0","shopifyproductid":"6640418914471","shopifyvariantid":"39674007683239","shopifyinventoryid":"41768713781415","shopifylocationid":"","product_id":"44660933","variant_id":"77566153","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45113537":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113537","ebayitemid":"306343600691","deleted":1}},"44554481":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554481","ebayitemid":"335707552878","shopifyproductid":"8120351850718","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8120351850718","shopifyvariantid":"44329970237662","shopifyinventoryid":"46427612709086","shopifylocationid":"","product_id":"44554481","variant_id":"77447161","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554475":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554475","ebayitemid":"286195225926","shopifyproductid":"8112437362910","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8112437362910","shopifyvariantid":"44315854667998","shopifyinventoryid":"46413405913310","shopifylocationid":"","product_id":"44554475","variant_id":"77447155","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45109877":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45109877","ebayitemid":"256967617055","deleted":1}}} 2025-08-07 15:20:20 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 15:20:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:20:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:20:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:20:20 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:20:20 [INFO]: productIds WHich are having null productid -> [45113537,45109877] 2025-08-07 15:20:20 [INFO]: ebayItemIds WHich are not imported-> ["306343600691","256967617055"] 2025-08-07 15:20:20 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 15:20:20 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 15:20:20 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113537,45109877) 2025-08-07 15:20:20 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 15:20:20 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 15:20:20 [INFO]: Transaction committed successfully. 2025-08-07 15:20:20 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 15:20:20 [INFO]: Shopify Inventory id 45732324868318 2025-08-07 15:20:20 [INFO]: Shopify Location id 58450641063 2025-08-07 15:20:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:20:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:20:21Z","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-07 15:20:21 [INFO]: Change: available | Delta: -1 2025-08-07 15:20:21 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:20:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:20:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555906 and user_id = 14409 2025-08-07 15:20:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448586 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:20:21 [INFO]: Shopify Inventory id 41768713781415 2025-08-07 15:20:21 [INFO]: Shopify Location id 58450641063 2025-08-07 15:20:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:20:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:20:21Z","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-07 15:20:21 [INFO]: Change: available | Delta: -1 2025-08-07 15:20:21 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:20:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:20:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44660933 and user_id = 14409 2025-08-07 15:20:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566153 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:20:21 [INFO]: Shopify Inventory id 46427612709086 2025-08-07 15:20:21 [INFO]: Shopify Location id 58450641063 2025-08-07 15:20:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:20:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:20:21Z","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-07 15:20:21 [INFO]: Change: available | Delta: -1 2025-08-07 15:20:21 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:20:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:20:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554481 and user_id = 14409 2025-08-07 15:20:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447161 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:20:21 [INFO]: Shopify Inventory id 46413405913310 2025-08-07 15:20:21 [INFO]: Shopify Location id 58450641063 2025-08-07 15:20:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:20:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:20:22Z","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-07 15:20:22 [INFO]: Change: available | Delta: -1 2025-08-07 15:20:22 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:20:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:20:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554475 and user_id = 14409 2025-08-07 15:20:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447155 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:20:22 [INFO]: updateIdsQuantity -> ["77448586","77566153","77447161","77447155"] 2025-08-07 15:20:22 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-07 15:20:22 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77448586 THEN 0 WHEN id = 77566153 THEN 0 WHEN id = 77447161 THEN 0 WHEN id = 77447155 THEN 0 END, quantityflag = CASE WHEN id = 77448586 THEN 0 WHEN id = 77566153 THEN 0 WHEN id = 77447161 THEN 0 WHEN id = 77447155 THEN 0 END WHERE user_id = 14409 AND id IN (77448586,77566153,77447161,77447155) 2025-08-07 15:20:22 [INFO]: QUANTITY Updated IDs: 77448586, 77566153, 77447161, 77447155 2025-08-07 15:20:22 [INFO]: Successfully processed data for user 14409 2025-08-07 15:20:22 [INFO]: Execution Started 2025-08-07 15:20:22 [INFO]: Execution Finished 2025-08-07 15:30:01 [INFO]: Execution Started 2025-08-07 15:30:01 [INFO]: old server sucessfully connected 2025-08-07 15:30:01 [INFO]: sqs client sucess created 2025-08-07 15:30:04 [INFO]: Number of messages in the queue: 2 2025-08-07 15:30:06 [INFO]: item found in queue is if condition 14409 2025-08-07 15:30:06 [INFO]: item found in queue is 14409 2025-08-07 15:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBtBan0MBWWfYVrNTa8l9dNRJe9G65bs82muMQqOrRJsIZ9tWF8naMECKolg5zpQQvG+ybChPAxpb7OV4MFGqVyXfz/WuhKbCysJq9CxMcrj0RV+ZGQCh1iTBqXvkqh5ZSQdPzRLwVPDlnkQcGWGXNskKIB43nC4zbTiQ+MnHtdvgW+GZV7WeuA+SjCqX+T2Ji2dZLSnh5fxkAKzzarq9FSGIlwtufT2cjR4uVsUPJJEDZmQHx4gQUsL8MqzBiDNBmXtdg6+wyIhzIMSS5X94PYxutWr81xwBmR0IbWUQogHw2d/DcD5T4yX84U8hZcmAG7OY3nfHo86y+58bttBHIGSa9aldwW/xypy5e6oTo3vqy3VaVUOU4RLhb7gxYDEERDUap6sK6OQ98t24nfZK2r8sftJr1o0n1+bIC3akm9CEkP07+SSgOx5c64nVlehbr 2025-08-07 15:30:07 [INFO]: item found in queue is if condition 14409 2025-08-07 15:30:07 [INFO]: item found in queue is 14409 2025-08-07 15:30:10 [INFO]: Message deleted from the queue for receipt handle: AQEBoBDfigyaJPICr7XJQGClBh0SCBmcCDVXNLn2QbYgbmwePNnNmu7M87YgDpHgm54rcGvxZMVVttGi6tgjtB6PSlk7uCtdWl76ko+8jRQW2fICAF95IqK69VT+G0NS7DJbqKtPFWQ3++dK5oKimpvRa/gp6pk/4tuFyAmKZsqW0w8GBsGk1OE0TOkRy2qnG98XWN2Ch5jBThZw41EijfUAdHdGzSsOPvd+9HRWdULYO2cca5QvUrtIJFbra1ddKC+lvYrj3Ma7taxEZLzLPC+Dktq2b9a0j4hZ39BiN3E6bLeghlvrsssIUFUzlWTT6G2n7AthdNQ7K+3MQaVZSOVqOAGxohUNrIvaveCbsOD6b72eEfYfjd8yGP08L1xNg92YT93wO8NsV8zPIQCUtbYD6/LZX5UreNoZ5Qj/SXdNz7nAE62v30IszGQtuteOzWIT 2025-08-07 15:30:10 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 15:30:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 15:30:10 [INFO]: inside itemsold and closed 14409 2025-08-07 15:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:30:12 [INFO]: Ebay item id :: 335707557004 exists in Database 2025-08-07 15:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:30:12 [INFO]: inside itemsold and closed 14409 2025-08-07 15:30:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:30:14 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:30:14 [INFO]: Ebay item id :: 305948396488 exists in Database 2025-08-07 15:30:14 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:30:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:30:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:30:14 [INFO]: in processold action queue is array for {"44554486":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554486","ebayitemid":"335707557004","shopifyproductid":"7868332835038","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"7868332835038","shopifyvariantid":"43636011204830","shopifyinventoryid":"45731763486942","shopifylocationid":"","product_id":"44554486","variant_id":"77447166","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554491":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554491","ebayitemid":"305948396488","shopifyproductid":"7780722901214","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"7780722901214","shopifyvariantid":"43352425529566","shopifyinventoryid":"45447700775134","shopifylocationid":"","product_id":"44554491","variant_id":"77447171","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 15:30:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 15:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:30:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:30:14 [INFO]: Shopify Inventory id 45731763486942 2025-08-07 15:30:14 [INFO]: Shopify Location id 58450641063 2025-08-07 15:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:30:14Z","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-07 15:30:14 [INFO]: Change: available | Delta: -1 2025-08-07 15:30:14 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554486 and user_id = 14409 2025-08-07 15:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447166 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:30:14 [INFO]: Shopify Inventory id 45447700775134 2025-08-07 15:30:14 [INFO]: Shopify Location id 58450641063 2025-08-07 15:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:30:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:30:14Z","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-07 15:30:15 [INFO]: Change: available | Delta: -1 2025-08-07 15:30:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:30:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:30:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554491 and user_id = 14409 2025-08-07 15:30:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447171 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:30:15 [INFO]: updateIdsQuantity -> ["77447166","77447171"] 2025-08-07 15:30:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 15:30:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77447166 THEN 0 WHEN id = 77447171 THEN 0 END, quantityflag = CASE WHEN id = 77447166 THEN 0 WHEN id = 77447171 THEN 0 END WHERE user_id = 14409 AND id IN (77447166,77447171) 2025-08-07 15:30:15 [INFO]: QUANTITY Updated IDs: 77447166, 77447171 2025-08-07 15:30:15 [INFO]: Successfully processed data for user 14409 2025-08-07 15:30:15 [INFO]: Execution Started 2025-08-07 15:30:15 [INFO]: Execution Finished 2025-08-07 15:40:02 [INFO]: Execution Started 2025-08-07 15:40:02 [INFO]: old server sucessfully connected 2025-08-07 15:40:02 [INFO]: sqs client sucess created 2025-08-07 15:40:05 [INFO]: Number of messages in the queue: 3 2025-08-07 15:40:06 [INFO]: item found in queue is if condition 14409 2025-08-07 15:40:06 [INFO]: item found in queue is 14409 2025-08-07 15:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBlVLkefyANwcKSFeZJCjvsM68SA3oo89srevXMup+UUcFOufnuy2VnahLCg3uc5TLDLF49rRc074n3szpoChinEUChNE6flDO9rjE4HMvyV5ehd3YpMk2iE+9Sw9svCvJuFv033J6quIvCAA66kWDyQFz3sWYdDP8yJJIRMmih0S7TMy7+qpFrRsdAU3ygs+hLTLuZnU9bqtY33ffcYfQ1ZWfZT+AGQpRnLQKgzN4/f/x74TY9rTvGKRk9paGn1uJEfruQmNeRzd0O+NqUh4U1HeqyYYSbgqzuTiOi0azK+hAJhL0DZmLNrpHuP4yWtVCHz7pjFJuXO/BvSEPITwc+kvooPheBtFtBOqPUL7qPcC9VXgr9OPk9PZFQV02t8T+mlxxhVSRPx76J+igyG1us7zpMhpdH2TXZzQUrAnv/0rrp9wMEZH4rXqaiNQtQhuz 2025-08-07 15:40:07 [INFO]: item found in queue is if condition 14409 2025-08-07 15:40:07 [INFO]: item found in queue is 14409 2025-08-07 15:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBxvFksp10D4Vdq28g7JTgFjchrRajPFqtDXK8SMhG73+Twd00Zyk34SJFaDL7JPYI9BlWKxLXm2qhdx8jG17PW3sEsHArGPzVH82bXHJRhK7g3zB4LPPwYfGNeY4to3x3nk9bsj4+6G9tcm9dbvHcdhYwgqNrh2aNeRjaicvDBH7i4sgQVthqcpZoPXE8oI2o8a+o/h/P71wx36d+25AFnC9rz05YLiji9d6xJb3mb7qxeHbZox6SW6Wp+nr5i5eLHDd9fgCam3sujdhAqYzkj+u+SHK72Wxr7VE1J/KVxFPeFX5SwqQE/7RNwhp713hjLcvKNii3PwskHJL1Tv9Ue9ZO0QiIzh11oYSdDmD5Oy7w+C0vc6Z836Yo2pkgaWRbe+7RenOKqroruQQl+vDvh4C5SEiMB6OqMJjp8NmB/bcdyq9o9pQQHCSgYczjxmkX 2025-08-07 15:40:08 [INFO]: item found in queue is if condition 14409 2025-08-07 15:40:08 [INFO]: item found in queue is 14409 2025-08-07 15:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEB7LbrlR0/yzk1QOhXlNhlAzEeFx16pZviPBTlemvInF73891yQi2yA6gi5yQyBb9mBjkaY9L7DsQCYBlUtnzhvxW3Yf31b2FSO4jgvOB9YyDBTKK4b34H1MtgDhLSGE/oYSjrYhCmfoHbstpEKtm2FSY11IXD6DhLpis3JZpZtx5VMTh65DgEvl8vyqEVpbuDwNejqrpIp2X60v57tHNNBS+zPzO+T9lbTF7mGUhpNnVd2XxGeubKdUIFdNQ8JB7dbdledKzbJGEi9usEziNBvpuXa/8IOuQuqos/EGpbIlHbQlxuNhRwLccIn3JbnytdvfLdEfdJUkUMjNtrx9OKBRmP3B6LhqavZSqIlSv4wDla4GCH1RWD11C0DTQxMtSbbwQfJUijQucyMM21zh4/vW8y7ZjFO7p3in2wTyBA4f0bPZzLDbgGlEEgwKButJ+F 2025-08-07 15:40:09 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 15:40:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 15:40:09 [INFO]: inside itemsold and closed 14409 2025-08-07 15:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:40:11 [INFO]: Ebay item id :: 305948401683 exists in Database 2025-08-07 15:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:40:11 [INFO]: inside itemsold and closed 14409 2025-08-07 15:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:40:12 [INFO]: Ebay item id :: 305948375837 exists in Database 2025-08-07 15:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:40:12 [INFO]: inside itemsold and closed 14409 2025-08-07 15:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:40:14 [INFO]: Ebay item id :: 286195257847 exists in Database 2025-08-07 15:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:40:14 [INFO]: in processold action queue is array for {"44554496":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554496","ebayitemid":"305948401683","shopifyproductid":"8197102305502","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8197102305502","shopifyvariantid":"44503079256286","shopifyinventoryid":"46601014378718","shopifylocationid":"","product_id":"44554496","variant_id":"77447176","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554470":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554470","ebayitemid":"305948375837","shopifyproductid":"7941023498462","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"7941023498462","shopifyvariantid":"43938956345566","shopifyinventoryid":"46035389776094","shopifylocationid":"","product_id":"44554470","variant_id":"77447150","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554502":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554502","ebayitemid":"286195257847","shopifyproductid":"8228244685022","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8228244685022","shopifyvariantid":"44585787556062","shopifyinventoryid":"46683753021662","shopifylocationid":"","product_id":"44554502","variant_id":"77447182","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 15:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 15:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:40:14 [INFO]: Shopify Inventory id 46601014378718 2025-08-07 15:40:14 [INFO]: Shopify Location id 58450641063 2025-08-07 15:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:40:14Z","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-07 15:40:14 [INFO]: Change: available | Delta: -1 2025-08-07 15:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554496 and user_id = 14409 2025-08-07 15:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447176 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:40:14 [INFO]: Shopify Inventory id 46035389776094 2025-08-07 15:40:14 [INFO]: Shopify Location id 58450641063 2025-08-07 15:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:40:15Z","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-07 15:40:15 [INFO]: Change: available | Delta: -1 2025-08-07 15:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554470 and user_id = 14409 2025-08-07 15:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447150 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:40:15 [INFO]: Shopify Inventory id 46683753021662 2025-08-07 15:40:15 [INFO]: Shopify Location id 58450641063 2025-08-07 15:40:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15:40:15Z","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-07 15:40:15 [INFO]: Change: available | Delta: -1 2025-08-07 15:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554502 and user_id = 14409 2025-08-07 15:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447182 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:40:15 [INFO]: updateIdsQuantity -> ["77447176","77447150","77447182"] 2025-08-07 15:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 15:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77447176 THEN 0 WHEN id = 77447150 THEN 0 WHEN id = 77447182 THEN 0 END, quantityflag = CASE WHEN id = 77447176 THEN 0 WHEN id = 77447150 THEN 0 WHEN id = 77447182 THEN 0 END WHERE user_id = 14409 AND id IN (77447176,77447150,77447182) 2025-08-07 15:40:15 [INFO]: QUANTITY Updated IDs: 77447176, 77447150, 77447182 2025-08-07 15:40:15 [INFO]: Successfully processed data for user 14409 2025-08-07 15:40:15 [INFO]: Execution Started 2025-08-07 15:40:15 [INFO]: Execution Finished 2025-08-07 15:50:01 [INFO]: Execution Started 2025-08-07 15:50:01 [INFO]: old server sucessfully connected 2025-08-07 15:50:01 [INFO]: sqs client sucess created 2025-08-07 15:50:05 [INFO]: Number of messages in the queue: 1 2025-08-07 15:50:07 [INFO]: item found in queue is if condition 14409 2025-08-07 15:50:07 [INFO]: item found in queue is 14409 2025-08-07 15:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBYC1wPUp5IC/pXDyM2WHp2+flO4t64LlnUulgco/tWzh/BRf/pigs+bBZ6sHcXQKjbks/1IG5fPtI6ZUdjK1PHC0S8gvVcWJqtIZIh/WoeBI42Kmp/1XiDP0fdzlQlzKH3GZyn7CNAPEmpKw4Gyan0OOMelJg3nJ/hadF1Ry8DEBMH5ewby7/9dAO9NvWvCdhDMBxaUSwkvfrUDnTO9aIay6fJ2lFfaz2mhHN/J7iz7mabcduq8t2sQHsDXs2tldIedD5kmd3zoSK0AAPD5V47qnM8C9u9qi/ol8fz9vA4mfYNVk+ipDGey5XX0rUdBLfM9oKDq5sLtmyJt62qj4N1X6EQaDQtqHCR9cs+SJK84CKTmjwgS9cJMd7PahbhnQ8Rrm7RDZR2gNXLsrfnHl0PvMcTaz19Zw4YjAfEVM3rBsgorVZE3Oaz6VxS3YZB3Rk 2025-08-07 15:50:07 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 15:50:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 15:50:07 [INFO]: inside itemsold and closed 14409 2025-08-07 15:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 15:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-07 15:50:09 [INFO]: Ebay item id :: 304780183664 exists in Database 2025-08-07 15:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-07 15:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 15:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 15:50:09 [INFO]: in processold action queue is array for {"44588340":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588340","ebayitemid":"304780183664","shopifyproductid":"8017607524574","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"8017607524574","shopifyvariantid":"44146476777694","shopifyinventoryid":"46243396944094","shopifylocationid":"","product_id":"44588340","variant_id":"77481049","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 15:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 15:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 15:50:09 [INFO]: Shopify Inventory id 46243396944094 2025-08-07 15:50:09 [INFO]: Shopify Location id 58450641063 2025-08-07 15:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 15:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T15: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-08-07 15:50:09 [INFO]: Change: available | Delta: -1 2025-08-07 15:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-07 15:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 15:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588340 and user_id = 14409 2025-08-07 15:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481049 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 15:50:09 [INFO]: updateIdsQuantity -> ["77481049"] 2025-08-07 15:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 15:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77481049 THEN 0 END, quantityflag = CASE WHEN id = 77481049 THEN 0 END WHERE user_id = 14409 AND id IN (77481049) 2025-08-07 15:50:09 [INFO]: QUANTITY Updated IDs: 77481049 2025-08-07 15:50:09 [INFO]: Successfully processed data for user 14409 2025-08-07 15:50:09 [INFO]: Execution Started 2025-08-07 15:50:09 [INFO]: Execution Finished