Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

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

 

Posted 19 December 2013 - 07:57 PM #1

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?

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4656 posts

Posted 19 December 2013 - 08:00 PM #2

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

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 

Posted 19 December 2013 - 08:26 PM #3

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?

 
  • StellarBytes
  • Senior Member
  • Members
  • Join Date: 08-Aug 11
  • 1807 posts

Posted 19 December 2013 - 10:45 PM #4

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?

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.
Hire StellarBytes for CS-Cart Design & Development Services

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4656 posts

Posted 20 December 2013 - 05:37 PM #5

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?

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

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 

Posted 20 December 2013 - 09:35 PM #6

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