Problem exporting

[url of the page with the problem] : http://liveelite.co.uk
[HikaShop version] : 2.2.0
[Joomla version] : 2.5.11
[PHP version] : 5.3.24
[Browser(s) name and version] : Firefox 22.0
[Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen?

Thanks

Alex

Hi Alex,

How do you export your product?
If you don't select any product in your backend product listing then it export everything in one time.
I guess this is the solution to export your 1500 products

Hi Eliot,

Sorry i wasn't referring to the products i was referring to the orders. What we do is export the orders each month and then send this to the suppliers. However i am having difficulty exporting these orders as it only displays 100 at a time.

Thanks

Alex

My bad!

In this case I would suggest to use our brand new mass action system.
You can find this feature in System>Mass Action, it allow you to create a csv of orders really easily even with some filters.

i hope it will fit your needs!

Thanks Eliot.

I seem to be getting further this way, one thing though, we have 15,000 orders so far which takes a long time to process so i set the limit to 3,000 orders, however this gives me the first 3000 orders. Can i set it in any way so that i get the 3000 most recent orders rather than 3000 first? Or do i need to set the start limit to say 12,000 then run the process?

Regards,

Alex

Indeed setting a limit is a good idea (plus this system is quite convenient to use).
What you have to do is simply change the value of the "start" field. Set it to 0, then 3000, then 6000 (if you have a limit set to 3000) so it will export the orders from where it stopped

I agree, this is a great system, you guys really do provide the best products and support!

Thanks!

Please can you look into why i am getting duplicates on the export?
Is this because of hikamarket? We have changed the setting on there to use same order number throughout however this export seems to just be giving us a duplicate.

Are you sure there is no way we can export the old way as this didnt give us duplicates. Otherwise we need to go through 1500 orders and de-duplicate each order.

Thanks

Alex

Hi Nicolas,

Thanks, this doesn't seem to retrieve any data, can you confirm that it is correct (attached).?

Many thanks.

Hi,

I confirm that this is correct, but because you added a filter on the order type, you have less orders returned than before, so you have probably to change the limit start.

Hi Xavier,

This has now worked, thanks, do you know why the '£' has an A with an accent above it on export?

Thanks

Alex

I think it"s the encode format which is not read as expected by your csv reader.
Try to open the csv with another program and see if there is still the A with accent.

It is set to be an excel export, which when opened with libre or calc still shows the 'A' at the beginning.

Thanks.

We have corrected the export on our end, because the currency should not be displayed in the price field.
So we removed it from the csv export.

It will be available in the next release.

To correct that problem now, you have to replace:

						if($element->$column->currency != '0' ){
							$currency = hikashop_get('class.currency');
							$square = $currency->format($element->$column->value,$element->$column->currency);
						}else{
							$square = $element->$column->value;
						}

						if($element->$column->currency != '0' && JRequest::getVar('from_task','displayResults') == 'displayResults'){
							$currency = hikashop_get('class.currency');
							$square = $currency->format($element->$column->value,$element->$column->currency);
						}else{
							$square = $element->$column->value;
						}

JRequest::setVar('from_task','exportCsv');