oca / connector-magento Goto Github PK
View Code? Open in Web Editor NEWConnect Odoo with Magento
Home Page: http://odoo-magento-connector.com/
License: GNU Affero General Public License v3.0
Connect Odoo with Magento
Home Page: http://odoo-magento-connector.com/
License: GNU Affero General Public License v3.0
Hello,
I installed magento connector and it was working fine but unfortunatly my customer update it connector module from Apps Menu ,
I update all the connectoer's addons also tried to create new database but still getting the same issue and also job is not geting to execute
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 296, 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 190, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 132, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 199, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/model.py", line 393, in requeue
self.pool.get('queue.job').requeue(cr, uid, job_ids, context=context)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/model.py", line 127, in requeue
self._change_job_state(cr, uid, ids, PENDING, context=context)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/model.py", line 110, in _change_job_state
job = storage.load(job.uuid)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/job.py", line 246, in load
func = _unpickle(str(stored.func))
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/job.py", line 71, in _unpickle
raise NotReadableJobError('Could not unpickle.', pickled)
NotReadableJobError: ('Could not unpickle.', 'False')
For avoiding this error i also follow some patched which is provided by other's contributor
https://code.launchpad.net/~camptocamp/openerp-connector/7.0-unicode-pickled-1288187/+merge/209481
also follow this
https://code.launchpad.net/~acsone-openerp/openerp-connector/bug-1288187-sbi-unicode/+merge/209430
please any one can help me
Hello,
I installed magento connector and it was working fine but unfortunatly my customer update it connector module from Apps Menu ,
Now i am getting no handler error but when i go back and look my log file then i got the 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 296, 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 190, in execute_kw
return self.execute(db, uid, obj, method, *args, *_kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 132, in wrapper
return f(self, dbname, _args, *_kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 199, in execute
res = self.execute_cr(cr, uid, obj, method, _args, *_kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
return getattr(object, method)(cr, uid, _args, *_kw)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/model.py", line 393, in requeue
self.pool.get('queue.job').requeue(cr, uid, job_ids, context=context)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/model.py", line 127, in requeue
self._change_job_state(cr, uid, ids, PENDING, context=context)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/model.py", line 110, in _change_job_state
job = storage.load(job.uuid)
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/job.py", line 246, in load
func = _unpickle(str(stored.func))
File "/opt/openerp/magento_addons/openerp-connector/connector/queue/job.py", line 71, in _unpickle
raise NotReadableJobError('Could not unpickle.', pickled)
NotReadableJobError: ('Could not unpickle.', 'False')
For avoiding this error i also follow some patched which is provided by other's contributor
https://code.launchpad.net/~camptocamp/openerp-connector/7.0-unicode-pickled-1288187/+merge/209481
also follow this
https://code.launchpad.net/~acsone-openerp/openerp-connector/bug-1288187-sbi-unicode/+merge/209430
please any one can help me
Hi,
I just stumbled across an issue with fixed amount discounts in Magento. For example, I have an order with one product in Magento: 85€ sales price incl. tax, 75€ voucher which results in a 10€ total. In Odoo this orders was translated into the following: 104.998% discount and a total of -4,25€. The problem here is that Odoo takes the 75€ voucher from the net price(71.43€) and not the gross price (85€).
Is there a setting that can fix that - if not I would like to file a bug.
Thanks,
Michael
hi guys,
when I want to enable the pricing management in odoo at the connector settings, I get the following error:
Odoo Server Error
Traceback (most recent call last):
File "/home/odoo/src/odoo/8.0/openerp/http.py", line 536, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/home/odoo/src/odoo/8.0/openerp/http.py", line 573, in dispatch
result = self._call_function(*_self.params)
File "/home/odoo/src/odoo/8.0/openerp/http.py", line 309, in _call_function
return checked_call(self.db, *args, *_kwargs)
File "/home/odoo/src/odoo/8.0/openerp/service/model.py", line 113, in wrapper
return f(dbname, _args, *_kwargs)
File "/home/odoo/src/odoo/8.0/openerp/http.py", line 306, in checked_call
return self.endpoint(_a, *_kw)
File "/home/odoo/src/odoo/8.0/openerp/http.py", line 802, in call
return self.method(_args, *_kw)
File "/home/odoo/src/odoo/8.0/openerp/http.py", line 402, in response_wrap
response = f(_args, *_kw)
File "/home/odoo/src/custom/private/loempia/controllers/embed.py", line 49, in download_urls
mods_to_install = Modules.compute_modules_to_install(series, module_names, local_modules)
File "/home/odoo/src/odoo/8.0/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/home/odoo/src/custom/private/loempia/loempia2.py", line 959, in compute_modules_to_install
assert len(mids) == len(set(requested_mods)), 'Unknown modules requested: %r' % requested_mods
AssertionError: Unknown modules requested: ['magentoerpconnect_pricing']
How can I install that?
Thanks,
Michael
Description of the mechanism to import orders with verification of the payment
Description of the problem
The postponing is done by setting an ETA in the job to 10 minutes later. Jobs are processed in the order of the ETA.
If the processing time of the queue of jobs pending for a payment is larger than 10 minutes, the first jobs to be processed will be postponed before the last jobs could be processed.
Proposition for correction
Instead of postponing the jobs 10 minutes later, postpone them to max(eta)
so the queue will loop completely. Still, recent sales orders needs to be verified more often, because they have more chance to receive a payment than some days old orders.
So I propose to support a retry pattern like the following:
Retry count (until) | Postpone minutes |
---|---|
3 | 10 |
6 | 20 |
50 | 30 |
infinite | max(eta) |
It would be represented as a dict
with the count as keys and the postponing as values in seconds or a constant symbolizing that it should be max(eta)
.
When a retry pattern is not provided, it fallbacks to the current constant of 10 minutes.
The retry pattern is configured on the @job
.
This needs to be implemented in https://github.com/OCA/connector
Tested on Odoo 7.0 and Magento 1.7.0.0 (with SAMPLE_DATA)
Synchronization works well, the import of res.partner.category works, except for categories with a compound name (eg "TEST GROUP")
I get the following traceback:
Traceback (most recent call last):
File "/home/clovis/Documents/test/connector/connector/queue/worker.py", line 122, in run_job
job.perform(session)
File "/home/clovis/Documents/test/connector/connector/queue/job.py", line 491, in perform
self.result = self.func(session, *self.args, **self.kwargs)
File "/home/clovis/Documents/test/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 378, in import_record
importer.run(magento_id, force=force)
File "/home/clovis/Documents/test/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 232, in run
self.binder.bind(self.magento_id, binding_id)
File "/home/clovis/Documents/test/connector-magento/magentoerpconnect/unit/binder.py", line 125, in bind
"got: %s, %s" % (external_id, binding_id)
AssertionError: external_id or binding_id missing, got: 0, 17
Hello,
I have successfully installed the connector, imported partners, product categories & products. The issue I am having is that all the products are imported to root category or All Products rather than in their respective categories.
Also, in POS, products appear in other category.
I am using Magento 1.8.1
Can anyone please help me with this as I have too many products?
Thank you.
hi guys,
all our products in Magento are configurable products with associated simple products. When I sync them to Odoo, I just get all the simple products. Why are they not grouped correctly with Variants? In your documentation you specified that you support simple and configurable products: "But, as of today, only simple and configurable products are supported."
thanks,
michael
It appears that Magento can have different settings for each storeview with regards whether tax is included in the price or not, which is a situation the connector cannot handle at the moment. Not sure if there is a way to find out what the setting is from magento through the API.
Proposed solution: add a checkbox (and a migration script to move the backend setting there) or a tri-state field (included/excluded/inherit from backend) on the storeview and update the code in SO import to check that instead.
What do you think?
In the documentation it is written :
Important
Please check if you have installed Magento on PHP with a 5.4.x* version.
Magento is not compatible with this version and would prevent the API to behave normally.
In that case, you must retrograde to PHP 5.3.x or apply the patch provided by Magento (see http://magento.com/resources/system-requirements)
http://magento.com/resources/system-requirements tells something different. Is the doc obsolete or is there an other subtlety?
With the latest version of the connector with Magento 1.7.0.2 with php 5.4 and OpenERP v7 :
For the task : openerp.addons.magentoerpconnect.unit.import_synchronizer.import_batch('magento.product.category', 1, filters={'from_date': datetime.datetime(2014, 12, 2, 19, 43, 11)})
I get this error message :
Traceback (most recent call last):
File "/opt/openerp7/git/connector/connector/queue/worker.py", line 122, in run_job job.perform(session)
File "/opt/openerp7/git/connector/connector/queue/job.py", line 490, in perform self.result = self.func(session, *self.args, **self.kwargs)
File "/opt/openerp7/git/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 369, in import_batch importer.run(filters=filters)
File "/opt/openerp7/git/connector-magento/magentoerpconnect/product_category.py", line 184, in run tree = self.backend_adapter.tree()
File "/opt/openerp7/git/connector-magento/magentoerpconnect/product_category.py", line 146, in tree [parent_id, storeview_id])
File "/opt/openerp7/git/connector-magento/magentoerpconnect/product_category.py", line 96, in _call return super(ProductCategoryAdapter, self)._call(method, arguments)
File "/opt/openerp7/git/connector-magento/magentoerpconnect/unit/backend_adapter.py", line 156, in _call result = api.call(method, arguments)
File "/opt/openerp7/git/openerp/tools/eggs/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 1: 'Internal Error. Please see log for details.'>
Dear developer,
Thank you for developing an import extension for magento to Odoo.
Currently I have succeded to import the customer/categories and products into Odoo from magento. Unfortunetly I have some problems with importing sale orders.
I hope you can provide me with a solution for this problem.
Thank you in advance,
Michiel
The following error appears:
MissingError: ('MissingError', u'One of the documents you are trying to access has been deleted, please try again after refreshing.')
More traceback information:
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/connector/queue/worker.py", line 127, in run_job
with session_hdl.session() as session:
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/connector/queue/job.py", line 492, in perform
descr = (self._description or
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/magentoerpconnect/unit/import_synchronizer.py", line 378, in import_record
importer.run(magento_id, force=force)
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/magentoerpconnect/unit/import_synchronizer.py", line 229, in run
record = self._create_data(map_record)
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/magentoerpconnect/sale.py", line 826, in _create_data
*_kwargs)
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/magentoerpconnect/unit/import_synchronizer.py", line 170, in _create_data
return map_record.values(for_create=True, *_kwargs)
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/connector/unit/mapper.py", line 910, in values
def getattr(self, key):
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/connector/unit/mapper.py", line 643, in _apply
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/connector/unit/mapper.py", line 701, in _apply_with_options
'mapping method %s' % (values, meth))
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/magentoerpconnect/sale.py", line 929, in finalize
values = self._add_shipping_line(map_record, values)
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/magentoerpconnect/sale.py", line 895, in _add_shipping_line
line = (0, 0, line_builder.get_line())
File "/usr/lib/python2.7/site-packages/openerp/addons/magento/magento-connector-v8/connector_ecommerce/sale.py", line 490, in get_line
'name': product.name,
File "/usr/lib/python2.7/site-packages/openerp/fields.py", line 823, in get
return record._cache[self]
File "/usr/lib/python2.7/site-packages/openerp/models.py", line 5913, in getitem
return value.get() if isinstance(value, SpecialValue) else value
File "/usr/lib/python2.7/site-packages/openerp/fields.py", line 55, in get
raise self.exception
Hi, all
For odoo 8.0 there didn't have sale shop model again, user can set warehouse and pricelist directly on sale order. connector for odoo v7 we use the sale shop as a bridge between sale order and magento store.
for odoo 8.0 what should do for this relationship. I'm pleasure to listen your opinions.
Best Regards
I tried out magento buildout from @guewen and i can't get orders into odoo from magento
Importing Partner Categories, Product Categories and Products works fine, but not for orders.
I see that some order imports are in queue and will be processed, but no sale orders available.
What is the cause? What do i miss?
I checked out http://odoo-magento-connector.com/guides/installation_guide.html#installation but can't find why it does not import orders...
Thanks for answer
when you have an existing magento and an existing odoo
when you do a first sync it recreate all products
no matching on SKU
What about wrap this with try except and give a nice message?
To avoid errors like this:
#122
More info here:
OCA/maintainer-quality-tools#157 (comment)
2014-08-29 17:06:22,505 8192 CRITICAL ? openerp.modules.module: Couldn't load module web
2014-08-29 17:06:22,506 8192 CRITICAL ? openerp.modules.module: cannot import name related_action
2014-08-29 17:06:22,506 8192 ERROR ? openerp.service: Failed to load server-wide module web
.
The web
module is provided by the addons found in the openerp-web
project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File "/www/openerp/openerp/odoo/openerp/service/init.py", line 60, in load_server_wide_modules
openerp.modules.module.load_openerp_module(m)
File "/www/openerp/openerp/odoo/openerp/modules/module.py", line 415, in load_openerp_module
getattr(sys.modules['openerp.addons.' + module_name], info['post_load'])()
File "/www/openerp/openerp/odoo/addons/web/http.py", line 628, in wsgi_postload
openerp.wsgi.register_wsgi_handler(Root())
File "/www/openerp/openerp/odoo/addons/web/http.py", line 517, in init
self.load_addons()
File "/www/openerp/openerp/odoo/addons/web/http.py", line 580, in load_addons
m = import('openerp.addons.' + module)
File "/www/openerp/openerp/odoo/openerp/modules/module.py", line 133, in load_module
mod = imp.load_module('openerp.addons.' + module_part, f, path, descr)
File "/www/openerp/openerp/odoo/oca_connector/connector-magento/magentoerpconnect/init.py", line 6, in
import magento_model
File "/www/openerp/openerp/odoo/oca_connector/connector-magento/magentoerpconnect/magento_model.py", line 34, in
from .unit.backend_adapter import GenericAdapter
File "/www/openerp/openerp/odoo/oca_connector/connector-magento/magentoerpconnect/unit/init.py", line 5, in
import import_synchronizer
File "/www/openerp/openerp/odoo/oca_connector/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 26, in
from openerp.addons.connector.queue.job import job, related_action
ImportError: cannot import name related_action
hi guys,
I successfully imported everything from your tutorial till the orders. All orders are failing in the import with the following error:
Traceback (most recent call last):
File "/opt/openerp-custom/addons/connector/connector/queue/worker.py", line 124, in run_job
job.perform(session)
File "/opt/openerp-custom/addons/connector/connector/queue/job.py", line 466, in perform
self.result = self.func(session, _self.args, *_self.kwargs)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 379, in import_record
importer.run(magento_id, force=force)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 225, in run
self._after_import(binding)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/sale.py", line 727, in _after_import
self._create_payment(binding)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/sale.py", line 691, in _create_payment
binding.openerp_id.automatic_payment(amount)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/opt/openerp-custom/addons/e-commerce/sale_payment_method/sale.py", line 107, in automatic_payment
self._add_payment(journal, amount, date)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/opt/openerp-custom/addons/e-commerce/sale_payment_method/sale.py", line 136, in _add_payment
move_model.create(move_vals)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 462, in new_api
result = method(self._model, cr, uid, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account.py", line 1402, in create
result = super(account_move, self).create(cr, uid, vals, c)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 336, in old_api
result = method(recs, _args, *_kwargs)
File "/opt/openerp-custom/addons/connector/connector/producer.py", line 48, in create
record_id = create_original(self, vals)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4074, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 462, in new_api
result = method(self._model, cr, uid, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4259, in _create
result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
File "/usr/lib/python2.7/dist-packages/openerp/osv/fields.py", line 811, in set
id_new = obj.create(cr, user, act[2], context=context)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account_move_line.py", line 1282, in create
if ('account_id' in vals) and not account_obj.read(cr, uid, [vals['account_id']], ['active'])[0]['active']:
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3139, in read
result = BaseModel.read(records, fields, load=load)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3174, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3386, in _read_from_database
forbidden = missing.exists()
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4860, in exists
self._cr.execute(query, [tuple(ids)])
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper
return f(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: SELECT id FROM "account_account" WHERE id IN (false)
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Do you have an idea whats going on here?
Thanks,
Michael
Hello,
After updated Magento 1.9.2.1 the import controls work fine but when I look at the purchase order or clients I have nothing imported.
I do not have to display bug.
Nothing in the logs.
My oddo logs
2015-08-27 14:16:22,359 4191 INFO Autoslide openerp.addons.magentoerpconnect.sale: search for magento saleorders {'created_at': {'to': '2015/08/27 14:15:23', 'from': '2015/08/27 13:47:55'}, 'store_id': {'in': [u'0']}, 'state': {'neq': 'canceled'}} returned []
2015-08-27 14:16:23,834 4191 INFO Autoslide openerp.addons.magentoerpconnect.product: search for magento products {'updated_at': {'to': '2015/08/27 14:15:22', 'from': '2015/08/27 13:47:54'}} returned []
My apache log
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 847 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 887 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 818 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 848 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 891 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 818 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 847 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 821 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
autoslide.fr:80 92.222.7.206 - - [27/Aug/2015:16:16:23 +0200] "POST /index.php/api/xmlrpc HTTP/1.1" 200 818 "-" "xmlrpclib.py/1.0.1 (by www.pythonware.com)"
Any help please.
Regards
Hi, team:
when I import partner.category I find when the search result customer_group_id is 0 the job is failed. then I check the code, I find in when I bind the magento_id with binder_id the code has a assert sentence in the magentoerpconnect module binder file line 123:
assert external_id and binding_id, (
"external_id or binding_id missing, "
"got: %s, %s" % (external_id, binding_id)
)
then the external_id value is 0 and this sentence is not passed.
I think maybe this is a bug for every object import to OE when the magento_id is zero.
While import sale order from Magento to Odoo, always default product "[SHIP]" is set inside shipping line of that order. Even though we have specified product inside carrier method of that order.
System is not going to getting correct product from selected carrier method of that order instead of system always taking default service product which have external id "connector_ecommerce.product_product_shipping".
We have been tested with Odoo V8. Also getting it inside OpenERP V7.
Hello,
I have an Odoo 7 installation in a Debian 7 host, I have some addons installed: http://odoo-magento-connector.com/guides/installation_guide.html
$ bzr branch lp:openerp-connector/7.0 /opt/openerp-connector
$ bzr branch lp:openerp-connector-ecommerce/7.0 /opt/openerp-connector-ecommerce
$ bzr branch lp:openerp-connector-magento/7.0 /opt/openerp-connector-magento
$ bzr branch lp:e-commerce-addons/7.0 /opt/e-commerce-addons
$ bzr branch lp:openerp-product-attributes/7.0 /opt/openerp-product-attributes
$ bzr branch lp:sale-wkfl/7.0 /opt/sale-wkfl
My /etc/openerp/openerp-server.conf is like this:
[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = False
db_port = False
db_user = openerp
db_password = False
addons_path = /opt/openerp-connector,/opt/openerp-connector-ecommerce,/opt/openerp-connector-magento,/opt/e-commerce-addons,/opt/openerp-product-attributes,/opt/sale-wkfl
When I updated to the last version of Odoo 7 (openerp_7.0-20141011-011008.deb):
apt-get update && apt-get upgrade
I got this:
root@OpenERP:~# sudo -u openerp openerp-server --config=/etc/openerp/openerp-server.conf --update=all
2014-10-11 17:20:12,474 2569 INFO ? openerp: OpenERP version 7.0-b42ae34
2014-10-11 17:20:12,475 2569 INFO ? openerp: addons paths: /opt/openerp-connector,/opt/openerp-connector-ecommerce,/opt/openerp-connector-magento,/opt/e-commerce-addons,/opt/openerp-product-attributes,/opt/sale-wkfl
2014-10-11 17:20:12,475 2569 INFO ? openerp: database hostname: localhost
2014-10-11 17:20:12,475 2569 INFO ? openerp: database port: 5432
2014-10-11 17:20:12,475 2569 INFO ? openerp: database user: openerp
2014-10-11 17:20:12,697 2569 CRITICAL ? openerp.modules.module: Couldn't load module web
2014-10-11 17:20:12,698 2569 CRITICAL ? openerp.modules.module: No module named magento
2014-10-11 17:20:12,698 2569 ERROR ? openerp.service: Failed to load server-wide module web.
The web module is provided by the addons found in the openerp-web project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File "/usr/lib/python2.6/dist-packages/openerp/service/init.py", line 60, in load_server_wide_modules
openerp.modules.module.load_openerp_module(m)
File "/usr/lib/python2.6/dist-packages/openerp/modules/module.py", line 415, in load_openerp_module
getattr(sys.modules['openerp.addons.' + module_name], info['post_load'])()
File "/usr/lib/python2.6/dist-packages/openerp/addons/web/http.py", line 628, in wsgi_postload
openerp.wsgi.register_wsgi_handler(Root())
File "/usr/lib/python2.6/dist-packages/openerp/addons/web/http.py", line 517, in init
self.load_addons()
File "/usr/lib/python2.6/dist-packages/openerp/addons/web/http.py", line 580, in load_addons
m = import('openerp.addons.' + module)
File "/usr/lib/python2.6/dist-packages/openerp/modules/module.py", line 133, in load_module
mod = imp.load_module('openerp.addons.' + module_part, f, path, descr)
File "/opt/openerp-connector-magento/magentoerpconnect/init.py", line 6, in
import magento_model
File "/opt/openerp-connector-magento/magentoerpconnect/magento_model.py", line 34, in
from .unit.backend_adapter import GenericAdapter
File "/opt/openerp-connector-magento/magentoerpconnect/unit/init.py", line 5, in
import import_synchronizer
File "/opt/openerp-connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 32, in
from ..related_action import link
File "/opt/openerp-connector-magento/magentoerpconnect/related_action.py", line 35, in
from .unit.backend_adapter import GenericAdapter
File "/opt/openerp-connector-magento/magentoerpconnect/unit/backend_adapter.py", line 26, in
import magento as magentolib
ImportError: No module named magento
2014-10-11 17:20:12,710 2569 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069
2014-10-11 17:20:12,710 2569 INFO ? openerp: OpenERP server is running, waiting for connections...
And if I open the web page: http://127.0.0.1:8069, I can only see "no handler found"
When I update Models List,Odoo 8 show me the error:No model named openerp?
Hi,
I'm not sure if this is a configuration issue or a real issue. I configured the "Prices include tax" setting to Yes, as our prices in Magento are already with tax. When I import the sales orders now from Magento, Odoo is calculating 19%VAT on top of the price of the product which already includes VAT (eg. product price is 69€ incl. tax, sales order with this product total is 82.11€). So this is not correct. Can you please help me figure that out?
Thanks,
Michael
My Odoo 8.0 running on Windows 7 Ultimate
But, it gives an error when installing the module magentoerpconnect.
Traceback (most recent call last):
File "C:\Odoo 8.0\server.\openerp\http.py", line 537, in _handle_exception
File "C:\Odoo 8.0\server.\openerp\http.py", line 574, in dispatch
File "C:\Odoo 8.0\server.\openerp\http.py", line 310, in call_function
File "C:\Odoo 8.0\server.\openerp\service\model.py", line 113, in wrapper
File "C:\Odoo 8.0\server.\openerp\http.py", line 307, in checked_call
File "C:\Odoo 8.0\server.\openerp\http.py", line 803, in call
File "C:\Odoo 8.0\server.\openerp\http.py", line 403, in response_wrap
File "C:\Odoo 8.0\server\openerp\addons\web\controllers\main.py", line 948, in call_button
File "C:\Odoo 8.0\server\openerp\addons\web\controllers\main.py", line 936, in call_kw
File "C:\Odoo 8.0\server.\openerp\api.py", line 241, in wrapper
File "C:\Odoo 8.0\server.\openerp\api.py", line 394, in old_api
File "C:\Odoo 8.0\server.\openerp\api.py", line 398, in new_api
File "C:\Odoo 8.0\server\openerp\addons\base\module\wizard\base_module_update.py", line 15, in update_module
File "C:\Odoo 8.0\server.\openerp\api.py", line 239, in wrapper
File "C:\Odoo 8.0\server.\openerp\api.py", line 463, in new_api
File "C:\Odoo 8.0\server\openerp\addons\base\module\module.py", line 650, in update_list
File "C:\Odoo 8.0\server.\openerp\http.py", line 1308, in load_addons
File "C:\Odoo 8.0\server.\openerp\modules\module.py", line 80, in load_module
File "C:\Odoo 8.0\server\openerp\addons\magentoerpconnect__init.py", line 2, in
ImportError: cannot import name setting
I configured well the Magento backend on a fresh Odoo 8 install, and my products are sync, however the product_qty field in magento_product_product are still at zero. When I run "Update all the products stock quantities" it does nothing, the quantities still remain at 0.
I try to debug but I'm not a python dev, however I trace that new_qty in _recompute_magento_qty_backend method is always 0 for all the products.
In magento_model.update_product_stock_qty , the magento_products resultset contain well a good number of products.
Also I don't see any Magento API call when I press update qty button (and the API call work when I update categories button for example).
Do I forgot something ?
I get the following error in odoo 8.0
Odoo Server Error
Traceback (most recent call last):
File "/opt/loyalerp/loyalerp-server/openerp/http.py", line 536, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/loyalerp/loyalerp-server/openerp/http.py", line 573, in dispatch
result = self._call_function(*_self.params)
File "/opt/loyalerp/loyalerp-server/openerp/http.py", line 309, in _call_function
return checked_call(self.db, *args, *_kwargs)
File "/opt/loyalerp/loyalerp-server/openerp/service/model.py", line 113, in wrapper
return f(dbname, _args, *_kwargs)
File "/opt/loyalerp/loyalerp-server/openerp/http.py", line 306, in checked_call
return self.endpoint(_a, *_kw)
File "/opt/loyalerp/loyalerp-server/openerp/http.py", line 802, in call
return self.method(_args, *_kw)
File "/opt/loyalerp/loyalerp-server/openerp/http.py", line 402, in response_wrap
response = f(_args, *_kw)
File "/opt/loyalerp/loyalerp-server/addons/web/controllers/main.py", line 948, in call_button
action = self._call_kw(model, method, args, {})
File "/opt/loyalerp/loyalerp-server/addons/web/controllers/main.py", line 936, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, _args, *_kwargs)
File "/opt/loyalerp/loyalerp-server/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/opt/loyalerp/loyalerp-server/openerp/api.py", line 363, in old_api
result = method(recs, _args, *_kwargs)
File "/opt/loyalerp/custom/magnetoconnector/connector-magento/magentoerpconnect/magento_model.py", line 198, in synchronize_metadata
import_batch(session, model, backend.id)
File "/opt/loyalerp/custom/magnetoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 370, in import_batch
importer.run(filters=filters)
File "/opt/loyalerp/custom/magnetoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 239, in run
record_ids = self.backend_adapter.search(filters)
File "/opt/loyalerp/custom/magnetoconnector/connector-magento/magentoerpconnect/unit/backend_adapter.py", line 211, in search
[filters] if filters else [{}])
File "/opt/loyalerp/custom/magnetoconnector/connector-magento/magentoerpconnect/unit/backend_adapter.py", line 159, in _call
full_url=custom_url) as api:
File "/usr/local/lib/python2.7/dist-packages/magento/api.py", line 133, in enter
self.connect()
File "/usr/local/lib/python2.7/dist-packages/magento/api.py", line 123, in connect
self.client = ServerProxy(self.url, allow_none=True)
File "/usr/lib/python2.7/xmlrpclib.py", line 1549, in init
raise IOError, "unsupported XML-RPC protocol"
IOError: unsupported XML-RPC protocol
Hi,
I've a scenario were there are three websites on magento using same payment method.
In this case, the wrong payment method is set on sale order.
Hello,
I do not understand for some days synchronization Odoo / magento no longer works I have an error message:
Odoo Server Error
Traceback (most recent call last):
File "/opt/odoo/odoo/openerp/http.py", line 537, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/odoo/openerp/http.py", line 574, in dispatch
result = self._call_function(**self.params)
File "/opt/odoo/odoo/openerp/http.py", line 310, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo/odoo/openerp/service/model.py", line 113, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo/odoo/openerp/http.py", line 307, in checked_call
return self.endpoint(*a, **kw)
File "/opt/odoo/odoo/openerp/http.py", line 803, in __call__
return self.method(*args, **kw)
File "/opt/odoo/odoo/openerp/http.py", line 403, in response_wrap
response = f(*args, **kw)
File "/opt/odoo/odoo/addons/web/controllers/main.py", line 948, in call_button
action = self._call_kw(model, method, args, {})
File "/opt/odoo/odoo/addons/web/controllers/main.py", line 936, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "/opt/odoo/odoo/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/api.py", line 363, in old_api
result = method(recs, *args, **kwargs)
File "/opt/odoo/.local/share/Odoo/addons/8.0/magentoerpconnect/magento_model.py", line 198, in synchronize_metadata
import_batch(session, model, backend.id)
File "/opt/odoo/.local/share/Odoo/addons/8.0/magentoerpconnect/unit/import_synchronizer.py", line 370, in import_batch
importer.run(filters=filters)
File "/opt/odoo/.local/share/Odoo/addons/8.0/magentoerpconnect/unit/import_synchronizer.py", line 239, in run
record_ids = self.backend_adapter.search(filters)
File "/opt/odoo/.local/share/Odoo/addons/8.0/magentoerpconnect/unit/backend_adapter.py", line 211, in search
[filters] if filters else [{}])
File "/opt/odoo/.local/share/Odoo/addons/8.0/magentoerpconnect/unit/backend_adapter.py", line 159, in _call
full_url=custom_url) as api:
File "/usr/local/lib/python2.7/dist-packages/magento/api.py", line 136, in __enter__
self.username, self.password)
File "/usr/lib/python2.7/xmlrpclib.py", line 1233, in __call__
return self.__send(self.__name, args)
File "/usr/lib/python2.7/xmlrpclib.py", line 1587, in __request
verbose=self.__verbose
File "/usr/lib/python2.7/xmlrpclib.py", line 1273, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python2.7/xmlrpclib.py", line 1321, in single_request
response.msg,
ProtocolError: <ProtocolError for mywebsite.fr/index.php/api/xmlrpc: 404 Not Found>
If you can help me see more clearly I will be grateful.
Odoo 8 - Ubuntu 14.0.4
Regards
How can I modified this method?
Just did a fresh install of the connector. Some errors showing up in normal activity. I realize that there may be some "odoo" only issues here on the Portal, but 2 of the 3 are referencing Magento Bindings which I do not believe were involved in these quotes or invoices.
Depending upon how I get to this, I am getting a consitent error whereby an Magento Related customer cannont seemingly access their backend created quotation via the Odoo Portal. This functionality should remain it seems to me. Very important absence from Magento and it is important that this can be in Odoo capabilites (was in Openerp7 with Connector)
After Logging in on the back end, when I see related quotes for the portal customer, choosing a Quote I get a series of errors visible:
On the specific quotation referenced in email:
AccessError
No value found for sale.order(15,).magento_bind_ids
On a prior quotation listed on the portal:
AccessError
The requested operation cannot be completed due to security restrictions. Please contact your system administrator.
(Document type: res.partner, Operation: read)
On a invoice listed on the customer portal:
AccessError
Sorry, you are not allowed to access this document. Only users with the following access level are currently allowed to do that:
- Accounting & Finance/Invoicing & Payments
- Connector/Connector Manager
(Document model: magento.account.invoice)
end of post
Hi,
We have a customer project with a single backend magento including several website and side Odoo it is multi-company.
I wanted to ask your opinion for import sale orders , either change the company for user 'administrator' using the company on the magento.store (thus sale.shop) to execute scheduler or by adding a 'connector_user_id' m2o on company to a user and by switching to the user configured on the
company as explained here: https://www.mail-archive.com/[email protected]/msg00091.html.
Regards,
Hi,
It would be nice to link payment methods with storeview. When there are multiple shops with different currency, the sale_payment_method doesn't link with correct sale order.
Consider a scenario:
There is no way (am I missing something?) we can link Paypal AUD payment method to Australia store sale orders.
I am open for suggestion. I would be amazed If this can be done without writing a single line of code.
Regards,
K
magentoerpconnect_order_comment uses nltk.clean_html(comment)
which does no longer work. It has been removed from the lib in version 3.0: nltk/nltk@39a303e
From Travis:
2014-09-10 10:23:45,300 23456 TEST openerp_test openerp.modules.module: ERROR: test_20_export_sale_comment (openerp.addons.magentoerpconnect_order_comment.tests.test_synchronization.TestMagentoSaleCommentExport)
2014-09-10 10:23:45,300 23456 TEST openerp_test openerp.modules.module: ` Test export of sale order comment
2014-09-10 10:23:45,300 23456 TEST openerp_test openerp.modules.module: Traceback (most recent call last):
2014-09-10 10:23:45,300 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/build/OCA/connector-magento/magentoerpconnect_order_comment/tests/test_synchronization.py", line 154, in test_20_export_sale_comment
2014-09-10 10:23:45,300 23456 TEST openerp_test openerp.modules.module: ` export_record(self.session, 'magento.sale.comment', mag_comment_id)
2014-09-10 10:23:45,300 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/build/OCA/connector-magento/magentoerpconnect/unit/export_synchronizer.py", line 389, in export_record
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` return exporter.run(binding_id, fields=fields)
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/build/OCA/connector-magento/magentoerpconnect/unit/export_synchronizer.py", line 124, in run
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` result = self._run(*args, **kwargs)
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/build/OCA/connector-magento/magentoerpconnect/unit/export_synchronizer.py", line 375, in _run
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` record = self._create_data(map_record, fields=fields)
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/build/OCA/connector-magento/magentoerpconnect/unit/export_synchronizer.py", line 330, in _create_data
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` return map_record.values(for_create=True, fields=fields, **kwargs)
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/connector/connector/unit/mapper.py", line 904, in values
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` values = self._mapper._apply(self, options=options)
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/connector/connector/unit/mapper.py", line 643, in _apply
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` return self._apply_with_options(map_record)
2014-09-10 10:23:45,301 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/connector/connector/unit/mapper.py", line 681, in _apply_with_options
2014-09-10 10:23:45,302 23456 TEST openerp_test openerp.modules.module: ` values = meth(map_record.source)
2014-09-10 10:23:45,302 23456 TEST openerp_test openerp.modules.module: ` File "/home/travis/build/OCA/connector-magento/magentoerpconnect_order_comment/sale.py", line 282, in comment
2014-09-10 10:23:45,302 23456 TEST openerp_test openerp.modules.module: ` return {'comment': nltk.clean_html(comment)}
2014-09-10 10:23:45,302 23456 TEST openerp_test openerp.modules.module: ` File "/usr/local/lib/python2.7/dist-packages/nltk/util.py", line 346, in clean_html
2014-09-10 10:23:45,302 23456 TEST openerp_test openerp.modules.module: ` raise NotImplementedError ("To remove HTML markup, use BeautifulSoup's get_text() function")
2014-09-10 10:23:45,302 23456 TEST openerp_test openerp.modules.module: ` NotImplementedError: To remove HTML markup, use BeautifulSoup's get_text() function
It should be replaced by BeautifulSoup or another library / own function that does the same thing.
Maybe we have to freeze the version of nltk
, but it will be a problem some day.
Hello!
Can I modify the files, that the connector don´t sync the category?
In Odoo all my prices are based on different price lists and they are connected to the category.
On each import he overwrite my own category.
I want only that he write not the category to the product. The categories tree of course I need in odoo.
Thank you!
This is my Local current test IP. Seems there should be some navigation between the IP and Authors
Off of my local (pre "install") Module Information Page in Odoo.
(my IP number changed to "myip" to stop the link a bit)
Contributors links to: https://myip/AUTHORS
gives: Not Found
linked from: Local Modules / Magento Connector
https://myip/web#id=310&view_type=form&model=ir.module.module&menu_id=53&action=37
File/Line: https://github.com/OCA/connector-magento/blob/8.0/magentoerpconnect/connector.py#L27
WARNING dbname openerp.addons.magentoerpconnect.connector: Deprecated: at line 27: This call to 'install_in_connector()' has no effect and is not required.
Commented it locally and works fine....
Haven't made a PR, cause it's a smart issue ;)
Exists support for Odoo V.8 now ?
Thanks
My English es Bad
Hi,
I just tried importing all of our old orders. First of all the jobs failed because I did not have the fiscal years and periods configured. I did that now and now the jobs are failing with this error message:
Traceback (most recent call last):
File "/opt/openerp-custom/addons/connector/connector/queue/worker.py", line 124, in run_job
job.perform(session)
File "/opt/openerp-custom/addons/connector/connector/queue/job.py", line 466, in perform
self.result = self.func(session, _self.args, *_self.kwargs)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 379, in import_record
importer.run(magento_id, force=force)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 220, in run
record = self._create_data(map_record)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/sale.py", line 908, in _create_data
**kwargs)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 164, in _create_data
return map_record.values(for_create=True, **kwargs)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 912, in values
values = self._mapper._apply(self, options=options)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 696, in _apply
return self._apply_with_options(map_record)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 745, in _apply_with_options
to_attr, model_name)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 654, in _map_child
to_attr, options=self.options)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 419, in get_items
mapped.append(self.get_item_values(map_record, to_attr, options))
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 440, in get_item_values
return map_record.values(**options)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 912, in values
values = self._mapper._apply(self, options=options)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 696, in _apply
return self._apply_with_options(map_record)
File "/opt/openerp-custom/addons/connector/connector/unit/mapper.py", line 734, in _apply_with_options
values = meth(map_record.source)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/sale.py", line 980, in product_id
"SaleOrderImporter._import_dependencies" % record['product_id'])
AssertionError: product_id 456 should have been imported in SaleOrderImporter._import_dependencies
Can you help me identify the issue?
Thanks,
Michael
When creating a new export job for products, we are seeing the following stack trace (edited for the full line of code):
File "/vagrant/connector_addons_inprogress/connector-magento/magentoerpconnect/unit/export_synchronizer.py", line 96, in _should_import
magento_date = datetime.strptime(record['updated_at'], MAGENTO_DATETIME_FORMAT)
File "/usr/lib/python2.7/_strptime.py", line 325, in _strptime
(data_string, format))
ValueError: time data '2015-05-15 20:18:18' does not match format '%Y/%m/%d %H:%M:%S'
The error is due to the record object having the Odoo server datetime format, but strptime is using the magento datetime format.
pre-upgrade, this function used DEFAULT_SERVER_DATETIME_FORMAT instead of MAGENTO_DATETIME_FORMAT, so it looks like a regression.
Was there any reason for this change?
If i update the product image in magento, the image in odoo are updated for product.product but the picture for product.template is still unchanged and the old one
Hi Team,
I was testing sale order import with multi company with different taxes and found a bug.
Steps to reproduce:
Problem:
Solution:
set shop in session context.
Hi, i'm triying to sync orders from magento to Openerp 7.
The price in Magento are tax included.
In the configuration for the connector I have checked (Prices include tax).
When the order is synced, openerp include againg the tax for the product.
Ex: In magento the price in catalog is 9.71 with a discount of 5% = 9.22€ this value with tax included.
Magento say:
Total 9,22 €
Shiping 10,00 €
taxes 1,60 €
Total = 19,22 €
Openerp say:
Product IVA 21% 9.22
Shipping costs 10.00
Subtotal 19.22 €
Tax 1.94 €
Total 21.16 €
It seems that apply the tax again to 9.22.
It's normal, or I'm doing something wrong??
Salesperson in Sales Orders (sale.order.user_id
) should be set as the customer's Salesperson (res.partner.user_id
) on imported orders.
I know that other salespeople will not be able to see the orders then according to https://github.com/OCA/connector-magento/blob/7.0/magentoerpconnect/sale.py#L964-L968:
@mapping
def user_id(self, record):
""" Do not assign to a Salesperson otherwise sales orders are hidden
for the salespersons (access rules)"""
return {'user_id': False}
But, this is necessary for accounting and commission of salespeople, so maybe this should be configurable setting.
If anyone can also give a little direction as to how to proceed with this issue I can make a pull request.
Read OCA/maintainer-tools#29 to know more about it
Hi,
In odoo we can generate PO from SO if the product is:
Can we trigger the same workflow while importing SO from Magento?
Thanks!
Hi,
I have installed the Magento Connector Modul. But in my Installation there are no workers.
Why is that so?
http://odoo-magento-connector.com/guides/installation_guide.html
I can't make a worker and the process in the waitlist can be finished manually.
in connector-magento / magentoerpconnect / product.py
def search(self, filters=None, from_date=None): """ Search records according to some criterias and returns a list of ids :rtype: list """ if filters is None: filters = {} if from_date is not None: str_from_date = from_date.strftime('%Y/%m/%d %H:%M:%S') filters['updated_at'] = {'from': str_from_date}
it seems here that from_date information is in filters, and not in from_date arg.
Then the date is not well formatted according Magento needs and Magento returns an error.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.