Importing: Autocommit=false or use of Mysql, LOAD DATA IN FILE

[david71076]

Hi all.

 

My excuses if this topic is already created, maybe not the next procedure:

 

I have to upload a catalog products of 10000 products aproximately, then i need to know the fastest way do it daily, because the catalog change with this frecuence, then my questions are:

 

1) There is any way to set autocommit = false, just for uploading products? How can i do it. 

2) I was trying to do a CSV export / import using LOAD DATA IN FILE procedure from mysql but i have not clear the tables to export import without affect prestashop right functions.

 

Any help about this topic, could be very apreciated.

Thanks very much.

David