Store customer order management device, store customer order management method, and store customer order management program
The store customer order management device and method address inventory management challenges by linking inventory data across locations, ensuring accurate inventory tracking and allocation, thus reducing discrepancies and enhancing customer satisfaction.
Patent Information
- Application Number
- JP2022202613
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-12-19
- Publication Date
- 2025-10-07
- Estimated Expiration
- 2042-12-19
AI Technical Summary
Existing inventory management systems fail to accurately manage inventory status after a customer order is placed, leading to discrepancies in inventory updates and inaccurate journal entries, especially when items are shipped out or received.
A store customer order management device and method that tracks inventory data by linking products, storage locations, current quantities, allocated quantities, and movement/shipping quantities, allowing real-time management of inventory allocation and updates based on customer orders, including transfer and receipt of goods.
Enables detailed inventory management, ensuring accurate accounting by recording consignment items and allowing inventory allocation across locations, reducing discrepancies and improving customer satisfaction through timely inventory management.
Smart Images

Figure 0007750821000001 
Figure 0007750821000002 
Figure 0007750821000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to a store customer order management device, a store customer order management method, and a store customer order management program. [Background technology]
[0002] Patent document 1 discloses a configuration in which, when a customer order is placed at a store, an inventory database is searched for stock at the inventory storage location, and if there is stock, a shipping instruction is sent to the inventory storage location and the inventory database is updated. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Publication No. 8-147374 Summary of the Invention [Problem to be solved by the invention]
[0004] However, in the invention described in Patent Document 1, inventory updates to the inventory database are only performed after an order for shipping is received, which means that detailed inventory status cannot be managed after a customer order is placed, when the inventory is shipped out, when the inventory is received, etc., and there is a problem in that accurate journal entries cannot be created.
[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a store customer order management device, a store customer order management method, and a store customer order management program that can manage the detailed status of inventory items sent from the inventory storage location to the store when a store is out of stock and a customer order occurs. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the store customer order management device of the present invention is a store customer order management device comprising a memory unit and a control unit, wherein the memory unit comprises inventory storage means for storing inventory data that is set by linking together products, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and moving / shipping quantities, and the control unit identifies the inventory data in which an available allocation storage location is set to allocate the requested products based on a purchase request that sets a requested product and a requested quantity from a customer as available allocation inventory data, and identifies the requested product, the available allocation storage location, and ... The system is characterized by comprising a store customer order acquisition means for acquiring store customer order data set in association with the store and the requested quantity, an inventory allocation means for updating the available stock data based on the store customer order data, a transfer acquisition means for acquiring transfer data of the requested goods from the available storage location to the requesting store and updating the available stock data based on the transfer data, and a transfer receiving means for updating the available stock data based on the transferred and received quantity of the requested goods when the requested goods are transferred and received from the available storage location to the requesting store.
[0007] In addition, in the store customer order management device of the present invention, the inventory allocation means updates the available inventory data by adding the requested quantity to the allocated quantity set in the available inventory data based on the store customer order data, and subtracting the requested quantity from the available inventory data.
[0008] In addition, in the store customer order management device of the present invention, the movement acquisition means acquires the movement data that sets the movement / shipping quantity of the requested product from the allocable storage location to the requesting store, and based on the movement data, updates the allocable inventory data by subtracting the movement / shipping quantity from the allocated quantity set in the allocable inventory data and adding the movement / shipping quantity to the movement / shipping quantity.
[0009] In addition, in the store customer order management device of the present invention, the moving and receiving means is characterized in that when the requested product is moved and received from the available storage location to the requesting store, the moving and receiving quantity is updated based on the moved and received quantity of the requested product by subtracting the moved and received quantity from the moved and shipped quantity set in the available inventory data.
[0010] In addition, in the store customer order management device of the present invention, the moving and receiving means is further characterized by additionally registering in the inventory storage means the requested store inventory data that is set by linking the requested product, the storage location that is the requesting store, and the current inventory quantity that is the moving and receiving quantity.
[0011] In addition, in the store customer order management device according to the present invention, the allocation-enabled storage location is an allocation-enabled store.
[0012] In addition, in the store customer order management device of the present invention, the available storage location is an available warehouse, and the inventory allocation means is further characterized in that it acquires order data that is set by linking the requesting store, the available warehouse, the requested product, and the requested quantity based on the store customer order data.
[0013] In addition, in the store customer order management device of the present invention, the control unit is characterized by further comprising a shipping instruction means for notifying the allocable warehouse of shipping instruction data for the requested quantity of the requested product from the allocable warehouse to the requesting store based on the order data.
[0014] In addition, in the store customer order management device of the present invention, the movement acquisition means acquires shipping data that sets the quantity of the requested product to be moved and shipped from the allocable warehouse to the requesting store based on the shipping instruction data, and updates the allocable inventory data by subtracting the moved and shipped quantity from the allocated quantity set in the allocable inventory data based on the shipping data and adding the moved and shipped quantity to the moved and shipped quantity.
[0015] The store customer order management method according to the present invention is a store customer order management method to be executed by a store customer order management device having a memory unit and a control unit, wherein the memory unit has an inventory storage means for storing inventory data that is set by linking together products, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and moving / shipping quantities, and the control unit executes the inventory storage means to identify, as available inventory data, the inventory data in which an available allocation storage location is set that can allocate the requested products based on a purchase request that is set for a requested product and a requested quantity from a customer, and to identify the requested product, the available allocation storage location, and the requested store. and a store customer order acquisition step for acquiring store customer order data set by linking the requested quantity to the store, an inventory allocation step for updating the available stock data based on the store customer order data, a transfer acquisition step for acquiring transfer data of the requested goods from the available storage location to the requesting store and updating the available stock data based on the transfer data, and a transfer and storage step for updating the available stock data based on the transferred and stored quantity of the requested goods when the requested goods are transferred and stored from the available storage location to the requesting store.
[0016] The store customer order management program according to the present invention is a store customer order management program to be executed by a store customer order management device having a memory unit and a control unit, wherein the memory unit has an inventory storage means for storing inventory data that is set by linking together products, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and moving / shipping quantities, and the control unit identifies the inventory data in which an available allocation storage location that can allocate the requested products is set as available allocation inventory data based on a purchase request that sets a requested product and requested quantity from a customer, and identifies the requested product, the available allocation storage location, and the requested store as available allocation inventory data. and a store customer order acquisition step for acquiring store customer order data linked to the requested quantity, an inventory allocation step for updating the available stock data based on the store customer order data, a transfer acquisition step for acquiring transfer data of the requested goods from the available storage location to the requesting store and updating the available stock data based on the transfer data, and a transfer receipt step for updating the available stock data based on the transferred stock quantity of the requested goods when the requested goods are transferred and received from the available storage location to the requesting store. [Effects of the Invention]
[0017] According to the present invention, since the status of customer orders can be managed in detail, assets that are not physically available in the store can be recorded using a "consignment" account or the like, thereby achieving the effect of managing product inventory at each location without discrepancies in accounting. Furthermore, according to the present invention, when a customer order is placed at a store and the store does not have the item in stock, the inventory status at other stores or warehouses can be checked, and if there is stock, a request to order the item to secure the inventory at that location can be registered, and shipping can be performed in conjunction with the request. Furthermore, according to the present invention, when the order is registered, inventory is allocated, enabling management to reduce the available allocation quantity (available shipment quantity). [Brief explanation of the drawings]
[0018] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a store customer order management device according to this embodiment. [Figure 2] FIG. 2 is a flowchart showing an example of the processing of the store customer order management device in this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of store customer order management processing in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of store customer order management processing in this embodiment. [Figure 5] FIG. 5 is a diagram showing an example of store customer order management processing in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of store customer order management processing in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of store customer order management processing in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of store customer order management processing in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of store customer order management processing in this embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0019] 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.
[0020] [1. Overview] First, an outline of the present invention will be described.
[0021] Previously, if an item was out of stock at the time of a customer order but was available at another store or warehouse, they would communicate over the phone and register the shipment as soon as the sender was ready. This meant that the inventory appeared to be in stock on the system until the registration was made, and the sender's system registration also had to be done from scratch, which could lead to mistakes.
[0022] Therefore, in this embodiment, a system is provided that secures inventory in real time, leading to improved customer satisfaction in terms of speed and reliability.
[0023] [2. Configuration] An example of the configuration of a store customer 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 customer order management device 100 according to this embodiment.
[0024] 1, the store customer order management device 100 is a commercially available desktop personal computer. Note that the store customer order management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.
[0025] The store customer order management device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the store customer order management device 100 is connected to each other so that they can communicate with each other via any communication path.
[0026] The communication interface unit 104 communicatively connects the store customer 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 exchanging data with other devices via the communication line. Here, the network 300 has a function of connecting the store customer 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).
[0027] 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.
[0028] 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 an inventory database 106a.
[0029] The inventory database 106a stores inventory data for each storage location. The inventory database 106a may store inventory data linking items, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and quantities to be transferred and shipped. The inventory database 106a may also store available inventory data, store customer order data, item transfer data, requesting store inventory data, order data, shipping instruction data, and / or shipping data. The store customer order data may include the requested item, slip number, available allocation storage location, requesting store, customer order date, and / or requested quantity. The transfer data may include the slip number, shipper, ship destination, transfer date, transferred item, and / or transferred quantity. The order data may include the slip number, shipper, ship destination, order date, ordered item, and / or ordered quantity. The shipping instruction data may include the slip number, shipper, ship destination, shipping instruction date, shipped item, and / or shipped quantity. The shipping data may also include a slip number, a shipping origin, a shipping destination, a shipping date, a shipped product, and / or a shipping quantity.
[0030] The control unit 102 is a CPU or the like that comprehensively controls the store customer 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 a store customer order acquisition unit 102a, an inventory allocation unit 102b, a shipping instruction unit 102c, a movement acquisition unit 102d, and a movement and storage unit 102e.
[0031] The store customer order acquisition unit 102a identifies inventory data in which an available allocation storage location for the requested product is set as available inventory data, and acquires store customer order data that is set by linking the requested product, the available allocation storage location, the requesting store, and the requested quantity. Here, the store customer order acquisition unit 102a may identify inventory data in which an available allocation storage location for the requested product is set as available inventory data, based on a purchase request from a customer in which the requested product and the requested quantity are set, and acquire store customer order data that is set by linking the requested product, the available allocation storage location, the requesting store, and the requested quantity. Here, the available allocation storage location may be an available allocation store. Alternatively, the available allocation storage location may be an available allocation warehouse.
[0032] The inventory allocation unit 102b updates the available inventory data based on the store customer order data. Here, the inventory allocation unit 102b may update the available inventory data by adding the requested quantity to the allocated quantity set in the available inventory data based on the store customer order data and subtracting the requested quantity from the available allocation quantity. Furthermore, the inventory allocation unit 102b may acquire order data that links the requesting store, available allocation warehouse, requested product, and requested quantity based on the store customer order data.
[0033] The shipping instruction unit 102c acquires shipping instruction data for the requested quantity of the requested product from the requesting store. Here, the shipping instruction unit 102c may notify the allocable warehouse of the shipping instruction data for the requested quantity of the requested product from the allocable warehouse to the requesting store based on the order data.
[0034] The movement acquisition unit 102d updates the allocable inventory data based on movement data of the requested items from the allocation-enabled storage location to the requesting store. Here, the movement acquisition unit 102d may acquire movement data of the requested items from the allocation-enabled storage location to the requesting store and update the allocable inventory data based on the movement data. Alternatively, the movement acquisition unit 102d may acquire movement data that sets the outgoing quantity of the requested items to be moved from the allocation-enabled storage location to the requesting store, and update the allocable inventory data based on the movement data by subtracting the outgoing quantity from the allocated quantity set in the allocable inventory data and adding the outgoing quantity to the moving and transporting quantity. Alternatively, the movement acquisition unit 102d may acquire shipping data that sets the outgoing quantity of the requested items to be moved from the allocation-enabled warehouse to the requesting store based on the shipping instruction data, and update the allocable inventory data by subtracting the outgoing quantity from the allocated quantity set in the allocation-enabled inventory data and adding the outgoing quantity to the moving and transporting quantity based on the shipping data.
[0035] The transferring and receiving unit 102e updates the allocable inventory data based on the transferred and received quantity of the requested product. Here, when the requested product is transferred and received from an allocation-enabled storage location to the requesting store, the transferring and receiving unit 102e may update the allocable inventory data based on the transferred and received quantity of the requested product. Furthermore, when the requested product is transferred and received from an allocation-enabled storage location to the requesting store, the transferring and receiving unit 102e may update the allocable inventory data based on the transferred and received quantity of the requested product by subtracting the transferred and received quantity from the transferred and received quantity set in the allocable inventory data. Furthermore, the transferring and receiving unit 102e may additionally register, in the inventory database 106a, requesting store inventory data set by linking the requested product, the storage location that is the requesting store, and the current inventory quantity that is the transferred and received quantity.
[0036] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.
[0037] [Store customer order management processing] An example of store customer order management processing in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a flowchart showing an example of processing by the store customer order management device 100 in this embodiment.
[0038] As shown in FIG. 2, the store customer order acquisition unit 102a identifies, based on a purchase request from a customer at a requesting store that sets the requested product and requested quantity, inventory data registered in the inventory database 106a in which an available storage location for allocating the requested product is set as available inventory data, and acquires store customer order data that is set by linking the requested product, the available storage location, the requesting store, and the requested quantity (step SA-1).
[0039] Then, the inventory allocation unit 102b determines whether the available allocation storage location set in the store customer order data is an available allocation store or an available allocation warehouse (step SA-2).
[0040] Then, when the inventory allocation unit 102b determines that the storage location available for allocation is an available store (step SA-2: store), it shifts the process to step SA-3.
[0041] Then, based on the store customer order data, the inventory allocation unit 102b adds the requested quantity to the allocated quantity set in the available inventory data registered in the inventory database 106a, and subtracts the requested quantity from the available inventory data, thereby updating the available inventory data registered in the inventory database 106a (step SA-3).
[0042] Then, the movement acquisition unit 102d acquires store movement data that sets the quantity of the requested product to be moved and shipped from the available store to the requesting store, and updates the available stock data based on the store movement data by subtracting the quantity to be moved and shipped from the allocated quantity set in the available stock data and adding the quantity to be moved and shipped to the quantity to be moved (step SA-4).
[0043] When the requested product is transferred from the available store to the requesting store, the transfer and receiving unit 102e updates the available stock data registered in the inventory database 106a by subtracting the transferred and received quantity from the transferred and shipped quantity set in the available stock data registered in the inventory database 106a based on the transferred and received quantity of the requested product, and adds the requested store stock data set by linking the requested product, the storage location of the requesting store, and the current stock quantity which is the transferred and received quantity to the inventory database 106a (step SA-5), thereby completing the processing.
[0044] On the other hand, if the inventory allocation unit 102b determines that the available allocation storage location is an available allocation warehouse (step SA-2: warehouse), it shifts the process to step SA-6.
[0045] Then, the inventory allocation unit 102b acquires order data that links the requested store, available allocation warehouse, requested product, and requested quantity based on the store customer order data, and updates the available allocation inventory data registered in the inventory database 106a by adding the requested quantity to the allocated quantity set in the available allocation inventory data registered in the inventory database 106a and subtracting the requested quantity from the available allocation quantity (step SA-6).
[0046] Then, the shipping instruction unit 102c notifies the allocable warehouse of shipping instruction data for the requested quantity of the requested product from the allocable warehouse to the requesting store based on the order data (step SA-7).
[0047] Then, the movement acquisition unit 102d acquires shipping data that sets the quantity of the requested product to be moved and shipped from the allocable warehouse to the requesting store based on the shipping instruction data, and updates the allocable inventory data registered in the inventory database 106a by subtracting the quantity to be moved and shipped from the allocated quantity set in the allocable inventory data based on the shipping data and adding the quantity to be moved and shipped to the quantity to be moved and shipped (step SA-8).
[0048] When the requested product is transferred from the available warehouse to the requested store, the transfer and receiving unit 102e updates the available inventory data registered in the inventory database 106a by subtracting the transferred and received quantity from the transferred and shipped quantity set in the available inventory data registered in the inventory database 106a based on the transferred and received quantity of the requested product, and adds the requested store inventory data set by linking the requested product, the storage location of the requested store, and the current inventory quantity which is the transferred and received quantity to the inventory database 106a (step SA-9), thereby completing the processing.
[0049] An example of store customer order management processing in this embodiment will now be described with reference to Figures 3 to 9. Figures 3 to 9 are diagrams showing an example of store customer order management processing in this embodiment.
[0050] [Ordering from other stores] As shown in Figure 3, in this embodiment, a customer places an order for one T-shirt at the Ginza store, but since the store does not have it in stock, the store checks stock at other stores and warehouses, and since the Shibuya store has it in stock, the store contacts the Shibuya store, and after confirming that there is no problem, the request is registered for the Shibuya store. Here, as shown in Figure 3, in this embodiment, inventory is allocated at the time the customer order is registered at the Ginza store, ensuring that the inventory is secured.
[0051] In this embodiment, a shipping slip for transfer to the Ginza store is registered, linked to the customer order slip at the Ginza store, as shown in Fig. 4. In this embodiment, as shown in Fig. 4, the Shibuya store transfers the item by linking it to the customer order slip, and the current inventory quantity and the allocated quantity are reduced to become the transfer shipment quantity.
[0052] Then, as shown in FIG. 5, in this embodiment, the transfer input (transfer and storage) is finally performed at the Ginza store, and the process is completed.
[0053] [Warehouse Pickup Processing] As shown in Figure 6, in this embodiment, a customer places an order for one T-shirt at the Ginza store, but the store does not have the item in stock, so the store checks inventory at other stores and warehouses, and since the item is in stock at the central warehouse, the request is registered with the central warehouse. Here, as shown in Figure 6, in this embodiment, when a customer places an order with a warehouse, order data that leads to shipping instructions to the warehouse is generated when the customer order is registered. Also, as shown in Figure 6, in this embodiment, inventory is allocated at the time the customer order is registered at the Ginza store, ensuring that inventory is secured.
[0054] In this embodiment, as shown in FIG. 7, shipping instructions are input at the head office or warehouse, and as shown in FIG. 8, shipping instructions are input at the warehouse at the time of warehouse shipping.
[0055] Then, as shown in FIG. 9, in this embodiment, the arrival entry is finally performed at the Ginza store, and the process is completed.
[0056] [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.
[0057] 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.
[0058] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.
[0059] 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.
[0060] 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.
[0061] 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.
[0062] Furthermore, with regard to the store customer order management device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.
[0063] For example, all or any part of the processing functions of the store customer 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 stored 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 customer order management device 100 as needed. That is, a computer program is stored in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. The computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.
[0064] In addition, this computer program may be stored in an application program server connected to the store customer order management device 100 via any network, and all or part of it may be downloaded as needed.
[0065] 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.
[0066] 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.
[0067] 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.
[0068] The store customer 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 an information processing device connected to any peripheral device. The store customer order management device 100 may also be implemented by installing software (including programs or data) that causes the device to perform the processes described in this embodiment.
[0069] 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]
[0070] The present invention is useful in industries such as the distribution and retail industry, including companies that operate stores for home appliances or apparel. [Explanation of symbols]
[0071] 100 Store customer order management device 102 Control section 102a Store Customer Order Acquisition Department 102b Inventory Allocation Department 102c Shipping Instructions 102d Movement acquisition part 102e Mobile storage section 104 Communication interface unit 106 Storage section 106a Inventory Database 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network
Claims
1. A store customer order management device having a memory unit and a control unit, The storage unit inventory storage means for storing inventory data that is set by linking together products, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and moving / shipping quantities; Equipped with The control unit a store customer order acquisition means for identifying the inventory data in which an available storage location for allocating the requested product is set based on a purchase request in which a requested product and a requested quantity are set from a customer as available inventory data, and acquiring store customer order data that is set by linking the requested product, the available storage location, the requesting store, and the requested quantity; an inventory allocation means for updating the available inventory data based on the store customer order data; a movement acquisition means for acquiring movement data of the requested product from the allocation-available storage location to the requesting store, and updating the allocation-available inventory data based on the movement data; a transfer and receiving means for updating the allocable inventory data based on the transferred and received quantity of the requested goods when the requested goods are transferred and received from the allocation-available storage location to the requesting store; A store customer order management device comprising:
2. The inventory allocation means A store customer order management device as described in claim 1, characterized in that the available inventory data is updated by adding the requested quantity to the allocated quantity set in the available inventory data based on the store customer order data and subtracting the requested quantity from the available inventory data.
3. The movement acquisition means The store customer order management device of claim 2, characterized in that the transfer data, which sets the transfer / shipment quantity of the requested product from the allocation-available storage location to the requesting store, is acquired, and the transfer / shipment quantity is subtracted from the allocated quantity set in the allocation-available inventory data based on the transfer data, and the transfer / shipment quantity is added to the transfer / shipment quantity, thereby updating the allocation-available inventory data.
4. The moving and storing means is The store customer order management device of claim 3, characterized in that when the requested product is moved and stored from the available storage location to the requesting store, the available inventory data is updated by subtracting the moved and stored quantity from the moved and shipped quantity set in the available inventory data based on the moved and stored quantity of the requested product.
5. The moving and storing means is The store customer order management device of claim 4 further registers in the inventory storage means inventory data for the requested store that is linked to the requested product, the storage location of the requested store, and the current inventory quantity, which is the transferred inventory quantity.
6. The available storage location is:
6. The store customer order management device according to claim 1, wherein the store is an allocation-enabled store.
7. The available storage location is: It is an available warehouse, The inventory allocation means The store customer order management device described in claim 2 further acquires order data that links the requesting store, the available warehouse, the requested product, and the requested quantity based on the store customer order data.
8. The control unit a shipping instruction means for notifying the allocable warehouse of shipping instruction data for the requested product in the requested quantity from the allocable warehouse to the requesting store based on the order data; 8. The store customer order management device according to claim 7, further comprising:
9. The movement acquisition means The store customer order management device of claim 8, characterized in that it acquires shipping data that sets the quantity of the requested product to be moved and shipped from the allocable warehouse to the requesting store based on the shipping instruction data, and updates the allocable inventory data by subtracting the moved and shipped quantity from the allocated quantity set in the allocable inventory data based on the shipping data and adding the moved and shipped quantity to the moved and shipped quantity.
10. A store customer order management method to be executed by a store customer order management device having a memory unit and a control unit, The storage unit inventory storage means for storing inventory data that is set by linking together products, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and moving / shipping quantities; Equipped with Executed in the control unit: a store customer order acquisition step of identifying the inventory data in which an available storage location for allocating the requested product is set as available inventory data based on a purchase request in which a requested product and a requested quantity are set from a customer, and acquiring store customer order data set by linking the requested product, the available storage location, the requesting store, and the requested quantity; an inventory allocation step of updating the available inventory data based on the store customer order data; a movement acquisition step of acquiring movement data of the requested product from the allocation-available storage location to the requesting store and updating the allocation-available inventory data based on the movement data; a transferring and receiving step of updating the allocable inventory data based on the transferred and received quantity of the requested goods when the requested goods are transferred and received from the allocable storage location to the requesting store; A store customer order management method comprising:
11. A store customer order management program to be executed by a store customer order management device having a memory unit and a control unit, The storage unit inventory storage means for storing inventory data that is set by linking together products, storage locations, current inventory quantities, allocated quantities, available allocation quantities, and moving / shipping quantities; Equipped with In the control unit, a store customer order acquisition step of identifying the inventory data in which an available storage location for allocating the requested product is set as available inventory data based on a purchase request in which a requested product and a requested quantity are set from a customer, and acquiring store customer order data set by linking the requested product, the available storage location, the requesting store, and the requested quantity; an inventory allocation step of updating the available inventory data based on the store customer order data; a movement acquisition step of acquiring movement data of the requested product from the allocation-available storage location to the requesting store and updating the allocation-available inventory data based on the movement data; a transferring and receiving step of updating the allocable inventory data based on the transferred and received quantity of the requested goods when the requested goods are transferred and received from the allocable storage location to the requesting store; A store customer order management program for executing the above.
Citation Information
Patent Citations
System and method for automatically managing stock moving and shipping
JP1993135083A
Method for retrieving inventory and device therefor
JP1996147374A
Physical distribution integration support system, order reception / placement support device, stock management support device, shipment work support device, order reception / placement support device control program and physical distribution integration support method
JP2011059863A
Commodity inventory management device, commodity inventory management method, and commodity inventory management program
JP2019164483A
Method and system for distributing inventory of a replaced or discontinued distribution center product
US20120150700A1