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>
Does someone has an Idea what is wrong here?
Thanks
Hey DeanandDavidSuperF,
can you share your template with us? There seems to be an error in one line.
Best regards
Tobi
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.
@DeanandDavidSuperF
You used “ and ” instead of " in your Template !!
Corrected it works:
{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
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>
I hope you have an idea where the problem is.
thanks again for your help.
@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
Thanks a lot Tobi for your continuous support.
I checked and we do not have any filter in the additional filters in the feed:
What do you mean by Dynamic calculation for shipping cost? which parameter ?
Thanks and have a nice day
Individual shipping costs like here: Shopware 5 - Shipping Costs & Payment - Individual shipping costs
Please check your shipping costs.
The calculation of shipping cost is based on the price of the cart:
is this what you mean ? does this need to be changed?
@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:
and if here are some „non standard“ additions:
