JP5041487B2 - Inventory management system - Google Patents

Description

  The present invention relates to an inventory management system, and more particularly to an inventory management system that minimizes the inventory of goods. In addition, the customer rank is determined from the reservation execution level and the annual purchase amount of the product reservation applicant, and a list of products that can be reserved by the product reservation applicant is displayed from the customer rank and the product sales status so that the product reservation is performed. It is a thing. In particular, reservation requests for products with good sales from good customers are reserved.

Today, in the case of nationwide chain stores, such as online shopping, search for stores in stock nationwide, display a list on the display unit, purchase products from stores in stock via Internet shopping, or visit stores to purchase In consideration of convenience, there is a system that introduces a group of stores in the vicinity of the store's normal travel route, and a system that adjusts the arrival schedule so that stock is available when visiting the store. (For example, refer to Patent Documents 1 and 2).
JP 2002-117221 A (paragraphs 0013 to 0019, FIG. 1) JP 2002-169948 A (paragraphs 0011 to 0020, FIG. 1)

  In the conventional system, there is a system that adjusts the stock so that there is the stock on the day of the visit by adjusting the inventory in order to respond to the request that the store visitor wants to purchase after confirming the product. This was a planned adjustment, and the store reservation was not guaranteed when the customer visited the store, and there was a possibility that the stock could be accidentally lost. In addition, it is not always necessary to secure inventory by reservations for products with poor distribution and high-priced products, even if the store reservation person confirms the product, if not purchased, it could be a bad stock . The present invention has been made in view of such problems, and an object of the present invention is to provide an inventory management system capable of performing inventory management in accordance with the circumstances of the purchase applicant side and the situation of the sales side. Yes.

  (1) The invention described in claim 1 is a customer terminal that makes a product reservation request, a management server that is connected to the customer terminal via a network and manages inventory of the product, and a product that is connected to the management server. In an inventory management system composed of a database for storing management information, a store terminal connected to the network, and a clerk terminal also connected to the network, a product reservation applicant makes a product reservation from the customer terminal. Then, the management server determines a customer rank from the reservation execution degree and the annual purchase amount of the product reservation applicant stored in the database, and the product reservation applicant from the customer rank and the sales status of the product. The product list that can be reserved is displayed on the display unit of the customer terminal so that the product reservation can be performed. When the product reservation is made, Inventory management system, characterized in that it has to send the goods reserve request.

  (2) In the invention according to claim 2, in response to a request that the product reservation applicant confirms the product and then decides to purchase, the management server refers to the database to determine the last sale date of the product. In addition, the inventory of the product is restricted in consideration of the sales situation.

(3) The invention described in claim 3 is characterized in that, for a product with good sales status, the management server reserves a product in response to a product reservation request from a member customer.
(4) The invention according to claim 4 is characterized in that the customer server rejects a reservation request from a member customer for a product having a poor sales situation.

  (5) In the invention according to claim 5, when the store reservation person is a member of a company including a store that has made a store reservation or a group designated by the company, the management server stores the purchase results of the member or past store reservations. It is characterized by restricting the stock of the product from the purchase results at the time.

  (1) When a product that can be reserved by a product reservation applicant is determined from the customer rank and the product sales information, the reserve of the product is sent to the clerk terminal, so that the product desired by the customer who may purchase the product is reserved. Can be kept.

(2) According to the invention described in claim 2, the occurrence of defective stock can be suppressed by restricting the stock of the corresponding product from the last sale date of the corresponding product and the sales situation.
(3) According to the invention as set forth in claim 3, since a product with good sales status does not become a defective stock even if the product is kept, the product can be kept as requested by the member customer.

