TWI553567B - Accurate warehouse management system based on order status and method thereof - Google Patents

Accurate warehouse management system based on order status and method thereof Download PDF

Info

Publication number
TWI553567B
TWI553567B TW104143958A TW104143958A TWI553567B TW I553567 B TWI553567 B TW I553567B TW 104143958 A TW104143958 A TW 104143958A TW 104143958 A TW104143958 A TW 104143958A TW I553567 B TWI553567 B TW I553567B
Authority
TW
Taiwan
Prior art keywords
inventory
order
stock
name
merchandise
Prior art date
Application number
TW104143958A
Other languages
Chinese (zh)
Other versions
TW201723939A (en
Inventor
高貫偉
Original Assignee
英業達股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 英業達股份有限公司 filed Critical 英業達股份有限公司
Priority to TW104143958A priority Critical patent/TWI553567B/en
Application granted granted Critical
Publication of TWI553567B publication Critical patent/TWI553567B/en
Publication of TW201723939A publication Critical patent/TW201723939A/en

Links

Description

依據訂單狀態提供精確倉儲管理系統及其方法Providing accurate warehouse management system and method thereof according to order status

一種倉儲管理系統及其方法,尤其是指一種依據訂單狀態即時審核結果所產生的訂單進而提供精確倉儲管理系統及其方法。 A warehouse management system and method thereof, in particular, an order generated by an immediate audit result based on an order status, thereby providing an accurate warehouse management system and method thereof.

藉由電子商務發展迅猛,越來越多的訂購系統提供商品的銷售,例如:露天、淘寶、天貓、京東、亞馬遜…等,由於訂購系統的擴張,訂購系統多元化的情況會使得商品銷售速度增加,銷售速度增加的情況下往往會導致銷售商的倉儲管理不便,即商品庫存不夠精准,無法及時應對庫存的變化,進而失去商機。 With the rapid development of e-commerce, more and more ordering systems provide merchandise sales, such as: open air, Taobao, Tmall, JD, Amazon...etc. Due to the expansion of the ordering system, the diversification of the ordering system will make the goods The increase in sales speed and the increase in sales speed often lead to inconvenience to the warehousing management of the seller, that is, the inventory of the goods is not accurate enough to respond to changes in the inventory in time, thereby losing business opportunities.

另外,在訂購系統有訂單產生時,扣除了商品庫存。訂單流轉到倉庫,在處理的任何階段,購買者有可能進行更換商品、退掉商品…等,由於沒有及時更新商品的庫存,導致有特殊作業時,亦會造成商品庫存不準確。 In addition, when the order system has an order, the goods inventory is deducted. The order flow is transferred to the warehouse. At any stage of the processing, the purchaser may change the goods, return the goods, etc., and the inventory of the goods may not be accurate due to the lack of timely updating of the inventory of the goods, resulting in special operations.

綜上所述,可知先前技術中長期以來一直存在倉儲管理無法依據即時情況進行調整而造成商品庫存不精確的問題,因此有必要提出改進的技術手段,來解決此一問題。 In summary, it can be seen that in the prior art, there has been a problem that warehouse management cannot be adjusted according to the immediate situation and the inventory of the goods is not accurate. Therefore, it is necessary to propose an improved technical means to solve this problem.

有鑒於先前技術存在現有技術無法達到依據訂單狀態提供精確倉儲管理的問題,本發明遂揭露一種依據訂單狀態提供精確倉儲管理系統及其方法,其中:本發明所揭露的依據訂單狀態提供精確倉儲管理系統,其包含:商品倉儲資料庫、接收模組以及處理模組。 In view of the prior art, the prior art cannot provide the problem of providing accurate storage management according to the order status, the present invention discloses an accurate storage management system and method thereof according to the order status, wherein: the present invention provides accurate storage management according to the order status. The system comprises: a commodity storage database, a receiving module and a processing module.

倉儲管理系統的商品倉儲資料庫儲存有多筆商品資料,每一筆商品資料包含商品位置、商品名稱以及庫位庫存,並依據商品名稱統計庫位庫存為在售庫存。 The commodity storage database of the warehouse management system stores a plurality of commodity materials, and each commodity data includes a commodity location, a product name, and a stock inventory, and the stock inventory is calculated according to the trade name.

倉儲管理系統的接收模組是用以接收訂單,訂單包含至少一商品名稱、與商品名稱對應的數量、訂單狀態以及訂單操作。 The receiving module of the warehouse management system is for receiving an order, and the order includes at least one product name, a quantity corresponding to the product name, an order status, and an order operation.

倉儲管理系統的處理模組用以依據訂單的訂單狀態以及訂單操作執行下列操作:當訂單狀態為付款成功時,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更;當訂單狀態為客服審核、當訂單操作為審核操作且當對應商品名稱的在售庫存減去數量為負數時,則訂單未能通過審核,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更;當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為售出商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存減去數量以更新對應商品名稱的在售庫存;當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為取消商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存;當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為變更商品時,依據商品名 稱對商品倉儲資料庫中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存;當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為售出商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存減去數量以更新對應庫位庫存;當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為取銷商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存;當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為變更商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加或是減去數量以更新對應庫位庫存;當訂單狀態為出庫驗證與秤重時,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更;及當訂單狀態為配送完成後退貨時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存。 The processing module of the warehouse management system is configured to perform the following operations according to the order status of the order and the order operation: when the order status is payment success, the inventory in the commodity storage database and the corresponding inventory inventory are not changed; when the order status For the customer service audit, when the order operation is the audit operation and when the sales inventory minus the quantity of the corresponding product name is negative, the order fails to pass the audit, and the inventory in the commodity warehouse database and the corresponding location inventory are not changed. When the order status is customer service audit and the order is approved, and when the order operation is sold, the quantity is deducted from the corresponding stock in the stock warehouse database according to the product name to update the stock of the corresponding product name; The status is customer service audit and the order is approved, and when the order operation is canceled, the quantity of the corresponding stock in the goods warehouse database is updated according to the product name to update the stock of the corresponding product name; when the order status is customer service audit and When the order is approved and when the order is operated as a change, the quotient Name It refers to the increase or decrease of the corresponding stock in the commodity storage database to update the stock of the corresponding commodity name; when the order status is the generated bill of lading or the print order, and when the order is operated as the sold item When the quantity is subtracted from the corresponding stock in the commodity storage database according to the product name to update the stock of the corresponding product name, and the stock quantity corresponding to the product position of the assigned product name is subtracted from the stock quantity to update the corresponding library. Bit stock; when the order status is to generate a bill of lading or print a courier and when the order is operated as a resale item, the quantity of the corresponding stock in the merchandise stock database is increased according to the item name to update the corresponding item name for sale. Inventory, and update the corresponding inventory inventory according to the inventory increase corresponding to the position of the commodity to which the commodity name is assigned; when the order status is to generate a bill of lading or print a courier and when the order operation is a changed merchandise, according to the merchandise The name is added to the corresponding stock in the commodity storage database or the quantity is subtracted to update the stock of the corresponding commodity name, and According to the location of the goods corresponding to the product name, the inventory inventory is increased or subtracted to update the corresponding inventory inventory; when the order status is outbound verification and weighing, the inventory in the commodity storage database and the corresponding location The stock is not changed; and when the order status is returned after the delivery is completed, the quantity of the corresponding stock in the goods storage database is increased according to the product name to update the stock of the corresponding product name, and the goods according to the name of the goods to be distributed The location corresponding to the location inventory is increased to update the corresponding location inventory.

本發明所揭露的依據訂單狀態提供精確倉儲管理的方法,其包含下列步驟:首先,提供倉儲管理系統,且倉儲管理系統包含商品倉儲資料庫,商品倉儲資料庫儲存有多筆商品資料,每一筆商品資料包含商品位置、商品名稱以及庫位庫存,並依據商品名稱統計庫位庫存為在售庫存;接著,倉儲管理系統接收訂單,訂單包含至少一商品名稱、與商品名稱對應的數量、訂單 狀態以及訂單操作;接著,倉儲管理系統依據訂單的訂單狀態以及訂單操作執行下列操作:當訂單狀態為付款成功時,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更;接著,當訂單狀態為客服審核、當訂單操作為審核操作且當對應商品名稱的在售庫存減去數量為負數時,則訂單未能通過審核,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更;接著,當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為售出商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存減去數量以更新對應商品名稱的在售庫存;接著,當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為取消商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存;接著,當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為變更商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存;接著,當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為售出商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存減去數量以更新對應庫位庫存;接著,當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為取銷商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存;接著,當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為變更商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的 庫位庫存增加或是減去數量以更新對應庫位庫存;接著,當訂單狀態為出庫驗證與秤重時,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更;最後,當訂單狀態為配送完成後退貨時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存。 The method for providing accurate warehouse management according to the order status disclosed in the present invention comprises the following steps: First, providing a warehouse management system, and the warehouse management system includes a commodity storage database, and the commodity storage database stores a plurality of commodity materials, each of which The product data includes the product location, the product name, and the inventory inventory, and the inventory inventory is calculated according to the product name; then, the warehouse management system receives the order, and the order includes at least one product name, the quantity corresponding to the product name, and the order. Status and order operation; then, the warehouse management system performs the following operations according to the order status of the order and the order operation: when the order status is payment success, the inventory in the goods warehouse database and the corresponding location inventory are not changed; When the order status is customer service audit, when the order operation is the audit operation and when the quantity of the corresponding stock name minus the stock value is negative, the order fails to pass the audit, the stock in the commodity warehouse database and the corresponding stock inventory Not changed; then, when the order status is customer service review and the order is approved and when the order operation is sold, the quantity corresponding to the corresponding stock in the goods storage database is updated according to the product name to update the corresponding product name. Selling inventory; then, when the order status is customer service audit and the order is approved, and when the order operation is canceled, the quantity of the corresponding stock in the goods warehousing database is increased according to the product name to update the stock of the corresponding product name; Then, when the order status is customer service review and the order is approved And when the order operation is a change of the goods, the sales amount of the corresponding goods name is updated or subtracted according to the product name to the corresponding stock in the goods storage database; and then, when the order status is the generated goods order or Is to print the courier slip and when the order operation is the sold merchandise, the quantity of the corresponding stock in the merchandise warehouse is decremented according to the merchandise name to update the stock of the corresponding merchandise name, and according to the merchandise of the assigned merchandise name The location corresponding to the location inventory minus the quantity to update the corresponding location inventory; then, when the order status is to generate a bill of lading or print the delivery order and when the order operation is to cancel the merchandise, according to the merchandise name in the merchandise storage database The corresponding in-stock inventory is increased to update the in-stock inventory corresponding to the product name, and the corresponding inventory inventory quantity is updated according to the position of the inventory corresponding to the commodity position of the assigned product name; then, when the order status is the generated bill of lading Or print the courier receipt and when the order operation is changed, according to the product name, the corresponding corresponding in the merchandise storage database The sale of inventories increased or reduced by the number to update the corresponding product names in the sale of inventory, and the corresponding positions are allocated according to the commodity trade names of The stock inventory is increased or subtracted to update the corresponding stock inventory; then, when the order status is outbound verification and weighing, the inventory in the commodity warehouse database and the corresponding stock inventory are not changed; finally, when When the order status is returned after the delivery is completed, the quantity of the corresponding stock in the goods storage database is increased according to the product name to update the stock of the corresponding product name, and the stock position corresponding to the product position of the assigned product name is increased. Quantity to update the corresponding location inventory.

本發明所揭露的系統及方法如上,與先前技術之間的差異在於本發明依據訂單的訂單狀態以及訂單操作進行倉儲管理系統的商品倉儲資料庫中在售庫存以及庫位庫存計算與更新,藉以提供精確倉儲管理的效用。 The system and method disclosed by the present invention are as above, and the difference from the prior art is that the present invention performs inventory calculation and inventory inventory calculation and update in the commodity storage database of the warehouse management system according to the order status of the order and the order operation. Provides the utility of accurate warehouse management.

透過上述的技術手段,本發明可以達成依據訂單狀態以提供精確倉儲管理的技術功效。 Through the above technical means, the present invention can achieve the technical effect of providing accurate storage management according to the order status.

20‧‧‧倉儲管理系統 20‧‧‧Warehouse Management System

21‧‧‧商品倉儲資料庫 21‧‧‧Commodity warehousing database

22‧‧‧接收模組 22‧‧‧ receiving module

23‧‧‧處理模組 23‧‧‧Processing module

24‧‧‧生成模組 24‧‧‧Generation Module

25‧‧‧顯示模組 25‧‧‧ display module

26‧‧‧發送模組 26‧‧‧Send module

27‧‧‧確認變更模組 27‧‧‧Confirm change module

步驟110‧‧‧提供倉儲管理系統,且倉儲管理系統包含商品倉儲資料庫,商品倉儲資料庫儲存有多筆商品資料,每一筆商品資料包含商品位置、商品名稱以及庫位庫存,並依據商品名稱統計庫位庫存為在售庫存 Step 110‧‧‧ provides a warehouse management system, and the warehouse management system includes a commodity storage database, and the commodity storage database stores a plurality of commodity materials, each commodity data including a product location, a product name, and a location inventory, and according to the product name Statistical inventory inventory is in stock

步驟120‧‧‧倉儲管理系統接收訂單,訂單包含至少一商品名稱、與商品名稱對應的數量、訂單狀態以及訂單操作 Step 120‧‧ ‧ The warehouse management system receives the order, the order contains at least one product name, the quantity corresponding to the product name, the order status, and the order operation

步驟130‧‧‧倉儲管理系統依據訂單的訂單狀態以及訂單操作執行下列操作 Step 130‧‧‧ The warehouse management system performs the following operations based on the order status of the order and the order operation

步驟1301‧‧‧當訂單狀態為付款成功時,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更 Step 1301‧‧‧ When the order status is payment success, the inventory in the commodity warehouse database and the corresponding location inventory are not changed.

步驟1302‧‧‧當訂單狀態為客服審核、當訂單操作為審核操作且當對應商品名稱的在售庫存減去數量為負數時,則訂單未能通過審核,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更 Step 1302‧‧‧ When the order status is customer service audit, when the order operation is an audit operation and when the quantity of the corresponding stock name minus the stock name is negative, the order fails to pass the audit, and the stock in the merchandise repository is in stock and The corresponding location inventory is not changed

步驟1303‧‧‧當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為售出商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存減去數量以更新對應商品名稱的在售庫存 Step 1303‧‧‧ When the order status is customer service audit and the order is approved, and when the order operation is sold, the quantity of the corresponding stock in the goods warehouse database is deducted according to the product name to update the corresponding product name for sale. in stock

步驟1304‧‧‧當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為取消商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存 Step 1304‧‧‧ When the order status is customer service review and the order is approved, and when the order operation is canceled, the quantity of the corresponding stock in the goods storage database is increased according to the product name to update the sales stock of the corresponding product name.

步驟1305‧‧‧當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為變更商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存 Step 1305‧‧‧ When the order status is customer service audit and the order is approved and when the order operation is changed, the corresponding item name is updated or subtracted according to the product name for the corresponding stock in the product warehouse database. In stock

步驟1306‧‧‧當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為售出商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存減去數量以更新對應庫位庫存 Step 1306‧‧‧ When the order status is to generate a bill of lading or to print a courier and when the order is operated as a merchandise, the corresponding merchandise is decremented according to the merchandise name to update the corresponding merchandise according to the merchandise inventory The stock of the name is sold, and the corresponding inventory level is updated according to the stock inventory corresponding to the position of the commodity to which the product name is assigned.

步驟1307‧‧‧當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為取銷商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存 Step 1307‧‧‧ When the order status is to generate a bill of lading or to print a courier and when the order is operated as a merchandise, the quantity corresponding to the stock in the merchandise stock database is updated according to the merchandise name to update the corresponding merchandise name. In the inventory, and according to the position of the goods corresponding to the position of the goods to be assigned to increase the number of inventory to update the corresponding inventory

步驟1308‧‧‧當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為變更商品時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加或是減去數量以更新對應庫位庫存 Step 1308‧‧‧ When the order status is to generate a bill of lading or to print a courier and when the order is operated as a change item, the quantity is updated or decremented according to the item name to the corresponding stock in the merchandise storage database. Corresponding inventory inventory corresponding to the product name, and increasing or subtracting the inventory based on the inventory corresponding to the product location of the assigned product name to update the corresponding inventory inventory

步驟1309‧‧‧當訂單狀態為出庫驗證與秤重時,商品倉儲資料庫中在售庫存以及對應的庫位庫存不被變更 Step 1309‧‧‧ When the order status is outbound verification and weighing, the inventory in the commodity warehouse database and the corresponding location inventory are not changed.

步驟1310‧‧‧當訂單狀態為配送完成後退貨時,依據商品名稱對商品倉儲資料庫中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存 Step 1310‧‧‧ When the order status is returned after the delivery is completed, the quantity of the corresponding stock in the goods storage database is increased according to the product name to update the stock of the corresponding product name, and the position of the goods according to the assigned product name The corresponding inventory inventory is increased to update the corresponding location inventory

步驟141‧‧‧當倉儲管理系統依據被分配商品名稱的商品位置對應的庫位庫存增加或是減去數量以更新對應庫位庫存時,對應生成第一提示訊息 Step 141‧‧‧ When the warehouse management system increases or decreases the corresponding stock position inventory according to the stock position corresponding to the product position of the assigned product name, the corresponding first prompt message is generated.

步驟142‧‧‧倉儲管理系統顯示第一提示訊息 Step 142‧‧ ‧ The warehouse management system displays the first prompt message

步驟143‧‧‧倉儲管理系統發送第一提示訊息至手持式裝置 Step 143‧‧ ‧ The warehouse management system sends the first prompt message to the handheld device

步驟151‧‧‧倉儲管理系統接收確認指令 Step 151‧‧ ‧ The warehouse management system receives the confirmation command

步驟152‧‧‧倉儲管理系統依據確認指令確認更新對應庫位庫存 Step 152‧‧ ‧ The warehouse management system confirms the update of the corresponding inventory in accordance with the confirmation command

步驟153‧‧‧若倉儲管理系統經過預設時間未接收到確認指令,則生成第二提示訊息 Step 153‧‧‧ If the warehouse management system does not receive the confirmation command after the preset time, the second prompt message is generated.

步驟154‧‧‧倉儲管理系統顯示第二提示訊息 Step 154‧‧ ‧ The warehouse management system displays the second prompt message

步驟155‧‧‧倉儲管理系統發送第二提示訊息至手持式裝置,並且倉儲管理系統依據被分配商品名稱的商品位置對應的庫位庫存恢復為未更新前的庫位庫存 Step 155‧‧ ‧ The warehousing management system sends the second prompt message to the handheld device, and the warehousing management system restores the inventory inventory corresponding to the commodity location of the assigned product name to the inventory inventory before the update

第1圖繪示為本發明依據訂單狀態提供精確倉儲管理系統的系統方塊圖。 FIG. 1 is a block diagram of a system for providing an accurate warehouse management system according to an order status according to the present invention.

第2A圖至第2D圖繪示為本發明依據訂單狀態提供精確倉儲管理方法的方法流程圖。 2A to 2D are flow charts showing a method for providing an accurate warehouse management method according to an order status according to the present invention.

以下將配合圖式及實施例來詳細說明本發明的實施方式,藉此對本發明如何應用技術手段來解決技術問題並達成技術功效的實現過程能充分理解並據以實施。 The embodiments of the present invention will be described in detail below with reference to the drawings and embodiments, so that the application of the technical means to solve the technical problems and achieve the technical effects can be fully understood and implemented.

以下首先要說明本發明所揭露的依據訂單狀態提供精確倉儲管理系統,並請參考「第1圖」所示,「第1圖」繪示為本發明依據訂單狀態提供精確倉儲管理系統的系統方塊圖;「第2A圖」至「第2D圖」繪示為本發明依據訂單狀態提供精確倉儲管理方法流程圖。 The following is a description of the accurate storage management system according to the order status disclosed in the present invention, and please refer to "1", which is a system block for providing an accurate warehouse management system according to the order status of the present invention. Figure 2; "2A" to "2D" is a flow chart showing the method for providing accurate storage management according to the order status of the present invention.

本發明所揭露的依據訂單狀態提供精確倉儲管理系統,其包含:倉儲管理系統20,倉儲管理系統20更包含:商品倉儲資料庫21、接收模組22以及處理模組23。 The warehousing management system 20 includes a warehousing management system 20, a warehousing storage system 21, a receiving module 22, and a processing module 23.

一般來說,會倉儲管理系統20同時管理多個倉庫,每一個倉庫會分不同的區域,每一個區域會具有多個貨架,貨架會具有多個庫位,商品位置即包含有倉庫代碼、庫區代碼、貨架代碼以及庫位代碼…等,在此僅為舉例說明之,並不以此侷限本發明的應用範疇,因此,每一個商品在倉儲管理系統20的商品倉儲資料庫21中所儲存的多筆商品資料,每一筆商品資料包含商品位、商品名稱以及庫位庫存,並依據商品名稱統計庫位庫存為在售庫存(步驟110)。 Generally, the warehouse management system 20 manages multiple warehouses at the same time, each warehouse will be divided into different areas, each area will have multiple shelves, the shelves will have multiple locations, and the commodity location contains the warehouse code and library. The area code, the shelf code, the location code, and the like are merely exemplified herein, and are not intended to limit the scope of application of the present invention. Therefore, each item is stored in the commodity storage database 21 of the warehouse management system 20. A plurality of product materials, each of which includes a product position, a product name, and a location inventory, and the inventory inventory is based on the product name as an inventory (step 110).

接著,倉儲管理系統20的接收模組22是用以接收訂單,訂單包含至少一商品名稱、與商品名稱對應的數量、訂單狀態以及訂單操作(步驟120),並在倉儲管理系統20的接收模組22接收到訂單後,再由倉儲管理系統20的處理模組23依據訂單的訂單狀態以及訂單操作執行下列操作(步驟130):當訂單狀態為付款成功時,商品倉儲資料庫21中在售庫存以及對應的庫位庫存不被變更(步驟1301)。 Next, the receiving module 22 of the warehouse management system 20 is configured to receive an order including at least one product name, a quantity corresponding to the product name, an order status, and an order operation (step 120), and in the receiving mode of the warehouse management system 20. After the group 22 receives the order, the processing module 23 of the warehousing management system 20 performs the following operations according to the order status of the order and the order operation (step 130): when the order status is successful, the commodity warehousing database 21 is for sale. The inventory and the corresponding location inventory are not changed (step 1301).

當訂單狀態為客服審核、當訂單操作為審核操作且當對應商品名稱的在售庫存減去數量為負數時,則訂單未能通過審核,商品倉儲資料庫21中在售庫存以及對應的庫位庫存不被變更(步驟1302)。 When the order status is customer service review, when the order operation is an audit operation, and when the sales inventory minus quantity of the corresponding product name is negative, the order fails to pass the audit, and the inventory in the commodity storage database 21 and the corresponding location The inventory is not changed (step 1302).

當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為售出商品時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存減去數量以更新對應商品名稱的在售庫存(步驟1303)。 When the order status is customer service audit and the order passes the audit and when the order operation is the sold item, the quantity of the corresponding stock in the item warehousing database 21 is deducted according to the item name of the order to update the stocked item of the corresponding item name ( Step 1303).

當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為取消商品時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存增加數量以更新對應商品名稱的在售庫存(步驟1304)。 When the order status is customer service audit and the order passes the audit and when the order operation is canceled, the quantity of the corresponding stock in the goods warehousing database 21 is increased according to the item name of the order to update the stock of the corresponding item name (step 1304). ).

