Vote up!
Vote down!

Commerce monthly orders view

I'm doing a project in which I need to produce a monthly order view.

The users will do a order for everyday of the month, and the system needs to create a view, a table view of all orders of the month, this table must have in the vertical first column the order number, one for each day, and in the horizontal row must have all the products that the user order... something like this image:


I was trying to do this with the DataTables module (http://drupal.org/project/datatables/) but I wasn't able to choose the product item field, I can only get the Line item field, and it contains everything, but not in the format I require, is it possible to do it??

Thanks a lot!!

Asked by: alduxvm
on July 25, 2012

1 Answer

Vote up!
Vote down!

You can add a relationship to the product information using the product id on the line item. You'll have to use Aggregation settings on a line item to count how many products were ordered per month. I would recommend you also relate the order using the order id on the line item and filter based on order status to make sure you only have purchased items.

Josh Miller
Answer by: Josh Miller
Posted: Sep 5, 2012