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

$15-25 USD / hour

Closed

Posted

almost 7 years ago

$15-25 USD / hour

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

Database Programming

PHP

SQL

Project ID: 14793267

About the project

31 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

31 freelancers are bidding on average $20 USD/hour for this job

@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 in 40 days

4.9

(466 reviews)

8.2

@WebInfoSolutions

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

$21 USD in 40 days

4.9

(224 reviews)

7.9

@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 experienced with eCommerce store, online store, Wordpress theme design, Wordpress theme customization, Wordpress webshop, Wordpress plugin creation and Wordpress extension development. I did much work to adjust sites for their requirements doing PHP programming for e-mail subscriptions, pop-ups alerts, not standard registration forms and complicated pop-up menus. I have worked on a number of built-in wordpress plugins and can manage it well. I believe my abilities would be perfect for your venture. I can finish this job within the necessary time frame. I have years of experience in Wordpress and can provide you my past sample work as well. I will be serving you with all my hard work and skills. Kindly get back to me Regards : Mithu

$15 USD in 40 days

5.0

(82 reviews)

7.9

@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 concerned on reputation and building client relationship. We offer you money back guarantee if your experience working with us does not exceed your expectation.

$15 USD in 40 days

4.7

(519 reviews)

8.3

@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 very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Warm Regards ~Team Shopify

$20 USD in 40 days

5.0

(27 reviews)

7.0

@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 both front/backend. I will give you update regarding your project after every two hours during project. I think i'll be perfect for this job regarding my skills- Wordpress theme development and customization Plugins development Bootstrap Photoshop HTML5 CSS3 AJAX JavaScript Jquery WooCommerce Advanced PHP Please contact for more discussion... Thanks & Regards Richestuser

$24 USD in 40 days

4.9

(239 reviews)

7.2

@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 your needs, which will yield a clear picture of implementation phase. Prior undertaking project, I want to show demo of the work done previously. Apart from demo, I will be sharing following documentation which will turn your project into Quality and Successful delivery: - Technical Project Proposal - Designs - Flow chart for this Project - Execution plan Thanks

$20 USD in 40 days

4.8

(55 reviews)

7.1

@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 in 40 days

4.9

(126 reviews)

6.3

@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 skills and experiences in HTML5, PHP, Java, JavaScript, Joomla, Laravel, Angular, CodeIgniter and other. So we can help you with database update statement! Will be glad to cooperate and construct the partnership with you! Can I propose you to discuss this with us (Removed by Freelancer.com Admin)? Kind Regards Maksim CEO IntoBi

$27 USD in 40 days

5.0

(25 reviews)

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 application and other technologies. Our innovative ways for IT services have created us the leaders during this field. Jexcore Infotech Pvt. Ltd. employees are the cream of the talent crop. We offer value to our customers by giving several edges to them together with speed to promote, high quality folks and processes, innovative technology. We are leading Games, Web and Mobile apps Development company in India. Regarding your Project: We have analyst your job details and as per that we would like to clear few things with you, kindly Personal Message us, so we can discuss. We would like to discuss your project with you and work in your job. If you can trust us, Just develop your first job with us and see our result. After that you can take decision for other Job. Let us know. Regards, Jexcore Infotech Pvt. Ltd.

$22 USD in 40 days

5.0

(13 reviews)

5.6

@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 similar project recently which I can share with you. Let me know when you have a minute to discuss.

$22 USD in 40 days

5.0

(7 reviews)

4.9

@vinaysinghh

A proposal has not yet been provided

$16 USD in 5 days

4.8

(48 reviews)

5.2

@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 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

$22 USD in 40 days

5.0

(14 reviews)

4.6

@sarbajitpal

Will charge only $40 for this assignment .Gone through your requirement of making changes in PHP ,database portion in order to have a quick,effecient and correct implementation of promo code for products Relevant Skills and Experience:- Worked in MNC's like Accenture,Infosys. Handled projects involving millions of transaction data from scratch. Experienced in database design,database Proposed Milestones $15/hr- NO ADVANCE PAYMENT REQUIRED Will strictly follow Agile Methodology and TDD development approach. PLEASE SHARE FURTHER DETAILS ABOUT THIS PROJECT. READY TO DELIVER A DEMO ON SMALL MODULE.

$15 USD in 40 days

5.0

(5 reviews)

2.9

@CHREHAN

Hi, I have almost five year of experience as application developer. following are my area of expertise. C#,Power BI,Pentaho,MDX,BigData,Database Designing,Database Development,SSRS,SQL Scripting

$16 USD in 30 days

4.7

(4 reviews)

2.6

@mmaguire0311

I have been working with PHP and MySQL for over 10 years and will be able to get this job done quickly. I will additionally review the rest of your database scheme (if you wish) and create any indices or updates that will make it run more efficiently.

$16 USD in 20 days

0.0

(0 reviews)

0.0

@inetfreelancer

I have vast experience of 8 years in SQL, Stored Procedures, PHP and PHP MyAdmin. I have developed Hotel Management System using these skills. I am willing to do this work. I can give any test to prove if required.

$15 USD in 40 days