BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Moved images for 8800 products! Need help.
Rank: Member
Joined: 11/13/2007(UTC)
Posts: 22
|
I copied all my images in to a new folder and I want to begin to link all 8800 products to their corresponding images located in the new folder. The idea is SEO related meaning I wanted to throw a few keywords in the image urls. Is there a quick fix for this or do I have to go item by item in edit?
Thanks,
Chris
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
|
|
|
|
|
|
Rank: Member
Joined: 11/13/2007(UTC)
Posts: 22
|
Marcus,
It probably will. I am not familiar with Microsoft SQL servers. I do have the Studio Express installed but I am treading lightly around the application in fear of screwing up the database. Although, eventually I am going to have to learn how to get around in it.
If I want to search for images/products in the database to find out where the urls are contained for images, how would I do such a search using the Studio Express Ap? Also, how do I access the content of specific tables and columns. I can find them in Studio Express but I can't find the data that is contained within it.
I really appreciate all of your help and I apologize in advance for my ignorance. I never was exposed to this type of sql database.
Thanks,
Chris
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Chris,
Just make sure your host has done a backup of your database -- I now regularly edit the db with Express Server -- and the Search and Replace utility too -- to view the contents of a table, highlight it in the left pane and right click to "Open Table" -- you can then see the contents in the right pane. It's probably the Products Table you want. |
|
|
|
|
|
|
Rank: Member
Joined: 11/13/2007(UTC)
Posts: 22
|
Worked perfectly. Thank you for the help!
|
|
|
|
|
|
Rank: Member
Joined: 10/29/2007(UTC)
Posts: 33
|
I just did this last night for 608 products.
As others have mentioned be sure you have a backup.
Using sql studio in an SQL Query Window:
lets say you had an imagefile path of images/thumbs and you wanted to change it to images/products.
this is for the products table imagefilesmall column. You would simply change the set statement and arguements to change the imagefilemedium column.
EXAMPLE:
UPDATE Products
Set imagefilesmall = replace(imagefilesmall, 'thumbs', 'products')
You should get a count of rows effected. |
|
|
|
|
|
|
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.