Pharmaceutical-product data management system and method

Abstract

The present application relates to the field of pharmaceutical product management. Provided are a pharmaceutical-product data management system and method. The pharmaceutical-product data management method comprises the following steps: when pharmaceutical products are put into storage in a warehouse, collecting storage data of the pharmaceutical products; collecting for-sale data of pharmaceutical products on shelves; when the pharmaceutical products are sold from a cashier desk, collecting sales data of the pharmaceutical products; and adjusting prices of the pharmaceutical products on the basis of the storage data, the for-sale data and the sales data. By means of collecting and compiling statistics on storage data, for-sale data and sales data, the degree to which a pharmaceutical product is slow-moving can be obtained, and the remaining shelf lives, remaining quantities, effective periods and potency retention rates of the pharmaceutical products are calculated; and the remaining shelf lives, remaining quantities, effective periods and potency retention rates of the pharmaceutical products are used as influence factors regarding sales efficiency, calculation and analysis are then performed on the basis of these influence factors, and the prices of the pharmaceutical products are adjusted in real time on the basis of the analysis result, such that differentiated prices are better provided for old and new pharmaceutical products, thereby facilitating a reduction in the workloads of sales personnel, and improving the working efficiency of sales.

Description

Pharmaceutical data management system and method Technical Field

[0001] The present application relates to the field of pharmaceutical management technology, and in particular to a pharmaceutical data management system and method. Background Art

[0002] Pharmaceuticals have a limited shelf life. To avoid the sale of expired pharmaceuticals, regulatory authorities stipulate that pharmaceuticals must generally be removed from shelves three months in advance of their expiration date and that expired pharmaceuticals must be reported as damaged.

[0003] When selling commonly used medicines (such as cold medicines, vitamin C Yinqiao tablets, and digestion tablets), some users will check the expiration dates of the medicines and usually choose the most recently released medicines. This results in a more serious slow-selling situation for medicines that are closer to their expiration dates. That is, newly released medicines (new medicines) sell quickly, while medicines that have been on the shelves for a long time (old medicines) sell slowly. Ultimately, medicines that have been on the shelves for a long time take longer to sell, forming a vicious cycle. Sales staff need to check the medicines on the shelves one by one every few days and sort the old and new medicines, for example, placing old medicines at the front and new medicines at the back, in order to promote the sales efficiency of old medicines. However, on the one hand, the effect is not very obvious, and on the other hand, it increases the workload of sales staff, resulting in low sales efficiency. Therefore, it is necessary to manage medicine data to improve the sales efficiency of old medicines, reduce the workload of sales staff, and improve sales efficiency.

[0004] Summary of the Invention

[0005] The present application provides a pharmaceutical data management system and method for managing pharmaceutical data to improve the sales efficiency of old pharmaceuticals, reduce the workload of sales personnel, and improve sales efficiency.

[0006] The first aspect of the present application provides a pharmaceutical data management method, comprising the following steps:

[0007] Collect the incoming data of medicines when they are put into the warehouse;

[0008] Collect data on pharmaceutical products on shelves for sale;

[0009] Collecting pharmaceutical sales data when pharmaceuticals are sold at a cash register;

[0010] Adjust the billing of pharmaceutical products based on inventory data, pending sales data, and sold data.

[0011] In some embodiments of the first aspect, collecting the pharmaceutical entry data when the pharmaceuticals are entered into the warehouse includes:

[0012] When the medicines are put into storage, the medicines are image-recognized to obtain the storage data, which includes the name, production date, expiration date, and storage quantity.

[0013] In some embodiments of the first aspect, collecting data on pharmaceuticals for sale on shelves includes:

[0014] Perform image recognition on the pharmaceuticals on the shelf to obtain the data for sale, which includes the name, production date, expiration date, and quantity for sale.

[0015] In some embodiments of the first aspect, collecting pharmaceutical sales data when the pharmaceuticals are sold at a checkout counter includes:

[0016] When the medicines are sold at the cashier counter, image recognition is performed on the medicines to obtain the sales data, which includes the name, production date, expiration date, and sales quantity.

[0017] In some embodiments of the first aspect, adjusting the billing of pharmaceuticals based on the incoming data, the pending sales data, and the sold data includes:

