Hotfix release available: 2017-02-19e "Frusterick Manners". upgrade now! [49.5] (what's this?)
Hotfix release available fixing CVE-2017-12979 and CVE-2017-12980: 2017-02-19d "Frusterick Manners". upgrade now! [49.4] (what's this?)
export_patterns:csv

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.

The CSV-export should be provided as direct link to the CSV-file in the customer login - if needed with login and password (HTML basic access authentication).

Demo CSV

  • You can find an example for a rightly formatted CSV-file here.

The columns in particular

Column Description Length Has to have content Will be used for search
idUnique ID of the article 255 Yes No
ordernumberOrdernumber(s) / SKU(s) of the article 80 Yes Yes
nameName of the article, how it is displayed on the search result pages 1GB Yes Yes
summaryShort description of the article, which can be displayed optionally. 1GB No Yes
descriptionDetailed article description. 1GB No Yes
priceCurrently valid retail price incl. taxes (f.e. currents sales price). 10.2 1) Yes No
insteadRegular price of the article incl. taxes. 10.2 2) No No
maxpriceCurrently valid retail price incl. taxes with the highest available option. 10.2 3) No No
taxrateTaxrate of the article. 10.2 4) Yes No
urlAbsolute or relative link to the article-detail-page. 1023 Yes No
imageAbsolute or relative link to article image. We recommend to deliver the image in thumbnail-size. 1023 Yes No
attributesCategories and attributes (used for filters) of the article. 1GB Yes Yes
keywordsKeywords, which are related to the article. 1GB No Yes
groupsGroups, which the article is related to. (f.e. subshops). 1GB No No
bonusBonusvalue related to the specific article. This is useful to push products on top of the search results. 10.2 5) No No
sales_frequencySalesfrequency of the article. “How often was the specific article sold?” 2147483647 No No
date_addedThe date, on which the article was added to the shop. 2147483647 No No
sortThis 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. 2147483647 6) No No
... You can define additional columns freely. No No

Format

  • The CSV-file has to be UTF-8 encoded.
  • The columns of the CSV-file have to be seperated by a tab (\t).
  • The rows have to be seperated by “new line” (\n). (NOT carriage return)
  • If the text value of a column contains several words, it has to be in double quotation marks ().
  • Functional characters (return, \n, tab \t, etc.) have to replaced by a white space.
  • Escape sequences are used analog as in C / C++ / Java / PHP (f.e. A 17\” monitor “).
  • The first row has to contain the names of the columns, that are shown in the table above (f.e. id, ordernumber, etc.).
  • The names of the columns must not be in quotation marks.
  • The CSV-file must not be bigger than 2 GB.

The columns in detail


id

Unique ID of the article:

  • May contain letters and numbers.
  • Must not be longer than 255 characters.
  • Has to be unique - if there are duplicate ids only the first article with this id will be imported.

ordernumber

Ordernumber(s) / SKU(s) of the article:

  • May contain characters and seperators (except ”|“ and ”#“).
  • You can provide several ordernumbers seperated by ”|“. These can be used slave- / child-ordernumbers, SKUs, EAN/ISBN, etc.
  • The limitation to 80 characters is related to one ordernumber. Several ordernumbers seperated by ”|“ can each contain 80 characters.
  • Ordernumbers are not being searched error tolerant.
  • In order to be able to find variations of the ordernumber, you can add these variations as seperate ordernumbers (f.e. 081512345|0815 - if the ordernumber should be found also by typing in the first 4 numbers).

name

Name of the article:

  • Must not contain HTML- or XML-formatting.

summary

Short description of the article:

  • Must not contain HTML- or XML-formatting.

description

Detailed description of the article:

  • Must not contain HTML- or XML-formatting.

price

The gross price (base price - incl. taxes) of the article.

  • Must have a dot (.) as decimal seperator.
  • Must not contain seperators for numbers larger than or equal to 1000.
  • Example: 24999.95 = right | 24,999.95 = wrong
  • For certain cases such as items without a price, intranet- or CMS-search, use a price of 0.00.

instead

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.

  • The same rules as in the column price (described above) apply.

maxprice

The price for the most expensive article variant. It can be used for prices like from 29 € –> price=“29.00”, maxprice=“39.00”

  • The same rules as in the column price (described above) apply.

taxrate

Tax rate of given article (f.e.: 19 für 19% VAT).

  • Must not contain the % character.
  • If column is left empty, a tax rate of 19% is assumed.

url

The URL, which links to the article-detail-page.

  • May be relative or absolute.
  • If a relative URL is given, it will be appended to the search result page URL.

image

The URL, which links to the article image.

  • May be relative or absolute.
  • If a relative URL is given, it will be appended to the search result page URL.

attributes

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.

  • All attributes have to be encoded in URL-style: Example: color=red&cat=bikes.
    • It is very important that you also encode characters like = or & that are contained in the values.
    • For example, a bike made by a manufacturer called Sons&Brothers would look like this: vendor=Sons%26Partner&cat=bikes.
    • It is also important that all attributes are UTF-8 encoded before you URL encode them.
  • More than one value of the same attribute may be used: Use it like this: color=red&color=green.
  • All attribute names and values are non case-sensitive.
categories
  • Categories must be given with the key cat. This is important!
    • Sub-categories have to be separated with an underline character _, which must not be URL-encoded.
    • For example, an article from the category 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.

You have to export both main-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
  • Vendors (manufacturers) must be given with the key vendor. This is also very important!

keywords

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.

  • Keywords have to be seperated by a comma (”,“).
  • Keyword may contain more than one word (“hiking shoe”).
  • Example: keywords=hiking shoe, mountains

groups

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.

  • Have to be seperated by a comma (”,“).
  • The values have to be strings.
  • There is a maximum of 4 096 articles supported per article.
  • If the value of a group contains more than one word, you have to replace the whitespaces with ”+“.
  • Example: uk_01,uk_02,ger_01,ger_02,rest+of+the+world.

bonus

With this value, you can influence the ranking of certain articles.

  • The bonus ranking is computed after the following formula: ( 1 + bonus ), meaning that a bonus of 1 will double this articles relevance.
  • Negative values are allowed, if you want to lower the ranking of the article.
  • To boost an article, we recommend using a value from 1 to 3.
  • To lower the ranking of an article, we recommend a value from 0 to -0.9.
  • If you have pushing-rules activated in your FINDOLOGIC customer account (see our documentation about product pushing), the values in the fields of the pushed products will be replaced and will have no effect.

sales_frequency

Amount of sold items of the given article.

  • This value has to be an integer (whole number), whose value is bigger as or equals 0.
  • This value will be computed into ranking calculation.
  • This value can also be used as a sort criteria.
If you use PlentyMarkets (version 6 or higher) it is not possible to export a value for sales frequency

date_added

The date, on which the article was added.

  • The date hast to be given in the UNIX-Time format. (Wikipedia: Unix time)
  • This value can be used as a sort criteria.

sort

Freely choosable integer (whole number) value to sort articles on the search result page.

  • Articles may be sorted ascending or descending after this value.
  • May have a different meaning for each shop system.

optional_additional_columns

These columns can have freely choosable names:

  • The values in these columns won't be used by for the calculation of the search results.
  • All informations given here can be used for your specific needs.
  • F.e.: stock information, shipping details, etc.

1) , 2) , 3) , 4) , 5)
10 digits and 2 decimals
6)
If sort is used combined with our calculated relevance, the values must not be negative