A method, device and equipment for processing information of furniture production materials

Abstract

The application discloses a kind of furniture production material information processing method, device and equipment, relate to furniture production manufacturing technical field, comprising: receiving furniture production scheme;According to the furniture production scheme, obtain the material information needed for furniture production;According to the material information, query the real-time inventory data of factory material warehouse in factory ERP system;When real-time inventory data is greater than 0, according to the material information in the factory material warehouse matching homologous material product or same process material product;When matching succeeds, use homologous material or same process material in factory material warehouse as furniture production material;When matching fails, or real-time inventory data is less than or equal to 0, identify homologous material or same process material in supplier system, and generate pre-purchase notice.The application can realize front-end design and factory inventory and supplier's automatic seamless docking, improve material information processing efficiency, reduce inventory backlog, optimize resource allocation.

Description

Technical Field

[0001] This invention relates to the field of furniture manufacturing technology, and in particular to a method, apparatus and equipment for processing furniture production material information. Background Technology

[0002] In the manufacturing sectors of custom furniture, panel furniture, and whole-house customization, production splitting is a crucial link connecting front-end design with back-end factory manufacturing. In existing technological solutions in this field, designers use drawing software to complete product designs, generating a list of materials including boards and hardware. This list is then imported into an Enterprise Resource Planning (ERP) system, where the system or personnel check inventory against historical data or static snapshots of the factory warehouse. If insufficient inventory is found, supplier information is further queried and procurement processes are arranged. Throughout this process, the material requirements from the design end and the real-time inventory status from the factory end are linked through step-by-step operations, retrieving and matching materials in the database according to preset material attribute rules to achieve the preparation and scheduling of production materials.

[0003] However, in existing technologies, due to the lag in data interaction between the design and inventory management stages, it is impossible to dynamically grasp the complex status of materials in transit, awaiting shipment, and already occupied in real time. This makes it difficult to quickly and accurately identify alternative materials of the same origin or process when inventory fluctuates, resulting in frequent material shortages or stockpiles. Summary of the Invention

[0004] In view of the above, the present invention aims to provide a method, apparatus and equipment for processing furniture production material information, so as to solve the aforementioned technical problems.

[0005] The technical solution adopted in this invention is as follows:

[0006] This invention provides a method for processing furniture manufacturing material information, including:

[0007] Receive furniture production plans;

[0008] Based on the furniture production plan, obtain the material information required for furniture production;

[0009] Based on the material information, query the real-time inventory data of the factory's material warehouse in the factory's ERP system;

[0010] When the real-time inventory data is greater than 0, match products of the same source material or products of the same process in the factory material library according to the material information.

[0011] When a match is successful, use materials of the same origin or process from the factory's material library as furniture production materials;

[0012] When a match fails, or when the real-time inventory data is less than or equal to 0, the supplier system identifies materials from the same source or using the same process and generates a pre-purchase notice.

[0013] Optionally, the material information required for furniture production should include at least the information on the boards and the hardware materials.

[0014] Optionally, the homologous materials include materials that are identical in terms of supplier, manufacturer, brand, product code, item number, name, material specifications, dimensions, and color.

[0015] Optionally, the same process material includes materials with the same groove depth, groove width, front visible width, material thickness, edge clamp size, and material usage direction.

[0016] Optionally, the real-time inventory data includes real-time inventory quantity, in-transit inventory quantity, quantity to be shipped out, quantity to be delivered, quantity to be returned, quantity already occupied, material type with the highest inventory quantity, and material type with the lowest inventory quantity.

[0017] Optionally, when the real-time inventory data is greater than 0, matching products of the same source material or products of the same process in the factory material library according to the material information further includes:

[0018] Mismatched materials are identified in the factory's material library and marked.

[0019] Optionally, identify materials of the same origin or process within the supplier's system, including:

[0020] Within the supplier system, data and images of inventory materials are identified to match materials from the same source or using the same process.

[0021] Optionally, methods for processing furniture manufacturing material information also include:

[0022] Based on the material information and furniture production plan, calculate the material specifications and dimensions.

[0023] Based on the specified dimensions, obtain the material surplus information, number the material surplus information, and put it into the surplus material warehouse;

[0024] By merging the data from the surplus material warehouse with the inventory data from the factory material warehouse, we can obtain the real-time inventory data of the factory material warehouse.

[0025] The present invention also provides a processing device for furniture production material information, comprising:

[0026] The receiving module is used to receive furniture production plans;

[0027] The processing module is used to obtain the material information required for furniture production according to the furniture production plan; query the real-time inventory data of the factory material library in the factory ERP system according to the material information; when the real-time inventory data is greater than 0, match the same source material products or materials with the same process in the factory material library according to the material information; when the match is successful, use the same source material or materials with the same process in the factory material library as furniture production materials; when the match fails, or the real-time inventory data is less than or equal to 0, identify the same source material or materials with the same process in the supplier system and generate a pre-purchase notice.

[0028] The present invention also provides a computing device, comprising: a processor and a memory storing a computer program, wherein the computer program, when executed by the processor, performs the method described above.

[0029] The above-described solution of the present invention has at least the following beneficial effects:

[0030] The above-described solution of the present invention involves receiving a furniture production plan; obtaining material information required for furniture production based on the plan; querying real-time inventory data of the factory's material library in the factory's ERP system based on the material information; when the real-time inventory data is greater than 0, matching products of the same source material or the same process material in the factory's material library based on the material information; when a match is successful, using the same source material or the same process material in the factory's material library as the furniture production material; when a match fails, or when the real-time inventory data is less than or equal to 0, identifying the same source material or the same process material in the supplier's system and generating a pre-purchase notice. This enables automatic and seamless integration between front-end design, factory inventory, and suppliers, improving material information processing efficiency, reducing inventory backlog, and optimizing resource allocation. Attached Figure Description

[0031] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described below with reference to the accompanying drawings, wherein:

[0032] Figure 1 A flowchart illustrating a method for processing furniture production material information provided in an embodiment of the present invention.

[0033] Figure 2 A schematic diagram of a module for processing furniture production material information provided in an embodiment of the present invention. Detailed Implementation

[0034] Embodiments of the present invention are described in detail below. Examples of these embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and should not be construed as limiting the present invention.

[0035] This invention proposes an embodiment of a method for processing furniture production material information, specifically, as follows: Figure 1 As shown, it includes:

[0036] Step 11: Receive the furniture production plan;

[0037] In this embodiment, the furniture production plan can refer to a digital file containing furniture product design drawings, structural parameters, and configuration requirements. Its source can be a data stream directly exported from front-end design software or a standard format file uploaded to the system by the user. This furniture production plan serves as the input basis for subsequent material information acquisition, encompassing all the geometric and attribute constraints required to complete a specific furniture order. By receiving this plan, the system can automatically parse out the specific requirements of the production task, providing accurate target objects for subsequent inventory queries and matching.

[0038] Step 12: Obtain the material information required for furniture production according to the furniture production plan.

[0039] In this embodiment, material information refers to the set of raw material attributes required to manufacture all components in the furniture production plan, including but not limited to the length, width, thickness, texture, and color code of the boards, as well as the model, specifications, and mounting hole data of the hardware. This information is obtained by parsing the component list and attribute tags in the furniture production plan. Specifically, the system traverses each board and component in the plan and extracts its corresponding material code or feature description. For example, when the furniture production plan includes a wardrobe side panel, the system will automatically extract its dimensions as 2400mm long, 600mm wide, and 18mm thick, its material as oak grain, and its color as light walnut, etc. The obtained material information is used to construct a benchmark dataset for subsequent queries and matching, ensuring that the system can accurately identify the specific material types required for production.

[0040] Step 13: Based on the material information, query the real-time inventory data of the factory's material warehouse in the factory's ERP system.

[0041] In this embodiment, real-time inventory data refers to a snapshot of the current actual available and in-transit materials status in the factory, including dynamic indicators such as real-time inventory quantity, in-transit inventory quantity, quantity awaiting shipment, quantity awaiting delivery, quantity awaiting return, and quantity already occupied. This data is obtained by calling the database interface of the factory's ERP system to read the field values ​​of the corresponding materials in the factory's material warehouse in real time. Specifically, the system sends a query request to the ERP system, returning the physical inventory of the material in the warehouse at the current moment, as well as the quantity that has been locked by other orders but has not yet been shipped. For example, when querying a certain model of hinge, the system not only obtains the 500 units currently in stock on the warehouse shelves, but also simultaneously obtains the 200 units in transit that are expected to arrive tomorrow, and the 50 units already occupied by other urgent orders. The purpose of real-time inventory data is to serve as a basis for determining whether materials can be directly transferred from within the factory, avoiding misjudgments caused by information lag.

[0042] Step 14: When the real-time inventory data is greater than 0, match the same source material products or the same process material products in the factory material library according to the material information.

[0043] In this embodiment, "same-source material products" refers to materials whose purchasing unit, manufacturer, brand, product code, item number, name, material specifications, dimensions, and color are completely identical. Because this embodiment uses a unified format to fill in hardware process data, the standardization of hardware processes can be guaranteed. Only with standardized hardware processes can the accuracy of comparing process data and image recognition during traceability be achieved. Furthermore, the software automatically matches the hardware during drawing, eliminating the need for manual adjustments. "Same-process material products" can refer to materials with identical processing parameters such as groove depth, groove width, visible width from the front, material thickness, edge clamp size, and material usage direction. It should be noted that the same-process material products and the target demand material products must have the same intended function.

