Offline and online operation fused inventory processing system and method

Abstract

The invention discloses an inventory processing system and method fusing offline and online operation, and the system comprises the steps: an offline end carries out the warehouse-out operation and stores the warehouse-out information under the condition of no network or weak network, transmits the warehouse-out information to a database end when the network exists, and downloads and updates the inventory information from the database end; the online end carries out warehouse-out operation when the online end has a network, synchronously transmits warehouse-out information to the database end, and synchronously downloads updated inventory information from the database end; and the database end gathers and processes all warehouse-in and warehouse-out information, updates the inventory information, and transmits the latest inventory information to the offline end and the online end. According to the technical scheme provided by the invention, the warehouse-out information is collected, and the inventory information is sorted and cancelled after verification by using the timing module, so that the warehouse-out processing problem of multi-source data at an offline end and an online end is solved, the corresponding warehouse-in order information is tracked for each warehouse-out order and is cancelled after verification, and the efficiency of warehouse-out processing is improved. And the accuracy of inventory data and inventory cost statistics is ensured.

Description

Technical Field

[0001] The present invention relates to the technical field of inventory processing, and in particular to an inventory processing system and method integrating offline and online operations. Background Art

[0002] In ocean-going ships, due to reasons such as network blind spots or high costs, a lot of business data at the ship end cannot be transmitted to the shipping company at the shore base in real time, resulting in the shipping company at the shore base being unable to understand the situation of the ship in real time, and the ship end cannot complete various business data operations on the software in a timely manner, making management difficult.

[0003] At present, some shipping companies have developed a ship offline-end processing system, which can realize many offline operations of the ship without network, and then compress and transmit information when there is a network. However, this system can only solve some tasks that do not conflict with other data, such as submitting procurement applications, task completion reports, etc., and only need to report demand data and completion reports to the shipping company at the shore base for review, approval and procurement processing. For some tasks that conflict with other online data and data processing with a high degree of time correlation, such as inventory data and inbound and outbound management, the existing ship offline-end processing system cannot solve them well.

[0004] In the prior art, the following problems exist in the inventory data processing of the offline end: (1) If the latest inventory information is not synchronized in time at the offline end, some errors will occur when performing inbound and outbound operations offline or online. For example, if the inventory data of an item at the offline end is 0 while the actual inventory of the item is not 0, the offline end cannot handle the outbound operation of the item.

[0005] (2) After the offline end processes the inbound and outbound operations, there is a time difference in data synchronization, resulting in inaccurate inventory data in the database, mismatching of batches of outbound and inbound items, statistical chaos, and it is difficult to effectively promote the inventory management of the ship and difficult to exert its value. For example: How to process the outbound information of the same item transmitted from different software ends such as the offline end and the online end at different times in the database center? How to correspond to the previous procurement cost? Summary of the Invention

[0006] In view of the above deficiencies in the current technology, the present invention provides an inventory processing system integrating offline and online operations. By collecting outbound information within a certain time range (within the preset closing time point or allowed by the closing rule), and using a timing module to sort and verify the inventory information, the problem of outbound processing of multi-source data at the offline end and the online end is solved. The system tracks the corresponding inbound order information for each outbound order and performs verification processing, ensuring the accuracy of inventory data, inventory cost, and outbound consumption cost statistics.

[0007] To achieve the above object, the embodiments of the present invention adopt the following technical solutions: An inventory processing system integrating offline and online operations, comprising: An offline terminal, configured to perform outbound operations and store outbound information under offline or weak network conditions, transmit the outbound information to the database terminal when the network condition is good, and download and update the inventory information from the database terminal; An online terminal, configured to perform outbound operations when the network condition is good, synchronously transmit the outbound information to the database terminal, and synchronously download and update the inventory information from the database terminal; A database terminal, configured to summarize and process all inbound and outbound information, update the inventory information, and transmit the latest inventory information to the offline terminal and the online terminal; Wherein, the database terminal includes: A data processing module, configured to process the outbound information transmitted from different sources and at different times by the offline terminal and the online terminal, and transmit the latest inventory information to the offline terminal and the online terminal; An inventory management summary module, configured to summarize and process all inbound and outbound information, and update the inventory information; Wherein, the data processing module includes: A timing module, configured to sort the outbound information and inbound information of the items involved in the outbound information according to the inbound and outbound times; An inventory cancellation module, configured to set a closing time point for the online terminal and the offline terminal, check and cancel the outbound information and the inbound information one by one, and ensure that each outbound quantity has a corresponding inbound information; A cache module, configured to cache abnormal data for users to process the abnormal data separately.

[0008] According to one aspect of the present invention, the outbound information, the inbound and outbound information, and the inventory information include: item code, item name.

[0009] According to one aspect of the present invention, the offline terminal includes: An offline inventory management module, configured to store and manage the inventory information and the outbound information; An offline outbound management module, configured to query and reference the inventory information in the offline inventory management module, create an outbound order, and transmit the outbound information to the offline inventory management module; A data transmission management module, configured to perform data transmission with the database terminal when the network condition is good.

[0010] According to one aspect of the present invention, the data transmission between the data transmission management module and the database terminal includes a manual mode and an automatic mode.

[0011] According to one aspect of the present invention, the online terminal includes: An online inventory management module for storing and managing inventory information and outbound information; An online outbound management module for querying and referencing the inventory information in the online inventory management module, creating an outbound order, and transmitting the outbound information to the online inventory management module; A data transmission management module for data transmission with the database side.

[0012] According to one aspect of the present invention, the processing flow of the inventory processing system for item inventory information is as follows: The database side transmits the latest inventory information of the inventory management summary module to the data processing module, and after adding the time stamp given by the timing module in the data processing module, it is transmitted to the offline side and the online side; The offline side receives the inventory information through the data transmission management module and updates the inventory information in the offline inventory management module; The user operates to issue goods in the offline outbound management module, and the offline outbound management module creates an outbound order from the latest inventory information in the offline inventory management module; The offline inventory management module collects the outbound information, and after updating the inventory, transmits the outbound information to the database side through the data transmission management module of the offline side; The data processing module of the database side receives the outbound information transmitted from the offline side and the online side, processes the outbound information, and then updates it to the inventory management summary module.

[0013] According to one aspect of the present invention, the processing flow of the inventory processing system for item inventory information is as follows: The database side transmits the latest inventory information of the inventory management summary module to the data processing module, and after adding the time stamp given by the timing module in the data processing module, it is transmitted to the offline side and the online side; The online side receives the inventory information through the data transmission management module and updates the inventory information in the online inventory management module; The user operates to issue goods in the online outbound management module, and the online outbound management module retrieves the latest inventory information from the online inventory management module to create an outbound order; The online inventory management module collects the outbound information, and after updating the inventory, transmits the outbound information to the database side through the data transmission management module of the online side; The data processing module of the database side receives the outbound information transmitted from the offline side and the online side, processes the outbound information, and then updates it to the inventory management summary module.

[0014] According to one aspect of the present invention, the inventory management summary module further includes: Storing information of inventory items, including item images and item feature encodings obtained based on a pre-trained feature extraction network.

[0015] According to one aspect of the present invention, the inventory processing system integrating offline and online operations further includes: A purchase-in warehousing module, configured to perform warehousing operations on the purchased items and transmit the warehousing information to the database side; An allocation-in warehousing module, configured to perform warehousing operations on the allocated items and transmit the warehousing information to the database side.

[0016] An inventory processing method integrating offline and online operations, based on the inventory processing system integrating offline and online operations as described above, includes: Constructing an offline end, an online end, and a database end for inventory processing; The offline end performs outbound operations and stores the outbound information under offline or weak network conditions, transmits the outbound information to the database side when the network condition is good, and downloads and updates the inventory information from the database side; The online end performs outbound operations when the network condition is good, synchronously transmits the outbound information to the database side, and synchronously downloads and updates the inventory information from the database side; The database side summarizes and processes all inbound and outbound information, updates the inventory information, and transmits the latest inventory information to the offline end and the online end.

[0017] Advantages of the implementation of the present invention: The present invention provides an inventory processing system integrating offline and online operations. By collecting the outbound information within a certain time range (within the preset closing time point or allowed by the closing rule), using the timing module to sort and verify the inventory information, it solves the problem of outbound processing of multi-source data at the offline end and the online end. The system tracks the corresponding inbound order information for each outbound order and performs verification processing, ensuring the accuracy of inventory data, inventory cost, and outbound consumption cost statistics. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the drawings required for use in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.

[0019] Figure 1 It is a structure diagram of an inventory processing system integrating offline and online operations according to the present invention; Figure 2 It is a verification flowchart of the timing module, inventory elimination module, cache module, and inventory management summary module for the outbound information according to the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0020] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0021] Embodiment 1

