# How to show manufacturer / hersteller in the order confirmation email?

**URL:** <https://forum.shopware.com/t/how-to-show-manufacturer-hersteller-in-the-order-confirmation-email/71472>\
**Category:** Programming (EN)\
**Created:** [9. Dezember 2020 um 20:17 UTC](https://forum.shopware.com/t/how-to-show-manufacturer-hersteller-in-the-order-confirmation-email/71472 "2020-12-09T20:17:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Duff](https://avatars.discourse-cdn.com/v4/letter/d/958977/32.png) [@Duff](https://forum.shopware.com/u/Duff)\
**Post date:** [9. Dezember 2020 um 20:17 UTC](https://forum.shopware.com/t/how-to-show-manufacturer-hersteller-in-the-order-confirmation-email/71472/1 "2020-12-09T20:17:53Z")

</div>

Hi,

I used to have a workaround to show the manufacturer in the order confirmation email template by using this piece of code:

```
	{{ dbquery('name', 'product_manufacturer_translation', {'product_manufacturer_id =': dbquery('product_manufacturer_id', 'product', {'id =': dbquery('IF(parent_id IS NULL, id, parent_id)', 'product', {'id =': lineItem.identifier|uuid2bytes})})}, {('IF(language_id = "%s", 1, 0)'|format(languageid())): 'DESC'}) }}{% endif %}

```

However, since 6.3.3, this code is not working anymore. Who can help me find the right way to fetch and display the manufacturer (or hersteller) name for each line item?&nbsp;

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Duff](https://avatars.discourse-cdn.com/v4/letter/d/958977/32.png) [@Duff](https://forum.shopware.com/u/Duff)\
**Post date:** [12. Dezember 2020 um 14:35 UTC](https://forum.shopware.com/t/how-to-show-manufacturer-hersteller-in-the-order-confirmation-email/71472/2 "2020-12-12T14:35:53Z")

</div>

Somehow, the code now works - I must have made a typo in the template somewhere. That is something that would be very welcome by the way; some way of error reporting on e-mailtemplates.&nbsp;

Keep up the good work!

---

<div class="post-metadata">

**Author:** ![viniciov](https://avatars.discourse-cdn.com/v4/letter/v/eb8c5e/32.png) [@viniciov](https://forum.shopware.com/u/viniciov)\
**Post date:** [31. Oktober 2023 um 05:52 UTC](https://forum.shopware.com/t/how-to-show-manufacturer-hersteller-in-the-order-confirmation-email/71472/3 "2023-10-31T05:52:43Z")

</div>

Hello. Could you please share your solution? I’m breaking my neck trying to show the manufacturer name for each line of the product confirmation email.

Here’s what I have done so far but it returns nothing, which means there is an error in my code.

```auto
                <div{% if nestingLevel > 0 %} style="padding-left: {{ (nestingLevel + 1) * 10 }}px"{% endif %}>
                    {{ nestedItem.label|u.wordwrap(80) }} <br>
                    <p>Manufactured by:         
                    {{ dbquery('name', 'product_manufacturer_translation', 'product_manufacturer_id =' | nestedItem.payload.manufacturerId) }}
                    </p>
                </div>

```

Any help is of great value. Thanks

---

<div class="post-metadata">

**Author:** ![viniciov](https://avatars.discourse-cdn.com/v4/letter/v/eb8c5e/32.png) [@viniciov](https://forum.shopware.com/u/viniciov)\
**Post date:** [2. November 2023 um 05:45 UTC](https://forum.shopware.com/t/how-to-show-manufacturer-hersteller-in-the-order-confirmation-email/71472/4 "2023-11-02T05:45:26Z")

</div>

I will put the Manufacturer name within the product name. Not a very elegant solution but it’s a workaround.