Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I wonder if anyone else has run into this. I have custom URLs assigned to my categories. Every now and then, one of the same custom URLs will get assigned to some product (I believe in the last case it got assigned to the same product twice). I have to clear that setting for that product and go back and save the category again.
Could this be a bug -- gremlins? Hack? |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Joe,
I haven't heard of this before but it sounds like it could be a serious issue if reproduced. Please send us a support ticket with the details so we can look into it.
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Marcus,
I did open a ticket and Everett was looking into it today. It actually happened again -- the custom URL for a certain category I had set got reassigned to the same product that it had earlier. It's the same pair of items (category -> product) |
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
So if you edit the settings back to the correct value, it gets changed again? Only thoughts I have at the moment is that the database is getting changed (not likely) or something going on when the site recycles. Is there anyway you can tell if the site recycles to eliminate that possibility? When does the change occur? Randomly? Do you have more than yourself making these changes? Just throwing out some things to troubleshoot. |
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Thanks Chris,
Everett has been working with me on this and we discovered that categories that were imported from my SF6 database were "hard-coded" with an ID rather than the BV format of a random created category ID. My guess is that perhaps those product IDs were similar in number to the old Category IDs and something is getting cross-wired. I only have a few imported categories and I'm replacing them with new ones, but I do have a couple that now have nested subcategories with a lot of products that would take a lot of time to recreate. |
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
SQL find and replace would be able to update it faster, maybe everett may be able to run that for you on your db without you purchasing a license because of what is causing the problem. |
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
Joe,
Seems like that old (____________fill in words of choosing) SF software still manages to cause issues even after we stopped using it. |
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Isn't that the truth!
I've got the SQL Search and Replace -- the question is: What should be the "replace" value? |
|
|
|
|
|
|
Rank: Member
Joined: 3/8/2007(UTC)
Posts: 139
|
Hey Joe,
If you have created a new category (a category who's only purpose is to provide you a valid categoryid number, and then can be deleted), use the new categoryid number to replace the old SF category Id numbers. Using the SQL find and replace tool should definitely speed up the process.
Just to clarify, the find value would be the SF category ID, and the replace value will be the new categoryid.
Thanks, |
Everett Comstock
BV Software |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
So if I create a new category and then use that GUID in the old category -- that would make it so I don't have to recreate all subs if that is a top level category? |
|
|
|
|
|
|
Rank: Member
Joined: 3/8/2007(UTC)
Posts: 139
|
Hey Joe,
You wouldn't have to recreate the sub categories, but you would have to update their "ParentId" field with the GUID from the new category. This is where SQL Find and Replace would really come in handy.
Thanks, |
Everett Comstock
BV Software |
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
Hi Joe,
Basically all you need is a valid guid value. There are freeware programs out there that we generate them for you or you can create a bunch of temporary categories to generate the guids.
Once you have the guids (doesn't matter how you get them), you want to replace the old storefront ids with the new guids throughout the databse which is where the sql find and replace comes in handy.
For example, say you have a category named "Bird Feeders" and the storefront id and hence the bvc5 is now "1". You have generated a new guid (say '9E061D4F-972E-4cbe-9797-D812F005B55B'). What you do now is replace all the "1" in the database (makes sure its a place that is referencing the categoryid 1 and not some other field like your product id of 1 that is causing your problems) with "9E061D4F-972E-4cbe-9797-D812F005B55B". Repeat the procedure for all of your categories. You should not have to do all your products as the conflicts should be resolved by changing your category id. |
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I think it will be relative simple -- I'm only talking a half-dozen categories -- thankfully I decided to restructure my category layout when I created my BV5 store and only a few old categories fit the new scheme.
This does bring up the question: Why didn't the old Product IDs carry over? It seems those have been recreated in BV5 format even though I imported them as I did the categories -- at least the created URLs follow a BV5 format and in no way resemble the old cart IDs |
|
|
|
|
|
|
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.