I was wondering if you'd have any suggestions on how to retrieve a list of sizes that are available in the current selection.
For example, I have around 1M products in our webshop, that all contain sizes like:
S, XXL, XXXL
Also, I've created a table with sizes (category_sizes) I want to display per main category, so lets say category 'women' can have these sizes:
S, M, XL, XXL, 18, 19, 20 (each in a single row)
I hope you understand the problem. Exploding the sizes in the pt_products table would result in a very large array of distinct sizes, and then comparing it to the category_sizes table entries would simply take way too long.
Maybe the category_sizes is not the way to go, but I'm not sure. Unfortunately it's pretty hard to normalize the sizes since the feeds we use contain very precarious data.
Hope you have any ideas :-)
Thanks in advance