Processing method of e-commerce platform address base

Abstract

In order to solve the problem of low order processing efficiency and accuracy caused by inconsistent address information of existing different e-commerce platforms, the invention provides a processing method of an e-commerce platform address library, an OMS address library is established in an address management system, address information with consistent formats is accommodated, and OMS address library information is updated in real time; the order address of the e-commerce platform is regularly extracted for address analysis, the format of the order address is automatically converted during address analysis, and key information is extracted and analyzed into address information adaptive to the OMS address library; and a compensation analysis process is set for the order address which fails in standardization processing, and the missing address level is modified according to the acquisition condition of the existing address level. By establishing a standard OMS address library and a perfect address resolution strategy, automatic standardized processing of address information is realized, and the accuracy of order processing is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of electronic digital data processing, and in particular to a method for processing an address library of an e-commerce platform. Background Art

[0002] In the current e-commerce environment, enterprises need to operate multiple e-commerce platforms at the same time in order to expand their market share. However, there are significant differences in the address information format and content between different e-commerce platforms, which brings many inconveniences to order processing and logistics distribution. The traditional processing method does not process the addresses of each e-commerce platform, directly saves the order information to the OMS system and pushes it to the WMS system, resulting in inconsistent address formats, increasing system complexity and order processing time; or manually checks and converts address information, but this method is inefficient and prone to errors. Due to the inconsistent address information format, the existing technology lacks effective standardized and unified processing methods, resulting in problems such as low order processing efficiency, difficult data analysis, and poor customer experience.

[0003] For example, a "method and device for matching address data" disclosed in Chinese patent documents, with the announcement number CN108733810A, extracts the address coding part of standard address data and sample address data for matching, converts the sample address data into standard address data, and solves the problem that the existing technology cannot effectively match the complex and changeable sample address data. However, this method may have limitations in dealing with the differences in address formats unique to different e-commerce platforms, especially in terms of automated processing and real-time updates. Summary of the invention

[0004] The present invention mainly solves the problem of low order processing efficiency and accuracy caused by inconsistent address information on different existing e-commerce platforms; in this regard, the present invention provides a method for processing the address library of an e-commerce platform, and its technical improvement lies in realizing the automated and standardized processing of address information by establishing a standard OMS address library and a perfect address resolution strategy. It reduces the delivery failure or return caused by address errors, and the automated matching process also reduces the errors caused by human factors, thereby improving the accuracy of order processing.

[0005] The above technical problems of the present invention are mainly solved by the following technical solutions: A method for processing an address library of an e-commerce platform of the present invention comprises: establishing an OMS address library: constructing an OMS address library in an address management system to accommodate address information of a consistent format, and updating the OMS address library information in real time; standardization processing: periodically extracting order addresses of an e-commerce platform for address resolution; during the address resolution process, capturing order addresses and automatically converting the format, extracting key information and resolving it into address information adapted to the OMS address library; setting a compensation resolution process for order addresses that fail standardization processing, and modifying the missing address levels according to the query conditions of the existing address levels.

[0006] Through regular extraction and standardized processing, the format consistency and accuracy of all order address information are ensured, reducing the complexity and errors of data processing caused by inconsistent formats. The OMS address database is based on national standard zoning and urban and rural classification codes, ensuring the authority and timeliness of address information, improving the reliability of the address database and data consistency. The automated conversion and key information extraction of the address resolution process further improves data processing efficiency, allowing order addresses to be quickly and accurately converted into a format that is compatible with the OMS address database. The compensatory resolution process effectively solves the problem of a small number of address information that cannot be correctly parsed due to abnormal formats, ensuring that all order address information can be correctly processed and stored, thereby improving order processing efficiency and reducing error rates.

[0007] Preferably, the compensation resolution process includes: querying all address names in a single order address and arranging them from high to low according to the associated address levels; identifying the highest address level X and the associated address name, and if the address name missing from address level X-0 is queried, associating X-0 with the address name; if the address name missing from address level X-0 is not queried, associating address level X-0 with the address name associated with the original address level X-1, and re-associating the original address level X-1 with the address name associated with the original address level X-2.

[0008] The above design can ensure that even if some levels of information are missing, the system can still reasonably complete the address information and improve the integrity and consistency of the data. It ensures that all order address information can be correctly processed and stored, reducing errors caused by missing or incomplete address information.

[0009] Preferably, the compensation resolution process also includes: the address management system obtains all address levels and associated address names within the regional scope corresponding to the target order address through the address query platform, and establishes an address list, and the information in the address list is accurate to county-level data; performs semantic search in the address list, and traverses the address list to obtain related node information, obtains the search result of the target order address, and re-standardizes the search result.

[0010] The address management system obtains all address levels and associated address names within the region corresponding to the target order address through the address query platform, and establishes an address list with information accurate to the county level. It performs semantic search and traversal within the address list to obtain related node information, which can enhance the robustness and flexibility of the system, optimize resource utilization, simplify maintenance work, and improve data mining capabilities, thereby ensuring the accuracy and completeness of address information and improving order processing efficiency.

[0011] Preferably, the compensation resolution process also includes: the address management system identifies the province or municipality information in the target order address, queries the IP address location, and automatically fills in the province or municipality field, city or municipal county field, and district or autonomous prefecture field.

[0012] By automatically identifying the province or municipality information in the target order address and automatically filling in the province or municipality field based on the IP address location, the accuracy of the address information and the efficiency of filling in can be significantly improved. Automatically identifying the city or city-level county field and intelligently filling it based on the existing information, as well as the system automatically identifying the district or autonomous prefecture information and automatically completing it based on the existing information, further enhances the intelligence level of the system, reduces the need for manual intervention, improves the efficiency and accuracy of data processing, and also improves the user experience, ensuring smoother and more reliable order processing.

[0013] Preferably, the compensation analysis process further includes: extracting key fields including fields representing address levels in the address information, classifying the fields according to corresponding address levels, arranging them according to the adaptation format of the OMS address library, and inputting them into the OMS address library.

[0014] The address management system can ensure that the address information is highly structured and standardized by extracting key fields and classifying the fields representing the address level in the address information according to the corresponding address level and arranging them according to the adaptive format of the OMS address library, thereby improving the accuracy and efficiency of data processing. For order addresses that fail to be standardized, they are automatically completed according to preset rules, which can effectively solve the problem of incomplete address information, reduce the need for manual intervention, and further improve the degree of automation of order processing. This design not only enhances the intelligent processing capabilities of the system, but also improves the user satisfaction of the overall system, ensuring data consistency and efficient operation of the system.

[0015] Preferably, the process of establishing the OMS address database also includes: establishing the OMS address database based on the district divisions and urban-rural classification codes of the area corresponding to the order address; the OMS system receives address information in a standard format, and the address management system performs regular verification and addition, deletion, modification and check of the address information in the OMS address database with a period of T.

[0016] By establishing an OMS address database in the address management system based on the zoning and urban-rural classification codes of the region corresponding to the order address, the address database can be highly standardized and consistent. The address information in the OMS address database is regularly verified and added, deleted, modified and checked with a period of T, which can continuously maintain the accuracy and timeliness of the address database. This design not only improves the reliability of address information, but also enhances the maintainability and scalability of the system, ensures data quality in long-term operation, supports more efficient order processing and logistics distribution, and reduces maintenance costs, improving the overall stability of the system.

[0017] Preferably, the method further includes pre-processing the order address before standardization: the address management system is connected to the e-commerce platform, the order addresses in the platform address library are captured, and spaces and special characters are removed from all order addresses; the address management system verifies the order address in the database of the e-commerce platform, and corrects the erroneous information in the order address based on semantic screening. Before standardization, the order address is pre-processed, including removing spaces and special characters. The address information can also be further cleaned and standardized to ensure the consistency and standardization of the address structure. Specifically: in addition to removing spaces and special characters, it is also possible to remove redundant punctuation marks and repeated separators (such as redundant commas, semicolons, etc.) to ensure that the address information is concise and clear; convert all characters into a unified encoding format, such as converting all letters to lowercase or uppercase to ensure the consistency of character encoding.

[0018] Common address abbreviations can be further converted to standard forms, such as replacing "Rd." with "Road" and "St." with "Street" to ensure the consistency of address abbreviations; in the preprocessing process, missing address components can be supplemented through an intelligent filling mechanism, such as inferring and supplementing missing district or street names based on existing information; using specific separators (such as commas or spaces) to separate different address levels to ensure a clear structure of address information. Through these preprocessing steps, the cleanliness and consistency of data can be significantly improved, errors and interference factors in subsequent processing can be reduced, and the structure of address information can be standardized, thereby improving the efficiency and accuracy of order processing.

[0019] Preferably, the standardization process includes: setting fixed separators between the address strings of each level of the standardized order address, splicing the address names through separators in the order of address levels; and dividing the address levels according to the key fields. The advantage of this is that it improves the consistency and readability of the address information, simplifies the subsequent processing steps, and facilitates the system to quickly and accurately identify and process each address level, thereby improving the overall processing efficiency.

