Connectors mailing list archives
connectors@odoo-community.org
Browse archives
Re: Two warehouse in Odoo, 1 magento
by
Opener B.V., Stefan Rijnhart
On 09/28/2016 02:53 PM, David Hernández wrote: > OK, i'll try. > > In V8 i have to look at qty column in stock_quant table to do that no? > > I have to do for each product_id in lines, sum qty for my two locations ? > > In sql something like : > > SELECT sum(qty) from stock_quant WHERE location_id=12 OR location_id=19 > AND product_id=9 Try browsing your products with both the warehouses in the context to retrieve the quantity fields with the appropriate quantities. Code your custom field to proxy the field of your choice. https://github.com/odoo/odoo/blob/8.0/addons/stock/product.py#L88 Regards, Stefan. > > > > El 27/09/16 a les 20:22, Stefan Rijnhart ha escrit: > > On 09/27/2016 03:38 PM, David Hernández wrote: > > > Hi, in the configuration of the connector I can select one of my > > > warehouse and later a field that represents my stock. > > > > > > I want to send the stock from (warehouse 1 + warehouse 2) > > > ----------->Magento qty > > > > > > Can I create new field that sum stock from warehouse 1 + warehouse 2) > > > and configure the connector to use this field as stock qty to sync? > > > > > > > Yes, you can. The Magento connector configuration allows you to select a > > custom field to push to Magento as the current stock. > > > > Regards, > > Stefan. > > > > _______________________________________________ > > Mailing-List: http://odoo-community.org/groups/connectors-30 > > Post to: mailto:connectors@odoo-community.org > > Unsubscribe: http://odoo-community.org/groups?unsubscribe > > > > -- > Serveis Informàtics a Pimes i Particulars > - Manteniment de xarxes i servidors > - Reinstal·lacions de sistemes > - Desinfecció de virus > - Instal·lació de Linux > - Implementació d'Odoo (Gestió empresa) > > http://sinergiainformatica.net > > Telf: 659 522 073 > > _______________________________________________ > Mailing-List: http://odoo-community.org/groups/connectors-30 > Post to: mailto:connectors@odoo-community.org > Unsubscribe: http://odoo-community.org/groups?unsubscribe >
