Import Products run forever

[ahamdycrafa6c5]

Hello guys,

When I try to upload bulk products using the (Import) method, the products are uploaded successfully but the website is showing the upload loading icon is loading forever and don't show me the results at the end, if it's a success or there are some errors.

My magento2 admin session is very high and my server max_exeuction_time is very high too.

My server specification is (8 CPU + 32 GB RAM).

It's working fine if I uploaded in less than 1500 Products in the CSV file but once I exceeded the 1500 Products, it doesn't stop loading.

Check out these screenshots please:

https://prnt.sc/u8e2nb

https://prnt.sc/u8e2et

[Manish Mittal]

@ahamdycrafa6c5 

You can do 2 things:

1. Set indexer for products to be Update by schedule (schedule). So it will not take time during importing products.

2. Check error logs what error you are getting during upload, it can be server/ Magento logs. 

[anantprajapati]

Hello @ahamdycrafa6c5 

Can you please check on server log. May be you can get the some deadlock due to multiple process on database.

If my answer is useful, please Accept as Solution & give Kudos

[ahamdycrafa6c5]

---

@Manish Mittal wrote:

@ahamdycrafa6c5 

You can do 2 things:

1. Set indexer for products to be Update by schedule (schedule). So it will not take time during importing products.

2. Check error logs what error you are getting during upload, it can be server/ Magento logs. 

---

1. I don't have an issue with the indexer as it's not running during the importing, it run only when I do it manually.

2. Could you please tell me which log file I should check during my importing products?

[ahamdycrafa6c5]

---

@anantprajapati wrote:

Hello @ahamdycrafa6c5 

Can you please check on server log. May be you can get the some deadlock due to multiple process on database.

If my answer is useful, please Accept as Solution & give Kudos

---

Could you please tell me which log file I should check?

[Manish Mittal]

@ahamdycrafa6c5 

can you share admin indexing screenshot. Apart from that you just check Magento logs (system.log, exception.log or any other log generating during that time) and Server logs(apache error log)

[anantprajapati]

Hello @ahamdycrafa6c5 

If there is no any error showing in <magento_root>/var/log/system.log or <magento_root>/var/log/debug.log or <magento_root>/var/log/exception.log 

Then please try to check in Server Log like if you use Linux then it should be under /var/log (this is not magento /var/log). you can find the hint from there.