(4) According to the invention described in claim 4, it is possible to prevent the occurrence of defective inventory by refusing a reservation request from a member customer for a product with poor sales status.
(5) According to the invention described in claim 5, when the store visitor is a member customer, it is determined whether or not to keep the product from the purchase record of the member or the purchase record at the past visit reservation. Therefore, it is possible to suppress the occurrence of defective inventory.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of the system of the present invention. In the figure, reference numeral 1 denotes a customer terminal that makes a product reservation request and the like, and 2 denotes a network such as the Internet to which the customer terminal 1 is connected. Reference numeral 3 denotes a management server that is connected to the network 2 and performs inventory management of products.

  The management server 2 includes a member registration unit for registering a member, a reservation reception determination unit for determining reservation reception, a reservationable product display unit for displaying a reservationable product, and a purchase record update unit for updating a purchase record. The sales status update means for updating the sales status, the reservation execution rate update means for updating the reservation execution rate, the customer rank update means for updating the customer rank, and the reserve product processing means for processing the reserve product. ing. These constituent means can be realized by hardware or software.

  Here, the customer rank is a rank for judging how much the customer purchases the product for the merchandise sales side. The normal rank is B, and the rank of the customer who often purchases the product is A. The rank of the customer who does not purchase is set to C (details will be described later).

  A database (DB) 4 is connected to the management server 3 and stores product management information. For example, a hard disk device is used as the database. The database 4 includes a merchandise sales information management table for storing the sale status of merchandise, a merchandise inventory table for storing inventory information of the merchandise, a reservable inventory condition table for storing reservable inventory conditions, and a sale status of the merchandise. Are stored in the sales condition table for storing the number of days, the number of days for which the product can be stored, and the member information table for storing the member information.

  In addition, a member purchase record table that stores member purchase results, a reservation management table that stores product reservation management status, a customer rank table that stores customer ranks, and a reservation execution determination that stores determination conditions for reservation execution A table, a reservationable customer condition table for storing the conditions of customers who can make reservations, a product sales record table for storing product sales results, a store management table for storing store management status, and an email for storing a mail template Includes a template table.

  The configuration of each table is shown below. FIG. 2 is a diagram illustrating a configuration example of a product sales status management table. As shown in the figure, the sales status is stored for each type of product. For example, for product A, there is an average 12 product sales per month. FIG. 3 is a diagram showing a configuration example of the commodity inventory table. In this product inventory table, the sales price, the number of stocks, and the product ID are stored for each product. For example, the price of the product A is 9800 yen, the stock quantity is 2, and the product IDs are A111 and A112.

  FIG. 4 is a diagram illustrating a configuration example of the reservable inventory condition table. As shown in the figure, the number of stocks and the customer rank that can be reserved are stored for each product. For example, a product A with a stock quantity of 1 is a customer rank A, and a product quantity A with a stock quantity of 2 is a customer rank B. FIG. 5 is a diagram showing a configuration example of the sales situation condition table. The sales condition and the reservationable customer rank are stored for each product. For example, the reservationable customer rank is “A” when the sales status condition of the product A is “three or more monthly sales”. FIG. 6 is a diagram illustrating a configuration example of a reserveable days table. The number of days that can be reserved and the customer rank that can be reserved are stored for each product. For example, the reservationable customer rank A is stored for a product A having a reserveable number of days of 3 days. When the number of days that can be reserved is one day, the customer rank for reservation is B. Since the product of customer rank B is likely to become a defective stock, the number of days that can be reserved is shortened to one day. The product of customer rank A has a long reserve period of 3 days.

  FIG. 7 is a diagram illustrating a configuration example of the member information table. As shown in the figure, member ID, member name, address, member registration date, member contact e-mail address, customer purchase rank, annual purchase amount, total number of reservations purchased, and reservation execution The rate and the reservation execution rate rank are stored. Here, the total number of reserved product purchases is the number of times the reserved product is actually purchased, and the reservation execution rate indicates the ratio of the actual number of purchases to the total number of reservations. The reservation execution rate rank indicates the ratio of the number of actual purchases to the total number of reservations.

  FIG. 8 is a diagram illustrating a configuration example of the member purchase record table. For each member ID, a purchase date, a product ID, and a purchase amount are stored. FIG. 9 is a diagram showing a configuration example of the reservation management table. As shown in the figure, the reservation number, the member ID of the reserved member, the reserved product ID of the reserved product, the reserve deadline date, and the cancellation date are stored.

  FIG. 10 is a diagram illustrating a configuration example of a customer rank table. The rank is stored according to the annual purchase amount. For example, when the annual purchase amount is 100,000 yen or more, the rank is 1, and when the annual purchase amount is 10,000 yen to 100,000 yen, the rank is 2. FIG. 11 is a diagram illustrating a configuration example of a reservation execution determination table. As shown in the figure, a rank is stored for each reservation execution rate. For example, when the reservation execution rate is 80% or more, the class is 1. FIG. 12 is a diagram showing a configuration example of a reservationable customer condition table. As shown in the figure, a customer rank that can be reserved is stored for each condition. For example, when the rank of the reservation execution determination table or the customer rank table is 1, the reservable customer rank is A, and when the rank of the reservation execution determination table and the customer rank table is 2, the reservable customer rank is B.

  FIG. 13 is a diagram illustrating a configuration example of a product sales record table. As shown in the figure, the date, the product ID, and the sales amount are stored. FIG. 14 is a diagram illustrating a configuration example of the store management table. As shown in the figure, store names and store contact e-mail addresses are stored.

