Book inventory management method and device, electronic equipment and medium

Abstract

The invention provides a book inventory management method and apparatus, an electronic device and a medium. The method comprises the steps of obtaining to-be-delivered sales commodities from a pre-established commodity file; if the sold commodity is a packaged commodity, generating at least one package specification of the sold commodity based on a preset warehouse-out strategy, and determining a package number corresponding to each package specification of the sold commodity; and generating the total book number of the sales commodities based on the book specification and the book number of the sales commodities, and generating a sales delivery order based on the book name, the book specification, the book number and the total book number of the sales commodities. The convenience of book inventory management is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of library management, and in particular to a method, device, electronic device and medium for managing library inventory. Background Art

[0002] With the diversification of all walks of life, the packaging of its products is also undergoing great changes. Various methods such as bagging, boxing, plastic sealing, bundling, etc. emerge in an endless stream, and even for boxing alone, there will be boxes of various specifications. When books are bound into finished products at the printing factory and enter the packing link, the number of books in each package packed in different batches will be affected due to the different specifications of the wrapping paper (brown kraft paper) prepared by the publishing house or printing factory at different times. For example, for the same book, there were 20 copies in one package last year, while there are 30 copies in one package this year.

[0003] Distributors, wholesalers and other primary or even secondary sellers are different from bookstore sales or online store sales where books are sold individually. Their packages are not unpacked and are sold to lower-level units as whole packages. Similarly, for warehouse management, the total number of incoming books of a certain book can be obtained by counting the number of packages and multiplying by the number of copies in each package when purchasing and storing. The same applies to sales and inventory counting.

[0004] In traditional library management software systems, calculations are usually carried out based on the number of copies of books as the unit. This is no problem for sales at the end of the supply chain, but for the intermediate links in the supply chain, although the number of packages can be manually converted into the number of copies using a calculator or conveniently converted into the number of copies through system tools, it is extremely inconvenient for inventory management. Summary of the Invention

[0005] In view of this, the purpose of the present invention is to provide a method, device, electronic device and medium for managing library inventory to improve the convenience of library inventory management.

[0006] To achieve the above purpose, the technical solution adopted by the present invention is as follows:

[0007] In the first aspect, the present invention provides a method for managing library inventory, including: obtaining the sales products to be shipped out from a pre-established product file; if the sales products are packaged products, generating at least one package and copy specification for the sales products based on a preset shipping strategy, and determining the number of packages corresponding to each package and copy specification of the sales products; where the shipping strategy includes a shipping strategy based on package volume and / or a shipping strategy based on the number of packages; the shipping strategy based on package volume is that small packages are shipped out first or large packages are shipped out first; the shipping strategy based on the number of packages is that packages with fewer numbers are shipped out first or packages with more numbers are shipped out first; generating the total number of copies of the sales products based on the package and copy specification and the number of packages of the sales products, and generating a sales shipping list based on the book name, package and copy specification, the number of packages and the total number of copies of the sales products.

[0008] Optionally, after obtaining the salable products to be shipped out from the pre-established product files, it further includes: determining the total intended number of copies of the salable products; if the salable products are packaged products, generating at least one package specification for the salable products based on a preset shipping strategy; determining the number of packages corresponding to each package specification of the salable products based on a preset rounding package strategy, and generating the total number of copies of the salable products based on the package specifications and the number of packages of the salable products; wherein, the rounding package strategy includes one of the following: can exceed the total intended number of copies, can be less than the total intended number of copies, and prompt if it cannot be rounded into a package; generating a sales shipping order based on the book name, package specifications, number of packages, and total number of copies of the salable products.

[0009] Optionally, after obtaining the salable products to be shipped out from the pre-established product files, it further includes: if the salable products are loose copies, determining the total number of copies of the salable products, and generating a sales shipping order based on the book name and the total number of copies of the salable products.

[0010] Optionally, the book inventory management method provided by the present invention further includes: obtaining the product information of the products to be warehoused; wherein, the product information includes multiple ones of the following: book name, author, publisher, package specifications, number of packages, total number of copies; for the packaged products to be warehoused, selecting the corresponding book name and package specifications from the product files based on the product information of the products to be warehoused, determining the number of packages corresponding to the package specifications, generating the total number of copies based on the package specifications and the number of packages, and updating the inventory information of the products to be warehoused; for the loose copies of the products to be warehoused, updating the inventory information of the products to be warehoused based on the total number of copies of the products to be warehoused.

[0011] Optionally, after obtaining the product information of the products to be warehoused, it further includes: determining whether there is a product file for the products to be warehoused based on the product information; wherein, the product file at least includes: book name and package specifications; if there is, updating the product file according to the package specifications of the products to be warehoused; if not, establishing a product file for the products to be warehoused.

[0012] Optionally, the book inventory management method provided by the present invention further includes: obtaining the package specifications, number of packages, and target package specifications of the products to be unpacked; generating the target number of packages of the products to be unpacked based on the package specifications, number of packages, and target package specifications of the products to be unpacked; generating a repackaging order for the products to be unpacked based on the target number of packages and the target package specifications, so that the business personnel can unpack and repackage the products to be unpacked based on the repackaging order.

[0013] Optionally, the book inventory management method provided by the present invention further includes: obtaining the total number of copies and the target package specifications of the products to be packaged; generating the target number of packages of the products to be packaged based on the total number of copies and the target package specifications of the products to be packaged; generating a repackaging order for the products to be packaged based on the target number of packages and the target package specifications, so that the business personnel can package the products to be packaged based on the repackaging order.

[0014] In a second aspect, the present invention provides a book inventory management device, comprising: a commodity acquisition module for acquiring sales commodities to be shipped out from a pre-established commodity file; a package specification and package quantity determination module for, if the sales commodity is a packaged commodity, generating at least one package specification of the sales commodity based on a preset shipping-out strategy and determining the package quantity corresponding to each package specification of the sales commodity; wherein the shipping-out strategy includes a shipping-out strategy based on package volume and / or a shipping-out strategy based on the number of packages; the shipping-out strategy based on package volume is that small packages are shipped out first or large packages are shipped out first; the shipping-out strategy based on the number of packages is that packages with fewer numbers are shipped out first or packages with more numbers are shipped out first; a sales shipping-out order generation module for generating the total number of copies of the sales commodity based on the package specifications and package quantities of the sales commodity, and generating a sales shipping-out order based on the book name, package specifications, package quantities and total number of copies of the sales commodity.

[0015] In a third aspect, the present invention provides an electronic device, comprising a processor and a memory, the memory storing computer-executable instructions that can be executed by the processor, and the processor executing the computer-executable instructions to implement the steps of the method according to any one of the above first aspects.

[0016] In a fourth aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is run by a processor, it executes the steps of the method according to any one of the above first aspects.

[0017] The present invention brings the following beneficial effects:

[0018] The above book inventory management method, device, electronic device and medium provided by the present invention include: acquiring sales commodities to be shipped out from a pre-established commodity file; if the sales commodity is a packaged commodity, generating at least one package specification of the sales commodity based on a preset shipping-out strategy and determining the package quantity corresponding to each package specification of the sales commodity; wherein the shipping-out strategy includes a shipping-out strategy based on package volume and / or a shipping-out strategy based on the number of packages; the shipping-out strategy based on package volume is that small packages are shipped out first or large packages are shipped out first; the shipping-out strategy based on the number of packages is that packages with fewer numbers are shipped out first or packages with more numbers are shipped out first; generating the total number of copies of the sales commodity based on the package specifications and package quantities of the sales commodity, and generating a sales shipping-out order based on the book name, package specifications, package quantities and total number of copies of the sales commodity. In the above method, in the sales order-making link, the preset shipping-out strategy determines the package specifications of the sales commodity, and then determines the package quantity of each package specification. Through the package quantity, the specific total number of copies is obtained, and then a sales shipping-out order is generated, so as to facilitate quick query of the package quantity without unpacking, and provide great convenience for links such as sales order-making, improving the convenience of book inventory management.

[0019] Other features and advantages of the present invention will be set forth in the following description, and in part will be obvious from the description, or may be learned by practice of the present invention. The objectives and other advantages of the present invention are realized and attained by the structure particularly pointed out in the specification, claims as well as the drawings.

[0020] In order to make the above objectives, features and advantages of the present invention more obvious and understandable, the following specifically enumerates the preferred embodiments and, in conjunction with the accompanying drawings, the detailed description is as follows. Brief Description of the Drawings

[0021] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following will briefly introduce the drawings required for the description of the specific embodiments or the prior art. Obviously, the drawings in the following description are some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.

[0022] Figure 1 It is a flowchart of a book inventory management method provided by an embodiment of the present invention;

[0023] Figure 2 It is a schematic flowchart of another book inventory management provided by an embodiment of the present invention;

[0024] Figure 3 It is a schematic structural diagram of a book inventory management device provided by an embodiment of the present invention;

[0025] Figure 4 It is a schematic structural diagram of an electronic device provided by an embodiment of the present invention. Detailed Embodiments

[0026] In order to make the objectives, technical solutions and advantages of the embodiments of the present invention clearer, the following will clearly and completely describe the technical solutions of the present invention in conjunction with the drawings. Obviously, the described embodiments are some, but not all, of the embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts fall within the scope of protection of the present invention.

[0027] Currently, the traditional book management software system is extremely inconvenient for inventory management, mainly involving the following aspects:

[0028] (1) With the multiple purchases and warehousing of book commodities, the purchasing clerks often only notice the total number of copies, the total amount, the damage rate, etc. However, there are various specific packaging specifications that are inconvenient to remember, and the purchasing clerks are rarely in the warehouse, so they have no idea about how many medium-packet specifications of book commodities there are.

[0029] (2) Problem of inaccurate determination of sales quantity by salespersons: In the non-retail industry, lower-level purchases often require whole packages, which are not only convenient for handling and counting, but also easy to store and less likely to be damaged. For books, with multiple packaging specifications, it is difficult to determine the final number of copies sold. For example, if it is planned to sell 100 copies of a certain book product to a customer, and there are packages of 22 copies and 26 copies in the warehouse, whether it is a single packaging specification or a mixed packaging specification, it is impossible to reach exactly 100 copies without unpacking.

