I have a SQL Question, maybe Excel would work too? Not sure.

I want to change all of my products to have “store.commoto.com” at the end of each page title. How can I do this is MySQL? Right now we are manually going through the backend of CS Cart and updating products one by one. There has to be an easier way, either SQL or something else. Excel maybe? Could I download all products and then import them back in concatenating “store.commoto.com” to the end of each page title? If so, where would I go to do this?

Yes you can do it via concatenate in excel as a csv file by exporting just the product code and name, But can I ask why you would want to do that? is it is for seo reasons it wont help a bit.



John

Yes it is for SEO reasons. We were thinking it would help. Is there anything that Would help as far as adjusting the page title? Maybe just making the page title as descriptive as possible?

[quote name='kristabrashear' timestamp='1387484789' post='173786']

Yes it is for SEO reasons. We were thinking it would help. Is there anything that Would help as far as adjusting the page title? Maybe just making the page title as descriptive as possible?

[/quote]

Title tag - follow this.



As for the SQL, this will work…remember to back up before executing any SQL statements directly on the live store database.

UPDATE cscart_product_descriptions SET page_title=concat(page_title,' store.commoto.com')

This would add " store.commoto.com" to the end of the Page Title for products. However, this can be done dynamically through CS-Cart by adding “store.commoto.com” in the Page Title field of the Products location (ie. Design>Layouts>Products settings). I personally would not use “mydomain.com” but I would use “My Domain”. Nobody remembers the URL of sites they visit infrequently, but they have a far higher chance of remembering the store name which can then be found using search engines.

[quote name='kristabrashear' timestamp='1387484789' post='173786']

Yes it is for SEO reasons. We were thinking it would help. Is there anything that Would help as far as adjusting the page title? Maybe just making the page title as descriptive as possible?

[/quote]

If you are hoping having that in to get the store name better SEO friendly then you dont need to, it will be found. Unless the name is the brand of the product I wouldn't bother You would be better using the product title and brand name just as you have now as you would just be adding unneeded text and lengthening your already long titles.



Maybe you would be better putting it in the description, say starting with, store.commot.com are proud to present this " Ducati etc etc etc product name)

John

Thanks for the code Stellarbytes. Thats exactly what I used. And thanks John for the SEO tips.