Cut product_name attributes into separate lines

[Holohugo]

Hello

product_name is carring attributes group and attribute value whenever is displayed. I need to strip it into lines like:

NAME </ br>

Attr. group1 and Value </ br>

Attr. group2 and Value </ br>

I need this for my PDF invoices, where everything is in one line, creating a mess. A dont need it enywhere else, only on invoice.

 

In invoice.product-tab.tpl file, there is:

<span style="font-size:10pt;">{$order_detail.product_name}</span><br/>
<span style="font-size:8pt;">{$order_detail.product_reference}</span>

 

I tried to find whatever product_name variable within the site files, but i could not find the one that is covering the format, or that would allow me to break line between actual name, and and attributes group.

Can someone please point me to the right direction? I would accept even anY other solution to this

 

Thank you

[Jagotic]

Data you're looking for stored in Database.

Find table order_detail  & see column product_name

[Holohugo]

On 9/24/2019 at 4:59 AM, Jagotic said:

Data you're looking for stored in Database.

Find table order_detail  & see column product_name

Thank You! But can i format data in database or the output? If its tored in one table, i cant formate it, right?