JP4404798B2 - Product sales management system, product information database server, and product sales management program - Google Patents

Description

  The present invention relates to discount sales of products, and more particularly to a product sales management system, a product information database server, and a product sales management program capable of outputting product discount information.

  The recent price competition of retail stores is also affected by the economic downturn, and customer needs for prices are increasing. For example, even if the freshness of a product is somewhat low, there is an increasing need for a product with a lower price. In order to meet the needs of customers who are strongly demanded for such low-priced products, it is possible to distinguish certain products from other products by attaching a sticker that displays a discount on products that are close to their expiration date. A method of selling and managing various products is adopted.

An example of a conventional method for selling and managing merchandise is described in Patent Document 1 (Japanese Utility Model Publication No. 60-173971). Patent Literature 1 sells and manages products by distinguishing products using price tags that change color according to temperature.
When paying at the checkout POS cash register terminal, it was necessary to change the price with labor and effort.

  In addition, with respect to products with low profits, it has been a problem to keep the stock of the products from remaining.

  The present invention provides a service that solves the above problems.

Shokai 60-173971

  However, the conventional method of selling and managing the above-mentioned products requires a labor-intensive effort to put a sticker that displays a discount, or a manual POS cash register terminal to adjust the price by manual labor. Labor costs and operational burdens, such as what had to be done, were issues.

  Moreover, even if a predetermined product can be sold separately from other products, it is insufficient in terms of product management, such as suppressing inventory.

  Furthermore, since the price tag is special in the conventional technique disclosed in Patent Document 1, it takes a high cost to distinguish products, and cannot meet the needs of customers for low-priced products.

  An object of the present invention is to provide a merchandise sales management system, a merchandise information database server, and a merchandise sales management program that can control costs and easily distinguish predetermined products from other products.

A first merchandise sales management system of the present invention includes a merchandise information database server for accumulating merchandise information including information related to merchandise and sales of the merchandise connected to each other via the Internet, the merchandise information database server, and a customer terminal. And an information output terminal that outputs information related to the sale of the product and a price tag creation terminal that creates a price tag attached to the product, and the product information database server uses the discount price and discount time of the product as information related to the sale of the product. Including discount information and color information of the price tag of the product, sending the product information of the product to be discounted to the price tag creation terminal, the price tag creation terminal based on the information of the production date and time included in the product information, Create a price tag with different colors for each time, and associate the product information with the color information of the created price tag in the product information database server. The product information including the discount information of the product and the color information of the price tag at the time of product discount is notified to the customer terminal by e-mail and displayed or voiced at the information output terminal for the product for which the discount time has started. Means for outputting.

  According to the present invention, it is possible to suppress costs and easily distinguish a predetermined product from other products based on various conditions.

  The reason for this is that a product information database server that stores product information including information related to products and sales of the products, connected to each other via the Internet, a customer terminal, and an information output terminal that outputs information related to sales of products This is because the information related to the sale of the product that is input to the product information database server is notified to the customer terminal by e-mail, and is also displayed or output by the information output terminal.

  Next, embodiments of the present invention will be described in detail with reference to the drawings.

(First embodiment)
(Composition of product sales management system)
FIG. 1 is a block diagram showing a configuration of a merchandise sales management system according to an embodiment of the present invention.

  Referring to FIG. 1, a merchandise sales management system according to an embodiment of the present invention includes a merchandise information input terminal 10, a merchandise information DB server 20, a discount information output terminal 30, a price tag creation terminal 40, a settlement POS cash register terminal 50, a customer terminal. 60 and the Internet (or LAN) 100 that connects them to each other.

  The product information input terminal 10 is a function (application) for inputting product information of products sold at retail stores such as supermarkets and customer information obtained in advance into the product information DB server 20 via the Internet (or LAN) 100. have.

  The merchandise information is composed of a plurality of items indicating various contents of the merchandise.

  FIG. 2 is a diagram illustrating an example of a product information database including product information input by the product information input terminal 10 to the product information DB server 20.

  Referring to FIG. 2, in one part of FIG. 2, items constituting the product information and their contents are described in association with each other. For example, as items, “product name”, “product category 1”, “manufacturing date / time”, “best before date”, “designated discount start time”, “best before date discount start time”, “stock quantity”, “discount start stock” "Number", "Number of stocks specified discount time", etc., and the contents of these items are "Miyazaki-produced Hinata chicken", "Fresh foods", "2004 / ** / ** / 15:55 ”,“ 2004 / ** / ** / 18:00 ”,“ 2004 / ** / ** / 12:00 ”,“ 6 hours before the expiration date ”,“ 421 ”,“ 200 ”,“ 2004 ” / ** / ** / "etc. are described in association with each other.

  The “designated discount start time” indicates a predesignated time for starting the discount sale of the product.

  The “best before date discount start time” indicates a time for starting a discount sale of a product, which is determined based on the content of the item “best before date”.

  Further, the “discount start stock quantity” is an item indicating the condition of the stock quantity for starting the discount sale of the product, and the stock quantity of the product is determined at a predetermined time when the discount sale of the product is started. If the condition is satisfied, this item indicates that discount sale of the product is started.

  Furthermore, the “stock quantity discount specified time” is an item indicating a predetermined time when the discount sale of the product is started when the stock quantity satisfies a predetermined condition.

  In addition, as shown in FIG. 2, there is “price color information” transmitted from the price tag creation terminal 40 (described later) as an item constituting the product information, and “blue” is described as an example of the content. Has been.

  “Price tag color information” is information indicating the color of the price tag attached to the product when the product is sold at a discount.

  The customer information is composed of a plurality of items indicating various characteristics of the customer.

  FIG. 3 is a diagram showing an example of a customer information database that the product information DB server 20 has.

  Referring to FIG. 3, as an example of items indicating customer characteristics and contents thereof, “registration number”, “mail address”, “customer name”, “customer address”, “phone number”, “age”, “ "Occupation" is listed.

  The product information DB (database) server 20 has a function of storing product information, customer information, etc. transmitted from the product information input terminal 10 and the like, and automatically displays a WEB page via the Internet (or LAN) 100. Update function and a function of sending mail to the customer terminal 60 based on the stored customer information (application).

  The merchandise information DB server 20 has a database composed of merchandise information shown in FIG. 2 and customer information shown in FIG.

  Here, the hardware configuration of the product information DB server 20 will be described.

  FIG. 4 is a block diagram showing a hardware configuration of the product information DB server 20 of the product sales management system according to this embodiment.

  Referring to FIG. 4, the product information DB server 20 stores a data processing unit 21 for storing product information, a product information DB 22 for updating and storing product information, a customer information DB 23, and product information including discount information on the network. And exchanges data such as product information with the website data storage unit 24 to be disclosed to the customer, the product information input terminal 10, the discount information output terminal 30, the price tag creation terminal 40, the settlement POS cash register terminal 50, and the customer terminal 60. A data transmission / reception unit 25;

  The product information DB server 20 of the present embodiment not only realizes its operation in hardware, but also executes a program for executing each function of each unit described above by the CPU on the data processing unit 21. It can be realized in software. This program is stored in an auxiliary storage unit such as a hard disk, and is loaded from the auxiliary storage unit to the CPU via a main storage unit such as a main memory, and controls the operation thereof, thereby realizing each function described above.

  The discount information output terminal 30 obtains product information from the product information DB server 20 via the Internet (or LAN) 100, and displays product discount information on a liquid crystal display or the like based on the product information, in-store speaker It has a function to output by voice guidance or the like.

  The price tag creation terminal 40 creates a price tag based on the product information shown in FIG. 2 obtained from the product information DB server 20 via the Internet (or LAN) 100. For example, products manufactured between 10:00 am and 12:00 am light blue based on the information of “Production Date / Time” that is an item that constitutes product information, and products manufactured between 12:00 and 14:00 are Change the ink when printing every time zone, such as green, and print the product name, price, etc. on the label paper.

  Further, the price tag creation terminal 40 associates the product with the price tag color information included in the price tag associated with the product, and transmits the product to the product information DB server 20.

  The settlement POS cash register terminal 50 has a function of obtaining product information from the database of the product information DB server 20 via the Internet (or LAN) 100, a function of identifying a product with a barcode reader, etc., and sales of the settled product. A function (application) for registering information in the database of the product information DB server 20;

  The customer terminal 60 is a terminal such as a mobile phone or a personal computer possessed by the customer, and is an email having product information including discount information transmitted from the product information DB server 20 via the Internet (or LAN) 100. And a function for browsing websites in which product information including discount information has been updated by the product information DB server 20 based on a URL (Uniform Resource Locator) attached to a sent e-mail. is doing.

