阅读说明：本技术 一种零售数据自动处理识别系统及实现方法 (Retail data automatic processing and identifying system and implementation method ) 是由 刘红 赵健民 肖洒 于 2018-11-26 设计创作，主要内容包括：本发明公开了一种零售数据自动处理识别系统,包括：该零售数据自动处理识别系统及其实现方法,所述数据自动识别主程序模块,对下载数据进行识别处理,所述数据识别处理模块,根据已预设的零售客户分类、单据数据分类,进行数据分类自动识别处理,所述数据识别处理模块,根据主程序自动汇总的识别失败的零售客户单据数据类型,对识别失败的数据进行再次自动识别；所述网站原始资料数据库模块,数据入库成功后,自动返回入库结果,任务结束。该零售数据自动处理识别系统及其实现方法,该零售数据自动处理识别系统及其实现方法,可按供应商、零售商进行独立标识,再将同类单据标准化,自动对零售商数据进行处理识别,并归类存储。(The invention discloses an automatic processing and identifying system for retail data, which comprises: the retail data automatic processing and identifying system and the realizing method thereof are characterized in that a data automatic identification main program module identifies and processes downloaded data, a data identification processing module automatically identifies and processes data classification according to preset retail customer classification and bill data classification, and a data identification processing module automatically identifies and processes data failed to identify again according to the retail customer bill data types failed to identify and automatically summarized by the main program; and the website original data database module automatically returns a storage result after the data is successfully stored, and the task is finished. The retail data automatic processing and identifying system and the realizing method thereof can carry out independent identification according to suppliers and retailers, standardize similar documents, automatically process and identify the data of the suppliers and classify and store the data.)

1. An automated retail data processing and identification system, the system comprising: the system comprises a data acquisition module, a data automatic identification main program module, a data preset principle module, an abnormal document type automatic summarizing module, a website original data database module and a log recording module;

the data acquisition module is used for acquiring data downloaded by a website;

the data automatic identification main program module is used for directly starting a data automatic identification main program after data downloaded from a website is obtained, automatically identifying the downloaded data and setting type classification and range of data identification;

the data preset principle module comprises a retail customer classification and database division principle and a document data classification and database division principle;

the data automatic identification main program module is used for carrying out data classification automatic identification processing according to preset retail customer classification and document data classification to obtain an identification processing result; if the identification processing result is that the automatic data identification processing is successful, sending the data to an independent website original database module according to a classification and database dividing principle; if the identification processing result is that the automatic data identification processing is unsuccessful, the data is sent to an abnormal bill type automatic summarizing module;

the abnormal bill type automatic summarizing module is used for automatically summarizing the abnormal bill types and sending the abnormal bill type automatic summarizing result to the log recording module;

the log recording module is used for writing the automatic summarizing result of the abnormal bill types into a log table as an execution result record, and the main program automatically reminds the data presetting principle module to supplement and maintain the classification database dividing principle;

the data identification processing module is also used for automatically identifying the data failed in identification again after supplementing a maintenance classification database dividing principle, and sending the data to the original database module of the website for storage after the data is successfully identified;

and the website original data database module is also used for automatically returning a warehousing result after the data warehousing is successful, taking the warehousing result as an execution result record and writing the execution result record into a log table, and finishing the single data automatic identification processing task.

2. A retail data automatic processing identification system according to claim 1, characterized by: the data preset principle module can manually adjust retail customer and document data to carry out classification and classification, and the data is changed according to preset values.

3. A retail data automatic processing identification system according to claim 1, characterized by: the automatic data identification main program module stores the successfully identified data into the independent original website database according to the classification and database dividing principle, collects and records the abnormal bill types which are failed to be identified into a record table as an execution result, re-identifies the failed data after supplementing and maintaining the classification and database dividing principle, and stores the data into the independent original website database after the data are successfully identified.

4. A retail data automatic processing identification system and an implementation method thereof are characterized by comprising the following steps: after the data is downloaded through the website, a data automatic identification main program is directly started, the downloaded data can be automatically identified through the identification main program, and the type classification and the range of data identification are set;

