If you want to create your own Amazon.com, then you should try iCat's Electronic Commerce Suite 3.0 Professional Edition. iCat started developing e-commerce software in 1993, when Amazon.com was just an idea in Jeff Bezo's brain.

However, the Electronic Commerce Suite Professional Edition is not for a small Web site because you will need to shell out $9,995. But, if you have a company with lots of products, then the Commerce Suite will have all the features you need. If you go to the www.icat.com Web site, you can see several demos of iCat catalogs, including an online book store. Actual customer catalogs are also shown there. For those with less sophisticated Web catalog needs, iCat offers a Standard Edition for $3,495

The Commerce Suite requires experience with a scripting language called Carbo (iCat's proprietary language, which is similar to SQL). The language is not rocket science, but you will still need to spend time getting used to it (the Carbo reference manual is 300 pages). The Carbo code editor has a wizard and syntax checking, but it is definitely not a full-fledged development environment.

You will also need to understand SQL and database administration. In other words, the typical on-line proprietor will probably need to hire a programmer. In fact, the iCat Web site has a list of ISPs that develop and host iCat catalogs for businesses.

The Commerce Suite requires 60 MB of free hard drive space and 16 MB of RAM. The software supports Win95, Win NT and even the Power Mac.

The Commerce Suite uses the popular shopping-cart motif. That is, if the user likes the product, he will click it and the item will be listed on the shopping-cart page. When the user is finished, he will click an icon to verify the order and then receive an e-mail confirmation.

Actually, the Commerce Suite is not used just for on-line store fronts. Rather, you can use this software for corporate Intranets. This is what Boeing did as it created a catalog for its company training programs - giving detailed information on courses, instructors and schedules, as well as allowing employees to register for courses and download course materials.

To create your on-line catalogs, you will use the iCat Commerce Publisher, which is where you will do most of your work. You will not use a proprietary interface; instead, the Publisher runs from your browser. Thus, you can develop a catalog with programmers who are located in different locations.

To run your catalogs, you will need a Web server. iCat supports servers from Microsoft, Netscape, O'Reilly and Quarterdeck, as well as many flavors of UNIX. Also, iCat has provided its own server. But, if you want to use the iCat Data Entry Manager (explained below), then you will need to install the iCat Web Server. (In other words, you should install this server.)

With Publisher, you will hook your catalogs to two databases: 1. Staging Database: Used to create and manage the test database. In most cases, you will use the Data Entry Manager to create the staging database. The staging database has the following pre-defined fields for each data item: Company, Item Name, Identifier (SKU or ID#), Abstract (description) and Main Price. You can then create your own custom fields for both text and numerical data.
2. Live Database: Taking the staging database and publishing it "live" on the Web. It is from this data that iCat will dynamically create catalog pages for users, as well as store order and tracking information. iCat provides a Sybase SQL Anywhere ODBC database to accomplish this.

This two-tiered structure makes sense - you may want to make modifications to your database without having it posted to the Web. However, if you are not careful you might run into problems. That is, if you post to the two databases simultaneously and do not keep track of the changes, this can lead to chaos. Thankfully, the iCat manual has procedures to keep your databases in sync.

As the name implies, the Data Entry Manager allows you to enter, import and update the data items that will appear in your catalog. But, if you want to import anything other than the Sybase Anywhere ODBC database, you will need to map the schema of your database to match the Commerce Suite.

You can organize your data items into four levels: sections, subsections, categories and subcategories. If you have a large database, it would behoove you to divide your catalog into some understandable hierarchy; if not, you will likely have a nightmare.

You can even place promotional information in the database:

Tax methods: You can specify sales tax methods by zip code or state. The Commerce Suite has a trial version of TaxWare, which is used to calculate sales taxes.

The Commerce Suite has a variety of tools that allow you to analyze traffic statistics. Using the Sales Manager module, you can look at reports on orders, customers and item tracking (which shows the number of hits and the percentage of time the user spent viewing each item).

The manuals are well written. Included is a sample catalog, which makes for an excellent tutorial.

This is a really exciting product. There are many templates. The Publisher uses the familiar browser interface. You can hook to many online payment systems. The list goes on and on. I wish I had my own bookstore, so I could utilize the power of this software.

Published Oct. 1, 1997— Reads 9,548
Copyright © 1997 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.

About Tom Taulli
Tom Taulli is the CEO of Blueprint Interactive (www.bpia.com), which develops Internet applications for the enterprise.