[0044] The matching process begins after confirming that the real-time inventory data meets a preset condition greater than 0. The system uses algorithms to compare the acquired material information with the physical data in the inventory from multiple dimensions. Product codes, regular data, and non-regular data are mapped to products existing in the warehouse, distinguishing between completely identical products from the same source, products with compatible processes from the same process, and mismatched products. For example, if a production plan requires a specific thickness of sheet metal, but the warehouse does not have the exact same batch, but there is a batch of substitute sheets with the exact same thickness, groove size, and visible width, the system identifies it as a product made of the same material. Through this hierarchical matching mechanism, existing inventory resources can be utilized to the maximum extent while prioritizing product quality, reducing material waste caused by minor differences.

[0045] Step 15: When a match is successful, use materials from the same source or process in the factory's material library as furniture production materials.

[0046] In this embodiment, the system marks successfully matched materials as designated materials for the current production plan and generates corresponding material retrieval instructions or production work orders. This operation is performed after determining the existence of materials with the same source or process. Specifically, it updates the material references in the production plan, replacing the original designed materials with the actual substitute material identifiers in the warehouse. For example, when the system successfully matches a sheet material with the same process, it automatically writes the sheet material's storage location number and batch number into the production execution system, directly retrieving the material from the designated storage location for processing. This embodiment achieves seamless integration between the design and inventory ends, ensuring the timely supply of production materials, while reducing new purchase costs by reusing existing inventory.

[0047] Step 16: When matching fails, or when real-time inventory data is less than or equal to 0, identify materials of the same origin or process in the supplier system and generate a pre-purchase notice.

[0048] In this embodiment, a matching failure may mean that no materials meeting the same source or process standards are found in the factory's material library, or that the real-time inventory data shows an available quantity of 0 or a negative number (i.e., out-of-stock status). In this case, the system expands the search scope to external supplier systems, identifying matching materials from the supplier's material database and images to find suitable materials meeting the requirements. For example, when a specific color of hardware is out of stock in the factory and there are no substitutes, the system automatically connects to the shared supplier platform, finds a supplier with stock and perfectly matching parameters, and then generates a pre-purchase notice containing the supplier's information and material details, sending it to the purchasing department for review. This mechanism ensures that when internal production materials cannot meet the demand, an external supply chain response can be quickly initiated, avoiding production stoppages due to material shortages.

[0049] The method in this embodiment automates and automates the entire process of furniture production material handling through the steps described above. By receiving furniture production plans and automatically acquiring material information, errors and delays caused by manual data entry are eliminated. Combined with real-time inventory data queries from the factory's ERP system, the design team can instantly perceive inventory status, resolving the problem of information disconnect. Furthermore, by prioritizing matching materials of the same origin or process when inventory is sufficient, and automatically redirecting to the supplier system for identification and generating pre-purchase notifications when inventory is insufficient or matching fails, a complete closed-loop management mechanism is formed. This mechanism not only significantly improves the efficiency of material information processing and reduces manual intervention, but also effectively reduces the risk of inventory backlog and procurement costs by prioritizing the use of internal inventory and precise external sourcing. Ultimately, this system drives the evolution of factory material warehouse management towards a zero-inventory goal, enhancing the overall responsiveness and resource allocation efficiency of the supply chain.

[0050] In an optional embodiment of the present invention, the material information required for furniture production includes at least board material information and hardware material information.

[0051] In this embodiment, board material information refers to a data set of various wood or engineered wood materials that constitute the main structure of the furniture, specifically including attribute data of materials such as solid wood boards, particleboard, medium-density fiberboard, and plywood. Board material information is automatically extracted by the front-end design software when generating the furniture production plan, and its function is to provide basic physical parameters for subsequent material matching. Board material information can be set according to the furniture design drawings, including the board's name, material, specifications, dimensions, color, grain direction, and surface treatment process. For example, when the production plan includes a custom wardrobe, the board material information extracted by the system includes specific values ​​such as the side panel thickness of 18mm, oak grain color, and dimensions of 2400mm*600mm, and the back panel thickness of 9mm and white color. By clearly defining the detailed composition of the board material information, the system can accurately locate the specific board type that meets the design requirements when querying inventory.

[0052] Hardware material information refers to a data set of metal or non-metal fittings used for furniture connection, fixation, support, and functional realization. Specifically, it includes attribute data for fittings such as hinges, drawer slides, handles, connectors, and support rods. Hardware material information is acquired simultaneously with board material information, and its purpose is to complete the bill of materials for furniture production, ensuring the supply of functional components. Hardware material information includes the supplier, manufacturer, brand, product code, item number, name, material, specifications, and mounting hole data. For example, for the aforementioned custom wardrobe, the hardware material information extracted by the system includes specific details such as the brand of the concealed hinge (a specific brand), product code H-2023, groove depth of 12mm, groove width of 35mm, and drawer slide length of 500mm and load-bearing capacity of 45kg. The board material information and hardware material information work together to form complete furniture production material information. This allows the system to cover not only the main structural materials but also key connecting components when matching materials from the same source or process, thus avoiding production stoppages due to a lack of hardware fittings. This step aims to refine the dimensions of material information, providing comprehensive and structured data input for subsequent inventory queries and supplier matching, effectively avoiding matching failures or procurement omissions caused by ambiguous material classifications.

[0053] In an optional embodiment of the present invention, the homologous materials include materials that are identical in terms of purchasing unit, manufacturer, brand, product code, item number, name, material specifications, size, and color.

[0054] In this embodiment, "same-source material" refers to a material entity whose attribute information is completely consistent with the design requirements. The determination of same-source material encompasses several key data fields: supplier (identifying the direct source of supply); manufacturer (the original manufacturer); brand (representing the commercial identifier of the material); product code and item number (unique identification codes within the manufacturer and distribution channels, respectively); name (the material's general or specific designation); material specifications and dimensions (defining the material's physical composition and geometric parameters); and color (characterizing the material's visual appearance). These fields collectively constitute the uniqueness constraint of same-source material. Only when the material to be matched and the target material completely overlap in all the above dimensions will the system determine it as a same-source material. For example, when the design scheme specifies the use of a certain brand of solid wood particleboard, with specifications of 1220mm×2440mm×18mm and color code walnut, the candidate materials retrieved by the system from the factory material database must simultaneously meet the following requirements: supplier is the same distributor, manufacturer is the same board factory, brand is consistent, product code and item number are identical, name is accurate, material thickness and dimensions are precisely matched, and color code is completely identical, in order to be confirmed as same-source material. This multi-dimensional and rigorous comparison mechanism ensures that the alternative materials used in production during inventory replacement are highly consistent with the original design materials in terms of physical properties, chemical properties, and appearance. This avoids quality problems such as color difference, uneven structural strength, or excessive assembly tolerance caused by differences in material batches or sources, effectively guaranteeing the final delivery quality and traceability of customized furniture products.

[0055] In an optional embodiment of the present invention, the same process material includes materials with the same groove depth, groove width, front visible width, material thickness, edge clamp size, and material usage direction.

[0056] In this embodiment, "materials with the same processing technology" refers to alternative materials determined based on the consistency of processing parameters when it is impossible to obtain materials from the same source in a strictly defined sense (i.e., materials with completely identical suppliers, manufacturers, brands, etc.). Specifically, the groove depth and width dimensions determine the fitting accuracy of the board material with other components, which are key geometric parameters to ensure the stability of the furniture structure; the visible width directly affects the size and aesthetics of the gaps after furniture assembly; the material thickness is related to the load-bearing capacity of the overall structure and the interlocking depth of the connectors; the size of the edge-sealing panel involves the installation compatibility of the edge banding or decorative strips; and the material usage direction defines the texture direction or stress direction to ensure that the product meets design expectations. These parameters together constitute the judgment set for materials with the same processing technology. Only when the material to be matched and the required material are completely consistent in value or state in all the above dimensions will the system identify it as a material with the same processing technology.

[0057] Taking hardware manufacturing process data as an example: For metal edge trim, the following process data needs to be compared: 1. Outer contour dimensions: Length: 3000, Width: 20.9, Thickness: 3.4; 2. Processing process data: Exposed edge width A: 3.4, Door panel reduction width B: 1.9, Plywood thickness C: 19.3, Side groove depth D: 9.5, Side groove width E: 2.4; If there is no process data FN for the metal edge trim, then there is no need to compare the remaining process data. After comparing the process data, image recognition is performed. Image recognition will compare the images in two directions (formal view and top view) to reveal differences in processing technology and installation direction.

[0058] This embodiment addresses the production stagnation caused by a shortage of a single source of materials by expanding the dimensions of material matching from matching with a single source to matching with materials of equivalent process. The output of this step is a list of qualified materials using the same process. This result can be directly used as the basis for subsequent material requisition or substitution confirmation, thereby significantly improving the utilization rate of inventory materials and the flexibility of production plan execution while ensuring the consistency of furniture product quality and appearance.

[0059] In an optional embodiment of the present invention, the real-time inventory data includes real-time inventory quantity, in-transit inventory quantity, quantity to be shipped out, quantity to be delivered, quantity to be returned, quantity already occupied, material type with the highest inventory quantity, and material type with the lowest inventory quantity.

[0060] In this embodiment, real-time inventory quantity refers to the total number of materials currently physically stored in the factory warehouse and in a freely deployable state. This data is obtained through the warehouse management system's real-time balance after scanning inbound and deducting outbound items. In-transit inventory quantity refers to the quantity of materials for which purchase orders have been placed with suppliers and shipments have been completed, but which have not yet arrived at the factory warehouse for acceptance. Its purpose is to predict the amount of inventory replenishment that will increase in the near future, avoiding duplicate orders. Quantity awaiting shipment refers to the quantity of materials for which internal material requisition forms or production work orders have been generated, but the physical transfer operation has not yet been completed. Quantity awaiting shipment refers to the quantity of materials for which packaging has been completed and shipment to customers or downstream processes has been confirmed, awaiting pickup by logistics carriers. Quantity awaiting return refers to the quantity of materials for which a return process has been initiated due to quality inspection failures or order cancellations, but which are still temporarily stored in the factory area or are en route for return. Quantity already occupied refers to the quantity of materials that have been locked or pre-allocated by specific urgent orders, and although in inventory, cannot be accessed by other ordinary orders. The quantities of goods awaiting shipment, goods awaiting delivery, goods awaiting return, and goods already in use constitute a dynamic buffer layer of inventory. By distinguishing these states, the net available quantity of materials can be accurately calculated.

[0061] For example, when the system receives an urgent furniture order, if the physical inventory shows 100 sheets of board, but 80 of them are already in use (locked by another urgent order) and 10 are waiting to be shipped (being moved to the production line), then the actual real-time inventory available for the new order is only 10 sheets. Based on this, the system determines that replenishment or matching of alternative materials is necessary, thus avoiding production line shutdowns caused by information lag.

[0062] The material types with the highest and lowest inventory levels are extreme values ​​generated by the system after statistically sorting the real-time inventory levels of each material category based on a preset time period (such as daily or weekly). Their purpose is to identify the risks of overstocking and stockouts. Specifically, the system iterates through all material categories, compares the total inventory value of each category, marks the category with the highest value as the material type with the highest inventory level, and marks the category with the lowest value as the material type with the lowest inventory level. Through this dynamic monitoring mechanism, management can intuitively grasp the health of the inventory structure, suspend procurement of the highest-value material type to reduce inventory, and activate early warnings for the lowest-value material type to ensure supply.

[0063] This embodiment solves the technical problem of accurately assessing the true availability of materials based solely on a single inventory value in the traditional model by expanding the static inventory quantity to a comprehensive dataset that includes items in circulation, locked items, and extreme value distributions. Based on the aforementioned multi-dimensional real-time inventory data, the system can accurately execute subsequent matching logic: when the calculated available inventory is greater than 0, it prioritizes matching within the factory with items from the same source or using the same process; however, if dynamic factors such as goods in transit and goods awaiting return are considered and it is determined that the actual available resources are insufficient (i.e., the equivalent inventory is less than or equal to 0), it immediately switches to the supplier system for identification and generates a pre-purchase notice. This significantly improves the accuracy of furniture production material scheduling, effectively avoids production delays or blind procurement caused by misjudgment of inventory status, and promotes the factory's evolution towards the goal of refined zero-inventory management.

[0064] In an optional embodiment of the present invention, when the real-time inventory data is greater than 0, matching products of the same source material or products of the same process in the factory material library according to the material information further includes:

[0065] Mismatched materials are identified in the factory's material library and marked.

[0066] In this embodiment, mismatched materials refer to furniture production materials that fail to meet preset matching conditions when executing the matching logic for materials from the same source or materials using the same process. Specifically, the system compares the material information (including board material information and hardware material information) required by the current furniture production plan with the real-time inventory data in the factory's material library item by item. If the conventional data of a certain inventory material (such as the purchasing unit, manufacturer, brand, product code, item number, name, material specifications, and color) is not completely consistent with the required material, and its non-conventional data (such as groove depth, groove width, visible width, material thickness, edge panel size, and material usage direction) also fails to meet the production process requirements, then the inventory material is determined to be a mismatched material. For example, when the production plan requires boards with a thickness of 18mm and an oak white finish, but the warehouse only has boards of the same brand with a thickness of 18mm but a walnut color, or only boards with a matching color but a thickness of 25mm, these materials are all identified as mismatched materials. This rigorous item-by-item comparison mechanism can accurately screen out materials that cannot be directly put into production due to differences in specifications, color, or process parameters, thus avoiding production accidents caused by incorrect material requisition.

[0067] Furthermore, mismatched materials are marked: specific status identifiers or attribute tags are added to the database records of mismatched materials to distinguish them from usable materials of the same origin or process. When the system identifies mismatched materials, it automatically writes a mismatch status code into the inventory record field of that material, and can further record the specific reason code for the mismatch (such as color mismatch, size deviation, missing process parameters, etc.). This marking process is dynamically updated. Once compliant materials are subsequently purchased or the original mismatched materials become usable through process adjustments, the mark can be cleared or updated to be usable. By digitally marking mismatched materials, visualized management of problematic materials is achieved, enabling managers to quickly locate non-standard materials accumulating in inventory, analyze whether the cause is due to overly specific design selections or supplier delivery deviations, thus providing data support for optimizing the material database and formulating precise procurement strategies, while also facilitating subsequent quality traceability and supplier evaluation.

[0068] In an optional embodiment of the present invention, identifying materials of the same origin or process within the supplier system includes:

[0069] Within the supplier system, data and images of inventory materials are identified to match materials from the same source or using the same process.

[0070] In this embodiment, materials of the same origin or process are identified within the supplier system. Specifically, the identification process involves matching materials of the same origin or process by analyzing data and images of inventory materials within the supplier system. The data here can refer to structured attribute information, including but not limited to conventional data such as purchasing unit, manufacturer, brand, product code, item number, name, material specifications, dimensions, and color, as well as non-process data such as groove depth, groove width, front visible width, material thickness, edge clamp dimensions, and material usage direction. Images can refer to digital image files reflecting the material's appearance, texture, color, surface quality, and edge processing details. This step expands the search scope to an external supplier resource pool when the factory's local material library cannot meet production needs (i.e., matching fails or real-time inventory data is less than or equal to zero), using a dual verification mechanism to ensure the availability of alternative materials. Specifically, the system first extracts the feature vector of the material to be purchased, which is composed of the aforementioned structured data fields and image feature fingerprints. Subsequently, the system performs data comparison and image similarity calculation in parallel within the supplier system's database. For example, when matching a specific panel material, the system not only compares its thickness (18mm), color code (RAL9016), and other numerical information, but also uses image recognition algorithms to analyze its wood grain direction, gloss distribution, and pixel-level differences from a standard sample image. If the data matching degree exceeds a preset threshold and the image similarity is higher than a set standard, the match is considered successful. This data-and-image combined recognition method effectively avoids mismatch problems caused by errors in a single data dimension, especially for decorative furniture materials with high visual consistency requirements, significantly improving the accuracy of remote matching. This result provides a reliable material basis for the subsequent generation of pre-purchase notices, ensuring the accuracy of cross-system collaborative scheduling. This embodiment refines the recognition process within the supplier's system into a dual recognition of inventory material data and images, achieving efficient and accurate scheduling of external resources.

[0071] In an optional embodiment of the present invention, the method for processing furniture production material information further includes:

[0072] Based on the material information and furniture production plan, calculate the material specifications and dimensions.

[0073] Based on the specified dimensions, obtain the material surplus information, number the material surplus information, and put it into the surplus material warehouse;

[0074] By merging the data from the surplus material warehouse with the inventory data from the factory material warehouse, we can obtain the real-time inventory data of the factory material warehouse.

[0075] In this embodiment, material information refers to the board material information and hardware material information obtained above. The furniture production plan can refer to production instructions that include specific furniture styles, quantities, and structural designs. Calculating the usage specifications of materials means that the system, based on the component disassembly data in the furniture production plan and combined with the material information's requirements for material quality, thickness, and grain direction, uses a layout algorithm to simulate the actual cutting process, thereby determining the specific length and width values ​​that each piece of raw material needs to be cut into during actual production. For example, when the production plan includes a cabinet side panel with a length of 2400mm, and the standard board size is 2440mm × 1220mm, the system will calculate the actual usage specifications of this component as 2400mm × 600mm (assuming a width requirement of 600mm), and allow for necessary saw kerf loss. This precise calculation based on the production plan ensures the accuracy of subsequent surplus material data, providing fundamental data support for the digital management of surplus materials.

[0076] Furthermore, based on the usage specifications, the system obtains material surplus information, assigns a number to this information, and places it in the surplus material database. Once the usage specifications are determined, the system automatically calculates the difference between the original board size and the usage specifications, identifying this difference as surplus material. The material surplus information includes at least the length, width, thickness, material type, and remaining area of ​​the surplus material. Numbering the material surplus information means the system generates a unique identification code for each identified piece of surplus material, which is bound to the surplus material's physical location and specifications. Placing it in the surplus material database means entering the numbered surplus material information into the system's virtual surplus material database, which corresponds one-to-one with the surplus material storage area in the factory's physical warehouse. For example, if a standard board is cut and a piece measuring 800mm × 600mm remains, the system will mark it, record its material as particleboard, update its status to usable, and store it in the surplus material database. Through numbered management, precise location and rapid retrieval of surplus materials are achieved, avoiding resource idleness caused by chaotic surplus material information.

[0077] Furthermore, the data from the surplus material warehouse is merged with the inventory data from the factory material warehouse to obtain the real-time inventory data of the factory material warehouse. This involves querying the inventory status of regular new materials, including real-time inventory quantity and quantity in transit. Merging the surplus material warehouse data means that the system integrates usable surplus material data from the surplus material warehouse into the overall data pool of the factory material warehouse according to dimensions such as material and specifications, making it logically equivalent to new materials participating in inventory calculations. Obtaining the real-time inventory data of the factory material warehouse means that the updated inventory data includes not only unopened new boards but also all reusable surplus material resources. For example, when a subsequent production task requires an 800mm × 600mm board, the system will prioritize matching the number in the surplus material warehouse when querying the real-time inventory data. If a match is successful, the quantity will be automatically deducted when calculating the procurement demand. This significantly improves the overall material utilization rate, effectively avoids raw material waste, and promotes the evolution of the factory material warehouse towards the goal of zero inventory by incorporating surplus materials into a unified inventory system.

[0078] This embodiment achieves closed-loop management of production surplus materials through the synergistic effect of the above steps. Specifically, by calculating the usage specifications and dimensions based on material information and furniture production plans, the remaining amount after each cut can be accurately determined. Furthermore, by numbering the surplus material information and storing it in a surplus material database, a digital surplus material archive is established, solving the problem of difficulty in tracking and finding surplus materials in the traditional model. Moreover, by merging the surplus material database data with the factory's material inventory data, the surplus materials can be automatically identified and utilized by the system in subsequent inventory queries and matching processes. This mechanism ensures that the system prioritizes the use of surplus materials during the next production layout, only triggering the procurement of new materials or the matching process of similar materials when surplus materials are insufficient. This significantly reduces raw material consumption and inventory backlog, improving the overall efficiency of material management.

[0079] In summary, the product storage and retrieval function works as follows: Utilizing product code recognition, image scanning, and automatic voice recognition, it automatically stores various products in designated locations and spaces, or retrieves the location and space of various products, and searches for and views various products in designated locations or spaces. Then, the retrieval command is assigned to an executor (human / robot). After the executor accurately locates the location / space, the product is retrieved / moved. The product's location / space changes, and the executor confirms the completion of the command. The system can record the product's location / space multiple times.

[0080] like Figure 2 As shown, a furniture production material information processing device 20 includes:

[0081] Receiver module 21 is used to receive furniture production plans;

[0082] The processing module 22 is used to obtain the material information required for furniture production according to the furniture production plan; query the real-time inventory data of the factory material library in the factory ERP system according to the material information; when the real-time inventory data is greater than 0, match the same source material products or materials with the same process in the factory material library according to the material information; when the match is successful, use the same source material or materials with the same process in the factory material library as furniture production materials; when the match fails, or the real-time inventory data is less than or equal to 0, identify the same source material or materials with the same process in the supplier system and generate a pre-purchase notice.

[0083] Optionally, the material information required for furniture production should include at least the information on the boards and the hardware materials.

[0084] Optionally, the homologous materials include materials that are identical in terms of supplier, manufacturer, brand, product code, item number, name, material specifications, dimensions, and color.

[0085] Optionally, the same process material includes materials with the same groove depth, groove width, front visible width, material thickness, edge clamp size, and material usage direction.

[0086] Optionally, the real-time inventory data includes real-time inventory quantity, in-transit inventory quantity, quantity to be shipped out, quantity to be delivered, quantity to be returned, quantity already occupied, material type with the highest inventory quantity, and material type with the lowest inventory quantity.

[0087] Optionally, when the real-time inventory data is greater than 0, matching products of the same source material or products of the same process in the factory material library according to the material information further includes:

[0088] Mismatched materials are identified in the factory's material library and marked.

[0089] Optionally, identify materials of the same origin or process within the supplier's system, including:

[0090] Within the supplier system, data and images of inventory materials are identified to match materials from the same source or using the same process.

[0091] Optionally, the furniture production material information processing device also includes:

[0092] Based on the material information and furniture production plan, calculate the material specifications and dimensions.

[0093] Based on the specified dimensions, obtain the material surplus information, number the material surplus information, and put it into the surplus material warehouse;

[0094] By merging the data from the surplus material warehouse with the inventory data from the factory material warehouse, we can obtain the real-time inventory data of the factory material warehouse.

[0095] It should be noted that this device is the same as the method described above. All implementations in the above method embodiments are applicable to the embodiments of this device and can achieve the same technical effect.

[0096] An embodiment of the present invention also provides a computing device, including: a processor and a memory storing a computer program, wherein the computer program, when executed by the processor, performs the method described in the above embodiments. All implementations in the above method embodiments are applicable to this embodiment and can achieve the same technical effect.

[0097] In this embodiment of the invention, a computer-readable storage medium is also provided, storing instructions that, when executed on a computer, cause the computer to perform the method described in the above embodiments. All implementations of the methods described in the above embodiments are applicable to this embodiment and can achieve the same technical effect.

[0098] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.

[0099] Those skilled in the art will understand that, for the sake of convenience and brevity, the specific working processes of the systems, devices, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here.

[0100] In the embodiments provided by this invention, it should be understood that the disclosed apparatus and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative. For instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between devices or units may be electrical, mechanical, or other forms.

[0101] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0102] In addition, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.

[0103] If the aforementioned functions are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this invention, essentially, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, ROM, RAM, magnetic disks, or optical disks.

[0104] Furthermore, it should be noted that in the apparatus and method of the present invention, it is obvious that the components or steps can be decomposed and / or recombined. These decompositions and / or recombinations should be considered equivalent solutions of the present invention. Moreover, the steps performing the above series of processes can naturally be executed in the order described, but are not necessarily required to be executed in chronological order; some steps can be executed in parallel or independently of each other. Those skilled in the art will understand that all or any step or component of the method and apparatus of the present invention can be implemented in any computing device (including processors, storage media, etc.) or network of computing devices, in hardware, firmware, software, or a combination thereof. This is something that those skilled in the art can achieve by using their basic programming skills after reading the description of the present invention.

[0105] Therefore, the object of the present invention can also be achieved by running a program or a set of programs on any computing device. The computing device can be a known general-purpose device. Therefore, the object of the present invention can also be achieved simply by providing a program product containing program code implementing the method or apparatus. That is, such a program product also constitutes the present invention, and the storage medium storing such a program product also constitutes the present invention. Obviously, the storage medium can be any known storage medium or any storage medium developed in the future. It should also be noted that in the apparatus and method of the present invention, it is obvious that the components or steps can be decomposed and / or recombined. These decompositions and / or recombinations should be considered equivalent to the present invention. Furthermore, the steps performing the above series of processes can naturally be performed in the order described, but are not necessarily required to be performed in chronological order. Some steps can be performed in parallel or independently of each other.

[0106] The above description represents the preferred embodiments of the present invention. It should be noted that those skilled in the art can make various improvements and modifications without departing from the principles of the present invention, and these improvements and modifications should also be considered within the scope of protection of the present invention.

Claims

1. A method for processing furniture production material information, characterized in that, include: Receive furniture production plans; Based on the furniture production plan, obtain the material information required for furniture production; Based on the material information, query the real-time inventory data of the factory's material warehouse in the factory's ERP system; When the real-time inventory data is greater than 0, match products of the same source material or products of the same process in the factory material library according to the material information. When a match is successful, use materials of the same origin or process from the factory's material library as furniture production materials; When a match fails, or when real-time inventory data is less than or equal to 0, the supplier system identifies materials from the same source or using the same process and generates a pre-purchase notice.

2. The method for processing furniture production material information according to claim 1, characterized in that, The material information required for furniture production includes at least information on the boards and hardware materials.

3. The method for processing furniture production material information according to claim 1, characterized in that, The homologous materials include materials that are identical in terms of supplier, manufacturer, brand, product code, item number, name, material specifications, size, and color.

4. The method for processing furniture production material information according to claim 1, characterized in that, The same process materials include materials with the same groove depth, groove width, front visible width, material thickness, edge clamp size, and material usage direction.

5. The method for processing furniture production material information according to claim 1, characterized in that, The real-time inventory data includes real-time inventory quantity, in-transit inventory quantity, quantity to be shipped out, quantity to be delivered, quantity to be returned, quantity already occupied, material type with the highest inventory quantity, and material type with the lowest inventory quantity.

6. The method for processing furniture production material information according to claim 1, characterized in that, When the real-time inventory data is greater than 0, the system matches products made of the same source material or products made of the same process in the factory material library based on the material information, and also includes: Mismatched materials are identified in the factory's material library and marked.

7. The method for processing furniture production material information according to claim 1, characterized in that, Identify materials from the same source or using the same process within the supplier's system, including: Within the supplier system, data and images of inventory materials are identified to match materials from the same source or using the same process.

8. The method for processing furniture production material information according to claim 1, characterized in that, Also includes: Based on the material information and furniture production plan, calculate the material specifications and dimensions. Based on the specified dimensions, obtain the material surplus information, number the material surplus information, and put it into the surplus material warehouse; By merging the data from the surplus material warehouse with the inventory data from the factory material warehouse, we can obtain the real-time inventory data of the factory material warehouse.

9. A device for processing information on furniture production materials, characterized in that, include: The receiving module is used to receive furniture production plans; The processing module is used to obtain the material information required for furniture production based on the furniture production plan. Based on the material information, query the real-time inventory data of the factory's material warehouse in the factory's ERP system; When the real-time inventory data is greater than 0, match products of the same source material or the same process material in the factory material library according to the material information; when the match is successful, use the same source material or the same process material in the factory material library as the furniture production material; When a match fails, or when real-time inventory data is less than or equal to 0, the supplier system identifies materials from the same source or using the same process and generates a pre-purchase notice.

10. A computing device, characterized in that, include: A processor, a memory storing a computer program, wherein the computer program, when executed by the processor, performs the method as described in any one of claims 1 to 8.

Images