[go: up one dir, main page]

CN120689106A - Store operation commodity configuration method, device, storage medium and computer equipment - Google Patents

Store operation commodity configuration method, device, storage medium and computer equipment

Info

Publication number
CN120689106A
CN120689106A CN202510930425.0A CN202510930425A CN120689106A CN 120689106 A CN120689106 A CN 120689106A CN 202510930425 A CN202510930425 A CN 202510930425A CN 120689106 A CN120689106 A CN 120689106A
Authority
CN
China
Prior art keywords
rule
store
target
commodity
list
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202510930425.0A
Other languages
Chinese (zh)
Inventor
何顺槺
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chuangyou Digital Technology Guangdong Co Ltd
Original Assignee
Chuangyou Digital Technology Guangdong Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Chuangyou Digital Technology Guangdong Co Ltd filed Critical Chuangyou Digital Technology Guangdong Co Ltd
Priority to CN202510930425.0A priority Critical patent/CN120689106A/en
Publication of CN120689106A publication Critical patent/CN120689106A/en
Pending legal-status Critical Current

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

According to the store operation commodity configuration method, the store operation commodity configuration device, the storage medium and the computer equipment, the update records to be processed are obtained from the subscribed message queue, and the target update records matched with the target store are accurately selected, so that change information of store attributes can be timely captured. And determining the changed attribute information of the target store based on the update records, and matching the attribute information with a preset rule definition table to form a first rule table, so that dynamic update of store operation rules is realized, and the rule is ensured to be matched with the current attribute of the store. And then comparing the first rule table with a second rule table which is currently effective in the target store, accurately determining rules to be deleted and newly added, and further adjusting the commodity list of the target store. The method effectively solves the problems of untimely rule updating, rough treatment and the like caused by manual notification and manual updating in the past, and improves the efficiency and accuracy of rule management.

Description

