Inventory management method and device, storage medium and electronic equipment
By introducing channel inventory information into inventory management and refinement allocation, the problem of inefficient inventory management in the existing technology is solved, and more efficient inventory management and reduced supply chain costs are achieved.
Patent Information
- Application Number
- CN202311434550.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-10-31
- Publication Date
- 2025-05-02
AI Technical Summary
The existing inventory management methods are inefficient under the diversified sales channels of e-commerce platforms, resulting in high CPU usage and affecting system stability.
Introduce channel inventory information, allocate physical inventory through preset inventory allocation rules, and refine it to merchants and stores, so as to realize comprehensive inventory management in multi-channel and diversified sales scenarios.
It improves inventory management efficiency, reduces the complexity of channel and inventory management, reduces supply chain costs, and improves sales efficiency.
Smart Images

Figure CN119919048A_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to the field of logistics technology, and in particular to an inventory management method, device, storage medium and electronic device. Background Art
[0002] With the rapid development of e-commerce platforms, merchants' front-end sales have become fragmented and diversified, which has greatly increased the complexity of brand channel management and inventory management. Supply chain costs continue to rise, which has seriously restricted the expansion of front-end sales and the improvement of back-end service experience. Merchants have a stronger demand for online multi-channel integration, unified channel management, unified inventory management and logistics services, increased sales opportunities, and reduced total inventory and long-tail inventory have become core demands.
[0003] The current inventory management has limited dimensions for inventory calculation. For example, there is only calculation in the business unit + warehouse dimensions. The allocation process does not have the concept of "sales channel" and is not suitable for the inventory management requirements of the diversified sales channels of e-commerce platforms. This makes the inventory allocation calculation efficiency low, which in turn leads to extremely high system CPU usage during high-frequency calculations, affecting system stability.
[0004] It should be noted that the information disclosed in the above background technology section is only used to enhance the understanding of the background of the present disclosure, and therefore may include information that does not constitute the prior art known to ordinary technicians in the field. Summary of the invention
[0005] The purpose of the present disclosure is to provide an inventory management method, device, storage medium and electronic device, aiming to solve the problem of low inventory allocation calculation efficiency.
[0006] Other features and advantages of the present disclosure will become apparent from the following detailed description, or may be learned in part by the practice of the present disclosure.
[0007] According to one aspect of an embodiment of the present disclosure, there is provided an inventory management method, including:
[0008] Detect whether the physical inventory information of the target consignor has changed based on the target consignor's order;
[0009] When a change in the physical inventory information of the target consignor is detected, acquiring the physical inventory information of the target consignor;
[0010] Performing inventory allocation on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information;
[0011] The merchant inventory information is pushed to a target merchant, and / or the store inventory information is pushed to a target store of the target merchant.
[0012] According to some embodiments of the present disclosure, based on the above solution, when the order is a sales order, the step of detecting whether the physical inventory information of the target owner has changed based on the order of the target owner includes:
[0013] Extract the outbound quantity of the target consignor in the sales order;
[0014] Pre-occupying the physical inventory information of the target cargo owner based on the outbound quantity;
[0015] Check whether the physical inventory information of the target owner has changed based on the physical inventory information after pre-occupancy.
[0016] According to some embodiments of the present disclosure, based on the above solution, after pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes:
[0017] When receiving the feedback of the outbound operation, the reserved physical inventory information will be deducted.
[0018] According to some embodiments of the present disclosure, based on the above solution, in pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes:
[0019] Acquire channel information of the sales order; wherein the channel information includes merchant information and / or store information;
[0020] The merchant inventory information corresponding to the merchant information and / or the store inventory information corresponding to the store information is pre-occupied based on the channel information.
[0021] According to some embodiments of the present disclosure, based on the above solution, the method further includes:
[0022] When the outbound operation feedback is received, the reserved merchant inventory information and / or store inventory information will be deducted.
[0023] According to some embodiments of the present disclosure, based on the above solution, after pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes:
[0024] Checking whether the physical inventory of the target cargo owner is sufficient according to the physical inventory information after pre-occupancy;
[0025] When it is detected that the physical inventory of the target owner is insufficient, an inventory replenishment prompt message is generated.
[0026] According to some embodiments of the present disclosure, based on the above solution, when the order is a purchase order, the step of detecting whether the physical inventory information of the target owner has changed based on the order of the target owner includes:
[0027] Extract the incoming quantity of the target consignor mentioned in the purchase order;
[0028] Adding the physical inventory information of the target owner based on the incoming quantity;
[0029] Check whether the physical inventory information of the target cargo owner has changed based on the added physical inventory information.
[0030] According to a second aspect of an embodiment of the present disclosure, there is provided an inventory management device, including:
[0031] A detection module, used to detect whether the physical inventory information of the target consignor has changed based on the order of the target consignor;
[0032] An acquisition module, configured to acquire the physical inventory information of the target consignor when detecting a change in the physical inventory information of the target consignor;
[0033] An allocation module, configured to perform inventory allocation on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information;
[0034] A push module is used to push the merchant inventory information to a target merchant, and / or push the store inventory information to a target store of the target merchant.
[0035] According to a third aspect of an embodiment of the present disclosure, there is provided a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the inventory management method as in the above embodiment is implemented.
[0036] According to a fourth aspect of an embodiment of the present disclosure, an electronic device is provided, characterized in that it includes: one or more processors; a storage device for storing one or more programs, when the one or more programs are executed by the one or more processors, the one or more processors implement the inventory management method as in the above-mentioned embodiment.
[0037] The exemplary embodiments of the present disclosure may have some or all of the following beneficial effects:
[0038] In the technical solutions provided in some embodiments of the present disclosure, channel inventory information is introduced in the inventory management process, and the physical inventory can be allocated according to preset inventory allocation rules to obtain channel inventory information, which is then refined to merchants and stores in the channel. It is suitable for comprehensive inventory management in multi-channel and diversified sales scenarios, improves the inventory management efficiency of cargo owners, reduces the complexity of channel and inventory management, and thus reduces supply chain costs. Furthermore, unified channel management and unified inventory management and logistics services will help improve the sales efficiency of cargo owners and bring better benefits to enterprises.
[0039] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] The drawings herein are incorporated into the specification and constitute a part of the specification, showing embodiments consistent with the present disclosure, and together with the specification, are used to explain the principles of the present disclosure. Obviously, the drawings described below are only some embodiments of the present disclosure, and for ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. In the drawings:
[0041] Figure 1 A schematic diagram schematically illustrates a flow chart of an inventory management method in an exemplary embodiment of the present disclosure;
[0042] Figure 2 A flowchart schematically illustrates a sales order pre-emption method in an exemplary embodiment of the present disclosure;
[0043] Figure 3 A schematic diagram schematically shows a flow chart of a sales order pre-order return method in an exemplary embodiment of the present disclosure;
[0044] Figure 4 A schematic diagram schematically illustrates a flow chart of an inventory hierarchy structure in an exemplary embodiment of the present disclosure;
[0045] Figure 5 A schematic diagram of a process of inventory allocation in an exemplary embodiment of the present disclosure is schematically shown;
[0046] Figure 6 A schematic diagram of a model of inventory allocation in an exemplary embodiment of the present disclosure is schematically shown;
[0047] Figure 7 A schematic diagram schematically shows a result of inventory allocation in an exemplary embodiment of the present disclosure;
[0048] Figure 8 A schematic diagram of data flow of an inventory allocation system in an exemplary embodiment of the present disclosure is schematically shown;
[0049] Fig. 9 A schematic diagram of a startup process of inventory calculation in an exemplary embodiment of the present disclosure is schematically shown;
[0050] Fig.10 A schematic diagram schematically illustrates a flow chart of an abnormal compensation mechanism method in an exemplary embodiment of the present disclosure;
[0051] Fig.11 A schematic diagram schematically illustrates another flow chart of an abnormal compensation mechanism method in an exemplary embodiment of the present disclosure;
[0052] Fig.12 (a) schematically shows a performance test diagram of an inventory management system in the prior art;
[0053] Fig.12 (b) schematically shows a performance test diagram of an inventory management system in an exemplary embodiment of the present disclosure;
[0054] Fig.13 A schematic diagram schematically shows the composition of an inventory management device in an exemplary embodiment of the present disclosure;
[0055] Fig.14 A schematic diagram schematically illustrates a computer-readable storage medium in an exemplary embodiment of the present disclosure;
[0056] Fig.15 The structure diagram of a computer system of an electronic device in an exemplary embodiment of the present disclosure is schematically shown. DETAILED DESCRIPTION
[0057] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be more comprehensive and complete and will fully convey the concept of the example embodiments to those skilled in the art.
[0058] In addition, the described features, structures or characteristics may be combined in one or more embodiments in any suitable manner. In the following description, many specific details are provided to provide a full understanding of the embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced without one or more of the specific details, or other methods, components, devices, steps, etc. may be adopted. In other cases, known methods, devices, implementations or operations are not shown or described in detail to avoid blurring the various aspects of the present disclosure.
[0059] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically independent entities. That is, these functional entities may be implemented in software form, or in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.
[0060] The flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps can be decomposed, and some operations / steps can be combined or partially combined, so the actual execution order may change according to actual conditions.
[0061] The integrated supply chain + logistics technology product penetration of consumer goods is an overall product. Business scenarios include online multi-platform and multi-channel integrated goods for brands, online and offline nearby fulfillment integrated goods, and brand BC integrated goods. Its projects include basic logistics services, supply chain planning, and supply chain software services. The current VSC supply chain plan's sales, replenishment and other forecast data have been sunk to the store dimension. It is necessary to improve the channel dimension purchase, sales and inventory management of the ECLP system based on the existing VSC's accurate forecast and inventory planning.
[0062] With the rapid development of e-commerce platforms, merchants' front-end sales have become fragmented and diversified, which has greatly increased the complexity of brand channel management and inventory management. Supply chain costs continue to rise, which has seriously restricted the expansion of front-end sales and the improvement of back-end service experience. Merchants have a stronger demand for online multi-channel integration, unified channel management, unified inventory management and logistics services, increased sales opportunities, and reduced total inventory and long-tail inventory have become core demands.
[0063] For example, a product is provided with warehouse-distribution integrated fulfillment services for orders from three sales channels. The inventory of channel 1 is spread across seven warehouses nationwide, while that of channels 2 and 3 is spread across five warehouses nationwide. The rest are distributed. The current operating status is that the three channels use three modes for independent management. The warehousing and fulfillment relationship is shown in Table 1:
[0064] Table 1 One-stop goods management model for three channels
[0065]
[0066] In the existing technology, inventory calculation has limited dimensions. For example, there is only calculation of the business unit + warehouse dimension. The allocation process does not have the concept of "sales channel". It is not suitable for the inventory management requirements required by the diversified sales channels of e-commerce platforms. This makes the inventory allocation calculation efficiency low, which in turn leads to extremely high system CPU usage during high-frequency calculations, affecting system stability.
[0067] Therefore, in response to the shortcomings in the prior art, the present disclosure provides an inventory management method, which adds the concept of "channel inventory" in the inventory calculation process, increases the channel inventory calculation dimension, and thus enables merchants to sell through online and offline channels, redefines the calculation data in the calculation process, and greatly improves the calculation performance.
[0068] The implementation details of the technical solution of the embodiment of the present disclosure are elaborated in detail below.
[0069] Figure 1 The following is a schematic diagram showing a flow chart of an inventory management method in an exemplary embodiment of the present disclosure. Figure 1 As shown, the inventory management method includes steps S101 to S104:
[0070] Step S101, based on the order of the target owner, detecting whether the physical inventory information of the target owner has changed;
[0071] Step S102, when detecting a change in the physical inventory information of the target owner, obtaining the physical inventory information of the target owner;
[0072] Step S103, performing inventory allocation on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information;
[0073] Step S104: pushing the merchant inventory information to a target merchant, and / or pushing the store inventory information to a target store of the target merchant.
[0074] In the technical solutions provided in some embodiments of the present disclosure, channel inventory information is introduced in the inventory management process, and the physical inventory can be allocated according to preset inventory allocation rules to obtain channel inventory information, which is then refined to merchants and stores in the channel. It is suitable for comprehensive inventory management in multi-channel and diversified sales scenarios, improves the inventory management efficiency of cargo owners, reduces the complexity of channel and inventory management, and thus reduces supply chain costs. Furthermore, unified channel management and unified inventory management and logistics services will help improve the sales efficiency of cargo owners and bring better benefits to enterprises.
[0075] Below, each step of the inventory management method in this example implementation will be described in more detail with reference to the accompanying drawings and embodiments.
[0076] In step S101, based on the order of the target owner, it is detected whether the physical inventory information of the target owner has changed.
[0077] Specifically, each item in the inventory center corresponds to a consignor and a consignor number. The orders of the target consignor are diverse, and the methods for detecting different orders are also different.
[0078] In one embodiment of the present disclosure, when the order is a sales order, the detection of whether the physical inventory information of the target owner has changed based on the target owner's order includes: extracting the outbound quantity of the target owner in the sales order; pre-occupying the physical inventory information of the target owner based on the outbound quantity; and detecting whether the physical inventory information of the target owner has changed based on the pre-occupied physical inventory information.
[0079] Specifically, when the order is a sales order, that is, the inventory change is caused by the user, there is a time difference between the transfer of inventory data and physical inventory. At this time, it is necessary to pre-occupy the inventory when the order is received, and then send back the pre-occupied inventory for synchronization after the physical inventory is transferred. Therefore, when the inventory is pre-occupied, the inventory information has changed. At this time, it is necessary to judge whether the physical inventory information of the target owner has changed based on the physical inventory information after pre-occupancy.
[0080] In one embodiment of the present disclosure, after pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes: upon receiving a feedback of the outbound operation, deducting the pre-occupied physical inventory information.
[0081] Specifically, inventory pre-occupancy is only a virtual deduction of inventory during data transmission. When the warehouse is in operation and the data is transmitted back, the previously reserved physical inventory information needs to be actually deducted to ensure that the system data is consistent with the physical inventory.
[0082] In one embodiment of the present disclosure, after pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes: obtaining channel information of the sales order; wherein the channel information includes merchant information and / or store information; and pre-occupying the merchant inventory information corresponding to the merchant information and / or the store inventory information corresponding to the store information based on the channel information.
[0083] Among them, the channel is the channel for selling goods. At present, in the field of logistics technology, common sales channels include different merchant apps / e-commerce platforms, and a merchant can be divided into multiple stores for sales. Therefore, common channels include multiple merchants, or multiple stores of merchants, or a combination of the two.
[0084] Physical inventory information refers to the actual inventory of the owner in the warehouse, while channel inventory information refers to the inventory of the owner corresponding to different sales channels. Therefore, when inventory pre-occupancy is performed, channel inventory information also needs to be pre-occupied. Therefore, merchant inventory information and / or store inventory information also need to be pre-occupied.
[0085] In one embodiment of the present disclosure, the method further includes: upon receiving a feedback of a delivery operation, deducting the reserved merchant inventory information and / or store inventory information.
[0086] This logic is the same as the above-mentioned deduction of physical inventory information, both of which keep the system data consistent with the physical inventory.
[0087] Figure 2 The following is a schematic diagram showing a flow chart of a sales order pre-emption method in an exemplary embodiment of the present disclosure. Figure 2 As shown, when the document is obtained, first determine whether the document is for channel inventory management (i.e., applicable to the inventory management method in this application): if not, use the original process; if so, pre-occupy, and the pre-occupied business unit inventory and pre-occupied channel inventory can be pre-occupied, that is, the available inventory in the corresponding inventory is reduced; on this basis, check whether the inventory is sufficient: if not, return the document to explain the reason; if so, continue to check whether it corresponds to the e-commerce platform; if it corresponds to the e-commerce platform, then send the store inventory pre-occupancy information, and then generate the consumer store inventory pre-occupancy information, and realize the passive execution of store inventory pre-occupancy, that is, the available inventory is reduced and the pre-occupancy amount is increased; if there is no corresponding e-commerce platform, then send the inventory change message and pre-occupy successfully, and generate the consumer business unit channel inventory change message at the same time, based on the change message, check whether the order is a sales order, if so, ignore the change message; if it is not a sales order, it is necessary to recalculate the store to ensure that the inventory data corresponds to the actual inventory; wherein, when the store is recalculated, it is necessary to identify whether the available inventory has changed, and recalculate when it changes.
[0088] Figure 3 The following is a schematic diagram showing a flow chart of a sales order pre-order return method in an exemplary embodiment of the present disclosure. Figure 3 As shown, when the document is obtained, first determine whether the document is channel inventory management (that is, applicable to the inventory management method in this application): if not, use the original process, if it is to deduct the division inventory and the channel inventory, that is, deduct the actual inventory (that is, Figure 2The reserved inventory is actually deducted), and then it is checked whether it is an e-commerce platform sales order. If so, the store inventory reservation feedback information is sent to generate the consumer store inventory reservation feedback information, and the store inventory passively executes the store inventory reservation, that is, the reserved amount is subtracted; if it is not an e-commerce platform sales order, an inventory change message is sent, the reservation feedback processing is successful, and the consumer division channel inventory change message is generated at the same time to check whether the order is a sales order. If so, the change message is ignored; if it is not a sales order, the store needs to be recalculated to ensure that the inventory data corresponds to the actual inventory; among them, when the store recalculates, it is necessary to identify whether the available inventory has changed, and recalculate when it changes.
[0089] In one embodiment of the present disclosure, when the order is a purchase order, the detection of whether the physical inventory information of the target owner has changed based on the order of the target owner includes: extracting the incoming quantity of the target owner in the purchase order; adding the physical inventory information of the target owner based on the incoming quantity; and detecting whether the physical inventory information of the target owner has changed based on the added physical inventory information.
[0090] Specifically, when a purchase order is generated, the owner's physical inventory information will be increased as a whole, and then the physical inventory information after the increase will be used to determine whether the physical inventory information has changed.
[0091] In step S102, when a change in the physical inventory information of the target owner is detected, the physical inventory information of the target owner is obtained.
[0092] Specifically, only when the physical inventory information changes, whether it is a decrease in inventory caused by a sales order or an increase in inventory caused by a purchase order, inventory allocation will be performed on the changed physical inventory information subsequently.
[0093] Therefore, when the physical inventory information of the target consignor changes, the physical inventory information of the target consignor at the current moment can be extracted from the system for subsequent inventory allocation.
[0094] In step S103, inventory allocation is performed on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information.
[0095] Figure 4 The following is a schematic diagram of a process flow of an inventory hierarchy structure in an exemplary embodiment of the present disclosure. Figure 4 As shown, the inventory has several different hierarchical structures, such as:
[0096] The business unit inventory information, also known as physical inventory information, may include cargo owner information, product information, warehouse information, inventory status, inventory level, and inventory quantity. The inventory quantity includes the total inventory quantity and the available inventory quantity.
[0097] Store inventory is managed according to different stores, which may include owner information, store information, store product information, inventory management method, warehouse and inventory quantity. The inventory quantity includes available inventory quantity, inventory reserve quantity and set reserve quantity.
[0098] Merchant inventory means inventory management according to different merchants, which may include channel factors, product information, warehouse information, inventory status, inventory level, inventory type, and inventory quantity. The inventory quantity includes total inventory quantity and available inventory quantity.
[0099] The batch inventory of the business unit may include the owner information, product information, warehouse information, inventory status, inventory level, batch attributes, inventory type and inventory quantity. The inventory quantity includes the total inventory quantity and the available inventory quantity.
[0100] The total inventory of the consignor refers to the inventory corresponding to the consignor, which may include consignor information, product information, inventory status, inventory level, inventory type and inventory quantity. The inventory quantity includes the total inventory quantity and the available inventory quantity.
[0101] Figure 5 The following is a schematic diagram of a process flow of inventory allocation in an exemplary embodiment of the present disclosure. Figure 5 As shown in the figure, the inventory level can be divided into four levels, namely the total inventory of the owner, the physical inventory, the merchant inventory and the store inventory. The specific concepts are as follows: Figure 4 There are detailed descriptions in the , so I won’t go into details here.
[0102] For example, for a certain cargo owner, the physical inventory includes 3,000 pieces of good quality goods and 9 pieces that are about to expire.
[0103] Merchant inventory, for example, inventory of multiple sales channels, for example, channel 1 (JD) is allocated to 1,000 good products and 0 recent promotional products, channel 2 (TM) is allocated to 1,000 good products and 0 recent promotional products, channel 3 (DY) is allocated to 600 good products and 0 recent promotional products, channel 4 (others) is allocated to 300 good products and 0 recent promotional products, and channel 5 (PDD) is allocated to 100 good products and 9 recent promotional products.
[0104] Among them, Channel 1 (JD) has several stores under it, and the distribution is POP Store 1 with 200 good products and 0 near-effective promotional products, POP Store 2 with 480 good products and 0 near-effective promotional products, and POP Store 3 with 320 good products and 0 near-effective promotional products. Channel 4 (JD) has stores under it, and the distribution is POP Store 1 with 100 good products and 9 near-effective promotional products.
[0105] The structure of inventory allocation is shown above, but the allocation rules can be freely set. Specifically, since channels correspond to merchants and / or stores, inventory allocation rules also correspond to merchant allocation rules and / or store allocation rules. Merchant allocation rules and store allocation rules are used to meet the personalized demands of different channels, and the real-time dynamic allocation rules can be formed into a rule pool for use in the two channel dimensions of merchants and stores.
[0106] Figure 6 A schematic diagram of a model of inventory allocation in an exemplary embodiment of the present disclosure is schematically shown. Figure 6 As shown, the inventory center provides customers with inventory management in different dimensions, and can provide real-time inventory query, change, allocation, occupancy, change, warning, channel and other scenario services; among them, the business unit inventory is a management model based on the physical inventory, mainly including SKU, warehouse, grade, inventory type and inventory quantity; the store inventory is a management model based on the attributes of the sales store, mainly including SKU, warehouse, channel and inventory quantity; the merchant inventory is a management model based on the attributes of the sales merchant, mainly including SKU, store / management method, warehouse and inventory quantity.
[0107] For merchant allocation rules or store allocation rules, there can be multi-dimensional allocation rules by warehouse, ratio, merchant, store, fixed value, etc. For example, Figure 4 , a fixed value of 1,000 pieces is allocated to channel 1 and channel 2 (by fixed value), 60% of the remaining pieces is allocated to channel 3 (by proportion), and so on.
[0108] After the inventory allocation is completed, the inventory data can be stored. The stored data structure is shown in Table 2-4.
[0109] Table 2 Data structure of the distribution of commodity dimension to channel inventory
[0110]
[0111] Table 3 Data structure of channel inventory allocation in the store dimension
[0112]
[0113] Table 4 Data structure of inventory ratio setting for a batch of goods
[0114]
[0115] Among them, the inventory ratio setting of the goods dimension (goods_channel_ratio) in Table 4 cooperates with the allocation of channel inventory in the store dimension (goods_channel_shop_stock_allot_rule) to realize the allocation of the store dimension; and cooperates with the allocation of channel inventory in the merchant dimension (channel_shop_stock_allot_rule) to realize the allocation of the merchant dimension, and finally the allocated inventory is reflected in the channel inventory (shop_stock).
[0116] Figure 7 The following is a schematic diagram showing a result of inventory allocation in an exemplary embodiment of the present disclosure. Figure 7 As shown, there are 600 stocks in the warehouse, of which channel 1 and channel 3 are exclusive stocks, accounting for 40% of the total stock, so channel 1 and channel 3 share 40% of the total stock, 120 pieces each for each sales channel; channel 2 stores are shared models, accounting for 60%, so the stock is distributed in the proportion of 60%*20%, 60%*30%, and 60%*50%. These goods are stored in three warehouses, namely warehouse A, B, and C, storing 100, 200, and 300 pieces respectively, and are managed by different warehouse management systems WMS.
[0117] The channel inventory allocation strategy is as follows: the total inventory of the shipper includes 80 good products, 10 near-expiry products, and 5 expired products, as shown in Table 5. There are channels 1 and 2 in the matching rules. The inventory is allocated to different channels according to the rules and allocation ratios, as shown in Table 6.
[0118] Table 5 Business unit inventory information
[0119]
[0120]
[0121] Table 6 Channel inventory information
[0122]
[0123] Step S104: pushing the merchant inventory information to a target merchant, and / or pushing the store inventory information to a target store of the target merchant.
[0124] Specifically, when there is merchant inventory information, the merchant inventory information is pushed to the target merchant to provide inventory display for users on the merchant page. When there is store inventory information, the store inventory information is pushed to the target store to provide inventory display for users on the store page.
[0125] Figure 8 The following is a schematic diagram showing the data flow of an inventory allocation system in an exemplary embodiment of the present disclosure. Figure 8 As shown:
[0126] Inventory allocation rules are configured on the merchant side and management side of the external system. When the internal system detects a change in inventory, the inventory processing system of the internal system synchronizes it to the channel inventory system. Finally, inventory is allocated through physical inventory + inventory allocation rules, and finally synchronized to POP and VMI.
[0127] Its main functions include:
[0128] ① Sourcing business provides query services;
[0129] ② Document-driven inventory increase and decrease;
[0130] ③、④ Warehouse operations drive inventory changes, and inventory is processed internally;
[0131] ⑤, ⑥, ⑦ In conjunction with the inventory allocation strategy, the virtual set business supports the POP store sales inventory business;
[0132] ⑧Warehouse relocation business handles inventory.
[0133] Based on the above method, on the one hand, the distribution of one batch of goods to multiple consignors increases the channel dimension, which is mainly reflected in the extension of various sales channels, so that a certain sales channel has merchant dimension and store dimension in the sense of sales channel.
[0134] On the other hand, the introduction of the sales channel concept directly increases the management dimension of goods by cargo owners, and at the same time has a good effect on users in settling accounts and sharing profits.
[0135] In one embodiment of the present disclosure, the inventory management system provided by the present disclosure is combined with the inventory management system in the prior art ( Figure 8 The internal system in the system was put into operation and compared with the system after operation, which produced a good technical effect. The following is a detailed description:
[0136] Fig. 9A schematic diagram of the startup process of inventory calculation in an exemplary embodiment of the present disclosure is schematically shown. At the specific execution level, when an inventory change is detected, a message stock_change is generated, the message tock_change is parsed, and then the query is made based on the input parameter deptNo whether a channel inventory flag is enabled (i.e., using the method provided in this application). If it is not enabled, the process ends, i.e., it is not executed; if it is enabled, then the preset logic factor is checked to see if it is 1, if it is, it is not processed, if not, the message logicStockFlows is obtained, and the message logicStockFlows is checked to see if there is data, if there is no data, it is not processed, if there is data, then the filtered data is checked to see if it is greater than 0, if it is greater than 0, the inventory recalculation is enabled, if it is less than or equal to 0, then it is not processed.
[0137] Fig.10 A schematic diagram schematically shows a flow chart of an abnormal compensation mechanism method in an exemplary embodiment of the present disclosure; Fig.10 As shown, when the warehouse ratio is updated (i.e., when the inventory changes), a non-empty check is performed, and after the check passes, the commodity ratio validity check is performed, and after the check passes, the warehouse quantity check is performed, and after the check passes, the warehouse validity check is performed, and after the check passes, the loop logic is completed. Among them, the steps of warehouse quantity check include logical inventory query, commodity dimension rule query, query of the warehouse dimension table according to the commodity primary key, and then inventory quantity check. After the check passes, this setting is performed, that is, logical inventory-occupied.
[0138] Fig.11 The flowchart schematically shows another abnormal compensation mechanism method in the exemplary embodiment of the present disclosure. Fig.11 As shown, when the warehouse ratio is updated (that is, when the inventory changes), a non-empty check is performed. After the check passes, the input parameter ID is checked for non-empty. After the check passes, the warehouse quantity is checked. After the check passes, the commodity ratio validity is checked. After the check passes, the warehouse information is queried based on the ID to see if it exists. If so, logical deletion is performed and recalculation is triggered.
[0139] Table 7 shows the inventory management system operation data in the prior art, and Tables 8 and 9 show the inventory management system operation data obtained using the method provided by the present disclosure, wherein Table 8 is the business log data of the production environment that is not closed, and Table 9 is the business log data of the production environment that is closed.
[0140] Table 7 Operational data of prior art inventory management system
[0141]
[0142] Table 8 Business log data not closed in the production environment of this disclosure
[0143]
[0144]
[0145] Table 9 Production environment shutdown business log data in this disclosure
[0146]
[0147] As shown in Table 7, in the prior art, when the sku is 200 to 1 and the number of concurrent users is 1, the TPS (transactions / second) is 7 transactions / second; while using the method provided by the present invention, as shown in Table 8, when the sku is 2789 to 1 and the number of concurrent users is 1, the TPS (transactions / second) is 19 transactions / second, which greatly improves the system performance.
[0148] Comparing Table 8 and Table 9, for example, when the number of concurrent users is 280, when the business log is turned off, the TPS (tx / sec) is 2915 tx / sec; when the business log is turned off, the TPS (tx / sec) is 4533 tx / sec, and the system performance is also improved.
[0149] Fig.12 (a) Schematic diagram of a performance test of an inventory management system in the prior art.
[0150] The horizontal axis represents time, and the vertical axis represents the performance of database pre-occupancy. Fig.12 (b) schematically shows a performance test diagram of an inventory management system in an exemplary embodiment of the present disclosure, wherein the horizontal axis represents time, the vertical axis represents the memory pre-occupancy performance, and different linear axes represent different calculation examples.
[0151] based on Fig.12 Compared with (a) and (b), in terms of performance, the inventory management system disclosed in the present invention relies on memory pre-occupancy, which is about 3 times lower than database pre-occupancy. The performance of database pre-occupancy is about 300ms, and the memory pre-occupancy is about 70-100ms.
[0152] Fig.13 The following is a schematic diagram showing the composition of an inventory management device in an exemplary embodiment of the present disclosure. Fig.13 As shown, the inventory management device 1300 may include a detection module 1301, an acquisition module 1302, an allocation module 1303, and a push module 1304. Among them:
[0153] A detection module 1301 is used to detect whether the physical inventory information of the target owner has changed based on the order of the target owner;
[0154] The acquisition module 1302 is used to acquire the physical inventory information of the target owner when detecting a change in the physical inventory information of the target owner;
[0155] The allocation module 1303 is used to perform inventory allocation on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information;
[0156] The push module 1304 is used to push the merchant inventory information to a target merchant, and / or push the store inventory information to a target store of the target merchant.
[0157] According to an exemplary embodiment of the present disclosure, the detection module 1301 is used to extract the outbound quantity of the target consignor in the sales order when the order is a sales order; pre-occupy the physical inventory information of the target consignor based on the outbound quantity; and detect whether the physical inventory information of the target consignor has changed based on the pre-occupied physical inventory information.
[0158] According to an exemplary embodiment of the present disclosure, the detection module 1301 is also used to, after pre-occupying the physical inventory information of the target owner based on the outbound quantity, deduct the pre-occupied physical inventory information when receiving the outbound operation feedback.
[0159] According to an exemplary embodiment of the present disclosure, the detection module 1301 is also used to obtain channel information of the sales order after pre-occupying the physical inventory information of the target consignor based on the outbound quantity; wherein the channel information includes merchant information and / or store information; and pre-occupying the merchant inventory information corresponding to the merchant information and / or the store inventory information corresponding to the store information based on the channel information.
[0160] According to an exemplary embodiment of the present disclosure, the detection module 1301 is further configured to deduct the reserved merchant inventory information and / or store inventory information when receiving a feedback of a delivery operation.
[0161] According to an exemplary embodiment of the present disclosure, the detection module 1301 is also used to extract the incoming quantity of the target consignor in the purchase order when the order is a purchase order; increase the physical inventory information of the target consignor based on the incoming quantity; and detect whether the physical inventory information of the target consignor has changed based on the added physical inventory information.
[0162] According to an exemplary embodiment of the present disclosure, the inventory allocation rule includes a merchant allocation rule and / or a store allocation rule.
[0163] The specific details of each module in the above-mentioned inventory management device 1300 have been described in detail in the corresponding inventory management method, so they will not be repeated here.
[0164] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the embodiments of the present disclosure, the features and functions of two or more modules or units described above can be embodied in one module or unit. On the contrary, the features and functions of one module or unit described above can be further divided into multiple modules or units to be embodied.
[0165] In an exemplary embodiment of the present disclosure, a storage medium capable of implementing the above method is also provided. Fig.14 A schematic diagram schematically illustrates a computer-readable storage medium in an exemplary embodiment of the present disclosure, such as Fig.14 As shown, a program product 1400 for implementing the above method according to an embodiment of the present disclosure is described, which can adopt a portable compact disk read-only memory (CD-ROM) and include program code, and can be run on a terminal device, such as a mobile phone. However, the program product of the present disclosure is not limited thereto. In this document, a readable storage medium can be any tangible medium containing or storing a program, which can be used by or in combination with an instruction execution system, an apparatus or a device.
[0166] In an exemplary embodiment of the present disclosure, an electronic device capable of implementing the above method is also provided. Fig.15 The structure diagram of a computer system of an electronic device in an exemplary embodiment of the present disclosure is schematically shown.
[0167] It should be noted that Fig.15 The computer system 1500 of the electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.
[0168] like Fig.15 As shown, the computer system 1500 includes a central processing unit (CPU) 1501, which can perform various appropriate actions and processes according to the program stored in the read-only memory (ROM) 1502 or the program loaded from the storage part 1508 to the random access memory (RAM) 1503. In the RAM 1503, various programs and data required for system operation are also stored. The CPU 1501, the ROM 1502, and the RAM 1503 are connected to each other through a bus 1504. An input / output (I / O) interface 1505 is also connected to the bus 1504.
[0169] The following components are connected to the I / O interface 1505: an input section 1506 including a keyboard, a mouse, etc.; an output section 1507 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 1508 including a hard disk, etc.; and a communication section 1509 including a network interface card such as a LAN (Local Area Network) card, a modem, etc. The communication section 1509 performs communication processing via a network such as the Internet. A drive 1510 is also connected to the I / O interface 1505 as needed. A removable medium 1511, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 1510 as needed so that a computer program read therefrom is installed into the storage section 1508 as needed.
[0170] In particular, according to an embodiment of the present disclosure, the process described below with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication part 1509, and / or installed from a removable medium 1511. When the computer program is executed by a central processing unit (CPU) 1501, various functions defined in the system of the present disclosure are executed.
[0171] It should be noted that the computer-readable medium shown in the embodiment of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, a system, device or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM), a flash memory, an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by an instruction execution system, device or device or used in combination with it. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, wherein a computer-readable program code is carried. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate, or transmit programs for use by or in conjunction with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.
[0172] The flow charts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0173] The units involved in the embodiments described in the present disclosure may be implemented by software or hardware, and the units described may also be arranged in a processor. The names of these units do not, in some cases, constitute limitations on the units themselves.
[0174] As another aspect, the present disclosure further provides a computer-readable medium, which may be included in the electronic device described in the above embodiment; or may exist independently without being assembled into the electronic device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by an electronic device, the electronic device implements the method described in the above embodiment.
[0175] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the embodiments of the present disclosure, the features and functions of two or more modules or units described above can be embodied in one module or unit. On the contrary, the features and functions of one module or unit described above can be further divided into multiple modules or units to be embodied.
[0176] Through the description of the above implementation, it is easy for those skilled in the art to understand that the example implementation described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the implementation of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, including several instructions to enable a computing device (which can be a personal computer, a server, a touch terminal, or a network device, etc.) to execute the method according to the implementation of the present disclosure.
[0177] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary technical means in the art that are not disclosed in the present disclosure.
[0178] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims
1. An inventory management method, characterized in that: include: Detect whether the physical inventory information of the target consignor has changed based on the target consignor's order; When a change in the physical inventory information of the target consignor is detected, acquiring the physical inventory information of the target consignor; Performing inventory allocation on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information; The merchant inventory information is pushed to a target merchant, and / or the store inventory information is pushed to a target store of the target merchant.
2. The inventory management method according to claim 1, characterized in that: When the order is a sales order, the step of detecting whether the physical inventory information of the target owner has changed based on the order of the target owner includes: Extract the outbound quantity of the target consignor in the sales order; Pre-occupying the physical inventory information of the target cargo owner based on the outbound quantity; Check whether the physical inventory information of the target owner has changed based on the physical inventory information after pre-occupancy.
3. The inventory management method according to claim 2, characterized in that: After pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes: When receiving the feedback of the outbound operation, the reserved physical inventory information will be deducted.
4. The inventory management method according to claim 2, characterized in that: After pre-occupying the physical inventory information of the target owner based on the outbound quantity, the method further includes: Acquire channel information of the sales order; wherein the channel information includes merchant information and / or store information; The merchant inventory information corresponding to the merchant information and / or the store inventory information corresponding to the store information is pre-occupied based on the channel information.
5. The inventory management method according to claim 4, characterized in that: The method further comprises: When the outbound operation feedback is received, the reserved merchant inventory information and / or store inventory information will be deducted.
6. The inventory management method according to claim 1, characterized in that: When the order is a purchase order, the step of detecting whether the physical inventory information of the target owner has changed based on the order of the target owner includes: Extract the incoming quantity of the target consignor mentioned in the purchase order; Adding the physical inventory information of the target owner based on the incoming quantity; Check whether the physical inventory information of the target cargo owner has changed based on the added physical inventory information.
7. The inventory management method according to claim 1, characterized in that: The inventory allocation rules include merchant allocation rules and / or store allocation rules.
8. An inventory management device, characterized in that: include: A detection module, used to detect whether the physical inventory information of the target consignor has changed based on the order of the target consignor; An acquisition module, configured to acquire the physical inventory information of the target consignor when detecting a change in the physical inventory information of the target consignor; An allocation module, configured to perform inventory allocation on the physical inventory information based on a preset inventory allocation rule to obtain channel inventory information; wherein the channel inventory information includes merchant inventory information and / or store inventory information; A push module is used to push the merchant inventory information to a target merchant, and / or push the store inventory information to a target store of the target merchant.
9. A computer-readable storage medium having a computer program stored thereon, wherein when the program is executed by a processor, the inventory management method according to any one of claims 1 to 7 is implemented.
10. An electronic device, characterized in that: include: one or more processors; A storage device for storing one or more programs, when the one or more programs are executed by the one or more processors, enables the one or more processors to implement the inventory management method according to any one of claims 1 to 7.
Citation Information
Patent Citations
Full-channel stock distribution method based on stock of seller
CN107886279A
A method and platform for automatically allocate commodity inventory
CN109472443A
Inventory sharing method and device among distributed warehouses
CN110147974A
Inventory calculation synchronization method and equipment
CN112101860A
Digital shopping mall system based on service console
CN112150243A