JP2003085350A - Sales management device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To handle the order receipt of a net shop in the same manner as in the control for each customer in an actual shop by linking the order receipt to an existing sales management system. SOLUTION: A shop terminal 2 receives the contents of an order and information on an orderer from a shopping mall site 1. When the information on the orderer is already registered in a customer master file F3 on the sales management system 21 side, the shop terminal updates sales results in the customer master file F3 corresponding to the orderer base on the contents of the order of the net sales. When the information on the orderer is not registered, the shop terminal 2 registers the information on the orderer additionally to the customer master file F3, and registers the contents of the order of the net sales additionally to the customer master file F3 as the sales results corresponding to the orderer.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a sales management device and a program for storing and managing customer information and sales results for each customer who has a history of commercial transactions in a store.

[0002]

2. Description of the Related Art In recent years, an electronic shop that performs bidirectional communication via the Internet between an online shop (virtual store) that sells various products via the Internet and a user terminal on the customer side that makes a purchase application for the products In a commercial transaction, a desired product can be freely purchased from a user terminal such as home at any time, and payment for the purchased product can be automatically deducted from a bank account. Services for supporting online sales, such as shopping malls equivalent to towns, are becoming increasingly popular. By the way, a personal computer (PC) installed in a store stores and manages the product information for each sale target product that is traded in the store, and also stores and manages the sales information and the customer information, and the order entered by the key is entered. A sales management system (business application) is built to perform sales management such as updating sales information and customer information based on contents and issuing various slips based on the sales information and customer information. In order to allow the existing sales management system to manage sales of the online shop as well, order information from the online shop and input the order information for online sales according to the normal key operation procedure. I was doing.

[0003]

However, for an operator who is accustomed to the work of inputting normal order contents in a physical store, it is not efficient to input the special net order information because the input is inefficient. There was also a problem that it was easy to induce mistakes. Therefore, it suffices to let the existing sales management system also manage the sales of the online shop, but for that purpose, the business application that is the existing sales management system can be changed drastically or a new system can be individually set. Since it needs to be built, the system development cost becomes enormous, and there remains a problem that the burden is too heavy for a small private store.

An object of the first invention is to receive and process order contents and customer information on the side of an online shop.
An object of the present invention is to provide a sales management device capable of linking an order received from an online shop to an existing sales management system and handling the same as customer-based management on the actual shop side. A second object of the present invention is to receive and process the order contents, customer information, and addressee information on the side of the online shop so that the order of the online shop accompanied by the delivery request of the goods can be linked to the existing sales management system. It is possible,
It is to be able to provide a sales management device that can be handled in the same manner as the management by customer / destination at the actual store side.

The means of the present invention are as follows. The invention according to claim 1 (the first invention) is provided with a customer storage means for a real shop that stores and manages customer information for each customer who has a history of commercial transactions in the real shop, and refers to this customer storage means. A sales management device for managing customers by means of receiving means for receiving the customer information together with the order contents of the online sales for which the product order has been made on the side of the online shop conducting electronic commerce through the network, and the receiving means. Determining means for determining whether the customer information is registered in the customer storage means, and if the determining means determines that the customer information has been registered, it is for each customer stored and managed corresponding to the customer. When it is determined by the update unit that the sales result is updated based on the contents of the order for the online sale and the registration unit is unregistered, the received customer information The system further comprises registration means for additionally registering to the customer storage means and additionally registering the order contents of the online sales as a sales record for each customer corresponding to the customer.

Therefore, according to the first aspect of the present invention, when the order contents and the customer information on the side of the online shop are received and the customer information is already registered in the customer storage means, the sales result corresponding to the customer is sold online. Although it is updated based on the order details, if the customer information is not registered, the customer information is additionally registered in the customer storage means, and the order details for online sales are additionally registered as sales results corresponding to the customer. Can be linked to the sales management system without changing the existing sales management system, without the burden of manually entering order details and customer information for online sales, without posting errors, etc. It is possible to securely process the orders of the above, and it is possible to handle the customers who use the online sales in the same manner as the customers of the actual store. As a result, online sales can be reflected in daily operations, and the results of online sales can be taken into consideration when customer service and sales promotion are performed according to the sales results of each customer.

Further, the computer is provided with a program for realizing the main functions shown in the above-mentioned invention of claim 1 (invention of claim 9).

The first invention may be as follows. In addition to the customer storage means for the actual shop, there is provided a customer storage means for the net shop that stores and manages information about the customer corresponding to the customer who uses the net shop (the invention according to claim 2). Therefore, claim 2
According to the described invention, in addition to having the same effect as that of the invention described in claim 1, the customer storage means for the actual store stores and manages the mixed customers of the online shop and the actual customer. Even so, the usage status of the online shop can be managed separately.

In this case, it is determined whether the customer information received by the receiving means is a customer who has used the net shop in the past by referring to the customer storage means for the net shop, and the customer using the net shop If so, by updating the sales record for each customer for the online shop (the invention according to claim 3), it becomes possible to carry out customer service and sales promotion according to the usage record of online sales.

When the customer information received by the receiving means is registered in the customer storage means, the customer information corresponding to the customer registered in the customer storage means under a certain condition is received by the customer. Correcting means for correcting based on the information is provided (the invention according to claim 4). Therefore, according to the invention described in claim 4, in addition to having the same effect as the invention described in claim 1, the corresponding customer information in the customer storage means is corrected based on the customer information from the net shop side. Therefore, if the address, telephone number, etc. are changed, it is possible to correct the contents of the customer storage means based on the latest information without requiring the customer to be notified of the change. Is unnecessary, and important information such as customer information will not be erroneously corrected due to an input error or the like.

In this case, after the customer information received by the receiving means and the customer information stored and managed in the customer storage means corresponding to the customer are displayed and output, a request for modification is received. If the correction means corrects the customer information registered in the customer storage means on the basis of the received customer information (invention of claim 5), the operator can obtain both customer information. When it is found that there is a difference between the two and it is determined that the correction is necessary, the correction process is executed, so that it is possible to improve the safety as compared with the complete automation.

[0012] A sales management device for executing various kinds of slip processing based on order information input by a commercial transaction in an actual store, wherein a slip record is created based on the order information for online sales received by the receiving means. , And requests execution of the various kinds of slip processing based on this slip record (the invention according to claim 8). Therefore, according to the invention described in claim 8, in addition to the effect similar to that of the invention described in claim 1, it is possible to execute the existing slip processing based on the order information of the online sales. A delivery note, a transfer request form, etc. can be obtained in response to an order.

The invention according to claim 6 (second invention) is
Corresponding to each customer who has a history of commercial transactions in the physical store, when the customer makes a delivery request to a third party for the purchased product, the destination information storage means for the physical store that stores and manages the customer information and the destination information. A sales management device for managing by customer / destination by referring to the destination storage means, and the customer together with the order contents of the online sale in which the product order is placed on the side of the online shop that conducts electronic commerce through the network. Receiving means for receiving information and delivery destination information, discriminating means for discriminating whether or not the customer information and delivery destination information received by the receiving means are registered in the delivery destination storage means, and discriminating that they have been registered by this discriminating means. In case of the above, the sales record by customer / destination stored and managed in correspondence with the customer and the destination is updated based on the contents of the order for the online sales. If it is determined by the update means and the determination means that the registration is not registered, the received customer information and delivery destination information are additionally registered in the delivery destination storage means, and the order contents of the online sale are added to the customer. ,
It is provided with a registration means for additionally registering sales results by customer / destination corresponding to the destination.

Therefore, according to the second aspect of the present invention, the contents of the order for the online sale, the customer information and the delivery destination information are received, and if the customer information and the delivery destination information are already registered in the delivery destination storing means, the customer and the delivery destination are supported. The sales results are updated based on the online sales order contents.If the customer information and destination information are not registered, the customer information and destination information are additionally registered in the destination storage means, and the online sales order contents are updated. Since it is additionally registered as sales results for customers and destinations, it can be linked to the sales management system without changing the existing sales management system,
Without the burden of manually inputting order contents, customer information, and destination information for online sales, without posting errors, etc., it becomes possible to reliably process the orders on the side of the online shop accompanied by the delivery request of the product, It can be handled in the same way as the management by customer / destination on the physical store side. As a result, online sales can be reflected in daily operations, and the results of online sales can be taken into consideration when implementing customer service and sales promotion in accordance with sales results by customer and destination.

Further, a program for causing the computer to realize the main functions shown in the above-mentioned invention of claim 6 is provided (the invention of claim 10).

The second invention may be as follows. In addition to the delivery destination storage means for the actual shop, a delivery destination storage means for the online shop that stores and manages customer information and delivery destination information for each use of the online shop is provided (the invention according to claim 7). Therefore, according to the invention described in claim 7, in addition to the same effect as the invention described in claim 6, the customer information at the time of using the online shop, the destination information and the actual store use are stored in the destination storage means for the actual store. Even if the customer information and the addressee information at the time are mixed and stored and managed, the delivery management using the online shop can be individually performed as necessary.

A sales management device for executing various kinds of voucher processing based on order information input by a commercial transaction in an actual store, wherein a voucher record is created based on the order information for online sales received by the receiving means. , And requests execution of the various kinds of slip processing based on this slip record (the invention according to claim 8). Therefore, according to the invention described in claim 8, in addition to the effect similar to that of the invention described in claim 1, it is possible to execute the existing slip processing based on the order information of the online sales. It is possible to obtain a delivery slip and the like in addition to the delivery note and the transfer request sheet according to the order.

[0018]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to FIGS. FIG. 1 is a block diagram showing the overall configuration of a sales management network system in this embodiment. This sales management network system (wide area communication system) has a shopping mall site 1 as a core, and is installed in this shopping mall site 1 in an actual store (actual store) which is a member user (net store) of the member. A system environment in which a store terminal 2 is connected via a network (Internet) 3 and a user terminal (product purchaser terminal) 4 who is a general customer of a shopping mall is connected via a network 3. Has become. The shopping mall site 1 is a computer system for operating and managing a virtual shopping mall (shopping mall), which is a collection of online shops (virtual stores).

The store terminal 2 is a product guide page with contents arbitrarily selected from the sale target product group for which online sale target products for sale on the shopping mall site 1 (net shop sales products) are commercially traded at actual stores. (HTML W
eb page) and create shopping mall site 1
It is designed to update sales information, customer information, etc. on the actual store side based on the order information for online sales that has been uploaded to the shopping mall site 1 or ordered on the shopping mall site 1 side. It is a sales management device capable of easily linking an online shop construction and an online sales management with an existing sales management system without changing.

In this embodiment, for example,
Digitized (packetized) data is transmitted and received between the shopping mall site 1 and the store terminal 2 and the product purchaser terminal 4 by the HTTP protocol or the like using the TCP / IP communication protocol. , The data including the coded control information are used to recognize the necessary processing contents and cooperate with each other to perform the data processing. The shopping mall site 1 has a database server function, a Web server function, a mail server function, and the like, and the store terminal 2 and the product purchaser terminal 4 have a Web browser function.

