JP4504028B2 - Online building materials order processing equipment - Google Patents

Description

The present invention is an online building material ordering process that enables online, integrated, efficient execution of building material quotation creation, ordering, and delivery in transactions such as those performed between building material manufacturers and customers. Relates to the device.

  Building material manufacturers do daily transactions with many customers, including distributors such as wholesalers and construction companies such as construction companies, but the types and sizes of building materials, delivery dates, delivery locations, etc. Since orders are specified in various combinations and conditions, the creation of purchase orders on the customer side and the creation of quotations at building material manufacturers are complicated and time-consuming tasks. For example, the customer confirms the type, dimensions, and construction method for all necessary building materials, and specifies and orders the size, quantity, construction method, delivery date, and delivery location for each type, and the building material manufacturer that received the order. On the side, it is necessary to secure the necessary quantity of building materials of the type specified by the customer, and if necessary, cut out the building materials with the specified dimensions and deliver them to the designated construction site on the designated date. I had to estimate costs, work days, delivery methods, and so on.

  In addition, an ordering system that can order building materials online has been used in the past. However, since the system simply handles ordering, customers who wish to place an order first refer to the product catalog information and select the product (building material). ), And it was necessary to take out the construction drawings of the product from the collection of construction drawings and create the ordering data. The ordering data created in this way was sent online to the building material manufacturer, and the building material manufacturer made an estimate based on it and delivered it to the customer's commercial flow, that is, to the supplier's distributor or contractor. . Since distributors or contractors placed orders based on the estimate, troubles in delivery due to lack of contact were constantly occurring.

In the conventional online ordering system related to building materials, practically only order processing is handled, so that information is not sufficiently utilized, and the following problems occur.
(1) Even if the customer enters the ordering data on the online terminal and sends it to the building material manufacturer, it is often a long time to wait until the estimate is returned. It was late.
(2) Since there is no use of information between customers, even if there are similar transactions by other customers in the past, customers must create completely new ordering data, and building material manufacturers must repeatedly create estimates of the same content. The efficiency of the system was poor.
(3) When a large number of products are ordered with the details in one ordering slip, the delivery date is determined according to the product with the latest delivery date in the slip. Therefore, if the customer wants to ship from a product in stock, it is only possible to create and send an order slip for each line, or place orders at once, and then request distribution by telephone to the supplier. Since the supplier has to correct his / her slip, the online order was ruined and the efficiency was poor.
(4) The most important thing in sales of building materials is how to bring the goods to the construction site where the situation changes one after another. Therefore, the person in charge at the retail store creates a management table for each site of the contractor who is the customer, writes the delivery date from the manufacturer or wholesaler and the scheduled delivery date for each item (floor material, joinery, etc.) I had to do complicated management.
(5) The window frame depends on the size of the sash, that is, it differs depending on the sash manufacturer. Conventionally, the window frame is usually delivered as a long product and processed on-site. However, in recent years, part of the sash frame that has been pre-cut (a window frame that has been cut to a predetermined size) has been commercialized, prompted by cost reductions due to shortening of the construction period and problems of garbage. It was not enough to meet the needs of customers who wanted free dimensions.
(6) Counters are often manufactured with special specifications such as shape and dimensions. For this reason, there has been a mechanism for building materials manufacturers to process and deliver materials according to the customer's wishes, but the ordering method is to create a purchase order by writing the necessary items on the order form specified by the manufacturer, It was a method of sending by FAX. However, because faxes of purchase orders are repeatedly sent from the contractor to the retail stores, wholesalers, etc. in the commercial flow, the purchase orders become more difficult to see or the order is delayed, causing problems with fax orders. It was seen.

The object of the present invention is to enable the customer himself / herself to easily create an estimate with a small work load in the online building material ordering / processing apparatus, shortening the period until the estimate and delivery, as well as special orders and emergency orders. The goal is to meet the diverse needs of customers and to enable efficient and error-free delivery management.

In order to solve the above-mentioned problems, the present invention provides an online building material ordering and processing apparatus that enables a customer himself / herself to directly create estimate data online. For this reason, the host can calculate the delivery date and design price on the spot and return in real time to the estimate setting items entered by the customer on the terminal, giving accurate information to the customer and speeding up the creation of estimate data. Like that. In this way, it is possible for the customer to delete a lot of intermediate work that has been required in the past by creating the estimate data by himself, and the customer has long spent to know the delivery date and the design price. Efficiency such as no waiting time is required.

In particular, the present invention manages the estimate data and order data together with the product information in a database, and opens not only the product information but also the estimate data of the commercial flow related to the customer to the customer, so that the customer can easily refer to them. Enable creation of quotation data and ordering data.
The online building material order processing apparatus according to the present invention can be configured as follows.
(1) An online building material ordering / processing apparatus having a program processing means and a data file storage device and coupled to an ordering terminal via a network,
Inventory product data file storing inventory product data provided in the data file storage device;
Estimated data file that is provided in the data file storage device and manages the estimated data with items including at least items, quantity, estimated customers, commercial customers of estimated customers, construction methods, using the estimated number as a key,
A delivery schedule file for each item that is provided in the data file storage device and manages the delivery schedule using the customer, construction method, and item as keys,
An order data file that is provided in the data file storage device and manages the estimated data already ordered as order data ;
In response to an inquiry request from the customer of the terminal, the inventory product data is extracted from the inventory product data file of the data file storage device , or the estimate data is extracted from the estimate data file of the data file storage device and transmitted to the terminal. Estimate ordering program processing means for generating estimate data and ordering processing,
A delivery management program processing means for automatically setting and distributing and managing delivery items and delivery schedules for each customer and construction method for the estimate data stored in the estimate data file of the data file storage device;
In response to an estimate data inquiry request from a customer of a terminal, an estimate data browsing program processing means for retrieving and responding to estimate data of the customer himself / herself and a commercial customer related to the customer from the estimate data file of the data file storage device When,
A configuration of an online building material ordering and processing apparatus characterized by comprising:

FIG. 1 shows the basic configuration of an on-line building material order processing apparatus according to the present invention by an exemplary method.

In FIG. 1, a host (or server) 1 of a building material manufacturer includes an order information database 3 stored in a file storage device 2, an estimated order / order program processing means 4 and a delivery management program, each function realized by a program. A processing means 5 is provided and connected to the terminals 7-1, 7-2, and 7 -n via the network 6 so that ordering processing can be performed. For example, the terminal 7-1 is from a manufacturer sales office, the terminal 7-2 is from a distributor, and the terminal 7-n is from a contractor.

  The order information database 3 stores inventory data of commodities such as building materials, and estimate data and order data of each customer created so far.

The estimated ordering program processing means 4 retrieves the inventory product data in the ordering information database 3 and the estimated data of the related commercial flow in response to the inquiry request from the terminals 7-1, 7-2, 7-n, and The process presented in. The customer creates estimated data with reference to the presented inventory product data and commercial flow estimated data, and transmits it to the host 1. The estimated ordering program processing means 4 confirms the estimated data received from the terminal, stores it in the ordering information database 3, waits for an ordering instruction from the terminal, and confirms the ordering process using the estimated data as the ordering data. The order data is stored in the order information database 3.

Delivery management program processing unit 5, the order data stored in the ordering information database 3, by customer, by delivery region, and managing for reference by delivery, delivery and delivery items contained in the further order data For the scheduled date , processing is performed by sorting and managing by customer, construction method, and construction site, and processing is performed in response to the delivery status inquiry in comparison with the shipping record data indicating the shipping status.

By adopting the online building material order processing system of the present invention, the order processing of goods is remarkably efficient, the service is improved, the time required for ordering is shortened, and the delivery date can be advanced. In addition, since ordering and delivery management are performed in an integrated manner, ordering and delivery can be checked easily and mistakes can be reduced.

A preferred embodiment in which the online building material ordering and processing apparatus according to the present invention is applied to building material transactions will be described with reference to FIGS.

FIG. 2 is a system configuration diagram, in which 1 is a host, 6 is a network, 7-1 and 7-n are customer terminals, 11 is a CPU, 12 is a main storage device such as SDRAM, and 13 is a file storage such as HDD. 14 is a display control interface, 15 is a display device, 16 is a communication control interface such as a modem or LAN, and 17 is a printer. The functions of the online building material order processing apparatus according to the present invention are implemented by 18 order processing programs and 19 order information database.

