Liquor sample library management method and system

Abstract

The invention relates to the technical field of inventory management, in particular to a wine sample library management method and system. According to the wine sample library management method, RFID tags are used for identifying warehousing samples with one object and one code, and rule attributes are marked for each sample; defining a rule priority through a preset business rule, and distributing a storage location for the storage sample; a warehouse checking table is generated, and the samples in the warehouse are scanned and checked; when the borrowed samples in the library correspond to the samples which are returned and put in storage, identification and examination and approval are firstly carried out, and the state of each sample is determined; if the sample is damaged or overdue, destroying the sample, directly carrying out warehouse-out operation, and not carrying out return treatment; and if the corresponding replacement materials exist, the replacement materials are put into storage according to new products to be processed. According to the wine sample library management method, real-time sample positioning and tracking and automatic, intelligent and efficient warehouse management are realized, the management cost is reduced, the management efficiency is improved, and the wine sample library management method is suitable for popularization and application.

Description

Technical Field

[0001] This invention relates to the field of inventory management technology, and in particular to a method and system for managing a wine sample warehouse. Background Technology

[0002] In the operations of many enterprises, sample warehouse management faces a series of severe challenges. The diverse range of samples in the warehouse, covering various specifications, models, and categories, makes finding a specific sample akin to searching for a needle in a haystack. Furthermore, the lack of standardized inventory reports forces staff to manually check each sample individually, a time-consuming and labor-intensive process prone to errors and omissions. In addition, the absence of an effective tracking mechanism makes it difficult to monitor the whereabouts and usage status of borrowed samples in real time. This not only affects the normal use and return of samples but also risks loss or damage, leading to unnecessary losses for the enterprise and severely hindering the efficiency and quality improvement of sample warehouse management.

[0003] To address the above problems, this invention proposes a method and system for managing wine sample libraries. Summary of the Invention

[0004] To overcome the shortcomings of existing technologies, this invention provides a simple and efficient method for managing wine sample libraries.

[0005] This invention is achieved through the following technical solution:

[0006] A method and system for managing a wine sample library includes the following steps:

[0007] Step S1: Sample warehousing management

[0008] RFID tags are used to identify each incoming sample with a unique code, and each sample is marked with a rule attribute. Rule priorities are defined through preset business rules, and available storage locations are traversed. Based on the rule attributes of the incoming samples and the business rules, storage locations are allocated to the incoming samples.

[0009] In step S1, the business rules are as follows:

[0010] High-frequency priority rule: The higher the frequency of sample retrieval, the closer the storage location is to the entrance / exit;

[0011] Weight principle: The heavier the sample entering the warehouse, the closer it is to the lower shelf; lighter samples are placed on the upper shelf to avoid uneven stress on the shelves.

[0012] Compatibility rule: Samples with mutually exclusive attributes are not allowed to be stored in the same warehouse.

[0013] In step S1, the warehouse is divided into a wine tasting warehouse, a finished wine warehouse, and a wine warehouse to be packaged.

[0014] Tasting Wine Cellar: Wines are purchased from external suppliers and used for training purposes. The intended use of the samples is described upon receipt. When wines are borrowed and returned, they are first evaluated and approved before being stored.

[0015] Finished product wine storage: Wine samples retained during product inspection are confirmed for storage after approval and are used for finished product wine sample retention; they are first stored in a temporary storage and then periodically transferred to the formal sample storage according to a custom cycle; the batch, production date and product information are clearly marked when they are stored; when borrowed and returned to storage, they are identified and approved before being stored.

[0016] Wine awaiting packaging: Wines awaiting packaging inspection are stored in the warehouse, or are manually stored. The management model is consistent with that of the wine tasting warehouse.

[0017] Step S2, Inventory Management

[0018] A warehouse inventory list is generated based on six dimensions: production date, sample category, sample source, sample name, batch, and storage location. Samples in the warehouse are scanned and inventoried, and data of completed and uncounted items are recorded and compared with the warehouse inventory list. If there are discrepancies in the inventory data, the inventory is re-counted.

[0019] It allows querying of inventory data through different dimensions, and also allows downloading and exporting of the data.

[0020] In step S2, inventory counting supports two modes: shelf counting and full warehouse counting. When counting by shelf, the warehouse manager first scans the shelf code to generate information such as inventory quantity, counted quantity, uncounted quantity and a list of samples to be counted.

