JP2002092295A - Store sales management system using communication network - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a store sales management system using a communication network and capable of collectively managing the franchise selling business of communication/OA equipment by a head office by sharing the information of commodities with respective stores. SOLUTION: The store sales management system capable of managing group stores for selling communication/OA equipment by a franchise system for collectively managing the supply/purchasing/delivery/installation of commodities by the head office through the communication network is provided with a store information database having store specification information or the like for specifying a store in a chain, a customer information database having customer specification information for specifying a customer to be a commodity selling target, a lease information database having lease information for specifying a lease object and a lease company, and a commodity information database having commodity specification information or the like for specifying a commodity. The system is provided also with a customer management means for managing customers to be commodity selling targets, a commodity management means including order reception management and purchasing management, a money receipt/payment management means including payment management, sales management and receipt management, and a means connected to respective store terminals to transmit/receive the information of respective database.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a franchise in which the procurement, purchase, delivery, and installation of goods are managed collectively by a headquarters. It sells communication and OA (office automation) equipment, and sells affiliated stores connected to a communication network. The present invention relates to a store sales management system using a communication network, which has a management function.

[0002]

2. Description of the Related Art Conventionally, there are various business forms such as an agency system, a franchise system, and an intermediary business as distribution forms of goods sales. Procurement, purchasing, ordering,
Since the agency handles all the delivery and installation work, the burden on the agency such as efficiency, cost, man-hours, and financing was considerable.

On the other hand, with the recent spread of the Internet, an unspecified number of people (customers) can freely register data on specific items (for example, commodities) on a homepage of the Internet. The so-called e-commerce system, in which a contract member browses data registered by these customers and sells products and the like requested by the customers on a network, is increasing rapidly.

[0004] As an example of such an electronic commerce system, for example, a "customer information registration relay system" disclosed in JP-A-11-66168 is known. FIG.
Is a block diagram of the customer information registration relay system.
This system includes a service center 600 and a customer terminal 3
00 and a contractor terminal 400 are connected via a communication network (wide area computer network) 500. The request information registration unit 610 of the service center 600 is a unit that collects request information (such as a desired product name) from an unspecified number of general customer terminals 300 and registers the collected request information in the request information database.

The system shown in FIG. 9 is realized by using a homepage or the like on the Internet.
The service center 600 sets up a homepage on the Internet by a Web server or the like. The customer is a customer terminal 30 linked to a wide area computer network
The request information registration means 610 using the homepage of the service center 600 as an interface is accessed by the access means 310 such as a Web browser of 0 to request registration of the request information (such as the name of a product to be purchased). The request information registration means 610 of the service center 600 writes and manages the request information in the request information database 710. The contractor who wishes to view the registered request information in this way,
The access information 410 such as a Web browser of the contractor terminal 400 linked to the wide area computer network accesses the request information browsing means 630 using the home page of the service center 600 as an interface.

The service center 600 uses the contractor authentication means 640 to authenticate that the contractor is a legitimately registered member based on the contractor authentication information such as the contractor's password and user ID, and then sets the browsing conditions. Selection information of matching desired information is presented to the contractor using an interface called a homepage. The contractor extracts desired request information from the presented request information selection information. Based on the extracted information, the contractor can directly contact the customer through the customer's contact information and the like included in the information, and perform sales, service, and the like of the product desired by the customer. On the other hand, the center 600 bills the contractor according to the information usage amount.

[0007] However, in the above-mentioned conventional example, the agency in the conventional distribution form has an excessive quota because it is a business entity different from the headquarters in terms of management. However, there was a problem that the burden was too heavy. Also, JP-A-11-6616
In the case of No. 8, service center 600 and contractor 400
This is a relationship between companies that are separate from each other, and access of information is permitted through the authentication procedure using authentication means such as passwords and IDs. Therefore, the procedure is complicated, and it is of course impossible to share information. The fact that both parties work together in order to increase their mutual benefits has a problem that it cannot be expected in terms of corporate form or system.

[0008]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, according to the present invention, communication and communication by a franchise system can be formed more closely than the relationship between the head office and the agency in the agency system. The affiliated stores that sell OA (office automation) equipment and the headquarters are connected by a communication network, and information on products is shared with each store in order to centrally manage procurement, purchase, delivery, installation, etc. of products at the headquarters. It is another object of the present invention to provide a store sales management system using a communication network that has a function of obtaining information on each store related to management and enables efficient collaboration in a new form. .

[0009]

In order to achieve the above object, an invention according to claim 1 is a communication / OA (office automation) device based on a franchise in which procurement, purchase, delivery, and installation of goods are collectively managed by a headquarters. In a store sales management device using a computer system that manages affiliated stores that sell over a communication network, store identification information that specifies the name, address, and responsible person of the affiliated store, customer information in this store , A store information database including at least sales information indicating deposit / withdrawal information, and product information indicating details of a product to be handled, and customer identification information for specifying the name, address, and responsible person of the customer to whom the product is sold , Sales information indicating the unit price of the sold product, installation cost, product information indicating the sold product and its installation method, and store information of the store handling the product A customer information database containing at least each information, lease property, lease specification information specifying a leasing company, lease term information indicating the lending period of the commodity equipment that is the lease property, lease fee information indicating the cost at the time of the lease, lease destination A lease information database that includes at least customer information indicating the information of the store that handles the leased property, the product name, the product identification information that specifies the product with the product code, the unit price of the product, the facility cost, A product information database including at least price information indicating price, and a customer management means for managing a customer who sells the product; a product management means for the product including order management and purchase management; and payment. Management, sales management, and payment management means including payment management, and connected to the terminal of the store to transmit and receive information of each database. And means for. Further, in the invention according to claim 2, the terminal device of the store connected to the sales management device includes a customer identification information for identifying a name, an address, a responsible person of a customer to whom the product is sold, and a sales product. A customer information database including at least unit price, sales information indicating installation cost, product information indicating a sold product and its installation method, and store information of the store handling the product, and a lease that specifies a leased property or a leasing company. Specific information, lease period information indicating the lending period of the commodity equipment that is a leased property, lease fee information indicating the cost at the time of leasing, customer information indicating the leasing destination, store information of the store handling the leased property, A lease information database that includes at least the product name, product identification information that identifies the product with the product code, product price, installation cost,
A merchandise information database including at least price information indicating a price at the time of lease, and a customer management means for managing customers to whom the merchandise is sold; merchandise management of merchandise including order management and purchase management Means, payment management, sales management, and payment management means for payment management, and means for connecting to the sales management device and transmitting and receiving information in the respective databases. The invention according to claim 3 is characterized in that the sales management device and the terminal device of the store can mutually access the database as a shared group without requiring an authentication procedure.

(Operation) According to the store sales management system using this communication network, when accessing the database of the franchise headquarters, the "folder sharing" function or the like, which can set security stages, is used.
Affiliated stores that are franchise group members, once set authentication procedures such as passwords, IDs, etc., make settings so that they are not required each time, specify sharing, and browse the headquarters database from the store, It is possible to share customer information between the headquarters and affiliated stores by saving the information as it is in its own database or to obtain management information from the store in the same way as the headquarters, and to promote joint work of sales activities to customers. The headquarters and affiliated stores with a franchise system build a closer environment on the communication network, share product-related information such as customer information database, product information database, lease information database, etc. Procurement, procurement, delivery, installation, etc. are managed collectively by the headquarters. When accessing the database, by specifying exclusive sharing as a group, it is possible to eliminate the need for each authentication procedure and to respond quickly, and more efficiently compared to the agency system Activities can be facilitated and sales performance can be improved.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A specific example of an embodiment of a store sales management system using a communication network according to the present invention will be described below with reference to the drawings. FIG. 1 is a schematic diagram showing a network configuration of a store sales management system using a communication network according to the present embodiment. FIG.
Reference numeral 1 denotes a franchise headquarters management device that sells OA equipment and the like under a franchise system, controls and manages the operations of each franchise store via a communication network, and promotes sales to customers. 2 is a terminal device of a franchise store that conducts sales activities in a relationship with the headquarters and an extranet or an intranet, in other words, a franchise net, through a communication network under a franchise agreement with the franchise headquarters.
Reference numeral 3 connects the franchise headquarters 1 to each store 2 and further uses a dedicated communication line for connecting a leasing company or a manufacturer / wholesaler who is a product provider to take in as a franchise net, or use the Internet or the like. It is a communication network.

FIG. 2 is a schematic diagram showing the configuration of a store sales management system using the communication network shown in FIG. In FIG. 2, 1 is a sales management device representing a franchise headquarters, 2 is a store terminal device of a franchise store that has concluded a franchise contract, and 3 is a communication network such as the Internet that connects the franchise headquarters 1 and the store 2. Reference numeral 111 denotes a central control unit for controlling the store sales management device 1, and reference numeral 112 denotes a management terminal of the store sales management device 1, which includes a Web tool and the like. Reference numeral 101 denotes a communication line connection unit connected via the communication network 3 and includes a TA, a router, and the like. Reference numeral 102 denotes a data transmitting / receiving means for adjusting a data transfer format based on each protocol.

A store information database 121 stores information on affiliated stores, a customer information database 122 stores customer information on a sales destination, a lease information database 123 stores lease information on a lease form, and a lease or sale 124. A merchandise information database 125 stores information on merchandise to be provided, and a supplier information database 125 stores information on merchandise suppliers such as manufacturers. Similarly, 211 is a central control unit for controlling the store terminal device 2, and 212 is a store terminal including a Web tool and the like. 202 is a data transmitting / receiving means, 222 is a customer information database, 223 is a lease information database,
Reference numeral 224 denotes a product information database. 103, 203
Is a system bus of each device.

Although not shown, the sales management device 1
In order to manage the respective data in cooperation with these databases, the store terminal device 2 has a customer management means for managing a customer to whom the product is sold, a product management means such as order management and purchase management, and a payment method. It has payment / withdrawal management means such as management, sales management, and payment management.

The headquarters 1 and the affiliated stores 2 can freely access the database constructed based on the contract by sharing folders with each other. For example, the store 2 reads the database of the headquarters and directly names the database. Save "
It is also possible to save new information in a time-series manner as its own database by storing the information in a time-series manner, and the headquarters 1 can obtain management information from the store 2 in a similar procedure. Build an active database that can be used as information. In addition, the database system is based on a simple knowledge (HTML) with a goal of a database having a department that can link to a wide range of internal and external business information based on Web technology, rather than a locally closed database such as a LAN. Knowled
ge) database, full-scale RDBMS (relational database management system) and the like. (Note that the headquarters 1 has not given access permission to the supplier information database 125 because it is not necessary for the store 2 within the business scope of the headquarters 1).

Next, the operation thus constructed will be described with reference to the drawings. FIG. 3 is an explanatory diagram showing the flow of goods and payment in the store sales management system using the communication network shown in FIG. 1. As shown in FIG. 3, the franchise store 2 and the customer have a product contract. Is transmitted to the franchise headquarters 1 in the form of order receipt documents or order data, and the franchise headquarters 1 places an order for an ordered product with a manufacturer and requests a leasing company to examine a customer. When the purchased goods are received from the manufacturer, the goods are issued to the customer, the contract is confirmed by the inspection of the leasing company, the customer is requested to maintain the goods, and the payment is confirmed. Request payment to the leasing company and confirm payment. The procedure is as follows.

Referring to the flowchart of FIG. 4, when an order is made with a customer at the affiliated store 2 (S101),
An order slip + lease contract is sent to the headquarters 1 as an order document or order data by a method capable of facsimile or electronic authentication, and necessary items are written, for example, in an Excel sheet (process book) as an order process ( S102). Necessary items include an order date, a person in charge, a customer name, a product name, a credit company name, a lease fee, and the like.

[0018] Items related to the current order are displayed on the display device (S103), and as store information 1 shown in FIG. The customer information such as name and bank account, sales information indicating the deposit and withdrawal information, and product information indicating the details of the product to be handled are written in the store information database 121 (store information DB in FIG. 4) 121 as an order input. At the same time, as customer information 1 shown in FIG. 8B, customer identification information such as a customer name, an address, a person in charge, a bank account, sales information such as a unit price of a sold product, construction cost, and a price of a sold product. Then, the customer information database 122 (customer information DB in FIG. 4) 122a that combines the product information indicating the installation method and the like, the name of the store handling the product, and the store information of the representative is written as an order entry (S104).

Next, other than installation work of the sold product itself, such as INS (registered trademark) work, arrangements and maintenance contracts are made for the works (S105). FAX sent from store at the time of order
Or, according to the contents sent in a way that can be electronically authenticated,
The headquarters 1 requests the leasing company for an examination (S106).
When the examination is returned, the store 2 is notified, and FIG.
As lease information 1 shown in (1), lease specifying information for specifying a leasing company, lease period information for lending periods of commodity equipment that is a leased property, lease fee information for expenses at the time of leasing, customer information for leasing customers, leasing The information 123a including the store information of the store handling the property is written into the lease information database 123 (the lease information DB in FIG. 4) as a lease order input (S107).

Check the stock of the ordered item from the sheet table (S
108). It is determined whether or not there is a stock, and if there is a stock, the process proceeds to S113 (S109). When there is a stock, as a product input, as the product information 1 shown in FIG. 8D, product specifying information for specifying a product such as a product name and a product code, a unit price of the product, facility cost, and a price at the time of lease are shown. Pricing information,
Is written into the product information database 124 (product information DB in FIG. 4) as the delivery information, and at the same time, the delivery information is written in the delivery column of the customer information database 122 (S113). The product of the actual order is installed at the installation location specified by the customer (S114), and the acceptance procedure of the leasing company is performed.

If there is no stock in the judgment at S109, an order is placed with the maker, and the maker order is input to the supplier information database 125 (supplier information DB in FIG. 4) shown in FIG. The product data is written, and at the same time, the data of the ordered (purchased) product is added to the product information database 124 (S110). Next, for the incoming goods from the manufacturer of the ordered goods, the incoming goods information is added to the goods information database 124 as a receiving input (S11).
1). The received goods are delivered to the customer (S112). After the delivery, the products are similarly installed in the processes of S113 to S114.

When the installation work of the product is completed and the acceptance of the leasing company is completed, the process moves to A in FIG. 5 and the sales are determined (S
121). The sales tabulation process is performed (S122) while checking the display (S123) for each tabulation table. A fee is charged to the leasing company (S124). The list of each leasing company is displayed (S125), and the leasing rate, the leasing fee, and the like are confirmed, and the payment information by the payment input is added to the leasing information database 123 and the customer information database 122 (S1).
26). A maintenance fee is charged to the customer (S12
7) After waiting for payment from the customer, the customer's payment information in the customer information database 122 is added as a payment input (S128).

It should be noted that the process proceeds to B in FIG. 6 from the warehousing input S111 from the manufacturer shown in FIG.
131). The purchase information is added as a purchase input to the supplier information database 125 by the purchase from the manufacturer and the storage (S132). After performing the payment processing to the supplier maker (S133), payment information for the purchase is added to the supplier information database 125 as a payment input (S134).

Next, as shown in FIG. 7, as a process at the end of the month (S141), the sales totaling process for the current month is performed by the customer information database 122, the product information database 124, the lease information database 123, and the store information database 12
From the month information of No. 1, the data is totaled like a monthly report by type of each display (S143) (S142). Next, a franchise-specific list (store list) is displayed from the customer information database 122 (S145), a fee for each store is calculated, and payment information is written to the customer information database 122 (S14).
4). In addition, a monthly report for each supplier is displayed from the customer information database 122 (S147), a maintenance fee is charged to the customer every month, and payment information is written into the customer information database 122 (S146). All the updated contents of each database described above are also reflected in the database of the shop terminal 2 side.

As described above, according to the present embodiment, among the databases, the customer information database 122 is the most important information for sales collaborative work because it directly reflects the trends of customers. Relocation information such as "I have a desire to relocate to a wider building" immediately leads to a business opportunity.In such a case, the system will allow the headquarters and affiliated stores to work together to develop joint work, Therefore, it is easy to achieve expected results as compared to agency sales. The customer information database 122 is mainly used for sales activities as history information for nominated contracted customers. In addition to such sales history data, other customers by referrals generated from communication after purchase are introduced. Expand and use the customer information database by ranking preliminary customer information such as information, various internal and external information, information between stores, or predicted customer information extracted from various human relationships, etc. It may be.

The present invention adopts a distributed system called a franchise system in the form of a company, introduces a cutting-edge model of a communication network represented by recent Web computing, and provides an efficient franchise system. By constructing a new business model that enables work, the pressure of the agency system in the conventional OA equipment sales chain can be released, and sales motivation and performance can be improved.

[0027]

As described above, according to the first aspect of the present invention, management of affiliated stores that sell communication and OA equipment by a franchise that collectively manages the procurement, purchase, delivery, and installation of goods at the headquarters. A store management database using a computer system that performs the communication via a communication network, the store information database including the store name, address, store identification information for specifying the responsible person, etc. Customer information database including customer name, address, customer identification information specifying the person in charge, etc., lease information database including lease property, lease specification information specifying the leasing company, etc., product name and product A customer management means for managing a customer to whom the product is sold, including a product information database including product specifying information for specifying the product of the code; And merchandise management means for merchandise including purchase management, payment management, sales management, deposit and withdrawal management means including payment management, and means for connecting to the terminal of the store and transmitting and receiving information of each database. In order to collectively manage the procurement, purchase, delivery, placement, etc. of products at the headquarters, information related to products is shared with each store and collaborative work is possible, so communication / OA equipment by franchise is sold The new franchise group's willingness to sell and expand sales performance by building a new business model that enables efficient collaborative work by linking affiliated stores and headquarters with the latest communication network system There is. According to the invention described in claim 2, the terminal device of the store connected to the sales management device of the franchise headquarters stores the customer's name, address, customer identification information for identifying the responsible person, etc., to whom the product is sold. A customer information database, a lease information database including a lease property, lease specification information specifying a leasing company, and a product information database including a product name and a product code including a product code. Customer management means for managing customers to whom the goods are sold; merchandise product management means including order management and purchase management; payment management, sales management; Means for connecting to the sales management device of the headquarters and transmitting and receiving information of each database, so that the store can use the database of the headquarters in common, enabling collaborative work. By has become, there is an effect that can deploy a functional sales activities by taking advantage of franchise of advantages as a sequence store. According to the third aspect of the present invention, since the sales management device and the terminal device of the store can mutually access the database without requiring an authentication procedure, the affiliated stores share the database of the headquarters, and the headquarters stores the store. Since management information can be obtained, there is an effect that functional sales activities can be performed.

[Brief description of the drawings]

FIG. 1 is a schematic diagram showing a network configuration of a store sales system using a communication network according to an embodiment of the present invention.

FIG. 2 is a schematic diagram showing the configuration of a store sales management system using the communication network shown in FIG.

FIG. 3 is an explanatory diagram showing a flow of goods and payment in a store sales management system using the communication network shown in FIG. 1;

FIG. 4 is a flowchart of a process of the store sales management system using the communication network shown in FIG. 2;

FIG. 5 is a flowchart of a sales confirmation process in the process of the store sales management system using the communication network shown in FIG. 4;

FIG. 6 is a flowchart of a purchase process in a process of the store sales management system using the communication network shown in FIG. 4;

FIG. 7 is a flowchart of a month-end totaling process in a process of the store sales management system using the communication network shown in FIG. 4;

8 is a schematic diagram showing the contents of a database in a store sales management system using the communication network shown in FIG. 2;

FIG. 9 is a block diagram of a conventional customer information registration relay system.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Franchise headquarters (sales management device) 2 affiliated store (store terminal device) 3 communication network 101, 201 communication line connection unit 102, 202 data transmission / reception means 103, 203 system bus 111, 211 central control unit 112 management terminal 121 store Information database 122, 222 Customer information database 123, 223 Lease information database 124, 224 Product information database 125 Supplier information database 212 Store terminal

Claims (3)

[Claims] 1. A computer system that manages affiliated stores that sell communication and OA (office automation) equipment by a franchise that collectively manages the procurement, purchase, delivery, and installation of products through a communication network. In the store sales management device, the name and address of the affiliated store, the store identification information for specifying the person in charge, the customer information at this store, the sales information indicating the deposit and withdrawal information, and the product information indicating the details of the handled product, A store information database that contains at least each information, customer name, address, customer identification information to identify the person in charge of the product, sales information indicating the unit price of the product sold, installation cost, sold product, and its installation A customer information database that contains at least the following information: Lease identification information that identifies the leasing company, lease term information that indicates the lending period of the product / equipment that is the leased property, lease fee information that indicates the cost at the time of leasing, customer information that indicates the leased party, and information about stores that handle leased properties ,
A lease information database that includes at least the following information: a product name that includes at least the following information: a product name, product identification information that specifies the product of the product code, a unit price of the product, equipment cost, and price information that indicates the price at the time of lease. Customer management means that has a database and manages customers to whom products are sold, product management means for products including order management and purchase management, deposit and withdrawal including payment management, sales management, and payment management A store sales management system using a communication network, comprising: a management unit; and a unit connected to a terminal of the store to transmit and receive information of each database. 2. The terminal device of the store connected to the sales management device, wherein a name, address,
Customer information including at least customer identification information for specifying a responsible person, unit price of a sold product, sales information indicating an installation cost, product information indicating a sold product and its installation method, and store information of the store handling the product. Database and lease properties, lease identification information that identifies the leasing company, lease period information that indicates the lending period of the product equipment that is the lease property, lease information that indicates the cost at the time of the lease, customer information that indicates the leased party, lease properties The store information of the store dealing with, the lease information database including at least each information of the product name, product identification information to identify the product of the product code, product price, installation cost, price information indicating the price at the time of lease, A product information database including at least the following information; a customer management means for managing customers who sell products; order management; Merchandise management means for merchandise including purchase management, payment management, sales management, deposit and withdrawal management means for payment management, and means for connecting to the sales management device and transmitting and receiving information of each database. 2. The method according to claim 1, further comprising:
A store sales management system using the communication network described in 1. 3. The communication according to claim 1, wherein the sales management device and the terminal device of the store can mutually access the database as a shared group without requiring an authentication procedure. Store sales management system using a network.