All Order Notification Emails Blank after 4.52 Upgrade

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Item

Qty

Total

{{cartItem.ProductName}}
SKU: {{cartItem.ProductSku}}

{{cartItem.Quantity | number : 2}} x {{cartItem.UnitCost | currency : '$' : 2}}

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your shopping cart.

Subtotal

{{minicart.cartTotals.SubTotal | currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Image

Item

Qty

Total

{{cartItem.ProductName}}
SKU: {{cartItem.ProductSku}}

{{cartItem.Quantity | number : 2}} x {{cartItem.UnitCost | currency : '$' : 2}}

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your shopping cart.

SKU

Product Name

Unit Cost

Qty

Line Total

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your saved shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

Status

Order No.

Order Date

Ship To

Order Total

Pay Total

Balance

Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}

{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}

Home

Product Discus...

SmithCart

All Order Notification Emails Blank after 4.52 Upgrade

8/26/2011 10:58 AM

Brian Buell

Joined: 5/13/2010

Posts: 31

All Order Notification Emails Blank after 4.52 Upgrade

Upgraded to 4.52 and all my order notification emails are blank. The invoice emails sent to the customer are fine.

8/26/2011 1:37 PM

Joined: 1/1/0001

Posts: 0

Re: All Order Notification Emails Blank after 4.52 Upgrade

Hi Brian,

Which version of the Cart did you upgrade from? In Cart v.4.36 we added "Email Template Management" in the Admin Menu to customize the look of your store's emails. Have you set up or enabled the email templates?

Thanks,

8/26/2011 2:32 PM

Brian Buell

Joined: 5/13/2010

Posts: 31

Re: All Order Notification Emails Blank after 4.52 Upgrade

I don't know what version we were on however, I HAVE NOT setup any email templates. However, the default templates were fine and now I have nothing. I wouldn't even know where to start. Are there no default email templates? I don't need fancy email reports but I do need to know what ny customers purchased so we can fulfill their orders. What can you tell me?

8/26/2011 2:35 PM

Brian Buell

Joined: 5/13/2010

Posts: 31

Re: All Order Notification Emails Blank after 4.52 Upgrade

I tried to create an email template and got this error.

The stored procedure 'dbo.TLOL_Smith_AddEmailTemplateSC' doesn't exist.

8/26/2011 3:10 PM

Joined: 1/1/0001

Posts: 0

Re: All Order Notification Emails Blank after 4.52 Upgrade Modified By on 8/26/2011 3:10:14 PM

Hi Brian,

Here is a link to a forum post with the missing stored proc you need:
http://www.smith-consulting.com/Forum...

Thanks,

8/26/2011 4:03 PM

Brian Buell

Joined: 5/13/2010

Posts: 31

Re: All Order Notification Emails Blank after 4.52 Upgrade Modified By Scott Kelly on 8/26/2011 4:34:58 PM

I can't find these procedures anywhere.

There are 3 showup in the dropdown box to select from but I can't find them.

Another Question, if they show up in the drop down box than why are they missing.

Another Question, why does your production release of the live software have missing stored procedures?

Please help as I am having to manualy go in and print out our orders and fax them to our fulfullment house.

8/26/2011 4:24 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: All Order Notification Emails Blank after 4.52 Upgrade Modified By Scott Kelly on 8/26/2011 5:23:38 PM

Hi Brian,

The stored proc for the email template is included in the cart install package if extract the zip and do a search in files for the stored proc name you will see it there. Here is a forum post where you can get the stored proc:

http://www.smith-consulting.com/Forums/forumid/1/threadid/7981/scope/posts.aspx

Also, I recommend installing/upgrading on your test site first before installing on your live site to avoid any production issues.

Thanks,

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce