CN108550008A - A kind of auxiliary based on mobile phone app matches goods and inventory management system - Google Patents

Abstract

A kind of auxiliary based on mobile phone app matches goods and inventory management system, including goods orders management system, stock information database, auxiliary distribution management system, commodity inventory control system and tele-control system.Auxiliary distribution management system automatically generates most short picking path according to the distribution of the cargo in order information and warehouse, while positioning cargo inventory locations, prevents that mistake from picking and leakage is picked by scanned item bar code.Stock control, which timely updates, feeds back the inventory information and sales data in warehouse.By bluetooth connection printer and packing machine, express delivery face singles print, packing machine operation and control are carried out.The merchandise news of statistics can be fed back to goods orders management system.The present invention carries out on mobile phone auxiliary with goods with storehouse management entire set, and user only needs use mobile phone as support, and app auxiliary avoids cumbersome error free with goods with cargo interests formula and realization of tradition with goods, while stock control is managed warehouse.The present invention is suitable for middle-size and small-size on-line shop user.

Description

A mobile app-based auxiliary distribution and inventory management system

technical field

The invention relates to the technical field of distribution and warehouse management in express logistics, in particular to an auxiliary distribution and inventory management system based on a mobile phone app.

Background technique

After more than 30 years of development, my country's express delivery industry has grown into an emerging strategic service industry with the fastest growth rate and the greatest development potential. In 2016, China's express delivery business volume was 31.28 billion pieces. In 2017, China's express delivery business volume was 40.1 billion pieces, and the growth rate was high and stable. At present, there are 6 million online store merchants nationwide. The rapid development of e-commerce and online shopping brings rapid development opportunities to warehouse management and logistics distribution, but also brings unprecedented challenges and problems.

The traditional distribution method for small and medium-sized online store merchants is: manually export the order information from the computer and print out the paper distribution list, push the distribution trolley or other loading tools into the warehouse, pick the goods one by one according to the distribution list, and complete the picking Take it back to the packaging area, and the express delivery list will be printed by the computer. Before packaging and pasting, it is necessary to check whether the item and the express delivery list match again. This traditional distribution method is complicated and purposeless. Long-term repeated checking manually will inevitably lead to fatigue and mistakes, and the efficiency of distribution is low. This traditional distribution method can no longer meet the needs of today's express logistics.

At present, there is basically no warehouse management system for small and medium-sized online store merchants based on mobile apps. The traditional storage management method of small and medium online stores is to rely on manual and paper records. This traditional method is inconvenient to operate, inefficient, irregular, and lacks the scientific nature of big data analysis.

With the development of society, mobile phones have completely integrated into our daily life, and the functions of mobile phones are becoming more and more abundant, bringing us a convenient life. There is an urgent need to develop a low-cost, easy-to-operate application for small and medium-sized online stores, which also has the functions of warehouse management and auxiliary distribution, and all functions are integrated on the mobile phone. It is used to optimize the distribution process of online store merchants, prevent distribution errors, reduce manual labor intensity, and improve distribution and management efficiency; at the same time, it provides a scientific and reasonable basis for warehouse management, allowing small and medium-sized online store merchants to manage warehouses and distribute goods. The goods are more standardized and faster.

Contents of the invention

In view of the above existing problems, the present invention provides a mobile app-based auxiliary distribution and inventory management system for small and medium-sized online stores.

The present invention is achieved through the following technical solutions.

A mobile app-based auxiliary distribution and inventory management system according to the present invention includes a commodity order management system, an inventory commodity information database, an auxiliary distribution management system, a commodity inventory management system, and a remote control system. The commodity inventory management system is connected to the commodity order management system through the network, and provides real-time commodity data after inventory management operations; the inventory commodity information database provides commodity inventory information for the commodity order management system, auxiliary distribution management system and commodity inventory management system . The inventory commodity information in the inventory commodity information database is updated through the commodity inventory management system; the commodity order management system sends the received order information to the auxiliary distribution management system through the network. The auxiliary distribution system sends the order information to be printed to the remote control system.

The commodity order management system is a computer-based e-commerce transaction platform that can conduct commodity transactions.

The inventory commodity information database includes all commodity information stored in the warehouse. Such as product name, model, serial number, color, storage time, purchase quantity, warehouse storage shelf address, etc.

The auxiliary distribution management system includes three parts: shelf positioning of inventory goods, automatic generation of the shortest picking path, and error prevention for picking by scanning codes. Inventory product shelf positioning According to the order information, retrieve the inventory product database, locate and display the detailed inventory location of the current product to be picked. Automatically generate the shortest picking path Generate the shortest picking path and order based on the warehouse goods distribution and order information. Scan code picking and error prevention Use the mobile phone camera to scan the barcode of the product to get the product information and compare it with the order information. If the information matches correctly, it will prompt that the picking is successful, and if the information does not match, the vibration will prompt the picking error.

