Skip to content

Joom!Fish 2.0.4 and VirtueMart 1.1.4 – Multilanguage support

There a few tricks to get this working for your online store with Joomla.

1. Make sure you have installed Virtuemart 1.1.4 and Joomfish 2.0.4 over Joomla 1.5.20 (it should work with any 1.5 version). System Legacy plugin should be on.

2. You need to alter the table vm_product_attribute_sku

ALTER TABLE `jos_vm_product_attribute_sku` ADD `attribute_sku_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;

3. Copy this Joomfish content elements to your site: in administrator\components\com_joomfish\contentelements

4. Add this file toyour site administrator\components\com_virtuemart\html

shop_browse_queries.zip

There is only one line of chages from the original file and it is on 41 line:

Original:

$fieldnames = "`product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`#__{vm}_category`.`category_id`,
				`#__{vm}_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
				`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`#__{vm}_product`.`mdate`, `#__{vm}_product`.`cdate`";

After:

$fieldnames = "`#__{vm}_product`.`product_id`,`product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`#__{vm}_category`.`category_id`,
				`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
				`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`#__{vm}_product`.`mdate`, `#__{vm}_product`.`cdate`";

5. To directly translate the products in the virtuemart product list go to your module manager and get your Direct Translation module properties (this is an administrator module Wink). In the parameter section you find several lines with config values. Just add the following code to one of those lines.

com_virtuemart#vm_product#product_id#page#product.product_list

This additional configuration will allow the direct translation module to identify which product you want to translate. It opens a modal window in which you can process your complete translation.

6. Usefull links:

http://www.joomfish.eu/forum/viewtopic.php?f=24&t=5393

http://www.joomfish.net/en/blog/28-alex-blog/168-joomfish-and-virtuemart

http://www.joomfish.net/forum/viewtopic.php?f=24&t=1073

http://www.gjcwebdesign.com/joomla-15-virtuemart-11-joomfish-20.html

 

If you have problem with the Joomfish Language Activation this is the solution:

The solution is to delete and create a table jos_languages. Open your phpMyAdmin and delete this table. Then run this SQL-query to your base:

CREATE TABLE IF NOT EXISTS `jos_languages` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default ”,
`active` tinyint(1) NOT NULL default ‘0’,
`iso` varchar(20) default NULL,
`code` varchar(20) NOT NULL default ”,
`shortcode` varchar(20) default NULL,
`image` varchar(100) default NULL,
`fallback_code` varchar(20) NOT NULL default ”,
`params` text NOT NULL,
`ordering` int(11) NOT NULL default ‘0’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `jos_languages` (`id`, `name`, `active`, `iso`, `code`, `shortcode`, `image`, `fallback_code`, `params`, `ordering`) VALUES
(1, ‘English (United Kingdom)’, 1, ‘en_GB.utf8, en_GB.UT’, ‘en-GB’, ‘en’, ”, ”, ”, 1);

 

More info here: http://www.joomfish.net/forum/viewtopic.php?f=47&t=7199&start=10

Published inCodingJoomla

8 Comments

  1. H.G.Wang

    Dear Mrs./Mr.

    Thank you very much for your clear and useful tips for multilanguage support in virtuemart. I tried other tips from different sites, but they are either not work or not clear enough to follow. Furtunately I found your tip and I can follow very easily. Most important it works fine. Thanks again.

    Best Regards,
    HongGuang

  2. behzad Kubatov

    Thank you Very very much
    it works

  3. Daniel

    Great tips! Works very fine!
    Thank you very much!

    Daniel

  4. Lukas Pokorny

    Thank you very much!! Your tutorial and source codes helped me a lot!
    Lukas

  5. Bremzy

    Thank you very much. Excellent work on VirtueMart 1.1.9 and Joomla 1.5.23

  6. Ema

    Hi,
    What file do I need to open to alter the table vm_product_attribute_sku in step “2”?
    Many thanks!

  7. Ema

    I did everything step by step and it’s working in the admin. But the translation is not showing up on the front end. I’m using Joomla 1.5, VirtueMart 1.1.6 and Joom!Fish Version V2.1.7. Can you please tell me how to fix it?
    Thank you

  8. allex

    Thanks a lot. U R the BEST OF THE BEST

Leave a Reply to behzad Kubatov Cancel reply

Your email address will not be published. Required fields are marked *

*