[SOLVED] Search including MPN

[franayala]

Hi all,

How to include product MPN in search?

This is possible? In configuration back end we can not locate an option to do this. We can include a lot of options to search but no Manufacturer Part Number.

Thanks!!!

[GJC Web Design]

Hopefully will be added in the final VM3 but maybe you can add the field in administrator/components/com_virtuemart/virtuemart.cfg

browse_search_fields=array:`p`.product_sku|category_name|category_description|mf_name|product_name|product_s_desc|product_desc|product_mpn

[franayala]

Not work

[GJC Web Design]

ah well - did you look why not?

models/product.php?

[franayala]

I will see. Let me check

[franayala]

it's impossible for me to solve this.

Any help, please?

Thanks!

[slammy]

as far as I can see it´s already included in vm 2.6.10, just tested and it worked ...

[franayala]

not for me. In a clean installation not work

[jjk]

Just tested it in my 2.6.10 version. Doesn't work for me.
@slammy
Did you check by chance with Product SKU and MPN being identical? I this case probably your Product SKU was found.

[slammy]

@jjk

this is surprising for me. there are no identicals because I don´t use mpn. I´ve tested it with 12345 and the be-product-search found this one (from > 500 in db) where I´ve edited the mpn with 12345. I can post files if you want, just tell me which ones.
best regards
jens

[jjk]

... I´ve tested it with 12345 and the be-product-search found this one (from > 500 in db) where I´ve edited the mpn with 12345.

Ok, that's the difference. I've tested it with the frontend search. Product SKU is available for the frontend search, MPN is not.

[slammy]

ah - ok you speak about fe-search, sry misunderstood you.

[franayala]

how to include mpn in front send search?

[Milbo]

Hopefully will be added in the final VM3 but maybe you can add the field in administrator/components/com_virtuemart/virtuemart.cfg

browse_search_fields=array:`p`.product_sku|category_name|category_description|mf_name|product_name|product_s_desc|product_desc|product_mpn

Cant work, you add a value for a field, which is not in the array

[Milbo]

try
shopfunctions.php around line 1151, function getValidProductFilterArray

just add 'product_mpn' to the array