WO2019091076A1

WO2019091076A1 - Method and device for managing bill of material, and computer-readable storage medium

Info

Publication number: WO2019091076A1
Application number: PCT/CN2018/086332
Authority: WO
Inventors: 李六七
Original assignee: 深圳前海硬之城信息技术有限公司
Priority date: 2017-11-07
Filing date: 2018-05-10
Publication date: 2019-05-16
Also published as: CN109754200A

Abstract

The present solution is applicable to the technical field of material management, and provides a method and device for managing a Bill of Material (BOM), and a computer-readable storage medium. The method comprises: obtaining a BOM; identifying material types and quantities in the BOM according to a prebuilt product database, and querying, according to the material types, relevant material information from the product database, the material information comprising material prices corresponding to materials provided by different merchants on different delivery dates; recommending a material purchase scheme for a user according to the material quantities and the material information, and visually displaying the material purchase scheme to the user, the material purchase scheme comprising merchants from which materials are to be purchased, material purchase costs, and material delivery dates. According the present solution, BOMs in different formats can be identified, and a material purchase scheme can be visually recommended for a user according to the BOMs, so that communication disorders between an engineer and a purchaser are eliminated, and labor and time costs are reduced for enterprises in respect of scheme design and material purchase decision-making.

Description

Bill of materials management method, device and computer readable storage medium

Technical field

The invention belongs to the technical field of material management, and in particular relates to a bill of materials management method, device and computer readable storage medium.

Background technique

BOM (Bill of Material) is a technical description of the product structure, which includes information on various materials, and plays a fundamental role in the production, planning, business, procurement, cost accounting and technical management of the enterprise. The role is the core document of manufacturing.

The BOM management system is the bill of materials management system of the product, which is mainly used to maintain and control the establishment, circulation, change, settlement and material procurement of the BOM. The emergence of the BOM management system has produced a qualitative leap in the level of product material management. However, the existing BOM management system can only provide a simple quotation function for the materials purchased by the enterprise based on the bill of materials. There is a uniform requirement for the BOM format, a standard model is required for the content written by the BOM, and different formats and non-standards cannot be intelligently recognized. The BOM of the model cannot provide more in-depth services such as batch purchase price comparison, suitable delivery selection, intelligent optimal recommendation and visual display.

technical problem

In view of the above, the present invention provides a bill of materials management method and apparatus, and a computer readable storage medium, which solves the problem that the BOM management system has a unified requirement for the BOM format in the prior art, and requires a standard model for the content of the BOM writing, and cannot be intelligent. Identifying BOMs of different formats and non-standard models does not provide more in-depth service issues such as bulk purchase price comparison, appropriate delivery selection, intelligent optimal recommendation and visual display.

Technical solution

A first aspect of the invention provides a bill of materials management method comprising:

Obtain a list of materials that the user needs to purchase;

Identifying the material type and quantity in the material list according to the pre-established product database, and querying related material information from the pre-established product database according to the material type; the material information includes different materials provided by different merchants. The material price corresponding to the period;

The material procurement plan is recommended for the user according to the quantity of the material and the material information, and the material procurement plan is displayed to the user in a visual form, and the material procurement plan includes the material purchasing business, the material bulk purchasing cost, and the material delivery date.

A second aspect of the present invention provides a bill of materials management apparatus comprising:

a bill of materials acquisition unit for obtaining a bill of materials that the user needs to purchase;

a bill of material identification unit, configured to identify a material type and quantity in the bill of materials according to a pre-established product database;

a material matching unit, configured to query related product information from the product database according to the material type; the material information includes a material price corresponding to a different merchant providing the material under different delivery periods;

a procurement plan recommendation unit, configured to recommend a material procurement plan to the user according to the quantity of the material and the material information, and display the material procurement plan to the user in a visual form, the material procurement plan includes a material purchasing business, and a material bulk purchasing Cost and material delivery.

A third aspect of the present invention provides a bill of materials management apparatus including a memory, a processor, and a computer program stored in the memory and operable on the processor, wherein the processor executes the computer The steps of the method as described in the first aspect above are implemented at the time of the program.

A fourth aspect of the invention provides a computer readable storage medium storing a computer program, wherein the computer program is executed by a processor to implement the steps of the method as described in the first aspect above .

Beneficial effect

The invention can realize the intelligent identification of the material list of different formats and non-standard models by using the product type and the quantity in the material list according to the pre-established product database, so that the user does not need to manually adjust before using the material list management system. The format of the bill of materials simplifies the user operation; in addition, after identifying the type and quantity of the materials in the bill of materials; querying related material information from the product database according to the material type; the material information includes different merchants Providing a material price corresponding to the material under different delivery periods; and then recommending a material procurement plan for the user according to the quantity of the material and the material information, the material procurement plan includes a material purchasing merchant, a material bulk purchasing cost, and a material delivery The project can be used to recommend suitable material procurement plans for users based on the bill of materials, and display them in a visual way, eliminating communication barriers between engineers and procurement, saving manpower and time costs for the company's design and material procurement decisions. .

DRAWINGS

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the embodiments or the description of the prior art will be briefly described below. It is obvious that the drawings in the following description are only the present invention. For some embodiments, other drawings may be obtained from those of ordinary skill in the art in light of the inventive workability.

1 is a schematic flowchart showing an implementation process of a bill of materials management method according to Embodiment 1 of the present invention;

2 is a schematic diagram showing an implementation flow of a bill of materials management method according to Embodiment 2 of the present invention;

3 is a schematic structural diagram of a bill of materials management apparatus according to Embodiment 3 of the present invention;

4 is a schematic structural diagram of a bill of materials management apparatus according to a preferred embodiment of the third embodiment of the present invention;

FIG. 5 is a schematic structural diagram of a bill of materials management apparatus according to Embodiment 4 of the present invention.

Embodiments of the invention

In the following description, for purposes of illustration and description However, it will be apparent to those skilled in the art that the present invention may be practiced in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the invention.

In order to explain the technical solution described in the present invention, the following description will be made by way of specific embodiments.

Example 1

FIG. 1 is a flowchart showing an implementation process of a bill of materials management method according to an embodiment of the present invention. The main body of the method is the bill of materials management device described in the embodiment of the present invention. Referring to FIG. 1 , the implementation process of the bill of materials management method provided by this embodiment is as follows:

Step S101: Obtain a bill of materials that the user needs to purchase.

In this embodiment, the obtaining the bill of materials purchased by the user includes receiving materials submitted by the user to the bill of materials management device by means of copying, uploading, importing, dragging, image recognition or voice input of the unformatted document. List. The bill of materials includes the types and quantities of materials that the user needs to purchase. The types of materials include, but are not limited to, material names, brands, models, parameters, price ranges, and material purchase delivery dates.

Step S102, identifying a material type and quantity in the material list according to a pre-established product database, and querying related product information from the product database according to the material type; the material information includes materials provided by different merchants. The price of the material corresponding to the different delivery period.

In this embodiment, the identifying the type and quantity of the materials in the bill of materials according to the pre-established product database specifically includes:

Determining whether the bill of materials is a list in the form of a header;

If the bill of materials has a list in the form of a header, identifying valid material data in the bill of materials according to keywords in the header and the product database;

If the bill of materials has no list in the form of a header or a list in the form of a non-tab, the data in the bill of materials is parsed line by line, and the parsed data content and the material data in the product database are parsed. The characteristics are compared to determine whether the data is valid material data;

A valid bill of materials is extracted based on the identified valid material data, the bill of materials including the type and quantity of materials purchased by the user.

In this embodiment, if the bill of materials is a list in the form of a table without a header format, the cells in the bill of materials are parsed line by line, the contents in each cell are identified, and the The content is compared to the material data characteristics in the pre-trained product database to determine if the content in the cell is valid material data.

In this embodiment, if the bill of materials is a document content without a fixed format, the document content is first processed by word segmentation, and then the document data segmentation is sequentially read, the document data segmentation is performed, and the material features in the pre-trained product database are A comparison is made to determine whether the document data segmentation is valid material data.

The identification method of the material list used in the embodiment can identify the material list in different formats, so that the user can manually adjust the format of the material list without inputting the material list, thereby simplifying the user operation.

Preferably, in this embodiment, before step S101, the method further includes:

Collecting relevant information of the inbound product, and storing related information of the product into a product database; the related information of the product includes a brand, a model, a name, a price, and parameter information of the product;

Performing word segmentation on the related information of the product, and creating a product index for the product according to the word segmentation processing result, the product index includes: a brand index, a model index, a name index, a price index, a parameter index, and a similar product index. Preferably, the rules for word segmentation can be custom. For example, data collection and data cleaning of related products of the product are performed by big data, and machine learning and mining are performed based on the data, thereby obtaining rules for processing word segmentation and realizing custom word segmentation.

Preferably, by optimizing the data mining engine's search mode, fuzzy information definition and/or precise information definition, it is ensured that the latest information can be quickly discovered, the dynamic message routing is more intelligent, and the accurate calibration of useful information nodes is achieved, and Through these calibrated useful information, some timely updated information is involved to improve the search efficiency of the data mining engine, reduce the time of blind search, make the search more targeted, make the search at different times more relevant, and enable the customer to track The ins and outs of information are conducive to statistical analysis of information.

Further, optimizing the search mode of the data mining engine may specifically include: intelligent scenario application reasoning. Intelligent scene application reasoning makes information evolve from simple fragment to logical direction. It is represented in logical event graphing and standardization, which enables data mining engine to compare standard logical scenes and obtain logical meaning of scenes when obtaining key segments. Improve the extraction efficiency of useful data and reduce the interference of spam.

In this embodiment, the related information of the product is subjected to word segmentation processing by using the three-robbery method, and the related information of the product may be subjected to auxiliary word segmentation processing using the IK word segmentation method.

In this embodiment, querying related material information from the product database according to the material type specifically includes:

Obtaining a brand to which each material in the material category belongs, and querying, in the product database, product data that matches a brand to which the material belongs;

Identifying the material number of each material in the material category, and filtering product data matching the material number of the material from the product data matching the brand of the material according to the material number;

Obtaining key parameters of each material in the material category, and filtering material data that meets user requirements from product data matching the material number of the material according to the key parameter;

The material data meeting the user's demand is used as the searched material information related to the material type.

In this embodiment, the user can indicate the brand to which the purchased material belongs in the bill of materials, so that the bill of materials management system can obtain the brand to which the user belongs according to the brand that the user needs to purchase in the product database after obtaining the bill of materials. Search for product data that matches it.

In this embodiment, the material type in the bill of materials may further include a material number of the material required by the user, and the material number is generally composed of numbers and letters, and may also include some commonly used punctuation marks, for example: Lines, slashes, double quotes, etc. After obtaining the material number of the purchased material required by the user, the material list management system selects the product data matching the material number from the product data matching the brand according to the material number, and specifically:

After obtaining the material number of the purchased material required by the user, the material list management system searches for the same material product with the material number from the product data matching the brand through a round robin manner;

If there is a material product with the same material number, the same material product is filtered out from the previous product data for the user to select;

If there is no material product with the same material number, it means that the material number is wrong. At this time, the machine number based on the error correction coding corrects the material number, and then the material is processed according to the material number after the error correction processing. match. Wherein, the error correction coding based machine learning performs error correction processing on the material number, including:

Querying the material number that is close to the material number from the product data matching the brand according to the material number, and replacing the material number with the found material number that is close to the material number.

Preferably, in the embodiment, the material list may further include a material parameter of the material required by the user. After obtaining the material data matching the material number, the material list management system may further analyze the material parameter information of the material data, and analyze whether the material parameter information meets the material parameter recorded on the user material list. The information requirement is to filter out the materials whose material parameters meet the user requirements from the material data matching the material number, and to ensure that the optimal materials are recommended to the user.

Step S103, recommending a material procurement plan for the user according to the quantity of the material and the material information, and displaying the material procurement plan to the user in a visual form, the material procurement plan includes a material purchasing business, a material bulk purchasing cost, and a material delivery. period.

In this embodiment, after obtaining the material information matching the material type, the material list management system calculates a plurality of material procurement plans according to the material data purchased by the user and the material information, and then The optimal material procurement plan that meets the user's material purchase delivery period and the lowest procurement cost is selected from a plurality of material procurement plans, and the output of the optimal material procurement plan is displayed to the user. While recommending the optimal material procurement plan to the user, it is also possible to calculate the estimated cost savings of the procurement plan relative to other procurement plans, and output the estimated cost savings to the user.

As can be seen from the above, the bill of materials management method provided in this embodiment can realize the intelligent identification of bills of materials of different formats and non-standard models by using the type and quantity of materials in the bill of materials according to a pre-established product database. This eliminates the need for the user to manually adjust the format of the bill of materials before using the bill of materials management system, which simplifies the user's operation; in addition, since the type and quantity of the materials in the bill of materials are identified, the pre-established Querying relevant material information in the product database; the material information includes material prices corresponding to different materials provided by different merchants under different delivery periods; and then recommending material procurement plans according to the quantity of materials and the material information, The material procurement plan includes the material procurement business, the material bulk procurement cost and the material delivery date, so that it can recommend a suitable material procurement plan for the user according to the material list, and display it in a visual way, eliminating the communication barrier between the engineer and the procurement. For the enterprise Save manpower and time costs on the design and material procurement decisions.

Example 2

2 is a schematic diagram of an implementation flow of a bill of materials management method according to an embodiment of the present invention. The main body of the method is a bill of materials management apparatus provided by another embodiment of the present invention. As shown in FIG. 2, the steps S201 to S203 in the method are completely the same as the steps S101 to S103 in the previous embodiment, and therefore will not be described again, which is equivalent to the previous embodiment. In this embodiment, The material information further includes the parameter information of the material, the supplier information, the inventory information, and the service life. The method for managing the material list provided in this embodiment further includes:

Step S204, obtaining parameter information of the material in the material procurement plan recommended by the user, analyzing parameter information of the material, determining whether the material is environmentally friendly, prompting the user according to the judgment result; and/or,

Step S205, obtaining supplier information of materials in the material procurement plan recommended by the user, determining, according to the supplier information of the materials, whether the product has a risk of discontinuing production, and prompting the user according to the judgment result; and/or,

Step S206, obtaining the inventory information and the service life of the material in the material procurement plan recommended by the user, determining whether the out-of-stock risk is stored according to the inventory information and the service life of the material, and prompting the user according to the judgment result.

In this embodiment, the bill of materials management device obtains the constituent components of the product by analyzing the parameter information of the material, and then determines whether the material is an environmentally friendly product according to the composition of the material. For example, if the lead material is analyzed and the lead content exceeds the national safety standard, the material is a non-environmental product, and the user is reminded of the risk.

In this embodiment, the bill of materials management device determines whether the product has a risk of discontinuation by analyzing supplier information of the product, wherein the supplier information includes the number of suppliers and the production plan information of each supplier, if If the number of suppliers is lower than the preset threshold, the generation plans of the suppliers are further analyzed to determine whether the materials have a risk of shutdown. If there is a risk of discontinuation, the user is prompted for risks, so that the user can take countermeasures as soon as possible.

In this embodiment, the bill of materials management device can analyze and judge whether there is a shortage of goods according to the inventory information of the recommended materials and the service life of the materials, and if there is a shortage of goods, prompt the user to make the user timely Take other countermeasures.

Compared with the previous embodiment, the bill of materials management system provided by the embodiment can further evaluate various risks such as non-environmental protection, production stoppage, and production stoppage of the enterprise material procurement and storage, and prompt the user for risk, so that the user can be recommended to be excluded. After the risk of production suspension, non-environmental protection, and shortage of goods, it is conducive to the formation of a long-term stable supply chain material procurement plan, further enhancing the user experience.

Example 3

FIG. 3 is a schematic structural diagram of a bill of materials management apparatus according to Embodiment 3 of the present invention. Only the parts related to the present embodiment are shown for convenience of explanation.

As shown in FIG. 3, the bill of materials management apparatus 3 provided in this embodiment includes:

The bill of material obtaining unit 31 is configured to obtain a bill of materials that the user needs to purchase;

The bill of material identification unit 32 is configured to identify the type and quantity of the materials in the bill of materials according to a pre-established product database;

The material matching unit 33 is configured to query related product information from the product database according to the material type; the material information includes price of the material corresponding to different materials provided by different merchants under different delivery dates;

The procurement plan recommendation unit 34 is configured to recommend a material procurement plan to the user according to the quantity of the material and the material information, and display the material procurement plan to the user in a visual form, the material procurement plan includes a material purchasing merchant, a material batch Purchasing costs and material delivery.

Optionally, the bill of material identification unit 32 is specifically configured to:

Determining whether the bill of materials is a list in the form of a header;

Optionally, the bill of materials management device 3 further includes:

The product database establishing unit 35 is configured to collect related information of the inbound product, and store related information of the product into a product database; the related information of the product includes a brand, a model, a name, a price, and a parameter information of the product. ;

The product index creating unit 36 is configured to perform word segmentation processing on the related information of the product, and create a product index for the product according to the word segmentation processing result, where the product index includes: a brand index, a model index, a name index, a price index, and a parameter. Index and similar product index.

Optionally, the material matching unit 33 is specifically configured to:

Optionally, referring to FIG. 4, in another embodiment, the bill of material management device 3 further includes a risk assessment and prompting unit 37, configured to:

Obtaining parameter information of the material in the material procurement plan recommended by the user, analyzing parameter information of the material, determining whether the material is environmentally friendly, prompting the user according to the judgment result; and/or,

Obtaining the supplier information of the material in the material procurement plan recommended by the user, determining whether the product has a risk of discontinuation according to the supplier information of the material, and prompting the user according to the judgment result; and/or,

Obtain the inventory information and the service life of the materials in the material procurement plan recommended by the user. According to the inventory information and the service life of the materials, determine whether there is a shortage risk, and prompt the user according to the judgment result.

It should be noted that the respective units in the foregoing apparatus provided by the embodiments of the present invention are based on the same concept as the method embodiment of the present invention, and the technical effects thereof are the same as the method embodiments of the present invention. For details, refer to the method of the present invention. The description in the embodiments will not be repeated here.

Therefore, it can be seen that the bill of materials management system provided by the embodiment of the invention can also realize intelligently identifying bills of materials of different formats and non-standard models, so that the user does not need to manually adjust the format of the bill of materials before using the bill of materials management system, which simplifies. User operation; in addition, according to the bill of materials, the user can recommend a suitable material procurement plan and display it in a visual way, eliminating the communication barrier between the engineer and the procurement, saving the manpower and the enterprise in the design and material procurement decision. Time costs.

It should be understood that the size of the sequence of the steps in the above embodiments does not imply a sequence of executions, and the order of execution of the processes should be determined by its function and internal logic, and should not be construed as limiting the implementation of the embodiments of the present invention.

Example 4

Figure 5 is a schematic diagram of a bill of materials management apparatus according to a fourth embodiment of the present invention. As shown in FIG. 5, the bill of materials management apparatus of this embodiment includes a processor 50, a memory 51, and a computer program 52 stored in the memory 51 and operable on the processor 50. The processor 50, when executing the computer program 52, implements the steps in the various method embodiments described above, such as steps 101 through 104 shown in FIG. Alternatively, when the processor 50 executes the computer program 52, the functions of the modules/units in the above-described respective device embodiments are implemented, such as the functions of the modules 31 to 34 shown in FIG.

Illustratively, the computer program 52 can be partitioned into one or more modules/units that are stored in the memory 51 and executed by the processor 50 to complete this invention. The one or more modules/units may be a series of computer program instructions that are capable of performing a particular function, the instruction segments being used to describe the execution of the computer program 52 in the bill of materials management device. For example, the computer program 52 can be divided into a bill of material obtaining unit 31, a bill of material identifying unit 32, a material matching unit 33, and a purchasing plan recommending unit 34. The specific functions of each unit are as follows:

The procurement plan recommending unit 34 is configured to recommend a material procurement plan for the user according to the quantity of the material and the material information, and display the material procurement plan to the user in a visual form, the material procurement plan includes material purchasing business, material bulk purchasing Cost and material delivery.

The bill of material management device 5 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The bill of material management device 5 may include, but is not limited to, the processor 50 and the memory 51. It will be understood by those skilled in the art that FIG. 5 is only an example of the bill of materials management device, does not constitute a limitation of the bill of materials management device 5, may include more or less components than the illustration, or combine some components, or Different components, such as the bill of material management device 5, may also include input and output devices, network access devices, buses, and the like.

The so-called processor 50 can be a central processing unit (Central Processing Unit, CPU), can also be other general-purpose processors, digital signal processors (DSP), application specific integrated circuits (Application Specific Integrated Circuit (ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor or any conventional processor or the like.

The memory 51 may be an internal storage unit of the bill of materials management device, such as a hard disk or a memory of the bill of materials management device. The memory 51 may also be an external storage device of the bill of materials management device, such as a plug-in hard disk provided on the bill of materials management device, and a smart memory card (Smart Media) Card, SMC), Secure Digital (SD) card, Flash Card, etc. Further, the memory 51 may also include both an internal storage unit of the bill of materials management device and an external storage device. The memory 51 is used to store the computer program and other programs and data required by the terminal. The memory 51 can also be used to temporarily store data that has been output or is about to be output.

It will be apparent to those skilled in the art that, for convenience and brevity of description, only the division of each functional unit and module described above is exemplified. In practical applications, the above functions may be assigned to different functional units as needed. The module is completed by dividing the internal structure of the device into different functional units or modules to perform all or part of the functions described above. Each functional unit and module in the embodiment may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit, and the integrated unit may be hardware. Formal implementation can also be implemented in the form of software functional units. In addition, the specific names of the respective functional units and modules are only for the purpose of facilitating mutual differentiation, and are not intended to limit the scope of protection of the present application. For the specific working process of the unit and the module in the foregoing system, reference may be made to the corresponding process in the foregoing method embodiment, and details are not described herein again.

In the above embodiments, the descriptions of the various embodiments are different, and the parts that are not detailed or described in a certain embodiment can be referred to the related descriptions of other embodiments.

Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the various examples described in connection with the embodiments disclosed herein can be implemented in electronic hardware or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the solution. A person skilled in the art can use different methods for implementing the described functions for each particular application, but such implementation should not be considered to be beyond the scope of the present invention.

In the embodiments provided by the present invention, it should be understood that the disclosed device/list management device and method may be implemented in other manners. For example, the device/list management device embodiment described above is merely illustrative. For example, the division of the module or unit is only a logical function division, and the actual implementation may have another division manner, for example, multiple Units or components may be combined or integrated into another system, or some features may be omitted or not implemented. In addition, the mutual coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interface, device or unit, and may be in electrical, mechanical or other form.

The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of a software functional unit.

The integrated modules/units, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. Based on such understanding, the present invention implements all or part of the processes in the foregoing embodiments, and may also be completed by a computer program to instruct related hardware. The computer program may be stored in a computer readable storage medium. The steps of the various method embodiments described above may be implemented when the program is executed by the processor. Wherein, the computer program comprises computer program code, which may be in the form of source code, object code form, executable file or some intermediate form. The computer readable medium can include any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a removable hard drive, a magnetic disk, an optical disk, a computer memory, a read only memory (ROM, Read-Only) Memory), random access memory (RAM, Random) Access Memory), electrical carrier signals, telecommunications signals, and software distribution media. It should be noted that the content contained in the computer readable medium may be appropriately increased or decreased according to the requirements of legislation and patent practice in a jurisdiction, for example, in some jurisdictions, according to legislation and patent practice, computer readable media It does not include electrical carrier signals and telecommunication signals.

The embodiments described above are only for explaining the technical solutions of the present invention, and are not intended to be limiting; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art will understand that The technical solutions described in the examples are modified, or some of the technical features are equivalently replaced; and the modifications or substitutions do not deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be included in Within the scope of protection of the present invention.

Claims

A bill of materials management method, comprising:

Obtain a list of materials that the user needs to purchase;

Identifying the material type and quantity in the material list according to the pre-established product database, and querying related product information from the product database according to the material type; the material information includes materials provided by different merchants at different delivery dates The corresponding material price;

The material procurement plan is recommended for the user according to the quantity of the material and the material information, and the material procurement plan is displayed to the user in a visual form, and the material procurement plan includes the material purchasing business, the material bulk purchasing cost, and the material delivery date.
The bill of materials management method according to claim 1, wherein the identifying the item type and quantity in the bill of materials according to the pre-established product database comprises:

Determining whether the bill of materials is a list in the form of a header;

If the bill of materials has a list in the form of a header, identifying valid material data in the bill of materials according to keywords in the header and the product database;

If the bill of materials has no list in the form of a header or a list in the form of a non-tab, the data in the bill of materials is parsed line by line, and the parsed data content and the material data in the product database are parsed. The characteristics are compared to determine whether the data is valid material data;

A valid bill of materials is extracted based on the identified valid material data, the bill of materials including the type and quantity of materials purchased by the user.
The bill of materials management method according to claim 1, wherein the obtaining the bill of materials to be purchased by the user further comprises:

Collecting relevant information of the inbound product, and storing related information of the product into a product database; the related information of the product includes a brand, a model, a name, a price, and parameter information of the product;

Performing word segmentation on the related information of the product, and creating a product index for the product according to the word segmentation processing result, the product index includes: a brand index, a model index, a name index, a price index, a parameter index, and a similar product index.
The bill of materials management method according to claim 1, wherein the querying the related material information from the pre-established product database according to the type and quantity of the materials comprises:

Obtaining a brand to which each material in the material category belongs, and querying, in the product database, product data that matches a brand to which the material belongs;

Identifying the material number of each material in the material category, and filtering product data matching the material number of the material from the product data matching the brand of the material according to the material number;

Obtaining key parameters of each material in the material category, and filtering material data that meets user requirements from product data matching the material number of the material according to the key parameter;

The material data meeting the user's demand is used as the searched material information related to the material type.
The bill of materials management method according to claim 1, wherein the material information further includes parameter information of the material, supplier information, inventory information, and service life, and the recommended quantity is based on the quantity of the material and the material information. After the material procurement plan, it also includes:

Obtaining parameter information of the material in the material procurement plan recommended by the user, analyzing parameter information of the material, determining whether the material is environmentally friendly, prompting the user according to the judgment result; and/or,

Obtaining the supplier information of the material in the material procurement plan recommended by the user, determining whether the product has a risk of discontinuation according to the supplier information of the material, and prompting the user according to the judgment result; and/or,

Obtain the inventory information and the service life of the materials in the material procurement plan recommended by the user. According to the inventory information and the service life of the materials, determine whether there is a shortage risk, and prompt the user according to the judgment result.
A bill of materials management device, comprising:

a bill of materials acquisition unit for obtaining a bill of materials that the user needs to purchase;

a bill of material identification unit, configured to identify a material type and quantity in the bill of materials according to a pre-established product database;

a material matching unit, configured to query related product information from the product database according to the material type; the material information includes material prices corresponding to materials provided by different merchants under different delivery dates;

a procurement plan recommendation unit, configured to recommend a material procurement plan to the user according to the quantity of the material and the material information, and display the material procurement plan to the user in a visual form, the material procurement plan includes a material purchasing business, and a material bulk purchasing Cost and material delivery.
The bill of materials management device according to claim 6, wherein the bill of material identification unit is specifically configured to:

Determining whether the bill of materials is a list in the form of a header;

If the bill of materials has a list in the form of a header, identifying valid material data in the bill of materials according to keywords in the header and the product database;

If the bill of materials has no list in the form of a header or a list in the form of a non-tab, the data in the bill of materials is parsed line by line, and the parsed data content and the material data in the product database are parsed. The characteristics are compared to determine whether the data is valid material data;

A valid bill of materials is extracted based on the identified valid material data, the bill of materials including the type and quantity of materials purchased by the user.
The bill of materials management device of claim 6 further comprising:

a product database establishing unit, configured to collect related information of the inbound product, and store related information of the product into a product database; the related information of the product includes a brand, a model, a name, a price, and parameter information of the product;

a product index creating unit, configured to perform word segmentation processing on related information of the product, and create a product index for the product according to the word segmentation processing result, where the product index includes: a brand index, a model index, a name index, a price index, and a parameter index And similar product index.
The bill of materials management device according to claim 6, wherein the material matching unit is specifically configured to:

Obtaining a brand to which each material in the material category belongs, and querying, in the product database, product data that matches a brand to which the material belongs;

Identifying the material number of each material in the material category, and filtering product data matching the material number of the material from the product data matching the brand of the material according to the material number;

Obtaining key parameters of each material in the material category, and filtering material data that meets user requirements from product data matching the material number of the material according to the key parameter;

The material data meeting the user's demand is used as the searched material information related to the material type.
The bill of materials management apparatus according to claim 6, further comprising: a risk assessment and prompting unit, configured to:

Obtaining parameter information of the material in the material procurement plan recommended by the user, analyzing parameter information of the material, determining whether the material is environmentally friendly, prompting the user according to the judgment result; and/or,

Obtaining the supplier information of the material in the material procurement plan recommended by the user, determining whether the product has a risk of discontinuation according to the supplier information of the material, and prompting the user according to the judgment result; and/or,

Obtain the inventory information and the service life of the materials in the material procurement plan recommended by the user. According to the inventory information and the service life of the materials, determine whether there is a shortage risk, and prompt the user according to the judgment result.
A bill of materials management apparatus comprising a memory, a processor, and a computer program stored in the memory and operable on the processor, wherein the processor executes the computer program as claimed The steps of any of the methods of any of 1 to 5.
A computer readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the steps of the method of any one of claims 1 to 5.