JP2014164330A - Real time stock inquiry system and real time stock inquiry program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a real time stock inquiry system which allows a user to view in real time stocks of a store that the user can visit and a real time stock inquiry program.SOLUTION: The real time stock inquiry system includes: a registration processor for settling a transaction with each customer; a stock management server having a store location database storing a store name uniquely allocated to each store and a store location which is location information for each store and a stock management database storing a stock quantity for each commodity code uniquely allocated to each commodity on the basis of settlement information received from the registration processor; and a location information acquisition part for acquiring a terminal location which is current location information. The system also has a customer terminal which transmits to the stock management server a stock inquiry instruction together with the terminal location and a commodity code, receives a stock quantity read from the stock management database on the basis of a store name which the stock management server reads from the store location database on the basis of the commodity code and the terminal location received, and displays the received store name, store location and stock quantity in an input/output part.

Description

  Embodiments described herein relate generally to a real-time inventory inquiry system and a real-time inventory inquiry program.

  When a customer intends to purchase a product, it is convenient if the customer can know in advance whether or not the product is in stock at a store to be purchased.

  In this regard, in the conventional inventory management system, the update of inventory is often limited to once a day, and it is impossible to know whether there is inventory at the present time.

  On the other hand, some Internet shopping sites that do not have actual stores display real-time inventory. However, this site is difficult to use for customers who want to buy the goods after actually picking them up.

  Furthermore, in the conventional inventory management system, when making an inquiry, it is not possible to list the inventory of multiple stores, and if there is no inventory in one store, re-search to check the inventory of other stores I had to.

JP-A-4-160595

  Accordingly, there is a need for a real-time inventory inquiry system and a real-time inventory inquiry program that can list the inventory of stores that can be visited in real time, that is, in real time.

  In order to solve the above-described problem, an embodiment of the present invention stores a registration processing device that settles a transaction with a customer, a store name that is uniquely assigned to a store, and a store location that is location information for each store. An inventory management server having an inventory management database for storing inventory quantities for each product code uniquely assigned to the product based on the store location database and the settlement information received from the registration processing device, and the terminal location that is the current location information The store name read from the store location database based on the product code and the terminal position received by the inventory management server, the inventory management server transmitting the inventory inquiry instruction together with the terminal location and the product code to the inventory management server The inventory quantity read from the inventory management database is received based on the received store name, store location, and location. To provide a real-time inventory inquiry system comprising a customer terminal to display the quantity to the input-output unit.