[0022] As Figure 1 shown, an inventory processing system integrating offline and online operations includes: an offline end, an online end, a database end, and other modules.

[0023] Offline end: used to perform outbound operations and store outbound information under no-network or weak-network conditions, transfer the outbound information to the database end when the network condition is good, and download and update the inventory information from the database end.

[0024] The offline end includes: an offline inventory management module, an offline outbound management module, and a data transmission management module.

[0025] Offline inventory management module: used to store and manage inventory information and outbound information.

[0026] Offline outbound management module: used to query and reference the inventory information in the offline inventory management module, create an outbound order, and transfer the outbound information to the offline inventory management module.

[0027] Data transmission management module: used to perform data transmission with the database end when the network condition is good, transfer the outbound information of the offline end to the database end, and synchronously download the latest inventory information of the database end to the offline end.

[0028] The data transmission between the data transmission management module and the database end includes a manual mode and an automatic mode: The manual mode is that the corresponding upload and download operations will only be performed after the user clicks the operation.

[0029] The automatic mode can be that the user sets a certain time point. When this time point is reached, if the host is connected to the network and the offline end is in the open state, the offline end automatically performs upload and download operations. The automatic mode can also be to set regular network detection. When the network status is detected to be good and stable, the offline end automatically performs upload and download operations.

[0030] Online end: used to perform outbound operations when the network condition is good, synchronously transmit the outbound information to the database end, and synchronously download and update the inventory information from the database end.

[0031] The online end includes: an online inventory management module, an online outbound management module, and a data transmission management module.

[0032] Inventory management online module: used to store and manage inventory information and outbound information.

[0033] Outbound management online module: used to query and reference the inventory information in the inventory management online module, create an outbound order, and transfer the outbound information to the inventory management online module.

[0034] Data transmission management module: used to perform data transmission with the database side, transfer the outbound information at the online side to the database side, and synchronously download the latest inventory information from the database side to the online side. The data transmission management module at the online side only has an automatic transmission mode.

[0035] The outbound information transmitted by the offline side and the online side to the database side includes: item code (unique code), item name, item model, item code, item description, unit, outbound quantity, outbound date, operator, transmission time, data source (offline side / online side), etc.

[0036] Database side: used to summarize and process all inbound and outbound information, update the inventory information, and transmit the latest inventory information to the offline side and the online side.

[0037] The said database side includes: a data processing module and an inventory management summary module.

[0038] Data processing module: used to process the outbound information transmitted from different sources and at different times by the offline side and the online side, and transmit the latest inventory information to the offline side and the online side.

[0039] The said data processing module includes: a timing module, a stock elimination module, and a cache module.

[0040] Figure 2 As shown, it is the verification process of the outbound information by the timing module, the stock elimination module, the cache module, and the inventory management summary module.

[0041] Timing module: used to sort the outbound information and inbound information of the items involved in the outbound information according to the inbound and outbound times.

[0042] The timing module sequentially identifies each piece of outbound information received from the offline side and the online side in the order of "outbound date", and this identification information is composed of "outbound date + transmission time + data source". Although the offline side may have transmitted a lot of outbound information with a delay, when the outbound information from the offline side and the online side is collected in the timing module, they will be sorted again according to the outbound date.

[0043] The timing module sorts out the latest inventory information of the inventory management summary module, screens the items involved in the outbound information in the inventory information, selects the latest inventory information of these items and the inbound information for each quantity, and sorts them according to the inbound time.

[0044] The timing module collects and sorts the item inbound information and item outbound information according to the inbound time and outbound time, attaches a time label, and passes it to the inventory clearing module. For the items not found in the inventory, they enter the cache module for processing.

[0045] Inventory clearing module: It is used to set the closing time point for the online and offline terminals, check and cancel the outbound information and inbound information one by one, ensure that each outbound quantity has a corresponding inbound information, that is, determine the inbound price and manufacturer corresponding to each outbound quantity (for convenient cost statistics and quality traceability), and update the final inventory change result.

[0046] The inventory clearing module takes the timing sorting start point and end point as the start point and end point of inventory clearing, and sequentially cancels the inbound and outbound information during this period.

[0047] Specifically, the inventory clearing module collects the documents and sorts them according to time, and then processes the documents: After the documents sorted according to the item inbound and outbound time enter the inventory clearing module, each item is screened and merged based on the unique material code. There will be several data: (timing sorting start point) initial inventory, (between the start point and the end point) inbound order, (between the start point and the end point) outbound order. The system will cancel these inbound and outbound documents according to the first-in, first-out rule, and finally generate the (timing sorting end point) end inventory. These inbound and outbound documents and end inventory information will be updated to the inventory management summary module. Due to the configuration of the time margin, during this timing stage from the timing sorting start point to the end point, it may also receive documents passed from the next timing stage. At that time, the inbound and outbound information of this item will be re-canceled and the inventory will be updated again, and then passed to the inventory management summary module.

[0048] Cache module: It is used to cache abnormal data for users to process the abnormal data separately. When the timing module and the inventory clearing module are processing, there will be some abnormal data, such as the mismatch between the outbound and inbound items, which need to be processed manually by the user. The cache module stores the abnormal data processed by the timing module and the inventory clearing module for users to process the abnormal data separately.

[0049] The cache module collects exception documents and then processes them. For example, since the item codes generated based on rules at the offline end are inconsistent with those generated based on rules at the database end, it is impossible to perform the verification action for inbound and outbound in the inventory write-off module. Therefore, in the cache module, the user needs to manually check the matching. The system can quickly filter the newly added item information in the recent period (after the timing sorting start time) to facilitate the user's checking. After the matching is completed, the item and the outbound document re-enter the inventory write-off module, and the inventory write-off action is performed again for the documents of the item during the start and end periods.

[0050] Inventory management summary module: used to summarize and process all inbound and outbound information and update the inventory information.

[0051] The inventory information passed from the database end to the offline end and the online end includes: item code (unique code), item name, item model, item code, item description, unit, total inventory quantity (there is more detailed information below the total inventory quantity, including: the inbound time corresponding to each quantity in the inventory, the inbound operator, the supplier, the inbound price), etc.

[0052] Preferably, other modules may include: purchase inbound module, transfer inbound module, etc.

[0053] Purchase inbound module: used to perform the inbound operation on the purchased items and transmit the inbound information to the database end.

[0054] Transfer inbound module: used to perform the inbound operation on the transferred items and transmit the inbound information to the database end.

[0055] The processing flow of the item inventory information in the system is as follows: S1: Other modules (such as the purchase module, transfer inbound module, etc.) provide the inbound information to the inventory management summary module at the database end. The inventory management summary module at the database end establishes the latest inventory information for each item. If there is no item information for the inbound item in the inventory, a new item information is added and the inbound information is updated, and the item code (unique code) of the item is generated according to the rules synchronously.

[0056] S2: The database end passes the latest inventory information of the inventory management summary module to the data processing module, and after adding the time stamp given by the timing module in the data processing module, it is passed to the offline end and the online end. Since the success of the data transmission of the offline end software depends on the network situation and the request time of the offline end, after the transmission is successful, this synchronization time is used as the time stamp of this inventory information synchronization record.

[0057] S3: There are different processing methods for the offline end and the online end in this step: a. Offline end S3.1a: The offline end receives the inventory information through the data transmission management module and updates the inventory information in the offline inventory management module.

[0058] S3.2a: The user operates the outbound management in the offline outbound management module. The offline outbound management module retrieves the latest inventory information of these items from the offline inventory management module so that the user can select which items to outbound. The outbound information of the selected items will form an outbound order, and the inventory information in the offline inventory management module will be updated. If there is no outbound item information in the inventory information, the user will perform the outbound operation of adding new items.

[0059] S3.3a: Separate processing of outbound orders: Due to the lag of the inventory information in the offline inventory management module compared to the inventory information on the database side, some newly purchased items or updated quantities of original items in the database side have not been synchronized to the offline end. Combining with the outbound operation, three types of documents and corresponding operations will be generated: (1) Outbound order for items with item codes and sufficient inventory. Example: There are 5 inventories of a certain item, and 3 are outbound this time. An outbound order is formed and the inventory is updated.

[0060] (2) Outbound order for items with item codes but insufficient inventory. Example: There are 0 inventories of a certain item, and 3 are outbound this time. An outbound order is formed and the inventory is updated (allowing negative inventory values).

[0061] (3) Outbound order for items without item codes. Example: There is no information about this item in the software, but 3 are outbound this time. New items and temporary item numbers are added, and an outbound order is formed.

[0062] S3.4a: After the offline inventory management module collects the outbound information and updates the inventory, it transmits the outbound information to the database side through the data transmission management module of the offline end in manual or automatic mode.

[0063] Note: The inventory information on the offline end is only for reference when making outbound operations on the offline end and does not need to be transmitted to the database side. When the data transmission management module on the offline end is started, the offline end transmits the outbound information and synchronously downloads the latest inventory information.

[0064] b. Online end S3.1b: The online end receives the inventory information through the data transmission management module and updates the inventory information in the online inventory management module.

[0065] s3.2b: When the user operates the outbound in the online outbound management module, the online outbound management module will retrieve the latest inventory information of these items from the online inventory management module so that the user can select which items to outbound. The outbound information of the selected items will form an outbound order, and the inventory information in the online inventory management module will be updated. If there is no outbound item information in the inventory information, the user will perform the outbound operation for adding new items.

[0066] s3.3b: Separate processing of outbound orders: Due to the untimely inbound operation, the updated quantities of some newly purchased or original items that have been actually purchased and inbound have not been updated to the database side, and consequently, the actual latest inventory information has not been synchronized on the online side. Combining with the outbound operation, three types of documents and corresponding operations may also be generated (logically processed in the same way as the offline side): (1) Outbound order for items with item codes and sufficient inventory. Example: An item has 5 inventories, and 3 are outbound this time. An outbound order is formed, and the inventory is updated.

[0067] (2) Outbound order for items with item codes but insufficient inventory. Example: An item has 0 inventories, and 3 are outbound this time. An outbound order is formed, and the inventory is updated (negative inventory values are allowed).

[0068] (3) Outbound order for items without item codes. Example: There is no information about this item in the software, but 3 are outbound this time. New items and temporary item numbers are added, and an outbound order is formed.

[0069] s3.4b: After the online inventory management module collects the outbound information and updates the inventory, it automatically transmits the outbound information to the database side through the data transmission management module.

[0070] Note: The inventory information on the online side can be only used as a reference when making outbound operations on the online side and does not need to be transmitted to the database side. The data transmission management module on the online side transmits the outbound information to the database side and synchronously downloads the latest inventory information as well.

[0071] S4: The data processing module on the database side receives the outbound information transmitted from the offline side and the online side, processes this outbound information (the processing process is shown in Figure 2 ), and then updates it to the inventory management summary module. The inventory management summary module will form the latest inventory information and store all approved inbound records and outbound records. The database then loops according to the steps in s1 in combination with the inbound information.

[0072] The beneficial effects of this embodiment are as follows: By collecting the outbound information within a certain time range (preset closing time point or allowed by the closing rules), and using the timing module to sort and verify the inventory information, this method solves the problem of outbound processing of multi-source data at the offline and online ends. The system tracks the corresponding inbound order information for each outbound order and performs verification processing, ensuring the accuracy of the statistics of inventory data, inventory costs, and outbound consumption costs.

[0073] Embodiment Two

[0074] As Figure 1 shown, an inventory processing system integrating offline and online operations includes: an offline end, an online end, a database end, and other modules.

[0075] Offline end: Used to perform outbound operations and store outbound information under offline or weak network conditions, transfer the outbound information to the database end when the network condition is good, and download and update the inventory information from the database end.

[0076] The offline end includes: an offline inventory management module, an offline outbound management module, and a data transmission management module.

[0077] Offline inventory management module: Used to store and manage inventory information and outbound information.

[0078] Offline outbound management module: Used to query and reference the inventory information in the offline inventory management module, create an outbound order, and transfer the outbound information to the offline inventory management module.

[0079] Data transmission management module: Used to perform data transmission with the database end when the network condition is good, transfer the outbound information of the offline end to the database end, and synchronously download the latest inventory information of the database end to the offline end.

[0080] The data transmission between the data transmission management module and the database end includes a manual mode and an automatic mode: The manual mode is that the corresponding upload and download operations will only be performed after the user clicks the operation.

[0081] The automatic mode can be that the user sets a certain time point. When this time point is reached, if the host is connected to the network and the offline end is in an open state, the offline end automatically performs upload and download operations. The automatic mode can also be set to perform network detection regularly. When the network status is detected to be good and stable, the offline end automatically performs upload and download operations.

[0082] Online end: Used to perform outbound operations when the network condition is good, synchronously transmit the outbound information to the database end, and synchronously download and update the inventory information from the database end.

[0083] The online terminal includes: an online inventory management module, an online outbound management module, and a data transmission management module.

[0084] Online inventory management module: Used to store and manage inventory information and outbound information.

[0085] Online outbound management module: Used to query and reference the inventory information in the online inventory management module, create an outbound order, and transfer the outbound information to the online inventory management module.

[0086] Data transmission management module: Used to perform data transmission with the database terminal, transfer the outbound information of the online terminal to the database terminal, and synchronously download the latest inventory information of the database terminal to the online terminal. The data transmission management module of the online terminal only has an automatic transmission mode.

[0087] The outbound information transmitted by the offline terminal and the online terminal to the database terminal includes: item code (unique code), item name, item model, item code, item description, unit, outbound quantity, outbound date, operator, transmission time, data source (offline terminal / online terminal), etc.

[0088] Database terminal: Used to summarize and process all inbound and outbound information, update inventory information, and transmit the latest inventory information to the offline terminal and the online terminal.

[0089] The database terminal includes: a data processing module and an inventory management summary module.

[0090] Data processing module: Used to process the outbound information transmitted from different sources and at different times by the offline terminal and the online terminal, and transmit the latest inventory information to the offline terminal and the online terminal.

[0091] The data processing module includes: a timing module, a stock elimination module, and a cache module.

[0092] Figure 2 As shown, it is the verification process of the outbound information by the timing module, the stock elimination module, the cache module, and the inventory management summary module.

[0093] Timing module: Used to sort the outbound information and inbound information of the items involved in the outbound information according to the inbound and outbound times.

[0094] The timing module sequentially identifies each piece of outbound information received from the offline terminal and the online terminal in the order of the "outbound date". This identification information is composed of "outbound date + transmission time + data source". Although the offline terminal may have transmitted a lot of outbound information with a delay, when it is aggregated in the timing module, the outbound information of the offline terminal and the online terminal will be sorted again according to the outbound date.

[0095] The timing module sorts out the latest inventory information of the inventory management summary module, screens the items involved in the outbound information in the inventory information, selects the latest inventory information of these items and the corresponding incoming information of each quantity, and sorts them according to the incoming time.

[0096] The timing module collects and sorts the information of item entry and exit according to the entry and exit time, attaches a time mark, and passes it to the elimination module. For items not found in the inventory, they enter the cache module for processing.

[0097] Inventory elimination module: used to set closing time points for the online and offline ends, check and write off the outbound and inbound information one by one, and make sure that each outbound quantity has corresponding inbound information, that is, determine the inbound price and manufacturer corresponding to each outbound quantity (to facilitate cost statistics and quality traceability), and update the final inventory change results.

[0098] The warehouse elimination module uses the starting and ending points of the timing sorting as the starting and ending points of warehouse elimination, and writes off the in-and-out warehouse information during this period in sequence.

[0099] Specifically, the warehouse elimination module collects documents and sorts them by time, and then processes the documents: after the documents sorted by the time of entry and exit of the items enter the warehouse elimination module, each item will be screened and merged based on the unique code of the material code, and there will be several data: (the starting point of the timing sorting) initial inventory, (between the starting point and the end point) entry order, (between the starting point and the end point) exit order. The system will write off these entry and exit documents according to the first-in-first-out rule, and finally generate the end point inventory (the end point of the timing sorting). These entry and exit documents and the end point inventory information will be updated to the inventory management summary module. Because of the configuration of the time margin, the timing stage from the starting point to the end point of the timing sorting may also receive documents passed from the next timing stage, and then the entry and exit information of the item will be re-written off and the inventory will be updated, and then passed to the inventory management summary module.

[0100] Cache module: used to cache abnormal data so that users can process the abnormal data separately. When the timing module and the warehouse elimination module process, there will be some abnormal data, such as mismatch between outbound and inbound items, which requires manual processing by users. The cache module stores the abnormal data processed by the timing module and the warehouse elimination module so that users can process the abnormal data separately.

[0101] The cache module collects exception documents and then processes them. For example, since the item codes generated based on rules at the offline end are inconsistent with those generated based on rules at the database end, the verification action for inbound and outbound operations cannot be performed in the inventory cancellation module. Therefore, in the cache module, the user needs to manually check and match. The system can quickly filter the newly added item information in the recent period (after the starting time of the timing sort) to facilitate the user's check and match. After the matching is completed, the item and the outbound document re-enter the inventory cancellation module, and the inventory cancellation action is re-performed for the documents of the item during the starting and ending periods.

[0102] Inventory management summary module: used to summarize and process all inbound and outbound information and update inventory information.

[0103] The inventory management summary module further includes: Store the information of inventory items, including item images and item feature codes obtained based on a pre-trained feature extraction network.

[0104] In practical applications, when conducting inventory management, it is difficult to determine the corresponding item solely relying on the text description of the item, or for the same item during recording, due to unfamiliarity, different names may appear. In this way, there may be duplicate inventory records in the database, resulting in inaccurate inventory records and affecting the accuracy and efficiency of inbound and outbound operations. Therefore, when recording the inventory information of items, the item images can be stored simultaneously to facilitate users to view and check.

[0105] At the same time, when an item is put into storage, in order to facilitate the user to quickly find the corresponding inventory record, the feature code of the item can be saved. The item being put into storage is used to obtain its feature code through the feature extraction network, and the similarity is calculated with the feature codes of the existing items in the database. According to the sorting of the similarity, the closest item is found. At the same time, in order to improve the search efficiency, the item category, keywords, etc. can be restricted to reduce the number of items to be compared, reduce the calculation amount, and improve the processing efficiency.

[0106] Specifically, the feature extraction network can be constructed based on deep learning models such as convolutional neural networks, perform convolutional operations and feature extraction on the item images, and finally obtain the feature vector as the feature code. The existing item pictures can be used for pre-training to obtain a trained feature extraction network. During application, the trained feature extraction network can be directly called for processing and calculation to improve the real-time processing efficiency.

[0107] The inventory information passed from the database end to the offline end and the online end includes: item code (unique code), item name, item model, item code, item description, unit, total inventory quantity (there is more detailed information below the total inventory quantity, including: the inbound time, inbound operator, supplier, and inbound price corresponding to each quantity in the inventory), etc.

[0108] Preferably, other modules may include: a purchase receipt module, a transfer receipt module, etc.

[0109] Purchase receipt module: used to perform receipt operations on the purchased items and transmit the receipt information to the database side.

[0110] Transfer receipt module: used to perform receipt operations on the transferred items and transmit the receipt information to the database side.

[0111] The beneficial effect of this embodiment is that: this method also saves the item images and item feature codes in the database, which is convenient for comparing and searching for items.

[0112] Embodiment Three

[0113] An inventory processing method integrating offline and online operations, based on the inventory processing system integrating offline and online operations as described in Embodiment One or Two, includes: Constructing an offline end, an online end, and a database end for inventory processing; The offline end performs outbound operations and stores the outbound information under offline or weak network conditions, transmits the outbound information to the database end when the network condition is good, and downloads and updates the inventory information from the database end; The online end performs outbound operations when the network condition is good, synchronously transmits the outbound information to the database end, and synchronously downloads and updates the inventory information from the database end; The database end summarizes and processes all inbound and outbound information, updates the inventory information, and transmits the latest inventory information to the offline end and the online end.

[0114] Preferably, this method further includes: Constructing a purchase receipt module and a transfer receipt module; The purchase receipt module performs receipt operations on the purchased items and transmits the receipt information to the database end; The transfer receipt module performs receipt operations on the transferred items and transmits the receipt information to the database end.

[0115] Embodiment Four

[0116] A computer program product includes a computer program, and when the computer program is executed, it implements the inventory processing system integrating offline and online operations as described in Embodiment One or Two.

[0117] Embodiment Five

[0118] A readable storage medium stores the computer program as described in Embodiment Four, and when the computer program is executed, it implements the inventory processing system integrating offline and online operations as described in Embodiment One or Two.

[0119] As described above, it is only the specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by those skilled in the art within the technical scope disclosed by the present invention should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims described above.

Claims

