JP2008003651A - Product service information providing program and apparatus - Google Patents

Abstract

[Object] An object of the present invention is to provide a product service information providing program, method, and apparatus capable of grasping a customer's desire to purchase and providing service information of a product that makes a profit as a whole store. To do.
[Configuration] Based on the information stored in the storage means on the computer that can communicate with the customer's cart device, the planned inventory quantity that is obtained by subtracting the planned purchase quantity from the inventory quantity is the planned sales quantity from the total sales plan to the present. Calculating the excess inventory number exceeding the expected excess inventory allowable ratio of the remaining sales plan remaining by subtracting the number, and setting the corresponding number of products as a service target, and the customer's cart device without information on the purchase schedule of the product And notifying the service content of the product.
[Selection] Figure 1

Description

  The present invention relates to a product service information providing program, method and apparatus for providing product service information.

  In order to increase the digestion rate of products that you want to sell consciously in the store, analyze the products you want to sell consciously in the store, and each customer is suitable for products that the customer intends to purchase (in the shopping cart) Provide real-time product information centered on products that you want to sell consciously in stores, along with discount information and information on the coupon target products you have, and output a menu that suggests based on the product information of your shopping cart The technology that ranks the proposed menu based on the sum of the discount rates of the products that make up the proposed menu and raises the display priority of the menu that increases the number of products that are about to be sold consciously in stores is disclosed. (Patent Document 1).

  In addition, in order to automatically distribute promotional content based on POS sales data, sales trends are analyzed from sales information received from POS, and sales events are expected to be unsold by a predetermined date based on the sales trend data. Select and send a product sale), analyze sales data, and forecast the future sales volume by taking into account the time of day, day of the week, events around the store, etc. A technique for performing a sales volume simulation when an event is executed with reference to past data is disclosed (Patent Document 2).

  Furthermore, for the purpose of efficiently selling out the desired products to be sold out, the relationship between the time and the stock quantity is displayed for each food category, with the horizontal axis representing the time and the vertical axis representing the stock quantity. Product sales peak or the relationship between the day of the week and the stock reduction rate, the relationship between the weather and the forecast for tomorrow's forecast, the relationship between the sales rate and the discount rate for each food category, and the correlation between the discount and the start time The technique which can analyze etc. is also disclosed (patent document 3).

However, with the techniques according to these known documents, it is not possible to grasp the customer's purchase desires and provide service information of products that can produce profits as a whole store.
JP-A-11-35355 JP 2002-92455 A JP 2005-258620 A

  The present invention is an invention made in view of the above-described problems of the background art, and is product information that makes it possible to provide service information of a product that makes a profit as a whole store by grasping the purchase desire of the customer It is an object to provide a providing program, method and apparatus.

  In order to solve the above-mentioned problem, the invention according to claim 1 of the present invention is a computer communicable with a cart device of a customer, stored in a storage means, the number of stocks for each product in a predetermined sales calculation period, Based on the planned purchase number, planned sales number, and expected excess inventory tolerance input from the customer's cart device, the planned stock number obtained by subtracting the planned purchase number from the stock number is the sales from the planned total sales to the current time. Service setting process that calculates the excess inventory exceeding the expected excess inventory allowance for products that do not satisfy the expected excess inventory allowance for the remaining sales plan after subtracting the planned number, and sets that number of products as a service target And the service setting processing step based on the information on the purchase schedule and the service content of the product for each customer in a predetermined sales calculation period, which is further stored in the storage means. And a service providing step of notifying the service contents of the quotient goods to the customer of the cart apparatus without the information of the purchase plans of products that are set as the scan target, that is the execution and features.

  According to the first aspect of the present invention, by causing the computer to execute each of the above steps, only a predetermined number of products less than the sales plan remaining number of the current date and time for each product are serviced, Service information can be selectively sent to customers who do not plan to purchase this product, so all products can be serviced, and all customers, including customers who are willing to purchase regardless of the availability of services, will be notified of service. In addition, it is possible to provide service information of a product that has a high possibility of obtaining a gross profit, in other words, profitable as a whole store.

  FIG. 1 shows a system configuration schematic diagram of an embodiment of the present invention.

  A product tag 10 shown in FIG. 1 includes a product ID 111, a product name 112, a production date 113, a date 114, a price 115, a service flag, etc. for uniquely identifying a product as shown in FIG. Price for storage means 11 for storing information such as information record 11r, communication control means 12 for controlling transmission / reception of information wirelessly with other devices such as store device 50 via wireless antenna 121, and price for display 131 The tag is affixed to an individual product with a semiconductor integrated circuit known as an RFID tag or an IC tag, which includes an output control unit 13 for controlling the output of information stored in the storage unit 11.

  In the present embodiment, when a service flag is set in the product information record 11r of the storage unit 11, the output control unit 12 changes the display color or blinks the display via the display 131. It is assumed that output control is performed so that it can be perceived.

  The location tag 20 stores information such as a location information record 21r including coordinates 211 that uniquely identify a location in an area such as a store where the system of this embodiment is introduced as shown in FIG. With a semiconductor integrated circuit known as an RFID tag, an IC tag, etc., comprising means 21 and communication control means 22 for controlling the wireless transmission of information to other devices such as cart device 40 via wireless antenna 221 It is a tag.

  The customer ID storage medium 30 includes storage means 31 and the like for storing information such as a customer ID 311 that can uniquely identify a customer, a customer ID record 31r including authentication information 312 and the like as shown in FIG. Storage media such as magnetic cards, IC cards, and portable information terminals.

  The cart device 40 inputs information from the customer ID storage medium 30 via the ID storage medium reader 411, inputs information from the position tag 20 via the position tag reader 412, and information with the customer via the touch panel display 413. Information input / output, information input from the product tag 10 via the product tag reader 414 based on the customer's operation, information input / output between the communication control means 42, processing control means 43, and storage means 44 described later Input / output control means 41 for controlling input / output, communication control means 42 for controlling wireless information transmission / reception to / from other devices such as the store device 50 via the wireless antenna 421, and cart device processing described later as effective fish 2, a cart device ID 4411 for uniquely identifying the cart device 40, and the cart device 40 as shown in FIG. A cart device information table 441 including a cart device information record 441r including a customer ID 4412 and position information 4413 of a customer, a product ID 4421, a product name 4422, a price 4423, a service notification date and time 4424, as shown in FIG. A smart cart comprising storage means 43 for storing various information such as a product information table 442 including a product information record 442r including contents 4425, scheduled date and time 4426, scheduled number 4427, settlement date and time 4428, settlement number 4429 and the like, It is a computer called a PSA (Personal Shopping Assistant) terminal or the like.

  The store apparatus 50 includes an input / output control unit 51 that controls information input / output between the product tag 10 via the product tag reader / writer 211, a communication control unit 52, a processing control unit 53, and a storage unit 54, which will be described later. Communication control means 52 for controlling wireless transmission / reception of information to / from other devices such as the cart device 40 via the wireless antenna 521, processing for controlling execution of table update processing, service setting processing, and service provision processing described later. The control means 53, a login table 541 composed of a login record 541r including a user ID 5411, a cart device ID 5412, location information, etc., as shown in FIG. 2 (6), and a customer ID 5421 as shown in FIG. 2 (7). , Date 5422, type 5423, details (price 5424, service content 5425, planned number 5426, settlement number 54 7, a customer history table 542 including a customer history record 542 r including a cleared flag 5428), a product ID 5431, a product name 5432, a price 5433, a gross profit rate 5434, and a manufacturing date 5435 as shown in FIG. , Expiration date 5436, location information 5437, inventory quantity 5438, planned purchase quantity 5439, excess inventory quantity 543A, inventory management record 543r including update flag 543B, etc., product ID 5441 as shown in FIG. , Time 5442, sales plan number 5443, excess inventory allowable rate 5444, expected excess inventory allowable rate 5445, sales plan table 544 including sales plan record 544r including service contents 5446, and product ID 5451 as shown in FIG. , Including gross profit amount 5452, product location information 5453, etc. Service target product table 545 composed of service target product record 545r, service target customer table 546 composed of service target customer record 546r including product ID 5461, customer ID 5462, customer location information 5463, etc., as shown in FIG. A screen data table 547 composed of a screen data record 547r including a screen name 5471, a screen data path 5472, etc., as shown in FIG. 2 (12), a product ID 5491, a customer ID 5492, and a co-purchased product as shown in FIG. Purchase information table 549 including a purchase information record 549r including ID 5493, purchase ratio 5494, etc., as shown in FIG. 3 (1), excess inventory number 54811, product name 54812, price 54813, ratio 54814, service price 54815, planned number 54816 etc. , Setting items such as product information 54821, number 54822 shown in FIG. 3 (2), service information screen data 5481 including “Register purchase schedule” button 54817, “Do not register purchase schedule” button 54818, and the like. And a storage unit 54 that stores screen data such as confirmation screen data 5482 including a “logout” button 54323, a “not logout” button 54324, and the like.

  Next, cart device processing performed by the processing control means 43 of the cart device 40 of the present invention will be described using the cart device processing flowchart shown in FIG.

  The processing control means 43 of the cart apparatus 40 of the present invention starts processing based on the read input of the customer ID storage medium 40 by the input / output control means 41 via the ID storage medium reader 411. In S101, the read ID storage medium 40 authentication processes are executed. Since the specific method of this authentication is a conventional technique, description thereof is omitted. In the present embodiment, the method using the ID storage medium 40 is taken as an example. However, the use of biometric authentication or other various technologies capable of authenticating an object to be identified, alone or in combination, is excluded. Instead, various methods other than authentication using an ID storage medium that can branch processing depending on success or failure of authentication can be employed.

  In S102, it is determined whether or not the authentication is successful. If it is determined that the authentication is successful (Y in S102), the process proceeds to S103, and if it is determined that the authentication is not successful (N in S102), the input / output control unit 41 uses the touch panel display 413. The fact that the authentication is unsuccessful is output to, and the cart apparatus processing is terminated.

  In S <b> 103, the cart device of the cart device information table 441 that acquires the customer ID stored in the storage unit 31 of the customer ID storage medium 30 through the ID storage medium reader 411 by the input / output control unit 41 and stores it in the storage unit 44. In addition to outputting / storing in the information record 441r, log information in which the cart device ID 4411 and the customer ID 4412 of the cart device information record 441r are set is generated, and the communication control means 42 transmits and notifies the store device 50 via the wireless antenna 421. .

  In S104, the process waits for the occurrence of an input / output control event by the input / output control means 41. When the occurrence of the event is detected, the process proceeds to S110.

  In S110, it is determined whether the event that has occurred is input of the position information record 21r of the position tag 20 via the position tag reader 412 by the input / output control means 41, and if it is determined that the input is the input of the position information record 21r (Y in S110) The process proceeds to S112, and if it is determined that the position information record 21r is not input in S110 (N in S110), the process proceeds to S120.

  In S111, it is determined whether the information in the input position information record 21r is different from the position information 4413 in the cart apparatus information record 441r in the cart apparatus information table 441 stored in the storage unit 33. If it is determined in S111 that it is different (Y in S111), the process proceeds to S112, and if it is determined that it is not different (N in S111), the process returns to S104.

  In S112, the information of the input position information record 21r is output and set to the position information 4413 of the cart apparatus information record 441r of the cart apparatus information table 44 and stored in the storage means 44, and at the same time via the wireless antenna 321 by the communication control means 32. The location information including the cart device ID 4411, the customer ID 4412, and the location information 4413 is generated in the store device 50, the transmission is notified, and the process returns to S104.

  In S120, it is determined whether the event that has occurred is reception of service information from the store apparatus 50 via the wireless antenna 321 by the communication control means 32. If it is determined that the service information is received (Y in S120), the process proceeds to S121, where If it is determined that the information is not received (N in S120), the process proceeds to S130.

  In S121, a product name 4422, price 4423, and service content 4424 are set based on the product name 54812, price 54813, and service price 54815 of the setting items of the received service information, and the product information record in which the current date and time is set as the service notification date and time 4424. 442r is generated and output / stored in the product information table 442 of the storage means 44, and the input / output control means 31 sets values on the setting items of the service information screen 5481 shown in FIG. The service information screen is output, and the process returns to S104. With respect to the output service information screen, the touch panel 413 is touch-operated to set the planned number 54816 as shown in FIG. 3A, and by selecting the “Register purchase plan” button 54817, the input / output control means 41, it is determined that the input is a purchase schedule in S130 described later, and it is determined that the input is not a purchase schedule by selecting the “do not register purchase schedule” button 54818.

  In S130, it is determined whether the event that has occurred is an input of a product purchase schedule displayed on the touch panel display 312 by the input / output control means. If it is determined that the input is a product purchase schedule input (Y in S130), the process proceeds to S131. If it is determined that the purchase schedule is not input (NO in S130), the process proceeds to S140.

  In addition to the service information output in S121, for the input of the purchase schedule in the cart device using the touch panel display 312, the cart device 40 is provided with a GUI for accessing the inventory management table 543 of the storage unit 54 of the store device 50. A table for requesting / obtaining / displaying a search for information stored in the inventory management table 543 via this GUI, or by partially mirroring information in the inventory management table 543 in the storage means 44 of the cart device 40 (see FIG. (Not shown) can be prepared in advance, and various conventional techniques such as accessing the inventory management table 543 and acquiring information as necessary for confirming the number of inventory can be adopted. I will omit the explanation.

  In S131, if it is a purchase schedule input to the service information screen 5481 output in S121, the current date and time and the planned number 4427 are set in the scheduled date and time 4426 of the corresponding product information record 442r in the product information table 442 stored in the storage unit 44. When the planned number 54816 is set and the purchase information is not input to the service information screen 5481 output in S121 but is the purchase information input by the above-described conventional product search, the product ID 4421 is obtained from the product information obtained by the search. A product information record 442r in which the product name 4422 and the price 4423 are set to the current date and time in the scheduled date and time 4426 and the planned number input from the touch panel in the planned number 4427 is generated and stored in the storage means 44. Communication control using 442r as purchase schedule information Send notification to the store unit 50 via the wireless antenna 321 by the step 32, the flow returns to S104.

  In S140, it is determined whether the event that has occurred is input of the product information record 11r of the product tag 10 by the input / output control means 31 via the product tag reader 414, and if it is determined that the input is the product information record 11r (Y in S140), S141. If the product information record 11r is not input (N in S140), the process proceeds to S150.

  In S141, the information of the product information record 11r input to the touch panel display 312 by the input / output control means 31 is output.

  In S142, the service flag is set in the input product information record 11r, and the product information table 442 stored in the storage unit 44 based on the product name included in the product information record 11r is referred to, so that it corresponds. If the product information record 442r is present and the service notification date 4424 is set, it is determined whether it is a service target. If it is determined to be a service target (Y in S142), the process proceeds to S143, and is not a service target (S142). If N), it returns to S104.

  In S143, the input / output control means 31 outputs the service content 4425 of the corresponding product information record 442r to the touch panel display 312 in addition to the information output in S113, and the process returns to S104.

  In S150, it is determined whether the event that has occurred is an input of a settlement request for the information of the product information record 11r output to the touch panel display 312 in S141. If it is determined that the settlement request is input (Y in S150), the process proceeds to S151. If it is determined that the request is not input (N in S150), the process proceeds to S160.

  In S151, the product information table 442 stored in the storage unit 44 is referred to based on the product name included in the product information record 11r. If there is a corresponding product information record 442r, the product information record 442 is not present. After the product ID 111, product name 112, and price 115 included in the product information record 11r are set to the product name 4421, product name 4422, and price 4423, the current date and time are set to the check-in date 4428 and the check-out number 4429 is the target of the check-out request. A value obtained by adding the product scores of the same product name 111 is set and output / stored in the product information table 442, and payment request information is generated, and is transmitted to the store apparatus 50 by the communication control means 32 via the wireless antenna 321. Then, the process returns to S104.

  In S160, it is determined whether the occurred event is logout. If it is determined that the logout is logout (Y in S160), the process proceeds to S161. If it is determined that the logout is not logout (N in S160), the process returns to S104.

  In S161, the communication control means 32 transmits and notifies the store apparatus 50 of logout notification information including the cart apparatus ID and the customer ID via the wireless antenna 321.

  In S162, the communication control means 32 determines whether confirmation information has been received from the store apparatus 50 via the wireless antenna 321. If it is determined that the confirmation information has been received (Y in S162), the process proceeds to S163 and no confirmation information is received. If it is determined (N in S162), the cart apparatus process is terminated.

  In S163, the input / output control means 31 outputs a confirmation information screen 5482 as shown in FIG.

  In S164, it is determined whether the approval is input depending on whether the touch operation to the “logout” button 54823 or the “do not logout” button 54824 on the confirmation information screen 5482 output in S163 is input by the input / output control means 42. If the input is a touch operation to the “Logout” button 54823, it is determined that the approval has been input (Y in S164), and the process proceeds to S165 to input the touch operation to the “Do not logout” button 54824. In this case, it is determined that the approval has not been input (N in S164), and the process returns to S104.

  In S165, the communication control means 32 transmits and notifies the store apparatus 50 of approval information including the customer ID via the wireless antenna 321, and the cart apparatus process is terminated.

  Next, the table update process performed by the process control means 53 of the store apparatus 50 of the present invention will be described with reference to the table update process flowchart shown in FIG.

  The process control means 53 of the store apparatus 50 of the present invention starts the table update process shown in FIG. 5 based on the reception of information from the cart apparatus 40 via the wireless antenna 521 by the communication control means 52.

  The process control means 53 of the store apparatus 50 determines in S310 of FIG. 5 whether the information received from the cart apparatus 40 is login information. If it is determined that the information is login information (Y in S310), the process control means 53 proceeds to S311. If it is determined that there is no (N in S310), the process proceeds to S320.

  In S311, a login record 541r in which the customer ID and cart device ID included in the received login information are set to the customer ID 5411 and the cart device ID 5412 is generated, and is output and stored in the login table 541 of the storage unit 54.

  In S312, a customer history record 542r in which the customer ID included in the received login information, the current date and time, and the login are set in the customer ID 5421, the date 5422, and the type 5423 is generated and output and stored in the customer history table of the storage unit 54. Then, the table update process ends.

  In S320, it is determined whether the information received from the cart device 40 is position information. If it is determined that the information is position information (Y in S320), the process proceeds to S321. If it is determined that the information is not position information (N in S320), the process proceeds to S330. .

  In S321, the login table 541 stored in the storage unit 54 is referred to based on the customer ID included in the received location information, and the received location information is set in the location information 5413 of the login record 541r that matches the customer ID. The data is output / updated and stored in the table 541, and the table updating process is terminated.

  In S330, it is determined whether the information received from the cart apparatus 40 is purchase schedule information. If it is determined that the information is purchase schedule information (Y in S330), the process proceeds to S331, and if it is determined that the information is not purchase schedule information (N in S330), S340. Proceed to

  In S331, it is searched whether there is a customer history record 542r in the customer history table 542 stored in the storage means 54 based on the customer ID and the product name included in the received purchase schedule information. If the scheduled number 5426 is not set, the customer history record 542r is generated based on the received purchase schedule information, and then the current date is set to the date 5422 and output and stored in the customer history table 542.

  In S332, the inventory management table 542 of the storage means 54 is referred to, and the planned purchase quantity 5439 of the inventory management record 542r corresponding to the product ID included in the purchase schedule information is added and output and stored in the inventory management table 542 to update the table. The process ends. If the customer history record 542r is already in the customer history table 542 in S331, the adjustment is made from the planned number 5426 to the planned number 5426 of all the customer history records 542r for the corresponding product in the predetermined sales calculation period. A difference value between the planned number included in the received purchase schedule information and the planned number 5426 before the processing of S331 is added so that the number is subtracted.

  In S340, it is determined whether the information received from the cart apparatus 40 is settlement information. If it is determined that the information is settlement information (Y in S340), the process proceeds to S341. If it is determined that the information is not settlement information (N in S340), the process proceeds to S350.

  In S341, it is searched whether there is a customer history record 542r in the customer history table 542 stored in the storage means 54 based on the customer ID and product name included in the received settlement information. If there is, the settlement included in the received settlement information. When the number of payments 5427 is set and the number of payments 5427 is the scheduled number 5426 or more, the payment completed flag 5428 is set. If there is no corresponding customer history record 542r, the customer history record 542r is set based on the received payment information. Generate and set a settlement completed flag 5428 and output and store it in the customer history table 541 of the storage means 54.

  In S342, the inventory management table 543 stored in the storage unit 54 is referred to, the settlement number is subtracted from the inventory number 5438 of the inventory management record 543r identified by the product ID of the commodity to be settled, and the customer processed in S341 is further processed. When the planned number 5426 of the history record 542r is 1 or more, the settlement number 5427 with the planned number 5426 as the maximum value is subtracted from the planned purchase number 5439, an update flag is set, and output and stored in the inventory management table 543. The update process ends. Note that if the customer history record 542r is already in the customer history table 542 in S341, the inventory quantity 5438 is reversed to the reimbursement number 5427 of all the customer history records 542r for the corresponding product in the predetermined sales calculation period. The number 5439 is a value obtained by subtracting the number of payments with the planned number 5426 as the upper limit from the planned number 5426 of all customer history records 542r for the corresponding product in the predetermined sales calculation period. The difference value between the number of settlements included and the number of settlements 5427 before processing in S341 is added to the latter, and the difference value between the planned number included in the received settlement information and the planned number 5426 before processing in S341 is added.

  In S350, it is determined whether the information is logout information. If the logout information is determined (Y in S350), the process proceeds to S351, and if it is not a logout event (N in S350), the process ends.

  In S351, with reference to the customer history record 542r in which the type 5423 of the customer history table 542 stored in the storage unit 54 is the product ID, the cleared flag 5428 is included in the customer history record 542r of the customer ID included in the logout information. It is determined whether there is a customer history record 241r that has not been set. If it is determined (Y in S351), the process proceeds to S352, and if it is determined that it is not (N in S351), the process proceeds to S356.

  In S352, the product name of the customer history record 241r in which the settlement flag 5428 is not set in the product name 54821 and the number 54822 of the setting items of the confirmation screen data 5482 as shown in FIG. 5432, confirmation information in which a value obtained by subtracting the settlement number 4429 from the planned number is set is generated.

  In S353, the communication control means 52 transmits the confirmation information generated in S352 to the cart device 40 via the wireless antenna 521.

  In S354, the communication control unit 52 determines whether approval information has been received from the cart device 40 via the wireless antenna 521. If it is determined that the approval information has been received (Y in S354), the process proceeds to S355, and the approval information has not been received. If it is determined that (N in S354), the process is terminated.

  In S355, referring to the inventory management table 542 of the storage means 54, the customer history record 241r includes the planned purchase number of the inventory management record 542r corresponding to the product ID included in the customer history record 241r including the product information that has not been settled. An update flag is set by subtracting the number that has not been settled and stored in the inventory management table 542.

  In S356, the login table stored in the storage unit 54 is referred to based on the customer ID included in the logout information, the login record that matches the customer ID is deleted from the login table, and updated and stored in the storage unit 54.

  In S357, logout information including the date and time and the customer ID is output and stored in the customer history table 241 of the storage means 54, and the table update process is terminated.

  Next, service setting processing performed by the processing control means 53 of the store apparatus 50 of the present invention will be described below with reference to a service setting processing flowchart shown in FIG.

  The process control means 53 of the store apparatus 50 of the present invention executes the service setting process shown in FIG. 6 at a predetermined timing.

  The processing control means 53 of the store apparatus 50 determines whether or not there is an inventory management record 543r in which the update flag 543B is set with reference to the inventory management table 543 in S501 of FIG. 6, and determines that it is present (Y in S501). The process proceeds to S502 with the corresponding inventory management record 543r as a processing target, and if it is determined that there is no inventory (N in S501), the service setting process is terminated.

  In S502, the sales plan table 544 stored in the storage unit 54 is referred to, and all the sales plans corresponding to the predetermined sales calculation period among the sales plan records 544r identified by the product ID 5431 of the inventory management record 543r to be processed. The ratio (excess inventory ratio) of the inventory number 5438 of the inventory management record 543r to the remaining sales plan number obtained by subtracting the sales plan number from the total value of the sales plan number of the record 544r to the current date and time is calculated.

  In S503, it is determined whether the excess inventory rate obtained in S502 is equal to or greater than the excess inventory allowable rate 5444 at the current date and time of the sales plan record 544r to be processed. If it is determined that the excess inventory allowable rate is 5444 or more (Y in S503), S503 is determined. If it is determined that the excess inventory allowable rate is not equal to or greater than 5444 (N in S503), the process proceeds to S507.

  In S504, a ratio (expected excess inventory ratio) of the planned inventory quantity obtained by subtracting the planned purchase quantity 5439 from the inventory quantity 5438 of the inventory management record 542r to be processed with respect to the sales plan remaining quantity obtained in S502 is calculated.

  In S505, it is determined whether the expected excess inventory rate obtained in S504 is greater than or equal to the expected excess inventory allowable rate 5445 at the current date and time of the sales plan record 544r to be processed, and is greater than or equal to the expected excess inventory allowable rate 5445 (Y in S505). If it discriminate | determines, it will progress to S506, and if it discriminate | determines that it is not more than the expected excess inventory allowable rate 5445 (N in S505), it will progress to S507.

  In S506, the number of inventory exceeding the expected excess inventory rate is set in the excess inventory quantity 543A of the inventory management record 543r to be processed, and is output / stored in the inventory management table 543, and the product tag reader / writer 511 is input / output control means 51. The service flag 116 is set and stored in the product information record 11r stored in the storage unit 11 of the product tag 10 corresponding to the excess inventory number 543A from the nearer time limit of the corresponding product, and the process returns to S501. In response to this processing, in the product tag 10, the output control unit 12 performs output control through the display 131 so that the user can perceive that the product is a service target, such as changing the display color or blinking the display.

  In S507, if the excess inventory number 543A is set in the inventory management record 543 to be processed, it is initialized to 0, and the input / output control means 51 uses the product tag reader / writer 511 for the corresponding product. The setting of the service flag 116 of the product information record 11r stored in the storage unit 11 of the product tag 10 is deleted to update the storage, and the process returns to S501. In response to this processing, in the product tag 10, the output control unit 12 performs output control that allows the product tag 10 to perceive that it is a service target, such as changing the display color or blinking the display, via the display 131. .

  Next, a service providing process performed by the process control means 53 of the store apparatus 50 according to the present invention will be described below with reference to a service providing process flowchart shown in FIG.

  The process control means 53 of the store apparatus 50 of the present invention executes the service providing process shown in FIG. 7 at a predetermined timing.

  In S701 of FIG. 7, the process control means 53 of the store apparatus 50 refers to the inventory management table 543 stored in the storage means 54, and searches for an inventory management record 543r having an excess inventory number 543A of 1 or more. If it is determined as “Y” in S701, the process proceeds to S702, and if it is determined that there is no (N in S701), the service providing process is terminated.

  In S702, the product ID 5431, the price 5433, the gross profit rate 5434, the multiplication value of the excess inventory number 543A, and the position information 5437 are obtained for each record, with all inventory management records 543r having an excess inventory number 543A of 1 or more as processing targets. A service target product record 545r set in the ID 5451, gross profit 5452, and position information 5462 is generated, and is output and stored in the service target product table 545 of the storage unit 54.

  In S703, the service target product records 545r of the service target product table 545 stored in the storage unit 54 are sorted in the descending order of the gross profit amount 5452, updated and stored in the storage unit, and the first service target product with the highest gross profit amount is stored. Record 545r is acquired.

  In S704, it is determined whether the service target product record 545r has been acquired. If it is determined that the service target product record 545r has been acquired (Y in S704), the process proceeds to S705. If it is determined that it has not been acquired (N in S704), the service providing process ends.

  In S705, referring to the inventory management table 543 and the sales plan table 544 stored in the storage unit 54, the service price obtained by applying the service content 5446 to the price 5433 of the product to be processed and the ratio of the service price to the price are calculated. It memorize | stores in the memory | storage means 54 as process target goods service information (not shown).

  In S706, the login table 541 and the customer history table 542 stored in the storage unit 54 are referred to, and the processing target product ID within the predetermined sales calculation period of the customer ID 5421 corresponding to the customer ID 5411 of the login record 541r is set as the type 5423. The customer ID 5431 without the customer history record 542r and the location information 5413 of the login record 541r of this customer ID are acquired, and the service target customer record 546r set in the product ID 5461, the customer ID 5462, and the location information 5463 is generated and stored in the storage means 54 Output / store in service target customer table 546.

  In S707, based on the position information 5453 of the service target product record 545 to be processed, the position information 5463 of the service target customer record 546r of the service target customer table 546 stored in the storage unit 54 is rearranged in the order of closeness to the storage unit 54. The service target customer record 546r of the position information 5463 closest to the position information 5453 of the service target product record 545 to be processed is acquired by updating and storing.

  In S708, it is determined whether the service target customer record 546r has been acquired. If it is determined that the service target customer record 546r has been acquired (Y in S707), the process proceeds to S708. If it is determined that it has not been acquired (N in S707), the process proceeds to S715.

  In S709, with reference to the buy-and-buy information table 549 and the inventory management table 543 stored in the storage unit 54, the buy-and-buy information record 549r with the product ID 5491 as the processing target product ID and the customer ID 5492 as the target customer ID The concurrent purchase rate 5494 is obtained, and the value obtained by subtracting the planned purchase number 5439 from the inventory number 5438 of the inventory management record 543r having the concurrent purchase product ID 5493 as the product ID 5431 is 1 or more, and the price 5433 is lower than the price 5433 of the product to be processed. If it is determined that there is a product to be purchased together (Yes in S709), the process proceeds to S709, and if it is determined that it is not present (N in S709), the process proceeds to S710.

  In S710, referring to the inventory management table 543, the sales plan table 544 stored in the storage unit 54, and the processing target product service information stored in the storage unit 54 in S705, service information as shown in (1) of FIG. The excess inventory number 54811, product name 54812, price 54813, ratio 54814, service price 54815 on the screen 5481, the excess stock number 543A of the product to be processed, the product name 5432, and the product name of the product purchased together. The service information is generated by setting the price 5433, the price 5433 of the co-purchased product, the ratio of the service price calculated in S705 to the price 5433 of the co-purchased product, and the service price. FIG. 8 (1) shows an example of the service information screen after setting in S710.

  In S711, referring to the inventory management table 543, the sales plan table 544 stored in the storage unit 54, and the processing target product service information stored in the storage unit 54 in S705, service information as shown in (1) of FIG. The excess inventory number 54811, the product name 54812, the price 54813, the ratio 54814, and the service price 54815 on the screen 5481 include the excess inventory number 543A of the processing target product, the price 5433 of the processing target product, and the ratio and service price calculated in S705. Set each to generate service information. FIG. 8 (2) shows an example of the service information screen after setting in S711.

  In S 712, the generated service information is transmitted to the cart device 40 of the target customer via the wireless antenna 521 by the communication control unit 52.

  In S713, the customer ID 5462 to be processed, the current date and time, the product ID 5451 to be processed, the price 54813, the service price 54815, and the product ID 5432 of the simultaneously purchased product, the customer ID 5421, the date 5422, the product ID 5423, the price 5423, The set customer history record 543r is generated in the service content 5425, and is output and stored in the customer history table 543 of the storage means 54.

  In S714, the inventory management table 543 stored in the storage unit 54 is referred to, it is determined whether the service information notification transmission for the excess inventory number 543A of the processing target product has been performed, and if it is determined to be performed (Y in S714), the process proceeds to S715. If it is determined that the process has not been performed (N in S714), the process proceeds to S716.

  In S715, the service target product table 545 stored in the storage unit 54 is referred to, the next service target product record 545r is selected, and the process returns to S704.

  In S716, the service target customer table 546 stored in the storage unit 54 is referred to, the next service target customer record 546r is selected, and the process returns to S708.

  According to the present invention described above, only a predetermined number of products less than the sales plan remaining number of the current date and time for each product are targeted for service, and service information is selectively sent to customers who do not plan to purchase this product. It ’s more likely that you ’ll be able to get a gross margin than setting up a service for all your products and notifying all your customers, including those you ’re willing to buy, regardless of service availability, In other words, it is possible to provide service information on products that produce profits for the entire store.

  In addition, when notifying service information, customers close to this product will be notified, so the time from product purchase schedule entry to product acquisition after setting the service target will be shortened, and customers who may have a higher purchase rate It is possible to provide information.

  In addition, when there is a cheaper product with a high buy-through rate, since a service is set for the product, the ratio of the service to the price can be shown high, and an effect of increasing the purchase degree can be expected.

  Each information and processing can be dispersedly arranged in a plurality of devices, concentratedly arranged in a single device, or rearranged without departing from the gist of the present invention.

It is a system configuration schematic diagram of the present invention. It is a data layout example of the present invention. It is an example of screen data of the present invention. It is a cart apparatus process flowchart of this invention. It is a table update process flowchart of this invention. It is a service setting process flowchart of this invention. It is a service provision process flowchart of this invention. It is an example of a screen display of the present invention.

Explanation of symbols

10: Product tag 11: Storage means 12: Communication control means 121: Wireless antenna 13: Output control means 131: Display 20: Position tag 21: Storage means 22: Communication control means 221: Wireless antenna 30: Customer ID storage medium 31: Storage means 40: Cart device 41: Input / output control means 411: ID storage medium reader 412: Position tag reader 413: Touch panel display 414: Product tag reader 43: Processing control means 44: Storage means 441: Cart device information table 442: Product information table 50: Store device 51: Input / output control means 511: Product tag reader / writer 52: Communication control means 521: Wireless antenna 53: Processing control means 54: Storage means 541: Login table 542: Customer history table 543: Inventory management table 544: Sales plan table 545 Service target product table 546: service target customer table 547: screen data table 548: screen data 548
549: concurrent purchase information table 549

Claims (4)

To a computer that can communicate with the customer's cart device,
Based on information on the number of stocks for each product in a predetermined sales calculation period, the number of planned purchases entered from the customer's cart device, the number of planned sales, and the expected excess inventory tolerance ratio stored in the storage means The excess of the planned inventory after subtracting the planned purchase quantity exceeds the expected excess inventory allowance for products that do not satisfy the expected excess inventory allowance of the remaining sales plan after subtracting the planned sales to date from the total sales plan A service setting processing step for calculating the stock quantity and setting the corresponding number of products as service targets;
Based on the information on the product purchase schedule for each customer in the predetermined sales calculation period and the service content information of the product stored in the storage means, information on the product purchase schedule set as the service target in the service setting processing step A service providing step of notifying the customer's cart device of service contents of the product
A product service information providing program characterized in that In the service providing step, based on the position information of the product further stored in the storage unit and the position information of the customer's cart device, the customer cart device of the position information close to the position information of the product is sequentially The service information providing program according to claim 1, wherein service information including service contents of the product is notified. In the service providing step, the product set as the service target in the service setting processing step based on each information of the price for each product, the purchased product and the concurrent purchase rate, which is further stored in the storage unit, is a predetermined value or more. The service information including information on the application of the service content is notified to the co-sold product when there is a co-sale product whose price is lower than that of the product. Product service information provision program. Communication control means for controlling communication with the customer's cart device;
The number of stocks for each product in a predetermined sales calculation period, the planned number of purchases input from the customer's cart device, the number of planned sales, the allowable excess inventory allowance rate, the planned purchase and products for each customer during the predetermined sales calculation period Storage means for storing the service content information of
For a product that does not satisfy the expected excess inventory allowance rate of the remaining sales plan by subtracting the planned sales number from the total sales plan number to the current time, the planned stock number subtracting the planned purchase number from the stock number stored in the storage means, A service setting processing means for calculating an excess inventory number exceeding the expected excess inventory allowable rate and setting a corresponding number of products as service targets;
Service providing means for notifying the customer's cart device of the service content of the product, which is not storing information on the purchase schedule of the product in the storage means, based on the excess inventory number for each product calculated by the service setting processing means When,
An apparatus for providing product service information, comprising:

Images