Inventory information processing method and system

Abstract

The invention discloses an inventory information processing method and system. An inventory account table is used for recording inventory information of commerce objects in the area. The inventory account table comprises account type fields, first user identification fields and inventory number fields. The account type is determined according to the inventory distribution mode of the commerce objects to a corresponding first user. The method comprises the first step of acquiring the geographic position information of a second user after an operation request of the front-end second user for conducting operation on the designated commerce object of the designated first user, the second step of selecting a target area according to the geographic position information of the second user, the third step of reading inventory account records corresponding to the designated first user from the inventory account table in the target area and determining the target inventory account records to be operated according to a reading result, and the fourth step of conducting operation on the target inventory account records according to the operation request. By means of the method and system, accuracy of all logic inventory data can be guaranteed, and expansion is facilitated.

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