2025-08-13 21:00:02 [INFO]: Execution Started 2025-08-13 21:00:02 [INFO]: old server sucessfully connected 2025-08-13 21:00:02 [INFO]: sqs client sucess created 2025-08-13 21:00:03 [INFO]: Number of messages in the queue: 3 2025-08-13 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-13 21:00:03 [INFO]: item found in queue is 14409 2025-08-13 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBysFvXUgUFCfn/B+kvuvMXeoKS1lMDxIdVfqt9/lzLrq6sFak3VymSoVJo90AR/AONSSFi1/BDMXWzedF5aD+fUz813nVDbkpc4holSdYDCrAFwcV/s/mZjBUiVcL4g4iwd6wwTJ5XHme8jZePUmtBDNy1wArRWJSlbUkO1AGKN9sz29809WZFkkfUuqM+hKAajiKx6NwxcNLkxf/U4oYFiwmCqPOvbsiTeQfSmJ1voL+b+hbJNZLsBcI+Uf6ZVHenJUjgWhu9Hmb8JvekOmasQlzwKkgqVBHLcCU8L8tpkUraWjZUAoTpFAOMwMh/Q5kcKdnKH2tekc9BhdnmDNRxq/34/ikFNRHpreso9mkUiSe/s/5xPp5ngPptUgM7FNhR17eHGOMXe0NEDbNS9yNdL9194F50Bp4nY5gzYj19Q/V63JlM92CnnEHjx2JnV8E 2025-08-13 21:00:04 [INFO]: item found in queue is if condition 14409 2025-08-13 21:00:04 [INFO]: item found in queue is 14409 2025-08-13 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBEqfJMdJPvvBLdwuj8Jd+FH9F8/hyWTXUK1/8izZ8AR5cQE7fmhLvnh/+8cixBMxsqJCmC/e6tkbCGW0VzFomn4rWM3C3EMER9ScQOsarTb8hLU3wZ8reYGjQy4M9kTwkZ6X2KfK+0ZzRR0/LXG6CTMj5vpxwXYeHMqrqOcAR6mp9DszR8yynVbbCyhm6Bh8/TQ2tlbfHaTXo8EQUygmK72sOI0Ja5AugoKo/DrhNFeZkoQW6HA1vwswgZvNFtLAQEOuKatdyg03VjtCdUJHgxnZ/LFYfqYzfAcC3bRVBaLoaNeh3DCCs2bz3RDnr/fv1yDnAGf+fdnVDAFJE2nNBGjF8Nsi2oPwsgnzsQWvQqMuaz6oP973ewSYUwU/OQwJ0OZGsy1/vb2mXPOgrNABd3vlnAYp4I3crukD8hlv7xh88nIexbbv82g3zzk5/BJMr 2025-08-13 21:00:04 [INFO]: item found in queue is if condition 14409 2025-08-13 21:00:04 [INFO]: item found in queue is 14409 2025-08-13 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBVXKU19ZzewWx0iYYUXZwYRvQdV/6v3PKBim0BPz47WSXG0oX7du6fbCg8Mi957B2KIyv/zZFXjeUTZMiRQ/XmOxEFteGeGrmOkUTv5vOCF5k1xcAhCqVge3ATd8rF5pwGb/03qZcf6AcAVGbgrYF/iKXyBffsZ/XRmC8ErWRgoaJvk7fbcdoaLzquoGE1P9o2lHlfISolarq02XihBnK7UYIbKtBPDJFEVxEg71HIEJMsqrM7FJEJrmYZiNDHBl2qtMdzmtKK7UKjCrh5P2x+dL9EcZd/jzHFSbyGCWkpsH94NgGcJZoerkKd/j8Wrdx0X594l81Sk+a9w+Uj45q1AOJFrylhTtdys0Yj9CgSYT4erTonPUl35NKnJ8knfmAv4fD8oz3nnm3swQSQrTFm7fy1qUbBmI7a1fOOV2GhLMuP93CTLyUK6BfjZsfafFE 2025-08-13 21:00:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-13 21:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 21:00:04 [INFO]: inside itemsold and closed 14409 2025-08-13 21:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:00:06 [INFO]: Ebay item id :: 286043355900 exists in Database 2025-08-13 21:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 21:00:06 [INFO]: inside itemsold and closed 14409 2025-08-13 21:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:00:08 [INFO]: Ebay item id :: 286043340783 exists in Database 2025-08-13 21:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 21:00:08 [INFO]: inside itemsold and closed 14409 2025-08-13 21:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:00:10 [INFO]: Ebay item id :: 305763783744 exists in Database 2025-08-13 21:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 21:00:10 [INFO]: in processold action queue is array for {"44555454":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555454","ebayitemid":"286043355900","shopifyproductid":"7901781491934","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7901781491934","shopifyvariantid":"43744703742174","shopifyinventoryid":"45840708632798","shopifylocationid":"","product_id":"44555454","variant_id":"77448134","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44555431":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555431","ebayitemid":"286043340783","shopifyproductid":"7631455846622","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7631455846622","shopifyvariantid":"42725126930654","shopifyinventoryid":"44819601326302","shopifylocationid":"","product_id":"44555431","variant_id":"77448111","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44555421":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555421","ebayitemid":"305763783744","shopifyproductid":"7577082855646","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7577082855646","shopifyvariantid":"42530859417822","shopifyinventoryid":"44624854352094","shopifylocationid":"","product_id":"44555421","variant_id":"77448101","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 21:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 21:00:10 [INFO]: Shopify Inventory id 45840708632798 2025-08-13 21:00:10 [INFO]: Shopify Location id 58450641063 2025-08-13 21:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 21:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T21:00:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 21:00:10 [INFO]: Change: available | Delta: -1 2025-08-13 21:00:10 [INFO]: Change: on_hand | Delta: -1 2025-08-13 21:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 21:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555454 and user_id = 14409 2025-08-13 21:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448134 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 21:00:10 [INFO]: Shopify Inventory id 44819601326302 2025-08-13 21:00:10 [INFO]: Shopify Location id 58450641063 2025-08-13 21:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T21:00:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 21:00:11 [INFO]: Change: available | Delta: -1 2025-08-13 21:00:11 [INFO]: Change: on_hand | Delta: -1 2025-08-13 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555431 and user_id = 14409 2025-08-13 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448111 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 21:00:11 [INFO]: Shopify Inventory id 44624854352094 2025-08-13 21:00:11 [INFO]: Shopify Location id 58450641063 2025-08-13 21:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T21:00:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 21:00:11 [INFO]: Change: available | Delta: -1 2025-08-13 21:00:11 [INFO]: Change: on_hand | Delta: -1 2025-08-13 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555421 and user_id = 14409 2025-08-13 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448101 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 21:00:11 [INFO]: updateIdsQuantity -> ["77448134","77448111","77448101"] 2025-08-13 21:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-13 21:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77448134 THEN 0 WHEN id = 77448111 THEN 0 WHEN id = 77448101 THEN 0 END, quantityflag = CASE WHEN id = 77448134 THEN 0 WHEN id = 77448111 THEN 0 WHEN id = 77448101 THEN 0 END WHERE user_id = 14409 AND id IN (77448134,77448111,77448101) 2025-08-13 21:00:11 [INFO]: QUANTITY Updated IDs: 77448134, 77448111, 77448101 2025-08-13 21:00:11 [INFO]: Successfully processed data for user 14409 2025-08-13 21:00:11 [INFO]: Execution Started 2025-08-13 21:00:11 [INFO]: Execution Finished 2025-08-13 21:10:01 [INFO]: Execution Started 2025-08-13 21:10:01 [INFO]: old server sucessfully connected 2025-08-13 21:10:01 [INFO]: sqs client sucess created 2025-08-13 21:10:02 [INFO]: Number of messages in the queue: 2 2025-08-13 21:10:03 [INFO]: item found in queue is if condition 14409 2025-08-13 21:10:03 [INFO]: item found in queue is 14409 2025-08-13 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBS5QCdaBcR778LV4MLDCrQeRrBpx0eo5DDTu3rnDKb8B8yKBOb6eCAeW43WECw+/303ZylN+tiL5QcaylgPK7hpH8u+fCa+OoAHkbk1fKVE6ZQc9c54V3c0+oks18ih6vIunqk/KGKyItJoa7en7SD8mufhPUoZYadwV3tmaeSWIf4u7xKkj2usONkyOIpL3jtv/+HncjKZ2TfjXDqpNg/Vc5U215rRB3iLFjwtJk2Mk41Hck4LHZPQIZGpr3vplBwatYD5BvgkqfwHCsOvCEs5RSw7ySDrb1jvUV5hM4FErMGFFccx7CjC+lmhE3cBBSZoNstQ9mTv9HDcVd9tjc0BXRnfBORNVVYI3bQ57pBcrnQ5UwqWDv5n/eV2SSd2E2qI6UvSBXNsM8cQKTk6ibJtEn/x4w9llHOSbWzKT3FNob1pP+jkdMfw/616swhxz1 2025-08-13 21:10:03 [INFO]: item found in queue is if condition 14409 2025-08-13 21:10:03 [INFO]: item found in queue is 14409 2025-08-13 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBuE+DY77C72Ai5c0mRAar26xJcNUM7/MexnOXp3xgjxXotz0GmKFTyqH13rG5aFAgrsOQVVkC5e7or/TIbjKr4AsxMVwihRTWEgXCpvCbnly1jwSAYPIE3VY4eFcvEOlG+pwQO7r7d0jZLWlQPKO/Gk5GXKgfIMLPWG5srqU64BchPRAZedgi9oeEKkRGLHopg5u+vE/TwAYSSu+KCu4eAZrLU9HTrMJ8qKW4bCDnyxm0/EBFAWzqcqXF8cKiP/r9K79ykN759D6i7/Dcp8oM9+adiobgrXA5jx2h2xeBoSevm02AMR8vFs02SNQ6XWwQYbUb8EK7QKKZ4FKkGUKZjHrC5o1frByKFsRHGExZAGOU1JW8+dj7zrVuHNwpg6zcsHIXzt/icdIJ85RDG02+sI4F54lGdAHmYvuQrsmA6xyzfYTZX/viGBnh7D60dmQK 2025-08-13 21:10:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 21:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 21:10:03 [INFO]: inside itemsold and closed 14409 2025-08-13 21:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:10:05 [INFO]: Ebay item id :: 285789202921 exists in Database 2025-08-13 21:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 21:10:05 [INFO]: inside itemsold and closed 14409 2025-08-13 21:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:10:07 [INFO]: Ebay item id :: 305486383398 exists in Database 2025-08-13 21:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:10:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 21:10:07 [INFO]: in processold action queue is array for {"44596004":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596004","ebayitemid":"285789202921","shopifyproductid":"8347205861598","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8347205861598","shopifyvariantid":"45002072522974","shopifyinventoryid":"47099866611934","shopifylocationid":"","product_id":"44596004","variant_id":"77488713","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45145728":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45145728","ebayitemid":"305486383398","deleted":1}}} 2025-08-13 21:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 21:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 21:10:07 [INFO]: productIds WHich are having null productid -> [45145728] 2025-08-13 21:10:07 [INFO]: ebayItemIds WHich are not imported-> ["305486383398"] 2025-08-13 21:10:07 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 21:10:07 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 21:10:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45145728) 2025-08-13 21:10:07 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 21:10:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 21:10:07 [INFO]: Transaction committed successfully. 2025-08-13 21:10:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 21:10:07 [INFO]: Shopify Inventory id 47099866611934 2025-08-13 21:10:07 [INFO]: Shopify Location id 58450641063 2025-08-13 21:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 21:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T21:10:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 21:10:07 [INFO]: Change: available | Delta: -1 2025-08-13 21:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-13 21:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 21:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596004 and user_id = 14409 2025-08-13 21:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488713 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 21:10:07 [INFO]: updateIdsQuantity -> ["77488713"] 2025-08-13 21:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 21:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77488713 THEN 0 END, quantityflag = CASE WHEN id = 77488713 THEN 0 END WHERE user_id = 14409 AND id IN (77488713) 2025-08-13 21:10:07 [INFO]: QUANTITY Updated IDs: 77488713 2025-08-13 21:10:07 [INFO]: Successfully processed data for user 14409 2025-08-13 21:10:07 [INFO]: Execution Started 2025-08-13 21:10:07 [INFO]: Execution Finished 2025-08-13 21:20:01 [INFO]: Execution Started 2025-08-13 21:20:01 [INFO]: old server sucessfully connected 2025-08-13 21:20:01 [INFO]: sqs client sucess created 2025-08-13 21:20:02 [INFO]: Number of messages in the queue: 2 2025-08-13 21:20:03 [INFO]: item found in queue is if condition 14409 2025-08-13 21:20:03 [INFO]: item found in queue is 14409 2025-08-13 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBVqZo/af7vyJ6WV5U9EEtmz3RUFYHPZztPJMyM0c5ighaZWJKk7VlcCT+GCHJiEDAdHNBZJD6B2MVC/5UzTjfFQO2q84lWpSsiVr4iORFZQfIF49Ze5gGX1Xm7qRgTZdNwHkBsBnjJWrlJD0EB4fzgjEVEjo0A/2FqAgOZRbQnv+N4sbBTthMgPweNDqCJJq5dIkGEuT2B/BjI7AdFkcyGo7hLlLywwhBsGBWyYSv17bjyDrHwr1R8LGU6NAAHJF7rm1sbK6sHQqJ3HDEk0kTDf+gTm5WlDoasbx7L3HonxBaMo3VVi74fnxXe9aUGydGC1dBKMEr7AaW3yvYPiVH+Rm5knYztKsfUdKv4c1rm7fpL9IQLyaxcVaRyNOvdsIAHYP0ixi8Kgo9JHMWsXiMrNIiEOJfzYwxQhZQ3pOIYzX/DNWkuombH5Rvos8mo4Qf 2025-08-13 21:20:03 [INFO]: item found in queue is if condition 14409 2025-08-13 21:20:03 [INFO]: item found in queue is 14409 2025-08-13 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNeQ7n+TtyGEmvgk6HsRXK914PHiFYMhLSsbmVOSBIjTse6p0mwfWZ7vK7Y7WGaaeFbc7IVLK94O23a9SwChE5kws6ZbJr9L8Ke86c2RyZMq6eVSdOmHNheuUr3wPbArW521E3sgA3ktFjW9PpItvN+kjtS2G+n8995tDBtJkZk7Bk9NRhvBVqX1609huCEFwjNYXH7+QPUB7UY22tCz8QcNPRcllgoIxoN+GcZi+/f/0mN/yxjOLQvF/pmczVrOIFHcpDRS0k5ebiQPtBknH5mDavIY046h2etWhWABGISmgXEvy905IcSYzUah9sDoTKkqqacJZ7tbl3t0YKr8XG1ns+318FMl0/jpnn4pw5pCAyQJbxQdBDk9woxWiK7k7Ug3Z4RvqMqw6TfC5Icc4C3bxlUZ/T9lhuw01F2/rB7jMo1PvsNE7nSKJSDc/Q2y3 2025-08-13 21:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 21:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 21:20:03 [INFO]: inside itemsold and closed 14409 2025-08-13 21:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:20:05 [INFO]: Ebay item id :: 325666148940 exists in Database 2025-08-13 21:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 21:20:05 [INFO]: inside itemsold and closed 14409 2025-08-13 21:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:20:07 [INFO]: Ebay item id :: 284459200066 exists in Database 2025-08-13 21:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:20:07 [INFO]: in processold action queue is array for {"44670899":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670899","ebayitemid":"325666148940","shopifyproductid":"8047619014878","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8047619014878","shopifyvariantid":"44200715714782","shopifyinventoryid":"46297790972126","shopifylocationid":"","product_id":"44670899","variant_id":"77576119","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 21:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 21:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 21:20:07 [INFO]: Shopify Inventory id 46297790972126 2025-08-13 21:20:07 [INFO]: Shopify Location id 58450641063 2025-08-13 21:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 21:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T21:20:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 21:20:07 [INFO]: Change: available | Delta: -1 2025-08-13 21:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-13 21:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 21:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670899 and user_id = 14409 2025-08-13 21:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576119 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 21:20:07 [INFO]: updateIdsQuantity -> ["77576119"] 2025-08-13 21:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 21:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77576119 THEN 0 END, quantityflag = CASE WHEN id = 77576119 THEN 0 END WHERE user_id = 14409 AND id IN (77576119) 2025-08-13 21:20:07 [INFO]: QUANTITY Updated IDs: 77576119 2025-08-13 21:20:07 [INFO]: Successfully processed data for user 14409 2025-08-13 21:20:07 [INFO]: Execution Started 2025-08-13 21:20:07 [INFO]: Execution Finished 2025-08-13 21:30:02 [INFO]: Execution Started 2025-08-13 21:30:02 [INFO]: old server sucessfully connected 2025-08-13 21:30:02 [INFO]: sqs client sucess created 2025-08-13 21:30:03 [INFO]: Number of messages in the queue: 0 2025-08-13 21:30:23 [INFO]: Execution Started 2025-08-13 21:30:23 [INFO]: Execution Finished 2025-08-13 21:40:01 [INFO]: Execution Started 2025-08-13 21:40:01 [INFO]: old server sucessfully connected 2025-08-13 21:40:01 [INFO]: sqs client sucess created 2025-08-13 21:40:02 [INFO]: Number of messages in the queue: 0 2025-08-13 21:40:22 [INFO]: Execution Started 2025-08-13 21:40:22 [INFO]: Execution Finished 2025-08-13 21:50:01 [INFO]: Execution Started 2025-08-13 21:50:01 [INFO]: old server sucessfully connected 2025-08-13 21:50:01 [INFO]: sqs client sucess created 2025-08-13 21:50:02 [INFO]: Number of messages in the queue: 0 2025-08-13 21:50:21 [INFO]: item found in queue is if condition 14409 2025-08-13 21:50:21 [INFO]: item found in queue is 14409 2025-08-13 21:50:21 [INFO]: Message deleted from the queue for receipt handle: AQEBb20VbOkruYBi6PFmjbpd0CvhE2tlZndkOFayFAot28l9zFg97f/AjwleV7EIA2kK82QEv81K5YK0DpOhJw6T3CkafiwksOXD5g8hx1bQOuX2GypHhADh0zAWb/OE6dQvVX+wyiNofpjndvF2pLtVMbLyzynpGFqKxFXCw947AMAsl4G2fn3Lv3eWuMlj6xC1kgE8ugWy8nEOACNlCPTYbEMCgGm7/xhUznTUmWHoaTQCZVYu+qwpSE8UCr6BltkGus1wZO1IoR9EQFARRvZZpTZ9H+lVS2iw6F0xm3w00HNfpqcYhjUeUELqIHlvqQ/4HaB7z6RxFxkcOn11kKVzFES36MY3hdNekShVdw3ILL5ArYumSBJJcZw62wKh5w5pczwHKJU+ZzOL6LNxo7FGlbMRL/nPti479mEYOv5xNQ9H18yQFQXDFxfPO9F0bq2G 2025-08-13 21:50:21 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-13 21:50:21 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 21:50:21 [INFO]: inside itemsold and closed 14409 2025-08-13 21:50:23 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 21:50:23 [INFO]: autolink for user_id 14409 is 1 2025-08-13 21:50:23 [INFO]: Ebay item id :: 286291656222 exists in Database 2025-08-13 21:50:23 [INFO]: Item is reliested :: exists in Database 2025-08-13 21:50:23 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 21:50:23 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 21:50:23 [INFO]: in processold action queue is array for {"44746991":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44746991","ebayitemid":"286291656222","shopifyproductid":"8811473371358","variants":[{"price":"15.99","quantity":0,"weight":"0.75","shopifyproductid":"8811473371358","shopifyvariantid":"46274710700254","shopifyinventoryid":"48375491821790","shopifylocationid":"","product_id":"44746991","variant_id":"77655399","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 21:50:23 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 21:50:23 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 21:50:23 [INFO]: Shopify Inventory id 48375491821790 2025-08-13 21:50:23 [INFO]: Shopify Location id 58450641063 2025-08-13 21:50:23 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 21:50:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T21:50:23Z","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-13 21:50:23 [INFO]: Change: available | Delta: -1 2025-08-13 21:50:23 [INFO]: Change: on_hand | Delta: -1 2025-08-13 21:50:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 21:50:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44746991 and user_id = 14409 2025-08-13 21:50:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77655399 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 21:50:23 [INFO]: updateIdsQuantity -> ["77655399"] 2025-08-13 21:50:23 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 21:50:23 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77655399 THEN 0 END, quantityflag = CASE WHEN id = 77655399 THEN 0 END WHERE user_id = 14409 AND id IN (77655399) 2025-08-13 21:50:23 [INFO]: QUANTITY Updated IDs: 77655399 2025-08-13 21:50:23 [INFO]: Successfully processed data for user 14409 2025-08-13 21:50:23 [INFO]: Execution Started 2025-08-13 21:50:23 [INFO]: Execution Finished