Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Add New Products fields


surplus

Recommended Posts

Wondering if you knew this off the top of your head.

 

I installed Add new products fields http://www.oscommerce.com/community/contri...arch,new+fields

 

Everything seems to be working fine, but the actual field name does not show up on my site.

 

My Site

 

 

Below the price you will see a "14" In front of that I want it to say Issues:

 

the new field added is products_issues

 

 

any help is greatly appreciated.

Link to comment
Share on other sites

go to the product_info.php locate the code for the new field product_issues and before it code the text Issues:

 

or define the text in the languages file and then in product_info.php code in the text define

 

or post your code for product_info.php and someone will do it all for you

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

<?php
/*
 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);
// ADDED BY CLEMENT for design  
 define('HEADING_IMAGE_FILE', 'table_background_default.gif');
 require(DIR_WS_INCLUDES . FILENAME_DESIGN);
//**    

 $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
 $product_check = tep_db_fetch_array($product_check_query);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML <?php echo HTML_PARAMS; ?>>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=<?php echo CHARSET; ?>">
<TITLE><?php echo TITLE; ?></TITLE>
<BASE HREF="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<LINK REL="stylesheet" TYPE="text/css" HREF="stylesheet.css">
<script language="javascript"><!--
function popupWindow(url) {
 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
ft=150')
}
//--></SCRIPT>
<?php echo HEAD_TAGS; ?>

<?php echo BODY_TAG; ?>

<!-- header //-->

<?php
require(DIR_WS_INCLUDES . 'header.php'); 


if (COLUMN_LEFT_DISPLAY == 'true') {
echo '<!-- left_navigation //-->';
require(DIR_WS_INCLUDES . 'column_left.php'); 
echo '<!-- left_navigation_eof //-->';
}
?>

<!-- body_text //-->
   <TD <?php echo CONTENT_PARAM_FIRST_TD; ?>>
<?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>

      <?php echo CONTENT_TOP_FIRST_TD; ?>

<TABLE <?php echo CONTENT_PARAM_FIRST_TABLE; ?>>

<?php
 if ($product_check['total'] < 1) {
?>
      <?php echo CONTENT_TOP_FIRST_TABLE; ?>
   
     <TR>
       <TD><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></TD>
     </TR>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
     <TR>
       <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="1" CELLPADDING="2" CLASS="infoBox_button">
         <TR CLASS="infoBoxContents_button">
           <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="0" CELLPADDING="2">
             <TR>
               <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD>
               <TD ALIGN="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></TD>
               <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD>
             </TR>
           </TABLE></TD>
         </TR>
       </TABLE></TD>
     </TR>
<?php
 } else {
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_issues, p.products_retail_price, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
   $product_info = tep_db_fetch_array($product_info_query);

   tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

   if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
     $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
   } else {
     $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
   }

   if (tep_not_null($product_info['products_model'])) {
     $products_name = $product_info['products_name'] . ' <span class="smallText">[' . $product_info['products_model'] . ']</span>';
   } else {
     $products_name = $product_info['products_name'];
   }
?>
     <TR>
       <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="0" CELLPADDING="0">
         <TR>
           <TD CLASS="pageHeading" VALIGN="top"><?php echo $products_name; ?></TD>
          </TR>
    <TR>
           <TD ALIGN="right" VALIGN="top" style="font-family: Tahoma; font-size: 20px; color: #4F576A; font-weight: bold; padding-right: 10px;"><?php echo $products_price; ?></TD>
         </TR>
       </TABLE></TD>
     </TR>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
     <TR>
       <TD CLASS="main">
<?php
   if (tep_not_null($product_info['products_image'])) {
?>
         <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2" ALIGN="right">
           <TR>
             <TD ALIGN="center" CLASS="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');
//--></SCRIPT>
<NOSCRIPT>
<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
</noscript>
</td>
</tr>
</table>
<?php
}
include(DIR_WS_MODULES . 'ezier_new_fields.php'); 
// START: Extra Fields Contribution
$products_extra_fields_query = tep_db_query("SELECT pef.*,ptf.* FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef, " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " ptf WHERE ptf.products_id=" . (int)$HTTP_GET_VARS['products_id'] . " AND pef.products_extra_fields_status = 1 ORDER BY products_extra_fields_order");
while ($products_extra_fields = tep_db_fetch_array($products_extra_fields_query)) {
 $extra_product_field[$products_extra_fields['products_extra_fields_id']] = $products_extra_fields['products_extra_fields_value'];
}

$extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " WHERE products_extra_fields_status = 1 ORDER BY products_extra_fields_order");
while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
 if ($extra_product_field[$extra_fields['products_extra_fields_id']] != '') {
?>
       <b><?php echo $extra_fields['products_extra_fields_name']; ?>:</b> 
       <?php echo $extra_product_field[$extra_fields['products_extra_fields_id']]; ?><br />
<?
 }
}
// END: Extra Fields Contribution
?>
         <P><?php echo stripslashes($product_info['products_issues']); ?></P>
         <P><?php echo stripslashes($product_info['products_description']); ?></P>
<?php
   $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
   $products_attributes = tep_db_fetch_array($products_attributes_query);
   if ($products_attributes['total'] > 0) {
?>
         <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2">
           <TR>
             <TD CLASS="main" COLSPAN="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></TD>
           </TR>
<?php
     $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
     while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
       $products_options_array = array();
       $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
       while ($products_options = tep_db_fetch_array($products_options_query)) {
         $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
         if ($products_options['options_values_price'] != '0') {
           $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
         }
       }

       if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
         $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
       } else {
         $selected_attribute = false;
       }
?>
           <TR>
             <TD CLASS="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></TD>
             <TD CLASS="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></TD>
           </TR>
<?php
     }
?>
         </TABLE>
<?php 
 //sandalwood
 if (tep_not_null($product_info['products_issues'])) {
 echo TEXT_PRODUCTS_SIZE.' '.$product_info['products_issues'];
 } 
 //end of sandalwood
 ?>
<?php
   }
?>
       </TD>
     </TR>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
<?php
   $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
   $reviews = tep_db_fetch_array($reviews_query);
   if ($reviews['count'] > 0) {
?>
     <TR>
       <TD CLASS="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></TD>
     </TR>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
<?php
   }

   if (tep_not_null($product_info['products_url'])) {
?>
     <TR>
       <TD CLASS="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></TD>
     </TR>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
<?php
   }

   if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
?>
     <TR>
       <TD ALIGN="center" CLASS="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></TD>
     </TR>
<?php
   } else {
?>
     <TR>
       <TD ALIGN="center" CLASS="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></TD>
     </TR>
<?php
   }
?>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
     <TR>
       <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="1" CELLPADDING="2" CLASS="infoBox_button">
         <TR CLASS="infoBoxContents_button">
           <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="0" CELLPADDING="2">
             <TR>
               <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD>
               <TD CLASS="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></TD>
               <TD CLASS="main" ALIGN="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></TD>
               <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD>
             </TR>
           </TABLE></TD>
         </TR>
       </TABLE></TD>
     </TR>
     <TR>
       <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD>
     </TR>
     <TR>
       <TD>
<?php
   if ((USE_CACHE == 'true') && empty($SID)) {
     echo tep_cache_also_purchased(3600);
   } else {
     include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
   }
 }
?>
       </TD>
     </TR>
     <?php echo CONTENT_BOTTOM_FIRST_TABLE; ?>   
   </TABLE></form>
   <?php echo CONTENT_BOTTOM_FIRST_TD; ?>
</TD>
<!-- body_text_eof //-->

<?php
if (COLUMN_RIGHT_DISPLAY == 'true') {
echo '<!-- right_navigation //-->';
require(DIR_WS_INCLUDES . 'column_right.php');
echo '<!-- right_navigation_eof //-->';
}

require(DIR_WS_INCLUDES . 'footer.php'); 
?>

<?php echo ENDING_TAGS; ?>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

this code here

<?php 
//sandalwood
if (tep_not_null($product_info['products_issues'])) {
echo TEXT_PRODUCTS_SIZE.' '.$product_info['products_issues'];
} 
//end of sandalwood
?>
<?php
? }
?>

and more so the TEXT_PRODUCTS_SIZE should give you the text.

 

There should be a define in catalog/includes/languages/english/product_info.php

define('TEXT_PRODUCTS_SIZE', 'Issues:');

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

I am having another issue with this as well

 

I went ahead and put issues in the field on the easy populate sheet. But now I am limited to the number of characters.

 

I can only put in Issues:#

 

I want to have a format like Issues: ##

 

how do I expand the field so it will accept a space and 2 more digits.

 

my site

 

thanks for your help

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...