Jump to content

Multi language SEO translation


masterunix

Recommended Posts

Hello all,

 

I see Cube cart has a feature to add translated version for each language for categories or products.

 

I want to make my website more SEO friendly in more languages meaning i want to add subdomains and with some cronjobs i can make a perfect SEO website for all available languages in Cube cart admin.

 

Now here is the problem.

 

I have more then 10.000 products and i can not simply modifying them one by one to add translations for each language.

 

I have all languages for all products in excel.

 

Is there any coder who can make a mod for this? So i can import excel or csv in admin and select which language i want to import?

 

Let me know if you can and we can discuss the budget.

Link to comment
Share on other sites

The tables CubeCart_inventory_language and CubeCart_category_language are straightforward and are simply used. That is, when showing a product or category, a query is made against these tables and, depending on the language the customer is using, the results of the query against these tables overwrite the data contained in the main record.

 

So, in your CSV file, have these columns for the inventory_language table:

product_id: #

language: es-ES (standard language identifier)

name: UTF-8 encoded name

description: UTF-8 encoded, stripslashes

seo_meta_title: UTF-8 encoded

seo_meta_description: UTF-8 encoded, striptags

seo_meta_keywords: UTF-8 encoded

 

where the product_id is the database table record number of that product.

 

The same is done for the category_language table:

cat_id, language, cat_name, cat_desc, and the three seo columns.

 

Feed the CSV to the database by using a database utility, such as phpMyAdmin.

Link to comment
Share on other sites

Hello bsmither,

 

Thank you for your answer!

 

So in theory it is possible to have more then one language?

 

I understand your theory and i know how to use phpmyadmin, but i am not really a database administrator so for me it is hard to manage this.

 

I would like to havew a tool who can import this for me.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...