JP2002259723A - Business site building support system for retailers - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a means to allow a middle/minor retailer to build easily a one-stop business site for corporate customers which works utilizing the Internet, etc. SOLUTION: A data center 100 establishes an exchange route of goods data 112 and order data 113 with a wholesaler 110 through a computer network or an electronic medium 111, arranges the goods data of the wholesaler, and performs service for retailers 120. To the goods data 114 given from the wholesaler, each retailer additionally registers individual goods data 123 he wants to sell, registers the pricing factor data 122 for calculation of the offered price in accordance with the customer rank and performs an operational support service for releasing to public as the one-stop service site for the retailer 120, and thus the business site building support service for retailers is established.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention assists a retailer in preparing supplier product data, setting a sales price for each customer, and realizing a one-stop sales site for retailers using the Internet. It is assumed that.

[0002]

2. Description of the Related Art There are many major retailers dealing with individual customers who have already established their own sales sites on the Internet. Some companies have opened sales sites for corporate customers.

[0003] In addition to systems development tools and binaries for building a sales site on the Internet, systems that can be customized by a sales site builder by providing a source are sold. There is a current situation that costs are high.

[0004]

[Problems to be Solved by the Invention] There are many small and medium-sized retailers who do not even have their own homepages, much less the complexity of preparing product data of suppliers and the complexity of setting sales prices for each customer. Due to circumstances, it is difficult to build a sales site using the Internet.

Accordingly, an object of the present invention is to provide means for a small and medium-sized retailer to easily construct a one-stop business site for corporate customers using the Internet.

[0006]

SUMMARY OF THE INVENTION In order to achieve the above object, the present invention relates to a database server installed on a data center via a computer network such as the Internet or an electronic medium via a computer network such as the Internet. And a retailer selling the wholesaler's products installed price coefficient data for calculating a price to be presented to the customer based on the captured product data at the data center via the Internet. Registering in the database server through the Web server, and registering the unique merchandise data possessed by the retailer in the database server through the Web server via the Internet. Access to the database server through the server Mortal, to search for product data of the retailer, to get an estimate of the purchase wish item, in which to be able to the order of the product.

[0007] Further, when order data from the corporate customer is obtained from the database server through the Web server via the Internet, and the product of the order is a wholesaler purchased by the retailer,
The order data can be transferred to the wholesaler via a computer network such as the Internet or an electronic medium.

[0008]

Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a diagram for explaining the configuration of a sales site construction support system for a retailer according to the present invention and the exchange of data.
FIGS. 2A and 2B are display examples of a screen for setting a pricing coefficient such as a margin for each product group, and FIGS. 3A and 3B.
Is a subgroup (middle category) of each product group (major category)
4A, FIG. 4B, and FIG. 4C show screens for setting a valuation coefficient such as a profit margin for each subgroup. 5A and 5B are display examples of a screen for applying the price group (arbitrary combination of the pricing coefficients of each product group) defined in FIG. 2A to the customer of the retailer, FIGS. 6A, 6B, FIG. 6C is a flowchart showing a calculation process of a selling price presented to the retailer customer, FIG. 7A is a screen example of a quote that can be obtained by the retailer customer, and FIG. 7B is a quote list displayed by the retailer customer. 7C is a display example of a shopping cart displayed when an arbitrary quote item is selected from the quote list, and FIGS. 8A, 8B, 8C, and 8D are retailer customers. Is a retail business It is a display example of a screen for setting in advance the contents of the top page that is displayed when you log in to the operating site.

In FIG. 1, 100 is a data center, 1
10 is a wholesaler, 120 is a retailer, 130 is a retailer's customer, any retailer can purchase goods from multiple wholesalers, there are multiple retailers, and each retailer has Since each customer can have a plurality of customers, the wholesalers, retailers, and customers of the retailers are suffixed in the figure, but the suffixes are omitted in the description.

As shown in FIG. 1, the sales site construction support system for a retailer according to the present invention has a product name, a model number, a price,
Data center 100 that holds product data such as specifications and stock quantities, and order data such as product names, model numbers, and quantities
And a wholesaler 110 that provides product data 112 to the data center 100 via a computer network such as the Internet or an electronic medium 111 and receives order data 113 from the data center 100; Data 114
Is registered in the data center 100 and price coefficient data 122 for calculating the price of the product presented to the customer 130 of the retailer based on the data center 100, and the retailer receiving the order data 124 from the data center 100 It is composed of a retailer 120 and a customer 130 of the retailer who accesses a sales site of the retailer 120 in the data center 100 via the Internet 131, searches for a product, obtains a quote, and places an order.

Although not shown here, the data center 100 constituting the system includes a processing device such as a Web server and a database server for the present invention, and can be accessed via a computer network such as the Internet. Retailers 1 that make up the system
20, each of the retailer's customers 130 is equipped with a device equipped with a Web browser for the processing of the present invention, and can access the sales site of the retailer 120 in the data center 100 via the Internet, and The constituent wholesaler 110 includes a processing device such as a server for processing according to the present invention, and can access a database server in the data center 100 via a computer network such as the Internet.

In FIG. 1, the solid lines with arrows between the data center 100, the wholesaler 110, the retailer 120, and the retailer's customer 130 across the Internet, a computer network, or an electronic medium indicate data movement. The dashed line with an arrow indicates the operation, and the entire processing flow of the present invention will be described below with reference to FIG.

In order to establish a sales site on the Internet of the retailer 120, merchandise data 112 from a wholesaler 110 who has business with the retailer 120 is transferred to a computer network such as the Internet or an electronic medium 111.
And the data center 100 holds the data as merchandise data 114 of the wholesaler.

The wholesaler's product data 114 and the retailer 120 wishing to sell to the retailer's customer 130, W
The data center 10 combines the unique product data 123 registered by inputting from a web browser form or uploading a text file describing product data.
0 is stored as merchandise data 125, and
Calculate the sales price offered by the retailer 120 when the retailer customer 130 accesses the retailer's sales site, registered by the retailer 120 by inputting from a web browser form or uploading a text file containing pricing coefficient data. The data center 100 holds price coefficient data 122 for retailers as price coefficient data 126 for retailers.

The customer 130 of the retailer uses the Web browser to access the data center 1 via the Internet 131.
Go to the sales site of the retailer 120 at 00,
The product data 125 of the retailer is searched, and if necessary, a quote is obtained and an order is placed.

When the retailer customer 130 searches for a product, the sales price calculated based on the pricing coefficient data 126 for the retailer customer 130 registered by the retailer 120 in the data center 100 is presented, and the retailer's customer is searched. Customer 130
Has obtained the quote, the data center 100 holds the quote data 127, and when the customer 130 of the retailer has ordered the product desired to be purchased, the data center 100 holds the order data 128.

The retailer 120 uses the Web browser to access the data center 100 via the Internet 121, and stores the order data 1 held by the data center 100.
Order data 1 of unique goods of the retailer 120 out of 28
24, and in the case of an order for a product handled by the wholesaler 110, the data center 100 transmits the order data 113 to a computer network such as the Internet or the electronic medium 1.
Hand over to wholesaler 110 via 11.

Next, regarding the above-mentioned coefficient data with a value,
This will be described with reference to FIGS. 2A, 2B, 3A, 3B, 4A, 4B, 4C, 5A, and 5B.

FIG. 2A is an example of a screen for setting a margin and a partition rate corresponding to a price code for each major category of a product and defining a price group. There is a price code 204 for each major category of a product. For the price code, a margin 205 for determining the selling price in addition to the purchase price, and a partition rate 206 necessary for determining the selling price from the desired retail price and the margin are set. Is defined as one price group.

