JP2002029610A - Comprehensive merchandise management system using information system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a physical distribution management system matching with information society and, to say in details, provide a merchandise management system using an information system capable of comprehensively and efficiently managing commodities in a store and a warehouse using a communication type handy terminal unit having a mobile function. SOLUTION: A function for transmitting and receiving information between the handy terminal unit in each store selling the commodities, and a server connected to the Internet is provided to confirm the contents of the server from a terminal unit of the Internet on a screen.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a general merchandise management system using a computer network such as the Internet, and more particularly, to a merchandise store and a stocktaking store and a warehouse for holding produced merchandise as stock. The present invention relates to a comprehensive product management system using an information system that efficiently manages a handy terminal having a mobile function (such as a mobile phone or a PHS) in order to comprehensively manage products that pass between them.

[0002]

2. Description of the Related Art Conventionally, merchandise management of a store that sells and inventory goods is performed by a POS (Point Of Sale) installed in the store.
s) It is performed by terminal, and the data of each store is managed at the center. Product data such as warehouse stock is managed by a computer or the like separate from the store.

[0003]

Conventionally, merchandise management at stores is performed by POS, so that sufficient management of stocks and the like cannot be performed, and since the POS has a settlement function, especially in stocktaking. There is an inconvenience that the user must frequently go back and forth between the product placement place and the checkout place.
In addition, there is a possibility that an input error may occur due to data aggregation by the POS, and the work time is considerably long. Further, since the management between the POS and the warehouse is not comprehensively performed, the merchandise management as a business entity that sells merchandise at many stores is insufficient.

[0004] The present invention has been made in view of the above circumstances, and an object of the present invention is to provide a product management system that matches the information-oriented society.
An object of the present invention is to provide a comprehensive product management system using an information system for comprehensively and efficiently managing products in stores and warehouses using a handy terminal having a mobile function.

[0005]

SUMMARY OF THE INVENTION The present invention relates to a comprehensive merchandise management system using an information system such as the Internet. The object of the present invention is to connect a handy terminal of each store selling merchandise to the Internet. This is achieved by providing a function capable of transmitting / receiving data to / from a server so that the contents of the server can be confirmed on a screen from the terminal on the Internet.

[0006] An RAS is connected to the server, and the transmission / reception is performed via a PHS line or a mobile phone line, or the server has a product master as a database, or Is installed for each company, and at least the product name, product code, cost,
By registering retail prices, standards, departments, categories, or by providing a bar code reading function on the handy terminal, or by attaching a connection function to the printer on the handy terminal, using an optical, wireless or wired printer The above object of the present invention can be achieved more effectively by enabling print data to be transmitted to the printer.

[0007]

BEST MODE FOR CARRYING OUT THE INVENTION A comprehensive product management system using the information system of the present invention is applicable not only to stores that sell products but also to warehouses that hold and store products sold at many stores such as convenience stores and supermarkets. In order to ensure reliable and comprehensive management, install a communication type handy terminal at each store and input data, and open the data to member companies and general consumers on a server connected to the Internet. I have. Able to conduct marketing analysis based on output data by using a PHS-compatible communication handy terminal as a tool for the purpose of completely centrally managing inventory data for e-commerce and stores on the Internet. It is. For companies that want to realize the initial investment (preparation of infrastructure) at no cost, it can provide stock-based information with full performance fee. When creating inventory data, you can check the data on the web, check and correct it with your own program, and check the stock easily if you have a browser because it is fully web-based Can be. Also, after reading the barcode with the handy terminal, the data can be collectively received by the server via the PHS line, the code system can be set at the time of input, and the product data can be imported into the handy terminal, so it is not set There is no erroneous input of the code.

Hereinafter, a comprehensive merchandise management system using an information system according to the present invention will be described with reference to the drawings.

FIG. 1 is an overall configuration showing the concept of the present invention. A server 10 managed by a business entity is an Internet 1
And the server 10 is connected to each store (A to C) 2
Are connected via a RAS (Remote Access Server) 11 via a PHS line. The server 10 has a product master 12 for registering products of each company,
Product name, product code (barcode),
There are costs (purchase prices), retail prices, standards (weight, size, color, etc.), departments, and categories (pharmaceuticals, beverages, foods, miscellaneous goods, etc.). The server 10 is connected to a warehouse system 31 that manages the stock of merchandise held in the warehouse 30, and the contents of the server 10 (the stock status of the warehouse, the stock status of each store, etc.) are stored in each store 2. Can be read out in real time from a terminal (personal computer) or another terminal (personal computer) 3 installed on the terminal and can be confirmed on the screen.

