Problem with "sort by" when i try to export catalog

Asked by Julian Velasquez

Hello, i have the next openerp error message when i try to export catalog to magento.

Environment Information :
System : Linux-2.6.24-26-generic-i686-with-debian-lenny-sid
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 8.04.4 LTS
Release: 8.04
Codename: hardy
Operating System Release : 2.6.24-26-generic
Operating System Version : #1 SMP Tue Dec 1 18:37:31 UTC 2009
Operating System Architecture : 32bit
Operating System Locale : es_CO.UTF8
Python Version : 2.5.2
OpenERP-Client Version : 5.0.9
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/openerp-server/", line 245, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/lib/python2.5/site-packages/openerp-server/", line 74, in __call__
    return getattr(self, method)(*params)
  File "/usr/lib/python2.5/site-packages/openerp-server/service/", line 576, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/base_sale_multichannels/", line 159, in export_catalog
    self.export_categories(cr, uid, shop, ctx)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/base_sale_multichannels/", line 147, in export_categories
    self.pool.get('product.category').ext_export(cr, uid, [categ_id for categ_id in categories], [], {}, ctx)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/base_external_referentials/", line 298, in ext_export
    self.ext_update(cr, uid, exp_data, conn, mapping_rec['external_update_method'], record_data['id'], ext_id, rec_check_ids[0], mapping_rec['external_create_method'], context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/base_external_referentials/", line 342, in ext_update
    crid = self.ext_create(cr, uid, data, conn, create_method, oe_id, context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/magentoerpconnect/", line 58, in ext_create
    return, [data.get('parent_id', 1), data])
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/magentoerpconnect/", line 87, in call
    return self.try_call(method, arguments)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/magentoerpconnect/", line 60, in try_call
    res =, method, arguments)
  File "/usr/lib/python2.5/", line 1147, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.5/", line 1437, in __request
  File "/usr/lib/python2.5/", line 1201, in request
    return self._parse_response(h.getfile(), sock)
  File "/usr/lib/python2.5/", line 1340, in _parse_response
    return u.close()
  File "/usr/lib/python2.5/", line 787, in close
    raise Fault(**self._stack[0])
Fault: <Fault 1: 'Default Product Listing Sort by not exists on Available Product Listing Sort by'>

Thank you for your attention.

Julian Velasquez

Question information

English Edit question
Magento OpenERP Connector Edit question
No assignee Edit question
Solved by:
Julian Velasquez
Last query:
Last reply:
Revision history for this message
Julian Velasquez (juesvedi) said :

I found the problem. I change the configuration in:
menu>products>products categories>"select category">display settings>
and change values in:
"Available product listing (sort by)" and "Default product listing sort (sort by)" like "Use config settings"

Config settings values are located in magento admin panel: system>configuration>catalog>front view>product listing sort by and catalog>categories management>display settings>available product listing sort by.