The order processing program 18 includes a dialogue control program 20, an estimate creation program 21, an inventory product presentation program 22, an estimate data browsing program 23, and a delivery management program 24. The order information database 19 includes an inventory product data file 25, an estimate data file 26, and an order data file 27.
In the system shown in FIG. 2, the hardware configuration of the host 1 constituting the building material order receiving / processing apparatus of the present invention will be briefly described.
The basic hardware configuration of the host 1 is the same as that of a general computer. Under the control of the OS, an interactive control program 20 for an application loaded in the main storage device 12, an estimate creation program 21, Each command of the ordering / ordering processing program 18 including the inventory product presentation program 22, the estimate data browsing program 23, the delivery management program 24, and the like is executed by the CPU 11, thereby realizing a data processing function possessed by each application. . The stock product data file 25 processed by the application, the estimate data file 26, the order data file 27, and the like are stored in the file storage device 13 as the order information database 19, and are accessed by the application as necessary. File processing such as update and deletion is performed.

The host 1 includes a display control interface 14, a display device 15, and a printer 17 as a man-machine interface with an operator, as well as a mouse and a keyboard (not shown). In addition, a communication control interface 16 is provided to communicate with the customer's stationary terminal 7-1 and portable terminal 7-n via the network 6.
Next, the operation of the system will be described. The dialogue control program 20 controls the advancement of the corresponding processing in cooperation with the programs 20 to 24 in response to commands such as inventory product inquiry requests, estimate data browsing requests, and orders from the terminals 7-1 and 7-n. Do.

  The estimate creation program 21 can be operated from the terminals 7-1 and 7-n, and assists the customer in creating estimate data by himself / herself online. Prepare multiple types of quotation data creation patterns or templates in advance, and select the type of quotation data you want to create, for example, select the product as it is, specify precuts in the submenu, or freely set dimensions and processing conditions in the free plan The appropriate pattern can be selected from the menu. Data is set in each input item of a pattern (template). For example, the customer inputs and sets the item, quantity, amount, delivery date, delivery location, merchandise supplier (for example, wholesaler name), etc., in the estimate data. For example, when entering a product item, display a list of products in the pull-down menu and click on a product, or enter the code number (product number) assigned to each product directly, There is a method of reading the code with a barcode reader. The quantity is keyed in or selected from a pull-down menu list. Settings such as dimensions for free plan estimates are also keyed. The estimate creation program 21 checks these setting values, sets necessary additional items such as a delivery method, delivery costs, and consumption tax, calculates a delivery date, completes estimate data, and performs a client terminal in real time. To return to the screen.

  Further, when placing an order cut for a window frame, the estimate creating program 21 prepares a plan menu for “order cut by part”, and selects and orders from a plurality of plans when placing an order. Two types are available: “Order” and “Free Plan” for ordering while setting processing dimensions and processing conditions on the spot.

  Furthermore, the estimate creation program 21 prepares a special estimate creation wizard for ordering a custom counter. A custom counter estimate creation wizard screen and a customer operation example will be described with reference to FIGS.

  FIG. 7 shows a menu screen, in which the customer touches (or clicks) the label 31 of the “collection custom order counter”. Next, the “Counter shape list” screen of FIG. 8 is displayed. Touch the desired counter shape type to select it. Here, a label 32 of type T09 (JL-R type) is selected. Next, the screen shifts to the “Select Grade / Color / Thickness” screen of FIG. Here, the desired material type, color, and thickness of the counter are selected by touching the label 33 or the like. In the example shown in the figure, the grade is “Oak”, the color is “CB Center Brown”, and the thickness is “38 mm”. Next, the screen moves to the “shape designation” screen of FIG. Here, dimensions (W, L) and a curved surface (R) are set in the input fields 34 and 35, and a chamfering position indicated by a dotted line is input. Next, the screen shifts to a “chamfer shape designation” screen of FIG. Here, a chamfered shape label of a desired cross section is touched and selected. Here, the “both round surfaces” label 36 is selected. Next, the “shape confirmation” screen of FIG. 12 is displayed. Here, it is possible to confirm the set value that has been selected or input and designated so far, and touch the “print” label to print the contents, or touch “sume” to go to the “order” screen in FIG. . In the “order” screen of FIG. 13, the design price calculated by the estimate creation program 21 is displayed together with the set counter product number, quantity, product name and design specifications. Here, when the customer further inputs and sets the delivery location “site” and the desired delivery date “not rare”, the estimate creation program 21 determines the delivery destination “destination”, calculates the delivery date “delivery date”, and displays each screen. Is displayed in the display field 38. After confirming the delivery date and touching the “Confirm” button in the lower right corner, the order is confirmed with the estimated data on the screen. This estimate data created by the terminal is managed in the database in the same manner as the estimate data created by the building material manufacturer.

  The inventory merchandise presentation program 22 searches the inventory merchandise data file 25 in the ordering information database 19 in response to an inventory merchandise inquiry request from the terminal, and presents information on the inquired merchandise. The process of answering the availability, quantity, and delivery date of the inventory is performed. The inquiry of the inventory product is performed by specifying the product number. First, the presence / absence and quantity of the product, the delivery date, the product photo, and the like are transmitted to the terminal. If the customer wants to know further details of the product, it is only necessary to touch a predetermined chip or photograph on the screen of the terminal, and the stock product presentation program 22 responds to the specification (size, shape, Detailed information such as features) and construction materials are output to the screen.

  In addition, when dealing with wooden building materials, the distinctive grain of wood is a matter that requires great care. This problem is especially seen in Japanese-style new building materials. For example, even a pine floorboard shows a completely different texture depending on the color shade (red and white) of the wood and the clogging (interval) of the grain. For this reason, for example, in the case of additional orders, products are divided and managed with a certain color and eye spacing so that the texture is similar to the one ordered earlier, and the color trends may differ depending on the region. By deciding the color to be shipped depending on the region and the alternative when there is no stock, complaints about color differences due to additional orders can be reduced. The substitute product information is set for each necessary product in the inventory product data file 25 of the order information database 19. For example, for a color substitute, a file having a list of colors that can be substituted for basic colors is created in advance. However, in general, link information may be added between products that can be substituted.

