Inventory information processing method and system

Abstract

This application discloses an inventory information processing method and system, which records the inventory information of the commodity object in this area through an inventory account table. The inventory account table includes an account type field, a first user identification field and an inventory quantity field. The account type is based on The inventory allocation method of the corresponding first user is determined by the owner of the commodity object. The method includes: after receiving an operation request from a front-end second user to operate the specified commodity object of the specified first user, obtaining the corresponding information of the second user. The geographical location information of the second user; select the target area according to the geographical location information corresponding to the second user; read the inventory account record corresponding to the designated first user in the inventory account table of the target area, and determine based on the read result The target inventory account record to be operated; operate the target inventory account record according to the operation request. Through this application, it is easy to ensure the accuracy of each piece of logical inventory data and facilitate expansion.

Description

technical field [0001] This application relates to the technical field of inventory management in an e-commerce transaction platform, in particular to an inventory information processing method and system. Background technique [0002] In the e-commerce trading platform, due to the requirements of the delivery area of ​​the product object, the merchant often needs to set up different warehouses for the product object in different geographical regions, and equip each warehouse with corresponding physical inventory to meet the principle of nearby delivery and save delivery Time required, cost, etc. [0003] Due to business development, merchants generally need to separate part of the inventory in the same warehouse for sale in specific channels (such as assigning to other sellers for consignment sales), or participate in special sales activities organized by the trading platform. In addition, the merchants of the supply chain distribution platform need to allocate part of the...

AI Technical Summary

Problems solved by technology

Moreover, since merchants can use a variety of different allocation methods when allocating inventory, there may be overlaps between multiple logical inventories, etc., it is difficult to maintain a balance between the logical inventory of each seller and the physical inventory in the warehouse. Consistency in quantity, therefore, there are difficulties in managing these logical inventories

[0004] For this reason, there are generally two processing methods in the prior art. One is to record each logical inventory by adding a new database table field on the basis of the original inventory table. However, this method is difficult to adapt to flexible business expansion; The second is to create an additional inventory table to record logical inventory separately. This method not only increases the cost and complexity of inventory management, but also makes it difficult to achieve consistency between the inventory in the logical inventory table and the inventory in the physical inventory table.

In this way, it is difficult to know how many products each seller has sold through the inventory table, whether the plan needs to be changed, etc.

Images