JP2000339544A - Commodity sales data processing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To quickly and accurately change the price of a sacrificial commodity to a new price by comparing the read number of daily sales points of the day with the number of sacrifice sales points, and at the time of judging that the number of daily sales points is less than the number of sacrifice sales points, forming a sacrifice change information so as to be outputted to a sacrifice work file. SOLUTION: The number Ni of daily sales points is acquired from a daily unit article sales file (ST32). At the time, a selling price Pi is also acquired from a unit commodity master file. Then a sacrifice change information file is retrieved to acquire the sacrifice change information satisfying the condition that sacrificial time Tm has elapsed and a sacrificial price Pm is less than a current selling price Pi (ST33). The read number Ni of daily sales points is compared with the number Nm of sacrifice sales points to judge whether the number Ni is less than the number Nm or not (ST34). At the time of judging that the number Ni is less than the number Nm (NO in the ST34), the sacrifice change information is outputted to the sacrifice work file (ST38).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a high-level device having a single item master file and a plurality of POS terminals capable of registering items by using single item master data stored in the single item master file via a network. The present invention relates to a merchandise sales data processing system which is communicably connected and which is configured to be capable of collectively managing the same-day single-item sales information including the same-day sales points obtained from each POS terminal by the host machine and storing the same in the single-item sales file on the same day. .

[0002]

2. Description of the Related Art In FIG. 12, a merchandise sales data processing system includes a store controller (upper machine) 30 having a single item master file 33M, and a single item master file 33.
A plurality of POS terminals (electronic cash registers) 10 capable of registering products using the single item master data stored in the M are connected so as to be able to perform data communication via the networks 1 and 2, and the host machine (30) The single-item sales information including the number of sales on the same day acquired from the POS terminal 10 is accumulated and stored in the single-item sales file 33TU on the same day, and can be managed collectively.

In the case of FIG. 12, each POS terminal 10 is connected to a store controller (upper device) 30 via each POS controller (upper device) 20. Therefore, the single item master data of the single item master file 33M is distributed to the single item file of each POS controller (upper device) 20, and each POS terminal 10 transmits the single item data stored in the single item file of the POS controller (upper device) 20. There is a case where the product is registered by using the URL, but the essence does not change.

The terminal 40 is a client machine (personal computer) having the store controller (upper machine) 30 as a server. A printer 21 is connected to the network 2.

[0005] The store controller 30 accumulates on-the-spot single-item sales information including the number of on-site sales points acquired (collected) from the respective POS controllers 20, that is, the respective POS terminals 10, and stores the same in the on-site single-item sales file 33TU. In addition, the sales points and the sales amount by time zone for each sales day are stored in the single item sales record file 33UJ.

[0006] Here, among the products to be sold, there are so-called close-off products which are sold by discounting the balance by comparing the remaining situation (the number of remaining products) with the business hours. However, the selling price of each product is not limited to the store
The single item master data (sale price) of the single item master file 33M in 0 must be changed using the terminal 40.

[0007] Specifically, the terminal 40 issues a selling price change command at the time of deciding to sell the general merchandise at a discount or at the time of deciding to sell off the sold-out merchandise, and then sends data [commodity (commodity code) and new selling price] (ST50 in FIG. 13)
Is YES), and the setting is stored (updated) in the selling price change file 33BH (ST51). Thereby, the selling price change process of changing the selling price of the single item master file 33M to the new selling price of the selling price change file 33BH is executed (ST5).
2).

[0008]

In the case of general merchandise, there is little problem from the viewpoint of customer service, and there is little problem even if a slight time lag occurs. Since products that must be disposed of are targeted, time delays and unnecessary reductions in new selling prices will result in operating losses. On the other hand, changing to a new unit price earlier often results in greater damage / loss than a delay.

[0009] Thus, in order to change a product sold out daily, that is, a close-out product to a new price, it is necessary to determine the timing and the amount of money for minimizing or eliminating the remaining number while securing operating profit. However, in reality, the sales person in charge looks around the product display shelves, decides the closing timing and the discounted selling price from the remaining status of the product and the remaining business hours until the store closes, and also determines the product code, product name and current A terminal 4 in the office that notes the selling price and is away from the sales floor
You have to go to 0 and enter.

