JP2014142966A - Sales management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a sales management system that allows a user to easily identify merchandise that became sales leakage in a case that many merchandises are sold at once.SOLUTION: A merchandise master 20 associates a plurality of merchandise codes with a merchandise group name, theory weight, and volume. Calculation means 11 acquires the merchandise codes and a quantity, and calculates a final total of the theory weight. Scales 50 measures actual weight. A touch panel 40 displays the final total of the theory weight and the actual weight, and, according to a display control operation, determines whether: to display a quantity for each merchandise division name; or to display by associating combination of the merchandise group name and the volume with a quantity for each combination.

Description

  The present invention relates to a sales management system.

  When a product is sold and recorded in the store using the POS system, some of the many products may be delivered to the purchaser without being input to the POS system due to a salesperson's error or the like. . Since products that are not input to the POS system are not reflected in the billing fee, a sales omission occurs.

  In order to prevent such a situation, a configuration for confirming a product using a weight value is known. For example, in the configuration of Patent Document 1, the total weight of the products weighed by the measuring instrument is compared with the total weight retrieved using the product code, and an alarm is generated if they are different.

Japanese Patent Laid-Open No. 7-141568

However, the conventional system has a problem that, when a large number of products are sold at a time, it is complicated to identify which product is a sales failure after discovering that there is a sales failure.
For example, in the configuration of Patent Document 1, it is not possible to input the quantity of products, and it is necessary to scan all the products one by one. For this reason, when a sales omission is detected when a large number of single-type products are sold, it is necessary to recount all types of products, and the confirmation work becomes complicated.
Further, even in a system that can input the quantity of products, it is necessary to recount all types of products if the input of the quantity is incorrect, and the confirmation work becomes complicated.

  The present invention has been made to solve such problems, and provides a sales management system that makes it possible to easily identify a product that has failed to be sold when many products are sold at once. The purpose is to do.

In order to solve the above problems, the sales management system according to the present invention is:
Storage means for storing a product master for associating a product group name, theoretical weight and capacity for each of a plurality of product codes;
Product code obtaining means for obtaining at least one product code as a target product code;
A calculation unit that obtains a quantity for each of the target product codes, and calculates a total theoretical weight based on the theoretical weight and the quantity related to each of the target product codes;
Display means for displaying the total theoretical weight and the actual weight;
Operation input means for receiving a display control operation for controlling the display means,
The display means is responsive to the display control operation,
-Display the product group name in association with the quantity for each product group name,
-Decide whether to display the product group name and capacity combination in association with the quantity for each combination.

The product master further associates a manufacturer name with each of the plurality of product codes,
In accordance with the display control operation, the display means may further determine whether to display a manufacturer name and a quantity for each manufacturer name in association with each other.
The product master further associates a shape with each of the plurality of product codes,
In accordance with the display control operation, the display means may further determine whether to display a combination of a product group name and shape and a quantity for each combination in association with each other.
The display unit may further display a warning when the total of the theoretical weights does not match the actual weight obtained by measuring the weight of the object.

  According to the sales management system of the present invention, whether the product group name and the quantity for each product group name are displayed in association with each other, or the combination of the product group name and capacity and the quantity for each combination are displayed in association with each other. Can be displayed while switching arbitrarily, so that a product that has lost sales can be easily identified.

It is a figure which shows the structure of the sales management system which concerns on Embodiment 1 of this invention. It is a figure which shows the example of a structure of the goods master which concerns on Embodiment 1. FIG. It is a flowchart showing the flow of a process of the sales management system of FIG. It is an example of the screen which displays the quantity for every goods name concerning Embodiment 1. FIG. It is an example of the screen which displays the quantity for every goods department name which concerns on Embodiment 1. FIG. 4 is an example of a screen that displays the quantity for each product department / capacity according to the first embodiment. It is a figure which shows the example of a structure of the goods master which concerns on Embodiment 2. FIG. It is an example of the screen which displays the quantity for every goods name concerning Embodiment 2. It is an example of the screen which displays the quantity for every manufacturer name which concerns on Embodiment 2. FIG. It is an example of the screen which displays the quantity for every merchandise department and shape which concerns on Embodiment 2. FIG.

Embodiments of the present invention will be described below with reference to the accompanying drawings.
Embodiment 1 FIG.
FIG. 1 shows a configuration of a sales management system 100 according to Embodiment 1 of the present invention. The sales management system 100 is used in retail stores, for example.
The sales management system 100 includes a control device 10 that controls the operation thereof. The control device 10 has a configuration as a well-known computer, and includes a calculation unit 11 that performs a calculation and a storage unit 12 that stores information. The calculation means 11 includes a CPU (Central Processing Unit), and the storage means 12 includes a storage medium such as a semiconductor memory and an HDD (Hard Disk Drive).

The sales management system 100 includes a scanner 30 that acquires a product code assigned to a product. In the present embodiment, the product code acquired by the scanner 30 is to be sold.
The sales management system 100 includes a touch panel 40. The touch panel 40 serves as a display unit and an operation input unit. Instead of the touch panel 40, display means (liquid crystal panel or the like) and input means (keyboard or the like) may be provided individually.

The sales management system 100 includes a scale 50 as a weight measuring unit that measures the weight of an object. The scale 50 includes an after-sales basket 51 that accommodates an object, and measures the total weight of an object (for example, a product) existing in the after-sales basket 51. In the present specification, the weight measured from time to time by the balance 50 is referred to as “actual weight”, and the weight stored in advance or calculated based on this is referred to as “theoretical weight”.
Although not shown in particular, the sales management system 100 has a configuration as a known POS system, such as a printing unit for printing a receipt.

The storage unit 12 of the control device 10 stores a product master 20.
FIG. 2 shows an example of the configuration of the product master 20. The product master 20 stores information related to the product in association with the product code representing each of the plurality of products. Information related to the product includes a product name, a product department name, a capacity, and a weight (theoretical weight).

  The product name is, for example, information for a salesperson to identify the product, and is represented by text data, for example. The product department name is information for identifying each group when the product is classified into groups, and is represented by text data, for example. When a plurality of products belong to the same group, the same product department name is designated for those product codes. A capacity | capacitance represents the net capacity | capacitance of goods, for example, is represented by a numerical value (a unit may be included). The theoretical weight represents the weight of the product, and is represented by, for example, a numerical value (may include a unit).

  The theoretical weight can be designated as appropriate. For example, a nominal weight by the manufacturer may be used, or actual measurement may be performed in advance at a store or the like, and the measured value may be stored and used. Further, when an error due to the weight of the packaging or the like can be tolerated, the net weight of the contents may be used as the theoretical weight instead of the total weight including the packaging or the like. The definition or determination method of the theoretical weight may vary depending on the product.

The processing flow of the sales management system 100 configured as described above will be described below.
FIG. 3 is a flowchart showing a process flow of the sales management system 100 according to the first embodiment. First, a salesperson who operates the sales management system 100 performs a predetermined scan start operation. In response to this, the calculation means 11 receives the scan start signal (step S1), and starts the processing of FIG. Note that step S1 may be omitted, and in this case, the process may be started from step S2.
The sales management process shown in FIG. 3 is roughly divided into a first half product registration process and a second half settlement process. Specifically, the first half is a process of registering a product through the scanner 30, and the second half is a process of making a payment with a user who purchases the product, such as receiving cash and making a credit payment. Although there are places where product registration has been scanned and product registration omissions are expressed as scan omissions, in this embodiment, an example of registering products via the scanner 30 is described. Is a word.
In the process flow shown in FIG. 3, step S9 is a confirmation process for shifting from the first half to the second half process, step S10 is the second half process, and the other processes are the first half process.

  Next, the computing means 11 acquires at least one product code to be sold via the scanner 30 (step S2). The product code is acquired, for example, when the salesperson causes the scanner 30 to read an identification pattern (bar code or the like) attached to the product. Here, the product code acquired by the scanner 30 may be referred to as “target product code” below. The scanner 30 may acquire a plurality of target product codes in accordance with salesperson operations.

  Here, the salesperson takes out a product (for example, a product stored in the pre-sales basket 60 in FIG. 1) placed outside the after-sales basket 51 and causes the scanner 30 to scan, and then sells the scanned product. It is accommodated in the rear basket 51. With this operation, the product associated with the target product code becomes the target of weight measurement by the scale 50.

  Moreover, in this step S2, the calculating means 11 acquires the quantity (number) for every object product code. The sales person can input the quantity from the touch panel 40 or the like. For example, after the salesperson scans the product code of a certain product by the scanner 30 and before scanning another product code, the salesperson operates the numeric buttons on the touch panel 40 to input a numerical value, thereby representing the product code. You can enter the quantity of goods sold. Further, when the product code of the next product is scanned without entering a numerical value, it is handled that the value “1” is acquired as the quantity. As such an operation, a known POS system operation may be employed.

