Product Listing Custom Fields

[chadlly2003]

I am using zencart v1.5.4.


I have created a custom field in my database called (upc) within the products table. I need this to show this field on my product listing page but I am stuck on how to get it to display. If someone could assist me or lead me in the right direction i would appreciate it.

[mesnitu]

This module helps ?

https://www.zen-cart.com/downloads.php?do=file&id=442

[mesnitu]

Ups, sorry. it doesn't display either.

[chadlly2003]

I actually got it by adjusting the default_filter.php and the product listing.php from a previous posting.

The only thing now is if there is nothing in the database how do i hide the span from displaying.

This is my code
<span><strong>UPC:</strong> '. $listing->fields['upc'] . '' . '</span><br />

[mesnitu]

Something like

if ($listing->fields['upc']!='') {
echo '<span><strong>UPC:</strong> '. $listing->fields['upc'] . '' . '</span><br />';
}

[chadlly2003]

hmm that does not seem to work on the product listing page. Any other ideas

[mesnitu]

well, one example from that file is

 if ($listing->fields['products_qty_box_status'] == 0) {
              $lc_button = '<a href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT, 'class="listingBuyNowButton"') . '</a>';
            } else {
              $lc_button = TEXT_PRODUCT_LISTING_MULTIPLE_ADD_TO_CART . "<input type=\"text\" name=\"products_id[" . $listing->fields['products_id'] . "]\" value=\"0\" size=\"4\" />";
            } 

If you can see the field with the right values no matter what, the only thing you need is a IF condition.
Anyway, just pointing some direction...