Abstract:
A Supplier Portal is provided to allow a Supplier to self-author the business process elements (BPEs) of a business process (BP) to create, manage and publish rich-content for use in eCatalogs, Data Pools, Enterprise Resource Planning (ERP) systems, and other knowledge management situations. The resulting business process (BP) for content management incorporates the Supplier&#39;s business process (BP) model. At the business process (BP) level, self-authoring allows users to adapt business process elements (BPEs) such as workflows, approval rules and approver roles and permissions, event notification and metrics. At the activity level, self-authoring allows users to adapt business process elements (BPEs) such as user interaction templates, business process (BP) rules and user roles and permissions that relate to the input, configuration, rationalization, classification, value extraction, quality control, publication, and ongoing management of rich-content. The resulting published rich-content incorporates a supplier&#39;s unique way of doing business while adhering to the quality, integrity and consistency imposed by the Supplier Portal to achieve a seamless published rich-content such as an ecatalog. The Supplier Portal can be any and all of a hosted behind a firewall solution, accessible via a browser on at least one of a Personal Computer, hand held, or wireless/wired networked communication or standalone device.

Description:
CROSS REFERENCE TO RELATED APPLICATION  
       [0001]     This is a non-provisional application claiming the benefit of U.S. provisional application number U.S. No. 60/567,780 filed on May 5, 2004, the entire disclosure of which is hereby incorporated by reference. 
     
    
     BACKGROUND OF THE INVENTION  
       [0002]     1. Field of the Invention  
         [0003]     The present invention relates to a system and method for a supplier to self-author the catalog management steps of providing, cleaning, classifying, value extracting, quality controlling, and publishing catalog information describing products/items available from the supplier. More particularly, the present invention relates to a system and method for a Supplier Portal that is internet or network-accessible for a supplier to self-author the management of catalog information describing products/items available from the supplier.  
         [0004]     2. Description of the Related Art  
         [0005]     With the advent of eCommerce, adopters of this technology have been challenged to receive the promised ROI. Industry experts point directly to the failure of Suppliers and buyers not having a media process that will allow the parties to communicate via electronic data transfers all the requirements for a full life cycle of eCommerce Transactions. A Secondary Symptom to this is the failure of the parties to build a common language where product information can be transferred in a manner which will meets all of the business requirements of both parties.  
         [0006]     Failures in eCommerce initiatives to date are directly related to the Cost of technology and the lack of communication protocols presented in a manner that buyers and sellers can relate to.  
         [0007]     To address this need the parties must have a platform that will communicate the business requirements and encompass all the required business needs of all parties involved in the eCommerce transactions. A review of the business processes that require an interaction in eCommerce identifies the data elements that must fulfill the needs of the business processes that manage and control these transactions during a complete life cycle. An example some of these business processes, and potential Data Elements that can support them, include:  
         [0008]     Shoppers: a review of the habits of people buying on the Internet shows that buyers need a certain level of product information to have confidence that what they are ordering will fit their needs. To inform the buyer the product information must present the data elements that will differentiate the product from other similar products, as an example: Electrical Tape, can be found in varying lengths and widths, but to meet industry standards different colors are also required for different applications where Black, Yellow and Red may address issues related to Safety, Process identifiers etc. A buyer looking within a catalog may find this tape, but without a unique characteristic of color the buyer would not be able to select the Tape they need.  
         [0009]     Commodity Managers: These individuals within an organization are responsible for selecting supply sources, contracting with suppliers and verifying compliance. The data elements that support their business process are related to transaction information such as price, Quantities per price, Units of Measure, Delivery Dates, Commodity Coding—all Common data elements that allow comparisons for the same items from different sources.  
         [0010]     Accounting: This process may require unique identifiers such as the Duns number for the Source of the Product, the Contracted Price, a commodity or unique code to charge the transaction to a budget.  
         [0011]     To support true eCommerce and streamline the Procure to pay process there are business requirements place on Catalog data that is multi-Faceted. The process of collaborating with Supply sources must include the capability to express the requirements, to allow the requirements to be fulfilled and to communicate to submitters of product information whether those requirements are met or whether the information may need further input.  
         [0012]     Gathering and transmitting these data elements can be a time consuming and costly task. To date supply sources have not met these requirements in general based on lack of technology that will lower the burden and lower the technical requirements on the supply community.  
         [0013]     The Supplier Portal is designed to address these issues. This technology process provides a streamlined process on a simple technology platform that will allow suppliers to Create and manage their product information meeting all of the business objectives that Suppliers and buying organizations share, in a real-time collaborative web based environment.  
         [0014]     Catalog creation and management are critical first steps in the Supply Chain Management process. Catalog creation involves the conversion of unstructured product/item data into structured information that is easily searched, compared, and selected for the purpose of ordering a product/item. Catalog management involves the ongoing data entry, updates, deletes, and modifications necessary to keep the catalog information complete, accurate and timely throughout the lifecycle of the products being presented for sale or other uses.  
         [0015]     Many catalog management applications require a catalog information supplier team to continuously provide fresh data to a centralized administration team that is responsible for updating the catalog. The team members can be a part of the supplier&#39;s organization, or they can be members of an external group that is providing an outsourced service. If the team has to service multiple suppliers, delays in the catalog updating process can occur due to competing tasks and priorities, and information quality can suffer.  
         [0016]     Since a supplier&#39;s economic success depends in part upon an ability to get the latest product information to potential buyers on a timely basis, it is essential that there be no delays or errors in the catalog management process, and that the resulting catalog information be up-to-date, complete and accurate. To maximize control of the presentation of up-to-date, complete and accurate catalog information to customers, suppliers need direct and timely access to their catalog information as well as user friendly tools that allow them to add, find, modify, quality control and delete their product information.  
         [0017]     The term tool refers to the tools of the knowledge worker, and includes templates, rules engines, workflow processes, forms, pick lists, and other devices that provide suggested structures or processes that make it easier for the supplier to carry out content and catalog management processes.  
         [0018]     To compete in today&#39;s fast changing competitive environment, a supplier needs greater speed, flexibility, functionality and self-authoring control than is provide by current catalog management applications.  
         [0019]     Suppliers need tools that work for both Buy-Side and Sell-Side Product information. They need to manage product item data coming from their suppliers, as well as that being sent to their customers. Many applications in the field only work with either buy or sell side processes, but not both.  
         [0020]     Suppliers need tools that facilitate the quick and easy online submittal of Images and Attachments (technical documents like product specifications, warranty agreements, wiring diagrams, Material Safety Data Sheets (MSDS) etc.) that are essential to providing catalog viewers with a “picture” of the items they are considering for purchase. Other applications in the field either do not facilitate online image management, or do so in a manner that is not quick and easy for a supplier not experienced with the process of managing images or attachments.  
         [0021]     Suppliers need tools to help them classify product data items, and extract meaningful values for the product attributes. Many applications in the field require the supplier to have the skills to perform these tasks manually.  
         [0022]     Suppliers need tools to help them determine what customers can view which catalog information.  
         [0023]     Suppliers need tools that allow users with different roles and tasks to work on the same system at the same time, and even on the same task.  
         [0024]     Supplier personnel need to be notified when an assigned task becomes available for completion. The Supplier Portal notifies task owners when an assigned task is available for work. This leads to improved process efficiencies by minimizing process delays.  
         [0025]     Suppliers frequently choose to utilize material experts to help with aspects of catalog item classification and attribute value extraction.  
         [0026]     Different aspects of catalog management require different types of approvals and suppliers need to be able to self-author user configurations, access rights and authorization.  
         [0027]     Suppliers need to present their catalog items in different ways to different customers to meet marketplace requirements. Standards bodies like UCCnet are setting the standards by which product item data is structured, formatted, and defined.  
         [0028]     Suppliers do not always know how potential customers want or need the product item data structured or defined.  
         [0029]     Suppliers need to be able to have a shopping-like platform where they can simulate what their potential buyers will experience while shopping for their products.  
         [0030]     Suppliers need catalogs of product item data that is easily searchable by untrained customers. Items that are not easily searchable are items that are not likely to be bought.  
         [0031]     Suppliers need to quickly and easily publish rich-content product item data to multiple third party procurement applications.  
         [0032]     Suppliers need extensive reporting capabilities to monitor the efficiency and effectiveness of their catalog management processes.  
       SUMMARY OF THE INVENTION  
       [0033]     Thus, there is a need for a web-based supplier support facility/portal that allows suppliers to collaborate with a publisher in the capture of product/item data for the creation and maintenance of an eCatalog. This ability to “self author” provides a significant competitive advantage over suppliers who do not have this capability.  
         [0034]     The present invention provides suppliers with a supplier portal comprising a system and method for an ecatalog Supplier Portal comprising tools and direct access they need to “self author” their catalog information throughout the production lifecycle for “rich content” data items. Rich content is defined as content that has the following characteristics: 
        It is structured—similar items are grouped in the same classification schema location and the same type of information is in the same place for each item;     It is normalized—the same information is consistent across all data items—i.e., a manufacturer&#39;s name is spelled the same way wherever it appears;     It includes intuitive descriptive information—each item is described with information that is written in terms that are commonly understood by the people using the information;     It is accurate when compared to the source information supplied by the manufacturer;     The product data items are defined in terms of attributes that help users compare and differentiate the items for purposes such as purchasing the items—the attributes can include technical specs, size, color, price, units of measure, commodity codes, model, manufacturer name, and many more that fit the user&#39;s business needs;     The items are fully searchable on all characteristics by different user types;     The items are parametrically searchable by attribute values;     The item information includes images, pictures, drawings and other attachments like MSDS, warranties, etc; and     Each item is defined to the point that it can be assigned to at least one commodity class.        
 
         [0044]     The system and method for a Supplier Portal according to the present invention allows suppliers to leverage immediate access to their product information or a typical e-catalog system, with just a standard web browser. Security rules of the present invention can limit supplier access to just the product information that pertains to their business.  
         [0045]     The tools required by a supplier to produce rich content online catalogs are available through the Supplier Portal of the system and method of the present invention. When suppliers either navigate through the catalog view or search the system repository, the self-authoring functionality of the Supplier Portal allows them to easily edit, add, or delete products or product information. Alternatively, a batch load process can be used to perform complete file submissions. In a preferred embodiment, once the supplier “submits” its data for quality assurance, the person designated by the supplier to review the data quality, i.e., a Catalog Administrator, receives an email notification that catalogs or changes are awaiting their approval.  
         [0046]     A preferred embodiment of the present invention includes:  
         [0047]     1. Electronic Catalog Content Creation: Effective catalog content management allows an organization to import and create rich electronic catalog content. This includes the ability to offer detailed product text and images to an organization and its users. Also included are tools for quickly loading large quantities of catalog content into a central database or repository. The Supplier Portal of the present invention allows an organization to load and convert free-form, unstructured text descriptions into rich, organized catalog content searchable by keyword, attribute, or hierarchical structure. Catalog content may be entered manually or by importing catalog content from a formatted file obtained from an organization&#39;s supplier.  
         [0048]     2. Catalog Content Organization: Organization of catalog content makes it feasible to quickly manage large quantities of catalog content on an ongoing basis, including enabling an hierarchical structure for grouping products. This includes creating different product views or assortments by user group. Importantly, this also includes the capability to preview product information before publishing it. The Supplier Portal allows an organization to create a hierarchical structure for grouping products consisting of product categories and subcategories configured to an organization&#39;s specifications.  
         [0049]     The self-authoring functionality of the Supplier Portal allows an organization to create different product views of its catalog content, e.g., product views by commodity, by assigning shopper groups (user groups) to users. The Supplier Portal provides pattern recognition technology based on a comprehensive knowledge base of pre-defined pattern recognition rules, enabling an organization to quickly organize and categorize large quantities of catalog content, streamlining its electronic catalog content organization process and increasing productivity.  
         [0050]     3. Catalog Content Delivery: Delivery of effective catalog content separates content data from layout and allows non-technical, business users to publish catalog content without the involvement of a third-party provider&#39;s technical staff. The Supplier Portal provides a comprehensive online supplier catalog, facilitating the self-authoring publication by an organization of its catalog content. The online supplier catalog allows users to search for a product by entering a keyword(s) or by using the available product categories and subcategories of the catalog.  
         [0051]     4. Supplier Enablement: supplier enablement allows suppliers to participate with an organization in an organization&#39;s catalog content lifecycle. The Supplier Portal is a web-based application that provides a supplier a wide range of functions associated with self-authored management of the supplier&#39;s catalog content for its buying organizations. As a web-based, hosted application, in a preferred embodiment, the supplier component of the application requires only a standard browser and access to the Internet.  
         [0052]     5. Workflow Management: Catalog content management allows an organization to implement catalog content approval workflows according to an organization&#39;s internal catalog content approval process. The Supplier Portal of the present invention provides a comprehensive Approval Management function that allows an organization to self-author and implement business rules within the Supplier Portal to correspond to the organization&#39;s internal catalog content approval process.  
         [0053]     6. One-Click Web Interface: The web-based interface of the Supplier Portal of the present invention provides one-click access points to the different functional areas in the application.  
         [0054]     7. Comprehensive Reporting: The Reports module of the present invention allows decision-making based on the catalog content information stored in the Supplier Portal catalogs. This module provides access to a range of catalog content reports, from a set of standard reports to customized reports that can be created for an organization. The parameterized aspect of the reporting tool allows the supplier to self-author the customized report outputs needed to assess the efficiency and effectiveness of their catalog management process. The module allows users to print reports, view reports as a display screen, or export report data to a file for use with external applications.  
         [0055]     8. Integration: The Supplier Portal can be integrated/interfaced with other eProcurement or ERP systems, or existing business-to-business solutions or legacy systems.  
         [0056]     This combination of direct and timely access, and supplier-friendly tools, allows the supplier to “self author” their content management process. By eliminating the need for catalog management specialists or services, the Supplier Portal allows a supplier to act rapidly, and efficiently to get the right product item information to the right buying audience at the right time. This self-authoring capability allows a supplier to streamline the catalog management process, eliminate the cost of intermediate services, reduce time delays, control the output quality, build internal expertise and achieve a competitive advantage.  
         [0057]     In a preferred embodiment, the Supplier Portal of the present invention support supplier activities by providing functions required to maintain the flow of content between suppliers and a Web Catalog, or between suppliers and other data uses/users, on an ongoing basis. The functions of the Supplier Portal support self-authoring by owners and suppliers or the provisioning of authoring services by a third party and include: 
        Signing-up new suppliers;     Managing relationships with suppliers to facilitate the flow of information;     Managing day-to-day activities and communications between owners, suppliers and customers relative to rich content;     Establishing a schedule with owners and suppliers to ensure delivery of their updated content on a regular basis, consistent with predefined timelines;     Tracking customer, owner and supplier content inputs to ensure changes to content are reflected in all catalogs (Staging, and Production Catalogs);     Instructing owners and suppliers on self-authoring requirements;     Maintaining data integrity among multiple parties;     Providing User-defined multiple levels of security and authorizations which reflect the terms and conditions of underlying business contracts     Enforcing compliance with business contracts terms and conditions, and agreed-to business processes among multiple parties;     Reducing the cost of transactions between parties     Improving the return on existing related data processing applications     Facilitating rich catalog maintenance which improves searchability and usability of procurement and sell-side applications; and     Providing On-going web-based training.        
 
         [0071]     As an example only, a business process that a supplier can establish using the Supplier Portal of the present invention may include the steps of: 
        Training Com Mgrs./Plant personnel/buyers on the Supplier Portal Content Management Solution;     Making initial contact by Com Mgrs./Plant Personnel with suppliers;     A Supplier loading a catalog into the Supplier Portal;     Automatically mapping and transforming the content into predefined category schemas with identification of additional content requirements;     Suppliers making enhancements and resubmits;     Notifying Catalog Administrators of the availability of new content, via email with a link to the Supplier Portal;     Administrators reviewing, analyzing, adjusting the new content in the catalog; and     Administrators performing: 
            a. Approval of the new content in the catalog;     b. Approval of the new content in the Catalog and requesting further enhancement of the new content; and     c. Denial of approval of the new content in the catalog and requesting required enhancements of the rejected new content.   
               
 
     
    
     BRIEF DESCRIPTION OF THE DRAWINGS  
       [0083]      FIG. 1  illustrates a Supplier Portal Process Overview Diagram;  
         [0084]      FIG. 2  illustrates Supplier Registration Profile;  
         [0085]      FIG. 3  illustrates an Upload Data File Page;  
         [0086]      FIG. 4  illustrates a Process Data Page;  
         [0087]      FIG. 5  illustrates a Product Record Page;  
         [0088]      FIG. 6  illustrates an Edit/change/modify Items Page Search Results;  
         [0089]      FIG. 7  illustrates an Edit/change/modify Items Page;  
         [0090]      FIG. 8  illustrates an Edit Product Record Page;  
         [0091]      FIG. 9  illustrates an Item History Page;  
         [0092]      FIG. 10  illustrates an Approval Review Page;  
         [0093]      FIG. 11  illustrates a Category Selection Page;  
         [0094]      FIG. 12  illustrates a Keyword Search Results Page;  
         [0095]      FIG. 13  illustrates a Product List Page;  
         [0096]      FIG. 14  illustrates a Product List Page—Common Features;  
         [0097]      FIG. 15  illustrates a Product Information Page;  
         [0098]      FIG. 16  illustrates a Short Description Setup Page;  
         [0099]      FIG. 17  illustrates a Reports Page;  
         [0100]      FIG. 18  illustrates a Database Schema;  
         [0101]      FIG. 19  illustrates a Database Schema for updates to products;  
         [0102]      FIG. 20  illustrates a Network Diagram for a Supplier Portal implementation;  
         [0103]      FIG. 21  illustrates the relationship between the supplier portal business process (BP) comprising business process elements (BPEs) and a typical supplier&#39;s e-procurement process;  
         [0104]      FIG. 22  illustrates a template used to configure a business process element (BPE); and  
         [0105]      FIG. 23  illustrates tables in a relational database used to store data related to a business process element (BPE). 
     
    
     DETAILED DESCRIPTION OF THE INVENTION  
       [0106]     The system and method of the present invention provide a Supplier Portal for a supplier to self-author processes for product/item management and catalog management.  
         [0000]     Supplier Portal Process Flow—Self Authoring Options  
         [0107]      FIG. 1  outlines a Supplier Portal Process Flow and the underlying Data Flow Process, and highlights a Self-Authoring Option available to the users/suppliers that can be chosen to instantiate their preferred business method(s). While  FIG. 1  suggests a preferred process a supplier does not have to follow this preferred process, this is an example process only, presented for discussion purposes and not for limitation. The system and method of the present invention provides a supplier a selection of functions to “self author” a process to fit a supplier business model; steps can be omitted, the sequence of steps can be altered, and different sets of data can be subjected to different processes to meet different objectives.  
         [0108]     The self-authoring process begins with the supplier&#39;s Purpose  100 . The purpose(s) can include one or more of the following: 
        to produce an internal catalog;     to produce catalogs for customers;     to output data to a data pool for subsequent use;     to produce structured data that distributors can use to further promote the supplier&#39;s products;     to produce output for ERP systems; and     to produce content for some other knowledge management use.        
 
         [0115]     In this example, the supplier has specified objectives for the process that include: 
        increasing the quantity of items processed;     increasing the quality of the data processed;     decreasing the time it takes to process quality data;     decreasing the total costs of producing quality data; and     increasing the usefulness of the output to the recipient.        
 
         [0121]     In the Input step  105 , the supplier chooses from the various types of input the supplier can import, including: 
        single or multiple sources of data;     data that is in raw or structured formats;     data that is in hard or soft copy; and     electronic data that is in different formats such as comma separated variables (CSV), extensible markup language (XML), electronic data interchange (EDI), and excel.        
 
         [0126]     In the Configure step  110  the supplier determines: 
        who is to have what type of access and authorization rights throughout the process being defined;     what user groups are created, who to assign to each group, and what permissions to grant to each group;     what the approval steps are in the process, who is given approval authority, and what level of authority is given; and     what roles internal personnel have, and what roles external personal (i.e., material experts, consultants, etc) have.        
 
         [0131]     The Rationalize step  115  illustrates the actions the supplier can self-author to make unclean data more structured and consistent—and thus quicker, easier and more effective to process, including: 
        converting hard copy data to an electronic format;     moving data from improper fields to improve data organization;     correcting misspelling to improve data consistency;     modifying data to meet standards—such as required abbreviations;     removing duplicate data; and     tagging items to facilitate their proper classification.        
 
         [0138]     The Classify step  120  highlights the self-authoring options available to the supplier to place the incoming data items into the proper place in the classification tree: 
        selecting either the automatic or the manual mode of classification, or both for selected subsets of items;     deciding when to use existing patterns, and when to create new ones to facilitate the classification; and     deciding whether to use the default schema, create a new one, use multiple schemas, or adapt one of the standard schemas such as UCCnet.        
 
         [0142]     The Extract value step  125  highlights the self-authoring options the supplier can take to place the incoming data item field values into the proper attribute fields. The options include: 
        selecting either the automatic or the manual mode of extracting item field values into the proper attribute field, or both for selected subsets of items;     deciding when to use existing patterns, and when to create new ones to facilitate the value extraction;     deciding whether to use the default attributes, create new ones for internal use, or adapt existing values to fit external standards for core and extended attributes such as UCCnet; and     decide how to add pricing data per item, and how to manage its constant change and update requirements.        
 
         [0147]     The Prepare step  130  highlights the self-authorizing options the supplier can take to further prepare their data for rich-content applications, including: 
        deciding how to structure the short and long descriptions that represent the data item in a catalog;     deciding whether to add images or attachments to the item data to make it easier for end users to understand the item;     deciding whether to use or modify existing templates to provide additional structure to the data to meet external requirements; and     decide what data formatting and definition standards to comply with in order to be able to register the product data items in external data pools such as UCCnet.        
 
         [0152]     The Quality Control step  135  highlights the self-authoring options the supplier can take to ensure the quality of the items that are published. These options include: 
        assigning responsibility for quality control, i.e., who is to review what items, in what phase, at what level of approval;     deciding how to handle items that are approved, and those that are rejected at any given phase; and     deciding what catalog views to provide to which users at each phase in the process to help them see how the end user will be viewing the product data when it is published and in use.        
 
         [0156]     The Publish step  140  highlights the self-authoring options the supplier can take to ensure that the items are published correctly, including: 
        deciding what data is to be published, to whom, in what format, on what schedule; and     deciding on the method of data transfer, whether the supplier will push the data to the recipient or the recipient will pull the data from the supplier.        
 
         [0159]     The Output step  145  highlights the self-authoring options the supplier has with regards to the data that is sent to the recipient, including: 
        rich-content catalog data that is structured, consistent, and contains images and attachments;     structured data files that can be imported into other systems;     data that is formatted and defined to meet the requirements of various data pools;     data that is formatted and defined to meet the requirements of various data registration standards bodies; and     data that is formatted and defined to meet the requirements of various ERP systems.        
 
         [0165]     The Feedback step  150  highlights the types of feedback the supplier is seeking to allow them to better self-author the options they choose in the future to improve the process the next time it is utilized, including: 
        metrics about the process itself, and how efficient and effective it is regarding elements such as; data accuracy, data completeness, the timeliness of the process, the cost effectiveness of the process, the usefulness of the output and audit tracking; and     metrics about the results of their initial expectations, including; the initial objectives, the results against those objectives, the gap between what was expected and what occurred, and the corrective actions that are needed to close the gaps. 
 
 The Data Flow Process 
       
 
         [0168]     As illustrated at the bottom of  FIG. 1 , in a preferred embodiment the steps in a Data Flow Process parallel the Supplier Portal Process Flow, and illustrate how the data moves as the process takes place, including: 
        receiving input data  105 ;     rationalizing  115  the received data;     classifying the rationalized data  120 ;     extracting values from the classified data  125 ;     storing the data in a temporary storage area to await quality control  155 ;     approving the quality of at least some of the data stored in the temporary storage  135 ;     moving the approved data from the temporary storage to a final storage area  160 ; and     selecting data stored in the final storage area to be published  140  to at least one target  145  selected from the group consisting of catalog, data pool, and ERP system.        
 
         [0177]     Functions included in a preferred embodiment of the system and method of the present invention to support a supplier in self-authoring a business process include: 
        a. Administrator maintenance 
            i. Administrator account setup     ii. Approval management setup    
            b. Supplier maintenance 
            i. Supplier account setup    
            c. User maintenance 
            i. User Product View Setup     ii. Pricing Model Maintenance     iii. New Shopper Group Setup     iv. User Account Setup     v. Changing a Password    
            d. Item Management 
            i. Importing Items     ii. Import Data Updates     iii. Add/enter Items     iv. Edit/change/modify Items     v. Delete Items    
            e. Catalog Management 
            i. Review and Approve Catalog Content     ii. Catalog Navigation 
                (1) Viewing the catalog    
                iii. Short descriptions    
            f. Reports     g. Database Schema        
 
         [0202]     The following sections discuss preferred embodiments of each of these functions and, by way of example only, provide screen shots of an implementation of a supplier portal according to the system and method of the present invention.  
         [0000]     A. Administrator Maintenance  
         [0000]     Administrator Account Setup  
         [0203]     This function allows a Supplier Portal Administrator to: 
        create and maintain all system administrator accounts, supplier accounts, and user accounts;     create and maintain catalog content approval workflows, and supplier registration information, wherein an Approval Workflow function allows the user to specify for each of their suppliers who must review and approve catalog content before it can be published to the catalog;     create and maintain Supplier product views, user product views, user shopper groups, and pricing models; and     change password information.        
 
         [0208]     The Administrator Account Setup function of a preferred embodiment of a Supplier Portal allows the Administrator to specify the information that users can access and the functions users can perform in the application.  
         [0209]     A preferred embodiment of a Supplier Portal includes at least three user profiles. The three user profiles are “System Administrator,” “Supplier,” and “Catalog User.” Each user profile is a collection of privileges that can be assigned to one or more user account.  
         [0210]     At least the following rules apply to the Setup of a Supplier Portal&#39;s at least three user profiles: 
        the System Administrator user profile provides a user full access to all available functions within the application;     the Supplier user profile provides a user full access to all the available functions within the Password Maintenance, Import Items, Add/Enter Item, Edit/Change/Modify Items, Deleted Items, Catalog Navigation, and Edit/Registration Form options of the Master Maintenance Menu page;     the Supplier user profile allows the user to create a user account for each of their organization&#39;s suppliers;     the Catalog user profile provides a user access to their organization&#39;s catalog such that each Supplier Portal user gets one and only one user account and an account provides identification information about the user, including the user&#39;s login ID and password;     the user profile (privileges) granted to a user account determines the information the user can access and the functions the user can perform; and     any user involved with the catalog content approval process workflow(s) configured in the application for their organization must have an administrator user account. 
 
 Approval Management Setup 
       
 
         [0217]     The following rules apply to Approval Management Setup: 
        supplier Portal allows the user to create a catalog content approval workflow for each of their suppliers;     a catalog content approval workflow refers to the business rules implemented within Supplier Portal to mimic an organization&#39;s internal catalog content approval process and therefore, a catalog content workflow can be as simple or complex as needed;     an organization&#39;s catalog content approval process is represented in a workflow by levels where a Level refers to the user or groups (of users) within an organization responsible for reviewing and approving a supplier&#39;s catalog content before it can be published to a catalog;     a catalog content approval workflow must contain at least one level. A level must contain at least one user;     a catalog content approval process workflow must be created for each supplier and one and only one workflow can be associated with a supplier;     a supplier may be assigned to the workflow for the supplier; and     six default approval roles are “Supplier,” “Material Expert at Host,” “Supplier Allower,” “Local Controller”, “Commodity Manager,” and “Additional Approvers” where approval roles refer to the groups of users in an organization responsible for reviewing and approving catalog content.        
 
         [0225]     The Supplier approval role refers to the supplier of an approval process workflow.  
         [0226]     The Material Expert approval role refers to the staff member(s) responsible for reviewing and approving catalog content for an approval process workflow to ensure the use of best practices for catalog content creation.  
         [0227]     The Supplier Allower approval role generally refers to the supervisor at an organization responsible for reviewing and approving catalog content for all of the organization&#39;s approval process workflows.  
         [0228]     The Local Controller approval role refers to the managers at the regional level of an organization responsible for reviewing and approving catalog content for individual approval process workflows.  
         [0229]     The Commodity Manager approval role refers to the managers at the national level of an organization responsible for reviewing and approving catalog content for all of an organization&#39;s approval process workflows for a particular commodity or particular group of commodities.  
         [0230]     The Additional Approvers role refers to the additional staff at an organization responsible for reviewing and approving catalog content for individual approval process workflows. 
    in addition to the default approval roles, the Supplier Portal application can implement any additional approval roles for use with an organization&#39;s catalog content approval process workflows;     approval roles are available for use across catalog content approval process workflows, the user(s) assigned to an approval role must be the same within a single workflow, and the user(s) assigned to an approval role can be different across workflows;     catalog content approval process workflows are defined as step approval processes, meaning Supplier Portal routes the catalog content for approval to the user(s) of each level of the assigned catalog content approval process workflow one level at a time;     after new catalog content is created using the Import Items or Add/Enter Item options in the Master Maintenance Menu page or existing catalog content is updated or deleted, Supplier Portal assigns the catalog content approval process workflow for the supplier to the catalog content, the catalog content cannot be published to the organization&#39;s catalog until each level of the catalog content approval process workflow approves the catalog content, and after the last step of the approval process approves the catalog content, Supplier Portal automatically publishes the catalog content to the organization&#39;s catalog;     if an approver rejects the catalog content submitted for his/her review and approval, Supplier Portal automatically routes the submitted catalog content back to the previous level of the catalog content approval process workflow for review and approval again;     as Supplier Portal routes catalog content through an organization for review, the users responsible for reviewing and approving catalog content receive email notification of the catalog content submitted for their review and approval, and then, using the Catalog Administration function accessible from the Master Maintenance Menu page, these approvers review and route submitted catalog content;     if a new supplier is created, then it is necessary to create a new administrator or supplier account, and then create the catalog content approval process workflow for the supplier, then Supplier Portal displays the new workflow, the administrator or supplier account displays by default as the first level of the workflow depending on the process followed, if a supplier account is created after the supplier product view is created then the Supplier is the first level by default. If not, the administrator is the first level by default, the level can be updated as needed;     there must be a minimum of one approval level with no maximum limit. However the system will display a warning message in the event of a particular supplier product view having only one approval level, with the level being either the supplier himself or just the administrator, and failure to have more than one level could result in the items routing directly to production without a proper QA; and     deleting an approval level/approver in the midst of an item being in the approval cycle will result in the system prompting the administrator to proceed or not, if elected to proceed as an approval, the items/changes will move to the next level/approver even if this means the items moving to production with no more additional approvers after the one being deleted, if it&#39;s a rejection, then the items will move backward to the level/approver before the one being deleted, and if a particular field is already waiting for approval in the next level then the change coming from the approver that is going to be deleted will be ignored/lost and the same in the case of a rejection waiting in the previous level. 
 
 B. Supplier Maintenance 
   
 
         [0240]     This function provides a central location for creating and maintaining supplier product views, supplier accounts, catalog content approval workflows, and to enter the supplier registration information. The Supplier Maintenance function allows the user to: 
        create a new supplier product view, and modify or delete an existing supplier product view;     create a new supplier user account, and modify or delete an existing supplier user account;     create a new catalog content approval workflow, and modify or delete an existing catalog content approval workflow; and     enter the supplier information needed to allow a supplier to register in the application.        
 
         [0245]     The steps a user performs to configure a supplier for use in a Supplier Portal are: first create a product view for the supplier, then create a user account for the supplier, then create a catalog content approval workflow for the supplier, and then enter the basic supplier identification information needed to allow the supplier to register in the application.  
         [0000]     The Supplier Account Setup  
         [0246]     This function allows the user to enter the supplier identification information needed to allow a supplier to register in the application— FIG. 2 . The following rules apply to Supplier Registration Form: 
        the required fields of a supplier registration form must be completed for a supplier to allow the supplier to log into Supplier Portal and include: Supplier Name, Terms, Transmit method, Shipping method, A/P number, DUNS number, Accept order attachments, User access, Plant name/number; and     when a supplier logs into Supplier Portal, the application provides the supplier access to the supplier&#39;s registration form such that the Supplier has a set of required fields to complete before he can load any data, including: Address, City, Zip, Sales Rep name, email, phone and fax. 
 
 C. User Maintenance 
       
 
         [0249]     The User Maintenance function provides a central location for creating and maintaining user product views, catalog user accounts, shopper groups, and catalog pricing models. The User Maintenance function allows the Supplier Portal Administrator to: 
        create a new user product view, and modify or delete an existing user product view;     create a new catalog pricing model, and modify or delete an existing catalog pricing model;     create a new shopper group, and modify or delete an existing shopper group; and     create a new catalog user account (i.e., the requesters or shoppers that will be placing orders from an organization&#39;s catalog), and modify or delete an existing catalog user account. 
 
 User Product View Setup 
       
 
         [0254]     In Supplier Portal, a user product view refers to a named group of one or more suppliers in a catalog to which a catalog user group is assigned. The following rules apply to User Product View Setup: 
        user product views allow the administrator to create different pricing structures that are then applied to the different groups of users of a catalog and can be used to control which user groups have access to a supplier&#39;s products in a catalog;     the administrator can create suppliers, and then assign them to user product views;     the administrator can create user product views, and then assign them to shopper groups; and     when a user product view is assigned to a shopper group, it allows any user in the shopper group to view the products of each supplier assigned to the user product view. 
 
 Pricing Model Maintenance 
       
 
         [0259]     The Pricing Model Maintenance function allows the Administrator to specify the product pricing of a catalog for each shopper group, which includes specifying the markup of products. The pricing model components include: The name of the pricing model, the Main Markup %, the Freight Markup %, Other Markup %. The following rules apply to Price Model Maintenance: 
        the Price Model Maintenance function is particularly helpful if different pricing has been negotiated with suppliers based on a shopper group;     with pricing models in use, when a user displays a product in a catalog, Supplier Portal calculates and displays the price of the product based on the markup specified in the pricing model assigned to the user&#39;s shopper group;     the administrator can create pricing models, and then assign them to shopper groups; and     the pricing model is the captures, stores and uses an effective date and an expiration date to establish the start and end date of the time sensitive aspect of item pricing. 
 
 New Shopper Group Setup 
       
 
         [0264]     In Supplier Portal, a shopper group is a role, or group designation, that the Administrator creates to apply to and categorize users by the products they are permitted to access in a catalog. The elements in a shoppers group include: the shoppers group name, the product view assigned, the pricing model assigned, the main markup %, the freight markup %, and the other markup %. The following rules apply to Shopper Group Setup: 
        when a shopper group is created, it is associated with a user product view and a pricing model;     the administrator creates a shopper group, and then assigns it to selected users;     a Shopper Group can be assigned to one or more catalog user accounts;     a Shopper Group can be created with a parent-child relationship with the parent having access to all the views of a child shopper group; and     user product views, and a pricing model, must be created before creating shopper groups. 
 
 User Account Setup 
       
 
         [0270]     The User Account Setup function allows the administrator to create and maintain the user accounts of an organization&#39;s catalog. The elements in a user account include: user name, id, password, email address, phone, fax, credit card number, and the user groups to which the user is assigned. The following rules apply to User Account Setup: 
        a user account identifies a catalog user in the application and consists of a user&#39;s identification and login information. Catalog user refers to the requesters or shoppers that will be placing orders from an organization&#39;s catalog;     the Administrator must create shopper groups prior to creating catalog user accounts.        
 
         [0273]     Then they can assign shopper groups to catalog user accounts; and 
        any user involved with using an organization&#39;s catalog must have a catalog user account. 
 
 Changing a Password 
       
 
         [0275]     The user can elect to change their password. To do so they are required to enter their current password, the new password, and the new password again as a confirmation.  
         [0000]     D. Item Management  
         [0276]     Item management includes the functions of Import Items, Add/Enter Item, Edit/Change/Modify Items, and Delete Items. These functions allow a user to create and maintain an organization&#39;s catalog content. These functions allow a Supplier Portal Administrator to: 
        import catalog content (product information) from a formatted file obtained from a supplier (Import Items function);     enter catalog content manually (Add/Enter Item function);     modify existing catalog content manually (Edit/Change/Modify Items function); and     delete existing catalog content manually (Delete Items function). 
 
 Importing Items 
       
 
         [0281]     The Import Items function is used to import/modify catalog content (product information) from a formatted file obtained from a supplier. The following rules apply to Import Items: 
        the Import Items function can be used with a formatted file containing at least 20 product information records;     the Import Items function supports an MS Excel (.xls) file containing the required and optional fields for each product record;     the Import Items function allows a user to import multiple product information files at one time;     importing a product information file includes correcting any errors Supplier Portal identifies in the file, and then classifying and processing each product information record in the file into the existing classes of an organization&#39;s catalog; and     a Supplier Portal Administrator can only load/update the catalog content for the supplier of the approval process workflow they are currently assigned to. 
 
 The user follows the steps below to import new items: 
       
 
         [0287]     1. From the main menu bar select Item Management&gt;Import Items&gt;Upload Data File.  
         [0288]     2. Select Upload Data File and the Upload Data File page will appear— FIG. 3 . Here the user selects the supplier portal view  310  and the excel upload filename  320 .  
         [0289]     3. If the incoming product information is not in a supported file format, the user selects the Display Excel Template link to display the supported file format template. An Excel spreadsheet with the template to be used for loading the data is displayed. The template contains at least the following data item fields: product id, project id, supplier SKU #, supplier id, supplier name, UPC code, supplier short description.  
         [0290]     4. The user copies or manually enters all of the product information into the template file.  
         [0291]     5. The user saves the file to a local machine. By default, Supplier Portal saves the file to the C:\ drive of the local machine.  
         [0292]     6. From the Upload Data File page, the user selects the Select Supplier Product View drop-down, and chooses the supplier of the product information.  
         [0293]     7. In the Select An Excel Upload File field, the user enters the complete pathname of the product information file, or selects the Browse option to navigate to the file and select its name.  
         [0294]     8. The user selects the Upload File option. A status pop-up window is displayed indicating the progress of the different stages during the data upload. The stages include: file ftp, Initializing, Loading file into memory, and loading data into data base. As the process unfolds, at least one pop-up window indicates the total # of records processed, and the percent of records processed from the total input file.  
         [0295]     9. If the user has more than one product information file to import, after the pop-up window displays the “File ftp . . . ” status for a file, the user may then upload the next file for processing.  
         [0296]     10. After uploading each data file, from the main menu bar the user selects Item Management&gt;Import Items&gt;Track and Process Uploaded Data. The Table page is displayed listing the status of each uploaded product information file. This includes the project name, the table name, the start product id, the end product id, the rate of valid records, the link to the download error list, the link to the downward rejection list, the append data, the delete upload, the date, the user who created/imported the data, the user who updated the data, and the update date.  
         [0297]     11. For the status of each uploaded file, the user review the Project, Table Name, and a Rate of Valid Records columns is displayed in the page for each file.  
         [0298]     12. To review any errors in a file, the user selects the Download Error List link for the file.  
         [0299]     13. Respond to the confirmation message that displays by selecting Yes. A Download Error List spreadsheet is displayed listing each error, including a description of each error, product id, the supplier SKU, the error code, and the error message.  
         [0300]     14. The user selects the Download Rejections link to make the necessary corrective actions to the file.  
         [0301]     15. The user responds to the confirmation message that displays by selecting Yes. Supplier Portal downloads the rejections list, and then displays the spreadsheet. The spreadsheet items include: the product id, the project id, the load event it, the supplier SKU, the supplier id, the supplier name, the UPCcode, the description, and the supplier long description.  
         [0302]     16. The user corrects each error listed in the spreadsheet, and then repeats the above steps for each product information spreadsheet until no errors exist. Note: 
        Supplier Portal allows the user to classify a product record with errors, but does not allow the user to add a product record with errors to the application.     The Rate of valid records column and the Error/Rejections list reflect the information to both processes, Upload and Append. If the Append link is visible under the Append Data column then the Rate of valid records column and the Error/Rejections list reflect those of the Upload process. Otherwise they reflect those of the Append process. On the other hand since the Supplier Portal allows the user to process a data file with upload errors, then the Rate of valid records column and the Error/Rejections list reflect those of the Upload and Append processes together.        
 
         [0305]     17. From the Table page, to classify and process the data of an imported product information file, the user selects the respective link for the file under the Table Name column. The Process Data Page displays for the file— FIG. 4 . 
        The Process Data page contains the following items:     The left frame contains the item classification schema  410 .     The right frame contains:     a. A filter section  420  which includes a field for filtering, an operator for filtering, a filter string, an operator (and, or) to combine the filter, a filter button, and a release button     b. An action section  430  containing buttons which include: select all the items in the right frame, unselect all the selected items, manually classify the selected items, automatically classify the selected items     c. A go to page section  440  which includes arrow icons that go to the first and last records in the screen, a page entry box to go to the entered page number, and a reset page size box to modify the page size     d. An item section  450  which includes a check box for selecting the item, a description of the item, the class id of the item, the class determined field, the supplier name, the supplier SKU, the cost of the item, the unit of measure for the item, the attribute 1 value, and the value 1 item. 
            Before classifying each product record, in a preferred embodiment, the user sorts/groups the records into groups of similar products.    
               
 
         [0314]     18. To use the auto-recognition process of the Supplier Portal of the present invention to automatically classify each listed product, the user selects the Auto ID option. Using an extensive knowledgebase of sophisticated recognition rules, the auto-recognition process analyzes the description and attribute fields of each product to determine which class a product most likely belongs to. For each product, the Class Determined column displays the class assigned to a product by the Supplier Portal. If the user uses the Auto ID option, the user must review each product assignment to ensure the Supplier Portal classified each product correctly. (Note that if “All Classes” displays in the Class Determined column for a product after using the Auto ID option, the user must use the Manual ID option to classify the product manually.) 
        To manually assign a product or group of products to a class, in the right pane of the page, the user selects each product, then in the left pane of the page navigates to and selects the class, and then selects the Manual ID option. For each product, the Class Determined column displays the assigned class of each product. If the user classifies a product or group of products manually, and then uses the Auto ID option, the Supplier Portal of the present invention overwrites these manual classification(s).        
 
         [0316]     19. After classifying each product in the product information file, from the main menu bar, the user selects Item Management&gt;Import Items&gt;Track and Process Uploaded Data.  
         [0317]     20. To add the product information to the Supplier Portal of the present invention, the user locates the table that was just processed and selects the Append hyperlink in the same row under the Append Data column. To delete the product information, the user selects the Delete hyperlink in the same row under the Delete Upload column. Note that after the user uses the Append Data option, the two columns—Start Product ID and End Product ID—display the respective numbers for each product record.  
         [0318]     The user can append only those data that have passed all the validations. If there any records that did not append, the user can download the rejected records, correct them and re-upload them as a new file.  
         [0319]     After the user adds the product information, a Supplier Portal according to the present invention associates the catalog content product information with a catalog content approval process workflow for the supplier and then, according to the assigned workflow, routes the content to the appropriate Administrator(s) for review and approval.  
         [0000]     Import Data Updates  
         [0320]     The Import Items function can also be used to load updates to existing catalog data. The following rules apply to Import Items for the purpose of making updates to existing catalog content: 
        the appropriate action codes in the SPI file (the formatted .xls file) must be used to update catalog content;     the action codes for updates include: UPPR (Update Price: List Price and Cost), UPDR (Update Record: Entire Record except ProjectID, SupplierID, SupplierSKU, Image Files, and Unit of measure), DEL(Delete Record); and     a Supplier Portal Administrator can update at least the catalog content for the supplier of the approval process workflow that the Supplier Portal Administrator is authorized to update. 
 
 The user performs steps 1-16 to load the data file with the updates contained the formatted file containing all the updated records and the appropriate action codes. 
       
 
         [0324]     To add the updates to, the user locates at least one table that has been uploaded and selects the Append hyperlink located in the same row under the Append Data column.  
         [0325]     To delete the product information, the user selects the Delete hyperlink located in the same row under the Delete Upload column.  
         [0326]     A Supplier Portal according to the present invention may take into consideration the following fields—Supplier ID, SupplierSKU, Cost, and unit of measure of each record to identify the exact record and make the appropriate corrective action. If any of these fields individually or combined do not match that of an existing record then that item gets rejected. The user can download the rejected records, fix them and re-upload them as a new file.  
         [0000]     Add/Enter Items  
         [0000]     The following rules apply to Add/Enter Items:  
         [0000]    
       
         
           
              the Add/Enter Items function is used to enter catalog content (product information) manually; and  
              a Supplier Portal Administrator can Add/Enter at least the catalog content for the supplier of the approval process workflow that the Supplier Portal Administrator is authorized to update. 
 
 To add an item manually, the user performs the following steps: 
 
           
         
       
     
         [0329]     1. From the main menu bar selecting Item Management&gt;Add an Item to access the Add/Enter Items page. The page has two frames, and shows the hierarchical structure of the organization&#39;s catalog in the left frame.  
         [0330]     2. From the Add/Enter Items page, searching for a class into which to enter an item by entering a keyword(s) in the box in the right hand frame, or by navigating the available parent and child classes of the catalog in the left hand frame. 
        a. To use the Keyword search, In the Search field, entering a keyword(s). The Add/Enter Items page redisplays, showing the list of the classes that contain the keyword(s). Select a class link to display the Add/Enter Items page for the class.     b. To search for a class by navigating the available parent and child classes of the catalog, from the left pane of the page selecting the parent class folder under the All Classes folder to display the child class folders of the parent class folder. From the left pane of the page, navigating to and selecting the class to which an item is to be added.        
 
         [0333]     3. With the desired class folder highlighted, selecting the Add option to access the Product Record page— FIG. 5 .  
         [0334]     4. Filling in the appropriate fields  510 , as necessary, or selecting an attribute link to select from the complete list of available values. The attribute fields displayed vary depending on the attributes associated with the selected class.  
         [0335]     The fields that can be filled-in include the: item long description, type, style, number of pieces, size, UNSPSC, material, application, brand name, unit of measure, mfg name, mfg model, mfg part number, supplier name, supplier part number, and cost.  
         [0336]     For the Manufacturer Name field the user enters an existing value or creates a new value on-the-fly. When creating a new manufacturer name on-the-fly, in a preferred embodiment the user adheres to their organization&#39;s naming convention for manufacturer name. When the user creates a new manufacturer name on-the-fly, the user must enter a checkmark in the “new name” check box. Doing so causes the Supplier Portal of the present invention to send an email notification to a System Administrator informing that a new manufacturer name has been created.  
         [0337]     5. To upload a product picture for the product, the user selects the Load Picture option, and then selects Browse to navigate to and select the picture file.  
         [0338]     6. To attach a file to the product, the user selects the Attachment option, and then selects Browse to navigate to and select the picture file.  
         [0339]     7. The user selects Submit to add the product information. After the user adds the product information, a Supplier Portal according to the present invention assosicates the catalog content product information with a catalog content approval process workflow for the supplier and then, according to the assigned workflow, routes the content to the appropriate Administrator(s) for review and approval.  
         [0000]     Edit/Change/Modify Items  
         [0340]     The following rules apply to Edit/Change/Modify Items: 
        the Edit/Change/Modify Items function is used to modify existing catalog content (product information) manually.     a Supplier Portal Administrator can Edit/Change/Modify Items in at least the catalog content for the supplier of the approval process workflow that the Supplier Portal Administrator is authorized to update. 
 
 To update an item manually a user performs the following steps: 
       
 
         [0343]     1. From the main menu bar the user selects Item Management&gt;Edit/Change/Modify Item to access the Edit/Change/Modify Items page. The page has two frames. The left frame shows the hierarchical structure of the organization&#39;s catalog.  
         [0344]     2. From the Edit/Change/Modify Items page, the user can search for an item to edit by entering a keyword(s) in the box in the right frame or by navigating the available parent and child classes of the catalog in the left frame and locating the exact item to edit. 
        To use the Keyword search, In the Search field, the user enters a keyword(s) to find all the classes/items with names that contain the keyword(s) as entered. The Edit/Change/Modify Items page search results— FIG. 6 —displays populated with the list of these classes in the top half  610  and the top two hundred item matches in the bottom half  620 . The user then chooses an item by selecting an Item Number in the bottom half  620  to edit that item, or selects a class link in the top half  610  to display the Edit/Change/Modify Items page— FIG. 7 —for the class     To search for an item by navigating the available parent and child classes of the catalog, from the left pane of the page, the user selects the parent class folder under the All Classes folder to display the child class folders of the parent class folder. From the left pane of the page, the user navigates to and selects the class that contains the item to be edited. The Edit/Change/Modify Items page is displayed— FIG. 7 .     To display a particular class folder  710  containing an item to edit, the user selects the item by selecting the link of the Item number  720  or checking the box  730  of the item to edit. The Edit Product Record page is displayed— FIG. 8 .        
 
         [0348]     3. The user then edits the appropriate fields, as necessary, by entering a new value or selecting an attribute link to choose from a list of available values. The Edit Product Record Page— FIG. 8 —shows the product data items. The fields that can be edited  810  include the: item short and long descriptions, type, diameter, material, color, unit of measure, mfg name, mfg model, mfg part number, supplier name, supplier part number, and cost.  
         [0349]     Note: 
        The item fields change based on the node where the item is classified     The Short Description field is not editable, because a Supplier Portal according to a preferred embodiment of the present invention builds the value of the Short Description field using the short description pattern associated with the class. If there is no pattern defined for that class then the Short description field is editable.     While in an Item detail page, a preferred embodiment of a Supplier Portal according to the present invention, highlights attribute values in three colors to notify the user of the changes to those values. They are: 
            a. Red: Denotes the new value of any field pending approval,     b. Green: Denotes the old value of any field pending approval,     c. Yellow: Denotes that the value in that field is currently awaiting approval in another approvers queue.    
               
 
         [0356]     Selecting the colored columns provides toggling between the old and new values of a field. Toggling on a Yellow colored attribute value would display the new value in yellow and the old value in Green. Toggling on a Red colored attribute value would display the new value in Red and the old value in Green.  
         [0357]     4. To upload a product picture for the product, the user selects the Load Picture option, and then selects Browse to navigate to and select the picture file.  
         [0358]     5. To attach a file to the product, the user selects the Attachment option, and then selects Browse to navigate to and select the file.  
         [0359]     6. To view the audit history of the product, the user selects the Show Item History link to see the Item History Page— FIG. 9 .  
         [0360]     The audit history is a list  910  that contains at least the following: the operations performed on a product, the date of an operation, the user who performed it, the type of modification, and a description of the modification. The audit history is used when the user needs to monitor such information as when a product was last modified or who made a certain modification to a product. The data fields include the: event, date, field name, new value, old value, username, approval status, initial approver, current approver, last approver, future approver, rejection code, and rejection description.  
         [0361]     8. The user selects Submit.  
         [0362]     After the user edits/changes/modifies the product information, a Supplier Portal according to the present invention associates the catalog content product information with a catalog content approval process workflow for the supplier and then, according to the assigned workflow, routes the content to the appropriate Administrator(s) for review and approval.  
         [0000]     Delete Items  
         [0000]     The following rules apply to Delete Items:  
         [0000]    
       
         
           
              the Delete Items function is used to delete existing catalog content (product information) manually; and  
              a Supplier Portal Administrator can only update the catalog content for the supplier of the approval process workflow they are currently assigned to. 
 
 To delete an item manually: 
 
 Note—since this process is essentially the same as the edit item process, the screens for this process are not shown, but the process is described 
 
           
         
       
     
         [0365]     1. From the main menu bar the user selects Item Management&gt;Delete Item to access the Delete Items page. The page has at least two frames. In a preferred embodiment, a left frame provides access to the hierarchical structure of the organization&#39;s catalog. 
            From the Delete Items page, the user can search for an item to delete by entering a keyword(s) or by navigating the available parent and child classes of the catalog and locating the exact item to delete.     Available in the upper-right of the page, the Keyword Search allows the user to quickly search for the items in the catalog by entering the keyword.            
 
         [0368]     2. To use the Keyword search, In the Search field, the user enters at least one keyword to find all the classes/items with names that contain the at least one keyword. The Delete Items page is redisplayed populated with a list of these classes in the top half and the top  200  item matches in the bottom half.  
         [0369]     3. The user selects the item by selecting on the Item Number in the bottom half and selects on Submit in the following screen to delete that item. Or the user selects a class link in the top half to display the Delete Items page for the class and proceed to the next step.  
         [0370]     4. From the left pane of the page, to search for a class by using the available parent and child classes of the catalog, the user selects the parent class folder under the All Classes folder to display the child class folders of the parent class folder.  
         [0371]     5. From the left pane of the page, the user navigates to and displays the class with the item to delete.  
         [0372]     6. With the desired class folder displayed, showing the items in that class, the user selects the check box of the item to delete, and then selects the Delete option.  
         [0373]     7. A confirmation message appears, asking the user if the user is sure the user wants to delete the selected items. The user can cancel the request or select OK to delete the selected items.  
         [0374]     After the user deletes product information, a Supplier Portal according to the present invention associates the catalog content product information with a catalog content approval process workflow for the supplier and then, according to the assigned workflow, routes the content to the appropriate Administrator(s) for review and approval.  
         [0000]     e. Catalog Management  
         [0375]     The Catalog Management function of a preferred embodiment allows a Supplier Portal Administrator to perform the steps of: 
        Reviewing and approving any catalog content created by a supplier or other portal administrator/s and submitted for review and approval.     Viewing the catalog as it would be viewed by the requisitioner.     Defining a template for building a customized short description pattern across all classes, modify and delete an existing short description pattern. 
 
 “Approval” refers to catalog content that has not yet been published to an organization&#39;s catalog for use because the catalog content is in the process of first being reviewed/approved internally within the organization. Catalog content is not published until the last step (internal to the organization) of the applicable catalog content approval process workflow approves the content for publishing. 
       
 
         [0379]     With the Catalog Management function the user can view the complete list of catalog content changes that have been submitted for review/approval, including reviewing a submitted catalog content change and responding to it by selecting from any of the options for routing the catalog content.  
         [0380]     A Supplier Portal according to a preferred embodiment, notifies the user via email each time catalog content is submitted for the user&#39;s review.  
         [0000]     Review and Approve Catalog Content  
         [0381]     In a preferred embodiment, in order to review/approve catalog content the user performs the following steps:  
         [0382]     1. From the Main Menu Bar on the Welcome Page, selecting at least one of Updated Items or New Items or Deleted Items depending on which type of content changes the user wants to review. The Approval Review page— FIG. 10 —displays each catalog content change submitted and awaits the user&#39;s review.  
         [0383]     2. From the Approval Review page— FIG. 10 —performing at least one of approving or rejecting items individually, by page, or by all items selected after reviewing them. To facilitate easier reviewing and approval the user can utilize at least one built-in option comprising filtering, sorting, grouping etc.  
         [0384]     3. To Group by a particular field, dragging and dropping a column heading into a Drag a column, e.g., textbox  1010 , to group the items by a specific column (criteria).  
         [0385]     4. Using a filter function  1020  to view a subset of items, by selecting in the top of the screen a field to filter by, selecting an operand, entering filtering criteria, selecting an operator to add additional filtering criteria as needed, and selecting Filter. Note that the operands displayed vary depending on the selected column. Also the filtering criteria are displayed for perusal.  
         [0386]     5. Sorting the items in a particular order selecting a desired column header  1030 .  
         [0387]     6. Changing the order of the display of the fields, by selecting a desired column, dragging it to a desired location and dropping it. A red handle bar displays after the user selects the desired column and begins to move it to the desired location.  
         [0388]     7. Approving/denying a catalog content, by selecting the check box next to the catalog content  1040 , and then selecting Approve/Reject  1050 . Selecting ‘OK’ on the confirmation message to approve a desired action, or Cancel to stop the approval. To select all the records in the displayed page, the user selects the V button  1060  or to selects all the records, selects the ‘Select All’ button  1020 . To deselect all the selected records, the user selects the ‘Unselect All’ button next to the ‘Select All’ button.  
         [0389]     8. For Approved items, a preferred embodiment of a Supplier Portal routes the approved catalog content to the next step/level in the approval (workflow) process the content is associated with, and then displays a confirmation message. For Rejected items, a preferred embodiment of a Supplier Portal routes the rejected catalog content to the previous step/level in the approval (workflow) process the content is associated with.  
         [0390]     9. Generating a report that lists products being displayed, by right-clicking in the page, then selecting the Export to Excel option that appears.  
         [0391]     10. While in the Item detail page, a preferred embodiment of a Supplier Portal highlights attribute values in at least three colors to notify the user of the changes to those values. The colors include: 
        a. Red: Denotes the new value of any field pending approval,     b. Green: Denotes the old value of any field pending approval, and     c. Yellow: Denotes that the value in that field is currently awaiting approval in another approvers queue.        
 
         [0395]     11. The user may double click on the colored columns to toggle between the old and new values of a field. Toggling on a Yellow colored attribute value displays the new value in yellow and the old value in Green. Toggling on a Red colored attribute value displays the new value in Red and the old value in Green.  
         [0000]     Catalog Navigation  
         [0396]     The Catalog Navigation function of a preferred embodiment allows a Supplier Portal Administrator to view an organization&#39;s catalog as a user of the catalog views the catalog. The Catalog Navigation function allows a user to review the contents of their catalog for ease of navigation and accuracy. In addition, the Catalog Navigation allows the user to at least add a new product, create a new product by copying an existing one, and delete an existing product.  
         [0000]     Viewing the Catalog  
         [0000]     To view the catalog the user performs the following steps:  
         [0397]     1. From the welcome page, the user selects Catalog Management&gt;Navigator to access the Category Selections page— FIG. 11 . As a central screen of the catalog, the Category Selections page provides easy access to the products available in the catalog. From the Category Selections page, the user searches for a product by entering at least one keyword  1110  or by navigating the available product categories and subcategories  1120  of the catalog. Available in the upper-right of catalog pages, the Keyword Search  1110  allows the user to quickly search for products across the product categories and subcategories of the catalog by entering keywords.  
         [0398]     2. To use the Keyword search, In the Search For field  1110 , the user enters at least one keyword to find all the products with names that contain the at least one keyword. The user can select the type of search  1130 , can select “All Words” to find all the products with descriptions that contain all the entered words, can select “Exact Words” to find all the products with descriptions that contain all the entered words exactly as the user has entered them, can select “Any Words” to find all the products with descriptions that contain any of the words entered, and can select “Without the Words” to find all the products with descriptions that do not contain any of the words entered. After entering the desired at least one keyword, the user selects the Go option  1140 .  
         [0399]     3. A Keyword Search Results page is displayed— FIG. 12 —which lists product categories  1210  as well as products  1220  matching search criteria. The Item Matches table displayed in the bottom half of the page lists each product  1220  matching the search criteria, i.e., the at least one keyword entered by the user.  
         [0400]     4. To view products by product category, the user selects the category link  1210  from the list in the top half of the page. A Product List page displays.  
         [0401]     5. To search for a product using the available product categories and subcategories of the catalog, from the bottom half of the Category Selections page  1220 , the user selects the category desired. If applicable, its subcategories are displayed, and these can be selected as well. Otherwise, A Product List page is displayed.  
         [0402]     6. From the Product List page— FIG. 13 , to view a large picture of a product, the user selects the thumbnail picture of the product  1310 . A large picture of the products is displayed.  
         [0403]     7. The User selects a column heading link  1320  to access options for sorting product records or filtering based on a specific criteria or hiding an available column. At the bottom of the Product List Page— FIG. 14 —The Common Features section  1410  lists any functions that all the displayed products have in common.  
         [0404]     8. The user places a pointer over the SKU Number link  1420  of a product to add a new product, to create a new product by copying the product, or to delete the product. A drop down list is displayed  1430  allowing the user to select among these options.  
         [0405]     9. To add a new product, the user selects the Add new product option  1430  in the drop down menu. A Product Record page is displayed.  
         [0406]     10. To create a new product by copying an existing one, the user selects the Copy product for modification option in the drop down menu  1430  for the product the user wants to copy. A Product Record page is displayed, populated with the values of the product.  
         [0407]     11. To delete a product, the user selects the Delete product option in the drop down menu  1430  for the product, and then the user responds to the confirmation message that is displayed by selecting OK.  
         [0408]     12. To view product detail information, the user selects a SKU Number link  1420  for a product. A Product Information page is displayed— FIG. 15 . The Product Information page displays a large picture of the product  1510 , and other product attributes  1520 , including short and long descriptions, types, diameters, material, color, manufacturer name and model, manufacturer part number, supplier name and part number,  
         [0409]     14. To view an Audit History of the product, the user selects the Show Item History link  1530 . The Audit History is a list containing the operations performed on a product, the date of an operation, the user who performed each operation, the type of operation, and a description of the operation. The Audit History is useful when the performed a certain operation on a product.  
         [0000]     Short Descriptions  
         [0410]     This Catalog Management function allows a Supplier Portal Administrator, to create a new supplier short description pattern, and modify or delete an existing supplier short description pattern.  
         [0411]     The following rules apply to Short Description Setup: 
        The Supplier Portal, in a preferred embodiment, implements the hierarchical structure of the organization&#39;s catalog. The hierarchical structure consists of the available parent classes and child classes of the catalog. Parent class and child class refer to the groups and subgroups (i.e., levels and sublevels) used to organize the available products of the catalog. Typically, a parent class contains one or more child classes, and a child class contains one or more leaf classes, with leaf classes containing products. Note that Leaf class refers to the lowest level child class in a parent class.     By default, Supplier Portal uses the default short description pattern to build the short description of products in each leaf class of an organization&#39;s catalog. The default short description pattern is of the form of Commodity+each leaf class attribute label and value, where Commodity equals the name of the child (leaf) class. Note that if an attribute class value is blank, the attribute label is not included in the default short description pattern.     The short description builder can be turned on or off for a particular class. If it&#39;s ‘ON’ then either the default pattern is used or the custom pattern built for that class is taken into consideration. If it&#39;s ‘OFF’ then the supplier provided short description is taken into consideration.     Using the Short Description Setup function, the user can define a different short description pattern for each leaf class of an organization&#39;s catalog. The Short Description Setup function is helpful if an organization wishes to use short description patterns other than the default short description pattern.     A short description pattern identifies the attributes to be used to build the short description of each item in a leaf class.     When the user displays an item in the catalog, Supplier Portal displays the short description of the item created using the short description pattern of the leaf class of the item. This field is not editable if there is a custom/default pattern defined for that class. On the other hand, it will be editable if the short description builder is set to OFF.     When Supplier Portal is installed, each attribute of the short description pattern of a leaf class is not selected, indicating the default short description pattern is in use for the leaf class. Selecting one or more attributes in the short description pattern of a leaf class indicates the selected short description pattern is to be used for the leaf class instead of the default short description pattern.     Using the Short Description Setup function, the user can also define a short description pattern for the All Classes folder of their organization&#39;s catalog, which the application inherits for any leaf level class that does not have defined a short description pattern. 
 
 To add a short description pattern for a leaf class, the user performs the following steps: 
       
 
         [0420]     1. From the welcome page, the user selects Catalog Management&gt;Short Description Template Setup.  
         [0421]     2. The Short Description page has at least two frames. A left frame provides access to the hierarchical structure of an organization&#39;s catalog. From the Short Description page, the user can search for a leaf class by entering a keyword(s) or by navigating the class tree using the available parent and child classes of the catalog. 
        To use the Keyword search in the right frame, in the Search field, the user enters at least one keyword to find all the classes with names that contain the entered at least one keyword. The Short Description page redisplays populated with the list of these classes.     To use the class tree search, from the left pane of the page, the user searches for a class by using the available parent and child classes of the catalog. The User selects the parent class folder under the All Classes folder to display the child class folders of the parent class folder. The user selects the desired child class folder. If applicable, its child class folders are displayed. Otherwise, its leaf class node(s) are displayed. The user selects the desired leaf class node. The Short Description Setup page for the selected leaf class is displayed.        
 
         [0424]     3. The Short Description Setup page— FIG. 16 —lists the attributes of the selected leaf class  1610 , including the base and user-defined attributes of the class. The base attributes  1620  are the same across all the classes. There are at least six base attributes including Manufacturer Name, Manufacturer Model, Manufacturer Part Number, Supplier Name, Supplier Part Number, and Unit of Measure.  
         [0425]     4. The Short Description Setup page allows the user to decide whether or not the user wants to use the default pattern for creating a short description (i.e., the base attributes listed above  1620 ), or create their own pattern. If they want the default pattern, they select the Skip box  1630 .  
         [0426]     5. If the user wants to create a pattern the user checks either the label  1640  and/or the values  1650  boxes for the attributes the user want included in the short description. The user can check the box next to the labels or values text at the top of the column to select that element for all the attributes. Or the user can select the desired boxes next to each desired attribute to just include the checked elements in the short description.  
         [0427]     6. The user can also use the Up and Dn options  1660  in the right of the page to move the selected attributes to the order in which they are to be displayed in a short description.  
         [0428]     7. The user selects ‘Save’ to save this short description configuration for this leaf.  
         [0429]     8. If a leaf has not been assigned a short description pattern, the same screen and process can be used to create one.  
         [0000]     f. Reports  
         [0430]     In a preferred embodiment of a Supplier Portal a Reports module allows a Supplier Portal Administrator to quickly and easily retrieve catalog content information in user-friendly formats. The reports of the module are designed to help the user conduct almost any type of analysis on their catalog content at all stages of the catalog content lifecycle. The Reporting module gives access to pre-defined reports, providing the user with a full range of options.  
         [0000]     Standard Reports  
         [0431]     The Standard reports are listed in  FIG. 17 , in the drop down menu  1710 . The user is prompted for parameters that allow the user to select the desired sub-set of information to be included in that report. The standard reports include:  
         [0432]     1. Category Report by Supplier/Manufacturer  
         [0433]     This report provides a list of items for a selected supplier, a selected manufacturer, and catalog class/product category. To produce the report, the user selects a link for the report in the Reports page, then selects a desired supplier, manufacturer, and catalog class/product category to be included in the report, and then selects Submit.  
         [0434]     2. Supplier Report with Customer Codes  
         [0435]     This report provides a list of selected supplier&#39;s items with customer codes. To produce the report, the user selects the link for the report in the Reports page, then selects the supplier, and then selects Submit.  
         [0436]     3. Exception Report for Null Attributes  
         [0437]     This report provides a list of selected supplier&#39;s items for which no attributes exist for the selected catalog class/product category. To produce the report, the user selects the link for the report in the Reports page, then selects the supplier and catalog class/product category, and then selects Submit.  
         [0438]     4. Product View Access by Shopper Group  
         [0439]     This report provides a list of a supplier&#39;s shopper groups. To produce the report, the user selects the link for the report in the Reports page, then selects the supplier, and then selects Submit.  
         [0440]     5. Suppliers Available to a Shopper Group  
         [0441]     This report provides a list of suppliers assigned to a shopper group. To produce the report, the user selects the link for the report in the Reports page, then selects the shopper group, and then selects Submit.  
         [0442]     6. Suppliers Assigned to an Individual in Approval Routings  
         [0443]     This report provides a list of catalog content approval process workflows an Administrator user is assigned to. To produce the report, the user selects the link for the report in the Reports page, then selects the administrator user account, and then selects Submit.  
         [0444]     7. Duplicate Parts within a Catalog  
         [0445]     This report provides a list of duplicate items in the catalog for the selected supplier. To produce the report, the user selects the link for the report in the Reports page, then selects the supplier, and then selects Submit.  
         [0446]     8. Duplicate Parts across Multiple Catalogs  
         [0447]     This report provides a list of duplicate items in the catalog across supplier for the selected manufacturer. To produce the report, the user selects the link for the report in the Reports page, then selects the manufacturer, and then selects Submit.  
         [0448]     9. Keyword Search  
         [0449]     This report provides a list of all items based on a keyword in the description field. To produce the report, the user selects the link for the report in the Reports page, then selects the keyword, and then selects Submit.  
         [0000]     g. Database Schema  
         [0450]      FIG. 18  illustrates components in a database schema that shows selected tables and fields used to support a Supplier Portal according to a preferred embodiment. The items with similar names in multiple tables allow for linking record items from different tables into a consolidated record item. The tables, and the fields they contain, are expanded, modified or deleted, to reflect the business requirements of a supplier organization.  
         [0451]     A user and group set of tables of a typical supplier database comprises the tables: 
        1. Users  1810 —defines a supplier user as having an ID  1811  and a CorporateID  1812 ;     2. UserCust  1820 —defines users of the specific supplier;     3. UserGroups  1830 —defines a group of users having GroupID  1831 ;     4. Groups  1840 —defines a named group as equivalent to a GroupID  1831  and relates to UserGroups  1830  by this GroupID  1831 ;     5. GroupsProductViews  1850 —defines the product view identified by ProductViewID  1851  as the view of a product ‘seen’ by a group identified by GroupID  1831 ;     6. GroupPriceModel  1860 —associates a group by GroupID  1831  with a price model by ID 1871  in the Price Model table.     7. PriceModel  1870 —identifies price models by ID  1871 .        
 
         [0459]      FIG. 19  illustrates a part of a database schema for tracking changes to products made by a supplier using a Supplier Portal according to the present invention. The DeleteTrack table  1910  tracks deletes of existing products, the InsertTrack table  1920  tracks new products to be added to a supplier&#39;s catalog of products, and the UpdateTrack table  1930  tracks updates to products that already exist in a supplier&#39;s catalog of products. In each of these tracking tables at least three approvers are recorded: current  1911 , last  1912  and future  1913  in order to locate the approval position of the tracked change in the supplier&#39;s workflow.  
         [0460]     The present invention applies to hosted, enterprise, wired and wireless networked implementations of a Supplier Portal wherein user access may be provided from any end-user device including handheld devices (personal digital assistants, wireless telephones), portable devices both wireless and wired, personal computers and workstations both wired and wireless, computer-to-computer access both wired and wireless, all over wireless and wired networks using interfaces such as web browsers and networks such as the internet, and wireless networks such as IEEE 802.11 and Bluetooth. Remote and local hosted implementations of a Supplier Portal are supported also using public and dedicated networks and communication infrastructure.  
         [0461]      FIG. 20  outlines one embodiment of the components in a Supplier Portal implementation. The application is composed of a web interface  2010  that could reside on a web server, an application software  2020  that could also reside on its own server, and a database  2030  that could also reside on its own server and contain separate locations for data in different states of readiness such as interim data that has not been quality controlled, and final data that has been approved and is ready for publication. The application could be accessed by users inside a firewall  2040  over an internal network  2050  using various devices  2060  such as pc or a handheld device that support a browser. Or the application could be accessed by users outside a firewall  2070  over the internet  2080  using various devices  2090  such as a pc or a handheld device that support a browser.  
         [0462]     Thus, the Supplier Portal provides a system and method for a supplier of goods and services to personalize the supplier&#39;s business persona as presented to the users of a supply chain while the Portal itself imposes conformity that makes it appear to a user that a consistent and integrated business is providing products and services. For example, each supplier provides business rules for how that supplier transacts business with users, roles for administering the business as it appears and occurs to a user of the supply chain, templates for integrating business rules and roles especially for on-line interactions with the Supplier as presented to users of the electronic supply chain. In this way, disparate business methods of a plurality of supply chain partners appear as one while retaining their individuality as business enterprises. This results in a robust supply chain that is easily adapted to changing business paradigms and is easy to use because of the integrity and consistency imposed by the Supplier Portal while users have a choice of suppliers providing different features because they can incorporate their differing ways of doing business, e.g., warranties and discounts and even integration of products and services from other supply chain partners. Each supplier retains an individual identity while appearing as part of a larger, well-functioning whole as a result of the system and method of the present invention for a Supplier Portal.  
         [0463]      FIG. 21  illustrates a preferred embodiment of the interface between a business process (BP) self-authored by a supplier using the supplier portal system and method of the present invention. This interface comprises business process elements (BPEs)  2110  configured using the present invention and a means of “executing the BPEs” by atypical e-procurement process. The portal system of the present invention  2110  provides typical BPEs that are defined and configured by supplier personnel. The typical BPEs provided by the supplier portal include content management, user management, catalog management, report management, staging area management, and portal administration. In a preferred embodiment, the BP comprises instances of the provided BPEs, self-authored by supplier personnel using the system and method of the present invention. For example, in a preferred embodiment the supplier portal, populates data tables that are stored in a database  2120 , and include data for content, roles, templates, rules, workflows, pricing, groups, views, and approvals. The data tables are then accessed by or exported  2130  to a supplier&#39;s e-procurement application  2140  or another supplier system such as an on-line sales system.  
         [0464]      FIG. 22  illustrates a preferred embodiment of the entries used to configure a BPE including a template  2210 , roles  2220 , rules  2230 , and functions  2240 . In a simplified example  2250 , a template  2210  defines entries such as a content approval process, which include a template name, description, creator and creation date; at least one approver role  2220 ; an approval rule  2230 , and at least one procedure  2240  to be followed.  
         [0465]      FIG. 23  illustrates a preferred embodiment of tables in a database that result from configuring a BPE including an element table  2310 , a template table  2320 , a rule table  2340 , and a role table  2350 . The configuration transaction table  2330  cross-references the entries stored in these tables for the template, rule and role that in combination configure the BPE.  
         [0466]     Multiple configuration transaction records can be used to define a complex element that may contain multiple templates, rules and roles. Within a typical e—procurement system  2140  shoppers search catalogs whose format and content has been specified in a supplier authored BP for preferred items, are presented, e.g., with pricing information that may be based on shopper group participation and product views that have been specified in a supplier authored BP and then go on to use a supplier or other third party system or process to create requisitions, obtain purchasing approvals, create purchase orders and send them to suppliers. The suppliers fulfill orders, submit invoices, and receive customer payments to complete the process.  
         [0467]     While the preferred embodiments of the present invention have been illustrated and described, it will be understood by those skilled in the art that the functions and database of a Supplier Portal as described herein are illustrative and various changes and modifications may be made to these functions and database and equivalents may be substituted for elements thereof without departing from the true scope of the present invention. In addition, many modifications may be made to adapt the teachings of the present invention to a particular situation without departing from its central scope, e.g., the database may be flat files or an object base or any combination of alternative data structures. Further, while the present invention has been described from the perspective of the Supplier, the user may well be a Buyer that is consolidating product item data from one or more Suppliers for the purpose of transforming their catalog content into a common buying marketplace that also needs to be self-authored by the Buyer to reflect their culture and purchasing related information needs. Additional parties that may be users of this technology include Content Factories that provide some or all of the services suppliers and buyers require to facilitate buy-sell transactions. Therefore, it is intended that the present invention not be limited to the particular embodiments disclosed as the best mode contemplated for carrying out the present invention, but that the present invention include all embodiments falling with the scope of the appended claims.  
       Appendix A  
     Supplier Product Input Table (SPI) Data File Layout  
       [0468]     The following table is an example of a preferred layout of a Supplier Product Input Table (SPI) data file. The table defines all the fields in an SPI data file, and the type, maximum size, and description for each field. This is the template used in the .xls file used to import catalog content.  
                                                                             Max               Field Name   Field Type   Size   Description   Comments                                ProductID   Number   50   Unique Product   Not                   identifier.   Required       ProjectID   Number   50   Unique Project/Catalog Identifier   Not                       Required       Supplier   Text   30   Indicates the Stock Keeping Unit   Required       SKU           code/Supplier Part Number for the                   product. Must be unique for each                   product.       Supplier ID   Number   50   A unique identifier for a supplier   Required                   within Supplier Portal, e.g. the                   DUNS number.       Supplier   Text   80   Identifies a supplier&#39;s name.   Required       Name       UPC Code   Text   12   Indicates the Universal Product                   Code for the product, if applicable.       Supplier   Text   254   Associates concise information   Ex: Size,       Short           with a product. Typically, this is the   Color.       Description           brief version of the supplier&#39;s   Material,                   technical description of the product.   etc.       Supplier   Text   No   An expanded description of a   Required       Long       limit   product. Typically, this is the       Description           supplier&#39;s technical and marketing                   description of the product.       List Price   Currency   Auto-   A product&#39;s cost per unit of   Required               matic   measure. Typically, this is the                   product&#39;s suggested retail price. A                   value with up to four decimal                   places may be entered.       Price   Text   50   Currency used for product&#39;s list   Required       Currency           price. USD is the default currency.                   Australia (dollar): AUD                   Belgium (franc): BEF                   Brazil (Real): BRR                   Canada (dollar): CAD                   France (franc): FRF                   Germany (Mark): DEM                   Italy (lira): ITL                   Japan (Yen): JPY                   Republic of Korea (Korean South)                   (Won): KRW                   China (Yuan Renminbi): CNY                   Spain (peseta): ESP                   Switzerland (franc): CHF                   Taiwan (New Taiwan dollar):                   TWD                   United Kingdom (pound): GBP                   United State: USD                   Euro Currency: EURO       Effective   Date/Time   8   Indicates the effective date the   Applicable       Date           product is available for shopping.   to the                       whole item                       if the item                       was never                       published                       before.                       Otherwise,                       valid for                       Cost only if                       it&#39;s an                       existing                       item.       Expiration   Date/Time   8   If a term applies, indicates the   Applicable       Date           expiration date of the product being   to the                   not available for shopping.   whole item                       if the item                       was never                       published                       before.                       Otherwise,                       valid for                       Cost only if                       it&#39;s an                       existing                       item.       Shippable   Text   2   Determines the unit of measure   Required       Unit of           used as a default for requisitions       Measure           created by the customer       (ShipUOM)           organization.                   For example, if 1-gallon cans of                   paint are sold in cases of 24 cans,                   the ShipUOM equals Case and the                   ShipPkgQty equals one.       Cost Unit of   Text   2   Determines the unit of measure   Required       Measure           used for pricing information       (CostUOM)           entered for a product.                   Can be the same as or different                   from the Shippable Unit of                   Measure.                   For example, 1-gallon cans of paint                   may be sold in cases of 24 cans, at                   $2.00/Can, or $24.00/Case. If sold                   by the case, the ShipUOM equals                   Case and the ShipPkgQty equals                   one.       Supplier   Text   4   Indicates the action to be completed   Required       Action           for the incoming data. Valid values                   are ADD, UPDT, UPPR, and DEL.                   ADD: Add a new record.                   UPDR: Update an existing record                   in whole except ProjectID,                   SupplierID, SupplierSKU, Image                   Files, and Unit of measure                   UPPR: Update price (Cost and List                   price) of an existing record.                   DEL: Delete an existing record.       Supplier   Text   30   For a discontinued product,   SKU       Successor           indicates the SKU of a replacement       Product           product as recommended by the                   supplier.       Cost   Currency   8   Identifies the cost of the Shippable   Required                   Packaging Quantity.                   For example, 1-gallon cans of paint                   may be sold in cases of 24 cans, at                   $2.00/Can, or $24.00/Case. if sold                   by the case, the ShipUOM equals                   Case and the ShipPkgQty equals                   one, and the Cost equals $24.00.       Cost   Text   4   Identifies the currency used for a   Required       Currency           product&#39;s cost. The currency type,                   USD, is the default currency.       Delivery   Number   4   Specifies (in days) the average       Days           lead-time required when ordering                   the product. Should include the                   time an item is needed to the time it                   is received.       Shippable   Single   4   Designates a quantity for the   Required       Packaging           Shippable Unit of Measure.       Quantity           For example, 1-gallon cans of paint                   may be sold in cases of 24 cans, at                   $2.00/Can, or $24.00/Case. If sold                   by the case, the ShipUOM equals                   Case and the ShipPkgQty equals                   one, the Cost equals $24.00, and the                   ShipPkgQty equals one.       Cost   Single   4   Designates a quantity other than the   Required       Packaging           Shippable Unit of Measure. Can be       Quantity           the same as or different from the                   Shippable Unit of Measure.                   For example, 1-gallon cans of paint                   may be sold in cases of 24 cans, at                   $2.00/Can, or $24.00/Case, with 10                   cases/pallet. If sold by the case, the                   ShipUOM equals Case and the                   ShipPkgQty equals one, the Cost                   equals $24.00, and the ShipPkgQty                   equals one. If purchased by the                   pallet, CostUOM equals Pallet and                   CostPkgQty equals 10.       Manufact-   Text   100   Identifies the product&#39;s   If       urer Name           manufacturer.   Available       Manufact-   Text   100   Identifies the product&#39;s   If       urer Part           manufacturer part number.   Available       Number       Purchase   Text   1       Frequency       ClassID   Number   Long       Not       Determined       Integer       Required       Class   Text   Unlim-   Example: PipeValvesHosesTubing   Not       Determined       ited   &amp; Fittings/Valves/GateValves   Required       COL_label —     Text   100   Identifies the name of each attribute   If       1 thru           (i.e. size, color, material, etc)   Available.       COL_label —             associated with a product.   Use these       30               columns to       (Total of 30               furnish       fields)               other                       pertinent                       product                       attributes                       that cannot                       be filled in                       other                       columns.       COL_1 thru   Text   100   Identifies the value (i.e. 1/2 Inch,   If       COL_30           Steel, Blue, etc.) of each attribute   Available.       (Total of 30           associated with a product.   Use these       fields)               columns to                       furnish                       other                       pertinent                       product                       attributes                       that cannot                       be filled in                       other                       columns.                  
 
         [0469]     The table below provides a description of each available field type.  
                                   Field Type   Definition                   Text   Alphanumeric characters.       Memo   Lengthy text or combinations of text and numbers. Up to           65,535 characters.       Long   Long Integer. Numeric data used in mathematical           calculations. Integer numbers from −2,147,483,648 to           2,147,483,647 (no fractions).       Date/Time   Date and time values.       Currency   Currency values and numeric data used in mathematical           calculations involving data with one to four decimal           places. Accurate to 15 digits on the left side of the           decimal separator and to 4 digits on the right side.       Yes/No   Yes and No values and fields that contain only one of two           values (Yes/No, True/False, or On/Off).       Single   Single Integer. Decimal value can go up to 7 digits.                  
 
         [0470]     For valid UNSPSC codes and values, visit the UN/SPSC Web site.