2025-08-01 18:00:01 [INFO]: Execution Started 2025-08-01 18:00:01 [INFO]: old server sucessfully connected 2025-08-01 18:00:01 [INFO]: sqs client sucess created 2025-08-01 18:00:02 [INFO]: Number of messages in the queue: 2 2025-08-01 18:00:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:00:03 [INFO]: item found in queue is 14409 2025-08-01 18:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/8p5u1sUqkXqJkApSake4lbxKZIDdadD9xqDa3SZc+t2gaJp+mpceGienpffYaisjt8N2i3f/U2UnHo2ZwDAnq6wADz1ZGwb8DUy+VLLc3tWsQBqYnaScJXXPkShaLD7woj/WoAhbJ0wXr9w53eVj35x/Mi5/wmtQ769kNmAxGGXbXRHIvMSo/JNgyYUasicZkvgCxj+OVdmuJdy5b22Dilxu9XqccQYY7FjqJemtpB+beOmC8/d76cDubIw4bTgAX845b9kDGzRp/Me/QZ82vwe8Ymo8Nzw6ejJ3DiOYtHZ4LJ+Oq3Q0eG7mv+rznZg5oYBedYwJVug15FZi2XX/7Vw27OkEslKQl+h1tbBOkOKlV4IB7EAeRLB2wgIuL7Md4Ind3RwLQ7Kqr5T+pej8WzfDvVIr21MC48OaXntnKuDhE2z5F9sMLuMa+0FXAMq 2025-08-01 18:00:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:00:03 [INFO]: item found in queue is 14409 2025-08-01 18:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBCUzAcrdna2OHf6vhjNX5EFR7ijr8RGZfQA9RyufKJj3JITrwV4ZT3dEyBhh79zhviQYzMNhtN9M0iiG0ACXooUs6IUSdtTPuDRt5cAhHG4MluVwc3T9dpSXknR2xnQtqYD+UHWXOZe/swKHOPfR8IsY6HtprzmJQOHpy4hcKLKp1ugKiihPdPWU1QvziUeXBZDvKP14YXdTdeB9wvd0udvj/PI7ihlHv+ksHWXA+U/mOdRfNhFu0OMm3PJO6fquB1CUlFXEnSSksMeIzW8M5uZ9mlMt3HoAnZpCh9zsWBONyROpyro6zsXhHWt1C/RJx9ROQ7Jx4qITrhocyWpJKEeAbzxjGUBYjmiEmFAqMS7tF9VHmX7y+MAPiUSHoUrVvfwLbvTGQC0OWhVMOQqt65indTKcaExW2TIu6s4ttqLZpZNpoeLa1NWD/IFJU9NJ6 2025-08-01 18:00:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 18:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 18:00:03 [INFO]: inside itemsold and closed 14409 2025-08-01 18:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:00:05 [INFO]: Ebay item id :: 325615553858 exists in Database 2025-08-01 18:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:00:05 [INFO]: inside itemsold and closed 14409 2025-08-01 18:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:00:07 [INFO]: Ebay item id :: 326306153100 exists in Database 2025-08-01 18:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:00:07 [INFO]: in processold action queue is array for {"44642430":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642430","ebayitemid":"325615553858","shopifyproductid":"8015314288862","variants":[{"price":"11.99","quantity":0,"weight":"0.9375","shopifyproductid":"8015314288862","shopifyvariantid":"44142378090718","shopifyinventoryid":"46239283708126","shopifylocationid":"","product_id":"44642430","variant_id":"77547619","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44652320":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44652320","ebayitemid":"326306153100","shopifyproductid":"6911578898599","variants":[{"price":"34.99","quantity":0,"weight":"3","shopifyproductid":"6911578898599","shopifyvariantid":"40689345298599","shopifyinventoryid":"42784996065447","shopifylocationid":"","product_id":"44652320","variant_id":"77557509","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 18:00:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 18:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:00:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:00:07 [INFO]: Shopify Inventory id 46239283708126 2025-08-01 18:00:07 [INFO]: Shopify Location id 58450641063 2025-08-01 18:00:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:00:08Z","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-01 18:00:08 [INFO]: Change: available | Delta: -2 2025-08-01 18:00:08 [INFO]: Change: on_hand | Delta: -2 2025-08-01 18:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642430 and user_id = 14409 2025-08-01 18:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547619 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:00:08 [INFO]: Shopify Inventory id 42784996065447 2025-08-01 18:00:08 [INFO]: Shopify Location id 58450641063 2025-08-01 18:00:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:00: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-01 18:00:08 [INFO]: Change: available | Delta: -1 2025-08-01 18:00:08 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44652320 and user_id = 14409 2025-08-01 18:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77557509 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:00:08 [INFO]: updateIdsQuantity -> ["77547619","77557509"] 2025-08-01 18:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-01 18:00:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77547619 THEN 0 WHEN id = 77557509 THEN 0 END, quantityflag = CASE WHEN id = 77547619 THEN 0 WHEN id = 77557509 THEN 0 END WHERE user_id = 14409 AND id IN (77547619,77557509) 2025-08-01 18:00:08 [INFO]: QUANTITY Updated IDs: 77547619, 77557509 2025-08-01 18:00:08 [INFO]: Successfully processed data for user 14409 2025-08-01 18:00:08 [INFO]: Execution Started 2025-08-01 18:00:08 [INFO]: Execution Finished 2025-08-01 18:10:01 [INFO]: Execution Started 2025-08-01 18:10:01 [INFO]: old server sucessfully connected 2025-08-01 18:10:01 [INFO]: sqs client sucess created 2025-08-01 18:10:02 [INFO]: Number of messages in the queue: 4 2025-08-01 18:10:02 [INFO]: item found in queue is if condition 14409 2025-08-01 18:10:02 [INFO]: item found in queue is 14409 2025-08-01 18:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEBg8YJZiDjTyXKjofBgr0711iV3gvKNSKISM+G+mPoIB9yLiZMB5muMBKvo/z1iS34fDhqh8EEJLT3KB4R1cPaFaDIuvuaayU2RXxeK2WaUPJwr5Q9UTfc3KaC3qkSqmnwc2DLvh7dFSFsaVjD4XOrqJvwkCupM9Rn5GwFeg1DGwY6CGMXxRCLOF7UbKfbAUNB3ta4FV5/LI6YKJFQWpIRQSGYMVQ6+xPOMmt6UAs9tKn/hZyJqLzPaSuKBmBpnis6D8M2eh3iGqOf/asGQFny+Iu1/odv3IwTX6mxd47Gs7Wk0mLxtFU0NQIu8HaHQnGuy8XAVooOJGr9pauWROip1amnlJ15fRejzEkQ3jmYYOIyoPr8DVPY5k0y/g0RdyhXIwQwb6+J6yGmbHaQSZO7nS2QY8JL9jvsrxwpiMhOOFeAvM8TShiySJID9LZ+vyUO 2025-08-01 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:10:03 [INFO]: item found in queue is 14409 2025-08-01 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8Cmr0FrplQygL2vZApcIlvTGZhPGyRI8VT8a14O66Vsh5JOuxi197s8zidjRn2PpK8PWGoSPuiwbd2VnoIIGqwqjYr7e+hLAQYIpLHLnphIUVh44EXkwEUfbrtCEct3VeyQpEEmCL7wGHFXzLBKiKmWpKP24OqLqT2isCGIbtMiz07QV3sfYuDEu59l74LwNfCPi7WRU0BjTHGRkjbQlS8EVANcyRT2ANlakqJbThPVSE0TRuPSAnRgholVkxFAx5dz+yQluZA7pGVL8BYPU9bK4DCl7FjsxFt0dUOEKMsVNRBdXkKqnuD0utJ6MneR79shkqSV6kDkUDnQmb5WXUnnBCD3VieYUQ15pmz+gjszZNI8YHrk0QK3EJWHhgDhRl3DDTl/F1BHBA867f8evZkjoq/JcInO1UFEm8IUZWQe0OdgZpybujhbrujk6EFTT 2025-08-01 18:10:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:10:03 [INFO]: item found in queue is 14409 2025-08-01 18:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHCdOye9HJ8O75u77aGTvw1URZK6jyv9drD9VqlkJDVTVyIck9o8Zk6p0LEvPEK3jfTzpi9mZVDOW8SX7603PRN/xurK3GD6rlhdQXYpHmxDeC+r+pCrnAPLfFkjm1LslZzJ25TUFs6hjGfTUeXSyszVwwQxHAsXt19pjamYb9zn97FrvdFvNVTDw+bMiwhx9lFO//TPANNXHTaICQIYrue3CspI+64eXQY2WJjM6devyEC+mjdBxSMLBKhO1IgqwTTHs+1TexPUx0G+ZsgwH9h3iprXYDqqA7bKGpAHL2mrINT03LC3/zDM7BlltVxiJHAYofePM/E5RjXXHWpbaOxt3cQk68WvsHRo8ZPhA0NxQcmCrwMm29L4I2IZkolrndtXWMf+Lau1ltlrqmKvdnmcKo106WeBfqi1sujHz1cJWHoCtA/04qC0h/zRYOwqG 2025-08-01 18:10:04 [INFO]: item found in queue is if condition 14409 2025-08-01 18:10:04 [INFO]: item found in queue is 14409 2025-08-01 18:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBVODZjdaFz0Qt585Pe5VHVOhcpLyZEX1t8egERLk8d52/RzZ4MMTKwGeTkyMDH7HNHwGBhV58dqI9XEuu9w5rthJGiRMeofnu1sZ6UdcLu2jrn/axb5M/AetH1+WUMPV65jwrUhRNrdQCcp+PwdT+BhdVJJ+3V1Vwrsoo1S/ojuWUA8gKwV4hDTnu3eiPYtOa7GogxD+owZqS7KmAcgl9lJhaRLF8FZGsK3LSj4c6FtgwABRnhYbNsewQBGSNB3JbSe1EM01v3pAGeQsA8apuTVDqG/1OnVONlZXzs5t6MvmkFr8sMw58lCXdOV5JkMdKKFogUDzIIZ5C91lUjD4kOwdfWQiWFOc6GXX9LIvMImFGsh1Qwv8ANpOulc9UijtxCF6bSwK6W4MeSkdDpxiKnKhEVN9p1Z8kXAV+781zwDWxcZusoz8+RQmoxEnweSs0 2025-08-01 18:10:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-01 18:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 18:10:04 [INFO]: inside itemsold and closed 14409 2025-08-01 18:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:10:06 [INFO]: Ebay item id :: 404091990841 exists in Database 2025-08-01 18:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:10:06 [INFO]: inside itemsold and closed 14409 2025-08-01 18:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:10:07 [INFO]: Ebay item id :: 226402063212 exists in Database 2025-08-01 18:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:10:07 [INFO]: inside itemsold and closed 14409 2025-08-01 18:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:10:09 [INFO]: Ebay item id :: 326595676767 exists in Database 2025-08-01 18:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:10:09 [INFO]: inside itemsold and closed 14409 2025-08-01 18:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:10:11 [INFO]: Ebay item id :: 326305127116 exists in Database 2025-08-01 18:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:10:11 [INFO]: in processold action queue is array for {"44649735":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649735","ebayitemid":"226402063212","shopifyproductid":"7674843922654","variants":[{"price":"44.99","quantity":0,"weight":"3","shopifyproductid":"7674843922654","shopifyvariantid":"42898139054302","shopifyinventoryid":"44993008369886","shopifylocationid":"","product_id":"44649735","variant_id":"77554924","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44858063":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44858063","ebayitemid":"326595676767","shopifyproductid":"8927179178206","variants":[{"price":"31.99","quantity":0,"weight":"1","shopifyproductid":"8927179178206","shopifyvariantid":"46846578917598","shopifyinventoryid":"48958023565534","shopifylocationid":"58450641063","product_id":"44858063","variant_id":"77769032","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44649738":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649738","ebayitemid":"326305127116","shopifyproductid":"8016405823710","variants":[{"price":"44.99","quantity":0,"weight":"3","shopifyproductid":"8016405823710","shopifyvariantid":"44144776708318","shopifyinventoryid":"46241680720094","shopifylocationid":"","product_id":"44649738","variant_id":"77554927","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 18:10:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 18:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:10:11 [INFO]: Shopify Inventory id 44993008369886 2025-08-01 18:10:11 [INFO]: Shopify Location id 58450641063 2025-08-01 18:10:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:10: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-01 18:10:12 [INFO]: Change: available | Delta: -1 2025-08-01 18:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649735 and user_id = 14409 2025-08-01 18:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554924 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:10:12 [INFO]: Shopify Inventory id 48958023565534 2025-08-01 18:10:12 [INFO]: Shopify Location id 58450641063 2025-08-01 18:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:10:12 [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-01 18:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44858063 and user_id = 14409 2025-08-01 18:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77769032 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:10:12 [INFO]: Shopify Inventory id 46241680720094 2025-08-01 18:10:12 [INFO]: Shopify Location id 58450641063 2025-08-01 18:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:10:12Z","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-01 18:10:12 [INFO]: Change: available | Delta: -1 2025-08-01 18:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649738 and user_id = 14409 2025-08-01 18:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554927 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:10:12 [INFO]: updateIdsQuantity -> ["77554924","77769032","77554927"] 2025-08-01 18:10:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 2 2025-08-01 18:10:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77554924 THEN 0 WHEN id = 77769032 THEN 0 WHEN id = 77554927 THEN 0 END, quantityflag = CASE WHEN id = 77554924 THEN 0 WHEN id = 77769032 THEN 0 WHEN id = 77554927 THEN 0 END WHERE user_id = 14409 AND id IN (77554924,77769032,77554927) 2025-08-01 18:10:12 [INFO]: QUANTITY Updated IDs: 77554924, 77769032, 77554927 2025-08-01 18:10:12 [INFO]: Successfully processed data for user 14409 2025-08-01 18:10:12 [INFO]: Execution Started 2025-08-01 18:10:12 [INFO]: Execution Finished 2025-08-01 18:20:01 [INFO]: Execution Started 2025-08-01 18:20:01 [INFO]: old server sucessfully connected 2025-08-01 18:20:01 [INFO]: sqs client sucess created 2025-08-01 18:20:02 [INFO]: Number of messages in the queue: 2 2025-08-01 18:20:02 [INFO]: item found in queue is if condition 14409 2025-08-01 18:20:02 [INFO]: item found in queue is 14409 2025-08-01 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwEbjP4orPioL9xXtlYnFj7DwMfAe/Irrscj0U7um1gsJFdiQtIdFil7ZPpdXz8mzCXkRvIC88+nIymQdkrftUWNsI0XcLS9UFgl9Vk4h4c35zPCVk/84HQ9iwz/0/xgHI2ljMk5oT8+CKRpNE0smimrpPhWv9oL76g6fhi2dFDGxlC95WG2Xf/ektAI4Qa804N1D7sQMNjV+1OP/JLd+/gCYIBhkYUAYuJHum3lvt24Wdoicgq0CUfaQBN9Nc5IRX4SwjxpukW/38VBTA9TasyGgMDELzGYWbMj0Lv8Ke/NaayPUP8TMaXOz7Dl00sI19j3iBxdg5+khy3OptdOi7RVD//hPxbN8KlnjMlmdwLiVk63IDvuq8toVSMLD24TpHNm53a+42kq5lPjMN+V37IqLSmpyiNFDOhUfqeNGl2o71LHHikkY0Sm/w3Jkpzcy 2025-08-01 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:20:03 [INFO]: item found in queue is 14409 2025-08-01 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBCajYtgqOYU3GkK8DdSflv4jC9qOvOnv61HRsnb5fMPgub8Ce0LSdAdgx6ZpXz/xwW0CXXd7Xv7NwaPulW0CCKs7PeJ6gdlStvDHmi29FI403JXwWLcPxsruAW/dWQQgDAMQWKJTDt5iJoJDe7rRaD5i6sodde0fTqwCYN1jJfTIFMJuMxfItQY7nt5WCcYV/ZlSTej9e+COA+mJ5R67in1LdyrzHIUIOKunZPa23XM+QwpkVAAVGdtVmctbwTanJFYIyMKTWSmSRqDh+xVPhGt1De3nKdYex1jKTJOcuexmESkZeaSClvOAd0Jr5AQMgBhPyS8jjgjkmTqCYyrrBdwjsASdGTJo4uQjLYCG09rQ4n1xYKT89WE/W3YDJu/E52pfKyxE1DSHEPCJ20Z1MNpS1BNtdBfequs31jGQCBBRo7luQjcx9BjAPITxqIXsk 2025-08-01 18:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 18:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 18:20:03 [INFO]: inside itemsold and closed 14409 2025-08-01 18:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:20:05 [INFO]: Ebay item id :: 226448599041 exists in Database 2025-08-01 18:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:20:05 [INFO]: inside itemsold and closed 14409 2025-08-01 18:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:20:07 [INFO]: Ebay item id :: 326283946833 exists in Database 2025-08-01 18:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:20:07 [INFO]: in processold action queue is array for {"44645469":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44645469","ebayitemid":"226448599041","shopifyproductid":"8735609159902","variants":[{"price":"31.99","quantity":0,"weight":"1","shopifyproductid":"8735609159902","shopifyvariantid":"46049055375582","shopifyinventoryid":"48147774832862","shopifylocationid":"","product_id":"44645469","variant_id":"77550658","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44678683":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44678683","ebayitemid":"326283946833","shopifyproductid":"8696105763038","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8696105763038","shopifyvariantid":"45936214835422","shopifyinventoryid":"48034663792862","shopifylocationid":"","product_id":"44678683","variant_id":"77583903","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 18:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:20:07 [INFO]: Shopify Inventory id 48147774832862 2025-08-01 18:20:07 [INFO]: Shopify Location id 58450641063 2025-08-01 18:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:20:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-01 18:20:07 [INFO]: Change: available | Delta: -1 2025-08-01 18:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44645469 and user_id = 14409 2025-08-01 18:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77550658 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:20:07 [INFO]: Shopify Inventory id 48034663792862 2025-08-01 18:20:07 [INFO]: Shopify Location id 58450641063 2025-08-01 18:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:20:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-01 18:20:07 [INFO]: Change: available | Delta: -1 2025-08-01 18:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44678683 and user_id = 14409 2025-08-01 18:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77583903 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:20:07 [INFO]: updateIdsQuantity -> ["77550658","77583903"] 2025-08-01 18:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-01 18:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77550658 THEN 0 WHEN id = 77583903 THEN 0 END, quantityflag = CASE WHEN id = 77550658 THEN 0 WHEN id = 77583903 THEN 0 END WHERE user_id = 14409 AND id IN (77550658,77583903) 2025-08-01 18:20:07 [INFO]: QUANTITY Updated IDs: 77550658, 77583903 2025-08-01 18:20:07 [INFO]: Successfully processed data for user 14409 2025-08-01 18:20:07 [INFO]: Execution Started 2025-08-01 18:20:07 [INFO]: Execution Finished 2025-08-01 18:30:01 [INFO]: Execution Started 2025-08-01 18:30:01 [INFO]: old server sucessfully connected 2025-08-01 18:30:01 [INFO]: sqs client sucess created 2025-08-01 18:30:02 [INFO]: Number of messages in the queue: 1 2025-08-01 18:30:02 [INFO]: item found in queue is if condition 14409 2025-08-01 18:30:02 [INFO]: item found in queue is 14409 2025-08-01 18:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMG+Qq9/v2+uA8hSn2l3R25FvZDHuZiHU0poLtBmuj5xG/YSpwZD0zUFKOC2J+6VPFtLvanVFvXPCXnyl/plmjqfDr+MoZRxnR7ZBElcnK/xFsw2hjNp1NrzxUvXll4Vn4zVOa9b7AXijjnSATuYDN0a7sgHT5XTkGvX+fo2An8M43OkSjMaaOIZaRHmzd5hwutWCDhPPsD7KI/nfnFLZXF+weZPa933egtwf7xUw4Fg2uOux+trfJLm/ObRPPBlCxqVOocJhitLuUCsHrdtwXQoKAAR8nyivm+xhmWKLg9RPZeqP8H+lGW9dzndRegDm4Dx3BybQ7SzS3Ot1FdWZ+UvP70CFNrm7WjFZMA2jWgPsZ3kAjCOxSLghmlbf5a53fCcpMR6W64+pkcGoeuvp1LyH+aWAV5gkhdxHB0j78IRiFZVCjBzbackIeu0+th9P 2025-08-01 18:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 18:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 18:30:03 [INFO]: inside itemsold and closed 14409 2025-08-01 18:30:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:30:04 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:30:04 [INFO]: Ebay item id :: 225763880000 exists in Database 2025-08-01 18:30:04 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:30:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:30:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:30:04 [INFO]: in processold action queue is array for {"44733520":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733520","ebayitemid":"225763880000","shopifyproductid":"8124712091870","variants":[{"price":"15.99","quantity":0,"weight":"0.75","shopifyproductid":"8124712091870","shopifyvariantid":"44339554975966","shopifyinventoryid":"46437256036574","shopifylocationid":"","product_id":"44733520","variant_id":"77641405","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 18:30:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 18:30:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:30:04 [INFO]: Shopify Inventory id 46437256036574 2025-08-01 18:30:04 [INFO]: Shopify Location id 58450641063 2025-08-01 18:30:04 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18: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-01 18:30:05 [INFO]: Change: available | Delta: -1 2025-08-01 18:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733520 and user_id = 14409 2025-08-01 18:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641405 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:30:05 [INFO]: updateIdsQuantity -> ["77641405"] 2025-08-01 18:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 18:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641405 THEN 0 END, quantityflag = CASE WHEN id = 77641405 THEN 0 END WHERE user_id = 14409 AND id IN (77641405) 2025-08-01 18:30:05 [INFO]: QUANTITY Updated IDs: 77641405 2025-08-01 18:30:05 [INFO]: Successfully processed data for user 14409 2025-08-01 18:30:05 [INFO]: Execution Started 2025-08-01 18:30:05 [INFO]: Execution Finished 2025-08-01 18:40:02 [INFO]: Execution Started 2025-08-01 18:40:02 [INFO]: old server sucessfully connected 2025-08-01 18:40:02 [INFO]: sqs client sucess created 2025-08-01 18:40:03 [INFO]: Number of messages in the queue: 5 2025-08-01 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:40:03 [INFO]: item found in queue is 14409 2025-08-01 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBtRsm07AO7bqvJ9cci3rn/9KCknoPGmjjbu0XTUA5W4u+p3ozpKbxBqc6iV0Wlv3sPQ3KrBCijbjzKydZ2JXkU4uecDPwTndLvWGt4KlYuvxcI3fZhODwTZoOh49ONmtHMPiq59TFgWGHsBDcSIb9/qv5b3LcC9abnazMjESHDTpi0OtByxITmUSlAKmMWTDU/vZkqw+jMR5GvaOI+NwoFmkWzQ8ec4lIkc9lctZMla9jxjEhp3jU8rfYKc81Ff4MFabfftQNeJOAZNzLHkzPLxJ+WXdFBocROfz/44EQIG3pH0pjOGlMqXNXpLQYZfiOVAJ/LF2viWNG1cDLbuTxWyBKDyw1mpG3+g9L3VrlQ80i9wpA+xkK+HXUt1Lt95LgJQHBkSSDVNKwSF8edWf0YVHonvOSWZ1aL8q2gbbo+cN7Ylqw10scBpvtJCijw4I/ 2025-08-01 18:40:04 [INFO]: item found in queue is if condition 14409 2025-08-01 18:40:04 [INFO]: item found in queue is 14409 2025-08-01 18:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBAnwiW7z9S04emnqo5knZr5dFHYPkk0rjY244zdvubeNbsiP+lO14GopaXWykNJ7WkbcQqnnRK7HJnJ1drAf3sV8RAbI+Hqd5Elc6mvR488Kb4bDgsdyuNGkYenzzLF08R9dlF4aRw5JkFdD52xs68Qzzdfm8etNJTNHeM27cy3SN3zl+XtHsG9fHGkBO2Gr9Ivfru2JT92xzls4XzGC4MTEDUAK70RGyUG4/JBdF2qBfrT7OZijwEuagOyt87ldSdMdB5Af8hzmLet2ZFP1hOBs6yt12fifqXtwLdatbMQi7lU9Nx0G/dzyYwcLxNVXemrNQiDPHHH0Y3bSe6EQTePpJbWqRQIZ5whfcBu2zqmQB9yQowLkLp26zWEJJ9zaKwlmc/mmmD5nszYizBXXSglcOydVyhv/9Rm0n1FRxYXqzRhEMzm7xYpY42xXU0FhV 2025-08-01 18:40:04 [INFO]: item found in queue is if condition 14409 2025-08-01 18:40:04 [INFO]: item found in queue is 14409 2025-08-01 18:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBvifVg3bJsOjnx5alH7CdwYNX5EXIlaSSzOKHYOVvNkUFHHJmhHIkmepsQsqKWnPJu5ESvXD0VWWPc16P6QG/YbfbQkBmtUc/evqdkmWhfIgEeon8Hc1nnbB0bh7sLw82SZ94DEzPJONW5P0pNvQ+pwYW0YpijDws03XJlCHHXI5UITyltghS0QCXZcV/aEpuIPuuqKoUAaIg3k+RqFqu9tXWnBIBZ1KOgf4jdHhXPKfuHhVq29nrXWcYjYu1nKLH84KP8A0Qr5ddHRckh+91NiKld0pE18Ychpi76dZn79rVu9mxylarTeJ0X6ZB8/XKEvHPkwPHs5QnDZjZYiWsapoRgI/B5i9eh+IeZL0nfcmq6xD3528P7irHjwmH6hX217XVmpkBXTeLe6lRz9gxK3/f95Y73w+ZEB+VF1PE48cpqsyPlv7Nmxzuxv/dzJDB 2025-08-01 18:40:05 [INFO]: item found in queue is if condition 14409 2025-08-01 18:40:05 [INFO]: item found in queue is 14409 2025-08-01 18:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBKgkjwFPU2PFtoZmXXKaPcvdN/vnG2e0E0oUaE8ePQR9ezKXyhEsyiTMm5wuESESwXPSgh7BoTodxC7bmI3BW5hQUG5ISluG320xxQEzAimUzLcPZ7KAyxxzUKvDDgcwX5Qy0GsbtMYJwbHiJ6oijqEo8jysMcM3h5pNdGqJekTQ2L8NyS2IA84atfnJHjTUIVQ1Gu192BDcpKTM/XM0dPRY2pXoPdfaKDscfd+EjOnhRN3Ekl01bNftmwgjUYGyOJv91fUwdMwSzPn9/yimYGIwW7Yi58WSfDymJJK+dM1SVh4HmZ2DQXD4umTRyETVdDaQvJlfm1xZU7cD/kjECGXNZkCkesCqbmV3+//v/S9DKH98MBpy1qGRtMkj9dBTLlS67bDsriOebYNkBK11NtBvDdopKk3hI5t4WP5UvKQzu/8UjlUXCmzh1iD+WCuuu 2025-08-01 18:40:05 [INFO]: item found in queue is if condition 14409 2025-08-01 18:40:05 [INFO]: item found in queue is 14409 2025-08-01 18:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB2aCeLy6agG2VxRsLNLjFqLSY4OBz69hEVp6WT/lTAL6qeMX+MsI257YRDNq01+ZbHdlp2yi7dIDhkZ/KX9VuuxJ/Td1KGzuAXgP9Brg/EepvwmZXqjYKaq3ZlGtUI+NGKo3I4VgDQmzXdefNh0rLlSmW7GDYJUT+LLwRt5N8a0Qii5kbmTdj2Vf3FJIqrGm+flAtf8B8Ig/xtx1PW3l73x6vqfUHxHYaHal9h1Tw9OIen6LcFmKqKWVZiV+leYiUN84TPbqw4YBy/er9vqonPyGxKUA9QYZ1g8CQ3QCE+4pf/Rn2B+eXi3Rl4WMZmjhiX94TXDNPu4Rh4CWnIVjA860geBVsHw+k6gJvIOUETi4Nx3YyLJ8molw0wtjKsK8RImqh3AgBEZuiK+ju2EgOrHg1o+oL1hbZE2sP7v5QVNZYri09/F7zeA7gSY1ZNl8P 2025-08-01 18:40:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-01 18:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 18:40:05 [INFO]: inside itemsold and closed 14409 2025-08-01 18:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:40:07 [INFO]: Ebay item id :: 404620151765 exists in Database 2025-08-01 18:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:40:07 [INFO]: inside itemsold and closed 14409 2025-08-01 18:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:40:09 [INFO]: Ebay item id :: 285740748558 exists in Database 2025-08-01 18:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:40:09 [INFO]: inside itemsold and closed 14409 2025-08-01 18:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:40:10 [INFO]: Ebay item id :: 306366649408 exists in Database 2025-08-01 18:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:40:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 18:40:10 [INFO]: inside itemsold and closed 14409 2025-08-01 18:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:40:12 [INFO]: Ebay item id :: 405124494501 exists in Database 2025-08-01 18:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:40:12 [INFO]: inside itemsold and closed 14409 2025-08-01 18:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:40:14 [INFO]: Ebay item id :: 257008807053 exists in Database 2025-08-01 18:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:40:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 18:40:14 [INFO]: in processold action queue is array for {"44638138":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638138","ebayitemid":"404620151765","shopifyproductid":"8242063966430","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8242063966430","shopifyvariantid":"44622317256926","shopifyinventoryid":"46720297173214","shopifylocationid":"","product_id":"44638138","variant_id":"77543327","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771802":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771802","ebayitemid":"285740748558","shopifyproductid":"8303377121502","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8303377121502","shopifyvariantid":"44851996426462","shopifyinventoryid":"46950040764638","shopifylocationid":"","product_id":"44771802","variant_id":"77680344","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45157555":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45157555","ebayitemid":"306366649408","deleted":1}},"44682051":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44682051","ebayitemid":"405124494501","shopifyproductid":"8694952526046","variants":[{"price":"149.99","quantity":0,"weight":"3","shopifyproductid":"8694952526046","shopifyvariantid":"45933634158814","shopifyinventoryid":"48032085344478","shopifylocationid":"","product_id":"44682051","variant_id":"77587276","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45205965":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45205965","ebayitemid":"257008807053","deleted":1}}} 2025-08-01 18:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 18:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:40:14 [INFO]: productIds WHich are having null productid -> [45157555,45205965] 2025-08-01 18:40:14 [INFO]: ebayItemIds WHich are not imported-> ["306366649408","257008807053"] 2025-08-01 18:40:14 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 18:40:14 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 18:40:14 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45157555,45205965) 2025-08-01 18:40:14 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 18:40:14 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 18:40:14 [INFO]: Transaction committed successfully. 2025-08-01 18:40:14 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 18:40:14 [INFO]: Shopify Inventory id 46720297173214 2025-08-01 18:40:14 [INFO]: Shopify Location id 58450641063 2025-08-01 18:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:40:14Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-01 18:40:14 [INFO]: Change: available | Delta: -4 2025-08-01 18:40:14 [INFO]: Change: on_hand | Delta: -4 2025-08-01 18:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638138 and user_id = 14409 2025-08-01 18:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77543327 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:40:14 [INFO]: Shopify Inventory id 46950040764638 2025-08-01 18:40:14 [INFO]: Shopify Location id 58450641063 2025-08-01 18:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:40:14Z","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-01 18:40:15 [INFO]: Change: available | Delta: -1 2025-08-01 18:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771802 and user_id = 14409 2025-08-01 18:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680344 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:40:15 [INFO]: Shopify Inventory id 48032085344478 2025-08-01 18:40:15 [INFO]: Shopify Location id 58450641063 2025-08-01 18:40:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18:40:15Z","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-01 18:40:15 [INFO]: Change: available | Delta: -1 2025-08-01 18:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44682051 and user_id = 14409 2025-08-01 18:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77587276 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:40:15 [INFO]: updateIdsQuantity -> ["77543327","77680344","77587276"] 2025-08-01 18:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-01 18:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77543327 THEN 0 WHEN id = 77680344 THEN 0 WHEN id = 77587276 THEN 0 END, quantityflag = CASE WHEN id = 77543327 THEN 0 WHEN id = 77680344 THEN 0 WHEN id = 77587276 THEN 0 END WHERE user_id = 14409 AND id IN (77543327,77680344,77587276) 2025-08-01 18:40:15 [INFO]: QUANTITY Updated IDs: 77543327, 77680344, 77587276 2025-08-01 18:40:15 [INFO]: Successfully processed data for user 14409 2025-08-01 18:40:15 [INFO]: Execution Started 2025-08-01 18:40:15 [INFO]: Execution Finished 2025-08-01 18:50:01 [INFO]: Execution Started 2025-08-01 18:50:01 [INFO]: old server sucessfully connected 2025-08-01 18:50:01 [INFO]: sqs client sucess created 2025-08-01 18:50:03 [INFO]: Number of messages in the queue: 2 2025-08-01 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 18:50:03 [INFO]: item found in queue is 14409 2025-08-01 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB0aMf9eumSZExO9J6O43lXW59ReGGtLSzOLZ5gsSoUfwqvh0GCQF1ASlaf9nmuox3dywMShe4qkakDPRbGNGzyCa+64TZ3aqyQ6KQAvK8duAQ79BoFXM7sCk/E3Qp7ASKeQVrep5OeYTwih9BIngA+3rWPA75ARZMfiA2eMHKMKEPVgXtXfEpUz6JogqoOsLC8F+z7HbTdWs3o4UssUPyKtpWrpeghWnZYIAjHrckUejfPOCERyIJka0ACLQvEFKTZBecQXlHH5WBL7c2cbdXvEXPoQ3vFe3ZQ1Iyw6E1Gbsm0XLVZIagmZuoOj+tYjo8mWjoxy86TsC4XjhM0pHe3ePkYy4oPHNvK7b0fB36p3HCeLkPG8prsAj5aeggF3Cy7MwWAAQEFhLvwM53OUYHFbM/X+P6Zp+kBNiXD6URSx+X0GrV0kNLibf/72lvltDG 2025-08-01 18:50:04 [INFO]: item found in queue is if condition 14409 2025-08-01 18:50:04 [INFO]: item found in queue is 14409 2025-08-01 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBZAmbrMNa2Ck+SfJJJ74iVaFyiZXsybAMwQY0Zax7ghMh7OdQBFL4F9ZIeRrX7tmnt6NLCiND0+ofjt1uyL9uFQJEcLPnAEK/KOUkYQKIWr7u1vmdM5wuYtGyDvgLzl4PI3IBKOZ9MwB344YynePAFrLZVAxTPbhnYHWYlama8yRWoi5h+8QcEaAQrdSeiHhK0jIPyhb3zCT9rObsVZJ1LKqm07vSUqL0HdIV6CIAMlb6Vm06o5h8bw0SzkZx+Eir6D3kpvorxBgmV58dyoX0a82bSgYnbFeKwRZWmhJmwa0pKlxI4Domqsj5V8ydTxXP3Khtwf4IrH54LyXrPPGhEglU5YQ8HICsNEDC8JZr/cWtSNUGVZ9QpAbIXm9/6LGJQSMINEoxzLZBzvy8aNuR2m8lSkzGZJvBXQHibys5Kk8Yo8HtqjUH2ea90l3nFgPi 2025-08-01 18:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 18:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 18:50:04 [INFO]: inside itemsold and closed 14409 2025-08-01 18:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:50:06 [INFO]: Ebay item id :: 326546598268 exists in Database 2025-08-01 18:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 18:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 18:50:06 [INFO]: inside itemsold and closed 14409 2025-08-01 18:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 18:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-01 18:50:08 [INFO]: Ebay item id :: 306413608091 exists in Database 2025-08-01 18:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-01 18:50:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 18:50:08 [INFO]: in processold action queue is array for {"44670474":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670474","ebayitemid":"326546598268","shopifyproductid":"8885237448926","variants":[{"price":"24.99","quantity":0,"weight":"0.75","shopifyproductid":"8885237448926","shopifyvariantid":"46639661252830","shopifyinventoryid":"48742626689246","shopifylocationid":"","product_id":"44670474","variant_id":"77575694","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45292711":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45292711","ebayitemid":"306413608091","deleted":1}}} 2025-08-01 18:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 18:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 18:50:08 [INFO]: productIds WHich are having null productid -> [45292711] 2025-08-01 18:50:08 [INFO]: ebayItemIds WHich are not imported-> ["306413608091"] 2025-08-01 18:50:08 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 18:50:08 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 18:50:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45292711) 2025-08-01 18:50:08 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 18:50:08 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 18:50:08 [INFO]: Transaction committed successfully. 2025-08-01 18:50:08 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 18:50:08 [INFO]: Shopify Inventory id 48742626689246 2025-08-01 18:50:08 [INFO]: Shopify Location id 58450641063 2025-08-01 18:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 18:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T18: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-01 18:50:08 [INFO]: Change: available | Delta: -1 2025-08-01 18:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-01 18:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 18:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670474 and user_id = 14409 2025-08-01 18:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575694 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 18:50:08 [INFO]: updateIdsQuantity -> ["77575694"] 2025-08-01 18:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 18:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77575694 THEN 0 END, quantityflag = CASE WHEN id = 77575694 THEN 0 END WHERE user_id = 14409 AND id IN (77575694) 2025-08-01 18:50:08 [INFO]: QUANTITY Updated IDs: 77575694 2025-08-01 18:50:08 [INFO]: Successfully processed data for user 14409 2025-08-01 18:50:08 [INFO]: Execution Started 2025-08-01 18:50:08 [INFO]: Execution Finished