Information inquiry apparatus, information inquiry method, and information inquiry program

Abstract

To provide an information inquiry apparatus, and the like, configured to manage commodity information in association with inventory information based on information for identifying a medium, thereby improving customer service quality and facilitating sales.SOLUTION: An information inquiry apparatus is configured to: (1) acquire a commodity associated with a predetermined medium code from a publication history registration data, and display publication history information including the acquired commodity and the predetermined medium code on a publication history inquiry screen; and (2) acquire stock quantity of a commodity selected on the publication history inquiry screen by referring to current inventory data, and display the acquired stock quantity on a store inventory inquiry screen.SELECTED DRAWING: Figure 3

Description

[Technical field]

[0001] The present invention relates to an information inquiry device, an information inquiry method, and an information inquiry program. [Background technology]

[0002] Patent Document 1 discloses an order receiving device and the like that reduces the loss of sales opportunities for products. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2019-121180 A Summary of the Invention [Problem to be solved by the invention]

[0004] Here, in the distribution and retail industry that deals with general consumers, the company's products are often advertised and promoted in magazines and on television, etc., and are often displayed in stores or at events. Therefore, from the perspective of preventing opportunity loss, it is important for store employees to be able to sell the desired product to customers even when the customer provides them with information on the media in which the product was shown (for example, the title of the television program in which the product was introduced) rather than information on the product itself.

[0005] However, in the past, there was no system for linking media information with products, so the accuracy of identifying products depended on the ability of each employee (mainly their knowledge and experience). As a result, it was not possible to maintain a consistent quality of customer service. Furthermore, even if the product was identified accurately, it took time to find out the stock information and arrival status of products at the store or center. As a result, the quality of customer service declined.

[0006] The present invention has been made in consideration of the above, and aims to provide an information inquiry device, an information inquiry method, and an information inquiry program that can improve customer service quality and promote sales by linking and managing product information and inventory information based on information for identifying a medium. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the objective, the information inquiry device of the present invention is characterized by comprising a first display control unit that acquires products linked to specified medium identification information from medium identification information for identifying the medium in which the product is disclosed and a first memory area that manages the products in association with each other, and displays the acquired products on a screen, and a second display control unit that acquires the inventory quantity of a product selected on the screen by referring to a second memory area that manages the inventory quantities of products by product, and displays the acquired inventory quantity on the screen.

[0008] Here, media conceptually include mass media, internet media, and sales promotion media. Mass media are, for example, newspapers, magazines, radio, and television. Internet media are, for example, digital newspapers, digital magazines, digital radio, digital television, product sales e-commerce platforms, search engines, social media, video sites, affiliate sites, and owned media. Sales promotion media are, for example, transportation, flyers, free papers, outdoors (signs and flags), direct mail, in-store POP, events and exhibitions, and digital signage.

[0009] In addition, in the information inquiry device of the present invention, the second memory area may manage the inventory quantity of products by product and by store, and the second display control unit may refer to the second memory area to obtain the inventory quantity of the selected product at a specified store and display the obtained inventory quantity on the screen.

[0010] In addition, in the information inquiry device of the present invention, the second display control unit may refer to the second memory area to obtain the inventory quantity of the selected product at each store other than the specified store, and display the total of the obtained inventory quantities on the screen.

[0011] In addition, in the information inquiry device of the present invention, the second memory area may manage the inventory quantity of products by product and by store or warehouse, and the second display control unit may refer to the second memory area to obtain the inventory quantity of the selected product in the warehouse and display the obtained inventory quantity on the screen.

[0012] In the information inquiry device according to the present invention, the predetermined store may be a store to which the operator belongs.

[0013] In addition, in the information inquiry device of the present invention, the second display control unit may display on a single screen the inventory quantity of the selected product at the specified store, the total inventory quantity of the selected product at each of the stores, and the inventory quantity of the selected product at the warehouse.

[0014] The information inquiry device according to the present invention may be capable of accessing a third memory area for managing, by product and by store or warehouse, the number of ordered products that have not yet arrived at a store or warehouse out of the number of ordered products, a fourth memory area for managing, by product and by store or warehouse, the number of moved and shipped products that have been shipped from a store and the number of moved and received products that have arrived at a store or warehouse in relation to the movement of products from a store to a store or warehouse, by product, by store of origin and by store or warehouse of destination, and a fifth memory area for managing, by product and by store or warehouse, the number of ordered products and the number of ordered products that have been shipped from a store or warehouse out of the number of ordered products, and the information inquiry device according to the present invention may be capable of accessing the number of ordered products that have not yet arrived and the number of moved and not yet arrived products of the selected product at the predetermined store, the number of ordered products at each of the stores and the number of moved and not yet arrived products of the selected product at each of the stores. The third display control unit may further include a third display control unit which displays on a screen the number of ordered items not yet arrived, the number of ordered items not yet arrived, and the number of items available for allocation in the warehouse, and the number of items ordered not yet arrived, and the third display control unit may acquire the number of ordered items not yet arrived from the third memory area, acquire the number of items moved and shipped and the number of items moved and received from the fourth memory area, calculate the number of items moved and not yet arrived by subtracting the acquired number of items moved and shipped from the acquired number of items moved and shipped, acquire the number of ordered items and the number of items shipped from the fifth memory area, calculate the number of items moved and not yet shipped by subtracting the acquired number of ordered items shipped from the acquired number of ordered items, and calculate the number of items available for allocation by subtracting the calculated number of items ordered not yet shipped from the sum of the inventory number acquired by the second display control unit, the acquired number of items ordered not yet arrived, and the calculated number of items moved and not yet arrived.

[0015] Furthermore, the information inquiry method of the present invention is characterized in including a first display control step in which a first display control unit acquires a product linked to specified medium identification information from a first memory area that links and manages medium identification information for identifying the medium in which the product is disclosed and the product, and displays the acquired product on the screen, and a second display control step in which a second display control unit refers to a second memory area that manages the inventory count of the product by product, acquires the inventory count of the product selected on the screen, and displays the acquired inventory count on the screen.

[0016] In addition, the information inquiry program of the present invention is intended to cause an information processing device to function as a first display control means for acquiring a product linked to specified medium identification information from a first memory area that links and manages medium identification information for identifying the medium on which the product is disclosed and the product, and displaying the acquired product on the screen, and a second display control means for acquiring the inventory quantity of a product selected on the screen by referring to a second memory area that manages the inventory quantities of products by product, and displaying the acquired inventory quantity on the screen. Effect of the Invention

[0017] The present invention has the effect of improving the quality of customer service and promoting sales by managing product information and inventory information in association with information for identifying a medium. [Brief description of the drawings]

[0018] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a task assistance device 100 according to the present embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of the posting history registration data 106a. [Diagram 3] FIG. 3 is a diagram showing an example of the posting history inquiry screen MA. [Figure 4] FIG. 4 is a diagram showing an example of the current stock data 106b, the warehouse master 106c, the store master 106d, and the product master 106e, as well as a store stock inquiry screen MB. [Diagram 5] FIG. 5 shows an example of the order data 106f, the transfer data 106g, the received order data 106h, the current stock data 106b, and the store and other store stock inquiry screen MC. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0019] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of an information inquiry device, an information inquiry method, and an information inquiry program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0020] [1. Configuration] An example of the configuration of a task assistance device 100 according to this embodiment (including an information inquiry device according to the present invention) will be described with reference to Fig. 1 etc. Fig. 1 is a block diagram showing an example of the configuration of the task assistance device 100.

[0021] The business support device 100 is constructed based on a commercially available desktop personal computer. The business support device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0022] The business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the business support device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0023] The communication interface unit 104 communicatively connects the task assistance device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the task assistance device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server 200, for example.

[0024] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0025] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs (including the information inquiry program according to the present invention) for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0026] The memory unit 106 stores listing history registration data 106a (including the first memory area of ​​the present invention), current inventory data 106b (including the second memory area of ​​the present invention), warehouse master 106c, store master 106d, product master 106e, order data 106f (including the third memory area of ​​the present invention), movement data 106g (including the fourth memory area of ​​the present invention), and order data 106h (including the fifth memory area of ​​the present invention), etc.

[0027] 2 shows an example of information stored in the publication history registration data 106a. The publication history registration data 106a is for managing products (including furniture, small items, miscellaneous goods, apparel, etc.) in association with publication information in media (including magazines, television, the Internet, etc.) and exhibition information in events (including stores, department stores, events, etc.). The publication history registration data 106a stores medium category identification information (e.g., medium category code or medium category name, etc.), medium identification information (e.g., medium code or medium name, etc.), dates related to the medium (e.g., release date (including exhibition date) or broadcast date, etc.), issue number, publication page, publication position (note: when the medium is a magazine), and product identification information (e.g., product code or product name, etc.), etc. In addition to the media, the medium also includes the party to whom the product is loaned when exhibited at an event, exhibition, etc., and when the medium is an event, exhibition, etc., "Loaner" is stored in the medium category name of the posting history registration data 106a, and the name of the business partner that loaned the product (e.g., "Business Partner (1)") is stored in the medium name of the posting history registration data 106a.

[0028] 4 and 5 show an example of information stored in the current inventory data 106b. The current inventory data 106b is for managing the current inventory of products in the store and warehouse. The current inventory data 106b stores warehouse identification information (e.g. warehouse code or warehouse name, etc.), product identification information, and current inventory quantity. The current inventory data 106b holds the current inventory quantity taking into account the number of received items in the order data 106f and the number of items shipped and received in the movement data 106g. For example, the current inventory quantity "18" of item number 002 at the Akihabara store is calculated by taking into account the quantity "10" of item number 002 that has arrived at the Akihabara store in the order data 106f, and the current inventory quantity "9" of item number 002 at the central warehouse is calculated by taking into account the quantity "3" of item number 002 that has arrived at the central warehouse in the order data 106f and the quantity "2" of item number 002 that has been shipped to the central warehouse and the quantity "2" of item number 002 that has been received in the movement data 106g.

[0029] 4 shows an example of information stored in the warehouse master 106c. The warehouse master 106c stores warehouse identification information (e.g., warehouse code or warehouse name), warehouse location classification, store identification information (e.g., store code), etc. The warehouse master 106c can manage not only existing warehouses but also stores as warehouses.

[0030] An example of information stored in the store master 106d is shown in Fig. 4. The store master 106d stores store identification information (for example, a store code or a store name, etc.) and the like.

[0031] An example of information stored in the product master 106e is shown in Fig. 4. The product master 106e stores product identification information, product unit prices (for example, retail prices (excluding tax) and the like), and the like.

[0032] An example of information stored in the order data 106f is shown in Fig. 5. The order data 106f stores order identification information (e.g., order number and order line number, etc.), receiving destination identification information (e.g., receiving warehouse code or receiving warehouse name, etc.), product identification information, order quantity, received quantity, and undelivered quantity (corresponding to the ordered yet to arrive quantity of the present invention), etc.

[0033] 5 shows an example of information stored in the movement data 106g. The movement data 106g is for managing the number of items sent out from a store (corresponding to the number of items moved and shipped in the present invention) and the number of items received into a store or warehouse (corresponding to the number of items moved and received in the present invention) in relation to the movement of goods from a store to another store or warehouse. The movement data 106g stores movement identification information (e.g., movement number and movement line number, etc.), source identification information (e.g., code or name of the store that is the source of movement (movement), etc.), destination identification information (e.g., code or name of the store that is the destination of movement (movement), etc.), product identification information, the number of items sent out and the number of items received, etc.

[0034] An example of information stored in the order data 106h is shown in Fig. 5. The order data 106h is for managing orders. The order data 106h stores order identification information (e.g., order number and order line number), shipping source identification information, product identification information, order quantity (corresponding to the order quantity of the present invention), and the number of orders shipped from the shipping source (corresponding to the order shipped quantity of the present invention), etc.

[0035] 1, the control unit 102 is a CPU or the like that performs overall control of the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs.

[0036] The control unit 102 conceptually includes, functionally, a posting history registration unit 102a, a posting history inquiry unit 102b (including the first display control unit of the present invention), a store inventory inquiry unit 102c (including the second display control unit of the present invention), and a store other store warehouse inventory inquiry unit 102d (including the third display control unit of the present invention). In the following description, the expressions "posting history registration unit 102a", "posting history inquiry unit 102b", "store inventory inquiry unit 102c", and "store other store warehouse inventory inquiry unit 102d" may be abbreviated to, for example, "registration unit 102a", "inquiry unit 102b", "inquiry unit 102c", and "inquiry unit 102d".

[0037] The registration unit 102a stores information for identifying the medium, such as media publication information or exhibition information at events, etc., set by employees, etc. on a publication history input screen (not shown), in the publication history registration data 106a (see Figure 2).

[0038] The inquiry unit 102b executes the following processes (11) to (14) (see FIG. 3). (11) A posting history inquiry screen MA (hereinafter, sometimes referred to as the “inquiry screen MA”) is displayed on the monitor 114. (12) When the media classification and / or media code are set in the areas for setting the extraction conditions on the inquiry screen MA (area MA1 for setting the media classification and area MA2 for setting the media code), the publication history registration data 106a is referenced to obtain the publication history registration records that match the set extraction conditions (media classification and / or media code). (13) A list of the publication history registration records obtained in (12), with the records sorted from the top by the most recent release date or broadcast date, is displayed in a selectable manner in area MA3 of the inquiry screen MA. (14) When a record including a desired product (a product for which stock inquiry is desired) is selected from the list displayed in area MA3, the inquiry unit 102c is activated.

[0039] The inquiry unit 102c executes the following processes (21) to (26) (see FIG. 4). (21) The inventory inquiry screen MB (hereinafter, sometimes referred to as the “inquiry screen MB”) is displayed on the monitor 114. (22) The product code contained in the record selected in area MA3 of the inquiry screen MA is displayed in areas MB21 and MB22 of the inquiry screen MB, which specify the range of product codes, and a specified store code (specifically, the store code of the store associated with the user who has logged in to the business support device 100, etc.) is displayed in area MB1 of the inquiry screen MB, where the store code is set. (23) The store master 106d is referenced to obtain store codes (other store codes) other than the store code set in area MB1, and the warehouse master 106c is referenced to obtain a warehouse code linked to the warehouse location category "base." (24) One or more product codes are recognized based on the setting state of area MB2 (state of product code range designation).

[0040] (25) For each recognized product code, the following processes (251) to (254) are executed to display a list of display records described in the following (254) for each product code in a selectable manner in area MB3 of the inquiry screen MB. (251) By referring to the current stock data 106b, a current stock record including the product code to be processed and the store code set in the area MB1 is obtained, and by referring to the product master 106e, the retail price linked to the product code to be processed is obtained. (252) For each of the other store codes acquired in (23), the current stock data 106b is referenced to acquire a current stock record including the product code to be processed and the other store code. (253) Referring to the current stock data 106b, a current stock record including the product code to be processed and the warehouse code obtained in (23) is obtained. (254) Display records including the product code to be processed, the product name included in the current inventory record obtained in (251), the current quantity included in the current inventory record obtained in (251), the total current quantity included in the current inventory record obtained in (252), the current quantity included in the current inventory record obtained in (253), and the retail price obtained in (251) are displayed in the inquiry screen MB in the following order from top to bottom: area MB31 for setting the product code, area MB32 for setting the product name, area MB33 for setting the inventory quantity at the store, area MB34 for setting the current inventory quantity at other stores, area MB35 for setting the current inventory quantity at the warehouse, and area MB36 for setting the retail price.

[0041] (26) When a record containing a desired product (a product for which detailed inventory inquiry is desired, including the unstocked status at the store, other stores, and the warehouse) is selected in the list displayed in area MB3, the inquiry unit 102d is activated.

[0042] The inquiry unit 102d executes the following processes (31) to (39) (see FIG. 5). (31) The store displays the other store inventory inquiry screen MC (hereinafter, sometimes referred to as the “inquiry screen MC”) on the monitor 114. (32) The product code contained in the record selected in area MB3 of the inquiry screen MB is displayed in area MC2 of the inquiry screen MC, where the product code is set, and a specified store code (specifically, the store code of the store associated with the user who has logged in to the business support device 100, or the store code set in area MB1 of the inquiry screen MB, etc.) is displayed in area MC1 of the inquiry screen MC. (33) The product code and product name contained in the record selected in area MB3 of the inquiry screen MB are displayed in area MC3 of the inquiry screen MC (area MC31 for setting the product code and area MC32 for setting the product name).

[0043] (34: Acquisition of data required for displaying own store inventory information) By referring to current stock data 106b, a current stock record is obtained that includes the store code set in area MC1 and the product code set in area MC2. By referring to order data 106f, an order record is obtained that includes the store code set in area MC1 and the product code set in area MC2. By referring to transfer data 106g, a transfer record is obtained that includes the product code set in area MC2 and the store code set in area MC1 as the receiving warehouse code. Note that while current stock records can usually always be obtained, there are cases in which order records and transfer records cannot be obtained.

[0044] (35: Display of own store inventory information) The current stock quantity contained in the current stock record obtained in (34) is displayed in the area MC41 for setting the current stock quantity on the inquiry screen MC. If an order record is obtained in (34), the number of items not yet delivered contained in the obtained order record is displayed in the area MC42 for setting the number of items not yet delivered on the inquiry screen MC. If an order record cannot be obtained in (34), the number of items not yet delivered is displayed as zero. If a transfer record is obtained in (34), the number obtained by subtracting the number of items received from the obtained transfer record from the number of items sent from the obtained transfer record is displayed in the area MC43 in the inquiry screen MC, which is used to set the number of items to be transferred but not yet received. If a transfer record cannot be obtained in (34), the number obtained by subtracting the number of items sent from the obtained transfer record from the number of items received from the obtained transfer record is displayed in the area MC43 in the inquiry screen MC, which is used to set the number of items to be transferred but not yet received.

[0045] (36: Acquisition of data required for displaying inventory information at other stores) The store master 106d is referenced to obtain store codes (other store codes) and store names (other store names) other than the store code set in area MC1. For each other store code obtained, current inventory data 106b is referenced to obtain a current inventory record including the other store code and the product code set in area MC2. For each other store code obtained, order data 106f is referenced to obtain an order record including the other store code and the product code set in area MC2. For each other store code obtained, movement data 106g is referenced to obtain a movement record including the product code set in area MC2 and the other store code as the receiving warehouse code. Note that while current inventory records can usually always be obtained, there are cases in which order records and movement records cannot be obtained.

[0046] (37: Display of inventory information at other stores) By executing the following steps (371) to (373) for each other store code, a list of records for the number of other store codes is displayed in area MC5 of the inquiry screen MC. (371) The other store code to be processed, the other store name obtained in (36) corresponding to the other store code to be processed, and the current stock quantity included in the current stock record obtained in (36) corresponding to the other store code to be processed are displayed in the inquiry screen MC in the area MC51 for setting the store code, the area MC52 for setting the store name, and the area MC53 for setting the current stock quantity, from top to bottom. (372) If an order record corresponding to the other store code being processed can be obtained in (36), the number of undelivered items contained in the obtained order record is displayed from top to bottom in area MC54 for setting the number of undelivered items in the inquiry screen MC; if an order record corresponding to the other store code being processed cannot be obtained, zero is displayed. (373) If a transfer record corresponding to the other store code being processed can be obtained in (36), the number obtained by subtracting the number of received items contained in the obtained transfer record from the number of shipped items contained in the obtained transfer record is displayed from top to bottom in area MC55 for setting the number of undelivered items in the inquiry screen MC; if an order record corresponding to the other store code being processed cannot be obtained in (36), zero is displayed.

[0047] (38: Acquisition process of data required for displaying center warehouse inventory information) The warehouse master 106c is referenced to obtain the warehouse code and warehouse name associated with the warehouse location category "base". The current inventory data 106b is referenced to obtain a current inventory record including the obtained warehouse code and the product code set in area MC2. The order data 106f is referenced to obtain an order record including the obtained warehouse code and the product code set in area MC2. The movement data 106g is referenced to obtain a movement record including the product code set in area MC2 and the obtained warehouse code as the receiving warehouse code. The order data 106h is referenced to obtain an order record including the obtained warehouse code and the product code set in area MC2. Note that while the current inventory record can usually always be obtained, there are cases in which the order record, movement record, and order record cannot be obtained.

[0048] (39: Display processing of center warehouse inventory information) The warehouse code obtained in (38), the warehouse name obtained in (38), and the current inventory quantity contained in the current inventory record obtained in (38) are displayed in an area MC61 for setting the warehouse code, an area MC62 for setting the warehouse name, and an area MC63 for setting the current inventory quantity on the inquiry screen MC. If an order record is obtained in (38), the number of items not yet delivered contained in the obtained order record is displayed in the area MC65 for setting the number of items not yet delivered on the inquiry screen MC. If an order record cannot be obtained in (38), the number of items not yet delivered is displayed as zero. If a transfer record is obtained in (38), the number obtained by subtracting the number of items received from the obtained transfer record from the number of items sent from the obtained transfer record is displayed in the area MC66 in the inquiry screen MC, which is used to set the number of items not yet received. If a transfer record cannot be obtained in (38), the number of items not yet received is displayed. If an order record is obtained in (38), the sum of the current inventory quantity set in area MC63, the unarrived quantity set in area MC65, and the transferred unarrived quantity set in area MC66 is subtracted from the sum of the order quantity included in the obtained order record minus the shipped quantity included in the obtained order record (unshipped quantity); if an order record cannot be obtained in (38), the sum is displayed in area MC64, which sets the available quantity on the inquiry screen MC.

[0049] [2. Specific examples of processing] A specific example of the process executed by the business support device 100 configured as described above will be described in detail with reference to Fig. 2 along with an example of a flow of business performed using the business support device 100. Note that the inquiry screens MA, MB, and MC are simplified.

[0050] [Step S1: Headquarters registers the information published in the media (see Figure 2)] First, an employee at the headquarters or the like sets information on publication in the media, exhibition information for events, product identification information, and the like on a publication history input screen (not shown).

[0051] The registration unit 102a then stores the publication information in the media, the exhibition information at events, the product identification information, and the like, set by the employee or the like on the publication history input screen, in the publication history registration data 106a.

[0052] [Step S2: At the store, search for the product using the media information provided by the customer (see Figure 3)] When a customer at an actual store verbally makes an inquiry such as "I want that piece of furniture that was featured in AAA magazine," the store employee sets the medium code "ZS001" corresponding to "AAA magazine" in area MA2 of the inquiry screen MA that is displayed in advance on monitor 114.

[0053] Then, the query unit 102b refers to the publication history registration data 106a, extracts the publication history registration records that include the media code "ZS001", and displays the extracted publication history registration records in area MA3 as a selectable list, with the most recent dates in the "Release Date / Broadcast Date" column displayed at the top, as shown in FIG. 3.

[0054] [Step S3: At the store, check the inventory status at your store (see Figure 4)] A store employee or the like selects the record for which they wish to inquire about inventory, whose "Release Date / Airing Date" is "2023 / 1 / 26," from the list displayed in area MA3 of the inquiry screen MA.

[0055] The inquiry unit 102c then displays an inquiry screen MB on the monitor, sets the product code "HB002" contained in the selected record in areas MB21 and MB22, and sets the store code of the store itself, "TP001", which is preset in the business support device 100, in area MB1.

[0056] Next, the inquiry unit 102c refers to the store master 106d to obtain other store codes "TP002," "TP003," and "TP004" other than the store code "TP001" set in area MB1, and also refers to the warehouse master 106c to obtain the warehouse code "SK001" linked to the warehouse location category "base."

[0057] Next, the inquiry unit 102c recognizes from the setting state of the area MB2 that the only set product code is "HB002".

[0058] Next, the inquiry unit 102c refers to the current stock data 106b to acquire a current stock record including the recognized product code "HB002" to be processed and the store code "TP001" set in the area MB1, and also refers to the product master 106e to acquire the retail price "55,000" linked to the product code "HB002". In addition, the inquiry unit 102c refers to the current stock data 106b to acquire a current stock record including the other store code and the product code "HB002" to be processed for each of the acquired other store codes "TP002", "TP003", and "TP004". In addition, the inquiry unit 102c refers to the current stock data 106b to acquire a current stock record including the acquired warehouse code "SK001" and the product code "HB002" to be processed.

[0059] Next, the inquiry unit 102c displays, from top to bottom, in areas MB31, MB32, MB33, MB34, MB35, and MB36 on the inquiry screen MB, display records including the product code to be processed "HB002," the product name "product number 002" contained in the current stock record acquired for store code "TP001," the current quantity in stock "18" contained in the current stock record, the sum of the current quantities in stock "20" contained in the three current stock records acquired for each of the three other store codes, the current quantity in stock "9" contained in the current stock record acquired for warehouse code "SK001," and the acquired list price "55,000."

[0060] [Step S4: At the store, check the inventory information of other stores and central warehouses (see Figure 5)] A store employee or the like selects a record displayed in area MB3 of the inquiry screen MB.

[0061] Then, the inquiry unit 102c starts the inquiry unit 102d.

[0062] Next, the inquiry unit 102d displays an inquiry screen MC on the monitor 114, and displays the product code "HB002" contained in the selected record in area MC2 of the inquiry screen MC, and displays the store code "TP001" of the store itself, which is preset in the business support device 100, in area MC1 of the inquiry screen MC.

[0063] Next, the inquiry unit 102d displays the product code "HB002" and the product name "product number 002" contained in the selected record in areas MC31 and MC32 of the inquiry screen MC.

[0064] Next, the inquiry unit 102d refers to the current stock data 106b to obtain a current stock record including the store code "TP001" set in area MC1 and the product code "HB002" set in area MC2, refers to the order data 106f to obtain an order record including the store code "TP001" and the product code "HB002", and refers to the transfer data 106g to obtain a transfer record including the store code "TP001" in the input warehouse code column and the product code "HB002" in the product code column. Note that in this explanation, it is assumed that the current stock record and the order record can be obtained, but the transfer record cannot be obtained.

[0065] Next, the inquiry unit 102d displays the current stock quantity "18" contained in the acquired current stock record in an area MC41 of the inquiry screen MC, and displays the undelivered quantity "40" contained in the acquired order record in an area MC42 of the inquiry screen MC. In addition, since the inquiry unit 102d could not acquire a transfer record, it displays zero in an area MC43 of the inquiry screen MC.

[0066] Next, the inquiry unit 102d refers to the store master 106d to acquire other store codes "TP002", "TP003", and "TP004" other than the store code "TP001" set in the area MC1, and other store names "Marunouchi store", "Kyobashi store", and "Nihonbashi store". Next, the inquiry unit 102d refers to the current stock data 106b for each of the acquired other store codes "TP002", "TP003", and "TP004" to acquire a current stock record including the other store code and the product code "HB002" set in the area MC2. In addition, the inquiry unit 102d refers to the order data 106f to acquire an order record including the other store code and the product code "HB002" for each of the acquired other store codes "TP002", "TP003", and "TP004". Furthermore, the inquiry unit 102d refers to the transfer data 106g for each of the acquired other store codes "TP002," "TP003," and "TP004," and acquires a transfer record that includes the other store code in the input warehouse code column and the product code "HB002" in the product code column. Note that in this explanation, it is assumed that only the current inventory record can be acquired for the other store code "TP002," only the current inventory record can be acquired for the other store code "TP003," and only the current inventory record and the transfer record can be acquired for the other store code "TP004."

[0067] Next, the inquiry unit 102d executes the following process for each of the acquired other store codes "TP002", "TP003", and "TP004", thereby displaying a list of three records in an area MC5 of the inquiry screen MC.

[0068] Specifically, first, the inquiry unit 102d displays the other store code "TP002", the acquired other store name "Marunouchi Store" corresponding to the other store code, and the current stock quantity "3" included in the acquired current stock record corresponding to the other store code in areas MC51, MC52, and MC53 of the inquiry screen MC, from top to bottom. Also, since the inquiry unit 102d was unable to acquire an order record corresponding to the other store code, it displays zeros in area MC54 of the inquiry screen MC, from top to bottom. Also, since the inquiry unit 102d was unable to acquire a transfer record corresponding to the other store code, it displays zeros in area MC55 of the inquiry screen MC, from top to bottom.

[0069] Next, the inquiry unit 102d displays the other store code "TP003", the acquired other store name "Kyobashi store" corresponding to the other store code, and the current stock quantity "10" included in the acquired current stock record corresponding to the other store code in areas MC51, MC52, and MC53 of the inquiry screen MC, from top to bottom. Also, since the inquiry unit 102d was unable to acquire an order record corresponding to the other store code, it displays zeros in area MC54 of the inquiry screen MC, from top to bottom. Also, since the inquiry unit 102d was unable to acquire a transfer record corresponding to the other store code, it displays zeros in area MC55 of the inquiry screen MC, from top to bottom.

[0070] Next, the inquiry unit 102d displays the other store code "TP004", the acquired other store name "Nihonbashi store" corresponding to the other store code, and the current stock quantity "7" included in the acquired current stock record corresponding to the other store code in areas MC51, MC52, and MC53 of the inquiry screen MC, from top to bottom. Also, since the inquiry unit 102d was unable to acquire an order record corresponding to the other store code, it displays zero in area MC54 of the inquiry screen MC, from top to bottom. Also, since the inquiry unit 102d was able to acquire a transfer record corresponding to the other store code, it displays the transferred unstocked quantity "5", calculated by subtracting the stock quantity from the outgoing quantity included in the transfer record, in area MC55 of the inquiry screen MC, from top to bottom.

[0071] Next, the inquiry unit 102d refers to the warehouse master 106c to acquire the warehouse code "SK001" and the warehouse name "center warehouse" linked to the warehouse location category "base". Next, the inquiry unit 102d refers to the current inventory data 106b to acquire a current inventory record including the warehouse code and the product code "HB002" set in the area MC2. The inquiry unit 102d also refers to the order data 106f to acquire an order record including the warehouse code and the product code. The inquiry unit 102d also refers to the transfer data 106g to acquire a transfer record including the warehouse code in the warehouse entry warehouse code column and the product code in the product code column. The inquiry unit 102d also refers to the order data 106h to acquire an order record including the warehouse code and the product code. In this explanation, it is assumed that the current inventory record, transfer record, order record, and order record have been acquired.

[0072] Next, the inquiry unit 102d displays the acquired warehouse code "SK001", the acquired warehouse name "Center Warehouse", and the current inventory quantity "9" included in the acquired current inventory record in areas MC61, MC62, and MC63 of the inquiry screen MC. Furthermore, since the inquiry unit 102d was able to acquire an order record, it displays the undelivered quantity "20" included in the acquired order record in area MC65 of the inquiry screen MC. Furthermore, since the inquiry unit 102d was able to acquire a transfer record, it displays "0" obtained by subtracting the received quantity "2" included in the acquired transfer record from the released quantity "2" included in the acquired transfer record in area MC66 of the inquiry screen MC. Next, the inquiry unit 102d displays in area MC64 of the inquiry screen MC the number "25", obtained by subtracting the unshipped quantity "4", which is the order quantity "4" included in the acquired order record minus the shipped quantity "0" included in the acquired order record, from the sum "29" of the current inventory quantity "9" set in area MC62, the unarrived quantity "20" set in area MC65, and the transferred unarrived quantity "0" set in area MC66.

[0073] As described above, according to this embodiment, information such as the posting of a product in a media medium and the lending of the product to a venue is registered in advance, and posting history registration data 106a is created. An employee or the like sets the posting information, etc. as an extraction condition on the posting history inquiry screen MA, identifies a product from the extraction result, transitions from the posting history inquiry screen MA to the store inventory inquiry screen MB, and can confirm the inventory status of the store. Furthermore, transitions from the store inventory inquiry screen MB to the store other store warehouse inventory inquiry screen MC, and can confirm inventory information of stores other than the store and the center warehouse, and even the number of stocks considering the order status when a product is out of stock. Therefore, store employees or the like can easily identify products using media information provided by customers, and can confirm inventory information and arrival schedules, etc., thereby improving the efficiency and quality of customer service. Furthermore, it is also possible to create sales plans, etc.

[0074] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0075] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0076] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0077] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0078] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0079] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0080] Moreover, with regard to the task support device 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0081] For example, the processing functions of the business support device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in the present embodiment, and is mechanically read by the business support device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0082] In addition, this computer program may be stored in an application program server connected to the task support device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0083] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0084] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0085] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0086] The business support device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The business support device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.

[0087] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0088] The present invention is useful in the retail industry and the like. [Explanation of symbols]

[0089] 100 Business support equipment 102 Control section 102a Publication History Registration Section 102b Publication History Inquiry Section 102c Store inventory inquiry section 102d Store and other store warehouse inventory inquiry section 104 Communication interface section 106 Storage section 106a Publication history registration data 106b Current Stock Data 106c Warehouse Master 106d Store Master 106e Product Master 106f Ordering Data 106g Mobile Data 106h Order data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. a first display control unit that acquires a product associated with a predetermined medium specification information from a first storage area that associates and manages medium specification information for identifying a medium on which the product is disclosed and the product, and displays the acquired product on a screen; a second display control unit that refers to a second storage area that manages the stock quantity of each product by product, acquires the stock quantity of the product selected on the screen, and displays the acquired stock quantity on the screen; To have An information inquiry device comprising:

2. The second storage area manages the number of products in stock by product and by store, the second display control unit refers to the second storage area, acquires the stock quantity of the selected product in a predetermined store, and displays the acquired stock quantity on a screen; 2. The information inquiry device according to claim 1,

3. the second display control unit refers to the second storage area, acquires the stock quantity of the selected product in each store other than the specified store, and displays the acquired total stock quantity on a screen; 3. The information inquiry device according to claim 2, wherein:

4. The second storage area manages the number of products in stock by product and by store or warehouse, the second display control unit refers to the second storage area, acquires an inventory quantity of the selected product in the warehouse, and displays the acquired inventory quantity on a screen; 4. The information inquiry device according to claim 3,

5. The predetermined store is a store to which the operator belongs; 5. The information inquiry device according to claim 4,

6. the second display control unit displays, on one screen, the inventory quantity of the selected product in the predetermined store, the total inventory quantity of the selected product in each store, and the inventory quantity of the selected product in the warehouse; 6. The information inquiry device according to claim 5,

7. a third storage area for managing the number of ordered products that have not yet arrived at a store or warehouse, by product type and by store or warehouse; a fourth storage area for managing the number of products that have been moved and shipped from a store and the number of products that have arrived at a store or warehouse, by product type, by store type and by store or warehouse type; and a fifth storage area for managing the number of ordered products and the number of ordered products that have been shipped from a store or warehouse, by product type and by store or warehouse type; a third display control unit that displays on a screen the number of ordered yet to arrive and the number of moved yet to arrive of the selected product at the predetermined store, the number of ordered yet to arrive and the number of moved yet to arrive of the selected product at each store, and the available number, the number of ordered yet to arrive, and the number of moved yet to arrive of the selected product at a warehouse; the third display control unit acquires the number of ordered items not yet arrived from the third memory area, acquires the number of moved and shipped items and the number of moved and shipped items from the fourth memory area, calculates the number of moved items not yet arrived by subtracting the acquired number of moved and shipped items from the acquired number of moved and shipped items, acquires the number of ordered items and the number of ordered items shipped from the fifth memory area, calculates the number of ordered items not yet shipped by subtracting the acquired number of ordered items shipped from the acquired number of ordered items, and calculates the number of available items by subtracting the calculated number of ordered items not yet shipped from the sum of the inventory number acquired by the second display control unit, the acquired number of ordered items not yet arrived, and the calculated number of moved items not yet arrived; 7. The information inquiry device according to claim 6,

8. a first display control step in which a first display control unit acquires a product linked to predetermined medium identification information from a first storage area that associates and manages medium identification information for identifying a medium on which the product is disclosed and the product, and displays the acquired product on a screen; a second display control step of causing a second display control unit to refer to a second storage area that manages the stock quantity of each product by each product, acquire the stock quantity of the product selected on the screen, and display the acquired stock quantity on the screen; 13. An information inquiry method comprising:

9. An information processing device, a first display control means for acquiring a product linked to predetermined medium identification information from a first storage area that links and manages medium identification information for identifying a medium on which the product is disclosed and the product, and for displaying the acquired product on a screen; a second display control means for referencing a second storage area for managing the stock quantity of each product on a product-by-product basis, acquiring the stock quantity of the product selected on the screen, and displaying the acquired stock quantity on the screen; An information inquiry program to function as a

Images