Using ProductCart - Quantity discount in order confirmation email

Quantity discount in order confirmation email

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4847
Printed Date: 06-March-2025 at 3:32pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Quantity discount in order confirmation email

Posted By: kcramer
Subject: Quantity discount in order confirmation email
Date Posted: 09-November-2011 at 12:12pm

How can we make the quantity discount amount appear as a line-item along with the subtotal, taxes, shipping, coupon code, and total amounts that are displayed in the Order Confirmation message sent to the customers?

The reason I ask is because without that discount, the totals at the bottom of the receipt look confusing. For example, most of our customers end up getting emails that look like this:

Subtotal: $54.90

Shipping charges: $ 8.95

====================

Total: $56.85

As you can see in the example above, those three amounts do not appear to add up. This is because a $7.00 quantity discount is factored into the final total but the line that should say "Quantity discount: ($7.00)" is not displayed in the email.

The discount is displayed in the email whenever a customer uses a coupon code, but NOT when a quantity discount is in effect. How do we get it to display this information in the emails?

Thanks in advance for your help.

~ Kristen

Replies:

Posted By: kcramer
Date Posted: 14-November-2011 at 1:31pm

In trying to find a solution to this problem, I came across this code in the file named sendmailCustomerProcessed.asp, and it seems like it relates to the display of Category Discounts (which is what our quantity discounts are), yet that discount is NOT being displayed in the Order Confirmation emails.

Does anyone know why this isn't working? (This isn't code we added or modified. It's the original code that came with the cart.)

************************************************************

'DiscountCode, when applicable...Category Discounts
ptotalDiscounts=pTotalDiscountAmount+piRewardValue+pcOrd_CatDiscounts
if ptotalDiscounts>0 then
if piRewardValue>0 then
customerEmail=customerEmail & FixedField(60, "R", dictLanguage.Item(Session("language")&"_sendMail_21") &RewardsLabel&dictLanguage.Item(Session("language")&"_sendMail_22"))
else
customerEmail=customerEmail & FixedField(60, "R", dictLanguage.Item(Session("language")&"_sendMail_23"))
end if
customerEmail=customerEmail & FixedField(11, "R", "(-"&scCurSign & money(ptotalDiscounts)&")")
customerEmail=customerEmail & vbCrLf
End If

************************************************************

Is there something we can add to this code to make the category discount amount appear in the same place where the subtotal, sales tax, shipping, and discount coupon amounts all appear at the bottom of the order details in the email? (Or am I just looking at the wrong code entirely and this excerpt of code isn't what should cause the category discount amount to appear in the email?)

Any help would be greatly appreciated.

~ Kristen