assign specific phone number in the product description

[mqmq0]

So the thing is, we have two type of products with two group handling it. I want to show on the product page one phone number per product where the client could ask questions, but the phone number of the specific group. I have column called "group" with a value 1 or 2 in my product db.

As I think I need a query what ask the db, what group the specific product is in.

But I don't know how to implement it.

Or there is an easier way somewhere in the admin page?

 

Any suggestion?

[El Patron]

I am pretty sure that the group is passed by controller to product.tpl file.

 

You can dump smarty values by using back office-->advanced parms-->performance (1.5)

http://screencast.com/t/CrsAvcEody7

 

once you know the variable is there you can then use it in your  product.tpl logic...

[mqmq0]

Right now I managed to get it work by this way:

 

{if ($product->id==306 or $product->id==458 or $product->id==503
        or $product->id==399 or $product->id==271 or $product->id==396
        or $product->id==463 or $product->id==466 or $product->id==500
        or $product->id==474 or $product->id==473 or $product->id==472
        or $product->id==502 or $product->id==381 or $product->id==422
        or $product->id==497 or $product->id==424 or $product->id==423

.... and so on for a lot of line

 

So I list the group 1 products this way, and in the else tag handles group 2.

That was good for a while but now we have hundreds of product and changing constantly, its hard to manage.

I need something which does it for me