JP5457422B2 - Information processing apparatus and program - Google Patents

Description

  Embodiments described herein relate generally to an information processing apparatus and a program.

  With the spread of networks in recent years, a sales method (EC: Electronic Commerce) for selling products via the Internet is actively performed. Also, in a store such as a supermarket, a so-called “net supermarket” sales method is performed in which products sold in the store are sold via the Internet.

In order to build a net super system as described above, there are multiple sources of data as shown below, so it is necessary to collectively manage which products at which stores are displayed at what prices. .
(1) Price information from the store server provided at each store (2) Product information from the headquarter server as a higher system (3) Maintenance information on the net super site of the net super server

  The information processing apparatus according to the embodiment includes a store information receiving unit that receives product information for each store from a first server group that stores a product master file for the store that stores various product information sold in the store for each store. , Common information receiving means for receiving product information common to all stores from a second server holding a product master file storing product information common to all stores to be transmitted to the first server group, and product information for each store And product information common to both stores and product extraction means for extracting a transmission target product to be transmitted to a third server operating a site for providing a net super service, Handling setting means for setting whether or not the product to be transmitted is handled by the Internet super service, and whether or not the product is handled by the internet super service Comprising a master file generating means for generating a product master file for online supermarket which stores product information relating to the constant has been the transmission Shipping and.

  The program according to the embodiment includes a store information receiving unit that receives product information for each store from a first server group that stores for each store a product master file for the store that stores various product information sold in the store, Common information receiving means for receiving commodity information common to all stores from a second server holding a commodity master file for storing commodity information common to all stores to be transmitted to the first server group, commodity information for each store, and Product extraction means for extracting a transmission target product that is common to both stores and that is a transmission target for a third server that operates a site for providing an Internet super service, from the product information common to all stores, and the transmission target Handling setting means for setting whether or not the product is handled by the Internet super service, and whether or not the product is handled by the internet super service. A master file generating means for generating a product master file for online supermarket which stores product information related to the transmission Shipping that is, causes a computer to function as.

FIG. 1 is a system configuration diagram schematically showing the overall configuration of a sales system. FIG. 2 is a block diagram showing the configuration of the product management server. FIG. 3 is a schematic diagram showing a configuration of a store product master management file. FIG. 4 is a schematic diagram showing the configuration of the headquarters product master management file. FIG. 5 is an explanatory diagram schematically showing a procedure for creating and transmitting a product master for an internet supermarket. FIG. 6 is a flowchart showing the flow of master file generation and transmission processing. FIG. 7 is an explanatory diagram illustrating a transmission target product extraction process. FIG. 8 is an explanatory diagram showing the handling of the handling flag. FIG. 9 is an explanatory diagram showing the handling of the handling flag. FIG. 10 is an explanatory diagram showing the handling of the handling flag. FIG. 11 is a schematic diagram illustrating an example of a merchandise master for internet supermarkets. FIG. 12 is a schematic diagram illustrating an example of a merchandise master for internet supermarkets. FIG. 13 is a diagram illustrating an example of transmission target conditions. FIG. 14 is a flowchart showing the flow of the master maintenance process. FIG. 15 is a front view showing an example of the condition selection screen. FIG. 16 is a schematic diagram illustrating a display control example of the condition selection screen. FIG. 17 is a front view illustrating an example of a product list screen. FIG. 18 is an explanatory diagram of an example of priority order assignment. FIG. 19 is an explanatory diagram of an example of priority order assignment. FIG. 20 is an explanatory diagram of an example of priority order assignment. FIG. 21 is an explanatory diagram of an example of priority order assignment. FIG. 22 is an explanatory diagram of an example of priority order assignment. FIG. 23 is a front view showing an example of an all-store common information maintenance screen. FIG. 24 is a front view showing an example of the store-specific information maintenance screen.

  Hereinafter, with reference to an accompanying drawing, an information processor concerning an embodiment and an embodiment of a program are described in detail. The present invention is not limited to the embodiments described below.

  FIG. 1 is a system configuration diagram schematically showing the overall configuration of the sales system 1. As shown in FIG. 1, the sales system 1 connects a plurality of point-of-sale (POS) terminals 2 as product sales data processing devices and each POS terminal 2 via a LAN 3 to perform centralized management. A POS system 7 provided in each store with a store server 4 that is one server, a headquarter server 13 that is a second server that connects the store server 4 via a dedicated line 8, and a store via a dedicated line 8 And a merchandise management server 14 to which the server 4 is connected. The headquarter server 13 and the product management server 14 are connected by a LAN 9.

The POS system 7 will be briefly described. The store server 4 includes a control unit having a computer configuration including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), an input device such as a keyboard and various buttons, a CRT, an LCD, and the like. A display device, a storage device such as an HDD or a flash memory for storing a product master file for a store that stores various product information sold in the store, a communication interface that can be connected to the network 5 and the like (not shown) ) The control unit executes the predetermined program stored in the storage device, thereby taking control of the POS system 7 as a whole.

The POS terminal 2 is allocated at a checkout location with a unique cash register number, and is a terminal for the cashier to perform sales processing. The POS terminal 2 is connected with a keyboard, drawer, display, card reader / writer, code scanner, and the like. When the POS terminal 2 reads a product code added to each product in the form of a barcode, a two-dimensional code, or the like by a code scanner, the POS terminal 2 makes an inquiry about the product by notifying the store server 4 of the product code. The store server 4 searches the product master file in response to an inquiry from the POS terminal 2, reads product information corresponding to the corresponding product code, and transmits it to the POS terminal 2. The POS terminal 2 acquires the unit price of the corresponding product from the store server 4. In addition, the POS terminal 2 calculates the total amount of these products based on the unit price and the number of products to be purchased, performs a process such as payment, generates sales data, and then stores the sales data at a predetermined timing. It transmits to the store server 4.

  In addition, as shown in FIG. 1, the sales system 1 provides a net super service for selling products sold in a store where the POS system 7 is installed via a network 5 such as the Internet. The network super server 6 which is a third server for managing the site is provided. The net super server 6 can be connected from the customer terminal 10 via the Internet 5.

  The net super server 6 includes a control unit having a computer configuration including a CPU, a ROM, a RAM, an input device such as a keyboard and various buttons, a display device such as a CRT and an LCD, a storage device such as an HDD and a flash memory, and a network 5. A communication interface that can be connected to the computer (none of which are shown), and various control units are realized by the control unit executing predetermined programs stored in the storage device (for example, Web applications, database programs, etc.) To do.

  The customer terminal 10 is a terminal device such as a personal computer (PC) or a mobile phone operated by an Internet supermarket customer (user). The customer terminal 10 can be connected to a control unit composed of a CPU, ROM, RAM, etc., an input device such as a keyboard and various buttons, a display device such as a CRT and an LCD, a storage device such as an HDD and a flash memory, and a network 5 A communication interface or the like (not shown) is provided, and various functions are realized by the control unit executing a predetermined program (for example, a Web browser) stored in the storage device.

  Each store also has a supermarket management server 11 that receives and manages an ordered merchandise list including the ordered merchandise received by the net super server 6 from the net super server 6 and an ordered merchandise list received by the net super server 6. A packing device 12 is provided that is used for packing work for sorting the products for which the corresponding products are collected from the store for each customer.

  The net super management server 11 includes a control unit having a computer configuration including a CPU, a ROM, a RAM, an input device such as a keyboard and various buttons, a display device such as a CRT and an LCD, a storage device such as an HDD and a flash memory, and a LAN 3 Or a communication interface that can be connected to the network 5 (none of which is shown), and the control unit executes a predetermined program (for example, a Web application, a database program, etc.) stored in the storage device, thereby Manage various data necessary to provide services.

The headquarter server 13 is a computer-configured control unit (CPU (Central Processing Unit), ROM (Read Only Memory), RAM (Random Access Memory), etc.
(Not shown) for managing sales data transmitted from the store server 4 of each store, or transmitting a product master file common to all stores to the store server 4 and the product management server 14 of each store It is a server that manages various data necessary for providing the Internet super service.

The merchandise management server 14 is an information processing apparatus that collectively manages which merchandise of which store is displayed on the site at what price when providing the net super service, and its electrical system is, for example, as shown in FIG. It is made into the composition.

  Here, FIG. 2 is a block diagram showing a configuration of the product management server 14. As shown in FIG. 2, the merchandise management server 14 includes a control unit 31 having a computer configuration including a CPU, a ROM, a RAM, and the like, a bus 32, a first communication interface 331 that can be connected to the LAN 9, and a network 5. A connectable second communication interface 332, a third communication interface 333 connectable to the dedicated line 8, an I / O device control unit 34, an operation input unit 35 including a keyboard and a mouse, a CRT and an LCD And a storage unit 37 configured by a storage device such as an HDD or a flash memory.

  The control unit 31 is configured to be able to execute online communication with the headquarter server 13 via the first communication interface 331 connected to the bus 32. Further, the control unit 31 is configured to be able to execute online communication with the net super server 6 via the second communication interface 332 connected to the bus 32. The control unit 31 is configured to be able to execute online communication with the store server 4 via the third communication interface 333 connected to the bus 32. Furthermore, an operation input unit 35, a display unit 36, and a storage unit 37 are connected to the control unit 31 via a bus 32 and an I / O device control unit 34.

  The storage unit 37 stores various programs executed by the control unit 31 and various setting information related to the execution of the programs. The control unit 31 realizes various functional units in cooperation with a predetermined program stored in the storage unit 37, and executes a master file generation and transmission process, a master maintenance process, and the like, which will be described later.

  In addition, the storage unit 37 includes a store product master management file 371, a headquarters product master management file 372, a product master file 373 for an internet supermarket, and the like as data necessary for the operation of the sales system 1.

  FIG. 3 is a schematic diagram showing the configuration of the store product master management file 371. As shown in FIG. 3, the store product master management file 371 is provided for each store, and each product sold in the store that is a part of the store product master transmitted from the store server 4. The product code information 100 is held.

  The store server 4 stores the product master (product code information, product name, unit price, category) of products that have been sold in the past year from all the products held in the store server 4 at a specified time (for example, during the closing process). , Special sales information, etc.) are extracted and transmitted to the product management server 14. The control unit 31 (store information receiving means 51 shown in FIG. 2) of the product management server 14 stores the product master (product code information, product name, unit price, category, sale) of the product transmitted from the store server 4 to the product management server 14. Information etc.) is received and stored in the store product master management file 371.

Here, the product code information 100 includes a product code 101 such as JAN (Japanese Article Number) that can identify each product and a company code 102. The company code 102 is information for collecting products with different production areas as one product. The product code 101 is added in advance to each product sold in the store in the form of a barcode or the like. The product code information 100 stored in the store product master management file 371 is transmitted from the store server 4 at a specified time (for example, during the closing process).

FIG. 4 is a schematic diagram showing a configuration of the headquarters product master management file 372. As shown in FIG. 4, the headquarters product master management file 372 includes a product category 204, a product name 205, a unit price 206, and bargain information for each product code information 200 of each product sold at all stores and online supermarkets. 207, bundle information 208 and the like are associated with each other.

  The headquarter server 13 creates a product master (product code information 200 or the like) of the product managed by the headquarter server 13 as CSV data, and transmits it from the headquarter server 13 to the product management server 14 as needed. The control unit 31 (common information receiving means 52 shown in FIG. 2) of the product management server 14 receives the product master (product code information 200 and the like) transmitted from the headquarter server 13 to the product management server 14 and receives the headquarters product master. Store in the management file 372.

Here, the product code information 200 includes a product code 201 such as JAN (Japanese Article Number) that can identify each product, a company code 202, and a representative flag 203. The company code 202 is information for collecting products with different production areas as one product. The representative flag 203 is for avoiding, for example, a large number of the same products with different production areas being lined up in the net supermarket when there are a plurality of products with the same company code 202. That is, when the same company code 202 is set for a plurality of products, one product is set as a product to be displayed on the Internet supermarket with the representative flag 203 set to “1”. Even when the company code 202 is not set over a plurality of product codes 201, the representative flag 203 is set to “1” and distributed.

  The product supermarket product master stored in the product supermarket master file 373 is created in the product management server 14 at a preset time. FIG. 5 is a schematic diagram schematically showing a procedure for creating and transmitting a product master for an internet supermarket. As shown in FIG. 5, the product management server 14 uses the data stored in the store product master management file 371 and the data stored in the headquarters product master management file 372 to perform master file generation and transmission processing. By executing, a product master for net supermarket is generated and transmitted.

  Here, master file generation and transmission processing in the merchandise management server 14 will be described. The control unit 31 of the product management server 14 cooperates with a master file generation and transmission program stored in the storage unit 37 to provide various functional units (store information receiving means 51, common information receiving means 52, product extracting means 53, Master file generation means 54, transmission means 55, etc.), and executes master file generation and transmission processing.