當訂單狀態為客服審核並且訂單通過審核以及當訂單操作為變更商品時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存(步驟1305)。 When the order status is customer service audit and the order is approved, and when the order operation is a change item, the corresponding item name is updated or subtracted according to the item name of the order to update the corresponding stock in the item warehouse database 21 to update the corresponding item name. Inventory (step 1305).

當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為售出商品時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存減去數量以更新對應庫位庫存(步驟1306)。 When the order status is the generated bill of lading or the print order, and when the order operation is the sold item, the quantity of the corresponding stock in the item warehousing database 21 is subtracted according to the item name of the order to update the corresponding item name. The inventory is sold, and the corresponding inventory is updated by subtracting the quantity from the location stock corresponding to the position of the item to which the item name is assigned (step 1306).

當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為取銷商品時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存(步驟1307)。 When the order status is to generate a bill of lading or print a courier and when the order operation is to cancel the merchandise, the quantity of the corresponding stock in the merchandise storage database 21 is increased according to the merchandise name of the order to update the corresponding merchandise name for sale. The inventory is updated according to the location inventory corresponding to the location of the item to which the item name is assigned to update the corresponding location inventory (step 1307).

當訂單狀態為生成撿貨單或是列印快遞單且當訂單操作為變更商品時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存增加或是減去數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加或是減去數量以更新對應庫位庫存(步驟1308)。 When the order status is a bill of lading or a print order, and when the order operation is a change item, the corresponding item is updated or subtracted according to the item name of the order to the corresponding stock in the item storage database 21 to update the corresponding item. The inventory of the name is sold, and the corresponding inventory is updated or subtracted according to the location inventory corresponding to the location of the commodity to which the product name is assigned (step 1308).

