2025-08-07 11:00:01 [INFO]: Execution Started 2025-08-07 11:00:01 [INFO]: old server sucessfully connected 2025-08-07 11:00:01 [INFO]: sqs client sucess created 2025-08-07 11:00:04 [INFO]: Number of messages in the queue: 1 2025-08-07 11:00:04 [INFO]: item found in queue is if condition 14409 2025-08-07 11:00:04 [INFO]: item found in queue is 14409 2025-08-07 11:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEByoace5wjKJg5hjdRmeCz99HuZgB6W3nbSKbEUznLBZCtarIBewG0gQzZOvJaE5qkwA+3rksz46G7nbNhSVz1NOiBMEd91QUIIdfnPYO5AjVAr8njnVZP4xrLISl5PfoFI/N5JyP69VidKr3BRL1uaF3hYFLvcMveS4pncUSd6W8zg76dPSMz+t8NHyCei2XpaYYXnzfj4RduJYz5eXRT8dS4/4Ig9ji97msR50s3z/bo3q+DqblSnJINJcgh1aLTZjhXF3U2pxZkNeHxZEiztYFMsPR+N4NmX+RKlYyuNe/noAQULz7Uty9wUS+Qol/Avooml3FDnuihtcioAcgWRhsNuw7q1CungCzHrLXFCxrPwAMLni3rRmAoRVu6fPG3mAGqmvtrXs81Jp3ZW4FS1TUKk4Gp9TZU+WUfW321rOBhahILJ203S2FEOTyrTMDS 2025-08-07 11:00:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 11:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 11:00:05 [INFO]: inside itemsold and closed 14409 2025-08-07 11:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:00:06 [INFO]: Ebay item id :: 305720645743 exists in Database 2025-08-07 11:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:00:06 [INFO]: in processold action queue is array for {"44565390":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44565390","ebayitemid":"305720645743","shopifyproductid":"8699152662750","variants":[{"price":"15.99","quantity":0,"weight":"2","shopifyproductid":"8699152662750","shopifyvariantid":"45943375855838","shopifyinventoryid":"48041866854622","shopifylocationid":"","product_id":"44565390","variant_id":"77458070","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 11:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 11:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:00:06 [INFO]: Shopify Inventory id 48041866854622 2025-08-07 11:00:06 [INFO]: Shopify Location id 58450641063 2025-08-07 11:00:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-07 11:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44565390 and user_id = 14409 2025-08-07 11:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458070 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:00:07 [INFO]: updateIdsQuantity -> ["77458070"] 2025-08-07 11:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 11:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77458070 THEN 0 END, quantityflag = CASE WHEN id = 77458070 THEN 0 END WHERE user_id = 14409 AND id IN (77458070) 2025-08-07 11:00:07 [INFO]: QUANTITY Updated IDs: 77458070 2025-08-07 11:00:07 [INFO]: Successfully processed data for user 14409 2025-08-07 11:00:07 [INFO]: Execution Started 2025-08-07 11:00:07 [INFO]: Execution Finished 2025-08-07 11:10:02 [INFO]: Execution Started 2025-08-07 11:10:02 [INFO]: old server sucessfully connected 2025-08-07 11:10:02 [INFO]: sqs client sucess created 2025-08-07 11:10:04 [INFO]: Number of messages in the queue: 0 2025-08-07 11:10:24 [INFO]: Execution Started 2025-08-07 11:10:24 [INFO]: Execution Finished 2025-08-07 11:20:01 [INFO]: Execution Started 2025-08-07 11:20:01 [INFO]: old server sucessfully connected 2025-08-07 11:20:01 [INFO]: sqs client sucess created 2025-08-07 11:20:04 [INFO]: Number of messages in the queue: 1 2025-08-07 11:20:05 [INFO]: item found in queue is if condition 14409 2025-08-07 11:20:05 [INFO]: item found in queue is 14409 2025-08-07 11:20:06 [INFO]: Message deleted from the queue for receipt handle: AQEBmHFBM/LWkIbho4aaMUFOUC8r1VrS5L/cwlt908eTDUd0hAeIkKz0WpYVFJD7yrYlBgjHuAXAH4VDZOsj7LLGdqUwW78tEYvAmKih6P0nG/JBNLidlsqLkdoVJ+cQ7TWzozH5+d5u5AocRFnp3+NOjkeoG8bhwEnJy9/h9kqhWlWxi9RPBpHXbSLVvlmc+3mVBGLgrFjLHA6dvpiRj1oAYmnhpkc09hKZ2xitlpT3uvPho+88d3PNYhdAVRv5Q8gWbItohXgNCtObKk3oZvho+CM2Y/1+J0s2NUFYEmod6vOVVUFflUk4x4HZurCIHWBGWgeAYNGarsIrE7vwr3taxuTPJF8bfP1XCz1zQVgteJ4CrwFGwT7M84tu0K9nNvB3S2gvtH4SayNzD/5UlUhA6D617dA92DwQbTxwvWVTjUdNAaLbA0DKKpKr2piW0Bt7 2025-08-07 11:20:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 11:20:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 11:20:06 [INFO]: inside itemsold and closed 14409 2025-08-07 11:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:20:08 [INFO]: Ebay item id :: 405121207366 exists in Database 2025-08-07 11:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:20:08 [INFO]: in processold action queue is array for {"44677295":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44677295","ebayitemid":"405121207366","shopifyproductid":"8699166818526","variants":[{"price":"18.99","quantity":0,"weight":"1","shopifyproductid":"8699166818526","shopifyvariantid":"45943409017054","shopifyinventoryid":"48041900507358","shopifylocationid":"","product_id":"44677295","variant_id":"77582515","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 11:20:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 11:20:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:20:08 [INFO]: Shopify Inventory id 48041900507358 2025-08-07 11:20:08 [INFO]: Shopify Location id 58450641063 2025-08-07 11:20:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T11: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-07 11:20:08 [INFO]: Change: available | Delta: -1 2025-08-07 11:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 11:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44677295 and user_id = 14409 2025-08-07 11:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77582515 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:20:08 [INFO]: updateIdsQuantity -> ["77582515"] 2025-08-07 11:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 11:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77582515 THEN 0 END, quantityflag = CASE WHEN id = 77582515 THEN 0 END WHERE user_id = 14409 AND id IN (77582515) 2025-08-07 11:20:08 [INFO]: QUANTITY Updated IDs: 77582515 2025-08-07 11:20:08 [INFO]: Successfully processed data for user 14409 2025-08-07 11:20:08 [INFO]: Execution Started 2025-08-07 11:20:08 [INFO]: Execution Finished 2025-08-07 11:30:01 [INFO]: Execution Started 2025-08-07 11:30:01 [INFO]: old server sucessfully connected 2025-08-07 11:30:01 [INFO]: sqs client sucess created 2025-08-07 11:30:03 [INFO]: Number of messages in the queue: 1 2025-08-07 11:30:03 [INFO]: item found in queue is if condition 14409 2025-08-07 11:30:03 [INFO]: item found in queue is 14409 2025-08-07 11:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBkLmJa3lys0plCCVvTeSsCU4ncYms4hq8e3nZD5qHU+OdKafbBttApQv1J9VwFVZsDZL6DvAbYGApAyEJD2tQz1MrWlST6kguVgJAiR3L+M9JHUAKZhWqYCA4S5r4nhtZdJtzjBY+XMJkcVRxFH/5kzb0mz3+f0sMpGHyakanmWQwUWNzOTuYneJXUzYgIt2Fh1SzK/mBj52RrG2PeRe3p73/9oF6jf/A0/cZA/JxLqRwEbMAPxYCh/uWneWi+X0arqN3cYDfun2lr6E3Eb3/bx0QqIuKRMSg1jk/EwvdEdD2sNJOegSPpj+MH9fWjrhOyeExxG638Tx8qYE6h98GfNkG5HXmGqDdEoao0l3/Ytg3ZtGl/kLpU4SFUtOVvkHKuf+a7uIbw0ttW/qiJTNNTMZ4Kb9OUGj8M4nLbQx8webWaeZQ4MlxG0y7frb+XxDT 2025-08-07 11:30:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 11:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 11:30:04 [INFO]: inside itemsold and closed 14409 2025-08-07 11:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:30:06 [INFO]: Ebay item id :: 256379884764 exists in Database 2025-08-07 11:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:30:06 [INFO]: in processold action queue is array for {"44690191":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44690191","ebayitemid":"256379884764","shopifyproductid":"8255463456990","variants":[{"price":"25.99","quantity":0,"weight":"3","shopifyproductid":"8255463456990","shopifyvariantid":"44679166165214","shopifyinventoryid":"46777125798110","shopifylocationid":"","product_id":"44690191","variant_id":"77595443","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 11:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 11:30:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:30:06 [INFO]: Shopify Inventory id 46777125798110 2025-08-07 11:30:06 [INFO]: Shopify Location id 58450641063 2025-08-07 11:30:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:30:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T11:30:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 11:30:06 [INFO]: Change: available | Delta: -1 2025-08-07 11:30:06 [INFO]: Change: on_hand | Delta: -1 2025-08-07 11:30:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:30:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44690191 and user_id = 14409 2025-08-07 11:30:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77595443 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:30:06 [INFO]: updateIdsQuantity -> ["77595443"] 2025-08-07 11:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 11:30:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77595443 THEN 0 END, quantityflag = CASE WHEN id = 77595443 THEN 0 END WHERE user_id = 14409 AND id IN (77595443) 2025-08-07 11:30:06 [INFO]: QUANTITY Updated IDs: 77595443 2025-08-07 11:30:06 [INFO]: Successfully processed data for user 14409 2025-08-07 11:30:06 [INFO]: Execution Started 2025-08-07 11:30:06 [INFO]: Execution Finished 2025-08-07 11:40:01 [INFO]: Execution Started 2025-08-07 11:40:01 [INFO]: old server sucessfully connected 2025-08-07 11:40:01 [INFO]: sqs client sucess created 2025-08-07 11:40:02 [INFO]: Number of messages in the queue: 2 2025-08-07 11:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 11:40:03 [INFO]: item found in queue is 14409 2025-08-07 11:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBeueqhASuURdDfxPUe5IJSlkHLyCMv5RBs8360bewOtG3SELKuvxcqXRxscogNLN0t6PLSkg9eUuF/Y9FAu3mBPESdjtN6AojQ38PuLHcgSexE6SD1JR1ICQ7ZXqmA4b4cqcOKB83Epqr96K5aoGCQaVFFeIIsit13ascZXVDaL+iQswhukF/+FfQIjGYvN65ElcfR+jClVS9oFkmPAa4N1Ptd1Rtz9/Wu77b4nZPS/xYJLF4neThxlhZyprsTPUFFFcqjXQCET7hXOd7X1uoaFcJBJZYlXUXA4L2X3Wbos7TWAtAfvPI9UfXJFHjG3VnEQfiHt5ZtumdPPlcqEhVAP+M00iFj6n9NjDXW19NqyOe14UElaG77rPAWOBI0gKLJriT1zfQDWG2dLTeB1xasdhKfcy/9FrcdSHD8jtnKM6O0HHiBg1MUvplBmYZ/BmD 2025-08-07 11:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 11:40:03 [INFO]: item found in queue is 14409 2025-08-07 11:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB57kqdYDdiV2H8+KwiC20q758bCWlv2zWrSF03FCujltkHZEvTbQjY0fP0I0yuIGI31KtX1b10hXZjdDxTAwgX8bsh3/cDMYCmlB9I6RMr/0tvYqeDOiHNPKT+l/rn+tDfBhKJ6dvlk1hTlYYhoI49Kq03QhwhqWszLc12EbFbBX80Lsagj6vV6zzT3oWju6UrLQHT105Q8Oq+BKc8WvnsQrLBzoTo+ACz3+IY/ia2oXjZUv4lCAZP8pd1yBOtZKqPCuiWrpcuHrwGbfBJYOD4RmzsTWTBZRQYa7cUC8CYry1eIuCQHoGSEIlgtb6y1RD3YXF5X3sADx2bK5g/Zs3fgjXB1XOOc6hKfWP3dcvJTiAe3OkELtATbld2L+0Q7svrnFCLtupNNFYzRDtK11IwUZOewXI+1DS50E7zEXEk5Zr1gBuyOVi4KitnY1dcoX6 2025-08-07 11:40:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 11:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 11:40:04 [INFO]: inside itemsold and closed 14409 2025-08-07 11:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:40:06 [INFO]: Ebay item id :: 285659539378 exists in Database 2025-08-07 11:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:40:06 [INFO]: inside itemsold and closed 14409 2025-08-07 11:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:40:07 [INFO]: Ebay item id :: 285646379756 exists in Database 2025-08-07 11:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:40:07 [INFO]: in processold action queue is array for {"44656314":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656314","ebayitemid":"285659539378","shopifyproductid":"8256737378526","variants":[{"price":"23.99","quantity":0,"weight":"3","shopifyproductid":"8256737378526","shopifyvariantid":"44682883662046","shopifyinventoryid":"46780844540126","shopifylocationid":"","product_id":"44656314","variant_id":"77561503","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44770443":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44770443","ebayitemid":"285646379756","shopifyproductid":"8091663466718","variants":[{"price":"15.99","quantity":0,"weight":"2","shopifyproductid":"8091663466718","shopifyvariantid":"44276403306718","shopifyinventoryid":"46373570183390","shopifylocationid":"","product_id":"44770443","variant_id":"77678985","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 11:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 11:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:40:07 [INFO]: Shopify Inventory id 46780844540126 2025-08-07 11:40:07 [INFO]: Shopify Location id 58450641063 2025-08-07 11:40:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T11:40: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-07 11:40:08 [INFO]: Change: available | Delta: -1 2025-08-07 11:40:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 11:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656314 and user_id = 14409 2025-08-07 11:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561503 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:40:08 [INFO]: Shopify Inventory id 46373570183390 2025-08-07 11:40:08 [INFO]: Shopify Location id 58450641063 2025-08-07 11:40:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T11:40: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-07 11:40:08 [INFO]: Change: available | Delta: -1 2025-08-07 11:40:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 11:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44770443 and user_id = 14409 2025-08-07 11:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77678985 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:40:08 [INFO]: updateIdsQuantity -> ["77561503","77678985"] 2025-08-07 11:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 11:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561503 THEN 0 WHEN id = 77678985 THEN 0 END, quantityflag = CASE WHEN id = 77561503 THEN 0 WHEN id = 77678985 THEN 0 END WHERE user_id = 14409 AND id IN (77561503,77678985) 2025-08-07 11:40:08 [INFO]: QUANTITY Updated IDs: 77561503, 77678985 2025-08-07 11:40:08 [INFO]: Successfully processed data for user 14409 2025-08-07 11:40:08 [INFO]: Execution Started 2025-08-07 11:40:08 [INFO]: Execution Finished 2025-08-07 11:50:01 [INFO]: Execution Started 2025-08-07 11:50:01 [INFO]: old server sucessfully connected 2025-08-07 11:50:01 [INFO]: sqs client sucess created 2025-08-07 11:50:02 [INFO]: Number of messages in the queue: 2 2025-08-07 11:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 11:50:03 [INFO]: item found in queue is 14409 2025-08-07 11:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBdDdUu6LWGwQ3c2nVVvXd2EWbuw0lfzmXxvOYIwUZVfQazPd2WPtyKKZNXWxqVt3tPbHvPip8SqDjxW3zFVNdTnfN6Vz4GWQV6MBEWTd8Zq+JscT3zPbsTTkZKITVRtbu9K709omC+DytEB2Galldi5Yd/r2v4l773kQf7D4fXsbxSVkbUEogOC+v2RZJlsCKUiMR/u1NomJAKjttG4oJtGIhDzrD09oRH67Uvjp5r/UReDALGbVDEJ7OtHLMvcX9ZbF+4ADv0U+zji6JBQbBdjbnssB6etSWhy9Ki2XRO7mLFmxuzigu8mk2PQuGsEeK6DeNqe2j7gyJCspyg/CFI7HB7S9sFaaiBqTTSuNXAbwM5K/iVNwUwTCdopPWK99WqOm2dAbcITdL0AQCohQpIVKykrIbf/ORwS8iFIdAqy5F1JwMU34BL/NQX5ru0D+o 2025-08-07 11:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 11:50:03 [INFO]: item found in queue is 14409 2025-08-07 11:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBjqujnT/7mrsEkokeTV9M7M3AJknRjZeC7NFhll9zTct7I4OrzQugwaD6Um9fZzZM1H6SwqY8mSNDuiAjd5ngbjdNvdGibCGNipAwNjfb/Ef83+A9GHtkOT+SU4SB1rHRa/Pt/Eu37YoyZvquDwzVmZxDu3yFE4erxJWvw8YQks52+tRXvW08KJ4n35awfdeavoDKuf6Ufl4nGtAAeacYi8yvJrxJ5oUC16X8/+ZkGBFLNXpvGVnAGyq+GRAMh2sl60RAfUf35C1UbJPnQ3BPyrg0wl72dlFAIN6lwT7daKqOTchECi4jUMP2g1NWFWDEchCq8L+K3hpNO9ESIu+OT/FTCpiVy0Iog2YBWYdkhZ8xqBGUNzu/0BdIGOL0CcDds83d4jhJTEcFOI+v0Nbnb1I2E/YNB3AJCGoueVxFbCBpIfKh+oTm4io/O76fWTqz 2025-08-07 11:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-07 11:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 11:50:04 [INFO]: inside itemsold and closed 14409 2025-08-07 11:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:50:05 [INFO]: Ebay item id :: 285688306884 exists in Database 2025-08-07 11:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:50:05 [INFO]: inside itemsold and closed 14409 2025-08-07 11:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 11:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 11:50:07 [INFO]: Ebay item id :: 404788410528 exists in Database 2025-08-07 11:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 11:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 11:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 11:50:07 [INFO]: in processold action queue is array for {"44771446":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771446","ebayitemid":"285688306884","shopifyproductid":"8694945284318","variants":[{"price":"222.99","quantity":0,"weight":"4","shopifyproductid":"8694945284318","shopifyvariantid":"45933620953310","shopifyinventoryid":"48032072138974","shopifylocationid":"","product_id":"44771446","variant_id":"77679988","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771581":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771581","ebayitemid":"404788410528","shopifyproductid":"8696101273822","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8696101273822","shopifyvariantid":"45936207560926","shopifyinventoryid":"48034656518366","shopifylocationid":"","product_id":"44771581","variant_id":"77680123","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 11:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 11:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 11:50:07 [INFO]: Shopify Inventory id 48032072138974 2025-08-07 11:50:07 [INFO]: Shopify Location id 58450641063 2025-08-07 11:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T11: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-07 11:50:08 [INFO]: Change: available | Delta: -1 2025-08-07 11:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 11:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771446 and user_id = 14409 2025-08-07 11:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77679988 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:50:08 [INFO]: Shopify Inventory id 48034656518366 2025-08-07 11:50:08 [INFO]: Shopify Location id 58450641063 2025-08-07 11:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 11:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T11:50: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-07 11:50:08 [INFO]: Change: available | Delta: -1 2025-08-07 11:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-07 11:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 11:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771581 and user_id = 14409 2025-08-07 11:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680123 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 11:50:08 [INFO]: updateIdsQuantity -> ["77679988","77680123"] 2025-08-07 11:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 11:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77679988 THEN 0 WHEN id = 77680123 THEN 0 END, quantityflag = CASE WHEN id = 77679988 THEN 0 WHEN id = 77680123 THEN 0 END WHERE user_id = 14409 AND id IN (77679988,77680123) 2025-08-07 11:50:08 [INFO]: QUANTITY Updated IDs: 77679988, 77680123 2025-08-07 11:50:08 [INFO]: Successfully processed data for user 14409 2025-08-07 11:50:08 [INFO]: Execution Started 2025-08-07 11:50:08 [INFO]: Execution Finished