zinkatres Posted April 27, 2005 Share Posted April 27, 2005 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 More sharing options...
zinkatres Posted April 27, 2005 Author Share Posted April 27, 2005 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 More sharing options...
nixem311 Posted April 28, 2005 Share Posted April 28, 2005 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 Link to comment Share on other sites More sharing options...
zinkatres Posted April 28, 2005 Author Share Posted April 28, 2005 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 :-" Link to comment Share on other sites More sharing options...
nixem311 Posted April 28, 2005 Share Posted April 28, 2005 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.