openlabs / magento_integration Goto Github PK

Export the current stock level of each product to magento. This should be done via cron and also available on call of a method in websites.

Magento 1.7, OpenERP7.

When I try to Import Catalog I get the following error: Are there any characters or symbols in the description of products in Magento that need to be avoided? I have some basic HTML formatting in the descriptions.

Client Traceback (most recent call last):
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130620_231038-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_20130620_231038-py2.7.egg/openerp/addons/web/controllers/main.py", line 1129, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130620_231038-py2.7.egg/openerp/addons/web/controllers/main.py", line 1117, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-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_20130620_231038-py2.7.egg/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130620_231038-py2.7.egg/openerp/addons/magento_integration/wizard/import_catalog.py", line 36, in import_catalog
product_ids = self.import_products(cursor, user, website, context)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130620_231038-py2.7.egg/openerp/addons/magento_integration/wizard/import_catalog.py", line 103, in import_products
cursor, user, mag_product['product_id'], context,
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130620_231038-py2.7.egg/openerp/addons/magento_integration/product.py", line 255, in find_or_create_using_magento_id
product_data = product_api.info(magento_id)
File "/opt/bitnami/python/lib/python2.7/site-packages/magento-0.5dev-py2.7.egg/magento/catalog.py", line 265, in info
'catalog_product.info', [product, store_view, attributes]
File "/opt/bitnami/python/lib/python2.7/site-packages/magento-0.5dev-py2.7.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1224, in call
return self.__send(self.__name, args)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1467, in parse_response
p.feed(data)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 557, in feed
self._parser.Parse(data, 0)
ExpatError: not well-formed (invalid token): line 2, column 1246

Currently the connector supports only the default language set on magento for sync.

We should be able to import resources based on languages in multiple store views.

When sales are imported bundle products need to be handled in a different way else the sale total might become double.

I have downloaded pycountry-0.17 from python and run it. copied it and put in my addons folder but i still get the error no module named pycountry.. am so frustrated...please what do i do..someone help me

im trying to import website on creating magento instances. and ive got this error.

OpenERP Server Error
Client Traceback (most recent call last):
File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1132, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/openerp/server/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/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/server/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/openerp/server/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/openerp/server/openerp/addons/magento_integration/wizard/import_websites.py", line 59, in import_websites
mag_websites = core_api.websites()
File "/opt/openerp/server/openerp/addons/magento_integration/api.py", line 25, in websites
return self.call('ol_websites.list', [])
File "/usr/local/lib/python2.6/dist-packages/magento-0.4-py2.6.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in call
return self.__send(self.__name, args)
File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
verbose=self.__verbose
File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
return self._parse_response(h.getfile(), sock)
File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
return u.close()
File "/usr/lib/python2.6/xmlrpclib.py", line 838, in close
raise Fault(**self._stack[0])
Fault: <Fault 2: 'Access denied.'>

Hello,

i have a problem on the magento module side.
The base exception showed in openERP:

  File "/usr/lib/python2.6/xmlrpclib.py", line 838, in close
    raise Fault(**self._stack[0])
Fault: <Fault 4: 'Resource path is not callable.'>

my research showed that it is a problem related to the first API Call

