1. Mailing Lists
  2. Connectors
  3. Re: Two warehouse in Odoo, 1 magento

Connectors mailing list archives

connectors@odoo-community.org

Browse archives

Add product directly in magento database / synchronization problem

Re: Two warehouse in Odoo, 1 magento

Avatar

Re: Two warehouse in Odoo, 1 magento

by
Hibou Corp., Jared Kipe
- 28/09/2016 19:14:08
Note that you want to add some () to your query.
Without parentheses, location_id=12 will make the whole thing true regardless of product_id.

location_id=12 OR location_id=19 AND product_id=9

SELECT true OR false AND false => true
SELECT (true OR false) AND false => false


Jared Kipe


On Sep 28, 2016, at 5:53 AM, David Hernández <soporte@sinergiainformatica.net> 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



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


Reference