Using SQL to Update Translations

[sohopros]

We are getting ready to update translations (English, French, and Spanish) for Custom Fields for our products. Once we have set up the language variables and values, and updated the language .ini files, all of our products' (>1,000) configurations will need to be updated for all Custom Fields (11) and their default values (80).
We think this last step would be best performed via a sql query to the database, but are not familiar enough with the VM data tables to do it. When we view the website's database in phpmyadmin, we see the attached, but don't recognize any of the tables as associated with Virtuemart.

Can you tell us which are the VM tables?

[Jörgen]

You have more pages with tables, all VM tables start with _virtuemart_

Jörgen

[GJC Web Design]

use the pagination to see the later pages

[sohopros]

"use the pagination to see the later pages
You have more pages with tables, all VM tables start with _virtuemart_"


Thanks for the help! I'll update if we have any other problems

[Jörgen]

You are welcome 

Jörgen