How can I update image field in items by categoryid with a query?

(0) Share

Report

Posted on by Bob Johnson

624

I need to help out the ordering dept by populating the image field in items. I want to run a query that would use ILC and add .jpg to it and insert into the image field. I would need to be able to select by category or some filter so I can limit what is being changed. I have seen a post that used this command is this correct?

UPDATE dbo_item.image SET dbo_item.image = "C:\IMAGEPATH\" where categoryid = xxx

Also is there away to rename a current ILC in bulk? Like ILC "028" to "B028" by supplier or some other meaningful filter?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

TimB 1,175 on at

Like (0)

Report

Re: How can I update image field in items by categoryid with a query?

Hi, you need to set the path to the pictures in SO administrator. File --> Configuration --> Paths --> pictures field. No, the query in your post will not work. You could use the following, it should work.

UPDATE item SET picturename = itemlookupcode + '.jpg' where categoryid = xxx

If you know the category name and not the id, you could replace this query with the xxx in the previous query including the parenthesis. (select id from category where name = 'CategoryNameHere')

Was this reply helpful? Yes No