Store order placement management apparatus, store order placement management method, and store order placement management program

Abstract

To provide a store order placement management apparatus, a store order placement management method, and a store order placement management program configured so that each store places orders collectively on a day of the week specified for each store, thereby improving efficiency and equalization in shipping operations of suppliers.SOLUTION: A store order placement management apparatus is configured to: acquire order placement data set in association with an ordering store, a supplier and an order input date; and fix a date of order for each order on the basis of the order placement data and a store order day-of-week master set in association with the store and the day of the week of the order.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a store order management device, a store order management method, and a store order management program. [Background technology]

[0002] Patent Document 1 discloses a configuration in which the usage status of consumables is calculated for each day of the week, and ordering processing is executed in consideration of the usage status. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2007-11813 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in Patent Document 1 above has a problem in that if there are daily orders from each store, packaging and shipping to all stores is required every day, resulting in extremely high logistics costs.

[0005] The present invention has been made in consideration of the above-mentioned problems, and has as its object to provide a store order management device, a store order management method, and a store order management program that can consolidate orders on a specific day of the week for each store, solidify orders on a store-by-store basis, and improve the efficiency and standardization of suppliers' shipping operations. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the store order management device of the present invention is a store order management device equipped with a memory unit and a control unit, wherein the memory unit includes a store order day of the week master set in association with a store and an order day of the week, and the control unit includes an order acquisition means for acquiring order data set in association with an ordering store, a supplier, and an order input date, and an order date determination means for determining the order date of each order based on the store order day of the week master and the order data.

[0007] In addition, in the store order management device of the present invention, the order date confirmation means confirms, based on the order data, the order day linked to the ordering store of each order in the store order day of the week master, and the date closest to the order input date, as the order date.

[0008] In addition, in the store order management device of the present invention, the order data is further linked to an order confirmed flag indicating whether the order has been confirmed or not, and the order date confirmation means further sets the order date of each of the orders in the order data, and updates and sets the order confirmed flag set in the order data to a state indicating that the order has been confirmed.

[0009] In addition, in the store order management device of the present invention, the order date confirmation means is further characterized in that it acquires order form data that is linked to the order date and the delivery destination, which is the ordering store, based on the order data.

[0010] In addition, in the store order management device of the present invention, the order date confirmation means is further characterized in that it acquires reorder data that is set for each supplier based on the order data, linking the order date of each order and the ordering store.

[0011] In addition, in the store order management device of the present invention, the store order day of the week master includes a store master set in linkage with the store and store group, and a store group order day of the week master set in linkage with the store group and the order day of the week, and the order date confirmation means identifies the store group linked to the ordering store of each order in the store master based on the order data, and confirms the order day of the week linked to the store group in the store group order day of the week master and the date closest to the order input date as the order date.

[0012] In addition, in the store order management device of the present invention, the order date confirmation means is further characterized in that it converts the order form data into EDI order form data that is compatible with the supplier's data format and transmits the EDI order form data to the supplier.

[0013] Furthermore, the store order management method of the present invention is a store order management method to be executed by a store order management device having a memory unit and a control unit, wherein the memory unit has a store order day of the week master set in association with stores and order days of the week, and the method includes an order acquisition step executed in the control unit for acquiring order data set in association with ordering stores, suppliers, and order input dates, and an order date determination step for determining the order date for each order based on the store order day of the week master and the order data.

[0014] In addition, the store order management program of the present invention is a store order management program to be executed by a store order management device having a memory unit and a control unit, wherein the memory unit has a store order day of the week master set in association with stores and order days of the week, and the control unit executes an order acquisition step of acquiring order data set in association with ordering stores, suppliers, and order input dates, and an order date determination step of determining the order date for each order based on the store order day of the week master and the order data. Effect of the Invention

[0015] According to the present invention, by leveling out store orders through distribution, it is possible to reduce and level out the shipping workload of suppliers and warehouses. Also, according to the present invention, it is possible to reduce the risk of inspection errors by performing the receiving operations at the store side in a centralized manner. Also, according to the present invention, it is possible to expect productivity improvement in companies in a business format that competes for miscellaneous goods. Also, according to the present invention, it is possible to improve the efficiency of ordering operations in a business format that sells low-priced items such as miscellaneous goods in large quantities and in large-scale retail companies. Also, according to the present invention, it is possible to consolidate orders by day of the week. [Brief description of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a store order management device according to this embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of a master configuration in this embodiment. [Diagram 3] FIG. 3 is a flowchart showing an example of a process performed by the store order management device in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of a store order management process in this embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of a store order management process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a store order management process in this embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of the new order data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0018] [1. Overview] First, an overview of the present invention will be described.

[0019] In the retail industry, due to the nature of the business, orders for a wide variety of products in large quantities are placed by stores all over the country.

