CN110322192A - Account checking method and system for the physical holding of stock of electric business platform and logic inventory - Google Patents
Account checking method and system for the physical holding of stock of electric business platform and logic inventory Download PDFInfo
- Publication number
- CN110322192A CN110322192A CN201910461464.5A CN201910461464A CN110322192A CN 110322192 A CN110322192 A CN 110322192A CN 201910461464 A CN201910461464 A CN 201910461464A CN 110322192 A CN110322192 A CN 110322192A
- Authority
- CN
- China
- Prior art keywords
- inventory
- day
- physical
- logical
- data
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000006243 chemical reaction Methods 0.000 claims abstract description 21
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 42
- 239000000463 material Substances 0.000 claims description 17
- 238000004364 calculation method Methods 0.000 claims description 8
- 230000003203 everyday effect Effects 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 6
- 238000004458 analytical method Methods 0.000 claims description 4
- 238000013075 data extraction Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 2
- 241001269238 Data Species 0.000 abstract 3
- 238000009825 accumulation Methods 0.000 abstract 2
- 238000000151 deposition Methods 0.000 abstract 1
- 230000006870 function Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000002354 daily effect Effects 0.000 description 3
- 238000006467 substitution reaction Methods 0.000 description 2
- 101100490479 Lactococcus lactis subsp. lactis (strain IL1403) addA gene Proteins 0.000 description 1
- 101100000975 Lactococcus lactis subsp. lactis (strain IL1403) rexB gene Proteins 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention discloses a kind of account checking method and system for the physical holding of stock of electric business platform and logic inventory, is related to inventory data processing technology field, by periodically depositing into row reconciliation to physical holding of stock and logical base, can timely find inventory's error and early warning.This method comprises: physical holding of stock snapshot and logic inventory's snapshot were transferred respectively the T days zero point moment, as initial inventory data；The day increment of physical holding of stock and the day increment of logic inventory on the day before obtaining at the T+1 days zero point moment；The day increment accumulation of physical holding of stock snapshot and physical holding of stock is obtained into the T+1 days physical holding of stock primary datas, and the day increment accumulation of logic inventory snapshot and logic inventory are obtained into the T+1 days logic inventory's primary datas；Physical holding of stock primary data and the T+1 days logic inventory's primary datas to the T+1 days do reconciliation after the data conversion of same dimension, and export reconciliation result；The system includes the method that above scheme is mentioned.
Description
Technical Field
The invention relates to the technical field of inventory data processing, in particular to a reconciliation method for physical inventory and logical inventory.
Background
Along with the popularization of electronic commerce, more and more users are used to online shopping, when a user clicks to purchase a commodity to generate an order, the inventory quantity of the commodity is correspondingly reduced, for a small-sized e-commerce platform with a small daily order quantity, a traditional relational database is selected for storing and managing acquisition and sales data of the commodity due to cost consideration, for a large-sized e-commerce platform, as daily inventory flow can reach million-level business volume, if the account of the traditional relational database cannot be filed, complete inventory data cannot be acquired during accounting, and the like, the normal use requirement of the e-commerce platform on account function cannot be met, based on the above, the large-sized e-commerce platform gradually adopts a mode of separately managing the physical inventory and the logical inventory, namely, the physical inventory system and the logical inventory system are adopted to manage the inventory data of the commodity in an interactive mode, the physical inventory is mainly embodied in the aspects of receiving and dispatching goods in logistics operation and used for carrying out fine management on goods, such as recording of bin shelves and inventory quantity of goods, the logical inventory is mainly embodied in an account of an e-commerce platform and used for recording of a storage center and inventory quantity of goods, in order to enable the e-commerce platform to stably operate, the statistical error of the physical inventory and the logical inventory needs to be set within a reasonable range, regular account checking is a basic implementation mode for guaranteeing the reasonable error of the physical inventory and the logical inventory, and the accuracy of an account checking result is a necessary condition for ensuring the data consistency of a physical inventory system and a logical inventory system.
Disclosure of Invention
The invention aims to provide a reconciliation method and a reconciliation system for physical inventory and logical inventory of an e-commerce platform.
In order to achieve the above object, an aspect of the present invention provides a reconciliation method for physical inventory and logical inventory of an e-commerce platform, including:
step S1, respectively calling a real inventory snapshot and a logic inventory snapshot at the zero time of the T day as initial inventory data;
step S2, acquiring the running water of the physical stock and the running water of the logical stock of the previous day at the zero time of the T +1 th day, and respectively acquiring the day increment of the physical stock based on the running water of the physical stock and the day increment of the logical stock based on the running water of the logical stock;
step S3, accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain logical inventory initial data of the T +1 th day;
step S4, performing data conversion of the same dimension on the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day, and then checking accounts, and outputting a checking account result;
step S6, locking dimension information with difference in the real object inventory initial data and the logic inventory initial data of the T +1 th day based on the account checking result, and simultaneously outputting the difference data of the dimension information;
and step S7, automatically giving an alarm when the difference data is larger than the threshold value, and reminding a manager to check the inventory.
Preferably, the method further comprises the following steps:
in step S5, let T be T +1, and repeat steps S1 to S4 to obtain reconciliation results for multiple days.
Optionally, the method for acquiring the material inventory running water and the logic inventory running water of the previous day at the zero time of the T +1 th day includes:
at the zero time of the T +1 th day, correspondingly acquiring the material object inventory running water and the logic inventory running water of the previous day from the material object inventory system and the logic inventory system respectively by adopting a big data extraction mode; or,
and at the zero time of the T +1 th day, extracting the material inventory running water of the previous day issued by the material inventory system every day and extracting the logic inventory running water of the previous day issued by the logic inventory system every day.
Preferably, the method for accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain the physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain the logical inventory initial data of the T +1 th day includes:
accumulating the physical inventory snapshot and the day increment of the physical inventory by adopting a spark and MapReduce calculation engine to obtain physical inventory initial data of T +1 day; and the number of the first and second groups,
and accumulating the logical inventory snapshot and the day increment of the logical inventory by adopting spark and MapReduce calculation engines to obtain the initial data of the logical inventory at the T +1 th day.
Preferably, the physical inventory initial data, the logical inventory initial data, the day increment of the physical inventory and the day increment of the logical inventory are stored in a Hive data warehouse.
Specifically, the method for reconciling the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day after performing data conversion of the same dimension and outputting a reconciliation result comprises the following steps:
the physical inventory initial data comprises a commodity number, physical location information, physical inventory position information, goods master information and physical inventory quantity information in the T +1 th day, and the logic inventory initial data comprises the commodity number, logic location information, logic inventory position information, goods master information and logic inventory quantity information in the T +1 th day;
performing unified dimensional data conversion on the physical inventory initial data and the logical inventory initial data, wherein the dimensional information of the converted physical inventory initial data comprises a commodity number, city bin information, goods owner information and T +1 th day physical inventory quantity information, and the dimensional information of the converted logical inventory initial data comprises the commodity number, the city bin information, the goods owner information and the T +1 th day logical inventory quantity information;
the reconciliation result comprises a commodity number, city bin information, goods owner information, real object inventory quantity information of the T +1 th day, logic inventory quantity information of the T +1 th day and difference data.
Further, the difference data is stored in an elastic search full-text search engine in a date unit so as to support a screening query function of the difference data.
Compared with the prior art, the reconciliation method for the material object inventory and the logic inventory of the e-commerce platform has the following beneficial effects:
in the reconciliation method for the physical inventory and the logical inventory of the E-commerce platform, the physical inventory snapshot and the logical inventory snapshot corresponding to the zero time of a certain historical day, such as the T th day, are taken as initial inventory data, then the day increment of the physical inventory and the day increment of the logical inventory of the previous day are obtained at the zero time of the second day, namely the T +1 th day, the physical inventory initial data of the T +1 th day is obtained by accumulating the day increment of the physical inventory and the physical inventory snapshots, the logical inventory initial data of the T +1 th day is obtained by accumulating the day increment of the logical inventory and the logical inventory snapshots, and for convenience of comparison, the difference data of the physical inventory and the logical inventory in the T +1 th day can be rapidly identified after the data conversion of unified dimension is carried out on the logical inventory and automatic alarm is carried out when the difference data is greater than a threshold value, and timely informing related personnel to analyze and judge the error reason, searching the reason causing the difference between the physical inventory system and the logic inventory system, and ensuring the consistency of data between the systems.
Therefore, the method provided by the invention can be used for regularly and quickly identifying the difference data between the logical inventory and the physical inventory and reminding relevant personnel of analyzing and checking the inventory data in time in an alarming manner so as to avoid the situation that the e-commerce platform cannot stably run due to the inconsistency of the data between the physical inventory system and the logical inventory system.
Another aspect of the present invention provides an account checking system for physical inventory and logical inventory of an e-commerce platform, which is applied to the account checking method for physical inventory and logical inventory of an e-commerce platform in the foregoing technical solution, and the system includes:
the initialization unit is used for respectively calling a real inventory snapshot and a logic inventory snapshot at the zero time of the T day as initial inventory data;
the increment obtaining unit is used for obtaining the running water of the physical stock and the running water of the logical stock in the previous day at the zero time of the T +1 th day, and respectively obtaining the day increment of the physical stock based on the running water of the physical stock and the day increment of the logical stock based on the running water of the logical stock;
the calculating unit is used for accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain logical inventory initial data of the T +1 th day;
the dimension conversion unit is used for performing data conversion of the same dimension on the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day and then checking accounts and outputting a checking account result;
the analysis output unit is used for locking dimension information with difference in the real object inventory initial data and the logic inventory initial data of the T +1 th day based on the account checking result and outputting the difference data of the dimension information;
and the prompting unit is used for automatically giving an alarm when the difference data is larger than the threshold value, and reminding a manager to check the inventory.
Preferably, the method further comprises the following steps:
and the circulating unit is used for enabling T to be T +1 and responding to the initialization unit again to obtain the reconciliation result of multiple days.
Preferably, the method further comprises the following steps:
the query unit is used for storing the difference data in an elastic search full-text search engine by taking the date as a unit so as to support the screening query function of the difference data.
Compared with the prior art, the reconciliation system for the material object inventory and the logic inventory of the e-commerce platform has the same beneficial effect as the reconciliation method for the material object inventory and the logic inventory of the e-commerce platform provided by the technical scheme, and the detailed description is omitted.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention and not to limit the invention. In the drawings:
fig. 1 is a schematic flowchart of an account checking method for physical inventory and logical inventory of an e-commerce platform according to an embodiment of the present invention;
FIG. 2 is an exemplary diagram of a physical inventory snapshot and a logical inventory snapshot according to a first embodiment of the present invention;
FIG. 3 is an exemplary diagram of a physical inventory day increment and a logical inventory day increment according to an embodiment of the invention;
fig. 4 is an exemplary diagram of reconciliation results output after unified dimension conversion in the first embodiment of the present invention;
fig. 5 is a block diagram of a reconciliation system for physical inventory and logical inventory of an e-commerce platform according to a second embodiment of the present invention.
Reference numerals:
1-an initialization unit, 2-an increment acquisition unit;
3-a calculation unit, 4-a dimension conversion unit;
5-a circulation unit, 6-an analysis output unit;
7-a prompt unit.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in detail below. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example one
Referring to fig. 1, the present embodiment provides an account checking method for physical inventory and logical inventory of an e-commerce platform, including:
step S1, respectively calling a real inventory snapshot and a logic inventory snapshot at the zero time of the T day as initial inventory data; step S2, acquiring the running water of the physical stock and the running water of the logical stock of the previous day at the zero time of the T +1 th day, and respectively acquiring the day increment of the physical stock based on the running water of the physical stock and the day increment of the logical stock based on the running water of the logical stock; step S3, accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain the physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain the logical inventory initial data of the T +1 th day; step S4, performing unified dimensional data conversion on the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day, and then checking accounts, and outputting a checking account result; step S6, locking dimension information with difference in the real object inventory initial data and the logic inventory initial data of the T +1 th day based on the account checking result, and simultaneously outputting the difference data of the dimension information; and step S7, automatically giving an alarm when the difference data is larger than the threshold value, and reminding a manager to check the inventory.
In specific implementation, it is assumed that a real object inventory snapshot and a logical inventory snapshot obtained at zero time of day T are shown in fig. 2, a real object inventory streamline and a logical inventory streamline obtained at zero time of day T +1 are shown in fig. 3, where the positive number of the content in the voucher number column indicates the quantity of warehousing of the goods, the negative number of the content in the voucher number column indicates the quantity of selling and exporting the goods, L025 indicates that the real object location is south kyo, and L036 indicates that the real object location is tin-free, the data format obtained by accumulating the real object inventory snapshot and the real object inventory daily increment and performing unified dimension conversion is shown in fig. 4, and an account checking result is finally obtained, in this step, the real object location and the logical location are mainly converted into a city warehouse in a unified manner, and information useless for the account checking process such as the real object inventory location, the logical inventory warehousing voucher is deleted; therefore, the difference data between the real object inventory and the logic inventory in the T +1 th day can be obtained clearly according to the account checking result; in addition, it should be stated that, theoretically, the method can support comparison of difference data of any two adjacent days in history, but in practical use, considering the situation that document entry is prolonged or acquisition of stock flow data is delayed, comparison of data before two days of the query date is preferred.
In the reconciliation method for the physical inventory and the logical inventory of the e-commerce platform, by acquiring the physical inventory snapshot and the logical inventory snapshot corresponding to the zero time of a certain historical day, such as the T th day, as the initial inventory data, then acquiring the day increment of the physical inventory and the day increment of the logical inventory of the previous day at the zero time of the second day, i.e., the T +1 th day, accumulating the day increment of the physical inventory and the physical inventory snapshots to obtain the physical inventory initial data of the T +1 th day, and accumulating the day increment of the logical inventory and the logical inventory snapshots to obtain the logical inventory initial data of the T +1 th day, for convenience of comparison, the difference data between the physical inventory and the logical inventory in the T +1 th day can be rapidly identified after uniform-dimension data conversion is performed on the data, and an alarm is automatically given when the difference data is greater than a threshold value, and related personnel are timely informed to analyze and judge the error reason, the reason causing the difference between the physical inventory system and the logic inventory system is searched, the consistency of data between the systems is ensured, and the loss caused by over-selling or lost sales due to the inventory difference between the systems is timely avoided.
Therefore, the method provided by the embodiment can be used for regularly and quickly identifying the difference data between the logical inventory and the physical inventory, and reminding relevant personnel of analyzing and checking the inventory data in time in an alarming manner, so that the situation that the e-commerce platform cannot stably run due to the inconsistency of the data between the physical inventory system and the logical inventory system is avoided.
Further, the method further comprises: in step S5, let T be T +1, and repeat steps S1 to S4 to obtain reconciliation results for multiple days. By means of circulation setting, reconciliation operation can be performed on the real object inventory data and the logic inventory data for multiple continuous days, reconciliation results for multiple days are correspondingly obtained, and the application range of the method provided by the embodiment is expanded.
Optionally, the method for acquiring the material inventory running water and the logic inventory running water of the previous day at the zero point of the T +1 th day in the above embodiment includes:
at the zero time of the T +1 th day, correspondingly acquiring the material object inventory running water and the logic inventory running water of the previous day from the material object inventory system and the logic inventory system respectively by adopting a big data extraction mode; or at the zero time of the T +1 th day, extracting the material inventory running water of the previous day issued by the material inventory system every day and extracting the logic inventory running water of the previous day issued by the logic inventory system every day. Through the arrangement of two data acquisition modes, the flexibility of system application can be increased.
Specifically, in the above embodiment, the method for accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain the physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain the logical inventory initial data of the T +1 th day includes:
accumulating the physical inventory snapshot and the day increment of the physical inventory by adopting a spark and MapReduce calculation engine to obtain the initial data of the physical inventory in the T +1 th day; and accumulating the logical inventory snapshot and the day increment of the logical inventory by adopting spark and MapReduce calculation engines to obtain the initial data of the logical inventory at the T +1 th day.
Further, the physical inventory initial data, the logic inventory initial data, the day increment of the physical inventory and the day increment of the logic inventory are stored in a Hive data warehouse.
Specifically, in the above embodiment, the method for reconciling the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day after performing data conversion of the same dimension, and outputting a reconciliation result includes:
the physical inventory initial data comprises a commodity number, physical location information, physical inventory position information, goods master information and physical inventory quantity information on the T +1 th day, and the logic inventory initial data comprises the commodity number, logic location information, logic inventory position information, goods master information and logic inventory quantity information on the T +1 th day;
performing unified dimensional data conversion on the physical inventory initial data and the logical inventory initial data, wherein the dimensional information of the converted physical inventory initial data comprises a commodity number, city bin information, goods owner information and physical inventory quantity information in the T +1 th day, and the dimensional information of the converted logical inventory initial data comprises the commodity number, the city bin information, the goods owner information and the logical inventory quantity information in the T +1 th day;
the reconciliation result comprises commodity numbers, city bin information, owner information, real object inventory quantity information of the T +1 th day, logic inventory quantity information of the T +1 th day and difference data.
Further, in the above embodiments, the difference data is stored in the elastic search full-text search engine in units of date to support the function of screening and querying the difference data.
It can be seen that, in this embodiment, a plurality of big data technologies are used to perform reconciliation operation on inventory data between the physical inventory system and the logical inventory system, for example, a spark and MapReduce calculation engine is used to calculate and compare inventory data to obtain difference data, and a comparison result of the difference data is stored in an elastic search full-text search engine to realize a query function supporting details of multi-dimensional difference data.
Example two
Referring to fig. 1 and fig. 5, the present embodiment provides an account checking system for physical inventory and logical inventory of an e-commerce platform, including:
the system comprises an initialization unit 1, a database management unit and a database management unit, wherein the initialization unit 1 is used for respectively calling a real inventory snapshot and a logic inventory snapshot at the zero time of the T day as initial inventory data;
the increment obtaining unit 2 is configured to obtain the running water of the physical inventory and the running water of the logical inventory of the previous day at the zero time of the T +1 th day, and obtain the day increment of the physical inventory based on the running water of the physical inventory and the day increment of the logical inventory based on the running water of the logical inventory, respectively;
the calculating unit 3 is configured to accumulate the physical inventory snapshot and the day increment of the physical inventory to obtain physical inventory initial data for the T +1 th day, and accumulate the logical inventory snapshot and the day increment of the logical inventory to obtain logical inventory initial data for the T +1 th day;
the dimension conversion unit 4 is used for performing unified dimension data conversion on the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day, and then checking accounts, and outputting a checking account result;
the analysis output unit 6 locks dimension information with difference in the real object inventory initial data and the logic inventory initial data of the T +1 th day based on the reconciliation result, and simultaneously outputs the difference data of the dimension information;
and the prompting unit 7 is used for automatically giving an alarm when the difference data is larger than the threshold value, and reminding a manager to check the inventory.
Preferably, the method further comprises the following steps:
and the circulating unit 5 is used for enabling T to be T +1 and responding to the initialization unit again to obtain the reconciliation result of multiple days.
Preferably, the method further comprises the following steps:
the query unit is used for storing the difference data in an elastic search full-text search engine by taking the date as a unit so as to support the screening query function of the difference data.
Compared with the prior art, the reconciliation system for the physical inventory and the logical inventory of the e-commerce platform provided by the embodiment of the invention has the same beneficial effect as the reconciliation method for the physical inventory and the logical inventory of the e-commerce platform provided by the embodiment, and the detailed description is omitted here.
It will be understood by those skilled in the art that all or part of the steps in the method for implementing the invention may be implemented by hardware instructions related to a program, the program may be stored in a computer-readable storage medium, and when executed, the program includes the steps of the method of the embodiment, and the storage medium may be: ROM/RAM, magnetic disks, optical disks, memory cards, and the like.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.
Claims (10)
1. A reconciliation method for physical inventory and logical inventory of an e-commerce platform is characterized by comprising the following steps:
step S1, respectively calling a real inventory snapshot and a logic inventory snapshot at the zero time of the T day as initial inventory data;
step S2, acquiring the running water of the physical stock and the running water of the logical stock of the previous day at the zero time of the T +1 th day, and respectively acquiring the day increment of the physical stock based on the running water of the physical stock and the day increment of the logical stock based on the running water of the logical stock;
step S3, accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain logical inventory initial data of the T +1 th day;
step S4, performing unified dimensional data conversion on the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day, and then checking accounts, and outputting a checking account result;
step S6, locking dimension information with difference in the real object inventory initial data and the logic inventory initial data of the T +1 th day based on the account checking result, and simultaneously outputting the difference data of the dimension information;
and step S7, automatically giving an alarm when the difference data is larger than the threshold value, and reminding a manager to check the inventory.
2. The method of claim 1, further comprising:
in step S5, let T be T +1, and repeat steps S1 to S4 to obtain reconciliation results for multiple days.
3. The method of claim 1, wherein the method of obtaining the running water of the physical inventory and the running water of the logical inventory of the previous day at the zero time of the T +1 th day comprises:
at the zero time of the T +1 th day, correspondingly acquiring the material object inventory running water and the logic inventory running water of the previous day from the material object inventory system and the logic inventory system respectively by adopting a big data extraction mode; or,
and at the zero time of the T +1 th day, extracting the material inventory running water of the previous day issued by the material inventory system every day and extracting the logic inventory running water of the previous day issued by the logic inventory system every day.
4. The method according to claim 1, wherein the method for accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain the physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain the logical inventory initial data of the T +1 th day comprises:
accumulating the physical inventory snapshot and the day increment of the physical inventory by adopting a spark and MapReduce calculation engine to obtain physical inventory initial data of T +1 day; and the number of the first and second groups,
and accumulating the logical inventory snapshot and the day increment of the logical inventory by adopting spark and MapReduce calculation engines to obtain the initial data of the logical inventory at the T +1 th day.
5. The method of claim 1, wherein the physical inventory initial data, the logical inventory initial data, the day increments for the physical inventory, and the day increments for the logical inventory are stored in a Hive data warehouse.
6. The method according to claim 1, wherein the method for reconciling the real object inventory initial data of the T +1 th day and the logical inventory initial data of the T +1 th day after performing data conversion of the same dimension and outputting a reconciliation result comprises:
the physical inventory initial data comprises a commodity number, physical location information, physical inventory position information, goods master information and physical inventory quantity information in the T +1 th day, and the logic inventory initial data comprises the commodity number, logic location information, logic inventory position information, goods master information and logic inventory quantity information in the T +1 th day;
performing unified dimensional data conversion on the physical inventory initial data and the logical inventory initial data, wherein the dimensional information of the converted physical inventory initial data comprises a commodity number, city bin information, goods owner information and T +1 th day physical inventory quantity information, and the dimensional information of the converted logical inventory initial data comprises the commodity number, the city bin information, the goods owner information and the T +1 th day logical inventory quantity information;
the reconciliation result comprises a commodity number, city bin information, goods owner information, real object inventory quantity information of the T +1 th day, logic inventory quantity information of the T +1 th day and difference data.
7. The method according to claim 1 or 6, wherein the difference data is stored in an elastic search full-text search engine in units of date to support a screening query function of difference data.
8. A reconciliation system for physical inventory and logical inventory of an e-commerce platform, comprising:
the initialization unit is used for respectively calling a real inventory snapshot and a logic inventory snapshot at the zero time of the T day as initial inventory data;
the increment obtaining unit is used for obtaining the running water of the physical stock and the running water of the logical stock in the previous day at the zero time of the T +1 th day, and respectively obtaining the day increment of the physical stock based on the running water of the physical stock and the day increment of the logical stock based on the running water of the logical stock;
the calculating unit is used for accumulating the physical inventory snapshot and the day increment of the physical inventory to obtain physical inventory initial data of the T +1 th day, and accumulating the logical inventory snapshot and the day increment of the logical inventory to obtain logical inventory initial data of the T +1 th day;
the dimension conversion unit is used for performing unified dimension data conversion on the real object inventory initial data of the T +1 th day and the logic inventory initial data of the T +1 th day and then checking accounts and outputting a checking account result;
the analysis output unit locks dimension information with difference in the real object inventory initial data and the logic inventory initial data of the T +1 th day based on the account checking result and outputs difference data of the dimension information at the same time;
and the prompting unit is used for automatically giving an alarm when the difference data is larger than the threshold value, and reminding a manager to check the inventory.
9. The system of claim 8, further comprising:
and the circulating unit is used for enabling T to be T +1 and responding to the initialization unit again to obtain the reconciliation result of multiple days.
10. The system of claim 8, further comprising:
the query unit is used for storing the difference data in an elastic search full-text search engine by taking the date as a unit so as to support the screening query function of the difference data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910461464.5A CN110322192A (en) | 2019-05-30 | 2019-05-30 | Account checking method and system for the physical holding of stock of electric business platform and logic inventory |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910461464.5A CN110322192A (en) | 2019-05-30 | 2019-05-30 | Account checking method and system for the physical holding of stock of electric business platform and logic inventory |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110322192A true CN110322192A (en) | 2019-10-11 |
Family
ID=68119353
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910461464.5A Pending CN110322192A (en) | 2019-05-30 | 2019-05-30 | Account checking method and system for the physical holding of stock of electric business platform and logic inventory |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110322192A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110930097A (en) * | 2019-12-11 | 2020-03-27 | 北京云杉世界信息技术有限公司 | Method and device for confirming commodity inventory after checking |
| CN112330253A (en) * | 2020-11-19 | 2021-02-05 | 无锡德望科荣科技系统有限公司 | Financial inventory management system capable of correcting enterprise resource plan in real time by data |
| CN112418748A (en) * | 2020-01-03 | 2021-02-26 | 上海哔哩哔哩科技有限公司 | Offline reconciliation method and system for e-commerce inventory under distributed architecture |
| CN112884719A (en) * | 2021-01-29 | 2021-06-01 | 广州富港万嘉智能科技有限公司 | Food stock checking method, readable storage medium and intelligent food machine |
| CN113111120A (en) * | 2020-01-13 | 2021-07-13 | 北京京东振世信息技术有限公司 | Method and device for verifying service data |
| CN113393191A (en) * | 2021-06-15 | 2021-09-14 | 北京京东振世信息技术有限公司 | Inventory reconciliation method, device, electronic equipment and storage medium |
| CN113496374A (en) * | 2020-04-08 | 2021-10-12 | 北京京东振世信息技术有限公司 | Data processing method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102663539A (en) * | 2012-03-20 | 2012-09-12 | 昆明悟然科技有限公司 | Operation cost management system based on platform of internet of things |
| CN103530757A (en) * | 2013-10-30 | 2014-01-22 | 杨斯智 | Network based multi-mode intelligent order following management method and intelligent management system |
| US20150161557A1 (en) * | 2013-12-09 | 2015-06-11 | Verizon Patent And Licensing Inc. | Inventory reconciliation device |
| CN104951509A (en) * | 2015-05-25 | 2015-09-30 | 中国科学院信息工程研究所 | Big data online interactive query method and system |
| US20160371639A1 (en) * | 2010-03-17 | 2016-12-22 | Medical Tracking Solutions, Inc. | System and method for tracking and managing medical device inventory |
| CN106447246A (en) * | 2015-08-06 | 2017-02-22 | 阿里巴巴集团控股有限公司 | Inventory data account checking method and inventory data account checking device |
| CN108133352A (en) * | 2018-02-09 | 2018-06-08 | 东莞嘉泰钟表有限公司 | A kind of practical method made an inventory with account inventory variance in quick processing warehouse |
-
2019
- 2019-05-30 CN CN201910461464.5A patent/CN110322192A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160371639A1 (en) * | 2010-03-17 | 2016-12-22 | Medical Tracking Solutions, Inc. | System and method for tracking and managing medical device inventory |
| CN102663539A (en) * | 2012-03-20 | 2012-09-12 | 昆明悟然科技有限公司 | Operation cost management system based on platform of internet of things |
| CN103530757A (en) * | 2013-10-30 | 2014-01-22 | 杨斯智 | Network based multi-mode intelligent order following management method and intelligent management system |
| US20150161557A1 (en) * | 2013-12-09 | 2015-06-11 | Verizon Patent And Licensing Inc. | Inventory reconciliation device |
| CN104951509A (en) * | 2015-05-25 | 2015-09-30 | 中国科学院信息工程研究所 | Big data online interactive query method and system |
| CN106447246A (en) * | 2015-08-06 | 2017-02-22 | 阿里巴巴集团控股有限公司 | Inventory data account checking method and inventory data account checking device |
| CN108133352A (en) * | 2018-02-09 | 2018-06-08 | 东莞嘉泰钟表有限公司 | A kind of practical method made an inventory with account inventory variance in quick processing warehouse |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110930097A (en) * | 2019-12-11 | 2020-03-27 | 北京云杉世界信息技术有限公司 | Method and device for confirming commodity inventory after checking |
| CN112418748A (en) * | 2020-01-03 | 2021-02-26 | 上海哔哩哔哩科技有限公司 | Offline reconciliation method and system for e-commerce inventory under distributed architecture |
| CN113111120A (en) * | 2020-01-13 | 2021-07-13 | 北京京东振世信息技术有限公司 | Method and device for verifying service data |
| CN113111120B (en) * | 2020-01-13 | 2023-09-01 | 北京京东振世信息技术有限公司 | Service data verification method and device |
| CN113496374A (en) * | 2020-04-08 | 2021-10-12 | 北京京东振世信息技术有限公司 | Data processing method and device |
| CN112330253A (en) * | 2020-11-19 | 2021-02-05 | 无锡德望科荣科技系统有限公司 | Financial inventory management system capable of correcting enterprise resource plan in real time by data |
| CN112884719A (en) * | 2021-01-29 | 2021-06-01 | 广州富港万嘉智能科技有限公司 | Food stock checking method, readable storage medium and intelligent food machine |
| CN113393191A (en) * | 2021-06-15 | 2021-09-14 | 北京京东振世信息技术有限公司 | Inventory reconciliation method, device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110322192A (en) | Account checking method and system for the physical holding of stock of electric business platform and logic inventory | |
| WO2021052031A1 (en) | Statistical interquartile range-based commodity inventory risk early warning method and system, and computer readable storage medium | |
| US9965531B2 (en) | Data storage extract, transform and load operations for entity and time-based record generation | |
| US11372896B2 (en) | Method and apparatus for grouping data records | |
| CN101625686A (en) | Method and system for monitoring data consistency between plurality of databases | |
| CN107292418A (en) | A kind of waybill is detained Forecasting Methodology | |
| CN110546621A (en) | garbage collection for data storage | |
| CN110503359A (en) | One kind adopting management system with pin surely | |
| CN111914163A (en) | Medicine combination recommendation method and device, electronic equipment and storage medium | |
| CN103853802A (en) | Apparatus and method for indexing electronic content | |
| CN113537850A (en) | Storage optimization method and device, computer equipment and storage medium | |
| CN101452556A (en) | Customer information processing system and method | |
| CN114997916A (en) | Prediction method, system, electronic device and storage medium of potential user | |
| Meertens et al. | A data-driven supply-side approach for estimating cross-border Internet purchases within the European Union | |
| CN110688846B (en) | Periodic word mining method, system, electronic equipment and readable storage medium | |
| CN110706019A (en) | Effective price tag pushing method and device, computer equipment and storage medium | |
| CN113986821A (en) | Archive file management method based on label | |
| US20240134860A1 (en) | Order searching method, apparatus, computer device, and storage medium | |
| CN113780913A (en) | Method and device for generating safety stock information | |
| CN110990692A (en) | Data processing method and device based on portrait analysis | |
| CN115689713A (en) | Abnormal risk data processing method and device, computer equipment and storage medium | |
| CN107665451B (en) | Method and device for pushing product based on customer characteristic data | |
| CN111782954B (en) | Determination method and device of abnormal data search model | |
| CN114996342B (en) | Pool dividing method and device for connecting pools | |
| CN117575335B (en) | Vehicle development project risk monitoring method, device, system, equipment and medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191011 |