OpenCart Community

Posted: **Mon Jun 22, 2009 2:12 pm**

Let's talk about the new SEO Url rewrite in v.1.2.9

Issues:
1. Not all links are passed through the Seo Url funtion
2. the url_alias table could use indexes at query and alias columns
3. site pages like 'route=account/create' , 'route=checkout/cart' etc should be added by default or addable in admin.
4. it is not a good practice regenerating the whole 'url_alias' table after product/category/information update or add. the process takes 12 sec and more! (for 4000 products)
there should be a special page with the option to purge all Seo Urls
5. if an update of 'url_alias' table is made after product/category/information update or add should be a smart update with only the info it requires

I have hard coded some of the default links in admin/model/tool/seo_url.php

Code: Select all

$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=common/home', 		`alias` = ''");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=product/special', 	`alias` = 'oferte-speciale'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/account', 	`alias` = 'cont'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/create', 		`alias` = 'inregistrare'");		
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=product/latest', 		`alias` = 'noutati'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/login', 		`alias` = 'logare'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/logout', 		`alias` = 'delogare'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=checkout/cart', 		`alias` = 'cos-cumparaturi'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=checkout/shipping', 	`alias` = 'date-livrare'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=information/contact', `alias` = 'contact.html'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=information/sitemap', `alias` = 'harta-site.html'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=product/search', 		`alias` = 'harta-site.html'");

Posted: **Mon Jun 22, 2009 2:43 pm**

i can't see seo url module in my site www.idopoo.com
i have full new install the 1.29 opencart system.
but not see seo module.we can tell me how to find the seo url module?

Posted: **Mon Jun 22, 2009 3:20 pm**

Hi Daniel, I think that I am doing something wrong with seo urls, I didn't put anything for each product or category, I will have a look. I leave my web site link here If anyone wants to have a look, it's running with v1.2.9. If someone have got IE6 please tell me if he is able to see my page correctly. Thanks Daniel.

Posted: **Mon Jun 22, 2009 3:21 pm**

Ooooops, I forgot to write the site....XD

www.todoparacalzado.com

Posted: **Mon Jun 22, 2009 7:19 pm**

iuliantoma wrote:Let's talk about the new SEO Url rewrite in v.1.2.9

Issues:
1. Not all links are passed through the Seo Url funtion
2. the url_alias table could use indexes at query and alias columns
3. site pages like 'route=account/create' , 'route=checkout/cart' etc should be added by default or addable in admin.
4. it is not a good practice regenerating the whole 'url_alias' table after product/category/information update or add. the process takes 12 sec and more! (for 4000 products)
there should be a special page with the option to purge all Seo Urls
5. if an update of 'url_alias' table is made after product/category/information update or add should be a smart update with only the info it requires

I have hard coded some of the default links in admin/model/tool/seo_url.php

Create account page and many of the others should not be added as there is no reason for google to index them.

You are really the big SEO guru!! who can give me some one who has been doing seo for 10 years.

The seo urls mean NOTHING! Its really all about content and keyword density.

4. it is not a good practice regenerating the whole 'url_alias' table after product/category/information update or add. the process takes 12 sec and more! (for 4000 products)

No its about optimization! If you have to split the keywords up and you need to do a search for each keyword its going to take a lot more cpu power and time to build each url. If its already generated each seo url requires one search.

It does not take 12 seconds!!

what do you thnk is better? the admin generating the url for once in a while or multiple clients generating them on the fly on ever page request?

Posted: **Mon Jun 22, 2009 11:31 pm**

Daniel wrote: If you have to split the keywords up and you need to do a search for each keyword

I did not understand what you mean here.

Daniel wrote: It does not take 12 seconds!!

It does. this code is talking 12+ seconds when generating the 10000 links of my store at every product save (admin/controller/catalog/product.php)

Code: Select all

if ($this->config->get('config_seo_url')) {
				$this->load->model('tool/seo_url');
				
				$this->model_tool_seo_url->generate();
			}

Daniel wrote: what do you thnk is better? the admin generating the url for once in a while or multiple clients generating them on the fly on ever page request?

the admin way is better i think

Daniel wrote: Create account page and many of the others should not be added as there is no reason for google to index them.

True, what about sitemap page and contact?

Posted: **Wed Jun 24, 2009 5:10 am**

sitemap is done i think.

Posted: **Wed Jun 24, 2009 7:44 am**

@dbassa
Your page throws JS errors:

Code: Select all

Access is denied to:
http://todoparacalzado.com/catalog/view/javascript/png/iepngfix.htc

search the forum I think there was something in that regard

Also for IE just remove

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

from your layout template—it's totally useless anyway as it puts IE in quirks mode
http://en.wikipedia.org/wiki/Quirks_mod ... ring_modes

this will bring your center column up.

Posted: **Sat Jul 04, 2009 9:38 am**

Does it matter where you put the hardcoded code in seo_url.php for it to generate the other pages as pretty URLs? Or how do you get it to update the cart so that pages like the index, sitemap, and contact are displayed how you want? Thanks.

OpenCart Community

SEO URL Rewrite 1.2.9

SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9

Re: SEO URL Rewrite 1.2.9