How to access product_attribute reference in invoice.tpl

[presta911]

I want to add the product_attribute reference name (not just the product.reference) to the invoice, any help in how to get that value would be appreciated!

 

edit: actually in the invoice-b2b.tpl (don't know if that makes a difference)

Thx!

Edited April 1, 2016 by presta911 (see edit history)

[tuk66]

{$order_detail.product_reference} is already filled in by the combination reference.

[presta911]

Hi Tuk,

 

Thanks for the response.

 

Yes, I know $order_detail.product_reference is available, I was looking to get the attribute reference.

 

Now the $order_detail.attribute_reference_id is available, I was looking for how to use the id to get the attribute_reference, which is not available from the order_details table.

 

Is there some function that I could likely call that will take the attribute_id and return the attribute reference?

 

Thanks again to for any suggestions!

[tuk66]

The combination reference (atrribute_reference) is always available in the ps_order_detail table. This field is filled in with the right reference.

[presta911]

Thank you very much Tuk, you are absolutely correct.

 

What happened was I created an order BEFORE creating the combination attribute reference, so when I was looking at the invoice, only the product reference was being used.

 

But after you said the attribute reference is in the ps_order_detail table, I placed a new order and the attribute reference was now used instead of the product reference.

 

Thanks again for your assistance!