Product warehousing management method, device, electronic device and storage medium

Abstract

The present application relates to a product warehousing management method, device, electronic device and storage medium, which belongs to the technical field of database management, wherein the method includes: obtaining a business creation request, wherein the business creation request carries product information; extracting the product category and the corresponding attribute range in the product information based on a preset classification model; taking values ​​for each attribute range of the product category according to a preset verification rule to obtain a corresponding attribute combination to be selected; in the attribute combination to be selected, screening whether there is a target attribute item that cannot match the preset standard attribute combination; if not, updating the product information to a preset product database. The present application has the effect of improving the efficiency of product entry for enterprises.

Description

Technical Field

[0001] The present application relates to the technical field of database management, and in particular to a product warehousing management method, device, electronic device and storage medium. Background Art

[0002] At present, enterprises need to obtain products or services from the supply market as enterprise resources under certain conditions to ensure their production and operation activities.

[0003] In related technologies, companies usually enter the corresponding attributes of purchased products into a product management device. The product management device can record the quantities corresponding to different attributes of a certain product, thereby facilitating company managers to export corresponding product information based on the required products. The product information can be product quantity, product warehousing time, product attributes, etc.

[0004] During the implementation of this application, the inventors discovered that this technology has at least the following problems:

[0005] When a large number of different attributes of a product are stored in the product management device, it is necessary to manually query the attributes corresponding to the product to be entered and update the corresponding quantity. The query and update process is relatively cumbersome, resulting in low efficiency in product entry for the enterprise. Summary of the Invention

[0006] In order to improve the problem of low input efficiency caused by querying and updating corresponding product information, the present application provides a product inventory management method, device, electronic device and storage medium.

[0007] In the first aspect, the present application provides a product warehousing management method, which adopts the following technical solutions:

[0008] A product warehousing management method, comprising:

[0009] Obtaining a business creation request, wherein the business creation request carries product information;

[0010] Extracting product categories and corresponding attribute ranges from the product information based on a preset classification model;

[0011] According to the preset verification rules, the attribute ranges of the product category are evaluated to obtain corresponding attribute combinations to be selected;

[0012] Screening the candidate attribute combinations to see if there are any target attribute items that cannot match the preset standard attribute combination;

[0013] If it does not exist, the product information is updated to the preset product database.

[0014] By employing the above technical solution, when a business creation request is received, product information for the product to be entered is obtained. The classification model is then used to extract the product category from the product information, allowing the determination of all stored standard attribute combinations. Based on the validation rules, the attribute range of the product to be entered is evaluated and compared with the standard attribute combinations to determine whether the attribute range matches any of the standard attribute combinations. This makes it easier to update the corresponding quantity than manual query and update methods, improving the efficiency of product entry for enterprises.

[0015] In a specific implementation manner, the service creation request further carries a user identifier;

[0016] If the selected attribute set does not exist, the selected attribute set is updated into the preset product database, including:

[0017] If not, the candidate attribute set is updated into the preset product database;

[0018] Based on the user identifier, sending a prompt message of successful update to the corresponding first user;

[0019] Otherwise, a prompt message indicating that the update failed is sent to the first user.

[0020] By adopting the above technical solution, the user ID can be used to provide feedback to the corresponding user on whether the business creation is successful, which helps the user to modify or replace the product information.

[0021] In a specific implementation method, the value of each attribute range of the product category is obtained according to the preset verification rules to obtain the corresponding set of attributes to be selected, including:

[0022] Based on the preset verification rules, the minimum value, median value and maximum value of each attribute range are obtained as reference values;

[0023] According to the preset attribute arrangement order, the reference values ​​of the attribute ranges are paired and combined to obtain corresponding attribute combinations to be selected.

[0024] By adopting the above technical solution, the verification rules obtain the reference value of the attribute range of the entered product, and use the reference value for combination to obtain a candidate attribute combination composed of precise values, so that it is possible to quickly determine whether it matches the stored standard attribute combination while more accurately reflecting the attribute range.

[0025] In a specific implementation manner, after obtaining the minimum value, median value, and maximum value of each attribute range as a reference value based on the preset verification rule, the method further includes:

[0026] If the target attribute range in each attribute range is an exact value, the exact value is used as the reference value by default.

[0027] By adopting the above technical solution, when the attribute range is an exact value, since the minimum value, median value and maximum value of the attribute range are all the same exact value, the corresponding minimum value, median value and maximum value are no longer obtained, thereby reducing repeated calculations.

[0028] In a specific embodiment, the attribute range includes specifications, varieties, materials, origin and market price.

[0029] By adopting the above technical solution, specifications, varieties, materials, origins and market prices are different and are stored according to different attribute ranges, which is helpful for users to filter the required products and corresponding product information.

[0030] In a specific embodiment, the method further comprises:

[0031] Regularly obtain change categories and fluctuation ranges;

[0032] Determining target product information associated with the change category in the product database;

[0033] The target product information is updated.

[0034] By adopting the above technical solution, when the price of a product changes, the user can update the product database, effectively reducing the occurrence of price errors.

[0035] In a specific embodiment, the product information further includes a product identification;

[0036] The method further comprises:

[0037] Obtaining a product shipment request uploaded by a second user, wherein the product shipment request carries a product identifier and a corresponding limited range;

[0038] Based on the product identification, obtaining information of products to be selected that match the limited range and corresponding quantities to be shipped from the product database;

[0039] The quantity to be shipped is sent to the second user.

[0040] By adopting the above technical solution, the user sends a request for a product to be shipped and the limited range of the product required, determines the corresponding product according to the limited range and updates the product database to improve the accuracy of the product database data when the product is shipped.

[0041] In a second aspect, the present application provides a product warehousing management device, which adopts the following technical solution:

[0042] A product warehousing management device, comprising:

[0043] A request acquisition module is used to acquire a business creation request, wherein the business creation request carries product information;

[0044] An attribute range extraction module, configured to extract product categories and corresponding attribute ranges from the product information based on a preset classification model;

[0045] A combination obtaining module is used to obtain values ​​for each attribute range of the product category according to a preset verification rule to obtain a corresponding attribute combination to be selected;

[0046] An attribute item screening module is used to screen the candidate attribute combinations to see whether there is a target attribute item that cannot match a preset standard attribute combination;

[0047] The product information updating module is used to update the product information into a preset product database when the product information does not exist.

[0048] By adopting the above technical solution, when the product management device receives a business creation request, it obtains the product information of the product to be entered. Using the classification model, it then extracts the product category from the product information, determining all stored standard attribute combinations. Based on the verification rules, the attribute range of the product to be entered is evaluated and compared with the standard attribute combinations to determine whether the attribute range matches any of the standard attribute combinations. This makes it easier to update the corresponding quantity than manual query and update methods, thereby improving the efficiency of product entry for enterprises.

[0049] In a third aspect, the present application provides an electronic device, which adopts the following technical solution:

[0050] Optionally, the electronic device includes a processor and a memory, wherein the memory stores at least one instruction, at least one program, code set or instruction set, and the at least one instruction, at least one program, code set or instruction set is loaded and executed by the processor to implement a product inventory management method as described in the first aspect.

[0051] In a fourth aspect, the present application provides a computer-readable storage medium, which adopts the following technical solution:

[0052] Optionally, the storage medium stores at least one instruction, at least one program, code set or instruction set, and the at least one instruction, at least one program, code set or instruction set is loaded and executed by the processor to implement a product inventory management method as described in the first aspect.

[0053] In summary, this application includes at least one of the following beneficial technical effects:

[0054] 1. When a business creation request is received, the product information of the product to be entered is obtained. The product category in the product information is then extracted using a classification model to determine all stored standard attribute combinations. Based on the validation rules, the attribute range of the product to be entered is taken and compared with the standard attribute combinations to determine whether the attribute range matches any of the standard attribute combinations. This makes it easier to update the corresponding quantity than manual query and update methods, improving the efficiency of product entry for the enterprise.

[0055] 2. Through user identification, feedback can be provided to the corresponding user on whether the business creation is successful, which helps users modify or replace product information;

[0056] 3. The verification rule obtains the reference value of the attribute range of the entered product, and uses the reference value to combine to obtain a candidate attribute combination composed of precise values, so that it can quickly determine whether it matches the stored standard attribute combination while more accurately reflecting the attribute range. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0058] Figure 1 This is a structural block diagram of a product warehousing management system according to an embodiment of the present application.

[0059] Figure 2 It is a flowchart of a product warehousing management method according to an embodiment of the present application.

[0060] Figure 3 It is a flow chart of a product warehousing management device according to an embodiment of the present application. DETAILED DESCRIPTION

[0061] In order to make the objectives, technical solutions and advantages of this application clearer, the implementation methods of this application will be further described in detail below with reference to the accompanying drawings.

[0062] The embodiment of the present application provides a product entry management method, which can be applied to a product entry management system. The framework structure of a product entry management system can be as follows: Figure 1As shown, it may include a product management device and a user terminal. The product management device may be a server, and the user terminal may be a computer, a mobile phone, or a tablet. Specifically, the execution subject of the method may be the product management device, and it may be assisted by the user terminal. The product management device obtains the product information of a certain product uploaded by the user terminal and updates the product information to a preset product database to facilitate the enterprise to manage all internal products. The present application can be applied to the supply chain of bulk commodities, and performs data management on products in the supply chain, wherein the data management may be recording the cashier of the product.

[0063] The following will be combined with specific implementation methods. Figure 2 The processing flow shown is described in detail, and the content can be as follows:

[0064] Step 201: Obtain a service creation request, which carries product information.

[0065] During implementation, the user can log in to the application associated with the product management device and click the order creation button to generate the corresponding order filling interface. The user can enter the information of the product to be stored (i.e., product information) in the order filling interface, and the product management device will obtain a business creation request, which carries product information. Product information includes, for example, product specifications, varieties, materials, etc. In addition, the paper order can be scanned by a scanner associated with the product management device, and the product management device obtains the product information in the paper order through a built-in character recognition model, wherein deep learning is performed through training samples to obtain the corresponding character recognition model. The character recognition model is used to convert product information into a character string. For example, the product information can be building materials-diameter 3.51-length 850, then the converted character string can be Φ3.51*850.

[0066] Step 202: extract product categories and corresponding attribute ranges from the product information based on a preset classification model.

[0067] The product management device pre-configures a classification model, which is used to determine the corresponding product category and attribute range based on pre-stored product specifications. Product specifications can be divided into precise specifications and standard specifications. For example, the precise specification of building materials can be [Φ] diameter [* length], while the standard specification of building materials can be [Φ]\(diameter-diameter\)[*\(length-length\)]|Φ diameter-Φ diameter. The precise specification of hot-rolled coils can be thickness\*\width*(L|C), while the standard specification of hot-rolled coils can be \(thickness-thickness\)\*\(width-width\)\*(L|C), where L can indicate medium and heavy plate and C can indicate coil.

[0068] During implementation, the product management device determines the product specifications corresponding to the product information based on a preset classification model. Based on the product specifications, it then determines the corresponding product category and attribute range. For example, if the product management device extracts the product information of 3.51*1000*C, the corresponding product category is "hot coil" and the attribute range is "thickness 3.51, width 1000, coil type."

[0069] Furthermore, in order to facilitate users to ship out more precise products, the attribute range includes specifications, varieties, materials, origin and market price.

[0070] During implementation, the product management device adds a suffix to the pre-stored product specifications. The suffix can be one or more of variety, material, place of origin, and market price.

[0071] Step 203 : According to the preset verification rules, the attribute ranges of the product categories are evaluated to obtain corresponding attribute combinations to be selected.

[0072] In implementation, the product management device is pre-set with a verification rule, which may be SKU verification, to take values ​​from each attribute range of the product category to obtain a corresponding attribute combination to be selected.

[0073] Furthermore, step 203 specifically includes the following contents:

[0074] The product management device pre-sets an attribute arrangement order, and the attribute arrangement order may be an order in which the values ​​of the product specifications are arranged in sequence.

[0075] The product management device obtains the minimum, median, and maximum values ​​of each attribute range as reference values ​​based on a preset verification rule. It then pairs and combines the reference values ​​of each attribute range according to a preset attribute arrangement order to obtain the corresponding candidate attribute combination. For example, the product management device obtains a certain specification of (3.51-13.99)*(850-1120)*C, and obtains the corresponding hot coil thickness of 3.51-13.99 and width of 850-1120. Then, the minimum value corresponding to the thickness is 3.51, the median value is 8.75, and the maximum value is 13.99. The minimum value corresponding to the width is 850, the median value is 985, and the maximum value is 1120. A certain value of the thickness and a certain value of the width are combined, for example: 3.51*850*C, 3.51*1120*C, 13.99*985*C, etc., and the reference values ​​of each attribute range (i.e., the minimum value, median value and maximum value) can be paired and combined to obtain a set of corresponding attribute combinations to be selected.

[0076] Furthermore, in order to reduce repeated operations, after obtaining the minimum value, median value, and maximum value of each attribute range as reference values ​​based on the preset verification rules, the specific content can be:

[0077] In practice, if the product management device identifies a specific attribute range (i.e., the target attribute range) as an exact value, the exact value is used as the reference value by default. For example, if an attribute range is (0.35-0.6)*1000*C, then 1000 is used as the minimum, median, and maximum values ​​of the width by default.

[0078] Step 204 : Screening the candidate attribute combinations to see whether there are any target attribute items that cannot match the preset standard attribute combination.

[0079] During implementation, the product management device pre-sets a standard attribute combination. A certain standard attribute combination may include multiple attribute items. The attribute items may specifically be sku codes, categories, materials, specifications, and places of origin, etc. The product management device screens whether there is any inconsistency between a certain attribute item (i.e., the target attribute item) in the attribute combination to be selected and the corresponding attribute item in the standard attribute combination. That is, in the attribute combination to be selected, it is screened whether there is a target attribute item that cannot match the preset standard attribute combination.

[0080] Step 205: If the product information does not exist, update the product information to the preset product database.

[0081] During implementation, when there is no target attribute item that cannot match the preset standard attribute combination, the product management device determines the attribute range and corresponding quantity of the product in the product information, obtains a product data column that is consistent with the attribute range of the product for update, and the update can be to increase the quantity corresponding to the product to the original quantity of the product data column.

[0082] Optionally, to facilitate the user to modify or replace the product information, step 205 specifically includes the following:

[0083] The service creation request also carries a user identifier, which may be a serial number automatically and randomly generated by the product management device for different users.

[0084] In implementation, if it does not exist, the product management device updates the candidate attribute set to the preset product database; based on the user identifier, a prompt message of successful update is sent to the corresponding first user, otherwise, a prompt message of failed update is sent to the first user.

[0085] Optionally, in order for the enterprise to adjust the price of the corresponding product according to the market conditions of the product, this application also includes the following content:

[0086] The product management device periodically obtains the change category and the market price fluctuation range. The fluctuation range can be an increase or decrease in the price range. In addition, the period can be one hour, one day, or one week. From the product database, the product management device obtains the product category that matches the change category, determines the target product information associated with the product category, and changes (i.e., updates) the market price in the target product information.

[0087] Optionally, to improve the accuracy of product database data when products are shipped out, this application also includes the following:

[0088] During implementation, the product information pre-stored by the product management device also includes a product identifier, which can be a SKU code or a random code specific to a particular product. The product management device receives a product shipment request uploaded by a user (i.e., a second user). The product shipment request carries the product identifier and a corresponding limited range. The limited range can be one or more of the user's requirements for a particular product, such as market price, category, and material. Based on the product identifier, the product management device retrieves product information (i.e., candidate product information) and the corresponding quantity to be shipped from the product database that is consistent with (i.e., matches) the limited range of attributes. The device then sends the quantity to be shipped to the second user, allowing the second user to determine the required quantity based on the quantity to be shipped.

[0089] In addition, the product management device obtains a product shipment request uploaded by a third user, and the product shipment request carries a product identification, a product demand quantity, and a corresponding limited range; based on the product identification, in the product database, the information of the selected products matching the limited range and the corresponding quantity to be shipped are obtained; if the product demand quantity is less than the quantity to be shipped, the product database is updated according to the quantity to be shipped; the quantity to be shipped is sent to the third user; otherwise, the authority level corresponding to the third user is obtained; when the authority level is high, the quantity to be shipped is sent to the third user; when the authority level is low, a prompt message of failure is sent to the third user; and a prompt message that the selected products need to be supplemented is sent to the user corresponding to the high authority level.

[0090] Based on the same technical concept, the embodiment of the present application also discloses a product warehousing management device, such as Figure 3 As shown, a product warehousing management device includes:

[0091] The request acquisition module 301 is used to acquire a business creation request, which carries product information;

[0092] The attribute range extraction module 302 is used to extract the product category and the corresponding attribute range in the product information based on a preset classification model;

[0093] The combination obtaining module 303 is used to obtain values ​​for each attribute range of the product category according to a preset verification rule to obtain a corresponding attribute combination to be selected;

[0094] The attribute item screening module 304 is used to screen the candidate attribute combinations to see whether there is a target attribute item that cannot match the preset standard attribute combination;

[0095] The product information updating module 305 is used to update the product information into a preset product database when the product information does not exist.

[0096] Optionally, an attribute set updating module is configured to update the candidate attribute set into a preset product database when there is no target attribute item that cannot match the preset standard attribute combination;

[0097] A prompt information sending module, configured to send a prompt information indicating that the update is successful to the corresponding first user based on the user identifier;

[0098] The prompt information sending module is further configured to send a prompt information indicating that the update has failed to the first user when there is a target attribute item that cannot match the preset standard attribute combination.

[0099] Optionally, a reference value acquisition module is used to obtain the minimum value, median value and maximum value of each attribute range as reference values ​​based on preset verification rules;

[0100] The attribute combination obtaining module is used to pair and combine the reference values ​​of each attribute range according to the preset attribute arrangement order to obtain the corresponding attribute combination to be selected.

[0101] Optionally, a reference value default module is used to default the exact value as the reference value when the target attribute range in each attribute range is an exact value.

[0102] Optional, a fluctuation range acquisition module, used to regularly obtain change categories and fluctuation ranges;

[0103] A product information determination module is used to determine target product information associated with the change category in the product database;

[0104] The product information update module is used to update the target product information.

[0105] Optionally, a limited range acquisition module is used to acquire a product shipment request uploaded by a second user, the product shipment request carrying a product identifier and a corresponding limited range;

[0106] The module for obtaining the quantity to be shipped is used to obtain the information of the selected products that match the limited range and the corresponding quantity to be shipped from the product database based on the product identification;

[0107] The module for sending the quantity to be shipped is used to send the quantity to be shipped to the second user.

[0108] An embodiment of the present application further discloses an electronic device, which includes a memory and a processor, wherein the memory stores a computer program that can be loaded by the processor and execute a product warehousing management method as described above.

[0109] Based on the same technical concept, an embodiment of the present application also discloses a computer-readable storage medium, which stores a computer program that can be loaded by a processor and execute a product inventory management method such as the above-mentioned method. The computer-readable storage medium includes, for example: a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and other media that can store program codes.