Store business commodity configuration method, store business commodity configuration device, storage medium and computer equipment
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and apparatus for configuring store business articles, a storage medium, and a computer device.
Background
In business rule management systems in the retail industry, the applicability of store operating rules is largely dependent on its key attributes, including grade, type, geographic location, and affiliated organization. Changes in these attributes, such as store upgrades, regional adjustments, or business information changes, can directly affect store operation rule applicability, potentially leading to failure of the original rule, while requiring the enablement of new applicable rules.
At present, in the configuration process of store commodity operation, the adjustment of business rules mainly depends on manual notification and manual update, so that the rule update cannot respond to attribute change in time. In addition, when facing large-scale shops and complex rule systems, the rule updating process is extensive, and the instantaneity is insufficient, which not only affects the instantaneity of business decisions, but also can cause operation risks. Such inefficient rule management mechanisms have failed to meet the requirements of modern retail businesses for agile response and accurate configuration.
Disclosure of Invention
The present application aims to solve at least one of the above technical drawbacks, and in particular, the technical drawbacks of the prior art that the inefficient rule management mechanism has failed to meet the requirements of modern retail business for agile response and accurate configuration.
In a first aspect, the present application provides a method for configuring a store-operated commodity, the method comprising:
determining a target store;
acquiring an update record to be processed from a subscribed message queue, and selecting a target update record matched with the target store from the update record;
Determining store attribute information of the target store after attribute change based on each target update record, and matching the store attribute information in a preset rule definition table according to the store attribute information to form a first rule table;
after a second rule table which is currently effective in the target store is obtained, comparing the first rule table with the second rule table to determine a rule to be deleted and a rule to be newly added;
and determining a first commodity list managed and controlled under each rule to be deleted and a second commodity list managed and controlled under each rule to be newly added, and adjusting the current commodity management list of the target store according to the first commodity list and the second commodity list.
In one embodiment, the obtaining the update record to be processed in the subscribed message queue and selecting the target update record matched with the target store from the update record includes:
determining subscribed message queues, and acquiring update records to be processed from the message queues;
And extracting the store identification number of each acquired update record, selecting the update record with the store identification number corresponding to the target store from the update records, and determining the selected update record as a target update record.
In one embodiment, the determining, based on each target update record, store attribute information of the target store after attribute change includes:
Acquiring various database tables related to the target store;
Traversing each target update record, determining a database table corresponding to each target update record in each database table for each target update record, and updating the database table;
And after traversing each target update record, generating store attribute information of the target store after attribute change according to the current database tables.
In one embodiment, the matching in a preset rule definition table according to the store attribute information to form a first rule table includes:
Determining a preset rule definition table, and acquiring the effective condition of each rule in the rule definition table;
for each rule in the rule definition table, if the store attribute information meets the effective condition of the rule, adding the rule into a preset table;
and determining the latest preset table as a first rule table when each rule in the rule definition table is traversed.
In one embodiment, the comparing the first rule table with the second rule table to determine the rule to be deleted and the rule to be newly added includes:
For each rule in the first rule table, comparing the rule with each rule in the second rule table one by one, and determining the rule as a rule to be newly added if the rule does not exist in the second rule table when the comparison is completed;
And comparing each rule in the second rule table with each rule in the first rule table one by one, and determining the rule as a rule to be deleted if the rule does not exist in the first rule table when the comparison is completed.
In one embodiment, the determining the first commodity list under control of each rule to be deleted and the second commodity list under control of each rule to be newly added includes:
Inquiring a commodity list corresponding to the rule number of each rule to be deleted in a preset commodity association library, and summarizing the commodity list corresponding to each rule to be deleted to obtain a first commodity list;
And inquiring a commodity list corresponding to the rule number of each rule to be newly added in the commodity association library, and summarizing the commodity list corresponding to each rule to be newly added to obtain a second commodity list.
In one embodiment, the adjusting the current business commodity list of the target store according to the first commodity list and the second commodity list includes:
Acquiring a current commodity management list of the target store;
And deleting the commodities contained in the first commodity list in the commodity management list, and adding the commodities in the second commodity list to the deleted commodity management list to obtain a commodity management list of the final application of the target store.
In a second aspect, the present application provides a store-operated commodity allocation apparatus, the apparatus comprising:
The store determining module is used for determining a target store;
the record selecting module is used for acquiring the update record to be processed from the subscribed message queue and selecting a target update record matched with the target store from the update record;
The rule determining module is used for determining store attribute information of the target store after attribute change based on each target update record, and matching the store attribute information in a preset rule definition table according to the store attribute information to form a first rule table;
the rule comparison module is used for comparing the first rule table with the second rule table after acquiring the second rule table which is currently effective by the target store, and determining a rule to be deleted and a rule to be newly added;
and the commodity adjustment module is used for determining a first commodity list controlled by each rule to be deleted and a second commodity list controlled by each rule to be newly added, and adjusting the current commodity management list of the target store according to the first commodity list and the second commodity list.
In a third aspect, the present application provides a storage medium having stored therein computer readable instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of a store operation commodity configuration method according to any one of the embodiments described above.
In a fourth aspect, the present application provides a computer device comprising one or more processors, and a memory;
the memory has stored therein computer readable instructions which, when executed by the one or more processors, perform the steps of the store business commodity configuration method according to any of the embodiments described above.
From the above technical solutions, the embodiment of the present application has the following advantages:
According to the store operation commodity configuration method, the store operation commodity configuration device, the storage medium and the computer equipment, the update records to be processed are obtained from the subscribed message queue, and the target update records matched with the target store are accurately selected, so that the change information of the store attribute can be timely captured, the attribute information of the changed target store is determined based on the update records, and is matched with the preset rule definition table to form the first rule table, so that dynamic update of the store operation rule is realized, and the rule is ensured to be matched with the current attribute of the store. And then comparing the first rule table with a second rule table which is currently effective in the target store to accurately determine the rules to be deleted and newly added, and further adjusting the commodity list of the target store. The automatic rule updating and commodity list adjusting mechanism effectively solves the problems of untimely rule updating, rough treatment, insufficient instantaneity and the like caused by manual notification and manual updating in the past, improves the efficiency and accuracy of rule management, achieves the aim of quick response to store attribute change, further ensures the instantaneity and the accuracy of business decision, and reduces the operation risk.
Drawings
In order to more clearly illustrate the embodiments of the application or the technical solutions of the prior art, the drawings which are used in the description of the embodiments or the prior art will be briefly described, it being obvious that the drawings in the description below are only some embodiments of the application, and that other drawings can be obtained from these drawings without inventive faculty for a person skilled in the art.
FIG. 1 is a schematic flow chart of a method for configuring store business articles according to an embodiment of the present application;
Fig. 2 is a schematic flow chart of matching in a preset rule definition table according to store attribute information to form a first rule table according to an embodiment of the present application;
FIG. 3 is a diagram illustrating an exemplary method for configuring a store business commodity according to an embodiment of the present application;
Fig. 4 is a schematic structural diagram of a store operation commodity configuration device according to an embodiment of the present application;
fig. 5 is an internal structure diagram of a computer device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
In one embodiment, the application provides a store operation commodity configuration method, and the following embodiment is used for describing the method applied to a server. It will be appreciated that the method for performing store operation commodity configuration may be a single server or may be a server cluster composed of a plurality of servers, which is not particularly limited in the present application.
Specifically, in the current configuration process of commodity management in a store, the adjustment of business rules mainly depends on manual notification and manual update, so that the rule update cannot respond to attribute change in time. In addition, when facing large-scale shops and complex rule systems, the rule updating process is extensive, and the instantaneity is insufficient, which not only affects the instantaneity of business decisions, but also can cause operation risks. Such inefficient rule management mechanisms have failed to meet the requirements of modern retail businesses for agile response and accurate configuration. Based on this, as shown in fig. 1, the present application provides a method for configuring a store business commodity, the method comprising:
s101, determining a target store.
In this step, when a user needs to configure a commodity managed by a store, a store to be configured with the commodity, that is, a target store, is first determined.
S102, acquiring a pending update record from a subscribed message queue, and selecting a target update record matched with a target store from the pending update record.
The update record refers to a record of information of store attribute change, and includes, but is not limited to, table name, store identification number, change field and changed numerical value, processing identification, and the like.
In this step, the server may subscribe to a specific message queue, and when an update record is newly added in the message queue, the server may monitor this, and when the server detects that an update record is newly added in the message queue, the server may acquire an update record identified as to be processed from the message queue, and since these update records may cover a plurality of stores, a target update record corresponding to a target store may be selected from among the update records to be processed according to the store identification numbers included in the update record.
Illustratively, when a store is upgraded from a general store to a flagship store, the server can detect the change in the table synchronization stage, further obtain an updated record containing the store identification number and the upgrade information, and by matching the store number, the server can accurately identify that the record is related to the target store. The real-time acquisition and screening mechanism ensures that the system can capture any changes in store attributes in time and provides an accurate data basis for subsequent rule updates and commodity configuration adjustments.
It can be understood that for balancing the resource consumption caused by detecting the number of message queues and the timeliness caused by real-time detection, a timing task can be set, and detection can be performed when the triggering condition of the timing task is met.
The method comprises the steps of identifying records with keywords of UPDATE in a table synchronization process, comparing fields related to change in each record with corresponding fields in a current database to determine change fields and updated values thereof, acquiring store identification numbers and table names from the records, generating updated records according to the change fields and the changed values thereof, the store identification numbers and the table names, setting processing identification in the updated records to be processed, and storing the obtained updated records in the message queue.
In one example, an update record contains the following fields:
1. data_table_name: the table name (e.g., "store") to which the record belongs.
2. Data_key-the primary key of storing the record in JSON format (e.g., for store, the primary key may be { "store_id": "store identification number" }).
3. And (6) storing a key value pair set in a JSON format, wherein the key is a changed field name, namely a changed field, and the value is a new value of the field, namely a changed numerical value.
4. Message_status, process identity, default to 1, indicates pending.
And S103, determining store attribute information of the target stores after attribute change based on each target update record, and matching the store attribute information in a preset rule definition table according to the store attribute information to form a first rule table.
The store attribute information includes each attribute of the target store and its attribute value, that is, the store attribute information is composed of a changed attribute and its attribute value and an unchanged attribute and its attribute value. The rule definition table is used for recording various possible store attribute combinations and corresponding operation rules.
In this step, after the target update records corresponding to the target store are acquired, the target update records may be parsed to extract the attribute value after the store attribute is changed. For example, if a store is upgraded from an ordinary store to a flagship, the update record may include new ranking information "flagship". And then, summarizing the updated store attributes and the attribute values thereof and the unchanged attributes corresponding to the target store and the attribute values thereof to obtain store attribute information of the target store after the attribute change. And then matching is carried out in a preset rule definition table. The rule definition table details the operation rules corresponding to the attribute combinations of different grades, types, geographic positions, affiliated organizations and the like. The system finds a set of rules applicable to the current attribute of the target store by looking up matching items in the rule definition table, thereby forming a first rule table.
Illustratively, the rule definition table may specify that the flagship should be configured with a high-end commodity family, implement a more flexible promotion policy, and so forth. By the method, the changed attribute can be detected in time, and then a new set of operation rules can be generated rapidly according to the latest attribute of the store, so that the operation rules of the store are ensured to be matched with the current attribute, and therefore accurate service configuration and management are realized.
S104, after the second rule table which is currently effective in the target store is obtained, the first rule table and the second rule table are compared, and the rule to be deleted and the rule to be newly added are determined.
The second rule table is used for recording rule sets matched with store attribute information before the target store is not changed, namely rule sets in effect of the current target store. The rule to be deleted refers to a rule existing in the second rule table but not in the first rule table, and the rule to be newly added refers to a rule existing in the first rule table but not in the second rule table.
In this step, after the first rule table based on the latest attribute of the target store is generated, a second rule table in which the target store is currently in effect may be acquired. The second rule table records the operating rules currently being used by the target store. Then, by comparing the first rule table and the second rule table, it can be determined which rules need to be deleted and which rules need to be newly added. Specifically, rule entries in two rule tables may be compared one by one. If a rule exists in the first rule table but does not exist in the second rule table, then the rule is the rule to be newly added. Conversely, if a rule exists in the second rule table but does not exist in the first rule table, then the rule is the rule to be deleted. The accurate comparison mechanism not only ensures the accuracy and the integrity of rule updating and avoids omission or mistakes of rules, but also can timely adjust the operation rules according to the change of store attributes and ensure that the operation rules of stores are always matched with the current attributes.
In one embodiment, since the identification number of the rule is recorded in the second rule table, the second rule table may also be visually displayed in a physical view, and in particular, the specific content of each rule may be displayed in a table form, so as to improve the readability and understandability of the rule.
S105, determining a first commodity list managed and controlled under each rule to be deleted and a second commodity list managed and controlled under each rule to be newly added, and adjusting the current commodity management list of the target store according to the first commodity list and the second commodity list.
Wherein the first inventory includes a set of inventory SKU (Stock Keeping Unit, minimum stock unit) identifications covered by respective rules to be deleted. The second commodity list comprises a set of commodity SKU identifiers covered by each new rule to be added. The inventory of business items is used to record a set of item SKU identifications that are operated by the target store. The item SKU identification refers to an item number that represents the minimum stock keeping unit of the item.
In this step, when the rule to be deleted and the rule to be newly added are determined, the commodity list under the control of these rules may be determined next. Specifically, for each rule to be deleted, a list of products governed by the rule is queried to generate a first list of products. The first inventory records the business items to be pruned. And similarly, for each rule to be newly added, inquiring the commodity list regulated by the rule to generate a second commodity list. The second inventory records the business items to be added.
For example, assuming that a store is promoted from a general store to a flagship store, the rule to be deleted may be "a general product series promotion" where the first product list to be managed includes general products A, B, C, and the rule to be newly added may be "a high-end product series promotion" where the second product list to be managed includes high-end products X, Y, Z. And adjusting the current business commodity list of the target store according to the first commodity list and the second commodity list. The specific operation is to remove the common commodity A, B, C in the first commodity list from the operational commodity list of the target store, and add the high-end commodity X, Y, Z in the second commodity list to the operational commodity list of the target store. By the method, the commodity management bill of the target store can accurately reflect the latest operation rule, and the commodity configuration of the store is ensured to be matched with the current attribute.
In the above embodiment, the update record to be processed is obtained from the subscribed message queue, and the target update record matched with the target store is accurately selected, so that the change information of the store attribute can be captured in time, then the attribute information of the target store after the change is determined based on the update records, and the attribute information is matched with the preset rule definition table to form the first rule table, thereby realizing the dynamic update of the store operation rule and ensuring that the rule is matched with the current attribute of the store. And then comparing the first rule table with a second rule table which is currently effective in the target store to accurately determine the rules to be deleted and newly added, and further adjusting the commodity list of the target store. The automatic rule updating and commodity list adjusting mechanism effectively solves the problems of untimely rule updating, rough treatment, insufficient instantaneity and the like caused by manual notification and manual updating in the past, improves the efficiency and accuracy of rule management, achieves the aim of quick response to store attribute change, further ensures the instantaneity and the accuracy of business decision, and reduces the operation risk.
In one embodiment, obtaining the update record to be processed in the subscribed message queue and selecting the target update record matched with the target store from the update record comprises:
s1, determining a subscribed message queue, and acquiring an update record to be processed from the message queue.
S2, extracting the store identification number of each acquired update record, selecting the update record with the store identification number corresponding to the target store from the update records, and determining the selected update record as the target update record.
Wherein the message queue is used to store and transmit updated records regarding store attribute changes. Thus, each store can monitor the message queue to acquire the target update record corresponding to the respective store.
In this embodiment, the subscribed message queue is first determined. This message queue is typically provided by the enterprise's message middleware (e.g., rabbitMQ, kafka, etc.) for storing and transmitting updated records of store property changes. Then, by subscribing to the message queue, all the update records to be processed can be obtained in real time. These updated records contain various kinds of attribute change information for each store. After all the update records to be processed are obtained from the message queue, the store identification numbers in each update record can be extracted one by one. And then, selecting a target update record corresponding to the target store by comparing the extracted store identification number with the store identification number corresponding to the target store. Therefore, the update records related to the target store are accurately screened out, and regular update and commodity configuration adjustment of the target store can be timely and accurately performed.
In one embodiment, determining store attribute information of a target store after attribute change based on each target update record includes:
s1, acquiring various database tables related to target stores.
And S2, traversing each target update record, determining a database table corresponding to each target update record in each database table for each target update record, and updating the database table.
And S3, after each target update record is traversed, generating store attribute information of the target store after attribute change according to the current database tables.
In this embodiment, each database table is acquired from the database corresponding to the target store, and the database tables record the store attribute corresponding to the target store and the attribute value thereof. When traversing each target update record, for each target update record, a database table corresponding to the target update record may be determined in each database table, and updated based on the target update record. And updating the attribute value of the corresponding attribute in the database table by the changed attribute recorded in the target update record and the attribute value of the changed attribute. And after traversing each target update record, generating store attribute information of the target store after attribute change according to the current database tables. For subsequent attribute comparison and commodity adjustment based on the store attribute information.
As shown in fig. 2, in one embodiment, matching is performed in a preset rule definition table according to store attribute information to form a first rule table, including:
S201, determining a preset rule definition table, and acquiring the effective condition of each rule in the rule definition table.
S202, for each rule in the rule definition table, if the store attribute information meets the effective condition of the rule, adding the rule into the preset table.
S203, determining the latest preset table as a first rule table when each rule in the rule definition table is traversed.
Wherein, the effective condition refers to a condition for enabling the corresponding rule.
In this embodiment, a predetermined rule definition table is first determined, where the rule definition table includes all possible store operation rules and their validation conditions. After the rule definition table is obtained, each rule in the table and its validation conditions can be read one by one. For each rule, it is checked whether the target store corresponding store attribute information satisfies the validation condition of the rule. For example, if it is determined from store attribute information that the grade of the target store is a flagship store, a rule of "configuring a high-end product series" may be added to the preset table. And then continues to traverse all rules in the rule definition table. And after all the rules are traversed, determining the finally obtained preset table as a first rule table. This first rule table contains all rules applicable to the target store after the attribute change.
For example, if the target store corresponds to the store attribute information including two conditions of "store class is flagship store" and "store type is supermarket", the first rule table may include two rules of "configuring high-end commodity series" and "executing supermarket promotion. By the method, a complete set of operation rules can be dynamically generated according to the latest attribute information of the target store, and the operation rules of the store are ensured to be matched with the current attribute.
In one example, the rule definition table may contain a rule "if the store is rated on a flagship, then a high-end commodity series must be configured" with the effect that the store is rated on a flagship ".
In one embodiment, since the identification numbers of the rules are recorded in the first rule table, the first rule table may also be visually displayed in a logic view manner, and specific contents of each rule may be specifically displayed in a table form, so as to improve readability and understandability of the rules.
In one embodiment, comparing the first rule table with the second rule table to determine the rule to be deleted and the rule to be newly added includes:
S1, comparing each rule in the first rule table with each rule in the second rule table one by one, and determining the rule as a rule to be newly added if the rule does not exist in the second rule table when the comparison is completed.
S2, for each rule in the second rule table, comparing the rule with each rule in the first rule table one by one, and determining the rule as a rule to be deleted if the rule does not exist in the first rule table when the comparison is completed.
In this embodiment, the rule to be newly added that does not exist in the second rule table may be determined from the first rule table and the rule to be deleted that does not exist in the second rule table may be determined from the second rule table by comparing piece by piece. Thereby providing accurate data basis for the subsequent adjustment of the commodity list.
In one embodiment, determining a first commodity list under control of each rule to be deleted and a second commodity list under control of each rule to be newly added includes:
S1, inquiring a commodity list corresponding to the rule number of each rule to be deleted in a preset commodity association library, and summarizing the commodity list corresponding to each rule to be deleted to obtain a first commodity list.
And S2, inquiring a commodity list corresponding to the rule number of each rule to be newly added in the commodity association library, and summarizing the commodity list corresponding to each rule to be newly added to obtain a second commodity list.
The commodity association library is used for recording the mapping relation between the rule numbers and the commodities corresponding to the rule numbers.
In this embodiment, a commodity list corresponding to a rule number of each rule to be deleted is queried in a preset commodity association library. The commodity association library is a database for storing the mapping relation between the rule numbers and the commodity list, and records the commodities managed and controlled by each rule. For example, if a rule number of a rule to be deleted is R001, a list of products corresponding to R001 is found by querying a product association library. And repeating the inquiry process, summarizing the commodity list corresponding to each rule to be deleted, and finally obtaining a first commodity list. Similarly, a commodity list corresponding to the rule number of each rule to be newly added is queried in the commodity association library. For example, if a rule number of a rule to be newly added is R002, searching a commodity list corresponding to R002 by querying a commodity association library, repeating the query process, and summarizing the commodity list corresponding to each rule to be newly added to finally obtain a second commodity list. By the method, which commodities need to be removed from the business commodity list of the store and which commodities need to be newly added can be clarified, so that accurate commodity configuration adjustment is achieved.
In one embodiment, adjusting the current business commodity list of the target store according to the first commodity list and the second commodity list includes:
S1, acquiring a current commodity management list of a target store.
And S2, deleting the commodities contained in the first commodity list in the commodity management list, and adding the commodities in the second commodity list into the deleted commodity management list to obtain a commodity management list of the final application of the target store.
In this embodiment, an operational commodity list of a target store currently in use is obtained, commodities included in a first commodity list are deleted in the operational commodity list, and then commodities in a second commodity list are added on the basis of the deleted first commodity list, so that a commodity operational list of a target store final application is obtained. Specifically, the identification can be performed according to the SKU identification of the commodity when the commodity is deleted or newly added. The change field is identified through automatic detection, and then the rule applied at present is managed so as to adjust the commodity operation list, so that the response capability of store attribute change can be improved, the commodity operation list can be adjusted quickly, and the labor cost is saved.
In one embodiment, as shown in fig. 3, fig. 3 is an exemplary diagram of a method for configuring a store business commodity according to an embodiment of the present application. Changes are detected during table synchronization and change information is written to the message queue (i.e., data_queue) in the form of updated records, and then xxl-job scheduling can be used to set the timing tasks. In the change influence analysis, on one hand, a second rule table which is currently effective, namely a physical view (rule_store_sku), on the other hand, a first rule table after attribute change, namely a logic view, is calculated, then rule difference comparison is carried out based on the first rule table and the second rule table, a new rule (namely a rule to be added) and a deletion rule (namely a rule to be deleted) are marked, finally Cartesian product calculation can be carried out through a store identification number, and a commodity SKU list (namely store_sku_temp) to be deleted and added is obtained, wherein the list can be used for adjusting a commodity management list of a target store.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
The store operation commodity configuration device provided by the embodiment of the application is described below, and the store operation commodity configuration device described below and the store operation commodity configuration method described above can be referred to correspondingly.
As shown in fig. 4, the present application provides a store operation commodity configuration apparatus 300, which includes:
a store determination module 301 for determining a target store;
the record selecting module 302 is configured to obtain an update record to be processed from a subscribed message queue, and select a target update record matched with a target store from the update record;
The rule determining module 303 is configured to determine store attribute information of the target store after the attribute is changed based on each target update record, and match the store attribute information in a preset rule definition table according to the store attribute information to form a first rule table;
The rule comparison module 304 is configured to compare the first rule table with the second rule table after obtaining the second rule table that is currently effective in the target store, and determine a rule to be deleted and a rule to be newly added;
the commodity adjustment module 305 is configured to determine a first commodity list managed under each rule to be deleted and a second commodity list managed under each rule to be newly added, and adjust a current business commodity list of the target store according to the first commodity list and the second commodity list.
In the above embodiment, the update record to be processed is obtained from the subscribed message queue, and the target update record matched with the target store is accurately selected, so that the change information of the store attribute can be captured in time, then the attribute information of the target store after the change is determined based on the update records, and the attribute information is matched with the preset rule definition table to form the first rule table, thereby realizing the dynamic update of the store operation rule and ensuring that the rule is matched with the current attribute of the store. And then comparing the first rule table with a second rule table which is currently effective in the target store to accurately determine the rules to be deleted and newly added, and further adjusting the commodity list of the target store. The automatic rule updating and commodity list adjusting mechanism effectively solves the problems of untimely rule updating, rough treatment, insufficient instantaneity and the like caused by manual notification and manual updating in the past, improves the efficiency and accuracy of rule management, achieves the aim of quick response to store attribute change, further ensures the instantaneity and the accuracy of business decision, and reduces the operation risk.
In one embodiment, the record selection module includes:
the queue determining submodule is used for determining subscribed message queues and acquiring update records to be processed from the message queues;
The record selecting sub-module is used for extracting the store identification number of each acquired update record, selecting the update record with the store identification number corresponding to the target store from the update records, and determining the selected update record as the target update record.
In one embodiment, the record selection module includes:
the table acquisition sub-module is used for acquiring each database table related to the target store;
The table updating sub-module is used for traversing each target updating record, determining a database table corresponding to each target updating record in each database table for each target updating record, and updating the database table;
And the information determination submodule is used for generating store attribute information of the target store after attribute change according to the current database tables after each target update record is traversed.
In one embodiment, the record selection module includes:
The condition acquisition sub-module is used for determining a preset rule definition table and acquiring the effective condition of each rule in the rule definition table;
The rule determining submodule is used for adding each rule in the rule definition table into the preset table if the store attribute information meets the effective condition of the rule;
and the table determination submodule is used for determining the latest preset table as a first rule table when each rule in the rule definition table is traversed.
In one embodiment, the rule comparison module includes:
the first determining submodule is used for comparing each rule in the first rule table with each rule in the second rule table one by one, and determining the rule as a rule to be newly added if the rule does not exist in the second rule table when the comparison is completed;
And the second determining submodule is used for comparing each rule in the second rule table with each rule in the first rule table one by one, and determining the rule as a rule to be deleted if the rule does not exist in the first rule table when the comparison is completed.
In one embodiment, the commodity adjustment module comprises:
The first adjustment sub-module is used for inquiring a commodity list corresponding to the rule number of each rule to be deleted in a preset commodity association library, and summarizing the commodity list corresponding to each rule to be deleted to obtain a first commodity list;
And the second adjustment sub-module is used for inquiring the commodity list corresponding to the rule number of each rule to be newly added in the commodity association library, and summarizing the commodity list corresponding to each rule to be newly added to obtain a second commodity list.
In one embodiment, the commodity adjustment module comprises:
The list acquisition sub-module is used for acquiring the current commodity list of the target store;
and the list adjustment sub-module is used for deleting the commodities contained in the first commodity list in the management commodity list, and adding the commodities in the second commodity list into the deleted management commodity list to obtain a commodity management list of the final application of the target store.
The division of the modules in the store operation commodity allocation device is merely for illustration, and in other embodiments, the store operation commodity allocation device may be divided into different modules as required to complete all or part of the functions of the store operation commodity allocation device. The respective modules in the store-operated commodity configuration apparatus described above may be implemented in whole or in part by software, hardware, or a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, the present application also provides a storage medium having stored therein computer readable instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of the store business item configuration method of any of the above embodiments.
In one embodiment, the present application also provides a computer device having stored therein computer readable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of the store business item configuration method of any of the above embodiments.
Schematically, as shown in fig. 5, fig. 5 is a schematic internal structure of a computer device according to an embodiment of the present application, and the computer device 400 may be provided as a server. Referring to FIG. 5, computer device 400 includes a processing component 402 that further includes one or more processors, and memory resources represented by memory 401, for storing instructions, such as application programs, executable by processing component 402. The application program stored in the memory 401 may include one or more modules each corresponding to a set of instructions. Further, the processing component 402 is configured to execute instructions to perform the store business commodity configuration method of any of the embodiments described above.
The computer device 400 may also include a power component 403 configured to perform power management of the computer device 400, a wired or wireless network interface 404 configured to connect the computer device 400 to a network, and an input output (I/O) interface 405. The computer device 400 may operate based on an operating system stored in memory 401, such as Window Server (TM), mac OS XTM, unix (TM), linux (TM), free BSDTM, or the like.
It will be appreciated by those skilled in the art that the structure shown in FIG. 5 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
Finally, it is further noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises an element. As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises/comprising," "includes," and/or "having," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, components, or groups thereof, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, or groups thereof, and include any and all combinations of the listed items.
In the present specification, each embodiment is described in a progressive manner, and each embodiment focuses on the difference from other embodiments, and may be combined according to needs, and the same similar parts may be referred to each other.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1.一种门店经营商品配置方法,其特征在于,所述方法包括:1. A method for configuring merchandise for store operations, characterized in that the method comprises: 确定目标门店;Identify target stores; 在已订阅的消息队列中获取待处理的更新记录,并从中选取与所述目标门店匹配的目标更新记录;Obtain pending update records from the subscribed message queue, and select a target update record that matches the target store; 基于各个目标更新记录确定所述目标门店在属性变更后的门店属性信息,并根据所述门店属性信息在预设的规则定义表中进行匹配,形成第一规则表;Determining store attribute information of the target store after the attribute change based on each target update record, and matching the store attribute information in a preset rule definition table to form a first rule table; 获取所述目标门店当前生效的第二规则表后,将所述第一规则表和所述第二规则表进行比对,确定待删除规则和待新增规则;After obtaining the second rule table currently in effect for the target store, the first rule table and the second rule table are compared to determine rules to be deleted and rules to be added; 确定各个待删除规则下管控的第一商品清单以及各个待新增规则下管控的第二商品清单,并根据所述第一商品清单和所述第二商品清单调整所述目标门店当前的经营商品清单。Determine the first commodity list controlled under each to-be-deleted rule and the second commodity list controlled under each to-be-added rule, and adjust the current operating commodity list of the target store according to the first commodity list and the second commodity list. 2.根据权利要求1所述的门店经营商品配置方法,其特征在于,所述在已订阅的消息队列中获取待处理的更新记录,并从中选取与所述目标门店匹配的目标更新记录,包括:2. The method for configuring store merchandise according to claim 1, wherein obtaining pending update records from a subscribed message queue and selecting a target update record that matches the target store comprises: 确定已订阅的消息队列,并从所述消息队列中获取待处理的更新记录;Determine a subscribed message queue and obtain pending update records from the message queue; 提取所获取的每个更新记录的门店标识号,并在各个更新记录中选取门店标识号与所述目标门店相对应的更新记录后,将选取的更新记录确定为目标更新记录。The store identification number of each acquired update record is extracted, and after selecting an update record whose store identification number corresponds to the target store from each update record, the selected update record is determined as the target update record. 3.根据权利要求1所述的门店经营商品配置方法,其特征在于,所述基于各个目标更新记录确定所述目标门店在属性变更后的门店属性信息,包括:3. The method for configuring merchandise for store operations according to claim 1, wherein determining the store attribute information of the target store after the attribute change based on each target update record comprises: 获取与所述目标门店相关的各个数据库表;Obtain various database tables related to the target store; 遍历各个目标更新记录,对于每个目标更新记录,在各个数据库表中确定与该目标更新记录对应的数据库表,并对该数据库表进行更新;Traverse each target update record, for each target update record, determine the database table corresponding to the target update record in each database table, and update the database table; 当遍历完各个目标更新记录之后,根据当前各个数据库表生成所述目标门店在属性变更后的门店属性信息。After traversing all target update records, store attribute information of the target store after the attribute change is generated according to the current database tables. 4.根据权利要求1所述的门店经营商品配置方法,其特征在于,所述根据所述门店属性信息在预设的规则定义表中进行匹配,形成第一规则表,包括:4. The method for configuring merchandise for store operations according to claim 1, wherein the step of matching the store attribute information in a preset rule definition table to form a first rule table comprises: 确定预设的规则定义表,并获取所述规则定义表中每一规则的生效条件;Determine a preset rule definition table and obtain the validity conditions of each rule in the rule definition table; 对于所述规则定义表中的每一规则,若所述门店属性信息满足该规则的生效条件,则将该规则添加至预设表中;For each rule in the rule definition table, if the store attribute information meets the validity conditions of the rule, the rule is added to the preset table; 当遍历完所述规则定义表中的每一规则时将最新的预设表确定为第一规则表。When each rule in the rule definition table is traversed, the latest preset table is determined as the first rule table. 5.根据权利要求1所述的门店经营商品配置方法,其特征在于,所述将所述第一规则表和所述第二规则表进行比对,确定待删除规则和待新增规则,包括:5. The method for configuring merchandise for store operations according to claim 1, wherein comparing the first rule table with the second rule table to determine rules to be deleted and rules to be added comprises: 对于所述第一规则表中的每一规则,将该规则与所述第二规则表中的每一规则进行逐条比对,在比对完成时若该规则不存在于所述第二规则表中,则将该规则确定为待新增规则;For each rule in the first rule table, compare the rule with each rule in the second rule table one by one. If the rule does not exist in the second rule table after the comparison is completed, determine the rule as a rule to be added; 对于所述第二规则表中的每一规则,将该规则与所述第一规则表中的每一规则进行逐条比对,在比对完成时若该规则不存在于所述第一规则表中,则将该规则确定为待删除规则。For each rule in the second rule table, the rule is compared with each rule in the first rule table one by one. When the comparison is completed, if the rule does not exist in the first rule table, the rule is determined to be a rule to be deleted. 6.根据权利要求1所述的门店经营商品配置方法,其特征在于,所述确定各个待删除规则下管控的第一商品清单以及各个待新增规则下管控的第二商品清单,包括:6. The method for configuring store merchandise according to claim 1, wherein determining the first merchandise list to be controlled under each rule to be deleted and the second merchandise list to be controlled under each rule to be added comprises: 在预设的商品关联库中查询与每个待删除规则的规则编号对应的商品列表,汇总每个待删除规则对应的商品列表,得到第一商品清单;Searching for a product list corresponding to the rule number of each rule to be deleted in a preset product association database, summarizing the product lists corresponding to each rule to be deleted, and obtaining a first product list; 在所述商品关联库中查询与每个待新增规则的规则编号对应的商品列表,汇总每个待新增规则对应的商品列表,得到第二商品清单。The commodity list corresponding to the rule number of each to-be-added rule is searched in the commodity association database, and the commodity list corresponding to each to-be-added rule is summarized to obtain a second commodity list. 7.根据权利要求1所述的门店经营商品配置方法,其特征在于,所述根据所述第一商品清单和所述第二商品清单调整所述目标门店当前的经营商品清单,包括:7. The method for configuring store merchandise according to claim 1, wherein adjusting the current merchandise list of the target store based on the first merchandise list and the second merchandise list comprises: 获取所述目标门店当前的经营商品清单;Obtain the current merchandise list of the target store; 在所述经营商品清单中删除包含在所述第一商品清单中的商品,并将所述第二商品清单中的商品添加至经过删除后的经营商品清单中,得到所述目标门店最终应用的商品经营清单。The commodities included in the first commodity list are deleted from the merchandise list, and the commodities in the second commodity list are added to the deleted merchandise list to obtain the merchandise list finally used by the target store. 8.一种门店经营商品配置装置,其特征在于,所述装置包括:8. A device for configuring merchandise for store operations, characterized in that the device comprises: 门店确定模块,用于确定目标门店;Store determination module, used to determine target stores; 记录选取模块,用于在已订阅的消息队列中获取待处理的更新记录,并从中选取与所述目标门店匹配的目标更新记录;A record selection module is used to obtain pending update records in the subscribed message queue and select target update records that match the target store; 规则确定模块,用于基于各个目标更新记录确定所述目标门店在属性变更后的门店属性信息,并根据所述门店属性信息在预设的规则定义表中进行匹配,形成第一规则表;A rule determination module, configured to determine store attribute information of the target store after the attribute change based on each target update record, and perform matching in a preset rule definition table according to the store attribute information to form a first rule table; 规则比对模块,用于获取所述目标门店当前生效的第二规则表后,将所述第一规则表和所述第二规则表进行比对,确定待删除规则和待新增规则;A rule comparison module is configured to obtain the second rule table currently in effect for the target store, compare the first rule table with the second rule table, and determine rules to be deleted and rules to be added; 商品调整模块,用于确定各个待删除规则下管控的第一商品清单以及各个待新增规则下管控的第二商品清单,并根据所述第一商品清单和所述第二商品清单调整所述目标门店当前的经营商品清单。The commodity adjustment module is used to determine the first commodity list controlled under each to-be-deleted rule and the second commodity list controlled under each to-be-added rule, and adjust the current operating commodity list of the target store according to the first commodity list and the second commodity list. 9.一种存储介质,其特征在于:所述存储介质中存储有计算机可读指令,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行如权利要求1至7中任一项所述门店经营商品配置方法的步骤。9. A storage medium, characterized in that: the storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the store operation product configuration method as described in any one of claims 1 to 7. 10.一种计算机设备,其特征在于,包括:一个或多个处理器,以及存储器;10. A computer device, comprising: one or more processors, and a memory; 所述存储器中存储有计算机可读指令,所述计算机可读指令被所述一个或多个处理器执行时,执行如权利要求1至7中任一项所述门店经营商品配置方法的步骤。The memory stores computer-readable instructions, and when the computer-readable instructions are executed by the one or more processors, the steps of the store merchandise configuration method according to any one of claims 1 to 7 are executed.
CN202510930425.0A 2025-07-07 2025-07-07 Store operation commodity configuration method, device, storage medium and computer equipment Pending CN120689106A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202510930425.0A CN120689106A (en) 2025-07-07 2025-07-07 Store operation commodity configuration method, device, storage medium and computer equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202510930425.0A CN120689106A (en) 2025-07-07 2025-07-07 Store operation commodity configuration method, device, storage medium and computer equipment

Publications (1)

Publication Number Publication Date
CN120689106A true CN120689106A (en) 2025-09-23

Family

ID=97082067

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202510930425.0A Pending CN120689106A (en) 2025-07-07 2025-07-07 Store operation commodity configuration method, device, storage medium and computer equipment

Country Status (1)

Country Link
CN (1) CN120689106A (en)

Similar Documents

Publication Publication Date Title
US10795643B2 (en) System and method for resource reconciliation in an enterprise management system
US11163731B1 (en) Autobuild log anomaly detection methods and systems
US8965914B2 (en) Grouping identity records to generate candidate lists to use in an entity and relationship resolution process
CN109542935B (en) Execution method of rule engine, storage medium and server
CN111459985A (en) Identification information processing method and device
CN109388657B (en) Data processing method, device, computer equipment and storage medium
CN111506559A (en) Data storage method and device, electronic equipment and storage medium
CN112214505B (en) Data synchronization method, device, computer readable storage medium and electronic equipment
US11562319B1 (en) Machine learned item destination prediction system and associated machine learning techniques
US20210397745A1 (en) Data providing server device and data providing method
CN108829745B (en) Service data management method and device and electronic equipment
WO2022108599A1 (en) Data processing independent of storage, format or schema
CN112005232A (en) Vulnerability Status Report
US20090307527A1 (en) Data retrieval and handling systems, virtual warehousing, price comparison, price aggregation and stock availability engine
CN120689106A (en) Store operation commodity configuration method, device, storage medium and computer equipment
US20100070458A1 (en) Rule creation method and rule creating apparatus
JP6695847B2 (en) Software parts management system, computer
CN110929207B (en) Data processing method, device and computer readable storage medium
US20130318088A1 (en) Management of Class of Service
US10430775B1 (en) Validation and lookup techniques for rule-based data categorization
CN113780950A (en) Data processing method, device, server and readable storage medium
CN114925145B (en) Data storage method and device, storage medium and electronic equipment
US8874539B2 (en) Object identity and addressability
CN114257528B (en) Method, device, electronic device and storage medium for selecting Internet of Things devices
JP7668193B2 (en) System and method for proposing a sensor set - Patents.com

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination