2025-07-31 19:00:02 [INFO]: Execution Started 2025-07-31 19:00:02 [INFO]: old server sucessfully connected 2025-07-31 19:00:02 [INFO]: sqs client sucess created 2025-07-31 19:00:03 [INFO]: Number of messages in the queue: 6 2025-07-31 19:00:03 [INFO]: item found in queue is if condition 14409 2025-07-31 19:00:03 [INFO]: item found in queue is 14409 2025-07-31 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBC361O6ozWIZoB/J8+4xJopQouj1DZU2KSzeV4p5wRiGs2BsSjBG/ZW2p9qYGKdZK5XZkPLNI2yl4vsAbP+LxI3TcKPgVse4BDjmGA4zv5BuTgzJAGioK4BCzbNM27nlges++Tfw4fyy6aTHmpwys1hUeQj2PPs9ndTJRh+pFQn8ha7kZjfHvm9MZiEFij+Vxa9zbN/gfTJCrjrRZlz2EOF0TA2EbURY2mC86YMKrIUy1WDP8enjAAPpD1KMEN7zljYXYWLviI3MyWmU/yPbYU7RkdfL+lZGy8HsV/OocSpbMMlKJXzitIdr1sdLT9sfD7gGUl47+/XHwbHPRBi0NNCsrubjg1Awrm34A+T0Dy2udnVfopiEQn9q0XoiQJtMeCDXd4Qi2/KFK2DPDX1VT5HNxCztcLrL6fdmFXffLG5bCgN+5p5bq0+zEu06q1jlY 2025-07-31 19:00:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:00:04 [INFO]: item found in queue is 14409 2025-07-31 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvvs9iMukNf+lC+1nhoj2kExHrXuAlT2cgey9oBhjSDB3LOvegKTgdHoLt5m7OZRF/vrUqepcotFD94H6D6ub9s5m6gvlE8PgCn96Hl2jOv5IRNTNDaob9wGmFXJHxbhqHkonhURFO/Q1T1fNCD0HIIShIMXX273oObWvxGRAZY+L1zV0DaapyZChBtIFmxW+4Qx2k2LpdlNtqJyGw7/O51Siis8gK7RbbtIICRSoBt+/1US24+bZBwX56271oBvP3hYFUdl1rPva1aOBiKUumxhwrUm24dIoDb2L9mvUWPXsepBIMHRJX7SnwYRvet3UOFTDAEub67P6OIcqCbvrSThEXH5IX1yJau6tUJCKY17K5j4pf58rllDvAw/QZPWBebtslxvYGwIFj75oLYh1g/nsZSNcNF+xhffezSMzaAPY5uvepFFJNte1Ke7CfBet 2025-07-31 19:00:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:00:04 [INFO]: item found in queue is 14409 2025-07-31 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEB5Tn70XxnG2PNChjXi84DNIxL8qXRP39bB4xMiDSfkADykr/cRddzsi7qSfWYZEdLeAqF7dM7SLG87OPUTxZjkGhmT/MyG70nXjFu4XkbtifJ5WYFEGFpJOds1m6f0P4CCRkn8rTpmLNS3vp1tlnQ+DGFOTs4xbuAGr7GE0b9GZoDmsT3fIWb851bfBKVj5hphnfQk734SUPvzGRhStj360tAQvI3bVqx/W1RkSbgdh9LANYoq1hCK2eOm1V8kwM2v/G+A3CRGQVSmSceB0p26liSS5YCV11ng1Aiteh+ZW1yDdpTny2pTCxPHknXV2dhgyG5pBb2WbhK4RNrLW6gIi50xwMRmKfMmoX7XqIJFcOY1lVufjuAKhIn4p+pLu0/747Cmbwd7vx4qOUy13h59b75pjtRq1enOGehNRS6BOE2aMMtan9SBm2oDDKbN9Fr 2025-07-31 19:00:05 [INFO]: item found in queue is if condition 14409 2025-07-31 19:00:05 [INFO]: item found in queue is 14409 2025-07-31 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBvUZ1+kg07J+vuei7PHAFTLO/gPKYUofZIyP27mz1lKomqbNffe+qznjgOXzJtFyD+e8rrQ7jfbzZ/aB6vJKIIgaMGrYPlpexUhIfsgpYta2O3xxSF9s/OK1nmh77g8XhXcH6TZPLwjL0cnhtXlJu65LcvqxivF0CvDfy9U7eiq5a3WSw8vqPq06A0jasvOl91rreLPyA+nXF6+LlnyNGAjE/Mg18t4/VuizOnqyE/iqBUNznMG/Kkmp9PgImRA3WMADh5TVJgKGYWBKKHVhmCrnCp4bMoZsIYbLBpCMMfjwfldfn1GA+Wny+O+jt9YU4lIqklA02mUFy9hCkGJjR9Bm7wy1U1Mi8ptqfhgsl/WI6RPrfbJg8hB+rbNOlJB1XkQAFWtYLCriiQ6iGj9fdh305kei71PySWex4HFsrTUJA6spB4U9pdoD/QyHpb+pU 2025-07-31 19:00:05 [INFO]: item found in queue is if condition 14409 2025-07-31 19:00:05 [INFO]: item found in queue is 14409 2025-07-31 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBOxX0pwrc1hIRAWKBjhrz6/U/LnsgGvXQPfQyJNLB0+Hdp1P8rjoh1fwQ1d0PrBtjhAry8hWuTbyvJ9YuJxdVm6zePuAriRFYFB56+zDW6S7/+zzpX7rBKScQg+oSdEiGcGM1L/QfWH78IWp/YtZ6GnZa6+AkuKc91hTKEyiNxOQ2DJ2sjMOZbnAotllNvPfrpAhEdXnpAJQsgx250HRJc7CDrIi6g/IcCOI+T90lDzV5hOzAFy+/viAZqxMaWkbE1Z+t5CXBRdtWkuBxjNzwVTrOKftFAhTQ/EMo0NDcgH8J0KAn9E9Oo10G3H1Xo70o9aCJMWLKMrElLHNaOAHwVC5AFXV6lgLYIXi606I5IGdl6oc3MmnxZqq9AmAOJRdMv9keMC0QLBdO751Pq/o9NEKWDOpkOrxY3z7YTuWpht2Bp5fJPF1SC6hVkkBP+0sy 2025-07-31 19:00:06 [INFO]: item found in queue is if condition 14409 2025-07-31 19:00:06 [INFO]: item found in queue is 14409 2025-07-31 19:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBKAsGSse6wbWxQ/IjFF+gOatO6IEDfYTADt1FejB0fqYB08vdUTOJMu6u7mEFX6mQ2TzE8oi8hmrQT2LBz2mSP2YeQwZuV+0apoK1vmzNu1bn7lUDDZsV9uqf3CsJNS9cg1O4SvfkHHB/KmixXTHAjcT8cgSlTJ62S8X4EI7WeSVhzbFdhVKnHPt/wliguqvwZ7RjzGkEOYYfE4hAJC0vVTkitWkTHStYg42+MnzqKNInsrLpDJ2CxDQteTTbllhFeQfz1bVL10u5XzxE3tE8B0RXSefbF9stjq6k4CGo6FDaT/VaVPrgELQ5KMmve4cAyLJBaURQMt1hu1hvSoNH0cxmcVW4C7p6VGrPCYhMXU7/AASHUOODChLzLR808t5/67bRFQEzbVxswkBrtPGc0+hJ71e14oIUv2kiJkMyOiB00lpWYsSVVHOl/ICHDe82 2025-07-31 19:00:06 [INFO]: Processed 6 messages, reached the limit of 6. 2025-07-31 19:00:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 19:00:06 [INFO]: inside itemsold and closed 14409 2025-07-31 19:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:00:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:00:08 [INFO]: Ebay item id :: 305804195825 exists in Database 2025-07-31 19:00:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:00:08 [INFO]: inside itemsold and closed 14409 2025-07-31 19:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:00:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:00:10 [INFO]: Ebay item id :: 326440392384 exists in Database 2025-07-31 19:00:10 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:00:10 [INFO]: inside itemsold and closed 14409 2025-07-31 19:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:00:11 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:00:11 [INFO]: Ebay item id :: 286728713482 exists in Database 2025-07-31 19:00:11 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:00:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-07-31 19:00:11 [INFO]: inside itemsold and closed 14409 2025-07-31 19:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:00:13 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:00:13 [INFO]: Ebay item id :: 226715707998 exists in Database 2025-07-31 19:00:13 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:00:13 [INFO]: inside itemsold and closed 14409 2025-07-31 19:00:15 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:00:15 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:00:15 [INFO]: Ebay item id :: 306264033424 exists in Database 2025-07-31 19:00:15 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:00:15 [INFO]: inside itemsold and closed 14409 2025-07-31 19:00:16 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:00:16 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:00:16 [INFO]: Ebay item id :: 305786831231 exists in Database 2025-07-31 19:00:16 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:00:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:00:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:00:16 [INFO]: in processold action queue is array for {"44590162":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44590162","ebayitemid":"305804195825","shopifyproductid":"8696059822302","variants":[{"price":"54.99","quantity":0,"weight":"2","shopifyproductid":"8696059822302","shopifyvariantid":"45936060596446","shopifyinventoryid":"48034509521118","shopifylocationid":"","product_id":"44590162","variant_id":"77482871","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44737055":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737055","ebayitemid":"326440392384","shopifyproductid":"8828585902302","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8828585902302","shopifyvariantid":"46324179894494","shopifyinventoryid":"48425364357342","shopifylocationid":"","product_id":"44737055","variant_id":"77644992","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45293243":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45293243","ebayitemid":"286728713482","deleted":1}},"44667800":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44667800","ebayitemid":"226715707998","shopifyproductid":"8885234401502","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8885234401502","shopifyvariantid":"46639653945566","shopifyinventoryid":"48742619381982","shopifylocationid":"","product_id":"44667800","variant_id":"77573020","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44586977":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586977","ebayitemid":"306264033424","shopifyproductid":"8885222244574","variants":[{"price":"287.99","quantity":0,"weight":"2","shopifyproductid":"8885222244574","shopifyvariantid":"46639627600094","shopifyinventoryid":"48742593036510","shopifylocationid":"","product_id":"44586977","variant_id":"77479686","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44575690":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575690","ebayitemid":"305786831231","shopifyproductid":"7645533143262","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7645533143262","shopifyvariantid":"42772185776350","shopifyinventoryid":"44866719318238","shopifylocationid":"","product_id":"44575690","variant_id":"77468397","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 19:00:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 19:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:00:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:00:16 [INFO]: productIds WHich are having null productid -> [45293243] 2025-07-31 19:00:16 [INFO]: ebayItemIds WHich are not imported-> ["286728713482"] 2025-07-31 19:00:16 [INFO]: Entered in bulkUpdateProducts function 2025-07-31 19:00:16 [INFO]: Transaction started for bulkUpdateProducts 2025-07-31 19:00:16 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45293243) 2025-07-31 19:00:16 [INFO]: Query executed successfully. Affected rows: 0 2025-07-31 19:00:16 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-07-31 19:00:16 [INFO]: Transaction committed successfully. 2025-07-31 19:00:16 [INFO]: Transaction ended for bulkUpdateProducts 2025-07-31 19:00:16 [INFO]: Shopify Inventory id 48034509521118 2025-07-31 19:00:16 [INFO]: Shopify Location id 58450641063 2025-07-31 19:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:00:17Z","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-07-31 19:00:17 [INFO]: Change: available | Delta: -1 2025-07-31 19:00:17 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44590162 and user_id = 14409 2025-07-31 19:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482871 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:00:17 [INFO]: Shopify Inventory id 48425364357342 2025-07-31 19:00:17 [INFO]: Shopify Location id 58450641063 2025-07-31 19:00:17 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:00:17Z","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-07-31 19:00:17 [INFO]: Change: available | Delta: 1 2025-07-31 19:00:17 [INFO]: Change: on_hand | Delta: 1 2025-07-31 19:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737055 and user_id = 14409 2025-07-31 19:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644992 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:00:17 [INFO]: Shopify Inventory id 48742619381982 2025-07-31 19:00:17 [INFO]: Shopify Location id 58450641063 2025-07-31 19:00:17 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:00:17 [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-07-31 19:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44667800 and user_id = 14409 2025-07-31 19:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77573020 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:00:17 [INFO]: Shopify Inventory id 48742593036510 2025-07-31 19:00:17 [INFO]: Shopify Location id 58450641063 2025-07-31 19:00:17 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:00:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:00:17Z","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-07-31 19:00:18 [INFO]: Change: available | Delta: 1 2025-07-31 19:00:18 [INFO]: Change: on_hand | Delta: 1 2025-07-31 19:00:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:00:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586977 and user_id = 14409 2025-07-31 19:00:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479686 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:00:18 [INFO]: Shopify Inventory id 44866719318238 2025-07-31 19:00:18 [INFO]: Shopify Location id 58450641063 2025-07-31 19:00:18 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:00:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:00:18Z","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-07-31 19:00:18 [INFO]: Change: available | Delta: -1 2025-07-31 19:00:18 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:00:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:00:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575690 and user_id = 14409 2025-07-31 19:00:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468397 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:00:18 [INFO]: updateIdsQuantity -> ["77482871","77644992","77573020","77479686","77468397"] 2025-07-31 19:00:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-07-31 19:00:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77482871 THEN 0 WHEN id = 77644992 THEN 0 WHEN id = 77573020 THEN 0 WHEN id = 77479686 THEN 0 WHEN id = 77468397 THEN 0 END, quantityflag = CASE WHEN id = 77482871 THEN 0 WHEN id = 77644992 THEN 0 WHEN id = 77573020 THEN 0 WHEN id = 77479686 THEN 0 WHEN id = 77468397 THEN 0 END WHERE user_id = 14409 AND id IN (77482871,77644992,77573020,77479686,77468397) 2025-07-31 19:00:18 [INFO]: QUANTITY Updated IDs: 77482871, 77644992, 77573020, 77479686, 77468397 2025-07-31 19:00:18 [INFO]: Successfully processed data for user 14409 2025-07-31 19:00:18 [INFO]: Execution Started 2025-07-31 19:00:18 [INFO]: Execution Finished 2025-07-31 19:10:01 [INFO]: Execution Started 2025-07-31 19:10:01 [INFO]: old server sucessfully connected 2025-07-31 19:10:01 [INFO]: sqs client sucess created 2025-07-31 19:10:02 [INFO]: Number of messages in the queue: 0 2025-07-31 19:10:23 [INFO]: Execution Started 2025-07-31 19:10:23 [INFO]: Execution Finished 2025-07-31 19:20:02 [INFO]: Execution Started 2025-07-31 19:20:02 [INFO]: old server sucessfully connected 2025-07-31 19:20:02 [INFO]: sqs client sucess created 2025-07-31 19:20:03 [INFO]: Number of messages in the queue: 3 2025-07-31 19:20:03 [INFO]: item found in queue is if condition 14409 2025-07-31 19:20:03 [INFO]: item found in queue is 14409 2025-07-31 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPfPwMY0SrBiyNvLpRUV5B6t6ceL4hKO6hYFHaazinBjWbxQykaTQ7S2TOCMQkaVhSVTtAnAxpr5ilXcU23qwiywsQlsebT7XphhJuNL9w0MiHD+kMWcb1rMiMi5vOHH/nZ60ybzA3j6BNh7Ipfz+o1fxhnrcvIG0mwgK44jvqGNoEizFJWSjV06HIytvTX0cHdoujAaOjjKXXe1oaSW1ksPy4FfowXoegE2zr6QKbqyq10LIy9OtPOos157erUD+Mw53A/tfYDuK48JlMszhyDGEJ7DCBSxpx7zuOs55F1fkCu2nDsVnaQIqjDbElE+lyCh2EusafvS6QWUBKt7Y9jvoP+TUFtmfKqV47G/6bywEh2MBqEyLQSWJoKybmRx2yWH5tqKl2p5zrqJ7J6Ki3u10KeAorStk6Wuo7VWbeHkyehHaitbyTbNWGlxVrzuI 2025-07-31 19:20:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:20:04 [INFO]: item found in queue is 14409 2025-07-31 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBzKSEI2q2zIOnyX0QTxShtciITqqjluQIIv/pPQMgDeoeHoLt6asgZGuY1QfK5A/jhIFSDimYM+72o3pw5JPJDVzd5aW7Jz0+8jxvA5aOwv9oh7sxLFuA+oqeqea7On6X25tVTr7zTt6/sTaqiVD419XHSUlTj8sxj71ZcM6MrxXdAv3VsOqMNp4o5OZrtSsX9b7jBvcDPR+9lKHctbNfNu+mjTcAVTEiNo5iFq/DaWf/sV8pPOwKFZnp8sXN4E/fU3OviGrbGw7ko+mR+2QTwzx5Fi9GqHSyMrFaJqmBH3VtbH03rXDNlaKrvFyQrx3vTGY5hkjXUmO/XUGbhBKQsvVNejkYNJJikj5dTnZyTv4iquCQwjz73CwaDbNJQ/DHskfCJnRVXKJX1tNMisGkN+7R1hEkhcubEXSjvVPbi7d4nAxXvBQPgESDUWQLrd+t 2025-07-31 19:20:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:20:04 [INFO]: item found in queue is 14409 2025-07-31 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBoQFfaXAGbZh0OOgjQzL852uAG1G2qKTh5wB4/j9gySYvZXt93O8OwTPO1YaAqUiCzmqtB86J5oXzdtMCEKYmfjxz1EXNMD+/f2l3GerNmWXfvLEyAS/lQ2Tg36wNSf2SDgOKWIoGl8vnOfMYJZ0603syj63ngBQB83nS2TCT4IlCVb1o95PYpnguZ3Dgnh2n717mrdjEKzbzMc9pWuf0nJXW0xsvkGG8GUuohCLvTZtGK7ArBxqjtjQwfpz3CPX8bSjeR0X1AOgyJN9gQ1V/qWaZCNzh3Ohz2vHn9nzA8ULChsCtk11yoptS2slQVtkruxPeP83Yqfo9sPiI83L6zVaIZ5Ig9nwCDsCCFuR8eDVlILw7lSlC8TvKWyOwbNQm0qsfdFyWseU3acuNurMYn8NEkzCC5dabMtZBJKvu03+m0KYi525IzFV1fdsU13Mc 2025-07-31 19:20:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-07-31 19:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 19:20:04 [INFO]: inside itemsold and closed 14409 2025-07-31 19:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:20:06 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:20:06 [INFO]: Ebay item id :: 335538880396 exists in Database 2025-07-31 19:20:06 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:20:06 [INFO]: inside itemsold and closed 14409 2025-07-31 19:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:20:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:20:08 [INFO]: Ebay item id :: 405887089132 exists in Database 2025-07-31 19:20:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:20:08 [INFO]: inside itemsold and closed 14409 2025-07-31 19:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:20:09 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:20:09 [INFO]: Ebay item id :: 285884404478 exists in Database 2025-07-31 19:20:09 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:20:09 [INFO]: in processold action queue is array for {"44583699":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44583699","ebayitemid":"335538880396","shopifyproductid":"8483291922654","variants":[{"price":"47.99","quantity":0,"weight":"2","shopifyproductid":"8483291922654","shopifyvariantid":"45363372490974","shopifyinventoryid":"47461331828958","shopifylocationid":"","product_id":"44583699","variant_id":"77476408","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44834235":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44834235","ebayitemid":"405887089132","shopifyproductid":"8926436720862","variants":[{"price":"10.99","quantity":0,"weight":"1","shopifyproductid":"8926436720862","shopifyvariantid":"46838183657694","shopifyinventoryid":"48936672755934","shopifylocationid":"58450641063","product_id":"44834235","variant_id":"77744925","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44597615":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44597615","ebayitemid":"285884404478","shopifyproductid":"8523270488286","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8523270488286","shopifyvariantid":"45462359408862","shopifyinventoryid":"47560343060702","shopifylocationid":"","product_id":"44597615","variant_id":"77490324","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 19:20:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 19:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:20:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:20:09 [INFO]: Shopify Inventory id 47461331828958 2025-07-31 19:20:09 [INFO]: Shopify Location id 58450641063 2025-07-31 19:20:09 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19: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-07-31 19:20:10 [INFO]: Change: available | Delta: -1 2025-07-31 19:20:10 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44583699 and user_id = 14409 2025-07-31 19:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77476408 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:20:10 [INFO]: Shopify Inventory id 48936672755934 2025-07-31 19:20:10 [INFO]: Shopify Location id 58450641063 2025-07-31 19:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19: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-07-31 19:20:10 [INFO]: Change: available | Delta: -1 2025-07-31 19:20:10 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44834235 and user_id = 14409 2025-07-31 19:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77744925 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:20:10 [INFO]: Shopify Inventory id 47560343060702 2025-07-31 19:20:10 [INFO]: Shopify Location id 58450641063 2025-07-31 19:20:10 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19: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-07-31 19:20:10 [INFO]: Change: available | Delta: -1 2025-07-31 19:20:10 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44597615 and user_id = 14409 2025-07-31 19:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490324 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:20:10 [INFO]: updateIdsQuantity -> ["77476408","77744925","77490324"] 2025-07-31 19:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-07-31 19:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77476408 THEN 0 WHEN id = 77744925 THEN 0 WHEN id = 77490324 THEN 0 END, quantityflag = CASE WHEN id = 77476408 THEN 0 WHEN id = 77744925 THEN 0 WHEN id = 77490324 THEN 0 END WHERE user_id = 14409 AND id IN (77476408,77744925,77490324) 2025-07-31 19:20:10 [INFO]: QUANTITY Updated IDs: 77476408, 77744925, 77490324 2025-07-31 19:20:10 [INFO]: Successfully processed data for user 14409 2025-07-31 19:20:10 [INFO]: Execution Started 2025-07-31 19:20:10 [INFO]: Execution Finished 2025-07-31 19:30:01 [INFO]: Execution Started 2025-07-31 19:30:01 [INFO]: old server sucessfully connected 2025-07-31 19:30:01 [INFO]: sqs client sucess created 2025-07-31 19:30:02 [INFO]: Number of messages in the queue: 3 2025-07-31 19:30:03 [INFO]: item found in queue is if condition 14409 2025-07-31 19:30:03 [INFO]: item found in queue is 14409 2025-07-31 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBX73XdJ7+gMp8YuoAIuthHuAEDbiTjjmmpGU19KBUB0tqi71pFJT4ZCbFh6KLqQHmTtkQHT9RSx5Qq4LRLfSg9Ub5Hovzflz5dIq/m+n+8M4nmWoaaM6ntmpV+4EFajNpqhDps7Ej4a4xsBidCJVmJ9spU9y1g53tqhLzjhRAhand0REugpBs3jK4CO/5jMiajCMocau2IE6UFvx1WEj60OB3XxgLUf2mlJ7Bi4mhdBKkiDoZle1/Ummj9XMeQLYJn/Knf+geRMPezgs2jv0zf3TKz7BbbFKKxf41ec+jwya9FpemvdwSGXbHMIAjOj/v/I8su1QjDLFJzEk5VbI/Wge8k2rMvbvendMR8tIYjcmqfrNxNKI3nkjIssnccFhR2bBHvbgijNx/3VpHghawje2Sv2k02ZlZmi+iMd3bleamliKiVr+U86RBuCieldCR 2025-07-31 19:30:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:30:04 [INFO]: item found in queue is 14409 2025-07-31 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB/dS52PbwipGpQI+KlMHyP3ltHhbC42PoP8H6ZmQa2uoXd48zXiggXSBqOTpJxogSam3+omVdKwYPurGAdgPspk+0KxhjqQ1BPh1PjbMWPYTcdZVzTiGnhCq7raj8ZsD4ammZ0YRzGlyA9KvK55PL0uuksG6BCeUlbTb+cOfBCBjl/gbjAIzDX4gZaYvgGKQbDyGxMw5goaKwLhqGJAoJN75LSXbVY9kK1dpRv//oh37OylgR4u6T9M2c9Sj+EQy32cBiOF+96FOGnFEEMIaJGnhG5x08QkAsfEyoIzQz6Mu3ZWYePKcK/FvJKJ7YaDmFbko2TjVYt08jenU1xJuRjcAL0kwD1n08n44fnQ9syFeZiC+tyKnijSmVZI/EXnmBGO8uP9+63qBjrniqkK/7NKPuZu80ub+fXtVujdHMbcv3p+U+nIj5siOl+yuGs6ZD 2025-07-31 19:30:05 [INFO]: item found in queue is if condition 14409 2025-07-31 19:30:05 [INFO]: item found in queue is 14409 2025-07-31 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB2/YSARk+qjYuzYRklc8EmgVbHALtDt4fzaKFbHvC/AvOVgyWqHiKS8KgiP9sfQ0hxkUvOn5HLUiw+S2L+yMjuEPCXLMtLOmnqBjxMy1g86lGd4O7HUCYUyi3wBd0m5o/FLB1wHxIfrT6g34I2xx3dtySzQT0onxPxk1lTGcmO13HsQkj1ELRSoTsQYZRyDMkQ9A20j08pdLtXCywG5LSZC3o9UWn31kIR714z5fhagPw9HYKglrGrq4cW4o5yEz+o7uFPG0P6DtYCTMckpbcZ5oZWpAZXEntZcM3dSIWfso96hvTsn9iIHS+UKWBBfBICb10flWRKr95c+xfVTUaBP1uE9OX/48MXTA89T6vfIqdD1difW3xz336QCxQuj6OXJfkXJU3DK93tn3J8eLCjp9/7qKPi2uIfH28U10FCh0xW9iQ9dKUzdHeRQWoN96j 2025-07-31 19:30:05 [INFO]: Processed 3 messages, reached the limit of 3. 2025-07-31 19:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 19:30:05 [INFO]: inside itemsold and closed 14409 2025-07-31 19:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:30:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:30:07 [INFO]: Ebay item id :: 286398969919 exists in Database 2025-07-31 19:30:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:30:07 [INFO]: inside itemsold and closed 14409 2025-07-31 19:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:30:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:30:08 [INFO]: Ebay item id :: 335490209289 exists in Database 2025-07-31 19:30:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:30:08 [INFO]: inside itemsold and closed 14409 2025-07-31 19:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:30:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:30:10 [INFO]: Ebay item id :: 325400687410 exists in Database 2025-07-31 19:30:10 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:30:10 [INFO]: in processold action queue is array for {"44566349":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566349","ebayitemid":"286398969919","shopifyproductid":"8838177325278","variants":[{"price":"22.99","quantity":0,"weight":"0.75","shopifyproductid":"8838177325278","shopifyvariantid":"46352376496350","shopifyinventoryid":"48454099665118","shopifylocationid":"","product_id":"44566349","variant_id":"77459029","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576483":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576483","ebayitemid":"335490209289","shopifyproductid":"8697545720030","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8697545720030","shopifyvariantid":"45939382386910","shopifyinventoryid":"48037842092254","shopifylocationid":"","product_id":"44576483","variant_id":"77469190","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681120":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681120","ebayitemid":"325400687410","shopifyproductid":"7855365226718","variants":[{"price":"9.99","quantity":0,"weight":"0","shopifyproductid":"7855365226718","shopifyvariantid":"43588233363678","shopifyinventoryid":"45683894681822","shopifylocationid":"","product_id":"44681120","variant_id":"77586340","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 19:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 19:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:30:10 [INFO]: Shopify Inventory id 48454099665118 2025-07-31 19:30:10 [INFO]: Shopify Location id 58450641063 2025-07-31 19:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:30: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-07-31 19:30:10 [INFO]: Change: available | Delta: 1 2025-07-31 19:30:10 [INFO]: Change: on_hand | Delta: 1 2025-07-31 19:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566349 and user_id = 14409 2025-07-31 19:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459029 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:30:10 [INFO]: Shopify Inventory id 48037842092254 2025-07-31 19:30:10 [INFO]: Shopify Location id 58450641063 2025-07-31 19:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:30: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-07-31 19:30:11 [INFO]: Change: available | Delta: -1 2025-07-31 19:30:11 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576483 and user_id = 14409 2025-07-31 19:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469190 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:30:11 [INFO]: Shopify Inventory id 45683894681822 2025-07-31 19:30:11 [INFO]: Shopify Location id 58450641063 2025-07-31 19:30:11 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19: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-07-31 19:30:11 [INFO]: Change: available | Delta: -1 2025-07-31 19:30:11 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681120 and user_id = 14409 2025-07-31 19:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586340 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:30:11 [INFO]: updateIdsQuantity -> ["77459029","77469190","77586340"] 2025-07-31 19:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-07-31 19:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459029 THEN 0 WHEN id = 77469190 THEN 0 WHEN id = 77586340 THEN 0 END, quantityflag = CASE WHEN id = 77459029 THEN 0 WHEN id = 77469190 THEN 0 WHEN id = 77586340 THEN 0 END WHERE user_id = 14409 AND id IN (77459029,77469190,77586340) 2025-07-31 19:30:11 [INFO]: QUANTITY Updated IDs: 77459029, 77469190, 77586340 2025-07-31 19:30:11 [INFO]: Successfully processed data for user 14409 2025-07-31 19:30:11 [INFO]: Execution Started 2025-07-31 19:30:11 [INFO]: Execution Finished 2025-07-31 19:40:01 [INFO]: Execution Started 2025-07-31 19:40:01 [INFO]: old server sucessfully connected 2025-07-31 19:40:01 [INFO]: sqs client sucess created 2025-07-31 19:40:02 [INFO]: Number of messages in the queue: 1 2025-07-31 19:40:02 [INFO]: item found in queue is if condition 14409 2025-07-31 19:40:02 [INFO]: item found in queue is 14409 2025-07-31 19:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBM69RUs18jpSDg1fTli9t5ZXgM+N1EIxTImpkS7gLjgbpGhGUfyjelPbpsvrZ5EvlJ+R43xcx7zqdIh7LpFLNTuPz06OBPf0ahR87KiXhXNJTVASHy88S8rVHECj9C9nIlH868cWS7p4IcWqlaKgOpYRF18d2sYogcRliI2mlfBBfUyywk6zLYgUWONh9s5vm4B4+q1dBtGF19n0cKe1QjTgv8R0emVWrQu20Mp2jSth3xl+ykQhM+EOFUef/fB9LO2pD1BS+eT98EcofmpOFhfM0UCSNitrNK4A4qBLygZqbjpr59WXbJjL0cqJhubiA4lMfKFPxbJmGG8ulw1qsHcMo4rMDa5Yi7wllCtdBnnw52dYfwEfD92QnE+XSJHPOxowEezIp12cstou6QkWS+aq1JJMktoKcj1pBhSr5ArDIiPMXnEbCaIkjXnqHY4GC 2025-07-31 19:40:02 [INFO]: Processed 1 messages, reached the limit of 1. 2025-07-31 19:40:02 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 19:40:02 [INFO]: inside itemsold and closed 14409 2025-07-31 19:40:04 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:40:04 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:40:04 [INFO]: Ebay item id :: 335593602351 exists in Database 2025-07-31 19:40:04 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:40:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:40:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:40:04 [INFO]: in processold action queue is array for {"44594128":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44594128","ebayitemid":"335593602351","shopifyproductid":"8696079024350","variants":[{"price":"64.99","quantity":0,"weight":"2","shopifyproductid":"8696079024350","shopifyvariantid":"45936134324446","shopifyinventoryid":"48034583281886","shopifylocationid":"","product_id":"44594128","variant_id":"77486837","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 19:40:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 19:40:04 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:40:04 [INFO]: Shopify Inventory id 48034583281886 2025-07-31 19:40:04 [INFO]: Shopify Location id 58450641063 2025-07-31 19:40:04 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:40:04 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:40:04Z","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-07-31 19:40:04 [INFO]: Change: available | Delta: -1 2025-07-31 19:40:04 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:40:04 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:40:04 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44594128 and user_id = 14409 2025-07-31 19:40:04 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486837 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:40:04 [INFO]: updateIdsQuantity -> ["77486837"] 2025-07-31 19:40:04 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-07-31 19:40:04 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77486837 THEN 0 END, quantityflag = CASE WHEN id = 77486837 THEN 0 END WHERE user_id = 14409 AND id IN (77486837) 2025-07-31 19:40:04 [INFO]: QUANTITY Updated IDs: 77486837 2025-07-31 19:40:04 [INFO]: Successfully processed data for user 14409 2025-07-31 19:40:04 [INFO]: Execution Started 2025-07-31 19:40:04 [INFO]: Execution Finished 2025-07-31 19:50:02 [INFO]: Execution Started 2025-07-31 19:50:02 [INFO]: old server sucessfully connected 2025-07-31 19:50:02 [INFO]: sqs client sucess created 2025-07-31 19:50:03 [INFO]: Number of messages in the queue: 4 2025-07-31 19:50:03 [INFO]: item found in queue is if condition 14409 2025-07-31 19:50:03 [INFO]: item found in queue is 14409 2025-07-31 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBd6o5REI2EgmreUGQ4wMbJJQEXDoEHQE9Wra7N8gJZ7tPdk0NewtRArWbN6WvM4Myhlyp5oDgAxvYN7BExQSvA2H8NUkyCj2urjoDSx5C66rstYhc4Rp4cljD+lrRgpxjuQUY40lQRa0WCeMXCuINVgTFTgli16z+I/pb3Cxpc7pFHcU9Rm7T5aZAdvAnHuDsNHy8Nn/OgD8WntqjtFH9CfwjROUtdWpKswxmJSUmDfDe83AGKtPlawzRxzltJfeAMfU846GaKY4NMk9QtIjGudvG0aGbtHj8reyBnmas5jqK02cZdNxGl6Au5jVc5mQE8PjdI2F3RxPhpXopzYl4JP2PMijM7qIWYTjqgei42WFKJBGq8Yxqgw9TeMB05N5UWuilW2Uk5CMz2Yjuma19CTxQx+D7psMFqU17mrmoenrrHVGRHIs9JHSe8Nz3HQ/b 2025-07-31 19:50:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:50:04 [INFO]: item found in queue is 14409 2025-07-31 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBYlosMbhrqQM4UN+DnyjScSS7mGEqR+PoICVu6u9qy87sxA+RBZ6Ek8VsMVI3i79QW8cmNhUdRi+hwadQRyHo/mu6Y4eF7z+H4PFJuKfQ4wQij6K1SiDoBFf3TNl6WYwWB4KmK+1XXtJhdAtwii5jj3XTsebzwbkCu3JA012BexQOpcKmrWNSOE8X6gzMyTieb1BBBE7Zn+jTyOWRg55rz+1j6rL870jH1vOJfldf3n4JxDLovphRtrGZPh2S52jA2piKZbJYhuhz1BlRXcxzZT1uBK18q6uo1gBpKlU03VrtrpB9kDtebFhEqGG4ud8zQSp/uh8rpqZeDXxojAkGkUlzFiJzGrNwRXd0v0nXNDjIJgvOPfyCWQLiYzriDo/bPLl5IawIS0lcSZtz1KYtf+bF6xXeSEaaGaQsv2J+KZnZPnMeqJe0pK+Z0tCWvnDs 2025-07-31 19:50:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:50:04 [INFO]: item found in queue is 14409 2025-07-31 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBI+Q7k4agqxQk1HBoR7Cy7PmUWAMfhIA2qSoMGtx1fKWoOcoy0tur5R2CCq3v8oWkT3geIb1SuT/ya6tjSu9h8LDgZ462fT9PZlQm25B7Zom7R51akQytEzua3gXgwm6EIDEObC6RQ9cAZOi1KqnK2mmx2KPghgS7geLNro6mrWdH2xGXpZwJ/iOr70gIUmzX/XBpFO/p9i4GFpCVQ2DlHNZ0LeB/6UXoOioIbcP3qCG2IFolAZtOmJ+khFKa/B6BHK0FmywRGEXLFeNfm32f6z3HHvEtDzLUF7fBJUJbjh9i5wiRI0kp21aXsmGX+8gNCRQvKr4VU/AN8skZujRRFfT18ZnD6X9UYK8+A5lIq9uvZkteHVhlRMepvn4gcJOJBBpm11dhbgkNEyHJcrUPqnrDnNbAm4MS1RlFjEHF+2F7SKu1z2ksp0oc1pZyJCiu 2025-07-31 19:50:04 [INFO]: item found in queue is if condition 14409 2025-07-31 19:50:04 [INFO]: item found in queue is 14409 2025-07-31 19:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBInzsQTxOA1YD28+G91JpsiEC9zdvYl0ElX2RJV3fGMfLS6VekHxWGN66aUjVEp2njOoOTPClsAMiFoNvq48IYUFNGpA2kpCb+FfdByzc/FEvpmv94aynBAmdPmIQkW/qcVKtgO+tCu8vVxBfZXZxxtXpEmHkf2CHBltY1/CLq+sgAqgpXij7YX9eVwxktyrslf16skbJ9QP/KORjartZLcPE9n2LtonQI7ZSYZPn+OTB25tAUJ2H348P9eNyDGNqVTMO/9B/vsjobh2pvPbkoYfskJM161HQcJmIFUmQ7O/iUH1AGSnqDiYtNpaRt0FGdSjfpBSP7EM9dN1g1Ms4VwaKW9KPa/GPIeEMifz/KTKYlk0ZtKkPZeKWDK4gSFMiO49AdrZA2ih7RgItO5jZLmoDGjPTFf6Ey3qCHjzveoCyJmATQ+O9OPon/2n4/jwK 2025-07-31 19:50:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-07-31 19:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-07-31 19:50:05 [INFO]: inside itemsold and closed 14409 2025-07-31 19:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:50:07 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:50:07 [INFO]: Ebay item id :: 335413073351 exists in Database 2025-07-31 19:50:07 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:50:07 [INFO]: inside itemsold and closed 14409 2025-07-31 19:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:50:08 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:50:08 [INFO]: Ebay item id :: 286635953772 exists in Database 2025-07-31 19:50:08 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:50:08 [INFO]: inside itemsold and closed 14409 2025-07-31 19:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:50:10 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:50:10 [INFO]: not in db for user_id 14409 and the ebayitemid286343242884 2025-07-31 19:50:10 [INFO]: inside itemsold and closed 14409 2025-07-31 19:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-07-31 19:50:12 [INFO]: autolink for user_id 14409 is 1 2025-07-31 19:50:12 [INFO]: Ebay item id :: 285884549282 exists in Database 2025-07-31 19:50:12 [INFO]: Item is reliested :: exists in Database 2025-07-31 19:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-07-31 19:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-07-31 19:50:12 [INFO]: in processold action queue is array for {"44593961":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593961","ebayitemid":"335413073351","shopifyproductid":"8512779682014","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8512779682014","shopifyvariantid":"45435578384606","shopifyinventoryid":"47533557547230","shopifylocationid":"","product_id":"44593961","variant_id":"77486670","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44658657":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44658657","ebayitemid":"286635953772","shopifyproductid":"8822117499102","variants":[{"price":"21.99","quantity":0,"weight":"1","shopifyproductid":"8822117499102","shopifyvariantid":"46304568279262","shopifyinventoryid":"48405607284958","shopifylocationid":"","product_id":"44658657","variant_id":"77563877","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44604829":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44604829","ebayitemid":"285884549282","shopifyproductid":"8523296145630","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8523296145630","shopifyvariantid":"45462469837022","shopifyinventoryid":"47560453587166","shopifylocationid":"","product_id":"44604829","variant_id":"77499780","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-07-31 19:50:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-07-31 19:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-07-31 19:50:12 [INFO]: Shopify Inventory id 47533557547230 2025-07-31 19:50:12 [INFO]: Shopify Location id 58450641063 2025-07-31 19:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:50: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-07-31 19:50:12 [INFO]: Change: available | Delta: -1 2025-07-31 19:50:12 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593961 and user_id = 14409 2025-07-31 19:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486670 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:50:12 [INFO]: Shopify Inventory id 48405607284958 2025-07-31 19:50:12 [INFO]: Shopify Location id 58450641063 2025-07-31 19:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:50: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-07-31 19:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44658657 and user_id = 14409 2025-07-31 19:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563877 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:50:12 [INFO]: Shopify Inventory id 47560453587166 2025-07-31 19:50:12 [INFO]: Shopify Location id 58450641063 2025-07-31 19:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-07-31 19:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T19:50:13Z","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-07-31 19:50:13 [INFO]: Change: available | Delta: -1 2025-07-31 19:50:13 [INFO]: Change: on_hand | Delta: -1 2025-07-31 19:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-07-31 19:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44604829 and user_id = 14409 2025-07-31 19:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77499780 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-07-31 19:50:13 [INFO]: updateIdsQuantity -> ["77486670","77563877","77499780"] 2025-07-31 19:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-07-31 19:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77486670 THEN 0 WHEN id = 77563877 THEN 0 WHEN id = 77499780 THEN 0 END, quantityflag = CASE WHEN id = 77486670 THEN 0 WHEN id = 77563877 THEN 0 WHEN id = 77499780 THEN 0 END WHERE user_id = 14409 AND id IN (77486670,77563877,77499780) 2025-07-31 19:50:13 [INFO]: QUANTITY Updated IDs: 77486670, 77563877, 77499780 2025-07-31 19:50:13 [INFO]: Successfully processed data for user 14409 2025-07-31 19:50:13 [INFO]: Execution Started 2025-07-31 19:50:13 [INFO]: Execution Finished