2025-08-13 22:00:01 [INFO]: Execution Started 2025-08-13 22:00:01 [INFO]: old server sucessfully connected 2025-08-13 22:00:01 [INFO]: sqs client sucess created 2025-08-13 22:00:02 [INFO]: Number of messages in the queue: 5 2025-08-13 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:00:03 [INFO]: item found in queue is 14409 2025-08-13 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLwpwywGAwG4MVb6AWXcz617qiI1HYd+AcUsYzZG5CtYy/m51kTfM5rbohB2imPdfJPU9OLlNDwSL4ULwqBfW59tS7NJBq+Md5hyZSGSVtJyRCp0BZkQqR2zjgGnreJLVW7PjPrzHumogVg9zcWUw8hi1Bj8YFT7OjtXjV3oIBIXYwmnB0whkSvzVXA3UodwMP5BG5exj7O0QIFrUudqroQKI3qsUlB1ibdw0glhjeb9ieNdg0ikDpqsJQu1lgmWCE5ux0dmoqJoqyyMFMLomN+iJH6HqMJm5ahtdGAVEnA9Gx2HVj7vgEE1VPvP5hqGHN0Rt7TOKST045f1czzVqotlQwYdnCsFYllNTuRQAA6mUkCMNuUybBH0j4+dIgg+fUErXeaKOXptvkXziBx28pKSlkIFemZ59NouqdsWFvjWiaOQwIIf21mO42Q2ce5RM 2025-08-13 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:00:03 [INFO]: item found in queue is 14409 2025-08-13 22:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMjcXLtoL3oFTvh3WTMkK6JIIiODHZKkc/jNoTNQL5s0nOFDvOoyF9SYOx/RKFglAUAo8gcuV5y7y8FYAZc2I+m9y9bWEPNy5zphCwmaR3eJJVP+/oe2HyxwOeTLEfLhYzs/6kcmzgLFiWs/QjAxppHtb5NWF0Gmsq3QSmKKSEtcORSRLo4KoZpjfTG6ExCpGZRfU2lxebtBVhpHtsLLiJTpXgvTjMcyPlZRSALNxJZn3CBsDCosqMLu+A7GVRuQvzU1c9F4WWDsKccXb+AIBaJqaTK9UVO1yKUhLuK6c+IXqQcJjGPtQzicuKTNHZD1dEaTOQz1q5CITcxRh8H8BGVVHRBtMgXt2HLsEHOhQ84EPbC6DkOnNdPvu/pQuV/Fa3wPDHQ/lPl3bb3gDLxpogRzMIXs4wXsmBRlphjovuyMSHAdNN3wYesOextjeCFAK 2025-08-13 22:00:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:00:03 [INFO]: item found in queue is 14409 2025-08-13 22:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB3gLg20X4tw9SDgE51GZg5J4nXfjyV+NvPHegIse8lBTRVOnNrqcWHMW3uhr7k77ZMr0iBLbGaL7AAc/zNDPxnmFOmrIivvLxDwcXQdVGDY1TiK9zjhJZpbp+Cw3dnZAdNUEzbyz7knpHceYCbMacIUsUyA0CzjR4gHh1rieeLbStypkzS4WOBAoUhQYsdKZRDC3nib7z+REevVAiq5kccvrNipW4DTr0OB5JnLhu66NCfzjO7pxSp/ZkRxCgdu9t/Q3G9sEiOuQ0W2SAfCALIzJlIYA98gryf6/DFCEo+tuEJDnIYKhUn8/zIyhtUKFIQGGvp5LSuvDY6Hgs/uDKqyQQ9giKf0o/lmlq0L3ZtSFIp8BNx6aLeIqLilUZOamRwLQvt5GkKX5aUCD8WGmyYmSv8FTe9KkK+OD2Yis3mV3ZoQpAfhmHYKPKUORN1R19 2025-08-13 22:00:04 [INFO]: item found in queue is if condition 14409 2025-08-13 22:00:04 [INFO]: item found in queue is 14409 2025-08-13 22:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBhsB9q8jZxViRiOZfItioZsb6q0w5WEDnkqSUd/2WqkF2zF0PZ24Z5gyTp8LrDo/d09CsHg9VDz4ESFwgVHSoPR2axeiOzIo3DP5RVKA4nOs5aQExZf6Xkcf89bvwgAl/pazGlPfZsN7GJAtrSKjoOgK4q8eWMJxxUwKQrDThdHHy9+u0m4mzP2xf+OblHGJZULCdWZdFMMQfDaTgZ/J0WBEKUtF4SF4TLBzrSBNfRGZDzMWgGy8yhylFkCL4Y/9faLlNySt51x1TbEg3ffzMCy5rFkGpxsyrfn2tCuGkbjNSLfmF3yLqewHpY3c2qJaAwKpj9m+5BLWHdpQt0YRX7+RxWOcAJvPYpWADmtZRswH12DA6O9+UlCpQTAMZ6/ViftrTqPIjlJRk+2oOb1+Tgm/wRjlvZkKgQFJ5knTGFbHpUkl3uyEq+c0EpBTsNLZF 2025-08-13 22:00:04 [INFO]: item found in queue is if condition 14409 2025-08-13 22:00:04 [INFO]: item found in queue is 14409 2025-08-13 22:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBQ8h48j0oy+V+cfGhn+Xp3HofZRUKhDQGv52Vudkfj8UZoJbLRFUFy1jXd2RD09Cq/T5YSpIHi+BTL45Db8fDrTn9q0Tj7yhxrWCdU69NyuO8y9kO4gxblcOuGJA/0r024Kat9jBkm+nSYQDi4UhqES/v5eWebr/HBTrmT9DhVbNqS0EWuglsxT8Q5siiA7JgzUd3P6eIRXWxi8Hzm1qrJKOUMSc+ORTFoxIcZd/dVXFSFXn30itmsm+N0D/FjTGf9MoDHz7BJ59KEbHKV1g9WPRp/9H/ekeWYiVMQB8WMfuBWMKLFdRDj6d5YjrGa8dpbO+yHpKNHEP9lg2Qj0IhSIK6Tprmr48VSqGDVUfNGfQcFyR5clNuBe/lbL71WExgRMfPsuLOV8tREbCkkucEQnJ6CzQLCcj0pDY3fUYm1sjVbngIHUJWRQtDj8ggWXIi 2025-08-13 22:00:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-13 22:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 22:00:05 [INFO]: inside itemsold and closed 14409 2025-08-13 22:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:00:06 [INFO]: Ebay item id :: 326538570159 exists in Database 2025-08-13 22:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:00:06 [INFO]: inside itemsold and closed 14409 2025-08-13 22:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:00:09 [INFO]: Ebay item id :: 286548683598 exists in Database 2025-08-13 22:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:00:09 [INFO]: inside itemsold and closed 14409 2025-08-13 22:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:00:10 [INFO]: Ebay item id :: 257064516472 exists in Database 2025-08-13 22:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:00:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 22:00:10 [INFO]: inside itemsold and closed 14409 2025-08-13 22:00:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:00:12 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:00:12 [INFO]: Ebay item id :: 286693575725 exists in Database 2025-08-13 22:00:12 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:00:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 22:00:12 [INFO]: inside itemsold and closed 14409 2025-08-13 22:00:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:00:14 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:00:14 [INFO]: Ebay item id :: 226709695733 exists in Database 2025-08-13 22:00:14 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:00:14 [INFO]: in processold action queue is array for {"44656466":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656466","ebayitemid":"326538570159","shopifyproductid":"8879439511774","variants":[{"price":"24.99","quantity":0,"weight":"0.5","shopifyproductid":"8879439511774","shopifyvariantid":"46624700661982","shopifyinventoryid":"48727636574430","shopifylocationid":"","product_id":"44656466","variant_id":"77561655","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44856235":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44856235","ebayitemid":"286548683598","shopifyproductid":"8927161254110","variants":[{"price":"199.99","quantity":0,"weight":"2","shopifyproductid":"8927161254110","shopifyvariantid":"46846426415326","shopifyinventoryid":"48957628743902","shopifylocationid":"58450641063","product_id":"44856235","variant_id":"77767194","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45314381":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45314381","ebayitemid":"257064516472","deleted":1}},"45197260":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45197260","ebayitemid":"286693575725","deleted":1}}} 2025-08-13 22:00:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 22:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:00:14 [INFO]: productIds WHich are having null productid -> [45314381,45197260] 2025-08-13 22:00:14 [INFO]: ebayItemIds WHich are not imported-> ["257064516472","286693575725"] 2025-08-13 22:00:14 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 22:00:14 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 22:00:14 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45314381,45197260) 2025-08-13 22:00:14 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 22:00:14 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 22:00:14 [INFO]: Transaction committed successfully. 2025-08-13 22:00:14 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 22:00:14 [INFO]: Shopify Inventory id 48727636574430 2025-08-13 22:00:14 [INFO]: Shopify Location id 58450641063 2025-08-13 22:00:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-13 22:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656466 and user_id = 14409 2025-08-13 22:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561655 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:00:14 [INFO]: Shopify Inventory id 48957628743902 2025-08-13 22:00:14 [INFO]: Shopify Location id 58450641063 2025-08-13 22:00:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T22:00:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 22:00:14 [INFO]: Change: available | Delta: -1 2025-08-13 22:00:14 [INFO]: Change: on_hand | Delta: -1 2025-08-13 22:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44856235 and user_id = 14409 2025-08-13 22:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77767194 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:00:14 [INFO]: updateIdsQuantity -> ["77561655","77767194"] 2025-08-13 22:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 1 2025-08-13 22:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561655 THEN 0 WHEN id = 77767194 THEN 0 END, quantityflag = CASE WHEN id = 77561655 THEN 0 WHEN id = 77767194 THEN 0 END WHERE user_id = 14409 AND id IN (77561655,77767194) 2025-08-13 22:00:14 [INFO]: QUANTITY Updated IDs: 77561655, 77767194 2025-08-13 22:00:14 [INFO]: Successfully processed data for user 14409 2025-08-13 22:00:14 [INFO]: Execution Started 2025-08-13 22:00:14 [INFO]: Execution Finished 2025-08-13 22:10:01 [INFO]: Execution Started 2025-08-13 22:10:01 [INFO]: old server sucessfully connected 2025-08-13 22:10:01 [INFO]: sqs client sucess created 2025-08-13 22:10:02 [INFO]: Number of messages in the queue: 0 2025-08-13 22:10:22 [INFO]: Execution Started 2025-08-13 22:10:22 [INFO]: Execution Finished 2025-08-13 22:20:01 [INFO]: Execution Started 2025-08-13 22:20:01 [INFO]: old server sucessfully connected 2025-08-13 22:20:01 [INFO]: sqs client sucess created 2025-08-13 22:20:02 [INFO]: Number of messages in the queue: 2 2025-08-13 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:20:03 [INFO]: item found in queue is 14409 2025-08-13 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBUyXldSCOCxqwpjw9Zl/qV1+e9Hb88BGZmY4PTU8tU2wrsfUTCHn3GeJ0zojwiZcztyN7Hl/FVFk/ikZ2muoTVSNrVhMyYp2F/VRfvUdkikM3IdAkvZv0LFqgLDSt5yG9nDcrqsAqNWYu4GG0KTPHWHm7MKt/ooT0wrpxt18mVcXkxHxfKiDHC+K0WGePxdHrfEULvQEmTW62Wrb3Rdt/eKxmgXTDqQjZA4xOK0ZW+V5WPZzt3pQ8Joi8RqCONlgbS9OclmAvS0geNt7uOnq9ud92hTlgfdmk1cNT7X8Xx0GGcJsPVeYn64sdmREghY7ZAa2dVaeTX3WtBImejUppBkZk44saLjulrwKY6WmzvaUtrn6hJ/mVjwbb0xOSzi1utwBDMPOZzGQdseOHulIOqYXeV3i1vGYTWKx8kJfkhemxD39EgITuSsYZFrbtRQB/ 2025-08-13 22:20:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:20:03 [INFO]: item found in queue is 14409 2025-08-13 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQg7sd0tJuG+qGK9+u5e9rcaUFz5oOvijBtpREtDhvqBIb5Jysbk+GHw1zS9CqtiHoQunZprX8XZu3XvMVPE+q1M417I6Yceykl7xAUOqs/QCVLdgY1TNkx/RvmNhMEvt0uhKd+J2l+OdoNABHM+ncBL3sPlCUdez9CAmrI2X0MCNWnJT+T1+giNmrLQD2glASDk3dZd4GoDKgvCEE67Z4N4/uaDjwKm6QeQhRJ1GCfZ80a97cHCMvBTtTSQqmHhCMkS0iDeG199CvQkAGvK2VfIFawWijt3vvmoRhy4kup3tB2jCm1xEWx4yyfPl12Q3CMq+VnS+LQulQidLlFyM57pSbwz5J/v5FKzDYUYidbgFn8bvNy64L4rzMIKiH9QaSQ2zTJsxwZ92zA+CPL3t41S1wlTmfOcA6FqCJjEYtxO/onEUr8io6w8812LIjdxM 2025-08-13 22:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 22:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 22:20:03 [INFO]: inside itemsold and closed 14409 2025-08-13 22:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:20:05 [INFO]: Ebay item id :: 283630379229 exists in Database 2025-08-13 22:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:20:05 [INFO]: inside itemsold and closed 14409 2025-08-13 22:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:20:07 [INFO]: Ebay item id :: 326656470758 exists in Database 2025-08-13 22:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:20:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 22:20:07 [INFO]: in processold action queue is array for {"44599695":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44599695","ebayitemid":"283630379229","shopifyproductid":"6849014923431","variants":[{"price":"9.83","quantity":0,"weight":"1","shopifyproductid":"6849014923431","shopifyvariantid":"40415573475495","shopifyinventoryid":"42511078097063","shopifylocationid":"","product_id":"44599695","variant_id":"77492404","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45157498":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45157498","ebayitemid":"326656470758","deleted":1}}} 2025-08-13 22:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:20:07 [INFO]: productIds WHich are having null productid -> [45157498] 2025-08-13 22:20:07 [INFO]: ebayItemIds WHich are not imported-> ["326656470758"] 2025-08-13 22:20:07 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 22:20:07 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 22:20:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45157498) 2025-08-13 22:20:07 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 22:20:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 22:20:07 [INFO]: Transaction committed successfully. 2025-08-13 22:20:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 22:20:07 [INFO]: Shopify Inventory id 42511078097063 2025-08-13 22:20:07 [INFO]: Shopify Location id 58450641063 2025-08-13 22:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T22:20:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 22:20:07 [INFO]: Change: available | Delta: -1 2025-08-13 22:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-13 22:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44599695 and user_id = 14409 2025-08-13 22:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492404 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:20:07 [INFO]: updateIdsQuantity -> ["77492404"] 2025-08-13 22:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 22:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77492404 THEN 0 END, quantityflag = CASE WHEN id = 77492404 THEN 0 END WHERE user_id = 14409 AND id IN (77492404) 2025-08-13 22:20:07 [INFO]: QUANTITY Updated IDs: 77492404 2025-08-13 22:20:07 [INFO]: Successfully processed data for user 14409 2025-08-13 22:20:07 [INFO]: Execution Started 2025-08-13 22:20:07 [INFO]: Execution Finished 2025-08-13 22:30:01 [INFO]: Execution Started 2025-08-13 22:30:01 [INFO]: old server sucessfully connected 2025-08-13 22:30:01 [INFO]: sqs client sucess created 2025-08-13 22:30:02 [INFO]: Number of messages in the queue: 0 2025-08-13 22:30:23 [INFO]: Execution Started 2025-08-13 22:30:23 [INFO]: Execution Finished 2025-08-13 22:40:01 [INFO]: Execution Started 2025-08-13 22:40:01 [INFO]: old server sucessfully connected 2025-08-13 22:40:01 [INFO]: sqs client sucess created 2025-08-13 22:40:02 [INFO]: Number of messages in the queue: 3 2025-08-13 22:40:02 [INFO]: item found in queue is if condition 14409 2025-08-13 22:40:02 [INFO]: item found in queue is 14409 2025-08-13 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBBKH9WDXj6eGHjUlPKZ2rYxvpSy+0HqcJ2J/4eYfFCyYH4RjJPq/ayiZ4JuHaU0MypID33rsLDklAjxPtCT3GqOgv9ZPYLep4UeJjpQMZIPeKazPb04k6p5snst4Ug7OESLgI4hbkNdyVT/vRd4SujKODHnoajHg7II64gg/04u5RYpyn40RzANCaG8sDmqaNBrdoqAtNLPSdl+UEpAp87KhzmdmMtAejEKj7AzhH8X2kogy+qG5C68QUSzqARAXZu1KlMN8tI6um8womaLOYimsJcYs+yJcdgqXJ5qhE6z3pxrWyktPG29dawYa9BBh0ssNZkcMufgyzO90XrNFyiuJ6oWx9O27W9eegPD95hFgonAh33exSa3Y2gvNVATvP9Fptg/XZJaXj1y7Bfq2S/T+6kIw0SsChSOfwJY2ckL8HSgeAZFihy3pJUnznW4zF 2025-08-13 22:40:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:40:03 [INFO]: item found in queue is 14409 2025-08-13 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNQpd6gMk2jaivXvx9k6STlv0uaV4X3dJ0Y21JywmPUnM0xLG1QATW0EQ6MlPLys8qyYHfwqBce05G5JvkU4FZv+K2sk+GXAhuq6KAQQ6gGfzlt1mR4U5T7la1C1F/i6Jub8nDmdFgDRMZXaOsr93kudqJ7eI9GeCIxIps1a/PCIdIeK4soFHGZbrY/ewOEF2CVEl38m+Ca2kdA9+pogQRhpB7ZoPPsl9MFpFw/vfIhsmOVoCYznfQ724XOxa4eGKTXbhHqHlQUVETTzV3x7gQnMGX44E5J4+dPcT5bSMExZpzyyoRQEKoOgyXrpxTtItrTCS76tkaiu8Pz86BT0pxpvPLjbQdNBwTcnz5TjaEzCaCI/PPt1FJBtwwr7qJdt5RkLbsvSTsk9eV4r/Jk5u+KCwdZu0GPLmhewzZ262dMNDYIiTy0YIcB9t2CtuZSfE 2025-08-13 22:40:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:40:03 [INFO]: item found in queue is 14409 2025-08-13 22:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBmkN+u3CR1gnM0C/0NMF1tAkCeYfjBSCLnHW35imacEdWDu1NJ0/0s+vRYSuOoveLhzDAHhZwFkjaFq10sz2D6Fc4ayN9hLAcBpdTW8QL26fTRpWzhErjw9xWzGYEGm5ytLPGjHZjFLldQgx7ZZcSzhGSgneCGftWkGKxpyR7gXMsRYPspSSSWd1W5oNZMNbM8vQeewIn4WfI8Wt2zYOC/HXJUc/4/v6A0o6HwhR/r1M+oOtgXAESJ4TnGF6h1TFF9SHAuAuAzhhPMeVvWorTDHezg16AoJLHV2WF4XZNVp84hnQPVvVm7g9UcTiPr6J67nskGk+UyKl9qZzQVchtmu9nFiarGxS2MU2+otGTPZBGWLeqi+tNHY/wBPu07H7XRNIsDrk1mNLq5KIgFJStW01oqmPZM+HtKXICGUbjvIIGVngOEBUETCXY/oNlgDbr 2025-08-13 22:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-13 22:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 22:40:04 [INFO]: inside itemsold and closed 14409 2025-08-13 22:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:40:06 [INFO]: Ebay item id :: 257064355828 exists in Database 2025-08-13 22:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:40:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 22:40:06 [INFO]: inside itemsold and closed 14409 2025-08-13 22:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:40:08 [INFO]: Ebay item id :: 335564333944 exists in Database 2025-08-13 22:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:40:08 [INFO]: inside itemsold and closed 14409 2025-08-13 22:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:40:10 [INFO]: Ebay item id :: 226867540380 exists in Database 2025-08-13 22:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:40:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 22:40:10 [INFO]: in processold action queue is array for {"45314358":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45314358","ebayitemid":"257064355828","deleted":1}},"44560761":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560761","ebayitemid":"335564333944","shopifyproductid":"8699144798430","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8699144798430","shopifyvariantid":"45943349379294","shopifyinventoryid":"48041840378078","shopifylocationid":"","product_id":"44560761","variant_id":"77453441","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45234605":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45234605","ebayitemid":"226867540380","deleted":1}}} 2025-08-13 22:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 22:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:40:10 [INFO]: productIds WHich are having null productid -> [45314358,45234605] 2025-08-13 22:40:10 [INFO]: ebayItemIds WHich are not imported-> ["257064355828","226867540380"] 2025-08-13 22:40:10 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 22:40:10 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 22:40:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45314358,45234605) 2025-08-13 22:40:10 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 22:40:10 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 22:40:10 [INFO]: Transaction committed successfully. 2025-08-13 22:40:10 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 22:40:10 [INFO]: Shopify Inventory id 48041840378078 2025-08-13 22:40:10 [INFO]: Shopify Location id 58450641063 2025-08-13 22:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-13 22:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560761 and user_id = 14409 2025-08-13 22:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77453441 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:40:10 [INFO]: updateIdsQuantity -> ["77453441"] 2025-08-13 22:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 22:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77453441 THEN 0 END, quantityflag = CASE WHEN id = 77453441 THEN 0 END WHERE user_id = 14409 AND id IN (77453441) 2025-08-13 22:40:10 [INFO]: QUANTITY Updated IDs: 77453441 2025-08-13 22:40:10 [INFO]: Successfully processed data for user 14409 2025-08-13 22:40:10 [INFO]: Execution Started 2025-08-13 22:40:10 [INFO]: Execution Finished 2025-08-13 22:50:01 [INFO]: Execution Started 2025-08-13 22:50:01 [INFO]: old server sucessfully connected 2025-08-13 22:50:01 [INFO]: sqs client sucess created 2025-08-13 22:50:02 [INFO]: Number of messages in the queue: 5 2025-08-13 22:50:02 [INFO]: item found in queue is if condition 14409 2025-08-13 22:50:02 [INFO]: item found in queue is 14409 2025-08-13 22:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBRKzBAFFLXU68Y++fTmxRzzllvXuLYp0oeforPRMayI6Gp5w9yM/FS3OapRDs7VQknIShw1ny21GeXSYYVsY4f6XWHsrJ6ED4KRHPMJe5CUC+NGzF7faWNWNLvZUusUuAQAb+aAhU8YYRmjM3bD4f5y61IylfaXhtGkuDCw58B5S2JHQgNZ7Q1GEznQfuntrDRDcid4XMFSh7750YWVXR+6jA5VIezDBKgd5gsuI6ou/Wu61mj7e5rh4hA4z4Rwco4xE7cAk7tfjvg+Uc/8gLk45yJYdLBAu8QH8MlfeyHsEUpTrTzqoJ3lHJCvf6kKMVN2A1WwD+gN1v+BXAvxXaxQiueoEZnaSJVV1U98krAGq0nmJkrHV5wFmitCMGLTl8vHNHb1vRxbiRNJwVP5xmdOxBCs1lAc0/ydIE4wxg9nkfFTNueudHlBEAwoIgU1ob 2025-08-13 22:50:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:50:03 [INFO]: item found in queue is 14409 2025-08-13 22:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBXX1XEDnO6zNaIxYt6LqZn7ZBgw3Z6upwgvxQDIN46d3swgDU+nbaaGHu/9ppw72VUh42MYTS2m4hu126KLtl8T+4Ll+YG2pJRsG+gCQnQ7fTGTjuvfOryBrK8pZ7zGU+hPn8zGWkXfXGK7DOTZVQ3VmM+GCPuGM1A2c3OVlwVhd4VOq53faBaOtoQbMYvyyxsc6//Y9q9bkemHvNasTyRrNWWWPY7L+gogt3B7QjioB3qPQxQR2bVLa/t6QyIoPnqmpTQjHW8CLtiyqEz9vsm60D3ZhUXvHDjavzSSS8MYMRUtNi92nBvhoEwASNbuIZSaSgH0U/9FXh07iPPxkt484A7fZqywGKHMUUuPoINmaApuO52zCPepjuc87f9KE2Jy8shycsEXuzh+wrfQ7hzvBxpn7mD2pTsanjQg2YQDVp08ucjWDjP3ZFlI8kIl5h 2025-08-13 22:50:03 [INFO]: item found in queue is if condition 14409 2025-08-13 22:50:03 [INFO]: item found in queue is 14409 2025-08-13 22:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBC7F1BgBD1YanE8Q0AlYPU+Ki/pUKwHP2dBoOYeOdkMO6gpSfBLnqz1P15AYR0YZpWtKis0qgkeLiAWCDFplF8QoRotlftpUQgEt89Ubh55InooVlnCtpjG3yADCbF9x7ipb31ODfzoGS4wmyWtYtjEkN1348OmQdZ6WJIuDFOROf6y02UZIrZv7x8kDmcKS4q30sgVFPOU/uS0VPQI4J8xdPi0qN0mojtZWg7VHCthpIP36WPP+6IZEXwZfdZVt7k+Fuyo6LIhZxl//EyIzVn7hRlnaETrwfDr0jzOaxTqnC3O7J8tYtKhvcsKpgkTiIjNvaTto+fBCahxidC7sdnd521WsX7r85wZoF9aWMPo1tHew4DHBe6+wVpELcGAYLJHRG+K/+zjddU07t1MkNgK1V+heMCg0OdHpkNVguR8MSXlNeesAShdQkcLMAFUUD 2025-08-13 22:50:04 [INFO]: item found in queue is if condition 14409 2025-08-13 22:50:04 [INFO]: item found in queue is 14409 2025-08-13 22:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBFS8eblE0rr1SXWiw1eY1u1WIy5hAOxTIOK0L8fwSYkQ579b62C8RJKInWyF/zDx+4IYGZfAATmG3Hj7LcZLMmyu+2NnoS+Cm0kxTn/UXbJynyYP/ouPumh3Noc7NlMf/J5U3i5i2wwXFSjHANqm343hTDiQR/P5HHLyT8vvP2uybsz6jmsPj4WYzVCmv0/Fhh+K6Gr30IkdF2v5kfXj/vEz+ALWvVwJ4OiX3hMPoqOjMVVYMxTdYC6ae466kPtPY6ltxW4e+3DyKnLK+q2r+Da/zaakzuL9rbWvPTIhhDbxTH7PNiFonUQqKOPQ9kk9jE9wgvoqjW1N/YwyiFiy+EC0+EVHd48USiT8V63WKL65xJ2C/bkl19ucm0KURNYbnCxfeDemgAfGkUZwwZ7Xu3KPMihihmRUqVwJQlxvnJoLQctn1Aj61GQEfsxOzTxnk 2025-08-13 22:50:04 [INFO]: item found in queue is if condition 14409 2025-08-13 22:50:04 [INFO]: item found in queue is 14409 2025-08-13 22:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBLyAlCFI/HL+1mLzPYPGOF6YrKq3b+t4uX7iaMRhc5mJidxbXtyxVQ8KHODNBmILqgZnjDJCX9OLS2ZThsGgZaGL9yvUR53MXYX7sUfth95riGhhz/jgZlGpxex125fFGvBEc+frYlfSQWLEmelMioTwDKm8IohVr8EPhZjL8/kZ9idAe78q2RYAlvQYefQ/pvm2qt/zXGhkvdhcNhOMGNRautQJyLM2t6OcJQQZKtBw/q0WssXDechm4a2ICE57IyDXZE4pelDfQxkBHT76lkrJ252jYJHDirYHr5mkAd65TXWyfC2sVJ8ccmrnGUEEswQQUhiCSAFtpNn8iHJzBa1pVhMUYVK5yCAB6x7tODAaVXMylAH6nLHPfdDtSYhnTgPFedF/mRoyQILPvqNIIyrz6y8X4wQ5c2/F6RxPgLRCX5HwJvW0mZRQFiZLItDS2 2025-08-13 22:50:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-13 22:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 22:50:05 [INFO]: inside itemsold and closed 14409 2025-08-13 22:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:50:06 [INFO]: Ebay item id :: 286761590246 exists in Database 2025-08-13 22:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:50:06 [INFO]: inside itemsold and closed 14409 2025-08-13 22:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:50:08 [INFO]: Ebay item id :: 326374519087 exists in Database 2025-08-13 22:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:50:08 [INFO]: inside itemsold and closed 14409 2025-08-13 22:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:50:10 [INFO]: Ebay item id :: 323265893715 exists in Database 2025-08-13 22:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:50:10 [INFO]: inside itemsold and closed 14409 2025-08-13 22:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:50:12 [INFO]: Ebay item id :: 306159001078 exists in Database 2025-08-13 22:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:50:12 [INFO]: inside itemsold and closed 14409 2025-08-13 22:50:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 22:50:13 [INFO]: autolink for user_id 14409 is 1 2025-08-13 22:50:13 [INFO]: Ebay item id :: 286227541732 exists in Database 2025-08-13 22:50:13 [INFO]: Item is reliested :: exists in Database 2025-08-13 22:50:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 22:50:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 22:50:13 [INFO]: in processold action queue is array for {"45314109":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45314109","ebayitemid":"286761590246","shopifyproductid":"8985421086942","variants":[{"price":"13.99","quantity":0,"weight":"2","shopifyproductid":"8985421086942","shopifyvariantid":"47439842312414","shopifyinventoryid":"49551700099294","shopifylocationid":"58450641063","product_id":"45314109","variant_id":"78266622","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44653329":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653329","ebayitemid":"326374519087","shopifyproductid":"8766538219742","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8766538219742","shopifyvariantid":"46158852849886","shopifyinventoryid":"48258186543326","shopifylocationid":"","product_id":"44653329","variant_id":"77558518","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44663661":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44663661","ebayitemid":"323265893715","shopifyproductid":"6633493299367","variants":[{"price":"9.94","quantity":0,"weight":"0","shopifyproductid":"6633493299367","shopifyvariantid":"39650445164711","shopifyinventoryid":"41745085563047","shopifylocationid":"","product_id":"44663661","variant_id":"77568881","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44558789":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44558789","ebayitemid":"306159001078","shopifyproductid":"8838242304222","variants":[{"price":"13.99","quantity":0,"weight":"2","shopifyproductid":"8838242304222","shopifyvariantid":"46352503668958","shopifyinventoryid":"48454226837726","shopifylocationid":"","product_id":"44558789","variant_id":"77451469","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44669589":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44669589","ebayitemid":"286227541732","shopifyproductid":"8771608051934","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8771608051934","shopifyvariantid":"46169678971102","shopifyinventoryid":"48269139345630","shopifylocationid":"","product_id":"44669589","variant_id":"77574809","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 22:50:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 22:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:50:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 22:50:13 [INFO]: Shopify Inventory id 49551700099294 2025-08-13 22:50:13 [INFO]: Shopify Location id 58450641063 2025-08-13 22:50:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T22: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":1930,"restoreRate":100}}}} 2025-08-13 22:50:13 [INFO]: Change: available | Delta: -1 2025-08-13 22:50:13 [INFO]: Change: on_hand | Delta: -1 2025-08-13 22:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45314109 and user_id = 14409 2025-08-13 22:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266622 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:50:13 [INFO]: Shopify Inventory id 48258186543326 2025-08-13 22:50:13 [INFO]: Shopify Location id 58450641063 2025-08-13 22:50:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T22:50:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 22:50:14 [INFO]: Change: available | Delta: -1 2025-08-13 22:50:14 [INFO]: Change: on_hand | Delta: -1 2025-08-13 22:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653329 and user_id = 14409 2025-08-13 22:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558518 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:50:14 [INFO]: Shopify Inventory id 41745085563047 2025-08-13 22:50:14 [INFO]: Shopify Location id 58450641063 2025-08-13 22:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T22:50:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-13 22:50:14 [INFO]: Change: available | Delta: -1 2025-08-13 22:50:14 [INFO]: Change: on_hand | Delta: -1 2025-08-13 22:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44663661 and user_id = 14409 2025-08-13 22:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77568881 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:50:14 [INFO]: Shopify Inventory id 48454226837726 2025-08-13 22:50:14 [INFO]: Shopify Location id 58450641063 2025-08-13 22:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-13 22:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44558789 and user_id = 14409 2025-08-13 22:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77451469 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:50:14 [INFO]: Shopify Inventory id 48269139345630 2025-08-13 22:50:14 [INFO]: Shopify Location id 58450641063 2025-08-13 22:50:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 22:50:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-13 22:50:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 22:50:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44669589 and user_id = 14409 2025-08-13 22:50:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77574809 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 22:50:15 [INFO]: updateIdsQuantity -> ["78266622","77558518","77568881","77451469","77574809"] 2025-08-13 22:50:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-13 22:50:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266622 THEN 0 WHEN id = 77558518 THEN 0 WHEN id = 77568881 THEN 0 WHEN id = 77451469 THEN 0 WHEN id = 77574809 THEN 0 END, quantityflag = CASE WHEN id = 78266622 THEN 0 WHEN id = 77558518 THEN 0 WHEN id = 77568881 THEN 0 WHEN id = 77451469 THEN 0 WHEN id = 77574809 THEN 0 END WHERE user_id = 14409 AND id IN (78266622,77558518,77568881,77451469,77574809) 2025-08-13 22:50:15 [INFO]: QUANTITY Updated IDs: 78266622, 77558518, 77568881, 77451469, 77574809 2025-08-13 22:50:15 [INFO]: Successfully processed data for user 14409 2025-08-13 22:50:15 [INFO]: Execution Started 2025-08-13 22:50:15 [INFO]: Execution Finished