Report Generation - Item Sales by Date Range, with Tax in separate column.

Hi,

1. I don't see a way to do that in one screen.
The number of items sold for each product is something used for your own statistics, marketing or even inventory.
The taxes collected is something used for tax reporting.
Having a screen to get the taxes collected for each product in a period doesn't usually make sense for tax reporting since normally you just enter the total amount in the papers you give to the administration.
If you want to get a total of the tax collected for each tax rate over a particular period, you can access the "manage tax rates" button of the System>Taxes menu. It's done especially for that.
And if you want to get the number of items sold for each product, you can configure a report in the menu Orders>Reports.
But doing both at the same time is not possible with the default views of HikaShop.

2. That's not a problem of the export. That's a problem of the CSV reader tool you're using (or the way you configured it) which doesn't handle the comma as a separator. If you use LibreOffice (the free equivalent to excel) it will handle the commas properly.
For Excel, it depends on the version you're using, and your locale. So versions handles the comma by default, some the semi colons, and there is usually a setting to change that.
Also, in the HikaShop configuration, there is a setting in the main tab, in the files section to change the CSV separator. So you could change that setting too.

Hi,

Can you provide a screenshot of all the settings of your report ?

Hi,

Ok, I see what you mean.
Well, it's not really a bug. When you select "sales" under the "specific options" area, it gives you the total amount of the sales for the products.
When you select instead "orders", it gives you the quantity. As an added bonus, on the displayed listing, we also display the total amount as we can easily have it, but it's not the focus in such case. That's why it's not included in the CSV export. But we could of course add it to the CSV, it's just a matter of changing a bit the code.
We'll add that for the next version of HikaShop.
If you want to do it before then, you can change the code:

$widget->exportFields=array('order_product_name', 'Total');

$widget->exportFields=array('order_product_name', 'Total');
						}elseif($widget->widget_params->product_data=='orders'){
							$widget->exportFields=array('order_product_name', 'quantity', 'Total');