Electronic bidding method, device and computer-readable storage medium

Abstract

The present invention discloses an electronic bidding method, device, and computer-readable storage medium. The method comprises the following steps: a data application system sets a price catalog hierarchy for different procurement business needs by presetting decomposition requirements to meet the personalized needs of quotations, forms a first tolerance table, and sends the first tolerance table to an electronic quotation system. The script code is modified and run through Outlook, KEY values, and macro codes to trigger inquiries from a tender invitation template and collect inquiry information on schedule. A bid opening information registration form is formed through a bid opening operation, and the bid opening information registration form is released synchronously when a preset release condition is triggered, thereby achieving efficiency improvement and price fairness. When the above process is carried out, electronic bidding obtains a large amount of indicators and data, and the decision-making end can use this data to carry out work related to component cost analysis, forming a completely open, fair, and transparent bidding process.

Description

Technical Field

[0001] The present invention relates to the technical field of bidding and tendering, and in particular to an electronic bidding and tendering method, device and computer-readable storage medium. Background Art

[0002] The current bidding process in the market mainly consists of demand analysis, quotation inquiry, target price acquisition and bid opening. Before setting the purchase price, the buyer needs to issue a bidding invitation to the suppliers shortlisted by the JPC (Joint Procurement Consortium) or the annual large-order suppliers, and promptly collect the bidding intentions, bid prices and business conditions in order to obtain low parts prices and better production volume in a fully competitive manner.

[0003] However, the above-mentioned bidding method has an incompletely open, fair and transparent bidding process. Since each link of the above-mentioned bidding method is manually issued, collected and counted, it is very easy to have problems such as bid rigging, collusion, incomplete statistical data and corruption, making it difficult to gain the trust of suppliers. In addition, the manual operation process cannot quickly analyze and verify various data tables, resulting in low efficiency. Summary of the Invention

[0004] The main purpose of the present invention is to provide an electronic bidding method, device and computer-readable storage medium, aiming to solve the technical problems that the existing bidding method has an incompletely open, fair and transparent bidding process, which makes it difficult for suppliers to be convinced of the final bid opening, and the manual operation is inefficient.

[0005] To achieve the above object, the present invention provides an electronic bidding method, which comprises the following steps:

[0006] When the data application system receives an input data report, it analyzes and processes the data report based on preset decomposition requirements to obtain a first tolerance table;

[0007] Sending the first tolerance table to an electronic quotation system so that the electronic quotation system can run the electronic bidding logic according to the first tolerance table and generate a final price analysis report;

[0008] The final price analysis report returned by the electronic quotation system is received so as to carry out procurement bidding according to the final price analysis report.

[0009] Optionally, the step of the data application system receiving an input data report and analyzing and processing the data report based on preset decomposition requirements to obtain a first tolerance table includes:

[0010] After receiving the input data report, the data report is grouped based on the preset decomposition requirements to obtain a number of data decomposition sub-tables;

[0011] Supplier basic data is obtained, and the supplier basic data and a plurality of data decomposition sub-tables are integrated to form a first tolerance table.

[0012] Optionally, the step of sending the first tolerance table to an electronic quotation system so that the electronic quotation system performs electronic bidding logic according to the first tolerance table to form a final price analysis report includes:

[0013] After sending the first tolerance table to the electronic quotation system, the electronic quotation system generates a corresponding tender invitation letter template and a first quotation import table;

[0014] triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template and generates a price inquiry information registration form based on the first quotation import form;

[0015] Based on the electronic quotation system, generating a benchmark price analysis table according to the inquiry information registration table, and receiving the target price released by the collaborative platform based on the benchmark price analysis table, so as to trigger the bid opening operation according to the target price;

[0016] A final price analysis report is generated based on the bid opening operation of the electronic quotation system.

[0017] Optionally, before the step of triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template, the step further includes:

[0018] The supplier basic data in the first tolerance table is extracted through the electronic quotation system to form a second tolerance table, and a corresponding bidding invitation letter is generated based on the supplier basic data.

[0019] Optionally, the step of triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template, and generating a price inquiry information registration form based on the first quotation import form includes:

[0020] Triggering Outlook based on a local tool, sending the tender invitation letter and the second tolerance table to a corresponding Outlook destination through the inquiry operation of the electronic quotation system;

[0021] The electronic quotation system receives the quotation inquiry information returned by the Outlook destination and imports it into the first quotation import table to form a quotation inquiry information registration table.

[0022] Optionally, the step of triggering a bid opening operation according to the target price includes:

[0023] After the electronic quotation system detects the target price, it generates a bid opening invitation letter, a second quotation import table, and a third tolerance table;

