VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: be on October 28, 2012, 02:36:14 AM

Title: Show customfields in the productlist?
Post by: be on October 28, 2012, 02:36:14 AM
Hi,
how could show some of the customfields in the product list, gladly through overrides?
And if is there a possibility to control which of theese will be displayed?

BR

PS: Joomla 2.5.7 and Virtuemart 2.0.12f
Title: Re: Show customfields in the productlist?
Post by: PolishedGeek on October 28, 2012, 04:02:29 AM
Don't quite follow your question. Can you give an example?
Title: Re: Show customfields in the productlist?
Post by: be on October 29, 2012, 14:43:41 PM
Hi,
I have a customfield ,,author", it is a bookshop.
And now I´ll show this also on the categorylist.
I have added a screenshot.

BR

EDIT: I have done it now with a DB-query:

$db2 = JFactory::getDBO();
$db2->setQuery("SELECT custom_value FROM #__virtuemart_product_customfields WHERE virtuemart_product_id=".$product->virtuemart_product_id." and virtuemart_custom_id=17 ;"); 
$db2->query();
$resultauthor = $db2->loadResult();


[attachment cleanup by admin]