[0020] Preferably, the standardization process further includes: capturing order addresses in N cycles, converting the order addresses into a unified format and extracting key fields; arranging the address levels and address names from high to low according to the fixed address levels. The advantage of this is that it reduces processing errors caused by inconsistent formats, allowing the system to manage and parse address information more efficiently.

[0021] As a preferred method, the method further includes: the address management system is set in the OMS system; the OMS system receives the address information stored in the OMS address database and stores it in the order information table; the OMS system sends the order information table to the WMS system; the WMS system parses the address information and generates a distribution plan based on the order information table. The advantage of such a setting is that the reliability and execution efficiency of the distribution plan are improved, and distribution errors or delays caused by inconsistent address information are reduced.

[0022] The beneficial effects of the present invention are: 1. A method for processing an e-commerce platform address library of the present invention can significantly improve order processing efficiency and reduce order processing error rate. Through a standard OMS address library and a complete address resolution strategy, the address management system can convert order addresses of different e-commerce platforms into standard OMS addresses, thereby realizing standardization and automation of order address processing; this not only reduces the manual review and modification time of address information, allowing orders to enter the delivery link faster, but also reduces delivery delays caused by mismatched address information through the intelligent matching function, thereby significantly improving the overall order processing efficiency; in addition, standardized processing ensures the accuracy and consistency of address information, reduces delivery failures or returns caused by address errors; the automated matching process also reduces errors caused by human factors, and improves the accuracy of order processing.

[0023] 2. The method for processing the address library of an e-commerce platform of the present invention can improve customer satisfaction and reduce operating costs. Standardized processing and automated address management not only improve the accuracy and speed of delivery services, but also significantly improve customers' shopping experience, and enhance customers' trust and loyalty to the e-commerce platform; reduce customer complaints and disputes caused by address problems, and maintain the good image of the e-commerce platform; at the same time, by reducing the workload of manual review and modification, the manpower cost of the enterprise in order processing is reduced, the order processing efficiency and accuracy are improved, and it is helpful to reduce the additional costs and losses caused by delivery errors; unified address library management also strengthens the protection of address information, prevents data leakage and abuse, and strict permission control ensures that only authorized users can access and process address information, thereby enhancing data security. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1It is a flow chart of a method for processing an e-commerce platform address library according to the second embodiment of the present invention.

[0025] Figure 2 This is a compensation analysis flow chart of the second embodiment of the present invention.

[0026] Figure 3 It is a business flow chart of the method for processing the e-commerce platform address library of the first embodiment of the present invention. DETAILED DESCRIPTION

[0027] The technical solution of the present invention is further specifically described below through embodiments and in conjunction with the accompanying drawings.

[0028] Embodiment 1: Please refer to Figure 3 In order to solve the problems of low order processing efficiency and delivery errors caused by inconsistent address information on different e-commerce platforms, this embodiment provides a method for processing an e-commerce platform address library, which realizes automated and standardized processing of address information on different e-commerce platforms by establishing a standard OMS address library and a complete address resolution strategy.

[0029] First, create the OMS address database: The OMS address database is established based on the national statistical division and urban-rural classification codes published by the National Bureau of Statistics. The OMS address database is set in the address management system, which provides address database management functions, allowing merchants to view, edit, and delete addresses in the address management system. Real-time update and management of address data is achieved to ensure the latest and consistency of data. The address management system uses address resolution strategies to match and verify address data, effectively identifying and correcting erroneous or inconsistent address information. Because the address management system sets up the OMS address database and address resolution strategy, it can support the access of address database data from multiple e-commerce platforms, realizing cross-platform address data sharing and unified processing. Merchants can manage and process orders from different platforms on a unified interface.

[0030] The above design can ensure that the information in the address database is up to date and in compliance with national standards, avoiding errors caused by old data. Merchants can manage address information directly in the address management system, which improves management efficiency. In addition, real-time updates ensure that the address database is always up to date, reducing the lag caused by manual updates. The address management system can receive and parse address data from different e-commerce platforms. By setting a standardized algorithm through the built-in OMS address database, the address management system converts these address data into a standard and unified format to ensure the consistency of address information.

[0031] Create an address resolution policy: Design a set of address resolution strategies based on the OMS address database. Including but not limited to automatic completion of provinces, cities, districts, and streets. Including the processing of municipalities, county-level cities, and autonomous prefectures. Provide custom rule setting functions, allowing merchants to adjust the processing rules of address information according to actual needs, automate address completion operations, reduce manual input errors, and speed up processing. Allow merchants to adjust address processing rules according to their own business needs to adapt to different scenarios. Ensure that all address information is parsed according to unified rules, improving data consistency and readability.

