JP6863044B2 - Ordering aids and programs - Google Patents

Description

The present invention relates to an order assist device and a program.

Conventionally, it is difficult to predict the purchase of new books, so it is considered that each bookstore has abundant inventory so as not to lose sales opportunities. However, there is a problem of space required for storage and installation at each bookstore, and the current situation is that we cannot have abundant inventory. In addition, if the stock is abundant, there is a problem that the cost of returning the product is incurred.
Therefore, various attempts have been made regarding inventory management of books. For example, based on the purchase data of released products, products that are also sold at other stores are extracted, a purchase supplement product list of the store to be purchased is created, and automatic ordering is performed (). For example, Patent Documents 1 and 2).

Japanese Unexamined Patent Publication No. 2009-265761 Japanese Unexamined Patent Publication No. 2013-238974

All of the items described in Patent Documents 1 and 2 place an order based on past purchase results. Therefore, for example, if there is no past purchase record, the accuracy may be low.

Therefore, an object of the present invention is to provide an ordering assistance device and a program for placing an order with higher accuracy.

The present invention solves the above problems by the following solutions. In addition, in order to facilitate understanding, the description will be given with reference numerals corresponding to the embodiments of the present invention, but the present invention is not limited thereto. Further, the configurations described with reference numerals may be appropriately improved, or at least a part thereof may be replaced with other configurations.

The first invention is an ordering assistance device (1) for adjusting the order quantity of a new book, which is a new book data acquisition means (11) for acquiring bibliographic data including the title of the new book, and a trend word. The trend word acquisition means (13a) to be acquired, the trend word matching means (13a) for collating the title included in the bibliographic data with the trend word acquired by the trend word acquisition means, and the trend word matching means. This is an ordering assistance device including a coefficient determining means (13a) for determining a coefficient used for adjusting the order quantity according to the collation result according to the above.
According to the second invention, in the ordering assisting device (1) of the first invention, the trend word collating means (13a) calculates a matching rate with the trend word in the title, and the coefficient determining means (13a). Is an ordering assistance device characterized in that the coefficient is determined according to the matching rate calculated by the trend word collating means.
The third invention includes a text data acquisition means (13a) for acquiring the text data of the new book in the order assisting device (1) of the second invention, and the trend word collation means (13a) is the title. The ordering assistance device is characterized in that the matching rate with the trend word in the text data is calculated.
In the fourth invention, in any of the ordering assisting devices (1) from the first invention to the third invention, the bibliographic data further includes the publication date of the new book and is acquired by the trend word acquisition means. The trend word storage means (13a) for storing the trend word in association with the occurrence date of the trend word is provided, and the coefficient determining means (13a) has a size of an interval between the publication date and the occurrence date. The ordering assistance device is characterized in that the coefficient is determined according to the above.
The fifth invention is used for determining the order quantity at each bookstore in any of the ordering assistance devices (1) from the first invention to the fourth invention, and the bookstore data storing information about each bookstore. The bookstore data acquisition means (13b) for acquiring the location data of the bookstore from the storage unit (41), and the area matching means (13b) for collating with the location data when the title includes a word indicating the area. The coefficient determining means (13b) is an ordering assistance device characterized in that the coefficient is determined in the bookstore according to the collation result by the regional collation means.
The sixth invention is sales in which the sales data is acquired from the sales data storage unit (42) that stores sales data related to books in any of the ordering assisting devices (1) from the first invention to the fifth invention. The data acquisition means (13c) and the sales analysis means (13c) for analyzing the sales data acquired by the sales data acquisition means are provided, and the coefficient determining means (13c) is based on the analysis result by the sales analysis means. It is an ordering assistance device characterized in that the coefficient is determined accordingly.
According to a seventh invention, in the ordering assistance device (1) of the sixth invention, the bibliographic data includes the author of the new book, and the sales analysis means (13c) analyzes the sales data for each author. It is an ordering assistance device characterized by that.
The eighth invention is the order assisting device (1) of the sixth invention, in which the bibliographic data includes the publisher of the new book, and the sales analysis means (13c) distributes the sales data for each publisher. It is an ordering assistance device characterized by analyzing.
The ninth invention is the order assisting device (1) of the seventh invention or the eighth invention, in which the bibliographic data includes the genre of the newly published book, and the sales analysis means (13c) uses the sales data. It is an ordering assistance device characterized by analyzing by genre.
The tenth invention is used for determining the order quantity at each bookstore in any of the order assist devices (1) from the first invention to the ninth invention, and is used for determining the total order quantity and a plurality of the above-mentioned new publications. Each bookstore is provided with ordering condition data acquisition means (12) for acquiring book-specific data capable of identifying a book from a bookstore terminal (4) provided in each bookstore, and the coefficient determining means (13) is each of the plurality of newly published books. The coefficient is determined, the ratio of each new book to the plurality of new books is calculated based on the coefficient determined by the coefficient determining means, and the total order quantity acquired by the ordering condition data acquisition means is used. The ordering assisting device is provided with an ordering quantity calculating means (14) for calculating an ordering quantity for each of the plurality of newly published books.
The eleventh invention is a program (21a) for operating a computer as an ordering assisting device (1) according to any one of the first to tenth inventions.

According to the present invention, it is possible to provide an ordering assistance device and a program for placing an order with higher accuracy.

It is an overall block diagram of the ordering assistance system which concerns on this embodiment. It is a functional block diagram of the ordering auxiliary server which concerns on this embodiment. It is a flowchart which shows the ordering assistance process in the ordering assistance system which concerns on this Embodiment. It is a figure which shows the display example of the bookstore terminal which concerns on this embodiment. It is a figure which shows the example of the new book selection list as a specific example of the processing in the ordering auxiliary server which concerns on this embodiment. It is a flowchart which shows the adjustment process in the ordering auxiliary server which concerns on this Embodiment. It is a figure which shows the example of the table storage part of the ordering auxiliary server which concerns on this embodiment. It is a figure which shows the example of the table which is stored in the temporary data storage part as a specific example of the processing in the ordering auxiliary server which concerns on this embodiment. It is a figure which shows the example of the table which stores in the temporary data storage part as the specific example of the processing in the ordering auxiliary server which concerns on this embodiment.

Hereinafter, embodiments for carrying out the present invention will be described with reference to the drawings. It should be noted that this is only an example, and the technical scope of the present invention is not limited to this.
(Embodiment)
<Ordering assistance system 100>
FIG. 1 is an overall configuration diagram of the ordering assistance system 100 according to the present embodiment.
FIG. 2 is a functional block diagram of the ordering auxiliary server 1 according to the present embodiment.
The ordering assistance system 100 is used at each bookstore before ordering a new book, and is a system for presenting a highly accurate order quantity for each new book to each bookstore. In the following description, the "bookstore" refers to a real bookstore that actually exists, but may include a so-called online bookstore that can be purchased using the Internet. In addition, "book" means a publication including a book, a magazine, etc., and a newly published book means a newly published book.

As shown in FIG. 1, the ordering assistance system 100 includes an ordering assistance server 1 (ordering assistance device), a bookstore terminal 4, a publisher server 6, a book printing server 7, and a trend word server 9. The ordering auxiliary server 1 is connected to the bookstore terminal 4, the publisher server 6, the book printing server 7, and the trend word server 9 via the communication network N.
The communication network N is, for example, a communication network such as an Internet line.
The ordering auxiliary server 1 may be connected to a communication network (not shown) already used when ordering from a bookstore to a publisher. In that case, the ordering auxiliary server 1 is provided with another communication network that can be connected to the book printing server 7 and the trend word server 9.

<Ordering assistance server 1>
The ordering assistance server 1 is a device that presents the order quantity for each new book at each bookstore.
As shown in FIG. 2, the ordering auxiliary server 1 includes a control unit 10, a storage unit 20, and a communication interface unit 29.
The control unit 10 is a central processing unit (CPU) that controls the entire ordering auxiliary server 1. The control unit 10 appropriately reads and executes the operating system (OS) and the application program stored in the storage unit 20 to cooperate with the above-mentioned hardware and execute various functions.

The control unit 10 includes a new book acquisition unit 11 (new book data acquisition means), an order condition receiving unit 12 (order condition data acquisition means), an adjustment processing unit 13, and an order quantity calculation unit 14 (order quantity calculation means). And a calculation result transmission unit 15.
The new book acquisition unit 11 acquires the bibliographic data of the new book. Bibliographic data includes the title of the new book, publication date, author name, publisher name, genre, etc., book code for identifying the new book (for example, ISBN (International Standard Book Number), etc.), price. , The data including the size of the book. The new book acquisition unit 11 acquires the bibliographic data of the new book from the publisher server 6 of each publisher, for example. The new book acquisition unit 11 may acquire the bibliographic data of the new book from another device such as the bookstore terminal 4 when the bibliographic data of the new book cannot be acquired from the publisher server 6.

The ordering condition receiving unit 12 receives the ordering condition data from the bookstore terminal 4. The order condition data includes the total order quantity and the book code (book specific data) of each new book that the bookstore wishes to place an order for. Here, the new book that the bookstore wishes to order is also referred to as "target book" below.
The adjustment processing unit 13 determines a coefficient used for adjusting the ordered quantity for each target book. The adjustment processing unit 13 includes a trend word processing unit 13a (trend word acquisition means, trend word storage means, text data acquisition means, trend word collation means, coefficient determination means) and a regional processing unit 13b (bookstore data acquisition means, regional collation). A means, a coefficient determining means) and a sales performance processing unit 13c (sales data acquisition means, sales analysis means, coefficient determining means) are provided.

The trend word processing unit 13a determines the coefficient using the trend word. Specifically, the trend word processing unit 13a connects to the trend word server 9 and acquires trend data including the trend word from the trend word server 9. Here, the trend word is a word that indicates a topic of high interest in the world at any given time. In other words, the trend word changes from moment to moment. In addition, the trend data includes a trend word and an occurrence date. The occurrence date is the date when the word is a trend word, and may be the acquisition date of the trend word.

Next, the trend word processing unit 13a calculates the matching rate with the acquired trend word in the title and text data of the target book. Here, for example, when the title of the target book includes the trend word, the trend word processing unit 13a sets the match rate to 100%, and when the title of the target book does not include the trend word, the match rate is set to 100%. Is 0%. Then, when the title of the target book includes a part of the trend word, the trend word processing unit 13a acquires the text data of the target book from the book printing server 7 described later, and the trend in the acquired text data. The match rate is determined according to the number of matches with the word.
Then, the trend word processing unit 13a determines the coefficient according to the calculated matching rate.

The trend word processing unit 13a may acquire a plurality of trend data. Then, when a plurality of trend data are acquired, the trend data may have the rank of each trend word, and the trend word processing unit 13a may use the rank of the trend word. Specifically, when the trend word processing unit 13a includes the trend word in the title of the target book, for example, the coefficient may be weighted according to the order of the trend word. That is, the higher the rank of the trend word processing unit 13a, the larger the coefficient value may be.

Further, the trend word processing unit 13a determines the coefficient according to the size of the interval between the occurrence date of the trend word and the publication date of the target book. The trend word processing unit 13a increases the value of the coefficient on the assumption that the sales of the target book by the trend word are expected as the occurrence date and the publication date are closer.

The regional processing unit 13b determines the coefficient by collating whether or not the location of the bookstore is included in the title of the target book. Here, the bookstore data including the location of the bookstore is stored in, for example, the bookstore data storage unit 41 (see FIG. 1) of each bookstore terminal 4. Therefore, the regional processing unit 13b acquires the bookstore data from the bookstore terminal 4. The bookstore data includes the location of the bookstore, as well as the store code that identifies the bookstore. The location of the bookstore may include not only the address (prefecture, municipality, etc.) but also the name of the nearest station, the common name of the district, and the like.
The regional processing unit 13b collates the title of the target book with the location of the bookstore. Then, the area processing unit 13b determines the coefficient according to the collation result. When the title of the target book includes the location of the bookstore, the regional processing unit 13b increases the value of the coefficient.

The sales record processing unit 13c analyzes the sales data of all bookstores and determines the coefficient. The sales data is stored in, for example, the sales data storage unit 42 (see FIG. 1) of each bookstore terminal 4. Therefore, the sales record processing unit 13c acquires sales data from each bookstore terminal 4.
Then, the sales record processing unit 13c determines the coefficient by, for example, comparing the number of books sold with the same author name as the target book that has been sold in the last one year. In addition, the sales record processing unit 13c determines the coefficient by, for example, comparing the number of books sold with the same publisher name as the target book that has been sold in the last one year. Further, the sales record processing unit 13c may determine the coefficient by, for example, comparing the number of books sold by the author name or the publisher name for each genre with the target book.

The order quantity calculation unit 14 calculates the ratio of each target book to the plurality of target books by using the coefficient calculated by the adjustment processing unit 13. Then, the order quantity calculation unit 14 multiplies the calculated ratio by the total order quantity to calculate the order quantity of each target book.
The calculation result transmission unit 15 transmits the calculation result by the order quantity calculation unit 14 to the bookstore terminal 4.
The details of each process will be described later.

The storage unit 20 is a storage area for programs, data, and the like necessary for the control unit 10 to execute various processes, hardware for storing data, and the like, semiconductor memory elements, and the like.
The storage unit 20 includes a program storage unit 21, a table storage unit 22, an acquisition data storage unit 23, and a temporary data storage unit 24.
The program storage unit 21 is a storage area for storing various programs. The program storage unit 21 stores the ordering assistance program 21a.
The ordering assistance program 21a is a program for performing various functions executed by the control unit 10 of the ordering assistance server 1.
The table storage unit 22 is a storage area for storing various tables used when determining the coefficient. Examples of various tables will be described later.
The acquisition data storage unit 23 is a storage area for storing data acquired by the ordering auxiliary server 1 via the communication network N.
The temporary data storage unit 24 is a storage area for storing data generated and used in the process for determining the coefficient.

The communication interface unit 29 is an interface for communicating with the bookstore terminal 4 and other servers via the communication network N.

<Bookstore terminal 4>
Returning to FIG. 1, the bookstore terminal 4 is a terminal provided in each bookstore and used for order processing of new books and the like. The bookstore terminal 4 transmits / receives data regarding the order quantity of new books to / from the ordering assistance server 1. Further, the bookstore terminal 4 transmits the bookstore data to the ordering assistance server 1. Further, the bookstore terminal 4 transmits the sales data of the book to the ordering assistance server 1. In order to transmit the sales data, the bookstore terminal 4 may be connected to a POS (Point Of Sales) terminal (not shown) by communication, or the bookstore terminal 4 may have a function of a POS terminal.
The bookstore terminal 4 may be a general personal computer (PC), and includes a control unit, a storage unit, a communication interface unit, a display unit, an input unit, and the like (none of which are shown).

The storage unit of the bookstore terminal 4 includes a bookstore data storage unit 41 and a sales data storage unit 42.
The bookstore data storage unit 41 is a storage area for storing bookstore data.
The sales data storage unit 42 is a storage area for storing sales data of books. The sales data includes, for example, a sales date, a book code, and a store code. Further, the bookstore terminal 4 may have a bibliographic data storage unit (not shown) that stores a plurality of bibliographic data.
The bookstore data storage unit 41 and the sales data storage unit 42 are not stored in the bookstore terminal 4, and a bookstore management device (not shown) that bundles a plurality of bookstore terminals 4 stores information on the plurality of bookstore terminals 4. You may also memorize it.

<Publisher server 6>
The publisher server 6 is a server provided in each publisher. For example, the publisher server 6 transmits the bibliographic data of the new book to the ordering auxiliary server 1, so that the ordering auxiliary server 1 can acquire the bibliographic data of the new book.
The publisher server 6 includes a book data storage unit 61.
The book data storage unit 61 is a storage area for storing data related to books including newly published books. The book data storage unit 61 stores bibliographic data.

<Book printing server 7>
The book printing server 7 is provided in, for example, a printing company that prints a new book, and is connected to a printer or the like (not shown) for printing by communication.
The book printing server 7 includes a book printing data storage unit 71.
The book print data storage unit 71 is a storage area for storing data for printing a new book. The book print data storage unit 71 stores at least the title and text data of the new book. Then, for example, the book printing server 7 transmits the title and text data of the new book to the ordering auxiliary server 1, so that the ordering auxiliary server 1 can acquire the title and text data of the new book. ..

<Trend word server 9>
The trend word server 9 is a server that stores trend data including the trend word. The trend word server 9 acquires, for example, a search word acquired by a plurality of Web servers (not shown) operating a search site by an automatic patrol robot called a crawler as a trend word.
The trend word server 9 includes a trend data storage unit 91.
The trend data storage unit 91 stores the trend words that are higher in the search words in association with the rank and the date of occurrence.

The publisher server 6, the book printing server 7, and the trend word server 9 each include a control unit, a storage unit, a communication interface unit, and the like (none of which are shown).
A computer is an information processing device provided with a control device, a storage device, and the like. The ordering auxiliary server 1, the bookstore terminal 4, the publisher server 6, the book printing server 7, and the trend word server 9 are control units, respectively. , An information processing device equipped with a storage unit, etc., and is included in the concept of a computer.

<Processing of ordering assistance system 100>
Next, the processing of the ordering assistance system 100 will be described.
FIG. 3 is a flowchart showing an ordering assistance process in the ordering assistance system 100 according to the present embodiment.
FIG. 4 is a diagram showing a display example of the bookstore terminal 4 according to the present embodiment.
FIG. 5 is a diagram showing an example of a newly published book selection list 50 as a specific example of processing in the ordering auxiliary server 1 according to the present embodiment.
FIG. 6 is a flowchart showing an adjustment process on the ordering auxiliary server 1 according to the present embodiment.
FIG. 7 is a diagram showing an example of the table storage unit 22 of the ordering assistance server according to the present embodiment.
8 and 9 are diagrams showing an example of a table stored in the temporary data storage unit 24 as a specific example of the processing in the ordering auxiliary server according to the present embodiment.

When placing an order at each bookstore, for example, the clerk operates the bookstore terminal 4 in the bookstore to select an icon (not shown) for performing ordering assistance processing.
By doing so, in step S (hereinafter, simply referred to as “S”) 10 of FIG. 3, the control unit of the bookstore terminal 4 transmits the screen request data to the ordering auxiliary server 1.
In S11, the control unit 10 (new book acquisition unit 11) of the ordering assistance server 1 acquires the bibliographic data of the new book from each publisher server 6 in response to receiving the screen request data. Then, the control unit 10 stores the acquired bibliographic data of the newly published book in the acquired data storage unit 23.

In S12, the control unit 10 generates ordering support input screen data using the acquired bibliographic data, and transmits the generated ordering support input screen data to the bookstore terminal 4.
In S13, the control unit of the bookstore terminal 4 receives the ordering support input screen data, and causes the display unit of the bookstore terminal 4 to display the ordering support input screen 30.

FIG. 4A shows an example of the ordering support input screen 30 displayed on the bookstore terminal 4. The ordering support input screen 30 includes a total order quantity input unit 30a, a new book selection unit 30b, and buttons 30c and 30d.
The total order quantity input unit 30a is an input area for inputting the total order quantity.
The new book selection unit 30b outputs the bibliographic data of the new book in a list format, and has a check box capable of selecting a plurality of new books.
The button 30c is a button for transmitting the ordering condition data generated from the input value of the ordering support input screen 30 to the ordering assistance server 1. The button 30d is a button for ending the ordering assistance process.

The clerk inputs the total order quantity in the total order quantity input unit 30a of the order support input screen 30, and selects a plurality of new books to be ordered in the new book selection unit 30b. Here, by displaying the size of the book in the new book selection unit 30b, the clerk can select the target book in consideration of the empty space of the store and the size of the book. In the case of an online bookstore, the empty space in the warehouse or other place where inventory is stored and the size of the book will be taken into consideration.
In addition, when there is only one type of new book for which an order is desired, the total order quantity may be ordered as the title, and there is no need to use this system. In that case, the clerk selects the button 30d, and the ordering assistance system 100 ends this process.
Then, as described above, the store clerk inputs each item of the ordering support input screen 30, and then selects the button 30c. In S14, the control unit of the bookstore terminal 4 assists the ordering condition data with the ordering condition data. Send to server 1.

In S15, the control unit 10 (ordering condition receiving unit 12) of the ordering auxiliary server 1 receives the ordering condition data. Then, the control unit 10 generates, for example, the new book selection list 50 shown in FIG. 5 based on the received order condition data, and stores it in the temporary data storage unit 24.
This new book selection list 50 relates to a target book of a certain bookstore (hereinafter referred to as bookstore X). The new book selection list 50 has bibliographic data on four titles of new books. As the bibliographic data, the data acquired in S11 of FIG. 3 and stored in the acquired data storage unit 23 is used.
Returning to FIG. 3, in S16, the control unit 10 (adjustment processing unit 13) performs the adjustment processing.

Here, the adjustment process will be described with reference to FIG.
In S30 of FIG. 6, the control unit 10 (trend word processing unit 13a) communicates with the trend word server 9 and acquires trend data. Then, the control unit 10 stores the acquired trend data in the acquired data storage unit 23.
In S31, the trend word processing unit 13a determines a coefficient using the trend word.

Hereinafter, the processing will be described in detail with reference to the specific example of FIG.
When the trend word processing unit 13a acquires "Article 9 of the Constitution" as a trend word, the new book 50a in FIG. 5 includes the trend word in the title. Therefore, the trend word processing unit 13a sets the matching rate of the trend word to the newly published book 50a to 100%.
Further, for example, when the title of a new book includes "Constitution" or "Article 9", the trend word processing unit 13a indicates the number of appearances of the trend word "Article 9" with respect to the text data of the target book. Is calculated, and the match rate is determined by the number of appearances.

Here, another example will be used to describe in detail the determination of the match rate.
Similar to the above example, when the trend word is "Article 9 of the Constitution", it is assumed that there is a new book with the following titles.
(A) "The future of Article 9 of the Constitution"
(B) "The future of the Constitution"
(C) "Illustrated Constitution"
(D) "Revision of" Article 9 ""
(E) "Chinese martial arts to learn with the body"

In the case of this example, (A) has a matching rate of 100% because the title includes all the trend words "Article 9 of the Constitution".
The titles of (B) and (C) include "Constitution" which is a part of the trend word. In such a case, the trend word processing unit 13a sets the ratio of the number of characters in the matching character string in the title divided by the number of characters in the trend word as the matching rate. For (B) and (C), the match rate is 50%, which is obtained by dividing 2 which is the number of character strings of "Constitution" by 4 which is the number of character strings of "Article 9 of the Constitution".
In (D), the title includes "Kujo" which is a part of the trend word. Therefore, the match rate of (D) is 50%, which is obtained by dividing 2 which is the number of character strings of "Article 9" by 4 which is the number of character strings of "Article 9 of the Constitution".
In (E), since the title does not include the trend word, the match rate is 0%.

Next, the superiority and inferiority of (B), (C), and (D) having a matching rate of 50% are compared using the text data.
The trend word processing unit 13a confirms how much "Article 9 of the Constitution" appears in the text data.
Here, the word "Article 9 of the Constitution" appears 190 times in the text data of (B), the word "Article 9 of the Constitution" appears 150 times in the text data of (C), and the text of (D). Consider the case where the data does not include the word "Article 9 of the Constitution", that is, it appears 0 times.
Next, the trend word processing unit 13a calculates the matching rate using the text data. The match rate using the text data shall be expressed by the following formula using the match rate of the title and the number of appearances in the text data.

Using the above formula, the matching rate of (B) can be calculated as 50% × 190/190 = 50%.
Further, the matching rate of (C) can be calculated as 50% × 150/190 = 39%, and the matching rate of (D) can be calculated as 50% × 0/190 = 0%.

When the match rate is determined, the trend word processing unit 13a refers to the word match rate table 22a shown in FIG. 7 (A). The word match rate table 22a is a table stored in the table storage unit 22 and showing the relationship between the match rate and the coefficient.
Returning to the specific example of FIG. 5, the trend word processing unit 13a sets the coefficient of the new book 50a that 100% matches the trend word to "1.2", and sets the coefficient related to the matching rate of the new books 50b to 50d that does not match the trend word. Is set to "1".
If the matching rate is 39% as in the above-mentioned example for determining the matching rate, the coefficient is adjusted to the ratio according to the matching rate. Therefore, for example, "1.08" is used up to the second decimal place. Etc.
When the coefficient for the matching rate with the trend word is determined, the control unit 10 generates the coefficient storage table 55 as shown in FIG. 8 and stores the determined coefficient for each book code (see line 55a).

