KR19990046731A - System for implementing electronic commerce shopping mall on LINUX - Google Patents

Abstract

The present invention relates to an e-commerce shopping mall building system for Linux. The e-commerce shopping mall system 10 is connected to the e-commerce server 2 to call a store management, merchandise management, membership management, order management, inventory management and sales management system, and operates an e-commerce client (1) operating in Win 95/98. ); An e-commerce server 2 which is operated in the Linux operating system and is connected to the e-commerce client 1 and provides services such as shop management, product management, membership management, order management, inventory management and sales management; Store DB and product DB 3; Merchandise catalog 4; An e-commerce shop 5 providing e-commerce shopping to an online store; A membership registration program 6; A customer DB 7 using an e-commerce shopping mall; An order program 8 for ordering goods selected in the e-commerce shop 5 according to the order details; And an order history DB 9 that stores the order history provided from the payment gateway (PG) 22. Therefore, the Linux operating system securely operates shopping malls on the Internet by applying Internet security protocols from online store building, product management, membership management, order management, inventory management, and sales management to client / server rather than web. Various kinds of stores can be operated and managed simultaneously.

Description

System for implementing electronic commerce shopping mall on LINUX}

The present invention relates to a system for building an e-commerce shopping mall for Linux, and in particular, it is possible to purchase a product desired by a customer by constructing an internet shopping mall, and from the construction of a store in a one-click manner, operation, product management, membership management, and order management. The present invention relates to an e-commerce shopping mall construction system for Linux that can efficiently operate a shopping mall by providing an e-commerce shopping mall management program, which is a client / server type e-commerce solution required to operate a virtual shop and a shopping mall from inventory management to sales management. .

In general, Oracle uses a database engine such as Oracle, Sybase, Informix, etc. for UNIX, and uses Query Query Language: He is developing e-commerce packages using mainly SQL) servers and Oracle. In addition, small e-commerce products create file DB to reduce expensive database costs.

For Unix and Windows NT products, the ordering system and search system for customers are basically supported on the web (WWW). In addition, technical aspects such as product management, customer management, inventory management, and delivery management are also required. Many of them are managed on the web.

In addition, some large database companies, such as Oracle database, operate stores by connecting to a network with a management program of a client / server (C / S) environment developed by a self-developed tool in areas requiring security attention.

Shopping mall products for Unix are usually configured to be managed on the Web.

Therefore, the Internet address for store management can be leaked to the outside, and there are significant security risks. Most of the mall products for Unix use the Common Gateway Interface (CGI) method because they must be managed on the web. In other words, if a large number of users are in the store, speed problems will occur, and the management system that exists on the same site will also have a lot of difficulties in speedy customer service due to speed problems. In addition, these systems are mostly expensive foreign products (20 million won to 30 million won) and constitute a form of management system and service that is not suitable for Korea.

Moreover, despite the fact that the Linux market is expanding, there is a problem that an e-commerce product suitable for the Linux environment has not been developed yet.

The present invention has been made to solve the above problems of the prior art, an object of the present invention is to combine a database for Linux, which is inexpensive and practical, client-server Linux rather than a web connection method E-commerce solution package developed for e-commerce shopping mall managers can use the one-click method to build a store with a single click by using the TCP protocol, and from store construction to product management, membership management, order management, inventory management, sales management In order to secure personal information and credit cards that can be handled on the Internet, it is possible to shop securely by incorporating Secure Socket Layer (SSL) and Secure Electronic Transaction (SET) security protocols. Providing a shopping mall that can be operated and managed at the same time regardless of Linux provides a system for e-commerce shopping mall built to support the optimal marketing.

1 is a block diagram of an e-commerce shopping mall system for Linux according to the present invention.

2 is a flow diagram illustrating the functionality of an e-commerce client in a Win 95/98 environment.

3 is a flowchart illustrating the function of an e-commerce server in a Linux operating system.

4 is a flowchart showing the function of the product catalog.

5 is a flow diagram illustrating the functionality of an order system call.

6 is a flowchart showing the function of the shop management system.

7 is a flowchart illustrating the function of a merchandise management system.

8 is a flowchart illustrating the functions of a member management system.

9 is a flowchart showing the function of the order management system.

10 is a flowchart showing the function of the inventory management system.

11 is a flowchart showing the function of the sales management system.

<Explanation of symbols for main parts of the drawings>

1: e-commerce client 2: e-commerce server

3: store DB, product DB 4: product catalog

5: e-commerce shop 6: membership registration program

7: customer DB 8: ordering program

9: Order History DB 10: E-commerce shopping mall system

11: customer's web browser 12: web (WWW) server

20: Payment Server 23: Transaction History

22: Payment Gateway (PG)

WWW: World Wide Web

HTML: Hypertext Markup Language

SSL: Secure Socket Layer

SET: Secure Electronic Transaction

In order to achieve the above object, the present invention provides a payment including a customer's web browser 11, a web server 12, an e-commerce shopping mall system 10, and a payment gateway (PG) 22. As a system having a server 20, the e-commerce shopping mall system 10 is operated in a Win 95/98 environment, by entering the administrator's ID (id) and password (passwd) to receive administrator authentication and the e-commerce server An e-commerce client (1) connected to (2) to call store management, merchandise management, membership management, order management, inventory management and sales management systems and to modify material requests and results to the e-commerce server 2; An e-commerce server operating in a Linux operating system and connected to the e-commerce client 1 to provide services such as the store management, the product management, the membership management, the order management, the inventory management, and the sales management. (2); A store DB and product DB 3 for storing information of the online store and the online product; After accessing the online store, select a store for shopping and look up a product list to select a product and receive the product information from the product DB (3) to express a product catalog of the product information in an HTML file. Merchandise catalog 4; An e-commerce shop 5, written in HTML and C languages, for providing e-commerce shopping; A member registration program 6 written in C language for registering and processing information of a customer who uses a shopping mall of an e-commerce; A customer DB 7 for storing information of a customer using a shopping mall of an e-commerce; After shopping at the online store, the ordered product and the member information are received and added to the shopping cart, the product quantity is changed, the ordered product is canceled, the selected ordered product is calculated, the customer information is inputted and reconfirmed, and the payment is made through a credit card or online payment. Select a method to enter credit card information if the payment method is the credit card, obtain a credit card authorization by querying the credit card through the payment gateway (PG) 22, and if the payment method is online deposit, the payment bank Select and store in the customer order history DB (9), send e-mail to the order history customer, and move to an internet store, and in the e-commerce shop (5), which is the online internet store An order program 8 for ordering the selected goods according to the order details; And an order details DB 9 for storing the order details provided from the payment gateway (PG) 22 of the payment server 20.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. 1 is a block diagram of an e-commerce shopping mall system for Linux according to the present invention, which includes a web browser 11, a web (WWW) server 12, an e-commerce shopping mall system 10, and a payment server 20. It is composed.

The e-commerce shopping mall system 10 according to the present invention includes an e-commerce client 1, an e-commerce server 2, a store DB and a product DB 3, a product catalog 4, and an e-commerce shop 5 ), A member registration program 6, a customer DB 7, an order program 8, and an order history DB 9.

The e-commerce client 1 develops a client communication module using TCP / IP socket programming, and a user interface (GUI) is developed in Visual C ++ (Visual C ++) to be used in a Win 95/98 environment. It is operated, and the administrator ID is input by entering the administrator's ID (id) and password (passwd) and connected to the e-commerce server (2) to manage the store management, product management, membership management, order management, inventory management and sales management system. Calls and modifies data requests and results to the e-commerce server 2.

The e-commerce server 2 develops a server communication module using TCP / IP socket programming, operates on a Linux operating system, and is connected to the e-commerce client 1 to manage the store. The services of the product management, the membership management, the order management, the inventory management and the sales management.

The store DB and product DB 3 store information of the online store and the online product. The product catalog 4 accesses the online store, selects a store for shopping, searches a product list, selects a product, receives product information from the product DB 3, and receives a product catalog for the product information. Into a HTML file.

The e-commerce shop 5 is an online store, written in HTML and C languages, to provide e-commerce shopping.

The member registration program 6 is written in the C language, and registers and processes information of customers using the shopping mall of the e-commerce.

The customer DB 7 stores customer information using a shopping mall of an electronic commerce.

The order program 8 receives the ordered products and member information by shopping in the online store, adds them to the shopping cart, changes the product quantity, cancels the ordered products, calculates the selected ordered products, inputs and reconfirms customer information, and receives credit. If the payment method is the credit card, select a payment method such as a card or online payment, enter credit card information, obtain a credit card authorization by inquiring a credit card through the payment gateway (PG) 22, and make the payment. If the method is an online deposit, the payment bank is selected and stored in the customer order history DB (9), an e-mail is sent to the order history customer, and moved to an internet store, and the e-commerce shop is the online internet store. (shop) executes an order based on the order details of the product selected in (5).

The order history DB 9 stores the order history provided from the payment gateway (PG) 22 of the payment server 20.

The payment server 20 is composed of a payment gateway (PG) 22 and a transaction history 23. The payment gateway 22 receives the payment confirmation request for the order from the order program 8, inquires the transaction details 23, receives the inquiry result, and provides the payment confirmation result to the order program 8.

2 is a flowchart illustrating the function of an e-commerce client in a Win 95/98 environment. Referring to FIG. 2, the e-commerce client 1 checks the administrator's authentication (step S1) and checks whether the manager is a registered manager (step S2), and if it is not a registered manager, requests an authentication rejection message and reconfirmation request (step S3). Check the administrator authentication again, if the administrator is registered, establish an association with the e-commerce server 2 using a TCP / IP socket (step S4) and check the connection (step S5) if not connected. By reconnecting (step S6), the association with the e-commerce server 2 is again performed to establish the association between the client and the server. When connected to the e-commerce server 2, the shop management (step S100), the product management (step S200), the member management (step S300), the order management (step S400), the inventory management (step S500) and When the corresponding service request such as the sales management (step S600) is made, after receiving a data request and a result from the e-commerce server 2 (step S7), it is checked whether or not it is completed (step S8). (Step S200), the member management (step S300), the order management (step S400), the inventory management (step S500) and the sales management (step S600) process is repeated, and when the e-commerce client (1) ).

3 is a flowchart illustrating the function of an e-commerce server operating in a Linux operating system. Referring to FIG. 3, the e-commerce server 2 establishes an association with the e-commerce client 1 using a TCP / IP socket (step S11), and receives an administrator connection from the e-commerce client 1. (Step S12) The store management (step S101), the product management (step S201), the member management (step S301), the order management (step S401), and the inventory by the service request of the e-commerce client 1 Services such as management (step S501) and the sales management (step S601) are provided, and the next command is received after providing the processing result of the service to the e-commerce client 1 (step S13). If the check is completed or not completed, the store management (step S101), the product management (step S201), the member management (step S301), the order management (step S401), the inventory management (step S501) and the sale The management (step S601) is repeated and the e-commerce server 2 is terminated (step S14).

4 is a flowchart showing the functions of the product catalog 4.

After accessing the user store using the customer's web browser (step S20), the product is searched (step S21) and the store is selected (step S22), the product list is queried and the product is selected (step S23). After receiving the product information from the product DB (step S24) and querying the product catalog (step S25), ordering the product (step S26) and checking the member information in the member DB (step S27) to determine whether the member is a member. Check (step S28) to register a member if not a member (step S29) and store it in the member DB (S30) and order the product again (step S28) and call the order system if it is a registered member (step S31).

Referring to FIG. 5, the calling function of the ordering system ⓣ receives the ordered product and the member information (step S34), puts them in the shopping cart (step S35), and then continues shopping (step S36). Moving to the e-commerce shop 5 (step S37), the product quantity change (step S38) completes the product quantity change by selecting and changing the product quantity (step S39), and canceling the ordered product (step S40) A product to be canceled is selected and cancellation is completed by a cancellation request (step S41). The selected product calculation, customer information is input and reconfirmed (step S42), and a payment method such as credit card or online payment is selected (step S43). If the payment method is the credit card, the credit card information is input (step S44), the credit card is queried through the payment gateway (PG) 22 (step S45), and the credit card authorization is checked (step S46). If the credit card is not approved, the credit card information is entered (step S44) and the payment gateway (PG) (step 22), and the credit card is re-reviewed (step S45) for approval. The settlement bank is selected (step S47). After the credit card is approved and the payment bank is selected, it is stored in the customer's order history DB 9 (step S48), and an email is sent to the order history customer (S56). 5) (step S50).

Referring to FIG. 6, the store management system ⓐ performs functions of a store view (S102), a store add (S104), and a store delete (S106).

The store view (step S102) queries a list of stores to select a store to view store information (step S103), and the store addition (step S104) enters store information and stores it in the store DB (3). Create a store (step S105),

The store deletion (step S106) extracts a list of stores and selects a store (step S107) to check for deletion, deletes the store from the store DB 3 (step S109) or if not deletes the store view ( Step S102), the store addition (step S104) and the store deletion (step S106) are continued.

Referring to FIG. 7, the product management system ⓑ functions to view a product after selecting a store (step S202) (step S203), change a product (step S211), delete a product (step S221), and register a new product (step S231). Do this. The product view (step S203) generates a product catalog after product classification and product selection (step S204) (step S205). The product change (step S211) changes the product contents of the product catalog product template (step S213) created in HTML after product classification and product selection (step S212) and stores it in the product DB 3 (step S214). The product deletion (step S221) checks whether there is a deletion after product classification and product selection (step S222) (step S223) and deletes the store from the product DB 3 (step S224). The new product registration (step S231) selects categories of major classification and small classification (step S232), inputs product information to create the contents of the product catalog in HTML (step S233), and loads a product image (step S234). After storing in the product DB 3 (step S235), the product view (step S203), the product change (step S211), the product deletion (step S221) and the new product registration (step S231) are continued.

Referring to FIG. 8, the member management system ⓒ performs a function of member classification S302, excellent customer list S311, and anniversary management S321.

The member classification (step S302) is a specific member list (step S303), male and female member list (step S304), region list (step S305), age list (S306), job list (step S307), respectively. Select a member to view member information and order details.

The excellent customer list (step S311) looks up the product purchase history and compares the criteria for the excellent customer (step S312), looks up the excellent customer list (step S313) and selects the specific member (step S308). View information and order history.

The anniversary management (step S321) confirms anniversaries, searches for birthdays and wedding anniversaries, inquires a list of members (step S322), and automatically sends a congratulatory message by e-mail.

Referring to FIG. 9, the order management system ⓓ checks the order details, calculates an order list (step S402), checks the goods shipment confirmation (step S403), and checks the goods shipment confirmation (step S404). S405) Check the payment confirmation (step S406), check the goods shipment confirmation (step S404), check the return to calculate the list to be returned and the customer (step S407) and check the goods exchange confirmation (step S408) The shipment confirmation is checked (step S404). After checking the product shipment confirmation (step S404), a mail (mail) for reconfirming the order details is sent to the customer (step S409), and stored in the order history DB 9 of the customer (step S410).

Referring to FIG. 10, the inventory management system ⓔ selects a store (step S502), calculates a product list and a current quantity / sold quantity by managing inventory by a member company (step S503) and inventory by product (step S504). (Step S505) The quantity at the time of goods receipt is changed (step S506), it is stored in the goods DB 3, and it returns to the stock management system ⓔ.

Referring to FIG. 11, the sales management system ⓕ inquires the sales situation S602, the sales situation S603 by company, and the sales situation S604 by product to the product DB 3 (S605). The list is calculated, the product quantity and the price information are calculated (S606) and fed back to the sales management system (ⓕ).

Therefore, by building an e-commerce shopping mall in the Linux operating system using a client / server method rather than the web method, the manager shopping mall can be safely operated from online store construction to product management, membership management, order management, inventory management, and sales management.

As described above, the system for building an e-commerce shopping mall for Linux according to the present invention develops an inexpensive and practical e-commerce package for Linux and operates a small- to medium-sized internet store while operating a high-priced foreign e-commerce solution. Anyone can easily set up an e-commerce store with excellent performance, and develop an e-commerce solution for Linux that incorporates Linux databases such as Oracle, Informix, and mSQL. Rather than managing the store in the company, the self-developed client / server type e-commerce management system solution allows administrators to connect to the e-commerce server in real time by using the TCP protocol from the e-commerce client of their computer. To operate and manage your online store It provides a shopping mall that operates and manages not only a small single store but also various types of stores at the same time.The one-click method of building online stores, operation, product management, membership management, order management, inventory management, Sales management can be handled all over the Internet, and one-to-one marketing principles can be used to analyze product consumption trends and support optimal marketing. For this reason, it is possible to securely shop by combining the Secure Socket Layer (SSL) and Secure Electronic Transaction (SET) security protocols.

