Order subtotal in new PR8 customer email

[koala]

I'm trying to get the order subtotal to show up in the new PR8 order confirmation email and I'm not having any luck.

I've tried a few approaches, not sure what I'm doing wrong.

&mvt:option:formatted_subtotal;

I've also tried assigning toolkit and using a few different bits of code with this module to no luck.

Any thoughts? This is the only missing piece to my modified confirmation email.

[jsdva]

Re: Order subtotal in new PR8 customer email

Maybe: &mvt:item:formatted_subtotal;

[koala]

Re: Order subtotal in new PR8 customer email

I just tried that one, it gives the subtotal of the last product.

Hopefully it's something simple that I'm just not thinking of...

[Leanne]

Re: Order subtotal in new PR8 customer email

Do you want the order subtotal or the option subtotal? Your question is about the order, but the smt code you posted is for attribute options.

[koala]

Re: Order subtotal in new PR8 customer email

Hi Leanne,

I want the order subtotal. I've got a line by line subtotal (by default this is in that template-- I've just extended it to show the "Price/Ea" as well).

Some customers just really want to see their order total prior to tax and shipping

[wcw]

Re: Order subtotal in new PR8 customer email

See #117 at http://www.emporiumplus.com/1AA00223.html

[wajake41]

Re: Order subtotal in new PR8 customer email

Hi Dylan: I'm testing the new Customer Order Confirmation email on our sites (both cssui & mmui) and have found that there is no column heading for price each and that the price each amount is being displayed in the total price column. Also the total price for each item is not being displayed at all.

On the plus side, the invoice total amount itself is being displayed correctly at the bottom of the total amount column.

Are you seeing anything like this?

Larry

[koala]

Re: Order subtotal in new PR8 customer email

Hi Larry,

They removed the Price/Ea column from the previous "HTML Invoice" template.

This is what my code looks like now that I've modified it:

<table style="border-collapse: collapse; border-spacing: 0; font-size: 100%; color: #676767; border: 1px solid #c7c8d7; width: 690px;">
            <tr>
            
                <th style="font-size: 16px; color: #5b639c; padding: 5px 20px 5px 20px; vertical-align: top; text-align: left;">Product</th>
                <th style="font-size: 16px; color: #5b639c; padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">Quantity</th>
                <th style="font-size: 16px; color: #5b639c; padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">Price/Ea</th>
                <th style="font-size: 16px; color: #5b639c; padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">Total</th>
            </tr>

            <mvt:foreach iterator="item" array="order:items">
                <tr style="background-color: #f7f7f7; font-weight: bold;">
                
                    <td style="padding: 5px 20px 5px 20px; vertical-align: top; text-align: left;">&mvt:item:name;</td>
                    <td style="padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">&mvt:item:quantity;</td>
<td style="padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">&mvt:item:formatted_price;</td>
                    <td style="padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">&mvt:item:formatted_subtotal;</td>
                </tr>

                <mvt:foreach iterator="option" array="item:options">
                    <tr>
                        
                        <td style="padding: 5px 20px 5px 20px; vertical-align: top; text-align: left;">
                            <mvt:if expr="l.settings:option:option_id">
                                &mvt:option:attr_code;: &mvt:option:opt_code;
                            <mvt:elseif expr="NOT ISNULL l.settings:option:data">
                                &mvt:option:attr_code;: &mvt:option:data;
                            <mvt:elseif expr="NOT ISNULL l.settings:option:data_long">
                                &mvt:option:attr_code;: &mvt:option:data_long;
                            <mvt:else>
                                &mvt:option:attr_code;
                            </mvt:if>
                        </td>
                        <td></td>
                    <td></td>
                        <td style="padding: 5px 20px 5px 20px; vertical-align: top; width: 60px; text-align: right;">
                            <mvt:if expr="l.settings:option:subtotal">
                                &mvt:option:formatted_subtotal;
                            </mvt:if>
                        </td>
                    </tr>
                </mvt:foreach>
            </mvt:foreach>

            <tr style="background-color: #f7f7f7;">
                
                <td colspan="3" style="padding: 5px 20px 5px 20px; vertical-align: bottom; text-align: right;">
                    <mvt:foreach iterator="charge" array="order:charges">
                        &mvt:charge:descrip;:<br />
                    </mvt:foreach>

                    <h2 style="font-size: 16px; color: #5b639c; margin: 0;">Total:</h2>
                </td>

                <td style="padding: 5px 20px 5px 20px; vertical-align: bottom; text-align: right;">
                    <mvt:foreach iterator="charge" array="order:charges">
                        &mvt:charge:formatted_disp_amt;<br />
                    </mvt:foreach>

                    <h2 style="font-size: 16px; color: #5b639c; margin: 0;">&mvt:order:formatted_total;</h2>
                </td>
            </tr>            
        </table>

Please note that I removed the CODE column as I do not find this column useful from a customers perspective.

[wajake41]

Re: Order subtotal in new PR8 customer email

Hi Dylan:
you said that "They removed the Price/Ea column from the previous "HTML Invoice" template." That wasn't done on purpose was it? This must be a mistake?

My invoice is showing the price each cost in the total column and then the price each cost X quantity at the bottom of the total column. The column doesn't add down to this invoice amount.

Is the template with the price each column available.

Larry

[jsisk]

Re: Order subtotal in new PR8 customer email

This is the reply I received when I asked about it:

You're right it's a bug.


Here's what it's supposed to be:


It should be using &mvt:item:formatted_subtotal; instead of
&mvt:item:formatted_price;


Go ahead and edit your template manually.

[wajake41]

Re: Order subtotal in new PR8 customer email

I've got to ask. In my entire 35 years in DP, I have never before seen an invoice where the price each is not on the invoice. Why has this been done?
Larry

[blubbert]

Re: Order subtotal in new PR8 customer email

For those of you interested in using Bill's Toolkit solution to getting the order subtotal, here is the code that Bill helped me work out.

<mvt:item name="toolkit" param="order|ocount|l.all_settings:order:id" />
                &mvte:toolkit:ordersubtotalF;

Once you have this then he has several more items that work as well.

&mvte:toolkit:orderweight;

By the way, I just have put in a quick recommendation for modules from Emporium Plus and Bill Weiland. Bill stands behind his modules and the support he provides is just amazing. His modules are affordably priced and his support is some of the best I have ever seen, if not the best.

[koala]

Re: Order subtotal in new PR8 customer email

Thanks Brandon. I tried your code and it threw a fatal error for me when I tried to test sending out a customer order confirmation email. I did confirm toolkit was selected as an active item for this particular template.

By chance is this something that might only work starting from a certain version of toolkit? Our version is 5.2100

[wcw]

Re: Order subtotal in new PR8 customer email

If your version does not have the function, you simply won't get a value. You should not get an error. You probably have syntax wrong somewhere.

[koala]

Re: Order subtotal in new PR8 customer email

I'll keep playing with it. I had copied and pasted exact from above, but I'll take a closer look again!