Commodity purchase-sale-stock management method and device, front compensation cabinet and computer storage medium

Abstract

The invention discloses a commodity purchase-sale-stock management method and device, a front compensation cabinet and a computer storage medium, and relates to the technical field of commodity storage cabinet management, the management method comprises the following steps: maintaining commodity information, maintaining the commodity information to a corresponding commodity, the commodity information comprising a commodity name, a commodity model, a commodity allocation and a commodity package size; identifying commodity information, and identifying each item of commodity information on the commodity; processing the commodity information, and calculating the stock quantity of the commodities according to the warehouse-in and warehouse-out information of the commodities; the management end is used for managing commodity sales orders, analyzing and processing commodity sales data according to commodity sales conditions, making sales predictions for sales volume of commodities according to different types of commodity sales conditions in different time periods, and pushing the sales predictions to the corresponding display ends; the system can automatically identify and record various information and inventory conditions of commodities, is connected with a commodity management system platform, can count and record sales volume of each commodity in a specific time period, and makes sales prediction.

Description

Technical Field

[0001] The present invention relates to the technical field of commodity storage cabinet management, and in particular to a commodity purchase, sales and inventory management method, device, pre-replenishment cabinet and computer storage medium. Background Art

[0002] At present, when the front replenishment cabinets of goods are used for warehousing, the situation of goods entering and leaving the cabinets is generally not counted, or it is manually counted, recorded in account books or manually entered into computers for commodity management. It is impossible to automatically identify and record the information of goods entering and leaving the cabinets and synchronize the commodity management system for commodity management; it usually takes half a year or a year, when the store is closed for inventory, to count more accurate data. The workload is huge, time-consuming and labor-intensive, prone to business trips, and will also affect the normal business of the store; and it is impossible to connect the sales data with the commodity order management system, combine the sales data of the previous year, and make sales forecasts for the sales volume of the goods, resulting in insufficient stock of some best-selling products, and serious inventory backlogs of some non-best-selling products, resulting in waste of storage space. Summary of the invention

[0003] The purpose of the present invention is to provide a commodity purchase, sales and inventory management method, device, front replenishment cabinet and computer storage medium, which can automatically identify and record various information and inventory status of commodities, and is connected to a commodity management system platform, which can count and record the sales volume of each commodity in a specific time period and make sales forecasts.

[0004] The present invention includes a commodity purchase, sales and inventory management method, comprising the following steps:

[0005] Maintain product information, and maintain product information on the corresponding products. Product information includes product name, product model, product location and product packaging size;

[0006] Identify product information and identify various product information on the product;

[0007] Process product information and calculate the inventory quantity of products based on the product inbound and outbound information;

[0008] Manage product sales orders, analyze and process product sales data based on product sales, make sales forecasts for the product based on the sales of different types of products in different time periods, and push the forecasts to the corresponding display terminals.

[0009] Preferably, the product name, product model number and product location are represented by different letters, symbols or numbers.

[0010] Preferably, the product model includes features for distinguishing the product from other products of the same type, including product size, product color, and product flavor.

[0011] Preferably, managing product sales orders specifically includes: counting the product size, product color and product flavor of the sold products on a daily, monthly or quarterly basis according to the set replenishment cycle, and calculating sales forecasts based on the statistical sales data to predict the quantity of corresponding products that need to be replenished at the corresponding time of the next replenishment cycle.

[0012] Preferably, the statistical cycle for managing commodity sales orders is one year. Combined with the replenishment cycle, the sales volume in the corresponding time period in the future is predicted based on the sales volume of the same product in the same time period of the previous year.

[0013] Preferably, the number of shelves required for a certain product is calculated in combination with product packaging size information, sales forecasts, and replenishment cycles, and the shelf allocation is adjusted in real time.

[0014] Preferably, the sales volume of products of different product sizes, product colors, and product flavors within a certain period of time is counted and sorted to calculate a ranking list of the most popular products.

[0015] The present invention also includes a management device for commodity pre-replenishment cabinets using the commodity purchase, sales and inventory management method as described above, the management device comprising:

[0016] Product information unit, used to mark the product name, product model, product location and product packaging size of the product;

[0017] The commodity identification and collection unit is used to identify and collect various information on the commodity information unit and transmit it to the front-end system unit;

[0018] The front-end system unit obtains the information of the goods entering and exiting the cabinet through the commodity identification and collection unit, performs calculations and processing, counts the inventory quantity of the goods, and transmits the commodity name, commodity model, commodity location and inventory quantity to the front-end display unit;

[0019] The front-end display unit is used to display the product name, product model, product location, inventory quantity and product sales ranking of the products in the front replenishment cabinet;