Although the above has been described with reference to a preferred embodiment of the present invention, those skilled in the art will be able to variously modify and change the present invention without departing from the spirit and scope of the invention described in the claims below. It will be appreciated.

Claims (4)

In a system comprising a customer's web browser 11, a web server 12, an e-commerce shopping mall system 10, and a payment server 20 including a payment gateway (PG) 22 The e-commerce shopping mall system 10 Operates in Win 95/98 environment, enters administrator ID and password (passwd), authenticates the administrator, connects to the e-commerce server (2), store management, product management, membership management, order management, inventory An e-commerce client (1) for invoking a management and sales management system and for modifying data requests and results to the e-commerce server (2); An e-commerce server operating in a Linux operating system and connected to the e-commerce client 1 to provide services such as the store management, the product management, the membership management, the order management, the inventory management, and the sales management. (2); A store DB and product DB 3 for storing information of the online store and the online product; After accessing the online store, select a store for shopping and look up a product list to select a product and receive the product information from the product DB (3) to express a product catalog of the product information in an HTML file. Merchandise catalog 4; An e-commerce shop 5, written in HTML and C languages, for providing e-commerce shopping; A member registration program 6 written in C language for registering and processing information of a customer who uses a shopping mall of an e-commerce; A customer DB 7 for storing information of a customer using a shopping mall of an e-commerce; After shopping at the online store, the ordered product and the member information are received and added to the shopping cart, the product quantity is changed, the ordered product is canceled, the selected ordered product is calculated, the customer information is inputted and reconfirmed, and the payment is made through a credit card or online payment. Select a method to enter credit card information if the payment method is the credit card, obtain a credit card authorization by querying the credit card through the payment gateway (PG) 22, and if the payment method is online deposit, the payment bank Select and store in the customer order history DB (9), send e-mail to the order history customer, and move to an internet store, and in the e-commerce shop (5), which is the online internet store An order program 8 for ordering the selected goods according to the order details; And E-commerce shopping mall building system for Linux, characterized in that consisting of an order history DB (9) for storing the order history provided from the payment gateway (PG) (22) of the payment server (20). The method of claim 1, The e-commerce client 1 Check the administrator's authentication (S1) to check whether it is a registered administrator (S2), if it is not a registered administrator, request authentication rejection message and reconfirmation (S3) to check the administrator's certification again, and if the registered administrator is a TCP / IP socket Use the (Socket) to establish an association with the e-commerce server (2) (S4) and check the connection (S5) if not connected again (S6) to establish the association between the client / server the e-commerce server (2) After executing the association setting again, and connected to the e-commerce server (2), the store management (S100), the product management (S200), the member management (S300), the order management (S400), the inventory When the corresponding service request such as the management (S500) and the sales management (S600) is made, after receiving the data request and the result from the e-commerce server 2 (S7), and checking the completion (S8) if not completed Store management (S100), the product management ( S200), the member management (S300), the order management (S400), the inventory management (S500) and the sales management (S600) repeats the process, and finished when confirmed e-commerce shopping mall for Linux Building system. The method of claim 1, The e-commerce server 2 is Establish an association with the e-commerce client 1 using a TCP / IP socket (S11), receive an administrator connection from the e-commerce client 1 (S12), and request a service request of the e-commerce client 1. Services such as the shop management (S101), the product management (S201), the member management (S301), the order management (S401), the inventory management (S501) and the sales management (S601), After providing the result of processing the corresponding service to the e-commerce client 1, the next command is received (S13). If the completion is not checked by completion of the shop management (S101), the product management (S201), and the member management ( S301), the order management (S401), the inventory management (S501) and the sales management (S601) process is repeated, and when confirmed that the e-commerce server (2) is terminated (S14) E-commerce shopping mall construction System. The electronic commerce client (1), the electronic commerce server (2), the store DB and product DB (3), the product catalog (4), the e-commerce shop (5), the member registration program (6) on a computer By using the e-commerce shopping mall system 10 including the customer DB (7), the order program (8), the order history DB (9) can be read by a computer recording a program for executing the e-commerce shopping mall for Linux Recording media.