How to filter product popup by availability

[raynor]

hi

I used to have this on my earlier version of Sugar, but seemed to lose it when I went to version 6.

When adding a Product to an Account, and using the Product Popup, I want it to always filter so that only products that are In Stock are shown.

I've tried editing modules/ProductTemplates/Popup_picker.php and put
$where = 'product_templates.status = "Available"'; into the function process_page, but it doesn't seem to apply.

Any suggestions?

[andopes]

Hi raynor

I believe your old version had been customized accordingly.
Can you provide the zipped custom/modules/ProductTemplates/ and custom/modules/ProductTemplates/

Cheers

[raynor]

hi Andopes

A new day is a good day. I'm sure i had tried this combination before, but I added:
$where2 = "product_templates.status = 'Available'";
if ($where) $where.= " AND product_templates.status = 'Available'";
else $where = 'product_templates.status = "Available"';

in function process_page, just after the call to get_where_clause, and it works now.

Thanks!