[0010] In addition, since the same work must be repeated every day, it is a very inefficient and difficult work in the sales business. Furthermore, it is difficult to secure replacement personnel because the work is of a nature that can only be performed by the sales floor manager class.

[0011] In this regard, a system for automatically grasping the number of stocks on the merchandise display shelves and making a recommendation for a change in the selling price has been tried. Has to be entered by the user, which is rather complicated and ineffective, so that the spread is stagnant.

[0012] Therefore, with the current reality of increasingly intense competition, there is a strong demand for easier and more reliable operations.

An object of the present invention is to provide an easy-to-handle product sales data processing system capable of changing the new selling price of a close-out product quickly and accurately.

[0014]

According to a first aspect of the present invention, there is provided an upper-level device having a single-item master file and a plurality of POS terminals capable of registering products using single-item master data stored in the single-item master file. Products that are connected so that data communication is possible via the network, and are configured so that they can be collectively managed while accumulating single-item sales information on the same day, including the current-day sales points, etc. acquired by the host machine from each POS terminal and storing them in the single-item sales file on the same day. In the sales data processing system, a close-out product identification flag is formed so as to be storable for each product stored in the single item master file, and close-off sale change information including a close-off selling price, a close-off time, and a close-off sales number for each close-off target product. A change-of-sale information file capable of setting and storing the information is provided. The closing target product is extracted by referring to the closing target product discriminating flag, and the number of sales on the day of the extracted product can be read from the single item sales file on the same day, and the closing sales for the relevant product can be read from the closing sales change information file. The points are formed so that they can be read, and if the day's sales points that are read are compared to the closing sales points and the day's sales points are determined to be less than the closing sales points, the closing sales change information can be output to the closing work file. It is a formed product sales data processing system.

In this invention, the single item master file contains
For each product, a close-out target product determination flag for determining that each product is a close-out target product is set and stored. In addition, the closing sale information including the closing selling price, the closing time, and the closing sale points for each of the closing-off target products is set and stored in the closing selling change information file.

For example, the host machine refers to the target product discrimination flag stored in the single item master file at regular intervals within a time zone close to the parting time set and stored in the closing sale information file. Extract products. This is in order to exclude the other commodities in which the commodities which are not the commodities to be discontinued are set incorrectly in the modification price information file.

On the same day, the sales points of the extracted products are read from the single-item sales file on the day, the closing sales points of the corresponding products are read from the closing sales change information file, and the read sales points on the day and the closing sales points are compared. It is determined whether or not the number of sales on the day is equal to or less than the number of sales closed.

If it is determined that the sales points on the day are equal to or less than the closing sales points, the closing sales change information is output to the closing work file. In other words, if the sales points up to that time on the day are less than the closing sales points set and stored by estimating that if this point remains, unsold will occur, that is, the sales on the day are less than expected In this case, the closing sale change information (closed selling price) is output to the closing work file, and a preparation is made so that the current selling price of the single item master file can be changed to the closing selling price manually or automatically after confirmation. At the time of switching to the change of the selling price to the closing selling price, only the execution request is required.

Therefore, the sales person in charge looks around the product display shelves, determines the closing time and selling price based on the remaining status of the product and the remaining business hours until closing, and notes the product code, the product name, and the current selling price. In addition, it is possible to eliminate the complicated and rapid conventional work that requires the user to go to the terminal of the office distant from the sales floor and input. That is, the change of the new selling price of the closing product can be performed quickly and accurately, and the handling is very easy.

Further, according to the invention of claim 2, the high-order machine comprises:
If it is determined that the current day sales points exceed the closing sales points by comparing the read day sales points and the closing sales points, a plurality of time zone sales points in the same time zone as the relevant time zone are read from the single item sales result file. A sales data processing system formed so that even if the average sales points are calculated and the sales points on the day are determined to be equal to or less than the calculated average sales points, the closing sales change information can be output to the closing work file. .

In this invention, the higher-ranking device compares the read sales amount on the day with the closed sales amount and determines that the sales amount on the day exceeds the closed sales amount. A plurality of time zone sales points in the time zone are read and their average sales points are calculated, and it is determined whether or not the day's sales points are less than or equal to the calculated average sales points. Then, even when it is determined that the sales points on the day are equal to or less than the calculated average sales points, the closing sales change information is output to the closing work file.

In other words, if the sales amount on the day exceeds the closing sales amount, it means that more sales are sold than expected. Therefore, in principle, there is no need to sell out at the closing time set and stored in the closing sales change information file. Good. However, the sale was not guaranteed. In view of the sales record history of the time period, even when the sales points on the day are equal to or less than the calculated average sales points, the closing sales change information (closing sales price) is output to the closing work file to enable closing sales. . This is because there is a risk that unsold may be left.

If the sales points on the day exceed the calculated average sales points, there is a chance to improve the profit, so that the closing sales change information (closing sales price) is not output to the closing work file.

[0024] Therefore, in addition to providing the same operation and effect as the case of the first aspect of the present invention, the probability of being sold out can be further improved, so that the profit can be expanded or the unsold can be greatly reduced.

The invention according to claim 3 is characterized in that when the close-out sale change information set and stored in the close-out sale change information file is output to the close-out work file and automatic execution is already selected, This is a product sales data processing system formed so that the selling price of the product stored in the master file can be automatically changed to the closing price stored in the closing work file.

In this invention, when the close-out sale change information set and stored in the close-out sale change information file is output to the close-out work file and automatic execution has been selected, the host machine stores the close-out sale change information in the single item master file. Is automatically changed to the closing price stored in the closing work file.

In other words, if automatic execution is selected, the selling price of the product stored in the single item master file is automatically changed to the closing selling price of the work file at or after the closing time in the closing sale change information. Close-out sales are performed automatically.

Therefore, in addition to providing the same operation and effect as in each of the first and second aspects of the present invention, the work load on the person in charge can be greatly reduced, and the timing of close-out sales can be overlooked. Absent.

The invention according to claim 4 is characterized in that the operator recognizes the prompt for changing the selling price of the commodity when the closing selling change information stored in the closing selling information file is output to the closing work file. This is a merchandise sales data processing system formed so as to be able to output.

According to this invention, when outputting the closing sale change information set and stored in the closing sale change information file to the closing work file, the host machine can recognize the selling price change prompt for the product by the operator. Output (for example, display output, audio output, print output). That is,
It warns that closing products should be changed to closing selling prices from the sales on the day.

Therefore, in addition to providing the same operation and effect as in each of the first to third aspects of the present invention, it is possible to give the person in charge a chance to make a decision on close-out sales. A cautious decision can be made while finally confirming the actual state of the customer at the counter at the same day and at that time.

Further, the invention of claim 5 is capable of displaying and outputting the unconfirmed closing sale change information that is stored in the closing work file and for which the confirmed flag is not set, and in which a confirmed input is performed. Is a product sales data processing system formed so that a confirmed flag can be set in the closing sale change information on the product.

In this invention, the host machine displays and outputs the unsettled closing sale change information stored in the closing work file. The person in charge who sees this confirms the situation of closing out and then inputs that confirmation has been made. Then, an unconfirmed flag is set in the closing sale change information. In other words, it is possible to confirm the situation in which the company is going to the latest closeout sale.

Therefore, in addition to providing the same operation and effect as in each of the first to fourth aspects of the present invention, since there is no duplicate display in the subsequent steps, it is possible to avoid misunderstanding and to handle. It becomes even easier.

Further, according to the invention of claim 6, the execution selection can be input while referring to the displayed and sold out change information, and when the execution selection is input, the execution selection stored in the single item master file is stored. A commodity sales data processing system formed so as to be able to change a commodity selling price to the closing selling price stored in the closing work file.

In this invention, the person in charge can input the execution selection while referring to the displayed and sold out change information. When the execution selection input is performed, the host machine changes the selling price of the product stored in the single item master file to the closing price stored in the closing work file. That is, after reconfirmation on the display, close-out sales can be executed.

Therefore, in addition to providing the same operation and effect as in each of the fourth and fifth aspects of the present invention, the final decision can reflect the decision made by the person in charge, so that more careful operation can be performed. .

Further, in the invention according to claim 7, when the selling price of the goods stored in the single item master file is changed to the closing price stored in the closing work file, the display selling price of the electronic shelf label is changed. This is a merchandise sales data processing system formed so as to be automatically changeable to a close-out selling price.

In this invention, when the host machine changes the selling price of the product stored in the single item master file to the same selling price as the closing price stored in the closing work file, it is displayed on the electronic shelf label. The selling price is automatically changed to the selling price. In other words, the price of the close-out product displayed on the product display shelf can be switched to the new selling price at the same time as the closing sale is started.

