Filtering Custom Product Field

[succeed.net]

Ok I figured the guys in support need a break so I would come here with a question. Support folks are great by the way.

 

In order to do mass emailing to specific customers we have had to do setup custom fields in each of our products. These custom fields are important because they hold key information specific to each product at each separate location the customer has. A customer can have three products, each at different physical locations. The information available in each field is the same on all product.

 

The issue I am running into is that when we filter on the custom product field we have to filter each product separately. I need to be able to filter the custom field and filter through all products.

 

The reason for needing to filter this way is to be able to mass mail the customers with specific info in the custom product field regardless of the product type they have.

 

We have say 30 products. All products have the same custom fields. I need to be able to filter all 30 products to find all products that match specific custom field data. Currently I WHMCS only give the capability to filter each product separately.

 

Any Ideas?

 

Dave

[bluerayconcepts]

This is a bump of an old post but i just had a thought of how to do accomplish this change fairly easily...I think.

 

All that would need to be done is change the Custom Field Drop down list in the Search/Filter from a drop down to a ctrl selectable list. Then we would be able to select all the fields we wanted to search and enter the custom field value we are looking for.

 

I think this would be easier to accomplish that what i was originally thinking.

 

There has to be other people that need to search across the custom product fields. Custom product fields open up a whole other way to keep track of customer data.

 

Please!!!!