OSCommerce (MySQL help needed)

In Progress


The project here is pretty straight forward. On my clients site there is a large database of products in a OSCommerce eCommerce store. What ever the price is on any given product, I want it to end with ( $[url removed, login to view]) . eg. If the price shows $[url removed, login to view] I want it to show $23.00. If it shows $[url removed, login to view], I want it to show $57.00. In short, I want the cents section to just reflect .00 (no cents).

This is a fairly large database so I don't want bids to do each item one at a time. What I'm thinking can be done (but I'm not the SQL pro here so let me know if you have another idea) is to pull the SQL database from the cPanel, convert to an editable form like .csv or .xls so you can just do a one time mass change to reflect the new price(s). All the dollar amounts will be the same, I just want all the cents reset to .00 and then do a data dump back to the sql database.

If you can think of an easier way to do this that's fine. I would expect a very good back up of the "entire" database so nothing is lost or currupted in the process that can't be replaced if an accident occured.

Please put your ideas on how to do this in a PM to me and give me your best price to convert the entire database to me. Do a good job and I may award you other work. I own a Project Management company here in the USA and have many jobs going on several of which are open for bidding on now. Looking forward to awarding this project pretty fast so I'm only going to run this ad for less than a week, but probably will award it in a couple days. I need the work done now.

Be very accurate on the time frame it'll take you to finish the job.


Payment will be made using Freelancers broker service and will be paid in full once I see the entire project is completed successfully the way I've described here. No milestone payments or upfront payments will be given so please don't ask. Just look at my feedbacks and you'll see I always pay on time as promissed and I'll of course put the funds in escrow with freelancer so you'll see it ready to be paid out as soon as the job is complete.

Thank you,

Michael D Baker

Project Management, USA

Skills: Data Entry, Database Administration, MySQL, OSCommerce, PHP

See more: which is the best site for freelancers, what to do freelancer usa, what's an escrow service, what is a data entry form in a database, what if the freelancer end the job, what freelancers want in clients, usa escrow service, usa best freelancer, t sql jobs, t sql freelancer, site freelancer usa, service now jobs, service now freelancer, pull escrow, project management for clients freelancer, pro freelancer site, pro freelancers, php project management freelancer, mysql job freelancer, mysql freelancers, mass jobs, jobs in the usa, jobs in mass, jobs completed freelancer, is escrow a one time payment

Project ID: #4165182

32 freelancers are bidding on average $74 for this job


pls chk pmb

$30 USD in 0 days
(533 Reviews)

Hello! I can help you with this work. I am OSC and MySQL expert. Thanks!

$50 USD in 0 days
(396 Reviews)

we can do ti for you

$45 USD in 1 day
(526 Reviews)

i can do that for you.check pmb.thanks.

$35 USD in 0 days
(353 Reviews)

I can do this very quickly for you today.

$50 USD in 1 day
(89 Reviews)

OK, a message would be flying towards you in just a sec. Kind Regards

$30 USD in 0 days
(249 Reviews)

Full time freelance web developer with over 8 years of commercial experience.

$30 USD in 3 days
(88 Reviews)

Hello, I am very experienced in Oscommerce,please view my recommendation in private message Thanks

$80 USD in 2 days
(113 Reviews)

Greetings! I am very well familiar with oscommerce. Clear with the requirement. I can do it right away. thanks

$40 USD in 1 day
(134 Reviews)

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$40 USD in 0 days
(37 Reviews)

hi, i'm gonna send you an email to explain you better how can i do it.

$40 USD in 0 days
(57 Reviews)

Hi, Kindly Check PMB

$250 USD in 2 days
(15 Reviews)

Hi, MySQL expert with experience in OSCommerce db schema. This won't take me long at all. Please review PM for details.

$50 USD in 1 day
(34 Reviews)

It is very easy job, pls check pm for more detail

$30 USD in 0 days
(73 Reviews)

Lets do it.Ready to start immediately.

$45 USD in 1 day
(48 Reviews)

We can start immediately. Quality work promised.

$40 USD in 1 day
(123 Reviews)

Hi Please see PM.

$85 USD in 1 day
(15 Reviews)

I am ready to start immediately. Please check PM for details.

$30 USD in 1 day
(30 Reviews)

Hi, We have thoroughly read your requirements and believe that we can deliver exceptional results. Experienced osCommerce developer ready to begin your project. Please check your PMB and let me know. We hope you wi More

$30 USD in 0 days
(24 Reviews)

Hello sir I can resolve this issues in 2 hours. thanks

$30 USD in 0 days
(12 Reviews)