A commodity return order quantity calculation method and device, electronic equipment and storage medium

Abstract

The application discloses a commodity return order quantity calculation method and device, electronic equipment and a storage medium, and is used to solve the technical problem that the calculation of return order quantity in the traditional supply chain mode all depends on manual operation, which makes the calculation of return order quantity inefficient under a large number of SKU commodity quantities, and results in high labor cost. The application comprises the following steps: acquiring all market orders and supply shipment specifications of a target commodity; adjusting each market order according to the supply shipment specifications to obtain adjusted demand quantity; acquiring the resource pool occupation quantity corresponding to each market order; adjusting the resource pool occupation quantity according to the supply shipment specifications to obtain adjusted occupation quantity; calculating the initial return order quantity according to the adjusted demand quantity and the adjusted occupation quantity; and adjusting the initial return order quantity according to the supply shipment specifications to obtain the target return order quantity of the target commodity.

Description

Technical Field

[0001] This invention relates to the field of supply and demand allocation technology, and in particular to a method, apparatus, electronic device and storage medium for calculating the quantity of returned goods orders. Background Technology

[0002] Some retail companies operate using a pull supply chain model, which requires managing customer demand and orders for hundreds or even thousands of products. At the same time, the minimum order quantity (MOQ) in a pull supply chain becomes an important metric in business operations.

[0003] For large-scale retail enterprises, the volume of goods inside the enterprise is large, reaching tens of thousands of SKUs. The process of confirming the MOQ for each SKU is actually confirming the current purchase quantity of the goods (usually referring to the reorder quantity) so as to match the reorder quantity to the supplier for delivery.

[0004] In traditional supply chain models, the calculation of repeat order quantities relies entirely on manual operation, which makes the calculation of repeat order quantities inefficient when dealing with a huge number of SKU products, resulting in high labor costs. Summary of the Invention

[0005] This invention provides a method, apparatus, electronic device, and storage medium for calculating the quantity of repeat orders, which solves the technical problem that the calculation of repeat order quantity in the traditional supply chain model relies entirely on manual operation, resulting in low efficiency in calculating the repeat order quantity with a huge number of SKUs and leading to high labor costs.

[0006] This invention provides a method for calculating the quantity of returned goods, including:

[0007] Obtain all market orders and supply specifications for the target product;

[0008] Adjust each market order according to the supply and shipment specifications to obtain the adjusted demand.

[0009] Obtain the resource pool usage corresponding to each of the aforementioned market orders;

[0010] The resource pool occupancy is adjusted according to the supply and shipment specifications to obtain the adjusted occupancy.

[0011] Calculate the initial return order quantity based on the adjusted demand and the adjusted occupancy.

[0012] The initial return order quantity is adjusted according to the supply and shipment specifications to obtain the target return order quantity for the target product.

[0013] Optionally, the step of adjusting each market order according to the supply and shipment specifications to obtain the adjusted demand includes:

[0014] Obtain the original demand for each of the aforementioned market orders;

[0015] Calculate the demand remainder between the original demand quantity and the supply shipment specifications for each market order in sequence;

[0016] The demand remainder corresponding to each market order is removed sequentially to obtain the adjusted demand number for each market order.

[0017] Optionally, the resource pool occupancy includes the inventory pool occupancy and the shared pool occupancy; the step of adjusting the resource pool occupancy according to the supply shipment specifications to obtain the adjusted occupancy includes:

[0018] Determine the order of adjustment for the market orders;

[0019] The inventory pool occupancy is adjusted according to the adjustment order and the supply shipment specifications to generate an inventory adjustment amount;

[0020] The shared pool occupancy is adjusted according to the adjustment order and the supply and shipment specifications to generate a shared adjustment amount;

[0021] The adjustment occupancy for each market order is calculated using the inventory adjustment amount and the shared adjustment amount.

[0022] Optionally, the step of determining the adjustment order of the market orders includes:

[0023] Obtain the market priority for each of the aforementioned market orders;

[0024] The market orders are sorted according to the market priority to obtain the first adjustment order;

[0025] Filter orders from the same market with the same market priority;

[0026] The orders in the same-level market are sorted according to the demand number of the orders in the same-level market to obtain the second adjustment order;

[0027] Filter orders from the same market segment with the same demand.

[0028] Get the creation time of orders from the same market segment with the same demand.

[0029] Based on the creation time, orders from the same market segment with the same demand are sorted to obtain the third adjustment order;

[0030] The adjustment order of the market order is generated by using the first adjustment order, the second adjustment order, and the third adjustment order.

[0031] Optionally, the step of adjusting the inventory pool occupancy based on the adjustment order and the supply shipment specifications to generate an inventory adjustment amount includes:

[0032] The total inventory pool occupancy is calculated using all the aforementioned inventory pool occupancy amounts.

[0033] Calculate the inventory balance between the total inventory in the inventory pool and the supplied shipment specifications;

