The present invention relates to a product information system, more particularly relates to a product purchasing trend analyzing system for acquiring in real time information up to when customers purchase products and analyzing purchasing trends of customers based on this information.
Japanese Unexamined Patent Publication (Kokai) No. 2002-150432 discloses an invention entitled a “product information provision server and product information provision method”. This invention has as its object the provision of a product information provision server and product information provision method enabling analysis of information of unpurchased products which were not been sold, but which it is believed users wanted to buy or were interested in and thereby promoting sales of products. This configuration is characterized in that a server communicably connected to terminal devices installed in stores stores in an output history database and manages information relating to an output history of product information for which search or display is requested from the terminal devices based on user operation, stores and manages sold product information sent from host computers of POS systems connected to POS terminals of POS systems installed at cash registers etc. in stores, and specifies information on unpurchased products which were candidates for purchase but which failed to be purchased based on the output history information and sold product information.
The product information server according to this prior art only collects information on which customers purchased which products when analyzing purchased product information, so could not analyze what products were purchase candidates for each customer or from what perspectives customers purchased products in real time. Further, this server counted only what products were sold when analyzing product purchase information, so could not acquire in real time information as to which products were purchase candidates or which products were not purchase candidates. With the method of Japanese Unexamined Patent Publication (Kokai) No. 2002-150432, since only information on unpurchased products which were not sold, but which it is believed users wanted or were interested in was obtained, it was not possible to analyze information as to what perspectives customers purchased products from. Therefore, store managers were unable to judge in real time and suitably set the restocking quantities and prices of products which were purchase candidates or products which were not purchase candidates.
Further, according to the prior art, customers could not display on screens a comparison of items of specifications of competing manufacturers for the same products. They had to print out product information of different manufacturers for comparisons or make comparisons by product catalogs of product information in order to compare products. This took trouble.
Further, in stores, staff often end up being kept busy explaining products. The work which originally should be performed by the staff cannot therefore be completed. Further, with the method of Japanese Unexamined Patent Publication (Kokai) No. 2002-150432, since only information on unpurchased products which were not sold, but which it is believed users wanted or were interested in was obtained, it was not possible to analyze information as to which products were compared with which manufacturers or what perspectives customers purchased products from. Therefore, manufacturers have not been able to obtain in real time information relating to purchasing trends of products such as what products compete with what manufacturers and what perspectives customers use to determine purchases of products, that is, what the standards of judgment are for customers purchasing products, so have often left product development for later.
The present invention has as its object the provision of a product purchasing trend analyzing system for acquiring and analyzing information relating to purchasing trends of products such as what kind of products are considered as purchase candidates when customers select products for purchase or what perspectives they select products for purchase from and notifying the information to stores in real time so as to enable them to judge in real time the restocking quantities or prices of products in the stores to enable these to be suitably set.
The present invention has as another object to notify manufacturers in real time of information as to what manufacturers are rival manufacturers of products and on what points (specifications) products purchased by customers are compared with products of rival manufacturers so as to enable manufacturers to timely develop products along with the constantly changing trends of purchase of products by customers (consumers).
The product purchasing trend analyzing system according to the present invention for achieving the above objects is characterized by storing in a customer purchasing trend database a history relating to products which customers view and items of specifications of the products when customers view product information for comparison or purchase products and analyzing this information to analyze the selected products (names of products of purchase candidates) and selected items (purchasing perspectives of products) in customer units and product units.
The product purchasing trend analyzing system according to the present invention for achieving the above objects provides a system for analyzing purchasing trends of products which manufacturers sell in stores, characterized by being provided with a server communicably connected with first terminals provided at said manufacturers and second terminals provided in said stores, said server provided with entry means enabling input of product information of said products from said first terminals, product information display means for sending said product information to and displaying it at said second terminals, and acquiring means for acquiring histories by which said product information is accessed by said second terminals.
In such a product purchasing trend analyzing system, said system is provided with a customer purchasing trend database for storing information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access, and said server counts the number of times customers access predetermined product categories in said product information in product category units, stores the counted values in said customer purchasing trend database, reads from said customer purchasing trend database if said customers have purchased products and reads what items among the plurality of items showing specifications of said products said customers accessed, and displays purchasing trends of products so as to analyze the reasons why said customers selected the manufacturers whose products said customers have purchased, from among a plurality of manufacturers providing product information of said products which said customers access, by provision of first display means.
In such a product purchasing trend analyzing system, said system is provided with a customer purchasing trend database for storing information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access, and said server counts the number of times customers access predetermined product categories in said product information in product category units, stores the counted values in said customer purchasing trend database, reads from said customer purchasing trend database if said customers have purchased products of said product category, and displays a list comparing for each product category the manufacturers for which customers view said product categories or purchase from, from among a plurality of manufacturers providing product information of products of said product categories accessed by said customers, by provision of second display means.
In such a product purchasing trend analyzing system, said system is provided with a customer purchasing trend database for storing information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access, and said server counts the number of times customers access predetermined product categories in said product information in product category units, stores the counted values in said customer purchasing trend database, reads from said customer purchasing trend database if said customers have purchased products of said product categories and reads which items among a plurality of items showing specifications of said products said customers have accessed, and displays a list comparing, for each product category, the number of times said customers have accessed a plurality of items showing specifications of said products of manufacturers compared with a specific manufacturer among a plurality of manufacturers providing product information of products of said product category which said customer accesses with said specific manufacturer for each manufacturer by provision of a third display means.
In such a product purchasing trend analyzing system, the system is provided with a second server separate from said server provided with said acquiring means, and said second server stores information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access and sets the restocking quantities and prices of the products.
Below, embodiments of the present invention will be explained in detail with reference to the attached drawings.
The main server 1 is arranged in the building of a broker and is a general medium- or large-sized computer system. An auxiliary disk stores a product information database DB 11, a product information update history database DB 12, and a customer purchasing trend database DB 13. These databases will be explained in detail later.
The information terminals 2 are also called clients or customers, are arranged in stores for retailing products, and can provide information to customers without the help of store clerks. A display 21, card reader 22, bar code reader 23, and printer 24 are connected to each. The information terminals 2 provide product information to be sent to the customers from the main server 1 through the monitor screens of the displays 21. Due to this, it is possible to save the time of store clerk in explaining products in the stores. Further, the history data of input operations by customers from touch panels or the mouses etc. provided at the information terminals 2 is stored in the client purchasing trend database DB in the main server 1. The card readers 22 read registration numbers unambiguously specifying customers stored in for example magnetic cards or IC cards. These cards are also utilized as bonus point cards. “Bonus point cards” record the number of bonus points which customers acquire in accordance with the amounts which the customers purchase. The customers receive benefits such as discounts the next time they purchase from stores in accordance with the number of bonus points.
The bar code readers 23 read bar codes specifying products and carrying information on the products which customers desire to have displayed on the monitor screens of the displays 21. Bar codes generally include “JAN-8” and “JAN-13” bar codes based on the JAN (Japanese Article Numbering), “EAN-8” and “EAN-13” bar codes based on the EAN (European Article Numbering), and “UPC/A” and “UPC/E” bar codes based on the UPC (Universal Product Code). When products are large or heavy, printed matter bearing the bar codes are prepared separately and utilized by the customers.
The printers 24 are provided for customers or store clerks to print out printable information displayed on monitor screens of displays 21 on paper for memo use.
The manufacturer terminals 3 are arranged in the buildings of manufacturers. By writing product information relating to the specifications, price, etc. of products in a predetermined format provided at the main server 1 side, the product information is sent to the main server 1 and is stored in the product information database DB 11 at the main server 1. Further, when preparing or updating the product information database DB 11 at the main server 1, the numbers of registered bonus points of the products and the numbers of times of registration input from the manufacturers are stored in the product information update history database DB (hereinafter simply referred to as the “update history database DB”) 12.
Stores are provided with POS terminals 5 at their cash registers. Further, each POS terminal 5 has a display 51, card reader 52, bar code reader 53, and printer 54 connected to it. Store clerks read the bar codes attached to products by bar code readers provided at the POS terminals 5 when products are purchased.
Stores or headquarters of stores (normally having a plurality of stores) located away from the stores are provided with store servers 6 communicably connected to the POS terminals 5. Each store server 6 stores in an auxiliary disk a customer database DB 61 and PLU (Price Look Up) database DB 62. The store servers 6 are connected communicably with the main server 1 and update the prices of products in the product information database. The customer DB's 61 and PLU DB's 62 store information relating to products purchased by customers input by store clerks through bar code readers 53, specifically, tables of correspondence among the bar codes, product names, and prices. The information stored in the customer DB's 61 are transferred through the network 4 to the customer purchasing trend DB 12 in the main server 1. The PLU DB 62's contain information used only for processing in stores.
Further, a virtual store server 7 provided in the building of a virtual store is communicably connected to the main server 1 through the network 4. Customers registered at the virtual store through personal computers (PC) 8 of the customers connected communicably to the main server 1 through the Internet 4 can shop through the Internet without going out to actual stores and using information terminals 2 at the stores. The virtual store server 7 has similar functions to a store server 5.
The first embodiment shown in
Next, the preparation and updating of the product information database DB 11 will be explained.
When each manufacturer finishes registering product information as shown in
Next, preparation of the product information update history database DB 13 will be explained.
As explained above, the update history database can be used for measurement of the degree of contribution of registration of product information from manufacturers to stores. In the first embodiment, the update history database DB 13 is sent to store servers 6 installed in stores. Store servers 6 receiving this sent data can automatically determine the restocking quantities of products by the stores in accordance with the degrees of contribution of registration of product information from manufacturers to the stores.
In the above first embodiment, the example is shown of the update history database DB 13 installed in the main server 1, that is, the server of a broker, but it is also possible to have the role of the broker handled by the stores as an embodiment. In such a second embodiment, the auxiliary disks of the store servers 6 installed in the stores store product information databases DB 11, product information update history databases DB 12, and customer purchasing trend databases DB 13. Using the data of the update history databases DB 12, in the same way as explained using
Next, the process of a customer acquiring product information to purchasing a product and the process of analyzing purchasing trends of products from the history will be explained below.
Note that a customer can also view the screen of an information terminal without a customer card, but in this case the history of what specifications a customer actually purchasing a product showed interest in when deciding to purchase the product cannot be obtained.
In
When clicking on product description item information in this way, detailed information relating to the item is displayed. At this time, the selected item (purchase perspective of product) is saved in the memory.
Further, as shown in
Therefore, the customer purchasing trend DB is provided with the following items:
1. Time when customer views product information at product information terminal (time of viewing of product information)
2. Time when customer purchases product (time of purchase)
The time of purchase is set when “1” is set for the purchase flag.
Next, the preparation of the customer purchasing trend database DB 12 will be explained.
As explained above, when a customer finishes viewing products, the viewed information is sent from the information terminal 2 to the main server 1 and the selected products (names of products of purchase candidates) and selected items (purchasing perspectives of products) are saved in the customer purchasing trend database 12 in the main server 1. Below, the processing for preparing this customer purchasing trend database will be explained.
In
As explained above, the customer purchasing trend database DB is a collection of data on the viewed items which a customer selects at the information terminal 2 recorded in category units or for each customer.
(1) When a customer views a product, the information terminal 2 reads a recording medium (member card) including information unique to the customer, the information terminal 2 notifies the purchasing information to the main server 1, and the purchasing information is saved in the customer purchasing trend database 12.
(2) When a customer purchases a product, the POS terminal 5 reads a recording medium (member card) including information unique to the customer, the POS terminal 5 notifies the purchasing information to the main server 1, and the purchasing information is saved in the customer purchasing trend database 12.
At step S1 of
At step S3, it is judged if the category which the customer selects was newly selected by the customer. When the result of judgment is YES, the routine proceeds to step S5, while when NO, the routine proceeds to step S4.
At step S4, the selected category is judged, a new table corresponding to that category is prepared, the customer number is set in the table, and “1” is set in the selected item.
At step S5, the already selected table is viewed to judge if the selected item is an already selected item. When the result of judgment is YES, the routine ends, while when NO, the routine proceeds to step S6. At step S6, “1” is set in the selected item.
The main server 1 has a customer selection information counting means, has customer unit information extracting means, category unit information editing means, and comparative manufacturer information editing means, edits the information, displays the results on the screen, or prints them out on the paper.
Next, the method of forecasting restocking quantities and restocking dates for products based on the customer purchasing trend DB will be explained.
By acquiring the product information viewing times of customers and the histories of viewing times, it is learned how many days after viewing the product information the individual customers purchased products. By obtaining statistics on the numbers of times of viewing of individual products and how many days after viewing the product information the products were purchased, stores can forecast the restocking quantities and restocking dates of individual products.
From the information shown in
From the results shown in
Restocking quantity=30×0.20=6 units
is forecasted.
Similarly, if forecasting the restocking quantity for the next week for refrigerators of the second manufacturer (GR-A40T),
Restocking quantity=25×0.10≈3 units
is forecasted.
From the information shown in
From the result shown in
The restocking quantity is forecasted as follows:
Therefore, the ratio of a person viewing a refrigerator of the first manufacturer (NR-E48AP) on a Saturday purchasing it after seven days is 5÷17≈0.30 and the ratio of it purchasing it after eight days is 7÷17≈0.40.
The number of times of viewing on June 6 (Saturday) in the most recent one week is 27, so using the above method of forecasting restocking, 27×0.20≈5.4≈6 units.
Therefore, the forecast of demand for June 13 (Saturday) after seven days is 6 (units)×0.30≈1.8≈2 (units), while the forecast of demand for June 13 (Saturday) after eight days is 6 (units)×0.40≈2.4≈3 (units).
As explained above, by acquiring the history of the viewing times of product information and the purchasing times of customers, it is learned how many days after viewing product information individual customers purchased products. By obtaining statistics on the number of times of viewing of individual products and how many days after viewing product information what products were purchased, stores can forecast the restocking quantity and restocking dates of individual products.
The restocking quantity is forecasted by the ratio of the number of times of viewing and number purchased of individual products. Further, the restocking dates may be forecasted by the method of obtaining statistics on how many days after viewing products were purchased so as to set the restocking dates after the periods of the peak values.
According to the product purchasing trend analyzing system according to the present invention explained above, stores and manufacturers can obtain the following advantages:
(i) Advantages to Stores
(ii) Advantages to Manufacturers
(Appendix 1)
A product purchasing trend analyzing system for analyzing purchasing trends of products which manufacturers sell in stores,
said product purchasing trend analyzing system characterized by being provided with a server communicably connected with first terminals provided at said manufacturers and second terminals provided in said stores,
said server provided with
entry means enabling input of product information of said products from said first terminals,
product information display means for sending said product information to and displaying it at said second terminals, and
acquiring means for acquiring histories by which said product information is accessed by said second terminals.
(Appendix 2)
A product purchasing trend analyzing system as set forth in claim 1, wherein said server is provided with:
means for acquiring from said first terminals histories by which product information of said products has been updated for each first terminal,
means for calculating an update history order for each said first terminal from an update history of each first terminal, and
means for evaluating an input of product information for each first terminal from said update history order.
(Appendix 3)
A product purchasing trend analyzing system as set forth in appendix 1 or 2, wherein said acquiring means acquires a first history as to which products' product information customers access.
(Appendix 4)
A product purchasing trend analyzing system as set forth in any one of appendixes 1 to 3, wherein said acquiring means acquires a second history as to which products customers purchase.
(Appendix 5)
A product purchasing trend analyzing system as set forth in any one of appendixes 1 to 4, wherein
said product information includes a plurality of items showing specifications of said products, and
said acquiring means acquires a third history as to which items among said plurality of items customers access.
(Appendix 6)
A product purchasing trend analyzing system as set forth in any one of appendixes 2 to 5, wherein
said product information includes a plurality of items showing specifications of said product, and
said acquiring means acquires said first history and said third history by store clerks accessing said second terminals for items designated by customers.
(Appendix 7)
A product purchasing trend analyzing system as set forth in appendix 5 or 6, where said third history is a history by which the same customers access a plurality of items among said plurality of items.
(Appendix 8)
A product purchasing trend analyzing system as set forth in any one of appendixes 5 to 7, wherein said server is provided with a customer purchasing trend database storing at least one of the first, second, and third histories acquired by said acquiring means.
(Appendix 9)
A product purchasing trend analyzing system as set forth in appendix 8, wherein
said system is provided with a customer purchasing trend database for storing information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access, and
said server counts the number of times customers access predetermined product categories in said product information in product category units, stores the counted values in said customer purchasing trend database, reads from said customer purchasing trend database if said customers have purchased products and reads what items among the plurality of items showing specifications of said products said customers accessed, and displays purchasing trends of products so as to analyze the reasons why said customers selected the manufacturers whose products said customers have purchased, from among a plurality of manufacturers providing product information of said products which said customers access, by provision of first display means.
(Appendix 10)
A product purchasing trend analyzing system as set forth in appendix 8, wherein
said system is provided with a customer purchasing trend database for storing information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access, and
said server counts the number of times customers access predetermined product categories in said product information in product category units, stores the counted values in said customer purchasing trend database, reads from said customer purchasing trend database if said customers have purchased products of said product category, and displays a list comparing for each product category the manufacturers for which customers view said product categories or purchase from, from among a plurality of manufacturers providing product information of products of said product categories accessed by said customers, by provision of second display means.
(Appendix 11)
A product purchasing trend analyzing system as set forth in appendix 8, wherein
said system is provided with a customer purchasing trend database for storing information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access, and
said server counts the number of times customers access predetermined product categories in said product information in product category units, stores the counted values in said customer purchasing trend database, reads from said customer purchasing trend database if said customers have purchased products of said product categories and reads which items among a plurality of items showing specifications of said products said customers have accessed, and displays a list comparing, for each product category, the number of times said customers have accessed a plurality of items showing specifications of said products of manufacturers compared with a specific manufacturer among a plurality of manufacturers providing product information of products of said product category which said customer accesses with said specific manufacturer for each manufacturer by provision of a third display means.
(Appendix 12)
A product purchasing trend analyzing system as set forth in appendix 1, wherein the system is provided with a second server separate from said server provided with said acquiring means, and said second server stores information giving a first history as to what products' product information said customers access, a second history as to which products said customers have purchased, and a third history as to which items among a plurality of items showing specifications of said products said customers access and sets the restocking quantities and prices of the products.
(Appendix 13)
A product purchasing trend analyzing system as set forth in appendix 1, which system acquires histories of the times when customers view product information and the times when they purchase said products and obtains statistics on the number of viewings of individual products and how many days after viewing the product information which products were purchased so as to set restocking quantities and restocking dates of individual products based on the histories of said viewing times and said purchasing times.
(Appendix 14)
A program in a product purchasing trend analyzing system for analyzing purchasing trends of products which manufacturers sell in stores,
said program in a product purchasing trend analyzing system characterized by being provided with:
entry means enabling input of product information of said products from said first terminals,
product information display means for sending said product information to and displaying it at said second terminals, and
acquiring means for acquiring histories by which said product information is accessed by said second terminals.
This application is a continuation of, and claims priority from International PCT Application No. PCT/JP2002/007022, filed on Jul. 10, 2002, the contents being incorporated herein by reference,
Number | Date | Country | |
---|---|---|---|
Parent | PCT/JP02/07022 | Jul 2002 | US |
Child | 11030316 | Jan 2005 | US |