As an example of a procedure for defining a price group, first, a system provides a price group of a template in which a margin and a partition rate are set for each price code as an option default 211 existing in a combo box 210 shown in FIG. 2B. Therefore, if necessary, set a new price group name in the new price group name text box 202,
By clicking the copy button 203 of the price group, for example, a new price group “customer” is added, the margin 205 and the partition rate 206 for each price code of the customer price group are set, and the update button 207 is clicked. I do.

Combo box option 21 shown in FIG. 2B
0 is displayed when the downward arrow on the right end of the price group combo box 200 in FIG. 2A is clicked. To delete the added price group, select the price group to be deleted from the option 210 of the combo box. Click the price group delete button 201.

FIG. 3A is an example of a screen for adding a price code of a medium category of a product to a price code of each major category of a product, and FIG. 3B is included in each of the major categories of a product registered in advance. It is a display example of the content of the combo box for displaying and selecting the middle classification to be performed.

As an example of the definition of the price code for the middle category of the product, the option 310 of the combo box shown in FIG. 3B is used.
A middle class to be added is selected, and the middle class of the selected product is displayed in a product category combo box 300 to be added as a price code in FIG. 3A, and a margin 301 and a partition ratio 302 are displayed.
Is set, and a registration button 303 is clicked, so that it is additionally displayed on a detailed list 304 of price codes.

FIG. 4A is an example of a screen for adding a price code paying attention to the maker of the product in addition to setting the price code for the classification of the product. FIG. 4B shows the display and selection of the maker registered in advance. FIG. 4C is a display example of combo box options for displaying and selecting a supplier registered in advance.

As a definition example of a price code for a maker of a product, a maker to be added is selected from a combo box 410 shown in FIG. 4B, a corresponding supplier is selected from a combo box 420 shown in FIG. 4C, and the selected product is selected. In FIG. 4A, the manufacturer and the supplier are displayed in the manufacturer name combo box 400 and the supplier combo box 401, respectively. The margin 402 and the partition ratio 403 are set. Details list 4
05 is additionally displayed.

FIG. 5A is an example of a screen for defining information of a retailer's customer, and FIG. 5B is a view of a combo box for displaying and selecting a price group registered in advance in FIG. 2A applied to the customer. It is a display example.

As an example of the definition of the customer information, a customer name is set in a company / corporate name text box 500 shown in FIG. 5A, a price group to be applied is selected from an option 510 of a combo box shown in FIG. 5B, and the selected price is selected. The group is set as a price group 501 applied to the customer in FIG. 5A, and other necessary items are set, and a registration button 5 is set.
By clicking 02, a customer and a price group applied to the customer are registered in association with each other.

Next, referring to FIGS. 6A, 6B, and 6C, a process of calculating a selling price presented when a customer of a retailer accesses a sales site of the retailer via the Internet and searches for product information. This will be described with reference to 6C.

First, in step 600 shown in FIG. 6A,
If the selling price of the product is set as an absolute value in the price group designation applied to the customer, the selling price becomes the offer price in step 601, and the selling price is set in the price group designation. If not, when the absolute value of the selling price is specified for all price groups in step 602, the selling price becomes the offered price in step 603.

Next, in step 604, when the partition price of the product is set as an absolute value by specifying the price group applied to the customer, in step 620 shown in FIG. If there is a setting, if the product belongs to the middle-class price code in step 621, the absolute value of the manufacturer-specific margin and the partition price specified for the middle-class price code is determined in step 622. If the product does not belong to the middle-class price code in step 621, the manufacturer-specified margin and partition price specified for the large-class price code are calculated in step 623. Calculate the offer price using the absolute value.

If there is no setting of the margin by manufacturer in step 620, and if the product belongs to the middle class price code in step 624, the product is designated for the middle class price code in step 625. The proposed price is calculated using the common margin of all manufacturers and the absolute value of the partition price. If the product does not belong to the middle-class price code in step 624, the large-class price code is calculated in step 626. The offer price is calculated using the absolute value of the common margin and the partition price specified by all manufacturers.