according to the preset retail customer classification and document data classification, automatic data classification identification processing is carried out, and after identification is successful, the data are stored in an independent website original database according to a classification database principle, so that data can be inquired and used manually;

various downloaded data are automatically classified and identified by retail customers and document data, and are identified by preset classification standards of retail customers and classification standards of document data, and different identification processing results are obtained for the downloaded data: success and failure of identification;

identifying and processing the downloaded data as one-time successful data, and directly storing the downloaded data into an independent website original database according to a classification and database dividing principle;

for the downloaded data with the identification processing result of 'failure', the main program automatically summarizes and identifies the data types of the documents of the retail customers with the failure, the data types are written into a log table as execution result records, and meanwhile, the main program automatically reminds the supplement and maintenance of classification library division principles;

according to the retail customer document data types which are automatically gathered by the main program and failed in identification, after a maintenance classification database dividing principle is supplemented, automatically identifying the data which are failed in identification again, and storing the data into a website original database after the data are successfully identified;

and after the data is successfully put in the warehouse, automatically returning a warehousing result, recording the warehousing result as an execution result, writing the execution result into a log table, finishing the single data automatic identification processing task, and starting to perform automatic identification processing on the next data.

5. The retail data automatic processing and recognition system and the realization method thereof according to claim 4, characterized in that: the data presetting principle is used for manually classifying and sorting the data of the retail customer and the document.

6. The retail data automatic processing and recognition system and the realization method thereof according to claim 4, characterized in that: the processing range of the data identification processing module is as follows: the retail customer classification of the website download data and the document data classification.

7. The retail data automatic processing and recognition system and the realization method thereof according to claim 4, characterized in that: and the data identification processing module performs classification and library division on successfully identified data, stores the successfully identified data into an independent website original database, performs exception summary processing on unsuccessfully identified data, performs secondary identification, and finishes warehousing after the successfully identified data.

8. An automatic retail data processing and identification system, characterized in that: the method comprises the following steps:

the data automatic identification main program module starts to operate after the data downloading on the website is finished, and starts to identify the downloaded data;

the data presetting principle module consists of a retail customer and a document data classification and sub-library;

the data automatic identification main program module carries out data classification automatic identification processing according to preset retail customer classification and receipt data classification, stores the data classification automatic identification processing into an independent website original database according to a classification database dividing principle after the data identification is successful, automatically summarizes and identifies the failed retail customer receipt data types by the main program if the data automatic identification processing is unsuccessful, writes the data types into a log table as execution result records, and automatically reminds the main program to supplement the maintenance classification database dividing principle;

the data automatic identification main program module is used for automatically identifying the data failed in identification again after supplementing a maintenance classification database dividing principle according to the retail customer document data types failed in identification automatically summarized by the main program, and storing the data failed in identification into a website original database after successful identification;

the website original data database module automatically returns a warehousing result after successful data warehousing, the warehousing result is used as an execution result record and written into a log table, and a single data automatic identification processing task is finished;

the retail data is automatically processed and identified by adopting the following steps: after the data is downloaded through the website, a data automatic identification main program is directly started, the downloaded data can be automatically identified through the identification main program, and the type classification and the range of data identification are set;

according to the preset retail customer classification and document data classification, automatic data classification identification processing is carried out, and after identification is successful, the data are stored in an independent website original database according to a classification database principle, so that data can be inquired and used manually;

various downloaded data are automatically classified and identified by retail customers and document data, and are identified by preset classification standards of retail customers and classification standards of document data, and different identification processing results are obtained for the downloaded data: success and failure of identification;

identifying and processing the downloaded data as one-time successful data, and directly storing the downloaded data into an independent website original database according to a classification and database dividing principle;

for the downloaded data with the identification processing result of 'failure', the main program automatically summarizes and identifies the data types of the documents of the retail customers with the failure, the data types are written into a log table as execution result records, and meanwhile, the main program automatically reminds the supplement and maintenance of classification library division principles;

according to the retail customer document data types which are automatically gathered by the main program and failed in identification, after a maintenance classification database dividing principle is supplemented, automatically identifying the data which are failed in identification again, and storing the data into a website original database after the data are successfully identified;

