Product price not showing up in views without Disable SQL rewriting I got a Commerce Product set up in Drupal 7 with a content-type Product Display that have a product reference to it. Users have read access to Product Display but not direct access to the Commerce Product.

I am now trying to set up a Pane in Views 3 that list Product Display nodes in a table. I want to include the Price in every row. I have added the referenced product in relationship and were about to add the price field from the product.

This view however does not display at all for normal users. I suspected that normal users don't have access to the Product entity, so turned on Disable SQL Rewriting and now Views displays the table as intended for normal users.

I am wondering if this is the right way to get the price to show up in Views? I can see that the Product Display node can actually display the price on its page without giving access to the Product to normal users, but cannot find how to access that display field within just the node in Views.
This has been discussed in a lengthy thread on drupal.org. The recommendation apparently is indeed to disable SQL Rewriting. There is a pretty good explanation of the ramifications in the middle of the thread along with alternative suggestions. But it appears that you got it right for now.