# Productexport mainnumber

**URL:** <https://forum.shopware.com/t/productexport-mainnumber/27189>\
**Category:** Shopware 3.5\
**Tags:** general\
**Created:** [12. Mai 2015 um 22:21 UTC](https://forum.shopware.com/t/productexport-mainnumber/27189 "2015-05-12T22:21:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jumbo](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jumbo](https://forum.shopware.com/u/jumbo)\
**Post date:** [12. Mai 2015 um 22:21 UTC](https://forum.shopware.com/t/productexport-mainnumber/27189/1 "2015-05-12T22:21:42Z")

</div>

is any solution to get Artikel mainnumber via ProductExport? i must create csv file with this varible.

---

<div class="post-metadata">

**Author:** ![shopomania](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@shopomania](https://forum.shopware.com/u/shopomania)\
**Post date:** [12. Mai 2015 um 22:56 UTC](https://forum.shopware.com/t/productexport-mainnumber/27189/2 "2015-05-12T22:56:34Z")

</div>

Probably this is a good entry point (depending on the Shopware version and your goal): [http://en.wiki.shopware.com/\_detail\_1572.html](http://en.wiki.shopware.com/%5C_detail%5C_1572.html)

---

<div class="post-metadata">

**Author:** ![tarkka](https://avatars.discourse-cdn.com/v4/letter/t/ba8739/32.png) [@tarkka](https://forum.shopware.com/u/tarkka)\
**Post date:** [14. Mai 2015 um 08:58 UTC](https://forum.shopware.com/t/productexport-mainnumber/27189/3 "2015-05-14T08:58:26Z")

</div>

Out-of-the-box Shopware has two options to export products to CSV: 1. Backend --\> Content --\> Import / export In “Export items and categories” block select Data:Items, Format:CSV and “Export variants” checked. First two columns in the file will be “ordernumber” and “mainnumber” 2. Backend --\> Marketing --\> Item export Here is no way to get variant number and main product number in the same feed. If “Export variants” option is selected, variable $sArticle.ordernumber will return variant number. If “Export variants” option is disabled, variable $sArticle.ordernumber will return number of main product. If option (1) for some reason is not suitable to you, I would suggest to extend /engine/core/class/sExport.php function sCreateSql.