and after the data is successfully put in the warehouse, automatically returning a warehousing result, recording the warehousing result as an execution result, writing the execution result into a log table, finishing the single data automatic identification processing task, and starting to perform automatic identification processing on the next data.

Technical Field

The invention relates to the technical field of automatic data processing and identifying systems, in particular to an automatic retail data processing and identifying system and an implementation method thereof.

Background

The business transactions of the two parties of the zero supply are all through various bill jobs, such as orders, receipt bills, return bills and the like, and some data sharing, such as POS real sales, stock data and the like, the bills of each retailer website are different from data formats, types and presentation modes, and after the suppliers obtain the information, the suppliers need to manually name and store the documents in a classified mode.

Because the number of retailers and the types of documents and data are large, the formats are different, manual processing and identification are complicated, the documents and the data are not easy to arrange, and the documents and the data of the same type cannot be integrated. We propose an automatic retail data processing and identification system and an implementation method thereof so as to solve the problems set forth above.

Disclosure of Invention

The invention aims to provide an automatic retail data processing and identifying system to solve the problems that due to the fact that a plurality of retailers, a plurality of documents and data types and different formats are provided in the background art, manual processing and identification are complicated, sorting is not easy, and similar documents and data cannot be integrated.

In order to achieve the purpose, the invention provides the following technical scheme: an automated retail data processing identification system comprising: the system comprises a data acquisition module, a data automatic identification main program module, a data preset principle module, an abnormal document type automatic summarizing module, a website original data database module and a log recording module;

the data acquisition module is used for acquiring data downloaded by a website;

the data automatic identification main program module is used for directly starting a data automatic identification main program after data downloaded from a website is obtained, automatically identifying the downloaded data and setting type classification and range of data identification;

the data preset principle module comprises a retail customer classification and database division principle and a document data classification and database division principle and is used for carrying out data classification automatic identification processing, and after identification is successful, the data preset principle module is stored into an independent website original database module according to the classification and database division principle;

the data identification processing module is used for carrying out automatic identification processing on data classification according to preset retail customer classification and document data classification to obtain an identification processing result; if the identification processing result is that the automatic data identification processing is successful, sending the data to an independent website original database module according to a classification and database dividing principle; if the identification processing result is that the automatic data identification processing is unsuccessful, the data is sent to an abnormal bill type automatic summarizing module;

the abnormal bill type automatic summarizing module is used for automatically summarizing the abnormal bill types and sending the abnormal bill type automatic summarizing result to the log recording module;

the log recording module is used for writing the automatic summarizing result of the abnormal bill types into a log table as an execution result record and automatically reminding the data presetting principle module to supplement and maintain the classification database dividing principle;

the data identification processing module is also used for automatically identifying the data failed in identification again after supplementing a maintenance classification database dividing principle, and sending the data to the original database module of the website for storage after the data is successfully identified;

and the website original data database module is also used for automatically returning a warehousing result after the data warehousing is successful, taking the warehousing result as an execution result record and writing the execution result record into a log table, and finishing the single data automatic identification processing task.

Optionally, the data pre-set rule module can manually adjust the retail customer and document data to perform classification and classification into the database, and the data pre-set rule module can change the value.

Optionally, the data identification processing template stores the successfully identified data into an independent website original database according to a classification and database dividing principle, summarizes and records the failed identified abnormal document type as an execution result into a record table, re-identifies the failed identified data after supplementing and maintaining the classification and database dividing principle, and stores the failed identified data into the independent website original database after the successful identification.

In order to achieve the above purpose, the invention also provides the following scheme:

a retail data automatic processing identification system and an implementation method thereof comprise the following steps: after the data is downloaded through the website, a data automatic identification main program is directly started, the downloaded data can be automatically identified through the identification main program, and the type classification and the range of data identification are set;

according to the preset retail customer classification and document data classification, automatic data classification identification processing is carried out, and after identification is successful, the data are stored in an independent website original database according to a classification database principle, so that data can be inquired and used manually;

various downloaded data are automatically classified and identified by retail customers and document data, and are identified by preset classification standards of retail customers and classification standards of document data, and different identification processing results are obtained for the downloaded data: success and failure of identification;

identifying and processing the downloaded data as one-time successful data, and directly storing the downloaded data into an independent website original database according to a classification and database dividing principle;

for the downloaded data with the identification processing result of 'failure', the main program automatically summarizes and identifies the data types of the documents of the retail customers with the failure, the data types are written into a log table as execution result records, and meanwhile, the main program automatically reminds the supplement and maintenance of classification library division principles;

according to the retail customer document data types which are automatically gathered by the main program and failed in identification, after a maintenance classification database dividing principle is supplemented, automatically identifying the data which are failed in identification again, and storing the data into a website original database after the data are successfully identified;

and after the data is successfully put in the warehouse, automatically returning a warehousing result, recording the warehousing result as an execution result, writing the execution result into a log table, finishing the single data automatic identification processing task, and starting to perform automatic identification processing on the next data.

Optionally, the data presetting principle is manually classified and classified into a database for retail customers and document data.

Optionally, the processing range of the data identification processing module is: the retail customer classification of the website download data and the document data classification.

Optionally, the data identification processing module performs classification and library division on successfully identified data, stores the successfully identified data in an independent website original database, performs exception summary processing on unsuccessfully identified data, performs secondary identification, and finishes warehousing after the successfully identified data.

In addition, the invention also provides a retail data automatic processing and identifying system, which comprises:

the data automatic identification main program module starts to operate after the data downloading on the website is finished, and starts to identify the downloaded data;

the data presetting principle module consists of a retail customer and a document data classification and sub-library;

the data identification processing module carries out data classification automatic identification processing according to preset retail customer classification and receipt data classification, stores the data classification automatic identification processing into an independent website original database according to a classification database dividing principle after the data identification is successful, automatically summarizes and identifies the failed retail customer receipt data types by a main program if the data automatic identification processing is unsuccessful, writes the data types into a log table as execution result records, and automatically reminds the main program to supplement and maintain the classification database dividing principle;

the data identification processing module is used for automatically identifying the data failed in identification again after supplementing a maintenance classification database dividing principle according to the retail customer document data types failed in identification automatically summarized by the main program, and storing the data failed in identification into the original database of the website after the data is successfully identified;

the website original data database module automatically returns a warehousing result after successful data warehousing, the warehousing result is used as an execution result record and written into a log table, and a single data automatic identification processing task is finished;

the retail data is automatically processed and identified by adopting the following steps: after the data is downloaded through the website, a data automatic identification main program is directly started, the downloaded data can be automatically identified through the identification main program, and the type classification and the range of data identification are set;

according to the preset retail customer classification and document data classification, automatic data classification identification processing is carried out, and after identification is successful, the data are stored in an independent website original database according to a classification database principle, so that data can be inquired and used manually;

various downloaded data are automatically classified and identified by retail customers and document data, and are identified by preset classification standards of retail customers and classification standards of document data, and different identification processing results are obtained for the downloaded data: success and failure of identification;

identifying and processing the downloaded data as one-time successful data, and directly storing the downloaded data into an independent website original database according to a classification and database dividing principle;

for the downloaded data with the identification processing result of 'failure', the main program automatically summarizes and identifies the data types of the documents of the retail customers with the failure, the data types are written into a log table as execution result records, and meanwhile, the main program automatically reminds the supplement and maintenance of classification library division principles;

according to the retail customer document data types which are automatically gathered by the main program and failed in identification, after a maintenance classification database dividing principle is supplemented, automatically identifying the data which are failed in identification again, and storing the data into a website original database after the data are successfully identified;

and after the data is successfully put in the warehouse, automatically returning a warehousing result, recording the warehousing result as an execution result, writing the execution result into a log table, finishing the single data automatic identification processing task, and starting to perform automatic identification processing on the next data.

