JP2014052773A - Information processing apparatus and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processing apparatus in which even when a commodity ordered at a net supermarket is not present in a shop, such a situation is dealt with appropriately instead of informing stockout (out of stock).SOLUTION: An information processing apparatus includes: stockout commodity determination means which refers, when a commodity code associated with a stock commodity and a commodity code of an ordered commodity stored as an ordered commodity list do not coincide with each other, to a commodity master file that stores a substitute code, which is a commodity code of a substitute commodity serving as a new selling target in place of the ordered commodity, along with commodity information associated with a commodity code of the ordered commodity, extracts an ordered commodity whose commodity code associated to a stock commodity is registered as a substitute code, and determines it as a stockout commodity; and commodity substitution means for changing a commodity code of the stockout commodity included in the ordered commodity list to a substitute code.

Description

  Embodiments described herein relate generally to an information processing apparatus and a program.

  With the spread of networks in recent years, a sales method (EC: Electronic Commerce) for selling products via the Internet is actively performed. Also, in a store such as a supermarket, a so-called “net supermarket” sales method is performed in which products sold in the store are sold via the Internet. At online supermarkets, when an order to purchase a product is received from a customer, the picking work for collecting the corresponding product from the store and the packing work for sorting the collected product for each customer are performed and delivered to each customer. Has been.

  However, according to the conventional method, there is a problem that in the picking work based on the issued picking slip, a shortage (out of stock) occurs when the product ordered at the online supermarket does not exist in the store.

  An information processing apparatus according to an embodiment is regarded as an order product code storage unit that stores, in a storage unit, a product code of an order product related to an order received from a terminal device connected via a network, as an order product list. Product code input means for inputting a product code associated with a stock product to be stored, a product code associated with the stock product, and a product of the ordered product stored as the ordered product list in the storage unit A product in which a substitute code that is a product code of a substitute product to be sold instead of the ordered product is associated with a product code of the ordered product when the respective product codes do not match with the comparison means that compares the code With reference to the product master file stored together with the information, the product code associated with the stock product is the substitute code. Extracting the registered ordered product and confirming as a missing product product means to be confirmed as a missing product, a product replacement means for changing the product code of the missing product included in the ordered product list to the replacement code, Is provided.

