JP2013186592A - Information processor and program - Google Patents

Abstract

[PROBLEMS] To promote the use of online supermarkets.
[Means for Resolution] A member input from a product information acquisition unit for acquiring product information including a unit price related to a product to be sold at an online supermarket and a member rank storage unit for storing a member rank for each member according to a purchase record The member rank extracting means for extracting the member rank of the member corresponding to the number and the storage unit that stores the reduction information for determining the amount to be reduced with respect to the unit price related to the sale target product in association with the member rank and extracted. Based on the extraction means for extracting the reduction information corresponding to the member rank, the reduction information corresponding to the extracted member rank, and the unit price related to the sale target product acquired by the product information acquisition means, the member rank A calculation means for calculating the corresponding sales amount, product information relating to the sale target product acquired by the product information acquisition means, and the calculation means calculated by the calculation means And a generating means for generating a commodity purchase screen that displays the sales amount in accordance with the personnel ranks.
[Selection] Figure 7

Description

  Embodiments described herein relate generally to an information processing apparatus and a program.

  With the spread of networks in recent years, a sales method (EC: Electronic Commerce) for selling products via the Internet is actively performed. Also, in a store such as a supermarket, a so-called “net supermarket” sales method is performed in which products sold in the store are sold via the Internet.

  By the way, according to the conventional Internet supermarket, there is one in which services are provided by e-mail, direct mail, point grant, etc. after purchasing a product.

  However, the above services are provided after purchasing the product, and are not provided in real time, and are not sufficient for promoting the utilization of the net supermarket.

  The information processing apparatus according to the embodiment includes a product information acquisition unit that acquires product information including a unit price related to a product to be sold at an online supermarket, and a member rank storage unit that stores a member rank for each member according to purchase results. A member rank extracting means for extracting the member rank of the member corresponding to the input member number, and a storage unit for storing reduction information for determining an amount to be reduced with respect to the unit price related to the sale target product in association with the member rank The extraction means for extracting the reduction information corresponding to the member rank extracted by the member rank extraction means; and the reduction information corresponding to the member rank extracted by the extraction means and the product information acquisition means Based on the unit price related to the sale target product, a calculation unit that calculates a sales amount according to the member rank, and the sales acquired by the product information acquisition unit It includes a commodity information according to the elephant products, and a generating means for generating a commodity purchase screen that displays the sales amount in accordance with the member rank in which the calculation means has calculated.

  The program according to the embodiment includes a product information acquisition unit that acquires product information including a unit price related to a product to be sold at an online supermarket, and a member rank storage unit that stores a member rank for each member according to purchase results. A storage unit for storing member rank extraction means for extracting the member rank of the member corresponding to the input member number, and reduction information for determining an amount to be reduced with respect to the unit price related to the sale target product in association with the member rank; The extraction means for extracting the reduction information corresponding to the member rank extracted by the member rank extraction means, the reduction information corresponding to the member rank extracted by the extraction means, and the product information acquisition means Based on the unit price associated with the product to be sold, a calculation unit that calculates a sales amount according to a member rank, and the product information acquisition unit And product information relating to the sale items were, and generating means for generating a commodity purchase screen that displays the sales amount in accordance with the member rank in which the calculation means has calculated, to function as.

FIG. 1 is a system configuration diagram schematically illustrating the overall configuration of a product sales system according to an embodiment. FIG. 2 is a block diagram showing the configuration of the electrical system of the member server. FIG. 3 is a schematic diagram showing purchase record information. FIG. 4 is a block diagram showing a configuration of the electrical system of the net super server. FIG. 5 is a schematic diagram showing a discount rate setting table. FIG. 6 is a diagram illustrating a software configuration of the control unit. FIG. 7 is a front view showing an example of a product purchase page. FIG. 8 is a flowchart showing a procedure of order reception processing.

  Embodiments of an information processing apparatus and a program according to the present invention will be described below in detail with reference to the accompanying drawings. The present invention is not limited to the embodiments described below.

  FIG. 1 is a system configuration diagram schematically showing the overall configuration of the commodity sales system 1. As shown in FIG. 1, a merchandise sales system 1 includes a plurality of POS (Point Of Sales) terminals 2, a store computer 4 that centrally manages these POS terminals 2 by connecting them through a LAN 3, Connected to the store computer 4 via a dedicated line 8 and a POS system 7 composed of a net super server 6 as an information processing apparatus that provides a net super service to the customer terminal 10 connected via the WAN 5 A server computer (hereinafter referred to as a member server) 9 is configured.

  The store computer 4 is responsible for overall control of the POS system 7. The store computer 4 stores a product master file F1, a store sales file F2, and the like. The product master file F1 is a file that stores product information such as product names, unit prices, product images, etc. in association with product codes, and the store sales file F2 is a file that stores sales registration data transmitted from each POS terminal 2 It is.

  Here, an operation of sales processing performed by the POS terminal 2 and the store computer 4 when a product is purchased at a store of the POS system 7 will be described. For example, when a product code attached to a product is read by a code scanner (not shown) of the POS terminal 2, the POS terminal 2 inquires the store computer 4 about the read product code. On the other hand, the store computer 4 searches the product master file F 1 in response to an inquiry from the POS terminal 2, reads product information corresponding to the corresponding product code, and transmits it to the POS terminal 2.

  Further, the POS terminal 2 receives the product name, unit price, etc. from the store computer 4, and registers it by department and displays it on a display (not shown) based on the inquired product code and the received product name, unit price, etc. Further, a printing process is performed by a printer (not shown), and the sales registered data is transmitted to the store computer 4. The store computer 4 that has received the sales registration data from the POS terminal 2 accumulates the sales registration data in the store sales file F2. In this manner, the sales registration data accumulated in the store sales file F2 is transmitted to the member server 9 at a predetermined timing. The sales processing for sales at the net supermarket by the net super server 6 will be described later.

  Next, the member server 9 will be described. The electrical system of the member server 9 is configured as shown in FIG. 2, for example. Here, FIG. 2 is a block diagram showing the configuration of the electrical system of the member server 9. The member server 9 includes a control unit 91 having a computer configuration including a CPU, a ROM, a RAM, and the like, and communicates with the store computer 4 via the dedicated line 8 from the communication interface 93 connected via the bus 92. It is comprised so that online communication can be performed mutually. Further, a keyboard 95, a display 96, a printer 97, and a hard disk drive device (hereinafter referred to as HDD) 98 are connected to the control unit 91 via a bus 92 and an I / O device control unit 94.

  The HDD 98 stores a chain sales file F3, a member master file F4, a member performance file F5, and the like in addition to a control program for operating the CPU of the control unit 91.

  The chain sales file F3 is a file that stores sales registration data transmitted from the store computer 4 of each store. The member master file F4 is a file that stores member information (customer name, gender, birthday, address, telephone number, etc.) for each member customer. The member record file F5 is a member rank storage unit, and is a file that stores purchase record information for each member customer. The purchase record information is cumulatively updated at a predetermined timing based on the chain sales file F3 and the like.

  Here, the purchase record information stored in the member record file F5 will be described with reference to FIG. As shown in FIG. 3, member information such as a member number for identifying a customer, a member rank, and a total purchase amount is stored in the purchase record information. Here, the member rank is a rank set by the store for each member based on a predetermined standard such as the customer's (member) purchase record (total purchase amount), the number of visits or store visit frequency, the number of purchases, etc. . As an example, the member rank at the time of enrollment is set as rank C, members with a total purchase price of 50,000 yen or more are set as rank B, and members with a purchase price of 100,000 yen or more are set as rank A.

  Next, the net super server 6 will be described. The net super server 6 is a server device for realizing a sales management system such as a so-called “net super”, and publishes an EC site for merchandise sales on the WAN 5 to place orders for merchandise purchase from the customer terminal 10. Accept. Further, the net super server 6 outputs (prints) a delivery slip for delivering the ordered product using a printer 67 described later.

  The electrical system of the net super server 6 is configured as shown in FIG. 4, for example. Here, FIG. 4 is a block diagram showing the configuration of the electrical system of the net super server 6. The net super server 6 is mutually connected between the control unit 61 having a computer configuration including a CPU, ROM, RAM, and the like, and the communication interface 631 connected via the bus 62 and the store computer 4 via the LAN 3. It is configured to perform online communication. Further, the communication interface 632 connected via the bus 62 is configured to perform online communication with the customer terminal 10 via the WAN 5. Further, a keyboard 65, a display 66, a printer 67, and a hard disk drive device (hereinafter referred to as HDD) 68 are connected to the control unit 61 via a bus 62 and an I / O device control unit 64.

  In the HDD 68, in addition to various programs (for example, a Web application, a database program, etc.) for operating the net super server 6 as a net super order receiving system in cooperation with the CPU of the control unit 61, order receiving processing described later A control program for executing the above is stored. The printer 67 may be built in the net super server 6 or may be provided outside the net super server 6.

  The HDD 68 functions as a storage unit, and stores a discount rate setting table 41 in addition to various programs executed by the CPU.

  The discount rate setting table 41 is a table in which a discount rate, which is reduction information for determining an amount to be reduced with respect to a unit price related to a sale target product, is set in association with each member rank when an order for product purchase is received. . Specifically, as shown in FIG. 5, the discount rate for member rank C is 0, the discount rate for member rank B is 10%, and the discount rate for member rank A is set to 20%. . Note that the reduction information for determining the amount to be reduced with respect to the unit price related to the sale target product is not limited to the discount rate, and may be a discount amount.

  Here, the net super service provided by the net super server 6 will be described. The net super server 6 (control unit 61) obtains product information such as the product name and unit price of the product to be sold on the net supermarket from the store computer 4 among the products provided in the store of the POS system 7, and these An EC site for ordering products with product information posted on WAN5. It is assumed that a mechanism for inputting a membership number (for example, user authentication) is provided in advance to identify each customer.

  As an operation until a product is purchased (ordered) at the internet supermarket, the customer terminal 10 accesses the address of the EC site provided by the internet super server 6 according to the operation of the user. On the other hand, when receiving an access from the customer terminal 10, the EC site control unit 61 (hereinafter simply referred to as the net super server 6) receives a product master file stored in the store computer 4 based on a program stored in the HDD 68. If F1 is referred and the product purchase page P1 (refer FIG. 7) which is a product purchase screen for receiving a purchase order is produced | generated, it will transmit to the customer terminal 10. FIG. The customer terminal 10 displays the product purchase page P1 provided from the net super server 6 on a display unit (not shown) and waits for a user operation input.

  The net super server 6 (control unit 61) has the following software configuration in order to generate the product purchase page P1. FIG. 6 is a diagram illustrating a software configuration of the control unit 61. As shown in FIG. 6, the control unit 61 includes a product information acquisition unit 601 that is a product information acquisition unit, a member rank extraction unit 602 that is a member rank extraction unit, an extraction unit 603 that is an extraction unit, and a calculation unit. A calculation unit 604 and a generation unit 605 which is a generation unit are provided.

  The product information acquisition unit 601 acquires product information such as the product name, unit price, and product image of the product from the product master file F1 of the store computer 4.

  The member rank extraction unit 602 extracts the member rank from the purchase record information in the member record file F5 of the member server 9 based on the input member number.

  The extraction unit 603 extracts a discount rate corresponding to the member rank extracted by the member rank extraction unit 602 from the discount rate setting table 41. As an example, when the member rank extraction unit 602 receives that the member rank is B, the extraction unit 603 extracts from the discount rate setting table 41 that the discount rate for the member rank B is 10%.

As shown in the following equation (1), the calculation unit 604 multiplies the unit price of the product acquired by the product information acquisition unit 601 by the discount rate corresponding to the member rank extracted by the extraction unit 603, according to the member rank. Calculate the sales amount.
Sales amount according to member rank = unit price x discount rate according to member rank (1)

  The generation unit 605 generates the product purchase page P1 based on the product name and product image of the product acquired by the product information acquisition unit 601 and the sales amount corresponding to the member rank calculated by the calculation unit 604.

  FIG. 7 is a front view showing an example of the product purchase page P1. As shown in FIG. 7, the product purchase page P1 displays a purchase screen G1 for purchasing the product read from the product master file F1. As shown in FIG. 7, a product image D1, a product name D2, and a product code D3 read from the product master file are displayed on the purchase screen G1 for each product on the product purchase page P1.

  In addition, as shown in FIG. 7, the purchase screen G1 for each product on the product purchase page P1 also displays the member rank and the sales amount D4 corresponding to the member rank. The calculation unit 604 also calculates a sales amount according to the discount rate corresponding to the member rank other than the member rank extracted by the extraction unit 603, and the generation unit 605 sells according to the member rank other than the corresponding member rank. The amount D5 is also included in the product purchase page P1 as reference material. Thus, the use of the net supermarket can be promoted by making a difference in the sales amount according to the member rank.

  Note that the generation unit 605 may include information derived from purchase results necessary for the member rank to be higher than the member rank extracted by the extraction unit 603. That is, as shown in FIG. 7, the product purchase page also includes information on purchases (total purchases) of customers (members) required to move up to the next member rank, information D6 such as the number of visits or store visits, and the number of purchases. You may make it display on P1. The example of the information D6 shown in FIG. 7 is a case where a member (member) with rank B has a purchase record so far (total purchase amount) of 73,000 yen when a member with 100,000 yen or more is set to rank A. .

  Each time the customer terminal 10 receives a press of the purchase button B1 provided on the purchase screen G1 via a keyboard, mouse, or the like (not shown), the product code, category, and purchase quantity of the corresponding product are used as purchase targets. The server 6 is notified. When the customer terminal 10 receives an instruction to the effect that the product selection has been completed via a keyboard or a mouse (not shown), the customer terminal 10 notifies the net super server 6 of the completion of the selection.

  After that, the net super server 6 prints the details of the product to be purchased by the order on the delivery slip.

  Then, at the store of the POS system 7, according to the product name and quantity recorded in the delivery slip, the ordered product is delivered from the store to the customer's house using a delivery organization (not shown). In this way, merchandise sold at the online supermarket is delivered from the actual store that is the supplier of the merchandise to the customer's home.

  Hereinafter, with reference to FIG. 8, an operation when the net super server 6 receives an order for purchasing a product from a customer (customer terminal 10) via an EC site that is disclosed to the WAN 5 will be described. Here, FIG. 8 is a flowchart showing a procedure of order reception processing executed when a product purchase order is received. As an assumption of this process, it is assumed that the initial screen of the EC site has been disclosed on the WAN 5 in advance.

  The control unit 61 stands by until the customer terminal 10 accesses the initial screen of the EC site disclosed on the WAN 5 (Step S11; No). When the control unit 61 accepts access to the website from the customer terminal 10 (step S11; Yes), the control unit 61 displays a screen for prompting the member number input and waits until the member number is input (step S11). S12; No).

  On the other hand, when the input of the member number is received from the customer terminal 10 (step S12; Yes), the control unit 61 (member rank extracting unit 602) stores the purchase record information corresponding to the member number via the store computer 4 as a member. Acquired from the member achievement file F5 of the server 9 and extracts the member rank (step S13).

  Further, the control unit 61 (product information acquisition unit 601) acquires the product name, unit price, product image, and the like of the product to be sold in the online supermarket from the product master file F1 of the store computer 4 (step S14).

  Further, the control unit 61 (extraction unit 603) extracts the discount rate corresponding to the member rank extracted in step S13 from the discount rate setting table 41 (step S15), and the control unit 61 (calculation unit 604) extracts it. The sales amount corresponding to the member rank is calculated using the discount rate (step S16).

  Next, the control unit 61 (generation unit 605) generates the product purchase page P1 based on the product name and product image of the product acquired in step S14 and the sales amount corresponding to the member rank calculated in step S16 ( Step S17). In steps S15 to S17, a sales amount corresponding to a member rank other than the corresponding member rank may be calculated and displayed on the product purchase page P1.

  Thereafter, the control unit 61 displays a product purchase page P1 on the customer terminal 10 via the EC site, and accepts selection of a product to be purchased from the product purchase page P1 from the product purchase page P1.

  The control part 61 determines whether the instruction | indication which performs accounting from the customer terminal 10 was received after selection of goods (step S18). If the instruction to perform the accounting is not accepted (step S18: No), the selection of the product is accepted as it is.

  When the control unit 61 receives an instruction to perform accounting (step S18; Yes), the sales amount of the product is calculated based on the product information of the product to be purchased (step S19).

  Thereafter, the control unit 61 notifies the customer of the completion of the purchase procedure by providing the customer terminal 10 with a Web page that represents the sales amount calculated in step S19 and a list of products to be purchased. (Step S20).

  Further, the control unit 61 executes a slip generation process for generating a delivery slip related to the delivery of the product for which the order has been received from the customer terminal 10 (step S21).

  The control unit 61 outputs the delivery slip generated by the slip generation processing in step S21 using the printer 67 (step S22), and ends this processing.

  The delivery slip output by the above process is delivered to the delivery staff together with each item to be purchased picked up in the store, and delivered to the customer home of the delivery destination. After delivery is completed, the customer's receipt signature or stamped delivery slip is returned to the store of the POS system 7 and subjected to sales processing by the POS terminal 2 at an arbitrary timing.

  As described above, according to the present embodiment, the product purchase screen displays the product information related to the product to be sold at the online supermarket and the sales amount obtained by subtracting the predetermined amount from the unit price according to the member rank according to the purchase record. By displaying as a certain product purchase page P1 and accepting orders for product purchases by customers, it is possible to provide services in real time at the time of product purchase. it can.

  As mentioned above, although some embodiment of this invention was described, these embodiment is shown as an example and is not intending limiting the range of 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.

  For example, in the above embodiment, the store computer 4 manages the product master file F1 and the store sales file F2 in an integrated manner. However, the present invention is not limited to this. For example, each POS terminal 2 individually stores the product master file F1 and the product master file F1. The store sales file F2 may be held, and data may be integrated into the product master file F1 and the store sales file F2 managed by the store computer 4 at a predetermined timing.

  The program executed by the net super server 6 of the above embodiment is provided by being incorporated in advance in a recording medium included in each device. However, the program is not limited to this and can be installed or executed. In such a case, the program may be recorded on a computer-readable recording medium such as a CD-ROM, a flexible disk (FD), a CD-R, or a DVD (Digital Versatile Disk). Furthermore, the recording medium is not limited to a medium independent of a computer or an embedded system, but also includes a recording medium in which a program transmitted via a LAN or the Internet is downloaded and stored or temporarily stored.

  Further, the program executed by the net super server 6 of the above embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. You may comprise so that it may provide or distribute via a network.

6 Information Processing Device 41 Storage Unit 601 Product Information Acquisition Unit 602 Member Rank Extraction Unit 603 Extraction Unit 604 Calculation Unit 605 Generation Unit F5 Member Rank Storage Unit

JP 2011-164775 A

Claims (6)

Product information acquisition means for acquiring product information including unit prices related to products sold at an online supermarket,
Member rank extraction means for extracting the member rank of the member corresponding to the input member number from the member rank storage unit for storing the member rank for each member according to the purchase record;
Extraction for extracting the reduction information corresponding to the member rank extracted by the member rank extraction means from a storage unit for storing reduction information for determining the amount to be reduced with respect to the unit price related to the sale target product in association with the member rank. Means,
Calculation means for calculating a sales amount corresponding to the member rank based on the reduction information corresponding to the member rank extracted by the extraction means and the unit price related to the sale target product acquired by the product information acquisition means;
Generating means for generating a product purchase screen for displaying the product information related to the sale target product acquired by the product information acquisition means and the sales amount according to the member rank calculated by the calculation means;
An information processing apparatus comprising: The calculation means also calculates a sales amount corresponding to the reduction information corresponding to a member rank other than the member rank extracted by the extraction means,
The generating unit generates the product purchase screen including a sales amount corresponding to the reduction information corresponding to a member rank other than the member rank extracted by the extracting unit;
The information processing apparatus according to claim 1. The generation means generates the product purchase screen including information derived from the purchase results necessary for the rank to rise to a member rank higher than the member rank extracted by the extraction means.
The information processing apparatus according to claim 1 or 2. Computer
Product information acquisition means for acquiring product information including unit prices related to products sold at an online supermarket,
Member rank extraction means for extracting the member rank of the member corresponding to the input member number from the member rank storage unit for storing the member rank for each member according to the purchase record;
Extraction for extracting the reduction information corresponding to the member rank extracted by the member rank extraction means from a storage unit for storing reduction information for determining the amount to be reduced with respect to the unit price related to the sale target product in association with the member rank. Means,
Calculation means for calculating a sales amount corresponding to the member rank based on the reduction information corresponding to the member rank extracted by the extraction means and the unit price related to the sale target product acquired by the product information acquisition means;
Generating means for generating a product purchase screen for displaying the product information related to the sale target product acquired by the product information acquisition means and the sales amount according to the member rank calculated by the calculation means;
Program to function as. The calculation means also calculates a sales amount corresponding to the reduction information corresponding to a member rank other than the member rank extracted by the extraction means,
The generating unit generates the product purchase screen including a sales amount corresponding to the reduction information corresponding to a member rank other than the member rank extracted by the extracting unit;
The program according to claim 4. The generation means generates the product purchase screen including information derived from the purchase results necessary for the rank to rise to a member rank higher than the member rank extracted by the extraction means.
The program according to claim 4 or 5.

Images