Retail AND wholesale display on the product listing page

[Mythos]

Hello,

I'm trying to accomplish the result I'm attaching as an image. I already managed to add this in my product info page with this code and then adding it to the template (on the same product info page):

$product_wholesale_query = tep_db_query("select customers_group_price from products_groups where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = 2");

I just simply can't find where to do this kind of thing in the product_listing.php file.






Thank you,
Shutiri

[pgmarshall]

The queries that build the pages above product_info are all in catalog/index.php but be warned that this will affect quite a lot of the functionality (but then again this is what I expect you want to do)

Regards,

[Mythos]

Hello pgmarshall,

Thank you. Yes, I can see the queries; but where is the html part of the product listing ? where's the table for that page (content) ?

index.php calls CONTENT_INDEX_PRODUCTS and that one calls FILENAME_PRODUCT_LISTING (in my case, I'm not using the _COL version).

I can't find the html table for the content of that page, the manufacturer, image, price and buy button. Where is it ?

Thank you again,
Mythos

[Mythos]

Ok, I found it, in product_listing.php, quite obvious.

I'll try to manage the query to call the wholesale price; any tip will (or code ), will be highly appreciated !

Cheers,
Mytho

[Mythos]

Hello again,

I've been trying all day to get the same result I managed for the product_info.tpl.php, with the code I mentioned earlier.

What I know (presume) so far, is that I need to get the different prices (retail and wholesale) into the $listing array, in product_listing.php. There's actually a commented print_r in the file, to see the content of $listing, very useful...

To get those prices into $listing, I have to modify the query $listing_sql in index.php, but I unfortunately can't do that; my php/mysql knowledge won't go that far.

Can you please tell me how to make the display on my image happen ?

Thank you,
Mythos