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 PDFInfo
- 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
Links
Description
一種倉儲管理系統及其方法,尤其是指一種依據訂單狀態即時審核結果所產生的訂單進而提供精確倉儲管理系統及其方法。 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)
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)
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)
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 |
-
2015
- 2015-12-28 TW TW104143958A patent/TWI553567B/en not_active IP Right Cessation
Patent Citations (3)
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)
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 |