Rank: Member
Joined: 1/10/2005(UTC) Posts: 714
Thanks: 14 times Was thanked: 1 time(s) in 1 post(s)
|
I want to change my product template for all of my products. I used the batch product edit and set the template to what I wanted. It ran successful. When I went to check a product that was using the old template, it still was using the old template. I also tried using the SQL find and replace utility and it did the same thing.
The weird thing is that all my products say they are using the correct template in the admin, but they are still using the old template on the wesbite unless I save the product.
Help!
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Are you manually specifying your product URLs rather than using auto-rewriting? |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 1/10/2005(UTC) Posts: 714
Thanks: 14 times Was thanked: 1 time(s) in 1 post(s)
|
I am manually rewriting the URLs.
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: "Bryan" I am manually rewriting the URLs. Yeah, that's the issue. The URL rewriter doesn't use the product data (i.e. bvc_Product table) when rewriting URLs. It uses the Custom URL data (i.e. bvc_CustomUrl table) which holds a copy of the rewritten URL specified in the product data. Anyway, the bulk editor must not bother to keep these two data sources in sync like the product admin page does. To fix this you can resave each product (fun!) or write a SQL or ASP.NET script to update the URLs. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 1/10/2005(UTC) Posts: 714
Thanks: 14 times Was thanked: 1 time(s) in 1 post(s)
|
[quote="Aaron"] Yeah, that's the issue. The URL rewriter doesn't use the product data (i.e. bvc_Product table) when rewriting URLs. It uses the Custom URL data (i.e. bvc_CustomUrl table) which holds a copy of the rewritten URL specified in the product data. Anyway, the bulk editor must not bother to keep these two data sources in sync like the product admin page does. To fix this you can resave each product (fun!) or write a SQL or ASP.NET script to update the URLs.</FONT>Yup, that fixed it. I used the SQL find and replace utility with customer URL table instead of the product table and it solved the problem! Thanks.
|
|
|
|
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.