Hi,

I have an Oscommerce web site modified with a lot custom php scripts. Web is working fine but sometimes waste too much resource by the bad written programming and bad mysql table setting. I would like to improve my web programming and db setting in order to have better performance while use less system resources. I want to know if there is any company that can do this service? What exact should I call this kind of service? Thanks

If you're willing to pay to have a development company rewrite the bulk of OSCommerce, you might just want to consider switching to different software, because it will cost you a lot less!

We are big fans of Pinnacle Cart. It's very well programmed (from what I can see - admittedly, I haven't seen it in a shopping environment where there are thousands of transactions per day, or anything like that), and the templating system gives you a lot of freedom over how the site lays out. I've converted Pinnacle to a CSS-based layout with relative ease in the past.

Building a cart from scratch is probably better than trying to reprogram OSCommerce - it doesn't really do you much good to start with a broken model :) In lieu of designing a custom cart (which would also be extraordinarily expensive), I would definitely consider Pinnacle!

As the_pm has said it will be very costly to have the whole site rewritten.
The only thing I would suggest is like the_pm and thats to either look into a different cart suite like Pinnical or have a custom writeen application/cart.
I would suggest the later if you have enough time and resources, no prebuilt scripts like OScommerce and Pinnicle can compare to something custom built to your exact needs.

Thank you so much for the advise.

To use a new shopping cart that means I have to spend a lot of time working with web master plus I have to make a complete planing on what needs to be done. I believe it is more afford for me to just ask for a rewrite. Because I think for rewrite, the web master can easily check which php page and mysql query should be improve. I will check out the Pinnacle see how hard for me to start from scratch.

Thank you so much for the advise.

To use a new shopping cart that means I have to spend a lot of time working with web master plus I have to make a complete planing on what needs to be done. I believe it is more afford for me to just ask for a rewrite. Because I think for rewrite, the web master can easily check which php page and mysql query should be improve. I will check out the Pinnacle see how hard for me to start from scratch.If you can find a good database migration script (and I believe this shouldn't be too hard to find), setting you up with Pinnacle would be as simple as installing it, migrating the DB and skinning the cart.

One of the big problems with rewriting OSCommerce is that you no longer have a migration path. So if you rewrite it, and a week later a big security hole is found, you're going to end up doing all of that work again. And this problem will be magnified over time as you upgrade and rewrite over and over. You'll waste precious money and time, and between upgrades, you'll have security issues with your cart. AND...it'll probably cost more just for the first rewrite than moving to a better cart. So why put yourself through all of that? :)

I see. That make sense to me. I will just use another shopping cart instead of doing rewrite. thanks

This would probably be referred to as optimization. I m sure you can find a PHP developer in your area that can handle this.. I would recommend not going to a "Website" company to get this done as you will end up paying more because they will act as a middle man. Try to find a PHP/MySQL developer in your area and work directly with them. Obviously, finding a developer with OSCommerce experience is recommended.

You should consider using ZenCart. It was originally based on osCommerce, but it has a lot of the bugs/issues fixed. Also, ZenCart is actively developed. There is even a book about how to use ZenCart.

One of the most important things about ZenCart is that it works with register_globals off unlike the outdated osCommerce.