Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Display Products on orders,invoice & pk slip


zinkatres

Recommended Posts

Posted

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

Posted

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

Posted
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

Posted

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

Posted
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

Archived

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

×
×
  • Create New...