Order Confirmation Email Template

[EIF]

Ok, I will check that site.

I used to have an extension for the e-mails. I found in that code something about setting the date format.

Code Select Expand

    private function userFormattedDate($timestamp, $timezone) {
    $dateFormat = emp_helper::getGlobalParam('date_format');
   
    $date = new JDate();
   
    if(!function_exists('date_timestamp_set')){
    $tmpdate = getdate( ( int ) $timestamp );
    $date->setDate( $tmpdate['year'] , $tmpdate['mon'] , $tmpdate['mday'] );
    $date->setTime( $tmpdate['hours'] , $tmpdate['minutes'] , $tmpdate['seconds'] );
    }
    else{
    $date->setTimestamp($timestamp);
    }
    $date->setTimezone(new DateTimeZone($timezone));
   
    $ret = $date->format($dateFormat, true);
   
    return $ret;
    }
   
private function userFormattedDateLocale($timestamp, $timezone, $locale = null) {
if (!is_null($locale)){
$curLocale = setlocale(LC_CTYPE, 0);
setlocale(LC_CTYPE, $locale);
setlocale(LC_TIME, $locale);
}

$dateFormat = emp_helper::getGlobalParam('date_format_locale');

$defTZ = date_default_timezone_get();
date_default_timezone_set($timezone);
$date = strftime($dateFormat, $timestamp);
date_default_timezone_set($defTZ);

if ($date === false){
$dateFormat = "%b %d, %Y";
$date = strftime($dateFormat); //March 10, 2011
}

if(!is_null($locale)){
setlocale(LC_CTYPE, $curLocale);
setlocale(LC_TIME, $curLocale);
}

return $date;
}
}

[Studio 42]

If you use Joomla, the timezone is set by user(in your case too), but this is not the right timeZone when you send yourself the mail or if user is not connected.
So i think timezone should be manually set or it's better to use UTC time zone.
You can use

Code Select Expand

$format = JText::_('DATE_FORMAT_LC4'); // or DATE_FORMAT_LC3
$date = JFactory::getDate($mydate, 'UTC');
echo $date->toFormat($format);

[mausci1969]

So no other ideas in about how to change my confirmation email columns?

[AH]

mausci1969

There are not really any "other ideas"  - you need to change the templates for the files that are used in email confirmation.

Studio42 has given you some input to this in the previous posts.

If you cannot see how to do this then you may need to engage a developer.

[EIF]

Looks like in virtuemart 3.2.14 the layout of the e-mail has been changed.

I put back my own code in thes mail_html files. Also in invoice_items.php. But still the table of the items (sku, name, price, etc) is the standaard of virtuemart. Somehow my own code has not beed used.
Where is this new virtuemart code of the invoice items now, which I need to edit? The rest of the e-mail displays my own layout, except the table of the invoice items.


Edit: found it! Looks like mail_html_pricelist.php is used now, not only invoice_items.php.

[bryanearl]

I have used this method to show the product image on my invoices, and I have it working properly.

It took me forever searching for a way to specify the image size displayed on the invoice, so I wanted to share the trick because making a DIV around the image php code and specifying width and height there has no effect.

You need to add "$width=X,$height=X" to the php code displaying the image:

Code Select Expand

<?php if (!empty($item->images[0])) { echo $item->images[0]->displayMediaThumb ('',FALSE,"", true, false, true,$width=50,$height=50); } ?>

[Robert_ITMan]

Edit: found it! Looks like mail_html_pricelist.php is used now, not only invoice_items.php.

THANKS EIF!
I might never have figured this out without your note!

[GJC Web Design]

why are u people not using template over rides?

[Robert_ITMan]

why are u people not using template over rides?

GJC,

We are using our template over rides - the issue here is that if you only have the one over ride file invoice_items.php it does not work for us you also need to add the file mail_html_pricelist.php (unedited) as having only the file invoice_items.php is not enough to get our own template file to be used -- a bug since 3.2.12?

[StefanSTS]

There is no bug,
earlier one file was called by the other, so both price list tables were the same.

For good reason, to have different tables for mail and invoice, this has been changed. So finally you can easily leave out columns or rows in your invoice that you show in your mail.
The status column is one of the examples. Many shop owners want to show the status of single products in the email, but the invoice is delivered without the status.

Regards
Stefan