A method for updating a design file containing sales order information
By creating a mapping table of design document update relationships, the problems of wasted human resources and high error rates in traditional design document updates are solved, and efficient design document updates are achieved.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- SHENZHEN FENDA TECH CO LTD
- Filing Date
- 2026-05-09
- Publication Date
- 2026-07-31
AI Technical Summary
In the manufacturing of consumer electronics and daily consumer goods, the traditional method of updating design documents increases communication and coordination costs and the workload of engineers because product packaging design and screen printing design are handled by different engineers. It also results in a high error rate.
By creating a design file update relationship mapping table, the correspondence between the change information of new sales batch orders and the original design files is recorded, and the table is stored in a newly created folder, thus enabling the updating of multiple design files.
It reduced the error rate of design document updates and saved design engineers human resources and communication costs.
Smart Images
Figure CN122492085A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the technical field of updating design documents for new sales batch orders, and in particular to a method for updating design documents containing sales order information. Background Technology
[0002] In industries such as consumer electronics and consumer goods manufacturing, products using the same or similar molds often experience changes in customer PO numbers, colors, models, or countries of origin during the actual manufacturing process due to batch differences in sales orders. This necessitates updating the product packaging and screen printing design documents based on these changes. Typically, the traditional method for updating these design documents is as follows: the graphic design engineer responsible for the product packaging uses graphic design software to modify and update all packaging design documents related to the changes in the new order; the structural engineer responsible for the screen printing design uses structural design software to modify and update the screen printing design documents related to the changes in the new order.
[0003] Since product packaging design and product appearance silkscreen design are handled by different engineers, and there are often many design documents that need to be updated, the traditional method of updating design documents not only increases the communication and coordination costs of relevant personnel and the workload of engineers, resulting in a waste of human resources, but also causes a high error rate by modifying and updating each design document one by one.
[0004] Therefore, a new technical solution needs to be researched to address the above problems. Summary of the Invention
[0005] In view of this, the present invention addresses the shortcomings of existing technologies, and its main objective is to provide a method for updating design documents containing sales order information. This method creates a design document update association mapping table based on the correspondence between the change information of new sales batch orders and the original design documents containing the sales order information. The original design documents containing the sales order information and the design document update association mapping table are stored in a newly created folder. The original design documents containing the sales order information and the design document update association mapping table are then used as the updated design documents, thereby enabling the updating of multiple design documents containing sales order information. This not only saves design engineers' human resource costs and communication costs with clients, but also significantly reduces the error rate when updating large numbers of traditional design documents.
[0006] To achieve the above objectives, the present invention adopts the following technical solution: A method for updating a design file containing sales order information, characterized in that the method includes the following steps: S1. Obtain change information for new sales batch orders; S2. Compare and analyze the obtained change information with the information in the original design file containing sales order information to determine whether the original design file containing sales order information needs to be updated. S3. Create a design document update association mapping table based on the correspondence between the change information and the original design documents containing sales order information; S4. Determine the updated design file by combining the original design file containing sales order information and the design file update association mapping table.
[0007] Furthermore, the acquisition of change information for new sales batch orders includes: Retrieve the category of the change information from the new batch order information table; Retrieve the content of the change information corresponding to the category of the change information from the new batch order information table; The change requirements are obtained from the new batch order information table.
[0008] Furthermore, the determination of whether the original design file containing sales order information needs to be updated includes: If the obtained change information category appears in the original design file containing sales order information, then the original design file containing sales order information needs to be updated. If the obtained change information category does not appear in the original design file containing sales order information, then it is not necessary to update the original design file containing sales order information.
[0009] Furthermore, the creation of the design document update association mapping table includes: Create a new spreadsheet file on your computer; In the first row of the newly created spreadsheet file, design the table header with different information attributes occupying a separate column; In the row immediately below the table header, enter, edit, and save the specific content that corresponds one-to-one with the information attributes in the table header; Rename the saved table file to the Design File Update Association Mapping Table.
[0010] Furthermore, the design document updates the information attributes in the header of the association mapping table, including the unique sales order number.
[0011] Furthermore, the determination of the updated design document includes: Create a new folder on your computer; Save all the original design files containing sales order information that need to be updated, along with the design file update association mapping table, into the newly created folder. Rename the newly created folder according to the naming rules of the updated design file folder.
[0012] Furthermore, design document updates refer to updates to the specific content of the information contained in the design documents for product packaging and screen printing.
[0013] Furthermore, the change information for the new sales batch order refers to the information that the design documents for the original packaging and screen printing need to be updated due to changes in the category (PO number, color, model, or place of origin) of different batches of products.
[0014] Furthermore, the relationship mapping table is created using a Microsoft Excel spreadsheet file.
[0015] Furthermore, the relationship mapping table is created using a WPS spreadsheet file.
[0016] Compared with the prior art, the present invention has significant advantages and beneficial effects. Specifically, as can be seen from the above technical solution, the present invention provides a method for updating design files containing sales order information. This method can create a design file update association mapping table based on the correspondence between the change information of new sales batch orders and the original design files containing sales order information. This table records the original design files containing sales order information, the change information of the original design files containing sales order information involved in the change information of new sales batch orders, and the corresponding content binding relationship between the two, including the changed content and its location information in the original design files containing sales order information. Furthermore, by storing the original design files containing sales order information and the design file update association mapping table in a newly created folder, the original design files containing sales order information and the design file update association mapping table are determined as the updated design files, thereby realizing the updating of multiple design files containing sales order information. This method eliminates the need for packaging design engineers and structural design engineers to use their respective software to modify the original design documents containing sales order information and the updated drawings confirmed by the client. Instead, a single staff member creates a design document update relationship mapping table and uses the original design document containing sales order information and the mapping table to define the updated design document. This not only saves on the human resource costs of design engineers and communication costs with clients but also significantly reduces the error rate when updating a large number of traditional design documents. Attached Figure Description
[0017] To more clearly illustrate the technical solutions in the embodiments of this application, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0018] Figure 1 This is a flowchart of the design document update method provided in the embodiments of this application. Detailed Implementation
[0019] To make the technical problems, technical solutions, and beneficial effects to be solved by this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and are not intended to limit the scope of this application.
[0020] It should be noted that when a component is referred to as being "fixed to" or "set on" another component, it can be directly on or indirectly on that other component. When a component is referred to as being "connected to" another component, it can be directly connected to or indirectly connected to that other component.
[0021] It should be understood that the terms "length", "width", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this application.
[0022] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this application, "multiple" means two or more, unless otherwise explicitly specified.
[0023] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments.
[0024] Before providing a detailed explanation of the embodiments of this application, the application scenarios of the embodiments of this application will be described first.
[0025] In industries such as consumer electronics and consumer goods manufacturing, product packaging and screen printing design documents typically include sales order information. Each order may require updating the design documents containing single or multiple categories of changes, such as customer PO numbers, colors, models, and countries of origin, based on changes in the sales order batch. For example, a product may have four colors, each corresponding to a new sales order. Each sales order might involve four design documents related to the customer PO number: product screen printing, product packaging box, packaging box sticker, and outer carton sticker. If the customer requires updating the customer PO number for each order, and each order includes four sales orders corresponding to the four colors, then each order requires updating the customer PO number in 16 design documents. This leads to problems such as wasted human resources and a high error rate in revisions. The method for updating design documents containing sales order information in this application only requires creating a design document update association mapping table based on the original design document containing sales order information and the correspondence between the change information of the new sales batch order and the original design document containing sales order information. The original design document containing sales order information and the design document update association mapping table are then used as the updated design document. This method is simple and easy to understand, greatly saving the labor cost of designers repeatedly modifying design documents, while also avoiding revision errors and reducing the error rate.
[0026] Please see Figure 1 The following describes a method for updating a design file containing sales order information, provided by an embodiment of this application.
[0027] The present invention provides a method for updating a design file containing sales order information, comprising the following steps: S1. Obtain change information for new sales batch orders; Specifically, design documents refer to the product packaging and screen printing design documents. Product packaging design documents generally include design documents for product packaging boxes, packaging box stickers, outer cartons, outer carton stickers, and instruction manuals. Product screen printing design documents generally refer to design documents that include the content to be screen printed on the product's exterior and the specific locations of the screen prints.
[0028] The change information for new sales batch orders refers to the information that differs between the second and subsequent batches of orders for the same product with the same appearance and shape, and the first or previous batch of orders. The design documents for the product packaging and appearance silkscreening contain change information related to the product sales order, which may include one or more information such as customer PO number, color, model or place of origin, which may cause the original design documents containing sales order information to need to be updated.
[0029] Obtaining change information for new sales batch orders includes: retrieving the category of change information from the new batch sales order information table; retrieving the content of the change information from the new batch sales order information table; and retrieving the change requirements for the change information from the new batch sales order information table. The category of change information generally involves one or more categories such as the customer PO number, color, model, or country of origin that need to be changed for this batch of sales orders; the content of the change information is the specific content corresponding to each category of change information; and the change requirements generally include specific requirements for the format, location, etc., of the changed content.
[0030] S2. Compare and analyze the obtained change information with the information in the original design file containing sales order information to determine whether the original design file containing sales order information needs to be updated. Specifically, if the obtained change information category appears in the original design file containing sales order information, then the original design file containing sales order information needs to be updated; if the obtained change information category does not appear in the original design file containing sales order information, then the original design file containing sales order information does not need to be updated.
[0031] S3. Create a design document update association mapping table based on the correspondence between the change information and the original design documents containing sales order information; Specifically, a design document update relationship mapping table can be created using a Microsoft Excel spreadsheet. This involves: first, creating a new Microsoft Excel spreadsheet on your computer; second, designing the table header in the new spreadsheet, specifically by entering information attributes sequentially in the first row, including sales order number, product model, customer PO number, change information, quantity, etc., with each attribute occupying a separate column; then, in the rows below the table header, corresponding to the information attributes in the header, first entering the sales order number, then sequentially entering the information attributes corresponding to that sales order number in the row containing the sales order number, until all sales order numbers and their corresponding information attributes are entered. Afterwards, edit the table content as needed and save it; finally, rename the saved Microsoft Excel spreadsheet to "Design Document Update Relationship Mapping Table".
[0032] Alternatively, a design document update relationship mapping table can be created using WPS Spreadsheet. The steps are as follows: First, create a new WPS Spreadsheet file on your computer. Second, design the table header in the new WPS Spreadsheet file as needed. Specifically, enter the information attributes sequentially in the first row of the WPS Spreadsheet file, including sales order number, product model, customer PO number, change information, quantity, etc., with each information attribute occupying a separate column. Then, in the rows below the table header, corresponding to the information attributes in the header, first enter the specific content of the sales order number, then sequentially enter the specific content of the information attributes corresponding to that sales order number in the row containing the sales order number, until all the specific content of the sales order number and its corresponding information attributes is entered. After that, edit the table content as needed and save it. Finally, rename the saved WPS Spreadsheet file to "Design Document Update Relationship Mapping Table".
[0033] The header of the updated association mapping table in the design document includes at least one unique information attribute for the corresponding specific content. In this invention, the unique information attribute for the corresponding specific content is the sales order number.
[0034] S4. Determine the updated design file by combining the original design file containing sales order information and the design file update association mapping table.
[0035] Specifically, the process of identifying the updated design files includes: first, creating a new folder on the computer; second, saving all the original design files containing sales order information and the design file update association mapping table together into the newly created folder; and finally, renaming the newly created folder according to the naming rules for the updated design file folder, thus confirming that both are the updated design files.
[0036] The following example, a change in the customer's PO number in a certain batch of sales orders, will be used to illustrate the invention.
[0037] A certain batch of sales orders corresponds to products with 4 colors. Each color corresponds to a sales order number and a customer PO number. The design files for the product packaging and screen printing of each color include 6 types of design files. These 6 types of design files are: packaging box, packaging box sticker, outer carton, outer carton sticker, instruction manual, and screen printing. Therefore, this batch of orders corresponds to a total of 24 product packaging and screen printing design files.
[0038] The first step is to obtain the change information for the new sales batch orders.
[0039] Specifically, the change information category obtained from the order information table for this batch only includes the customer PO number category. The specific content of the change information for the customer PO number category is obtained from the order information table for this batch. The change requirements for the change information for the customer PO number category obtained from the order information table for this batch generally include specific change requirements for the format of the change content, the location of the change, etc.
[0040] The second step is to compare and analyze the obtained change information with the information in the original design file that contains sales order information to determine whether the original design file containing sales order information needs to be updated.
[0041] The change information for the customer PO number category was compared and analyzed one by one with the design documents for the product packaging and appearance silk screen printing corresponding to the batch of orders. It was determined that the design documents that need to be updated due to the change information for the customer PO number category include four design documents in the packaging and appearance silk screen printing documents corresponding to each sales order of four colors: packaging box, packaging box sticker, outer carton sticker, and appearance silk screen printing. In total, there are 16 design documents that need to be updated.
[0042] The third step is to create a design document change association mapping table based on the correspondence between the change information and the original design documents containing sales order information.
[0043] First, create a new spreadsheet file on your computer.
[0044] Next, design the table header as needed in the newly created spreadsheet file. Open the newly created spreadsheet file and enter the information attributes in the first row of the table. Starting from the first information attribute in the first row, you can enter the sales order number, internal product model, customer model, color, order quantity, customer PO number, packaging box, packaging box sticker, outer carton sticker, and product silkscreen printing in sequence. Each information attribute occupies a separate column.
[0045] In the newly created spreadsheet file, in the four rows below the header, corresponding to the information attributes in the header, first enter the specific content of the four sales order numbers in sequence. Then, in the row containing each sales order number, enter the specific content of the information attribute corresponding to that sales order number in sequence. Continue until the specific content of the four sales order numbers and their corresponding information attributes is completed. Then, edit the table content as needed and save it.
[0046] Finally, rename the saved table file to "Design File" and update the customer PO number association mapping table.
[0047] Step 4: The original design documents and design documents containing sales order information, which are among the 16 documents that need to be updated, are identified in the customer PO number association mapping table as the updated design documents.
[0048] First, create a new folder on your computer. Next, save the 16 original design files containing sales order information and the updated customer PO number association mapping table to this new folder. Finally, rename the new folder according to the naming rules for the updated design files. For example, you can rename it to: Packaging and Silkscreen Design Files for Model XX with Order Number 111000. This will confirm the 16 original design files containing sales order information and the updated customer PO number association mapping table as the updated design files.
[0049] Compared with the prior art, the present invention has significant advantages and beneficial effects. Specifically, as can be seen from the above technical solution, the present invention provides a method for updating design files containing sales order information. This method can create a design file update association mapping table based on the correspondence between the change information of new sales batch orders and the original design files containing sales order information. This table records the original design files containing sales order information, the change information of the original design files containing sales order information involved in the change information of new sales batch orders, and the corresponding content binding relationship between the two, including the changed content and its location information in the original design files containing sales order information. Furthermore, by storing the original design files containing sales order information and the design file update association mapping table in a newly created folder, the original design files containing sales order information and the design file update association mapping table are determined as the updated design files, thereby realizing the updating of multiple design files containing sales order information. This method eliminates the need for packaging design engineers and structural design engineers to use their respective software to modify the original design documents containing sales order information and the updated drawings confirmed by the client. Instead, a single staff member creates a design document update relationship mapping table and uses the original design document containing sales order information and the mapping table to define the updated design document. This not only saves on the human resource costs of design engineers and communication costs with clients but also significantly reduces the error rate when updating a large number of traditional design documents.
[0050] The above are merely preferred embodiments of the present invention, and only specifically describe the technical principles of the present invention. These descriptions are only for explaining the principles of the present invention and should not be construed as limiting the scope of protection of the present invention in any way. Based on this explanation, any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention, as well as other specific embodiments of the present invention that can be conceived by those skilled in the art without creative effort, should be included within the scope of protection of the present invention.
Claims
1. An updating method of a design file containing sales order information, characterized by, The method includes the following steps: S1. Obtain change information for new sales batch orders; S2. Compare and analyze the obtained change information with the information in the original design file containing sales order information to determine whether the original design file containing sales order information needs to be updated. S3. Create a design document update association mapping table based on the correspondence between the change information and the original design documents containing sales order information; S4. Determine the updated design file by combining the original design file containing sales order information and the design file update association mapping table.
2. The method of updating a design file containing sales order information according to claim 1, characterized in that: The process of obtaining change information for new sales batch orders includes: Retrieve the category of the change information from the new batch order information table; Retrieve the content of the change information corresponding to the category of the change information from the new batch order information table; The change requirements are obtained from the new batch order information table.
3. The method for updating design files containing sales order information according to claim 1, characterized in that: The determination of whether the original design file containing sales order information needs to be updated includes: If the obtained change information category appears in the original design file containing sales order information, then the original design file containing sales order information needs to be updated. If the obtained change information category does not appear in the original design file containing sales order information, then it is not necessary to update the original design file containing sales order information.
4. The method for updating design files containing sales order information according to claim 3, characterized in that: The creation and design document update relationship mapping table includes: Create a new spreadsheet file on your computer; In the first row of the newly created spreadsheet file, design the table header with different information attributes occupying a separate column; In the row immediately below the table header, enter, edit, and save the specific content that corresponds one-to-one with the information attributes in the table header; Rename the saved table file to the Design File Update Association Mapping Table.
5. The method for updating design files containing sales order information according to claim 4, characterized in that: The design document updates the information attributes in the header of the association mapping table, including the unique sales order number.
6. The method for updating design files containing sales order information according to claim 4, characterized in that: The determination of the updated design file includes: Create a new folder on your computer; Save all the original design files containing sales order information that need to be updated, along with the design file update association mapping table, into the newly created folder. Rename the newly created folder according to the naming rules of the updated design file folder.
7. The method for updating design files containing sales order information according to claim 1, characterized in that: Design document updates refer to updates to the specific content of the information contained in the design documents for product packaging and screen printing.
8. The method for updating a design document containing sales order information according to any one of claims 1-7, characterized in that: The change information for the new sales batch order refers to information about different batches of products, including changes in PO number, color, model, or place of origin, which necessitates updating the original packaging and screen printing design documents accordingly.
9. The method for updating a design document containing sales order information according to any one of claims 1-7, characterized in that: The relationship mapping table was created using a Microsoft Excel spreadsheet file.
10. The method for updating a design document containing sales order information according to any one of claims 1-7, characterized in that: The relationship mapping table was created using a WPS spreadsheet file.