2025-08-02 10:00:01 [INFO]: Execution Started 2025-08-02 10:00:01 [INFO]: old server sucessfully connected 2025-08-02 10:00:02 [INFO]: sqs client sucess created 2025-08-02 10:00:03 [INFO]: Number of messages in the queue: 1 2025-08-02 10:00:03 [INFO]: item found in queue is if condition 14409 2025-08-02 10:00:03 [INFO]: item found in queue is 14409 2025-08-02 10:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmvbPKKZDrEhKVyU3nnGjFziqDpbYMa6wkQV8E7yblyFWEa5kIbrA0Ry6cYEzVNiCpdvtipF+1NSCdzd94DpCr26CSOyAWgO8Fad6YFDOd3vqw9LYHbstdq96V8jhN4WHA4qNNHCfghWLC0t276MJzsbBZD/mAU5VGPBi2P6wo1DD+JmWSbLKO7Ijc2Hq4DzTxnFo9HQvxKog6NAYa6SK/2DHhIjfl388rXRnZA4oHZ4y72ILVla8PpLkRw/2a6ArlY3RbQxZgqvsNFzUZLnyAB0MKrWSjJbjgAgdTi+hkoYvPaESxU2tBE5nv9YbLYOrKKOfBbmeYbiC0MJRTzd7T728u1OcW7xbNGxuDN+0tw9rs70ThhEvGrxSaOd94/AscfTp8k/TS6NpDjbrCgNSSfW/vTDwpTOHJK+JO5gk76m9g/pHG1TOShf0y7wPyTDf 2025-08-02 10:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-02 10:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-02 10:00:03 [INFO]: inside itemsold and closed 14409 2025-08-02 10:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:00:05 [INFO]: Ebay item id :: 256444433751 exists in Database 2025-08-02 10:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:00:05 [INFO]: in processold action queue is array for {"44637689":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44637689","ebayitemid":"256444433751","shopifyproductid":"8315882307806","variants":[{"price":"55.99","quantity":0,"weight":"2","shopifyproductid":"8315882307806","shopifyvariantid":"44892178415838","shopifyinventoryid":"46989961527518","shopifylocationid":"","product_id":"44637689","variant_id":"77542878","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-02 10:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-02 10:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:00:05 [INFO]: Shopify Inventory id 46989961527518 2025-08-02 10:00:05 [INFO]: Shopify Location id 58450641063 2025-08-02 10:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:00: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-02 10:00:06 [INFO]: Change: available | Delta: -1 2025-08-02 10:00:06 [INFO]: Change: on_hand | Delta: -1 2025-08-02 10:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44637689 and user_id = 14409 2025-08-02 10:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77542878 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:00:06 [INFO]: updateIdsQuantity -> ["77542878"] 2025-08-02 10:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-02 10:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77542878 THEN 0 END, quantityflag = CASE WHEN id = 77542878 THEN 0 END WHERE user_id = 14409 AND id IN (77542878) 2025-08-02 10:00:06 [INFO]: QUANTITY Updated IDs: 77542878 2025-08-02 10:00:06 [INFO]: Successfully processed data for user 14409 2025-08-02 10:00:06 [INFO]: Execution Started 2025-08-02 10:00:06 [INFO]: Execution Finished 2025-08-02 10:10:01 [INFO]: Execution Started 2025-08-02 10:10:01 [INFO]: old server sucessfully connected 2025-08-02 10:10:01 [INFO]: sqs client sucess created 2025-08-02 10:10:02 [INFO]: Number of messages in the queue: 3 2025-08-02 10:10:03 [INFO]: item found in queue is if condition 14409 2025-08-02 10:10:03 [INFO]: item found in queue is 14409 2025-08-02 10:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlfKYbAWvThIHxD9edtmzZDpH0bxATrKkDtnpsz0dRP5hs+nQFImg4l4bE4Z/WjsAKhMUGuLYdol89xHL0li7KVBXtouX49Ph4cwSplybnlYOVmTZL4R8Cve2GXJK8DpqJRLvzRZylsFE3kyV5Lgrx7VrZnbi8tegfugqQPe+YMYrWPB7WUeT3v+BGtFG8A+9j6V3XJbOhCTpW6Qm/jLIawikkkq/107541EKxMB2h+0E8odYZlXXTV3oXDz651reB+7rRSc7+XGtqT0zWjn/zoVY8mDKKRrdBeQp//3AfuhmmMU/JMnrvshz6ypYU10E14HqNwck1LsicYaZZcCZRezY4W9A8lSOScXOqcHixLMRAyL3YT6d196cyh1trDo5FQiqHz4QrvldGAw0ocIQ+zAElT4elOKxK8Tzoxw29+gRaC9kX5Bk4OlefnAq7UW1 2025-08-02 10:10:03 [INFO]: item found in queue is if condition 14409 2025-08-02 10:10:03 [INFO]: item found in queue is 14409 2025-08-02 10:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBkn+72yaCzqfotRXqDSygy41n1nuUhpVoM+3KdCQKGqOTlbdDhtHMIybyoPllVf2I+ON6HkUjxS3wDFBheYJC7NCulWYxoKHqq58SabrthJZfTJ1xb3DkO5Tj8gPqN1Kzgur/TJRuGNt4+dU1mkQGTiV1a2PkeNZuxU6o64ja71j7Ux+cUZ96YNyuwlcTREbbhW/n3G4zFIMeyo8XRWtoOPRjJpl5FpzAM+ww17Le0syA3CKAjdGqS13CkxdaurTfPwyW7L31/jEvUP/KfcDO8Ou8luEaEe0/x/2JHwLx0s9vjRiU/t83v2Gr1xt68uPapNqHOPTVg1uSIuENrq/oDX+kr0g9cgYw86f6xv73PY9WjpCemdZGlhOxizATEOsVY5q3cbFpS41S+taBTUMOoK8c3WuCruXdXWOB6f8aVCqE6Gb5w8txQUdzYqBU+Vqn 2025-08-02 10:10:04 [INFO]: item found in queue is if condition 14409 2025-08-02 10:10:04 [INFO]: item found in queue is 14409 2025-08-02 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB8ywQyLWsibgfbboCEcL5CThJIOTReiAlJTPyacgciYepgZWxb9t0hyLOa72E6eVM3Nz8BOH1wk+xfErz3Pq8of14bY12K17QtHo3j3EvNY6JelehIU59zz77Ic0m77GHLuXDpoP3GLB5+hFC+RkUU1Z5ePLFdAgKJ6jLGwUUhDhCiNl0Nt3zPqBA08oGY2EO927jqyj7A9ONQ/rznOQSFBf/xs2h3VKPAp/EN0yUoAa1bjgaXyLOQHNG0AleERY64AXkQDpXNcmIWCACwAu+Fc2EHACdpCx/h1Uk4h76vWWvc3eiHKPII8ZUyuL6O0ng2aZyzLrFJRGsNwdi+xNHNnqbtPBTFybCcLU8dDU1Eqf1bQuKDZEdxIGRU7v1bcCHanhLghv/fAQdet6uYU1jANTQy2SQWPFbn4xh0p5eKqQKMkQVgbQTkFLErtfrNAAx 2025-08-02 10:10:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-02 10:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-02 10:10:04 [INFO]: inside itemsold and closed 14409 2025-08-02 10:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:10:06 [INFO]: Ebay item id :: 404860389981 exists in Database 2025-08-02 10:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:10:06 [INFO]: inside itemsold and closed 14409 2025-08-02 10:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:10:08 [INFO]: Ebay item id :: 256445605031 exists in Database 2025-08-02 10:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:10:08 [INFO]: inside itemsold and closed 14409 2025-08-02 10:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:10:09 [INFO]: Ebay item id :: 256446694894 exists in Database 2025-08-02 10:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:10:09 [INFO]: in processold action queue is array for {"44642582":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642582","ebayitemid":"404860389981","shopifyproductid":"8318938546398","variants":[{"price":"129.99","quantity":0,"weight":"2","shopifyproductid":"8318938546398","shopifyvariantid":"44906655842526","shopifyinventoryid":"47004432335070","shopifylocationid":"","product_id":"44642582","variant_id":"77547771","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44642015":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642015","ebayitemid":"256445605031","shopifyproductid":"8318627053790","variants":[{"price":"177.99","quantity":0,"weight":"2","shopifyproductid":"8318627053790","shopifyvariantid":"44903882064094","shopifyinventoryid":"47001660391646","shopifylocationid":"","product_id":"44642015","variant_id":"77547204","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44644594":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644594","ebayitemid":"256446694894","shopifyproductid":"8920503845086","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8920503845086","shopifyvariantid":"46781244375262","shopifyinventoryid":"48879758409950","shopifylocationid":"58450641063","product_id":"44644594","variant_id":"77549783","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-02 10:10:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-02 10:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:10:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:10:10 [INFO]: Shopify Inventory id 47004432335070 2025-08-02 10:10:10 [INFO]: Shopify Location id 58450641063 2025-08-02 10:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:10: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-02 10:10:10 [INFO]: Change: available | Delta: -1 2025-08-02 10:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-02 10:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642582 and user_id = 14409 2025-08-02 10:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547771 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:10:10 [INFO]: Shopify Inventory id 47001660391646 2025-08-02 10:10:10 [INFO]: Shopify Location id 58450641063 2025-08-02 10:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:10: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-02 10:10:10 [INFO]: Change: available | Delta: -1 2025-08-02 10:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-02 10:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642015 and user_id = 14409 2025-08-02 10:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547204 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:10:10 [INFO]: Shopify Inventory id 48879758409950 2025-08-02 10:10:10 [INFO]: Shopify Location id 58450641063 2025-08-02 10:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:10: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-02 10:10:10 [INFO]: Change: available | Delta: -2 2025-08-02 10:10:10 [INFO]: Change: on_hand | Delta: -2 2025-08-02 10:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644594 and user_id = 14409 2025-08-02 10:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549783 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:10:10 [INFO]: updateIdsQuantity -> ["77547771","77547204","77549783"] 2025-08-02 10:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-02 10:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77547771 THEN 0 WHEN id = 77547204 THEN 0 WHEN id = 77549783 THEN 0 END, quantityflag = CASE WHEN id = 77547771 THEN 0 WHEN id = 77547204 THEN 0 WHEN id = 77549783 THEN 0 END WHERE user_id = 14409 AND id IN (77547771,77547204,77549783) 2025-08-02 10:10:10 [INFO]: QUANTITY Updated IDs: 77547771, 77547204, 77549783 2025-08-02 10:10:10 [INFO]: Successfully processed data for user 14409 2025-08-02 10:10:10 [INFO]: Execution Started 2025-08-02 10:10:10 [INFO]: Execution Finished 2025-08-02 10:20:01 [INFO]: Execution Started 2025-08-02 10:20:01 [INFO]: old server sucessfully connected 2025-08-02 10:20:01 [INFO]: sqs client sucess created 2025-08-02 10:20:03 [INFO]: Number of messages in the queue: 1 2025-08-02 10:20:03 [INFO]: item found in queue is if condition 14409 2025-08-02 10:20:03 [INFO]: item found in queue is 14409 2025-08-02 10:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPcxMouCAaTsL26kfkR3iVBmNbf+jAHPmGIHyVa49GOPeTcVT5Eo2cqktBffx6nkfPkQg8tLhDFXwDhrxVtYstTAs6ievd2L8FdSoR5WgGA/m/cNx/CJUSkr1XBt21cYgvJKhLnh7ctO9WSwYy1fhlLa7GzrnLT8NKDnNJqZth6aEjOA2UiLLSLaU1EAIadeHV1Jivkna2v68jEfsWJ7qNyj7BmaQdgqL0YF7AsTLEsG2lXsZdtGpJAehXrNofSo/bLMrT3t6fGQ9+wkqrHjiqAHsNxsAzFXypHpTYwKvjpQxDHinIkmZ55GZvtPEFjZVs+t5AqoDN/EjSkfjefPdaaTVljgnriBAqRaWiScJbayDPj1/fe4XiEwovrvjedutG/Uy7/2JckApNxjcEutLuKX5AQlEFSynbj+1rNg+4fd4VKLyLvWt9+Cy9wOzHIxa 2025-08-02 10:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-02 10:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-02 10:20:03 [INFO]: inside itemsold and closed 14409 2025-08-02 10:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:20:05 [INFO]: Ebay item id :: 285772555812 exists in Database 2025-08-02 10:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:20:05 [INFO]: in processold action queue is array for {"44656742":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656742","ebayitemid":"285772555812","shopifyproductid":"8072263663838","variants":[{"price":"149.99","quantity":0,"weight":"2","shopifyproductid":"8072263663838","shopifyvariantid":"44246981279966","shopifyinventoryid":"46344130625758","shopifylocationid":"","product_id":"44656742","variant_id":"77561962","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-02 10:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-02 10:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:20:05 [INFO]: Shopify Inventory id 46344130625758 2025-08-02 10:20:05 [INFO]: Shopify Location id 58450641063 2025-08-02 10:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:20: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-02 10:20:05 [INFO]: Change: available | Delta: -1 2025-08-02 10:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-02 10:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656742 and user_id = 14409 2025-08-02 10:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561962 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:20:05 [INFO]: updateIdsQuantity -> ["77561962"] 2025-08-02 10:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-02 10:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561962 THEN 0 END, quantityflag = CASE WHEN id = 77561962 THEN 0 END WHERE user_id = 14409 AND id IN (77561962) 2025-08-02 10:20:05 [INFO]: QUANTITY Updated IDs: 77561962 2025-08-02 10:20:05 [INFO]: Successfully processed data for user 14409 2025-08-02 10:20:05 [INFO]: Execution Started 2025-08-02 10:20:05 [INFO]: Execution Finished 2025-08-02 10:30:02 [INFO]: Execution Started 2025-08-02 10:30:02 [INFO]: old server sucessfully connected 2025-08-02 10:30:02 [INFO]: sqs client sucess created 2025-08-02 10:30:03 [INFO]: Number of messages in the queue: 2 2025-08-02 10:30:03 [INFO]: item found in queue is if condition 14409 2025-08-02 10:30:03 [INFO]: item found in queue is 14409 2025-08-02 10:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBTaKFFFSdauViLcjXzzBh2OBsbHoUNLhSAkaIg3HskZEU6/d2yip8k3WHfN2yiUrXrVAF1FQ42JgPG0wa4BC80oDHcpn3rXGw0Rnb69l0ObL+2tMLDN+GvSwVV7WBshuWocraI8W9tYVO4JQFL5bkTeuqQNRmOQNfJ9Z6bBycaO7iECS81AbUJporlWuxNHX8MXcTSyrZdw2/a1j7VsDiDVBSEbKiSd/kTHOE1MkEdkI6/Bkqlw2B+ZBCv7+0D5WfkthHbpNIPQzW4gA4p2JSlKt48oK4HbPTNnbCzTgG3Cp2mSSNL83gsn+JpQ8uSYqtJfDY7mLbDc3BAuCspBnpc7Jv84JyWGWhlY5ktkY/X49dX4ndkCblaBWp03fUvOOpc4AcVD4Sq/QVOgL/11jTiYK/jOc3jSuK7XEuhZ3Tz9Ve1PHHFBDGcOCrog83BXmM 2025-08-02 10:30:04 [INFO]: item found in queue is if condition 14409 2025-08-02 10:30:04 [INFO]: item found in queue is 14409 2025-08-02 10:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEByoiK2FyVO0zcahmc2FzkZQHGqXs5XHi6E0YfR6g/l41dqr5Ds7QjdqhMU/1rD24Ba+K+CT4bG0dOYfKtGdPNSiA6aZwcEPaXlDX9VsmTtc6Mv2icyto0zri2Ot0kCldHXt+5dOis6vT+DmsDDHp3/f06Rc1QZ5a/gwM/s+tC6iuYAkfhBJr9FAUF/rUFpV+3GsqAtuFjN/DDIFcKI8aDHRy+vy1KXi3G2JAGP9Q48VoJmZCuuZxeLJa520GZJGiE8sf4JOExBIoBgsmGWwUCaKZjAIvfJJeYjVDLdudGM4FLIE9S42B3zYuFky6Qyc+JEr83G28aLoDzzycTDeHF2OazTHX1MCF9EW4osc0M4R0NOf1v82JiJ37ui0BXMKUsoSHWDZJn9ORiRzGaqd6s70wPmvTHfP7G1Xe1GLlRR80uRAjEEPVMB6J4BnPmFRVQ 2025-08-02 10:30:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-02 10:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-02 10:30:04 [INFO]: inside itemsold and closed 14409 2025-08-02 10:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:30:06 [INFO]: Ebay item id :: 326415808083 exists in Database 2025-08-02 10:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:30:06 [INFO]: inside itemsold and closed 14409 2025-08-02 10:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-02 10:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-02 10:30:07 [INFO]: Ebay item id :: 256453715794 exists in Database 2025-08-02 10:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-02 10:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-02 10:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-02 10:30:07 [INFO]: in processold action queue is array for {"44671107":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44671107","ebayitemid":"326415808083","shopifyproductid":"8797864001758","variants":[{"price":"29.99","quantity":0,"weight":"0.75","shopifyproductid":"8797864001758","shopifyvariantid":"46240499499230","shopifyinventoryid":"48340935770334","shopifylocationid":"","product_id":"44671107","variant_id":"77576327","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44665130":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44665130","ebayitemid":"256453715794","shopifyproductid":"8334436335838","variants":[{"price":"41.99","quantity":0,"weight":"2","shopifyproductid":"8334436335838","shopifyvariantid":"44958662099166","shopifyinventoryid":"47056445767902","shopifylocationid":"","product_id":"44665130","variant_id":"77570350","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-02 10:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-02 10:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-02 10:30:07 [INFO]: Shopify Inventory id 48340935770334 2025-08-02 10:30:07 [INFO]: Shopify Location id 58450641063 2025-08-02 10:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:30: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-02 10:30:08 [INFO]: Change: available | Delta: -1 2025-08-02 10:30:08 [INFO]: Change: on_hand | Delta: -1 2025-08-02 10:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44671107 and user_id = 14409 2025-08-02 10:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576327 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:30:08 [INFO]: Shopify Inventory id 47056445767902 2025-08-02 10:30:08 [INFO]: Shopify Location id 58450641063 2025-08-02 10:30:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-02 10:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-02T10:30: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-02 10:30:08 [INFO]: Change: available | Delta: -1 2025-08-02 10:30:08 [INFO]: Change: on_hand | Delta: -1 2025-08-02 10:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-02 10:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44665130 and user_id = 14409 2025-08-02 10:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77570350 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-02 10:30:08 [INFO]: updateIdsQuantity -> ["77576327","77570350"] 2025-08-02 10:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-02 10:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77576327 THEN 0 WHEN id = 77570350 THEN 0 END, quantityflag = CASE WHEN id = 77576327 THEN 0 WHEN id = 77570350 THEN 0 END WHERE user_id = 14409 AND id IN (77576327,77570350) 2025-08-02 10:30:08 [INFO]: QUANTITY Updated IDs: 77576327, 77570350 2025-08-02 10:30:08 [INFO]: Successfully processed data for user 14409 2025-08-02 10:30:08 [INFO]: Execution Started 2025-08-02 10:30:08 [INFO]: Execution Finished 2025-08-02 10:40:02 [INFO]: Execution Started 2025-08-02 10:40:02 [INFO]: old server sucessfully connected 2025-08-02 10:40:02 [INFO]: sqs client sucess created 2025-08-02 10:40:03 [INFO]: Number of messages in the queue: 0 2025-08-02 10:40:23 [INFO]: Execution Started 2025-08-02 10:40:23 [INFO]: Execution Finished 2025-08-02 10:50:01 [INFO]: Execution Started 2025-08-02 10:50:01 [INFO]: old server sucessfully connected 2025-08-02 10:50:01 [INFO]: sqs client sucess created 2025-08-02 10:50:02 [INFO]: Number of messages in the queue: 0 2025-08-02 10:50:23 [INFO]: Execution Started 2025-08-02 10:50:23 [INFO]: Execution Finished