Export to XLS on shop with more than 10000 product

-- HikaShop version -- : 2.2.3
-- Joomla version -- : 3.2.3

I have a big shop, so when I try to export it to xls, I have a error:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 1104 bytes) in blabla/libraries/joomla/database/driver/mysqli.php on line 806

Also I have error like this when I made import 10 000 products to the shop. So I made it by splitting big xls file to 4 smaller. But maybe exist more correct way?

Sounds like you're exhausting your server's resources. More likley to be a hosting issue than a hikashop issue.

Hi,

Exactly !

67108864 bytes = 64Mb

It is your PHP memory limitation, like the PHP error message explained.
You try to load too many data from your database and it can't feet into your PHP allocated memory.

HikaShop can't do anything for that.

Regards,

Hi.
But what should I do?
How to work with big shop in xls?

Hi,

One solution could probably be to use he mass actions.
Create an export and set a limit on the products number.
You can for example export them 1000 by 1000.

Hi, thanks. It can be used. Not comfortable, but worked.

Maybe in future Hikashop team will make something like this by automatic script?

Hi,

I put your idea/request in our TODO list.

Regards,