[0032] Complete address resolution strategy: Address collection and preprocessing: The address management system connects with multiple e-commerce platforms through API interfaces, and regularly captures the address database information of each platform. All addresses are preprocessed (such as removing spaces, processing special characters, etc.), and prepare for the subsequent standardization and verification process.

[0033] Address standardization: convert the format of all captured address information and extract key information. Resolve the address into the address of the OMS address database according to the address resolution strategy.

[0034] Improve the address resolution strategy: If a small number of addresses fail to be standardized and the corresponding OMS address cannot be found, set the function according to the provided custom rules. Adjust the processing rules of address information according to actual needs and supplement the address resolution strategy. Ensure that the addresses of each e-commerce platform can be converted into OMS addresses according to the resolution strategy.

[0035] Preprocessing removes unnecessary characters, reducing interference factors in subsequent processing. Ensure that all address information is processed in a unified format, improving data consistency. Even if a few addresses cannot be directly standardized, the problem can be solved through custom rules to ensure that all address information can be correctly parsed.

[0036] In the process of order address standardization: users place orders on different e-commerce platforms. It is known that the address management system is set up in the OMS system. The order first passes through the address management system, and through the address resolution strategy, the e-commerce platform address is converted into a standard OMS address and then pushed to the OMS system. The OMS system stores the order, including the order address information, and pushes the order to the WMS system after completing other business processes. The WMS system generates a delivery plan based on the standardized address information provided by the OMS system.

[0037] The benefit is that the standardized address information ensures more efficient order management. The seamless connection between the address management system and the WMS system improves the accuracy and efficiency of logistics distribution. Standardized address information reduces delivery errors and improves customer satisfaction. Through the above steps, the standardized processing of address information can be effectively achieved, order processing efficiency can be improved, data analysis results can be improved, and customer experience can be enhanced. Each step has clear benefits to ensure that the entire process is both efficient and accurate. In addition, the OMS address database and the address management system in which it is located have the function of dynamically updating and maintaining the address database. At the same time, data encryption and anonymization processing technology are used in the address resolution process to ensure user privacy and security. In addition, if a resolution failure occurs during the address resolution process, an email or text message will be sent immediately to the processing personnel to ensure the timeliness of the event processing.

[0038] Embodiment 2: Please refer to Figure 1 and Figure 2 , a method for processing an e-commerce platform address library in this embodiment further improves Example 1 on the basis of Example 1 and describes it in more detail.

[0039] This embodiment realizes the unified and standardized processing of address information of different e-commerce platforms by establishing an OMS address database, a standardized processing process and an address resolution process. The specific steps are as follows.

[0040] First, establish an OMS address database based on the national statistical divisions and urban-rural classification codes published by the National Bureau of Statistics to ensure that the address database can accommodate address information with consistent formats and support real-time update and management functions. The OMS address database is set up inside the address management system, which receives address information based on divisions and urban-rural classification codes and stores it in the OMS address database; the address information in the OMS address database is regularly verified and added, deleted, and modified with a period of T.

[0041] Doing so not only ensures that the information in the address database is up to date and in compliance with national standards, avoiding errors caused by old data, but also ensures that the address database is always up to date through the real-time update function, reducing the lag caused by manual updates. At the same time, the address management system provides powerful management functions, allowing merchants to view, edit, and delete address information in the OMS system, improving management efficiency. Periodic scheduled verification and addition, deletion, modification, and query operations further ensure the consistency and accuracy of the data, thereby improving the efficiency and reliability of overall order processing.

[0042] When executing the standardized processing, the order address is captured in N cycles, where N can be a time unit such as minutes, hours, or a whole day. This ensures that the system updates the order address information regularly and in a timely manner. After the order address is converted into a unified format, the key information is extracted; the unified format is arranged from high to low according to the fixed address level (such as province, city, district / county, street, etc.). The benefit of this approach is that it can ensure the consistency and readability of all order address information, thereby improving the efficiency and accuracy of data processing.

[0043] The address management system is connected to the e-commerce platform, and the order addresses in the platform address library are captured, and spaces and special characters are removed from all order addresses. The benefit of this step is that by removing unnecessary characters, interference factors in subsequent processing are reduced, making the address information more concise and clear. The order address is verified in the e-commerce platform database, and the erroneous information in the order address is corrected based on semantic screening. This can improve the accuracy of the data, reduce order processing problems and logistics delivery delays caused by incorrect address information, and thus improve the overall order processing efficiency and customer satisfaction.

[0044] During the address resolution process, the standardized order address is automatically converted to a different format, and key information is extracted and resolved into address information that is compatible with the OMS address library. A compensation resolution process is set up for order addresses that fail standardization, and the missing address levels are appropriately modified based on the settings of the existing address levels.

[0045] The above design can be described in detail as follows: during the address resolution process, the address management system will automatically convert the format of the standardized order address, extract key information, and resolve it into address information that is compatible with the OMS address library. This includes but is not limited to format conversion of all order addresses to ensure that each address information is arranged in a unified format, that is, arranged from high to low according to a fixed address level (such as province, city, district / county, street, etc.). Extract key information of each address (such as province, city, district / county, street, etc.) to ensure that each piece of information is accurate.

[0046] In addition, the pre-set address parsing strategy is used to parse the extracted key information into address information that is compatible with the OMS address library. Ensure that the format and content of each address information conform to the standards of the OMS address library. These order addresses usually fail to pass the standard processing flow because they lack certain key address levels or the format does not match. The compensation parsing process includes obtaining all address levels and corresponding address names within the area associated with the target order address, establishing an address list, and accurately retrieving county-level data. Perform semantic search in the list, traverse the list to obtain the associated node information, and obtain the search results for the target order address. Re-standardize the search results to ensure that all address information can be correctly parsed.

[0047] If a certain address level (such as district / county) is missing in a certain order address, but lower-level address information (such as street) is identified, the missing address level will be modified appropriately according to the settings of the existing address levels. For example, if "province" and "street" are identified, but "city" and "district / county" are missing, the "city" and "district / county" levels will be supplemented through the compensation resolution process, and the "street" level will be placed correctly. During the supplementation process, the original high-level address is kept unchanged, the original lower-level address is moved back and associated with the lower-level address, and the missing level in the middle is supplemented.

[0048] The logic of automatic completion is: query all address names in a single order address and arrange them from high to low according to the associated address levels; identify the highest address level X and the associated address name, and if the address name missing from address level X-0 is found, associate X-0 with the address name; if the address name missing from address level X-0 is not found, associate address level X-0 with the address name associated with the original address level X-1, and re-associate the original address level X-1 with the address name associated with the original address level X-2.

[0049] That is, when it is necessary to add intermediate-level content, if it is recognized that the intermediate level X-0 is missing between the original high-level address X and the lower-level address level X-1, and address level X-2 is recognized, the original high-level address X is kept unchanged, the original X-1 is shifted back one position and associated with address level X-2, and the intermediate-level address level X-0 is supplemented.

[0050] When supplementing the intermediate level X-0, address level X-0 is associated with the address name originally associated with address level X-1, and X-1 is disassociated from the originally associated address name. Address level X-2 is disassociated from the originally associated address name, and then the address name is associated with address level X-1.

[0051] This design has several significant advantages: First, it significantly reduces missing items in address information through automatic completion logic, ensuring that each necessary address level is supplemented, thereby enhancing data integrity. Second, the automatic completion logic ensures that all address information is processed in a unified standard format, improving data consistency and readability, and reducing the possibility of human input errors, making address information more reliable. In addition, automated processing not only reduces the need for human intervention, but also improves processing efficiency. The system can quickly identify and process missing information, speeding up order processing.

[0052] At the same time, this design maintains data consistency, ensures the consistency of all address information across different e-commerce platforms, and avoids data confusion caused by inconsistent formats. The easily extensible design makes it easier to add new address levels or adjust rules in the future, simplifies the management and maintenance of address information, and reduces operation and maintenance costs. In addition, accurate address information improves the user's shopping experience, reduces delays in logistics and distribution, improves customer satisfaction, and facilitates data analysis, which helps companies better understand market distribution and service needs. High-quality data also helps to make more accurate business decisions. Because the address management system is set up within the OMS system, it will eventually input the processed addresses in the OMS address library into the OMS system to store and generate an order information table, which will be sent from the OMS system to the WMS system to execute the order. Therefore, the automatic completion logic in the address management system also enables the OMS system to seamlessly connect with the WMS system, improving the collaborative efficiency of the overall system.

[0053] Embodiment 3: The processing method of the e-commerce platform address library provided in this embodiment is illustrated with reference to Example 1. In the current e-commerce environment, enterprises often need to operate multiple e-commerce platforms at the same time to expand their market share. However, there are differences in the address information format, content, etc. between different e-commerce platforms. This has brought many inconveniences to order processing and logistics distribution. In order to illustrate the application effect of the method of the present invention, the following takes "Sanlitun Street, Chaoyang District, Beijing" as an example to show the method of the present invention for the defects of municipality addresses and the process of format unification of addresses containing municipalities.

