Inventory data processing method and device, equipment and medium

Abstract

The embodiment of the invention provides an inventory data processing method and device, equipment and a medium. The method comprises the steps of obtaining inventory data of commodities stored in a warehouse by a commodity owner; and based on each preset inventory analysis dimension and an inventory analysis strategy corresponding to each inventory analysis dimension, analyzing the inventory data to obtain a first inventory analysis file. The method is used for solving the problems of low accuracy, low efficiency and high cost caused by manual inventory data analysis in the prior art, and automatic, rapid and accurate inventory data analysis is realized.

Description

Technical Field

[0001] The present invention relates to the technical field of inventory management, and in particular to an inventory data processing method, device, equipment and medium. Background Art

[0002] With the rapid development of the economy and electronic information technology, inventory management plays a vital role in a company's growth and competitiveness. Proper inventory management can improve warehouse turnover and prevent excessive inventory overstocking. Inventory analysis, a key tool in inventory management, provides a global overview of hot-selling and slow-moving goods, their distribution, and allows for efficient inventory scheduling, significantly improving inventory turnover.

[0003] Existing inventory management mostly uses manual methods to conduct inventory analysis, but manual inventory analysis has a series of problems such as low accuracy, low efficiency and high labor costs. Summary of the Invention

[0004] Embodiments of the present invention provide an inventory data processing method, apparatus, device, and medium to address the problems of low accuracy, low efficiency, and high cost caused by manual inventory data analysis in the prior art, thereby enabling automatic, rapid, and accurate inventory data analysis.

[0005] An embodiment of the present invention provides an inventory data processing method, the method comprising:

[0006] Obtain inventory data of goods stored in the warehouse by the goods owner;

[0007] Based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions, the inventory data is analyzed to obtain a first inventory analysis file.

[0008] According to the inventory data processing method provided by an embodiment of the present invention, the inventory analysis dimension includes: a stagnant inventory analysis dimension;

[0009] Analyzing the inventory data based on the slow-moving inventory analysis dimension and the inventory analysis strategy corresponding to the slow-moving inventory analysis dimension to obtain the first inventory analysis file includes:

[0010] Determine whether there is a shipment record for the product in the warehouse;

[0011] If it is determined that the product has the shipment record, obtaining the last shipment date corresponding to the product; calculating the sum of the current date and a first preset value to obtain a sum result; calculating the difference between the sum result and the last shipment date to obtain a first difference; if the first difference is greater than a second preset value, using the first difference as the slow-moving inventory age of the product; and obtaining the first inventory analysis file based on the inventory data and the slow-moving inventory age.

[0012] If it is determined that no outbound record exists for the product, the last entry date corresponding to the product is obtained; the sum of the current date and the first preset value is calculated to obtain a sum result; the difference between the sum result and the last entry date is calculated to obtain a second difference; if the second difference is greater than the second preset value, the second difference is used as the slow-moving inventory age of the product; and the first inventory analysis file is obtained based on the inventory data and the slow-moving inventory age.

[0013] According to the inventory data processing method provided by an embodiment of the present invention, the inventory analysis dimensions include: a stagnant inventory ratio analysis dimension;

[0014] The inventory data is analyzed based on the slow-moving inventory ratio analysis dimension and the inventory analysis strategy corresponding to the slow-moving inventory ratio analysis dimension to obtain the first inventory analysis file, including:

[0015] Determine the number of slow-moving goods corresponding to the goods owner and the total number of goods in the warehouse;

[0016] Calculating a quotient of the quantity and the total quantity to obtain a first quotient value, and using the first quotient value as the slow-moving inventory ratio of the product;

[0017] The first inventory analysis file is obtained based on the inventory data and the slow-moving inventory ratio.

[0018] According to the inventory data processing method provided by an embodiment of the present invention, the inventory analysis dimension includes: an average inventory analysis dimension;

[0019] Analyzing the inventory data based on the average inventory analysis dimension and the inventory analysis strategy corresponding to the average inventory analysis dimension to obtain the first inventory analysis file includes:

[0020] Obtain the inventory quantity of the product in the warehouse and the initial warehousing date of the product;

[0021] Calculate the sum of the current date and the third preset value to obtain a sum result;

[0022] Calculating the difference between the summed result and the initial warehousing date to obtain a third difference;

[0023] Calculating a quotient of the third difference and the inventory quantity to obtain a second quotient value, and using the second quotient value as the average inventory age;

[0024] The first inventory analysis file is obtained based on the inventory data and the average inventory age.

[0025] According to the inventory data processing method provided by an embodiment of the present invention, the inventory analysis dimension includes: commodity storage validity period analysis dimension;

[0026] Analyzing the inventory data based on the commodity storage validity period analysis dimension and the inventory analysis strategy corresponding to the commodity storage validity period analysis dimension to obtain the first inventory analysis file includes:

[0027] Get the initial entry date of the product;

[0028] Calculating the difference between the current date and the initial warehousing date to obtain a fourth difference, and using the fourth difference as the storage validity period of the product;

[0029] The first inventory analysis file is obtained based on the inventory data and the storage validity period of the commodity.

[0030] According to the inventory data processing method provided by an embodiment of the present invention, the first inventory analysis file includes inventory age, and the inventory age is obtained based on the current date and the initial inventory entry date of the product;

[0031] After analyzing the inventory data based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions to obtain the first inventory analysis file, the method further includes:

[0032] determining whether a first inventory age in the first inventory analysis file is greater than a preset first alarm threshold;

[0033] When it is determined that the first storage age is greater than the first alarm threshold, calculating the difference between the first storage age and the first alarm threshold to obtain a fourth difference;

[0034] Based on the fourth difference, an alarm level is determined, and alarm information corresponding to the alarm level is generated.

[0035] According to an embodiment of the present invention, the inventory data processing method further includes: analyzing the inventory data based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the preset inventory analysis dimensions to obtain the first inventory analysis file;

[0036] Obtaining a commodity analysis requirement corresponding to the commodity owner, wherein the commodity analysis requirement is used to indicate the commodity owner's analysis requirement for target data in the inventory data, the target data being determined by the commodity owner;

[0037] Based on the commodity analysis requirement, statistics are collected on the target data in the first inventory analysis file to obtain a second inventory analysis file.

[0038] According to the inventory data processing method provided by an embodiment of the present invention, the second inventory analysis file includes inventory age, and the inventory age is obtained based on the current date and the initial inventory entry date of the product;

[0039] After analyzing the first inventory analysis file based on the commodity analysis requirement to obtain the second inventory analysis file, the method further includes:

[0040] determining whether a second inventory age in the second inventory analysis file is greater than a preset second alarm threshold;

[0041] When it is determined that the second storage age is greater than the second alarm threshold, calculating the difference between the second storage age and the second alarm threshold to obtain a fifth difference;

[0042] Based on the fifth difference, an alarm level is determined, and alarm information corresponding to the alarm level is generated.

[0043] An embodiment of the present invention further provides an inventory data processing device, the device comprising:

[0044] The acquisition module is used to obtain the inventory data of the goods stored in the warehouse by the goods owner;

[0045] The analysis module is configured to analyze the inventory data based on preset inventory analysis dimensions and inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

[0046] An embodiment of the present invention further provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the steps of the inventory data processing method are implemented when the processor executes the program.

[0047] An embodiment of the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the inventory data processing method are implemented.

[0048] The inventory data processing method, apparatus, device, and medium provided in the embodiments of the present invention obtain inventory data of goods stored in a warehouse by a goods owner; analyze the inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to the pre-set inventory analysis dimensions to obtain a first inventory analysis file. It can be seen that the present invention automatically analyzes inventory data through inventory analysis dimensions and inventory analysis strategies and generates a first inventory analysis file that can be viewed intuitively. The entire process does not require human intervention, effectively solving a series of problems in the prior art of manually analyzing inventory data, such as low accuracy, low efficiency, and high labor costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0050] Figure 1 This is one of the flowcharts of the inventory data processing method provided by an embodiment of the present invention;

[0051] Figure 2 It is a schematic diagram of the sluggish price trend line provided by the present invention;

[0052] Figure 3 This is a circular diagram of the proportion of stagnant prices provided by the present invention;

[0053] Figure 4 It is a bar diagram of the percentage of obsolete inventory provided by the present invention;

[0054] Figure 5 This is a broken line diagram of the percentage of slow-moving inventory provided by the present invention;

[0055] Figure 6 This is a bar diagram of the proportion of expired prices provided by the present invention;

[0056] Figure 7 This is a circular diagram of the proportion of expired prices provided by the present invention;

[0057] Figure 8 This is the second flow chart of the inventory data processing method provided by the present invention;

[0058] Figure 9 It is a structural diagram of an inventory data processing device provided by an embodiment of the present invention;

[0059] Figure 10 It is a structural diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0060] To make the objectives, technical solutions, and advantages of the embodiments of the present invention more clear, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0061] Embodiments of the present invention provide an inventory data processing method that can be applied to smart terminals, such as mobile phones, computers, and tablets, and can also be applied to servers. Below, the method is described using a server as an example. However, it should be noted that this is merely an example and is not intended to limit the scope of protection of the present invention. Other descriptions in the embodiments of the present invention are also provided for illustrative purposes and are not intended to limit the scope of protection of the present invention. These descriptions will not be repeated hereafter.

[0062] like Figure 1 As shown, the method includes:

[0063] Step 101: Obtain inventory data of goods stored in the warehouse by the goods owner.

[0064] The present invention includes one or more warehouses, each warehouse includes commodities stored by one or more commodity owners, each commodity owner corresponds to one or more commodities, and the commodities of the commodity owners can be stored in one or more warehouses.

[0065] For example, a commodity owner may store a commodity in one warehouse, two warehouses, three warehouses, or even more warehouses.

[0066] For another example, a commodity owner may store multiple commodities in different warehouses, or in the same warehouse, or store any one of the multiple commodities in the same or different warehouses, and so on.

[0067] Among them, inventory data includes: warehouse name, owner name, product name, product code, product inventory quantity, product allocation quantity, product frozen quantity, product available quantity, product initial entry time, product exit time, product location in the warehouse (referred to as storage location), storage location code, product partition in the warehouse (referred to as storage area), specific area of the product partition in the warehouse (referred to as area), group of product area in the warehouse (referred to as storage location group), etc.

[0068] Among them, the commodity inventory quantity is the quantity of the commodity stored in the warehouse; the commodity allocation quantity is the quantity of the commodity pre-occupied by orders; the commodity frozen quantity is the quantity of the commodity that needs to be returned to the owner; the commodity available quantity is the quantity of the commodity remaining after deducting the commodity inventory quantity from the commodity allocation quantity and then deducting the commodity frozen quantity.

[0069] Step 102 : Analyze the inventory data based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

[0070] The present invention includes multiple inventory analysis dimensions, different inventory analysis dimensions correspond to different inventory analysis strategies, and the corresponding relationship between inventory analysis dimensions and inventory analysis strategies has been pre-configured.

[0071] Among them, inventory analysis dimensions include: obsolete inventory analysis dimension, obsolete inventory ratio analysis dimension, average inventory analysis dimension, and product storage validity period analysis dimension.

[0072] Specifically, the obsolete inventory analysis dimension corresponds to the obsolete inventory analysis strategy, the obsolete inventory ratio analysis dimension corresponds to the obsolete inventory ratio analysis strategy, the average inventory analysis dimension corresponds to the average inventory analysis strategy, the product storage validity period analysis dimension corresponds to the product storage validity period analysis strategy, and so on.

[0073] Specifically, for the obsolete inventory analysis dimension, the inventory data is analyzed using the obsolete inventory analysis strategy to obtain a first inventory analysis file corresponding to the obsolete inventory analysis dimension; for the obsolete inventory proportion analysis dimension, the inventory data is analyzed using the obsolete inventory proportion analysis strategy to obtain a first inventory analysis file corresponding to the obsolete inventory proportion analysis dimension; for the average inventory analysis dimension, the inventory data is analyzed using the average inventory analysis strategy to obtain a first inventory analysis file corresponding to the average inventory analysis dimension; for the product storage validity period analysis dimension, the inventory data is analyzed using the product storage validity period analysis strategy to obtain a first inventory analysis file corresponding to the product storage validity period analysis dimension.

[0074] The first inventory analysis file includes inventory data and analysis results corresponding to corresponding inventory analysis dimensions.

[0075] The first inventory file includes any one or more of a table, a report, a line chart, a ring chart, a bar chart, etc. The present invention does not limit this, and the user can set it according to his actual needs.

[0076] The inventory data processing method provided in an embodiment of the present invention obtains inventory data of goods stored in a warehouse by a goods owner; analyzes the inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to the pre-set inventory analysis dimensions to obtain a first inventory analysis file. It can be seen that the present invention automatically analyzes inventory data through inventory analysis dimensions and inventory analysis strategies and generates a first inventory analysis file that can be viewed intuitively. The entire process does not require human intervention, effectively solving a series of problems in the prior art of manually analyzing inventory data, such as low accuracy, low efficiency, and high labor costs.

[0077] In the following specific embodiments, the present invention is described by taking an example in which a commodity owner stores one commodity in one warehouse. Of course, this is only an example and is not intended to limit the present invention.

[0078] In a specific embodiment, the inventory analysis dimension includes a slow-moving inventory analysis dimension. When the inventory analysis dimension is the slow-moving inventory analysis dimension, analyzing inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to the pre-set inventory analysis dimensions to obtain a first inventory analysis file includes: analyzing inventory data based on the slow-moving inventory analysis dimension and the inventory analysis strategy corresponding to the slow-moving inventory analysis dimension (i.e., the slow-moving inventory analysis strategy) to obtain the first inventory analysis file. Specific implementation thereof includes:

[0079] Determine whether there is a shipment record for the product in the warehouse. If it is determined that there is a shipment record for the product, obtain the last shipment date corresponding to the product; calculate the sum of the current date and a first preset value to obtain a sum result; calculate the difference between the sum result and the last shipment date to obtain a first difference; if the first difference is greater than a second preset value, use the first difference as the product's slow-moving inventory age; and obtain a first inventory analysis file based on the inventory data and the slow-moving inventory age. If it is determined that there is no shipment record for the product, obtain the last entry date corresponding to the product; calculate the sum of the current date and the first preset value to obtain a sum result; calculate the difference between the sum result and the last shipment date to obtain a second difference; if the second difference is greater than the second preset value, use the second difference as the product's slow-moving inventory age; and obtain a first inventory analysis file based on the inventory data and the slow-moving inventory age.

[0080] Specifically, when goods stored in the warehouse are put into the warehouse, a corresponding entry record will be generated; when goods are taken out of the warehouse, a corresponding exit record will be generated.

[0081] Specifically, by determining whether there is a corresponding outbound record for the product, it is determined whether the product has been turned over. If it is determined that there is a corresponding outbound record for the product, the first difference value is obtained using formula (1); if it is determined that there is no corresponding outbound record for the product, the second difference value is obtained using formula (2).

[0082] First difference = (current date + first preset value) - last shipment date... (1)

[0083] Second difference = (current date + first preset value) - last entry date... (2)

[0084] For example, the first preset value may be a value of 1.

[0085] Specifically, when the first difference is greater than the second preset value, the commodity is determined to be a slow-moving commodity, and the first difference at this time is used as the slow-moving inventory age of the commodity; when the second difference is greater than the second preset value, the commodity is determined to be a slow-moving commodity, and the second difference at this time is used as the slow-moving inventory age of the commodity.

[0086] For example, take the second preset value of 180 days as an example:

[0087] When the first difference is greater than 180 days, the commodity is determined to be a stagnant commodity (in a stagnant state), and the first difference at this time is used as the stagnant inventory age of the commodity; when the second difference is greater than 180 days, the commodity is determined to be a stagnant commodity, and the second difference at this time is used as the stagnant inventory age of the commodity.

[0088] Specifically, the present invention also includes slow-moving warning products, that is, a fourth preset value is pre-set, and the corresponding products when the first difference is less than or equal to the first preset value and greater than the fourth preset value are determined as slow-moving warning products.

[0089] For example, the fourth preset value is 135 days.

[0090] When the first difference is less than or equal to 180 days and greater than 135 days, the commodity is determined to be a slow-moving warning commodity (in a slow-moving warning state), and the first difference at this time is used as the slow-moving warning inventory age of the commodity; when the second difference is less than or equal to 180 days and greater than 135 days, the commodity is determined to be a slow-moving warning commodity, and the second difference at this time is used as the slow-moving warning inventory age of the commodity.

[0091] Of course, when the first difference is less than or equal to 135 days, the product is determined to be a normal inventory product (in normal inventory status); when the second difference is less than or equal to 135 days, the product is determined to be a normal inventory product.

[0092] Below is a schematic diagram of the stagnant inventory aging report, see Table 1:

[0093] Commodity owner Product Name Product Code Product inventory quantity Location code Stagnant storage age A 111 AA1100 1000 KUWEI1 200 days B 222 BB2200 1500 KUWEI2 300 days C 333 CC3300 5000 KUWEI3 190 days D 444 DD4400 8300 KUWEI4 260 days

[0094] Table 1 Sluggish Inventory Age Report

[0095] The inventory data in Table 1 is only partially illustrated, and users can set it according to their actual needs, and the present invention does not limit it.

[0096] The present invention analyzes inventory data based on the obsolete inventory analysis dimension to obtain the obsolete inventory age corresponding to the commodity owner, and then analyzes the commodities corresponding to the obsolete inventory age to find the cause of the obsolete inventory and solve the problem.

[0097] In addition, since the goods have evolved into stagnant goods, the corresponding commodity prices have also become stagnant prices.

[0098] For example, the obsolete price corresponding to the commodity owner A is 1,000 yuan, and the total obsolete price corresponding to the warehouse corresponding to the commodity owner A is 10,000 yuan. By calculating the quotient of the obsolete price and the total obsolete price, the obsolete price ratio can be obtained.

[0099] pass Figure 2 The line chart shows the sluggish price trend for each month.

[0100] Among them, Figure 2 In the figure, the dates on the horizontal axis are January 2023, February 2023, March 2023, April 2023 and May 2023, and the unit of the vertical axis is ten thousand yuan.

[0101] Of course, the proportion of stagnant prices can be calculated by time period.

[0102] For example, taking the commodity owner A as an example, for example, the proportion of obsolete prices from January 2023 to March 2023, that is, the obsolete price of commodity A from January 2023 to March 2023 is 500 yuan, and the total obsolete price of the warehouse corresponding to the commodity owner A from January 2023 to March 2023 is 8,000 yuan, then the proportion of obsolete prices in this time period is 500 divided by 8,000 to get the quotient.

[0103] For example, taking the commodity owner B as an example, for example, the proportion of obsolete prices from January 2023 to May 2023, that is, the obsolete price of commodity B from January 2023 to May 2023 is 800 yuan, and the total obsolete price of the warehouse corresponding to the commodity owner B from January 2023 to May 2023 is 9,000 yuan, then the proportion of obsolete prices in this time period is 800 divided by 9,000 to get the quotient.

[0104] Of course, the proportion of stagnant prices can also be calculated by region.

[0105] For example, all regions are divided into the eastern region, the western region, the southern region, and the northern region.

[0106] For example, calculate the slow-moving prices in the eastern region, the slow-moving prices in the western region, the slow-moving prices in the southern region, and the slow-moving prices in the northern region, and divide the above results by the total slow-moving prices in the warehouse to get the slow-moving price percentage based on the region. Figure 3 The ring diagram is used to illustrate.

[0107] in, Figure 3 In the chart, the eastern region is represented by stripes, with a stagnant price share of 8.2%; the western region is represented by straight lines, with a stagnant price share of 3.2%; the southern region is represented by dots, with a stagnant price share of 1.4%; and the northern region is represented by dotted lines, with a stagnant price share of 1.2%.

[0108] In a specific embodiment, the inventory analysis dimension includes a stagnant inventory ratio analysis dimension. When the inventory analysis dimension is a stagnant inventory ratio analysis dimension, analyzing inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to each inventory analysis dimension to obtain a first inventory analysis file includes: analyzing inventory data based on the stagnant inventory ratio analysis dimension and the inventory analysis strategy (stagnant inventory ratio analysis strategy) corresponding to the stagnant inventory ratio analysis dimension to obtain the first inventory analysis file. The specific implementation process includes:

[0109] Determine the number of obsolete goods corresponding to the goods owner and the total number of goods in the warehouse; calculate the quotient of the number and the total number to obtain a first quotient value, and use the first quotient value as the obsolete inventory ratio of the goods; and obtain a first inventory analysis file based on the inventory data and the obsolete inventory ratio.

[0110] Specifically, the proportion of slow-moving inventory is obtained using formula (3):

[0111] Percentage of obsolete inventory = Number of goods / Total number of goods…………………………(3)

[0112] Below is a schematic diagram of the report on the proportion of stagnant inventory, see Table 2:

[0113]

[0114]

[0115] Table 2 Report on the proportion of obsolete inventory

[0116] The inventory data in Table 2 is only partially illustrated, and the user can set it according to his actual needs, and the present invention does not limit it.

[0117] Next, through Figure 4 The bar chart shows the comparison of the proportion of obsolete inventory.

[0118] The figure compares the proportion of stagnant inventory in the eastern, western, southern and northern regions. Figure 4 The unit of the middle horizontal axis is percentage (%). For example, the proportion of obsolete inventory in the eastern region is 82%; the proportion of obsolete inventory in the western region is 49%; the proportion of obsolete inventory in the northern region is 26%; and the proportion of obsolete inventory in the southern region is 75%.

[0119] Of course, the percentage of obsolete inventory can be calculated by time interval. For specific implementation methods, please refer to the example of calculating the percentage of obsolete price by time interval.

[0120] Of course, you can also calculate the percentage of stagnant inventory in continuous time intervals. For example, you can calculate the percentage of stagnant inventory in each month. For example, taking the owner of the product A as an example, the percentage of stagnant inventory in January 2023 is 26%, the percentage of stagnant inventory in February 2023 is 42%, the percentage of stagnant inventory in March 2023 is 19%, the percentage of stagnant inventory in April 2023 is 56%, and the percentage of stagnant inventory in May 2023 is 52%. And so on. Figure 5 The unit of the vertical axis is percentage (%), please refer to Figure 5 Line chart.

