I am having issues with being able to import listings in bulk. I am have increased max_execution_time to 40 minutes but import process stops after after roughly 4-5 minutes and nothing happens. I’ve cut down my file size down to 5 rows and it is still not working. it just spins for 2-3 min then page refreshes and nothing happens. I tested with just i row in the file and that does load but it takes roughly 2-3 minutes. Any suggestions on how i can solve this. Thank you
I’m having the exact same issue. Looking at my logs it looks like it’s related to importing the images and processing them for thumbnails etc. You can try increasing your php memory limit as that is what is causing my import to fail currently. You can also reduce your php concurrency to possibly lower the amount of memory being used at any time, however this will slow down the import even more!
huxhamjphoto Thank you for your reply. I am not even trying to upload images my upload file contains image path for all images which i am ready uploaded via SFTP. I will try increasing php memory and see how that goes.
1 Like
@ihor any suggestions on how i can get this working better. Importing 2-3 listings at a time is really ideal. increasing memory limit and max execution time didn’t really make any difference. Are there alternative ways of being able to mass upload listings? Thank you
Hi,
I recommend testing this for a single listing without an image, importing a single listing shouldn’t take 2-3 minutes - maybe this is a delay for loading images from third-party URLs.
We also plan to update the Import extension to resolve the max_execution_time limit.
Hello Ihor
I am not attempting to load any images. All images already loaded directly via sftp. I am simply loading a flat CSV file. I attempted a single listing and it take roughly same amount of time as loading a file with 4. if i attempt 5 rows or more it just times out. Is there a way to somehow import listing directly into DB? Thank you for your help.
Dmitri have you tried without any images specified at all (even ones already uploaded)? The issue I was having was also images already uploaded via SFTP being processed by imagick during import - creating thumbnails etc. Try the import with no image urls at all.
I have not attempted that. Is there a way to add image url’s after file upload without having to go through each listing individually? Thank you
Even if the image is on the same server, the Import extension access it via the URL set in the CSV file and uploads it to WordPress media (while WordPress also generates images for different sizes), so there may be no difference whether it’s a third-party website or the same server. It shouldn’t take this long though, please try importing listings without the Images column at all, this will help to detect if the issue is related to processing images.
Unfortunately there’s no way to skip the WordPress processing and use DB directly, only if listings are being exported from another WordPress-powered website built with HivePress, then it would be easier to move the database itself by exporting/importing SQL.
Thank you Ihor. Do you think its worth exploring uploading listings via API method or would i encounter similar issues?
If you mean WordPress REST API, it may be a bit faster, but would require mapping to the post meta fields and taxonomy terms (listing is a custom post type). If you have WP All Import you can try using it as an alternative, it also requires mapping CSV columns to meta fields and taxonomy terms (this is how listing attributes are implemented), you can find more details here Import from another directory theme of Attributes - #4 by andrii
Thank you Ihor! I will give both of those options a try. I appreciate your help with this.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.