[0054] Taobao order address example: Province: Beijing, City: Beijing, District: Chaoyang District, Street: Sanlitun Street. JD.com order address example: Province: Beijing, City: Chaoyang District, District: Sanlitun Street. Douyin order address example: Province: Beijing, City: Beijing, District: Chaoyang District, Street: Sanlitun Street.

[0055] According to the above three example addresses, the definition of address levels for multi-platform addresses is not unified. Therefore, the following method is used to solve the problem. First, an OMS address library is established based on the regional divisions and urban and rural classification codes. The OMS address library can accommodate address information with consistent formats, and the address management system updates and manages the functions in real time. Next, the order addresses of the e-commerce platform are extracted regularly and the format is standardized. The order addresses are captured in set time units, such as minutes, hours or full days, and the key information is extracted after the order addresses are converted to a unified format. The unified format is arranged from high to low according to the fixed address level. The system where the OMS address library is located is connected to the e-commerce platform to capture the order addresses of the platform address library and remove spaces and special characters from all order addresses. The order address is verified in the e-commerce platform database, and the erroneous information in the order address is corrected based on semantic screening.

[0056] For the order addresses in the above examples, the results after standardization are as follows: Taobao order address: Province: Beijing, City: Beijing, District: Chaoyang District, Street: Sanlitun Street. JD.com order address: Province: Beijing, City: Beijing, District: Chaoyang District, Street: Sanlitun Street. Douyin order address: Province: Beijing, City: Beijing, District: Chaoyang District, Street: Sanlitun Street. As you can see, all order addresses have been converted into a unified format.

[0057] The logic of the modified format reference is: automatically complete the correct address level X and the corresponding address name in a single order address. If the address level X-1 below the address level X is not recognized, and the address level X-2 is recognized, the address name corresponding to the address level X-2 is associated with the address level X-1, and the association between the address level X-2 and the original address name is cancelled. That is, if the middle level address between the two address levels is not recognized, the lower level address level is raised by one level, and the corresponding key fields are also modified synchronously.

[0058] For example, during the identification process of Taobao order address information and Douyin order address information, it was found that all address levels could be correctly identified, so no modification was required.

[0059] When identifying the address of JD.com orders, it can be found that the "city" is missing between the "province" and the "district", but both the "province" and the "district" are identified. Therefore, the "Chaoyang District" at the "district" level is first associated with the "city" level, and the "Chaoyang District" at the "district" level is unassociated with the original address name. Further analysis shows that due to the duplication of the "street" level, deduplication is required.

[0060] For order addresses that fail to be standardized, a compensation analysis process is set up. For example, if the "city" field is missing in a JD order, the system will obtain all address levels and corresponding address names within the target order address's associated region through the compensation analysis process, establish an address list, perform semantic search, traverse the list to obtain associated node information, obtain the search results for the target order address, and re-standardize the search results.

[0061] That is, the province or municipality information in the target order address is automatically identified, and the province or municipality field is automatically filled in according to the IP address location; the city or city-level county field is automatically identified and intelligently filled in according to the existing information; the system automatically identifies the district or autonomous prefecture information, and the system automatically completes it according to the existing information.

[0062] Special treatment for municipalities: If the city in the platform address is not one of the four municipalities directly under the central government, namely Beijing, Shanghai, Chongqing and Tianjin, the city in the address will be moved to the district, the district will be moved to the street, and the city will be automatically filled in.

[0063] For automatic completion of province / city / district / county / state / street / autonomous prefecture: For example, the address of a Taobao order is: Province: Zhejiang Province, City: Hangzhou City, District: Binjiang District. The address of a JD order is: Province: Zhejiang Province, City: Hangzhou City, District: Binjiang District. The unified processing is: Province: Zhejiang Province, City: Hangzhou City, District: Binjiang District.

[0064] Special treatment for county-level administrative units directly under the province: For county-level administrative units directly under the province: City and District are automatically filled with the corresponding county-level administrative units directly under the province. For example: The address of Taobao order is: Province: Hubei Province, City: Xiantao City, District: Blank, Street: Shazui Street. The address of Pinduoduo order is: Province: Hubei Province, City: County-level administrative division directly under the province, District: Xiantao City, Street: Shazui Street. The unified treatment is: Province: Hubei Province, City: Xiantao City, District: Xiantao City, Street: Shazui Street.

[0065] Finally, the address information stored in the OMS address database is sent to the OMS system, the OMS system is associated with the WMS system, and the WMS system parses the address information and generates a distribution plan based on the unified address information. Through the above steps, the present invention can effectively solve the problem of inconsistent address information formats on different e-commerce platforms, improve order processing efficiency, improve data analysis results, and enhance customer experience.

[0066] Embodiment 4: The processing method of the e-commerce platform address library provided in this embodiment is illustrated by example with respect to Embodiment 1. In the following, taking "Xin'anjiang Street, Jiande City, Hangzhou City, Zhejiang Province" as an example, the process of format unification of the address defects that may occur in prefecture-level cities by the method of the present invention is demonstrated.

[0067] Taobao order address example: Province: Zhejiang, City: Hangzhou, District: Jiande, Street: Xin'anjiang Street. JD.com order address example: Province: Zhejiang, City: Jiande, District: Xin'anjiang Street. Douyin order address example: Province: Zhejiang, City: Hangzhou, Street: Xin'anjiang Street.

[0068] The problems are that in JD.com orders, the "city" field is filled with "Jiande City" instead of "Hangzhou City". We need to use the automatic recognition function to intelligently fill in the correct "city" field based on the existing information and classify "Jiande City" into the correct "district / county" field. In addition, in Douyin orders, there is no description of the district-level address Jiande City, so the information needs to be automatically completed based on the IP address.

[0069] The unified address format is as follows: Taobao order address: Province: Zhejiang, City: Hangzhou, District: Jiande, Street: Xin'anjiang Street. JD order address: Province: Zhejiang, City: Hangzhou, District: Jiande, Street: Xin'anjiang Street. Douyin order address: Province: Zhejiang, City: Hangzhou, District: Jiande, Street: Xin'anjiang Street.

[0070] For JD.com orders, the automatic identification logic is as follows: first identify the existing information. It is known that the "Province" field corresponds to "Zhejiang", the "City" field corresponds to "Jiande City", and the "District / County" field corresponds to "Xin'anjiang Street". During the identification process, if the "Province" field is "Zhejiang" and "Jiande City" appears in the "City" field, the system automatically identifies "Jiande City" as a district / county level. In Zhejiang Province, "Jiande City" is under the jurisdiction of Hangzhou City, so the "City" field should be "Hangzhou City". The system moves "Jiande City" from the "City" field to the "District / County" field and moves the street back.

[0071] For Douyin orders, its automatic identification logic is: when identifying the existing information, it is found that the field corresponding to the "district" is missing, so the "district" level address under the jurisdiction of "Xin'anjiang Street" is directly queried in the IP address, and it is identified as "Jiande City" and completed and associated with the "district" address level.

[0072] Embodiment 5: The processing method of the e-commerce platform address library provided in this embodiment is illustrated by example with respect to Embodiment 1. In the following, taking "Hexi Street, Kangding City, Ganzi Tibetan Autonomous Prefecture, Sichuan Province" as an example, the process of format unification of the method of the present invention for address defects that may occur in a district or autonomous prefecture is demonstrated.

[0073] Taobao order address example: Province: Sichuan, City: Ganzi Tibetan Autonomous Prefecture, District: Kangding City, Street: Hexi Street. JD.com order address example: Province: Sichuan, City: Kangding City, District: Hexi Street. Douyin order address example: Province: Sichuan, City: Ganzi Tibetan Autonomous Prefecture, District: Hexi Street.

[0074] For Taobao order address: The address information format is relatively complete, but it should be noted that the "city" field is filled in with "Ganzi Tibetan Autonomous Prefecture", and the "district" field is filled in with "Kangding City". Although this is also correct, in some cases, this statement may cause some confusion in understanding. However, in general, the address information format is relatively standard and there are no obvious problems.

[0075] For JD.com order addresses: "Kangding City" is filled in the "City" field instead of "Ganzi Tibetan Autonomous Prefecture" because according to the IP address query, Kangding City is actually a county-level city under the jurisdiction of Ganzi Tibetan Autonomous Prefecture, not a prefecture-level city. Therefore, the correct "City" field should be "Ganzi Tibetan Autonomous Prefecture", and "Kangding City" should be filled in as the "District / County" level.

[0076] For the address of Douyin orders: "Hexi Street" is filled in the "District" field instead of "Kangding City". Because according to the IP address query, Hexi Street is a street office in Kangding City, and should be filled in as the "Street" level. "Kangding City" is a district / county level and should be placed in the "District / County" field.

[0077] In order to solve the above problem, the following modifications are made: For the "city" address level, if the name of a county-level city appears in the "City" field (such as "Kangding City"), the system will automatically identify which autonomous prefecture the county-level city belongs to (such as "Ganzi Tibetan Autonomous Prefecture") and move it to the "District / County" field, and fill in the name of the autonomous prefecture in the "City" field.

[0078] For the "District" address level, if the name of a street appears in the "District" field (such as "Hexi Street"), the system automatically identifies which district / county level the street belongs to and moves it to the "Street" field, and fills in the district / county level in the "District / County" field.

[0079] The compensation resolution process includes: for order addresses that fail standardization processing, a compensation resolution process is set up to obtain all address levels and corresponding address names within the target order address associated area, establish an address list, perform semantic search, traverse the list to obtain associated node information, obtain the search results for the target order address, and re-standardize the search results.

[0080] The unified address format is as follows: Taobao order address: Province: Sichuan, City: Ganzi Tibetan Autonomous Prefecture, District: Kangding City, Street: Hexi Street. JD.com order address: Province: Sichuan, City: Ganzi Tibetan Autonomous Prefecture, District: Kangding City, Street: Hexi Street. Douyin order address: Province: Sichuan, City: Ganzi Tibetan Autonomous Prefecture, District: Kangding City, Street: Hexi Street.

[0081] It should be understood that the embodiments are only used to illustrate the present invention and are not used to limit the scope of the present invention. In addition, it should be understood that after reading the content taught by the present invention, those skilled in the art can make various changes or modifications to the present invention, and these equivalent forms also fall within the scope limited by the appended claims of the application.

Claims

1. A method for processing an address database of an e-commerce platform, characterized in that: include: Establish an OMS address database: Build an OMS address database in the address management system to store address information in a consistent format and update the OMS address database information in real time; Standardized processing: Regularly extract order addresses from e-commerce platforms for address resolution. During the address resolution process, the order address is automatically converted to a different format, and key information is extracted and resolved into address information that is compatible with the OMS address library. Set up a compensation resolution process for order addresses that fail standardization processing, and modify the missing address levels based on the query results of the existing address levels.

2. The method for processing an e-commerce platform address database according to claim 1, characterized in that: The compensation analysis process includes: Query all address names in a single order address and sort them from high to low according to the associated address level; Identify the highest address level X and the associated address name. If the address name missing from address level X-0 is found, associate X-0 with the address name. If the address name missing from address level X-0 is not found, associate address level X-0 with the address name associated with the original address level X-1, and re-associate the original address level X-1 with the address name associated with the original address level X-2.

3. A method for processing an e-commerce platform address database according to claim 1 or 2, characterized in that: The compensation analysis process also includes: The address management system obtains all address levels and associated address names within the region corresponding to the target order address through the address query platform, and establishes an address chain list. The information in the address chain list is accurate to county-level data. Perform semantic search in the address list, traverse the address list to obtain related node information, obtain the search result of the target order address, and re-standardize the search results.

4. The method for processing an e-commerce platform address database according to claim 3, characterized in that: The compensation analysis process also includes: The address management system identifies the province or municipality information in the target order address, queries the IP address location, and automatically fills in the province or municipality field, city or county field, and district or autonomous prefecture field.

5. The method for processing an e-commerce platform address database according to claim 4, characterized in that: The compensation analysis process also includes: The key fields to be extracted include fields representing address levels in the address information. The fields are classified according to the corresponding address levels, arranged in accordance with the adaptation format of the OMS address library, and input into the OMS address library.

6. The method for processing an e-commerce platform address database according to claim 1, characterized in that: The process of establishing an OMS address database also includes: Establish an OMS address database based on the district division and urban-rural classification code of the area corresponding to the order address; The OMS system receives address information in a standard format, and the address management system performs regular verification and addition, deletion, modification and query of the address information in the OMS address database at a period of T.

7. The method for processing an e-commerce platform address database according to claim 1, characterized in that: It also includes pre-processing of order addresses before standardization: The address management system is connected to the e-commerce platform to capture the order addresses in the platform address database and remove spaces and special characters from all order addresses; The address management system verifies the order address in the e-commerce platform's database and corrects the erroneous or missing information in the order address based on semantic screening.

8. The method for processing an e-commerce platform address database according to claim 1, characterized in that: The standardization process includes: Fixed separators are set between the address strings of each level of the standardized order address, and the address names are concatenated by separators in the order of address levels; the address levels are divided according to the corresponding key fields.

9. A method for processing an e-commerce platform address database according to claim 1 or 8, characterized in that: The standardization process also includes: Capture order addresses in a cycle of N, convert the order addresses into a unified format and extract key fields; arrange address levels and address names from high to low according to fixed address levels.

10. The method for processing an e-commerce platform address database according to claim 1, characterized in that: Also includes: The address management system is set up in the OMS system; The OMS system receives the address information stored in the OMS address database and stores it in the order information table. The OMS system sends the order information table to the WMS system. The WMS system parses the address information and generates a delivery plan based on the order information table.

Images