The computing means 11 calculates the total theoretical weight based on the theoretical weight and quantity associated with each target product code. In addition, the scanned product may be displayed on the liquid crystal panel installed on the user side (step S3). Next, the salesperson scans all product codes and then performs a predetermined scanning end operation. In response to this, the calculation means 11 receives a scan end signal (step S4). The predetermined scan end operation is, for example, that the touch panel 40 is provided with a button “subtotal” and the salesperson presses the “subtotal” button.
During product registration in the first half of the process, the amount is accumulated and added in real time, and the total amount to be paid by the user is displayed.
In step S4 and subsequent steps, the total amount is confirmed by processing for confirming whether or not the second half of the process is entered (departure that there will be no registration of the product since the transaction will be transferred from now on), and proceeds to the second half of the settlement processing. . As described later, when a scan omission occurs, re-settlement processing can be performed by additionally registering a product and touching the “subtotal” button again.
The total theoretical weight can be obtained, for example, by calculating the product of the theoretical weight and the quantity for each target product code and summing the products.

  Next, the calculation means 11 acquires the actual weight of the article accommodated in the after-sales basket 51 via the scale 50 (step S5). As described above, since all the products scanned in step S2 are accommodated in the after-sales basket 51, this actual weight is the actual weight of all the products to be sold.

Next, the calculation means 11 controls the touch panel 40 to display a predetermined screen (step S6). In this step S6, the touch panel 40 displays a screen for each product name.
FIG. 4 is an example of a screen for each product name. The screen for each product name displays the product name and the quantity (“number” in this example) for each product name in association with each target product code. This screen is close to the conventional visual confirmation. As shown in FIG. 4, the display of the target product code itself may be omitted, but this may be displayed.

  In the example of FIG. 4, it is assumed that the number of “black beers” should actually be five, but the salesperson accidentally sets the number to four. The screen for each product name displays the total theoretical weight (4600 g in this example) calculated in step S4 and the actual weight (5000 g in this example) acquired in step S5. Further, the difference between the total theoretical weight and the actual weight (400 g in this example) may be displayed.

  In addition, the screen for each product name shows the product name (“product” in this example), product name (“department” in this example), capacity, theoretical weight (in this example) for each target product code entered. "Weight") and quantity.

Next, the computing means 11 determines whether or not the total theoretical weight and the actual weight match (step S7). Here, the range of “match” may be appropriately determined by those skilled in the art. For example, it may be determined to match only when the numerical values are exactly the same, or may be determined to match when the difference or ratio falls within a predetermined range.
Actually, each product has a certain amount of weight error, so that the allowable range weight for each product or the total weight can be arbitrarily set. For example, when the tolerance is ± 20 g, when the theoretical weight is 1000 g, the actual weight is determined to be equal to the theoretical weight if the actual weight is 980 g or more and 1020 g or less. Moreover, since an error also occurs in the weight of the post-sales basket 51, the post-sales basket 51 may be given a width in advance.

If it is determined that they do not match, the touch panel 40 displays a warning (step S8). This determination is equivalent to the sales management system 100 determining that there is a possibility of sales omission. Specifically, the calculation means 11 controls the touch panel 40 to display a warning message 80. The warning message 80 may be displayed with a voice warning. The warning message 80 is a content that prompts the salesperson to collate the product scanned by the scanner 30 and the quantity thereof with the product and the quantity accommodated in the post-sales basket 51 and includes, for example, the word “weight”. Contains a string.
Further, the warning in step S8, the salesperson notices that the actual product and the scanned data are inconsistent, and determines that it should not proceed to the latter half of the settlement process. For such a case, as will be described later with respect to step S14 and the like, the first half of the process can be continued and an additional scan process can be performed.

  In step S7, when it is determined that the total theoretical weight and the actual weight match, or after step S8, the calculation means 11 receives a control operation by the salesperson (step S9). For example, the touch panel 40 functions as an operation input unit for a salesperson to input a control operation. The control operation includes a confirmation completion operation and a correction operation as progress control operations. The control operation includes a display control operation.

  The screen for each product name (FIG. 4, step S6) displays a confirmation completion button 71, a department name display button 72 (displayed as “by department”), and a department name capacity display button 73 (displayed as “by department capacity”). To do. Via these buttons, the salesperson can input a control operation to the computing means 11.

  The operation on the confirmation completion button 71 is a confirmation completion operation, and is an operation for instructing the salesperson to complete the confirmation work and complete the sales process. The calculation means 11 will perform a sales completion process, if the operation with respect to the confirmation completion button 71 is received (step S10). Step S10 is the latter half of the settlement process, which includes a process of receiving cash, making a credit settlement, and printing a receipt, for example.

  The operations on the department name display button 72 and the department name capacity display button 73 are display control operations for controlling the display content of the touch panel 40 itself. The calculating means 11 controls the touch panel 40 according to display control operation, and switches a display screen. Note that an operation on a product name display button 74 described later is also a display control operation, and the calculation unit 11 controls the touch panel 40 in response to this and switches the display screen.

When the department name display button 72 is operated in step S9, the computing means 11 controls the touch panel 40 to display a screen for each product department name (step S12).
FIG. 5 is an example of a screen for each product department name. The screen for each product department name associates the product department name (in this example, “department”) with the quantity for each product department name (in this example, “number”) for each product department name related to the target product code. To display. If the warning message 80 is displayed in step S8, the warning message 80 is displayed continuously (or anew). The product department name to be displayed on this screen can be acquired by searching the product master 20 based on the target product code, for example.
This screen is a screen that is aggregated by classification group such as departments when there are many types of similar products (that is, when there are many products belonging to the same product department).

Similar to the screen for each product name (FIG. 4), the screen for each product department name also displays the total theoretical weight and the actual weight. Further, the difference between the total theoretical weight and the actual weight may be displayed. In addition, for each of the product division names (in this example, “department”), the product division name and quantity are displayed. Further, a confirmation completion button 71, a product name display button 74 (display “by product”) and a department name capacity display button 73 (display “by department capacity”) are displayed. The operations on the product name display button 74 and the department name capacity display button 73 are display control operations for controlling the display content of the touch panel 40 itself. The calculating means 11 controls the touch panel 40 according to display control operation, and switches a display screen.
After step S12, the process returns to step S9, and the calculation means 11 accepts a control operation by the salesperson.

When the department name capacity display button 73 is operated in step S9, the calculation means 11 controls the touch panel 40 to display a screen for each product department name / capacity (step S13).
FIG. 6 is an example of a screen for each product department name / capacity. The screen for each product department name / capacity displays, for each combination of product department name and capacity related to the target product code, the quantity related to each combination in association with each other. If the warning message 80 is displayed in step S8, the warning message 80 is displayed continuously (or anew). Here, for different products, even if the product department name is the same, if the capacity is different, it belongs to a different combination, so the display for each combination of product department name and capacity is more than the display for each product name In other words, it can be said that the display is in units smaller than the display for each product department name. The combination of the product department name and the capacity to be displayed on this screen can be obtained by searching the product master 20 based on the target product code, for example. This screen is a screen that is aggregated by department capacity in the case of products that can be patterned to some extent, such as alcoholic beverages.

Similar to the screen for each product name (FIG. 4), the screen for each product department name / capacity also displays the total theoretical weight and the actual weight. Further, the difference between the total theoretical weight and the actual weight may be displayed. Further, for each combination of the product department name and the capacity, the product department name (in this example, “department”), the capacity, and the quantity are displayed. Further, a confirmation completion button 71, a product name display button 74, and a department name display button 72 are displayed. The operations on the product name display button 74 and the department name capacity display button 73 are display control operations for controlling the display content of the touch panel 40 itself. The calculating means 11 controls the touch panel 40 according to display control operation, and switches a display screen.
After step S13, the process returns to step S9, and the calculation means 11 accepts a control operation by the salesperson.

  When the product name display button 74 is operated in step S9, the computing unit 11 controls the touch panel 40 to display a screen for each product name (step S11). The screen displayed in step S11 is the same as that in step S6 described above, and is shown in FIG. If the warning message 80 is displayed in step S8, the warning message 80 is displayed continuously (or anew).

In step S9, when a correction operation (a salesperson notices a scan omission and additionally scans a product), the calculation means 11 responds accordingly by applying the target product code, the quantity related to the target product code, or both Is corrected (added) (step S14). Thereafter, the process returns to step S3, and the total theoretical weight is recalculated.
By displaying the scanned product list as shown in FIGS. 4 to 6, it is possible to prompt the salesperson to notice the product forgot to scan. In step S14, the scanned product data is updated by adding the data scanned by the salesperson to the already scanned product list.
Alternatively, instead of correcting, the processing may be returned to step S1 and all products may be scanned again.

As described above, in step S9, the touch panel 40 responds to the display control operation.
-Display the product name and quantity for each product name in association with each other,
-Display the product department name and the quantity for each product department in association with each other, or
It can be said that the combination of the product department name and capacity and the quantity for each combination are displayed in association with each other.

  For this reason, it is possible to display whether the quantity for each product name is displayed in detail or whether the quantity for each product department or the quantity for each capacity is roughly displayed. Can be specified.

For example, when various types of beer are mixed as in the example of FIG. 4, there are cases where it is easier to count the total number of beers than to count the number for each product name that distinguishes even beer varieties. Therefore, in such a case, the screen is first switched to the screen of FIG. 5 to specify that the sales omission is one of beer (or not beer), and then the screen of FIG. 4 is switched to only beer. It is possible to confirm the details by paying attention (or paying attention to only the department other than beer).
Furthermore, as shown in FIG. 6, by classifying and displaying beer by capacity, not by product type, one can see 633 ml of beer and six 350 ml of beer, so the salesperson cannot scan. It is easy to notice the product.
Although not shown in the figure, the total number of products scanned at present ("Registered Number 4" in FIG. 4, "Registered Number 9" in FIG. 5, "Registered Number 10" in FIG. 6) is calculated. Display, the salesperson can visually confirm the number of scanned products and the number of products in the basket 51 after sales, so it is easy to notice how many scans are missing.

In the first embodiment, the following modifications can be made.
The display control operation is not limited to the operation of the button displayed on the touch panel, and may be any operation as long as it is a known operation. For example, it may be an operation of pressing a predetermined key on the keyboard. In this case, different screens may be associated with different keys.

  The operation and operation of the sales management system 100 in steps S1 to S3 and S10 may be any operation as long as it is an operation using a known POS system.

  The product department name may be a classification that does not necessarily match the term “department”. For some group classification, the product group name representing each group can be used instead of the product department name.

The scanner 30 may be an optical scanner using visible light, infrared light, or the like, or may be an electromagnetic scanner using RFID technology. Further, the product code acquisition means is not limited to the scanner, and may be any device as long as it has a function of acquiring a product code. For example, a keyboard or a touch panel for inputting a product code may be used, and an image may be acquired by photographing the product, and the product code may be acquired by identifying the product by image processing.
In addition, depending on the store, there is not enough space around the POS system that performs sales processing, and there are cases where the two baskets of the pre-sales basket 60 and the post-sales basket 51 cannot be placed. In that case, products are put in one basket, the products are scanned one by one, and are stored in the same basket after scanning. That is, when one basket is used as the after-sales basket 51, the product before the scan and the product after the scan are mixed in the after-sales basket 51.
In such a case, scan omissions (registration omissions) are more likely to occur than when a product is moved using two baskets. However, according to the present embodiment, the salesperson is more easily aware.
When the sales process is performed only with the after-sales basket 51, the weight can be measured when the after-sales basket 51 is placed on the balance 50. Therefore, the process shown in step S5 in the flowchart shown in FIG. You may implement after. After the processing in steps S3 and S4, the “total weight of registered products” approaches “actual total weight” every time the products are scanned on the sales progress screen (FIGS. 4 to 6) displayed in step S6. The salesperson can easily notice the sales omission before touching the “subtotal” button.

