I'm creating a new drupal commerce site and I wanted to create a view of all my products.
I didn't want to use Format: content but Format: fields instead. Of course then I needed to add a relationship to get the right fields like price (which are not part of the product display but rather the product itself) in to my view.
All of this worked rather well, I can see my view and it lists the products nicely.
The problem is that only I, the admin, can see the view. Authenticated users and anonymous users are not able to see anything.
As far as I can tell, the query does not display a result for them... (I added a string in the no results behavior section)
I checked all of the permissions needed for this view and made sure that all the content is published and that the view shows published content.
I did notice however that when I remove the relationship, the view does have a result.
I find this rather strange and I cannot find the answer so I turn to you. Is there anyone here who knows what I'm missing?
Thanks in advance