Use existing images when import products

Hi @samysalahgad

I understand your concern about the slow import process when using CSV files, especially with images.

If you have already uploaded your images to your server, you can certainly use those existing images during the import process. In your CSV file, you’ll need to specify the exact path to the images in the “Images” column. The path should be relative to your server’s “wp-content/uploads/” directory. For example, if your image is in a folder called “products” in the “uploads” directory, the path would be “products/your-image.jpg”.

If the image URL is not found or is incorrect, WooCommerce will attempt to download and rename the image, which might be causing the issue you’re experiencing.

Please try updating your CSV file with the correct image paths and import again. If you’re still having issues, please let us know.

@shameemreza I like the idea ??

Another issue maybe reason for slowdown is thumbnail generation and cropping during import

Anyway to disable thumbnail generation during import?

@when importing prodcuts I should define the image url in csv in form of https://www.mywebsite.com/wp-content/uploads/image.png

or it should be like internal folder location /home/mywebsite.com/public_html/wp-content/uploads/image.png

or https://localhost/wp-content/uploads/image.png

Hello samysalahgad

Thank you for your reply.

The thumbnail generation depends on how many thumbnail sizes your theme has registered.
You can control thumbnails at Dashboard → Settings → Media.

If you don’t want WordPress to create additional images at all, you can set the values to “0”.
WordPress will skip any size with that value.
For more details check this blog post I found on the internet.

Answering your question:
– If your site is live then you should use this:
https://www.mywebsite.com/wp-content/uploads/image.png
– If your site is on a localhost then you should use this:
https://localhost/wp-content/uploads/image.png

I hope this helps.
Let me know if you have more questions. ??

Best regards.

@shameemreza sorry but your solution didnt work

Images already saved in the uploads folder ( the default folder for uploads and images ) and images links using my own websitle url

and also imported images from my server to my server and renamed it

The good thing the import process is faster after doing the previous action and also after setting thumnails values to 0, I think thumnail generation while importing was the main problem and caused server hangup

Maybe woocommerce make change when adding or importing products, to process thumnail generation after the whole import is complete, giving more server resources for each process to complete

and checking again

thmbnails also generated even I set all values to 0

I really appreciate your support , but wondering that plugin support reply to my topic without being sure about it

Both things done as you mentioned, and both issues was not fixed and the server stuck again

Images downloaded again and again, thumbnails generated also

Not sure what to say!!!

Hi @samysalahgad

thmbnails also generated even I set all values to 0

You can add this code snippet to your child theme’s function.php to disable thumbnail Image regeneration: https://github.com/woocommerce/woocommerce/wiki/Thumbnail-Image-Regeneration-in-3.3#how-to-disable-background-regeneration

add_filter( 'woocommerce_background_image_regeneration', '__return_false' );

Images already saved in the uploads folder ( the default folder for uploads and images ) and images links using my own websitle url

Can you share a screenshot of your Images column? For screenshots, I recommend https://snipboard.io/ for easily sharing screenshots – please follow the instructions on the page, then paste the URL(s) in your reply.

In the meantime, if you upload images to the wp-content/uploads/year/month/ folder OR wp-content/uploads/product_images/, you can use the filename without the path in your CSV instead of the full URL. More info: https://woocommerce.com/document/product-csv-importer-exporter/#images

Let us know how that goes. Looking forward to helping you.

I added image directly on uploads folder and als created another folder inside uploads folder (product_images)

My wordpress settings not arrange media by date, so all images go to uploads forder

and on csv i added image name “dress.jpg”, i got that error when importing, Unable to use image “dress.jpg”.

Hello samysalahgad,

Thank you for your reply.

For better understanding, could you share the CSV file you use in the import process?
Also, share a screenshot of the directory where you have uploaded the images.
Please make sure the directory path is visible in the screenshot.

This information will help me replicate the issue on my test and diagnose the problem.
Looking forward to your response. ??

Best regards.

Hi @samysalahgad

I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or open a new topic.

Thanks!