JP5145820B2 - Shopping support system and program - Google Patents

Description

  The present invention relates to a technique for supporting shopping.

  Today, product sales information is distributed through various media such as newspaper inserts, town information magazines, websites on the Internet, and IC tags attached to products. For example, various IC tag systems have been developed by applying an IC tag reader system that attaches an IC tag to an article and reads the IC tag information.

  As such a system, a shopping support system and method capable of efficiently performing shopping while traveling around a plurality of shops are disclosed in Patent Document 1 below. This system displays products purchased by the user and stores that sell related products under the conditions desired by the user, and presents the order in which the displayed stores are optimally visited. In such a system, it is possible to search for information on the store that is most suitable for purchasing the product that the user wants to purchase and related products, and multiple stores that sell different products are extracted by the search. If so, it provides information on the route in which order each store should be visited.

  Furthermore, a method for attaching an IC tag to a catalog, a magazine, a newspaper, etc. and transmitting a link destination that provides information on the contents is disclosed in Patent Document 2 below. This system allows various tangible objects in the analog world to be linked by a link by embedding a link to access an electronic network in the tangible object. In such a system, any tangible object in the analog world and the digital world can be connected by a link by embedding a link for accessing an electronic network in the tangible object.

  Further, Patent Document 3 below shows a method for searching for a store information database to extract the price, sale information, and store information of a product to be purchased to support shopping without waste or waste. In creating shopping memos based on sales advertisements of each store, this system quickly obtains information about the prices of products to be purchased at each store by acquiring advertisements from the network and creating a table in an easy-to-search format. In this way, the purchase destination of the product meeting the user's request is guided.

  In such a system, the processing method of the goods is determined based on the stocked goods, and various items such as a shop where the missing goods are purchased as cheap as possible, a shop near a specific place, and a shop within business hours can be visited. It is possible to select information according to conditions and provide information for shopping without excessive, wasteful or wasteful shopping.

  In recent years, services such as attaching an IC tag to a product / article and reading the product information from the information of the IC tag or following the movement history of the IC tag to accurately grasp the physical distribution have been developed. In the future, it is speculated that IC tag technology will spread rapidly with the development of the ubiquitous society, and in the near future, IC tags will be installed in newspaper advertisements.

If an IC tag is installed in a newspaper advertisement, more information than the current information can be obtained. For example, a rust portion such as music can be recorded on an IC tag and read and listened to by an IC reader. Further, more product information to be posted in the advertisement can be recorded, and products that cannot be printed by the advertisement can be recorded in the IC tag portion, and the user can draw it out at home.
JP 2006-184950 A JP 2001-273226 A JP-A-10-63725

  However, as in the prior art, for example, it is possible to read information from advertisements in newspapers and receive electronic information such as cheap eggs and cheap fish, but which store is best to purchase? You must judge for yourself. Also, since advertising information is often posted together for several days, it is difficult to remember such things as “Today's eggs are cheap at that store” until a few days later. Depending on the combination of products desired, it may be less expensive to purchase two products at a store that is reasonably cheap than to buy one at the cheapest store. This is a problem that taking into account the travel time and travel costs, the relationship is not “Purchase at a low-priced store” = “Most efficient shopping”.

  Furthermore, in the system disclosed in Japanese Patent Application Laid-Open No. 2006-184950, it is possible to search for information on a store that is most suitable for purchasing a product that the user wants to purchase and related products. When a plurality of shops that sells are extracted, it is possible to provide an optimum route as to which order each shop should be visited.

  However, with this technology, there is no consideration when purchasing a plurality of products at the same time. That is, even if “the cheapest product including transportation costs” is simply displayed for each product, it is not known whether it is “the most efficient shopping”. For example, if you want to purchase eggs, meat, and Chinese cabbage, even if the cheapest products are output for each product and displayed in order of purchase as in this technology, it is not known whether it is the most efficient. In particular, it may be more efficient to shop for eggs and Chinese cabbage in the same shopping street, or go to another shopping street using transportation and purchase meat there. In such a case, the conventional technology cannot cope. In addition, it is said that it includes not only the product price but also transportation costs (for example, the gasoline cost of the car), but the gasoline cost also varies depending on the individual vehicle type, high-octane, regular, light oil and local Transportation costs also change depending on the average unit price. There arises a problem that such a case cannot be dealt with.

  Next, in the system disclosed in Japanese Patent Application Laid-Open No. 10-63725, the processing method of the articles is determined based on the inventory articles, and the purchase source of the missing articles is determined to be as cheap as possible, the store / sales near a specific place. It is possible to select information based on various conditions such as a shop that can be visited in time, and to provide information for shopping without excessive, wasteful or wasteful shopping.

  However, even if you are provided with the information to select a place where you purchase the missing goods according to the conditions and make shopping without undue, waste, or waste, which store you will go to at the discretion of the individual? You must judge. The problem with this system was that shopping was done in the order of the cheapest shops, but taking into account travel time and travel costs, “buy at cheap shops” = “the most efficient shopping” The problem is not to be.

  Furthermore, in the above prior art, everything is processed with the idea centered on the home. However, when actually going to live, when going from a destination (leisure, public institution, hospital, etc.), go to the shop from the company. Cases are also included. In such a case, there is an error in transportation costs, so there is a problem that it is not known how to go around the store is the “most efficient shopping”.

The present invention solves the above-described problems, and provides a technique for assisting a user so that an efficient shopping can be performed by reflecting the price of a product to be purchased and the cost of transportation means at the time of shopping. Objective.

  One aspect of the present invention employs the following means in order to solve the above problems. That is, in this aspect, a map information database including information for identifying a store and geographical location information of the store, information for identifying a transportation means used by a user, and each usage fee of the transportation means A product that accepts input of product information including a transportation cost information database that includes information indicated by units or units of sections that can be used by the means of transportation, information that identifies products provided at a store, and the offer price of the product Information input means, product information database for storing the product information input from the product information input means together with information for identifying the store, information for identifying the product desired by the user, and purchase information including the desired quantity A shopping support system comprising purchase information input means for receiving input and processing means for performing arithmetic processing. Here, the processing means extracts information for identifying a store that sells a product included in the input purchase information and a sales price of the product from the product information database, and the product is sold at a plurality of stores. The store extracting means for extracting one or more stores to be used for the purchase information by selecting a store with a low price, and once for the extracted store starting from a predetermined point The first setting means for setting the first route to the predetermined end point after each visit and the transportation cost database, and the transportation cost when the route is traced for each distance constituting the route or the section constituting the route A transportation cost calculation means for calculating the transportation cost according to the first transportation cost, and a first traveling total value that is a sum of a price and a transportation cost when the product is purchased at each store included in the first route. Single store purchase for calculating a single store purchase amount, which is the total purchase price when all the products included in the purchase information are purchased at each of the calculation means and the stores within a predetermined range from the user's location point At the store where the total value of the amount calculation means and the single store purchase cost and the single store transportation cost which is the transportation cost necessary for traveling from the departure point to the end point to the end point is the smallest A second total means for calculating a single store minimum shopping cost which is a total value, and the single store minimum purchase cost when the single store minimum shopping cost does not exceed a predetermined limit with respect to the cyclic total value; Output means for displaying information for recommending the purchase of a product included in the purchase information at a single store as an expense.

  According to this aspect, it is possible to support the user's decision as to whether to shop at a single store or to visit a plurality of stores, and efficient shopping.

  The processing means includes: an excluded store selecting unit that selects a first store to be excluded from stores included in the first route; and a store other than the first store included in the first route, An alternative store allocation means for allocating a store that sells a product scheduled to be purchased at the first store at a minimum price as an alternative store for purchasing the product on behalf of the first store; Comparing means may be provided that compares the increase in the purchase amount of the product with the decrease in the transportation cost by excluding the first store from the first route when the change is made. The output means recommends information for recommending the purchase of the product through the second route excluding the first store from the first route when the increase in the purchase amount of the product is smaller than the decrease in the transportation cost. Show it. According to this aspect, when visiting a plurality of shops, it is possible to narrow down the shops in consideration of transportation costs and reduce shopping costs.

  Further, the processing means sequentially changes the first store to be selected, and assigns the substitute store by the substitute store assigning means, the increase in the purchase price of the product by the comparing means, and the decrease in the transportation cost. And a repeating unit that repeats the comparison with and a determination unit that ends the repetition by the repeating unit when a predetermined calculation state is reached. According to this aspect, it is possible to support the user more efficiently by repeating the processing up to a predetermined limit.

  According to the present invention, the above-described problems are solved, and the user can be supported so that an efficient shopping can be performed by reflecting the price of the product to be purchased and the cost of transportation at the time of shopping.

  Hereinafter, an information system according to the best mode for carrying out the present invention (hereinafter referred to as an embodiment) will be described with reference to the drawings. The configuration of the following embodiment is an exemplification, and the present invention is not limited to the configuration of the embodiment.

<System outline>
This information system provides the following functions to assist the user in efficient shopping.
(1) Providing information for purchasing a plurality of purchased products in an efficient procedure.
(2) Efficient procedures are evaluated by price, time, etc., and provide an environment where individuals can choose without hesitation.
(3) Provide information that enables efficient product purchase, including the cost of transportation from home.
(4) When the means of transportation is a private car, calculate the exact transportation cost from the individual fuel consumption and unit price of the fuel area.
(5) A function for specifying how many km of radius of the article information is collected from the home is provided, and information is provided as to whether or not the merchandise can be purchased efficiently in what order.
(6) Provide efficient shopping information including transportation charges from the destination.

  FIG. 1 is a block diagram showing functions of the information system. As shown in FIG. 1, this information system includes a store 40 product information database 41 (corresponding to a product information database), a map information database 42, and a personal information database 43, and products for inputting information into the database 40. The information input means 62, the purchase information input means 61, and the processing means 60 which processes the information of the database 40, and outputs the information which supports a user's shopping. Each of the above means is realized as a program on a computer.

  Of the database 40, the store product information database 41 stores the product information input from the product information input means 62 together with information for identifying the store. The map information database 42 includes information for identifying a store and geographical location information of the store. Further, the map information database 42 includes geographical position information of a region where the user is set in advance. The personal information database 43 includes information on transportation means used by the user (corresponding to a transportation cost information database). The information on the transportation means includes information for identifying the transportation means and information indicating a usage fee of each transportation means in a unit of distance or a section of a section that can be used by the transportation means.

  For example, the detachable recording medium input / output device 36, the communication interface 37, the IC tag reader / writer 20, the OCR (Optical Character Reader) 21, etc. are connected to the merchandise information input means 62, and various information is responded to user operations. Input and output. The input information is stored in the database 40. The information input to the product information input means 62 is, for example, information for identifying a product provided at a store, a provision price of the product, and the like.

  The purchase information input means 61 is connected to the input device 34 and inputs various information in response to a user operation. That is, the purchase information input means 61 accepts input of purchase information including information for identifying a product desired by the user and the desired quantity, and generates, for example, a shopping list in a personal information database. In addition, transportation means, fuel consumption, fuel price, and the like are also input through the input device 34.

  For example, the processing unit 60 accesses the database 40 and executes various information processing. The processing unit 60 includes a store extracting unit 601, a setting unit 602, a transportation cost calculating unit 603, a first summing unit 604, a single store transportation cost calculating unit 605, a second summing unit 606, and an output unit 607.

  The store extraction unit 601 extracts information for identifying a store that sells a product included in the input purchase information and the selling price of the product from the store product information database 41, and the product is sold at a plurality of stores. When a store is selected, one or more stores to be used for the purchase information are extracted by selecting a store with a low price.

The route setting unit 602 includes a first setting unit, a second setting unit, and a third setting unit. The first setting means sets a first route from a predetermined point as a departure point to a predetermined end point after visiting the extracted store once. The second setting means is configured such that when the second store is added to any section of the route excluding the first store from the first route, the increase in transportation cost due to the addition is minimized. Set the route. The third setting means selects the third store that sells the product that was planned to be purchased at the first store, and excludes the first store when the third store is included in the first route. A third route is created, and when the third store is not included in the first route, the third store is located in any section of the route excluding the first store from the first route. The traffic cost calculation means 603 refers to the traffic cost database and determines the traffic cost when the route is traced or the distance of the route or Calculate according to the transportation costs for each section that makes up the route.

  The first total calculation means 604 calculates a cyclic total value that is the total of the purchase amount and the transportation cost when the product is purchased at the store included in the first route.

  The single store purchase amount calculation means 605 calculates a single store purchase amount that is the total purchase price when all the products included in the purchase information are purchased in each store.

  The second summing means 606 calculates a single store minimum shopping cost, which is the sum of the single store purchase amount and the single store transportation cost at the store having the smallest value.

  A display device 35 is connected to the output means 607. The output means 607 purchases a product included in the purchase information at a single store that becomes the single store minimum purchase cost when the single store minimum purchase cost does not exceed a predetermined limit with respect to the total traveling value. Is recommended.

  FIG. 2 is a diagram showing an outline of processing of the information system. The information system first executes product information input processing. The product information input process is a process of accepting input of product information from the user and accumulating it in the store product information database 41. The user inputs product information (product name, price, etc.), date, store address, etc. stored in the IC tag by the IC tag reader / writer 20. The information system detects an operation on the IC tag reader / writer 20 and reads information stored in the IC tag (S1).

  Further, the information system reads the designation of the sale item, and stores the sale price, the discount price, the discount rate, etc. for each date and each category of the product (S2). Further, the information system creates a list in which identification information indicating shops is rearranged in order from the lowest price for each date and each product (S3).

On the other hand, the information system executes a personal information input process for receiving input of personal information from the user. In this process, the information system prompts the user to input a home address and reads the input information (S4). Hereinafter, reading the input information by prompting the user to input is referred to as “accepting input (from the user)”. Further, the information system receives an input of an article desired from the user (S5). For example, the names of products such as eggs, onions, and carrots are input.

  Further, the information system accepts input of date and time information as to when those articles are necessary (S6). Further, the information system accepts an input of transportation means used for purchasing those articles, for example, a train (S7).

  Further, the information system accepts an input of the current unit price of gasoline, for example, the price of 1 liter of gasoline (S8). Further, the information system accepts an input of a distance that can be traveled per liter by a currently used car (this distance is called fuel consumption) (S9). However, information that does not change for a long time, such as car information, is stored in the default definition file of the personal information database 43 of the system, and a situation different from the default definition file, for example, a car that is different from the vehicle that is always used. Input may be accepted only when used.

  Next, this information system collates the data of the goods desired to be input with the product information (S10). And this information system extracts the candidate of the store which should purchase each article | item from the predetermined range, ie, the geographical range which a user accept | permits to go shopping. The store in this case may be selected, for example, because each product can be purchased at the lowest price. Further, a route passing through the extracted store candidates is set. Then, the transportation cost along the route is calculated (S11). The route at this point is a temporary candidate, and the transportation cost is not final.

  And this information system calculates the shopping charge of the goods group including the transportation expense accompanying a movement (S12). Furthermore, this information system selects one of the stores included in the current route (hereinafter referred to as the first store), and changes the product to be purchased at the first store to purchase at another store. Calculate changes in shopping fees. In that case, first, stop purchasing at the first store, calculate the total amount of goods and the total transportation cost when purchasing only at the remaining stores on the current route, and purchase with the original route Calculate the increase or decrease. In addition, instead of the first store, the total amount of goods and the total transportation cost when purchased at a store not included in the current route are calculated, and the increase / decrease from the case of purchasing through the original route is calculated. By such a procedure, a route with the lowest shopping charge is determined among the route from which the first store is deleted and the route including the second store instead of the first store (S13).

  Then, the information system presents the determined route to the user. The user goes shopping according to the presented route (S14).

  FIG. 3 is a diagram illustrating a hardware configuration of the information system. This information system can be realized as a system that is incorporated in a personal computer, a portable information terminal, an in-vehicle device, or a mobile phone and provides a function to a user. In addition, the information system can be realized as a system that provides a web service by a server on the Internet. Such a system functions by a computer program executed on a computer.

As shown in FIG. 3, this information system includes a CPU (Central Processing Unit) 31, a memory 32, a hard disk drive 33, an input / output device 34 (a pointing device such as a keyboard and a mouse), a display device 35, and a removable recording medium. Input / output device 36 (DVD (Digital Versatile Disk) drive, IC reader / writer, etc.), communication interface 37 (LAN (Local Area Network), wireless LAN, mobile phone, PHS (Personal Handyphone System) interface, etc.) . The computer may be provided with an IC tag reader / writer 20 and an OCR (Optical Character Reader) 39.

  FIG. 4A illustrates the configuration of the IC tag. The IC tag 10 shown in FIG. 4 includes an antenna 11, a rectifier 12, a demodulator 13, a modulator 14, a memory 15, and a control unit 16. The antenna 11 is provided for non-contact power / signal reception via radio. The memory 15 stores various information according to the use of the IC tag 10, and the control unit 16 executes various processes according to the use of the IC tag 10.

  A signal received by the antenna 11 is supplied to the rectifier 12 and the demodulator 13. That is, the radio wave received by the antenna 11 is superimposed not only with a radio wave intended to supply power via the rectifier 12, but also with an AM-modulated signal or clock signal for information communication purposes. The power received by the antenna 11 is boosted by a resonance action by a capacitor (not shown) connected in parallel with the inductance L of the antenna 11 itself, and supplied to the rectifier 12 as an AC voltage.

  The rectifier 12 converts the AC voltage supplied from the antenna 11 into a DC voltage. The rectifier 12 includes a regulator for supplying a constant DC voltage to the load. The rectifier 12 supplies a constant DC voltage to the demodulator 13, the modulator 14, the memory 15, and the control unit 16.

  The demodulator 13 demodulates the signal received via the antenna 11 and supplies the demodulated signal to the control unit 16. The modulator 14 modulates the signal supplied from the control unit 16 and wirelessly transmits the signal via the antenna 11.

  4B is a configuration diagram of an example of a configuration of an IC tag reader / writer that performs power supply and wireless communication to the IC tag 10 illustrated in FIG. 4A. The IC tag reader / writer 20 shown in FIG. 4B includes an antenna 21, a transmitter 22, a receiver 23, a control unit 24, and a memory 25.

  The IC tag reader / writer 20 transmits radio waves from the transmitter 22 via the antenna 21. The IC tag 10 receives the radio wave from the IC tag reader / writer 20 by the antenna 11. As described above, an electromotive force is generated by the resonance action of the inductance and the capacitance, and a DC voltage is generated by the rectifier 12 of the IC tag 10. Based on this DC voltage, the circuit (IC chip) inside the IC tag 10 operates, the control unit 16 reads out necessary information from the memory 15, and reads the read information from the modulator 14 through the antenna 11 as a radio signal. Send. The receiver 23 of the IC tag reader / writer 20 receives a signal from the IC tag 10 via the antenna 21 and supplies the received signal to the control unit 24. The control unit 24 transfers information included in the received signal to the outside (information system or the like in FIG. 3) as necessary.

  FIG. 5 shows an example of the data structure of advertisement data in the IC tag. In this example, the advertisement data of the IC tag includes a management unit and a product unit. The management unit mainly includes information for specifying a store that is the advertiser. For example, the management unit includes the store name, the geographical location of the store (latitude, longitude, etc.), information indicating the nearest station, the time zone of the date and time of the time service, and the like. The time zone of the date and time of the time service is, for example, 16: 00-17: 00 every day, 15: 00-17: 00 every Monday, and the like. In addition, the product section includes a normal price, a price during time service, a product weight, a product volume, dimensions, and the like for each product handled in the store.

FIG. 5 shows an example of an IC tag. For example, even in the case of a paper insert advertisement, the OCR 20 converts the printed character string into digital information, and the product information for each store of similar information can be obtained. Can be generated. Similarly, information such as the price of goods, the price at time service, the weight, volume, and dimensions can be acquired for each store from the website on the network.

  Information for each product for each store obtained from the IC tag reader / writer 20, the OCR 39, a website on the network, and the like is stored in the store product information database 41 using information for identifying the store such as the store name as a key. Instead of the store name, the acquired information may be stored in the store information database 41 using a unique identification code as a key. The identification code and the store name may be registered in the store master. Similarly, the product may be stored in the store product information database 41 based on the product code. The product code and the product name may be registered in the product master.

<< First Embodiment >>
<Processing flow>
The information system according to the first embodiment of the present invention will be described below with reference to the drawings in FIGS.

  FIG. 6 shows a processing flow of the information system. This information system refers to the database 40 and provides a user's shopping support function. First, the database 40 includes a store merchandise information database 41, a map information database 42, and a personal information database 43.

  In FIG. 7, the example of the record of the store merchandise information database 41 is shown. The store product information database 41 stores information for identifying each store, information for identifying a product sold at each store, and the price of each product. FIG. 7 shows the relationship between information (for example, product name) for identifying the product handled by the A store and the price. In this information system, the price of a product means a price in a normalized unit (hereinafter referred to as a unit price). For example, the price is 10 units for eggs and 1 for onions. The data of the store merchandise information database 41 is collected by the information system according to the user's operation through newspaper inserts, IC tags, the Internet, and the like. Further, the store merchandise information database 41 is collected by accessing a website of a URL (Uniform Resource Locator) registered in the personal information database 43 with the information system set in advance by the user under the control of the data collection program. .

  For example, the product category, the store category, and the geographical range of the store for which information is to be collected may be registered in the personal information database 43 by the user operating the input device. The CPU 31 of the information system that executes this process corresponds to means for receiving a geographical range.

  And the information system should just collect the said information with respect to the website on the internet. The CPU 31 of the information system that executes this process corresponds to means for acquiring product information.

  The collected information is input from the keyboard, the OCR 39, the IC tag reader / writer 20, the communication interface 37, etc., converted into the normalized price, and stored in the store merchandise information database 41.

  FIG. 8 shows an example of a record of point data in the map information database 42. The point data stores the geographical position of each point, for example, latitude and longitude. In the example of FIG. 8, for example, stores such as A store and B store, and home positions of family A and family B are defined.

  FIG. 9 shows an example of route data in the map information database 42. The road data defines the road between points. In the example of FIG. 9, there are distances between points such as between the A shop and the B shop, between the A shop and the C shop, between the family A and the A shop, and between the family A and the B shop. Is defined.

  The personal information database 43 in FIG. 6 includes a family name, a shopping list, information on transportation means used by the family, fuel consumption, fuel price, and shopping range. FIG. 10 shows an example of a shopping list. The shopping list includes a column of one or more products to be purchased, a column of sales price (unit price) at a store that sells each product, and the number of purchases of each product.

  FIG. 10 is a shopping list in the case of the family A. A list of products currently desired by the family A and the number of purchases are listed. In addition, in this shopping list, the selling price of each product from the store A to the store J, which is a store located in a shopping range that is an allowable distance for the family A, is listed. The shopping range is stored in the personal information database 43 as personal data of each family. For example, it is within 4 km in a linear distance from home. Also, it is within 5 km from home.

  In the information on transportation means used by the family shown in FIG. 6, transportation means normally used by the family are registered as default values. For example, a car, a bus, a train, etc. However, in actual shopping support, the transportation means used by the family on the day may be input.

  Furthermore, the personal information database 43 of FIG. 6 registers the fuel consumption of a car owned by the family and the fuel price at a gas station used by the family. What is necessary is just to input about the fuel consumption of a car, when purchasing a new car. In addition, the travel distance and usage amount may be input every time gasoline is purchased. Then, the average travel distance per liter of gasoline may be calculated.

  The fuel price may be input when the sales price at the gas station is changed. However, the information system may periodically access a gas station or a website of a gasoline sales company to acquire the fuel price. That is, the URL (Uniform Resource Locator) of a daily gas station website is registered in the personal information database 43, and the information system reads the fuel price from the website at a predetermined time, for example, 12:00 every day. Should be obtained.

  FIG. 11 is an example of the nearest public transportation data included in the map information database 42. The nearest public transportation means data includes a record listing the nearest public transportation means for each point. In the example of FIG. 11, for example, the A store is closest to the B1 bus stop when using the bus, and the S1 station is closest to the train when using the train. In Family A's home, the B3 bus stop is the nearest when using the bus, and the S2 station is the nearest when using the train.

  In FIG. 11, two nearest public transportation means are recorded for each point, but the nearest public transportation means in the public transportation data of the present embodiment is not limited to two. The number of columns of the nearest public transportation means, that is, the number of the nearest public transportation means may be variable for each point.

  FIG. 12 shows an example of public transportation means cost data included in the map information database 42. Public transportation means cost data may be stored in the personal information database 43. Public transportation cost data includes transportation fees between points. For example, between the B1 bus stop and the B2 bus stop is 200 yen. Moreover, it is 180 yen from S1 station to S2 station.

  The public transportation means cost data is input by the user through the input means 34 every time the public transportation means fee is revised. This information system accepts input from a user and stores public transportation fee data. In addition, the information system may periodically access a public transportation website and obtain a fee.

  With reference to FIG. 6, the outline | summary processing flow with respect to the shopping list of this information system is demonstrated. In this processing flow, shopping support for efficiently purchasing products in the shopping list shown in FIG. 10 is executed. Hereinafter, in this embodiment, a case will be described in which shopping is supported with priority given to the low price of goods.

  The process for creating the shopping list is basically a process for creating a list consisting of the names and the number (quantity) of the products shown in FIG. . The stores listed in the shopping list are stores whose distance from the user's home is within the shopping range desired by the user. The distance between the user's home and the store is calculated as a linear distance from the user's home (for example, family A) based on the point data in FIG. Further, for example, the route from the user's home may be calculated according to the route data in FIG. The shopping range may be defined in the personal information database 43, for example. Then, the shops in the shopping range are extracted from the user's home and listed in the shopping list in FIG.

  In this process, first, the information system calculates the distance from the user's home to each store (S20). Information for identifying the user's home is stored in the personal information database 43. For example, the family name may be registered in the profile of the personal information database 43. The distance from the user's home to each store is calculated with reference to the route data in FIG.

  Next, the information system calculates the distance between the shops to visit from the name of the shop described in the shopping list and the route data shown in FIG. 9 (S21).

  Next, from the results of S20 and S21, the transportation cost for visiting each store individually is calculated (S22). At this time, the information system may inquire the user about transportation means. And when there is no input of transportation means, the default transportation means registered in the personal information database 43 may be used.

  Next, the information system refers to the shopping list, and refers to the amount of money for purchasing products at each store from the store product information database 41. Then, a shopping list price table is created by adding the product price for each product for each store, the number of purchases desired by the user, and the purchase price based on the number of purchases (S23).

  Then, the transportation cost when each store is used individually (hereinafter referred to as single store transportation cost) and the total amount of the shopping list at each store (hereinafter referred to as single store purchase cost) are calculated for each store ( S24). Then, a store having a low sum of the single store transportation cost and the single store purchase cost is selected. Hereinafter, the total amount of money in a store where the total amount of the single store transportation cost and the single store purchase cost is the cheapest is referred to as a single store shopping cost (indicated by (α) in FIG. 6).

Next, for the products listed in the shopping list, a store that can be purchased at the lowest cost is extracted from the stores listed in the shopping list. A product sold in such a store is referred to as the lowest price product. In this information system, the stores extracted at this time are referred to as patrol candidate stores. Then, the information system creates a route for leaving the home and visiting each store. Of such routes, the creation of a perfect optimum route is generally known as a “traveling salesman problem” as a problem that cannot be solved in polynomial time (NP complete problem).

  Here, the route is obtained by an approximate solution. As an approximate solution, an area where a plurality of shops that are homes and visiting places are further divided into smaller areas, and an optimal solution may be obtained in each area. For example, when a visit target area includes a plurality of stations, the area is divided into a plurality of areas centered on the station.

  Then, it is only necessary to obtain a patrol route of a store included in each region and a patrol route between the region and the region (from station to station). Then, the entire route can be obtained by fitting the tour route that goes around each store in the region into the tour route that goes around the region.

  By doing so, it is possible to reduce the number of circulation destinations to be processed and to create a route that goes around the circulation candidate store from the home at approximately the shortest distance. For example, if thirty patrol candidate shops are extracted, 30! It is necessary to calculate the / 2 path (where! Indicates factorial). However, for example, by dividing into 6 areas each including 5 shops, 5! An approximate solution can be obtained by calculating the path of the order.

  The division of the area is not limited to the one centered on the station, and for example, the area may be simply divided into rectangular areas by latitude and longitude. Moreover, you may divide | segment an area | region into the strip | belt-shaped area | region orthogonal to a main road for every predetermined distance (for example, 1 km) along a main road. Many other processing methods for obtaining such an approximate optimum route have been proposed, and details thereof will be omitted.

  In this way, the total of the purchase amount and the transportation cost when the merchandise is purchased by visiting the store that sells the lowest-priced product (hereinafter referred to as the cyclic total value, indicated by (β) in FIG. 6) is obtained (S25). ).

  Then, the information system compares the single store shopping cost (α) with the cyclic total value (β) (S26). When the single store shopping cost (α) is low, the information system outputs a display for recommending shopping at the store corresponding to the single store shopping cost (α) to the display unit (S27). In this case, the user purchases a product on the shopping list at a single store where the sum of the purchase price of the product and the transportation cost is the lowest.

  In addition, when the cyclic total value (β) is low, the information system determines, for each product, the lowest price (the price at a store that is currently planned to be purchased) and the next cheapest store (a store on the current route, The difference from the price of the product at the alternative store is calculated (S28).

  Then, the difference (increase) in the total amount of the products when purchased at an alternative store without making a purchase at a specific store (hereinafter referred to as the first store) scheduled to be present on the current route is calculated. (S29). Here, as the selection of the first store, for example, a store having the smallest number of purchased items may be selected. This is because a store with a small number of purchased items is considered to be less affected by the purchase at an alternative store with the next lowest price from the lowest price. In addition, for each store, the store with the smallest increase in purchase amount when the planned purchase item is changed to an alternative store may be selected as the first store. Further, the difference between the increase in the purchase amount and the decrease in the transportation cost due to not visiting the store may be calculated, and the store having the largest reduction amount may be selected as the first store. Also, simply select a store that has a long distance from the store before and after the store of interest, or a store with high transportation costs in the section with the store before and after the store as the first store. Good. The CPU 31 of the information system that executes such processing for selecting the first store corresponds to the excluded store selection means. Further, the CPU 31 of the information system that executes the process of setting an alternative store for purchasing the product that was planned to be purchased at the first store corresponds to an alternative store allocation unit.

  And the difference of the total amount of goods is compared with the difference (reduction amount) of the transportation expense by not visiting the 1st store (S30). The CPU 31 of the information system that executes the process of S30 corresponds to a comparison unit. When the difference (increased amount) in the total amount of the products is large, information that recommends that the products be purchased at each store having the cyclic total value (β) on the route that does not exclude the first store is displayed on the display unit. Output (S31).

  On the other hand, when the difference (decrease) in the transportation cost is large, the information system outputs to the display section information recommending that a product be purchased through a route that excludes the first store from the route (S32). At this time, the information system recommends that the product that was planned to be purchased at the first store is purchased at the alternative store.

  As described above, according to the information system of the present embodiment, when the user visits each store from the user's home and purchases the product, the sum of both the price of the product and the transportation cost is advantageous in the store. Recommend purchases to users and support shopping. In particular, it is possible to provide support in consideration of the advantages and disadvantages of purchasing a plurality of products at a plurality of stores and purchasing them at one place. Furthermore, even when traveling around a plurality of places, by replacing the purchase at the first store, which is greatly affected by the transportation cost, with the purchase at the alternative store, waste due to an increase in transportation cost can be reduced.

<Modification>
In the above embodiment, as shown in FIG. 6, first, the single store shopping cost (α) is compared with the cyclic total value (β). When the single store shopping cost (α) is low, the information system outputs a display recommending shopping at the store corresponding to the single store shopping cost (α) on the display unit, and the total traveling value In the case where (β) is cheap, it was further determined whether or not to change the shopping to an alternative store on the route to go around.

  However, instead of such a procedure, before comparing the single store shopping cost (α) with the cyclic total value (β), first, the shopping is further changed to an alternative store in the route of circulation. Whether or not it may be determined. FIGS. 13 to 15 show flowcharts of such processing.

  In the process of FIG. 13, the processes from S20 to S25 are the same as those in FIG. That is, the total (β) of the purchase amount and the transportation cost when the product is purchased by visiting the route constituted by the stores selling the lowest price product is obtained (S25).

  Next, the information system searches for a route where the total amount can be reduced with a route from which stores have been reduced (S25A). In this case, the total amount obtained is (γ). Further, the information system searches for a route where the total amount can be reduced by replacing the store including the current route with the store not included in the route (S25B). Let the total amount obtained in this case be (δ).

  In this way, the single store shopping cost (α) obtained by the process of S24 is compared with the total amount (δ) obtained as a result of the search (S26A). When the single store shopping cost (α) is low, the information system outputs a display for recommending shopping at the store corresponding to the single store shopping cost (α) to the display unit (S27). In this case, the user purchases a product on the shopping list at a single store where the sum of the purchase price of the product and the transportation cost is the lowest.

  When the total amount (δ) obtained as a result of the search is low, the information system outputs a display for recommending shopping on the route having the total amount (δ) to the display unit (S27A). ).

FIG. 14 shows a processing example (S in FIG. 13) of searching for a route where the total amount can be reduced by reducing the number of shops.
Details of 25A). In this process, the information system selects a specific store (first store) included in the current route (referred to as the first route) (S25A1). This selection procedure is the same as the selection procedure for the first store in S29 of FIG.

  Next, instead of purchasing the product at the selected store, the information system changes the purchase to the store with the next lowest price (alternative store) among the other stores included in the route for selling the product. The second route is created (S25A2). The CPU 31 of the information system that executes the process of S25A2 corresponds to an alternative store allocation unit.

  And this information system calculates the difference (increase) of the total amount of goods at the time of purchasing in an alternative store, without purchasing in the 1st store which exists in the 1st course.

  Then, the difference between the total amount of the products is compared with the difference (decrease) in the transportation cost due to not visiting the first store (S25A3). And when the difference (reduction amount) of goods is large, this information system makes the 2nd path | route which excluded the 1st store from the path | route anew as a 1st path | route (S25A4). The CPU 31 of the information system that executes the processing of S25A4 corresponds to a means that is defined as the first route.

  Next, the information system determines whether or not to end the process (S25A5). This determination may be made on condition that the number of repetitions of the repeating means from S25A1 to S25A3 has reached the upper limit value. Moreover, it is good also as conditions on condition that all the stores contained in the said 1st path | route set initially are compared as said 1st store. If the process is not terminated, the information system returns the control to S25A1. On the other hand, when ending the process, the total amount of merchandise and the total amount (γ) of the transportation cost are obtained through the current first route (S25A6).

  FIG. 15 shows a processing example in which a second route is created by switching between a store included in the current first route and a store not included in the first route, and a route that can reduce the total amount is searched ( (Details of S25B in FIG. 13) are shown. In this process, the information system selects a specific store (first store) included in the current route (first route) (S25B1). This selection procedure is the same as the selection procedure for the first store in S29 of FIG.

  Next, instead of purchasing the product at the selected store, the information system changes the purchase to the store with the next lowest price (alternative store) among other stores not included in the channel for selling the product. The second route is created (S25B2). The CPU 31 of the information system that executes the process of S25B2 corresponds to the second setting unit.

  In this case, when a plurality of products are scheduled to be purchased at the first store, a store that is not included in the route for selling the product at the lowest price for at least one product is set as the substitute store. Then, the product that was planned to be purchased at the first store other than the product may be purchased at the store that sells at the lowest price among the stores and alternative stores included in the second route.

  Further, a route excluding the first store is obtained from the first route, and a route to the alternative store is inserted into any section in the route. In that case, the route to the alternative store is selected by selecting the section where the increase in the transportation cost due to the route insertion to the alternative store is minimized.

Then, this information system calculates the difference (increase) in the total amount of products when purchased at an alternative store and a store on the route without making a purchase at the first store on the first route. To do. Further, the difference between the total amount of the products is compared with the difference (decrease) in the transportation cost due to the change of the first store to the alternative store (S25B3). And when the difference (reduction amount) of transportation expenses is large, this information system changes the 2nd path | route which changed the 1st store from the path | route into an alternative store again, and makes it a 1st path | route (S25B4). The CPU 31 of the information system that executes the process of S25B4 corresponds to a means defined as the first path.

  Next, the information system determines whether or not to end the process (S25B5). This determination is the same as S25A5 in FIG. And when not complete | finishing a process, this information system returns control to S25B1. On the other hand, when ending the process, the total amount of merchandise and the total amount (δ) of transportation expenses are obtained on the current first route (S25B6).

  As described above, according to the process of FIG. 13, before the difference is compared in S26A, the process of S25A and S25B, that is, the search process for reducing the total price of the purchase price of goods and the transportation cost is performed. Executed. Therefore, although the amount of calculation increases compared with the process of FIG. 9, it is possible to recommend a route through which shopping can be performed at a lower price than the process of FIG.

  Furthermore, in the process of FIG. 14, a search process is performed to reduce the total amount of merchandise purchases and transportation costs by reducing stores. Further, in the process of FIG. 15, a search process for reducing the total purchase price of goods and the transportation cost is executed by exchanging the shops included in the route and the shops not included in the route. Therefore, the amount of calculation increases as compared with the case of FIG. 9, while further search processing is performed to reduce the total purchase price of goods and transportation costs.

  In the processes of FIGS. 13 to 15, a search for reducing the shops to be visited is executed once in the process of FIG. 14, and a search for replacing the shops is performed by the process of FIG. That is, in the process of FIG. 15, a store that is not included in the current route is used as an alternative store for replacement of the store. However, instead of such processing, the processing of FIG. 14 and FIG. 15 may be executed by the same repeated processing. For example, the processing shown in FIG. 14 is not executed, and instead of the store included in the current route and the store not included in the current route may be selected as the alternative store in the processing of FIG.

  In other words, it is identified whether or not the route includes another store (second store) that sells products that were planned to be purchased at one store (hereinafter referred to as the first store) included in the route. Select without. This selection is made from a store included in the shopping range.

  Then, when the selected second store is included in the current route, the first store is excluded and a new route is created, and when the second store is not included in the current route, The second store is added to any section of the route that excludes the first store from the route. Then, a new route that minimizes the increase in transportation costs due to the addition may be set. What is necessary is just to compare with the present route and a new route about the purchase amount of goods in such a route, and the total amount of transportation expenses. Then, by repeating such comparison, it is possible to execute a search for reducing the total purchase price of goods and transportation costs compared to the current route.

In the above embodiment, when the single store shopping cost (α) is lower than the cyclic total value (β), the shopping at the single store that becomes the single store shopping cost (α) is recommended. However, instead of such processing, the limit of the difference between the single store shopping cost (α) and the cyclic total value (β) that the user can endure may be registered in the personal information database 43. The limit of such difference may be received in advance from the user through the input device 34. And even if the single store shopping cost (α) exceeds the cyclic total value (β), this information system recommends shopping at a single store if the difference is below the set limit. do it. In this way, if the amount of increase can be tolerated by the user, it can be purchased at a single store, saving time and not having to visit multiple stores. That is, when the user selects which of the shopping cost savings and the trouble of going around a plurality of stores to be prioritized, the condition can be quantitatively determined to support the user's decision making.

  For a store with a home delivery service, a home delivery fee may be used instead of transportation costs. In other words, in the calculation of the total amount of product purchases and transportation costs, for stores handling home delivery, the purchase amount of products and home delivery charges are added, and the same processing as in FIGS. 6 and 13 is executed to support shopping. May be. The procedure is basically the same as FIG. 6 and FIG. 13 although there is a difference that the delivery fee is added to the transportation cost for evaluation instead of setting the transportation cost to the store to zero.

<Example 1>
An embodiment according to the information processing system will be described with reference to FIGS. FIG. 16 is an example of a map showing an area where the family A is located. This map shows the positions of family A's home, store A, store B, and store C. The location of the store A is indicated by the letter A in a circle. The same applies to other shops. Furthermore, roads and roads from the home of the family A to the shops A, B, and C are shown. Here, the stores A, B, and C are stores extracted from a range located within a distance (shopping range) that the family A can accept among the stores registered in the map database 42.

  Further, in FIG. 16, a simplified version of the shopping list is shown. Buy 3 onions, 2 long onions, 3 bunch of spinach, 3 packs of foreign shiitake (300 grams), 1 pack of coffee, 2 packs of chicken leg (200 grams), 1 pack of eggs (10) .

  Here, a car is used as a transportation. In this example, a vehicle with a fuel consumption of 6 km per liter of gasoline is used. The gasoline price in this region is currently 120 yen per liter. Therefore, for example, it requires 5/6 liters from the home of family A to store A, and when converted to a gasoline price, the transportation cost is 100 yen. The same calculation is performed for the store B, the store C, etc. from home. These transportation costs are calculated by a computer program of the information system.

  FIG. 17 shows the result (referred to as “shopping list price table”) of calculating the total price of the purchase price of goods and transportation costs when all the goods on the shopping list are purchased at each store. For example, in the case of the store A closest to the family A, the purchase price of the product is 3870 yen, the transportation cost is 200 yen for the round trip, and the total price is 4070 yen. Similarly, the total amounts of 4310 yen and 4480 yen are calculated for stores B and C.

  On the other hand, in FIG. 17, the row indicated by Min indicates the result of calculating the purchase price of the product and the transportation cost when the store that sells the cheapest product is visited (traveling total value β). For example, the onion price of 80 yen for store B is the cheapest, and if you purchase 3 items from the shopping list, it will be 240 yen. In addition, for the green onions (overseas production), the unit price of 50 yen for store A is the cheapest, and two items in the product list are purchased for 100 yen. The same applies to other products. Therefore, the total amount of merchandise purchases over the cheapest stores is 3300 yen.

  In addition, the transportation cost is a one-stroke route that passes through stores B and C only once, such as family A's home, store A, store B, store C, store A, and family A's home. 33km, 33/6 liters of gasoline are required, and the transportation cost is 660 yen in total for the return trip. Therefore, the total amount (β) of the route around the lowest price is 3960 yen.

  FIG. 18 shows an example of further reducing the transportation expenses by reducing the number of shops on the route in this case. In the result of FIG. 17, the total amount (β) of the route for the lowest price is 3960 yen, and in the determination of S26 of FIG. β) is cheap.

  Accordingly, processing for reducing stores on the route of S28-S30 is executed. In the example of FIG. 18, an example is shown in which the store C is excluded from the route for visiting the store of the lowest priced product indicated by Min. In this case, since the coffee B, which was scheduled to be purchased at the store C, is changed to the store A, the purchase price of the product increases by 110 yen. On the other hand, by not visiting the store C, the round trip distance is 24 km, and the transportation cost is 480 yen, which is a reduction of 180 yen. As a result, by excluding the store C, the total amount is reduced by 70 yen, and the total of the cheapest product store and transportation expenses can be reduced to 3890 yen.

<Example 2>
An embodiment according to the information processing system will be described with reference to FIG. In FIG. 19, the number of purchases is changed compared to the case of FIG. That is, the long onion (overseas production) is changed from 2 to 3, the spinach is changed from 3 bundles to 1 bundle, and the eggs are changed from 1 pack to 6 packs. Also in this case, by the processing of this information system illustrated in FIG. 6, the store C is excluded from the route for visiting the store of the lowest price product, and the total price of the purchase price and the transportation cost of the lowest price product is 3960 to 3890. The amount has been reduced to yen.

<Example 3>
A third embodiment of the information system will be described with reference to FIGS. 20 and 21. FIG. FIG. 20 is a diagram illustrating the locations on the map of the homes of the family B and the stores A, B, and C located in the permissible range, and the roads. Here, the car to be used is set in the personal information database 43 so that it can travel 12 km per liter of gasoline. The gasoline price is 120 yen per liter and 10 yen per km.

  FIG. 21 shows an example of the shopping list price table of the present embodiment. Here, the shopping list in the example of FIG. 20 and the total price (α) of the purchase price and the transportation cost of the products when all are purchased at each store, and the product on the route that goes around the store of the cheapest product The total amount (β) of the purchase price and the transportation cost is shown.

  In this case as well, the total amount (β) for visiting the store of the cheapest product is 3690 yen, which can be purchased at a lower price than purchasing at each store alone. However, in this example, even if the store C is excluded from the route for visiting the store of the cheapest product, the difference (decrease) in transportation costs is smaller than the difference (increase) in the purchase price of coffee. For this reason, by excluding the store C, the total amount (β) for visiting the store of the cheapest product increases to 3740 yen and cannot be reduced.

<< Second Embodiment >>
In the first embodiment, the processing of the information system has been described on the assumption that the user leaves the home and returns to the home. In the present embodiment, an information system that supports a user when visiting a store from a destination and shopping efficiently will be described. Other configurations and operations are the same as those in the first embodiment. Therefore, the same components as those in the first embodiment are denoted by the same reference numerals, and the description thereof is omitted. Moreover, since the system configuration is the same as that of the first embodiment, the drawings of the first embodiment are referred to as necessary.

  FIG. 22 is a flowchart showing processing of the information system according to this embodiment. In the present embodiment, the information system accepts input of information regarding the destination point and input of information regarding the end point, and registers them in the personal information database (S19). The CPU 31 of the information system that executes this process corresponds to coordinate input means.

The destination is, for example, a geographical position where a shopping route is desired to start, such as a place of work or a claim, other than at home. The information regarding the destination point is an address, latitude, longitude, etc. indicating the geographical position of the destination. The end point is basically home. However, points other than home, for example, work place, business trip place, etc. may be designated as the end point of the shopping route.

  Next, the information system calculates the distance from the store to each store and from each store to the end point (usually home) (S20A). This process is different from the process of S20 in FIG. 6 in that the departure point is a destination and a user-desired end point is specified including points other than home. However, the processing procedure is the same as S20. The processing after S21 is the same as in the case of FIG. Moreover, you may perform the process of FIG. 13 as a process after S21.

  As described above, according to the present information system, it is possible to accept input of a destination point and an end point desired by the user, and to support efficient shopping on the route to the destination point, the store, and the end point.

  Note that in the process of S19 in FIG. 22, an input of a relay point may be received and registered in the personal information database. The CPU 31 of the information system that executes this process corresponds to means for receiving an input of a relay point. And in the process of S21, you may add the calculation process of the distance between a store and a relay point with the calculation of the distance between stores. Then, processing that always passes through the relay point may be executed in the middle of the route from the destination point through the store to the end point.

  In this case, the relay point may be a store that purchases the corresponding product, or may be a geographical location unrelated to shopping (for example, a store that has no product to be purchased). By setting it as such a process, the user's activity of completing other errands during shopping can be supported. Other errands include, for example, business trips, customers, hospitals, government offices, banks, schools, etc.

<Example 4>
Based on FIG. 23 and FIG. 24, the Example of the shopping assistance by this information system is shown. FIG. 23 is a diagram illustrating a map location, store location (see destination POINT), and route of the stores A, B, and C located in the home of the family C and the shopping range thereof. Here, the car to be used is set in the personal information database 43 so that it can travel 12 km per liter of gasoline. The gasoline price is 120 yen and 10 yen per km.

  This information system handles destination points in the same way as stores. That is, based on the distance between the destination, home, and other shops (see FIG. 9), the transportation cost of each section is calculated. In this example, the distance between the home and the destination point is 9 km, and 90 yen (see H => D) is calculated. Further, for example, the distance from the store A to the destination point is 10 km, and 100 yen is calculated (see A => D).

  FIG. 24 shows a shopping list price table of the present embodiment. That is, the shopping list in the example of FIG. 23, the total amount of the purchase price of the product and the transportation cost when all the purchases are made at each store, and the purchase price of the product on the route that goes around the store of the cheapest product The total amount (β) with transportation costs is shown. Here, since the handling of the shopping list is the same as that in the embodiment 1-3, the description thereof is omitted.

  In this case as well, the total amount (β) for visiting the store of the cheapest product is 3040 yen, which can be purchased at a lower price than purchasing each store alone.

On the other hand, the distance from the destination point to the family C's home via the store C (or store A), the store A (or store B), and the store B is 28 km, and the transportation cost is 280 yen. . In addition, when the store C is excluded, the increase in the product price is 90 yen for onions and 220 yen for shiitake (domestic), for a total of 310 yen. Further, when visiting Store A and Store B without visiting Store C and returning to the home of Family C, the distance is 19 km, and the reduction in transportation expenses is 90 yen.

  In addition, when the store A is excluded, the increase in the product price is 90 yen for the long onion (overseas production) and 90 yen for the shiitake (overseas production), totaling 180 yen. Further, when visiting Store C and Store B without visiting Store A and returning to the home of Family C, the distance is 23 km, and the reduction in transportation expenses is 50 yen. In any case, in this case, there is no merit of reducing the transportation cost by narrowing down the shops to be visited.

  The information system executes the above-described route evaluation according to the processing flow of FIG. 22, and stores C (or store A), store A (or store B), store B from the destination point indicated by Min in FIG. It is recommended to purchase at the cheapest store on the route to return to the home of the family C via.

<< Third Embodiment >>
In this embodiment, when there is a time service in each store, an information system is described that reflects the user's visitable time, determines the product price, and supports efficient shopping. Here, the time service refers to a service that reduces a price to a plurality of product groups at a uniform discount rate or discount amount in a time zone of a specific date and time.

  The information on the time service can be acquired from, for example, the contents of newspaper insert advertisements or IC tag record information attached to insert advertisements. Moreover, you may obtain from the website on the internet.

  The acquired time service information is stored in the store product information database 41 for each store. This time service information is recorded as information for identifying a store, a time zone of the date and time when the time service is performed, a product group to which the time service is applied, and a discount rate or discount amount.

  FIG. 25 is an example of a shopping list price table created based on the store merchandise information database 41 including such time service information. In this example, for example, onions are sold at Shop C for 10 yen (usually 50 yen) every day from 16:00 to 17:00, and Shiitake is sold at Shop A every day from 17:00 to 18:00 for 20 yen ( It is recorded that it is usually sold at 100 yen).

  FIG. 26 is an example of a shopping list amount table when the store cannot be visited during the time service period. In this example, since the store C cannot be visited during the time zone from 16:00 to 17:00, the amount of time service related to the store C is not included in the shopping list amount table. This information system supports shopping based on this shopping list price list.

  27 and 28 show the processing flow of the information system that realizes such processing. FIG. 27 is a flowchart showing a shopping list price table creation process when visiting a single store. This process is a modification of the process of S23 of FIG. 6 to determine the time service. When visiting a single store, if the user's shopping time zone is fixed, the visit time of the store is clear.

  Therefore, the information system first receives an input of a shopping time zone from the user (S231). The CPU 31 of the information system that executes this process corresponds to a means for receiving time zone input.

  Next, the information system executes the following processing for each store. That is, the information system reads the sales price of the product of the store and the information of the time service from the store product information database 41. Here, the information of the time service includes a time zone of the date and time when the time service is implemented, an applicable product group, a discount rate, a discount price, and the like.

  Then, the information system determines whether or not the user can reach the store during the time period when the time service is performed (S233). This process should just compare a user's shopping time slot | zone with the time slot | zone when time service is implemented. Alternatively, the travel time may be calculated from the distance from the user's home to the store, and the time that can be reached at the store may be obtained.

  When the user can reach the store during the time service is implemented, the information system sets the price of the product to which the time service is applied in the shopping list price table at the time service price. (S234). In addition, what is necessary is just to set a normal price to a shopping list amount table | surface about the goods to which time service is not applied.

  On the other hand, if the user cannot reach the store during the time service is performed, the information system sets the price of the product to which the time service is applied in the shopping list price table at a normal price ( S235).

  Then, the information system determines whether or not the processing has been completed for all stores in the search range (S236). If an unprocessed store remains in the search range, the present system returns control to S232. On the other hand, when the processing of all the stores in the search range is completed, the information system ends the creation of the shopping list amount table when visiting each single store. Thereafter, as in the case of the first embodiment, the transportation cost of each store and the total amount of the shopping list (single store shopping cost α) may be calculated.

  FIG. 28 is a flowchart showing a shopping list price table creation process when a plurality of shops are visited. This process is a modification of the process of S25 of FIG. 6 in order to determine the time service. When patroling a plurality of stores, even if the user's shopping time zone is fixed, the visit time of each store is shifted due to movement. Therefore, it is necessary to determine the traveling route and determine whether the time service is applied to each store including the travel time.

  In this case, in this embodiment, the visit time zone of the one store that should be given the highest priority is first fixed. That is, a schedule is set for a store that is assumed to have the greatest discount effect by the time service (hereinafter referred to as a priority store) during a time service period. The CPU 31 of the information system that executes this process corresponds to priority store selection means.

  For other stores on the route (referred to as non-priority stores), the visitable date and time is calculated from the order relationship with the priority stores, and it is determined whether or not the application of the time service can be applied. Here, the description will be made assuming that the user has already input the shopping time zone (for example, the processing of S231 in FIG. 27).

  First, the information system sets a route for visiting the cheapest store (S252). For this setting, as described in the processing of S25 in FIG. 6 in the first embodiment, a procedure for obtaining an approximate solution of the traveling salesman problem can be applied.

  Then, the present system selects a priority store to be given priority in the route, and sets its visit time. Specifically, the visit time zone of the priority store is overlapped with the time service time zone (S253). For example, the time of the priority store time service is set to times T1 to T2.

  Next, the information system calculates a visit time of another store on the route, that is, a non-priority store (S254). Specifically, the arrival time and departure time for the non-priority store on the route are obtained by varying the arrival time of the user at the priority store and the end time of leaving the priority store within the range of T1 to T2 (S254). ). The CPU 31 of the information system that executes this process corresponds to means for calculating the visit time.

  At this time, for example, the average stay time ΔT at the user's store is used as the stay time at each store. The average stay time ΔT at the user's store may be recorded in the personal information database 43.

  And this information system performs the following processes with respect to each store on a path | route. That is, the information system reads information on the time service of the currently processed store from the store product information database 41. Then, the information system determines whether or not the user can reach the store during the time period when the time service is performed (S256). When the user can reach the store during the time service is implemented, the information system sets the price of the product to which the time service is applied in the shopping list price table at the time service price. (S257). In addition, what is necessary is just to set a normal price to a shopping list amount table | surface about the goods to which time service is not applied.

  On the other hand, if the user cannot reach the store during the time service is performed, the information system sets the price of the product to which the time service is applied in the shopping list price table at a normal price ( S258).

  Then, the information system determines whether or not the processing has been completed for all stores in the search range (S259). When an unprocessed store remains in the search range, the present system returns the control to S255. On the other hand, when the processing of all the stores in the search range is completed, the information system calculates the total amount (β) of the purchase amount of the product and the transportation cost when shopping at each store according to the route. (S25A).

  Thereafter, the information system may search for an efficient shopping route by, for example, the same processing as that after S26 in FIG. Moreover, you may perform the process similar to after S25A of FIG. If the number of stores on the route changes, the visit time of each store may be calculated again in the same procedure as in FIG. 28, and the applicability of the time service may be determined again.

  As described above, according to the present embodiment, it is possible to appropriately select a store and a route to be purchased from the relationship between the shopping time zone of the user and the date and time of the time service of each store, thereby supporting the user's shopping. .

<< 4th Embodiment >>
An information system according to the fourth embodiment of the present invention will be described with reference to FIGS. In the present embodiment, an information system that supports a user's shopping will be described in consideration of the weight, volume, etc. of the product as well as the price of the product, transportation costs, and the like.

  For example, when visiting a store and purchasing a product, even if the product is inexpensive, no matter how much the product is cheap, if you purchase a lot of heavy items, if you move on foot or by bicycle, then Is inconvenient to buy. The same applies when purchasing a product with a large volume.

Therefore, in the present embodiment, the concept of weight moving distance is introduced as an evaluation index for shopping including a heavy product. The weight movement distance amount corresponds to a value obtained by integrating the weight of the purchased product and the movement distance after the purchase. In the present embodiment, a plurality of routes are prepared in which the sum of the purchase price of goods and the transportation cost is not more than a predetermined limit. Of these routes, it is recommended to shop on the route with the smallest weight movement distance. For this evaluation, the store product information database 41 stores the weight for each product.

  In the case where the volume is taken into account, similarly, the volume movement distance amount may be calculated. The volume movement distance amount corresponds to a value obtained by integrating the volume of the purchased product and the movement distance after the purchase. Hereinafter, such an index is referred to as an option index.

  FIG. 29 shows the entire processing flow of the information system. This process is a modification of FIG. 13 of the first embodiment. In this process, S20 to S25 are the same as those in FIG.

  When searching for a route by reducing the number of stores included in the route, the information system obtains a plurality of routes in which the total of the purchase price of goods and the transportation cost is not more than a predetermined limit without narrowing down to one route (S25C). ). This process can be realized by storing all the routes in which the sum of the purchase price of goods and the transportation cost is equal to or less than a predetermined limit in S25A process of FIG. 13 of the first embodiment. In this case, the predetermined limit may be received and stored, for example, by a user setting. The CPU 31 and the memory 32 of the information system that executes this processing correspond to the path storage means.

  This limit is, for example, a numerical value corresponding to today's budget. For example, a semi-fixed default value is stored in the personal information database 43 so that the user can input the budget according to the budget of the day when the information system is used, and change the budget. Just keep it.

  In addition, the information system searches for a plurality of routes where the total amount can be reduced by replacement with a store not included in the route (S25D). This process can be realized by storing all the routes in which the sum of the purchase price of goods and the transportation cost is equal to or less than a predetermined limit in the S25B process of FIG. 13 of the first embodiment.

  Then, a route to be selected is determined from the plurality of routes obtained as a result of S25C and S25D using an option index, and the total price (γ) of the lowest price product and transportation cost is calculated for the route (S25E). Subsequent processing is the same as in the first embodiment.

  FIG. 30 shows a flowchart of processing for selecting a route based on the weight movement distance when the weight condition is adopted as the option indicator.

  In this process, the information system performs the following evaluation for all the currently stored routes. That is, the information system calculates the weight (W) of the product purchased at the store currently being processed (S25E1). This process may be performed by referring to the store product information database 41 and determining the weight of the product to be purchased.

  Then, the information system calculates a distance (D) from the current store to the end point after the store (S25E2). Then, the information system multiplies the weight (W) and the distance (D) and adds up to the weight moving distance (T) (S25E3). The CPU 31 of the information system that executes this process corresponds to a means for calculating the integration location.

Then, the information system determines whether or not the processing of all stores on the currently processed route has been completed (S25E4). If there is a store that has not yet been processed in the current route, the information processing system refers to the store next to the current route (S25E5). And this information system returns control to S25E1.

  On the other hand, when the processing of all stores on the route currently being processed is completed, the information system stores the integrated value (T) of the weight movement distance amount for the current route (S25E6). Next, the information system determines whether or not the processing has been completed for all routes (S25E7).

  When there is a route that has not yet been processed, the information system refers to the next route and refers to the first store of the route. And this information system returns control to S25E1. On the other hand, when all the routes have been processed, the information system selects a route having the smallest integrated value (T) of the weight movement distance amount among the stored routes (S25E9). Then, for the selected route, the sum (γ) of the price of the cheapest product and the transportation cost is calculated (S25EA).

  Thus, according to this information system, the order of shopping can be supported so that the moving distance of a heavy product is minimized.

  FIG. 31 is a flowchart illustrating a process of selecting one of a plurality of routes according to the volume movement distance amount instead of the weight movement distance amount. In this process, as compared with FIG. 30, the volume (V) is referred to instead of the weight of the product (S25F1), the volume movement distance (U) is integrated (S25F3), and the volume movement distance ( U) is saved (S25F6). The CPU 31 of the information system that executes this process corresponds to a means for calculating the integration location.

  Then, the route with the smallest integrated value (U) of the volume movement distance is selected (S25F9). Other processes are the same as those in FIG. According to this information system, it is possible to support the order of shopping so as to minimize the moving distance of a product having a volume.

  FIG. 32 is a flowchart showing a process of selecting a route in a priority order designated by the user from a plurality of indices such as a weight movement distance amount, a volume movement distance amount, and a discount amount (or discount rate) by a time service. In this process, the information system accepts a user's designation through the input device 34 and the display device 35, and determines an index to be prioritized (S51). Indicators that should be prioritized are, for example, weight, volume, and shopping costs.

  Then, the information system determines whether or not the user's designation is designation that prioritizes the weight condition (S52). When giving priority to the weight condition, the information system selects a route having a small weight movement distance amount from a plurality of stored routes (S53).

  If the weight condition is not prioritized, the information system determines whether the user designation is designation prioritizing the volume condition (S54). When giving priority to the volume condition, the information system selects a route having a small volume movement distance amount from the plurality of stored routes (S55).

  Further, when the volume condition is not prioritized, the information system selects a route with a smaller total price of the lowest priced commodity and transportation cost (S56). Then, the information system calculates the sum of the lowest priced product and the transportation cost in the selected route (S57).

  FIG. 33 is a flowchart showing a process of selecting a route by designating a weight movement distance amount, a volume movement distance amount, a discount amount by a time service, or an allowable limit of a discount rate.

In this process, the information system accepts a user's designation through the input device 34 and the display device 35, and accepts input of allowable values for indicators such as weight, volume, shopping costs, discount conditions, etc. (S61). The allowable weight value may be determined using the weight movement distance calculated in FIG. For example, a setting such as a limit may be accepted for moving a 10 kg baggage for 1000 meters or more. Further, the volume allowable value may be based on the volume moving distance calculated in FIG. For example, it is only necessary to accept a setting such as a limit for moving a 10-L package over 1000 meters.

  As for the allowable value of the shopping cost, for example, the shopping budget for today may be set to a limit of 4500 yen. As a discount condition, the total shopping cost or the discount rate may be used as an index. For example, in today's shopping, the discount rate is at least 2 percent for all purchased items. Also, the discount amount for today's shopping is 1000 yen.

  Then, the information system calculates the weight movement distance amount for each stored route. Then, a route that does not satisfy the allowable limit is excluded from those routes, and a filter is applied to the route (S62). As a result, when there is no remaining route that satisfies the allowable limit (NO in S63), the information system prompts the input of the allowable value of the weight movement distance amount again (S64). And the process of S62 and S63 is repeated with the tolerance value input again.

  When a route that satisfies the allowable limit remains (YES in S63), the information system calculates a volume movement distance amount for the route. Then, a route that does not satisfy the allowable limit is excluded from those routes, and a filter is applied to the route (S65). As a result, when there is no remaining route that satisfies the permissible limit (NO in S66), the information system prompts the input of the permissible value of the volume movement distance amount again (S66). And the process of S65 and S66 is repeated with the tolerance value input again.

  If a route that satisfies the allowable limit remains (YES in S66), the information system calculates the total price of the price and transportation cost of the product to be purchased (S68).

  Then, it is determined whether or not the total amount satisfies the allowable limit (S69). As a result, when there is no remaining route that satisfies the allowable limit (NO in S69), the information system prompts again for the input of the allowable shopping cost (S6A). And the process of S68 and S69 is repeated with the tolerance value input again.

  If a route that satisfies the allowable limit remains (YES in S6B), the information system calculates discount conditions such as a discount amount and a discount rate of the time service applied to the product to be purchased (S6B). ). Then, it is determined whether or not the discount condition satisfies an allowable limit (S6C). As a result, when there is no remaining route that satisfies the permissible limit (NO in S6C), the information system prompts the user again to enter the permissible value for the discount condition (S6D). And the process of S6B and S6C is repeated with the tolerance value input again.

  If a route that satisfies the allowable limit remains (YES in S6C), the information system calculates the total price of the lowest-priced product and transportation cost for the route.

  As described above, the information system applies a filter from a plurality of routes depending on whether or not an index such as weight, volume, shopping cost, discount condition, or the like is an allowable limit. Then, a route in which a plurality of indices are the user's allowable limit is selected. When a plurality of routes remain as a result of applying the filter, the determination is made with the user's priority index. For example, a route with the smallest total purchase price and transportation cost is selected (S6E). And this information system recommends the user to shop along the route. In this way, it is possible to support shopping along a route that satisfies a plurality of conditions set by the user.

FIG. 34 is a diagram illustrating a processing example for determining whether or not a purchased product is to be handled as a home delivery based on the weight of the product or the volume of the product. This process is executed as a pre-process of the process of FIG. 29, for example. In this process, the information system accepts an input of a limit index of a product to be taken home by shopping (S70). Here, the limit index is, for example, a weight limit or a volume limit.

  The information system refers to the store merchandise information database 41 and classifies the merchandise into home delivery and take-out. That is, this information system determines whether or not the processing of all corresponding stores in the store product information database 41 has been completed (S71).

  If all the stores have not been processed, the information system next determines whether or not all the products that can be purchased at the store have been processed (S72). When the processing of all the products is completed, the information system refers to the corresponding next store in the store product information database 41 (S73). And this information system returns control to S71.

  On the other hand, when the merchandise of the store being processed still remains in the determination of S72, the information system refers to the next merchandise (S74). And this information system judges whether the weight is beyond a limit about the goods (S75). If the weight exceeds the limit, the information system classifies the product as home delivery (S77).

  If the weight is not over the limit, the information system determines whether the volume or size of the product is over the limit (S76). If the volume exceeds the limit, the information system classifies the product as home delivery (S77).

If the weight, volume, or dimensions do not exceed the limits, the information system does not classify the merchandise as home delivery and is subject to normal shopping. Then, the information system returns the control to S71. In this way, since the merchandise handled as home delivery is delivered from each store, it is not necessary to stop at the store directly and remove it from the shopping route. The transportation cost can be calculated. Moreover, what is necessary is just to display on the display apparatus 35 with the shopping list which isolate | separated the goods for home delivery and the goods for normal take-away.

  As described above, according to the information system, products whose weight, volume, dimensions, etc. exceed the user's allowable limits can be classified as home delivery, a route can be created, and the user's shopping can be supported.

  In addition to the above conditions, the products may be simply filtered by the product origin. For example, in the store product information database 41, the place of origin is stored together with the product. This function is based on the premise that the origin of the product is clearly indicated in the advertisement information such as IC tag or the Internet, or that the information on the origin of the product in each store can be obtained by some other method. And

  Then, before creating the shopping list, the user may input the place of origin that the user wants to prioritize or want to exclude. In creating the shopping list, this information system may extract a price of a product by excluding a specific origin, for example, foreign products, and create a shopping list. Alternatively, the purchase price may be calculated from the price of the product excluding the place of origin.

<< 5th Embodiment >>
The shopping route created by the first to third embodiments described above may be transferred to the vehicle-mounted device. The transfer may be performed by the data transmission unit of the information system via the communication interface 37 of the information system and the wireless communication interface of the vehicle-mounted device, for example, by a user operation. Further, for example, route information may be output to a medium through an input / output device of a detachable recording medium and input to the vehicle-mounted device. The vehicle-mounted device may pass the route information to the car navigation system that guides the user according to the input route. For this purpose, a conversion unit that can convert the route information created by the information system into the same format that can be read by the car navigation system of the vehicle-mounted device may be provided. However, the format of the route information used in this information system may be matched with the format readable by the car navigation system of the vehicle-mounted device.

  The user's shopping support can be further strengthened by linking the information system and the vehicle-mounted device. Moreover, you may mount the information system itself shown in the said 1st Embodiment to 4th Embodiment in onboard equipment.

<Computer-readable recording medium>
A program for causing a computer or other machine or device (hereinafter, a computer or the like) to realize any of the above functions can be recorded on a recording medium that can be read by the computer or the like. The function can be provided by causing a computer or the like to read and execute the program of the recording medium.

  Here, a computer-readable recording medium is a recording medium that stores information such as data and programs by electrical, magnetic, optical, mechanical, or chemical action and can be read from a computer or the like. Say. Examples of such a recording medium that can be removed from a computer or the like include a flexible disk, a magneto-optical disk, a CD-ROM, a CD-R / W, a DVD, a DAT, an 8 mm tape, and a memory card.

  In addition, as a recording medium fixed to a computer or the like, there are a hard disk, a ROM (read only memory), and the like.

It is a block diagram which shows the function of an information system. It is a figure which shows the process outline | summary of an information system. It is a figure which illustrates the hardware constitutions of an information system. It is a figure which illustrates the structure of an IC tag. It is a figure which illustrates the structure of an IC tag reader / writer. It is an example of the structure of advertisement data in an IC tag. It is a figure which shows the processing flow of an information system. It is a figure which shows the example of the record of a store merchandise information database. It is a figure which shows the example of the record of point data. It is a figure which shows the example of road data. It is a figure which shows the example of a shopping list. It is an example of the nearest public transportation data. It is a figure which shows the example of public transport means expense data. It is a figure which shows the modification of the processing flow of an information system. It is a figure which shows the process example which searches the path | route which can reduce a total amount with the path | route which reduced the store. It is a figure which shows the example of a process which searches for the path | route which can create a 2nd path | route by replacement with the shop included in the present 1st path | route, and the shop not included in a 1st path | route, and can reduce the total amount of money. . It is an example of the map which shows an area. It is a figure which shows the shopping list amount table | surface which is a result of calculating the total amount of the purchase price of goods, and transportation expenses when all the goods of a shopping list are purchased in a shop. It is a figure which shows the example which reduces the transportation cost by reducing the shop on a path | route. It is a figure explaining the Example by an information processing system. It is a figure which illustrates an area. It is a figure which shows the example of a shopping list amount table. It is a figure which shows the process of the information system which concerns on 2nd Embodiment. It is a figure which illustrates an area. It is an example of a shopping list amount table. It is an example of the shopping list amount table created based on the store merchandise information database including time service information. It is an example of the shopping list amount table when the store cannot be visited during the time service period. It is a figure which shows the processing flow of the information system which concerns on 3rd Embodiment. It is a flowchart which shows the preparation process of the shopping list amount table | surface in the case of visiting a plurality of stores. It is a figure which shows the whole processing flow of the information system which concerns on 3rd Embodiment. It is a figure which shows the flowchart of the process which selects a path | route with a weight movement distance amount. It is a figure which shows the flowchart of the process which selects a path | route by volume moving distance amount. It is a flowchart which shows the process which selects a path | route in the priority order designated by a user among a some parameter | index. It is a flowchart which shows the process which selects the path | route, specifying the weight movement distance amount, the volume movement distance amount, the discount amount by time service, or the allowable limit of a discount rate. It is a figure which shows the process example which determines whether the goods purchased based on the weight of goods or the volume of goods are handled as home delivery.

Explanation of symbols

31 CPU
32 Memory 33 Hard Disk Drive 34 Input Device 35 Display Device 36 Removable Recording Medium Input / Output Device 37 Communication Interface 38 IC Tag Reader / Writer 39 OCR
40 Database 41 Store Product Information Database 42 Map Information Database 43 Personal Information Database 60 Processing Means 61 Purchase Information Input Means 62 Product Information Input Means

Claims (5)

A map information database including information for identifying a store and geographical location information of the store;
A transportation cost information database including information for identifying a transportation means used by a user and information indicating each usage fee of the transportation means in a unit of distance or a section of a section in which the transportation means can be used;
Product information input means for receiving input of product information including information for identifying a product provided in the store and a provision price of the product;
A product information database for storing product information input from the product information input means together with information for identifying the store;
Purchase information input means for receiving input of purchase information including information for identifying a product desired by the user and the desired quantity;
Processing means for performing arithmetic processing,
The processing means includes
Information for identifying a store that sells a product included in the input purchase information and a sales price of the product are extracted from the product information database, and the price is low when the product is sold at a plurality of stores. A store extracting means for extracting a store to be used for the purchase information by selecting a store;
First setting means for setting a first route from a predetermined point as a starting point to the predetermined store after visiting the extracted store once;
A transportation cost calculation means for referring to the transportation cost information database and calculating a transportation cost when following a route according to a distance of the route or a transportation cost for each section constituting the route;
An excluded store selecting means for selecting a first store to be excluded from stores included in the first route;
Of the stores other than the first store included in the first route, a store that sells a product that was planned to be purchased at the first store at the lowest price is replaced with the product instead of the first store. An alternative store assignment means to assign as an alternative store to purchase;
A comparison means for comparing an increase in the purchase amount of the product with a decrease in transportation costs by excluding the first store from the first route when the purchase is changed to the purchase at the alternative store;
Purchasing a product when a purchase total at the store included in the first route is the total of the purchase amount when the product is purchased and the transportation cost is calculated, and when the purchase is changed to the purchase at the alternative store When the increase in the amount is smaller than the decrease in the transportation cost, the purchase amount when the product is purchased at a store included in the second route excluding the first store from the first route, and the A first total calculating means for calculating a total traveling value that is a total with transportation expenses;
Single store purchase price calculation means for calculating a single store purchase price that is the total purchase price when all the products included in the purchase information are purchased in each of the stores located within a predetermined range from the user's location point When,
The sum of the purchase amount of the single store and the single store transportation cost, which is the transportation cost required to travel from the departure point to the one store and to the end point, is the total value at the smallest store. A second total means for calculating the minimum shopping cost of one store;
When the minimum shopping cost of the single store does not exceed a predetermined limit with respect to the cyclic total value, purchase of the product included in the purchase information at the single store that becomes the minimum shopping cost of the single store A shopping support system comprising: output means for displaying recommended information. The processing means includes
By sequentially changing the selected first store, the replacement store allocation by the replacement store allocation means, and the comparison between the increase in the purchase amount of the product and the decrease in the transportation cost by the comparison means. Repeating means, and
The shopping support system according to claim 1, further comprising: a confirmation unit that terminates the repetition by the repetition unit when a predetermined calculation state is reached. The processing means includes
Means for selecting a second store that sells merchandise that was planned to be purchased at the first store at stores not included in the first route;
When the second store is added to any section of the route excluding the first store from the first route, a second route that minimizes the increase in transportation cost due to the addition is set. A second setting means;
Means for calculating the purchase price of a product when the product is purchased at a store that sells the product included in the purchase information at a minimum price among the stores included in the second route;
The apparatus further comprises means for redefining the second route as the first route when the total of the purchase price of the product and the transportation cost is smaller on the second route than on the first route. Item 2. The shopping support system according to Item 1. The processing means includes
Means for selecting a third store that sells products that were planned to be purchased at the first store;
When the third store is included in the first route, the third route is created by excluding the first store, and when the third store is not included in the first route The third store is added to any section of the route excluding the first store from the first route, and a third route is set to minimize the increase in transportation cost due to the addition. Setting means;
Means for calculating the purchase price of a product when the product is purchased at a store that sells the product included in the purchase information at the lowest price among the stores included in the third path;
Means for redefining the third route as a route when the total of the purchase price of the product and the transportation cost is smaller in the third route than the first route;
Repetitive means for sequentially changing the first store and the third store to repeat the comparison of the cost including the purchase amount of the product and the transportation cost between the first route and the third route; ,
The shopping support system according to claim 1, further comprising: a determination unit that stops the repetition by the repetition unit when a predetermined calculation state is reached. A map information database including information for identifying a store and geographical location information of the store, information for identifying a means of transportation used by a user, and a usage fee for each means of transportation. In a computer comprising a transportation cost information database including information shown in units of available sections, and a product information database,
Receiving input of product information including information for identifying a product provided at the store and a provision price of the product;
Storing the input product information together with information for identifying the store in the product information database;
A purchase information input step for receiving input of purchase information including information for identifying a product desired by the user and the desired quantity;
Information for identifying a store that sells a product included in the input purchase information and a sales price of the product are extracted from the product information database, and when the product is sold at a plurality of stores, A store extraction step of extracting a store to be used for the purchase information by selecting a cheap store;
A first setting step of setting a first route to a predetermined end point after visiting the extracted store once each at a predetermined point as a starting point;
Referring to the transportation cost information database, and calculating a transportation cost when the route is followed according to the distance of the route or the transportation cost for each section constituting the route;
An excluded store selection step of selecting a first store to be excluded from stores included in the first route;
Of the stores other than the first store included in the first route, a store that sells a product that was planned to be purchased at the first store at the lowest price is replaced with the product instead of the first store. An alternative store assignment step to assign as an alternative store to purchase,
A comparison step of comparing an increase in the purchase amount of the product with a decrease in transportation costs by excluding the first store from the first route when changing to the purchase at the alternative store;
A total traveling value that is the sum of the purchase amount and the transportation cost when the product is purchased at a store included in the first route is calculated, and an increase in the purchase amount of the product is a decrease in the transportation cost. In the case where it is smaller, a cyclic total value that is the sum of the purchase amount and the transportation cost when the product is purchased at a store included in the second route excluding the first store from the first route is A first total calculating step of calculating;
Single store purchase price calculation step of calculating a single store purchase price that is the total purchase price when all the products included in the purchase information are purchased at each of the stores located within a predetermined range from the user's location point When,
The sum of the purchase amount of the single store and the single store transportation cost, which is the transportation cost required to travel from the departure point to the one store and to the end point, is the total value at the smallest store. A second total step of calculating a minimum shopping cost for one store;
When the minimum shopping cost of the single store does not exceed a predetermined limit with respect to the cyclic total value, purchase of the product included in the purchase information at the single store that becomes the minimum shopping cost of the single store A shopping support program for executing an output step for displaying recommended information.

Images