Jump to content

Archived

This topic is now archived and is closed to further replies.

tedhorn123

Add product category to invoive

Recommended Posts

I am trying to add the product category to invoice.php

 

I know there is a Manufacturer to Order contrib that is similar, but I'm still having trouble.

 

 

Any ideas?

 

Thanks in advance.

Share this post


Link to post
Share on other sites

The page catalog/checkout_process.php sends the invoices to the customer as well as a copy to store owner.

You will need to insert a database query that compares the products_id to the category_id using the table products to categories.

 

Try it around line 262:

for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {

$email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n";

}

 

Use the class $order in the loop:

for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {

$products_id = tep_get_prid($order->products[$i]['id'])

$query = 'select category_id as id from ' . TABLE_PRODUCTS_TO_CATEGORIES . ' where products_id = ' . (int)$products_id);

$category = tep_db_fetch_array($query);

$email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n";

$email_order .= 'Category ID: ' . $category['id'] . "\n";

}

 

Please be advised that the above was off the top of my head. You may need to modify if errors occur.. But the general idea should work..


Lloyd

Share this post


Link to post
Share on other sites

×