Plastic trade scene-oriented cargo purchase-sale-stock data management system

Abstract

The invention discloses a plastic trade scene-oriented cargo purchase-sales-stock data management system, which belongs to the technical field of cargo purchase-sales-stock management and specifically comprises a database, a purchase management module, a sales management module, a stock management and distribution module and an order tracking module. According to the method, a purchase order-inventory real-time binding mechanism is introduced, original inventory data is updated through in-transit inventory data, a traditional inventory is divided into new inventory concepts of available inventory and in-transit inventory, after sales order data is obtained, an inventory locking engine mechanism is called, a binding relation between a sales order and a new inventory is generated, and the new inventory is obtained. According to the method, the locked inventory is determined through matching and locking of the sales order and the inventory, the inventory data is updated again to cancel after verification of the locked inventory, dynamic monitoring and synchronous association of the inventory data, the purchasing data and the sales data are achieved, the inventory management efficiency and the order performance accuracy are effectively improved, and goods are effectively prevented from being oversold and mistakenly sold.

Description

Technical Field

[0001] This invention relates to the field of goods inventory management technology, and more specifically, to a goods inventory data management system for plastics trading scenarios. Background Technology

[0002] For plastic traders, efficient inventory management is the lifeline of their business. Currently, the following are some common pain points in specific inventory management: 1. Inefficient inventory management: Inventory control relies heavily on experience, which easily leads to the awkward situation of "inventory backlog and stockouts coexisting". On the one hand, frequent stockouts of popular products affect delivery; on the other hand, slow-moving goods pile up, tying up a lot of working capital and resulting in high annual inventory costs. For the diverse range of plastic raw materials, inaccurate and untimely inventory data is the main cause of these problems. 2. Data silos and low collaboration efficiency: Purchasing, sales, and warehousing data are often independent, forming "information silos". This leads to a long process from inquiry to contract signing, low order fulfillment rate, and difficulty in collaboration between departments.

[0003] A search revealed that patent number CN117853012A discloses "An Intelligent Warehouse Inventory Management System and Method". Although this patent achieves data integration and prediction, it lacks collaboration between sales and procurement. This means that the system cannot ensure the accuracy and reliability of inventory. If goods are still in transit, the sales end may have already included them in the available inventory, but they have not actually been put into storage yet, which can easily lead to overselling. In addition, the lack of automatic inventory locking at the time of shipment may cause multiple orders to compete for the same batch of inventory, resulting in misdelivery or delays.

[0004] To address the issues of inventory management in existing technologies, a new inventory management system for the plastics trade scenario is proposed. Summary of the Invention

[0005] The purpose of this invention is to solve the problem of goods inventory management in the prior art and to provide a goods inventory management system for plastic trade scenarios.

[0006] The objective of this invention can be achieved through the following technical solution: a goods purchase, sales and inventory data management system for plastics trading scenarios, including a database, a procurement management module, a sales management module, an inventory management and allocation module and an order tracking module, wherein the database stores inventory data and safety stock thresholds;

[0007] The procurement management module formulates procurement plans based on inventory data and safety stock thresholds to create procurement contracts. After the procurement contracts are approved, an in-transit receipt order is created. Based on the in-transit receipt order, corresponding in-transit inventory data is generated and sent to the inventory management and allocation module.

[0008] The inventory management and allocation module receives in-transit inventory data and updates the inventory data based on the in-transit inventory data. At this time, the inventory data includes available inventory data and in-transit inventory data, and the available inventory data is the inventory data corresponding to the original available inventory.

[0009] The sales management module is used to obtain sales order data, and based on the inventory data and the inventory locking engine mechanism constrained by the sales order data, formulate a sales locking plan to create a sales contract. After the sales contract is approved, a locked inventory outbound order is created. Based on the locked inventory outbound order, locked outbound data corresponding to the locked inventory is generated and sent to the inventory management allocation module.

[0010] The inventory management and allocation module receives locked outbound data, cancels the locked inventory from the available inventory data and the in-transit inventory data, updates the inventory data based on the locked outbound data, and stores it in the database.

[0011] The order tracking module tracks incoming orders and locked inventory outgoing orders in real time, and uses a dynamic data-driven engine to process inventory outgoing and lock release.

[0012] Furthermore, available inventory data includes in-stock item codes and quantities; in-transit inventory data includes in-transit item codes, quantities, and estimated arrival times; and sales order data includes sales item codes, estimated sales quantities, estimated departure times, sales locations, customer levels, and order urgency.

[0013] Furthermore, the process of creating locked inventory outbound orders includes:

[0014] The sales management module determines the priority of sales orders based on customer level and order urgency in the sales order data, and follows the constraints of sales order priority. Then, it allocates and locks inventory based on the available inventory data and in-transit inventory data corresponding to the sales order data.

[0015] Specifically, by matching the uniqueness of the goods codes, under the premise that the expected sales quantity is less than the sum of the quantity in stock and the quantity in transit, and the expected outbound time is much longer than the expected inbound time, the goods in stock and the goods in transit with the same goods code in the sales order data are locked from the available inventory and the inventory in transit, and the actual sales quantity is obtained based on the locking of the goods in stock and the goods in transit.

[0016] Locked inventory outbound orders are created based on the sales product code, actual sales quantity, estimated outbound time, sales location, customer level, and order urgency. The locked outbound data includes the sales product code, actual sales quantity, and estimated outbound time.

[0017] Furthermore, the process of obtaining actual sales figures includes:

[0018] When the expected sales quantity is less than the inventory quantity, only the inventory quantity is locked from the available inventory, and the expected sales quantity is directly output as the actual sales quantity.

[0019] When the expected sales quantity is greater than the inventory quantity, compare the expected outbound time and the expected inbound time. When the expected outbound time is much longer than the expected inbound time, continue to lock the goods in transit from the inventory in transit and supplement the expected sales quantity with the quantity of goods in transit. When the expected sales quantity is less than the inventory in transit, the goods in transit can be locked directly from the inventory in transit, and the expected sales quantity is output as the actual sales quantity.

[0020] When the quantity in transit is less than the estimated sales quantity, or when the estimated outbound time is close to the estimated inbound time, negotiate with the customer to modify the order and reduce the estimated sales quantity. Specifically, when the quantity in transit is less than the estimated sales quantity, reduce the estimated sales quantity until the estimated sales quantity is less than the sum of the quantity in stock and the quantity in transit. Output the first-level reduced sales quantity as the actual sales quantity. When the estimated outbound time is close to the estimated inbound time, reduce the estimated sales quantity until the estimated sales quantity is less than the quantity in stock. Output the second-level reduced sales quantity as the actual sales quantity.

[0021] Furthermore, the process of writing off locked inventory from available inventory data and in-transit inventory data includes:

[0022] After a locked inventory outbound order is generated, if the goods in stock are locked only from the available inventory, the locked inventory is marked as "in-stock - locked inventory" and will be written off from the available inventory data. If the goods in stock and goods in transit are locked from the available inventory and the in-transit inventory respectively, the locked in-transit inventory is marked as "in-transit - locked inventory". In this case, the "in-stock - locked inventory" will be written off from the available inventory data and the "in-transit - locked inventory" will be written off from the in-transit inventory data.

[0023] Furthermore, the inventory outbound process includes: after the order tracking module detects that a locked inventory outbound order has been generated, when only the in-stock-locked inventory is associated, the corresponding in-stock goods will be picked and dispatched immediately, and its status will be updated to outbound transportation status. When both in-stock-locked inventory and in-transit-locked inventory are associated, or when only in-transit-locked inventory is associated, the logistics status of the in-transit-locked inventory will be tracked at all times. When the logistics status of the in-transit-locked inventory changes to "delivered / awaiting warehousing", the in-transit-locked inventory will be changed to in-stock-locked inventory, and the corresponding in-stock goods will be picked and dispatched immediately, and its status will be updated to outbound transportation status.

[0024] Furthermore, the process of locking and releasing includes: if the order tracking module detects that a locked inventory outbound order is canceled or payment timed out before outbound, it automatically releases the locked inventory in stock or in transit, returning it to the original available inventory or in-transit inventory pool.

[0025] Compared with the prior art, the advantages of this invention are:

[0026] 1. This solution introduces a "real-time binding mechanism between purchase orders and inventory" to update the original inventory data with in-transit inventory data. It distinguishes traditional inventory into a new inventory concept of "available inventory" and "in-transit inventory". After obtaining sales order data, it calls the inventory locking engine mechanism to generate a binding relationship between sales orders and new inventory. By matching sales orders with inventory, it determines "locked inventory" and updates the inventory data again to reclaim the locked inventory. This realizes dynamic monitoring and synchronous association between inventory data and purchase and sales data, which not only effectively improves inventory management efficiency and order fulfillment accuracy, but also effectively prevents overselling and misselling of goods.

[0027] During the process of invoking the inventory locking engine mechanism, a sales locking plan is formulated based on inventory data and sales order data constraints. A sales order and inventory batch binding relationship is generated. Based on the sales order priority constraints, quantity, and outbound and inbound time constraints, the inventory is locked from "available inventory" or "in-transit inventory" to determine "locked inventory".

[0028] 2. The order tracking module provides real-time data for inbound orders and locked inventory outbound orders. This data not only serves as a trigger signal for inventory status transitions, enabling end-to-end inventory visualization and automated management from suppliers to customers, but also automatically releases the locked inventory (either in-stock or in-transit) before outbound orders are cancelled or payment times out, allowing it to return to the original available inventory or in-transit inventory pool. Attached Figure Description

[0029] Figure 1 This is a system principle block diagram of the present invention;

[0030] Figure 2 This is a flowchart of the method of the present invention. Detailed Implementation

[0031] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative effort are within the scope of protection of the present invention.

[0032] Example 1: This invention discloses a goods inventory management system for plastics trading scenarios. Please refer to [link / reference]. Figure 1 It includes a database, a procurement management module, a sales management module, an inventory management and allocation module, and an order tracking module. The database stores inventory data and safety stock thresholds, which can be automatically set based on historical data and sales forecasts.

[0033] The procurement management module formulates procurement plans and creates procurement contracts based on inventory data and safety stock thresholds. When the inventory of a certain item reaches the safety stock threshold, the system will automatically send an early warning message and can even intelligently generate replenishment suggestions to effectively reduce the risk of stockouts and overstocking. After the procurement contract is approved, an in-transit receipt order is created. Based on the in-transit receipt order, corresponding in-transit inventory (goods that have been ordered but not yet received) in-transit inventory data is generated and sent to the inventory management and allocation module to ensure the rationality of inventory and the accuracy of procurement.

[0034] The inventory management and allocation module receives in-transit inventory data and updates the inventory data based on the in-transit inventory data. At this time, the inventory data includes available inventory data and in-transit inventory data. Available inventory data is the inventory data corresponding to the original available inventory (goods that have been put into storage). Available inventory data includes the in-stock goods code and the quantity in stock. In-transit inventory data includes the in-transit goods code, the quantity in transit, and the expected inbound time.

[0035] The sales management module is used to acquire sales order data, which includes the sales product code, expected sales quantity, expected delivery time, sales location, customer level, and order urgency. Based on inventory data and the inventory locking engine mechanism constrained by sales order data, it generates a binding relationship between sales orders and inventory batches, formulates a sales locking plan to create sales contracts, and creates locked inventory delivery orders after the sales contracts are approved. Based on the locked inventory delivery orders, it generates locked inventory (goods that have been bound to sales orders and locked and have been received or ordered but not yet received, goods ready for delivery or waiting for delivery) locked delivery data and sends it to the inventory management allocation module.

[0036] The process of creating a locked inventory outbound order includes:

[0037] The sales management module obtains available inventory data, in-transit inventory data, and sales order data, and determines the priority of sales orders based on customer level and order urgency in the sales order data.

[0038] Following the priority constraints of sales orders, inventory allocation and locking are performed based on the available inventory data and in-transit inventory data corresponding to the sales order data. Immediately after a sales order is generated, an "inventory lock request" is generated. Specifically, by matching the uniqueness of the product code, and ensuring that the expected sales quantity is less than the sum of the in-stock quantity and the in-transit quantity, and that the expected outbound time is much longer than the expected inbound time, the in-stock and in-transit products with the same product code in the sales order data are locked from the available inventory and in-transit inventory. The actual sales quantity is obtained based on the locked in-stock and in-transit products. The actual sales quantity is determined by the quantity of in-stock and in-transit products and the consensus reached through customer negotiation.

[0039] Create locked inventory outbound orders based on sales product codes, actual sales quantities, estimated outbound time, sales location, customer level, and order urgency. Lock the corresponding sales quantity of goods from "available inventory" or "in-transit inventory" according to sales order priority constraints, quantity, and outbound / inbound time constraints. Locked outbound data includes sales product codes, actual sales quantities, and estimated outbound time.

[0040] The process of obtaining actual sales figures includes:

[0041] When the expected sales quantity is less than the inventory quantity, only the inventory is locked from the available inventory, and the expected sales quantity is directly output as the actual sales quantity. For the abundant spot inventory, a real-time dynamic allocation method is used for management to ensure flexible deduction of spot inventory.

[0042] When the expected sales quantity is greater than the inventory quantity, compare the expected outbound time and the expected inbound time. If the expected outbound time is much longer than the expected inbound time, continue to lock the goods in transit from the inventory in transit and use the quantity of the goods in transit to supplement the expected sales quantity. If the expected sales quantity is less than the inventory in transit, the goods in transit can be locked directly from the inventory in transit (the inventory in transit is directly referenced by the sales order), and the expected sales quantity is output as the actual sales quantity.

[0043] When the quantity in transit is less than the estimated sales quantity, or when the estimated outbound time is close to the estimated inbound time, negotiate with the customer to modify the order and reduce the estimated sales quantity. Specifically, when the quantity in transit is less than the estimated sales quantity, reduce the estimated sales quantity until the estimated sales quantity is less than the sum of the quantity in stock and the quantity in transit. Output the first-level reduced sales quantity as the actual sales quantity. When the estimated outbound time is close to the estimated inbound time (the estimated sales quantity cannot be replenished by the inventory in transit), reduce the estimated sales quantity until the estimated sales quantity is less than the quantity in stock. Output the second-level reduced sales quantity as the actual sales quantity. Ensure that the actual sales quantity (locked inventory quantity) is less than the inventory data. The core process of locking inventory immediately when the locked inventory outbound order is generated includes a series of steps such as inventory status division, constraint relationship generation, lock request, and locked inventory generation.

[0044] Example 2: The inventory management and allocation module receives locked outbound data, removes the locked inventory from the available inventory data and in-transit inventory data, updates the inventory data based on the locked outbound data, and stores it in the database (reducing the inventory), thus completing the inventory transfer. The specific process includes:

[0045] After a locked inventory outbound order is generated, if only the in-stock goods are locked from the available inventory, the locked inventory will be marked as in-stock - locked inventory, and the in-stock - locked inventory will be written off from the available inventory data;

[0046] When goods in stock and goods in transit are locked from available inventory and in-transit inventory respectively, the locked in-transit inventory is recorded as in-transit-locked inventory. At this time, the locked inventory includes both the locked inventory in stock and the in-transit-locked inventory. The locked inventory in stock is cleared from the available inventory data, and the in-transit-locked inventory is cleared from the in-transit inventory data. When a sales order points to such goods, the inventory locking engine can lock a specific quantity in the "in-transit inventory". When the goods are actually received into the warehouse, the system automatically changes the status of this batch of goods directly from "in transit" to "locked", seamlessly connecting to the waiting orders and effectively preventing missales.

[0047] The order tracking module tracks inbound orders and locked inventory outbound orders in real time. Based on a dynamic data-driven engine, it handles inventory outbound and lock release processes, including:

[0048] When the order tracking module detects that a locked inventory outbound order has been generated, if only the in-stock-locked inventory is associated, it immediately picks and ships the corresponding in-stock goods and updates its status to outbound transportation status. If both in-stock-locked inventory and in-transit-locked inventory are associated, or if only in-transit-locked inventory is associated, it tracks the logistics status of the in-transit-locked inventory in real time. When the logistics status of the in-transit-locked inventory changes to "delivered / awaiting warehousing", the in-transit-locked inventory is changed to in-stock-locked inventory, and the corresponding in-stock goods are immediately picked and shipped, updating its status to outbound transportation status. If the locked inventory outbound order is successfully outbound without any changes, the locked outbound data is directly stored in the database as sales outbound data as historical data.

[0049] If the order tracking module detects that a locked inventory outbound order is canceled or payment timed out before shipment, it automatically releases the locked inventory in the in-stock or in-transit pool, returning it to the original available inventory or in-transit inventory pool.

[0050] Please see Figure 2 In conjunction with Embodiments 1 and 2, this invention also proposes a method for managing goods inventory and sales data in the context of plastics trading, comprising the following steps:

[0051] Step 1: In-transit inventory generation: Based on inventory data and safety stock threshold, formulate a procurement plan, create in-transit inbound orders, and generate corresponding in-transit inventory data based on the in-transit inbound orders;

[0052] Step 2, Inventory Update: Update the inventory data based on the in-transit inventory data. At this time, the inventory data includes available inventory data and in-transit inventory data, with the available inventory data corresponding to the original available inventory.

[0053] Step 3, Inventory Locking: Obtain sales order data, formulate a sales locking plan based on the inventory data and the inventory locking engine mechanism constrained by the sales order data, create locked inventory outbound orders, and generate locked outbound data for the corresponding locked inventory based on the locked inventory outbound orders;

[0054] Step 4, Inventory Verification and Secondary Update: Based on the locking status, the locked inventory is divided into In-Stock - Locked Inventory and In-Transit - Locked Inventory. The In-Stock - Locked Inventory and In-Transit - Locked Inventory are deactivated from the available inventory data and in-transit inventory data, respectively. The inventory data is updated based on the locked outbound data and stored in the database.

[0055] Step 5: Inventory Outbound, Lock Release, and Update Again: Track inbound orders and locked inventory outbound orders in real time. Drive the engine with dynamic order data to process inventory outbound and lock release, update the inventory data again, and store it in the database.

[0056] In summary, the "Purchase Order - Real-time Inventory Binding" mechanism is introduced to update the original inventory data with in-transit inventory data. This new inventory concept distinguishes traditional inventory into "available inventory" and "in-transit inventory." After obtaining sales order data, the inventory locking engine mechanism is invoked to generate a binding relationship between the sales order and the new inventory. By matching the sales order with the inventory, "locked inventory" is determined, and the inventory data is updated again to reclaim the locked inventory. This achieves dynamic monitoring and synchronous association between inventory data and purchase and sales data, which not only effectively improves inventory management efficiency and order fulfillment accuracy but also effectively prevents overselling and misselling of goods.

[0057] The order tracking module provides real-time data for inbound orders and locked inventory outbound orders. This data not only serves as a trigger signal for inventory status transitions, but also automatically releases the locked inventory (either in-stock or in-transit) before outbound orders are cancelled or payment times out, allowing it to return to the original available inventory or in-transit inventory pool.

[0058] The above description is merely a preferred embodiment of the present invention; however, the scope of protection of the present invention is not limited thereto; any equivalent substitutions or modifications made by those skilled in the art within the technical scope disclosed in the present invention, based on the technical solution and its improved concept, should be covered within the scope of protection of the present invention.

Claims

1. A goods inventory management system for plastics trading scenarios, characterized by: It includes a database, a procurement management module, a sales management module, an inventory management and allocation module, and an order tracking module. The database stores inventory data and safety stock thresholds. The procurement management module formulates procurement plans based on inventory data and safety stock thresholds to create procurement contracts. After the procurement contracts are approved, an in-transit receipt order is created. Based on the in-transit receipt order, corresponding in-transit inventory data is generated and sent to the inventory management and allocation module. The inventory management and allocation module receives in-transit inventory data and updates the inventory data based on the in-transit inventory data. At this time, the inventory data includes available inventory data and in-transit inventory data, and the available inventory data is the inventory data corresponding to the original available inventory. The sales management module is used to obtain sales order data, and based on the inventory data and the inventory locking engine mechanism constrained by the sales order data, formulate a sales locking plan to create a sales contract. After the sales contract is approved, a locked inventory outbound order is created. Based on the locked inventory outbound order, locked outbound data corresponding to the locked inventory is generated and sent to the inventory management allocation module. The inventory management and allocation module receives locked outbound data, cancels the locked inventory from the available inventory data and the in-transit inventory data, updates the inventory data based on the locked outbound data, and stores it in the database. The order tracking module tracks incoming orders and locked inventory outgoing orders in real time. It uses a dynamic data-driven engine to process inventory outgoing and locking releases, updates inventory data, and stores it in the database.

