A customer update management system based on big data

By designing a customer update management system based on big data, collecting and analyzing customer data in real time, the problems of complex data processing, poor reference and information security risks in the existing system are solved, and efficient data processing and customer information protection are achieved.

CN118152413BActive Publication Date: 2025-02-07JIANGSU YUNJIHUI SOFTWARE TECH CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
CN202410279951.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-03-12
Publication Date
2025-02-07
Estimated Expiration
2044-03-12

AI Technical Summary

Technical Problem

The existing customer information update management system has problems such as complicated data processing, poor reference of processing results, and hidden dangers in customer personal information.

Method used

A customer update management system based on big data is designed, including customer information acquisition module, customer information analysis module, customer consumption record module and customer information update module. By collecting and analyzing customer data in real time, it provides dynamically updated consumer reports, and Update and delete customer information in real time in the database.

Benefits of technology

It improves data processing efficiency, enhances the reference of processing results, and effectively protects customer personal information, reducing the risk of information leakage.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118152413B_ABST
    Figure CN118152413B_ABST
Patent Text Reader

Abstract

The present invention provides a customer update management system based on big data, which belongs to the field of information management and solves the problem of poor reference of customer information processing results. The specific method is as follows: obtaining customer personal information, completed order information and historical order information to obtain customer initial information; analyzing the consumption expenditure and consumption potential of the customer initial information to obtain a primary customer consumption report; a customer consumption record module obtains additional order information of the customer, corrects the primary customer consumption report, and obtains the customer consumption report; the customer monitors whether the customer initial information has changed; if not, updating the historical customer information according to the customer consumption report; if changed, updating the historical customer information according to the changed customer initial information; the present invention acquires and processes customer personal and order information, analyzes the customer's consumption willingness and consumption potential, and enables the enterprise to timely understand customer behavior and demand to adjust production and sales plans.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention discloses a customer update management system based on big data, which relates to the technical field of customer management. Background Art

[0002] The existing management systems or methods for updating customer information have the following deficiencies:

[0003] 1. Complex data processing: Existing management systems or methods for updating customer information need to process a large amount of data, but enterprises may not be able to make full use of this data, resulting in information overload and waste of computing power. At the same time, the processed data occupies too much data space, increasing the pressure on data processors.

[0004] 2. The processing results are not of good reference value: the existing management systems or methods for updating customer information cannot achieve real-time dynamic updates of customer information and cannot judge the customer's consumption willingness and potential, making the merchant's product push work counterproductive.

[0005] 3. Citizens’ personal information security: According to the authorization publication number CN113468194B, “A customer relationship management data update system and method based on big data” is published. During the implementation of this invention, it is necessary to obtain the customer’s facial and payment data, which poses a risk of leakage of customer personal information and property information. Summary of the invention

[0006] In view of the shortcomings of the prior art, the purpose of the present invention is to provide a customer update management system based on big data, aiming to solve the problems of slow updating of customer information and poor reference of processing results.

[0007] In order to achieve the above object, the present invention is implemented through the following technical solutions:

[0008] A customer update management system based on big data includes:

[0009] Customer information acquisition module: used to obtain the customer's personal information, completed order information and historical order information, and obtain the customer's initial information;

[0010] Customer information analysis module: used to analyze the consumption expenditure and consumption potential of the customer's initial information and obtain the primary customer consumption report;

[0011] Customer consumption record module: used to obtain additional order information of customers, modify primary customer consumption reports, and obtain customer consumption reports;

[0012] Customer information update module: used to monitor whether the customer's initial information has changed; if it has not changed, the historical customer information is updated according to the customer's consumption report; if it has changed, the changed customer's initial information is used as the update information, and the historical customer information is updated according to the update information;

[0013] Database: used to store customer information, store statistics, minimum income indicators and total number of residents in different regions, as well as GDP and customer information retention period values.

[0014] Furthermore, the workflow of the customer information acquisition module is as follows:

[0015] The customer uploads the data of the communication software, payment software and shopping software in the mobile terminal to the customer information acquisition module; the customer information acquisition module obtains the customer's name, address and ID number by reading the communication software data uploaded by the customer; and obtains the customer's total income amount, total expenditure amount and all order information by reading the payment software data uploaded by the customer;

[0016] Order information includes: order time, recipient, product name, store name, payment amount and delivery address;

[0017] The customer information acquisition module acquires the current system time and extracts the year information of the current system time as the reference year; the customer information acquisition module extracts the order information whose "order time" year is the same as the "reference year" from all order information to obtain the completed order information;

[0018] The customer information acquisition module takes the order information with different "order time" year and "reference year" in all order information as historical order information;

[0019] The customer information acquisition module uses the customer's name, address, mobile phone number, total income amount and total expenditure amount as the customer's personal information;

[0020] The customer information acquisition module sends the customer's personal information, completed order information and historical order information as customer information to the customer information analysis module.

[0021] Furthermore, the workflow of the customer information analysis module is as follows:

[0022] The customer information analysis module extracts the customer's name, address, total income amount and total expenditure amount from the customer's initial information; the customer's name and address are recorded as reference name and reference address respectively; the total income amount is recorded as I, and the total expenditure amount is recorded as E;

[0023] The customer information analysis module performs consumption expenditure analysis on the customer's initial information, executes processes A1 to A9, and obtains a primary customer consumption expenditure analysis report;

[0024] The customer information analysis module analyzes the consumption potential of the customer's initial information, executes processes B1 to B7, and obtains a primary customer consumption potential expenditure report;

[0025] The customer information analysis module sends the customer personal information, "primary customer consumption expenditure analysis report" and "primary customer consumption potential expenditure report" as primary customer consumption reports to the customer consumption record module.

[0026] Furthermore, the process of the customer information analysis module performing consumption expenditure analysis on the customer's initial information is as follows:

[0027] Process A1: The customer information analysis module reads the quantity of all order information in the completed order information, recorded as Cm;

[0028] Process A2: The customer information analysis module extracts the product name, store name and payment amount from the completed order information;

[0029] Process A3: The customer information analysis module reads the store statistics in the database; based on the "product name and store name in the completed order information" and combined with the store statistics, reads the number of customers of different consumption types and the payment amount:

[0030] Living expenses: number of orders, recorded as C1, and payment amount, recorded as E1;

[0031] Luxury goods consumption: number of orders, recorded as C2, and payment amount, recorded as E2;

[0032] Entertainment consumption: number of orders, recorded as C3, and payment amount, recorded as E3;

[0033] Education consumption: number of orders, recorded as C4, and payment amount, recorded as E4;

[0034] Health care consumption: number of orders, recorded as C5, and payment amount, recorded as E5;

[0035] Digital consumption: number of orders, recorded as C6, and payment amount, recorded as E6;

[0036] Environmental consumption: number of orders, recorded as C7, and payment amount, recorded as E7;

[0037] Among them, “C1, C2, C3, C4, C5, C6, C7” and “Cm” satisfy “C1+C2+C3+C4+C5+C6+C7=Cm”; “E1, E2, E3, E4, E5, E6, E7” and “E” satisfy “E1+E2+E3+E4+E5+E6+E7=E”;

[0038] Process A4: The customer information analysis module calculates the customer's total consumption expenditure ratio CE1, CE1 = E / I*100%;

[0039] Process A5: The customer information analysis module calculates the customer's weighted expenditure ratio CE2;

[0040]

[0041] Process A6: The customer information analysis module calculates the customer's living consumption coefficient ΔC1, ΔC1 = C1 / Cm*E1; the education consumption coefficient ΔC4, ΔC4 = C4 / Cm*E4; the health care coefficient ΔC5, ΔC5 = C5 / Cm*E5; and calculates the customer's essential consumption coefficient ΔC = ΔC1+ΔC4+ΔC5;

[0042] Process A7: The customer information analysis module analyzes the ratio of CE1 to CE2; if CE1 / CE2>2, it means that the customer's consumption expenditure accounts for a high proportion and belongs to the high-consumption group, and there is no need to execute process A8; if 2>CE1 / CE2≥1, the customer information analysis module reads the corresponding regional minimum income index, total number of residents and GDP in the database according to the reference address, and enters process A8;

[0043] Process A8: The customer information analysis module takes the minimum income index as m1 and the total number of residents as pm, calculates the regional expenditure threshold V, V = (12*m1+GDP / pm) / 2; analyzes the ratio of ΔC to V; if ΔC / V>1, it is said that the user's consumption expenditure accounts for a high proportion and belongs to the high-consumption group; if 1≥ΔC / V≥0.9, it is said that the user's consumption expenditure accounts for a normal proportion and belongs to the normal consumption group; if 0.9>ΔC / V>0, it is said that the user's consumption expenditure accounts for a low proportion and belongs to the low-consumption group;

[0044] Process A9: The customer information analysis module uses the analysis results of processes A1 to A8 as the primary customer consumption expenditure analysis report.

[0045] Furthermore, the process of the customer information analysis module performing consumption potential analysis on the customer's initial information is as follows:

[0046] Process B1: The customer information analysis module reads the number of all order information in the historical order information, denoted as Ch;

[0047] Process B2: The customer information analysis module reads the number of orders in the historical order information whose recipients are not the reference name, recorded as NP; reads the number of orders whose delivery addresses are not the reference address, recorded as ND;

[0048] Process B3: The customer information analysis module calculates the purchase rate of others ΔNP1 of historical data, ΔNP=NP / Ch; calculates the purchase rate of other places ΔND1, ΔND1=ND / Ch;

[0049] Process B4: The customer information analysis module uses the same method as processes B1 to B3 above to read the number of all completed orders, recorded as Cn; read the number of orders in which "the recipient is not the reference name" and "the delivery address is not the reference address" among the completed orders, recorded as np and nd respectively; calculate the purchase rate of others ΔNP2 and the purchase rate of other places ΔND2 of the completed orders, ΔNP2 = np / Cn; ΔND2 = nd / Cn;

[0050] Process B5: The customer information analysis module determines whether the customer has consumption potential: if ΔNP1≥0.5 and ΔNP2≥0.5, it is determined that the customer himself is not the main consumer and has no consumption potential; if ΔNP1≥0.5, but 0.5>ΔNP2>0, it is determined whether the value of "ΔND2-ΔND1" is greater than or equal to 0; if "ΔND2-ΔND1" is greater than or equal to 0, it means that the customer's main consumer has changed from "others" to "himself" and has consumption potential; if "ΔND2-ΔND1" is less than 0, it is determined that the customer himself is not the main consumer and has no consumption potential; if ΔNP1<0.5, it is determined that the customer himself is not the main consumer and has no consumption potential;

[0051] Process B6: Based on the analysis results of process B5, determine the main consumption types of customers with "consumption potential";

[0052] Process B7: The customer information analysis module uses the analysis results of the above processes B1 to B6 as a primary customer consumption potential analysis report.

[0053] Furthermore, the workflow of process B6 is as follows:

[0054] Process B61: The customer information analysis module reads the year of the current system time as the search year, recorded as y;

[0055] Process B62: The customer information analysis module reads all order information with order time years of "y-1", "y-2", and "y-3" in the historical order information according to the search year, and uses it as reference historical order information;

[0056] Process B63: The customer information analysis module reads the historical customer personal information of the years "y-1", "y-2", and "y-3" in the data according to the customer name and mobile phone number, and extracts the corresponding total expenditure amount, which is recorded as mf, ms, and mt respectively;

[0057] Process B64: The customer information analysis module reads the store statistical information in the database, and counts the number of orders and total expenditures of different types of customers according to the "product name and store name" in the "reference historical order information", and obtains three sets of reference data sets, which are recorded as Bf, Bs and Bt respectively;

[0058] Bf{Pf1, Pf2, Pf3, Pf4, Pf5, Pf6, Mf};

[0059] Bs{Ps1, Ps2, Ps3, Ps4, Ps5, Ps6, Ms};

[0060] Bt{Pt1, Pt2, Pt3, Pt4, Pt5, Pt6, Mt};

[0061] Among them, the number of orders is represented by "P", and the total payment amount is represented by "M"; the numbers "1 to 6" in the sets Bf, Bs and Bt represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively;

[0062] Process B65: The customer information analysis module counts the number of orders and total payment amounts of different types of consumption in the customer personal information and completed order information to obtain a judgment data set, which is recorded as B;

[0063] B{P1, P2, P3, P4, P5, P6, M};

[0064] The number of orders is represented by "P", and the total payment amount is represented by "M". The numbers "1 to 6" in set B represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption, and environmental protection consumption" respectively.

[0065] Process B66: The customer information analysis module calculates the consumption proportion V corresponding to different types of consumption of customers in the sets Bf, Bs and Bt respectively;

[0066] The consumption proportion of set Bf is Vf{Vf1, Vf2, Vf3, Vf4, Vf5, Vf6};

[0067]

[0068] The consumption proportion of set Bs is Vs{Vs1, Vs2, Vs3, Vs4, Vs5, Vs6};

[0069]

[0070] The consumption proportion of set Bt is Vt{Vt1, Vt2, Vt3, Vt4, Vt5, Vt6};

[0071]

[0072] Process B67: The customer information analysis module calculates and analyzes the customer's total expenditure amount growth coefficient UM, UM = M - (Mf + Ms + Mt) / 3; if UM ≤ 0, it means that the customer's consumption willingness is weak, and the customer changes from "having consumption potential" to "no consumption potential"; if UM > 0, the customer's consumption growth coefficient UP is calculated and analyzed, UP = 3 * M / (Mf + Ms + Mt); if UP > 1, it means that the customer's consumption willingness is strong, and the customer changes from "having consumption potential" to "strong consumption potential", and there is no need to execute subsequent processes B68 to B69; if 1 ≥ UP > 0, it means that the customer's consumption willingness is ordinary, and the customer information analysis module determines the customer's specific consumption potential and enters process B68;

[0073] Process B68: The customer information analysis module determines the specific consumption potential of the customer in turn and obtains the recommended consumption type;

[0074] Process B69: The customer information analysis module divides customers into “having - recommended consumption type - consumption potential” according to “recommended consumption type”.

[0075] Furthermore, the workflow of process B68 is as follows:

[0076] Process B681: The customer information analysis module calculates the potential coefficients CB of different types of consumption of customers in set B in sequence;

[0077]

[0078] We get CB1, CB2, CB3, CB4, CB5, and CB6; the numbers "1 to 6" represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption, and environmental protection consumption" respectively;

[0079] Process B682: The customer information analysis module arranges "CB1-CB6" in ascending order to obtain set B1;

[0080] Process B683: The customer information analysis module extracts the last item of set B1 as a reference coefficient, and determines whether the reference coefficient is greater than 0; if the reference coefficient is less than or equal to 0, it means that the customer's consumption willingness is weak, and the customer changes from "having consumption potential" to "having no consumption potential"; if the reference coefficient is greater than 0, the customer information analysis module extracts the first item of set B1 as the second reference coefficient, and enters process B684;

[0081] Process B684: The customer information analysis module determines whether the second reference coefficient is greater than 0; if the second reference coefficient is greater than or equal to 0, it means that the customer has a strong willingness to consume, and the customer changes from "having consumption potential" to "strong consumption potential"; if the second reference coefficient is less than 0, the customer information analysis module reads the consumption types corresponding to the items with "potential coefficient CB" greater than 0 from the "first item of set B1" in sequence, and records them as recommended consumption types (the numbers "1 to 6" represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively).

[0082] Furthermore, the workflow of the customer consumption record module is as follows:

[0083] Process C1: The customer consumption record module reads the current system time as the recording time;

[0084] Process C2: The customer consumption record module extracts the customer's personal information from the primary customer consumption report, reads the customer's name and mobile phone number as the record name and record mobile phone number;

[0085] Process C3: The customer consumption record module reads all the order information of the franchise stores according to the recorded name and recorded mobile phone number, and extracts all the order information of the franchise stores whose order time is after the "recorded time" as additional order information;

[0086] Process C4: The customer consumption record module reads the store statistical information in the database, and counts the number of orders and expenditure amounts of different types of customer consumption according to the "product name and store name" in the "additional order information" to obtain set C;

[0087] C{PP1, PP2, PP3, PP4, PP5, PP6, PP7, MM};

[0088] The number of orders is represented by "PP" and the payment amount is represented by "MM". The numbers "1 to 7" represent "life consumption, luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively.

[0089] Process C5: The customer consumption record module re-analyzes the customer's consumption expenditure and obtains the customer consumption expenditure report;

[0090] Process C6: The customer consumption record module re-analyzes the customer's consumption potential and obtains a customer consumption potential report;

[0091] Process C7: The customer consumption record module uses the "customer consumption expenditure report" and "customer consumption potential report" obtained in processes C5 and C6 as customer consumption reports;

[0092] Process C8: The customer consumption record module sends the customer personal information and customer consumption report to the customer information update module.

[0093] Furthermore, the workflow of process C5 is as follows:

[0094] Process C51: The customer consumption record module reads the above process A4 to obtain CE1, and reads the above process A5 to obtain CE2;

[0095] Process C52: The customer consumption record module brings the additional order information into process A1, and adds the "additional order information" to the "completed order information" (the logical operation is "union");

[0096] Process C53: The customer consumption record module adds "PP1" to "C1" in the above process A3, adds "PP2" to "C2", adds "PP3" to "C3", adds "PP4" to "C4", adds "PP5" to "C5", adds "PP6" to "C6", and adds "PP7" to "C7";

[0097] Process C54: Customer consumption record module adds "MM" to "E" in the above process A4;

[0098] Process C55: The customer consumption record module re-executes processes A1 to A5, calculates the proportion of the customer's new consumption total expenditure, recorded as CCE1; the proportion of the new consumption weighted expenditure, recorded as CCE2;

[0099] Process C56: The customer consumption record module calculates the consumption potential change coefficient Y, Y = CCE1 / CCE2-CE1 / CE2;

[0100] If Y>0, it means that the proportion of customer expenditure has increased. The customer consumption record module replaces "CE1" in the above process A4 with "CCE1" and replaces "CE2" in the above process A5 with "CCE2", and executes processes A6 to A9; updates the primary customer consumption expenditure analysis report, and uses the "updated" primary customer consumption expenditure analysis report as the customer consumption expenditure report;

[0101] If Y≤0, it means that the customer expenditure ratio remains unchanged, and the customer consumption record module uses the primary customer consumption expenditure report as the customer consumption expenditure report.

[0102] Furthermore, the workflow of process C6 is as follows:

[0103] Process C61: The customer consumption record module reads the above process B681 to obtain CB1, CB2, CB3, CB4, CB5, and CB6;

[0104] Process C62: Customer consumption record module replaces "P1, P2, P3, P4, P5, P6" in process B65 with "PP2, PP3, PP4, PP5, PP6, PP7" of set C, replaces "M" with "MM" of set C, re-executes processes B64 to B681, obtains new potential coefficients, recorded as CBB, and obtains CBB1, CBB2, CBB3, CBB4, CBB5, CBB6;

[0105] Process C63: The customer consumption record module calculates the sum of CBB1 to CBB6, recorded as CBB; calculates the sum of CB1 to CB6, recorded as CB;

[0106] Process C63: The customer consumption record module calculates the consumption potential change coefficient Z, Z = 1-CB / CBB;

[0107] If Z>0, it means that the customer's consumption potential has increased. The customer consumption record module replaces "no consumption potential" in the primary customer consumption potential report with "consumption potential", and "consumption potential" with "strong consumption potential", and executes process B642 to process B7 to update the primary customer consumption potential analysis report, and uses the "updated" primary customer consumption potential analysis report as the customer consumption report;

[0108] If Z≤0, it means that the customer's consumption potential remains unchanged, and the customer consumption record module uses the primary customer consumption potential report as the customer consumption potential report.

[0109] Furthermore, the workflow of the customer information update module is as follows:

[0110] Process D1: The customer information update module reads the current system time as the saving time;

[0111] Process D2: The customer information update module reads the customer name and mobile phone number in the customer personal information, and records it as the name search and mobile phone number search;

[0112] Process D3: The customer information update module reads the historical customer information corresponding to "find name and find mobile phone number" in the data;

[0113] Process D4: The customer information update module records the "recording time" in the "historical customer information" as the "time to be modified", the "customer personal information" as the "personal information to be modified", and the "customer consumption report" as the "report to be modified";

[0114] Process D5: The customer information update module replaces "time to be modified" with "save time", replaces "personal information to be modified" with "customer personal information" (customer consumption record module), and replaces "report to be modified" with "customer consumption report" (customer consumption record module), completing an update;

[0115] Process D6: After the customer information update module "completes one update", it monitors whether the "customer information acquisition module" has re-acquired the initial customer information of the same customer; if it has, it executes process D7; if not, it executes process D8;

[0116] Process D7: The "customer information acquisition module" does not obtain the initial customer information of the same customer; the customer information update module monitors whether the order information corresponding to "find name and find mobile phone number" appears in the order information of the franchise store; if so, the order information corresponding to the franchise store is extracted, the customer consumption record module is executed, the customer data is updated for the second time, and the customers are classified;

[0117] Process D8: The "customer information acquisition module" obtains the initial customer information of the same customer; the customer information update module uses the re-acquired customer initial information as the update information, and re-executes processes D1 to D6 of the customer information analysis module, customer consumption record module and customer information update module to perform a second update on the customer data.

[0118] Compared with the prior art, the present invention has the following beneficial effects:

[0119] 1. High data processing efficiency: In data processing, the present invention only processes key customer information, reduces the interference of additional data, and improves data processing capabilities; at the same time, the data processing results of the present invention are only saved in one copy in the database, and the data processing results are updated in real time through the sharing of franchise store data, which reduces the pressure of data storage and avoids the large amount of calculation of historical data when updating data.

[0120] 2. High data reference: The present invention can collect and process a large amount of customer data in real time, analyze the customer's consumption capacity and consumption potential, and differentiate customers, so that enterprises can timely understand customer behavior and demand to adjust production and sales plans.

[0121] 3. Customer information protection: The present invention only adopts the two methods of "customer self-uploaded data" and "franchised store sharing data" to obtain customer-related information, and updates, checks and deletes customer information in real time in the database; reduces the channels for obtaining customer privacy information from the data source, updates in real time and dynamically from the data processing, does not back up customer privacy information, and promptly deletes and abandons customer privacy information of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0122] Other features, objects and advantages of the present invention will become more apparent from the detailed description of non-limiting embodiments made with reference to the following drawings:

[0123] Figure 1 It is a functional schematic diagram of the system of the present invention;

[0124] Figure 2 This is a schematic diagram of data processing of the present invention;

[0125] Figure 3 This is the logical design intention of the present invention. DETAILED DESCRIPTION

[0126] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.

[0127] See also Figure 1 and Figure 2 A customer update management system based on big data includes: a customer information acquisition module, a customer information analysis module, a customer consumption record module, a customer information update module, a database and a server; wherein the customer information acquisition module, the customer information analysis module, the customer consumption record module and the customer information update module are connected to the server and the database respectively.

[0128] Database: used to store customer information, store statistics, minimum income indicators and total number of residents in different regions, as well as GDP and customer information retention period values.

[0129] Customer information includes: recording time, customer personal information and customer consumption report; historical customer information is "unupdated" customer information;

[0130] The store statistics information includes: the name, location and name of the main products of the store; it should be noted that the names and locations of state-owned institutions such as hospitals, schools, government departments, etc. are also stored in the "store statistics information" of the database in the present invention;

[0131] The customer information retention period value indicates: the maximum time for the present invention to retain customer information is generally set to 3 years; the customer information retention period value can be changed according to the requirements of the merchant, platform or regulatory authority.

[0132] The customer information acquisition module acquires the customer's personal information, completed order information, and historical order information to obtain the customer's initial information;

[0133] The workflow of the customer information acquisition module is as follows:

[0134] The customer uploads the data of the communication software, payment software and shopping software in the mobile terminal to the customer information acquisition module; the customer information acquisition module obtains the customer's name, address and ID number by reading the communication software data uploaded by the customer; and obtains the customer's total income amount, total expenditure amount and all order information by reading the payment software data uploaded by the customer;

[0135] Order information includes: order time, recipient, product name, store name, payment amount and delivery address;

[0136] It should be noted that if the customer purchases in a physical store, the recipient in the order information will be the customer, and the "product name" and "delivery address" can be omitted.

[0137] The customer information acquisition module acquires the current system time and extracts the year information of the current system time as the reference year; the customer information acquisition module extracts the order information whose "order time" year is the same as the "reference year" from all order information to obtain the completed order information;

[0138] The customer information acquisition module takes the order information with different "order time" year and "reference year" in all order information as historical order information;

[0139] The customer information acquisition module uses the customer's name, address, mobile phone number, total income amount and total expenditure amount as the customer's personal information;

[0140] The customer information acquisition module sends the customer's personal information, completed order information and historical order information as customer information to the customer information analysis module.

[0141] It should be noted that the above-mentioned "mobile terminal" refers to a mobile phone; according to relevant laws (citizens' privacy rights and property rights), citizens' personal information and asset information belong to personal privacy, and non-state public officials are not allowed to view and call them. Therefore, in the present invention, the corresponding customer privacy information is obtained by "uploading by the customer"; example: the reference year is 2023, and the customer uploads the data in the communication software, payment software and shopping software on November 1, 2023. The customer information includes "the customer's total income amount, total expenditure amount and completed order information from January 1 to November 1, 2023"; if the customer consumes between November 1 and December 1, 2023, but does not upload data in the customer information acquisition module, the customer information only includes "the customer's total income amount, total expenditure amount and completed order information from January 1 to November 1, 2023".

[0142] The customer information analysis module analyzes the consumption expenditure and consumption potential of the customer's initial information to obtain a primary customer consumption report;

[0143] See also Figure 3 ,The workflow of the customer information analysis module is as follows:

[0144] The customer information analysis module extracts the customer's name, address, total income amount and total expenditure amount from the customer's initial information; the customer's name and address are recorded as reference name and reference address respectively; the total income amount is recorded as I, and the total expenditure amount is recorded as E;

[0145] The customer information analysis module performs consumption expenditure analysis on the customer's initial information, executes processes A1 to A9, and obtains a primary customer consumption expenditure analysis report;

[0146] The customer information analysis module analyzes the consumption potential of the customer's initial information, executes processes B1 to B7, and obtains a primary customer consumption potential expenditure report;

[0147] The customer information analysis module sends the customer personal information, "primary customer consumption expenditure analysis report" and "primary customer consumption potential expenditure report" as primary customer consumption reports to the customer consumption record module;

[0148] The process of the customer information analysis module to analyze the consumption expenditure of the customer's initial information is as follows:

[0149] Process A1: The customer information analysis module reads the quantity of all order information in the completed order information, recorded as Cm;

[0150] Process A2: The customer information analysis module extracts the product name, store name and payment amount from the completed order information;

[0151] Process A3: The customer information analysis module reads the store statistics in the database; based on the "product name and store name in the completed order information" and combined with the store statistics, reads the number of customers of different consumption types and the payment amount:

[0152] Living expenses: number of orders, recorded as C1, and payment amount, recorded as E1;

[0153] Luxury goods consumption: number of orders, recorded as C2, and payment amount, recorded as E2;

[0154] Entertainment consumption: number of orders, recorded as C3, and payment amount, recorded as E3;

[0155] Education consumption: number of orders, recorded as C4, and payment amount, recorded as E4;

[0156] Health care consumption: number of orders, recorded as C5, and payment amount, recorded as E5;

[0157] Digital consumption: number of orders, recorded as C6, and payment amount, recorded as E6;

[0158] Environmental consumption: number of orders, recorded as C7, and payment amount, recorded as E7;

[0159] Among them, “C1, C2, C3, C4, C5, C6, C7” and “Cm” satisfy “C1+C2+C3+C4+C5+C6+C7=Cm”; “E1, E2, E3, E4, E5, E6, E7” and “E” satisfy “E1+E2+E3+E4+E5+E6+E7=E”;

[0160] It should be noted that the "consumption types" in the above process A3 are divided into: daily consumption, luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental consumption; among which daily consumption includes clothing consumption, but the order payment amount of "clothing consumption" in daily consumption shall not exceed the annual minimum income index of the corresponding region (12*regional minimum income index). If it exceeds, it will be "luxury consumption".

[0161] Process A4: The customer information analysis module calculates the customer's total consumption expenditure ratio CE1, CE1 = E / I*100%;

[0162] Process A5: The customer information analysis module calculates the customer's weighted expenditure ratio CE2;

[0163]

[0164] Process A6: The customer information analysis module calculates the customer's living consumption coefficient ΔC1, ΔC1 = C1 / Cm*E1; the education consumption coefficient ΔC4, ΔC4 = C4 / Cm*E4; the health care coefficient ΔC5, ΔC5 = C5 / Cm*E5; and calculates the customer's essential consumption coefficient ΔC = ΔC1+ΔC4+ΔC5;

[0165] Process A7: The customer information analysis module analyzes the ratio of CE1 to CE2; if CE1 / CE2>2, it means that the customer's consumption expenditure accounts for a high proportion and belongs to the high-consumption group, and there is no need to execute process A8; if 2>CE1 / CE2≥1, the customer information analysis module reads the corresponding regional minimum income index, total number of residents and GDP in the database according to the reference address, and enters process A8;

[0166] Process A8: The customer information analysis module takes the minimum income index as m1 and the total number of residents as pm, calculates the regional expenditure threshold V, V = (12*m1+GDP / pm) / 2; analyzes the ratio of ΔC to V; if ΔC / V>1, it is said that the user's consumption expenditure accounts for a high proportion and belongs to the high-consumption group; if 1≥ΔC / V≥0.9, it is said that the user's consumption expenditure accounts for a normal proportion and belongs to the normal consumption group; if 0.9>ΔC / V>0, it is said that the user's consumption expenditure accounts for a low proportion and belongs to the low-consumption group;

[0167] Process A9: The customer information analysis module uses the analysis results of processes A1 to A8 as the primary customer consumption expenditure analysis report;

[0168] It should be noted that the above “CE1 / CE2” ratio relationship is explained as follows:

[0169] From the above-mentioned processes A3 to A5, it can be seen that the ratio of "CE1 / CE2" is equal to the ratio of "1 / (C1 / Cm+C2 / Cm+C3 / Cm+C4 / Cm+C5 / Cm+C6 / Cm+C7 / Cm)"; because "C1+C2+C3+C4+C5+C6+C7=Cm", according to the inequality definition, the value of "C1 / Cm+C2 / Cm+C3 / Cm+C4 / Cm+C5 / Cm+C6 / Cm+C7 / Cm" is the maximum and is 1 if and only if "C1 / Cm=C2 / Cm=C3 / Cm=C4 / Cm=C5 / Cm=C6 / Cm=C7 / Cm"; therefore, the minimum value of the ratio of "CE1 / CE2" is 1.

[0170] The process of the customer information analysis module to analyze the consumption potential of the customer's initial information is as follows:

[0171] Process B1: The customer information analysis module reads the number of all order information in the historical order information, denoted as Ch;

[0172] Process B2: The customer information analysis module reads the number of orders in the historical order information whose recipients are not the reference name, recorded as NP; reads the number of orders whose delivery addresses are not the reference address, recorded as ND;

[0173] Process B3: The customer information analysis module calculates the purchase rate of others ΔNP1 of historical data, ΔNP=NP / Ch; calculates the purchase rate of other places ΔND1, ΔND1=ND / Ch;

[0174] Process B4: The customer information analysis module uses the same method as processes B1 to B3 above to read the number of all completed orders, recorded as Cn; read the number of orders in which "the recipient is not the reference name" and "the delivery address is not the reference address" among the completed orders, recorded as np and nd respectively; calculate the purchase rate of others ΔNP2 and the purchase rate of other places ΔND2 of the completed orders, ΔNP2 = np / Cn; ΔND2 = nd / Cn;

[0175] Process B5: The customer information analysis module determines whether the customer has consumption potential: if ΔNP1≥0.5 and ΔNP2≥0.5, it is determined that the customer himself is not the main consumer and has no consumption potential; if ΔNP1≥0.5, but 0.5>ΔNP2>0, it is determined whether the value of "ΔND2-ΔND1" is greater than or equal to 0; if "ΔND2-ΔND1" is greater than or equal to 0, it means that the customer's main consumer has changed from "others" to "himself" and has consumption potential; if "ΔND2-ΔND1" is less than 0, it is determined that the customer himself is not the main consumer and has no consumption potential; if ΔNP1<0.5, it is determined that the customer himself is not the main consumer and has no consumption potential;

[0176] Process B6: Based on the analysis results of process B5, determine the main consumption types of customers with "consumption potential";

[0177] Process B61: The customer information analysis module reads the year of the current system time as the search year, recorded as y;

[0178] Process B62: The customer information analysis module reads all order information with order time years of "y-1", "y-2", and "y-3" in the historical order information according to the search year, and uses it as reference historical order information;

[0179] Process B63: The customer information analysis module reads the historical customer personal information of the years "y-1", "y-2", and "y-3" in the data according to the customer name and mobile phone number, and extracts the corresponding total expenditure amount, which is recorded as mf, ms, and mt respectively;

[0180] Process B64: The customer information analysis module reads the store statistical information in the database, and counts the number of orders and total expenditures of different types of customers according to the "product name and store name" in the "reference historical order information", and obtains three sets of reference data sets, which are recorded as Bf, Bs and Bt respectively;

[0181] Bf{Pf1, Pf2, Pf3, Pf4, Pf5, Pf6, Mf};

[0182] Bs{Ps1, Ps2, Ps3, Ps4, Ps5, Ps6, Ms};

[0183] Bt{Pt1, Pt2, Pt3, Pt4, Pt5, Pt6, Mt};

[0184] Among them, the number of orders is represented by "P", and the total payment amount is represented by "M"; the numbers "1 to 6" in the sets Bf, Bs and Bt represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively;

[0185] It should be noted that the consumption types in the above-mentioned "Process B64" are divided into: living consumption, luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption; among them, the "living consumption", "senior high school or university tuition fees" and "hospital treatment fees" counted in Process B64 are necessary consumption and are not included in the statistics; "education consumption" only counts the consumption of "non-school external education resources", and "health and medical consumption" only counts "non-acute medical service consumption" and "health care product consumption"; among them, "non-acute medical service consumption" refers to non-medical service consumption provided by hospitals or local health centers, such as regular physical examinations, buying medicines in pharmacies, and purchasing ordinary medical devices.

[0186] Process B65: The customer information analysis module counts the number of orders and total payment amounts of different types of consumption in the customer personal information and completed order information to obtain a judgment data set, which is recorded as B;

[0187] B{P1, P2, P3, P4, P5, P6, M};

[0188] The number of orders is represented by "P", and the total payment amount is represented by "M". The numbers "1 to 6" in set B represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption, and environmental protection consumption" respectively.

[0189] Process B66: The customer information analysis module calculates the consumption proportion V corresponding to different types of consumption of customers in the sets Bf, Bs and Bt respectively;

[0190] The consumption proportion of set Bf is Vf{Vf1, Vf2, Vf3, Vf4, Vf5, Vf6};

[0191]

[0192] The consumption proportion of set Bs is Vs{Vs1, Vs2, Vs3, Vs4, Vs5, Vs6};

[0193]

[0194] The consumption proportion of set Bt is Vt{Vt1, Vt2, Vt3, Vt4, Vt5, Vt6};

[0195]

[0196] Process B67: The customer information analysis module calculates and analyzes the customer's total expenditure amount growth coefficient UM, UM = M - (Mf + Ms + Mt) / 3; if UM ≤ 0, it means that the customer's consumption willingness is weak, and the customer changes from "having consumption potential" to "no consumption potential"; if UM > 0, the customer's consumption growth coefficient UP is calculated and analyzed, UP = 3 * M / (Mf + Ms + Mt); if UP > 1, it means that the customer's consumption willingness is strong, and the customer changes from "having consumption potential" to "strong consumption potential", and there is no need to execute subsequent processes B68 to B69; if 1 ≥ UP > 0, it means that the customer's consumption willingness is ordinary, and the customer information analysis module determines the customer's specific consumption potential and enters process B68;

[0197] Process B68: The customer information analysis module determines the specific consumption potential of the customer in turn;

[0198] Process B681: The customer information analysis module calculates the potential coefficients CB of different types of consumption of customers in set B in sequence;

[0199]

[0200] We get CB1, CB2, CB3, CB4, CB5, and CB6; the numbers "1 to 6" represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption, and environmental protection consumption" respectively;

[0201] Process B682: The customer information analysis module arranges "CB1-CB6" in ascending order to obtain set B1;

[0202] Process B683: The customer information analysis module extracts the last item of set B1 as a reference coefficient, and determines whether the reference coefficient is greater than 0; if the reference coefficient is less than or equal to 0, it means that the customer's consumption willingness is weak, and the customer changes from "having consumption potential" to "having no consumption potential"; if the reference coefficient is greater than 0, the customer information analysis module extracts the first item of set B1 as the second reference coefficient, and enters process B684;

[0203] Process B684: The customer information analysis module determines whether the second reference coefficient is greater than 0; if the second reference coefficient is greater than or equal to 0, it means that the customer has a strong willingness to consume, and the customer changes from "having consumption potential" to "strong consumption potential"; if the second reference coefficient is less than 0, the customer information analysis module reads the consumption types corresponding to the items with "potential coefficient CB" greater than 0 from the "first item of set B1" in sequence, and records them as recommended consumption types (the numbers "1 to 6" represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively);

[0204] Process B69: The customer information analysis module divides customers into “having - recommended consumption type - consumption potential” according to “recommended consumption type”;

[0205] Process B7: The customer information analysis module uses the analysis results of the above processes B1 to B6 as a primary customer consumption potential analysis report.

[0206] The customer consumption record module obtains the customer's additional order information, modifies the primary customer consumption report, and obtains the customer consumption report;

[0207] The workflow of the customer consumption record module is as follows:

[0208] Process C1: The customer consumption record module reads the current system time as the recording time;

[0209] Process C2: The customer consumption record module extracts the customer's personal information from the primary customer consumption report, reads the customer's name and mobile phone number as the record name and record mobile phone number;

[0210] Process C3: The customer consumption record module reads all the order information of the franchise stores according to the recorded name and recorded mobile phone number, and extracts all the order information of the franchise stores whose order time is after the "recorded time" as additional order information;

[0211] It should be noted that according to relevant laws (citizens' privacy rights and property rights), citizens' personal information and asset information are personal privacy, and non-state public officials are not allowed to view or access them. Therefore, the "customer consumption record module" in the present invention can only obtain customer order information corresponding to franchise stores, and cannot obtain relevant information about other customers' individuals or assets. This is hereby explained.

[0212] Process C4: The customer consumption record module reads the store statistical information in the database, and counts the number of orders and expenditure amounts of different types of customer consumption according to the "product name and store name" in the "additional order information" to obtain set C;

[0213] C{PP1, PP2, PP3, PP4, PP5, PP6, PP7, MM};

[0214] The number of orders is represented by "PP" and the payment amount is represented by "MM". The numbers "1 to 7" represent "life consumption, luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively.

[0215] Process C5: The customer consumption record module re-analyzes the customer's consumption expenditure and obtains the customer consumption expenditure report;

[0216] Process C51: The customer consumption record module reads the above process A4 to obtain CE1, and reads the above process A5 to obtain CE2;

[0217] Process C52: The customer consumption record module brings the additional order information into process A1, and adds the "additional order information" to the "completed order information" (the logical operation is "union");

[0218] Process C53: The customer consumption record module adds "PP1" to "C1" in the above process A3, adds "PP2" to "C2", adds "PP3" to "C3", adds "PP4" to "C4", adds "PP5" to "C5", adds "PP6" to "C6", and adds "PP7" to "C7";

[0219] Process C54: Customer consumption record module adds "MM" to "E" in the above process A4;

[0220] Process C55: The customer consumption record module re-executes processes A1 to A5, calculates the proportion of the customer's new consumption total expenditure, recorded as CCE1; the proportion of the new consumption weighted expenditure, recorded as CCE2;

[0221] Process C56: The customer consumption record module calculates the consumption potential change coefficient Y, Y = CCE1 / CCE2-CE1 / CE2;

[0222] If Y>0, it means that the proportion of customer expenditure has increased. The customer consumption record module replaces "CE1" in the above process A4 with "CCE1" and replaces "CE2" in the above process A5 with "CCE2", and executes processes A6 to A9; updates the primary customer consumption expenditure analysis report, and uses the "updated" primary customer consumption expenditure analysis report as the customer consumption expenditure report;

[0223] If Y≤0, it means that the customer expenditure ratio remains unchanged, and the customer consumption record module uses the primary customer consumption expenditure report as the customer consumption expenditure report;

[0224] Process C6: The customer consumption record module re-analyzes the customer's consumption potential and obtains a customer consumption potential report;

[0225] Process C61: The customer consumption record module reads the above process B681 to obtain CB1, CB2, CB3, CB4, CB5, and CB6;

[0226] Process C62: Customer consumption record module replaces "P1, P2, P3, P4, P5, P6" in process B65 with "PP2, PP3, PP4, PP5, PP6, PP7" of set C, replaces "M" with "MM" of set C, re-executes processes B64 to B681, obtains new potential coefficients, recorded as CBB, and obtains CBB1, CBB2, CBB3, CBB4, CBB5, CBB6;

[0227] Process C63: The customer consumption record module calculates the sum of CBB1 to CBB6, recorded as CBB; calculates the sum of CB1 to CB6, recorded as CB;

[0228] Process C63: The customer consumption record module calculates the consumption potential change coefficient Z, Z = 1-CB / CBB;

[0229] If Z>0, it means that the customer's consumption potential has increased. The customer consumption record module replaces "no consumption potential" in the primary customer consumption potential report with "consumption potential", and "consumption potential" with "strong consumption potential", and executes process B642 to process B7 to update the primary customer consumption potential analysis report, and uses the "updated" primary customer consumption potential analysis report as the customer consumption report;

[0230] If Z≤0, it means that the customer's consumption potential remains unchanged, and the customer consumption record module uses the primary customer consumption potential report as the customer consumption potential report;

[0231] Process C7: The customer consumption record module uses the "customer consumption expenditure report" and "customer consumption potential report" obtained in processes C5 and C6 as customer consumption reports;

[0232] Process C8: The customer consumption record module sends the customer personal information and customer consumption report to the customer information update module.

[0233] The customer information update module monitors whether the customer's initial information has changed; if it has not changed, the historical customer information is updated according to the customer's consumption report; if it has changed, the changed customer's initial information is used as the update information, and the historical customer information is updated according to the update information;

[0234] The workflow of the customer information update module is as follows:

[0235] Process D1: The customer information update module reads the current system time as the saving time;

[0236] Process D2: The customer information update module reads the customer name and mobile phone number in the customer personal information, and records it as the name search and mobile phone number search;

[0237] Process D3: The customer information update module reads the historical customer information corresponding to "find name and find mobile phone number" in the data;

[0238] Process D4: The customer information update module records the "recording time" in the "historical customer information" as the "time to be modified", the "customer personal information" as the "personal information to be modified", and the "customer consumption report" as the "report to be modified";

[0239] Process D5: The customer information update module replaces "time to be modified" with "save time", replaces "personal information to be modified" with "customer personal information" (customer consumption record module), and replaces "report to be modified" with "customer consumption report" (customer consumption record module), completing an update;

[0240] Process D6: After the customer information update module "completes an update", it monitors whether the customer's initial information has changed, that is, whether the "customer information acquisition module" has re-acquired the customer's initial information of the same customer; if it has, it executes process D7; if not, it executes process D8;

[0241] Process D7: The "customer information acquisition module" does not obtain the initial customer information of the same customer; the customer information update module monitors whether the order information corresponding to "find name and find mobile phone number" appears in the order information of the franchise store; if so, the order information corresponding to the franchise store is extracted, the customer consumption record module is executed, the customer data is updated for the second time, and the customers are classified;

[0242] Process D8: The "customer information acquisition module" acquires the initial customer information of the same customer; the customer information update module uses the newly acquired initial customer information as update information, re-executes processes D1 to D6 of the customer information analysis module, customer consumption record module, and customer information update module, performs a second update on the customer data, and classifies the customers;

[0243] It should be noted that in the above-mentioned processes D7 and D8, the classification of customers includes: potential customers, existing customers and ordinary customers; among them, "potential customers" refers to customers who "belong to the normal consumer group and have consumption potential", "existing customers" refers to customers who "belong to the normal consumer group and have high consumption potential" or "belong to the high consumer group", and "ordinary customers" refers to customers who "belong to the normal consumer group and have no consumption potential" or "belong to the low consumer group".

[0244] Process D9: The customer information update module reads the "customer information storage period value" in the database and records it as N; the customer information update module retrieves the customer information whose "storage time" and "recording time in customer information" differ by N and whose customer consumption report remains unchanged in the database, and deletes it.

[0245] It should be noted that, from the processing of historical customer information by the customer information update module, it can be seen that the present invention adopts dynamic update processing for "customer information", and each customer name and mobile phone number corresponds to only one customer information; if the customer information in the database does not change for a long time, it means that the customer has given up the use of the present invention. According to relevant laws (citizens' privacy rights and property rights), non-state public officials shall not retain citizens' personal and property information without the permission of others; therefore, the present invention deletes customer information that has not been used for a long time, and this is hereby stated.

[0246] The above formulas are all dimensionless and numerical calculations. The formula is a formula for the most recent real situation obtained by collecting a large amount of data and performing software simulation. The preset parameters in the formula are set by technical personnel in this field according to actual conditions. For example, if there are weight coefficients and proportional coefficients, their set sizes are to quantify each parameter to obtain a specific value, which is convenient for subsequent comparison. Regarding the size of the weight coefficient and the proportional coefficient, it is sufficient as long as it does not affect the proportional relationship between the parameter and the quantized value.

[0247] Finally, it should be noted that the above-described embodiments are only specific implementations of the present invention, which are used to illustrate the technical solutions of the present invention, rather than to limit them. The protection scope of the present invention is not limited thereto. Although the present invention is described in detail with reference to the above-described embodiments, ordinary technicians in the field should understand that any technician familiar with the technical field can still modify the technical solutions recorded in the above-described embodiments within the technical scope disclosed by the present invention, or can easily think of changes, or make equivalent replacements for some of the technical features therein; and these modifications, changes or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be based on the protection scope of the claims.

Claims

1. A customer update management system based on big data, characterized in that: The management system includes: Customer information acquisition module: used to obtain the customer's personal information and all order information, and divide all order information into: completed order information with the same order time and year as the current system time and historical order information with different order time and year; the customer's personal information, completed order information and historical order information are used as the customer's initial information; Customer information analysis module: used to analyze the completed order information based on historical order information, analyze the customer's consumption expenditure proportion and consumption potential, and obtain a primary customer consumption report; Customer consumption record module: used to obtain additional order information of customers in franchise stores; conduct secondary analysis on primary customer consumption report based on additional order information, analyze the customer's consumption expenditure proportion and consumption potential again, and obtain customer consumption report; Customer information update module: used to update historical customer information once according to customer consumption reports, and monitor whether the customer's initial information has changed; if there is no change, the customer information update module only calls the customer consumption record module to obtain and re-update the historical customer information according to the customer's additional order information; if there is a change, the changed customer's initial information is used as the update information, and the customer information update module calls the customer information analysis module and the customer consumption record module to re-update the historical customer information according to the update information; Database: used to store customer information, store statistics, minimum income indicators and total number of residents in different regions, GDP and customer information retention period values. Customer information includes: recording time, customer personal information and customer consumption reports; The workflow of the customer information update module is as follows: Process D1: The customer information update module reads the current system time as the saving time; Process D2: The customer information update module reads the customer name and mobile phone number in the customer personal information, which is recorded as looking up the name and looking up the mobile phone number; Process D3: The customer information update module reads the historical customer information corresponding to the name search and the mobile phone number search in the data; Process D4: The customer information update module records the recording time in the historical customer information as the time to be modified, the customer personal information as the personal information to be modified, and the customer consumption report as the report to be modified; Process D5: The customer information update module replaces the time to be modified with the saved time, replaces the personal information to be modified with the customer's personal information, and replaces the report to be modified with the customer's consumption report, completing an update; Process D6: After completing an update, the customer information update module monitors whether the customer information acquisition module has re-acquired the initial customer information of the same customer; if so, process D7 is executed; if not, process D8 is executed; Process D7: The customer information acquisition module does not obtain the initial customer information of the same customer; the customer information update module monitors whether the order information corresponding to the name search and the mobile phone number search appears in the order information of the franchise store; if so, the order information corresponding to the franchise store is extracted, the customer consumption record module is executed, the customer data is updated for the second time, and the customers are classified; Process D8: The customer information acquisition module obtains the initial customer information of the same customer; the customer information update module uses the re-acquired initial customer information as the update information, and re-executes processes D1 to D6 of the customer information analysis module, customer consumption record module and customer information update module to perform a second update on the customer data.

2. According to the big data-based customer update management system of claim 1, it is characterized in that: The workflow of the customer information acquisition module is as follows: The customer uploads the data of the communication software, payment software and shopping software in the mobile terminal to the customer information acquisition module; the customer information acquisition module obtains the customer's name, address and ID number by reading the communication software data uploaded by the customer; and obtains the customer's total income amount, total expenditure amount and all order information by reading the payment software data uploaded by the customer; Order information includes: order time, recipient, product name, store name, payment amount and delivery address; The customer information acquisition module obtains the current system time and extracts the year information of the current system time as the reference year; the customer information acquisition module extracts the order information whose "order time" year is the same as the "reference year" from all order information to obtain the completed order information; The customer information acquisition module takes the order information with different "order time" year and "reference year" in all order information as historical order information; The customer information acquisition module uses the customer's name, address, mobile phone number, total income amount and total expenditure amount as the customer's personal information; The customer information acquisition module sends the customer's personal information, completed order information and historical order information as the customer's initial information to the customer information analysis module.

3. A customer update management system based on big data according to claim 2, characterized in that: The workflow of the customer information analysis module is as follows: The customer information analysis module extracts the customer's name, address, total income amount and total expenditure amount from the customer's initial information; the customer's name and address are recorded as reference name and reference address respectively; the total income amount is recorded as I, and the total expenditure amount is recorded as E; The customer information analysis module analyzes the consumption expenditure of the customer's initial information and obtains a primary customer consumption expenditure analysis report; The customer information analysis module analyzes the consumption potential of the customer's initial information and obtains a primary customer consumption potential expenditure report; The customer information analysis module sends the customer personal information, the primary customer consumption expenditure analysis report and the primary customer consumption potential expenditure report as the primary customer consumption report to the customer consumption record module.

4. The customer update management system based on big data according to claim 3 is characterized in that: The process of the customer information analysis module performing consumption expenditure analysis on the customer's initial information is as follows: Process A1: The customer information analysis module reads the quantity of all order information in the completed order information, recorded as Cm; Process A2: The customer information analysis module extracts the product name, store name and payment amount from the completed order information; Process A3: The customer information analysis module reads the store statistics in the database; based on the "product name and store name in the completed order information" and combined with the store statistics, reads the number of customers of different consumption types and the payment amount: Living expenses: number of orders, recorded as C1, and payment amount, recorded as E1; Luxury goods consumption: number of orders, recorded as C2, and payment amount, recorded as E2; Entertainment consumption: number of orders, recorded as C3, and payment amount, recorded as E3; Education consumption: number of orders, recorded as C4, and payment amount, recorded as E4; Health care consumption: number of orders, recorded as C5, and payment amount, recorded as E5; Digital consumption: number of orders, recorded as C6, and payment amount, recorded as E6; Environmental consumption: number of orders, recorded as C7, and payment amount, recorded as E7; Among them, "C1, C2, C3, C4, C5, C6, C7" and "Cm" satisfy "C1+C2+C3+C4+C5+C6+C7=Cm"; "E1, E2, E3, E4, E5, E6, E7" and "E" satisfy "E1+E2+E3+E4+E5+E6+E7=E"; Process A4: The customer information analysis module calculates the customer's total consumption expenditure ratio CE1, CE1 = E / I*100%; Process A5: The customer information analysis module calculates the customer's weighted expenditure ratio CE2; ; Process A6: The customer information analysis module calculates the customer's living consumption coefficient ΔC1, ΔC1 = C1 / Cm*E1; the education consumption coefficient ΔC4, ΔC4 = C4 / Cm*E4; the health care coefficient ΔC5, ΔC5 = C5 / Cm*E5; and calculates the customer's essential consumption coefficient ΔC = ΔC1 + ΔC4 + ΔC5; Process A7: The customer information analysis module analyzes the ratio of CE1 to CE2; if CE1 / CE2>2, it means that the customer's consumption expenditure accounts for a high proportion and belongs to the high-consumption group, and there is no need to execute process A8; if 2>CE1 / CE2≥1, the customer information analysis module reads the corresponding regional minimum income index, total number of residents and GDP in the database according to the reference address, and enters process A8; Process A8: The customer information analysis module takes the minimum income index as m1 and the total number of residents as pm, calculates the regional expenditure threshold V, V = (12*m1 + GDP / pm) / 2; analyzes the ratio of ΔC to V; if ΔC / V>1, it is said that the customer's consumption expenditure accounts for a high proportion and belongs to the high-consumption group; if 1≥ΔC / V≥0.9, it is said that the customer's consumption expenditure accounts for a normal proportion and belongs to the normal consumption group; if 0.9>ΔC / V>0, it is said that the customer's consumption expenditure accounts for a low proportion and belongs to the low-consumption group; Process A9: The customer information analysis module uses the analysis results of processes A1 to A8 as the primary customer consumption expenditure analysis report. After the analysis is completed, the customer information analysis module conducts consumption potential analysis on the customer's initial information.

5. A customer update management system based on big data according to claim 4, characterized in that: The process of the customer information analysis module analyzing the consumption potential of the customer's initial information is as follows: Process B1: The customer information analysis module reads the number of all order information in the historical order information, denoted as Ch; Process B2: The customer information analysis module reads the number of orders in the historical order information whose recipients are not the reference name, recorded as NP; and reads the number of orders whose delivery addresses are not the reference address, recorded as ND; Process B3: The customer information analysis module calculates the purchase rate of others ΔNP1 of historical data, ΔNP=NP / Ch; calculates the purchase rate of other places ΔND1, ΔND1=ND / Ch; Process B4: The customer information analysis module uses the same method as the above processes B1 to B3 to read the number of all completed orders, recorded as Cn; read the number of orders in which "the recipient is not the reference name" and "the delivery address is not the reference address" in the completed orders, recorded as np and nd respectively; calculate the purchase rate of others ΔNP2 and the purchase rate of other places ΔND2 of the completed orders, ΔNP2=np / Cn; ΔND2=nd / Cn; Process B5: The customer information analysis module determines whether the customer has consumption potential: if ΔNP1≥0.5 and ΔNP2≥0.5, it is determined that the customer himself is not the main consumer and has no consumption potential; if ΔNP1≥0.5, but 0.5>ΔNP2>0, it is determined whether the value of "ΔND2-ΔND1" is greater than or equal to 0; if "ΔND2-ΔND1" is greater than or equal to 0, it means that the customer's main consumer has changed from "others" to "himself" and has consumption potential; if "ΔND2-ΔND1" is less than 0, it is determined that the customer himself is not the main consumer and has no consumption potential; if ΔNP1<0.5, it is determined that the customer himself is not the main consumer and has no consumption potential; Process B6: Based on the analysis results of process B5, determine the main consumption types of customers with "consumption potential"; Process B7: The customer information analysis module uses the analysis results of the above processes B1 to B6 as a primary customer consumption potential analysis report.

6. The customer update management system based on big data according to claim 5, characterized in that: The workflow of process B6 is as follows: Process B61: The customer information analysis module reads the year of the current system time as the search year, recorded as y; Process B62: The customer information analysis module reads all order information with order placement years of "y-1", "y-2", and "y-3" in the historical order information according to the search year, and uses this as reference historical order information; Process B63: The customer information analysis module reads the historical customer personal information of the years "y-1", "y-2", and "y-3" in the data based on the customer name and mobile phone number, and extracts the corresponding total expenditure amount, which is recorded as mf, ms, and mt respectively; Process B64: The customer information analysis module reads the store statistical information in the database, and counts the number of orders and total expenditures of different types of customers based on the "product name and store name" in the "reference historical order information", and obtains three sets of reference data sets, which are recorded as Bf, Bs and Bt respectively; Bf{Pf1, Pf2, Pf3, Pf4, Pf5, Pf6, Mf}; Bs{Ps1, Ps2, Ps3, Ps4, Ps5, Ps6, Ms}; Bt{Pt1, Pt2, Pt3, Pt4, Pt5, Pt6, Mt}; Among them, the number of orders is represented by "P", and the total payment amount is represented by "M"; the numbers "1 to 6" in the sets Bf, Bs and Bt represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption" respectively; Process B65: The customer information analysis module counts the number of orders and total payment amounts of different types of consumption in the customer personal information and completed order information to obtain a judgment data set, which is recorded as B; B{P1, P2, P3, P4, P5, P6, M}; The number of orders is represented by "P", and the total payment amount is represented by "M". The numbers "1 to 6" in set B represent "luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption, and environmental protection consumption" respectively. Process B66: The customer information analysis module calculates the consumption proportion V corresponding to different types of consumption of customers in the sets Bf, Bs and Bt respectively; The consumption proportion of set Bf is Vf{Vf1, Vf2, Vf3, Vf4, Vf5, Vf6}; ; The consumption proportion of set Bs is Vs{Vs1, Vs2, Vs3, Vs4, Vs5, Vs6}; ; The consumption proportion of set Bt is Vt{Vt1, Vt2, Vt3, Vt4, Vt5, Vt6}; ; Process B67: The customer information analysis module calculates and analyzes the customer's total expenditure amount growth coefficient UM, UM = M - (Mf + Ms + Mt) / 3; if UM ≤ 0, it means that the customer's consumption willingness is weak, and the customer changes from "having consumption potential" to "no consumption potential"; if UM > 0, the customer's consumption growth coefficient UP is calculated and analyzed, UP = 3 * M / (Mf + Ms + Mt); if UP > 1, it means that the customer's consumption willingness is strong, and the customer changes from "having consumption potential" to "strong consumption potential", and there is no need to execute subsequent processes B68 to B69; if 1 ≥ UP > 0, it means that the customer's consumption willingness is ordinary, and the customer information analysis module determines the customer's specific consumption potential and enters process B68; Process B68: The customer information analysis module determines the specific consumption potential of the customer in turn and obtains the recommended consumption type; Process B681: The customer information analysis module calculates the potential coefficients CB of different types of consumption of customers in set B in sequence; ; Get CB1, CB2, CB3, CB4, CB5, CB6; Process B682: The customer information analysis module arranges "CB1-CB6" in ascending order to obtain set B1; Process B683: The customer information analysis module determines whether the last item of set B1 is greater than 0; if it is less than or equal to 0, the customer changes from "having consumption potential" to "not having consumption potential"; if it is greater than 0, the customer information analysis module extracts the first item of set B1 and enters process B684; Process B684: The customer information analysis module determines whether the first item of set B1 is greater than 0; if it is greater than or equal to 0, the customer changes from "having consumption potential" to "strong consumption potential"; if it is less than 0, the customer information analysis module reads the consumption types corresponding to the items whose "potential coefficient CB" is greater than 0 from "the first item of set B1" in sequence, and records them as recommended consumption types; Process B69: The customer information analysis module divides customers into "having - recommended consumption type - consumption potential" according to the "recommended consumption type". After the customer information analysis module completes the analysis, it enters the customer consumption record module.

7. The customer update management system based on big data according to claim 6, characterized in that: The workflow of the customer consumption record module is as follows: Process C1: The customer consumption record module reads the current system time as the recording time; Process C2: The customer consumption record module extracts the customer's personal information from the primary customer consumption report, reads the customer's name and mobile phone number as the record name and record mobile phone number; Process C3: The customer consumption record module reads all the order information of the franchise stores according to the recorded name and recorded mobile phone number, and extracts all the order information of the franchise stores whose order time is after the recorded time as additional order information; Process C4: The customer consumption record module reads the store statistical information in the database, and counts the number of orders and expenditure amounts of different types of consumption by customers based on the product name and store name in the additional order information to obtain set C; C{PP1, PP2, PP3, PP4, PP5, PP6, PP7, MM}; The number of orders is represented by PP, and the payment amount is represented by MM; the numbers "1 to 7" represent life consumption, luxury consumption, entertainment consumption, education consumption, health and medical consumption, digital consumption and environmental protection consumption respectively; Process C5: The customer consumption record module re-analyzes the customer's consumption expenditure and obtains the customer consumption expenditure report; Process C6: The customer consumption record module re-analyzes the customer's consumption potential and obtains a customer consumption potential report; Process C7: The customer consumption record module uses the customer consumption expenditure report and customer consumption potential report obtained by processes C5 and C6 as the customer consumption report; Process C8: The customer consumption record module sends the customer personal information and customer consumption report to the customer information update module.

8. The customer update management system based on big data according to claim 7, characterized in that: The workflow of process C5 is as follows: Process C51: The customer consumption record module reads the above process A4 to obtain CE1, and reads the above process A5 to obtain CE2; Process C52: The customer consumption record module brings the additional order information into process A1 and adds the additional order information to the completed order information; Process C53: The customer consumption record module adds PP1 to "C1" in the above process A3, adds PP2 to C2, adds PP3 to C3, adds PP4 to C4, adds PP5 to C5, adds PP6 to C6, and adds PP7 to C7; Process C54: Customer consumption record module adds MM based on E in the above process A4; Process C55: The customer consumption record module re-executes processes A1 to A5, calculates the proportion of the customer's new consumption total expenditure, recorded as CCE1; the proportion of the new consumption weighted expenditure, recorded as CCE2; Process C56: The customer consumption record module calculates the consumption potential change coefficient Y, Y = CCE1 / CCE2-CE1 / CE2; If Y>0, it means that the proportion of customer expenditure has increased. The customer consumption record module replaces "CE1" in the above process A4 with "CCE1" and replaces CE2 in the above process A5 with CCE2, and executes processes A6 to A9; updates the primary customer consumption expenditure analysis report, and uses the "updated" primary customer consumption expenditure analysis report as the customer consumption expenditure report; If Y≤0, it means that the customer expenditure ratio remains unchanged, and the customer consumption record module uses the primary customer consumption expenditure report as the customer consumption expenditure report.

9. The customer update management system based on big data according to claim 7, characterized in that: The workflow of process C6 is as follows: Process C61: The customer consumption record module reads the above process B681 to obtain CB1, CB2, CB3, CB4, CB5, and CB6; Process C62: Customer consumption record module replaces "P1, P2, P3, P4, P5, P6" in process B65 with "PP2, PP3, PP4, PP5, PP6, PP7" of set C, replaces "M" with "MM" of set C, re-executes processes B64 to B681, obtains new potential coefficients, recorded as CBB, and obtains CBB1, CBB2, CBB3, CBB4, CBB5, CBB6; Process C63: The customer consumption record module calculates the sum of CBB1 to CBB6, recorded as CBB; calculates the sum of CB1 to CB6, recorded as CB; Process C64: The customer consumption record module calculates the consumption potential change coefficient Z, Z = 1-CB / CBB; If Z>0, it means that the customer's consumption potential has increased. The customer consumption record module replaces the "no consumption potential" in the primary customer consumption potential report with "having consumption potential" and replaces the consumption potential with "strong consumption potential". Execute process B64 to process B7, update the primary customer consumption potential analysis report, and use the "updated" primary customer consumption potential analysis report as the customer consumption report. If Z≤0, it means that the customer's consumption potential remains unchanged, and the customer consumption record module uses the primary customer consumption potential report as the customer consumption potential report.

Citation Information

Patent Citations

  • A Customer Relationship Management Data Update System and Method Based on Big Data

    CN113468194B

  • A mango plantation service system based on WeChat platform

    CN109146704A

  • Jewelry user management system and method based on RDIF label technology

    CN116629727A