Therefore, in addition to providing the same operation and effect as in each of the inventions according to claims 3 to 6, it is possible to establish a close-out sales system as a whole including the sales floor, and to sell the goods based on the close-up selling price. Customer service related to early provision and avoidance of misrecognition of prices can be further improved.

Further, according to the invention of claim 8, when the selling price of goods stored in the single item master file is changed to the closing selling price stored in the closing work file, the selling price is stored in the closing work file. This is a merchandise sales data processing system formed so as to be able to delete such closing sale change information.

In this invention, when the host machine changes the selling price stored in the single item master file to the closing price stored in the work file,
The closing sale change information stored in the closing work file is deleted.

Therefore, in addition to providing the same operation and effect as in each of the third to seventh aspects of the present invention, it is possible to avoid an overlapping change of the same close-up product to the same close-up selling price, and to close off. Work files can be reduced in size.

[0044]

Embodiments of the present invention will be described below with reference to the drawings. This product sales data processing system (10, 20, 30) has the same basic configuration and functions as those of the conventional example (FIGS. 12 and 13), but furthermore, as shown in FIGS. The higher-ranking machine (30) refers to the parting target product determination flag stored in the single part master file 33M and determines the day's sales points Ni of the product determined to be the parting target product on the same day as the single item sales file 3 for the day.
Close-out sale change information file 3 which is readable from 3TU and stores the close-out sale change information (including the close-out selling price, close-out time, and close-out sales points) for each of the close-out target products.
The closing sales number Nm of the product is formed so as to be readable from the 3MK, and the closing sales change information is formed so as to be output to the closing work file 33MW when it is determined that the sales number Ni on the day is equal to or smaller than the closing sales number Nm. I have.

Parts common to those in the conventional example (FIG. 12) are denoted by the same reference numerals, and description thereof will be simplified or omitted.

In FIG. 1, a store controller (host device) 30 composed of a computer includes a control unit (CPU, R
OM, RAM, etc.) and a memory unit (HDD, etc.), and collectively manages the entire store. The terminal 40 is formed of a personal computer having a control unit, a memory unit, and input / output devices (a keyboard, a display, and the like), and forms a client machine when the lower controller 20 is a server.
Is provided on a product display shelf and has a single item master file 33M.
Is displayed (ST15 in FIG. 8).

As shown in FIG. 1, a single item master file 33 is stored in the memory of the store controller (upper device) 30.
M, on the day single item sales file 33TU, single item sales result file 33UJ and selling price change file 33BH,
A closing sale information file 33MK and an automatic closing work file 33MW are provided.

As shown in FIG. 2, the single item master file 33M is formed so as to be capable of setting and storing a product flag (PLU code), a category, a product name and a selling price, as well as a product flag for parting off. Product registration at each POS terminal 10 is executed based on the selling price set and stored in the single item master file 33M.

FIG. 3 shows the single-item sales file 33TU on the day.
As shown in the figure, the product code (PLU code) and each POS
Sales number N of the day acquired from terminal 10 (20)
i and the sales amount are stored.

As shown in FIG. 4, the sale price change file 33BH stores a product code (PLU code) and a new sale price. The new selling price is input to the terminal 40 by data input (FIG. 8).
(YES in ST10) to update (ST1)
3) is done. Then, when a selling price change request is made as necessary, a selling price change process (ST14) for rewriting the selling price of the single item master file 33M to a new selling price is executed.

In this embodiment, the single item master file 3
Selling price change processing (ST1) that rewrites 3M selling price to new selling price
When step 4) is executed, the display selling price of the electronic shelf label 50 can be switched to the new selling price (ST15). The consistency between the data and the sales floor can be taken instantaneously.

FIG. 5 shows a single item sales record file 33UJ.
As shown in the table, sales date, sales time zone, product code (P
LU code), sales points, and sales amount.
For example, the sales performance by time zone for each product within one week is stored.

Here, the closing sale change information file 33MK
As shown in FIG. 6, the closing sale information, that is, the closing selling price Pm, the closing time Tm, and the closing sales number Nm for each closing target product (PLU code) can be set and stored, and is updated using the terminal 40 (FIG. 6). YES at ST10 of 8,
YES in ST11, ST12).

That is, the closing selling price P determined from the viewpoint that no unsold will occur based on the rule of thumb.
m, a closing time Tm, and a closing sales number Nm.

As shown in FIG. 7, the automatic closing work file 33MW contains closing selling change information, that is, a product code (PL).
Um) and the closing price Pm. In the present embodiment, the product code (PLU code) and the closing price Pm are shown as the closing sale change information, but the closing time Tm may be added.

That is, the closing sale change information file 33M
The automatic closing work file 33 for executing the closing sale according to the closing sale change information stored in K is
Must be set to the MW. In addition, a confirmation flag (0: unconfirmed, 1: confirmed) is set (set).
can do.

Here, the host machine (30) is, for example, a certain time (for example, 10 minutes or 5 minutes) in a time zone close to the closing time Tm set and stored in the closing selling change information file 33MK.
For each minute), the parting target product is extracted with reference to the parting target product determination flag stored in the single item master file 33M of FIG. 2 (ST30 of FIG. 10). When a product that is not a close-out target product is mistakenly set in the close-up price change information file 33MK, the other product can be excluded.

Subsequently, the closing sale change information file 33 on the day
It is determined whether or not there is data (close-out sale change information) on the product extracted by searching for the MK (ST31).

If the closing sale change information for the product is set and stored (YES in ST31), the current day sales point Ni is acquired from the single-day sales file 33TU in FIG. 3 (ST32). At this time, the selling price Pi is also obtained from the single item master file 33M in FIG. Further, the current time Ti is acquired.

Thereafter, the closing sale change information file 33M
K is searched to obtain closing sale change information (PLU code, closing selling price Pm, closing selling point Nm) satisfying the condition that the closing time Tm has passed and the closing selling price Pm is equal to or less than the current selling price Pi (ST33).

Then, by comparing the read day sales points Ni and the closing sales points Nm, it is determined whether or not the day sales points Ni is equal to or less than the closing sales points Nm (ST34).
When it is determined that the sales number Ni on the day is less than or equal to the sales number Nm (S34: NO), the closing change information is output to the closing work file 33MW in FIG.
T38).

In ST38, the sold-out sale change information to be output is described as "sale price Pm etc."
Including code. In FIG. 7, the PLU code and the closing price Pm are used. However, when priority is given to execution by automatic selection, it is preferable that the closing time Tm is also output.

That is, the sales points N up to that time on the day
If i is less than Nm, which is the closing sales number Nm that has been set and stored by estimating that unsold will occur when the store is closed when this score Ni remains, that is, the sales number Ni of the day is smaller than expected. In this case, the closing sale information (closed selling price Pm) is output to the closing work file 33MK, and preparation for changing the selling price Pi to the closing selling price Pm manually or automatically after confirmation is made. Close-up selling price Pm
When the change to the selling price change is made, only the execution request is required.

If it is determined that the sales number Ni on the day exceeds the closing sales number Nm (YES in ST34),
A plurality of time zone sales points Nt over each day in the same time zone as the time zone (for example, 19:00 to 19:59) are obtained (read) from the single item sales record file 33UJ in FIG.
Then, the average sales points Nh are calculated (ST36).

Then, it is determined whether or not the current day sales point Ni is equal to or less than the calculated average sales point Nh (ST37).
However, even when it is determined that the sales number Ni on the day is equal to or smaller than the calculated average sales number Nh (YES in ST37), the closing sales change information is output to the closing work file 33MW (S37).
T38).

That is, when the sales number Ni on the day exceeds the closing sales number Nm (YES in ST34), it means that more sales have been sold than expected, and in principle, the closing sales set and stored in the closing sales information file 33MK. It is not necessary to sell out at time Tm. However, the sale was not guaranteed. In view of the sales record history of the time period, even when the sales number Ni on the day is equal to or less than the calculated average sales number Nh, it is possible to output the close-out sales change information (close-out sales price) to the close-up work file 33MW and perform the close-out sales. I do.

Therefore, also at this stage, the salesperson looks at the product display shelf, determines the selling price Pm of the closing sale from the remaining status of the product and the remaining business hours until closing, and finds out the product code, the product name and the current selling price. It is possible to eliminate the complicated and rapid conventional business of having to write down Pi and go to the terminal 40 in the office distant from the sales floor and input it. That is, the change of the new selling price of the closing product can be performed quickly and accurately, and the handling is very easy. Further, the probability of being sold out can be improved, so that profits can be expanded or unsold can be greatly reduced.

When the sales points NI on the day exceed the calculated average sales points Nh (NO in ST37), there is a chance to improve profits, so that the closing sales change information (closing sales price) is not output to the closing work file 33MW.

Further, in this embodiment, for practical use and handling convenience, the host machine (30) sends the closing sale change information set and stored in the closing sale change information file 33MK to the closing work file 33MW. When outputting,
The sales price change prompt for the product is output so that the operator can recognize it. In this embodiment, the display is output to the display of the terminal 40 (ST39). Note that audio output or print output may be used.

That is, a warning is issued to the effect that the closing product should be changed to the closing selling price Pm from the sales on the day. Therefore, the person in charge can be given a chance to make a decision on close-out sales, so that the person in charge can make a prudent decision while finally confirming the actual state of the customer at the counter at the time of the day.

On the other hand, if automatic execution has been selected (YES in ST40 of FIG. 11), the single item master file 33
The product selling price Pi stored in M is automatically changed to the closing selling price Pm stored in the closing work file 33MW. Specifically, the closing sales information (close selling price Pm) stored in the closing work file 33MW is rewritten as the new selling price (Pm) of the selling price change file 33BH in FIG. 4 (ST42). Thus, the selling price change process of rewriting the selling price Pi stored in the single item master file 33M as the new selling price (Pm) of the selling price change file 33BH is executed (ST43).

That is, if automatic execution is selected in advance,
When the closing time Tm in the closing sale change information (or after the closing time Tm has elapsed), the single item master file 33M
Can be automatically executed to automatically change the product selling price Pi to the closing selling price Pm, so that the work load on the person in charge can be greatly reduced and the timing of the closing selling is not missed.

As described above, when the commodity selling price Pi stored in the single item master file 33M is changed to the closing selling price Pm, the closing selling change information stored in the closing work file 33MW is deleted (ST44). . Therefore, it is possible to avoid an overlap change to the same close-up selling price for the same close-up product, and to close the close-up work file 33.
The capacity of the MW can be reduced.

Further, if a display request is issued to the host machine (30) at the terminal 40 (FIG. 9), the closing work file 33MW
Closing sale change information (data) that is stored and unconfirmed in
Is displayed on the display of the terminal 40 at any time (ST in FIG. 9).
20, ST21 YES, ST22). Messages and alarms can also be selectively performed (ST2
2).

The person in charge who sees this confirms the situation in which he decides to sell out, and after confirming the input (Y in ST23).
ES), the confirmed flag ("1") is set (set) in the closing sale change information on the product (ST2).
4). In other words, it is possible to confirm the situation of the latest closing sale, and since there is no overlapping display, it is possible to avoid mistakes in viewing and further facilitate handling.

At this point, the person in charge can input an execution selection at the terminal 40 (YES in ST25) while referring to the sale change information displayed on the display. Host machine (3
In the case of 0), when the execution selection input is made, the product selling price Pi stored in the single item master file 33M is automatically changed to the closing selling price Pm stored in the work file 33MW.

For details, see the close-out work file 33MW.
Closing sale change information (closed selling price Pm) stored in
Is the new selling price (Pm) of the selling price change file 33BH in FIG.
(ST27). Thus, the selling price change process of rewriting the selling price Pi stored in the single item master file 33M as the new selling price (Pm) of the selling price change file 33BH is executed (ST28).

That is, after reconfirmation on the display, it is possible to manually switch over to close-out sales and execute it. Therefore, the decision made by the person in charge can be reflected in the final decision, so that more careful operation can be performed.

In this case as well, as in the case of ST44 in FIG. 11, since the commodity selling price Pi stored in the single item master file 33M has been changed to the closing selling price Pm, it is stored in the closing work file 33MW. The closing sale change information is deleted (ST29). Therefore, it is possible to avoid an overlapping change of the same closing product to the same closing selling price, and to reduce the capacity of the closing work file 33MW.

Further, the selling price Pi stored in the single item master file 33M is cut off and the work file 33M is closed.
In the case of changing to the closing price PM stored in W (ST43 in FIG. 11, ST28 in FIG. 9), ST1 in FIG.
As in the case of No. 5, the selling price displayed on the electronic shelf label 50 is automatically changed to the same selling price as the closing selling price Pm (FIG. 1).
ST41 of FIG. 1 and ST26 of FIG. 9).

That is, when the selling price of the close-out product displayed on the product display shelf is decided to be closed and sold, the new selling price can be simultaneously switched. Therefore, it is possible to establish a close-out sales system including the sales floor, and to further improve customer services such as early provision of a product based on the close-out selling price Pm and avoidance of false recognition of the price.

[0082]

According to the first aspect of the present invention, there is provided a close-out sale change information file capable of setting and storing close-out sale change information including a close-off sale price, a close-out time, and a close-off sales point for each of the close-off target products. Compare the current day's sales points of the target product extracted with reference to the discrimination flag with the closing sales points, and if the day's sales points are determined to be less than or equal to the closing sales points, the closing sales change information to the closing work file Since it is a product sales data processing system formed so that it can be output, the sales person in charge looks around the product display shelf and determines the selling price of close-out sales from the remaining status of the product and the remaining business hours until closing, and the product code and It is possible to eliminate the complicated and rapid conventional work that requires the user to write down the product name and the current selling price and go to the terminal in the office distant from the sales floor and input it. That is, the change of the new selling price of the closing product can be performed quickly and accurately, and the handling is very easy.

According to the second aspect of the present invention, when it is determined that the sales points on the day exceed the closing sales points, a plurality of time zone sales points in the same time zone as the relevant time zone are read from the single item sales record file. The system according to claim 1, wherein even if the average sales points are calculated and the day's sales points are determined to be less than or equal to the calculated average sales points, the closing sales change information is output to the closing work file. In addition to the same effect as in the case, the probability of being sold out can be further improved, so that the profit can be increased or the unsold can be greatly reduced.

Further, according to the third aspect of the present invention, when the close-out sale change information set and stored in the close-out sale change information file is output to the close-out work file and automatic execution has been selected, the single item master file is used. Is formed so as to be automatically changeable to the closing selling price of the work file, so that the same effect as in each of the inventions of claims 1 and 2 can be obtained, and further, the work load of the person in charge Can be greatly reduced, and the timing of close-out sales will not be overlooked.

Further, according to the fourth aspect of the present invention, when the closing sale change information of the closing sale change information file is output to the closing work file, it is possible to output so that the operator can recognize the prompt for changing the selling price of the product. Since it is formed, in addition to being able to provide the same effects as in each of the inventions of claims 1 to 3, it is possible to give the person in charge a chance to make a decision on close-out sales. A cautious decision can be made while finally confirming the actual state of the customer at the counter at the same day and at that time.

According to the fifth aspect of the present invention, unchecked closing sale change information for which the confirmed flag of the closing work file is not set can be displayed and output, and when the confirmed input is input, the closing sale change information is displayed. Is set to be able to set a confirmed flag, so that the same effect as in each of the inventions of claims 1 to 4 can be obtained, and furthermore, there is no overlapping display. Mistakes can be avoided and handling is easier.

Further, according to the invention of claim 6, it is possible to input the execution selection while referring to the displayed sales change information, and when the execution selection is input, the sales price of the corresponding item in the single item master file is determined. Since it is formed so as to be changeable to the closing price of the file, it is possible to obtain the same effect as in each of the inventions of claims 4 and 5, and to further reflect the decision made by the person in charge in the final decision. Therefore, more careful operation can be performed.

Further, according to the seventh aspect of the invention, when the selling price of the single item master file is changed to the closing selling price of the work file, the display selling price of the electronic shelf label is automatically changed to the closing selling price. Therefore, in addition to achieving the same effects as in each of the inventions of claims 3 to 6, it is possible to establish an entire close-out sales system including a sales floor, and to promptly provide products at a close-up selling price. And customer service for avoiding misunderstanding of prices can be further improved.

Further, according to the invention of claim 8, when the selling price of the single item master file is changed to the closing selling price of the work file, the closing sale change information stored in the closing work file can be deleted. Since it is formed, the same effect as in each of the inventions according to claims 3 to 7 can be obtained, and furthermore, it is possible to avoid an overlapping change of the same close-up product to the same close-up selling price and to close off Work files can be reduced in size.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention.

FIG. 2 is a diagram for explaining a single item master file.

FIG. 3 is a diagram for explaining a single item sales file on the same day.

FIG. 4 is a diagram for explaining a selling price change file.

FIG. 5 is also a diagram for explaining a sales price sales record file.

FIG. 6 is also a diagram for explaining a closing sale change information file.

FIG. 7 is a view for explaining an automatic parting work file.

FIG. 8 is a flowchart for explaining a manual selling price change processing operation.

FIG. 9 is a flowchart for explaining a selling price change processing operation based on an execution selection after confirmation.

FIG. 10 is also a flowchart (1) for explaining a selling price change prompting output operation and a selling price change processing operation by automatic execution selection.

FIG. 11 is a flowchart (2) for explaining a selling price change prompting output operation and a selling price change processing operation by automatic execution selection.

FIG. 12 is a block diagram for explaining a conventional example.

FIG. 13 is a flowchart for explaining a selling price changing operation according to a conventional example.

[Explanation of symbols]

 1, 2 Network 10 POS terminal 20 POS controller (upper machine) 30 Store controller (upper machine) 33M Single item master file 33TU Single item sales file 33BH Selling price change file 33UJ Selling actual sales file 33MK Close-out sales change information file 33MW Automatic closing work file 40 Terminal 50 Electronic shelf label

Claims (8)

[Claims] A host machine having a single item master file;
A plurality of POS terminals capable of registering products using the single item master data stored in the single item master file are connected via a network so as to be able to perform data communication. In a product sales data processing system that is formed so as to be able to be managed collectively while accumulating single-item sales information on the same day and storing the same in a single-item sales file on the day, it is possible to store a product discrimination flag for parting-off for each product stored in the single product master file And a closing sale change information file capable of setting and storing closing sale price information including a closing sale price, a closing time, and a closing sale point for each of the closing target products, wherein the higher-level device is stored in a single item master file. A product to be extracted and referred to by referring to the product identification flag On the same day, the sales points on the day can be read from the single-item sales file on the day, and the closing sales points for the product can be read from the closing sales information file, and the read sales points on the day and the closing sales points are compared. A product sales data processing system which is configured to output the closing sales change information to a closing work file when it is determined that the sales points on the day are not more than the closing sales points. 2. If the higher-level device determines that the current day's sales points exceed the close-off sales points by comparing the read today's sales points with the close-off sales points, the same time as the time zone from the single item sales record file is used. Reads the sales points of a plurality of time zones of the band, calculates the average sales points, and outputs the close-out sales change information to the work file even if it is determined that the sales points on the day are less than the calculated average sales points. The merchandise sales data processing system according to claim 1, wherein the merchandise sales data processing system is formed as possible. 3. When the closeout sale change information set and stored in the closeout sale change information file is output to the closeout work file and automatic execution has been selected,
3. The product sales data processing system according to claim 1, wherein the selling price of the product stored in the single item master file is automatically changeable to the closing price stored in the closing work file. . 4. When outputting the close-out sale change information set and stored in the close-out change information file to the close-out work file, output is performed so that an operator can recognize a prompt for changing the selling price of the product. The product sales data processing system according to any one of claims 1 to 3, wherein: 5. An unconfirmed closing sale change information stored in the closing work file and having no confirmed flag set, can be displayed and output, and when a confirmed input is performed, a closing sale change relating to the product is performed. The merchandise sales data processing system according to any one of claims 1 to 4, wherein a confirmed flag is set in the information. 6. The close-up work file can be input with execution selection while referring to the displayed and output close-out change information, and when the execution selection input is performed, the product sale price stored in the single item master file is used as the close-up work file. 5. The system is formed so as to be changeable to the close-out selling price stored in the storage unit.
Or the goods sales data processing system according to claim 5. 7. When the selling price stored in the single item master file is changed to the closing price stored in the closing work file, the display selling price of the electronic shelf label can be automatically changed to the closing selling price. The merchandise sales data processing system according to any one of claims 3 to 6, which is formed. 8. When the selling price stored in the single item master file is changed to the closing price stored in the closing work file, the closing change information stored in the closing work file is deleted. The merchandise sales data processing system according to claim 3, wherein the merchandise sales data processing system is configured to be capable of being formed.