SEO Friendly Url In Opencart



Url rewriting is very important for the website and it is good for the SEO. As we know the url having the query string i.e. ?index=2&pid=15 is not good for the SEO and url like this is not accepted by the Google. In the Opencart url rewrite is default functionality and you need to Enable it from the admin panel for this just follow the steps given below:

Step 1. Just connect the FTP and search for the .htaccess.txt file and rename it from .htaccess to the .htaccess, you can find it on the root of the Opencart website where you have uploaded the files.
Step 2. Now Login to the admin panel of the Opencart website and navigate to the Systems > Settings > Click To Edit the Store.
Step 3. Now Click on the Server Tab and search for the SEO URL option and check SEO URL option Yes.
Step 4. Now Enter the SEO Keyword for the Category, Product and the Information Pages, you can find the SEO Keyword under the Data Tab for the Category, products and Information Pages at the time of insertion or edition.
Step 5. You can use the Mysql Query given below to set the url of the Opencart by running the query below, Before running the query please take the backup of
your database
:

INSERT INTO url_alias (query, keyword) VALUES (‘account/wishlist’, ‘wishlist’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/account’, ‘my-account’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/login’, ‘login’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/logout’, ‘logout’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/order’, ‘order-history’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/newsletter’, ‘newsletter’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/account’, ‘affiliates’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/forgotten’, ‘forgot-password’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/download’, ‘downloads’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/return’, ‘returns’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/transaction’, ‘transactions’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/register’, ‘create-account’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/return/insert’, ‘request-return’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/edit’, ‘edit-account’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/password’, ‘change-password’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/address’, ‘address-book’);
INSERT INTO url_alias (query, keyword) VALUES (‘account/reward’, ‘reward-points’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/edit’, ‘edit-affiliate-account’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/password’, ‘change-affiliate-password’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/payment’, ‘affiliate-payment-options’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/tracking’, ‘affiliate-tracking-code’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/transaction’, ‘affiliate-transactions’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/logout’, ‘affiliate-logout’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/forgotten’, ‘affiliate-forgot-password’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/register’, ‘create-affiliate-account’);
INSERT INTO url_alias (query, keyword) VALUES (‘affiliate/login’, ‘affiliate-login’);
INSERT INTO url_alias (query, keyword) VALUES (‘common/home’, ”);
INSERT INTO url_alias (query, keyword) VALUES (‘checkout/cart’, ‘shopping-cart’);
INSERT INTO url_alias (query, keyword) VALUES (‘checkout/checkout’, ‘checkout’);
INSERT INTO url_alias (query, keyword) VALUES (‘checkout/voucher’, ‘gift-vouchers’);
INSERT INTO url_alias (query, keyword) VALUES (‘information/contact’, ‘contact-us’);
INSERT INTO url_alias (query, keyword) VALUES (‘information/sitemap’, ‘sitemap’);
INSERT INTO url_alias (query, keyword) VALUES (‘product/special’, ‘specials’);
INSERT INTO url_alias (query, keyword) VALUES (‘product/manufacturer’, ‘brands’);
INSERT INTO url_alias (query, keyword) VALUES (‘product/compare’, ‘compare-products’);
INSERT INTO url_alias (query, keyword) VALUES (‘product/search’, ‘search’);

If you are looking for the SEO optimization of the Opencart website it is very important to create the Sitemap for your website and submit it to the Google
so that Search Engine can Index your pages easily, For Creating the Sitemap in Opencart check the Activate Google Site Map in OpenCart.

I think it would helps, Thanks for reading, If you Like the Post Please Share it on Facebook, G+.