← Back to team overview

openerp-india team mailing list archive

[Bug 988270] [NEW] [6.1] slow fetching products Point of Sale

 

Public bug reported:

Addons : 6745
Web : 2308
Server : 4147

Fetching 60000+ product s in the Point of Sale module is slow because
the  'pos_categ_id = null'.

This is because in the pos.js file line 72  says:
this.fetch('product.product', ['name', 'list_price', 'pos_categ_id', 'taxes_id', 'product_image_small', 'ean13', 'id'], [['pos_categ_id', '!=', 'false']]),
==> This wil get all the products where pos_categ_id != False, include the 'null' values

but when changing this to:
this.fetch('product.product', ['name', 'list_price', 'pos_categ_id', 'taxes_id', 'product_image_small', 'ean13', 'id'], [['pos_categ_id', 'in',  _.pluck(this.store.get('pos.category'), 'id') ]]), 
  ==> it only get the products for the designated category of the PoS itself.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/988270

Title:
  [6.1] slow fetching products Point of Sale

Status in OpenERP Addons (modules):
  New

Bug description:
  Addons : 6745
  Web : 2308
  Server : 4147

  Fetching 60000+ product s in the Point of Sale module is slow because
  the  'pos_categ_id = null'.

  This is because in the pos.js file line 72  says:
  this.fetch('product.product', ['name', 'list_price', 'pos_categ_id', 'taxes_id', 'product_image_small', 'ean13', 'id'], [['pos_categ_id', '!=', 'false']]),
  ==> This wil get all the products where pos_categ_id != False, include the 'null' values

  but when changing this to:
  this.fetch('product.product', ['name', 'list_price', 'pos_categ_id', 'taxes_id', 'product_image_small', 'ean13', 'id'], [['pos_categ_id', 'in',  _.pluck(this.store.get('pos.category'), 'id') ]]), 
    ==> it only get the products for the designated category of the PoS itself.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/988270/+subscriptions


Follow ups

References