• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

sternyy
#1 Posted : Tuesday, April 26, 2011 12:41:56 PM(UTC)
sternyy

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!
Aaron
#2 Posted : Tuesday, April 26, 2011 1:56:58 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
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
sternyy
#3 Posted : Tuesday, April 26, 2011 3:29:36 PM(UTC)
sternyy

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.
Aaron
#4 Posted : Tuesday, April 26, 2011 3:38:06 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Originally Posted by: "Bryan" Go to Quoted Post
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
sternyy
#5 Posted : Wednesday, April 27, 2011 9:37:44 AM(UTC)
sternyy

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.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012