JP2014048967A - Net supermarket server and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To solve a problem that previous confirmation is needed for coupon distributed via e-mail.SOLUTION: A net supermarket server that is connected via a network to a customer terminal and manages commodity information of commodities sold at a net supermarket, which is a selling system for selling commodities in a shop via a network, includes: a coupon storage part for storing coupon information indicative of whether or not a coupon can be used for a commodity; commodity data transmission means for transmitting, to a customer terminal, commodity data for causing commodity information of a sold commodity to be displayed in a display part of the customer terminal; coupon commodity transmission means for transmitting, to the customer terminal, coupon commodity data, which is used for causing commodity information to be displayed, the commodity information being created in response to a request from the customer terminal on the basis of the coupon information and showing a commodity purchased by using the coupon; and coupon data processing means for performing data processing as to the fact that the coupon is used for a commodity purchased at the customer terminal on the basis of the coupon commodity data.

Description

  Embodiments described herein relate generally to a net super server 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. In the online supermarket, when an order for purchasing a product is received from a customer through the Internet, the store is operated so that the corresponding product is collected from the store and delivered to the home of each customer.

  In order for this customer to shop at the online supermarket, the customer usually orders the product by accessing the Internet supermarket site via the Internet from a customer terminal such as a personal computer (PC) or mobile phone at home. The store has a system in which the ordered product is delivered to the home on the same day or at a later date.

  On the other hand, in order to promote sales at the online supermarket, the store distributes coupon coupons that can be used for products sold at the online supermarket planned by the store to customers. The customer looks at the received email, grasps the product to which the coupon is applied, and purchases the product.

  However, in order for a customer to use a coupon at an internet supermarket, it is necessary for the customer to grasp what kind of coupon has been delivered by e-mail, which has been a burden on the customer.

  The net super server of the embodiment is connected to a customer terminal through a network, and the net super server that manages product information of products sold at a net supermarket that is a sales method of in-store merchandise via the network. Correspondingly, a coupon storage unit that stores coupon information indicating whether or not the coupon can be used, and a product that transmits product data for displaying the product information of the product to be sold on the display unit of the customer terminal to the customer terminal Coupon product for sending coupon product data for displaying product information that can be purchased by using a coupon created based on the coupon information in response to a request from the data transmission means and the customer terminal to the customer terminal A data transmission means and a quotient purchased based on the coupon product data at the customer terminal And a coupon data processing means for performing data processing using the coupon against.

  The program of the embodiment is connected to a customer terminal via a network, and has a function of managing product information of products sold at a net supermarket that is a sales method of in-store products via the network, and corresponds to the products Then, on the customer terminal, product data for displaying the product information of the product to be sold on the display unit of the customer terminal on a computer having a coupon storage unit that stores coupon information indicating whether or not the coupon can be used is stored in the customer terminal. Product data transmission means for transmitting, and coupon product data for displaying product information that can be purchased by using a coupon created based on the coupon information in response to a request from the customer terminal is transmitted to the customer terminal Coupon product data transmitting means to perform and products purchased on the customer terminal based on the coupon product data To execute a coupon data processing means for executing data processing using the coupon against.

FIG. 1 is a diagram showing the entire system of the present embodiment. FIG. 2 is a block diagram of the net super server. FIG. 3 is a diagram showing a product master of the net super server. FIG. 4 is a diagram illustrating an example of a screen of the net super server. FIG. 5 is a flowchart showing the processing of the net super server. FIG. 6 is a diagram showing a screen of a customer terminal connected to the net super server via the network. FIG. 7 is a diagram showing another screen of the customer terminal connected to the net super server via the network.

  Hereinafter, a net super server and a program according to embodiments will be described in detail with reference to the accompanying drawings. The present invention is not limited to the embodiments described below.

  FIG. 1 is a diagram showing an entire system 1 according to the present embodiment. In FIG. 1, the store system 2 and the headquarter system 3 are connected by a dedicated line 4. Further, the store system 2 is connected to the net super system 5 via the network line 7. The net super system 5 is connected to a customer terminal 6 (for example, a PC (personal computer 6a) or a mobile phone 6b) via a network line 7.

  The headquarter system 3 provided in the headquarters includes a headquarter server 20. The headquarter server 20 is a customer master (not shown) for managing customer information (for example, customer name, age, address, gender, birthday, purchase history, cumulative points, customer rank, etc.) for each customer, It has a product master that stores product information for each store. The headquarter server 20 transmits the customer information of the customer master and the product information of the product master to the store server 11 of each store via the dedicated line 4.

The store system 2 provided in the store is mainly provided with a store server 11, a plurality of POS (Point Of Sales) terminals 12, and a net super management server 14, which are connected to each other via a local area network (LAN). (Area Network) line 15 is connected.
The POS terminal 12 executes data processing of merchandise sold at the store, the store server 11 collects data processed by the POS terminal 12, and sends information and commands from the headquarter server 20 to the POS terminal 12 and the net super server. 18 to send. The net super management server 14 executes data processing for the selection (picking) of products purchased at the net supermarket and the packaging (packing) of products based on the product purchase information transmitted from the net super server 18. The product boxing is executed by inputting product information at the handy terminal 16, and the input product information is transmitted to the net super management server 14 via the antenna 13. The net super management server 14 outputs the delivery slip data to the printer 17 when the packaging of the product is completed, and the printer 17 prints the delivery slip.

  The net super system 5 includes a net super server 18. Web server connected to network, database server that stores customer database including customer master and product database including product master, batch server that executes batch processing, management server that manages coupons and points, mail to customers The net super server 18 composed of a mail server that executes the distribution of the above is communicably connected to the store system 2 and the customer terminal 6 of each store via the network. The net super server 18 stores customer information, information on products sold on the net supermarket, etc. When there is an access from the customer terminal 6, the product information is transmitted to the customer terminal 6, and the product from the customer terminal 6 is transmitted. Accept purchase. The received product purchase information is transmitted to the net super management server 14 of the store system 2.

  FIG. 2 is a block diagram of the net super server 18. As shown in FIG. 2, the net super server 18 includes a central processing unit (CPU), a ROM (Read Only Memory) that stores various programs, a RAM (Random Access Memory) that develops various data, and various programs. The CPU, the ROM, the RAM, and the memory unit are connected to each other via the data bus 110. The CPU, ROM, RAM, and memory unit constitute the control unit 100. That is, the control unit 100 executes a control process described later when the CPU operates according to a program stored in the ROM or the memory unit and expanded in the RAM.

  Further, a keyboard 108 having a coupon use declaration key 113 for declaring use of a coupon is connected to the data bus 110 via a controller 105. Further, a network I / F (Interface) 109 is connected to the data bus 110. The network I / F 109 transmits data and commands from the network super server 18 and receives data and commands from the customer terminal 6 and the network super management server 14.

  The RAM also has a product master area 111 for storing product information and a coupon storage unit 112 for storing coupon information. The control unit 100 causes the product data transmission unit 101, the coupon product data transmission unit 102, and the coupon data processing unit 103 to function according to various programs stored in the ROM or the memory unit. In the coupon storage unit 112, coupon information indicating whether the coupon is usable or not usable is stored.

  The product data transmission unit 101 has a function of transmitting product data for displaying product information of a product to be sold on the display unit of the customer terminal 6 to the customer terminal 6. The coupon product data transmission means 102 transmits coupon product data for displaying the product information that can be purchased by using the coupon created based on the coupon information in response to a request from the customer terminal 6 to the customer terminal 6. It has a function. The coupon data processing means 103 has a function of executing data processing using a coupon for a product purchased based on the coupon product data at the customer terminal 6.

  FIG. 3 is a detailed view of the product master stored in the product master area 111. In FIG. 3, the product master specifies a product code area 21 for storing a product code, a product name area 22 for storing a product name, a unit price area 23 for storing a unit price of a product, and a coupon issued for the product. A coupon code area 24 for storing the coupon code, a discount area 25 for storing the discount amount of the product, a coupon usage count area 26 for storing the coupon usage count, and a flag indicating whether or not the coupon usage is declared. A coupon use flag area 27. The flag stored in the coupon use flag area 27 has a flag value of 1 when use of a coupon is declared, and a flag value of 0 when use of a coupon is not declared. Corresponding to the product code, the product name, unit price, coupon code, discount amount, coupon usage count, and coupon usage flag are stored.

  FIG. 4 is an example of a coupon list screen stored in the coupon storage unit 112 and displayed on the display unit 106. For a product for which a coupon is issued, the product code is input from the keyboard 108 and the coupon use declaration key 113 is operated to declare the use of the coupon for the product and store it in the product master corresponding to the input product code. The flag is set to 1 and the product data stored in the product master is stored in the coupon storage unit 112 and displayed on the display unit 106. In the coupon list, an implementation status area 31 indicating the implementation status of coupon use, an effective start area 32 indicating the valid start date of coupon usage, an effective end date area 33 indicating the valid end date of coupon usage, and a declaration of coupon usage are canceled. The operation area 34 is displayed, and these data are stored in the coupon storage unit 112. By operating the displayed delete key 35 in the operation area 34, the use declaration of the coupon is canceled and the data of the product code is deleted from the coupon storage unit 112. The use period of the coupon is obtained from the effective start date stored in the effective start area 32 and the effective end date stored in the effective end date area 33. If it is within the use period, the mark ● is displayed in the implementation status area 31. .

  FIG. 5 is a flowchart showing the control process of the net super server 18. In FIG. 5, the control unit 100 determines whether or not a product code has been input from the keyboard 108 (step SP11). When it is determined that the product code has been input (Yes in step SP11), the control unit 100 determines whether the coupon use declaration key 113 has been operated next (step SP12). If it is determined that the product has been operated (Yes in step SP12), the control unit 100 reads product data corresponding to the input product code from the product master stored in the product master area 111 and stores it in the coupon storage unit 112. (Step SP13). And the coupon use flag of the said goods memorize | stored in the coupon use flag area 27 is set to 1 (step SP14). When the coupon use declaration key 113 is not operated (No in step SP12), other processing is executed (step SP17).

  When the control unit 100 determines that the product code is not input (No in step SP11), the control unit 100 determines whether the delete key 35 has been operated (step SP15). If it is determined that the delete key 35 has been operated (Yes in step SP15), the control unit 100 sets the coupon use flag of the product stored in the coupon use flag area 27 to 0 (step SP16). And the merchandise data in which the delete key 35 was operated is deleted from the coupon memory | storage part 112, and a process is complete | finished.

  When determining that the operation is not the operation of the delete key 35 (No in step SP15), the control unit 100 determines whether the network I / F 109 has received a login signal from the customer terminal 6 (step SP21). If it is determined that a login signal has been received (Yes in step SP21), the control unit 100 transmits product information displayed on the screen of the logged-in customer terminal 6 (step SP22). This product information is information on all products sold on the internet supermarket, and all the transmitted product information is displayed on the customer terminal 6. A customer operates the screen displayed on the customer terminal 6 to purchase a product.

FIG. 6 shows an example of product information displayed on the screen of the customer terminal 6. In FIG. 6, product images 42, product names 43, and product prices 44 are displayed for all products sold at the online supermarket. In addition, for each displayed product, a “put into shopping cart” key 45 for purchasing the product is displayed. The customer selects and purchases a product while viewing the information on this screen. When purchasing a product, the product purchase data is created by operating the “put into shopping cart” key 45. When the purchase end is declared, the product purchase data is transmitted to the network super server 18 via the network line 7. At this stage, the customer terminal 6 screen is not displayed to indicate whether or not the coupon can be used, and the coupon can be used, and the product can be displayed by operating the “Add to shopping cart” key 45 from the screen. Coupons are not applied even when purchased.
In addition, on the screen of the customer terminal 6, a check-in coupon key 41 for shifting to a screen for shopping using a coupon is displayed. When the customer operates the check-in coupon key 41, a screen for purchasing a product using a coupon described later is displayed.

  If it is determined that the login signal has not been received (No in step SP21), the control unit 100 determines whether the network I / F 109 has received a signal indicating that the check-in coupon key 41 has been operated on the screen. (Step SP23). When it is determined that the signal indicating that the check-in coupon key 41 has been operated is received (Yes in step SP23), the control unit 100 determines whether the customer terminal 6 is logged in (step SP24) and logs in. If it is determined that the coupon usage flag is stored in the coupon usage flag area 27 of the product master, the control unit 100 extracts the product whose coupon usage flag is 1 and stores it in the coupon storage unit 112. The product in which ● is stored in the implementation status area 31 is extracted, and coupon product data is created for the extracted product. (Step SP25). Next, the control unit 100 transmits the created coupon product data to the customer terminal 6 on which the check-in coupon key 41 is operated (step SP26). That is, the coupon merchandise data transmitted at step SP26 is obtained by extracting only data of merchandise that can be purchased using the coupon.

  FIG. 7 is a screen of coupon product data transmitted to the customer terminal 6 and displayed on the display unit 106 of the customer terminal 6. In FIG. 7, a product image 42, a product name 43, and a product price 44 are displayed for each product for which the check-in coupon key 41 and the extracted coupon can be used. In addition, for each product, a “put in shopping cart” key 45 for purchasing the product without using the coupon and a “use coupon” key 46 for purchasing the product using the coupon are displayed. Yes. When purchasing a product without using a coupon, the product purchase data is created by operating the “put into shopping cart” key 45. When the purchase end is declared, the product purchase data is transmitted to the network super server 18 via the network line 7.

  On the other hand, when purchasing a product using a coupon, the coupon product purchase data is created by operating the “use coupon” key 46. When the purchase end is declared, the coupon product purchase data is transmitted to the net super server 18 via the network line 7.

  When it is not operation of the check-in coupon key 41 (No of step SP23), the control part 100 judges whether merchandise purchase data was received (step SP28). The product purchase data referred to here is data purchased by operating the “Add to shopping cart” key 45. If it is determined that the product purchase data has been received (Yes in step SP28), it is determined whether the customer terminal 6 is logged in (step SP29). If it is determined that the customer terminal 6 is logged in (Yes in step SP29). Data processing is executed based on the received product purchase data (step SP30). This data processing is data processing for providing the net super management server 14 with information for collecting and packing products for purchased products. Then, the product master data is updated (step SP31). At that time, the coupon usage count in the coupon usage count area 26 is not updated for the purchased product.

  When it is determined that the product purchase data is not received (No in step SP28), the control unit 100 determines whether the coupon product purchase data is received (step SP32). If it is determined that the coupon product purchase data has been received (Yes in step SP32), it is determined whether the customer terminal 6 is logged in (step SP33). If it is determined that the customer terminal 6 is logged in (Yes in step SP33). ), Data processing is executed based on the received coupon product purchase data (step SP34). This data processing is to provide information for collecting products and packing them for purchased products. Then, the product master data is updated (step SP35). At that time, the coupon usage count in the coupon usage count area 26 is also updated for the purchased product.

  In this embodiment having such a configuration, the net super server 18 transmits product data to be displayed on the customer terminal 6 to the customer terminal 6, and uses the coupon in response to a request from the customer terminal 6. Is transmitted to the customer terminal 6. The customer switches from the normal screen to the coupon screen, displays the products for which the coupon can be used, checks the products to which the coupon is applied while looking at the coupon screen, and purchases the products.

  If it is this Embodiment provided with such a structure, coupon product data will be transmitted to the customer terminal 6, and the product to which a coupon will be applied is confirmed while looking at the screen of the coupon product based on this coupon product data. Since the product can be purchased using the product, the customer can purchase the product to which the coupon is applied without confirming the product to which the coupon is applied in advance.

  Moreover, in this Embodiment, since it is judged with a flag whether it is a goods which can use a coupon, the goods which can use a coupon can be extracted easily. In addition, since the flag can be set to 1 only by operating the coupon use declaration key 113, the coupon can be used with a simple operation.

  Moreover, in this Embodiment, since it has the use period data which can use a coupon, use of a coupon becomes possible in the usable period of a coupon.

  Moreover, in this Embodiment, the usage period of a coupon can be input easily from a screen.

  Moreover, in this Embodiment, since the product purchase using a coupon and the product purchase which does not use a coupon can be selected in the coupon screen which can use a coupon, a coupon is used with respect to a required product. be able to.

  This embodiment is presented as an example, and is not intended to limit the scope of the invention. The novel embodiment can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. This embodiment and its modifications 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 this embodiment, coupon screen data that enables purchasing a product without using a coupon on the coupon screen is transmitted, but only a product that uses the coupon can be purchased on the coupon screen. Good coupon product data may be transmitted.

  In this embodiment, the customer terminal 6 is a PC 6a or a mobile phone 6b. However, the customer terminal 6 is a tablet terminal used when a person in charge of the store visits the customer's house and receives an order from the customer. Also includes listening terminals.

  In the present embodiment, the coupon usage period is set and the coupon can be used within the usage period, but the usage period is not necessarily provided.

  The program executed in the net super server of the present embodiment is a file in an installable or executable format, such as a CD-ROM, a flexible disk (FD), a CD-R, a DVD (Digital Versatile Disk), or the like. And recorded on a computer-readable recording medium.

  Further, the program executed by the net super server according to 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 net super server of the present embodiment may be provided or distributed via a network such as the Internet.

  Further, the program executed by the net super server according to the present embodiment may be provided by being incorporated in advance in a ROM or the like.

DESCRIPTION OF SYMBOLS 100 Control part 101 Purchase screen data transmission means 102 Coupon purchase screen data transmission means 103 Coupon purchase data processing means

JP 2002-56264 A

Claims (6)

In a net super server that is connected to a customer terminal via a network and manages product information of products sold in a net supermarket that is a sales method of in-store products via the network,
A coupon storage unit that stores coupon information indicating whether or not a coupon can be used in correspondence with the product;
Product data transmitting means for transmitting product data for displaying product information of products to be sold on the display unit of the customer terminal to the customer terminal;
Coupon product data transmission means for transmitting coupon product data for displaying product information that can be purchased by using a coupon created based on the coupon information in response to a request from the customer terminal to the customer terminal;
Coupon data processing means for executing data processing using the coupon for a product purchased based on the coupon product data in the customer terminal;
Net super server with The coupon information is flag information indicating whether or not a coupon can be used, and the coupon product data transmission means creates the coupon product data based on the flag information indicating that a coupon can be used. The net super server according to claim 1. 3. The net super of claim 1, wherein the coupon information includes coupon usage period data, and the coupon product data transmission unit transmits the coupon product data based on the coupon usage period data. server. A display unit is provided, and the usage period of the coupon can be displayed and set on the display unit.
The net super server according to claim 3. The coupon data processing means executes data processing that does not use the coupon for products purchased without using the coupon.
The net super server according to claim 1. Whether or not a coupon can be used corresponding to the product, which is connected to the customer terminal via a network and has a function of managing product information of a product sold at an online supermarket which is a sales method of in-store products via the network In a computer equipped with a coupon storage unit for storing coupon information indicating
Product data transmitting means for transmitting product data for displaying product information of products to be sold on the display unit of the customer terminal to the customer terminal;
Coupon product data transmission means for transmitting coupon product data for displaying product information that can be purchased by using a coupon created based on the coupon information in response to a request from the customer terminal to the customer terminal;
Coupon data processing means for executing data processing using the coupon for a product purchased based on the coupon product data in the customer terminal;
A program that executes

Images