Phoca Forum

Hi Everyone

I got this error when i wanted to import my products. Now the products is about 28 000. How can i fix this please let me know.

Hi, as written in the error message. On your server, there is no enough memory to complete all the task. I would recommend using standard import/export in SQL (e.g. in phpMyAdmin or Adminer) in case you have so much products in your eshop.

Jan

Hi Jan

is there no way i can make the memory much larger for it.
the standard import export in sql can you explain n bit more about it please

Hi, it depends on your server, you can make the memory larger on your server. But hard to say if this will be enough. The recommended way for importing/exporting items is the database way. There is no specific guide for this but it will be similar like migrating:

https://www.phoca.cz/documents/50-phoca ... o-joomla-3

1) exporting database data
2) copying image/download and other filesystem data from old site
3) importing database date
4) copying image/download and other filesystem data to new site

Jan

Hi Jan

Just tried to make the limitations for the memory unlimited i read that -1 is for unlimited but that also didn't work.
So I have an idea if I take the exported products XML file and say of 10 000 i only import 2500 and delete the rest, what I'm saying is import it in parts and not a whole anymore do you think it will work.

but anycase I'm going to read these documents you send in the link thanks for them.

BTW in some days, this extension: https://rolandd.com/products/ro-csvi should be ready for Phoca Cart too (the development version). So this can be even some way

Jan

Hi Jan

Thanks for the info, will read up on it but it looks really interesting.

Have a fantastic day.

Ok