3

Magento2 large CSV file was not successfully imported.

I am trying to import 20 Mb products CSV file but was not imported successfully. Still it says "please wait" only.

I have also changed upload_max_filesize = 20M and post_max_size = 20M in php.ini file and other settings as follows.

max_input_time = 300
max_input_time=300
max_execution _time =300

Need help

Improve this question

3 Answers 3

Reset to default
2

we were facing same issue when importing customer infromation it was like 13000 rows, it worked when we split files of 1000 rows.

a bash command that helped to split quick is:

split -l 1000 mybigfile.csv

but you have to add the csv headers to each file.

Improve this answer
0

Hi please set max execution time 18000
try using collection of 500 product in one csv files , mens at time import 500 then next 500. it work fine try it.

Improve this answer
6
  • it is possible to add 22,000 products at once in Magento 2 ??? Need help
    – kamal
    Commented May 3, 2017 at 12:57
  • no it create issue like time out , so its advisable to import 500 or 1000 product at time
    – Navin Bhudiya
    Commented May 3, 2017 at 12:58
  • But im increase my execution time any possible to bulk import plz Ans
    – kamal
    Commented May 3, 2017 at 13:05
  • no i dont think , as per my experience not possible
    – Navin Bhudiya
    Commented May 3, 2017 at 13:13
  • Bro may i know your working Magento2.0 or Magento 1.9
    – kamal
    Commented May 4, 2017 at 3:38
0

When you import large files you shall consider to import them by the command line.

Magento 2 Import Performance could give you a hint how to get started with it.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.