2. The goods inventory management system for plastics trading scenarios according to claim 1, characterized in that: Available inventory data includes in-stock item codes and quantities; in-transit inventory data includes in-transit item codes, quantities, and estimated arrival times; and sales order data includes sales item codes, estimated sales quantities, estimated departure times, sales locations, customer levels, and order urgency.

3. The goods inventory management system for plastics trading scenarios according to claim 2, characterized in that: The process of creating a locked inventory outbound order includes: The sales management module determines the priority of sales orders based on customer level and order urgency in the sales order data, and follows the constraints of sales order priority. Then, it allocates and locks inventory based on the available inventory data and in-transit inventory data corresponding to the sales order data. Specifically, by matching the uniqueness of the goods codes, under the premise that the expected sales quantity is less than the sum of the quantity in stock and the quantity in transit, and the expected outbound time is much longer than the expected inbound time, the goods in stock and the goods in transit with the same goods code in the sales order data are locked from the available inventory and the inventory in transit, and the actual sales quantity is obtained based on the locking of the goods in stock and the goods in transit. Locked inventory outbound orders are created based on the sales product code, actual sales quantity, estimated outbound time, sales location, customer level, and order urgency. The locked outbound data includes the sales product code, actual sales quantity, and estimated outbound time.

4. The goods inventory management system for plastics trading scenarios according to claim 3, characterized in that: The process of obtaining actual sales figures includes: When the expected sales quantity is less than the inventory quantity, only the inventory is locked from the available inventory, and the expected sales quantity is directly output as the actual sales quantity. When the expected sales quantity is greater than the inventory quantity, compare the expected outbound time and the expected inbound time. When the expected outbound time is much longer than the expected inbound time, continue to lock the goods in transit from the inventory in transit and supplement the expected sales quantity with the quantity of goods in transit. When the expected sales quantity is less than the inventory in transit, the goods in transit can be locked directly from the inventory in transit, and the expected sales quantity is output as the actual sales quantity. When the quantity in transit is less than the estimated sales quantity, or when the estimated outbound time is close to the estimated inbound time, negotiate with the customer to modify the order and reduce the estimated sales quantity. Specifically, when the quantity in transit is less than the estimated sales quantity, reduce the estimated sales quantity until the estimated sales quantity is less than the sum of the quantity in stock and the quantity in transit. Output the first-level reduced sales quantity as the actual sales quantity. When the estimated outbound time is close to the estimated inbound time, reduce the estimated sales quantity until the estimated sales quantity is less than the quantity in stock. Output the second-level reduced sales quantity as the actual sales quantity.

5. The goods inventory management system for plastics trading scenarios according to claim 4, characterized in that: The process of writing off locked inventory from available inventory data and in-transit inventory data includes: After a locked inventory outbound order is generated, if the goods in stock are locked only from the available inventory, the locked inventory is marked as "in-stock - locked inventory" and will be written off from the available inventory data. If the goods in stock and goods in transit are locked from the available inventory and the in-transit inventory respectively, the locked in-transit inventory is marked as "in-transit - locked inventory". In this case, the "in-stock - locked inventory" will be written off from the available inventory data and the "in-transit - locked inventory" will be written off from the in-transit inventory data.

6. The goods inventory management system for plastics trading scenarios according to claim 5, characterized in that: The process of issuing inventory includes: After the order tracking module detects that a locked inventory issuance order has been generated, when only the in-stock locked inventory is associated, the corresponding in-stock goods will be picked and issued immediately, and its status will be updated to outbound transportation status. When both in-stock locked inventory and in-transit locked inventory are associated, or when only in-transit locked inventory is associated, the logistics status of the in-transit locked inventory will be tracked at all times. When the logistics status of the in-transit locked inventory changes to "delivered / awaiting warehousing", the in-transit locked inventory will be changed to in-stock locked inventory, and the corresponding in-stock goods will be picked and issued immediately, and its status will be updated to outbound transportation status.

7. The goods inventory management system for plastics trading scenarios according to claim 6, characterized in that: The process of locking and releasing inventory includes: if the order tracking module detects that a locked inventory outbound order is canceled or payment timed out before outbound, it automatically releases the locked inventory in stock or in transit for that order, returning it to the original available inventory or in-transit inventory pool.

Images