Home › How to get the manufacturer name into Ultimate SEO Urls for OsCommerce






  
  
  
    					

				
Want to get the manufacturer name into the product_info url on ultimate SEO urls for OsCommerce? Here's how!
			

			

			
		

			Category:
			oscommerce, seo		
		
		

		
		

    		
It's handy on some shops to have the brand name in the Search Engine Friendly (SEF) url for the Ultimate SEO Url contribution in OsCommerce. However, this feature isn't supported out of the box, it is however a simple code change. 






Step 1. Open includes/classes/seo.class.php




Add the following function to the end of the class before the 

} # end class 


closing brackets...






function get_manufacturer_name_from_product(&$cID){

		$this->performance['NUMBER_QUERIES']++;

		$sql = "SELECT m.manufacturers_name, m.manufacturers_id

				FROM ".TABLE_MANUFACTURERS." m

				LEFT OUTER JOIN ".TABLE_PRODUCTS." p ON m.manufacturers_id = p.manufacturers_id

				WHERE p.products_id = '".(int)$cID."'

				LIMIT 1";

		$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );

		$manufacturers_id = $result['manufacturers_id'] ;

		$manufacturers_name = $result['manufacturers_name'] ;


		$mName = $this->not_null($result['manufacturers_name']) ? $result['manufacturers_name']  : $result['manufacturers_name'];

		$mName = $this->strip($mName);


		$this->cache['MANUFACTURERS'][$full_cPath] = $mName;

		$this->performance['QUERIES']['MANUFACTURERS'][] = $sql;

		$return = $mName;


		return $return;

	} # end function






Step 2. Replace the following





In the function called 'parse_parameters' replace the follow code after line with "case 'products_id':" 





	switch(true){

		case ( $page == FILENAME_PRODUCT_INFO && !$this->is_attribute_string($p2[1]) ):

			$url = $this->make_url($page, $this->get_product_name($p2[1]), $p2[0], $p2[1], '.html', $separator);

                        $this->ValidateName($url, "p", $p2[1], $connection, $separator);

			break;

		case ( $page == FILENAME_PRODUCT_REVIEWS ):

			$url = $this->make_url($page, $this->get_product_name($p2[1]), 'products_id_review', $p2[1], '.html', $separator);

                        $this->ValidateName($url, "pr", $p2[1], $connection, $separator);

			break;

		case ( $page == FILENAME_PRODUCT_REVIEWS_INFO ):

			$url = $this->make_url($page, $this->get_product_name($p2[1]), 'products_id_review_info', $p2[1], '.html', $separator);

                        $this->ValidateName($url, "pw", $p2[1], $connection, $separator);

			break;

		default:

			$container[$p2[0]] = $p2[1];

			break;

		} # end switch

		break;





with the following:





switch(true){

						case ( $page == FILENAME_PRODUCT_INFO && !$this->is_attribute_string($p2[1]) ):

							$url = $this->make_url($page, $this->get_manufacturer_name_from_product($p2[1])."-".$this->get_product_name($p2[1]), $p2[0], $p2[1], '.html', $separator);

				                        $this->ValidateName($url, "p", $p2[1], $connection, $separator);

							break;

						case ( $page == FILENAME_PRODUCT_REVIEWS ):

							$url = $this->make_url($page, $this->get_manufacturer_name_from_product($p2[1])."-".$this->get_product_name($p2[1]), 'products_id_review', $p2[1], '.html', $separator);

				                        $this->ValidateName($url, "pr", $p2[1], $connection, $separator);

							break;

						case ( $page == FILENAME_PRODUCT_REVIEWS_INFO ):

							$url = $this->make_url($page, $this->get_manufacturer_name_from_product($p2[1])."-".$this->get_product_name($p2[1]), 'products_id_review_info', $p2[1], '.html', $separator);

				                        $this->ValidateName($url, "pw", $p2[1], $connection, $separator);

							break;

						default:

							$container[$p2[0]] = $p2[1];

							break;

					} # end switch

					break;





Step 3. Clear the cache and reset sitemaps




In the admin under the SEO Urls, clear/reset the cache. If running sitemaps, regenerate the sitemap and ping Google, same goes for Froogle if running feeds.

If it's a very very well aged and well ranked site you may wish to create 301 redirects for all the old SEF urls to the new SEF urls if required.







    	

    	

    	  
File Attachments
			
			download
			
			 Download: 
			seo.class_.php.txt
			
			
  
  

 
  

          
Comments

        



      

      Thank you for the info          

  
  
  
  

    Submitted by Pisco (not verified) on Sun, 04/26/2009 - 02:40.  


  

    
I got a bug in Ultimate SEO URL

I got a bad redirection on manufacturers_id

Just dont know what to do

Regards

      


      

          

  

 





      

      Hi Pisco,
Need to see the bug          

  
  
  
  

    Submitted by geefin on Thu, 06/25/2009 - 21:46.  


  

    
Hi Pisco,


Need to see the bug to help! :) Typically the first port of call with SEO Urls is to check that you have the right directory name (especially if using a sub directory!) in the .htaccess. Then check you have all the required PHP modules enabled. After that, it's time to start digging into the code! :)


Cheers,
Graeme.

      


      

          

  

 





      
Comment viewing options

  
  

    




 




 




 




Select your preferred way to display the comments and click "Save settings" to activate your changes.
  



 






      
Post new comment

  
  

    



 
 




 
 
 
The content of this field is kept private and will not be shown publicly.