FIG. 2 is a block diagram for explaining the basic system outline of the store terminal 2. The store terminal 2 is a personal computer (store P) installed in the store.
C), the store terminal 2 stores and manages the product information for each sale target product that is traded in the store.
An existing sales management system 21 is constructed that stores and manages sales information, customer information, and the like, and performs various sales management based on key-entered order information (slip data). In other words, the sales management system 21 uses various master files,
It is a normal business application that operates and manages files for slip processing and performs a series of business such as ordering work, payment management, billing work, shipping work, etc., inputting sales data, issuing slips, managing data, utilizing data, etc. It has general processing functions for sales management. On this sales management system 21 side,
As its basic data files, a plurality of product MT (master) files F1 for each product genre described later, a slip detail / slip total file F2, a customer master file F
3. A delivery destination master file F4 is provided. The master file is a concept of a transaction file, but in this embodiment, it is simply a basic file and may be used in a transactional manner (for example, customer master file F3). , And the delivery destination master file F4) are referred to as a master file (the same applies hereinafter).

In addition to the existing sales management system 21 described above, the store terminal 2 is additionally configured with a net shop construction / operation system 22 specific to this embodiment. This online shop construction / operation system 22 is for building an online shop and managing online sales.
The shop terminal 2 provided with this system 22 also functions as a "PC for online shop shopkeepers". The online shop construction / operation system 22 is roughly divided into an online shop construction AP (application) 22a and an online sales input AP 22b, and cooperates with the existing sales management system 21. The cooperation with the sales management system 21 includes “merchandise master cooperation” and “order transaction cooperation”.

The “merchandise master linkage” means that information on each merchandise for online shop display is generated by referring to the merchandise master file F1 on the sales management system 21 side and uploaded to the shopping mall site 1.
The consistency between the product on the online shop side and the product in the product master file F1 is maintained. “Order transaction linkage” means performing various business processes by acquiring order information (order transaction) on the side of the online shop and inputting it as order information to the sales management system 21. Order business, payment management , A billing business, a customer management, a shipping business, and the like are processed in accordance with order information for online sales.

When a new online shop is constructed, the operator activates the online shop construction AP 22a to arbitrarily define the structure of the product guide page, and the product information to be posted in the product guide page and its arrangement. The state can be set arbitrarily, and the structure of this product information page (HT
ML) and various file groups F that store product information (including product images) to be posted on the product guide page are uploaded to the shopping mall site 1 to build desired online shop construction information in the store-specific storage area E. I am trying to do it. Here, build an online shop A
P22a is roughly divided into an online shop definition module M1, an online product registration module M2, and an online product display module M3. The online shop definition module M1 is a module for arbitrarily defining the structure of the online shop, that is, the configuration such as the page design for each of the plurality of product guide pages.

The online commodity registration module M2 arbitrarily selects and designates a commodity which is a target candidate to be put up as an online sale from various commodities stored in the commodity master file F1 on the sales management system 21 side. And a module for registering information about the product in the linked product master file F5. The linked product master file F5 is a product master file for online sales that stores and manages a product group that is a candidate for online sales. The online product display module M3 is a linked product master file F.
Any product can be selected as a target product for online sales from the exhibition candidate group registered in 5, and the display state for arranging the information on the selected product in the product guide page is arbitrary. It is a configurable module.

The net sales input AP 22b constituting the net shop construction / operation system 22 has a net order information acquisition module M5 and a net order input module M6. The online order information acquisition module M5
This is a module for receiving and acquiring the order information for online sales read from the order information file OF corresponding to the own online shop for which an order for goods has been placed on the side of the shopping mall site 1 and storing it in the linked sales detail file F6. . The order information for online sales includes information about ordered products, information about the orderer, and information about the delivery destination (destination), which are collectively referred to as order information.

The linked sales statement file F6 temporarily stores and holds the contents of the order information file OF on the shopping mall site 1 side, and the online order input module M6.
Reads the contents of the linked sales detail file F6 (order information for online sales) in units of slips and stores it in the slip details / slip totals file F2, or extracts information about the orderer to the customer master file F3. Module for performing processing such as storing and updating the sales results for each customer, extracting information about the delivery destinations, storing them in the delivery destination master file F4, and updating the sales results for each customer / delivery destination Is.

FIG. 3 shows a net shop definition module M1, a net product registration module M2, and a net product display module M3 which constitute the net shop construction AP 22a.
4 is a diagram for explaining the operation concept of FIG. When the online shop definition module M1 is activated, the store terminal 2
The structure of the online shop such as the number of pages and the page type for each page, the maximum number of products to be posted, etc. are defined and stored in the shop structure definition file F11, or the design (background image, button) is specified for each page. Etc., and the layout thereof) are defined and stored in the HTML file F12. The HTML file F12 is a file created in the hypertext markup language, and is composed of a plurality of pages corresponding to the number of pages in the shop structure definition. Note that FIG. 32B shows a shop structure definition screen for inputting and setting the data stored in the shop structure definition file F11, the details of which will be described later.

When the online merchandise registration module M2 is activated, the store terminal 2 displays a list of a plurality of merchandise master files F1 associated with merchandise genres provided on the sales management system 21 side, and this master is displayed. Product master file F1 of the desired product category from the list
Is arbitrarily selected and designated, the contents of the selected product master file F1 are displayed in a list. When an arbitrary product is selected and designated from the product list, information about the product is stored in the linked product master file F5. register. That is, when the selected product master file F1 is used as a source and a product that is a candidate for online sale is arbitrarily selected from various products in the product master file F1, the selected product information is included in the selected product information. The information necessary for online sales is retrieved and registered in the linked product master file F5, and the unique information input for online sales is registered in the linked product master file F5.

In this case, the product master file F1 and the linked product master file F5 are associated with each other by a product code or the like. Further, even if a product that is not registered in the product master file F1, that is, a new product that is not handled in an actual store, can be registered in the linked product master file F5 as a candidate for online sales, When it is registered, it is additionally registered in the product master file F1 to maintain the consistency between the product master file F1 and the linked product master file F5.

As a means for maintaining the consistency between the product master file F1 and the linked product master file F5, when the contents of the product master file F1 are modified,
It is determined whether or not the product designated as the correction target is the product transmitted to the shopping mall site 1 side (product being sold online), and if the product is being sold online, a correction warning message is displayed. ing. in this case,
The contents of the linked product master file F5 corresponding to the product are updated in synchronization with the update of the product master file F1 on condition that the instruction to execute the correction is received. Further, even when the content of the product master file F1 is deleted, if the product designated as the deletion target is a product that is being sold online, it is prohibited to delete the content of the product master file F1 corresponding to the product. I'm trying to display a message.

FIG. 4A shows the record structure of the product master file F1. Each product record has a "product code", a "product name", a "product category", a "JAN code", and a "sales". It has various items such as "price". Figure 4
(B) shows the record structure of the linked product master file F5, and each net product record has a "product code", a "product name", ..., "Sales price", "image number", "product". It has various items such as “description” and “delivery fee”. "Product code", "Product name", ...
The “sale price” is the information acquired from the product master file F1, but the “image number”, “product description”, “delivery charge”, etc. are information unique to the online product that does not exist in the product master file F1. Is. In addition, the linked product master file F5 includes the product master file F linked with it.
The name of 1 is added as the “source master name”.

In accordance with the online product registration module M2, the shop terminal 2 activates the image selection module M21 to display a list of the contents of the image candidate file F7. The image candidate file F7 is a file that stores and manages the product images captured in advance for each of various products in the one product file format in association with the image numbers. When an arbitrary product image is selected and specified from the image list, the store terminal 2 stores the selected image number in the linked product master file F5 as information about the product.

When the online product display module M3 is activated, the store terminal 2 displays a list of the contents of the shop structure definition file F11. Note that FIG. 37 shows an online product display <displaying the contents of the shop structure definition file F11.
Page list> screen is shown as an example, and details thereof will be described later. Then, when an arbitrary page is selected from the page list, the shop terminal 2 accesses the product display definition file F31 and displays the definition content corresponding to the selected page (initially undefined). FIG. 5 is a diagram showing the structure of the product display definition file F31, which defines products to be arranged in the page corresponding to a plurality of pages and the arrangement order thereof, and the definition content corresponding to each page is “page “Number”, “product code (1)”, “product code (2)”, ... Further, FIG. 38 shows an example of the display product registration screen corresponding to the selection page, the details of which will be described later.

In accordance with the online product display module M3, the store terminal 2 accesses the linked product master file F5 to display the product list screen. Note that FIG.
Shows an example of the product list screen of the linked product master file F5, the details of which will be described later. When an arbitrary product is selected for online display from this product list, the product code is assigned to the product display definition file F.
Placed within 31 selected pages. In addition, when an operation (arrangement operation) of arbitrarily changing the order of the display arrangement is performed after performing an operation of arbitrarily selecting the products to be displayed on the net (assortment operation), the online product display module M3.
According to the store terminal 2, the product display definition file F3
An editing process of rearranging the contents of one selected page in the designated order is performed. And the online product display module M3
Activates the page generation module M31.

According to the page generation module M31, the store terminal 2 refers to the contents of the linked product master file F5, the image candidate file F7, and the product display definition file F31 to refer to the net image file F32, the net product master file F33, and the HTML file. Create F12 for each page. That is, the contents of the product display definition file F31 are analyzed page by page, the product information read from the linked product master file F5 is set in the online product master file F33 according to the definition contents, and the image corresponding to the product is displayed. It is read from the image candidate file F7 and set in the net image file F32, and further, the shop structure definition file F11 and the product display definition file F
The contents of 31 are set in the HTML file F12 page by page. In FIG. 4C, the product information (net product record) read from the linked product master file F5 is the net product master file F33.
It is shown that it is set as it is.

FIG. 6 is a diagram showing how various kinds of information obtained by constructing the online shop are uploaded to the shopping mall site 1 side. That is, the upload module M4 is a module for associating the net image file F32, the net product master file F33, and the HTML file F12 generated by the page generation module M31 with each other and uploading them to the shopping mall site 1. In this case, the shopping mall site 1 sets the online shop construction information transmitted from each store terminal 2 in the store-specific storage area E.
The shopping mall site 1 is provided with an order information file OF and a store management table T described later.

FIG. 7 is a diagram showing the contents of the store area E for storing and managing the online shop construction information for each store on the side of the shopping mall site 1. This store-based storage area E corresponds to the identification information (store number) for each net shop, and includes an HTML file F12, a net product master file F33, and a net image file F.
32 is configured to be stored and managed. The shopping mall site 1 reads the contents of the store-specific storage area E corresponding to the online shop accessed from the product purchaser terminal 4, creates a product guide page for the customer, and sends it to the requesting product purchaser terminal 4 To do.

