Uploading Products through CSV excel sheet - Site loading very slow

Question

we bought magento extension for uploading the products through excel sheet.

we are uploading Products using csv file.

But when we are uploading the csv file , its taking more time to upload.

At the time of uploading, site will load very slowly and backend will not open

Is it the problem with the extension or with the server.

What steps we need to take solve these issues

After a quick search in google

1)we did Truncating log tables

2)Delete not required attributes

3)change Index Mode to Manual update

4) increased server requirements :

OS: Ubuntu Server Edition 
Server: Apache
RAM: 16GB
Hard Disk: 160 GB SSD

what else we need to do to speed up the uploading.

please give me some tips to speed up. because we are struggling a lot for this.

Giuseppe · Accepted Answer · 2015-11-27 13:21:08Z

0

I suggest the use of the MAGMI importer

if used properly is the fastest method I know to import products in magento

answered Nov 27 '15 at 13:21

Giuseppe

1,1138 silver badges11 bronze badges

fine, but for some reason we have to use the extension. – user33510 Nov 27 '15 at 13:39
In this case I suggest to optimize first the mySQL configuration files specifically for magento, you will find a lot of articles on google. – Giuseppe Nov 27 '15 at 14:49
than i will try that..... – user33510 Nov 27 '15 at 14:54

add a comment |

1 Answer 1