2025-08-05 22:00:01 [INFO]: Execution Started 2025-08-05 22:00:01 [INFO]: old server sucessfully connected 2025-08-05 22:00:01 [INFO]: sqs client sucess created 2025-08-05 22:00:02 [INFO]: Number of messages in the queue: 3 2025-08-05 22:00:02 [INFO]: item found in queue is if condition 14409 2025-08-05 22:00:02 [INFO]: item found in queue is 14409 2025-08-05 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB81l6LOp1XALy564ak8f4mX2cfi2PGFftFK6dtRJZPktPtnc9vOwI+lLMNiKA4n34vmQ4lh4AOzVrKLepOwG5G6P7zmUkgchbW9rQ306katQ82U75cOb/GSsYc+wNqSZZ1mxNj+OqxuMqM+BxWUreG/zQ4j5l8PIJXGkmbpI1VY9PtsNhMT0OgAQj5esmr+Om4vCEOMx4jDvFhZFyAtL8Z+JPV2u44i0icIUI6+h0uNA2701hm2LmqZG+dbyACPLmCqu4Wd7PjxcGK2LRdqxNoqMljVMamiv6ERaregIBWawHvqhY1ADF+heIX7AY9ZcRx4t9nl1iYJfY86Dpy8MMqFR7fslDszl39h68CMF9hmTXTxdp0AkCzzWV9WKvxQk6qcIVK3wdYQYroG05xCuvv3DrR+JUR4TKe++Sqz10ovZkOIA9lF+K1vskTdi6OV+o 2025-08-05 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-05 22:00:03 [INFO]: item found in queue is 14409 2025-08-05 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBGx3+3QbQIHpd/yyqe4n+tG0FbTn492w7g8bd85PtafxJvvyccUBWKue6+eAEq8TSlA5ZZkVCwdG3emezJ3aX1Zr3wJZ5K0vmvD4aHdrFRhlZYVh3KusQDPl4daRbhB3hXIv/6iN8MOSmg1jiCbi9ONG6R2aWqSfvOVlgda4yj9p1RRlBYtE+3NeWl1lmBGYPlvRr6pSVKU+cmuUDDbwyHLzfGqVIddI41jQron7NypvLDTujK4DLX+Kga0Ame0ZxUM1DD1at+1aFrT2y9OLMJM+nq6i5f+BHL7/N83BL3R7GuslithaVp7PXGSJfa6D1lxdnYIhCyKTZa+IsP3iiK11c4S3zpqdr4NtO9LfNsQv5p1Cq0sKOHGBdyKHiDSwm02fu+05Y69NqxYH3pvJ8iGBr4yl8+7BTdtjIYSi3lyEd2yveApcZoELFWleSZ0om 2025-08-05 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-05 22:00:03 [INFO]: item found in queue is 14409 2025-08-05 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1DLi5iAxOrjYx/WHsdf7afOT3br4aB3n/5QF43qXn7uKcZ+85KxA6k4m+vxzCu0w5d3HmFbxVgN+2URDEaBM76xgQ4jozsUQzxp/0Ofy8noyApXEFoZwLelq7Vx/aJz0mXntgekEhmoBCSxVbp6I46cHLtKHmUHlr0ZTVWEKwXVdhkkJor2dwwy/o78uqfsH9fayE7/FDltKPyptLsT+ZvuWWYdZXKqYlHWQFBv2U/cyg6U4XIWiZkUUHgUp6sLyfNmFpXzWsPnv97tuBA5M/eWW0jUFujhaunpUSkBK1+fXp64eVRVjlvO8nxFYpwtmIUihjG72qUbUiT8jUW1DwgGcbdb2c0hvpoNu1PM+bmLPnRvEZJqz81GfHgbplkexws/47cdYRJ6Q3I8a3mRvIYAvNp2yOzOA122pkZ5HIxa5PAfRR3s1dpIQIqXlm3v+ 2025-08-05 22:00:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 22:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 22:00:03 [INFO]: inside itemsold and closed 14409 2025-08-05 22:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:00:05 [INFO]: Ebay item id :: 286748912085 exists in Database 2025-08-05 22:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 22:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 22:00:05 [INFO]: inside itemsold and closed 14409 2025-08-05 22:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:00:07 [INFO]: Ebay item id :: 286747513375 exists in Database 2025-08-05 22:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 22:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 22:00:07 [INFO]: inside itemsold and closed 14409 2025-08-05 22:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:00:09 [INFO]: Ebay item id :: 335990433419 exists in Database 2025-08-05 22:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:00:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 22:00:09 [INFO]: in processold action queue is array for {"45313331":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313331","ebayitemid":"286748912085","shopifyproductid":"8980530069726","variants":[{"price":"159.99","quantity":0,"weight":"2","shopifyproductid":"8980530069726","shopifyvariantid":"47307645452510","shopifyinventoryid":"49419448189150","shopifylocationid":"58450641063","product_id":"45313331","variant_id":"78265844","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313143":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313143","ebayitemid":"286747513375","shopifyproductid":"8980015055070","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8980015055070","shopifyvariantid":"47293299720414","shopifyinventoryid":"49405120282846","shopifylocationid":"58450641063","product_id":"45313143","variant_id":"78265656","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45113161":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113161","ebayitemid":"335990433419","deleted":1}}} 2025-08-05 22:00:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 22:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 22:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 22:00:09 [INFO]: productIds WHich are having null productid -> [45113161] 2025-08-05 22:00:09 [INFO]: ebayItemIds WHich are not imported-> ["335990433419"] 2025-08-05 22:00:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 22:00:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 22:00:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113161) 2025-08-05 22:00:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 22:00:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 22:00:09 [INFO]: Transaction committed successfully. 2025-08-05 22:00:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 22:00:09 [INFO]: Shopify Inventory id 49419448189150 2025-08-05 22:00:09 [INFO]: Shopify Location id 58450641063 2025-08-05 22:00:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 22:00:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T22:00: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-05 22:00:09 [INFO]: Change: available | Delta: -1 2025-08-05 22:00:09 [INFO]: Change: on_hand | Delta: -1 2025-08-05 22:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 22:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313331 and user_id = 14409 2025-08-05 22:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265844 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 22:00:09 [INFO]: Shopify Inventory id 49405120282846 2025-08-05 22:00:09 [INFO]: Shopify Location id 58450641063 2025-08-05 22:00:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 22:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T22: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-05 22:00:10 [INFO]: Change: available | Delta: -1 2025-08-05 22:00:10 [INFO]: Change: on_hand | Delta: -1 2025-08-05 22:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 22:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313143 and user_id = 14409 2025-08-05 22:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265656 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 22:00:10 [INFO]: updateIdsQuantity -> ["78265844","78265656"] 2025-08-05 22:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 22:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265844 THEN 0 WHEN id = 78265656 THEN 0 END, quantityflag = CASE WHEN id = 78265844 THEN 0 WHEN id = 78265656 THEN 0 END WHERE user_id = 14409 AND id IN (78265844,78265656) 2025-08-05 22:00:10 [INFO]: QUANTITY Updated IDs: 78265844, 78265656 2025-08-05 22:00:10 [INFO]: Successfully processed data for user 14409 2025-08-05 22:00:10 [INFO]: Execution Started 2025-08-05 22:00:10 [INFO]: Execution Finished 2025-08-05 22:10:01 [INFO]: Execution Started 2025-08-05 22:10:01 [INFO]: old server sucessfully connected 2025-08-05 22:10:01 [INFO]: sqs client sucess created 2025-08-05 22:10:02 [INFO]: Number of messages in the queue: 1 2025-08-05 22:10:03 [INFO]: item found in queue is if condition 14409 2025-08-05 22:10:03 [INFO]: item found in queue is 14409 2025-08-05 22:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBeHX6OywNEJyX77vK7Bk9XqpPIzDRRhTcaLQQslTmCGDxpKl+YCdc1bJhdjoX9f/Woiinlc0diG4m4N/jT6g9Vu6jKoV9YX7udwnKTX/2kPad76gNi8lxoGTx4edhIhtZ6DNNCTwukD2atZiUtFUVh2P69GMzPzvn0mdS99F3+ebGy8knJc4UYzJIkaxfSB7PzlCIbRJpiWzXzB/36QPBpQugi6H/4k0vZVaOdaTtEQA6+EmchjEhB+5JuBd7izU8EzrE4MICHqkOCj4Ugb37JXYIsmK7JY7imDQh+zSEkUrTdt9HrzxMj6K1p59MVNkHDzKWP5SewqwdJarOL58Y0R5/drZMetBzpkkZETFJLPeLb4xFKZVweVbZOCejlmeKOCtIiHbHQpRqo+exEAg25uBkLDgfZBaGyTN6kywkBVkzLtlXbQ1Un/5+zo8bWZhG 2025-08-05 22:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 22:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 22:10:03 [INFO]: inside itemsold and closed 14409 2025-08-05 22:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:10:05 [INFO]: Ebay item id :: 257030834578 exists in Database 2025-08-05 22:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:10:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 22:10:05 [INFO]: in processold action queue is array for {"45281341":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45281341","ebayitemid":"257030834578","deleted":1}}} 2025-08-05 22:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 22:10:05 [INFO]: productIds WHich are having null productid -> [45281341] 2025-08-05 22:10:05 [INFO]: ebayItemIds WHich are not imported-> ["257030834578"] 2025-08-05 22:10:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 22:10:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 22:10:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45281341) 2025-08-05 22:10:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 22:10:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 22:10:05 [INFO]: Transaction committed successfully. 2025-08-05 22:10:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 22:10:05 [INFO]: Successfully processed data for user 14409 2025-08-05 22:10:05 [INFO]: Execution Started 2025-08-05 22:10:05 [INFO]: Execution Finished 2025-08-05 22:20:01 [INFO]: Execution Started 2025-08-05 22:20:01 [INFO]: old server sucessfully connected 2025-08-05 22:20:01 [INFO]: sqs client sucess created 2025-08-05 22:20:02 [INFO]: Number of messages in the queue: 2 2025-08-05 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 22:20:03 [INFO]: item found in queue is 14409 2025-08-05 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7k+YS2FA+vtqVj6bVQ6Tcxx1iRSr3c62I0hcdt8E7x0ya/wqIEq8HZYfEqtYUyDxD8WMbgNtvg1tyxNeHnrEAnZhK05Ax+zo6i1XoI/wz9w4p0ZjGggBA1UBmAgyCbqgeVBbZjOvnz80PYhcvMWtt8vzGKq4dgMAC3MYl15O/nwfKhN6ZcwDtAc5mA1XV19fnixhOA98wtgiGcASygkCfZIqtGeRDysq7QSLDRdnOssMrQLrledjsjBnEt9s+u8sn2bHWN7HWAb/38TiRuv3WGtHN/hN/drJISV58jJTsdxiNSUPgP7ZN86ocZ8d1n5lmGua4JSPpo8/pPuk4f+hXoq1oNeRZpOMaFBmKm+8ZYD2oXdmA6Ayi47HmXj5YSuBEyTHQne+QYUUL4QfaF0nWTBWaSz17VXNBtAq0U2+BxUduhRVUoNSBQY7Fa9O3qHX 2025-08-05 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 22:20:03 [INFO]: item found in queue is 14409 2025-08-05 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBTWigBCAozmtKm0W5vG5twBCirCtgv+gEabGtkB0ZSc2Eh+ElxHPuMMwKfGA9F6kaNGIakwIh7rDKD7XhEKjExAj7VZ1elrmCFqFmQqENPUQKy2ogOvgiXIy6aWc65k30D30puyaErIALvw0V4rkSXyjVE+f9ILKygKIS/B/10c2Lgmtin0wHA2UuyDyE1/lBCBHiFPPcj3f6zYM7u0HC1L8jU8htIpYBcr0i/OYbp4BSALL1NQVQTCGswH3leiYFiVUycAsZHxv8HU2tONiYPSDIA6EdvQAHbO0c4AgCZnZF2jK6p8ynqomWsrVZ5+YnxA7WQti/2LftE+HQli87cZeWl+0qYIFf0Xh8DeK5hX2cK5/iHsqq3x53a0XkOweUvkwDKuC0z3QB+TH1p7ZIjbip6t5BcfgxVgv4CYC34XckxIcw8fQ7Sbjb3I6ajhRg 2025-08-05 22:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 22:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 22:20:03 [INFO]: inside itemsold and closed 14409 2025-08-05 22:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:20:05 [INFO]: Ebay item id :: 303145473349 exists in Database 2025-08-05 22:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 22:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 22:20:05 [INFO]: inside itemsold and closed 14409 2025-08-05 22:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:20:07 [INFO]: Ebay item id :: 285415546006 exists in Database 2025-08-05 22:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 22:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 22:20:07 [INFO]: in processold action queue is array for {"44559847":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559847","ebayitemid":"303145473349","shopifyproductid":"6830667890855","variants":[{"price":"9.95","quantity":0,"weight":"0.75","shopifyproductid":"6830667890855","shopifyvariantid":"40333214744743","shopifyinventoryid":"42428560605351","shopifylocationid":"","product_id":"44559847","variant_id":"77452527","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44764849":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44764849","ebayitemid":"285415546006","shopifyproductid":"8104829026526","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8104829026526","shopifyvariantid":"44299807162590","shopifyinventoryid":"46397141123294","shopifylocationid":"","product_id":"44764849","variant_id":"77673391","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 22:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 22:20:07 [INFO]: Shopify Inventory id 42428560605351 2025-08-05 22:20:07 [INFO]: Shopify Location id 58450641063 2025-08-05 22:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 22:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T22: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-05 22:20:07 [INFO]: Change: available | Delta: -1 2025-08-05 22:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-05 22:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 22:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559847 and user_id = 14409 2025-08-05 22:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452527 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 22:20:07 [INFO]: Shopify Inventory id 46397141123294 2025-08-05 22:20:07 [INFO]: Shopify Location id 58450641063 2025-08-05 22:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 22:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T22:20:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 22:20:08 [INFO]: Change: available | Delta: -1 2025-08-05 22:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-05 22:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 22:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44764849 and user_id = 14409 2025-08-05 22:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77673391 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 22:20:08 [INFO]: updateIdsQuantity -> ["77452527","77673391"] 2025-08-05 22:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 22:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77452527 THEN 0 WHEN id = 77673391 THEN 0 END, quantityflag = CASE WHEN id = 77452527 THEN 0 WHEN id = 77673391 THEN 0 END WHERE user_id = 14409 AND id IN (77452527,77673391) 2025-08-05 22:20:08 [INFO]: QUANTITY Updated IDs: 77452527, 77673391 2025-08-05 22:20:08 [INFO]: Successfully processed data for user 14409 2025-08-05 22:20:08 [INFO]: Execution Started 2025-08-05 22:20:08 [INFO]: Execution Finished 2025-08-05 22:30:01 [INFO]: Execution Started 2025-08-05 22:30:01 [INFO]: old server sucessfully connected 2025-08-05 22:30:01 [INFO]: sqs client sucess created 2025-08-05 22:30:02 [INFO]: Number of messages in the queue: 0 2025-08-05 22:30:02 [INFO]: item found in queue is if condition 14409 2025-08-05 22:30:02 [INFO]: item found in queue is 14409 2025-08-05 22:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKyDhwvV1BSX1CbyqFzQp0cAQbNzotRle9XzWKocimvG1EjbkKKlO43lBKbf3xAavaltKqkPym4Qi0aXK1ikO84EkLppFRefBXJSEp+5jzLNkUJNssH9AgUJKK25cvcbcIsZYSfmv93PPeKRaOcXczhuzbu+8mRDrafJJUevM/Y+OtgTzvEOr37LKutRBhLNW05vagUD94fIL219eR46KI5fK5D/0w2rRhxrGJLNZkTuP7JQiEHce7I15WXbum2x+eBtRSnUmGOgIY+Q3LpCWfEDTBghpcPBqwsZC0iHJshrrKndKEjcPNzY4nX1IfYp2ZDarb46kXo9Lm5p4p84gpn1PQ4Y/6ztY2zi7Z8v2v8gJnEtLJBn6Aok9CcMdDCbFfk12gsuk+tDsn8nHb5OvLYhjGD+q7TQ8rcrT/CHXDFit9+l078dtzgG0OQeWPCO2 2025-08-05 22:30:03 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-05 22:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 22:30:03 [INFO]: inside itemsold and closed 14409 2025-08-05 22:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:30:05 [INFO]: Ebay item id :: 286381726246 exists in Database 2025-08-05 22:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 22:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 22:30:05 [INFO]: in processold action queue is array for {"44557120":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557120","ebayitemid":"286381726246","shopifyproductid":"8838219366622","variants":[{"price":"65.99","quantity":0,"weight":"2","shopifyproductid":"8838219366622","shopifyvariantid":"46352452354270","shopifyinventoryid":"48454175523038","shopifylocationid":"","product_id":"44557120","variant_id":"77449800","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 22:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 22:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 22:30:05 [INFO]: Shopify Inventory id 48454175523038 2025-08-05 22:30:05 [INFO]: Shopify Location id 58450641063 2025-08-05 22:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 22:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T22:30:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1987,"restoreRate":100}}}} 2025-08-05 22:30:05 [INFO]: Change: available | Delta: -1 2025-08-05 22:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-05 22:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 22:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557120 and user_id = 14409 2025-08-05 22:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449800 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 22:30:05 [INFO]: updateIdsQuantity -> ["77449800"] 2025-08-05 22:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 22:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77449800 THEN 0 END, quantityflag = CASE WHEN id = 77449800 THEN 0 END WHERE user_id = 14409 AND id IN (77449800) 2025-08-05 22:30:05 [INFO]: QUANTITY Updated IDs: 77449800 2025-08-05 22:30:05 [INFO]: Successfully processed data for user 14409 2025-08-05 22:30:05 [INFO]: Execution Started 2025-08-05 22:30:05 [INFO]: Execution Finished 2025-08-05 22:40:01 [INFO]: Execution Started 2025-08-05 22:40:01 [INFO]: old server sucessfully connected 2025-08-05 22:40:01 [INFO]: sqs client sucess created 2025-08-05 22:40:02 [INFO]: Number of messages in the queue: 0 2025-08-05 22:40:23 [INFO]: Execution Started 2025-08-05 22:40:23 [INFO]: Execution Finished 2025-08-05 22:50:01 [INFO]: Execution Started 2025-08-05 22:50:01 [INFO]: old server sucessfully connected 2025-08-05 22:50:01 [INFO]: sqs client sucess created 2025-08-05 22:50:02 [INFO]: Number of messages in the queue: 1 2025-08-05 22:50:03 [INFO]: item found in queue is if condition 14409 2025-08-05 22:50:03 [INFO]: item found in queue is 14409 2025-08-05 22:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBD/uOCxVt0nLEo2mYtdy9bB2rmkZQ7nfoJbaOgF5nSKhIVwHss9DuuBJio6Ok4FrvfR23ig55r4+nRKlkFZVZypP7djE036Vsi0QFYaeP3IdjHUoyJ4KkL6ZweR8S3pWVG2um72MevXgyilu0HvoflijSOv8kS6Pw+SUzCLbFVy1GBypMizVmpmTQSHytFfmrC6uPei/P1TSxEF38dIWK0njXaZJNe9fMgwv8ix+DCUCtwRSWoUibEmC2lagPzpB7rMH5jMebAsm+Bo1W3jkC+lcRTstmCkeTqy6sIr5jnvcqFgfVVOfH4UyNqhXHEl5fWqpUs3N+sW8zOSbbN+0gQ2mnkixNPnNkqeD/VbfRVsuCQP8H0DORApzyZFoBcMNeq0h0cCuEeyVOEfM3oMZW7ZeiFK+FYtndhFf8G+DChBCU9shRua9StZ/1jfXe+Svt 2025-08-05 22:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 22:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 22:50:03 [INFO]: inside itemsold and closed 14409 2025-08-05 22:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 22:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 22:50:05 [INFO]: Ebay item id :: 323937310475 exists in Database 2025-08-05 22:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 22:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 22:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 22:50:05 [INFO]: in processold action queue is array for {"44727493":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44727493","ebayitemid":"323937310475","shopifyproductid":"6634144333991","variants":[{"price":"9.83","quantity":0,"weight":"0.5","shopifyproductid":"6634144333991","shopifyvariantid":"39653169791143","shopifyinventoryid":"41747812024487","shopifylocationid":"","product_id":"44727493","variant_id":"77635371","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 22:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 22:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 22:50:05 [INFO]: Shopify Inventory id 41747812024487 2025-08-05 22:50:05 [INFO]: Shopify Location id 58450641063 2025-08-05 22:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 22:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T22:50:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 22:50:05 [INFO]: Change: available | Delta: -1 2025-08-05 22:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-05 22:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 22:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44727493 and user_id = 14409 2025-08-05 22:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77635371 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 22:50:05 [INFO]: updateIdsQuantity -> ["77635371"] 2025-08-05 22:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 22:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77635371 THEN 0 END, quantityflag = CASE WHEN id = 77635371 THEN 0 END WHERE user_id = 14409 AND id IN (77635371) 2025-08-05 22:50:05 [INFO]: QUANTITY Updated IDs: 77635371 2025-08-05 22:50:05 [INFO]: Successfully processed data for user 14409 2025-08-05 22:50:05 [INFO]: Execution Started 2025-08-05 22:50:05 [INFO]: Execution Finished