[0020] The commodity management system unit analyzes and processes commodity sales data according to commodity sales orders, and makes sales forecasts for various commodities in different time periods;

[0021] The back-end display unit is used to display the calculation data processed by the commodity management system unit.

[0022] The present invention also includes a front compensation cabinet, which includes:

[0023] A processor and a memory, wherein the memory is communicatively connected with the processor;

[0024] The memory is used to store executable instructions executed by at least one processor, and the processor is used to execute the executable instructions to implement any one of the commodity purchase, sales and inventory management methods described above.

[0025] The present invention also includes a computer-readable storage medium, in which a computer program is stored. When the computer program is executed by a processor, the method for managing the purchase, sale and inventory of goods as described above is implemented.

[0026] In summary, the present invention has the following beneficial effects:

[0027] 1. It can automatically identify and record various information of the goods entering and leaving the cabinet, and display the information of the goods such as the name, model, location, inventory quantity and sales ranking of the goods on the front display unit, which is convenient for the use of the cabinet and the retrieval of goods. It also displays the inventory quantity in real time, replenishes the goods in time, reduces the workload and error probability of inventory counting, and improves work efficiency. Displaying the sales ranking of goods is conducive to attracting customers and promoting hot-selling goods.

[0028] 2. With a commodity management system platform, it can count and record the sales volume of each commodity in a specific time period. When a sales order is successfully created, the order automatically allocates commodity storage information, and the delivery personnel go to the corresponding cabinet to take out the ordered goods according to the commodity storage information; the front-end and back-end system platforms automatically update the commodity inventory information; and record the sales data of a certain commodity in a specific time period, and make a sales forecast for the next corresponding time period; according to the sales forecast calculated by the system, stock up in advance to avoid out-of-stock and sales losses, and also avoid stocking too much goods and causing inventory backlogs;

[0029] 3. Based on the sales forecast of a certain commodity calculated by the system and the commodity packaging size, calculate the number of shelves required for a certain commodity in the future, adjust the shelf allocation in real time, reasonably allocate commodity shelves, and improve the utilization efficiency of the front-end cabinet shelves. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] Figure 1 It is the main flow chart of the commodity purchase, sales and inventory management method of the present invention;

[0031] Figure 2 A flowchart of the steps of managing a commodity sales order in the commodity purchase, sales and inventory management method of the present invention;

[0032] Figure 3 The present invention is a structural block diagram of a management device for pre-replenishment of goods. DETAILED DESCRIPTION

[0033] The present invention will be further described below in conjunction with the accompanying drawings.

[0034] The positions mentioned in this specification are based on the positions of the commodity purchase, sales and inventory management method, device, front replenishment cabinet and computer storage medium of the present invention when they are working normally. The positions during storage and transportation are not limited and only represent relative position relationships, not absolute position relationships.

[0035] like Figure 1 As shown, a commodity purchase, sales and inventory management method is applied to commodity information management of commodity pre-replenishment cabinets, including the following steps:

[0036] Step 101, maintain product information, and maintain the product information on the corresponding product. The product information includes product name, product model, product location and product packaging size; the product model includes characteristics used to distinguish it from other similar products, including product size, product color, and product flavor; the product packaging size is used to display the external dimensions of different products, and the product location is allocated according to the external dimensions of different products; the product name, product model, and product location are represented by different letters, symbols or numbers, among which the product size, product color, and product flavor in the product model are also distinguished by different letters, symbols or numbers, thereby forming a unique code for identifying the product; the carrier of the product code can be an RFID tag card or other uniquely identifiable mark attached to the product.

[0037] Step 102, identifying the product information, mainly through a camera or a code scanning device, identifying the product code, identifying the product information on the product, and recording the product information, depending on the carrier of the product code.

[0038] Step 103, process the product information, store and process the identified products, convert them into text and pictures, and display them on the display terminal, including the product name, product model and product storage location, and record the product's warehousing and outbound information, calculate the inventory quantity and product storage location of the product, and display them on the display terminal; the product packaging size is mainly used to allocate storage locations, and is not displayed on the front-end display terminal.

[0039] Step 104, manage the product sales order, analyze and process the product sales data according to the product sales situation, make sales forecasts for different time periods for different products according to the sales situation of different types of products in different time periods, and push them to the corresponding display terminal.

[0040] When a sales order is successfully created, the order is automatically assigned with product location information, and the delivery staff takes out the ordered products from the corresponding cabinets based on the product location information; the front-end and back-end system platforms automatically update the product inventory information; and record the sales data of a certain product within a specific time period, and make a sales forecast for the next corresponding time period; the sales forecast is a table that predicts the sales volume of a product within a specific time period in the future. Combined with the replenishment cycle, it can more intuitively and specifically display the correspondence between future sales data and time. It is widely used in the fast-moving consumer goods industry. According to the sales forecast, production lines, production capacity, raw materials and finished products are prepared, which has great positive significance for inventory control and cost management.

[0041] In order to better understand the above embodiments, Figure 2 As shown, the present invention also provides a flowchart of steps for managing a commodity sales order of a commodity purchase, sales and inventory management method, the method at least comprising:

[0042] Step 201, based on the statistical sales data and the set replenishment cycle, the product size, product color and product flavor of the sold products are counted on a daily, monthly or quarterly basis to predict the quantity of corresponding products to be replenished in the next replenishment cycle.

[0043] According to the needs, the statistical cycle for managing commodity sales orders is usually one year. The future sales situation is predicted based on the sales volume of similar products in the same period of the previous year, and a sales forecast table is provided;

[0044] To facilitate the calculation method of the above sales forecast, take a certain product as an example, assuming that the replenishment cycle is one month, the sales volume of a certain brand of size 37 red slippers in some months of the previous year is as follows:

[0045] April May June July August 10 pairs 12 pairs 14 pairs 14 pairs 12 pairs

[0046] If the sales volume fluctuation ratio is set to ±10% and rounded up, the sales forecast for size 37 red slippers of a certain brand in the corresponding month of this year can be given as follows:

[0047] April May June July August Maximum sales 11 pairs 14 pairs 16 pairs 16 pairs 14 pairs Minimum sales volume 9 pairs 11 pairs 13 pairs 13 pairs 11 pairs

[0048] According to the sales forecast calculated by the system, stock up in advance to avoid out-of-stock and loss of sales, and also to avoid stocking too much and causing inventory backlogs. Food, beverages and other flavored goods can also be calculated in the same way. In fact, the statistical period is usually one year, and the full-year sales can be predicted at most, so that factories can prepare raw materials and production lines in advance and reserve production capacity.

[0049] Among them, the sales volume fluctuation ratio and replenishment cycle can be set by yourself in the back end according to the situation. When the replenishment cycle is monthly, the system will count the sales volume on a monthly basis and calculate the monthly sales forecast. When the replenishment cycle is daily, the system will count the sales volume on a daily basis and calculate the daily sales forecast.

[0050] At the same time, specific statistical intervals can be set for special products. For example, seasonal cold products such as ice cream can have statistical intervals set according to the duration of the local summer. Traditional holiday foods such as mooncakes can also have separate statistical intervals set according to the dates of holidays that year.

[0051] Step 202, based on the sales forecast of a certain commodity calculated by the system and in combination with the commodity packaging size, calculate the number of shelves required for the certain commodity in the future, adjust the shelf allocation in real time, reasonably allocate the commodity shelves, and improve the utilization efficiency of the front-end cabinet shelves.

[0052] Step 203, count the sales of different product sizes, product colors, and product flavors within a certain period of time, sort them, calculate the ranking list of the most popular products, and push the ranking list information to customers to achieve the effect of publicity.

[0053] like Figure 3 As shown, a management device for front-end replenishment of goods in a method for managing goods purchase, sale and inventory, the management device comprises:

[0054] Product information unit, used to mark the product name, product model, product location and product packaging size of the product;

[0055] The commodity identification and collection unit is used to identify and collect various information on the commodity information unit and transmit it to the front-end system unit;

[0056] The front-end system unit obtains the information of the goods before entering and leaving the cabinet through the commodity identification and collection unit, performs calculations and processing, counts the inventory quantity of the goods, and transmits the commodity name, commodity model, commodity location and inventory quantity to the front-end display unit;

[0057] The front-end display unit is used to display the product name, product model, product location, inventory quantity and product sales ranking of the products in the front replenishment cabinet;

[0058] The commodity management system unit analyzes and processes commodity sales data according to commodity sales orders, and makes sales forecasts for various commodities in different time periods;

[0059] The back-end display unit is used to display the calculation data processed by the commodity management system unit, including the commodity name, commodity model, commodity location, inventory quantity, commodity packaging size, sales forecast, and other information setting pages of the commodities in the front replenishment cabinet.

[0060] A front replenishment cabinet includes: a processor and a memory, wherein the memory is communicatively connected to the processor; the memory is used to store executable instructions executed by at least one processor, and the processor is used to execute the executable instructions to implement the commodity purchase, sales and inventory management method as described above.

[0061] In this embodiment, the memory may be implemented in any appropriate manner, for example, the memory may be a read-only memory, a mechanical hard disk, a solid-state hard disk, or a USB flash drive, etc.; the memory is used to store at least one executable instruction executed by the processor;

