Blog

If you have a Shop with the Shopware software, maybe you like to produce a Products Feed for Google Merchant Center in order to send your selected Categories from your Shop to Google. What you need to do is to create the right Template containing the columns and all data appropriately formatted according to the standards required by Google.

You can find out further informations about the standards of Google Merchant Feeds here:

• Tab-delimited data feed instructions
• Product data specification

On your shop Backend select Marketing -> Item export (or Produktexporte in German), then click on Add:

Set the parameters for your shop:

• Title: a name for your Feed
• File name: TXT filename to call
• Hash: random generate hash from Shopware (you can change it)
• Shop: select your Shop in drop down menu
• The Customer Group you have to export
• Currency
• Category: witch Category you have to export (Main Category for the whole shop)
• Variants, if you need to export Product Variants

This is the structure of the Header (Kopfzeile) of your Feed:

{strip}
id{#S#}
title{#S#}
description{#S#}
price{#S#}
condition{#S#}
link{#S#}
availability{#S#}
image_link{#S#}
google_product_category{#S#}
product_type{#S#}
brand{#S#}
gtin{#S#}
identifier_exists{#S#}
shipping
{/strip}{#L#}

Please, notice that the last element of your table HAS NOT a separator placeholder {#S#}.
This placeholder will generate a TAB separator and so a new empty column that will be an error on Google Merchant.

And this is the structure of the Body (Template) of your Feed:

{strip}
{$sArticle.ordernumber|escape}{#S#}
{$sArticle.name|strip_tags|strip|truncate:80:"...":true|escape|htmlentities}{#S#}
{$sArticle.description_long|strip_tags|html_entity_decode|trim|regex_replace:"
      #[^\wöäüÖÄÜß\.%&-+ ]#i":""|strip|truncate:500:"...":true|htmlentities|escape}{#S#}
{$sArticle.price|escape:"number"|replace:',':'.'} EUR{#S#}
New{#S#}
{$sArticle.articleID|link:$sArticle.name|escape}{#S#}
in stock{#S#}
{$sArticle.image|image:1}{#S#}
7362{#S#}
{$sArticle.articleID|category:">"|escape}{#S#}
Brand of Product{#S#}
{#S#}
no{#S#}
DE:::{$sArticle|@shippingcost:"prepayment":"de":"DHL / DPD"|escape:"number"|replace:',':'.'} EUR
{/strip}{#L#}

For this Customer we have some fixed Values, as:

• condition: New
• availability: in stock
• brand: ShopName
• gtin: (empty)
• identifier_exists: no

Now you can test if a correct CSV file will be generated by clicking on the name of the Feed you've gave in.

Do not forget to set correct parameters to get a right CSV rendering with your CSV Editor (eg. OpenOffice Calc or Microsoft Office Excel)

Thanks, Fabrizio.