[0020] Previously, purchase orders were sent to suppliers each time an order was placed, and the goods were shipped each time. This meant that the number of items increased at suppliers and warehouses as the logistics units became smaller, significantly increasing the burden of packaging and other tasks. As a result, shipping operations were delayed, and the ordering party also faced a higher risk of delayed or incorrect arrival of goods.

[0021] Therefore, in this embodiment, a mechanism is provided in which orders are grouped together on a day of the week determined for each store, and orders are consolidated by store, allowing the ordering side to control the granularity of orders.

[0022] [2. Configuration] An example of the configuration of a store order management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a store order management device 100 according to this embodiment.

[0023] 1, the store order management device 100 is a commercially available desktop personal computer. The store order management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0024] The store order management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units included in the store order management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0025] The communication interface unit 104 communicatively connects the store order management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the store order management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0026] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0027] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes a store order day of the week master 106a and a transaction database 106e.

[0028] The store order day of the week master 106a is a master that associates stores with order days of the week. Here, the store order day of the week master 106a may include a store master 106b that associates stores with store groups, a store group master 106c that associates store groups, and a store group order day of the week master 106d that associates store groups with order days of the week.

[0029] Here, an example of a master configuration in this embodiment will be described with reference to Fig. 2. Fig. 2 is a diagram showing an example of a master configuration in this embodiment.

[0030] As shown in Fig. 2, in the store master 106b of this embodiment, the store code, the store name, and the store group code may be set in a linked manner. Also, as shown in Fig. 2, in the store group master 106c of this embodiment, the store group code and the store group name may be set in a linked manner. Also, as shown in Fig. 2, in the store group order day of the week master 106d of this embodiment, the store group code and the day of the week may be set in a linked manner. Here, the store groups in this embodiment may be set to be groups that can distribute the load by area, so that the load can be leveled for each warehouse and each shipping base of the supplier.

[0031] 1, the transaction database 106e stores transaction data, which may include order data, purchase order data, order change data, EDI purchase order data, and the like.

[0032] The control unit 102 is a CPU or the like that performs overall control of the store order management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. Conceptually, the control unit 102 is equipped with an order acquisition unit 102a and an order date determination unit 102b.

[0033] The order acquisition unit 102a acquires order data in which a supplier is set. Here, the order acquisition unit 102a may acquire order data in which an ordering store, a supplier, and an order input date are linked to each other. In addition, the order data may be linked to an order confirmation flag indicating whether the order has been confirmed or not.

[0034] The order date determination unit 102b determines the order date of each order. Here, the order date determination unit 102b may determine the order date of each order based on the store order day of the week master 106a and the order data. Also, the order date determination unit 102b may determine, based on the order data, the order day associated with the order store of each order in the store order day of the week master 106a and the date closest to the order input date as the order date. Also, the order date determination unit 102b may set the order date of each order in the order data and update the order confirmation flag set in the order data to indicate that the order has been confirmed. Also, the order date determination unit 102b may acquire purchase order data that is set by linking the order date and the delivery destination that is the ordering store, based on the order data. Also, the order date determination unit 102b may acquire reorder data that is set by linking the order date of each order and the ordering store, based on the order data. The order date determining unit 102b may also identify a store group linked to the ordering store of each order in the store master 106b based on the order data, and determine as the order date the order day linked to the store group in the store group order day of the week master 106d and the date closest to the order input date.The order date determining unit 102b may also convert the order data into EDI order data compatible with the supplier's data format, and transmit the EDI order data to the supplier.

[0035] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0036] [Store order management processing] An example of store order management processing in this embodiment will now be described with reference to Fig. 3. Fig. 3 is a flowchart showing an example of processing by the store order management device 100 in this embodiment.

[0037] As shown in FIG. 3, the order acquisition unit 102a acquires order data that is linked to the ordering store, supplier, order input date, and an order confirmed flag indicating whether the order has been confirmed, based on order input by a user at each ordering store, and registers the order data in the transaction database 106e (step SA-1).

[0038] Then, the order date determination unit 102b identifies the store group linked to the ordering store of each order in the store master 106b based on the order data stored in the transaction database 106e, and determines as the order date the order day linked to the store group in the store group order day of the week master 106d that is also the date closest to the order input date (step SA-2).

[0039] Then, the order date confirmation unit 102b sets the order date of each order in the order data stored in the transaction database 106e, and updates the order confirmation flag set in the order data to indicate that the order has been confirmed (step SA-3).

[0040] Then, the order date determination unit 102b acquires new order data that is set by linking the order date and the ordering store of each order for each supplier based on the order data stored in the transaction database 106e (step SA-4).

[0041] Then, the order date determination unit 102b acquires order form data that is linked to the order date and the delivery destination, which is the ordering store, based on the order data stored in the transaction database 106e, and registers the order form data in the transaction database 106e (step SA-5).

[0042] Then, the order date determination unit 102b converts the order data stored in the transaction database 106e into EDI order data that is compatible with the supplier's data format, and transmits the EDI order data to the supplier (step SA-6), thereby completing the process.

[0043] An example of the store order management process in this embodiment will now be described with reference to Figures 4 to 7. Figures 4 to 6 are diagrams showing an example of the store order management process in this embodiment.

[0044] As shown in FIG. 4, in this embodiment, orders are input at each store at any time.

[0045] As shown in Fig. 5, in this embodiment, an order date is set in the order data input daily by each store during night processing, and the order confirmation flag is updated to TRUE. Here, in this embodiment, the next order day of the week date closest to the order input date is acquired as the order date. Also, in this embodiment, the order day of the week is acquired by referring to the store group code set in the store master 106b and the store group order day of the week master 106d.

[0046] As shown in FIG. 6, in this embodiment, only orders that have been confirmed in the order confirmation process are considered, and purchase orders are issued and EDI linkage is performed on a confirmed order date basis.

[0047] Here, an example of a comparison between this embodiment and the prior art will be described with reference to Fig. 7. Fig. 7 is a diagram showing an example of order change data.

[0048] As shown in Figure 7, with respect to an order to supplier SII001 with an order input date of Monday, May 8, 2023, in conventional technology, order change data is obtained that sets shipment from supplier SII001 to three delivery destinations (Store A, Store B, Store C) on order date: Monday, May 8, 2023. However, in this embodiment, since orders are consolidated on a day of the week determined for each store, the order change data is obtained separately: order change data that sets shipment from supplier SII001 to two delivery destinations (Store A, Store C) on order date: Monday, May 8, 2023, and order change data that sets shipment from supplier SII001 to one delivery destination (Store B) on order date: Tuesday, May 9, 2023.

[0049] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0050] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0051] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0052] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0053] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0054] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0055] Moreover, with regard to store order management device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.

[0056] For example, the processing functions of the store order management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the store order management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0057] In addition, this computer program may be stored in an application program server connected to the store order management device 100 via any network, and it is also possible to download all or part of it as needed.

[0058] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0059] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0060] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0061] The store order management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The store order management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processes described in this embodiment.

[0062] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0063] INDUSTRIAL APPLICABILITY The present invention is useful in industries such as large and medium-sized retail companies that sell low-priced items, including general merchandise, in large quantities. [Explanation of symbols]

[0064] 100 Store order management device 102 Control section 102a Order Acquisition Department 102b Order date confirmation section 104 Communication interface section 106 Storage section 106a Store order day master 106b Store master 106c Store group master 106d Store group order day master 106e Trade Database 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A store order management device including a storage unit and a control unit, The storage unit is Store order day master data that is linked to the store and the order day of the week, Equipped with The control unit is An order acquisition means for acquiring order data that is set by linking an ordering store, a supplier, and an order input date; an order date determination means for determining an order date for each order based on the store order day of the week master and the order data; A store order management device comprising:

2. The order date determination means is The store order management device according to claim 1, characterized in that, based on the order data, the order day linked to the ordering store of each order in the store order day of the week master and the date closest to the order input date is determined as the order date.

3. The order data is Furthermore, an order confirmation flag indicating whether the order has been confirmed or not is set in association with the order. The order date determination means is 3. The store order management device according to claim 1, further comprising: setting the order date of each of the orders in the order data; and updating the order confirmation flag set in the order data to indicate that the order has been confirmed.

4. The order date determination means is 4. The store order management device according to claim 3, further acquiring order form data that is set by linking the order date and the delivery destination that is the ordering store, based on the order data.

5. The order date determination means is 4. The store order management device according to claim 3, further comprising: a step of acquiring, for each of said suppliers, reorder data set in association with said order date and said ordering store based on said order data.

6. The store order day of the week master data includes: A store master set by linking the store and the store group, and a store group order day of the week master set by linking the store group and the order day of the week, The order date determination means is The store order management device according to claim 2, characterized in that, based on the order data, the store group linked to the ordering store of each order in the store master is identified, and the order day linked to the store group in the store group order day of the week master and the date closest to the order input date is confirmed as the order date.

7. The order date determination means is 5. The store order management device according to claim 4, further comprising: converting said order data into EDI order data conforming to a data format of said supplier; and transmitting said EDI order data to said supplier.

8. A store order management method to be executed by a store order management device having a storage unit and a control unit, The storage unit is Store order day master data that is linked to the store and the order day of the week, Equipped with Executed in the control unit: an order acquisition step for acquiring order data that is set by linking an ordering store, a supplier, and an order input date; an order date determination step of determining an order date for each order based on the store order day of the week master and the order data; A store order management method comprising:

9. A store order management program to be executed by a store order management device having a storage unit and a control unit, The storage unit is Store order day master data that is linked to the store and the order day of the week, Equipped with In the control unit, an order acquisition step for acquiring order data that is set by linking an ordering store, a supplier, and an order input date; an order date determination step of determining an order date for each order based on the store order day of the week master and the order data; A store order management program for executing the above.

Images