[0021] After administrator approval and confirmation, the full warehouse inventory process begins; if a shortage is found by comparing with the warehouse inventory list, an outbound order is automatically generated, and the goods are released after the outbound order is approved; if a surplus is found, offline processing is notified.

[0022] Based on the sample's expiration date, early warnings are issued for samples that are about to expire or have already expired; expired data is marked with a prominent color. Exporting of warning data is also permitted.

[0023] When samples from different storage rooms within the same sample library need to be transferred, this is handled through the transfer-out and transfer-in functions.

[0024] Within the same warehouse, multiple physical samples can be selected and moved to the same location at once, based on a single target storage location.

[0025] In step S2, an administrator with management authority maintains information on the sample warehouse, warehouse location, shelf information, and product category information.

[0026] At the same time, corresponding barcodes can be printed for any shelf / location.

[0027] Maintain the basic information of the packaged wines and the information of the wines included in the package.

[0028] In step S2, a warning mechanism is set up in conjunction with the sample validity period. When the validity period of the sample entering the warehouse is lower than the custom threshold, a warning message is issued to notify the warehouse management personnel to handle it offline.

[0029] Customize the warning period for the return of borrowed samples. If the samples are not returned to the warehouse within the warning period, a warning message will be issued to notify the corresponding warehouse staff and the person who borrowed the samples.

[0030] Step S3, Sample Outbound Management

[0031] When the outbound unit is a box, an unpacking reminder is issued when finished wine samples are outbound, and a prompt is issued for other samples, asking whether unpacking is required; if the outbound unit is a box or a user feedback that unpacking is required, the unpacking operation is automatically triggered, and the box can be moved after unpacking.

[0032] When borrowed samples are returned to the warehouse, they must first be identified and approved to clarify the status of each sample.

[0033] If a sample is damaged or expired, it will be destroyed and directly issued to the warehouse without being returned. If there is a corresponding replacement material, the replacement material will be processed as a new product upon entry into the warehouse.

[0034] A wine sample library management system for implementing the above method includes:

[0035] The sample receiving management module is responsible for using RFID tags to identify each receiving sample with a unique code and marking each sample with rule attributes; defining rule priorities through preset business rules, traversing available storage locations, and allocating storage locations for receiving samples based on the rule attributes of the receiving samples and the business rules;

[0036] The inventory management module is responsible for generating a warehouse inventory list based on six dimensions: production date, sample category, sample source, sample name, batch, and inventory location; scanning samples in the warehouse for inventory, recording the data of completed and uncounted inventory, and comparing it with the warehouse inventory list. When there are discrepancies in the inventory data, the inventory is re-counted.

[0037] The sample outbound management module is responsible for issuing unpacking reminders when the outbound unit is a box, and issuing prompts for other sample outbounds, asking whether unpacking is required; if the outbound unit is a box or a user feedback that unpacking is required, the unpacking operation is automatically triggered, and the unpacking operation is supported after the box is unpacked.

[0038] When borrowed samples are returned to the warehouse, the sample outbound management module is responsible for identification and approval, clarifying the status of each sample.

[0039] When a sample is damaged or expires, the sample outbound management module is responsible for destroying the sample and directly issuing it out of the warehouse without returning it. If there is a corresponding replacement material, the replacement material will be processed as a new product upon entry into the warehouse.

[0040] A wine sample library management device includes a memory and a processor; the memory is used to store a computer program, and the processor is used to execute the computer program to implement the method steps described above.

[0041] A readable storage medium storing a computer program that, when executed by a processor, implements the method steps described above.

[0042] The beneficial effects of this invention are: the wine sample library management method realizes real-time sample positioning and tracking and automated, intelligent and efficient warehouse management, reduces management costs and improves management efficiency, and is therefore widely applicable. Attached Figure Description

[0043] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0044] Appendix Figure 1 This is a flowchart of the wine sample library management process of the present invention.

[0045] Appendix Figure 2 This is a schematic diagram of the sample library management method of the present invention. Detailed Implementation

[0046] To enable those skilled in the art to better understand the technical solutions of this invention, the technical solutions in the embodiments of this invention will be clearly and completely described below in conjunction with the embodiments of this invention. Obviously, the described embodiments are merely some embodiments of this invention, and not all embodiments. Based on the embodiments of this invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of this invention.

[0047] Currently, there are third-party mini-programs specifically for warehouse management, which can basically solve the management of sample entry and exit and inventory operations. However, they cannot achieve one-item-one-code management of samples, box code to bottle code conversion, partial outbound and early warning mechanisms, and cannot track the return of borrowed samples in real time. They can only use manual recording, which is easy to forget.

[0048] This method for managing the wine sample library includes the following steps:

[0049] Step S1: Sample warehousing management

[0050] RFID tags are used to identify each incoming sample with a unique code, and each sample is marked with a rule attribute (such as "high frequency", "heavy", "chemical"). Rule priorities are defined by preset business rules (such as category, frequency, weight, etc.) (such as frequency > weight > category). The available storage locations are traversed, and storage locations are allocated to the incoming samples based on the rule attributes of the samples and the business rules.

[0051] In step S1, the business rules are as follows:

[0052] High-frequency priority rule: The higher the frequency of sample retrieval, the closer the storage location is to the entrance / exit (such as the lower shelf of the "golden area");

[0053] Weight principle: The heavier the sample entering the warehouse, the closer it is to the lower shelf; lighter samples are placed on the upper shelf to avoid uneven stress on the shelves.

[0054] Compatibility rule: Samples with mutually exclusive properties (such as flammable and explosive materials and oxidizers) are not allowed to be stored in the same warehouse.

[0055] Example code (Python pseudocode):

[0056]

[0057]

[0058] In step S1, the warehouse is divided into a wine tasting warehouse, a finished wine warehouse, and a wine warehouse to be packaged.

[0059] Tasting Wine Cellar: Wines are purchased from external suppliers and used for training purposes. The intended use of the samples is described upon receipt. When wines are borrowed and returned, they are first evaluated and approved before being stored.

[0060] Finished product wine storage: Wine samples retained during product inspection are confirmed for storage after approval and are used for finished product wine sample retention; they are first stored in a temporary storage and then periodically transferred to the formal sample storage according to a custom cycle; the batch, production date and product information are clearly marked when they are stored; when borrowed and returned to storage, they are identified and approved before being stored.

[0061] Wine awaiting packaging: Wines awaiting packaging inspection are stored in the warehouse, or are manually stored. The management model is consistent with that of the wine tasting warehouse.

[0062] Step S2, Inventory Management

[0063] A warehouse inventory list is generated based on six dimensions: production date, sample category, sample source, sample name, batch, and storage location. Samples in the warehouse are scanned and inventoried, and data of completed and uncounted items are recorded and compared with the warehouse inventory list. If there are discrepancies in the inventory data, the inventory is re-counted.

[0064] It allows querying of inventory data through different dimensions, and also allows downloading and exporting of the data.

[0065] In step S2, inventory counting supports two modes: shelf counting and full warehouse counting. When counting by shelf, the warehouse manager first scans the shelf code to generate information such as inventory quantity, counted quantity, uncounted quantity and a list of samples to be counted.

[0066] After administrator approval and confirmation, the full warehouse inventory process begins; if a shortage is found by comparing with the warehouse inventory list, an outbound order is automatically generated, and the goods are released after the outbound order is approved; if a surplus is found, offline processing is notified.

[0067] Based on the sample's expiration date, early warnings are issued for samples that are about to expire or have already expired; expired data is marked with a prominent color. Exporting of warning data is also permitted.

[0068] When samples from different storage rooms within the same sample library need to be transferred, this is handled through the transfer-out and transfer-in functions.

[0069] Within the same warehouse, multiple physical samples can be selected and moved to the same location at once, based on a single target storage location.

[0070] In step S2, the administrator with management authority maintains the sample warehouse, warehouse location, shelf information and product category information; warehouse maintenance or changing the administrator requires approval and confirmation.

[0071] At the same time, corresponding barcodes can be printed for any shelf / location.

[0072] Maintain the basic information of the packaged wines and the information of the wines included in the package.

[0073] In step S2, a warning mechanism is set up in conjunction with the sample validity period. When the validity period of the sample entering the warehouse is lower than the custom threshold, a warning message is issued to notify the warehouse management personnel to handle it offline.

[0074] Customize the warning period for the return of borrowed samples. If the samples are not returned to the warehouse within the warning period, a warning message will be issued to notify the corresponding warehouse staff and the person who borrowed the samples.

[0075] Step S3, Sample Outbound Management

[0076] The loan is issued in units of one physical sample.

[0077] When the outbound unit is a box, an unpacking reminder is issued when finished wine samples are outbound, and a prompt is issued for other samples, asking whether unpacking is required; if the outbound unit is a box or a user feedback that unpacking is required, the unpacking operation is automatically triggered, and the box can be moved after unpacking.

[0078] When borrowed samples are returned to the warehouse, they must first be identified and approved to clarify the status of each sample.

[0079] If a sample is damaged or expired, it will be destroyed and directly issued to the warehouse without being returned. If there is a corresponding replacement material, the replacement material will be processed as a new product upon entry into the warehouse.

[0080] Table 1. Information on Wine Sample Library Management Activities

[0081]

[0082]

[0083] This wine sample library management system is used to implement the above method, including:

[0084] The sample receiving management module is responsible for identifying each receiving sample with a unique code using RFID tags, and marking each sample with rule attributes (such as "high frequency", "heavy", "chemical"); defining rule priorities (such as frequency > weight > category) through preset business rules (such as category, frequency, weight, etc.), traversing available storage locations, and allocating storage locations for receiving samples based on the rule attributes of the receiving samples and the business rules;

[0085] The inventory management module is responsible for generating a warehouse inventory list based on six dimensions: production date, sample category, sample source, sample name, batch, and inventory location; scanning samples in the warehouse for inventory, recording the data of completed and uncounted inventory, and comparing it with the warehouse inventory list. When there are discrepancies in the inventory data, the inventory is re-counted.

[0086] The sample outbound management module is responsible for issuing unpacking reminders when the outbound unit is a box, and issuing prompts for other sample outbounds, asking whether unpacking is required; if the outbound unit is a box or a user feedback that unpacking is required, the unpacking operation is automatically triggered, and the unpacking operation is supported after the box is unpacked.

[0087] When borrowed samples are returned to the warehouse, the sample outbound management module is responsible for identification and approval, clarifying the status of each sample.

[0088] When a sample is damaged or expires, the sample outbound management module is responsible for destroying the sample and directly issuing it out of the warehouse without returning it. If there is a corresponding replacement material, the replacement material will be processed as a new product upon entry into the warehouse.

[0089] The wine sample library management device includes a memory and a processor; the memory is used to store a computer program, and the processor is used to execute the computer program to implement the method steps described above.

[0090] The readable storage medium stores a computer program that, when executed by a processor, implements the method steps described above.

[0091] Compared with existing technologies, this method for managing wine sample libraries has the following characteristics:

[0092] First, it has realized a smart warehouse: by connecting and integrating equipment, samples and data in the warehouse through the Internet of Things, artificial intelligence and big data analysis technologies, the warehouse has achieved automation, intelligence and efficiency.

[0093] Secondly, it realizes RFID inventory: using sensors, RFID tags, barcodes and other equipment, it can automatically identify and sense samples, locate and track samples in real time, and automate sample inventory.

[0094] Third, it realizes IoT monitoring: global visual monitoring and early warning through artificial intelligence technology, big data analysis and other technologies.

[0095] The embodiments described above are merely one specific implementation of the present invention. Ordinary changes and substitutions made by those skilled in the art within the scope of the technical solution of the present invention should be included within the protection scope of the present invention.

Claims

1. A method and system for managing a wine sample library, characterized in that: Includes the following steps: Step S1: Sample warehousing management RFID tags are used to identify each incoming sample with a unique code, and each sample is marked with a rule attribute. Rule priorities are defined through preset business rules, and available storage locations are traversed. Based on the rule attributes of the incoming samples and the business rules, storage locations are allocated to the incoming samples. Step S2, Inventory Management A warehouse inventory list is generated based on six dimensions: production date, sample category, sample source, sample name, batch, and storage location. Samples in the warehouse are scanned and inventoried, and data of completed and uncounted items are recorded and compared with the warehouse inventory list. If there are discrepancies in the inventory data, the inventory is re-counted. Step S3, Sample Outbound Management When the outbound unit is a box, an unpacking reminder is issued when finished wine samples are outbound, and a prompt is issued for other samples, asking whether unpacking is required; if the outbound unit is a box or a user feedback that unpacking is required, the unpacking operation is automatically triggered, and the box can be moved after unpacking. When borrowed samples are returned to the warehouse, they must first be identified and approved to clarify the status of each sample. If a sample is damaged or expired, it will be destroyed and directly issued to the warehouse without being returned. If there is a corresponding replacement material, the replacement material will be processed as a new product upon entry into the warehouse.

2. The method for managing a wine sample library according to claim 1, characterized in that: In step S1, the business rules are as follows: High-frequency priority rule: The higher the frequency of sample retrieval, the closer the storage location is to the entrance / exit; Weight principle: The heavier the sample entering the warehouse, the closer it is to the lower layer of the warehouse; Compatibility rule: Samples with mutually exclusive attributes are not allowed to be stored in the same warehouse.

3. The method for managing a wine sample library according to claim 2, characterized in that: In step S1, the warehouse is divided into a wine tasting warehouse, a finished wine warehouse, and a wine warehouse to be packaged. Tasting Wine Cellar: Wines are purchased from external suppliers and used for training purposes. The intended use of the samples is described upon receipt. When wines are borrowed and returned, they are first evaluated and approved before being stored. Finished product wine storage: Wine samples retained during product inspection are confirmed for storage after approval and are used for finished product wine sample retention; they are first stored in a temporary storage and then periodically transferred to the formal sample storage according to a custom cycle; the batch, production date and product information are clearly marked when they are stored; when borrowed and returned to storage, they are identified and approved before being stored. Wine awaiting packaging: Wines awaiting packaging inspection are stored in the warehouse, or are manually stored. The management model is consistent with that of the wine tasting warehouse.

4. The method for managing a wine sample library according to claim 1, characterized in that: In step S2, inventory counting supports two modes: shelf counting and full warehouse counting. When counting by shelf, the warehouse manager first scans the shelf code to generate information such as inventory quantity, counted quantity, uncounted quantity and a list of samples to be counted. After administrator approval and confirmation, the full inventory count process will commence. If a shortage is found when comparing with the warehouse inventory list, an outbound order will be automatically generated. The outbound order will be approved before the goods are released. If an inventory surplus is found, notify the offline staff for processing. Based on the sample's expiration date, early warnings are issued for samples that are about to expire or have already expired.

5. The method for managing a wine sample library according to claim 4, characterized in that: In step S2, an administrator with management authority maintains information on the sample warehouse, warehouse location, shelf information, and product category information. Maintain the basic information of the packaged wines and the information of the wines included in the package.

6. The method for managing a wine sample library according to claim 4, characterized in that: In step S2, a pre-warning mechanism is set based on the sample expiration date. When the expiration date of an incoming sample is lower than a pre-defined threshold, a pre-warning message is issued. Notify warehouse staff to handle the matter offline; Customize the warning period for the return of borrowed samples. If the samples are not returned to the warehouse within the warning period, a warning message will be issued to notify the corresponding warehouse staff and the person who borrowed the samples.

7. A wine sample library management system, characterized in that: To implement the method according to any one of claims 1 to 6, comprising: The sample receiving management module is responsible for using RFID tags to identify each receiving sample with a unique code and marking each sample with rule attributes; defining rule priorities through preset business rules, traversing available storage locations, and allocating storage locations for receiving samples based on the rule attributes of the receiving samples and the business rules; The inventory management module is responsible for generating a warehouse inventory list based on six dimensions: production date, sample category, sample source, sample name, batch, and inventory location; scanning samples in the warehouse for inventory, recording the data of completed and uncounted inventory, and comparing it with the warehouse inventory list. When there are discrepancies in the inventory data, the inventory is re-counted. The sample outbound management module is responsible for issuing unpacking reminders when the outbound unit is a box, and issuing prompts for other sample outbounds, asking whether unpacking is required; if the outbound unit is a box or a user feedback that unpacking is required, the unpacking operation is automatically triggered, and the unpacking operation is supported after the box is unpacked. When borrowed samples are returned to the warehouse, the sample outbound management module is responsible for identification and approval, clarifying the status of each sample. When a sample is damaged or expires, the sample outbound management module is responsible for destroying the sample and directly issuing it out of the warehouse without returning it. If there is a corresponding replacement material, the replacement material will be processed as a new product upon entry into the warehouse.

8. A wine sample storage management device, characterized in that: It includes a memory and a processor; the memory is used to store a computer program, and the processor is used to execute the computer program to implement the method as described in any one of claims 1 to 6.

9. A readable storage medium, characterized in that: The readable storage medium stores a computer program that, when executed by a processor, implements the method as described in any one of claims 1 to 6.

Images