product description on the invoice?

Welcome, Guest

(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, 9 months ago #20192

fawad OFFLINE Posts: 3	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, 9 months 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, 9 months ago #20227

fawad
OFFLINE
Posts: 3

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, 9 months ago by fawad.

The topic has been locked.

Re: product description on the invoice? 13 years, 8 months ago #20561

fawad OFFLINE Posts: 3	Can someone please help me, I need the description necessarily
	The topic has been locked.

Re: product description on the invoice? 13 years, 8 months 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

ARTIO Forums

Support Forums

VM Invoice

Support