Need to send product specific detail in confirmation email

Hi all

I have 6 secured PDF's for download, each 1 requiring it's own password/user ID to a access.

What I would like to do is send the correct password/user ID in the confirmation email. Can anyone tell me how I could do this and where I would store the relevent details to be retrieved by the email?

wish i could help keith,
I have the same dilemma
just want an email sent to the customer, with a link for the download.
seems simple, but like you, i cant find the answers.
if i do , ill let you know.
hope you will do the same.

Hi raymondg

Thanks, I do have an idea, just trying to figure out how to implement it. Will post it here if I succeed.

How is your download setup, is it in a separate location to your zen cart ? If not, ZC should provide a download link automatically if it has been setup correctly.

raymondg:

wish i could help keith,
I have the same dilemma
just want an email sent to the customer, with a link for the download.
If they are purchasing a downloadable product, then the links are provided on the checkout-success page as well as in the My Account area.

If you are wanting to send a link separately after-the-fact, you can do it manually by adding details in the Order Comments and clicking Update under Admin->Orders

OK in reference to the first post in this thread, I have got the downloads set up, tested and working.

The confirmation email currently being sent out displays:

Order Confirmation Company Name

Customer Name,
Thanks for shopping with us today!
The following are the details of your order.

Order Number: 3
Date Ordered: Friday 28 July, 2006
Click here for a Detailed Invoice

Products Info & Billing Address

The Email I would like to send looks like this:

Order Confirmation Company Name

Customer Name,
Thanks for shopping with us today!
The following are the details of your order.

Your Keycode
The Code to access the Product you have downloaded is:

  [***Product_Keycode  field data***]

Order Number: 3
Date Ordered: Friday 28 July, 2006
Click here for a Detailed Invoice

Products Info & Billing Address

would this work, and if there is anything missing can anyone tell me what else needs to be completed and how.

1. Create a new field titled Product_Keycode in the Products_Details Table.
2. Add keycode data into new field.
3. Create Email Text Title defines in checkout_process.php.
4. Create Email Text Content defines in checkout_process.php.
5. Add defines to checkout email template.

Any help or advice greatly appreciated TIA

where will you get the keycode from? Is it unique that customer? or is it a generic password?

It is a Generic password that is set to to the Product.

BTW my previous post should read Product_Description table and not Product_Details table.

includes/classes/order.php
around line 816 you have:```php
// include onetime charges

Right above that, add:```php
$this->products_ordered_attributes .= "\n" . 'The password to unlock these files is: t28s8vsv3a';

and put your password in where appropriate.

Is this code insert, instead of or in addition to the steps I mentioned earlier ? and do I need to put all these changes in My Template directory ?

You could almost do it "instead of" what you suggested earlier.

The file I indicated doesn't have any overrides, so can't override it. Just edit and replace the existing file. (make notes so you can re-do it when upgrading).

Big Thanks Dr B :thumbsup:

I am currently trying to replace the demo setup with an exact mirror of the current cart and database setup. Have copied the cart files, just having palptations trying to figure out the database/phpmyadmin side of things (watch out wiki here I come AGAIN) :lol:

As soon as that is completed I will try everything out on the test site and either post any further queries here or report if a successful result achieved.