Binning method, medium, apparatus, and computing device for a product
By combining total inventory and purchase order data, along with the warehouse and channel distribution ratio, the target distribution quantity for each warehouse is calculated, solving the problem of low distribution accuracy in existing technologies and achieving more efficient product allocation and inventory balancing.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- HANGZHOU NETEASE ZAIGU TECH CO LTD
- Filing Date
- 2022-11-02
- Publication Date
- 2026-07-24
AI Technical Summary
Existing technologies have low accuracy in product distribution and cannot effectively guarantee the balance of supply and inventory distribution in B-end channels.
By combining the total inventory of the target product in all warehouses, purchase order data, and the distribution ratio of each warehouse in each target sales channel, the inventory after distribution is determined. Combined with the existing inventory, the target distribution quantity for each target sales channel in each warehouse is calculated, and automated distribution is achieved using computing equipment.
It improved the accuracy of warehouse distribution, ensured sufficient supply to B-end channels, avoided the problem of uneven inventory distribution, and achieved more efficient product allocation.
Smart Images

Figure CN115630900B_ABST
Abstract
Description
Technical Field
[0001] The embodiments of this disclosure relate to the field of automated warehousing, and more specifically, the embodiments of this disclosure relate to a product warehousing method, medium, apparatus, and computing device. Background Technology
[0002] This section is intended to provide background or context for the embodiments of this disclosure as set forth in the claims. The description herein is not intended to be a prior art simply because it is included in this section.
[0003] With the development of computer and internet technology, online shopping has become one of the main consumption methods for users. In order to ensure timely delivery of online shopping, merchants usually set up warehouses in multiple cities with convenient logistics or in cities where the products are produced, and distribute the products sold to these warehouses to reduce transportation costs and speed up delivery.
[0004] Currently, there is a problem with low accuracy when distributing products to different warehouses. Summary of the Invention
[0005] This disclosure provides a product sorting method, medium, apparatus, and computing device to solve the problem of low accuracy when sorting products.
[0006] In a first aspect of this disclosure, a method for distributing products into warehouses is provided, comprising:
[0007] Based on the total inventory of the target product in all warehouses and the purchase order data, determine the first inventory of the target product in each target sales channel; wherein, the purchase order data includes the total stock of the target product and the stock ratio corresponding to each target sales channel, and the first inventory of the target product in each target sales channel is the inventory of the target product in the target sales channel after the total stock of the target product is divided into warehouses.
[0008] For each target sales channel, a second inventory of the target product in each warehouse within the target sales channel is determined based on the first inventory quantity corresponding to the target sales channel and the warehouse allocation ratio of the target product in each warehouse within the target sales channel; wherein, the second inventory of the target product in each warehouse within the target sales channel is the inventory quantity of the target product in each warehouse within the target sales channel after the total stock quantity of the target product has been allocated to different warehouses.
[0009] For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse.
[0010] Based on the initial distribution quantity of each warehouse and the inventory ratio of each target sales channel, the target distribution quantity of the target product for each target sales channel in each warehouse is determined.
[0011] In one embodiment of this disclosure, determining the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data includes:
[0012] For each target sales channel, a third inventory level is determined based on the total inventory level, the total stock level, the sales lock-in quantity, the stock level ratio, and the sales ratio corresponding to the target sales channel; wherein, the sales lock-in quantity is the minimum number of the target product configured in the target sales channel;
[0013] For each target sales channel, the first inventory of the target sales channel is determined based on the third inventory, the total inventory, the total stock, and the first inventory already determined in other target sales channels.
[0014] In another embodiment of this disclosure, determining the third inventory level for each target sales channel based on the total inventory level, the total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel includes:
[0015] For each target sales channel, the fourth inventory level of the target product in that target sales channel is determined based on the total inventory level, the sales lock-in quantity corresponding to the target sales channel, and the inventory ratio.
[0016] For each target sales channel, the fifth inventory level of the target product in that target sales channel is determined based on the total inventory level, the total stock level, and the sales ratio corresponding to the target sales channel.
[0017] For each target sales channel, the larger of the fourth and fifth inventory quantities is determined as the third inventory quantity for that target sales channel.
[0018] In another embodiment of this disclosure, determining the first inventory level of each target sales channel based on the third inventory level, the total inventory level, the total stock level, and the first inventory level already determined in other target sales channels includes:
[0019] For each target sales channel, the remaining allocable quantity for that target sales channel is determined based on the total inventory, the total stock, and the first inventory already determined in other target sales channels.
[0020] The smallest quantity among the third inventory quantity and the remaining allocable quantity is determined as the first inventory quantity of the target sales channel.
[0021] In another embodiment of this disclosure, determining the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse within each target sales channel, and the existing inventory quantity of the warehouse includes:
[0022] For each warehouse, calculate the sum of the second inventory levels of the warehouses across all target sales channels, and the first difference between this sum and the existing inventory level. The first difference is then determined as the stockout amount of the target product in that warehouse.
[0023] For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse.
[0024] In another embodiment of this disclosure, determining the initial distribution quantity of the target product in each warehouse based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse includes:
[0025] For each warehouse, calculate the ratio of the stockout quantity in that warehouse to the total stockout quantity;
[0026] For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the ratio and the total inventory.
[0027] In another embodiment of this disclosure, determining the initial distribution quantity of the target product in each warehouse based on the ratio and the total inventory quantity includes:
[0028] For each warehouse, calculate the first product of the ratio and the total inventory quantity, and determine the first product as the initial distribution quantity of the target product in that warehouse.
[0029] In another embodiment of this disclosure, determining the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse within each target sales channel, and the existing inventory quantity of the warehouse includes:
[0030] The quantity of the target product in the first sub-warehouse of each warehouse is determined based on the second inventory quantity of the target product in each warehouse, the existing inventory quantity, and the total stock quantity.
[0031] For each warehouse, based on the loading capacity of the transport containers, determine whether there are any underfilled transport containers required to transport the target quantity of the first sub-warehouse;
[0032] For each warehouse, if there are cases where the target products of the first sub-warehouse quantity are not fully loaded when transporting them, then obtain the quantity of target products allocated to the warehouse that need to be loaded into the partially loaded containers;
[0033] Based on the quantity of target products allocated to each warehouse that need to be loaded into boxes that are not full, obtain the total quantity of all target products that need to be loaded into boxes that are not full.
[0034] Based on the total quantity of all target products that need to be loaded into the partially filled containers, and the loading capacity of the transport containers, the target products that need to be loaded into the partially filled containers are redistributed to determine the second distribution quantity of the target products in each warehouse; wherein, the second distribution quantity is the quantity of the target products redistributed to each warehouse.
[0035] The initial quantity of the target product in each warehouse is obtained based on the first sub-warehouse quantity of the target product in each warehouse, the loading capacity of the transport container, and the second sub-warehouse quantity of the target product in each warehouse.
[0036] In another embodiment of this disclosure, the step of redistributing all target products that need to be loaded into the underfilled containers based on the total quantity of all target products that need to be loaded into the underfilled containers and the loading capacity of the transport containers, and determining the quantity of the target products in the second sub-warehouses of each warehouse, includes:
[0037] Based on the order of quantity in the first sub-warehouse, all target products that need to be loaded into the partially filled containers are allocated to each warehouse in the same quantity as the loading capacity of the transport container, until all target products that need to be loaded into the partially filled containers are allocated, thus obtaining the quantity of the target products in the second sub-warehouse in each warehouse.
[0038] In another embodiment of this disclosure, determining the target distribution quantity of the target product for each target sales channel in each warehouse based on the initial distribution quantity corresponding to each warehouse and the inventory ratio of each target sales channel includes:
[0039] For each warehouse, calculate the second product of the initial distribution quantity of the warehouse and the inventory ratio of each target sales channel to determine the third distribution quantity of each target sales channel in the warehouse;
[0040] For each target sales channel, the quantity of the third sub-warehouse in each warehouse of the target sales channel is accumulated;
[0041] For each target sales channel, the saturation level of the target sales channel is determined based on the sum obtained from the cumulative processing and the corresponding inventory level of the target sales channel.
[0042] Based on the saturation of each target sales channel, the number of third sub-warehouses corresponding to each target sales channel in the target warehouse is adjusted to determine the number of target sub-warehouses corresponding to each target sales channel in each warehouse.
[0043] In another embodiment of this disclosure, the step of adjusting the number of third sub-warehouses corresponding to each target sales channel in the target warehouse according to the saturation of each target sales channel, and determining the number of target sub-warehouses corresponding to each target sales channel in each warehouse, includes:
[0044] In the target warehouse, if the saturation of any target sales channel is greater than the preset saturation, the number of third sub-warehouses of the target sales channel shall be reduced until the saturation of the target sales channel reaches the preset saturation.
[0045] If the saturation of any target sales channel is less than the preset saturation, then the number of third sub-warehouses in the target sales channel is increased until the saturation of the target sales channel reaches the preset saturation.
[0046] The adjusted number of sub-warehouses in the target warehouse is determined as the target sub-warehouse number corresponding to each target sales channel in the target warehouse, and the third sub-warehouse number of each target sales channel in other warehouses is determined as the target sub-warehouse number of each target sales channel in other warehouses.
[0047] In a second aspect of this disclosure, a product compartmentation device is provided, comprising:
[0048] The determination module is used to determine the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data; wherein, the purchase order data includes the total stock level of the target product and the stock level ratio corresponding to each target sales channel, and the first inventory level of the target product in each target sales channel is the inventory level of the target product in the target sales channel after the total stock level of the target product is divided into warehouses;
[0049] The determining module is further configured to, for each target sales channel, determine the second inventory of the target product in each warehouse within the target sales channel based on the first inventory corresponding to the target sales channel and the distribution ratio of the target product in each warehouse within the target sales channel; wherein, the second inventory of the target product in each warehouse within the target sales channel is the inventory of the target product in each warehouse within the target sales channel after the total stock of the target product has been distributed into warehouses;
[0050] The determining module is further configured to determine, for each warehouse, the initial distribution quantity of the target product in the warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse.
[0051] The determining module is further configured to determine the target distribution quantity of the target product corresponding to each target sales channel in each warehouse based on the initial distribution quantity of each warehouse and the inventory ratio of each target sales channel.
[0052] In one embodiment of this disclosure, when the determining module determines the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data, it is specifically used for:
[0053] For each target sales channel, a third inventory level is determined based on the total inventory level, the total stock level, the sales lock-in quantity, the stock level ratio, and the sales ratio corresponding to the target sales channel; wherein, the sales lock-in quantity is the minimum number of the target product configured in the target sales channel;
[0054] For each target sales channel, the first inventory of the target sales channel is determined based on the third inventory, the total inventory, the total stock, and the first inventory already determined in other target sales channels.
[0055] In another embodiment of this disclosure, when the determining module determines the third inventory level of each target sales channel based on the total inventory level, the total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel, it is specifically used for:
[0056] For each target sales channel, the fourth inventory level of the target product in that target sales channel is determined based on the total inventory level, the sales lock-in quantity corresponding to the target sales channel, and the inventory ratio.
[0057] For each target sales channel, the fifth inventory level of the target product in that target sales channel is determined based on the total inventory level, the total stock level, and the sales ratio corresponding to the target sales channel.
[0058] For each target sales channel, the larger of the fourth and fifth inventory quantities is determined as the third inventory quantity for that target sales channel.
[0059] In another embodiment of this disclosure, when the determining module determines the first inventory of a target sales channel for each target sales channel based on the third inventory, the total inventory, the total stock, and the first inventory already determined among other target sales channels, it is specifically used for:
[0060] For each target sales channel, the remaining allocable quantity for that target sales channel is determined based on the total inventory, the total stock, and the first inventory already determined in other target sales channels.
[0061] The smallest quantity among the third inventory quantity and the remaining allocable quantity is determined as the first inventory quantity of the target sales channel.
[0062] In another embodiment of this disclosure, when the determining module determines the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse within each target sales channel, and the existing inventory quantity of the warehouse, it is specifically used for:
[0063] For each warehouse, calculate the sum of the second inventory levels of the warehouses across all target sales channels, and the first difference between this sum and the existing inventory level. The first difference is then determined as the stockout amount of the target product in that warehouse.
[0064] For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse.
[0065] In another embodiment of this disclosure, when the determining module determines the initial distribution quantity of the target product in each warehouse based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse, it is specifically used for:
[0066] For each warehouse, calculate the ratio of the stockout quantity in that warehouse to the total stockout quantity;
[0067] For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the ratio and the total inventory.
[0068] In another embodiment of this disclosure, when the determining module determines the initial distribution quantity of the target product in each warehouse based on the ratio and the total inventory, it is specifically used for:
[0069] For each warehouse, calculate the first product of the ratio and the total inventory quantity, and determine the first product as the initial distribution quantity of the target product in that warehouse.
[0070] In another embodiment of this disclosure, the determining module, when determining the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse within each target sales channel, and the existing inventory quantity of the warehouse, is specifically used for:
[0071] The quantity of the target product in the first sub-warehouse of each warehouse is determined based on the second inventory quantity of the target product in each warehouse, the existing inventory quantity, and the total stock quantity.
[0072] For each warehouse, based on the loading capacity of the transport containers, determine whether there are any underfilled transport containers required to transport the target quantity of the first sub-warehouse;
[0073] For each warehouse, if there are cases where the target products of the first sub-warehouse quantity are not fully loaded when transporting them, then obtain the quantity of target products allocated to the warehouse that need to be loaded into the partially loaded containers;
[0074] Based on the quantity of target products allocated to each warehouse that need to be loaded into boxes that are not full, obtain the total quantity of all target products that need to be loaded into boxes that are not full.
[0075] Based on the total quantity of all target products that need to be loaded into the partially filled containers, and the loading capacity of the transport containers, the target products that need to be loaded into the partially filled containers are redistributed to determine the second distribution quantity of the target products in each warehouse; wherein, the second distribution quantity is the quantity of the target products redistributed to each warehouse.
[0076] The initial quantity of the target product in each warehouse is obtained based on the first sub-warehouse quantity of the target product in each warehouse, the loading capacity of the transport container, and the second sub-warehouse quantity of the target product in each warehouse.
[0077] In another embodiment of this disclosure, when the determining module redistributes the target products that need to be loaded into the unfilled containers based on the total quantity of all target products that need to be loaded into the unfilled containers and the loading capacity of the transport containers, and determines the quantity of the target products in the second sub-warehouse of each warehouse, it is specifically used for:
[0078] Based on the order of quantity in the first sub-warehouse, all target products that need to be loaded into the partially filled containers are allocated to each warehouse in the same quantity as the loading capacity of the transport container, until all target products that need to be loaded into the partially filled containers are allocated, thus obtaining the quantity of the target products in the second sub-warehouse in each warehouse.
[0079] In another embodiment of this disclosure, when the determining module determines the target distribution quantity of the target product corresponding to each target sales channel in each warehouse based on the initial distribution quantity corresponding to each warehouse and the inventory ratio of each target sales channel, it is specifically used for:
[0080] For each warehouse, calculate the second product of the initial distribution quantity of the warehouse and the inventory ratio of each target sales channel to determine the third distribution quantity of each target sales channel in the warehouse;
[0081] For each target sales channel, the quantity of the third sub-warehouse in each warehouse of the target sales channel is accumulated;
[0082] For each target sales channel, the saturation level of the target sales channel is determined based on the sum obtained from the cumulative processing and the corresponding inventory level of the target sales channel.
[0083] Based on the saturation of each target sales channel, the number of third sub-warehouses corresponding to each target sales channel in the target warehouse is adjusted to determine the number of target sub-warehouses corresponding to each target sales channel in each warehouse.
[0084] In another embodiment of this disclosure, when the determining module adjusts the number of third sub-warehouses corresponding to each target sales channel in the target warehouse based on the saturation of each target sales channel, and determines the number of target sub-warehouses corresponding to each target sales channel in each warehouse, it is specifically used for:
[0085] In the target warehouse, if the saturation of any target sales channel is greater than the preset saturation, the number of third sub-warehouses of the target sales channel shall be reduced until the saturation of the target sales channel reaches the preset saturation.
[0086] If the saturation of any target sales channel is less than the preset saturation, then the number of third sub-warehouses in the target sales channel is increased until the saturation of the target sales channel reaches the preset saturation.
[0087] The adjusted number of sub-warehouses in the target warehouse is determined as the target sub-warehouse number corresponding to each target sales channel in the target warehouse, and the third sub-warehouse number of each target sales channel in other warehouses is determined as the target sub-warehouse number of each target sales channel in other warehouses.
[0088] Thirdly, embodiments of this disclosure provide a computing device, including: a processor, and a memory communicatively connected to the processor;
[0089] The memory stores the instructions that the computer executes;
[0090] The processor executes computer execution instructions stored in memory to implement the product partitioning method as described in the first aspect of this disclosure.
[0091] Fourthly, embodiments of this disclosure provide a storage medium storing computer program instructions, which, when executed, implement the product partitioning method as described in the first aspect of this disclosure.
[0092] Fifthly, embodiments of this disclosure provide a computer program product, including a computer program that, when executed by a processor, implements the product partitioning method as described in the first aspect of this disclosure.
[0093] The product warehousing method, medium, apparatus, and computing device disclosed herein determine the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data. For each target sales channel, a second inventory level of the target product in each warehouse within that target sales channel is determined based on the first inventory level corresponding to that sales channel and the warehousing ratio of the target product in each warehouse within that sales channel. For each warehouse, an initial warehousing quantity of the target product in that warehouse is determined based on the total stock preparation quantity, the second inventory level of that warehouse within each target sales channel, and the existing inventory level of that warehouse. Finally, a target warehousing quantity of the target product corresponding to each target sales channel in each warehouse is determined based on the initial warehousing quantity corresponding to each warehouse and the stock preparation ratio of each target sales channel. Because the embodiments of this disclosure combine the existing inventory level of each warehouse, purchase order data, and historical sales data from warehouse outbound shipments, determining the target warehousing quantity of the target product corresponding to each target sales channel in each warehouse from both the sales channel and warehouse dimensions, the accuracy of warehousing processing can be effectively improved. Attached Figure Description
[0094] The above and other objects, features, and advantages of this disclosure will become readily apparent from the following detailed description of exemplary embodiments, taken in conjunction with the accompanying drawings. Several embodiments of this disclosure are illustrated in the drawings by way of example and not limitation, in which:
[0095] Figure 1 This is a schematic diagram of an application scenario provided by an embodiment of the present disclosure;
[0096] Figure 2 A flowchart illustrating a product warehousing method provided in an embodiment of this disclosure;
[0097] Figure 3 A flowchart of a product distribution method provided in another embodiment of this disclosure;
[0098] Figure 4 A flowchart of a product distribution method provided in yet another embodiment of this disclosure;
[0099] Figure 5A flowchart of a product distribution method provided in yet another embodiment of this disclosure;
[0100] Figure 6 A flowchart of a product distribution method provided in yet another embodiment of this disclosure;
[0101] Figure 7 A flowchart of a product distribution method provided in yet another embodiment of this disclosure;
[0102] Figure 8 A flowchart of a product distribution method provided in yet another embodiment of this disclosure;
[0103] Figure 9 A schematic diagram of a storage medium provided in an embodiment of this disclosure;
[0104] Figure 10 This is a schematic diagram of the structure of a product compartmentation device provided in an embodiment of the present disclosure;
[0105] Figure 11 This is a schematic diagram of the structure of a computing device provided in an embodiment of the present disclosure.
[0106] In the accompanying drawings, the same or corresponding reference numerals indicate the same or corresponding parts. Detailed Implementation
[0107] The principles and spirit of this disclosure will now be described with reference to several exemplary embodiments. It should be understood that these embodiments are given merely to enable those skilled in the art to better understand and implement this disclosure, and are not intended to limit the scope of this disclosure in any way. Rather, these embodiments are provided to make this disclosure more thorough and complete, and to fully convey the scope of this disclosure to those skilled in the art.
[0108] Those skilled in the art will recognize that embodiments of this disclosure can be implemented as a system, apparatus, device, method, or computer program product. Therefore, this disclosure can be specifically implemented in the following forms: entirely hardware, entirely software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.
[0109] According to embodiments of this disclosure, a product compartmentation method, medium, apparatus, and computing device are proposed.
[0110] In this article, it is important to understand the following terms:
[0111] Sales channels refer to the pathways or routes through which a product is transferred from the producer to the consumer. They are commercial organizations composed of a series of interdependent entities. Brand-driven e-commerce platforms sell their products through multiple channels, generally categorized as B2B (business) distribution channels (B-end channels) and B2C (consumer) self-operated channels (C-end channels).
[0112] Warehouse Allocation: Based on the sales channel inventory distribution strategy, the allocation quantity of purchased products is calculated. Products are allocated in two dimensions: warehouses and sales channels. Vertically, they are placed in specific warehouses, and horizontally, they are assigned to several sales channels.
[0113] Warehouse allocation ratio: This involves statistically analyzing a product's sales data in warehouses over a specific period to calculate the product's sales percentage in each warehouse. It serves as a crucial basis for guiding reasonable warehouse allocation. More specifically, it can be divided into B2B channel warehouse allocation ratio and B2C channel warehouse allocation ratio.
[0114] Furthermore, the number of any elements in the accompanying drawings is for illustrative purposes only and not for limitation, and any naming is for distinction only and has no limiting meaning.
[0115] In addition, the data involved in this disclosure may be data authorized by the user or fully authorized by all parties. The collection, dissemination and use of the data shall comply with the requirements of relevant national laws and regulations. The implementation methods / executives of this disclosure may be combined with each other.
[0116] The principles and spirit of this disclosure will be explained in detail below with reference to several representative embodiments. Invention Overview
[0118] The inventors have discovered that currently, two common methods are used for product warehousing: The first method involves sales personnel developing a warehousing plan based on experience before each product purchase. This plan clarifies which warehouses and quantities of purchased products will be allocated vertically, and which sales channels and quantities will be allocated horizontally. This allows for product warehousing after purchase based on the plan. The second method uses a shared inventory approach, distributing purchased products across the entire network of warehouses according to the C-end channel warehouse allocation ratio. Following a first-come, first-served principle, the sales channel that needs the goods first receives priority from the shared inventory. However, when distributing products to warehouses using the above methods, the rigor of manual processing cannot be guaranteed. B-end channels have high product demand and have contractual agreements with distribution channels, requiring sufficient inventory to be delivered. Using a single inventory and first-come-first-served principle can easily lead to insufficient supply to B-end channels. Furthermore, allocating products based on the warehouse distribution ratio of C-end channels without considering the warehouse distribution ratio of B-end channels can easily result in uneven inventory distribution after product distribution, leading to low accuracy.
[0119] To address the aforementioned issues, this disclosure provides a product warehousing method, medium, apparatus, and computing device. After purchasing target products based on a stock order, the method determines the first inventory level of the target product in each target sales channel and the second inventory level in each warehouse within each target sales channel by using the total inventory level of the target product in all warehouses, purchase order data, and the warehousing ratio of each warehouse within each target sales channel. Then, combining this with the existing inventory level of the target product in each warehouse, the target warehousing quantity for each target sales channel in each warehouse is determined. This replaces the manual warehousing process based on experience values, effectively ensuring the accuracy of warehousing processing from the perspective of full-network, full-channel inventory.
[0120] After introducing the basic principles of this disclosure, various non-limiting embodiments of this disclosure will be described in detail below.
[0121] Application Scenarios Overview
[0122] First refer to Figure 1 Examples of application scenarios for the solutions provided in this disclosure are given. Figure 1 This is a schematic diagram of an application scenario provided by an embodiment of the present disclosure, such as... Figure 1As shown, in this application scenario, the brand can purchase target products from OEM factories and / or the brand's own manufacturing plants based on a stock preparation order. This stock preparation order includes the total stock quantity, at least one target sales channel, and the stock preparation ratio in each target sales channel. When purchasing target products based on the stock preparation order, the brand can determine the target distribution quantity of the target products for each target sales channel in each warehouse based on the total inventory of the target products in all warehouses, purchase order data, the warehouse distribution ratio in each target sales channel, and the existing inventory in each warehouse. After purchasing the target products, the brand can distribute the target products to each warehouse sequentially according to the aforementioned target distribution quantity for storage.
[0123] It should be noted that the process of determining the target number of distribution warehouses can be achieved through the brand's computing device. This computing device can be a terminal device, such as a laptop or desktop computer, or it can be a server. This application embodiment does not impose specific limitations on this. In practical applications, whether the computing device is a terminal device or a server can be determined according to actual needs, and this disclosure does not impose specific limitations on this.
[0124] Exemplary methods
[0125] The following is combined Figure 1 Application scenarios, refer to Figure 2 This description outlines a product distribution method based on exemplary embodiments of the present disclosure. It should be noted that the above application scenarios are shown only to facilitate understanding of the spirit and principles of the present disclosure, and the embodiments of the present disclosure are not limited in any way. Rather, the embodiments of the present disclosure can be applied to any applicable scenario.
[0126] First, the product distribution method will be introduced through specific examples.
[0127] Figure 2 This is a flowchart illustrating a product distribution method according to an embodiment of this disclosure. The method described in this embodiment can be applied to a computing device, which may be a server or a server cluster, etc. Figure 2 As shown, the method in this embodiment includes:
[0128] S201. Based on the total inventory of the target product in all warehouses and purchase order data, determine the initial inventory of the target product in each target sales channel.
[0129] In this step, the purchase order data includes the total inventory of the target product and the corresponding inventory ratio for each target sales channel. Since the purchase order data only includes data at the sales channel level and not at the warehouse level, and the warehouse level data is determined based on the distribution ratio of the target sales channel in each warehouse, it is necessary to combine the total inventory of the target product in all warehouses to determine the initial inventory level of the target product in each target sales channel.
[0130] Optionally, the purchase order data may also include the inventory quantity corresponding to each target sales channel. For example, the inventory quantity corresponding to each target sales channel can be calculated using the following formula:
[0131] ws k =ws×wp k Formula 1
[0132] Where ws is the total inventory of the target product, ws k For the inventory quantity corresponding to channel K, wp k The inventory ratio of the target product in channel K.
[0133] For example, the inventory ratio for each target sales channel is expressed by the following formula:
[0134]
[0135] Where n is the total number of target sales channels.
[0136] Optionally, since multiplying decimals can result in fractional amounts, the product needs to be rounded down and the fractional amount redistributed to the target sales channel with the highest inventory ratio. For example, assuming the calculated inventory ratios for channels 1, 2, and 3 are 0.1, 0.2, and 0.7 respectively, and the total inventory is 99, then the calculated inventory quantities for channels 1, 2, and 3 based on the inventory ratios of each target sales channel and the total inventory are 9.9, 19.8, and 69.3 respectively. Further, the inventory quantities for channels 1 and 2 need to be rounded down, and the fractional amounts redistributed to channel 3. That is, the processed inventory quantities for channels 1, 2, and 3 are 9, 19, and 71 respectively.
[0137] The first inventory level of the target product in each target sales channel is the inventory level of the target product in each target sales channel after the total inventory of the target product is divided into warehouses.
[0138] Optionally, the total inventory of the target product in all warehouses includes the quantity of the target product currently stored in all warehouses, as well as the initial warehouse allocation quantity of the target product in each warehouse, determined based on other packing orders with allocation times earlier than the current packing order. It should be understood that the warehouse allocation time is the time at which the initial warehouse allocation quantity is determined.
[0139] S202. For each target sales channel, determine the second inventory of the target product in each warehouse within the target sales channel based on the first inventory corresponding to the target sales channel and the distribution ratio of the target product in each warehouse within the target sales channel.
[0140] In this step, the distribution ratio of the target product in each warehouse within each target sales channel is determined based on historical sales data from warehouse outbound shipments. This historical sales data reflects the historical sales performance of the target product in each warehouse. Therefore, after determining the initial inventory level of the target product in each target sales channel, the secondary inventory level in each warehouse within that channel can be further determined based on the distribution ratio. This ensures that after the distribution process, each warehouse and each target sales channel can meet the sales demand for the target product, avoiding stockouts or product overstocking.
[0141] The second inventory level of the target product in each warehouse within the target sales channel is the inventory level of the target product in each warehouse within the target sales channel after the total stock of the target product has been divided into warehouses.
[0142] In one specific implementation, for each target sales channel, the first inventory level of the target sales channel can be multiplied by the distribution ratio of each warehouse within the target sales channel, and the product is the second inventory level of the target product in each warehouse within the target sales channel.
[0143] For example, the second inventory level of the target product in each warehouse within each target sales channel can be calculated using the following Formula 3:
[0144]
[0145] Among them, sp ki For the distribution ratio of warehouse i within channel k, wf k For channel K, the first inventory level, w ki Let i be the second inventory level in warehouse i within channel k.
[0146] It should be understood that since multiplying decimals can result in zeros, when zeros exist, the product needs to be rounded down and the zeros redistributed to the warehouse with the second largest inventory.
[0147] For example, the distribution ratio of each warehouse satisfies the following formula four:
[0148]
[0149] Where z is the total number of warehouses, and for each target sales channel, the sum of the distribution ratios of all warehouses within that target sales channel is 100%.
[0150] S203. For each warehouse, determine the initial distribution quantity of the target product in that warehouse based on the total stock preparation quantity, the second inventory quantity of that warehouse in each target sales channel, and the existing inventory quantity of that warehouse.
[0151] In this step, after determining the second inventory level, the quantity of target products to be distributed to each warehouse can be determined by combining the existing inventory levels in each warehouse. This is the initial warehouse allocation quantity.
[0152] The existing inventory includes the quantity of target products currently stored in the warehouse and the initial distribution quantity determined based on other stock orders. It should be understood that the distribution time of other stock orders is earlier than that of the current stock order, and the distribution time is the time when the initial distribution quantity of target products corresponding to each target sales channel in each warehouse is determined.
[0153] For example, the existing inventory of the target product in each warehouse satisfies the following formula five:
[0154]
[0155] Among them, wr i wr represents the existing inventory of the target product in warehouse i, and wr represents the total inventory of the target product in all warehouses.
[0156] S204. Based on the initial distribution quantity of each warehouse and the inventory ratio of each target sales channel, determine the target distribution quantity of each target product in each warehouse for each target sales channel.
[0157] In this step, after determining the initial distribution quantity for each warehouse, the target products in each warehouse can be divided from the channel perspective based on the inventory ratio of each target sales channel, thereby determining the target distribution quantity of the target products for each target sales channel in each warehouse.
[0158] Following this step, the total stock of target products can be distributed to the target sales channels of each warehouse for storage, based on the target distribution quantity mentioned above.
[0159] The product distribution method disclosed herein determines the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data. For each target sales channel, the second inventory level of the target product in each warehouse within that target sales channel is determined based on the first inventory level corresponding to that target sales channel and the distribution ratio of the target product in each warehouse within that target sales channel. For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stock preparation quantity, the second inventory level of that warehouse within each target sales channel, and the existing inventory level of that warehouse. The target distribution quantity of the target product for each target sales channel in each warehouse is determined based on the initial distribution quantity for each warehouse and the stock preparation ratio for each target sales channel. Because this embodiment of the disclosure combines the existing inventory level of each warehouse, purchase order data, and historical sales data from warehouse outbound shipments, it determines the target distribution quantity of the target product for each target sales channel in each warehouse from both the sales channel and warehouse dimensions, thus effectively improving the accuracy of distribution processing.
[0160] Optionally, in some embodiments, S201 can also be performed by... Figure 3 To express. Figure 3 A flowchart illustrating a product warehousing method provided in another embodiment of this disclosure. (See flowchart for example.) Figure 3 As shown, S201 can also be achieved through the following steps:
[0161] S301. For each target sales channel, determine the third inventory level of the target sales channel based on the total inventory level, total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel.
[0162] In this embodiment, the target quantity of the target product can be determined based on the total inventory and total stock. Then, the target quantity of the target product is allocated to all sales channels with sales volume in sequence, and the first inventory volume allocated to each target sales channel is calculated.
[0163] For example, the sales ratio of each target sales channel satisfies the following formula six:
[0164]
[0165] Where t is the total number of sales channels, cp k The sales ratio for channel K.
[0166] Optionally, the sales ratio for each target sales channel can be determined based on the historical sales data of the target product's warehouse outbound shipments.
[0167] The sales lock-in quantity is the minimum number of products that the target product is configured in the target sales channel.
[0168] Optionally, the target product may be locked at the channel level to prevent it from being occupied by a shared inventory model. The sales lock quantity is the same as the locked quantity mentioned above. It should be understood that the sales lock quantity may also include the locked quantity of goods procured in transit from the target sales channel.
[0169] In one specific implementation, determining the third inventory level can be achieved through the following process:
[0170] For each target sales channel, determine the fourth inventory level of the target product in the target sales channel based on the total inventory level, the sales lock-in quantity corresponding to the target sales channel, and the inventory ratio; for each target sales channel, determine the fifth inventory level of the target product in the target sales channel based on the total inventory level, the total inventory level, and the sales ratio corresponding to the target sales channel; for each target sales channel, determine the largest quantity between the fourth and fifth inventory levels as the third inventory level of the target sales channel.
[0171] For example, the fourth inventory level of the target product in each of the aforementioned target sales channels can be calculated using the following Formula 7:
[0172] wa k =ws k +wlock k Formula 7
[0173] Among them, wa k wlock represents the fourth inventory level of the target product in channel K. k To lock in the sales volume of the target product in channel k.
[0174] For example, the total inventory and the total stock can be summed to determine the target quantity of the target product.
[0175] For example, the target quantity of the target product can be calculated using the following formula:
[0176] wi=wr+ws Formula 8
[0177] Where wi is the target quantity of the target product, wr is the total inventory of the target product in all warehouses, and ws is the total stock level.
[0178] For example, the target quantity is multiplied by the sales ratio corresponding to the target sales channel, and the product is the fifth inventory level of the target product in that target sales channel.
[0179] Optionally, if the product contains zeros, the product value is rounded down to the nearest integer. The rounded value is the fifth inventory level of the target product in the target sales channel.
[0180] For example, the third inventory level of the target product in each of the aforementioned target sales channels can be calculated using the following Formula Nine:
[0181]
[0182] Among them, wi k This represents the third inventory level of the target product in channel K. This represents the fifth inventory level of the target product in channel K.
[0183] S302. For each target sales channel, determine the first inventory level of the target sales channel based on the third inventory level, total inventory level, total stock level, and the first inventory level already determined in other target sales channels.
[0184] In one specific implementation, determining the initial inventory level can be achieved through the following process:
[0185] For each target sales channel, determine the remaining allocatable quantity of the target sales channel based on the total inventory, total stock, and the first inventory already determined in other target sales channels; and determine the minimum quantity among the third inventory and the remaining allocatable quantity as the first inventory of the target sales channel.
[0186] For example, the remaining allocatable amount can be calculated using the following formula:
[0187] wl k =wl 初始 -wf 其他 Formula 10
[0188] Among them, wl k WL represents the remaining allocatable quantity of the target product in channel K. 初始 wf is the initial remaining allocatable amount. 其他 This is the sum of the initial inventory levels already identified in other target sales channels.
[0189] The initial remaining allocatable quantity is the target quantity. For example, the initial remaining allocatable quantity can be expressed by the following formula (eleventh equation):
[0190] wl 初始 =wi Formula Eleven
[0191] For example, the initial inventory level of the target product in each target sales channel can be calculated using the following formula:
[0192] wf k =min(wl) k wi k ) Formula 12
[0193] Among them, wf kThe initial inventory level of the target product in channel k.
[0194] When confirming the initial inventory level of the target product in each target sales channel, the following conditions must be met:
[0195] a. If the remaining allocable quantity is insufficient, then the allocation of the first inventory quantity to the remaining unallocated sales channels shall be stopped.
[0196] b. If there is sufficient remaining allocation capacity and the remaining B-end channels have not been fully allocated, then continue to allocate to other B-end channels.
[0197] c. If there is sufficient remaining allocation and all B-end channels on the purchase order have been allocated, then the remaining amount will be allocated to the C-end self-operated sales channels and placed in the shared inventory.
[0198] Compared with the prior art, the embodiments of this disclosure take into account the reasonable division of inventory demand between B-end channels and C-end channels, thereby ensuring that inventory and channel dimensions are in a balanced state.
[0199] In the above embodiments, for each target sales channel, a third inventory level is determined based on the total inventory level, total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel. A first inventory level for the target sales channel is then determined based on the third inventory level, total inventory level, total stock level, and the first inventory level already determined in other target sales channels. This embodiment combines the sales lock-in quantity and the remaining allocable quantity to determine the first inventory level for each target sales channel, ensuring that the allocation of the first inventory level can meet the sales demand of that target sales channel, further improving the accuracy of warehouse allocation processing.
[0200] Optionally, in some embodiments, S203 can also be performed by... Figure 4 To express. Figure 4 A flowchart illustrating a product distribution method provided in yet another embodiment of this disclosure. (See attached flowchart.) Figure 4 As shown, S203 can also be achieved through the following steps:
[0201] S401. For each warehouse, calculate the sum of the second inventory levels of that warehouse across all target sales channels, and the first difference between this sum and the existing inventory levels. Determine this first difference as the stockout quantity of the target product in that warehouse.
[0202] For example, the sum of the second inventory levels in this warehouse across all target sales channels can be calculated using the following formula thirteen:
[0203]
[0204] Among them, s iFor example, the stockout quantity of the target product in each warehouse can be calculated by summing the second inventory quantity in all target sales channels for that warehouse, using the following formula fourteen:
[0205] l i =s i -wr i Formula Fourteen
[0206] Among them, l i For the stock shortage of the target product in the i warehouse, wr i This represents the existing inventory level in warehouse i.
[0207] It should be understood that if the stockout quantity is negative, it means that the warehouse is not out of stock and has sufficient stock, and there is no need to allocate the target product to the warehouse; if the stockout quantity of the warehouse is an integer, it means that the warehouse is out of stock and the target product needs to be allocated to the warehouse.
[0208] S402. For each warehouse, determine the initial distribution quantity of the target product in that warehouse based on the total stockout quantity, total stock quantity, and stockout quantity of all warehouses.
[0209] In practical applications, if some warehouses are not out of stock, or if the total stock shortage of all warehouses exceeds the total stock, the warehouses with stock shortages may not be able to fully share the target products of the total stock. Therefore, it is necessary to share the target products of the total stock according to the proportion of each warehouse's stock shortage to the total stock shortage.
[0210] The initial quantity of the target product in this warehouse can be determined through the following steps:
[0211] For each warehouse, calculate the ratio of the warehouse's stockout to the total stockout; based on this ratio and the total stockout, determine the initial distribution quantity of the target product in that warehouse.
[0212] For example, the total stockout can be calculated using the following formula fifteen:
[0213]
[0214] Where l represents the total shortage.
[0215] Specifically, determining the initial distribution quantity of the target product in the warehouse based on the ratio and the total inventory can be achieved as follows: for each warehouse, calculate the first product of the ratio and the total inventory, and determine the first product as the initial distribution quantity of the target product in that warehouse.
[0216] For example, the total stockout can be calculated using the following formula sixteen:
[0217]
[0218] Among them, ws i The initial quantity of the target product in warehouse i, where wp is the total inventory quantity.
[0219] It should be understood that when there are spares, these spares will be redistributed to the warehouse with the largest shortage.
[0220] In the above embodiments, for each warehouse, the sum of the second inventory levels in all target sales channels of that warehouse is calculated, and the first difference between this sum and the existing inventory level is determined. This first difference is defined as the stockout quantity of the target product in that warehouse. Based on the total stockout quantity, total stock level, and stockout quantity of each warehouse, the initial distribution quantity of the target product in that warehouse is determined. In this embodiment of the disclosure, considering that warehouses with stockouts cannot completely distribute the target products in the total stock level of the stock order, the distribution of the target products in the total stock level is based on the proportion of each warehouse's stockout quantity to the total stockout quantity, effectively ensuring the balance of the distribution process.
[0221] Optionally, in some embodiments, S203 can also be performed by... Figure 5 To express. Figure 5 A flowchart illustrating a product distribution method provided in yet another embodiment of this disclosure. (See attached flowchart.) Figure 5 As shown, S203 can also be achieved through the following steps:
[0222] S501. Determine the first sub-warehouse quantity of the target product in each warehouse based on the second inventory quantity, existing inventory quantity, and total stock quantity of the target product in each warehouse.
[0223] The specific implementation method and principle of this step can be found in [reference]. Figure 4 The embodiments shown are not described in detail here.
[0224] S502. For each warehouse, based on the loading capacity of the transport container, determine whether there are any unfilled transport containers required when transporting the target quantity of products in the first sub-warehouse.
[0225] To ensure the safety and neatness of the target products during transportation, they typically need to be pre-loaded into transport containers. The corresponding quantity of target products is then transported to each warehouse in units of these containers. In practice, considering packaging and transportation costs, the target products transported to each warehouse are preferably in whole-number containers. Therefore, it is necessary to determine whether any containers are not full when transporting the first batch of target products to a warehouse, so that further processing can be carried out if any are not full.
[0226] In one possible implementation, the quantity of the first sub-warehouse can be divided by the loading capacity of the transport container. The integer part of the quotient is the number of full containers, and the remainder is the number of remaining target products that are not fully loaded. If there is a remainder, it means that the transport containers required to transport the quantity of the first sub-warehouse are not fully loaded; conversely, if there is no remainder, it means that the transport containers required to transport the quantity of the first sub-warehouse are not not fully loaded.
[0227] The loading capacity of the transport container is the maximum number of target products that the transport container can carry.
[0228] S503. For each warehouse, if there are cases where the target products of the first sub-warehouse quantity are not fully loaded when transporting them, then obtain the quantity of target products allocated to that warehouse that need to be loaded into the partially loaded containers.
[0229] Optionally, the quantity of target products allocated to the warehouse and required to be loaded into partially full containers is the remainder in S502.
[0230] S504. Based on the quantity of target products allocated to each warehouse that need to be loaded into boxes that are not full, obtain the total quantity of all target products that need to be loaded into boxes that are not full.
[0231] In one possible implementation, the quantities of target products allocated to each warehouse that need to be loaded into partially full containers can be summed up, and the sum is the total quantity of all target products that need to be loaded into partially full containers.
[0232] S505. Based on the total number of target products that need to be loaded into the unfilled containers and the loading capacity of the transport containers, redistribute all target products that need to be loaded into the unfilled containers to determine the second sub-warehouse quantity of the target products in each warehouse.
[0233] The second sub-warehouse quantity refers to the quantity of target products that are redistributed to each warehouse.
[0234] In one possible implementation, all target products that need to be loaded into the partially filled containers can be allocated to each warehouse in descending order of the first sub-warehouse quantity. The number of target products is the same as the loading capacity of the transport container. This process continues until all target products that need to be loaded into the partially filled containers have been allocated, thus obtaining the second sub-warehouse quantity of the target products in each warehouse.
[0235] Optionally, the same number of target products as the loading capacity of the transport container can be allocated to each warehouse in other orders, such as according to the order of warehouse number, random order, or allocation priority order corresponding to the location of the warehouse, etc. This disclosure does not impose specific limitations on this.
[0236] Optionally, when allocating the same number of target products as the loading capacity of the transport container to each warehouse in sequence for all target products that need to be loaded into the unfilled container, if the number of target products that need to be loaded into the unfilled container is less than the loading capacity of the transport container, then the remaining target products that need to be loaded into the unfilled container are allocated to the warehouse with the largest number of first sub-warehouses.
[0237] S506. Based on the first sub-warehouse quantity of the target product in each warehouse, the loading capacity of the transport container, and the second sub-warehouse quantity of the target product in each warehouse, obtain the initial sub-warehouse quantity of the target product in each warehouse.
[0238] Specifically, for each warehouse, the number of full boxes corresponding to that warehouse can be multiplied by the loading capacity of the transport container, and then the second sub-warehouse quantity of the target product in that warehouse can be added to determine the initial sub-warehouse quantity of the target product in that warehouse.
[0239] Next, a specific example will be used to explain this embodiment in detail.
[0240] For example, assuming it takes x products to fill a shipping container, the number of full containers can be determined using the following formula (17) when transporting the target quantity of the first sub-warehouse to each warehouse:
[0241]
[0242] Among them, wb i This represents the number of boxes in the full container.
[0243] Establish a zero-remainder allocation pool A, and place the remainders from Formula 17 into allocation pool A, awaiting re-allocation. For example, allocation pool A can satisfy the following Formula 18:
[0244] A i =A i-1 +ws i Formula 18
[0245] Based on this, the initial number of sub-accounts can be determined using the following formula:
[0246] q i =wb i ×x+x, if A>0 (Formula 19)
[0247] Where, q i This represents the initial quantity of the target product in the i-warehouse.
[0248] Meanwhile, the remaining amount of target products to be allocated in allocation pool A can be determined using the following formula:
[0249] A = Ax, until Aenough (Formula 20)
[0250] In the above embodiment, the loading capacity of the transport container determines whether there are any unfilled transport containers needed to transport the target products of the first sub-warehouse. If there are unfilled containers, all target products that need to be loaded into the unfilled containers are redistributed, which effectively reduces packaging material costs and transportation costs.
[0251] In some embodiments, S204 can also be transmitted via Figure 6 To express. Figure 6 A flowchart illustrating a product distribution method provided in yet another embodiment of this disclosure. (See attached flowchart.) Figure 6 As shown, S204 can also be achieved through the following steps:
[0252] S601. For each warehouse, calculate the second product of the initial sub-warehouse quantity of the warehouse and the inventory ratio of each target sales channel, and determine the third sub-warehouse quantity of each target sales channel in the warehouse.
[0253] For example, the quantity of third-tier sub-warehouses for each target sales channel in this warehouse can be calculated using the following formula twenty-one:
[0254]
[0255] Among them, c ki Let be the quantity of the third sub-warehouse of channel k in warehouse i.
[0256] S602. For each target sales channel, sum up the number of third sub-warehouses in each warehouse for that target sales channel.
[0257] For example, the sum of the number of third-tier warehouses in each warehouse of the target sales channel can be calculated using the following formula twenty-two:
[0258]
[0259] Among them, c k This represents the sum of the number of third-level sub-warehouses in each warehouse for channel k.
[0260] S603. For each target sales channel, determine the saturation level of the target sales channel based on the sum obtained from the cumulative processing and the corresponding inventory level of the target sales channel.
[0261] For example, the saturation level of each target sales channel can be calculated using the following formula twenty-three:
[0262] saturation k =c k -ws k Formula 23
[0263] Among them, saturation k Let k be the saturation level of channel k.
[0264] S604. Based on the saturation of each target sales channel, adjust the quantity of the third sub-warehouse corresponding to each target sales channel in the target warehouse to determine the quantity of the target sub-warehouse corresponding to each target sales channel in each warehouse.
[0265] Since multiplying by proportions can result in irregular fractions, for channel K, in order to ensure that the total quantity of the target product in all warehouses within channel K equals the stock quantity of channel K on the purchase order, it is necessary to first identify the same warehouse in different sales channels, namely the target warehouse, and then make adjustments to the quantity of the third warehouse in different channels of that target warehouse.
[0266] If the saturation level is less than 0, it means that the target sales channel is not saturated enough and the number of third-party warehouses on the target sales channel needs to be increased; if the saturation level is greater than 0, it means that the target sales channel is oversaturated and the number of third-party warehouses on the target sales channel needs to be reduced; if the saturation level is equal to 0, it means that the number of third-party warehouses on the target sales channel does not need to be adjusted.
[0267] In one possible implementation, in the target warehouse, if the saturation of any target sales channel is greater than a preset saturation, the number of third sub-warehouses for the target sales channel is reduced until the saturation of the target sales channel reaches the preset saturation; if the saturation of any target sales channel is less than the preset saturation, the number of third sub-warehouses for the target sales channel is increased until the saturation of the target sales channel reaches the preset saturation; the adjusted number of sub-warehouses in the target warehouse is determined as the target sub-warehouse number corresponding to each target sales channel in the target warehouse, and the number of third sub-warehouses for each target sales channel in other warehouses is determined as the target sub-warehouse number for each target sales channel in other warehouses.
[0268] Optionally, the target warehouse can be a warehouse randomly selected from the warehouses, a pre-set warehouse, or a warehouse determined according to preset rules (e.g., the warehouse with the largest total number of third-level sub-warehouses in each target sales channel). It can be determined according to the actual situation, and this disclosure embodiment does not impose specific restrictions on it.
[0269] Optionally, the method for adjusting the quantity of third-party warehouses corresponding to each target sales channel in the target warehouse can be represented by Table 1.
[0270] Table 1
[0271]
[0272] As shown in Table 1, the total third inventory levels of Channel 1, Channel 2, and Channel 3 at the sales channel level are insufficient to meet the inventory requirements of the purchase order, resulting in a saturation deviation. Warehouse 1 is designated as the target warehouse, and the third inventory levels are adjusted across different target sales channels within Warehouse 1 until the inventory requirements for the target sales channels on the purchase order are met.
[0273] In the above embodiments, the multiplication of proportions can result in irregular fractions, leading to discrepancies between the calculated quantity of third-level distribution points for the target sales channel and the inventory quantity for that channel on the purchase order. This embodiment of the present disclosure, after calculating the quantity of third-level distribution points for each target sales channel in each warehouse, combines this with the inventory quantity of that target sales channel to determine its saturation level. Based on the saturation level of each target sales channel, the quantity of third-level distribution points for that target sales channel in the target warehouse is adjusted. This determines the target quantity of distribution points for each target sales channel in each warehouse, ensuring the consistency between the total target quantity of distribution points for each target sales channel in each warehouse and the corresponding inventory quantity, thus improving the accuracy of distribution point processing.
[0274] Based on the above product distribution method, the following two specific examples will be used to illustrate the product distribution method in detail.
[0275] Example 1, Figure 7 A flowchart illustrating a product distribution method provided in yet another embodiment of this disclosure. (See attached flowchart.) Figure 7 As shown, the product's distribution method can also be achieved through the following steps:
[0276] First, preliminary data preparation is conducted. This includes determining the stock quantity of target products for each target sales channel in the purchase order, the existing inventory of target products in each warehouse, the sales lock-in quantity of target products in each target sales channel, the sales ratio of target products in each target sales channel, and the distribution ratio of warehouses within each target sales channel. Further, the initial inventory quantity of target products in each target sales channel and the secondary inventory quantity in each warehouse within each target sales channel are determined. Then, the stockout quantity in each warehouse is determined, and the initial distribution quantity of target products in each warehouse is determined. Finally, based on the warehouse consolidation logic, the initial distribution quantity of target products in each warehouse is determined, and the target distribution quantity of target products for each target sales channel in each warehouse is determined.
[0277] Example 2, Figure 8 A flowchart of a product distribution method provided in another embodiment of this disclosure.
[0278] like Figure 8 As shown, the product's distribution method can also be achieved through the following steps:
[0279] Based on the remaining allocable amount, determine whether it is sufficient to allocate to each target sales channel individually. If so, determine the allocation for each sales channel (e.g., Figure 8 The allocation is determined by the first inventory quantity corresponding to Channel 1, Channel t, and C-end channels, and the second inventory quantity corresponding to each warehouse within each target sales channel; if this is not possible, the allocation is stopped.
[0280] This disclosure constructs a product warehousing strategy based on the characteristics of channel inventory distribution. From the perspective of omnichannel inventory, it proactively considers the reasonable allocation of inventory needs between B-end and C-end channels, effectively promoting reasonable inventory distribution, improving inventory utilization, reducing the rate of cross-regional shipments, and minimizing inter-warehouse transfer costs caused by inventory imbalances. Simultaneously, it generates positive feedback, accumulating historical sales data at the channel and warehouse levels, and analyzing and calculating sales ratios and warehouse allocation ratios.
[0281] Exemplary media
[0282] After introducing the methods of exemplary embodiments of this disclosure, the following references are made. Figure 9 The storage medium of the exemplary embodiments of this disclosure will be described.
[0283] refer to Figure 9 As shown, the storage medium 900 stores a program product for implementing the above-described method according to an embodiment of the present disclosure. This program product may be a portable compact disc read-only memory (CD-ROM) and includes computer-executable instructions for causing a computing device to execute the compartmentation method of the product provided in this disclosure. However, the program product of this disclosure is not limited thereto.
[0284] The program product may employ any combination of one or more readable media. A readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.
[0285] A readable signal medium may include data signals propagated in baseband or as part of a carrier wave, carrying computer-executed instructions. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A readable signal medium may also be any readable medium other than a readable storage medium.
[0286] Computer-executable instructions for performing the operations disclosed herein can be written in any combination of one or more programming languages, including object-oriented programming languages such as Java and C++, and conventional procedural programming languages such as C or similar languages. The computer-executable instructions can be executed entirely on the user's computing device, partially on the user's computing device, partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing devices can be connected to the user's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN).
[0287] Exemplary device
[0288] Having introduced the medium of exemplary embodiments of this disclosure, the following references are made to... Figure 10 The compartmentation device of the product of the exemplary embodiment of this disclosure will be described to implement the method in any of the above method embodiments. The implementation principle and technical effect are similar, and will not be repeated here.
[0289] Figure 10 This is a schematic diagram of the structure of a product compartmentation device provided in an embodiment of the present disclosure, as shown below. Figure 10 As shown, the product compartmentation device 1000 of this embodiment includes: a determination module 1001. Wherein:
[0290] The determination module 1001 is used to determine the first inventory of the target product in each target sales channel based on the total inventory of the target product in all warehouses and the purchase order data; wherein, the purchase order data includes the total stock of the target product and the stock ratio corresponding to each target sales channel, and the first inventory of the target product in each target sales channel is the inventory of the target product in the target sales channel after the total stock of the target product is divided into warehouses.
[0291] The determination module 1001 is also used to determine, for each target sales channel, the second inventory of the target product in each warehouse within the target sales channel based on the first inventory corresponding to the target sales channel and the distribution ratio of the target product in each warehouse within the target sales channel; wherein, the second inventory of the target product in each warehouse within the target sales channel is the inventory of the target product in each warehouse within the target sales channel after the total stock of the target product is distributed into warehouses.
[0292] The determination module 1001 is also used to determine the initial distribution quantity of the target product in the warehouse for each warehouse, based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse.
[0293] The determination module 1001 is also used to determine the target distribution quantity of the target product for each target sales channel in each warehouse based on the initial distribution quantity of each warehouse and the inventory ratio of each target sales channel.
[0294] In one embodiment of this disclosure, when determining the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data, the determining module 1001 is specifically used for:
[0295] For each target sales channel, the third inventory level is determined based on the total inventory level, total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel; whereby the sales lock-in quantity is the minimum number of products that the target product is configured in the target sales channel.
[0296] For each target sales channel, determine the first inventory level of the target sales channel based on the third inventory level, total inventory level, total stock level, and the first inventory level already determined in other target sales channels.
[0297] In another embodiment of this disclosure, when the determining module 1001 determines the third inventory level of each target sales channel based on the total inventory level, the total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel, it is specifically used for:
[0298] For each target sales channel, determine the fourth inventory level of the target product in the target sales channel based on the total inventory level, the sales lock-in quantity corresponding to the target sales channel, and the inventory ratio.
[0299] For each target sales channel, determine the fifth inventory level of the target product in the target sales channel based on the total inventory level, total stock level, and the sales ratio corresponding to the target sales channel.
[0300] For each target sales channel, the larger of the fourth and fifth inventory levels is determined as the third inventory level for that target sales channel.
[0301] In another embodiment of this disclosure, when determining the first inventory level of a target sales channel based on the third inventory level, the total inventory level, the total stock level, and the first inventory level already determined in other target sales channels, the determining module 1001 is specifically used for:
[0302] For each target sales channel, determine the remaining allocable quantity for that target sales channel based on the total inventory, total stock, and the first inventory already determined in other target sales channels;
[0303] The smallest quantity among the third inventory level and the remaining allocable quantity is determined as the first inventory level for the target sales channel.
[0304] In another embodiment of this disclosure, when the determining module 1001 determines the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of warehouses within each target sales channel, and the existing inventory quantity of the warehouse, it is specifically used for:
[0305] For each warehouse, calculate the sum of the second inventory levels in all warehouses within the target sales channels, and the first difference between this sum and the existing inventory level. This first difference is then determined as the stockout amount of the target product in the warehouse.
[0306] For each warehouse, the initial quantity of the target product in each warehouse is determined based on the total stockout, total inventory, and stockout of all warehouses.
[0307] In another embodiment of this disclosure, the determining module 1001, when determining the initial distribution quantity of the target product in each warehouse based on the total stockout quantity, total stockout quantity, and stockout quantity of all warehouses, is specifically used for:
[0308] For each warehouse, calculate the ratio of the warehouse's stockout to the total stockout.
[0309] For each warehouse, the initial quantity of the target product in the warehouse is determined based on the ratio and the total inventory.
[0310] In another embodiment of this disclosure, the determining module 1001, when determining the initial distribution quantity of the target product in each warehouse based on the ratio and the total inventory, is specifically used for:
[0311] For each warehouse, calculate the first product of the ratio and the total inventory quantity, and determine the initial distribution quantity of the target product in the warehouse.
[0312] In another embodiment of this disclosure, the determining module 1001, when determining the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of warehouses within each target sales channel, and the existing inventory quantity of the warehouse, is specifically used for:
[0313] The quantity of the target product in the first sub-warehouse of each warehouse is determined based on the second inventory quantity of the target product in each warehouse, the existing inventory quantity, and the total stock quantity.
[0314] For each warehouse, based on the loading capacity of the transport containers, determine whether there are any underfilled transport containers required when transporting the target quantity of products for the first sub-warehouse.
[0315] For each warehouse, if there are cases where the target products of the first sub-warehouse quantity are not fully loaded when transporting them, then obtain the quantity of target products allocated to the warehouse that need to be loaded into the partially loaded boxes;
[0316] Based on the quantity of target products allocated to each warehouse that need to be loaded into boxes that are not full, obtain the total quantity of all target products that need to be loaded into boxes that are not full.
[0317] Based on the total quantity of all target products that need to be loaded into containers that are not fully filled, and the loading capacity of the transport containers, all target products that need to be loaded into containers that are not fully filled are redistributed to determine the second distribution quantity of target products in each warehouse; wherein, the second distribution quantity is the quantity of target products redistributed to each warehouse.
[0318] The initial quantity of the target product in each warehouse is obtained based on the first sub-warehouse quantity of the target product in each warehouse, the loading capacity of the transport container, and the second sub-warehouse quantity of the target product in each warehouse.
[0319] In another embodiment of this disclosure, when determining the quantity of target products in the second sub-warehouse of each warehouse by redistributing all target products that need to be loaded into the unfilled containers based on the total quantity of all target products that need to be loaded into the unfilled containers and the loading capacity of the transport containers, the determining module 1001 is specifically used for:
[0320] Based on the order of quantity in the first sub-warehouse, all target products that need to be loaded into the partially filled containers are allocated to each warehouse in the same quantity as the loading capacity of the transport container, until all target products that need to be loaded into the partially filled containers are allocated, thus obtaining the quantity of target products in the second sub-warehouse in each warehouse.
[0321] In another embodiment of this disclosure, when determining the target distribution quantity of the target product for each target sales channel in each warehouse based on the initial distribution quantity for each warehouse and the inventory ratio for each target sales channel, the determining module 1001 is specifically used for:
[0322] For each warehouse, calculate the second product of the initial distribution quantity of the warehouse and the inventory ratio of each target sales channel to determine the third distribution quantity of each target sales channel in the warehouse.
[0323] For each target sales channel, the quantity of the third sub-warehouse in each warehouse of the target sales channel is accumulated;
[0324] For each target sales channel, the saturation level of the target sales channel is determined based on the cumulative sum obtained from the cumulative processing and the corresponding inventory level of the target sales channel.
[0325] Based on the saturation of each target sales channel, the number of third sub-warehouses corresponding to each target sales channel in the target warehouse is adjusted to determine the number of target sub-warehouses corresponding to each target sales channel in each warehouse.
[0326] In another embodiment of this disclosure, when determining the number of third sub-warehouses corresponding to each target sales channel in the target warehouse based on the saturation of each target sales channel, the determining module 1001 is specifically used for:
[0327] If the saturation of any target sales channel in the target warehouse exceeds the preset saturation level, the number of third sub-warehouses in the target sales channel will be reduced until the saturation of the target sales channel reaches the preset saturation level.
[0328] If the saturation of any target sales channel is less than the preset saturation, then increase the number of third-level distribution warehouses in the target sales channel until the saturation of the target sales channel reaches the preset saturation.
[0329] The adjusted number of sub-warehouses in the target warehouse is determined as the target sub-warehouse quantity corresponding to each target sales channel in the target warehouse, and the third sub-warehouse quantity of each target sales channel in other warehouses is determined as the target sub-warehouse quantity of each target sales channel in other warehouses.
[0330] Thirdly, embodiments of this disclosure provide a computing device, including: a processor, and a memory communicatively connected to the processor;
[0331] The memory stores instructions that the computer executes;
[0332] The processor executes computer-executable instructions stored in memory to implement the partitioning method of the product as described in the first aspect of this disclosure.
[0333] Fourthly, embodiments of this disclosure provide a storage medium storing computer program instructions, which, when executed, implement the partitioning method of the product as described in the first aspect of this disclosure.
[0334] Exemplary computing device
[0335] Having described the methods, media, and apparatus of exemplary embodiments of this disclosure, the following references... Figure 11 A computing device according to an exemplary embodiment of the present disclosure will be described.
[0336] Figure 11 The computing device 1100 shown is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments disclosed herein.
[0337] like Figure 11As shown, the computing device 1100 is presented in the form of a general-purpose computing device. The components of the computing device 1100 may include, but are not limited to: at least one processing unit 1101, at least one storage unit 1102, and a bus 1103 connecting different system components (including the processing unit 1101 and the storage unit 1102). The at least one storage unit 1102 stores computer-executable instructions; the at least one processing unit 1101 includes a processor that executes the computer-executable instructions to implement the methods described above.
[0338] Bus 1103 includes a data bus, a control bus, and an address bus.
[0339] Storage unit 1102 may include readable media in the form of volatile memory, such as random access memory (RAM) 11021 and / or cache memory 11022, and may further include readable media in the form of non-volatile memory, such as read-only memory (ROM) 11023.
[0340] Storage unit 1102 may also include a program / utility 11025 having a set (at least one) of program modules 11024, such program modules 11024 including but not limited to: operating system, one or more application programs, other program modules and program data, each or some combination of these examples may include an implementation of a network environment.
[0341] The computing device 1100 can also communicate with one or more external devices 1104 (e.g., keyboard, pointing device, etc.). This communication can be performed via input / output (I / O) interface 1105. Furthermore, the computing device 1100 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 1106. Figure 11 As shown, network adapter 1106 communicates with other modules of computing device 1100 via bus 1103. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with computing device 1100, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0342] It should be noted that although several units / modules or sub-units / modules of the product compartmentation device are mentioned in the detailed description above, this division is merely exemplary and not mandatory. In fact, according to embodiments of this disclosure, the features and functions of two or more units / modules described above can be embodied in one unit / module. Conversely, the features and functions of one unit / module described above can be further divided and embodied by multiple units / modules.
[0343] Furthermore, although the operations of the methods disclosed herein are described in a specific order in the accompanying drawings, this does not require or imply that these operations must be performed in that specific order, or that all of the operations shown must be performed to achieve the desired result. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined into one step, and / or one step may be broken down into multiple steps.
[0344] While the spirit and principles of this disclosure have been described with reference to several specific embodiments, it should be understood that this disclosure is not limited to the disclosed specific embodiments, and the division of aspects does not imply that features in these aspects cannot be combined for benefit; such division is merely for convenience of expression. This disclosure is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.
Claims
1. A method for distributing products into warehouses, comprising: Based on the total inventory of the target product in all warehouses and the purchase order data, determine the first inventory of the target product in each target sales channel; wherein, the purchase order data includes the total stock of the target product and the stock ratio corresponding to each target sales channel, and the first inventory of the target product in each target sales channel is the inventory of the target product in the target sales channel after the total stock of the target product is divided into warehouses. For each target sales channel, a second inventory of the target product in each warehouse within the target sales channel is determined based on the first inventory quantity corresponding to the target sales channel and the warehouse allocation ratio of the target product in each warehouse within the target sales channel; wherein, the second inventory of the target product in each warehouse within the target sales channel is the inventory quantity of the target product in each warehouse within the target sales channel after the total stock quantity of the target product has been allocated to different warehouses. For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse. Based on the initial distribution quantity of each warehouse and the inventory ratio of each target sales channel, determine the target distribution quantity of the target product for each target sales channel in each warehouse. The step of determining the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data includes: For each target sales channel, a third inventory level is determined based on the total inventory level, the total stock level, the sales lock-in quantity, the stock level ratio, and the sales ratio corresponding to the target sales channel; wherein, the sales lock-in quantity is the minimum number of the target product configured in the target sales channel; For each target sales channel, the remaining allocable quantity for that target sales channel is determined based on the total inventory, the total stock, and the first inventory already determined in other target sales channels. The smallest quantity among the third inventory quantity and the remaining allocable quantity is determined as the first inventory quantity of the target sales channel; Specifically, for each target sales channel, a third inventory level is determined based on the total inventory level, the total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel. This includes: For each target sales channel, the fourth inventory level of the target product in that target sales channel is determined based on the total inventory level, the sales lock-in quantity corresponding to the target sales channel, and the inventory ratio. For each target sales channel, the fifth inventory level of the target product in that target sales channel is determined based on the total inventory level, the total stock level, and the sales ratio corresponding to the target sales channel. For each target sales channel, the larger of the fourth and fifth inventory quantities is determined as the third inventory quantity for that target sales channel.
2. The method according to claim 1, wherein determining the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse within each target sales channel, and the existing inventory quantity of the warehouse comprises: For each warehouse, calculate the sum of the second inventory levels of the warehouses across all target sales channels, and the first difference between this sum and the existing inventory level. The first difference is then determined as the stockout amount of the target product in that warehouse. For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse.
3. The method according to claim 2, wherein determining the initial distribution quantity of the target product in each warehouse based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse comprises: For each warehouse, calculate the ratio of the stockout quantity in that warehouse to the total stockout quantity; For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the ratio and the total inventory.
4. The method according to claim 3, wherein determining the initial distribution quantity of the target product in each warehouse based on the ratio and the total inventory quantity comprises: For each warehouse, calculate the first product of the ratio and the total inventory quantity, and determine the first product as the initial distribution quantity of the target product in that warehouse.
5. The method according to claim 1, wherein determining the initial distribution quantity of the target product in each warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse within each target sales channel, and the existing inventory quantity of the warehouse comprises: The quantity of the target product in the first sub-warehouse of each warehouse is determined based on the second inventory quantity of the target product in each warehouse, the existing inventory quantity, and the total stock quantity. For each warehouse, based on the loading capacity of the transport containers, determine whether there are any underfilled transport containers required when transporting the target quantity of the first sub-warehouse; For each warehouse, if there are cases where the target products of the first sub-warehouse quantity are not fully loaded when transporting them, then obtain the quantity of target products allocated to the warehouse that need to be loaded into the partially loaded boxes; Based on the quantity of target products allocated to each warehouse that need to be loaded into boxes that are not full, obtain the total quantity of all target products that need to be loaded into boxes that are not full. Based on the total quantity of all target products that need to be loaded into the partially filled containers, and the loading capacity of the transport containers, the target products that need to be loaded into the partially filled containers are redistributed to determine the second distribution quantity of the target products in each warehouse; wherein, the second distribution quantity is the quantity of the target products redistributed to each warehouse. The initial quantity of the target product in each warehouse is obtained based on the first sub-warehouse quantity of the target product in each warehouse, the loading capacity of the transport container, and the second sub-warehouse quantity of the target product in each warehouse.
6. The method according to claim 5, wherein the step of redistributing all target products that need to be loaded into the unfilled containers based on the total quantity of all target products that need to be loaded into the unfilled containers and the loading capacity of the transport containers, and determining the quantity of the target products in the second sub-warehouse of each warehouse, includes: Based on the order of quantity in the first sub-warehouse, all target products that need to be loaded into the partially filled containers are allocated to each warehouse in the same quantity as the loading capacity of the transport container, until all target products that need to be loaded into the partially filled containers are allocated, thus obtaining the quantity of the target products in the second sub-warehouse in each warehouse.
7. The method according to claim 1, wherein determining the target distribution quantity of the target product for each target sales channel in each warehouse based on the initial distribution quantity corresponding to each warehouse and the inventory ratio of each target sales channel includes: For each warehouse, calculate the second product of the initial distribution quantity of the warehouse and the inventory ratio of each target sales channel to determine the third distribution quantity of each target sales channel in the warehouse; For each target sales channel, the quantity of the third sub-warehouse in each warehouse of the target sales channel is accumulated; For each target sales channel, the saturation level of the target sales channel is determined based on the sum obtained from the cumulative processing and the corresponding inventory level of the target sales channel. Based on the saturation of each target sales channel, the number of third sub-warehouses corresponding to each target sales channel in the target warehouse is adjusted to determine the number of target sub-warehouses corresponding to each target sales channel in each warehouse.
8. The method according to claim 7, wherein adjusting the number of third sub-warehouses corresponding to each target sales channel in the target warehouse according to the saturation of each target sales channel, and determining the number of target sub-warehouses corresponding to each target sales channel in each warehouse, includes: In the target warehouse, if the saturation of any target sales channel is greater than the preset saturation, the number of third sub-warehouses of the target sales channel shall be reduced until the saturation of the target sales channel reaches the preset saturation. If the saturation of any target sales channel is less than the preset saturation, then the number of third sub-warehouses in the target sales channel is increased until the saturation of the target sales channel reaches the preset saturation. The adjusted number of sub-warehouses in the target warehouse is determined as the target sub-warehouse number corresponding to each target sales channel in the target warehouse, and the third sub-warehouse number of each target sales channel in other warehouses is determined as the target sub-warehouse number of each target sales channel in other warehouses.
9. A product compartmentation device, comprising: The determination module is used to determine the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data; wherein, the purchase order data includes the total stock level of the target product and the stock level ratio corresponding to each target sales channel, and the first inventory level of the target product in each target sales channel is the inventory level of the target product in the target sales channel after the total stock level of the target product is divided into warehouses; The determining module is further configured to, for each target sales channel, determine the second inventory of the target product in each warehouse within the target sales channel based on the first inventory corresponding to the target sales channel and the distribution ratio of the target product in each warehouse within the target sales channel; wherein, the second inventory of the target product in each warehouse within the target sales channel is the inventory of the target product in each warehouse within the target sales channel after the total stock of the target product has been distributed into warehouses; The determining module is further configured to determine, for each warehouse, the initial distribution quantity of the target product in the warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse. The determining module is further configured to determine the target distribution quantity of the target product corresponding to each target sales channel in each warehouse based on the initial distribution quantity of each warehouse and the inventory ratio of each target sales channel. The determining module is used to determine the first inventory level of the target product in each target sales channel based on the total inventory level of the target product in all warehouses and purchase order data, specifically for: For each target sales channel, a third inventory level is determined based on the total inventory level, the total stock level, the sales lock-in quantity, the stock level ratio, and the sales ratio corresponding to the target sales channel; wherein, the sales lock-in quantity is the minimum number of the target product configured in the target sales channel; For each target sales channel, the first inventory of the target sales channel is determined based on the third inventory, the total inventory, the total stock, and the first inventory already determined in other target sales channels. The determining module is used to determine the third inventory level for each target sales channel based on the total inventory level, the total stock level, and the sales lock-in quantity, stock level ratio, and sales ratio corresponding to the target sales channel. Specifically, it is used for: For each target sales channel, the fourth inventory level of the target product in that target sales channel is determined based on the total inventory level, the sales lock-in quantity corresponding to the target sales channel, and the inventory ratio. For each target sales channel, the fifth inventory level of the target product in that target sales channel is determined based on the total inventory level, the total stock level, and the sales ratio corresponding to the target sales channel. For each target sales channel, the larger of the fourth and fifth inventory quantities is determined as the third inventory quantity for that target sales channel; The determining module is used to determine the first inventory quantity of each target sales channel based on the third inventory quantity, the total inventory quantity, the total reserve quantity, and the first inventory quantity already determined in other target sales channels. Specifically, it is used to: For each target sales channel, the remaining allocable quantity for that target sales channel is determined based on the total inventory, the total stock, and the first inventory already determined in other target sales channels. The smallest quantity among the third inventory quantity and the remaining allocable quantity is determined as the first inventory quantity of the target sales channel.
10. The apparatus of claim 9, wherein the determining module is configured to, for each warehouse, determine the initial distribution quantity of the target product in the warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse, specifically configured to: For each warehouse, calculate the sum of the second inventory levels of the warehouses across all target sales channels, and the first difference between this sum and the existing inventory level. The first difference is then determined as the stockout amount of the target product in that warehouse. For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse.
11. The apparatus according to claim 10, wherein the determining module is configured to, for each warehouse, determine the initial distribution quantity of the target product in the warehouse based on the total stockout quantity of all warehouses, the total stockout quantity, and the stockout quantity of each warehouse, specifically configured to: For each warehouse, calculate the ratio of the stockout quantity in that warehouse to the total stockout quantity; For each warehouse, the initial distribution quantity of the target product in that warehouse is determined based on the ratio and the total inventory.
12. The apparatus according to claim 11, wherein the determining module is configured to determine, for each warehouse, the initial distribution quantity of the target product in the warehouse based on the ratio and the total inventory quantity, specifically configured to: For each warehouse, calculate the first product of the ratio and the total inventory quantity, and determine the first product as the initial distribution quantity of the target product in that warehouse.
13. The apparatus according to claim 9, wherein the determining module is configured to, for each warehouse, determine the initial distribution quantity of the target product in the warehouse based on the total stock preparation quantity, the second inventory quantity of the warehouse in each target sales channel, and the existing inventory quantity of the warehouse, specifically configured to: The quantity of the target product in the first sub-warehouse of each warehouse is determined based on the second inventory quantity of the target product in each warehouse, the existing inventory quantity, and the total stock quantity. For each warehouse, based on the loading capacity of the transport containers, determine whether there are any underfilled transport containers required when transporting the target quantity of the first sub-warehouse; For each warehouse, if there are cases where the target products of the first sub-warehouse quantity are not fully loaded when transporting them, then obtain the quantity of target products allocated to the warehouse that need to be loaded into the partially loaded boxes; Based on the quantity of target products allocated to each warehouse that need to be loaded into boxes that are not full, obtain the total quantity of all target products that need to be loaded into boxes that are not full. Based on the total quantity of all target products that need to be loaded into partially filled containers, and the loading capacity of the transport containers, the target products that need to be loaded into partially filled containers are redistributed to determine the second sub-warehouse quantity of the target products in each warehouse; wherein, The second sub-warehouse quantity is the quantity of the target product that is redistributed to each warehouse; The initial quantity of the target product in each warehouse is obtained based on the first sub-warehouse quantity of the target product in each warehouse, the loading capacity of the transport container, and the second sub-warehouse quantity of the target product in each warehouse.
14. The apparatus according to claim 13, wherein the determining module is configured to redistribute all target products that need to be loaded into the unfilled containers based on the total quantity of all target products that need to be loaded into the unfilled containers and the loading capacity of the transport containers, and to determine the quantity of the target products in the second sub-warehouse of each warehouse, specifically configured to: Based on the order of quantity in the first sub-warehouse, all target products that need to be loaded into the partially filled containers are allocated to each warehouse in the same quantity as the loading capacity of the transport container, until all target products that need to be loaded into the partially filled containers are allocated, thus obtaining the quantity of the target products in the second sub-warehouse in each warehouse.
15. The apparatus according to claim 9, wherein the determining module is configured to determine the target distribution quantity of the target product corresponding to each target sales channel in each warehouse based on the initial distribution quantity corresponding to each warehouse and the inventory ratio of each target sales channel, specifically configured to: For each warehouse, calculate the second product of the initial distribution quantity of the warehouse and the inventory ratio of each target sales channel to determine the third distribution quantity of each target sales channel in the warehouse; For each target sales channel, the quantity of the third sub-warehouse in each warehouse of the target sales channel is accumulated; For each target sales channel, the saturation level of the target sales channel is determined based on the sum obtained from the cumulative processing and the corresponding inventory level of the target sales channel. Based on the saturation of each target sales channel, the number of third sub-warehouses corresponding to each target sales channel in the target warehouse is adjusted to determine the number of target sub-warehouses corresponding to each target sales channel in each warehouse.
16. The apparatus according to claim 15, wherein the determining module is configured to adjust the number of third sub-warehouses corresponding to each target sales channel in the target warehouse according to the saturation of each target sales channel, and determine the number of target sub-warehouses corresponding to each target sales channel in each warehouse, specifically configured to: In the target warehouse, if the saturation of any target sales channel is greater than the preset saturation, the number of third sub-warehouses of the target sales channel shall be reduced until the saturation of the target sales channel reaches the preset saturation. If the saturation of any target sales channel is less than the preset saturation, then the number of third sub-warehouses in the target sales channel is increased until the saturation of the target sales channel reaches the preset saturation. The adjusted number of sub-warehouses in the target warehouse is determined as the target sub-warehouse number corresponding to each target sales channel in the target warehouse, and the third sub-warehouse number of each target sales channel in other warehouses is determined as the target sub-warehouse number of each target sales channel in other warehouses.
17. A computing device, comprising: A processor, and a memory communicatively connected to the processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory to implement the product compartmentation method as described in any one of claims 1 to 8.
18. A storage medium storing computer program instructions, which, when executed, implement a compartmenting method for the product as described in any one of claims 1 to 8.
19. A computer program product comprising a computer program that, when executed by a processor, implements the compartmenting method of the product as described in any one of claims 1 to 8.
Citation Information
Patent Citations
CN113888095A