Taxonomy and data structure for an electronic procurement system

• US 9,245,289 B2
• Filed: 01/22/2013
• Issued: 01/26/2016
• Est. Priority Date: 01/15/2008
• Status: Active Grant

• Current Assignee: SciQuest Incorporated
• Original Assignee: SciQuest Incorporated
• Inventors: Ballaro, Charles A., Lef, Alexey, Frink, David
• Primary Examiner(s): HAQ, NAEEM U
• Application Number:
  US13/747,396
• Publication Number:
  US 20130254075A1
• Time in Patent Office: 1,099 Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0603 Catalogue ordering
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders
• CPC Class Codes: G06Q 50/163 Real estate management

Abstract

A computer-implemented method is described, performed at a server hosting an electronic procurement system. Supplier catalog data is received at the server from a plurality of respective suppliers associated with the electronic procurement system. The supplier catalog data is in a plurality of formats. The supplier catalog data is converted from the respective plurality of formats to respective common format catalog data. The respective common format catalog data is added to a database.

Claims

1. A computer-implemented method, comprising:

at a server hosting an electronic procurement system that facilitates transactions among a plurality of purchasing organizations and a plurality of suppliers over an electronic network, the server including one or more processors and a memory storing programs for execution by the processors;

receiving over the electronic network supplier catalog data from the plurality of respective suppliers, where the supplier catalog data is in a plurality of formats;

obtaining from a business rules database business rules associated with the plurality of respective suppliers;

in accordance with the business rules, automatically converting the supplier catalog data from the respective plurality of formats to respective common format catalog data;

storing in the memory of the server information linking respective common format catalog data to corresponding respective supplier catalog data;

adding the respective common format catalog data to a staging database;

enabling by the staging database a development environment in which the suppliers upload their respective data blocks into a supplier catalog and test its operation; and

in response to initiation of a syndication operation for syndicating data blocks into a supplier catalog;

transferring respective common format catalog data in the staging database to a live catalog database associated with the supplier catalog and accessible by purchaser users of the system;

activating at least part of the transferred common format catalog data as a live catalog; and

enabling a purchaser buyer from the purchasing organizations to select and purchase items provided by the plurality of suppliers from the live catalog, including presenting the live catalog via the electronic network to the purchaser buyer from the purchasing organizations.

2. The method of claim 1, further comprising associating the respective common format catalog data with the respective supplier catalog data.

3. The method of claim 2, wherein associating includes linking the respective supplier catalog data and the respective common format data, such that when the supplier catalog data received at the server changes, the common format catalog data updates accordingly.

4. The method of claim 1, wherein the electronic procurement system is a single instance multi-tenant system.

5. The method of claim 1, wherein the electronic procurement system is a web-based system.

6. The method of claim 1, wherein the server is located independently from suppliers and purchasers of the electronic procurement system.

7. The method of claim 1, wherein the server is located at a supplier of the electronic procurement system.

8. The method of claim 1, wherein the server is located at a purchaser of the electronic procurement system.

9. The method of claim 1, wherein the staging database forms a table in a larger electronic procurement system database.

10. The method of claim 1, wherein the staging database is a stand-alone database.

11. The method of claim 1, wherein the common format catalog data is a stockroom format.

12. The method of claim 1, wherein the supplier catalog data includes item data, standard attributes, and custom attributes.

13. The method of claim 1, wherein the supplier catalog data includes one or more of item name, description, size, weight, catalog number and color.

14. The method of claim 1, wherein the information linking respective the common format catalog data to the corresponding respective supplier catalog data includes a pointer with a respective supplier client, further including:

in accordance with new catalog data arrives from the respective supplier client, accessing the respective pointer to see which common format catalog data is associated with the respective supplier client, and updating the common format catalog data.

15. The method of claim 1, wherein in a bulk translation of the supplier catalog data, the supplier catalog data include substantially all of the supplier catalog data that are in the plurality of supplier catalog formats.

16. The method of claim 1, further includes:

when a supplier activates a new catalog on the electronic procurement system, performing a bulk translation of the supplier catalog data to the common catalog format catalog data.

17. The method of claim 1, wherein a subset of the supplier catalog data is formatted in one or more proprietary data formats associated with a respective supplier.

18. The method of claim 1, wherein a subset of the supplier catalog data is not compliant with the common format used by the electronic procurement system, further including:

correcting errors in the supplier catalog data to bring the subset of supplier catalog data into compliance with the catalog data common format.

19. A non-transitive computer-readable storage medium storing one or more programs for execution by one or more processors of a computer system, the one or more programs including instructions for:

at a server hosting an electronic procurement system that facilitates transactions among a plurality of purchasing organizations and a plurality of suppliers over an electronic network;

receiving over the electronic network supplier catalog data from the plurality of respective suppliers, where the supplier catalog data is in a plurality of formats;

obtaining from a business rules database business rules associated with the plurality of respective suppliers;

in accordance with the business rules, automatically converting the supplier catalog data from the respective plurality of formats to respective common format catalog data;

storing in the memory of the server information linking respective common format catalog data to corresponding respective supplier catalog data;

adding the respective common format catalog data to a staging database;

enabling by the staging database a development environment in which the suppliers upload their respective data blocks into a supplier catalog and test its operation; and

in response to initiation of a syndication operation for syndicating data blocks into a supplier catalog;

transferring respective common format catalog data in the staging database to a live catalog database associated with the supplier catalog and accessible by purchaser users of the system;

activating at least part of the transferred common format catalog data as a live catalog; and

enabling a purchaser buyer from the purchasing organizations to select and purchase items provided by the plurality of suppliers from the live catalog, including presenting the live catalog via the electronic network to the purchaser buyer from the purchasing organizations.

20. A server system, comprising:

one or more processors;

memory; and

one or more programs stored in the memory, the one or more programs comprising instructions to;

at a server hosting an electronic procurement system that facilitates transactions among a plurality of purchasing organizations and a plurality of suppliers over an electronic network;

receiving over the electronic network supplier catalog data from the plurality of respective suppliers, where the supplier catalog data is in a plurality of formats;

obtaining from a business rules database business rules associated with the plurality of respective suppliers;

in accordance with the business rules, automatically converting the supplier catalog data from the respective plurality of formats to respective common format catalog data;

storing in the memory of the server information linking respective common format catalog data to corresponding respective supplier catalog data;

adding the respective common format catalog data to a staging database;

enabling by the staging database a development environment in which the suppliers upload their respective data blocks into a supplier catalog and test its operation; and

in response to initiation of a syndication operation for syndicating data blocks into a supplier catalog;

transferring respective common format catalog data in the staging database to a live catalog database associated with the supplier catalog and accessible by purchaser users of the system;

activating at least part of the transferred common format catalog data as a live catalog; and

enabling a purchaser buyer from the purchasing organizations to select and purchase items provided by the plurality of suppliers from the live catalog, including presenting the live catalog via the electronic network to the purchaser buyer from the purchasing organizations.