[0018] Determine the remaining quantity of pharmaceuticals, remaining quantity = quantity received - quantity sold;

[0019] Determine the effective period of the drug: effective period = expiration date ÷ 2 - production date ÷ 2;

[0020] Determine the remaining days of the medicine, remaining days = expiration date - current date;

[0021] Determine the pharmaceutical product's value preservation rate, which is: value preservation rate = remaining days ÷ effective days;

[0022] Adjust the billing of pharmaceuticals based on remaining quantity, remaining days, and retention rate.

[0023] In some embodiments of the first aspect, adjusting the billing of pharmaceuticals based on the remaining quantity, remaining days, and value preservation rate includes:

[0024] If the maximum preset number of days > the remaining number of days > the minimum preset number of days, the billing of the medicines will be adjusted based on the remaining quantity, remaining number of days, and value retention rate; otherwise, the medicines will be removed from the shelves.

[0025] In some embodiments of the first aspect, adjusting the billing of pharmaceuticals based on the remaining quantity, remaining days, and value preservation rate includes:

[0026] If the maximum preset number of days > the remaining number of days > the minimum preset number of days, and the remaining quantity > 5, the billing = initial billing × hedging rate.

[0027] In some embodiments of the first aspect, adjusting the billing of pharmaceuticals based on the remaining quantity, remaining days, and value preservation rate includes:

[0028] If the maximum preset number of days > the remaining number of days > the minimum preset number of days, and the remaining quantity ≤ 5, then the billing = initial billing × hedging rate - initial billing × hedging rate ÷ remaining quantity.

[0029] A second aspect of the present application provides a pharmaceutical data management system, comprising:

[0030] Back-end data collection device, used to collect the incoming data of medicines when they are put into the warehouse;

[0031] Mid-range data collection device, used to collect data on pharmaceutical products for sale on shelves;

[0032] A front-end data collection device for collecting sales data of pharmaceuticals when the pharmaceuticals are sold from the cash register;

[0033] The processing device is connected to the back-end data acquisition device, the mid-end data acquisition device, the front-end data acquisition device, and the host of the cash register, and is used to adjust the billing of pharmaceuticals based on the incoming data, the data to be sold, and the data sold, and transmit the adjusted billing to the host of the cash register.

[0034] In some embodiments of the second aspect, the back-end data acquisition device is adapted to capture images of the pharmaceuticals when they are stored in a warehouse, and the processing device obtains storage data by identifying the image data captured by the back-end data acquisition device;

[0035] The mid-end data acquisition device is suitable for collecting images of pharmaceuticals on the shelf, and the processing device obtains the data for sale by identifying the image data collected by the mid-end data acquisition device;

[0036] The front-end data acquisition device is suitable for capturing images of the medicines when they are sold at the cashier counter, and the processing device obtains the sales data by identifying the image data captured by the front-end data acquisition device.

[0037] This application has the following beneficial effects:

[0038] By collecting and counting the incoming data, data for sale, and data for sale, we can obtain the degree of unsalable medicines, calculate the remaining days, remaining quantity, effective days, and value retention rate of medicines, incorporate the remaining days, remaining quantity, effective days, and value retention rate of medicines into the influencing factors of sales efficiency, and perform calculations and analysis based on these influencing factors. According to the analysis results, the billing of medicines is adjusted in real time to better provide differentiated billing for new and old medicines, which helps to improve the sales efficiency of old medicines, reduce the waste of medicines, improve the sales efficiency of old medicines, reduce the workload of sales staff, and improve sales efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, a brief introduction will be given below to the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0040] FIG1 is a flow chart of a pharmaceutical data management method according to an embodiment of the present application;

[0041] FIG2 is a flow chart of an algorithm for adjusting pharmaceutical billing according to an embodiment of the present application;

[0042] FIG3 is a schematic diagram of the structure of the pharmaceutical data management system in an embodiment of the present application.

[0043] Reference numerals: 100, back-end data collection device; 200, mid-end data collection device; 300, front-end data collection device; 400, processing device; 500, warehouse; 600, shelf; 700, cash register. DETAILED DESCRIPTION

[0044] The implementation methods of the present application are further described in detail below in conjunction with the drawings and examples. The terms used in the implementation methods of the present application are only used to explain the specific examples of the present application and are not intended to limit the present application.

