Encerrado

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 :)

Habilidades: Programação de Banco de Dados, PHP, SQL

Ver mais: Input products into woo commerce store, Upload products to woo commerce, product uploading in woo commerce, woo commerce point sale, need product sale, product category commerce, need soeone products oscommerce website, affiliate need product, need product display, upload products commerce via excell, need sell products, need product sell, import product magento commerce, designer sunglass commerce website sale, edit product reviews commerce admin

Acerca do Empregador:
( 20 comentários ) Seattle, United States

ID do Projeto: #14793267

33 freelancers estão ofertando em média $20/hora para este trabalho

mituld

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

$15 USD / hora
(366 Comentários)
8.1
gopalvora

Hello We are a team of professional developers and designers here to help you building your website and Application. We have been in the market for over two years, but new at freelancer. We are more conc Mais

$15 USD / hora
(426 Comentários)
8.1
WebInfoSolutions

Do you prefer doing everything from scratch with a high speed implementation and good programming work?

$21 USD / hora
(165 Comentários)
7.7
wpoppo

Following points that makes me the best candidate: 1. Understanding requirements quickly and easily 2. Following and implementing instructions perfectly 3. Developing awesome bug-free sites 4. Delivering on t Mais

$20 USD / hora
(107 Comentários)
7.5
qualifiedcoders

Hi, Good Day! We have read your post and would like to discuss further as we have a team of Wordpress developers who are experts in wordpress skinning, plugins & custom module development and have developed many Mais

$15 USD / hora
(23 Comentários)
7.3
ss86precursor

Hello, I see you need to fix price changing script to update values instead of storing them in the database. I'm Sergey from ProfIT Company and we're the perfect fit for you, because we're 5 years experienced PHP de Mais

$22 USD / hora
(12 Comentários)
6.7
Shopify

Hi, I (Myself a senior PHP Developer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the ve Mais

$20 USD / hora
(20 Comentários)
6.9
richestuser

Hi, I am skilled developer ...and if I had any Idea this much work is needed , I would have given you better cost estimation....I am an experienced senior web developer & Database administrator. I am quite handy on bo Mais

$24 USD / hora
(158 Comentários)
6.8
sphinxsolution

(From the makers of Vivino & Dah Makan) Hi, I hope you are doing well, We are 7 year young rapidly growing Website and Mobile App Development Company based out of New Jersey, USA, Gold coast, Australia & Pu Mais

$15 USD / hora
(10 Comentários)
6.8
DavidLiu80

Hello, Nice to meet you. I am an experienced web and mobile developer on this site. I have a great profile by completing over 100+ mobile apps and site tasks and got the great skills and experiences so far. So I am s Mais

$21 USD / hora
(41 Comentários)
7.0
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Mais

$20 USD / hora
(53 Comentários)
7.0
mithusamsukha

Dear Client Greetings I am Worpress developer, HTML coder and in some cases designer. I set up many websites using Wordpress, Woo-Commerce, Drupal and Joomla. I like Wordpress very much!!! I am well exper Mais

$15 USD / hora
(57 Comentários)
6.0
maksimchukmak

Hello! My name is Maksim, from Kiev, Ukraine (UTF + 2) We are IntoBi - hardworking and responsible team. Our developers have highly experience in the building of various websites and apps. Our team has excellent Mais

$27 USD / hora
(23 Comentários)
5.9
ShiaFirst

Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [url removed, login to view] message me to have a quick chat.

$20 USD / hora
(77 Comentários)
6.1
jexcoreinfotech

Hello Sir, Hope you are doing well!!! Detail About our Company: At Jexcore Infotech Pvt. Ltd. We’ve a talented pool of technical professionals that have experience within the latest Mobile Application, Web appli Mais

$22 USD / hora
(11 Comentários)
5.5
vinaysinghh

A proposal has not yet been provided

$16 USD / hora
(37 Comentários)
5.1
hamidali1994

Lets Start working on it now Lets Start working on it now Lets Start working on it now Lets Start working on it now Lets Start working on it now Lets Start working on it now Lets Start working on it now Lets Sta Mais

$22 USD / hora
(13 Comentários)
4.6
HongCStar86

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

$27 USD / hora
(7 Comentários)
4.5
softcarve

Hi, I would like to update the direct value in the database with promo code. Please share details. So that we can take things forward. Thanks.

$22 USD / hora
(15 Comentários)
4.4
zdesign77

Hey, how is it going today? My name is Michael, I'm a web designer/developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. In fact, I did a very sim Mais

$22 USD / hora
(6 Comentários)
4.1