Create a MySQL statement that will update the price of all gold products based on the weight

$30-250 USD

Completed

Posted

almost 11 years ago

$30-250 USD

Paid on delivery

I am using a Magento website to sell gold coins and various gold products. I am also using an XML feed to get the updated price of gold per ounce. I already have a PHP script that parses the XML feed for the price and retrieves the price per ounce, now I need a MySQL statement(s) that will take that price per ounce, multiply it by the weight of each gold product in the DB, which is in OZ, plus 3% and update the price for each product with that value in the DB. This needs to be done ASAP.

Magento

MySQL

Project ID: 4598529

About the project

2 proposals

Remote project

Active 11 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

Awarded to:

@umesh1787

Have a kind look at PM to see my detail proposal & accept my bid to start work immediately.

$105 USD in 1 day

4.8

(6 reviews)

3.2

2 freelancers are bidding on average $108 USD for this job

@bddevel0per

We provide you industry standard Mobile Apps, Software, Desktop Apps, Web Stores, Websites and Web Apps. So, you get all at one place! We can provide you the following: - iOS applications - Android applications - Software for all purposes - Desktop applications - Websites - Web applications - Ecommerce websites/ Web stores We specialize in: - Objective C, Cocoa, iOS 4, 5, 6 - Java, Google Android - WordPress, Joomla - WP Ecommerce, Magento - PHP5, PHP, MySQL - C#, C++, C - ActionScript 3.0, AIR, XML f

$111 USD in 3 days