The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 01-30-2015, 02:52 AM
Booster Store Admin:6517065@deleted's Avatar
Booster Store Admin:6517065@deleted is offline
Junior Member
 
Join Date: Jan 2015
Posts: 3
Default

In email Order Confirmation, the currency symbol for USD appears AFTER the numbers in the price.


(EDIT: I've attached a screenshot of the email to show the issue.)

I'm testing a new store (it's not live until I'm sure it works as needed). When the Order Confirmation email arrives, in the table where the products and prices are shown, the currency symbol for USD appears AFTER the numbers in the price. For example, it displays 19.99$, instead of the correct format $19.99. I've edited some of the HTML in the default Order Confirmation email (System Settings | Mail | Order Confirmation), but nothing in the section that formats the table with products and prices.

Is there a toggle/setting/code edit to ensure the currency format is correct?

In the Control Panel I've tripled-check that the System Settings | Formats & Units are correct (Currency display format=1,999.99, Currency=U.S. dollar ($), Currency symbol=>prefix=$, suffix=blank). The currency display example shows as $1,234.00").

Any help would be greatly appreciated!

It takes up a huge amount of space below, but here is the HTML (my apologies if it's not good etiquette):

Code:
<tr>
    <td align="left" valign="top" style="padding-top:8px;">
        <table border="0" width="100%" cellpadding="0" cellspacing="0" style="border: 1px solid #dadada;">
            <tr>
                <td style="padding-top: 20px;padding-right: 20px;padding-bottom: 0;padding-left: 20px;" class="emailProductContainer">
                    <table cellpadding="0" cellspacing="0">
                        <tr>
                            <td>
                                <table cellpadding="0" cellspacing="0">
                                    <!-- Order items : start -->
                                    <#list order.items as orderItem>
                                        <tr>
                                            <td valign="top" width="600" style="padding-bottom: 20px;" class="emailProduct">
                                                <!-- Order item: start -->
                                                <table border="0" cellpadding="0" cellspacing="0" style="table-layout: fixed;">
                                                    <tr>
                                                        <td align="left" valign="middle" style="padding-left: 20px;" class="emailProductDesc">
                                                            <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                                                <tr>
                                                                    <td style="font-family: Arial,sans-serif; font-size: 14px;line-height: normal; padding-top: 5px" class="emailProductName">
                                                                        <a href="${orderItem.customerUrl}" style="display: block; text-decoration: none; color: #005aae">
                                                                            ${orderItem.name}
                                                                        </a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #999999; padding-top: 11px;">
                                                                        SKU: #${orderItem.sku}<br/>
                                                                        ${orderItem.formattedOptions}
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td style="font-family: Arial,sans-serif; font-size: 14px;line-height: normal; color: #000000;padding-top: 9px;">
                                                                        ${orderItem.quantity} × ${orderItem.price}
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </td>
                                                    </tr>
                                                </table>
                                                <!-- Order item: end -->
                                            </td>
                                        </tr>
                                    </#list>
                                    <!-- Order items : end -->
                                </table>
                            </td>
                        </tr>

                        <tr>
                            <!-- Order totals : start -->
                            <td align="left" valign="top" class="emailProductTotal">
                                <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                    <tr>
                                        <td style="padding-top: 16px;padding-bottom: 23px;padding-left: 20px; border-top: 1px solid #DADADA;">

                                            <table cellpadding="0" cellspacing="0" border="0" align="right" width="50%">
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000; padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        ${order.items?size} items
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;white-space: nowrap;">
                                                        ${order.subtotal}
                                                    </td>
                                                </tr>
                                                <#if order.isShippingRequired>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        Shipping
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;white-space: nowrap;">
                                                        ${order.shippingCost}
                                                    </td>
                                                </tr>
                                                </#if>
                                                <#list order.taxes as tax>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        ${tax.name}
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;white-space: nowrap;">
                                                        ${tax.value}
                                                    </td>
                                                </tr>
                                                </#list>
                                                <#list order.discounts as discount>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        ${discount.name}
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000; white-space: nowrap;">
                                                        -${discount.value}
                                                    </td>
                                                </tr>
                                                </#list>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 18px;line-height: normal; color: #000000;padding-top: 6px;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        <b>Total</b>
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 18px;line-height: normal; color: #000000; padding-top: 6px;white-space: nowrap;">
                                                        <b>${order.total}</b>
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                            <!-- Order totals : end -->
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
    </td>
</tr>
Attached Images
File Type: jpg Picture1.jpg (114.7 KB, 153 views)

Last edited by Clara K; 01-30-2015 at 07:39 AM.
  #2  
Old 01-30-2015, 09:27 AM
WoodYouLike's Avatar
WoodYouLike WoodYouLike is offline
 
Join Date: Aug 2010
Posts: 593
Default

Have you checked the default settings in System Settings - Formats & Units - Currency pre-fix and/or suffix?
__________________
Owner/manager of [URL="http://www.woodyoulike.co.uk"]Wood You Like Ltd[/URL], independent retailer of quality wooden flooring in rural Kent UK
Creator of E-guide "[URL="http://blog.1plus1makes3.co.uk/selling-online.html"]Selling Online Basics[/URL]" :ecwid:
  #3  
Old 01-30-2015, 09:50 AM
Rick G's Avatar
Rick G Rick G is offline
Ecwid Team
 
Join Date: Jun 2014
Posts: 1,271
Default

Quote:
Originally Posted by Booster Store Admin View Post
(EDIT: I've attached a screenshot of the email to show the issue.)

I'm testing a new store (it's not live until I'm sure it works as needed). When the Order Confirmation email arrives, in the table where the products and prices are shown, the currency symbol for USD appears AFTER the numbers in the price. For example, it displays 19.99$, instead of the correct format $19.99. I've edited some of the HTML in the default Order Confirmation email (System Settings | Mail | Order Confirmation), but nothing in the section that formats the table with products and prices.

Is there a toggle/setting/code edit to ensure the currency format is correct?

In the Control Panel I've tripled-check that the System Settings | Formats & Units are correct (Currency display format=1,999.99, Currency=U.S. dollar ($), Currency symbol=>prefix=$, suffix=blank). The currency display example shows as $1,234.00").

Any help would be greatly appreciated!

It takes up a huge amount of space below, but here is the HTML (my apologies if it's not good etiquette):

Code:
<tr>
    <td align="left" valign="top" style="padding-top:8px;">
        <table border="0" width="100%" cellpadding="0" cellspacing="0" style="border: 1px solid #dadada;">
            <tr>
                <td style="padding-top: 20px;padding-right: 20px;padding-bottom: 0;padding-left: 20px;" class="emailProductContainer">
                    <table cellpadding="0" cellspacing="0">
                        <tr>
                            <td>
                                <table cellpadding="0" cellspacing="0">
                                    <!-- Order items : start -->
                                    <#list order.items as orderItem>
                                        <tr>
                                            <td valign="top" width="600" style="padding-bottom: 20px;" class="emailProduct">
                                                <!-- Order item: start -->
                                                <table border="0" cellpadding="0" cellspacing="0" style="table-layout: fixed;">
                                                    <tr>
                                                        <td align="left" valign="middle" style="padding-left: 20px;" class="emailProductDesc">
                                                            <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                                                <tr>
                                                                    <td style="font-family: Arial,sans-serif; font-size: 14px;line-height: normal; padding-top: 5px" class="emailProductName">
                                                                        <a href="${orderItem.customerUrl}" style="display: block; text-decoration: none; color: #005aae">
                                                                            ${orderItem.name}
                                                                        </a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #999999; padding-top: 11px;">
                                                                        SKU: #${orderItem.sku}<br/>
                                                                        ${orderItem.formattedOptions}
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td style="font-family: Arial,sans-serif; font-size: 14px;line-height: normal; color: #000000;padding-top: 9px;">
                                                                        ${orderItem.quantity} × ${orderItem.price}
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </td>
                                                    </tr>
                                                </table>
                                                <!-- Order item: end -->
                                            </td>
                                        </tr>
                                    </#list>
                                    <!-- Order items : end -->
                                </table>
                            </td>
                        </tr>

                        <tr>
                            <!-- Order totals : start -->
                            <td align="left" valign="top" class="emailProductTotal">
                                <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                    <tr>
                                        <td style="padding-top: 16px;padding-bottom: 23px;padding-left: 20px; border-top: 1px solid #DADADA;">

                                            <table cellpadding="0" cellspacing="0" border="0" align="right" width="50%">
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000; padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        ${order.items?size} items
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;white-space: nowrap;">
                                                        ${order.subtotal}
                                                    </td>
                                                </tr>
                                                <#if order.isShippingRequired>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        Shipping
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;white-space: nowrap;">
                                                        ${order.shippingCost}
                                                    </td>
                                                </tr>
                                                </#if>
                                                <#list order.taxes as tax>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        ${tax.name}
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;white-space: nowrap;">
                                                        ${tax.value}
                                                    </td>
                                                </tr>
                                                </#list>
                                                <#list order.discounts as discount>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        ${discount.name}
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 12px;line-height: normal; color: #000000; white-space: nowrap;">
                                                        -${discount.value}
                                                    </td>
                                                </tr>
                                                </#list>
                                                <tr>
                                                    <td align="left" valign="top" width="100%" style="font-family: Arial,sans-serif; font-size: 18px;line-height: normal; color: #000000;padding-top: 6px;padding-left: 32px;padding-right: 20px;white-space: nowrap;">
                                                        <b>Total</b>
                                                    </td>
                                                    <td align="right" valign="top" style="font-family: Arial,sans-serif; font-size: 18px;line-height: normal; color: #000000; padding-top: 6px;white-space: nowrap;">
                                                        <b>${order.total}</b>
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                            <!-- Order totals : end -->
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
    </td>
</tr>
Hi,

Thank you for contacting us.

I checked your store and I see that in your store the currency display method is set to display the price in this format:
Quote:
$1,999.99
When I try to view a preview of the email notification in your store or send a test email in my test store, I get the email with the following format:
Quote:
1999.99$
However if you try to make a test purchase in your store, you will receive an email notification with the currency format that you specified in your store settings.

So all your 'live' sale notifications display the currency correctly now, but the preview and test emails display the first format only at the moment. I've reported this issue to our development team and I will inform you here as soon as the fix is released.
Thank you.
__________________
Ecwid API and App Market Team
Ecwid Developer Website
  #4  
Old 01-30-2015, 02:48 PM
Booster Store Admin:6517065@deleted's Avatar
Booster Store Admin:6517065@deleted Booster Store Admin:6517065@deleted is offline
Junior Member
 
Join Date: Jan 2015
Posts: 3
Default

Yes, I checked those settings several times to be sure they were set correctly. From the Ecwid reply it appears it might be an opportunity for improvement. I will start some live tests with a PayPal test credit card. Hopefully the live order confirmations come through with the currency symbol in the correct format.

Thank you!
  #5  
Old 02-02-2015, 09:05 PM
Rick G's Avatar
Rick G Rick G is offline
Ecwid Team
 
Join Date: Jun 2014
Posts: 1,271
Default

Quote:
Originally Posted by Booster Store Admin View Post
Yes, I checked those settings several times to be sure they were set correctly. From the Ecwid reply it appears it might be an opportunity for improvement. I will start some live tests with a PayPal test credit card. Hopefully the live order confirmations come through with the currency symbol in the correct format.

Thank you!
Hi,

I understand that it is very important to see the HTML notifications that are sent to the customers in the preview and by sending a test email. Did you try to place a test order in your store and see how your HTML notifications look then? Please let me know if you have any questions.

I will post an update here when the fix for the preview notifications is released.
Thank you.
__________________
Ecwid API and App Market Team
Ecwid Developer Website
The Following User Says Thank You to Rick G For This Useful Post:
  #6  
Old 02-09-2015, 01:07 AM
Booster Store Admin:6517065@deleted's Avatar
Booster Store Admin:6517065@deleted Booster Store Admin:6517065@deleted is offline
Junior Member
 
Join Date: Jan 2015
Posts: 3
Default

Sorry for the delayed reply...

Yes, I placed a test order and the currency format in the Order Confirmation email was correct (e.g., $123.45).

Thank you again for the follow-up!
  #7  
Old 03-05-2015, 03:02 PM
Rick G's Avatar
Rick G Rick G is offline
Ecwid Team
 
Join Date: Jun 2014
Posts: 1,271
Default

Hi,

We have released an update today that will change the way your currency is displayed when oyu preview your HTML notifications.

Please let me know if you still experience this issue.
Thank you!
__________________
Ecwid API and App Market Team
Ecwid Developer Website
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
currency format, currency symbol, email confirmation, order confirmation, usd

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:40 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.