CN111967830A - Online and offline inventory synchronization method - Google Patents
Online and offline inventory synchronization method Download PDFInfo
- Publication number
- CN111967830A CN111967830A CN202010892631.4A CN202010892631A CN111967830A CN 111967830 A CN111967830 A CN 111967830A CN 202010892631 A CN202010892631 A CN 202010892631A CN 111967830 A CN111967830 A CN 111967830A
- Authority
- CN
- China
- Prior art keywords
- inventory
- data
- information
- commodity
- data information
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Computing Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an online and offline inventory synchronization method, which comprises the following steps: integrating the respective online and offline inventory data into unified inventory data information, acquiring the inventory data information according to preset frequency, receiving a generated order, wherein the order comprises change information of commodities, updating current commodity data information based on the change information of the commodities, determining virtual available inventory data according to the inventory data information and the commodity data information, and synchronously distributing the inventory data information, the commodity data information and the virtual available inventory data; the technical scheme provided by the invention achieves the purposes of transparent and synchronous inventory of the online and offline channels, and solves the technical problem of low inventory turnover efficiency caused by opaque inventory between the online and offline channels.
Description
Technical Field
The invention relates to the field of commodity inventory management, in particular to an online and offline inventory synchronization method.
Background
When online and offline retail development reaches a certain scale, enterprises begin to enter new channels in addition to the original traditional dominant channels, and explore new channel patterns, for example, walma begins to buy some online e-commerce and starts to try some small-sized convenience stores in addition to large supermarkets. Some e-commerce also starts trying to open some offline stores, such as thousand stores plan of xianwei, offline experience store of three squirrels, million-city store plan of capillary, and so on.
With the rise of new retail, many enterprises begin to explore the full-channel business, and the foundation for developing the full-channel business is to take on-line and off-line inventory. Generally, an enterprise manages inventory in different places such as an owned e-commerce warehouse, a physical warehouse, an offline store, and the like, and how to integrate and efficiently manage the inventory and distribute the inventory to each sales channel for sales is a key for the enterprise to get through the inventory of all channels.
The traditional inventory management usually meets the problem that the demand of a consumer is not matched with the actual inventory supply, one side of the traditional inventory management is exploded in a large-scale period of an e-commerce platform, one side of the traditional inventory management is overstocked in an off-line store, the inventory between all channels on the line and the off-line is not transparent and synchronous, the traditional inventory management is difficult to allocate mutually, the unified operation is realized, and the problems of slow inventory turnover, high stock preparation rate and low inventory turnover efficiency exist for an enterprise as a whole.
Disclosure of Invention
The invention mainly aims to provide an online and offline inventory synchronization method to solve the problems of opaque and asynchronous online and offline inventory and low inventory turnover efficiency.
In order to achieve the above object, a first aspect of the present invention provides an online-offline inventory synchronization method, including:
integrating the respective online and offline inventory data into unified inventory data information, and acquiring the inventory data information according to a preset frequency;
receiving a generated order, wherein the order comprises change information of the commodity, and updating current commodity data information based on the change information of the commodity;
determining virtual available inventory data according to the inventory data information and the commodity data information;
and synchronously distributing the inventory data information, the commodity data information and the virtual available inventory data.
Optionally, the integrating the online and offline inventory data into unified inventory data information and acquiring the inventory data information according to a preset frequency includes:
the method comprises the following steps that an actual inventory management party generates a full inventory file according to inventory data of each online and offline inventory, content defined by an inventory center and a unified standard, the full inventory file is uploaded to a third-party file management system, the third-party file management system informs the inventory center through a first message queue, and the inventory center acquires, reads and processes inventory data information in the full inventory file;
wherein the full inventory file content line comprises: the stock ground code, the commodity information, the stock quantity, the updating time and the version number; the first message queue contents include: file name, file md5 value, file storage address, source channel and creation time;
and the actual inventory management party provides a call-back interface, and when the inventory center acquires, reads and processes the inventory data information in the full inventory file, if abnormal conditions occur to cause that the inventory data information cannot be repaired by self to ensure the correctness, the call-back interface informs the actual inventory management party to regenerate and synchronize the full inventory file.
Optionally, the receiving the generated order, where the order includes change information of the commodity, and updating current commodity data information based on the change information of the commodity includes:
receiving the generated order and the inventory change, sending an inventory change message or directly calling an interface to inform an inventory center by an actual inventory manager according to a unified standard, and receiving the inventory change message and processing data by the inventory center; wherein the inventory change message content includes: the system comprises a stock place code, commodity information, a unique flow code of a stock management party, a full-channel unified order number, a stock change value, a type, update time, a serial number and a unique identifier;
the inventory center initializes or corrects all inventory data corresponding to a source channel in the content of the first message queue through the full inventory file, generates at least one piece of data through the version number in the content row of the full inventory file, each piece of data corresponds to one version number, sets the current version number to take effect after the initialization or correction is completed, and provides data service for the outside by using the data associated with the effective version number.
Optionally, the receiving the generated order, where the order includes change information of the product, and updating current product data information based on the change information of the product, further includes:
meanwhile, the inventory center updates the inventory information of the commodities through the inventory change message; filtering repeated request data generated by abnormality through the unique identifier in the contents of the inventory change message, and ensuring the sequence of the inventory change message through the sequence number in the contents of the inventory change message;
when the inventory center acquires the full inventory file and the inventory change message, the corresponding inventory code and the corresponding commodity code are marked through the content line of the full inventory file and the update time in the content of the inventory change message, whether the inventory change is ordered in time or not is judged in each update, and if the judgment sequence is wrong and data abnormity can be caused, call back is carried out, and inventory of the commodities is checked again.
Optionally, the determining the virtual available inventory data according to the inventory data information and the commodity data information includes:
determining actual inventory data according to the inventory data information;
determining occupied inventory data according to the commodity data information corresponding to the order;
and calculating the difference value between the actual inventory data and the occupied inventory data to obtain virtual available inventory data.
Optionally, the determining virtual available inventory data according to the inventory data information and the commodity data information further includes:
the inventory center collects online and offline actual inventory data through inventory data information, occupied inventory data is determined through commodity data information corresponding to online and offline order information, and difference value calculation is carried out on the actual inventory data and the occupied inventory data to obtain virtual available inventory data;
the inventory center provides a uniform standard interface, and the order management center of the online and offline full channel uses the interface to occupy the inventory through order contents;
wherein, the interface content includes: the method comprises the steps of stock area coding, commodity information, full-channel unified order number, stock occupation quantity, sales type, source channel, creation time and unique identification;
after the inventory is successfully occupied, the inventory center generates an inventory occupation identifier through the full-channel unified order number, the inventory location code and the commodity information in the interface content;
and the actual inventory management party takes out the corresponding commodities according to the order contents and then notifies the inventory center of the commodity taking-out message, and the inventory center removes inventory occupation according to the commodity taking-out message, deducts and modifies the actual inventory quantity and updates occupied inventory data and actual inventory data.
Optionally, the performing data synchronization distribution on the inventory data information, the commodity data information, and the virtual available inventory data includes:
providing basic inventory data service by using the inventory data information, the commodity data information and the virtual available inventory data;
providing a configurable aggregated service using the inventory data information, the commodity data information, and the virtual available inventory data;
and synchronizing configurable total information by utilizing the inventory data information, the commodity data information and the virtual available inventory data.
Further, the providing a basic inventory data service using the inventory data information, the commodity data information, and the virtual available inventory data includes:
the inventory center inquires virtual available inventory data or actual inventory data through inventory region codes and commodity information in the interface content;
integrating the inventory occupation and the actual inventory change into a unified inventory change message, and sending the unified inventory change message to a user in real time through a second message queue;
wherein the unified inventory change message content comprises: the system comprises stock area codes, commodity information, a full-channel unified order number, a stock change value, a residual stock quantity, a service type, a change type, update time, a serial number and a unique identifier.
Further, the providing a configurable aggregated service by using the inventory data information, the commodity data information and the virtual available inventory data includes:
a user acquires the aggregation data by configuring required combination information and a calculation mode;
wherein the combined information comprises a stock place, commodity information and stock quantity; the calculation mode comprises the steps of taking the sum, taking the maximum value, taking the minimum value and taking the average number of the same commodity.
Further, the synchronizing configurable total information using the inventory data information, the commodity data information, and the virtual available inventory data includes:
a user configures combination information, a computing mode and synchronization time through a configuration and computing mode of the configurable aggregation service;
after the configuration is completed, the inventory center generates a unique identifier, inquires inventory data information in a specified synchronization time in a combined information and calculation mode, generates a file named by the unique identifier, uploads the file to a third-party file management system, sends a message notification to a user, and the user receives the message and downloads the file through the unique identifier to acquire the inventory data information.
A second aspect of the present invention provides an online-offline inventory synchronization device, including:
the acquisition unit is used for integrating the respective online and offline inventory data into unified inventory data information and acquiring the inventory data information according to preset frequency;
the updating unit is used for receiving the generated order, wherein the order comprises the change information of the commodity, and updating the current commodity data information based on the change information of the commodity;
the determining unit is used for determining virtual available inventory data according to the inventory data information and the commodity data information;
and the data synchronous distribution unit is used for carrying out data synchronous distribution on the inventory data information, the commodity data information and the virtual available inventory data.
A third aspect of the present invention provides a computer-readable storage medium having stored thereon computer instructions for causing a computer to execute an online-to-offline inventory synchronization method provided by any one of the first aspects.
A fourth aspect of the present invention provides an electronic apparatus, comprising: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to cause the at least one processor to perform a method of online-to-offline inventory synchronization as provided in any of the first aspects.
In the embodiment of the invention, on-line and off-line respective inventory data are integrated into unified inventory data information, the inventory data information is collected according to a preset frequency, a generated order is received, wherein the order comprises change information of a commodity, the current commodity data information is updated based on the change information of the commodity, then virtual available inventory data are determined according to the inventory data information and the commodity data information, and finally the inventory data information, the commodity data information and the virtual available inventory data are subjected to data synchronous distribution; the technical scheme provided by the invention achieves the purposes of transparent and synchronous inventory of the online and offline channels, and solves the technical problem of low inventory turnover efficiency caused by opaque inventory between the online and offline channels.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a schematic flow chart of an online-offline inventory synchronization method according to an embodiment of the present invention;
fig. 2 is a block diagram of an online-offline inventory synchronization apparatus according to an embodiment of the present invention;
fig. 3 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged under appropriate circumstances in order to facilitate the description of the embodiments of the invention herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict. The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings.
The traditional inventory management usually meets the problem that the demand of a consumer is not matched with the actual inventory supply, on one hand, the warehouse is exploded in a large period of an e-commerce platform, on the other hand, the inventory of stores below the online is overstocked, and the inventory among all channels above and below the online is not transparent and synchronous, so that the mutual allocation and the unified operation are difficult, and the problems of slow inventory turnover, high stock rate and low inventory turnover efficiency exist for an enterprise as a whole.
In order to solve the above problem, an embodiment of the present invention provides an online-offline inventory synchronization method, as shown in fig. 1, the method includes the following steps S101 to S104:
step S101: integrating the respective online and offline inventory data into unified inventory data information, and acquiring the inventory data information according to a preset frequency;
the inventory data of actual inventory management parties of different channels such as e-commerce warehouses, entity warehouses, off-line store shops and the like corresponding to the on-line and off-line commodities are integrated into a unified data model, so that the integrated unified inventory data information is subjected to unified processing and data management while the on-line and off-line original data of various channels are saved, and the inventory data of various channels are managed more conveniently; and acquiring the inventory data information according to a preset frequency, for example, acquiring and updating all commodities of all inventory points at a frequency of once-a-day acquisition to obtain the current latest inventory data information.
Step S102: receiving a generated order, wherein the order comprises change information of the commodity, and updating current commodity data information based on the change information of the commodity; and receiving the generated order no matter which channel the order placed by the user belongs to online and offline, wherein the order comprises the change information of the commodity, and updating the current commodity data information in real time based on the change information of the commodity to obtain the latest commodity data information after the order is generated.
Step S103: determining virtual available inventory data according to the inventory data information and the commodity data information; and calculating to obtain virtual available inventory data according to the inventory data information and the data contained in the commodity data information of the order.
Step S104: and synchronously distributing the inventory data information, the commodity data information and the virtual available inventory data. The method comprises the steps of configuring and combining various data information and specific data according to requirements, providing different configurable data services to meet different requirements, synchronously distributing the configured combined information to achieve the purpose of real-time synchronization of stock data and solve the problem of data mismatch.
In the embodiment of the invention, the inventory data of different online and offline channels are integrated into the unified inventory data information, the current commodity data information is updated according to the commodity change information corresponding to the order, the virtual available inventory data is determined according to the inventory data information and the commodity data information, and the inventory data information, the commodity data information and the virtual available inventory data are synchronously distributed, so that the real-time synchronization of the inventory data is ensured, and the problem of low inventory turnover rate caused by data mismatch is avoided.
Specifically, integrating the respective stock data online and offline into unified stock data information, collecting the stock data information according to a preset frequency includes:
the method comprises the following steps that an actual inventory management party generates a full inventory file according to inventory data of each online and offline inventory, content defined by an inventory center and a unified standard, the full inventory file is uploaded to a third-party file management system, the third-party file management system informs the inventory center through a first message queue, and the inventory center acquires, reads and processes inventory data information in the full inventory file;
the actual inventory management party comprises all reliable data holding systems such as a store management system and a warehouse management system, and further comprises a step of manually generating a full inventory file and manually informing an inventory center under the condition of no automation; the full inventory file content row includes: the stock ground code, the commodity information, the stock quantity, the updating time and the version number; the first message queue contents include: the file management system comprises a file name, a file md5 value, a file storage address, a source channel and creation time, wherein the file md5 value is used for verifying consistency after downloading a file, the file storage address is a standard address of a third-party file management system, and the source channel is uniformly managed by a channel management system;
and the actual inventory management party provides a call-back interface, and when the inventory center acquires, reads and processes the inventory data information in the full inventory file, if abnormal conditions occur to cause that the inventory data information cannot be repaired by self to ensure the correctness, the call-back interface informs the actual inventory management party to regenerate and synchronize the full inventory file.
Specifically, the receiving the generated order, where the order includes change information of the commodity, and updating current commodity data information based on the change information of the commodity includes:
receiving the generated order and the inventory change, sending an inventory change message or directly calling an interface to inform an inventory center by an actual inventory manager according to a unified standard, and receiving the inventory change message and processing data by the inventory center; wherein the inventory change message content includes: the inventory information management method comprises the steps of inventory area coding, commodity information, an inventory manager unique assembly code, a full-channel unified order number, inventory change values, types, update time, serial numbers and unique identification, wherein if the full-channel unified order number is not ignored, the inventory change values can be positive numbers and negative numbers, the types comprise increase and decrease or inventory counting, the increase and decrease refers to the change of current inventory data compared with previous inventory data, and the inventory counting refers to the fact that the current inventory data covers the previous inventory data;
the inventory center initializes or corrects all inventory data corresponding to a source channel in the content of the first message queue through the full inventory file, dynamically judges through the source channel in the content of the first message queue, initializes without initialization, and compares and corrects the initialized data.
Specifically, the receiving the generated order, where the order includes change information of the product, and updating current product data information based on the change information of the product, further includes:
meanwhile, the inventory center updates the inventory information of the commodities through the inventory change message; filtering repeated request data generated by abnormality through the unique identifier in the contents of the inventory change message, and ensuring the sequence of the inventory change message through the sequence number in the contents of the inventory change message;
when the inventory center acquires the full inventory file and the inventory change message, the corresponding inventory region code and the corresponding commodity code are marked respectively through the content line of the full inventory file and the updating time in the content of the inventory change message, whether the inventory change is ordered in time or not is judged in each updating, if the judgment sequence is wrong and the data abnormity can be caused, and the cross sequence of the inventory and increase and decrease contained in the type in the content of the inventory change message is abnormal, the call back is carried out, the inventory of the commodity is re-ordered, and the inventory data error caused by the inventory of the commodity inventory, the increase and decrease disorder and the non-chronological sequence is prevented.
Specifically, the determining the virtual available inventory data according to the inventory data information and the commodity data information includes:
determining actual inventory data according to the inventory data information; acquiring actual inventory data from inventory data information of an actual inventory manager;
determining occupied inventory data according to the commodity data information corresponding to the order; determining that the order is placed, reserved, frozen and the like to generate inventory occupation according to the commodity data information corresponding to the order, and accordingly determining occupied inventory data;
and calculating the difference value between the actual inventory data and the occupied inventory data to obtain virtual available inventory data.
Specifically, the actual inventory data is the inventory quantity contained in the inventory location, and is determined by an actual inventory manager, and the occupied inventory data is the inventory occupation generated in the modes of ordering, reserving, freezing and the like, and is determined by an order; although the actual inventory data and the occupied inventory data point to the same commodity, the actual inventory data is provided by the actual inventory management party, and the occupied inventory data is updated according to the order, so that the synchronous updating of the actual inventory data and the occupied inventory data is completely decoupled, the occupied inventory data can be subtracted from the actual inventory data under any condition, the virtual available inventory can be rapidly and accurately calculated, and the problem of data integration synchronization in a series of online and offline differentiated scenes is solved.
Specifically, the determining virtual available inventory data according to the inventory data information and the commodity data information further includes:
the inventory center collects online and offline actual inventory data through inventory data information, occupied inventory data is determined through commodity data information corresponding to online and offline order information, and difference value calculation is carried out on the actual inventory data and the occupied inventory data to obtain virtual available inventory data;
the inventory center provides a uniform standard interface, and the order management center of the online and offline full channel uses the interface to occupy the inventory through order contents;
wherein, the interface content includes: the method comprises the steps of stock area coding, commodity information, full-channel unified order number, stock occupation quantity, sales type, source channel, creation time and unique identification;
after the inventory is successfully occupied, the inventory center generates an inventory occupation identifier through the full-channel unified order number, the inventory location code and the commodity information in the interface content; the existence time of the inventory occupation identification can be configured according to the actual situation of a channel, if the existence time of the inventory occupation identification is set to be 240 hours, then after 240 hours, the inventory occupation identification is automatically cleared, and the inventory occupation is automatically removed;
and the actual inventory management party takes out the corresponding commodities according to the order contents and then notifies the inventory center of the commodity taking-out message, and the inventory center removes inventory occupation according to the commodity taking-out message, deducts and modifies the actual inventory quantity and updates occupied inventory data and actual inventory data. The inventory center tightly controls data accuracy using distributed pessimistic locks.
Further, the performing data synchronization distribution on the inventory data information, the commodity data information, and the virtual available inventory data includes:
providing basic inventory data service by using the inventory data information, the commodity data information and the virtual available inventory data; the inventory center provides efficient and accurate basic data query service according to the existing data;
providing a configurable aggregated service using the inventory data information, the commodity data information, and the virtual available inventory data;
and synchronizing configurable total information by utilizing the inventory data information, the commodity data information and the virtual available inventory data.
Further, the providing a basic inventory data service using the inventory data information, the commodity data information, and the virtual available inventory data includes:
the inventory center inquires virtual available inventory data or actual inventory data through inventory region codes and commodity information in the interface content;
integrating the inventory occupation and the actual inventory change into a unified inventory change message, and sending the unified inventory change message to a user in real time through a second message queue;
wherein the unified inventory change message content comprises: the system comprises stock ground codes, commodity information, a full-channel unified order number, a stock change value, a residual stock quantity, a service type, a change type, an update time, a serial number and a unique identifier, wherein the stock change value comprises a positive number and a negative number, and the service type comprises a sales type.
Further, the providing a configurable aggregated service by using the inventory data information, the commodity data information and the virtual available inventory data includes:
a user acquires the aggregation data by configuring required combination information and a calculation mode;
the combined information comprises inventory places, commodity information and inventory quantity, the calculation mode comprises no commodity, the same commodity is taken and summed, the maximum value is taken, the minimum value is taken and the average value is taken, and the calculation mode adopts a dynamic script technology and can be expanded in real time.
Specifically, the inventory places comprise inventory place types, inventory place areas, various inventory place extension information and a specified inventory place coding set, the inventory place types comprise stores or warehouses, each sub-type is included, the inventory management system supports the supply, the inventory place areas comprise provincial districts and latitude and longitude ranges, and the various inventory place extension information can be dynamically expanded; the commodity information comprises commodity types and a specified commodity code set, and the commodity types comprise specific commodity information, are supported and provided by a commodity management system and can be dynamically expanded; the inventory quantity includes actual inventory data or a range of intervals of available inventory data.
Further, the synchronizing configurable total information using the inventory data information, the commodity data information, and the virtual available inventory data includes:
a user configures combination information, a computing mode and synchronous time by a configurable configuration and computing mode of the aggregation service, wherein the synchronous time is determined in a cron expression mode, and a specific task is executed at a specified time;
after the configuration is completed, the inventory center generates a unique identifier, inquires inventory data information in a specified synchronization time in a combined information and calculation mode, generates a file named by the unique identifier, uploads the file to a third-party file management system, sends a message notification to a user, and the user receives the message and downloads the file through the unique identifier to acquire the inventory data information.
In the process that a user acquires real-time latest inventory data information, if high concurrent scenes such as second killing, promotion, cattle bill brushing and the like are met, the flow is increased rapidly, the load connection of a database is suddenly increased sharply, and stock competition can cause over-sale or system abnormity. The embodiment of the invention processes the high concurrency scene from the inventory data cache:
under the condition of huge flow, the pressure of the database is reduced by using the cache, and the data are ensured to be fast. When the database is initialized, the database data is ensured to be written into the cache according to the simplified format only comprising commodity and inventory data information, the cache information is updated firstly when the subsequent updating is carried out, and the database is updated synchronously through the message queue after the updating is successful. The cache and the database provide services through two independent applications respectively, different machines are deployed differently, data are synchronized in real time through a message queue in the middle, the data are synchronized integrally at preset time intervals, and complete separation and no coupling are achieved.
From the above description, it can be seen that the present invention achieves the following technical effects:
1. the system has the advantages that a perfect data acquisition and updating mechanism ensures real-time performance, stability and data accuracy of acquired data by acquiring inventory data information and updating current commodity data information according to a preset frequency, and can automatically recover in a short time even if abnormal conditions occur;
2. the stock data of the actual stock management side of various channels are integrated into a unified data model, the original data of various channels are saved, and meanwhile, unified processing and data management can be carried out;
3. in the virtual available inventory determination model, the actual inventory data is the inventory quantity contained in the inventory location, the actual inventory management party determines the actual inventory data, the occupied inventory data is the inventory occupied through the mode of ordering, reserving, freezing and the like, the order is determined, the synchronous updating of the actual inventory data and the occupied inventory data is completely decoupled, the virtual available inventory is rapidly and accurately calculated under any condition, and the problem of data integration synchronization in a series of online and offline differentiated scenes is solved;
4. the configurable aggregation service is provided, and the configuration can be performed in each dimension related to the inventory data, so that the configuration and the data acquisition can be performed no matter what data is needed by a demand side, and meanwhile, all configured dimensions and calculation modes can be transversely expanded, thereby greatly saving subsequent development and maintenance resources;
5. the method provides basic stock data service and configurable full-scale information synchronization, and ensures real-time accuracy and reliability of data and continuous available data which can be corrected after abnormal conditions for users needing to cache data from two aspects.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowcharts, in some cases, the steps illustrated or described may be performed in an order different than presented herein.
An embodiment of the present invention further provides an online-offline inventory synchronization device for implementing the online-offline inventory synchronization method, as shown in fig. 2, the device includes:
the acquisition unit 21 is used for integrating the respective online and offline inventory data into unified inventory data information and acquiring the inventory data information according to a preset frequency;
an updating unit 22, configured to receive the generated order, where the order includes change information of the commodity, and update current commodity data information based on the change information of the commodity;
a determining unit 23, configured to determine virtual available inventory data according to the inventory data information and the commodity data information;
and a data synchronous distribution unit 24, configured to perform data synchronous distribution on the inventory data information, the commodity data information, and the virtual available inventory data.
An embodiment of the present invention further provides an electronic device, as shown in fig. 3, the electronic device includes one or more processors 31 and a memory 32, where one processor is taken as an example in fig. 3.
The controller may further include: an input device 33 and an output device 34.
The processor 31, the memory 32, the input device 33 and the output device 34 may be connected by a bus or other means, and fig. 3 illustrates the connection by a bus as an example.
The processor 31 may be a Central Processing Unit (CPU). The processor 31 may also be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or combinations thereof. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 32, which is a non-transitory computer readable storage medium, may be used for storing non-transitory software programs, non-transitory computer executable programs, and modules, such as program instructions/modules corresponding to the control method in the embodiments of the present invention. The processor 31 executes various functional applications of the server and data processing by running non-transitory software programs, instructions and modules stored in the memory 32, namely, implements the online-to-offline inventory synchronization method of the above-described method embodiment.
The memory 32 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of a processing device operated by the server, and the like. Further, the memory 32 may include high speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory 32 may optionally include memory located remotely from the processor 31, which may be connected to a network connection device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 33 may receive input numeric or character information and generate key signal inputs related to user settings and function control of the processing device of the server. The output device 34 may include a display device such as a display screen.
One or more modules are stored in the memory 32, which when executed by the one or more processors 31 perform the method as shown in fig. 1.
Those skilled in the art will appreciate that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and the processes of the embodiments of the motor control methods described above can be included when the computer program is executed. The storage medium may be a magnetic disk, an optical disk, a Read-only memory (ROM), a Random Access Memory (RAM), a Flash Memory (FM), a hard disk (hard disk drive, HDD), a Solid State Drive (SSD), or the like; the storage medium may also comprise a combination of memories of the kind described above.
Although the embodiments of the present invention have been described in conjunction with the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the invention, and such modifications and variations fall within the scope defined by the appended claims.
Claims (10)
1. An online-to-offline inventory synchronization method, the method comprising:
integrating the respective online and offline inventory data into unified inventory data information, and acquiring the inventory data information according to a preset frequency;
receiving a generated order, wherein the order comprises change information of the commodity, and updating current commodity data information based on the change information of the commodity;
determining virtual available inventory data according to the inventory data information and the commodity data information;
and synchronously distributing the inventory data information, the commodity data information and the virtual available inventory data.
2. The method of claim 1,
the stock data integration that will be online each other off-line is unified stock data information, gathers stock data information according to preset frequency, includes:
the method comprises the following steps that an actual inventory management party generates a full inventory file according to inventory data of each online and offline inventory, content defined by an inventory center and a unified standard, the full inventory file is uploaded to a third-party file management system, the third-party file management system informs the inventory center through a first message queue, and the inventory center acquires, reads and processes inventory data information in the full inventory file;
wherein the full inventory file content line comprises: the stock ground code, the commodity information, the stock quantity, the updating time and the version number; the first message queue contents include: file name, file md5 value, file storage address, source channel and creation time;
and the actual inventory management party provides a call-back interface, and when the inventory center acquires, reads and processes the inventory data information in the full inventory file, if abnormal conditions occur to cause that the inventory data information cannot be repaired by self to ensure the correctness, the call-back interface informs the actual inventory management party to regenerate and synchronize the full inventory file.
3. The method of claim 1,
the receiving the generated order, wherein the order includes change information of the commodity, and updating current commodity data information based on the change information of the commodity includes:
receiving the generated order and the inventory change, sending an inventory change message or directly calling an interface to inform an inventory center by an actual inventory manager according to a unified standard, and receiving the inventory change message and processing data by the inventory center; wherein the inventory change message content includes: the system comprises a stock place code, commodity information, a unique flow code of a stock management party, a full-channel unified order number, a stock change value, a type, update time, a serial number and a unique identifier;
the inventory center initializes or corrects all inventory data corresponding to a source channel in the content of the first message queue through the full inventory file, generates at least one piece of data through the version number in the content row of the full inventory file, each piece of data corresponds to one version number, sets the current version number to take effect after the initialization or correction is completed, and provides data service for the outside by using the data associated with the effective version number.
4. The method of claim 1,
the receiving the generated order, wherein the order includes change information of the commodity, and updating current commodity data information based on the change information of the commodity, further includes:
meanwhile, the inventory center updates the inventory information of the commodities through the inventory change message; filtering repeated request data generated by abnormality through the unique identifier in the contents of the inventory change message, and ensuring the sequence of the inventory change message through the sequence number in the contents of the inventory change message;
when the inventory center acquires the full inventory file and the inventory change message, the corresponding inventory code and the corresponding commodity code are marked through the content line of the full inventory file and the update time in the content of the inventory change message, whether the inventory change is ordered in time or not is judged in each update, and if the judgment sequence is wrong and data abnormity can be caused, call back is carried out, and inventory of the commodities is checked again.
5. The method of claim 1,
the determining virtual available inventory data according to the inventory data information and the commodity data information includes:
determining actual inventory data according to the inventory data information;
determining occupied inventory data according to the commodity data information corresponding to the order;
and calculating the difference value between the actual inventory data and the occupied inventory data to obtain virtual available inventory data.
6. The method of claim 1,
the determining virtual available inventory data according to the inventory data information and the commodity data information further comprises:
the inventory center collects online and offline actual inventory data through inventory data information, occupied inventory data is determined through commodity data information corresponding to online and offline order information, and difference value calculation is carried out on the actual inventory data and the occupied inventory data to obtain virtual available inventory data;
the inventory center provides a uniform standard interface, and the order management center of the online and offline full channel uses the interface to occupy the inventory through order contents;
wherein, the interface content includes: the method comprises the steps of stock area coding, commodity information, full-channel unified order number, stock occupation quantity, sales type, source channel, creation time and unique identification;
after the inventory is successfully occupied, the inventory center generates an inventory occupation identifier through the full-channel unified order number, the inventory location code and the commodity information in the interface content;
and the actual inventory management party takes out the corresponding commodities according to the order contents and then notifies the inventory center of the commodity taking-out message, and the inventory center removes inventory occupation according to the commodity taking-out message, deducts and modifies the actual inventory quantity and updates occupied inventory data and actual inventory data.
7. The method of claim 1,
the data synchronization distribution of the inventory data information, the commodity data information and the virtual available inventory data includes:
providing basic inventory data service by using the inventory data information, the commodity data information and the virtual available inventory data;
providing a configurable aggregated service using the inventory data information, the commodity data information, and the virtual available inventory data;
and synchronizing configurable total information by utilizing the inventory data information, the commodity data information and the virtual available inventory data.
8. The method of claim 7,
the providing of the basic inventory data service using the inventory data information, the commodity data information, and the virtual available inventory data includes:
the inventory center inquires virtual available inventory data or actual inventory data through inventory region codes and commodity information in the interface content;
integrating the inventory occupation and the actual inventory change into a unified inventory change message, and sending the unified inventory change message to a user in real time through a second message queue;
wherein the unified inventory change message content comprises: the system comprises stock area codes, commodity information, a full-channel unified order number, a stock change value, a residual stock quantity, a service type, a change type, update time, a serial number and a unique identifier.
9. The method of claim 7,
the providing of the configurable aggregated service by using the inventory data information, the commodity data information and the virtual available inventory data comprises:
a user acquires the aggregation data by configuring required combination information and a calculation mode;
wherein the combined information comprises a stock place, commodity information and stock quantity; the calculation mode comprises the steps of taking the sum, taking the maximum value, taking the minimum value and taking the average number of the same commodity.
10. The method of claim 7,
the synchronizing configurable total information using the inventory data information, the commodity data information, and the virtual available inventory data includes:
a user configures combination information, a computing mode and synchronization time through a configuration and computing mode of the configurable aggregation service;
after the configuration is completed, the inventory center generates a unique identifier, inquires inventory data information in a specified synchronization time in a combined information and calculation mode, generates a file named by the unique identifier, uploads the file to a third-party file management system, sends a message notification to a user, and the user receives the message and downloads the file through the unique identifier to acquire the inventory data information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010892631.4A CN111967830A (en) | 2020-08-28 | 2020-08-28 | Online and offline inventory synchronization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010892631.4A CN111967830A (en) | 2020-08-28 | 2020-08-28 | Online and offline inventory synchronization method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111967830A true CN111967830A (en) | 2020-11-20 |
Family
ID=73400754
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010892631.4A Pending CN111967830A (en) | 2020-08-28 | 2020-08-28 | Online and offline inventory synchronization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111967830A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112465607A (en) * | 2020-12-28 | 2021-03-09 | 憨妈妈网络科技(苏州)有限公司 | Mother and infant product dual-operation retail system |
| CN115357766A (en) * | 2022-10-17 | 2022-11-18 | 深圳美云集网络科技有限责任公司 | Data matching method and related device |
| CN117056432A (en) * | 2023-10-11 | 2023-11-14 | 广州市星康科技有限公司 | Method and system for synchronizing data between off-line and on-line commodity retail systems |
-
2020
- 2020-08-28 CN CN202010892631.4A patent/CN111967830A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112465607A (en) * | 2020-12-28 | 2021-03-09 | 憨妈妈网络科技(苏州)有限公司 | Mother and infant product dual-operation retail system |
| CN115357766A (en) * | 2022-10-17 | 2022-11-18 | 深圳美云集网络科技有限责任公司 | Data matching method and related device |
| CN115357766B (en) * | 2022-10-17 | 2023-01-24 | 深圳美云集网络科技有限责任公司 | Data matching method and related device |
| CN117056432A (en) * | 2023-10-11 | 2023-11-14 | 广州市星康科技有限公司 | Method and system for synchronizing data between off-line and on-line commodity retail systems |
| CN117056432B (en) * | 2023-10-11 | 2023-12-12 | 广州市星康科技有限公司 | Method and system for synchronizing data between off-line and on-line commodity retail systems |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111967830A (en) | Online and offline inventory synchronization method | |
| CN111339073A (en) | Real-time data processing method and device, electronic equipment and readable storage medium | |
| CN111459986B (en) | Data computing system and method | |
| CN111222089B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN109636304B (en) | Business system publishing method and device, storage medium and electronic device | |
| CN110334072A (en) | A kind of distributed file system, file updating method and device | |
| CN114048217A (en) | Incremental data synchronization method and device, electronic equipment and storage medium | |
| CN111784329A (en) | Service data processing method and device, storage medium and electronic device | |
| CN111143465A (en) | Method and device for realizing data center station and electronic equipment | |
| CN111200517B (en) | Service data early warning control method, device, equipment and storage medium | |
| CN112686418A (en) | Method and device for predicting performance timeliness | |
| CN110928681A (en) | Data processing method and device, storage medium and electronic device | |
| CN114416891B (en) | Method, system, apparatus and medium for data processing in a knowledge graph | |
| CN115827646A (en) | Index configuration method and device and electronic equipment | |
| CN113360689B (en) | Image retrieval system, method, related device and computer program product | |
| CN112860292A (en) | Configuration management method and device based on application | |
| CN111506646A (en) | Data synchronization method, device, system, storage medium and processor | |
| CN112231152A (en) | Data synchronization method, remote server, client and system | |
| CN114201501A (en) | Message processing method and device, electronic equipment and storage medium | |
| CN115460077B (en) | Configuration information updating method and device, storage medium and electronic device | |
| CN109005059A (en) | A kind of system and method for realizing Redis automated back-up | |
| US11366735B2 (en) | Dynamic data storage management | |
| CN112702376B (en) | Real-time transaction monitoring method | |
| CN117667425A (en) | Configuration optimization method and system for heterogeneous cloud resources | |
| CN114793194A (en) | Service data processing method and device and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |