How to transfer Product Quantity from one location to other location?

Question

hi,
How to transfer Product Quantity from one location to other location?
Example.
two location one is stock_1 and 2nd is stock_2
stock_1 qty. is 50.
now i want to transfer stock_1 to stock_2.*database through.*
because, i have 5000 product.

Manually is possible in ERP. but, it's take more time.
any idea form database side.

David Verove · Accepted Answer

Hello,
You have to work with stock_move after searching for location ids in stock_location :
location_1 : select id from stock_location where name = stock_1
location_2  select id from stock_location where name = stock_2
update stock_move set location_id = "location_2" where location_id = "location_1"
Regards,

相關帖文	回覆	瀏覽次數
Storing products in your Location 已解決 inventory stock_location	2 2月 25	2289
How to flag a "Stock Location" as a category? inventory stock_location	1 2月 19	3235
How to change stock location on a warehouse? inventory stock_location	2 10月 18	9785
how to use fields.function to get value from database ? inventory stock_location	1 8月 15	10347
how does each warehouse see only their inventory warehouses inventory stock_location	0 2月 25	3835

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！