Easy export order details for accountant

Hi, I played a bit with the Reports function. It looks like you can create great things with it for the Dashboard, but it isn't really an export tool (although it has an export button). Am I right about that? Let me explain my needs: my client wants to be able to export some basic details of the last order to a XLS of CSV. He wants to use that file to get the sale in to his accounting system (Exact online). There's no automatic way to do this, that's why we are looking for the options with an export.

When I use the export button of Reports a get a CSV with 62 columns, most of them I don't understand. I just need the customer details (name, address, et cetera) and the order details (bought products, total price, et cetera). Is there something like this possible. Best way would be an export tool where I can select the items (fields) I want to be exported.

Thank you, I will look into that. Didn't realize mass actions could be used for that.
Any chance of having a connection with Exact (used by more then 50.000 business owners) in the future?

Mass actions is nice, but I miss a few things. Maybe I'm not looking at the right place, maybe it's not there. If so, see it as a feature request

1. I want the CSV or XLS file only to be filled with the last order. I cannot filter for 'last order' or 'last x orders'
2. Is it possible to mail the created file instead of putting it somewhere (export path)?

Hi,

Actually it's not possible. But I just have added this possibility, it will be probably in the next release. (2.3.1).
If you want this modification, you have to edit the file "administrator/components/hikashop/classes/massaction.php" and add:

	var $ordering = '';
	var $direction = '';

	var $value = 500;

		if(!empty($this->ordering)) $query .= ' ORDER BY '.implode(',',$this->ordering);
		if(!empty($this->direction)) $query .= ' '.$this->direction;

return $query;

	function onProcessOrderMassFilterlimit(&$elements, &$query,$filter,$num){
		$query->ordering[] = 'order_id';
		$query->direction = 'DESC';
	}

Thanks for the support, I think I will wait to the next release, especially creating the plugin is beyond my scope

Not being able to mail the results is something I can solve in other ways. I see I can configure an export path. What's the default path and what should I put there to change that? More important: will the function create a unique filename? I mean, when I use a trigger (order created for example) and a report is created and put in the export directory, it has a file name. What if it's triggered again, will it overwrite the current file (BAD) or will it create an extra file (GOOD)? Best way would be to have a unique file with date and time or even better order ID. Just thinking ahead

I have not put anything in the export path field, so I expected to find a hikashop_export.xls in the root ( www.domain.com/hikashop_export.xls ). But I can't find anything. Doing something wrong?

Hi Nicolas,

1. Do you have any idea when the new version will be available and if the above mentioned options will be in it?
2. I talked to you about Exact, an accounting system that is used by many thousands of people. There are other webshops that have made plugins / connections to make data transfer between the webshop and Exact possible. For me, I think not having this option in Hikashop is a big disadvantage. Is there any chance this will be addressed in the near future?

Any news on the new version?

Hi there,

The last version has been released on May 14 but the auto-update is not activated yet.
You can download it from your user account or on the website for the free version though. Do not hesitate to give us feedback if you encounter any issue!

Hi, I just installed the new version. Lot of improvements, nice!

But.... this topic was about one asked improvement:
1. I want the CSV or XLS file only to be filled with the last order. I cannot filter for 'last order' or 'last x orders'

I can't find it or don't understand how to get this working. Can you help me (and others) a bit?

Hi,

You have to set your mass action like that:

Thanks, this is working. Last question. I want the created file to be exported to /lastorder (protected directory).
I tried in the export path /lastorder and lastorder (without /) but no result.
What shoud I type in exactly to get this working? You told me path from website root, but that's what I did (didn't I?)

Hi,

The path from website root is for example /var/www/mysite/lastorder

Sorry, but I don't get it working. When I log in to the shell, go to the right directory and give the command PWD (print working directory) I get /home/company/public_html/lastorder as answer. But when I use that and let Hikashop process the bulk action nothing happens.

Could it be going wrong because it's a password protected directory? I did that on purpose, because I don't want customer information public available.

An email option would still be great

I think that it's not working because of the password protection. Maybe folder permissions are not correct too in order to allow HikaShop to write a file inside.

Thanks to try in a not protected folder, with writable permissions.

Yes, email will be great, still on our TODO list