Odoo Help


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

on 6/27/15, 7:11 AM 658 views


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


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
On 6/27/15, 8:23 AM


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"


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 6/27/15, 7:11 AM
Seen: 658 times
Last updated: 6/29/15, 8:34 AM