VM Dashboard is an administration module to be published at the cpanel module position. It will show on your Joomla adminsitration control panel a set of 5 tabs.
- First tab will show monthly statistics for your sales and orders with charts and tables (show as many month as you want starting from current month.
- Second tab lists latest received orders with order numvber, customer name, order status, order total price and order date.
- Third tab shows latest product reviews with review status (green or red for published or unbuplished), date, product name, review, rating and reviewer name.
- Fourth tab shows latest products with product status (green or red for published or unbuplished) product id, sku, price, product name and product category.
- Fifth Tab shows a list of latest shoppers, with user ID name, username.
Every lists in these tabs are displayed as tables, amount of rows are module parameters. Every item is linked to its corresponding page in Virtuemart.
http://www.nordmograph.com/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=58 (http://www.nordmograph.com/extensions/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=58)
can you believe I don't find the download button or the add to cart button? I have even registered and can't download it.
EDIT: found it, zip box image, strange ;D
Works great, would be nice to have an option to show latest orders first, instead of montly sales.
Regards
Hello
Happy you like it.
Just note that the module re-opens the last tab you opened so you can have tha latest orders tab open first when you load the page.
Also I recommend you redownload the module, it just got an update to fix a bug for long time ago (2 years & more) stats.
Thanks ;)
BTW here you have the spanish translation I made for my website in case it helps or you want to include it.
I renamed the .ini to .txt
Tested and works perfectly in our website except for these text which isn't included in the language file:
"Module settings - More Virtuemart extensions - Support Forum
This is a free and usefull Joomla module by Nordmograph.com.
Review this extension at JED"
Regards
[attachment cleanup by admin]
Muchas gracias! I'll add it to the package.
Module works great here and is very handy indeed.
Absolute must for anyone running virtuemart.
Thanks !
Hey Happy You like it! Feel free to leave a review at JED too if you think it's usefull :)
I have this extension installed but I can't figure out how to enable it?
It is not visible in the available modules
Hi
Make sure you list administrator modules and not site modules.
Then enable it in the cpanel module position.
I did but I cant find it. Not under, vm cpanel, vm statistics or website cpanel...
Go to your site administration (j2.5)
Hit on extensions > Modules
Then next to the list filter; change the select list from "site" to "administrator".
You'll find the Virtuemart Synthetic Dashboard there.
I did exactly that. Perhaps it has to do with out VM v2.0.6? We cannot update at this time however.
No it's not related to VM version, it's a joomla module.
Re-install it and follow carefull the stebbystep from my previous posts.
Nothing more required.
Did you at least find the module settings ?
I logged in to your site, did nothing and the module is showing fine on the front page cpanel.
What else?
Module updated: Sales and orders total added not only for months butr also for the time period set:
http://www.nordmograph.com/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=123
I installed the new module but I can't see where the time period for totals can be changed?
The graph isn't properly displayed on our website though. Could you check your PM?
Hello
I recommend you use our forum for support. It makes it easier for us to track posts.
The time period to be set in the module settings. The total shows at the end of the table (table to be displayed)
The charts width is displayed at its best when module tab is the one open when the page loads.
The module from your download link still appears to be created Sep2012.
Is this the right version? I don't see the totals at the end of the table.
Hi, is happening the same to me, actually I didn't notice any difference,
regards
I just reuploaded again and checked. You can redownload it.
:)
Module has just got a new little update: a new tab with a RSS feed genarator/updater for store latest products.
Somehow usefull has VM2 doesn't have that feature anymore.
Feedback welcome.
Hi nordmograph
At the first version of the module I clicked at the order tab and next time I went log in the administrator my last view (order tab) was saved.
Not a big issue but would be nice if we could somehow show or choose the initial view.
Regards
Hi Nordmograph
When you have time could you please make the module show the translations correctly for the order status.
When we use this keys as order status the module doesn't show the value, instead displays the key. Language files have been updated and at the order status we have to use this keys which get translated correctly everywhere.
COM_VIRTUEMART_ORDER_STATUS_SHIPPED
COM_VIRTUEMART_ORDER_STATUS_REFUNDED
COM_VIRTUEMART_ORDER_STATUS_CANCELLED
COM_VIRTUEMART_ORDER_STATUS_CONFIRMED
COM_VIRTUEMART_ORDER_STATUS_CONFIRMED_BY_SHOPPER
COM_VIRTUEMART_ORDER_STATUS_PENDING
Regards
Hello
I updated the module for a minor bugfix causing a duplicate month name entry only happening in the last days of the month.
Just fixed.
Since I can die waiting for you to fix the multilingual issue I did a semi fix myself, at least it shows the order status letter code correctly:
administrator\modules\mod_vmsynthdashboard\tmpl\default.php
Around line 312 change:
<a href = "<?php echo $order_name_link; ?>" ><?php echo $row->order_status_name; ?></a>
to:
<a href = "<?php echo $order_name_link; ?>" ><?php echo $row->order_status; ?></a>
Hey Lindapowers
I updated the module just for you,(actually you only complained about these backend language strings).
I'm not using those from VM language files, the module has its own strings for order statuses. They also have style.
Make a backup of the old module and upgrade to the latest.
And add this to your language file
C="<font style='color:green;'>Confirmed</font>"
U="<font style='color:green;'>Confirmed by shopper</font>"
S="<font style='color:blue;'>Shipped</font>"
P="<font style='color:orange;'>Pending</font>"
X="<font style='color:red;'>Canceled</font>"
R="<font style='color:red;'>Refunded</font>"
Quote from: nordmograph on November 05, 2013, 16:57:03 PM
Hey Lindapowers
I updated the module just for you,(actually you only complained about these backend language strings).
I'm not using those from VM language files, the module has its own strings for order statuses. They also have style.
Make a backup of the old module and upgrade to the latest.
And add this to your language file
C="<font style='color:green;'>Confirmed</font>"
U="<font style='color:green;'>Confirmed by shopper</font>"
S="<font style='color:blue;'>Shipped</font>"
P="<font style='color:orange;'>Pending</font>"
X="<font style='color:red;'>Canceled</font>"
R="<font style='color:red;'>Refunded</font>"
Well thanks a lot, however my request affects ALL multilingual websites.
And I posted in your forum how the module showed those status, not my problem if people can't even notice or probably care about having the module display:
COM_VIRTUEMART_ORDER_STATUS_CONFIRMED instead of Confirmed or Confirmado in our case.
I was the only one requesting here the use of 2 taxes in the same order to make orders legally correct for all Europe... something from now on implemented in the core of VM, so im glad being alone sometimes ;)
Regards
Hi, installed the module but I have made a tweak to the code as I have different Order statuses that I want to count e.g. Collected, Shipped and Confirmed.
Here are the changes if you want to add them feel free.
1/.
In file: administrator/modules/mod_vmsynthdashboard/mod_vmsynthdashboard.xml
Change:
<fieldset name="basic">
to :
<fieldset name="basic" addfieldpath="administrator/modules/mod_vmsynthdashboard/elements">
<field name="orderstates" type="vmorderstates" multiple="multiple" label="Order Statuses To Report" description="List of Order Statuses to count towards totals" />
And add <folder>elements</folder> to the <files> section
2/.
Add folder /elements to /administrator/modules/mod_vmsynthdashboard folder.
and create a file called vmorderstates.php
paste this into that.
<?php
// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die( 'Restricted access' );
jimport( 'joomla.form.fields.list' );
class JFormFieldVMOrderStates extends JFormFieldList {
/**
* Element name
* @access protected
* @var string
*/
var $_name = 'vmorderstates';
protected function getOptions() {
$lang = JFactory::getLanguage();
$lang->load('com_virtuemart',JPATH_ADMINISTRATOR);
$db = JFactory::getDBO ();
$sql = $db->getQuery(true)
->select('order_status_code,order_status_name')
->from($db->qn('#__virtuemart_orderstates'))
->where($db->qn('virtuemart_vendor_id').'= 1')
->where($db->qn('order_status_code').'<> \'I\'')
->order('ordering');
$db->setQuery($sql);
$orderstates = $db->loadObjectList ();
$options = array();
foreach ($orderstates as $orderstate) {
$orderstate->order_status_name= JText::_ ($orderstate->order_status_name);
$options[] = JHTML::_('select.option', $orderstate->order_status_code, $orderstate->order_status_name);
}
return $options;
}
}
3/.
Open administrator/modules/mod_vmsynthdashboard/helper.php for editing
In the function getXMonthSells (around line 22)
add the following:
$vmorderstates = $params->get('orderstates', array('C'));
$orderstates = "";
for( $i=0 ; $i < count($vmorderstates); $i++) {
$orderstates .= "`order_status`='".$vmorderstates[$i]."' ";
if ( $i < (count($vmorderstates)-1) ) {
$orderstates .= "OR ";
}
}
and alter query statement around line 69 to be:
$q ="SELECT `order_total` FROM `#__virtuemart_orders` WHERE ( $orderstates ) AND SUBSTRING(`created_on`,1,7) = '".$q_date."' " ;
That's it. Enjoy.
I've attached a screenshot of the settings with the altered code.
[attachment cleanup by admin]
Great 8)
I just added your changes to the archive.
Thanks a lot, very usefull, I'm sure it wil please many.
Thanks guys works great, with this fixes is even better,
You're both welcome :-)
Quote from: nordmograph on September 18, 2012, 15:40:30 PM
http://www.nordmograph.com/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=58 (http://www.nordmograph.com/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=58)
Quote from: nordmograph on February 04, 2014, 16:28:39 PM
Great 8)
I just added your changes to the archive.
Thanks a lot, very usefull, I'm sure it wil please many.
That's good, but url to archive in first post of your thread isn't correct.
Thanks Maxim for reporting.
The site has moved to a subfolder.
I just fixed the url in the first post.
here it is again
http://www.nordmograph.com/extensions/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=58
Bugfix update: on the 31st, months names were mistaken.
Happy 2015 everybody!
Our VM Synthetic Dashboard admin module just got a great update.
2 new charts have been included!
- In addition to the sells and orders charts, we introduced the AVERAGE BASKET Chart
- Also we included a COUNTRIES or CITIES GEOCHART (+ table) of the regions of the world that generate the most orders.
Give it a try.
http://www.nordmograph.com/extensions/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=61&virtuemart_category_id=4&Itemid=58
Hi,
I've installed your module, but it shows some errors in first tab and only shows 2 tabs... Can you help me?
Thks
I think there is a little bug with the time, It doesn't take it from vm neither from joomla. We have a 2 hour difference from the real time when the order is created.
hi Aprodrigues,
The chart error messages show because the module find no orders to render data.
Hi Lindapowers,
The order date is taken from the VM table #__virtuemart_orders.created_on
Hi nordmograph,
Thks...
And why it only shows 2 tabs instead of 4? Same reason?
Hi,
I just to let you know I updated the module to 1.9.4 , adding Trends concept to current month graph and table rows (orders & sells).
Thanks, just 2 little bugs:
mod_vmsynthdashboard/css/style.css is missing and is loading PHP which can break session.
GEO chart by cities hides module tabs.
Hi Lindapowers,
The missing css file has been fixed in a recent version. Make sure you have the latest 1.9.5
I'll have a look at the cities issue.
Thanks for reporting :)
Hey ..
when I want to use GEO Chart, a map would show up, but without results and throwing following error: "Google Maps API error: MissingKeyMapError"
how to add the key?
thanks for help!
Nice catch, Since June 22nd and API Key is required for the Geochart on new sites.
I added an APIKey field and updated the call to the most recent chart library.
Update to 1.3.2.
Hi, just a little note about this super useful plugin.
In the tab "Latest shoppers" the data shown is latest registered shoppers and the guest orders do not appear.
Pretty sure you are aware of this anyway I guess is more sneaky to show the orders as guest also.