Unfortunately the code above did not work. I implemented it, cleared cache but the requested post did not show. I am not aware if it matters but I am using “Grouping” for the results and that may cause the issue.
Variation name
I not an expert in coding but I found a snippet below that can be used to extract the variation slug name in Woocommerce 3.0+ and might help you.
Either way thank you so much for your time and effort.