Import Time Out

  • Posts: 47
  • Thank you received: 0
7 years 5 months ago #270994

-- url of the page with the problem -- : unicomms-emall.com
-- Error-message(debug-mod must be tuned on) -- : Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/html/shop/administrator/components/com_hikashop/helpers/import.php on line 725

Hi everyone,

When we try importing products from CSV files, we are getting the following error message

Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/html/shop/administrator/components/com_hikashop/helpers/import.php on line 725

We used to get this error message before, but when we reduced the number of products per CSV file to 500, the import ran well. However, after exceeding 10,000 products we are getting this error even when we reduce the number of products to 50 per CSV.

All php timeouts have been set to 0 (unlimited) as indicated in the above error message.

Why is importing from csv taking such a long time and how do we overcome this problem?

Include is a sample CSV file that we wish to import.

Thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 5 months ago #271081

Hi,

If you were setting it to unlimited and that was really taken into account by your server, then you wouldn't have that error message since it can only happen when the processing reaches the limit and by definition, unlimited doesn't have a limit.
So I suppose that you still have a limit.
Instead of 0, try a big value.
Also, HikaShop can import products data really rapidely and even with 10K products, it should only take a few seconds. So that means that you have something else in the CSV which takes time.
For example, if you have image URLs in your CSV, then each time the CSV is processed, HikaShop has to download each image, and for each one, it can take several seconds or even 10s of seconds if the image is big. So if you have image URLs, try to upload them separately in the images/com_hikashop/upload folder of HikaShop and instead have their relative path in your CSV.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum