200,000+
item online catalog - Supermini Computer
Our Client Needed:
- 200,000+
line item catalog for IT customers.
- Upload
entire product catalogs from various vendors (incl. Cisco, HP, Sun, etc.)
into a single Oracle database.
- Automated
daily, weekly, and monthly uploads.
- Calculated
pricing formulas using vendor’s data during upload process.
- Catalog
pages must adhere to previously designed web site.
- Pages
should be dynamically created based upon customer’s search criteria.
Solution:
- Data
from vendors transferred automatically via FTP.
- Data
cleaned up, re-formatted, and uploaded into Oracle database.
- Online
catalog software uses templates to dynamically create pages using data from
SQLnet query to Oracle database.
- UNIX
servers, Netscape Enterprise HTTP Server, Oracle RDBMS behind secure firewall.
