UXB Dynamic Catalog

1
UXB Dynamic Catalog
2
The Dynamic Catalog

• Database driven
• Catalog Page information
• Upload Electronic Images
• SKU information Details
• Upload Electronic Documents
• PDF, Word, Exceletc
• User configurable
• Web Based maintenance tools

3
Database Structure - Overview

• Catalog database structure is comprised of
  several elements
• Category table user defined product categories
• Product series table catalog page information
• SKU table detailed SKU info i.E. SKU ,
  voltage, weight,
• Electronic document table PDF, word doc etc
• Linking Control tables

4
Database Structure - Overview

• Catalog database is comprised of several elements
• Menus/CategoriesUser defined web site navigation
• Products TableCatalog page information
• SKU Tabledetailed SKU info voltage, weight,
  SKU number
• Electronic documents tablePDF, Word, Excel,
  Images etc
• Linking and control tables

5
Database Structure Overview
6
Database Structure - Category

• Categories are user defined
• Are multi-branched tree structure
• Can have unique templates assigned to them

Category 1
Sub-Cat 1
Sub-Sub-Cat 1
Sub-Cat 2
7
Database Structure - Category
8
Database Structure - Category
Linking Table
Categories Table
Product Series Table
Category 1
Product 1
Product 2
Category 2
Category 3
Product 3
Product 4
Category 4
Product X
Category X
9
Database Structure - Category
Categories Table
Product Series Table
Linking Table
Product 1
Category 1
Product 2
Category 2
Category 3
Product 3
Product 4
Category 4
Product X
Category X
Assign One product to separate categories
10
Database Structure Products
Product Series Table
Linking Table
SKU Details Table
Product 1
SKU 1
Product 2
SKU 2
Product 3
SKU 3
Product 4
SKU 4
Product X
SKU X
Links two products to the same SKU
11
Database Structure Documents
Product Series Table
Linking Table
E-Document Table
Product 1
DOC 1
Product 2
DOC 2
Product 3
DOC 3
Product 4
DOC 4
Product X
DOC X
Link two products to the same document
12
Tying It All Together
Categories Table
Product Series Table
Linking Table
Linking Table
SKU Details Table
Product 1
Category 1
SKU 1
Product 2
Category 2
SKU 2
SKU 3
Product 3
Category 3
SKU 4
Category 4
Product 4
SKU X
Product X
Category X
Linking Table
E-Document Table
DOC 1
DOC 2
DOC 3
DOC 4
13
Tying It All Together - Example
Categories Table
Product Series Table
Linking Table
Linking Table
SKU Details Table
HLX Series
Explosion Proof
SKU X
Product 2
Category 2
SKU 2
HLX1WEG
XBP Series
Fluorescent
UFO-2E
Category 4
LAMPAK II
XPB-75P
Product X
Category X

• Explosion Proof Fluorescent share the same
  product (HLX)
• Two products share same SKU (SKUX)
• Three products share same document (rating chart)

Linking Table
E-Document Table
Ratings Chart
HLX Series PDF
LAMPAK II PDF
XPB Series PDF
14
Summary

• All product information is in one place
• All SKU information is in one place
• All E-Documents are in a central index
• Products can be organized by type, application,
  cost etc
• Site wide changes are automatic
• Search can be contextual and targeted by data
• Manage the information using a web browser

15
Shopping Cart Option

• This design application can integrate a shopping
  cart function.
• In the initial SKU table design you will need to
  determine pricing and shipping options for each
  SKU
• List price or trade?
• Tax tables which states?
• Shipping handling?
• Shipping methods?

16
Product Selector Option

• Product Selector / Search functionality
• Specification data can be integrated into the
  product or SKU tables
• Separate templates or single template can be
  created for differing products
• Management of the Product Selector tool becomes
  integrated into the site.

17
Multi-Lingual Web Site Option

• We expand the basic data structure to include
  fields for each language
• User decides which language when entering the
  site
• Questions
• Will navigation be the same for all languages?
• How many languages? Fixed or expandable?
• Separate templates for each language?

18
Administration Tools

• Web Browser based tools allow you to
• Create, edit delete product information
• Upload product images The server will resize
  and make thumbnails
• Upload E-Documents (.pdf, .doc, .zip etc)
• Associate products to categories, documents SKU
  items
• Manage all aspects of the catalog

19
Administration Tools
Create or Edit menus and assign templates
Sort menus and product visually
20
Administration Tools
Create or Edit product information
Upload product images with the web browser
21
Administration Tools
Associate Products to Electronic Documents
Associate Products to Categories
22
Administration Tools
Add or Edit SKU information
Upload and categorize Electronic Documents and
files
23
HTML Design Considerations

• Graphic design
• Utilize existing marketing themes
• Standardize on page design
• Copies of existing product graphics
• Electronic Documents
• Copies of PDF files
• One PDF per product
• PDF files for each section
• Other Files
• What format? (.wav, .AU, Real Player, .doc .xls)

24
Company Profiles

• Companies using the product Catalog

• Edwards Signaling
• www.edwards-signals.com
• The Signal Source
• www.thesignalsource.com
• Dual-Lite
• www.dual-lite.com
• Prescolite Life Safety Products
• www.prescolite-lsp.com

• Prostrong
• www.prostrong.com
• Manchester Honda
• www.manhonda.com/store/
• Regenatec
• www.regenatec.com
• MG Publishing
• www.mgpublishing.com

25
Summary

• Database driven web site
• Uses structured data
• Can make decisions based on user input
• Can be managed using a web browser
• Do not need to know HTML
• Bolt-in applications
• Expands the product catalog and web site
  functionality
• No need to redesign entire web site to add most
  new applications
• All Managed using a web browser
• Design considerations
• How much detail defines data structure
• Trade offs between amount of data and managing it
• Trade offs between static and dynamic template
  designs