1 / 70

V614 CeBS Catalog System

V614 CeBS Catalog System. Susan Lu Staff Software Engineer Vertical Application slu@sybase.com. Challenges in Managing and Presenting Products & Services. Typical environment Products and services are offered through multi-vendor and multi-network environment.

kane
Download Presentation

V614 CeBS Catalog System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. V614CeBS Catalog System • Susan Lu • Staff Software Engineer • Vertical Application • slu@sybase.com

  2. Challenges in Managing and Presenting Products & Services • Typical environment • Products and services are offered through multi-vendor and multi-network environment. • Multiple copies of catalogs: • Order system, provisioning system, billing system, etc. • Wireless services, DSL services, etc. • Residential services, small business services, etc.

  3. Challenges in Managing and Presenting Products & Services • Typical problems • Out of sync catalogs • Distinct systems handling different types of catalogs • Manual process to keep multiple copies of catalog in sync • Hard to provide a consistent presentation through out different catalogs

  4. Objectives • See how CeBS Catalog System could help to manage multi-vendor/multi-system products and services • Use CeBS Catalog System to provide a consistent presentation to all products and services • Understand overall design of CeBS Catalog System • Learn how to create and work with data in CeBS Catalog System database.

  5. Agenda • Catalog System Overview • Catalog Publisher • Basic Structures • Product Pricing Structure • Product Parameter Info • Catalog System UI • Multi-lingual Support • ETL

  6. Catalog System Overview • To allow telecommunication companies to easily publish their catalogs and provide their customers an environment to browse, search and therefore order products and services. • Front-end presentation to existing back office products and services • Provide an out-of-the-box catalog publisher implementation without regeneration of the templates. • Flexibility to incorporate customized logic

  7. Catalog System Overview • Products and services information are captured in CeBS catalog database. • Multiple catalogs can be consolidated and ETL (extract, transform and load) into CeBS catalog database • Products and services from different back office systems can co-exist in CeBS catalog system. • Integrated with CeBS order entry system • Products and services can be ordered and routed to corresponding back office system

  8. Catalog System Overview • Flexible products structure • Regular products & services • Bundled products & services • Promotion products & services • Up-sale and cross-sale

  9. Catalog System Overview • Based on CeBS framework including • Business Logic • Catalog System EJB - to retrieve product information from CeBS Catalog Database • UI Framework • Catalog System UI templates - to present information retrieved from Catalog System EJB • Slave mode only • Depend on back office to supply and update the actual catalog data

  10. Catalog System Overview Back Office Catalog 1 CeBS Catalog Back Office Catalog 2 Back Office Catalog 3

  11. Catalog System Overview CeBS Catalog Presentation Layer Static HTML/Images HTTP req HTTP resp Catalog JSP templates XML XML Catalog Publisher EJB Catalog

  12. Catalog Publisher • Provides catalog-publishing environment • Governs the overall look and feel of catalog • Implemented through • CatalogPublisher session EJB • Using CeBS BL framework • Stateless • Obtain data from Catalog Database • Read-only operations

  13. Catalog Publisher • A set of databeans • Obtain data from CatalogPublisher EJB • Retains data for presentation • A set of JSP templates • Accessing data from catalog databeans using tag library • Catalog Home page / Category page • Product page / Promotion page • etc.

  14. Catalog Publisher • Provide out-of-box implementation • Everything is ready to go after ETL • Dynamically publish the catalog content • Data changed in Catalog Database reflected directly without shutting down server

  15. Basic Structure - Category • Category • Logical grouping of products • Category JSP displays: name, description, child categories or products, and thumbnail • Description: short, long, html style • Features: for parametric search only (not displayed) • e.g. DSL, Frame Relay, Private Line • e.g. Residential Products, Small Business Products

  16. Basic Structure - Product • Product • Items can be purchased/add-to-cart • Product State (Marketable, Internal) • Product JSP displays: name, description, attributes, up-sale, cross-sale, and thumbnail • Description: short, long, html format • Attributes: name-value pairs • e.g. Basic DSL Internet Service, Domestic Private Line Service, Frame Relay Bundle Package

  17. Basic Structure – Bundled Product • Bundle Product • Consists of multiple products - products or bundles • Required product • Optional product • Union product list - one and only one selection from the list

  18. Basic Structure – Bundled Product • e.g. Frame Relay Package • Frame Relay Service (required) • Backup Frame Relay Service (optional) • Frame Relay DLCI (required) (might be internal product state) • Priority DLCI (union) • Standard DLCI (union)

  19. Basic Structure – Category Hierarchy • Category Hierarchy • Hierarchy tree structure • Consists of children categories or products • Root category: internal & required one where category hierarchy is built upon • Product navigation is done through Category Hierarchy • Orphan products/Categories will not be shown through category hierarchy navigation

  20. Long Distance Service Wireless Service Local Service Family Share Plan 250 Family Share Plan 1000 Nokia Phone 100 [R] Nokia Battery [O] Nokia Battery [O] Nokia Phone 200 [R] Residential Plans Business Plans Basic Structure – Category Hierarchy

  21. Basic Structure - Promotion • Promotion • Based on an existing product • Only promotion name, description, prices, part number can be different from the existing product. The rest of product info comes from the existing product which the promotion is based upon. • All information is optional. If it is defined explicitly, the info is obtained from the promotion instead of existing product.

  22. Basic Structure - Promotion • Can have multiple promotions based on the same product • e.g. Basic DSL Residential Service and Basic DSL Small Business Service all based on product Basic DSL Service. • e.g. Free Motorola Phone with National Wireless Plan

  23. Basic Structure – Up Sale Product • Up Sale Products • Products which a customer would most likely be interested based the a product he/she is browsing now. • All characteristics are same as product promotion • Tight to a base product

  24. Basic Structure – Up Sale Product • e.g. • Base product: Wireless phone; • Up-sale product: Headset for the wireless phone • e.g • Base product: Frame Relay Service • Up-sale product: Backup Frame Relay Service

  25. Basic Structure – Cross Sale Product • Cross Sale Products • Products that are not related to the product a customer is currently browsing but would like to the customer to consider. • All characteristics are same as product promotion • Tight to a base product

  26. Basic Structure – Cross Sale Product • e.g. • Base product: Wireless phone; • Cross-sale product: DSL Service • e.g • Base product: Frame Relay Service • Cross-sale product: Caller ID Service

  27. Basic Structure - Filter • Category & Product Filtering • Used to selectively filter out a set of categories/products if filter is defined • Based on User’s Organization Type • Default: MNC, SME, Reseller, Residential, Telco-self • Special customized organization types: GWD • For each category/product, a list of organization types allowed to view can be defined. • Non-logged in user is mapped to telco guest

  28. Basic Structure - Filter • e.g. Residential users only see Wireless and DSL categories. • e.g. Multi-national corporation users see DSL, Frame Relay, Private Lines and Wireless categories. • e.g. All users belong to Greenville Water District organization see GWD Frame Relay Package created for GWD only. • Future: filter based on address, NPA/NXX (area code/1st three digits of phone number), etc.

  29. Basic Structure - Keyword Search • Returns products found based on keyword specified in: • Product Specification: search on product name and short description • Part Number: search based on part number only

  30. Basic Structure - Keyword Search • Exact match but case in-sensitive. • Keyword: wireless • Result: GS3478 Wireless Phone, National Wireless Service • Not precise but guessing • Might yield no result; however, no guarantee the product in mind does not exist => guess wrong keyword

  31. Basic Structure - Parametric Search • Search based on individual item’s parameters and characteristics • Content is structured hierarchically. • Each category defines a set of features along with their possible values. • Child categories/products identify feature values accordingly.

  32. Basic Structure - Parametric Search • Displays classification tree-like structure along with features and values. • Users navigate based on the features and values selected. • Always yields result eliminates guesswork. • An advance search provided by many catalog vendors.

  33. Basic Structure - Parametric Search • Iterative search by refining search criteria through features and their associated values • Can easily restart the search by resetting search criteria • Useful when there are a large amount of products in a category

  34. Basic Structure - Parametric Search • Category: Wireless Service • Feature: Values • Anytime Minutes 250/400/500 • Night & Weekend Minutes 1000/2000/3000 • Call Waiting Free/Additional Charge • Long Distance Call Free/Additional Charge

  35. Basic Structure - Parametric Search • Products: • Standard WS • Anytime Minutes: 250 • Night & Weekend Minutes: 1000 • Call Waiting: Additional Monthly Fee • Long Distance Call: Additional Charge

  36. Basic Structure - Parametric Search • Local WS • Anytime Minutes: 400 • Night & Weekend Minutes: 2000 • Call Waiting: Free • Long Distance Call: Additional Charge

  37. Basic Structure - Parametric Search • National WS • Anytime Minutes: 500 • Night & Weekend Minutes: 3000 • Call Waiting: Free • Long Distance Call: Free

  38. Basic Structure - Parametric Search • Search criteria • Anytime Minutes: 500 => National WS • Night & Weekend Minutes: 2000 => Local WS • Call Waiting: Free => National & Local WS • Long Distance Call: Additional Charge => Standard & Local WS

  39. Product Pricing Structure • Provides flexible pricing structure to fulfill Telecommunication industry’s need • Numeric Price • Inline price description • Complex price description • Multiple pricing structures can be defined for a product. • CatalogPublisher EJB will obtain all pricing info defined • UI will display all pricing info returned

More Related