Import error 28 000 Products +-

[s4evision]

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.

[Jan]

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

[s4evision]

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

[Jan]

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

[s4evision]

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.

[Jan]

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

[s4evision]

Hi Jan

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

Have a fantastic day.

[Jan]

Ok