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
Hiya... this is just a simple php echo that needs to be added in...
If you want, i could mod it for you...
Good luck...
Jem
If you want, i could mod it for you...
Good luck...
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
Active Member
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.
I'll try have a look tonight for you and see what i come up with... because you will need something in the controller as well
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
Active Member
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...ensemble wrote:That would be great. Thanks!
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
Active Member
Hiya... just before i have a look, what version are you using?
Chears
Jem
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
Active Member
Hiya... i'll have a look once i hear back from you as to the version you are using...
Chears
Jem
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
Active Member
yeah, I have now created a mod for someone else that does this
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
Active Member
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
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
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
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
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
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
just providing my files for reference
Attachments
admin/controller/sale/order.php
catalog/model/checkout/order.php
cataolg/controller/checkout/confirm.php
Who is online
Users browsing this forum: No registered users and 103 guests
