uxb dynamic catalog. the dynamic catalog database driven catalog page information upload electronic...

UXB Dynamic CatalogUXB Dynamic Catalog

The Dynamic Catalog Database driven Catalog Page information Upload Electronic Images SKU information & Details Upload Electronic Documents

PDF, Word, Excel…etc

User configurable Web Based maintenance tools

Database Structure - Overview Catalog database is comprised of

several elements Menus/Categories

User defined web site navigation Products Table

Catalog page information SKU Table

detailed SKU info – voltage, weight, SKU number Electronic documents table

PDF, Word, Excel, Images …etc Linking and control tables

Database Structure Overview

SKU Details Table

E-Document Table

Product Series Table

Categories Table

Sub-Cat 1

Category 1

Sub-Sub-Cat 1

Sub-Cat 2

Database Structure - Category

Categories are user defined

Are multi-branched tree structure

Can have unique templates assigned to them

Database Structure - Category

Categories Table

Category 1

Category 2

Category 3

Category 4

Category X

Product Series Table

Product 1

Product 2

Product 3

Product X

Product 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Database Structure - Category

Categories Table

Category 1

Category 2

Category 3

Category 4

Category X

Product Series Table

Product 1

Product 2

Product 3

Product X

Product 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Product 1

Database Structure - Category

Categories Table

Category 1

Category 2

Category 3

Category 4

Category X

Product Series Table

Product 2

Product 3

Product X

Product 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Assign One product to separate categories

Database Structure – Products

SKU Details TableProduct Series Table

Product 1

Product 2

Product 3

Product X

Product 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

SKU 1

SKU 2

SKU 3

SKU X

SKU 4

Links two products to the same SKU

Database Structure – Documents

Product Series Table

Product 1

Product 2

Product 3

Product X

Product 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

DOC 1

DOC 2

DOC 3

DOC X

DOC 4

E-Document Table

Link two products to the same document

DOC 1

SKU 1Product 1

Tying It All Together

Categories Table

Category 1

Category 2

Category 3

Category 4

Category X

Product Series Table

Product 2

Product 3

Product X

Product 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

SKU Details TableLinking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

SKU 2

SKU 3

SKU X

SKU 4

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

DOC 2

DOC 4

DOC 3

E-Document Table

Ratings Chart

SKU XHLX Series

Tying It All Together - Example

Explosion Proof & Fluorescent share the same product (HLX)

Two products share same SKU (SKUX)

Three products share same document (rating chart)

Categories Table

Explosion Proof

Category 2

Fluorescent

Category 4

Category X

Product Series Table

Product 2

XBP Series

Product X

LAMPAK II

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

SKU Details TableLinking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

SKU 2

HLX1WEG

XPB-75P

UFO-2E

Linking Table

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

Cat Prod

HLX Series PDF

XPB Series PDF

LAMPAK II PDF

E-Document Table

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

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?

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.

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?

Administration ToolsWeb 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

Administration ToolsCreate or Edit menus and assign templates

Sort menus and product visually

Administration ToolsCreate or Edit product information

Upload product images with the web browser

Administration Tools

Associate Products to Electronic Documents

Associate Products to Categories

Administration ToolsAdd or Edit SKU information

Upload and categorize Electronic Documents and

files

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)

Company Profiles

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

Companies using the product Catalog:

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