[Checkoutemail] unit price missing from email

mmvvcp

Joined: 2005-12-22
Posts: 21
Posted: Tue, 2006-05-16 17:09

When somebody purchases an item using the checkoutemail, when the email arrives the unit price of the item is missing in the email

As you can see from the screengrab where the £ sign is circled in red it should say what the unit price is ie 10.00 in this case.

Any ideas on what is causing this information not to show

 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Wed, 2006-05-17 18:31

VERY strange... I've never seen that happen before! Can you look at the message source of the email, in the "text" alternative part, and see if there's anything in that bit?

 
dgp

Joined: 2006-05-21
Posts: 5
Posted: Sun, 2006-05-21 08:41

I also have this issue... I have looked in the source for the email sent and it appears like this

=========================
<http://www.xxxxxxx.xxxxx
Title: 06-h-bt-northstars1-036
Ref: 06-h-bt-northstars1-036.jpg
Summary:
Qty: 1 of 4&quot; x 6&quot; Photo [$ each]
Qty: 2 of 5&quot; x 7&quot; Photo [$ each]
Qty: 3 of Emailed Photo [$ each]
Subtotal: $56.00]
=========================

Is this the "text" alternative part you were referring to??

Looking in the source for the table itself doesn't seem to help as there is only the $ symbol and nothing else in there. I am using checkout email module v0.0.6 if this helps. I am also using Checkout module v01.12. I also tried using the latest versions of checkout email and the checkout module but this didn't resolve my issue.

 
chinaski

Joined: 2006-05-31
Posts: 8
Posted: Wed, 2006-05-31 15:38

I'm having this issue as well. Using email v.0.0.7. Any solutions?

 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Fri, 2006-06-02 07:49

OK, looks like there should be a simple explanation for this. I will investigate the code in more detail over the weekend and get back to you all.

 
pesto126

Joined: 2006-05-05
Posts: 8
Posted: Mon, 2006-06-12 18:47

Yes.. same here.. just noticed this!

 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Mon, 2006-06-12 20:08

For everybody who's having this problem, are you using per-item pricing anywhere, or should this just be picking up the default prices from the module admin page?

Please could you post screenshots of them odule configuration page for me as well?

Thanks!

 
mmvvcp

Joined: 2005-12-22
Posts: 21
Posted: Tue, 2006-06-13 11:06

I am not using per item pricing and here is a screen shot of the module configuration page

[img=http://img77.imageshack.us/img77/3171/checkout3xm.th.jpg]

 
bchantre

Joined: 2005-11-16
Posts: 55
Posted: Tue, 2006-06-13 12:17

I have the same problem with the latest version of checkoutemail.

I am not using per item pricing.

 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Tue, 2006-06-13 12:43

Great - thanks for the info. I'll look at it some more and see if I can work it out.

Do you get the same problem if you use the PayPal module, or is it just the email one?

 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Tue, 2006-06-13 19:25

Hello,
I have the same problem with the latest version of checkoutemail, Whith "euro".
When i edit the html souce send whith copy paste in new mail with outlook and i change fonte in Arial no problem.
I thing but i don't know where in the files if we change fontname purhaps???
I'm very new there are 3 day i never know gallery2 it's a very very goooood job.
Sorry for my poor english, i'm french.
Thank you
http://jpl5.mine.nu

AttachmentSize
exemple_arial.jpg40.33 KB
mail_send.jpg37.5 KB
 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Tue, 2006-06-13 20:16

i think i have one solution : in /var/www/html/gallery2/modules/checkoutemail/templates/message.tpl: change with this
the change is line 55 : <P><FONT face=Arial>The following order has been submitted:</P>
and the end in line 187 : <td align="right"><strong>{$csymbol}{$total}</strong></td> </FONT>

here is my source

--{$boundary}
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

{if $showCustomer}
{g->text text="Customer"}: {$custFirstName} {$custLastName}
{g->text text="Email"}: <{$custEmail}>
{g->text text="Recipient"}: {$custRecipientName}
{g->text text="Address"}: {$custAddress1}
{$custAddress2}
{$custAddress3}
{$custAddress4}
{$custAddress5}
{g->text text="Zip"}: {$custZip}
{g->text text="Country"}: {$custCountry}

{g->text text="Comments"}: {$custComments}
{/if}

{foreach from=$items item=item}
=========================
{if $showLinks}
<{g->url arg1="view=core.ShowItem" arg2="itemId=`$item.id`" forceFullUrl=true}>
{/if}
{g->text text="Title"}: {$item.title|markup}
{g->text text="Ref"}: {$item.pathComponent}
{g->text text="Summary"}: {$item.summary|markup}
{section name=x loop=$product}
{if isset($item.quant[x]) }
{g->text text="Qty"}: {$item.quant[x]} {g->text text="of"} {$product[x]} [{$csymbol}{if isset($item.itemPrices[x])}{$item.itemPrices[x]}{else}{$tpl.price[x]}{/if} {g->text text="each"}]
{/if}
{/section}
{if $item.paper != ""}
{g->text text="Paper"}: {$item.paper}
{/if}
{g->text text="Subtotal"}: {$csymbol}{$item.subtotal}]
{/foreach}
=========================

{g->text text="Postage and Packing"}: {$csymbol}{$postage}
{g->text text="Total"}: {$csymbol}{$total}

--{$boundary}
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<title>Order information</title>
</head>

<body>
<P><FONT face=Arial>The following order has been submitted:</P>

{if $showCustomer}
<table cellspacing="5">
<tr>
<td align="right"><strong>{g->text text="First Name"}:</strong></td>
<td>{$custFirstName}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Last Name"}:</strong></td>
<td>{$custLastName}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Email Address"}:</strong></td>
<td>{$custEmail}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Recipient's Name (if different to above)"}:</strong></td>
<td>{$custRecipientName}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Postal Address"}:</strong></td>
<td>{$custAddress1}</td>
</tr>
<tr>
<td align="right">&nbsp;</td>
<td>{$custAddress2}</td>
</tr>
<tr>
<td align="right">&nbsp;</td>
<td>{$custAddress3}</td>
</tr>
<tr>
<td align="right">&nbsp;</td>
<td>{$custAddress4}</td>
</tr>
<tr>
<td align="right">&nbsp;</td>
<td>{$custAddress5}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Postal/Zip Code"}:</strong></td>
<td>{$custZip}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Country"}:</strong></td>
<td>{$custCountry}</td>
</tr>
<tr>
<td align="right"><strong>{g->text text="Comments"}:</strong></td>
<td>{$custComments}</td>
</tr>
</table>
{/if}

<table cellspacing="5">
<tr>
<th>{g->text text="Photo"}</th>
<th>{g->text text="Info"}</th>
<th>{g->text text="Product"}/{g->text text="Price"}/{g->text text="Quantity"}</th>
{if $paper[0] != ""}
<th>{g->text text="Paper"}</th>
{/if}
<th>{g->text text="Subtotal"}</th>
</tr>
<tr>
{foreach from=$items item=item}
<tr>
{if $showThumbs}
<td>
{if $showLinks}
<a href="{g->url arg1="view=core.ShowItem" arg2="itemId=`$item.id`"} forceFullUrl=true">
{/if}
{if isset($thumbnails[$item.id])}
{g->image item=$items[$item.id] image=$thumbnails[$item.id] maxSize=150 forceFullUrl=true}
{else}
{g->text text="No thumbnail"}
{/if}
{if $showLinks}
</a>
{/if}
</td>
{else}
<td>
{if $showLinks}
<a href="{g->url arg1="view=core.ShowItem" arg2="itemId=`$item.id`" forceFullUrl=true}">{$item.pathComponent}</a>
{else}
{$item.pathComponent}
{/if}
</td>
{/if}
<td align="top">
<strong>{g->text text="Title"}:</strong>
{$item.title|markup}<br>
<strong>{g->text text="Summary"}:</strong>
{$item.summary|markup}
</td>
<td>
<table cellspacing="0" cellpadding="10" border="1" bordercolor="#999999">
{section name=x loop=$product}
{if isset($item.quant[x]) }
<tr>
<td><center>{$product[x]}</td>
<td><center>{$csymbol}{if isset($item.itemPrices[x])}{$item.itemPrices[x]}{else}{$tpl.price[x]}{/if}</td>
<td><center><b>{$item.quant[x]}</td>
</tr>
{/if}
{/section}
</table>
</td>
{if $item.paper != ""}
<td>
{$item.paper}
</td>
{/if}
<td align="right"><strong>{$csymbol}{$item.subtotal}</strong></td>
</tr>
{/foreach}
<tr>
{if $paper[0] !=""}
<td colspan="4" align="right">{g->text text="Postage and Packing"}:</td>
{else}
<td colspan="3" align="right">{g->text text="Postage and Packing"}:</td>
{/if}
<td align="right"><b>{$csymbol}{$postage}</b></td>
</tr>
<tr>
{if $paper[0] !=""}
<td colspan="4" align="right"><strong>{g->text text="Total"}:</strong></td>
{else}
<td colspan="3" align="right"><strong>{g->text text="Total"}:</strong></td>
{/if}
<td align="right"><strong>{$csymbol}{$total}</strong></td> </FONT>
</tr>
</tr>
</table>
</body>
</html>

--{$boundary}--

 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Tue, 2006-06-13 20:21

Second probleme, in second row the value price is cut only sign euro. i thing it's in the table
if anyone have solution

thank you

 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Tue, 2006-06-13 21:12

for me that in this code

<table cellspacing="0" cellpadding="20" border="1" bordercolor="#999999">
{section name=x loop=$product}
{if isset($item.quant[x]) }
<tr>
<td><center>{$product[x]}</td>
+++++++++++++++ <td><center>{$csymbol}{if isset($item.itemPrices[x])}{$item.itemPrices[x]}{else}{$tpl.price[x]}{/if}</td>+++++++++++++++++++++++++
<td><center><b>{$item.quant[x]}</td>
</tr>

remove ++++++++++++ to clean selection
i think there are connction with mysql table and "{if isset($item.itemPrices[x])}{$item.itemPrices[x]}{else}{$tpl.price[x]}{/if}" this is not realy good
but php is too much at this time for me

thank you

 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Fri, 2006-06-16 10:01

Hello,
I think, i have the solution:

at line : 158 repalce <td><center>{$csymbol}{if isset($item.itemPrices[x])}{$item.itemPrices[x]}{else}{$tpl.price[x]}{/if}</td>
by

<td><center>{$price[x]} {$csymbol}</td

you can see in attachment.
in fact only variable {$price[x]} is needed.
but perhaps that the author want adding the quantity for each articles and given a total by article?

i hope to have a comment on this subject

AttachmentSize
results_mail.jpg94.43 KB
 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Fri, 2006-06-16 10:34

That may fix the problem you are seeing, but it will also break per-item pricing support.

If you don't use per-item pricing then go ahead and make that change to get around the issue, but I do still need to work out exactly what is going wrong and why.

 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Fri, 2006-06-16 16:54

Yes, it's really interesting to have total per item but without anything it's not usable
Nota : on the web page we d'ont have price per item only unit price and that we must have on the mail.
Now if you have time to correct them, i woud like to suggest to you : Adding a column to have unit price and price per qty.
Thank you for answer.

ps see attachment with "add album (3 photos) with multi choise item the mail is correct but better with your correction.

Good job

AttachmentSize
resluts_add_album.jpg149.73 KB
 
jplorge
jplorge's picture

Joined: 2006-06-13
Posts: 7
Posted: Fri, 2006-06-16 17:17

Other probleme with case choise in checkoutmail module, (for me it's not very important). with outlook , if case Thumbnail is "on" i d'ont have the image in the mail, but the same mail with yahoo show image. other if case thumbnail and link are "on" the link is cut like this : (see attachments)
thank you

AttachmentSize
link_correct_without_thumb.jpg102.86 KB
result_yahoo.jpg105.65 KB
result_outlook2.jpg93.84 KB
 
pesto126

Joined: 2006-05-05
Posts: 8
Posted: Mon, 2006-06-19 19:05

Looking for a solution still.... I've tried a bunch of things to no avail.. I'm using global pricing only. Please!!

 
paulcobb

Joined: 2006-05-04
Posts: 122
Posted: Sun, 2006-07-16 14:14

Hi,
Have there been any thoughts on how to fix this issue yet?
I have the same problem.

On checkoutemail
The unit price is not shown on my confirmation email, only the sub-total for each item.

On checkoutpaypal
There is only a total shown for each item on my confirmation email(but that may be how it's supposed to be ?)

Thanks

 
sphism
sphism's picture

Joined: 2006-10-11
Posts: 4
Posted: Wed, 2006-12-06 12:14

HI,

I'm getting this error too.

At first i was just using the global price settings and i get teh same error as in the first post.

I then tested per item pricing, the products that use per item pricing don't get this error, whilst the ones using global pricing still get the error.

Would be great to see a fix for this

Great module by the way, i love the email invoice with thumbnanils :)

cheers,

m

 
parkiet

Joined: 2006-03-16
Posts: 22
Posted: Tue, 2007-01-16 21:27

I had the same problem with the currency symbol and tried the solution of jplorge in post 7. It helped and solved the problem. I did not use per item pricing. As I am using outlook for my email, I wonder if the possibility for receiving graphics from the internet is put correct (options - security tab - settings for automatic downloads). Maybe this is not the problem, but I receive the email with the thumbnails correct on my computer. Anyway thanks to jplorge for the help with the currency symbol and thurnbulm for the really great checkout modules!
P.

 
Dozza
Dozza's picture

Joined: 2007-08-28
Posts: 112
Posted: Wed, 2007-12-05 18:35

How do you go about 'per item pricing'? Doe's this allow you to order multiple format prints of the same photo?

DMC