Composing and cataloging item configuration data

• US 6,871,198 B2
• Filed: 12/21/2001
• Issued: 03/22/2005
• Est. Priority Date: 12/21/2001
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: Requisite Technology, Inc. (Huron Consulting Group Incorporated)
• Inventors: Neal, Michael Renn, Wilmsen, James Michael, Straub, Ian
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): Veillard, Jacques
• Application Number:
  US10/029,352
• Publication Number:
  US 20030149706A1
• Time in Patent Office: 1,187 Days
• Field of Search: 707/2, 707/3, 707/100, 707/200, 707/104.1, 707/10, 705/29, 705/80, 705/53, 710/38, 710/100, 709/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

An improvement for composing and cataloging item configuration data is disclosed. One embodiment of the invention includes identifying a base item, identifying a part number for the base item, breaking the part number into sections, each section corresponding to an attribute of the base item, and determining which of the part number sections relate to configurable attributes of the base item. The embodiment further includes listing a plurality of selectable part number section values for the configurable attributes, listing descriptive information for each of the selectable part number section values, linking the descriptive information to the corresponding selectable part number section value, generating a part number formula to define the configurable sections and associate configurable sections to the corresponding list of values, and generating a description formula to define a configurable description and associate descriptive information with corresponding configurable selectable part number values. The embodiment further includes adding the base item part number, values list, descriptive information list, part number formula and description formula to an electronic catalog.

Claims

1. A method for adding an item to an electronic catalog comprising:

identifying a base item;

identifying a part number for the base item;

Breaking the part number into sections, each section. Corresponding to an attribute of the base item;

determining which of the part number sections relate to configurable attributes of the base item;

listing a plurality of selectable part number section values for the configurable attributes;

listing descriptive information for each of the selectable part number section values;

linking the descriptive information to the corresponding selectable part number section value;

generating a part number formula to define the configurable sections and associate configurable sections to the corresponding list of values;

generating a description formula to define a configurable description and associate descriptive information with corresponding configurable selectable part number values;

and adding the base item part number, values list, descriptive information list, part number formula and description formula to an electronic catalog.

2. The method of claim 1, further comprising associating each configurable section with a searchable item attribute for items in the electronic catalog.

3. The method of claim 1, further comprising listing a price factor for each of the part number section values and adding the price factor list to the catalog.

4. The method of claim 1, wherein adding the item comprises adding the item to the catalog as the base item to the catalog and adding the configurable attributes as variations on the base item.

5. The method of claim 1, wherein adding the descriptive information to the respective attributes comprises adding all of the descriptive information to attributes of the base item so that the electronic catalog is searchable against all of the descriptions.

6. The method of claim 1, further comprising defining an item description after adding the item to the catalog, defining an item description comprising:

finding a base item;

for each configurable attribute, selecting a descriptive information for the configurable attribute to define a configuration of the item;

associating a part number section value for each selected descriptive information; and

combining the associated part number section values to define a part number for the selected configuration of the item.

7. A method of defining an item description using an electronic catalog comprising:

finding a base item in an electronic catalog;

retrieving from the electronic catalog a base part number for the base item, the base part number having configurable sections;

for each configurable section, retrieving from the electronic catalog a list of alternative descriptions for the configurable section;

selecting a description from the list of alternative descriptions for each configurable section to define a configuration of the item;

applying the selected descriptions to identify part number values for each configurable section corresponding to the selected descriptions;

applying the identified part number values to a part number formula to generate a part number for the defined item configuration; and

applying the selected descriptions to a description formula to generation a description for the defined item configuration.

8. The method of claim 7 further comprising retrieving a list of price factors for each configurable section, identifying a price factor for each configurable section corresponding to the selected descriptions and applying the identified price factors to a price formula to generate a price for the defined item configuration.

9. The method of claim 7 wherein retrieving a list of alternative descriptions comprises retrieving a list of alternative descriptions from among a plurality of different lists using a key identifying a type of list.

10. The method of claim 9 wherein the key indicates a preferred language for the alternative descriptions.

11. A method of transferring an item having multiple configurations to an electronic catalog, the method comprising:

maintaining an item in a first data format as a single item having at least one configurable attribute, the configurable attribute being associated with a plurality of alternative values, each value having a corresponding description, wherein the item is represented in the first data format as a matrix of alternative values and alternative descriptions corresponding to the respective values;

converting the item into a plurality of separate items in the first data format, each item corresponding to a different alternative value of the configurable attribute; and

loading the separate items into a catalog.

12. The method of claim 11, further comprising converting the plurality of items from the first data format to a second data format before loading the separate items.

13. The method of claim 11, wherein the matrix of values is expressed as text in a mark-up language.

14. The method of claim 11, wherein the plurality of different items comprises all possible configurations of the single item.

15. The method of claim 11, further comprising loading the alternative descriptions into a search index of the catalog.

16. The method of claim 11, wherein converting the item comprises applying a description formula to the descriptions to generate a description for each separate item.

17. The method of claim 11, wherein the first data format further comprises a plurality of alternative price factors, each corresponding to one of the alternative attribute values.

18. The method of claim 17, wherein converting the item comprises applying a price formula to the price factors to generate a price for each separate item.

19. The method of claim 11, wherein the first data format further comprises a plurality of alternative part number values, each corresponding to one of the alternative attribute values and wherein converting the item comprises applying a part number formula to the part number values to generate a part number for each separate item.

20. The method of claim 11, further comprising editing the item in the first data format before converting the item.

21. A method of defining an item description using an electronic catalog comprising:

finding a base item in an electronic catalog;

retrieving a base part number from the electronic catalog for the base item, the base part number having configurable sections;

for each configurable section, retrieving from the electronic catalog a list of alternative descriptions for the configurable section;

selecting a description from the lists of alternative descriptions for each configurable section to define a configuration of the item;

applying the selected descriptions to identify part number values for each configurable section corresponding to the selected descriptions;

applying the identified part number values to a part number formula to generate a part number for the defined item configuration; and

retrieving a list of price factors for each configurable section, identifying a price factor for each configurable section corresponding to the selected descriptions and applying the identified price factors to a price formula to generate a price for the defined item configuration.

22. The method of claim 21 further comprising applying the selected descriptions to a description formula to generate a description for the defined item configuration.

23. The method of claim 21 wherein retrieving a list of alternative descriptions comprises retrieving a list of alternative descriptions from among a plurality of different lists using a key identifying a type of list.

24. The method of claim 23 wherein the key indicates a preferred language for the alternative descriptions.

25. A method of transferring an item having multiple configurations to an electronic catalog, the method comprising:

maintaining an item in a first data format as a single item having at least one configurable attribute, the configurable attribute being associated with a plurality of alternative values, each value having a corresponding description;

converting the item into a plurality of separate items in the first data format by applying a description formula to the descriptions to generate a description for each separate item, each item corresponding to a different alternative value of the configurable attribute, wherein the first data format further comprises a plurality of alternative part number values, each corresponding to one of the alternative attribute values and wherein converting the item comprises applying a part number formula to the part number values to generate a part number for each separate item; and

loading the separate items into a catalog.

26. The method of claim 25, further comprising converting the plurality of items from the first data format to a second data format before loading the separate items.

27. The method of claim 26, wherein the matrix of values is expressed as text in a mark-up language.

28. The method of claim 25, wherein the item is represented in the first data format as a matrix of alternative values and alternative descriptions corresponding to the respective values.

29. The method of claim 25, wherein the plurality of different items comprises all possible configurations of the single item.

30. The method of claim 25, further comprising loading the alternative descriptions into a search index of the catalog.

31. The method of claim 25, wherein the first data converting further comprises a plurality of alternative price factors, each corresponding to one of the alternative attribute values.

32. The method of claim 30, wherein converting the item comprises applying a price formula to the price factors to generate a price for each separate item.

33. The method of claim 25, further comprising editing the item in the first data format before converting the item.

34. A machine-readable medium having stored thereon data representing instructions which, when executed by a machine, cause the machine to perform operations comprising:

identifying a base item;

identifying a part number for the base item;

breaking the part number into sections, each section corresponding to an attribute of the base item;

determining which of the part number sections relate to configurable attributes of the base item;

listing a plurality of selectable part number section values for the configurable attributes;

listing descriptive information for each of the selectable part number section values;

linking the descriptive information to the corresponding selectable part number section value;

generating a part number formula to define the configurable sections and associate configurable sections to the corresponding list of values;

generating a description formula to define a configurable description and associate descriptive information with corresponding configurable selectable part number values; and

adding the base item part number, values list, descriptive information list, part number formula and description formula to an electronic catalog.

35. The medium of claim 34, further comprising instructions which, when executed by the machine, cause the machine to perform further operations comprising associating each configurable section with a searchable item attribute for items in the electronic catalog.

36. The medium of claim 34, further comprising instructions which, when executed by the machine, cause the machine to perform further operations comprising listing a price factor for each of the part number section values and adding the price factor list to the catalog.

37. The medium of claim 34, further comprising instructions which, when executed by the machine, cause the machine to perform further operations comprising defining an item description after adding the item to the catalog, defining an item description comprising:

finding a base item;

for each configurable attribute, selecting a descriptive information for the configurable attribute to define a configuration of the item;

associating a part number section value for each selected descriptive information; and

combining the associated part number section values to define a part number for the selected configuration of the item.

38. A machine-readable medium having stored thereon data representing instructions which, when executed by a machine, cause the machine to perform operations comprising:

finding a base item in an electronic catalog;

retrieving a base part number from the electronic catalog for the base item, the base part number having configurable sections;

for each configurable section, retrieving from the electronic catalog a list of alternative descriptions for the configurable section;

selecting a description from the lists of alternative descriptions for each configurable section to define a configuration of the item;

applying the selected descriptions to identify part number values for each configurable section corresponding to the selected descriptions;

applying the identified part number values to a part number formula to generate a part number for the defined item configuration; and

applying the selected descriptions to a description formula to generate a description for the defined item configuration.

39. The medium of claim 38 further comprising instructions which, when executed by the machine, cause the machine to perform further operations comprising retrieving a list of price factors for each configurable section, identifying a price factor for each configurable section corresponding to the selected descriptions and applying the identified price factors to a price formula to generate a price for the defined item configuration.

40. A machine-readable medium having stored thereon data representing instructions which, when executed by a machine, cause the machine to perform operations comprising:

finding a base item in an electronic catalog;

retrieving a base part number from the electronic catalog for the base item, the base part number having configurable sections;

for each configurable section, retrieving from the electronic catalog a list of alternative descriptions for the configurable section;

selecting a description from the lists of alternative descriptions for each configurable section to define a configuration of the item;

applying the selected descriptions to identify part number values for each configurable section corresponding to the selected descriptions;

applying the identified part number values to a part number formula to generate a part number for the defined item configuration; and

retrieving a list of price factors for each configurable section, identifying a price factor for each configurable section corresponding to the selected descriptions and applying the identified price factors to a price formula to generate a price for the defined item configuration.

41. The medium of claim 40 further comprising instructions which, when executed by the machine, cause the machine to perform further operations comprising applying the selected descriptions to a description formula to generate a description for the defined item configuration.