JP5033539B2

JP5033539B2 - Occupational sales processing system, apparatus, method, program, and computer-readable medium storing the program

Info

Publication number: JP5033539B2
Application number: JP2007218420A
Authority: JP
Inventors: 公夫原田
Original assignee: Nippon Systemware Co Ltd
Current assignee: Nippon Systemware Co Ltd
Priority date: 2007-08-24
Filing date: 2007-08-24
Publication date: 2012-09-26
Anticipated expiration: 2027-08-24
Also published as: JP2009053822A

Description

本発明は、職域販売処理システム、装置、方法、プログラム、および該プログラムを格納したコンピュータ可読媒体に関し、詳細には、仲介料算出手段を有する職域販売処理システム、装置、方法、プログラム、および該プログラムを格納したコンピュータ可読媒体に関する。 The present invention relates to an occupational sales processing system, apparatus, method, program, and computer-readable medium storing the program, and in particular, an occupational sales processing system, apparatus, method, program, and program having mediation fee calculation means The present invention relates to a computer-readable medium that stores.

販売業者が商品およびサービスを顧客に販売する形態の１つとして、職域販売がある。職域販売とは、予め販売業者と、顧客となる企業または団体の福利厚生機関とが契約を結び、販売業者の商品およびサービスを契約先の企業の社員、または団体のメンバーに独占販売することである。また、職域販売は、その企業または団体の敷地内に販売業者が訪問して、そこで展示販売を行うことが一般的である。 One form in which sellers sell goods and services to customers is occupational sales. Occupational sales refers to a contract between a distributor and a welfare organization of a company or organization that serves as a customer, and exclusively selling the products and services of the seller to employees of the contracted company or members of the organization. is there. In addition, in the occupational field sales, a dealer visits the site of the company or organization and generally performs display sales there.

また、職域販売において、販売業者は、企業または団体の福利厚生機関に顧客紹介料（仲介料）を支払う場合がある。この仲介料は、一般的に、商品およびサービスごとに個別に設定され、その商品およびサービスの販売数または売上高に応じて変化するように設定される。 Further, in occupational sales, a distributor may pay a customer introduction fee (brokerage fee) to a company or group welfare organization. This brokerage fee is generally set individually for each product and service, and is set to change according to the number of sales or sales of the product and service.

職域販売による販売業者側のメリットとしては、大規模なマーケットを所有できること、売上が販売店舗の立地に左右されないこと、競合がなく独占的に販売することができることなどが挙げられる。一方、企業または団体側のメリットは、販売店に行く手間が省けること、一括購入によるコスト削減により、特別割引などの優遇措置を享受できること、福利厚生を充実できること、販売業者から支払われた仲介料を福利厚生業務の経費等に使用できることなどが挙げられる。 Advantages of the sales side by occupational sales include that they can own a large market, that sales are not affected by the location of the store, and that they can sell exclusively without competition. On the other hand, the merits of companies or organizations are that they can save time and effort to go to the store, enjoy preferential treatment such as special discounts by reducing costs through bulk purchases, enhance benefits, and brokerage fees paid by dealers. Can be used for expenses for welfare services.

一方、現行の販売業者の多くは、インターネットなどのネット網に接続されたサーバ内に自社の商品およびサービスを販売するサイトを有しており、ネットユーザは、このサイトにアクセスして、商品およびサービスを閲覧し、気に入った場合にこれらをネット上で購入する。近年、このようなネット販売は急速に普及しており、様々な販売サイトが出現している。 On the other hand, many of the current dealers have a site for selling their products and services in a server connected to a network such as the Internet. Browse the services and buy them online if you like them. In recent years, such online sales have spread rapidly, and various sales sites have appeared.

従来、訪問販売が主流であった職域販売においても、このネット販売のスタイルが取り入れられつつある。例えば、特許文献１は、ネット網を介して職域販売を行う方法、システム等を開示している。この発明では、ネット販売特有の問題点等を改善し、福利厚生機関に独自の販売サイトを提供している。
特開２００２−１９７２９９ The online sales style is being adopted even in occupational sales, where door-to-door sales have been the mainstream. For example, Patent Document 1 discloses a method, a system, and the like for performing sales at a job area via a network. In the present invention, problems unique to online sales are improved, and a unique sales site is provided to the benefit organization.
JP 2002-197299 A

しかし、上記の特許文献１の発明では、上記の仲介料の仕組みを考慮されていない。よって、特許文献１で開示されているシステムと共に、別途、仲介料を算出する手段が必要となる。 However, in the invention of the above-mentioned Patent Document 1, the mechanism of the brokerage fee is not considered. Therefore, in addition to the system disclosed in Patent Document 1, a separate means for calculating the mediation fee is required.

本発明は、上記のような問題を考慮して創案されたものであり、本発明の課題は、仲介料を算出する手段を有した職域販売処理システムを提供することである。本発明の更なる課題は、該職域販売処理システムで用いる職域販売装置、方法、プログラム、該プログラムが格納されたコンピュータ可読媒体を提供することである。 The present invention has been made in consideration of the above problems, and an object of the present invention is to provide a job sales processing system having means for calculating an intermediary fee. A further object of the present invention is to provide a job sales apparatus, method, program, and computer readable medium storing the program used in the job sales processing system.

上記課題を解決するために、本発明の請求項１の発明は、職域販売契約に基づいて販売業者が商品またはサービスを団体の構成員に販売するために使用される職域販売処理システムであり、以下の発明特定事項を備える。
販売する商品またはサービスが登録された販売サイトを有する販売装置と、
前記団体が前記登録された商品またはサービスを注文するために用いる購入端末と、
前記販売装置および前記購入端末とネットワークを介して接続され、前記商品またはサービスの売買の仲介をする仲介サイトを有する販売仲介装置と、を備え、
前記販売装置は、
販売する前記商品またはサービスに関する情報を前記販売仲介装置に送信する商品・サービス情報送信手段と、
前記販売仲介装置から送信された職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を受信する職域販売決定商品・サービスおよび必要なクーポン数情報受信手段と、
受信した前記職域販売決定商品またはサービスおよび必要なクーポン数に関する情報に基づいて、前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号を作成するクーポンＩＤ・番号作成手段と、
作成した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を前記販売仲介装置に送信するクーポンＩＤ・番号情報送信手段と、
前記購入端末から送信された購入決定商品またはサービスに関する情報を受信する購入決定商品・サービス情報受信手段と、
前記商品またはサービスの売上に関する情報を前記販売仲介装置に送信する売上情報送信手段と、
を有し、
前記購入端末は、
前記職域販売商品またはサービスおよび必要なクーポン数に関する情報を前記販売仲介装置に送信する職域販売決定商品・サービスおよび必要なクーポン数情報送信手段と、
前記販売仲介装置から送信された前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報ならびに前記販売装置のアドレス情報を受信するクーポンＩＤ・番号およびアドレス情報受信手段と、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を自身のサイトに掲載するクーポン情報掲載手段と、
前記購入決定商品またはサービスに関する情報を前記販売装置に送信する購入決定商品・サービス情報送信手段と、
を有し、
前記販売仲介装置は、
前記商品またはサービスの情報が入力された登録商品／サービステーブル、前記販売業者の情報が入力された販売業者テーブル、前記団体の情報が入力された登録購入団体テーブル、前記登録商品／サービステーブルに入力された前記商品またはサービスと前記販売業者テーブルに入力された前記販売業者と前記登録購入団体テーブルに入力された前記団体とが関連付けられたマッチングテーブル、前記商品またはサービスの販売数量とアフィリエイト率とが関連付けられたアフィリエイトテーブルおよび前記アフィリエイトテーブルに基づいて仲介料を算出するための集計テーブルを含むデータベースと、
前記販売装置から送信された前記商品またはサービスに関する情報を受信する商品・サービス情報受信手段と、
受信した前記商品またはサービスに関する情報に基づいて、前記データベースの前記登録商品／サービステーブルに必要な事項を入力するための商品・サービス情報入力手段と、
必要な事項を入力された前記商品またはサービスについて、前記データベースの前記アフィリエイトテーブルを作成するアフィリエイトテーブル作成手段と、
前記購入端末から送信された前記職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を受信する職域販売決定商品・サービスおよび必要なクーポン数情報受信手段と、
受信した前記職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を前記販売装置に送信する職域販売決定商品・サービスおよび必要なクーポン数情報送信手段と、
前記販売装置から送信された前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を受信するクーポンＩＤ・番号情報受信手段と、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報に基づいて、前記データベースの前記マッチングテーブルに必要な事項を入力するためのクーポンＩＤ・番号情報入力手段と、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報ならびに前記販売装置のアドレス情報を前記購入端末に送信するクーポンＩＤ・番号およびアドレス情報送信手段と、
前記販売装置から送信された前記商品またはサービスの売上に関する情報を受信する売上情報受信手段と、
受信した前記商品またはサービスの売上に関する情報に基づいて、前記データベースの前記集計テーブルで指定された集計期間における売上数量および売上金額を集計する売上集計手段と、
集計した前記売上数量を基に、前記データベースのアフィリエイトテーブルを参照して、適用するアフィリエイト率を決定するアフィリエイト率決定手段と、
決定した前記アフィリエイト率を基に、前記団体が前記販売業者から受け取る仲介料を算出する仲介料算出手段と、を有する。 In order to solve the above-mentioned problem, the invention of claim 1 of the present invention is an occupational sales processing system used by a seller to sell goods or services to members of an organization based on an occupational sales contract, The following invention specific matters are provided.
A sales device having a sales site where the goods or services to be sold are registered;
A purchasing terminal used by the organization to order the registered goods or services;
A sales intermediary device having an intermediary site connected to the sales device and the purchase terminal via a network and mediating the buying and selling of the goods or services,
The sales device is:
Product / service information transmitting means for transmitting information related to the product or service to be sold to the sales mediating device;
A job sales decision product / service and a required coupon number information receiving means for receiving information on the job sale decision product or service and the required number of coupons transmitted from the sales intermediary device;
Coupon ID / number creating means for creating a coupon ID and a coupon number of the job sales determined product or service based on the received information regarding the job sales determined product or service and the required number of coupons;
Coupon ID / number information transmitting means for transmitting information related to the coupon ID and coupon number of the created occupational sales determined product or service to the sales mediating device;
Purchase decision product / service information receiving means for receiving information related to the purchase decision product or service transmitted from the purchase terminal;
Sales information transmitting means for transmitting information related to sales of the product or service to the sales mediating device;
Have
The purchase terminal is
A job sales decision product / service and necessary coupon number information transmission means for transmitting information related to the job sales product or service and the required number of coupons to the sales intermediary device;
Coupon ID / number and address information receiving means for receiving information related to coupon ID and coupon number of the occupational sales determined commodity or service transmitted from the sales intermediary device and address information of the sales device;
Coupon information posting means for posting information on coupon ID and coupon number of the received occupational sales determined product or service on its own site;
Purchase decision product / service information transmission means for sending information related to the purchase decision product or service to the sales device;
Have
The sales intermediary device is:
Registered product / service table into which the product or service information has been input, seller table to which the seller information has been input, registered purchase organization table into which the organization information has been input, input to the registered product / service table A matching table in which the product or service entered, the seller input in the seller table and the organization input in the registered purchase organization table are associated, and the sales quantity and affiliate rate of the product or service A database including an associated affiliate table and a summary table for calculating a brokerage fee based on the affiliate table;
Product / service information receiving means for receiving information on the product or service transmitted from the selling device;
Product / service information input means for inputting necessary items to the registered product / service table of the database based on the received information about the product or service;
Affiliate table creating means for creating the affiliate table of the database for the goods or services for which necessary items have been input,
The office sales decision product / service and the required coupon number information receiving means for receiving the information related to the job sale decision product or service and the required number of coupons transmitted from the purchase terminal;
The occupational sales decision product / service and the required coupon number information transmission means for transmitting the received information related to the occupational sale decision product or service and the required number of coupons to the sales device;
Coupon ID / number information receiving means for receiving information on coupon ID and coupon number of the occupational sales determined product or service transmitted from the sales device;
Coupon ID / number information input means for inputting necessary items to the matching table of the database, based on the received information on the coupon ID and coupon number of the occupational sales determined product or service received;
Coupon ID / number and address information transmitting means for transmitting the received information on the coupon ID and coupon number of the occupational sales determined product or service and the address information of the sales device to the purchase terminal;
Sales information receiving means for receiving information related to sales of the goods or services transmitted from the sales device;
Sales aggregation means for aggregating the sales quantity and the sales amount in the aggregation period specified in the aggregation table of the database based on the received information on the sales of the goods or services;
Affiliate rate determining means for determining an affiliate rate to be applied with reference to the affiliate table of the database based on the aggregated sales volume;
Based on the determined the affiliate rate, to have a, a commission fee calculation means the organization calculates a commission fee received from the merchant.

