Product Extra fields on Order Confirmation - Please help !!!

[David M. Graham]

Did you get a chance to post the code you were talking about in earlier reply. I am just stuck on that last bit. Your help is greatly appreciated. Learner.

Sorry it has taken so long -- here is the text of my previously blocked post:

Code: [Select]

<?PHP
    }
    // Extra Products Fields are checked and presented
    $extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
                                        FROM ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf,
                                             ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
                                        WHERE ptf.products_id='".(int)$HTTP_GET_VARS['products_id']."'
                                          and ptf.products_extra_fields_value <> ''
                                          and ptf.products_extra_fields_id = pef.products_extra_fields_id
                                          and (pef.languages_id='0' or pef.languages_id='".$languages_id."')
                                        ORDER BY products_extra_fields_order");
    if ( tep_db_num_rows($extra_fields_query) > 0 ) {
?>
  <tr>
    <td>< ? php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ? ></td>
  </tr>
  <tr>
    <td class="main"><table border="0" cellspacing="1" cellpadding="2">
        <?php
      while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
        if (! $extra_fields['status'])  // show only enabled extra field
          continue;
?>
        <tr>
          <td class="main" valign="top"><b><?php echo $extra_fields['name']; ? >:&nbsp;</b></td>
          <td class="main" valign="top"><?php echo $extra_fields['value']; ? ></td>
        </tr>
        <?php
      }
?>
      </table></td>
  </tr>
  <?php
    }
    // END: Extra Fields Contribution

Is the pertinent section of product_info.php.   Stripped of the HTML - it issues a query to return the product extra fields for a single product ordered by their configured sort order.
It checks that the query returned results (good practice, that). 

Following which it executes a while loop, using tep_db_fetch_array to step through the data set.  During that loop it:

Checks that the field is enabled (0 or 1 in the status field, if contents are 0 the field is disabled).

Skips disabled fields (the "continue" statement)

Generates a two cell table row consisting of the Extra Field Name and the Extra Field Value.

Stops at the end of the array.

Thats all.

Next, we will find the appropriate locations in the checkout process code at which we might want to display this information.

[learner]

Hi David

Did you get a chance to post the code you were talking about in earlier reply.

I am just stuck on that last bit. Your help is greatly appreciated.

Learner.

[learner]

Hi David

Below is the code from checkout_confirmation.tpl.php:

Code: [Select]

<?php
/*
  $Id: checkout_confirmation.tpl.php,v 1.0.0.0 2008/01/16 13:41:11 datazen Exp $

  CRE Loaded, Open Source E-Commerce Solutions
  http://www.creloaded.com

  Copyright (c) 2007 CRE Loaded
  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/ 
// RCI code start
echo $cre_RCI->get('global', 'top');
echo $cre_RCI->get('checkoutconfirmation', 'top');
// RCI code eof
?>   
<table border="0" width="100%" cellspacing="0" cellpadding="<?php echo CELLPADDING_SUB; ?>">
  <?php
  if (SHOW_HEADING_TITLE_ORIGINAL == 'yes') {
    $header_text = '&nbsp;'
    ?>
    <tr>
      <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
        <tr>
          <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
          <!--<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_confirmation.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>-->
        </tr>
      </table></td>
    </tr>
    <tr>
      <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    </tr>
    <?php
  } else {
    $header_text = HEADING_TITLE;
  }
  if (MAIN_TABLE_BORDER == 'yes'){
    table_image_border_top(false, false, $header_text);
  }
  ?>
  <tr>
    <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
      <tr class="infoBoxContents">
        <?php
        if ($sendto != false) {
          ?>
          <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
            <tr>
              <?php
              // RCO start
              if ($cre_RCO->get('checkoutconfirmation', 'editdeliveryaddresslink') !== true) {              
                echo '<td class="main"><b>' . HEADING_DELIVERY_ADDRESS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a></td>' . "\n";
              }
              // RCO end
              ?>
            </tr>
            <tr>
              <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td>
            </tr>
            <?php
            if ($order->info['shipping_method']) {
              ?>
              <tr>
                <?php
                // RCO start
                if ($cre_RCO->get('checkoutconfirmation', 'editshippingmethodlink') !== true) { 
                  echo '<td class="main"><b>' . HEADING_SHIPPING_METHOD . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a></td>' . "\n";
                }
                // RCO end
                ?>
              </tr>
              <tr>
                <td class="main"><?php echo $order->info['shipping_method']; ?></td>
              </tr>
              <?php
            }
            ?>
          </table></td>
          <?php
        }
        ?>
        <td width="<?php echo (($sendto != false) ? '70%' : '100%'); ?>" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <?php
              if (sizeof($order->info['tax_groups']) > 1) {
                ?>
                <tr>
                  <?php
                  // RCO start
                  if ($cre_RCO->get('checkoutconfirmation', 'editproductslink') !== true) {
                    echo '<td class="main" colspan="2"><b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a></td>' . "\n";
                  }
                  // RCO end
                  ?>
                  <td class="smallText" align="right"><b><?php echo HEADING_TAX; ?></b></td>
                  <td class="smallText" align="right"><b><?php echo HEADING_TOTAL; ?></b></td>
                </tr>
                <?php
              } else {
                ?>
                <tr>
                  <?php
                  // RCO start
                  if ($cre_RCO->get('checkoutconfirmation', 'editproductslink') !== true) {
                    echo '<td class="main" colspan="2"><b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a></td>' . "\n";
                  }
                  // RCO end
                  ?>                 
                </tr>
                <?php
              }
              for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
                echo '          <tr>' . "\n" .
                     '            <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . '&nbsp;x</td>' . "\n" .
                     '            <td class="main" valign="top">' . $order->products[$i]['name'];
                if (STOCK_CHECK == 'true') {
                  echo tep_check_stock($order->products[$i]['id'], $order->products[$i]['qty']);
                } 
                if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
                  for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {
                    echo '<br><nobr><small>&nbsp;<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . ' ' . $order->products[$i]['attributes'][$j]['prefix'] . ' ' . $currencies->display_price($order->products[$i]['attributes'][$j]['price'], tep_get_tax_rate($products[$i]['tax_class_id']), 1)  . '</i></small></nobr>';
                  }
                }
                echo '            </td>' . "\n";
                if (sizeof($order->info['tax_groups']) > 1) echo '            <td class="main" valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n";
                echo '            <td class="main" align="right" valign="top">' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . '</td>' . "\n" .
                     '          </tr>' . "\n";
              }
              ?>
            </table></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
    <td class="main"><b><?php echo HEADING_BILLING_INFORMATION; ?></b></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">
      <tr class="infoBoxContents">
        <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
            <?php
            // RCO start
            if ($cre_RCO->get('checkoutconfirmation', 'editbillingaddresslink') !== true) {           
              echo '<td class="main"><b>' . HEADING_BILLING_ADDRESS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT_ADDRESS, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a></td>' . "\n";
            }
            // RCO end
            ?>
          </tr>
          <tr>
            <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br>'); ?></td>
          </tr>
          <tr>
            <?php
            // RCO start
            if ($cre_RCO->get('checkoutconfirmation', 'editpaymentmethodlink') !== true) {               
              echo '<td class="main"><b>' . HEADING_PAYMENT_METHOD . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a></td>' . "\n";
            }
            // RCO end
            ?>
          </tr>
          <tr>
            <td class="main"><?php echo $order->info['payment_method']; ?></td>
          </tr>
        </table></td>
        <td width="70%" valign="top" align="right"><table border="0" cellspacing="0" cellpadding="2">
          <?php
          if (MODULE_ORDER_TOTAL_INSTALLED) {
            $order_total_modules->process();
            echo $order_total_modules->output();
          }
          // RCI code start
          echo $cre_RCI->get('checkoutconfirmation', 'display');
          // RCI code eof     
          ?>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <?php
  if (is_array($payment_modules->modules)) {
    if ($confirmation = $payment_modules->confirmation()) {
      $payment_info = $confirmation['title'];
      if (!isset($_SESSION['payment_info'])) $_SESSION['payment_info'] = $payment_info;
      ?>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td class="main"><b><?php echo HEADING_PAYMENT_INFORMATION; ?></b></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">
          <tr class="infoBoxContents">
            <td><table border="0" cellspacing="0" cellpadding="2">
              <tr>
                <td class="main" colspan="4"><?php echo $confirmation['title']; ?></td>
              </tr>
              <?php
              for ($i=0, $n=sizeof($confirmation['fields']); $i<$n; $i++) {
                ?>
                <tr>
                  <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                  <td class="main"><?php echo $confirmation['fields'][$i]['title']; ?></td>
                  <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                  <td class="main"><?php echo $confirmation['fields'][$i]['field']; ?></td>
                </tr>
                <?php
              }
              ?>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <?php
    }
  }
  ?>
  <tr>
    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <?php
  if (tep_not_null($order->info['comments'])) {
    ?>
    <tr>
      <td class="main"><?php echo '<b>' . HEADING_ORDER_COMMENTS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></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">
        <tr class="infoBoxContents">
          <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
            <tr>
              <td class="main"><?php echo nl2br(tep_output_string_protected($order->info['comments'])) . tep_draw_hidden_field('comments', $order->info['comments']); ?></td>
            </tr>
          </table></td>
        </tr>
      </table></td>
    </tr>
    <tr>
      <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    </tr>
    <?php
  }
  if (MAIN_TABLE_BORDER == 'yes'){
    table_image_border_bottom();
  }
  ?>
  <tr>
    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <?php
  //RCI start
  echo $cre_RCI->get('checkoutconfirmation', 'insideformabovebuttons');
  //RCI end
  ?>     
  <tr>
    <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
      <tr class="infoBoxContents">
        <td>
          <?php
          if (isset($$payment->form_action_url)) {
            $form_action_url = $$payment->form_action_url;
          } else {
            $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL');
          }
          if (ACCOUNT_CONDITIONS_REQUIRED == 'false' ) {
            echo tep_draw_form('checkout_confirmation', $form_action_url, 'post','');
          } else {
            echo tep_draw_form('checkout_confirmation', $form_action_url, 'post','onsubmit="return checkCheckBox(this)"');
          }
          if (is_array($payment_modules->modules)) {
            echo $payment_modules->process_button();
          }
          ?>
          <table border="0" width="100%" cellspacing="0" cellpadding="2">
            <?php
            if (ACCOUNT_CONDITIONS_REQUIRED == 'true') {
              ?>
              <tr>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                <td class="main" colspan="2"><?php echo CONDITION_AGREEMENT; ?> <input type="checkbox" value="0" name="agree"></td>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              </tr>
              <?php
            }
            ?>
            <tr>
              <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              <td class="main"><b><?php echo TITLE_CONTINUE_CHECKOUT_PROCEDURE . '</b><br>' . TEXT_CONTINUE_CHECKOUT_PROCEDURE; ?></td>
              <td class="main" align="right"><?php  echo tep_template_image_submit('button_confirm_order.gif', IMAGE_BUTTON_CONFIRM_ORDER) . "\n";?></td>       
              <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
            </tr>       
            <tr>
              <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              <td class="main">
                <?php 
                echo HEADING_IPRECORDED_1;
                $ip_iprecorded = YOUR_IP_IPRECORDED;
                $isp_iprecorded = YOUR_ISP_IPRECORDED;
                $ip = $_SERVER["REMOTE_ADDR"];
                $client = gethostbyaddr($_SERVER["REMOTE_ADDR"]);
                $str = preg_split("/\./", $client);
                $i = count($str);
                $x = $i - 1;
                $n = $i - 2;
                $isp = $str[$n] . "." . $str[$x]; 
                echo "<div align=\"justify\"><font size=\".1\">$ip_iprecorded: $ip<br>$isp_iprecorded: $isp</div>"; 
                ?>
              </td>
              <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
            </tr>
            <?php
            //RCI start
            echo $cre_RCI->get('checkoutconfirmation', 'insideformbelowbuttons');
            //RCI end
            ?>
          </table></form>
        </td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <?php
  //RCI start
  echo $cre_RCI->get('checkoutconfirmation', 'menu');
  //RCI end
  // RCO start
  if ($cre_RCO->get('checkoutconfirmation', 'checkoutbar') !== true) {               
    ?>
    <tr>
      <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
        <tr>
          <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
            <tr>
              <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td>
              <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>
            </tr>
          </table></td>
          <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>
          <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
            <tr>
              <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>
              <td><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td>
              <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>
            </tr>
          </table></td>
          <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
            <tr>
              <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>
              <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_DELIVERY . '</a>'; ?></td>
          <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_PAYMENT . '</a>'; ?></td>
          <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td>
          <td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td>
        </tr>
      </table></td>
    </tr>
    <?php
  }
  // RCO end
  ?>
</table>
<?php 
// RCI code start
echo $cre_RCI->get('checkoutconfirmation', 'bottom');
echo $cre_RCI->get('global', 'bottom');
// RCI code eof
?>
Thanks David.

[learner]

Thanks a lot David...

[David M. Graham]

Well, I found the appropriate code, nicely explained it and tried to post it.

Blocked by Mod Security.

Will retry after Denver checks the rules...

David

[David M. Graham]

Bah!   I need to look at the product_info page, not the product_listing pages.

I'll look at this tonight and come up with a roughed out plan at least.

David

[David M. Graham]

Well - we will get you unstuck.

The nice thing is - you are at least working at these very valid issues consistently and trying some quite reasonable approaches to deal with them.

You are right - adding this data to the product name is just not on.  Even if you could expand the field in the database, templates just are not all that likely to manage the additional content well.

Within the bounds of the carts current capabilities you can add this information to the Meta tags (manually).  That will help somewhat in getting the information to more spiders and rendering it more relevant on the product information page, and I would recommend this.

But, what you want to do is a very reasonable customization to the cart.  The place to start is with a look at the code which generates the product listings.

This varies depending on configuration settings but includes/modules/product_listing.php and includes/modules/product_listing_col.php are good places to start.  You would be looking for two things -  the code which queries the database for these fields and the code which displays them.

You don't want to store these fields in the order - they are really of no use to you there.  So the two needs above should determine the scope of your project.

I have some urgent things to take care of today, and do not have time to look for this code right now.  If you can look at those, extract what you determine to be the  pertinent portions of the code and post it here, that would move us forward. 



David

[learner]

Hi Graham

Yes, I need this for all products. I will not be using PEF for search options as it is merely to show customer what they are ordering at Order Confirmation.

The other option is to include them in actual Products Name field. For example:

---------------------------------------------------
1 x Antioxidant Formula £7.65
Size: 30
Form: Capsules
---------------------------------------------------

Not sure if this will work. But then when I tried doing that it will not accommodate anything more that VARCHAR(255). I tried changing that from MySQL but it will not allow that as well.

Really stuck.

Thanks Graham.

Learner.

[David M. Graham]

[quote = "learner"]I am using CRE Loaded6 v6.2 Pro[13.1 (SP1)]. I can post my shopping_cart.php for you to have a look if you don't mind to have a look and guide me in the right direction. What I think is that if it works for Product Listing, Shopping Cart then it should work for Order Confirmation as well. It also works for Order Confirmations Emails that are sent to customers once they place an order.

Please correct me if I am wrong...[/quote]

You are wrong.

Here is why.  Product extra fields are (or should be) searchable tags for products.  They are very customizable, and their use can and does vary widely from one cart to the next.  The use to which you would like them put seems very reasonable for your situation - but it is not for everyone.  As CRE Loaded is intended to be a commodity application forcing this usage on everyone is just not reasonable.

That said, what you want should not be all that terribly difficult to do.  Do you need this for all products??

David

[learner]

Hi

Can anybody please help me? I spent a lot of time but it went in vain. Basically, I have product extra fields showing on my product listing page and also in my shopping cart (please see attached screenshot). I want the same fields to appear on Order Confirmation page. Definitely, something needs to be changed on checkout_confirmation.php.

At the moment, Order Confirmation page show the following info:

---------------------------------------------------
1 x Antioxidant Formula £7.65
---------------------------------------------------


But I want it to show as the following on Order confirmation:


---------------------------------------------------
1 x Antioxidant Formula £7.65
Size: 30
Form: Capsules
---------------------------------------------------

I am using CRE Loaded6 v6.2 Pro[13.1 (SP1)]. I can post my shopping_cart.php for you to have a look if you don't mind to have a look and guide me in the right direction. What I think is that if it works for Product Listing, Shopping Cart then it should work for Order Confirmation as well. It also works for Order Confirmations Emails that are sent to customers once they place an order.

Please correct me if I am wrong...


Any help is greatly appreciated. Please help. Thanks in advance.

Learner.