Post by wakabayashi » Fri Jun 22, 2012 6:33 am

How is it possible to add special prices to the invoice? I wanna see the original price and the special price... In the product.tpl i see for example the two variable $price and $special but how can I get them into order_invoice.tpl? Same question about discounts...

Thanks for your help

New member


Thu Aug 04, 2011 2:55 am

Post by opcrat » Sat Jun 23, 2012 3:34 am

Basically when your customers confirm the order it will stored into database tables, like Product Details stored in order_product table and when your customers or you see its invoice it will display details from database. By default opencart is only storing products final price after discount in database so for special or discount you might need to add two columns into database and need to store special or discounted prices according so that you can display it on invoces.

Most Useful Extensions || Most Selling Extensions
Opencart Development || Opencart Designing || eCommerce Project

✔ Join more than 5000 Happy Opencart Store Owners enjoying the extensions designed and developed by Opcrat, Opencart Partner.

User avatar
Active Member


Wed Dec 21, 2011 6:54 am

Post by straightlight » Sat Jun 23, 2012 3:42 am

The alternative way rather than adding two separate fields in the database amongst the order would be to extend the query where the order products are already queried from the core so to use all possible related product IDs with specials prices in order to show on the invoice. The only disadvantage with this is that specials are of course for limited time period and, later on, when trying to gather the information regarding specials, the order info may see the results as expired dates regarding those specials.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.

Straightlight Administrator / Quality Assurance Analyst / Programmer / Opencart Tester

Legendary Member


Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 16 guests