[0062] In this embodiment, the processor can be implemented in any appropriate manner. For example, the processor can take the form of a microprocessor or a processor and a computer-readable medium storing computer-readable program code (such as software or firmware) that can be executed by the microprocessor, a logic gate, a switch, an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), a programmable logic controller, and an embedded microcontroller, etc.; the processor is used to execute executable instructions to implement the commodity purchase, sales and inventory management method as described above.

[0063] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the commodity purchase, sales and inventory management method as described above.

[0064] Those of ordinary skill in the art will appreciate that the modules and method steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0065] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described devices, equipment and modules can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0066] In the several embodiments provided in the present application, it should be understood that the disclosed devices, apparatuses and methods can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of the modules is only a logical function division. There may be other division methods in actual implementation, such as multiple modules or units can be combined or integrated into another device, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or equipment, which can be electrical, mechanical or other forms.

[0067] The modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0068] In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist physically separately, or two or more modules may be integrated into one module.

[0069] If the functions are implemented in the form of software function modules and sold or used as independent products, they can be stored in a computer-readable storage medium. 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, including several instructions for a computer device (which can be a personal computer, server, or 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 instructions, such as a USB flash drive, a mobile hard disk, a read-only storage server, a random access storage server, a magnetic disk or an optical disk.

[0070] Of course, the above description is not a limitation of the present invention, and the present invention is not limited to the above examples. Changes, modifications, additions or substitutions made by technicians in this technical field within the essential scope of the present invention should also fall within the protection scope of the present invention.

Claims

1. A commodity purchase, sales and inventory management method, characterized in that: The steps include: Maintain product information, and maintain the product information on the corresponding product, the product information includes product name, product model, product location and product packaging size; Identify product information and identify various product information on the product; Process product information and calculate the inventory quantity of products based on the product inbound and outbound information; Manage product sales orders, analyze and process product sales data based on product sales, make sales forecasts for the product based on the sales of different types of products in different time periods, and push the forecasts to the corresponding display terminals.

2. A commodity purchase, sales and inventory management method as claimed in claim 1, characterized in that: The product name, product model and product location are represented by different letters, symbols or numbers.

3. A commodity purchase, sales and inventory management method as claimed in claim 1, characterized in that: The product model includes features used to distinguish it from other products of the same type, including product size, product color, and product flavor.

4. A commodity purchase, sales and inventory management method as claimed in claim 3, characterized in that: The management of commodity sales orders specifically includes: according to the set replenishment cycle, statistics are collected on the commodity size, commodity color and commodity flavor of the sold commodities on a daily, monthly or quarterly basis, and sales forecasts are calculated based on the statistical sales data to predict the quantity of the corresponding commodity to be replenished at the corresponding time of the next replenishment cycle.

5. A commodity purchase, sales and inventory management method as claimed in claim 4, characterized in that: The statistical cycle for managing commodity sales orders is one year. Combined with the replenishment cycle, the sales volume in the corresponding time period in the future is predicted based on the sales volume of the same product in the same time period of the previous year.

6. A commodity purchase, sales and inventory management method as claimed in claim 4, characterized in that: Combine product packaging size information with sales forecasts and replenishment cycles to calculate the number of shelves required for a certain product and adjust shelf allocation in real time.

7. A commodity purchase, sales and inventory management method as claimed in claim 4, characterized in that: Count the sales of different sizes, colors, and flavors of goods within a certain period of time, sort them, and calculate the ranking of the most popular products.

8. A management device for commodity front-end replenishment cabinets using a commodity purchase, sales and inventory management method as described in claims 1-7, characterized in that: The management device includes: Product information unit, used to mark the product name, product model, product location and product packaging size of the product; The commodity identification and collection unit is used to identify and collect various information on the commodity information unit and transmit it to the front-end system unit; The front-end system unit obtains the information of the goods entering and exiting the cabinet through the commodity identification and collection unit, performs calculations and processing, counts the inventory quantity of the goods, and transmits the commodity name, commodity model, commodity location and inventory quantity to the front-end display unit; The front-end display unit is used to display the product name, product model, product location, inventory quantity and product sales ranking of the products in the front replenishment cabinet; The commodity management system unit analyzes and processes commodity sales data according to commodity sales orders, and makes sales forecasts for various commodities in different time periods; The back-end display unit is used to display the calculation data processed by the commodity management system unit.

9. A front-end cabinet, characterized in that: The front supplement cabinet comprises: A processor and a memory, wherein the memory is communicatively connected to the processor; The memory is used to store at least one executable instruction executed by the processor, and the processor is used to execute the executable instruction to implement the commodity purchase, sales and inventory management method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the commodity purchase, sales and inventory management method according to any one of claims 1 to 7 is implemented.

Images