2025-08-11 22:00:01 [INFO]: Execution Started 2025-08-11 22:00:01 [INFO]: old server sucessfully connected 2025-08-11 22:00:02 [INFO]: sqs client sucess created 2025-08-11 22:00:03 [INFO]: Number of messages in the queue: 3 2025-08-11 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:00:03 [INFO]: item found in queue is 14409 2025-08-11 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFHEr8BGFHdra+WKaYgGp1938oP9e57cH8aAFgwvBuYhneN1eOjNYV7xYvcHiLuXLRIA5UjISQndbYj2tD3TLYZLNUvccgH2J93Fwp52YIPuygBGl59/Z6dk1qDydw1Y4x8SaSmpdhyQkPUWJatAIB8Je5TnsDYrau4YHphJQ49E1nreTsItblaoqI0Yd0KPAKPC0x96bUmSrXhX5QE1ruCrWXw5NggDRMdj8rC+QEP4PTGcFDhBTAzGbyUV9x8XIwZLurrhnxX8ULAz0p/YrwVpFLbWgO3mWmp2DUikbO3MjIOaewOPuZIqZVS0ODIWw0BQ1YjWM+PWckpNVuQHeoErGi06UFrcb/xyhbcP4169zwHIMvNszR2irvPHvO6BsWazmSAvf+fDfFfB0+p2r6C5T/fsnEQtGLFj9iluswQxvNsPVozrvJV448JnC/mMI 2025-08-11 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:00:03 [INFO]: item found in queue is 14409 2025-08-11 22:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB4d0cG0mvLxQqgQEWMFROU4D6haosLgbJVFjC9/u1ZQp83eWivkxHBVcjDw+QPBHRcBGCPPZDOHwIMLDW3d7l7yMbX1Z3BlW8qbUDjQkh6CExkgTTZJIceuPoTzsI8Dh9NSKAmviTRZcSMX7/nkfreMJPvYfVMp6p5pwP6yXvGSUSMmr5cqI5zv+qe5h2878nNql8jh3F2T04bZ+LWyBktspE6JBuVy7hKIy33zssZt4moOe1bNIBwdFWOSvgkNVmq3Qbk5L11u7xSWvlyBvUswfYjTgwba29eo4cxSxDBL0Wwvdp3R6xmmdL+DbuGXCxGj7Np370AGU7oDJrObUibdYoeVLFVZZkYoGLsOeH0OMqaUSOCxEU+yab3gTIA3cb3va68MSWIB0QwvT9eFuyYclVC8aOpScAcOMCyv+DLC7R6hrR6reTdl7kj99Qkkoh 2025-08-11 22:00:04 [INFO]: item found in queue is if condition 14409 2025-08-11 22:00:04 [INFO]: item found in queue is 14409 2025-08-11 22:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBqkpIfuqnrayj5SUfCMMV+y+ngiAgKIV8c84Kg64gcCkGgFZPQFKrQr9ogrjO4YxfW9bB9KwPgK4kf++s5yw6IsYMp3xgViRg/8+E7d1GggKI5vn+Je4SjYGGP7JZXSi2Mu6oUYu04V4dlsUp5nWnMsAt83Ob7FFHTZw8p40Wz616/4ZrfMle4Sn9IZhO1wRdzTZvE48FgdKrziLOtXjIN3JozlpBjQr+cfZoSRVECCDz6jpGhVntk1f+KdwxmnsldzZUBhjRHG/+DmmxgIccbvoUYTFnaOAdMIqqf+h0312V7dwPzaMTQ1VwV8r3i6RL0+P9cq41idhYim0Yomer2jLWq/v/nNE6cLKS+AeEyzxuL76tavtjeJ6BE/NtmP7scunxzf4fDMP2jmL9vvjoxjI83WdXFXN2awicB1uds85SU/DFNxWuaUaWugYraUIu 2025-08-11 22:00:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 22:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 22:00:04 [INFO]: inside itemsold and closed 14409 2025-08-11 22:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:00:06 [INFO]: Ebay item id :: 257052219674 exists in Database 2025-08-11 22:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:00:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 22:00:06 [INFO]: inside itemsold and closed 14409 2025-08-11 22:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:00:09 [INFO]: Ebay item id :: 305998197204 exists in Database 2025-08-11 22:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:00:09 [INFO]: inside itemsold and closed 14409 2025-08-11 22:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:00:11 [INFO]: Ebay item id :: 335738079166 exists in Database 2025-08-11 22:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:00:11 [INFO]: in processold action queue is array for {"45066375":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45066375","ebayitemid":"257052219674","deleted":1}},"44591210":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591210","ebayitemid":"305998197204","shopifyproductid":"8121095225566","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8121095225566","shopifyvariantid":"44331908104414","shopifyinventoryid":"46429562142942","shopifylocationid":"","product_id":"44591210","variant_id":"77483919","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44582038":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582038","ebayitemid":"335738079166","shopifyproductid":"7942703120606","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"7942703120606","shopifyvariantid":"43951337898206","shopifyinventoryid":"46047781159134","shopifylocationid":"","product_id":"44582038","variant_id":"77474747","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 22:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 22:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:00:11 [INFO]: productIds WHich are having null productid -> [45066375] 2025-08-11 22:00:11 [INFO]: ebayItemIds WHich are not imported-> ["257052219674"] 2025-08-11 22:00:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 22:00:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 22:00:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45066375) 2025-08-11 22:00:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 22:00:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 22:00:11 [INFO]: Transaction committed successfully. 2025-08-11 22:00:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 22:00:11 [INFO]: Shopify Inventory id 46429562142942 2025-08-11 22:00:11 [INFO]: Shopify Location id 58450641063 2025-08-11 22:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:00: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-11 22:00:11 [INFO]: Change: available | Delta: -1 2025-08-11 22:00:11 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591210 and user_id = 14409 2025-08-11 22:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77483919 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:00:11 [INFO]: Shopify Inventory id 46047781159134 2025-08-11 22:00:11 [INFO]: Shopify Location id 58450641063 2025-08-11 22:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:00: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-11 22:00:11 [INFO]: Change: available | Delta: -1 2025-08-11 22:00:11 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582038 and user_id = 14409 2025-08-11 22:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77474747 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:00:11 [INFO]: updateIdsQuantity -> ["77483919","77474747"] 2025-08-11 22:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 22:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77483919 THEN 0 WHEN id = 77474747 THEN 0 END, quantityflag = CASE WHEN id = 77483919 THEN 0 WHEN id = 77474747 THEN 0 END WHERE user_id = 14409 AND id IN (77483919,77474747) 2025-08-11 22:00:11 [INFO]: QUANTITY Updated IDs: 77483919, 77474747 2025-08-11 22:00:11 [INFO]: Successfully processed data for user 14409 2025-08-11 22:00:11 [INFO]: Execution Started 2025-08-11 22:00:11 [INFO]: Execution Finished 2025-08-11 22:10:01 [INFO]: Execution Started 2025-08-11 22:10:01 [INFO]: old server sucessfully connected 2025-08-11 22:10:01 [INFO]: sqs client sucess created 2025-08-11 22:10:02 [INFO]: Number of messages in the queue: 4 2025-08-11 22:10:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:10:03 [INFO]: item found in queue is 14409 2025-08-11 22:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+/qeZEKCMjBhtpEThn7+WoH7weiyvJIap6POS0+NqgLPw93pl+/KKcsH4+1wweb3L+wo8uNMYnM9P+AJnQgHHnBAIw56ejzDrG7PKCWd8j0X/8kKRQi7Y1T+ymUJ9GSoNu1OsD1xK0ozhe7MpwuNVxFbIVwgrNmmMUAkeoSUuaI1VRYm1JFgm1AZ+NrB85rn0T7pdhzIE97K8vlVRp+XOeA5bOo8M5ICdVlzoMxfh2hOm/Gw/bTho6PmxN727OUBnf4FUKFnkqhYf6/oepUsoOEoPSokCpk4qkysL9OFVx7drxx5yzpnk1RPkrDvYzpCAQlNO6YhhVqLq74Z+9Cp9/BCwDyqN23D7SZ3/sQI1zEKVAVGfM4YbmUbroVldi7V73ybSYDTeNf6/j8GrW65Y6tl1QcqVwJ35kjpXoYFPzOqHtbpbV2e+EJedsdtPFOG 2025-08-11 22:10:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:10:03 [INFO]: item found in queue is 14409 2025-08-11 22:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNgO7ma6n8WgrkBpiDW+/iNUfl+CP1qwM/6+LWEfLv2LN1EYzPhxSCdcny8MfxE0XoLCVmL1lz5UXCaDqsCaSrTSSXfDfEw4MF1pkQCMV9/NngPExKu6CSxc0QpGxVaNMDh621+Xe75Gs7WDwMDLsIvj105Px6feOsgvBRBP8rmzfL1wsmk7bdZlWJV1kCw41DvWtCHXx88hzV50YKoZ3FlgHC5gVX33btIG5ScMnr/0/UZH05h/p6mnIS4zoCkxs/zE3yH/K1uM7HJ8TZfbYTPYSkHCPLGXkfJ5R5TM8KueE1AcHsT0+CKfrSkL5ccsbuC846p/XTIMlwv+IoMu9RYDtE6pAMl/U9UKCFYNn6iYAs7rmMsJuqt8C2KTHe2NOxAzIkAqXFkYwwx0ITEpREfDclgiPOFf87ReZgCS5CYncxGqbrpAiJvyZPymE80cV 2025-08-11 22:10:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:10:03 [INFO]: item found in queue is 14409 2025-08-11 22:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB/Lv5yRlygIIOtI8pdKc7b/5FWEuNCrzrNjS1qcoqMDXFziOb+33IpKCsTllTaJeg4u2xM0FaUD5wuFxGkkV8AmbfOhMGI5ydaRIwbCZk9Qe2zYpgb6dRM8aEjQHLHmqnC+kNL3HfbKmoCasln9cqbRQKz16wUzvb1eYoFWpeLeGNUuG4pY1QiZxREcI9brw/KDd+e53I9VS2vCCSlCIZTc5HZU5ObOH+tF0JAKXOigFw8PYfaLjzn2hs+y8LWk0tt83h5lTVyya51llc/0oebZrT0bG8fQgeUPz08bHphkjheXU1djwmIQun46IwvKAJkBT+dbqsh/P6VjZadPBCgUipiW/zA+sfjG5TITgAILBfofzJPNIzySmAydcecjQ4PsH47qi94O641dVEVAO6yh2i35CQFJm6OMcGwDOCeWs5xrgb/IGixBceDhe3dNYw 2025-08-11 22:10:04 [INFO]: item found in queue is if condition 14409 2025-08-11 22:10:04 [INFO]: item found in queue is 14409 2025-08-11 22:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBy5PKl9mNsE1L8799FBdl+RUDPpVtHf533qgywO7nEHtebXlPpwBvtJf9fbZfjPzS16PmjuVyf+sjhQg2D/QYm+tUfLihCysavntyNTHoC0pJq6759OM/1O4onUTTMmwm6f9zNBk6IhXCN8w30UNE2Hjb6/bOfJG0Cn3NAhuagYRxI6s3XKYIu+vm0RBQLjB9yOGl83Uqeht6jnkpQvkvZh94n0zjL9SBgakq9fgLduzZUi+VqvTjKK3iazsfWuSq2fGT4Tnx0tEEVaBy+sglpCCDspo/g3+dxqT9+zkz0QA5FsPqFhCFMQLZH0hs6xact5Wk25ev3B8Mef0M5fCy6jyub/S9XRYEUUCHDhsbyfcHF0W4AXqcgNLunw4GWdf8bzey0+s0zj1kIJ0v9M6IyxqWqnoRoH/7ogBrrUkwtZ7aa063MPH2rtoW9WR3w0BF 2025-08-11 22:10:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-11 22:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 22:10:04 [INFO]: inside itemsold and closed 14409 2025-08-11 22:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:10:06 [INFO]: Ebay item id :: 305998334849 exists in Database 2025-08-11 22:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:10:06 [INFO]: inside itemsold and closed 14409 2025-08-11 22:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:10:08 [INFO]: Ebay item id :: 335747989090 exists in Database 2025-08-11 22:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:10:08 [INFO]: inside itemsold and closed 14409 2025-08-11 22:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:10:09 [INFO]: Ebay item id :: 305987701860 exists in Database 2025-08-11 22:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:10:09 [INFO]: inside itemsold and closed 14409 2025-08-11 22:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:10:11 [INFO]: Ebay item id :: 286237138645 exists in Database 2025-08-11 22:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:10:11 [INFO]: in processold action queue is array for {"44640295":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44640295","ebayitemid":"305998334849","shopifyproductid":"8148655079646","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8148655079646","shopifyvariantid":"44393168896222","shopifyinventoryid":"46490966786270","shopifylocationid":"","product_id":"44640295","variant_id":"77545484","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44593702":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44593702","ebayitemid":"335747989090","shopifyproductid":"8919620845790","variants":[{"price":"550.79","quantity":0,"weight":"18","shopifyproductid":"8919620845790","shopifyvariantid":"46759988986078","shopifyinventoryid":"48858498203870","shopifylocationid":"58450641063","product_id":"44593702","variant_id":"77486411","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44584314":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44584314","ebayitemid":"305987701860","shopifyproductid":"8124911288542","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8124911288542","shopifyvariantid":"44340278395102","shopifyinventoryid":"46437979586782","shopifylocationid":"","product_id":"44584314","variant_id":"77477023","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595481":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595481","ebayitemid":"286237138645","shopifyproductid":"8784641851614","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8784641851614","shopifyvariantid":"46206123901150","shopifyinventoryid":"48305945215198","shopifylocationid":"","product_id":"44595481","variant_id":"77488190","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 22:10:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 22:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:10:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:10:11 [INFO]: Shopify Inventory id 46490966786270 2025-08-11 22:10:11 [INFO]: Shopify Location id 58450641063 2025-08-11 22:10:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:10:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22: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-11 22:10:11 [INFO]: Change: available | Delta: -1 2025-08-11 22:10:11 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:10:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:10:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44640295 and user_id = 14409 2025-08-11 22:10:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77545484 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:10:11 [INFO]: Shopify Inventory id 48858498203870 2025-08-11 22:10:11 [INFO]: Shopify Location id 58450641063 2025-08-11 22:10:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1988,"restoreRate":100}}}} 2025-08-11 22:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44593702 and user_id = 14409 2025-08-11 22:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77486411 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:10:12 [INFO]: Shopify Inventory id 46437979586782 2025-08-11 22:10:12 [INFO]: Shopify Location id 58450641063 2025-08-11 22:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22: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-11 22:10:12 [INFO]: Change: available | Delta: -1 2025-08-11 22:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44584314 and user_id = 14409 2025-08-11 22:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77477023 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:10:12 [INFO]: Shopify Inventory id 48305945215198 2025-08-11 22:10:12 [INFO]: Shopify Location id 58450641063 2025-08-11 22:10:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22: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-11 22:10:12 [INFO]: Change: available | Delta: -1 2025-08-11 22:10:12 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595481 and user_id = 14409 2025-08-11 22:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488190 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:10:12 [INFO]: updateIdsQuantity -> ["77545484","77486411","77477023","77488190"] 2025-08-11 22:10:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 3 2025-08-11 22:10:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77545484 THEN 0 WHEN id = 77486411 THEN 0 WHEN id = 77477023 THEN 0 WHEN id = 77488190 THEN 0 END, quantityflag = CASE WHEN id = 77545484 THEN 0 WHEN id = 77486411 THEN 0 WHEN id = 77477023 THEN 0 WHEN id = 77488190 THEN 0 END WHERE user_id = 14409 AND id IN (77545484,77486411,77477023,77488190) 2025-08-11 22:10:12 [INFO]: QUANTITY Updated IDs: 77545484, 77486411, 77477023, 77488190 2025-08-11 22:10:12 [INFO]: Successfully processed data for user 14409 2025-08-11 22:10:12 [INFO]: Execution Started 2025-08-11 22:10:12 [INFO]: Execution Finished 2025-08-11 22:20:02 [INFO]: Execution Started 2025-08-11 22:20:02 [INFO]: old server sucessfully connected 2025-08-11 22:20:02 [INFO]: sqs client sucess created 2025-08-11 22:20:03 [INFO]: Number of messages in the queue: 2 2025-08-11 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:20:03 [INFO]: item found in queue is 14409 2025-08-11 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBV7AmTwiTc09g0WBul/EglHJZPeOm7nygz+a5dZucjhCDorlZYW5xc8Nu1fwUe/WZQowp7y8KJSp3tnI/SfVyISKbjkkonm9r01+OmwJfZPFQ0RPAhnq3JcD8CaeiOZNW+B+uATdGh2Rc6L0ujnF1zFlHu+7LFdCt0yfhkBj382akLrZBGFV8b3FIAxr5ZlH28Mn6+tQY5+F5wbmiEsTFhFJaF+fq/JzQLyka72zj9Ik3NNa299OqttJu3/CxTpFVqQHl2wnCgHCOWgs+2Zd9HsWGNqbEHs2qUXuYVg39Xc6/EhAtihRHoEQ6JnzTCnRtvwzyok25YLRpNznwLMAfoCpJVMut+ZvAk8GuUChZ92pqookyuG8GmjtLpxaay6JeWtmLSmqrDGS6y0lTVMnJ5D38AbYR7W8b03kI9HHWyBa8s6k5tYmAAnR+YgNkOor2 2025-08-11 22:20:04 [INFO]: item found in queue is if condition 14409 2025-08-11 22:20:04 [INFO]: item found in queue is 14409 2025-08-11 22:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBShQllutFWgu+45OyD//HjErHOXVvYHjC0WTOXUJFPwp8AT1XvoUhAEOGrwUXIdkD9i8Oi5uWlkqGLo75czPwhIKAX3EsHlXLPJPMkfxUdalm3wKsOj1+8Sn+E2+RWymsHZurv4L8b6c464FivTi/UoFwdBsQ2nxoEtxdgt9QLuAe9mZRG4P8z6CXF7sDRh25oLywet3rSE6CzVIVO21b4mZViGuDXDJinBSwQIetKFuXRdk6xYaO+cfO2Xy9QOEjVphx1gVUoKEXph/oQVQP36/16w1L9N3QNyEMXCK0WYrZ3BDRK7iU0MCVjmZd8Xf7B0SRJz9HrBB6V4qZIZOLLfXeOFL76IzubZUQPBCEtx/SoTPEVHfjtztirg7SO86k9gtPy4iduSHEym82TQpuJJdd7EbE9WV5V9+PlrD1wYEcxQKCuJcdXM2KNOiBTH8 2025-08-11 22:20:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-11 22:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 22:20:04 [INFO]: inside itemsold and closed 14409 2025-08-11 22:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:20:05 [INFO]: Ebay item id :: 286232275614 exists in Database 2025-08-11 22:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:20:05 [INFO]: inside itemsold and closed 14409 2025-08-11 22:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:20:07 [INFO]: Ebay item id :: 286222929304 exists in Database 2025-08-11 22:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:20:07 [INFO]: in processold action queue is array for {"44640257":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44640257","ebayitemid":"286232275614","shopifyproductid":"7646845337822","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"7646845337822","shopifyvariantid":"42777890259166","shopifyinventoryid":"44872429437150","shopifylocationid":"","product_id":"44640257","variant_id":"77545446","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44637280":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44637280","ebayitemid":"286222929304","shopifyproductid":"7959588438238","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"7959588438238","shopifyvariantid":"44005265801438","shopifyinventoryid":"46101834924254","shopifylocationid":"","product_id":"44637280","variant_id":"77542469","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 22:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:20:07 [INFO]: Shopify Inventory id 44872429437150 2025-08-11 22:20:07 [INFO]: Shopify Location id 58450641063 2025-08-11 22:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:20: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-11 22:20:08 [INFO]: Change: available | Delta: -1 2025-08-11 22:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44640257 and user_id = 14409 2025-08-11 22:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77545446 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:20:08 [INFO]: Shopify Inventory id 46101834924254 2025-08-11 22:20:08 [INFO]: Shopify Location id 58450641063 2025-08-11 22:20:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:20: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-11 22:20:08 [INFO]: Change: available | Delta: -1 2025-08-11 22:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44637280 and user_id = 14409 2025-08-11 22:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77542469 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:20:08 [INFO]: updateIdsQuantity -> ["77545446","77542469"] 2025-08-11 22:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 22:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77545446 THEN 0 WHEN id = 77542469 THEN 0 END, quantityflag = CASE WHEN id = 77545446 THEN 0 WHEN id = 77542469 THEN 0 END WHERE user_id = 14409 AND id IN (77545446,77542469) 2025-08-11 22:20:08 [INFO]: QUANTITY Updated IDs: 77545446, 77542469 2025-08-11 22:20:08 [INFO]: Successfully processed data for user 14409 2025-08-11 22:20:08 [INFO]: Execution Started 2025-08-11 22:20:08 [INFO]: Execution Finished 2025-08-11 22:30:01 [INFO]: Execution Started 2025-08-11 22:30:01 [INFO]: old server sucessfully connected 2025-08-11 22:30:01 [INFO]: sqs client sucess created 2025-08-11 22:30:02 [INFO]: Number of messages in the queue: 2 2025-08-11 22:30:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:30:03 [INFO]: item found in queue is 14409 2025-08-11 22:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoIyqStJXeVSJSKgea6S+CumOMTaZffAhYZSTaB55t9+n1AiUWLl+ZLol83airTcFI0vAXUrmP/DDYeJYpCAr7M3wX+ziA3J3a3cnVRw5YXk2JW5jJS6YjQTjNfh/uACLEyaXSH59z/tWQ1Zy7JM3lsZQ1QBPfLZHcxKvIRAcV7qcgDxHaqnYP3mlkjLE/43gkNYI+MiW5YfCtvAih9vDSPTNbuu8QuY765NCN6f0ZC6ENStQuyXIwTUffoPkpOL/7zkQKj2ss7AQUzDy0pJ8yxzlRBZX20UhUeGz75/s7CeQO7Bibt7tn3QvbmVorgj5RHA0xN64TaVFK/zzClRAOH3OyQQybPMMl4cjhHb9biTpk1xWvyDoMU9mI6XPNUECy9Ecd0mZyCKyin1XPdjKsCS/dxyNla6jxTgLhFF4ShKRXgOYbdGLVQKuEC5JitJI 2025-08-11 22:30:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:30:03 [INFO]: item found in queue is 14409 2025-08-11 22:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBupiM1FolsSpZ59weKcZcsdlL/CYvUdG2yZWQnXujMQVXu+/mDNcSyhvUt841kXSy96d4Wn7e9Yky65FcPzr11N1kK/AO+lOePt3oeN7xvEtYWQZ4Wj/XxET8hCE0jagrzODSRM8lIDlVIvVdH1srLiBrhAzvFz/iwyFuGGnyU2ifgQSl2w1o8qyTW3g7EgAN73nJUpE5fmllA8df0fIRT3i/fUz6OLMaUS0axs64z5gh4EMmQDdb4G4JAi182cMKz39tDdT1zmfU3OEH+IxylM1l6S+SzFNNPdZzJT/MK5fxwFws58LmWLo5qoytMHKJgciPWStwEM2bN57+VnQm50CaFqrD0zQUv6kEFbKX6TFD0xs6EcbhEzHumNfSZkRVuxGXqOFAe/LlfphwcR7SoHHkdjCsCpujaNWOglvX7lQE/wlwz2r1USPMy7lrNtbW 2025-08-11 22:30:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-11 22:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 22:30:03 [INFO]: inside itemsold and closed 14409 2025-08-11 22:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:30:05 [INFO]: Ebay item id :: 335644443658 exists in Database 2025-08-11 22:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:30:05 [INFO]: inside itemsold and closed 14409 2025-08-11 22:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:30:07 [INFO]: Ebay item id :: 305870604527 exists in Database 2025-08-11 22:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:30:07 [INFO]: in processold action queue is array for {"44604795":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44604795","ebayitemid":"335644443658","shopifyproductid":"8273867014366","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8273867014366","shopifyvariantid":"44760148902110","shopifyinventoryid":"46858159390942","shopifylocationid":"","product_id":"44604795","variant_id":"77499746","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44596670":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596670","ebayitemid":"305870604527","shopifyproductid":"8064655065310","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8064655065310","shopifyvariantid":"44234762223838","shopifyinventoryid":"46331893383390","shopifylocationid":"","product_id":"44596670","variant_id":"77489379","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 22:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 22:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:30:07 [INFO]: Shopify Inventory id 46858159390942 2025-08-11 22:30:07 [INFO]: Shopify Location id 58450641063 2025-08-11 22:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:30:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:30: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-11 22:30:07 [INFO]: Change: available | Delta: -1 2025-08-11 22:30:07 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44604795 and user_id = 14409 2025-08-11 22:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77499746 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:30:07 [INFO]: Shopify Inventory id 46331893383390 2025-08-11 22:30:07 [INFO]: Shopify Location id 58450641063 2025-08-11 22:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:30:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:30:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-11 22:30:08 [INFO]: Change: available | Delta: -1 2025-08-11 22:30:08 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:30:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:30:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596670 and user_id = 14409 2025-08-11 22:30:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489379 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:30:08 [INFO]: updateIdsQuantity -> ["77499746","77489379"] 2025-08-11 22:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 22:30:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77499746 THEN 0 WHEN id = 77489379 THEN 0 END, quantityflag = CASE WHEN id = 77499746 THEN 0 WHEN id = 77489379 THEN 0 END WHERE user_id = 14409 AND id IN (77499746,77489379) 2025-08-11 22:30:08 [INFO]: QUANTITY Updated IDs: 77499746, 77489379 2025-08-11 22:30:08 [INFO]: Successfully processed data for user 14409 2025-08-11 22:30:08 [INFO]: Execution Started 2025-08-11 22:30:08 [INFO]: Execution Finished 2025-08-11 22:40:01 [INFO]: Execution Started 2025-08-11 22:40:01 [INFO]: old server sucessfully connected 2025-08-11 22:40:01 [INFO]: sqs client sucess created 2025-08-11 22:40:02 [INFO]: Number of messages in the queue: 4 2025-08-11 22:40:02 [INFO]: item found in queue is if condition 14409 2025-08-11 22:40:02 [INFO]: item found in queue is 14409 2025-08-11 22:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBozfkCtr11GduqX0olsLb1oI1byN6h/75aNKw0lMgX8x/gmRSffOUslMWxJbHeGpes3TkJ3Ao/Ypg2Z/bZFZve8hGFpk3V7n5+gaE/5Sn6afsu8M/nsrkDDS2/JOQyQlazxqYuxrb35dyYxJcfHIbQ03xPwJBIfteJeaA3fFwIumm8CmVrjB/loGlChdyWZLzLU1J9I4EjEQh3m3LtbROOus9VLY7tP7bvW1Wt7XdgQvME+SkqwBD6CQscZEbTMPBQpVZOgujQw0g4RebkOH+JCimiek3nEYXj20cmvmuQ8GdgJa6H/yrbobW6JfUmXOhw8M4HsgGGxDOB04sDdNEvr7IQf2Ym1arKjKmQ66aeen4vFykD8pkeLG+PzUtN1a7c4L0zY76jijIRML4QKKJLgShDvq73pb1OCmPNMhgTMQGZtQSLX5rCFmKHxtlDaiP 2025-08-11 22:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:40:03 [INFO]: item found in queue is 14409 2025-08-11 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKcJ7p7kNxiRUsWFXz5D8+E1vwWho0x9MpTDTfILH2SgN0yBANJwtlNOvMDkCVBV7wyU8QF7OYwq8ksk2bbbO6q0pmdurRMvg0brS8h2xTV1sQQTWr0uII3cihHxJlPdBCcEVy5ocBUS+f0PsYLcWPk0Sgg63QUVKaq8FA2OzRl4deTmj9+32VYBm5TbBYMz1+jYf28pjfF1iwAHPTR08S0TKYF8MzaGC+URQBBXfueVzgwdVl15rHTtdYbhLbw0EUHbSR4GvXNBY1nBbF28jV6+UAoFYd44nguHEvUXig/b+t/lscKk3niTL+LC7/jKRxTs0ii0CScf6iyZaIiSh4sYbe6cK3zogYiQRtrratY/moXskk0oAZeGVT7GKBCuKgsxwgEtuc3YDvrfX+XaU3y/7W91B5n2zPeTsFCOy/o4tJevu490TfenPOubp9Eu2 2025-08-11 22:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 22:40:03 [INFO]: item found in queue is 14409 2025-08-11 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBza8Of9gYxBcpB7etyVybyR/4Y1hvdjtEbZVaHejgvPVROjuebAJH7z7GHygrQMPBKh41ycmARcFd2gstVHuBcXITjGFF9mc38nmgC91As+0HCOqCR4UDIEQ30/mvtN/l9N8qRfpLvHqAgC4+hwD0mCzZqi5eEn63Lv49o11Y9JkCRbEj4EZTqjU+zsyBnolWy8bg2RvVIqI5VqCcjSv9ay1PRlaiciJsmGtyOdQQ0fTsMuu+7xoZlL4k9tTfgU17k0sdSpfHuGMR68XvFEgvuvo8M9q96+Vs09xYk37WaCkSovw+ltgO8RMfhQruBYaRY2q9le1gwTewgelGq+ia6R4fFkjF1qQUCVRGGkpvjQcYk1R1zy5aKLIZ3TNPStYgutg1ZSR5ybe5mVL6q+0nMwvfU6nOR8bz+4ThOmfYWNX7jAg1+y4GaJCh5SAUPq3L 2025-08-11 22:40:04 [INFO]: item found in queue is if condition 14409 2025-08-11 22:40:04 [INFO]: item found in queue is 14409 2025-08-11 22:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB1mrbG/nZ12nUmxOCHr5kthJHzpU76H/QTRUk89T1bpvQRqtKqMxTHw2VvENmvFve68q6+PF+56ezcuVlSEO+/wAirsd7uy1YhCm3PxjEls8m4ZISiTBGsxZHOavTju5Ck6GD08GWIXCDEv8yngVxHqAvR5u4bCz4y//jc4gYxsrwgGgs81VqbOaLj2r74SmEmR1G9xEeR3BYejQ2RQAwf+OxB8bZ2w9J0JQzVF8zhNUr2TZ8BHbeJbxB9Pmq/DBr6+Pg6Pau0t89FnmpcoykhEm1OGIhTHRvV4tn/T+PQUEVJOCH63ceI2duwQjxvcQa/t9TwRtPi7qbBPytbs6RBXSeWMstJMaCw3G8N/X5VjzNZ9un4SDF9HyYQpe7v9VqQooUzuAYu8l9VRhKDi+uNa9HJlkUzWfuwcf8MzLG/Easko9o5pIBnT/REILnupnN 2025-08-11 22:40:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-11 22:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 22:40:04 [INFO]: inside itemsold and closed 14409 2025-08-11 22:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:40:05 [INFO]: Ebay item id :: 335075015145 exists in Database 2025-08-11 22:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:40:05 [INFO]: inside itemsold and closed 14409 2025-08-11 22:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:40:07 [INFO]: Ebay item id :: 286134411138 exists in Database 2025-08-11 22:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:40:07 [INFO]: inside itemsold and closed 14409 2025-08-11 22:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:40:09 [INFO]: Ebay item id :: 286100903611 exists in Database 2025-08-11 22:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:40:09 [INFO]: inside itemsold and closed 14409 2025-08-11 22:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:40:11 [INFO]: Ebay item id :: 335644437579 exists in Database 2025-08-11 22:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:40:11 [INFO]: in processold action queue is array for {"44576379":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576379","ebayitemid":"335075015145","shopifyproductid":"8156936306910","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8156936306910","shopifyvariantid":"44416771883230","shopifyinventoryid":"46514526191838","shopifylocationid":"","product_id":"44576379","variant_id":"77469086","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44596678":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596678","ebayitemid":"286134411138","shopifyproductid":"8102773948638","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8102773948638","shopifyvariantid":"44296353448158","shopifyinventoryid":"46393673023710","shopifylocationid":"","product_id":"44596678","variant_id":"77489387","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44581526":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44581526","ebayitemid":"286100903611","shopifyproductid":"8702042374366","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8702042374366","shopifyvariantid":"45950630854878","shopifyinventoryid":"48049195679966","shopifylocationid":"","product_id":"44581526","variant_id":"77474235","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44596685":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596685","ebayitemid":"335644437579","shopifyproductid":"8132962484446","variants":[{"price":"79.99","quantity":0,"weight":"3","shopifyproductid":"8132962484446","shopifyvariantid":"44355692003550","shopifyinventoryid":"46453462991070","shopifylocationid":"","product_id":"44596685","variant_id":"77489394","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 22:40:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 22:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:40:11 [INFO]: Shopify Inventory id 46514526191838 2025-08-11 22:40:11 [INFO]: Shopify Location id 58450641063 2025-08-11 22:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:40: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-11 22:40:11 [INFO]: Change: available | Delta: -1 2025-08-11 22:40:11 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576379 and user_id = 14409 2025-08-11 22:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469086 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:40:11 [INFO]: Shopify Inventory id 46393673023710 2025-08-11 22:40:11 [INFO]: Shopify Location id 58450641063 2025-08-11 22:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:40:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1986,"restoreRate":100}}}} 2025-08-11 22:40:12 [INFO]: Change: available | Delta: -1 2025-08-11 22:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596678 and user_id = 14409 2025-08-11 22:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489387 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:40:12 [INFO]: Shopify Inventory id 48049195679966 2025-08-11 22:40:12 [INFO]: Shopify Location id 58450641063 2025-08-11 22:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:40: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-11 22:40:12 [INFO]: Change: available | Delta: -1 2025-08-11 22:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44581526 and user_id = 14409 2025-08-11 22:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77474235 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:40:12 [INFO]: Shopify Inventory id 46453462991070 2025-08-11 22:40:12 [INFO]: Shopify Location id 58450641063 2025-08-11 22:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:40: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-11 22:40:12 [INFO]: Change: available | Delta: -1 2025-08-11 22:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596685 and user_id = 14409 2025-08-11 22:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489394 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:40:12 [INFO]: updateIdsQuantity -> ["77469086","77489387","77474235","77489394"] 2025-08-11 22:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-11 22:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77469086 THEN 0 WHEN id = 77489387 THEN 0 WHEN id = 77474235 THEN 0 WHEN id = 77489394 THEN 0 END, quantityflag = CASE WHEN id = 77469086 THEN 0 WHEN id = 77489387 THEN 0 WHEN id = 77474235 THEN 0 WHEN id = 77489394 THEN 0 END WHERE user_id = 14409 AND id IN (77469086,77489387,77474235,77489394) 2025-08-11 22:40:12 [INFO]: QUANTITY Updated IDs: 77469086, 77489387, 77474235, 77489394 2025-08-11 22:40:12 [INFO]: Successfully processed data for user 14409 2025-08-11 22:40:12 [INFO]: Execution Started 2025-08-11 22:40:12 [INFO]: Execution Finished 2025-08-11 22:50:01 [INFO]: Execution Started 2025-08-11 22:50:01 [INFO]: old server sucessfully connected 2025-08-11 22:50:01 [INFO]: sqs client sucess created 2025-08-11 22:50:02 [INFO]: Number of messages in the queue: 1 2025-08-11 22:50:02 [INFO]: item found in queue is if condition 14409 2025-08-11 22:50:02 [INFO]: item found in queue is 14409 2025-08-11 22:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFl/KRimBgQRgNuoLVN6sxL+FvT3tp1Vo5r+xqGgjdgiw8/bdN2pCn+C4+yKpE0+ScQ9wcpxhFGl5V8BlABzGX1rlCLoGPWZ8DoPPNFsUy/ag2WrrqhRjsciK97KzBvglSeHTwQSpcjy2/YCg0014LTK2JswL9jV5brPoJ++PlYMzjgtb74LleQwhPZmmdcWfe6OOmV2GTo0qEeuEE1v68KVFqzWWxbxJ/t7UNYMf1QHAKg91VhS5AD0K9RGLuY61Qou7LtF6/BRXy0yTW7Vg1j1EvGWio9CfHzqi2jZKGhRl8AXCpnGLebr3mf8D6Cn7yPUDHErc9QfCQcHezEfJNHjp12VF9h/ApDhp/83/Lflq3nf6BQZS7+Bh1eRo+sTpxtaLV2qbE4WvKLb6wnHUk5Kkwm9pUz/5A0qZYAJ+sMIr3oe3/z4is3Pou3ZO4W7D 2025-08-11 22:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 22:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 22:50:03 [INFO]: inside itemsold and closed 14409 2025-08-11 22:50:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 22:50:04 [INFO]: autolink for user_id 14409 is 1 2025-08-11 22:50:04 [INFO]: Ebay item id :: 335561361353 exists in Database 2025-08-11 22:50:04 [INFO]: Item is reliested :: exists in Database 2025-08-11 22:50:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 22:50:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 22:50:04 [INFO]: in processold action queue is array for {"44557200":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557200","ebayitemid":"335561361353","shopifyproductid":"8696091410654","variants":[{"price":"84.99","quantity":0,"weight":"3","shopifyproductid":"8696091410654","shopifyvariantid":"45936163913950","shopifyinventoryid":"48034612871390","shopifylocationid":"","product_id":"44557200","variant_id":"77449880","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 22:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 22:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 22:50:05 [INFO]: Shopify Inventory id 48034612871390 2025-08-11 22:50:05 [INFO]: Shopify Location id 58450641063 2025-08-11 22:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 22:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T22:50:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1931,"restoreRate":100}}}} 2025-08-11 22:50:05 [INFO]: Change: available | Delta: -1 2025-08-11 22:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 22:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 22:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557200 and user_id = 14409 2025-08-11 22:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449880 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 22:50:05 [INFO]: updateIdsQuantity -> ["77449880"] 2025-08-11 22:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 22:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77449880 THEN 0 END, quantityflag = CASE WHEN id = 77449880 THEN 0 END WHERE user_id = 14409 AND id IN (77449880) 2025-08-11 22:50:05 [INFO]: QUANTITY Updated IDs: 77449880 2025-08-11 22:50:05 [INFO]: Successfully processed data for user 14409 2025-08-11 22:50:05 [INFO]: Execution Started 2025-08-11 22:50:05 [INFO]: Execution Finished