JP2702078B2 - Simultaneous sales product search display device and method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus and method for retrieving and displaying simultaneous sales products purchased by a customer together with a certain product.

[0002]

2. Description of the Related Art In the apparel industry, a plurality of stores are sometimes managed by a predetermined department of a sales company called a headquarters. By the way, especially in such a form of apparel, it is important to coordinate a plurality of products such as shirts and pants, for example.
In addition, another product is often purchased at the same time. Therefore,
At each store, various products may be displayed in combination.

[0003]

However, in many cases, the above-mentioned combination of products is displayed at each store in consideration of a unique combination based on the sales situation of the store. As a result, the sales at each store will change even for the same product. Also,
If it is displayed in combination, it is difficult to know whether the combination sold well or whether the single item itself was good and sold well. Displaying them in combination results in waste of display space.

SUMMARY OF THE INVENTION The present invention has been made in view of the above points, and is a simultaneous sales product that enables easy determination of whether or not each product can be combined with another product and, if so, the product to be combined. It is an object to provide a search display device and method.

[0005]

In order to achieve the above object, a simultaneous sales product search and display device according to the present invention comprises a sales information storage means for sequentially storing sales information of products at a store in units of one transaction. And product information storage means for storing information about each product together with its image; and, based on the sales information stored in the sales information storage means, information on co-sold products for any product from the product information storage means. Searching and displaying means for searching and displaying a list of the images together with the images in order of frequency of being sold together.

Further, according to the present invention, there is provided a simultaneous sales product search and display method, wherein information on each product is stored in a product information storage means together with an image thereof, and the sales information storage means stores
The sales information of the merchandise at the store is sequentially stored in units of one transaction, and based on the sales information stored in the sales information storage means, information on co-sold goods for any merchandise is retrieved from the merchandise information storage means. Then, the images are displayed in a list in the order of the frequency of being sold together with the images.

[0007]

In other words, according to the apparatus and method for searching and displaying simultaneous sales products of the present invention, information on each product is stored in the product information storage means together with its image, and the sales information storage means stores the information at the store. Are sequentially stored in units of one transaction. Then, when an arbitrary product is designated, based on the sales information stored in the sales information storage means, a co-sale product for any product, that is, information on a simultaneous sales product, is searched from the product information storage means, Along with the images (for example, reduced images), a list is displayed in ascending frequency, that is, the set ratio is high.

[0008]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a diagram for explaining the concept of the present invention,
FIG. 2 is a diagram showing the configuration of the embodiment.

[0009] In these figures, an apparel maker's headquarters (hereinafter referred to as headquarters) 10, a plurality of stores 20, and a distribution center 30 that perform from clothing manufacturing to sales to general customers.
Have a modem M, and are connected via the public line 40 by the modem M. Here, the distribution center 30 temporarily stores products manufactured at a factory (not shown),
It is an inventory base from which products are delivered to each store 20 as needed. In this embodiment, only one distribution center 30 is provided, but it is needless to say that a plurality of distribution centers 30 may be provided.

The head office 10 is connected to the modem M and has a controller 11 for performing various processes such as data transmission / reception and various database (DB) searches and updates. The controller 11 is connected to a sales DB 12, an inventory DB 13, and a product master DB 14 as a product attribute DB, and a terminal T including a keyboard and a CRT 15 (not shown) as input / output devices. Here, the sales DB 12 stores information such as when and how many products were sold at which stores. In addition, the inventory DB 13 stores information on products (clothes) being produced or scheduled to be produced at a factory (not shown), the products in stock at the distribution center 30, and the number of products in each store 20. I remember. Further, the product master DB 14
The detailed information on all the products handled by the headquarters 10 is stored together with the images of the products.

On the other hand, each store 20 has a controller 21 connected to the modem M and performing various processes such as data transmission / reception and DB updating. The controller 21 is connected to a terminal T including a keyboard, a barcode reader, and a CRT as an input / output device, and a product master DB 22. When sales information of a product is input from the terminal T, it is stored in the sales DB 12 of the headquarters 10 via the public line 40. In this case, as shown in FIG. 1, the sales information is stored for each receipt 23, that is, for each transaction. That is, the receipt No. Is stored in the sales DB 12 in the form of one record with the header as a header. Note that this sales information does not necessarily need to be stored in the sales DB 12 in real time. For example, the sales information is temporarily stored in each store, and is collectively transferred and stored in the sales DB 12 during the night outside business hours. Is also good.

The product master DB 22 stores the above-mentioned headquarters 1
The information necessary for each store 20 in the contents of the merchandise master DB 14 of No. 0 is given through the public line 40 and duplicated.
Necessary information such as a part number is stored. Alternatively, instead of all products, the store may be limited to products handled by the store 20. This product master DB22
Can be searched by the terminal T.

The distribution center 30 has a controller 31 connected to the modem M for performing various processes such as data transmission / reception, and a terminal T including a keyboard and a CRT as an input / output device of the controller 31. I have.

Next, the operation of searching and displaying a list of simultaneously sold products in such a configuration will be described with reference to a series of flowcharts shown in FIGS. That is, when an instruction to search and display a list of simultaneous sales products is input from the terminal T of the headquarters 10, the controller 11 first sets the internal counters N and M to "1" as initial settings (step S).
1).

Next, a set rate of each product is calculated based on the sales information stored in the sales DB 12 for each receipt (step S2). Here, the set rate means that the product is on average with several different products (with the same receipt)
It is a value indicating whether or not sold, that is, a co-sales rate, and is calculated as follows. First, the number of simultaneous purchases of the key products for which the set rate is to be calculated in each receipt 23 is calculated, and the sum of the calculated values is divided by the number of receipts 23 including the key products. The simultaneous purchase points are values obtained by dividing the total sales points indicated on the receipt 23 by the sales points of the key products. For example, in the example of FIG. 1, when a product indicated by a code “12601-38” is considered as a key product for which a set ratio is to be calculated, the receipt No. Since the receipt 23 of 001 includes three items in total, and two of the key items are the key items, the number of simultaneous purchases is 3/2 = 1.5 points, and the receipt number. In the receipt 23 of 004, the number of simultaneous purchases is 4/1
= 4 points, and the receipt No. In the receipt 23 of 015, the number of simultaneous purchases is 1/1 = 1. Therefore, the set ratio is (1.5 + 4 + 1) /3=6.5/3=2.16.
66 ..., for example, rounding off the third decimal place, the set rate becomes 2.17. That is, the set ratio is 1 or more. In this way, the set rate is calculated using each product as a key product. Then, the codes for specifying the products are rearranged in the descending order of the calculated set rates, and stored in a memory (not shown) provided inside the controller 11 in the form of a set rate table (step S).
3).

Next, various data on the N-th product in the set rate table are read from the inventory DB 13 and the product master DB 14 (step S4), and are read out from the sales DB 12 and stored in the set rate table. The data is displayed on the CRT 15 of the terminal T together with certain data (step S5). Here, the display screen 15 of the CRT 15
A is a key product display area 1 for displaying key products.
5a and a list display area 15b for displaying a list of products sold at the same time.
13. The data read from the product master DB 14 is displayed in the key product display area 15a. In this case, if necessary, the image of the key product can be displayed as a reduced image (hereinafter, referred to as a miniature picture) 16a.

Further, regarding the N-th product, sales D
A simultaneous sales product is searched from B12 (step S6),
Sort them in descending order of quantity, that is, in descending order of frequency.
The simultaneous sales product table is stored in a memory (not shown) provided inside the controller 11 (step S7).
Then, various data on the M-th product in this table are read from the inventory DB 13 and the product master DB 14 (step S8), and displayed on the list display area 15b of the CRT 15 (step S9). Also in this case, the miniature picture 16b of the simultaneous sales product is displayed.

Then, after the internal counter M is counted up by "1" (step S10), it is determined whether or not there is a simultaneously purchased product (step S11). FIG.
In the example of (3), a total of nine (3 × 3) simultaneous sales items can be displayed (although the last three are partially displayed). If there are more purchased items, the display can be made by scrolling the display screen. That is, if there are more simultaneous sales commodities, the process returns to step S8, and the above processing is repeated. On the other hand, if there are no more products to be purchased at the same time, the operation waits for an instruction input by the operator.

When an instruction is input from the terminal T (step S
12) First, it is determined whether or not it is an instruction input for displaying a list of the next simultaneous sales products (step S13). If so, the display in the list display area 15b is cleared (step S14), and the process returns to step S8 to repeat the above processing.

On the other hand, if the input is not an instruction to display a list of the next simultaneous sales products, it is determined whether or not the display is to be input for the next key product (step S15). If so, the value of the internal counter N is incremented by "+1", and
After resetting the value of the internal counter M to "1" (step S16), the process returns to step S4 to repeat the above processing.

If it is determined that the input instruction is not a display instruction for the next key product, the end of the process is determined to have been input, and the search and display operation of the simultaneous sales product list is terminated.

As described above, key products and other products with simultaneous sales are searched in descending order of frequency. The searched simultaneous sales products include data such as the number of sales and the number of stocks and product attributes such as colors. In addition to the above, the images are displayed as a list, so that it is possible to intuitively and visually analyze what kind of products are sold together, which is useful for examining a product group at the time of product planning. In addition, when a product that is sold at another store in a specific store 20 is not sold, it is possible to advise the specific store 20 about a product to be displayed in combination with the specific store 20. Since the stock information is also displayed at the same time, it is possible to issue a shipping instruction to the distribution center 30 or a production instruction to a factory (not shown) when the merchandise to be combined is not present in the store. In addition, since the set rate of the key products is also displayed at the same time, it is possible to give an advice not to combine and display products having a very low set rate.

The above-described operation of searching and displaying a list of simultaneously sold products can be performed in the same manner from the terminal T of the store 20 via the public line 40. And the ordering to the headquarters 10 can be considered.

In the display of the list of products sold at the same time,
Data such as the number of sales and inventory, and product attributes such as color,
Although displayed together with the image, information such as items and materials may be further included as product attributes.

Further, even if the set rate is not calculated and sorted each time the simultaneous sales product list search and display instruction is input, the set rate is calculated and sorted based on the data up to the previous day at the start of business hours. Alternatively, each time the instruction is input, it may be used. Similarly, search and sorting of simultaneous sales products for each product may be performed once a day.

Also, instead of sequentially reading and displaying the items in ascending order of the set rate as in the above-described embodiment, an arbitrary product is also designated as a key product and a period of sales is specified, and a list of simultaneously sold products for that product is retrieved and displayed. Needless to say, it may be done. In that case, it is only necessary to perform the processing for the designated key product only, and it goes without saying that the search result is displayed at a higher speed.

In the above-described embodiment, the operator determines which combination of products sells well by looking at the list of simultaneous sales products, but this may be automated. That is, it is possible to focus on a certain product attribute and search and display the attribute that is sold simultaneously with that attribute by rank. For example, if an item is instructed to search and display items purchased at the same time as a shirt,
The product master DB 14, that is, the product attribute DB is searched according to the set rate, and the first place: pants, the second place: jacket,
Third place: Necklace, etc. are displayed, and when a plurality of attributes are specified, for example, a search display of items purchased at the same time as attributes of pants (first attribute) × slim (second attribute) is input. 1st place: Long x jacket, 2nd place:
A line x court,... Are displayed in search. Then, by inputting these detailed display instructions, a list display including a miniature picture as shown in FIG. 5 is made.

[0028]

As described in detail above, according to the present invention,
Provided is a simultaneous sales product search and display apparatus and method that enables the user to easily determine whether or not each product can be combined with other products and to determine the product to be combined when combined, since the parallel sales ranking is indicated with an image. be able to.

[Brief description of the drawings]

FIG. 1 is a diagram for explaining the concept of the present invention.

FIG. 2 is a diagram illustrating a configuration of an embodiment.

FIG. 3 is a diagram showing the first half of a series of flowcharts for explaining a simultaneous sales product search and display operation.

FIG. 4 is a diagram showing a latter half of a series of flowcharts for explaining a simultaneous sales product search and display operation.

FIG. 5 is a diagram showing a display example of a search result.

[Explanation of symbols]

 10: Apparel Maker Headquarters, 11, 21, 31: Controller, 12: Sales DB, 13: Inventory DB, 14: Product Master (Product Attribute) DB, 15: CRT, 15A: Display Screen, 15a: Key Product Display Area, 15b: List display area, 16a, 16b: Reduced image (bean picture), 20: Store, 23: Receipt, 30: Distribution center, 40: Public line, M: Modem, T: Terminal.

 ──────────────────────────────────────────────────続 き Continuation of the front page (56) References JP-A-63-301398 (JP, A) JP-A-64-21571 (JP, A) JP-A-63-95581 (JP, A) JP-A-2- 23464 (JP, A) JP-A-63-12069 (JP, A) JP-A-63-261462 (JP, A) JP-A-6-176270 (JP, A) JP-B 5-44038 (JP, B2)

Claims (3)

(57) [Claims] 1. A sales information storage means for sequentially storing sales information of merchandise in a store in units of one transaction, a goods information storage means for storing information on each commodity together with an image thereof, and the sales information storage means Based on the sales information stored in the search information display means for retrieving information on co-sold merchandise for any product from the merchandise information storage means, and displaying a list of images together with the images in descending order of frequency of co-sale. A simultaneous sales product search and display device, comprising: 2. The simultaneous sales product search and display device according to claim 1, further comprising a parallel sales rate calculation display means for calculating and displaying a parallel sales rate of the arbitrary product based on the sales information. . 3. The merchandise information storage means stores information about each merchandise together with its image, and the sales information storage means sequentially stores sales information of merchandise at the store in units of one transaction. Based on the sales information stored in the sales information storage means, information on co-sold products for any product is retrieved from the product information storage means, and is displayed in a list together with the image in descending order of frequency of co-sale. Characteristic simultaneous sales product search and display method.