KR20160032402A - The Marketing Management System related Online Shopping System - Google Patents

Abstract

The present invention relates to a sales management system in association with shopping. The system comprises the following steps of: storing member information in an integrated DB of a management system if a customer subscribes to a shopping mall as a member; storing a product in the integrated DB of the management system again if the product is read or ordered; and storing payment information, association information related to payment, delivery information, preference information, sales related information, and the like in the integrated DB of the management system in case of payment. Therefore, a sales manager and a system manager organically and effectively use the system to make a sales achievement.

Description

[0001] The present invention relates to a marketing management system,

The present invention basically integrates functions (order, finishing, logistics, production, finance, settlement, etc.) of a sales management system in an online shopping mall system. It is a system of sales information management system (B2B) is a system in which a company registers services or goods and is purchased by an individual or an enterprise customer. However, this integrated system is a system in which an ASP (Application Service Provider) method to an individual or an enterprise customer, thereby solving both sales management and sales and purchase in one system.

In general, a shopping mall is composed of menu items such as product registration, member registration, approval information, bulletin board management, point management, order book management, delivery management, and event management. Whether it is a B2B shopping mall or a general small shopping mall, the program has almost similar menus and structures. The purpose of the shopping mall is to structure and sell the goods and goods, and to include other bulletin boards, points, orders, deliveries and events that depend on them. Nowadays, thousands of these shopping malls are on the Internet or mobile, and they are also disappearing.

The sales management system consists of menu items such as sales management, item management, menu management, sales management, order management, deadline management, event management, sales activity management, tax management and claim management. The sales management system, which consists of business related information such as distribution or manufacturing, is composed of more menu items related to sales as described above, and business logic and processes have the same pattern.

And the sales management system in order to integrate the shopping mall and the sales management system separately, so that the business related to the shopping, the purchase and sale of the goods and the goods, and the sales activities related thereto are made into one information system. A system capable of sales management work is a shopping-linked sales management system of the present invention.

In the present invention, how a shopping mall and a sales management system are integrated and how business processes are defined is a solution to a shopping-linked sales management system.

In other words, by integrating shopping mall system, sales management system, management system and link system into one integrated DB and one business process, users, sales managers and system administrators can organically use this system effectively, Whether or not an integrated system capable of enhancing business performance can be created is a core content of the present invention.

Business process framework In terms of system integration, when a customer purchases a certain product, it is stored in a shopping mall system, a sales management system, and a linked system simultaneously in a consolidated DB. This integrated DB is used simultaneously in sales management, connection management and system management Structure is a key to the present invention.

The present invention relates to a system and method for storing goods in a shopping mall, a step of storing the goods in an integrated DB of a management system when a customer registers the goods, a step of storing goods or goods in an integrated DB of the management system, Information, and shipping information, taste information, and business related information are stored in the integrated DB of the management system. The stored integrated DB refers to the meta DB that receives the flag value, and in the shopping mall system, The information is taken from the integrated DB, outputted, and outputted to the management system, and also outputted from the sales management system.

In this process structure, integrated DB is shared in shopping mall, sales management system and link system.

It is also linked with the purchase of goods, logistics, production, finance, management information for shopping mall operation, so that it can process goods purchase, logistics, production, finance and management information not merely shopping mall concept of product in one system at a time , And sales management (sales increase or profit improvement), which is the greatest advantage of this system, can be operated integrally in one system.

The present invention relates not only to the concept of selling goods at a shopping mall but also to the purchase of goods, logistics, production, finance, and management information for shopping mall operation, so that purchase, logistics, production, And the internal sales management for operating business (sales growth or profit improvement) in the sales management system, which is the biggest advantage of this system, can be operated integrally in one system.

1 is a block diagram of a shopping-linked sales management system;
FIG. 2 is a block diagram of a shop-linked sales management system DATABASE.
Fig. 3 shows a structure of a shopping-linked sales management system.
FIG. 4 is a flowchart illustrating a shopping-linked sales management system FLOWCHART.
FIG. 5 is a block diagram of the shopping linked sales management system PROCESS.
FIG. 6 is a diagram illustrating a shopping management system according to a shopping management system, MATCHING LOGIC.

The present invention will now be described in detail with reference to the accompanying drawings.

 1 is a block diagram of a shopping-linked sales management system. As shown in the block diagram, the system includes one integrated system such as 170 sales management system, 180 shopping mall system, 190 linkage system, and 191 management system, The base uses the shopping-linked sales management system integrated database such as 192 which integrates the databases of the sales DB, shopping DB, and management DB of each business. The internal link system of 110 is connected with the shopping-linked sales system, , Production, finance, and management systems, and can be used as an option in the shopping-linked sales management system.

160 The external linkage system can link EDI, communication, delivery, bank, and VAN, which has the advantage of being able to selectively link with integrated DB according to business needs.

The whole process is described as a system in which customers, corporations, and managers can organize product ordering, product registration, ordering and delivery within the system, and can handle all the basic steps of distribution in one system.

Accordingly, in the shopping-linked sales management system of the present invention, a company registers a product to be sold, and when a customer orders a product, the manager has a structure for ordering and receiving delivery. For example, if a customer wishes to purchase a car, the order is received for the car registered by the company, and the company requests the manager to order the car to sell. Then, the manager has a business process of confirming the customer's order information and the product registration information of the company, placing an order for the company, receiving the order, delivering the car to the manager, confirming the payment information of the customer, All the data of this process is stored in the integrated database and is used for future marketing and sales management. From another point of view, the manager can also connect the customer to the company and generate profit through it while performing the ESCROW service role between the customer and the company. If the general company uses the shopping-linked sales management system of the present invention system, In addition to this, it is possible to integrate the whole system and sales part for the integrated distribution.

 FIG. 2 is a diagram showing a DATABASE of a shopping-linked sales management system in which a shopping mall system and a sales management system store data in a structure and a data flow is schematically shown.

 As shown in FIG. 2, the management system DB01 performs the role of MASTER DB. That is, the data in the sales management DB, the shopping DB, and the integrated customer DB are used to refer to each table and column by referring to the flag value of the MASTER DB. In addition, copies of sales management DB, shopping DB, and integrated customer DB are configured to store the same data in the management DB02 or SUB DB through batch data at regular intervals.

That is, the MASTER DB arranges options which are the flag values of the sales management DB, the shopping DB, and the integrated customer DB, which are subordinate DBs, and stores a copy of the hot DB in the SUB DB. It can also be divided into upper DB and lower DB

210,220,230,240,250,260 is the upper DB and is stored in the flag value of the data and option, and the Flag value and option which are the basis of this option and the Flag value can be controlled in the Master DB. ACCESS is possible only at the location where the business DB of the actual shop-linked sales management system is stored.

The sub DB retrieves the Flag values of the MASTER DB, 220 sales management DB users, 230 sales management DB administrators, 240 shopping DB users, 250 shopping DB managers, and 260 integrated customer DB, which are the upper DBs, through the management system DB 02, The sub-DBs that transmit and deliver the data have a structure to perform input and output with the user. 292 Sales management user DB, 292 Sales management DB DB, 292 Shopping mall user DB, 292 Sales management user database DB for directly inputting data output from the user through the master database for association management, 281 Management system DB for sales management, 281 Management system DB for shopping mall, Screen DB, sales management link DB01 and shopping mall link DB02.

That is, the lower DB also has the MASTER concept DB on the DB which becomes the input / output of the user data of the final stage, and the DB of this MASTER concept controls the lower DBs according to the FLAG value of the entire system's SuB DB.

FIG. 3 shows a structure of a shopping-linked sales management system. In FIG. 3, reference numeral 310 denotes a database of a shopping-linked sales management system, 320 denotes a management system, 330 denotes a verification, 340 denotes a sales management system processor and 350 denotes a shopping mall processor.

As shown in <Fig. 2>, MASTER DB transfers Flag to SUB DB, SUB DB transfers FLAG to sub-DB, and the actual DB of 292 Sales Management User DB, Sales Management DB DB, 292 Shopping Mall User Screen DB and sales management link DB01 and shopping mall link DB02 exchange data directly with users (customer, company, manager) data.

For example, in the case of the basic product data, each menu of the sales management system processor (sales management, sales management, deadline management, order management, item menu management, sales) is managed through the 320 management system processor and 330 authentication management, information matching, Supply management, and tax management) and the management system's processes and databases, exchanging the data. At this time, in addition to the sub-DB of the customer information MASTER DB and SUB DB, a copy of the sub- It is stored once again in DB form. In addition, the integrated customer database in the sales management system is composed of 360 individual members, 370 corporate members , 390 Purchase, 391 Logistics, 392 Production Processor and DB to be directly input and output

And has a structure that includes a separate copy in the category of the business management system.