さらに、上記課題を解決するために、本発明の請求項２の発明は、販売業者が商品またはサービスを、職域販売契約に基づいて、団体の構成員に販売する職域販売において、該商品またはサービスが登録された販売サイトを有する販売装置と、前記団体が前記商品またはサービスを注文するために使用する購入端末と、にネットワークを介して接続され、前記商品またはサービスの売買の仲介をする仲介サイトを有する販売仲介装置であり、
前記販売業者が販売する商品またはサービスの情報が入力された登録商品／サービステーブル、前記販売業者の情報が入力された販売業者テーブル、前記団体の情報が入力された登録購入団体テーブル、前記登録商品／サービステーブルに入力された前記商品またはサービスと前記販売業者テーブルに入力された前記販売業者と前記登録購入団体テーブルに入力された前記団体とが関連付けられたマッチングテーブル、前記商品またはサービスの売上数量とアフィリエイト率とが関連付けられたアフィリエイトテーブルおよび前記アフィリエイトテーブルに基づいて仲介料を算出するための集計テーブルを含むデータベースと、
前記販売装置から送信された前記商品またはサービスに関する情報を受信する商品・サービス情報受信手段と、
受信した前記商品またはサービスに関する情報に基づいて、前記データベースの前記登録商品／サービステーブルに必要な事項を入力するための商品・サービス情報入力手段と、
必要な事項を入力された前記商品またはサービスについて、前記データベースの前記アフィリエイトテーブルを作成するアフィリエイトテーブル作成手段と、
前記購入端末から送信された職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を受信する職域販売決定商品・サービスおよび必要なクーポン数情報受信手段と、
受信した前記職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を前記販売装置に送信する職域販売決定商品・サービスおよび必要なクーポン数情報送信手段と、
前記販売装置から送信された前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を受信するクーポンＩＤ・番号情報受信手段と、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報に基づいて、前記データベースの前記マッチングテーブルに必要な事項を入力するためのクーポンＩＤ・番号情報入力手段と、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報ならびに前記販売装置のアドレス情報を前記購入端末に送信するクーポンＩＤ・番号およびアドレス情報送信手段と、
前記販売装置から送信された前記商品またはサービスの売上に関する情報を受信する売上情報受信手段と、
受信した前記商品またはサービスの売上に関する情報に基づいて、前記データベースの前記集計テーブルで指定された集計期間における売上数量および売上金額を集計する売上集計手段と、
集計した前記売上数量を基に、前記データベースのアフィリエイトテーブルを参照して、適用するアフィリエイト率を決定するアフィリエイト率決定手段と、
決定した前記アフィリエイト率を基に、前記団体が前記販売業者から受け取る仲介料を算出する仲介料算出手段と、を有することを特徴とする。 Furthermore, in order to solve the above-mentioned problem, the invention of claim 2 of the present invention provides a product or service in sales in which the seller sells the product or service to the members of the organization based on the occupational sales contract. There a sales device having a sales site registered, the organizations are connected via a network and purchase terminals, to be used to order the product or service, mediated site mediates the goods or services for trading A sales intermediary device having
Registered product / service table in which information on products or services sold by the seller is input, seller table in which information on the seller is input, registered purchase organization table in which information on the organization is input, and the registered products / Matching table in which the product or service entered in the service table, the seller entered in the seller table and the organization entered in the registered purchase organization table are associated, the sales quantity of the product or service A database including an affiliate table in which an affiliate rate is associated and a summary table for calculating a brokerage fee based on the affiliate table;
Product / service information receiving means for receiving information on the product or service transmitted from the selling device;
Product / service information input means for inputting necessary items to the registered product / service table of the database based on the received information about the product or service;
Affiliate table creating means for creating the affiliate table of the database for the goods or services for which necessary items have been input,
The office sales decision product / service and the required coupon number information receiving means for receiving information on the job sale decision product or service and the required number of coupons transmitted from the purchase terminal;
The occupational sales decision product / service and the required coupon number information transmission means for transmitting the received information related to the occupational sale decision product or service and the required number of coupons to the sales device;
Coupon ID / number information receiving means for receiving information on coupon ID and coupon number of the occupational sales determined product or service transmitted from the sales device;
Coupon ID / number information input means for inputting necessary items to the matching table of the database, based on the received information on the coupon ID and coupon number of the occupational sales determined product or service received;
Coupon ID / number and address information transmitting means for transmitting the received information on the coupon ID and coupon number of the occupational sales determined product or service and the address information of the sales device to the purchase terminal;
Sales information receiving means for receiving information related to sales of the goods or services transmitted from the sales device;
Sales aggregation means for aggregating the sales quantity and the sales amount in the aggregation period specified in the aggregation table of the database based on the received information on the sales of the goods or services;
Affiliate rate determining means for determining an affiliate rate to be applied with reference to the affiliate table of the database based on the aggregated sales volume;
Based on the determined the affiliate rates, the organization is characterized in that chromatic and a commission fee calculation means for calculating a commission fee received from the merchant.

さらに、上記課題を解決するために、本発明の請求項３の発明は、販売業者が商品またはサービスを、職域販売契約に基づいて、団体の構成員に販売する職域販売において、該商品またはサービスが登録された販売サイトを有する販売装置と、前記団体が使用する購入端末と、前記販売装置および前記購入端末とネットワークを介して接続され、前記商品またはサービスの売買の仲介をする仲介サイトならびに前記販売業者が販売する商品またはサービスの情報が入力された登録商品／サービステーブル、前記販売業者の情報が入力された販売業者テーブル、前記団体の情報が入力された登録購入団体テーブル、前記登録商品／サービステーブルに入力された前記商品またはサービスと前記販売業者テーブルに入力された前記販売業者と前記登録購入団体テーブルに入力された前記団体とが関連付けられたマッチングテーブル、前記商品またはサービスの売上数量とアフィリエイト率とが関連付けられたアフィリエイトテーブルおよび前記アフィリエイトテーブルに基づいて仲介料を算出するための集計テーブルを含むデータベースを有する販売仲介装置と、を備える職域販売処理システムを用いて行う職域販売処理方法であり、以下の発明特定事項を備える。
前記販売装置において、
商品・サービス情報送信手段によって、販売する前記商品またはサービスに関する情報を前記販売仲介装置に送信する商品・サービス情報送信ステップと、
前記販売仲介装置において、
商品・サービス情報受信手段によって、前記販売装置から送信された前記商品またはサービスに関する情報を受信する商品・サービス情報受信ステップと、
受信した前記商品またはサービスに関する情報を基に行われる、商品・サービス情報入力手段による前記データベースの前記登録商品／サービステーブルへの必要な事項の入力を受け付ける商品・サービス情報入力受付ステップと、
アフィリエイトテーブル作成手段によって、必要な事項を入力された前記商品またはサービスについて、前記データベースの前記アフィリエイトテーブルを作成するアフィリエイトテーブル作成ステップと、
前記購入端末において、
職域販売決定商品・サービスおよび必要なクーポン数情報送信手段によって、職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を前記販売仲介装置に送信する職域販売決定商品・サービスおよび必要なクーポン数情報送信ステップと、
前記販売仲介装置において、
職域販売決定商品・サービスおよび必要なクーポン数情報受信手段によって、前記購入端末から送信された前記職域販売決定商品および必要なクーポン数に関する情報を受信する職域販売決定商品・サービスおよび必要なクーポン数情報受信ステップと、
職域販売決定商品・サービスおよび必要なクーポン数情報送信手段によって、受信した前記職域販売決定商品および必要なクーポン数に関する情報を前記販売端末に送信する職域販売決定商品・サービスおよび必要なクーポン数情報送信ステップと、
前記販売装置において、
職域販売決定商品・サービスおよび必要なクーポン数受信手段によって、前記販売仲介装置から送信された前記職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を受信する職域販売決定商品・サービスおよび必要なクーポン数情報受信ステップと、
クーポンＩＤ・番号作成手段によって、受信した前記職域販売決定商品またはサービスおよび必要なクーポン数に基づいて、前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号を作成するクーポンＩＤ・番号作成ステップと、
クーポンＩＤ・番号情報送信手段によって、作成した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を前記販売仲介装置に送信するクーポンＩＤ・番号情報送信ステップと、
前記販売仲介装置において、
クーポンＩＤ・番号情報受信手段によって、前記販売装置から送信された前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を受信するクーポンＩＤ・番号情報受信ステップと、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を基に行われる、クーポンＩＤ・番号情報入力手段による前記データベースの前記マッチングテーブルへの必要な事項の入力を受け付けるクーポンＩＤ・番号情報入力受付ステップと、
クーポンＩＤ・番号およびアドレス情報送信手段によって、受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報ならびに前記販売装置のアドレス情報を前記購入端末に送信するクーポンＩＤ・番号およびアドレス情報送信ステップと、
前記購入端末において、
クーポンＩＤ・番号およびアドレス情報受信手段によって、前記販売仲介装置から送信された前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報ならびに前記販売装置のアドレス情報を受信するクーポンＩＤ・番号およびアドレス情報受信ステップと、
クーポン情報掲載手段によって、受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を自身のサイトに掲載するクーポン情報掲載ステップと、
購入決定商品・サービス情報送信手段によって、購入決定商品またはサービスに関する情報を前記販売装置に送信する購入決定商品・サービス情報送信ステップと、
前記販売端末において、
購入決定商品・サービス情報受信手段によって、前記購入端末から送信された前記購入決定商品またはサービスに関する情報を受信する購入決定商品・サービス情報受信ステップと、
売上情報送信手段によって、前記商品またはサービスの売上に関する情報を前記販売仲介装置に送信する売上情報送信ステップと、
前記販売仲介装置において、
売上情報受信手段によって、前記販売装置から送信された前記商品またはサービスの売上に関する情報を受信する売上情報受信手段ステップと、
売上集計手段によって、受信した前記商品またはサービスの売上に関する情報に基づいて、前記データベースの前記集計テーブルで指定された集計期間における売上数量および売上金額を集計する売上集計ステップと、
アフィリエイト率決定手段によって、集計した前記売上数量を基に、前記データベースのアフィリエイトテーブルを参照して、適用するアフィリエイト率を決定するアフィリエイト率決定ステップと、
仲介料算出手段によって、決定した前記アフィリエイト率を基に、前記団体が前記販売業者から受け取る仲介料を算出する仲介料算出ステップと、
を含む。 Furthermore, in order to solve the above-mentioned problem, the invention according to claim 3 of the present invention relates to a product or service in sales in which the seller sells the product or service to members of the organization based on the job sales contract. A sales device having a registered sales site, a purchase terminal used by the organization, an intermediary site connected to the sales device and the purchase terminal via a network, and mediating the buying and selling of the product or service, and the Registered product / service table in which information on products or services sold by the seller is input, seller table in which the information on the seller is input, registered purchase organization table in which the information on the organization is input, registered product / service table The merchandise or service entered in the service table, the merchant entered in the merchant table, and the Matching table associated with the group entered in the record / purchase group table, affiliate table associated with the sales volume and affiliate rate of the product or service, and aggregation for calculating the brokerage fee based on the affiliate table A sales area sales processing method performed using a sales area sales processing system including a sales mediating apparatus having a database including a table, and includes the following invention specific matters.
In the sales device,
A product / service information transmission step of transmitting information related to the product or service to be sold to the sales mediation device by a product / service information transmission means;
In the sales intermediary device,
A product / service information receiving step for receiving information on the product or service transmitted from the sales device by a product / service information receiving unit;
A product / service information input receiving step for receiving input of necessary items to the registered product / service table of the database by a product / service information input means, which is performed based on the received information about the product or service;
An affiliate table creating step for creating the affiliate table of the database for the product or service for which necessary items have been input by the affiliate table creating means;
In the purchase terminal,
Occupational sales decided product / service and necessary coupon number information transmission means transmits information related to occupational sales decided product / service and necessary coupon number to the sales intermediary device, and the occupational sales decided product / service and necessary coupon number information transmission Steps,
In the sales intermediary device,
Occupation sales decided product / service and necessary coupon number information receiving means receive the information related to the occupational sale decided product and the necessary coupon number transmitted from the purchase terminal, the occupation sales decided product / service and necessary coupon number information Receiving step;
Occupation sales decided product / service and necessary coupon number information transmission means transmits information about the received occupational sale decided product and necessary coupon number to the sales terminal, and the occupation sales decided product / service and necessary coupon number information transmission Steps,
In the sales device,
Occupational sales determined products / services and necessary coupon number receiving means receive information on the occupational sales determined products or services and the required number of coupons transmitted from the sales intermediary device, and required coupon sales determined products / services and required coupons A number information receiving step;
A coupon ID / number creating step for creating a coupon ID and a coupon number of the job sales determined product or service based on the received job sales determined product or service and the required number of coupons by the coupon ID / number creating means;
A coupon ID / number information transmitting means for transmitting information related to a coupon ID and a coupon number of the created job sales-determined product or service to the sales mediation apparatus by a coupon ID / number information transmitting means;
In the sales intermediary device,
A coupon ID / number information receiving step for receiving information related to a coupon ID and a coupon number of the occupational sales determined product or service transmitted from the sales device by a coupon ID / number information receiving means;
Coupon ID / number for accepting input of necessary items to the matching table of the database by the coupon ID / number information input means, which is performed based on the received coupon ID and coupon number information of the occupational sales determined product or service received An information input acceptance step;
Coupon ID / number and address information transmitting means for transmitting the received coupon ID / coupon number and address information of the sales device to the purchase terminal, and sending the coupon ID / number and address information to the purchase terminal. Steps,
In the purchase terminal,
Coupon ID / number and address for receiving coupon ID and coupon number information of the occupational sales determined product or service transmitted from the sales mediation device and address information of the sales device by the coupon ID / number and address information receiving means An information receiving step;
A coupon information posting step for posting information on the coupon ID and coupon number of the received occupational sales determined product or service on its own site by the coupon information posting means;
A purchase-determined product / service information transmitting step for transmitting information related to a purchase-determined product or service to the sales device by a purchase-determined product / service information transmitting unit;
In the sales terminal,
A purchase decision product / service information receiving step for receiving information on the purchase decision product or service transmitted from the purchase terminal by the purchase decision product / service information receiving means;
Sales information transmission step of transmitting information related to sales of the product or service to the sales mediation device by sales information transmission means;
In the sales intermediary device,
Sales information receiving means step for receiving information related to sales of the goods or services transmitted from the sales device by sales information receiving means;
A sales totaling step of totaling the sales quantity and the sales amount in the totaling period specified in the totaling table of the database based on the received information on the sales of the goods or services by the sales totaling means;
Affiliate rate determination means for determining the affiliate rate to be applied, referring to the affiliate table of the database, based on the aggregated sales volume,
A brokerage fee calculating step for calculating a brokerage fee received by the group from the seller based on the affiliate rate determined by the brokerage fee calculating means;
Including

さらに、上記課題を解決するために、本発明の請求項４の発明は、販売業者が商品またはサービスを、職域販売契約に基づいて、団体の構成員に販売する職域販売において、該商品またはサービスが登録された販売サイトを有する販売装置と、前記団体が使用する購入端末と、前記販売装置および前記購入端末とネットワークを介して接続され、前記商品またはサービスの売買の仲介をする仲介サイトならびに前記販売業者が販売する商品またはサービスの情報が入力された登録商品／サービステーブル、前記販売業者の情報が入力された販売業者テーブル、前記団体の情報が入力された登録購入団体テーブル、前記登録商品／サービステーブルに入力された前記商品またはサービスと前記販売業者テーブルに入力された前記販売業者と前記登録購入団体テーブルに入力された前記団体とが関連付けられたマッチングテーブル、前記商品またはサービスの売上数量とアフィリエイト率とが関連付けられたアフィリエイトテーブルおよび前記アフィリエイトテーブルに基づいて仲介料を算出するための集計テーブルを含むデータベースを有する販売仲介装置を構成するコンピュータに販売仲介処理を実行させるためのプログラムであり、以下の発明特定事項を備える。
前記販売装置から送信された前記商品またはサービスに関する情報を受信する商品・サービス情報受信ステップと、
受信した前記商品またはサービスに関する情報を基に行われる前記データベースの前記登録商品／サービステーブルへの必要な事項の入力を受け付ける商品・サービス情報入力受付ステップと、
必要な事項を入力された前記商品またはサービスについて、前記データベースの前記アフィリエイトテーブルを作成するアフィリエイトテーブル作成ステップと、
前記購入端末から送信された職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を受信する職域販売決定商品・サービスおよび必要なクーポン数情報受信ステップと、
受信した前記職域販売決定商品またはサービスおよび必要なクーポン数に関する情報を前記販売装置に送信する職域販売決定商品・サービスおよび必要なクーポン数情報送信ステップと、
前記販売装置から送信された前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を受信するクーポンＩＤ・番号情報受信ステップと、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報を基に行われる前記データベースの前記マッチングテーブルへの必要な事項の入力を受け付けるクーポンＩＤ・番号情報入力受付ステップと、
受信した前記職域販売決定商品またはサービスのクーポンＩＤおよびクーポン番号に関する情報ならびに前記販売装置のアドレス情報を前記購入端末に送信するクーポンＩＤ・番号およびアドレス情報送信ステップと、
前記販売装置から送信された前記商品またはサービスの売上に関する情報を受信する売上情報受信ステップと、
受信した前記商品またはサービスの売上に関する情報に基づいて、前記データベースの前記集計テーブルで指定された集計期間における売上数量および売上金額を集計する売上集計ステップと、
集計した前記売上数量を基に、前記データベースのアフィリエイトテーブルを参照して、適用するアフィリエイト率を決定するアフィリエイト率決定ステップと、
決定した前記アフィリエイト率を基に、前記団体が前記販売業者から受け取る仲介料を算出する仲介料算出ステップと、
を含む。 Furthermore, in order to solve the above-mentioned problem, the invention according to claim 4 of the present invention relates to a product or service in a sales area where a distributor sells a product or service to a member of an organization based on an occupational sales contract. A sales device having a registered sales site, a purchase terminal used by the organization, an intermediary site connected to the sales device and the purchase terminal via a network, and mediating the buying and selling of the product or service, and the Registered product / service table in which information on products or services sold by the seller is input, seller table in which the information on the seller is input, registered purchase organization table in which the information on the organization is input, registered product / service table The merchandise or service entered in the service table, the merchant entered in the merchant table, and the Matching table associated with the group entered in the record / purchase group table, affiliate table associated with the sales volume and affiliate rate of the product or service, and aggregation for calculating the brokerage fee based on the affiliate table A program for causing a computer constituting a sales mediation apparatus having a database including a table to execute sales mediation processing , and includes the following invention specific matters.
A product / service information receiving step for receiving information on the product or service transmitted from the sales device;
A product / service information input receiving step for receiving input of necessary items to the registered product / service table of the database, which is performed based on the received information about the product or service;
Affiliate table creation step of creating the affiliate table of the database for the goods or services for which necessary items have been input,
The office sales decision product / service and the required coupon number information receiving step for receiving information on the job sale decision product or service and the required number of coupons transmitted from the purchase terminal;
The job sales decision product / service and the required coupon number information transmission step for transmitting the received information on the job sale decision product or service and the required number of coupons to the sales device;
A coupon ID / number information receiving step for receiving information related to a coupon ID and a coupon number of the occupational sales determined product or service transmitted from the sales device;
A coupon ID / number information input receiving step for receiving input of necessary items to the matching table of the database, which is performed based on the received coupon ID and coupon number of the received occupational sales determined product or service;
A coupon ID / number and address information transmitting step for transmitting the received information regarding the coupon ID and coupon number of the occupational sales determined product or service and the address information of the sales device to the purchase terminal;
Sales information receiving step for receiving information related to sales of the goods or services transmitted from the sales device;
Based on the received information on the sales of the product or service, a sales totaling step of totaling the sales quantity and sales amount in the totaling period specified in the totaling table of the database;
An affiliate rate determination step for determining an affiliate rate to be applied with reference to the affiliate table of the database based on the aggregated sales volume;
Based on the determined affiliate rate, an intermediary fee calculating step for calculating an intermediary fee that the group receives from the seller;
Including

さらに、上記課題を解決するために、本発明の請求項５の発明は、請求項４に記載のプログラムを記録したことを特徴とするコンピュータ可読媒体である。 Further, in order to solve the above-mentioned problem, the invention according to claim 5 of the present invention is a computer-readable medium in which the program according to claim 4 is recorded.

本発明の職域販売処理システム、装置、方法、プログラム、コンピュータ可読媒体は、仲介料の支払いが必要な職域販売に好適に適用することができる。 The occupational sales processing system, apparatus, method, program, and computer-readable medium of the present invention can be suitably applied to occupational sales that require payment of an intermediary fee.

また、本発明によって、販売業者が団体に支払うべき仲介料を自動的に算出することが可能となる。また、仲介料の算出方法が団体ごと、商品ごと、または商品の販売数量によって異なったとしても、対応することが可能となり、従来マニュアルで仲介料を計算していた販売業者や団体の福利厚生機関の負担が大きく低減されることになる。 Further, according to the present invention, it becomes possible to automatically calculate the brokerage fee that the distributor should pay to the organization. In addition, even if the method of calculating the brokerage fee varies depending on the group, product, or sales volume of the product, it is possible to cope with it. This greatly reduces the burden.

添付図面を参照して、以下に本発明の好適な１実施形態を説明する。なお、本実施形態において、「販売業者」という用語は、商品およびサービスを提供する会社、組織等を示す。また提供する商品およびサービスを総括して以下「商品」と称する。また、「団体」という用語は、上記「販売業者」から「商品」を購入する会社、団体、組織等を示す。さらに、「構成員」という用語は、上記「団体」を構成するメンバー（会社の社員など）を示す。「福利厚生機関」は、上記「団体」に包含される部門であるが、該「団体」から業務委託を受けた別の団体であってもよい。 A preferred embodiment of the present invention will be described below with reference to the accompanying drawings. In the present embodiment, the term “seller” indicates a company, organization, or the like that provides products and services. The products and services to be provided are collectively referred to as “products” below. The term “group” indicates a company, group, organization, or the like that purchases “goods” from the “seller”. Furthermore, the term “member” indicates a member (such as an employee of a company) that constitutes the “organization”. The “welfare institution” is a department included in the above “organization”, but may be another organization that has been outsourced by the “organization”.

図１は、本発明の１実施形態に係る職域販売処理システムの概略図である。
この図に示すように、本実施形態の職域販売処理システム１００は、販売仲介装置１０と、４つの販売装置２０と、４つの購入端末３０と、ネットワーク４０とを備える。 FIG. 1 is a schematic diagram of a job sales processing system according to an embodiment of the present invention.
As shown in this figure, the occupational area sales processing system 100 of this embodiment includes a sales intermediary device 10, four sales devices 20, four purchase terminals 30, and a network 40.

［職域販売処理システムの構成要素］
図１を参照して、各構成要素について説明する。販売仲介装置１０は、販売業者と団体との間の職域販売を仲介するサイトを有する装置であり、具体的には、販売業者およびその商品と、団体とを結び付ける機能を有する。該装置は職域販売処理システム１００の中で最も重要な要素であり、既存のサーバ、コンピュータなどから構成される。詳細は後述するが、販売業者と、商品と、団体との関連付けを行う手段や、販売業者が団体の福利厚生機関に支払うべき仲介料を算出する手段を備えている。 [Components of Occupational Sales Processing System]
Each component will be described with reference to FIG. The sales intermediary device 10 is a device having a site that mediates sales of occupations between the seller and the organization, and specifically has a function of linking the seller and its products with the organization. The apparatus is the most important element in the occupational sales processing system 100, and includes an existing server, computer, and the like. As will be described in detail later, there are provided means for associating a merchant with a product and a group, and a means for calculating a brokerage fee that the merchant should pay to the welfare organization of the group.

販売装置２０は、販売業者が販売仲介装置１０のサイトにアクセスするために用いられる装置であり、販売する商品が登録された販売サイトが組み込まれている。この装置は既存のサーバ、コンピュータなどから構成される。 The sales apparatus 20 is an apparatus used by a distributor to access the site of the sales mediation apparatus 10, and incorporates a sales site in which products to be sold are registered. This apparatus is composed of an existing server, computer, and the like.

購入端末３０は、団体の構成員または福利厚生機関が販売仲介装置１０のサイトにアクセスするために用いられる端末であり、主に会員登録、職域販売する商品の決定、商品の注文などを行う際に用いられる。この端末は、通信機能を有し、かつウェブの閲覧ソフトが組み込まれた既存のコンピュータ、携帯端末（ＰＤＡ等）、携帯電話などから構成される。 The purchase terminal 30 is a terminal used by a member of a group or a welfare institution to access the site of the sales intermediary device 10, and mainly performs membership registration, determination of products to be sold in the occupation, ordering of products, and the like. Used for. This terminal includes an existing computer having a communication function and incorporating web browsing software, a portable terminal (PDA, etc.), a cellular phone, and the like.

ネットワーク４０は、販売装置２０と販売仲介装置１０との間、および、販売仲介装置１０と購入端末３０との間を接続して、相互に通信可能にするために使用される。また、ネットワーク４０は、各装置または端末と直接接続されるか、あるいは通信回線などを介して間接的に接続される。このネットワークには、インターネット、イーサネット（登録商標）、広域イーサネット（登録商標）などの既存のネット網を用いてよい。また、販売装置２０と購入端末３０との間も相互に直接通信可能である。 The network 40 is used to connect the sales device 20 and the sales mediation device 10 and between the sales mediation device 10 and the purchase terminal 30 so that they can communicate with each other. The network 40 is directly connected to each device or terminal, or indirectly connected via a communication line or the like. For this network, an existing network such as the Internet, Ethernet (registered trademark), wide area Ethernet (registered trademark), or the like may be used. Further, the sales device 20 and the purchase terminal 30 can also directly communicate with each other.

［職域販売処理システムの機能］
図２を参照して、本発明の１実施形態に係る職域販売処理システム１００の機能について説明する。
この図は、職域販売処理システム１００に、販売業者として、商品Ｘを職域販売する業者Ｘと、商品Ｙを販売する業者Ｙと、商品Ｚを販売する業者Ｚと、商品Ｉを販売する業者Ｉと、購入団体として、２０万人の構成員を有する団体Ａと、２万人の構成員を有する団体Ｂと、１０万人の構成員を有する団体Ｃと、５０人の構成員を有する団体Ｄとが登録されている例を示している。 [Functions of occupational sales processing system]
With reference to FIG. 2, the function of the occupational sales processing system 100 which concerns on one Embodiment of this invention is demonstrated.
This figure shows the trader sales processing system 100 as traders, trader X that sells product X, trader Y that sells product Y, trader Z that sells product Z, and trader I that sells product I. And as a purchasing organization, an organization A having 200,000 members, an organization B having 20,000 members, an organization C having 100,000 members, and an organization having 50 members An example is shown in which D is registered.

さらに、販売業者Ｘは商品Ｘを団体Ａに、業者Ｙは商品Ｙを団体ＡおよびＣに、業者Ｚは商品Ｚを団体Ｄに、業者Ｉは商品Ｉを団体Ｄに職域販売するように、販売仲介装置１０のサイトで関連付けされている。この関連情報を基にして、職域販売処理システム１００を介して、複数の業者と団体との間で職域販売が行われる。詳細は後述するが、各販売業者は、販売仲介装置１０を介して登録している団体およびその詳細情報を入手でき、また、各団体の福利厚生機関も、購入する商品および該商品の販売業者の詳細情報を販売仲介装置１０経由で入手することができる。 Furthermore, the seller X sells the product X to the organization A, the dealer Y sells the product Y to the organizations A and C, the dealer Z sells the product Z to the organization D, and the dealer I sells the product I to the organization D. It is associated with the site of the sales mediation apparatus 10. Based on this related information, job sales are performed between a plurality of traders and organizations via the job sales processing system 100. Although details will be described later, each dealer can obtain the registered organization and its detailed information via the sales intermediary device 10, and the welfare organization of each organization also purchases the product to be purchased and the seller of the product. Detailed information can be obtained via the sales mediation apparatus 10.

［販売仲介装置のデータベース］
図３を参照して、販売仲介装置１０が有するデータベースについて説明する。この図に示すように、販売仲介装置１０は、販売業者テーブル１５０と、登録商品／サービステーブル１６０と、アフィリエイトテーブル１７０と、登録購入団体テーブル１８０と、マッチングテーブル１９０と、集計テーブル２００とを含む。以下に図４を参照して個々のテーブルについて詳細に説明する。 [Sales Intermediary Device Database]
With reference to FIG. 3, the database which the sales mediation apparatus 10 has is demonstrated. As shown in this figure, the sales mediating apparatus 10 includes a dealer table 150, a registered product / service table 160, an affiliate table 170, a registered purchase group table 180, a matching table 190, and a tabulation table 200. . The individual tables will be described in detail below with reference to FIG.

（ａ）販売業者テーブル１５０
販売業者テーブル１５０は、商品を提供する販売業者についての情報が登録されたテーブルであり、業者ＩＤ、業者名称、詳細情報、認証ＩＤ、認証パスワードの項目を有している。「業者ＩＤ」とは販売業者を識別するためのＩＤであり、各販売業者に一意に付与される。「詳細情報」とは販売業者に関する詳細情報であり、特に限定しないが、販売業者の正式名称、所在地、連絡先、資本金、代表者名などが含まれる。「認証ＩＤ」および「認証パスワード」は、販売業者が、販売仲介装置の会員用サイトにアクセスするために必要なコードである。 (A) Seller table 150
The seller table 150 is a table in which information about sellers who provide products is registered, and includes items of supplier ID, supplier name, detailed information, authentication ID, and authentication password. The “merchant ID” is an ID for identifying the distributor and is uniquely given to each distributor. “Detailed information” is detailed information about the seller, and includes, but is not limited to, the official name, address, contact information, capital, representative name, etc. of the seller. The “authentication ID” and “authentication password” are codes necessary for the seller to access the member site of the sales intermediary device.

（ｂ）登録商品／サービステーブル１６０
登録商品／サービステーブル１６０は、販売業者が提供する商品についての情報が登録されたテーブルであり、商品／サービスＩＤ、商品／サービス名、詳細情報、初期アフィリエイトテーブルＩＤ、表示開始時期、表示終了時期の項目を有している。「商品／サービスＩＤ」は、商品を識別するためのＩＤであり、各商品に一意に付与される。詳細情報とは商品に関する詳細情報であり、特に限定しないが、商品の標準価格、写真、特徴、ＰＲなどが含まれる。「初期アフィリエイトテーブルＩＤ」は、アフィリエイトテーブル１７０の説明で詳述するが、商品ごとに作成されるアフィリエイトテーブルのうち、デフォルトとして用いるアフィリエイトテーブルのＩＤに相当する。本実施形態では、デフォルトでは、アフィリエイト率を１％に設定するものとする。したがって、初期アフィリエイトテーブルＩＤは、該当する商品のアフィリエイト率１％におけるテーブルのＩＤとなる。また、商品によっては、年末、年始、クリスマス時、または春、夏等、販売時期が限定されるものがある。そのため、商品を提示する期間を特定する「表示開始時期」「表示終了時期」の項目が設けられ、その期間のみ商品の閲覧および購入が可能となる。 (B) Registered product / service table 160
The registered product / service table 160 is a table in which information about products provided by the seller is registered. Product / service ID, product / service name, detailed information, initial affiliate table ID, display start time, display end time Have items. The “product / service ID” is an ID for identifying a product, and is uniquely assigned to each product. The detailed information is detailed information about the product and includes, but is not limited to, a standard price, a photograph, a feature, and PR of the product. The “initial affiliate table ID” is described in detail in the description of the affiliate table 170, and corresponds to the ID of the affiliate table used as a default among the affiliate tables created for each product. In the present embodiment, the affiliate rate is set to 1% by default. Therefore, the initial affiliate table ID is the ID of the table at the affiliate rate of 1% for the corresponding product. Some products have limited sales periods such as the end of the year, the beginning of the year, Christmas time, or spring and summer. Therefore, items of “display start time” and “display end time” for specifying a period for presenting the product are provided, and the product can be browsed and purchased only during that period.

（ｃ）アフィリエイトテーブル１７０
アフィリエイトテーブル１７０には、アフィリエイト率と売上個数との関係が示されており、商品ごとに作成される。アフィリエイト率とは、該当する商品の仲介料を算出するために用いられる要素であり、単位売上金額当たりの仲介料に相当する。例えば、商品Ｗのアフィリエイト率が１％で設定されており、その売上額が１００万円の場合には、商品Ｗの仲介料は１万円となる。
アフィリエイト率は、例えば１〜４％の範囲で、１％ステップで設定され、それぞれにおいて、運用コスト、損益分岐粗利、粗利率、想定売上額、当該商品構成比、提供単価、想定売上個数が設定される。運用コストは、該当する商品を販売するために消費されるコストであり、人件費、販促費、システム維持費などが挙げられ、過去のデータより経験的に求められる。この運用コストは、一般に売上額に応じて上昇する。損益分岐粗利は、該当の製品を販売する際に利益を得られる最低の粗利額である。これは運用コストに応じて決定される。粗利率は、政府発表データを基に決定される。想定売上額は、損益分岐粗利と粗利率によって求められる。当該商品構成比および提供単価は、販売業者によって、商品登録時に与えられる。最後に、以上の数値に用いて想定売上個数が決定される。これにより、各アフィリエイト率と売上個数との関係が求められる。図４（ｃ）の表を参照すると、対象の商品の売り上げ個数が０〜１３３の範囲では、アフィリエイト率は１％、１３４〜２００の範囲で２％、２０１〜２６７の範囲で３％、２６８以上で４％と設定される。それぞれのアフィリエイト率に対してアフィリエイトテーブルＩＤが一意に付与される。 (C) Affiliate table 170
The affiliate table 170 shows the relationship between the affiliate rate and the number of units sold, and is created for each product. The affiliate rate is an element used to calculate the brokerage fee for the corresponding product, and corresponds to the brokerage fee per unit sales amount. For example, when the affiliate rate of the product W is set to 1% and the sales amount is 1 million yen, the brokerage fee for the product W is 10,000 yen.
Affiliate rates are set in 1% steps, for example, in the range of 1 to 4%. In each case, the operating cost, the break-even profit, the gross profit rate, the estimated sales, the product composition ratio, the unit price provided, and the estimated number of sales Is set. The operation cost is a cost consumed to sell the corresponding product, and includes labor costs, sales promotion costs, system maintenance costs, etc., and is empirically obtained from past data. This operating cost generally increases with the amount of sales. Break-even profit margin is the lowest gross profit that can be earned when selling the product. This is determined according to the operating cost. The gross margin is determined based on government-announced data. Estimated sales are calculated based on the break-even margin and the gross margin. The merchandise composition ratio and the unit price are given by the seller at the time of merchandise registration. Finally, the assumed sales volume is determined using the above numerical values. Thereby, the relationship between each affiliate rate and the number of sales is calculated | required. Referring to the table of FIG. 4 (c), the affiliate rate is 1%, 2% in the range of 134 to 200, 3% in the range of 201 to 267, 268 in the range of 0 to 133 sales of the target product. The above is set to 4%. An affiliate table ID is uniquely assigned to each affiliate rate.

（ｄ）登録購入団体テーブル１８０
登録購入団体テーブルは、商品を購入する団体についての情報が登録されたテーブルであり、団体ＩＤ、職域ＩＤ、団体情報、構成員情報、認証ＩＤ、認証パスワードの項目を有する。「団体ＩＤ」は、団体を識別するために用いるものであり、各団体に一意に付与される。「職域ＩＤ」とは、団体を更に細分化して識別する場合に用いられる。例えば、ある団体が複数の支部を有しており、その支部ごとに別々に職域販売を登録、管理する場合に、異なる職域ＩＤを付与する。「団体情報」は団体に関する詳細情報であり、特に限定しないが、団体の正式名称、所在地、代表者名、連絡先等が含まれる。「構成員情報」は、該当の団体の構成員に関する詳細情報であり、特に限定しないが、構成員の人数、男女比、平均年齢等が挙げられる。「認証ＩＤ」および「認証パスワード」は、団体が、販売仲介装置の会員用サイトにアクセスするために必要なコードである。 (D) Registered purchase group table 180
The registered purchase group table is a table in which information on groups that purchase products is registered, and includes items of group ID, occupation ID, group information, member information, authentication ID, and authentication password. The “group ID” is used to identify a group and is uniquely assigned to each group. “Occupation ID” is used when the organization is further subdivided and identified. For example, when a certain organization has a plurality of branches and registers and manages job sales separately for each branch, different job IDs are given. “Group information” is detailed information about the group, and includes, but is not limited to, the official name, location, representative name, and contact information of the group. “Member information” is detailed information regarding the members of the corresponding organization, and is not particularly limited, but includes the number of members, the sex ratio, the average age, and the like. The “authentication ID” and “authentication password” are codes necessary for the organization to access the member site of the sales mediation apparatus.

（ｅ）マッチングテーブル１９０
マッチングテーブルは、販売業者と、商品と、団体と、職域と、が関連付けられたテーブルである。また、商品を販売する場合にクーポンが発行され、「クーポンＩＤ」は職域ごと、あるいは商品ごとに一意に付与され、「クーポン数」は、該当のクーポンにおける発行数を示す。「マッチングＩＤ」は、マッチングテーブルの行ごとに一意に付与される。 (E) Matching table 190
The matching table is a table in which sellers, products, groups, and occupations are associated with each other. In addition, a coupon is issued when a product is sold, a “coupon ID” is uniquely assigned for each job area or for each product, and “coupon number” indicates the number of issues in the corresponding coupon. The “matching ID” is uniquely assigned to each row of the matching table.

（ｆ）集計テーブル２００
集計テーブルは、マッチングＩＤごとに所定の集計期間における売上数量を集計して、商品ごとに適用するアフィリエイト率を決定し、販売業者が団体に支払う仲介料を算出するためのテーブルである。マッチングＩＤ、集計期間、売上数量、初期アフィリエイトテーブルＩＤ、適用アフィリエイトテーブルＩＤ、売上金額、仲介料の項目を有する。
ここで、初期アフィリエイトテーブルの項目は、（ｂ）登録商品／サービステーブル１６０で説明したように、本実施形態ではアフィリエイト率が１％のテーブルのＩＤが選択される。
次に、集計期間における売上数量を基に、適用アフィリエイト率を求める。ここで、アフィリエイト率は、商品ごとに設定される。また、売上数量に対する下限閾値（本実施形態では１０とする）を設けてよい。販売数量がこの下限閾値以下の職域については、初期のアフィリエイト率（１％）をそのまま適用することにする。
図４（ｆ）を参照して詳細に説明する。マッチングＩＤ「Ｍ００１」、「Ｍ００３」、「Ｍ００４」の行では、同一の商品（□□１）が取り扱われているため、この３行についてアフィリエイト率を求める。しかし、「Ｍ００４」では、売上数量が９で、下限閾値１０以下のため、適用アフィリエイトテーブルは、初期アフィリエイトテーブルと同一（□□−１）となる。次に、「Ｍ００１」と「Ｍ００３」の売上数量の合計は１４０であり、この数値を基に、図４（ｃ）のアフィリエイトテーブルよりアフィリエイト率を求めると、２％となる。よって、適用アフィリエイトテーブルＩＤは□□１−２になる。
以上のように求めたアフィリエイト率を基に、マッチングＩＤごとに仲介料を算出する。 (F) Total table 200
The tabulation table is a table for calculating the brokerage fee that the seller pays to the organization by counting the sales quantity in a predetermined tabulation period for each matching ID, determining the affiliate rate to be applied for each product. It has items of matching ID, total period, sales quantity, initial affiliate table ID, application affiliate table ID, sales amount, and brokerage fee.
Here, as the item of the initial affiliate table, as described in (b) Registered product / service table 160, the ID of the table with an affiliate rate of 1% is selected in this embodiment.
Next, an applicable affiliate rate is obtained based on the sales volume in the counting period. Here, the affiliate rate is set for each product. In addition, a lower threshold (10 in this embodiment) for the sales volume may be provided. The initial affiliate rate (1%) is applied as it is to the occupations whose sales quantity is below this lower threshold.
This will be described in detail with reference to FIG. Since the same product (□□ 1) is handled in the rows with matching IDs “M001”, “M003”, and “M004”, the affiliate rate is obtained for these three rows. However, in “M004”, since the sales volume is 9 and the lower threshold is 10 or less, the applicable affiliate table is the same as the initial affiliate table (□□ −1). Next, the total sales volume of “M001” and “M003” is 140, and when the affiliate rate is obtained from the affiliate table of FIG. 4C based on this numerical value, it becomes 2%. Therefore, the application affiliate table ID is □□ 1-2.
Based on the affiliate rate obtained as described above, a brokerage fee is calculated for each matching ID.

上記６つのテーブルを有したデータベースによって、仲介料が算出される。この仲介料は、販売仲介装置１０より、販売装置２０および購入端末３０に通知され、販売業者は団体の福利厚生機関にこの仲介料を支払う必要がある。 The brokerage fee is calculated by the database having the above six tables. This brokerage fee is notified from the sales brokerage device 10 to the sales device 20 and the purchase terminal 30, and the seller needs to pay this brokerage fee to the welfare organization of the organization.

［販売仲介装置の会員用サイトへの登録方法］
販売仲介装置１０の有するサイトは、会員となった業者および団体のみがアクセス可能な限定公開サイトである。そのため、本願の１実施形態に係る職域販売処理システム１００を使用するためには、まず、販売仲介装置１０のサイトに業者および団体が会員登録をする必要がある。そこで、以下に図５を参照して、販売仲介装置１０のサイトへ販売業者および団体が会員登録する手順を説明する。 [Registration method for member site of sales mediation device]
The site possessed by the sales intermediary device 10 is a limited public site that can be accessed only by traders and organizations that have become members. Therefore, in order to use the occupational sales processing system 100 according to the embodiment of the present application, it is first necessary for a trader and an organization to register as a member at the site of the sales mediating apparatus 10. Therefore, with reference to FIG. 5, a procedure for a merchant and group to register as a member at the site of the sales mediating apparatus 10 will be described below.

まず、販売業者／団体が、販売装置２０／購入端末３０を介して、販売仲介装置１０の公開（非会員用）サイトにアクセスし、そのサイトの会員登録フォームに所定の情報を入力することで、会員登録を申し込む（Ｓ１）。販売仲介装置１０は、その申し込みを受け付け（Ｓ２）、申し込みを受け付けたことを販売装置２０／購入端末３０に通知する（Ｓ３）。次に、販売仲介装置１０のサイトの管理者は、申し込みを受けた販売業者／団体の審査を行う（Ｓ４）。審査内容については、特に限定しないが、職域販売契約時に行われる通常の審査内容であってよい。審査が不合格の場合には、不合格を通知する（Ｓ５）。一方、合格の場合には、合格を通知し（Ｓ７）、契約を結ぶ（Ｓ９）。契約の内容については、特に限定しないが、職域販売における通常の契約内容であってよい。契約後、その販売業者／団体が新たに会員になったことを、販売仲介装置１０はサイト上などで他の会員に通知する（Ｓ１０）。最後に販売仲介装置１０は、契約した販売業者／団体に認証キーを発行し（Ｓ１１）、販売業者／団体はその認証キーを入力することで、会員専用サイトにアクセスすることが可能となる。最後に、販売仲介装置１０は、会員となった販売装置２０／購入端末３０の情報を元に、自身のデータベースの販売業者テーブル１５０または登録購入団体テーブル１８０の各項目に必要事項を振り分ける（Ｓ１２）。
以上の方法で、販売業者および団体の会員登録が行われる。 First, the seller / organization accesses the public (non-member) site of the sales intermediary device 10 via the sales device 20 / purchase terminal 30 and inputs predetermined information into the member registration form of the site. Apply for membership registration (S1). The sales intermediary device 10 accepts the application (S2), and notifies the sales device 20 / purchase terminal 30 that the application has been accepted (S3). Next, the administrator of the site of the sales mediating apparatus 10 examines the seller / organization that has received the application (S4). The examination content is not particularly limited, but may be the usual examination content performed at the time of occupational sales contract. If the examination fails, a failure is notified (S5). On the other hand, in the case of a pass, the pass is notified (S7) and a contract is concluded (S9). The content of the contract is not particularly limited, but it may be normal contract content in occupational sales. After the contract, the sales intermediary device 10 notifies other members on the site that the seller / organization has become a new member (S10). Finally, the sales intermediary device 10 issues an authentication key to the contracted distributor / organization (S11), and the distributor / organization inputs the authentication key, thereby making it possible to access the member-dedicated site. Finally, the sales intermediary device 10 allocates necessary items to each item of the seller table 150 or registered purchase group table 180 of its own database based on the information of the sales device 20 / purchase terminal 30 that has become a member (S12). ).
Member registration of distributors and organizations is performed in the manner described above.

従来、販売業者または団体が職域販売を行う場合、それぞれ相手を探し、その相手が信用できるかどうかを審査し、審査結果が合格の場合に職域販売契約を結ぶ。これらのプロセスは独自に行わねばならないため、非常に手間のかかる作業となる。しかし、本発明の職域販売処理システムには、職域販売を希望する販売業者および団体が既に登録されているため、相手先を比較的容易に見つけることができる。また、登録されている販売業者及び団体は、既に販売仲介装置１０のサイトの管理者による審査を合格しているため、独自の審査を省略するか、簡略化させることができる。さらに、販売仲介装置１０のデータベースより販売業者、商品、団体に関する様々な情報を入手できるため、相手先の決定や、審査を行う場合に有用でき、従来手間の掛った作業が簡略化され、販売業者、団体の双方の負荷が大きく低減される。 Conventionally, when a dealer or an organization sells occupations, each partner is searched for, and whether or not the other party can be trusted is examined. If the examination result is passed, an occupational sales contract is concluded. Since these processes must be performed independently, they are very laborious. However, in the occupational area sales processing system according to the present invention, since the dealers and organizations that desire the occupational area sales are already registered, it is relatively easy to find the other party. In addition, since the registered distributors and organizations have already passed the examination by the administrator of the site of the sales mediating apparatus 10, the original examination can be omitted or simplified. Furthermore, since various information regarding the seller, products, and groups can be obtained from the database of the sales intermediary device 10, it can be useful when determining the destination or conducting an examination, and the conventional labor-intensive work is simplified and sales are facilitated. The burden on both traders and organizations is greatly reduced.

［職域販売処理方法］
上記のような手順で会員登録を行った販売業者と団体との間で、本発明の１実施形態に係る職域販売処理システム１００を用いて職域販売を行う。図６を参照して、本実施形態に係る職域販売処理方法について説明する。 [Job sales processing method]
Job sales are performed between the seller and the group that have registered the membership in the above-described procedure using the job sales processing system 100 according to the embodiment of the present invention. With reference to FIG. 6, the occupational sales processing method according to the present embodiment will be described.

まず、販売仲介装置１０の会員用サイトに、販売装置２０がアクセスする。そして、職域販売したい商品を登録するために、該商品に対する詳細情報を販売仲介装置１０のサイトに入力する（Ｓ１）。この入力は、例えば、販売装置２０内のサイトに登録されている商品に関する情報を、販売仲介装置１０に送ることで行われてよい。 First, the sales device 20 accesses the member site of the sales mediation device 10. Then, in order to register the product to be sold in the occupational area, detailed information on the product is input to the site of the sales mediation apparatus 10 (S1). This input may be performed, for example, by sending information related to a product registered in a site in the sales apparatus 20 to the sales mediation apparatus 10.

販売装置２０からの商品登録は販売仲介装置１０で受け付けられ（Ｓ２）、これを受けて、販売仲介装置１０は、この情報を基に、データベースの登録商品／サービステーブル１６０の各項目に必要な事項を入力する（Ｓ３）。次いで、アフィリエイトテーブル１７０を商品ごとに作成する（Ｓ４）。なお、本実施形態では初期アフィリエイト率は１％と設定されることに留意されたい。以上の手順によって、登録された商品は購入端末３０で閲覧可能となる。 The merchandise registration from the sales device 20 is accepted by the sales mediation device 10 (S2). Upon receipt of this, the sales mediation device 10 is necessary for each item of the registered merchandise / service table 160 in the database based on this information. Items are input (S3). Next, an affiliate table 170 is created for each product (S4). Note that in this embodiment, the initial affiliate rate is set to 1%. By the above procedure, the registered product can be viewed on the purchase terminal 30.

次に、団体の福利厚生機関が購入端末３０を介して、販売仲介装置１０の会員用サイトにアクセスして、登録された商品を閲覧および検索を行う（Ｓ５）。その際には、データベース技術で用いられる公知の検索手段を用いて、団体および商品を閲覧、検索してよい。例えば、商品カテゴリーごと、価格順、売り上げ順に閲覧や検索してよい。また、特定の商品やその販売業者の詳細情報を販売仲介装置１０のデータベースの登録商品／サービステーブル１６０や販売業者テーブル１５０から入手して、商品決定の参考にしてよい。そして、職域販売する商品を決定し、決定した商品と必要なクーポン数を通知する（Ｓ６）。販売仲介装置１０はこれらの情報を受け取ると、メール等で販売装置２０に転送する（Ｓ７）。 Next, the welfare organization of the organization accesses the member site of the sales intermediary device 10 via the purchase terminal 30, and browses and searches the registered products (S5). In that case, organizations and products may be browsed and searched using known search means used in database technology. For example, browsing and searching may be performed for each product category, in order of price, and in order of sales. Further, the detailed information of a specific product and its distributor may be obtained from the registered product / service table 160 and the seller table 150 in the database of the sales mediating apparatus 10 and used as a reference for product determination. Then, the product to be sold in the occupation is determined, and the determined product and the required number of coupons are notified (S6). Upon receiving these pieces of information, the sales intermediary device 10 transfers the information to the sales device 20 by e-mail or the like (S7).

この商品決定およびクーポン情報を受けて（Ｓ８）、販売装置２０は、該商品のクーポンＩＤおよびクーポン番号を作成し、販売仲介装置１０に送付する（Ｓ９）。販売仲介装置１０は、この情報を基に自身のマッチングテーブル１９０に必要な事項を記載して、メール等で購入端末３０に該情報および販売装置２０のアドレス情報を送る（Ｓ１０）。なお、このクーポン情報は、商品購入の際に必要となる情報であり、この情報によって商品の売上が計算される。購入端末３０は、この転送されたクーポンに関する情報を受け取り、自身のサイトに掲載する（Ｓ１１）。 Upon receiving this product determination and coupon information (S8), the sales device 20 creates a coupon ID and a coupon number for the product and sends them to the sales mediation device 10 (S9). Based on this information, the sales mediating apparatus 10 describes necessary items in its own matching table 190, and sends the information and address information of the sales apparatus 20 to the purchase terminal 30 by e-mail or the like (S10). The coupon information is information necessary for purchasing a product, and the sales of the product are calculated based on this information. The purchase terminal 30 receives the information regarding the transferred coupon and posts it on its own site (S11).

次いで、その団体の構成員が購入端末３０で決定された商品を閲覧し、必要に応じてその詳細情報を入手する。そして、構成員は、購入したい商品を決定したら、購入端末３０から販売装置２０にその商品を注文する（Ｓ１２）。販売装置２０が注文を受けると（Ｓ１３）、注文を受領したことが購入端末３０へ通知される。これによって、商品の発注は完了する。 Next, a member of the group browses the product determined by the purchase terminal 30 and obtains detailed information as necessary. Then, when the member determines a product to be purchased, the member orders the product from the purchase terminal 30 to the sales apparatus 20 (S12). When the sales apparatus 20 receives an order (S13), the purchase terminal 30 is notified that the order has been received. This completes the ordering of the product.

その後、販売仲介装置１０は、データベースの集計テーブル２００で指定された集計期間における売上数量および売上金額を集計する。その際に、販売仲介装置１０は、販売装置２０に対して商品の売り上げに関する情報をクーポンＩＤごとに問い合わせ、販売装置２０はそれに応じて該情報を送付する（Ｓ１４）。そして、集計した売上数量を基に、アフィリエイトテーブル１７０を参照して、適用するアフィリエイト率を決定する（Ｓ１５）。そのアフィリエイト率を基に、販売業者が団体の福利厚生機関に支払うべき仲介料を算出する（Ｓ１６）。最後に、販売仲介装置１０はその算出した仲介料を販売装置２０と購入端末３０とに通知する（Ｓ１８、Ｓ１９）。 Thereafter, the sales intermediary device 10 totals the sales quantity and the sales amount in the total period specified in the total table 200 of the database. At that time, the sales intermediary device 10 inquires of the sales device 20 about the sales of the product for each coupon ID, and the sales device 20 sends the information accordingly (S14). Then, based on the total sales volume, the affiliate table 170 is referred to and the affiliate rate to be applied is determined (S15). Based on the affiliate rate, a brokerage fee to be paid by the distributor to the welfare organization of the group is calculated (S16). Finally, the sales intermediary device 10 notifies the calculated mediation fee to the sales device 20 and the purchase terminal 30 (S18, S19).

以上、本発明の１実施形態に係る職域販売処理システムおよび方法を説明したが、これらは例示的なものに過ぎず、様々な変更や変形が可能である。例えば、図１および図２の職域販売処理システム１００では、それぞれ４つの販売装置２０および購入端末３０が示されているが、本発明の販売装置および購入端末の数は、それに限定されるものではなく、任意の数であってよい。また、図２では、１つの販売装置２０から、１つの商品が提供されているが、本発明はそれに限定されるものではなく、１つの販売装置から複数の商品が提供されてもよい。 Although the job sales processing system and method according to the embodiment of the present invention have been described above, these are merely exemplary, and various changes and modifications can be made. For example, in the work area sales processing system 100 of FIGS. 1 and 2, four sales devices 20 and purchase terminals 30 are shown, respectively, but the numbers of the sales devices and purchase terminals of the present invention are not limited thereto. There may be any number. In FIG. 2, one product is provided from one sales device 20, but the present invention is not limited thereto, and a plurality of products may be provided from one sales device.

また、本実施形態のアフィリエイトテーブル１７０で設定されるアフィリエイト率と想定売上個数の関係は、販売業者と、販売仲介装置１０の管理者と、団体との間に結ばれる職域販売契約に基づくものであり、任意に設定してよく、特定の関係に限定されるものではない。
さらに、本実施形態では、初期アフィリエイト率を１％と設定したが、本発明はこれに限定されるものではなく、任意の数値を用いてよい。同様に、アフィリエイトテーブル１７０で設定されるアフィリエイト率は、本実施形態では１〜４％で１％ステップとしているが、本発明はこれに限定されるものではなく、任意の数値で設定してよい。 In addition, the relationship between the affiliate rate and the assumed sales quantity set in the affiliate table 170 of the present embodiment is based on an occupational sales contract established between the seller, the administrator of the sales mediating apparatus 10, and the group. Yes, it may be set arbitrarily and is not limited to a specific relationship.
Furthermore, in this embodiment, the initial affiliate rate is set to 1%, but the present invention is not limited to this, and any numerical value may be used. Similarly, the affiliate rate set in the affiliate table 170 is 1 to 4% and 1% step in the present embodiment, but the present invention is not limited to this and may be set with an arbitrary numerical value. .

本実施形態において、アフィリエイト率は、商品の売上個数と関連付けがされているが、本発明はこれに限定するものではない。代替え的に、アフィリエイト率を、商品の想定売上額と関連付けさせてもよい。その場合には、仲介料は商品の売上額に応じて変化することになる。 In this embodiment, the affiliate rate is associated with the number of products sold, but the present invention is not limited to this. Alternatively, the affiliate rate may be associated with the estimated sales amount of the product. In that case, the brokerage fee changes according to the sales amount of the product.

本発明の１実施形態の係る販売仲介装置１０のデータベースは、６つのテーブルから構成されているが、更に、データを分析するための分析テーブルを含んでもよい。この分析テーブルには、登録購入団体テーブル１８０の情報を用いて、例えば、男女別、年齢別に商品の売上数を集計したデータが振り分けられる。そして、この集計データ統計処理を施し、グラフなどでビジュアル化して、販売業者に提供することができる。これらのデータは、販売業者にとって、販売を促進する上で貴重な市場データとなり得る。さらに、商品の売上数量を基に、商品売り上げランキングを作成して、団体に提供してもよい。 The database of the sales mediation apparatus 10 according to one embodiment of the present invention is composed of six tables, but may further include an analysis table for analyzing data. In this analysis table, for example, data obtained by tabulating the number of products sold by gender and age is sorted using the information of the registered purchase group table 180. Then, the statistical data statistical processing is performed and visualized with a graph or the like, which can be provided to the seller. These data can be valuable market data for merchants in promoting sales. Further, a product sales ranking may be created based on the sales volume of the product and provided to the organization.

本発明の１実施形態では、仲介料は、販売業者から団体の福利厚生機関に支払われるものと説明したが、本発明はそれに限定されるものではない。代替え的に、仲介料の一部が、仲介サイトの管理、運営費として販売仲介装置１０の管理者に支払われてもよい。その場合、仲介料は、団体の福利厚生機関への支払額と、販売仲介装置１０への支払額と、に別々に集計することが好ましい。 In one embodiment of the present invention, it has been described that the brokerage fee is paid from the distributor to the welfare organization of the organization, but the present invention is not limited thereto. Alternatively, a part of the brokerage fee may be paid to the manager of the sales brokerage apparatus 10 as a management and operation cost of the brokerage site. In that case, it is preferable that the brokerage fee is separately calculated for the payment amount to the welfare organization of the group and the payment amount to the sales brokerage device 10.

上述した本発明の１実施形態に係る職域販売処理方法は、プログラムとして実装されることが好ましい。その場合には、プログラムはメインのサーバから各販売仲介装置１０へダウンロードされるか、コンピュータ可読媒体の形態で分配されることが好ましい。コンピュータ可読媒体の例としては、ＣＤ−ＲＯＭ、磁気テープ、フレキシブルディスク、光学式データ保存装置などが挙げられる。 The above-described job sales processing method according to the embodiment of the present invention is preferably implemented as a program. In that case, the program is preferably downloaded from the main server to each sales mediation apparatus 10 or distributed in the form of a computer-readable medium. Examples of the computer-readable medium include a CD-ROM, a magnetic tape, a flexible disk, and an optical data storage device.

本発明の１実施形態に係る職域販売処理システムの構成を示す図である。It is a figure which shows the structure of the occupation sales processing system which concerns on one Embodiment of this invention. 本発明の１実施形態に係る職域販売処理システムの機能を示す図である。It is a figure which shows the function of the occupation sales processing system which concerns on one Embodiment of this invention. 本発明の１実施形態に係る販売仲介装置のデータベースの構造を示す図である。It is a figure which shows the structure of the database of the sales mediation apparatus which concerns on one Embodiment of this invention. 本発明の１実施形態に係る販売仲介装置のデータベースを構成するテーブルの詳細構造を示す図である。It is a figure which shows the detailed structure of the table which comprises the database of the sales mediation apparatus which concerns on one Embodiment of this invention. 本発明の１実施形態に係る職域販売処理システムに会員登録する手順を示すフローチャートである。It is a flowchart which shows the procedure which registers as a member in the occupation sales processing system which concerns on one Embodiment of this invention. 本発明の１実施形態に係る職域販売処理方法を示すフローチャートである。It is a flowchart which shows the occupation sales processing method which concerns on one Embodiment of this invention.

１００職域販売処理システム
１０販売仲介装置
２０販売装置
３０購入端末
４０ネットワーク
100 Job Sales Processing System 10 Sales Intermediary Device 20 Sales Device 30 Purchase Terminal 40 Network

Claims

An occupational sales processing system used by a distributor to sell goods or services to members of an organization under an occupational sales agreement,
A sales device having a sales site where the goods or services to be sold are registered;
And the purchase terminal to be used for the organization to order the registered goods or services,
A sales intermediary device having an intermediary site connected to the sales device and the purchase terminal via a network and mediating the buying and selling of the goods or services,
The sales device is:
Product / service information transmitting means for transmitting information related to the product or service to be sold to the sales mediating device;
A job sales decision product / service and a required coupon number information receiving means for receiving information on the job sale decision product or service and the required number of coupons transmitted from the sales intermediary device;
Coupon ID / number creating means for creating a coupon ID and a coupon number of the job sales determined product or service based on the received information regarding the job sales determined product or service and the required number of coupons;
Coupon ID / number information transmitting means for transmitting information related to the coupon ID and coupon number of the created occupational sales determined product or service to the sales mediating device;
Purchase decision product / service information receiving means for receiving information related to the purchase decision product or service transmitted from the purchase terminal;
Sales information transmitting means for transmitting information related to sales of the product or service to the sales mediating device;
Have
The purchase terminal is
A job sales decision product / service and necessary coupon number information transmission means for transmitting information related to the job sales product or service and the required number of coupons to the sales intermediary device;
Coupon ID / number and address information receiving means for receiving information related to coupon ID and coupon number of the occupational sales determined commodity or service transmitted from the sales intermediary device and address information of the sales device;
Coupon information posting means for posting information on coupon ID and coupon number of the received occupational sales determined product or service on its own site;
Purchase decision product / service information transmission means for sending information related to the purchase decision product or service to the sales device;
Have
The sales intermediary device is:
Registered product / service table into which the product or service information has been input, seller table to which the seller information has been input, registered purchase organization table into which the organization information has been input, input to the registered product / service table A matching table in which the product or service entered, the seller input in the seller table and the organization input in the registered purchase organization table are associated, and the sales quantity and affiliate rate of the product or service A database including an associated affiliate table and a summary table for calculating a brokerage fee based on the affiliate table;
Product / service information receiving means for receiving information on the product or service transmitted from the selling device;
Product / service information input means for inputting necessary items to the registered product / service table of the database based on the received information about the product or service;
Affiliate table creating means for creating the affiliate table of the database for the goods or services for which necessary items have been input,
The office sales decision product / service and the required coupon number information receiving means for receiving the information related to the job sale decision product or service and the required number of coupons transmitted from the purchase terminal;
The occupational sales decision product / service and the required coupon number information transmission means for transmitting the received information related to the occupational sale decision product or service and the required number of coupons to the sales device;
Coupon ID / number information receiving means for receiving information on coupon ID and coupon number of the occupational sales determined product or service transmitted from the sales device;
Coupon ID / number information input means for inputting necessary items to the matching table of the database, based on the received information on the coupon ID and coupon number of the occupational sales determined product or service received;
Coupon ID / number and address information transmitting means for transmitting the received information on the coupon ID and coupon number of the occupational sales determined product or service and the address information of the sales device to the purchase terminal;
Sales information receiving means for receiving information related to sales of the goods or services transmitted from the sales device;
Sales aggregation means for aggregating the sales quantity and the sales amount in the aggregation period specified in the aggregation table of the database based on the received information on the sales of the goods or services;
Affiliate rate determining means for determining an affiliate rate to be applied with reference to the affiliate table of the database based on the aggregated sales volume;
Based on the determined the affiliate rate, worksite sales processing system, characterized by chromatic and commission fee calculation means, a for calculating a commission fee which the organization receives from the merchant.

In occupational sales in which a distributor sells goods or services to members of an organization based on an occupational sales contract, a sales apparatus having a sales site in which the products or services are registered, and the organization sells the goods or services A sales intermediary device having an intermediary site connected to a purchase terminal used for ordering via a network and mediating the buying and selling of the goods or services,
Registered product / service table in which information on products or services sold by the seller is input, seller table in which information on the seller is input, registered purchase organization table in which information on the organization is input, and the registered products / Matching table in which the product or service entered in the service table, the seller entered in the seller table and the organization entered in the registered purchase organization table are associated, the sales quantity of the product or service A database including an affiliate table in which an affiliate rate is associated and a summary table for calculating a brokerage fee based on the affiliate table;
Product / service information receiving means for receiving information on the product or service transmitted from the selling device;

Product / service information input means for inputting necessary items to the registered product / service table of the database based on the received information about the product or service;
Affiliate table creating means for creating the affiliate table of the database for the goods or services for which necessary items have been input,
The office sales decision product / service and the required coupon number information receiving means for receiving information on the job sale decision product or service and the required number of coupons transmitted from the purchase terminal;
The occupational sales decision product / service and the required coupon number information transmission means for transmitting the received information related to the occupational sale decision product or service and the required number of coupons to the sales device;
Coupon ID / number information receiving means for receiving information on coupon ID and coupon number of the occupational sales determined product or service transmitted from the sales device;
Coupon ID / number information input means for inputting necessary items to the matching table of the database, based on the received information on the coupon ID and coupon number of the occupational sales determined product or service received;
Coupon ID / number and address information transmitting means for transmitting the received information on the coupon ID and coupon number of the occupational sales determined product or service and the address information of the sales device to the purchase terminal;
Sales information receiving means for receiving information related to sales of the goods or services transmitted from the sales device;
Sales aggregation means for aggregating the sales quantity and the sales amount in the aggregation period specified in the aggregation table of the database based on the received information on the sales of the goods or services;
Affiliate rate determining means for determining an affiliate rate to be applied with reference to the affiliate table of the database based on the aggregated sales volume;
Based on the determined the affiliate rate, sales mediation apparatus the organization characterized by chromatic and a commission fee calculation means for calculating a commission fee received from the merchant.

In the occupational sales in which the seller sells the goods or services to the members of the organization based on the occupational sales contract, the sales apparatus having a sales site where the goods or services are registered;
The purchase terminal used by the organization, the sales device and the purchase terminal are connected via a network, and the brokerage site that mediates the buying and selling of the product or service and the information of the product or service sold by the seller are input. Registered merchandise / service table, merchant table into which information on the merchant is entered, registered purchase group table into which information on the group is entered, the merchandise or service entered into the registered merchandise / service table, and the A matching table in which the seller input in the seller table and the group input in the registered purchase group table are associated with each other, an affiliate table in which the sales quantity of the product or service and the affiliate rate are associated, and the affiliate Brokerage fee based on table A worksite sales processing method using the worksite sales processing system comprising a sales mediation apparatus, a having a database containing a summary table for output,
In the sales device,
A product / service information transmission step of transmitting information related to the product or service to be sold to the sales mediation device by a product / service information transmission means;
In the sales intermediary device,
A product / service information receiving step for receiving information on the product or service transmitted from the sales device by a product / service information receiving unit;
A product / service information input receiving step for receiving input of necessary items to the registered product / service table of the database by a product / service information input means, which is performed based on the received information about the product or service;
An affiliate table creating step for creating the affiliate table of the database for the product or service for which necessary items have been input by the affiliate table creating means;
In the purchase terminal,
Occupational sales decided product / service and necessary coupon number information transmission means transmits information related to occupational sales decided product / service and necessary coupon number to the sales intermediary device, and the occupational sales decided product / service and necessary coupon number information transmission Steps,
In the sales intermediary device,
Occupation sales decided product / service and necessary coupon number information receiving means receive the information related to the occupational sale decided product and the necessary coupon number transmitted from the purchase terminal, the occupation sales decided product / service and necessary coupon number information Receiving step;
Occupation sales decided product / service and necessary coupon number information transmission means transmits information about the received occupational sale decided product and necessary coupon number to the sales terminal, and the occupation sales decided product / service and necessary coupon number information transmission Steps,
In the sales device,
Occupational sales determined products / services and necessary coupon number receiving means receive information on the occupational sales determined products or services and the required number of coupons transmitted from the sales intermediary device, and required coupon sales determined products / services and required coupons A number information receiving step;
A coupon ID / number creating step for creating a coupon ID and a coupon number of the job sales determined product or service based on the received job sales determined product or service and the required number of coupons by the coupon ID / number creating means;
A coupon ID / number information transmitting means for transmitting information related to a coupon ID and a coupon number of the created job sales-determined product or service to the sales mediation apparatus by a coupon ID / number information transmitting means;
In the sales intermediary device,
A coupon ID / number information receiving step for receiving information related to a coupon ID and a coupon number of the occupational sales determined product or service transmitted from the sales device by a coupon ID / number information receiving means;
Coupon ID / number for accepting input of necessary items to the matching table of the database by the coupon ID / number information input means, which is performed based on the received coupon ID and coupon number information of the occupational sales determined product or service received An information input acceptance step;
Coupon ID / number and address information transmitting means for transmitting the received coupon ID / coupon number and address information of the sales device to the purchase terminal, and sending the coupon ID / number and address information to the purchase terminal. Steps,
In the purchase terminal,
Coupon ID / number and address for receiving coupon ID and coupon number information of the occupational sales determined product or service transmitted from the sales mediation device and address information of the sales device by the coupon ID / number and address information receiving means An information receiving step;
A coupon information posting step for posting information on the coupon ID and coupon number of the received occupational sales determined product or service on its own site by the coupon information posting means;
A purchase-determined product / service information transmitting step for transmitting information related to a purchase-determined product or service to the sales device by a purchase-determined product / service information transmitting unit;
In the sales terminal,
A purchase decision product / service information receiving step for receiving information on the purchase decision product or service transmitted from the purchase terminal by the purchase decision product / service information receiving means;
Sales information transmission step of transmitting information related to sales of the product or service to the sales mediation device by sales information transmission means;
In the sales intermediary device,
Sales information receiving means step for receiving information related to sales of the goods or services transmitted from the sales device by sales information receiving means;
A sales totaling step of totaling the sales quantity and the sales amount in the totaling period specified in the totaling table of the database based on the received information on the sales of the goods or services by the sales totaling means;
Affiliate rate determination means for determining the affiliate rate to be applied, referring to the affiliate table of the database, based on the aggregated sales volume,
A brokerage fee calculating step for calculating a brokerage fee received by the group from the seller based on the affiliate rate determined by the brokerage fee calculating means;
An occupational sales processing method characterized by including :

In the occupational sales in which the seller sells products or services to members of the organization based on the occupational sales contract, a sales device having a sales site where the products or services are registered, and a purchase terminal used by the organization An intermediary site that is connected to the sales device and the purchase terminal via a network and mediates the buying and selling of the product or service, and a registered product / service table into which information on the product or service sold by the seller is input, The seller table in which the information on the seller is input, the registered purchase organization table in which the information on the organization is input, the product or service input in the registered product / service table and the seller table. The merchant associated with the seller and the group entered in the registered purchase group table. Sales to a computer constituting a sales intermediary device having a database including a charting table, an affiliate table in which the sales volume of the product or service and an affiliate rate are associated, and a summary table for calculating an intermediary fee based on the affiliate table A program for executing mediation processing ,
A product / service information receiving step for receiving information on the product or service transmitted from the sales device;
A product / service information input receiving step for receiving input of necessary items to the registered product / service table of the database, which is performed based on the received information about the product or service;
Affiliate table creation step of creating the affiliate table of the database for the goods or services for which necessary items have been input,
The office sales decision product / service and the required coupon number information receiving step for receiving information on the job sale decision product or service and the required number of coupons transmitted from the purchase terminal;
The job sales decision product / service and the required coupon number information transmission step for transmitting the received information on the job sale decision product or service and the required number of coupons to the sales device;
A coupon ID / number information receiving step for receiving information related to a coupon ID and a coupon number of the occupational sales determined product or service transmitted from the sales device;
A coupon ID / number information input receiving step for receiving input of necessary items to the matching table of the database, which is performed based on the received coupon ID and coupon number of the received occupational sales determined product or service;
A coupon ID / number and address information transmitting step for transmitting the received information regarding the coupon ID and coupon number of the occupational sales determined product or service and the address information of the sales device to the purchase terminal;
Sales information receiving step for receiving information related to sales of the goods or services transmitted from the sales device;
Based on the received information on the sales of the product or service, a sales totaling step of totaling the sales quantity and sales amount in the totaling period specified in the totaling table of the database;
An affiliate rate determination step for determining an affiliate rate to be applied with reference to the affiliate table of the database based on the aggregated sales volume;
Based on the determined affiliate rate, an intermediary fee calculating step for calculating an intermediary fee that the group receives from the seller;
The program characterized by including.

A computer-readable medium having recorded thereon the program according to claim 4 .