2025-08-12 20:00:02 [INFO]: Execution Started 2025-08-12 20:00:02 [INFO]: old server sucessfully connected 2025-08-12 20:00:02 [INFO]: sqs client sucess created 2025-08-12 20:00:03 [INFO]: Number of messages in the queue: 1 2025-08-12 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:00:03 [INFO]: item found in queue is 14409 2025-08-12 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQgHrGHlS41F3/u9l4WYPBkfw0KpTDBZIjtvvUI4mszzLKE1lZ4EGIjLfhR1ZeetRs1aTVh1HtR2v1xSHp89+PNksCtVQsEKhOqFwaE/qZLRDVGA/tERHJgiz55cMsqzwKs3HdXe98jJ3GJIYR0dCUgtOVDitW4OvA86OVRh2XhCM5eD6lFFTUEHLMNFNm+W4ohUFtImJ960JH9Xj2v1qcKiId0uyhO3x0AX0MOJ/F6uuLmBUSG8ZGVbobert5mObCKoADhLpgfWRWg0j6eCkzmnaWAhm0ubSMjhGMQh9gOB3lnRWcuR019DgdpKpRBLE6c1awcNPOM5ertkzZmt4QeXaIQkw4fD6pQboUbao3kdyrh84phOOSG+LxoeY2n3RPWLgBWPNqysHZEHcVLX2dUiKDpyxHNe4xd7oSlLEgrL1sNNxw4LkMNgLJQclkEAW 2025-08-12 20:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 20:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 20:00:03 [INFO]: inside itemsold and closed 14409 2025-08-12 20:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:00:05 [INFO]: Ebay item id :: 335694528222 exists in Database 2025-08-12 20:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:00:05 [INFO]: in processold action queue is array for {"44590404":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44590404","ebayitemid":"335694528222","shopifyproductid":"8747604508894","variants":[{"price":"26.99","quantity":0,"weight":"2","shopifyproductid":"8747604508894","shopifyvariantid":"46108240478430","shopifyinventoryid":"48207177416926","shopifylocationid":"","product_id":"44590404","variant_id":"77483113","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 20:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 20:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:00:05 [INFO]: Shopify Inventory id 48207177416926 2025-08-12 20:00:05 [INFO]: Shopify Location id 58450641063 2025-08-12 20:00:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20: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-12 20:00:05 [INFO]: Change: available | Delta: -1 2025-08-12 20:00:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44590404 and user_id = 14409 2025-08-12 20:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77483113 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:00:05 [INFO]: updateIdsQuantity -> ["77483113"] 2025-08-12 20:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 20:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77483113 THEN 0 END, quantityflag = CASE WHEN id = 77483113 THEN 0 END WHERE user_id = 14409 AND id IN (77483113) 2025-08-12 20:00:05 [INFO]: QUANTITY Updated IDs: 77483113 2025-08-12 20:00:05 [INFO]: Successfully processed data for user 14409 2025-08-12 20:00:05 [INFO]: Execution Started 2025-08-12 20:00:05 [INFO]: Execution Finished 2025-08-12 20:10:02 [INFO]: Execution Started 2025-08-12 20:10:02 [INFO]: old server sucessfully connected 2025-08-12 20:10:02 [INFO]: sqs client sucess created 2025-08-12 20:10:03 [INFO]: Number of messages in the queue: 1 2025-08-12 20:10:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:10:03 [INFO]: item found in queue is 14409 2025-08-12 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBso3M6R4ayqpqXHDyNgpQRUvJ2TurfrzPI5tgapE+k7bh9KWFUTjiwgORXh3kCxi8NT9za14b0cmYRds7DTBsoLFjcaMtb3G1GIu6qlAA9VVgWPxK9mCFOq4Skac6zkYfbJ5AzeNnJwzktLIwsTfLsliA0lrN7mXF6j/yvRMx+haDstUsUlnOlTcTEVIKpzIZ+JX9Sq69KcmG0bY+D+48urCXV9ZlXYZ/bLwjNAGr9ndk8PtWfGZ8pRh2UHWi0HqvfvII1eWZ+/04RqbdU6JiGOwElOs9LfnC9jSTqHMrPp+BrNqZs9FPmd8xS3woupzNYP6rhBpxDrYTx5UepBLuVY2p6SuNiu5urEQc8mW1STvucvxZw2UrOH8PPdSRDDY+qOHbP7mwnjPe9W9sUI61vnme83gpcLkEd3Ajm1GYWcEDHJe2LldotmeRphvWwm1n 2025-08-12 20:10:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 20:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 20:10:03 [INFO]: inside itemsold and closed 14409 2025-08-12 20:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:10:05 [INFO]: Ebay item id :: 335656900268 exists in Database 2025-08-12 20:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:10:05 [INFO]: in processold action queue is array for {"44558699":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44558699","ebayitemid":"335656900268","shopifyproductid":"8725583495390","variants":[{"price":"26.99","quantity":0,"weight":"2","shopifyproductid":"8725583495390","shopifyvariantid":"46011528511710","shopifyinventoryid":"48110013808862","shopifylocationid":"","product_id":"44558699","variant_id":"77451379","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 20:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 20:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:10:05 [INFO]: Shopify Inventory id 48110013808862 2025-08-12 20:10:05 [INFO]: Shopify Location id 58450641063 2025-08-12 20:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20:10: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-12 20:10:05 [INFO]: Change: available | Delta: -1 2025-08-12 20:10:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44558699 and user_id = 14409 2025-08-12 20:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77451379 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:10:05 [INFO]: updateIdsQuantity -> ["77451379"] 2025-08-12 20:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 20:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77451379 THEN 0 END, quantityflag = CASE WHEN id = 77451379 THEN 0 END WHERE user_id = 14409 AND id IN (77451379) 2025-08-12 20:10:05 [INFO]: QUANTITY Updated IDs: 77451379 2025-08-12 20:10:05 [INFO]: Successfully processed data for user 14409 2025-08-12 20:10:05 [INFO]: Execution Started 2025-08-12 20:10:05 [INFO]: Execution Finished 2025-08-12 20:20:01 [INFO]: Execution Started 2025-08-12 20:20:01 [INFO]: old server sucessfully connected 2025-08-12 20:20:01 [INFO]: sqs client sucess created 2025-08-12 20:20:03 [INFO]: Number of messages in the queue: 3 2025-08-12 20:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:20:03 [INFO]: item found in queue is 14409 2025-08-12 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBOHJXKb8Xi/TW5v4zQiEQ0COhZjOkRgYnIB1zvc5v95fbR2k+u6V+HyZ0Y9y8XGGxymGpdjpeon0gFHz2cHBIVCcBFYXcCrCMG+UtsNHDD3rTt0m0m7iXcLTEgQEpQBPGKYB3mSEP9MvLSWvCXtuHcytsfN4bY3hdJpSSUIO9klbeOroYDo0Bz6zQhOg8Kbd2TDu4Jc8tmx3Uxj0+cQS/WgdW9s4aHzZLUvUtLF/ze65iXIrdvyIHisiYL9pn6pMK8xYocHuPoGWaaZBWf8g0a2t7ozorNYq1IXLXb2ZJFXvR5dyWtIasBkArcazz22C7K3gTolrc2xcjwaGaY7yHMLd4S1So8K358kw7Yd16GpEKHWO1Qb4aAihEKrXDlxl21tYf1qb74q60/gJji58xcMzf0VBDf5GhinaQdqn6MwXEv6n6cF8nX4p6G6rKojRD 2025-08-12 20:20:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:20:03 [INFO]: item found in queue is 14409 2025-08-12 20:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBtpdzz0jtt7QXZr78hSrZV23YTNi56bzw2y/nuzB50O4/lu4OM/xBuIX74yUxX9RZ+MHyySMDSn9pVo+pKPlemCKFpmuMh5m6ICCshGUiO4XYgGttAMTii1h1mUQpVRlQlUh4mFDPeTrdAIUAneDBEgbPcPK9T2xTcjm6XqSwLtAMkviD3apzmrlqbNZjQjjB43LYq1cQdlmWF5dqPsfkyQYH3OkDwAjB/THvQI07TV2BrtLMP+V5qMMdzZypsdWW0esm4yYlOnxKm4it7LhSoywRNWNkFpAU/2kmmEoCnt96m5OCnHbXqWHEdDbL7y/sf0E7SDHV+ZZIY1kVBiWn32BlIl2NMD8Y0ubJ6zsCr+iey9w+AFJxsdJHfkVBiBCr/djGN+og9zSb3bnIdkSpbTnQpFDVzM4vdZAKW3dghUsQ7qd5oGh88egGWE3S/5gt 2025-08-12 20:20:04 [INFO]: item found in queue is if condition 14409 2025-08-12 20:20:04 [INFO]: item found in queue is 14409 2025-08-12 20:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBAf7cB0wL9Z7rv/0GaOEGa6uInDBxf6XjZFMHGZLZKHK5hafuX2NQxIvI67fIT6euaaBGppb+GRwKab2y2kU8EZnBw8dyyH64Lm4qxpOSzY/4pD4LHD6AJSgK2S8QB7otkdkh6LAgjDoQhor2p02mUN+Yjz1eFby0TVFqH12bJGIcVJ+npFvA38LnDii+gRWoAovegKQpaEPwB3TbtuwZNU3+IxVMTS5ElZRiqAcnDJVuVdF+g151zSljIdcDobZ5oNdXL2yMNoYWFIRMbH/DdA8zLK/wjsiVrBG26w5FrsvLx7jwfEjS+ccNb1LuvGUsFDhdSxF08KGFWIAFYz74xT1zWgyuwSPXkt6jHytnlu7wPmKr4kJHdMr2oyeNtU9bdKWU8rv7HEzLYZPrDdI0FuieqrFtV2nzcIEiYqjQEL1OoIYB/Cj+HpSdVjX1Cmd8 2025-08-12 20:20:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 20:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 20:20:04 [INFO]: inside itemsold and closed 14409 2025-08-12 20:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:20:06 [INFO]: Ebay item id :: 335674495987 exists in Database 2025-08-12 20:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:20:06 [INFO]: inside itemsold and closed 14409 2025-08-12 20:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:20:08 [INFO]: Ebay item id :: 335674500329 exists in Database 2025-08-12 20:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:20:08 [INFO]: inside itemsold and closed 14409 2025-08-12 20:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:20:09 [INFO]: Ebay item id :: 305852146924 exists in Database 2025-08-12 20:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:20:09 [INFO]: in processold action queue is array for {"44572692":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572692","ebayitemid":"335674495987","shopifyproductid":"8038467436766","variants":[{"price":"22.99","quantity":0,"weight":"2","shopifyproductid":"8038467436766","shopifyvariantid":"44184129274078","shopifyinventoryid":"46281168290014","shopifylocationid":"","product_id":"44572692","variant_id":"77465376","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572698":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572698","ebayitemid":"335674500329","shopifyproductid":"8144386064606","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8144386064606","shopifyvariantid":"44379762131166","shopifyinventoryid":"46477552484574","shopifylocationid":"","product_id":"44572698","variant_id":"77465382","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44584759":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44584759","ebayitemid":"305852146924","shopifyproductid":"8711307985118","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8711307985118","shopifyvariantid":"45972599472350","shopifyinventoryid":"48071390593246","shopifylocationid":"","product_id":"44584759","variant_id":"77477468","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 20:20:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 20:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:20:09 [INFO]: Shopify Inventory id 46281168290014 2025-08-12 20:20:09 [INFO]: Shopify Location id 58450641063 2025-08-12 20:20:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:20:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20:20: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-12 20:20:09 [INFO]: Change: available | Delta: -1 2025-08-12 20:20:09 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:20:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:20:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572692 and user_id = 14409 2025-08-12 20:20:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465376 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:20:09 [INFO]: Shopify Inventory id 46477552484574 2025-08-12 20:20:09 [INFO]: Shopify Location id 58450641063 2025-08-12 20:20:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20:20: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-12 20:20:10 [INFO]: Change: available | Delta: -1 2025-08-12 20:20:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572698 and user_id = 14409 2025-08-12 20:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465382 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:20:10 [INFO]: Shopify Inventory id 48071390593246 2025-08-12 20:20:10 [INFO]: Shopify Location id 58450641063 2025-08-12 20:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20:20: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-12 20:20:10 [INFO]: Change: available | Delta: -1 2025-08-12 20:20:10 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44584759 and user_id = 14409 2025-08-12 20:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77477468 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:20:10 [INFO]: updateIdsQuantity -> ["77465376","77465382","77477468"] 2025-08-12 20:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-12 20:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77465376 THEN 0 WHEN id = 77465382 THEN 0 WHEN id = 77477468 THEN 0 END, quantityflag = CASE WHEN id = 77465376 THEN 0 WHEN id = 77465382 THEN 0 WHEN id = 77477468 THEN 0 END WHERE user_id = 14409 AND id IN (77465376,77465382,77477468) 2025-08-12 20:20:10 [INFO]: QUANTITY Updated IDs: 77465376, 77465382, 77477468 2025-08-12 20:20:10 [INFO]: Successfully processed data for user 14409 2025-08-12 20:20:10 [INFO]: Execution Started 2025-08-12 20:20:10 [INFO]: Execution Finished 2025-08-12 20:30:02 [INFO]: Execution Started 2025-08-12 20:30:02 [INFO]: old server sucessfully connected 2025-08-12 20:30:02 [INFO]: sqs client sucess created 2025-08-12 20:30:03 [INFO]: Number of messages in the queue: 1 2025-08-12 20:30:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:30:03 [INFO]: item found in queue is 14409 2025-08-12 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxGgjIGNv5E342zoLa4DCXfiZs3jVNyev8DJAe6QmNe6B1tr30VaE9OTuxt8odqa5BUbTDBO0Gv1hgdJHtMHswt1wUvii6TrGoNxcLwi7KNSKDEk+yFmzbaMwqyGjqVrXbpkvOepOP7kCMPQVviEwyknm1/OU7mrGGGnO5W/YZTyWkEOiApBMfE0LtLPb4YLC1DKUyXpyY2cp7LSsGulkWIQ0EcVI3sEjFxPWg+mmpQaypE6Mc9LDV13pJldwZe4OJqv8rkFPeQZBjYCe1kpyS/FRYg05h6rjweVibmwBjwrT9Xar6BDXZJYepes4mslkKz8j1qKUs1r16QCKLDgJaAFxbJ9Kmw/Gmi9wJ7DMF4Nt8/tT7iIKGQ08IWLwZsHd9hET9yXhNrgWIgSLepc1HdmiGqK+WZZ4NbYwqyLBtJXuTUOtGt+SvSmGA++pgmqa 2025-08-12 20:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 20:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 20:30:03 [INFO]: inside itemsold and closed 14409 2025-08-12 20:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:30:05 [INFO]: Ebay item id :: 286063199839 exists in Database 2025-08-12 20:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:30:05 [INFO]: in processold action queue is array for {"44574967":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574967","ebayitemid":"286063199839","shopifyproductid":"8697464389854","variants":[{"price":"21.99","quantity":0,"weight":"2","shopifyproductid":"8697464389854","shopifyvariantid":"45939237093598","shopifyinventoryid":"48037693554910","shopifylocationid":"","product_id":"44574967","variant_id":"77467674","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 20:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 20:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:30:05 [INFO]: Shopify Inventory id 48037693554910 2025-08-12 20:30:05 [INFO]: Shopify Location id 58450641063 2025-08-12 20:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20: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":1989,"restoreRate":100}}}} 2025-08-12 20:30:05 [INFO]: Change: available | Delta: -1 2025-08-12 20:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574967 and user_id = 14409 2025-08-12 20:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467674 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:30:05 [INFO]: updateIdsQuantity -> ["77467674"] 2025-08-12 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77467674 THEN 0 END, quantityflag = CASE WHEN id = 77467674 THEN 0 END WHERE user_id = 14409 AND id IN (77467674) 2025-08-12 20:30:05 [INFO]: QUANTITY Updated IDs: 77467674 2025-08-12 20:30:05 [INFO]: Successfully processed data for user 14409 2025-08-12 20:30:05 [INFO]: Execution Started 2025-08-12 20:30:05 [INFO]: Execution Finished 2025-08-12 20:40:01 [INFO]: Execution Started 2025-08-12 20:40:01 [INFO]: old server sucessfully connected 2025-08-12 20:40:01 [INFO]: sqs client sucess created 2025-08-12 20:40:02 [INFO]: Number of messages in the queue: 3 2025-08-12 20:40:02 [INFO]: item found in queue is if condition 14409 2025-08-12 20:40:02 [INFO]: item found in queue is 14409 2025-08-12 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBi7PstkeUkUc3+N6LEFM0MydnAP2jsbSoI6R+x0gcJ72XsdHCJAS1QCuPOf5SPWNhRlLSataWr0XgUGJmkmh6uQh/Y+iOlHvY251FvkgS8taOU/6nStYYj4pXBXE+R3Uyn4VJGIoFSYpyH4HlxHk1E6bM5CQ2kF/0axo06etftfPU73bkZoTPopKkK8xcDedO8H0V0M1Bm874ZnbeGcNcSxvjvZ1bPPTOZJcujVm8jLurePphYw5ZEiysc6L2jGYjYHEhpBL70xgJuv8HbIPgus7jdUNDicRTyYIhu8a7LZubdTjSVx5pLnUmgUQ8itzIpu2AFQK+c/tVAQPhmrLA+su2iw2MQms4SboCB1oJF/ziyNToe4GqY8yQkgUGAsm6PjMK6MRA9ffaL1VlkjnU57EyT/5mrXzM1nY8xRHMl/wgV1QdVKqipQehdHeG1kDe 2025-08-12 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:40:03 [INFO]: item found in queue is 14409 2025-08-12 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBBjyWh+JBN7BMI0Z9bhgAE7T/ieG3/gn4b6kXQ5mISwVLOvUCr33M6I5cRL+MTLp2OG9gC8sHA2e8AU+SWHmqHULZP7K2P5Vf1ezxs2s2fJVdoqmLbBit+ppr5MDu0ZTKgicnbNtGQQQiQd9ORkTFAN/oXmPYqeieFD1g1rWRPp9Qu42x4FdA2AQaZxaZM8oEdAQWQsFax6/HGo9eiBGs0Ch4BjhxBYSV2JWnKgKaaRJLQHSOtD4Ar4XF+jGV2AUr9kf9wbknPgZCCcisqcejZFBeWgOFKYuBNku4aUbTpZsNvXlZQPo6mqGLiJUTpqsAhUJUiWamyd+BO1QzxRwAIXzEJUYS0Hf7gMTj21TcTwfuwDjdlDqz2D3mGqXQf0DSHP87ZpqFiLo1Pc6rq6fR87JP9A28oOv9YsK/bTVtaNogTSM6dRBLxSfkDxsNWldN 2025-08-12 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:40:03 [INFO]: item found in queue is 14409 2025-08-12 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB8uy9qOBrbC01uL+fWNfsWZ0c29iGFzY2HLbY3JlglWLg0Gz6MKeXXP3lwyuD4lROz0lHW9V0cB2q0ybVX3hZPT1MoyHz5kmclwcFhCjLrgbqEHE/xUg2ZIW/y0MYzFvLPMHIV5lDo8ErfAiOICEr/IDOMtiKqNvbOxALy7y8BHWA7wRRlV0n2HLmqiJT38VaUfH+HZR2zT0VN5hf9yuWmqFnLi0f+21iIf+GmanPO4FjUu2iFy5aM97iGlePC4H7roMTRcggGFZpeWW3hqFoBH8JJ8vFAJeCs20BIvfTrNM4H2ZbRpEBRjW5pLp0NTN+sD/wutwnAMQ8/agj/ZhfCLnb9YN9Xb8iI67AIz+eNi2V58htRywnbhW4pA/BLNhHxuDHnsthA8gAp1YwZelzRyFKfoL5xvFQCy2+vem0Q1gXo+axm0pshmTAuYq6rbnY 2025-08-12 20:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 20:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 20:40:04 [INFO]: inside itemsold and closed 14409 2025-08-12 20:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:40:05 [INFO]: Ebay item id :: 326622078892 exists in Database 2025-08-12 20:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 20:40:05 [INFO]: inside itemsold and closed 14409 2025-08-12 20:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:40:07 [INFO]: Ebay item id :: 305793185961 exists in Database 2025-08-12 20:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:40:07 [INFO]: inside itemsold and closed 14409 2025-08-12 20:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:40:09 [INFO]: Ebay item id :: 335479429111 exists in Database 2025-08-12 20:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:40:09 [INFO]: in processold action queue is array for {"45106265":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45106265","ebayitemid":"326622078892","deleted":1}},"44582694":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582694","ebayitemid":"305793185961","shopifyproductid":"8017582883038","variants":[{"price":"20.99","quantity":0,"weight":"2","shopifyproductid":"8017582883038","shopifyvariantid":"44146444632286","shopifyinventoryid":"46243364798686","shopifylocationid":"","product_id":"44582694","variant_id":"77475403","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44565935":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44565935","ebayitemid":"335479429111","shopifyproductid":"8699154301150","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8699154301150","shopifyvariantid":"45943378575582","shopifyinventoryid":"48041869574366","shopifylocationid":"","product_id":"44565935","variant_id":"77458615","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 20:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 20:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:40:09 [INFO]: productIds WHich are having null productid -> [45106265] 2025-08-12 20:40:09 [INFO]: ebayItemIds WHich are not imported-> ["326622078892"] 2025-08-12 20:40:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 20:40:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 20:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45106265) 2025-08-12 20:40:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 20:40:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 20:40:09 [INFO]: Transaction committed successfully. 2025-08-12 20:40:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 20:40:09 [INFO]: Shopify Inventory id 46243364798686 2025-08-12 20:40:09 [INFO]: Shopify Location id 58450641063 2025-08-12 20:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20:40: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-12 20:40:09 [INFO]: Change: available | Delta: -1 2025-08-12 20:40:09 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582694 and user_id = 14409 2025-08-12 20:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475403 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:40:09 [INFO]: Shopify Inventory id 48041869574366 2025-08-12 20:40:09 [INFO]: Shopify Location id 58450641063 2025-08-12 20:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20:40: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-12 20:40:09 [INFO]: Change: available | Delta: -1 2025-08-12 20:40:09 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44565935 and user_id = 14409 2025-08-12 20:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458615 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:40:09 [INFO]: updateIdsQuantity -> ["77475403","77458615"] 2025-08-12 20:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 20:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77475403 THEN 0 WHEN id = 77458615 THEN 0 END, quantityflag = CASE WHEN id = 77475403 THEN 0 WHEN id = 77458615 THEN 0 END WHERE user_id = 14409 AND id IN (77475403,77458615) 2025-08-12 20:40:09 [INFO]: QUANTITY Updated IDs: 77475403, 77458615 2025-08-12 20:40:09 [INFO]: Successfully processed data for user 14409 2025-08-12 20:40:09 [INFO]: Execution Started 2025-08-12 20:40:09 [INFO]: Execution Finished 2025-08-12 20:50:01 [INFO]: Execution Started 2025-08-12 20:50:01 [INFO]: old server sucessfully connected 2025-08-12 20:50:01 [INFO]: sqs client sucess created 2025-08-12 20:50:02 [INFO]: Number of messages in the queue: 2 2025-08-12 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:50:03 [INFO]: item found in queue is 14409 2025-08-12 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBS6cm5fcMey2Owo0xDv1weX458/Gjj27sIpZ3BQQHTjG3slnTm61N/8XlR518DI/XLzVxsFL0zt6+ZT6EUtHpMZuzTwS7B5L1/K7cHwRPTRsIePLToUCwrye5BnddAiwkkVrVNzMdq6eeQTsLkIrZlRzo0zwTMGlG+4vmk0X/vi4E2UoE/Ge5oIwR4QusZUZ9GA1p9/5z6p1E2bW3GjLaOMwf3MVWAN0hr0pw3s60S6PDpd/6W8SfMETa1v0oZwR6V1zHLDT7CRKln7IwRpJut9Cw8CEWCJ9lEZ+LzGjy8sgXFYKd8kxoB7iLmpjfb4xodKZBPjbF/CJutAFHQyizE8ejpQITBkz29d1iUWftBqtfB3sBnnXBXUsE8sezMFfhU69uVYMSs8ag2AIwCJR0/WCokQ1NJ+AVFrYG+ka+91zq3YcoD2bsSzarKNMyta1Z 2025-08-12 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-12 20:50:03 [INFO]: item found in queue is 14409 2025-08-12 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBgqdsG1ABZj3Fz5giljKOFixZ9+cMNNul4r5f1jv5fyt29+NhBpe9181COjg7Yqe6fLWFZ7D9AVuq6P9c8nw4yCNLDfDO78BEDCEG3PoX57jaRybtXuniqTAU7pnNLBanxoMyvlXKBe3Y+eIH5zkTNdd2Z5jRGDtm03BaoDe3k1OizJ1qOpYP/ttkh53DUnN0YariC6zB7Mpvy1yaLCagmF5L6drqO5ktlczHsCYu1u9cZ1XjBFNUdzSPItffAVjOYG6GnAgnNACI+Eo0genRrVVOAmrSQavHx0bWLn3WvQ+g4/sgnQG64oxebK/akJMCVag67dK8xvluz9qggvMnNoPHgvU/3g75conIRuvbIMhKN6cbG4VJPTXxUokiFN4wv/1op8Hys0lnPlUOPZ6kF7/zrI+A2SSp+94oX0oR9JCI82yaUX9WPxZICJmtLfST 2025-08-12 20:50:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 20:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 20:50:03 [INFO]: inside itemsold and closed 14409 2025-08-12 20:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:50:05 [INFO]: Ebay item id :: 326717161136 exists in Database 2025-08-12 20:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:50:05 [INFO]: inside itemsold and closed 14409 2025-08-12 20:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 20:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-12 20:50:07 [INFO]: Ebay item id :: 335352213722 exists in Database 2025-08-12 20:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-12 20:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 20:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 20:50:07 [INFO]: in processold action queue is array for {"45313084":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313084","ebayitemid":"326717161136","shopifyproductid":"8979655786718","variants":[{"price":"181.99","quantity":0,"weight":"2","shopifyproductid":"8979655786718","shopifyvariantid":"47292286009566","shopifyinventoryid":"49404105588958","shopifylocationid":"58450641063","product_id":"45313084","variant_id":"78265597","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576258":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576258","ebayitemid":"335352213722","shopifyproductid":"8407670882526","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8407670882526","shopifyvariantid":"45198791704798","shopifyinventoryid":"47296701432030","shopifylocationid":"","product_id":"44576258","variant_id":"77468965","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 20:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 20:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 20:50:07 [INFO]: Shopify Inventory id 49404105588958 2025-08-12 20:50:07 [INFO]: Shopify Location id 58450641063 2025-08-12 20:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20: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-12 20:50:07 [INFO]: Change: available | Delta: -1 2025-08-12 20:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313084 and user_id = 14409 2025-08-12 20:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265597 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:50:07 [INFO]: Shopify Inventory id 47296701432030 2025-08-12 20:50:07 [INFO]: Shopify Location id 58450641063 2025-08-12 20:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 20:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T20: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-12 20:50:07 [INFO]: Change: available | Delta: -1 2025-08-12 20:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-12 20:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 20:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576258 and user_id = 14409 2025-08-12 20:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468965 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 20:50:07 [INFO]: updateIdsQuantity -> ["78265597","77468965"] 2025-08-12 20:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 20:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265597 THEN 0 WHEN id = 77468965 THEN 0 END, quantityflag = CASE WHEN id = 78265597 THEN 0 WHEN id = 77468965 THEN 0 END WHERE user_id = 14409 AND id IN (78265597,77468965) 2025-08-12 20:50:07 [INFO]: QUANTITY Updated IDs: 78265597, 77468965 2025-08-12 20:50:07 [INFO]: Successfully processed data for user 14409 2025-08-12 20:50:07 [INFO]: Execution Started 2025-08-12 20:50:07 [INFO]: Execution Finished