當訂單狀態為出庫驗證與秤重時,商品倉儲資料庫21中在售庫存以及對應的庫位庫存不被變更(步驟1309)。 When the order status is the outbound verification and weighing, the in-stock inventory and the corresponding location inventory in the merchandise repository database 21 are not changed (step 1309).

當訂單狀態為配送完成後退貨時,依據訂單的商品名稱對商品倉儲資料庫21中對應的在售庫存增加數量以更新對應商品名稱的在售庫存,並依據被分配商品名稱的商品位置對應的庫位庫存增加數量以更新對應庫位庫存(步驟1310)。 When the order status is returned after the delivery is completed, the quantity of the corresponding stock in the commodity storage database 21 is increased according to the product name of the order to update the stocked inventory of the corresponding product name, and corresponding to the position of the commodity of the assigned product name. The inventory inventory is incremented to update the corresponding location inventory (step 1310).

除此之外,倉儲管理系統20更包含下列模組:生成模組24、顯示模組25、發送模組26以及確認變更模組27。 In addition, the warehouse management system 20 further includes the following modules: a generation module 24, a display module 25, a transmission module 26, and a confirmation change module 27.

倉儲管理系統20的生成模組24是當倉儲管理系統20的處理模組23依據被分配商品名稱的商品位置對應的庫位庫存增加或是減去數量以更新對應庫位庫存時,對應生成第一提示訊息(步驟141),再由倉儲管理系統20的顯示模組25對第一提示訊息進行顯示(步驟142),而第一提示訊息是用以提示操作人員需要將對應商品名稱的商品於商品位置進行取貨或是上架。 The generating module 24 of the warehousing management system 20 is configured when the processing module 23 of the warehousing management system 20 increases or subtracts the corresponding stock position inventory according to the stock position corresponding to the product position of the assigned product name. a prompt message (step 141), and the first prompt message is displayed by the display module 25 of the warehouse management system 20 (step 142), and the first prompt message is used to prompt the operator to need to place the product corresponding to the product name. The goods are picked up or put on shelves.

除此之外,更可透過倉儲管理系統20的發送模組26將第一提示訊息傳送至操作人員所持有的手持式裝置(步驟143),以便於操作人員得知要將對應商品名稱的商品於商品位置進行取貨或是上架。 In addition, the first prompt message can be transmitted to the handheld device held by the operator through the sending module 26 of the warehouse management system 20 (step 143), so that the operator knows that the corresponding product name is to be Goods are picked up at the merchandise location or placed on the shelves.

當操作人員完成對應商品名稱的商品於商品位置進行取貨或是上架後,即可透過手持式裝置或是倉儲管理系統20發出確認指令(步驟151),倉儲管理系統20即可透過確認變更模組27接收到確認指令時,確認更新對應庫位庫存(步驟152),若經過預設時間未接收到確認指令,則表示操作人員未能將對應商品名稱的商品於商品位置進行取貨或是上架,此時再透過倉儲管理系統20的生成模組24生成第二提示訊息(步驟153),再由倉儲管理系統20的 顯示模組25對第二提示訊息進行顯示(步驟154),而第二提示訊息是用以提示操作人員已超過將對應商品名稱的商品於商品位置進行取貨或是上架的確認時間,並再透過倉儲管理系統20的發送模組26將第二提示訊息傳送至操作人員所持有的手持式裝置(步驟155),以提示操作人員已超過將對應商品名稱的商品於商品位置進行取貨或是上架的確認時間,此時倉儲管理系統20的處理模組23即會依據被分配商品名稱的商品位置對應的庫位庫存恢復為未更新前的庫位庫存(步驟155),藉以進一步避免庫位庫存與實際庫位庫存不一致的情況發生。 When the operator completes the pick-up or the shelf of the product corresponding to the product name, the confirmation command can be issued through the handheld device or the warehouse management system 20 (step 151), and the warehouse management system 20 can confirm the change mode. When receiving the confirmation command, the group 27 confirms that the corresponding location inventory is updated (step 152). If the confirmation command is not received after the preset time, the operator fails to pick up the product corresponding to the product name at the product location or After being put on the shelf, the second prompt message is generated by the generating module 24 of the warehouse management system 20 (step 153), and then by the warehouse management system 20 The display module 25 displays the second prompt message (step 154), and the second prompt message is used to prompt the operator to exceed the time when the product corresponding to the product name is picked up or put on the product position, and then The second prompt message is transmitted to the handheld device held by the operator through the sending module 26 of the warehouse management system 20 (step 155), to prompt the operator that the product corresponding to the product name has been picked up at the commodity location or It is the confirmation time of the shelf. At this time, the processing module 23 of the warehouse management system 20 restores the inventory inventory corresponding to the product location of the assigned product name to the inventory inventory before the update (step 155), thereby further avoiding the library. The bit inventory is inconsistent with the actual inventory inventory.

綜上所述,可知本發明與先前技術之間的差異在於本發明依據訂單的訂單狀態以及訂單操作進行倉儲管理系統的商品倉儲資料庫中在售庫存以及庫位庫存計算與更新,藉以提供精確倉儲管理的效用。 In summary, it can be seen that the difference between the present invention and the prior art is that the present invention performs the calculation and update of the inventory and the inventory inventory in the commodity storage database of the warehouse management system according to the order status of the order and the order operation, thereby providing accurate The utility of warehouse management.

藉由此一技術手段可以來解決先前技術所存在依據訂單狀態提供精確倉儲管理的問題,進而達成依據訂單狀態以提供精確倉儲管理的技術功效。 By this technical means, the problem of providing accurate storage management according to the order status of the prior art can be solved, thereby achieving the technical effect of providing accurate storage management according to the order status.

雖然本發明所揭露的實施方式如上,惟所述的內容並非用以直接限定本發明的專利保護範圍。任何本發明所屬技術領域中具有通常知識者,在不脫離本發明所揭露的精神和範圍的前提下,可以在實施的形式上及細節上作些許的更動。本發明的專利保護範圍,仍須以所附的申請專利範圍所界定者為準。 While the embodiments of the present invention have been described above, the above description is not intended to limit the scope of the invention. Any changes in the form and details of the embodiments may be made without departing from the spirit and scope of the invention. The scope of the invention is to be determined by the scope of the appended claims.

20‧‧‧倉儲管理系統 20‧‧‧Warehouse Management System

21‧‧‧商品倉儲資料庫 21‧‧‧Commodity warehousing database

22‧‧‧接收模組 22‧‧‧ receiving module

23‧‧‧處理模組 23‧‧‧Processing module

24‧‧‧生成模組 24‧‧‧Generation Module

25‧‧‧顯示模組 25‧‧‧ display module

26‧‧‧發送模組 26‧‧‧Send module

27‧‧‧變更確認模組 27‧‧‧Change Confirmation Module

Claims (10)

一種依據訂單狀態提供精確倉儲管理系統,其包含:一商品倉儲資料庫,所述商品倉儲資料庫儲存有多筆商品資料,每一筆商品資料包含一商品位置、一商品名稱以及一庫位庫存,並依據所述商品名稱統計所述庫位庫存為一在售庫存;一接收模組,用以接收一訂單,所述訂單包含所述至少一商品名稱、與所述商品名稱對應的一數量、一訂單狀態以及一訂單操作;及一處理模組,所述處理模組用以依據所述訂單的所述訂單狀態以及所述訂單操作執行下列操作:當所述訂單狀態為付款成功時,所述商品倉儲資料庫中所述在售庫存以及對應的所述庫位庫存不被變更;當所述訂單狀態為客服審核、當所述訂單操作為審核操作且當對應所述商品名稱的所述在售庫存減去所述數量為負數時,則所述訂單未能通過審核,所述商品倉儲資料庫中所述在售庫存以及對應的所述庫位庫存不被變更;當所述訂單狀態為客服審核並且所述訂單通過審核以及當所述訂單操作為售出商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存減去所述數量以更新對應所述商品名稱的所述在售庫存;當所述訂單狀態為客服審核並且所述訂單通過審核以及當所述訂單操作為取消商品時,依據所述商品名稱對所述 商品倉儲資料庫中對應的所述在售庫存增加所述數量以更新對應所述商品名稱的所述在售庫存;當所述訂單狀態為客服審核並且所述訂單通過審核以及當所述訂單操作為變更商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加或是減去所述數量以更新對應所述商品名稱的所述在售庫存;當所述訂單狀態為生成撿貨單或是列印快遞單且當所述訂單操作為售出商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存減去所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存減去所述數量以更新對應所述庫位庫存;當所述訂單狀態為生成撿貨單或是列印快遞單且當所述訂單操作為取銷商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加所述數量以更新對應所述庫位庫存;當所述訂單狀態為生成撿貨單或是列印快遞單且當所述訂單操作為變更商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加或是減去所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述 商品名稱的所述商品位置對應的所述庫位庫存增加或是減去所述數量以更新對應所述庫位庫存;當所述訂單狀態為出庫驗證與秤重時,所述商品倉儲資料庫中所述在售庫存以及對應的所述庫位庫存不被變更;及當所述訂單狀態為配送完成後退貨時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加所述數量以更新對應所述庫位庫存。 An accurate warehouse management system is provided according to an order status, comprising: a commodity storage database, wherein the commodity storage database stores a plurality of commodity materials, each commodity data comprising a commodity location, a commodity name, and a inventory inventory. And counting, according to the product name, the inventory inventory is an on-sale inventory; a receiving module, configured to receive an order, the order includes the at least one product name, a quantity corresponding to the product name, An order status and an order operation; and a processing module, the processing module is configured to perform the following operations according to the order status of the order and the order operation: when the order status is payment success, The inventory in the commodity storage database and the corresponding inventory inventory are not changed; when the order status is customer service audit, when the order operation is an audit operation and when the corresponding product name is When the sales inventory minus the quantity is negative, then the order fails to pass the audit, the inventory in the commodity storage database and the The inventory of the inventory is not changed; when the order status is customer service review and the order is approved, and when the order operation is sold, the corresponding product name is corresponding to the commodity storage database. The in-stock inventory minus the quantity to update the in-stock inventory corresponding to the item name; when the order status is customer service review and the order passes the review and when the order operation is canceled goods, According to the product name And increasing the quantity in the corresponding stock in the merchandise storage database to update the in-stock inventory corresponding to the merchandise name; when the order status is customer service audit and the order passes the audit and when the order is operated In order to change the merchandise, the sales amount is increased or subtracted from the corresponding stock in the merchandise storage database according to the merchandise name to update the in-stock inventory corresponding to the merchandise name; The order status is a bill of lading or a print order, and when the order is operated as a merchandise, the quantity is subtracted from the corresponding stock in the merchandise repository according to the merchandise name. Updating the inventories corresponding to the item name, and subtracting the quantity according to the inventory inventory corresponding to the item position to which the item name is assigned to update the corresponding inventory inventory; The order status is a generated bill of lading or a print order, and when the order is operated as a merchandise, the corresponding stock in the merchandise repository is stored according to the merchandise name. Increasing the quantity to update the in-stock inventory corresponding to the item name, and increasing the quantity according to the location inventory corresponding to the item position to which the item name is assigned to update the corresponding inventory inventory And when the order status is generating a bill of lading or printing a courier slip and when the order operation is a change merchandise, increasing the corresponding stock in the merchandise stock database according to the merchandise name or Deducting the quantity to update the in-stock inventory corresponding to the item name, and according to the assigned The inventory inventory corresponding to the commodity position of the commodity name is increased or subtracted to update the corresponding inventory inventory; when the order status is outbound verification and weighing, the commodity storage database The in-stock inventory and the corresponding inventory inventory are not changed; and when the order status is returned after the delivery is completed, the corresponding sales in the commodity storage database are sold according to the product name. The quantity is increased by the inventory to update the in-sale inventory corresponding to the item name, and the quantity is increased according to the location inventory corresponding to the item position to which the item name is assigned to update the corresponding location in stock. 如申請專利範圍第1項所述的依據訂單狀態提供精確倉儲管理系統,其中所述依據訂單狀態提供精確倉儲管理系統更包含一生成模組,用以當所述處理模組依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加或是減去所述數量以更新對應所述庫位庫存時,對應生成一第一提示訊息。 Providing the accurate warehouse management system according to the order status, as described in claim 1, wherein the providing an accurate storage management system according to the order status further includes a generating module, when the processing module is configured according to the When the location inventory corresponding to the commodity location of the product name is increased or subtracted to update the corresponding inventory inventory, a first prompt message is generated correspondingly. 如申請專利範圍第2項所述的依據訂單狀態提供精確倉儲管理系統,其中所述依據訂單狀態提供精確倉儲管理系統更包含一顯示模組,用以顯示所述第一提示訊息。 The accurate warehousing management system is provided according to the order status, as described in claim 2, wherein the accurate warehousing management system according to the order status further includes a display module for displaying the first prompt message. 如申請專利範圍第3項所述的依據訂單狀態提供精確倉儲管理系統,其中所述依據訂單狀態提供精確倉儲管理系統更包含一發送模組,用以發送所述第一提示訊息至一手持式裝置。 The accurate warehousing management system is provided according to the order status, as described in claim 3, wherein the accurate warehousing management system according to the order status further includes a sending module, configured to send the first prompt message to a handheld Device. 如申請專利範圍第4項所述的依據訂單狀態提供精確倉儲管理系統,其中所述依據訂單狀態提供精確倉儲管理系統更包含一確認變更模組,用以接收一確認指令,並依據所述確認指令確認更新對應所述庫位庫存,若經過 預設時間未接收到所述確認指令,則透過所述生成模組生成一第二提示訊息,再由所述顯示模組顯示所述第二提示訊息,以及由所述發送模組發送所述第二提示訊息至所述手持式裝置,並由所述處理模組依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存恢復為未更新前的所述庫位庫存。 Providing the accurate warehouse management system according to the order status as described in claim 4, wherein the providing an accurate storage management system according to the order status further comprises a confirmation change module for receiving a confirmation instruction and confirming according to the confirmation The instruction confirmation update corresponds to the location inventory, if If the confirmation command is not received, the second prompt message is generated by the generating module, and the second prompt message is displayed by the display module, and the sending module sends the And sending, by the processing module, the location inventory corresponding to the commodity location to which the product name is assigned to the location inventory before the update is not updated. 一種依據訂單狀態提供精確倉儲管理的方法,其包含:提供一倉儲管理系統,且所述倉儲管理系統包含一商品倉儲資料庫,所述商品倉儲資料庫儲存有多筆商品資料,每一筆商品資料包含一商品位置、一商品名稱以及一庫位庫存,並依據所述商品名稱統計所述庫位庫存為一在售庫存;所述倉儲管理系統接收一訂單,所述訂單包含所述至少一商品名稱、與所述商品名稱對應的一數量、一訂單狀態以及一訂單操作;所述倉儲管理系統依據所述訂單的所述訂單狀態以及所述訂單操作執行下列操作:當所述訂單狀態為付款成功時,所述商品倉儲資料庫中所述在售庫存以及對應的所述庫位庫存不被變更;當所述訂單狀態為客服審核、當所述訂單操作為審核操作且當對應所述商品名稱的所述在售庫存減去所述數量為負數時,則所述訂單未能通過審核,所述商品倉儲資料庫中所述在售庫存以及對應的所述庫位庫存不被變更;當所述訂單狀態為客服審核並且所述訂單通過審核以及當所述訂單操作為售出商品時,依據所述商品名稱對所述 商品倉儲資料庫中對應的所述在售庫存減去所述數量以更新對應所述商品名稱的所述在售庫存;當所述訂單狀態為客服審核並且所述訂單通過審核以及當所述訂單操作為取消商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加所述數量以更新對應所述商品名稱的所述在售庫存;當所述訂單狀態為客服審核並且所述訂單通過審核以及當所述訂單操作為變更商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加或是減去所述數量以更新對應所述商品名稱的所述在售庫存;當所述訂單狀態為生成檢貨單或是列印快遞單且當所述訂單操作為售出商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存減去所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存減去所述數量以更新對應所述庫位庫存;當所述訂單狀態為生成撿貨單或是列印快遞單且當所述訂單操作為取銷商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加所述數量以更新對應所述庫位庫存; 當所述訂單狀態為生成撿貨單或是列印快遞單且當所述訂單操作為變更商品時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加或是減去所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加或是減去所述數量以更新對應所述庫位庫存;當所述訂單狀態為出庫驗證與秤重時,所述商品倉儲資料庫中所述在售庫存以及對應的所述庫位庫存不被變更;及當所述訂單狀態為配送完成後退貨時,依據所述商品名稱對所述商品倉儲資料庫中對應的所述在售庫存增加所述數量以更新對應所述商品名稱的所述在售庫存,並依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加所述數量以更新對應所述庫位庫存。 A method for providing accurate warehousing management according to an order status, comprising: providing a warehousing management system, wherein the warehousing management system comprises a commodity warehousing database, wherein the commodity warehousing database stores a plurality of commodity materials, each commodity data Include a merchandise location, a merchandise name, and a stock inventory, and according to the merchandise name, the location inventory is an in-stock inventory; the warehouse management system receives an order, the order includes the at least one merchandise a name, a quantity corresponding to the item name, an order status, and an order operation; the warehouse management system performs the following operations according to the order status of the order and the order operation: when the order status is payment Upon successful, the in-stock inventory and the corresponding inventory inventory in the merchandise warehouse database are not changed; when the order status is customer service audit, when the order operation is an audit operation and when the product is corresponding If the said stock in stock is less than the quantity, the order fails to pass the audit, the commodity The inventory in the repository and the corresponding inventory inventory are not changed; when the order status is customer service review and the order passes the review and when the order operation is a sold item, according to the Product name to the stated Retrieving the quantity in the merchandise warehouse database corresponding to the in-stock inventory to update the in-stock inventory corresponding to the merchandise name; when the order status is customer service audit and the order is approved and when the order is When the operation is to cancel the commodity, the quantity is increased according to the commodity name corresponding to the corresponding stock in the commodity storage database to update the in-stock inventory corresponding to the commodity name; when the order status is The customer service audits and the order passes the review and when the order operation is a change of the commodity, the corresponding inventory in the merchandise warehouse database is added or subtracted according to the merchandise name to update the corresponding The in-stock inventory of the product name; when the order status is generating a check-in form or printing a courier slip and when the order operation is a sold item, storing the merchandise data according to the merchandise name Retrieving the quantity in the library corresponding to the in-stock inventory to update the in-stock inventory corresponding to the item name, and according to the item to which the item name is assigned And corresponding to the inventory inventory minus the quantity to update the corresponding inventory inventory; when the order status is generating a bill of lading or printing a courier and when the order operation is to cancel the merchandise, according to The item name adds the quantity to the corresponding stock in the merchandise storage database to update the in-stock inventory corresponding to the item name, and according to the item position to which the item name is assigned Corresponding the inventory of the location increases the quantity to update the inventory corresponding to the location; When the order status is generating a bill of lading or printing a courier slip and when the order operation is a change merchandise, increasing the corresponding stock in the merchandise storage database according to the merchandise name or Subtracting the quantity to update the in-sale inventory corresponding to the product name, and updating or subtracting the quantity according to the location inventory corresponding to the item position to which the item name is assigned to update the corresponding The inventory inventory; when the order status is outbound verification and weighing, the in-stock inventory and the corresponding location inventory in the commodity storage database are not changed; and when the order status is When the return is completed after the delivery is completed, the quantity is increased according to the commodity name corresponding to the corresponding stock in the commodity storage database to update the sold stock corresponding to the commodity name, and according to the assigned The location inventory corresponding to the item location of the product name is increased by the quantity to update the corresponding location inventory. 如申請專利範圍第6項所述的依據訂單狀態提供精確倉儲管理的方法,其中所述依據訂單狀態提供精確倉儲管理的方法更包含當所述倉儲管理系統依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存增加或是減去所述數量以更新對應所述庫位庫存時,對應生成一第一提示訊息。 A method for providing accurate warehousing management according to an order status, as described in claim 6, wherein the method for providing accurate warehousing management according to an order status further comprises when the warehousing management system is configured according to the assigned product name When the location inventory corresponding to the commodity location is increased or subtracted to update the corresponding inventory inventory, a first prompt message is generated correspondingly. 如申請專利範圍第7項所述的依據訂單狀態提供精確倉儲管理的方法,其中所述依據訂單狀態提供精確倉儲管理的方法更包含所述倉儲管理系統顯示所述第一提示訊息的步驟。 The method for providing accurate warehousing management according to an order status, as described in claim 7, wherein the method for providing accurate warehousing management according to an order status further comprises the step of the warehousing management system displaying the first prompt message. 如申請專利範圍第8項所述的依據訂單狀態提供精確倉儲管理的方法,其中所述依據訂單狀態提供精確倉儲管理的方法更包含所述倉儲管理系統發送所述第一提示訊息至一手持式裝置的步驟。 The method for providing accurate warehousing management according to an order status, as described in claim 8, wherein the method for providing accurate warehousing management according to an order status further comprises the warehousing management system transmitting the first prompt message to a handheld The steps of the device. 如申請專利範圍第9項所述的依據訂單狀態提供精確倉儲管理的方法,其中所述依據訂單狀態提供精確倉儲管理的方法更包含下列步驟:所述倉儲管理系統接收一確認指令;所述倉儲管理系統依據所述確認指令確認更新對應所述庫位庫存;若所述倉儲管理系統經過預設時間未接收到所述確認指令,則生成一第二提示訊息;所述倉儲管理系統顯示所述第二提示訊息;及所述倉儲管理系統發送所述第二提示訊息至所述手持式裝置,並且所述倉儲管理系統依據被分配所述商品名稱的所述商品位置對應的所述庫位庫存恢復為未更新前的所述庫位庫存。 The method for providing accurate warehousing management according to an order status, as described in claim 9, wherein the method for providing accurate warehousing management according to an order status further comprises the following steps: the warehousing management system receives a confirmation instruction; the warehousing The management system confirms that the update corresponds to the location inventory according to the confirmation instruction; if the storage management system does not receive the confirmation instruction after a preset time, generating a second prompt message; the warehouse management system displays the a second prompt message; and the warehouse management system sends the second prompt message to the handheld device, and the warehouse management system is in accordance with the location inventory corresponding to the commodity location to which the product name is assigned Revert to the location inventory before the update.
TW104143958A 2015-12-28 2015-12-28 Accurate warehouse management system based on order status and method thereof TWI553567B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW104143958A TWI553567B (en) 2015-12-28 2015-12-28 Accurate warehouse management system based on order status and method thereof

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW104143958A TWI553567B (en) 2015-12-28 2015-12-28 Accurate warehouse management system based on order status and method thereof

Publications (2)

Publication Number Publication Date
TWI553567B true TWI553567B (en) 2016-10-11
TW201723939A TW201723939A (en) 2017-07-01

Family

ID=57848271

Family Applications (1)

Application Number Title Priority Date Filing Date
TW104143958A TWI553567B (en) 2015-12-28 2015-12-28 Accurate warehouse management system based on order status and method thereof

Country Status (1)

Country Link
TW (1) TWI553567B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11954644B2 (en) 2020-08-06 2024-04-09 Coupang Corp. Electronic apparatus for providing picking information of item and method thereof

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102292737A (en) * 2008-11-28 2011-12-21 纽乐金集团 Systems and methods for processing requests for proposals and managing inventory
TW201537492A (en) * 2014-03-24 2015-10-01 Alibaba Group Services Ltd Method and system for processing periodic orders
TWI502373B (en) * 2014-01-09 2015-10-01 Data exchange management system and method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102292737A (en) * 2008-11-28 2011-12-21 纽乐金集团 Systems and methods for processing requests for proposals and managing inventory
TWI502373B (en) * 2014-01-09 2015-10-01 Data exchange management system and method
TW201537492A (en) * 2014-03-24 2015-10-01 Alibaba Group Services Ltd Method and system for processing periodic orders

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11954644B2 (en) 2020-08-06 2024-04-09 Coupang Corp. Electronic apparatus for providing picking information of item and method thereof

