Users don't have access to view as soon as relation is added, drupal commerce 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
This is an issue listed in the Drupal Commerce issues queue. http://drupal.org/node/1276450 Its happens when your view has a relationship to a commerce product.  I came across this earlier today when I was doing the same thing as you.   

Two different solutions are suggested at comments 5 and 6 on the issues page. The first is to disable SQL rewriting under the Advanced > SQL Settings section of the view.  This can have security implications if your using contextual or exposed filters.  The other suggestion is give all user roles the 'View any product of any type' permission under permissions.  This is what worked for me.