Ecommerce and Excel

[sunniebrowne]

Hi all,

I need to import 1000s of images to my website via a CVS file. all saved images are saved locally as the product reference number however i need to create a URL for local images and inset them into the same row as the product. Anyone go any ideas on how i can solve this?

Example

Untitled.png
Untitled1.png

some product contact multiple varents of colour and sizes and would create URLs for all with some indication to the product then insert the URL into the Product Image Colloumn in one cell and ";" to separate the URLs?

Hope someone can help.

[6StringJazzer]

all saved images are saved locally as the product reference number

I don't see anything in File Explorer that match the SKU numbers in your data.

Your file explorer is set to hide file extensions. What are the extensions on the image files?

some product contact multiple varents of colour and sizes and would create URLs for all with some indication to the product then insert the URL into the Product Image Colloumn in one cell and ";" to separate the URLs?

Are you saying that the URLs for all variants of the same product must be in the same cell? How can you tell which rows are variants of the same product?

Can you show an example of what you want the result to look like? Example should address all of the above issues.