Data has always been a strong point of Titan CMS. We’ve helped clients from manufacturers to medical institutions manage data in a productive, user-focused formats that often involves Titan CMS data schemas.
Simple data schemas are quick and easy to build within Titan CMS, as explained on our documentation website. We can expand on the basics and create robust data relationships to meet the needs of clients who must manage large amounts of complex data. In the case of Server Products, we applied this capability to the creation of their next-generation manufacturing online product catalog.
Differentiating from Distributors
Server Products, of Richfield, Wis., is a leading manufacturer of food serving equipment with products crossing over several different lines. The company primarily sells through distributors and resellers, not directly from its own website. This situation can and did create confusion about the future role of the company’s website.
Server Products faced online competition from its own distributors. Users looked to the resellers and distributors’ sites to learn more about the company’s products. The manufacturer’s own site offered users no more information than their channel partners did, and a visitor could actually buy something from the resellers. So, what could Server Products’ website offer to site visitors that resellers and distributors couldn’t?
A Next-Generation Manufacturing Online Product Catalog
Server Products already had site content, such as how-to videos and help documents, that was unavailable to distributors. Visitors just couldn’t find this added value, which resided in a single section of the site. Users could get to it, but only by searching.
Today, Server Products’ dynamic product catalog houses all information about a given product within a single product detail page easily managed through Titan CMS. A user looking to learn more about a food warmer, for example, navigates to the product detail page about that warmer and can then click through the full specifications, FAQ documentation, how-to videos and more.
The company manages these customized product pages through Titan CMS data schemas. Content creators and managers upload each value into a spreadsheet, which Titan CMS interprets in order to create tables and other data listings on the site.
Let’s break down exactly how Titan CMS makes this happen.
Each product has a table with specifications, documentation, and trouble shooting. FAQs live under the trouble-shooting tab.
Each product FAQ is related to a product in the FAQ table using a Titan CMS lookup field to create a data relationship. In this case the “FAQ_Lookup_ID” was used.
Some of these product FAQs apply across several lines and multiple products, so the same FAQ content can be reused in several places on the site.
Each product has a table with detailed specification on the product detail page.
These specifications are managed through a schema relationship. The tables are generated from a spreadsheet using a Titan CMS external key, so large tables of data can be related and managed easily. Specifications are linked by a product number key in the uploaded spreadsheet.
If the product number in the spreadsheet matches the product lookup in Titan CMS, the data will display in the table.
Most products have variants that are tailored to specific industries or specific uses.
These are all managed through a lookup in Titan CMS, as well.
Imported spreadsheet data dictates which variants display under individual products.
Lookup Based Product Information
For other content listed on the product-detail page, such as certifications, plug types, serving applications, and warranties, information displays based on lookups.
This data is also uploaded in a spreadsheet into the Titan CMS workstation using Titans lookup import capabilities. Titan CMS will display the image associated with the lookup value.
Images are standardized, so they appear the same across every product on the site.
These data schema applications save huge amounts of time for data-heavy websites. They eliminate entering data product by product. Content managers can create one spreadsheet offline and then upload it to Titan CMS. Front-End developers need only create one table; Users managing their site never need to edit freeform tables or edit individual product data. They need only change the spreadsheet and let Titan CMS do the rest.
If you’re ready to create an elevated product catalog for your organization with Titan CMS, contact us. We can help.
Originally Published: Thu, October 26, 2017