Add Custom variable to receipt email

[graphicz]

Client's Pick and Pack want a SKU code for each product.
I have created the variable for this at product level.
I need to add it to the receipt email as a copy of this goes to Pick and Pack.
Page 131 of the AUG speaks of adding order related content rather than product related.

Can this variable be added to the receipt (Buyer) email?

Does the variable need to be added to the Cart somehow, and if it is will it then appear on the Buyer Email.

Support suggested adding the variable to the Buyer Email but this didn't work.

I would be very grateful for help configuring this.

Thank you

[NormanRouxel]

See http://community.actinic.com/showthread.php?t=28914 for a discussion on how to display user Variables in the Cart. Make sure you follow post #2's, requirement for the "Upload" setting to be ticked in the Variables definition.

You'll need to patch OrderScript.pl to include the user variable in the customer email.

Here's the block of code that emails the Other_Info prompt.

		#
		# Add other and date info prompts if defined
		#
		if (length $$pProduct{'OTHER_INFO_PROMPT'} > 0)
			{
			MailOrderLine( "",
								$$pProduct{'OTHER_INFO_PROMPT'} . "\r\n  " . $CurrentItem{'INFO'},
								"",
								"",
								"",
								$nDescriptionColumnWidth,
								@TableFormat
								);
			}

Immediately above that put the same code tweaked to display your SKU variable (assuming it's called that). N.B. Untested.

		#
		# Add SKU prompt if defined
		#
		if (length $$pProduct{'CUSTOMVARS'}{'SKU'} > 0)
			{
			MailOrderLine( "",
								'SKU: ' . $$pProduct{'CUSTOMVARS'}{'SKU'},
								"",
								"",
								"",
								$nDescriptionColumnWidth,
								@TableFormat
								);
			}

[graphicz]

FanDabiDozey

Perfection in every post Norman - Thank you.

Here is the receipt (Buyers) email showig the SKU added following changing OrderScript.pl as per your suggestion:

Dear j c,

Thank you for shopping at My Company.
We have received and are processing the following order:

******************************************************
Order Number: JC12CD10000005
Order Date: 28 March 2012 14:08 GMT

Ship To:
j c
gg
s
bn12cd
United Kingdom
98
info@graphicz.co.uk



Shopping Cart (Prices in British Pounds)
DESCRIPTION QUANTITY PRICE COST
----------------------------------------------------------------------
Magnum Opus™ 1 £195.00 £195.00
SKU: moskutry

Microfiber Pad 1
SKU: TryMySKUc0de
======================================================================
Subtotal: £195.00
Shipping (Standard Charge): £11.75
Total: £206.75
Including VAT: £30.79

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


Sincerely,
My Company

My Street
My Town
United Kingdom
My Phone Number
info@graphicz.co.uk

[NormanRouxel]

Don't forget that you'll have to re-apply this tweak after you upgrade to 11.0.2, 3, etc.