If your are using CSV-export for the data synchonization between your shop data and Findologic, the CSV-data provided by you has to be formatted in the way that is described below.
Unless you have an enterprise-contract the shop data will be imported by Findologic automated daily at a fixed time between 01:00 CET and 06:00 CET.
You can either write your own export script, provide a completely finished CSV-file for the import, or use a plugin provided by Findologic.
You can find a detailed description of all available colums in our CSV-format below.
Column | Description | Has to have content | Will be used for search |
---|---|---|---|
id | Unique ID of the article | Yes | No |
ordernumber | Article number(s) / SKU(s) of the article | Yes | Yes |
name | Name of the article, how it is displayed on the search result pages | Yes | Yes |
summary | Short description of the article, which can be displayed optionally. | No | Yes |
description | Detailed article description. | No | Yes |
price | Currently valid retail price incl. taxes (f.e. currents sales price). | Yes | No |
instead | Regular price of the article incl. taxes. | No | No |
maxprice | Currently valid retail price incl. taxes with the highest available option. | No | No |
taxrate | Taxrate of the article. | Yes | No |
url | Absolute or relative link to the article-detail-page. | No | No |
image | Absolute or relative link to article image. We recommend to deliver the image in thumbnail-size. | No | No |
attributes | Categories and attributes (used for filters) of the article. | Yes | Yes |
keywords | Keywords, which are related to the article. | No | Yes |
groups | Groups, which the article is related to. (f.e. subshops). | No | No |
bonus | Bonusvalue related to the specific article. This is useful to push products on top of the search results. | No | No |
sales_frequency | Salesfrequency of the article. “How often was the specific article sold?” | No | No |
date_added | The date, on which the article was added to the shop. | No | No |
sort | This value can be used to sort the articles and to have influence on the position of specific articles on the search result pages. Has to be an integer. | No | No |
visibilities | Indicates the visibility of all/some products | No | No |
properties | You can define additional information using the properties column. | No | No |
\t
).\n
). (NOT carriage return)“
). \n
, tab \t
, etc.) have to replaced by a white space.A 17\” monitor “
).
Unique ID of the article:
Ordernumber(s) / SKU(s) of the article:
|
“ and ”#
“).|
“. These can be used slave- / child-ordernumbers, SKUs, EAN/ISBN, etc.081512345|0815
- if the ordernumber should be found also by typing in the first 4 numbers).Name of the article:
Short description of the article:
Detailed description of the article:
The gross price (base price - incl. taxes) of the article.
.
) as decimal seperator.24999.95
= right | 24,999.95
= wrong0.00
.
The gross price shown instead of the base price, for example Now only 39.95$ instead of 59.95$
–> base price=59.95, instead=39.95
.
price
(described above) apply.
The price for the most expensive article variant. It can be used for prices like from 29 €
–> price=“29.00”, maxprice=“39.00”
price
(described above) apply.
Tax rate of given article (f.e.: 19
für 19% VAT).
%
character.The URL, which links to the article-detail-page.
The URL, which links to the article image.
This column is used to set all values, that will be used as filters. Examples for these filters are: categories, vendor, color, size, etc. Here you can find our documentation about filter configuration.
vendor=Dolce%20%26%20Gabbana&cat=Schn%C3%BCrschuhe
.=
or &
that are contained in the values.Sons&Partners
would look like this: vendor=Sons%26Partners&cat=bikes
.color=red&color=green
.categories
cat
. This is important!_
, which must not be URL-encoded.Bikes > Mountain Bikes
has to look like this: cat=Bikes_Mountain+Bikes
cat_url (Category paths for navigation)
In order to use Findologic Navigation with Direct Integration, the parameter cat_url
has to be added with the category path to the “attributes” column. If a product is shown in several categories, all paths have to be exported.
cat_url's
and sub-cat_url's
for the main- and sub-categories, that an article is assigned to.
For example for a product, which is assigned to the following categories …
… these cat_url's
should be added to the “attributes” column
cat_url=/presents&cat_url=/presents/champagne&cat_url=/wedding-presents&cat_url=/jacken%26maentel&cat_url=/de/geschenke/champagner
vendor
vendor
. This is also very important!Keywords, that you specify for the given article. As this column has a big influence on the calculation of the results, please fill this colums very senseful in order to get the best search results.
”,“
).“hiking shoe”
). hiking shoe, mountains
This parameter can be used to assign given articles to certain groups. These groups can be used to seperate search result for subshops or customer-groups.
”,“
).”+“
.uk_01,uk_02,ger_01,ger_02,rest+of+the+world
.—-
With this value, you can influence the ranking of certain articles.
( 1 + bonus )
, meaning that a bonus of 1
will double this articles relevance.Amount of sold items of the given article.
The date, on which the article was added.
Freely choosable integer (whole number) value to sort articles on the search result page.
These values can have freely choosable names, which can be used as properties:
If you want to show different variations (colors, sizes etc.) of a certain product in your shop and you want to display those variants in specific product-cards on the search result page, it can be realized by following the steps described below (example for colors):
Functionality:
How the content of the variants-property should look like:
You have to provide an appropriate property (for example “variants”) for every parent-product by using a JSON-string. Here is an example of this property:
{ "Mud" : { "VariantIconPic" : "https://www.shop.com/media/jacket_mud_variant_icon.jpg", "productPic" : "https://www.shop.com/media/jacket_mud_variant_pic.jpg", "productUrl" : "https://www.shop.com/jacket_mud" }, "Black" : { "VariantIconPic" : "https://www.shop.com/media/jacket_black_variant_icon.jpg", "productPic" : "https://www.shop.com/media/jacket_black_variant_pic.jpg", "productUrl" : "https://www.shop.com/jacket_black" }, "Red" : { "VariantIconPic" : "https://www.shop.com/media/jacket_red_variant_icon.jpg", "productPic" : "https://www.shop.com/media/jacket_red_variant_pic.jpg", "productUrl" : "https://www.shop.com/jacket_red" }, "Navy" : { "VariantIconPic" : "https://www.shop.com/media/jacket_navy_variant_icon.jpg", "productPic" : "https://www.shop.com/media/jacket_navy_variant_pic.jpg", "productUrl" : "https://www.shop.com/jacket_navy" } }
This format allows the export of variant specific attributes. Those attributes can then be used to filter for the variant and not just the parent product.
size=M
is available in red
, but the same shirt in size=L
is only available in blue
. This export format is not set as default and must be activated by Findologic.Please contact our technical support if you have any questions regarding this export format.
id | ordernumber | name | price | image | attributes | groups | parent_id | keywords | bonus |
---|---|---|---|---|---|---|---|---|---|
123 | ABC|DEF|GHI | Parent | 99.90 | brand=ham | 215_public_parent,215_public | keyword1 | 1 | ||
123-1 | 60.00 | color=red&size=M | 215_public,218_public | 123 | |||||
123-2 | 70.00 | color=blue&size=L | 215_public,220_public | 123 | |||||
456 | JKL | Product without variants | 9.90 | brand=spam&length=50 | 215_public,222_public | keyword2 | 1 |