Embodiment 2. FIG.
In the second embodiment, the scanned products are classified by paying attention to the characteristics of the products different from the first embodiment. Specifically, we focus on the manufacturer name and shape.
FIG. 7 is an example of the product master 21 used in the second embodiment. The product master 21 shown in FIG. 7 has items of manufacturer name and shape in addition to the product master 20 shown in FIG. The manufacturer name indicates the company that manufactured the product. The shape indicates the outer shape of the product, and examples thereof include bottles, cans, plastic bottles, bottles, boxing, and bagging. The “shape” may also be an item indicating the type of product container or the type of product packaging. In the case of a product that does not use a container or packaging, the outer shape of the product itself may be handled as a “shape”.
The flow of processing in the second embodiment will be described with reference to FIG. When the screen for each product name is displayed in step S6, the calculation means 11 displays the product name, department, manufacturer name, weight, and number as shown in FIG. 8 with reference to the product master 21 shown in FIG. To do. The capacity and shape may also be displayed.
When the manufacturer-specific display button 75 is operated, the calculation means 75 refers to the product master 21 and displays the scanned number for each manufacturer (FIG. 9). When the display button 76 by shape is operated, the calculation unit 75 refers to the product master 21 and displays the number of scanned items by product department and shape (FIG. 10).
In FIG. 9, not only the manufacturer name but also the department, capacity, and shape may be displayed in combination. In FIG. 10, the division may not be displayed and the shape may be classified only, or the capacity and the manufacturer name may be combined and displayed.
The process of shifting to another display screen by operating the display button on the display screens of FIGS. 8 to 10 is as described in the first embodiment.
As described above, in the second embodiment, the classification and display are described with attention paid to various features of the product. For example, in the case of a skilled salesperson at a liquor store, the manufacturer can grasp at a glance when scanning beer. For this reason, if the five main categories of the four major domestic manufacturers and other foreign manufacturers are displayed, it is easy to understand what the scan omission products are.
Also, a skilled salesperson at a food store can easily grasp the shape of a product when scanning. Therefore, if the scanned products for each shape are classified and displayed, it is easy to grasp what the scan omission products are.

  10 control devices (11 calculation means, 12 storage means), 20, 21 product master, 30 scanner (product code acquisition means), 40 touch panel (display means, operation input means), 50 scale (weight measurement means), 51 after sales Basket, 60 Pre-sales basket, 71 Confirmation completion button, 72 Department name display button, 73 Department name capacity display button, 74 Product name display button, 75 Manufacturer display button, 76 Shape display button, 80 Warning message (warning display) , 100 Sales management system.

Claims (4)

Storage means for storing a product master for associating a product group name, theoretical weight and capacity for each of a plurality of product codes;
Product code obtaining means for obtaining at least one product code as a target product code;
A calculation unit that obtains a quantity for each of the target product codes, and calculates a total theoretical weight based on the theoretical weight and the quantity related to each of the target product codes;
Display means for displaying the total theoretical weight and the actual weight;
Operation input means for receiving a display control operation for controlling the display means,
The display means is responsive to the display control operation,
-Display the product group name in association with the quantity for each product group name,
-A sales management system that determines whether a combination of product group name and capacity and the quantity for each combination are displayed in association with each other. The product master further associates a manufacturer name with each of the plurality of product codes,
The sales management system according to claim 1, wherein the display unit determines whether to display a manufacturer name and a quantity for each manufacturer name in association with each other according to the display control operation. The product master further associates a shape with each of the plurality of product codes,
The sales management system according to claim 1, wherein the display unit further determines whether to display a combination of a product group name and shape and a quantity for each combination in association with the display control operation. .   The sales management system according to any one of claims 1 to 3, wherein the display unit further displays a warning when the total of the theoretical weights and the actual weight obtained by measuring the weight of the object do not match.

Images