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