Hi,
I have an issue and I don't know what the best approach is to fix it.
Problem
We are listing only the main products (not variants)
We have a free text search field that, besides a number of fields from the main product, needs to search the variants product number
Ex:
- Main product ID = PROD1
- Product variants's number (not the ID) = 111, 112, 113
- If I search for 111, I get PROD1
Possible solution
The most obvious solution is to have a field in the main product that contains all of the variant's product numbers, but this means the user needs to update those fields accurately, which does not make sense for the customer.
Is there a better way to do it? Can I index some fields to the main products that belong to the variant?
Best Regards,
Nuno Aguiar