FIG. 6 is a flowchart showing the flow of master file generation and transmission processing. As shown in FIG. 6, the control unit 31 (product extraction means 53) of the product management server 14 is set at a preset time based on the current date and time measured by a time measuring unit such as an RTC (Real Time Clock) (not shown). If it is determined that it has become (step S1; Yes), a transmission target product extraction process is executed (step S2).

  The product extraction unit 53 compares the data stored in the store product master management file 371 with the data stored in the headquarters product master management file 372 in the transmission target product extraction process of step S2. Are extracted to a work table (RAM).

The transmission target product extraction process in step S2 will be described with reference to a specific example shown in FIG. As shown in FIG. 7, the control unit 31 of the product management server 14 compares the data stored in the store product master management file 371 with the data stored in the headquarters product master management file 372, and When there is a common product code and company code in the file, a product having the common product code and company code is extracted as a transmission target product. According to the example shown in FIG. 7, the above three products are products having the same product code and company code, and only the representative product “4900000000001” has the representative flag 203 set to “1”. Yes. Further, according to the example shown in FIG. 7, the handling flag 301 is set to “1” indicating that the handling flag 301 is “handled” for all the above three products.

  Further, the fourth product from the top shown in FIG. 7 is “handled” + “representative product” because there is no other product having the same product code. Therefore, according to the example shown in FIG. 7, the number of products transmitted to the net super server 6 is two products.

  The handling flag 301 is information that only the merchandise management server 14 has, and transmission to the net super server 6 is controlled by the information. For a product just transmitted from the store server 4 or the headquarter server 13, the handling flag 301 is set to “0” indicating “not handled”. A product for which the handling flag 301 is set to “0” is not transmitted to the network super server 6. On the other hand, products whose handling flag 301 is set to “1” indicating that “handling is available” in the master maintenance process described later in the product management server 14 are transmitted to the net super server 6.

  The handling of the handling flag 301 by the control unit 31 of the merchandise management server 14 will be described in detail.

  FIG. 8 is an explanatory diagram showing how the handling flag 301 is handled when a product not managed by the product management server 14 is received from the store server 4 or the headquarter server 13. As shown in FIG. 8, when a product not managed by the product management server 14 is collected from the store server 4 or received from the headquarter server 13, the handling flag 301 is set to “0” indicating “not handled”. Is set. Therefore, this product is transmitted to the net super server 6 unless maintenance is performed to change the handling flag 301 to “1” indicating “handled” in the master maintenance process described later in the merchandise management server 14. There is no.

  FIG. 9 is an explanatory diagram showing the handling of the handling flag 301 when the merchandise (handled) managed by the merchandise management server 14 is received from the store server 4 or the headquarter server 13. As illustrated in FIG. 9, when a product (handled) managed by the product management server 14 is received from the store server 4 or the headquarter server 13, the control unit 31 of the product management server 14 uses the received content as internal information. However, the handling flag 301 is left as it is. This means that “1” indicating that the handling flag 301 is “handled” means that the product is transmitted to the Internet super server 6 and sold at the Internet supermarket, and the product information has been sent. That is because it is determined that there is an intention to modify information on the Internet supermarket.

  FIG. 10 is an explanatory diagram showing the handling of the handling flag 301 when the merchandise (not handled) managed by the merchandise management server 14 is received from the store server 4. As shown in FIG. 10, the merchandise managed by the merchandise management server 14 but received the merchandise (no handling) set to “0” indicating that the handling flag 301 is “not handled” from the store server 4. In this case, the control unit 31 of the merchandise management server 14 does not perform internal update because the merchandise is a merchandise that is not handled on the Internet supermarket side.

  When the transmission target product extraction process in step S2 is completed as described above, the control unit 31 (master file generation unit 54) of the product management server 14 executes a master generation process for generating a product master for the net supermarket (step S3).

In the master generation process in step S3, various data associated with the product for which the handling flag 301 extracted as the product transmitted to the net super server 6 in the transmission target product extraction process in step S2 is set to “1”. Are acquired from the store product master management file 371 and the headquarters product master management file 372, and set as the product master for the net supermarket. Here, FIG. 11 shows an example of a product master for a net supermarket for a normal product with a JAN code, and FIG. 12 shows an example of a product master for a net supermarket for a NON-PLU product. .

  The control unit 31 (transmission means 55) of the merchandise management server 14 selects the net supermarket among the transmission target merchandise stored in the net supermarket merchandise master file 373 storing the net supermarket merchandise master generated as described above. The product information related to the transmission target product handled by the service is transmitted to the net super server 6 (step S4), and the process is terminated.

