Need help with database update statement. Goal: Update THIRD displayed (promo code) price in product title based on 20% off calculation from the sale price - woo commerce products (700+)

We have 3 prices displayed on our products on pages where the products are listed. We have "Regular price" which has a slash through it. We have "Sale price" which is the product price without a promo code We have "promo price" which is displayed as part of the product title name on listing pages. Initially we had some poor php code executing and calculating 20% off every products "sale" price which creates the "promo price" and was displayed to look like it was part of our product title For example : [PRODUCT IMAGE] [PRODUCT TITLE – $80.00 using promo code: Happy] [Regular price: $133.00] [Sale price: $100.00] Meaning if the customer purchased the product it would cost $100.00. But if the customer used promo code “Happy” at checkout the product would only cost $80.00 The current php method is not okay for us. It slows down our site. We need to use some type of script to update these values instead so they are stored in the database. We need to be able to run this script anytime we change our products price – with instructions on how to run it correctly. You will have access to 2 individuals who know the website very well and can set you up with any live development environments you may require, along with the owner of the site who has a history in programming and would like it done a specific way. APPLICANTS MUST LIVE OR LIVE NEAR THE TIMEZONE OF THE USA – MUST BE ABLE TO COMMIT AT LEAST 8 HOURS WORKING !!!TODAY!!!!. IF THE PROJECT IS DONE WELL AND FAST THERE IS OPPORTUNITY FOR DAILY WORK. LOOKING FOR SOMEONE SKILLED WITH DATABASE WORK SPECIFICALLY USING STORED PROCEDURE METHODS. STRONG KNOWLEDGE IN PHP, PHPMYADMIN, SQL AND FAIMILAR WITH WORDPRESS/WOOCOMMERCE WEBSITES. LOOKING FOR SOMEONE ASAP! MUST BE QUALIFIED IN ALL MENTIONED ABOVE. Thanks :)