Thread: Where is the SENAME / URL string stored in the database

If I have the name of an item as, "Item One", the url is something like //p-320-511-item-one.aspx. If I change it to, "Item One Super Deluxe", it changes the URL to //p-320-511-item-one-super-deluxe.aspx.

After that change, the old URL still works.


My question is, where is the old url stored in the database? It must keep track of old urls in a table somewhere that point back to the current one....

The old sename value isnt stored in the DB.

The clever stuff, works, as the ID is the same

SF, will 301 redirect any old urls you may have. Perfect for SEO purposes!

Ok, so how does it know what to redirect? It has to store that some place.

I'm looking to stack the deck and have my list of urls from the old site 301 to this new ones on this site.

Any thoughts?

Originally Posted by suedeapple

The old sename value isnt stored in the DB.

The clever stuff, works, as the ID is the same

SF, will 301 redirect any old urls you may have. Perfect for SEO purposes!

It's based on the ProductID.

e.g. - in the example you gave, any of the following would work (i.e. all get 301'd to the same place) :-

//p-320-511-item-two.aspx
//p-320-test.aspx
//p-320-999-another-test.aspx
//p-320-BFG-has-all-the-answers.aspx
//p-320-pretty-much-anything-you-like-can-be-here.aspx



TTFN

BFG

Cool. But, how does it know to do that? That is my question... Is there a file somewhere that does these 301s?

Originally Posted by BFG 9000

It's based on the ProductID.

e.g. - in the example you gave, any of the following would work (i.e. all get 301'd to the same place) :-

//p-320-511-item-two.aspx
//p-320-test.aspx
//p-320-999-another-test.aspx
//p-320-BFG-has-all-the-answers.aspx
//p-320-pretty-much-anything-you-like-can-be-here.aspx



TTFN

BFG

No - "It's based on the ProductID" - the number after p-


TTFN

BFG

It's handled by the <urlrewrites> section in the web.config file, more specifically this line:

<rule url="/p-([0-9]*)-([\w-]*)\.aspx(?:\?(.*))?" rewrite="/showproduct.aspx?ProductID=$1&amp;SEName=$2&amp;$3 " />