Automating New product Images

[AndyBorrett]

I have a folder within the site1 folder called Images. Within this folder are three more - Small, Large and Thumb.
All my images are in the format XXXXXXXY.JPG where XXXXXXX is the product code (I use my own product codes) and Y is either T for thumbnails or L for large.

Is it possible to automatically fill in the boxes for Image paths when adding a new product rather than having to type or browse for the image every time I add a new product?

I was thinking along the lines of either a customer variable or maybe a Query in Access.

Any thoughts?

[cdicken]

You could use code like this:

<img src="NETQUOTEVAR:PRODUCTREFERENCE_t.jpg" />

Which would work fine online - the problem is that you need to get the files uploaded to the website - which will mean browsing for files - either in the product dialogue or in 'Advanced | Additional Files'.

[NormanRouxel]

I you really need this (as Chris mentioned) then upgrading to V8 would allow this to be automated. V8 automatically uploads any images it finds in the generated HTML.

[AndyBorrett]

Neither method is ideal for me so I have been playing with Access query's and having some success.

If I manage to get it working correctly I will post it here.