[0034] When the inventory balance is not zero, the inventory adjustment amount for the market orders is generated by deducting the inventory pool occupancy of the market orders based on the inventory balance, in accordance with the adjustment order.

[0035] Optionally, the step of adjusting the shared pool occupancy based on the adjustment order and the supply shipment specifications to obtain the shared adjustment amount includes:

[0036] The total shared pool usage is calculated using all the aforementioned shared pool usage values.

[0037] Calculate the shared remainder between the total amount occupied by the shared pool and the supply shipment specifications;

[0038] When the shared remainder is not 0, the shared adjustment amount of the market order is generated by deducting the shared pool occupancy of the market order based on the shared remainder, in accordance with the adjustment order.

[0039] Optionally, the step of adjusting the initial reorder quantity according to the supply and shipment specifications to obtain the target reorder quantity of the target product includes:

[0040] Calculate the total number of return orders using the initial return order quantity corresponding to all market orders;

[0041] Calculate the total number of return orders and the return order remainder for the supplied shipment specifications;

[0042] The target number of repeat orders is obtained by subtracting the repeat order remainder from the total number of repeat orders.

[0043] The present invention also provides a device for calculating the quantity of returned goods, comprising:

[0044] The acquisition module is used to acquire all market orders and supply specifications for the target product;

[0045] The demand calculation module is used to adjust each market order according to the supply and shipment specifications to obtain the adjusted demand.

[0046] The resource pool usage acquisition module is used to acquire the resource pool usage corresponding to each market order.

[0047] The occupancy calculation module is used to adjust the resource pool occupancy according to the supply and shipment specifications to obtain the adjusted occupancy.

[0048] The initial return order quantity calculation module is used to calculate the initial return order quantity based on the adjustment demand and the adjustment occupancy.

[0049] The target return order quantity calculation module is used to adjust the initial return order quantity according to the supply and shipment specifications to obtain the target return order quantity of the target product.

[0050] The present invention also provides an electronic device, the device comprising a processor and a memory:

[0051] The memory is used to store program code and transmit the program code to the processor;

[0052] The processor is used to execute the product return order quantity calculation method as described above, according to the instructions in the program code.

[0053] The present invention also provides a computer-readable storage medium for storing program code for executing the product return order quantity calculation method as described in any of the preceding claims.

[0054] As can be seen from the above technical solution, the present invention has the following advantages: The present invention adjusts each market order according to the supply shipment specifications to obtain the adjusted demand quantity that meets the supply shipment specifications; then, it adjusts the resource pool occupancy according to the supply shipment specifications to obtain the adjusted occupancy quantity that meets the supply shipment specifications; thereby maximizing the consumption of existing resources in the resource pool, reducing the number of repeat orders, and thus saving procurement costs. Next, the initial repeat order quantity is calculated based on the adjusted demand quantity and adjusted occupancy quantity of each market order, and the initial repeat order quantity is adjusted according to the supply shipment specifications to obtain the target repeat order quantity that meets the supply shipment specifications. The entire process requires minimal manual intervention and can automatically calculate the repeat order quantity, improving the calculation efficiency of repeat order quantity and reducing labor costs. Attached Figure Description

[0055] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0056] Figure 1 A flowchart illustrating the steps of a method for calculating the quantity of returned goods provided in an embodiment of the present invention;

[0057] Figure 2 A flowchart illustrating the steps of a method for calculating the quantity of returned goods, as provided in another embodiment of the present invention;

[0058] Figure 3 This is a structural block diagram of a product return order quantity calculation device provided in an embodiment of the present invention. Detailed Implementation

[0059] This invention provides a method, apparatus, electronic device, and storage medium for calculating the quantity of repeat orders, which solves the technical problem that the calculation of repeat order quantities in the traditional supply chain model relies entirely on manual operation, resulting in low efficiency in calculating repeat order quantities with a huge number of SKUs and leading to high labor costs.

[0060] To make the objectives, features, and advantages of this invention more apparent and understandable, the technical solutions of the embodiments of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described below are only some embodiments of this invention, and not all embodiments. Based on the embodiments of this invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this invention.

[0061] Please see Figure 1 , Figure 1 A flowchart illustrating the steps of a method for calculating the quantity of returned goods provided in an embodiment of the present invention.

[0062] The present invention provides a method for calculating the quantity of returned orders for goods, which may specifically include the following steps:

[0063] Step 101: Obtain all market orders and supply specifications for the target product;

[0064] A market order is a document issued by a customer to purchase a specific product. The market order records information such as the market in which the product is purchased, the market priority of that market, and the quantity of the product to be purchased. Retail businesses can use market orders to initiate purchase requests to product suppliers.

[0065] Supply specifications refer to the packaging standards used by commodity suppliers when providing target goods to retail enterprises. In one example, supply specifications could be medium-sized packages, full cases, etc., with several target goods forming a medium-sized package, and several medium-sized packages forming a full case.

[0066] Obtaining market orders for a target product allows us to determine the total demand for that product, which in turn helps us determine the quantity of the target product to purchase from suppliers.

[0067] It should be noted that in real-world scenarios, before obtaining market orders for a target product, it is necessary to determine whether the target product falls into any of the following categories:

[0068] Temporary delisting, prohibited procurement list, lifecycle plan elimination and actual elimination (i.e., eliminating certain suppliers), EOS delisting, SAP delisting.

[0069] If yes, then no action is taken; otherwise, the corresponding market order is obtained, and subsequent steps are executed.

[0070] The prohibited procurement list refers to a list of goods that are prohibited from being purchased.

[0071] EOS (Electronic Ordering System) is a computer system that allows businesses to process various information from ordering to order acceptance online using communication networks (value-added networks or the Internet) and terminal equipment.

[0072] SAP (System Applications and Products) is a suite of enterprise management solution software.

[0073] Step 102: Adjust each market order according to the supply and shipment specifications to obtain the adjusted demand.

[0074] In this embodiment of the invention, the demand for each market order can be adjusted to an integer multiple of the supply shipment specification to obtain the adjusted demand.

[0075] It should be noted that in actual production, in order to avoid the accumulation of target products, retail companies will not actively increase the demand from customers in each market. Therefore, the adjustment of the demand is to take the integer multiple of the supply and shipment specifications downward.

[0076] Step 103: Obtain the resource pool usage corresponding to each market order;

[0077] In this embodiment of the invention, the resource pool refers to a stored pool of target goods resources that can be directly allocated to users. When a retail enterprise receives a market order, it can allocate a portion of the order's inventory to the resource pool, thereby reducing the number of target goods it needs to purchase from suppliers.

[0078] Step 104: Adjust the resource pool usage according to the supply and shipment specifications to obtain the adjusted usage.

[0079] In this embodiment of the invention, the resource pool occupancy can be adjusted according to the supply and shipment specifications so that the total resource pool occupancy of all market orders meets the requirements of the supply and shipment specifications, thus obtaining the adjusted occupancy.

[0080] Since the adjusted occupancy is obtained by reducing the resource pool occupancy to meet the supply and delivery specifications, the adjusted occupancy is no greater than the resource pool occupancy.

[0081] Step 105: Calculate the initial return order quantity based on the adjusted demand and adjusted occupancy.

[0082] The initial return order quantity refers to the quantity of target goods that need to be provided by the goods supplier, calculated based on the adjustment demand and adjustment occupancy of market orders.

[0083] Step 106: Adjust the initial reorder quantity according to the supply shipment specifications to obtain the target reorder quantity for the target product.

[0084] In this embodiment of the invention, since the supply of the target product by the commodity supplier is determined according to the supply and shipment specifications, it is necessary to adjust the initial return order quantity to make it meet the requirements of the supply and shipment specifications.

[0085] This invention adjusts each market order based on the supply shipment specifications to obtain the adjusted demand quantity that meets those specifications. Then, it adjusts the resource pool usage based on the supply shipment specifications to obtain the adjusted usage quantity that meets those specifications. This maximizes the use of existing resources in the resource pool, reduces the number of repeat orders, and thus saves procurement costs. Next, the initial repeat order quantity is calculated based on the adjusted demand quantity and adjusted usage quantity for each market order, and then adjusted based on the supply shipment specifications to obtain the target repeat order quantity that meets those specifications. The entire process requires minimal manual intervention and can automatically calculate repeat order quantities, improving the efficiency of repeat order quantity calculation and reducing labor costs.

[0086] Please see Figure 2 , Figure 2 A flowchart illustrating a method for calculating the quantity of returned orders for goods, as provided in another embodiment of the present invention. Specifically, it may include the following steps:

[0087] Step 201: Obtain all market orders and supply specifications for the target product;

[0088] Step 202: Obtain the original demand for each market order;

[0089] The original demand is the quantity of the target goods that a customer actually requests in a market order.

[0090] Step 203: Calculate the demand remainder between the original demand quantity and the supply specifications for each market order.

[0091] Step 204: Remove the demand remainder corresponding to each market order in turn to obtain the adjustment demand for each market order;

[0092] In this embodiment of the invention, the adjustment of the market order demand is to reduce it to meet an integer multiple of the supply and shipment specifications. In order to minimize the reduction, the original demand of each market order can be divided by the supply and shipment specifications, the remainder is used as the demand remainder, and the demand remainder is deducted from the original demand to obtain the adjusted demand that is closest to the original demand.

[0093] Step 205: Obtain the resource pool usage corresponding to each market order;

[0094] In this embodiment of the invention, the resource pool refers to a stored pool of target goods resources that can be directly allocated to users. When a retail enterprise receives a market order, it can allocate a portion of the order's inventory to the resource pool, thereby reducing the number of target goods it needs to purchase from suppliers.

[0095] Step 206: Adjust the resource pool usage according to the supply and shipment specifications to obtain the adjusted usage.

[0096] In this embodiment of the invention, the resource pool occupancy can be adjusted according to the supply and shipment specifications so that the total resource pool occupancy of all market orders meets the requirements of the supply and shipment specifications, thus obtaining the adjusted occupancy.

[0097] In one example, resource pool utilization may include inventory pool utilization and shared pool utilization; adjusting resource pool utilization based on supply shipment specifications to obtain the adjusted utilization step may include the following sub-steps:

[0098] S61, determine the order of market order adjustments;

[0099] In this embodiment of the invention, market orders can be pre-classified and screened, and then the order of multiple adjustments for each market order can be determined according to a preset adjustment principle. Finally, all market orders can be adjusted by combining the multiple adjustment orders. Alternatively, market orders can be adjusted in batches to determine the final order of market order adjustments.

[0100] In one example, step S61 may include the following sub-steps:

[0101] S611, obtain the market priority of each market order;

[0102] S612, sort market orders according to market priority to obtain the first adjustment order;

[0103] S613, filter orders from the same market with the same market priority;

[0104] S614, Sort the orders in the same market according to the demand of the same market to obtain the second adjustment order;

[0105] S615, filter orders from the same market segment with the same demand quantity;

[0106] S616, retrieve the creation time of orders from peer markets with the same demand;

[0107] S617, Sort orders in the same market with the same demand based on creation time to obtain the third adjustment order;

[0108] S618 uses the first adjustment sequence, the second adjustment sequence, and the third adjustment sequence to generate the adjustment sequence for market orders.

[0109] In practical implementation, we can first consider market priority (e.g., market priority determined by market size, market priority determined by product sales planning strategies, etc.), and sort the market orders in descending order according to market priority to obtain the first adjustment order. Next, from all market orders sorted according to the first adjustment order, we select first-level market orders with the same market priority. Among all first-level market orders, we sort them in descending order according to the number of demands for each first-level market order to obtain the second adjustment order. We then adjust all market orders sorted according to the second adjustment order. Next, from all market orders adjusted again according to the second adjustment order, we select second-level market orders with the same number of demands. We obtain the creation time of each second-level market order with the same number of demands and sort them in descending order starting from the latest creation time to obtain the third adjustment order. Finally, we adjust all market orders sorted according to the third adjustment order to obtain the final adjustment order of the market orders.

[0110] S62, adjust the inventory pool usage according to the adjustment order and supply shipment specifications to generate inventory adjustment quantity;

[0111] An inventory pool is used to store returned goods that have become inventory.

[0112] Inventory adjustment refers to the amount of inventory resources occupied by adjusted market orders in the inventory pool.

[0113] Since market orders prioritize using inventory resources before shared resources to avoid wasting existing resources when they are submitted, in this embodiment of the invention, it is necessary to first adjust the inventory pool usage of market orders to generate an inventory adjustment amount.

[0114] In one example, the step of adjusting the inventory pool holdings based on the adjustment order and supply shipment specifications to generate the inventory adjustment amount may include the following sub-steps:

[0115] S621, calculate the total inventory pool usage using the usage of all inventory pools;

[0116] S622, calculate the inventory balance between the total inventory pool usage and the supplied shipment specifications;

[0117] S623, when the inventory balance is not zero, generate the inventory adjustment amount for market orders by deducting the inventory pool occupancy of market orders based on the inventory balance in the adjustment order.

[0118] In this embodiment of the invention, the total inventory holdings can be divided by the supply shipment specifications to obtain the inventory remainder. When the inventory remainder is not 0, it indicates that the total inventory holdings are not an integer multiple of the supply shipment specifications. In this case, the inventory adjustment amount for market orders can be obtained by deducting the inventory remainder from the total inventory holdings.

[0119] In practice, the deduction of inventory pool usage for market orders can be carried out according to the aforementioned priority principle, prioritizing the deduction of inventory pool usage for the market order with the highest priority. If the inventory pool usage of the highest priority market order is insufficient for the deduction, the inventory pool usage of the next market order will be deducted sequentially.

[0120] S63, adjust the shared pool occupancy based on the adjustment order and supply shipment specifications, and generate the shared adjustment amount;

[0121] A shared pool is used to store shared orders, which refer to goods that are in transit but have not yet been returned and exist in the shared pool. A shared pool is a resource pool that aggregates the demand surplus of goods ordered from multiple markets; these demand surpluses are quantities of goods that are no longer needed in the original market and can be transferred to other markets.

[0122] The shared adjustment amount refers to the adjusted amount of shared resources occupied by market orders in the shared pool, which is an integer multiple of the supply shipment specifications. Therefore, the shared adjustment amount can be obtained by adjusting the shared pool usage based on the adjustment order and supply shipment specifications.

[0123] In one example, the step of adjusting the shared pool occupancy based on the adjustment order and supply shipment specifications to generate the shared adjustment amount may include the following sub-steps:

[0124] S631, calculate the total shared pool usage using the total shared pool usage;

[0125] S632, calculate the shared remainder between the total amount occupied in the shared pool and the supplied shipment specifications;

[0126] S633, when the shared remainder is not 0, according to the adjustment order, the shared pool occupancy of market orders is deducted based on the shared remainder to generate the shared adjustment amount of market orders.

[0127] In this embodiment of the invention, the total shared pool occupancy can be divided by the supply shipment specifications to obtain a shared remainder. When the shared remainder is not 0, it indicates that the total shared occupancy is not an integer multiple of the supply shipment specifications. In this case, the shared remainder can be deducted from the total shared occupancy to obtain the shared adjustment amount for market orders.

[0128] In the specific implementation, the deduction of shared pool usage for market orders can be carried out according to the above priority principle, prioritizing the deduction of shared pool usage for the market order with the highest priority. If the shared pool usage of the highest priority market order is insufficient for the deduction, the shared pool usage of the next market order will be deducted in sequence.

[0129] S64 uses inventory adjustment amount and shared adjustment amount to calculate the adjustment occupancy of each market order.

[0130] After calculating the inventory adjustment amount and shared adjustment amount for each market order, the two are added together to obtain the adjustment amount occupied by each market order.

[0131] Step 207: Calculate the initial return order quantity based on the adjusted demand and adjusted occupancy.

[0132] Step 208: Adjust the initial reorder quantity according to the supply shipment specifications to obtain the target reorder quantity for the target product.

[0133] In this embodiment of the invention, since the supply of the target product by the commodity supplier is determined according to the supply and shipment specifications, it is necessary to adjust the initial return order quantity to make it meet the requirements of the supply and shipment specifications.

[0134] In one example, the step of adjusting the initial reorder quantity based on the supply shipment specifications to obtain the target reorder quantity for the target product may include the following sub-steps:

[0135] S81, calculate the total number of return orders using the initial return order quantity corresponding to all market orders;

[0136] S82, calculate the total number of return orders and the return order remainder for the supplied shipment specifications;

[0137] S83, deduct the remainder from the total number of repeat orders to obtain the target repeat order quantity for the target product.

[0138] In this embodiment of the invention, the total number of repeat orders for all market orders can be calculated. Then, the total number of repeat orders is divided by the supply shipment specifications to obtain the repeat order remainder. The repeat order remainder is then subtracted from the total number of repeat orders to obtain the target repeat order quantity for the target product. The target repeat order quantity is an integer multiple of the supply shipment specifications.

[0139] This invention adjusts each market order based on the supply shipment specifications to obtain the adjusted demand quantity that meets those specifications. Then, it adjusts the inventory pool and shared pool occupancy based on the supply shipment specifications to obtain the adjusted occupancy quantity that meets the supply shipment specifications. This maximizes the use of existing resources in the inventory pool and shared pool, reducing the number of repeat orders and thus saving procurement costs. Next, the initial repeat order quantity is calculated based on the adjusted demand quantity and adjusted occupancy quantity for each market order, and then adjusted based on the supply shipment specifications to obtain the target repeat order quantity that meets the supply shipment specifications. The entire process requires minimal manual intervention and can automatically calculate repeat order quantities, improving the efficiency of repeat order quantity calculation and reducing labor costs.

[0140] For ease of understanding, the embodiments of the present invention will be described below through specific examples:

[0141] The first step is to retrieve all market orders for the current batch run when executing the batch run process, and filter the data according to the following conditions:

[0142] Temporary delisting, prohibited mining list, lifecycle plan elimination and actual elimination, EOS delisting, SAP delisting.

[0143] Batch processing refers to accumulating data into "batches" and processing them all at once at a specified time.

[0144] The second step is to group the orders into two categories: non-customized and customized (customized and non-customized orders can be preset by the business; customized orders refer to a single order that meets the MOQ of the SKU, while non-customized orders refer to the same batch of orders). The market order demand is then aggregated at the [SKU + warehouse] dimension for subsequent calculations.

[0145] [SKU + Warehouse]: Single warehouse full case refers to the quantity of market demand corresponding to a dimension being a multiple of the quantity of a single case of SKU products. In order to control logistics costs, the procurement data is generally in the form of single warehouse full cases.

[0146] The third step is to adjust the demand for all market orders to a multiple of the number of SKU boxes based on the [SKU + warehouse] dimension.

[0147] The order of single-warehouse full container loads is sorted before and after adjustment, with the following priority: the first level is market priority; the second level is when all market priorities are the same, the adjustment is based on the demand quantity, i.e., in descending order; the third level is when the first two levels are the same, the adjustment is based on the creation time of the market order, starting from the latest creation time.

