Hi all, I was asked to import in Prestashop a list of products that are provided as a single CSV file, this file is exported by a dealer and accessible by FTP.
I should read that file and import in Prestashop, that file updates each day and is around 8000 rows and many of them are up to 14k, because each row contains: description, image urls, nested categories up to 5 sublevels, etc. It's a bit of a nightmare...
My idea is to to write a parser in PHP that generates intermediate CSV files (like 1 for categories, 1 for products, etc) and then setup crons to manage all the automated import process.
Since now I have managed to extract all the category tree in a CSV and import in Prestashop, the number of categories are 401 in this moment.
The process is very heavy and slow and and I am afraid that with 8000 products I will end up in a failure.
My question is if (from your experience) to import all that amount of data each day is a feasible task or if is an impossible mission.
I also thought to restart with a different approach: to write all that data in MySql tables and then in some way write them directly to the prestashop tables but is going to be a lot of effort.
I don't know what would be the best solution for automating that import process...
Thanks for any suggestion.