JP2011192158A - Book information processing system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a book sales management system for reflecting product data newly sold by a publisher or the like to a database of an agent or the like. <P>SOLUTION: The book sales management system 1000 is provided for connecting a publisher, a bookstore, an agent, and a management headquarter to manage distribution of products including books. The book sales management system 1000 includes: a user database for storing user information which includes attribute information and identification information about a user; and a product database 112 for storing the product information about the product including books. Also, the book sales management system 1000 includes a new product registration part for receiving input of new product registration data from the publisher, associates the new product registration data with the user information, and then adds them to the product database 112. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a book information processing system.

  Recently, AMAZON. com's commercial success of the Internet book sales system, and also AMAZON. com, an e-book terminal “Kindle” and Apple Inc. The distribution environment of the publishing industry, the agency industry, and the bookstore industry in Japan and the world is changing drastically under the influence of the electronic book terminal “iPad” to be released.

  For this reason, the publishing industry, agency industry, and bookstore industry in Japan urgently introduced a sales management system and electronic book distribution system for products including books, CDs, DVDs, Blu-ray discs, stationery, etc., using the Internet and other electronic networks. It is out.

  Among these, “Publine” provided by Kinokuniya, a leading company in the Japanese bookstore industry, is a POS born from Kinokuniya's solid information technology and rich experience, as shown in Figs. It is a data / online service that has evolved in response to user support and has become an information tool indispensable to the publishing industry.

  On the other hand, many other companies are developing various systems in response to drastic changes in the distribution environment in the publishing industry, agency industry, and bookstore industry. For example, in Patent Document 1, various information such as the accurate sales situation and inventory situation of the market are shared through a network by bookstores, distributors, and publishers, and appropriate duplication, distribution, and opportunity loss are reported. A book information management system for preventing, increasing sales and reducing returns is described.

  In Patent Document 2, the bookstore side can search the book information on the publisher side and can easily select the book to be supplemented. On the publisher side, the replenishment order specified by each publisher is provided. A book ordering system for enabling a book to be sent is described. Further, in Patent Document 3, the user registers search conditions for a desired book, and the system searches for book information and presents a candidate book list, thereby eliminating the need for the user to search for the desired book. A book purchasing system is described.

  Further, Patent Literature 4 describes a book sales system for making a sales reservation from one book to be sold in the future, such as a specific number in periodicals. Further, Patent Document 5 describes a book collection information processing system for reducing the work burden on a bookstore involved in ordering books and improving the efficiency of the work. Further, Patent Document 6 describes a reprint recommendation processing system for recommending the number of reprints in a timely manner so as to minimize loss due to return, disposal, and sales opportunity loss of books.

JP 2002-7664 A JP 2003-256696 A JP 2004-178076 A JP 2004-303132 A JP 2006-323684 A JP 2008-282269 A

  However, the prior art described in the above literature has room for improvement in the following points.

  First, “Publish” provided by Kinokuniya is an advanced system, but it is a system specialized in providing sales data and the like, so it is difficult to use it for other purposes as it is.

  Second, the systems described in Patent Documents 1 to 6 are not provided with a sales promotion function, and flexibly promote sales to bookstores or consumers while browsing sales data such as “Publish” described above. It is difficult to verify the results of the promotion, provide feedback, and further improve the promotion strategy. Also, there is no function to maintain the trust of the entire system by checking the sales promotion information entered by publishers etc. once at the administrative headquarters and then delivering appropriate sales promotion information to bookstores or consumers. It is also difficult to reduce the risk that some publishers will use the system inappropriately.

  Thirdly, in the systems described in Patent Documents 2 to 6, when a publisher newly releases a new publication, new publication information must be registered with the subsidiary company based on the new publication information input format of each agency company with different standards. In other words, it is difficult to reduce the labor for launching a new publication. In addition, when correcting the book information for a book that has already been released, the correction information must be registered with the agency based on the correction format of each agency with different standards. It is difficult to reduce the effort to correct information.

  The present invention has been made in view of the above circumstances, and product data newly released by publishers and their correction data can be collectively reflected in a database of a store, etc., and publishers can sell products. While confirming the situation, it is possible to flexibly promote sales to bookstores or consumers and verify the results of the promotion, while risking that some publishers use the system inappropriately. An object of the present invention is to provide a book sales management system that can be reduced.

  ADVANTAGE OF THE INVENTION According to this invention, the book sales management system for managing the distribution of the goods containing a book by connecting a publisher, a bookstore, an agency, and the management headquarters is provided. The book sales management system includes a user database that stores user information including user attribute information and identification information, and a product database that stores product information related to products including books.

  In addition, this book sales management system accepts input of new product registration data from publishers, adds new product registration data to the product database after associating it with user information, and is independent of the book sales management system. A new product registration unit is provided for adding new product registration data to an agency product database of an agency.

  The book sales management system also accepts extraction or editing data for specific product information contained in the product database from a publisher, extracts specific product information from the product database based on the extraction command, and accepts editing data. In this case, a product information browsing / editing unit for reflecting the edited data in the product database and reflecting it in the agency product database is provided.

  In addition, this book sales management system accepts sales / reservation trend extraction commands for specific products included in the product database from publishers or administration headquarters, and sales / reservation trends provided independently of the book sales management system. A sales / reservation trend data extraction unit is provided for extracting sales / reservation trend information of a specific product from the database.

  In addition, the book sales management system accepts sales promotion information of a specific product included in the product database from a publisher, adds the sales promotion information to the product information of the specific product, associates it with the product information of the specific product, and further sells the product. A sales promotion information registration unit for notifying the sales promotion information distribution unit of addition of promotion information is provided.

  In addition, the book sales management system receives a notification of sales promotion information from the sales promotion information registration unit, prompts the management headquarters to approve the distribution of the sales promotion information, and distributes the sales promotion information when the approval is accepted. A sales promotion information distribution unit is provided.

  According to this configuration, since a new product registration unit and a product information browsing / editing unit are provided, product data newly released by publishers and the correction data thereof can be collectively reflected in a database of a store, etc. It is possible to reduce the labor required for companies to register new book information and to modify already-book information.

  In addition, according to this configuration, since the sales / reservation trend data extraction unit and the sales promotion information registration unit are provided, publishers and the like can flexibly promote sales to bookstores or consumers while checking the sales status of products. And the results of the promotion can be verified. Therefore, while browsing sales data such as “Publine” as described above, sales promotion is flexibly performed for bookstores or consumers, the results of the sales promotion are verified, feedback is given, and the sales promotion strategy is further improved. It is possible to continue.

  Further, according to this configuration, since the sales promotion information distribution unit is provided, the sales promotion information input by the publisher or the like can be checked once by the management headquarters, and then appropriate sales promotion information can be delivered to the bookstore or the consumer. . As a result, it is possible to reduce the risk that some publishers use the system inappropriately, and maintain the trust of the entire system.

It is a conceptual diagram for demonstrating the function of "Public" which a conventionally well-known Kinokuniya bookstore provides. It is a functional block diagram for demonstrating the structure of "Publine" which a conventionally well-known Kinokuniya bookstore provides. It is a conceptual diagram for demonstrating the structure in which the product data which a publisher etc. newly sells, and its correction data are reflected in the database of a store etc. collectively using the book sales management system of embodiment. To explain a mechanism in which a publisher or the like makes a sales promotion to a bookstore or a consumer flexibly while confirming the sales status of a product and verifies the sales promotion result by using the book sales management system of the embodiment. FIG. It is a functional block diagram for demonstrating the whole structure of the book sales management system of embodiment. It is a table for demonstrating the data structure of the user database in the book sales management system of embodiment. It is a table for demonstrating the data structure of the goods database in the book sales management system of embodiment. It is a user interface for demonstrating the function of the login part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the login part in the book sales management system of embodiment. It is a user interface for demonstrating the function of the input reception part in the book sales management system of embodiment. It is a user interface for demonstrating the registrant information of the new goods registration part in the book sales management system of embodiment, and the input function of an agency. It is a user interface for demonstrating the input function of the merchandise information of the new merchandise registration part in the book sales management system of embodiment. It is a user interface for demonstrating the input function of the reservation information of the new goods registration part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the new goods registration part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the essential input item request | requirement part in the book sales management system of embodiment. It is a table for demonstrating the data structure of the essential input matter memory | storage part in the book sales management system of embodiment. It is a user interface for demonstrating the function of the merchandise information browsing / editing part in the book sales management system of embodiment. It is a user interface for demonstrating the registrant information of the merchandise information browsing / editing part in the book sales management system of embodiment, and the input function of an agency. It is a user interface for demonstrating the input function of the merchandise information of the merchandise information browsing / editing part in the book sales management system of the embodiment. It is a functional block diagram for demonstrating the structure of the merchandise information of the merchandise information browsing / editing part in the book sales management system of embodiment. It is a user interface for demonstrating the basic information extraction function of the sales and reservation trend data extraction part in the book sales management system of embodiment. It is a user interface for demonstrating the sales promotion effect measurement function of the sales and reservation trend data extraction part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the sales and reservation trend data extraction part in the book sales management system of embodiment. It is a user interface for demonstrating the list function of the sales promotion information registration part in the book sales management system of embodiment. It is a user interface for demonstrating the various information registration function of the sales promotion information registration part in the book sales management system of embodiment. It is a user interface for demonstrating the DM dispatch condition registration function of the sales promotion information registration part in the book sales management system of embodiment. It is a user interface for demonstrating the reservation receipt slip registration function of the sales promotion information registration part in the book sales management system of embodiment. It is a user interface for demonstrating the missing message registration function of the sales promotion information registration part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the sales promotion information registration part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the sales promotion information delivery part in the book sales management system of embodiment. It is a table for demonstrating the data structure of the consumer database connected to the book sales management system of embodiment. It is a user interface for demonstrating the sales promotion result analysis function of the sales and reservation trend data extraction part in the book sales management system of embodiment. It is a functional block diagram for demonstrating the structure of the sales promotion effect analysis tool in the book sales management system of embodiment.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. In all the drawings, the same reference numerals are given to the same components, and the description will be omitted as appropriate.

