Bulk Upload Alternate Images?

[draneb]

Hello,

I have about 700 products in one category that all need the same 6 alternate images added.
Would someone be able to suggest the best method for doing this?

Thank you very much!

[euroluxantiques]

I populate my additional images into ac_ProductImages directly via SQL. I've been doing it for a couple of years like this, and it hasn't seemed to hurt anything.

I would just use an insert statement like:

INSERT INTO dbo.ac_ProductImages ( ProductId, ImageUrl, ImageAltText,OrderBy )

SELECT a.ProductId, [Link to Image],[Alternate Text],[OrderBy, e.g., 1-6]
FROM dbo.ac_Products

Run this for each image you want to post.

Hope this helps.