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, Excel…etc • User configurable • Web Based maintenance tools

3. 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

4. Categories Table Product Series Table SKU Details Table E-Document Table Database Structure Overview

5. Categories are user defined Are multi-branched tree structure Can have unique templates assigned to them Database Structure - Category Category 1 Sub-Cat 1 Sub-Sub-Cat 1 Sub-Cat 2

6. Categories Table Linking Table Product Series Table Category 1 Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod Product 1 Category 2 Product 2 Category 3 Product 3 Category 4 Product 4 Category X Product X Database Structure - Category

7. Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod 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

8. Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod 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 Assign One product to separate categories

9. Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod 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

10. Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod 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

11. Prod Cat Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod Cat Cat Cat Cat Prod Prod Prod Cat Cat Prod Prod Prod Prod Cat Cat Cat Cat Prod Prod Prod Prod Cat Tying It All Together Categories Table Linking Table Product Series 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 Product 4 Category 4 SKU X Product X Category X Linking Table E-Document Table DOC 1 DOC 2 DOC 3 DOC 4

12. Prod Cat Cat Cat Cat Cat Cat Cat Prod Prod Prod Prod Prod Prod Cat Cat Cat Cat Prod Prod Prod Cat Cat Prod Prod Prod Prod Cat Cat Cat Cat Prod Prod Prod Prod Cat 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 Linking Table Product Series Table Linking Table SKU Details Table HLX Series Explosion Proof SKU X Product 2 Category 2 SKU 2 HLX1WEG XBP Series Fluorescent UFO-2E LAMPAK II Category 4 XPB-75P Product X Category X Linking Table E-Document Table Ratings Chart HLX Series PDF LAMPAK II PDF XPB Series PDF

13. 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

14. 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?

15. 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.

16. 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?

17. 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

18. Administration Tools Create or Edit menus and assign templates Sort menus and product visually

19. Administration Tools Create or Edit product information Upload product images with the web browser

20. Administration Tools Associate Products to Electronic Documents Associate Products to Categories

21. Administration Tools Add or Edit SKU information Upload and categorize Electronic Documents and files

22. 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)

23. 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 Company Profiles Companies using the product Catalog:

24. 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