JP7205159B2 - Sales management system, sales management method, and computer program for sales management - Google Patents

Description

The present invention relates to a sales management system, a sales management method, and a computer program for sales management for managing sales of merchandise.

For example, as a conventional sales management system for managing sales of merchandise, a system that can be realized by a client server system has been proposed (see, for example, Patent Document 1).

JP 2018-514839 A

However, the above-described conventional system is mainly configured to be able to find correspondence between a plurality of clients and servers. It was not something that could be confirmed.

The present invention has been made to solve such problems. The purpose is to provide a computer program for sales management.

A first aspect of the present invention is
A sales management system for managing sales of merchandise,
a product information management means for managing product information on a plurality of types of products that can be sold;
product designation means for designating one of the plurality of types of products;
a trading information management means for acquiring, from the product information management means, product information relating to the product specified via the product specifying means, and managing the sale information relating to the sale corresponding to the product in association with the product information;
and display means capable of displaying a plurality of product information in a topology expression format centering on a selling entity, and displaying the trading information corresponding to each product information.

According to this, by displaying the sales information corresponding to each of a plurality of product information in a topology expression format, it is possible to visually check the sales management status for each product in an easy-to-view manner.

As a preferred embodiment of the first aspect of the present invention,
The multiple types of products include transit products purchased via one or more intermediate traders,
The display means can display the one or more intermediate traders including the purchaser centering on the seller in a topology expression format, and can display the trade information corresponding to each intermediate trader. characterized by being

According to this, it is possible to visually confirm the purchase management status for each one or a plurality of intermediate traders, including the purchase source, in a visually easy-to-see manner.

As another preferred embodiment of the first aspect of the present invention,
The display means is characterized in that it can display a route in a topology representation format according to the presence or absence of the trading information for each of the product information.

According to this, the route can be displayed/hidden according to the presence/absence of trading information for each item information, so that it is possible to distinguish already sold items from unsold items at a glance.

As another preferred embodiment of the first aspect of the present invention,
The display means is characterized in that it can display the length of the route in a topology representation format according to the number of trades included in the trade information for each item of the commodity information.

According to this, since the length of the route can be displayed differently according to the number of trades included in the trade information for each piece of merchandise information, it is possible to distinguish at a glance the merchandise with a large number of trades and the merchandise with a small number of trades. can.

A second aspect of the present invention is
A method performed by a sales management system for managing sales of merchandise, the method comprising:
a product information management step for managing product information about a plurality of types of products that can be sold;
a product designation step for designating one of the plurality of types of products;
a trading information management step of acquiring product information related to the product specified through the product specifying step, and managing the trading information related to trading corresponding to the product in association with the product information;
and a display step for displaying the trading information corresponding to each piece of product information, wherein the product information can be displayed in a topology expression format centering on the selling entity.

According to this, by displaying the sales information corresponding to each of a plurality of product information in a topology expression format, it is possible to visually check the sales management status for each product in an easy-to-view manner.

A computer program for sales management for managing sales of merchandise,
the computer,
a product information management means for managing product information on a plurality of types of products that can be sold;
product designation means for designating one of the plurality of types of products;
a trading information management means for acquiring, from the product information management means, product information relating to the product specified via the product specifying means, and managing the sale information relating to the sale corresponding to the product in association with the product information;
display means capable of displaying a plurality of product information centered on a sales entity in a topology expression format, and for displaying the trading information corresponding to each product information;
It is characterized by functioning as

According to this, the sales management system according to the first aspect can be realized by a computer.

According to the present invention, it is possible to confirm the status of sales management for each of a plurality of types of commodities in a visually easy-to-see manner.

It is a block diagram showing the hardware constitutions of the computer which constitutes the sales management system concerning the embodiment of the present invention. 1 is a block diagram showing the functional configuration of a sales management system according to an embodiment of the present invention; FIG. It is a figure which shows an example of the database applied to the sales management system which concerns on embodiment of this invention. It is a figure which shows an example of the database applied to the sales management system which concerns on embodiment of this invention. It is a flow chart which shows an example of sales management processing performed by a sales management system concerning an embodiment of the present invention. FIG. 3 is a diagram for explaining an example of a topology diagram displayed by the sales management system according to the embodiment of the present invention; FIG.

EMBODIMENT OF THE INVENTION Hereinafter, with reference to an accompanying drawing, the form (henceforth, embodiment) for implementing this invention is demonstrated in detail.

[Hardware configuration of sales management system]
First, the hardware configuration of a computer that constitutes a sales management system (hereinafter simply referred to as "system" or "this system") according to an embodiment of the present invention will be described with reference to FIG. FIG. 1 is a block diagram showing the hardware configuration of a computer that constitutes the system. Products to be sold and managed by the sales management system according to this embodiment include all tangible products sold out, products in a data format that can be downloaded via the Internet (for example, software, music data, etc.), and usage period Including subscription products that provide intangible services in which the timing of billing and payment of consideration is determined according to the ”). Also, the sales management system according to this embodiment is realized by a general computer. The computer includes a CPU (Central Processing Unit) 1, ROM (Read Only Memory) 2, RAM (Random Access Memory) 3, storage device 4, input/output interface (hereinafter abbreviated as "IF") 5, mouse 6, keyboard 7, a display device 8, a printing device 9, and a communication device 10 basically. The CPU 1, ROM 2, RAM 3, storage device 4, and IF 5 are connected to each other via an internal bus. Mouse 6, keyboard 7, display device 8, printer 9, and communication device 10 are connected to the internal bus via IF5.

The CPU 1 executes and controls the operation of the entire computer, and executes, for example, sales management processing, which will be described later, based on a program. The ROM 2 stores control programs and the like for executing and controlling the operation of the entire computer. The RAM 3 provides a work area necessary for execution control of the CPU 1 and a storage area for various data. The storage device 4 is a large-capacity storage device such as a hard disk drive or a solid state drive, and stores programs and data for executing sales management processing, for example, according to installation or download. IF 5 exchanges various signals between CPU 1 and mouse 6 , keyboard 7 , display device 8 , printer 9 , and communication device 10 .

The mouse 6 is a so-called pointing device and is used to perform selection operations on the screen of the display device 8 . The keyboard 7 is used for directly inputting characters, numbers, etc. on the screen of the display device 8 . The display device 8 is, for example, a liquid crystal display, and displays character information and the like on an input operation display screen, an output result display screen, and the like. In particular, on the output result display screen, for example, a topology diagram, which will be described later, is displayed in order to make the sales management situation visually easier to see. The printing device 9 is, for example, an inkjet printer or a laser printer, and prints the topology diagram or the like displayed on the output result display screen on paper according to the printing operation. The communication device 10 is connected to, for example, a user terminal on the Internet via a network line (not shown), and downloads or uploads various data, programs, etc. with this user terminal or the like in response to web requests.

The computer of the present embodiment is pre-installed with programs, data, etc. for executing sales management processing in the storage device 4, but since it is basically connected to the Internet, it is possible to receive data from another external server. Programs, data, and the like for executing sales management processing may be made operable by downloading each time.

[System functional configuration]
Next, the functional configuration of the system will be described with reference to FIG. FIG. 2 is a block diagram showing the functional configuration of this system. The system of this embodiment is for selling various tangible and intangible commodities, and is mainly used for sales management by sales entities such as agents. Intangible products (subscription products) may be provided as digital data such as software or music, or may be provided as intangible services such as eating and drinking services, hairdressing services, and rental services.

As shown in FIG. 2, the system includes, as functions realized by a computer, product designation means 100, product information management means 200, trading information management means 210, sales destination management means 220, purchase source management means 230, billing time It has calculation means 300 , payment timing calculation means 310 , and display means 400 .

The product specifying means 100 is realized by the mouse 6 and the keyboard 7, and is used for inputting information on various products. The product specifying means 100 can also be realized by a computer, smartphone, or the like of the purchaser or the purchasing user connected to the Internet.

The merchandise information management means 200, the sales information management means 210, the sales destination management means 220, and the purchaser management means 230 are mainly realized by the storage device 4, and store corresponding data in a readable and writable manner. The merchandise information management means 200, the sales information management means 210, the sales destination management means 220, and the purchaser management means 230 are updated to the latest data, for example, when the merchandise is designated or when billing will be described later.

Merchandise information management means 200 manages information (merchandise information) on a plurality of types of commodities purchased from a purchaser as commodities that can be sold in a database. As shown in an example in FIG. 3, the product information includes the source of purchase, date of purchase, number of purchases, and information required when the product is an intangible product (subscription product) for each product type (A1 to A7). It is defined as data that associates different contract types. The purchase source is added each time a new purchase is made. The date of purchase corresponds to the initial payment date to the purchaser, and is also used as the starting date for the next payment date when the product is an intangible product (subscription product). The number of purchases is the quantity of products purchased from the purchase source. If the product is an intangible product (subscription product), the contract type defines the type of payment contract, such as a lump sum payment, an annual fee system, a monthly fee system, or a pay-as-you-go system, which is determined at the time of purchase for each product.

The trading information management means 210 manages information (trading information) on trading of products sold to customers using a database. As an example is shown in FIG. 4, the trading information is divided into trading information for the purchaser and trading information for the purchaser.

The sales information for each sales destination includes the type of product sold, the date of sale, the number of sales, the type of contract required if the product is an intangible product (subscription product), the billing amount (other (including agency commission when purchasing from an agency), and the next billing date when the product is an intangible product (subscription product). The sales date corresponds to the initial billing date to the sales destination, and is also used as the starting date for the next billing date when the product is an intangible product (subscription product). The number of sales is defined as the quantity to the sales destination. The contract type defines the type of billing contract determined at the time of product sales, such as a lump sum payment, an annual fee system, a monthly fee system, and a pay-as-you-go system. The billing amount is calculated at the time of sale as a lump sum, annual amount, monthly amount, or monthly amount according to the pay-as-you-go system as the product price according to the contract type. The billed amount includes the commission paid to the agent when the product is purchased through another agent. The next billing date is calculated at the time of sale as the next billing date for the product price corresponding to the contract type.

The transaction information for the purchase source includes the type of product purchased, date of purchase, number of purchases, contract type required if the product is an intangible product (subscription product), payment amount (other (including agent commission when purchasing from an agent) and the next payment date when the product is an intangible product (subscription product). The purchase date corresponds to the initial payment date to the purchaser, and is also used as the starting date for the next payment date when the product is an intangible product (subscription product). The number of purchases is defined as the number of products purchased from the purchase source. The contract type defines the type of payment contract determined at the time of product purchase, such as a lump-sum payment, an annual fee system, a monthly fee system, and a pay-as-you-go system. The payment amount is calculated at the time of purchase as a lump sum, annual amount, monthly amount, or monthly amount according to the pay-as-you-go system as the product price according to the contract type. The amount to be paid includes commissions paid to an agent when goods are purchased through another agent. The next payment date is calculated at the time of purchase as the next payment date for the product according to the contract type.

Returning to FIG. 2, the sales destination management means 220 includes, as information on sales destinations, an ID for specifying a sales destination and a user of the sales destination, as well as data on a shopping cart applied to so-called online shopping, a settlement method, and so on. , manages data related to My Page for users themselves to check purchase details and contract details. Note that the user may be another agency. Purchasing source management means 230 manages, as information about a purchasing source, data related to an ID for specifying a purchasing source, a supplier maker or a developer of the purchasing source, and the like.

The billing time calculation means 300 and the payment time calculation means 310 are mainly implemented by the CPU 1 . When the product is an intangible product (subscription product), the billing time calculation means 300 calculates the product price as a lump sum, annual amount, monthly amount, monthly amount according to the pay-as-you-go system, which is the contract type of the product when the product is sold, Using the date of sale as the starting date, calculate the next billing date (next billing date) for the next annual fee, monthly fee, and monthly fee according to the pay-as-you-go system. The calculated product price and the next billing date are written in the sales information (see FIG. 4) for the purchaser. When the product is an intangible product (subscription product), the payment timing calculation means 310 calculates the lump sum, annual amount, monthly amount, and monthly amount according to the pay-as-you-go contract type of the product when purchasing the product as the product price, Using the date of purchase as the starting date, calculate the next payment date (next payment date) for the next annual amount, monthly amount, and monthly amount according to the pay-as-you-go system. The billed consideration and the next payment date calculated are written in the transaction information (see FIG. 4) for the purchase source. In the case of a lump-sum payment (for example, in the case of tangible goods), the next billing date and the next payment date are omitted from the calculation process.

A display means 400 is implemented by the CPU 1 and the display device 8 . The display means 400 displays the source of purchase and a plurality of commodities as nodes centering on the selling entity, and also displays the routes (edges) connecting these nodes and the selling entity in accordance with the content of the contract, a so-called topology representation. Display formal diagrams (topology diagrams) for sales management. This topology diagram will be described later with reference to FIG.

Next, with reference to FIG. 5, sales management processing executed by the CPU 1 of this system will be described. FIG. 5 is a flowchart showing sales management processing.

First, in step S1, the CPU 1 detects that a product to be purchased by a sales destination or a user of the sales destination (hereinafter collectively referred to as a "sales destination, etc.") is specified via the Internet from a list of products in the product information. to confirm. At this time, the CPU 1 acquires the ID information for specifying the sales destination and the like from the information input to the web page, in addition to the designated product type. In addition, if the product designation is verbally communicated to the seller by telephone, etc. from the seller, the system operator of the seller may manually enter the product type and ID information. good.

Next, in step S2, the CPU 1 confirms that a contract type such as a lump sum, an annual fee, a monthly fee, or a pay-as-you-go system has been specified in addition to the number of sales for the specified product. At this time, the CPU 1 identifies the number of sales of the designated product, and also identifies the date of sale based on the date and time when the product was designated. Then, the CPU 1 writes the designated product type, sales date, sales quantity, and contract type into the database of the storage device 4 as sales information.

Next, in step S3, the CPU 1 calculates the billing time. In calculating the timing of billing, the amount billed to the customer, etc. at the present time is calculated based on the contract type and the date of sale. The next billing date corresponding to the contract type is also calculated using the day as the starting date. The next billing date is written in the database of the storage device 4 as trading information of the corresponding product. Such next billing date is used to notify the next billing amount to the purchaser or the like. In addition, when calculating the billing period, if the corresponding product is not purchased directly from the supplier manufacturer or developer, but purchased through another agency, payment should be made to the agency. A billing amount is calculated that includes a fee depending on the type of contract.

Next, in step S4, the CPU 1 calculates the payment timing. In calculating this payment period, the payment amount at the time of purchase is calculated based on the contract type and purchase date with the purchaser, and the next payment date according to the contract type is also calculated with the purchase date as the starting date. Calculated. The next payment date is written in the database of the storage device 4 as trading information of the corresponding product. Such next payment date is used to make the next payment to the purchaser. In addition, when calculating the payment period, if the corresponding product was not purchased directly from the supplier manufacturer or developer, but was purchased through another agency, the payment was made to the agency. A payment amount including a commission according to the contract type is calculated.

Next, in step S5, the CPU 1 causes the display device 8 to display a topology diagram centered on the seller as shown in FIG. In FIG. 6, "P" indicates a sales entity (manager of a sales management system, etc.), nodes "A1" to "A7" indicate products, and node "P1" indicates another agent as a purchase source. A store is shown, and nodes "D1" to "D3" show supplier manufacturers or developers as purchase sources. As an example, in the topology diagram of FIG. 6, it is displayed that the number of sales destinations is 2, the number of sales is 25, and the billing amount is 160,000 yen for the product of node "A1". Also, for the product of node "A2", the number of buyers is 1, the number of sales is 12, and the billing amount is 80,000 yen as individual sales information. Similar information is displayed for the products of other nodes "A3" to "A6", but is omitted in FIG. 6 for the sake of convenience. Since the number of items sold at node "A7" is 0, there is no path (edge) connecting to the selling entity "P", and it is displayed alone as an item that can be sold but has not yet been sold. be done. That is, in the present embodiment, the CPU 1 displays purchased products as nodes that are not connected by paths (edges) even though they are not sold. In addition, the CPU 1 identifies the purchased products even if they have not been sold on a different path (edge) from the sold products (for example, when the sold products are connected by a solid line, the unsold products are connected by a dotted line). ). Also, for example, when comparing node 'A1' and node 'A2', the amount billed for 'A1' is greater than that for 'A2'. displayed briefly. That is, the path (edge) connecting the product and the sales entity is displayed shorter as the billed amount increases.

In the topology diagram of FIG. 6, for the supplier maker or developer of node "D1", as individual purchase information, the type of product purchased is "A1", the number of purchases at the time of purchase is 25, and the payment amount is 100,000. It is displayed to be a circle. Similar information is displayed for other nodes "D2" and "P1", but is omitted in FIG. 6 for the sake of convenience. Since the node "P1" indicates another agency, the developer's node "D3" is displayed to be connected to the node "P1" via a path (edge). Furthermore, in the topology diagram of FIG. 6, it is displayed that the number of purchasers is 3, the number of buyers is 6, the number of sales is 200, and the last month's sales are 2,348,000 yen for "P", the sales entity. ing. It should be noted that the CPU 1, for example, only when a node indicating a product or a node indicating a purchaser is selected (for example, by clicking with the mouse 6, etc.) by an operation such as an administrator of the sales management system, the individual sales information and the individual Purchasing information may be displayed. In the topology diagram, the distance between "P" of the seller and the node indicating the product or the node indicating the supplier may be set according to the billing amount or the payment amount, or the next billing date or distance. The sooner the next payment date is, the closer the selling entity's "P" may be.

According to this system, since product sales information is managed in association with product information on multiple types of products, when selling multiple types of products, different sales information is associated with each product. can do.

In addition to the amount billed to the purchaser, the transaction information includes the next billing date according to the contract type, so the amount billed to the purchaser and the time of billing can be managed in detail.

In addition, even if the product is purchased through another agency (intermediate trader), it is possible to accurately obtain and manage the billing amount to the sales destination, including the commission to the agency.

In addition to the payment amount, the transaction information includes the next payment date according to the contract type, so that the payment amount to the purchaser and the payment period can be managed in detail.

In addition, even if the product is purchased through another agency (intermediate trader), it is possible to accurately obtain and manage the payment amount including the commission to the agency.

In addition, by displaying the sales information corresponding to each product information in a topology diagram, it is possible to visually check the sales management status for each product in an easy-to-see manner.

In addition, it is possible to confirm the status of purchase management for each purchase source in a visually easy-to-read manner using the topology diagram.

Further, since the route can be displayed/hidden according to the presence/absence of trading information for each item information, it is possible to distinguish at a glance whether the item has already been sold or not.

In addition, since the length of the route can be displayed differently according to the number of sales included in the trading information for each piece of merchandise information, it is possible to distinguish at a glance whether the merchandise has a large number of sales or the merchandise with a small number of sales. In the above embodiment, the length of the route connecting to the purchaser is changed according to the number of sales. good too.

Although the embodiments of the present invention have been described above, it goes without saying that the technical scope of the present invention is not limited to the contents of the above embodiments. It is obvious to those skilled in the art that various modifications or improvements can be made to the above embodiments. Moreover, it is clear from the description of the scope of the claims that the forms with such modifications or improvements are also included in the technical scope of the present invention.

In the above embodiment, the system is configured by a computer connected to the Internet. However, as another system of the present invention, a storage device that stores databases and programs is separated from the computer and stored in, for example, a cloud server. It is also possible to construct the database and access the program each time through the Internet.

In the above embodiment, the topology diagram is displayed with nodes of the seller (P), the products (A1 to A7), and the purchaser (D1, D2, P1). Alternatively, a topology diagram may be displayed in which sales destinations and the like are nodes.

In the topology diagram, the displayed items (number of sales, billing amount, sales, etc.) may be customized by the user.

1 CPU
2 ROMs
3 RAM
4 storage device 6 mouse 7 keyboard 8 display device 9 printing device 10 communication device 100 product designation means 200 product information management means 210 sales information management means 220 sales destination management means 230 purchase source management means 300 billing time calculation means 310 payment time calculation means 400 display means

Claims (6)

A sales management system for managing sales of merchandise,
a product information management means for managing product information on a plurality of types of products that can be sold;
product designation means for designating one of the plurality of types of products;
a trading information management means for acquiring, from the product information management means, product information relating to the product specified via the product specifying means, and managing the sale information relating to the sale corresponding to the product in association with the product information;
A sales management system characterized by comprising a display means capable of displaying a plurality of product information in a topology expression format centering on a sales entity, and displaying the trading information corresponding to each product information. . The multiple types of products include transit products purchased via one or more intermediate traders,
The display means can display the one or more intermediate traders including the purchaser centering on the seller in a topology expression format, and can display the trade information corresponding to each intermediate trader. The sales management system according to claim 1, characterized by: 3. The sales management system according to claim 1, wherein said display means can display a route in a topology representation format according to the presence or absence of said trading information for each item information. 4. A method according to claim 1, wherein said display means is capable of displaying the length of a route in a topology representation format in accordance with the amount of transaction included in said trading information for each item information. Sales management system. A method performed by a sales management system for managing sales of merchandise, the method comprising:
a product information management step for managing product information about a plurality of types of products that can be sold;
a product designation step for designating one of the plurality of types of products;
a trading information management step of acquiring product information related to the product specified through the product specifying step, and managing the trading information related to trading corresponding to the product in association with the product information;
and a display step for displaying the trading information corresponding to each piece of product information, wherein the plurality of product information can be displayed in a topology expression format centering on the selling entity. A computer program for sales management for managing sales of merchandise,
the computer,
a product information management means for managing product information on a plurality of types of products that can be sold;
product designation means for designating one of the plurality of types of products;
a trading information management means for acquiring, from the product information management means, product information relating to the product specified via the product specifying means, and managing the sale information relating to the sale corresponding to the product in association with the product information;
display means capable of displaying a plurality of product information centered on a sales entity in a topology expression format, and for displaying the trading information corresponding to each product information;
A computer program for sales management characterized by functioning as a

Images