FIG. 2 shows the external structure of the handy terminal 20 used in the present invention. The portable terminal 20 has a portable shape mainly composed of a display portion (upper portion) and a key portion (lower portion). And a function of inputting data and communicating with the server 10. The key part includes a power key 21 and a left (L) right (R) scroll key 2 for moving the screen to the previous screen or the next screen.
2. Ten keys 23 for inputting data and the like, an enter key (confirmation key) 24 for confirming data input, and function keys 25 for moving to various screens and inputting various instructions are provided. The shift key "S" 26 is used to switch between upper and lower alphabets and numbers on the numeric keypad 23. When the barcode reading trigger 27 is pressed, the barcode reading trigger 27 emits a laser beam to start reading the barcode. The handy terminal 20 can read a barcode attached to a product by scanning with a laser beam, easily input a barcode, and optically transmit data to a personal computer or the like from the transmission unit 28. be able to. The handy terminal 20 is a PHS
And a transmission / reception circuit for transmitting / receiving data via the RAS 11 of the server 10.

[0011] The bar code is the function key 2
By switching 5, the manual input is also possible. In this example, the transmission unit 28 transmits light (infrared rays or the like), but transmission may be performed wirelessly or by contact with a connector.

The handy terminal 20 has an initial setting function,
It has an inventory function, a data search / modification function, a data transmission / reception function, and a data printing function. In the initial setting function, the ID of the handy terminal, the head office code and store code of the rental destination, and the product master (part number, standard, size) The same location (location)
Before starting the operation, it is set whether or not to perform a duplication check within a stage. The inventory function includes a pre-inventory function (inspection of whether all part numbers of stock items are registered in the product master before book inventory) and a book inventory function. Inventories) and a value inventory function (inventory based on product number, selling price and quantity). Data search is 1) location, 2) location +
Steps, 3) location + part number, 4) location + part number + step, 5) part number pattern. The data transmission / reception function enables data transmission / reception in the I / O box and the PHS. The reception data includes initial setting data, product master data, product master unregistered data (created in the server 10), and store-by-store data. Duplicate data (created on server 10), inventory difference data (created by comparing with theoretical stock on server 10), inventory list data (created on server 10)
There is. The transmission data includes previous inventory data, book inventory data, inventory correction data (for inventory difference data correction, inventory list data correction), and business end data.

FIG. 3 shows an outline of a commercial transaction. A consumer registered as a member inputs an ID and a password to a server 10 connected to the Internet 1 (step P1), and the member information of the server 10 is entered. Is checked on the screen (Step P2), a product search for a product to be purchased is performed (product shelf browsing) (Step P3), a product is selected on the screen (Step P4), and the contents put in the shopping basket are checked. To confirm the product (Step P5) and purchase the product (Step P6).

Note that the application for membership is made on a screen as shown in FIG. 4, and the name (kanji, kana), mail address, address,
Enter your phone number, date of birth, gender, and password. In the case of a corporation, enter the department name together with the company / organization name (Kanji, Kana). When the registration of the member is approved, an ID number is given, and the member is registered in the server 10 as a member.

When the merchandise is purchased as described above, the delivery destination of the merchandise is selected from the home, the designated destination, and the reservation at a convenience store (step P7). When the designated delivery destination is selected, delivery destination information such as an address, a telephone number, a company / organization name, a department name, and a recipient name is input (step P71), and a desired delivery date is designated (step P71).
72), the delivery information is confirmed (step P73). In addition, when the delivery destination is selected for the convenience store reservation, a map search is performed (step P74), and the nearest and convenient reservation store is determined from the searched map information (step P75).

When the delivery destination is determined as described above,
Next, select a payment method such as bank transfer, credit card,
It selects from cash on delivery, convenience store payment and post office transfer (step P8). In the case of a bank transfer, the transfer destination bank account is confirmed (step P81), and in the case of a credit card, card information such as a card company name, a card number, and an expiration date is entered (step P82). Please wait for a while because the expiration date has been confirmed. "(Step P83).

Next, it is confirmed on the screen which of the above four payment methods has been selected (step P9), the order of the product is confirmed on the screen (step P10), and the order number is further confirmed on the thank-you screen. (Step P11), a thank-you mail for confirmation is transmitted to the orderer (Step P1)
2). Thereafter, when the payment is made by the above four methods, a shipping completion mail is received (step P13), and the goods are received by each designated delivery (step P1).
4, P15). In the case of cash on delivery designation, payment is made when the goods are received.

FIG. 5 shows an operation example of data transmission from the handy terminal 20 to the server 10 when the product master 12 is not present. First, input items of the handy terminal 20 are set (step Q1), and the handy terminal 2 is set.
Data input with 0 is started (step Q2), and input data search (step Q3) and correction of input data (step Q4) are repeated until data confirmation is completed (step Q5). Thereafter, the data input using the PHS line is transmitted to the server 10 (step Q6),
This transmission data is received by the server 10 (step Q
7). The server 10 publishes the received data as text data on the web (step Q8), and displays details of each person in charge and location (step Q9).

FIG. 6 shows the product master 12 as shown in FIG.
An operation example of data transmission from the handy terminal 20 to the server 10 in the case where there is a
2 is confirmed (step Q10), and the product master 12 is cleaned (step Q11). Then, input items of the handy terminal 20 are set (step Q1).
2), data input by the handy terminal 20 is started (step Q13), and search of input data (step Q14) and correction of input data (step Q15) are repeated until data confirmation is completed (step Q1).
6). Thereafter, the data input using the PHS line and the RAS 11 is transmitted to the server 10 (step Q1).
7), the server 10 receives this transmission data (step Q18). The server 10 collates the received data with the data of the product master 12 (step Q20), receives the collation result at the handy terminal 20 (step Q21), and prints the data with a printer (step Q2).
2) After that, it is published on the web as text data (step Q23). Then, a list of unregistered product data is displayed (step Q24), a summary table for each department / location is displayed (step Q25),
The detailed schedule for each location is displayed (step Q26),
The data is printed as a form (step Q2
7). Printing is performed by a printer via the transmission unit 28.

Hereinafter, the function of the handy terminal 20 and the inventory work using the function will be described in detail.

FIG. 7 shows a menu flow of the handy terminal 20. When the power is turned on, the "head office code", "store code",
“Terminal ID” is displayed on the display unit, and the main menus are “Inventory”, “Receipt / Ship”, “Data Transmission /
"Data maintenance", "Print", and "Terminal setting" are displayed (menu M1). And the main menu M
If "Inventory" is selected from among 1, "Book inventory" and "Previous inventory" are displayed (menu M2), and if "Book inventory" is selected here, "Single item inventory" and "Amount inventory" are further displayed. (Menu M3).

When "data transmission / reception" is selected from the main menu M1, "data transmission", "data reception", and "field strength inspection" are displayed (menu M4).
If "Data transmission" is selected here, "PHS", "I /
“O box” is displayed (menu M5), and “book inventory”, “pre-inventory”, “stock difference correction data”, and “stock correction data” are displayed (menu M
6). When "data reception" is selected from menu M4, "PHS" and "I / O box" are also displayed (menu M7), and the same menu (request transmission, data reception) is displayed regardless of which is selected (menu M8, M8
'), Select "Request transmission", "Initial setting data", "Product master", "Unregistered product data", "Inventory duplicate data", "Stock difference data", "Stock list data" are displayed (menu M9, M9 '), when "data reception" is selected, "initial setting data", "product master", "unregistered product data", "inventory duplicate data",
“Stock difference data” and “stock list data” are displayed (menus M9 and M9 ′).

When "data maintenance" in the main menu M1 is selected, "search / correction" and "delete all data" are displayed (menu M10), and "search / correction" is displayed.
Select "Initial setting data", "Product master",
"Unregistered product data", "Inventory duplicate data", "Stock difference data", and "Stock list data" are displayed (menu M11), and "Delete all data" is selected from menu M10.
Is selected, "Book Inventory Data", "Previous Inventory Data",
“Unregistered product data”, “inventory duplicate data”, “stock difference data”, “stock difference correction data”, “stock list data”, and “stock list correction data” are displayed (menu M12). When "print" is selected from the main menu M1, "book inventory data", "unregistered product data",
“Inventory duplicate data”, “stock difference data”, and “stock list data” are displayed (menu M13), and “terminal setting”
Is selected, "communication setting" and "headquarters / store setting" are displayed (menu M14).

FIG. 8 shows the timing of data transmission and reception between the handy terminal 20 and the server 10. First, a previous inventory is performed on the handy terminal 20 side (step S100).
Is transmitted and received (step S101). Thereafter, book inventory is performed at the handy terminal 20 (step S).
102), the inventory data is transmitted to the server 10 and received (step S103), and the data is corrected, added,
After the deletion, the data is transmitted to the handy terminal 20 (steps S104 and S105).

Then, a data request is transmitted from the handy terminal 20 to the server 10 (step S110), the server 10 performs server processing (step S111), and transmits the data to the handy terminal 20. Thereafter, the handy terminal 20 displays the initial setting data (step S112), the product master (step S113), the unregistered product data (step S114), the inventory duplicate data (step S115), and the stock difference data (step S1).
16), and process the inventory list data (step S117).

The handy terminal 20 searches for unregistered merchandise data and inventory duplicate data (step S120), and can perform printing with a printer. In addition to the data search, the inventory difference data and the inventory list data can be corrected, deleted, and added (step S121), and can be printed.
Then, the search, correction, deletion, and additional data are transmitted to the server 10, and the process ends (step S122).

By the way, the pre-inventory is to confirm whether the product code of the stock is registered in the product master as a pre-process of the book inventory, and is performed according to the flow shown in FIG.
First, when the location BC (barcode) scan “1.Y” is selected in the initial setting of the area management (step S1), the barcode is read. When “2.N” is selected in the above step S1, the location is entered from the numeric keypad 23. input. If "2.N" is designated in step S1, manual input is required. If the barcode cannot be read,
By pressing "F6" of the function key 25, the contents of the bar code are input from the ten keys 23. The type of area barcode is selected for each shelf and its number is input (step S2), and it is checked whether or not the product master 12 is taken in during the previous inventory (step S3). And
Enter “1.Y” to check the presence in the product master 12 by inputting the product code, and enter “2.N” if the presence is not checked. Next, it becomes the product number BC (bar code) type for each product, and the bar code type is changed to “1.
C "," 2. NW-7 "," 3. ITF "," 4. CO
DE39 "," 5. CODE93 "," 6. CODE1
28 "," 7. MSI "," 8. IATA "," 9. I
Next, the user selects one of nine types of “ndustrial 2 of 5” and inputs the number (step S4).

Next, an initial setting for using a barcode standard CD (code) is made (step S5). If a standard code is to be input, "1.Y" is input, otherwise, "2.N" is input. ". Then, the mode becomes the input mode of the standard BC type (step S6), and the type of the barcode is selected and the number is input. Thereafter, the selling price input mode is set (step S7). If a selling price code is to be entered, "1.Y" is entered, otherwise "2.N" is entered and the process is terminated. Thereafter, the selling price BC type mode is set (step S8), and the type of the barcode is selected and its number is input. Thereafter, the total number of selling price digits of the bar code is input (step S9), the number of digits of the starting position of the selling price included in the selling price code is input (step S10), and the number of digits of the selling price included in the selling price code is further input. (Step S11),
Further, when manually inputting the selling price, characters to be input before and after are input (step S12).

The screen displayed in the previous inventory differs depending on the contents registered in the initial setting of FIG. 9, but the input method of each item is as shown in FIGS. “Location” in FIGS. 10 and 11 means input of a location, and “stage” means a stage input by the ten keys 23. Also,
“Product” means input of a product code, “Regular” means input of a standard code, and “Sell” means input of a selling price code.

Next, the book inventory operation will be described with reference to the flowchart of FIG. First, the location BC (barcode) scan is input by default as "1.Y" when a barcode is used and "2.N" when a barcode is not used (step S20). The location / stage BC type is performed by selecting the type of the code and inputting the number (step S21). Then, when checking the existence in the product master by inputting the product code, refer to “1.
"Y." If there is no existence check, enter "2.N" to check the product master (step S2).
2) Enter "1.Y" to check the presence of the same product code at the same location / stage, and enter "2. Y" to not check the presence of the same product code at the same location / stage.
N "is input (step S23). Then, the type of the barcode is selected, the number is input, and the product number BC type is performed (step S24). Next, when a standard code is input, "1.Y" is input, and when the standard code is not input. Inputs "2.N" to use the standard CD (step S25), selects the type of barcode, and inputs the number to perform the standard BC type (step S26). Furthermore, when checking the quantity upper limit, enter “1.Y”. When not checking the quantity upper limit, enter “2.N”.
When "1. Y" is entered, the quantity upper limit is entered (step S27). Then, enter "ENT" to display the quantity by default, enter "2 + ENT" to display the quantity by default, and enter the default display value of the quantity if you enter "ENT" (step S28).

The screen displayed in the single item inventory differs depending on the contents registered in FIG. 12, but the input of each item is performed according to FIGS. 13 and 14, and “location”, “stage”, “article”,
“Rule” is the same as in the case of the previous inventory described with reference to FIGS. 10 and 11, and “number” means the quantity.

Next, a description will be given of the stock taking of money, with reference to FIG. 15 and FIG. The value inventory is an inventory that inputs a selling price and a quantity, and performs an inventory based on a total sum and a calculation.

First, in the initial setting of the location BC scan (step S30), "1.Y" is selected when a barcode is used for inputting a location, and "2.N" when a barcode is not used. Select “1.Y”
If is selected, the type of barcode is selected and its number is input (step S31). After that, or when "2.N" is selected in step S31, the initial setting of the use of the department is performed (step S32). When the department is input, "1.Y" is selected, and when the department is not input. Inputs "2.N", and further inputs whether or not the department is mandatory (step S33). If the existence check is to be made in the commodity master by inputting the commodity code, "1.Y" is selected, and if not, "2.N" is entered (step S34). If the existence of the product code is to be checked, select "1.Y". If the existence of the same product code is not to be checked, select "2.N" (step S35) and initialize the use of the part number CD (step S40). ). If you enter a part number code, enter “1.Y”. If you do not enter a part number code, enter “2.N”. If “1.Y” is entered, select the type of barcode. Then, the number is entered (step S41), and the required / optional part number CD is further entered (step S42).
If "N" is input, use a standard CD, enter "1.Y" to input a standard code, or enter "2.N" if no standard code is input (step S4).
3). If "1.Y" is input in step S43, the type of the barcode is selected and the number is input to perform the standard BC type (step S44), and the required / optional standard CD is selected (step S44). Step S45). After that, or when "2.N" is input in step S43, the bar code type is selected and the number is input to perform the selling price BC type (step S50), and the total number of digits of the selling price code is input. (Step S51). Then, when the number of digits of the start position of the selling price included in the selling price code is input (step S52), the number of digits of the selling price included in the selling price code is input (step S53), and when the selling price is manually input,
Characters to be input before and after are input (step S54). Further, whether or not the quantity upper limit value is checked is input (step S5).
5) Enter the quantity upper limit value (step S56), and enter quantity D
The EF value is set (step S57). To display the quantity by default, enter “ENT”. To not display the quantity by default, enter “2 + ENT” and enter “E”.
If "NT" is entered, the default display value of the quantity is entered (step S58).

Although the screen displayed in the amount inventory differs depending on the contents registered in FIG. 15 and FIG. 16, input of each item is performed according to FIG. 17 and FIG.

Data maintenance is divided into data search and deletion of all data.
It is divided into previous inventory data, unregistered product data, duplicate inventory data, inventory difference data, and inventory list data.

The book inventory data is used to search, correct, add, and delete data input in book inventory (single item inventory, value inventory). Search condition setting input is based on FIG. This is done by inputting, inputting columns, and displaying data. In addition, the previous inventory data is searched, corrected, and deleted for the data input in the previous inventory, and the unregistered product data is searched for the unregistered product data received from the server. Inventory duplicate data searches for inventory duplicate data received from the server, inventory difference data searches, corrects, adds, and deletes inventory difference data received from the server, and inventory list data matches inventory list data received from the server. Search, modify, add and delete.

In the above description, the handy terminal of each store and the server are connected by a PHS line, but any portable terminal capable of wireless communication may be used.

[0038]

As described above, according to the comprehensive merchandise management system using the information system according to the present invention, a merchandise management system that matches the information society can be provided. It can be managed at the handy terminal, and it is possible to manage the stock status of stores and warehouses collectively. The stock status of each store can be checked immediately on the screen, and it is not necessary to check by telephone, and the stock can be smoothly checked and moved between many stores. Further, a product master can be created and maintained, and the received data can be provided in a file format by totaling and processing the data.

Further, physical inventory can be easily performed,
It becomes possible to grasp the stock and long-term staying items for each item individually, and it can be used as data for confirming the difference from the theoretical inventory (book). In addition to not only determining the detailed data for each department and location, determining the amount of merchandise available by the selling price reduction method or the cost method, it is also possible to create an inventory report for settlement of accounts.

[Brief description of the drawings]

FIG. 1 is a diagram showing an overall configuration of the present invention.

FIG. 2 is an external view of a handy terminal used in the present invention.

FIG. 3 is a flowchart showing an operation example of the present invention.

FIG. 4 is a screen view of a member registration in the present invention.

FIG. 5 is a flowchart showing an operation example of the handy terminal when there is no product master.

FIG. 6 is a flowchart showing an operation example of the handy terminal when there is a product master;

FIG. 7 is a flowchart of a menu screen of the handy terminal.

FIG. 8 is a timing chart showing a processing example between a handy terminal and a server.

FIG. 9 is a flowchart showing an operation example of the previous inventory.

FIG. 10 is a diagram for explaining a method of inputting items of previous inventory.

FIG. 11 is a diagram for explaining a method of inputting items of previous inventory.

FIG. 12 is a flowchart showing an example of book inventory operation.

FIG. 13 is a diagram for explaining a method for inputting items for single item inventory.

FIG. 14 is a diagram for explaining a method of inputting items for single item inventory;

FIG. 15 is a part of a flowchart showing an example of the operation of the amount inventory.

FIG. 16 is a part of a flowchart showing an example of the operation of the amount counting;

FIG. 17 is a diagram for explaining an amount inventory.

FIG. 18 is a diagram for explaining an amount inventory.

FIG. 19 is a diagram for explaining search condition setting.

[Explanation of symbols]

 1 Internet 2 Store 3 Terminal (PC) 10 Server 11 RAS 12 Product Master 20 Handy Terminal 30 Warehouse 31 Warehouse System

Continued on the front page (72) Inventor Yuichiro Araki 6-27-8 Jingumae, Shibuya-ku, Tokyo Inside Goodwill Communication Co., Ltd. (72) Inventor Masataka Hanazawa 6-27-8 Jingumae, Shibuya-ku, Tokyo Goodwill Co., Ltd. In communication F term (reference) 3F022 MM03 MM07 MM11 MM21 PP04 5B049 AA02 AA06 BB11 CC28 DD02 DD05 EE05 FF02 FF04 FF09 GG06 GG07

Claims (6)

[Claims] 1. A function capable of transmitting and receiving data between a handy terminal of each store that sells products and a server connected to the Internet, so that the contents of the server can be confirmed on a screen from the terminal of the Internet. A comprehensive product management system using an information system characterized by the following. 2. An integrated product management system using an information system according to claim 1, wherein an RAS is connected to said server, and said transmission and reception are performed by a PHS line or a mobile phone line. 3. A comprehensive product management system using the information system according to claim 1, wherein said server has a product master as a database. 4. A comprehensive system using the information system according to claim 3, wherein said product master is set up for each company and at least a product name, a product code, a cost, a retail price, a standard, a department, and a category are registered. Product management system. 5. An integrated product management system using the information system according to claim 1, wherein said handy terminal has a barcode reading function. 6. A general product using the information system according to claim 1, wherein a connection function to a printer is attached to said handy terminal so that print data can be transmitted to the printer by light, wireless or wire. Management system.