The auxiliary distribution management system retrieves the inventory commodity information database according to the order information and the distribution of goods in the warehouse, and automatically generates the shortest picking sequence and path; locates and displays the detailed inventory location of the current commodity to be picked, scans the barcode of the commodity with the mobile phone camera, and obtains Commodity information, the system automatically matches the commodity information and order information to check whether the picking is correct; if the picking is wrong, the mobile phone vibrates to remind you to take the wrong goods and pick the goods again; if the picking is correct, the system will automatically jump to the next item in the order Picking interface; only after completing all the picking of the goods in this order can you enter the next order to prevent wrong picking and missing picking.

The commodity inventory management system includes inventory management operations of inquiry, deletion, editing, addition, statistics, commodity storage and commodity delivery. The inventory management operation query can query all the information of any commodity in the warehouse, such as commodity name, model, serial number, color, time of purchase and storage, purchase quantity, warehouse storage shelf address, etc. Its inventory management operation delete can directly delete the information of some products that are no longer sold. Its inventory management operation editor can edit commodity information and correct commodity information in time. Its inventory management operation is added, which can directly add the information of a certain type of new product. Its inventory management operation statistics can obtain the sales situation, income situation, purchase information records of various commodities within a period of time, and the minimum inventory quantity of a certain type of commodity, providing a basis for purchase. According to the minimum inventory quantity of the set commodities, timely feedback the commodities that need to be purchased, maintain the inventory within a certain quantity, and ensure the stability of the supply.

The remote control system can be connected with printers and packaging machines via bluetooth. Capable of printing express delivery sheets and controlling operations related to packaging machines.

Auxiliary distribution management system, its distribution process is that the commodity order management system receives the order, and the user generates the distribution demand according to the specified number of orders or the orders generated within a certain period of time. The user connects the mobile app to the commodity order management system through the network, and sends all the original data of the order to the mobile app. The mobile app searches the inventory commodity information database according to the order information and the distribution of warehouse shelves, and automatically generates the shortest picking path and Picking steps. The mobile app enters the distribution mode. Workers carry mobile phones and push the picking trolley into the warehouse to pick goods. The app automatically locates the inventory location of the first product, the worker finds the product and picks it up, scans the bar code of the product, and the system automatically matches and checks the order information and product information. If there is a mistake in the picking, the mobile phone will vibrate to remind you that the picking is wrong and you need to pick the goods again; only when you pick the goods correctly can you pick the next item in this order. The picking of an order is completed to enter the picking of the next order until all orders are completed. The mobile phone and the printer are connected via Bluetooth, and the express delivery form information to be printed is sent to the printer for printing. When pasting express delivery sheets, paste the express delivery sheets printed by the printer one by one according to the serial number of the storage space of the trolley.

The picking trolley is a trolley with multiple storage spaces, and these storage spaces are all marked with serial numbers, and one storage space corresponds to one order. The picked goods are stored in order, which is consistent with the order of the printed express delivery slip.

The express delivery bill information can be automatically generated from the original order information sent by the commodity order management system, and the parameters of the sender and the recipient can be set separately; the parameters of the sender include: delivery store name, name, Contact information, zip code, address, remarks, etc.; the recipient parameters include: name, buyer id, contact information, zip code, address, list of purchased items, amount, number of pieces, remarks, etc. Parameters can be modified when there are special requirements.

The commodity inventory management system described above needs to obtain administrator authority when performing inventory management operations on the warehouse, so as to prevent warehouse data from being leaked and tampered with, and ensure database information security.

The above-mentioned various information query results and system statistics results can be exported and sent to the printer to print out.

Beneficial effects of the present invention: the present invention is aimed at small and medium-sized online store merchants, and integrates auxiliary distribution and storage management on the mobile phone app, making distribution and storage management more convenient and concise. It does not require other hardware platforms for support, saving costs for small and medium-sized online store merchants in distribution and warehouse management. Optimize the paper list distribution method commonly used by online store merchants to prevent picking errors, reduce manual labor intensity, and improve the efficiency of distribution and warehouse management. At the same time, it provides a scientific and reasonable basis for warehouse management, making the warehouse management and distribution of small and medium-sized online stores more standardized and faster.

Description of drawings

Fig. 1 is a system structure frame diagram of the present invention.

Fig. 2 is a functional diagram of inventory management of the present invention.

Fig. 3 is a function diagram of auxiliary distribution of the present invention.

Fig. 4 is the flow chart of auxiliary distribution of the present invention.

Fig. 5 is a structural diagram of the remote control of the present invention.

Detailed ways

In order to enable readers to better understand the present invention, the present invention will be described in more detail below in conjunction with the accompanying drawings. It should be understood that the given examples are only used to explain the present invention, and the specific application of the present invention is not limited thereto.

In a specific embodiment, the present invention provides a mobile app-based auxiliary distribution and warehouse management system, as shown in the structural frame diagram of Figure 1, which includes a commodity order management system, an inventory commodity information database, an auxiliary distribution There are five parts: goods management system, commodity inventory management system and remote control system. The inventory commodity information database can feed back the information of inventory commodities to the commodity order management system, commodity inventory management system and auxiliary distribution management system, so that merchants can keep abreast of all the information of inventory commodities when selling, and provide a data basis for inventory management and distribution .

The inventory product information database includes all product information stored in the warehouse, such as product name, model, serial number, color, storage time, purchase quantity, warehouse storage shelf address, etc.

As shown in FIG. 2 , the commodity inventory management system is capable of querying, deleting, editing, adding, counting, commodity storage and commodity inventory management operations. The inventory management operation query of the commodity inventory management system is characterized in that all information of any commodity in the warehouse can be queried, such as commodity name, model, serial number, color, time of purchase and storage, purchase quantity, warehouse storage shelf address, etc. . Its inventory management operation delete can directly delete some products that are no longer sold. Its inventory management operation editor can edit commodity information and correct commodity information in time. Its inventory management operation is added, which can directly add the information of a certain type of new product. Its inventory management operation statistics can count for a period of time, the sales situation, income situation, purchase information records of various commodities, and the minimum inventory quantity of a certain type of commodity, and timely feedback the commodities that need to be purchased according to the set minimum commodity inventory quantity, and maintain inventory commodities Within a certain quantity, the stability of supply is guaranteed. At the same time, according to the best-selling situation of various commodities, scientifically purchase.

The commodity inventory management system described above needs to obtain administrator authority when performing inventory management operations on the warehouse, so as to prevent warehouse data from being leaked and tampered with, and ensure database information security.

As shown in FIG. 3 , the auxiliary distribution management system supports the positioning of commodity shelves, and is used to locate the commodities that need to be searched for in the current order, so that accurate positioning can avoid blind searching. The shortest picking path and picking steps can be generated based on order information and warehouse layout. At the same time, scan the code to prevent mistakes, use the camera of the mobile phone to scan the barcode of the product, get the product information, and match it with the order information to remind the user whether the picking is correct. Only when the product is successfully picked can the next product be picked. Complete this order to enter the next order to prevent wrong and missed picking.

As shown in Figure 4, the app assists distribution. The distribution process is that the commodity order management system receives a certain number of orders, and the user generates a distribution demand for a certain number of orders according to the specific order quantity or fixed time requirements. The user connects the mobile app to the product order management system through the network, and sends all the original data of the order to the mobile app. The mobile app automatically generates the shortest picking path and picking steps according to the order information and the layout of the warehouse shelves. The mobile app enters the distribution mode. Workers carry mobile phones and push the picking trolley into the warehouse to pick goods. The app automatically locates the inventory location of the first product, the worker finds the product and picks it up, scans the bar code of the product, and the system automatically matches and checks the order information and product information. If there is a mistake in the picking, the mobile phone will vibrate to remind the wrong picking and pick the goods again. Only by picking correctly can the next item of this order be picked. The picking of an order is completed before the picking of the next order can be carried out until all orders are completed. The mobile phone and the printer are connected via Bluetooth, and the information of the courier form that needs to be printed is sent to the printer for printing. When pasting express delivery sheets, paste the express delivery sheets printed by the printer one by one according to the serial number of the storage space of the trolley, without repeated checks.

The picking trolley is a trolley with multiple storage spaces, and these storage spaces are all marked with serial numbers, and one storage space corresponds to one order. The picked goods are stored in order, which is consistent with the order of the printed express delivery slip.

The express delivery bill information can be automatically generated from the original order information sent by the commodity order management system, and the parameters of the sender and the recipient can be set separately. The parameters of the sender include: delivery store name, name, Contact information, zip code, address, remarks, etc.; the recipient parameters include: name, buyer id, contact information, zip code, address, list of purchased items, amount, number of pieces, remarks, etc. Parameters can be modified when there are special requirements.

The remote control system can be connected with printers and packaging machines through Bluetooth, and can complete express delivery bill printing and packaging machine-related operation control.

The results of various information inquiries and system statistics can be sent to the printer to be printed out.

The above specific implementation is only one of the implementations of the present invention, and should not be construed as limiting the patent scope of the present invention. Those skilled in the art can make several modifications, deformations and improvements without departing from the concept of the present invention. The modifications, equivalent replacements and improvements made within the spirit and principles of the present invention should all be included in the protection scope of the present invention within.

Claims (5)

1. An auxiliary distribution and inventory management system based on a mobile app, characterized in that it includes a commodity order management system, an inventory commodity information database, an auxiliary distribution management system, a commodity inventory management system and a remote control system; the commodity inventory management system passes The network is connected to the commodity order management system and provides real-time commodity data after inventory management operations; the inventory commodity information database provides commodity inventory information for the commodity order management system, auxiliary distribution management system and commodity inventory management system, through commodity inventory management The system updates the inventory commodity information in the inventory commodity information database; the commodity order management system sends the received order information to the auxiliary distribution management system through the network; the auxiliary distribution system sends the order information to be printed to the remote control system; The commodity order management system is a computer-based e-commerce trading platform for commodity transactions; The inventory product information database includes all product information stored in the warehouse: product name, model, serial number, color, storage time, purchase quantity, warehouse storage shelf address; The auxiliary distribution management system includes three parts: inventory commodity shelf positioning, automatic generation of the shortest picking path, and scanning code picking to prevent errors; inventory commodity shelf positioning searches the inventory commodity database according to the order information, locates and displays the current demand The detailed inventory location of the picked goods, and the shortest picking path is automatically generated. According to the distribution of goods in the warehouse and the order information, the shortest picking path and order are generated; scanning the code to pick and prevent errors Use the mobile phone camera to scan the barcode of the product to obtain the product information and compare it with the order information In contrast, if the information matches correctly, it will prompt that the picking is successful, and if the information matches incorrectly, it will vibrate to prompt that the picking is wrong; The commodity inventory management system includes inventory management operations such as inquiry, deletion, editing, addition, statistics, commodity storage and commodity exit; query all information of any commodity in the warehouse: commodity name, model, serial number, color, Purchase and storage time, purchase quantity, warehouse storage shelf address; delete information of some products that are no longer on sale; edit product information and correct product information in time; directly add information of a new type of product; count various products within a period of time The sales situation, income situation, purchase information records and the minimum inventory quantity of a certain type of goods provide a basis for purchase; according to the set minimum inventory quantity of goods, timely feedback of the goods that need to be purchased is maintained within a certain quantity of goods in stock to ensure supply stability; The remote control system is connected with the printer and the packaging machine via bluetooth to print the express delivery list and control the operation of the packaging machine. 2. A kind of auxiliary distribution and inventory management system based on mobile phone app according to claim 1, characterized in that the commodity inventory management system needs to obtain administrator authority when performing inventory management operations on warehouses, preventing warehouses from Data leakage and tampering ensure the security of database information. 3. A mobile app-based auxiliary distribution and inventory management system according to claim 1, characterized in that the distribution process of the auxiliary distribution management system is that the commodity order management system receives an order, and the user according to the regulations A large number of orders or orders generated within a certain period of time generate distribution requirements; the user connects the mobile app to the product order management system through the network, and sends all the original data of the order to the mobile app. The mobile app is based on the order information and the distribution of warehouse shelves The situation, search the inventory product information database, automatically generate the shortest picking path and picking steps; the mobile app enters the distribution mode; workers carry mobile phones, push the picking trolley into the warehouse to pick goods; the app automatically locates the inventory location of the first order, The worker finds the product and picks it up, scans the barcode of the product, and the system automatically matches and checks the order information and product information; if there is a mistake in the picking, the mobile phone will vibrate to remind the wrong picking and re-picking; only when the correct picking is made can the order be placed next Picking of items; completing the picking of one order can enter the picking of the next order until all orders are completed; the mobile phone and the printer are connected through Bluetooth, and the information of the express delivery note that needs to be printed is sent to the printer for printing; when posting the express delivery note, According to the serial number of the storage space of the trolley, paste the express delivery sheets printed by the printer one by one. 4. A kind of auxiliary distribution and inventory management system based on mobile phone app according to claim 3, characterized in that said picking trolley is a trolley with multiple storage spaces, and the storage spaces are all marked with serial numbers, and one storage space The space corresponds to an order; picks are stored in order, which is consistent with the order of the printed express delivery slip. 5. A mobile phone app-based auxiliary distribution and inventory management system according to claim 3, characterized in that the express delivery order information is automatically generated from the original order information sent by the commodity order management system, and can be processed separately Parameter settings for sender and recipient; sender parameters include: shipping store name, name, contact information, zip code, address, remarks; recipient parameters include: name, buyer id, contact information, zip code, Address, list of purchased items, amount, number of pieces, remarks; parameters can be modified when there are special requirements.