(my overwritten Handler/Abstract.php
DEBUG (7): try to load module: sales/order_api Line 282 in file /var/www/web8/html/app/code/local/Mage/Api/Model/Server/Handler/Abstract.php

From MyDebugging:
013-08-30T19:28:11+00:00 DEBUG (7): try to load module: sales/order_api Line 28
2 in file ...

normal Server Exception:

#0 /var/www/web8/html/app/code/local/Mage/Api/Model/Server/Handler/Abstract.php(
140): Mage_Api_Model_Server_Adapter_Xmlrpc->fault('1', 'Internal Error....')
#1 /var/www/web8/html/app/code/local/Mage/Api/Model/Server/Handler/Abstract.php(
48): Mage_Api_Model_Server_Handler_Abstract->_fault('internal')
#2 /var/www/web8/html/app/code/local/Mage/Api/Model/Server/Handler/Abstract.php(
284): Mage_Api_Model_Server_Handler_Abstract->handlePhpError(4096, 'Object of class...', '/var/www/web8/h...', 284, Array)
#3 [internal function]: Mage_Api_Model_Server_Handler_Abstract->call('0209dda8627a200...', 'sales_order.get...', Array)
#4 /var/www/web8/html/lib/Zend/Server/Abstract.php(232): call_user_func_array(Array, Array)
#5 /var/www/web8/html/lib/Zend/XmlRpc/Server.php(599): Zend_Server_Abstract->_dispatch(Object(Zend_Server_Method_Definition), Array)
#6 /var/www/web8/html/lib/Zend/XmlRpc/Server.php(337): Zend_XmlRpc_Server->_handle(Object(Zend_XmlRpc_Request_Http))
#7 /var/www/web8/html/app/code/local/Mage/Api/Model/Server/Adapter/Xmlrpc.php(113): Zend_XmlRpc_Server->handle()
#8 /var/www/web8/html/app/code/core/Mage/Api/Model/Server.php(138): Mage_Api_Model_Server_Adapter_Xmlrpc->run()
#9 /var/www/web8/html/app/code/core/Mage/Api/controllers/XmlrpcController.php(39): Mage_Api_Model_Server->run()
#10 /var/www/web8/html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Api_XmlrpcController->indexAction()
#11 /var/www/web8/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#12 /var/www/web8/html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /var/www/web8/html/app/co```de/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#14 /var/www/web8/html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#15 /var/www/web8/html/index.php(104): Mage::run('', 'store')
#16 {main} Line 289 in file /var/www/web8/html/app/code/local/Mage/Api/Model/Server/Handler/Abstract.php

I am using

• Magento 1.7.0.2
• Magento Module 1.4.1
• latest OpenERP magento_integration client from github

i get an error "connection time ou"t whenever i import catalog on openerp from magento.
What should i do for this?

Qty is not imported as well as the stock status (all 0 and not in stock) and if you leave the server running it will sync back to magento putting all out of sale

Hi there!

I was testing the Magento integration module and it seems very solid, nice job!

I found that there is no possibility to export products from OpenERP to Magento. This is a recurrent scenario, where a client that is already using OpenERP wants to go online and thus wants an ECommerce platform.

Is possible to export products from OpenERP to Magento?

If not, there are plants to make something like this?

Thanks!

Damián Soriano

i get the following errow whilst installing

Warning: install_lib: build/lib.linux-x86_64-2.7 does not exist..no python mobule to install

what do i do??????

Hi,

Thanks for all the work on this addon / connector. I followed all the steps from https://openerp-magento-connector.readthedocs.org/en/develop/. Alltough i keep getting an error on importing:

OpenERP Server Error
Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1132, in call_button
action = self._call_kw(req, model, method, args, {})
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/usr/lib/pymodules/python2.7/openerp/addons/magento_integration/wizard/import_websites.py", line 49, in import_websites
cursor, user, order_config_api.get_states(), context
File "/usr/lib/pymodules/python2.7/openerp/addons/magento_integration/sale.py", line 101, in create_all_using_magento_data
'openerp_state': default_order_states_map[code],
KeyError: 'processing_payment'

Do you have any idea what could be wrong?

Thanks,

Nick

First of all, great clear work guys 👍 .

started testing the connector, installation went way too smooth.
just installed magento 1.7.0.2, plain instance with no demo data.

Tested connection, successful.
Import website, successful.
Import Carriers / shipping method, success full.

