Recipe mechanism auditing method and device, electronic equipment and storage medium
By extracting sales feature information to generate joint primary keys and automatically matching audit opinions, the problems of low efficiency and error of manual audits are solved, automated audits are realized, and efficiency and accuracy are improved.
Patent Information
- Application Number
- CN202411012250.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-25
- Publication Date
- 2024-12-06
AI Technical Summary
In the prior art, the distribution price mechanism of manual review products is inefficient and prone to errors, resulting in a large number of repeated manual operations and errors.
By obtaining product information, extracting sales feature information, generating joint primary keys, and automatically matching and determining the review opinions of the current donation mechanism based on the review opinions in historical documents, reducing manual calculations and reviews.
Automatic audits are realized, reducing the workload and cost of manual audits, improving audit efficiency and reducing errors.
Smart Images

Figure CN119090414A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data audit technology, and in particular to a method, device, electronic device and storage medium for auditing a distribution mechanism. Background Art
[0002] The information transparency of the beauty e-commerce industry is getting higher and higher, and consumers are becoming more and more sensitive to prices and gift distribution. In order to protect the rights and interests of consumers, online dealers, brands and other parties, brands need to strictly control and supervise prices and prices and gift distribution mechanisms for different sales channels and different products. Usually, the person in charge of each sales channel in the e-commerce department (divided by different e-commerce platforms and direct sales, distribution and other dimensions) provides each store with a product sales plan document for the next month in the middle of the month. The product sales plan document includes the main products, gifts, price and hand price corresponding to all product links. The product sales plan document is submitted to the business specialist for approval. The business specialist mainly uses Excel to manually match the price corresponding to the product code of each product, and calculates the discount rate based on the price, and then determines whether the product has passed the review based on the discount rate. This method consumes a lot of repetitive manual operations every month, is inefficient, and manual review is prone to errors. Summary of the invention
[0003] The present invention provides a method for reviewing a gift-giving mechanism, so as to solve the problem that the manual review of a gift-giving price mechanism of a product is inefficient and prone to errors.
[0004] In a first aspect, the present invention provides a method for reviewing a matching mechanism, comprising:
[0005] Obtain a target worksheet including product information of a plurality of products, wherein each gift distribution mechanism corresponds to at least one of the product information;
[0006] For each of the gift matching mechanisms, selecting a plurality of feature information representing sales features of a product from the product information corresponding to the gift matching mechanism;
[0007] Generate a joint primary key of the matching mechanism based on the characteristic information;
[0008] The audit opinion of the current allocation mechanism is determined according to the joint primary key and the historical file, wherein the historical file includes the historical allocation mechanism, the joint primary key corresponding to the historical allocation mechanism, and the audit opinion.
[0009] In a second aspect, the present invention provides a device for auditing a distribution mechanism, comprising:
[0010] A product information acquisition module, used to acquire a target worksheet including product information of a plurality of products, each gift mechanism corresponding to at least one of the product information;
[0011] A feature information extraction module, for selecting, for each gift-matching mechanism, a plurality of feature information representing sales features of a product from the product information corresponding to the gift-matching mechanism;
[0012] A joint primary key generation module, used to generate a joint primary key of the matching mechanism based on the characteristic information;
[0013] The audit opinion determination module is used to determine the audit opinion of the current allocation mechanism based on the joint primary key and historical files, and the historical files include historical allocation mechanisms, joint primary keys corresponding to the historical allocation mechanisms, and audit opinions.
[0014] In a third aspect, the present invention provides an electronic device, the electronic device comprising:
[0015] at least one processor; and
[0016] a memory communicatively connected to the at least one processor; wherein,
[0017] The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the allocation mechanism review method described in the first aspect of the present invention.
[0018] In a fourth aspect, the present invention provides a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a processor to implement the method for reviewing a gift mechanism as described in the first aspect of the present invention when executed.
[0019] An embodiment of the present invention provides a method for auditing a gift mechanism, which obtains a target worksheet including product information of multiple products, each gift mechanism corresponding to at least one product information; for each gift mechanism, multiple feature information representing the sales features of the product are selected from the product information corresponding to the gift mechanism; a joint primary key of the gift mechanism is generated based on the feature information; and the audit opinion of the current gift mechanism is determined according to the joint primary key and a historical file, wherein the historical file includes the historical gift mechanism, the joint primary key corresponding to the historical gift mechanism, and the audit opinion. Gift mechanisms with different sales features are classified in the form of a joint primary key, and the gift mechanism to be audited can be automatically matched according to the historical file, that is, the audit opinion of the current gift mechanism can be determined according to the audit opinion of the same gift mechanism in the historical file. For the current gift mechanism that can match the corresponding historical file, there is no need for manual calculation and audit, which reduces the workload and cost of manual audit and improves the audit efficiency.
[0020] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0022] Figure 1 This is a flow chart of a method for reviewing a gift mechanism provided in the first embodiment of the present invention;
[0023] Figure 2 This is a flow chart of a method for reviewing a gift mechanism provided by Embodiment 2 of the present invention;
[0024] Figure 3 It is a structural diagram of a device for reviewing a gift-giving mechanism provided in Embodiment 3 of the present invention;
[0025] Figure 4 It is a schematic diagram of the structure of an electronic device provided in Embodiment 4 of the present invention. DETAILED DESCRIPTION
[0026] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.
[0027] Embodiment 1
[0028] Figure 1 This is a flow chart of a matching mechanism audit method provided in the first embodiment of the present invention. This embodiment is applicable to the matching mechanism audit situation. The method can be executed by a matching mechanism audit device. The matching mechanism audit device can be implemented in the form of hardware and / or software. The matching mechanism audit device can be configured in an electronic device. Figure 1 As shown, the audit method of the matching mechanism includes:
[0029] S101. Obtain a target worksheet including product information of a plurality of products, wherein each gift distribution mechanism corresponds to at least one product information.
[0030] The gifting mechanism is a product gifting plan, which means that when users buy the merchant's products, the merchant gives them other products or services (such as discount coupons, etc.) to increase the user's sense of value and satisfaction. The gifting mechanism is often used in some online or offline product promotion activities. The gifting mechanism can only be applied to specific product sales after passing the review. Generally speaking, the review process of the gifting mechanism occurs before the product promotion activity, or periodically (for example, at the end of each month).
[0031] Product information includes product type, which can be main product or gift, that is, the main product is one product, and the gift is also one product. The main product is the main product for sale, and the gift is the product that comes with the main product. The products corresponding to each gift mechanism include at least one main product, which may not include gifts, or may include one or more gifts, for example:
[0032] For the gift mechanism 1, the corresponding product is the main product DH*1;
[0033] For gift matching mechanism 2, the corresponding products are main product DH*1 and standard gift CH*1;
[0034] For gift matching mechanism 3, the corresponding products are main product DH*1, standard gift CH*2, and member bonus VH*2.
[0035] Enter the above data into the corresponding target worksheet, which can be expressed as the following Table 1;
[0036] Table 1. Partial data in a target data table.
[0037]
[0038]
[0039] In the above Table 1, the serial number represents the code of the gift allocation mechanism, each gift allocation mechanism corresponds to a unique serial number, the code is the product code, each product corresponds to a unique code, the product details are the name of the product, and the configuration quantity is the number of individual products in the gift allocation mechanism.
[0040] A target worksheet includes multiple product information. Specifically, the target worksheet is an EXCEL table. The header of the target worksheet defines the attribute information of each column of data. Each row of data in the target worksheet is the product information of a product. In other words, each row of data is the product information of a main product or a gift. Each gift mechanism corresponds to the product information of at least one main product.
[0041] Of course, product information may also include sales price, purchase price, store name, folder name, platform name, promotion level, etc. The specific table formats are not shown one by one.
[0042] The target worksheet is usually located in a file, such as a workbook. In an optional embodiment, the target worksheet is a table file in the target file. Before obtaining the target worksheet including product information of multiple products, it also includes: for each target file, the data structure of each target worksheet is sorted according to the preset worksheet structure, so that the data structure of the target worksheet is consistent with the data structure of the preset worksheet structure; for each target worksheet, it is determined whether there is an error or missing in the content of each product information in the target worksheet; if so, it is determined that the target worksheet is not qualified for review, and the error type of the target worksheet is determined, and the table name of the target worksheet, the file name of the corresponding target file and the error type are used as modification information and output; if not, it is determined that the target worksheet is qualified for review. In addition, the target worksheet can also be cleaned for data, because the number of files involved is very large, and they are filled in by different business personnel, so the field names will be different, and the format will also be different, all of which need to be cleaned and regularized.
[0043] The data structure of each target worksheet is sorted according to a preset worksheet structure, specifically, it can be sorted according to a certain data arrangement order. Only target worksheets with audit qualifications can be used to execute S101, and target worksheets without audit qualifications are sent to the terminal that provides the target worksheet to remind the corresponding personnel to modify the target worksheet.
[0044] S102: For each gift-matching mechanism, select characteristic information representing sales characteristics of the product from the product information corresponding to the gift-matching mechanism.
[0045] Each gifting mechanism corresponds to the product information of at least one main product, and may also correspond to the product information of one or more gifts. For each gifting mechanism, feature information representing the sales characteristics of the product is selected from the product information corresponding to the gifting mechanism. Specifically, for each product information corresponding to the gifting mechanism, feature information representing the sales characteristics of the product is selected. Optionally, the feature information may be information that distinguishes products of different gifting mechanisms, or may be information that reflects the differences between different products in the same gifting mechanism. Exemplarily, the feature information includes at least product type, product code, configuration quantity, and price.
[0046] It should be noted that the price is usually only included in the product information of the main product, and not in the product information of the gift.
[0047] For example, the product information of the two products corresponding to the gift mechanism 1 are X1 (main product, product code 131) and X2 (gift, product code 1521). Each product information can extract characteristic information representing the sales characteristics of the product, specifically: main product, product code 131, configuration quantity 1, price 356, gift, product code 1521, configuration quantity 1.
[0048] S103. Generate a joint primary key of the gift matching mechanism based on the feature information.
[0049] The joint primary key is the unique identifier of the gift mechanism, which is used to express the characteristic content of the gift mechanism. The joint primary key consists of multiple fields. By using the joint primary key, the specific content of the gift mechanism is flattened, which can reduce redundant data and improve data query efficiency and audit efficiency.
[0050] Specifically, the feature information can be combined front and back, and different types of feature information can be divided by preset placeholders. The specific form of the joint primary key can be set according to actual needs, but it is usually determined based on a fixed form. Orderly management can be achieved on the basis of distinguishing different gift mechanisms, and it can also be indexed according to the joint primary key in subsequent steps. It can be seen that the generated joint primary key is also unique, so that each joint primary key can represent a gift mechanism. It should also be noted that for a gift mechanism with only one main product, since more than one sales feature is extracted, the joint primary key of the gift mechanism can also be generated based on the feature information.
[0051] The specific characteristic information is: main product, product code 131, configuration quantity 1, price 356, gift, product code 1521, configuration quantity 1.
[0052] In a rule for creating a joint primary key, the generated joint primary key is: main product 131-1, gift product 1521-1, 356;
[0053] In another rule for creating a composite primary key, the generated composite primary key is: main product 131-1@356&gift 1521-1.
[0054] The creation rule of the joint primary key defines the type of sales features. The above form of the joint primary key is only an example and is not intended to limit the present invention. For example, each feature information may be converted into corresponding characters and then combined to obtain a joint primary key.
[0055] In an optional embodiment, after generating the joint primary key of the gift allocation mechanism based on the characteristic information, it also includes: combining all product information of the same gift allocation mechanism in the target worksheet and adding the joint primary key to obtain the combined information of each gift allocation mechanism; saving the modified target worksheet as a comprehensive worksheet.
[0056] Among them, all product information of the same gift mechanism in the target worksheet is combined. First, the data in the column corresponding to each sales feature in the target worksheet can be deleted, and then the parts with the same content in the product information of different products of the same gift mechanism can be merged to obtain a row of product information, and then a new column is added as the data column corresponding to the joint primary key, and the joint primary keys corresponding to each gift mechanism are added to the data column corresponding to the joint primary key in the same row.
[0057] In the comprehensive worksheet, the joint primary key, as the keyword for uniquely identifying the rows of the table, can uniquely identify a row of data in the target worksheet, and delete redundant information by merging data. Through the comprehensive worksheet, staff can quickly and clearly access each allocation mechanism and the joint primary key of each allocation mechanism.
[0058] S104. Determine the audit opinion of the current allocation mechanism based on the combined primary key and historical files.
[0059] The historical file includes the historical allocation mechanism, the joint primary key corresponding to the historical allocation mechanism, and the audit opinion. It should be noted here that the creation rules of the joint primary key corresponding to the historical allocation mechanism are consistent with the current creation rules of each joint primary key, and the joint primary key and audit opinion corresponding to the historical allocation mechanism have been verified and confirmed. On this basis, the joint primary key corresponding to the historical allocation mechanism in the historical file is matched with the joint primary key of the current allocation mechanism, and the audit opinion corresponding to the matched historical allocation mechanism is used as the audit opinion of the current allocation mechanism. The audit opinion can be "agree", "disagree", "approved", or "approved".
[0060] Although the historical allocation mechanism is mentioned in this step, there is no need to compare the details of the historical allocation mechanism with the current allocation mechanism. It is only necessary to compare the joint primary key of the two.
[0061] It can be seen from the joint primary key in S103 that if the types of feature information are small, the gift-matching mechanism cannot be accurately reflected. For example, when only the product code, configuration quantity and price are included but the product type is not included, a product can be used as the main product in gift-matching mechanism 3, but it may be a gift in gift-matching mechanism 5. When the product type is not included, the main product and the gift in the gift-matching mechanism cannot be distinguished. If there are many types of feature information, for example, in addition to the above features, the month, platform name, etc. are also included, on the one hand, the redundant information of the joint primary key is increased, which is not conducive to fast matching when using the joint component. On the other hand, the scope of the gift-matching mechanism expressed by the joint primary key is too small, which may cause more current gift-matching mechanisms to fail to match the corresponding historical files, and the audit opinion of the current gift-matching mechanism cannot be determined based on the historical files. Therefore, in this embodiment, the feature information representing the sales characteristics of the product is set to include at least product type, product code, configuration quantity and price, which can accurately reflect the gift-matching mechanism, and will not limit the scope of the gift-matching mechanism expressed by the joint primary key too small, so as to facilitate matching to the corresponding historical files, thereby realizing automatic audit.
[0062] An embodiment of the present invention provides a method for auditing a gift mechanism, which obtains a target worksheet including product information of multiple products, each gift mechanism corresponding to at least one product information; for each gift mechanism, multiple feature information representing the sales features of the product are selected from the product information corresponding to the gift mechanism; a joint primary key of the gift mechanism is generated based on the feature information; and the audit opinion of the current gift mechanism is determined according to the joint primary key and a historical file, wherein the historical file includes the historical gift mechanism, the joint primary key corresponding to the historical gift mechanism, and the audit opinion. Gift mechanisms with different sales features are classified in the form of a joint primary key, and the gift mechanism to be audited can be automatically matched according to the historical file, that is, the audit opinion of the current gift mechanism can be determined according to the audit opinion of the same gift mechanism in the historical file. For the current gift mechanism that can match the corresponding historical file, there is no need for manual calculation and audit, which reduces the workload and cost of manual audit and improves the audit efficiency.
[0063] Embodiment 2
[0064] Figure 2 This is a flow chart of a method for reviewing a gift mechanism provided in the second embodiment of the present invention. The embodiment of the present invention is optimized on the basis of the above-mentioned first embodiment. Figure 2 As shown, the audit method of the matching mechanism includes:
[0065] S201. Obtain a target worksheet including product information of a plurality of products, wherein each gift distribution mechanism corresponds to at least one product information.
[0066] S202: For each gift-matching mechanism, select a plurality of characteristic information representing sales characteristics of the product from the product information corresponding to the gift-matching mechanism.
[0067] S203. Generate a joint primary key of the gift matching mechanism based on the feature information.
[0068] S201-S203 are similar to S101-S103 in the first embodiment, and the details may refer to the contents in the first embodiment.
[0069] S204: Using the joint primary key as an index field, search the historical files for a historical allocation mechanism corresponding to the joint primary key.
[0070] The historical file includes the historical allocation mechanism, the joint primary key corresponding to the historical allocation mechanism, and the audit opinion. In the historical file, each historical allocation mechanism corresponds to a joint primary key and an audit opinion.
[0071] S205. Determine whether there is a historical allocation mechanism corresponding to the joint primary key.
[0072] If yes, execute S206, if no, execute S208.
[0073] The composite primary key can be an identifiable mechanism primary key, which is matched using the SQL language.
[0074] S206. Use the historical allocation mechanism corresponding to the joint primary key as the first allocation mechanism.
[0075] S207. Determine the audit opinion of the current allocation mechanism according to the audit opinion corresponding to the first allocation mechanism.
[0076] Optionally, the number of first gift matching mechanisms is one or more, and the joint primary key is used as the index field, and the historical gift matching mechanism corresponding to the joint primary key is searched in the historical file, including: judging whether there is a historical gift matching mechanism corresponding to the joint primary key; if so, taking the historical gift matching mechanism corresponding to the joint primary key as the first gift matching mechanism, and determining the audit opinion of the current gift matching mechanism according to the audit opinion corresponding to the first gift matching mechanism. When the number of first gift matching mechanisms is one, the audit opinion corresponding to the first gift matching mechanism is taken as the audit opinion of the current gift matching mechanism; when the number of first gift matching mechanisms is multiple, the current gift matching mechanism and the store name corresponding to each first gift matching mechanism are determined respectively, and the current store name and multiple reference store names are obtained; the audit opinion of the current gift matching mechanism is determined according to the overlap between the current store name and the reference store name.
[0077] Among them, the review opinion of the current gift matching mechanism is determined according to the overlap between the current store name and the reference store name, including: judging whether there is a reference store name identical to the current store name; if so, taking the first gift matching mechanism corresponding to the reference store name identical to the current store name as the second gift matching mechanism; if not, taking the latest first gift matching mechanism as the second gift matching mechanism; and taking the review opinion of the second gift matching mechanism as the review opinion of the current gift matching mechanism.
[0078] The audit opinions of the historical gift matching mechanism of the same store or other stores can be used as the audit opinions of the current gift matching mechanism. However, when there are multiple historical gift matching mechanisms at the same time, considering the differences in sales volume, turnover, sales strategies, etc. of different stores, the universality of the same gift matching mechanism in different stores may be different. Therefore, setting the audit opinion priority of the historical gift matching mechanism of the same store to the highest can ensure the accuracy and feasibility of the audit opinions on the basis of realizing automatic audit.
[0079] Example 1: The current gift matching mechanism corresponds to store N1. However, in historical data, the same gift matching mechanism has been applied to store N1, store N2, and store N3. The first gift matching mechanism corresponding to store N1 is used as the second gift matching mechanism.
[0080] Example 2: The current gift matching mechanism corresponds to store N1, but in the historical data, the same gift matching mechanism has been applied to stores N2 and N3. The first gift matching mechanism corresponding to store N3 is the latest one, so the first gift matching mechanism corresponding to store N3 is used as the second gift matching mechanism. The latest gift matching mechanism means that the review opinion of the gift matching mechanism has been changed and is different from the historical data, indicating that the latest gift matching mechanism is a newly implemented gift matching mechanism that has passed the review.
[0081] S208. Set a manual review label for the gift matching mechanism.
[0082] When there is a historical allocation mechanism corresponding to the joint primary key, it means that the current allocation mechanism is a new allocation mechanism, which has not been evaluated and reviewed in history. Therefore, a manual review label is set for the allocation mechanism to facilitate targeted review by staff.
[0083] Optionally, product information includes the product's promotion level and product type. After determining the audit opinion of the current gift matching mechanism based on the joint primary key and historical files, it also includes: obtaining relevant information of each target worksheet, including the activity platform, month and store name; distinguishing the target worksheets according to the activity platform and month and placing them in different folders; in each folder, distinguishing the target worksheets according to the store name and placing them in different newly created tables; in each newly created table, distinguishing the product information according to the product type and promotion level and placing them on different pages; after the settings are completed, the adjusted newly created table is stored in the database. The amount of data in the database is enriched, and the data stored in the database becomes a historical file, which can be used for future configuration mechanism audits. As the amount of data in the database increases, it is conducive to the automatic audit of more configuration mechanisms. Among them, the new gift matching mechanism can also be stored as a historical file after manual review.
[0084] The above process can be implemented by Python, which reads all files and pages of data uniformly, stores them in the database, and adds corresponding fields such as month, platform, package / single product, promotion level, etc. according to the folder name, file name, and excel page name to distinguish them, and obtain data that conforms to the structure of the storage table. For example, in the same workbook, the worksheet name of the first page is: Package-Promotion Level S; the worksheet name of the second page is: Package-Promotion Level A0; the worksheet name of the third page is: Single Product-Promotion Level S; the worksheet name of the fourth page is: Single Product-Promotion Level A0. For data that does not conform to the structure of the storage table, the Python script will report an error and output the error type.
[0085] This embodiment can automate the review process of most gift matching mechanisms by adjusting the format of pending files and storing them in the warehouse, greatly shortening the manual review time and improving the review efficiency of gift matching mechanisms. In addition, when there are multiple first gift matching mechanisms, the current gift matching mechanism and the store name corresponding to each first gift matching mechanism are determined respectively to obtain the current store name and multiple reference store names; the review opinions corresponding to the first gift matching mechanism corresponding to the store with the same name are given priority as the review opinions of the current gift matching mechanism, so as to ensure the accuracy and feasibility of the review opinions on the basis of realizing automatic review.
[0086] Embodiment 3
[0087] Figure 3 This is a schematic diagram of the structure of a gift mechanism review device provided by Embodiment 3 of the present invention. Figure 3 As shown, the allocation mechanism audit device includes:
[0088] The product information acquisition module 301 is used to acquire a target worksheet including product information of a plurality of products, each gift mechanism corresponding to at least one of the product information;
[0089] A feature information extraction module 302 is used to select, for each gift-giving mechanism, a plurality of feature information representing sales features of a product from the product information corresponding to the gift-giving mechanism;
[0090] A joint primary key generation module 303, used to generate a joint primary key of the matching mechanism based on the characteristic information;
[0091] The audit opinion determination module 304 is used to determine the audit opinion of the current allocation mechanism according to the joint primary key and the historical file, wherein the historical file includes the historical allocation mechanism, the joint primary key corresponding to the historical allocation mechanism, and the audit opinion.
[0092] Optionally, the allocation mechanism audit device further includes:
[0093] A sorting module, for sorting the data structure of each target worksheet according to a preset worksheet structure for each target file, so that the data structure of the target worksheet is consistent with the data structure of the preset worksheet structure;
[0094] A checking module, for determining, for each of the target worksheets, whether the content of each product information in the target worksheet is wrong or missing; if so, executing the content of the first audit qualification determination module, if not, executing the content of the second audit qualification determination module;
[0095] A first audit qualification determination module is used to determine that the target worksheet does not have the audit qualification, and to determine the error type of the target worksheet, and to output the table name of the target worksheet, the file name of the corresponding target file, and the error type as modification information;
[0096] The second audit qualification determination module is used to determine whether the target worksheet is audit qualified.
[0097] Optionally, the allocation mechanism audit device further includes:
[0098] A combination information module, used for combining all the product information of the same gift matching mechanism in the target worksheet and adding the joint primary key to obtain the combination information of each gift matching mechanism;
[0099] The comprehensive worksheet acquisition module is used to save the modified target worksheet as a comprehensive worksheet.
[0100] Optionally, the audit opinion determination module 304 includes:
[0101] A historical allocation mechanism search submodule, used to use the joint primary key as an index field to search for a historical allocation mechanism corresponding to the joint primary key in the historical file;
[0102] A result judgment submodule is used to judge whether there is the historical allocation mechanism corresponding to the joint primary key; if so, the first allocation mechanism is executed to determine the content of the submodule; if not, the manual marking is executed to determine the content of the submodule;
[0103] The first allocation mechanism determination submodule is used to use the historical allocation mechanism corresponding to the joint primary key as the first allocation mechanism,
[0104] An audit opinion determination submodule, used to determine the audit opinion of the current matching mechanism according to the audit opinion corresponding to the first matching mechanism;
[0105] The manual labeling determination submodule is used to set a manual review label for the gift allocation mechanism.
[0106] Optionally, the number of the first matching mechanism is one or more, and the audit opinion determination submodule includes:
[0107] The first audit opinion determination unit is used to use the audit opinion corresponding to the first allocation mechanism as the audit opinion of the current allocation mechanism when the number of the first allocation mechanism is 1;
[0108] A store name determination unit, for determining the current store name and each store name corresponding to the first gift matching mechanism when there are multiple first gift matching mechanisms, to obtain the current store name and multiple reference store names;
[0109] The second audit opinion determination unit is used to determine the audit opinion of the current gift matching mechanism according to the overlap between the current store name and the reference store name.
[0110] Optionally, the audit opinion determines the second unit, including:
[0111] The same-name judgment subunit is used to judge whether there is the reference store name that is the same as the current store name; if so, the content of the first subunit is executed; if not, the content of the second subunit is executed;
[0112] A first subunit is configured to use the first gift matching mechanism corresponding to the reference store name identical to the current store name as a second gift matching mechanism;
[0113] A second subunit, configured to use the latest first allocation mechanism as a second allocation mechanism;
[0114] The audit opinion determining unit is used to use the audit opinion of the second allocation mechanism as the audit opinion of the current allocation mechanism.
[0115] Optionally, the product information includes the product promotion level and product type, and the gift mechanism review device further includes:
[0116] A related information acquisition module, used to acquire the related information of each target worksheet, wherein the related information includes the activity platform, month and store name;
[0117] A first differentiation module is used to differentiate the target worksheets according to the activity platform and month and place them in different folders;
[0118] A second distinguishing module is used to distinguish the target worksheets in each folder according to the store name and place them in different newly created tables;
[0119] A third differentiation module is used to differentiate the product information in each of the newly created tables according to product type and promotion level and place them in different pages;
[0120] The storage module is used to store the adjusted newly created table into the database after the setting is completed.
[0121] The gift-matching mechanism audit device provided in the embodiment of the present invention can execute the gift-matching mechanism audit method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
[0122] Embodiment 4
[0123] Figure 4 A schematic diagram of the structure of an electronic device 40 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.
[0124] like Figure 4As shown, the electronic device 40 includes at least one processor 41, and a memory connected to the at least one processor 41, such as a read-only memory (ROM) 42, a random access memory (RAM) 43, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 41 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 42 or the computer program loaded from the storage unit 48 to the random access memory (RAM) 43. In the RAM 43, various programs and data required for the operation of the electronic device 40 can also be stored. The processor 41, the ROM 42, and the RAM 43 are connected to each other through a bus 44. An input / output (I / O) interface 45 is also connected to the bus 44.
[0125] A number of components in the electronic device 40 are connected to the I / O interface 45, including: an input unit 46, such as a keyboard, a mouse, etc.; an output unit 47, such as various types of displays, speakers, etc.; a storage unit 48, such as a disk, an optical disk, etc.; and a communication unit 49, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 49 allows the electronic device 40 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.
[0126] The processor 41 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 41 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 41 executes the various methods and processes described above, such as the matching mechanism review method.
[0127] In some embodiments, the allocation mechanism audit method can be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 48. In some embodiments, part or all of the computer program can be loaded and / or installed on the electronic device 40 via the ROM 42 and / or the communication unit 49. When the computer program is loaded into the RAM 43 and executed by the processor 41, one or more steps of the allocation mechanism audit method described above can be performed. Alternatively, in other embodiments, the processor 41 can be configured to execute the allocation mechanism audit method in any other appropriate manner (for example, by means of firmware).
[0128] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.
[0129] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.
[0130] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0131] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).
[0132] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.
[0133] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.
[0134] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.
[0135] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims
1. A method for reviewing the matching mechanism. It is characterized in that include: Obtain a target worksheet including product information of a plurality of products, wherein each gift distribution mechanism corresponds to at least one of the product information; For each of the gift matching mechanisms, selecting a plurality of feature information representing sales features of a product from the product information corresponding to the gift matching mechanism; Generate a joint primary key of the gift matching mechanism based on the characteristic information; The audit opinion of the current allocation mechanism is determined according to the joint primary key and the historical file, wherein the historical file includes the historical allocation mechanism, the joint primary key corresponding to the historical allocation mechanism, and the audit opinion.
2. The method for auditing the gift matching mechanism as claimed in claim 1, It is characterized in that The target worksheet is a table file in the target file. Before obtaining the target worksheet including product information of a plurality of products, the method further includes: For each target file, the data structure of each target worksheet is sorted according to a preset worksheet structure, so that the data structure of the target worksheet is consistent with the data structure of the preset worksheet structure; For each of the target worksheets, determining whether the content of each product information in the target worksheet is wrong or missing; If so, determine that the target worksheet does not have the audit qualification, determine the error type of the target worksheet, and output the table name of the target worksheet, the corresponding file name of the target file and the error type as modification information; If not, determine that the target worksheet is eligible for review.
3. The method for auditing the gift matching mechanism as described in any one of claims 1-2, It is characterized in that After generating the joint primary key of the gift matching mechanism based on the feature information, the method further includes: Combine all the product information of the same gift matching mechanism in the target work table and add the joint primary key to obtain the combined information of each gift matching mechanism; The modified target worksheet is saved as a comprehensive worksheet.
4. The method for auditing the gift matching mechanism as described in any one of claims 1 to 3, It is characterized in that The audit opinion of the current allocation mechanism is determined based on the combined primary key and the historical file, including: Using the joint primary key as an index field, searching the historical files for the historical allocation mechanism corresponding to the joint primary key; Determine whether the historical allocation mechanism corresponding to the joint primary key exists; If yes, the historical allocation mechanism corresponding to the joint primary key is used as the first allocation mechanism. Determining the current review opinion of the matching mechanism according to the review opinion corresponding to the first matching mechanism; If not, a manual review tag is set for the matching mechanism.
5. The method for auditing the gift matching mechanism as claimed in claim 4, It is characterized in that The number of the first gift matching mechanism is one or more, and the determining the current audit opinion of the gift matching mechanism according to the audit opinion corresponding to the first gift matching mechanism includes: When the number of the first gift allocation mechanism is 1, the review opinion corresponding to the first gift allocation mechanism is used as the review opinion of the current gift allocation mechanism; When there are multiple first gift matching mechanisms, respectively determine the current gift matching mechanism and the store name corresponding to each first gift matching mechanism to obtain the current store name and multiple reference store names; The review opinion of the current gift matching mechanism is determined based on the overlap between the current store name and the reference store name.
6. The method for auditing the gift matching mechanism as claimed in claim 5, It is characterized in that The determining of the review opinion of the current gift matching mechanism according to the overlap between the current store name and the reference store name includes: Determine whether there is the reference store name that is the same as the current store name; If so, using the first gift matching mechanism corresponding to the reference store name that is the same as the current store name as the second gift matching mechanism; If not, the latest first allocation mechanism will be used as the second allocation mechanism; The audit opinion of the second matching mechanism shall be used as the audit opinion of the current matching mechanism.
7. The method for auditing the gift matching mechanism as described in any one of claims 1 to 3, It is characterized in that The product information includes the promotion level and product type of the product, and after determining the audit opinion of the current gift matching mechanism according to the joint primary key and the historical file, further includes: Obtaining relevant information of each target worksheet, the relevant information including activity platform, month and store name; Separate the target worksheets according to activity platforms and months and place them in different folders; In each of the folders, the target worksheets are differentiated according to the store names and placed in different newly created tables; In each of the newly created tables, the product information is differentiated according to product type and promotion level and placed in different pages; After the setting is completed, the adjusted newly created table is stored in the database.
8. A device for auditing a distribution mechanism, It is characterized in that include: A product information acquisition module, used to acquire a target worksheet including product information of a plurality of products, each gift mechanism corresponding to at least one of the product information; A feature information extraction module, for selecting, for each gift-matching mechanism, a plurality of feature information representing sales features of a product from the product information corresponding to the gift-matching mechanism; A joint primary key generation module, used to generate a joint primary key of the matching mechanism based on the characteristic information; The audit opinion determination module is used to determine the audit opinion of the current allocation mechanism based on the joint primary key and historical files, and the historical files include historical allocation mechanisms, joint primary keys corresponding to the historical allocation mechanisms, and audit opinions.
9. An electronic device, It is characterized in that The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the allocation mechanism audit method described in any one of claims 1-7.
10. A computer-readable storage medium, It is characterized in that The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the allocation mechanism review method described in any one of claims 1-7 when executed.
