Store order management device, store order management method, and store order 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] Japanese Patent Application Laid-Open No. 2007-11813 Summary of the Invention [Problem to be solved by the invention]

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

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims 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 standardize shipping operations of suppliers. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objectives, 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 master set in association with stores and order days of the week, and the control unit includes an order acquisition means for acquiring order data set in association with ordering stores, suppliers, and order input dates, and an order date determination means for determining the order date for each order based on the store order day master and the order data.

[0007] In addition, in the store order management device of the present invention, the order date confirmation means is characterized in that it confirms, based on the order data, the order day linked to the ordering store for 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 set with an order confirmed flag that indicates whether the order has been confirmed, and the order date confirmation means further sets the order date of each order in the order data, and updates the order confirmed flag set in the order data to indicate 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, for each supplier based on the order data, order change data that is set by 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 master includes a store master that links the store and store group together, and a store group order day master that links the store group and the order day, and the order date confirmation means identifies the store group that is linked to the ordering store of each order in the store master based on the order data, and confirms the order day that is linked to the store group in the store group order day master and is 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 by the control unit to acquire order data set in association with ordering stores, suppliers, and order input dates, and an order date determination step to determine 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. [Effects 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. Furthermore, according to the present invention, it is possible to reduce the risk of inspection errors by centralizing the receiving operations at the store side. Furthermore, according to the present invention, it is possible to expect productivity improvements in companies competing for miscellaneous goods. Furthermore, according to the present invention, it is possible to improve the efficiency of ordering operations in large-scale retail companies that sell large quantities of low-priced items, including miscellaneous goods. Furthermore, according to the present invention, it is possible to consolidate orders by day of the week. [Brief explanation 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. [Figure 2] FIG. 2 is a diagram showing an example of a master configuration in this embodiment. [Figure 3] FIG. 3 is a flowchart showing an example of processing performed by the store order management device according to this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of the store order management process in this embodiment. [Figure 5] FIG. 5 is a diagram showing an example of the store order management process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the store order management process in this embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of new order data. DETAILED DESCRIPTION OF THE INVENTION

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

[0018] [1. Overview] First, an outline 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 logistics units at suppliers and warehouses became smaller, which in turn increased the number of items, significantly increasing the burden on packaging and other tasks. This led to delays in shipping, and also increased the risk of delayed or incorrect shipments for the ordering party.

[0021] Therefore, in this embodiment, a system is provided in which orders are grouped on a day of the week determined for each store, and orders are consolidated on a store-by-store basis, 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. Note that the store order management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and 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] Communication interface 104 communicatively connects store order management device 100 to network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. Communication interface 104 has a function of exchanging data with other devices via the communication line. Network 300 here has a function of connecting store order management device 100 and server 200 communicatively 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 achieve 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, etc. The storage unit 106 stores computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. 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] An example of a master configuration in this embodiment will now 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, store name, and store group code may be set in a linked relationship. Also, as shown in Fig. 2, in the store group master 106c of this embodiment, the store group code and store group name may be set in a linked relationship. 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 day of the week may be set in a linked relationship. Here, the store groups in this embodiment may be set as groups that can distribute the load by area, so that the load can be leveled for each warehouse and supplier shipping base.

[0031] 1, 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 comprehensively controls 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. Functionally, the control unit 102 conceptually includes 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 the ordering store, supplier, and order input date are linked together. 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 determining unit 102b determines the order date for each order. Here, the order date determining unit 102b may determine the order date for each order based on the store-order-day-of-week master 106a and the order data. Furthermore, the order date determining unit 102b may determine, based on the order data, the order date that is the order day associated with the ordering store for each order in the store-order-day-of-week master 106a and that is the date closest to the order input date. Furthermore, the order date determining unit 102b may set the order date for 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. Furthermore, the order date determining unit 102b may acquire order form data that associates the order date with the delivery destination, which is the ordering store, based on the order data. Furthermore, the order date determining unit 102b may acquire reorder data that associates the order date and the ordering store for each supplier, based on the order data. The order date determining unit 102b may also identify the store group associated with 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 associated with the store group in the store group order day of the week master 106d that is closest to the order input date.The order date determining unit 102b may also convert the order form data into EDI order form data that conforms to the supplier's data format, and transmit the EDI order form 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 Figure 3, the order acquisition unit 102a acquires order data that is linked to the ordering store, supplier, order input date, and an order confirmation 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, based on the order data stored in the transaction database 106e, the order date determination unit 102b identifies the store group linked to the ordering store for each order in the store master 106b, and determines the order day linked to the store group in the store group order day of the week master 106d, which is also the date closest to the order input date, as the order 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 for each supplier, linking the order date and the ordering store of each order, 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 confirmation unit 102b converts the order data stored in the transaction database 106e into EDI order data that conforms to 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 as needed.

[0045] As shown in Figure 5, in this embodiment, an order date is set in the order data entered daily at each store during nighttime processing, and the order confirmation flag is updated to TRUE. In this embodiment, the order date is the date of the next order day of the week immediately preceding the order input date. Furthermore, in this embodiment, the order day of the week is obtained by referencing the store group order day of the week master 106d from the store group code set in the store master 106b.

[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 implemented on a confirmed order date basis.

[0047] Here, an example of 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 new order data.

[0048] As shown in Figure 7, for an order to supplier SII001 with an order input date of Monday, May 8, 2023, in conventional technology, revised order data is obtained that sets shipment from supplier SII001 to three delivery destinations (Store A, Store B, and Store C) on order date Monday, May 8, 2023.However, in this embodiment, since orders are grouped on a day of the week determined for each store, revised order data is obtained separately: revised order data that sets shipment from supplier SII001 to two delivery destinations (Store A and Store C) on order date Monday, May 8, 2023, and revised order 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 the achievement of SDGs Goals 8 and 9.

[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, which can contribute to the achievement of Goal 16 of the SDGs.

[0052] 5. Other Embodiments The present invention may be implemented 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] Furthermore, 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 can be changed as desired unless otherwise specified.

[0055] Furthermore, with regard to the store order management device 100, the components shown in the drawings are functional concepts, and do not necessarily have to be physically configured as shown in the drawings.

[0056] For example, all or any part of the processing functions of the store order management device 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing 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 needed. That is, a computer program for providing 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). The computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

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

[0058] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure 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, can use well-known configurations and procedures.

[0060] The various databases 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 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 workstation, or may be configured as the information processing device connected to any peripheral device. The store order management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to perform 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

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

[0064] 100 Store order management device 102 Control section 102a Order Acquisition Department 102b Order date confirmation section 104 Communication interface unit 106 Storage section 106a Store order day master 106b Store Master 106c Store Group Master 106d Store group order day master 106e Transaction Database 108 Input / Output Interface Section 112 Input Device 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 Store order day master data linked to the store and order day of the week, Equipped with The control unit 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 the order date of each order based on the store order day master and the order data; A store order management device comprising:

2. The order date determination means 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 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 The store order management device according to claim 1 or 2, further comprising: setting the order date of each order 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 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 The store order management device according to claim 3, further comprising: acquiring, for each supplier based on the order data, reorder data that is set by linking the order date of each order and the ordering store.

6. The store order day master data includes: a store master set by linking the store and the store group, and a store group order day master set by linking the store group and the order day, The order date determination means The store order management device described in 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 master and the date closest to the order input date is confirmed as the order date.

7. The order date determination means 5. The store order management device according to claim 4, further comprising: converting the order data into EDI order data that conforms to the supplier's data format; and transmitting the EDI order data to the supplier.

8. A store order management method to be executed by a store order management device including a storage unit and a control unit, The storage unit Store order day master data linked to the store and 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 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 Store order day master data linked to the store and 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 master and the order data; A store order management program for executing the above.

Images