ranjan1101 / magento-openerp-smile-synchro

Automatically exported from code.google.com/p/magento-openerp-smile-synchro
0 stars 0 forks source link

automatic submit of orders from Magento to openerp does not work. #53

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. in magento: admin /configuration / OpenERP Sync.
   seting up opern-erp-server, db /user/pass. enable & enable debug.
2. create a new order in magento, go thur order process and fish
3.

What is the expected output? What do you see instead?

I assume, this feature should be a automatic-realtime-transfer of orders to 
OpenERP.

the order is created in magento, in addition a error is displayed:

Traceback (most recent call last): File 
"/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 256, in 
dispatch result = LocalService(service_name)(method, *params) File 
"/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 76, in 
__call__ return getattr(self, method)(*params) File 
"/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 
577, in execute res = service.execute(db, uid, object, method, *args) File 
"/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 58, in 
wrapper return f(self, dbname, *args, **kwargs) File 
"/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 119, in 
execute res = pool.execute_cr(cr, uid, obj, method, *args, **kw) File 
"/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 111, in 
execute_cr return getattr(object, method)(cr, uid, *args, **kw) File 
"/usr/lib/python2.5/site-packages/openerp-server/addons/magento_openerp_synchro.
zip/magento_openerp_synchro/magento.py", line 68, in createOrders results = 
utils.createOrders(cr, uid, sale_order_array) File 
"/usr/lib/python2.5/site-packages/openerp-server/addons/magento_openerp_synchro.
zip/magento_openerp_synchro/magento_utils.py", line 29, in createOrders 
has_error += self.createOrder(cr, uid, so) File 
"/usr/lib/python2.5/site-packages/openerp-server/addons/magento_openerp_synchro.
zip/magento_openerp_synchro/magento_utils.py", line 118, in createOrder 
shop_id=self.pool.get('sale.shop').search(cr, uid, [('magento_id', '>', 0)]) 
File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 3072, 
in search cr.execute('select %s.id from ' % self._table + ','.join(tables) 
+qu1+' order by '+order_by+limit_str+offset_str, qu2) File 
"/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 78, in 
wrapper return f(self, *args, **kwargs) File 
"/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 123, in 
execute res = self._obj.execute(query, params) ProgrammingError: column 
sale_shop.magento_id does not exist LINE 1: select sale_shop.id from 
"sale_shop" where (sale_shop.magent... ^ 

What version of the product are you using? On what operating system?
OpenERP: 5.0.14 @ Ubuntu 10.4
Magento: 1.4.2.0 @ centos 5.5

Using the 5.0.0.9.9 verison of module, and copyd the magento-code form there to 
magento-server.

Please provide any additional information below.

Its quite confuing that there are now at least 3 differnt connctors with 
similar names are out there.

Original issue reported on code.google.com by zwis...@gmail.com on 1 Jan 2011 at 1:41

GoogleCodeExporter commented 9 years ago
solved.
check out "Comment by mz4wheeler, Jun 03, 2009" on UserManual.

Original comment by zwis...@gmail.com on 3 Jan 2011 at 12:32