In addition, the trend word processing unit 13a calculates the interval between the publication date of the new book 50a and the occurrence date of the trend word "Article 9 of the Constitution". Here, when the occurrence date of "Article 9 of the Constitution" is "April 8", the publication date of the new book 50a is "April 10" (see FIG. 5), so that the trend word processing unit 13a , Calculate the interval as "2 days".
When the interval between the occurrence date and the publication date of the trend word is calculated, the trend word processing unit 13a refers to the word date matching table 22b shown in FIG. 7B. The word date matching table 22b is a table stored in the table storage unit 22 and showing the relationship between the interval and the coefficient.
The trend word processing unit 13a sets the coefficient related to the interval between the publication dates of the new books 50b to 50d that do not match the trend word to "1", and sets the coefficient of the new books 50a that matches the trend word to "1.2". ..
When the coefficient for the interval between the occurrence date and the publication date of the trend word is determined, the control unit 10 stores the determined coefficient in the coefficient storage table 55 of FIG. 8 for each book code (see line 55b).

Returning to FIG. 6, in S32, the control unit 10 (regional processing unit 13b) acquires the bookstore data from the bookstore terminal 4 of the bookstore X. Then, the control unit 10 stores the acquired bookstore data in the acquired data storage unit 23.
In S33, the regional processing unit 13b determines a coefficient using the location of the bookstore.
When the bookstore X is in "Tokyo", the new book 50c in FIG. 5 includes "Tokyo" in the title. Therefore, the regional processing unit 13b determines that the new book 50c contains matching regional information. Further, the regional processing unit 13b determines that the newly published books 50a, 50b and 50d do not include matching regional information.

When it is determined whether or not the matching regional information is included, the regional processing unit 13b refers to the regional collation table 22c shown in FIG. 7 (C). The area collation table 22c is a table stored in the table storage unit 22 and showing the relationship between the collation result between the location of the bookstore and the title and the coefficient.
The regional processing department 13b sets the coefficient of the new book 50c whose title matches the location of the bookstore to "1.2", and sets the coefficient of the new books 50a, 50b and 50d whose title does not match the location of the bookstore to "1". And.
When the coefficient is determined using the collation result between the location of the bookstore and the title, the control unit 10 stores the determined coefficient in the coefficient storage table 55 of FIG. 8 for each book code (see line 55c).

Returning to FIG. 6, in S34, the control unit 10 (sales record processing unit 13c) acquires sales data from the bookstore terminals 4 of all bookstores. Here, the control unit 10 acquires, for example, sales data for the latest one year from each bookstore terminal 4. Then, the control unit 10 stores the acquired sales data in the acquired data storage unit 23.
The control unit 10 may separately provide an acquisition sales data storage unit in the storage unit 20 and store the acquired sales data in the acquisition sales data storage unit. Then, the control unit 10 may acquire the difference sales data from each bookstore terminal 4 and update the acquired sales data storage unit each time this processing is performed.

In S35, the control unit 10 (sales record processing unit 13c) determines a coefficient using the sales record based on the sales data.
In this example, as the coefficient using the sales record, the coefficient using the sales record is calculated from four different viewpoints by author, by publisher, by author and genre, and by publisher and genre.

The sales record processing unit 13c aggregates the acquired sales data by author of the new book selection list 50. Specifically, the sales record processing unit 13c generates an author-specific table 51a as shown in FIG. 9A in the temporary data storage unit 24. At this time, the monthly average number of books sold and the coefficient are blank. Then, the sales record processing unit 13c aggregates the number of books sold by author using the sales data for the last one year, calculates the monthly average number of books sold, and updates the table 51a by author. Next, the sales record processing unit 13c obtains an average value from the monthly average number of books sold by each author, calculates the ratio of the monthly average number of books sold by each author to the average value as a coefficient, and updates the table 51a for each author.

In addition, the sales record processing unit 13c aggregates the acquired sales data for each publisher of the new book selection list 50. Specifically, the sales record processing unit 13c generates a publisher-specific table 51b as shown in FIG. 9B in the temporary data storage unit 24. At this time, the average number of books sold on the first day and the coefficient are blank. Then, the sales record processing unit 13c aggregates the number of books sold on the first day of each book by publisher, calculates the average number of books sold on the first day, and updates the table 51b by publisher, using the sales data for the last one year. Next, the sales performance processing unit 13c obtains an average value from the average number of books sold on the first day of each publisher, calculates the ratio of the average number of books sold on the first day of each publisher to the average value as a coefficient, and sets the table 51b for each publisher. Update.

Further, the sales record processing unit 13c aggregates the acquired sales data by author and genre of the new book selection list 50, and displays the temporary data storage unit 24 by author by genre as shown in FIG. 9C. Generate table 51c. Further, the sales record processing unit 13c aggregates the acquired sales data by publisher and genre of the new book selection list 50, and displays the acquired sales data in the temporary data storage unit 24 by publisher genre as shown in FIG. 9 (D). Another table 51d is generated. These are calculated and the table is updated by the same processing as described above.
When the coefficient for each sales record is determined, the control unit 10 stores the determined coefficient in the coefficient storage table 55 of FIG. 8 for each book code (see line 55d).
After that, the control unit 10 ends this process and shifts the process to FIG.

Returning to FIG. 3, in S17, the control unit 10 (order quantity calculation unit 14) calculates the order quantity of each target book from each ratio of the target books and the total order quantity.
Specifically, the order quantity calculation unit 14 calculates the average coefficient from the coefficient for each target book stored in the coefficient storage table 55 of FIG. Then, the order quantity calculation unit 14 calculates the ratio for each target book based on the average coefficient (see line 55e).
Here, in this example, the average coefficient is used for calculating the ratio, but for a coefficient having a high importance, the coefficient may be weighted. For example, if the coefficient for the trend word is important, the coefficient for the trend word may be weighted.
Then, the order quantity calculation unit 14 calculates the order quantity of each of the target books by multiplying the total order quantity by the ratio. The order quantity calculation unit 14 performs rounding so that the calculated order quantities of the target books are added together to obtain the total order quantity.

In S18, the control unit 10 (calculation result transmission unit 15) generates result screen data including the order quantity of each target book which is the calculation result, and transmits the result screen data to the bookstore terminal 4. After that, the control unit 10 ends this process.
In S19, the control unit of the bookstore terminal 4 receives the result screen data and causes the display unit to display the result screen 31.
FIG. 4B shows an example of the result screen 31 displayed on the bookstore terminal 4. The clerk of the bookstore X can perform the order processing by looking at the result screen 31 and inputting the order quantity of the target book into, for example, a separately prepared ordering system.
After that, the control unit of the bookstore terminal 4 ends this process.

As described above, the ordering auxiliary server 1 of the present embodiment has the following effects.
(1) The title of the new book is collated with the trend word, and the coefficient used for adjusting the ordered quantity is determined according to the collation result. Then, the determined coefficient is used for adjusting the ordered quantity. Here, books containing trend words in their titles are generally of interest to customers and are likely to be purchased. Therefore, by increasing the order quantity of new books containing the trend word in the title, it is possible to eliminate the loss of sales opportunities and reduce the risk of returns. As a result, the calculated order quantity can be made more accurate.

(2) Since the coefficient is determined according to the matching rate between the title of the new book and the trend word, not only all of the trend words match, but also some of the trend words match according to the matching rate. The coefficient can be determined. At that time, by using not only the title but also the text data, for example, the matching rate can be increased for the text containing all of the trend words and the title being a part of the trend words. Further, for example, the matching rate can be lowered for a text that does not include a trend word and whose title is a part of the trend word. Therefore, the coefficient to be calculated can be made to reflect the actual contents of the book.
(3) Determine the coefficient according to the size of the interval between the date of occurrence of the trend word and the date of publication of the new book. If the date of occurrence of the trend word and the date of publication of the new book are different, it is possible that the trend word is not trending at the time of publication, but this can be taken into consideration.

(4) The title of the new book is collated with the location of the bookstore, and the coefficient used for adjusting the ordered quantity is determined according to the collation result. Therefore, if the title includes the location of the bookstore, the order quantity can be adjusted a lot.
(5) Since the coefficient is determined based on the past sales data, the coefficient can reflect the sales by the author or publisher of the new book.
(6) Since the total order quantity and the new book data for which an order is desired are acquired from the bookstore, the order quantity of each new book is calculated and output, the bookstore can place an order using the output result. it can.

Although the embodiments of the present invention have been described above, the present invention is not limited to the above-described embodiments. In addition, the effects described in the embodiments are merely a list of the most suitable effects arising from the present invention, and the effects according to the present invention are not limited to those described in the embodiments. The above-described embodiment and the modified form described later can be used in combination as appropriate, but detailed description thereof will be omitted.

(Transformed form)
(1) In the present embodiment, the sales record is based on the monthly average number of books, but is not limited to this. For example, it may be based on the average number of books sold on the first day. This is effective because the order quantity can be calculated using the sales record of the first day of the new book. In addition, although the explanation has been made using the sales results of the last one year as an example, the description is not limited to this. Further, as the sales performance, the results of analysis from four different viewpoints are used, but the results may be more or less than that, or the results of analysis from different viewpoints may be used. Furthermore, the sales amount may be used instead of the number of books.

(2) In the present embodiment, a method of determining the matching rate with the trend word has been described by showing a specific example, but the present invention is not limited to this. If the coefficient of the book is large when the trend word is included, the matching rate with the trend word may be calculated by using another calculation formula or the like.
(3) In the present embodiment, the case where the trend word and the title are collated and the text data is collated to determine the matching rate has been described as an example, but the present invention is not limited to this. If the data of the content printed on the strip of the book can be obtained from the book printing server, the data may be collated with the trend word and used for determining the matching rate. By doing so, it is possible to increase the value of the coefficient when the trend word is included in what is described in a place that is noticeable to the customer.

(4) In the present embodiment, the result screen for outputting the total order quantity and the order quantity of a plurality of selected target books has been described as an example, but the present invention is not limited to this. For example, advice on the display method may be output together with the ordered quantity. As advice on the display method, for example, if the coefficient of the trend word is high, it is better to use "flat stacking" or "face display" according to the ordered quantity.
(5) In the present embodiment, the case where the ordering process is performed after the ordering auxiliary server processes the ordering process in the previous stage has been described as an example, but the present invention is not limited to this. This function may be incorporated into an existing order processing system.

(6) In the present embodiment, it has been described that the ordering auxiliary server acquires various data from each server and the bookstore terminal connected via the communication network and performs processing, but the present invention is not limited to this. The various acquired data may be stored in the storage unit of the ordering auxiliary server, and the processing may be performed using the various data stored in the storage unit of the ordering auxiliary server.
(7) In the present embodiment, the use as supporting the order processing in the bookstore has been described, but the present invention is not limited to this. For example, each publisher may use this ordering assistance system when determining the ratio of the circulation of the first edition to a plurality of new books.

1 Ordering assistance server 4 Bookstore terminal 6 Publisher server 7 Book printing server 9 Trend word server 10 Control unit 11 New book acquisition unit 12 Ordering condition receiving unit 13 Adjustment processing unit 13a Trend word processing unit 13b Regional processing unit 13c Sales record processing Department 14 Order quantity calculation unit 20 Storage unit 21a Ordering assistance program 22 Table storage unit 23 Acquisition data storage unit 41 Bookstore data storage unit 42 Sales data storage unit 61 Book data storage unit 71 Book print data storage unit 91 Trend data storage unit 100 Ordering Auxiliary system

Claims (11)

It is an ordering assistance device for adjusting the order quantity of new books.
New book data acquisition means for acquiring bibliographic data including the title of the new book for each of the multiple new books to be ordered,
How to get a trend word and how to get a trend word
A trend word collating means for collating the title included in the bibliographic data with the trend word acquired by the trend word acquiring means.
A coefficient determining means for determining a coefficient used for adjusting the order quantity for each of the plurality of newly published books to be ordered according to the collation result by the trend word matching means.
Ordering assistance device equipped with. In the ordering assistance device according to claim 1,
The trend word collating means calculates the matching rate with the trend word in the title, and calculates the matching rate.
The coefficient determining means determines the coefficient according to the matching rate calculated by the trend word matching means.
An ordering assistance device characterized by. In the ordering assistance device according to claim 2,
It is equipped with a text data acquisition means for acquiring the text data of the new book.
The trend word collating means calculates the matching rate with the trend word in the title and the text data.
An ordering assistance device characterized by. In the ordering assistance device according to any one of claims 1 to 3.
The bibliographic data further includes the publication date of the new book.
A trend word storage means for storing the trend word acquired by the trend word acquisition means in association with the occurrence date of the trend word is provided.
The coefficient determining means determines the coefficient according to the size of the interval between the publication date and the occurrence date.
An ordering assistance device characterized by. In the ordering assistance device according to any one of claims 1 to 4.
It is used to determine the quantity ordered at each bookstore.
Bookstore data acquisition means for acquiring bookstore location data from the bookstore data storage section that stores information about each bookstore,
When the title contains a word indicating a region, a regional collation means for collating with the location data and
With
The coefficient determining means determines the coefficient in the bookstore according to the collation result by the regional collation means.
An ordering assistance device characterized by. In the ordering assistance device according to any one of claims 1 to 5.
A sales data acquisition means for acquiring the sales data from the sales data storage unit that stores sales data related to books, and
A sales analysis means that aggregates the sales data acquired by the sales data acquisition means for each type of bibliographic data of the new book, and a sales analysis means.
With
The coefficient determining means determines the coefficient according to the aggregation result by the sales analysis means.
An ordering assistance device characterized by. In the ordering assistance device according to claim 6,
The bibliographic data includes the authors of the new books.
The sales analysis means aggregates the sales data for each author.
An ordering assistance device characterized by. In the ordering assistance device according to claim 6,
The bibliographic data includes the publishers of the new books.
The sales analysis means aggregates the sales data for each publisher.
An ordering assistance device characterized by. In the ordering assistance device according to claim 7 or 8.
The bibliographic data includes the genre of the new book.
The sales analysis means aggregates the sales data for each genre.
An ordering assistance device characterized by. In the ordering assistance device according to any one of claims 1 to 9.
It is used to determine the quantity ordered at each bookstore.
It is provided with an order condition data acquisition means for acquiring the total order quantity and the book identification data capable of identifying a plurality of the new books from the bookstore terminal provided in each bookstore.
The coefficient determining means determines the coefficient for each of the plurality of newly published books.
Based on the coefficient determined by the coefficient determining means, the ratio of each new book to the plurality of new books is calculated, and the total order quantity acquired by the ordering condition data acquisition means is used to obtain the plurality of new books. Provide an order quantity calculation means for calculating the order quantity for each,
An ordering assistance device characterized by. A program for operating a computer as an ordering assisting device according to any one of claims 1 to 10.

Images