import csv products extremely slow

[pduke7]

Hi !

i am transferring products form old oscommerce using presta 1.6.1.6 import with csv. i have about 4500 products.
the nature of the process demands multiple csv imports.

the first import with ids, names etc was fast(first time adding 4500 rows)

as soon as i started repeating the process for more fields (for example : a csv only with product IDs and category IDs for assigning categories) the import takes as much as 10 hours for 800 products. and i haven't even started wit photos yet....

 

i tried several php combinations (5.5, 5.6, 7, with or without nginx) but nothing seems to make any difference. except that i get an error when using fast-cgi

server is working kinda cool so it seems to be the process itself

 

is there any fix to make it go faster? or even.... much faster

 

cheers!

[presta.show]

Hi pduke7,

 

Check out this Import CSV & XML Manager Module: https://www.prestashop.com/forums/topic/539577-module-smart-csv-xml-prestashop-import-manager/

[Gipielle]

Same problem

[Pierre_d]

 I had a similar problem with 1.7.2. Had >14000 products to import! I wonder wether it is slow on purpose. I finally bought an import module from Prestashop.addon. Not expensive and much faster.

[presta.show]

Hi,

PrestaShop standard CSV importer using PHP, so if your file is too big PHP crash with timeout - file take to much time to PHP could finish it.

You could increase max_execution_time and max_input_time in your php server configuration to increase PHP runtime. 

Otherwise, if you are looking for universal solution that skip PHP limits, try PrestaShop CSV & XML Import Mnager from prestashow.pl. This module use Ajax and AngularJS to import and update data. Module could run files up to 1000 MB and have a lot of comfortable configurations to boost your import and edit data before they are transfered to shop:

https://www.prestashop.com/forums/topic/539577-module-smart-csv-xml-prestashop-16-17-import-manager/

Best regards,

Artur

Edited January 5, 2018 by prestashow.pl (see edit history)