Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

product description on the invoice?
(1 viewing) (1) Guest
PDF Invoice generator and editor for Joomla and VirtueMart.

If your topic falls within one of the subcategories, then please post it directly there. Post to this parent category only if your question does not match any subcategory topic.
  • Page:
  • 1

TOPIC: product description on the invoice?

product description on the invoice? 13 years, 1 month ago #20192

Hello!

I would like to add the product description on the invoice
Can someone please help me?

SQL Command
 
select product_s_desc
from jos_vm_product, jos_vm_order_item
where product_sku = order_item_sku;
 
The topic has been locked.

Re: product description on the invoice? 13 years, 1 month ago #20213

  • jaku
Hello,

thanks for your post, we wil consider adding this as option to the default version.
To get this in the current version you need join OrderItems table with Product table (in invoicehtml.php, line 675, using the product_id as a key and add the product description in the generated code.
The topic has been locked.

Re: product description on the invoice? 13 years, 1 month ago #20227

Hello and thanks for your answer!
In my shop the Prod. description is very important.
I have it on file (order.order_print.php and etc.) have made

Here the code for order.order_print.php
 
$query = 'select product_desc from jos_vm_product where product_id = '.$dbt->f('product_id');
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo "<span style=\"font-size: smaller;\">" . $row['product_desc']. "</span>";
 


Here the code for order.order_printdetails.php
 
$query = 'select product_desc from jos_vm_product where product_id = '. intval($dbcart->f("product_id"));
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo "<font size=\"-2\">" . $row['product_desc'] . "</font>";
 


I'll be very grateful if you tell me exactly where I paste the code and and..

thanks!
Last Edit: 13 years, 1 month ago by fawad.
The topic has been locked.

Re: product description on the invoice? 13 years, 1 month ago #20561

Can someone please help me, I need the description necessarily
The topic has been locked.

Re: product description on the invoice? 13 years ago #20642

  • jaku
Hello,
sorry, but custom adjustments to the component are a bit out of range of these support forums, we do not have capacity to cover those.

However, you can book this as a custom development service from us at:
www.artio.net/e-shop/support-services/joomla-related-support-1h
The topic has been locked.
  • Page:
  • 1
User Login Empty