If it is determined in step 604 that the partition price of the product is not set by specifying the price group applied to the customer, the process proceeds to step 605, and the partition price of the product is changed to an absolute value by specifying all price groups. If it is set in step 620 shown in FIG. 6B, if there is a setting of the margin by manufacturer, if it is determined in step 621 that the product belongs to the middle-class price code, step 62
In step 2, the offer price is calculated using the manufacturer-specific margin and the absolute value of the partition price specified for the middle-class price code. In step 621, the product must belong to the middle-class price code. For example, in step 623, the offered price is calculated using the manufacturer-specific margin and the absolute value of the partition price specified for the large classification price code.

At step 605, if the partition price of the product is not set as an absolute value for all price groups applied to the customer, the process proceeds to step 606, where the desired retail price is set as the price of the product. If the product has been set in step 640 shown in FIG. 6C, and if the product belongs to the middle-class price code in step 641, the process proceeds to step 64.
2. Calculate the offered price using the margin by manufacturer specified for the middle-class price code, the suggested retail price, and the manufacturer-specific partition rate specified for the middle-class price code. If the product does not belong to the middle-class price code at 641, the manufacturer's margin, suggested retail price, and the big-class price code specified for the large-class price code are specified at step 643. The proposed price is calculated using the manufacturer-specific partition rate.

If there is no setting of the margin by manufacturer in step 640, and if the product belongs to the price code of the middle category in step 644, the product is designated in step 645 for the middle category price code. The proposed price is calculated using the common manufacturer's margin, the suggested retail price, and the common manufacturer's partition rate specified for the middle class price code, and in step 644 the product is converted to the middle class price code. If not, in step 646 the common manufacturer's margin, suggested retail price specified for the major category price code, and the common manufacturer's partition rate designated for the major category code are used. To calculate the offered price.

If it is determined in step 606 that the desired retail price has not been set as the price of the product, step 6
At 07, the product is handled as not for sale.

Next, the customer of the retailer accesses the sales site of the retailer via the Internet, the customer obtains a quote for the product desired to be purchased, and selects an arbitrary quote item from the saved quote history. The process of putting in the shopping cart will be described with reference to FIGS. 7A, 7B, and 7C.

FIG. 7A is a display example of a quote, and FIG.
FIG. 7C shows a display example of the estimation history list, and FIG. 7C shows a display example when a product is put into a shopping cart from the estimation data.

The quote 700 is displayed by clicking the quote button 721 in the shopping cart 720 displayed when a purchase operation is performed on a product search result screen or the like, and the quote data is saved at that timing. Then, even after logging in again, the history can be referred to as the quote list 710, and by clicking an arbitrary quote number 711 in the quote list 710, the shopping cart 720 is called again with the product of the quote data stored. Can be.

Next, a method of setting a top page screen displayed when a retailer's customer accesses the retailer's business site via the Internet will be described with reference to FIG.
A, FIG. 8B, FIG. 8C, and FIG. 8D.

FIG. 8A edits the contents of the top page displayed when the customer logs in to the system of the present invention, for each customer of the retailer, or for all customers if no distinction is required for each customer. Screen display example for
FIG. 8B is a display example of combo box options for selecting a customer to be defined, and FIG. 8D is a selection of a part template constituting a screen displayed when the customer logs in to the system of the present invention. FIG. 8C is a display example of a combo box option for selecting a position on the whole screen to display a product display screen based on the template.

As a procedure for defining a customer screen, a customer to be defined is selected from options 820 shown in FIG. 8B displayed by clicking a downward arrow at the right end of the target customer combo box 800, and a product shelf combo box is displayed. 8
8 is displayed by clicking the down arrow at the right end of the template 01 shown in FIG. 8C, and the option 84 shown in FIG. 8D displayed by clicking the down arrow at the right end of the template combo box 803 is displayed.
Select a template to be adopted from 0, set search conditions for products in the combo boxes 804 to 808, and click a search button 809 to display products matching the conditions in the corresponding product list 810, and furthermore, a corresponding product list 810
By selecting a product to be displayed from among the products displayed in, and clicking the down arrow button 812, a product to be displayed is set in the display product list 814.

When an arbitrary product displayed in the corresponding product list 810 is selected, if the product has image data, the image is displayed in the image data display area 811 and an arbitrary product is selected from the display product list 814. By clicking the upward arrow button 813, the product can be excluded from the display target, and all the products set in the display product list by the clear button 816 can be deleted.

The display image button 8 shows how the products set in the display product list are displayed based on the template selected in the template combo box 803.
15 can be confirmed by clicking the button, and a detailed list of the definition contents of the display screen for each customer can be displayed by clicking the confirmation button 817 of the setting contents. Is registered in the system.

[0045]

As described above, according to the sales site construction support system for retailers of the present invention, due to the complexity of the preparation of merchandise product data and the complexity of setting the sales price for each customer, the company has Small and medium-sized retailers who have not yet established a sales site on the Internet can easily build their own sales site, and it is possible to increase the depth of cultivation and sales efficiency of each retailer customer.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a system configuration according to an embodiment of the present invention.

FIG. 2A is an explanatory diagram showing a display example of the embodiment of the present invention.

FIG. 2B is an explanatory diagram showing a display example of the embodiment of the present invention.

FIG. 3A is an explanatory diagram showing a display example of the embodiment of the present invention.

FIG. 3B is an explanatory diagram showing a display example of the embodiment of the present invention.

FIG. 4A is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 4B is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 4C is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 5A is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 5B is an explanatory diagram showing a display example of the embodiment of the present invention.

FIG. 6A is a flowchart showing a procedure for calculating a price presented to a customer.

FIG. 6B is a flowchart showing a procedure for calculating a price offered to a customer.

FIG. 6C is a flowchart showing a procedure for calculating a price presented to a customer.

FIG. 7A is an explanatory diagram showing a display example of the embodiment of the present invention.

FIG. 7B is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 7C is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 8A is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 8B is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 8C is an explanatory diagram showing a display example according to the embodiment of the present invention.

FIG. 8D is an explanatory diagram showing a display example according to the embodiment of the present invention.

[Explanation of symbols]

 100 Data Center 110 Wholesaler 111 Computer Network or Electronic Medium 112 Product Data 113 Order Data 114 Wholesaler Product Data 120 Retailer 121 Internet 122 Pricing Coefficient Data 123 Unique Product Data 124 Order Data 125 Retailer Product Data 126 Retailer Coefficient Data 127 Retailer Estimate Data 128 Retailer Order Data 130 Retailer Customers 131 Internet

Claims (4)

[Claims] 1. A function of obtaining merchandise data from a wholesaler from an arbitrary wholesaler via a computer network such as the Internet or an electronic medium, and maintaining the wholesaler's merchandise data on a daily basis, and selling the wholesaler's merchandise. A function to calculate the selling price to be offered to each customer of the retailer based on the product data of the wholesaler (supplier) from the customer data of any retailer, and the original product data of the retailer. A sales site for retailers, which has a function of additionally registering them collectively or individually and a function of transferring order data from any customer of the retailer to the wholesaler through a computer network such as the Internet or an electronic medium. Construction support system. 2. A function for a retailer to set a margin for each product group, a function for adding a subgroup to the product group and setting a margin for the subgroup.
2. The sales site construction support system for retailers according to claim 1, further comprising a function of setting a profit margin of the product by focusing on a maker of the product. 3. A function for a customer to obtain a quote for a product,
2. The sales site construction support system for retailers according to claim 1, further comprising a function of storing and referring to a quote history of a product and a function of selecting an arbitrary quote item from the quote history and continuing order processing. 4. A function that allows a retailer to customize its own sales site, and a function that can customize products and messages displayed on a top page when a customer of the retailer logs into the system for each customer. The sales site construction support system for retailers according to claim 1, further comprising: