X-Cart forums

[staalejg]

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]

Moving to Third Party Add-Ons

[Jon]

"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.

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]

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

[timbrrr]

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

Originally Posted by Jon

"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.

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]

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:

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

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

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

[drx]

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]

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

[Jon]

Something like:

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

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