JP6472206B2 - Product proposal system, product proposal method, and product proposal program - Google Patents

Description

  The present invention relates to a product proposal system, a product proposal method, and a product proposal program.

  A point-of-sales (POS) system is known in which sales results of products sold in stores are aggregated in units of products and customers, and the aggregated data can be used for marketing.

  In the retail industry, products MIX, gross profit MIX, and the like are known as methods for changing the gross profit rate depending on the products sold in the store and ensuring the maximum gross profit rate in the entire store. In recent years, the use of big data has become popular.

  In Japanese Patent Application Laid-Open No. 2007-25841 (Patent Document 1), “In a POS system having a touch panel type terminal for inputting the sales of a product, the terminal displays the product on the basic screen for inputting the sales of the product. A purchaser information display button for instructing the display of purchaser information is displayed, and the sales information of the product can be entered after the purchaser information display button displays the buyer's information on the basic screen. It has been described.

JP 2007-25841 A

  In the conventional method, even a simple receipt analysis (basket analysis) results in an enormous amount of calculation and an order that is virtually impossible. Although various methods have been used to reduce the amount of calculation, uniform methods such as extracting information from special sales have been mainstream and not always effective. Therefore, in the conventional method, there is a problem that it is difficult to formulate a sales plan effective for improving the customer unit price and the gross margin based on the data collected by the POS system.

  An object of the present invention is to provide a technology that makes it possible to formulate a sales plan effective for improving a unit price of a customer and a gross margin based on data collected by a POS system.

  Of the inventions disclosed in the present application, the outline of typical ones will be briefly described as follows.

  One embodiment of the present invention includes a data center and a terminal connected to the data center via a network, and the data center represents a set product that represents a set product sold as a set with a spindle product. It has a total part which acquires an image and the sales performance of the set product. A distribution unit that displays the set sale product selection screen for displaying the set product image acquired by the counting unit and the sales record in a list in association with each other by delivering the set sale product selection screen. Further, the terminal receives an input for selecting a desired set product image from the plurality of set product images displayed in a list.

  In another embodiment, the aggregation unit of the data center acquires a set product image representing a set product to be sold as a set with the main product and a sales result of the set product from the storage unit. Have In addition, the distribution unit of the data center distributes the set sales product selection screen that displays the set product image acquired by the totaling unit and the sales performance of the set product in a list in association with each other. Set sales product selection screen distribution step to be displayed on the screen. The terminal further includes an input step of receiving an input for selecting a desired set product from the plurality of set product images displayed in a list.

  In another embodiment, a product proposal program to be executed by a computer of a data center having a totaling unit, a distribution unit, and a storage unit, wherein the totaling unit is sold as a set with a main product. The computer is caused to execute a set product acquisition step of acquiring a set product image representing a product and a sales result of the set product from the storage unit. In addition, the distribution unit distributes a set sales product selection screen that displays the set product image acquired by the counting unit and the sales results of the set product in a list in association with each other to an external terminal. The product selection screen distribution step is executed by the computer. In addition, the totaling unit, an alternative candidate product image representing an alternative candidate product that is the same type of product as the set product of the set product image that has received an input to be selected by the terminal, and sales results of the alternative candidate product, The alternative candidate product acquisition step of acquiring the item from the storage unit is executed by the computer. In addition, the distribution unit distributes to the terminal an alternative product examination screen that displays the alternative candidate product image acquired by the aggregation unit and the sales results of the alternative candidate product in a list in association with each other. The examination screen distribution step is executed by the computer.

  Among the inventions disclosed in the present application, effects obtained by typical ones will be briefly described as follows.

  According to the representative embodiment of the present invention, it is possible to formulate a sales plan effective for improving the customer unit price and the gross margin based on the data collected by the POS system.

It is a figure which shows the outline | summary of the structural example of the goods proposal system in one embodiment of this invention. It is a figure which shows the outline | summary of the scatter diagram which the collection part in one embodiment of this invention produces | generates. It is a figure which shows the outline | summary of the scatter diagram which the collection part in one embodiment of this invention produces | generates. It is a figure which shows the outline | summary of the customer visit performance table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the customer information management master table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the merchandise management master table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the sales history table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the segment information table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the sales performance information table classified by classification memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the sales performance information table classified by goods memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the set sales performance information table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the shop information master table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the classification master table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the proposal condition table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the proposal master table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the outline | summary of the condition master table memorize | stored in the memory | storage part in one embodiment of this invention. It is a figure which shows the example of the goods selection screen displayed on the terminal in one embodiment of this invention. It is a figure which shows the example of the goods selection screen displayed on the terminal in one embodiment of this invention. It is a figure which shows the example of the goods selection screen displayed on the terminal in one embodiment of this invention. It is a figure which shows the example of the set sales goods selection screen displayed on the terminal in one embodiment of this invention. It is a figure which shows the example of the alternative goods examination screen displayed on the terminal in one embodiment of this invention. It is a figure which shows the example of the set sales goods selection screen displayed on the terminal in one embodiment of this invention. It is a figure which shows the outline | summary of the whole process in one embodiment of this invention. It is a figure which shows the outline | summary of the countermeasure object classification specific process in one embodiment of this invention.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. Note that components having the same function are denoted by the same reference symbols throughout the drawings for describing the embodiment, and the repetitive description thereof will be omitted.

  In the data center of the product proposal system in one embodiment of the present invention (a cloud computing environment that provides services to store terminals and headquarters terminals), the horizontal axis represents the number of times sold, and the vertical axis represents the average sales amount And a scatter diagram (described later, FIG. 2) in which points correspond to customers is generated. In the generated scatter diagram, the area where sales are low despite the concentration of customers is selected as the area that needs countermeasures to improve sales (hereinafter sometimes referred to as countermeasure target segment). To do. As a result, it becomes possible to efficiently select the target segments and to formulate a sales plan effective for improving the customer unit price and the gross margin.

  Further, the data center specifies the category (for example, butter) of the product with the highest sales as the countermeasure target category in the specified area.

  In addition, the data center displays a circle representing the quantity of products sold (for example, XX butter, △△ butter) belonging to the specified countermeasure target category (for example, the larger the quantity sold, the larger the radius of the circle). Is displayed on the terminal of the store and the headquarters. This makes it possible to identify products that are frequently purchased, and to select appropriate products as the target of the product MIX to be countermeasured.

  Thereafter, the terminal of the store and the head office accepts an input for selecting a product with a large quantity sold (a product with a large circle radius) as a main product by referring to the displayed bubble chart.

  Then, the data center displays the selected main product, the set product image representing the set product sold as a set with the main product, and the sales results of the main product and the set product in a list on the terminals of the store and the headquarters. This makes it possible to check the past results of the product MIX. In addition, based on the displayed content, it becomes possible to examine which set product can be replaced to improve the unit price of customers and the gross profit margin. In addition, it becomes possible to combine the main product and the set sales product while confirming the past results, so that the sales strategy can be transmitted to the site.

<System configuration>
FIG. 1 is a diagram showing an outline of a configuration example of a product proposal system according to an embodiment of the present invention. As shown in FIG. 1, the product proposal system includes a data center 100, a headquarters main system 210 of the headquarters 200 connected to the datacenter 100 via a network, a storage unit 220 of the headquarters 200, a datacenter 100, and a network. The terminal 230 of the headquarter 200 connected via the network, the store controller 310 of the store 300 connected via the network to the headquarters backbone system 210, and the store connected to the store controller 310 via the LAN (Local Area Network). 300 POS cash registers 320 and a terminal 330 of a store 300 connected to the data center 100 via a network.

  Further, the data center 100, the headquarters backbone system 210, the terminals 230 and 330, the store controller 310, and the POS register 320 are implemented by predetermined hardware and software. For example, the data center 100, the headquarters backbone system 210, the terminals 230 and 330, the store controller 310, and the POS cash register 320 have a processor, a memory, and the like, and the program on the memory executed by the processor is the data center 100, the headquarters backbone. The computer of the system 210, the terminals 230 and 330, the store controller 310, and the POS register 320 is made to function.

  The POS cash register 320 includes a product code (for example, JAN (Japan Article Number) code) read by a bar code reader (not shown), the price of each product, the total sales price of each product, the purchase time, etc. Output a receipt with information. The POS register 320 also stores the product code, the price of each product, the total sales amount of each product, the purchase time, and personal information (customer ID and customer name) read from the customer card owned by the customer. Etc.) (hereinafter may be referred to as POS data) to the store controller 310.

  The store controller 310 manages information such as a product name, a product code, and a unit price of the product in association with each other. Further, the store controller 310 aggregates the sales results of the products sold at the store based on the POS data input from the POS register 320 in units of products and customers.

  The store controller 310 transmits the collected POS data to the headquarters 200 in association with the store ID for identifying the store.

  The headquarters core system 210 of the headquarters 200 performs various statistical processing based on the POS data transmitted from the store controller 310 of each store 300, thereby making it possible to use the collected POS data for marketing. The headquarters backbone system 210 of the headquarters 200 stores the POS data transmitted from each store 300 in the storage unit 220.

  The headquarters backbone system 210 transmits POS data collected from each store 300 to the data center 100.

  The information collection unit 110 of the data center 100 collects the POS data transmitted from the headquarters 200 and stores the collected POS data in the storage unit 140.

  In the storage unit 140 of the data center 100 and the storage unit 220 of the headquarter 200, a customer visit record table (described later, FIG. 4), a customer information management master table (described later, FIG. 5), and a product management master table (described later, FIG. 6). Sales history table (described later, FIG. 7), segment information table (described later, FIG. 8), classified sales performance information table (described later, FIG. 9), product sales performance information table (described later, FIG. 10), set sales performance Information table (described later, FIG. 11), store information master table (described later, FIG. 12), classification master table (described later, FIG. 13), proposal condition table (described later, FIG. 14), proposal master table (described later, FIG. 15), A condition master table (described later, FIG. 16) is stored.

  The totaling unit 120 of the data center 100 acquires information stored in the storage unit 140 and analyzes the acquired information. Based on the analysis result, the totaling unit 120 acquires a classification code of a product category (hereinafter, sometimes referred to as a countermeasure target category) that requires countermeasures such as price change or replacement from the storage unit 140.

  Hereinafter, with reference to FIG. 2 and FIG. 3, the aggregation unit 120 will explain in detail the process of analyzing the information acquired from the storage unit 140 and the process of acquiring the classification code of the countermeasure target classification based on the analysis result. To do.

  First, the totaling unit 120 generates a scatter diagram 1500 shown in FIG. 2 where the horizontal axis is the number of times sold and the vertical axis is the average sales amount, and performs analysis based on the generated scatter diagram 1500. Each point 1502 included in the scatter diagram 1500 corresponds to one customer.

  The totaling unit 120 searches the segment information table (described later, FIG. 8) stored in the storage unit 140 using the store ID for identifying the store 300 as a key, and finds all the corresponding [segment ID], [money limit] ], [Amount lower limit], [Sales count upper limit], [Sales count lower limit]. Further, the totaling unit 120 searches the customer visit record table (described later, FIG. 4) stored in the storage unit 140 using the store ID as a key, and searches all corresponding [customer ID], [number of sales], [average] [Sales amount].

  Then, the tabulation unit 120 acquires each segment 1501 identified from the [money limit], [money limit], [sales count upper limit], and [sales count lower limit] obtained from the segment information table from the customer visit record table. A scatter diagram 1500 is generated by placing a point 1502 at a coordinate specified from [number of sales] (X coordinate) and [average sales amount] (Y coordinate).

  Next, the totaling unit 120 has a monthly purchase amount equal to or greater than the median value (“30000”, which is the median value of the minimum value “0” and the maximum value “60000” on the vertical axis of the scatter diagram 1500), and All the segments 1501 whose number of purchases is less than the median value (“30” which is the median value of the minimum value “0” and the maximum value “60” on the horizontal axis of the scatter diagram 1500) are extracted. Moreover, the totaling unit 120 extracts all the segments 1501 in which the monthly purchase amount is less than the median and the number of monthly purchases is greater than or equal to the median. The totaling unit 120 extracts all the segments 1501 in which the number of times the customer visits the store 300 is less than a predetermined number (for example, the median) or the average sales amount to the customer is less than the predetermined amount (for example, the median). Anyway.

  Then, as illustrated in FIG. 3, the totaling unit 120 deletes all points 1502 arranged other than the extracted segment 1501 from the scatter diagram 1500. Further, the totaling unit 120 totals the number of points 1502 to be arranged for each extracted segment 1501, and specifies the segment 1503 having the maximum number of points 1502 to be arranged. As a result, the countermeasure target segment 1503 is specified.

  Next, the tabulation unit 120 searches the classified sales performance information table (described later, FIG. 9) using the segment ID of the identified countermeasure target segment 1503 as a key, so that the sales with the largest sales in the segment 1503 are classified. Get classification code. Thereby, the classification code of the countermeasure target classification is acquired. The aggregation unit 120 inputs the acquired classification code of the countermeasure target classification to the distribution unit 130.

  In addition, the totaling unit 120 may store either the sales or the gross margin when the store 300 has less than the number of monthly purchases (for example, median) or the average sales amount to the customer is less than a predetermined amount (for example, the median). However, the classification code with the highest classification may be selected and acquired as the classification code for the countermeasure target classification.

  Refer to FIG. 1 again. The distribution unit 130 is a product (for example, “XX butter” or “ΔΔ butter”) belonging to the classification code (for example, JICFS classification code) of the countermeasure target classification (for example, “butter”) input from the totaling unit 120. A product selection screen (to be described later, FIG. 17 and FIG. 19) on which a bubble chart in which a circle representing the quantity sold is displayed is distributed to the terminal 230 of the headquarters 200 or the terminal 330 of the store 300 to be displayed. Terminals 230 and 330 are tablet terminals having a touch panel, and accept a touch operation from a user. Specifically, the terminals 230 and 330 detect a touch operation on the screen display area, and execute a process corresponding to the position where the touch operation is received.

  Terminals 230 and 330 accept input for selecting a circle from the circles arranged in the bubble chart. When the terminals 230 and 330 receive an input for selecting a circle corresponding to a product whose quantity sold is less than a predetermined number, the counting unit 120 is identified from the selling price and the gross margin of the received product. The content of the proposal stored in advance (for example, the content of the proposal for increasing the amount sold) is acquired from the storage unit 140, and the acquired content of the proposal is input to the distribution unit 130. The distribution unit 130 displays a product selection screen (to be described later, FIG. 18) that displays the proposal content acquired by the totaling unit 120 by distributing it to the terminals 230 and 330.

  On the other hand, when the terminals 230 and 330 accept an input for selecting a circle corresponding to a product whose quantity sold is a predetermined number or more, the counting unit 120 selects a product corresponding to the accepted circle as a main product. . Then, the aggregation unit 120 acquires the product code of the selected main product from the storage unit 140 and inputs the acquired product code to the distribution unit 130. In addition, the totaling unit 120 may extract the product with the highest sales from the products belonging to the classification code of the countermeasure target classification, and may select the extracted products as the main products.

  The distribution unit 130 displays the main product image representing the main product selected by the aggregation unit 120, the set product image representing the set product sold as a set with the main product, and the sales results of the set product in a list. The set sales product selection screen (to be described later, FIG. 20) to be displayed is delivered to the terminals 230 and 330.

  The terminals 230 and 330 receive an input for selecting a desired set product image from the set product images displayed in the list. Thereby, a set product is selected.

  The aggregation unit 120 acquires an alternative candidate product image representing an alternative candidate product that is the same type of product as the set product of the set product image that has received the input selected by the terminals 230 and 330, and the sales results of the alternative candidate product. . Then, the aggregation unit 120 inputs the acquired alternative candidate product image and the sales results of the alternative candidate product to the distribution unit 130.

  The distribution unit 130 distributes to the terminals 230 and 330 an alternative product examination screen (described later, FIG. 21) that displays the alternative candidate product images acquired by the tabulation unit 120 and the sales results of the alternative candidate products in association with each other. To display.

  By accepting an input for selecting a desired alternative candidate product from a plurality of alternative candidate product images displayed by the terminals 230 and 330 in a list, the alternative candidate product of the alternative candidate product image that has received the input is a set sale product selection screen. Is set as a new set product in place of the set product of the set product image that has received the input.

<Customer visit results table>
FIG. 4 is a diagram showing an overview of the customer visit record table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 4, the customer visit record table is composed of data items such as [customer ID], [store ID], [number of sales], [average sales amount], [year and month].

  [Customer ID] indicates a code for identifying a customer. [Store ID] indicates a code for identifying a store. [Number of sales] indicates the number of times the customer has visited the store in a predetermined period (for example, one month). [Monthly sales amount] indicates an average amount sold by a customer in one purchase in a predetermined period (for example, one month). [Year / month] indicates the year / month of the corresponding period.

<Customer information management master table>
FIG. 5 is a diagram showing an overview of the customer information management master table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 5, the customer information management master table includes data items such as [customer ID] and [name].

  [Name] indicates the name of the customer.

<Product management master table>
FIG. 6 is a diagram showing an outline of the product management master table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 6, the merchandise management master table includes data items such as [product code] and [product name].

  [Product code] indicates a code for identifying a product. [Product code] is, for example, a JAN code. [Product Name] indicates the name of the product.

<Sales history table>
FIG. 7 is a diagram showing an overview of the sales history table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 7, the sales history table includes data items such as [customer ID], [store ID], [product code], [purchase date], and [purchase time].

  [Purchase Date] indicates the date on which the product was purchased. [Purchase time] indicates the time when the product is purchased.

<Segment information table>
FIG. 8 is a diagram showing an outline of the segment information table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 8, the segment information table is composed of data items such as [Store ID], [Segment ID], [Money amount upper limit], [Money amount lower limit], [Sales frequency upper limit], and [Sales frequency lower limit]. Is done.

  [Segment ID] indicates a code for identifying a segment. [Money amount upper limit], [Money amount lower limit], [Sales frequency upper limit], and [Sales frequency lower limit] indicate values for specifying the segment range.

<Sales results information table by category>
FIG. 9 is a diagram showing an overview of the classified sales result information table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 9, the sales information information table classified by classification includes [Store ID], [Segment ID], [Classification Code], [Sales], [Number of Customers], [PI (Purchase Index) Amount], [ It consists of data items such as [Month].

  [Classification code] indicates a code for identifying the category to which the product belongs. [Sales] indicates the total sales of products belonging to the corresponding category. [Number of customers] indicates the number of customers who sold products belonging to the corresponding category. [PI Amount] indicates the average amount of the product sold with respect to the total number of customers who passed the cash register.

<Sales results information table by product>
FIG. 10 is a diagram showing an outline of the sales result information table for each product stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 10, the sales result information table for each product includes [Store ID], [Classification Code], [Product Code], [Gross Margin], [Sales Price], [Quantity], [Sales], [Rough [Rate], [Sales Price Deviation Value], [Gross Margin Deviation Value], [PI Quantity], [PI Amount], [Unit Price], [PI Gross Margin], [Year Month], [PI Gross Margin], etc. It consists of data items.

  [Gross margin] indicates the ratio of gross profit to the sales of the product specified by the product code. [Selling price] indicates the selling price of the product specified from the product code. [Quantity] indicates the quantity of the product specified from the product code. [Sales] indicates the amount of sales. [Gross profit] indicates the total gross profit of the product specified from the product code. Specifically, [Gross profit] is calculated by multiplying [Selling price], [Quantity] and [Gross margin], or [Selling price] minus [Cost]. It is calculated by multiplying. [Sales Price Deviation Value] indicates a standard deviation value of [Selling Price] at which a product specified from the product code is sold at a store. [Gross margin deviation value] indicates a standard deviation value of [gross margin] at which the product specified from the product code is sold at the store. [PI quantity] indicates an average quantity of products sold to customers who have passed the cash register. [Original unit price] indicates the cost of the product specified from the product code. [PI Gross Margin] indicates the average gross margin at which products are sold to customers who have passed the cash register. [PI gross margin] indicates the ratio of [PI gross margin] to [PI amount] of the product.

<Set sales results information table>
FIG. 11 is a diagram showing an outline of the set sales record information table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 11, the set sales record information table includes data items such as [store ID], [classification code], [product code], [product code 2] to [product code 5], and [year / month]. Consists of. [Product code 2] to [Product code 5] indicate codes for specifying the product specified by the product code and the product sold as a set.

<Store information master table>
FIG. 12 is a diagram showing an outline of the store information master table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 12, the store information master table includes data items such as [store ID], [store name], [address], [name of representative], [TEL], and [FAX].

  [Store name] indicates the name of the store. [Address] indicates the location of the store. [Representative Name] indicates the name of the representative. [TEL] indicates the telephone number of the store. [FAX] indicates the FAX number of the store.

<Classification master table>
FIG. 13 is a diagram showing an overview of the classification master table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 13, the classification master table includes data items such as [classification code], [major classification], [medium classification], and [small classification].

  [Major category], [Medium category], and [Small category] indicate the type of category to which the product belongs.

<Proposed condition table>
FIG. 14 is a diagram showing an outline of the proposal condition table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 14, the proposal condition table includes data items such as [Condition ID] and [Proposal ID].

  [Condition ID] indicates a code for identifying [Condition] (described later, FIG. 16). [Proposal ID] indicates a code for identifying [Proposal Content] (described later in FIG. 15).

<Proposal master table>
FIG. 15 is a diagram showing an outline of the proposal master table stored in the storage units 140 and 220 according to the embodiment of the present invention. As shown in FIG. 15, the proposal master table includes data items such as [suggest ID] and [suggested contents].

  [Proposal Content] indicates the content of the proposal for increasing the sales of the store and the quantity of products purchased.

<Condition master table>
FIG. 16 is a diagram showing an outline of the condition master table stored in the storage units 140 and 220 according to the embodiment of the present invention. The condition master table includes conditions for specifying store sales and proposal contents for increasing the quantity of merchandise purchased. As shown in FIG. 16, the condition master table includes data items such as [condition ID] and [condition].

  [Condition] indicates a condition corresponding to the condition ID. Specifically, “the selling price is lower than the average in the classification and the gross margin is lower than the average in the average classification, and the sales quantity is less than 10”.

<Product selection screen>
FIGS. 17-19 is a figure which shows the example of the goods selection screen displayed on the terminals 230 and 330 in one embodiment of this invention. As shown in FIGS. 17 to 19, a graph (for example, a bubble chart 1701) is displayed on the product selection screen, in which the vertical axis is the standard deviation value of the gross profit rate and the horizontal axis is the standard deviation value of the selling price.

  The bubble chart 1701 indicates the quantity sold (for example, “XX butter” or “△△ butter”) belonging to the classification code of the countermeasure target classification (for example, “product butter”) (the quantity sold is large). A plurality of figures (for example, a circle 1702) are arranged so that the radius of the circle increases. For example, as shown in FIG. 17, when a circle 1702 corresponding to a product whose quantity sold is less than a predetermined number is received (for example, a touch operation) on the product selection screen, the terminals 230 and 330 are displayed in FIG. The product selection screen shown in is displayed. Then, on the product selection screen shown in FIG. 18, proposal contents 1703 for increasing the quantity that the product corresponding to the accepted circle 1702 can be sold are displayed.

  On the other hand, as shown in FIG. 19, when a circle 1702 corresponding to a product whose sold quantity is a predetermined number or more receives an input, a screen displayed on the terminals 230 and 330 is a set sales product selection screen (described later, FIG. 20).

  Note that the display mode of the graphic may be changed according to the quantity sold.

<Set product selection screen>
FIG. 20 is a diagram showing an example of a set sale product selection screen displayed on the terminals 230 and 330 according to the embodiment of the present invention. As shown in FIG. 20, the set sales product selection screen includes a priority product image 2001 representing a product (hereinafter also referred to as a priority product) that has been input on the product selection screen (described above, FIG. 19). A set product image 2002 representing the priority product and a product sold as a set (hereinafter may be referred to as a set product), and the sales result 2003 of the priority product and each set product are displayed.

  The sales record 2003 includes information such as the PI quantity, the PI amount, the selling price, the unit price, the PI gross profit, and the PI gross profit rate corresponding to the priority product and the set product.

  When any set product image 2002 receives an input (for example, touch operation), the screen displayed on the terminals 230 and 330 is switched to an alternative product review screen (described later, FIG. 21).

  After that, by selecting an alternative product on the alternative product examination screen shown in FIG. 21, the set product image 2002 selected on the set sale product selection screen of FIG. 20 is selected on the alternative product examination screen. The set product image 2002 of the substitute product is changed.

<Substitute product review screen>
FIG. 21 is a diagram showing an example of an alternative product review screen displayed on the terminals 230 and 330 according to the embodiment of the present invention. As shown in FIG. 21, the substitute product review screen includes a set product image 2101 representing a set product that has been input on the set sale product selection screen (described above, FIG. 20), and each product that is a candidate for the substitute product. A sales result display area 2102 in which the sales results are displayed, a sales order sort button 2103, a gross margin order sort button 2104, and an original unit price order sort button 2105 are displayed.

  In the sales performance display area 2102, the product name, the selling price, the sales, and the gross margin of the products that are candidates for the substitute product are displayed side by side from the top to the bottom for each product.

  When the sales order sort button 2103 receives an input (for example, touch operation), the products displayed in the sales performance display area 2102 are sorted in the order of sales.

  When the gross profit order sorting button 2104 accepts input, the products displayed in the sales performance display area 2102 are sorted in descending order of gross profit.

  When the original unit price order sort button 2105 receives an input, the products displayed in the sales performance display area 2102 are sorted in the order of the original unit price.

  FIG. 22 shows a screen displayed on the terminals 230 and 330 when an alternative product is selected by accepting input of any of the product name, selling price, sales, and gross margin of the product displayed in the sales performance display area 2102. Switch to the set sales product selection screen.

<Overall processing>
FIG. 23 is a diagram showing an overview of the overall processing in one embodiment of the present invention.

  First, in S2301, the terminal 230 of the headquarters 200 or the terminal 330 of the store 300 transmits the store ID of the store 300 to the data center 100.

  Next, in S2302, the data center 100 receives the store ID transmitted in S2301.

  Next, in S2303, the totaling unit 120 of the data center 100 executes countermeasure target classification specifying processing (described later, FIG. 24). Thereby, the totaling unit 120 acquires the classification code of the countermeasure target classification based on the store ID received in S2302. The aggregation unit 120 inputs the acquired classification code of the countermeasure target classification to the distribution unit 130.

  Next, in S2304, the distribution unit 130 of the data center 100 distributes the product selection screen (described above, FIGS. 17 and 19) based on the classification code of the countermeasure target classification acquired in S2303 to the terminals 230 and 330. To display.

  Next, in S2305, the terminals 230 and 330 determine whether any of the circles 1702 arranged on the bubble chart 1701 has received an input (for example, a touch operation). In S2305, when the terminals 230 and 330 determine that the circle 1702 has not received an input (No in S2305), the process proceeds to S2305. On the other hand, if the terminals 230 and 330 determine in S2305 that the circle 1702 has received an input (Yes in S2305), the process proceeds to S2306.

  Next, in S2306, the aggregation unit 120 of the data center 100 searches the sales result information table for each product (described above, FIG. 10) using the product ID of the product corresponding to the circle 1702 received in S2305 as a key. Then, the corresponding quantity, selling price, gross profit rate, selling price deviation value, and gross profit high deviation value are acquired.

  Next, in S2307, the aggregation unit 120 of the data center 100 determines whether the quantity acquired in S2306 is less than a predetermined number. In S2307, when the counting unit 120 determines that the quantity acquired in S2306 is not less than the predetermined number (S2307—No), the process proceeds to S2312. On the other hand, if the counting unit 120 determines in S2307 that the quantity acquired in S2306 is less than the predetermined number (S2307-Yes), the process proceeds to S2308.

  Next, in S2308, the aggregation unit 120 of the data center 100 analyzes whether the selling price deviation value acquired in S2306 and the gross profit deviation value are less than 50.

  Next, in S2309, the aggregation unit 120 of the data center 100 acquires the corresponding condition ID from the condition master table (described above, FIG. 16) based on the result analyzed in S2308.

  Next, in S2310, the aggregation unit 120 of the data center 100 searches the proposal condition table (described above, FIG. 14) using the condition ID acquired in S2309 as a key, and acquires the corresponding proposal ID. Further, the aggregation unit 120 of the data center 100 searches the proposal master table (described above, FIG. 15) using the acquired proposal ID as a key, and acquires the corresponding proposal content.

  Next, in S2311, the distribution unit 130 of the data center 100 displays the product selection screen (described above, FIG. 18) including the proposal content acquired in S2310 by distributing it to the terminals 230 and 330. After the process of S2311, the process returns to S2305.

  If NO in S2307, in S2312, the totaling unit 120 of the data center 100 uses the product ID of the product corresponding to the circle 1702 accepted in S2305 as a key, as a set sales record information table (described above, FIG. 11) is searched and the corresponding product code (for example, product code 2 to product code 5) is acquired. Thereby, the totaling unit 120 acquires the main product and the product code of the set product sold as a set. The aggregation unit 120 inputs each acquired product code to the distribution unit 130.

  Next, in S2313, the aggregation unit 120 of the data center 100 searches the sales result information table for each product (described above, FIG. 10) using the product ID of the product corresponding to the circle 1702 received in S2305 as a key. Then, the corresponding PI quantity, PI amount, selling price, original unit price, PI gross margin, and PI gross margin are acquired. The totaling unit 120 also inputs the acquired PI quantity, PI amount, selling price, original unit price, PI gross profit, and PI gross profit rate to the distribution unit 130.

  Next, in S2314, the distribution unit 130 of the data center 100 displays the set sales product selection screen (described above, FIG. 20) based on the information input in S2313 by distributing it to the terminals 230 and 330. Specifically, the distribution unit 130 causes the terminals 230 and 330 to display the product image of the product corresponding to the circle 1702 received in S2305 as the priority product image 2001 in FIG. Further, the distribution unit 130 causes the terminals 230 and 330 to display the product image corresponding to the main product and the product code of the set product sold as a set input in S2312, as the set product image 2002 in FIG. Further, the distribution unit 130 causes the terminals 230 and 330 to display the PI quantity, the PI amount, the selling price, the original unit price, the PI gross profit, and the PI gross profit rate acquired in S2313 as sales results 2003. When the terminal 230 or 330 receives an input for selecting any one of the set product images 2002, the process proceeds to S2315.

  Next, in S2315, the totaling unit 120 of the data center 100 uses the classification code (for example, the classification code of the small classification) corresponding to the set product image 2002 selected in S2314 as a key to the sales result information table for each product ( As described above, FIG. 10) is searched, and the corresponding product code, selling price, sales, and gross profit rate are acquired. The aggregation unit 120 inputs the acquired product code, selling price, sales, and gross profit margin to the distribution unit 130. Thereby, the totaling unit 120 acquires a substitute product for the set product selected in S2314.

  Next, in S2316, the distribution unit 130 of the data center 100 displays an alternative product examination screen (described above, FIG. 21) based on each information input in S2315 by distributing it to the terminals 230 and 330. Specifically, the distribution unit 130 causes the terminals 230 and 330 to display the set product image 2002 selected in step S2315. In addition, the distribution unit 130 causes the terminals 230 and 330 to display the product code, the selling price, the sales, and the gross margin input in S2315 as the sales performance display area 2102. When an alternative product is selected by accepting input of any of the product name, selling price, sales, and gross margin of the product displayed in the sales result display area 2102 of the alternative product review screen, the process proceeds to S2317.

  Next, in S2317, the distribution unit 130 of the data center 100 distributes a set sales product selection screen (described above, FIG. 22) displaying the set product image 2002 of the alternative product selected in S2316 to the terminals 230 and 330. To display. In addition, the totaling unit 120 uses the product code of the set product selected in S2314 in the set sales record information table (described above, FIG. 11) stored in the storage unit 140 as the substitute product selected in S2316. Update to product code.

<Countermeasure target classification processing>
FIG. 24 is a diagram showing an outline of the countermeasure target classification specifying process in one embodiment of the present invention.

  First, in S2401, the totaling unit 120 searches the segment information table (described above, FIG. 8) stored in the storage unit 140 using the store ID received in S2302 as a key, and searches all corresponding [segment IDs]. , [Amount upper limit], [Amount lower limit], [Sales count upper limit], [Sales count lower limit] are acquired.

  Next, in S2402, the totaling unit 120 searches the customer visit record table (described above, FIG. 4) stored in the storage unit 140 using the store ID received in S2302 as a key, and selects all corresponding [customers [ID], [Store ID], [Number of Sales], [Average Sales Amount] are acquired.

  Next, in S2403, the tabulation unit 120 stores a customer visit to each segment 1501 identified from [amount upper limit], [amount lower limit], [sales count upper limit], and [sales count lower limit] acquired from the segment information table. A scatter diagram 1500 is generated by arranging points 1502 at coordinates specified from the [number of sales] (X coordinate) and [average sales amount] (Y coordinate) acquired from the result table.

  In step S <b> 2404, the counting unit 120 extracts all the segments 1501 whose monthly purchase amount is equal to or greater than the median value and whose monthly purchase count is less than the median value. Moreover, the totaling unit 120 extracts all the segments 1501 in which the monthly purchase amount is less than the median and the number of monthly purchases is greater than or equal to the median.

  In step S <b> 2405, the tabulation unit 120 deletes all points 1502 arranged other than the extracted segment 1501 from the scatter diagram 1500.

  In step S <b> 2406, the totaling unit 120 totals the number of points 1502 to be arranged for each extracted segment 1501, and specifies the segment 1503 having the maximum number of points 1502 to be arranged. As a result, the counting unit 120 specifies the countermeasure target segment 1503.

  Next, in S2407, the tabulation unit 120 searches the classified sales result information table (described above, FIG. 9) using the segment ID of the identified countermeasure target segment 1503 as a key, so that the sales in the segment 1503 can be determined. Get the classification code of the largest classification. Thereby, the classification code of the countermeasure target classification is acquired.

<Effects of the present embodiment>
According to the product proposal system in the present embodiment described above, a set sales product selection screen that displays a list of set product images 2002 and sales results 2003 in association with each other is distributed to the terminals 230 and 330 in the past. It is possible to combine the main axis product and the set sales product while confirming the results, and to transmit the sales strategy to the site. In addition, the past performance of the product MIX can be confirmed.

  Also, by distributing an alternative product examination screen that displays the alternative candidate product image and the sales results of the alternative candidate product image in a list to the terminals 230 and 330, which set product is based on the displayed contents. By replacing, it will be possible to consider whether the unit price of customers and the gross margin can be improved.

  In addition, by displaying a product selection screen on which a graph in which a graphic representing the quantity of products sold is displayed is displayed on the terminals 230 and 330, it becomes possible to identify products that are frequently purchased, and take measures. An appropriate product can be accurately selected as a target of the product MIX.

  Furthermore, by referring to the displayed graph, it is possible to select a product with a large quantity sold as the main product.

  By selecting the category with the highest number of sales or gross margin as the number of times the customer visits the store 300 is less than the predetermined number or the average sales amount to the customer is less than the predetermined amount, The target classification can be efficiently identified, and a sales plan effective for improving the customer unit price and the gross margin can be formulated.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  For example, the terminals 230 and 330 include all terminals of various forms such as smartphones in addition to the tablet terminals.

DESCRIPTION OF SYMBOLS 100 ... Data center, 110 ... Information collection part, 120 ... Aggregation part, 130 ... Distribution part, 140 ... Storage part,
200 ... headquarters, 210 ... headquarters backbone system, 220 ... storage unit, 230 ... terminal,
300 ... Store, 310 ... Store controller, 320 ... POS cash register, 330 ... Terminal,
1701 ... Bubble chart, 1702 ... Yen, 1703 ... Suggested content,
2001 ... Important product image, 2002 ... Set product image, 2003 ... Sales results,
2101 ... Set product image, 2102 ... Sales performance display area, 2103 ... Sales order sort button, 2104 ... Gross profit order sort button, 2105 ... Original unit price order sort button.

Claims (9)

A data center, and a terminal connected to the data center via a network,
The data center is
A totaling unit for acquiring a set product image representing a set product sold as a main product and a set product, and a sales result of the set product;
A distribution unit that displays on the terminal by distributing a set sales product selection screen that displays the list in association with the set product image acquired by the counting unit and the sales record;
Have
The terminal receives an input to select a desired set product image from the plurality of set product images displayed in a list,
The distribution unit causes the terminal to display a product selection screen on which a graph on which a graphic representing the quantity of products sold is displayed,
The terminal receives an input for selecting a desired graphic from a plurality of the graphic arranged in the graph,
When the input of the graphic corresponding to the product whose quantity sold is a predetermined number or more is received from the terminal, the counting unit selects the product corresponding to the graphic as the main product,
The distribution unit includes a main product image representing the main product selected by the aggregation unit, the set product image representing the set product sold as a set with the main product, and the sales results of the set product. A product proposal system for displaying on the terminal by distributing the set sales product selection screen displayed in a list in association with each other. A data center, and a terminal connected to the data center via a network,
The data center is
A totaling unit for acquiring a set product image representing a set product sold as a main product and a set product, and a sales result of the set product;
A distribution unit that displays on the terminal by distributing a set sales product selection screen that displays the list in association with the set product image acquired by the counting unit and the sales record;
Have
The terminal receives an input to select a desired set product image from the plurality of set product images displayed in a list,
The distribution unit causes the terminal to display a product selection screen on which a graph on which a graphic representing the quantity of products sold is displayed,
The terminal receives an input for selecting a desired graphic from a plurality of the graphic arranged in the graph,
When receiving the input of the graphic corresponding to the product whose quantity sold is less than a predetermined number from the terminal, the totaling unit stores the proposal content specified from the selling price and the gross margin of the product corresponding to the graphic Obtained from the department,
The distribution unit is caused to display on the terminal by distributing the product selection screen displaying the proposal content acquired by the aggregation unit.
Product proposal system. A data center, and a terminal connected to the data center via a network,
The data center is
A totaling unit for acquiring a set product image representing a set product sold as a main product and a set product, and a sales result of the set product;
A distribution unit that displays on the terminal by distributing a set sales product selection screen that displays the list in association with the set product image acquired by the counting unit and the sales record;
Have
The terminal receives an input to select a desired set product image from the plurality of set product images displayed in a list,
The distribution unit causes the terminal to display a product selection screen on which a graph on which a graphic representing the quantity of products sold is displayed,
The terminal receives an input for selecting a desired graphic from a plurality of the graphic arranged in the graph,
The aggregating unit selects, as a countermeasure target category, a category in which a customer visits a store less than a predetermined number of times or an average sales amount to the customer is less than a predetermined amount and either sales or gross margin is the highest And
The distribution unit causes the terminal to display by distributing the product selection screen on which the graph in which the graphic representing the quantity sold of the product belonging to the countermeasure target classification is displayed is displayed.
Product proposal system. A set product acquisition step in which the aggregation unit of the data center acquires a set product image representing a set product sold as a set with the main product and a sales result of the set product from the storage unit;
The distribution unit of the data center displays on the terminal by distributing a set sales product selection screen that displays the set product image acquired by the totaling unit and the sales performance of the set product in a list in association with each other A set sales product selection screen distribution step to be performed;
An input step for receiving an input for selecting the desired set product from the set product images displayed in a list by the terminal;
Have
In the set sale product selection screen distribution step, a product selection screen on which a graph in which a graphic representing the quantity sold is displayed is displayed on the terminal.
  In the input step, an input for selecting a desired graphic from a plurality of the graphic arranged in the graph is received,
In the set product acquisition step, when an input of the graphic corresponding to the product whose quantity sold is a predetermined number or more is received from the terminal, the product corresponding to the graphic is selected as the main product,
In the set sales product selection screen distribution step, a main product image representing the main product selected in the set product acquisition step, the set product image representing the set product sold as a set with the main product, and the set A product proposal method in which the terminal is displayed by distributing the set sales product selection screen that displays the sales results of products in a list in association with each other. A set product acquisition step in which the aggregation unit of the data center acquires a set product image representing a set product sold as a set with the main product and a sales result of the set product from the storage unit;
The distribution unit of the data center displays on the terminal by distributing a set sales product selection screen that displays the set product image acquired by the totaling unit and the sales performance of the set product in a list in association with each other A set sales product selection screen distribution step to be performed;
An input step for receiving an input for selecting the desired set product from the set product images displayed in a list by the terminal;
Have
In the set sale product selection screen distribution step, a product selection screen on which a graph in which a graphic representing the quantity sold is displayed is displayed on the terminal.
In the input step, an input for selecting a desired graphic from a plurality of the graphic arranged in the graph is received,
In the set product acquisition step, when the input of the graphic corresponding to the product whose quantity sold is less than a predetermined number is received from the terminal, the proposal content specified from the selling price and the gross margin of the product corresponding to the graphic From the storage unit,
In the set sale product selection screen distribution step, a product proposal method is displayed on the terminal by distributing the product selection screen that displays the proposal content acquired in the set product acquisition step. A set product acquisition step in which the aggregation unit of the data center acquires a set product image representing a set product sold as a set with the main product and a sales result of the set product from the storage unit;
The distribution unit of the data center displays on the terminal by distributing a set sales product selection screen that displays the set product image acquired by the totaling unit and the sales performance of the set product in a list in association with each other A set sales product selection screen distribution step to be performed;
An input step for receiving an input for selecting the desired set product from the set product images displayed in a list by the terminal;
Have
In the set sale product selection screen distribution step, a product selection screen on which a graph in which a graphic representing the quantity sold is displayed is displayed on the terminal.
In the input step, an input for selecting a desired graphic from a plurality of the graphic arranged in the graph is received,
In the set product acquisition step, the number of times the customer visits the store is less than the predetermined number or the average sales amount to the customer is less than the predetermined amount, and either the sales or the gross margin is the highest classification, the countermeasure target classification Selected as
In the set sale product selection screen distribution step, the product selection screen on which the graph in which the graphic representing the quantity sold of the product belonging to the countermeasure target classification is arranged is displayed is displayed on the terminal. , Product proposal method. A product proposal program to be executed by a data center computer having a counting unit, a distribution unit, and a storage unit,
A set product acquisition step for acquiring from the storage unit a set product image representing a set product sold as a main product and a set product, and a sales record of the set product;
Set sales product selection for delivering to the external terminal a set sales product selection screen in which the distribution unit associates and displays the set product image acquired by the tabulation unit and the sales performance of the set product in a list A screen distribution step;
To the computer,
In the set sale product selection screen distribution step, a product selection screen on which a graph in which a graphic representing the quantity sold is displayed is displayed on the terminal.
In the set product acquisition step, when an input of the graphic corresponding to the product whose quantity sold is a predetermined number or more is received from the terminal, the product corresponding to the graphic is selected as the main product,
In the set sales product selection screen distribution step, a main product image representing the main product selected in the set product acquisition step, the set product image representing the set product sold as a set with the main product, and the set A product proposal program for displaying on the terminal by distributing the set sales product selection screen that displays the sales results of products in a list in association with each other. A product proposal program to be executed by a data center computer having a counting unit, a distribution unit, and a storage unit,
A set product acquisition step for acquiring from the storage unit a set product image representing a set product sold as a main product and a set product, and a sales record of the set product;
Set sales product selection for delivering to the external terminal a set sales product selection screen in which the distribution unit associates and displays the set product image acquired by the tabulation unit and the sales performance of the set product in a list A screen distribution step;
To the computer,
In the set sale product selection screen distribution step, a product selection screen on which a graph in which a graphic representing the quantity sold is displayed is displayed on the terminal.
In the set product acquisition step, when the input of the graphic corresponding to the product whose quantity sold is less than a predetermined number is received from the terminal, the proposal content specified from the selling price and the gross margin of the product corresponding to the graphic From the storage unit,
In the set sales product selection screen distribution step, a product proposal program is displayed on the terminal by distributing the product selection screen that displays the proposal content acquired in the set product acquisition step. A product proposal program to be executed by a data center computer having a counting unit, a distribution unit, and a storage unit,
A set product acquisition step for acquiring from the storage unit a set product image representing a set product sold as a main product and a set product, and a sales record of the set product;
Set sales product selection for delivering to the external terminal a set sales product selection screen in which the distribution unit associates and displays the set product image acquired by the tabulation unit and the sales performance of the set product in a list A screen distribution step;
To the computer,
In the set sale product selection screen distribution step, a product selection screen on which a graph in which a graphic representing the quantity sold is displayed is displayed on the terminal.
In the set product acquisition step, the number of times the customer visits the store is less than the predetermined number or the average sales amount to the customer is less than the predetermined amount, and either the sales or the gross margin is the highest classification, the countermeasure target classification Selected as
In the set sale product selection screen distribution step, the product selection screen on which the graph in which the graphic representing the quantity sold of the product belonging to the countermeasure target classification is arranged is displayed is displayed on the terminal. , Product proposal program.

Images