SYSTEM AND METHOD FOR APPLYING AND TRACKING A CONDITIONAL VALUE COUPON FOR A RETAIL ESTABLISHMENT
CROSS REFERENCE TO RELATED APPLICATIONS
This application is related to co-pending United States patent application
Serial No. 09/076,409 entitled "METHOD AND APPARATUS FOR GENERATING
A COUPON" filed on May 12, 1998 in the name of Jay S. Walker, et al.
BACKGROUND OF THE INVENTION
Field of the Invention
The present invention relates to purchasing systems and more particularly to
purchasing systems that apply a discount or reward to a customer's purchase wherein
the discount value is conditional on a set of predetermined events or purchases.
Description of the Related Art
Many retail establishments, particularly grocery stores, pursue marketing
strategies to attract customers and to influence customers to develop buying habits
that are most beneficial to the store. One conventional method of influencing a
customer's buying habits is offering discounts that reduce the price of a service or
product offered by the grocery store. These discounts may be in the form of free
standing inserts (FSIs), coupons, and loss leaders. Generally, coupons provide a
discount for a particular product or brand of product to encourage the customer to
shop at the grocery store, or to promote or switch brand loyalty. These coupons may
also be limited to a particular time period to encourage the shopper to visit the store
during this time. For example, the coupon or discount may only be effective for a
particular day of the week (e.g., Saturday). If the coupon is not used on that day, the coupon is worthless.
While these coupons may promote certain customer purchasing habits, such as when to visit the store or which product to purchase, customers may find the limited use of the coupon frustrating and therefore, not worth saving or using.
Furthermore, weekly advertised specials and coupons by their very nature only attract customers for a given time period and do not incrementally promote customer buying habits. Since the specials or discounts vary from week to week, there is no guarantee or likelihood that a store will be discounting exactly what the consumer is interested in buying every grocery trip. Most consumers, therefore, scan the weekly advertisement of every grocery store in their area before doing their weekly grocery shopping and choose to go to the store that most meets their needs.
Another attempt to attract customers and encourage customer buying habits is the implementation of a frequent shopper card program. This program provides a customer with a frequent shopper card that is presented at the time of purchase.
Presentation of the card enables the customer to receive special weekly discounts on specific items purchased. Essentially, these programs act as a paperless coupon redemption system.
The frequent shopper card programs are also used to track a customer's shopping habits. The frequent shopper card includes a customer identifier that enables the retailer to identify, record and track a frequent shopper's purchases. The customer's shopping history is then used to perform targeted marketing functions, such as compiling mailing lists and sending out advertising material or printing point-of-sale
(POS) coupons to the customer, similar to the Catalina Marketing system which allows stores to print sales offers and discount coupons at the checkout counters. When the POS coupons are redeemed, the coupons are scanned by the cashiers and the amount of the discount is deducted from the total amount of the purchase. This precision marketing permits the POS coupon to have 40% more face value than traditional FSI coupons. While the POS coupon may provide additional discount to the consumer to promote customer loyalty or to change brand loyalty, the incentive to encourage buying habits of the customer is not much more than that presented by an FSI coupon. Again the limited use of the coupon may discourage the customer from using the coupon and may even have the opposite effect of attracting customers.
With the considerable number of supermarket stores in any given area, there exists a need for systems and processes which provide a supermarket with the ability to incrementally reward a customer for buying habits or purchases that are beneficial to the store. SUMMARY OF THE INVENTION
It is an object of the present invention to provide new and improved systems and methods for retail establishments to encourage and reward customers' purchasing habits or purchases that are beneficial to the retail establishment by providing conditional value coupons that provide different discount values based on a predefined set of purchasing conditions. For instance, conditional coupons may encourage a customer to increase his frequency of visits and purchase totals.
According to the present invention, a method and system are disclosed for processing a purchase by a customer of a retail establishment, comprising receiving an
identifier and determining a first discount and second discount from the identifier. The identifier may be used to retrieve a record of the first and second discount from a database. The first discount has a first discount value and the second discount has a second discount value. The method and system further comprises determining a predetermined condition of the purchase and selecting one of the first discount and the second discount based on whether the predetermined condition is satisfied, thereby generating a selected discount having a selected discount value. The selected discount is then applied to the customer's purchase. BRIEF DESCRIPTION OF THE DRAWINGS The present invention is described in detail below with reference to the following drawing figures of which:
FIG. 1 is a block diagram of a point-of-sale (POS) terminal of a purchasing system configured in accordance with a preferred embodiment of the present invention;
FIG. 2 is a block diagram of a point-of-sale (POS) controller configured in accordance with a preferred embodiment of the present invention;
FIG. 3 is a diagram of a conditional discount coupon used with the purchasing system of FIG. 1;
FIG. 4 is an illustration of a database table referred to as the INVENTORY DATABASE database in FIG. 2; FIG. 5 is an illustration of a database table referred to as the TRANSACTION
DATABASE database in FIG. 2;
FIG. 6 is an illustration of a database table referred to as the FREQUENT SHOPPER DATABASE database in FIG. 2;
FIG. 7 is an illustration of a database table referred to as the COUPON VALUE DATABASE database in FIG. 2;
FIGS. 8 A and 8B are flowcharts that illustrate the operations carried out for determining and applying a conditional discount to a customer's current purchase according to a preferred embodiment of the present invention; and
FIG. 9 is an illustration of a database table referred to as the REDEEMED COUPON DATABASE database in FIG. 2. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
In this section, the present invention is described with regard to the drawing figures briefly described above.
As such, the following terms are used throughout the remainder of this section. For purposes of construction, such terms shall have the following meanings:
The terms "item", "product", "goods", and "services", unless otherwise specified, are intended to refer to any item sold or offered by a retailer. Accordingly, for purposes of construction, the terms "item", "product", "goods" or "services" shall be treated as synonyms.
The terms "store", "retailer", "supermarket", and "retail establishment", unless otherwise specified, are intended to refer to any retail merchandising establishment that caters to the public and that allows customers to select products and services. Retail establishments may be a retail store such as a warehouse, a supermarket or grocery store, a department store, or any other retail or merchandising establishment. Accordingly, for purposes of construction, the terms "store", "retailer", "supermarket", and "retail establishment" shall be treated as synonyms.
The terms "customer", "consumer", "purchaser" and "shopper", unless otherwise specified, are intended to refer to any person, group of people, or other entity that visits or otherwise patronizes a retailer and who purchases products and services from the retailer. Accordingly, for purposes of construction, the terms "customer", "consumer", "purchaser" and "shopper" shall be treated as synonyms.
The terms "purchase" and "transaction", unless otherwise specified, are intended to refer to the purchasing of any item or group of items. Accordingly, for purposes of construction, the terms "purchase" and "transaction" shall be treated as synonyms.
The following is a description of the structural and operational aspects of the present invention. The structural aspects are described first and are followed by a description of the operational aspects.
In terms of structure, reference is now made to FIGS. 1 and 2. Therein depicted is a block diagram representing a purchasing system 100 for a retail establishment equipped to record and tally a customer's transaction and apply an appropriate discount to the customer's transaction based on a coupon presented by a customer and a set of pre-defined conditions.
In one embodiment, the purchasing system 100 includes a point of sale (POS) terminal 102 and a POS controller 104. The POS terminal 102 is coupled to the POS controller 104 via a data link 106. In addition, the POS terminal 102 also communicates with a printer 108 and an input device 110. As shown in FIG. 1, printer 108 and input device 110 are coupled to POS terminal 102 via data links 120, 122, respectively. The functionality could all be contained in one POS terminal, or a terminal/server network.
A link such as links 106, 120 and 122 preferably comprises a network connection and/or a serial connection. For example, links 106, 120 and 122 may be a lOBaseT connection enabling Internet communications between POS terminal 102 and POS controller 104. Of course, many other forms of communication links may be used as is apparent to those skilled in the art. Such other data links may include network connections, wireless connections, radio-based communications, telephony-based communications, and other network-based communications such as wide area networks distributed via open architectures such as by the Internet.
As shown in FIG. 1, POS terminal 102 is a data processing system including a central processing unit (CPU) 124, a random access memory unit (RAM) 126, a readonly memory unit (ROM) 128. The POS terminal 102 is operable to receive data signals from the input device 110 and process the information in combination with data received from the POS controller 104 via link 106.
Input device 110 generates signals that identify the item being purchased, a customer using a Frequent Shopper Card and/or a coupon, wherein UPC bar codes are used to identify the purchased item, the customer and the coupon. Input device 110 may be a scanning device similar to the type found in the POS terminals of grocery stores. These scanning devices are capable of reading a first UPC bar code provided on the item to be purchased, a second UPC bar code provided on a customer's Frequent Shopper Card (not shown) which provides the identity or account number of the customer, and a third UPC bar code provided on a conditional coupon. The scanning device transmits signals representing the scanned bar codes to POS terminal 102 via data link 122. In another embodiment, the input device may be a key pad which
includes alphanumeric keys. Such keys are actuated to indicate codes that represent a purchased item, a customer and/or a coupon.
In addition the input device 110 may be operable to read information stored in a card having a magnetic storage medium (i.e., a magnetic strip), or in a smart card having an integrated circuit including readable memory. Similarly, conditional coupons can be stored on a magnetic storage medium or a smart card. Such coupons may be redeemed by swiping the card or otherwise reading the card at the point of sale during a transaction.
CPU 124 transmits data representative of the purchased items, the frequent shopper and the conditional value coupons via link 106 to the POS controller 104. The POS controller 104, in turn, determines the price of the scanned item, and the information relating to the customer and coupon.
In accordance with the present invention, POS terminal 102 transmits an identifier of the coupon to the POS controller 104. The identifier identifies a record in a database from which may be determined the amount of the discount based on a set of predefined conditions. The discount is applied to the customer's purchase. The POS controller 104 completes the transaction and transmits data representative of the items purchased, the discounts applied, applicable taxes and the final total of the transaction to the POS terminal 102 which provides the data to printer 108 for printing on a receipt. Referring to FIG. 2, therein depicted is a block diagram of POS controller 104.
The POS controller 104 is a data processing system such as a computer-equipped automatic data processing system including a central processing unit (CPU) 130, a random access memory unit (RAM) 132, a read-only memory unit (ROM) 134 and a
data storage device 138. The CPU 130 communicates with POS terminal 102 via data link 106.
CPU 130 is coupled to the data storage device 138 via a bus 140 or another well-known, high-speed data communications vehicle or channel. CPU 130 is a computer system of the typical variety adapted to execute software programs.
Additionally, CPU 130 may be configured with communications equipment such as telephony communications and network communications equipment to communicate with POS terminal 102. Implementation of communications link 106 will be readily understood by those skilled in the art. Data storage device 138 may be an appropriate combination of semiconducter, magnetic and/or optical memory that is configured to read and write data maintained in a file store. Of course, it will be appreciated that data storage sub-system may be one that consists of multiple disk sub-systems which may be geographically dispersed and coupled via a network architecture. The data storage device 138 stores a COUPON VALUE DATABASE 142, an
INVENTORY DATABASE 144, a FREQUENT SHOPPER DATABASE 146, a TRANSACTION DATABASE 148, a REDEEMED COUPON DATABASE 149 and a COUPON REDEMPTION PROGRAM 150. The FREQUENT SHOPPER DATABASE 146 maintains a record for each customer which may include information relating to the customer's status. INVENTORY DATABASE 144 maintains a record of each item in the store and the item's price. TRANSACTION DATABASE 148 maintains a record of each customer transaction. CPU 130, in accordance with the COUPON REDEMPTION PROGRAM 150, retrieves the earned discount from the
record of the COUPON VALUE DATABASE 142 that represents the coupon. Thus, the conditional discount is applied to the customer's current transaction. CPU 130 also, in accordance with the COUPON REDEMPTION PROGRAM 150, records the number of coupons that are redeemed at each particular discount value in REDEEMED COUPON DATABASE 149.
Referring now to FIG. 3, therein depicted is a discount coupon 96 representative of the discount the customer will receive off a subsequent purchase at the retail establishment. The coupon has multiple discount values, each of which are conditional upon the transaction satisfying a set of predefined conditions. In particular, the coupon 96 provides a discount of $0.96 off any purchase at ABC grocer, provided the visit is made before November 27, 1997 and the purchase subtotal is greater than $25.00. If the purchase is before November 27, 1997 and the total purchase price is between $10.00 and $25.00, a discount of $0.64 is applied to the transaction. Otherwise, the discount is $0.32 off any purchase less than $10.00 at anytime. The coupon 96 includes an identification number 98 corresponding to a coupon identifier. The identification number 98 is a string of alphanumeric characters that may be keyed into an input device. The identification number 98 also corresponds to a UPC
or other bar code 99, which may be scanned by an input device such as the input device 110.
The bar code symbology used for the invention may be UPC-A. "System 5" of UPC-A is designated for coupon use. Such a system allows for the generation of 99,999 unique coupon offers. Typical information represented by a "system 5" bar
code is the manufacturer number and the product number. The bar code 99 acts as an access code for accessing a database of conditions and values of the printed coupon 96. The POS controller 104 then analyzes the conditions in the database to see if they have been met by the customer's purchase, purchase total or date of purchase as appropriate. After completion of the comparison, the POS controller 104 determines which conditional value to apply to the purchase.
2D bar code symbology may also be used for the conditional coupons 96. A 2D bar code may contain all of the databases necessary for the comparison to take place. Instead of the bar code acting as a "pointer" to a database stored elsewhere, the bar code would contain all information pertinent to the conditional value coupon. Symbol's PDF417, Portable Data File, acts in this manner. A PDF417 symbol contains a complete date record and requires no access to an external database.
The following paragraphs describe a preferred embodiment of the INVENTORY DATABASE 144 as illustrated by database table 152, shown in FIG. 4. The INVENTORY DATABASE 144 is used in the present invention to identify the product and its purchase price when the product identifier is scanned by the input device or otherwise received. Of course, many changes and alterations may be made to such tables to effectuate certain functionality depending on particular design and implementation choices, as is apparent to those skilled in the art. The database table 152 illustrates records relating to products sold by the retail establishment. Table 152 has a column and row arrangement whereby columns define fields and rows define records Rl - R6 stored according to the field specification of the columns. Table 152 includes for each record fields for identifying a PRODUCT
IDENTIFIER 154, a FAMILY CODE 156, a MANUFACTURER CODE 158, a DESCRIPTION 160, and a PRICE 162.
Each record Rl - R6 is representative of a product sold by the retail establishment. Each record Rl - R6 is uniquely identified by PRODUCT IDENTIFIER 154. For example, with regard to record Rl, a product having PRODUCT IDENTIFIER of "114207" is for "FUJI 100k film with 24 exposures" having a MANUFACTURER CODE of "1205", a FAMILY CODE of "103", and a retail price of "$5.48". Each MANUFACTURER CODE 158 provides a unique identifier representative of the manufacturer or brand. For example, Manufacturer Code of "1205" represents the company "FUJI" as the manufacturer of the purchased product. Similarly, MANUFACTURER CODE of "1206" of record R3 represents a product manufactured by "KODAK", and MANUFACTURER CODE of "1290" of records R5 and R6 represents a retail establishment's (i.e., "Shop Rite") brand product.
Each FAMILY CODE 156 is a unique identifier representative of the product's type or category. For example, a FAMILY CODE of "103" represents the category of film products and thus records Rl, R2 and R3 represent film products. Similarly, FAMILY CODE of "115" represents the category of baked goods from the bakery, and a FAMILY CODE of "101" represents the category of goods associated with beverages. It is important to note that the structure and arrangement of table 152, including its columns and fields, may be altered to suit particular design requirements. Many columns may be added to table 152 to carry out certain functionality control within a data processing system employing a database table like table 152. Such additions and changes will be apparent to those skilled in the art.
As each item is scanned by the input device 110 (FIG. 1), the POS terminal 102 (FIG. 1) transmits the product identifier to the POS controller 104. POS controller 104 retrieves the record from the INVENTORY DATABASE 144 that corresponds to the product identifier. The POS Controller 104 therefrom determines the item price and transmits the price to POS terminal 102.
POS terminal 102 receives the price of the item from the POS controller 104 and transmits data representing the description and price of each item to printer 108 via data link 120. Upon receipt of such data, printer 108 prints the information to generate a sales receipt of the transaction. In addition, POS controller 104 stores the selected data of each scanned product in the TRANSACTION DATABASE 148 which, as described below, maintains a subtotal of the transaction as each purchased item is scanned by input device 110. The POS controller 104, operating according to the COUPON REDEMPTION PROGRAM 150, (i) determines the discount of a conditional coupon based on data in the COUPON VALUE DATABASE 142, (ii) stores the discount in the TRANSACTION DATABASE 148, and (iii) deducts the discount from the subtotal of the transaction. Any applicable taxes are recorded in the TRANSACTION DATABASE 148 and are then added to the subtotal to generate a total purchase amount for the transaction. The POS terminal 102 receives this information and transmits the information to printer 108 for printing indicia on the receipt. Such indicia may identify the item purchased, item price, manufacturer's coupon discount, time/date of purchase, total of purchase, applicable taxes, and/or total of purchase.
Referring now to FIG. 5, therein is a database table 164 which represents a
record relating to a transaction at a retail establishment. Database table 164 (hereinafter referred to as "table 164") represents a record of TRANSACTION DATABASE 148 (FIG. 2). Table 164 has a column and row arrangement whereby columns define fields and rows define records. The TRANSACTION DATABASE 148 typically includes a plurality of records such as that represented by table 164, each record defining a transaction. Each of entries Rl 1, R12, R13, R14 and R15 includes a TRANSACTION CODE 166, a DESCRIPTION 168, a PRICE 170 and a SUBTOTAL 172.
The transaction illustrated in FIG. 5 is for a transaction identified by "91210765" that occurred on January 15, 1998 at 5:10 PM. Entry Rl 1 indicates a Frequent Shopper identified by TRANSACTION CODE "9995" and having a description "Joe Smith, Gold Frequent Shopper". Entry R12 represents a purchased product identified by TRANSACTION CODE of "114207" having a product description of "FUJI 24 EXP. 100K FILM" for a price of $5.48. The SUBTOTAL of entry R12 is equal to the SUBTOTAL of the previous SUBTOTAL of entry Rl 1 plus the PRICE of the product of entry R12. Entry R13 represents a redeemed conditional coupon having a TRANSACTION CODE of "11210", a product description of "CONDITIONAL COUPON" and a price (discount) of "-$2.00" associated with a purchased product of entry R12. The SUBTOTAL of entry R13 is equal to the SUBTOTAL of the previous SUBTOTAL of entry R12 plus the PRICE (discount) of the conditional discount entry R12. Entry R14 represents the taxes for the transaction identified by TRANSACTION CODE of "TAXES" and having a description of "1.08 x SUBTOTAL". The price of the TAXES is determined to be 0.08 (i.e., 8% sales taxes) multiplied by the SUBTOTAL of entry R13 for a PRICE of $0.27. The SUBTOTAL
of entry R14 is equal to the SUBTOTAL of the previous SUBTOTAL of entry R13 plus the price of the TAXES of entry R14. Entry R15 represents the total price for the transaction and is identified by TRANSACTION CODE of "TOTAL". The TOTAL of entry R15 is equal to the SUBTOTAL of the previous entry R14. It is important to note that the structure and arrangement of table 164, including its columns and fields, may be altered to suit particular design requirements. Appropriate additions and changes will be apparent to those skilled in the art.
Referring to FIG. 6, the following paragraphs describe one embodiment of the FREQUENT SHOPPER DATABASE 146 that is depicted in database table 174. The retail establishment may rate each customer according to a predetermined criteria to define or rate the customer's loyalty to the retail establishment. For example a customer having a "gold" rating may be a customer that visits the store at least once a week and purchases at least $15.00 in products, while all other customers may have a "silver" rating. The database table 174 stores a plurality of records R16, R17, R18, R19 and
R20, each relating to a frequent shopper. Table 174 has a column and row arrangement whereby columns define fields and rows define records stored according to the field specification of the columns. Each record includes a FREQUENT SHOPPER NUMBER 176, a NAME 178, an ADDRESS 180, a TELEPHONE NUMBER 182, and a STATUS 184. For example, in table 174 record R16 contains information related to a customer having a FREQUENT SHOPPER NUMBER of "9995".
Each of records R16, R17, R18, R19 and R20 represents a customer that has a Frequent Shopper Card account at the retail establishment. For example, with regard to
record R16, "Joe Smith" has a FREQUENT SHOPPER NUMBER of "9995" and a "gold" status. The STATUS 184 of each record may be represented in various other ways. For example, there may be a plurality of sets of frequent shopper numbers, each set corresponding to a status. It is important to note that the structure and arrangement of table 174, including its columns and fields, may change to suit particular design requirements. Many columns may be added to table 174 to effect certain functionality control within a data processing system employing a database table like table 174. Such additions and changes will be apparent to those skilled in the art. Referring to FIG. 7, the following paragraphs describe a preferred embodiment of the COUPON VALUE DATABASE 142 (FIG. 2) as illustrated by database table 190. The table 190 includes a plurality of records, each representing a conditional coupon. These records define the condition that must be satisfied to receive a corresponding predefined discount value for an identified coupon. Table 190 has a column and row arrangement whereby columns define fields and rows define records stored according to the field specification of the columns. Each of records R21 - R30 includes a COUPON IDENTIFIER 192, a VALUE 1 194, a CONDITION 1 196, a VALUE 2 198, a CONDITION 2 200, a VALUE N 202 and a CONDITION N 204. Each of records Rl - R10 represents a coupon that has been issued or distributed to the customers of the retail establishment. Each record includes a plurality of possible discount values in the VALUE fields 194, 198, 202. The discount value of a redeemed coupon that is applied to a purchase is based on the satisfaction of a corresponding
condition defined in the CONDITION fields 196, 200, 204, respectively. For example, with regard to record R21, the coupon having a COUPON IDENTIFIER of "11210" has a first discount value of $2.00 if a purchased item has a TRANSACTION CODE of "114207", a second discount value of $1.28 if a purchased item has a MANUFACTURER CODE of "1205", and a third discount value of $0.64 if any other item is purchased. Although the table 190 includes three value and condition pairs, those skilled in the art will understand that any number of value and condition pairs may be used.
Records R22 - R30, which have the same record format as record R21, illustrate other embodiments for applying a discount based on the purchase satisfying different conditions. For instance, record R22 is illustrative of a coupon, identified by a COUPON IDENTIFIER of "11211", wherein the application of the discount to the purchase is conditional on the date in which the customer redeems the coupon. For example, in record R22 the discount value is $1.50 off the subtotal of the purchase if the coupon is redeemed before January 10, 1998. If the coupon is redeemed between January 10, 1998 and January 19, 1998, the discount value is $1.00. If the coupon is redeemed between January 20, 1998 and January 29, 1998, the discount value is $0.50. In another embodiment, the coupon can be activated at a future time. For example, the coupon may be issued on December 25, 1997 but cannot be redeemed until after January 1, 1998. Such a delay in activation may be achieved by simply adding the condition to each of the CONDITIONS 194, 198, 202 for record R22 that the purchase date must also be after December 31, 1997. For example, the condition 196 may be "used after December 31, 1997 and used before January 10, 1998". Such Compound
Conditions (a plurality of conditions which are joined by connecting tests such as "and", "or" and "not") are apparent to those skilled in the art.
Record R23 is illustrative of a coupon having a COUPON IDENTIFIER of "11212" that has a conditional discount based on the total price of the customer's purchase. In record R23, the discount value is $1.50 if the transaction price is greater than $30.00. If the transaction total is between $15.00 and $30.00, the discount value of the coupon is $0.75. If the transaction total is less than or equal to $15.00, the discount value of the coupon is $0.50.
Record R24 is illustrative of a coupon having a COUPON IDENTIFIER of "11213" that has a conditional discount based on the redemption of other coupons toward the customer's purchase. In record R24, the discount value is $2.00 if no other coupons are redeemed toward the present purchase. If other coupons are redeemed, the discount value of the coupon is $1.00. No further value and condition pairs are defined for the record R24. Record R25 is illustrative of a coupon having a COUPON IDENTIFIER of
"11214" that has a conditional discount based on the redemption of a predetermined number of other, like coupons. In record R25, the discount value is $1.00 if three (3) other like coupons are redeemed with the present coupon. If no other like coupons are redeemed with the present coupon, the discount value of the coupon is $0.50. Record R26 is illustrative of a coupon having a COUPON IDENTIFIER of
11215 that has a conditional discount based on the use of a Frequent Shopper Card and status of the shopper (i.e., "gold" customer). In record R26, the discount value is $1.50 if the customer uses a Frequent Shopper Card with the coupon and is designated as a
"gold " customer. If the customer uses a Frequent Shopper Card with the coupon and is designated as a "silver " customer, the discount value of the coupon is $1.00 off the subtotal of the purchase. If the customer does not use a Frequent Shopper Card with the coupon, the discount value of the coupon is $0.50. Record R27 is illustrative of a coupon having a COUPON IDENTIFIER of
"11216" that has a conditional discount based on the incremental number of like coupons redeemed in prior purchases by all customers. In record R27, the discount value is $2.00 if less than 100 like coupons have been redeemed by customers. If between 100 and 200 like coupons have been redeemed by customers, the discount value of the coupon is $0.50. If greater than 200 like coupons have been redeemed by customers, the discount value of the coupon is $0.25.
Record R28 is illustrative of a coupon having a COUPON IDENTIFIER of "11217" that has a conditional discount based on the number and type of movies currently being rented and/or the customers history of returning movie rentals on time. In record R28, the discount value is for a free movie rental (e.g. two day rental period) of an old release, if the customer is renting at least one new release and one old release. If the customer is renting at least one old release and no new releases, the discount value of the coupon is a free one day rental of the old release being rented. If the customer has historically returned rented movies on time, the discount value of the coupon is a free one day rental of a movie being rented. The POS controller 104 (FIG. 1) may store a customer's rental history in the transaction database 148, such as the dates and times of each rental, the dates and times when each movie was returned, and whether each movie was returned on time or after the end of a rental period.
Accordingly, such rental history may be read to determine whether he has returned movies on time in the past. For example, the number of times the customer has not returned a movie on time may determine whether he is considered to satisfy the above conditions. Record R29 is illustrative of a coupon having a COUPON IDENTIFIER of
"11218" that has a conditional discount based on the day of the week of the customer's purchase. In record R29, the discount value is $2.00 if the coupon is redeemed on Monday, Tuesday or Friday. If the coupon is redeemed on the other days of the week, the discount value of the coupon is $1.00. Record R30 is illustrative of a coupon having a COUPON IDENTIFIER of
"11219" that has a conditional discount based on the time of day that the coupon is redeemed. In record R30, the discount value is $2.00 if the coupon is redeemed between 5:00 PM and 7:00 PM. If the coupon is redeemed at other times during the day, the discount value of the coupon is $1.00. It is important to note that the structure and arrangement of table 190, including its columns and fields, may change to suit particular design requirements. Many columns may be added to table 190 to carry out certain functionality control within a data processing system employing a database table like table 190. Such additions and changes will be apparent to those skilled in the art. Thus, a variety of conditions have been illustrated in the Table 190. Those skilled in the art will understand that many other conditions may be included. The records R21 - R30 of the database table 190 of FIG. 7 illustrates a number of defined conditions for applying a discount value to transaction. One skilled in the art will
appreciate that many other conditions are possible. For example, some coupons may only be redeemed after a predetermined number of like coupons have been presented for redemption. For this condition, each individual coupon may have no value individually, but collectively the coupons may have a value. For instance, coupons may have no value individually, however, when five of these coupons are redeemed, the customer is entitled to a phone card having ten minutes of pre-paid phone time.
Similarly, a combination of coupons may possess a greater value than the sum of the values of coupons included in the combination. For instance, if a coupon having a value of one minute of pre-paid phone time is redeemed, the customer is entitled to a phone card with one minute of pre-paid phone time. However, if five such coupons are redeemed, the customer is entitled to a phone card with ten pre-paid minutes.
In another condition, the coupons may only be redeemed once a certain maximum number of coupons have been redeemed by customers. For example, after two hundred similar coupons have been redeemed by customers, the remaining issued coupons may be of no value. Alternatively, the value of a coupon may increase or decrease depending on the number of similar coupons that have been redeemed by customers.
The present invention may also include the REDEEMED COUPON DATABASE 149 (FIG. 2) which records data relating to the redemption of coupons. Such a database is useful in tracking the redemption of coupons.
Referring now to FIG. 8, database table 210 (hereinafter referred to as "table 210") is an embodiment of REDEEMED COUPON DATABASE 149 (FIG. 2). Table 210 has a column and row arrangement whereby columns define fields and rows define
records R31, R32, R33 and R34 that are stored according to the field specification of the columns. Each record includes COUPON IDENTIFIER 212, a TOTAL REDEEMED AT VALUE 1 214, a TOTAL REDEEMED AT VALUE 2 216, and a TOTAL REDEEMED AT VALUE N 218. For example, record R31, identified by a COUPON IDENTIFIER of " 11210", contains information related to the coupons having a COUPON IDENTIFIER of "11210".
Each record R31 - R34 represents the information relating to the redemption of coupons at selected discount values. For example, with regard to record R31, one coupon having a discount value of VALUE 1 194 (i.e., $2.00 see FIG. 7) was redeemed, four coupons having a discount value of VALUE 2 198 (i.e., $1.28) were redeemed, fifty-two coupons having a discount value of VALUE N 204 (i.e., $0.64) were redeemed.
It should be understood that the POS controller 104 and POS TERMINAL 102 of the purchasing system 100 use the database tables 152, 164, 174, 190 and 210 illustrated in FIGS. 4 - 8 to operate together. The flowchart depicted in FIGS. 9 A and 9B and described below illustrates how such elements operate together. In particular, described below are the steps carried out by purchasing system 100 within a retail establishment to apply a discount to a customer's transaction based on the transaction meeting a predefined condition. Referring to FIGS. 9A and 9B, a process 250 begins when the POS controller
104 receives the PRODUCT IDENTIFIERS of products being purchased by the customer, as well as any Frequent Shopper Code (Step 252). As described in greater detail above, the price and description of each product that is being purchased by the
customer may be retrieved from the inventory database 144 (FIG 2). In step 254, the POS controller 104 receives the conditional coupon code that may be encoded on the coupon. As described above, the conditional coupon, having a UPC code, is scanned by input device 110. The conditional coupon code is transmitted to POS terminal 102 and provided to the POS controller 104 accordingly. Alternatively, the conditional coupon code may be manually entered using an alphanumeric keypad. At step 256, the subtotal of the purchase is continually calculated as each product is added to the TRANSACTION DATABASE 148. In one embodiment, the cashier operating the POS terminal may enter a "purchase received" prompt. Such a prompt indicates to the POS terminal that all items have been scanned, and so the value of the coupon should now be determined. In another embodiment, the value of the coupon is determined when the coupon is scanned and received by the POS terminal.
The CPU 130 retrieves the appropriate coupon record identified by the COUPON IDENTIFIER in field 192 of the COUPON VALUE DATABASE 142. From the coupon record, the possible conditions may be retrieved (step 258).
At Step 260, the POS controller 104 compares the first condition (defined in the CONDITION 1 field) with the current purchase stored in the TRANSACTION DATABASE 148 (See FIG. 5). For example, for the conditional coupon defined in record R21 of FIG. 7, the POS controller compares the TRANSACTION CODE of each of the products of the current purchase with the code number "114207" identified in the CONDITION 1 field 196. Thus, if at Step 262, the Code number "114207" is recorded in the TRANSACTION DATABASE 148, then the purchase satisfies the first condition. Then, at step 264, the POS controller 104 retrieves the corresponding
coupon discount value for the satisfied condition. Thus, if the first condition is satisfied, then the VALUE 1 field 194 in the COUPON VALUE DATABASE 142 (which has a discount value of $2.00) is retrieved. The retrieved discount value is then stored in the TRANSACTION DATABASE 148 (See FIG. 5) and at step 266 the discount value is subtracted from the subtotal of the purchase as described above. If at Step 262, the purchase does not satisfy the first condition, the POS controller 104, at Step 268, compares the second condition defined in the CONDITION 2 field with the current purchase. If at Step 270, the second condition is satisfied, the POS controller 104 retrieves the corresponding coupon discount value (the VALUE 2 field 198) (step 264) and subtracts this value from the subtotal (Step 266).
If, at Step 270, the purchase does not satisfy the second condition, the POS controller 104, in Step 272, compares the nth condition defined in the CONDITION N field with the current purchase. If, at Step 274, the nth condition is satisfied, the POS controller 124 retrieves the corresponding coupon discount value (the value N Field) (step 264) and subtracts this value from the subtotal (step 266).
If, at Step 274, the present transaction does not satisfy the nth condition, an appropriate message is provided to the customer and/or cashier that the coupon is invalid (step 276). Therefore, no discount is applicable to the purchase.
It should be noted that while the bar code may be printed on a coupon, the present invention is not so limited. To the contrary, the present invention contemplates that the bar code may be printed on any item in the retail establishment. In this way, the value of an item in the store may be determined by external conditions that are evaluated when the code is scanned at the POS terminal 102. For instance, when items
such as milk or canned goods near their expiration dates, the price of that good may be adjusted accordingly to encourage the sale of the product. The conditions on the products could be new merchandise, merchandise nearing an expiration date, or merchandise past an expiration date. These conditional discounts on the products thus eliminate the need to change the prices in a database. A time code stamped into the bar code symbol would be used to automatically adjust the price. Also, items could have different prices depending on whether other items were purchased as well.
Accordingly, having fully described the present invention by way of example with reference to the attached drawing figures, it will be readily appreciated that many changes and modifications may be made to the invention and to any of the exemplary embodiments shown and/or described herein without departing from the spirit or scope of the invention which is defined in the appended claims.