I would like to get the customer group in Sales > Order grid. I'm using the gridcontrol module for this.

I used below XML tag to get customer group but after that I do not see any order. I think my join query is wrong:

<join table="customer/customer_group" condition="main_table.customer_id ={{table}}.customer_group_id" field="customer_group_code"/>

1 Answer 1


It is, as you're joining a customer id with a customer group id. The main_table is sales_flat_order. It has a customer_group_id field, which can be NULL.

  • how to fix it.. i wan to get customer group code her
    – mcoder
    Feb 15, 2015 at 23:59

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.