[0024] triggering Outlook based on a local tool, and sending the bid opening invitation letter and the third tolerance table to a corresponding Outlook destination through the bid opening operation of the electronic quotation system;

[0025] The electronic quotation system receives the bid opening information returned by the Outlook destination and imports it into the second quotation import table to form a bid opening information registration table.

[0026] Optionally, after the step of importing the second quotation import table to form a bid opening information registration table, the method further includes:

[0027] Detecting whether the bid opening information registration form triggers a preset release condition;

[0028] If the bid opening information registration form triggers the preset release condition, the bid opening information registration form and the supplier basic data are matched by the KEY value to obtain the bid quotation form of the participating suppliers;

[0029] Receive the final price analysis report returned by the bidding supplier after the quotation form is released.

[0030] Optionally, after the step of detecting whether the bid opening information registration form triggers a preset release condition, the method further includes:

[0031] If the bid opening information registration form does not trigger the preset release condition, no release operation is performed.

[0032] In addition, to achieve the above-mentioned purpose, the present invention also provides an electronic bidding device, including a memory, a processor, and a computer program stored in the memory and runnable on the processor, wherein the computer program implements the steps of the above-mentioned electronic bidding method when executed by the processor.

[0033] In addition, to achieve the above-mentioned purpose, the present invention also provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the above-mentioned electronic bidding method are implemented.

[0034] The present invention transforms all traditional manual bidding methods into digital and highly integrated electronic bidding methods, avoiding the problems of corruption or inefficiency caused by human intervention or human influence in the existing manual bidding process. By completing the statistics, analysis and processing of personalized data reports by the data application system, the problems of low efficiency and processing errors in data report processing in manual operation are avoided, which can not only effectively improve the efficiency of data report processing, but also reduce labor costs. The bidding process of inquiry and quotation, target price acquisition and bid opening is automatically completed through the electronic quotation system, which fundamentally eliminates the impact of adverse situations such as bid rigging, collusion, data leakage, etc. caused by human intervention or human operation, enhances the trust of suppliers, and ensures a completely open, fair and transparent bidding process. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 It is a schematic diagram of the terminal structure of the hardware operating environment involved in the embodiment of the present invention;

[0036] Figure 2 This is a flow chart of an embodiment of the electronic bidding method of the present invention applied to a data application system;

[0037] Figure 3 This is a flow chart of an embodiment of the electronic bidding method of the present invention applied to an electronic quotation system;

[0038] Figure 4 for Figure 2 Detailed flow chart of step S50;

[0039] Figure 5 for Figure 2 Detailed flow chart of step S60;

[0040] Figure 6 This is a schematic diagram of the offline process of the conventional manual bidding method;

[0041] Figure 7 It is a schematic diagram of the online process of the electronic bidding method of the present invention.

[0042] The purpose, features and advantages of the present invention will be further described with reference to the accompanying drawings and in conjunction with the embodiments. DETAILED DESCRIPTION

[0043] It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.

[0044] The main solution of the embodiment of the present invention is: by transforming all traditional bidding process operations into a digital and highly integrated electronic bidding method, the manual operation method existing in the existing bidding method is eliminated and all operations are changed to macro code operation methods, thereby building a database management, information query and analysis function, and building a full-process, paperless innovative procurement transaction method.

[0045] Due to existing technology, the current bidding process in the procurement process is manually issued, collected, and counted. The statistical data is incomplete and prone to errors, which makes it inefficient. Because the self-opening bidding process is not open and transparent, there is a problem of insufficient trust in suppliers. At the same time, the cost surge caused by manual labor in all links is not conducive to the company's cost reduction and efficiency improvement.

[0046] The present invention provides a solution that only requires converting all existing manual operation links into macro codes and inputting them into the operating system, replacing the existing manual operation methods with electronic methods, thereby improving data processing efficiency and data transmission security, avoiding the problems of human intervention or human influence in manual operations, and further achieving improved supplier trust and reduced enterprise costs.

[0047] like Figure 1 As shown, Figure 1 It is a schematic diagram of the terminal structure of the hardware operating environment involved in the embodiment of the present invention.

[0048] The electronic bidding apparatus in the embodiment of the present invention may be a PC, or a mobile terminal device such as a smart phone, a tablet computer, or a portable computer.

[0049] like Figure 1 As shown, the electronic bidding device may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002. Among them, the communication bus 1002 is used to realize the connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the user interface 1003 may also include a standard wired interface and a wireless interface. The network interface 1004 may optionally include a standard wired interface and a wireless interface (such as a WI-FI interface). The memory 1005 may be a high-speed RAM memory, or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also be a storage device independent of the aforementioned processor 1001.

[0050] Optionally, the electronic bidding device may also include a camera, RF (Radio Frequency) circuit, sensor, audio circuit, WiFi module, etc. Among them, sensors include light sensors, motion sensors and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor can adjust the brightness of the display screen according to the brightness of the ambient light, and the proximity sensor can turn off the display screen and / or backlight when the mobile terminal is moved to the ear. As a type of motion sensor, the gravity acceleration sensor can detect the magnitude of acceleration in all directions (generally three axes), and can detect the magnitude and direction of gravity when stationary. It can be used for applications that identify the posture of the mobile terminal (such as horizontal and vertical screen switching, related games, magnetometer posture calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal can also be equipped with other sensors such as gyroscopes, barometers, hygrometers, thermometers, infrared sensors, etc., which will not be repeated here.

[0051] Those skilled in the art will understand that Figure 1 The structure of the electronic bidding device shown in the figure does not constitute a limitation of the electronic bidding device, and may include more or fewer components than shown in the figure, or combine certain components, or arrange the components differently.

[0052] like Figure 1 As shown, the memory 1005 as a computer storage medium may include an operating system, a network communication module, a user interface module and an electronic bidding program.

[0053] exist Figure 1 In the terminal shown, the network interface 1004 is mainly used to connect to the backend server and communicate data with the backend server; the user interface 1003 is mainly used to connect to the client (user end) and communicate data with the client; and the processor 1001 can be used to call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0054] When the data application system receives an input data report, it analyzes and processes the data report based on preset decomposition requirements to obtain a first tolerance table;

[0055] Sending the first tolerance table to an electronic quotation system so that the electronic quotation system can run the electronic bidding logic according to the first tolerance table and generate a final price analysis report;

[0056] The final price analysis report returned by the electronic quotation system is received so as to carry out procurement bidding according to the final price analysis report.

[0057] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0058] The step of the data application system receiving an input data report and analyzing and processing the data report based on a preset decomposition requirement to obtain a first tolerance table includes: after receiving the input data report, grouping the data report based on the preset decomposition requirement to obtain a plurality of data decomposition sub-tables;

[0059] Supplier basic data is obtained, and the supplier basic data and a plurality of data decomposition sub-tables are integrated to form a first tolerance table.

[0060] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0061] The step of sending the first tolerance table to the electronic quotation system so that the electronic quotation system executes the electronic bidding logic according to the first tolerance table to form a final price analysis report includes: after sending the first tolerance table to the electronic quotation system, generating a corresponding tender invitation letter template and a first quotation import table through the electronic quotation system;

[0062] triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template and generates a price inquiry information registration form based on the first quotation import form;

[0063] Based on the electronic quotation system, generating a benchmark price analysis table according to the inquiry information registration table, and receiving the target price released by the collaborative platform based on the benchmark price analysis table, so as to trigger the bid opening operation according to the target price;

[0064] A final price analysis report is generated based on the bid opening operation of the electronic quotation system.

[0065] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0066] Before the step of triggering Outlook based on the local tool so that the electronic quotation system triggers the inquiry operation according to the tender invitation letter template, the electronic quotation system extracts the supplier basic data in the first tolerance table to form a second tolerance table, and generates a corresponding tender invitation letter based on the supplier basic data.

[0067] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0068] The step of triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template and generates a price inquiry information registration form based on the first quotation import form includes: triggering Outlook based on a local tool to send the tender invitation letter and the second tolerance table to a corresponding Outlook destination through the price inquiry operation of the electronic quotation system;

[0069] The electronic quotation system receives the quotation inquiry information returned by the Outlook destination and imports it into the first quotation import table to form a quotation inquiry information registration table.

[0070] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0071] The step of triggering a bid opening operation according to the target price includes: generating a bid opening invitation letter, a second bid import table, and a third tolerance table based on the electronic bidding system detecting the target price;

[0072] triggering Outlook based on a local tool, and sending the bid opening invitation letter and the third tolerance table to a corresponding Outlook destination through the bid opening operation of the electronic quotation system;

[0073] The electronic quotation system receives the bid opening information returned by the Outlook destination and imports it into the second quotation import table to form a bid opening information registration table.

[0074] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0075] After the step of importing the second quotation import table to form a bid opening information registration table, detecting whether the bid opening information registration table triggers a preset release condition;

[0076] If the bid opening information registration form triggers the preset release condition, the bid opening information registration form and the supplier basic data are matched by the KEY value to obtain the bid quotation form of the participating suppliers;

[0077] Receive the final price analysis report returned by the bidding supplier after the quotation form is released.

[0078] Furthermore, the processor 1001 may call the electronic bidding program stored in the memory 1005 and perform the following operations:

[0079] After the step of detecting whether the bid opening information registration form triggers a preset release condition, the method further includes: if the bid opening information registration form does not trigger the preset release condition, no release operation is performed.

[0080] Reference Figure 2 、 Figure 6 and Figure 7 An embodiment of the present invention provides an electronic bidding method, the electronic bidding method comprising:

[0081] Step S10: When the data application system receives the input data report, it analyzes and processes the data report based on the preset decomposition requirements to obtain a first tolerance table;

[0082] The operation end is a data application system, which in this embodiment is used to analyze, process and integrate the data reports uploaded by the operator. The specific operations are as follows:

[0083] The operator imports various parts data, price and other data reports into the data application system on the business platform side. After receiving various data reports uploaded by the business platform, the data application system decomposes, processes and integrates the data reports according to the preset decomposition requirements.

[0084] The preset decomposition requirements refer to, for example, Figure 7 As shown, after receiving data reports imported from business platforms such as ECM, SAP, and SOR, price catalog levels are set for different procurement business needs through category management analysis to meet personalized needs such as price decomposition relationships and quotation relationships of different parts. SOR data reports, parts data reports, allocated tooling data reports, and buyer basic data reports are decomposed to obtain the first tolerance table quickly and accurately through the macro code operation of the data application system, avoiding the following problems: Figure 6 As shown, the data processing in the existing demand analysis link is based on manual analysis, calculation and processing. This data processing method is very prone to errors and data leakage, thereby reducing the efficiency of data processing and data security.

[0085] In this embodiment, the first tolerance table adopts the 1804 tolerance table.

[0086] Optionally, in step S10, the data application system receives an input data report, and the step of analyzing and processing the data report based on a preset decomposition requirement to obtain a first tolerance table includes:

[0087] Step S11, after receiving the input data report, grouping the data report based on the preset decomposition requirements to obtain a number of data decomposition sub-tables;

[0088] Step S12: Obtain supplier basic data, and integrate the supplier basic data and several data decomposition sub-tables to form a first tolerance table.

[0089] After receiving the data report transmitted by the operator through the business platform, the data application system decomposes the data report into several data decomposition sub-tables such as parts data report, SOR data report, allocated tooling data report, and buyer basic data report according to the preset decomposition requirements in the report system. At the same time, the data application system will automatically obtain the list of shortlisted suppliers and the annual shortlisted large-order suppliers to form a supplier basic data report.

[0090] After obtaining several data decomposition sub-tables and supplier basic data reports, the two are integrated to form a first tolerance table.

[0091] The existing first tolerance table is entirely obtained manually. For example, price analysis is manually generated by buyers, and various data analyses rely entirely on manual accumulation. However, the price analysis data acquisition logic is complex, difficult to verify and test, and prone to data errors and low efficiency. This greatly limits the accuracy and generation efficiency of the data, which in turn leads to errors in the subsequent purchase prices, making it difficult to form a better purchase price.

[0092] Step S20: sending the first tolerance table to an electronic quotation system so that the electronic quotation system can run the electronic bidding logic according to the first tolerance table to generate a final price analysis report;

[0093] Step S30: receiving the final price analysis report returned by the electronic quotation system so as to conduct procurement bidding based on the final price analysis report.

[0094] like Figure 7 As shown, after the data application system forms the first tolerance table, it needs to send the first tolerance table to the electronic quotation system side to trigger the subsequent related electronic bidding logic, so that after the electronic quotation system runs the electronic bidding logic, a final price analysis report is formed. The final price analysis report includes: supplier quotation, target price, tooling allocation, automatic calculation of cost reduction data, etc., which is convenient for JPC to carry out procurement and fixed-point purchase according to the final price analysis report and accurately make the best procurement and fixed-point purchase decision.

[0095] Among them, the electronic bidding logic includes the macro code operation logic of quotation inquiry, price analysis and final bidding process.

[0096] In this embodiment, the data application system is used to analyze, process and integrate the data reports uploaded by the operator, thereby avoiding data processing errors and data leakage in existing manual operations, which lead to errors in the subsequent procurement prices and greatly limit the accuracy and generation efficiency of the data. The final procurement bidding is carried out through the data application system, which facilitates the JPC to determine the procurement points based on the final price analysis report. It can not only accurately make the optimal procurement point decision, but also ensure that the procurement bidding process is safe and leak-free. The fully digital and highly integrated electronic bidding method can fundamentally eliminate adverse situations such as bid rigging and collusion caused by human intervention or human influence, and ensure a completely open, fair and transparent bidding process.

[0097] Further, refer to Figure 3 、 Figure 6 and Figure 7 An embodiment of the present invention provides an electronic bidding method. Based on the embodiment shown in step S20 above, the step of sending the first tolerance table to the electronic quotation system so that the electronic quotation system performs electronic bidding logic according to the first tolerance table and generates a final price analysis report includes:

[0098] Step S40: After sending the first tolerance table to the electronic quotation system, the electronic quotation system generates a corresponding tender invitation letter template and a first quotation import table;

[0099] The operating end is the electronic bidding system, which is used to run the electronic bidding logic.

[0100] When the electronic bidding system receives the first tolerance table sent by the data application system, it will generate a corresponding bidding invitation letter template based on the supplier basic data in the first tolerance table, which is used to automatically generate the corresponding supplier bidding invitation. At the same time, it will also generate a first quotation import table based on the data decomposition sub-table, which is used to automatically import the inquiry information returned by the supplier based on the bidding invitation, avoiding the following problems: Figure 6 As shown, existing tender invitation letters and supplier quotations are filled out and generated based on manual operations, which are prone to errors in data information filling due to excessive data, which in turn leads to errors in the generated data quotations, causing unpredictable losses to suppliers and enterprises.

[0101] Step S50: triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template and generates a price inquiry information registration form based on the first quotation import form;

[0102] After the electronic quotation system detects that the tender invitation template and the first quotation import table have been generated, it triggers Outlook according to the local tool, and then triggers the inquiry operation (i.e. Figure 7The macro code operation logic of the inquiry and quotation in the function is used to automatically send the corresponding bidding invitation letter and price list to the corresponding supplier mailbox through the Outlook mailbox, and supplement the first quotation import table according to the inquiry information returned by the supplier mailbox to form the first quotation import table with the supplier's non-final round quotation and demand information, that is, the inquiry information registration table. This is also to avoid information errors and omissions caused by manual issuance and collection of bidding invitations and supplier quotations.

[0103] Optionally, before the step of triggering Outlook based on a local tool in step S50 so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template, the step further includes:

[0104] Step S51: extracting the supplier basic data in the first tolerance table through the electronic quotation system to form a second tolerance table, and generating a corresponding bidding invitation letter based on the supplier basic data.

[0105] Before triggering Outlook to issue a tender invitation using local tools, the tender invitation template needs to be supplemented with specific information, such as the supplier's name. Therefore, the supplier basic data in the first tolerance table needs to be extracted and used to supplement the supplier invitation template. At the same time, the electronic quotation system also issues tender invitations based on the supplier's Outlook email address recorded in the supplier basic data. The second tolerance table is a price breakdown table that excludes the supplier basic data and is used to provide a reference for price ranges when suppliers make quotations.

[0106] Step S60: generating a benchmark price analysis table based on the electronic quotation system and the inquiry information registration table, and receiving a target price released by the collaborative platform based on the benchmark price analysis table, so as to trigger a bid opening operation according to the target price;

[0107] After receiving the inquiry information returned by the supplier and generating the corresponding inquiry information registration form, the electronic quotation system will automatically generate a complete benchmark price analysis table horizontally based on the demand information, quotation information and other data in the inquiry information registration form through the data acquisition logic in the macro code. At the same time, the electronic quotation system automatically captures the target price released by the finance department on the collaborative platform, and triggers the macro code execution of the bid opening operation through the approval of the stretched target price by the procurement director. Among them, the electronic quotation system will retain the operation traces corresponding to the release of the target price and the approval of the stretched target price by the procurement director to prevent the opacity of the operation process without leaving any trace, which will lead to insufficient trust of suppliers in the company.

[0108] Step S70: generating a final price analysis report based on the bid opening operation of the electronic quotation system.

[0109] Through the opening operation in the electronic quotation system (i.e. Figure 7 The final price analysis report is sent to the data application system to provide accurate data basis for JPC procurement decision-making, avoiding the following problems: Figure 6 As shown, the final price analysis report generated by manual calculation and operation contains errors, which leads to incorrect JPC decision-making and the failure to obtain lower parts prices and better production inclination. This not only increases the company's costs, but also reduces the suppliers' trust in the company.

[0110] In this embodiment, the inquiry and quotation process is run through the electronic quotation system, which avoids the situation that the existing tender invitation letters and supplier quotations are filled out and generated based on manual operations, which is prone to data information filling errors due to excessive data. The target price is obtained through the electronic quotation system, and the release and review process of the target price are recorded to prevent the opaque operation process without leaving any traces, which leads to insufficient trust in the enterprise by suppliers. The bid opening process is run through the electronic quotation system, which avoids the errors in the existing final price analysis report generated by manual calculation and operation, which leads to errors in JPC decisions, which not only increases the cost of the enterprise, but also reduces the trust of suppliers in the enterprise.

[0111] Further, refer to Figure 4 An embodiment of the present invention provides an electronic bidding method. Based on the embodiment shown in step S50 above, the steps of triggering Outlook using a local tool so that the electronic quotation system triggers a price inquiry operation based on the tender invitation letter template and generating a price inquiry information registration form based on the first quotation import form include:

[0112] Step S52: triggering Outlook based on the local tool, sending the tender invitation letter and the second tolerance table to the corresponding Outlook destination through the inquiry operation of the electronic quotation system;

[0113] Step S53: The electronic quotation system receives the quotation information returned by the Outlook destination and imports it into the first quotation import table to form a quotation information registration table.

[0114] After detecting the generation of the tender invitation letter template and the first quotation import table, Outlook is triggered through local tools, and based on the inquiry operation (i.e. the macro code operation logic of the quotation inquiry), the tender invitation letter and price details table (i.e. the second tolerance table) containing the supplier's specific information are sent to the corresponding Outlook mailbox destination in the supplier's basic data.

[0115] After receiving the tender invitation letter and price list, suppliers can exchange inquiry information through Outlook mailbox without going through the company's internal system, avoiding the data errors and omissions caused by the existing manual distribution and receipt operations through ordinary mail and fax.

[0116] At the same time, in the process of triggering Outlook for data interaction through local tools, whether the enterprise sends a bidding invitation letter and a price list to the supplier, or the supplier returns the inquiry information to the enterprise, the information sent through the Outlook mailbox has a corresponding key. Only when the key matches can the data be interacted normally. Otherwise, it will be judged as an error message and the sending or receiving process of the information will be stopped to avoid improper bidding caused by the sending or receiving of error information.

[0117] In this embodiment, the inquiry operation is implemented by triggering Outlook through local tools, which can avoid data errors and omissions caused by the existing manual issuance and receipt of ordinary mail and fax, and can also avoid improper bidding caused by the sending or receiving of erroneous information.

[0118] Further, refer to Figure 5 An embodiment of the present invention provides an electronic bidding method. Based on the embodiment shown in step S60 above, the step of triggering the bid opening operation according to the target price includes:

[0119] Step S61, after the electronic quotation system detects the target price, generating a bid opening invitation letter, a second quotation import table and a third tolerance table;

[0120] After the collaborative platform releases the target price and the procurement director approves the stretched target price, the final tender invitation letter (i.e., the bid opening invitation letter), the second quotation import table (used to import the bid opening information returned by the supplier) and the third tolerance table (i.e., the price details table containing the stretched target price) are generated based on the approved stretched target price. This is also to avoid the high error rate and low efficiency of the existing manual issuance of tender invitations and price details.

[0121] Step S62: triggering Outlook based on the local tool, and sending the bid opening invitation letter and the third tolerance table to the corresponding Outlook destination through the bid opening operation of the electronic quotation system;

[0122] Step S63: The electronic quotation system receives the bid opening information returned by the Outlook destination and imports it into the second quotation import table to form a bid opening information registration table.

[0123] After detecting the generation of the bid opening invitation letter, the second quotation import table and the third tolerance table, Outlook is triggered through local tools, and the macro code based on the bid opening operation runs to send the final tender invitation letter containing the supplier's specific information (i.e., the bid opening invitation letter) and the price details table containing the stretched target price (i.e., the third tolerance table) to the corresponding Outlook mailbox destination in the supplier's basic data.

[0124] After receiving the final tender invitation letter and the price list containing the stretched target price, the supplier can still securely transmit the bid opening information without logging into the company's internal system. The transmission process and encryption method are the same as those for the inquiry operation.

[0125] Optionally, after the step of importing the second quotation import table to form a bid opening information registration table in step S63, the method further includes:

[0126] Step S64, detecting whether the bid opening information registration form triggers a preset release condition;

[0127] After the bid opening information registration form is generated, the electronic quotation system will monitor in real time whether the bid opening information registration form triggers the preset release conditions. The preset release conditions refer to the arrival of the bid closing time and the receipt of bid opening information from all suppliers. When the above two conditions are all met, the electronic quotation system determines that the preset release conditions of the bid opening information registration form are triggered.

[0128] Step S65: If the bid opening information registration form triggers the preset release condition, the bid opening information registration form is matched with the supplier basic data through the KEY value to obtain a bid quotation form of participating suppliers;

[0129] When the preset release condition is triggered, the electronic quotation system starts to apply for the start of the bid opening procedure. The electronic quotation system matches the bid opening information registration form with the supplier basic data through the KEY, that is, the bid opening information returned by each supplier in the bid opening information registration form is statistically analyzed with the supplier basic data to form a bidding supplier quotation table. The generation of the bidding supplier quotation table is different from the generation of the existing bidding supplier quotation table. In this embodiment, the calculation and generation of the bidding supplier quotation table rely entirely on macro code operation, eliminating all human intervention and human influence, and promoting the construction of a bidding method with an honest and clean system.

[0130] Step S66: receiving the final price analysis report returned by the released bidding supplier quotation form.

[0131] Once a supplier's quotation is released and approved by the purchasing director and purchasing manager, it will be sent to the purchasing department. The purchasing department will use the supplier's quotation to conduct component cost analysis, providing a key analytical data source for building various types of cost models, thereby forming a final price analysis report. JPC can make accurate procurement and bidding decisions based on the final price analysis report, thereby improving the accuracy of data analysis.

[0132] It should be noted that after the preset release conditions are triggered, the post-release operation process and bid opening data of the bid opening information registration form will be fully recorded, so that when adverse situations arise later, they can be checked and inspected according to the operation process and bid opening data.

[0133] Optionally, after the step of detecting whether the bid opening information registration form triggers a preset release condition in step S64, the method further includes:

[0134] Step S67: If the bid opening information registration table does not trigger the preset release condition, no release operation is performed.

[0135] When the preset release condition is not triggered, it means that the bid deadline has not arrived or the supplier's bid opening information is incomplete. If the bid opening information registration form is released at this time, there is a risk of leakage of the bid opening information registration form or incomplete bid opening information, which may lead to errors in data statistical analysis. In order to avoid this adverse situation, the electronic quotation system will not start any bid opening procedures at this time. If the operation of releasing the bid opening information registration form is detected at this time, the operation will be recorded and an alarm will be triggered to remind corporate users that there is a risk of bidding information leakage at this time.

[0136] In this embodiment, the bid opening operation is implemented by triggering Outlook through local tools, which is also to avoid the high error rate and low efficiency problems of the existing manual issuance of bidding invitations and price details. At the same time, after the bid opening information registration form is formed, the electronic quotation system detects in real time whether the preset release conditions are triggered, avoiding information leakage caused by improper operation in the existing manual release, thereby making the bidding process incomplete.

[0137] In addition, an embodiment of the present invention also proposes an electronic bidding device, which includes a memory, a processor, and a computer program stored in the memory and runnable on the processor. When the processor executes the computer program, the steps of the above-mentioned electronic bidding method are implemented.

[0138] In addition, the present invention also proposes a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the above-mentioned electronic bidding method are implemented.

[0139] It should be noted that, in this document, the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or system comprising a series of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or system. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of other identical elements in the process, method, article, or system comprising the element.

[0140] The serial numbers of the above embodiments of the present invention are for description only and do not represent the advantages or disadvantages of the embodiments.

[0141] Through the description of the above embodiments, those skilled in the art can clearly understand that the above embodiment methods can be implemented by means of software plus the necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is a better embodiment. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) as described above, and includes a number of instructions for enabling a terminal device (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in each embodiment of the present invention.

[0142] The above are only preferred embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention description and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. An electronic bidding method, characterized in that: The electronic bidding method is applied to a data application system and comprises the following steps: When the data application system receives an input data report, it analyzes and processes the data report based on preset decomposition requirements to obtain a first tolerance table. The preset decomposition requirements refer to setting price catalog levels for different procurement business needs through category management analysis after receiving the data report imported from the business platform to meet the personalized needs of price decomposition relationships and quotation relationships for different parts. The first tolerance table is an 1804 tolerance table generated by running the macro code of the data application system based on the data report imported from the business platform, the parts data report, the allocated tooling data report, and the buyer's basic data report; Sending the first tolerance table to an electronic quotation system so that the electronic quotation system can run the electronic bidding logic according to the first tolerance table and generate a final price analysis report; The final price analysis report returned by the electronic quotation system is received so as to carry out procurement bidding according to the final price analysis report.

2. The electronic bidding method according to claim 1, wherein: The step of receiving an input data report by the data application system and analyzing and processing the data report based on preset decomposition requirements to obtain a first tolerance table includes: After receiving the input data report, the data report is grouped based on the preset decomposition requirements to obtain several data decomposition sub-tables, wherein the data decomposition sub-tables are the parts data report, the data report imported from the business platform, the allocated tooling data report, and the buyer's basic data report obtained by the data application system decomposing the data report according to the preset decomposition requirements in the report system; Obtaining supplier basic data, and integrating the supplier basic data with a plurality of data decomposition sub-tables to form a first tolerance table; The step of grouping the data report based on the preset decomposition requirements to obtain a plurality of data decomposition sub-tables includes: Decomposing the data report into the parts data report, the data report imported from the business platform, the apportioned tooling data report, and the buyer's basic data report according to preset decomposition requirements in the report system; The step of obtaining supplier basic data and integrating the supplier basic data with a plurality of data decomposition sub-tables to form a first tolerance table includes: Obtain the list of shortlisted suppliers and annual shortlisted large-order suppliers to form basic supplier data; After obtaining the parts data report, the data report imported from the business platform, the apportioned tooling data report, the buyer's basic data report and the supplier's basic data report, the two are integrated to form the first tolerance table.

3. The electronic bidding method according to claim 1, wherein: The step of sending the first tolerance table to the electronic quotation system so that the electronic quotation system performs electronic bidding logic according to the first tolerance table to form a final price analysis report includes: After sending the first tolerance table to the electronic quotation system, the electronic quotation system generates a corresponding tender invitation letter template and a first quotation import table; triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template and generates a price inquiry information registration form based on the first quotation import form; Based on the electronic quotation system, generating a benchmark price analysis table according to the inquiry information registration table, and receiving the target price released by the collaborative platform based on the benchmark price analysis table, so as to trigger the bid opening operation according to the target price; A final price analysis report is generated based on the bid opening operation of the electronic quotation system.

4. The electronic bidding method according to claim 3, wherein: Before the step of triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template, the step further includes: Extracting the supplier basic data in the first tolerance table through an electronic quotation system to form a second tolerance table, and generating a corresponding tender invitation letter based on the supplier basic data, wherein the second tolerance table is a price breakdown table excluding the supplier basic data; The steps of extracting the supplier basic data in the first tolerance table through the electronic quotation system to form a second tolerance table, and generating a corresponding tender invitation letter based on the supplier basic data include: The supplier basic data in the first tolerance table is eliminated, and the first tolerance table from which the supplier basic data is eliminated is used to form the second tolerance table. The supplier basic data in the first tolerance table is extracted, and the supplier invitation letter template is supplemented with the extracted supplier basic data to generate the tender invitation letter.

5. The electronic bidding method according to claim 4, wherein: The step of triggering Outlook based on a local tool so that the electronic quotation system triggers a price inquiry operation according to the tender invitation letter template and generates a price inquiry information registration form based on the first quotation import form includes: Triggering Outlook based on a local tool, sending the tender invitation letter and the second tolerance table to a corresponding Outlook destination through the inquiry operation of the electronic quotation system; The electronic quotation system receives the quotation inquiry information returned by the Outlook destination and imports it into the first quotation import table to form a quotation inquiry information registration table.

6. The electronic bidding method according to claim 5, wherein: The step of triggering the bid opening operation according to the target price includes: After the target price is detected by the electronic quotation system, a bid opening invitation letter, a second quotation import table and a third tolerance table are generated, wherein the third tolerance table is a price detail table containing a stretched target price; triggering Outlook based on a local tool, and sending the bid opening invitation letter and the third tolerance table to a corresponding Outlook destination through the bid opening operation of the electronic quotation system; receiving the bid opening information returned by the Outlook destination based on the electronic quotation system, and importing the information into the second quotation import table to form a bid opening information registration table; The step of generating a bid opening invitation letter, a second bid import table, and a third tolerance table after the target price is detected by the electronic quotation system includes: After the collaborative platform releases the target price and the procurement director approves the stretched target price, the bid opening invitation letter, the second quotation import table and the third tolerance table are generated based on the approved stretched target price, wherein the bid opening invitation letter is the final tender invitation letter, and the second quotation import table is used to import the bid opening information returned by the supplier.

7. The electronic bidding method according to claim 6, characterized in that: After the step of importing the second quotation import table to form a bid opening information registration table, the method further includes: Detecting whether the bid opening information registration form triggers a preset release condition; If the bid opening information registration form triggers the preset release condition, the bid opening information registration form and the supplier basic data are matched by the KEY value to obtain the bid quotation form of the participating suppliers; Receive the final price analysis report returned by the bidding supplier after the quotation form is released.

8. The electronic bidding method according to claim 7, wherein: After the step of detecting whether the bid opening information registration form triggers a preset release condition, the method further includes: If the bid opening information registration form does not trigger the preset release condition, no release operation is performed.

9. An electronic bidding device, characterized in that: The electronic bidding device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the electronic bidding method according to any one of claims 1 to 8 are implemented.

10. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the electronic bidding method according to any one of claims 1 to 8.

Images