TW528972B - Real-time e-commerce order reply system and method - Google Patents

Abstract

A real-time e-commerce order reply system and method is provided, which can reply the electronic order sent by the customer in real-time. The e-commerce order reply system according to the present invention comprises: an EDI platform, a SAP platform, a SQL server, and a WWW server. The EDI platform is used to receive the electronic order. The SAP platform executes the predetermined FCT computing procedure based on the electronic order data received by the EDI platform so as to obtain the associated FCT data. The SQL server executes the predetermined STFC computing procedure based on the electronic order data received by the EDT platform, and thus obtaining the associated STFC data. The WWW server is used to announce the FCT/STFC data obtained from the SAP platform and the SQL server, and thus the customer can browse the FCT/STFC data announced on the WWW server through the Internet.

Description

528972 A7 B7 Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs V. Invention Description (1) [Field of Invention] The present invention relates to an e-commerce information technology, and in particular, to an instant e-commerce order response system and method. It can respond to the electronic orders placed by customers in a timely manner, and the relevant production completion rate data, including Factory Cycle Time (FCT) and Ship To First Commitment (STFC), Internet sites reply to customers. [Background of the Invention] In the contract electronics manufacturing (CEM) industry, when a manufacturer receives an order from a customer, the manufacturer must first calculate the relevant production completion rate data, including the FCT of the production process and the original agreement Shipment time STFC; and then return this FCT / STFC information to the customer. FCT data is used to display the number of orders received from the manufacturer to the date of shipment; STFC data is used to display the date of shipment provided by the manufacturer. The manufacturer calculates the required FCT / STFC data according to some parameters; these parameters include the order quantity, cargo type, manufacturing capacity, and so on. The following shows a commonly used FCT / STFC calculation formula; FCT-(EDT856 Time)-(EDT850 Time) -Average = Sum [(EDI856-EDI850)] * (Qty 〇f EDI 856)] / Sum (Qty of EDI856) -Max = Max [(EDI856-EDI850)] -Min = Min [(EDI856-EDI850)] STFC = (EDT856 Time) (EDT855 Time) (Please read the precautions on the back before filling in the blocks on this page)

I • -Order_ V: The paper size of the paper is applicable to the Chinese National Standard (CNS) A4 (210 X 297 mm) 1 16395 528972 Printed by the Consumer Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs A7 B7 V. Description of the invention (2)- Average = Sum [(EDI856-EDI855)] * (Qty of EDI 856)] / Sum (Qty of EDI856) -Max = Max [(EDI856-EDI855)] -Min = Min [(EDI856-EDI855)] because different Manufacturers have different fct / stfc calculation formulas, and their related background knowledge is well known in the industry, so they will not be described in further detail below. Figure 1 is a schematic diagram of a system architecture, showing the basic system architecture of a conventional e-commerce order response system (such as the part designated by 100); and the flowchart in Figure 2 shows the electronics shown in Figure i Procedural steps performed by the business order response system 100. As shown in Figure 1, this conventional e-commerce order response system 100

It includes at least: (a) — EDI platform 11 〇, (b) — SAP platform 120, (c) a CEM specialist 130 (Note · This CEM specialist is a staff member, not a system platform), and (d) -Customer Service Station 14〇. EDI platform 11〇 is based on electronic data exchange (Electrnie Data

Exchange, EDI) The work platform constructed by the standard specifications is externally connected to a network system, such as the Internet 20, and is used to allow a client workstation 10 to connect to it through the Internet 20 The e-commerce order response system 100 receives an electronic order from the client through the client workstation 10, such as an EDI 850 electronic order. Since the Em specification is a well-known standard in the information industry, it will not be described in further detail below. (Please read the precautions on the back before filling in the blocks on this page) Order. -Γ 线

16395 528972 A7 V. Description of the invention (

Advertising Protoco 丨, SAp) is a work platform constructed by the standard specifications, which is connected to the EDI platform 110, and is used to perform-predetermined FCT calculation procedures based on the electricity order data it receives-to obtain-related FCT data. Since the SAp specification is also a well-known standard specification in the information industry, it will not be described in further detail below. The CEM specialist 130 is a staff member whose expertise is in stfc calculations. He is responsible for obtaining manual-based calculations, such as manual calculations or using a computer, based on the electronic order data he receives—group-related information. The customer service workstation 140 is a computer, such as a desktop personal computer, which is externally connected to the Internet 20 and has an e-mail function installed. The customer service staff can use this customer service workstation 14 to send the necessary materials to the customer via e-mail 20 to the customer. Printed by the Consumer Cooperative of the Intellectual Property Bureau of the Ministry of Economic Affairs_ Please refer to Figure 2 and Figure 1 at the same time. When the customer wants to place an order with the manufacturer, the first step is S10. 〇 An electronic order, such as EDI 850, is transmitted to the manufacturer's e-commerce order response system 100 via the Internet 20. Then the following steps 311 to §14 are performed by the e-commerce single response system 100. Online In step S11, the e-commerce order response system 100 uses the EDI platform 110 to receive electronic orders issued by customers, and then forwards the received electronic orders to the Sap platform 120 and the CEM specialist 130. Then step S12 is performed, in which the SAP platform 120 executes a predetermined FCT calculation program based on the received electronic order data, thereby obtaining a set of related FCT data. Then proceed to step S13, where the CEM commissioner 130 is responsible for the acceptance of the paper size according to the paper size «Standard (CNS) A4 Specifications ⑽ x 297 princes) 3 16395 V. The electronic order data obtained in the description of the invention (4) is calculated by people The program is, for example, Teng Zengtian to execute STFC data of a predetermined STFC meter. Say something and ask for a group of correlations, then proceed to step Sl4, where you get silk six?丨 — Y system will obtain the FCT / STFC data

It's from the parent to each service station, and let FCT / STPP let the customer service staff there. E-mails are sent to customers via the Internet 20. However, one of the shortcomings of the above-mentioned early response system for e-commerce orders is that each household must wait for a long time after issuing electronic orders. Received an email from the e-commerce order response system 100. This is because the above steps S13 and S14 require manpower to perform the work and e-mail sending work, so it will make the whole process take a considerable amount of time, so that the time to respond to customers is slower. Therefore, the electronic contract manufacturing business community needs an instant electronic business order response system and method, so that customers can receive the required FCT / STFC information in a timely manner to make the business transactions between the two parties more efficient. [Summary of the Invention] In view of the shortcomings of the conventional technology described above, the main purpose of the present invention is to provide a new e-commerce order response system and method, which can promptly respond to electronic orders issued by customers. Another object of the present invention is to provide a new e-commerce order response system and method, which can eliminate the need for human resources to perform STFC " ten different jobs and e-mail sending tasks, thereby saving human resources. The e-commerce order response system of the present invention includes at least the following system 528972 A7 B7 printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs 5. Description of the Invention (5) Components · An EDI platform, an SAP platform, a SQL server, and an Web server. The EDI platform is used to receive the electronic order; the SAP platform can execute a predetermined FCT calculation procedure based on the electronic order data received by the EDI platform, thereby obtaining a set of related FCT data; the SQL server can be based on The electronic order data received by the EDI platform is used to execute a predetermined STFC calculation process, thereby obtaining a set of related STFC data; and the web server allows the SAP platform and the SQL server to request them The obtained FCT / STFC information is published on the web server, so that customers can browse the FCT / STFC data published on the web server through the Internet. When a customer sends an electronic order to the above-mentioned e-commerce order response system, it first uses the EDI platform to receive the electronic order; then the electronic order data received by the EDI platform executes a predetermined order through the SAP platform. FCT calculation program to obtain a set of related FCT data; meanwhile, the electronic order data received by the EDI platform is executed through a SQL server to execute a predetermined STFC calculation program to obtain a set Related STFC information. Finally, the FCT / STFC data obtained from the SAP platform and the SQL server are published on a web server, so that customers can browse the FCT / STFC data published on the web server through the Internet. . [Brief Description of the Drawings] The essential technical content of the present invention and its embodiments have been disclosed in detail in the drawings in the drawings attached to this specification. The contents of these drawings are briefly described as follows: (Please read the precautions on the back before filling in the blocks on this page)-Order · • The paper size of the thread is applicable to the Chinese National Standard (CNS) A4 (210 X 297 mm) 5 16395 528972

5. Description of the invention (6) Figure 1 (known technology) is a schematic diagram of a system architecture, which shows a basic system architecture of a known e-commerce order response system; 6 / '* Figure 2 (known technology) is a The flowchart shows the procedure steps performed by the Baozi business order response system as shown in FIG. 3; FIG. 3 is a schematic diagram of a system architecture showing the basic system architecture of the e-commerce order response system of the present invention; and FIG. 4 is a A flowchart showing the process steps performed by the e-commerce order response system shown in Figure 3. [Illustration of Symbols] 10 20 100 Wisdom of the Ministry of Economic Affairs. Bureau employee consumer cooperative prints client workstations Internet. Known e-commerce order response system EDI platform SAP platform CEM commissioner customer service workstation Electronic of the invention Business order response system EDI platform SAP platform SQL server Web server is (WWW server) [Inventive embodiment] The following is a detailed disclosure of the e-commerce order response explaining the present invention in conjunction with Figures 3 and 4 in the attached drawings Examples of systems and methods 110 120 130 140 200 210 220 230 240 16395 (Please read the notes on the back before filling in the blocks on this page). -Order. • ΓΓΓ 528972 A7 B7 Printed by the Employees' Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs System description of the invention (7. FIG. 3 shows the basic system architecture of the e-commerce order response system of the present invention; and the flow chart of FIG. 4 shows the process steps performed by the e-commerce order response system of the present invention. Please first Referring to FIG. 3, the e-commerce order response system (as indicated by the number 200) of the present invention includes at least the following systems: Components: a work platform 210, an SAP platform 220, a SQL server 23, and a web server 240 (WWW Server) 240. The EDI platform 210 is based on the Electronic Data Exchange (EDI) i standard specification The constructed work platform is externally connected to a network system, such as the Internet 20, and is used to allow a client workstation 10 to connect to the e-commerce order response system 200 through the Internet 20. And receive customer's electronic order from client workstation 10, such as EDI 850 electronic order. SAP platform 220 is a work platform constructed based on the standard specification of the service advertising login agreement Advertising Protocol (SAP), which is connected Go to the EDI platform 210, and use it to execute the FCT calculation data of the status according to the electronic order data it receives, so as to obtain a set of related FCT data. The SQL server 230 is a database server constructed based on the standard specifications of a structured query language (Stmctiired Query Language, SQL), such as Microsoft SQL Server, which is also connected to the EDI platform 210 for The electronic order data to be executed, and the STFC 5 ten different procedures in advance are used to obtain a set of related stfc data. As the SQL specification is a standard specification well known in the information industry, (Please read the precautions on the back before filling in the blocks on this page)-Order_ This paper size applies to China National Standard (CNS) A4 (210x297 mm) 7 16395 V. Description of the invention (8)

Microsoft SQL Server is also a database server thief software program used by the Ziyetang κ Private Fei Cry "Dou-π Bay efl industry, so it will not be further described below-a detailed description. Web Feeder 240 External Department Connected to the Internet 20, and internally connected to the SAP platform 220 and the post server 230, which allows SAP to get the fct / stfc data obtained by SAP :: 〇 and SQL server 230 = this: Γ server " Ο 上 'so that customers can use the Internet- ^ formula', for example, e :: ape Navigat〇r of —_Εχρ1〇Γ6Γ 刘, to browse the web server Figure 3 and Figure 3, when the customer wants to place an order: = the first step will be performed, that is, the client will use the electronic order, such as a leg, to transmit to the manufacturer's electronics through the Internet: 20 Business order response system details = Sub-business order response system fan performs the following steps: ⑶ Ping 21 ^ 2 Μ1 towel e-commerce order response system 2GG uses EDI: electronic order issued by the customer to receive, and then the ΓΓΓ order at the same time Transfer to sap platform cafe and order feeding service to receive == 2 S22 'which system The SAP platform 220 executes the-pre-defined FCT calculation program based on all the data and early-morning data-and obtains the FCT data related to the version. &Quot; Received === 来: " 'One serving ... 摅 疋 早 贝 枓 来The STFC calculation program for the first lamp is applicable to this paper standard-16395 8 Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs 528972 A7 -------------_____ 5. Description of the invention (9) "- -Calculate the STFC f data related to this group ^ The feature of the present invention is that the STFC calculation program here is completely automatically executed by the SQL server 23 without using any human resources. In step S24, the FCT data obtained from the s AP platform 22 and the stfc data obtained from the SQL server 23 are published on the web server 240 i. This allows the customer who placed the order to use the Internet The network 20 also uses a web browser, such as the commonly used Microsoft Internet Explorer or Netscape, to browse the FCT / STFC data published on the web server 240. Compared with the conventional technology, E-commerce order response system and method of the present invention Allows customers to browse the required FCT / STFC data through the Internet immediately after issuing an electronic order, thus making the business communication between the customer and the manufacturer more efficient. In addition, the e-commerce order of the present invention The response system and method do not need to use human resources at all, so manufacturers can use this to save human resources. Therefore, the present invention has better progress and practicability than the conventional technology. The above descriptions are merely preferred embodiments of the present invention, and are not intended to limit the scope of the essential technical content of the present invention. The essential technical content of the present invention is broadly defined in the scope of patent application described below. Any technological entity or method completed by others' is exactly the same as defined in the scope of patent application below, or is an equivalent change, it will be considered to be covered by this patent scope. (Please read the precautions on the back before filling in the blocks on this page) Order--Thread This paper size applies to China National Standard (CNS) A4 (210 X 297 mm) 9 16395

Claims (1)

528972 A8 B8 C8 D8 Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs 6. Scope of Patent Application 1. A method of replying to an e-commerce order. It is the second time to respond to an electronic order issued by a customer. The e-commerce order return party φ 5, 丨 ,, & dry and complex include at least the following steps: (1) receiving the electronic order; (2) performing a predetermined FCT calculation based on the received electronic order information The program 'uses this to obtain a set of related FcT data; (3) executes a predetermined FC nose counting procedure based on the received electronic order data, thereby obtaining a set of related sTFc data; and' ( 4) Publish the FCT / STFC data obtained by the SAP platform and the SQL server on a database server; where the data server is externally connected to a network system to allow the customer FCT / STFC data published on the database server can be obtained through the network system. 2. The method of replying to an e-commerce order as described in item 1 of the scope of patent application, wherein in step (1), an EDI platform is used to receive the electronic order. 3 · The electronic as described in item 1 of the scope of patent application The business order reply method, in step (2), an SAP platform is used to execute the FCT calculation program. 4. The method for responding to an e-commerce order as described in item 1 of the scope of patent application, wherein in step (3), a SQL server 230 is used to execute the STFC calculation program. 5 · As for the method of replying to e-commerce orders as described in item 1 of Shenyan's patent scope, this paper size applies to Chinese national standards (CNS> A4 size (210 x 297 mm) 16395 (Please read the precautions on the back before filling in this Page) ------ 丨 Order ί Line-丨 Bee-528972 Printed by the Intellectual Property Bureau of the Ministry of Economic Affairs, Consumer Cooperatives, the paper size is applicable to the Chinese National Standard (CNS) A4 specification (210 X 297 mm) 11 In step (4) A, the Internet season is crying, * J The road system is the Internet, and the data server is a web server. 6. —An e-commerce order response method, in which an electronic order issued by a customer is immediately replied; at least Gong Wangxi includes the following steps: (1) An EDI platform is used to receive the order. Electronic orders; (2) The electronic order data received by the EDI platform is executed through a SAP platform to execute a predetermined FCT calculation procedure, so as to obtain a set of related FCT information; (3) the EDI platform is received by the The electronic order data is executed by a SQL server to execute a predetermined STFC calculation program, and a set of related STFC data is dreamed; Published on-web server, so that the customer can browse the FCT / STFC data published on the web server through the Internet. 7 · An e-commerce order response system, which can respond to an electronic order issued by a customer in a timely manner; The e-commerce order response system includes at least the following system components: (a) — EDI platform, which is used to receive the Electronic orders; (b) — SAP platform, which can execute a predetermined FCT calculation program based on the electronic order data received by the EDI platform, thereby obtaining a set of related FCT data; (c) a SQL server Device, which can receive 16395 according to the EDI platform--------- I--II — ^ illlIII «^ I —Awl (Please read the precautions on the back before filling this page) 528972 A8 B8 C8 D8 VI. Patent application scope of electronic order data to execute a predetermined STFC calculation program to obtain a set of related STFC data; and (d) —Web server, which allows the SAP platform and the SQL The server publishes the obtained FCT / STFC information on the web server, thereby allowing the client to browse the FCT / STFC data published on the web server through the Internet. (Please read the notes on the back before filling out this page) Printed by the Consumer Cooperatives of the Intellectual Property Bureau of the Ministry of Economic Affairs This paper size applies to China National Standard (CNS) A4 (210 X 297 mm) 12 16395