KR20130027680A - Sorting system for the medicine sales data and the method thereof - Google Patents

Abstract

PURPOSE: A system for collecting sales data of medicines and a method thereof are provided to simultaneously transmit sales data to a plurality of pharmaceutical companies when a wholesale agent provides the data once. CONSTITUTION: A control and management server(130) matches product information of each pharmaceutical company uploaded from a plurality of pharmaceutical company terminals(110) to an intrinsic code of a corresponding pharmaceutical company terminal. A plurality of client terminals(120) store the product information downloaded from the control and management server. The client terminals upload sales data and seller information to the control and management server. The control and management server matches the sales data by seller group and product according to a set condition. The control and management server updates the matched sales data to the corresponding pharmaceutical company terminal on each set cycle. [Reference numerals] (110) Manufacturer(pharmaceutical company); (120) Customer(Wholesale supplier); (131) Control and management server; (132) Collecting code generating/matching unit; (133) Code management unit; (134) Product DB; (135) Selling partner DB; (136) Sales data DB

Description

Sorting system for the medicine sales data and the method

The present invention relates to a sales data collection system and method of medicines, and more particularly, sales of medicines that collect and provide sales data by automatically matching sales data provided from a plurality of customers to a data collection format of a manufacturer. A data collection system and method thereof.

In general, pharmaceutical companies regularly establish sales strategies by collecting and analyzing the sales data of medicines to identify the wholesaler's inventory or analyze the data about the customers.

In order to analyze the data, sales data of wholesalers provided by various wholesalers dealing with pharmaceutical companies are collected and analyzed.

However, in order to receive sales data of a conventional wholesaler, wholesalers have been provided with a sales data written in a file format or written form using a program such as Word or Excel.

1 is a view showing a sales data collection system of a conventional medicine. As shown in FIG. 1, the conventional medicine sales data collection system 10 receives sales data on its products from wholesalers 21 to 23 as customers of respective manufacturers 11 to 13 as pharmaceutical companies. It has been provided by email or in writing. For example, the manufacturer A 11 has been provided with sales data (sales data 1-1 to sales data 1-3) for its products from the wholesalers 21 to 23.

Each manufacturer 11 to 13 directly collected sales data provided from customers 21 to 23 and analyzed the sales. By the way, in the conventional sales data collection system of the pharmaceutical 10, a lot of time and manpower was required by directly processing the sales data provided, or by requesting data analysis to an external professional company.

In addition, if the final retailer of wholesalers is a pharmacy, it is difficult to analyze in detail because the current law is to collect by postal code or local name.

The problem to be solved by the present invention is to transmit the sales data to a number of pharmaceutical companies at the same time with only one data supply, and to collect the sales data that can be provided to the manufacturer by quickly and accurately collecting the sales data provided from a number of customers The present invention provides a system and a method thereof.

The sales data collection system of medicines according to the present invention uploads product information on products produced individually, and receives a plurality of manufacturers terminals receiving product sales data according to the sale of the produced products and product information of the produced products. Download and store and store product information of a plurality of client terminals uploading the sales data of the corresponding product according to a set cycle and the product information uploaded from the plurality of manufacturer terminals by matching the unique codes of the corresponding manufacturer terminals. Matching the sales data uploaded from the plurality of client terminals according to a set condition and storing the product and client group in a storage area for each client, and updating the stored sales data to the corresponding manufacturer terminal every set period. It includes a sales management server.

Method for collecting sales data of medicines according to the present invention, the product information of the product uploaded from a plurality of manufacturers terminal matching the unique code of the manufacturer terminal, and individually stored in the product DB, uploaded from a plurality of customer terminals Storing the customer information in which the produced product is sold in a customer DB, matching and storing the sales data uploaded from the plurality of client terminals into a customer group and a product group according to a set condition, and the matched sale Updating the data to a plurality of corresponding manufacturer terminal for each set period.

Sales data collection system according to the present invention has the effect that the wholesaler can transmit the sales data to a number of pharmaceutical companies at the same time with only one data.

In addition, the sales data collection system according to the present invention has the effect that it is possible to collect the sales data provided from a number of wholesalers accurately and quickly to provide more detailed sales data to pharmaceutical companies than conventional sales data.

In addition, the sales data collection system according to the present invention has the effect that the pharmaceutical company can perform a more accurate and detailed sales analysis compared to the conventional, while the wholesaler and the pharmaceutical company protects the individual information of the pharmacy as the distributor.

1 is a view showing a method for collecting sales data of a conventional medicine.
2 is a view showing a sales data collection system of medicines according to an embodiment of the present invention.
3 is a flowchart illustrating a sales data collection method according to the present invention.
4 is a view for explaining a matching method for a customer according to the present invention.
5 is a view for explaining a matching method for a product according to the present invention.
6 is a view showing an embodiment showing a sales data matching result using the present invention.

In order to fully understand the present invention, operational advantages of the present invention, and objects achieved by the practice of the present invention, reference should be made to the accompanying drawings and the accompanying drawings which illustrate preferred embodiments of the present invention.

BEST MODE FOR CARRYING OUT THE INVENTION Hereinafter, the present invention will be described in detail with reference to the preferred embodiments of the present invention with reference to the accompanying drawings. Like reference symbols in the drawings denote like elements.

2 is a view showing a sales data collection system of medicines according to an embodiment of the present invention.

2, the sales data collection system 100 according to the present invention includes a plurality of manufacturer terminals 110, a plurality of client terminals 120, and a control management server 130.

The manufacturer is a pharmaceutical company that produces and supplies medicines, and the customer is a pharmaceutical wholesaler or a hospital, clinic or pharmacy that receives the product directly from the pharmaceutical companies.

Dedicated programs for accessing the control management server 130 are installed in the plurality of manufacturer terminals 110 and the plurality of client terminals 120.

The plurality of manufacturers terminal 110 uploads the product information for the products produced by the manufacturer to the control management server 130.

The plurality of manufacturer terminals 110 are provided from the control management server 130 from the control management server from the control management server, the sales data according to the sale of the corresponding product.

The plurality of customer terminals 120 downloads and stores product information of production products produced by the manufacturer from the control management server 130, and uploads sales data of the sold product to the control management server 130. do.

The plurality of customer terminals 120 uploads to the control management server 130 the customer information about the customer to which the produced products are sold.

The control management server 130 individually stores the product information of the production products uploaded from the plurality of manufacturers terminals 110 by matching the unique codes of the corresponding manufacturers terminals.

The control management server 130 matches the sales data uploaded from the plurality of customer terminals 110 on a set condition and stores them in a storage area for each customer.

The control management server 130 updates the stored matched sales data to the corresponding manufacturer terminal 110 at set intervals.

The control management server 130 is a control management unit 131, aggregation code generation / matching unit 132, aggregation code management unit 133, product DB 134, customer DB (135) and sales data DB (136) Include.

The control manager 131 matches product information transmitted from the plurality of manufacturer terminals 110 with unique codes of respective manufacturer terminals and stores the product information in the product DB 134.

The control management unit 131 stores the account information transmitted from the customer terminal 120 in the customer DB (135).

In this case, the control management unit 131 uploads the product information and the customer information from the plurality of manufacturer terminals 110 or the plurality of customer terminals 120 is a set period or the plurality of manufacturer terminals 110. And when the product information and the customer information stored in each of the plurality of customer terminal 120 is changed may be implemented to be automatically transmitted.

The control management unit 131 individually transmits and updates the sales data matched with the sales data DB to each of the plurality of manufacturer terminals 110 according to a set cycle.

In addition, the control management unit 131 updates the product information stored in the product DB to the plurality of customer terminals 120 at a set cycle, and updates the customer information stored in the customer DB to the plurality of manufacturer terminals 110. It can be implemented to.

The control management unit 131 authenticates the use authority when there are authentication requests for system use from the plurality of manufacturer terminals 110, and provides sales data to the approved manufacturers to the plurality of client terminals 120. Ask for approval. Then, when the provision of data from the customer terminal 120 to the manufacturer is approved, and stores the authentication information for it.

The code generation / matching unit 132 generates a collection code for matching the product information stored in the product DB and the customer information in the customer DB to the collection conditions set by the plurality of manufacturer terminals 110.

The code generation / matching unit 132 generates one group code for at least one customer for a hospital or a clinic among the customer information stored in the customer DB, and in the case where the customer is a pharmacy, the code generator / matching unit 132 Generate one group code for each.

The code management unit 133 manages the aggregation code generated from the code generation / matching unit 132, and generates the code from the product information and the customer information included in the sales data transmitted from each of the customer terminals 120. The matching code generated by the matching unit 132 is stored in the sales data DB 136.

The product DB 134 stores product information individually produced by a manufacturer transmitted from the plurality of manufacturer terminals 110.

The customer DB 135 stores customer information that the customer receives from the manufacturer and sells.

The sales data DB 136 is uploaded from the plurality of customer terminals 120 and stores the sales data matching the setting conditions of the manufacturer.

3 is a flowchart illustrating a sales data collection method according to the present invention. 2 and 3, the sales management server 130 of the drug sales data collection system 110 of the product information of the production products uploaded from a plurality of manufacturers terminal 110 unique code of the manufacturer terminal Matched with and stored in the product DB (134) (S110).

The sales management server 130 stores in the customer DB 135 the customer information on which the produced products uploaded from the plurality of customer terminals 120 are sold (S120).

At this time, the sales management server 130 is uploaded to the product information from the plurality of manufacturers terminal 110 and uploaded to the customer information from the plurality of customer terminal 120 is a set period or the product information and customer information It can be implemented to be sent automatically when is changed.

In addition, the sales management server 130 updates the product information stored in the product DB to the plurality of customer terminals 120 at a set cycle, and updates the customer information stored in the customer DB to the plurality of manufacturer terminals 110. It can be implemented to update.

The sales management server 130 matches and stores sales data uploaded from the plurality of client terminals 120 in a predetermined sales group and a product group (S130 to S140).

That is, the sales management server 130 classifies the product information and the seller information stored in the product DB 134 and the customer DB 135 under the conditions set by each of the plurality of manufacturers 110, and each classified product. And generate a collection code for the customers (S130).

In this case, the sales management server 130 generates one aggregation code for at least one client when the client is a hospital or a clinic, and generates one aggregation code for at least three clients when the client is a pharmacy. Create

The sales management server 130 matches the generated sales code uploaded from the plurality of client terminals with the generated aggregation code and stores it in the sales data DB (S140).

The sales management server 130 updates the matched and stored sales data to a plurality of corresponding manufacturer terminals 110 at set intervals (S150).

4 is a view for explaining a matching method for a customer according to the present invention. As shown in FIG. 4, the sales management server 130 generates and matches a collection code by classifying the customer information stored in the customer DB 135 into a set group.

That is, the sales management server 130 classifies the customer information stored in the customer destination DB into a set number of groups, generates a matching code, matches each other, and sells the information about the sales data uploaded from the plurality of customer terminals 120. Match and store the information.

In other words, as illustrated, the clients are matched to the set group with the generated aggregation codes H00001, PH00001, and P000002.

In more detail, when the sales source stored in the sales management server 130 is a hospital or a clinic, it matches one sales source (S00001) and one collection code (H00001), and in the case of a pharmacy, at least three clients (S00002 to S00004) and one matching code (PH00001) is stored and matched, if there are less than three pharmacies are stored and matched with the remaining sales sources (S00005 ~ S00006) and one collection code (P000002).

5 is a view showing an embodiment showing results of sales data matching results using the present invention. Referring to FIG. 6, the matching method for the product may be implemented in the same manner as the method described with reference to FIG. 4, and thus, the detailed description will be omitted for the sake of brevity.

However, since the product is not restricted by the law, it is preferable to match a product with a wholesale code, a product standard code, and a product collection code of a product of a customer in order to match a product, but as illustrated, two products are matched. One product code can be given and matched.

At this time, the matching for the product is preferably matched based on the standard drug code of the product.

7 is a view showing an embodiment showing a result of collecting sales data using the present invention. As shown in Fig. 7, the sales data transmitted from the customer is matched and stored by the collection code set by the manufacturer. That is, as illustrated, the sales data for the door-to-door pharmacy insurance (00002), the door-to-door pharmacy general (00003), and the desired pharmacy (00005), which are the sellers matched with the acquisition code (PH00001) of the door pharmacy, are collected and stored. That is, as illustrated, only the data about the product matching the manufacturer code to be provided with data from the sales matched with the collection code PH00001 of the pharmacy is collected and transmitted.

As described above, the customer may prepare and transmit the sales data for transmission to a plurality of manufacturers as a single sales data, and the manufacturer may set the sales data provided from the multiple clients in its own format without a separate collection process. Can be provided.

100: sales data collection system 110: manufacturer terminal
120: customer terminal 130: sales management server
131: control management unit 132: code generation / matching unit
133: code management unit 134: product DB
135: customer DB 136: sales database DB

Claims (10)

A plurality of terminal terminals uploading product information on products produced individually and receiving sales data according to the sale of the corresponding products;
A plurality of client terminals for downloading and storing product information of the produced products and uploading sales data of the produced products according to a setting cycle;
Matching product information of the production products uploaded from the plurality of manufacturers terminal with the unique code of the corresponding manufacturer terminal and individually stored, matching the sales data uploaded from the plurality of clients terminal by product and customer group according to the set conditions And store it in a storage area for each customer, and include a sales management server for updating the stored matched sales data to a corresponding manufacturer terminal every set period. The method of claim 1,
The sales management server,
A product DB for storing product information transmitted from the plurality of manufacturer terminals;
A sales company DB for storing information of a sales company that receives and sells products produced from the manufacturing company through the customer;
A sales data DB uploaded from the plurality of client terminals and storing matched sales data through the sales management server;
A code generation / matching unit for generating and matching an aggregation code for matching the product information and the seller information stored in the product DB and the seller DB to a collection condition set by the plurality of manufacturer terminals;
A code management unit for managing the generated generation code generated by the code generation / matching unit and storing the matched sales data in the sales data DB; And
Match the product information transmitted from the manufacturer terminal with the unique code of the manufacturer terminal in the product DB or store the customer information transmitted from the client terminal in the customer DB, the sales data DB according to the set period System for selling sales of medicines comprising a control management unit for transmitting and updating the matched and stored sales data to the plurality of manufacturers terminal. The method of claim 2,
The code generation / matching unit,
If the customer is a hospital or a clinician generates at least one collection code for at least one customer,
The sales data collection system for medicines to generate one aggregation code for at least three customers if the customer is a pharmacy. The method of claim 2,
The control management unit,
And selling product information stored in the product DB to the plurality of customer terminals at a first set period, and updating the customer information stored in the customer DB to the plurality of manufacturer terminals at a second set period. The method of claim 1,
And uploading the product information from the plurality of manufacturer terminals and the customer information from the plurality of client terminals is automatically transmitted when a third set period or the product information and the customer information are changed. Storing product information of production products uploaded from a plurality of manufacturer terminals by matching the unique codes of the corresponding manufacturer terminals to a product DB;
Storing customer information in which a production product uploaded from a plurality of customer terminals is sold in a customer DB;
Matching and storing sales data uploaded from the plurality of client terminals into a customer group and a product group according to a set condition;
And selling the matched and stored sales data to a plurality of corresponding manufacturer terminals at predetermined intervals, respectively. The method according to claim 6,
Matching and storing the sales data,
Classifying product information and customer information stored in the product DB and the customer DB under the set conditions of each of a plurality of manufacturers to generate an aggregation code for each classified product and customer; And
And matching the sales data uploaded from the plurality of client terminals with the generated aggregation code and storing the sales data in a sales data DB. The method of claim 7, wherein
Generating the aggregation code,
If the customer is a hospital or a clinician generates at least one collection code for at least one customer,
The sales data collection method of the medicine to generate one aggregation code for at least three customers if the customer is a pharmacy. The method according to claim 6,
Method of collecting sales data of the drug,
And updating the product information stored in the product DB to the plurality of customer terminals at a first set period, and updating the customer information stored in the customer DB to the plurality of manufacturer terminals at a second set period. How to collect data. The method according to claim 6,
And uploading the product information from the plurality of manufacturer terminals and the customer information from the plurality of client terminals is automatically transmitted when a third set period or the product information and the customer information are changed.

Images