...
The structure of the product feed is CSV with the following required fields:
| Google field | Corresponding Mapping | Memo |
|---|---|---|
id | sku.code or product.code | You can choose to use sku or product entity depending on your setup |
title | sku.displayName or product.displayName | You can choose to use sku or product entity depending on your setup |
link | sku.seo.uri or product.seo.uri | You can choose to use sku or product entity depending on your setup
e.g. "https://www.myshop.com/fc/MAIN/product/$1" |
image_link | IMAGE0 atrribute on sku or product | You can choose to use sku or product entity depending on your setup
e.g. "https://www.myshop.com/imgvault/product/$1" |
additional_image_link | IMAGE1 atrribute on sku or product | You can choose to use sku or product entity depending on your setup
|
price |
e.g. "$1 CHF" | |
shipping |
e.g. "CH:::4.95 CHF" (CH is the code for your region and extra colons are separators for shipping attributes, which you can leave as default) | |
availability |  hardcode to "in_stock" | |
condition | hardcode to "new" | |
brand | sku.product.brand.name or product.brand.name | You can choose to use sku or product entity depending on your setup |
gtin | sku.barCode or product.attribute.XXXX | You can choose to use sku or product entity depending on your setup
|
mpn | sku.nanufacturerCode or product.manufacturerCode | You can choose to use sku or product entity depending on your setup |
Note that in your descriptor you need to specify full path on the server where to put the file. It is recommended to place it in one of the apache resource directories for your site. Ensure you specify the resource path to avoid proxy to tomcat.
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<!--
~ Copyright 2009 Inspire-Software.com
~
~ Licensed under the Apache License, Version 2.0 (the "License");
~ you may not use this file except in compliance with the License.
~ You may obtain a copy of the License at
~
~ http://www.apache.org/licenses/LICENSE-2.0
~
~ Unless required by applicable law or agreed to in writing, software
~ distributed under the License is distributed on an "AS IS" BASIS,
~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
~ See the License for the specific language governing permissions and
~ limitations under the License.
-->
<export-descriptor xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.yes-cart.org/schema/export-descriptor.xsd">
<context>
<shop-code>MMS<code>SHOP10</shop-code>
</context>
<entity-type>org.yes.cart.domain.entity.Product</entity-type>
<export-file-descriptor>
<file-encoding>UTF-8</file-encoding>
<file-name>/var/www/shop10/resources/2l8YSRX1tTAQq_merchantcentre.csv</file-name>
<print-header>true</print-header>
<column-delimiter>,</column-delimiter>
<text-qualifier>"</text-qualifier>
</export-file-descriptor>
<select-sql>
select distinct s.product, w
from ProductSkuEntity s, SkuPriceEntity r, SkuWarehouseEntity w
where
s.code = r.skuCode
and r.shop.shopId = 15
and r.currency = 'CHF'
and r.pricingPolicy is null
and (r.saleto is null or r.saleto > {NOW})
and s.code = w.skuCode
and w.warehouse.warehouseId in (5,6)
and w.quantity > 0
and (w.availableto is null or w.availableto > {NOW})
</select-sql>
<export-columns>
<!-- SKU -->
<column-descriptor>
<column-header>id</column-header>
<field-type>FIELD</field-type>
<name>code</name>
</column-descriptor>
<!-- Display names DE -->
<column-descriptor>
<column-header>title</column-header>
<field-type>FIELD</field-type>
<name>name</name>
<!-- <name>displayName</name>-->
<!-- <language>de</language>-->
</column-descriptor>
<!-- Short description -->
<column-descriptor>
<column-header>description</column-header>
<field-type>FIELD</field-type>
<data-type>AVC</data-type>
<name>attributes</name>
<context>PRODUCT_DESCRIPTION2_de</context>
</column-descriptor>
<!-- Deep link -->
<column-descriptor>
<column-header>link</column-header>
<field-type>FIELD</field-type>
<data-type>org.yes.cart.domain.entity.Seo</data-type>
<name>seo.uri</name>
<value-regex>(.*)</value-regex>
<value-regex-template>https://www.myshop.com/fc/MAIN/product/$1</value-regex-template>
</column-descriptor>
<!-- Image -->
<column-descriptor>
<column-header>image_link</column-header>
<field-type>FIELD</field-type>
<data-type>AVC</data-type>
<name>attributes</name>
<context>IMAGE0</context>
<value-regex>(.*)</value-regex>
<value-regex-template>https://www.myshop.com/imgvault/product/$1</value-regex-template>
</column-descriptor>
<!-- Image Alternative -->
<column-descriptor>
<column-header>additional_image_link</column-header>
<field-type>FIELD</field-type>
<data-type>AVC</data-type>
<name>attributes</name>
<context>IMAGE1</context>
<value-regex>(.*)</value-regex>
<value-regex-template>https://www.myshop.com/imgvault/product/$1</value-regex-template>
</column-descriptor>
<!-- Price in CHF incl VAT -->
<column-descriptor>
<column-header>price</column-header>
<field-type>FIELD</field-type>
<data-type>PRICE</data-type>
<name>productId</name>
<context>CHF</context>
<value-regex>(.*)</value-regex>
<value-regex-template>$1 CHF</value-regex-template>
</column-descriptor>
<!-- Order shipping cost -->
<column-descriptor>
<column-header>shipping</column-header>
<field-type>FIELD</field-type>
<name>productId</name>
<value-constant>CH:::4.95 CHF</value-constant>
</column-descriptor>
<!-- Availability -->
<column-descriptor>
<column-header>availability</column-header>
<field-type>FIELD</field-type>
<name>productId</name>
<value-constant>in_stock</value-constant>
</column-descriptor>
<!-- Condition -->
<column-descriptor>
<column-header>condition</column-header>
<field-type>FIELD</field-type>
<name>productId</name>
<value-constant>new</value-constant>
</column-descriptor>
<!-- Brand,Manufacturer -->
<column-descriptor>
<column-header>brand</column-header>
<field-type>FK_FIELD</field-type>
<entity-type>org.yes.cart.domain.entity.Brand</entity-type>
<name>brand.name</name>
</column-descriptor>
<!-- EAN or ISBN for Books -->
<column-descriptor>
<column-header>gtin</column-header>
<field-type>FIELD</field-type>
<data-type>AVC</data-type>
<name>attributes</name>
<context>atoppreiseexportean</context>
</column-descriptor>
<!-- Manufacturer SKU -->
<column-descriptor>
<column-header>mpn</column-header>
<field-type>FIELD</field-type>
<name>manufacturerCode</name>
</column-descriptor>
</export-columns>
</export-descriptor> |
...