JP2018190471A - Sales data processing device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate point management operations even when a point planning is diversified.SOLUTION: A sales data processing device in an embodiment comprises: shop information reading means; point reading means; and point output means. The shop information reading means is configured to read shop identification on an own shop from shop information storage means storing shop identification information for identifying shops, and the point reading means is configured to read a point giving rate with respect to the shop identification information read by the shop identification information reading means from the point storage means storing, for each point planning, the shop identification information on a shop applying the point planning, and a point giving rate to be applied for the point planning. The point output means is configured to calculate points on the basis of the point giving rate read by the point reading means; and output the calculated points.SELECTED DRAWING: Figure 5

Description

  Embodiments described herein relate generally to a sales data processing apparatus and a program.

  In chain stores in the retail, restaurant, and service industries, a point system that gives customers points that can be shared by affiliated stores is widely used. As a conventional technology of the point system, there is a point management system that can set a high point grant rate (return rate) during the campaign period to improve the customer collection rate. Also known is a technology for improving the willingness to purchase by setting a high point return rate for recommended products and product categories.

  In the conventional point system, the headquarter server that supervises chain stores often manages the point grant rate of all affiliated stores. For example, the headquarters server distributes a point master in which a point grant rate is set for each point plan to each affiliated store. A point-of-sale (POS) terminal of a store can calculate points using a point master at the time of product registration, and can give points common to all stores according to the plan to customers.

  By the way, in a chain store, there is a case where it is desired to carry out point planning limited to a specific store or a specific store belonging to a specific area. In such a case, conventionally, it has been necessary to prepare different point masters for stores that carry out point planning and stores that do not. Therefore, when a large number of point plans are to be held, the point master management work has become complicated. Therefore, conventionally, there has been a demand for the development of a point management system that can cope with the diversification of point planning.

  The problem to be solved by the present invention is to provide a sales data processing apparatus and program that can easily perform point management work even if point planning is diversified.

  The sales data processing device of the embodiment includes store information reading means, point reading means, and point output means. The store information reading means reads the store identification information of the own store from the store information storage means storing the store identification information for identifying the store. For each point plan, the point reading means reads the store information reading means from the point storage means that stores the store identification information of the store to which the point plan is applied and the point grant rate to be applied in the point plan. The point grant rate for the store identification information is read. The point output means calculates points based on the point grant rate read by the point reading means, and outputs the calculated points.

FIG. 1 is a schematic configuration diagram of a store system according to the present embodiment. FIG. 2 is a block diagram illustrating a hardware configuration of the headquarter server. FIG. 3 is an explanatory diagram showing a setting example of the point master. FIG. 4 is a block diagram illustrating a hardware configuration of the store server. FIG. 5 is a block diagram showing a functional configuration of the POS terminal. FIG. 6 is a flowchart showing the procedure of the point giving process executed by the POS terminal.

  FIG. 1 is a schematic configuration diagram of a store system 100 according to the present embodiment. Each of the stores a to c includes at least one POS terminal 1. The POS terminal 1 is a sales data processing device that performs sales registration processing for merchandise. Although FIG. 1 shows an example in which a plurality of POS terminals 1 are connected to the store server 4 and used, the number of POS terminals 1 used in the store is not particularly limited.

  The store server 4 is a server device that performs overall management of data received from the POS terminal 1 and other data, and performs store sales management, inventory management, expense management, and the like. The store server 4 and the POS terminal 1 are connected by a connection line 3 such as a LAN (Local Area Network) provided in the store. The store server 4 is connected to the head office server 6 by a dedicated line 8. The headquarter server 6 is a server that performs sales management, inventory management, and the like at a plurality of stores.

  Next, the functional configuration of each device will be described. First, the headquarter server 6 will be described. FIG. 2 is a block diagram showing a hardware configuration of the headquarter server 6. The headquarter server 6 includes a control unit 61 having a computer configuration including a CPU, a ROM, a RAM, and the like. In addition, a keyboard 65, a display 66, a printer 67, and an HDD (Hard Disk Drive) 68 are connected to the controller 61 via a bus 62 and an I / O device controller 64. The control unit 61 performs data communication with the store server 4 via a communication I / F (Interface) 63 and a dedicated line 8.

  The HDD 68 stores a product master 681, a point master 682, and a member master 683, in addition to various programs that operate the CPU of the control unit 61.

  The product master 681 is a master file that manages product information such as product codes, product names, and prices.

  The point master 682 is a master file for setting a point plan application target, a point grant rate, and the like. A more detailed functional configuration and setting example of the point master 682 will be described later with reference to FIG.

  The member master 683 is a master file for managing the member number, member information such as a member name and contact information, and the number of points.

  The headquarter server 6 updates and manages the product master 681 and the point master 682, and distributes the updated data to the store server 4 of the affiliated store. The store server 4 updates its own product master 481 and point master 482 (both see FIG. 4) based on the distributed data. The POS terminal 1 in the store inquires of the product master 481 and the point master 482 of the store server 4 about the latest data when receiving a predetermined timing or data update instruction. Then, the POS terminal 1 copies the latest data of the store server 4 and updates the product master 201 and the point master 202 (both see FIG. 5).

  Next, a data configuration example of the point master 682 will be described. FIG. 3 is an explanatory diagram showing a setting example of the point master 682. The point master 682 of the headquarter server 6, the point master 482 of the store server 4, and the point master 202 of the POS terminal 1 are synchronized as described above. Therefore, the setting example described here is also applied to the point masters 482 and 202.

  The point master 682 sets, for each point plan, information indicating a store to be applied (applied store) and information indicating a product to be applied to the point plan (applied product).

