Hi,
I need to build a website where I will have different product details like size, color etc. The problem is that I am not sure what is the best way to do this because there will be arround 50 different fields needed for each product and I'm trying to get best of both worlds, to have a good backend (to be easy to complete all the fields by the editors), and to be good from the performance point of view.
I think about some ways :
1. Regular fields, one for each thing ? The problem is that there will be at least 50 fields for each product and when I need them all it will probably have an impact on the performance, even more when I'll want to filter based on some values (like a specific color and a size smaller than X)
2. Page refferance ? As some of them will have just few options like the category the product is part of I am thinking I can do this for almost all fields (just not for the ones like size etc)
3. Repeater field ? The problem might be that it is hard for editors to complete both the "label" and the value for example and seems like repeater fields are for different things.
4. The pro fields table module ? Is this what it is meant for ?
Did any of you had to build something similar ? How does processwire handle pages with more than 50 fields (or probably to be sure in future it might have more, something arround 100 fields), keeping in mind that there might be a total of 2000-3000 pages of products.
Also I need almost all of them to be search-able and to be able to compare any 2 (or a bigger number) of products and show which one has a bigger size for example, so the values have to be somehow separated from the labels.
Any idea is welcome. Thanks