<Functions of the entire book sales management system>
FIG. 3 is a conceptual diagram for explaining a mechanism in which product data newly released by a publisher or the like and its correction data are collectively reflected in a database such as a store using the book sales management system 1000 of the present embodiment. is there. As described above, in the book sales management system 1000 of the present embodiment, product data and its correction data newly released by a plurality of publishers such as publisher A and publisher B registered in advance as users of this system. Is registered in the product database 112 of the book sales management system 1000.

  Then, the newly released product data registered in the product database 112 and the correction data thereof are converted into the format A, the format B, and the format C, and then the agency product database A (200a) and the agency product database B (200b). ), And sent to the agency product database C (200c) all at once. As a result, if these transmission data do not conform to the data format and data content requested by the agency product database A (200a), the agency product database B (200b), and the agency product database C (200c), an error message is returned. Is done. On the other hand, if these transmission data conform to the data format and data content requested by the agency product database A (200a), the agency product database B (200b), and the agency product database C (200c), the transmission data is Reflected in database contents.

  As described above, in the book sales management system 1000 of this embodiment, product data to be newly released and correction data thereof can be collectively reflected in a plurality of agency databases having different standards. Therefore, it is possible to reduce the labor of a publisher or the like to register newly published book information in a plurality of agency stores and the labor of correcting already published book information.

  FIG. 4 shows a book sales management system 1000 according to the present embodiment, in which publishers etc. flexibly promote sales to bookstores or consumers while checking the sales status of products, and verify the sales promotion results. It is a conceptual diagram for demonstrating the mechanism to do. As described above, in the book sales management system 1000 according to the present embodiment, a plurality of publishers such as publisher A and publisher B registered in advance as users of this system can execute up-to-date promotions or new / existing promotions. Sales promotion information is registered in the product database 112 of the book sales management system 1000.

  Then, the sales promotion information registered in the product database 112 is not suddenly distributed to the bookstore or the consumer. Instead, the book sales management system 1000 once notifies the management headquarters of an approval application for distributing these sales promotion information to a bookstore or a consumer. On the other hand, if the management headquarters approves, a part of the sales promotion information is distributed by changing from a state where it cannot be viewed from the bookstore chain A to a state where it can be viewed. Of these sales promotion information, information related to reservation acceptance is distributed by being converted into a reservation acceptance slip format and changed from a non-downloadable state to a downloadable state from the bookstore B. On the other hand, information related to DM (direct mail) among these sales promotion information is distributed by being converted into a DM format and mailed to a consumer's mail address.

  As described above, in the book sales management system 1000 according to the present embodiment, publishers and the like can flexibly sell to bookstores or consumers while checking the sales status of products using “Publish” provided by Kinokuniya. Promotion can be done. After sales promotion, we regularly review sales data such as “Publine” provided by Kinokuniya, verify the sales promotion results, provide feedback, and further improve sales promotion strategies. It is possible to continue.

  Further, in the book sales management system 1000 of this embodiment, the sales promotion information input by the publisher or the like is once checked by the management headquarters, and then appropriate sales promotion information can be delivered to the bookstore or the consumer. As a result, it is possible to reduce the risk that some publishers use the system inappropriately, and maintain the trust of the entire system.

<Configuration of the entire book sales management system>
FIG. 5 is a functional block diagram for explaining the overall configuration of the book sales management system of the present embodiment. The book sales management system 1000 of this embodiment is a book sales management system for managing the distribution of products including books by connecting the publisher terminal 500, the bookstore terminal 400, the agency terminal 201, and the management headquarter terminal 600. .

  The book sales management system 1000 is connected to a bookstore terminal 400, a publisher terminal 500, and a management headquarter terminal 600 via a network 130 such as the Internet. The book sales management system 1000 is connected to the sales / reservation trend database 300 via a network 136 such as the Internet. A database operator terminal 301 is connected to the sales reservation trend database 300. The book sales management system 1000 is connected to the consumer database 140 via a network 134 such as the Internet. The book sales management system 1000 is connected to the agency product database A (202a), the agency product database B (202b), and the agency product database C (202c) via a network 134 such as the Internet. The agency store terminal 201 is connected to the agency product database A (202a).

  A personal computer (PC) 122, a printer 124, an image display device 126, and an operation unit 128 are connected to the outside of the book sales management system 1000.

  Here, the book sales management system 1000 includes a user database 108 that stores user information including user attribute information and identification information, and a product database 112 that stores product information related to products including books. Prepare.

  The book sales management system 1000 accepts input of new product registration data from the publisher terminal 500, associates the new product registration data with the user information, adds the new product registration data to the product database 112, and further the book sales management system 1000. A new product registration unit 110 for adding new product registration data to the agency product database A (202a), the agency product database B (202b), and the agency product database C (202c), which are provided independently of the agency. .

  Further, the book sales management system 1000 receives an extraction command or edit data for specific product information included in the product database 112 from the publisher terminal 500, and extracts specific product information from the product database 112 based on the extraction command. When the edited data is received, the edited data is reflected in the product database 112, and the product information is browsed / reproduced in the agency product database A (202a), the agency product database B (202b), and the agency product database C (202c). An editing unit 114 is provided.

  The book sales management system 1000 accepts a sales / reservation trend extraction command for a specific product included in the product database 112 from the publisher terminal 500 or the management headquarters terminal 600, and is provided independently of the book sales management system 1000. The sales / reservation trend data extracting unit 120 extracts the sales / reservation trend information of a specific product from the sales / reservation trend database 300.

  In addition, the book sales management system 1000 receives sales promotion information of a specific product included in the product database 112 from a publisher, adds the sales promotion information to the product information of the specific product, and adds the sales promotion information to the product database 112. Furthermore, a sales promotion information registration unit 116 that notifies the sales promotion information distribution unit 118 of addition of sales promotion information is provided.

  The book sales management system 1000 accepts the notification of the sales promotion information from the sales promotion information registration unit 116, prompts the management headquarters terminal 600 to approve the distribution of the sales promotion information, and if the approval is accepted, the sales promotion information is received. A sales promotion information distribution unit 118 that distributes information is provided.

  The book sales management system 1000 includes a login unit 102 that receives an external login, an input reception unit 104 that receives input of various data and instructions from the outside, and an output unit 106 that outputs various data and instructions to the outside. I have. Here, the input receiving unit 104 may receive various data and instructions from various external terminals via the networks 130, 134, and 136, and may receive various data from various external databases via the networks 130, 134, and 136. It may be received, and various data and instructions may be received from the external PC 122 and the operation unit 128. On the other hand, when outputting various data and instructions to the outside, the output unit 106 may output the data to the outside via the networks 130, 134, 136, and outputs the data to the PC 122 connected to the outside. Alternatively, a print command may be output to an externally connected printer, or may be output as image data to the externally connected image display unit 126.

  According to this configuration, since the new product registration unit 110 and the product information browsing / editing unit are provided, the product data newly released by publishers and the correction data thereof can be collectively reflected in the database of the store, etc. It is possible to reduce the labor for a publisher to register new book information and the effort to correct already published book information.

  In addition, according to this configuration, since the sales / reservation trend data extraction unit and the sales promotion information registration unit are provided, publishers and the like can flexibly promote sales to bookstores or consumers while checking the sales status of products. And the results of the promotion can be verified. Therefore, while browsing sales data such as “Publine” as described above, sales promotion is flexibly performed for bookstores or consumers, the results of the sales promotion are verified, feedback is given, and the sales promotion strategy is further improved. It is possible to continue.

  Further, according to this configuration, since the sales promotion information distribution unit is provided, the sales promotion information input by the publisher or the like can be checked once by the management headquarters, and then appropriate sales promotion information can be delivered to the bookstore or the consumer. . As a result, it is possible to reduce the risk that some publishers use the system inappropriately, and maintain the trust of the entire system.

<Data structure of user database>
FIG. 6 is a table for explaining the data structure of the user database 108 in the book sales management system 1000 of this embodiment. As shown in FIG. 6, the user database 108 stores user information including user attribute information and identification information.

  This attribute information (corresponding to the “type” column) includes any attribute of the publisher, bookstore, agency, and administration headquarters. This identification information (corresponding to the column of “identification number”) includes a secret ID and password for other users uniquely assigned to the user. By including such attribute information and identification information of the user, if the user types a secret ID and password on the login screen, the attribute (publisher, bookstore, Therefore, it is possible to manage the access authority according to the user attributes while maintaining the security of the entire system.

<Data structure of product database>
FIG. 7 is a table for explaining the data structure of the product database 112 in the book sales management system 1000 of the present embodiment. As shown in FIG. 7, the product database 112 stores product information related to products including books.

  This product information includes the product name (corresponding to the “Title” column), the author name (corresponding to the “Author” column), the publisher name (corresponding to the “Publisher” column), and the price (“Main Price”). Column), release date (corresponding to the “Date of Publication” column), and data on product codes uniquely assigned to users. Thus, having the product name, the author name, the publisher name, the price, the release date, and the product code uniquely assigned to the user, the agency product database 200 of most agency stores requires in common. The main part of the input items can be satisfied. In addition, it is possible to store in advance in the product database 112 the main part of the data required when performing sales promotion described later.

  This product code may be a code unique to the book sales management system 1000 (corresponding to the column of “product code”), ISBN code (corresponding to the column of “ISBN”), magazine code, record product number, or JAN. It may be an existing code based on a public standard such as a code or a private standard. By using the ready-made codes based on these public standards and private standards, it is possible to satisfy the input items of the ready-made codes commonly requested by the agency product database 200 of most agency stores. Moreover, since these ready-made codes are standards that are valid throughout Japan or around the world, the versatility of data stored in the product database 112 can be enhanced.

  Here, the product information further includes data relating to a category to which the product belongs (corresponding to a column “category”). In this way, by including data related to the classification to which the product belongs in the product information, the utility value when the data stored in the product database 112 is used for sales promotion described later is improved.

  This classification may be a classification selected by a publisher from choices prepared in advance by the management headquarters. In this way, even if the classifications are assigned by different publishers, the classification items match each other, and there is an advantage that the consistency of the classification of the data stored in the product database 112 is increased. On the other hand, this classification may be a classification uniquely given by a publisher. In this way, different publishers can use unique and easy-to-use items, and there is an advantage that the data stored in the product database 112 is easy to use.

<Login unit and input reception unit>
FIG. 8 is a user interface for explaining the function of the login unit 102 in the book sales management system 1000 of the present embodiment. FIG. 9 is a functional block diagram for explaining the configuration of the login unit in the book sales management system 1000 of this embodiment. For example, when a person in charge of the publisher accesses a website on the Internet of the book sales management system 1000 from the publisher terminal 500, a login screen presented by the login unit 102 is displayed.

  When the person in charge inputs a secret ID and password from the publisher terminal 500 to another user uniquely assigned to the company, the ID and password are transmitted to the comparison unit 204 via the input data acquisition unit 202. The The comparison / contrast unit 204 that has received the ID and password acquires a data set corresponding to the ID and password from the user database 108 via the user identification information acquisition unit 206. At this time, the comparison / contrast unit 204 acquires a data set including an ID, a password, and attribute information (publisher, bookstore, agency, or administration headquarters).

  As a result, if there is a data set that matches the input ID and password, the comparison unit 204 instructs the login permission unit 210 to permit login. Then, the login permission unit 210 displays image information indicating that login is permitted to the publisher terminal 500 via the output unit 106 and the network 130, and an input reception screen presented by the input reception unit 104 as described later. Is displayed on publisher terminal 500. In this case, the comparison / contrast unit 204 transmits the attribute information (publisher, bookstore, agency, or administration headquarters) of the user who is permitted to log in to the login area specifying unit 212.

  Then, the login area designating unit 212 acquires data related to the login area corresponding to the attribute information of the user (publisher, bookstore, agency, or administration headquarters) from the login area storage unit 214, and the login area The data related to is transmitted to the input receiving unit 104. Then, as will be described later, the input reception unit 104 displays an input reception screen that displays only a login possible area based on attribute information (publisher, bookstore, agency, or administration headquarters) of a user who is permitted to log in. 500.

  On the other hand, if there is no data set that matches the input ID and password, the comparison unit 204 instructs the login prohibition unit 208 to prohibit login. Then, the login prohibition unit 208 displays image information indicating that login is prohibited to the publisher terminal 500 via the output unit 106 and the network 130, and displays image information that prompts the user to input the correct ID and password again. indicate.

  FIG. 10 is a user interface for explaining the function of the input receiving unit 104 in the book sales management system 1000 of the present embodiment. FIG. 10 shows a user interface when the publisher is a user. When the attribute information of the user is a publisher, the log-in area specifying unit 212 stores a new product registration unit 110, a product information browsing / editing unit 114, a sales / reservation trend extraction unit 120, and a sales promotion registration unit 116, which will be described later. Only the corresponding login enabled area is displayed on the publisher terminal 500. The user can move to the user interface of the area by clicking the button of the area to be used out of the login possible areas.

<New Product Information Registration Department>
FIG. 11 is a user interface for explaining the registrant information of the new product registration unit 110 and the input function of the agency in the book sales management system 1000 of the embodiment. FIG. 14 is a functional block diagram for explaining the configuration of the new product registration unit 110 in the book sales management system 1000 of the embodiment. As shown in FIG. 11, when the user clicks the new product registration button in the log-in area through the input reception unit 104, the input data is acquired by the input data acquisition unit 302 of the new product registration unit 110. , It is possible to shift to the user interface of “new product registration—registrant information”. In this interface, items that are requested to be input by the interface in the registration information of the logged-in user are automatically read from the user database 108.

  Then, the user inputs the items of the new product registrant and the book data delivery destination required by this interface, and at this time, the user wants to reflect the input data in the agency database of which agency store. Will be selected. Of course, one or more agency stores may be selected. Thereafter, the user selects whether to register the new product individually or collectively in CSV format.

  FIG. 12 is a user interface for explaining the product information input function of the new product registration unit 110 in the book sales management system 1000 of the embodiment. Reference should also be made to FIG. When the user clicks the individual registration button in the user interface of FIG. 11, the already entered registrant information is transmitted to the new product information adding unit 316 via the individual input receiving unit 304 and the registrant information receiving unit 308. Is done. And as shown in FIG. 12, it can transfer to this "product individual registration-product information-" user interface. In this interface, information can be individually entered for a product such as a book to be newly registered. And a user inputs about the item regarding the new goods requested | required by this interface, and when the input is completed, the button for proceeding is clicked. When the next button is clicked, the already-entered product information is transmitted to the new product information adding unit 316 via the individual input receiving unit 304 and the product information receiving unit 310.

  FIG. 13 is a user interface for explaining the reservation information input function of the new product registration unit in the book sales management system of the embodiment. Reference should also be made to FIG. When the user clicks the next button in the user interface shown in FIG. 12, the user interface can be shifted to the “product individual registration-reservation information-” user interface as shown in FIG. In this interface, if a product such as a book to be newly registered is scheduled to be released or overprinted soon, reservation information can be entered individually. Then, the user inputs items related to a new product scheduled to be released / overprinted in the near future requested by this interface, and when the input is completed, the user clicks a button for finishing the input of reservation information. When the button for finishing the input of the reservation information is clicked, the already input reservation information is transmitted to the new product information addition unit 316 via the individual input reception unit 304 and the reservation information reception unit 311.

  On the other hand, when the user clicks the CSV batch registration button in the user interface of FIG. 11, the user interface can be shifted to the “CSV batch registration-upload-” user interface (not shown). In this interface, it is possible to upload electronic files prepared in CSV format for products such as books that are desired to be registered collectively in CSV format. When the user designates the electronic file to be uploaded requested by this interface and clicks a button for proceeding, the designated electronic file is uploaded. In addition, if a product such as a book to be newly registered is scheduled to be released or overprinted in the near future, reservation information is also included in the electronic file prepared in CSV format. It is unnecessary. When the uploading is performed in this way, the new product information adding unit 316 is collectively put in a state where the registrant information, product information, and reservation information of the new product are associated with each other via the collective input receiving unit 306 and the CSV input unit 312. Is transmitted to.

  In any case, the new product information adding unit 316 adds the transmitted registrant information, product information, and reservation information of the new product to the product database 112 in association with each other. In this way, the new product registration unit 110 receives input of new product registration data from the publisher terminal 500 of the publisher by the user, associates the new product registration data with the user information, and then stores the new product registration data in the product database 112. to add. The new product information adding unit 316 transmits the transmitted new product registrant information, product information, and reservation information to the required input item request unit 320 in a state of being associated with each other.

  Separately from this, data relating to the book data transmission destination to which the individual registrant information, the product information and the reservation information of the new product are transmitted in association with each other is received from the individual input reception unit 304 and the collective input reception unit 306. 314 is transmitted. This agency transmission information reception unit 314 also transmits data relating to the book data transmission destination to the essential input item request unit 320.

  Then, the required input item request unit 320 acquires the required input item corresponding to the transmitted data related to the book data transmission destination from the required input item storage unit 318, and the registrant information and the product information associated with each other of the new product. In addition, if the required input items are satisfied and the data including the reservation information does not include non-conforming data, the error message creating unit 322 associates the new products with each other without creating an error message. Data including the registered user information, product information, and reservation information is transmitted to the agency data transmission unit 324 as it is. The agency data transmission unit 324 provides data including registrant information, merchandise information, and reservation information associated with each other for the new merchandise via the network 134 and is provided independently of the book sales management system 1000. The agency product database A (200a), the agency product database B (200b), and the agency product database C (200c) are added to the agency product database selected by the user.

  On the other hand, if the data including the registrant information, product information, and reservation information associated with each other of the new product includes data that is not required or is incompatible, the error message creating unit 322 Create an error message to alert the user and prompt them to enter the required input items again. As a result, when the user again inputs correction data for correcting the contents of the registrant information, product information, and reservation information in which the error message is issued in the above flow, the correction data is received by the correction receiving unit 326. Is transmitted to. Then, the correction accepting unit 326 transmits the data regarding the registrant information, the product information, and the reservation information reflecting the transmitted correction data to the essential input item request unit 320 again. The above steps are then repeated until the error message is no longer generated.

  In this way, the new product registration unit 110 inputs the new product registration data at a time, and according to the different input methods of the plurality of standards selected by the publisher, the agency product database A (200a having different standards). ), New product registration data is added to the broker product database selected by the user from the broker product database B (200b) and the broker product database C (200c).

  However, the agency product database A (200a), the agency product database B (200b), and the agency product database C (200c) are not included in the rules regarding the mandatory input items stored in the mandatory input item storage unit 318. There is also a possibility that a hidden rule is provided. In such a case, the network 134 is selected from any one of the agency product database A (200a), the agency product database B (200b), and the agency product database C (200c). The error message may return to the answer data acquisition unit 328 via Upon receiving such an error message, the answer data acquisition unit 328 transmits the error message from the outside to the error message creation unit 322, converts the error message into a user-oriented error message, and outputs the error message via the output unit 106. The error message is sent to the user to further correct the corresponding part.

  As described above, since the book sales management system 1000 of the present embodiment includes the new product registration unit 110 as described above, product data to be newly released by publishers or the like can be obtained from an agency product database A (200a) such as a distributor. The agency product database B (200b) and the agency product database C (200c) can be collectively reflected in the agency product database selected by the user. The effort to correct information can be reduced.

<Required input item request section>
FIG. 15 is a functional block diagram for explaining the configuration of the required input item request unit 320 in the book sales management system 1000 of the embodiment. FIG. 16 is a table for explaining the data structure of the essential input item storage unit in the book sales management system of the embodiment. In the mandatory input item request unit 320, data related to the registrant information, the product information, and the reservation information is transmitted from the new product addition unit 105 to the common essential input item comparison / contrast unit 402 and the specific essential input item comparison / contrast unit 404. In addition, data indicating that the publisher has selected a plurality of agency product databases A (200a) and agency product database B (200b) having different standards is transmitted from the agency transmission information receiving unit 104 to the unique mandatory input item acquisition unit 410. .

  Then, as shown in FIG. 16, the common essential input item comparison / contrast unit 402 is indispensable common essential in the agency product database A (200a), the agency product database B (200b), and the agency product database C (200c). An input item is acquired from the essential input item storage unit 318. Further, the unique and required input item comparison / contrast unit 404 acquires from the required input item storage unit 318 the unique and required input items that are only required for the agency product database A (200a) and the agency product database B (200b).

  Then, the transmission permission / inhibition determining unit 406 acquires the comparison result of the common essential input item comparison / contrast unit 402 and the comparison result of the specific essential input item comparison / contrast unit 404, and the common essential input item and the specific essential input item are insufficient. Alternatively, if it is determined that there is no nonconformity, the fact is transmitted to the agency data transmission unit 104. Then, the agency data transmission unit 104 adds merchandise data newly released by a publisher or the like to the agency product database A (200a) and the agency product database B (200b).

  On the other hand, the transmission permission / inhibition determining unit 406 acquires the comparison result of the common essential input item comparison / contrast unit 402 and the comparison result of the specific essential input item comparison / contrast unit 404, and the common essential input item and the specific mandatory input item are insufficient. Alternatively, if it is determined that there is a nonconformity, the error message creating unit 322 creates an error message, and prompts the user to make a correction. As a result, when the user corrects the data, the correction reception unit 326 acquires the correction data, transmits the data reflecting the correction to the transmission permission determination unit again, and the above steps are repeated. . These steps are repeated until no error message appears.

  Thus, the new product registration unit 110 prompts the publisher to input common required input items that are commonly required in different input methods of a plurality of standards in order to realize the functions already described, and the common required A common essential input item comparison / contrast unit 402 is provided to notify the publisher of an error message when the input data for the input item is insufficient or incompatible. In addition, the new product registration unit 110 urges the publisher to select the publication product database A (200a), the agency product database B (200b), and the agency product database C (200c) with different standards, and publishes them. When the company selects a brokerage product database A (200a) and a brokerage product database B (200b) having a plurality of different standards, it is a mandatory input common to the selected brokerage product database A (200a) and brokerage product database B (200b). There may be specific input items that are required in addition to the items. In preparation for such a case, the new product registration unit 110 prompts the publisher to input the specific input item, and notifies the publisher of an error message when the input data for the specific input item is insufficient or incompatible. An essential input item comparison / contrast unit 404 is also included in addition to the common essential item comparison / contrast unit 402.

  As described above, the book sales management system 1000 according to the present embodiment includes the above-described essential item input request unit 320. Therefore, the merchandise data newly released by the publisher or the like can be obtained from the agency merchandise database A (200a) such as the agency. Even if the agency product database B (200b) and the agency product database C (200c) are collectively reflected in the agency product database selected by the user, some of the agency product databases lack or do not conform to the data content or format. Can correct such an error even if it happens, and the publishers and others will register the new book information and correct the existing book information while preventing the trouble that the input data is not reflected well. Labor can be reduced.

<Product information viewing / editing department>
FIG. 17 is a user interface for explaining the function of the product information browsing / editing unit 114 in the book sales management system of the embodiment. FIG. 20 is a functional block diagram for explaining a configuration of product information of the product information browsing / editing unit 114 in the book sales management system of the embodiment. As shown in FIG. 17, when the user clicks the product information editing button in the log-in area through the input receiving unit 104, the input data is input by the input data acquisition unit 502 of the product information browsing / editing unit 114. Acquired and can move to the user interface for “product information editing”. The user interface is provided with a search engine input form of the product database 112 so that already registered product information can be searched.

  Here, when the product information extraction / editing unit 114 receives a search for specific product information or edit data that is not associated with the user information of the publisher from the publisher, such a product information extraction / editing unit 114 A security management unit 508 is provided for notifying the publisher of an error message that calls attention that data that does not have access authority cannot be displayed. When the input data acquisition unit 502 of the product information extraction / editing unit 114 receives a search for such product information that does not originally have access authority via the input receiving unit 104, the input data acquisition unit 502 performs the search. Data is transmitted to the target product information extraction unit 504. The target product information extraction unit 504 acquires product information corresponding to the search data from the product database 112 and transmits the product information to the security management unit 508. The security management unit 508 stores the product information in the user information of the publisher. If it is determined that the message is not associated with the error message, the error message creating unit 514 creates an error message and alerts the user via the output unit 106.

  On the other hand, when the product information extraction / editing unit 114 accepts a specific product information extraction command or edit data search associated with the publisher's user information from the publisher, the input data acquisition unit 502 transmits the search data to the target product information extraction unit 504. The target product information extraction unit 504 acquires product information corresponding to the search data from the product database 112 and transmits the product information to the security management unit 508. The security management unit 508 stores the product information in the user information of the publisher. When it is determined that the product information is associated with the product information, the product information is displayed to the user via the output unit 106 without causing the error message creation unit 514 to create an error message.

  FIG. 18 is a user interface for explaining the registrant information of the merchandise information browsing / editing unit and the input function of the agency in the book sales management system of the embodiment. Also refer to FIG. As shown in FIG. 18, when the user clicks desired product information from the list of registered product information displayed in FIG. 17, the input data is input data of the product information browsing / editing unit 114. Acquired by the acquisition unit 502, the user interface of “product information editing—registrant information” can be shifted to.

  Then, the user inputs correction data if necessary for the registrant and the book data delivery address where the browsed product requested by this interface is displayed. It is selected whether the corrected data should be reflected in the store's agency database. Of course, one or more agency stores may be selected. Thereafter, the user clicks a button for proceeding.

  FIG. 19 is a user interface for explaining the product information input function of the product information browsing / editing unit in the book sales management system of the embodiment. Please also refer to FIG. When the user clicks the next button in the user interface of FIG. 18, as shown in FIG. 19, it is possible to shift to the “product information editing—product information—” user interface. In this interface, you can enter the data you want to edit for a product such as a book you are browsing. Then, the user inputs correction data for the item related to the browsed product requested in this interface, and when the input is completed, clicks a button for reflecting the editing result.

  When the button for reflecting the editing result is clicked, the product information browsing / editing unit 114 reflects the edit data input via the edit data reflecting unit 508 in the product database 112. In this way, the merchandise information browsing / editing unit 114 receives input of edit data from the publisher terminal 500 of the publisher by the user, overwrites the correction data on the browsed merchandise information, and then reflects it in the merchandise database 112. To do. In addition, the edited data reflection unit 508 transmits the product information on which the correction data is overwritten to the required input item request unit 510.

  Separately from this, the edit data reflecting unit 508 transmits data related to the book data transmission destination to which the product information overwritten with the correction data is transmitted to the agency data transmission unit 520. The edited data reflection unit 508 also transmits data relating to the book data transmission destination to the required input item request unit 510.

  Then, the required input item request unit 510 acquires the required input item corresponding to the transmitted data related to the book data transmission destination from the required input item storage unit 512, and inputs the required input into the product information overwritten with the correction data. If the items are satisfied and non-conforming data is not included, the error message creation unit 514 transmits the product information overwritten with the correction data to the agency data transmission unit 520 without creating an error message. To do. The agency data transmission unit 520 sends the agency information database A (200a), agency goods of the agency store provided independently of the book sales management system 1000 via the network 134, with the merchandise information overwritten with the correction data. It adds to the agency product database which the user selected among database B (200b) and agency product database C (200c).

  On the other hand, if the product information overwritten with the corrected data contains missing or incompatible data, the error message creation unit 514 creates an error message and pays attention to the user. Prompting you to enter the required items again. As a result, if the user has entered re-correction data for correcting the content of the registrant information, product information, and reservation information that has an error message, the re-correction data is accepted for correction. Is transmitted to the unit 516. Then, the correction receiving unit 516 transmits the product information reflecting the transmitted re-correction data to the essential input item request unit 510 again. The above steps are then repeated until the error message is no longer generated.

  In this way, the merchandise information browsing / editing unit 114 inputs the correction data once, and according to the different input methods of the plurality of standards selected by the publisher, the agency product database A (200a having different standards). ), Correction data is added to the agency product database selected by the user from the agency product database B (200b) and the agency product database C (200c).

<Sales / Reservation Trend Data Extraction Unit>
FIG. 21 is a user interface for explaining the basic information extraction function of the sales / reservation trend data extraction unit 120 in the book sales management system 1000 of this embodiment. FIG. 23 is a functional block diagram for explaining the configuration of the sales / reservation trend data extraction unit 120 in the book sales management system 1000 of the present embodiment. As shown in FIG. 21, when the user clicks the sales / reservation trend data button in the log-in area via the input reception unit 104, the input data is the input data acquisition unit of the sales / reservation trend data extraction unit 120. It is acquired by 602, and it can shift to the user interface of this “sales reservation trend confirmation”. The user interface is provided with an input form for a search engine of the sales / reservation trend database 300 so that already registered product information can be searched.

The most preferred sales / reservation trend database 300 is Kinokuniya's “Public”. This is because the use of “Public” has the following merits.
(1) Disclosure of all single-item data You can know the data of all products handled at Kinokuniya. In addition to sales data, you can view purchase / return / inventory data for each item.
(2) Internet connection No new investment is required for use. For this reason, the PubLine Web service can be used from any PC that can connect to the Internet.
(3) Access to large amounts of data Data from 1998 has been saved and can be searched on a daily, weekly, or monthly basis.
(4) Searching for books, magazines, and JAN code products Not only books but also magazines, JAN code DVDs and calendars can be searched.
(5) Providing customer demographic data We also disclose data on the gender and age group of customers who have purchased a single product, so we can see data that matches actual sales and expand the range of marketing.
(6) Real-time data The sales of the day can be updated every 5 minutes and viewed in real time.

  Here, if the sales / reservation trend data extraction unit 120 accepts a search for specific sales / reservation trend data not associated with the publisher's user information from the publisher, such access authority is given. A privacy management unit 606 is provided for notifying the publisher of an error message that calls attention to the fact that data that does not have a message cannot be displayed. When the input data acquisition unit 602 of the sales / reservation trend data extraction unit 120 receives a search for such sales / reservation trend data that does not originally have access authority via the input reception unit 104, the input data acquisition unit In step 602, the search data is transmitted to the target product information extraction unit 604. The target product information extraction unit 604 acquires product information corresponding to the search data from the sales / reservation trend database 300 via the network 136 and transmits it to the privacy management unit 606. If it is determined that the reservation trend data is not associated with the publisher's user information, the error message creation unit 610 creates an error message and alerts the user via the output unit 106.

  On the other hand, when the sales / reservation trend data extraction unit 120 accepts a search for sales / reservation trend data of specific product information associated with the publisher's user information from the publisher, input data acquisition is performed. The unit 602 transmits the search data to the target product information extraction unit 604. The target product information extraction unit 604 acquires sales / reservation trend data corresponding to the search data from the sales / reservation trend database 300 via the network 136 and transmits the data to the privacy management unit 606. The privacy management unit 606 When it is determined that the sales / reservation trend data is associated with the user information of the publisher, the sales / reservation trend data is output to the output unit 106 without causing the error message creation unit 610 to create an error message. Display to the user via The user clicks a button for proceeding to the next after confirming the sales / reservation trend data.

  FIG. 21 is a user interface for explaining the basic information extraction function of the sales / reservation trend data extraction unit 120 in the book sales management system 1000 of this embodiment. Please also refer to FIG. As shown in FIG. 22, when the user clicks a button for proceeding in FIG. 21 via the input reception unit 104, the input data is input by the input data acquisition unit 602 of the sales / reservation trend data extraction unit 120. Acquired and can move to the user interface of this “page view list” and “DM shipping status list”. Specifically, when the user interface of “page view list” and “DM shipment status list” is shifted to, the sales / reservation trend data of the target product is transmitted from the target product information extraction unit 604 to the sales promotion effect analysis tool 612. . Then, the sales promotion effect analysis tool 612 acquires the sales promotion history of the target product from the product database 112 and associates the sales promotion history and the sales / reservation trend data with “page view list” and “DM shipping status list”. The sales promotion effect analysis result is displayed to the user via the output unit 106.

  As described above, the sales / reservation trend data extraction unit 120 uses, for example, a “page view list” and a “DM shipment status list” as the sales promotion effect analysis tool 612 distributed by the sales promotion information distribution unit 118 described later. By having a tool, publishers and the like can flexibly promote sales to bookstores or consumers while checking the sales status of products, and verify the sales promotion results. For this reason, sales promotions such as “Publish” provided by Kinokuniya are flexibly promoted to bookstores or consumers, and the results of the promotion are verified and feedback is given. It is possible to improve. In FIG. 21, the “page view list” is in the form of a sales / reservation trend list for each product, but is not limited to such a format. For example, instead of the sales / reservation trend list for each product, A sales / reservation trend list may be used.

<Sales Promotion Information Registration Department>
FIG. 24 is a user interface for explaining the list function of the sales promotion information registration unit 116 in the book sales management system 1000 of the embodiment. FIG. 29 is a functional block diagram for explaining the configuration of the sales promotion information registration unit 116 in the book sales management system 1000 of the embodiment. As shown in FIG. 24, when the user clicks the sales / reservation trend button in the log-in area via the input reception unit 104, the input data is input by the input data acquisition unit 702 of the sales promotion information registration unit 116. It is acquired, and it can shift to the user interface of this "sales promotion information registration-list-". The user interface is provided with a search engine input form of the product database 112 so that already registered product information can be searched.

  Then, the user selects which of the products in the list requested by this interface wants to register the sales promotion information. In this interface, when the user selects the target product, the selection data is acquired by the input data acquisition unit 702 via the input reception unit 104. Thereafter, the user clicks a button for proceeding. Then, the input data acquisition unit 702 transmits the selection data to the target product information extraction unit 704, and the target product information extraction unit 704 extracts the sales promotion information data of the target product from the product database 112 as shown in FIG.

  FIG. 25 is a user interface for explaining various information registration functions of the sales promotion information registration unit 116 in the book sales management system 1000 of the present embodiment. Please also refer to FIG. When the user clicks on a product selected from the user interface shown in FIG. 24, the user can shift to the “sales promotion information registration” user interface as shown in FIG. In this interface, you can enter promotion information including advertisement information, shelf information, store message, store file or management headquarters message or specify upload file for a product such as a book you are browsing. be able to.

  If you have already entered these promotion information or specified an upload file in the past, the data or upload file specification already entered will be displayed, so overwrite those data or upload file specifications. You will enter new data or upload file specifications in the form. On the other hand, if you have never entered these promotional information in the past, those data or upload file specifications will not be displayed, so you can enter those data or upload file specifications into a new blank input form or It will be specified. Then, the user inputs desired data or specifies an upload file for the sales promotion information requested by this interface, and clicks a button for proceeding to the next when input or specification is completed.

  When the button for proceeding to the next is clicked, the data about the sales promotion information that has already been input becomes the advertisement information reception unit 706, the shelf information reception unit 708, the store message reception unit 710, the store file reception unit 712, and the message to the management headquarters. Each is transmitted to the reception unit 714.

  FIG. 26 is a user interface for explaining the DM shipping condition registration function of the sales promotion information registration unit 116 in the book sales management system 1000 of the embodiment. Please also refer to FIG. As shown in FIG. 26, when the user clicks a button for proceeding in FIG. 25 through the input receiving unit 104, the input data is acquired by the input data acquiring unit 702 of the sales promotion information registering unit 116. The user interface of “DM shipping condition registration request” can be transferred.

  Then, the user designates which ISBN or author is designated among DM sending conditions requested by this interface, and inputs conditions for sending DM (direct mail). If a DM has already been sent in the past, the data already entered is displayed, so that new data is input in the form of overwriting those data. On the other hand, if the DM has not been sent in the past, the data already entered is not displayed, so that the data is entered into a new blank input form. In this interface, when the user inputs the ISBN or the author name, the input data is acquired by the input data acquiring unit 702 via the input receiving unit 104. Thereafter, the user clicks a button for proceeding. Then, the input DM shipping conditions are transmitted to the DM creation unit 718.

  FIG. 27 is a user interface for explaining the reservation acceptance form registration function of the sales promotion information registration unit 116 in the book sales management system 1000 of the present embodiment. Please also refer to FIG. As shown in FIG. 27, when the user clicks a button for proceeding in FIG. 26 via the input receiving unit 104, the input data is acquired by the input data acquiring unit 702 of the sales promotion information registering unit 116. , It is possible to shift to the user interface for “registration receipt registration”.

  Then, the user inputs a condition for creating a reservation reception slip with what kind of headline / introductory sentence among the reservation reception slip generation conditions required in this interface. If a reservation acceptance slip has been created in the past, those already entered data are displayed, so that new data is entered in the form of overwriting those data. On the other hand, if the reservation acceptance slip has not been created in the past, the data already entered is not displayed, and the data is newly entered into a blank input form. Then, in this interface, when the user inputs a headline / introductory text, the input data is acquired by the input data acquisition unit 702 via the input reception unit 104, and the reservation reception form creation unit 716 performs real-time processing on the input. The reservation receipt slip is created and displayed on the user's terminal screen. At that time, the two-dimensional barcode creating unit 723 creates a two-dimensional barcode that can be photographed and recognized by the camera function of the portable information terminal of the consumer and displays it on the reservation reception slip. Thereafter, the user clicks a button for proceeding.

  As will be described later, when a consumer shoots and recognizes the two-dimensional barcode created in this way with a portable information terminal at a storefront and accesses a site on a network using i-mode / EZWEB or the like, the bookstore's You will be directed to an introduction page for a specific product at a sales site on the network. In this way, the reservation acceptance form creation unit 716 includes a two-dimensional barcode creation part 723 that modifies the reservation acceptance form into a format for two-dimensional barcode store distribution that can be photographed and recognized by the camera function of the portable information terminal. Therefore, for example, sales promotion on mobile can be performed in conjunction with a book sales site on the Internet accessible from a portable information terminal such as Kinokuniya BOOKWEB.

  FIG. 28 is a user interface for explaining the missing message registration function of the sales promotion information registration unit 116 in the book sales management system 1000 of this embodiment. Please also refer to FIG. As shown in FIG. 28, when the user clicks the button for proceeding in FIG. 27 via the input receiving unit 104, the input data is acquired by the input data acquiring unit 702 of the sales promotion information registering unit 116. , It is possible to shift to the user interface of this “missing message registration”.

  Then, the user inputs what contents of the missing message registration conditions required in this interface, and which bookstore wants to deliver the missing message. If a missing message has already been delivered in the past, the data already entered is displayed, so that new data is input overwriting the data. On the other hand, if the missing message has never been delivered in the past, the data already entered is not displayed, and the data is newly entered into a blank input form. Thereafter, the user clicks a button for distributing the sales promotion information input so far. Then, the content of the input missing message and the data of the delivery destination are transmitted to the missing message creating unit 720.

  In this way, when a button for distributing the sales promotion information input so far is clicked, a notification information receiving unit 706, a shelf information receiving unit 708, a store message receiving unit 710, a store-oriented file receiving unit 712, From the management headquarters message reception unit 714, sales promotion information including advertisement information of specific products, shelf information, store messages, store files, or management headquarters messages is transmitted to the sales promotion information addition unit 722. The In addition, when a button for distributing the sales promotion information input so far is clicked, a reservation for a specific product is similarly made from the reservation receipt form information creation unit 716, the DM creation unit 718, and the missing message creation unit 720. Sales promotion information including any one of the reception slip, direct mail, and missing message is transmitted to the sales promotion information adding unit 722.

  Then, the sales promotion information adding unit 722 stores the sales promotion information including any of the advertisement information, the shelf information, the message for the store, the file for the store, and the message for the management headquarters in the product database 112. Initially, writing or uploading is performed in a state where browsing or downloading is impossible. Further, the sales promotion information adding unit 722 displays the sales promotion information including any of the received reservation receipt, direct mail, and missing message for the specific product in a state where it cannot be viewed or downloaded at first. The database 112 is written or uploaded. Then, the sales promotion information adding unit 722 notifies the sales promotion information distribution unit 118 described later via the notification unit 724 that the sales promotion information has been written or uploaded to the product database 112.

