Author Topic: Show customfields in the productlist?  (Read 1212 times)

be

  • Beginner
  • *
  • Posts: 36
Show customfields in the productlist?
« 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

PolishedGeek

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 263
  • Joomla! Innovation Refined.
    • Polished Geek, LLC - Joomla! extensions, web development & custom integrations
Re: Show customfields in the productlist?
« Reply #1 on: October 28, 2012, 04:02:29 am »
Don't quite follow your question. Can you give an example?
~ Deb Cinkus, CEO
Polished Geek, LLC   |    www.PolishedGeek.com

Creators of JoomLister - eBay Lister for Joomla!

be

  • Beginner
  • *
  • Posts: 36
Re: Show customfields in the productlist?
« Reply #2 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:
Code: [Select]
$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]