# How to export orders with a promotion code?

**URL:** <https://forum.shopware.com/t/how-to-export-orders-with-a-promotion-code/106302>\
**Category:** Other Questions (EN)\
**Created:** [20. Januar 2025 um 08:08 UTC](https://forum.shopware.com/t/how-to-export-orders-with-a-promotion-code/106302 "2025-01-20T08:08:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zinkbakken](https://avatars.discourse-cdn.com/v4/letter/z/ba9def/32.png) [@zinkbakken](https://forum.shopware.com/u/zinkbakken)\
**Post date:** [20. Januar 2025 um 08:08 UTC](https://forum.shopware.com/t/how-to-export-orders-with-a-promotion-code/106302/1 "2025-01-20T08:08:46Z")

</div>

Settings → Import/export  
I want to export orders that are using a promotion code, but I can’t find a database entry for the promotion codes?

---

<div class="post-metadata">

**Author:** ![Kavkus](https://avatars.discourse-cdn.com/v4/letter/k/e19b73/32.png) [@Kavkus](https://forum.shopware.com/u/Kavkus)\
**Post date:** [20. Januar 2025 um 09:14 UTC](https://forum.shopware.com/t/how-to-export-orders-with-a-promotion-code/106302/2 "2025-01-20T09:14:11Z")

</div>

There’s no such function. You need an SQL query that joins the line items and specifically looks for the promotion types