Customized furniture industry order color sorting method and system

Abstract

The invention belongs to the technical field of customized furniture production management, and particularly relates to a customized furniture industry order color sorting method and system. The customized furniture industry order color sorting method comprises the following steps: obtaining to-be-produced overall order information; splitting the whole order into corresponding sub-orders according to color names of products; classifying the sub-orders with the same color name into a batch group with the same color; planning the color batch groups of the sub-orders associated with the same integral order into adjacent batch groups; and sorting the adjacent batch groups according to the overall order priority. According to the order color sorting method for the customized furniture industry, hierarchical sorting ensures that the sub-order units of each overall order are produced in adjacent color batches as much as possible, and the completion of the overall order is accelerated, so that the cache region is released, and meanwhile, the requirements of order urgent adjustment and the like are met; and efficient support is provided for mixed order production of customized furniture enterprises.

Description

Technical Field

[0001] This invention belongs to the field of customized furniture production management technology, specifically relating to a method and system for color-sorting orders in the customized furniture industry. Background Technology

[0002] In the custom furniture industry, with the diversification and personalization of market demand, mixed-order production has gradually become the mainstream production model for many furniture factories. Custom furniture orders generally exhibit the characteristic of "multiple colors per order"—that is, an order contains furniture products of multiple colors (e.g., a wardrobe order includes "white marble" cabinet doors, "light gray wood grain" cabinet bodies, and "dark brown walnut" handles), necessitating mixed-order production. Currently, the core logic of mixed-order production is: first, each order is broken down into "sub-order units" of corresponding colors (split according to the product colors within the order, one color corresponds to one sub-order unit, containing information such as production requirements and raw material specifications for that color product); then, sub-order units of the same color from multiple orders are grouped into the same batch for production. Through this method, in the raw material cutting and processing stages, the layout of raw materials such as boards of the same color can be optimized, minimizing waste and maximizing the use of raw materials, thereby effectively reducing production costs. This is the core reason why the mixed-order production model is widely adopted.

[0003] However, the current mixed-order production model has many problems that urgently need to be solved in practical applications, and these problems are further exacerbated by the characteristic of "multiple colors split in a single order": 1. Uncontrollable production sequence of sub-order units, making it impossible to accurately predict the overall order delivery time: In the existing mixed-order production process, the production workshop can only roughly plan for color batches, lacking a means to coordinate and prioritize the "sub-order units after a single order is broken down." Since the completion of an overall order depends on the completion of the production of all its sub-order units, and these sub-order units may be scattered across different color batches, and the production progress of each batch is affected by factors such as raw material supply and equipment status, production managers cannot clearly grasp the correlation progress between the "overall order - sub-order units - color batches," resulting in an inability to accurately predict the final completion time of the overall order, which can easily lead to customer complaints.

[0004] 2. Severe backlog of goods and excessive buffer space occupancy slow down production: Due to the disordered production sequence of sub-order units, semi-finished products from completed sub-order units and raw materials for unfinished sub-order units accumulate in the buffer space during production. Under the current model, the buffer space for a particular color batch can only be cleared after all sub-order units for that batch are completed; simultaneously, the entire order can only be assembled and delivered after all sub-order units are produced, resulting in unfinished semi-finished products occupying buffer space for an extended period. When multiple color batches of sub-order units proceed simultaneously, and the number of waiting sub-order units exceeds the buffer space's capacity, materials needed for subsequent production cannot enter the buffer space, causing production interruptions and severely slowing down the overall production progress.

[0005] Furthermore, furniture industry color swatches use custom Chinese names for identification (such as "White Marble," "Yellow Silver Pear," and "Glacier Gray"), which are unrelated to RGB values. Only when the Chinese names of colors in sub-order units are completely identical can they be grouped into the same batch; there is no "similar color" criterion. This characteristic renders existing sorting schemes that rely on color parameters (such as RGB values) completely inapplicable, further increasing the difficulty of classifying and sorting sub-order units, and exacerbating the problems of excessive cache usage and the inability to quickly complete overall orders. Summary of the Invention

[0006] The purpose of this invention is to provide a method and system for color-sorting orders in the customized furniture industry to solve the above-mentioned technical problems.