FIG. 8A shows the contents of the store management table T provided on the side of the shopping mall site 1, which corresponds to the "store number" and is used to call the store terminal 2 "shop store PC". “Access information” is stored and managed. That is, in correspondence with the "store number" for identifying the store terminal (shop-opener PC) 2 that is a member of the shopping mall, as the "access information of the shop-opener PC", the telephone number of the store terminal 2, etc. The shopping mall site 1 stores the order record in the order information file OF for the store to the store terminal 2 when transmitting the order record to the store terminal 2.
The "access information of the shop branch PC" is read from.

FIG. 8B is a diagram showing the record structure of the order information file OF, and the order record includes "commodity code", "commodity name", "quantity", "price", "total price", It includes items such as "orderer's name", "address", "telephone number", "email address", "member ID", "delivery name", "delivery address", "delivery telephone number", and the like. "Product code", "Product name", "Quantity", "Price", and "Total price" indicate information related to product order,
"Orderer name", "Address", "Telephone number", "Email address", "Member ID" are purchasers (customers) of online sales
Information about "Delivery Name", "Delivery Address",
The “destination telephone number” indicates information about the destination when the ordered product is requested to be delivered to a third party. Here, each time the shopping mall site 1 receives an order from the product purchaser terminal 4, the shopping mall site 1 inquires of the purchaser about the order details, and stores the order record created thereby in the order information file OF. There is.

FIG. 9 is a diagram showing a list of various files provided on the sales management system 21 side and various files provided on the net shop construction / operation system 22 side. The slip details / slip total file F2 is
This is a file for storing and managing a slip detail record including items similar to the items of the record of the order information file OF (see FIG. 8B) and a slip total record summed up for each order. Here, in accordance with the online sales input AP 22b, the store terminal 2 reads 1 from the linked sales detail file F6.
Order information for online sales is acquired for each slip and stored in the slip details / slip total file F2. Thereafter, according to the sales management system 21, the store terminal 2 creates and prints out a delivery note, a transfer request form, a home delivery slip, an order detail daily report, etc. based on the contents of the slip detail / slip total file F2, and a slip issuance process And various slip management processes.

FIG. 9 shows the net shop construction AP2 in the net shop construction / operation system 22.
It is shown that the linked product master file F5, the image candidate file F7, the shop structure definition file F11, the product display definition file F31, and the HTML file F12 described above are provided on the side 2a, and are uploaded to the shopping mall site 1. As various files, online product master file F33, online image file F
32, the HTML file F12 is provided. Furthermore, on the net sales input AP 22b side,
In addition to the linked sales statement file F6 described above, a linked customer master file F8 and linked destination master file F9 are provided.

FIG. 10A shows the customer master file F.
3 and (B) are diagrams showing the record structure of the linked customer master file F8. Customer master file F3
Is the "customer code", "customer name",
It stores and manages customer records that have items such as "address", "phone number", "cumulative amount of sales", and "customer rank". The “customer rank” indicates the rank classified according to the sales record.

Here, according to the online sales input AP 22b, the store terminal 2 reads 1 from the linked sales detail file F6.
Order information for online sales is acquired for each slip, and it is determined whether the customer information is already registered in the customer master file F3. If it is already registered, the customer master file F3
Only the corresponding “cumulative sales amount” in the above is updated, but if it is not registered, the information regarding the customer is extracted from the order information for online sales acquired from the linked sales detail file F6, and the customer master file F3 is extracted. And the corresponding “cumulative sales amount” in the customer master file F3 is updated.

The linked customer master file F8 is a network for storing and managing a linked customer record having items of "customer code", "mail address", and "cumulative sales points" for each customer who has used online sales. It is a customer master for sale. According to the online sales input AP 22b, the store terminal 2 extracts information about the customer from the online sales order information acquired from the linked sales statement file F6 and registers it in the linked customer master file F8 under a certain condition. The relevant "sales accumulated points" are updated.

FIG. 11A shows a delivery destination master file F.
4 and (B) are diagrams showing the record structure of the linked delivery destination master file F9. Delivery master file F4
Stores and manages a destination record having items of "customer code", "delivery address code", "delivery name", "delivery address", "delivery telephone number", and "cumulative delivery amount". The “cumulative amount” is, for example, the sales record up to the present time that the company A sent to the company B when the company A, which is a customer, requests the company B, which is the delivery destination, to deliver the product.

Here, according to the online sales input AP 22b, the store terminal 2 reads 1 from the linked sales detail file F6.
Order information for online sales is acquired for each slip, and it is determined whether the customer code and the delivery address code extracted from them are registered in the delivery destination master file F4. If registered, the delivery destination master file F4 is determined. Only the relevant “cumulative sales amount” in is updated, but if it is not registered,
The customer code and information about the delivery destination are extracted from the online sales order information acquired from the linked sales detail file F6 and registered in the delivery destination master file F4.
I am trying to update.

The linked destination master file F9 is a "customer code" corresponding to a customer or a destination when a customer who uses online sales requests that the ordered product be delivered to a third party. ], “Destination code”, “Delivery name” is a delivery destination master for online sales. Store terminal 2 according to online sales input AP22b
Is configured to extract information about a delivery destination from the online sales order information acquired from the linked sales detail file F6 and register it in the linked delivery destination master file F9 under certain conditions.

FIG. 12 is a block diagram showing the basic components of the store terminal 2. The CPU 201 is a central processing unit that controls the overall operation of the store terminal 2 according to the operating system and various application software in the storage device 202. The storage device 202 is
In addition to the operating system and various application software, the above-mentioned various files and the like are stored, and have magnetic, optical, semiconductor memory and the like and a drive system thereof. The recording device 202 is not limited to a fixed memory such as a hard disk, and may have a configuration in which a removable storage medium such as a CD-RO or a DVD can be mounted. The programs and data in the storage device 202 are stored in the RAM as necessary.
(For example, static RAM) 203 is loaded, or the data in RAM 23 is saved in the storage device.
Further, the CPU 201 can directly access and use programs / data of other electronic devices via the communication device 24, or can download and receive from other electronic devices via the communication device 204. On the other hand, a communication device 204, an input device 205, a display device 206, and a printing device 207, which are its input / output peripheral devices, are connected to the CPU 201 via a bus line, and the CPU 201 controls their operations according to an input / output program. To do.

Next, the operation algorithm of the sales management network system in this embodiment will be described with reference to FIGS.
This will be described with reference to the flowchart shown in FIG. Here, each function described in these flowcharts is stored in the form of a readable program code,
The operation according to this program code is sequentially executed. Further, the operation according to the above program code transmitted via the transmission medium can be sequentially executed. That is, the operation peculiar to this embodiment can be executed by utilizing the program / data externally supplied via the transmission medium in addition to the recording medium.

FIGS. 13 to 24 show the construction of an online shop.
Net shop construction AP2 that constitutes the operation system 22
It is a flow chart which showed operation of store terminal 2 according to starting of 2a. Note that among FIGS. 13 to 24, FIG.
FIG. 17 is a series of flowcharts showing the operation in the case of newly constructing an online shop, and FIGS. 18 to 24 show the operation in the case of changing the shop contents after the new construction of the online shop. FIG. 18 and FIG. 19 are changes of the linked product master, FIGS. 20 and 21 are changes of display definition (change of products being sold online), and FIGS. 22 to 24 are product masters. 9 is a flowchart showing an operation according to the change of the file F1. 25 and 26 are flowcharts showing the operation on the shopping mall site 1 side in response to the access from the product purchaser terminal 4. 27 to 29 are flowcharts showing the operation of the store terminal 2 in response to the online sales input AP 22b that constitutes the online shop construction / operation system 22. 30 and 31 are
6 is a flowchart showing the operation of the store terminal 2 according to the sales management system 21.

First, with reference to FIGS. 13 to 17, the operation of newly constructing an online shop will be described. In this case, when the activation of the online shop construction AP 22a is designated, the CPU 201 displays and outputs the top page screen (step A1). On this top page screen,
It has menu items of "1: Create new net shop" and "Change net shop". When any one of the menu items is selected (step A2), the selection item is determined (step A3).

Now, when the menu item "1: Create new net shop" is selected, the net shop definition module M1 is activated and a work procedure screen showing a series of work procedures is displayed and output (step A4). ). Figure 32
(A) shows this work procedure screen. In this work procedure screen, "1: shop structure definition", "2: online product registration", "3: online product display", "4: site upload" A list of work procedures and a "Start" button are located. In addition, the following process
It is sequentially executed according to this work procedure.

When the operator confirms the contents of the work procedure screen and then operates the "start" button (step A5), the shop structure definition screen is displayed (step A6). FIG. 32 (B) shows this shop structure definition screen. In this shop structure definition screen, "page type", "selection", "page title",
It has a definition item of "maximum number of products". In this "Page type" item, the "cover", "shop introduction", "product list (1)",
"Product list (2)", etc. are displayed in fixed order in advance, and by entering a "check" in the item position of "selection" corresponding to "page type", the "page type" is displayed. Is selected and specified. "Maximum number of products"
Indicates the maximum number of products to be placed in the selection page.

In this shop structure definition screen,
After "Check" is entered in the "Select" item position and the required page is arbitrarily selected (step A7), the "page title" and "maximum number of products" are input and set corresponding to the selected page (step A7). A8), the contents of the shop structure definition screen are stored in the shop structure definition file F11 (step A9). After that, for each page selected as described above, the page design (background image, title image, page constituent elements such as buttons and their layout) is set and input (step A10), and the set page design is , Is stored in the HTML file F12 corresponding to each page (step A11).

In this way, in addition to arbitrarily setting the shop structure composed of a plurality of pages by arbitrarily selecting and designating the prepared page types, the work of arbitrarily setting the basic configuration contents of each page is performed. When the HTML file F12 is generated by the execution, the online product registration module M2 is activated. Then, the process proceeds to step A12 in FIG. 14, and various product master files F1 prepared for each product genre are accessed and the master list menu is displayed and output. When an arbitrary product master is selected and designated from this master list menu (step A1
3), the name of the selection master is the linked product master file F5
After performing the process of storing as the source file name of (step A14), the new net product registration screen is displayed (step A15).

FIG. 33 shows a base screen for registering this new online product. This new online product registration screen is
It is a registration screen for registering the data entered in the screen as an exhibition candidate in the linked product master file F5. "Product code", "Product name" in this registration base screen,
Items such as "Product name 2", "Tax-excluded tax classification", ... This is the item data to be processed. In addition to the above-mentioned “product code” and “product name”, each item of “sales price”, “product description”, “remark 1” ...
The item data is registered in the linked product master file F5.

Further, the registration base screen is provided with an image display area to which a product image is pasted and various function buttons are arranged. Among the function buttons, the button of “processing category” (upper right in the figure) selectively designates the processing of “add”, “correction”, and “delete” when changing the contents of the linked product master file F5. It is a thing. Various buttons arranged in the button menu provided at the bottom of the screen are omitted from the drawing.

In the state where such a new net product registration screen is displayed, the next step A16 decides whether the reading is from the selected master. That is, whether information is read from the product master file F1 selected in step A13 and registered in the linked product master file F5, or a product not stored in the selection master is registered in the linked product master file F5. Is determined. When it is specified that the information is read from the selection master and registered in the linked product master file F5, the source file name stored in step A14 is acquired and the product master specified by this source file name is acquired. The file F1 is accessed to display and output the product list screen (step A17).

FIG. 34 is a view showing a product list screen of the selection master (product master file F1). This product list screen displays the "product name" for each product, corresponding to the serial number.
A list of "Product Codes" is displayed. If you select and specify a product that is a candidate for online selling from among them, (Step A
18), product information corresponding to the selected product is read from the product master file F1, data of necessary items (product code, product name, price) are extracted from the product information, and new net product registration in FIG. 33 is performed. A copy is displayed at the corresponding item position on the screen (step A19).

On the other hand, when a product not stored in the selection master is registered in the linked product master file F5 (step A16), the data of the required items (product code, product) in the new online product registration screen of FIG. After manually inputting the name and price (step A20), a new product registration screen corresponding to the product master file F1 specified by the source file name is displayed and output (step A2).
1). Although not shown, the new product registration screen corresponding to the source master is a registration screen for registering each item of the product record that constitutes the product master file F1, and item data input in the above-mentioned new net product registration screen. Is read out and displayed as a copy at the corresponding item position in this registration screen (step A22). Then, the data of other necessary items are manually input in the registration screen corresponding to the source master (step A23). In this way, a product record is generated based on each item data input on the registration screen corresponding to the source master, and this product record is additionally registered in the product master file F1 designated by the source file name (step A24). Then, the new online product registration screen is displayed again (step A25).

Next, the online product registration module M2
The image selection module M21 is activated to display a list of the contents of the image candidate file F7 (step A2 in FIG. 15).
6). FIG. 35 shows this image list screen, and in this screen, a list of product images taken in advance corresponding to various products is displayed. When an arbitrary product image is selected and specified from this image list, the image number selected from the image candidate file F7 is acquired by the control of the image selection module M21 and sent to the online product registration module M2. The image number is stored in the linked product master file F5 as information about the product (step A27). Furthermore, the selected image is pasted in the image display area in the new online product registration screen of FIG. 33 (step A28).

In this state, if data of other necessary items (product description etc.) is input in the new net product registration screen, the input data is displayed at the corresponding item position in the registration screen (step A29). ). Here, when all the data of the necessary items have been input and the confirmation operation is performed (step A30), a product record is created based on the data in the new online product registration screen, and this created record is the linked product master file F5. Is registered (step A31). Then, in the next step A32, it is determined whether or not there is an instruction to end the registration process, and the process in FIG.
Returning to step A15, the above operation is repeated for each product unit (steps A15 to A32).

Here, when the instruction to end the registration is received (step A32), the online product registration module M2.
Activates the online product display module M3. Then, the process proceeds to step A33 of FIG. 16, and the store terminal 2 reads the contents of the shop structure definition file F11 according to the online product display module M3 and displays the online product display <page list> according to the contents of this structure definition ( Step A34). FIG. 37 shows this online product display <page list> screen. In this list screen, a series of “page number”, “page type”, and “selection” are set for each page that defines the shop structure. , “Page title”, and “Maximum number of products” are listed.

When an arbitrary page is selected and designated in this net product display <page list> screen (step A
35), the product display definition file F based on the selection page
The relevant page in 31 is accessed, and the display product registration screen corresponding to the selected page is displayed and output based on the definition content of the page (step A36), and the product list screen in the linked product master file F5 is also displayed and output. (Step A37). FIG. 38 shows a display product registration screen corresponding to this selection page. In the registration screen, the "page number" is displayed and various product information arranged in the selection page is displayed. It is displayed in the display order. That is, a "number" indicating the display order of each product,
"Product name" and "Product code" are displayed in a list, but when the online shop is newly constructed, the product display definition file F
Since no data is stored in 31, the registration screen does not display information about the product and remains blank.

FIG. 39 shows a product list screen of the linked product master file F5. This product list screen displays "product name" and "product code" for each product corresponding to the serial number. When any product is selected and designated as a display target (step A38), product information corresponding to the selected product is linked to the linked product master file F5.
Read out from and displayed on the display product registration screen corresponding to the selected page (step A39). Here, the product selected first is displayed at the head position (position indicated by the display number “1”) in the display product registration screen. When such display target selection operation is sequentially performed for each product, information regarding the product is sequentially arranged and displayed in the display product registration screen in the selected order.

As a result, when all the display target products have been selected (step A40), the display state change instruction set this time is accepted (step A41), and if there is a change instruction, the product arrangement in the display product registration screen is performed. Processing for changing the order in accordance with the changing operation is performed (step A4).
2). In this case, if you specify the product name to be changed and its placement position in the display product registration screen and perform a change operation to rearrange the specified product at the specified position, the contents of the display product registration screen will be as specified. Will be changed in the order of arrangement. When the end of change is instructed (step A43), each product code in the display product registration screen is read in that order and stored in the product display definition file F31 corresponding to the page (step A44). Then, it is checked whether all pages have been processed (step A45). If there is an unprocessed page, the next unprocessed page is selected, and then the step for displaying the online product display <page list> screen is performed. Returning to this, the above operation is repeated for all pages, and as a result, the product display definition file F31 shown in FIG. 5 is generated.

When the product display definition files F31 for all pages are generated in this way, the online product display module M3 activates the page generation module M31. Then, the process proceeds to step A46 in FIG. 17, and one page is designated from the top of each page of the product display definition file F31. Then, the "product code" is sequentially read from the product display definition file F31 corresponding to the specified page, and the linked product master file F is based on this "product code".
5 is accessed, and information about the product (net product record) is acquired from the linked product master file F5 and stored in the net product master file F33 (step A47).

Next, the image candidate file F7 is accessed based on the "image number" in the online product record obtained from the linked product master file F5, and the corresponding product image is read and stored in the net image file F32 (step A48). The storage processing of such online products and net images is performed for all products in the designated page (steps A47 to A49). When the storage process for one page is completed (step A49), the HTML file F12 is accessed based on the designated page and the HTML page corresponding to the designated page is read (step A5).
0) In this HTML page, an HTML page including the product display definition is created by pasting each product code in the order of the product display definition set in the corresponding page of the product display definition file F31. HT
A process of re-storing the data in the ML file F12 is performed (step A51).

In this way, the net product master file F33 and the net image file F3 corresponding to the designated page
2. When the process of generating the HTML file F12 is finished, it is checked whether the process of generating all pages defined in the product display definition file F31 is finished (step A52). Now, the process of generating the first page is performed. Since this is the case, the process returns to step A46 and, after the second page is designated, the net product master file F33, the net image file F32, and the HTML corresponding to the second page.
The process of generating the file F12 is executed (steps A47 to A51).

As a result, when the generation processing for all pages is completed (step A52), the page generation module M31
The upload module M4 is activated. Then, the net product master file F33, the net image file F32, and the HTML file F12 for all pages are uploaded to the shopping mall site 1 as the net shop construction information (step A53). The shopping mall site 1 sets the online shop construction information transmitted from the shop terminal 2 in the storage area E for each shop to build an online shop corresponding to the shop.

After the online shop is constructed in this way, when the menu item "Change Online Shop" in the top page screen is selected (see FIG. 13).
Steps A1 to A3) and the online shop changing process (FIGS. 18 to 24). First, when the menu item "Change Internet shop" is selected, the online product registration module M2 is activated. Then, the change menu screen is displayed and output (step A60 in FIG. 18). Figure 40
(A) shows this change menu screen, and on this menu screen, the menu items of "change linked product master", "change display definition", "change product master", and "end" are displayed. It

"Linked product master change" is a menu item for instructing a process to change the online product record stored as an exhibition candidate in the linked product master file F5. "Display definition change" is a product. "Change product master" is a menu item for instructing a process to change a product record stored as a product for online sale in the display definition file F31. "Product master change" is a product record stored in the product master file F1. This is a menu item for instructing the process of changing. "End" is an item for instructing the end of the change process. When an arbitrary menu item is selected from such a change menu screen (step A61), the selection item is discriminated (step A6).
2).

Now, when the menu item is selected to execute "change linked product master" (step A6)
1, A62), the linked product master file F5 has been accessed (step A63), and the selection of the change processing category is ready to be accepted (step A64). Here, when any section is selected and designated from among "addition", "correction" and "deletion" as the change processing section, the selected section is discriminated (step A65). Here, when adding a new product to the linked product master file F5, “add” is selected as the change processing category. Then, FIG.
While displaying the Internet product registration screen of (Step A
66), the product master file F1 designated by the source file name is accessed to display and output the product list screen of FIG. 34 (step A67).

When a product to be added as an online exhibition candidate is arbitrarily selected and designated from the product list screen (step A68), product information corresponding to the selected product is read from the product master file F1 and necessary items are selected from the product information. Data is extracted and displayed as a copy at the corresponding item position in the new net product registration screen (step A69). Next, the image selection module M21 is activated by the online product registration module M2. Then, the image candidate file F7
Is accessed, and the image list screen as shown in FIG. 35 is displayed (step A70). When the product image to be added is selected and designated from the image list screen, the selected image number is acquired (step A71), and the selected image is the image in the online product registration screen of FIG. It is attached to the display area (step A72).

Next, when data of other necessary items (product description etc.) is input in the online product registration screen, the input data is displayed at the corresponding item position in the registration screen (step A73). At this point, when all the data of the necessary items have been input and the confirmation operation is performed (step A7
4), a product record is created based on the data in the online product registration screen, and the created record is additionally registered in the linked product master file F5 (step A75). Then, in the next step A76, it is determined whether or not there is an addition end instruction, the process returns to step A66 until there is an end instruction, and the above operation is repeated.

When the product information in the linked product master file F5 is changed, "correction" is selected as the change processing category (step A77 in FIG. 19). Then,
The product list in the linked product master file F5 as shown in FIG. 39 is displayed (step A78). When the product to be modified is selected from the product list screen (step A79), the online product record corresponding to the product is read out and the content of the product record is displayed and output in the online product registration screen (step A80). . When a correction operation is performed on the item or product image in the online product registration screen corresponding to the selected product, the corresponding data in the registration screen is modified accordingly (step A81). And
When the data of the selected product is corrected (step A82),
The corresponding net product record in the linked product master file F5 is accessed based on the product, and the corresponding data in the net product record is updated based on the corrected data (step A83). And the next step A
At 84, it is determined whether or not there is an end instruction, the process returns to step A78 until there is an end instruction, and the above operation is repeated.

When "delete" is selected and designated as the change processing category (step A77 in FIG. 19), the product list in the linked product master file F5 is displayed (step A85). When a product to be deleted is selected from the product list screen (step A86), the product display definition file F31 is accessed based on the selected product to search for the “product code” of the product and to display the product The presence or absence is determined (steps A87, A88). That is, it is determined whether or not the product selected as the deletion target is a product being sold online. Here, if the “product code” of the product is stored in the product display definition file F31, the product selected for deletion is a product that is being sold online, so to notify the operator to that effect. A deletion warning message is displayed and output (step A89).

When a deletion execution request is received after displaying this warning message (step A9)
0), the corresponding product code in the product display definition file F31 is deleted to exclude the product from the target products for online sale (step A91), and the corresponding product record in the linked product master file F5 is deleted (step A91). Step A92). If the deletion is canceled after the warning message, steps A90 and A9 described above are executed.
The deletion process of 1 is not executed. And the next step A
At 93, it is determined whether or not there is a deletion end instruction, the process returns to step A85 until there is an end instruction, and the above operation is repeated. In addition, in the process of "addition", "correction", and "deletion" of the linked product master file F5 as described above, if the end is instructed (steps A76, A8).
4, A93), and returns to step A60 in FIG. 18, and the change menu screen is displayed again.

Next, the operation for changing the merchandise being sold online (changing the display definition) will be described with reference to FIGS. 20 and 21. In this case, when the menu item "display definition change" is selected and specified from the change menu screen shown in FIG. 40A, the online product display module M3 is activated. As a result, the process moves to step A100 of FIG. 20, the contents of the shop structure definition file F11 are read (step A101), and the online product display <page list> is displayed according to the contents of this structure definition (step A102). When a page to be changed is selected and specified in the online product display <page list> screen (step A103), the corresponding page in the product display definition file F31 is accessed based on the selected page and based on the definition content of the page. And a product registration screen (see FIG. 38) corresponding to the selection page is displayed and output (step A10).
4).

Then, the processing division selection is accepted (step A105), and the processing divisions "add", "move",
It is determined which of "delete", "other page" and "end" is selected (step A106). When adding a new product as a product currently being sold online, if "add" is selected as the processing category, the linked product master file F5 is read (step A107), and the product list screen (see FIG. 39). ) Is displayed and output (step A1)
08). When a product to be added is selected from this product list screen (step A109), information regarding the selected product is additionally inserted into the display product registration screen of FIG. 38 (step A110). Then, in the next step A111, it is determined whether or not there is an addition end instruction, the process returns to step A108 until there is an end instruction, and after the above operation is repeated,
In response to the end instruction, the product code added in the display product registration screen is additionally registered in the product display definition file F31 corresponding to the page (step A112). afterwards,
The process returns to step A105, and the process category can be selected.

Further, when changing the display order of the items for sale on the Internet, "move" is selected as the processing category (step A113 in FIG. 21). Here, when the order of the product names is changed, the contents of the display product registration screen are changed in the arrangement order as specified (step A114). Such a changing process is repeated until the end of movement is instructed. Here, when the movement end is instructed (step A11
5) Then, after updating the contents of the product display definition file F31 corresponding to the page in the order of the changed product name (step A116), the process category can be selected (step A105 in FIG. 20).

Further, in the case of excluding merchandise being sold online, "delete" is selected as the processing category (step A117 in FIG. 21). Then, when the product to be deleted is selected from the display product registration screen (step A11)
8) The corresponding product code in the product display definition file F31 is deleted, and the product is excluded from the products to be sold online (step A119). Such deletion processing is repeated until the end of deletion is instructed. here,
When the end of deletion is instructed (step A120), the process category can be selected (step A10 in FIG. 20).
5).

After the change processing for one page is performed in this manner, the above-mentioned display definition change processing for each page is performed until the end of "display definition change" is selected (step A121 in FIG. 21). 20 is executed, the process returns to step A102 of FIG. 20 to display the online product display screen, and then the selection of the next page to be changed is accepted. Hereinafter, the above-described change operation is repeated for each selected page for each page. Here, when the end of the “display definition change” is selected (step A121 in FIG. 21), the above-described FIG.
Each processing of No. 7 is sequentially executed.

That is, 1 in the product display definition file F31.
A page is designated (step A46), and the net product record of the corresponding product is acquired from the linked product master file F5 from the product display definition file F31 corresponding to the specified page and stored in the net product master file F33 (step A47). , A corresponding product image is read from the image candidate file F7 based on the “image number” in the online product record acquired from the linked product master file F5 and stored in the net image file F32 (step A
48). When the storage process for one page is completed, the HT that pasted each product code according to the order of the product display definition
An ML page is created and stored again in the HTML file F12 (step A51). After that, when the generation process for all pages is completed, the online product master file F3
3. Net image file F32, HTML file F1
2 is uploaded to the shopping mall site 1 (step A53).

Next, the operation of changing the contents of the product master file F1 will be described with reference to FIGS. From the change menu screen described above, "Product Master"
Item is selected (step A121 in FIG. 22),
The online product registration module M2 is activated. Then,
Various product master files F1 prepared for each product genre are accessed to display and output the master list menu (step A122). When an arbitrary product master is selected and specified from this master list menu (step A123), the selected product master file F1
Is accessed (step A124) and the selection of the processing category is ready to be accepted (step A1).
25). Here, "addition", "correction",
When an arbitrary section is selected and designated from "Delete", the selected section is discriminated (step A126).

Here, when adding a new product to the product master file F1, "add" is selected as the processing category. Then, the new product registration screen for the product master is displayed and output (step A127). In this state, after inputting the data of the necessary items in this new product registration screen (step A128) and performing the input confirmation operation (step A129), the product record is created based on the input data in the new product registration screen. The generated record is additionally registered as new product information in the product master file F1 (step A130). Then, the additional registration process of another new product is repeated until the end of the process is instructed (steps A127 to A131).

Further, in order to correct the product information registered in the product master file F1, "correction" is selected and designated as the processing category (step A13 in FIG. 23).
2) Display a list of products in the product master file F1 (step A133). When the product to be modified is selected from the product list screen (step A134),
The product display definition file F31 is accessed based on the selected product, the "product code" of the product is searched, and the presence or absence of the product is determined (steps A135 and A13).
6). That is, it is determined whether or not the product selected as the correction target is a product on sale online. Here, if the “product code” of the product is stored in the product display definition file F31, the product selected as the correction target is a product that is being sold online. A correction warning message is displayed and output (step A13).
7).

After displaying this warning message, a correction execution request is accepted (step A138),
If there is no execution request, the process proceeds to step A145 to cancel the correction processing of the selected product, but if the correction execution request is received or if the corresponding product code is not stored in the product display definition file F31 ( If the product is not on sale online, a product registration screen corresponding to the selected product is displayed and output (step A139). When the item to be corrected is designated and the correction operation is performed on the item data displayed in the item registration screen (step A140), the corresponding item in the item master file F1 is determined based on the item code. Search for records,
The content of the product record is updated based on the correction data (step A141).

Then, in order to update the contents of the linked product master file F5 in synchronization with the modification of the product master file F1, the linked product master file F5 is searched based on the product code, and whether there is a corresponding product code. Is determined (steps A142, A143), and if there is no corresponding code, the process proceeds to step A145. If there is a corresponding product code, the content of the net product record in the linked product master file F5 is updated based on the corrected data. (Step A144). In this case, if the product selected as the correction target is a product being sold online, a process of updating the content of the corresponding net product record in the net product master file F33 based on the correction data is also performed. Then, the process proceeds to step A145, it is determined whether or not the process end is instructed, and step A13 is performed until the end instruction is given.
Returning to step 3, the above operation is repeated.

Further, in order to delete the product information registered in the product master file F1, when "Delete" is selected and designated as the processing category (step A15 in FIG. 24).
0), a list of products in the product master file F1 is displayed (step A151). When the product to be deleted is selected from the product list screen (step A152),
The product display definition file F31 is accessed based on the selected product, the “product code” of the product is searched, and the presence or absence of the product is determined (steps A152 and A15).
3). Here, if the “product code” of the corresponding product is stored in the product display definition file F31, it means that the product selected as the target of deletion is a product that is being sold online, and the deletion of the product information is prohibited. The deletion prohibition message shown is displayed and output (step A159).

On the other hand, if the product selected as the deletion target is not a product being sold online (step A153), the corresponding record in the product master file F1 is searched based on the product code, and the product record is deleted ( Step A154). Then, in order to delete the corresponding product record of the linked product master file F5 in conjunction with the deletion of the product master file F1, the linked product master file F5 is searched based on the product code, and whether there is a corresponding product code. Is determined (steps A155, A15
6) If there is no corresponding code, the process proceeds to step A150. If there is a corresponding product code, the corresponding net product record in the linked product master file F5 is deleted (step A157). Then, the process proceeds to step A158, it is determined whether or not the processing end is instructed, the process returns to step A150 until the end instruction is given, and the above-described operation is repeated.

When the end of processing is instructed during the processing of “addition”, “correction” and “deletion” for the product master file F1 (steps A131, A14).
5, A158), the process returns to step A60 of FIG. 18, and the above-described change menu screen is displayed again. If the "End" menu item is selected in the change menu screen, that is detected in step A121 in FIG. 22, and the operation according to the online shop building AP 22a ends at this point.

Next, the operation when the product purchaser terminal 4 accesses the shopping mall site 1 will be described with reference to FIGS. 25 and 26. In response to the access from the product purchaser terminal 4, the shopping mall site 1 transmits the top page in which the information of each online shop is posted to the requesting terminal (step B1), and then the user selects the desired online shop. A request wait state is entered (step B2). Here, when the selection request is received from the product purchaser terminal 4, the HTML file F12 and the net image file F3 set corresponding to the online shop are set.
2. Referring to the online product master file F33, a process for creating a product guide page corresponding to the online shop is performed. Note that FIG. 36 shows a state where the product guide page is created. (A) shows the HTML file F1.
2, a specific example of the product guide page created based on the net image file F32 and the net product master file F33 is shown, (B) is a diagram showing the contents of one page constituting the HTML file F12.

First, the shopping mall site 1 accesses the HTML file F12 associated with the selected online shop, specifies the top HTML page (step B3), and specifies the specified HTML.
The online product master file F33 is accessed based on each product code set in the page, and the "image number" corresponding to each product code is acquired (step B
4). In this way, the online product master file F33
The net image file F32 is accessed based on each “image number” obtained from the above, the corresponding product image is read out (step B5), and the product image is pasted at the position corresponding to each product code in the designated HTML page ( Step B6).

Further, the online product master file F33 is accessed based on each product code set in the specified HTML page, and the "product name", "price", and "product description" are read from each product code ( Step B
7) In the designated HTML page, at the position corresponding to each product code, this "product name", "price", "product description"
A product information page with the contents pasted is created (step 8). As a result, in the product guide page, in addition to the "page title", each product image is arranged in a list, and the page contents in which "product name", "price", and "product description" are arranged below each image. The product guide page created in this way is transmitted to the product purchaser terminal 4 which is the request source (step B9).

After transmitting the product guide page, the shopping mall site 1 waits for a request from the product purchaser terminal 4 (step B10 in FIG. 26). Here, when the request from the product purchaser terminal 4 is accepted, it is determined whether the request is another page request (step B11) or a product selection request for purchasing the product (step B13). If another page request is accepted now (step B
11) After designating the requested page (step B1
2) Returning to step B4 in FIG. 25, the HTML page corresponding to the requested page is designated from the HTML file F12, and the product guide page is created based on this HTML page.

When the product to be purchased is selected (step B13), the online product master file F33 is accessed based on the product code of the selected product, and the "product name" and "price" are read from the product record. Is acquired, an order page in which the “product name” and the “price” are inserted is created and transmitted to the requesting product purchaser terminal 4 (step B1).
6). FIG. 40 (B) is a diagram showing this order page screen. In addition to the selected “Internet shop name”, “product name”, and “price” being displayed on this order page screen, As input items to enter, "quantity", "orderer name", "address", "phone number", "email address",
"Delivery name", "Delivery address", ... are provided.

On the side of the commodity purchaser terminal 4 that receives this order page, when the data of the required items are entered in the order page screen and sent back to the shopping mall site 1, the shopping mall site 1 While receiving the order data record from the terminal 4 (step B17), this order record is stored in the order information file O
It is stored in F (step B18). After that, the process waits for a request from the product purchaser terminal 4 (step B10).

Here, when the end request is received (step B13), the order information file OF is accessed to check the presence or absence of the order information. Is read for each online shop, and the corresponding store terminal (shop exhibitor PC)
2 (step B15). In this case, when the store terminal 2 receives the order information from the shopping mall site 1, it activates the online order information acquisition module M5 and stores the received order information in the linked sales statement file F6.

FIG. 27 is a flowchart showing the operation when the online sales input AP 22b is activated on the side of the store terminal 2 in response to a request from the operator. First, the store terminal 2 accesses the linked sales detail file F6, reads data for one record from the beginning (step C1), and performs customer registration processing based on the linked sales detail record (step C2). In this customer registration processing, a new customer (customer) through online sales is registered in the linked customer master file F8 for online sales, and is also registered in the customer master file F3 on the sales management system 21 side. This is done while maintaining the consistency between the customer master file F3 and the linked customer master file F8.

FIG. 28 is a flowchart detailing this customer registration processing. First, online sales input AP22
In accordance with b, the store terminal 2 uses the linked sales statement file F
The "mail address" is obtained from the record read from 6, and the contents of the record in the linked customer master file F8 are checked based on this "mail address", and the customer with the corresponding "mail address" It is checked whether it has been registered (step D1). In other words, by using the "email address", which is unique data for online sales, as a key, the interlocking customer master file F8 is searched to determine whether the same "email address" is registered. It is determined whether the customer has used it even once.

As a result, the linked customer master file F8
If the same "email address" is not registered in the record (step D2), since this is the first customer using net sales this time, "customer name" and "customer name" and "from the record read from the linked sales statement file F6""Telephonenumber" is acquired, and based on the "Customer name" and "Telephone number", the corresponding record contents in the customer master file F3 on the sales management system 21 side are checked, and the "Customer name" and "Telephone number" It is checked whether the customer having the "number" has been registered (step D3). That is, the customer master file F3 is searched using the "customer name" and "telephone number" that can identify the customer, and the same "customer name" and "telephone number" are searched.
By determining whether or not is registered, it is determined whether or not the customer (existing customer) has used the actual shop sales or online sales even once.

Here, if it is not registered (step D4), the customer is a new customer who has never used real shop sales or online sales, so that the process proceeds to step D5 and "new customer code" is generated. Then, the generated "customer code" and the "mail address" obtained from the linked sales detail record are additionally registered as a new record in the linked customer master file F8 (step D6), and the "customer code" is added. The relevant information (including the customer name, address, etc., as well as the mail address) obtained from the linked sales detail record is additionally registered as a new record in the customer master file F3 (step D7).

If the same "mail address" is already registered in the linked customer master file F8 (step D2), since the customer is an existing customer who has used online sales, the process moves to step D8. The corresponding "customer code" is read from the linked customer master file F8.
Then, based on this "customer code", the customer master file F3 on the sales management system 21 side is searched, and "address", "telephone number", and "mail address" are read out from this customer record, and are linked. The "address", "phone number", and "mail address" are read from the sales detail record, and these are associated and displayed for comparison (step D11).

That is, since the "address", "telephone number", and "email address" of the information regarding the customer are data that may be changed, the contents at the time of using the online sales this time and the contents already registered. The operator is asked whether or not it is necessary to correct and update the registered content by comparing and displaying and. Here, when the update request is received (step D12), the contents of the record in the customer master file F3 are corrected and updated based on the "address", "phone number", and "mail address" of the linked sales detail record. Processing is performed (step D13).

If the same "customer name" and "telephone number" are registered in the customer master file F3 (step D4), it is the existing customer, but online sales is used for the first time this time. Since this is the customer who made the request, step D9
Then, the "customer code" is read from the customer master file F3. Then, this "customer code" and the "mail address" of the linked sales detail record are additionally registered as a new record in the linked customer master file F8 (step D10). After that, the above-mentioned "address", "phone number", and "email address" are compared and displayed (step D11), and when an update request is received (step D)
12) The contents of the corresponding record in the customer master file F3 are corrected and updated (step D13).

When such customer registration processing is completed,
In step C3 of FIG. 27, the “total amount” is acquired from the linked sales detail record, and the customer master file F is acquired based on the “product code” of the linked sales detail record.
3 is accessed, and the "total amount of money" acquired from the linked sales detail record is added to the "cumulative amount of sales" in the corresponding record of the customer master file F3 and updated. Further, an update process is performed to add "1" to the "cumulative sales point" in the corresponding record of the linked customer master file F8 (step C4). After that, destination registration processing is performed (step C
5). In this destination registration process, when it is specified that the product purchased by the customer by online sales should be delivered to a third party, the destination information is registered in the linked online destination master file F9 for online sales. The registration processing for registering in the delivery destination master file F4 on the sales management system 21 side is performed, and the consistency between the delivery destination master file F4 and the linked delivery destination master file F9 is maintained.

FIG. 29 is a flowchart detailing this destination registration processing. In addition, this destination registration process,
Since it is basically the same as the customer registration processing shown in FIG. 27, the characteristic part of the destination registration processing will be mainly described below. First, while obtaining the "customer code" obtained in the steps of the customer registration processing described above ,, the "customer code" and the "destination name" obtained from the linked sales statement record are paired. Then, it is checked whether or not the "customer code" and the "destination name" are already registered in the linked destination master file F9 (steps E1 and E2).

If the "customer code" and the "destination name" are not registered in the linked destination master file F9 (step E2), the current destination specified by the existing customer is the online sales destination this time. Since this is the first time, the process moves to step E3, and it is checked whether this "customer code" and the "destination name" and "phone number" in the linked sales detail record are already registered in the destination master file F4 (step E3). , E4). Here, if the same “customer code”, “destination name”, and “phone number” have already been registered in the destination master file F4, a destination to which the existing customer has requested delivery of the product in the past ( This is a case where the delivery of the product is requested again to the existing delivery destination), but if it is not registered, it is a delivery request to a new delivery destination to which the delivery of the product has not been requested in the past.

If it is a new destination, a "new destination code" is generated (step E5). And
The "customer code", the "new delivery address code", and the "delivery destination name" obtained from the linked sales detail record are additionally registered as new records in the linked delivery destination master file F9 (step E6), and the "customer code" is also registered. ",
The "new delivery address code" and the corresponding information (customer name, customer address, etc.) obtained from the linked sales details are additionally registered as new records in the delivery destination master file F4 (step E7).

When an existing customer who has used online sales has once requested the delivery of a product to an existing destination, when the customer is requested to deliver the product again at the time of using the online sales this time (step E2). , The corresponding "destination code" is read from the linked delivery master file F9 (step E8). Then, the “address” and “phone number” in the destination master file F4 corresponding to the “customer code” and the “delivery code” are compared and displayed with the “address” and “phone number” in the linked sales statement record. After (Step E1
1) When an update request is received from the operator (step E12), "address" in the linked sales detail record,
The corresponding record in the delivery destination master file F4 is corrected and updated based on the "telephone number" (step E13).

On the other hand, if the same "customer code", "destination name", and "phone number" have already been registered in the destination master file F4 (step E4), the existing customer requests delivery of the product in the past. For existing destinations that have
Since this is the first delivery request by net sales, the process moves to step E9, and the corresponding "destination code" is read from the destination master file F4. Then, the "customer code" and the "delivery code" and the "delivery name" in the linked sales detail record are additionally registered as new records in the linked delivery master file F9 (step E1).
0). After that, the above-mentioned "address" and "phone number" are compared and displayed (step E11), and when an update request is received (step E12), the delivery destination master file F4.
Correct and update the contents of the corresponding record in (step E1
3).

When the destination registration process as described above is completed,
In step C6 of FIG. 27, the “total amount” is acquired from the linked sales detail record, and the delivery destination master file F is acquired based on the “product code” of the linked sales detail record.
4 is accessed and the “total amount” acquired from the linked sales detail record is added and updated to the “cumulative amount by destination” in the corresponding record of the destination master file F4. Further, a slip record corresponding to the slip detail / slip total file F2 is created based on the contents of the linked sales detail record (step C7), and this slip record is additionally registered in the slip detail / slip total file F2 (step C8). When the processing for one record is completed in this way, it is determined whether or not there is an unprocessed record in the linked sales detail file F6 (step C9). If there is an unprocessed record, the process returns to step C1 and the unprocessed After reading the record, the above operation is repeated.

FIG. 30 is a flow chart showing the operation of the store terminal 2 which is started to be executed in response to the activation of the sales management system 21 in the ordering business of actual store sales. First, the store terminal 2 reads the sales slip form in accordance with the sales management system 21 and displays and outputs the sales slip form (step F1).
Is input (step F2), a slip record is created based on the input slip data (step F2).
3), additionally registered in the slip description / slip total file F2 (step F4).

Here, the designated state of predesignated slip immediate processing / batch processing is discriminated (step F5), and if the slip immediate processing is designated, it is used for ordering work based on the created slip record. Various slips (a delivery note, a transfer request form, a delivery slip, etc.) are printed (step F6), and various slip management processes for other businesses are performed based on this slip record (step F7). Then, the "customer code" is obtained from the created slip record, the customer master file F3 is searched based on this "customer code", and the corresponding customer record is read (step F8), and the slip record is read. "Total amount" obtained from within the "total amount of sales" in the customer record
Is added to and the "cumulative sales amount" is updated (step F
9).

Next, the "delivery address code" is entered in the slip record.
If it includes (step F10), the “customer code” and the “delivery code” are acquired from the slip record, and the delivery destination master file F4 is searched based on the “customer code” and the “delivery code”. Then, the corresponding destination record is read (step F11), and the "total amount" acquired from the slip record is added to the "total amount by destination" in the destination record to update the "total amount by destination". (Step F12). If batch processing is specified in step F5, processing for updating the "cumulative sales amount" in the customer master file F3 is performed (steps F8 and F9). If the slip record contains the "delivery address code" (step F10), the process of updating the "delivery destination cumulative amount" of the delivery destination master file F4 is performed (steps F11 and F12).

FIG. 31 shows the sales management system 2 when a batch processing request is received from the operator or a slip processing request is received from the net order input module M6.
3 is a flowchart showing an operation of the store terminal 2 in which 1 is started and execution is started. First, the slip description / slip total file F2 is accessed to read an unprocessed slip record (step G1), and various slips for ordering work are executed based on this slip record (step G2). Based on the above, various slip management processes for other business are executed (step G3). Then, it is checked whether or not there is an unprocessed slip record in the slip description / slip total file F2 (step G4).
Then, the slip print / management process is performed based on the unprocessed record (steps G2 and G3).

As described above, the store terminal 2 in this embodiment receives the order information (order contents, orderer information) from the shopping mall site 1, and the orderer information is the customer on the sales management system 21 side. If it is already registered in the master file F3, the sales record (cumulative sales amount) in the customer master file F3 corresponding to the orderer is updated based on the order contents of online sales, but if the orderer information is not registered yet. If so, obtain the orderer information from the customer master file F3
In addition to the additional registration to the customer master file F3 as the sales result corresponding to the orderer, the contents of the online sales order are added to the sales management system 21 without changing the existing sales management system 21. It can be linked to each other, without the burden of manually inputting the order details and orderer information of the online sales, without posting errors, it is possible to reliably process the orders of the online sales and also the online sales It becomes possible to treat customers who use the same way as customers in the actual store. As a result, online sales can be reflected in daily operations, and the results of online sales can be taken into consideration when customer service and sales promotion are performed according to the sales results of each customer.

In this case, in addition to the customer master file F3, the linked customer master file F8 for the online shop is used.
In order to store and manage customer information and sales results (cumulative sales points) corresponding to customers who use the online shop, the cumulative sales points are updated.
Even if the customer who uses the online shop and the customer who uses the actual shop are mixed and stored in the customer master file F3, it is possible to easily grasp the usage situation of the online shop for each customer. In addition, it is possible to promote customer service and sales promotion according to the usage record of online sales.

When the orderer information from the shopping mall site 1 is registered as the customer information in the customer master file F3, the orderer information and the customer information are compared and displayed so that the operator can check the difference between them. If there is a need for correction and correction, the customer information in the customer master file F3 is corrected and updated based on the orderer information received this time in response to the correction request from the operator. When the telephone number or the like is changed, the contents of the customer master file F3 can be corrected based on the latest information without requiring the customer to be notified of the change, and troublesome correction work is unnecessary. In addition, important information called customer information will not be erroneously corrected due to input mistakes, etc. Since is interposed, it is possible to increase the safety.

Further, a slip record is created based on the order information from the shopping mall site 1 and this slip record is stored in the slip detail / slip total file F2 on the sales management system 21 side. Various slip processes can be executed based on the order information, and a delivery note, a transfer request form, etc. can be obtained in response to an order for online sales.

On the other hand, the store terminal 2 receives the order information (order details, orderer information, destination information) from the shopping mall site 1, and the orderer information and destination information are the delivery destination master file on the sales management system 21 side. If it is already registered in F4, the sales record (cumulative amount of delivery address) in the delivery destination master file F4 corresponding to the customer and the delivery destination is updated based on the order contents of online sales, but the customer information and the delivery destination information are not registered. If there is, the customer information and the destination information are additionally registered in the destination master file F4,
Since the contents of the online sales order are additionally registered in the destination master file F4 as sales results corresponding to the customer and the destination, the existing sales management system 21 can be linked to the sales management system 21 without modification. It is possible to securely process the order received by the online shop with the delivery request of the product without the burden of manually entering the order details of the online sales, the customer information, and the destination information, and without any posting error. At the same time, it becomes possible to handle it in the same way as the management by customer / destination by the actual store.
As a result, online sales can be reflected in daily operations, and the results of online sales can be taken into consideration when implementing customer service and sales promotion in accordance with sales results by customer and destination.

In this case, in addition to the delivery destination master file F4, the linked delivery destination master file F9 for the online shop is used.
Therefore, even if the customer who uses the online shop, the customer who uses the online shop and the customer who uses the actual shop, and the destination are stored together in the destination master file F4, the delivery using the internet shop is performed as necessary. Management can be done individually. Further, a delivery slip (delivery slip) as well as a delivery note, a transfer request form, and the like can be obtained based on a slip record created based on order information for online sales.

On the other hand, the net shop construction AP 22a
The configuration is roughly divided into an online shop definition module M1, an online product registration module M2, and an online product display module M3. When a new online shop is constructed, after displaying the work procedure on the screen, each module is sequentially activated. , It guides the series of work contents while sequentially displaying each work screen, and uploads the net construction information generated by this series of work to the shopping mall site 1 side. It becomes possible to efficiently carry out, and even a user who cannot fully use a PC or a user who does not have knowledge of Web pages can easily build an online shop unique to a store. In this case, perform a series of work 3
By dividing into stages, a person with minimum necessary skills can share the work in each stage, and if the online product display module M3 is individually activated, the product lineup and display status can be improved. Can be easily changed by anyone.

In the above-described embodiment, the shopping mall site 1 transmits the order information to the corresponding store terminal 2 each time it receives an order for online sale, and the store terminal 2 receives the order information for online sale. The order information is sequentially accumulated in the linked sales statement file F6 under the control of the online order information acquisition module M5 every time the shopping mall site 1 responds to the transmission request from the store terminal 2 and the online sales information file F6. The order information for sale may be collectively transmitted to the store terminal 2 that is the request source. In addition, the store terminal 2 uses the online order input module M
When 6 is activated, the online sales order information accumulated in the linked sales details file F6 is collectively fetched and the online order input is batch processed. However, every time an online sales order is generated. , Take the order information,
By activating the net order input module M6, the net order input process may be performed in real time.

In the above-described embodiment, the net order input module M6 is activated to register the customer information and the customer information of the net sales in the corresponding customer master file F3 and the customer master file F4 on the sales management system 21 side. However, the shopping mall site 1
When an order is received, the customer information and the destination information are acquired from the store terminal 2, the customer-dependent processing such as multiplication rate and consumption tax fraction processing is performed, and the information is displayed on the online shop. Therefore, more detailed customer service may be provided.

Each time the shopping mall site 1 receives a product order from the product purchaser terminal 4, the shopping mall site 1 transmits an order page screen to the product purchaser terminal 4 to input customer information and delivery destination information together with the order details. However, when a product order is received from the product purchaser terminal 4, the shop terminal 2 corresponding to the online shop is accessed and the shop terminal 2
If the customer information and the addressee information of the customer are acquired from the customer, the information is inserted into the order page and transmitted to the product purchaser terminal 4, the product purchaser terminal 4 side is the same for each online order. Since there is no need to input the information in the order page screen, the input work can be performed efficiently.

In addition to the customer master file F3, the linked customer master file F8 for the online shop is provided, and the linked destination master file F9 for the net shop is provided separately from the destination master file F4. We are good at items that change the record structure of the customer master file F3 and the destination master file F4 on the side to store "net sales identification data" and "sales record of net sales" to indicate that the information is related to online sales. If you add it to the destination record and the delivery destination record, the linked customer master file F for the online shop
8 and the linked delivery destination master file F9 are unnecessary. In addition, when updating the sales record (cumulative sales amount) in the customer master file F3 based on the order details of online sales, the item "Last sales date" is provided in the customer master file F3, and "Sales record" is set. The “last sale date” may be updated together with “.

Further, the present invention is not limited to the file management system for managing the various files described above, but can of course be applied to a database management system for managing them in a database. In this case, the sales management system 2 is changed according to the change of the data structure, for example, addition or deletion of fields.
1. Since it is not necessary to change the online shop construction / operation system 22, it is possible to deal flexibly.

Further, the sales management device as the store terminal 2 is not limited to the stand-alone type, and can transmit data via a wired transmission line such as a communication line or a cable or a wireless transmission line such as radio waves, microwaves, infrared rays or the like. It may be a distributed computer system that transmits and receives. In this case, a store PC incorporating the sales management system 21 and a store PC incorporating the online shop construction / operation system 22 are provided, and data is transmitted / received to / from each store PC so as to link them. Good. Here, when applied to a client / server system, an online shop construction / operation system 2 is installed on the server computer.
2 may be incorporated.

The actual store is not limited to a small personal store such as a stationery store or a fresh fish store, but may be a large-scale enterprise store such as a discount store, a convenience store, or a supermarket. It may be a store that carries out catalog mail order. Further, the products handled by the physical store are not limited to tangible products, but may also be sold as intangible products such as music contents, image contents, and document contents. You may

On the other hand, the computer may be provided with a recording medium (for example, a CD-ROM, a floppy disk, a RAM card, etc.) in which program codes for executing the above-mentioned respective means are recorded.
That is, a recording medium having a computer-readable program code, a function of receiving customer information together with the order contents of the online sales ordered by the online shop performing electronic commerce via the network, and the actual store For each customer who has a history of commercial transactions, a function to determine whether the received customer information is registered in the customer storage means for the actual store that stores and manages the customer information, and to determine that it has already been registered If it is determined that it is not registered, the function of updating the sales record for each customer stored and managed corresponding to the customer based on the content of the order for the online sales, The received customer information is additionally registered in the customer storage means, and the contents of the online sales order are additionally registered as sales results for each customer corresponding to the customer. It may be programs recorded computer to provide a recording medium readable for realizing the functions and that.

A recording medium having a computer-readable program code, and a function of receiving the customer information and the delivery destination information together with the order contents of the online sales for which the merchandise is ordered by the online shop which conducts electronic commerce through the network. In response to each customer who has a history of commercial transactions in the physical store, when the customer requests the delivery of the purchased product to a third party, the customer information and the destination information are stored and managed for the physical store. A function for determining whether the received customer information and destination information are registered in the destination storage means, and when it is determined that the received customer information and destination information are registered, they are stored and managed corresponding to the customer and the destination. A function to update the sales performance by customer / destination based on the contents of the online sales order, and if it is determined that it is not registered, the reception A program for realizing the function of additionally registering customer information and delivery destination information in the delivery destination storage means and additionally registering the contents of the online sales order as sales results by customer / delivery destination corresponding to the customer / delivery destination. You may make it provide the computer-readable recording medium which recorded.

[0135]

According to the present invention (the invention according to claim 1), when the contents of the order and the customer information on the side of the online shop are received and the customer information is already registered, the sales record corresponding to the customer. Is updated based on the order contents of online sales, but if the customer information is not registered, the customer information is additionally registered, and the order contents of online sales are additionally registered as sales results corresponding to the customer. Since it can be linked to the sales management system without changing the existing sales management system, there is no burden of manually entering the order details and customer information of the online sales, there is no posting error, etc. It is possible to securely process the orders of the above, and it is possible to handle the customers who use the online sales in the same manner as the customers of the actual store. As a result, online sales can be reflected in daily operations, and the results of online sales can be taken into consideration when customer service and sales promotion are performed according to the sales results of each customer. According to the present invention (the invention according to claim 6), the contents of the order for the online sale, the customer information and the destination information are received, and if the customer information and the destination information are registered, the sales corresponding to the customer and the destination are made. The results are updated based on the online sales order contents, but if the customer information and delivery destination information are not registered, the customer information and delivery destination information are additionally registered, and the online sales order contents are displayed for the customer and the delivery destination. Since it is additionally registered as sales results, it can be linked to the sales management system without changing the existing sales management system, and the burden of manually entering the order details, customer information, and destination information of online sales. It is possible to securely process orders from the online shop with delivery requests for products without any mistakes and posting errors, and at the same time, by customer of the actual shop Another management and can be handled in the same way. As a result, online sales can be reflected in daily operations, and the results of online sales can be taken into consideration when implementing customer service and sales promotion in accordance with sales results by customer and destination.

[Brief description of drawings]

FIG. 1 is a block diagram showing the overall configuration of a sales management network system.

FIG. 2 is a block diagram for explaining a basic system outline of the store terminal 2.

FIG. 3 is a diagram for explaining the operation concept of an online shop definition module M1, an online product registration module M2, and an online product display module M3 that form an online shop building AP 22a.

FIG. 4A is a diagram showing a record structure of a product master file F1, and FIG. 4B is a linked product master file F.
The figure which showed the record structure of 5.

FIG. 5 is a diagram showing a configuration of a product display definition file F31.

FIG. 6 is a diagram showing how various types of information obtained by building an online shop are uploaded to the shopping mall site 1 side.

FIG. 7 is a diagram showing the contents of a store-specific storage area E that stores and manages online shop construction information for each store on the shopping mall site 1 side.

FIG. 8A is a diagram showing the contents of a store management table T provided on the shopping mall site 1 side;
FIG. 6B is a diagram showing a record structure of the order information file OF.

FIG. 9 is a diagram showing a list of various files provided on the sales management system 21 side and various files provided on the online shop construction / operation system 22 side.

FIG. 10A shows a customer master file F3,
FIG. 9B is a diagram showing a record structure of a linked customer master file F8.

[FIG. 11] (A) shows a destination master file F4,
FIG. 9B is a diagram showing a record structure of a linked delivery destination master file F9.

FIG. 12 is a block diagram showing basic components of the store terminal 2.

FIG. 13 is a flowchart showing the operation of the shop terminal 2 in response to the activation of the online shop building AP 22a included in the online shop building / operating system 22.

[Fig. 14] Fig. 14 is a flowchart showing the operation at the time of building an online shop, following Fig. 13.

FIG. 15 is a flowchart showing the operation at the time of building an online shop, following FIG.

FIG. 16 is a flowchart showing the operation at the time of building an online shop, following FIG. 15.

FIG. 17 is a flowchart showing the operation at the time of building an online shop, following FIG. 16.

[FIG. 18] FIG. 18 is a flowchart showing an operation at the time of building an online shop, following FIG. 13.

FIG. 19 is a flowchart showing the operation at the time of building an online shop, following FIG.

FIG. 20 is a flowchart showing the operation at the time of building an online shop, following FIG. 18;

FIG. 21 is a flowchart showing the operation at the time of building an online shop, following FIG. 20;

FIG. 22 is a flowchart showing the operation at the time of building an online shop, following FIG. 20;

FIG. 23 is a flowchart showing the operation at the time of building an online shop, following FIG. 22;

FIG. 24 is a flowchart showing the operation at the time of building an online shop, following FIG. 23;

FIG. 25 is a flowchart showing an operation on the side of the shopping mall site 1 in response to access from the product purchaser terminal 4.

FIG. 26 is a shopping mall site 1 following FIG. 25.
6 is a flowchart showing the operation on the side.

FIG. 27 is a flowchart showing the operation of the store terminal 2 according to the online sales input AP 22b that constitutes the online shop construction / operation system 22.

FIG. 28 is a flowchart detailing the customer registration process shown in FIG. 27.

29 is a flowchart detailing the destination registration processing shown in FIG.

FIG. 30 is a flowchart showing the operation of the store terminal 2 according to the sales management system 21.

FIG. 31 is a flowchart showing the operation of the store terminal 2 in the case of performing a slip batch process according to the sales management system 21.

FIG. 32A is a diagram showing a work procedure screen, and FIG.
Shows the shop structure definition screen.

FIG. 33 is a view showing a base screen for new net product registration.

FIG. 34 is a view showing a product list screen of a selection master (product master file F1).

FIG. 35 is a diagram showing an image list screen.

FIG. 36 is a view showing a product guide page creation processing state, (A) shows a specific example of the created product guide page, and (B) shows the contents of one page constituting the HTML file F12. The figure which showed.

FIG. 37 is a diagram showing an online product display <page list> screen.

FIG. 38 is a view showing a display product registration screen corresponding to a selection page.

FIG. 39 is a view showing a product list screen of a linked product master file F5.

FIG. 40 (A) shows a change menu screen,
FIG. 6B is a diagram showing the contents of the order page.

[Explanation of symbols]

1 shopping mall site 2 store terminals 3 network 4 Product purchaser terminal 21 Sales Management System 22 Online shop construction / operation system F1 product master file F2 slip details / slip total file F3 Customer Master File F4 Delivery master file F6 linked sales statement file F8 interlocking customer master file F9 linked destination master file M5 online order information acquisition module M6 online order entry module

─────────────────────────────────────────────────── ─── Continuation of front page (51) Int.Cl. ⁷ Identification code FI theme code (reference) G06F 17/60 514 G06F 17/60 514 ZEC ZEC (72) Inventor Kazu Tai Haraguchi Sakuragaoka, Higashiyamato, Tokyo 2 Chome 229 Casio Computer Co., Ltd. Tokyo office (72) Inventor Kenichi Hibino 2 Sakuragaoka, Higashiyamato City, Tokyo 2 229 Casio Computer Co., Ltd. Tokyo office (72) Inventor Yoshihiro Sato 2 Sakuragaoka, Higashiyamato, Tokyo 2-229, Casio Computer Co., Ltd. Tokyo office (72) Inventor Yoshiaki Yuyama 2-229, Sakuragaoka, Higashiyamato-shi, Tokyo Casio Computer Co., Ltd. Tokyo office

Claims (10)

[Claims] 1. A sales management device comprising customer store means for an actual shop, which stores and manages customer information for each customer who has a history of conducting commercial transactions in an actual shop, and performs customer management by referring to this customer storage means. Then, receiving means for receiving the customer information together with the order contents of the online sale for which the merchandise is ordered on the side of the online shop conducting electronic commerce via the network, and the customer information received by the receiving means is registered in the customer storing means. If it is determined that registration has been completed by this determining means and the determining means, the customer-based sales record stored and managed corresponding to the customer is set as the order content of the online sales. Update means for updating based on the above, and if the judging means judges that the customer information is not registered, the received customer information is additionally registered in the customer storing means. In addition, the sales management device further comprises: registration means for additionally registering the order details of the online sales as a sales record for each customer corresponding to the customer. 2. In addition to the customer storage means for the actual shop, there is provided a customer storage means for the net shop which stores and manages information about the customer corresponding to the customer using the net shop. The sales management device according to claim 1. 3. It is determined whether the customer information received by the receiving means is a customer who has used an internet shop in the past by referring to the customer storage means for the internet shop, and whether the customer information is a customer using the internet shop. The sales management device according to claim 2, wherein, for example, the sales record for each customer for the online shop corresponding to the customer using the customer is updated. 4. When the customer information received by the receiving means is registered in the customer storage means for the actual store,
2. The sales management device according to claim 1, further comprising a correction unit that corrects customer information corresponding to the customer registered in the customer storage unit under a certain condition based on the received customer information. . 5. The customer information received by the receiving means and the customer information stored and managed in the customer storage means for the actual store corresponding to the customer are displayed and output, and a request for correction and change is issued. 4. The sales management according to claim 3, wherein the correction means corrects the customer information registered in the customer storage means on the basis of the received customer information on the condition that the customer information is received. apparatus. 6. A physical store that stores and manages customer information and destination information when a customer makes a delivery request to a third party for a product purchased by that customer corresponding to each customer who has a history of commercial transactions in the physical store. It is a sales management device that is equipped with a delivery destination storage means for managing the customer and the delivery destination by referring to the delivery destination storage means. Receiving means for receiving the customer information and the destination information together with the order contents, a determining means for determining whether the customer information and the destination information received by the receiving means are registered in the destination storing means, and the determining means If it is determined that it is, the sales results by customer / destination, which are stored and managed corresponding to the customer and the destination, are the order contents of the online sales. Update means for updating based on the update means, and when the determination means determines that the registration is not registered, the received customer information and delivery destination information are additionally registered in the delivery destination storage means, and the online sales order contents And a registration means for additionally registering as a sales record by customer / destination corresponding to the customer and destination. 7. A delivery destination storage means for an online shop, which stores and manages customer information and delivery destination information each time the internet shop is used, in addition to the delivery destination storage means for the actual shop. The sales management device according to claim 6. 8. A sales management device for executing various kinds of voucher processing based on order information input by a commercial transaction in a physical store, wherein a voucher record is created based on the order information for online sales received by the receiving means. 7. The sales management device according to claim 1, wherein the sales management device is created and requests execution of various kinds of slip processing based on the slip record. 9. A computer has a function of receiving customer information as well as the contents of an online sales order for a product ordered on the side of an online shop that conducts electronic commerce through a network, and has a track record of commercial transactions in an actual shop. For each customer, the function of determining whether the received customer information is registered in the customer storage means for the actual store that stores and manages the customer information, and if it is determined that the customer information has been registered, A function to update the sales record for each customer stored and managed corresponding to the customer based on the order contents of the online sales, and when it is determined that the customer has not been registered, the received customer information is stored in the customer information. A program for implementing the function of additionally registering in the storage means and additionally registering the contents of the online sales order as a sales record for each customer corresponding to the customer. 10. A function of receiving the customer information and the destination information together with the order contents of the online sale for the product ordered from the online shop which performs electronic commerce through the network to the computer, and the transaction is carried out in the actual store. In response to each customer who has a track record, when the customer requests the delivery of the purchased product to a third party, the reception information is stored in the delivery destination storage means for the actual store that stores and manages the customer information and the delivery destination information. Function to determine whether the registered customer information and delivery destination information has been registered, and if it is determined that the information has been registered, sales performance by customer and delivery destination that is stored and managed corresponding to the customer and delivery destination And a function of updating the information on the basis of the contents of the order of the online sales, and when it is determined that the registration is not registered, the received customer information and the destination information are stored in the destination storage means. A program for implementing the function of additionally registering to the customer and the sales information for each customer / destination corresponding to the customer and the recipient.