Hi Arvydas Thanks for you description. I could configure the redirection of my old url's with your information. In the next few days I will write a small tutorial about this topic.
Kind regards Roland -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Arvydas Gesendet: Dienstag, 13. Oktober 2009 14:08 An: [email protected] Betreff: Re: [oxid-dev-general] Technical questions on OXID SEO Hello, Roland, First, please, do not append oxseologs table any more - this table is used to LOG unsolvable seo urls. We don't have interface for moving data from oxseologs table yet, so you can review its contents manually and transfer data to oxseohistory (!) table, which is used to do exactly what you need. What is the purpose of oxseohistory table? Imagine you have a product with title "Product X", which details link is "http://shop.com/Product-X.html";. One day you decide to change its title to "Product Y", so details link will be automatically changed to "http://shop.com/Product-Y.html";. If your shop is indexed by search engines, your product details link in search results for some time will stay old one "http://shop.com/Product-X.html";. So we invented oxseohistory table, which stores outdated seo urls - if user comes to shop by clicking outdated product url he will be redirected to new one. What is the purpose of oxseologs table? If previously you used other shop software, search engines keeps old urls in its index. If user clicks on any of these outdated links he gets "404 Not Found" header and old URL is written to oxseologs table. How can you use data kept in oxseologs? If you exactly know what product should be accessed by opening old url kept in oxseologs table (or in search engines index), you can transfer this data to oxseohistory table. To do this you must know: (1) object OXID, which should be opened by clicking url, e.g. product OXID, category OXID or content OXID; (2) old url. (3) which shop currently hosts object. If you use PE/CE shop id is always 'oxbaseshop'; (4) which language was active when url was opened, so check language ID (0, 1, 2 ..); If you have all this data, you are ready to move url from logs table to history: INSERT INTO `oxseohistory` ( `oxobjectid`, `oxident`, `oxshopid`, `oxlang` ) VALUES ( _(1)_, MD5( LOWER( _(2)_ ) ) , _(3)_, _(4)_ ); NOTICE: On very special case, if you need to define custom seo url, you can move this data to oxseo table. To do this you must know: (1) object OXID, if there is no real object accessed by this url - any unique id must be used; (2) old url. (3) which shop currently hosts data accessible by url. If you use PE/CE shop id is always 'oxbaseshop'; (4) which language was active when url was opened, so check language ID (0, 1, 2 ..); (5) dynamic url, which opens your page; (6) old url. (7) url type, in this case it SHOULD be "static"; (8) if this url should is fixed - in this case it SHOULD be fixed; If you have all this data, you are ready to move url from logs table to oxseo: INSERT INTO `oxseo` ( `oxobjectid`, `oxident`, `oxshopid`, `oxlang`, `oxstdurl`, `oxseourl`, `oxtype`, `oxfixed` ) VALUES ( _(1)_, MD5( LOWER( _(2)_ ) ) , _(3)_, _(4)_, _(5)_, _(6)_, _(7)_, _(8)_ ); Arvydas -------------------------------------------------- From: <[email protected]> Sent: Tuesday, October 13, 2009 9:49 AM To: <[email protected]> Subject: Re: [oxid-dev-general]Technical questions on OXID SEO > Hi > > I'd like to get some url's of our old shop (for example > "/product_info.php/products_id/53") to the seo logs table to transfer > them (redirect 301) to the new product (for example http://www.domain.de > /garderoben/holz-kleiderbuegel-tiere.html). So I added an entry to the > oxseologs with the following datas: > > Oxstdurl => /product_info.php/products_id/53 (old url) > Oxidant => 1126 (id of the new product) > Oxshopid => oxbaseshop > Oxlang => 0 > > The result is a message "the page could not be found". Can anybody give > me a hint, what I have to fill into the oxseologs to get a redirect from > the old to the new url? > > Greetings > Roland > > Arvydas <arvydas.vap...@...> writes: > >> >> Hi, i want to add some more details: >> >> 1b. expired seo urls are moved to oxseohistory table. E.g. you started > your >> shop and "product x" had url "www.shop.com/product-x.html". One day > you >> decided to change this product name to "product y", so new url (if you > did >> not mark "fix url" in seo tab) will look like > "www.shop.com/product-y.html". >> Old seo url info does go history table. Possibly your old url was > stored in >> some forum, or search engine results outputs your old url, so seo > history >> keeps them, and is used as a relation from old url to new one (see 1c) > - see >> oxident field on both tables. >> >> 1c. if user or even search engine (e.g. indexing some forum page) came > to >> shop by old url redirection with header 301 says to search engine/user >> browser that old url is expired and should be used new instead. >> >> 2. seo logs table is used to stored dynamic > (index.php?cl=details&anid=123) >> urls which could not be translated into seo mode. e.g. you have a > module >> which overrides dynamic product link, so it cant be translated to seo > mode, >> because records in oxseo table (oxstdurl field) does not match. So > using seo >> logs table users can review un-translated dynamic urls and enter own > static >> seo urls. (possible that one day we will create such editing tool) >> >> 3. reserved words are these which should be removed while building seo > url. >> e.g. you have some subfolder in shop domain, e.g. forum, so by > entering >> forum as reserved word you tell to seo encoder not to generate such > urls, >> because they will not work. E.g. you have category "forum" and have > such >> folder on server, so marking "forum" as reserved word will create url > like >> www.shop.com/forum-your-seo-prefix/ >> >> 3a. not necessary >> >> 4. types used for identification, faster search (see indexes) + helps > while >> cleaning or resetting seo data - there is "Reset seo entries" button > in >> admin, so when you click this you mark all seo table entries expired > excl. >> static. Static urls are not changed dynamically. Static urls are these > which >> cannot be generated dynamically (user defined) e.g. contact, > guestbook and >> others. >> >> -------------------------------------------------- >> From: "Marco Steinhaeuser" <marco.steinhaeu...@...> >> Sent: Thursday, July 02, 2009 2:51 PM >> To: <dev-gene...@...> >> Subject: Re: [oxid-dev-general] Technical questions on OXID SEO >> >> > Hey Vikram! >> > >> > In former Shop Versions, we had different rewriting rules: >> > PE (type I IMO): & and ? Where switched to slashes simply >> > > http://www.yourshop.com/oxid.php/sid/cf2d4d66e18a52014cb5702556693b86/cl/det ails/cnid/1ad463624ce85f4b0.34723936/anid/a0048d7cb63df4ed3.56851241/MHD-05. 06.2009---Weight-Watchers-Apple-Crumble-Slices-a-144-g/ >> > >> > and type II in EE (beat me if I am wrong) >> > > http://www.yourshop.com/basteln/textilblumenbaender/satinbaender-25mm-breit- 22355-25.html >> > >> > Now, updating to version 4 where SEO purposes are much more > optimized and >> > where you might want to configure your URL like this >> > http://www.yourshop.com/article.html >> > you might run in trouble with your already in Google indexed pages. >> > >> > That's why we do a trick ;) >> > When you change the structure of your URL, the old URL is written to > the >> > logs. Coming from a search engine where your old URL was indexed, it > hits >> > the seo log table first and a html header 301 (permanently moved) is > given >> > to the visitor/bot and will be re-directed to the new URL. >> > >> > I think that meets your points 1. & 2. >> > >> > Could anybody else say something about the other questions? I would > be >> > interested as well >> > >> > >> > Regards >> > Marco >> > >> > >> > >> > >> > >> > -----Ursprüngliche Nachricht----- >> > Von: dev-general-boun...@... >> > [mailto:dev-general-boun...@...] Im Auftrag >> von Vikram >> > Vaswani >> > Gesendet: Mittwoch, 1. Juli 2009 19:23 >> > An: dev-gene...@... >> > Betreff: [oxid-dev-general] Technical questions on OXID SEO >> > >> > Hi all >> > >> > I am trying to understand some aspects of OXID's SEO implementation, > in >> > order to put together a brief article for OXIDForge. >> > >> > _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
