Dashboard orders this month

Hi,

Which version of HikaShop were you using before ?
We didn't change anything to the dashboard since April 2021, so if you had a more recent version of HikaShop, updating HikaShop shouldn't change anything, which might point to another issue.
Also, looking at the code on our end, it still looks correct:

		$ret['sales_sum'] = array(
			'slot' => 0,
			'order' => 1,
			'published' => 1,
			'class' => 'hkc-lg-3 hkc-sm-6',
			'label' => JText::_('HIKA_STATS_ORDERS_THIS_MONTH'),

			'format' => 'price',
			'type' => 'tile',
			'tile' => array(
				'icon' => array('type' => 'fa', 'value' => 'credit-card'),
				'view' => hikashop_completeLink('order&task=listing'),
			),
			'vars' => array(
				'DATE_RANGE' => 'past.month',
			),
			'query' => array(
				'get' => 'list',
				'select' => array(
					'SUM(hk_order.order_full_price) as value',
					'hk_order.order_currency_id as currency'
				),
				'tables' => hikashop_table('order') . ' AS hk_order ',
				'filters' => array(
					'order_type' => 'hk_order.order_type = '.$order_type.'',
					'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'),
					'order_created' => ($created_status ?
						'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})':
						'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'),
				),
				'group' => 'hk_order.order_currency_id'
			)
		);

Hi,

That's really strange. I don't see how that could be possible.
Could you provide a backend and a FTP access so that we could check the situation ?

Hi,

I've created a mass action for you to see the orders taken into account since the beginning of february :
i.imgur.com/RkjXMoi.png
As you can see, all the orders there combined give the total amount 2437.47
And that's the exact amount I can see in the dashboard, after changing past.month to this.month in the code with the FTP access provided:
i.imgur.com/pZXzz90.png
So to me it works just fine.

The problem is probably what you said "The amount for februari should show € 451.85". I suppose you manually looked at the orders in the orders listing. However, the problem is that you're not not looking at the same thing. On the orders listing, the date you see is when the order was created (order_created). The date taken into account by the statistics is the date of the confirmation of the order (order_invoice_created), when the order was paid. As you can see in my screenshot, half of the orders taken into account for the sum were created in January but paid in February. And that's why you get that huge difference between what you expect and the number you calculated by HikaShop.

That's actually the main reason why we chose to use past.month (the last 30 days) instead of this.month. Because merchants would come to us telling us the number was wrong when in fact it wasn't.
With past.month, it's always the last 30 days and thus it's more consistent with what they believe the number should be.