FIG. 1 is a system configuration diagram schematically showing the overall configuration of a sales system. FIG. 2 is a diagram illustrating an example of data stored in the product master file. FIG. 3 is a block diagram showing the configuration of the net super management server. FIG. 4 is a schematic diagram illustrating an example of an order management file. FIG. 5 is a schematic diagram showing an example of a delivery service management file. FIG. 6 is a block diagram showing the configuration of the packing device. FIG. 7 is a front view showing an example of a product purchase page. FIG. 8 is a flowchart showing the flow of picking slip issuing processing. FIG. 9 is a plan view showing an example of a picking slip. FIG. 10 is a flowchart showing the flow of the packing process and the shortage check process. FIG. 11 is a flowchart showing the flow of the merchandise replacement process. FIG. 12 is a plan view showing an example of a delivery slip.

  Hereinafter, with reference to an accompanying drawing, an information processor concerning an embodiment and an embodiment of a program are described in detail. The present invention is not limited to the embodiments described below.

  FIG. 1 is a system configuration diagram schematically showing the overall configuration of the sales system 1. As shown in FIG. 1, the sales system 1 is a store that centrally manages a plurality of POS (Point Of Sales) terminals 2 as merchandise sales data processing devices and a POS terminal 2 connected by a LAN 3. A POS system 7 including a server 4 and a headquarter server 9 connecting the store server 4 via a dedicated line 8 are provided.

  The POS system 7 and the headquarter server 9 will be briefly described. The store server 4 has a product master file MF for storing various product information (product unit price, etc.) sold in the store and is responsible for the overall control of the POS system 7, and includes a keyboard, a display device, a printer, A hard disk drive or the like is connected (not shown).

  FIG. 2 is a diagram illustrating an example of data stored in the product master file MF. As shown in FIG. 2, the product master file MF stores product information such as product names, product images, and unit prices in association with product codes such as JAN codes. In addition, the product master file MF is a substitute product for a product for which an alternative product to be picked instead of the ordered product is determined in advance when the product ordered in the picking operation at the internet supermarket described later does not exist in the store. The substitute code that is the product code is stored together with the substitute flag. If the substitution flag is “1”, the substitution code is replaced with the product code. If the substitution flag is “0”, the substitution code is not replaced.

  The POS terminal 2 is allocated at a checkout location with a unique cash register number, and is a terminal for the cashier to perform sales processing. The POS terminal 2 is connected with a keyboard, drawer, display, card reader / writer, code scanner, and the like. When the POS terminal 2 reads a product code added to each product in the form of a barcode, a two-dimensional code, or the like by a code scanner, the POS terminal 2 makes an inquiry about the product by notifying the store server 4 of the product code. The store server 4 searches the product master file MF in response to an inquiry from the POS terminal 2, reads product information corresponding to the corresponding product code, and transmits it to the POS terminal 2. The POS terminal 2 acquires the unit price of the corresponding product from the store server 4. In addition, the POS terminal 2 calculates the total amount of these products based on the unit price and the number of products to be purchased, performs a process such as payment, generates sales data, and then stores the sales data at a predetermined timing. It transmits to the store server 4.

  The headquarter server 9 includes a control unit (not shown) having a computer configuration including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like. The sales data transmitted from 4 is managed, or the product master file is transmitted to the store server 4 of each store.

  In addition, as shown in FIG. 1, the sales system 1 provides a net super service for selling products sold in a store where the POS system 7 is installed via a network 5 such as the Internet. The network super server 6 is provided. The net super server 6 can be connected from the customer terminal 10 via the Internet 5.

  The net super server 6 includes a control unit composed of a CPU, a ROM, a RAM, an input device such as a keyboard and various buttons, a display device such as a CRT and an LCD, a storage device such as an HDD and a flash memory, a dedicated line 8 and a network. 5 (not shown), and the control unit executes various programs by executing predetermined programs (for example, Web applications, database programs, etc.) stored in the storage device. Realize.

  The customer terminal 10 is a terminal device such as a personal computer (PC) or a mobile phone operated by an Internet supermarket customer (user). The customer terminal 10 can be connected to a control unit composed of a CPU, ROM, RAM, etc., an input device such as a keyboard and various buttons, a display device such as a CRT and an LCD, a storage device such as an HDD and a flash memory, and a network 5 A communication interface or the like (not shown) is provided, and various functions are realized by the control unit executing a predetermined program (for example, a Web browser) stored in the storage device.

  In addition, the store corresponds to the net super management server 11 that receives and manages the order merchandise list including the ordered merchandise received by the net super server 6 from the net super server 6 and the ordered merchandise list accepted by the net super server 6. And a packing device 12 used for packing work for sorting the products collected from the store for each customer.

  The net super management server 11 is an information processing apparatus that manages various data necessary for providing the net super service, and its electrical system is configured as shown in FIG. 2, for example.

  Here, FIG. 3 is a block diagram showing the configuration of the net super management server 11. As shown in FIG. 3, the net super management server 11 includes a control unit 31 having a computer configuration including a CPU, a ROM, a RAM, and the like, a bus 32, a first communication interface 331 connectable to the LAN 3, and a network 5. A second communication interface 332 that can be connected to the I / O device, an I / O device control unit 34, an operation input unit 35 configured by a keyboard, a mouse, and the like, a display unit 36 configured by a display device such as a CRT or LCD, A storage unit 37 configured by a storage device such as an HDD or a flash memory, and a printer connection unit 38 for connecting the printer 14 are provided.

  The control unit 31 is configured to perform online communication with the packing device 12 via the first communication interface 331 connected to the bus 32. Further, the control unit 31 is configured to be able to execute online communication with the net super server 6 via the second communication interface 332 connected to the bus 32. In addition, an operation input unit 35, a display unit 36, and a storage unit 37 are connected to the control unit 31 via a bus 32 and an I / O device control unit 34.

  The storage unit 37 stores various programs executed by the control unit 31 and various setting information related to the execution of the programs. The control unit 31 realizes various functional units in cooperation with a predetermined program stored in the storage unit 37, and executes a packing process and a missing part check process described later together with the packing device 12.

  In addition, the storage unit 37 stores an order management file 374, a delivery service management file 375, and the like as data necessary for providing the Internet super service.

  The order management file 374 is a data table for managing (holding) an order product list (described later) transmitted from the network super server 6 by the control unit 31 (order product code storage means 54). FIG. 4 is a schematic diagram illustrating an example of the order management file 374. As shown in FIG. 4, the order management file 374 holds a record in which a flight number, box number, sequence number, product code, product name, category ID, and check status are associated with each other.

  Here, the flight number is an identifier for identifying a delivery flight that delivers a product, and products having the same flight number are delivered by the same flight. The box number is an identifier for identifying a storage box that stores a product for delivery. The product purchased (ordered) by the online supermarket, that is, the product code (product name) registered in the order management file 374 is stored in the storage box indicated by the box number and delivered to the customer who placed the order. The It is assumed that a unique box number is assigned in advance to each storage box in the form of a code symbol such as a barcode or a two-dimensional code. The sequence number is a management number sequentially assigned to each product having the same flight number.

  The check status is information for indicating whether or not a packing process to be described later has been performed and a product shortage. In this embodiment, when the check status is “0”, it means that the packing process has not been processed, and when it is “1”, it means that the packing process has been processed. Further, when the check status is “9”, it means that the product is a missing item. It is assumed that the initial (default) state of the check status is “0”.

  The delivery flight management file 375 is a data table for managing the delivery date and time corresponding to each flight number. FIG. 5 is a schematic diagram showing an example of the delivery service management file 375. As shown in FIG. 5, the delivery service management file 375 holds the delivery date, delivery time, and deadline time in association with the flight number.

  The delivery date and the delivery time represent the date and time period for delivering the product. Moreover, the deadline time represents the time when the reception with the corresponding flight number is closed, and FIG. 5 shows an example in which the deadline is 3 hours before the delivery time. The control unit 31 deletes the delivery flight record whose deadline has passed from the delivery flight management file 375 based on the current date and time counted by a timekeeping unit such as an RTC (Real Time Clock) (not shown).

  Next, the packing device 12 will be described. The packing device 12 is a handy terminal or the like that can be carried by a worker who performs a packing operation (hereinafter referred to as a packing operator), and the electrical system is configured as shown in FIG. 6, for example.

  FIG. 6 is a block diagram showing a configuration of the packing device 12. As shown in FIG. 6, the packing device 12 includes a code scanner 41, an operation input unit 42, a display unit 43, a communication interface 44, a storage unit 45, a control unit 46, and the like, and each unit is connected by a bus 47.

  The code scanner 41 reads the code symbol added to the product or the storage box, and outputs the result of decoding the code symbol to the control unit 46. The operation input unit 42 includes an input device such as a keyboard, and outputs an operation signal corresponding to a user operation to the control unit 46. The display unit 43 is configured by a display device such as an LCD, and displays various types of information under the control of the control unit 46. The communication interface 44 is a wireless communication interface connectable to the LAN 3, and accesses the net super management server 11 via the access point 13 under the control of the control unit 46.

  The storage unit 45 includes a storage device such as a flash memory, and stores various programs executed by the control unit 46 and various setting information related to the execution of the programs. The control unit 46 includes a CPU, a ROM, a RAM, and the like, and implements various functional units in cooperation with predetermined programs stored in the storage unit 45. Execute product check processing.

  Here, an example of an operation until a product is purchased (ordered) at the internet supermarket will be described. First, the control unit of the customer terminal 10 (hereinafter simply referred to as the customer terminal 10) accesses the address of the EC site provided by the net super server 6 in accordance with a user operation. On the other hand, when the control unit of the net super server 6 (hereinafter simply referred to as the net super server 6) accepts access from the customer terminal 10, the EC sells products based on a program stored in a storage unit (not shown). An initial page (not shown) of the site is generated and transmitted to the customer terminal 10. The customer terminal 10 displays the initial page provided from the net super server 6 on a display unit (not shown) and waits for a user operation input.

  When the customer terminal 10 detects that a specific product category (for example, vegetable) has been selected by the user from a plurality of product categories displayed on the initial page, the customer terminal 10 determines the category name or category ID of the selected product category. Notify the net super server 6.

  On the other hand, when the net super server 6 receives the selection notification of the category name or category ID from the customer terminal 10, the net super server 6 refers to the product master file MF stored in the store server 4 and records a record corresponding to the category name or category ID. read out. And the net super server 6 will transmit to the customer terminal 10, if the goods purchase page for receiving a purchase order is produced | generated based on each read record. The customer terminal 10 displays the product purchase page provided from the net super server 6 on a display unit (not shown) and waits for a user operation input.

  FIG. 7 is a front view showing an example of a product purchase page. As shown in FIG. 7, the product purchase page displays a purchase screen G1 for purchasing the product read from the product master file MF.

  Each time the customer terminal 10 receives a press of the purchase button B1 provided on the purchase screen G1 via a keyboard, mouse, or the like (not shown), the product code, category, and purchase quantity of the corresponding product are used as purchase targets. The server 6 is notified. When the customer terminal 10 receives an instruction to the effect that the product selection has been completed via a keyboard or a mouse (not shown), the customer terminal 10 notifies the net super server 6 of the completion of the selection.

  Next, when receiving a notification of selection completion from the customer terminal 10, the net super server 6 generates a delivery date / time designation page for accepting designation of the delivery date / time and transmits it to the customer terminal 10. The customer terminal 10 displays a delivery date and time designation page (not shown) provided from the network super server 6 on a display unit (not shown) and waits for a user operation input.

  When the customer terminal 10 accepts that a specific delivery date and time has been selected on the delivery date and time designation page via a keyboard or a mouse (not shown), the customer terminal 10 notifies the network super server 6 of the selected delivery date and time.

  When the net super server 6 receives the delivery date / time notification from the customer terminal 10, the net super server 6 generates an ordered product list in which the product code of each product notified as a purchase target is associated with the flight number corresponding to the delivery date / time. To do. Thereafter, the net super server 6 transmits the ordered product list to the net super management server 11 via the Internet 5.

  Each time the control unit 31 of the net super management server 11 receives the ordered product list from the net super server 6, the order management file contains the flight number and product code included in the ordered product list in the record format shown in FIG. The data are sequentially stored in 374. The box number is assigned for each product according to the order product list and the type and quantity of the product included in the ordered product list. In addition, sequence numbers are assigned in the order of storage in the order management file 374 for the same flight number.

  A person in charge of picking work in the store of the POS system 7 (hereinafter referred to as “picking worker”) operates the net super management server 11 at a time corresponding to each flight number and responds in the order management file 374. The printer 14 issues a picking slip in which products included in the ordered product list associated with the flight number are extracted by category ID.

  Here, the picking slip issuing process in the net super management server 11 will be described. The control unit 31 of the net super management server 11 realizes various functional units (slip data generation means 51, picking slip output means 52, etc.) in cooperation with the picking slip issuing program stored in the storage portion 37, and picking. Execute slip issuing process.

  Here, FIG. 8 is a flowchart showing the flow of the picking slip issuing process. As shown in FIG. 8, the control unit 31 of the net super management server 11 operates the operation input unit 35 constituted by a picking operator such as a keyboard and a mouse, or a time measuring unit such as an RTC (Real Time Clock) not shown. When a picking slip issue instruction for a predetermined flight number is received based on the current date and time counted at (Step S1; Yes), for each product associated with the corresponding flight number in the order management file 374, a product code, The product name, product image, unit price, quantity, etc. are extracted (step S2).

  Next, the control unit 31 (slip data generation means 51) of the net super management server 11 refers to the product master file MF stored in the store server 4, and the replacement flag is “1” for each product associated with the flight number. It is determined whether or not there is a commodity registered in (Step S3).

  If it is determined that there is a product for which the substitution flag is registered as “1” (step S3; Yes), the control unit 31 (slip data generation means 51) of the net super management server 11 stores it in the store server 4. The substitute code associated with the product whose substitution flag is registered as “1” is extracted from the obtained product master file MF (step S4), and the product name, product image, Product information such as unit price is extracted from the product master file MF (step S5).

  Next, the control unit 31 (slip data generation means 51) of the net super management server 11 collects the product code, product name, product image, unit price, quantity, and the like for each product associated with the flight number in units of categories. For a product for which an alternative flag is registered, picking slip data is generated by associating the product name, product image, unit price, etc. of the product (substitute product) based on the substitute code (step S6).

  On the other hand, if it is determined that there is no product whose substitution flag is registered as “1” (step S3; No), the control unit 31 (slip data generation means 51) of the net super management server 11 sets the flight number. Picking slip data is generated by grouping the product code, product name, product image, unit price, quantity, and the like for each associated product in units of categories (step S7).

  Then, the control unit 31 (picking slip output means 52) of the net super management server 11 issues a picking slip based on the picking slip data from the printer 14 (step S8).

  FIG. 9 is a plan view showing an example of the picking slip 100. As shown in FIG. 9, the picking slip 100 is a product code, a product name, a product image, a unit price, a quantity, and the like printed in units of categories for each product associated with the corresponding flight number in the order management file 374. It is. Since the picking slip 100 is issued in units of categories as described above, products can be picked efficiently for each department.

  In addition, the picking slip 100 clearly describes that the product name, product image, unit price, etc. of the substitute product are “substitute product” for the product whose substitute flag is registered as “1”. .

  Based on the issued picking slip 100, the picking operator collects each product associated with the corresponding flight number in the order management file 374 from the store. The collected products are then transported to a backyard or the like and delivered to a packing operator.

  Then, in the picking work based on the issued picking slip 100, when the product ordered at the net supermarket does not exist in the store, the picking operator picks the alternative product written together in the picking slip 100.

  As described above, processing when the product ordered at the online supermarket does not exist in the store and the picking operator picks the alternative product written in the picking slip 100 will be described later.

  Hereinafter, with reference to FIG. 10, a packing process and a missing part check process executed in cooperation with the net super management server 11 and the packing device 12 will be described. The control unit 31 of the net super management server 11 cooperates with the packing processing program stored in the storage unit 37 to provide various functional units (ordered product code storage unit 54, product code input unit 55, comparison unit 56, missing item). A product determination unit 57, a product replacement unit 58, a slip output unit 59, etc.), and performs part of the packing process and the shortage check process.

  Here, FIG. 10 is a flowchart showing the flow of the packing process and the shortage check process executed by the cooperation of the net super management server 11 and the packing device 12. As a premise of this processing, it is assumed that a flight number related to the main packing work is input via the operation input unit 42 by a packing operator who operates the packing device 12 (step S11; Yes). Also, it is assumed that one of the products delivered from the picking operator is picked up by the packing operator and the code symbol added to the product is read by the code scanner 41 of the packing device 12.

  First, when the control unit 46 (product code input means 55) of the packing device 12 obtains the product code read by the code scanner 41 (step S12), the combination of the previously entered flight number and this product code is net superposed. The box number is inquired by notifying the management server 11 (step S13).

  When the control unit 31 (comparison unit 56) of the net super management server 11 receives the combination of the flight number and the product code from the packing device 12, it corresponds to this combination from the order management file 374 and the check status is unprocessed. A record is searched (step S31), and it is determined whether or not the corresponding record exists (step S32).

  If it is determined in step S32 that the corresponding record exists (step S32; Yes), the control unit 31 sets the box number associated with the smallest value among the sequence numbers included in each corresponding record to the packing device 12. (Step S34).

  On the other hand, when it determines with the corresponding record not existing (step S32; No), the control part 31 performs a goods alternative process (step S33).

  The commodity substitution process in step S33 will be described with reference to the flowchart of FIG. As shown in FIG. 11, the control unit 31 (out-of-stock product determination means 57) of the net super management server 11 first refers to the product master file MF of the store server 4 based on the product code scanned by the code scanner 41. The product code is registered as an alternative code (step S51), and the product included in the order product list in the order management file 374 is extracted from the extracted products and missing. An existing product is confirmed (step S52).

  Next, the control unit 31 (product replacement means 58) of the net super management server 11 changes the product code of the missing product included in the ordered product list of the order management file 374 to the replacement code (scanned product code) ( In step S53), the box number associated with the smallest value among the sequence numbers included in each record corresponding to the scanned product code is transmitted to the packing device 12 (step S54), and the process ends.

  By doing in this way, when the product ordered at the online supermarket does not exist in the store and the picking operator picks up and scans the alternative product written in the picking slip 100, the replacement product is selected at the net supermarket. Packing work can be proceeded with as an ordered product.

  Thus, the product substitution process in step S33 is completed.

  Returning to FIG. 10, when the control unit 46 of the packing device 12 receives the box number from the net super management server 11 (step S14; Yes), the value of the box number is displayed on the display unit 43 (step S16). It waits for an input from the scanner 41 (step S17; No).

  Here, the packing operator stores the obtained product in the storage box corresponding to the box number displayed in step S16, and then uses the code scanner 41 of the packing device 12 to store the box number added to the storage box. Read.

  When the box number is input via the code scanner 41 (step S17; Yes), the control unit 46 of the packing apparatus 12 transmits the box number to the net super management server 11, thereby matching the box number. Is confirmed (step S18).

  When receiving the notification of the box number from the packing device 12, the control unit 31 of the net super management server 11 determines whether or not this box number matches the box number transmitted in step S18 (step S35). Here, when it determines with it being inconsistent (step S35; No), the control part 31 transmits the message to the effect that the classification destination has an error to the packing apparatus 12 (step S36).

  If it is determined in step S35 that both box numbers match (step S35; Yes), the control unit 31 transmits a message indicating that the sorting destination is correct to the packing device 12 (step S37). When receiving the message transmitted from the net super management server 11, the control unit 46 of the packing device 12 displays this message on the display unit 43 (step S19).

  Thereby, the packing operator can easily determine whether or not the sorting has been performed correctly by checking the message displayed on the display unit 43. In the present embodiment, the net super management server 11 determines whether the box number matches, but the box number transmitted from the net super management server 11 and the box number input via the code scanner 41 , The packing device 12 itself may make a match determination.

  Subsequently, the control unit 31 of the net super management server 11 changes the check status included in the sequence number record to be processed to “1” representing processed (step S38).

  When the packing operator performs the above-described packing process for all the products delivered from the picking operator, the packing operator performs an operation for instructing that the sorting is completed via the operation input unit 42. When the control unit 46 of the packing apparatus 12 receives an instruction for completion of sorting through the operation input unit 42 (step S20; Yes), the network super management server receives the previously entered flight number and sorting completion information indicating sorting completion. 11 (step S21).

  On the other hand, when receiving the flight number and sorting completion information from the packing device 12, the control unit 31 of the net super management server 11 refers to the order management file 374 and checks the check status included in each record corresponding to this flight number. If there is one of “0” representing unprocessed (step S39; Yes), a message indicating that there is an unprocessed product (for example, a list of unprocessed products) is transmitted to the packing device 12 ( In step S40), among the check statuses included in each record corresponding to the flight number, “0” indicating unprocessed status is changed to “9” indicating shortage (step S41), and the net super management server 11 (slip output means 59) outputs a delivery slip (receipt slip) 200 shown in FIG. (Step S42), and ends the process.

  When the control unit 46 of the packing device 12 receives a message (for example, a list of unprocessed products) transmitted from the net super management server 11, the control unit 46 displays this message on the display unit 43 (step S22) and ends the process. To do.

  On the other hand, if there is no "0" indicating unprocessed (step S39; No), the control unit 31 (slip output means 59) of the net super management server 11 sends the delivery slip (shown in FIG. 12 based on the ordered product list). (Receipt slip) 200 is output from the printer 14 (step S42), and the process ends.

  When the product code of the missing product in the order management file 374 is changed to the replacement code (the product code scanned by the code scanner 41) in the product replacement process, the changed replacement product is displayed in the delivery slip (receipt slip) 200. And the information related to the product read from the product master file MF stored in the store server 4 based on the product code and the product code.

  In addition, since the product ordered at the internet supermarket is missing, a message indicating that a substitute product is to be sent may be described.

  As described above, when the code symbol added to the product picked by the packing operator is scanned (read) by the code scanner 41 of the packing device 12, the box number assigned to each customer is displayed on the packing device 12. Since the packing operator sorts each product into a storage box based on the box number displayed on the packing device 12, mistakes can be reduced and work efficiency can be improved.

  The products sorted in the storage box by the packing operator in the store serving as the delivery source in this manner are delivered to the delivery staff together with the delivery slip (receipt slip) 200 shown in FIG. Delivered. After the delivery of the product is completed, the customer's receipt signature or stamped delivery slip (receipt slip) 200 is returned to the store equipped with the POS system 7.

  Further, the store cashier reads the code symbol (including the sales price at the time of purchase at the Internet supermarket) of each product printed on the delivery slip (receipt slip) 200 returned to the store by the code scanner of the POS terminal 2. . Similarly to the normal sales process, the POS terminal 2 reads the code symbol added to each product printed on the delivery slip (receipt slip) 200 by the code scanner, and at the time of purchase at the net supermarket included in the code symbol. After calculating the total amount of these products based on the sales price and the number of products sold and generating settlement data, the sales data is transmitted to the store server 4 at a predetermined timing.

  By including the sales price at the time of purchase at the net supermarket in the code symbol of each product printed on the delivery slip (receipt slip) 200 as described above, the sales price of the real store can be obtained by the next day delivery or time service, for example. Even if they are different, sales will be recorded at the selling price when purchased at the online supermarket.

  Further, as described above, when the product ordered at the online supermarket does not exist in the store and the substitute product is picked and scanned, the product code of the missing product in the order management file 374 is changed to the substitute code. Therefore, the product printed on the delivery slip (receipt slip) 200 is a substitute product.

  As described above, according to the present embodiment, when the product code associated with the stock product scanned by the code scanner 41 and the product code of the ordered product stored as the ordered product list do not match, Instead, by referring to the product master file MF that stores the substitute code, which is the product code of the substitute product to be sold, together with the product information associated with the product code of the ordered product, the product code associated with the stock product is Ordered products registered as replacement codes are extracted, confirmed as missing products, and the product codes of missing products included in the ordered product list are changed to alternative codes. Even if it does not exist in the store, it can be dealt with without running out of stock (out of stock).

  Further, according to the present embodiment, with respect to an order product having an alternative code associated with the product code with reference to the product master file MF, the product information about the alternative product based on the alternative code and the product about the ordered product Since the picking slip 100 including information is printed out from the printer, the picking worker is written in the picking slip 100 when the product ordered at the net supermarket does not exist in the store in the picking work based on the picking slip. Working efficiency can be improved by picking alternative products.

  The embodiment of the present invention has been described above, but the present invention is not limited to this, and various modifications, substitutions, additions, and the like are possible without departing from the spirit of the present invention.

  Moreover, in the said embodiment, although the net super server 6 was set as the form arrange | positioned outside a shop, it is good also as a form arrange | positioned not only in this but in a store. Further, the net super management server 11 and the store server 4 may have a function of the net super server 6.

  In the above embodiment, the product code and the box number are held in the code symbol. However, the present invention is not limited to this, and may be held in the form of an RFID tag or the like. In this case, the packing apparatus 12 includes an RFID reader / writer instead of the code scanner 41.

  The program executed by each device of the above embodiment may be configured to be provided by being incorporated in advance in a ROM or the like. The program may be provided by being recorded in a computer-readable recording medium such as a CD-ROM, a flexible disk (FD), a CD-R, or a DVD in an installable or executable format file. Good.

  Further, the program may be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network. Further, the program may be provided or distributed via a network such as the Internet.

  Although several embodiments of the present invention have been described, these embodiments are presented by way of example and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and the equivalents thereof.

DESCRIPTION OF SYMBOLS 10 Terminal device 11 Information processing apparatus 51 Voucher data generation means 52 Picking slip output means 54 Order product code storage means 55 Product code input means 56 Comparison means 57 Missing goods confirmation means 58 Commodity substitution means 59 Voucher output means 374 Storage section

JP 2011-164775 A

Claims (6)

An order product code storage means for storing a product code of an order product related to an order received from a terminal device connected via a network as an order product list in a storage unit;
Product code input means for inputting a product code associated with a stock product considered as the ordered product;
Comparison means for comparing the product code associated with the stock product with the product code of the ordered product stored as the ordered product list in the storage unit;
If the product codes do not match, refer to the product master file that stores the substitute code, which is the product code of the substitute product to be sold instead of the ordered product, together with the product information associated with the product code of the ordered product And a missing product confirmation means for extracting the ordered product in which the product code associated with the stock product is registered as the substitute code, and confirming the product as a missing product,
Product replacement means for changing the product code of the missing product included in the ordered product list to the replacement code;
An information processing apparatus comprising: A slip output unit that outputs a slip printed with the product information read from the product master file based on the replacement code of the replacement product changed by the product replacement unit;
The information processing apparatus according to claim 1. Refer to a product master file that stores a substitute code that is a product code of a substitute product to be sold instead of the ordered product together with product information associated with the product code of the ordered product, and is associated with the product code. For the ordered product with the substitute code, slip data that includes product information about the substitute product based on the substitute code and product information about the ordered product, and generates picking slip data to be used for picking the ordered product Generating means;
Picking slip output means for printing out a picking slip based on the picking slip data from a printer;
The information processing apparatus according to claim 1, further comprising: Computer
An order product code storage means for storing a product code of an order product related to an order received from a terminal device connected via a network as an order product list in a storage unit;
Product code input means for inputting a product code associated with a stock product considered as the ordered product;
Comparison means for comparing the product code associated with the stock product with the product code of the ordered product stored as the ordered product list in the storage unit;
If the product codes do not match, refer to the product master file that stores the substitute code, which is the product code of the substitute product to be sold instead of the ordered product, together with the product information associated with the product code of the ordered product And a missing product confirmation means for extracting the ordered product in which the product code associated with the stock product is registered as the substitute code, and confirming the product as a missing product,
Product replacement means for changing the product code of the missing product included in the ordered product list to the replacement code;
Program to function as. Causing the computer to further function as slip output means for outputting a slip printed with the product information read from the product master file based on the replacement code of the replacement product changed by the product replacement means;
The program according to claim 4. Refer to a product master file that stores a substitute code that is a product code of a substitute product to be sold instead of the ordered product together with product information associated with the product code of the ordered product, and is associated with the product code. For the ordered product with the substitute code, slip data that includes product information about the substitute product based on the substitute code and product information about the ordered product, and generates picking slip data to be used for picking the ordered product Generating means;
Picking slip output means for printing out a picking slip based on the picking slip data from a printer;
The program according to claim 4 or 5, further causing the computer to function as:

Images