Configuration of permanent Redirects (Redirect 301)
If you want to move your online store to another shopping cart software (e.g. OXID eShop), you should make sure, that the old URL is redirected to your new product URIs. One option to do so is a “permanent redirect” via html header 301: Every URI will be redirected permanently to the new URI. There is another option, “temporary redirect” via html header 302. The second option is not recommended for permanent migrations. Also, Google’s page rank would not be inherited.
A simple but manual possibility would be to define the redirects in .htaccess but OXID eShop has got a clever SEO system that internally covers that needs. Now we have to teach the OXID SEO system how to re-route the old URIs to the new product deep links. In the next chapters, I will describe how this should be done.
Configure the redirect
To teach OXID the redirects, we have to insert an entry to the database table oxseohistory. This query has to have the following syntax:
INSERT INTO oxseohistory (OXOBJECTID, OXIDENT, OXSHOPID, OXLANG) VALUES ('bcf96ad6c453da8ca24a157dd1ca3612', MD5('my_old_productlink.php/'), 'oxbaseshop', 0);
A short description of the different fields:
- OXOBJECTID: You will find this value in table oxarticles, field OXID. This is the ID of the product, the old URI shall link to.
- OXIDENT: In this field, the old link is saved. The link has to be written without the URL (e.g. http://www.my-store.de), inserted lower case and will be saved to the database as an MD5-hash. Since the webserver’s URL rewrite hands URLs over to Oxid with a trailing slash, old URLs have to be stored with a trailing slash added (attn: no slash at the start of the old URL!).
- OXSHOPID: This is the place where the SHOPID has to be inserted. In the most cases, this would be oxbaseshop. Check this value in the table oxshops.
- OXLANG: Here the value for the language of the appropriate product shall be entered. The standard value shall be “0”.
Check the Redirect
Now the query is entered to the database (e.g. by phpMyAdmin) and the old link might be hit in your browser. If everything worked fine, it shall be redirected to the new product URI.
Check the html header using an external tool like http://www.internetofficer.com/seo-tool/redirect-check/ to see if you were successful.
Have fun with your configuration!