CSV files, is there any further tips to import large amounts of products?

[Paulw01]

Hi there.

My server settings are ok. Unicode set on import - csv corrrect - delimiters correct.

I have 3500 products with image urls
I have 2000 categories

I cannot upload the csv file 1,653 kb in one go? I've had to break it down into 27 files to upload in order to prevent timing out. This whole upload process takes 4 hours after all the messing around etc with different files and waiting for uploads.

I've read / been advised that the import section on presta needs optimizing?, however, I see some people have huge csv / product amounts and don't suffer import problems? Is there something else that can be done to improve importing ? Would anyone be willing to reveal any more tips ?

Many thanks
Paul

[Paul C]

Paul,

The problem isn't the size of the CSV file, but the time it takes to process the images - that's what eats up the CPU time. The best way of doing it would be to install a local server on your pc (e.g. XAMPP) and build the store database on there (you can disable the timeout completely that way) and then do an export from your local database and import into your production database. Don't forget to ftp the product images from the /img directory too, of course as they'll have been thumbnailed and renamed to new files in there.

Just make sure that the config for the local install matches the one on your production database (except the url, and database connection details which will be different - modify a copy of your settings file from the production install as a template for your local one).

Paul

[flotl90]

I am running Prestashop Version 1.2.0.8. I want to export my products intu a CSV file and then migrate to last version and import them. How can i do that? The export of products is a safety mesure.