[0030] (3) Difficulty in inventory counting of book products in the warehouse: For each packaging specification, the number of packages needs to be counted separately, and then the total number of copies in each package specification is calculated respectively. Finally, the total number of books is obtained by summarization, which is not friendly to the inventory counting work in the warehouse. In addition, when there are multiple package specifications for a certain book, there will be multiple packages of different sizes for the same product in the warehouse. It is difficult for the warehouse keeper to accurately know the number of packages of each specification. Especially when counting during procurement receipt and sales delivery, in the case of a mixture of multiple packages, it is impossible to conveniently know the quantity of inventory products.

[0031] (4) Warehouse stockers do not know which packaging specification the salesperson wants to sell. Warehouse stockers can only obtain the total quantity of a certain book product to be stocked. In the case of multiple packaging specifications, the warehouse stockers can only stock by feeling on their own to finally make up the total number of copies that meet the requirements.

[0032] (5) Difficulty in receiving and counting for the purchaser: When a certain product is shipped in a mixture of multiple packages, it is inconvenient for the warehouse personnel of the purchaser to count the goods.

[0033] Based on this, an inventory management method, device, electronic device and medium for books provided by the embodiments of the present invention can improve the convenience of book inventory management.

[0034] For the convenience of understanding this embodiment, first, a book inventory management method disclosed in the embodiments of the present invention will be introduced in detail. This method can be executed by an electronic device, such as a smart phone, a computer, a tablet computer, etc. Refer to Figure 1 The flowchart of a book inventory management method shown, which shows that the method mainly includes the following steps S101 to S103:

[0035] Step S101: Obtain the sales products to be shipped out from the pre-established product file.

[0036] In one implementation, a product file of the product is established in advance. The product file includes at least information such as book name, package specification, inventory, etc.; when there are multiple package specifications for the same product, the package specifications in the product file are improved. Specifically, through the t_goods_sku table, multiple package specifications are supported for one product. Based on this, when formulating a sales delivery order for product sales, the sales products to be shipped out can be obtained from the product file.

[0037] Step S102: If the sold goods are packaged goods, at least one package specification of the sold goods is generated based on a preset outbound strategy, and the package quantity corresponding to each package specification of the sold goods is determined.

[0038] In one implementation, if the sold goods are packaged goods, at least one package specification of the sold goods can be automatically generated according to the preset outbound strategy. The inventory information of each package specification can be displayed in the system, and the business personnel can select the package quantity corresponding to each package specification. Specifically, the outbound strategy includes an outbound strategy based on package volume and / or an outbound strategy based on the number of packages; the outbound strategy based on package volume is that the small packages are shipped first or the large packages are shipped first; the outbound strategy based on the number of packages is that the packages with fewer numbers are shipped first or the packages with more numbers are shipped first. The business personnel can select the outbound strategy according to the actual inventory and sales demand of the goods. For example: Suppose there are 8,120 copies of a certain commodity in stock, among which, there are 100 packages of 80 copies per package and 2 packages of 60 copies per package. Since the difference in packaging sizes between the packages of 18 copies and 60 copies is not significant, in order to avoid taking the wrong ones, it is necessary to try to ship out the 60-copy package specification first and only leave the 80-copy package. Then the outbound strategy can be selected as shipping the small packages first. When generating the package specifications of the sold goods, the package specifications of 60 copies per package are preferably generated first.

[0039] In addition, when the automatically filled package specifications are inconsistent with the physical package specifications, the business personnel can manually modify them.

[0040] Step S103: Generate the total number of copies of the sold goods based on the package specifications and package quantities of the sold goods, and generate a sales outbound order based on the book name, package specifications, package quantities, and total number of copies of the sold goods.

[0041] In one implementation, the system can automatically calculate the total number of copies of the sold goods according to the package specifications and package quantities of the sold goods, and then automatically generate a sales outbound order based on information such as the book name, package specifications, package quantities, and total number of copies of the sold goods.

[0042] The above book inventory management method provided by the embodiments of the present invention can, in the sales order-making link, determine the package specifications of the sold goods according to the preset outbound strategy, and then determine the package quantity of each package specification. Through the package quantity, the specific total number of copies can be obtained, and then a sales outbound order is generated, which is convenient for quickly querying the package quantity without unpacking and provides great convenience for links such as sales order-making, improving the convenience of book inventory management.

[0043] In one embodiment, for the total number of volumes of goods purchased by a customer, if there is no desire for loose volumes, the total number of volumes needs to be fine-tuned to ensure that all purchased goods are packaged. Based on this, after obtaining the sales goods to be shipped out from the pre-established goods file in the above method, it further includes: determining the intended total number of volumes of the sales goods; if the sales goods are packaged goods, generating at least one package volume specification for the sales goods based on a preset shipping strategy; determining the number of packages corresponding to each package volume specification of the sales goods based on a preset rounding-up package strategy, and generating the total number of volumes of the sales goods based on the package volume specification and the number of packages of the sales goods; wherein, the rounding-up package strategy includes one of the following: can exceed the intended total number of volumes, can be less than the intended total number of volumes, and if rounding up is not possible, prompt; generating a sales shipping order based on the book name, package volume specification, number of packages, and total number of volumes of the sales goods.

[0044] In specific implementation, first obtain the commodity name of the sales goods to be shipped out and the customer's intended total number of volumes; then automatically generate the package volume specification based on a preset shipping strategy; next, automatically generate the number of packages for each package volume specification according to the preset rounding-up package strategy, and calculate the actual total number of volumes of the sales goods; if the difference between the actual total number of volumes and the intended total number of volumes is within the range acceptable to the customer, generate a sales shipping order based on the book name, package volume specification, number of packages, and total number of volumes of the sales goods.

[0045] In one embodiment, if the sales goods are loose volumes, the total number of volumes of the sales goods can be directly determined, and then a sales shipping order is generated based on the book name and total number of volumes of the sales goods.

[0046] In one embodiment, when a purchaser purchases goods from a supplier for warehousing, first obtain the goods information of the goods to be warehoused; wherein, the goods information includes multiple of the following: book name, author, publisher, package volume specification, number of packages, total number of volumes.

[0047] For the packaged goods to be warehoused, select the corresponding book name and package volume specification from the goods file based on the goods information of the goods to be warehoused, determine the number of packages corresponding to the package volume specification, generate the total number of volumes based on the package volume specification and the number of packages, and update the inventory information of the goods to be warehoused.

[0048] In specific implementation, first determine whether there is a goods file for the goods to be warehoused based on the goods information; if there is, update the goods file according to the package volume specification of the goods to be warehoused; if not, establish a goods file for the goods to be warehoused.

[0049] Specifically, information such as the book name, author, and publisher of the goods to be warehoused can be compared with the information in the product file to determine whether there is a product file for the goods to be warehoused; if so, directly obtain the product file of the goods to be warehoused, and update the product file according to the package rules of the actually arrived goods to be warehoused; if not, establish a product file for the goods to be warehoused.

[0050] Based on this, for the goods to be warehoused, select the corresponding book name and package rules from the product file, determine the number of packages corresponding to the package specifications, the system can automatically calculate the total number of volumes according to the package specifications and the number of packages, and update the inventory information of the goods to be warehoused, such as: package specifications, number of packages, total number of volumes, total cost, etc.

[0051] For unpackaged goods to be warehoused, update the inventory information of the goods to be warehoused based on the total number of volumes of the goods to be warehoused. In specific implementation, for unpackaged goods to be warehoused, the inventory information can be directly updated according to the total number of volumes.

[0052] In one implementation manner, for the convenience of inventory management, in the embodiments of the present invention, the package specifications of existing products can also be changed according to actual needs, that is, new package specification products are obtained by unpacking and repackaging. Specifically, the above method further includes: first, obtaining the package specifications, number of packages, and target package specifications of the goods to be unpacked; then, based on the package specifications, number of packages, and target package specifications of the goods to be unpacked, generating the target number of packages of the goods to be unpacked; finally, generating a repackaging form for the goods to be unpacked based on the target number of packages and the target package specifications, so that the business personnel can unpack and repackage the goods to be unpacked based on the repackaging form.

[0053] In specific implementation, first select the package specifications, number of packages, and target package specifications (i.e., the new package specifications) of the goods to be unpacked; then the system can calculate the total number of volumes according to the package specifications and the number of packages, and calculate the target number of packages of the goods to be unpacked (i.e., the number of packages corresponding to the new package specifications) according to the total number of volumes and the target package specifications; finally, generate a repackaging form for the goods to be unpacked based on the target number of packages and the target package specifications, and the business personnel can unpack the goods to be unpacked according to the repackaging form and then repackage them according to the target package specifications. For example: to unpack the goods in a package of 52 volumes into a package of 40 volumes, select 100 packages of goods in a package of 52 volumes, then the total number of volumes is 5200 volumes, and unpacking into a package of 40 volumes can obtain 130 packages.

[0054] Furthermore, when repackaging, the above method further includes: first obtaining the total number of volumes of the goods to be repackaged and the target package specifications; then, based on the total number of volumes of the goods to be repackaged and the target package specifications, generating the target number of packages of the goods to be repackaged; finally, generating a repackaging form for the goods to be repackaged based on the target number of packages and the target package specifications, so that the business personnel can package the goods to be repackaged based on the repackaging form.

[0055] In specific implementation, first, select the total number of volumes of the goods to be repackaged and the target package volume specification; then the system can automatically calculate the target number of packages based on the total number of volumes of the goods to be repackaged and the target package volume specification; finally, generate a repackaging form for the goods to be repackaged according to the target number of packages and the target package volume specification, and the business personnel can package the goods to be repackaged based on the repackaging form.

[0056] The embodiment of the present invention also provides a generation method for the outbound strategy, including:

[0057] (1) Generation method for the outbound strategy based on package volume

[0058] First, pre-maintain the basic data such as the gross weight and volume of the goods, and use the sum of the volumes of all the goods in the order as the basis for generating the package volume specification. For example: the order contains 3 goods, and the volumes are 0.5m 3 , 0.3m 3 , 0.4m 3 , and the total volume is 1.2m 3 .

