Increase Connection Timeout For Product Import

Hi All,

I am using NopCommerce 4.10
I have around 150 products which I am trying export change its stock quantity and then import the same.

On the local system with debugger on it works fine but when I put it on the test server it gives the "Connection Timed Out" error.

My First question is "Is this error due to SQL connection timeout or the application timeout"
Second question "How to I increase this timeout?"


Thanks for your help in advance

Please check the System Log to get a more detailed message.
150 products is not a lot that you should be getting a timeout.  Where is the SQL server with respect to the IIS site? (same PD?  within the same local network ?)  Are you using Azure?

The SQL and Application is on the same server.

We have deployed on the AWS server.

The Application is hosted on the IIS server.

I tried uploading 10/20 product and that works.

But throws the timeout error after 30 seconds if we tried higher number of products.


I tried changing connection string by adding "Connection Timeout=1000;Connect Timeout=900;" but that didn't worked also.

Do you what to do to solve this?

Anyone knows how to do this?

can you please try with below link ?
https://www.techcartnow.com/increase-timeout-asp-net-application/


set executionTimeout higher value(>1000) to check.

Tried all the steps but still it doesn't works.