Display Products on orders,invoice & pk slip

[zinkatres]

Can some one please tell me how to display products that have been bought on the orders screen. I have installed the PayPal IPN and now the list of items bought will not show up on the orders screen, the invoices, or the packing slip. I have looked and looked thru out the code but cannot come up with a solution. Please help me

 

-bil

[zinkatres]

Thanks anyway but after 5 hours of probing I have seemed to fix the problem.

 

For anyone's future reference the database call for product listing is in admin/includes/classes/order.php

 

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price, products_id from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

 

it was around line 109 in my edited file

 

thanks

[nixem311]

Thanks anyway but after 5 hours of probing I have seemed to fix the problem.

 

For anyone's future reference the database call for product listing is in admin/includes/classes/order.php

 

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price, products_id from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

 

it was around line 109 in my edited file

 

thanks

<{POST_SNAPBACK}>

 

will this show orders that were proccessed in the past .. or only future orders..

 

 

 

PAUL

[zinkatres]

Paul,

 

As far as I know this line will pull and display any products that exist in the database

but then again im not an expert :-"

[nixem311]

Paul,

 

As far as I know this line will pull and display any products that exist in the database

but then again im not an expert :-"

<{POST_SNAPBACK}>

 

 

in my admin/includes/classes/order.php file.. i only have 106 pages.. the last 6 being basially nothingness...

 

where exactly do place this code .. do i replace old cose with this code.. or insert it into the page ....

 

 

Thanks again.. PAUL