JP4741892B2 - Flower ordering system - Google Patents

Description

  The present invention relates to a groom ordering and ordering system in which a wholesaler who handles florets purchases products in the market and manages ordering with customers such as retailers.

  Traditionally, wholesalers such as grooms, with the permission of the market founder, participate in selling and selling seri within the market, determine the price of grooms, and buy from wholesalers. Then, the purchased florets are divided into certain units and sold to stores in the market or retailers such as local and local florists. In this way, the middle wholesaler evaluates the groom and distributes the purchased goods.

Generally, a middle wholesaler predicts customer demands and sells goods, selects products, and wholesales products purchased from the market in accordance with orders from sales outlets that are customers. When placing an order, the customer places an order specifying the production area, producer, price, quality, etc., even for the same product type. In the retail industry, it is common to use a POS system using a bar code or the like for sales management, and it is also widely used in the retail industry that handles florets.
Japanese Patent Laid-Open No. 7-37000 JP 2002-170007 A JP 2002-279116 A

  However, fresh flowers, which are living creatures, have fluctuating bid prices, and every time they purchase from the market, sales pricing work is performed, and the selling price to retailers fluctuates according to the bid price.

  On the other hand, a POS system is used for sales management at a retailer and is managed using a barcode. In general, the JAN code, which is a unified standard, is used for this bar code, but in the industry that handles raw products such as the flower industry and the fruit and vegetable industry, it is standardized for each product such as an industrial product. Using codes was impossible due to product quality variations and sorting complexity. For this reason, sales management has been carried out using in-store codes that are decided by each retail store. At this time, the retail store where the product is purchased needs to determine the selling price of the product, assign a code to be used in the POS system using barcodes to all the products, read each by a barcode reader, and register it in the product master was there. All of this work needs to be performed in a short time before the opening of the store. However, the work is cumbersome and there is a problem that registration errors occur because a large amount of registration work is performed. Furthermore, since this method refers to the unit price of the master each time scanning is performed, the burden on the computer is large. On the other hand, a method generally used in the perishable industry employs a method of directly referring to the lower-order unit price information in the in-store code without referring to the master, thereby reducing the burden on the computer. However, this method has a disadvantage that it cannot be managed individually.

  In addition, in order to arrange pots at the storefront, it is possible to sort the varieties received, create labels indicating barcodes, varieties, etc., and attach them directly to the pots or insert them in the soil part of the pots. It is done in the store. However, not all products are managed using barcodes, and it is time-consuming to create labels because the labels are printed after the products are received.

  Further, wholesalers generally sort and deliver orders from chain stores having a plurality of stores according to the assignment at the time of ordering. At this time, the mass sales stores handle a large quantity, so that they are performed at each store such as registration in the POS system and printing of labels, which is not efficient. Furthermore, the retailer has created an order list and placed an order with a wholesaler when purchasing the groom, which is a product. The order list is an assortment that takes into account sales and seasons. However, the replacement of new varieties every year is part of the products of the same period of the previous year, and the same varieties are generally prepared every year. However, it takes time to create a new order form for each order. The wholesaler who received the order also inquires about the arrival status to the market every time, and there are many exchanges with the retailer regarding the quality, the designation of the production location and producer, the price, etc. It was not good.

  In the flower industry, in order to improve business efficiency in the market, for example, a bidding system as shown in Patent Document 1 has been proposed. However, the system disclosed in Patent Document 1 is a system that allows a user to participate in a bid by confirming the product status from a remote location using a communication network or the like in a bid. The content is the same as before.

  In addition, as shown in Patent Document 2, the shipment status of fresh produce from the producer, the shipment status of the wholesaler who ships the collected agricultural product to the market, the purchase status from the auction of the wholesaler, retailer, etc. A management system is disclosed that is managed by a service center management device and records a progress state from production to customer order status. However, it does not disclose how to handle ordering operations that occur in transactions between wholesalers and retailers that handle grooms.

  The present invention has been made in view of the above-mentioned problems of the prior art, and improves the efficiency of operations from ordering to ordering between a customer who is a retailer handling florets and a wholesaler who wholesales florets to the customer. It is an object of the present invention to provide a florist ordering system that can manage florets with a POS system using a JAN code or the like.

The present invention is a system for managing a purchase operation performed between a wholesaler who wholesales florets whose prices fluctuate and a customer who sells florets, and stores customer information, merchandise information related to florets, and wholesale information An information database, a purchase order creation function for customers, a product master creation function for a POS system, and a purchase order creation function for ordering products. A wholesaler computer used by the merchant, a market terminal installed in the market, a label printing function installed at the distribution center and created from the purchase order information, and an inspection checklist creation / printing function for product delivery a center terminal comprising, consists of a customer terminal of the customer uses, the distributor computer and each terminal are connected by a communication network, the wholesale A constant wholesale price is set for each quality of the groom in accordance with a predetermined standard regardless of price fluctuations, and a code set by the wholesaler for each product based on the wholesale price and each product by the wholesaler computer Information is stored in the information database, and provided to be transmitted to each terminal via the communication network.The wholesaler computer is configured to store the information in the information database from the previous order results of the customer. An order form with a recommendation list automatically created by the wholesaler computer is added to the customer terminal through the communication network as a product list of the groom taking into account the season and quality based on past order data. provided so as to be transmitted, the customer terminal, the purchase order received, adds order information the customer at the customer terminal Te, the provided purchase orders to be sent to the distributor computer through said communication network, said distributor computer, purchase orders that have been created based on the purchase order received in the market terminal through the communication network The market terminal is provided so that it can be transmitted to the wholesaler computer as a response to an ordering response by checking the arrival status of the product in the received purchase order and registering the result. The product that has not arrived in the market according to the order reply is automatically recorded in the information database as the next ordered product, or other products of the same price in the wholesale price based on the wholesale price. The merchant computer is provided so as to be able to automatically select and send the product to the market terminal . A final purchase order created by the wholesaler together with product information related to a predetermined flower basket is provided so as to be transmitted to the center terminal, and the center terminal is ordered by the purchase order based on the received final purchase order. The necessary product information relating to the flower arrangement is automatically set and printed on the label of the order flower arrangement , the inspection checklist of the purchase order is printed, and the flower arrangement of the purchase order is sent to the customer as the label and inspection checklist. This is a flower ordering system that can be delivered together.

  The wholesaler computer is connected to the Internet as the communication means, the customer also has a customer terminal connected to the Internet, the wholesaler and the customer communicate with each other via the Internet, and the wholesaler An order from a customer is transmitted from the wholesaler computer to the market via the Internet.

  The purchase order includes a list of varieties and quantities of florets delivered to each store of the retailer that forms the chain store as the customer. Further, the merchandise master is formed by JAN code information automatically generated by the wholesaler computer using the information database.

  The confirmed purchase order transmitted by the wholesaler computer includes the product information related to the ordered flower buds, and includes information on the appearance, variety, breeding management, and retail price related to the ordered flower buds. The merchandise information is printed on a label or a merchandise display for each bridegroom based on a confirmed purchase order sent from the wholesaler computer.

  According to the flower ordering and ordering system of the present invention, since an order form reflecting the purchase results up to the previous time can be automatically created, the work of creating the order form can be labor-saving and efficient. In addition, since a uniform product master is created for each quality using the JAN code, the product management of the wholesaler can be made more efficient, and the registration work in the POS system can be saved on the customer side. is there. In addition, since a printed label such as a barcode and an inspection checklist are attached to the product at the time of shipping the product at the distribution center, it is not time-consuming for the customer to create.

  Hereinafter, an embodiment of a flower ordering / ordering system according to the present invention will be described with reference to FIGS. The flower ordering / ordering system 10 of this embodiment is used as a system for managing ordering between a flower wholesaler 12 and a customer 14 as a retailer.

  As shown in FIG. 1, the flower ordering / ordering system 10 of this embodiment is provided with a wholesaler computer 12a formed on the wholesaler 12 side so as to be connectable to a communication network 21 such as the Internet or a telephone line. Yes. In addition, an information database 12b storing customer 14 information, groom information, and wholesale information is provided, and a wholesaler computer 12a is connected to the information database 12b in a readable and writable manner. Further, for example, by using e-mail or the like, via the communication network 21, the retailer terminal 14a for the customer 14, the market terminal 16a for the market 16, and the distribution center 18 connected to the wholesaler computer 12a can be transmitted and received. Center terminals 18a are provided so as to be able to transmit and receive. Each terminal 14a, 16a, 18a is formed of a personal computer or the like. In addition, on the delivery center 18 side, a printing device 18b capable of printing a barcode or the like on a product label is connected to the center terminal 18a.

  Here, the JAN code used in the flower ordering / ordering system 10 of this embodiment will be described. In general, the product code portion constituting the JAN code distinguishes products by assigning one code to each product. For this reason, there are various types of fresh produce, such as fruits and vegetables, such as production area, producer, season / time, appearance, quality, etc. End up. In the flower ordering / ordering system 10 of this embodiment, the cost of wholesale to the retailer, which is the customer 14, is fixed based on the quality of the product and past transactions so that the fluctuation range of the bid price of the flower can be absorbed. Then, the products are classified according to quality, etc., and the product code is recorded in the information database 12b so as to correspond to the wholesale price and 1: 1 as in the case of industrial products, and further information on the place of origin, producer, season / time, etc. Is added corresponding to each wholesale price product. For this reason, when a product is specified from the wholesaler computer 12a on the operation screen, a JAN code having information matching the desired product is generated.

  Next, processing of the flower ordering / ordering system 10 of this embodiment will be described. First, as shown in FIG. 2, different processing is performed for the first transaction with the customer 14 and for the second and subsequent transactions. When the transaction with the customer 14 is the first time, as shown in FIGS. 2 and 3, the wholesaler 12 creates a new order form 20 by the wholesaler computer 12a toward the customer 14 who is a retailer. . The created order form 20 is created, for example, as an electronic file in the Excel (registered trademark) format and transmitted via the communication network 21 (s1).

  The customer 14 receives the order form 20 using the retailer terminal 14a, inputs the desired product into the order form 20 (s2), and transmits it to the wholesaler 12 as the order reply form 20a (s3). The wholesaler 12 creates a provisional purchase order 22 based on the order response form 20a received using the wholesaler computer 12a and transmits it to the market 16 (s4). In the market 16, it is checked whether or not the product in the provisional purchase order 22 received using the market terminal 16 a is received and the result is input, and the result is transmitted to the wholesaler 12 as a provisional order response 22 a (s 5 ). The wholesaler 12 takes in the provisional order reply form 22a from the market 16 and creates a provisional order reply form 24 for the customer and transmits it to the customer 14 (s6). Then, the customer 14 creates a regular order form 26 based on the received provisional order answer sheet 24 and transmits it to the wholesaler 12 (s7). As a result, the product ordered by the wholesaler 12 from the market 16 is confirmed.

  On the other hand, when the transaction with the customer 14 is the second or later transaction, as shown in FIGS. 2 and 4, a recommended list of products according to the season or the like is obtained from the transaction results accumulated in the information database 12b. Automatically generated by wholesaler computer 12a. The automatically generated recommendation list may be the same as the previous year, the average for the past years, or the quantity for the current year predicted from the fluctuations for the past years. Then, the order form 20 in which the recommendation list is described is transmitted via the communication network 21 (s8). The customer 14 receives the order form 20 using the retailer terminal 14a, and if there is a desired product in addition to the recommended list described in the order form 20, the customer 14 additionally inputs the product name and quantity, etc. Is sent to the wholesaler 12 as a provisional purchase order 22 by e-mail (s9).

  The wholesaler 12 transmits the provisional purchase order 22 received from the customer 14 to the market 16 via the communication network by the wholesaler computer 12a (s10). In the market 16, the arrival status of the product in the received provisional purchase order 22 is checked, the result is registered, and the result is transmitted to the wholesaler 12 as a provisional order response 22 a. At this time, merchandise not yet received in the market is recorded in the information database 12b by the wholesaler computer 12a as the next ordered merchandise (s11). Thus, the product to be ordered from the market 16 is confirmed. On the other hand, if the predetermined product ordered by the wholesaler 12 is not in the market 16, the product of the other producer of the same price is automatically selected by the wholesaler computer 12a based on the price, You may make it order from the market 16.

  Then, for both the first order and the second and subsequent orders, the wholesaler 12 sends a confirmed purchase order 28 to the market 16 and the distribution center 18 (s12), and the customer 14 receives the JAN code information of the newly ordered product. Is transmitted (S13). Therefore, in the case of the first transaction, the product master 30 of all the ordered products is transmitted, and only the data of the product master 30 of the new product is transmitted from the second time onward. In the market 16, the goods are moved to the distribution center 18 based on the confirmed purchase order 28 received using the market terminal 16 a. In the delivery center 18, the confirmed purchase order 28 received using the center terminal 18a is converted into an electronic file of, for example, CSV format, and taken into the printing device 12b to print a barcode, product information, etc. on an arbitrary label. Is done. In addition, an inspection checklist is created and printed in order to confirm the product and quantity when the product is delivered (s14). Then, along with the products received from the market 16, the products, the inspection checklist, and various labels are delivered to the customer 14 in accordance with the confirmed purchase order 28 (s15). The confirmed purchase order 28 describes a list of the varieties and quantities of the florets delivered to each store for the customer 14 who is a retailer forming a chain store.

  Here, the label printed at the distribution center 18 is a label wound around a stem of a fresh flower as a product, a label attached to a bowl, or the like. Further, it is preferable that the name, product type, color, other way of raising, etc. are printed on this label at the same time. Furthermore, what is called POP which displayed the information regarding goods may be created. The print information is recorded in the product master 30 corresponding to the JAN code, stored in the center terminal 18a of the distribution center 18 and printed.

  The customer 14 takes the merchandise master 30 received from the wholesaler 12 into the POS system, attaches a label attached to the delivered merchandise, and displays and sells it at the store. At the same time, the delivered purchase order 32 is sent to the wholesaler by, for example, FAX (s16). Information such as selling price and number can be added to the product master 30 at the customer 14.

  Here, the transmission of each purchase order and reply may be sent simultaneously to a plurality of locations. The confirmed purchase order 28 and the delivery master 30 are sent from the wholesaler 12 to the customer 14, the market 16, and the distribution center. 18 may be transmitted almost simultaneously.

  According to the flower ordering / ordering system 10 of this embodiment, the order form 20 including the recommended list reflecting the transaction results is automatically created in the second and subsequent orders. At this time, since it is not necessary to input the product name, the production area and the producer designation, the creation of the order form 20 can be performed efficiently. Further, the JAN code of the product most suitable for the order is automatically generated from the groom information stored in the information database 12b, and the product master 30 is created. Therefore, on the customer 14 side, after the product arrives, the customer 14 can classify, read the barcode attached to the product with a barcode reader or the like, and register it to the POS system. It is. In addition, since a printed label such as a barcode and an inspection checklist are attached to the product when the product is shipped from the delivery center 18, it does not take time to print and the work efficiency is high.

  The flower ordering / ordering system of the present invention is not limited to the above embodiment, and the communication network may be a line other than the Internet. In addition, if the information database is configured to be accessible via a network by a dedicated web server and web application, start up the terminal browser and operate from provisional order to final order via the Internet.・ By inputting, transmission / reception processing by electronic mail or the like is not necessary, so that ordering processing is more efficient and erroneous delivery does not occur.

  Further, it is possible to make an EOS (Electronic Ordering System) in conjunction with a customer's POS system, and it is possible to order a necessary quantity of the best-selling products and efficiently manage the products.