-Setting example of application store The point master 682 is set so that each point plan is a plan that applies to all stores or a plan that targets a specific store. The distinction between all store targets and specific store targets can be made by other methods such as flag setting, but here, a setting example using store codes will be described.

  That is, as shown in FIG. 3, the store code of the store to which the point plan is applied is set in the point master 682 for each point plan. For example, if a plurality of stores belonging to a specific area are to be applied, store codes of the plurality of stores are respectively set (cases 3 to 6). Further, if not limited to a specific store but all stores in the group are to be applied to the plan, a store code (for example, 99999) indicating that all stores are to be applied is set (case 2, 7-10).

-Setting example of applied product The point master 682 is set so that each point plan is a plan that applies to all products or a plan that targets specific products. The distinction between all product targets and specific product targets can be made by other methods such as flag setting. Here, a setting example based on product codes will be described.

  That is, as shown in FIG. 3, in the point master 682, for each point plan, a product code of a product to which the point plan is applied is set. For example, in the case of a plan in which a specific product is a point grant target, the product code of the target product is set (cases 7 to 10). In addition, in the case where all the products are to be applied to the plan without being limited to the specific products, a product code (for example, 0) indicating that all products are to be applied is set (cases 2 to 6). . Note that product information other than the product code may be set as long as the applicable product can be identified.

  As described above, in the present embodiment, the point master 682 can be set by appropriately combining target stores or target products for point planning. That is, it is possible to collectively manage the point grant rates for all stores and all plans without separately providing a point master for each store or each plan.

-Setting example of point grant rate In the point master 682, a point grant rate for each point plan is set. In FIG. 4, the example which set the number of points with respect to the point unit price as a point grant rate is shown. That is, in the example of Case 1, 1 point is awarded for 100 yen, and the base point (basic points) is set with the point grant rate being 1% of the sales amount. A base point is a purchase point given by purchase of all goods in all stores in a normal period, without specifying a period, a store, and goods. Needless to say, the currency unit is not limited to yen, but is changed according to the currency of the country of implementation.

・ Application period setting example The application period is set with the start date and end date of the period during which the point plan is applied. Since the base point is applied throughout the year, a start date and an end date are set so as to sufficiently cover the application period.

<Explanation for each setting case>
・ Case 1
In case 1, a base point is set as described above. Both the store code and the product code are set to 0, and the combination of the code values can identify the base point application target. The code value may be set to a numerical value other than 0, as long as it can be identified that the base point is set by a combination of the store code and the product code. In addition, for cases 2 and 7 to 10, it is only necessary to be able to identify that there is a point plan limited to a base point that is applied to all stores for a limited time by the code value of the store code.

・ Case 2
In case 2, the application period and the point grant rate are set for the point plans that apply to all products and all stores, such as the founding festival point plan. In the store code, a code value 99999 indicating that all stores are applicable is set. That is, if the purchase date is within the applicable period (2014/05/09 to 2014/05/11) regardless of the code value of the store code and the product code, the point grant rate of case 2 (for the point unit price 200) 5 points are applied.

・ Cases 3-6
In cases 3 to 6, a point plan for all products is set, for example, limited to a single or a plurality of specific stores such as district-limited points. That is, store codes for four stores of store codes 11010, 11020, 11030, and 11040 of stores that belong to the specific district are set as applicable stores. Since the applicable products are all products, 0 is set as the product code to be applied. Therefore, if the store codes of the above four stores are accepted within the applicable period (2014/05/09 to 2014/05/11) regardless of the product code, the point grant rate for cases 3 to 6 (for the point unit price 300) 10 points are applied).

・ Case 7-10
In cases 7 to 10, for example, point plans to be held at all stores are set for specific products such as Christmas product points. In such a case, a code value 99999 indicating that all stores are targeted for application is set in the store code of the applicable store. As product codes of applicable products, product codes 1100001, 1100003, 1100004, and 1100025 of products related to seasonal events such as Christmas are set. Therefore, regardless of the store code, if the above four product codes are received within the applicable period (2014/12/01 to 2014/12/25), the point grant rate for cases 7 to 10 (for the point unit price 400) 15 points) apply.

・ Case 11-13
In cases 11 to 13, a point plan for a specific product and a specific store is set. In this example, store codes 11541, 11550, and 11551 of stores belonging to a specific district are set. In addition, a product code 1100002 of a product to be applied is set. Therefore, if the store code of the applicable store and the product code of the applicable product are received within the application period (2014/05/01 to 2014/05/31), the point grant rate (point unit price 100) for cases 11 to 13 is accepted. 10 points) apply.

  In this way, in the point master 682, the store code of the applicable store, the product code of the applicable product, and the application period are set for each point plan. That is, it is possible to collectively set a point plan for all stores and a point plan for specific stores in the point master 682. Accordingly, it is only necessary to distribute the same point master 682 to all the affiliated stores without preparing a point master for each region or store where the plan is held, so that the master management work can be simplified.

  Next, the store server 4 will be described. FIG. 4 is a block diagram illustrating a hardware configuration of the store server 4. The store server 4 includes a control unit 41 having a computer configuration including a CPU, a ROM, a RAM, and the like. In addition, a keyboard 45, a display 46, a printer 47, and an HDD 48 are connected to the control unit 41 via a bus 42 and an I / O device control unit 44.

  The control unit 41 performs data communication with the POS terminal 1 via the communication I / F 431 and the connection line 3. Further, the control unit 41 performs data communication with the headquarter server 6 via the communication I / F 432 and the dedicated line 8. Further, the control unit 41 requests the headquarter server 6 to transmit various data in response to a request from the POS terminal 1. In addition, the control unit 41 transmits the data received from the headquarter server 6 to the POS terminal 1 that requested it.

  The HDD 48 stores various data files such as a product master 481, a point master 482, a sales data file (not shown), in addition to various control programs for operating the CPU of the control unit 41.

  Further, the control unit 41 downloads the latest product master 681 and the point master 682 from the headquarter server 6 and updates the product master 481 and the point master 482 in the HDD 48 when a predetermined time comes or when the store clerk inputs an instruction. Note that the data update method is not particularly limited, and the product master 481 or the point master 482 may be updated with the difference data.

  Next, the POS terminal 1 will be described. FIG. 5 is a block diagram showing a functional configuration of the POS terminal 1. The POS terminal 1 includes a control unit 11 having a computer configuration including a CPU, a ROM, a RAM, and the like. The control unit 11 also has a keyboard 15, a scanner 16, a store clerk display 17, a customer display 18, a printer 19, an HDD 20, a magnetic card RW (reader / writer) via a bus 12 and an I / O device control unit 14. ) 21, non-contact type RW 22 and speaker 23 are connected. The salesclerk display 17 is a display device such as a liquid crystal display. A touch panel is laminated on the display screen of the clerk display 17.

  The HDD 20 stores a product master 201 and a point master 202 in addition to various programs executed by the control unit 11. The control unit 11 uses the predetermined time or update instruction as a trigger to copy the product master 481 and the point master 482 of the store server 4, and updates the product master 201 and the point master 202 in the HDD 20 with the copy data. Further, the HDD 20 is provided with a store code setting area 203. In the store code setting area 203, a store code for identifying the store where the POS terminal 1 is installed is set.

  The magnetic card RW21 reads / writes data from / to a magnetic memory type point card or the like. Note that the point card is not limited to the magnetic storage type, and other storage type cards may be used. In that case, as the RW of the point card, a type RW that conforms to the card storage method is used. The non-contact type RW 22 reads / writes data from / to a portable electronic device equipped with a non-contact type IC card or a non-contact type IC chip.

  The control unit 11 performs data communication with the store server 4 via the communication I / F 13 and the connection line 3. Further, the control unit 11 performs data communication with the headquarter server 6 via the dedicated line 8. In addition, the control unit 11 performs data communication with the validation server 7 via the dedicated line 2. Next, the program of the present embodiment executed by the control unit 11 will be described.

  Note that the program executed by the POS terminal 1 of the present embodiment is provided by being incorporated in advance in a ROM or the like. The program executed in the POS terminal 1 of the present embodiment is a file in an installable format or an executable format, and is a computer such as a CD-ROM, a flexible disk (FD), a CD-R, a DVD (Digital Versatile Disk). You may comprise so that it may record and provide on a readable recording medium.

  Furthermore, the program executed by the POS terminal 1 of the present embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. Further, the program executed by the POS terminal 1 of the present embodiment may be provided or distributed via a network such as the Internet.

  As shown in FIG. 5, the program executed by the POS terminal 1 of this embodiment has a module configuration including a store code reading unit 51, a product code receiving unit 52, a point management unit 53, and a print control unit 54. . As actual hardware, the CPU reads the program of the present embodiment from the storage medium (ROM) and executes the program, so that the respective units are loaded on the main storage device. Then, the CPU generates a store code reading unit 51, a product code receiving unit 52, a point management unit 53, and a print control unit 54 on the main storage device.

  The store code reading unit 51 reads a store code set in the store code setting area 203 of the HDD 20. The timing for reading the store code is not particularly limited. It may be read for each transaction, or may be read on the working memory when an application for registering sales is started.

  The product code receiving unit 52 receives the product code of the purchased product (sales product) in response to the code input from the keyboard 15 or the scanner 16.

  The point management unit 53 is based on the store code read by the store code reading unit 51, the product code received by the product code receiving unit 52, and the date and time acquired from a time measuring means such as RTC (Real Time Clock) or OS. The point master 202 is searched for applicable point plans. If there is an applicable point plan, the point grant rate of the plan is read and points are calculated. If there is no applicable point plan, base points are applied to calculate points.

  And the point management part 53 calculates the point provided with respect to the purchase of the said goods based on the read point grant rate and goods price. Further, when the end of one transaction is declared by operating the current key or the like, the point management unit 53 adds the points for purchase of each product and calculates the total points given in the current transaction. Further, the point management unit 53 transmits the total points and the customer's member number to the headquarter server 6 and updates the accumulated points in the member master 683.

  The print control unit 54 outputs print data to the printer 19 and controls printing of a receipt. In addition, the print control unit 54 includes the total points for the current time calculated by the point management unit 53 (sometimes referred to as addition points) in the print data of the receipt. The print control unit 54 reads the updated accumulated points from the member master 683 of the headquarter server 6 and includes them in the print data of the receipt. The printer 19 prints and issues a receipt based on the print data. As a result, along with the product information of the purchased product, the points added in the current transaction and the accumulated points held by the current customer are printed on the receipt.

  Next, a procedure example of the point grant process executed by the POS terminal 1 will be described. FIG. 6 is a flowchart showing the procedure of the point giving process executed by the POS terminal 1.

  First, the store code reading unit 51 reads the store code from the store code setting area 203 onto the RAM when the sales registration process is started (step S1). Next, the product code receiving unit 52 receives the product code of the purchased product in response to the code input from the keyboard 15 or the scanner 16 (step S2). Further, the product code receiving unit 52 reads product information such as a product name and a price from the product master 201 for the product of the product code.

  Next, the point management unit 53 searches the point master 202 for a point plan applicable to the purchased product based on the store code read in step S1, the product code received in step S2, and the current date and time. Search is performed (step S3). In this case, the base point is not included in the search range. For point plans other than the base point, search for the presence of the corresponding point plan, and apply the base point if not applicable.

  If there is a point plan corresponding to the combination of the store code, the product code, and the current date and time (step S4: Yes), the point management unit 53 reads the point grant rate of the plan from the point master 202 (step S5). And the point management part 53 calculates the point provided with respect to the said goods from the point grant rate and the goods price read by step S2 (step S6). On the other hand, if there is no corresponding point plan (step S4: No), the point management unit 53 applies a base point (step S7) and calculates a point (step S8).

  If the end of the transaction is not declared by operating the current key or the like (step S9: No), the control unit 11 returns to step S2 and performs the procedure of steps S2 to S8 for the remaining products. When the end of the transaction is declared by operating the current key or the like (step S9: Yes), the point management unit 53 adds the individual points calculated for each product and calculates the total points for this transaction. (Step S10).

  Then, the point management unit 53 transmits the member number input from the magnetic card RW21 and the current total points calculated in step S10 to the headquarter server 6, and updates the member master 683 (step S11). The control unit 61 of the headquarter server 6 updates the accumulated points by adding the received total points to the accumulated points of the received member number. Then, the accumulated points are returned to the POS terminal 1.

  The print control unit 54 of the POS terminal 1 generates receipt print data including the product code received in step S2 and the product information read from the product master 201. Further, the print control unit 54 generates receipt print data including the total points calculated in step S10 and the accumulated points updated in step S11. Then, the print control unit 54 outputs the generated print data to the printer 19 and prints and issues a receipt (step S12).

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

  In the embodiment described above, the point grant rate is the number of points given to a predetermined sales amount (point unit price), but the point grant rate setting method is not limited to this. As another example, the point grant rate may be set so that a predetermined point is added when one item is purchased. Moreover, you may set a point grant rate so that a predetermined point may be added for every transaction in a specific store.

  For example, if the point plan is to add 10 points per transaction at a specific store, 10 points added per transaction correspond to the point grant rate of the present embodiment. Or if it is a point plan of adding 10 points for every purchase of a specific product, 10 points added every time a product is purchased corresponds to the point grant rate of this embodiment.

  That is, the point grant rate of the present embodiment is not limited to the point ratio given to the product price. Points added to product units and transaction units may be set as the point grant rate.

  As described above, the POS terminal 1 of the present embodiment reads the point grant rate applied to the own store from the point master 682 using the store code of the own store, and calculates points. That is, since the POS terminal 1 of this embodiment can extract the point plan applied to its own store from the point master, the point master can be common to all stores. Therefore, it is not necessary to prepare by changing the point master between the planning target store and the non-planning store. As described above, according to the present embodiment, even if the point plan is diversified or complicated, it is possible to simplify and increase the efficiency of the point management work in the affiliated store.

  DESCRIPTION OF SYMBOLS 1 ... POS terminal, 4 ... Store server, 6 ... Head office server, 100 ... Store system, 201, 481, 681 ... Merchandise master, 202, 482, 682 ... Point master, 683 ... Member master, 203 ... Store code setting area.

