Skip to Content
Menu
This question has been flagged

We have about 22000 products imported into Odoo using webkul connector for Magento 2. All of our weights are in LB ( Pounds). The product actually shows Weight in LB but the System setting for products Weight Measurement is set to Kilograms. If i change it to Pound and try to open a product i get an error. I have to change it back to Kilograms to be able to open the product without errors. How can i change the system setting to Pound without getting errors, or does it even matter what the setting is if all of the products are showing in Pounds. Is there anyone on this forum that has experienced this problem. 

  Error:
Odoo Server Error

Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 761, in get
value = self._data[field][record._ids[0]]
KeyError: 7902

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\fields.py", line 1044, in __get__
value = env.cache.get(record, self)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 767, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('product.template(7902,).weight_uom_name', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\cache.py", line 85, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.model.data', <function IrModelData.xmlid_lookup at 0x02CEA5D0>, 'uom.product_uom_lb')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 619, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 309, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\pycompat.py", line 14, in reraise
raise value
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 664, in dispatch
result = self._call_function(**self.params)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 345, in _call_function
return checked_call(self.db, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\service\model.py", line 93, in wrapper
return f(dbname, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 338, in checked_call
result = self.endpoint(*a, **kw)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 909, in __call__
return self.method(*args, **kw)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\http.py", line 510, in response_wrap
response = f(*args, **kw)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\web\controllers\main.py", line 1319, in call_kw
return self._call_kw(model, method, args, kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\web\controllers\main.py", line 1311, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 411, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 398, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 2856, in read
vals[name] = convert(record[name], record, use_name_get)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 5473, in __getitem__
return self._fields[key].__get__(self, type(self))
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\fields.py", line 1068, in __get__
self.compute_value(recs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\fields.py", line 1149, in compute_value
records._compute_field_value(self)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\models.py", line 3840, in _compute_field_value
getattr(self, field.compute)()
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\product\models\product_template.py", line 290, in _compute_weight_uom_name
template.weight_uom_name = self._get_weight_uom_name_from_ir_config_parameter()
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\product\models\product_template.py", line 286, in _get_weight_uom_name_from_ir_config_parameter
return self._get_weight_uom_id_from_ir_config_parameter().display_name
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\product\models\product_template.py", line 280, in _get_weight_uom_id_from_ir_config_parameter
return self.env.ref('uom.product_uom_lb')
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\api.py", line 522, in ref
return self['ir.model.data'].xmlid_to_object(xml_id, raise_if_not_found=raise_if_not_found)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\base\models\ir_model.py", line 1638, in xmlid_to_object
t = self.xmlid_to_res_model_res_id(xmlid, raise_if_not_found)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\base\models\ir_model.py", line 1622, in xmlid_to_res_model_res_id
return self.xmlid_lookup(xmlid)[1:3]
File "<decorator-gen-24>", line 2, in xmlid_lookup
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\tools\cache.py", line 90, in lookup
value = d[key] = self.method(*args, **kwargs)
File "C:\Program Files (x86)\Odoo 13.0\server\odoo\addons\base\models\ir_model.py", line 1611, in xmlid_lookup
raise ValueError('External ID not found in the system: %s' % xmlid)
ValueError: External ID not found in the system: uom.product_uom_lb

Avatar
Discard
Author Best Answer

Ermin, thank you for your answer. i changed the External id to uom.product_uom_lb and now it works perfectly. 

Avatar
Discard

Your upvote and check as answered is very welcome.

Best Answer

You can define multiple Units of Measures. As your error messages clearly says, there is no UoM with the External ID uom.product_uom_lb. You should check if, you have lb in your UoM table, if yes, export your UoM to check their External IDs. If the External ID is different in Odoo 13, you should revert to Webkul.

Avatar
Discard
Related Posts Replies Views Activity
2
Jan 20
3573
2
Jul 24
1662
1
Mar 24
412
1
Dec 19
5325
0
Mar 15
4001