JP2018156213A - Shopping support system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a shopping support system which can accommodate needs of various customers in an integrated fashion.SOLUTION: In a shopping support system 1, an external terminal 3 for use on the outside of a shop 6, a shop terminal 4 for use on the inside of the shop 6, and a server 2 are connected via a network 5. An affiliate 7 logs into the external terminal 3, and a person 9 responsible for the shop logs into the shop terminal 4, and the external terminal 3 and the shop terminal 4 are configured so that they can be connected to each other in a moving image interaction system. The server 2 provides the external terminal 3 and the shop terminal 4 with a screen including an access button to the moving image interactive system, provides the shop terminal 4 with an acceptance registration screen 700 for registering acceptance information of an inquiry made via the moving image interactive system and a telephone, provides the external device 3 with an inquiry registration screen 500 for registering an inquiry about a commodity or a service, and stores information inputted via the acceptance registration screen 700 and the inquiry registration screen 500, as inquiry information.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a shopping support system that supports purchasing products such as stores at a customer's home or the like.

  2. Description of the Related Art In recent years, delivery services for accepting orders for products sold in stores and delivering them to customers' homes and the like have been widely used. For example, Patent Document 1 discloses a shopping system in which a customer can order a product while photographing a product display state in a store with a Web camera mounted on a shopping cart and checking a video of the Web camera via the Internet. ing.

Japanese Patent No. 5412457

  However, since it is difficult for elderly people who are not used to PCs (Personal Computers) and smartphones used for ordering to use the shopping system as disclosed in Patent Document 1, it is possible to respond by telephone or store employees. There is a need for staff members to come to their homes. On the other hand, customers who are used to PCs have a need to complete orders on the Internet.

  Furthermore, there is a need to place an order while actually checking the usage method in a home center that handles residential equipment and tools related to DIY (Do It Yourself).

  The present invention has been made in view of the above-described problems, and an object of the present invention is to provide a shopping support system that can respond to the needs of various customers in an integrated manner.

  The present invention for achieving the above-described object includes an external terminal that can be used outside a store and can use a video dialogue system, a store terminal that can be used inside the store and can use the video dialogue system, and a server. And the external terminal is used when a member of the store logs in on a login screen provided by the server, and the store terminal is connected to the login screen. The person in charge at the store logs in, the external terminal and the store terminal are configured to be connectable to each other in the video interaction system, and the server is connected to the external terminal and the store terminal. On the other hand, an access providing means for providing a screen including an access button to the video interactive system, and the store terminal On the other hand, a reception registration means for providing a reception registration screen for registering the reception information of the inquiry through the video dialogue system and the telephone, and an inquiry registration screen for registering the inquiry to the external terminal are provided. A shopping support system comprising: inquiry registration means for performing storage; and storage means for storing information input through both the reception registration screen and the inquiry registration screen as inquiry information. According to the present invention, it is possible to respond to the needs of various customers in an integrated manner.

  The storage means uses a reception number that uniquely identifies the reception information as a main key, a member number that uniquely identifies the member, a reception section that indicates a classification of the video interactive system and the telephone, and the inquiry information. A reception transaction table including a uniquely identified inquiry number, and the inquiry number as a primary key, including the member number, an inquiry content indicating the content of the inquiry, and an answer content indicating the content of the answer to the inquiry A database including an inquiry master table, and the reception registration means, upon receiving information input via the reception registration screen, adds a new record to the reception transaction table and the inquiry master table, When the inquiry registration means receives the information input via the inquiry registration screen, the inquiry master text In Bull may be to add a new record. As a result, information on queries made by various methods can be centrally managed by the query master table.

  The server provides an inquiry confirmation providing means for providing an inquiry history display screen for displaying a history of the inquiry master table relating to the member number of the logged-in member to the external terminal, and the store terminal. Inquiry answer providing means for providing an inquiry answer screen for adding the answer contents to the inquiry master table may be further provided. As a result, regarding inquiries made by various methods, the member can confirm the answer content on the same screen, and the person in charge can answer on the same screen.

  The database uses the member number as a primary key, the login date and time of the member, the logout date and time of the member, and a video dialogue flag indicating whether or not the member has pressed the access button to the video dialogue system, The access providing means activates an access button to the video dialogue system only when the member is logged in, and when the access button to the video dialogue system is pressed, The login history table is updated so that the moving image dialogue flag is turned on, and the server displays a login list for displaying information on the logged-in member and the moving image interaction flag on the store terminal. You may make it further provide the login list provision means which provides a screen. Thereby, even if it is a case where it cooperates with an external animation dialogue system, member 7 using animation dialogue can be specified.

  The database uses a product identification code for uniquely identifying a product as a main key, and a product master table including a product name of the product and a store classification code indicating a classification of the product in the store, and the store is uniquely identified The store code and the product identification code to be used as a main key, the store name indicating the name of the store, the handling classification indicating whether or not the product is handled in the store, the number of products in the store, the image of the product, A store product master table including product shelf allocation information, wherein the product master table stores data of both products handled in the store and products not handled in the store, The server further includes product search means for providing a product search screen for accepting a search for products to the external terminal, and the product search unit Receives a product search condition from the external terminal, performs a search by combining the product master table and the store product master table with the product identification code, and at least the product name, the store name, and the You may make it extract the handling classification, the said stock quantity, the said shelf allocation information, and the said image, and may transmit the data of the search result display screen which displays a search result to the said external terminal. As a result, the member can search for products that are not handled in each store, which improves convenience.

  The product search means may include a message for inquiring in the data on the search result display screen when there is no shelf allocation information in the store product master table. As a result, the member can be notified that the product needs to be inquired.

  According to the present invention, it is possible to provide a shopping support system capable of responding to various customer needs in an integrated manner.

The figure which shows the outline of shopping support system 1 Example of member master table 100, person in charge master table 110, member person in charge master table 120, and store master table 130 Examples of product master table 140, store product master table 150, classification conversion master table 160, and standard product master table 170 An example of the reception transaction table 180, the inquiry master table 190, the product list table 200, and the login history table 210 Example of screen transition of shopping support system 1 Examples of product search screen 400 and search result display screen 420 Example of inquiry registration screen 500 Example of inquiry history display screen 600 Example of reception registration screen 700 Example of inquiry list screen 800 An example of an inquiry response screen 900 An example of the login list screen 1000

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. First, an outline of the shopping support system 1 in the embodiment of the present invention will be described with reference to FIG.

  FIG. 1 is a diagram showing an outline of the shopping support system 1. As shown in FIG. 1, in the shopping support system 1, an external terminal 3 used outside the store 6, a store terminal 4 used inside the store 6, and the server 2 are connected via a network 5. .

  The server 2, the external terminal 3, and the store terminal 4 are a CPU (abbreviation of “Central Processing Unit”) as a control unit, a memory as a main storage unit, an HDD (abbreviation of “Hard Disk Drive”) as an auxiliary storage unit, A flash memory, a liquid crystal display as a display unit, a keyboard and mouse as an input unit, a touch panel display, and the like are included. The server 2 further includes a LAN (Local Area Network) cable as a wired communication unit. The external terminal 3 and the store terminal 4 further include a wireless module as a wireless communication unit and a camera as a moving image capturing unit.

  An HDD (abbreviation of “Operating System”), an application program, data necessary for processing, and the like are stored in the HDD or flash memory serving as an auxiliary storage unit. The CPUs of the server 2, the external terminal 3, and the store terminal 4 read out the OS and application programs from the auxiliary storage unit, store them in the main storage unit, control other devices while accessing the main storage unit, and will be described later. Execute. The server 2 is, for example, a server computer disposed in a data center or the like, and may be realized by a single casing or may be realized by a plurality of casings. The external terminal 3 and the store terminal 4 are, for example, a tablet terminal or a notebook PC. The network 5 is, for example, the Internet.

  A web application program provided as the shopping support system 1 is installed in the auxiliary storage unit of the server 2, and a database necessary for the shopping support system 1 is constructed.

  In the auxiliary storage unit of the external terminal 3 and the store terminal 4, a web browsing software program is installed and a program on the terminal side of the video interactive system is installed. The moving image interaction system is a system capable of at least one-to-one moving image interaction, for example, a web conference system or an Internet telephone system having a video call function. The external terminal 3 and the store terminal 4 are configured such that a web application applied by the server 2 can be used by a function of web browsing software. Further, the external terminal 3 and the store terminal 4 are configured such that the moving picture interactive system can be used by the function of the program on the terminal side of the moving picture interactive system. And the external terminal 3 and the shop terminal 4 are comprised so that a mutual connection is possible in a moving image dialogue system. The moving image dialogue system may be constructed independently or a commercially available system may be used.

  The business types of the store 6 are a home center, a supermarket, a drug store, a department store, a home appliance mass retailer, and other specialty stores. The shopping support system 1 may be used jointly by a plurality of stores 6 in the same series. The member 7 is a customer who has performed member registration in the shopping support system 1, member registration such as a point card in the store 6, member registration on an EC (Electric Commerce) site operated by the store 6, and the like. The sales representative 8 is an employee of the store 6 and is mainly in charge of outside sales and delivery. The store manager 9 is an employee of the store 6 and is mainly in charge of customer service, product management, etc. in the store 6.

  The sales representative 8 carries the external terminal 3 and visits the home or office of the member 7 and asks the member 7 about the purchase of the product. At that time, the member 7 logs in from the login screen provided by the server 2 by using his / her membership number and password, and uses the external terminal 3. In addition, the member 7 can log in from the login screen provided by the server 2 by his / her own PC, tablet terminal, smartphone, etc. in addition to the external terminal 3 carried by the sales person 8.

  As described above, the external terminal 3 and the store terminal 4 are configured to be connectable to each other in the moving image dialogue system. Therefore, the member 7 can order the product even at home or the like while confirming the actual product through the moving image dialogue system or having the store staff 9 demonstrate how to use the product.

  Although details will be described later, the server 2 is configured to centrally manage both inquiries via a moving image interactive system, a telephone, and the like and inquiries via an inquiry registration screen provided by the server 2. In other words, in the shopping support system 1, the member 7 who is not used to a PC or the like performs inquiry processing via the video dialogue system using the external terminal 3 carried by the sales representative 8 or the telephone, and the PC or the like. For the member 7 who is used to the above, an inquiry registration screen provided by the server 2 or an inquiry via mail is performed, and information related to the inquiry is managed centrally. Therefore, it becomes possible to respond to the needs of various customers in an integrated manner.

  Next, details of the tables included in the database constructed in the storage unit of the server 2 will be described with reference to FIGS.

  FIG. 2 is an example of the member master table 100, the person-in-charge master table 110, the member person-in-charge master table 120, and the store master table 130.

  The member master table 100 is a table that holds information about the member 7. The member master table 100 shows, for example, the member number 101 for uniquely identifying the member 7, the member 102 name 102, the login password 103 for the member 7, and the store 6 where the member 7 has registered as a member. Contract store code 104. In addition, the member master table 100 may include personal information such as an address, a telephone number, and sex, and information on hobbies.

  The person-in-charge master table 110 is a table that holds information about the member 7. The person-in-charge master table 110 uses, for example, a person-in-charge code 111 for uniquely identifying a person in charge such as a sales person-in-charge 8 or a shop-in-charge person 9, and the person-in-charge name 112 as the person-in-charge name and the person in charge A store code 113 for uniquely identifying the store 6 to which the person belongs, a person-in-charge category 114 indicating the type of person in charge, and a password 115 for login of the person-in-charge. In addition, the person-in-charge master table 110 may include qualification information indicating the authority of the person in charge.

  The member-in-charge master table 120 is a table that holds information on users who can log in to the shopping support system 1. The member person-in-charge master table 120 includes, for example, a member / person-in-charge flag 122 that indicates the distinction between the member 7 and the person in charge, with the member number / person-in-charge code 121 uniquely identifying the member 7 and the person in charge as the main key. Since both the member number 101 and the person-in-charge code 111 can be held in the member number / person-in-charge code 121, the member number 101 and the person-in-charge code 111 have a code system that does not overlap each other.

  The store master table 130 is a table that holds information about the store 6. The store master table 130 includes, for example, a store name 132 that is the name of the store 6 with the store code 131 as a main key. In addition, the store master table 130 may include an address, a telephone number, a fax number, and the like of the store 6.

  FIG. 3 is an example of the product master table 140, the store product master table 150, the classification conversion master table 160, and the standard product master table 170.

  The product master table 140 is a table holding product information. The product master table 140 uses, for example, a JAN (Japanese Article Number) code 141 that uniquely identifies a product as a main key, a product name 142 that is the name of the product, a department code 143 that indicates a product department, and a large product A major classification code 144 indicating a classification, a middle classification code 145 indicating a middle classification of the product, a minor classification code 146 indicating a minor classification of the product, a manufacturer name 147 which is the name of the manufacturer of the product, and a product model number. A product model 148 and a product image 149 are included. The department code 143, the major classification code 144, the middle classification code 145, and the minor classification code 146 are four-layer categories for classifying products, and are uniquely defined by the store 6. However, it is commonly used in stores 6 of the same series. Hereinafter, the department code 143, the major classification code 144, the middle classification code 145, and the minor classification code 146 are collectively referred to as a store classification code 300. The store classification code 300 is not limited to the four-layer category, and may have a smaller layer structure or a larger layer structure. In addition, the product master table 140 may include detailed information such as a manufacturer's desired price, a product comment, and a URL where a product introduction article is posted.

  The store product master table 150 is a table that stores information about products for each store 6. The store product master table 150 has, for example, a store code 151 and a JAN code 152 as main keys, a store name 153, a handling category 154 that indicates whether or not the product is handled in the store 6, and a selling price 155 that indicates the selling price of the product. , And the inventory quantity 156 of the product in the store 6 and the shelf allocation information 157 indicating the display place of the product in the store 6. The shelf allocation information 157 includes the shelf number and the number of steps of the display shelf. In addition, the store product master table 150 may include purchase information such as suppliers and order units, and sales promotion information.

  The classification conversion master table 160 is a table that holds information for converting an external classification code defined by an external organization (for example, an industry standard organization) into the store classification code 300. The classification conversion master table 160 is, for example, a four-layer category defined by an external organization with the department code 161, the large classification code 162, the medium classification code 163, and the small classification code 164, that is, the store classification code 300 as main keys. 1 standard classification 165, 2nd standard classification 166, 3rd standard classification 167, and 4th standard classification 168 are included. Hereinafter, the first standard classification 165, the second standard classification 166, the third standard classification 167, and the fourth standard classification 168 are collectively referred to as an external classification code 310. The external classification code 310 is not limited to the four-layer category, and may have a smaller layer configuration or a larger layer configuration.

  The standard product master table 170 is a table that stores information on product masters of external organizations. The standard product master table 170 has, for example, a JAN code 171 as a primary key, a product name 172, a first standard category 173, a second standard category 174, a third standard category 175, and a fourth standard category 176, that is, an external category code. 310. In addition, the standard product master table 170 may include detailed product information. The standard product master table 170 is not necessarily defined as a database table. The server 2 may store the data of the standard product master table 170 in, for example, a CSV file format.

  Here, the relationship between the product master table 140 and the store product master table 150 will be described. In the store product master table 150, data of products handled in the store 6 are registered. On the other hand, in the product master table 140, data of both products handled at the store 6 and products not handled at the store 6 are registered. The data of the product that is not handled in the store 6 is registered by duplicating the data of the standard product master table 170, for example. As a result, the product search function provided by the server 2 (see FIG. 6 to be described later) can search not only products handled at the store 6 but also products not handled at the store 6 in a lump.

  FIG. 4 is an example of the reception transaction table 180, the inquiry master table 190, the product list table 200, and the login history table 210.

  The reception transaction table 180 is a table that holds reception information for inquiries via a moving image dialogue system, electronic mail, telephone, and the like. The reception transaction table 180 uses, for example, a reception number 181 that uniquely identifies reception information as a primary key, a member number 182, reception date / time 183 of reception information, and a reception section indicating a classification of a video dialogue system, e-mail, and telephone. 184, a reception person 185 indicating a person in charge of reception, a query section 186 indicating products, services, and other sections, and a query number 187 for uniquely identifying the query information.

  The inquiry master table 190 is a table that collectively holds inquiry information from the member 7 through various means. The inquiry master table 190 has, for example, an inquiry number 191 as a primary key, a member number 192, an inquiry content 193 indicating the inquiry content, an inquiry information creation date 194, and an answer content 195 indicating the answer content to the inquiry. , An answer date 196, an answerer 197 indicating the person who made the answer, an inquiry category 198, and an opening flag 199 indicating whether the person in charge confirmed the inquiry information. In addition, the inquiry master table 190 may hold an estimate number for uniquely identifying an estimate.

  The product list table 200 is a table that holds information on products ordered by the member 7. The merchandise list table 200 includes, for example, a quantity 203 indicating the number of merchandise orders with the member number 201 and the JAN code 202 as main keys.

  The login history table 210 is a table that holds the login history of the member 7 or the person in charge. The login history table 210 has a member number 211 (including a person-in-charge code) as a main key, the login date 212 of the member 7 or the person in charge, the logout date 213 of the member 7 or the person in charge, and the member 7 or person in charge. A moving image interaction flag 214 indicating whether or not an access button to the moving image interaction system has been pressed.

  Here, the relationship between the reception transaction table 180 and the inquiry master table 190 will be described. The reception transaction table 180 is a table that holds reception information input via a reception registration screen 700 shown in FIG. On the other hand, the inquiry master table 190 holds both inquiry information input via the inquiry registration screen 500 shown in FIG. 7 and inquiry information input via the reception registration screen 700 shown in FIG. It is. That is, the inquiry information corresponding to the reception information held in the reception transaction table 180 is always registered in the inquiry master table 190. As a result, the server 2 can centrally manage inquiries made by various methods in the inquiry master table 190.

  Next, details of each screen provided by the server 2 and processing of the server 2 will be described with reference to FIGS. The control unit of the server 2 responds to a request from the external terminal 3 or the store terminal 4 and transmits data of each screen to the external terminal 3 or the store terminal 4. The control part of the external terminal 3 or the shop terminal 4 displays each screen on a display part by the function of web browsing software. In addition, the control unit of the external terminal 3 or the store terminal 4 transmits data input on each screen to the server 2 via the input unit.

  FIG. 5 is an example of a screen transition of the shopping support system 1. The screens and screen items that can be displayed differ depending on the login by the member 7 and the login by the person in charge (= the sales person 8 or the shop person 9). FIG. 5A shows a screen displayed when the member 7 logs in, and FIG. 5B shows a screen displayed when the person in charge logs in. In practice, the screen transitions shown in FIG. 5 are not all, and various screen transitions can be made by arranging menu buttons on each screen.

  First, the screen transition in the case of login by the member 7 will be described. In the present embodiment, the external terminal 3 is used when the member 7 logs in on the login screen (not shown) in step S11. In step S11, login authentication is performed using a membership number and a password. The server 2 discriminates between the member 7 and the person in charge using the member person in charge master table 120. When the server 2 discriminates the member 7, the server 2 performs login authentication using the member master table 100.

  Next, the external terminal 3 transmits a display request for the product search screen 400 to the server 2 in step S12.

  FIG. 6 is an example of the product search screen 400 and the search result display screen 420. A product search screen 400 shown in FIG. 6A is a screen for setting search conditions. A search result display screen 420 shown in FIG. 6B is a screen for displaying the search results.

  6A, the product search screen 400 includes a product category 401, a store handling check box 402, a product name text box 403, a manufacturer name text box 404, a store name text box 405, and a product model number text box 406. , A search button 407, a moving image dialogue button 408, an inquiry button 409, and a return button 410.

  In the product category 401, data of the store classification code 300 in the product master table 140 is displayed. In FIG. 6A, the data of the department code 143 is displayed. When the department name is selected by the member 7, the external terminal 3 displays the large classification code 144 of the selected department name. When the major classification name is selected, the external terminal 3 displays the middle classification code 145 of the selected major classification name. When the middle category name is selected, the external terminal 3 displays the minor category code 146 of the selected middle category name. The selected department name or category name in the lowest layer is set as a search condition.

  When the store handling check box 402 is selected, a product that is handled in the store 6 is set as a search condition. When a character string is input to the product name text box 403 to the product model number text box 406, the input character string is set as a search condition for each item.

  A search button 407 is a button for requesting execution of a search. The moving image interaction button 408 is an access button to the moving image interaction system. The inquiry button 409 is a button for requesting screen transition to an inquiry registration screen 500 described later.

  The server 2 activates the video dialogue button 408 only when the member 7 or the person in charge is logged in, and when the video dialogue button 408 is pressed, the video dialogue flag 214 is turned on for the login history table 210. Update. Thereby, even in the case of cooperation with an external moving image dialogue system, the member 7 or the person in charge who is using the moving image dialogue can be specified.