JP 2013-186513 A

The sales data processing device of the embodiment is applied to store information storing means for storing store identification information for identifying a store, store identification information of a store to which the point plan is applied for each point plan, and the point plan. The point information is stored in association with the point storage rate, the store information reading unit for reading the store identification information of the own store from the store information storage unit, and the store information reading unit from the point storage unit. Point reading means for reading the point grant rate for the read store identification information; and point output means for calculating points based on the point grant rate read by the point reading means and outputting the calculated points. .

Claims (6)

Store information reading means for reading store identification information of the own store from store information storage means storing store identification information for identifying a store,
For each point plan, from the point storage means storing the store identification information of the store to which the point plan is applied and the point grant rate to be applied in the point plan, the store information reading means with respect to the store identification information read by the store information reading means Point reading means for reading the point grant rate;
Point output means for calculating points based on the point grant rate read by the point reading means, and outputting the calculated points;
A sales data processing apparatus. The point storage means stores the point grant rate for a store target plan that specifies a store to which the point plan is applied without specifying a product to which the point plan is applied as the point plan,
The point reading means reads the point grant rate of the store limited point plan corresponding to the store identification information read by the store information reading means from the point storage means,
The point output means calculates points based on the point grant rate of the store target plan read by the point reading means, and outputs the calculated points.
The sales data processing device according to claim 1. It further comprises a product information receiving means for receiving product information of sales products,
The point storage means stores, for each point plan, a combination of store identification information of a store to which the point plan is applied and product information of a product to which the point plan is applied,
The point reading means selects, from the point storage means, the point plan corresponding to the combination of the store identification information read by the store information reading means and the product information received by the product information receiving means, and Read the point grant rate of point planning,
The point output means calculates points based on the point grant rate read by the point reading means, and outputs the calculated points.
The sales data processing device according to claim 1 or 2. The point storage means stores a point grant rate of a base point to be applied when none of the point plans is applicable,
If the point plan corresponding to the store identification information read by the store information reading means is not set in the point storage means, the point output means calculates points based on the point grant rate of the base points. , Output the calculated points,
The sales data processing apparatus according to any one of claims 1 to 3. The point storage means stores the application period of the point plan for each point plan,
The sales data processing device according to any one of claims 1 to 4, wherein the point reading unit reads a point grant rate of the point plan within an application period from the point storage unit. In the sales data processing device, the computer
Store information reading means for reading store identification information of the own store from store information storage means storing store identification information for identifying a store,
For each point plan, from the point storage means storing the store identification information of the store to which the point plan is applied and the point grant rate to be applied in the point plan, the store information reading means with respect to the store identification information read by the store information reading means Point reading means for reading the point grant rate;
A program that functions as point output means for calculating points based on the point grant rate read by the point reading means and outputting the calculated points.

Images