FIG. 3 is an example of a flow of processing executed by the inventory product presentation program 22 to automatically select an alternative for the color of the floorboard. First , a customer performs an estimate slip creation operation at a certain terminal (7-1, 7-n), and inquires of the host 1 whether a desired delivery date is possible for a certain product. The inventory product presentation program 22 of the host 1 calculates the delivery date of the product by a normal method. When the delivery date is as desired, the delivery date of the regular product is returned to the customer's terminal, and the process proceeds to the ordering process. If the delivery date does not satisfy the request, the substitute product delivery date calculation process is entered to check whether there is a substitute product. If there are no alternatives that can be proposed, answer the delivery date of the previous normal product , and if an appropriate alternative is found, create a replacement candidate list consisting of the alternative product name and the alternative product delivery date, Send to customer's terminal. The customer selects an appropriate substitute item from the substitute item candidate list and shifts to the ordering process.

  FIG. 4 is a detailed flow of the substitute product delivery date calculation process of FIG. 3 executed by the inventory product presentation program 22. An alternative color file is created in advance. The alternative color file can refer to data of the corresponding basic color and alternative color 1, 2, 3,. In the flow of FIG. 3, if the normal product of the basic color fails to meet the delivery date, the product of the first alternative color 1 is referred to by referring to the alternative color file shown in the figure based on the product number (original product number) of the normal color and the information of the providing area , And calculate the arrival date and time of delivery to the place of delivery by regular delivery flights. If it is earlier than the delivery date of the normal product, it is registered in the alternative product candidate list, and it is later than the delivery date of the regular product. For example, the product number is generated for the next alternative color 2, and the arrival date and time is calculated in the same manner. This process is repeated for the number of alternative colors in the list to complete the alternative candidate list.

  FIG. 5 is a flowchart of a delivery date calculation process that considers the delivery method so that the arrival time can be clearly shown in an emergency or the like executed by the inventory product presentation program 22. In the building materials industry, which is highly dependent on the traditional commercial flow, improving delivery efficiency is an important issue involving process management at the construction site. Generally, two to three relays are required before a product arrives at a construction shop (construction site) where the product is an end user. The main flow is from the manufacturer to the wholesaler, then from the wholesaler to the retail store, and then from the retail store to the construction site. At this time, since the arrival time of the product is not fixed, the cargo to be sent to the retail store after delivery from the wholesaler to the retail store arrives. There are various kinds of waste, such as being in a situation where there is no, or waiting for the arrival of one product, delaying all delivery and even affecting the on-site process. Therefore, when an order is received online from a customer, processing is automatically performed on the spot, not only the delivery date but also the arrival time. At the stage of receiving the order, the delivery destination is grasped, and a predetermined delivery time is selected and displayed from the routing of delivery. The time display is in units of one hour, which helps to improve the delivery efficiency of the entire distribution. The customer can inquire about the delivery date for delivery on regular flights while creating a voucher for an estimate. If the requested delivery date is not obtained, the customer can switch to the delivery date inquiry for delivery on emergency flights and get the desired arrival date and time. Such an appropriate delivery method can be selected. For this reason, an emergency flight arrival date calculation process is provided in addition to the normal flight delivery date calculation process. In the normal flight delivery date calculation process, the stock date, estimated storage file, and production plan file are used to estimate the expected arrival date when the product is out of stock. Using the data and the data on the number of delivery days from the base to the customer and the arrival time, the delivery date and time for the delivery by the normal flight is calculated. In the emergency flight arrival date calculation process, possible delivery means, delivery date, and fare candidates are obtained and presented from an emergency flight pattern file that records the delivery means and delivery route patterns used in the case of emergency flights.

  Returning to FIG. 2, the estimate data browsing program 23 publishes the estimate data file 26 stored in the ordering information database 19 to the customer's commercial flow and responds to the browsing request.

  The delivery management program 24 moves the estimated data file 26 subjected to the ordering process to the ordering data file 27 and manages the execution of the ordering and delivery so that delivery mistakes such as delivery date errors do not occur.

For this reason, as shown in Fig. 6, an estimate finding file, an estimate details file, and a delivery schedule file for each item are created, and delivery items and delivery schedules (schedules) are automatically set for each customer and each construction method (construction method). And distribute and manage .

In the delivery schedule file by item, for example, (1) XX construction company is (2) If it is a conventional construction method, the first delivery will be floor materials and staircase materials 10 days after the upper building date, the second delivery will be frame material It is set to be performed 17 days after the upper building date with the joinery . Then, at the site registered as the conventional construction method of the XX construction shop, the order is placed on the desired delivery date for each item according to the rule calculated from the inputted upper building date. At the site where the order is placed here, it is possible to refer to the contents of the estimate finding file and the estimate detail file and perform site management and check for omissions in the order. In addition, it is possible to provide a function for sorting and managing ordering data for each site such as a subdivision and listing the sites of registered construction companies.

1 is a basic configuration diagram of an online building material order processing apparatus according to the present invention. 1 is a system configuration diagram of an embodiment of an online building material order receiving / processing apparatus according to the present invention. FIG. It is a flowchart of the process which selects automatically the alternative of the color of a floor board. It is a detailed flowchart of an alternative product delivery date calculation process. It is a flowchart of the delivery date calculation process which can specify arrival time. It is a flowchart of the process which sets automatically the delivery item and a delivery schedule (schedule) according to a customer and construction method, and distributes and manages. It is explanatory drawing of a menu screen. It is explanatory drawing of the "counter shape list" screen for custom-order counter ordering. It is explanatory drawing of the "material type, color, thickness selection" screen for ordering a custom counter. It is explanatory drawing of the "shape specification" screen for ordering a custom counter. It is explanatory drawing of the "specify chamfer shape" screen for ordering a custom-made counter. It is explanatory drawing of the "shape confirmation" screen for custom-order counter ordering. It is explanatory drawing of the "order" screen for custom order counter ordering.

Explanation of symbols

1: host 2: file storage device 3: ordering information database 4: estimate ordering program processing means 5: delivery management program processing means 6: network 7-1, 7-2, 7-n: terminal

Claims (1)

An online building material ordering and processing apparatus having a program processing means and a data file storage device and connected to a terminal on the ordering side via a network,
Inventory product data file storing inventory product data provided in the data file storage device;
Estimated data is provided in the data file storage device, using the quotation number as a key, and at least items, quantities, quotation creation customers, commercial customers with business relations such as quotation creation customers and suppliers, and items including construction methods An estimate data file to manage,
A delivery schedule file for each item that is provided in the data file storage device and manages the delivery schedule using the customer, construction method, and item as keys,
An order data file that is provided in the data file storage device and manages the estimated data already ordered as order data;
In response to an inquiry request from the customer of the terminal, the inventory product data is extracted from the inventory product data file of the data file storage device, or the estimate data is extracted from the estimate data file of the data file storage device and transmitted to the terminal. Estimate ordering program processing means for generating estimate data and ordering processing,
A delivery management program processing means for automatically setting and distributing and managing delivery items and delivery schedules for each customer and construction method for the estimate data stored in the estimate data file of the data file storage device;
Depending on the estimated data query request from the terminal of the customer, the estimate data file of the data file storage device, searches the customer quotation data commercial distribution in the business relationship, such as the customer's own and customer and vendor, An estimate data browsing program processing means to reply;
An on-line building material order processing apparatus characterized by comprising:

Images