When the search condition is set and the search button 407 is pressed, the external terminal 3 transmits the set search condition to the server 2 and requests execution of the search. The server 2 performs a search by combining the product master table 140 and the store product master table 150 with the JAN code 141 which is a product identification code. The search conditions are as follows.
The store classification code 300 of the product master table 140 that matches the department name or classification name selected in the category 401
When the store handling check box 402 is selected, the handling category 154 of the store product master table 150 is “handled”
Product name 142 in the product master table 140 including the character string input in the product name text box 403
The manufacturer name 147 of the product master table 140 including the character string input in the manufacturer name text box 404
Store name 153 in the store product master table 150 including the character string input in the store name text box 405
The product model number 148 of the product master table 140 including the character string input in the product model number text box 406

  When there is a product that matches the search condition, the server 2 stores the image 149, the manufacturer name 147, the product name 142, the handling category 154, the stock quantity 156, the store name 153, the shelf allocation information 157, And the data of the search result display screen 420 is transmitted to the external terminal 3.

  As shown in FIG. 6B, the search result display screen 420 has screen items of the search result display area 421 in addition to the screen items of the product search screen 400. In the example shown in FIG. 6B, the character string “Nailer” is input in the product name text box 403, and three search result display areas 421a to 421c are displayed as search results.

  For the products in the search result display area 421a, the store name 153 of the store product master table 150 is “A”, the handling category 154 is “handled”, the stock quantity 156 is “5”, and the shelf allocation information 157 is “B1”. Therefore, the server 2 includes the messages “A store handling”, “stock quantity 5”, and “storage bin B1” in the data of the search result display area 421.

  For the products in the search result display area 421b, the store name 153 of the store product master table 150 is “B”, the handling category 154 is “handled”, the stock quantity 156 is “0”, and the shelf allocation information 157 is “E2”. Therefore, the server 2 includes the messages “B store handling”, “stock quantity 0”, and “shelf number E2” in the data of the search result display area 421.

  Since the products in the search result display area 421c do not have the shelf allocation information 157 in the store product master table 150, the message “Please contact us” is included in the data in the search result display area 421. The case where there is no shelf allocation information 157 in the store product master table 150 means that there is a record in the store product master table 150 but there is no record of the shelf allocation information 157, and a record in the store product master table 150. Includes both of the second case where no exists. In the first case, it is considered that the shelf allocation information 157 is not registered or deleted at the time of inventory because the product is waiting for the first arrival of the product or the handling is actually stopped. . In the second case, none of the stores 6 has been handled, and there is data in the product master table 140, but no data exists in the store product master table 150.

  In the product master table 140, in addition to the product data handled in each store 6, product data registered in the standard product master table 170 is also registered. Therefore, since the member 7 can search and purchase a product that is not handled in each store 6, convenience is improved. Further, when purchasing a product that is not handled at each store 6, since the arrival time and price are not yet determined, the member 7 needs to make an inquiry to the store 6. In the shopping support system 1 of the present embodiment, the store 6 can be inquired by various methods, so the burden on the member 7 can be reduced. The store 6 can also expect an increase in sales by improving customer satisfaction and reducing opportunity loss.

  Returning to the description of FIG. If there is a search result (Yes in Step S13), the member 7 can proceed to purchase a product on the search result display screen 420. When a product on the search result display screen 420 is selected, the external terminal 3 transmits a display request for a product detail screen (not shown) of the selected product to the server 2 in step S14. When a purchase instruction is selected on the product detail screen, the external terminal 3 transmits a display request for a product list screen (not shown) for displaying a list of products desired to be purchased to the server 2 in step S15. On the product list screen, in addition to confirming the product desired to be purchased, payment for product purchase can be performed.

  When there is no search result (no step S13), or when it is desired to make an inquiry about the product or service, such as when the user wants to check the usage method of the product on the product detail screen, the member 7 can use the video dialogue system or the telephone. Inquiries made via the inquiry registration screen 500 can be performed. Note that, on the product detail screen, a moving image dialogue button 408, an inquiry button 409, and the like on the product search screen 400 and the search result display screen 420 may be arranged.

  When making an inquiry through the video dialogue system (video dialogue in step S16), when the video dialogue button 408 is pressed by the member 7, the external terminal 3 sends an access request to the video dialogue system to the web server in the video dialogue system. Send to. The external terminal 3 receives the login screen data from the web server in the video interactive system and displays it as a new window. On the other hand, the store terminal 4 that is used when the store person in charge 9 logs in logs in the video dialogue system in advance and accepts a conversation request from the external terminal 3. And the external terminal 3 and the shop terminal 4 are connected on a moving image dialogue system. As a result, the member 7 can perform interactive communication of moving images with the store staff 9 in real time to confirm the actual product and how to use the product.

  When making an inquiry via the telephone (telephone in step S18), the member 7 makes a telephone call to the store 6 by a fixed telephone, a mobile phone, a smartphone, an Internet telephone, or the like. On the other hand, the store person in charge 9 receives a call at the store 6. As a result, the member 7 can make an inquiry to the store staff 9 while confirming the product information on the display unit of the external terminal 3.

  When making an inquiry via the inquiry registration screen 500 (registration in step S19), when the inquiry button 409 is pressed by the member 7, the external terminal 3 transmits a screen transition request to the inquiry registration screen 500 to the server 2. To do. In response to this, the server 2 transmits the data of the inquiry registration screen 500 to the external terminal 3.

  FIG. 7 is an example of the inquiry registration screen 500. The inquiry registration screen 500 has screen items of a member number display area 501, an inquiry classification radio button 502, an inquiry content text box 503, a send button 504, and a return button 505.

  In the member number display area 501, the member number of the logged-in member 7 is displayed. The inquiry category radio button 502 has three categories: product, service, and others. The selected category is set as inquiry information. When a character string is input to the inquiry content text box 503, the input character string is set as inquiry information. The transmission button 504 is a button for instructing transmission of inquiry information. The return button 505 is a button for requesting screen transition to the previous screen.

