Odoo Help


Initial Stock for POS OpenERP 7.0

on 3/25/13, 10:39 PM 4,238 views


I just try migrate from local POS program to OpenERP 7.0. The product is successfully imported from CSV file. How can I put initial stock qty for my product? In which Warehouse location it should be put on?

Thanks + regards, Johan

Antoine Huvelle
On 3/26/13, 9:19 AM

You could go in Warehouse > Inventory Control > Physical Inventories and create a new inventory. You'll have to add one line per product and specify the stock location.

Of course, once your inventory is created, you can chose to import it.

A v7 Runbot with all DB will give you an example of Starting Inventory at that place.

Thanks Antonie. Since I am newbie, please explain in detail how I can import the initial inventory data from CVS? BTW what is A v7 Runbot? Where is it? Thanks

on 3/27/13, 2:47 AM



| 5 4 7
Baarn, Netherlands
On 3/26/13, 7:36 AM

It can be scripted as well, depending on the amount of work it is for someone to manually add the numbers (and they might change after they have been added....). If you want to scipt it, you need:

a csv-file with the following things:

  • article (name/code/ what ever to uniquely identify it in the DB)
  • amount available
  • location (name/code what ever to uniquely identify location in the DB)

a script which does:

  • read file per line
  • look up the article, store the ID within the DB
  • look up the location, store the ID within the DB
  • in the table 'stock.change.product.qty', add the values: location ID, quantity
  • use the method change_product_qty to get the needed things changed

Code below is using the additional module openerp-client-lib. It is NOT a complete snippet, just something to get you started. If needed, I can give a more detailed answer later.

connection = openerplib.get_connection(hostname=h, database=db, login=u, password=p)

m = 'stock.change.product.qty'

model = connection.get_model(m)

v = {'prodlot_id': False, 'location_id': locID, 'new_quantity': from csv-file}

stockID = model.create(v)

context = {'active_id': id} # id of product!

res = model.change_product_qty([stockID], context)

Please give more detail.

on 4/18/13, 5:00 AM
On 3/25/13, 11:39 PM

I think you must make purchase to increase the qty of the product

I think you are right if I just begin the business with OpenERP. Actually I am migrate from other local made simple POS program, and the retail business is already running with about 800 active items with some stock of them. Any Idea?

on 3/26/13, 12:10 AM

Omal Bastin

--Omal Bastin--

| 6 6 8
Kochi, Kerala, India
--Omal Bastin--

Swiming deep into openERP/ODOO

Omal Bastin
On 3/26/13, 4:34 AM

From the product menu, select your product. There is a tab called 'Inventory' n the form view of product. There you can see a button link called 'Update' which is use to update the quantity available with you. If you have multiple locations then you need to add the group 'manage multiple locations' to the user.

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: 3/25/13, 10:39 PM
Seen: 4238 times
Last updated: 3/16/15, 8:10 AM