Timeout on import

[SULTD]

I have been trying to import my products into Prestashop via the import csv option.

I can happily import 10 products, 100 products, 150 products but much above that and I get a long delay then a HTTP 405 Method Not Allowed error on the webpage.

I've talked to my host (Hostgator) and they say this is due to a Prestashop issue.

 

So, before I go back to them again can anyone help back me up with either a solution or more information that I may take back to my hoster?

 

 

[SULTD]

Anyone able to help with this?

[wdburgdorf]

old issue: https://www.prestashop.com/forums/topic/254206-prestashop-csv-import-problem-import-of-more-then-100-products-seems-like-mission-impossible/

[bellini13]

So when you encounter the issue (which i believe is a timeout issue), are there any products that are imported?  If the answer is yes, that means Prestashop is working properly, and that your servers configuration does not have the resources or settings that will allow a 'long' running script to execute, which is very common issue with shared hosting environments.

 

A 405 http response is misleading, as this is typically reserved for when the server does not support a very specific HTTP METHOD (like GET, POST, HEAD etc..)

 

If 50 or 100 products work properly, then obviously the server supports the required HTTP METHOD (POST).  If 150+ does not work, it is not a 405 issue, as we already proven that the server accepts the POST method.  My guess is that the server is killing your long running process before it can complete, and then redirecting your browser to this 405 error page.  If that turns out to be true, then this is something you host needs to resolve for you, or you need to find a new host.  Just be prepared that you get what you pay for.  Don't expect a shared hosting environment to provide you with unlimited resources, there will always be some restrictions...

[wdburgdorf]

Yes, bellini13, it is exactly as you say, thanks for your comments. It is cheap hosting, so it does not have sufficient resources for such an import. But otherwise it is quite sufficient and I don't want to move to a different hosting just for this import. Would it not be possible to write a php script that is able to import many products even with low resources? Even if the import takes a lot of time.

 

I now used the Prestashop Manager (https://www.prestashopmanager.com/) for the import. 20 seconds for almost 460 products (had to do it 4-5 times before everything was right...). It even has a free trial period of 30 days, so at least this first import came free. Unfortunately the csv has a slightly different format than Prestashop standard, but that was easy enough to adjust.