[0148] After sorting, adjust the single-warehouse full container load (FCL) order: When adjusting the single-warehouse FCL order, the adjustment ratio needs to be calculated: Select markets that ship in medium-sized packages from all market orders (market orders with demand in full-case containers are not included in the ratio calculation and do not need to be adjusted for single-warehouse FCL). Calculate the ratio of the number of orders in each market that ships in medium-sized packages to the total number of market orders. For each market order that ships in medium-sized packages, adjust the demand in the single-warehouse FCL order according to the ratio corresponding to that market order (i.e., deduct the demand according to the specifications of the medium-sized package and round down). If there is a surplus, continue to deduct in a loop according to the market priority until all the surplus is deducted.

[0149] The fourth step is to adjust the inventory pool usage and the shared pool usage.

[0150] 1. Return the inventory and / or shared orders occupied by the market orders whose demand was reduced in the first step to the inventory pool and shared pool. If the market orders with reduced demand include return orders (i.e., the return order quantity is not 0), the remaining quantity will be deducted from the return order quantity first (as shown in Table 2).

[0151] 2. Market orders occupy the remaining resources in the inventory pool and the shared pool in sequence according to priority, so as to consume the resources in the inventory pool and the shared pool as much as possible (as shown in Table 3).

[0152] 3. Adjust all currently occupied inventory and shared orders to full-case status in a single warehouse. This is equivalent to deducting all shared inventory and shared orders from the full-case status and increasing the number of return orders (as shown in Table 4).

[0153] The fifth step is to adjust the reorder quantity of all market orders according to the specifications of full cases, and deduct the remaining quantity from the market orders according to priority until all the remaining quantity is used up.

[0154] After the above process is completed, the market order demand, inventory pool usage, shared pool usage, and reorder quantity will all be adjusted to full cases per warehouse. At this point, it is determined whether the target reorder quantity for the same SKU is greater than or equal to the MOQ. If not, the target reorder quantity is reduced to 0. If so, a batch run is executed to generate the corresponding reorder purchase order to purchase the target product from the supplier.

[0155] For example:

[0156] Premise: The current inventory remaining quantity is 10 when the batch run is executed; prioritize identifying market orders whose demand does not match the full case specification.

[0157] Within the same warehouse, for the same SKU, i.e., at the [SKU + warehouse] level:

[0158] The shipment specification is 1*5*2=10 (full carton), and the intermediate package specification is 5 pieces. Therefore:

[0159]

[0160] Table 1

[0161] Next, based on the adjusted specifications, adjustments were prioritized for market order A, and the results are as follows:

[0162] 1) Remaining inventory: 10

[0163] Market Order A - Shipping Method: Full Case; Original Demand: 100 (115-5); Inventory Pool Utilization: 15; Shared Pool Utilization: 0; Reorders: 95 (100-5).

[0164]

[0165] Table 2

[0166] 2) Inventory pool remaining amount: 0 (10-10)

[0167] Market Order A – Shipping Method: Full Case; Original Demand: 110; Inventory Pool Utilization: 25 (15+10) (This includes the remaining inventory of 10 from the batch run); Shared Pool Utilization: 0; Repeat Orders: 85 (95-10)

[0168]

[0169]

[0170] Table 3

[0171] 3) Remaining inventory: 5 (0+5)

[0172] The inventory occupied by market orders A+B+C is calculated to be 55. Based on the specifications of full-case orders, the occupied inventory of 55 is adjusted to 50 per warehouse full-case order. Then, according to the preset priority, the remaining 5 are returned to the inventory pool. At this point, we have:

[0173] Market Order A - Shipping Method: Medium Package; Original Demand: 110; Inventory Pool Utilization: 20 (25-5); Shared Pool Utilization: 0; Return Orders: 90 (85+5).

[0174]

[0175] Table 4

[0176] At this point, the demand for each market order, the inventory pool usage of all market orders, the shared pool usage, and the return order quantity are all multiples of the full case. The current return order quantity is the target return order quantity, which is used to purchase the target product from the product supplier.

[0177] Please see Figure 3 , Figure 3 This is a structural block diagram of a product return order quantity calculation device provided in an embodiment of the present invention.

[0178] This invention provides a device for calculating the quantity of returned goods, comprising:

[0179] Module 301 is used to acquire all market orders and supply specifications for the target product;

[0180] The demand calculation module 302 is used to adjust each market order according to the supply and delivery specifications to obtain the adjusted demand.

[0181] The resource pool usage acquisition module 303 is used to acquire the resource pool usage corresponding to each market order.

[0182] The resource pool occupancy calculation module 304 is used to adjust the resource pool occupancy according to the supply and shipment specifications to obtain the adjusted occupancy.

[0183] The initial return order quantity calculation module 305 is used to calculate the initial return order quantity based on the adjustment demand and adjustment occupancy.

[0184] The target reorder quantity calculation module 306 is used to adjust the initial reorder quantity according to the supply and shipment specifications to obtain the target reorder quantity of the target product.

[0185] In this embodiment of the invention, the adjustment demand calculation module 302 includes:

[0186] The raw demand acquisition submodule is used to obtain the raw demand corresponding to each market order.

[0187] The demand remainder calculation submodule is used to calculate the demand remainder between the original demand quantity and the supply shipment specifications for each market order in turn.

[0188] The adjustment demand calculation submodule is used to sequentially remove the demand remainder corresponding to each market order to obtain the adjustment demand for each market order.

[0189] In this embodiment of the invention, the resource pool occupancy includes the inventory pool occupancy and the shared pool occupancy; the occupancy calculation module 304 includes:

[0190] The "Order Adjustment Determination" submodule is used to determine the order in which market orders are adjusted.

[0191] The inventory adjustment quantity generation submodule is used to adjust the inventory pool usage according to the adjustment order and supply shipment specifications, and generate the inventory adjustment quantity.

[0192] The shared adjustment quantity generation submodule is used to adjust the shared pool occupancy based on the adjustment order and supply shipment specifications, and generate the shared adjustment quantity.

[0193] The adjustment occupancy calculation submodule is used to calculate the adjustment occupancy for each market order using inventory adjustment and shared adjustment.

[0194] In this embodiment of the invention, adjusting the order of obtaining sub-modules includes:

[0195] The market priority acquisition unit is used to acquire the market priority of each market order;

[0196] The first adjustment order acquisition unit is used to sort market orders according to market priority to obtain the first adjustment order;

[0197] The peer market order filtering unit is used to filter peer market orders with the same market priority;

[0198] The second adjustment order generation unit is used to sort the orders in the same-level market according to the demand number of orders in the same-level market to obtain the second adjustment order;

[0199] The same demand quantity order filtering unit is used to filter orders from the same market level with the same demand quantity;

[0200] The creation time acquisition unit is used to obtain the creation time of orders in the same market with the same demand.

[0201] The third adjustment order acquisition unit is used to sort orders in the same market with the same demand based on the creation time to obtain the third adjustment order;

[0202] The adjustment order generation unit is used to generate the adjustment order of market orders by adopting the first adjustment order, the second adjustment order, and the third adjustment order.

[0203] In this embodiment of the invention, the inventory adjustment generation submodule includes:

[0204] The inventory pool total occupancy calculation unit is used to calculate the total inventory pool occupancy using the occupancy of all inventory pools.

[0205] The inventory balance calculation unit is used to calculate the inventory balance between the total inventory pool and the supplied shipment specifications.

[0206] The inventory adjustment generation unit is used to generate the inventory adjustment amount for market orders by deducting the inventory pool occupancy of market orders from the inventory balance when the inventory balance is not zero, according to the adjustment order.

[0207] In this embodiment of the invention, the shared adjustment amount generation submodule includes:

[0208] The shared pool occupancy total calculation unit is used to calculate the total shared pool occupancy using the occupancy of all shared pools.

[0209] The shared remainder calculation unit is used to calculate the shared remainder between the total amount occupied by the shared pool and the supplied shipment specifications;

[0210] The shared adjustment amount generation unit is used to generate the shared adjustment amount of market orders by deducting the shared pool occupancy of market orders based on the shared remainder when the shared remainder is not 0, according to the adjustment order.

[0211] In this embodiment of the invention, the target return order quantity calculation module 306 includes:

[0212] The total number of return orders calculation submodule is used to calculate the total number of return orders using the initial return order quantity corresponding to all market orders.

[0213] The reorder remainder calculation submodule is used to calculate the reorder remainder between the total number of reorders and the supplied shipment specifications;

[0214] The target return order quantity calculation submodule is used to subtract the return order remainder from the total return order quantity to obtain the target return order quantity for the target product.

[0215] This invention also provides an electronic device, which includes a processor and a memory:

[0216] The memory is used to store program code and transfer the program code to the processor;

[0217] The processor is used to execute the product return order quantity calculation method of this embodiment of the invention according to the instructions in the program code.

[0218] This invention also provides a computer-readable storage medium for storing program code, which is used to execute the product return order quantity calculation method of this invention.

[0219] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems, devices, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here.

[0220] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other.

[0221] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, apparatus, or computer program products. Therefore, embodiments of the present invention can take the form of entirely hardware embodiments, entirely software embodiments, or embodiments combining software and hardware aspects. Furthermore, embodiments of the present invention can take the form of computer program products implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0222] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing terminal device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal device, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0223] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing terminal device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0224] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal equipment, causing a series of operational steps to be performed on the computer or other programmable terminal equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable terminal equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0225] Although preferred embodiments of the present invention have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments as well as all changes and modifications falling within the scope of the embodiments of the present invention.

[0226] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations, nor do they limit the entities or operations themselves. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or terminal device that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or terminal device. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or terminal device that includes said element.

[0227] The above-described embodiments are only used to illustrate the technical solutions of the present invention, and are not intended to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for calculating the quantity of returned goods, characterized in that, include: Obtain all market orders and supply specifications for the target product; Adjust each market order according to the supply and shipment specifications to obtain the adjusted demand. Obtain the resource pool usage corresponding to each of the aforementioned market orders; The resource pool occupancy is adjusted according to the supply and shipment specifications to obtain the adjusted occupancy. Calculate the initial return order quantity based on the adjusted demand and the adjusted occupancy. Adjust the initial return order quantity according to the supply and shipment specifications to obtain the target return order quantity for the target product; The step of adjusting each market order according to the supply and shipment specifications to obtain the adjusted demand includes: Obtain the original demand for each of the aforementioned market orders; Calculate the demand remainder between the original demand quantity and the supply shipment specifications for each market order in sequence; The demand remainder corresponding to each market order is removed sequentially to obtain the adjusted demand number for each market order.

2. The method according to claim 1, characterized in that, The resource pool occupancy includes the inventory pool occupancy and the shared pool occupancy; the step of adjusting the resource pool occupancy according to the supply and shipment specifications to obtain the adjusted occupancy includes: Determine the order of adjustment for the market orders; The inventory pool occupancy is adjusted according to the adjustment order and the supply shipment specifications to generate an inventory adjustment amount; The shared pool occupancy is adjusted according to the adjustment order and the supply and shipment specifications to generate a shared adjustment amount; The adjustment occupancy for each market order is calculated using the inventory adjustment amount and the shared adjustment amount.

3. The method according to claim 2, characterized in that, The step of determining the adjustment order of the market orders includes: Obtain the market priority for each of the aforementioned market orders; The market orders are sorted according to the market priority to obtain the first adjustment order; Filter orders from the same market with the same market priority; The orders in the same-level market are sorted according to the demand number of the orders in the same-level market to obtain the second adjustment order; Filter orders from the same market segment with the same demand. Get the creation time of orders from the same market segment with the same demand. Based on the creation time, orders from the same market segment with the same demand are sorted to obtain the third adjustment order; The adjustment order of the market order is generated by using the first adjustment order, the second adjustment order, and the third adjustment order.

4. The method according to claim 2, characterized in that, The step of adjusting the inventory pool occupancy according to the adjustment order and the supply shipment specifications to generate the inventory adjustment amount includes: The total inventory pool occupancy is calculated using all the aforementioned inventory pool occupancy amounts. Calculate the inventory balance between the total inventory in the inventory pool and the supplied shipment specifications; When the inventory balance is not zero, the inventory adjustment amount for the market orders is generated by deducting the inventory pool occupancy of the market orders based on the inventory balance, in accordance with the adjustment order.

5. The method according to claim 2, characterized in that, The step of adjusting the shared pool occupancy based on the adjustment order and the supply shipment specifications to obtain the shared adjustment amount includes: The total shared pool usage is calculated using all the aforementioned shared pool usage values. Calculate the shared remainder between the total amount occupied by the shared pool and the supply shipment specifications; When the shared remainder is not 0, the shared adjustment amount of the market order is generated by deducting the shared pool occupancy of the market order based on the shared remainder, in accordance with the adjustment order.

6. The method according to claim 1, 2, 4, or 5, characterized in that, The step of adjusting the initial return order quantity according to the supply and shipment specifications to obtain the target return order quantity for the target product includes: Calculate the total number of return orders using the initial return order quantity corresponding to all market orders; Calculate the total number of return orders and the return order remainder for the supplied shipment specifications; The target number of repeat orders is obtained by subtracting the repeat order remainder from the total number of repeat orders.

7. A device for calculating the quantity of returned goods, characterized in that, include: The acquisition module is used to acquire all market orders and supply specifications for the target product; The demand calculation module is used to adjust each market order according to the supply and shipment specifications to obtain the adjusted demand. The resource pool usage acquisition module is used to acquire the resource pool usage corresponding to each market order. The occupancy calculation module is used to adjust the resource pool occupancy according to the supply and shipment specifications to obtain the adjusted occupancy. The initial return order quantity calculation module is used to calculate the initial return order quantity based on the adjustment demand and the adjustment occupancy. The target reorder quantity calculation module is used to adjust the initial reorder quantity according to the supply and shipment specifications to obtain the target reorder quantity of the target product. The adjustment requirement calculation module includes: The raw demand acquisition submodule is used to obtain the raw demand corresponding to each market order. The demand remainder calculation submodule is used to calculate the demand remainder between the original demand quantity and the supply shipment specifications for each market order in turn. The adjustment demand calculation submodule is used to sequentially remove the demand remainder corresponding to each market order to obtain the adjustment demand for each market order.

8. An electronic device, characterized in that, The device includes a processor and a memory: The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the product return order quantity calculation method according to any one of claims 1-6 according to the instructions in the program code.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium is used to store program code for executing the product return order quantity calculation method according to any one of claims 1-6.

Images