Store: Dashboard

Sweet action. The bottom left pane doesn't make sense, though. The title is "Orders" but the content is a View of products in the store. If that is indeed the most recent orders, perhaps make it a View with columns showing the Order ID, Customer (first / last name), Total (dollar amount), and Operations (view / edit).

Users have preferred a view link to a clickable order ID in the past, but I think my preference would be to just have both. I think. Any thoughts? I believe their rationale was that for lower order numbers it's a tiny link and that their customers were just missing the link.

An interesting pane to add to the dashboard would be "Tasks", that list for example orders that need action, products of which stock threshold has been reached and need action. Ad hock tasks or an other thing. But this might mean coding a little "tasks framework"...

I'm going to postpone this and possibly won't fix it in the future if it does indeed fit better in a contrib module. At the current rate of development, this probably won't be a 1.0 feature, though. Related issue:

http://drupal.org/node/725592#comment-3052272

I'm thinking about creating some more blocks and put them in the install profile, so the dashboard can much nicer, because it's really a central place for shop managers and marketing people and co.

Some ideas of blocks :
Products related : Best sales, Worst sales, Latest sales, Most viewed, Least viewed
Data summary (if possible)
User related : New customers, Best customers (by Total and Number of orders)
Carts related : Abandoned carts (% of total carts)

I don't know if all blocks are possible, but I'll try ! I'm not trying funky stuff, basically most blocks (if not all) will come from Views.

After a discussion with rszrama and damien most of these blocks should belong to a report module, which doesn't exit to date. I'll file an issue (edit: done here #1031134: Report module) for that. So we should just restrict those blocks for day-to-day store management tasks.

Here's a first block : "Latest orders", which is just a block version of the "Orders" admin page. I refreshed the code in the commerce_order_ui.default_views.inc with the whole export code from Views. Added a 'more link' to the admin page, and limited the number of items to 5.

https://github.com/DjebbZ/drupalcommerce/commit/a917384ac1bb9180f7fb2b0d...

Changing tags.

As we can't track paid orders, i.e. actual incomes related to products and orders and users etc., other blocks are nearly impossible to create...

Sources of ideas for dashboard/report information :
http://www.magentocommerce.com/product/features/analytics-and-reporting/...
http://www.flickr.com/photos/ans/4539585089/
http://www.prestashop.com/en/allfeatures#stat
http://wordpress.org/extend/plugins/wp-e-commerce-dashboard-widgets/scre...

To be able to create the "Best sales", we need to count total quantity of line items referencing the product on orders NOT in the "canceled" or "cart" state. - @rszrama. So I'm going to try to create a views handler that will do the quantity part, the order part being just a filter that already exists.

Done ! Views handler done ! So happy :) :)

https://github.com/DjebbZ/drupalcommerce/commit/a917384ac1bb9180f7fb2b0d...

Better handler here (with sorting and filtering) :

https://github.com/DjebbZ/drupalcommerce/commit/cad9bae62ae14b27818653ed...

The "Best orders today" block is almost ready, but the views filter for "Order status" doesn't work, so I can't filter for actual orders.

Thanks to the previous handler, the "Best orders today" block for the dashboard is now ready. But when added to the Dashboard it produces this Debug notice :

# Debug:

'Missing handler: commerce_order total_quantity field'

in views_get_handler() (line 841 of /Users/khalid_jebbari/Sites/commerce/sites/all/modules/views/views.module).
# Debug:

'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'unknown\' in \'order clause\''

in views_plugin_query_default->execute() (line 1314 of /Users/khalid_jebbari/Sites/commerce/sites/all/modules/views/plugins/views_plugin_query_default.inc).

So I might did something wrong with the handler...

The previous bugs were stupid bugs. Fixed ! So here's the code for a proper Views handler that really displays the total quantity of items for an order.

https://github.com/DjebbZ/drupalcommerce/commit/05c2178ffa08e25603ff8910...

But I removed the filter and sort handlers, because the quantity is calculated on the fly. So they just can't work. We need to figure out a way to use them, especially the sort. Without the sort, the "Best orders" dashboard block cannot exist.

Maybe the total quantity should be an actual field of the order, updated some way (Rules ?), so handling it with Views will be easy.

Actually, if you add the "group by" option in the view, you can show, filter and sort by line items of the orders using the relationship out of the box, so there is no need of the extra field.

subscribing

subscribing

I think some of this, like the summary blocks could be generated by Drupal Commerce. And then a install profile could just place them into the dashboard, and implement more if needed.

I'm going to do some work on this.

sub

sub

What do you think about create a module for this?

I think it's a really important part of Drupal Commerce. Do you think that it will be integrated into Drupal Commerce on next version?

I've been working on a dashboard and it's quiet near ready for a closed beta release. Here is a sneak preview video:
http://youtu.be/L1-9-fgXRJg?hd=1
Snapshot of the backend:
http://i.imgur.com/rgzMW.png
If you have any comments or requests feel free to make an issue in the sandbox:
: http://drupal.org/sandbox/peach/1571178

It's built with views, skinr and a custom module to provide ajax-views integrated SVG google charts in a responsive layout.

Wow, thanks for sharing! : )

Yes impressive!! Really excited to test it!

update: you can now use the Commerce Compass dashboard without the need to patch anything: http://drupal.org/project/commerce_compass

Very cool work!

I want to add: We have in Germany a new E-Commerce Solution which is in some points better than Magento. For more informations you can visit http://www.shopware.de

Here you find a live backend demo of shopware with their Dashboard:
http://www.shopwaredemo.de/backend/

Sometimes it is good to use inspirations from other well shop solutions.

See also http://drupal.org/project/commerce_reports. This issue should probably be closed, as contrib modules which can provide the suggested functionality exists?

Fixing input format.

Closing issue. Commerce Reports is the module that should be providing this page.