JP5064521B2 - Sales support device and sales support program - Google Patents

Description

  The present invention relates to a sales support apparatus and a sales support program for supporting product sales on an EC site.

  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 these sales methods via the Internet, a website for selling products (hereinafter referred to as EC site) is opened on the Internet, and the customer can access the EC site to order and settle the product. Has been.

  In addition, in the EC site, when a product is out of stock, it is handled by displaying information indicating the out of stock on the order screen of the corresponding product. For example, Patent Document 1 discloses displaying information on sold out (out of stock) on a thumbnail image of each product.

  However, with the conventional method for dealing with out of stock, it is possible to make the customer recognize that the product is out of stock, but if the number of out-of-stock indications is excessively large, it may give the customer a bad impression such as poor product selection. is there.

  The present invention has been made in view of the above, and an object of the present invention is to provide a sales support device and a sales support program capable of efficiently and effectively displaying out-of-stock items.

In order to solve the above-described problems and achieve the object, the present invention discloses a sales support that publishes on the network the names and unit prices of a plurality of products to be sold via the network and accepts purchase orders for each product. In the apparatus, a first screen generating unit that generates a purchase screen for receiving a purchase order of the product for each product, a first holding unit that stores out-of-stock information for identifying whether the product is out of stock for each product, Based on the shortage information held in the first holding means, a calculating means for calculating a ratio of out-of-stock items in a product to be sold, and whether the ratio of out-of-stock items calculated by the calculating means exceeds a predetermined ratio When the out-of-stock product determining unit and the out-of-stock product determining unit determine that the ratio of the out-of-stock item is equal to or less than the predetermined ratio, information indicating out-of-stock is added to the purchase screen of the out-of-stock product. The ratio of the out-of-stock items by the second screen generating means for generating the out-of-stock screen, the transmitting means for transmitting the purchase screen and the out-of-stock screen to the terminal device connected via the network, and the out-of-stock determination means Purchase screen non-display means for hiding the purchase screen of the out-of-stock item from the terminal device .

The present invention also discloses a computer of a sales support apparatus that publishes on the network the names and unit prices of a plurality of products to be sold via the network, and accepts purchase orders for each product. A first screen generating means for generating a purchase screen for accepting an order; a first holding means for holding out missing product information for identifying whether or not the product is out of stock for each product; and a missing piece held in the first holding means. Calculation means for calculating the ratio of out-of-stock items in the products to be sold based on the item information, and out-of-stock determination means for determining whether the ratio of out-of-stock items calculated by the calculation means exceeds a predetermined ratio; When the out-of-stock determination means determines that the ratio of the out-of-stock item is equal to or less than the predetermined ratio, a second screen generation for generating a out-of-stock screen in which information indicating out-of-stock is added to the purchase screen of the out-of-stock product Means, a transmission means for transmitting the purchase screen and the out-of-stock screen to a terminal device connected via the network, and the out-of-stock determination means determines that the ratio of the out-of-stock-goods exceeds the predetermined ratio. Then, it functions as a purchase screen non-display unit that hides the purchase screen of the out-of-stock item from the terminal device .

  According to the present invention, it is possible to provide a sales support device and a sales support program capable of efficiently and effectively displaying out-of-stock products.

FIG. 1 is a diagram schematically showing an overall configuration of a net super system. FIG. 2 is a diagram illustrating the configuration of the store computer. FIG. 3 is a diagram illustrating an example of a net product master file. FIG. 4 is a diagram illustrating an example of a category master file. FIG. 5 is a diagram illustrating an example of an online purchase history file. FIG. 6 is a diagram illustrating the configuration of the sales support server. FIG. 7 is a diagram illustrating an example of a store status file. FIG. 8 is a diagram showing the configuration of the customer terminal. FIG. 9 is a flowchart showing a procedure for missing item event processing. FIG. 10 is a flowchart showing the procedure of the standard determination process. FIG. 11 is a flowchart showing the procedure of the purchase page providing process. FIG. 12 is a diagram illustrating an example of the initial page. FIG. 13 is a diagram illustrating an example of a purchase screen. FIG. 14 is a diagram illustrating an example of a stockout screen. FIG. 15 is a diagram illustrating an example of a product purchase page. FIG. 16 is a diagram illustrating an example of a product purchase page. FIG. 17 is a diagram illustrating an example of a product purchase page.

  Embodiments of a sales support apparatus and a sales support program according to the present invention will be described below in detail with reference to the accompanying drawings. In the embodiment described below, an example in which the present invention is applied to a server device (server system) that provides a net super service will be described, but the present invention is not limited to this example.

  FIG. 1 is a diagram schematically showing the overall configuration of the net super system 1. As shown in the figure, the net super system 1 is connected to a POS system 4 including a POS (Point Of Sales) terminal 2 and a store computer 3, and a store computer 3 via a network N2, and via a network N3. And a sales support server 5 that provides a net super service to the customer terminal 6. Note that the number of customer terminals 6 connected to the network N3 is not limited to the example of FIG.

  The POS terminal 2 is a terminal device operated by a store clerk (casher), and is configured to be able to execute online communication with the store computer 3 via a network N1 such as a LAN laid in the store. ing.

  The POS terminal 2 can be connected to a control unit composed of a CPU, ROM, RAM, etc., an input device such as a keyboard and various buttons, a display device such as a CRT and LCD, a storage device such as an HDD and a flash memory, and a network N1. A communication interface, a code scanner, and the like (not shown) are provided, and various functions are realized by the control unit executing predetermined programs stored in the storage device.

  Specifically, the POS terminal 2 notifies the store computer 3 of the product code when a product code (described later) added to each product in the form of a barcode or a two-dimensional code is read by the code scanner. To obtain the unit price of the corresponding product from the store computer 3. Further, when the POS terminal 2 calculates the total amount of the products to be purchased based on the unit price and the number of products to be purchased and performs settlement, the product code of each product to be purchased is obtained. Then, a purchase history registration process for performing registration in a store purchase history file 374 or a net purchase history file 375 described later is executed.

  In addition, the input device of the POS terminal 2 is one in which the purchase history registration processing relates to sales in a store (hereinafter referred to as store sales mode), or relates to sales in a net supermarket (hereinafter referred to as net sales mode). It is assumed that any mode is set by the cashier prior to the execution of the sales registration process. When information is transmitted to the store computer 3, the currently set mode is also notified.

  The store computer 3 is a server device that manages various data necessary for the operation of the network super system 1 and the POS system 4, and the electrical system is configured as shown in FIG. 2, for example.

  Here, FIG. 2 is a diagram showing a configuration of the store computer 3. As shown in the figure, the store computer 3 is connected to a control unit 31 having a computer configuration including a CPU, ROM, RAM, and the like, a bus 32, a first communication interface 331 connectable to the network N1, and a network N2. A connectable second communication interface 332, an I / O device control unit 34, an operation input unit 35 including a keyboard and a mouse, a display unit 36 including a display device such as a CRT and an LCD, and an HDD And a storage unit 37 composed of a storage device such as a flash memory.

  The control unit 31 is configured to perform online communication with each POS terminal 2 via the first communication interface 331 connected to the bus 32. The control unit 31 is configured to perform online communication with the sales support server 5 through the second communication interface 332 connected to the bus 32. In addition, an operation input unit 35, a display unit 36, and a storage unit 37 are connected to the control unit 31 via a bus 32 and an I / O device control unit 34.

  The storage unit 37 stores various programs executed by the CPU of the control unit 31 and various setting information related to the execution of the programs. The control unit 31 comprehensively controls the operation of the store computer 3 in cooperation with a predetermined program stored in the storage unit 37. In addition, the control unit 31 executes a missing item event process (see FIG. 8) described later in cooperation with a predetermined program stored in the storage unit 37.

  Further, the storage unit 37 stores, as data necessary for the operation of the net super system 1 and the POS system 4, a store product master file 371, a net product master file 372, a category master file 373, a store purchase history file 374, The purchase history file 375 for use is stored.

  The store product master file 371 stores a category ID, a product name, a unit price, and the like indicating the category of the product in association with the product code of each product sold in the store. Here, the product code is a product identification code such as JAN (Japanese Article Number) that can identify each product. The product code is added in advance in the form of a barcode or the like to each product sold in the store.

  The net product master file 372 stores a category ID, a product name, a unit price, an image URI, a shortage flag, a standard flag, etc. indicating the category of the product in association with the product code of each product sold on the net supermarket. Has been. FIG. 3 is a diagram showing an example of the online product master file 372. As shown in the figure, the net product master file 372 holds a record that associates a category ID, a product code, a product name, a unit price, an image URI, a shortage flag, and a standard flag for each product type. Yes.

  Here, the image URI is a URI (Uniform Resource Identifier) indicating the storage location of the image file of the corresponding product, and is used when the sales support server 5 provides the net super service. The shortage flag is flag information for identifying whether or not the corresponding product is out of stock, where “0” means that there is a stock and “1” means that the product is out of stock. The standard flag is flag information for identifying whether or not the corresponding product is a standard product that can secure stable sales, and “0” means a normal product that is not a standard product, and “1” means “1”. It means that it is a standard product.

  Note that the value of the shortage flag is determined via the POS terminal 2, the operation input unit 35, or the like when the stock in the store is exhausted or when the number secured for sale at the net supermarket has been sold. Is set to “1”.

  The category master file 373 holds a category ID and a category name in association with each other. FIG. 4 is a diagram illustrating an example of the category master file 373. In the figure, the category ID “001” is “vegetable”, “002” is “meat”, and “003” is “daily (product)”. The category ID in the category master file 373 corresponds to the category ID in the store product master file 371 and the net product master file 372, and the category name can be read from the product code.

  In the store purchase history file 374, the product code of the product purchased in the store and the date and time (sales date and time) when the purchase was made are stored in association with each other. In addition, in the online purchase history file 375, the product code of a product for which a purchase order has been received at the Internet supermarket and the date and time at which this purchase order has been received are stored in association with each other.

  FIG. 5 is a diagram showing an example of the online purchase history file 375. In the figure, product codes of products purchased (ordered) between “2009/11/05 15:42” and “2009/11/15 09:12” are shown.

  Here, an operation of a sales registration process executed when a product is purchased at a store or an online supermarket will be described. In the POS terminal 2, it is assumed that the mode setting button is set to either the store sales mode or the net sales mode.

  When a code scanner (not shown) reads the product code attached to the product, the control unit of the POS terminal 2 (hereinafter simply referred to as POS terminal 2) reads the read product code, the currently set mode, Is sent to the store computer 3.

  Based on the product code and mode notified from the POS terminal 2, the control unit 31 of the store computer 3 searches the store product master file 371 or the net product master file 372 for a corresponding record. Here, when the store sales mode is notified, the control unit 31 searches the store product master file 371, reads the product name and unit price corresponding to the notified product code, and the category name corresponding to the category ID. Are read from the category master file 373. When the online sales mode is notified, the control unit 31 searches the online product master file 372, reads the product name and unit price corresponding to the notified product code, and sets the category name corresponding to the category ID. Read from the category master file 373. Then, the store computer 3 transmits the read product name, unit price, category name, and other information to the POS terminal 2 that is the access source.

  When the POS terminal 2 receives information such as the product name, unit price, and category name from the store computer 3, the POS terminal 2 displays these information on a display device (not shown). In addition, when the POS terminal 2 performs settlement based on the unit price of each product, the product code of each product targeted for settlement is transmitted to the store computer 3 as a sales registration together with the currently set mode.

  When accepting sales registration from the POS terminal 2, the control unit 31 of the store computer 3 registers each product code included in the sales registration in the store purchase history file 374 or the net purchase history file 375. Specifically, when the store registration mode is included in the sales registration, the control unit 31 records each product code included in the sales registration with a current date and time counted by a timing unit (not shown) such as an RTC. The association is registered in the store purchase history file 374. In addition, when the sales registration includes the online sales mode, the control unit 31 associates each product code included in the sales registration with the current date and time and registers the product code in the online purchase history file 375.

  As a result, the purchase history of the product purchased in the store is registered in the store purchase history file 374, and the purchase history of the product purchased (ordered) in the online supermarket is registered in the online purchase history file 375.

  Next, the sales support server 5 will be described. The sales support server 5 is a server device for providing a net super service for selling products sold in a store of the POS system 4 via a network N3 such as the Internet. Specifically, the sales support server 5 is an ASP (Application Service Provider) server or the like, publishes an EC site for selling products on the network N3, and accepts orders for purchasing products.

  FIG. 6 is a diagram showing the configuration of the sales support server 5. As shown in the figure, the sales support server 5 includes a control unit 51 having a computer configuration including a CPU, a ROM, a RAM, and the like, a bus 52, a first communication interface 531 connectable to a network N2, and a network N3. A second communication interface 532 that can be connected to the I / O device, an I / O device control unit 54, an operation input unit 55 configured by a keyboard, a mouse, and the like, a display unit 56 configured by a display device such as a CRT or LCD, And a storage unit 57 including a storage device such as an HDD or a flash memory.

  The control unit 51 is configured to be able to perform online communication with the store computer 3 via the first communication interface 531 connected to the bus 52. The control unit 51 is configured to perform online communication with the customer terminal 6 via the second communication interface 532 connected to the bus 52. In addition, an operation input unit 55, a display unit 56, and a storage unit 57 are connected to the control unit 51 via a bus 52 and an I / O device control unit 54.

The storage unit 57 stores various programs executed by the control unit 51 and various setting information related to the execution of the programs. In addition, the storage unit 57 cooperates with the control unit 51 to generate various programs (for example, a Web application, a database program, etc.) for operating the sales support server 5 as an order system for a net supermarket, or to generate an EC site. Various contents are stored. The control unit 51 cooperates with various programs stored in the storage unit 57 to generate a first screen generation unit, a calculation unit, a stockout determination unit, a second screen generation unit, a transmission unit, a purchase screen non-display unit, a standard item. It functions as a determination unit and a setting unit , and executes a missing item event process, a standard determination process, a purchase page provision process, etc., which will be described later.

  In addition, the storage unit 57 stores a store status file 571 as setting information related to the realization of the net supermarket. Here, FIG. 7 is a diagram illustrating an example of the store status file 571. As shown in the figure, the store status file 571 stores various setting items and their setting values in association with each other. In the comment column, supplementary items regarding the set value are shown.

  In FIG. 7, the shortage policy flag indicates whether or not this out-of-stock product is out of stock when a shortage (out of stock) occurs in a product sold at an online supermarket. The policy of whether or not. In this embodiment, the shortage policy flag “0” means that no item is displayed, and the shortage policy flag “1” means that the item is out of stock.

  The missing item non-display threshold indicates a threshold for setting the missing item policy flag to “0” or “1”. In the present embodiment, in the shortage event process (see FIG. 8), which will be described later, when the ratio of the shortage among all products sold at the online supermarket (the current shortage ratio) exceeds the shortage non-display threshold, The product policy flag is set to “0”. In addition, although the value of the missing item non-display threshold value can be set to an arbitrary value, it is preferably a value of 50% or less.

  The standard product check time determines the execution time of a standard determination process to be described later. When the current time measured by a time measuring unit (not shown) such as RTC (Real Time Clock) reaches the standard product check time, the control unit 51 starts a standard determination process described later.

  Also, the shortage flag reset time determines the timing for initializing the shortage flag in each record stored in the net product master file 372 of the store computer 3 to “0”. When the current time measured by the time measuring unit (not shown) reaches the shortage flag reset time, the control unit 51 updates the shortage flag in each record stored in the net product master file 372 to “0”. .

  Returning to FIG. 1, the customer terminal 6 is an information processing apparatus such as a PC or a mobile phone operated by a user of the net super service. The electrical system of the customer terminal 6 is configured as shown in FIG. 8, for example.

  Here, FIG. 8 is a diagram illustrating a configuration of the customer terminal 6. As shown in the figure, the customer terminal 6 includes a control unit 61 having a computer configuration including a CPU, ROM, RAM, and the like, a bus 62, a communication interface 63 connectable to the network N3, and I / O device control. Unit 64, operation input unit 65 configured by a keyboard, a mouse, and the like, display unit 66 configured by a display device such as a CRT or LCD, and a storage unit 67 configured by a storage device such as an HDD or a flash memory It has.

  The control unit 61 is configured to be able to execute online communication with the sales support server 5 via the communication interface 63 connected to the bus 62. In addition, an operation input unit 65, a display unit 66, and a storage unit 67 are connected to the control unit 61 via a bus 62 and an I / O device control unit 64.

  The storage unit 67 stores various programs executed by the control unit 61 and various setting information related to the execution of the programs. The storage unit 67 stores various programs (for example, a Web browser) for enjoying the Internet super service. The control unit 61 realizes a Web browser function in cooperation with various programs stored in the storage unit 67, and accesses the EC site of the customer terminal 6 in accordance with an instruction from the user.

  Hereinafter, the operation of the net super system 1 will be described. First, with reference to FIG. 9, a shortage event process performed in cooperation with the store computer 3 and the sales support server 5 will be described.

  FIG. 9 is a flowchart showing a procedure for missing item event processing. First, the control unit 31 of the store computer 3 checks the state of the online product master file 372 at all times or every predetermined time, and determines whether or not the value of the shortage flag is updated (step S11; No). If it is determined that the missing item flag has been updated (step S11; Yes), the control unit 31 notifies the sales support server 5 that an event relating to the update of the missing item flag (hereinafter referred to as a missing item event) has occurred ( Step S12).

  On the other hand, when the control unit 51 of the sales support server 5 receives a notice of occurrence of a shortage event from the store computer 3, the control unit 51 refers to the online product master file 372 of the store computer 3 and is registered in the online product master file 372. The total number of records (hereinafter referred to as the number of product masters) and the total number of records whose missing item flag is “1” (hereinafter referred to as the number of missing products) are respectively acquired (step S21).

  Next, the control unit 51 divides the number of missing products by the number of product masters, thereby calculating a current missing product ratio that represents the ratio of missing items among all products sold at the online supermarket (step S22). Subsequently, the control unit 51 compares the current missing item ratio with the missing item non-display threshold value in the store status file 571 and determines whether or not the current missing item ratio exceeds the missing item non-display threshold value (step S23). ).

  When it is determined in step S23 that the current missing item ratio is equal to or less than the missing item non-display threshold (step S23; No), the control unit 51 sets the value of the missing item policy flag in the store status file 571 to “1” (out of stock display). ) (Step S24), the process is terminated. If it is determined in step S23 that the current missing item ratio exceeds the missing item non-display threshold (step S23; Yes), the control unit 51 sets the value of the missing item policy flag in the store status file 571 to “0”. After setting to (non-display) (step S25), this process is terminated.

  As described above, the control unit 51 of the sales support server 5 sets the shortage policy flag in the store status file 571 to be out of stock when the ratio of the shortage in all products sold at the online supermarket exceeds the shortage non-display threshold. The display is updated from “1” indicating display to “0” indicating non-display.

  In this embodiment, the sales support server 5 derives the number of product masters and the number of missing products. However, the present invention is not limited to this, and the store computer 3 calculates the number of product masters and the number of missing products. A product event may be notified to the sales support server 5 together. Further, in the present embodiment, the sales support server 5 updates the shortage policy flag at the timing when the shortage event is notified from the store computer 3, but the present invention is not limited to this. For example, the sales support server 5 periodically Alternatively, the status of the net product master file 372 may be confirmed.

  Next, the standard determination process executed by the sales support server 5 will be described with reference to FIG. Here, FIG. 10 is a flowchart showing the procedure of the standard determination process executed by the sales support server 5.

  First, the control unit 51 waits until the current time measured by a timekeeping unit such as an RTC reaches the standard product check time in the store status file 571 (step S31; No). If it is determined that the standard product check time has been reached (step S31; Yes), the control unit 51 performs a loop of steps S32 to S37 for each product (product code) registered in the online purchase history file 375 of the store computer 3. Execute the process.

  In this loop processing, the control unit 51 refers to the online purchase history file 375 and calculates the number of sales (sales number) within a predetermined period for each type of product code registered in the online purchase history file 375. Derived (step S33).

  Subsequently, based on the number of sales derived in step S33, the control unit 51 determines whether or not the product with the product code is a standard product that can secure stable sales (step S34). Note that the method for determining whether or not the product is a standard product is not particularly limited. For example, a product in which the number of sales within the past week exceeds a predetermined threshold (for example, 30) may be determined as a standard product, or the number of sales per day may be a predetermined threshold (for example, 5). It is good also as a form which determines the goods which exceeded it as a basic goods.

  If it is determined in step S33 that the product is a normal product (step S34; No), the control unit 51 searches a record corresponding to the product code of the normal product from the online product master file 372 of the store computer 3, and in the corresponding record. Is set to “0” (step S35).

  On the other hand, when it determines with a basic goods in step S34 (step S34; Yes), the control part 51 searches the record corresponding to the goods code of this basic goods from the internet product master file 372 of the store computer 3, and corresponds. The standard flag in the record is set to “1” (step S36).

  When the control unit 51 repeats the processing of steps S32 to S37 until the standard flag is set for all the product codes registered in the online purchase history file 375, the standard flag is set for all the product codes. End the process.

  In this way, the sales support server 5 sorts each product into a standard product and a normal product based on the purchase history of the product sold at the net supermarket. In this embodiment, the basic product is determined based on the online purchase history file 375. However, the present invention is not limited to this, and the basic product may be determined based on the store purchase history file 374. Alternatively, the basic product may be determined based on both the store purchase history file 374 and the net purchase history file 375.

  Next, with reference to FIGS. 11 to 17, the product purchase screen providing process executed by the sales support server 5 will be described. Here, FIG. 11 is a flowchart showing a procedure of a purchase page providing process executed by the sales support server 5 in response to an access from the customer terminal 6.

  First, in the customer terminal 6, the control unit 61 accesses an EC site published on the network N 3 in response to a user operation via the operation input unit 65 (step S 41).

  When receiving the access from the customer terminal 6, the control unit 51 of the sales support server 5 generates an initial page of the EC site based on various contents stored in the storage unit 57 (step S51), and the customer of the access source Transmit (provide) to the terminal 6 (step S52).

  When accepting the initial page transmitted from the sales support server 5, the control unit 61 of the customer terminal 6 displays the initial page on the display unit 66 (step S42).

  FIG. 12 is a diagram illustrating an example of an initial page provided from the sales support server 5. In the figure, a list of character strings representing each product category (for example, vegetables, fruits, etc.) is displayed in the area A1. In the area A2, icon images representing each product category are displayed in a list.

  When the user operating the customer terminal 6 selects a desired product category (for example, “vegetables”) from a plurality of product categories displayed in the area A1 or the area A2 of the initial page via the operation input unit 65, The control unit 61 receives the category name or category ID of the selected product category.

  Returning to FIG. 11, when the control unit 61 of the customer terminal 6 accepts selection of a product category from the user based on the initial page displayed on the display unit 66 (step S43), the category name or category ID of the product category is sold. It transmits to the support server 5 (step S44).

  On the other hand, when receiving the category name or category ID from the customer terminal 6, the control unit 51 of the sales support server 5 extracts a record corresponding to the category name or category ID from the net product master file 372 of the store computer 3. (Step S53). And the control part 51 performs the loop process of step S54-S59 about each of the extracted record.

  In this loop process, first, the control unit 51 determines whether or not the value of the shortage flag in the record is “0” (step S55). When it is determined that the value of the shortage flag is “0” (step S55; Yes), the control unit 51 corresponds to the product code based on the product code, product name, unit price, and image URI included in this record. A screen for receiving a purchase order for the product (hereinafter referred to as a purchase screen) is generated (step S56), and the process proceeds to step S59.

  FIG. 13 is a diagram illustrating an example of the purchase screen generated in step S56. As shown in the figure, the purchase screen G1 displays an area A31 for displaying a product code, an area A32 for displaying a product name, an area A33 for displaying a unit price, and an image file. Area A34. The purchase screen G1 has an area A35 for selectively inputting the number of products to be purchased and a purchase button B1 for instructing an order. In the area A34, an image file acquired from the storage location indicated by the image URI is displayed.

  Returning to FIG. 11, when it is determined in step S55 that the missing item flag is “1” (step S55; No), the control unit 51 determines the value of the standard flag included in this record and the missing item in the store status file 571. It is determined whether or not the values of the policy flags are both “0” (step S57). Here, when it is determined that both the standard flag and the shortage policy flag are values other than “0” (step S57; No), the control unit 51 adds the product code, product name, unit price, and image URI included in this record. Based on this, a screen indicating that the product corresponding to the product code is out of stock (hereinafter referred to as the “out of stock screen”) is generated (step S58), and the process proceeds to step S59.

  Here, FIG. 14 is a diagram illustrating an example of the out-of-stock screen generated in step S58. As shown in the figure, the out-of-stock screen G2, as with the purchase screen G1, is an area A31 for displaying the product code, an area A32 for displaying the product name, and an area A33 for displaying the unit price. And an area A34 for displaying an image file. Further, the out-of-stock screen G2 has an area A35 for selectively inputting the number of products to be purchased and a purchase button B1, as in the purchase screen G1, but is in an invalidated state that cannot be operated. Information indicating out of stock is displayed at the position of the purchase button B1. That is, the control unit 51 invalidates the area A35 and the purchase button B1 in the purchase screen G1, and generates a product with the information indicating that the product is out of stock as the out-of-stock screen G2.

  Returning to FIG. 11, when both the standard flag and the missing item policy flag values are determined to be “0” in Step S57 (Step S57; Yes), the control unit 51 suppresses the generation of the out-of-stock screen, The cut screen (and purchase screen) is not generated, and the process immediately proceeds to step S59.

  If the control unit 51 executes the processing of steps S54 to S59 for each record extracted in step S53 and determines that the processing has been executed for all the records, the product is based on the purchase screen and the out-of-stock screen generated so far. A purchase page is generated (step S60) and transmitted to the customer terminal 6 (step S61).

  When accepting the product purchase page transmitted from the sales support server 5, the control unit 61 of the customer terminal 6 displays the product purchase page on the display unit 66 (step S45), and ends this process.

  Thereafter, each time a new product category is selected on the customer terminal 6, the control unit of the sales support server 5 executes the processing of steps S51 to S61, and displays the product purchase page for the selected product category on the customer terminal 6 To provide.

  15 to 17 are diagrams illustrating examples of the product purchase page provided from the sales support server 5. Here, FIG. 15 shows a product purchase page configured by purchase screens G11 to G13. In the case of the figure, the user operating the customer terminal 6 presses the purchase button B1 provided on the purchase screen (for example, purchase screen G12) of the product desired to purchase via the operation input unit 65. Thereby, the control part 61 detects pressing of purchase button B1, and recognizes the goods corresponding to this purchase button B1 as purchase object.

  FIG. 16 shows a state in which the purchase screen G12 is changed to the out-of-stock screen G22 when the product corresponding to the purchase screen G12 shown in FIG. 15 is out of stock. As described above, since the area A35 and the purchase button B1 are invalidated on the out-of-stock screen G2, it is impossible to make a product a purchase target.

  By the way, in the case where the out-of-stock screen G2 is displayed, when the product is out of stock and the standard flag is “1” and the shortage policy flag is “0”, the standard flag is “0” and the shortage policy flag is “ In the case of “1”, the standard flag and the missing part policy flag are both “1”.

  Here, focusing on the condition that the product is out of stock and the standard flag is “1” and the shortage policy flag is “0”, this is because the standard product is out of stock, and the current stockout ratio exceeds the shortage hidden threshold. It corresponds to the case. That is, the out-of-stock screen G2 is displayed in preference to the standard flag value “1” over the shortage policy flag value “0”. This is because the basic product is a basic product compared to the normal product, so it may give the user a bad impression that the product lineup is poor by hiding the out-of-stock screen. It is.

  Focusing on the condition that the product is out of stock and the standard flag is “0” and the stockout policy flag is “1”, this is because the normal product is out of stock and the current stockout ratio is below the stockout non-display threshold. Corresponds to the case. Focusing on the condition that the product is out of stock, the standard flag is “1”, and the shortage policy flag is “1”, this is that the standard product is out of stock and the current product shortage ratio is below the missing product non-display threshold. Corresponds to the case. In these cases, the current stockout ratio is below the stockout non-display threshold, so even if the stockout screen is displayed, the number of stockouts will not be excessive, and the product will run out without harming the user's witness. Can be recognized by the user.

  FIG. 17 shows a state where the purchase screen G12 (or the out-of-stock screen G22) is not displayed due to the out of stock of the product corresponding to the purchase screen G12 shown in FIG. In this case, the purchase screen G13 is arranged at the position where the non-displayed purchase screen G12 (or the out-of-stock screen G22) is arranged, and the purchase screen G14 is arranged at the position where the purchase screen G13 is arranged. Therefore, the user of the customer terminal 6 cannot confirm the product itself corresponding to the purchase screen G12 from the product purchase page.

  By the way, the case where the purchase screen G12 (or the out-of-stock screen G22) is not displayed is limited to the case where the product is out of stock, the standard flag is “0”, and the shortage policy flag is “0”. This corresponds to a case where the normal product is out of stock and the current missing product ratio exceeds the missing product non-display threshold. In this case, if the out-of-stock screen is displayed, the number of out-of-stock screens is excessively increased, which may impair the user's feelings. Therefore, in the present embodiment, when the normal product is out of stock and the current shortage ratio exceeds the shortage non-display threshold, this normal product purchase screen G12 (or out-of-stock screen G22) is hidden. , The user has a bad impression.

  As described above, in this embodiment, the display of the out-of-stock screen is switched between display and non-display according to the value of the standard flag of the product that is out of stock and the value of the out-of-stock policy flag. And it becomes possible to carry out effectively. In addition, this can prevent the out-of-stock screen from being displayed excessively, so that it is possible to prevent the user from having a bad impression on the out-of-stock display of the product, and to smoothly operate the Internet super service. Is possible.

  When the purchase button B1 on the purchase screen displayed by the above process is pressed, the control unit 61 of the customer terminal 6 notifies the sales support server 5 of the product code of the product corresponding to the purchase screen as a purchase target. Further, when the control unit 61 receives a press of a confirmation button (not shown) for confirming an order via the operation input unit 65, the control unit 61 notifies the sales support server 5 that the order has been confirmed.

  When the control unit 51 of the sales support server 5 holds the product code notified as a purchase target and receives a notification that the order has been confirmed, the product name and unit price corresponding to each product code held so far Etc. are read from the net product master file 372 and transmitted to the store computer 3 as an order list. In the POS system 4, based on the order list received by the store computer 3, the products included in the order list are collected (picked) from the products sold in the store. Then, when the cashier of the POS terminal 2 sets the mode setting button of the POS terminal 2 to the net sales mode, for each product collected from the store, the product code is read using a code scanner (not shown) and sales registration processing is performed. . As a result, the product code of the product purchased at the internet supermarket is registered in the internet purchase history file 375.

  The embodiment of the present invention has been described above, but the present invention is not limited to this, and various modifications, substitutions, additions, and the like are possible without departing from the spirit of the present invention.

  For example, in the above-described embodiment, the store product master file 371 and the online product master file 372 are used to manage the price of the product sold in the store and the online supermarket. For example, it is good also as a form which manages the goods sold in a store and a net supermarket using one goods master file.

  Moreover, in the said embodiment, although it was set as the form which manages the purchase history of the goods sold in the store and the net supermarket using the store purchase history file 374 and the net purchase history file 375, it is not limited to this. For example, it is good also as a form which manages the purchase history of the goods sold in the store and the net supermarket using one purchase history file.

  In the above embodiment, the store computer 3 holds the net product master file 372 and the net purchase history file 375. However, the present invention is not limited to this, and the sales support server 5 may hold it.

  In the above embodiment, the sales support server 5 is arranged outside the POS system 4. However, the present invention is not limited to this and may be arranged in the POS system 4. The store computer 3 may have a function of the sales support server 5.

  Moreover, although the said embodiment demonstrated the internet super service which one shop (POS system 4) provides, it is not restricted to this, By connecting the POS system 4 of multiple shops to the sales support server 5, each shop The Internet super service may be provided via the sales support server 5. In the case of this form, it is preferable for the sales support server 5 to display a selection item for selecting a store to be a purchase destination on the initial page or the like.

  The program executed by each device of the above embodiment may be configured to be provided by being incorporated in advance in a ROM or the like. The program may be provided by being recorded in a computer-readable recording medium such as a CD-ROM, a flexible disk (FD), a CD-R, or a DVD in an installable or executable format file. Good.

  Further, the program may be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network. Further, the program may be provided or distributed via a network such as the Internet.

DESCRIPTION OF SYMBOLS 1 Net super system 2 POS terminal 3 Store computer 31 Control part 32 Bus 331 1st communication interface 332 2nd communication interface 34 I / O device control part 35 Operation input part 36 Display part 37 Storage part 371 Store product master file 372 Net Product master file 373 category master file 374 store purchase history file 375 online purchase history file 4 POS system 5 sales support server 51 control unit 52 bus 531 first communication interface 532 second communication interface 54 I / O device control unit 55 Operation input unit 56 Display unit 57 Storage unit 571 Store status file 6 Customer terminal 61 Control unit 62 Bus 63 Communication interface 64 I / O device control unit 65 Operation input unit 66 Display unit 67 Part N1 network N2 network N3 network

Japanese Patent No. 3428297

Claims (6)

In the sales support device that publishes on the network each of the names and unit prices of a plurality of products sold through the network, and accepts purchase orders for each product,
First screen generation means for generating a purchase screen for receiving a purchase order of the product for each product;
First holding means for holding missing item information for identifying whether or not the product is out of stock for each product;
Calculation means for calculating a ratio of out-of-stock items in the products to be sold based on the shortage information held in the first holding means;
Out-of-stock determination means for determining whether the proportion of out-of-stock items calculated by the calculation means exceeds a predetermined ratio;
When the out-of-stock determination unit determines that the ratio of the out-of-stock item is equal to or less than the predetermined ratio, a second screen generation unit that generates an out-of-stock screen in which information indicating the out-of-stock is added to the purchase screen of the out-of-stock product;
Transmitting means for transmitting the purchase screen and the out-of-stock screen to a terminal device connected via the network;
When it is determined by the out-of-stock determination means that the ratio of the out-of-stock item exceeds the predetermined ratio, a purchase screen non-display unit that hides the purchase screen of the out-of-stock item from the terminal device;
A sales support apparatus characterized by comprising: In association with each product held in the first holding means, further comprising second holding means for holding basic information for identifying whether or not the product is a standard product that can ensure stable sales,
The second screen generating means is the standard information of the second holding means associated with the out-of-stock product when the out-of-stock product judgment means judges that the ratio of the out-of-stock product exceeds the predetermined ratio There to represent the standard items, sales support apparatus according to claim 1, characterized in that to produce the goods off the screen of the sold-out goods. A third holding means for associating a type of a product for which an order has been received from the terminal device based on the purchase screen with a date for receiving the order, and holding the purchase history;
Based on the purchase history held in the third holding means, a standard determination means for determining whether or not the product is a standard product for each type of product included in the purchase history;
A setting unit that sets a determination result of each product determined by the standard determination unit in the basic information of the second holding unit;
The sales support apparatus according to claim 2, further comprising: The sales support apparatus according to claim 3, wherein the standard determination unit determines a product whose number of sales in a predetermined period exceeds a predetermined first threshold as a standard product . The sales support apparatus according to claim 3, wherein the standard determination unit determines a product whose number of sales per day exceeds a predetermined second threshold as a standard product . A computer of a sales support device that publishes on the network the name and unit price of a plurality of products sold via the network, and accepts purchase orders for each product ,
First screen generation means for generating a purchase screen for receiving a purchase order of the product for each product;
First holding means for holding missing item information for identifying whether or not the product is out of stock for each product;
Calculation means for calculating a ratio of out-of-stock items in the products to be sold based on the shortage information held in the first holding means;
Out-of-stock determination means for determining whether the proportion of out-of-stock items calculated by the calculation means exceeds a predetermined ratio;
When the out-of-stock determination unit determines that the ratio of the out-of-stock item is equal to or less than the predetermined ratio, a second screen generation unit that generates an out-of-stock screen in which information indicating the out-of-stock is added to the purchase screen of the out-of-stock product;
Transmitting means for transmitting the purchase screen and the out-of-stock screen to a terminal device connected via the network;
When it is determined by the out-of-stock determination means that the ratio of the out-of-stock item exceeds the predetermined ratio, a purchase screen non-display unit that hides the purchase screen of the out-of-stock item from the terminal device;
Sales support program to make it function.

Images