It is a block diagram which shows the structure of the flower ordering / ordering system of one Embodiment of this invention. It is a processing flowchart which shows the processing state of the flower ordering / ordering system of this embodiment. It is the schematic which shows the flow of the initial order and ordering, and goods of the flower ordering / ordering system of this embodiment. It is the schematic which shows the order of the second and subsequent orders and ordering of this embodiment, and the flow of goods.

DESCRIPTION OF SYMBOLS 10 Flower arrangement ordering system 12 Wholesaler 12a Wholesaler computer 12b Information database 14 Customer 14a Retailer terminal 16 Market 16a Market terminal 18 Distribution center 18a Center terminal

Claims (4)

A system for managing purchase operations between a wholesaler who sells flowers with fluctuating prices and a customer who sells flowers,
An information database storing customer information, merchandise information related to grooms, and wholesale information;
A purchase order creation function for a customer, a product master creation function for a POS system, and a purchase order creation function for ordering products, which can be connected to the information database in a readable and writable manner and used by the wholesaler A merchant computer;
A market terminal installed in the market;
A center terminal installed at a delivery center and having a label printing function created from the purchase order information and an inspection checklist creation / printing function for product delivery;
A customer terminal used by the customer,
The wholesaler computer and each terminal are connected by a communication network,
A constant wholesale price is set for each quality of the groom according to a predetermined standard in the wholesaler regardless of price fluctuations, and the wholesaler computer sets a code set by the wholesaler for each product based on the wholesale price. Each product information is stored in the information database and provided to be transmitted to each terminal via the communication network.
The wholesaler computer automatically creates a merchandise list of the bridegroom taking into account the season and quality based on the past order data from the customer's previous order record stored in the information database. recommended list, which was created the added purchase order, provided so as to be transmitted to the customer terminal through the communication network to,
The customer terminal is provided so that the customer can add order information at the customer terminal to the received order form, and the order form can be transmitted to the wholesaler computer through the communication network.
The wholesaler computer is provided so that a purchase order created based on the received purchase order can be transmitted to the market terminal through the communication network ,
The market terminal is provided so that it can be transmitted to the wholesaler computer as an order reply, by checking the arrival status of the product in the received purchase order and registering the result .
The wholesaler computer automatically records in the information database products that have not arrived in the market according to the order reply , or the same price in the wholesale price based on the wholesale price. In addition to the price, the product of the producer is automatically selected and transmitted to the market terminal. Further, the wholesaler computer is configured such that, based on the received purchase order , the wholesaler provides product information on a predetermined flower basket. The prepared firm purchase order is provided so that it can be sent to the center terminal,
The center terminal automatically sets the necessary product information on the groom ordered by the purchase order based on the received confirmed purchase order, prints it on the label of the order groom, and checks the inspection of the purchase order A flower ordering / ordering system characterized in that a list is printed and the flower order of the purchase order can be delivered to the customer together with the label and an inspection checklist.   2. The flower ordering order according to claim 1, wherein the order form includes a list of varieties and quantities of the florets delivered to each store of a retailer that forms the chain store as the customer. system.   2. The flower ordering / ordering system according to claim 1, wherein the product master is formed by JAN code information automatically generated by the wholesaler computer using the information database.   The confirmed purchase order transmitted by the wholesaler computer includes the product information related to the ordered flower buds, and includes information on the appearance, variety, breeding management, and retail price related to the ordered flower buds. 2. A flower ordering / ordering system according to claim 1, wherein the merchandise information is printed on a label or a merchandise display for each of the grooms according to a confirmed order book transmitted from the wholesaler computer.

Images