CN109584009B - Automatic matching system for website data - Google Patents

Automatic matching system for website data Download PDF

Info

Publication number
CN109584009B
CN109584009B CN201811431321.1A CN201811431321A CN109584009B CN 109584009 B CN109584009 B CN 109584009B CN 201811431321 A CN201811431321 A CN 201811431321A CN 109584009 B CN109584009 B CN 109584009B
Authority
CN
China
Prior art keywords
data
module
conversion
automatic
main
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
CN201811431321.1A
Other languages
Chinese (zh)
Other versions
CN109584009A (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.)
Shanghai Amt Data System Co ltd
Original Assignee
Shanghai Amt Data System 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 Shanghai Amt Data System Co ltd filed Critical Shanghai Amt Data System Co ltd
Priority to CN201811431321.1A priority Critical patent/CN109584009B/en
Publication of CN109584009A publication Critical patent/CN109584009A/en
Application granted granted Critical
Publication of CN109584009B publication Critical patent/CN109584009B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • 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
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0621Item configuration or customization
    • 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
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0633Lists, e.g. purchase orders, compilation or processing

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Information Transfer Between Computers (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention discloses an automatic matching system for website data, which comprises data sending equipment, a website original data database, a data conversion processing module and a data summarization conversion module, wherein the output end of the data sending equipment is connected with the input end of a data entry module, the output end of the data entry module is connected with the input end of a data analysis module, the output end of the data matching module is connected with the input end of a data screening module, and the input end of the data summarization conversion module is connected with the output end of a log recording module. According to the automatic matching system for the website data, the corresponding relation between information such as a retailer website store, commodities and information such as a supplier store and commodities is established, data matching conversion can be automatically performed on the information through the data conversion processing module, when the conversion is abnormal, the data screening module can give an error prompt, and matching is performed again after supplementary maintenance, so that the efficiency of data processing is improved.

Description

Automatic matching system for website data
Technical Field
The invention relates to the technical field of automatic conversion of website data, in particular to an automatic matching system of website data.
Background
In daily life, business transactions of two zero-supply parties are operated through various receipts, such as orders, receipt receipts, return notes and the like, a retail store opens the content viewed by a supplier on a website, and presented information of systems inside the retail store, such as stores, commodities, commodity units and the like, is completely different from the number and name of systems inside the supplier, so that the supplier needs to judge which information corresponds to the systems inside the supplier through manual work when processing various receipts of the retail store.
Most of the existing information conversion work is carried out manually, but because the number of retailers is large, the amount of documents is large, and the number of information conversion items is large, the information conversion is carried out only through manual judgment, firstly, personnel are required to know relevant information of the retailers and internal systems of enterprises very well, the processing efficiency is very low, the forms and the contents of documents of each retail website are different, units, prices, box gauges, tax rates and the like are different, the error is easy to make only by subjective judgment, the influence of the working experience or the familiarity of the personnel is caused, the error rate is high, once the error occurs, the subsequent delivery operation is disturbed or refused, and the enterprise is possibly lost seriously.
Disclosure of Invention
The invention aims to provide an automatic matching system for website data, which aims to solve the problems that the processing efficiency is very low, the subjective judgment is only needed, the error is very easy and the enterprise loss is easily caused when the information conversion is carried out by the manual judgment in the background technology.
In order to achieve the purpose, the invention provides the following technical scheme: an automatic matching system for website data comprises a data sending device, a website original data database, a data conversion processing module and a data summarization conversion module, wherein the output end of the data sending device is connected with the input end of a data entry device, the output end of the data entry device is connected with the input end of a data analysis module, the output end of the website original data database is connected with the input end of a data automatic conversion main program module, the input end of the data automatic conversion main program module is connected with the input end of the data analysis module, the input end of the data conversion processing module is connected with the output end of the data automatic conversion main program module, the output end of the data conversion processing module is connected with the input end of a data matching module, the output end of the data matching module is connected with the input end of a data screening module, the output end of the data screening module is connected with the input ends of the abnormal data automatic summarizing module and the log recording module respectively, the output end of the abnormal data automatic summarizing module is respectively connected with the input ends of the main data relation conversion module and the cloud data storage module, the output end of the main data relation conversion module is connected with the input end of the data conversion processing module, the output ends of the abnormal data automatic summarizing module and the data screening module are connected with the input end of the log recording module, the output end of the log recording module is connected with the input end of the cloud data storage module, and the input end of the log recording module is connected with the output end of the firewall system module, the input end of the data summarization conversion module is connected with the output end of the log recording module, and the data summarization conversion module is connected with the data output module.
Preferably, the data sending device comprises a mobile phone end and a computer display end, and the data sending device and the data entry module are connected with each other through the internet.
Preferably, the data processed by the data conversion processing module comprises retailer main data, store main data, product corresponding main data, product package main data, unit main data, product specification main data, tax rate main data and discount main data.
Preferably, the automatic data conversion main program module is provided with a timing module, and the automatic data conversion main program module is connected with the original data database of the website through a network.
Preferably, the processing range of the data conversion processing module includes various documents for automatic conversion processing of stores, commodities, commodity packages, gifts, units, quantities, tax rates, discount rates, money amounts and the like, and the data conversion processing module can perform special rule conversion according to special conditions.
Preferably, the data screening module respectively with abnormal data automatic summarization module and logging module pass through data interconnect, and the data that the data screening module failed will be transmitted to abnormal data automatic summarization module, the data that pass through will be transmitted to the logging module.
Preferably, the cloud data storage module is respectively connected with the abnormal data automatic collecting module and the log recording module through a network, and the cloud data storage module stores the recorded data in the network in the form of an account number and a password.
Preferably, the main data relationship conversion module performs automatic conversion again on the data which is failed to be converted in the abnormal data automatic summary module, and the data which is successfully converted by the main data relationship conversion module is collected as an execution record by the log recording module.
Compared with the prior art, the invention has the beneficial effects that: the website data is automatically matched with a system,
1. by establishing the corresponding relation between information such as website stores and commodities of retailers and information such as store stores and commodities of suppliers and setting the data conversion processing module, the matching conversion is automatically carried out on the information, the defect of operation subjective judgment by manpower in the traditional industry is avoided, the manpower is saved, and the condition that the enterprise is lost due to the manual judgment error is avoided;
2. the data information of the retailers and the suppliers is matched and converted by the system through the data conversion processing module, when the conversion is abnormal, the data screening module can give an error prompt, the system can supplement and maintain the corresponding relation through the main data relation conversion module after being identified and collected by the abnormal data automatic summarizing module, and then the matching conversion is carried out through the data conversion processing module again, so that the working efficiency of the system is improved;
3. synchronous data of all retailers can be unified and arranged into format files used by internal standards of enterprises according to supplier information through the data summarization conversion module.
Drawings
FIG. 1 is a schematic view of the flow structure of the present invention;
FIG. 2 is a schematic diagram of a data screening failure process according to the present invention;
FIG. 3 is a schematic diagram of a processing data structure of the data conversion processing module according to the present 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.
Referring to fig. 1-3, the present invention provides a technical solution: a kind of website data automatic matching system, including data sending equipment, original data database of the website, data conversion processing module and data summarization conversion module, the output end of the data sending equipment links with input end of the data entry equipment, and the output end of the data entry equipment links with input end of the data analysis module, the data sending equipment includes mobile phone end and computer display end, and the data sending equipment and data entry module are interconnected through the Internet, users can carry on the entry of the data through the network by the mobile phone or computer, has saved the manpower, has raised the working efficiency;
the output end of the website original data database is connected with the input end of a data automatic conversion main program module, the input end of the data automatic conversion main program module is connected with the input end of a data analysis module, a timing module is arranged in the data automatic conversion main program module, and the automatic conversion main program module is mutually connected with the website original data database through a network, so that the conversion of data is unified effectively;
the input end of the data conversion processing module is connected with the output end of the data automatic conversion main program module, the output end of the data conversion processing module is connected with the input end of the data matching module, the data processed by the data conversion processing module comprises main data of retailers, main data of stores, main data corresponding to products, main data of product packages, main data of units, main data of product specifications, main data of tax rate and main data of discounts, the processing range of the data conversion processing module comprises various bills for automatic conversion processing of stores, commodities, commodity packages, gifts, units, quantity, tax rate, discounting rate, amount and the like, and the data conversion processing module can perform special rule conversion according to special conditions, so that the functionality of the system is improved, and greater convenience is brought to users;
the output end of the data matching module is connected with the input end of the data screening module, the output end of the data screening module is respectively connected with the input ends of the abnormal data automatic summarizing module and the log recording module, the data screening module is respectively connected with the abnormal data automatic summarizing module and the log recording module through data, data which do not pass through the data screening module are transmitted to the abnormal data automatic summarizing module, and data which pass through the data screening module are transmitted to the log recording module, so that the identification of the system is higher;
the output end of the abnormal data automatic summarizing module is connected with the input ends of the main data relation conversion module and the cloud data storage module respectively, the output end of the main data relation conversion module is connected with the input end of the data conversion processing module, the cloud data storage module is connected with the abnormal data automatic summarizing module and the log recording module respectively through a network, the cloud data storage module stores recorded data in the network in the form of account numbers and passwords, and the cloud data storage module is arranged to record and store the data processed by the system so that a user can analyze and arrange the data when necessary;
the output ends of the abnormal data automatic gathering module and the data screening module are connected with the input end of the log recording module, the output end of the log recording module is connected with the input end of the cloud data storage module, the input end of the log recording module is connected with the output end of the firewall system module, the input end of the data summarizing and converting module is connected with the output end of the log recording module, and the data summarizing and converting module is connected with the data output module.
The working principle is as follows: when the website data automatic matching system is used, according to the figures 1-3, when a retailer needs to convert and match various order data, such as orders, receipts and the like, with data of a supplier, the data which needs to be converted and matched is firstly sent into a data analysis module by a data sending device for preliminary analysis, then a data automatic conversion main program module is started, and data is screened and captured from a website original data database provided with supplier data according to a timing task set in the data automatic conversion main program module, at the moment, the data automatic conversion main program module automatically performs data conversion processing according to maintained conversion relation main data (including retailer main data, store main data, product corresponding main data, product package main data, unit main data, product specification main data, tax rate main data and discount main data) through a data conversion processing module, meanwhile, special rule conversion is carried out according to special conditions, such as monthly data and yearly data of sales data are automatically calculated and converted into daily data and the like, the converted data are analyzed through a data screening module, if the data are not automatically converted, a main program automatically collects the data which are failed to be converted into an abnormal data automatic collecting module, the abnormal data automatic collecting module is used as an execution result record to be written into a log recording module and is used as a reference basis for supplementing and maintaining main data of a conversion relation, then the main program automatically collects the conversion failure data according to the main program, the main data relation conversion module is used for supplementing and maintaining respective main data modules of corresponding platform ends, the data which are failed to be converted are automatically converted again, the data are written into a recording module as execution result records after the conversion is successfully converted, and finally the data output by the data conversion module are summarized through synchronous data of various retailers, and (4) uniformly arranging the data into format files used by the internal standards of the enterprises according to the information of the suppliers, finishing the single data automatic conversion task and continuing the data conversion operation by the user.
Those not described in detail in this specification are within the skill of the art.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.

Claims (1)

1. The utility model provides an automatic matching system of website data, includes data transmission equipment, website original data database, data conversion processing module and data summarization conversion module, its characterized in that: the output end of the data sending equipment is connected with the input end of the data input module, the output end of the data input module is connected with the input end of the data analysis module, the output end of the website original data database is connected with the input end of the automatic data conversion main program module, the input end of the automatic data conversion main program module is connected with the input end of the data analysis module, the input end of the data conversion processing module is connected with the output end of the automatic data conversion main program module, the output end of the data conversion processing module is connected with the input end of the data matching module, the output end of the data matching module is connected with the input end of the data screening module, the output end of the data screening module is respectively connected with the input ends of the abnormal data automatic summarizing module and the log recording module, and the output end of the abnormal data automatic summarizing module is respectively connected with the input ends of the main data relation conversion module and the cloud data storage module The output end of the main data relation conversion module is connected with the input end of the data conversion processing module, the output ends of the abnormal data automatic collection module and the data screening module are both connected with the input end of the log recording module, the output end of the log recording module is connected with the input end of the cloud data storage module, the input end of the log recording module is connected with the output end of the firewall system module, the input end of the data summarization conversion module is connected with the output end of the log recording module, and the data summarization conversion module is connected with the data output module; the data sending equipment comprises a mobile phone end and a computer display end, and the data sending equipment and the data entry module are connected with each other through the Internet; the data processed by the data conversion processing module comprises retailer main data, store main data, product corresponding main data, product package main data, unit main data, product specification main data, tax rate main data and discount main data; the automatic data conversion main program module is internally provided with a timing module and is mutually connected with a website original data database through a network; the processing range of the data conversion processing module comprises automatic conversion processing of various documents on stores, commodities, commodity packages, gifts, units, quantities, tax rates, discount rates and money amounts, and the data conversion processing module performs special rule conversion according to special conditions; the data screening module is respectively connected with the abnormal data automatic summarizing module and the log recording module through data, data which are not passed by the data screening module are transmitted to the abnormal data automatic summarizing module, and data which are passed by the data screening module are transmitted to the log recording module; the cloud data storage module is respectively connected with the abnormal data automatic summarizing module and the log recording module through a network, and the cloud data storage module stores the recorded data in the network in the form of an account number and a password; the main data relation conversion module is used for automatically converting the data which is converted successfully in the abnormal data automatic summarizing module again, and the data which is converted successfully by the main data relation conversion module is used as an execution record and is collected by the log recording module in a connected mode;
when the website data automatic matching system is used, when a retailer needs to convert and match various order data with data of a supplier, data needing to be converted and matched are firstly sent into a data analysis module by data sending equipment through a data entry module for preliminary analysis, then a data automatic conversion main program module is started, and data is screened and captured from a website original data database provided with data of the supplier according to a timing task set in the data automatic conversion main program module, at the moment, the data automatic conversion main program module program automatically performs data conversion processing through a data conversion processing module according to maintained main data of a conversion relation, meanwhile, special rules are converted aiming at special conditions, the converted data are analyzed through a data screening module, if the data automatic conversion is unsuccessful, the data which are failed in conversion are automatically summarized to an abnormal data automatic summarizing module, and writing the data as an execution result record into a log recording module as a reference basis for supplementing and maintaining main data of a conversion relation, automatically summarizing conversion failure data according to a main program, performing supplementary maintenance on respective main data modules of corresponding platform ends through a main data relation conversion module, automatically converting the data failed in conversion again, writing the converted data as an execution result record into a log recording module after the conversion is successful, finally uniformly arranging the output data of the data summarization conversion module into a format file used by an enterprise internal standard according to supplier information through synchronous data of various retailers, finishing a single data automatic conversion task at this moment, and continuing data conversion operation by a user.
CN201811431321.1A 2018-11-26 2018-11-26 Automatic matching system for website data Active CN109584009B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811431321.1A CN109584009B (en) 2018-11-26 2018-11-26 Automatic matching system for website data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811431321.1A CN109584009B (en) 2018-11-26 2018-11-26 Automatic matching system for website data

Publications (2)

Publication Number Publication Date
CN109584009A CN109584009A (en) 2019-04-05
CN109584009B true CN109584009B (en) 2021-10-29

Family

ID=65925078

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811431321.1A Active CN109584009B (en) 2018-11-26 2018-11-26 Automatic matching system for website data

Country Status (1)

Country Link
CN (1) CN109584009B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112863170A (en) * 2020-11-14 2021-05-28 浙江信电技术股份有限公司 Road traffic mobile monitoring system

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1459751A (en) * 2002-05-20 2003-12-03 鸿富锦精密工业(深圳)有限公司 Capacity forecast and ordering sheet data exchange system and method
CN1695152A (en) * 2001-07-05 2005-11-09 电脑联合想象公司 System and method for transforming business process policy data
CN1797443A (en) * 2004-12-25 2006-07-05 鸿富锦精密工业(深圳)有限公司 Data exchange system and method
US20070297684A1 (en) * 2004-12-16 2007-12-27 Mitsubishi Electric Corporation Data Conversion Apparatus, Data Conversion Method, and Data Conversion System
CN101876969A (en) * 2009-12-04 2010-11-03 金蝶软件(中国)有限公司 Report form developing method and device
CN105117881A (en) * 2015-08-21 2015-12-02 山东协通通信技术有限公司 Inventory system suitable for medium and small sized supermarkets
CN107291863A (en) * 2017-06-12 2017-10-24 杭州电子科技大学 A kind of quick check method and device for industrial control equipment information security

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW200625114A (en) * 2004-12-24 2006-07-16 Hon Hai Prec Ind Co Ltd Method and system for interchanging data
US8843497B2 (en) * 2012-02-09 2014-09-23 Linkshare Corporation System and method for association extraction for surf-shopping
CN103309907B (en) * 2012-03-16 2017-02-01 上海安捷力信息系统有限公司 Method and system for standardized processing of service data from different sources
CN104680381B (en) * 2013-12-03 2018-02-27 航天信息软件技术有限公司 A kind of method and system that electronic invoice is quickly generated based on ERP system
CN107230119A (en) * 2016-03-24 2017-10-03 阿里巴巴集团控股有限公司 A kind of data matching method and device
CN107818394A (en) * 2017-09-02 2018-03-20 孟旭 A kind of intelligent marketing system based on technology of Internet of things

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1695152A (en) * 2001-07-05 2005-11-09 电脑联合想象公司 System and method for transforming business process policy data
CN1459751A (en) * 2002-05-20 2003-12-03 鸿富锦精密工业(深圳)有限公司 Capacity forecast and ordering sheet data exchange system and method
US20070297684A1 (en) * 2004-12-16 2007-12-27 Mitsubishi Electric Corporation Data Conversion Apparatus, Data Conversion Method, and Data Conversion System
CN1797443A (en) * 2004-12-25 2006-07-05 鸿富锦精密工业(深圳)有限公司 Data exchange system and method
CN101876969A (en) * 2009-12-04 2010-11-03 金蝶软件(中国)有限公司 Report form developing method and device
CN105117881A (en) * 2015-08-21 2015-12-02 山东协通通信技术有限公司 Inventory system suitable for medium and small sized supermarkets
CN107291863A (en) * 2017-06-12 2017-10-24 杭州电子科技大学 A kind of quick check method and device for industrial control equipment information security

Also Published As

Publication number Publication date
CN109584009A (en) 2019-04-05

Similar Documents

Publication Publication Date Title
CN105321046A (en) Corporate financial management system
CN111967822B (en) Shield tunneling machine service platform, service method and architecture based on WeChat public number
CN111221889B (en) CASS retail data integration service platform
CN107358518A (en) Polymorphic various dimensions are connected associated mode account information collection method
CN109544313A (en) A kind of voucher electronic management system
CN111062799A (en) Method and device for managing family client, electronic equipment and storage medium
CN103856565A (en) E-commerce tax source management cloud collection monitoring method
CN109584009B (en) Automatic matching system for website data
CN110910232B (en) Financial reconciliation system and method
CN101388036A (en) Data table summarizing method and device
CN114119228A (en) Supply chain finance intelligent supervision system based on internet
CN112508682A (en) Method for automatically checking account by intelligent system
US10157091B2 (en) Evaluating and servicing problematic cash-handling machines
CN109656953A (en) A kind of retail data automatic inspection system
CN212515891U (en) Shield machine service platform and framework based on WeChat public number
CN112214536B (en) Enterprise account data real-time import management system
CN201111282Y (en) Tax control system based on network server
CN114461669A (en) Ticket-involved business integrated management system and method
US20140278753A1 (en) System and method for identifying mergers and acquisitions
US9613385B2 (en) System for analyzing device performance data
CN109711797B (en) Method and system for generating business account record according to invoice
CN211454310U (en) Laboratory information management system based on network isolation technology
TWI831114B (en) Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium
Song et al. Research on financial coordinated supervision platform and supervision strategy for online payment under paperless trade
CN115330390A (en) Merchant refund automatic processing method, system, equipment and storage medium based on RPA

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
PE01 Entry into force of the registration of the contract for pledge of patent right
PE01 Entry into force of the registration of the contract for pledge of patent right

Denomination of invention: A website data automatic matching system

Granted publication date: 20211029

Pledgee: China Construction Bank Corporation Shanghai Sixth Branch

Pledgor: SHANGHAI AMT DATA SYSTEM Co.,Ltd.

Registration number: Y2024310000064