# Feed Export Problem

**URL:** <https://forum.shopware.com/t/feed-export-problem/88827>\
**Category:** Shopware 5\
**Created:** [5. Juli 2021 um 12:14 UTC](https://forum.shopware.com/t/feed-export-problem/88827 "2021-07-05T12:14:22Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![DeanandDavidSuperF](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/deananddavidsuperf/32/14043_2.png) [@DeanandDavidSuperF](https://forum.shopware.com/u/DeanandDavidSuperF)\
**Post date:** [5. Juli 2021 um 12:14 UTC](https://forum.shopware.com/t/feed-export-problem/88827/1 "2021-07-05T12:14:22Z")

</div>

Hallo Leute,

When trying to export the feeds for google merchant, we got always same error expcetion:

## Ups! Ein Fehler ist aufgetreten!

```
<p>
    <span class="frontend_error_exception">Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.</span>
</p>

<h3> in engine/Library/Smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 657</h3>

<h3>Stack trace:</h3>
<div style="overflow:auto;">
    <pre>#0 engine/Library/Smarty/sysplugins/smarty_internal_templateparser.php(3144): Smarty_Internal_TemplateCompilerBase->trigger_template_error() #1 engine/Library/Smarty/sysplugins/smarty_internal_templateparser.php(3209): Smarty_Internal_Templateparser->yy_syntax_error(10, '\xE2') #2 engine/Library/Smarty/sysplugins/smarty_internal_smartytemplatecompiler.php(105): Smarty_Internal_Templateparser->doParse(10, '\xE2') #3 engine/Library/Smarty/sysplugins/smarty_internal_templatecompilerbase.php(192): Smarty_Internal_SmartyTemplateCompiler->doCompile('{foreach $sArti...') #4 engine/Library/Smarty/sysplugins/smarty_internal_template.php(187): Smarty_Internal_TemplateCompilerBase->compileTemplate(Object(Enlight_Template_Default)) #5 engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(155): Smarty_Internal_Template->compileTemplateSource() #6 engine/Shopware/Core/sExport.php(1150): Smarty_Internal_TemplateBase->fetch('string:{foreach...', 1) #7 engine/Shopware/Controllers/Backend/Export.php(133): sExport->executeExport(Resource id #933) #8 engine/Shopware/Controllers/Backend/Export.php(69): Shopware_Controllers_Backend_Export->generateExport('php://output') #9 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Export->indexAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch('indexAction') #11 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #13 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main}</pre>
</div>

```

&nbsp;

Does someone has an Idea what is wrong here?

Thanks

---

<div class="post-metadata">

**Author:** ![TobiasKassner](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/tobiaskassner/32/21642_2.png) [@TobiasKassner](https://forum.shopware.com/u/TobiasKassner)\
**Post date:** [7. Juli 2021 um 06:14 UTC](https://forum.shopware.com/t/feed-export-problem/88827/2 "2021-07-07T06:14:55Z")

</div>

Hey [DeanandDavidSuperF](https://forum.shopware.com/u/DeanandDavidSuperF),

can you share your template with us? There seems to be an error in one line.

Best regards  
Tobi

---

<div class="post-metadata">

**Author:** ![DeanandDavidSuperF](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/deananddavidsuperf/32/14043_2.png) [@DeanandDavidSuperF](https://forum.shopware.com/u/DeanandDavidSuperF)\
**Post date:** [7. Juli 2021 um 12:32 UTC](https://forum.shopware.com/t/feed-export-problem/88827/3 "2021-07-07T12:32:18Z")

</div>

Hallo Tobi,

Thanks for your reply.

here is our template:

{strip}  
unisex {#S#}  
adult {#S#}  
{$sArticle.attr7|escape}{#S#}  
schwarz {#S#}  
{$sArticle.attr4|escape}{#S#}  
{$sArticle.attr5|escape}{#S#}  
{$sArticle.ordernumber|escape}{#S#}  
{$sArticle.name|strip\_tags|strip|trim|truncate:60:"…":true|escape} {$sArticle.additionaltext|escape} {if $sArticle.referenceunit && $sArticle.purchaseunit}{assign var=“sArticleReferenceprice” value=$sArticle.price/$sArticle.purchaseunit\*$sArticle.referenceunit}({$sArticleReferenceprice|escape:“number”}/{$sArticle.referenceunit}{$sArticle.unit}€){/if}{#S#}  
{$sArticle.description\_long|strip\_tags|strip|trim|truncate:500:"…":true|escape}{#S#}  
{$sArticle.articleID|link:$sArticle.name|escape}{#S#}  
{$sArticle.image|image:4}{#S#}  
{$sArticle.ean|escape}{#S#}  
{$sArticle.supplier|escape}{#S#}  
{$sArticle.suppliernumber|escape}{#S#}  
Neu {#S#}  
{$sArticle.articleID|category:" \> "|escape}{#S#}  
{$sArticle.price|escape:“number”}{#S#}  
{if $sArticle.referenceunit && $sArticle.purchaseunit}  
{assign var=“sArticleReferenceprice” value=$sArticle.price/$sArticle.purchaseunit\*$sArticle.referenceunit}  
{$sArticle.referenceunit} {$sArticle.unit}{#S#}  
{$sArticle.purchaseunit} {$sArticle.unit}{#S#}  
{else}  
{#S#}{#S#}  
{/if}  
DE::DPD:{$sArticle|@shippingcost:“prepayment”:“de”}{#S#}  
EUR {#S#}  
{$sArticle.additionaltext|escape}{#S#}  
{if $sArticle.esd}Auf Lager  
{elseif $sArticle.instock\>0}Auf Lager  
{elseif $sArticle.releasedate && $sArticle.releasedate|strtotime \> $smarty.now}Vorbestellt  
{elseif $sArticle.shippingtime}Auf Lager  
{else}Nicht auf Lager{/if}  
{/strip}{#L#}

Thanks a lot for your support.

---

<div class="post-metadata">

**Author:** ![TobiasKassner](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/tobiaskassner/32/21642_2.png) [@TobiasKassner](https://forum.shopware.com/u/TobiasKassner)\
**Post date:** [8. Juli 2021 um 17:55 UTC](https://forum.shopware.com/t/feed-export-problem/88827/4 "2021-07-08T17:55:36Z")

</div>

@DeanandDavidSuperF

You used “ and ” instead of " in your Template !!

Corrected it works:

```auto
{strip}
unisex {#S#}
adult {#S#}
{$sArticle.attr7|escape}{#S#}
schwarz {#S#}
{$sArticle.attr4|escape}{#S#}
{$sArticle.attr5|escape}{#S#}
{$sArticle.ordernumber|escape}{#S#}
{$sArticle.name|strip_tags|strip|trim|truncate:60:"…":true|escape} {$sArticle.additionaltext|escape} {if $sArticle.referenceunit && $sArticle.purchaseunit}{assign var="sArticleReferenceprice" value=$sArticle.price/$sArticle.purchaseunit*$sArticle.referenceunit}({$sArticleReferenceprice|escape:"number"}/{$sArticle.referenceunit}{$sArticle.unit}€){/if}{#S#}
{$sArticle.description_long|strip_tags|strip|trim|truncate:500:"…":true|escape}{#S#}
{$sArticle.articleID|link:$sArticle.name|escape}{#S#}
{$sArticle.image|image:4}{#S#}
{$sArticle.ean|escape}{#S#}
{$sArticle.supplier|escape}{#S#}
{$sArticle.suppliernumber|escape}{#S#}
Neu {#S#}
{$sArticle.articleID|category:" > "|escape}{#S#}
{$sArticle.price|escape:"number"}{#S#}
{if $sArticle.referenceunit && $sArticle.purchaseunit}
{assign var="sArticleReferenceprice" value=$sArticle.price/$sArticle.purchaseunit*$sArticle.referenceunit}
{$sArticle.referenceunit} {$sArticle.unit}{#S#}
{$sArticle.purchaseunit} {$sArticle.unit}{#S#}
{else}
{#S#}{#S#}
{/if}
DE::DPD:{$sArticle|@shippingcost:"prepayment":"de"}{#S#}
EUR {#S#}
{$sArticle.additionaltext|escape}{#S#}
{if $sArticle.esd}Auf Lager
{elseif $sArticle.instock>0}Auf Lager
{elseif $sArticle.releasedate && $sArticle.releasedate|strtotime > $smarty.now}Vorbestellt
{elseif $sArticle.shippingtime}Auf Lager
{else}Nicht auf Lager{/if}
{/strip}{#L#}

```

I hope I could help you!

Kind regards  
Tobi

---

<div class="post-metadata">

**Author:** ![DeanandDavidSuperF](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/deananddavidsuperf/32/14043_2.png) [@DeanandDavidSuperF](https://forum.shopware.com/u/DeanandDavidSuperF)\
**Post date:** [8. Juli 2021 um 22:07 UTC](https://forum.shopware.com/t/feed-export-problem/88827/5 "2021-07-08T22:07:38Z")

</div>

thanks a lot Tobi for your help.

I used the updated template and I got now a different error:

gender age\_group größe farbe google\_produktkategorie promotion\_id id titel beschreibung link bild\_url ean marke mpn zustand produktart preis unit\_pricing\_base\_measure unit\_pricing\_measure versand währung item\_group\_id verfügbarkeit

## Ups! Ein Fehler ist aufgetreten!

```
<p>
    <span class="frontend_error_exception">Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.</span>
</p>

<h3>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute' in 'where clause' in engine/Library/Zend/Db/Statement/Pdo.php on line 224</h3>

<h3>Stack trace:</h3>
<div style="overflow:auto;">
    <pre>#0 engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('\n SE...', Array) #3 engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(85): Zend_Db_Adapter_Pdo_Abstract->query('\n SE...', Array) #4 engine/Library/Zend/Db/Adapter/Abstract.php(747): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n SE...', Array) #5 engine/Shopware/Core/sExport.php(1549): Zend_Db_Adapter_Abstract->fetchRow('\n SE...') #6 engine/Shopware/Core/sExport.php(1716): sExport->sGetPremiumDispatch(Array, NULL) #7 engine/Shopware/Core/sExport.php(1446): sExport->sGetArticlePremiumShippingcosts(Array, Array, Array, NULL) #8 var/cache/production_201904021344/templates/export_1/5b/aa/61/5baa616f8106cc4bfba05bc9904d53587eb55a27.string.php(75): sExport->sGetArticleShippingcost(Array, Array, Array) #9 engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_60e77652cf1c39_97086630(Object(Enlight_Template_Default)) #10 engine/Shopware/Core/sExport.php(1150): Smarty_Internal_TemplateBase->fetch('string:{foreach...', 1) #11 engine/Shopware/Controllers/Backend/Export.php(133): sExport->executeExport(Resource id #907) #12 engine/Shopware/Controllers/Backend/Export.php(69): Shopware_Controllers_Backend_Export->generateExport('php://output') #13 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Export->indexAction() #14 engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch('indexAction') #15 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #16 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #17 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #21 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #22 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main}</pre>
</div>

```

&nbsp;

I hope you have an idea where the problem is.

thanks again for your help.

---

<div class="post-metadata">

**Author:** ![TobiasKassner](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/tobiaskassner/32/21642_2.png) [@TobiasKassner](https://forum.shopware.com/u/TobiasKassner)\
**Post date:** [9. Juli 2021 um 05:51 UTC](https://forum.shopware.com/t/feed-export-problem/88827/6 "2021-07-09T05:51:55Z")

</div>

@DeanandDavidSuperF

It seems that you have an incorrect SQL statement in the „additional filters“ tab of the feed.

It could also be the shipping costs. The dynamic calculation of shipping costs can not be used in all cases in the export feed.

Check these settings!

Kind regards  
Tobi

---

<div class="post-metadata">

**Author:** ![DeanandDavidSuperF](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/deananddavidsuperf/32/14043_2.png) [@DeanandDavidSuperF](https://forum.shopware.com/u/DeanandDavidSuperF)\
**Post date:** [9. Juli 2021 um 11:11 UTC](https://forum.shopware.com/t/feed-export-problem/88827/7 "2021-07-09T11:11:11Z")

</div>

Thanks a lot Tobi for your continuous support.

I checked and we do not have any filter in the additional filters in the feed:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/b/bbcd6c9b69c9afd2e8249a38078cbc1e986b2bb4.png)

What do you mean by Dynamic calculation for shipping cost? which parameter ?

Thanks and have a nice day

---

<div class="post-metadata">

**Author:** ![TobiasKassner](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/tobiaskassner/32/21642_2.png) [@TobiasKassner](https://forum.shopware.com/u/TobiasKassner)\
**Post date:** [9. Juli 2021 um 11:29 UTC](https://forum.shopware.com/t/feed-export-problem/88827/8 "2021-07-09T11:29:46Z")

</div>

Individual shipping costs like here: [Shopware 5 - Shipping Costs & Payment - Individual shipping costs](https://docs.shopware.com/en/shopware-5-en/shipping-costs-and-payment-methods/individual-shipping-costs)

Please check your shipping costs.

---

<div class="post-metadata">

**Author:** ![DeanandDavidSuperF](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/deananddavidsuperf/32/14043_2.png) [@DeanandDavidSuperF](https://forum.shopware.com/u/DeanandDavidSuperF)\
**Post date:** [9. Juli 2021 um 13:18 UTC](https://forum.shopware.com/t/feed-export-problem/88827/9 "2021-07-09T13:18:13Z")

</div>

The calculation of shipping cost is based on the price of the cart:

![image](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/6/601a3535fd7dbc2dc76e8bc5347329798944fb7e.png)

is this what you mean ? does this need to be changed?

---

<div class="post-metadata">

**Author:** ![TobiasKassner](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/tobiaskassner/32/21642_2.png) [@TobiasKassner](https://forum.shopware.com/u/TobiasKassner)\
**Post date:** [9. Juli 2021 um 14:28 UTC](https://forum.shopware.com/t/feed-export-problem/88827/10 "2021-07-09T14:28:53Z")

</div>

@DeanandDavidSuperF No, like in the documentation/wiki I linked you…Didn’t you read that?

Do you have only one shipping method?

Check the advanced configurations of every shipping method like here:

 ![screenshot-test.shopware.in-2021.07.09-16_26_02](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/4/46a2732490d2b451f576e012b86ff2d6b693f0e8.png)

and if here are some „non standard“ additions:

 ![screenshot2-test.shopware.in-2021.07.09-16_27_26](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/5/5c745006c8a06936aa35cfd5c48f2732773d600e.png)