X-Cart forums - Product Title and CDSEO Pro

X-Cart forums (https://forum.x-cart.com/index.php)

- Third Party Add-Ons for X-Cart 4 (https://forum.x-cart.com/forumdisplay.php?f=45)

- - Product Title and CDSEO Pro (https://forum.x-cart.com/showthread.php?t=43137)

staalejg

10-21-2008 07:40 AM

Product Title and CDSEO Pro

I've installed CDSEO Pro and it works like a charm. I need to change the Product Titles on a global level.

All of my products have an html page title of "Product Name - Company Name". I'd like to change them globally to "Product Name - Global Keywords". Where can I define what shows up after "Product Name" in CDSEO Pro?

Thanks.

X-Cart 4.19

balinor

10-21-2008 07:44 AM

Re: Product Title and CDSEO Pro

Moving to Third Party Add-Ons

Jon	10-21-2008 12:22 PM

Re: Product Title and CDSEO Pro

"Company Name" comes from your configuration for your actual company name.

You can change this globally with an sql patch as follows, being sure to change "Company Name" to your current title component and "Global Keywords" to your desired title component.

Code:

UPDATE wcm_cdseo set cdseoTitle = replace(cdseoTitle,' - Company Name',' - Global Keywords');

You can run sql patches in x-cart admin -> patch/upgrade -> sql patch

staalejg

10-21-2008 12:30 PM

Re: Product Title and CDSEO Pro

Sweet. Just used the mysql command line to do this. That is exactly what I needed.

timbrrr

10-23-2008 01:58 PM

Re: Product Title and CDSEO Pro

Could you give the exact syntac to switch the cdseoTitle and the company name around?

The end result would be Company name then the cdseo

I tried doing this with the example but wasnt gettting something right... kept getting a mysql error

Thanks

Quote:

Originally Posted by Jon

Code:

UPDATE wcm_cdseo set cdseoTitle = replace(cdseoTitle,' - Company Name',' - Global Keywords');

You can run sql patches in x-cart admin -> patch/upgrade -> sql patch

Jon	10-23-2008 02:03 PM

Re: Product Title and CDSEO Pro

I wouldn't recommend this as global keywords should be put last as they are less relevant to the specific page.

You can accomplish this however, by:

1) Backup your database, these queries haven't been tested live and I take no accountability!

2) Run a query to remove the Company Name:

Code:

UPDATE wcm_cdseo set cdseoTitle = replace(cdseoTitle,' - Company Name','');

3) Run a query to add to the front of the title:

Code:

UPDATE `wcm_cdseo` SET `cdseoTitle` = CONCAT('Company Name - ',cdseoTitle);

drx	05-07-2009 11:39 AM

Re: Product Title and CDSEO Pro

lets say i want the category to have the title with a "general keyword" and I want the products to have a different "general keyword" that is not the same used on the category. How can i do that?

balinor

05-07-2009 11:42 AM

Re: Product Title and CDSEO Pro

drx, need you to update your signature as I requested please.

Jon	05-07-2009 12:21 PM

Re: Product Title and CDSEO Pro

Something like:

Code:

UPDATE `wcm_cdseo` SET `cdseoTitle` = CONCAT('Product Keyword ',cdseoTitle) WHERE cdseoType='product';

Code:

UPDATE `wcm_cdseo` SET `cdseoTitle` = CONCAT('Category Keyword ',cdseoTitle) WHERE cdseoType='category';

All times are GMT -8. The time now is 06:13 AM.