[0045] As shown in FIG1 , in Example 1 of the present application, a pharmaceutical data management method is provided, comprising the following steps:

[0046] When medicines are put into warehouse 500, the incoming data of medicines are collected;

[0047] Collecting data on pharmaceutical products for sale on shelf 600;

[0048] When pharmaceuticals are sold from the cash register 700, sales data of pharmaceuticals are collected;

[0049] Adjust the billing of pharmaceuticals based on incoming data, pending sales data, and sold data.

[0050] According to the above implementation of Example 1, the sales route of pharmaceuticals includes warehousing, shelving, purchasing, and selling. When pharmaceuticals are stored in the warehouse 500, the storage data of the pharmaceuticals are collected. After the pharmaceuticals are shelved on the shelf 600, the data on the pharmaceuticals to be sold on the shelf 600 are collected. When the pharmaceuticals are sold from the cash register 700, the sales data of the pharmaceuticals are collected. By counting the storage data, the data on the data to be sold, and the sales data, the degree of unsalable pharmaceuticals can be obtained. As shown in FIG3 , for example, the pharmaceuticals stored in the warehouse 500 include three types of pharmaceuticals: pharmaceutical A, pharmaceutical B, and pharmaceutical C. After some pharmaceuticals are shelved on the shelf 600, there are pharmaceuticals A and pharmaceutical B with various production dates and expiration dates on the shelf 600. For example, there are three types of pharmaceuticals with different production dates and expiration dates in pharmaceutical A: pharmaceutical A1 (the names of the pharmaceuticals in pharmaceutical A1 are different). The names, production dates and expiration dates of the medicines are the same respectively), medicine A2 (the names, production dates and expiration dates of the medicines in medicine A2 are the same respectively), and medicine A3 (the names, production dates and expiration dates of the medicines in medicine A3 are the same respectively, for example, the names, production dates and expiration dates of the medicines in medicine A3 are the same). There are three types of medicines with production dates and expiration dates in medicine B: medicine B1 (the names, production dates and expiration dates of the medicines in medicine B1 are the same respectively), medicine B2 (the names, production dates and expiration dates of the medicines in medicine B2 are the same respectively), and medicine B3 (the names, production dates and expiration dates of the medicines in medicine B3 are the same respectively). The user selects medicine A2 and checks out at checkout counter 700. After medicine A2 is checked out, medicine A2 is sold. This embodiment uses pharmaceutical A2 as an example to analyze the sales of pharmaceutical A2. For example, if the production date of pharmaceutical A2 is June 22, 2021, and the expiration date is June 22, 2023 (or if the expiration date is two years, it is converted to a unified format: June 22, 2021 + 2 years = June 22, 2023), each time a pharmaceutical A2 is sold, the total number of pharmaceutical A2 in warehouse 500 and on shelf 600 is reduced by one. By analyzing the total number of pharmaceutical A2, its production date, and its expiration date, the billing of pharmaceutical A2 is adjusted based on the analysis results. For example, if pharmaceutical A2 is nearing its expiration date or the total number of pharmaceutical A2 is relatively large, the billing of pharmaceutical A2 is reduced. This eliminates the need for sales staff to check each pharmaceutical on the shelf, helping to improve the efficiency of selling old pharmaceuticals, reduce sales staff workload, and improve sales efficiency.

[0051] In some embodiments of Example 1, the step of collecting the pharmaceutical entry data when the pharmaceuticals are entered into the warehouse 500 includes:

[0052] When the medicines are put into the warehouse 500, image recognition is performed on the medicines to obtain the storage data, which includes the name, production date, expiration date, and storage quantity.

[0053] In some implementations of Example 1, collecting the data of pharmaceuticals for sale on the shelf 600 includes:

[0054] Image recognition is performed on the pharmaceuticals on the shelf 600 to obtain the data for sale, which includes the name, production date, expiration date, and quantity for sale.

[0055] In some embodiments of Example 1, collecting pharmaceutical sales data when pharmaceuticals are sold from the cashier counter 700 includes:

[0056] When the medicines are sold from the cashier counter 700 , image recognition is performed on the medicines to obtain the sales data, which includes the name, production date, expiration date, and sales quantity.

[0057] In some implementations of Example 1, adjusting the billing of pharmaceuticals based on the incoming data, the pending sales data, and the sold data includes:

[0058] Determine the remaining quantity of pharmaceuticals, remaining quantity = quantity received - quantity sold;

[0059] Determine the effective period of the drug: effective period = (expiration date - production date) ÷ 2;

[0060] Determine the remaining days of the medicine, remaining days = expiration date - current date;

[0061] Determine the pharmaceutical product's value preservation rate, which is: value preservation rate = remaining days ÷ effective days;

[0062] Adjust the billing of pharmaceuticals based on remaining quantity, remaining days, and retention rate.

[0063] Because users often consider the production date and expiration date of pharmaceuticals when purchasing them, the sales efficiency of new pharmaceuticals is higher than that of old pharmaceuticals. The sluggish sales of old pharmaceuticals lead to even lower sales efficiency, forming a vicious cycle. If a pharmaceutical remains unsold three months before its expiration date, it must be removed from the shelves according to regulations, resulting in waste. Through the above-mentioned implementation of Example 1, the remaining days, remaining quantity, effective days, and value retention rate of pharmaceuticals are included as influencing factors, and calculations and analysis are performed based on these influencing factors. The billing of pharmaceuticals is adjusted according to the analysis results, which helps to improve the sales efficiency of old pharmaceuticals, reduce pharmaceutical waste, improve the sales efficiency of old pharmaceuticals, reduce the workload of sales personnel, and improve sales efficiency.

[0064] As shown in FIG2 , in some implementations of Example 1, adjusting the billing of pharmaceuticals based on the remaining quantity, remaining days, and value preservation rate includes:

[0065] If the maximum preset number of days > the remaining number of days > the minimum preset number of days, the billing of the medicines will be adjusted based on the remaining quantity, remaining number of days, and value retention rate; otherwise, the medicines will be removed from the shelves.

[0066] Through the above implementation of Example 1, the collected data is analyzed to see whether the remaining days of the medicine are greater than 3 months (90 days). If the condition of greater than 3 months is met, subsequent calculations and billing adjustments are performed; otherwise, the medicine is removed from the shelves.

[0067] In some embodiments of Example 1, adjusting the billing of pharmaceuticals based on the remaining quantity, remaining days, and value preservation rate includes:

[0068] If the maximum preset number of days > the remaining number of days > the minimum preset number of days, and the remaining quantity > 5, the billing = initial billing × hedging rate.

[0069] Through the above implementation of Example 1, when the remaining quantity is greater than 5, the real-time (timed in days) billing of the medicines is evaluated by the value preservation rate. The lower the value preservation rate, the fewer days the medicines have left and the higher the degree of obsolescence. In this case, the billing of the medicines needs to be reduced day by day. The calculation formula is: billing = initial billing × value preservation rate.

[0070] In some embodiments of Example 1, adjusting the billing of pharmaceuticals based on the remaining quantity, remaining days, and value preservation rate includes:

[0071] If the maximum preset number of days > the remaining number of days > the minimum preset number of days, and the remaining quantity ≤ 5, then the billing = initial billing × hedging rate × (1-1 ÷ remaining quantity) = initial billing × hedging rate - initial billing × hedging rate ÷ remaining quantity.

[0072] Through the above implementation of Example 1, the maximum preset number of days is set to 180 (days), and the minimum preset number of days is set to 90 (days). When the number of medicines is less than or equal to 5, the number of old medicines on shelf 600 is small, and the number of new medicines is large. The comparison between old medicines and new medicines in terms of expiration date and production date will be more obvious. In order to reduce the user's rejection effect on old medicines, on the basis of the value retention rate, the medicines are further billed according to the quantity. The calculation formula is: billing = initial billing × value retention rate × (1-1 ÷ remaining quantity). When the number of medicines is less than or equal to 5, the smaller the number, the lower the billing, thereby improving the sales efficiency of old medicines and clearing out the small number of old medicines more quickly.

[0073] To facilitate understanding of the technical solution of Example 1, the following description is made using pharmaceutical A2 as an example. The current date is January 22, 2023, the initial billing of pharmaceutical A2 is RMB 100, the number of pharmaceutical A2 in stock is 30, the number of pharmaceutical A2 sold is 24, the production date of pharmaceutical A2 is June 22, 2021, and the expiration date of pharmaceutical A2 is June 22, 2023. The remaining quantity of pharmaceutical A2 = the number of in-stock quantities - the number of sold quantities = 30 - 24 = 6 (units), the effective number of days of pharmaceutical A2 = (effective number - production date) ÷ 2 = (June 22, 2023 - June 22, 2021) ÷ 2 = 730 ÷ 2 = 365 (days), the remaining number of days of pharmaceutical A2 = effective number - current date = June 22, 2023 - January 22, 2023 Days = 151 (days), the value preservation rate of medicine A2 = the remaining days ÷ the effective days = 151 ÷ 365 ≈ 0.4, the billing of the remaining 6 medicines A2 = initial billing × value preservation rate = 100 × 0.4 = 40 (yuan), the billing of the remaining 5 medicines A2 = initial billing × value preservation rate × (1-1 ÷ remaining number) = 100 × 0.4 × (1-1 ÷ 5) = 32 (yuan), the remaining 4 The billing for medicine A2 = 100×0.4×(1-1÷4)=30 (yuan), the billing for the remaining 3 medicines A2 = 100×0.4×(1-1÷3)≈27 (yuan), the billing for the remaining 2 medicines A2 = 100×0.4×(1-1÷2)=20 (yuan), the billing for the remaining 1 medicine A2 = 100×0.4×(1-1÷1)=0 (yuan). Among them, the effective days are determined by multiplying the actual effective days by a preset coefficient. For example, the actual effective days of medicine A2 = expiration date - production date = June 22, 2023 - June 22, 2021 = 730 (days). The coefficient of the effective days of medicine A2 is 0.5, that is, the effective days of medicine A2 = actual effective days × 0.5 = 365 (days). The coefficient is adjusted according to the actual effective days of the medicine. For example, if the actual effective days = 180 (days), the coefficient should be adjusted to 1. From this, it can be seen that the actual effective number of days of pharmaceuticals is not fixed, and the value retention rate does not have to be calculated using the fixed value provided in this embodiment (the fixed value provided in this embodiment is an optional example). The value retention rate is qualitatively in line with the calculation formula "value retention rate = remaining days ÷ effective days", that is, the fewer the remaining days, the lower the user's purchase value (from the perspective of consumption habits, not the perspective of efficacy value, the efficacy value is still the same, unless the drug is about to expire, then the use value of the drug will inevitably decrease). In order to adapt to different pharmaceuticals, the calculation reliability of the value retention rate can be improved after the effective number of days is adjusted using a preset coefficient.For the case where a drug is about to expire (based on the relative expiration date of 3 months in advance), for example, drug A will expire in 3 days, and the user just needs a 3-day supply of medicine. Then the user will consider that if he forgets to take the medicine once, the extra supply will expire, so the user will usually choose a drug that is further away from expiration (that is, a newer medicine).

[0074] As shown in FIG3 , in Example 2 of the present application, a pharmaceutical data management system is provided, including:

[0075] The back-end data collection device 100 is used to collect the incoming data of the medicines when the medicines are put into the warehouse 500;

[0076] The mid-end data collection device 200 is used to collect the data of the pharmaceutical products for sale on the shelf 600;

[0077] The front-end data collection device 300 is used to collect sales data of pharmaceuticals when the pharmaceuticals are sold from the cashier 700;

[0078] The processing device 400 is connected to the back-end data acquisition device 100, the mid-end data acquisition device 200, the front-end data acquisition device 300, and the host of the cash register 700, respectively, and is used to adjust the billing of medicines based on the incoming data, the data for sale, and the data for sale, and transmit the adjusted billing to the host of the cash register 700.

[0079] In some implementations of Example 2, the back-end data acquisition device 100 is adapted to capture images of the pharmaceuticals when they are stored in the warehouse 500, and the processing device 400 obtains storage data by identifying the image data captured by the back-end data acquisition device 100;

[0080] The mid-end data acquisition device 200 is suitable for collecting images of pharmaceuticals on the shelf 600, and the processing device 400 obtains the data for sale by identifying the image data collected by the mid-end data acquisition device 200;

[0081] The front-end data acquisition device 300 is suitable for capturing images of medicines when they are sold from the cashier counter 700 , and the processing device 400 obtains sales data by identifying the image data captured by the front-end data acquisition device 300 .

[0082] In Example 2, the back-end data collection device 100 and the front-end data collection device 300 use a barcode scanning device to collect data such as the name, production date, and expiration date of the medicine by scanning the barcode on the medicine packaging box. The front-end data collection device 300 is connected to the host of the cashier counter 700 and transmits the collected data to the processing device 400 and the host of the cashier counter 700 at the same time. The host of the cashier counter 700 can also forward the data to the processing device 400 (for example, the host of the cashier counter 700 and the processing device 400 communicate via a network connection, and the host transmits the collected data to the processing device 400). To the processing device 400, the processing device 400 transmits the adjusted billing to the host), the terminal data acquisition device uses a camera, the camera takes pictures of the medicines on the shelf 600 at regular intervals, and transmits the photographed image information to the processing device 400, the processing device 400 calculates and identifies the image data to obtain the name, production date, expiration date and other data of the medicines on the shelf 600, the processing device 400 uses a computer, the computer memory stores a computer program, and the computer program is executed by the computer processor to implement the pharmaceutical data management method as described in Example 1. The processing device 400 is connected to the host of the cash register 700 and is used to transmit the adjusted billing to the host of the cash register 700. The cashier scans the code of the selected medicines, and the host of the cash register 700 bills the medicines according to the adjusted billing. After the medicines are sold, the front-end data acquisition device 300 transmits the collected data to the processing device 400, and the processing device 400 updates the medicine data (quantity) stored in the database. For example, after one of the remaining 6 medicines A2 is sold, the quantity of medicine A2 in the database is updated to 5, and the billing of the remaining 5 medicines A2 is adjusted.

[0083] It should be noted that the pharmaceuticals in this application are commonly used medicines, such as cold medicines, vitamin C Yinqiao tablets, digestion tablets, etc.

[0084] It should be noted that pharmaceuticals are seasonal. Taking cold medicine as an example, during the off-season, the amount of medicine purchased by the pharmacy will be appropriately reduced. At this time, the problem of small amount of medicine and long sales cycle is more prominent. During the peak season, the amount of medicine is large and the sales cycle is short, but the difference in sales efficiency between new and old medicines is greater than that in the off-season (because there is a large amount and many choices, while there are only a few medicines in the off-season, and either there is no better choice or no choice is made). As long as there is a situation where users choose between new and old, the method and system of this application can play its value. The amount of waste reduced in the off-season is small, while a lot of waste can be reduced in the peak season. Hospitals or merchants can choose to use the method and system of this application for sales in the peak season and sell normally in the off-season (without using the method and system of this application).

[0085] It should be noted that Article 20 of the "Regulations on the Supervision and Administration of Drug Circulation" stipulates that "drug production and operation enterprises shall not give prescription drugs or Class A over-the-counter drugs to the public by means of bundling, giving away drugs when buying drugs, giving away drugs when buying goods, etc." On the basis of this provision, this application adopts a scheme of differentiating billing for new and old medicines to improve the sales efficiency of old medicines and reduce the waste caused by unsold and expired old medicines. Since the efficacy of new and old medicines is the same within the validity period, users can choose to purchase according to their own circumstances. For example, some people often take medicines due to physical reasons, so they can choose to buy more discounted medicines within the validity period, and there is no need to run errands to buy them many times (of course, this depends on the user's consumption habits). Some users have better physical conditions, so they can choose to buy them when they must use the medicine. Therefore, whether users will stock up on old medicines because they are cheap depends on their actual needs, and this application does not impose restrictions in this regard.

[0086] It should also be noted that the prices of similar pharmaceuticals of different brands are usually different. For example, there are Vitamin C Yinqiao tablets on the market that cost a few yuan a bottle and Vitamin C Yinqiao tablets that cost dozens of yuan a bottle. The price difference is large, but the efficacy is basically the same. Therefore, this application, under the premise of complying with the provisions of Article 20 of the "Regulations on the Supervision and Administration of Drug Circulation", distinguishes between new and old pharmaceuticals of the same brand and name and sells them at a corresponding price reduction, which will not cause public opinion.

[0087] The above embodiments are merely explanations of the present application and are not limitations of the present application. After reading this specification, those skilled in the art may make modifications to the implementation methods of the present application as needed without any creative contribution. However, as long as they are within the scope of the claims of the present application, they are protected by the patent law.

Claims

1. A pharmaceutical data management method, characterized in that: The steps include: Collect the medicine entry data when the medicine is put into the warehouse; Collect data on the pharmaceutical products on the shelves for sale; Collecting sales data of pharmaceutical products when the pharmaceutical products are sold at the cash register; Adjust the billing of pharmaceutical products based on inventory data, pending sales data, and sales data.

2. The pharmaceutical data management method according to claim 1, characterized in that: The data collected when the medicines are put into the warehouse includes: When the medicines are put into storage, image recognition is performed on the medicines to obtain the storage data, which includes the name, production date, expiration date, and storage quantity.

3. The pharmaceutical data management method according to claim 2, characterized in that: The collection of the sales data of pharmaceutical products on the shelves includes: Image recognition is performed on the medicines on the shelf to obtain the data for sale, which includes the name, production date, expiration date, and quantity for sale.

4. The pharmaceutical data management method according to claim 3, characterized in that: The sales data of the pharmaceuticals collected when the pharmaceuticals are sold from the cash register includes: When the medicines are sold at the cashier counter, image recognition is performed on the medicines to obtain the sales data, which includes the name, production date, expiration date, and sales quantity.

5. The pharmaceutical data management method according to claim 4, characterized in that: The method of adjusting the billing of pharmaceutical products according to the incoming data, the pending data, and the sold data includes: Determine the remaining quantity of pharmaceutical products, remaining quantity = quantity in stock - quantity sold; Determine the effective period of the medicine, effective period = expiration date ÷ 2 - production date ÷ 2; Determine the remaining days of the medicine, remaining days = expiration date - current date; Determine the value retention rate of pharmaceutical products, value retention rate = remaining days ÷ effective days; Adjust the billing of pharmaceutical products based on remaining quantity, remaining days, and retention rate.

6. The pharmaceutical data management method according to claim 5, characterized in that: The billing of pharmaceutical products adjusted according to the remaining quantity, remaining days, and value preservation rate includes: If the maximum preset number of days > the remaining number of days > the minimum preset number of days, the billing of the medicines will be adjusted based on the remaining quantity, remaining days, and value retention rate; otherwise, the medicines will be removed from the shelves.

7. The pharmaceutical data management method according to claim 6, characterized in that: The billing of pharmaceutical products adjusted according to the remaining quantity, remaining days, and value preservation rate includes: If the maximum preset number of days > the remaining number of days > the minimum preset number of days, and the remaining number > 5, the billing = initial billing × hedging rate.

8. The pharmaceutical data management method according to claim 7, characterized in that: The billing of pharmaceutical products adjusted according to the remaining quantity, remaining days, and value preservation rate includes: If the maximum preset number of days > the remaining number of days > the minimum preset number of days, and the remaining quantity ≤ 5, the billing = initial billing × hedging rate - initial billing × hedging rate ÷ remaining quantity.

9. A pharmaceutical data management system, characterized in that: include: The back-end data collection device is used to collect the storage data of the medicines when they are stored in the warehouse; Mid-range data collection device, used to collect data on pharmaceutical products for sale on shelves; A front-end data collection device, used to collect sales data of pharmaceuticals when the pharmaceuticals are sold from the cash register; The processing device is connected to the back-end data acquisition device, the mid-end data acquisition device, the front-end data acquisition device, and the host of the cash register, and is used to adjust the billing of medicines according to the inventory data, the data to be sold, and the sold data, and transmit the adjusted billing to the host of the cash register.

10. The pharmaceutical data management system according to claim 9, characterized in that: The back-end data acquisition device is suitable for collecting images of the medicines when they are stored in the warehouse, and the processing device obtains the storage data by identifying the image data collected by the back-end data acquisition device; The mid-end data acquisition device is suitable for collecting images of pharmaceuticals on the shelf, and the processing device obtains the data for sale by identifying the image data collected by the mid-end data acquisition device; The front-end data acquisition device is suitable for collecting images of medicines when the medicines are sold from the cash register, and the processing device obtains the sales data by identifying the image data collected by the front-end data acquisition device.

Images