[0007] The first aspect of this application provides a method for color-sorting orders in the customized furniture industry, including: Obtain overall order information for production; The overall order is split into corresponding sub-orders based on the product's color name; Sub-orders with the same color name will be grouped into the same color batch group; Organize the color batch groups of sub-orders that are associated with the same overall order into adjacent batch groups; Sort adjacent batch groups according to overall order priority.

[0008] In one embodiment of this application, the overall order information to be produced includes: overall order number, product list, delivery deadline, overall order priority, and production man-hours per product.

[0009] In one embodiment of this application, the method of splitting an overall order into corresponding sub-orders based on product color includes: For each overall order, sub-order units are split according to the product color name, and each sub-order unit generates a unique identifier.

[0010] In one embodiment of this application, the identifier includes an overall order number and a color name.

[0011] In one embodiment of this application, the color-sorting method for custom furniture industry orders further includes: Standardize and validate the color names of the split sub-orders.

[0012] In one embodiment of this application, the color-sorting method for custom furniture industry orders further includes: Within each color batch group, sub-orders are sorted in ascending order of production time.

[0013] In one embodiment of this application, the color-sorting method for custom furniture industry orders further includes: After sorting, associate the relationships between "overall order - sub-order - color batch group" to generate an "overall order progress tracking table".

[0014] In one embodiment of this application, the color-sorting method for custom furniture industry orders further includes: Obtain the overall order expedited information and update the priority of the overall order.

[0015] Accordingly, a second aspect of this application provides a color-coded order sorting system for the customized furniture industry, comprising: The order information acquisition module is used to acquire overall order information for orders awaiting production. The sub-order splitting module is used to split the overall order into corresponding sub-orders based on the product's color name; The color batch group building module is used to group sub-orders with the same color name into the same color batch group; The adjacent batch group construction module is used to plan color batch groups of sub-orders that are associated with the same overall order as adjacent batch groups. The adjacent batch group sorting module sorts adjacent batch groups according to the overall order priority.

[0016] In one embodiment of this application, the custom furniture industry order color sorting system further includes: The sub-order sorting module is used to sort sub-orders within each color batch group in ascending order of production time.

[0017] The beneficial effects of this invention are: Unlike existing technologies, this application provides a method for color-sorting orders in the customized furniture industry. The method includes: acquiring overall order information; splitting the overall order into corresponding sub-orders based on product color names; grouping sub-orders with the same color name into the same color batch group; planning color batch groups of sub-orders associated with the same overall order as adjacent batch groups; and sorting adjacent batch groups according to the overall order priority. The hierarchical sorting of the color-sorting method for customized furniture orders in this invention ensures that sub-order units of each overall order are produced in adjacent color batches as much as possible, accelerating the completion of the overall order, thereby releasing buffer space, and simultaneously meeting the needs of expedited order adjustments, providing efficient support for mixed-order production in customized furniture enterprises.

[0018] Other features and advantages of the invention will be set forth in the following description, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention are realized and obtained through the structures particularly pointed out in the description and the drawings.

[0019] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, preferred embodiments are described below in detail with reference to the accompanying drawings. Attached Figure Description

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

[0021] Figure 1 This is a schematic diagram of a preferred embodiment of the color sorting method for customized furniture industry orders according to the present invention; Figure 2 This is a schematic representation of overall order information according to a preferred embodiment of the present invention; Figure 3 This is a schematic diagram of a sub-order list according to a preferred embodiment of the present invention; Figure 4 This is a schematic representation of overall order progress tracking in a preferred embodiment of the present invention. Detailed Implementation

[0022] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0023] This application provides a method and system for color-sorting orders in the customized furniture industry, which will be described in detail below. It should be noted that the order of description of the following embodiments is not intended to limit the preferred order of the embodiments of this application. Furthermore, the descriptions of each embodiment have their own emphasis; parts not described in detail in a certain embodiment can be referred to in the relevant descriptions of other embodiments.

[0024] See Figure 1 In one embodiment, the color-sorting method for custom furniture industry orders includes: S1, obtain overall order information for production; S2, split the overall order into corresponding sub-orders according to the color name of the product; S3, group sub-orders with the same color name into the same color batch group; S4, group the color batches of sub-orders that are associated with the same overall order into adjacent batch groups; S5 sorts adjacent batch groups according to the overall order priority.

[0025] In S1, the overall order information to be produced includes: overall order number, product list, delivery deadline, overall order priority, and production man-hours per product. Optionally, the overall order information to be produced may be obtained from, but is not limited to, the enterprise order management system, or input through a human-computer interaction device.

[0026] In S2, the method of splitting the overall order into corresponding sub-orders according to product color includes: for each overall order, splitting it into corresponding sub-order units according to product color name, and generating a unique identifier for each sub-order unit.

[0027] Optionally, the identifier includes an overall order number and a color name. For example, the identifier could be in the format "D001 - White Marble," where "D001" is the overall order number and "White Marble" is the color name. Of course, in other embodiments, the number and color name can also be in other formats.

[0028] Optionally, the color names of the split sub-orders can be standardized and validated to ensure complete consistency with the enterprise color card library names, such as removing easily confused expressions like "white marble pattern" to avoid misclassification of sub-order units of the same color.

[0029] Furthermore, in S3, color grouping can be based on the color name of the sub-order, using the "exact name match" principle: only when the Chinese names of the colors in two sub-orders are exactly the same are they grouped into the same color batch group; if there are any differences in the color names (such as "Glacier Gray" and "Light Glacier Gray"), they are grouped into different batch groups. Each color batch group can contain "batch group identifier (color name), a list of associated sub-order units (including the overall order number, production hours, customer priority, etc.)" information, achieving precise grouping of sub-order units.

[0030] Furthermore, in S4, with the goal of "adjacent production of sub-orders within the overall order," color batch groups "related to the same sub-order unit of the overall order" can be prioritized as adjacent batch groups. For example, if an overall order contains sub-order units of "white marble" and "light gray wood grain," then the "white marble batch group" and the "light gray wood grain batch group" can be planned as adjacent batches. This can accelerate the completion of the overall order and free up buffer space.

[0031] Furthermore, in S5, adjacent batch groups can be sorted according to the overall order priority.

[0032] In one embodiment, priority can be divided into "yes" and "no," where "yes" indicates that priority is required and the order is ranked higher, and "no" indicates that priority is not required and the order is ranked lower. When multiple orders or all orders require priority, they can also be sorted according to certain rules, such as sorting by the order of order placement. Similarly, when multiple orders or all orders do not require priority, they can also be sorted according to certain rules, such as sorting by the order of order placement.

[0033] Of course, in some embodiments, priorities can also be graded, for example, level 1 has the highest priority, level 2 is next, level 3 is next, and so on. In other embodiments, priorities can also be defined according to other different rules.

[0034] Furthermore, within each color batch group, the production order of sub-orders can be sorted according to certain rules. For example, sub-orders can be sorted in ascending order of production man-hours. Another example is sorting sub-orders according to the priority of the overall order to which each sub-order belongs. Of course, in other embodiments, sorting can also be performed according to other rules.

[0035] Furthermore, after sorting, the system can associate the relationships between "overall order - sub-order - color batch group" to generate an "overall order progress tracking table." This table clearly displays the batch and production sequence of all sub-order units within each overall order, facilitating management's understanding of the overall order progress.

[0036] In one embodiment, the color-sorting method for custom furniture industry orders may further include: S6, obtaining overall order expedited information and updating the priority of the overall orders. Then, according to S5, reordering adjacent batch groups according to the overall order priority.

[0037] In some application scenarios, it is necessary to expedite one or more overall orders. In some embodiments, this can be achieved by updating the priority of the overall orders requiring expedited processing, for example, changing whether priority is required from "no" to "yes"; or changing the priority level from level 3 to level 1, etc. After updating the priority level, adjacent batch groups are sorted according to the updated priority, so that those requiring expedited processing are produced first.

[0038] Based on the above embodiments, another embodiment of this application provides a color-coded order sorting system for the customized furniture industry, comprising: The order information acquisition module is used to acquire overall order information for orders awaiting production. The sub-order splitting module is used to split the overall order into corresponding sub-orders based on the product's color name; The color batch group building module is used to group sub-orders with the same color name into the same color batch group; The adjacent batch group construction module is used to plan color batch groups of sub-orders that are associated with the same overall order as adjacent batch groups. The adjacent batch group sorting module sorts adjacent batch groups according to the overall order priority.

[0039] Furthermore, the custom furniture industry order color sorting system also includes: The sub-order sorting module is used to sort sub-orders within each color batch group in ascending order of production time.

[0040] Furthermore, the custom furniture industry order color sorting system also includes: The expedited order module allows users to obtain overall expedited order information and update the priority of the overall orders.

[0041] In some embodiments, the custom furniture industry order color sorting system may further include: The sorting result export module exports the sorting results to an Excel file, which can also be printed. The exported content includes three layers of information: ① a color batch group sorting table (batch number, color name, and associated order list); the exported results can be printed directly, facilitating production organization in the workshop according to the order in the table; and... Data interaction module with workshop production management software: A standardized data interface (direct database connection) is adopted to achieve "data interaction" with the workshop production management software: ① Data synchronization: After the sorting results are determined, the system automatically transmits the "batch group sorting data and sub-order unit sorting data" to the production management software, and the production management software displays the production plan in units of "batch groups".

[0042] In this embodiment, the working method of each module of the custom furniture industry order color sorting system can be found in the above embodiment, and will not be repeated here.

[0043] Taking three complete orders (including multiple colors) from a custom furniture factory as an example, the implementation process of the sorting method is explained in detail: S1, retrieve the overall order information for 3 items, see [link / reference] Figure 2 ; S2, split according to the "unique color" principle, generating sub-orders (identifier format: overall order number - color), see [link / reference]. Figure 3 Of course, the production time of sub-order units can also be calculated as needed (not shown in the diagram). Color name verification: It was confirmed that "white marble", "light gray wood grain", etc. are consistent with the company's color card library, and there are no differences in description.

[0044] S3, based on the "exact name match" principle, divides the 9 sub-order units into 5 color batch groups: • Batch Group 1 (White Marble): D001 - White Marble, D002 - White Marble (both are "White Marble" in color) • Batch Group 2 (Light Gray Wood Grain): D001 - Light Gray Wood Grain, D003 - Light Gray Wood Grain (both are "Light Gray Wood Grain" in color) • Batch Group 3 (Dark Brown Walnut): D001 - Dark Brown Walnut, D003 - Dark Brown Walnut (both are "Dark Brown Walnut" in color) • Batch Group 4 (Yellow Silver Pear): D002 - Yellow Silver Pear (color is "Yellow Silver Pear") • Batch Group 5 (Glacier Grey): D002 - Glacier Grey, D003 - Glacier Grey (both colors are "Glacier Grey").

[0045] S4. Organize the color batch groups of sub-orders associated with the same overall order into adjacent batch groups. For example, batch groups 1, 2, and 3 are all associated with D001, so they are divided into adjacent batch groups; batch groups 1, 4, and 5 are all associated with D002, so they are divided into adjacent batch groups; batch groups 2, 3, and 5 are all associated with D003, so they are divided into adjacent batch groups.

[0046] S5. According to the priority setting, the production of order D002 needs to be prioritized. The batch groups related to order D002, namely batch group 4, batch group 5, and batch group 1, will be placed first. The determined batch group order at this time is: batch group 4, batch group 1, and batch group 5. (Optionally, batch group 4 has the shortest working time and can be placed first).

[0047] The remaining batch groups can be sorted according to whether they are in the same adjacent batch group as the prioritized batch group. For example, in batch group 1, if batch groups 2 and 3, which are adjacent batch groups to "D001 - White Marble", are added to the production sequence, then the determined batch group order is: batch group 4, batch group 1, batch group 5, batch group 2, batch group 3.

[0048] Finally, see Figure 4 It can generate an "order progress tracking table" that clearly shows the distribution and production sequence of each sub-order unit of the overall order.

[0049] In summary, the sorting method of the present invention has the following advantages: 1. Adapt to the multi-color characteristics of a single order to achieve accurate splitting and hierarchical sorting: This method incorporates "single order splitting into sub-order units" into the sorting process for the first time. Through hierarchical management of "overall order - sub-order unit - color batch group", it solves the problem of disordered sub-order units in the existing model and ensures that the sorting results conform to the actual production process.

[0050] 2. Adjacent production batches of sub-order units accelerate the completion of the overall order and release the cache: By prioritizing the overall order and planning adjacent color batch groups, sub-order units of the same overall order are made to be in adjacent production batches as much as possible, reducing the waiting time of the overall order and accelerating its completion; at the same time, the cache can be cleared in a timely manner after each batch of sub-order units is produced quickly, avoiding the backlog of goods and solving the problem of excessive cache area occupation.

[0051] 3. Accurately estimate the overall order delivery time: Based on the progress correlation of "overall order - sub-order unit - batch group", combined with the planned production time of each batch group and the production man-hour of the sub-order unit, the estimated completion time of each overall order can be accurately calculated, which solves the problem of uncontrollable delivery time in the existing model and improves customer satisfaction.

[0052] 4. Flexible support for expedited adjustments to meet diverse needs: The dual-mode expedited processing of "overall order + sub-order unit" can meet the expedited order needs in different scenarios, ensuring fast delivery of overall orders while avoiding the impact of partial expedited processing on the overall production plan, thus improving the company's emergency response capabilities.

[0053] 5. Convenient data interaction and result export, improving production collaboration efficiency: The sorting results contain multi-level information, and exporting and printing them facilitates execution in the workshop.

[0054] The above description is merely a preferred embodiment of the present invention and is not intended to limit the present invention in any way. Although the present invention has been disclosed above with reference to preferred embodiments, it is not intended to limit the present invention. Any person skilled in the art can make some modifications or alterations to the above-disclosed technical content to create equivalent embodiments without departing from the scope of the present invention. Any simple modifications, equivalent changes and alterations made to the above embodiments based on the technical essence of the present invention without departing from the scope of the present invention shall still fall within the scope of the present invention.

Claims

1. A method for color-sorting orders in the customized furniture industry, characterized in that, include: Obtain overall order information for production; The overall order is split into corresponding sub-orders based on the product's color name; Sub-orders with the same color name will be grouped into the same color batch group; Organize the color batch groups of sub-orders that are associated with the same overall order into adjacent batch groups; Sort adjacent batch groups according to overall order priority.

2. The color-sorting method for custom furniture industry orders according to claim 1, characterized in that, The overall order information to be produced includes: overall order number, product list, delivery deadline, overall order priority, and production man-hours per product.

3. The color-sorting method for custom furniture industry orders according to claim 1, characterized in that, The method for splitting an overall order into corresponding sub-orders based on product color includes: For each overall order, sub-order units are split according to the product color name, and each sub-order unit generates a unique identifier.

4. The color-sorting method for custom furniture industry orders according to claim 3, characterized in that, The identifier includes the overall order number and color name.

5. The color-sorting method for custom furniture industry orders according to claim 4, characterized in that, Also includes: Standardize and validate the color names of the split sub-orders.

6. The color-sorting method for custom furniture industry orders according to claim 1, characterized in that, Also includes: Within each color batch group, sub-orders are sorted in ascending order of production time.

7. The color-sorting method for custom furniture industry orders according to claim 1, characterized in that, Also includes: After sorting, associate the "overall order - sub-order - color batch group" relationships to generate an "overall order progress tracking table".

8. The color-sorting method for custom furniture industry orders according to claim 1, characterized in that, Also includes: Obtain the overall order expedited information and update the priority of the overall order.

9. A color-coded order sorting system for the customized furniture industry, characterized in that, include: The order information acquisition module is used to acquire overall order information for orders awaiting production. The sub-order splitting module is used to split the overall order into corresponding sub-orders based on the product's color name; The color batch group building module is used to group sub-orders with the same color name into the same color batch group; The adjacent batch group construction module is used to plan color batch groups of sub-orders that are associated with the same overall order as adjacent batch groups. The adjacent batch group sorting module sorts adjacent batch groups according to the overall order priority.

10. The custom furniture industry order color sorting system according to claim 9, characterized in that, Also includes: The sub-order sorting module is used to sort sub-orders within each color batch group in ascending order of production time.

Images