JP4633832B2 - Product reservation method - Google Patents

Description

  The present invention relates to a product reservation method, and more particularly to a product reservation method suitable for simplifying the reservation management of magazines that are regularly subscribed in a bookstore.

Traditional book reservations at bookstores were made as follows. Necessary items are entered in the reservation slip by the customer and the store clerk who visited the store, and based on the reservation slip, the customer name is filed for each publisher's magazine. When the magazine arrives, the necessary number of books is extracted based on the reservation slip and stored in the product storage shelf together with the customer name. Then, referring to a copy of the customer who visited the store again, a necessary magazine is taken out from the product storage shelf and delivered to the customer. Patent Document 1 describes a system in which a magazine purchaser directly applies for a periodic magazine subscription without visiting a bookstore.
JP 2004-355570 A

  However, the above-described conventional reservation method has a problem that the trouble of managing the magazine reservation at the bookstore is complicated. On the other hand, in addition to customers who book magazine subscriptions online from their home computers, there are many customers who are unfamiliar with computer operations or who have confirmed the contents of a magazine at a bookstore and then subscribe to the bookstore at the bookstore. There was a need for more efficient reservation work.

  SUMMARY OF THE INVENTION The present invention solves such problems, and an object of the present invention is to provide a product reservation method capable of improving the efficiency of product reservation management work in a store.

  In order to achieve the above object, according to the first aspect of the present invention, a step of generating a temporary reservation master file by associating a magazine code with a customer code of a customer who has made a reservation for the magazine, Receiving a bibliographic master file comprising journal data including detailed information of the magazine, and selecting the magazine data having the same magazine code as the magazine code from the received bibliographic master file. Generating a reservation master file in association with the customer code.

   In the first aspect of the invention, a temporary reservation master file is generated by associating a known magazine code with a customer code regardless of the release date of the magazine. Magazine reservation for each or each magazine can be managed mechanically on a computer. After receiving the bibliographic master file, a reservation master file is created in which magazine data having the same magazine code as the above-mentioned magazine code is associated with the customer code. Management of each magazine and delivery to the customer can be mechanically managed on a computer.

  In the second invention, the magazine is a periodic issue magazine, and the temporary reservation master file is obtained by associating a magazine code of the periodic issue magazine with a customer code of a customer who subscribes to the periodic issue magazine. The magazine data includes a magazine product identification code. In the second aspect of the present invention, management and delivery of magazines that are periodically issued for each customer can be mechanically managed on a computer.

  In the third invention, a JAN code is used as the magazine product identification code.

  In the fourth invention, a step of generating a provisional reservation master file by associating a product code with a customer code of a customer who made a reservation for the product, and detailed information on the product issued in relation to the release date of the product Receiving a product master file including: selecting a product data including the same product code as the product code from the received product master file and generating a reservation master file in association with the customer code; Is provided. In the fourth invention, not only magazines but general products can be managed mechanically on a computer for each customer or for each product, and individual products received Management for each customer and delivery to the customer can be managed mechanically on a computer.

  As described above, according to the product reservation method of the present invention, the product reservation management work in the store can be made efficient by using the computer.

(Equipment for implementing the product reservation method)
FIG. 1 shows the configuration of an apparatus for carrying out the product reservation method of the present invention. The apparatus includes a personal computer (personal computer) 1 and a POS register 2. A main body 11 of the personal computer 1 includes a CPU, a memory, an interface circuit, and the like, and a monitor 12, a keyboard 13, a mouse 14, and a barcode scanner 15 are connected to the main body 11. The main body 21 of the POS register 2 includes a CPU, a memory, an interface circuit, and the like. A monitor 22 with a built-in touch panel, a card reader 23 and a barcode scanner 24 are connected to the main body 11. Each master file to be described later is generated on the memory of the external server 3 and is appropriately referred to by the personal computer 1 and the POS register 2. Hereinafter, the present invention will be described by taking as an example the case where the product is a magazine.

(Procedure for subscription)
Magazine reservations are made on the PC 1. Hereinafter, the processing procedure executed by the personal computer 1 will be described with reference to the flowcharts of FIGS. First, a subscription registration screen S1 (FIG. 4) is displayed on the monitor 12 of the personal computer 1 (step 101). In this state, the membership code attached to the membership card of the customer who makes the reservation application is read by the barcode scanner 15, and the read membership code is displayed in the “membership code” column 501 of the screen S1 (step 102). ). Subsequently, the magazine code of the magazine for which the customer has subscribed is entered from the keyboard 13 and displayed in the “magazine code” field 502 on the screen S1 (step 103). This magazine code is entered from a code list such as “Magazine Mokuroku”. Note that the following screen display is an example for easy understanding, and the magazine data and the like shown on the screen are not necessarily consistent with each other on the screen.

  When the customer has the actual magazine to be subscribed for, the JAN code attached to the actual magazine is read by the barcode scanner 15 and the magazine code portion included in the read JAN code is “magazine code”. It is displayed in the column 502. When the “search” button 503 on the screen S1 is clicked in this state (step 104), the magazine information screen S2 shown in FIG. 5 is displayed (step 105). On the screen S2, member information such as “member code” and “name” of the customer to whom the member code is assigned are displayed, and input items are displayed.

  Here, the outline of the JAN code for magazines is as follows. In FIG. 9, the first digit “4910” is followed by a five-digit magazine code portion “C1, C2, C3, C4, C5”. After that, the issue month “DD”, the last digit “E” of the year, the check digit “F”, and the price “GHHHH” are followed in this order. When the most significant digit “C1” of the magazine code part is “0” or “1”, monthly, bimonthly, and quarterly publications are indicated. When “2” or “3”, weekly, seasonal, and biweekly publications are indicated. The only magazines that can be reserved in this embodiment are those whose magazine code part “C1” is “0”, “1”, “2”, “3”.

  When “C1” is “0” or “1”, “C2, C3, C4, C5” is the magazine name code. In this case, when “C5” is an odd number, it is a regular publication, and when “C5” is an even number, it is a separate volume or extra edition. When “C1” is “2” or “3”, “C2, C3, C4” is the magazine name code. When “C5” is “1” to “5”, the issue week is indicated, and when “C5” is “6” to “9”, a separate volume is indicated.

  A check box 504 for selecting “magazine code” is displayed as an input item on the screen S2 (FIG. 5). In this embodiment, the most significant digit “C1” of the magazine code is “2” indicating weekly, seasonal, or biweekly, and the magazine name code “C2, C3, C4” is “975”. Then, a check box 504 is displayed for the normal publication in which the lowest digit “C5” is “1” and the separate volumes in which “6”, “7”, “8”, and “9” are displayed. Therefore, a desired check box 504 is touched to be checked and selected (step 106). In this embodiment, a check mark is put in “29759”, which is selected.

  At the same time, on the screen S2, columns "505" to 507 for "magazine name", "publisher", and "publishing form" are displayed, and items determined from the magazine name code are displayed here. Further, “1” is displayed in the “number of books” column 508, and the date following the reservation date is displayed in the “subscription start date” column 509 in the present embodiment. In addition, if each column 505-509 has correction, correction will be suitably performed by the input from the keyboard 13. FIG.

  The “subscription end date” column 510 is set by an input from the keyboard 13, but if not set, the following processing is performed. In principle, the subscription will be invalidated 3 months after the subscription start date. That is, the subscription ends. If reservation data to be described later is generated within this three-month period, the “subscription end date” is extended by three months based on this date. The reason for performing such management is that the magazine code is often altered or disappears so that it is not used for a long time without generating reservation data.

  After confirming / correcting each column 505 to 510 on the magazine information screen S2, clicking the “Confirm” button 511 on the screen S2 displays a “Register” button (not shown). (Step 107) A subscription master (FIG. 10) as a provisional reservation master file in which the customer code and the magazine code are associated is generated (Step 108). When the “print” button 512 (FIG. 6) that appears in the upper right of the screen S2 is clicked after the “registration” button is clicked (step 109), a list of magazines for which the customer has reserved subscriptions is printed (FIG. 6, step 110). ). Therefore, this is used as a record for customers and bookstores.

  In the case of a magazine, a bibliographic master file (hereinafter simply referred to as a bibliographic master) including the JAN code is transmitted online from a wholesaler to a bookstore three days before the sale. As shown in FIG. 11, the bibliographic master is composed of magazine data including detailed information about the magazine such as a magazine name, a publisher name, a magazine code, and a release date in addition to the JAN code. Therefore, when the bibliographic master is received (step 111), the magazine code and the magazine code of the subscription master (FIG. 10) are collated (step 112). A reservation master (FIG. 12) is generated by making the included JAN code correspond to the customer code instead of the magazine code of the subscription master (step 114).

  In order to confirm the registered subscription data, the subscription search screen S3 (FIG. 7) is called. Enter the member code in the “member code” field on the screen S3 or enter the magazine code in the “magazine code” field (FIG. 4 shows the case where the magazine code “01003” is entered). When is clicked, the reservation status is displayed for each member or each magazine (FIG. 7). In the “reservation” column 514 in the screen S3, a white circle is displayed for a magazine for which the bibliographic master (FIG. 11) has already been received and the reservation master (FIG. 12) has been created, and in the “reserve” column 515, White circles are displayed on magazines that are already in stock. When the “details” button 516 on the screen S3 is touched, the details information screen S4 (FIG. 8) is switched to display details of reservation contents of the customer / magazine corresponding to the button 516.

(Management procedures for incoming magazines)
When a magazine is actually delivered from a wholesaler, delivery data as shown in FIG. 13 is sent online prior to delivery. The delivery data includes the JAN code of the magazine to be sent and its quantity. Therefore, the reservation master already generated in the personal computer 1 (step 114 in FIG. 3 and FIG. 12) is referred to, and the number of customers having the same JAN code as the JAN code of the magazine to be sent is calculated. The number of customers made is regarded as the reserve inventory number. This reserve stock quantity is printed out together with the corresponding JAN code and magazine name as the reserve number in the reserve list (FIG. 14). The store clerk refers to the reserve list and stores the received magazine in a magazine reserve shelf managed for each magazine code.

(Screen warning at subscription reservation)
When accepting a subscription, the personal computer 1 makes the following determination and displays a warning for the store clerk on the screen of the monitor 12. That is, when the bibliographic master (FIG. 11) is received, but the current shipment data (FIG. 13) is not received and the purchase processing has not been completed, “subscription reservation for this time in the previous record” “Please judge the delivery of the magazine” is displayed. If the bibliographic master has been received, but the quantity of delivery data received this time is zero and there is virtually no delivery, “The number of deliveries is zero, so subscription subscription magazines cannot be handed over. "It takes time." If you have received the bibliographic master and have received the delivery data for the current shipment with a non-zero quantity, but the purchase process has not been completed, Please warn me ". Furthermore, if the bibliographic master has been received, the current delivery data of a value other than zero has been received, and the purchase processing has been completed, "If the subscription subscription magazine for this time is in store, it will be delivered If not, the next issue will be handed over. The reservation will be generated automatically. "

(Reservation magazine delivery procedure)
Delivery of the reserved magazine is performed at the POS register 2. Hereinafter, the processing procedure executed in the POS register 2 will be described with reference to the flowchart of FIG. First, a sales registration screen S5 (FIG. 16) is displayed on the monitor 22 of the POS register 2 (step 201). When a customer who has subscribed for subscription receives the magazine, when the membership card is read by the card reader 23 of the POS cash register 2, the membership code and name of the customer are displayed at the top of the screen S5 (FIG. 16). (Step 202). Further, the number of magazines that are allocated, that is, received, is displayed at the bottom of the screen S5 (FIG. 16, step 203). Subsequently, when the “member reserved product calling” button 521 (FIG. 17) on the screen S5 is touched, a pick-up product selection screen S6 displaying a list of magazines reserved by the customer is displayed (FIG. 17, FIG. 17). Step 204). Among these magazines, (allocated) magazines that are in stock are displayed with a black circle in the “Date / Allocation” column 522 and with a white circle in the “Pickup” column 523. The confirmation of whether or not the allocation is made is performed by referring to an arrival file created by scanning the JAN code of the received magazine.

  At this time, when the arrival is not confirmed on the arrival file and the black circle mark is not displayed in the “date / reserve” column 522, the above screen is displayed when the magazine is actually already received and can be delivered. Touching the up / down arrow button 524 on S6 (FIG. 18) changes the selected line, and touching the “change designation” button 525, a white circle is forcibly displayed in the “pickup” column 523.

  When the “print list” button 526 on the screen S6 is touched in this state, a list of magazines that can be handed over to the customer with white circles displayed in the “pickup” column 523 is printed as shown in FIG. 205). The store clerk carries the printed magazine list, selects a required magazine from the magazine storage shelf, and takes it back to the POS register 2.

  Thereafter, when the “directly to acceptance” button 527 on the screen S6 (FIG. 18) is touched (step 106), the acceptance screen S7 is displayed (FIG. 20, step 207), and the “pickup” column 523 is displayed. A list of magazines with white circles is displayed in (FIG. 18). In this state, when the JAN code attached to the magazine brought back to the POS register 2 is read by the barcode scanner 24, the “completed” mark is displayed in the “verified” column 528 of the magazine that matches the JAN code ( FIG. 20, steps 208 and 210). If the JAN code of the magazine brought back to the POS register 2 does not match the JAN code on the list, a warning message is displayed (step 209). When the “verification completed” button 529 is touched at the stage where the “completed” mark is displayed in the “verified” column 528 of all the magazines displayed in the list (FIG. 20) (step 211), the total amount of charges is indicated. A receipt is printed (step 212).

(Other embodiments)
In the above-described embodiment, the case where the present invention is applied to magazine subscription management has been described. However, the present invention can also be applied to products other than magazines.

It is a block block diagram of the apparatus which implements the goods reservation method in one Embodiment of this invention. It is a flowchart which shows the process sequence in a personal computer. It is a flowchart which shows the process sequence in a personal computer. It is a front view of the screen displayed on a personal computer monitor. It is a front view of the screen displayed on a personal computer monitor. It is a front view of the screen displayed on a personal computer monitor. It is a front view of the screen displayed on a personal computer monitor. It is a front view of the screen displayed on a personal computer monitor. It is a figure explaining the structure of a JAN code. It is a figure explaining the structure of a subscription master. It is a figure explaining the structure of a bibliographic master. It is a figure explaining the structure of a reservation master. It is a figure explaining the structure of delivery data. It is a front view of the printed reserve list. It is a flowchart which shows the process sequence in a POS cash register. It is a front view of the screen displayed on a POS cash register monitor. It is a front view of the screen displayed on a POS cash register monitor. It is a front view of the screen displayed on a POS cash register monitor. It is a front view of the printed magazine list. It is a front view of the screen displayed on a POS cash register monitor.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Personal computer, 11 ... Main body, 12 ... Monitor, 13 ... Keyboard, 14 ... Mouse, 2 ... POS cash register, 21 ... Main body, 22 ... Monitor, 23 ... Card reader, 24 ... Bar code scanner, 3 ... External server.

Claims (4)

A step of generating a temporary reservation master file by associating a magazine code with a customer code of a customer who has reserved the magazine, and magazine data including detailed information of the magazine issued in relation to the release date of the magazine Receiving a bibliographic master file; and selecting the journal data having the same magazine code as the magazine code from the received bibliographic master file and generating a reservation master file in association with the customer code. Product reservation management method provided. The magazine is a periodic issue magazine, and the temporary reservation master file is obtained by associating a magazine code of the periodic issue magazine with a customer code of a customer who subscribes to the periodic issue magazine, and the magazine data is for a magazine The product reservation management method according to claim 1, comprising a product identification code. The product reservation management method according to claim 2, wherein a JAN code is used as the magazine product identification code. A step of generating a provisional reservation master file by associating a product code with a customer code of a customer who has reserved the product, and a product master file including detailed information on the product issued in relation to a release date of the product A product reservation management method comprising: a receiving step; and selecting a product data including the same product code as the product code from the received product master file and generating a reservation master file in association with the customer code. .