2025-08-04 15:00:01 [INFO]: Execution Started 2025-08-04 15:00:01 [INFO]: old server sucessfully connected 2025-08-04 15:00:01 [INFO]: sqs client sucess created 2025-08-04 15:00:02 [INFO]: Number of messages in the queue: 1 2025-08-04 15:00:02 [INFO]: item found in queue is if condition 14409 2025-08-04 15:00:02 [INFO]: item found in queue is 14409 2025-08-04 15:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBRqCl1JpfxmHopgDKw0MCQXNTD76Ivoxny3gkT6wa0iiaErB9hPc3928kaK+GpUFzOeJHqBVjnjTzujGfrcad1xuwo7OlcAwafVnI7EaBCYbX46mYYQiOczQhHXeYrUmIFcYngA05p7N6/NBeaBHlNtm4VHX/pqId833n50jFFH2HgrZd6xgkZgdnlv0v4Yi9fbuzXFnDSRd/IeZl4anXs0aTW+Cqg9kBBGfqp/QYjdp+5Y7lE2/9Ia0DLI886fY4xzu37m1S5TiwSJsPuENJtSw+wirJoKUBnbEtD6F1MuMTNqPYtOIuVG0JbtWIsJ4jIrq+0NQeAbc3tPAxpwLlkTxHmqAHy2XyEv1eX0rJlUJa6wPllKphSgRFJ7O1vkcuMeNv62fIV4v1vszIxgHDh6KcuYWDaajIpEVdv/k0BJbqXqg6HONfVjv/LP5+Wf+0 2025-08-04 15:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 15:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 15:00:03 [INFO]: inside itemsold and closed 14409 2025-08-04 15:00:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:00:04 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:00:04 [INFO]: Ebay item id :: 405469748912 exists in Database 2025-08-04 15:00:04 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:00:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:00:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:00:04 [INFO]: in processold action queue is array for {"44778040":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44778040","ebayitemid":"405469748912","shopifyproductid":"7921533190366","variants":[{"price":"89.99","quantity":0,"weight":"2","shopifyproductid":"7921533190366","shopifyvariantid":"43855603499230","shopifyinventoryid":"45951719243998","shopifylocationid":"","product_id":"44778040","variant_id":"77686582","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 15:00:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 15:00:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:00:04 [INFO]: Shopify Inventory id 45951719243998 2025-08-04 15:00:04 [INFO]: Shopify Location id 58450641063 2025-08-04 15:00:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:00:05 [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-04 15:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44778040 and user_id = 14409 2025-08-04 15:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77686582 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:00:05 [INFO]: updateIdsQuantity -> ["77686582"] 2025-08-04 15:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 15:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77686582 THEN 0 END, quantityflag = CASE WHEN id = 77686582 THEN 0 END WHERE user_id = 14409 AND id IN (77686582) 2025-08-04 15:00:05 [INFO]: QUANTITY Updated IDs: 77686582 2025-08-04 15:00:05 [INFO]: Successfully processed data for user 14409 2025-08-04 15:00:05 [INFO]: Execution Started 2025-08-04 15:00:05 [INFO]: Execution Finished 2025-08-04 15:10:01 [INFO]: Execution Started 2025-08-04 15:10:01 [INFO]: old server sucessfully connected 2025-08-04 15:10:01 [INFO]: sqs client sucess created 2025-08-04 15:10:03 [INFO]: Number of messages in the queue: 0 2025-08-04 15:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 15:10:03 [INFO]: item found in queue is 14409 2025-08-04 15:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBA2KbXQZ1OMg2KQlsXa0bdHswvVx5OJCB3w0gmGHu+r1mjy9RJqN7sYBQWnBla99t5+SLWmgAwWW+WMFpFAkuDHOAKvPTSQDRfVtCLc1stCDeJoCQlx3gKWXXVkBfzlC+62touikq5HhAROWkqOM3LKgFnhKPpmWEPM2v3WHSU0W78xKHMTwHEl4lcgiekcK8hX0nMda4gM9C3Kl6VHfVnEOug/vzcpCLJ8/Z0mWjCS7h92enYTjq21FLeeuQANEIhMloJeyF2grGgH8+euzYrVc14r+B0s+j7zQuE8lT2rhO/Hlyw9tthMxARscu7eL3q8lD1pO5DwqakklPOL5nCpBlo+ryjsVK3diaDS0lSYf01uPytuUPJos/G1dCfBH0a8GvQaMTwW9pG1zztvg4JN9t9d4xKl4HtwfHM/fYEFK5G2F1CnssjcuA5QMTI9eu 2025-08-04 15:10:04 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-04 15:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 15:10:04 [INFO]: inside itemsold and closed 14409 2025-08-04 15:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:10:05 [INFO]: Ebay item id :: 335789531277 exists in Database 2025-08-04 15:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:10:05 [INFO]: in processold action queue is array for {"44604798":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44604798","ebayitemid":"335789531277","shopifyproductid":"8803979067614","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8803979067614","shopifyvariantid":"46255372370142","shopifyinventoryid":"48355994960094","shopifylocationid":"","product_id":"44604798","variant_id":"77499749","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 15:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 15:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:10:05 [INFO]: Shopify Inventory id 48355994960094 2025-08-04 15:10:05 [INFO]: Shopify Location id 58450641063 2025-08-04 15:10:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T15:10:05Z","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-04 15:10:05 [INFO]: Change: available | Delta: -2 2025-08-04 15:10:05 [INFO]: Change: on_hand | Delta: -2 2025-08-04 15:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44604798 and user_id = 14409 2025-08-04 15:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77499749 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:10:05 [INFO]: updateIdsQuantity -> ["77499749"] 2025-08-04 15:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 15:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77499749 THEN 0 END, quantityflag = CASE WHEN id = 77499749 THEN 0 END WHERE user_id = 14409 AND id IN (77499749) 2025-08-04 15:10:05 [INFO]: QUANTITY Updated IDs: 77499749 2025-08-04 15:10:05 [INFO]: Successfully processed data for user 14409 2025-08-04 15:10:05 [INFO]: Execution Started 2025-08-04 15:10:05 [INFO]: Execution Finished 2025-08-04 15:20:01 [INFO]: Execution Started 2025-08-04 15:20:01 [INFO]: old server sucessfully connected 2025-08-04 15:20:01 [INFO]: sqs client sucess created 2025-08-04 15:20:02 [INFO]: Number of messages in the queue: 1 2025-08-04 15:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 15:20:03 [INFO]: item found in queue is 14409 2025-08-04 15:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBCNrfRshbFbZZ84bCDJ7hhORkhXBapfq4+wrU6xIPcWUX4UEmz4q4nMrWajFUEnvEdG5XXRc9DrROR6hTn2Ojyqka5XopIRf9vw1N7YCqV4yJIabQ5Y7Ma7BoaGPX/m5MJCwKrTkRKsRNwtImJId1cUn+eKqwE2fpofRBpwA2a08doRzLYGX5HU6DTAeWzScUFonfKyTkcQbpkRyQUF/fo7vKa1krJeCipp5l7y4DQYS1oSnYKD60l+1O00xtYl0N1ktqDH9y3NL1Ga5ZaEm3eEOYixgUaDQWmp4ZUzCM3l1CYmVsb5L9rSytDzd6IGPvmWhmGmRsT+Zp1O61WJZTx0C2DlvhCARlDp6+nW3MEhlX8f0nZeo6gQvcosoO5DEfCI8GErcF3ZoD3U34Y8POGRl+qLwJP8ZuNlcygw9r9XDkTuGTeH2x33tjhSa4unN3 2025-08-04 15:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 15:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 15:20:03 [INFO]: inside itemsold and closed 14409 2025-08-04 15:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:20:05 [INFO]: Ebay item id :: 334483107267 exists in Database 2025-08-04 15:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:20:05 [INFO]: in processold action queue is array for [] 2025-08-04 15:20:05 [INFO]: Successfully processed data for user 14409 2025-08-04 15:20:05 [INFO]: Execution Started 2025-08-04 15:20:05 [INFO]: Execution Finished 2025-08-04 15:30:01 [INFO]: Execution Started 2025-08-04 15:30:01 [INFO]: old server sucessfully connected 2025-08-04 15:30:01 [INFO]: sqs client sucess created 2025-08-04 15:30:03 [INFO]: Number of messages in the queue: 3 2025-08-04 15:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 15:30:03 [INFO]: item found in queue is 14409 2025-08-04 15:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBCsPWN8BjAvtXHoBp4Q6cgRDRRMeqqavNIZnSb4o5/c4T1nxUcViFrsVJ0pVdu4IfIt5ZMh4ec1YqxZ5suWJYlQz6rxTGhYfQbe6PHcZTDQ9V66cODzdc0g/Yo9Tb8fJS3l8Eu7V4qItCMKp7RYslGZwQ6Ncrfcnkk4aII7M3+s4JLDachuZS2kIA6y7h7FILNw3K4lJ4AoKP5bJ4i9fb5gx4SYROjzjoQdRq18iwU2O1m0Uz0ws/HCQIa5+2fiBeVRI0GND21/z7eWpLxC/EVXen1NZEKHxlUl8U86rPV5qiOpn2HTGyVl8tXarh9U4k18p8SUDphAC/mQsz/dhRzVCzhKj+kaiMzjnVQDW2qydv8SLswKey0fcaF9ENAOb/G99d7tL1OEHciMqzZN9HVo0txi+uWfe/aMc0vfg9NTY9QQoEiEFMAlzEeUkEF7bw 2025-08-04 15:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 15:30:04 [INFO]: item found in queue is 14409 2025-08-04 15:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB2LL12RqGOYA5tW2E0sgEovN+/NcHSaUYi5Y92ORF4yacO5qDN2xrN93wuBOErPPM7KTJij4LwjZpJVtUyPAnhRoqlJo530Gboo3jhhhglS9hJ9n88J5X6fXsJGntzs3LrJq/LV41xc+SebbiIkZ6LkkuGso3XwI6cQDXDQ0ZbeX0BHjm0hsxwTRKdgzhQZ/3cX0KQZpOxP53jML//Ccck18ovSkLQAor8xTXYqfrhHY96FLgiSqRxTXgo/3ZiXvj8c4DyOQOcTdDGz51ZNhOoza23qVwAzv7fQfJ0ABt0GW5TsZzFJzue2fuEWVRdqpkEcoYwpEBT7gJuYWshxpKM4BztNEChRI2xc03//33ZwEkl+koXJ3Jr6yTaLBks0+fNFgCP02UUKRTsye7mX9bdtQEcU/EnW5E1EW6BIyVXi4OojutEesHe6ELaT7cwjun 2025-08-04 15:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 15:30:05 [INFO]: item found in queue is 14409 2025-08-04 15:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBX/8aXB6TSpRGBOUcLfHEDxtEqZ6dRM7Y8bPKRV4ruKBkZdOgf70WGPf6FgKLciHNaMo+hD1dEHO5YoLN6LB5KbSnCVPoMcbSbg/TP6Dty7mZCisBoiiCvMPXOmCaTmU/1YoQ7C3p5CfV1ZlZY2RfLZ6+tdvF5sK1Rxmaer/UfEKUJmjfWBM3vBnTsqSQcyVaMTHlrP6p8Bbi6ATS5xsEsjeFZIJRMcb/oPCMNonLBJ9VmxU+dcbfT1mNKUzbZ6Sp/LI4Bxe2ChiBQeENtRnqdnBc8x/0//dh+0YQzukyOnAA63pkmJCW/sGbLQ2/Xi827vtFGaHpM3rImO+eIeGi4sW4dTvK+RRRi5aIuXGjwigQWyTc/1c5uTxFSm2tFsMNb6hQIk7+jx9MjjTadqdSeTztJzCOeXp+dwDM6nOHQS9Cjj1815cGkhWu4Xnl6fWh 2025-08-04 15:30:05 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 15:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 15:30:05 [INFO]: inside itemsold and closed 14409 2025-08-04 15:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:30:07 [INFO]: Ebay item id :: 285763277872 exists in Database 2025-08-04 15:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:30:07 [INFO]: inside itemsold and closed 14409 2025-08-04 15:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:30:09 [INFO]: Ebay item id :: 285762754878 exists in Database 2025-08-04 15:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:30:09 [INFO]: inside itemsold and closed 14409 2025-08-04 15:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:30:10 [INFO]: Ebay item id :: 305776588619 exists in Database 2025-08-04 15:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:30:10 [INFO]: in processold action queue is array for {"44571501":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44571501","ebayitemid":"285763277872","shopifyproductid":"8316494184670","variants":[{"price":"15.99","quantity":0,"weight":"0.5","shopifyproductid":"8316494184670","shopifyvariantid":"44894481219806","shopifyinventoryid":"46992264888542","shopifylocationid":"","product_id":"44571501","variant_id":"77464185","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44570782":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570782","ebayitemid":"285762754878","shopifyproductid":"8315984642270","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8315984642270","shopifyvariantid":"44892920152286","shopifyinventoryid":"46990703558878","shopifylocationid":"","product_id":"44570782","variant_id":"77463466","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44567159":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567159","ebayitemid":"305776588619","shopifyproductid":"8697515114718","variants":[{"price":"26.99","quantity":0,"weight":"0.5","shopifyproductid":"8697515114718","shopifyvariantid":"45939329532126","shopifyinventoryid":"48037789237470","shopifylocationid":"","product_id":"44567159","variant_id":"77459839","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 15:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 15:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:30:10 [INFO]: Shopify Inventory id 46992264888542 2025-08-04 15:30:10 [INFO]: Shopify Location id 58450641063 2025-08-04 15:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T15:30:11Z","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-04 15:30:11 [INFO]: Change: available | Delta: -1 2025-08-04 15:30:11 [INFO]: Change: on_hand | Delta: -1 2025-08-04 15:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44571501 and user_id = 14409 2025-08-04 15:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464185 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:30:11 [INFO]: Shopify Inventory id 46990703558878 2025-08-04 15:30:11 [INFO]: Shopify Location id 58450641063 2025-08-04 15:30:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:30:11 [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-04 15:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570782 and user_id = 14409 2025-08-04 15:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77463466 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:30:11 [INFO]: Shopify Inventory id 48037789237470 2025-08-04 15:30:11 [INFO]: Shopify Location id 58450641063 2025-08-04 15:30:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T15:30:11Z","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-04 15:30:11 [INFO]: Change: available | Delta: -1 2025-08-04 15:30:11 [INFO]: Change: on_hand | Delta: -1 2025-08-04 15:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567159 and user_id = 14409 2025-08-04 15:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459839 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:30:11 [INFO]: updateIdsQuantity -> ["77464185","77463466","77459839"] 2025-08-04 15:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 15:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77464185 THEN 0 WHEN id = 77463466 THEN 0 WHEN id = 77459839 THEN 0 END, quantityflag = CASE WHEN id = 77464185 THEN 0 WHEN id = 77463466 THEN 0 WHEN id = 77459839 THEN 0 END WHERE user_id = 14409 AND id IN (77464185,77463466,77459839) 2025-08-04 15:30:11 [INFO]: QUANTITY Updated IDs: 77464185, 77463466, 77459839 2025-08-04 15:30:11 [INFO]: Successfully processed data for user 14409 2025-08-04 15:30:11 [INFO]: Execution Started 2025-08-04 15:30:11 [INFO]: Execution Finished 2025-08-04 15:40:01 [INFO]: Execution Started 2025-08-04 15:40:01 [INFO]: old server sucessfully connected 2025-08-04 15:40:01 [INFO]: sqs client sucess created 2025-08-04 15:40:02 [INFO]: Number of messages in the queue: 0 2025-08-04 15:40:23 [INFO]: Execution Started 2025-08-04 15:40:23 [INFO]: Execution Finished 2025-08-04 15:50:01 [INFO]: Execution Started 2025-08-04 15:50:01 [INFO]: old server sucessfully connected 2025-08-04 15:50:01 [INFO]: sqs client sucess created 2025-08-04 15:50:03 [INFO]: Number of messages in the queue: 2 2025-08-04 15:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 15:50:03 [INFO]: item found in queue is 14409 2025-08-04 15:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBhHJRE82GU4xgWIZfM0+u672fzxPTSkGVkdIL+72B02FxnnnpWSCBEmcu3J7dcaSXqgKSt0u3J9ghJEnZpKsEz0tUG7a37eSuH2ZFom9VCjKsT16HKRqWAp447Wmwo78AvzHlESJr5G9RZoqtwKuFTOl7Zix5D+Jc9OgsDJLkDtaFLz+n8UbX8o9FJmfodgu0gyeML0w+iFe6AIwEnCbugQN2fEdYs5wAM1n4H0L3XDZ2vp+voZm+0WnNRYv/XUZ26rJ8X0WtRz2rvdR1bJEtZtXkyOxwkzgvnyaX5DJQaWdwrFi/ZT79YOR0IKUSuJyPEUR+cviWubn3q6S6JZdGapoEdtteZP6p2Wu5eCcZgF9oBgm8fmqwfPcVrR92FtfVoT3ByrUesmEiDZN8VWgRmOUzLxc8VyKiStNftk/KX0Q5ginrYJtu36qOrkhUKPke 2025-08-04 15:50:04 [INFO]: item found in queue is if condition 14409 2025-08-04 15:50:04 [INFO]: item found in queue is 14409 2025-08-04 15:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBi7L4OpOiInd47i4eCSVitkTr7AzVWq+1rAQqXzBDtvF7cBGADD9X9/rC8kWMndqtJ6da74z8GSYL1hA2kMPCJ89ITbYiy8dxILWhI622RJyPK3gwneFqcvcVDqjZLutacGtFAF241QHcqlcWF3tGy6NIyE6Dncg8/zc6OJGcZRbgbowhA+YLyRAYORjDSpzIc6dwUqo+5INLO2DiLtKLb+kOSpWcJS1GxMjakaFGeat5f/eQ6BMkorfDqb5bCxQ06jkX9a4nTKUpmDwffc4wNZkdvtR2aTVfToWMcPQ1FxRl3Zev/DsaArUjrFSZBM4DUY3SFgKWA4ephUkvETYx2Datb9X0OyUPVVYLTva1b5T4o3fBifCwg+RcAFNJOfzFOBzuKH9WZOp/Yxxu5doXm1Z0+VWjcnrBOidJmaGEt5C4ebHykCyxtCldXmmVAyJt 2025-08-04 15:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 15:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 15:50:04 [INFO]: inside itemsold and closed 14409 2025-08-04 15:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:50:06 [INFO]: Ebay item id :: 306070818926 exists in Database 2025-08-04 15:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:50:06 [INFO]: inside itemsold and closed 14409 2025-08-04 15:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 15:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 15:50:08 [INFO]: Ebay item id :: 285474228673 exists in Database 2025-08-04 15:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 15:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 15:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 15:50:08 [INFO]: in processold action queue is array for {"44594898":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594898","ebayitemid":"306070818926","shopifyproductid":"8694955409630","variants":[{"price":"309.99","quantity":0,"weight":"2","shopifyproductid":"8694955409630","shopifyvariantid":"45933639237854","shopifyinventoryid":"48032090423518","shopifylocationid":"","product_id":"44594898","variant_id":"77487607","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572389":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572389","ebayitemid":"285474228673","shopifyproductid":"8128917766366","variants":[{"price":"20.99","quantity":0,"weight":"0.5","shopifyproductid":"8128917766366","shopifyvariantid":"44347670659294","shopifyinventoryid":"46445428605150","shopifylocationid":"","product_id":"44572389","variant_id":"77465073","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 15:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 15:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 15:50:08 [INFO]: Shopify Inventory id 48032090423518 2025-08-04 15:50:08 [INFO]: Shopify Location id 58450641063 2025-08-04 15:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T15: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-04 15:50:08 [INFO]: Change: available | Delta: -1 2025-08-04 15:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 15:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594898 and user_id = 14409 2025-08-04 15:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487607 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:50:08 [INFO]: Shopify Inventory id 46445428605150 2025-08-04 15:50:08 [INFO]: Shopify Location id 58450641063 2025-08-04 15:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 15:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T15: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-04 15:50:08 [INFO]: Change: available | Delta: -1 2025-08-04 15:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 15:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 15:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572389 and user_id = 14409 2025-08-04 15:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465073 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 15:50:08 [INFO]: updateIdsQuantity -> ["77487607","77465073"] 2025-08-04 15:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 15:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77487607 THEN 0 WHEN id = 77465073 THEN 0 END, quantityflag = CASE WHEN id = 77487607 THEN 0 WHEN id = 77465073 THEN 0 END WHERE user_id = 14409 AND id IN (77487607,77465073) 2025-08-04 15:50:08 [INFO]: QUANTITY Updated IDs: 77487607, 77465073 2025-08-04 15:50:08 [INFO]: Successfully processed data for user 14409 2025-08-04 15:50:08 [INFO]: Execution Started 2025-08-04 15:50:08 [INFO]: Execution Finished