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 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.
32 freelancers are bidding on average $20/hour for this job
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
Hello, dear I have read your job post in detail I am very interested in your job because I have all skills you need. Please see my profile. I can fix it in a couple of hours. Thanks Best regards, Hong