Referring to FIG. 3, in detail, how a business process progresses when an actual user uses the shopping linked sales management system. When a customer (user) places an order to purchase a product in a shopping mall and makes a payment, ), The company accepts the order and applies for the order to the manager, and the company makes the delivery to the manager for the ordered product, and the manager confirms the delivery (processing the confirmation of delivery of the company, To approve the delivery of the goods. All of these processes are automatically transferred to the sales management system, sales management, deadline management, order management, item menu management, sales supply management, and tax management items of the sales management system. (For example, the accounting officer in the company uses sales and tax management items and the salesperson uses sales force management items), and the system administrator can manage authentication management, information matching, and consistency in 330 verification menus. In other words, the whole process is not just the concept of purchasing goods in a shopping mall, but selling by the seller, but rather the concept of a certain company needing to purchase, logistics, production, finance, It is a structure that can be done in the stem. More specifically, if a manufacturing company produces and sells bread and operates the company, in order to produce and sell bread as a shopping mall, it is necessary to purchase flour (purchase), purchase flour and store it (logistics) (Production) to be produced by a certain amount of production, and a financial manager (financial) is necessary for the operation. This is all operated by the sales amount of the bread, so if the bread is sold through the shopping mall, The tasks of the internal system listed above can be processed sequentially. If you have a mall, you have to operate a separate system for all the various operations of your company. However, the shopping-linked sales management system has a structure that integrates business processes of the entire company in one system by linking the sales through the shopping mall, purchasing through the sales management system, logistics, production, and finance. It can be used as a sales management system of a company, but it can be operated by an independent distributor. That is, a shopping mall is integrated with a sales management system, and the process is organically processed in one system

If the company is not directly producing goods but is in the distribution stage, it has a structure suitable for distributors who can purchase goods through the sales management system, sell them through shopping malls, and distribute the profits to the manufacturers . For example, discount stores do not produce goods directly, but they have a strong point in sales through retail stores. When this discount mart is sold through a shopping mall, for a merchandise sold through a shopping mall, if the customer proceeds purchase and payment through the shopping mall, the sales management system manager linked to the shopping mall places an order with the merchandise producer, Proceed with delivery of goods that the sales management system has already registered. Then, you can get the revenue from the distribution operation income by deducting the delivery amount from the customer's commodity amount, and the integrated DB of the archived customer and company can add the customer through new sales activity event management, marketing and claim management It can also help to improve the operating profit. As described above, the shopping-linked sales management system of the present invention can be regarded as an optimized enterprise information system that can cover not only the concept of the shopping mall concept and the integration of the sales management system but also the production through sales, distribution and connection.

FIG. 4 is a flow chart of a shopping-linked sales management system. FIG. 4 shows a process flow in the information system of the present invention.

410 sales information system, 420 shopping mall system, and 430 management system are separate concepts, but processes are flowing out of each other organically. In detail, the shopping mall system is centered

Whether the shopping mall is B2B or P2P, the customer is registered and the customer (including individual and company) is registered in the integrated DB

In the case of an individual, customer information is shared with a sales management system that grasps personal information and customer purchasing tendency through account management. In the case of a company, each item is registered in sales / sales / order / closing / item sales management system. This registered information selects a user display screen in a shopping mall, displays an account management or shopping related menu in a shopping mall, displays a menu related to sales / sales / order / finishing / item in the case of a company, , It is configured to acquire sales information function through each customer integrated DB, to match categories, to match menus, to match DBs, and to integrate management functions of sales and shopping of management system. All of the above processes are organically linked to the business process.

As an example, if you are a member, you will be transferred to the personal account menu through the personal user DB. If the company is a member, you will be transferred to the corporate account menu through the corporate user DB, and sales / sales / order / The management system is responsible for managing the entire system so that the individual and the enterprise can be operated in cooperation with each other. But it is a form that directly manages the distribution process in which the manager performs the overall integrated sales management with the shopping mall. However, this management system is not merely a distribution system that connects individuals and companies but rather a sales management system that can include the entire production, purchasing, logistics, finance, will be.

FIG. 5 represents the process of the shopping-linked sales management system. The shopping-linked sales management system has two processes, 510Matching system and 530MASTER system. The data stored in the integrated customer DB of 561 is stored as a flag value in the integrated master DB This is done by deduplication at 560, validation of the data at 580, and then the 590 data integration process.

In other words, when the user inputs data, the 510Matching system compares the data with the raw data and extracts it from 540. The data of the corresponding job is stolen at 550. Then, the redundancy is removed at 560. Then, If the value stored in the integrated DB is stored as Flag in the integrated master DB, it is stored in the integrated customer database in reverse. Then, the data is transferred again to each task, and the existing raw data and validity check are performed. Flag.

More specifically, user input data is stored as a flag value in comparison with existing raw data. It is verified for compatibility with existing registered data, and is stored again as a flag. Thus, all data are retrieved from each database table with only a flag value, The data process is performed. Since the data input / output form is the same as the above, it is possible to perform the sales management, item / menu management, sales management, sales supply price management, order management, sales activity management, The items of deadline management, tax management, event management and claim management are classified into product registration, member registration, payment information, order book management, bulletin board management, shipping management, point management, event management, Management, internal system management, and external link system management.

In other words, the purchase information entered by the user in the shopping mall goes through the matching system in the item / menu management item of the sales management system, the data is refined in the item / menu of the existing sales management system, The information of the user and the purchased goods is integrated into the integrated customer DB, and the data is transferred to the order management, delivery management and point management of the shopping mall system again. It goes over to shopping mall system management and sales system management part. In other words, the input / output of all data is basically stored in a cross in the shopping mall system, the sales management system, and the management system. In addition, the structural features that can be linked with the purchase management, logistics management, production management, .

FIG. 6 is a diagram showing matching logic of the shopping-linked sales information system, which includes 610 user accounts and 620 virtual system accounts, stores sales management categories and shopping mall categories together,

The sales management function selection process moves along with the shopping mall function selection process and recognizes the unique identification ID of each data through the matching key value (Master Flag), so that the shopping mall and the sales management system operate as if they are one system.

Finally, a matching DB shared with 630 shopping mall and sales management system is placed, and extraction, refinement, deduplication, data migration, validity check, and final data integration are stored in respective databases.

As a result, we have described the structure, form, and characteristics of the shopping-linked sales management system. This means that the shopping-linked sales management system efficiently integrates the functions of the shopping mall and the functions of the sales management system within a single system, , And a way to build a system that can cover sales.

Flag = identification value

Claims (7)

When a customer (user) places an order and makes a payment in a shopping mall of a sales management system, a company (user) accepts an order and applies for an order to an administrator. When the manager approves the order, The delivery is made to the manager for the commodity, and the manager confirms the delivery (processing of the company's delivery confirmation document, not the actual commodity confirmation) and approves to deliver the commodity to the customer. All of these processes are automatically transferred to the sales management system, sales management, deadline management, order management, item menu management, sales supply management, and tax management items of the sales management system. (For example, the accounting person in the company uses the sales and tax management items, and the sales person uses the sales supply management item), and the system administrator can manage authentication management, information matching and consistency in the verification menu. In other words, the whole process is not just the concept of purchasing goods in a shopping mall, but selling by the seller, but rather the concept of a certain company needing to purchase, logistics, production, finance, How to build an information system with structure that can be done in the stem



MASTER DB stores the options which are Flag values of sales management DB, shopping DB and integrated customer DB which are sub-DBs and SUB DB stores a copy of sub-DBs. It is divided into upper DB and lower DB, The flag value and options can be controlled by the Master DB. Options in these upper DBs can be accessed only by the administrator system in the shopping linked sales management system. When the lower DB stores the business data of the actual shopping linked sales management system And the lower DB has the MASTER concept DB on the DB which is the input / output of the user data in the upper end, and the MASTER concept DB controls the lower DBs according to the FLAG value of the entire system's SuB DB.

It is not a concept that simply purchases goods from a shopping mall and sells them, but rather a concept that allows a company to make purchasing, logistics, production, finance, management, and shopping malls and sales activities needed to produce goods Establish a shop-linked sales management system of the type described
How to.


If the customer (including individual and company) is registered in the integrated DB by registering a customer, whether the shopping mall system is B2B or P2P, the sales management that grasps personal information and the purchasing tendency of the customer through account management Customer information is shared with the system. If the company is a company, each item is registered in the sales management system of sales / sales / order / finishing / item. This registered information selects a user display screen in a shopping mall, displays an account management or shopping related menu in a shopping mall, displays a menu related to sales / sales / order / finishing / item in the case of a company, An information system structure in which sales information functions are acquired through respective customer integrated DBs, categories are matched, menus are matched, databases are matched, and management and sales functions of the management system are integrated and managed.
In the shop-linked sales management system, the user input data is stored as Flag value as compared with the existing raw data, and it is verified with the existing registered data and stored again as Flag so that all data can be retrieved from each database table with only Flag value, The information system structure in which the data process proceeds in the form shown to the user.



The purchase information entered by the user in the shopping mall is passed through the matching system in the item / menu management item of the sales management system, the data is refined in the item / menu of the existing sales management system, and the redundancy is removed. And stores the collected data in the integrated customer DB. Then, the data is transferred to the order management, delivery management, and point management of the shopping mall system, and again, through the master system of the manager system, System management. In other words, the input / output of all data is basically stored in a cross in the shopping mall system, the sales management system, and the management system. In addition, the structural features that can be linked with the purchase management, logistics management, production management, .

The sales management category selection and the shopping mall category are stored together with the user account, the virtual system account exists, the sales management function selection process moves together with the shopping mall function selection process, and the unique identification of each data through the matching key value (Master Flag) A structure in which the shopping mall and the sales management system are recognized as one system by recognizing the ID.

Images