Cannot show Product's Sale Price in Order Confirmations and Invoice

[eleung8448]

Hi Everyone,

I'm trying to get the product's sale price to show in the order confirmations & invoice instead of the base price because some of my products have discounts and I do not like the discount column. I have set up my product details and cart successfully to show the sales price but I can't get it to work in the order confirmations.

Please help and advise!

Here is my code for the order confirmation - detail_items.php

<?php
/**
*
* Order items view
*
* @package   VirtueMart
* @subpackage Orders
* @author Oscar van Eijk, Valerie Isaksen
* @link http://www.virtuemart.net
* @copyright Copyright (c) 2004 - 2010 VirtueMart Team. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* VirtueMart is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* @version $Id: details_items.php 5836 2012-04-09 13:13:21Z Milbo $
*/

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die('Restricted access');

if($this->format == 'pdf'){
   $widthTable = '100';
   $widtTitle = '27';
} else {
   $widthTable = '100';
   $widtTitle = '49';
}

?>
<table width="<?php echo $widthTable ?>%" cellspacing="0" cellpadding="0" border="0">
   <tr align="left" class="sectiontableheader">
      <th align="left" width="10%"><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_SKU') ?></th>
      <th align="left" colspan="2" width="<?php echo $widtTitle ?>%" ><?php echo JText::_('COM_VIRTUEMART_PRODUCT_NAME_TITLE') ?></th>
      <th align="center" width="10%"><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_PRODUCT_STATUS') ?></th>
      <th align="center" width="10%" ><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_PRICE') ?></th>
      <th align="left" width="5%"><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_QTY') ?></th>
      <?php if ( VmConfig::get('show_tax')) { ?>
      <th align="right" width="10%" ><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_PRODUCT_TAX') ?></th>
        <?php } ?>
      <th align="right" width="10%"><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_TOTAL') ?></th>
   </tr>
<?php
   foreach($this->orderdetails['items'] as $item) {
      $qtt = $item->product_quantity ;
      $_link = JRoute::_('index.php?option=com_virtuemart&view=productdetails&virtuemart_category_id=' . $item->virtuemart_category_id . '&virtuemart_product_id=' . $item->virtuemart_product_id);
?>
      <tr valign="top">
         <td align="left">
            <?php echo $item->order_item_sku; ?>
         </td>
         <td align="left" colspan="2" >
            <a href="<?php echo $_link; ?>"><?php echo $item->order_item_name; ?></a>
            <?php
//             vmdebug('tmpl details_item $item',$item);
               if (!empty($item->product_attribute)) {
                     if(!class_exists('VirtueMartModelCustomfields'))require(JPATH_VM_ADMINISTRATOR.DS.'models'.DS.'customfields.php');
                     $product_attribute = VirtueMartModelCustomfields::CustomsFieldOrderDisplay($item,'FE');
                  echo $product_attribute;
               }
            ?>
         </td>
         <td align="center">
            <?php echo $this->orderstatuses[$item->order_status]; ?>
         </td>
         <td align="center"   class="priceCol" >
             <?php echo $this->currency->priceDisplay($item->product_item_price);?>
         </td>
         <td align="center" >
            <?php echo $qtt; ?>
         </td>
         <?php if ( VmConfig::get('show_tax')) { ?>
            <td align="right" class="priceCol"><?php echo "<span  class='priceColor2'>".$this->currency->priceDisplay($item->product_tax ,0, $qtt)."</span>" ?></td>
                                <?php } ?>
         
         <td align="right"  class="priceCol">
            <?php
            $item->product_basePriceWithTax = (float) $item->product_basePriceWithTax;
            $class = '';
            if(!empty($item->product_basePriceWithTax) && $item->product_basePriceWithTax != $item->product_final_price ) {
               echo '<span class="line-through" >'.$this->currency->priceDisplay($item->product_basePriceWithTax,0,$qtt) .'</span><br />' ;
            }

            echo $this->currency->priceDisplay(  $item->product_subtotal_with_tax ,0); //No quantity or you must use product_final_price ?>
         </td>
      </tr>

<?php
   }
?>
<tr class="sectiontableentry1">
         <td colspan="6" align="right"><?php echo "Sub-Total:"; ?></td>

                        <?php if ( VmConfig::get('show_tax')) { ?>
         <td align="right"><?php echo "<span  class='priceColor2'>".$this->currency->priceDisplay($this->orderdetails['details']['BT']->order_tax)."</span>" ?></td>
                        <?php } ?>
         <td align="right"><?php echo $this->currency->priceDisplay($this->orderdetails['details']['BT']->order_salesPrice) ?></td>
        </tr>
