Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
I usually use my product name as the meta title, and the short descrption as the meta description. Instead of going into every single product to change the ones that are not like this, I was wondering if anyone knew of a little script i could execute!?
Bryan
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
I changed my product template to display the product name or short description in these tags if they are empty.
Anyway, you query should be something like
update bvc_Product
set MetaTitle = ProductName
, MetaDescription = ProductName
, ShortDescription = ProductName
You might want to split that into multiple operations and add a where clause at the end of each of them like
update bvc_Product
set MetaTitle = ProductName
where MetaTitle = ''
update bvc_Product
set MetaDescription = ProductName
where MetaDescription = ''
....
Regards,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
Thanks,
I went your first route and changed it in my product template. I didnt even think of doing that.
|
|
|
|
|
|
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.