2025-08-05 10:00:01 [INFO]: Execution Started 2025-08-05 10:00:01 [INFO]: old server sucessfully connected 2025-08-05 10:00:02 [INFO]: sqs client sucess created 2025-08-05 10:00:03 [INFO]: Number of messages in the queue: 6 2025-08-05 10:00:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:00:03 [INFO]: item found in queue is 14409 2025-08-05 10:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBaNKZ9u/dxdmPeXtd4qo2scGCEtT0FspBVyBQn1qw9/1VgnmA+4eN9udU+MvAG4Eljt3zLQyvMuSCGNvDtXF5vPPe2GqyQRoq/9reoMjhUJ3BNGKkukIM7uMpXvfwitE5vK6p9mqgBAteh09bBwfj80eAfS9+GD7EIX9fE5lq1U3+meozNrg1U4ThYykei19AN90VTGeAatGJAA2gqV8CKMdS0qAgG21xsbCEhdj5Z8wcbJEvo89lorWPJDlXvu2t7MR80HCeQSfprxLTqW2giPoE9naAOQyhIuK2MLA4aRPkjRpMpv7KnPe1eJRCVUuKEGaeKmEE6L1pIiqQTaZVeXqL8W+VJz+i6PN/qKpWISgHTLdGmFxWwGcmzvrPrmggGoOLokjLgrX6TjtbJGpZTZsMlJcHRB6z8ArHg4yfIJaIIVOsn9CRJ7rPpkmRG3w0 2025-08-05 10:00:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:00:03 [INFO]: item found in queue is 14409 2025-08-05 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB8dE5M9iw8A633Eko9+vdNyq1dOeBxJQ/j8JT9NddmPvyplhPWMRrz1mpCo+MmlMsqrN8Shjw2D49u2oIsooRx7OGtKU5OYxNF/XinddH6HIu6/Q1tBEi+kWm/diXfxrZ+oLWVI+Oqd/pKYMm3TOQkVPdG3xJj4Ex2Z3lralJ2HtqyjU/VA4inWtImLpXM7iYTB5vjNZh4uq7O6/ppiduiFu7oNOzkC5APOOer+MfNXfzYx9JBtxvtu90ZVLL7Vss0zjZV6fYHH4/Z7x+nalqHDHxjRetqRZMqdoEahwftxmko7zK5ZF8tOsG+QGdgdrNKUNsBHibrIMPi11xD9OKQJt83U/2+79QSqVh1JRSZKDE/uRrS/u8G8ZmO6C9JXLi6Vy5bDAcJBD9uI8QKODT3WagVGP+J+nAry5xHIqXlhkGv/O1b9/nyt3ibz8nWFdQ 2025-08-05 10:00:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:00:04 [INFO]: item found in queue is 14409 2025-08-05 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvKmSL9uquS7dStnPZdY+TL8SaqyS1gvw2y3oqpnL4rDz7B7Ytk8SnhUCDZFbmqnD73jJIyqNBo5OOwAzkTtrpLamQV444WRjwknD3YkLb3xIionzNU2nyE1+28OqeHAN+yerAJ3WYMuPgAkJdBr9M27TdHLLnrDaICFT0WlrjGfsf7DmGlZys6ZWpZyTB07VUqY7mVI+VTLzNq48gFs5CfmtUxIwa85hKBmSBvIQAzfxQV9ytIQ2R7yR1+O5sxImpkzzT5IQFHoE8GZhei2LLLbHzFmuYlKvzcWdqNhCTo66wA4dA0yBZlT4xgwMSDd7mFsMs2UEMHLStexPdrypY1210mc4MRhbJSEO2FWyCjEHTPg0GvAO63Kme+uQyVuDvN/NIlnRKb1nshnR1HBvFX6D6jJxijO+a+RSxmbkpo4uXHxn5WzKzX6+1KYS8QNG 2025-08-05 10:00:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:00:04 [INFO]: item found in queue is 14409 2025-08-05 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBm/3bk/YbDJr8CgPQPaQ/aNmdms+ZELRXShEn1QB9mKverdVVgopn456TiiOiqckt848DWim6NtJUfiEMS0+pTFvNOrBhIslwRKrvgg7J0eZrb2oiqOEwxlmAw37I/hVdUroxgz3ujI4/0DiZh4hMpFJI6MPP7shMWsf2GG1jcYDe9PEUHvxqqVZjXNkg1G0msxBWLs5p/AYWxLa5+OFiJLenk6ska4/+Kzggf/OhF0xJCDiRntnfP6hi1IJaugd+AigQtmDmT49JLUXfkvrwCJ/utX444UIiYqkAycFf5Miv3l0AOy86Lb36UztUCFyQDqX8e59AbXbKd05SdqlfMm7XwT3Y3SAVNcexspQLGCmunmoSejMNpDQr51Yz+P0PIB2lTTa4FP8wYeFWYWjjjVmkDV7UMtSfGn6P1ay5NsZ5D0MMYGc8NO80bm9Utm9n 2025-08-05 10:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 10:00:05 [INFO]: item found in queue is 14409 2025-08-05 10:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEB0EOPz52QwOXi+u6YGLp3dveHbYxNaeunEV/lZCSrgC/fGd6qbiX3kn3mtQhQPE8ItMblOpcgI7Zw3BbQw69J+Im/L5wCPb25YFORPaDCgBC+Q3iQiwFeh0B5dCWZJ832QtUVMZ0wLcwCzJOxuwrhjvdQQ6xgF+D/kM8HXEb+A3x5rnTnr/1fMsIXY3ALVwijkrn1OYtCSOac+ETpJLw9txOf70zS96sTPVJTtpnl4rIrOqg3UUJvzXC3K3ZwmoMnNqWi4JOsUy/QFgjym2xarJeT7Ism/ZQyNWONFH0qKW3jiT0EDpkp1vSK7Vy7JrSjY3SsDjAWBe+ustQv58BxX7fQB3MErR5OhvUcW7Ry5Mcqs1eXxUUZf4rYyDq84R1EelxvG7HWlUvG+eRulbD1vUaYbxDaZrqC64tKiRgdNb3Z5BtZnTcIvePivkisMI/b 2025-08-05 10:00:05 [INFO]: item found in queue is if condition 14409 2025-08-05 10:00:05 [INFO]: item found in queue is 14409 2025-08-05 10:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBUbjebxN7ePUkM0JP0w5EhM7Mvx820ijBTbn5ftfYC/QUgEPL9xJ7f2XETyZtjZzvO5q37ghbx8igUDgyVIujDdAVl8b76MaFKTBb5E1AqLCJ8KcXP9/oBVCKf77OOZKxQSnO7SJOFDobVfZ7lXlAU0ZzpjazYaLimxPjUcG3iSG9HVxButFQqrSPdAwKHrXp/o4AScdg56mHhHS6bKe35U8bOeDIBR+i0tVxbsY1jTZeGyZRza3crCVs9NyLZMueXtz8T3JL9/ptIie8q34YzH+x1xGdjG0rxgw13yhhIVqL4zBf6rtetKROA3LALSdzCXlDDJMLJCyeRsKfZFhV3MmIa8mvmPQFjwkO22uIYj0xBnZSTtQk7FRLIW4fHHXlAwN2n/en5DRZPORY6EtjyixSAf0oO51CIvIBX6TmNBeeOTNT4usHLk85gJYHkJwG 2025-08-05 10:00:05 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-05 10:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 10:00:05 [INFO]: inside itemsold and closed 14409 2025-08-05 10:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:00:07 [INFO]: Ebay item id :: 226203934494 exists in Database 2025-08-05 10:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:00:07 [INFO]: inside itemsold and closed 14409 2025-08-05 10:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:00:09 [INFO]: Ebay item id :: 335283081636 exists in Database 2025-08-05 10:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:00:09 [INFO]: inside itemsold and closed 14409 2025-08-05 10:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:00:11 [INFO]: Ebay item id :: 226203934494 exists in Database 2025-08-05 10:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:00:11 [INFO]: inside itemsold and closed 14409 2025-08-05 10:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:00:13 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:00:13 [INFO]: Ebay item id :: 226203930867 exists in Database 2025-08-05 10:00:13 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:00:13 [INFO]: inside itemsold and closed 14409 2025-08-05 10:00:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:00:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:00:14 [INFO]: Ebay item id :: 404901472756 exists in Database 2025-08-05 10:00:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:00:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:00:14 [INFO]: inside itemsold and closed 14409 2025-08-05 10:00:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:00:16 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:00:16 [INFO]: Ebay item id :: 404901476510 exists in Database 2025-08-05 10:00:16 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:00:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:00:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:00:16 [INFO]: in processold action queue is array for {"44662665":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662665","ebayitemid":"226203934494","shopifyproductid":"8698519584990","variants":[{"price":"17.99","quantity":0,"weight":"2","shopifyproductid":"8698519584990","shopifyvariantid":"45941763965150","shopifyinventoryid":"48040242708702","shopifylocationid":"","product_id":"44662665","variant_id":"77567885","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44600020":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600020","ebayitemid":"335283081636","shopifyproductid":"8920673943774","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8920673943774","shopifyvariantid":"46784346554590","shopifyinventoryid":"48882860294366","shopifylocationid":"58450641063","product_id":"44600020","variant_id":"77492729","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44662659":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44662659","ebayitemid":"226203930867","shopifyproductid":"8696056905950","variants":[{"price":"71.99","quantity":0,"weight":"0.5","shopifyproductid":"8696056905950","shopifyvariantid":"45936040181982","shopifyinventoryid":"48034489106654","shopifylocationid":"","product_id":"44662659","variant_id":"77567879","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772332":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772332","ebayitemid":"404901472756","shopifyproductid":"8367231762654","variants":[{"price":"89.99","quantity":0,"weight":"2","shopifyproductid":"8367231762654","shopifyvariantid":"45062045401310","shopifyinventoryid":"47159903944926","shopifylocationid":"","product_id":"44772332","variant_id":"77680874","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44791205":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44791205","ebayitemid":"404901476510","shopifyproductid":"8918145597662","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8918145597662","shopifyvariantid":"46733796376798","shopifyinventoryid":"48832283640030","shopifylocationid":"58450641063","product_id":"44791205","variant_id":"77701454","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 10:00:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 10:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:00:16 [INFO]: Shopify Inventory id 48040242708702 2025-08-05 10:00:16 [INFO]: Shopify Location id 58450641063 2025-08-05 10:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:00:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:00:16Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:00:16 [INFO]: Change: available | Delta: -3 2025-08-05 10:00:16 [INFO]: Change: on_hand | Delta: -3 2025-08-05 10:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662665 and user_id = 14409 2025-08-05 10:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567885 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:00:16 [INFO]: Shopify Inventory id 48882860294366 2025-08-05 10:00:16 [INFO]: Shopify Location id 58450641063 2025-08-05 10:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:00:17Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:00:17 [INFO]: Change: available | Delta: -3 2025-08-05 10:00:17 [INFO]: Change: on_hand | Delta: -3 2025-08-05 10:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600020 and user_id = 14409 2025-08-05 10:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492729 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:00:17 [INFO]: Shopify Inventory id 48034489106654 2025-08-05 10:00:17 [INFO]: Shopify Location id 58450641063 2025-08-05 10:00:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:00:17Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:00:17 [INFO]: Change: available | Delta: -2 2025-08-05 10:00:17 [INFO]: Change: on_hand | Delta: -2 2025-08-05 10:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44662659 and user_id = 14409 2025-08-05 10:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567879 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:00:17 [INFO]: Shopify Inventory id 47159903944926 2025-08-05 10:00:17 [INFO]: Shopify Location id 58450641063 2025-08-05 10:00:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:00:17Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:00:17 [INFO]: Change: available | Delta: -1 2025-08-05 10:00:17 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772332 and user_id = 14409 2025-08-05 10:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680874 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:00:17 [INFO]: Shopify Inventory id 48832283640030 2025-08-05 10:00:17 [INFO]: Shopify Location id 58450641063 2025-08-05 10:00:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:00:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:00:17Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:00:18 [INFO]: Change: available | Delta: -1 2025-08-05 10:00:18 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:00:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:00:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44791205 and user_id = 14409 2025-08-05 10:00:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77701454 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:00:18 [INFO]: updateIdsQuantity -> ["77567885","77492729","77567879","77680874","77701454"] 2025-08-05 10:00:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-05 10:00:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77567885 THEN 0 WHEN id = 77492729 THEN 0 WHEN id = 77567879 THEN 0 WHEN id = 77680874 THEN 0 WHEN id = 77701454 THEN 0 END, quantityflag = CASE WHEN id = 77567885 THEN 0 WHEN id = 77492729 THEN 0 WHEN id = 77567879 THEN 0 WHEN id = 77680874 THEN 0 WHEN id = 77701454 THEN 0 END WHERE user_id = 14409 AND id IN (77567885,77492729,77567879,77680874,77701454) 2025-08-05 10:00:18 [INFO]: QUANTITY Updated IDs: 77567885, 77492729, 77567879, 77680874, 77701454 2025-08-05 10:00:18 [INFO]: Successfully processed data for user 14409 2025-08-05 10:00:18 [INFO]: Execution Started 2025-08-05 10:00:18 [INFO]: Execution Finished 2025-08-05 10:10:01 [INFO]: Execution Started 2025-08-05 10:10:01 [INFO]: old server sucessfully connected 2025-08-05 10:10:01 [INFO]: sqs client sucess created 2025-08-05 10:10:02 [INFO]: Number of messages in the queue: 4 2025-08-05 10:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:10:03 [INFO]: item found in queue is 14409 2025-08-05 10:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBuuwR6qvesLWbj3LPKs/QopJd9n5eH+tqIpUHSfIy88ohXEw9EX5Kxgw14b6o4rb5YxvvCfFpd/YuemhMiLkaxz6MBjNw0ZOo1vbCkkzlFpEIJD68+JEKSK8Sh8SWsYf0tIPXPs4ZIqQTM3UL5n3KzkBU/KZPHi+fRDQ2kWpEZxC4FYdVPzlJtuNp9QCNYSV8jvFQtNHAyPv3jfIlcRsDqCWKvexNtigHiO/AKEMGFnVhk6NSwqwja4qB4dt2+2fZeVA7FsPdi00s4SYXn7SVkUgxJDC1sMdQ30zw6qT6Fk04mPLYNFCQcTEfhb05m4CJtH+gFldIApUDSBW+/FgDNUeezK92ll5ApbfpHNzNlJUCwdzbD1CRpPqLquewYRGoAhvp4jk4CRurZgBCgobt/L2Sr8o3PZBiGm2N7wVulUU3pALEDwHIIM2Eif9wmh1s 2025-08-05 10:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:10:03 [INFO]: item found in queue is 14409 2025-08-05 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBANvpcAcjNt5960wr0JcITk0RHoa0yRFBbaSLEwNYK0Zo43m++esoOKxHIeMPyNpNA3P0F9mSCKhjKLbJVjEfy+5OwnTDHow28rOoVFA3kcSbblzPR3h2yeEwmrScJI8OD3GN3XQGSCPOq/o232L4Oewe1ni1mmK8ZPxXXtUGGzZzHc+LJg3xykjfhACTlAgsyOkRG/EwzcQ16lyzzr7aO0YvW2LHKHIIqeF4tN2/TEScBuVHChv78/85A8q2/QNW3dg+51PcTNEenDfEyzgclXlxNA1BOWEq5VzQb+6ZqlKxdgLTsnR719Zv7j0KJSV84QPqn8QH3P889l8gf42HqXskjJSjVfYx8frBFX2unMh5jjx+58Tpmu0LubZ/YZpN9BjVjPwQEqfMbir2lamFzJZwFSOlU2sbSi8HkQv47ozXX/ta6gyQCK2P3rqIeTiZ 2025-08-05 10:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:10:04 [INFO]: item found in queue is 14409 2025-08-05 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB4AXB8mWa7dkBy2VxHUwVyHfpUjm/hj7+HvqByOsV+2UJ515LeskrH3vH6j5U2j9+/SGtOi7j5OUOcqE+o2jknk0P0KDwRxiAFamqmSAhpiyDhcgTipMoZYUZW/UzJNsdkHoJ1sXZJrPku0jxv4qSNnjz2uzFDN0Hb3iEY/tk801fEU9SANyldOOc7aSWFzz66C2Yu1hO6RMNfP7D05uxBGZ5Tj/pV/i6PjPCeGTHH7iGXw5FS8JmQQFD34hIr0xTQHf2RYHe+OKp5q6ypU7CQDojOG4iT/vF+TxfgH/YDiIesGpvpeDeUdDBpO23faGVqtcr5tdAaK+2eqhSLEbP+iJIuyyI+sL/HPMSh1v7w5h84wvpwJvFmy8Pa5Wa4hl4tgggNQuq8KAJ+ZNHG9e29T1Q6FSLJ2Db0lM1y69D4dmWRV6o//IPGeNYDKSF6r9b 2025-08-05 10:10:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:10:04 [INFO]: item found in queue is 14409 2025-08-05 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBNryibN/Ho2ESocmdkz3LhDSoL7R0H0T3jWqE+06sEwmYx2/fh7idmbfuxgOM8nHAMvAumHRJvt0IXW9gZAMFgO/IcdaYZ3R3vC+UWMZEXsKEp3djaOZiCKsJwFtrZdjf0A5cS137gaSAlig963df25WQ9YZxr8CbPMTjf9j0gfNgtSzZhEG39ap76SanVglbe3y0GfjyrM2wx7AocXS6j7c/yPvlXWlzcK93K9hqH0arB9S0KHJ4RKWg9WyYbr+7tKFnszIuv7QNpEdkj66qviY84JjaSv5X4o17x1fQvA5KTZe9qHCsUYhyl8zBRDHOo3FwTBIBrW47LMoJy4KcM8FNNfqI6bXfbjZlZYGPmdTAW/SHfeL0y/5U4Rg7v+vJgG8iG20nypk1G/+N6fQ3uLSHMi06/hhS4zAOMpH5ztO3yUYberSaXlUHdrfakHUG 2025-08-05 10:10:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 10:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 10:10:04 [INFO]: inside itemsold and closed 14409 2025-08-05 10:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:10:06 [INFO]: Ebay item id :: 326288721508 exists in Database 2025-08-05 10:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:10:06 [INFO]: inside itemsold and closed 14409 2025-08-05 10:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:10:08 [INFO]: Ebay item id :: 305582135539 exists in Database 2025-08-05 10:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:10:08 [INFO]: inside itemsold and closed 14409 2025-08-05 10:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:10:09 [INFO]: Ebay item id :: 305579863166 exists in Database 2025-08-05 10:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:10:09 [INFO]: inside itemsold and closed 14409 2025-08-05 10:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:10:11 [INFO]: Ebay item id :: 285798173559 exists in Database 2025-08-05 10:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:10:11 [INFO]: in processold action queue is array for {"44688383":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688383","ebayitemid":"326288721508","shopifyproductid":"8702062199006","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8702062199006","shopifyvariantid":"45950681088222","shopifyinventoryid":"48049258856670","shopifylocationid":"","product_id":"44688383","variant_id":"77593629","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44588366":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588366","ebayitemid":"305582135539","shopifyproductid":"8504413028574","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8504413028574","shopifyvariantid":"45415904772318","shopifyinventoryid":"47513882001630","shopifylocationid":"","product_id":"44588366","variant_id":"77481075","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44586411":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586411","ebayitemid":"305579863166","shopifyproductid":"8500693926110","variants":[{"price":"45.99","quantity":0,"weight":"2","shopifyproductid":"8500693926110","shopifyvariantid":"45409458979038","shopifyinventoryid":"47507437158622","shopifylocationid":"","product_id":"44586411","variant_id":"77479120","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772351":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772351","ebayitemid":"285798173559","shopifyproductid":"8368368451806","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8368368451806","shopifyvariantid":"45064125743326","shopifyinventoryid":"47161984254174","shopifylocationid":"","product_id":"44772351","variant_id":"77680893","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 10:10:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 10:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:10:11 [INFO]: Shopify Inventory id 48049258856670 2025-08-05 10:10:11 [INFO]: Shopify Location id 58450641063 2025-08-05 10:10:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:10:12Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:10:12 [INFO]: Change: available | Delta: -4 2025-08-05 10:10:12 [INFO]: Change: on_hand | Delta: -4 2025-08-05 10:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688383 and user_id = 14409 2025-08-05 10:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593629 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:10:12 [INFO]: Shopify Inventory id 47513882001630 2025-08-05 10:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 10:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:10:12Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:10:12 [INFO]: Change: available | Delta: -2 2025-08-05 10:10:12 [INFO]: Change: on_hand | Delta: -2 2025-08-05 10:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588366 and user_id = 14409 2025-08-05 10:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481075 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:10:12 [INFO]: Shopify Inventory id 47507437158622 2025-08-05 10:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 10:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:10: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-08-05 10:10:12 [INFO]: Change: available | Delta: -1 2025-08-05 10:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586411 and user_id = 14409 2025-08-05 10:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479120 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:10:12 [INFO]: Shopify Inventory id 47161984254174 2025-08-05 10:10:12 [INFO]: Shopify Location id 58450641063 2025-08-05 10:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:10:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:10:13Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:10:13 [INFO]: Change: available | Delta: -1 2025-08-05 10:10:13 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772351 and user_id = 14409 2025-08-05 10:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680893 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:10:13 [INFO]: updateIdsQuantity -> ["77593629","77481075","77479120","77680893"] 2025-08-05 10:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-05 10:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77593629 THEN 0 WHEN id = 77481075 THEN 0 WHEN id = 77479120 THEN 0 WHEN id = 77680893 THEN 0 END, quantityflag = CASE WHEN id = 77593629 THEN 0 WHEN id = 77481075 THEN 0 WHEN id = 77479120 THEN 0 WHEN id = 77680893 THEN 0 END WHERE user_id = 14409 AND id IN (77593629,77481075,77479120,77680893) 2025-08-05 10:10:13 [INFO]: QUANTITY Updated IDs: 77593629, 77481075, 77479120, 77680893 2025-08-05 10:10:13 [INFO]: Successfully processed data for user 14409 2025-08-05 10:10:13 [INFO]: Execution Started 2025-08-05 10:10:13 [INFO]: Execution Finished 2025-08-05 10:20:01 [INFO]: Execution Started 2025-08-05 10:20:01 [INFO]: old server sucessfully connected 2025-08-05 10:20:01 [INFO]: sqs client sucess created 2025-08-05 10:20:03 [INFO]: Number of messages in the queue: 4 2025-08-05 10:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:20:03 [INFO]: item found in queue is 14409 2025-08-05 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBNsRLCsAM6htjrA7Zpp0XPGFjfYcRCC8KLZtGcp0NOXCKVFpF6sfp+ykr+XQ4pvQVcd5Qf6RDEffNSLPi16A47NXZb8kB36sDGa1opkXPaQWD4PeIbfelzDhCduHg3kxx3KXEG2u9I4rJ2M8t0kHrLi0f9WrctCGSYP+PxEq/bgu0WBY/Lm+o4rM83IZZP/OC0VOV8BUIACBPhZqvU9qcZgV12hNS3ZhpwaWUrophgEz8TV8zLIZWuqKmJTJjWWd+34zK6ZlCtmC/6Wz4mAVdftDFO9L+dVmSA9BxG6FIz0RXDCYFvbssfV4ShmBOVqtybIjA/EBJUeCf37S1KifTSkzFX6QLB+bFLwOuiZoBMCpNuyKoMuntC2gmmHVZoNeMTjXp7aXaAN5Djp3v5iSZnLXKcinuv1PxjQ0Mog9FP0D7RdBYP97NE5EbT7bKqEDh 2025-08-05 10:20:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:20:04 [INFO]: item found in queue is 14409 2025-08-05 10:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBvKkNrXVUX5xRPtCcaYazV75e0HCiUfrNnwe36G+ufRps6QZo5+hh4xjb/fyRoNH0TxM1s2ZCHgVAgkcn5MWSJcdDX32iRAqa2KA/41uVjiCDH9VlsBRaDeCfLNObfZnFNXzA0ntkGm5739zVePXK2/RKetEzP1shgljJWQXD91Sb+3jXsuWYw7DZANHndfGZEIa2264D/TTQj9HZTwARiunfSi1iBXnh56lfWwt5fp+UhpR0zcRxUNN3H8FWchMZ7tuXH4DvgfDt78SMWJGz8Yf3dKaTmka2nPTFUg4WC8iFrkYUH8iSLpo8YnneEjuK3mfCd4AEHW/wAGG3ZccmkBVKYnUUlVo4UrPTDuLxrCg7X1XkfL/yApQgoP1+2iXHJSgCYXpWBkZJxQIg+Bqmgc/PBWuJJ+T/dtcrSbPNAJU8uobPU2laJc/polZ7Xzpy 2025-08-05 10:20:05 [INFO]: item found in queue is if condition 14409 2025-08-05 10:20:05 [INFO]: item found in queue is 14409 2025-08-05 10:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBL4Rn/g6FP0fT7WKt4hoY67h8cKwfJO1jkdnrLN7na0x8+tHxC3okcV9FRu8Kci8z5VfaPQhXSg3DWm9EYJhJyUKiFlVhaUpajt/MiVFT5D3oL/e3ig3pXLL+0Y1spwM7SoUnK/8fDe4P1W1Bm7S7P35cgvXr2+Pcz5AR3FVeYJ+kfQ3sKeacMVBrW6XRv2EMstdaEbAQIPQj0FERjP1A40rcIFBNqc7M9FbRXrBCmhbbDyp70xhzwA+ICrmUSq6xwRBtuyE93zOa7yLSp3eWqCNaJ5ZokLNpydw3yAp0nJUyNdgCvgg4xUumWW2t/YKLJcW2cLg7MsIl2i0GfAHTzODGqiEB7vgzzIxSMclkhBMY59FjF1YxgjEhDXmXec5tr9btBTKa+AKWSZH+sZvzy08hrUDutUi0gQz3Oq2QbrUeFJGZxmUxQ+SCi+BROyFz 2025-08-05 10:20:06 [INFO]: item found in queue is if condition 14409 2025-08-05 10:20:06 [INFO]: item found in queue is 14409 2025-08-05 10:20:07 [INFO]: Message deleted from the queue for receipt handle: AQEBZLIisjRkP6XnaKzuYCfRAnTlbp5SX3YpTTEWLq7NiLjXR62yMsZ5Wm9E2C/UtBUzPE1wFtdiAD5HUaZ8DlscyxTIwUocSWUDhsWz9eN2OLDAm7VH9jFk1iGDaXm0y11gGKfz0W17k7YXkoFwkxGYvmEN0oo+yu6qhdxXxY5FTt75vBxjkELC62ViX1Ntf4k3lD+bnDRXglVne+AABY9B3L0Na8Pp7DXH1KqOo7c37DdFdRlrhyrDs3+reRSVIIPj5zxpiOCoyRHt6aX7sbrlI0lBJXvPFLmUOtICEk6Deh4/DhYTnaLMvbHFlTcFnNTTQMw79AVfgz8JD25RobynHJJLHUtGcltc8ei3knJEAOxmRBlh3Tgg+hYeDeptSFMNcsiaSPPRyolBIzmwiP74RAwHICWiPcgo+qgV7wuOLtSu/RY8WY5xKE5Z4mbxZWQU 2025-08-05 10:20:07 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-05 10:20:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 10:20:07 [INFO]: inside itemsold and closed 14409 2025-08-05 10:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:20:09 [INFO]: Ebay item id :: 305730671370 exists in Database 2025-08-05 10:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:20:09 [INFO]: inside itemsold and closed 14409 2025-08-05 10:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:20:10 [INFO]: Ebay item id :: 225911829300 exists in Database 2025-08-05 10:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:20:10 [INFO]: inside itemsold and closed 14409 2025-08-05 10:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:20:12 [INFO]: Ebay item id :: 256469827987 exists in Database 2025-08-05 10:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:20:12 [INFO]: inside itemsold and closed 14409 2025-08-05 10:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:20:14 [INFO]: Ebay item id :: 285800036631 exists in Database 2025-08-05 10:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:20:14 [INFO]: in processold action queue is array for {"44733959":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733959","ebayitemid":"225911829300","shopifyproductid":"8232972484830","variants":[{"price":"74.99","quantity":0,"weight":"0.9375","shopifyproductid":"8232972484830","shopifyvariantid":"44597284307166","shopifyinventoryid":"46695256326366","shopifylocationid":"","product_id":"44733959","variant_id":"77641844","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772382":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772382","ebayitemid":"256469827987","shopifyproductid":"8369834229982","variants":[{"price":"229.99","quantity":0,"weight":"3","shopifyproductid":"8369834229982","shopifyvariantid":"45069930987742","shopifyinventoryid":"47167790514398","shopifylocationid":"","product_id":"44772382","variant_id":"77680923","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772385":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772385","ebayitemid":"285800036631","shopifyproductid":"8369981817054","variants":[{"price":"177.99","quantity":0,"weight":"2","shopifyproductid":"8369981817054","shopifyvariantid":"45070829551838","shopifyinventoryid":"47168689078494","shopifylocationid":"","product_id":"44772385","variant_id":"77680927","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 10:20:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 10:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:20:14 [INFO]: Shopify Inventory id 46695256326366 2025-08-05 10:20:14 [INFO]: Shopify Location id 58450641063 2025-08-05 10:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:20:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:20: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-05 10:20:14 [INFO]: Change: available | Delta: -1 2025-08-05 10:20:14 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:20:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:20:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733959 and user_id = 14409 2025-08-05 10:20:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641844 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:20:14 [INFO]: Shopify Inventory id 47167790514398 2025-08-05 10:20:14 [INFO]: Shopify Location id 58450641063 2025-08-05 10:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:20:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:20: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-05 10:20:14 [INFO]: Change: available | Delta: -1 2025-08-05 10:20:14 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:20:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:20:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772382 and user_id = 14409 2025-08-05 10:20:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680923 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:20:14 [INFO]: Shopify Inventory id 47168689078494 2025-08-05 10:20:14 [INFO]: Shopify Location id 58450641063 2025-08-05 10:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:20:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:20: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-05 10:20:15 [INFO]: Change: available | Delta: -1 2025-08-05 10:20:15 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:20:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:20:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772385 and user_id = 14409 2025-08-05 10:20:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680927 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:20:15 [INFO]: updateIdsQuantity -> ["77641844","77680923","77680927"] 2025-08-05 10:20:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 10:20:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641844 THEN 0 WHEN id = 77680923 THEN 0 WHEN id = 77680927 THEN 0 END, quantityflag = CASE WHEN id = 77641844 THEN 0 WHEN id = 77680923 THEN 0 WHEN id = 77680927 THEN 0 END WHERE user_id = 14409 AND id IN (77641844,77680923,77680927) 2025-08-05 10:20:15 [INFO]: QUANTITY Updated IDs: 77641844, 77680923, 77680927 2025-08-05 10:20:15 [INFO]: Successfully processed data for user 14409 2025-08-05 10:20:15 [INFO]: Execution Started 2025-08-05 10:20:15 [INFO]: Execution Finished 2025-08-05 10:30:01 [INFO]: Execution Started 2025-08-05 10:30:01 [INFO]: old server sucessfully connected 2025-08-05 10:30:01 [INFO]: sqs client sucess created 2025-08-05 10:30:03 [INFO]: Number of messages in the queue: 3 2025-08-05 10:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:30:03 [INFO]: item found in queue is 14409 2025-08-05 10:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBjdchFBERlVIijCGZITAGnjBf1jcVLSdkVpUv8r8Hhi+Vef+0HJSVNTrBB/jW1jS8VcoD8BYKeeYzvvMu5v2CI8u+Zxxtl1WR8lZXye7e9EbyTyUD40JcZoEe4UCE64kZQlJ+aIjLuo7HeVNpYMKtPrm+smDjR0G4pA/qxS+h8gMXjWUYUkK86DTSDi5iXWuRcY/m0CjhgN5bcyvScJ+RadWo4chpLBGtqCKEy0nVqdMiiOJYds2s/CObmuW/8Qgj8AXTq1OOwQqkHIOK+2yWrDj3FStEHYKPW24UuuRwM+Rk3xM8kG/nQ5r3I9hz3JPHYJ1YANlZ5HZaj77SnXNoVKPeZQB942muiRR9WFUQV7pIbHyRamiEVT7m4ucEuuLfXkf7HrZwuEAzo06Hwj1ua1x+KWjl2sGQAe0detYKKdVWlyeNm5YeWOD357R/baP7 2025-08-05 10:30:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:30:03 [INFO]: item found in queue is 14409 2025-08-05 10:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB0gQKcLDEHHuTEeXRdnShXTcA0VBUBd+aQ5tuyW7td2wrOKYdGzK9V8aJwIf2IaWqMhyQiEi+GY3HF4TL9LzqBSt+d7j5BYqcifHZMeoS8Fd5L/D+cTm+zPLCUtHWc4X3RQpxFLpFBg9iLRD0xeKlDMMy9Em8e67GzWn5SxmSNdMWYcN2Po2Qu3VPz5ZKRjvIECoP/pkAvX61Egzh9qvdwwtaJy2uP/c4V7ZXjyqIP8Jcz7LOnEKf7SGibL0fJIMjuV/ARtHv3sAsiA2Ye2EkBAM8TratQBbHcQhVhXfCvIs76JOb27bZBDoP1OQjmJxb7I9WXwxu8/GvTeinumGV78QXWZFA/ApY6MTbAH6WdzjjfPdDn84y5EzecerMh4SQrtCzakrKeofGCSsogOfOeJ2VKsFnEL8ryYifIimLzdBhN1HxhhM4FQAtnB5SP6fr 2025-08-05 10:30:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:30:04 [INFO]: item found in queue is 14409 2025-08-05 10:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBXzVb9p4MWtKKiCJ3C1DU0U8hYTw+SOB3DFtHNcM+9aYDaOaCfqbPjWay1M9mFA7jkmJer+IbDZoXGN8J0P709SovuFqMqeBmqqm1+C6+7081ujzrlq2cpMBYYcLKnHJAsrPMYZ70FKR+LSMZNAGSehHPVvrF2YexC+ZkUxVRnAb9prNLK6cIZaj8aMzQkeNKrjAlEl7jogiHi3MNYcelCyp3+voBd3P2oIEu2S4hOghssoMlkyO2EvraNZTgo+MKqm9HvFHWLxdlKfoH5gtlrOJnwXQi9wtK/SmoO2BHldQzWfNvlwiJ6cDnEHGbtsuObn/gZ9M4ckrm+eRMD2RlIRI5PG9f5h0VGg+QNUo8aMiiv2jDsEOd13OGxl3rbDjYqoqh2kCi+yxqrj6tHUq6UTuhPz7fF0afzyFNibWYg9J3KxxQEvtaFy7cSEmIAitG 2025-08-05 10:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 10:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 10:30:04 [INFO]: inside itemsold and closed 14409 2025-08-05 10:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:30:06 [INFO]: Ebay item id :: 333778532072 exists in Database 2025-08-05 10:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:30:06 [INFO]: inside itemsold and closed 14409 2025-08-05 10:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:30:08 [INFO]: Ebay item id :: 404911317851 exists in Database 2025-08-05 10:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:30:08 [INFO]: inside itemsold and closed 14409 2025-08-05 10:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:30:09 [INFO]: Ebay item id :: 285873306516 exists in Database 2025-08-05 10:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:30:09 [INFO]: in processold action queue is array for {"44558364":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44558364","ebayitemid":"333778532072","shopifyproductid":"6670076313767","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"6670076313767","shopifyvariantid":"39816177844391","shopifyinventoryid":"41910986375335","shopifylocationid":"","product_id":"44558364","variant_id":"77451044","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772441":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772441","ebayitemid":"404911317851","shopifyproductid":"8379718533342","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8379718533342","shopifyvariantid":"45101011828958","shopifyinventoryid":"47198875386078","shopifylocationid":"","product_id":"44772441","variant_id":"77680983","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44672087":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44672087","ebayitemid":"285873306516","shopifyproductid":"8922098663646","variants":[{"price":"71.99","quantity":0,"weight":"0.5","shopifyproductid":"8922098663646","shopifyvariantid":"46811514339550","shopifyinventoryid":"48909984596190","shopifylocationid":"58450641063","product_id":"44672087","variant_id":"77577307","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 10:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 10:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:30:10 [INFO]: Shopify Inventory id 41910986375335 2025-08-05 10:30:10 [INFO]: Shopify Location id 58450641063 2025-08-05 10:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:30: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-05 10:30:10 [INFO]: Change: available | Delta: -1 2025-08-05 10:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44558364 and user_id = 14409 2025-08-05 10:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77451044 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:30:10 [INFO]: Shopify Inventory id 47198875386078 2025-08-05 10:30:10 [INFO]: Shopify Location id 58450641063 2025-08-05 10:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:30: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-05 10:30:10 [INFO]: Change: available | Delta: -1 2025-08-05 10:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772441 and user_id = 14409 2025-08-05 10:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680983 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:30:10 [INFO]: Shopify Inventory id 48909984596190 2025-08-05 10:30:10 [INFO]: Shopify Location id 58450641063 2025-08-05 10:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:30:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:30:11 [INFO]: Change: available | Delta: -2 2025-08-05 10:30:11 [INFO]: Change: on_hand | Delta: -2 2025-08-05 10:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44672087 and user_id = 14409 2025-08-05 10:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77577307 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:30:11 [INFO]: updateIdsQuantity -> ["77451044","77680983","77577307"] 2025-08-05 10:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-05 10:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77451044 THEN 0 WHEN id = 77680983 THEN 0 WHEN id = 77577307 THEN 0 END, quantityflag = CASE WHEN id = 77451044 THEN 0 WHEN id = 77680983 THEN 0 WHEN id = 77577307 THEN 0 END WHERE user_id = 14409 AND id IN (77451044,77680983,77577307) 2025-08-05 10:30:11 [INFO]: QUANTITY Updated IDs: 77451044, 77680983, 77577307 2025-08-05 10:30:11 [INFO]: Successfully processed data for user 14409 2025-08-05 10:30:11 [INFO]: Execution Started 2025-08-05 10:30:11 [INFO]: Execution Finished 2025-08-05 10:40:02 [INFO]: Execution Started 2025-08-05 10:40:02 [INFO]: old server sucessfully connected 2025-08-05 10:40:02 [INFO]: sqs client sucess created 2025-08-05 10:40:03 [INFO]: Number of messages in the queue: 3 2025-08-05 10:40:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:40:03 [INFO]: item found in queue is 14409 2025-08-05 10:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBplTVR50spKAUEMQmhGLI2YGCXahWwWY555JtSLtvMBMNyCJLL6XuM78xh+wMPiKVaosReu6F+mhSdTZJLoko/CSZ7z9LQg1KEtivL9vD9hz9S8w35NIEtYsKhVrm3/3aaL3DlqZXxN3BqQQspmMPSXgDYCmzc70jZe0hjCgk62WrRSfTpBEIsznx2GL0x588NS7Al0qCDQqruR9TAV70rQVwSVPgKOZARDp9sCSeIEKN4V8wSWZcxFnFnniJjqF6xI2lohnH9BTyH3nE8kBGEEF30ypJlkzfXUbIIIMe8NTaOwNRlCtgTrqBXuBX1xijJqZtkEKkzW1uYA7j7AmNKWECldsJVH71lVo9/cYMv33Wm3wZ6WfyPIlvihqO4/oHkFguyN0Fgai5I4msbsR5tihqIr1NvsLyXkvJfBxEvQR5IxvFJhOLEVeo41jdtgUi 2025-08-05 10:40:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:40:04 [INFO]: item found in queue is 14409 2025-08-05 10:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBuOPobdNn2821ZFkQJl2z8pxulKYOJHAzTVbvewDENUTXgR9w0jz4fFD6V332WkXUeRbXa66JCoNCzetTsWRgtIqfULLfAyToVxRsSoz9M+2tQgccYLMtIIoy15rRg3lbDfn0GUZaAK53Q3iNyLKHnMMikhi3zV+cFE7DammFLPAvriLWvj6yC8cqhhaSuPNVx03tNVis8wkI7XZR9kmj7EruNKpckDuQzvU5SM66pWhXFhiRpWtIhqLkuD1Uy5ysRd0VRWNX1ALbfxG1Uti7+AKIr3aHHWw/D5J3iwzBv7qeiALdIvmc02UxLT5svEJHswrSLWRyQj0stAKga0q+x3BFniFBcOaTHnNS+KjWrLowiGNPgFsAXBEkbYPcbJq1X4HgXdfAG4pxdomhXzmQ2Q1+kGxo1OlTNCMR8SFDZNuYsZo2YX73gtohusrXLIZs 2025-08-05 10:40:04 [INFO]: item found in queue is if condition 14409 2025-08-05 10:40:04 [INFO]: item found in queue is 14409 2025-08-05 10:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBvEFljw6H0yy54AZVSkTnqSOzSMkVAlRQmQ6jVNj8gCU5H2cwKTAwXzpsWnc8Ol0wRdFPibxuQL5sR7GKcMzSNT82VBkc1xmu1F+yWcqnwv2vvZSgxhZG6+6qY3PXrDSe9MtaLc01oSD1LruutF8ZfvoyuhhzKBlNhTInHrnqU1XNQu5a3MrFl0Z8E9U3c84fTfy9envlZ62D5JZLh4Hm/7ybn29BAgm+YceZYIxqvTo4rvOUxRDE7adcBBtb3Uvetjg8QU6CzUNFQDc8HtE6Q2mvH/H2Qp1TSB64Jz03UAESRwwmgny21bgIZ4JRFCjvPYuU05Z0+v7IhY8TYCvuEbblAv4JK2xNznvne1Z2rIjuNqN8IBGTeXpYFzqvjBi0JwnZcPYC4OALa68gzjDEmwMF+YD+2IDSP0sJvkn5Ppfr4j2Qpl9TDk7xFDEWNxKS 2025-08-05 10:40:05 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 10:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 10:40:05 [INFO]: inside itemsold and closed 14409 2025-08-05 10:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:40:07 [INFO]: Ebay item id :: 284233899999 exists in Database 2025-08-05 10:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:40:07 [INFO]: inside itemsold and closed 14409 2025-08-05 10:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:40:09 [INFO]: Ebay item id :: 284148607333 exists in Database 2025-08-05 10:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:40:09 [INFO]: inside itemsold and closed 14409 2025-08-05 10:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:40:10 [INFO]: Ebay item id :: 284148607333 exists in Database 2025-08-05 10:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:40:10 [INFO]: in processold action queue is array for {"44592249":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592249","ebayitemid":"284233899999","shopifyproductid":"6678821929127","variants":[{"price":"19.97","quantity":0,"weight":"2","shopifyproductid":"6678821929127","shopifyvariantid":"39856575611047","shopifyinventoryid":"41951485952167","shopifylocationid":"","product_id":"44592249","variant_id":"77484958","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44573318":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573318","ebayitemid":"284148607333","shopifyproductid":"6678828449959","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"6678828449959","shopifyvariantid":"39856596680871","shopifyinventoryid":"41951507021991","shopifylocationid":"","product_id":"44573318","variant_id":"77466025","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 10:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 10:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:40:10 [INFO]: Shopify Inventory id 41951485952167 2025-08-05 10:40:10 [INFO]: Shopify Location id 58450641063 2025-08-05 10:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:40: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-05 10:40:11 [INFO]: Change: available | Delta: -1 2025-08-05 10:40:11 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592249 and user_id = 14409 2025-08-05 10:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484958 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:40:11 [INFO]: Shopify Inventory id 41951507021991 2025-08-05 10:40:11 [INFO]: Shopify Location id 58450641063 2025-08-05 10:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:40:11Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:40:11 [INFO]: Change: available | Delta: -2 2025-08-05 10:40:11 [INFO]: Change: on_hand | Delta: -2 2025-08-05 10:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573318 and user_id = 14409 2025-08-05 10:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466025 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:40:11 [INFO]: updateIdsQuantity -> ["77484958","77466025"] 2025-08-05 10:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 10:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77484958 THEN 0 WHEN id = 77466025 THEN 0 END, quantityflag = CASE WHEN id = 77484958 THEN 0 WHEN id = 77466025 THEN 0 END WHERE user_id = 14409 AND id IN (77484958,77466025) 2025-08-05 10:40:11 [INFO]: QUANTITY Updated IDs: 77484958, 77466025 2025-08-05 10:40:11 [INFO]: Successfully processed data for user 14409 2025-08-05 10:40:11 [INFO]: Execution Started 2025-08-05 10:40:11 [INFO]: Execution Finished 2025-08-05 10:50:01 [INFO]: Execution Started 2025-08-05 10:50:01 [INFO]: old server sucessfully connected 2025-08-05 10:50:01 [INFO]: sqs client sucess created 2025-08-05 10:50:02 [INFO]: Number of messages in the queue: 2 2025-08-05 10:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:50:03 [INFO]: item found in queue is 14409 2025-08-05 10:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKK1xVjdltE0/7W9EqAkZXYFj802zig5R+p2M+kapCe1/YmDpgOuHy6qer/lVugtrreWofT1eqWq7qViA04KOUokcbG3hRCukK4vuua/r2bWNcNS5hxB3x82vmHVMDVKXWgluicyrBCoGjRmaf2HAFt660BGVoq1Xrpy7nlKhVeAjYndjerpZvl74QDTQj1NDuj8EadgLvIb51/BcgRT5hu7FC1POlhO+oyBwdwlDBHZWprd4p5SU0YV6bGxIvCG3iCI5hYlsOIKDi1hgNN4pnL+wpgQz9zPUTPyGpOWjFLIjw/HuCZFI7atihmJR7JeNAPqSeZ7jzGW5Mi7JqG0ccn1TZqRxLzxIKfZ52pm5m19HR0YRes0/FfcCUCPP8cLtCxrE4TOiW7naDS6UpH8xcNeL6tDqJBvIaYrC/EVQLwMMrrzF8IrIzxIw9gWachsj 2025-08-05 10:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 10:50:03 [INFO]: item found in queue is 14409 2025-08-05 10:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBUhfEwtUp1I4nUqdSsHN+cjrJfyBiEufW0pM1ayAvmZ5fuoe3VRtdX8jNCAbC+y3C4vKdanwnuwfeNCQP71cLar4SiLnTH4x6w6PbAxQc7rswt5smmGMFy7cWAjrljAE9Bsz1KZwnGQAN+2fhx63R4t8zr3LzWnQEOggzblu1EJ4u89m6FA/Seq1pdZDPZEMq6lnzSn0iLZJJ7uoDxnisxTKKZVTJceqvZHnonXfT15nuSd67NT/cjglrdLuJHvZNw5K8+SlXUtGNocVoFfDzl5oJtkjyGzilIoU9Ou3Ep1z94FounJZ3TE6Md5jbrogVU02RU8D0UVAP7QPc0dk8hf+79zaEfKXK3Z/tklTz/pPxSc6f69/v2ADqNxDn/Jo1H5Ft3TXNkYJ4G4CcDnLmOPdBT43D+O9TFqXm3LkI1BY6wvezv181UJsyhsiLYlBM 2025-08-05 10:50:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 10:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 10:50:03 [INFO]: inside itemsold and closed 14409 2025-08-05 10:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:50:05 [INFO]: Ebay item id :: 304118693951 exists in Database 2025-08-05 10:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:50:05 [INFO]: inside itemsold and closed 14409 2025-08-05 10:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 10:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 10:50:07 [INFO]: Ebay item id :: 256477678233 exists in Database 2025-08-05 10:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 10:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 10:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 10:50:07 [INFO]: in processold action queue is array for {"44588813":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588813","ebayitemid":"304118693951","shopifyproductid":"7054893645991","variants":[{"price":"20.00","quantity":0,"weight":"2","shopifyproductid":"7054893645991","shopifyvariantid":"41368964759719","shopifyinventoryid":"43464983740583","shopifylocationid":"","product_id":"44588813","variant_id":"77481522","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772681":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772681","ebayitemid":"256477678233","shopifyproductid":"8395766595806","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8395766595806","shopifyvariantid":"45146170458334","shopifyinventoryid":"47244040077534","shopifylocationid":"","product_id":"44772681","variant_id":"77681223","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 10:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 10:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 10:50:07 [INFO]: Shopify Inventory id 43464983740583 2025-08-05 10:50:07 [INFO]: Shopify Location id 58450641063 2025-08-05 10:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:50:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:50:07 [INFO]: Change: available | Delta: -1 2025-08-05 10:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588813 and user_id = 14409 2025-08-05 10:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77481522 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:50:07 [INFO]: Shopify Inventory id 47244040077534 2025-08-05 10:50:07 [INFO]: Shopify Location id 58450641063 2025-08-05 10:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 10:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T10:50:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 10:50:07 [INFO]: Change: available | Delta: -1 2025-08-05 10:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-05 10:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 10:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772681 and user_id = 14409 2025-08-05 10:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681223 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 10:50:07 [INFO]: updateIdsQuantity -> ["77481522","77681223"] 2025-08-05 10:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 10:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77481522 THEN 0 WHEN id = 77681223 THEN 0 END, quantityflag = CASE WHEN id = 77481522 THEN 0 WHEN id = 77681223 THEN 0 END WHERE user_id = 14409 AND id IN (77481522,77681223) 2025-08-05 10:50:07 [INFO]: QUANTITY Updated IDs: 77481522, 77681223 2025-08-05 10:50:07 [INFO]: Successfully processed data for user 14409 2025-08-05 10:50:07 [INFO]: Execution Started 2025-08-05 10:50:07 [INFO]: Execution Finished