CA2327076A1 - Enabling grouped purchases of goods and services - Google Patents
Enabling grouped purchases of goods and services Download PDFInfo
- Publication number
- CA2327076A1 CA2327076A1 CA002327076A CA2327076A CA2327076A1 CA 2327076 A1 CA2327076 A1 CA 2327076A1 CA 002327076 A CA002327076 A CA 002327076A CA 2327076 A CA2327076 A CA 2327076A CA 2327076 A1 CA2327076 A1 CA 2327076A1
- Authority
- CA
- Canada
- Prior art keywords
- product
- package
- attribute
- unresolved
- data correlated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
Abstract
An e-commerce system having a catalog database including package data correlated to at least one package; a selection module; and a resolution module. The catalog database preferably also includes item data correlated to a plurality of items, each of which is fully resolved; product data correlated to at least one product, wherein each product comprises at least one unresolved attribute;
and attribute data. An e-commerce method comprising the steps of creating a catalog database containing package data correlated to at least one package, each package having at least one unresolved package attribute; determining a selected package from the catalog database; and resolving the unresolved attributes.
and attribute data. An e-commerce method comprising the steps of creating a catalog database containing package data correlated to at least one package, each package having at least one unresolved package attribute; determining a selected package from the catalog database; and resolving the unresolved attributes.
Description
E-COMMERCE PACKAGES
FIELD OF THE INVENTION
This invention relates to the field of e-commerce, and in particular, to the purchasing of packages of items.
BACKGROUND OF THE INVENTION
In the world of e-commerce, customers can purchase merchandise and services online from electronic catalogs, typically through websites on the Internet.
Such purchases typically involve the consumer browsing or searching through an electronic catalog and selecting merchandise or services the consumer wishes to purchase.
However, the applicants have recognized that there may be promotional and other advantages to be gained if merchandise and/or services could be grouped together. From the consumer's perspective, group purchases may involve price discounts or other incentives for volume purchases as well as making purchasing decisions easier. From the merchant's perspective, grouping merchandise together may result in increased sales volumes, and may assist in promoting new or low volume products with more popular, high volume products.
There is accordingly a need for a system and methodology for enabling the e-commerce purchasing of grouped merchandise and/or services.
SUMMARY OF THE INVENTION
The present invention is directed towards a system for enabling the e-commerce purchasing of grouped merchandise and/or services.
The subject e-commerce system comprises a catalog database comprising package data correlated to at least one package; a selection module; and a resolution module. Preferably, the catalog database further comprises item data correlated to a plurality of items, wherein each item is fully resolved; product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute; and attribute data.
The subject invention is also directed towards an e-commerce method comprising the steps of creating a catalog database comprising package data correlated to at least one package, wherein said at least one package comprises at least one unresolved attribute;
determining a selected package from the catalog database; and resolving said at least one unresolved attribute. Preferably the step of resolving the unresolved attribute involves determining a selected attribute value for said at least one unresolved attribute.
It will be appreciated by those skilled in the art that the invention herein can be implemented in a computer program which can be stored in storage or transmitted as a signal, such as on a modulated carrier signal for use in a computer system, or on a network such as the Internet for use in a computer system.
BRIEF DESCRIPTION OF THE DRAWINGS
The present invention will now be described, by way of example only, with reference to the following drawings, in which like reference numerals refer to like parts and in which:
Figure 1 is a schematic diagram of an e-commerce system made in accordance with the present invention.
Figures 2A-2F together comprise various database tables of the catalog database of Figure Figures 3A-3C together comprise a flow chart showing an e-commerce method employed using the e-commerce system of the present invention.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
Refernng to Figure 1, illustrated therein is a preferred embodiment of the e-commerce system of the subject invention. The system, shown generally as 10, comprises a catalog subsystem 12, an ordering and payment module 14 and a delivery subsystem 16. The catalog subsystem 12 in turn comprises a display module 18, a selection module 19, a resolution module 20, and a catalog database 22.
The e-commerce system 10 is connected to a global communications network 24, typically the Internet. Consumers 26 are able to access the system 10 to purchase merchandise and services using remote computers, in most instances running web browsers 28, as will be understood.
The system 10 will typically be implemented as a catalog website running on a website server connected to (and having a uniform resource locator or URL on) the Internet 24. As will be discussed in greater detail below, the catalog database 22 contains data correlated to the various merchandise and/or services available for purchase by the consumer 26. The catalog data may also contain image, sound or other non-textual data corresponding to each piece of merchandise and service offered for sale. In a known manner, the display module 18 generates and displays (typically on the consumer's 26 web browser 28 operating on a remote computer) web pages containing images of the merchandise and services as well as related marketing details such as pricing, sizes and colours, through which the consumer can browse before making a decision to purchase.
The payment module 14 coordinates the online payment of purchases, typically through the use of credit card numbers. The delivery subsystem 16 coordinates the shipping of purchases to the customer 26.
Referring simultaneously to Figures 2A through 2F, illustrated therein are various databases of information stored within the catalog database 22. Typically catalog database 22 will include a catalog entry table 500, a product attribute table 502, a product attribute value table 504, a package attribute table 506, a package attribute value table 508 and a package relationship table 510.
The catalog entry table 500 contains data correlated to products 520, items 522 and packages 524. The packages data 524 includes unresolved packages 526 and fully resolved packages 528, as will be explained in greater detail below.
The sample data contained in the tables 500, 502, 504, 506, 508, 510 has been included for illustrative purposes and references gloves and sweater merchandise. In the sample data, the gloves may be purchased in two materials, leather and vinyl. As well, the sweaters in the example are available in two colours, blue and green, and also come in two sizes, small and large. These options with respect to the sweaters and gloves are referred to throughout herein as attributes. In the example provided, sweaters have two attributes, size and colour, while gloves have a single attribute, material.
When used herein, the term "product" is intended to mean a piece of merchandise or a service which has at least one unresolved attribute. Correspondingly, when used herein, the term "item" is intended to mean a piece of merchandise or a service with no unresolved attributes. Thus, in the provided example, sweaters and gloves (with no additional information) are products 520, since the attributes of size, colour and/or material are unresolved, meaning that they are unspecified or undefined. On the other hand, a large blue sweater is an item 522 as is a pair of leather gloves, because all of their respective attributes have been specified.
As should be understood, while the items 522 in the example provided all correlate to the products 520, in the sense that they are fully resolved versions of the products 520 (sweaters and gloves), it is not necessary that all items 522 correlate to a product 520. As will be understood, some items 522 may not have attributes which are resolved, and hence will not have a correlated product 520.
The example provided also illustrates packages 524. Packages 524 are created by grouping merchandise and/or services for sale all together. Unresolved packages 526 include at least one product 520; accordingly, each unresolved package 526 requires the resolution of at least one attribute. Unresolved packages 526 may include products 520, items 522, and even other packages 524. Resolved packages 528 contain only items 522.
Referring to Figure 2A, as noted previously, the catalog entry table 500 contains data correlated to the merchandise and services offered for sale. This data is generally organized into fields in the database, for each entry: catalog entry identifier 550, catalog entry type 552, catalog entry description 554 and stock keeping unit ("SKU") identifier 556.
As shown in Figure 2B, the product attribute table 502 contains data correlated to each of the various types of attributes of the various products 520 available for purchase. The product attribute table 502 includes an attribute identification field 560, an attribute name field 562 and a product identification field 564. Every type of attribute is provided with a unique attribute name or type descriptor 562. In the example provided, the descriptors 562 indicate that there are three different attributes, two for sweaters (size and colour) and one for gloves (material).
Each of these attributes is provided with a unique attribute identifier 560, and each attribute is linked to a product 520 in the catalog entry table 500 through a product identifier 564 correlated to the catalog entry identifier 550.
Referring now to Figure 2C, the product attribute value table 504 contains data correlated to the specific values for each of the various types of attributes 562 of the various products 520 available for purchase. The product attribute value table 504 includes an attribute value identification field 570, an attribute identification field 572, an attribute value field 574, and an item identification field 576. As can be seen in the sample data provided, six different attribute values 574 are provided, small, large, blue, green, vinyl and leather. Each value 574 is linked to an item 522 in the catalog entry table 500 through an item identifier 576 correlated to the catalog entry identifier 550. As well, each value 574 is cross-referenced to its attribute type 562, through an attribute identifier 572 correlated to the attribute identifier 560 in the product attribute table 502.
As a result, the product attribute value table 504 identifies the value 574 and attribute type 562 of all of the attributes possessed by each item 522.
As shown in Figure 2D, the package attribute table 506 contains data correlated to each of the types of attributes of the various unresolved packages 526 available for purchase. The package attribute table 506 includes a package attribute identification field 580, an attribute identification field 582 and an unresolved package identification field 584. As noted, unresolved packages 526 contain at least one product 520 and accordingly, each unresolved package 526 requires the resolution of at least one product attribute 562. Every type of product attribute 562 required to resolve the unresolved packages 526 is provided with a unique package attribute identifier 580, linked to a product attribute identifier 560 in the product attribute table 502 through an attribute identifier 582 correlated to the attribute identifier 560. Each of these attributes 562 is also linked to an unresolved package 526 in the catalog entry table 500 through an unresolved package identifier 584 correlated to the catalog entry identifier 550.
Referring now to Figure 2E, the package attribute value table 508 serves to indirectly cross-reference each of the various resolved packages 528 available for purchase with the specific attribute values 574 of its component products) 520. The package attribute value table 508 includes a package attribute identification field 590, an attribute value identification field 592, and a fully resolved package identification field 594. Each resolved package 528 has an entry in the table 508 for each of its attribute values 574. Each entry is linked to a specific resolved package 528 in the catalog entry table 500 through a fully resolved package identifier 594 correlated to the catalog entry identifier 550. As well, each fully resolved package identifier 594 is cross-referenced to its component product 520 attribute values 574, through an attribute value identifier 592 correlated to the attribute value identifier 570 in the product attribute value table 504.
Each entry in the table 508 is provided with a package attribute identifier 590 correlated to the package attribute identifier 580 in the package attribute table 506.
As shown in Figure 2F, the package relationship table 510 provides data correlating each package 524 with its constituent components of products 520 and/or items 522.
The table 510 includes a package identification field 600, a component identification field 602 and a package type field 604. Each package 524 has an entry in the table 510 for each of its components. Each entry is linked to a specific package 524 in the catalog entry table 500 through a package identifier 600 correlated to the corresponding catalog entry identifier 550. As well, each package identifier 600 is cross-referenced to its product 520 and/or item 522 components, through a component identifier 602 correlated to the corresponding catalog entry identifier 550 in the catalog entry table 500. Each entry is also provided with a package type indicator 604 containing data indicating whether the package identifier 600 corresponds to an unresolved package or a fully resolved package.
Figures 3A-3C together illustrate the steps of the method 700 carned out by the system 10 made in accordance with the subject invention.
Once the customer 26 has accessed the catalog subsystem 12, typically using a web browser connected to the Internet 24, the customer 26 is able to browse through the various merchandise and services offered for sale, as contained in the catalog entry table 500. (Block 702) Preferably, only unresolved packages 526 available for purchase (in addition to products 520 and items 522) will be presented to the customer 26. In this regard, typically the display module 18 will display a photograph of one fully resolved package 528 correlated to the unresolved package 526 as a sample of the various resolved packages 528 or options available (again correlated to the unresolved package 526), as well as the relevant pricing and other marketing information contained in the relevant description field 554 for the unresolved package 526.
Typically, the catalog entry table 500 will also include a link between entries in the table 500 and photographic images to be displayed to the consumer 26. (Block 704) Once a customer 26 selects a catalog entry for purchase through the selection module 19 (typically by triggering a "button" displayed by the display module 18 near an image or other identifier of the desired merchandise or services or by activating a link, as will be understood), the selection module 19 determines the catalog entry identifier 550 correlated to the catalog entry selected by the customer 26. (Block 706) The catalog subsystem 12 then determines what the type of the selection is, by looking up the type 552 correlated to the selected catalog entry identifier 550. If the type 552 of the selection indicates that it is an item 522 (Block 708), the catalog subsystem 12 will simply add the selected item 522 to the customer's 26 shopping cart, as will be understood (Block 710). The consumer 26 can then continue browsing through the electronic catalog at Block 704.
If the type 552 of the selection indicates that it is a product 520 (Block 712), the catalog subsystem 12 requires the customer to designate the desired attribute values for the product 520, and ensures that the product 520 is fully resolved into an item 522, in a manner similar to that described in relation to Blocks 716 - 718, as discussed below (Block 713). The consumer 26 can then continue browsing through the electronic catalog at Block 704.
If the type 552 of the selection indicates that it is an unresolved package 526 (Block 714), the resolution module 20 then determines the products 520 possessed by the selected unresolved package 526, by matching the selected catalog entry identifier 550 with package identifiers 600, stored in the package relationship table 510. (Otherwise, if the selection is of a type other than item, product or package, the selection is processed accordingly (Block 717).) In the sample data provided, for explanatory purposes, it will be assumed that the unresolved package 526 selected by the customer 26 has "150" as its catalog entry identifier 550. It should be understood that while the sample data only contains one unresolved package 526, typically the catalog database 22 will contain data correlated to numerous unresolved packages 526. In the sample provided, the data contained in the package relationship table S 10 indicates that the selected package 526 contains two products 520, having component identifiers 602 "101" and "102", respectively (which correlate to products 520 having matching catalog entry identifiers 550, ie. the sweater and the gloves). (Block 71 S) For each product 520 contained in the selected package 526 (which will be referred to as a "selected product" 520), the resolution module 20 then determines the attribute types 562 possessed by the selected product 520 (which will be referred to as "selected attribute types" 562), by matching the catalog entry identifiers 550 of the selected product 520 with product identifiers 564, stored in the product attribute table 502. In the example provided, the resolution module 20 "determines" that the selected sweater product 520 has two unresolved selected attribute types 562 (sweater-size and sweater-colour) and that the selected gloves product 520 has one unresolved selected attribute type 562 (gloves-material) that must be resolved in order to complete the purchase.
(Block 716) As will be understood, for each such selected attribute 562 (and correlated attribute identifier 560) for each selected product 520, the resolution module 20 requires the customer 26 to select attribute values for the selected product 520. The resolution module 20 ensures that the customer 26 has selected attribute values 574 found in the attribute value field 574 of the product attribute value table 504 having an attribute identifier 572 matching that of the selected attribute identifier 560. The corresponding selected item identifier 576 (which corresponds to the related catalog entry identifier 550) is then determined. If the item identifiers 576 for all of the selected attribute values 574 for a selected product 520 do not match, or if an acceptable attribute value 574 cannot be located in the table 504, the resolution module 20 will direct the consumer 26 to either specify acceptable attribute values 574 or will reject the selection of the product 526. (Block 718) Once the selected catalog entry identifiers 550 have been determined for the selected products 520, the resolution module 20 then matches the selected catalog entry identifiers 550 with the component identifiers 604 ("selected component identifiers") in the package relationship table 510. If a package identifier 600 can be located in the relationship table 604 which correlates to all of the selected component identifiers 604, the catalog entry identifier 550 matching the selected package identifier 600 is then added to the customer's 26 shopping cart, as will be understood. If such an acceptable package identifier 600 cannot be located in the table 510, the resolution module 20 will direct the consumer 26 to either redesignate acceptable attribute values 574 or will reject the selection of the unresolved package 526. (Block 720) Once the customer 26 has completed deciding which merchandise and services to purchase (Block 721), the selected catalog entry identifier 550 (for the selected fully resolved package 528 and any other selections in the shopping cart) and related pricing information is used by the ordering subsystem 14 to arrange for the payment of the purchases) (typically by credit card) by the customer 26 in a known manner. (Block 722) As well, the SKU data 556 correlated to the selected catalog entry identifier 550 is forwarded to the fulfilment division 16 (typically a warehouse), where the contents of the selected package 528 are assembled and then shipped to the consumer 26. (Block 724) While the sample data provided in Figures 2A-2F identifies a fully resolved package 528 corresponding to each possible combination of attribute values 574 for each component product 520, it should be understood that in some instances, a fully resolved package 528 may not be available having certain attributes. One possible reason for such a situation may be for promotional advantage - even though a product having certain fully resolved attribute values (ie. a corresponding item 522) may be available for purchase individually, those specific attributes may not be available in a similar product available for purchase in a package. For example, while green and blue sweaters may be selling poorly individually (at the same time as red sweaters are generating significant sales), a gloves and sweater package may be created in which only blue and green sweaters are available for purchase in the package.
As should be understood, the use of packages provides the advantage that a package is treated as a single atomic unit, for which a single price can be charged. Once a package has been selected by a consumer 26, only the fully resolved package (and not its constituent item components) is added to his or her "shopping cart" (as will be understood). As a result, the constituent components cannot be modified. The consumer 26 can choose to increase the number of packages to be purchased, or can remove the package from the order.
Thus, while what is shown and described herein constitute preferred embodiments of the subj ect invention, it should be understood that various changes can be made without departing from the subject invention, the scope of which is defined in the appended claims.
FIELD OF THE INVENTION
This invention relates to the field of e-commerce, and in particular, to the purchasing of packages of items.
BACKGROUND OF THE INVENTION
In the world of e-commerce, customers can purchase merchandise and services online from electronic catalogs, typically through websites on the Internet.
Such purchases typically involve the consumer browsing or searching through an electronic catalog and selecting merchandise or services the consumer wishes to purchase.
However, the applicants have recognized that there may be promotional and other advantages to be gained if merchandise and/or services could be grouped together. From the consumer's perspective, group purchases may involve price discounts or other incentives for volume purchases as well as making purchasing decisions easier. From the merchant's perspective, grouping merchandise together may result in increased sales volumes, and may assist in promoting new or low volume products with more popular, high volume products.
There is accordingly a need for a system and methodology for enabling the e-commerce purchasing of grouped merchandise and/or services.
SUMMARY OF THE INVENTION
The present invention is directed towards a system for enabling the e-commerce purchasing of grouped merchandise and/or services.
The subject e-commerce system comprises a catalog database comprising package data correlated to at least one package; a selection module; and a resolution module. Preferably, the catalog database further comprises item data correlated to a plurality of items, wherein each item is fully resolved; product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute; and attribute data.
The subject invention is also directed towards an e-commerce method comprising the steps of creating a catalog database comprising package data correlated to at least one package, wherein said at least one package comprises at least one unresolved attribute;
determining a selected package from the catalog database; and resolving said at least one unresolved attribute. Preferably the step of resolving the unresolved attribute involves determining a selected attribute value for said at least one unresolved attribute.
It will be appreciated by those skilled in the art that the invention herein can be implemented in a computer program which can be stored in storage or transmitted as a signal, such as on a modulated carrier signal for use in a computer system, or on a network such as the Internet for use in a computer system.
BRIEF DESCRIPTION OF THE DRAWINGS
The present invention will now be described, by way of example only, with reference to the following drawings, in which like reference numerals refer to like parts and in which:
Figure 1 is a schematic diagram of an e-commerce system made in accordance with the present invention.
Figures 2A-2F together comprise various database tables of the catalog database of Figure Figures 3A-3C together comprise a flow chart showing an e-commerce method employed using the e-commerce system of the present invention.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
Refernng to Figure 1, illustrated therein is a preferred embodiment of the e-commerce system of the subject invention. The system, shown generally as 10, comprises a catalog subsystem 12, an ordering and payment module 14 and a delivery subsystem 16. The catalog subsystem 12 in turn comprises a display module 18, a selection module 19, a resolution module 20, and a catalog database 22.
The e-commerce system 10 is connected to a global communications network 24, typically the Internet. Consumers 26 are able to access the system 10 to purchase merchandise and services using remote computers, in most instances running web browsers 28, as will be understood.
The system 10 will typically be implemented as a catalog website running on a website server connected to (and having a uniform resource locator or URL on) the Internet 24. As will be discussed in greater detail below, the catalog database 22 contains data correlated to the various merchandise and/or services available for purchase by the consumer 26. The catalog data may also contain image, sound or other non-textual data corresponding to each piece of merchandise and service offered for sale. In a known manner, the display module 18 generates and displays (typically on the consumer's 26 web browser 28 operating on a remote computer) web pages containing images of the merchandise and services as well as related marketing details such as pricing, sizes and colours, through which the consumer can browse before making a decision to purchase.
The payment module 14 coordinates the online payment of purchases, typically through the use of credit card numbers. The delivery subsystem 16 coordinates the shipping of purchases to the customer 26.
Referring simultaneously to Figures 2A through 2F, illustrated therein are various databases of information stored within the catalog database 22. Typically catalog database 22 will include a catalog entry table 500, a product attribute table 502, a product attribute value table 504, a package attribute table 506, a package attribute value table 508 and a package relationship table 510.
The catalog entry table 500 contains data correlated to products 520, items 522 and packages 524. The packages data 524 includes unresolved packages 526 and fully resolved packages 528, as will be explained in greater detail below.
The sample data contained in the tables 500, 502, 504, 506, 508, 510 has been included for illustrative purposes and references gloves and sweater merchandise. In the sample data, the gloves may be purchased in two materials, leather and vinyl. As well, the sweaters in the example are available in two colours, blue and green, and also come in two sizes, small and large. These options with respect to the sweaters and gloves are referred to throughout herein as attributes. In the example provided, sweaters have two attributes, size and colour, while gloves have a single attribute, material.
When used herein, the term "product" is intended to mean a piece of merchandise or a service which has at least one unresolved attribute. Correspondingly, when used herein, the term "item" is intended to mean a piece of merchandise or a service with no unresolved attributes. Thus, in the provided example, sweaters and gloves (with no additional information) are products 520, since the attributes of size, colour and/or material are unresolved, meaning that they are unspecified or undefined. On the other hand, a large blue sweater is an item 522 as is a pair of leather gloves, because all of their respective attributes have been specified.
As should be understood, while the items 522 in the example provided all correlate to the products 520, in the sense that they are fully resolved versions of the products 520 (sweaters and gloves), it is not necessary that all items 522 correlate to a product 520. As will be understood, some items 522 may not have attributes which are resolved, and hence will not have a correlated product 520.
The example provided also illustrates packages 524. Packages 524 are created by grouping merchandise and/or services for sale all together. Unresolved packages 526 include at least one product 520; accordingly, each unresolved package 526 requires the resolution of at least one attribute. Unresolved packages 526 may include products 520, items 522, and even other packages 524. Resolved packages 528 contain only items 522.
Referring to Figure 2A, as noted previously, the catalog entry table 500 contains data correlated to the merchandise and services offered for sale. This data is generally organized into fields in the database, for each entry: catalog entry identifier 550, catalog entry type 552, catalog entry description 554 and stock keeping unit ("SKU") identifier 556.
As shown in Figure 2B, the product attribute table 502 contains data correlated to each of the various types of attributes of the various products 520 available for purchase. The product attribute table 502 includes an attribute identification field 560, an attribute name field 562 and a product identification field 564. Every type of attribute is provided with a unique attribute name or type descriptor 562. In the example provided, the descriptors 562 indicate that there are three different attributes, two for sweaters (size and colour) and one for gloves (material).
Each of these attributes is provided with a unique attribute identifier 560, and each attribute is linked to a product 520 in the catalog entry table 500 through a product identifier 564 correlated to the catalog entry identifier 550.
Referring now to Figure 2C, the product attribute value table 504 contains data correlated to the specific values for each of the various types of attributes 562 of the various products 520 available for purchase. The product attribute value table 504 includes an attribute value identification field 570, an attribute identification field 572, an attribute value field 574, and an item identification field 576. As can be seen in the sample data provided, six different attribute values 574 are provided, small, large, blue, green, vinyl and leather. Each value 574 is linked to an item 522 in the catalog entry table 500 through an item identifier 576 correlated to the catalog entry identifier 550. As well, each value 574 is cross-referenced to its attribute type 562, through an attribute identifier 572 correlated to the attribute identifier 560 in the product attribute table 502.
As a result, the product attribute value table 504 identifies the value 574 and attribute type 562 of all of the attributes possessed by each item 522.
As shown in Figure 2D, the package attribute table 506 contains data correlated to each of the types of attributes of the various unresolved packages 526 available for purchase. The package attribute table 506 includes a package attribute identification field 580, an attribute identification field 582 and an unresolved package identification field 584. As noted, unresolved packages 526 contain at least one product 520 and accordingly, each unresolved package 526 requires the resolution of at least one product attribute 562. Every type of product attribute 562 required to resolve the unresolved packages 526 is provided with a unique package attribute identifier 580, linked to a product attribute identifier 560 in the product attribute table 502 through an attribute identifier 582 correlated to the attribute identifier 560. Each of these attributes 562 is also linked to an unresolved package 526 in the catalog entry table 500 through an unresolved package identifier 584 correlated to the catalog entry identifier 550.
Referring now to Figure 2E, the package attribute value table 508 serves to indirectly cross-reference each of the various resolved packages 528 available for purchase with the specific attribute values 574 of its component products) 520. The package attribute value table 508 includes a package attribute identification field 590, an attribute value identification field 592, and a fully resolved package identification field 594. Each resolved package 528 has an entry in the table 508 for each of its attribute values 574. Each entry is linked to a specific resolved package 528 in the catalog entry table 500 through a fully resolved package identifier 594 correlated to the catalog entry identifier 550. As well, each fully resolved package identifier 594 is cross-referenced to its component product 520 attribute values 574, through an attribute value identifier 592 correlated to the attribute value identifier 570 in the product attribute value table 504.
Each entry in the table 508 is provided with a package attribute identifier 590 correlated to the package attribute identifier 580 in the package attribute table 506.
As shown in Figure 2F, the package relationship table 510 provides data correlating each package 524 with its constituent components of products 520 and/or items 522.
The table 510 includes a package identification field 600, a component identification field 602 and a package type field 604. Each package 524 has an entry in the table 510 for each of its components. Each entry is linked to a specific package 524 in the catalog entry table 500 through a package identifier 600 correlated to the corresponding catalog entry identifier 550. As well, each package identifier 600 is cross-referenced to its product 520 and/or item 522 components, through a component identifier 602 correlated to the corresponding catalog entry identifier 550 in the catalog entry table 500. Each entry is also provided with a package type indicator 604 containing data indicating whether the package identifier 600 corresponds to an unresolved package or a fully resolved package.
Figures 3A-3C together illustrate the steps of the method 700 carned out by the system 10 made in accordance with the subject invention.
Once the customer 26 has accessed the catalog subsystem 12, typically using a web browser connected to the Internet 24, the customer 26 is able to browse through the various merchandise and services offered for sale, as contained in the catalog entry table 500. (Block 702) Preferably, only unresolved packages 526 available for purchase (in addition to products 520 and items 522) will be presented to the customer 26. In this regard, typically the display module 18 will display a photograph of one fully resolved package 528 correlated to the unresolved package 526 as a sample of the various resolved packages 528 or options available (again correlated to the unresolved package 526), as well as the relevant pricing and other marketing information contained in the relevant description field 554 for the unresolved package 526.
Typically, the catalog entry table 500 will also include a link between entries in the table 500 and photographic images to be displayed to the consumer 26. (Block 704) Once a customer 26 selects a catalog entry for purchase through the selection module 19 (typically by triggering a "button" displayed by the display module 18 near an image or other identifier of the desired merchandise or services or by activating a link, as will be understood), the selection module 19 determines the catalog entry identifier 550 correlated to the catalog entry selected by the customer 26. (Block 706) The catalog subsystem 12 then determines what the type of the selection is, by looking up the type 552 correlated to the selected catalog entry identifier 550. If the type 552 of the selection indicates that it is an item 522 (Block 708), the catalog subsystem 12 will simply add the selected item 522 to the customer's 26 shopping cart, as will be understood (Block 710). The consumer 26 can then continue browsing through the electronic catalog at Block 704.
If the type 552 of the selection indicates that it is a product 520 (Block 712), the catalog subsystem 12 requires the customer to designate the desired attribute values for the product 520, and ensures that the product 520 is fully resolved into an item 522, in a manner similar to that described in relation to Blocks 716 - 718, as discussed below (Block 713). The consumer 26 can then continue browsing through the electronic catalog at Block 704.
If the type 552 of the selection indicates that it is an unresolved package 526 (Block 714), the resolution module 20 then determines the products 520 possessed by the selected unresolved package 526, by matching the selected catalog entry identifier 550 with package identifiers 600, stored in the package relationship table 510. (Otherwise, if the selection is of a type other than item, product or package, the selection is processed accordingly (Block 717).) In the sample data provided, for explanatory purposes, it will be assumed that the unresolved package 526 selected by the customer 26 has "150" as its catalog entry identifier 550. It should be understood that while the sample data only contains one unresolved package 526, typically the catalog database 22 will contain data correlated to numerous unresolved packages 526. In the sample provided, the data contained in the package relationship table S 10 indicates that the selected package 526 contains two products 520, having component identifiers 602 "101" and "102", respectively (which correlate to products 520 having matching catalog entry identifiers 550, ie. the sweater and the gloves). (Block 71 S) For each product 520 contained in the selected package 526 (which will be referred to as a "selected product" 520), the resolution module 20 then determines the attribute types 562 possessed by the selected product 520 (which will be referred to as "selected attribute types" 562), by matching the catalog entry identifiers 550 of the selected product 520 with product identifiers 564, stored in the product attribute table 502. In the example provided, the resolution module 20 "determines" that the selected sweater product 520 has two unresolved selected attribute types 562 (sweater-size and sweater-colour) and that the selected gloves product 520 has one unresolved selected attribute type 562 (gloves-material) that must be resolved in order to complete the purchase.
(Block 716) As will be understood, for each such selected attribute 562 (and correlated attribute identifier 560) for each selected product 520, the resolution module 20 requires the customer 26 to select attribute values for the selected product 520. The resolution module 20 ensures that the customer 26 has selected attribute values 574 found in the attribute value field 574 of the product attribute value table 504 having an attribute identifier 572 matching that of the selected attribute identifier 560. The corresponding selected item identifier 576 (which corresponds to the related catalog entry identifier 550) is then determined. If the item identifiers 576 for all of the selected attribute values 574 for a selected product 520 do not match, or if an acceptable attribute value 574 cannot be located in the table 504, the resolution module 20 will direct the consumer 26 to either specify acceptable attribute values 574 or will reject the selection of the product 526. (Block 718) Once the selected catalog entry identifiers 550 have been determined for the selected products 520, the resolution module 20 then matches the selected catalog entry identifiers 550 with the component identifiers 604 ("selected component identifiers") in the package relationship table 510. If a package identifier 600 can be located in the relationship table 604 which correlates to all of the selected component identifiers 604, the catalog entry identifier 550 matching the selected package identifier 600 is then added to the customer's 26 shopping cart, as will be understood. If such an acceptable package identifier 600 cannot be located in the table 510, the resolution module 20 will direct the consumer 26 to either redesignate acceptable attribute values 574 or will reject the selection of the unresolved package 526. (Block 720) Once the customer 26 has completed deciding which merchandise and services to purchase (Block 721), the selected catalog entry identifier 550 (for the selected fully resolved package 528 and any other selections in the shopping cart) and related pricing information is used by the ordering subsystem 14 to arrange for the payment of the purchases) (typically by credit card) by the customer 26 in a known manner. (Block 722) As well, the SKU data 556 correlated to the selected catalog entry identifier 550 is forwarded to the fulfilment division 16 (typically a warehouse), where the contents of the selected package 528 are assembled and then shipped to the consumer 26. (Block 724) While the sample data provided in Figures 2A-2F identifies a fully resolved package 528 corresponding to each possible combination of attribute values 574 for each component product 520, it should be understood that in some instances, a fully resolved package 528 may not be available having certain attributes. One possible reason for such a situation may be for promotional advantage - even though a product having certain fully resolved attribute values (ie. a corresponding item 522) may be available for purchase individually, those specific attributes may not be available in a similar product available for purchase in a package. For example, while green and blue sweaters may be selling poorly individually (at the same time as red sweaters are generating significant sales), a gloves and sweater package may be created in which only blue and green sweaters are available for purchase in the package.
As should be understood, the use of packages provides the advantage that a package is treated as a single atomic unit, for which a single price can be charged. Once a package has been selected by a consumer 26, only the fully resolved package (and not its constituent item components) is added to his or her "shopping cart" (as will be understood). As a result, the constituent components cannot be modified. The consumer 26 can choose to increase the number of packages to be purchased, or can remove the package from the order.
Thus, while what is shown and described herein constitute preferred embodiments of the subj ect invention, it should be understood that various changes can be made without departing from the subject invention, the scope of which is defined in the appended claims.
Claims (22)
1. An e-commerce system comprising:
(a) a catalog database comprising package data correlated to at least one package;
(b) a selection module; and (c) a resolution module.
(a) a catalog database comprising package data correlated to at least one package;
(b) a selection module; and (c) a resolution module.
2. The system of claim 1 wherein the catalog database further comprises:
(d) item data correlated to a plurality of items, wherein each item is fully resolved;
(e) product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute type; and (f) attribute data.
(d) item data correlated to a plurality of items, wherein each item is fully resolved;
(e) product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute type; and (f) attribute data.
3. The system of claim 1, wherein the catalog database further comprises image data correlated to the at least one package.
4. The system of claim 1, further comprising a connection to a global communications network.
5. The system of claim 4, wherein the global communications network comprises the Internet.
6. The system of claim 1, further comprising an ordering module.
7. The system of claim 6, further comprising a payment module.
8. The system of claim 6, further comprising a delivery subsystem.
9. An e-commerce method comprising the steps of:
(a) providing a catalog database comprising package data correlated to at least one package, wherein said at least one package comprises at least one unresolved attribute;
(b) providing means for enabling a customer to determine a selected package from the catalog database; and (c) resolving said at least one unresolved attribute.
(a) providing a catalog database comprising package data correlated to at least one package, wherein said at least one package comprises at least one unresolved attribute;
(b) providing means for enabling a customer to determine a selected package from the catalog database; and (c) resolving said at least one unresolved attribute.
10. The method as claimed in claim 9, wherein the catalog database further comprises product data correlated to at least one product, wherein said at least one product includes at least one unresolved attribute and wherein said at least one package includes at least one component product.
11. The method as claimed in claim 10, wherein step (c) comprises determining all component products included in the selected package.
12. The method as claimed in claim 11, wherein step (c) further comprises determining all attributes included in each component product.
13. The method as claimed in claim 9, wherein step (c) comprises determining a selected attribute value for said at least one unresolved attribute.
14. A program product stored on a computer readable medium, the program product comprising:
(a) a catalog database comprising package data correlated to at least one package;
(b) a selection module; and (c) a resolution module.
(a) a catalog database comprising package data correlated to at least one package;
(b) a selection module; and (c) a resolution module.
15. The program product of claim 14, wherein the catalog database further comprises:
(a) item data correlated to a plurality of items, wherein each item is fully resolved;
(b) product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute type; and (c) attribute data.
(a) item data correlated to a plurality of items, wherein each item is fully resolved;
(b) product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute type; and (c) attribute data.
16. A software product comprising:
(a) catalog database comprising package data correlated to at least one package;
(b) a selection module; and (c) a resolution module.
(a) catalog database comprising package data correlated to at least one package;
(b) a selection module; and (c) a resolution module.
17. The software product of claim 16 wherein the catalog database further comprises:
(a) item data correlated to a plurality of items, wherein each item is fully resolved;
(b) product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute type; and (c) attribute data.
(a) item data correlated to a plurality of items, wherein each item is fully resolved;
(b) product data correlated to at least one product, wherein said at least one product comprises at least one unresolved attribute type; and (c) attribute data.
18. A computer program product comprising:
(a) a computer-readable signal-baring medium;
(b) means in said medium for accomplishing the method of any of claims 9 to 13.
(a) a computer-readable signal-baring medium;
(b) means in said medium for accomplishing the method of any of claims 9 to 13.
19. The product of claim 18 wherein said medium is a recordable data storage medium.
20. The product of claim 18 wherein said medium is a modulated carrier signal.
21. The product of claim 20 wherein said signal is a transmission over a network.
22. The product of claim 21 wherein said network is the Internet.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2327076A CA2327076C (en) | 2000-11-30 | 2000-11-30 | Enabling grouped purchases of goods and services |
| US09/943,061 US7756875B2 (en) | 2000-11-30 | 2001-08-30 | Method and system for e-commerce packages |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2327076A CA2327076C (en) | 2000-11-30 | 2000-11-30 | Enabling grouped purchases of goods and services |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2327076A1 true CA2327076A1 (en) | 2002-05-30 |
| CA2327076C CA2327076C (en) | 2016-02-09 |
Family
ID=4167767
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2327076A Expired - Fee Related CA2327076C (en) | 2000-11-30 | 2000-11-30 | Enabling grouped purchases of goods and services |
Country Status (2)
| Country | Link |
|---|---|
| US (1) | US7756875B2 (en) |
| CA (1) | CA2327076C (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070282663A1 (en) * | 2006-05-11 | 2007-12-06 | Michael Best Friedrich Llp | Group purchase program systems and methods |
| CN102129631B (en) * | 2010-01-13 | 2015-04-22 | 阿里巴巴集团控股有限公司 | Method, equipment and system for SPU attribute aggregation |
| WO2016003500A1 (en) * | 2014-07-01 | 2016-01-07 | Barabajagal, LLC | System and method for secure digital content delivery |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5469206A (en) * | 1992-05-27 | 1995-11-21 | Philips Electronics North America Corporation | System and method for automatically correlating user preferences with electronic shopping information |
| US5459306A (en) * | 1994-06-15 | 1995-10-17 | Blockbuster Entertainment Corporation | Method and system for delivering on demand, individually targeted promotions |
| US5664110A (en) * | 1994-12-08 | 1997-09-02 | Highpoint Systems, Inc. | Remote ordering system |
| US5740425A (en) * | 1995-09-26 | 1998-04-14 | Povilus; David S. | Data structure and method for publishing electronic and printed product catalogs |
| US5898594A (en) * | 1996-06-24 | 1999-04-27 | Leason; David | Method and apparatus for enabling a selection of catalog items |
| US5890175A (en) * | 1996-09-25 | 1999-03-30 | Wong; Garland | Dynamic generation and display of catalogs |
| US6041411A (en) * | 1997-03-28 | 2000-03-21 | Wyatt; Stuart Alan | Method for defining and verifying user access rights to a computer information |
| WO1999008194A1 (en) * | 1997-08-08 | 1999-02-18 | Pics Previews, Inc. | Digital department system |
| US6606744B1 (en) * | 1999-11-22 | 2003-08-12 | Accenture, Llp | Providing collaborative installation management in a network-based supply chain environment |
-
2000
- 2000-11-30 CA CA2327076A patent/CA2327076C/en not_active Expired - Fee Related
-
2001
- 2001-08-30 US US09/943,061 patent/US7756875B2/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CA2327076C (en) | 2016-02-09 |
| US7756875B2 (en) | 2010-07-13 |
| US20020065803A1 (en) | 2002-05-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7792706B2 (en) | Method and system of providing recommendations during online shopping | |
| US7373317B1 (en) | Method and apparatus for facilitating sales of goods by independent parties | |
| CN103970761B (en) | A kind of commodity data searching method and device | |
| US6490567B1 (en) | System and method for distributed content electronic commerce | |
| US20090157479A1 (en) | Selection and Shopping System Founded on Mobile Architecture | |
| US20130080288A1 (en) | System and method for directing a customer to additional purchasing opportunities | |
| US20020026353A1 (en) | System and method of providing purchase information to consumers relating to advertisements displaying the product | |
| WO2001093074A9 (en) | Product feature and relation comparison system | |
| CN102314654B (en) | A kind of information-pushing method and Information Push Server | |
| US8190492B2 (en) | Centralized electronic sales using a consolidator | |
| JP2001290990A (en) | Method and system for anonymous selling/buying and mechanically readable recording medium stored with program | |
| US20040204987A1 (en) | Customized catalog with on-line purchases | |
| CA2327076C (en) | Enabling grouped purchases of goods and services | |
| CA2411381A1 (en) | Method and system for cart transfer in electronic commerce | |
| CN110555177A (en) | Internet commodity data analysis and collection method | |
| JP7395696B1 (en) | Search result page transmission device, search result page transmission method, and search result page transmission program | |
| CN110555176A (en) | E-commerce platform constructed by adopting internet commodity data analysis and collection method | |
| JP7382477B1 (en) | Product page transmission device, product page transmission method, and product page transmission program | |
| JP2004021622A (en) | Purchase system, method, and program based on comparison of commodity price | |
| KR100371846B1 (en) | network based-partition advertisement business system and method on network | |
| JP2002358456A (en) | System and method for site introduction | |
| AU773004B2 (en) | Computerised ordering system | |
| JP2001306860A (en) | Sales intermediation system | |
| WO2002073492A1 (en) | Centralized electronic sales using a consolidator | |
| KR20020092323A (en) | A service method of replacement search in e-Market Place |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| MKLA | Lapsed |
Effective date: 20191202 |