Returning to the description of FIG. Reference numeral 5 denotes a clerk terminal provided for each clerk, and 6 denotes a shop terminal provided for each shop. The operation of the system configured as described above will be described as follows.
When there is a member registration request from the customer terminal 1, the management server 3 displays a member registration screen on the customer terminal 1. FIG. 15 shows a member registration screen. The display area displays a message that says "Please register as a member to use the reservation service." The name, address, and contact address input areas are displayed. When the name, address and contact address are entered, the send button 11 is pressed. As a result, the name, address, and contact address are transmitted to the management server 3 via the network 2.

  The name, address, and contact address are stored and registered in the member information table (see FIG. 7) in the database 4 by the member registration means. At this time, the ID of the member is added, but this member ID is transmitted to the customer terminal 1 and the number is notified to the customer. At this time, “B” is set as a default value in the customer purchase rank of the member information table. Rank B indicates a normal rank.

  Next, when there is a product reservation request from the customer terminal 1, the reservation acceptance determination means in the management server 3 determines the product inventory table shown in FIG. 3 and the reservable inventory condition table shown in FIG. To determine whether there is a product that can be reserved. In addition to the above conditions, it is determined by referring to the sales status condition table shown in FIG.

  If there are products that can be reserved according to the above conditions, the management server 3 refers to the table of available days in the database 4 for these products, extracts the available days from the customer rank and the product name, and reserves the products. The display means displays on the customer terminal 1 together with the list of reservable products.

  FIG. 16 is a diagram showing a product reservation screen. On the screen, a list of products that can be reserved is displayed together with the display “Member ID 555, a list of products that can be reserved by the customer”. In the case of FIG. 16, for product A, the number of stocks is 2 for IDA 111, the last available date is March 27, and the number of available days is 1 day. The date is April 27, and the number of days that can be reserved is displayed.

  In this case, the customer checks the product to be purchased in the squares 12 and 13 attached to the side of the product and presses the product reservation request button 14 to make a request reservation. When the requested reservation information is input to the management server 3, the management server 3 writes the reservation number, member ID, reservation date, reserved product ID, and reserve deadline date in the reservation management table shown in FIG. If the customer does not have the necessary product, the customer presses the cancel button 15. As a result, the cancellation date is written in the reservation management table.

  When this request acceptance process is performed, the management server 3 transmits a product reservation acceptance completion mail to the customer terminal 1. FIG. 18 is a diagram showing a mail from the management server 3 to the customer terminal 1. (A) is a product acceptance completion e-mail that displays the name of the product and the number of days allowed for storage, along with an e-mail indicating that “the reservation for the following product has been completed. (B) is a notification email for cancellation of the reserve, and the content of the product that has been released is displayed along with an email stating "The reserve period for the following product has passed. .

  Further, the management server 3 transmits a reserve request information mail to the salesclerk terminal 5. FIG. 17 is a diagram showing a mail from the management server 3 to the clerk terminal 5. (A) is a reservation request information email, and the product information to be stored is displayed together with the message “Member ID 555 has been reserved. Please leave the following product.” (B) is a reserve release request mail. The store information is displayed on the clerk terminal 5 together with a message “Reservation period of the following product has passed. Please cancel the storage”. Keeping means placing the product on a separate dedicated shelf so that it is not handled in the same way as a general product. Keeping the product on the same shelf as a general product means releasing the product. To sell side by side.

  The management server 3 determines whether or not there is a product for which the number of days that can be reserved has passed, and if there is, the management server 3 sends a reservation request email to the store clerk terminal 5 of the store in which it has been stored, A cancellation request mail is also transmitted to the customer terminal 1 as shown in FIG. The management server 3 updates the annual reservation execution rate and the customer rank in the reservation execution determination table shown in FIG.

  In the management server 3, when the sales status update means receives the product sales information from the store terminal 6, the product sales result table shown in FIG. 13 in the database 4 is updated. Further, the purchase record update means accesses the product sales status management table shown in FIG. 5 and updates the average number of monthly sales for each product at the end of the month or at a predetermined timing.

  Further, the purchase record update means of the management server 3 accesses the member purchase record table shown in FIG. 8 and updates the member purchase record. Moreover, the reservation execution rate update means of the management server 3 updates the annual reservation execution rate in the member information table shown in FIG. 7 when reserved products are included. Further, the customer rank update means accesses the reservation execution determination table of FIG. 11 and updates the customer rank and the reservation execution rate rank.

  FIG. 19 is a flowchart showing an example of the operation of the management server. Assume that the system shown in FIG. 1 is used as the system. The subject of operation is a management server. First, it is checked whether or not a member registration request is received from the customer terminal 1 (S1). If there is a member registration request, the member information is registered in the member information table of the database 4 (S2). Next, when the member information is registered, the customer rank is initially set to “B” (S3). Here, the customer rank B indicates a normal rank. Thereafter, when the customer becomes an important customer of the store, the customer rank is raised to A. If it turns out that it is a customer who does not purchase the goods of the said store very much, it will be lowered to rank C below B.

  After the member registration request is completed, it is checked whether there is a reservation request from the customer terminal 1 (S4). If there is no reservation request, it is checked whether or not there is a product whose retention deadline has passed (S5). If there is no product whose deadline has passed, it is checked whether a cancellation request for the reserved product has been received from the store terminal 6 or the customer terminal 1 (S6). If there is a cancellation request, the cancellation date is registered in the reservation management table shown in FIG. 9 (S7), and the process returns to the beginning. Even if there is no cancellation request in step S6, the process returns to the beginning.

  In step S5, if there is a product with a reservation deadline, a store release request email is transmitted to the store staff terminal 5 of the store (S8), and a store release report email is also transmitted to the customer terminal 1 holding the store. (S9), the reservation execution rate, the reservation execution rate rank, and the customer rank of the member customer whose reserve has been canceled are updated (S10), and the process returns to the beginning. Here, the reservation execution rate rank and the customer rank are updated with respect to the reservation execution determination table shown in FIG.

  In step S1, if there is no member registration request, it is checked whether or not the merchandise sales information from the store terminal 6 has been received (S11). When the merchandise sales information is received, the merchandise sales record table shown in FIG. 13 is updated (S12). Next, it is checked whether or not the merchandise sales information has been sent at the end of the month (S13). If it is the end of the month, the product sales status management table shown in FIG. 2 is accessed to update the average monthly sales (S14).

  Next, it is checked whether or not the product sales information is from a registered member (S15). If not from a member, return to the beginning. If it is from a member, the member purchase record table shown in FIG. 8 is accessed to update the member purchase record (S16). Next, it is checked whether there is a reserved product in the received information (S17). If not, the process returns to the beginning. If there is, the reservation execution rate is calculated, and the reservation execution rate is updated by accessing the reservation execution determination table shown in FIG. 11 (S18). Then, the reservationable customer condition table shown in FIG. 12 is accessed, the customer purchase rank and the reservation execution rate rank are updated (S19), and the process returns to the beginning.

  Next, when there is a reservation request in step S4, referring to the reservation example inventory condition table shown in FIG. 4 and the configuration example of the reservation possible customer condition table shown in FIG. It is checked whether there is a product that satisfies the reservation availability condition (S20). If there is a product that satisfies the reservation availability condition, whether or not there is a product that satisfies the reservation availability status from the sales status and customer rank in addition to the conditions shown in step S20 with reference to the product sales performance table shown in FIG. Check (S21).

  If there is a product that satisfies the reservation availability condition, the number of days that can be reserved is extracted from the customer rank and the product name, and is displayed together with the reservation available product list as shown in FIG. 16 (S23). If there is no product satisfying the reservation available condition in step S20, or if there is no product satisfying the reservation available condition in step S21, reservation acceptance unavailable information is displayed on the customer terminal 1 (S22). Return.

  Next, it is checked whether or not the customer desired product is specified in the product list displayed in step S23 (S24). If not specified, return to the beginning. If specified, a reservation acceptance number is issued and reservation information is registered in the reservation management table shown in FIG. 9 (S25). Next, a product reservation acceptance completion mail as shown in FIG. 18A is transmitted to the customer terminal 1 (S26). Further, as shown in FIG. 17 (a), a reserve request information mail is transmitted to the clerk terminal 5 (S27). In this case, a mail can be easily created using the mail template table stored in the database 4. Then return to the beginning.

  As described above, according to the present invention, when a product that can be reserved by the product reservation applicant is determined from the customer rank and the sales information of the product, the reserve of the product is transmitted to the clerk terminal, so that the customer who can purchase the product. You can keep the goods you want.