Also Published As

Publication number Publication date
TW201723939A (en) 2017-07-01

Similar Documents

Publication Publication Date Title
CN110322186B (en) Data object inventory information processing method, device and system
KR20210055649A (en) Systems and methods for optimization of a product inventory by an intelligent adjustment of inbound purchase orders
US10733552B2 (en) Systems and methods for demand tracking of products based on sales and controlling restocking as a function of the determined demand in a retail environment
CN105931108A (en) Commodity selling system and method based on storage cabinet
KR20160010417A (en) Systems and methods of delivering parcels using attended delivery/pickup locations
KR102354795B1 (en) Systems and methods for automated outbound profile generation
KR102377930B1 (en) Electronic apparatus for managing carrying out on fulfillment center and controlling method thereof
TWI812871B (en) Computer-implemented system and method
KR20220012366A (en) Computer-implemented systems and methods for optimization of a product inventory by intelligent distribution of inbound products
TWI723923B (en) Computer-implemented systems and computer-implemented methods for transferring a return item to fulfillment centers for inventory management
US11263584B2 (en) Demand signal router for demand aware replenishment system
TWI553567B (en) Accurate warehouse management system based on order status and method thereof
KR20190111424A (en) System and method for product history management
US20030023501A1 (en) Vendor-managed inventory method and system
JP2016009329A (en) Merchandise delivery system and merchandise delivery method
JP2004210460A (en) Delivery management system and delivery management method
JP2001184440A (en) Distribution system, article delivery method, and distribution information processing method
US11367046B2 (en) Method and system for tracking inventory
CN113837685A (en) Warehouse-out interception method, warehouse logistics system, order system and readable storage medium
KR20130142216A (en) Packing management method in management system of internet shopping mall
JP4555795B2 (en) A system that supports the inspection of delivered products and inventory at the time of inspection in the distribution industry such as supermarkets using computers.
JP2017207797A (en) Delivery management system, method and computer program
JP7216170B1 (en) Merchandise management device, merchandise management method, and merchandise management program
WO2020236563A1 (en) Autonomous rfid storage system
JP3902161B2 (en) International consolidated logistics system

Legal Events

Date Code Title Description
MM4A Annulment or lapse of patent due to non-payment of fees