Now came the real test, import of products from magento store.
Created a product and assigned product to a "Default Category".
Tried to import it.
and hit with an error.
Traceback (most recent call last): File "/home/erp/workspace_v7/server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/home/erp/workspace_v7/server/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, *params) File "/home/erp/workspace_v7/server/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/home/erp/workspace_v7/server/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, *args, **kwargs) File "/home/erp/workspace_v7/server/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/home/erp/workspace_v7/server/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/home/erp/workspace_v7/server/openerp/addons/magento_integration/wizard/import_catalog.py", line 36, in import_catalog self.import_category_tree(cursor, user, instance, context) File "/home/erp/workspace_v7/server/openerp/addons/magento_integration/wizard/import_catalog.py", line 61, in import_category_tree category_tree = category_api.tree() File "/usr/local/lib/python2.7/dist-packages/magento-0.5dev-py2.7.egg/magento/catalog.py", line 41, in tree return self.call('catalog_category.tree', [parent_id, store_view]) File "/usr/local/lib/python2.7/dist-packages/magento-0.5dev-py2.7.egg/magento/api.py", line 162, in call return self.client.call(self.session, resource_path, arguments) File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__ return self.__send(self.__name, args) File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request verbose=self.__verbose File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request return self.single_request(host, handler, request_body, verbose) File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request return self.parse_response(response) File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response return u.close() File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close raise Fault(**self._stack[0]) Fault: <Fault 1: 'Internal Error. Please see log for details.'>

Now after my little finding I found that an issue with a call made at
https://github.com/openlabs/magento_integration/blame/develop/wizard/import_catalog.py#L61

Where magento expect either a root category or a store view id / name but hey wait, magento has already that on /app/code/core/Mage/Catalog/Model/Category/Api.php Line number 139. So now what's the cause of an issue !!!

Silly workaround I tried :
category_tree = category_api.tree(1)
and everything seems to be working.

Cheers,
Parthiv

The module Installed and tested connection OK, import sites and catalogs all OK, but when trying to import orders I got this error:

OpenERP Server Error

Client Traceback (most recent call last):
File "/opt/openerp/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/opt/openerp/openerp/addons/web/controllers/main.py", line 1134, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/openerp/addons/web/controllers/main.py", line 1122, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/openerp/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/openerp/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/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/openerp/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/opt/openerp/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *kw)
File "/opt/openerp/openerp/addons/magento_integration/wizard/import_orders.py", line 34, in import_orders
cursor, user, store_view, context
File "/opt/openerp/openerp/addons/magento_integration/magento.py", line 572, in import_orders_from_store_view
order_api.info(order['increment_id']), new_context
File "/opt/openerp/openerp/addons/magento_integration/sale.py", line 179, in find_or_create_using_magento_data
cursor, user, order_data, context
File "/opt/openerp/openerp/addons/magento_integration/sale.py", line 351, in create_using_magento_data
cursor, user, order_data['shipping_address'], partner, context
File "/opt/openerp/openerp/addons/magento_integration/partner.py", line 227, in find_or_create_address_as_partner_using_magento_data
cursor, user, address, address_data
File "/opt/openerp/openerp/addons/magento_integration/partner.py", line 251, in match_address_with_magento_data
[address_data['firstname'], address_data['lastname']]
TypeError: sequence item 1: expected string or Unicode, NoneType found

Is there an easy way to replace any None elements with ""?

Logging into OpenERP with user other than admin results in numerous stack traces relating to ACLs throughout application.

Research indicates a need to create a /security folder containing ir.model.access.csv and associated xml files for setting up model permissions for user groups.

See example stack below when attempting to access a simple product.

2013-07-29 14:58:12,072 23661 WARNING oerpdev openerp.addons.base.ir.ir_model: Access Denied by ACLs for operation: read, uid: 3, model: product.price_tier
2013-07-29 14:58:12,073 23661 ERROR oerpdev openerp.netsvc: Access Denied
Sorry, you are not allowed to access this document. Please contact your system administrator if you think this is an error.

(Document model: product.price_tier)
Traceback (most recent call last):
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 144, in wrapper
raise except_osv(inst.name, inst.value)
except_osv: (u'Access Denied', u'Sorry, you are not allowed to access this document. Please contact your system administrator if you think this is an error.\n\n(Document model: product.price_tier)')
2013-07-29 14:58:12,074 23661 INFO oerpdev werkzeug: 192.168.37.88 - - [29/Jul/2013 14:58:12] "POST /web/dataset/call_kw HTTP/1.1" 200 -

Hi there,

I have installed the connector exactly as per your installation Guide which has actually worked fine. If I try to Test the Connection toward my Magento Store i receive the following error:

OpenERP Server Error
Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1128, in call_kw
return self._call_kw(req, model, method, args, kwargs)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/usr/lib/pymodules/python2.7/openerp/addons/magento_integration/wizard/test_connection.py", line 29, in default_get
self.test_connection(cursor, user, context)
File "/usr/lib/pymodules/python2.7/openerp/addons/magento_integration/wizard/test_connection.py", line 47, in test_connection
with magento.API(
AttributeError: 'module' object has no attribute 'API'

Do you have any Idea why this is not working?

Right now the order status export works only for cancelled orders. This should work with all the states between openerp and magento.

hi
I installed the magento_integration module on openerp7 and I created a new instance .
I also installed Magento core API extension on magento
when I test connexion , an openerp warning appears :
"Incorrect API Settings!Please check and correct the API settings on instance."
I installet magento from http://davidtsadler.com/archives/2012/06/03/how-to-install-magento-on-ubuntu/#php
wait for help!!

Hi!

I’m trying to get the OpenERP Module to work.

I downloaded the zip from github. I extracted it to my OpenERP addons path. I then ran python setup.py install.

I logged in to my OpenERP site. I updated the module list. But I cannot see the module in the list of over 200 modules.

What am I doing wrong?

Please help!

Thanks.

Hi,

How can i copy this addon in my local machine in openerp?

Another error occurs when importing website as follows:

OpenERP Server Error
Client Traceback (most recent call last):
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_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_20130508_231028-py2.7.egg/openerp/addons/web/controllers/main.py", line 1133, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/web/controllers/main.py", line 1121, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 43, 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_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 31, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 104, 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_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 90, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/netsvc.py", line 293, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_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_20130508_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_20130508_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_20130508_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_20130508_231028-py2.7.egg/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *kw)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/magento_integration/wizard/import_websites.py", line 64, in import_websites
cursor, user, instance.id, mag_website, context
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/magento_integration/magento.py", line 207, in find_or_create
}, context=context
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/osv/orm.py", line 4434, 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_20130508_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_20130508_231028-py2.7.egg/openerp/sql_db.py", line 226, in execute
res = self._obj.execute(query, params)
ProgrammingError: column "magento_root_category_id" of relation "magento_instance_website" does not exist
LINE 1: ...ebsite" (id,"instance","code","name","magento_id","magento_r...
^

Ok

Import catalog gives the following error:

OpenERP Server Error
Client Traceback (most recent call last):
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_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_20130508_231028-py2.7.egg/openerp/addons/web/controllers/main.py", line 1133, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/web/controllers/main.py", line 1121, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 43, 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_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 31, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 104, 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_20130508_231028-py2.7.egg/openerp/addons/web/session.py", line 90, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/netsvc.py", line 293, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_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_20130508_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_20130508_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_20130508_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_20130508_231028-py2.7.egg/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/magento_integration/wizard/import_catalog.py", line 37, in import_catalog
product_ids = self.import_products(cursor, user, website, context)
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/magento_integration/wizard/import_catalog.py", line 103, in import_products
cursor, user, mag_product['product_id'], context,
File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20130508_231028-py2.7.egg/openerp/addons/magento_integration/product.py", line 255, in find_or_create_using_magento_id
product_data = product_api.info(magento_id)
File "/opt/bitnami/python/lib/python2.7/site-packages/magento-0.4-py2.7.egg/magento/catalog.py", line 265, in info
'catalog_product.info', [product, store_view, attributes]
File "/opt/bitnami/python/lib/python2.7/site-packages/magento-0.4-py2.7.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1224, in call
return self.__send(self.__name, args)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1467, in parse_response
p.feed(data)
File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 557, in feed
self._parser.Parse(data, 0)
ExpatError: not well-formed (invalid token): line 7, column 10
Ok

im trying to import sale on openerp magento integration.im suing openerpv7 and latest version of magento.

ive got this error message:

"Not Found!

Magento Store Main Website Store should have a shop configured."

is there something i need to configure?

or what?

thanks

Right now the taxation is not handled by the connector. This should be handled and taxes should be imported correctly on sales.

Importing of prices to an ERP from any other system is not recommended.

The design for export is as follows:

magento.website.store

• o2m - magento.store.tier_price

magento.store.tier_price

• store - m2o - magento.website.store - required
• quantity - float - required
• SQL constraint - unique(store, quantity)

product.product

• o2m - product.tier_price

product.tier_price

• product - m2o - required
• quantity - float - required
• price - function
• SQL constraint - unique(product, quantity)

Hey there!

I am trying to make the connection between Magento and OpenERP. I am using Magento 1.7.0.2 and OpenERP 7.0.

I just downloaded the magento-integration and in a fresh environment I installed the module. I configure the "Magento instance" in OpenERP, "Test connection" returns "Test connection with magento successful" but when I click "Import Websites" I got the following exception:

2013-07-15 17:16:26,762 4117 ERROR oerp70_magento_01 openerp.netsvc: 
Traceback (most recent call last):
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/addons/magento-integration/wizard/import_websites.py", line 49, in import_websites
    cursor, user, order_config_api.get_states(), context
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/openerp-7.0-py2.7.egg/openerp/addons/magento-integration/api.py", line 75, in get_states
    return self.call('sales_order.get_order_states', [])
  File "/opt/oerpenv/katrina/test70/default/local/lib/python2.7/site-packages/magento/api.py", line 161, in call
    return self.client.call(self.session, resource_path, arguments)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
    return self.single_request(host, handler, request_body, verbose)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
    return self.parse_response(response)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
    return u.close()
  File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
    raise Fault(**self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>

I think that the problem is in the "sales_order.get_order_states" magento web service. In a python console, if I execute the following code:

from magento.api import API

url = 'http://localhost/magento'
apiuser = '....'
apipass = '....'

with API(url, apiuser, apipass) as order_config_api:
    order_config_api.call('sales_order.get_order_states', [])

I get the following error:

Traceback (most recent call last):
  File "<stdin>", line 2, in <module>
  File "/usr/local/lib/python2.7/dist-packages/magento/api.py", line 161, in call
    return self.client.call(self.session, resource_path, arguments)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
    return self.single_request(host, handler, request_body, verbose)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
    return self.parse_response(response)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
    return u.close()
  File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
    raise Fault(**self._stack[0])
xmlrpclib.Fault: <Fault 3: 'Invalid api path.'>

It looks like the service "sales_order.get_order_states" does not exists, and I try to find it out and I was unable to find it in Magento. Should I install something additional in my Magento instance?

Thanks!

Damián Soriano

How can i adjust the execution time of openerp due to a lot of products to import the process get some error related to max execution time.

what can o do for this?

Add a checkbox on website to allow user to decide if the automatic inventory export has to be performed or not via cron.

This should be False by default

Hello

I have install magento-integration-develop module and did connection with magento it successfully connected but when i click on Import site button it open wizard and i click on continue button it give me error bellow

Traceback (most recent call last):
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 198, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, _kw)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/addons/magento-integration-develop/wizard/import_websites.py", line 58, in import_websites
mag_websites = core_api.websites()
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/addons/magento-integration-develop/api.py", line 27, in websites
return self.call('ol_websites.list', [])
File "/usr/local/lib/python2.7/dist-packages/magento-0.1.5dev-py2.7.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in call
return self.**send(self.__name, args)
File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
return u.close()
File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
raise Fault(_self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>
2013-07-12 05:28:51,256 5626 ERROR openerp_7 openerp.netsvc:
Traceback (most recent call last):
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/netsvc.py", line 295, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/service/web_services.py", line 614, in dispatch
res = fn(db, uid, *params)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 198, in execute
res = self.execute_cr(cr, uid, obj, method, _args, _kw)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, _kw)
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/addons/magento-integration-develop/wizard/import_websites.py", line 58, in import_websites
mag_websites = core_api.websites()
File "/home/jagdish/workspace/openerp-7.0-school_date01_07/openerp/addons/magento-integration-develop/api.py", line 27, in websites
return self.call('ol_websites.list', [])
File "/usr/local/lib/python2.7/dist-packages/magento-0.1.5dev-py2.7.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call
return self.__send(self.__name, args)
File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
return u.close()
File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
raise Fault(**self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>

So please Help

Thanks And regards
Jagdish

I GET THIS ERROR WHEN I TRY TO IMPORT CATALOG
Please define Default Product UOM for website 92trade
PLS HELP

Export tracking information from openerp sale order to magento sale.

When I import orders from Magento the Customer appears 3 times. One time as a Company and two times as a Partner.

Right now the order states map is hardcoded.

This should be a user configurable map with optimal defaults filled in.

Hi,

I did not see a function to sync invoices. Is there any plan to integrate this?

Thanks

Import carriers/shipping methods from magento and save them along with instance

The user should be the able to link each shipping method to a delivery.carrier record in openerp. This will be used for mapping the shipping method while exporting tracking information.

on a brand new installation of openerp it is impossible ther is a mistake on importing websites

with the magento-integration installed today and magento 1.7.0.2

Client Traceback (most recent call last):
File "/opt/openerp/web/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/opt/openerp/web/addons/web/controllers/main.py", line 1132, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/web/addons/web/controllers/main.py", line 1120, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/openerp/web/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/openerp/web/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/web/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/openerp/web/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/openerp/addons/magento-integration/wizard/import_websites.py", line 91, in import_websites
return self.open_websites(cursor, user, ids, instance, context)
File "/opt/openerp/addons/magento-integration/wizard/import_websites.py", line 107, in open_websites
cursor, user, 'magento_integration', 'instance_website_tree_view'
File "/opt/openerp/server/openerp/tools/cache.py", line 18, in lookup
r = self.lookup(self2, cr, *args)
File "/opt/openerp/server/openerp/tools/cache.py", line 46, in lookup
value = d[key] = self.method(self2, cr, *args)
File "/opt/openerp/server/openerp/addons/base/ir/ir_model.py", line 868, in get_object_reference
data_id = self._get_id(cr, uid, module, xml_id)
File "/opt/openerp/server/openerp/tools/cache.py", line 18, in lookup
r = self.lookup(self2, cr, *args)
File "/opt/openerp/server/openerp/tools/cache.py", line 46, in lookup
value = d[key] = self.method(self2, cr, *args)
File "/opt/openerp/server/openerp/addons/base/ir/ir_model.py", line 861, in _get_id
raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
ValueError: No such external ID currently defined in the system: magento_integration.instance_website_tree_view

File "/opt/openerp/web/addons/web/http.py", line 204, in dispatch

I followed instruction of the installation document but i get stuck when updating the module list

File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server\openerp\addons\pycountry__init__.py", line 9, in
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server.\openerp\modules\module.py", line 133, in load_module
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server\openerp\addons\pycountry__init__.py", line 9, in
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server.\openerp\modules\module.py", line 133, in load_module
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server\openerp\addons\pycountry__init__.py", line 9, in
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server.\openerp\modules\module.py", line 133, in load_module
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server\openerp\addons\pycountry__init__.py", line 9, in
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server.\openerp\modules\module.py", line 133, in load_module
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server\openerp\addons\pycountry__init__.py", line 9, in
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server.\openerp\modules\module.py", line 93, in find_module
File "C:\Program Files (x86)\OpenERP 7.0-20130728-231025\Server\server.\openerp\modules\module.py", line 169, in get_module_path
File "ntpath.pyc", line 70, in join
RuntimeError: maximum recursion depth exceeded in cmp

Hi there!

I am using the Magento Integration module and I found something that may be a lacking functionality:

1- Create a product in Magento with name "Product 01".
2- Import it in OpenERP with magento-integration. This creates a "Product 01" product in OpenERP
3- Go to Magento and change name from "Product 01" to "Product 02".
4- Import again products with magento-integration to OpenERP. In OpenERP the product is still called "Product 01" instead of "Product 02".

Bottom line, products don't get updated from Magento to OpenERP, the only flow of information is when the products are first imported and not later.

Are you planning to add this functionality for updating products information after the first Import?

Damián Soriano

Hello everybody,

I believe that the problem on importing/exporting things is related to php memory limit and maybe other things.. but i guess that a good solution would be making a throttle, import or export 20 on 20 items, for example.

Hello,

i've running a new OpenERP 7 database and Magento Comm 1.7.0.0.

The integration is set up fine and working (product import, shipment info, cancel status etc)

but if i want to create an invoice openerp give me an error.
A Database without magento modul does not throw that error.

Error message:

Client Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/http.py", line 203, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1133, in call_button
    action = self._call_kw(req, model, method, args, {})
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1121, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 43, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 293, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/sale/wizard/sale_make_invoice_advance.py", line 170, in create_invoices
    res = sale_obj.manual_invoice(cr, uid, sale_ids, context)
  File "/opt/openerp/server/openerp/addons/sale/sale.py", line 439, in manual_invoice
    wf_service.trg_validate(uid, 'sale.order', id, 'manual_invoice', cr)
  File "/opt/openerp/server/openerp/workflow/wkf_service.py", line 119, in trg_validate
    res2 = instance.validate(cr, id, ident, signal)
  File "/opt/openerp/server/openerp/workflow/instance.py", line 43, in validate
    workitem.process(cr, witem, ident, signal, force_running, stack=stack)
  File "/opt/openerp/server/openerp/workflow/workitem.py", line 60, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/opt/openerp/server/openerp/workflow/workitem.py", line 175, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/opt/openerp/server/openerp/workflow/workitem.py", line 183, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/opt/openerp/server/openerp/workflow/workitem.py", line 40, in create
    process(cr, res, ident, stack=stack)
  File "/opt/openerp/server/openerp/workflow/workitem.py", line 52, in process
    result = _execute(cr, workitem, activity, ident, stack)
  File "/opt/openerp/server/openerp/workflow/workitem.py", line 127, in _execute
    id_new = wkf_expr.execute(cr, ident, workitem, activity)
  File "/opt/openerp/server/openerp/workflow/wkf_expr.py", line 67, in execute
    return _eval_expr(cr, ident, workitem, activity['action'])
  File "/opt/openerp/server/openerp/workflow/wkf_expr.py", line 57, in _eval_expr
    ret = eval(line, env, nocopy=True)
  File "/opt/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/opt/openerp/server/openerp/osv/orm.py", line 374, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/opt/openerp/server/openerp/addons/sale_stock/sale_stock.py", line 192, in action_invoice_create
    res = super(sale_order,self).action_invoice_create( cr, uid, ids, grouped=grouped, states=states, date_invoice = date_invoice, context=context)
  File "/opt/openerp/server/openerp/addons/sale/sale.py", line 540, in action_invoice_create
    res = self._make_invoice(cr, uid, order, il, context=context)
  File "/opt/openerp/server/openerp/addons/sale/sale.py", line 408, in _make_invoice
    inv_id = inv_obj.create(cr, uid, inv, context=context)
  File "/opt/openerp/server/openerp/addons/mail/mail_thread.py", line 242, in create
    thread_id = super(mail_thread, self).create(cr, uid, values, context=context)
  File "/opt/openerp/server/openerp/osv/orm.py", line 4478, in create
    self.pool.get(object)._store_set_values(cr, user, ids, fields2, context)
  File "/opt/openerp/server/openerp/osv/orm.py", line 4627, in _store_set_values
    result = self._columns[f].get(cr, self, ids, f, SUPERUSER_ID, context=context)
  File "/opt/openerp/server/openerp/osv/fields.py", line 1131, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/opt/openerp/server/openerp/osv/fields.py", line 1197, in _fnct_read
    value = value[field] or False
  File "/opt/openerp/server/openerp/osv/orm.py", line 383, in __getitem__
    raise KeyError(error_msg)
KeyError: "Field 'commercial_partner_id' does not exist in object 'browse_record(res.partner, 6)'"

Thank you!

Hi guys,
I'm trying to install this module, but i have some problems:

1. I can only install if i rename the folder to "magento" instead of "magento_integration"
   2.First i couldn't import websites: got an error message, then i re-installed the module, now i get "invalid api"

Im trying to import over 1000 products on openerp from my magento store.
it seems that even i wait for a ton of hours it cannot import my magento catalog.

Is there anything can i do?

I get this error when i try to import catalog:

OpenERP

OpenERP Server Error

Client Traceback (most recent call last):
File "/opt/openerp/7.0/web/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/opt/openerp/7.0/web/addons/web/controllers/main.py", line 1132, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/7.0/web/addons/web/controllers/main.py", line 1120, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/openerp/7.0/web/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/openerp/7.0/web/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/7.0/web/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/openerp/7.0/web/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/7.0/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/7.0/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/7.0/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/openerp/7.0/addons/magento_integration/wizard/import_catalog.py", line 36, in import_catalog
product_ids = self.import_products(cursor, user, website, context)
File "/opt/openerp/7.0/addons/magento_integration/wizard/import_catalog.py", line 93, in import_products
store_view=website.stores[0].store_views[0].magento_id
File "/usr/local/lib/python2.7/dist-packages/magento-0.4-py2.7.egg/magento/catalog.py", line 253, in list
return self.call('catalog_product.list', [filters, store_view])
File "/usr/local/lib/python2.7/dist-packages/magento-0.4-py2.7.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in call
return self.__send(self.__name, args)
File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/usr/lib/python2.7/xmlrpclib.py", line 1467, in parse_response
p.feed(data)
File "/usr/lib/python2.7/xmlrpclib.py", line 557, in feed
self._parser.Parse(data, 0)
ExpatError: junk after document element: line 2, column 0

Import the image of product from magento and use it as the product image on openerp.

Hi. I have installed everything but upon test connection the following error occurs:

Incorrect API Settings!

Please check and correct the API settings on instance.

I use the Magento admin user in API user and API password.

Have port 8888 after IP address/domain name. Still won't connect.

Configurable products in sale orders have a different behaviour and pricing pattern.

This should be handled.

i get the following error when i try to import my website from the magento connector..please help
OpenERP Server Error

Client Traceback (most recent call last):
File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, *_self.params)
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1132, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
return getattr(req.session.model(model), method)(_args, **kwargs)
File "/opt/openerp/server/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/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/server/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/openerp/server/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, _params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr
return fct_src(cr, uid, model, method, _args, *_kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/openerp/server/openerp/addons/magento_integration/wizard/import_websites.py", line 49, in import_websites
cursor, user, order_config_api.get_states(), context
File "/opt/openerp/server/openerp/addons/magento_integration/api.py", line 75, in get_states
return self.call('sales_order.get_order_states', [])
File "/usr/local/lib/python2.7/dist-packages/magento-0.4-py2.7.egg/magento/api.py", line 161, in call
return self.client.call(self.session, resource_path, arguments)
File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in call
return self.__send(self.__name, args)
File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
return u.close()
File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
raise Fault(**self._stack[0])
Fault: <Fault 2: 'Access denied.'>

Right now the orders are imported in all states.

This might not be needed by all the users, hence this should be user configurable.

I success install this addon and import website,store and store view etc successfully.

But when I start to import catalog, it takes very long time like more then half hour for 300 sku website. It will not import any product if I press F5 to refresh the page while it loading.

I also try it on a websit with 4k sku, and wait until the screen show message to recommend me refresh the page. After interrupt the importing after hours, I found no product at all in the website.

The addon will not import any product until it load all products from magento? Is there a way to solve this problem or something wrong in my case?