Am Dienstag, 22. März 2016 14:15:17 UTC+1 schrieb Sergi Almacellas Abellana: > > El 22/03/16 a les 13:46, Raimon Esteve ha escrit: > > 2016-03-22 12:51 GMT+01:00 TPH<truckpart...@gmx.de <javascript:>>: > >> >Hello, > >> > > >> >I just wrote this question in the German group, but I think here are > much > >> >more people. Ill will keep both articles updated. > >> > > >> >What is the best way to get product stock directly from database? > >> > > >> >For a webshop / ebay sync I need the stock for every product of the > >> >warehouse. I have tried this with proteus, but this is not fast > enough. > >> > > >> >So I am searching for an way, to get the actually stock of product on > the > >> >warehouse. > >> > > >> >I think I have to use "stock_location" and "stock_move". Maybe > someone have > >> >already a snipped or can give me some hints. > > > https://bitbucket.org/tryton/stock/src/c9a913139d8da1cac5835362b829d16c0d28602f/product.py?fileviewer=file-view-default#product.py-135 > > > > > It's a method very hard and spend some time depends about > > product/stock moves in your database. > > Or you can simply browse the list of products with the correct keys in > the context: > > location_ids = (list of ids of the locations you want to take in account) > product_ids = (list of products id you want no know the stock) > > with Transaction().set_context(locations=location_ids): > for product in Product.browse(product_ids): > print product.quantity, product.forecast_quantity > > > > > Atention with the context because return some values or others. > This is explained on the docstring of compute_quantities [1] > > And it affects both ways. > > HIH > > [1] > > https://bitbucket.org/tryton/stock/src/c9a913139d8da1cac5835362b829d16c0d28602f/move.py?fileviewer=file-view-default#move.py-878 > > -- > Sergi Almacellas Abellana > www.koolpi.com > Twitter: @pokoli_srk >
Hello I am using Tryton 3.2 and work with proteus. I am not sure but I think there is no Transaction in this proteus version. So I try to get the stock directly from the SQL Database. -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/c548c6b2-a754-4d87-acc3-c0ec2ed06def%40googlegroups.com.