[0121] The present invention analyzes inventory data based on the obsolete inventory ratio analysis dimension to obtain the obsolete inventory ratio corresponding to the commodity owner, and then analyzes the obsolete commodities to find the causes of the obsolete inventory and solve the problem.

[0122] In a specific embodiment, the inventory analysis dimension includes an average inventory analysis dimension. When the inventory analysis dimension is the average inventory analysis dimension, analyzing inventory data based on preset inventory analysis dimensions and inventory analysis strategies corresponding to the preset inventory analysis dimensions to obtain a first inventory analysis file includes analyzing inventory data based on the average inventory analysis dimension and the inventory analysis strategy corresponding to the average inventory analysis dimension (i.e., the average inventory analysis strategy) to obtain the first inventory analysis file. The specific implementation process includes:

[0123] The inventory quantity of the product in the warehouse and the initial entry date of the product are obtained; the sum of the current date and a third preset value is calculated to obtain a sum result; the difference between the sum result and the initial entry date is calculated to obtain a third difference value; the quotient of the third difference and the inventory quantity is calculated to obtain a second quotient value, and the second quotient value is used as the average inventory age; and a first inventory analysis file is obtained based on the inventory data and the average inventory age.

[0124] Specifically, the average storage age can be obtained using formula (4):

[0125] Average inventory age = ((current date + third preset value) - initial inventory date) / inventory quantity... (4)

[0126] The third preset value may be 1.

[0127] Below is a schematic diagram of the average inventory age report, see Table 3:

[0128] Commodity owner Product Name Product Code Product inventory quantity Initial warehousing date Average storage age A 111 AA1100 1000 2023 / 5 / 6 230 days B 222 BB2200 1500 2023 / 8 / 5 146 days C 333 CC3300 5000 2023 / 5 / 9 226 days D 444 DD4400 8300 2023 / 5 / 9 226 days

[0129] Table 3 Average storage age report

[0130] The inventory data in Table 3 is only partially illustrated, and the user can set it according to his actual needs, and the present invention does not limit it.

[0131] The present invention analyzes inventory data based on the average inventory analysis dimension to obtain the average inventory age corresponding to the commodity owners, and then analyzes the commodities based on the average inventory age to make real-time adjustments to the warehouse's outbound and inbound strategies.

[0132] In a specific embodiment, the inventory analysis dimension includes a product storage validity period analysis dimension. When the inventory analysis dimension is the product storage validity period analysis dimension, analyzing inventory data based on each preset inventory analysis dimension and the inventory analysis strategy corresponding to each inventory analysis dimension to obtain a first inventory analysis file includes: analyzing inventory data based on the product storage validity period analysis dimension and the inventory analysis strategy corresponding to the product storage validity period analysis dimension to obtain the first inventory analysis file. The specific implementation process includes:

[0133] The initial entry date of the product is obtained; the difference between the current date and the initial entry date is calculated to obtain a fourth difference, and the fourth difference is used as the storage validity period of the product; and a first inventory analysis file is obtained based on the inventory data and the storage validity period of the product.

[0134] When a product is first placed in the warehouse, the initial entry time will be recorded and a storage validity period will be configured for the product.

[0135] Specifically, the storage validity period of the product can be obtained by formula (5):

[0136] Storage validity period = current date - initial storage date………………………………(5)

[0137] For example, take the storage validity period range of [0 days, 45 days] as an example to illustrate:

[0138] If the storage validity period is less than or equal to 0 days, it indicates that the product is expired; if the storage validity period is greater than 0 days and less than or equal to 45 days, it indicates that the product is in an expiration warning state; if the storage validity period is greater than 45 days, it indicates that the product is in normal inventory.

[0139] The present invention analyzes inventory data based on the commodity storage validity period analysis dimension to obtain the storage validity period corresponding to the commodity owner, and then analyzes the expired commodities to find the reasons for the expiration and solve the problem.

[0140] In addition, since the product has become an expired product, the corresponding product price has also become an expired price.

[0141] For example, the expiration price corresponding to the commodity owner A is 1,000 yuan, and the total expiration price corresponding to the warehouse corresponding to the commodity owner A is 10,000 yuan. By calculating the quotient of the expiration price and the total expiration price, the proportion of the expired price is obtained.

[0142] Of course, the proportion of expired prices can also be calculated by region.

[0143] For example, all regions are divided into the eastern region, the western region, the southern region, and the northern region.

[0144] For example, calculate the expired prices in the eastern region, the western region, the southern region, and the northern region during a preset time period (e.g., January 2023 to March 2023), and divide the above results by the total expired prices of the warehouse to obtain the regional percentage of expired prices. Figure 6 For example, the expired price in the eastern region is 550,000 yuan, the expired price in the western region is 760,000 yuan, the expired price in the southern region is 320,000 yuan, and the expired price in the northern region is 610,000 yuan. Figure 6 The unit of the horizontal axis is ten thousand yuan.

[0145] For example, you can also calculate according to the storage validity period, the proportion of the price of goods with a storage validity period of less than or equal to 0 days to the total price of the goods (the proportion of expired prices); the proportion of the price of goods with a storage validity period of greater than 0 days and less than or equal to 45 days to the total price of the goods; the proportion of the price of goods with a storage validity period of greater than 45 days to the total price of the goods. For details, please refer to Figure 7 For example, the percentage of expired prices for storage with a validity period of less than or equal to 0 days is indicated by a lower diagonal dashed line, representing a 10% percentage. The percentage of expired prices for storage with a validity period of greater than 0 days and less than or equal to 45 days is indicated by bricks, representing a 15% percentage. The percentage of expired prices for storage with a validity period of greater than 45 days is indicated by a grid, representing a 75% percentage.

[0146] Of course, the specific implementation methods of price and quantity are the same. The above example uses price as an example for illustration, and the quantity is the same.

[0147] In a specific embodiment, the first inventory analysis file includes inventory age, which is obtained based on the current date and the initial inventory entry date of the product, and is obtained by calculating the difference between the current date and the initial inventory entry date.

[0148] After obtaining the first inventory analysis file, determining whether a first inventory age in the first inventory analysis file is greater than a preset first alarm threshold; if it is determined that the first inventory age is greater than the first alarm threshold, calculating a difference between the first inventory age and the first alarm threshold to obtain a fourth difference; determining an alarm level based on the fourth difference, and generating alarm information corresponding to the alarm level.

[0149] Specifically, the inventory age of the commodity can be obtained from the report of the first inventory analysis file.

[0150] When the first storage age of a commodity is greater than a first alarm threshold, the present invention determines the alarm level and performs an alarm operation so that the commodity owner or warehouse manager can analyze the commodity in a timely manner and adjust the commodity's outbound and inbound strategies in real time.

[0151] In a specific embodiment, after obtaining the first inventory analysis file, the product analysis requirements corresponding to the product owner are obtained, wherein the product analysis requirements are used to indicate the product owner's analysis requirements for target data in the inventory data, and the target data is determined by the product owner; based on the product analysis requirements, the target data in the first inventory analysis file is statistically analyzed to obtain a second inventory analysis file.

[0152] The second inventory file includes any one or more of a table, a report, a line chart, a ring chart, a bar chart, etc. The present invention does not limit this, and the user can set it according to his actual needs.

[0153] Among them, the commodity analysis needs corresponding to commodity owners include: statistical analysis of the age of obsolete inventory within a specific time period, statistical analysis of the proportion of obsolete inventory within a specific time period, statistical analysis of the average age of inventory within a specific time period, statistical analysis of the storage validity period of commodities within a specific time period, etc.

[0154] Specifically, based on the commodity analysis requirements, the inventory data in the report in the first inventory analysis file is used to perform statistics (for example, summing or averaging operations according to preset weights) to obtain the second inventory analysis file.

[0155] The present invention analyzes the first inventory analysis file based on the commodity analysis requirements to obtain the second inventory analysis file. It can be seen that the present invention generates a second inventory analysis file that can be viewed intuitively based on the first inventory analysis file according to the commodity analysis requirements of the commodity owner. By obtaining the first inventory analysis file and the second inventory analysis file, a multi-level analysis is performed on the inventory data to obtain commodities that do not meet the requirements (for example, slow-moving commodities, expired commodities, etc.), analyze the reasons for the commodities that do not meet the requirements, solve the problems that arise, and adjust the commodity outbound and inbound strategies in real time.

[0156] In a specific embodiment, the second inventory analysis file includes inventory age, which is obtained based on the current date and the initial inventory entry date of the product.

[0157] After obtaining the second inventory analysis file, determining whether the second inventory age in the second inventory analysis file is greater than a preset second alarm threshold; if it is determined that the second inventory age is greater than the second alarm threshold, calculating the difference between the second inventory age and the second alarm threshold to obtain a fifth difference; determining an alarm level based on the fifth difference, and generating alarm information corresponding to the alarm level.

[0158] Specifically, the inventory age of the commodity can be obtained from the report in the second inventory analysis file.

[0159] When the second storage age of a commodity is greater than a second alarm threshold, the present invention determines the alarm level and performs an alarm operation so that the commodity owner or warehouse manager can analyze the commodity in a timely manner and adjust the commodity's outbound and inbound strategies in real time.

[0160] In a specific embodiment, after obtaining the first inventory analysis file and the second inventory analysis file, a shipping strategy, an incoming strategy, and a replenishment strategy corresponding to the product are generated.

[0161] For example, for goods with high liquidity (high turnover), they can be placed at the warehouse entrance to facilitate the goods' outbound, inbound, and replenishment operations. For goods with low liquidity (low turnover), they can be placed in the corner of the warehouse to reserve space for other goods with relatively high turnover.

[0162] The following is a schematic illustration of the specific implementation process of the present invention:

[0163] Inventory data is extracted from the management system, stored in a database, and the steps of the above-mentioned inventory data processing method are performed using the inventory data stored in the database. Furthermore, the obtained first inventory analysis file and second inventory analysis file are transmitted to the smart device through a preset interface for display on the smart device.

[0164] In addition, for inventory data that smart devices need to display in real time, the management system can directly transmit it to the smart device through a preset interface, or the management system can directly interact with the smart device and transmit the inventory data to the smart device. Figure 8 .

[0165] Among them, the management system includes: order management system, transportation management system, warehouse management system and billing management system, etc.

[0166] The present invention automatically analyzes inventory data through multiple inventory analysis dimensions and generates a first inventory analysis file that can be viewed intuitively. The entire process does not require human intervention, effectively solving a series of problems in the prior art of manually analyzing inventory data, such as low accuracy, low efficiency, and high labor costs. Furthermore, based on the commodity analysis requirements, the first inventory analysis file is analyzed to obtain a second inventory analysis file. It can be seen that the present invention generates a second inventory analysis file that can be viewed intuitively based on the first inventory analysis file according to the commodity analysis requirements of the commodity owner. By obtaining the first inventory analysis file and the second inventory analysis file, a multi-level analysis of the inventory data is performed to obtain commodities that do not meet the requirements (for example, stagnant commodities, expired commodities, etc.), analyze the reasons for the commodities that do not meet the requirements, solve the problems that arise, and make real-time adjustments to the commodity's outbound and inbound strategies.

[0167] The following describes an inventory data processing device provided by an embodiment of the present invention. The device is applied to a client. The inventory data processing device described below and the inventory data processing method applied to a client described above can be referred to each other. The repeated parts will not be repeated. Figure 9 As shown, the device includes:

[0168] The acquisition module 901 is used to obtain the inventory data of the goods stored in the warehouse by the goods owner;

[0169] The analysis module 902 is configured to analyze the inventory data based on preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

[0170] In a specific embodiment, the inventory analysis dimension includes: a stagnant inventory analysis dimension; an analysis module 902, specifically configured to determine whether there is a shipment record for the product in the warehouse; if it is determined that there is a shipment record for the product, obtain the last shipment date corresponding to the product; calculate the sum of a current date and a first preset value to obtain a sum result; calculate the difference between the sum result and the last shipment date to obtain a first difference; if the first difference is greater than a second preset value, use the first difference as the stagnant inventory age of the product; obtain a first inventory analysis file based on the inventory data and the stagnant inventory age; if it is determined that there is no shipment record for the product, obtain the last entry date corresponding to the product; calculate the sum of the current date and the first preset value to obtain a sum result; calculate the difference between the sum result and the last shipment date to obtain a second difference; if the second difference is greater than the second preset value, use the second difference as the stagnant inventory age of the product; and obtain the first inventory analysis file based on the inventory data and the stagnant inventory age.

[0171] In a specific embodiment, the inventory analysis dimension includes: a slow-moving inventory ratio analysis dimension; an analysis module 902 is specifically used to determine the number of slow-moving inventory-aged goods corresponding to the goods owner and the total number of goods in the warehouse; calculate the quotient of the quantity and the total quantity to obtain a first quotient value, and use the first quotient value as the slow-moving inventory ratio of the goods; and obtain a first inventory analysis file based on the inventory data and the slow-moving inventory ratio.

[0172] In a specific embodiment, the inventory analysis dimension includes: an average inventory analysis dimension; an analysis module 902, specifically configured to obtain the inventory quantity of goods in the warehouse and the initial entry date of the goods; calculate the sum of the current date and a third preset value to obtain a sum result; calculate the difference between the sum result and the initial entry date to obtain a third difference; calculate the quotient of the third difference and the inventory quantity to obtain a second quotient value, and use the second quotient value as the average inventory age; and obtain a first inventory analysis file based on the inventory data and the average inventory age.

[0173] In a specific embodiment, the inventory analysis dimension includes: a product storage validity period analysis dimension; an analysis module 902 is specifically used to obtain the initial storage date of the product; calculate the difference between the current date and the initial storage date to obtain a fourth difference, and use the fourth difference as the storage validity period of the product; and obtain a first inventory analysis file based on the inventory data and the storage validity period of the product.

[0174] In a specific embodiment, the first inventory analysis file includes an inventory age, which is obtained based on a current date and an initial inventory entry date of the product. The device also includes: an alarm module, configured to determine whether a first inventory age in the first inventory analysis file is greater than a preset first alarm threshold; if it is determined that the first inventory age is greater than the first alarm threshold, calculating a difference between the first inventory age and the first alarm threshold to obtain a fourth difference; determining an alarm level based on the fourth difference, and generating alarm information corresponding to the alarm level.

[0175] In a specific embodiment, the analysis module 902 is further used to obtain a product analysis requirement corresponding to a product owner, wherein the product analysis requirement is used to indicate the product owner's analysis requirement for target data in the inventory data, and the target data is determined by the product owner; based on the product analysis requirement, the target data in the first inventory analysis file is statistically analyzed to obtain a second inventory analysis file.

[0176] In a specific embodiment, the second inventory analysis file includes an inventory age, which is obtained based on a current date and an initial inventory entry date of the product. The alarm module is further configured to determine whether a second inventory age in the second inventory analysis file is greater than a preset second alarm threshold. If it is determined that the second inventory age is greater than the second alarm threshold, the difference between the second inventory age and the second alarm threshold is calculated to obtain a fifth difference. Based on the fifth difference, an alarm level is determined, and an alarm message corresponding to the alarm level is generated.

[0177] Figure 10 An example of a physical structure diagram of an electronic device is shown below. Figure 10 As shown, the electronic device may include: a processor 1001, a communications interface 1002, a memory 1003, and a communications bus 1004. The processor 1001, communications interface 1002, and memory 1003 communicate with each other via the communications bus 1004. The processor 1001 may invoke logic instructions in the memory 1003 to execute an inventory data processing method, which includes: obtaining inventory data of goods stored in a warehouse by a goods owner; and analyzing the inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

[0178] In addition, the logic instructions in the above-mentioned memory 1003 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0179] On the other hand, the present invention further provides a computer program product, comprising a computer program stored on a non-transitory computer-readable storage medium, the computer program comprising program instructions. When the program instructions are executed by a computer, the computer is capable of performing the inventory data processing method provided by the above-mentioned methods, the method comprising: obtaining inventory data of goods stored in a warehouse by a goods owner; and analyzing the inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

[0180] In yet another aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon. When executed by a processor, the computer program is implemented to perform the above-mentioned inventory data processing methods, the methods comprising: obtaining inventory data of goods stored in a warehouse by a goods owner; and analyzing the inventory data based on pre-set inventory analysis dimensions and inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

[0181] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, i.e., they may be located in one location or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of the present embodiment. Persons of ordinary skill in the art will be able to understand and implement the present invention without inventive effort.

[0182] Through the description of the above embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus a necessary general hardware platform, or of course, by hardware. Based on this understanding, the essence of the above technical solution or the part that contributes to the existing technology can be embodied in the form of a software product. The computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a magnetic disk, an optical disk, etc., and includes a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or certain parts of the embodiments.

[0183] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A method for processing inventory data, characterized in that: The method comprises: Obtain inventory data of goods stored in the warehouse by the goods owner; Based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions, the inventory data is analyzed to obtain a first inventory analysis file.

2. The inventory data processing method according to claim 1, characterized in that: The inventory analysis dimensions include: slow-moving inventory analysis dimensions; Analyzing the inventory data based on the slow-moving inventory analysis dimension and the inventory analysis strategy corresponding to the slow-moving inventory analysis dimension to obtain the first inventory analysis file includes: Determine whether there is a shipment record for the product in the warehouse; If it is determined that the product has the shipment record, obtaining the last shipment date corresponding to the product; calculating the sum of the current date and a first preset value to obtain a sum result; calculating the difference between the sum result and the last shipment date to obtain a first difference; if the first difference is greater than a second preset value, using the first difference as the slow-moving inventory age of the product; and obtaining the first inventory analysis file based on the inventory data and the slow-moving inventory age. If it is determined that no outbound record exists for the product, the last entry date corresponding to the product is obtained; the sum of the current date and the first preset value is calculated to obtain a sum result; the difference between the sum result and the last entry date is calculated to obtain a second difference; if the second difference is greater than the second preset value, the second difference is used as the slow-moving inventory age of the product; and the first inventory analysis file is obtained based on the inventory data and the slow-moving inventory age.

3. The inventory data processing method according to claim 2, characterized in that: The inventory analysis dimensions include: slow-moving inventory ratio analysis dimension; The inventory data is analyzed based on the slow-moving inventory ratio analysis dimension and the inventory analysis strategy corresponding to the slow-moving inventory ratio analysis dimension to obtain the first inventory analysis file, including: Determine the number of slow-moving goods corresponding to the goods owner and the total number of goods in the warehouse; Calculating a quotient of the quantity and the total quantity to obtain a first quotient value, and using the first quotient value as the slow-moving inventory ratio of the product; The first inventory analysis file is obtained based on the inventory data and the slow-moving inventory ratio.

4. The inventory data processing method according to any one of claims 1 to 3, characterized in that: The inventory analysis dimensions include: average inventory analysis dimensions; Analyzing the inventory data based on the average inventory analysis dimension and the inventory analysis strategy corresponding to the average inventory analysis dimension to obtain the first inventory analysis file includes: Obtain the inventory quantity of the product in the warehouse and the initial warehousing date of the product; Calculate the sum of the current date and the third preset value to obtain a sum result; Calculating the difference between the summed result and the initial warehousing date to obtain a third difference; Calculating a quotient of the third difference and the inventory quantity to obtain a second quotient value, and using the second quotient value as the average inventory age; The first inventory analysis file is obtained based on the inventory data and the average inventory age.

5. The inventory data processing method according to any one of claims 1 to 3, characterized in that: The inventory analysis dimension includes: commodity storage validity period analysis dimension; Analyzing the inventory data based on the commodity storage validity period analysis dimension and the inventory analysis strategy corresponding to the commodity storage validity period analysis dimension to obtain the first inventory analysis file includes: Get the initial entry date of the product; Calculating the difference between the current date and the initial warehousing date to obtain a fourth difference, and using the fourth difference as the storage validity period of the product; The first inventory analysis file is obtained based on the inventory data and the storage validity period of the commodity.

6. The inventory data processing method according to any one of claims 1 to 3, characterized in that: The first inventory analysis file includes inventory age, where the inventory age is obtained based on the current date and the initial inventory entry date of the product; After analyzing the inventory data based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions to obtain the first inventory analysis file, the method further includes: determining whether a first inventory age in the first inventory analysis file is greater than a preset first alarm threshold; When it is determined that the first storage age is greater than the first alarm threshold, calculating the difference between the first storage age and the first alarm threshold to obtain a fourth difference; Based on the fourth difference, an alarm level is determined, and alarm information corresponding to the alarm level is generated.

7. The inventory data processing method according to claim 1, characterized in that: After analyzing the inventory data based on the preset inventory analysis dimensions and the inventory analysis strategies corresponding to the inventory analysis dimensions to obtain the first inventory analysis file, the method further includes: Obtaining a commodity analysis requirement corresponding to the commodity owner, wherein the commodity analysis requirement is used to indicate the commodity owner's analysis requirement for target data in the inventory data, the target data being determined by the commodity owner; Based on the commodity analysis requirement, statistics are collected on the target data in the first inventory analysis file to obtain a second inventory analysis file.

8. The inventory data processing method according to claim 7, characterized in that: The second inventory analysis file includes inventory age, where the inventory age is obtained based on the current date and the initial inventory entry date of the product; After analyzing the first inventory analysis file based on the commodity analysis requirement to obtain the second inventory analysis file, the method further includes: determining whether a second inventory age in the second inventory analysis file is greater than a preset second alarm threshold; When it is determined that the second storage age is greater than the second alarm threshold, calculating the difference between the second storage age and the second alarm threshold to obtain a fifth difference; Based on the fifth difference, an alarm level is determined, and alarm information corresponding to the alarm level is generated.

9. An inventory data processing device, characterized in that: The device comprises: The acquisition module is used to obtain the inventory data of the goods stored in the warehouse by the goods owner; The analysis module is configured to analyze the inventory data based on preset inventory analysis dimensions and inventory analysis strategies corresponding to the inventory analysis dimensions to obtain a first inventory analysis file.

10. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the inventory data processing method according to any one of claims 1 to 8 is implemented.

11. A non-transitory computer-readable storage medium, characterized in that A computer program is stored thereon, and when the computer program is executed by a processor, the inventory data processing method according to any one of claims 1 to 8 is implemented.

Images