I have installed Drupal Commerce (7.x.1.8 version) but in user orders section when I select an order only price and total is shown. In despite of order details the message "no line items found" appears. What can I do on here to show order datails?

3 Answers 3


I found a solution that worked for me via this article.

The author propose to change the Commerce view settings.


This is a common problem for anonymous users depending on the permission configuration you might have, the usual solution is to disable the SQL query rewriting for the affected view.

Check out these related issues in drupal.org


'Disable SQL rewriting' in the affected view:

  1. Edit the view: in 'Advanced' select 'Query settings' Edit the view: in 'Advanced' select 'Query settings'
  2. Select 'Disable SQL rewriting' Select 'Disable SQL rewriting'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.