Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Display Products on orders,invoice & pk slip


zinkatres

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

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

 

 

 

PAUL

Link to comment
Share on other sites

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 :-"

 

 

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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...