It is a block diagram which shows the structure of a real-time stock inquiry system. It is a figure which shows the data structure of a goods master. It is a figure which shows the data structure of a transaction file. It is a figure which shows the data structure of an inventory management file. It is a figure which shows the data structure of a shop position database. It is a figure which shows the data structure of an inventory management database. It is a flowchart which shows the update operation | movement of the stock management database of a real-time stock inquiry system. It is a flowchart which shows store inventory inquiry operation | movement of a real-time inventory inquiry system. It is an example of the inventory confirmation result screen which a customer terminal displays.

  Hereinafter, an embodiment of a real-time inventory inquiry system and a real-time inventory inquiry program will be described in detail with reference to the drawings.

  The real-time inventory inquiry system of the present embodiment includes a registration processing device that settles a transaction with a customer, a store location database that stores a store name that is uniquely assigned to a store, and a store location that is location information for each store, and a registration process. An inventory management server that includes an inventory management database that stores inventory quantities for each product code that is uniquely assigned to a product based on payment information received from the apparatus, and a location information acquisition unit that acquires a terminal location that is current location information From the inventory management database based on the store name read from the store location database based on the product code and terminal location received by the inventory management server. Receiving the read inventory quantity, received store name, store location, and inventory quantity And a customer terminal to be displayed on the output unit.

  FIG. 1 is a block diagram showing a configuration of a real-time inventory inquiry system. As shown in FIG. 1, the real-time inventory inquiry system is a product information registration processing device (hereinafter referred to as a registration processing device) 1 such as a so-called POS (Point of sales) terminal installed in each store, and each store 10. And a management device 2 such as a so-called store controller, connected to the registration processing device 1, an inventory management server 3 connected to the management device 2, and a customer terminal 4 such as a smartphone or a personal computer owned by the customer.

  The registration processing device 1 includes a control unit 11 including a CPU (Central processing unit) that is an arithmetic device, an input / output unit 12 that inputs / outputs information, a communication unit 13 that performs information communication, and storage such as a memory and a hard disk drive. And a storage unit 14 including the device.

  The storage unit 14 stores a product master 14A that stores a unit price for each product code that is an identifier uniquely assigned to each product, and a transaction file 14B that stores the contents of one transaction.

  The storage unit 14 stores a real-time inventory inquiry program. The control unit 11 reads out and executes the real-time inventory inquiry program from the storage unit 14.

  The registration processing device 1 may communicate with the management device 2 such as a store controller via the communication unit 13.

  The management device 2 includes a control unit 21 including a CPU as an arithmetic device, an input / output unit 22 that inputs and outputs information, a communication unit 23 that performs information communication, and a storage unit 24 that includes a storage device such as a memory and a hard disk drive. And comprising.

  The storage unit 24 stores a product master 24A that stores a unit price for each product code, which is an identifier uniquely assigned to each product, and an inventory management file 24B that stores the quantity of stock for each product code.

  The storage unit 24 stores a real-time inventory inquiry program. The control unit 21 reads the real-time inventory inquiry program from the storage unit 24 and executes it.

  When the product code corresponding to the product in one transaction is not in the product master 14A, the registration processing device 1 reads out the corresponding data from the product master 24A of the management device 2 and stores it in the product master 14A to process one transaction. Do.

  When there is a change in the data stored in the merchandise master 24A, the management device 2 transmits the corresponding data to the registration processing device 1. The registration processing device 1 updates the merchandise master 14A based on the received data.

  The inventory management server 3 includes a control unit 31 including a CPU that is an arithmetic device, an input / output unit 32 that inputs and outputs information, a communication unit 33 that performs information communication, and a storage unit that includes a storage device such as a memory and a hard disk drive. 34.

  The storage unit 34 stores a store location database (hereinafter referred to as a database) 34A that stores location information for each store, and an inventory management DB 34B that stores the quantity of stock for each store for each product code.

  The storage unit 34 stores a real-time inventory inquiry program. The control unit 31 reads the real-time inventory inquiry program from the storage unit 34 and executes it.

  The registration processing device 1 updates the stock in the stock management file 24B of the management device 2 every time one transaction is completed. The management device 2 updates the inventory management DB 34B of the inventory management server 3 every time the update of the inventory management file 24B is completed.

  The customer terminal 4 includes a control unit 41 including a CPU that is an arithmetic device, an input / output unit 42 that inputs and outputs information, a communication unit 43 that performs information communication, and a storage unit 44 that includes a storage device such as a memory and a hard disk drive. And a position information acquisition unit 45 that acquires the position information of the customer terminal 4.

  The storage unit 44 stores a real-time inventory inquiry program. The control unit 41 reads out and executes the real-time inventory inquiry program from the storage unit 44.

  The customer terminal 4 is connected to the inventory management server 3 via a public communication line network 5 such as the Internet.

  The position information acquisition unit 45 acquires the position of the customer terminal 4 by longitude and latitude. The position information acquisition unit 45 may be a GPS (Global positioning system), for example, and is not limited thereto.

  FIG. 2 is a diagram illustrating a data configuration of the product master 14A. As shown in FIG. 2, the product master 14 </ b> A includes a “product code” that is uniquely assigned to each product, a “name” that is the name of the product, a “unit price” that is the price per product, Stores “department” indicating the sales department.

  As an example of each data, the product code is “4000000001234”, the name is “Frozen Carbonara”, the unit price is “398”, and the department is “5010”.

  The data configuration of the product master 24A is the same as the data configuration of the product master 14A.

  FIG. 3 is a diagram showing a data configuration of the transaction file 14B. As shown in FIG. 3, the transaction file 14B includes a “product code” indicating a product purchased by the customer, a “name” that is the name of the product, a “unit price” that is a price per product, “Quantity”, which is the number purchased by the customer, is stored.

  As an example of each data, the product code is “4000000001234”, the name is “Frozen Carbonara”, the unit price is “398”, and the quantity is “2”.

  FIG. 4 is a diagram showing a data configuration of the inventory management file 24B. As shown in FIG. 4, the inventory management file 24B includes a “product code” that is uniquely assigned to each product, a “name” that is the name of the product, and a “store name” that indicates the store 10 in which the management device 2 is installed. And “inventory quantity” indicating the current inventory quantity.

  As an example of each data, the product code is “4000000001234”, the name is “Frozen Carbonara”, the store name is “A store”, and the inventory quantity is “12”.

  FIG. 5 is a diagram illustrating a data configuration of the store position DB 34A. As illustrated in FIG. 5, the store position DB 34 </ b> A stores a “store name” indicating each store and a “position” indicating the position of the store.

  In the example of each data, the store name is “Store A” and the position is “East longitude 135 ° 25 ′ 31 ″ North latitude 45 ° 18′04 ″”.

  FIG. 6 is a diagram showing a data configuration of the inventory management DB 34B. As shown in FIG. 6, the inventory management DB 34 </ b> B includes a “product code” that is uniquely assigned to each product, a “name” that is the name of the product, a “store name” that indicates each store, and the current inventory quantity. “Inventory quantity” indicating “” is stored.

  As an example of each data, the product code is “4000000001234”, the name is “Frozen Carbonara”, the store name is “A store”, and the inventory quantity is “12”.

  FIG. 7 is a flowchart showing an update operation of the inventory management DB 34B of the real-time inventory inquiry system. As shown in FIG. 7, in step 701, the registration processing apparatus 1 scans the product code of the product using a scanner.

  In step 702, the registration processing apparatus 1 searches the product master 14A based on the read product code, and reads the name and unit price. The registration processing apparatus 1 stores the read product code, name, and quantity in the transaction file 14B.

  In step 703, the registration processing apparatus 1 determines whether the subtotal button has been pressed. If the registration processing apparatus 1 determines that the subtotal button has been pressed, the process proceeds to step 704. If it determines that the subtotal button has not been pressed, the registration processing apparatus 1 returns to step 701.