In the present embodiment, it is determined whether or not the product is to be transmitted to the net super server 6 based on the handling flag 301 managed by the product management server 14, but the transmission target condition is limited to this. is not. For example, as shown in FIG. 13, it is determined whether or not the product is to be transmitted to the net super server 6 based on the handling flag considering the store, the handling flag considering the NON-PLU product, the handling period, the actual selling price, and the like. It may be determined.

  By the way, the operators (users) of the product management server 14, the headquarter server 13, and the store server 4 are generated from the product master received from the headquarter server 13 and the store server 4 as described above, and the product master file 373 for the net supermarket. For the product master for internet superstores stored in, the product to be transmitted to the internet super server 6 can be selected, and various product information registered in the product master can be maintained.

  Next, the master maintenance process in the product management server 14 will be described. The control unit 31 of the merchandise management server 14 operates in cooperation with a master maintenance program stored in the storage unit 37 (functional setting unit 56, display order setting unit 57, store information changing unit 58, common information changing unit). 59 and the like, and the master maintenance process is executed.

  FIG. 14 is a flowchart showing the flow of the master maintenance process. As illustrated in FIG. 14, when the control unit 31 of the product management server 14 receives an operator (user) master maintenance instruction via a Web application from any terminal on the sales system 1 (step S <b> 11; Yes), A condition selection screen, which is a GUI for executing merchandise maintenance processing, is displayed on the terminal instructed for master maintenance (step S12).

  Here, FIG. 15 is a front view showing an example of the condition selection screen 400. A condition selection screen 400 shown in FIG. 15 is a screen for narrowing down products to be maintained. The condition selection screen 400 displays a code for selecting a product to be maintained (maintenance classification) by specifying a scan code by operating the scan code specifying button 401, specifying a product code by operating the product code specifying button 402, and a category code specifying button 403. Any one of the category code designations by the operation of can be selected.

  In the condition selection screen 400, when a scan code is designated by operating the scan code designation button 401, a code for selecting a product to be maintained is operated by a scanner input in the scan code designation area 404 and a manual input of the scan code. To execute it. Thereby, the product of the designated scan code is extracted.

In the condition selection screen 400, when a product code is designated by operating the product code designation button 402, the operator (user) designates a code for selecting a product to be maintained by manual entry of the product code in the product code designation area 405. To run. As a result, products for which the designated product code is set are extracted.

  In the condition selection screen 400, when category code is designated by operating the category code designation button 403, the category to which the product to be maintained belongs is manually input from the category code pull-down menu (category list) in the category code input area 406. Have the operator (user) specify the code to select. Also, when a category is designated from the category list, categories and products belonging to the category designated in the category code designation area 407 are extracted, and a desired product is designated to the operator (user) by specifying conditions for narrowing down. Let it run.

  In the condition selection screen 400, items that can be input are controlled by specifying the maintenance category. As shown in FIG. 16, when the maintenance category is selected, the GUI other than the selected maintenance category is grayed out and cannot be input or selected. Note that, as an initial state, scan code designation by operation of the scan code designation button 401 is selected.

  The tool button will be described. The confirm button 408 is a button for confirming the designated code. The end button 409 is a button for ending the product maintenance and returning to the menu. The previous screen button 410 is a button for ending the product maintenance and returning to the previous screen (not shown).

  When the conditions for narrowing down the products to be maintained are designated on the condition selection screen 400 (step S13; Yes), the control unit 31 (the handling setting unit 56 and the display order setting unit 57) of the product management server 14 A product that matches the conditions specified on the condition selection screen 400 is extracted from the product master file 373 for the net supermarket (step S14), and a product list screen that is a GUI for causing the terminal instructed to perform master maintenance to select a product is displayed. It is displayed (step S15).

  Here, FIG. 17 is a front view showing an example of the product list screen 500. The product list screen 500 shown in FIG. 17 displays the products extracted from the net supermarket product master file 373 in a list format in the product list 501 according to the conditions specified on the condition selection screen 400. The product list screen 500 is a screen for setting a handling flag 502, a handling period 503, and a site display order 504.

  The number of transmission products 505 displays the current number of products to be transmitted (total of all stores). The transmission target mark 506 is displayed by adding “O” to the transmission target product to be transmitted to the network super server 6.

  The scan code 507 displays the product of the designated scan code when the scan code is designated. The scan code 507 displays a product for which the designated product code is set when the product code is designated. The scan code 507 displays a product for which the specified category is set when the category code is specified.

  The product code 508 initially displays the “product code” received from the headquarter server 13. The product name 509 initially displays the “product name” received from the headquarter server 13. The representative flag 510 is a transmission condition to the network super server 6 together with the handling flag 502.

The tool button will be described. The product detail button 511 is a button for moving to an all-store common information maintenance screen, which will be described later, related to the product selected on the product list screen 500. If the setting has been changed, a confirmation message to “confirm maintenance contents” is displayed. The confirmation button 512 is a button for confirming maintenance contents. After pressing the confirmation button 512, a confirmation message “confirm maintenance contents” is displayed, and the confirmation is made when a “Yes” button (not shown) is selected. The end button 513 is a button for ending the product maintenance and returning to the menu. If the setting has been changed, a confirmation message “Discard maintenance details” is displayed. The previous screen button 514 is a button for returning to the condition selection screen 400. If the setting has been changed, a confirmation message “Discard maintenance details” is displayed.

  Next, the setting process in the product list screen 500 will be described in detail.

  The handling flag 502 is an inputable item, and is used to set which product is to be handled at the internet supermarket. For products handled at the online supermarket, the handling flag 502 is set to “1” indicating “handled”. A product for which the handling flag 502 is set to “1” is transmitted to the net super server 6. Note that a product for which the handling flag 502 is set to “0” cannot be maintained thereafter.

  The handling period 503 is an inputable item, and sets the period for handling the product as the handling start and handling end. The handling period 503 makes it possible to set a period for products posted on the site for a certain period, such as seasonal products.

  The site display order 504 is an inputable item, and sets the display order on the site by designating the highest priority flag and the priority order. The highest priority flag and the priority order are information for controlling the display order when the site is posted. Basically, a special sale product, a bundle product, and a normal product are displayed in this order, and the highest priority flag is used when it is desired to display them regardless of these. The priority order is divided into information that is automatically assigned and information that is input from the product list screen 500. When transmitting to the net super server 6, the control unit 31 of the product management server 14 determines and transmits the final priority order (display order) from both pieces of information. The net super server 6 determines the display order based on the priority order and the product code.

  Here, automatic allocation in priority order will be described. The priority order (automatic allocation) is updated when the merchandise master is updated in the store server 4 or the head office server 13. At the time of updating the product master, it is checked whether there is any special sale or bundled planned product in the product master of the store server 4 or the headquarter server 13 at that time. “300” is set when it exists, “200” is set when there is a special bundle product, and “900” is set when it is a normal product.

  When the priority order is not maintained on the product list screen 500, as shown in FIG. 18, the priority order is assigned in the order of the special sale product, the bundle product, and the normal product, and is displayed in that order on the site. .

  On the other hand, the priority order of the special sale product, bundle product, and normal product that can be input in the maintenance on the product list screen 500 is “1-9”. “1” has the highest priority, and “9” has the lowest priority. In the product list screen 500, as shown in FIG. 19, the products whose priority “9” is changed to “8” among the specially-sold products that are automatically assigned are displayed in order on the site. It will be. Also, as shown in FIG. 20, when the highest priority product is set on the product list screen 500, the priority order automatically assigned is ignored, so that it is displayed at the top regardless of special sale, bundle, or normal. become.

In addition, as shown in FIG. 21, since the order in which priority is automatically assigned to the products for which the sale period has ended is the normal products, the display order is the lowest. However, as shown in FIG. 22, the priority order input on the product list screen 500 does not return to the original order, so that it is displayed at the top in the normal product.

  When the “Yes” button of the confirmation message “Confirm maintenance contents” is selected after pressing the confirmation button 512 on the product list screen 500 (Step S16; No, Step S17; Yes), the product master for the net supermarket The setting contents determined for the file 373 are changed (step S18).

  On the other hand, when the product detail button 511 is operated on the product list screen 500 (step S16; Yes), the control unit 31 (common information changing unit 59) of the product management server 14 sends the product list to the terminal instructed for the master maintenance. An all-store common information maintenance screen related to the product selected on the screen 500 is displayed (step S19).

  Here, FIG. 23 is a front view showing an example of an all-store common information maintenance screen 600. A store-wide common information maintenance screen 600 shown in FIG. 23 is a screen for performing maintenance on the product selected on the product list screen 500, and is a screen for performing maintenance on common information for all stores.

  The all-store common information maintenance screen 600 displays product information 601 during maintenance as a display item. The in-maintenance product information 601 displays “scan code”, “product code”, and “product name” of the product currently being maintained.

  Store-wide common information 602 is an area where maintenance of store-wide common information is performed, and includes manufacturer name 6021, product name 6022, standard name 6023, catch phrase 6024, product detailed description 6025, product image file name 6026, temperature classification (freezing, Refrigerated, room temperature) 6027, headquarter selling price 6028, etc. can be input. If the headquarter selling price is set, the headquarter selling price, not the store selling price, is transmitted to the net super server 6 (headquarter selling price priority). Even if the same product is collected from the store, the selling price of the headquarters is not cleared.

  The site posting image 603 is an area for displaying a site image in order to confirm how the set information is displayed on the site. In the site posting image 603, a product image 6031, a product code 6032, a manufacturer name 6033, a product name 6034, a standard 6035, a production name 6036, a catch phrase 6037, an actual selling price 6038, a store abbreviation 6039, and the like are displayed. The actual selling price of a normal product is displayed when the selling price of the headquarters is set, and the selling price when the selling price is not set. The actual sale price of the NON-PLU product displays the price set in the NON-PLU information.

  The tool button will be described. The store detail button 604 is a button for moving to a store-specific information maintenance screen (to be described later) related to the product selected on the all-store common information maintenance screen 600. If the setting has been changed, a confirmation message to “confirm maintenance contents” is displayed. The confirmation button 605 is a button for confirming the maintenance content. After pressing the confirmation button 605, a confirmation message “confirm maintenance contents” is displayed, and the confirmation is made when a “Yes” button (not shown) is selected. An end button 606 is a button for ending the product maintenance and returning to the menu. If the setting has been changed, a confirmation message “Discard maintenance details” is displayed. The previous screen button 607 is a button for returning to the product list screen 500. If the setting has been changed, a confirmation message “Discard maintenance details” is displayed.

After the confirmation button 605 is pressed on the all-store common information maintenance screen 600, a “Yes” button in a confirmation message “Confirm maintenance contents” is selected (step S).
20; No, Step S21; Yes), the set content determined for the headquarters product master management file 372 is changed (Step S22).

  On the other hand, when the store-specific details button 604 is operated on the all-store common information maintenance screen 600 (step S20; Yes), the control unit 31 (store information changing means 58) of the merchandise management server 14 sends the terminal to which master maintenance is instructed. Then, the store-specific information maintenance screen related to the product selected on the all-store common information maintenance screen 600 is displayed (step S23).

  Here, FIG. 24 is a front view showing an example of the store-specific information maintenance screen 700. The store-specific information maintenance screen 700 shown in FIG. 24 is a screen for performing maintenance for each product on the store selected on the store-wide common information maintenance screen 600 (product list screen 500). Maintenance is not required for products that are commonly set in all stores, but products that have stores that are not handled or that have different selling prices are set on this screen.

  The store-specific information maintenance screen 700 displays product information 701 during maintenance as a display item. The in-maintenance product information 701 displays the “scan code”, “product code”, and “product name” of the product currently being maintained.

  The number of transmitted products (store total) 702 displays the current number of products to be transmitted (store total). The store selection list 703 is a list for selecting a store to be maintained. After a maintenance target store is selected from the store selection list 703, the number of products sent at that store is displayed.

  The headquarter selling price 704 displays the headquarter selling price as a reference below an actual selling price input area to be described later. The “special sale” indicator 705 is displayed when special sale information is set. The “M & M” indicator 706 is displayed when bundle information is set.

  The store-specific information 707 is an area where maintenance of information of each store is performed, and includes a handling category 7071, a handling period (start / end) 7072, an actual selling price 7073, a production area name 7074, a stock 7075, a sales limit (one day). 7076, sales limit (one transaction) 7077, sales promotion category 7078, flight control flag 7079, and the like can be input.

  The NON-PLU information 708 can be input when the selected product is a NON-PLU product. In the NON-PLU information 708, a handling category 7081, a product name 7082, a standard name 7083, a price 7084, and the like can be input.

  The tool button will be described. The store specific determination button 709 is a button for determining the content of maintenance. After pressing the store specific button 709, a confirmation message “Confirm maintenance contents” is displayed, and the confirmation is made when a “Yes” button (not shown) is selected. If the product is a special sale or bundle, if the actual sale price has been changed, a confirmation message indicating that the plan may not be established is displayed. The end button 710 is a button for ending the product maintenance and returning to the menu. If the setting has been changed, a confirmation message “Discard maintenance details” is displayed. The previous screen button 711 is a button for returning to the all-store common information maintenance screen 600. If the setting has been changed, a confirmation message “Discard maintenance details” is displayed.

When the control unit 31 of the merchandise management server 14 depresses the store-specific determination button 709 on the store-specific information maintenance screen 700, the “Yes” button of the confirmation message “Confirm maintenance contents” is selected (step S24). ; Yes), store product master management file 3
The setting content determined for 71 is changed (step S25).

  The master maintenance process described above is repeated until the end of the product maintenance is declared by operating the end button 710.

  When the end button 710 is operated and the end of the product maintenance is declared (step S26; Yes), the control unit 31 of the product management server 14 maintains the maintenance data for each store created by the product maintenance process by the operation from the GUI. (Product Master) is transmitted to the net super server 6 (step S27).

  As described above, according to the present embodiment, the merchandise price information from the store server 4 provided in each store and the product information from the head office server 13 serving as the host system are common to both, and The net super server product master file collectively manages the transmission target products to be transmitted to the net super server 6 that operates the site for providing the service, and the net super server 6 maintains the net super site at the net super site. Since the product master file is used, even if there are multiple sources of data as in the net super system, which products at which stores are displayed at what prices. Can be managed collectively.

  In other words, according to the present embodiment, it is possible to operate a net supermarket at a price determined by the headquarters side even for products with different selling prices at a plurality of stores.

  In addition, you may make it utilize cloud computing for implementation | achievement of the system containing the net super server 6, the headquarters server 13, the merchandise management server 14, etc. which were mentioned above. More specifically, a software provision form called Software as a Service (SaaS) is suitable.

  The program executed by each device of the above embodiment may be configured to be provided by being incorporated in advance in a ROM or the like. The program may be provided by being recorded in a computer-readable recording medium such as a CD-ROM, a flexible disk (FD), a CD-R, or a DVD in an installable or executable format file. Good.

  Further, the program may be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network. Further, the program may be provided or distributed via a network such as the Internet.

  Although several embodiments of the present invention have been described, these embodiments are presented by way of example and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and the equivalents thereof.

4 First Server 6 Third Server 13 Second Server 14 Information Processing Device 51 Store Information Receiving Means 52 Common Information Receiving Means 53 Product Extracting Means 54 Master File Generating Means 55 Transmitting Means 56 Handling Setting Means 57 Display Order Setting Means 58 Store Information Changing means 59 Common information changing means

JP 2011-164775 A

Claims (6)

Store information receiving means for receiving merchandise information for each store from a first server group that holds a merchandise master file for each store that stores various product information sold at the store;
Common information receiving means for receiving commodity information common to all stores from a second server holding a commodity master file for storing commodity information common to all stores to be transmitted to the first server group;
From the product information for each store and the product information common to all stores, a transmission target product that is common to both and is a transmission target for a third server that operates a site for providing an Internet super service is extracted. Product extraction means;
Handling setting means for setting whether to handle the product to be transmitted by the Internet super service;
A master file generating means for generating a product master file for a net super that stores product information related to the transmission target product that is set whether or not to handle the net super service;
An information processing apparatus comprising: Of the transmission target products stored in the product master file for the net supermarket, further comprising transmission means for transmitting product information related to the transmission target product handled by the net super service to the third server,
The information processing apparatus according to claim 1. For the transmission target product, further comprising a display order setting means for setting the display order of the transmission target product at the site operated by the third server at the site,
Information for setting the display order of the transmission target product at the site operated by the third server in the product information related to the transmission target product stored in the product master file for the net supermarket Included,
The information processing apparatus according to claim 1. Store information change means for changing the setting of the product information for each store received from the first server group;
The information processing apparatus according to claim 1. Further comprising common information changing means for changing the setting of commodity information common to all stores received from the second server.
The information processing apparatus according to claim 1. Store information receiving means for receiving merchandise information for each store from a first server group that holds a merchandise master file for each store that stores various product information sold at the store;
Common information receiving means for receiving commodity information common to all stores from a second server holding a commodity master file for storing commodity information common to all stores to be transmitted to the first server group;
From the product information for each store and the product information common to all stores, a transmission target product that is common to both and is a transmission target for a third server that operates a site for providing an Internet super service is extracted. Product extraction means;
Handling setting means for setting whether to handle the product to be transmitted by the Internet super service;
A master file generating means for generating a product master file for a net super that stores product information related to the transmission target product that is set whether or not to handle the net super service;
As a program to make the computer function.

Images