[SOLVED]CSV import: 1 New product is fast, 1 old product is slow

[tanasi]

Hi, 

I am trying to troubleshoot csv import speed and I need some help. 

Here are some facts:

• Prestashop version 1.6.1.18
• The shop has 5000 products. About 1000 are active.
• When i try to import new products the import is fast. Trying for example with only one product and the following fields: Name, Category the loading finishes in a fraction of a second. The product URL is created based on the product name  (there is a warning saying that the url has been created but everything is fine). 
• If I want to modify an existing product and use a CSV with only one product and the following fields: ID, Name, Category the loading is more than 3 minutes. Trying to load more that 1 product increases the loading time.. exponentially..

 

Any ideas on how to fix this?

 

[tanasi]

I think I have narrowed down the issue. Writing it down here as it might help others.  

I enabled profiling and it seems that a module that I have for mailchimp integration might be the issue. Disabling the module makes loading a 1-line csv for existing products finish in a second. 

Going to contact the developer now.. 

[PPSA]

You are 1000% correct in saying this
I battled for days thinking its something on my server
I disabled Mail Chimp module and boom, its working like normal, imports within 10-15 seconds