Post by ensemble » Thu Oct 27, 2011 11:11 pm

I want to add the product description (the one displayed on product.tpl) to the invoice and email sent to the customer after purchase. Can anyone tell me how to do this?

Thanks

New member

Posts

Joined
Wed Oct 19, 2011 2:20 am

User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)

Post by ensemble » Sun Oct 30, 2011 5:24 am

Hey, that's what I thought. I tried echoing <?php echo $product['description']; ?> and a few other combinations, but they didn't work. I didn't modify the controller or module, so I am guessing I am missing some call for the description. Any help would be great.

New member

Posts

Joined
Wed Oct 19, 2011 2:20 am

User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)

Post by ensemble » Sun Oct 30, 2011 6:07 am

That would be great. Thanks!

New member

Posts

Joined
Wed Oct 19, 2011 2:20 am

Post by Jeremy Fisk » Sun Oct 30, 2011 7:19 am

ensemble wrote:That would be great. Thanks!
Actually, if you want to be real helpful... can you please send me an email to jeremyfisk@clear.net.nz reminding me to do it...

Otherwise I might forget... lol

Chears

Jem

Hand Dryers

Bookstore Mod
QuickShop Module
Restricted Access - Compulsory Login
Template Override - Category Specific (vQmod)
Template Override - Brand Specific (vQmod)
How did you find out about us register question mod
Compulsory Login vQmod
Brands In Top Menu
zoom - Product Image - Auto on hover


User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)

User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)

User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)

Post by ensemble » Sun Oct 30, 2011 6:10 pm

1.5.1.3 ;)

New member

Posts

Joined
Wed Oct 19, 2011 2:20 am

Post by pugguy » Tue Nov 29, 2011 5:43 pm

Did anyone manage to figure this out? Ive tried a few things but cant seem to get the description to display in the email.... Any help would be apreciated! :)

Newbie

Posts

Joined
Wed Oct 26, 2011 9:05 pm

Post by ensemble » Tue Nov 29, 2011 11:03 pm

No solution yet... Has anyone done this?? Please post. :)

New member

Posts

Joined
Wed Oct 19, 2011 2:20 am

User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)

Post by ensemble » Fri Dec 09, 2011 7:41 am

Great! Where can we get it?

New member

Posts

Joined
Wed Oct 19, 2011 2:20 am

Post by pugguy » Tue Dec 20, 2011 6:20 pm

Surly this mod cant be too difficult? Is it not just a case of an echo in the template & some coding in the controller?

Newbie

Posts

Joined
Wed Oct 26, 2011 9:05 pm

Post by daveleggy » Mon Jun 25, 2012 5:18 pm

Has anyone found out how to do this? would really appreciate some help on this

Newbie

Posts

Joined
Thu Mar 29, 2012 7:29 pm

Post by straightlight » Mon Jun 25, 2012 7:20 pm

Edited for OC v1.5.6x releases compatibility.

Attachments

Add Description To Invoice And Email With VAT

Last edited by straightlight on Fri Jun 20, 2014 12:51 am, edited 3 times in total.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by daveleggy » Tue Jun 26, 2012 11:38 pm

sorry to trouble you - i have changed all the files as suggested but i get an error json: parse error which looking in the debug window is not getting anything from description field
Notice: Undefined index: description in C:\xampp\htdocs\catalog\controller\checkout\confirm.php on line 222Notice: Undefined index: description in C:\xampp\htdocs\catalog\model\checkout\order.php on line 9Notice: Error: Unknown column 'description' in 'field list'
Error No: 1054
INSERT INTO order_product SET order_id = '13', product_id = '29', name = 'Palm Treo Pro', `description` = '', model = 'Product 2', quantity = '1', price = '279.99', total = '279.99', tax = '50.99825' in C:\xampp\htdocs\system\database\mysql.php on line 49
any idea what i am doing wrong?
regards
Dave

Newbie

Posts

Joined
Thu Mar 29, 2012 7:29 pm

Post by straightlight » Wed Jun 27, 2012 3:50 am

Thanks. I targeted the wrong SQL table name on my instruction above. Last step edited.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by daveleggy » Wed Jun 27, 2012 5:05 pm

Hi Sorry to trouble you again
If i manually enter a description for an ordered product the invoice shows the description ok, but if i don't i get an error at checkout
<b>Notice</b>: Undefined index: description in <b>C:\xampp\htdocs\catalog\controller\checkout\confirm.php</b> on line <b>222</b><b>Notice</b>: Undefined index: description in <b>C:\xampp\htdocs\catalog\controller\checkout\confirm.php</b> on line <b>222</b><b>Notice</b>: Error: Column 'description' specified twice<br />Error No: 1110<br />INSERT INTO order_product SET order_id = '6', product_id = '29', name = 'Palm Treo Pro', `description` = '', `description` = '', `description` = '', model = 'Product 2', quantity = '2', price = '279.99', total = '559.98', tax = '99.9965' in <b>C:\xampp\htdocs\system\database\mysql.php</b> on line <b>49</b>

many thanks in advance
David

Newbie

Posts

Joined
Thu Mar 29, 2012 7:29 pm

Post by daveleggy » Wed Jun 27, 2012 5:22 pm

just providing my files for reference

Attachments

admin/controller/sale/order.php

catalog/model/checkout/order.php

cataolg/controller/checkout/confirm.php


Newbie

Posts

Joined
Thu Mar 29, 2012 7:29 pm
Who is online

Users browsing this forum: No registered users and 18 guests