A one-disk inventory sharing warehouse system and its scoring and allocation method
By designing a inventory sharing warehouse system and scoring mechanism, combining static and dynamic allocation mechanisms, the problem of reasonable allocation of inventory between multiple e-commerce channels is solved, inventory sharing and sales performance evaluation is realized, oversold risk is reduced and inventory management is simplified.
Patent Information
- Application Number
- CN202210294229.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-03-23
- Publication Date
- 2025-05-27
- Estimated Expiration
- 2042-03-23
AI Technical Summary
The existing technology is difficult to effectively solve the problem of reasonable distribution of a single inventory between multiple e-commerce channels, which can easily lead to oversold risks and the complexity of inventory management.
A one-track inventory sharing warehouse system was designed, including physical warehouses, logical warehouses, summary warehouses and channel warehouses. Inventory sharing is realized through the five-layer warehouse structure model, and a summary warehouse scoring mechanism and static and dynamic allocation mechanisms were introduced to ensure the reasonable allocation of inventory.
It realizes a piece of goods sharing in the inventory of various stores or warehouses of the enterprise, evaluates the sales performance of various online channels, dynamically allocates inventory to channels with sales opportunities, reduces the risk of oversold and simplifies inventory management.
Smart Images

Figure CN114881553B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of warehouse equipment, and more specifically, it relates to a one - inventory - sharing warehouse system and its scoring and allocation method. Background Art
[0002] An enterprise's one - inventory usually supplies multiple e - commerce channels for sales. As the number of online stores connected to the enterprise's middle - platform increases, if the inventory of each online store's warehouse synchronizes this one - inventory, the total sales inventory number on the online platform will greatly exceed the total inventory available for allocation in the enterprise's warehouse. Once a product sells well on multiple channels, it is easy to have a serious over - selling phenomenon.
[0003] Based on this, traditional middle - platform inventory management controls the inventory quantity transmitted to the online side by setting the inventory synchronization ratio and safety inventory of the warehouse; however, this method requires continuous human input to evaluate sales situations to adjust the inventory ratio and safety inventory. Even so, there is still a risk of over - selling caused by concurrent orders on multiple channels for some popular products; and when the remaining inventory is equal to the safety inventory number in the traditional mechanism, the available sales inventory online will be updated to 0 by the system while there is still available inventory for allocation in the warehouse; ultimately, manual intervention is required to manage the digestion of the remaining inventory. There are many such problems.
[0004] Combining the above reasons, how to reasonably allocate one - inventory to multiple e - commerce platforms is the problem to be solved in this application. Summary of the Invention
[0005] In view of the deficiencies of the prior art, according to the first aspect of the present invention, a one - inventory - sharing warehouse system is provided, which includes a physical warehouse that maps to the specific storage areas of the offline physical warehouse.
[0006] A logical warehouse, where the physical warehouse is associated with at least one logical warehouse, and the logical warehouse is used to logically split the goods in the storage areas of the physical warehouse.
[0007] An aggregation warehouse, where the aggregation warehouse is associated with the logical warehouse in a many - to - many relationship, and the aggregation warehouse is used to aggregate the associated logical warehouses.
[0008] A channel warehouse, where the channel warehouse is associated with the aggregation warehouse in a one - to - one relationship and is used to associate with the warehouses provided by various online e - commerce platforms.
[0009] The above technical solution has the following beneficial effects: The system establishes a five - layer warehouse structure model and realizes the sharing of one - inventory for each store or warehouse in the enterprise through the form of inventory aggregation.
[0010] According to the second aspect of the present invention, a method for scoring a one - inventory - sharing warehouse is provided. It is applied to a one - inventory - sharing warehouse system and includes the following processes:
[0011] The system determines the scoring factors and their scoring coefficients for the centralized warehouse.
[0012] The system filters the sample range of the centralized warehouse.
[0013] The system calculates the daily performance score for the filtered centralized warehouses according to the scoring coefficients set based on the weight ratio of each scoring factor and the sum of the scoring factors.
[0014] The system calculates the final comprehensive score according to the daily performance score and the 30-day historical performance score of the centralized warehouse.
[0015] The above technical solution has the following beneficial effects: introducing a centralized warehouse scoring mechanism to evaluate the sales performance of each online channel.
[0016] According to the third aspect of the present invention, a method for allocating a one-disk inventory shared warehouse is provided, which includes the following process:
[0017] It includes a static allocation mechanism and a dynamic allocation mechanism, both of which are used to calculate the inventory quantity of a single logical warehouse supplying multiple centralized warehouses. When the number of centralized warehouses associated with a single logical warehouse is greater than 1, the logical warehouse can be allocated through the static allocation mechanism and the dynamic allocation mechanism, and the two allocation mechanisms can be switched arbitrarily.
[0018] The above technical solution has the following beneficial effects: supporting the combination of the static allocation mechanism and the dynamic allocation mechanism at the logical warehouse dimension. For the logical warehouse enabled with the dynamic allocation mechanism, when calculating the inventory, it outputs a dynamic inventory value that matches the score for each centralized warehouse; for the logical warehouse not enabled with the dynamic allocation mechanism, it calculates and outputs to the associated centralized warehouse according to the static inventory ratio and the safety inventory method.
[0019] In summary, the above technical solution has the following beneficial effects: The system establishes a five-layer warehouse structure model, and realizes the sharing of inventory in one stock for each store or warehouse of the enterprise through the form of inventory aggregation. Introducing a centralized warehouse scoring mechanism to evaluate the sales performance of each online channel. Supporting the combination of the static allocation mechanism and the dynamic allocation mechanism at the logical warehouse dimension. For the logical warehouse enabled with the dynamic allocation mechanism, when calculating the inventory, it outputs a dynamic inventory value that matches the score for each centralized warehouse; for the logical warehouse not enabled with the dynamic allocation mechanism, it calculates and outputs to the associated centralized warehouse according to the static inventory ratio and the safety inventory method. Description of the Drawings
[0020] Figure 1 It is a schematic diagram of the system structure of a one-disk inventory shared warehouse system;
[0021] Figure 2 It is a schematic flowchart of a method for scoring a one-disk inventory shared warehouse;
[0022] Figure 3It is a schematic diagram of static allocation for a one - tray inventory sharing warehouse system;
[0023] Figure 4 It is a schematic diagram of the dynamic allocation flowchart for a one - tray inventory sharing warehouse allocation method;
[0024] Figure 5 It is a schematic diagram of dynamic allocation for a one - tray inventory sharing warehouse system.
[0025] Reference numerals: 10, physical warehouse; 20, entity warehouse; 30, logical warehouse; 40, summary warehouse; 50, channel warehouse. Detailed implementation manners
[0026] The present invention will be further described in detail below in conjunction with the drawings and embodiments. The same components are denoted by the same reference numerals. It should be noted that the terms "front", "rear", "left", "right", "upper" and "lower" used in the following description refer to the directions in the drawings, and the terms "bottom surface" and "top surface", "inner" and "outer" respectively refer to the directions towards or away from the geometric center of a specific component.
[0027] Such as Figure 1As shown in the figure, a one-disk inventory sharing warehouse system includes a physical warehouse 20, and the physical warehouse 20 maps the specific storage areas of the offline physical warehouse 10; a logical warehouse 30, where each logical warehouse 30 is associated with a physical warehouse 20, and each physical warehouse 20 is associated with at least one logical warehouse 30. The logical warehouse 30 is used to logically split the goods in the storage areas of the physical warehouse 20 and organize and manage them through the logical warehouse 30; a summary warehouse 40, where the summary warehouse 40 is associated with the logical warehouse 30 in a many-to-many relationship, and the summary warehouse 40 is used to summarize the logical warehouses 30 associated with it; a channel warehouse 50, where the channel warehouse 50 is associated with the summary warehouse 40 in a one-to-one relationship and is used to associate with the warehouses provided by various online e-commerce platforms. The system establishes a five-layer warehouse structure model and realizes the sharing of one-disk goods in the inventories of each store or warehouse of the enterprise through the form of inventory summary. The physical warehouse 10 is jointly defined by the one-disk inventory sharing warehouse system and the WMS (Warehouse Management System) system. The two systems are mapped one by one and point to a specific offline physical warehouse. The logical warehouse 30 can also be divided by the ERP system (Enterprise Resource Planning), and then the logical warehouse 30 library divided in the third-party ERP system is directly mapped one by one through the one-disk inventory sharing warehouse system to ensure that it is the smallest deliverable unit. The one-disk inventory sharing warehouse system can divide the logical warehouse 30 flexibly and diversely, but must establish a one-to-many association relationship with the physical warehouse 20, that is, one physical warehouse 20 can be associated with multiple logical warehouses 30, but one logical warehouse 30 cannot be associated with multiple physical warehouses 20, and the logical warehouses 30 corresponding to each physical warehouse 20 are different. The data of the summary warehouse 40 is the SKU (Stock Keeping Unit) level summary of the inventory data of the logical warehouses 30 associated with it, and multiple summary warehouses 40 can be associated with the same or the same group of logical warehouses 30. The channel warehouse 50 is a warehouse provided by various e-commerce platforms for third-party system docking. The warehouse types are divided differently according to the situations of each platform, but in the enterprise middle platform system, they are all regarded as the channel warehouse 50, and this data comes from the channel and cannot be changed. Based on the above structure, the enterprise can summarize all the sellable logical warehouses 30 into one-disk goods, set the summary warehouse 40 as needed and associate it with the specified channel mall.
[0028] As Figure 2 shown, a one-disk inventory sharing warehouse system can score each summary warehouse 40, and the one-disk inventory sharing warehouse scoring method is mainly realized through the following process.
[0029] St1.1. The system determines the scoring factors and their weight ratios of the summary warehouse 40. The scoring factors include the number of pieces purchased in the sales order, the number of pieces of goods in the return order, and the number of days since the opening of the associated online store. Different scoring factors have different scoring coefficients. The above scoring factors are continuously expanded to more customized scoring factors according to the development of the business.
[0030] St1.2, the sample range of the system filtering and summarizing warehouse 40. The conditions include that the logical warehouse 30 is bound in the summarizing warehouse 40, the summarizing warehouse 40 has been mapped to the channel warehouse 50, the store associated with the mapped channel warehouse 50 is in an enabled state, and the mall where the store is located is also in an authorized access state to maintain sharing the inventory system with the first-inventory warehouse system. Those that meet all the above conditions can be regarded as normal samples to participate in scoring, and the comprehensive scores of abnormal samples other than these are all 0.
[0031] St1.3, the system statistically calculates the daily scoring data of the filtered summarizing warehouse 40 according to the scoring factors, and calculates the daily performance score of each day based on the weight ratio of each scoring factor. The daily performance score is calculated based on the scoring data of each scoring factor on the same day. The daily performance score is calculated every 5 minutes according to each scoring factor and its weight ratio. The purpose of this score is that for channels like live broadcasts that may experience sudden surges in volume irregularly, if scored completely according to historical averages, it cannot reflect the inventory demand on the same day. Separately statistically calculating the daily performance score helps to provide a prediction of the daily sales trend.
[0032] St1.4, the system calculates the final comprehensive score according to the daily performance score and the 30-day historical performance score of the summarizing warehouse 40. The 30-day historical performance score is the average of the daily performance scores of the most recent 30 days before the current day. The statistical frequency of the 30-day historical performance score is T + 1, where T is the number of historical days. The score of the previous day is statistically counted, and the average value is calculated by summarizing the scores of the most recent 30 days to obtain the 30-day historical performance score. The purpose of this score is to evaluate the long-term performance of the store. Introducing the summarizing warehouse scoring mechanism is used to evaluate the sales performance of each online channel. Through this scoring mechanism for scoring and ranking and combining with the dynamic allocation mechanism, the optimal allocation problem of inventory synchronization is solved.
[0033] The comprehensive score is calculated through the daily performance score, the 30-day historical performance score, and the weight value W set by the system. The calculated comprehensive score S is
[0034] S = (S T+0 ×W T+0 ) + (S T+30 ×W T+30 ) (1.1)
[0035] In the formula: S T+0 is the daily performance score, W T+0 is the weight value of the daily performance score, S T+30 is the 30-day historical performance score, W T+30 is the weight value of the 30-day historical performance score. The weight value W can be adjusted accordingly according to the overall business requirements.
[0036] A one-batch inventory sharing warehouse system distributes inventory to multiple summary warehouses 40 through its distribution method. The one-batch inventory sharing warehouse distribution method is mainly implemented through the following process.
[0037] A one-batch inventory sharing warehouse distribution method includes a static distribution mechanism and a dynamic distribution mechanism, both of which are used to calculate the inventory quantity of a single logical warehouse 30 supplying multiple summary warehouses 40. When the number of summary warehouses 40 associated with a single logical warehouse 30 is greater than 1, the logical warehouse 30 can be distributed through the static distribution mechanism and the dynamic distribution mechanism, and the two distribution mechanisms can be switched arbitrarily; when the number of summary warehouses 40 associated with a single logical warehouse 30 is 1, the logical warehouse 30 is distributed through the static distribution mechanism. On the dimension of the logical warehouse, a combination of the static distribution mechanism and the dynamic distribution mechanism is supported. The logical warehouse enabled with the dynamic distribution mechanism outputs a dynamic inventory value matching its score to each summary warehouse when calculating the inventory; for the logical warehouse not enabled with the dynamic distribution mechanism, it calculates and outputs to the associated summary warehouse according to the static inventory ratio and the safety inventory method.
[0038] As Figure 3 shown, the static distribution mechanism calculates the static distribution inventory Y by manually inputting the safety inventory quantity and the inventory synchronization ratio and combining the available inventory quantity of the logical warehouse, as
[0039] Y = Ma × r - c (2.1)
[0040] In the formula: Ma is the available inventory quantity of the logical warehouse, c is the safety inventory quantity, and r is the inventory synchronization ratio.
[0041] The one-batch inventory sharing warehouse system supports independently setting the respective inventory ratios and safety inventory quantities of multiple summary warehouses 40 supplied by a single logical warehouse 30 in inventory management. The static distribution mechanism, as an alternative mode of the dynamic distribution mechanism, requires manual intervention to ensure that commodity personnel can flexibly manage targeted inventory placement plans when the dynamic distribution mechanism is not enabled in the warehouse.
[0042] Example 1: For example, the C logical warehouse 30 is bound to the first and second summary warehouses 40. For the first summary warehouse 40, its 20% synchronization ratio and a static safety inventory value of 0 are set; for the second summary warehouse 40, its 60% synchronization ratio and a static safety inventory value of 1 are set. If the available inventory of a certain commodity in this C logical warehouse 30 is 10, through calculation, Y 1 = Ma × r - c = 10 × 0.2 - 0 = 2, Y 2 = Ma × r - c = 10 × 0.6 - 1 = 5. According to the static distribution mechanism, 2 inventories are distributed to the first summary warehouse 40, and 5 inventories are distributed to the second summary warehouse 40.
[0043] The dynamic allocation mechanism supports setting the overflow multiple. The dynamic allocation mechanism has a logical warehouse overflow multiple and a summary warehouse overflow multiple; the logical warehouse overflow multiple is input manually and is used to calculate the summary warehouse overflow multiple. The summary warehouse overflow multiple is the overflow multiple of the inventory quantity allocated from the logical warehouse 30 to the summary warehouse 40. The overflow multiple allows the available inventory in some logical warehouses 30 to overflow appropriately within a certain range on the premise of pursuing the actual inventory sum of the SKUs in the online channel warehouse 50 to be equal to the actual inventory of the logical warehouse 30, in order to capture more sales opportunities.
[0044] The logical warehouse overflow multiple N, that is, the multiple relationship between the maximum available online inventory that the logical warehouse 30 can bear and the actual available inventory of the warehouse. The logical warehouse overflow multiple defaults to 0, and the configurable range of the logical warehouse overflow multiple N is 0 < N < W - 1, where W is the number of summary warehouses 40 associated with the logical warehouse 30.
[0045] The summary warehouse overflow multiple n, that is, the available inventory multiple of the summary warehouse 40 associated with the logical warehouse 30. The summary warehouse overflow multiple n is associated with the logical warehouse overflow multiple N, and the calculated summary warehouse overflow multiple n is
[0046]
[0047] In the formula: W is the number of summary warehouses 40 associated with the logical warehouse 30.
[0048] Example 2: For example, if the total overflow of a certain logical warehouse 30 is set to 1 time and it is bound to three summary warehouses 40, then the summary warehouse overflow multiple times, supported up to three decimal places. The above summary warehouse overflow multiple n will participate in the calculation in the subsequent dynamic allocation mechanism.
[0049] Such as Figure 4 shown, the allocation steps of the dynamic allocation mechanism are as follows.
[0050] St10: When the system determines that the logical warehouse 30 associated with the summary warehouse 40 triggers the dynamic allocation mechanism, then detect the inventory of the logical warehouse 30. For each logical warehouse 30 enabled with the dynamic allocation mechanism, when synchronizing each SKU to its associated summary warehouse 40, it is necessary to check whether the available inventory quantity of the SKU has triggered the dynamic allocation mechanism.
[0051] St20: Calculate the trigger threshold and trigger value of the allocation warehouse. The trigger threshold is the threshold for triggering dynamic allocation, and the trigger value is the mean value of the available inventory of the logical warehouse 30 for the summary warehouse 40. When the system determines that the trigger value is greater than the trigger threshold, then perform dynamic allocation according to the mean value. When the system determines that the trigger value is less than or equal to the trigger threshold, then perform dynamic allocation according to the score proportion of the summary warehouse 40; the trigger threshold Z is
[0052] Z = W × β (4.1)
[0053] Trigger value is
[0054]
[0055] where W is the number of summary warehouses 40 associated with the logic warehouse 30, β is the threshold coefficient, Ma is the available inventory of the logic warehouse, β is defaulted to "1", and the system can adjust β to an integer greater than 0 according to requirements to achieve the purpose of adjusting the trigger value.
[0056] St30, determine whether the trigger value is greater than the trigger threshold.
[0057] St41, when it is determined that the trigger value is greater than the trigger threshold, calculate the basic mean. If it is determined at this time, dynamic allocation is performed according to the mean, and the basic mean X base is
[0058]
[0059] where n is the overflow multiple of the summary warehouse associated with the logic warehouse 30, and the result of the basic mean X base is rounded down.
[0060] St42, calculate the total dynamic allocation value through the basic mean and compare it with the available inventory of the logic warehouse. The total dynamic allocation value is X base ×W, and the available inventory of the logic warehouse is Ma.
[0061] St43, determine whether the available inventory of the logic warehouse is greater than the total dynamic allocation value. That is, determine the size relationship between X base ×W and Ma.
[0062] St44, when it is determined that the available inventory of the logic warehouse is greater than the total dynamic allocation value, allocate the difference value completely. If N = 0, and it is determined that X base ×W < Ma, calculate the difference value x dif is
[0063] x dif = Ma - X base ×W (4.4)
[0064] The complete allocation rule distributes the output result array from high to low according to the score S of the summary warehouse 40.
[0065] Example three: As Figure 5 shown, for example, the SKUs in the B logic warehouse 30 have the following conditions, N = 0, Ma = 140, W = 3, β = 2; then the trigger value The trigger threshold Z = W × β = 3 × 2 = 6, then check whether the remainder x is generateddif = Ma - X base × W = 140 - 46 × 3 = 2. Sort the comprehensive scores S of the three summary warehouses 40 from high to low. Suppose S 1 > S 2 > S 3 , then output the inventory of the three summary warehouses 40 {X 1 , X 2 , X 3} = {47, 47, 46}.
[0066] Example 4: If the relationship between the dynamic allocation total value and the available inventory number of the logical warehouse is X base × W ≥ Ma, then the inventory of the logical warehouse 30 is allocated according to the basic average value. For example, the logical warehouse overflow multiple N = 1 is set for the D logical warehouse 30. Suppose Ma = 140, W = 3, β = 2,, then Then X = X base = 46.67 × 1.333 = 62, that is, the inventory allocated to the three summary warehouses 40 is all 62. Until the available inventory number of the logical warehouse Ma = 18, Because it does not meet the requirements of dynamic allocation according to the average value at this time, it enters the allocation process of St51 and makes dynamic allocation according to the score proportion of the summary warehouse.
[0067] St51: When it is judged that the trigger value is less than or equal to the trigger threshold, then calculate the score proportion of the summary warehouse. That is Then the logical warehouse 30 makes dynamic allocation according to the re - calculated score of the summary warehouse. The score proportion P of the summary warehouse is
[0068]
[0069] In the formula, P i is the score proportion of a certain summary warehouse 40, and S i is the comprehensive score of this summary warehouse 40.
[0070] St52: Calculate the allocated inventory quantity of each summary warehouse 40 by sorting the score proportions from high to low. Calculate the allocated inventory number X i of the summary warehouse as
[0071] X i = Ma × n × p (5.2)
[0072] In the formula, X i The result is rounded down.
[0073] St53: Judge whether the available inventory number of the logical warehouse is greater than the dynamic allocation total value. This process is used to calculate whether there is an unallocated balance. The balance value x dif is
[0074] x dif= Ma - ∑X i (5.3)
[0075] Where Ma is the available inventory number in the logic warehouse.
[0076] St54. When it is judged that the available inventory number in the logic warehouse is greater than the total value of dynamic allocation, the difference is allocated one by one in descending order according to the score ratio. That is, there is a difference value x dif , then the difference value x dif is allocated one by one in descending order according to the score ratio P of the summary warehouse, and the calculated allocated inventory number X of the summary warehouse is
[0077] X = X i + X dif (5.4)
[0078] Where X dif is the value obtained by allocating the difference value x dif one by one in descending order according to the score ratio P of the summary warehouse.
[0079] Example 5: For example, the SKUs in the logic warehouse 30 have the following conditions: N = 0, Ma = 12, W = 3; then Assume that the scores of each summary warehouse 40 are {S 1 , S 2 , S 3} = {120, 100, 88}, calculate the score ratios of each summary warehouse as {P 1 , P 2 , S 3} = {0.3896, 0.3247, 0.2857}, calculate the inventory numbers of each logic warehouse 30 as {X 1 , X 2 , X 3} = {4, 3, 3}, calculate the difference value x dif = 2, and the difference value is allocated to each logic warehouse 30 one by one, and the final allocated quantity {X 1 , X 2 , X 3} = {5, 4, 3}.
[0080] On the one hand, the one-plate inventory sharing warehouse system of the present application can solve the overselling problem caused by the excess total inventory released by multiple channels in the online daily sales inventory; more inventory is allocated to online stores with more sales opportunities through the dynamic allocation mechanism of the logical warehouse 30, and the total salable inventory allocated to all online channels will not increase, achieving the goal of efficient allocation and full consumption. At the same time, in the online inventory management, there is no need to perform complicated lock-up operations for sales scenarios such as live broadcasts, daily sales, and special sales. It is only necessary to transfer the inventory required for the activity from the dynamic allocation mechanism to the static allocation mechanism and synchronize it to the channel store; the combination of dynamic allocation and static allocation can achieve exclusive use of part of the inventory in the logical warehouse 30, and achieve the purpose of convenient and effective management and control of online inventory.
[0081] Under the premise that the system has the above-mentioned dynamic allocation mechanism and static allocation mechanism, the channel inventory exclusive mechanism can be easily and quickly implemented, which can meet the needs of channel promotion inventory locking to a great extent, without the need for commodity personnel to link the WMS system to lock warehouses and lock inventory. The specific implementation method is: 1. In the same summary warehouse 40, one or more logical warehouses 30 are set to a dynamic inventory allocation mechanism, and the remaining logical warehouses 30 are set to a static allocation mechanism; 2. Under the condition that the logical warehouse 30 of the static allocation mechanism is only associated with one summary warehouse 40, the inventory provided by the logical warehouse 30 can fully meet the supply needs. After the operation personnel formulate the promotion plan, the commodity personnel can directly transfer the required inventory to the warehouse of the static inventory allocation mechanism according to the inventory volume planned for the promotional goods, ensure that the inventory is not used by other channel warehouses 50, and flexibly and easily implement inventory locking, so that this part of the inventory can be regarded as the exclusive inventory of the promotion. The exclusive problem of promotion and live broadcast inventory is solved by using the dynamic allocation mechanism logical warehouse 30 and the static allocation mechanism logical warehouse 30 in a summary warehouse 40.
[0082] The above are only preferred embodiments of the present invention. The protection scope of the present invention is not limited to the above embodiments. All technical solutions under the concept of the present invention belong to the protection scope of the present invention. It should be pointed out that for ordinary technicians in this technical field, some improvements and modifications without departing from the principle of the present invention should also be regarded as the protection scope of the present invention.
Claims
1. A method for allocating a shared inventory of a single - tray warehouse, characterized in that, it includes a physical warehouse (20), and the physical warehouse (20) maps the specific storage areas of the offline physical warehouse (10); a logical warehouse (30), the physical warehouse (20) is associated with at least one logical warehouse (30), and the logical warehouse (30) is used for logically splitting the goods in the storage areas of the physical warehouse (20); a summary warehouse (40), the summary warehouse (40) is associated with the logical warehouse (30) in a many - to - many relationship, and the summary warehouse (40) is used for summarizing the associated logical warehouses (30); a channel warehouse (50), the channel warehouse (50) is associated with the summary warehouse (40) in a one - to - one relationship, and is used for associating the warehouses provided by various online e - commerce platforms; The method for allocating a shared inventory of a single - tray warehouse includes a static allocation mechanism and a dynamic allocation mechanism; When the number of summary warehouses (40) associated with a single logical warehouse (30) is greater than 1, then the logical warehouse (30) is allocated through the static allocation mechanism or the dynamic allocation mechanism, and the two allocation modes can be switched arbitrarily; When the number of summary warehouses (40) associated with a single logical warehouse (30) is 1, then the logical warehouse (30) is allocated through the static allocation mechanism; The dynamic allocation mechanism has a logical warehouse (30) overflow multiple and a summary warehouse (40) overflow multiple; The logical warehouse (30) overflow multiple is used to calculate the summary warehouse (40) overflow multiple, and the summary warehouse (40) overflow multiple is the overflow multiple of the inventory quantity allocated from the logical warehouse (30) to the summary warehouse (40).
2. The method for allocating a shared inventory of a single - tray warehouse according to claim 1, characterized in that, the static allocation mechanism calculates the static allocation inventory Y by manually inputting the safety inventory quantity and the inventory synchronization ratio, and combining with the available inventory quantity of the logical warehouse (30), Y = Ma×r - c (Equation 2.1) where: Ma is the available inventory quantity of the logical warehouse (30), r is the inventory synchronization ratio, and c is the safety inventory quantity.
3. The method for allocating a shared inventory of a single - tray warehouse according to claim 1, characterized in that, the default value of the logical warehouse (30) overflow multiple is 0, and the configurable range of the logical warehouse (30) overflow multiple N is 0 < N < W - 1; The summary warehouse (40) overflow multiple n associated with the logical warehouse (30) is associated with the logical warehouse (30) overflow multiple N, and the calculated summary warehouse (40) overflow multiple n is, where: W is the number of summary warehouses (40) associated with the logical warehouse (30).
4. The method for allocating a shared inventory of a single - tray warehouse according to claim 1, characterized in that, when it is judged that the logical warehouse (30) associated with the summary warehouse (40) triggers the dynamic allocation mechanism, then the inventory of the logical warehouse (30) is detected; calculate the dynamic allocation trigger threshold and trigger value of the logical warehouse (30); judge whether the trigger value is greater than the trigger threshold; when it is judged that the trigger value is greater than the trigger threshold, then calculate the basic mean value; Calculate the dynamic allocation total value based on the basic average value and compare it with the available inventory quantity of the logical warehouse (30); then determine whether the available inventory quantity of the logical warehouse is greater than the dynamic allocation total value. When it is determined that the available inventory quantity of the logical warehouse (30) is greater than the dynamic allocation total value, then allocate the difference value in full. When it is determined that the trigger value is less than or equal to the trigger threshold, then calculate the score ratio of the summary warehouse (40); calculate the allocated inventory of each summary warehouse (40) by sorting in descending order according to the score ratio. Then determine whether the available inventory quantity of the logical warehouse is greater than the dynamic allocation total value. When it is determined that the available inventory quantity of the logical warehouse (30) is greater than the dynamic allocation total value, then allocate the difference one by one in descending order according to the score ratio.
5. A one-batch inventory sharing warehouse system Characterized in that For implementing the one-batch inventory sharing warehouse allocation method described in any one of claims 1-4, including an entity warehouse (20), and the entity warehouse (20) maps the specific storage areas of the offline physical warehouse (10); A logical warehouse (30), the entity warehouse (20) is associated with at least one logical warehouse (30), and the logical warehouse (30) is used for logically splitting the goods in the storage areas of the entity warehouse (20); A summary warehouse (40), the summary warehouse (40) is associated with the logical warehouse (30) in a many-to-many relationship, and the summary warehouse (40) is used for summarizing the logical warehouses (30) associated with it; A channel warehouse (50), the channel warehouse (50) is associated with the summary warehouse (40) in a one-to-one relationship, and is used for associating the warehouses provided by various online e-commerce platforms.
6. A one-batch inventory sharing warehouse scoring method, which is applied to the one-batch inventory sharing warehouse system described in claim 5 Characterized in that Includes the following processes: The system determines the scoring factors and their weight ratios of the summary warehouse (40); The system filters the sample range of the summary warehouse (40); The system statistically calculates the daily scoring data of the filtered summary warehouse (40) according to the scoring factors, and calculates the daily performance score of each day based on the weight ratios of the respective scoring factors; The system calculates the final comprehensive score according to the daily performance score and the 30-day historical performance score of the summary warehouse (40); Introduce a summary warehouse (40) scoring mechanism to evaluate the sales performance of each online channel. Through this scoring mechanism, scoring and ranking are combined with the dynamic allocation mechanism to solve the optimal allocation problem of inventory synchronization.
7. According to the one-batch inventory sharing warehouse scoring method described in claim 6 Characterized in that The scoring factors include the number of purchased items in the sales order, the number of items in the return order, and the number of days since the opening of the associated online store. Different scoring factors have different score weights.
8. According to the one-batch inventory sharing warehouse scoring method described in claim 6 Characterized in that The daily performance score is calculated every 5 minutes according to the scoring factors and their weight ratios; The 30-day historical performance score is the average value of the daily performance scores of the most recent 30 days before the current day.
9. According to the one-batch inventory sharing warehouse scoring method described in claim 6 Characterized in that The comprehensive score is calculated based on the daily performance score, the 30-day historical performance score, and the weight value W set by the system. The calculated comprehensive score S is as follows: S = (S T+0 × W T+0 ) + (S T+30 × W T+30 )(1.1) Where: S T+0 is the daily performance score, W T+0 is the weight value of the daily performance score, S T+30 is the 30-day historical performance score, W T+30 is the weight value of the 30-day historical performance score.
Citation Information
Patent Citations
Full-channel stock distribution method based on stock of seller
CN107886279A
Inventory calculation synchronization method and equipment
CN112101860A