[0059] Then, according to the preset package material database (including the models and corresponding volumes of cartons, plastic bags, etc.), select the smallest package material that can accommodate the total volume by the principle of minimum space waste. If there are two types of cartons with volumes of 1.0m 3 and 1.5m 3 in the package material library, select the 1.5m 3 model. When the total volume of the goods exceeds the maximum volume of the package material, execute the unpacking algorithm: sort the goods in descending order of volume, and give priority to loading the large-volume goods; fill the remaining space with medium- and small-volume goods to generate multiple package volume specifications and mark the primary and secondary package relationships.

[0060] (2) Generation method for the outbound strategy based on the number of packages

[0061] First, preset the maximum number of packages per unit for each commodity category (for example, the first package volume specification of Commodity 1 is 40 volumes / package, and the second package volume specification is 50 volumes / package), and the system automatically splits the order. For example: the order contains 140 volumes of goods, which are split into 1 first package volume specification + 2 second package volume specifications (40 volumes + 100 volumes).

[0062] Then, optimize according to the combination logic. For example: aggregation of the same type: give priority to outbound of the goods with the same specification; associated with alternative materials: when the inventory of the goods with a certain package volume specification is insufficient, trigger the preset alternative rule and use the same commodity with other package volume specifications for substitution.

[0063] (3) Generation method for the composite strategy

[0064] Meet the maximum volume and maximum quantity limits for each package simultaneously, and give priority to enforcing the stricter constraint conditions. For example, the maximum capacity of a certain packaging material is 1m 3 and it can hold a maximum of 8 items; when 7 items are loaded and it has reached 0.9m 3 even if the quantity limit is not exceeded, the item loading will stop.

[0065] Analyze historical outbound data through machine learning to automatically optimize the package generation rules: generate fixed - specification packages for high - frequency co - sold product combinations; dynamically adjust the matching threshold of packaging material models for seasonal products.

[0066] In the embodiments of the present invention, the package generation rules can also be optimized through machine learning, specifically including: First, use the Apriori algorithm to mine frequent item sets in historical orders, identify high - frequency co - sold product combinations, construct a product co - occurrence relationship graph through the FP - growth algorithm, and dynamically generate SKU clustering groups.

[0067] Then, automatically generate a standardized package template for the TOP 20% high - frequency combinations (average weekly outbound volume > 500 times), preset the package material specifications, packing order, and buffer material configuration, introduce a reinforcement learning mechanism, and dynamically adjust the packing spacing and fixing method of combined products according to the actual transportation damage rate.

[0068] After that, based on the LSTM time - series model, predict the shipment peak of seasonal products (for example, the shipment volume of Christmas gift - like products from November to December accounts for 63% of the whole year), combine weather data (temperature, humidity) and the promotion calendar to correct the threshold for selecting packaging material models; in addition, the package volume matching threshold can be automatically relaxed during peak seasons (for example, allowing a 15% excess of the standard volume) to give priority to ensuring the outbound efficiency; in off - seasons, enable a strict matching mode to increase the space utilization rate to over 92% through a 3D packing algorithm.

[0069] For ease of understanding, the embodiments of the present invention provide another schematic diagram of the process for managing book inventory, as shown in Figure 2 including: the file - creating link, the purchase order - making link, the sales order - making link, the unpacking / grouping link, and the statistics link. The specific implementation methods can be referred to the foregoing embodiments and will not be elaborated here again.

[0070] In the purchase order - making link, first, ensure that there is sufficient information in the database to support different package specifications, including product files: The book information table: contains basic information of books, such as ISBN, book name, author, etc.; The package specification table: records the available package specifications for each book (for example, single - book, 5 - book per pack, 20 - book per box, etc.), as well as the corresponding quantity and price for each specification.

[0071] Then, the user can use the user interface to enter the warehousing information. This interface allows the user to input or select the following: Selection of books (which can be selected by search or browsing the catalog). Selection of package specifications (displaying all available specifications for the user to choose). For each specification, the actual received quantity needs to be entered.

[0072] After that, based on the information provided by the user, the system can perform the following operations:

[0073] Calculate the total warehousing quantity according to the selected specification (for example, if the specification of "5 books per pack" is selected and the quantity entered is 4, then the total is 20 books).

[0074] Update the inventory record to increase the inventory quantity of the corresponding books.

[0075] Record the warehousing transaction, including information such as timestamp, operator, book details, specification, and quantity.

[0076] To ensure data accuracy, the warehousing information can be verified through the following verification mechanisms: Instantly verify whether the input data is reasonable during entry (for example, the quantity cannot be negative); Provide options for the user to confirm that the warehousing information is correct before submission; The system automatically generates a preview to show how this warehousing will affect the existing inventory.

[0077] In addition, in this embodiment, reports can also be generated through relevant reporting tools, enabling users to view historical warehousing records, monitor inventory levels, and analyze cost change trends. The following is a specific warehousing example process:

[0078] Assume that for the warehousing of the book "Journey to the West", there are two package specifications for this book: "single copy" and "5 books per pack". If this warehousing includes 5 packs of "5 books per pack" and 3 single copies, then the system should: Automatically calculate the total number as 5×5 + 3 = 28 books; Update the inventory by adding these 28 books to the current inventory; Record the relevant details of this warehousing for future query and auditing.

[0079] In this embodiment, through the above methods, it can efficiently support the preparation of purchase warehousing documents for different package specifications, ensuring the accuracy and real-time nature of inventory data.

[0080] In the sales document preparation process, first, ensure that there is sufficient information in the database to support the management of different package specifications, usually including product files: Book basic information table: containing basic information such as book ID, book name, author, etc.; Package specification table: associated with the book basic information, defining different package specifications that each book may have (such as single copy, set, etc.), and information such as the barcode and price corresponding to each specification; Inventory table: recording the inventory quantity of each specification.

[0081] Then, on the user interface for sales invoicing, provide the user with an option or input box to allow the user to select or enter the package specification of the book, which can be implemented through a drop-down menu, search box, etc., to facilitate the user to quickly and accurately find the required specification.

[0082] When the user selects a specific book and package specification, the system needs to perform the following operations: Query the inventory table based on the selected book and specification to confirm whether there is sufficient inventory. If the inventory is sufficient, calculate the total amount according to the price of the specification and add the details of this transaction to the sales order. Update the inventory table to reduce the inventory quantity of the corresponding specification.

[0083] To better manage the sales situation of different specifications, the system can also generate relevant reports, such as sales volume statistics and sales amount analysis for each specification, to help decision-makers understand which specifications are more popular and thus optimize inventory management.

[0084] In this embodiment, it is necessary to pay attention to concurrency issues to avoid overselling when multiple sales orders process the same inventory specification simultaneously. For some special specifications (such as limited editions, signed editions, etc.), additional rules or restrictive conditions are required.

[0085] The embodiment of the present invention can also provide a user interface for the user to be able to select the books to be purchased and their corresponding package specifications. The interface allows the user to input or select the following information: selection of books; selection of package specifications; quantity of each specification.

[0086] After that, according to the user's selection, the system performs the following operations: Calculate the total quantity and total price based on the selected book and package specification; Verify whether the inventory is sufficient to support this purchase; Automatically generate a purchase order, listing all information in detail, including book name, specification, quantity, unit price, and total price.

[0087] To improve efficiency, the following automated measures can be adopted: Automatic replenishment suggestion function, which recommends the best purchase quantity based on the current inventory level and sales forecast; Batch import function, which allows the user to quickly enter multiple purchase records through Excel or other format files; Reporting tool, which enables the user to track the purchase history, analyze cost trends, monitor inventory levels, etc. The following is an example process when the user purchases books: Suppose you want to place an order for "Journey to the West". There are two package specifications for this book: single copy sold at ￥50 and a pack of 5 copies sold at ￥230. If you need to buy 23 copies, you can choose: 4 packs (a total of 20 copies), plus 3 single copies. The system will automatically calculate the total cost and generate the corresponding purchase order. In this way, it can effectively support the purchase invoicing of different package specifications, thereby improving work efficiency and reducing errors.

[0088] The above method provided by the embodiments of the present invention can make the information of book commodity materials more complete. In the order-making link, the specific number of copies can be obtained through the number of packages, and then combined with the package specification adjustment form, so as to facilitate the query of the package inventory of various package specifications of the books to be shipped out of the warehouse, facilitate the quick query of the number of packages without unpacking, and provide great convenience for links such as sales order-making.

[0089] For the book inventory management method provided in the foregoing embodiments, the embodiments of the present invention further provide a book inventory management device. Refer to Figure 3 the structural schematic diagram of a book inventory management device shown, which shows that the device mainly includes the following parts:

[0090] The commodity acquisition module 301 is used to acquire the sales commodities to be shipped out from the pre-established commodity file.

[0091] The package specification and package quantity determination module 302 is used to, if the sales commodity is a packaged commodity, generate at least one package specification of the sales commodity based on the preset outbound strategy, and determine the package quantity corresponding to each package specification of the sales commodity; wherein, the outbound strategy includes an outbound strategy based on package volume and / or an outbound strategy based on the number of packages; the outbound strategy based on package volume is that small packages are shipped first or large packages are shipped first; the outbound strategy based on the number of packages is that packages with fewer numbers are shipped first or packages with more numbers are shipped first.

[0092] The sales outbound order generation module 303 is used to generate the total number of copies of the sales commodity based on the package specification and package quantity of the sales commodity, and generate a sales outbound order based on the book name, package specification, package quantity and total number of copies of the sales commodity.

[0093] The above book inventory management device provided by the embodiments of the present invention can, in the sales order-making link, determine the package specification of the sales commodity according to the preset outbound strategy, and then determine the package quantity of each package specification, obtain the specific total number of copies through the package quantity, and then generate a sales outbound order, so as to facilitate the quick query of the package quantity without unpacking, and provide great convenience for links such as sales order-making, improving the convenience of book inventory management.

[0094] In one implementation manner, the above sales outbound order generation module 303 is further used to: determine the intended total number of copies of the sales commodity; if the sales commodity is a packaged commodity, generate at least one package specification of the sales commodity based on the preset outbound strategy; determine the package quantity corresponding to each package specification of the sales commodity based on the preset rounding package strategy, and generate the total number of copies of the sales commodity based on the package specification and package quantity of the sales commodity; wherein, the rounding package strategy includes one of the following: can exceed the intended total number of copies, can be less than the intended total number of copies, and prompt if it cannot be rounded into a whole package; generate a sales outbound order based on the book name, package specification, package quantity and total number of copies of the sales commodity.

[0095] In one embodiment, the above-mentioned sales and outbound order generation module 303 is further configured to: if the sold goods are loose books, determine the total number of books of the sold goods, and generate a sales and outbound order based on the book name and the total number of books of the sold goods.

[0096] In one embodiment, the above-mentioned device further includes: a goods warehousing module, configured to obtain the goods information of the goods to be warehoused; wherein, the goods information includes multiple ones of the following: book name, author, publisher, package specification, number of packages, total number of books; for the packed goods to be warehoused, select the corresponding book name and package specification from the goods file based on the goods information of the goods to be warehoused, determine the number of packages corresponding to the package specification, generate the total number of books based on the package specification and the number of packages, and update the inventory information of the goods to be warehoused; for the loose books to be warehoused, update the inventory information of the goods to be warehoused based on the total number of books of the goods to be warehoused.

[0097] In one embodiment, the above-mentioned device further includes: a goods file creation module, configured to determine whether there is a goods file for the goods to be warehoused based on the goods information; wherein, the goods file at least includes: book name and package specification; if so, obtain the goods file of the goods to be warehoused, and update the goods file according to the package specification of the goods to be warehoused; if not, create a goods file for the goods to be warehoused.

[0098] In one embodiment, the above-mentioned device further includes: a unpacking module, configured to obtain the package specification, number of packages and target package specification of the goods to be unpacked; based on the package specification, number of packages and target package specification of the goods to be unpacked, generate the target number of packages of the goods to be unpacked; generate a repackaging form for the goods to be unpacked based on the target number of packages and the target package specification, so that the business personnel can unpack and repack the goods to be unpacked based on the repackaging form.

[0099] In one embodiment, the above-mentioned device further includes: a packaging module, configured to obtain the total number of books and the target package specification of the goods to be packaged; based on the total number of books and the target package specification of the goods to be packaged, generate the target number of packages of the goods to be packaged; generate a repackaging form for the goods to be packaged based on the target number of packages and the target package specification, so that the business personnel can package the goods to be packaged based on the repackaging form.

[0100] It should be noted that for the device provided in the embodiments of the present invention, its implementation principle and the technical effects generated are the same as those of the foregoing method embodiments. For the sake of brief description, for the parts not mentioned in the device embodiments, reference may be made to the corresponding content in the foregoing method embodiments.

[0101] The embodiments of the present invention further provide an electronic device. Specifically, the electronic device includes a processor and a storage device; a computer program is stored on the storage device, and when the computer program is run by the processor, it executes the method described in any one of the above embodiments.

[0102] Figure 4 A structural schematic diagram of an electronic device provided by an embodiment of the present invention. The electronic device 100 includes: a processor 40, a memory 41, a bus 42, and a communication interface 43. The processor 40, the communication interface 43, and the memory 41 are connected through the bus 42. The processor 40 is configured to execute an executable module stored in the memory 41, such as a computer program.

[0103] Among them, the memory 41 may include a high-speed random access memory (RAM), and may also include a non-volatile memory, such as at least one disk memory. Through at least one communication interface 43 (which can be wired or wireless), a communication connection is established between this system network element and at least one other network element. The Internet, wide area network, local area network, metropolitan area network, etc. can be used.

[0104] The bus 42 can be an ISA bus, a PCI bus, an EISA bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. For the sake of simplicity of representation, Figure 4 only a bidirectional arrow is used to represent it in the figure, but it does not mean that there is only one bus or one type of bus.

[0105] Among them, the memory 41 is used to store a program. After receiving an execution instruction, the processor 40 executes the program. The method executed by the device defined by the flow process disclosed in any embodiment of the foregoing embodiments of the present invention can be applied to the processor 40 or implemented by the processor 40.

[0106] The processor 40 may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by the integrated logic circuit of the hardware in the processor 40 or the instructions in the form of software. The above-mentioned processor 40 may be a general-purpose processor, including a central processing unit (CPU for short), a network processor (NP for short), etc.; it may also be a digital signal processor (DSP for short), an application specific integrated circuit (ASIC for short), a field-programmable gate array (FPGA for short), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components. It can implement or execute the various methods, steps, and logic block diagrams disclosed in the embodiments of the present invention. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc. The steps of the method disclosed in combination with the embodiments of the present invention can be directly embodied as being executed and completed by the hardware decoding processor, or executed and completed by the combination of the hardware and software modules in the decoding processor. The software module may be located in a mature storage medium in the art such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory, or an electrically erasable programmable memory, a register, etc. This storage medium is located in the memory 41, and the processor 40 reads the information in the memory 41 and combines its hardware to complete the steps of the above method.

[0107] The computer program product of the readable storage medium provided by the embodiments of the present invention includes a computer-readable storage medium storing program code, and the instructions included in the program code can be used to execute the method described in the foregoing method embodiments. For the specific implementation, reference can be made to the foregoing method embodiments and will not be elaborated here.

[0108] When the above-mentioned functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or a 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 causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs that can store program codes.

[0109] Finally, it should be noted that the above-mentioned embodiments are only specific implementation manners of the present invention, used to illustrate the technical solutions of the present invention, rather than limiting it. The protection scope of the present invention is not limited thereto. Although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: any person skilled in the art within the technical scope disclosed by the present invention can still modify the technical solutions described in the foregoing embodiments, or can easily conceive of changes, or perform equivalent replacements on some of the technical features; and these modifications, changes, or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be covered by the protection scope of the present invention. Therefore, the protection scope of the present invention should be subject to the protection scope of the claims.

Claims

1. A method for managing book inventory, characterized in that, Include: Obtain the salable goods to be shipped out from a pre - established product file. If the salable goods are packed goods, generate at least one package specification for the salable goods based on a preset shipping - out strategy, and determine the number of packages corresponding to each package specification of the salable goods; wherein, the shipping - out strategy includes a shipping - out strategy based on package volume and / or a shipping - out strategy based on the number of packages; the shipping - out strategy based on package volume is that small packages are shipped out first or large packages are shipped out first; the shipping - out strategy based on the number of packages is that packages with fewer numbers are shipped out first or packages with more numbers are shipped out first. Generate the total number of volumes of the salable goods based on the package specifications and the number of packages of the salable goods, and generate a sales shipping - out list based on the book name, package specifications, number of packages, and total number of volumes of the salable goods.

2. The method according to claim 1, wherein After obtaining the salable goods to be shipped out from the pre - established product file, it further includes: Determine the intended total number of volumes of the salable goods. If the salable goods are packed goods, generate at least one package specification for the salable goods based on a preset shipping - out strategy. Determine the number of packages corresponding to each package specification of the salable goods based on a preset package - rounding strategy, and generate the total number of volumes of the salable goods based on the package specifications and the number of packages of the salable goods; wherein, the package - rounding strategy includes one of the following: can exceed the intended total number of volumes, can be less than the intended total number of volumes, and prompt if no whole - package rounding is possible. Generate a sales shipping - out list based on the book name, package specifications, number of packages, and total number of volumes of the salable goods.

3. The method according to claim 1, characterized in that After obtaining the salable goods to be shipped out from the product file, it further includes: If the salable goods are loose - volume goods, determine the total number of volumes of the salable goods, and generate a sales shipping - out list based on the book name and total number of volumes of the salable goods.

4. The method according to claim 1, wherein It also includes: Obtain the product information of the goods to be warehoused; wherein, the product information includes multiple of the following: book name, author, publisher, package specifications, number of packages, total number of volumes. For the packed goods to be warehoused, select the corresponding book name and package specifications from the product file based on the product information of the goods to be warehoused, determine the number of packages corresponding to the package specifications, generate the total number of volumes based on the package specifications and the number of packages, and update the inventory information of the goods to be warehoused. For the loose - volume goods to be warehoused, update the inventory information of the goods to be warehoused based on the total number of volumes of the goods to be warehoused.

5. The method according to claim 4, wherein After obtaining the product information of the goods to be warehoused, it further includes: Judge whether the goods to be warehoused have a product file based on the product information; wherein, the product file at least includes: book name and package specifications. If so, update the product file according to the package specifications of the goods to be warehoused. If not, establish a product file for the goods to be warehoused.

6. The method according to claim 1, wherein It also includes: Obtain the package specifications, number of packages, and target package specifications of the goods to be unpacked. Generate the target number of packages of the goods to be unpacked based on the package specifications, number of packages, and target package specifications of the goods to be unpacked. Generate a repackaging form for the unpacking-required commodity based on the target package quantity and the target package volume specification, so that the business personnel can unpack and repackage the unpacking-required commodity based on the repackaging form.

7. The method according to claim 1, wherein It further includes: Obtain the total volume of the commodities to be packaged and the target package volume specification; Based on the total volume of the commodities to be packaged and the target package volume specification, generate the target package quantity of the commodities to be packaged; Generate a repackaging form for the commodities to be packaged based on the target package quantity and the target package volume specification, so that the business personnel can package the commodities to be packaged based on the repackaging form.

8. A book inventory management device, characterized in that, It includes: A commodity acquisition module, configured to acquire the salable commodities to be shipped out from a pre-established commodity file; A package volume specification and package quantity determination module, configured to, if the salable commodity is a packaged commodity, generate at least one package volume specification of the salable commodity based on a preset shipping strategy, and determine the package quantity corresponding to each package volume specification of the salable commodity; wherein, the shipping strategy includes a shipping strategy based on package volume and / or a shipping strategy based on the number of packages; the shipping strategy based on package volume is that the small packages are shipped out first or the large packages are shipped out first; the shipping strategy based on the number of packages is that the packages with fewer numbers are shipped out first or the packages with more numbers are shipped out first; A sales shipping order generation module, configured to generate the total volume of the salable commodity based on the package volume specification and the package quantity of the salable commodity, and generate a sales shipping order based on the book name, package volume specification, package quantity, and total volume of the salable commodity.

9. An electronic device, characterized in that, It includes a processor and a memory, the memory stores computer-executable instructions that can be executed by the processor, and the processor executes the computer-executable instructions to implement the steps of the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, on which a computer program is stored, characterized in that, When the computer program is run by the processor, it executes the steps of the method according to any one of claims 1 to 7 above.

Images