Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
What is the proper way to use the Product Batch Edit.
Basically i want to change the all my products for one manufacture image folder location.
The images will be in the: images/gdr/ folder.
Should i use the "set to" or the "append to"? Currently the images are looking in the default: images/ folder. And what would i enter to make this work correctly?
Thanks |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
update bvc_Product
set ImageSmallFileName = replace(ImageSmallFileName, 'images/', 'images/gdr/')
Same for ImageMediumFileName
And something similar then for the Product Images table :) |
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
Thanks Corneliu:
But, i'm not quite following what I should put in to have it change the folder and still keep the image file the same. Just want to move the images to another folder for organization purposes. Seems like the Product Batch Edit should allow me to do this. |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
I still haven't been able to get this to work for me? |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Dan,
Sorry, I forgot to answer you. Can you give me more details about the change that you want to make (move what folder to what folder) so I can give you the correct SQL.
Regards,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
I just want to be able to quickly change a group of products. Since i did the SF6 to BV conversion, all my images are just referencing the default "/images/" folder for the correct image. I'm planning on doing more image organization with BV than i did with SF6. So i plan on creating different folder for my images. So for example "/images/gdr/" would be the folder all my image for one of my manufactures products will be. So i want to be able to batch change by manufacture or catefory the where it looks for the image without actually changing the image file.
Example, Currently have /images/test.jpg
would like to change to /images/gdr/test.jpg
I will create the folders, just need an easy way to change the reference in the products |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
I see, hmm .. that's not going to be very easy at the moment as the stored proc would have to know about your products.
If Batch Product Edit does not work I'm not sure what's your next best bet. It would be easy to code a plugin to "Move Images For This Product to" but I have no time for this as I'm stuck in too many projects atm.
Sorry,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
The Batch Product Edit may work, but i'm not sure what i would be entering in the box. So far everythig i tried does not do the trick. |
Dan
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.