Linux.com

Feature

OSCommerce in action

By Rob Sutherland on June 02, 2005 (8:00:00 AM)

Share    Print    Comments   

What's the best way to use the Web to sell products? A good open source option is OSCommerce, a shopping cart package that uses Linux, Apache, MySQL and PHP (LAMP) software. Because it's open source, companies that use it can customize it themselves to better meet their needs.

I spoke to a variety of companies that use OSCommerce. They sell everything from girls' socks to embedded software, and their business models run from mom-and-pop through full-blown manufacturing/distribution operations. In general, they had good things to say about the software. They noted that OSCommerce has been around since 2000 and has a large user community and a huge collection of contributions -- packaged sets of code modifications or documentation -- which is both a blessing and a curse. Many of them have made changes and additions to the code, which they then contributed back to the project. Some other positives that they pointed out:

  • OSCommerce has the ability to create optional product attributes, such as color and size.
  • The Web-based administration panel makes it possible for relatively inexperienced users to add and maintain product info.
  • Both sales taxes and value-added taxes (VAT) can be configured for a variety of scenarios.

On the other hand, these companies had some issues with the software as well:

  • The Web-based admin program can be cumbersome, especially the product entry and update pages, which have a large and confusing collection of options.
  • The handling of images is confusing.
  • Branding is complicated. It's hard to locate where things need to be changed and to ensure those changes can be carried over to new versions.
  • The large number of contributed packages and their varying quality can be a problem. Picking the ones that will work best for the business and maintaining them can be a real time sink. Ensuring that you don't install conflicting changes or overwrite existing code can be frustrating.

Some of the companies I spoke with offered more specifics. Everything Tights, an online-only retailer of girls' socks and tights, had no experience with PHP or MySQL when they first started using OSCommerce, but it had no problem setting up the software. Owner Mark Russell says his company would like enhancements, such as the ability to do global updates and similar mass operations through the Web backend.

Subrosasoft writes and sells backup and utility software for the Macintosh platform. Like Everything Tights, Subrosasoft's owner Marko Kostyrko had no problems with installation but had to modify the base package, in his case to handle users' downloads properly.

Batch Tech provides e-commerce solutions using OSCommerce and Zencart, another popular shopping cart program. Owner David Hardesty has been involved with OSCommerce since it began. He finds it one of the easiest e-commerce packages to install and set up. The only real drawback he sees is that the tax system is written from an international point of view, and can be confusing to U.S. users.

Element Computers retails an embedded Linux office server, and supports a network of resellers through the use of a content management system (CMS) called Mambo. It has integrated OSCommerce with Mambo so that they share common graphics and product data and appear to be one site. The company's main frustration is the lack of global functions to allow, for example, mass discounting of prices and export of groups of data in Quickbooks/CSV format.

Although OSCommerce is relatively easy to administer, customization and integrating changes can be extremely complex for new users and developers. The companies I talked to solved these problems in one of three different ways:

  1. They learned enough LAMP administration skills and PHP/MySQL and Linux concepts to install contributed packages and customize the base package. The key in this case is to make good use of the community as a training and support resource.
  2. They already had the necessary skills as IT professionals, and picked up expertise from the community and contributed back.
  3. They paid a professional to undertake the work for them. If you choose this approach, make sure that you can communicate well with whomever you choose, and look for a consultant who's honest and stable. Make sure that he's prepared to deal with things besides coding and technical support; you'll need good copy and graphics to make your site stand out, plus someone who can explain things in terms you'll understand.

The most common complaint I found from OSCommerce users was the same one I've heard about other e-commerce packages. People weren't aware of how much work would be involved in getting everything put together. They would get to a certain point, hit an unexpected bottleneck, and be unable to keep going. The majority of the work involved in getting any e-commerce package working is to organize your products, take attractive pictures, write solid descriptions, and learn to work with the package and make it part of your business operation. Every implementation will run into these problems, and everything takes longer and costs more than you plan for it, whether it's proprietary or open source. If you take a step-by-step approach, by putting only a portion of your inventory online at first or picking a small set of features to implement, you can avoid getting overwhelmed.

A key to success with OSCommerce are to first analyze your business and carefully look at operations. Make sure that you have or can obtain the skills you'll need to customize the software for your needs. Set a clear goal that will let you select only the correct enhancements for your situation. Keeping OSCommerce running and updated over time will require you to carefully track your changes and work out methods to keep it updated safely, such as installing a local version on a server in your office (or even a Windows workstation) and transferring the entire package to your ISP only after testing rather than updating things on the fly.

If you keep these points in mind, you'll find that OSCommerce can help move your product.

Share    Print    Comments   

Comments

on OSCommerce in action

Note: Comments are owned by the poster. We are not responsible for their content.

great piece of software from a programmer

Posted by: Anonymous Coward on June 02, 2005 07:37 PM
i pretty much learned php from this package. a crash course if you will with well written and consistent code. i had to ditch the admin interface because the design given to me was too far off from what oscommerce provides. for now, i have the commerce piece disabled but have a newer more beautiful interface in the works with a non-mysql search engine and actual commerce in the works. (<a href="http://betatoolsusa.com/" title="betatoolsusa.com">http://betatoolsusa.com/</a betatoolsusa.com>).

i would recommend oscommerce to anyone with a little php experience (or none like myself initially) because of the vast assortment of extremely useful addons (<a href="http://www.oscommerce.com/community/contributions" title="oscommerce.com">http://www.oscommerce.com/community/contribution<nobr>s<wbr></nobr> </a oscommerce.com>) and helpful community (<a href="http://forums.oscommerce.com/" title="oscommerce.com">http://forums.oscommerce.com/</a oscommerce.com>).

#

Re:great piece of software from a programmer

Posted by: Anonymous Coward on June 02, 2005 10:47 PM
Pimp Daddy says is Gooooood!

#

Totally rotten code!

Posted by: Anonymous [ip: 83.140.180.153] on August 30, 2007 02:36 PM
This among the top five of the worst pieces of code I've ever seen. SQL statements mixed with HTML. I would never hire someone who wrote code like that.

#

zencart

Posted by: Anonymous Coward on June 02, 2005 08:58 PM
<a href="http://www.zencart.org/" title="zencart.org">http://www.zencart.org/</a zencart.org> An oscommerce fork that is actually supported.

#

Re:zencart

Posted by: Anonymous Coward on June 02, 2005 10:43 PM
What do you mean by "actually supported"? OSCommerce is supported as well as Zencart... You just can't deal with anything that doesn't have templates.

#

osCommerce is great

Posted by: Anonymous Coward on June 03, 2005 03:42 AM
I have done two sites with osCommerce. On one site we where able to use a special plug-in from Sysbotz and there sales software to provide a complete suite for managing inventory and orders for the sites office staff. Check it out at <a href="http://www.sysbotz.com/" title="sysbotz.com">http://www.sysbotz.com/</a sysbotz.com>.

#

Re:osCommerce is great

Posted by: Anonymous Coward on June 03, 2005 05:14 AM
Still others get a boost in using osCommerce by using CRE Loaded - a version of osCommerce which includes about 50 of the most popular contributions, including more payment and shipping modules. Support for this package is found at <a href="http://creloaded.com/" title="creloaded.com">http://creloaded.com/</a creloaded.com> .

#

The KDE Effect.

Posted by: Anonymous Coward on June 03, 2005 07:01 AM
"The Web-based admin program can be cumbersome, especially the product entry and update pages, which have a large and confusing collection of options."

Better known as the KDE effect. OSS seems to have this obsession with control. If you can't do something to 'it', then someone's "dictating to you" or "taking away your rights (freedom)" e.g.Gnome.

"The large number of contributed packages and their varying quality can be a problem. Picking the ones that will work best for the business and maintaining them can be a real time sink. Ensuring that you don't install conflicting changes or overwrite existing code can be frustrating."

The standard OSS answer is to...wait for it...Hire some middleman to do what OSS and their "Bazaar" methodolgy implicitly promises. e.g We're better than that stoggy old "cathedral" model.

#

total crap

Posted by: vtre17 on June 03, 2005 07:52 AM
I wonder why people still recommend osCommerce. It is the most horrible PHP script mess I've seen so far. If it can be used for something, then only to learn how not to "program".

Twelve-times nested table layouts paired with clumsy use of CSS makes it look like a dino from the mid nineties. There is obviously no real database abstraction (an API layer maybe), and SQL commands intermingled with unmaintainable HTML throwing-out code. It's therefore no wonder, that so many companies are making money from "customizations" of it (if you want to adapt anything, you mostly have to rewrite code; qickly gets annoying because of its overall code quality).

I admit I haven't looked into it, since I've last looked and laughed at it, but I'm sure no rewrite or fork could have fixed such a project.

And btw, I think it is one of those projects that _abuse_ the term "open source" for questionable marketing reasons (the "os" in "osCommerce" abbreviates that).

#

Re:total crap

Posted by: Anonymous Coward on June 03, 2005 10:33 PM
How does osCommerce abuse the term "open source"? You are able to get the product and look at it's source? Nothing is closed? Open Source does not mean "Perfect Method of Coding" that's called being "ANAL". There is a "Soon To Be" open source project out there where the author wants to publish it's code but because he feels the code a mess he won't until he gets more time to clean it. It's been a year and nothing has been published. By now, it's devoted users would have done the job for him. If the product works and you want to publish it then go ahead. I don't care if the entire application was written with BASIC and no function calls!

For an open source project that is nearing 6 years old, osCommerce in great shape even with it's problems. I have looked at the other forks and have opted to stay with osC because I usually have to customize it. Remember to re-write everything will mean that you throw away time that could be used for features and you lose it's massive library of add-ons which in turn you lose many of it's users.

I think osC should be offically forked by the authors and have a team working on the re-write with the acceptance that you will lose all the add-ons. The system should be modularize and should separate design and code [MVC].

#

Re:total crap

Posted by: Anonymous Coward on June 04, 2005 04:26 AM
My guess is thats becuase you dont understand what a good open source project is and you probably dont know how to code so you make fun of someone elses code.

#

Re:total crap

Posted by: Anonymous Coward on June 05, 2005 09:02 AM
No, I just did an osc repair, I'd never worked with it before, although I have worked a lot with other open source apps like phpbb, which have several things osc simply seems to have given up on:

active development
useful websites
useable forums

I'd never use osc again, I can totally see why the zen cart group forked their project, osc is ridiculous, the worst programming I've seen in a long time, and the last release was in 2003 I believe. This is a dead project, I'd never use it again.

Zen cart however looks pretty good, templating system, which osc must have if it wants to be taken seriously as far as I'm concerned.

This is not a criticism of open source, which often works very well, but it looks like the core developers have left the building over a year ago. Don't get caught by the name, it's not happening any more.

I know an ex osc developer, he likewise quit, and was very unimpressed, to put it mildly, with how osc is run.

#

Zencart is a somewhat nice replacement

Posted by: Anonymous Coward on June 05, 2005 02:55 AM
My company is using pgCart <a href="http://www.pgcart.com/" title="pgcart.com">http://www.pgcart.com/</a pgcart.com> (php + postgresql). It has a very nice administration interface. They are considering open sourcing it too!

#

PCI Data Security Standard

Posted by: Maxwell309 on June 05, 2005 09:43 AM
The only reason I might hesitate to use osCommerce is the <a href="http://www.visa.com/cisp" title="visa.com">Payment Card Industry Data Security Standard</a visa.com>. I don't know that ocCommerce has been developed in such a manner as to allow a merchant to deploy a PCI compliant ecommerce solution. Many proprietary payment applications have not been developed in a manner that allows PCI compliance.

#

Re:PCI Data Security Standard

Posted by: Anonymous Coward on June 06, 2005 04:53 AM
That is why you couple oscommerce/zencart with sites like 2checkout. Gets around that so called security standard.

#

Re:PCI Data Security Standard

Posted by: Maxwell309 on June 11, 2005 04:53 AM
If you don't mind paying 2Checkout's 5.5% plus $0.45 per item. Any web retailer of a significant size will benfit from the lower cost of a more traditional credit card processor. Discount rates 1/2 of 2Checkout's are common.

The only advantage of 2Checkout is that its simplicity and it sheilds you from the credit associations data security standards. Probably ok if you are new to e-commerce, you want to sell a few quilts for cats or the baskets you weave underwater, but if you have a large, established e-commerce operation you are better off seeking PCI compliant service providers and tools that will aid you in achieving PCI compliance.

Also, it is not a "so called security standard". The Payment Card Industry Data Security Standard is a requirement for anyone who processes, stores or transmits cardholder data (specifically the credit card number), see <a href="http://www.visa.com/cisp" title="visa.com">http://www.visa.com/cisp</a visa.com>. Merchants ignore it at the risk of significant financial loss.

#

This story has been archived. Comments can no longer be posted.



 
Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya