CN117078363A - Production feedback method, device, equipment and storage medium for online order - Google Patents
Production feedback method, device, equipment and storage medium for online order Download PDFInfo
- Publication number
- CN117078363A CN117078363A CN202311345129.1A CN202311345129A CN117078363A CN 117078363 A CN117078363 A CN 117078363A CN 202311345129 A CN202311345129 A CN 202311345129A CN 117078363 A CN117078363 A CN 117078363A
- Authority
- CN
- China
- Prior art keywords
- order
- production
- replacement
- bom
- factory
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 173
- 238000000034 method Methods 0.000 title claims abstract description 35
- 239000000463 material Substances 0.000 claims abstract description 213
- 238000012545 processing Methods 0.000 claims abstract description 38
- 238000012790 confirmation Methods 0.000 claims abstract description 26
- 238000012544 monitoring process Methods 0.000 claims abstract description 18
- 230000005540 biological transmission Effects 0.000 claims description 21
- 238000012986 modification Methods 0.000 claims description 11
- 230000004048 modification Effects 0.000 claims description 11
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims 1
- 239000000047 product Substances 0.000 description 19
- 229910000679 solder Inorganic materials 0.000 description 9
- 238000006467 substitution reaction Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 239000011232 storage material Substances 0.000 description 4
- 230000007547 defect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
- 239000011265 semifinished product Substances 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Marketing (AREA)
- Accounting & Taxation (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Finance (AREA)
- General Health & Medical Sciences (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Human Resources & Organizations (AREA)
- Primary Health Care (AREA)
- Tourism & Hospitality (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the field of production order matching, and discloses a production feedback method, device and equipment of an online order and a storage medium. The method comprises the following steps: receiving user order data of a network platform; according to the order BOM table, carrying out matching processing in a preset factory material library to generate a BOM material shortage set; inquiring the replacement materials in a factory material library to generate a replacement material table corresponding to the BOM material shortage set; based on the replacement material table, carrying out material shortage replacement processing on the order BOM table to obtain a production BOM table and a replacement rate; the method comprises the steps of sending a production BOM table, a replacement material table and a replacement rate to a network platform, and monitoring user confirmation information of the network platform; when monitoring, replacing the order BOM table in the user order data based on the production BOM table to obtain production order data; the production order data is sent to a factory order port. In the embodiment of the invention, the technical problem that the user order experience is affected due to deviation of the finished product and the online order is solved.
Description
Technical Field
The present invention relates to the field of production order matching, and in particular, to a method, an apparatus, a device, and a storage medium for online order production feedback.
Background
For current customer order acquisition, a customer selects a hardware combination of relevant parameters on an e-commerce platform for order transmission, and then transmits the customer order to a manufacturing plant, which completes the customer order. In theory, this operation can reduce the flow nodes between the manufacturing plant and the front-end electronics platform, not only reducing the product inventory pressure, but also increasing the manufacturing delivery rate for the customer order.
However, in reality, the raw materials and semi-finished products of the manufacturing plant are not manufactured by themselves, and are required to be provided by other plants on the supply chain, and the actual e-commerce platform data is that the materials provided by the supply chain plan are not materials actually existing in the inventory of the manufacturing plant. The material data of the e-commerce platform is not completely consistent with the material data in the actual warehouse, and the online order acquired by the e-commerce platform may not be completely realized. Therefore, aiming at the technical problem that the user order experience is affected due to deviation between a finished product and an online order caused by inconsistent material data of the current e-commerce platform and material data of a manufacturing factory, a new technology is needed to solve the current problem.
Disclosure of Invention
The invention mainly aims to solve the technical problem that the user order experience is affected due to deviation between a finished product and an online order caused by inconsistent material data of the current electronic commerce platform and material data of a manufacturing factory.
The first aspect of the present invention provides a production feedback method for an online order, comprising the steps of:
receiving user order data of a network platform, wherein the user order data comprises: an order BOM table;
according to the order BOM table, matching processing is carried out in a preset factory material library, and a BOM material shortage set is generated;
based on a preset replacement algorithm and the BOM material shortage set, inquiring and processing replacement materials in the factory material library, and generating a replacement material table corresponding to the BOM material shortage set;
based on the replacement material table, carrying out material shortage replacement processing on the order BOM table to obtain a production BOM table and a replacement rate;
transmitting the production BOM table, the replacement material table and the replacement rate to the network platform, and monitoring user confirmation information of the network platform;
when the user confirmation information is monitored, replacing the order BOM table in the user order data based on the production BOM table to obtain production order data;
the production order data is sent to a factory order port for the factory to make a product based on the production order data.
Optionally, in a first implementation manner of the first aspect of the present invention, the performing, in the factory material library, query processing of replacement materials based on a preset replacement algorithm and the BOM missing material set, and generating a replacement material table corresponding to the BOM missing material set includes:
extracting the names of the materials in the BOM material shortage set;
according to a preset material replacement rule, carrying out replacement processing on the material names to generate a replacement material alternative set;
according to the alternative material set, carrying out inventory query processing on the factory material library to generate an alternative material set corresponding to the material name;
and writing the replacement material set corresponding to the material name into a preset replacement material table frame to generate a replacement material table.
Optionally, in a second implementation manner of the first aspect of the present invention, the sending the production BOM table, the replacement material table, and the replacement rate to the network platform includes:
splicing and packaging the production BOM table, the replacement material table and the replacement rate to generate a transmission packet;
and sending the transmission packet to the network platform by using a TCP/IP protocol.
Optionally, in a third implementation manner of the first aspect of the present invention, the sending the production order data to a factory order port, so that the factory performs product manufacturing based on the production order data includes:
backing up the production order data to a preset cloud database;
and when receiving backup success information fed back by the preset cloud database, sending the production order data to a factory order port so that a factory can manufacture products based on the production order data.
Optionally, in a fourth implementation manner of the first aspect of the present invention, the monitoring the user acknowledgement information of the network platform includes:
and monitoring information transmission of the confirmed API interface in the network platform by using Webhook.
Optionally, in a fifth implementation manner of the first aspect of the present invention, the replacing the order BOM table in the user order data based on the production BOM table, to obtain production order data includes:
and copying and replacing the order BOM table in the user order data by the production BOM table based on the subject name of the order BOM table to generate production order data.
Optionally, in a sixth implementation manner of the first aspect of the present invention, the performing, based on the replacement material table, a material shortage replacement process on the order BOM table, to obtain a production BOM table and a replacement rate includes:
based on the UPDATE statement, modifying data corresponding to the target replacement code in the order BOM table by utilizing the target replacement code of the replacement material table, and generating a production BOM table;
and calculating the modification rate of the material codes in the order BOM table to obtain the replacement rate.
The second aspect of the present invention provides a production feedback device for an online order, the production feedback device for an online order comprising:
the receiving module is used for receiving user order data of the network platform, wherein the user order data comprises: an order BOM table;
the matching module is used for carrying out matching processing in a preset factory material library according to the order BOM table to generate a BOM material shortage set;
the query module is used for carrying out query processing on the replacement materials in the factory material library based on a preset replacement algorithm and the BOM material shortage set, and generating a replacement material table corresponding to the BOM material shortage set;
the replacement module is used for carrying out material shortage replacement processing on the order BOM table based on the replacement material table to obtain a production BOM table and a replacement rate;
the monitoring and confirming module is used for sending the production BOM table, the replacement material table and the replacement rate to the network platform and monitoring user confirmation information of the network platform;
the order modification module is used for replacing the order BOM table in the user order data based on the production BOM table when the user confirmation information is monitored, so as to obtain production order data;
and the order transmission module is used for sending the production order data to a factory order port so that a factory can manufacture products based on the production order data.
A third aspect of the present invention provides a production feedback device for an online order, comprising: a memory and at least one processor, the memory having instructions stored therein, the memory and the at least one processor being interconnected by a line; the at least one processor invokes the instructions in the memory to cause the production feedback device of the online order to perform the production feedback method of the online order described above.
A fourth aspect of the present invention provides a computer readable storage medium having instructions stored therein which, when run on a computer, cause the computer to perform the production feedback method of an online order described above.
In the embodiment of the invention, the material replacement scheme is carried out on the material lacking in the actual storage materials in the BOM matching result by comparing the online acquired order data with the material data stored in the material library, the actual production information of the BOM list and the substitution rate which can be actually manufactured is sent to a customer for confirmation, and the BOM list which can ensure that the online order of the user is completely consistent with the actual production order after the user determines, thereby solving the technical problem that the deviation between the finished product and the online order is caused to influence the user order experience due to the fact that the material data of the current electronic commerce platform is inconsistent with the material data of a manufacturing factory.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a method for production feedback of an online order in an embodiment of the present invention;
FIG. 2 is a schematic diagram of an embodiment of an on-line order production feedback device according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of another embodiment of an on-line order production feedback device according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an embodiment of an on-line order production feedback device in accordance with an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a production feedback method, device and equipment of an online order and a storage medium.
The terms "first," "second," "third," "fourth" and the like in the description and in the claims and in the above drawings, if any, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or apparatus.
For ease of understanding, a specific flow of an embodiment of the present invention is described below with reference to fig. 1, and an embodiment of a method for online order production feedback in an embodiment of the present invention includes:
101. receiving user order data of a network platform, wherein the user order data comprises: an order BOM table;
in this embodiment, the user order data of the network platform includes some information such as user ID, payment account number, order BOM table, total number of orders, and detailed data such as receiving address and user phone number.
102. According to the order BOM table, matching processing is carried out in a preset factory material library, and a BOM material shortage set is generated;
in this embodiment, the order BOM table is specific data in the user order data, where the order BOM may be { screw: 20, control panel: 1, radiator: 1, display card A:1, memory bank B:2, solder paste: 1 }, inquiring and matching screws, a control board, a radiator and solder paste in a factory material library, but not inquiring a display card A and a memory bank B, and generating a BOM material shortage set { display card A:1, memory bank B:2 }.
103. Based on a preset replacement algorithm and the BOM material shortage set, inquiring and processing replacement materials in the factory material library, and generating a replacement material table corresponding to the BOM material shortage set;
in this embodiment, the BOM defect set { graphic card a) is replaced according to several preset equivalent materials: 1, memory bank B:2, inquiring data in a factory material library to obtain 1 material of the display card A, wherein 1 material of the display card B is replaced by 1 material of the memory bank B, and two materials of the memory bank B are replaced by one material of the memory bank C to obtain a replacement material table { display card A: 1: display card B:1, memory bank B: 2: memory bank C:1 }.
Further, at 103, the following steps may be performed:
1031. extracting the names of the materials in the BOM material shortage set;
1032. according to a preset material replacement rule, carrying out replacement processing on the material names to generate a replacement material alternative set;
1033. according to the alternative material set, carrying out inventory query processing on the factory material library to generate an alternative material set corresponding to the material name;
1034. and writing the replacement material set corresponding to the material name into a preset replacement material table frame to generate a replacement material table.
In 1031-1034 steps, extracting { display card A ] in BOM material shortage set: 1, memory bank B:2 display cards A, based on the preset materials with one display card A replaced by one display card B, one display card C, one display card D, one display card E and two display cards F, generating a replacement material alternative set { display card B:1, display card C:1, display card D:1, display card E:1, display card F:2 }. The current stock of the data of the factory material library is queried based on the materials of the display card B, the display card C, the display card D, the display card E and the display card F, namely the stock of the display card B is only queried, namely { in the replacement material table frame: : : …,: : : content of { graphic card a: 1: display card B: 1: : : similar steps are also performed on the memory bank B, and finally, a replacement material table { graphic card a: 1: display card B:1, memory bank B: 2: memory bank C:1 }.
104. Based on the replacement material table, carrying out material shortage replacement processing on the order BOM table to obtain a production BOM table and a replacement rate;
in this embodiment, { graphic card A: 1: display card B:1, memory bank B: 2: memory bank C:1 }, for order BOM table { screw: 20, control panel: 1, radiator: 1, display card A:1, memory bank B:2, solder paste: 1 }, resulting in a production BOM table { screw: 20, control panel: 1, radiator: 1, display card B:1, memory bank C:1, solder paste: 1 }, and a substitution rate of 33%.
Further, 104 may perform the following steps:
1041. based on the UPDATE statement, modifying data corresponding to the target replacement code in the order BOM table by utilizing the target replacement code of the replacement material table, and generating a production BOM table;
1042. and calculating the modification rate of the material codes in the order BOM table to obtain the replacement rate.
In 1041-1042 steps { graphic card A: 1: display card B:1, memory bank B: 2: memory bank C:1 }, and { screw: 20, control panel: 1, radiator: 1, display card A:1, memory bank B:2, solder paste: 1, performing splicing processing, and then performing replacement processing on the data of the related display card A and the related memory bank B by using an UPDATE statement to generate a BOM (binary object model) table { screw: 20, control panel: 1, radiator: 1, display card B:1, memory bank C:1, solder paste: 1, a total of 6 materials modified 2 material codes with a modification rate of 33%, i.e. a replacement rate of 33%.
105. Transmitting the production BOM table, the replacement material table and the replacement rate to the network platform, and monitoring user confirmation information of the network platform;
in this example, a BOM table { screw: 20, control panel: 1, radiator: 1, display card B:1, memory bank C:1, solder paste: 1 }, replace materials table { graphics card a: 1: display card B:1, memory bank B: 2: memory bank C:1 }, the replacement rate is 33% to the original network platform, then monitor whether the network platform will feedback the confirmation information of the user, only can the user confirm the situation to make.
Further, "send the production BOM table, the replacement materials table, the replacement rate to the network platform" may perform the following steps:
1051. splicing and packaging the production BOM table, the replacement material table and the replacement rate to generate a transmission packet;
1052. and sending the transmission packet to the network platform by using a TCP/IP protocol.
In the step 1051-1052, the production BOM table, the replacement material table and the replacement rate may be packaged according to the order 1, 2 and 3 to generate a transmission packet. Based on the TCP/IP protocol, a link interface using a specific HTTP is sent into the network platform.
Further, the "listening to the user acknowledgement information of the network platform" may perform the following steps:
1053. and monitoring information transmission of the confirmed API interface in the network platform by using Webhook.
In step 1053, webhook is a callback mechanism for Web applications that can automatically send HTTP requests to specified URLs when certain events occur. When the event is triggered, the Webhook sends the data to a preset URL address in the form of a POST request of HTTP, and the receiver can perform operations such as data processing, push notification and the like according to a preset processing mode. And monitoring information callback of clicking operation of a confirmation API (confirmation button) in the network platform by utilizing a callback mechanism of Webhook.
106. When the user confirmation information is monitored, replacing the order BOM table in the user order data based on the production BOM table to obtain production order data;
in this embodiment, if a callback confirmation instruction is monitored, the order BOM table in the user order data is directly replaced with the production BOM table, and the new production order data is combined.
Further, 106 may perform the following steps:
1061. and copying and replacing the order BOM table in the user order data by the production BOM table based on the subject name of the order BOM table to generate production order data.
In step 1061, order BOM table { 1-screw: 20, 2-control panels: 1, 3-heat sink: 1, 4-graphics card A:1, 5-memory bank B:2, 6-solder paste: the subject names of 1 } may be numbers 1-6, while the BOM table { 1-screw is produced: 20, 2-control panels: 1, 3-heat sink: 1, 4-display card B:1, 5-memory bank C:1, 6-solder paste: 1 numbers are 1-6, and the data of the numbers 1-6 are copied to replace an order BOM table in the user order data to generate production order data. The method is used for converting the production BOM table into the CSV format table for export, and then writing the CSV format table into the user order data so as to carry out replacement processing on the order BOM table and generate the production order data.
107. The production order data is sent to a factory order port for the factory to make a product based on the production order data.
In this embodiment, the production order data is sent to the factory order port, and in the production order data, besides the production BOM table, some information such as the user ID, the payment account number, the total number of orders, and the like, and detailed data such as the receiving address, the user mobile phone number, and the like are included, so that the factory manufacturing is completed, and the customer is directly sent to perform the product manufacturing.
Further, at 107, the following steps may be performed:
1071. backing up the production order data to a preset cloud database;
1072. and when receiving backup success information fed back by the preset cloud database, sending the production order data to a factory order port so that a factory can manufacture products based on the production order data.
In step 1071-1072, in order to prevent the loss of the production order data of the user during the transmission process, the production order data is uploaded to the cloud database, and the production order data is sent to the factory order port after the backup of the cloud database is completed, so that the factory can manufacture products based on the production order data.
In the embodiment of the invention, the material replacement scheme is carried out on the material lacking in the actual storage materials in the BOM matching result by comparing the online acquired order data with the material data stored in the material library, the actual production information of the BOM list and the substitution rate which can be actually manufactured is sent to a customer for confirmation, and the BOM list which can ensure that the online order of the user is completely consistent with the actual production order after the user determines, thereby solving the technical problem that the deviation between the finished product and the online order is caused to influence the user order experience due to the fact that the material data of the current electronic commerce platform is inconsistent with the material data of a manufacturing factory.
The method for feeding back the online order in the embodiment of the present invention is described above, and the following describes a device for feeding back the online order in the embodiment of the present invention, referring to fig. 2, and one embodiment of the device for feeding back the online order in the embodiment of the present invention includes:
a receiving module 201, configured to receive user order data of a network platform, where the user order data includes: an order BOM table;
the matching module 202 is configured to perform matching processing in a preset factory material library according to the order BOM table, so as to generate a BOM material shortage set;
the query module 203 is configured to perform query processing on a replacement material in the factory material library based on a preset replacement algorithm and the BOM material shortage set, and generate a replacement material table corresponding to the BOM material shortage set;
a replacing module 204, configured to perform a material shortage replacing process on the order BOM table based on the replacing material table, to obtain a production BOM table and a replacement rate;
the monitoring confirmation module 205 is configured to send the production BOM table, the replacement material table, and the replacement rate to the network platform, and monitor user confirmation information of the network platform;
an order modification module 206, configured to replace an order BOM table in the user order data based on the production BOM table when the user confirmation information is monitored, so as to obtain production order data;
an order transmission module 207 for sending the production order data to a factory order port for the factory to make product manufacture based on the production order data.
In the embodiment of the invention, the material replacement scheme is carried out on the material lacking in the actual storage materials in the BOM matching result by comparing the online acquired order data with the material data stored in the material library, the actual production information of the BOM list and the substitution rate which can be actually manufactured is sent to a customer for confirmation, and the BOM list which can ensure that the online order of the user is completely consistent with the actual production order after the user determines, thereby solving the technical problem that the deviation between the finished product and the online order is caused to influence the user order experience due to the fact that the material data of the current electronic commerce platform is inconsistent with the material data of a manufacturing factory.
Referring to fig. 3, another embodiment of an on-line order production feedback device according to an embodiment of the present invention includes:
a receiving module 201, configured to receive user order data of a network platform, where the user order data includes: an order BOM table;
the matching module 202 is configured to perform matching processing in a preset factory material library according to the order BOM table, so as to generate a BOM material shortage set;
the query module 203 is configured to perform query processing on a replacement material in the factory material library based on a preset replacement algorithm and the BOM material shortage set, and generate a replacement material table corresponding to the BOM material shortage set;
a replacing module 204, configured to perform a material shortage replacing process on the order BOM table based on the replacing material table, to obtain a production BOM table and a replacement rate;
the monitoring confirmation module 205 is configured to send the production BOM table, the replacement material table, and the replacement rate to the network platform, and monitor user confirmation information of the network platform;
an order modification module 206, configured to replace an order BOM table in the user order data based on the production BOM table when the user confirmation information is monitored, so as to obtain production order data;
an order transmission module 207 for sending the production order data to a factory order port for the factory to make product manufacture based on the production order data.
The query module 203 is specifically configured to:
extracting the names of the materials in the BOM material shortage set;
according to a preset material replacement rule, carrying out replacement processing on the material names to generate a replacement material alternative set;
according to the alternative material set, carrying out inventory query processing on the factory material library to generate an alternative material set corresponding to the material name;
and writing the replacement material set corresponding to the material name into a preset replacement material table frame to generate a replacement material table.
The snoop confirm module 205 is specifically configured to:
splicing and packaging the production BOM table, the replacement material table and the replacement rate to generate a transmission packet;
and sending the transmission packet to the network platform by using a TCP/IP protocol.
Wherein, the snoop confirm module 205 is further specifically configured to:
and monitoring information transmission of the confirmed API interface in the network platform by using Webhook.
Wherein, the order transmission module 207 comprises:
a backup unit 2071, configured to backup the production order data to a preset cloud database;
and the transmission unit 2072 is used for sending the production order data to a factory order port when receiving the backup success information fed back by the preset cloud database, so that the factory can manufacture products based on the production order data.
Wherein, the order modification module 206 is specifically configured to:
and copying and replacing the order BOM table in the user order data by the production BOM table based on the subject name of the order BOM table to generate production order data.
Wherein, the replacing module 204 is specifically configured to:
based on the UPDATE statement, modifying data corresponding to the target replacement code in the order BOM table by utilizing the target replacement code of the replacement material table, and generating a production BOM table;
and calculating the modification rate of the material codes in the order BOM table to obtain the replacement rate.
In the embodiment of the invention, the material replacement scheme is carried out on the material lacking in the actual storage materials in the BOM matching result by comparing the online acquired order data with the material data stored in the material library, the actual production information of the BOM list and the substitution rate which can be actually manufactured is sent to a customer for confirmation, and the BOM list which can ensure that the online order of the user is completely consistent with the actual production order after the user determines, thereby solving the technical problem that the deviation between the finished product and the online order is caused to influence the user order experience due to the fact that the material data of the current electronic commerce platform is inconsistent with the material data of a manufacturing factory.
The above-mentioned fig. 2 and fig. 3 describe in detail the production feedback device of the online order in the embodiment of the present invention from the point of view of the modularized functional entity, and the following describes in detail the production feedback device of the online order in the embodiment of the present invention from the point of view of hardware processing.
Fig. 4 is a schematic diagram of an on-line order production feedback device 400 according to an embodiment of the present invention, where the on-line order production feedback device 400 may have a relatively large difference due to different configurations or performances, and may include one or more processors (central processing units, CPU) 410 (e.g., one or more processors) and a memory 420, and one or more storage media 430 (e.g., one or more mass storage devices) storing an application 433 or data 432. Wherein memory 420 and storage medium 430 may be transitory or persistent storage. The program stored on the storage medium 430 may include one or more modules (not shown), each of which may include a series of instruction operations in the production feedback device 400 for an online order. Still further, the processor 410 may be configured to communicate with the storage medium 430 to execute a series of instruction operations in the storage medium 430 on the production feedback device 400 of the online order.
The online order based production feedback apparatus 400 may also include one or more power supplies 440, one or more wired or wireless network interfaces 450, one or more input/output interfaces 460, and/or one or more operating systems 431, such as Windows Serve, mac OS X, unix, linux, freeBSD, and the like. Those skilled in the art will appreciate that the production feedback device configuration of the online order shown in FIG. 4 does not constitute a limitation of the production feedback device based on the online order, and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.
The present invention also provides a computer readable storage medium, which may be a non-volatile computer readable storage medium, or a volatile computer readable storage medium, having stored therein instructions that, when executed on a computer, cause the computer to perform the steps of the online order production feedback method.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the system or apparatus and unit described above may refer to the corresponding process in the foregoing method embodiment, which is not repeated herein.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a random access memory (random access memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. The production feedback method of the online order is characterized by comprising the following steps:
receiving user order data of a network platform, wherein the user order data comprises: an order BOM table;
according to the order BOM table, matching processing is carried out in a preset factory material library, and a BOM material shortage set is generated;
based on a preset replacement algorithm and the BOM material shortage set, inquiring and processing replacement materials in the factory material library, and generating a replacement material table corresponding to the BOM material shortage set;
based on the replacement material table, carrying out material shortage replacement processing on the order BOM table to obtain a production BOM table and a replacement rate;
transmitting the production BOM table, the replacement material table and the replacement rate to the network platform, and monitoring user confirmation information of the network platform;
when the user confirmation information is monitored, replacing the order BOM table in the user order data based on the production BOM table to obtain production order data;
the production order data is sent to a factory order port for the factory to make a product based on the production order data.
2. The method for feeding back production of online orders according to claim 1, wherein the step of performing query processing of replacement materials in the factory material library based on a preset replacement algorithm and the BOM missing material set, and the step of generating a replacement material table corresponding to the BOM missing material set comprises the steps of:
extracting the names of the materials in the BOM material shortage set;
according to a preset material replacement rule, carrying out replacement processing on the material names to generate a replacement material alternative set;
according to the alternative material set, carrying out inventory query processing on the factory material library to generate an alternative material set corresponding to the material name;
and writing the replacement material set corresponding to the material name into a preset replacement material table frame to generate a replacement material table.
3. The method of claim 1, wherein the sending the production BOM table, the replacement materials table, and the replacement rate to the network platform comprises:
splicing and packaging the production BOM table, the replacement material table and the replacement rate to generate a transmission packet;
and sending the transmission packet to the network platform by using a TCP/IP protocol.
4. The method of claim 1, wherein the sending the production order data to a factory order port for a factory to make a product based on the production order data comprises:
backing up the production order data to a preset cloud database;
and when receiving backup success information fed back by the preset cloud database, sending the production order data to a factory order port so that a factory can manufacture products based on the production order data.
5. The method of claim 1, wherein monitoring the network platform for user confirmation information comprises:
and monitoring information transmission of the confirmed API interface in the network platform by using Webhook.
6. The method of claim 1, wherein replacing the order BOM table in the user order data based on the production BOM table, obtaining production order data comprises:
and copying and replacing the order BOM table in the user order data by the production BOM table based on the subject name of the order BOM table to generate production order data.
7. The method for feeding back production of online orders according to claim 1, wherein said performing a material shortage replacement process on the order BOM table based on the replacement material table, to obtain a production BOM table and a replacement rate comprises:
based on the UPDATE statement, modifying data corresponding to the target replacement code in the order BOM table by utilizing the target replacement code of the replacement material table, and generating a production BOM table;
and calculating the modification rate of the material codes in the order BOM table to obtain the replacement rate.
8. A production feedback device for an online order, wherein the production feedback device for an online order comprises:
the receiving module is used for receiving user order data of the network platform, wherein the user order data comprises: an order BOM table;
the matching module is used for carrying out matching processing in a preset factory material library according to the order BOM table to generate a BOM material shortage set;
the query module is used for carrying out query processing on the replacement materials in the factory material library based on a preset replacement algorithm and the BOM material shortage set, and generating a replacement material table corresponding to the BOM material shortage set;
the replacement module is used for carrying out material shortage replacement processing on the order BOM table based on the replacement material table to obtain a production BOM table and a replacement rate;
the monitoring and confirming module is used for sending the production BOM table, the replacement material table and the replacement rate to the network platform and monitoring user confirmation information of the network platform;
the order modification module is used for replacing the order BOM table in the user order data based on the production BOM table when the user confirmation information is monitored, so as to obtain production order data;
and the order transmission module is used for sending the production order data to a factory order port so that a factory can manufacture products based on the production order data.
9. A production feedback device for an online order, the production feedback device for an online order comprising: a memory and at least one processor, the memory having instructions stored therein, the memory and the at least one processor being interconnected by a line;
the at least one processor invoking the instructions in the memory to cause the production feedback device of the online order to perform the production feedback method of an online order of any of claims 1-7.
10. A computer readable storage medium having stored thereon a computer program, which when executed by a processor implements the method of production feedback of an online order according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311345129.1A CN117078363A (en) | 2023-10-18 | 2023-10-18 | Production feedback method, device, equipment and storage medium for online order |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311345129.1A CN117078363A (en) | 2023-10-18 | 2023-10-18 | Production feedback method, device, equipment and storage medium for online order |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117078363A true CN117078363A (en) | 2023-11-17 |
Family
ID=88704762
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311345129.1A Pending CN117078363A (en) | 2023-10-18 | 2023-10-18 | Production feedback method, device, equipment and storage medium for online order |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117078363A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117314133A (en) * | 2023-11-30 | 2023-12-29 | 广州汇通国信科技有限公司 | Intelligent flow integrating system based on business center |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7233914B1 (en) * | 2000-12-27 | 2007-06-19 | Joyo Wijaya | Technique for implementing item substitution for unavailable items relating to a customer order |
| US20100042516A1 (en) * | 2008-08-13 | 2010-02-18 | International Business Machines Corporation | Part Number Set Substitution |
| CN113627745A (en) * | 2021-07-21 | 2021-11-09 | 苏州慧工云信息科技有限公司 | Material demand planning method and system |
| CN114782130A (en) * | 2022-04-07 | 2022-07-22 | 联宝(合肥)电子科技有限公司 | Planning system and operation method for production enterprise integration |
| CN116843197A (en) * | 2023-06-29 | 2023-10-03 | 中科云谷科技有限公司 | Method, device and storage medium for generating material alternatives |
-
2023
- 2023-10-18 CN CN202311345129.1A patent/CN117078363A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7233914B1 (en) * | 2000-12-27 | 2007-06-19 | Joyo Wijaya | Technique for implementing item substitution for unavailable items relating to a customer order |
| US20100042516A1 (en) * | 2008-08-13 | 2010-02-18 | International Business Machines Corporation | Part Number Set Substitution |
| CN113627745A (en) * | 2021-07-21 | 2021-11-09 | 苏州慧工云信息科技有限公司 | Material demand planning method and system |
| CN114782130A (en) * | 2022-04-07 | 2022-07-22 | 联宝(合肥)电子科技有限公司 | Planning system and operation method for production enterprise integration |
| CN116843197A (en) * | 2023-06-29 | 2023-10-03 | 中科云谷科技有限公司 | Method, device and storage medium for generating material alternatives |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117314133A (en) * | 2023-11-30 | 2023-12-29 | 广州汇通国信科技有限公司 | Intelligent flow integrating system based on business center |
| CN117314133B (en) * | 2023-11-30 | 2024-03-29 | 广州汇通国信科技有限公司 | Intelligent flow integrating system based on business center |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20230169463A1 (en) | Inventory information distribution systems, devices and methods | |
| CN117078363A (en) | Production feedback method, device, equipment and storage medium for online order | |
| CN104283967A (en) | Third-party data service system based on Internet-of-Things data collecting | |
| US20170372243A1 (en) | System and method for inventory management, cost savings delivery and decision making | |
| CN112102001A (en) | Product quotation method and related equipment | |
| US20040015543A1 (en) | Manufacturing data access | |
| JP2005165610A (en) | Transaction processing system and method | |
| CN101393617A (en) | Material logistic system and method on production site | |
| CN113706254A (en) | Online material management method, device and equipment based on bill and storage medium | |
| JP2017102651A (en) | Parts procurement system | |
| WO2021024205A1 (en) | Method and system of optimizing stock availability and sales opportunity | |
| CN111222805A (en) | Printed circuit board order distribution system | |
| CN112214510B (en) | Dynamic source searching method, device and system for purchasing demand and storage medium | |
| CN115174543B (en) | Version update release time determining method and device | |
| TWI300179B (en) | ||
| CN117171215A (en) | Processing method, device, equipment and storage medium based on historical data | |
| JP2018055329A (en) | Manufacturing management system | |
| JP2006318265A (en) | Commodity management device, commodity management method and program | |
| JP2005196346A (en) | Management device for automatic vending machine | |
| CN116050791A (en) | Production line quality control method and system based on industrial Internet of things | |
| CN114462733A (en) | Order processing method and device based on order management platform and order management platform | |
| JP2005182244A (en) | Stock ordering device and method and stock ordering program | |
| CN117745100A (en) | Product management method and system adapting to multiple production scenes | |
| CN116415863A (en) | Method, device, equipment and storage medium for processing on-road express information query | |
| CN117033809A (en) | Equipment circulation information query method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |