CN112380187B - Inventory data monitoring method and device, computer equipment and storage medium - Google Patents

Inventory data monitoring method and device, computer equipment and storage medium Download PDF

Info

Publication number
CN112380187B
CN112380187B CN202011256906.1A CN202011256906A CN112380187B CN 112380187 B CN112380187 B CN 112380187B CN 202011256906 A CN202011256906 A CN 202011256906A CN 112380187 B CN112380187 B CN 112380187B
Authority
CN
China
Prior art keywords
inventory
data
monitoring
commodity
amount
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011256906.1A
Other languages
Chinese (zh)
Other versions
CN112380187A (en
Inventor
蒋洋建
刘建洋
姚舜
史凯丽
郑学伦
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Suning Cloud Computing Co Ltd
Original Assignee
Suning Cloud Computing Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Suning Cloud Computing Co Ltd filed Critical Suning Cloud Computing Co Ltd
Priority to CN202011256906.1A priority Critical patent/CN112380187B/en
Publication of CN112380187A publication Critical patent/CN112380187A/en
Priority to CA3138753A priority patent/CA3138753A1/en
Application granted granted Critical
Publication of CN112380187B publication Critical patent/CN112380187B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application relates to an inventory data monitoring method, an inventory data monitoring device, computer equipment and a storage medium, wherein the method comprises the following steps: receiving monitoring configuration information, and generating an inventory counting task according to the monitoring configuration information; determining one or more monitoring dimensions in an inventory statistics task; acquiring monitoring parameters of each monitoring dimension and a data statistical mode of the monitoring parameters; and determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to a data counting mode, and performing data monitoring on a counting result. The method can automatically count and monitor the inventory data.

Description

Inventory data monitoring method, device, computer equipment and storage medium
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for monitoring inventory data, a computer device, and a storage medium.
Background
Currently, an enterprise inventory report is presented in an Excel form, and data of the inventory report is obtained from a data system. Specifically, business personnel export report data from a data system, and due to the reasons that the report data is large, the export time is long, the dimensionality of the exported data is single and inconsistent with actual business requirements, the exported data needs to be processed for the second time manually, the time consumption is long, errors are prone to occurring, the situation that operation and collection and sales personnel obtain inventory report information is relatively delayed, the situation that the inventory is insufficient cannot be processed in time, the sales volume of an enterprise is influenced to a great extent, and huge economic losses are brought to the enterprise while the manpower losses are caused.
Particularly, when an enterprise relates to multi-platform operation, the unified inventory management process among a plurality of shops is complex, the inventory data needs to be exported from each data system and then manually counted, the data processing time is long, the efficiency is low, and errors are easy to occur.
Disclosure of Invention
In view of the above, it is necessary to provide an inventory data monitoring method, an apparatus, a computer device and a storage medium capable of automatically counting and monitoring inventory data.
A method of inventory data monitoring, the method comprising: receiving monitoring configuration information, and generating an inventory counting task according to the monitoring configuration information; determining one or more monitoring dimensions in an inventory statistics task; acquiring monitoring parameters of each monitoring dimension and a data statistical mode of the monitoring parameters; and determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to a data counting mode, and performing data monitoring on a counting result.
In one embodiment, the method further comprises: receiving and storing inventory data of the imported plurality of second inventory objects; monitoring order information of a plurality of second stock objects, and modifying the stored stock data of any second stock object according to the order information of any second stock object when the monitored order information of any second stock object causes the stock data of any second stock object to change; determining a first inventory object corresponding to the monitoring parameters, and counting the inventory data of the first inventory object according to a data counting mode, wherein the method comprises the following steps: and determining a first inventory object from the plurality of second inventory objects, acquiring the stored inventory data of the first inventory object, and counting the inventory data of the first inventory object according to a data counting mode.
In one embodiment, when the monitoring of the order information of any second inventory object causes a change in the inventory data of any second inventory object, modifying the stored inventory data of any second inventory object according to the order information of any second inventory object includes: and when the fact that the stock data of any second stock object needs to be reduced or increased due to monitoring of the order information of any second stock object is detected, the stock data of any second stock object is modified according to the reduction information or the increase information in the order information of any second stock object.
In one embodiment, monitoring order information of a plurality of second inventory objects, and modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when the monitored order information of any second inventory object causes the inventory data of any second inventory object to change comprises: performing data query on inventory data of a platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the query of the order information of any second inventory object; and the platform where any second stock object is located updates the stock data of any second stock object according to the order information.
Preferably, the method further comprises: setting a thread pool, and creating a plurality of threads in the thread pool; and controlling each thread to execute data query on the inventory data of the platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located in a concurrent mode, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the queried order information of any second inventory object.
Preferably, the method further comprises: and acquiring a thread number threshold, and controlling the number of concurrent threads in the thread pool through the thread number threshold.
In one embodiment, the first stock object comprises a commodity store, the stock data of the first stock object comprises the commodity amount and the amount of the stock commodities of the commodity store, and the monitoring parameters comprise a real-time stock amount, a real-time stock satisfaction rate, a stock plan satisfaction rate, a specified commodity stock amount, a joint-collected commodity stock amount, a spot stock amount or a pre-sale stock amount; the data statistical mode of the real-time inventory money is determined according to the product of the accumulated sum of the commodity quantity of the inventory commodity and the commodity store indicated in the inventory statistical task; the data statistics mode of the real-time inventory satisfaction rate is determined according to the sum of the inventory commodities in the commodity store, a first preset target sum and a preset early warning coefficient; the data statistics mode of the stock plan satisfaction rate is determined according to the sum of the inventory commodities in the commodity store with the preset inventory and a second preset target sum; the data statistical mode of the inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the specified commodity and the commodity price of the specified commodity; the data statistical mode of the jointly collected inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the jointly collected inventory commodities and the commodity price of the jointly collected inventory commodities; the data statistical mode of the spot inventory amount is determined according to the product of the sum of the commodity amount of the existing inventory commodity and the commodity price of the existing inventory commodity; the data statistics mode of the pre-sale inventory amount is determined according to the product of the sum of the commodity quantity of the pre-sale inventory commodity and the commodity price of the pre-sale inventory commodity.
In one embodiment, the plurality of monitoring dimensions include a single item dimension, a category dimension and a brand dimension, the inventory data of the first inventory object corresponding to the monitoring parameters of the single item dimension includes the commodity amount and the money amount of a single commodity, the inventory data of the first inventory object corresponding to the monitoring parameters of the category dimension includes the commodity amount and the money amount of a plurality of commodities of the same category, and the inventory data of the first inventory object corresponding to the monitoring parameters of the brand dimension includes the commodity amount and the money amount of a plurality of commodities of the plurality of categories of the same brand.
In one embodiment, the method further comprises: acquiring a monitoring result of data monitoring; performing early warning management on the monitoring result according to preset rule information; or generating early warning information according to the monitoring result, calling an interface of the external platform, and sending the early warning information to the external platform through the interface of the external platform.
Preferably, the method further comprises: and receiving external alarm information, and performing corresponding alarm according to the external alarm information.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method of any of the above embodiments when executing the computer program.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any of the above embodiments.
According to the inventory data monitoring method, the device, the computer equipment and the storage medium, the background receives the monitoring configuration information, the inventory statistics task is generated according to the monitoring configuration information, one or more monitoring dimensions in the inventory statistics task are determined, the monitoring parameters of the monitoring dimensions and the data statistics mode of the monitoring parameters are obtained, the first inventory object corresponding to the monitoring parameters is determined, the inventory data of the first inventory object are counted according to the data statistics mode, and the data monitoring is carried out on the counting result. Therefore, inventory data management personnel send monitoring configuration information of the monitored object to the background through the terminal, the background can generate a corresponding inventory counting task, corresponding inventory data counting and data monitoring are automatically executed according to the inventory counting task, manual operation is not needed, data processing time is shortened, and data processing efficiency is improved.
Drawings
FIG. 1 is a diagram of an application environment of a method for inventory data monitoring in one embodiment;
FIG. 2 is a flow diagram illustrating a method for inventory data monitoring, according to one embodiment;
FIG. 3 is a display diagram of a configuration interface for syndicating targeted information in one embodiment;
FIG. 4 is a display diagram of a configuration interface for early warning configuration information in one embodiment;
FIG. 5 is a display of a configuration interface for product inventory information in one embodiment;
FIG. 6 is a block diagram of a background build inventory data system in one embodiment;
FIG. 7 is an interface display of multiple monitoring dimensions and multiple monitoring parameters in one embodiment;
FIG. 8 is an architectural diagram of a background system architecture in one embodiment;
FIG. 9 is a flow diagram of a method for inventory data monitoring in an exemplary embodiment;
FIG. 10 is a timing diagram of inventory statistics for a method of inventory data monitoring in one embodiment;
FIG. 11 is a block diagram of an embodiment of an inventory data monitoring device;
FIG. 12 is a diagram of an internal structure of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The inventory data monitoring method is applied to the application environment shown in fig. 1. The background 10 is used to implement an inventory data monitoring method of the present application. The back office 10 includes a back-end server 102, an inventory system 104, and a database system 106. Specifically, the user inputs the monitoring configuration information in the terminal 20, and the terminal 20 sends the monitoring configuration information to the backend server 102 of the backend 10. The back-end server 102 generates an inventory statistics task according to the monitoring configuration information. Further, the back-end server 102 sends inventory statistics tasks to the inventory system 104. The inventory system 104 determines one or more monitoring dimensions in the inventory statistics task, and obtains monitoring parameters of each monitoring dimension and a data statistics manner of the monitoring parameters. Further, a first inventory object corresponding to the monitoring parameter is determined, inventory data of the first inventory object is extracted from the database system 106, the inventory data of the first inventory object is counted according to a data counting mode, and data monitoring is performed on a counting result. Therefore, manual operation is not needed, the data processing time is shortened, and the data processing efficiency is improved.
In one embodiment, as shown in fig. 2, an inventory data monitoring method is provided, which is described by taking the method as an example applied to the background 10 in fig. 1, and includes the following steps:
and S102, receiving the monitoring configuration information, and generating an inventory counting task according to the monitoring configuration information.
In this embodiment, the user may set the monitoring configuration information through the front-end workbench. The monitoring configuration information can comprise promotion target information, early warning configuration information, goods inventory information and the like of the commodities. The configuration of the promotion target information is shown in fig. 3, the configuration of the early warning configuration information is shown in fig. 4, and the configuration of the product type inventory information is shown in fig. 5.
The background receives monitoring configuration information sent by the front-end workbench, an inventory counting task is automatically created according to the monitoring configuration information, and after the inventory counting task is executed, inventory counting information with multiple dimensions can be checked on an inventory monitoring interface. Specifically, a main thread is created, which is used to perform inventory statistics tasks.
S104, determining one or more monitoring dimensions in the inventory statistics task.
In this embodiment, the back-office determines one or more monitoring dimensions in the inventory statistics task. The monitoring dimension can be determined according to the attribute information and the characteristic information of the inventory item corresponding to the inventory counting task. For example, the monitoring dimensions may include a singleton dimension, a category dimension, and other characteristic information building dimensions for the inventory item. Wherein determining one or more monitoring dimensions in the inventory statistics task may be: one or more monitoring dimensions are generated based on the inventory statistics task. For example, corresponding monitoring information is extracted from the inventory statistics task, and corresponding one or more monitoring dimensions are generated according to the monitoring information. Alternatively, determining one or more monitoring dimensions in an inventory statistics task may be: and acquiring identification information of the inventory statistics task, and extracting one or more monitoring dimensions in the inventory statistics task from a plurality of preset monitoring dimensions according to the identification information. Alternatively, determining one or more monitoring dimensions in an inventory statistics task may be: and reading one or more preset monitoring dimensions, and using the one or more preset monitoring dimensions as one or more monitoring dimensions in the inventory statistics task. For example, one or more monitoring dimensions are preset in the background, and any inventory statistics task performs data monitoring according to the preset one or more monitoring dimensions. Therefore, unified management of the inventory data by the background can be facilitated.
And S106, acquiring the monitoring parameters of each monitoring dimension and the data statistical mode of the monitoring parameters.
In this embodiment, the monitoring parameters of each monitoring dimension may be the same or different. For example, the monitoring parameters of the monitoring dimension a include a parameter a, a parameter B, and a parameter c, and the monitoring parameters of the monitoring dimension B also include a parameter a, a parameter B, and a parameter c. Or, the monitoring parameters of the monitoring dimension a include a parameter a, a parameter B and a parameter c, and the monitoring parameters of the monitoring dimension B include a parameter d, a parameter e and a parameter f. The monitoring parameters may be preset by the background, for example, the monitoring parameters may be the inventory amount of the inventory item, the amount of money of the inventory item, the inventory amount of the specified item in the inventory item, and the like. Meanwhile, the background can also preset a data statistical mode of the monitoring parameters. And the data statistical mode is used for indicating that statistical processing is carried out on the data corresponding to the monitoring parameters according to a preset data statistical rule. Specifically, the background may obtain the monitoring parameters of each monitoring dimension in an information matching manner. Further, a data statistical mode of the monitoring parameters is determined.
S108, determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to a data counting mode, and performing data monitoring on a counting result.
In this embodiment, the first inventory object may be a platform that manages inventory items. The first inventory object may be one or more. Each monitoring dimension corresponds to one or more monitoring parameters, and each monitoring parameter corresponds to one or more first inventory objects. The background determines a monitoring dimension corresponding to the inventory statistics task, further determines a monitoring parameter corresponding to the monitoring dimension, and then determines a first inventory object corresponding to the monitoring parameter. For example, the monitoring dimension corresponding to the determined inventory statistics task is an item, the monitoring parameter corresponding to the item is inventory, and the first inventory object corresponding to the inventory is a platform a, a platform B and a platform C where the item is located.
Further, the inventory data of the first inventory object is obtained, and data statistics is performed on the obtained inventory data in a data statistics mode. And meanwhile, monitoring data according to the statistical result. For example, a monitoring report is generated according to the statistical result, and data monitoring is performed according to the data result displayed by the monitoring report. The inventory data of the first inventory object may be dynamic data, and thus a statistical result obtained by performing data statistics on the acquired inventory data in a data statistics manner is also dynamic. Therefore, compared with manual statistical operation, the automatic inventory data monitoring method can improve the monitoring efficiency of the inventory data.
According to the inventory data monitoring method, the background receives monitoring configuration information, an inventory counting task is generated according to the monitoring configuration information, one or more monitoring dimensions in the inventory counting task are determined, monitoring parameters of all the monitoring dimensions and data counting modes of the monitoring parameters are obtained, a first inventory object corresponding to the monitoring parameters is determined, inventory data of the first inventory object are counted according to the data counting modes, and data monitoring is conducted on counting results. Therefore, inventory data management personnel send monitoring configuration information of the monitored object to the background through the terminal, the background can generate a corresponding inventory counting task, corresponding inventory data counting and data monitoring can be automatically executed according to the inventory counting task, manual operation is not needed, data processing time is shortened, and data processing efficiency is improved.
In an embodiment, before S108, the method further includes: receiving and storing inventory data of a plurality of imported second inventory objects; monitoring order information of a plurality of second inventory objects, and modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when the monitored order information of any second inventory object causes the inventory data of any second inventory object to change. S108 includes: and determining a first inventory object from the plurality of second inventory objects, acquiring the stored inventory data of the first inventory object, and counting the inventory data of the first inventory object according to a data counting mode.
In this embodiment, the inventory data system is built in the background, as shown in FIG. 6. The inventory data system comprises a database, an analysis module, an inventory cleaning module, a monitoring module and an early warning module. The inventory data system receives and stores inventory data for the imported plurality of second inventory objects. Inventory data for the imported plurality of second inventory objects is stored in a database. The monitoring module monitors order information of a plurality of second inventory objects. Specifically, the monitoring module reads the inventory data of each second inventory object by calling an interface of the inventory data storage system of each second inventory object, and stores the read inventory data into the database. And simultaneously monitoring the order information of each second stock object. And when the fact that the order information of any second stock object causes the stock data of any second stock object to change is monitored, the stock data of any second stock object is modified according to the order information of any second stock object. In particular, the inventory data system may directly monitor the inventory data management system of each second inventory object for order information. And the inventory data management system of each second inventory object modifies the inventory data in the inventory data storage system according to the order information. Further, the stored inventory data of the second inventory object is modified according to the monitored order information.
Further, a first inventory object is screened out from the plurality of second inventory objects, and stored inventory data of the first inventory object is obtained from an inventory data system. The stored inventory data of the first inventory object may be the inventory data before modification or the inventory data after modification. When the data storage system modifies and stores the first stock data according to the monitored order information, the data monitoring can be well carried out according to the statistical result when the stock data of the first stock object is counted according to the data statistical mode.
In this embodiment, the inventory data system accesses the inventory data of the plurality of second inventory objects, and performs corresponding monitoring management on the accessed inventory data. When the inventory data is changed due to the order information in the inventory data management system corresponding to the inventory data, the inventory data stored in the inventory data system is modified immediately according to the monitoring result, namely the order information, so that the final data monitoring result is more accurate, the inventory data is monitored more timely, and the data monitoring efficiency is improved.
In one embodiment, when it is monitored that the order information of any one of the second inventory objects causes a change in the inventory data of any one of the second inventory objects, modifying the stored inventory data of any one of the second inventory objects according to the order information of any one of the second inventory objects includes: and when the fact that the stock data of any second stock object needs to be reduced or increased due to monitoring of the order information of any second stock object is detected, the stock data of any second stock object is modified according to the reduction information or the increase information in the order information of any second stock object.
Specifically, the monitoring module monitors the issued order information in real time. When the order information indicates the state of the stored stock needing to be deducted, for example, two scenes of order deduction and payment deduction are set, an inventory cleaning module of the inventory data system is called to deduct the stock data stored in the database. In the operation process, the monitoring module inquires an interface of the inventory data storage system of the second inventory object at regular time, and when the inventory data is monitored to be reduced, the inventory cleaning module corrects the inventory data stored locally. Therefore, the final data monitoring result can be more accurate and timely, and the data monitoring efficiency is improved.
In one embodiment, monitoring order information of a plurality of second inventory objects, and modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when the monitored order information of any second inventory object causes the inventory data of any second inventory object to change comprises: performing data query on the inventory data of the platform where the second inventory objects are located through the inventory interface of the platform where the second inventory objects are located, and when the query result shows that the inventory data of the platform where the second inventory objects are located changes, modifying the stored inventory data of the second inventory objects according to the updated inventory data of the platform where the second inventory objects are located; and the platform where any second stock object is located updates the stock data of any second stock object according to the order information.
In this embodiment, each second inventory object performs data management through its corresponding platform. And the monitoring module calls an inventory interface of a platform where each second inventory object is located, performs data query on inventory data of the platform where each second inventory object is located, and stores the queried inventory data in a database of the inventory data system. And meanwhile, calling an inventory interface of the platform where each second inventory object is located to monitor the data change of the inventory data of the platform where the second inventory object is located, and modifying the locally stored inventory data of the second inventory object according to the updated inventory data of the platform where the second inventory object is located. Therefore, the inventory data system realizes statistical management of the inventory data of the second inventory objects of the multiple platforms, and performs data monitoring on the inventory data of the second inventory objects of the multiple platforms according to the statistical result.
In an embodiment, before performing the data query on the inventory data of the platform where each second inventory object is located through the inventory interface of the platform where each second inventory object is located, the method further includes: and setting a thread pool, and creating a plurality of threads in the thread pool. And controlling each thread to execute data query on the inventory data of the platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located in a concurrent mode, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the queried order information of any second inventory object.
Preferably, after creating a plurality of threads in the thread pool, the method further comprises: and acquiring a thread number threshold value, and controlling the number of concurrent threads in the thread pool through the thread number threshold value.
In this embodiment, in order to manage the inventory data of the platform where the accessed second inventory objects are located, the inventory data system sets a thread pool, creates a plurality of threads, and controls each thread to perform operations such as data query on the inventory data of the platform where the second inventory objects are located through the inventory interface of the platform where the second inventory objects are located in a concurrent manner. Therefore, the data management efficiency of the inventory data of the platform where the accessed second inventory objects are located can be improved. Furthermore, a thread number threshold value is set, and the number of concurrent threads in the thread pool is controlled through the thread number threshold value, so that the performance and the stability of the inventory data system can be ensured.
In one embodiment, the first inventory object includes a merchandising store, the inventory data of the first inventory object includes the quantity and amount of inventory of the merchandising store, and the monitoring parameters include a real-time inventory amount, a real-time inventory fulfillment rate, a stock plan fulfillment rate, a specified merchandising inventory amount, a joint sampling merchandising inventory amount, a spot inventory amount or a pre-sale inventory amount. The data statistical mode of the real-time inventory amount is determined according to the product of the sum of the commodity quantity of the inventory commodity and the commodity store indicated in the inventory statistical task; the data statistics mode of the real-time inventory satisfaction rate is determined according to the sum of the inventory commodities in the commodity store, a first preset target sum and a preset early warning coefficient; determining the data statistics mode of the stock plan satisfaction rate according to the sum of the inventory commodities of the commodity store with the preset inventory and a second preset target sum; the data statistical mode of the commodity inventory amount is determined according to the product of the sum of the commodity quantity of the specified commodity and the commodity price of the specified commodity; the data statistical mode of the jointly collected inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the jointly collected inventory commodities and the commodity price of the jointly collected inventory commodities; the data statistical mode of the spot stock money is determined according to the product of the sum of the commodity quantity of the existing stock commodities and the commodity price of the existing stock commodities; the data statistics of the pre-sold inventory amount is determined according to the product of the sum of the product quantities of the pre-sold inventory items and the product of the product price of the pre-sold inventory items.
In this embodiment, referring to fig. 7, the monitoring parameters include a real-time inventory amount, a real-time inventory fulfillment rate, a stock plan fulfillment rate, a specified merchandise inventory amount, a joint acquisition merchandise inventory amount, a spot inventory amount, or a pre-sale inventory amount. The data statistical method is as follows:
real-time inventory amount = commodity activity price (store a real-time inventory + store B real-time inventory);
the real-time inventory satisfaction rate = real-time inventory amount/(task target amount x warning coefficient);
stock plan satisfaction = stock inventory amount/task target amount;
core merchandise inventory amount = core merchandise activity price (store a real-time inventory + store B real-time inventory);
the combined acquisition commodity inventory amount = combined acquisition commodity activity price (store a real-time inventory + store B real-time inventory);
spot inventory amount = spot commodity activity price (store a real-time inventory + store B real-time inventory);
pre-sale inventory amount = pre-sale item activity price (store a real-time inventory + store B real-time inventory).
Specifically, the specified item inventory amount may be a core item inventory amount. The commercial store includes store a and store B. The real-time stock of the store a or the store B refers to the quantity of stock items in the store, and the item activity price refers to the amount of money of the stock items. The task target amount is a preset target amount. Therefore, the analysis module of the inventory data system can calculate the corresponding parameter values through the specific data statistical mode of each monitoring parameter, and further can perform data monitoring on the commodity quantity and the money amount of the inventory commodities of the plurality of commodity stores according to the parameter values.
Preferably, as shown in fig. 7, the multiple monitoring dimensions include a single item dimension, a category dimension, and a brand dimension, the inventory data of the first inventory object corresponding to the monitoring parameters of the single item dimension includes the commodity amount and the amount of a single commodity, the inventory data of the first inventory object corresponding to the monitoring parameters of the category dimension includes the commodity amount and the amount of a plurality of commodities of the same category, and the inventory data of the first inventory object corresponding to the monitoring parameters of the brand dimension includes the commodity amount and the amount of a plurality of commodities of the same category.
Therefore, the data monitoring of commodity data of the commodity store with multiple dimensions and multiple monitoring parameters can be realized.
In an embodiment, after S108, the method further includes: acquiring a monitoring result of data monitoring; performing early warning management on the monitoring result according to preset rule information; or generating early warning information according to the monitoring result, calling an interface of the external platform, and sending the early warning information to the external platform through the interface of the external platform. Or receiving external alarm information, and performing corresponding alarm according to the external alarm information.
In this embodiment, the inventory data system provides an early warning module. And the early warning module receives external warning information of an external system and carries out corresponding warning in the operation process. Such as notification messages of the mail system, etc. For the scene of sending the external message, the external platform is also required to be called to carry out notification of corresponding operation. And calling an interface of the external platform, and sending early warning information to the external platform through the interface of the external platform. For example, the inventory center is informed to allocate the replenishment inventory. The early warning module can also carry out early warning on the data of the monitoring result according to a set specified frequency and a specified rule, for example, the information that the daily inventory does not reach the standard is sent to a responsible person according to the class dimension for early warning. Therefore, the system for monitoring the inventory data can be improved, and the efficiency of monitoring the inventory data is improved.
A specific implementation scenario is given below to explain a specific implementation process of the inventory data monitoring method in the present application in implementing multidimensional inventory data monitoring:
in the implementation scenario, the inventory data monitoring method is used for solving the problems that when an enterprise operates on multiple platforms, an inventory unified management and control process among multiple shops is complex, workload is large, and sales loss caused by insufficient inventory is easy to generate or inventory turnover is reduced.
The application discloses real-time automatic inventory monitoring of background development establishes inventory data system, issues inventory allocation work order through warning the propelling movement mode in time intelligence to and in time feed back the data of lacking in stock, it is long to shorten the feedback of lacking in stock, reduces shop's overfall risk, reduces the harm that the burden was brought, improves the utilization ratio of stock turnover, realizes the digitization and the control management of multidimension degree of many shops inventory data.
Specifically, the system architecture of the background is shown in fig. 8, and the flowchart of the inventory data monitoring method is shown in fig. 9. The specific process flow is as follows:
(1) The user inputs configuration information on the front-end UI interface, and a configuration module of the system configures corresponding parameters. Where approval confirmation can be made for sensitive configurations.
(2) A monitoring module of the system monitors the inventory change in real time to update the inventory data. Specifically, order placing information is monitored in real time, and when the order state is changed into a state that stock needs to be deducted, for example, two scenes of order placing deduction and payment deduction are called, and a stock cleaning module is called to deduct existing stock information. In the operation process, the monitoring module regularly inquires the inventory interface of the platform where each shop is located to inquire and informs the inventory cleaning module to correct. For example, when the interface data is obviously smaller than the deduction data, correction updating is carried out on the stock data. In addition, the monitoring module monitors the behavior of adding or transferring the inventory or receives corresponding response information by the external platform and informs the inventory cleaning module to carry out corresponding operation. In the monitoring module, for inventory margins of different stores in different inventory modes, an alarm module is called according to configured threshold rules to carry out corresponding alarm.
(3) And the inventory cleaning module calls an interface of the corresponding platform to perform inventory query according to the inventory query range defined in the configuration module at regular time, and performs incremental inventory initialization according to the specified dimensionality. In daily operation, corresponding deduction and increase are carried out on the specified stock in response to the change information notified by the external module.
(4) The analysis module carries out multi-shop and multi-dimensional summarization and calculation on the single-item inventory information in the inventory cleaning module according to the designated frequency, forms a multi-shop data report for operation analysis, and carries out trend analysis on the inventory of the shops according to different inventory modes. Such as margin prediction, back-thrust prediction, turnaround prediction, etc. The analysis module also provides corresponding page functions for inquiring and exporting.
(5) And the early warning module pushes early warning information according to a specified rule. And the early warning module receives the warning information notified from the outside to carry out corresponding warning in the operation process. Such as mail notification, sending notification external messages, etc. For the scene of sending the external message, the external platform is also required to be called to carry out notification of corresponding operation. Such as notifying the inventory center to make a replenishment inventory. The module can also pre-warn data retained by external modules such as an analysis module or a monitoring module according to the set specified frequency according to specified rules, for example, daily substandard information of inventory is sent to a responsible person for pre-warning according to the class dimension.
A timing chart of inventory statistics of a background system architecture when implementing an inventory data monitoring method of the present application is shown in fig. 10. In conjunction with the inventory statistics timing diagram shown in fig. 10, a specific implementation scenario is given as follows:
aiming at different platform shops, operators set information such as a large promotion target amount, a category inventory, an early warning configuration and the like, manually trigger an inventory updating button, and automatically perform multi-dimensional inventory statistics and display by a background asynchronous task. And meanwhile, the early warning configuration is automatically detected, the alarm is given to the unqualified inventory item, and corresponding personnel are informed to carry out the timely stock preparation treatment.
Scene one: the preset design of the commodity is greatly promoted to monitor the inventory information.
The related operation and maintenance personnel decompose the promotion task into various categories and departments according to the target of the promotion activity. Meanwhile, the promotion target and different shop commodities needing to be monitored are led into the background in batches, and an early warning threshold value is set according to the promotion requirement. The background system can automatically monitor the inventory information of the imported commodities and generate a monitoring report according to single item/brand/class multi-dimension. Meanwhile, the inventory condition can be judged according to the early warning threshold value. And timely pushing alarm information for the unsatisfied commodities and issuing a dispatching work order according to an inventory dispatching formula. The reasonable stock promotes the sales of the enterprise.
Scene two: and the inventory operation is updated, and the performance and the stability of the system are ensured.
And the stock is updated by adopting asynchronous operation, so that other operations of business personnel are not influenced. The background controls the number of concurrent threads to ensure the performance and stability of the system in a thread pool mode.
Therefore, the multi-store inventory monitoring is realized, and the automation and multi-dimensional statistics of the multi-store inventory information are realized. Meanwhile, intelligent inventory allocation is supported. The early warning strategy is flexible and configurable, and early warning configuration of promotion activities of different levels is met.
It should be understood that, although the steps in the flowchart are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not limited to being performed in the exact order illustrated and, unless explicitly stated herein, may be performed in other orders. Moreover, at least some of the steps in the figures may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least some of the sub-steps or stages of other steps.
The present application further provides an inventory data monitoring apparatus, as shown in fig. 11, which includes a first generation module 12, a determination module 14, an acquisition module 16, and a monitoring module 18. The generating module 12 is configured to receive the monitoring configuration information, and generate an inventory statistics task according to the monitoring configuration information; a determination module 14 for determining one or more monitoring dimensions in an inventory statistics task; an obtaining module 16, configured to obtain a monitoring parameter of each monitoring dimension and a data statistics manner of the monitoring parameter; and the monitoring module 18 is configured to determine a first inventory object corresponding to the monitoring parameter, count the inventory data of the first inventory object according to a data statistics manner, and perform data monitoring on a statistical result.
In one embodiment, the inventory data monitoring device may include a listening module for receiving and storing inventory data of the imported plurality of second inventory objects; monitoring order information of a plurality of second inventory objects, and modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when the monitored order information of any second inventory object causes the inventory data of any second inventory object to change. The monitoring module 18 is specifically configured to determine a first inventory object from the plurality of second inventory objects, obtain the stored inventory data of the first inventory object, and count the inventory data of the first inventory object according to a data statistics manner.
In one embodiment, when monitoring that the order information of any second inventory object causes the stock data of any second inventory object to change, modifying the stock data of any second inventory object stored according to the order information of any second inventory object includes: and when the fact that the stock data of any second stock object needs to be reduced or increased due to the fact that the order information of any second stock object is monitored, the stored stock data of any second stock object is modified according to the reduction information or the increase information in the order information of any second stock object.
In one embodiment, monitoring order information of a plurality of second inventory objects, and when it is monitored that the order information of any second inventory object causes stock data of any second inventory object to change, modifying the stored stock data of any second inventory object according to the order information of any second inventory object comprises: performing data query on inventory data of a platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the query of the order information of any second inventory object; and the platform where any second stock object is located updates the stock data of any second stock object according to the order information.
In one embodiment, the inventory data monitoring apparatus may include a setting module configured to set a thread pool in which a plurality of threads are created; and controlling each thread to execute data query on the inventory data of the platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located in a concurrent mode, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the queried order information of any second inventory object.
In one embodiment, the inventory data monitoring device may include a control module configured to obtain a thread count threshold, and control the number of concurrent threads in the thread pool by the thread count threshold.
In one embodiment, the first inventory object comprises a commodity store, the inventory data of the first inventory object comprises the commodity amount and the amount of the inventory commodities of the commodity store, and the monitoring parameters comprise a real-time inventory amount, a real-time inventory satisfaction rate, a stock plan satisfaction rate, a specified commodity inventory amount, a joint collected commodity inventory amount, a spot inventory amount or a pre-sale inventory amount; the data statistical mode of the real-time inventory money is determined according to the product of the accumulated sum of the commodity quantity of the inventory commodity and the commodity store indicated in the inventory statistical task; the real-time inventory satisfaction rate data statistics mode is determined according to the sum of the inventory commodities of the commodity store, a first preset target sum and a preset early warning coefficient; the data statistics mode of the stock plan satisfaction rate is determined according to the sum of the inventory commodities in the commodity store with the preset inventory and a second preset target sum; the data statistical mode of the inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the specified commodity and the commodity price of the specified commodity; the data statistical mode of the jointly collected inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the jointly collected inventory commodities and the commodity price of the jointly collected inventory commodities; the data statistical mode of the spot inventory amount is determined according to the product of the sum of the commodity amount of the existing inventory commodity and the commodity price of the existing inventory commodity; the data statistics mode of the pre-sale inventory amount is determined according to the product of the sum of the commodity quantity of the pre-sale inventory commodity and the commodity price of the pre-sale inventory commodity.
In one embodiment, the multiple monitoring dimensions include a single item dimension, a category dimension, and a brand dimension, the inventory data of the first inventory object corresponding to the monitoring parameters of the single item dimension includes the commodity amount and the amount of money of a single commodity, the inventory data of the first inventory object corresponding to the monitoring parameters of the category dimension includes the commodity amount and the amount of money of multiple commodities of the same category, and the inventory data of the first inventory object corresponding to the monitoring parameters of the brand dimension includes the commodity amount and the amount of money of multiple commodities of multiple categories of the same brand.
In one embodiment, the inventory data monitoring device may include an early warning module for obtaining a monitoring result of data monitoring; and carrying out early warning management on the monitoring result according to the preset rule information. Or the monitoring device is used for generating early warning information according to the monitoring result, calling an interface of the external platform and sending the early warning information to the external platform through the interface of the external platform. Or, the alarm device is used for receiving external alarm information and performing corresponding alarm according to the external alarm information.
For specific limitations of the inventory data monitoring device, reference may be made to the above limitations of the inventory data monitoring method, which are not described herein again. The modules in the inventory data monitoring device may be implemented in whole or in part by software, hardware, and combinations thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, and the computer device may be a server supporting background operation, and the internal structure diagram of the computer device may be as shown in fig. 12. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operating system and the computer program to run on the non-volatile storage medium. The network interface of the computer device is used for connecting with an external terminal to read interface element information on the terminal. The computer program when executed by a processor implements a method of inventory data monitoring.
Those skilled in the art will appreciate that the architecture shown in fig. 12 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: receiving monitoring configuration information, and generating an inventory counting task according to the monitoring configuration information; determining one or more monitoring dimensions in an inventory statistics task; acquiring monitoring parameters of each monitoring dimension and a data statistical mode of the monitoring parameters; and determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to a data counting mode, and performing data monitoring on a counting result.
In one embodiment, the processor, when executing the computer program, further performs the steps of: receiving and storing inventory data of a plurality of imported second inventory objects; monitoring order information of a plurality of second inventory objects, and modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when the monitored order information of any second inventory object causes the inventory data of any second inventory object to change. The processor executes the computer program to realize the first inventory object corresponding to the determined monitoring parameter, and when the step of counting the inventory data of the first inventory object according to the data counting mode is carried out, the following steps are specifically realized: and determining a first inventory object from the plurality of second inventory objects, acquiring the stored inventory data of the first inventory object, and counting the inventory data of the first inventory object according to a data counting mode.
In one embodiment, the processor executes the computer program to implement the above step of modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when it is detected that the order information of any second inventory object causes a change in the inventory data of any second inventory object, and specifically implements the following steps: and when the fact that the stock data of any second stock object needs to be reduced or increased due to the fact that the order information of any second stock object is monitored, the stored stock data of any second stock object is modified according to the reduction information or the increase information in the order information of any second stock object.
In one embodiment, the processor executes a computer program to implement the above-mentioned step of monitoring the order information of a plurality of second inventory objects, and when it is detected that the order information of any one of the second inventory objects causes a change in the inventory data of any one of the second inventory objects, the step of modifying the inventory data of any one of the second inventory objects according to the order information of any one of the second inventory objects specifically implements the following steps: performing data query on the inventory data of the platform where the second inventory objects are located through the inventory interface of the platform where the second inventory objects are located, and when the query result shows that the inventory data of the platform where the second inventory objects are located changes, modifying the stored inventory data of the second inventory objects according to the updated inventory data of the platform where the second inventory objects are located; and the platform where any second stock object is located updates the stock data of any second stock object according to the order information.
In one embodiment, the processor when executing the computer program further performs the steps of: setting a thread pool, and creating a plurality of threads in the thread pool; and controlling each thread to execute data query on the inventory data of the platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located in a concurrent mode, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the queried order information of any second inventory object.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and acquiring a thread number threshold value, and controlling the number of concurrent threads in the thread pool through the thread number threshold value.
In one embodiment, the first inventory object comprises a commodity store, the inventory data of the first inventory object comprises the commodity amount and the amount of the inventory commodities of the commodity store, and the monitoring parameters comprise a real-time inventory amount, a real-time inventory satisfaction rate, a stock plan satisfaction rate, a specified commodity inventory amount, a joint collected commodity inventory amount, a spot inventory amount or a pre-sale inventory amount; the real-time inventory amount data statistical mode is determined according to the product of the sum of the accumulated commodity amount of the inventory commodities and the commodity store indicated in the inventory statistical task; the data statistics mode of the real-time inventory satisfaction rate is determined according to the sum of the inventory commodities in the commodity store, a first preset target sum and a preset early warning coefficient; the data statistics mode of the stock plan satisfaction rate is determined according to the sum of the inventory commodities in the commodity store with the preset inventory and a second preset target sum; the data statistical mode of the commodity inventory amount is determined according to the product of the sum of the commodity quantity of the specified commodity and the commodity price of the specified commodity; the data statistical mode of the jointly collected commodity inventory amount is determined according to the product of the sum of the commodity amount of the jointly collected inventory commodities and the commodity price of the jointly collected inventory commodities; the data statistical mode of the spot inventory amount is determined according to the product of the sum of the commodity amount of the existing inventory commodity and the commodity price of the existing inventory commodity; the data statistics mode of the pre-sale inventory amount is determined according to the product of the sum of the commodity quantity of the pre-sale inventory commodity and the commodity price of the pre-sale inventory commodity.
In one embodiment, the plurality of monitoring dimensions include a single item dimension, a category dimension and a brand dimension, the inventory data of the first inventory object corresponding to the monitoring parameters of the single item dimension includes the commodity amount and the money amount of a single commodity, the inventory data of the first inventory object corresponding to the monitoring parameters of the category dimension includes the commodity amount and the money amount of a plurality of commodities of the same category, and the inventory data of the first inventory object corresponding to the monitoring parameters of the brand dimension includes the commodity amount and the money amount of a plurality of commodities of the plurality of categories of the same brand.
In one embodiment, the processor when executing the computer program further performs the steps of: fetching a monitoring result of data monitoring; performing early warning management on the monitoring result according to preset rule information; or generating early warning information according to the monitoring result, calling an interface of the external platform, and sending the early warning information to the external platform through the interface of the external platform.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and receiving external alarm information, and performing corresponding alarm according to the external alarm information.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: receiving monitoring configuration information, and generating an inventory counting task according to the monitoring configuration information; determining one or more monitoring dimensions in an inventory statistics task; acquiring monitoring parameters of each monitoring dimension and a data statistical mode of the monitoring parameters; and determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to a data counting mode, and performing data monitoring on a counting result.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving and storing inventory data of the imported plurality of second inventory objects; monitoring the order information of a plurality of second stock objects, and modifying the stored stock data of any second stock object according to the order information of any second stock object when the monitored order information of any second stock object causes the stock data of any second stock object to change. When the computer program is executed by the processor to implement the first inventory object corresponding to the determined monitoring parameter, and the step of counting the inventory data of the first inventory object according to the data counting mode is implemented, the following steps are implemented: and determining a first inventory object from the plurality of second inventory objects, acquiring the stored inventory data of the first inventory object, and counting the inventory data of the first inventory object according to a data counting mode.
In one embodiment, when the computer program is executed by the processor to implement the step of modifying the stored inventory data of any second inventory object according to the order information of any second inventory object when it is monitored that the order information of any second inventory object causes a change in the inventory data of any second inventory object, the following steps are specifically implemented: and when the fact that the stock data of any second stock object needs to be reduced or increased due to the fact that the order information of any second stock object is monitored, the stored stock data of any second stock object is modified according to the reduction information or the increase information in the order information of any second stock object.
In one embodiment, the computer program is executed by the processor to implement the above-mentioned step of monitoring the order information of a plurality of second inventory objects, and when it is detected that the order information of any one of the second inventory objects causes a change in the inventory data of any one of the second inventory objects, the step of modifying the inventory data of any one of the second inventory objects according to the order information of any one of the second inventory objects specifically implements the following steps: performing data query on inventory data of a platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the query of the order information of any second inventory object; and the platform where any second stock object is located updates the stock data of any second stock object according to the order information.
In one embodiment, the computer program when executed by the processor further performs the steps of: setting a thread pool, and creating a plurality of threads in the thread pool; and controlling each thread to execute data query on the inventory data of the platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located in a concurrent mode, and modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located when the inventory data of the platform where any second inventory object is located is changed due to the queried order information of any second inventory object.
In one embodiment, the computer program when executed by the processor further performs the steps of: and acquiring a thread number threshold, and controlling the number of concurrent threads in the thread pool through the thread number threshold.
In one embodiment, the first stock object comprises a commodity store, the stock data of the first stock object comprises the commodity amount and the amount of the stock commodities of the commodity store, and the monitoring parameters comprise a real-time stock amount, a real-time stock satisfaction rate, a stock plan satisfaction rate, a specified commodity stock amount, a joint-collected commodity stock amount, a spot stock amount or a pre-sale stock amount; the data statistical mode of the real-time inventory money is determined according to the product of the accumulated sum of the commodity quantity of the inventory commodity and the commodity store indicated in the inventory statistical task; the data statistics mode of the real-time inventory satisfaction rate is determined according to the sum of the inventory commodities in the commodity store, a first preset target sum and a preset early warning coefficient; the data statistics mode of the stock plan satisfaction rate is determined according to the sum of the inventory commodities in the commodity store with the preset inventory and a second preset target sum; the data statistical mode of the inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the specified commodity and the commodity price of the specified commodity; the data statistical mode of the jointly collected inventory amount of the commodities is determined according to the product of the sum of the commodity amount of the jointly collected inventory commodities and the commodity price of the jointly collected inventory commodities; the data statistical mode of the spot stock money is determined according to the product of the sum of the commodity quantity of the existing stock commodities and the commodity price of the existing stock commodities; the data statistics mode of the pre-sale inventory amount is determined according to the product of the sum of the commodity quantity of the pre-sale inventory commodity and the commodity price of the pre-sale inventory commodity.
In one embodiment, the plurality of monitoring dimensions include a single item dimension, a category dimension and a brand dimension, the inventory data of the first inventory object corresponding to the monitoring parameters of the single item dimension includes the commodity amount and the money amount of a single commodity, the inventory data of the first inventory object corresponding to the monitoring parameters of the category dimension includes the commodity amount and the money amount of a plurality of commodities of the same category, and the inventory data of the first inventory object corresponding to the monitoring parameters of the brand dimension includes the commodity amount and the money amount of a plurality of commodities of the plurality of categories of the same brand.
In one embodiment, the computer program when executed by the processor further performs the steps of: fetching a monitoring result of data monitoring; performing early warning management on the monitoring result according to preset rule information; or generating early warning information according to the monitoring result, calling an interface of an external platform, and sending the early warning information to the external platform through the interface of the external platform.
In one embodiment, the computer program when executed by the processor further performs the steps of: and receiving external alarm information, and performing corresponding alarm according to the external alarm information.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
All possible combinations of the technical features in the above embodiments may not be described for the sake of brevity, but should be considered as being within the scope of the present disclosure as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent application shall be subject to the appended claims.

Claims (10)

1. A method of inventory data monitoring, the method comprising:
receiving monitoring configuration information, and generating an inventory counting task according to the monitoring configuration information;
determining one or more monitoring dimensions in the inventory statistics task;
acquiring monitoring parameters of each monitoring dimension and a data statistical mode of the monitoring parameters;
determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to the data counting mode, and performing data monitoring on the counting result;
the method further comprises the following steps:
receiving and storing inventory data of the imported plurality of second inventory objects;
monitoring the order information of the plurality of second stock objects, and modifying the stored stock data of any second stock object according to the order information of any second stock object when the monitored order information of any second stock object causes the stock data of any second stock object to change;
the determining the first inventory object corresponding to the monitoring parameter and counting the inventory data of the first inventory object according to the data counting mode includes:
determining the first inventory object from the plurality of second inventory objects, acquiring stored inventory data of the first inventory object, and counting the inventory data of the first inventory object according to the data statistical mode;
wherein the monitoring the order information of the plurality of second inventory objects, and when the monitoring of the order information of any second inventory object causes a change in the inventory data of any second inventory object, modifying the stored inventory data of any second inventory object according to the order information of any second inventory object, comprises:
performing data query on the inventory data of the platform where the second inventory objects are located through the inventory interface of the platform where the second inventory objects are located, and when the query result shows that the inventory data of the platform where the second inventory objects are located changes, modifying the stored inventory data of the second inventory objects according to the updated inventory data of the platform where the second inventory objects are located; and updating the stock data of any second stock object according to the order information by the platform where any second stock object is located.
2. The method of claim 1, wherein modifying the stored inventory data of any second inventory object based on the order information of the any second inventory object when it is monitored that the order information of the any second inventory object causes a change in the inventory data of the any second inventory object comprises:
and when monitoring that the order information of any second inventory object causes the inventory data of any second inventory object to be reduced or increased, modifying the stored inventory data of any second inventory object according to the reduction information or the increase information in the order information of any second inventory object.
3. The method of claim 1, further comprising:
setting a thread pool, and creating a plurality of threads in the thread pool;
and controlling each thread to execute data query on the inventory data of the platform where each second inventory object is located through an inventory interface of the platform where each second inventory object is located in a concurrent mode, and when the query result shows that the inventory data of the platform where any second inventory object is located changes according to the order information of any second inventory object, modifying the stored inventory data of any second inventory object according to the updated inventory data of the platform where any second inventory object is located.
4. The method of claim 3, further comprising:
and acquiring a thread number threshold value, and controlling the number of concurrent threads in the thread pool through the thread number threshold value.
5. The method of claim 1, wherein the first inventory object comprises a merchandising store, the inventory data of the first inventory object comprises a quantity and an amount of inventory items of the merchandising store, and the monitoring parameters comprise a real-time inventory amount, a real-time inventory fulfillment rate, a stock plan fulfillment rate, a specified merchandising inventory amount, a joint procurement merchandising inventory amount, a spot inventory amount, or a pre-sale inventory amount;
the data statistical mode of the real-time inventory amount is determined according to the product of the sum of the commodity amount of the inventory commodity and the commodity price of the commodity;
the data statistical mode of the real-time inventory satisfaction rate is determined according to the sum of the inventory commodities in the commodity store, a first preset target sum and a preset early warning coefficient;
the data statistics mode of the stock plan satisfaction rate is determined according to the sum of the inventory commodities of the preset inventory commodity store and a second preset target sum;
the data statistical mode of the inventory amount of the specified commodity is determined according to the product of the sum of the commodity amount of the specified commodity and the commodity price of the specified commodity;
the data statistical mode of the jointly collected commodity inventory amount is determined according to the product of the sum of the commodity amount of the jointly collected inventory commodity and the commodity price of the jointly collected inventory commodity;
the data statistical mode of the spot inventory amount is determined according to the product of the sum of the commodity amount of the existing inventory commodity and the commodity price of the existing inventory commodity;
the data statistics mode of the pre-sale inventory amount is determined according to the product of the sum of the accumulated commodity amount of the pre-sale inventory commodity and the commodity price of the pre-sale inventory commodity.
6. The method of claim 5, wherein the plurality of monitoring dimensions include a singleton dimension, a category dimension, and a brand dimension, the inventory data of the first inventory object corresponding to the monitoring parameters of the singleton dimension includes an amount of a single item and an amount of money, the inventory data of the first inventory object corresponding to the monitoring parameters of the category dimension includes an amount of a plurality of items of the same category and an amount of money, and the inventory data of the first inventory object corresponding to the monitoring parameters of the brand dimension includes an amount of a plurality of items of the same brand and an amount of money.
7. The method of claim 1, further comprising:
acquiring a monitoring result of data monitoring;
performing early warning management on the monitoring result according to preset rule information; or the like, or, alternatively,
generating early warning information according to the monitoring result, calling an interface of an external platform, and sending the early warning information to the external platform through the interface of the external platform;
the method further comprises the following steps:
and receiving external alarm information, and performing corresponding alarm according to the external alarm information.
8. An apparatus for implementing the inventory data monitoring method of claim 1, the apparatus comprising:
the generating module is used for receiving the monitoring configuration information and generating an inventory counting task according to the monitoring configuration information;
a determination module to determine one or more monitoring dimensions in the inventory statistics task;
the acquisition module is used for acquiring monitoring parameters of all monitoring dimensions and data statistics modes of the monitoring parameters;
and the monitoring module is used for determining a first inventory object corresponding to the monitoring parameters, counting the inventory data of the first inventory object according to the data counting mode and monitoring the data of the counting result.
9. A computer arrangement comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
CN202011256906.1A 2020-11-11 2020-11-11 Inventory data monitoring method and device, computer equipment and storage medium Active CN112380187B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN202011256906.1A CN112380187B (en) 2020-11-11 2020-11-11 Inventory data monitoring method and device, computer equipment and storage medium
CA3138753A CA3138753A1 (en) 2020-11-11 2021-11-12 Method of and device for monitoring inventory data, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011256906.1A CN112380187B (en) 2020-11-11 2020-11-11 Inventory data monitoring method and device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN112380187A CN112380187A (en) 2021-02-19
CN112380187B true CN112380187B (en) 2022-11-15

Family

ID=74582939

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011256906.1A Active CN112380187B (en) 2020-11-11 2020-11-11 Inventory data monitoring method and device, computer equipment and storage medium

Country Status (2)

Country Link
CN (1) CN112380187B (en)
CA (1) CA3138753A1 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113128932B (en) * 2021-04-16 2024-04-16 北京京东振世信息技术有限公司 Warehouse stock processing method and device, storage medium and electronic equipment
CN114817278A (en) * 2022-01-14 2022-07-29 百芯智能制造科技(深圳)有限公司 Electronic component SKU data updating method and updating device and electronic equipment
CN114677172B (en) * 2022-03-22 2022-12-13 北京网鲜供应链科技有限公司 Give birth to bright unusual moving early warning system

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105096015B (en) * 2014-04-23 2021-01-08 菜鸟智能物流控股有限公司 Commodity object information processing method and system
CN107705056A (en) * 2016-08-09 2018-02-16 菜鸟智能物流控股有限公司 Inventory state monitoring method and device, server and client
CN111221834B (en) * 2019-12-30 2023-08-25 深圳闽星科技有限公司 Commodity inventory value calculation method

Also Published As

Publication number Publication date
CN112380187A (en) 2021-02-19
CA3138753A1 (en) 2022-05-11

Similar Documents

Publication Publication Date Title
CN112380187B (en) Inventory data monitoring method and device, computer equipment and storage medium
US7657453B2 (en) System, computer-readable medium and method for filtering exceptions generated by forecasting and replenishment engine
EP1695282B1 (en) Data processing system and method
CN108780466A (en) Search for calculating near real-time data aggregation and retrieval data processing system
CN110276495A (en) Commercial articles ordering method, apparatus, computer and storage medium based on artificial intelligence
WO2021216167A1 (en) Auto clustering prediction models
US20160283881A1 (en) System and method for forecast driven replenishment of merchandise
CN110807596A (en) Cross-border e-commerce consignment warehouse storage management system and method
CN111352945A (en) Inventory supply chain management system, method, device, equipment and medium
CN110766520A (en) Multi-system multi-shop order fusion method and device, computer equipment and storage medium
CN114118503A (en) Supply chain inventory optimization method, device, equipment and storage medium
CN112053168A (en) Material monitoring method and device, electronic equipment and storage medium
CN111985862A (en) Method and apparatus for locating inventory items
CN112036631A (en) Purchasing quantity determination method, device, equipment and storage medium
US20170193435A1 (en) Systems and methods for forecasting on-shelf product availability
CN116562715B (en) Index data monitoring method, device, computer equipment and storage medium
CN112801591A (en) Method, system, terminal and storage medium for managing low-value consumable
CN112561440A (en) Delivery management method and management device
US20130041789A1 (en) Production cost analysis system
CN115630861A (en) Quality inspection strategy self-adaptive adjusting method, device and storage medium
CN115759924A (en) Order matching and follow-up system and method thereof
CN114091770A (en) Prediction analysis method, device, equipment and storage medium for material demand plan
CN114819790A (en) Intelligent store replenishment method and system based on big data
CN112116427A (en) Commodity recommendation method and device, electronic equipment and storage medium
CN113139835A (en) Data processing method, data processing device, nonvolatile storage medium and processor

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant