We recently ran into an issue where we didn't get any results when filtering on a specific size (eg. /categorieen/schoenen.html/maat/37-5/) although we did have products available for this filter value.
When looking further into this issue I found out that there were old attribute values in the tweakwise_attribute_slug which were not used anymore.
We had an text swatch attribute maat with the value 37.5. We've changed that value later on to 37,5. The old value was still available in the tweakwise_attribute_slug which didn't have any results anymore.
To fix this issue I've truncated the table so the values will be regenerated. Although this issue will appear again when changing the attribute values.
Issue Brief
We recently ran into an issue where we didn't get any results when filtering on a specific size (
eg. /categorieen/schoenen.html/maat/37-5/
) although we did have products available for this filter value. When looking further into this issue I found out that there were old attribute values in thetweakwise_attribute_slug
which were not used anymore.We had an text swatch attribute
maat
with the value 37.5. We've changed that value later on to 37,5. The old value was still available in thetweakwise_attribute_slug
which didn't have any results anymore.To fix this issue I've truncated the table so the values will be regenerated. Although this issue will appear again when changing the attribute values.
Preconditions
Environment