In step 704, the registration processing apparatus 1 calculates a subtotal.
In step 705, the registration processing apparatus 1 transmits an update instruction for the inventory management file 24 </ b> B to the management apparatus 2 together with the product code, name, and quantity.
In step 706, the registration processing apparatus 1 inputs a deposit.
In step 707, the registration processing apparatus 1 calculates change.
In step 708, the registration processing apparatus 1 clears the transaction file 14B.

  In step 709, the management apparatus 2 updates the inventory management file 24B. That is, the management device 2 subtracts the received quantity from the inventory quantity corresponding to the received product code and stores it in the inventory quantity.

  In step 710, the management apparatus 2 transmits an update instruction for the inventory management DB 34 </ b> B to the inventory management server 3 together with the product code, name, store name, and inventory quantity.

  In step 711, the inventory management server 3 updates the inventory management DB 34. That is, the inventory management server 3 updates the inventory quantity corresponding to the received product code, name, and store name with the received inventory quantity.

  FIG. 8 is a flowchart showing the store inventory inquiry operation of the real-time inventory inquiry system. As shown in FIG. 8, in step 801, the customer terminal 4 inputs a product code from the input / output unit 42.

In step 802, the customer terminal 4 inputs a store inventory inquiry instruction.
In step 803, the customer terminal 4 acquires the position information of the customer terminal 4 by the position information acquisition unit 45.

  In step 804, the customer terminal 4 transmits a store inventory inquiry instruction to the inventory management server 3 together with the position information, the product code, and the mail address registered in the customer terminal 4 in advance.

In step 805, the inventory management server 3 receives an inquiry instruction.
In step 806, the inventory management server 3 searches the store location DB 34A based on the received location information, and reads store names within a predetermined distance from the received location information.

  In step 807, the inventory management server 3 searches the inventory management DB 34B based on the received product code and the searched store name, and reads the inventory quantity for each store.

  In step 808, the inventory management server 3 transmits the product code, the product name, the store name, and the read inventory quantity for each store as an answer to the customer terminal 4.

  In step 809, the inventory management server 3 transmits a product code, a product name, a store name, and the read inventory quantity for each store as a reply to the received mail address.

  In step 810, the customer terminal 4 displays the inventory for each store based on the received answer at the input / output unit 42.

  FIG. 9 is an example of an inventory confirmation result screen 901 displayed by the customer terminal 4. As illustrated in FIG. 9, the customer terminal 4 displays a list of product codes, names, and stocks for each store on the inventory confirmation result screen 901.

  The customer terminal 4 may display the inventory quantity for each store on the inventory confirmation result screen 901 using the map 902.

  In this case, the inventory quantity may be displayed by a balloon 904 at the location of each store on the map 902, and the position of the customer terminal 4 may be displayed as the current position 903.

  As described above, the real-time inventory inquiry system of the present embodiment includes the registration processing device 1 that settles transactions with customers, the store location DB 34A that stores location information for each store, and the settlement information received from the registration processing device 1. The inventory management server 3 includes an inventory management DB 34B that stores the inventory for each product code uniquely assigned to the product, and the location information acquisition unit 45 that acquires location information. An instruction is transmitted together with location information and a product code, and the inventory quantity read from the inventory management DB 34B is received based on the store name read from the store location DB 34A based on the product code and location information received by the inventory management server 3, and received. A customer terminal 4 having an input / output unit for displaying the store name, the store position for each store, and the inventory quantity; Provided.

  Accordingly, there is an effect that the inventory of stores that can be visited in real time can be listed.

  Although several embodiments have been described, these embodiments have been presented by way of example and are not intended to limit the scope of the invention. These embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. These embodiments and their modifications are included in the scope and gist of the invention, and are also included in the invention described in the claims and the equivalents thereof.

1: Registration processing device 2: Management device 3: Inventory management server 4: Customer terminal 34A: Store location database 34B: Inventory management database

Claims (6)

A registration processing device that settles transactions with customers;
Stock for each product code uniquely assigned to the product based on the store location database storing the store name uniquely assigned to the store and the store location which is location information for each store and the settlement information received from the registration processing device An inventory management server comprising an inventory management database for storing quantities;
A location information acquisition unit that acquires a terminal location that is current location information, and transmits an inventory inquiry instruction to the inventory management server together with the terminal location and the product code, and the product code received by the inventory management server; The inventory quantity read from the inventory management database based on the store name read from the shop location database based on the terminal location is received, and the received store name, the store location, and the inventory quantity are input / output units Customer terminals to be displayed on
Real-time inventory inquiry system. The customer terminal is
The real-time inventory inquiry system according to claim 1, wherein a real-time inventory quantity for each store is displayed on the input / output unit using a map. The customer terminal is on the map,
The current location of the customer terminal;
The real-time inventory inquiry system according to claim 2, wherein the store location and the inventory quantity for each store are displayed. The customer terminal is
4. The real-time inventory inquiry system according to claim 3, wherein the inventory quantity for each store is displayed in a balloon at the location of the store on the map. The inventory management server
The real-time inventory inquiry system according to claim 4, wherein the inventory for each store is transmitted by e-mail to a pre-designated e-mail address. A registration processing device that settles transactions with customers;
Stock for each product code uniquely assigned to the product based on the store location database storing the store name uniquely assigned to the store and the store location which is location information for each store and the settlement information received from the registration processing device An inventory management server comprising an inventory management database for storing quantities;
A customer terminal comprising a position information acquisition unit for acquiring a terminal position which is the current position information;
A real-time inventory inquiry program for a real-time inventory inquiry system comprising:
The management server
When receiving an inventory inquiry instruction from the customer terminal together with the terminal position and the product code,
Inventory quantity reading means for reading the inventory quantity from the inventory management database based on the store name read from the store position database based on the product code and the terminal position received by the inventory management server;
Stock quantity transmitting means for transmitting the store name, the store position, and the inventory quantity to a customer terminal that displays the received shop name, the shop position, and the inventory quantity on an input / output unit;
Real-time inventory inquiry program to function as.

Images