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 ). 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