When the inquiry information is set and the send button 504 is pressed, the external terminal 3 transmits the set inquiry information to the server 2 and requests registration of the inquiry information. When the server 2 receives the inquiry information, the server 2 adds the following new record to the inquiry master table 190.
Inquiry number 191 = Automatic numbering for the inquiry master table 190. Member number 192 = Member number of the logged-in member 7. Inquiry content 193 = Character string input in the inquiry content text box 503. Creation date 194 = Server 2 System date / time / answer content 195, answer date / time 196, respondent 197 = not set / inquiry category 198 = category / open flag 199 = unopened flag selected by the query category radio button 502

Note that the server 2 may add the following new records to the received transaction table 180 together with the addition of the new records to the inquiry master table 190.
<Received transaction table 180>
-Reception number 181 = Automatic numbering for the reception transaction table 180-Member number 182 = Member number of the logged-in member 7-Reception date and time 183 = System date and time of the server 2-Reception category 184 = Classification and reception indicating the inquiry registration screen 500 185 = Code indicating system automatic reception / inquiry classification 186 = classification selected by inquiry classification radio button 502 / inquiry number 187 = automatic numbering for inquiry master table 190

  Returning to the description of FIG. The member 7 can confirm the registered inquiry information on the inquiry history display screen 600. In step S <b> 20, the external terminal 3 transmits a screen transition request to the inquiry history display screen 600 to the server 2. In response to this, the server 2 transmits the data of the inquiry history display screen 600 to the external terminal 3.

  FIG. 8 is an example of an inquiry history display screen 600. The inquiry history display screen 600 has screen items of an inquiry date display area 601, an inquiry content display area 602, an inquiry classification display area 603, an inquiry number display area 604, a status display area 605, a detailed button display area 606, and a return button 607. .

  In the inquiry date display area 601, the inquiry content display area 602, the inquiry classification display area 603, and the inquiry number display area 604, the creation date and time 194 of the inquiry master table 190 relating to the logged-in member 7, the inquiry contents 193, and the inquiry number 191, respectively. Is displayed. A part of the inquiry content 193 may be displayed in the inquiry content display area 602. In the status display area 605, “answer is present” is displayed when the answer content 195 is set, and “accepting” is displayed when the answer content 195 is not set. In the detail button display area 606, a detail button for requesting screen transition to an inquiry detail confirmation screen (not shown) for confirming the details of the inquiry information is displayed.

  Returning to the description of FIG. In step S21, when the detail button on the inquiry history display screen 600 is pressed, the external terminal 3 transmits to the server 2 a screen transition request to an inquiry detail confirmation screen (not shown) for confirming the details of the inquiry information. In step S22, when an estimate button (not shown) arranged on the inquiry detail confirmation screen is pressed, the external terminal 3 sends a screen transition request to the estimate confirmation screen (not shown) for confirming the estimate information to the server. 2 to send.

  As described above, in the shopping support system 1, the member 7 can search for and purchase products, and can inquire the store 6 by various methods.

  Next, the screen transition in the case of login by the store staff 9 will be described. In the present embodiment, the store terminal 4 is used when the store person in charge 9 logs in on the login screen (not shown) in step S31. In step S31, as in step S11, login authentication is performed using a membership number and a password. The server 2 discriminates between the member 7 and the person in charge using the member person-in-charge master table 120. If the server 2 discriminates from the person in charge, the server 2 performs login authentication using the person-in-charge master table 110.

  In step S32 or step S33, when the inquiry from the member 7 by telephone or video dialogue is handled, the store person in charge 9 registers the reception information via the reception registration screen 700 in step S34.

  FIG. 9 is an example of a reception registration screen 700. The reception registration screen 700 includes a reception number display area 701, a member number text box 702, a reception date / time display area 703, a reception classification radio button 704, an inquiry classification radio button 705, an inquiry content text box 706, a registration button 707, and a return button 708. Has screen items.

  In the reception number display area 701, automatic numbering data regarding the reception transaction table 180 is displayed. In the member number text box 702, the member number of the member 7 who has received the inquiry is input. The reception date display area 703 displays the current system date. The selected category of the acceptance category radio button 704 and the inquiry category radio button 705 is set as acceptance information. When a character string is input to the inquiry content text box 706, the input character string is set as reception information. The registration button 707 is a button for instructing registration of reception information. The return button 708 is a button for requesting screen transition to the previous screen.

When the reception information is set and the registration button 707 is pressed, the external terminal 3 transmits the set reception information to the server 2 and requests registration of the reception information. When the server 2 receives the reception information, the server 2 adds the following new records to the reception transaction table 180 and the inquiry master table 190.
<Received transaction table 180>
-Reception number 181 = Automatic numbering for the reception transaction table 180-Member number 182 = Number entered in the member number text box 702-Reception date and time 183 = Server 2 system date and time-Reception section 184 = Selection by reception section radio button 704 Category / Receiver 185 = Code of person in charge of logged-in person / inquiry category 186 = Class selected by query category radio button 705 / inquiry number 187 = automatic numbering for query master table 190 <query master table 190 >
Query number 191 = Automatic numbering for query master table 190 Member number 192 = Number entered in member number text box 702 Query content 193 = Character string entered in query content text box 706 Creation date 194 = Server System date / time / response content 195, answer date / time 196, respondent 197 = not set / inquiry category 198 = category / open flag 199 = unopened flag selected by the query category radio button 705

  Returning to the description of FIG. In step S35, the store person in charge 9 confirms the inquiry list screen 800.

  FIG. 10 is an example of the inquiry list screen 800. The inquiry list screen 800 includes a date text box 801, a member number text box 802, an inquiry content text box 803, an answerer name drop-down list 804, a search button 805, an inquiry date display area 806, an inquiry number display area 807, and a member number display. Area 808, member name display area 809, inquiry content display area 810, inquiry classification display area 811, reception number display area 812, reception classification display area 813, unsealed state display area 814, status display area 815, answer date display area 816, It has display items of an answerer display area 817, a detailed display area 818, and a return button 819.

  Values entered or selected in the date text box 801 to the respondent name drop-down list 804 are set as search conditions. When the search button 805 is pressed, the store terminal 4 transmits the set search condition to the server 2 and requests execution of the search. The server 2 searches the query master table 190 based on the received search condition. Search result data is displayed in each of the inquiry date display area 806 to the respondent display area 817. In the example shown in FIG. 10, “2016/11 / 15˜” is entered in the date text box 801, and five pieces of inquiry information are displayed as search results.

  The inquiry information in which the unsealed state display area 814 is “unread” means that the detail button has never been pressed and the unsealing flag 199 of the inquiry master table 190 is “unread”. In addition, the inquiry information whose status display area 815 is “accepting” means that the answer content 195 of the inquiry master table 190 is not set.

  Returning to the description of FIG. When the detail button displayed in the detail display area 818 of the inquiry list screen 800 is pressed, the store terminal 4 transmits a screen transition request to the inquiry response screen 900 to the server 2 in step S36. In response to this, the server 2 transmits the data of the inquiry response screen 900 to the external terminal 3.

  FIG. 11 is an example of an inquiry response screen 900. The inquiry answer screen 900 includes an inquiry number display area 901, an inquiry date display area 902, an inquiry content display area 903, an answer date display area 904, an answerer drop-down list 905, an answer contents text box 906, an estimate button 907, an estimate number. The display item includes a display area 908, a transmission button 909, and a return button 910.

  In the inquiry number display area 901 to the answer date display area 904, data of the inquiry master table 190 relating to the target inquiry information is displayed. The person-in-charge name selected in the respondent drop-down list 905 is set as answer information. The character string input in the answer content text box 906 is set as answer information.

When the answer information is set and the send button 909 is pressed, the store terminal 4 sends the set answer information to the server 2 and requests registration of the answer information. When the server 2 receives the answer information, the server 2 updates the record in the inquiry master table 190 in which the inquiry number 191 matches the number displayed in the inquiry number display area 901 with the following contents.
<Inquiry master table 190>
-Reply content 195 = Character string input in the reply content text box 906-Reply date 196 = Server 2 system date-Responder 197 = Responsible person name of the person in charge selected in the respondent drop-down list 905

  Returning to the description of FIG. When the estimate button 907 on the inquiry response screen 900 is pressed, the store terminal 4 transmits a screen transition request to an estimate screen (not shown) to the server 2 in step S37. In response to this, the server 2 transmits the data of the estimate screen to the external terminal 3.

  The store person in charge 9 can display the product search screen 400 in step S38 to search for products, or can display the product detail screen in step S39. Since the operation of the server 2 is the same as that in step S12 and step S14, detailed description thereof is omitted.

  The store person in charge 9 can also perform data processing in step S40. The main data processing includes processing for reflecting the data of the standard product master table 170 on the product master table 140. When a store processing person 9 presses a data processing button (not shown), the store terminal 4 transmits a data processing execution request to the server 2. In contrast, the server 2 uses the classification conversion master table 160 to convert the external classification code in the standard product master table 170 into a store classification code, and adds the data of the standard product master table 170 to the product master table. Or update.

  In step S41, the store person in charge 9 can display the login list screen 1000 to check the logged-in member 7 or person in charge.

  FIG. 12 is an example of the login list screen 1000. The login list screen 1000 is a screen for displaying information on the logged-in member 7 or the person in charge and the moving image dialogue flag on the store terminal 4. The login list screen 1000 includes display items of a login date / time display area 1001, a member name display area 1002, a store display area 1003, an inquiry content display area 1004, a moving image dialogue flag display area 1005, and a return button 1006.

  In the login date / time display area 1001 and the moving image dialogue flag display area 1005, data of the login history table 210 regarding the target member 7 or the person in charge is displayed. In the member name display area 1002 and the store display area 1003, data of the member master table 100 or the person in charge master table 110 regarding the target member 7 or the person in charge is displayed. In the inquiry content display area 1004, data of the inquiry master table 190 regarding the target member 7 is displayed.

  As described above, the server 2 activates the video interaction button 408 only when the member 7 or the person in charge is logged in. When the video interaction button 408 is pressed, the video interaction flag 214 is turned on for the login history table 210. Therefore, the member 7 or the person in charge who is using the moving image dialogue system can be grasped from the login list screen 1000.

The moving image dialogue flag display area 1005 is an item that can be updated by the user. When the store person in charge 9 finishes the moving picture conversation with the member 7 or the person in charge, the store person in charge 9 instructs to correct the moving picture conversation flag by double-clicking “●” (black circle) in the moving picture conversation flag display area 1005. On the other hand, the server 2 hides “●” (black circle) in the moving image dialogue flag display area 1005 and the member number 211 matches the member 7 or the person in charge displayed in the member name display area 1002. The record of the login history table 210 is updated with the following contents. Thereby, even if it is a case where it cooperates with an external animation dialogue system, the use situation of animation dialogue can be managed.
<Login history table 210>
・ Video dialogue flag = off

  As described above, the shopping support system 1 can respond to the needs of various customers in an integrated manner. In particular, the server 2 stores in the inquiry master table 190 inquiry information relating to both inquiry correspondence via a moving image interactive system and telephone and inquiry correspondence via the inquiry registration screen 500 and mail. In the inquiry list screen 800 and the inquiry response screen 900 that can be displayed by the person in charge, display and input reception processing are performed without distinguishing between the two. Therefore, the person in charge can respond to various inquiries by a unified operation procedure.

  In the shopping support system 1, the shelf allocation information 157 of the product is displayed on the search result display screen 420. Therefore, the customer can search for the desired product, specify the display location of the product in the store 6, and purchase the product. Furthermore, since the shopping support system 1 can also search for products that are not handled in the store 6, the customer can place orders for products that are not handled.

  The preferred embodiments of the shopping support system and the like according to the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to such examples. It will be apparent to those skilled in the art that various changes or modifications can be conceived within the scope of the technical idea disclosed in the present application, and these naturally belong to the technical scope of the present invention. Understood.

1 ……… Shopping support system 2 ……… Server 3 ……… External terminal 4 ……… Store terminal 5 ……… Network 6 ……… Store 7 ……… Member 8 ……… Sales representative 9 ……… Store manager 100 ... Member master table 110 ... Staff master table 120 ... Member master table 130 ... Product master table 140 ... Store master table 150 ... Store product master table 160 ... …… Category conversion master table 170 ………… Standard product master table 180 ……… Received transaction table 190 ……… Inquiry master table 200 ……… Product list table 210 ……… Login history table 400 ……… Product search screen 420 ... …… Search result display screen 500 ……… Inquiry registration screen 600 ……… Inquiry history display screen 700 ......... accepting registration screen 800 ......... inquiry list screen 900 ......... inquiry reply screen 1000 ......... login list screen

Claims (6)

A shopping support system in which an external terminal that can be used outside a store and can use a video interactive system, a store terminal that can be used in the store and that can use the video interactive system, and a server are connected via a network Because
The external terminal is used when a member of the store logs in on a login screen provided by the server,
The store terminal is used when the person in charge of the store logs in on the login screen,
The external terminal and the store terminal are configured to be connected to each other in the video interaction system,
The server
Access providing means for providing a screen including an access button to the moving image dialogue system for the external terminal and the store terminal;
A reception registration means for providing a reception registration screen for registering the reception information of the inquiry through the moving image dialogue system and the telephone with respect to the store terminal,
Inquiry registration means for providing an inquiry registration screen for registering an inquiry to the external terminal;
Storage means for storing information inputted through both the reception registration screen and the inquiry registration screen as inquiry information;
A shopping support system characterized by comprising: The storage means uses a reception number that uniquely identifies the reception information as a main key, a member number that uniquely identifies the member, a reception section that indicates a classification of the video interactive system and the telephone, and the inquiry information. A reception transaction table including a uniquely identified inquiry number, and the inquiry number as a primary key, including the member number, an inquiry content indicating the content of the inquiry, and an answer content indicating the content of the answer to the inquiry A database including a query master table,
The reception registration unit, upon receiving information input via the reception registration screen, adds a new record to the reception transaction table and the inquiry master table,
The shopping support system according to claim 1, wherein the inquiry registration unit adds a new record to the inquiry master table when receiving information input via the inquiry registration screen. The server
Inquiry confirmation providing means for providing an inquiry history display screen for displaying a history of the inquiry master table related to the member number of the logged-in member to the external terminal;
Inquiry answer providing means for providing an inquiry answer screen for adding the answer contents to the inquiry master table for the store terminal,
The shopping support system according to claim 2, further comprising: The database uses the member number as a primary key, the login date and time of the member, the logout date and time of the member, and a video dialogue flag indicating whether or not the member has pressed the access button to the video dialogue system, A login history table including
The access providing means activates an access button to the video dialogue system only when the member is logged in. When the access button to the video dialogue system is pressed, the video dialogue is performed on the login history table. Update the flag to turn on,
The said server is further provided with the login list provision means which provides the login list screen for displaying the information of the said login member and the said animation dialog flag with respect to the said store terminal. Or the shopping assistance system of Claim 3. The database uses a product identification code for uniquely identifying a product as a main key, and a product master table including a product name of the product and a store classification code indicating a classification of the product in the store, and the store is uniquely identified The store code and the product identification code to be used as a main key, the store name indicating the name of the store, the handling classification indicating whether or not the product is handled in the store, the number of products in the store, the image of the product, A store product master table including product shelf allocation information,
In the product master table, data of both products handled in the store and products not handled in the store are registered,
The server further includes a product search means for providing a product search screen for accepting a search for products to the external terminal,
When the product search means receives a product search condition from the external terminal, the product search means performs a search by combining the product master table and the store product master table with the product identification code, and at least the product name and the store A name, the handling classification, the inventory quantity, the shelf allocation information, and the image are extracted, and data of a search result display screen that displays a search result is transmitted to the external terminal. The shopping support system according to any one of claims 2 to 4. 6. The shopping support system according to claim 5, wherein the product search means includes a message for inquiring in the data of the search result display screen when the shelf allocation information of the store product master table is not present.

Images