1. An inventory processing system integrating offline and online operations, characterized in that: include: The offline end is used to perform outbound operations and store outbound information when there is no network or weak network conditions. When the network conditions are good, the outbound information is transmitted to the database end, and the updated inventory information is downloaded from the database end; The online side is used to perform outbound operations when the network conditions are good, and synchronously transmit outbound information to the database side, and synchronously download and update inventory information from the database side; The database side is used to summarize and process all inbound and outbound information, update inventory information, and transmit the latest inventory information to the offline and online sides; Wherein, the database end includes: The data processing module is used to process the outbound information transmitted from different sources and different time periods of the offline and online terminals, and transmit the latest inventory information to the offline and online terminals; Inventory management summary module, used to summarize and process all inbound and outbound information and update inventory information; Wherein, the data processing module includes: The timing module is used to sort the outbound and inbound information of the items involved in the outbound information according to the inbound and outbound time; The warehouse clearance module is used to set the closing time point for the online and offline terminals, check and write off the outbound and inbound information one by one, and ensure that each outbound quantity has corresponding inbound information; The cache module is used to cache abnormal data so that users can process the abnormal data separately.

2. The inventory processing system integrating offline and online operations according to claim 1, characterized in that: The outbound information, inbound and outbound information and inventory information include: item code and item name.

3. The inventory processing system integrating offline and online operations according to claim 1, characterized in that: The offline terminal includes: Inventory management offline module, used to store and manage inventory information and outbound information; The outbound management offline module is used to query the inventory information in the reference inventory management offline module, create an outbound order, and pass the outbound information to the inventory management offline module; The data transmission management module is used to transmit data with the database end when the network conditions are good.

4. The inventory processing system integrating offline and online operations according to claim 3, characterized in that: The data transmission management module and the database end perform data transmission in manual mode and automatic mode.

5. The inventory processing system integrating offline and online operations according to claim 1, characterized in that: The online terminal includes: Inventory management online module, used to store and manage inventory information and outbound information; The outbound management online module is used to query the inventory information in the reference inventory management online module, create an outbound order, and pass the outbound information to the inventory management online module; The data transmission management module is used for data transmission with the database end.

6. The inventory processing system integrating offline and online operations according to claim 3, characterized in that: The inventory processing system processes item inventory information as follows: The database end transmits the latest inventory information of the inventory management summary module to the data processing module, and after adding the time stamp given by the timing module in the data processing module, transmits it to the offline end and the online end; The offline end receives the inventory information through the data transmission management module and updates the inventory information in the inventory management offline module; The user operates the outbound delivery in the outbound delivery management offline module, which creates an outbound delivery order based on the latest inventory information in the inventory management offline module. The inventory management offline module collects outbound information and updates the inventory, and then transmits the outbound information to the database through the offline data transmission management module; The data processing module on the database side receives the outbound information transmitted from the offline side and the online side, processes the outbound information, and then updates it to the inventory management summary module.

7. The inventory processing system integrating offline and online operations according to claim 5, characterized in that: The inventory processing system processes item inventory information as follows: The database end transmits the latest inventory information of the inventory management summary module to the data processing module, and after adding the time stamp given by the timing module in the data processing module, transmits it to the offline end and the online end; The online end receives inventory information through the data transmission management module and updates the inventory information in the inventory management online module; The user operates the outbound delivery in the outbound delivery management online module, which retrieves the latest inventory information from the inventory management online module and creates an outbound delivery order; The inventory management online module collects outbound information and updates the inventory, and then transmits the outbound information to the database through the online data transmission management module; The data processing module on the database side receives the outbound information transmitted from the offline side and the online side, processes the outbound information, and then updates it to the inventory management summary module.

8. The inventory processing system integrating offline and online operations according to claim 1, characterized in that: The inventory management summary module also includes: Stores information about inventory items, including item images and item feature codes obtained based on a pre-trained feature extraction network.

9. The inventory processing system integrating offline and online operations according to claim 1, characterized in that: The inventory processing system integrating offline and online operations also includes: The purchasing and warehousing module is used to store the purchased items and transmit the warehousing information to the database. The transfer and warehousing module is used to carry out warehousing operations on the transferred items and transmit the warehousing information to the database.

10. An inventory processing method integrating offline and online operations, characterized in that: The inventory processing system integrating offline and online operations according to any one of claims 1 to 9 comprises: Build the offline, online and database sides of inventory processing; The offline end performs outbound operations and stores outbound information when there is no network or weak network conditions. When the network conditions are good, the outbound information is transmitted to the database end, and the updated inventory information is downloaded from the database end; The online end performs outbound operations when the network conditions are good, and transmits the outbound information to the database end synchronously, and downloads and updates the inventory information synchronously from the database end; The database side summarizes and processes all inbound and outbound information, updates inventory information, and transmits the latest inventory information to the offline and online sides.

Images