<Sales Promotion Information Distribution Unit 118>
FIG. 30 is a functional block diagram for explaining the configuration of the sales promotion information distribution unit 118 in the book sales management system 1000 of the embodiment. The sales promotion information distribution unit 118 receives notification that various sales promotion information has been written or uploaded to the product database 112 from the sales promotion information registration unit 116 via the notification reception unit 804, and extracts target product information. Part 806. Then, the target product information extraction unit 806 searches and extracts the sales promotion information written or uploaded for the target product of notification from the product database 112. Then, the target product information extraction unit 806 sends an approval application for distributing the written or uploaded sales promotion information to the management headquarters terminal 600 via the approval application unit 808, the output unit 106, and the network 130. On the screen.

  When the person in charge of the administrator headquarters who operates the administrator headquarters terminal 600 confirms the approval application displayed on the screen and approves it, the approval instruction is received from the administrator headquarters terminal 600 via the network 130 and input accepted. And the input data acquisition unit 802 of the sales promotion information distribution unit 118. Then, the input data acquisition unit 802 transmits the acquired approval instruction to the approval reception unit 810. The approval receiving unit 810 transmits the received approval instruction to the viewable change unit 812, the downloadable change unit 814, and the DM transmission unit 816.

  Then, the viewable change unit 812 views the advertisement information, the shelf information, and the message for the store of the specific product added to the product database 112 when logging in from the bookstore store via the login reception unit 102. The sales promotion information is distributed by changing from an impossible state to a viewable state. In addition, the viewable change unit 812 changes the message for the management headquarters added to the product database 112 from an unviewable state to a viewable state when logging in from the management headquarters via the login reception unit 102. Also, messages for administration headquarters are distributed. Further, the viewable change unit 812 reads the reservation receipt slip or missing message of a specific product added to the product database 112 from the format database 820 using the format conversion unit 822, and stores it for store delivery. By changing to a format and logging in from the bookstore store via the login reception unit 102, the reservation reception form or the missing message is also distributed.

  Then, the downloadable change unit 814 changes the file for the store of the specific product added to the product database from a non-downloadable state to a downloadable state when logging in from the bookstore store via the login reception unit 102. By doing so, files for stores of specific products are distributed.

  Also, the DM transmission unit 816 reads the corresponding format from the format database 820 using the format conversion unit 822 and changes the direct product of the specific product added to the product database 112 into a format for mail delivery. In addition, the DM transmission unit 816 relates to the DM to be sent from the consumer database 140 that stores the email address of the consumer of the product including the book provided independently of the book sales management system 1000. The DM is effectively transmitted by transmitting the DM modified in the mail delivery format to the mail address of the target consumer extracted via the network 130 and the DM transmission destination information acquisition unit 818 according to the product information to be performed. Deliver to selected consumers. Specifically, as already explained, if you have received an ISBN designation or author designation as a DM shipping condition, you may have purchased a book belonging to those ISBN classifications or a book of the same author in the past. DM can be sent to the mail address. At this time, if the DM reaches the consumer for each book, the consumer may be too complicated because the DM is too much. Therefore, for example, when sending DMs to the same consumer, the contents of all DMs may be collected and sent as one DM only once a week. The format when DMs are transmitted together as described above is also stored in the format database 820, and the DMs can be combined into one using the format conversion unit 822.

  FIG. 31 is a table for explaining the data structure of the consumer database 140 connected to the book sales management system 1000 of the present embodiment. Please also refer to FIG. As described above, the consumer database 140 includes e-mail addresses of consumers who have purchased books at a bookstore store or a sales site on the bookstore network. As the consumer database 140, for example, a consumer database of Kinokuniya stores that stores the mail addresses of consumers who have purchased books at the Kinokuniya bookstores nationwide or BookWeb / BookWebPro provided by Kinokuniya bookstores. It can be used suitably.

  As described above, since the book sales management system 1000 of the present embodiment includes the sales promotion information distribution unit 118 as described above, the sales promotion information input by the publisher or the like is checked once by the management headquarters, and appropriate sales are performed. Promotion information can be delivered to bookstores or consumers. As a result, it is possible to reduce the risk that some publishers use the system inappropriately, and maintain the trust of the entire system.

<Sales promotion effect analysis tool>
FIG. 32 is a user interface for explaining the sales promotion result analysis function of the sales / reservation trend data extraction unit 120 in the book sales management system 1000 of the embodiment. FIG. 33 is a functional block diagram for explaining the configuration of the sales promotion effect analysis tool 612 in the book sales management system 1000 of the embodiment. As already described in part, the sales promotion effect analysis tool 612 of the sales / reservation trend data extraction unit 120 is a sales history on the introduction page of a specific product on a sales site on a bookstore network and a search engine on the network. A page view analysis tool 902 that analyzes the search frequency by associating with each other is provided. Further, the sales promotion effect analysis tool 612 includes a keyword analysis tool 904 that analyzes the sales history on the introduction page of a specific product on the sales site on the bookstore network and the search keyword by the search engine on the network in association with each other. Further, the sales promotion effect analysis tool 612 analyzes the timing when the direct mail of a specific product is transmitted to the target consumer's mail address and the analysis result of the page view analysis tool 902 or the keyword analysis tool 906 in association with each other. A direct mail reaction analysis tool 906 is provided.

  That is, the sales promotion effect analysis tool 612 of the sales / reservation trend data extraction unit 120 includes the analysis result of the page view analysis tool 902, the keyword analysis tool 904, or the direct mail reaction analysis tool 906, and the book at the bookstore or agency store. It can be said that it is a tool for measuring the effect of sales promotion information on a network for analyzing sales / reservation trends of products in association with each other. That is, the sales promotion effect analysis tool 612 acquires sales / reservation trend data of a product including a book at a bookstore or an agency from the sales / reservation trend database 300 via the target product information extraction unit 604 and the network 136. be able to.

  Therefore, the sales promotion effect analysis tool 612 acquires various sales promotion histories of a specific product stored in the product database 112, and further on the network of bookstores stored in the sales / reservation trend database 300. The information such as the sales history on the introduction page of a specific product at the sales site, the search keyword by the search engine on the network, the search keyword by the search engine on the network, etc. are acquired, and the various types as shown in FIG. The sales promotion effect can be analyzed.

  In the book sales management system 1000 of this embodiment, since the sales promotion effect analysis tool 612 is provided, the publisher or the like flexibly promotes sales to the bookstore or the consumer while checking the sales status of the product. The sales promotion result can be verified. Therefore, while browsing sales data such as “Publine” as described above, sales promotion is flexibly performed for bookstores or consumers, the results of the sales promotion are verified, feedback is given, and the sales promotion strategy is further improved. It is possible to continue.

  As mentioned above, although embodiment of this invention was described with reference to drawings, these are the illustrations of this invention, Various structures other than the above are also employable.

  For example, in the above embodiment, “publine” of Kinokuniya was used as the sales / reservation trend database 300, but it is not limited to “publine” in particular, and is POS data provided by any bookstore, agency, or system company. Can also be suitably used. In other words, in addition to “Publine” (bookstore) at Kinokuniya, there are other services that provide POS data for viewing book sales, such as “Triple Win” (together) for daily sales, “Big NET ( (Big Net) "(bookstore), Junkudo's" POSDATA Ureta "(bookstore), Maruzen's" MCS (Maruzen Communication Square) "(bookstore), NET21's" Yamabiko Tsushin "(collaboration bookstore), Mitsubishi Research Institute DCS" “P-NET service” (system company), Amazon (bookstore), Sanyo bookstore “SPN2” (bookstore), store consortium Japan “WEBRAIN”, Akiya bookstore “OpenNet” (bookstore), Kumazawa bookstore group “ Kuma book.net "(bookstore) Other services may be used.

  Further, for example, in the above embodiment, the relational data model is used as the format of various databases. However, the present invention is not limited to the relational data model, and the hierarchical data model, the network type data model, the relational data model, the object data model, the card Even a type data model can be suitably used.

  Further, for example, in the above embodiment, the agency data transmission unit 324 is provided in the new product registration unit 110, and the agency data transmission unit 324 is connected via the network 134 to the agency product database A (200a) and the agency product database B. (200b), the registration information of a new product is added to the agency product database C (200c). However, the present invention is not limited to this configuration. That is, the agency data transmission unit 324 performs the agency product database A (200a), the agency product database via another new product registration system (not shown) provided independently of the book sales management system 1000. It is good also as a structure which adds the registration information of a new product to B (200b) and the agency product database C (200c). Thus, the development cost of the book sales management system 1000 is obtained by registering a new product in the agency through another new product registration system (not shown) provided independently of the book sales management system 1000. It becomes possible to save some.

  Further, for example, in the above embodiment, the function of distributing the number of new publications to stores is not provided, but the present invention is not limited to this configuration. That is, in the book sales management system 1000, in addition to the above configuration, when a new product such as a new publication is registered, the publisher once uploads the number of distributions of the new product to the management headquarters. Distribution number registration unit (not shown) for distribution, distribution approval unit (not shown) for the management headquarters to approve the number of distributions, and distribution of new products with the approved number of distributions to stores without waste A distribution unit (not shown) may be additionally provided. The distribution unit (not shown) is connected to a new product storage warehouse database (not shown) and a carrier database (not shown) provided independently of the book sales management system 1000. Preferably it is. In this way, publishers can flexibly distribute new publications to bookstores in conjunction with sales promotion activities, and prevent abuse of publishers' systems to be checked by the administration headquarters. You can also maintain trust in the entire system.

102 login unit 104 input reception unit 105 new product addition unit 106 output unit 108 user database 110 new product registration unit 112 product database 114 product information browsing / editing unit 116 sales promotion information registration unit 118 sales promotion information distribution unit 120 sales / reservations Trend data extractor 122 PC
124 Printer 126 Image Display Device 128 Operation Unit 130 Network 134 Network 136 Network 140 Consumer Database 200a Product Database A
200b Product Database B
200c Product Database C
201 Distributor terminal 202 Input data acquisition unit 204 Comparison / contrast unit 206 User identification information acquisition unit 208 Login prohibition unit 210 Login permission unit 212 Login area designation unit 214 Login possible area storage unit 300 Sales / reservation trend database 301 Database operator terminal 304 Individual input accepting unit 306 Collective input accepting unit 308 Registrant information accepting unit 310 Product information accepting unit 311 Reservation information accepting unit 312 CSV input unit 314 Intermediary transmission information accepting unit 316 New product information adding unit 318 Essential input item storage unit 320 Essential Input item request unit 322 Error message creation unit 324 Intermediary data transmission unit 326 Correction reception unit 328 Response data acquisition unit 400 Bookstore terminal 402 Common essential input item comparison / contrast unit 404 Specific essential input item comparison / contrast unit 406 Transmission permission / non-permission determination unit 410 Specific necessity Input item acquisition unit 500 Publisher terminal 502 Input data acquisition unit 504 Target product information extraction unit 508 Security management unit 510 Required input item request unit 512 Required input item storage unit 514 Error message creation unit 516 Correction reception unit 520 Intermediary data transmission unit 600 Management headquarters terminal 602 Input data acquisition unit 604 Target product information extraction unit 606 Privacy management unit 610 Error message creation unit 612 Sales promotion effect analysis tool 702 Input data acquisition unit 704 Target product information extraction unit 706 Advertisement information reception unit 708 Shelf information reception unit 710 Store message reception unit 712 File reception unit for store 714 Message reception unit for management headquarters 716 Reservation receipt form creation unit 718 DM creation unit 720 Missed message creation unit 722 Sales promotion information addition unit 723 2D barcode creation unit 7 24 Notification unit 802 Input data acquisition unit 804 Notification reception unit 806 Target product information extraction unit 808 Approval application unit 810 Approval reception unit 812 Viewable change unit 814 Downloadable change unit 816 DM transmission unit 818 DM transmission destination information acquisition unit 820 Format database 822 Format conversion unit 902 Page view analysis tool 904 Keyword analysis tool 906 Direct mail reaction analysis tool 1000 Book sales management system

Claims (23)

A book sales management system for managing the distribution of merchandise including books by connecting publishers, bookstores, agency stores and administration headquarters,
A user database for storing user information including user attribute information and identification information;
A product database that stores product information about products, including books,
Accepting input of new product registration data from a publisher, adding the new product registration data to the user database after associating it with the user information, and further providing an agency independent of the book sales management system A new product registration unit for adding the new product registration data to the store's agency product database;
When a specific product information extraction command or edit data included in the product database is received from a publisher, the specific product information is extracted from the product database based on the extraction command, and when edit data is received, A product information viewing / editing unit that reflects edit data in the product database, and further reflects in the agency product database;
Accepting a sales / reservation trend extraction command for a specific product included in the product database from a publisher or administration headquarters, and from the sales / reservation trend database provided independently of the book sales management system, Sales / reservation trend data extractor to extract sales / reservation trend information of
Receiving sales promotion information of a specific product included in the product database from a publisher, adding the sales promotion information to the product database after associating it with the product information of the specific product, and further adding the sales promotion information A sales promotion information registration unit that notifies the sales promotion information distribution unit,
The sales promotion information distribution unit that receives the notification of the sales promotion information from the sales promotion information registration unit, prompts the management headquarters to approve the distribution of the sales promotion information, and distributes the sales promotion information when the approval is accepted When,
A book sales management system. The book sales management system according to claim 1,
The attribute information includes any attribute of a publisher, a bookstore, an agency, and an administration headquarters,
The identification information includes a secret ID and password for other users uniquely assigned to the user,
Book sales management system. In the book sales management system according to claim 1 or 2,
The product information includes data on a product name, an author name, a publisher name, a price, a release date, and a product code uniquely assigned to a user.
Book sales management system. In the book sales management system according to claim 3,
The product code is an ISBN code, a magazine code, a record product number, or a JAN code.
Book sales management system. In the book sales management system according to claim 3 or 4,
The product information further includes data relating to a classification to which the product belongs.
Book sales management system. In the book sales management system according to claim 5,
The classification is a classification selected by a publisher from options prepared in advance by the administrative headquarters.
Book sales management system. In the book sales management system according to any one of claims 1 to 6,
The new product registration unit adds the new product registration data to the agency product database having different standards according to the different input methods of the standards selected by the publisher by inputting the new product registration data once. Configured as
Book sales management system. The book sales management system according to claim 7,
In the case where the new product registration unit prompts the publisher to input common required input items that are commonly required in different input methods of a plurality of standards, and the input data to the common required input items is insufficient or nonconforming Includes a common required input comparison section that notifies publishers of error messages,
Book sales management system. The book sales management system according to claim 8,
When the new product registration unit prompts the publisher to select options for a different product database with different standards and the publisher selects a different product database with different standards, the selected product Prompt the publisher to input specific input items required in addition to the common required input items in the database, and notify the publisher of an error message if the input data for the specific input items is insufficient or incompatible Including input comparison section
Book sales management system. The book sales management system according to any one of claims 7 to 9,
The new product registration unit is configured to collectively add a plurality of new product registration data to a plurality of different product database different standards at once.
Book sales management system. The book sales management system according to claim 1 to 10,
Security that notifies the publisher of an error message when the product information extraction / editing unit receives an extraction command or edit data for specific product information not associated with the publisher's user information from the publisher Including the administration department,
Book sales management system. The book sales management system according to claim 11,
The product information extracting / editing unit reflects the edited data in a plurality of standardized product databases according to different standards selected by the publisher by inputting the edited data once. Configured to,
Book sales management system. The book sales management system according to claim 1 to 12,
When the sales / reservation trend data extraction unit receives an extraction command for sales / reservation trend information related to product information not associated with the publisher's user information from the publisher, the sales / reservation trend data extraction unit performs sales based on the extraction command.・ Including a privacy management section that does not extract reservation trend information and notifies publishers of error messages.
Book sales management system. The book sales management system according to claim 1 to 13,
The sales / reservation trend data extraction unit is configured to be able to extract a sales / reservation trend list by product or a sales / reservation trend list by store,
Book sales management system. The book sales management system according to claim 1,
The sales / reservation trend data extraction unit further includes an effect measurement tool for the sales promotion information distributed by the sales promotion information distribution unit,
Book sales management system. The book sales management system according to claim 1 to 15,
The sales promotion information registration unit is configured to receive sales promotion information including any of advertising information, shelf information, message for store, file for store, message for store or management headquarters for a specific product,
Book sales management system. The book sales management system according to claim 1 to 16,
The sales promotion information registration unit is configured to receive sales promotion information including a reservation receipt slip, a direct mail, and a missing message for a specific product.
Book sales management system. The book sales management system according to claim 17,
The sales promotion information registration unit has a two-dimensional barcode that can be photographed and recognized by the camera function of a portable information terminal held by a consumer in the format of the reservation reception slip, and the two-dimensional barcode is stored in the portable information terminal. Including a two-dimensional barcode creation unit that changes to a store delivery format that is guided to an introduction page of a specific product at a sales site on the bookstore network when the information terminal is photographed and recognized to access the network;
Book sales management system. The book sales management system according to claim 18,
The sales promotion information distribution unit
Any of advertisement information, shelf information, and store message for a specific product added to the product database is changed from an unviewable state to a viewable state when logging in from the store of the bookstore via the login reception unit. Deliver by changing,
Deliver a file for a store of a specific product added to the product database by changing from a non-downloadable state to a downloadable state when logging in from the bookstore store via the login reception unit,
Deliver the message for the management headquarters added to the product database by changing the state from the unviewable state to the viewable state when logging in from the management headquarters via the login reception unit,
A book sales management system configured as follows. The book sales management system according to claim 17,
The sales promotion information distribution unit
The reservation receipt slip or missing message for a specific product added to the product database is changed into a format for store distribution, and then it can be downloaded when logged in from the bookstore store via the login reception unit. To deliver,
The mail address of the consumer of the product including the book provided independently from the book sales management system after modifying the direct mail of the specific product added to the product database into a mail delivery format Deliver by sending to the target consumer's email address extracted according to the product information from the consumer database that stores
A book sales management system configured as follows. The book sales management system according to claim 19,
The consumer database includes e-mail addresses of consumers who have purchased books at the bookstore store, a sales site on the bookstore network,
Book sales management system. In the book sales management system according to claim 20 or 21,
The sales / reservation trend data extraction unit
A page view analysis tool for analyzing the sales history on the introduction page of a specific product on the sales site on the bookstore network and the search frequency by the search engine on the network,
A keyword analysis tool for analyzing the sales history on the introduction page of a specific product on the sales site on the network of the bookstore and a search keyword by a search engine on the network,
A direct mail reaction analysis tool that analyzes the timing of sending a direct mail of a specific product to the target consumer's mail address and the analysis result of the page view analysis tool or the keyword analysis tool;
Including any of the following,
Book sales management system. The book sales management system according to claim 22,
The sales / reservation trend data extraction unit includes an analysis result of the page view analysis tool, the keyword analysis tool or the direct mail reaction analysis tool, and a sales / reservation trend of a product including a book at a bookstore or an agency. Further includes a tool for measuring the effectiveness of promotional information on the network to be correlated and analyzed,
Book sales management system.