Further, by restricting the inventory of the corresponding product from the last sale date and the sales status of the corresponding product, the occurrence of defective stock can be suppressed.
In addition, for products with good sales status, even if the products are kept, they will not become defective stock, so the products can be kept as requested by the member customers.

In addition, for products with poor sales status, it is possible to prevent the occurrence of defective inventory by refusing reservation requests from member customers.
Furthermore, when the store visitor is a member customer, it is determined whether or not to keep the product from the purchase record of the member or the purchase record at the past visit reservation, so the occurrence of defective inventory can be suppressed. .

It is a block diagram which shows one Embodiment of this invention system. It is a figure which shows the structural example of a merchandise sales status management table. It is a figure which shows the structural example of a goods inventory table. It is a figure which shows the structural example of a reservation possible stock condition table. It is a figure which shows the structural example of a sales condition condition table. It is a figure which shows the structural example of a reserve possible days table. It is a figure which shows the structural example of a member information table. It is a figure which shows the structural example of a member purchase performance table. It is a figure which shows the structural example of a reservation management table. It is a figure which shows the ranking with respect to an annual purchase amount. It is a figure which shows the structural example of a reservation execution judgment table. It is a figure which shows the structural example of a reservation possible customer condition table. It is a figure which shows the structural example of a goods sales performance table. It is a figure which shows the structural example of a shop management table. It is a figure which shows a member registration screen. It is a figure which shows a goods reservation screen. It is a figure which shows the mail from a management server to a salesclerk terminal. It is a figure which shows the mail from a management server to a customer terminal. It is a flowchart which shows an example of operation | movement of a management server.

Explanation of symbols

1 Customer terminal 2 Network 3 Management server 4 Database (DB)
5 Clerk terminal 6 Store terminal

Claims (5)

A customer terminal that makes a product reservation request, a management server that is connected to the customer terminal via a network and manages inventory of the product, a database that stores management information of the product connected to the management server, and the network In an inventory management system composed of connected store terminals and clerk terminals also connected to the network,
When a product reservation applicant makes a product reservation from the customer terminal, the management server determines a customer rank from the reservation execution degree and the annual purchase amount of the product reservation applicant stored in the database, and this customer A product list that can be reserved by the product reservation applicant is displayed on the display unit of the customer terminal based on the rank and the sales status of the product so that the product reservation can be performed. An inventory management system characterized by sending a message.   In response to a request that the product reservation applicant confirms the product and decides to purchase the product, the management server refers to the database and refers to the last sale date and the sales status of the product to check the inventory of the product. The inventory management system according to claim 1, wherein:   2. The inventory management system according to claim 1, wherein the management server reserves a product in response to a product reservation request from a member customer for a product with good sales status.   The inventory management system according to claim 1, wherein the customer server rejects a reservation request from a member customer for a product with poor sales status.   When a store visitor is a member of a company including a store reserved for a store visit or a group designated by the company, the management server restricts the stock of the product from the purchase record of the member or the purchase record at the past visit reservation. The inventory management system according to claim 1, wherein:

Images