[0110] The above embodiments are intended only to illustrate the technical solutions of this application and are not intended to limit the scope of protection of this application. Obviously, the embodiments described are only some of the embodiments of this application, not all of them. Based on these embodiments, all other embodiments obtained by persons of ordinary skill in the art without inventive effort are also within the scope of protection to be protected by this application.

Claims

1. A product warehousing management method, characterized in that: include: Obtaining a business creation request, wherein the business creation request carries product information; Extracting product categories and corresponding attribute ranges from the product information based on a preset classification model; According to the preset verification rules, the attribute ranges of the product category are evaluated to obtain corresponding attribute combinations to be selected; Screening the candidate attribute combinations to see if there are any target attribute items that cannot match the preset standard attribute combination; If it does not exist, then update the product information into the preset product database; According to the preset verification rules, the attribute ranges of the product category are evaluated to obtain a corresponding set of attributes to be selected, including: Based on the preset verification rules, the minimum value, median value and maximum value of each attribute range are obtained as reference values; According to a preset attribute arrangement order, the reference values ​​of the attribute ranges are paired and combined to obtain corresponding attribute combinations to be selected; After obtaining the minimum value, median value, and maximum value of each attribute range as reference values ​​based on the preset verification rule, the method further includes: If the target attribute range in each attribute range is an exact value, the exact value is used as the reference value by default.

2. A product warehousing management method according to claim 1, characterized in that: The service creation request also carries a user identifier; If the selected attribute set does not exist, the selected attribute set is updated into the preset product database, including: If not, the candidate attribute set is updated into the preset product database; Based on the user identifier, sending a prompt message of successful update to the corresponding first user; Otherwise, a prompt message indicating that the update failed is sent to the first user.

3. A product warehousing management method according to claim 1, characterized in that: The attributes include specifications, varieties, materials, origin and market price.

4. A product warehousing management method according to claim 1, characterized in that: The method further comprises: Regularly obtain change categories and fluctuation ranges; Determining target product information associated with the change category in the product database; The target product information is updated.

5. A product warehousing management method according to claim 4, characterized in that: The product information also includes product identification; The method further comprises: Obtaining a product shipment request uploaded by a second user, wherein the product shipment request carries a product identifier and a corresponding limited range; Based on the product identification, obtaining information of products to be selected that match the limited range and corresponding quantities to be shipped from the product database; The quantity to be shipped is sent to the second user.

6. A product warehousing management device, characterized in that: include: A request acquisition module is used to acquire a business creation request, wherein the business creation request carries product information; An attribute range extraction module, configured to extract product categories and corresponding attribute ranges from the product information based on a preset classification model; A combination obtaining module is used to obtain values ​​for each attribute range of the product category according to a preset verification rule to obtain a corresponding attribute combination to be selected; According to the preset verification rules, the attribute ranges of the product category are evaluated to obtain the corresponding attribute set to be selected, including: Based on the preset verification rules, the minimum value, median value and maximum value of each attribute range are obtained as reference values; According to a preset attribute arrangement order, the reference values ​​of the attribute ranges are paired and combined to obtain corresponding attribute combinations to be selected; After obtaining the minimum value, median value, and maximum value of each attribute range as reference values ​​based on the preset verification rule, the method further includes: If the target attribute range in each attribute range is an exact value, the exact value is used as the reference value by default; An attribute item screening module is used to screen the candidate attribute combinations to see whether there is a target attribute item that cannot match a preset standard attribute combination; The product information updating module is used to update the product information into a preset product database when the product information does not exist.

7. An electronic device, characterized in that: The method comprises a memory and a processor, wherein the memory stores a computer program that can be loaded by the processor and execute the method according to any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that A computer program is stored which can be loaded by a processor and execute the method according to any one of claims 1 to 5.

Images