KR20220087034A - Estimation Management System for Fabricating Studio - Google Patents

Abstract

According to the workshop estimate management system of the present invention, when creating an estimate in the workshop by modularizing the contents of the wood type, work date, dimensions, product type, finishing method, assembly method, etc. required in the workshop estimate, the data is automatically entered and It is possible to collect information from customers who have received orders from the workshop to analyze and utilize trends on customer orders, and to collect information on the trends of customers who purchase woodworking products, and to pay price through customer purchase information. Information on the average of purchases, statistics of the area where purchases are made, age, gender, etc. can be converted into a DB, and by integrating the quotation form used in the workshop, quotation management can be easily converted into a DB for analysis, marketing through big data collection, It has the effect of broadening the scope of use of various information on sales and product manufacturing.

Description

Workshop Estimation Management System {Estimation Management System for Fabricating Studio}

The present invention relates to an estimate management system for a workshop, and more specifically, when creating an estimate in a workshop by modularizing the contents of the wood type, work date, size, product type, finishing method, assembly method, etc. required in the workshop estimate, the data It is related to the quotation management system of the workshop, which is automatically entered and the customer information received from the workshop is converted into a DB, and the information is collected to analyze and utilize trends on customer orders.

In general, without a program for quotation in the workshop, most of the cases were to write a paper estimate manually or to create and print data through Excel. Although information on various quotations is being input, there is a problem in finding the contents of previous transactions, as well as the use of information for marketing and the diversification of quotation forms, so it is not standardized, so there is a problem in using it as data.

Republic of Korea Patent Publication Registration No. 10-1094167

The present invention has been devised to solve the above problems, and when making an estimate in the workshop by modularizing the contents of the wood type, work date, size, product type, finishing method, assembly method, etc. required in the workshop estimate, the data is automatically In addition, it is possible to collect the information of customers who have been inputted into a database and receive orders from the workshop so that they can analyze and utilize trends on customer orders. Information on the average of the price paid through , statistics of the region where purchases are made, age, gender, etc. can be converted into a DB, and by integrating the quotation form used in the workshop, it is possible to easily manage the quotation and analyze it as a DB, and collect big data. It is to provide a workshop estimate management system that can broaden the scope of use of various information on marketing, sales, and product manufacturing.

In the workshop estimate management system of the present invention for achieving the above object, a workshop authentication key is automatically generated and issued when registering as a workshop member on the workshop relay site through the workshop manager terminal, and an educational member managed by the workshop joins as a sales member It is characterized in that the workshop authentication key issued from the workshop relay site is given to the education member to be converted into a sales member and registered; When registering as a workshop member on the workshop relay site, it is possible to access the workshop relay site and use the workshop manager page, and when converted to a sales member, access the workshop relay site and use the sales member manager page.

The workshop relay site manager page for managing the workshop relay site calls up and displays category data based on the data of the quotation, the sales area that calls and displays the region designated at the beginning of the customer who purchased the product, and daily estimate The ranking is based on the daily order production status that displays , payment and unpaid details, the sales amount that shows the ratio of the total payment amount for each workshop and sales member’s inventory and returned products, and the sales amount of workshops and sales members The displayed sales ranking may be included and displayed.

The workshop relay site manager page may be displayed including whether the purchasing member has deposited the amount after receiving the quotation from the workshop, the type of product concerned, and the terms of the contract.

Estimate management performed through the workshop manager page or the sales member manager page allows you to check, transmit, and print the quotation created in the workshop, check the contents of the previously created quotation along with the newly created quotation, and send a new quotation You can write more.

The content to be entered to create a quotation is supported in a categorical method that is selected from preset items, and if there is information entered during previous workshop registration, it is automatically retrieved and entered. , business number, address, name of representative, name of workshop, when to write a quote, sign or seal of the workshop, selection of detailed settings for product category, production method, dimension, production period, type of wood, finishing method, type of oil, use of steel frame Availability, A/S period, assembly method, delivery method, color, image attachment for design, and product price can be displayed.

The written estimate is stored in the database of the workshop relay server, and the estimate information is accumulated and turned into big data, which can be used for trend analysis and search accordingly.

When the quotation is completed, a quotation code number is automatically generated and entered in the quotation, and the quotation code number can be created by combining the workshop registration number, workshop area code, and workshop document creation number.

According to the workshop estimate management system of the present invention as described above, when creating an estimate in the workshop by modularizing the contents of the wood type, work date, size, product type, finishing method, assembly method, etc. required in the workshop estimate, the data is Customer information entered automatically and ordered from the workshop is converted into a DB so that information can be collected to analyze and utilize trends on customer orders. Information on the average of the price paid through information, statistics of the region where purchases are made, age, gender, etc. can be converted into a DB, and by integrating the quotation form used in the workshop, it is possible to easily create a DB for quotation management and analyze big data. It has the effect of broadening the scope of use of various information on marketing, sales, and product manufacturing through collection.

1 to 3 are diagrams for explaining membership subscription to the workshop relay site in the quotation management system of the workshop to which an embodiment of the present invention is applied,
4 and 5 are diagrams showing the contents displayed through the workshop relay site in the quotation management system of the workshop to which an embodiment of the present invention is applied,
6 is a view showing a workshop list page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
7 is a view showing the sales member list page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
8 is a view showing the workshop detail page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
9 is a view showing a sales member detail page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
10 and 11 are views showing a return / inventory product page in the estimate management system of the workshop to which an embodiment of the present invention is applied,
12 and 13 are diagrams showing the workshop relay site manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
14 is a view showing the product order status performed through the workshop relay site manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
15 is a view showing the stock product sales status performed through the workshop relay site manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
16 is a view showing the order/production status for each company performed through the workshop relay site manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
17 to 21 are views showing workshop and sales member management performed through the workshop relay site manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
22 to 24 are views showing payment management performed through the workshop relay site manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
25 and 26 are views showing the workshop manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
27 is a view showing payment management performed through the workshop manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied;
28 and 29 are views showing return / inventory product management performed through the workshop manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
30 to 32 are views showing the estimate management performed through the workshop manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
33 to 35 are views showing member management performed through the workshop manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied,
36 to 38 are diagrams illustrating quotation management performed through the sales member manager page in the quotation management system of the workshop to which an embodiment of the present invention is applied.
Figure 39 is a processing procedure diagram for the method of managing the estimate of the workshop according to an embodiment of the present invention.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings in order to be described in detail so that those of ordinary skill in the art can easily practice the present invention.

The workshop quotation management system according to an embodiment of the present invention includes a workshop relay site server and a plurality of user terminals such as a PC, a smart pad, and a smart phone for using information by being connected to the workshop relay site server. .

In this case, the plurality of user terminals may include a workshop manager terminal and a sales member terminal.

First, as shown in FIGS. 1 and 2, the workshop manager accesses the workshop relay site through the terminal and requests membership as a workshop member through ID, password, and operator authentication, etc. If approved, you are completed as a workshop member and can log in to the workshop relay site.

When registration as a workshop member on the workshop relay site is completed, the workshop authentication key (workshop member code number) is automatically generated from the workshop relay site, transmitted to the workshop manager terminal, and stored in the database of the workshop relay site.

The workshop authentication key is generated by combining the order of registration + year of registration + area code + random number, and may be generated as, for example, 0001-2019-031-0089.

If you sign up as a workshop member, you can access the workshop relay site and use the workshop manager page.

In addition, as shown in FIG. 3 , a general user may join as a general member after accessing the workshop relay site through a terminal.

As shown in FIGS. 4 and 5, the workshop relay site includes popular workshop/semi-pro items, connected member interest category items, workshop page items, sales member (semi-pro) page items, and returned/stocked product items. is displayed

In the popular workshop/semi-pro category, the sellers and workshops that many purchasers of the workshop products click or confirm are shown.

In the interest category item of the connected member, workshops and sales members with similar production categories and price points are displayed based on the workshop page and the sales member page that the members checked.

The workshop page item is a workshop introduction page, and the workshop logo, workshop name, region, representative category, impression button and number of clicks of the impression button are displayed. do.

The items on the sales member page include the sales member photo, information about the workshop, representative category, region, support button, and the number of clicks on the support button. do.

Returned/stocked product items are displayed with product photos, regular price, discount price, discount rate, and reason for discount.

When the Show more button is selected in the workshop page item, as shown in FIG. 6, the studio list page is moved to, and when the Show more button is selected in the sales member page item, as shown in FIG. Likewise, it moves to the sales member list page, and the workshop list page and the sales member list page are displayed similarly.

On the left side of the workshop list page and the sales member list page, items that can be searched for product selection, region selection, price range, etc. are displayed to make it easier for buyers to find workshops and semi-pros they want.

In the case of a product tag, the value of the tag information set at the beginning by the workshop and the sales member is called and the most tagged information is shown in priority. Collect and display the workshops and sales members that have been placed.

On the right side of the workshop list page and the sales member list page, up/down buttons, promotional banner items, provisional estimate writing items, usage method items, and best review items are displayed.

If you select the promotional banner, you will be taken to the promotion page. If you select Write a provisional estimate, you will be connected to the provisional quotation page to proceed with making a provisional estimate. If you select the method of use, it will be linked to a notice, and if you select the best review, it will be linked to the review list. connected to the window.

When a studio is selected on the workshop list page, as shown in Fig. 8, the workshop is moved to the corresponding workshop detail page. When a sales member is selected from the sales member list page, the corresponding sales member details page is moved as shown in Fig. 9. .

The workshop detail page displays the workshop representative photo, workshop information, and 1:1 chat window. Delivery and A/S regulations, purchase reviews, and production reviews are included and displayed.

On the sales member detail page, the sales member representative photo, workshop information, and 1:1 chatting window are displayed. Information, shipping and A/S regulations, purchase reviews and production reviews are included and displayed.

When the Show more button is selected in the returned/invented product item, as shown in FIG. 10 , it moves to the returned/invented product list page.

The returned/stocked product list page should list all returned/stocked product prices, dimensions, and other details. Photos of returned/stocked products, discount rates, pre- and post-discount prices, and reasons for returns and stocks , the seller's name, purchase selection items, and items to add to cart are displayed, and in the case of returned/stocked products, since they are already made products, they can be purchased immediately. do.

When a product is selected from the returned/invented product list page, as shown in FIG. 11 , it moves to a returned/invented product detail page.

Return/stock product detail page displays returned/stocked product photos, discount rate, price before and after discount, reason for return and stock, seller name, payment page, 1:1 inquiry page, returned/stocked product description items In this way, a video introducing returned/stocked products, photos and stationery, and photos of products sold in the workshop are displayed, and information about the seller, delivery and A/S regulations, purchase reviews and production reviews are also displayed.

In addition, on the return/stock product detail page, an immediate purchase button is inserted at the bottom to enable immediate purchase when the purchase button is selected. Make the sale complete mark displayed.

12 and 13 show the workshop relay site manager page in the quotation management system of the workshop. The workshop relay site manager page manages the workshop and sales members as well as performs permission in various parts, and data movement is continuously performed. should be done

On the Home screen of the workshop relay site manager page, the total monthly sales amount (settled from the 1st of each month to the end of each month), monthly product production (number of payments for workshop + sales member + returned product sales), and new member registrations this month , monthly sales status, customized product workshops and product categories ordered by sales members, customer preferred categories, authentication and approval details for new workshops, and member management showing certification and approval details for new sales members are displayed and the details of the new deposit are displayed, and the details of the new inquiry are displayed.

14 is a view showing the product order status on the workshop relay site manager page, the customized order status in which the sales figures compared to the quotation are displayed while the results of the workshop and the sales member are displayed through customization, and the latest in the quotation creation It includes details about which information and payment details are displayed.

In the custom order status, it is possible to display a quotation, display payment details, or select a period with a calendar to display.

15 is a view showing the sales status of stock products in the studio relay site manager page, the total inventory and returned product status, and details of returned and stock products that display the figures for whether it is a stock product or a returned product as a graph The displayed detail item is included.

16 is a view showing the order/production status by company in the workshop relay site manager page. Based on the data of the quotation, the type of sales product displayed in a graph by calling the data of the category, the region designated at the beginning of the customer who purchased it is called Sales area displayed in graphs, daily quotation, daily order production status with payment and unpaid details, daily workshop and sales amount, workshop and sales showing the ratio of total payment amount for products in stock and returned products of sales members Included is a sales ranking in which the ranking is displayed based on the sales amount of the member.

17 to 21 show workshop and sales member management performed on the workshop relay site manager page, permission to join workshop, permission to upload workshop and sales member page, expansion of allowed number of workshop sales members, and permission to join sales member are performed.

Permission to join the workshop is not just approval of the application for membership, but includes information on whether the necessary information for the subscription has been completely filled out and whether the monthly fee has been paid. , 1 year, etc., the discount rate is included, and the contents written when the workshop joined, the total sales amount, the monthly membership period and usage amount, etc. are included.

Permission to upload the Workshop and Sales Member page is to check whether the page has been uploaded properly or there is no illegal content.

Permission to join a sales member is displayed when a sales member requests for approval of membership, and it is set to display not only the contents of the sales member but also the contents of the workshop. .

22 to 24 show payment management performed on the workshop relay site manager page, which purchasing member received a quote from which workshop and deposited the amount, what the product is, and under what conditions the contract was made show overall.

In the case of work progress information, the corresponding content is displayed immediately whenever a workshop or sales member inputs it in the middle.

25 and 26 show the workshop manager page, and on the Home screen of the workshop manager page, the monthly total payment amount (customized product payment amount + sum of inventory/returned product sales amount), monthly production completed products (payment The total number of completed products) and the increase in orders compared to the previous month (increase/decrease in the number of orders in the current month compared to the previous month's orders) are displayed.

In addition, the monthly sales status that directly shows how much the workshop has sold through the graph is displayed so that you can select 1 month, 6 months, or 1 year, and the type of order product that shows the proportion of what products were sold in the workshop. It is displayed so that it can be selected as 1 month, 6 months or 1 year, and includes a calendar in which the part for the workshop's work schedule and the part for the class (class) progress schedule are shown in different colors, content is included.

27 is a view showing payment management performed through the workshop manager page, including new wage details displaying the contents of the new payment and the total deposit details displaying the contents of the total deposit, 1:1 chat The workshop sends the payment amount from the window, and when the purchasing member pays, the details are automatically displayed in the new wage history.

In addition, it is possible to check the payment of the sales member, and it is possible to selectively change to view only the transactions of the workshop or view only the transactions of the sales member, and the issuance of the transaction statement is displayed in a new window.

28 and 29 show returned/invented product management performed through the workshop manager page, all of the inventory/returned products posted by the workshop are displayed in the returned/invented product sales management, and information on products for sale is confirmed Product type, price, quantity sold, sale start date, sale end date, sale status and detailed view are displayed for

In order to add returned/stocked products, the page title for the product for sale, regular price, discount selling price, discount rate, insert image of the product for sale, set product category for sale, enter shipping conditions, and product details are included.

30 to 32 show the estimate management performed through the workshop manager page, you can check, transmit, and print the quotation made in the workshop, and you can check the contents of the previously created quotation together with the newly created quotation, , it is also possible to additionally create a new quotation.

At this time, if you write a quote, you need to convert the content into an image and deliver it to the purchasing member.

In the quotation management page, you can view and edit the previously created quotation, and not only the quotation of the workshop but also the quotation of the sales members belonging to the workshop are displayed.

In addition, it displays generally which buyer received a quote from which workshop and deposited the amount, what product was quoted, and under what conditions the contract was signed.

The contents to be entered for creating a quote are supported in a categorical method that is selected from preset items, and if there is any information entered during the previous workshop registration, it is automatically retrieved and entered.

The quotation form used to prepare the quotation is unified and used, and the information analysis of the estimate management can be easily performed.

As the content to be entered for the quotation, it includes the studio logo, business number, address, representative name, studio name, the time of writing the estimate (automatic input), and the signature or seal of the studio.

In addition, as the content to be entered for creating a quotation, detailed setting selection for product category, production method, dimensions, production period, wood type, finishing method, oil type, whether steel frame is used, after-sales service period, assembly method, delivery method , color, image attachment for design, product price, etc. are further included.

The prepared quotation is stored in the database of the workshop relay server, and the quotation information is accumulated and converted into big data, which can be used for trend analysis and search.

In addition, the average price of Seller member products, the average price of studio products, the production period of the Seller member products, the production period of the workshop products, the production type of the Seller member product, the production type of the workshop product, the buyer’s preferred product, and the buyer’s preferred dimension , buyer's preferred color, buyer's preferred finishing method, buyer's preferred assembly method, statistics according to transaction period, trade statistics between regions, buyer's preferred log, etc.

Therefore, although it was not possible to predict the future in the workshop before, by the estimate management according to the present invention, you can search for the desired conditions such as period, region, type, log, etc. can be referred to, and it is possible to understand the purchase pattern of buyers, so it becomes possible to reduce malicious inventory of raw materials and operate customized education programs for consumer preference products through consumer trend analysis, etc., and add the amount according to tax calculation can be checked and simplified.

When the quotation is completed, the quotation code number is automatically generated and entered in the quotation. The quotation code number is created by combining the workshop registration number - workshop area code - workshop document creation number, for example, 0001-031-0001, etc. can be created with

On the other hand, the quotation code number automatically entered in the quotation can be traced back and the content of the quotation can be traced and displayed.

* FIGS. 33 to 35 show member management performed through the workshop manager page, and through the workshop manager page, purchasing member management, general member management in the workshop, and sales member (semi-pro) management in the workshop can be simultaneously managed. .

A purchasing member is a member (buyer) who made the final payment after purchasing a product from the workshop. The data of purchasing member management is displayed when the buyer pays for and approves the customized product of the workshop, and the displayed data is the transaction date, Item, amount, customer name, phone number, product number, view details, etc.

In this case, as detailed information, the transaction details with the purchasing member are shown, and detailed information such as detailed information about the purchasing member and a review post left can be additionally checked.

A general member of the workshop is a general member of the workshop who has registered as a member on the workshop relay site. After accessing the workshop relay site, signing up as a general member, and providing the member registration ID to the workshop, the workshop displayed on the workshop manager's terminal Approval of general members in the workshop is completed by registering an ID as a workshop member on the admin page and then approval.

Data displayed for general members in the workshop include general member name, address, class type (expressed in color), period of use, membership fee, phone number, and whether or not a member is a sales member.

A sales member (semi-pro) in the workshop is a member who entered the workshop code and re-registered as a general member in the workshop. When the criteria are met and re-registration as a sales member (semi-pro), the workshop authentication key issued from the workshop relay site is given to the education member so that he or she can be converted into a sales member and registered.

If you are converted to a sales member, you can access the workshop relay site and use the sales member manager page.

The sales member manager page is displayed in the same way as the workshop manager page of FIGS. 25 and 26, and the monthly total payment amount (customized product payment amount + inventory/returned product sales amount) is also displayed on the Home screen of the sales member manager page. ), monthly production completed products (total number of products for which payment has been made), and the order growth rate compared to the previous month (increase/decrease in the number of inquiries in the current month compared to the previous month's inquiry content) are displayed.

In addition, the monthly sales status that directly shows how much the workshop has sold through the graph is displayed so that you can select 1 month, 6 months, or 1 year, and the type of order product that shows the proportion of what products were sold in the workshop. It is displayed so that it can be selected as 1 month, 6 months or 1 year, and includes a calendar in which the part for the workshop's work schedule and the part for the class (class) progress schedule are shown in different colors, content is included.

The payment management performed through the sales member manager page is displayed in the same way as the payment management performed through the workshop manager page of FIG. , The workshop sends the payment amount in the 1:1 chat window, and when the purchasing member pays, the contents are automatically shown in the new wage history.

In addition, it is possible to check the payment of the sales member, and it is possible to selectively change to view only the transactions of the workshop or view only the transactions of the sales member, and the issuance of the transaction statement is displayed in a new window.

Returned/invented product management performed through the sales member manager page is the same as the returned/invented product management performed through the workshop manager page of FIGS. 28 and 29. Everything about the product is displayed, and the product type, price, sales quantity, sales start date, sales end date, sales status and view details are displayed for checking information about the products being sold.

In order to add returned/stocked products, the page title for the product for sale, regular price, discount selling price, discount rate, insert image of the product for sale, set product category for sale, enter shipping conditions, and product details are included.

36 to 38 show the quotation management performed through the sales member manager page, and you can check, transmit, and print the quotation made in the workshop, and check the contents of the previously created quotation together with the newly created quotation. Or, you can create additional new quotations.

At this time, if you write a quote, you need to convert the content into an image and deliver it to the purchasing member.

In the quotation management page, the contents of the previously created quotation can be viewed and edited, and not only the quotation of the sales member but also the quotation of the workshop to which the sales member belongs are displayed.

In addition, it displays generally which buyer received a quote from which workshop and deposited the amount, what product was quoted, and under what conditions the contract was signed.

The contents to be entered for creating a quote are supported in a categorical method that is selected from preset items, and if there is any information entered during the previous workshop registration, it is automatically retrieved and entered.

The quotation form used to prepare the quotation is unified and used, and the information analysis of the estimate management can be easily performed.

As the content to be entered for the quotation, it includes the studio logo, business number, address, representative name, studio name, the time of writing the estimate (automatic input), and the signature or seal of the studio.

In addition, as the content to be entered for creating a quotation, detailed setting selection for product category, production method, dimensions, production period, wood type, finishing method, oil type, whether steel frame is used, after-sales service period, assembly method, delivery method , color, image attachment for design, product price, etc. are further included.

The prepared quotation is stored in the database of the workshop relay server, and the quotation information is accumulated and converted into big data, which can be used for trend analysis and search.

In addition, the average price of Seller member products, the average price of studio products, the production period of the Seller member products, the production period of the workshop products, the production type of the Seller member product, the production type of the workshop product, the buyer’s preferred product, and the buyer’s preferred dimension , buyer's preferred color, buyer's preferred finishing method, buyer's preferred assembly method, statistics according to transaction period, trade statistics between regions, buyer's preferred log, etc.

Therefore, although it was not possible to predict the future in the workshop before, by the estimate management according to the present invention, you can search for the desired conditions such as period, region, type, log, etc. can be referred to, and it is possible to understand the purchase pattern of buyers, so it becomes possible to reduce malicious inventory of raw materials and operate customized education programs for consumer preference products through consumer trend analysis, etc., and add the amount according to tax calculation can be checked and simplified.

When the quotation is completed, the quotation code number is automatically generated and entered in the quotation. The quotation code number is created by combining the workshop registration number - workshop area code - workshop document creation number, for example, 0001-031-0001, etc. can be created with

On the other hand, the quotation code number automatically entered in the quotation can be traced back and the content of the quotation can be traced and displayed.

*Member management performed through the sales member manager page is different from member management performed through the workshop manager page, as shown in FIG. 35 , only purchasing member management can be performed.

That is, the purchasing member management data is displayed when the purchasing member pays for and approves the customized product of the workshop, and the transaction date, item, amount, purchasing member name, phone number, product number, and view details are displayed. The detailed information shows the transaction history with the purchasing member, and detailed information such as detailed information about the purchasing member and a review post can be additionally checked.

Figure 39 is a processing procedure diagram for a method of managing the estimate of the workshop according to an embodiment of the present invention. Referring to FIG. 39, the estimate management method of the workshop according to an embodiment of the present invention is as follows.

First, in step S105, the first customer who has joined as a purchasing member in the first workshop among the workshops that have joined as a member in the workshop relay server 100 that operates the workshop relay site requests a quote through the customer terminal 300 . Then, in step S110 and step S115, the quotation creation screen is displayed in response to the request, but as illustrated in FIG. 32 or 38, the quotation creation screen that modularizes the content necessary for quotation and enables automatic input express To this end, the workshop manager terminal 200 delivers the screen display information to the customer terminal 300 (S110), and the customer terminal 300 displays the quotation creation screen as illustrated in FIG. 32 or 38 based on this (S110). can do.

In steps S120 and S125, the customer terminal 300 responds to the input of the selection information of the first customer, and transmits it to the workshop manager terminal 200, and in step S130, the workshop manager terminal 200 provides the selection information Create an estimate based on At this time, the customer terminal 300 may display a screen as illustrated in FIG. 38 so that the first customer can select desired information from preset items. In this way, the data can be automatically entered by modularizing the necessary items when preparing the estimate and selecting them in a categorical method.

In steps S135 to S145, the workshop manager terminal 200 converts the created quotation into an image and transmits it to the customer terminal 300 and the workshop relay server 100, and in step S150, the workshop relay server 100 is the The quotation is stored in the internal database 110 .

On the other hand, when the quotation information is requested from the workshop manager terminal 200 in step S155, in steps S160 and S165, the workshop relay server 100 searches for a pre-stored quotation and provides the result, as illustrated in FIG. 30 or FIG. It can be displayed on the same screen as shown. To this end, the workshop relay server 100 stores the information including workshop information / quotation title / item / log type / quantity / payment status / quotation code number / price field in the database 110 when storing the quotation. In response to a request for quotation information by search conditions such as period, region, type, log, etc., the corresponding quotation information is detected, and the quotation list as illustrated in FIG. 30 or 36 is provided to the workshop manager terminal 200. can Due to this, the workshop manager can grasp the purchase pattern of the buyer, and furthermore, there is an effect of predicting the future.

According to the estimate management system of the workshop of the present invention as described above, when creating an estimate in the workshop by modularizing the contents of the wood type, work date, size, product type, finishing method, assembly method, etc. required for the workshop estimate, the data is automatically entered, and the information of customers who have received orders from the workshop is converted into a DB so that information can be collected to analyze and utilize trends on customer orders. Information on the average price paid through purchase information, statistics of the region where purchases are made, age, gender, etc. can be converted into a DB, and the quotation form used in the workshop can be integrated to make it easy to DB and analyze the estimate management. It has the effect of broadening the scope of use of various information on marketing, sales, and product manufacturing through data collection.

In the above description, preferred embodiments of the present invention have been presented and described, but the present invention is not necessarily limited thereto, and those of ordinary skill in the art to which the present invention pertains within the scope not departing from the technical spirit of the present invention. It will be readily apparent that many substitutions, modifications, and alterations are possible.

On the other hand, the method according to an embodiment of the present invention for solving the above problems may be implemented as a program for executing the method in a computer and a recording medium in which the program is recorded.

Claims (7)

at least a workshop manager terminal; workshop relay site server; In the workshop estimate management system comprising a; and a sales member terminal,
The workshop relay site server,
When registering as a member of the workshop on the workshop relay site through the workshop manager terminal, the workshop authentication key is automatically generated and issued;
The workshop manager terminal,
When registering as a workshop member on the workshop relay site, you can access the workshop relay site and use the workshop manager page. The key is given to the sales member terminal,
Sales member terminal,
By receiving the workshop authentication key issued from the workshop manager terminal, you can convert from a general member to a sales member and use the sales member manager page.
Workshop estimate management system. The method according to claim 1,
The workshop manager terminal,
Based on the data of the quotation from the workshop relay site server, the type of sales product that retrieves and displays category data based on the data of the quotation, the sales region that retrieves and displays the region designated at the beginning of the purchaser, daily quotation, payment and unpaid contents are displayed. Daily order production status, sales amount that shows the ratio of total payment amount for each workshop and sales member’s inventory and returned products, and sales ranking that shows ranking based on the sales amount of workshops and sales members are included. A workshop estimate management system characterized in that it receives a workshop relay site manager page for managing the workshop relay site to be used. 3. The method according to claim 2,
The studio relay site administrator page,
Workshop estimate management system, characterized in that it is displayed including whether the purchasing member has deposited the amount after receiving a quotation from the workshop, the type of product, and the terms of the contract. The method according to claim 1,
Workshop manager terminal or sales member terminal,
Workshop estimate management system, characterized in that it is possible to check, transmit, and print the quotation made in the workshop, to check the contents of the previously created quotation together with the newly created quotation, and to additionally create a new quotation. 5. The method according to claim 4,
The contents to be entered for the quotation are supported in a categorical method selected from the preset items, and if there is any information entered during the previous workshop registration, it is automatically retrieved and entered. , business number, address, name of representative, name of workshop, when to write a quote, sign or seal of the workshop, selection of detailed settings for product category, production method, dimensions, production period, type of wood, finishing method, oil type, use of steel frame A workshop estimate management system, characterized in that it includes image attachment for availability, A/S period, assembly method, delivery method, color, and design, and product price. 5. The method according to claim 4,
Workshop estimate management system, characterized in that the created estimate is stored in the database of the workshop relay server, the estimate information is accumulated and made into big data, and is used for trend analysis and search accordingly. 5. The method according to claim 4,
When the quotation is completed, the quotation code number is automatically generated and entered in the quotation, and the quotation code number is created by combining the workshop registration number, workshop area code, and workshop document creation number.

Images