Compared with the prior art, the invention has the beneficial effects that: the retail data automatic processing and identifying system and the realization method thereof can carry out independent identification according to suppliers and retailers, standardize the similar documents, automatically process and identify the data of the retailers, classify and store the data, improve the accuracy and the convenience of retail data identification, reduce the time and labor consumption of auxiliary operation of manpower, avoid the problems of slow data identification and analysis speed, low efficiency and data identification error caused by comparing specified rules and data with manpower identification classification, automatically summarize document types for abnormal data failed in identification after data identification and analysis, automatically identify the data failed in identification again after supplementing and maintaining classification database division principles, store the data into an independent website original database according to the classification database principle after the data identification is successful, facilitate the application and the check of the data, and carrying out identification processing on the next data.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.

FIG. 1 is a schematic diagram of an automated retail data processing and identification system according to the present invention;

FIG. 2 is a schematic diagram of a classification and classification rule library of an automatic retail data processing and recognition system according to the present invention;

fig. 3 is a schematic diagram of an implementation method of the retail data automatic processing and identifying system of the invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. 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.

In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further explained below.

Example 1

This embodiment 1 provides an automatic retail data processing and identifying system, please refer to fig. 1-2, which includes website acquisition of data, automatic data identification main program, classification and library presetting rule, data identification processing, automatic summary of abnormal document types, original data database of website, and log recording result, and the following describes the above system in detail.

Downloading data on a website by acquiring the data, starting an automatic identification main program of the data after the data are downloaded, starting identification processing on the downloaded data, and artificially limiting and controlling through a classification library-based preset principle: the retail customer classification and the receipt data classification are carried out, the downloaded data is analyzed and processed by a data identification processing module, the data which is successfully identified and determined for the first time is directly stored in an independent website original database according to the principle of sub-database classification, the data which is unsuccessfully identified and determined for the first time is automatically summarized, the automatic summarizing result of the data type is stored in a log record result, the automatically summarized abnormal receipt data is supplemented by the data classification sub-database principle, the data which is failed to identify is automatically identified again, the data which is successfully identified is stored in the website original database after the data identification is successful, the data is successfully stored in the database, the database entry result is automatically returned and written into a log table as an execution result record, the single data automatic identification processing task is finished, and then the data downloaded from the next website is analyzed by using identification processing, continuous and quick identification analysis processing of downloaded data is realized.

Example 2

Corresponding to the retail data automatic processing and identifying system provided in embodiment 1, embodiment 2 provides an implementation method of the retail data automatic processing and identifying system, please refer to fig. 3, which includes the following steps:

step 1: after the data are downloaded from the website, a data automatic identification main program is directly started, the downloaded data can be automatically identified by identifying the main program, the type classification and range of data identification are set, the program is set by a computer, so that the data identification is more accurate, the identification errors and errors are reduced, and the rapid identification operation of the data is facilitated;

step 2: according to the preset retail customer classification and document data classification, automatic data classification identification processing is carried out, and after identification is successful, the data are stored in an independent website original database according to a classification database principle, so that data can be inquired and used manually;

and step 3: various downloaded data are automatically classified and identified by retail customers and document data, and are identified by preset classification standards of retail customers and classification standards of document data, and different identification processing results are obtained for the downloaded data: the identification success and the identification failure are carried out, and different identification results are processed by different identification result methods;

and 4, step 4: identifying and processing the downloaded data as one-time successful data, and directly storing the downloaded data into an independent website original database according to a classification and database dividing principle, so that the data can be conveniently and manually searched and used;

and 5: for the downloaded data with the identification processing result of 'failure', the main program automatically summarizes and identifies the data types of the failed retail customer receipts, the data types are written into a log table as execution result records, meanwhile, the main program automatically reminds a principle of supplementing, maintaining and classifying the sub-bases, and automatically identifies the data with the identification failure again after supplementing the principle of maintaining and classifying the sub-bases according to the data types of the failed retail customer receipts automatically summarized by the main program, and stores the data into an original database of a website after the data are successfully identified for multiple times;

step 6: and after the data is successfully put in the warehouse, automatically returning a warehousing result, recording the warehousing result as an execution result, writing the execution result into a log table, finishing the single data automatic identification processing task, and starting to perform automatic identification processing on the next data.

Although the present invention has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that various changes in the embodiments and/or modifications of the invention can be made, and equivalents and modifications of some features of the invention can be made without departing from the spirit and scope of the invention.