(Operation of product sales management system)
Next, the operation of the merchandise sales management system according to this embodiment will be described in detail with reference to FIGS.

  5 and 10 are timing charts showing the operation of the merchandise sales management system according to the present embodiment.

  FIGS. 6 to 9 and FIGS. 11 to 14 are model diagrams showing modes for outputting product information including discount information.

  Referring to FIG. 5, in the product sales management system according to the present embodiment, when the product to be sold is close to a predetermined expiration date, discount information is output by announcement, etc., and the product is sold at a discount. explain.

  Product information input terminal 10 stores product information such as product name, date / time of manufacture, sales price, expiration date discount start time, discount price, customer email address, customer name, address, etc. Customer information is input (step A1) and registered in the product information database and customer information database (see FIGS. 2 and 3) of the product information DB server 20 (step A2).

  Next, the product information DB server 20 transmits product information such as “manufacturing date”, “product name”, “sales price”, etc. registered in the product information DB server 20 to the price tag creation terminal 40 (step A3).

  The price tag creation terminal 40, for example, for the product of the same type of product with a production time of 10:00 to 12:00 based on the information of “production date / time” included in the product information received from the product information DB server 20 In the case of products in light blue, green in the case of goods from 12:00 to 14:00, etc., print a different color on the label paper every time, create a price tag attached to the product, and price tag color information etc. that the created price tag has In association with the product information received from the product information DB server 20, the product information is transmitted to the product information DB server 20 and registered (step A4).

  When the “best before date discount start time” input from the product information input terminal 10 is reached (step A5), the product information DB server 20 introduces product information such as discount information based on the website data storage unit 23. Automatically updated (step A6), and an e-mail with product information including discount information and a URL indicating a link to a web page is registered in the customer information database shown in FIG. Is automatically transmitted to the customer terminal 60 (step A7).

  If the “best before date discount start time” has not been reached, step A5 is repeated until the “best before date discount start time” is reached.

  Upon receiving the e-mail, the customer terminal 60 displays product information and URL including discount information and price tag color information as shown in FIG. 6, and is updated by the product information DB server 20 based on the displayed URL. A web page as shown in FIG. 7 introducing the discount information can be displayed (step A8).

  Further, the product information DB server 20 transmits product information including discount information to the discount information output terminal 30 installed in the store (step A9), and the discount information output terminal 30 receives the product information from the product information DB server 20. The product information including the discount information is displayed as “discount breaking news” on the liquid crystal display as shown in FIG. 8, and the voice guidance of “discount breaking news” is performed on the in-store speaker as shown in FIG. (Step A10).

  When a product is settled at the settlement POS cash register terminal 50 (step A11), the settlement POS cash register terminal 50 inquires of the product information database of the merchandise information DB server 20 about the merchandise information to be settled (step A12), the merchandise information DB server 20 transmits the inquired merchandise information to the settlement POS cash register terminal 50 as a response to step A12 (step A13).

  If the product is not settled at the settlement POS cash register terminal 50 in step A11, the settlement POS cash register terminal 50 ends the process.

  The POS cash register terminal 50 settles the product, and if the product subject to settlement is discounted, the POS cash register terminal 50 settles the product at the price and sends the sales information to the product information DB server 20 (step A14). Registers the sales information in the product information database and finishes (step A15).

Next, with reference to FIG. 10, in the product sales management system according to the present embodiment, when there is a large number of products in stock, discount information is output through announcements, etc., and a case of performing product discount sales is described. The terminal 10 displays product information such as “product name”, “sales price”, “discount rate”, “stock quantity”, “discount start stock quantity”, “stock quantity discount specified time”, etc. Input (step B1) and register in advance in the product information database (see FIG. 2) of the product information DB server 20 (step B2).

  If the “stock quantity” of the product input from the product information input terminal 10 exceeds the “discount start stock quantity” for the “stock quantity discount specified time” (step B3), the product information DB server 20 "Mail address" item in which the server 20 automatically updates the web page introducing discount information, etc. (step B4), and the e-mail containing the discount information etc. and the URL of the web page is registered in the customer information database Is automatically transmitted to the customer terminal 60 (step B5).

  If the “stock quantity” of the product input from the product information input terminal 10 is less than the “discount start stock quantity” for the “stock quantity discount specified time” in step B3, the process proceeds to step B11.

  Upon receiving the e-mail, the customer terminal 60 displays the product information including the discount information as shown in FIG. 11 and the URL as “discount bulletin”, and is updated by the product information DB server 20 based on the displayed URL. A web page as shown in FIG. 12 that introduces the discount information as “discount breaking news” can be displayed (step B6).

  Further, the product information DB server 20 transmits the discount information in the product information database to the discount information output terminal 30 installed in the store as a “discount bulletin” (step B7) and receives this “discount bulletin”. The discount information output terminal 30 displays discount information as shown in FIG. 13 and voice guidance as shown in FIG. 14 (step B8).

  When the product is settled at the settlement POS register terminal 50 (step B9), the settlement POS register terminal 50 inquires the product information database of the product information DB server 20 about the product information of the product to be settled (step B10), The product information DB server 20 transmits “sales price”, “discount price”, etc. of the product information database (FIG. 2) to the settlement POS cash register terminal 50 (step B11).

  If the product is not settled at the settlement POS cash register terminal 50 in step B9, the settlement POS cash register terminal 50 ends the process.

  The settlement POS cash register terminal 50 performs settlement at the price if the product subject to settlement is discounted, transmits the sales information to the product information DB server 20 (step B12), and the transmitted sales information is The product information DB server 20 registers in the product information database and ends (step B13).

  In this way, the product sales management system according to the present embodiment has an electronic bulletin board and a liquid crystal display installed in advance in a product display shelf of a retail store such as a supermarket, and a product whose expiration date is approaching, such as fresh food. The product information etc. is automatically displayed on the electric bulletin board or liquid crystal display, the e-mail is sent to the mobile phone etc. possessed by the customer, the web page is released, and the discount information is notified to the customer.

(Effects of this embodiment)
According to the merchandise sales management system according to the present embodiment, the following effects are achieved.

  The first effect is that the operation cost is suppressed, and discounted products can be sold under various conditions by distinguishing the discounted products from other products.

  The reason is that, for example, as for a product having a best-before date such as fresh food, when the time limit approaches, discount information on the product is automatically output to the store, the customer's mobile phone, or the like. In addition, since the discount information for the product is related to the color of the price tag attached to the product, the customer can easily distinguish the discounted product from other products at first glance. On the other hand, it is possible to save labor, time, and cost for attaching a discount sticker or the like manually.

  The second effect is that, based on the sales information of the product, when the target product falls below the specified sales amount at the specified time, the product discount information is automatically announced to the customer. This will increase customer satisfaction and increase sales.

  The third effect is that the operator of the settlement POS cash register terminal can automatically settle without checking the sticker indicating the discount, so there is no need to manually enter the discount amount into the cash register. It is to prevent mistakes.

  Although the present invention has been described above with a plurality of preferred embodiments, the present invention is not necessarily limited to the above-described embodiments, and various modifications may be made within the scope of the technical idea. Can do.

  For example, in the above-described step B3, even if a product with a large stock falls below a preset sales amount at a predetermined time, the customer may be automatically notified of discount information and the like by updating the website.

  Further, various items constituting the product information of the product to which the price tag color-coded in advance is attached may be associated with the price tag color information included in the price tag.

  In addition, the customer information such as products that the customer wants, the products that the customer wants to make cheap, and the time to go shopping, etc. is received and aggregated from the customer's Web terminal or mobile phone. It may have a function of associating new customer information and product information, such as changing the display amount of the product, the discount rate, and changing them for each time zone.

It is a block diagram which shows the structure of the merchandise sales management system by embodiment of this invention. 3 is a diagram illustrating an example of a product information database configured by product information input to the product information DB server 20 by the product information input terminal 10. FIG. It is a figure which shows an example of the customer information database which the merchandise information DB server 20 has. 2 is a block diagram showing a hardware configuration of a product information DB server 20 of the product sales management system according to the present embodiment. FIG. It is a timing chart which shows operation | movement of the goods sales management system by this Embodiment. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a timing chart which shows operation | movement of the goods sales management system by this Embodiment. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a model figure which shows the aspect which outputs the merchandise information containing discount information. It is a model figure which shows the aspect which outputs the merchandise information containing discount information.

Explanation of symbols

10: Product information input terminal 20: Product information DB server 21: Data processing unit 22: Product information DB
23: Customer information DB
24: Web site data storage unit 25: Data transmission / reception unit 30: Discount information output terminal 40: Price tag creation terminal 50: Checkout POS cash register terminal 60: Customer terminal 100: Internet (or LAN)

Claims (14)

A product information database server that stores product information including information related to a product and the sale of the product, connected to each other via the Internet, the product information database server, a customer terminal, and information that outputs information related to the sale of the product Including an output terminal and a price tag creation terminal for creating a price tag attached to the product,
The product information database server is
As information related to the sale of the product, discount information including a discount price and discount time of the product and color information of the price tag of the product,
The product information of the product to be discounted is transmitted to the price tag creation terminal, and the price tag creation terminal color-codes a different color for each time based on the manufacturing date information included in the product information. And sending the product information and the color information of the created price tag in association with the product information database server,
For the product for which the discount time has started, the product information including the discount information of the product and the color information of the price tag at the time of discount of the product is notified to the customer terminal by e-mail and to the information output terminal A product sales management system characterized by being displayed or output by voice.   The merchandise information database server posts the merchandise information on the web site on the Internet for the merchandise for which the discount time has started, and notifies the customer terminal of the web site address by e-mail. The merchandise sales management system according to claim 1, wherein:   When the product information database server has a sales start price of the product less than a target sales amount set for each product at the discount start time of the product, product information including the discount information of the product is sent to the customer terminal. 3. The merchandise sales management system according to claim 1, wherein the information is output by e-mail and displayed by the information output terminal or by voice.   The merchandise information database server sends the merchandise information to the settlement terminal in response to an inquiry about the merchandise information from the settlement terminal that settles the merchandise,
  The settlement terminal that settles the product performs settlement based on the price or discount price of the product included in the product information, and transmits sales information to the product information database server. 3. The product sales management system according to 3.   5. The product sales management system according to claim 1, wherein the product information and customer information are registered in association with each other in the product information database server. A product information database server for storing product information including information on products and sales of the products,
Via the Internet, connected to a customer terminal, an information output terminal that outputs information related to the sale of the product, and a price tag creation terminal that creates a price tag attached to the product,
As information related to the sale of the product, discount information including a discount price and discount time of the product and color information of the price tag of the product,
The product information of the product to be discounted is transmitted to the price tag creating terminal, and the price tag creating terminal is color-coded according to a different color for each time based on the manufacturing date information included in the product information. And the product information and the color information of the created price tag are associated with each other and transmitted to the information database server,
For the product for which the discount time has started, the product information including the discount information of the product and the color information of the price tag at the time of discount of the product is notified to the customer terminal by e-mail and to the information output terminal A product information database server characterized by being displayed or output by voice.   7. The product for which the discount time has started is posted on a website for publishing on the Internet, and the address of the website is notified to the customer terminal by e-mail. Product information database server described.   When the sales of the product falls below the target sales amount set for each product at the discount start time of the product, product information including the discount information of the product is notified to the customer terminal by e-mail The product information database server according to claim 6 or 7, wherein the information output terminal outputs the information by display or voice.   In response to an inquiry about the product information from the checkout terminal that settles the product, the product information is transmitted to the checkout terminal,
  9. The product information database according to claim 6, wherein sales information after settlement based on a price or discount price of a product included in the product information is received from a payment terminal that settles the product. server.   The merchandise information database server according to claim 6, wherein the merchandise information and customer information are registered in association with each other. A product sales management program executed on a product information database server for storing product information including information related to products and sales of the products,
In the product information database server,
As information related to the sale of the product, discount information including a discount price and discount time of the product and color information of the price tag of the product,
The product information of the product to be discounted is transmitted to a price tag creation terminal that creates a price tag to be attached to the product, and the price tag creation terminal is based on information on manufacturing date and time included in the product information. and work with to create a price tag in different colors with different colors, to transmit in association with color information of the product information and price tag said created the information database server,
For the product for which the discount time has started, the product information including the discount information of the product and the color information of the price tag at the time of discount of the product is notified to the customer terminal by e-mail and to the information output terminal A product sales management program characterized by having a function of displaying or outputting by voice.   In the product information database server,
  The product for which the discount time has started is posted on a website that publishes the product information on the Internet, and the address of the website is notified to the customer terminal by e-mail. The product sales management program according to claim 11.   In the product information database server,
  When the sales of the product falls below the target sales amount set for each product at the discount start time of the product, product information including the discount information of the product is notified to the customer terminal by e-mail The product sales management program according to claim 11 or 12, wherein the information output terminal has a function of outputting by display or voice.   In the product information database server,
  In response to an inquiry about the product information from the checkout terminal that settles the product, the product information is transmitted to the checkout terminal,
  14. A function of receiving sales information after settlement based on a price or discount price of a product included in the product information from a payment terminal that settles the product. Product sales management program.

Images