No update of stock quantities

[Thomas Klosinsky]

It may be a misconfiguration but the stock quantities are not updated at all.

When importing the products from Magento, there has been no stock update in Odoo and when having stock in Odoo there is no update in Magento, even when running "Update all stock" in the backends configuration.

Any ideas how and where to check what that could be?

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

> When importing the products from Magento, there has been no stock update in Odoo

This is normal. You should create in initial inventory.

> when having stock in Odoo there is no update in Magento, even when running "Update all stock" in the backends configuration.

- Are export jobs created?

Can you try to:
 1. edit a product
 2. in the 'connector' tab, open the binding, see the stock level
 3. change the quantity of the product
 4. open the binding again, click on 'update' next to the stock level: it should be updated
 5. check if a job has been created

[Thomas Klosinsky (tmomas)]

alright.
did that.
now getting this error when clicking on update next to stock level.

OpenERP Server Error

Client Traceback (most recent call last):
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/controllers/main.py", line 1132, in call_button
    action = self._call_kw(req, model, method, args, {})
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/addons/openerp-connector-magento/magentoerpconnect/magento_model.py", line 276, in update_product_stock_qty
    context=context)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/orm.py", line 2356, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/orm.py", line 4860, in _search
    cr.execute...

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

It seems that you did not updated the modules properly.
Retry with --update=all or --update=base (or --update=magentoerpconnect
if only this module need updates)

[Thomas Klosinsky (tmomas)]

Problem is, that Odoo doesn't show modules to update anymore.

Error on every product import:

Traceback (most recent call last): File
"/opt/openerp/addons/openerp-connector/connector/queue/worker.py", line
122, in run_job job.perform(session) File
"/opt/openerp/addons/openerp-connector/connector/queue/job.py", line
485, in perform self.result = self.func(session, *self.args,
**self.kwargs) File
"/opt/openerp/addons/openerp-connector-magento/magentoerpconnect/unit/import_synchronizer.py",
line 373, in import_record importer.run(magento_id, force=force) File
"/opt/openerp/addons/openerp-connector-magento/magentoerpconnect/unit/import_synchronizer.py",
line 225, in run binding_id = self._create(record) File
"/opt/openerp/addons/openerp-connector-magento/magentoerpconnect/product.py",
line 391, in _create openerp_binding_id = super(ProductImport,
self)._create(data) File
"/opt/openerp/addons/openerp-connector-magento/magentoerpconnect/unit/import_synchronizer.py",
line 172, in _create binding_id = self.session.create(self.model._name,
data) File "/opt/openerp/addons/openerp-connector/connector/session.py",
line 175, in create return self.pool[model].create(self.cr, self.uid,
values, context=self.context) File
"/opt/openerp/addons/openerp-connector/connector/producer.py", line 42,
in create record_id = create_original(self, cr, uid, vals,
context=context) File
"/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/osv/orm.py",
line 4436, in create cr.execute('insert into "'+self._table+'"
(id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File
"/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/sql_db.py",
line 161, in wrapper return f(self, *args, **kwargs) File
"/opt/bitnami/apps/openerp/lib/openerp-7.0_20130922_231028-py2.7.egg/openerp/sql_db.py",
line 226, in execute res = self._obj.execute(query, params)
ProgrammingError: column "no_stock_sync" of relation
"magento_product_product" does not exist LINE 1:
...ed_at","backorders","manage_stock","product_type","no_stock_... ^

:(
Also with every module updated on server restart...

Am 25.06.14 13:02, schrieb Guewen Baconnier @ Camptocamp:
> It seems that you did not updated the modules properly.
> Retry with --update=all or --update=base (or --update=magentoerpconnect
> if only this module need updates)
>

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

On Wed, Jun 25, 2014 at 9:20 PM, Thomas Klosinsky
<email address hidden> wrote:
> Problem is, that Odoo doesn't show modules to update anymore.
>

I don't get what you mean.

Use the command line as I proposed before, or go to Settings >
Installed modules, and from there, search the 'base' module and click
on Update (always do a backup before).

[Thomas Klosinsky (tmomas)]

Problem is gone overnight...

Don't understand those phenomenons...

[Thomas Klosinsky (tmomas)]

Ah. not yet gone.

The error is gone. but the inventory export job is still in the row.
Will take some time since there are 2k jobs to be done before. I'll post the result later on.

[Thomas Klosinsky (tmomas)]

works like a charm.
Thanks for your help again!