<?php
if ($this->orderdetails['details']['BT']->coupon_discount <> 0.00) {
    $coupon_code=$this->orderdetails['details']['BT']->coupon_code?' ('.$this->orderdetails['details']['BT']->coupon_code.')':'';
   ?>
   <tr>
      <td align="right" class="pricePad" colspan="5"><?php echo JText::_('COM_VIRTUEMART_COUPON_DISCOUNT').$coupon_code ?></td>
         <td align="right">&nbsp;</td>

         <?php if ( VmConfig::get('show_tax')) { ?>
            <td align="right">&nbsp;</td>
                                <?php } ?>
      <td align="right"><?php echo '- '.$this->currency->priceDisplay($this->orderdetails['details']['BT']->coupon_discount); ?></td>
      <td align="right">&nbsp;</td>
   </tr>
<?php  } ?>
<tr>
      <td align="right" colspan="6"><?php echo "Shipping & Handing Fee:";?></td>


         <?php if ( VmConfig::get('show_tax')) { ?>
            <td align="right"><?php echo "<span  class='priceColor2'>".$this->currency->priceDisplay($this->orderdetails['details']['BT']->order_shipment_tax)."</span>" ?></td>
                                <?php } ?>
            
            <td align="right"><?php echo $this->currency->priceDisplay($this->orderdetails['details']['BT']->order_shipment); ?></td>

   </tr>

   <?php
      foreach($this->orderdetails['calc_rules'] as $rule){
         if ($rule->calc_kind== 'DBTaxRulesBill') { ?>
         <tr >
            <td colspan="6"  align="right" class="pricePad"><?php echo $rule->calc_rule_name ?> </td>

                                   <?php if ( VmConfig::get('show_tax')) { ?>
            <td align="right"> </td>
                                <?php } ?>
            <td align="right"> <?php echo  $this->currency->priceDisplay($rule->calc_amount);  ?></td>
            <td align="right"><?php echo  $this->currency->priceDisplay($rule->calc_amount);  ?> </td>
         </tr>
         <?php
         } elseif ($rule->calc_kind == 'taxRulesBill') { ?>
         <tr >
            <td colspan="6"  align="right"><?php echo "Tax Total:"; ?> </td>
            <?php if ( VmConfig::get('show_tax')) { ?>
            <td align="right"><?php echo $this->currency->priceDisplay($rule->calc_amount); ?> </td>
             <?php } ?>
         
            <td align="right"><?php echo $this->currency->priceDisplay($this->orderdetails['details']['BT']->order_billTaxAmount); ?></span></td>
         </tr>
         <?php
          } elseif ($rule->calc_kind == 'DATaxRulesBill') { ?>
         <tr >
            <td colspan="6"   align="right" class="pricePad"><?php echo $rule->calc_rule_name ?> </td>
            <?php if ( VmConfig::get('show_tax')) { ?>
            <td align="right"> </td>
             <?php } ?>
            <td align="right"><?php  echo   $this->currency->priceDisplay($rule->calc_amount);  ?> </td>
            <td align="right"><?php echo $this->currency->priceDisplay($rule->calc_amount);  ?> </td>
         </tr>

         <?php
          }

      }
      ?>


   
<tr><td align="right" colspan="8"><hr></td></tr>

   <tr>
      <td align="right" class="pricePad" colspan="6"><strong><?php echo JText::_('COM_VIRTUEMART_ORDER_PRINT_TOTAL') ?></strong></td>

       <?php if ( VmConfig::get('show_tax')) {  ?>
      <td align="right"><span  class='priceColor2'><?php echo $this->currency->priceDisplay($this->orderdetails['details']['BT']->order_billTaxAmount); ?></span></td>
       <?php } ?>
      <td align="right"><strong><?php echo $this->currency->priceDisplay($this->orderdetails['details']['BT']->order_total); ?></strong></td>
   </tr>

</table>

Thank you in advance!

Running Joomla 2.5.8, Virtuemart 2.014

[r_ekkie]

Do you all ready have a solution??? I have the same problem over here.

[eleung8448]

I solved it! This is what you change the code into in invoice_items.php:

Code Select Expand

<td align="right"   class="priceCol" >
    <?php echo '<span >'.$this->currency->priceDisplay($item->product_final_price) .'</span><br />'; ?>
</td>