|
Industry: HVAC/R The CustomerOne of the largest wholesale distributor of HVAC/R equipments in the country. The customer stocks and sells over 25,000 products and parts, and has a 1100-page catalog which is used as the main marketing tool for the company. The ChallengeThe customer’s catalog was previously built in-house over several years using QuarkXpress software. In order to publish a new catalog every year, the customer had to go through an elaborate and time consuming task of updating and adding new products to the catalog, remove the products that were discontinued, and also update the latest price and description in the static Quark pages. This process was highly time consuming and labor intensive. The customer also maintained pricing information for all the products in an AS400 system but did not have other information about the products in the database. As the business was growing fast and more companies were acquired, the customer realized that it was becoming impossible for its staff to keep track of all the information in the static Quark pages and that it will take at least 6 months to get its primary catalog published. The customer also wanted to take its product information online through its website to its customers with the ability to order products online. The customer realized that they were in need of a central database to store all the product information. The customer also needed tools to get the data published to print and online media quickly and effectively, and also to publish print catalogs every year with minimal effort. The SolutionTradingBell proposed its CatalogStudio solution for publishing print, web and CD catalogs. It was easy to get the product SKU and pricing information from the AS 400 system, but the information from Quark could not be imported directly into the TradingBell database. In order to solve this problem, TradingBell with its robust set of tools and vast experience, extracted, converted, cleaned, normalized and stored the data in TradingBell database from the 1100 Quark pages and linked thousands of image assets to the products within 60 days. The ResultThe customer, with all the important asset information now captured and stored in a Microsoft SQL server database, is now able to use the CatalogStudio & InCat software for managing product content and publish its catalogs quickly. Every year the customer publishes its primary catalog and also publishes several small market specific target catalogs and custom catalogs designed specifically for some individual customers. With the use of TradingBell’s software, the customer has achieved the goal of managing its product assets in a central repository database and make quick and last minute changes to the product information before the catalog is published. Customer is also using the same database and information for its online catalog where customers have the the ability to order directly. |