csv_export_documentation:csv_2_format
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
csv_export_documentation:csv_2_format [2023/03/28 09:38] rihad [Findologic CSV 2.0 export format] |
csv_export_documentation:csv_2_format [2023/04/03 17:15] (current) tobi |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| A warning will be shown during import and the tags get stripped automatically.</note> | A warning will be shown during import and the tags get stripped automatically.</note> | ||
| + | ---- | ||
| + | |||
| + | === Demo CSV ==== | ||
| + | * [[https://github.com/findologic/libflexport/blob/develop/resources/baseline_examples/example.csv|Without variants]]. | ||
| + | * [[https://github.com/findologic/libflexport/blob/develop/resources/baseline_examples/example-variants.csv|With variants]]. | ||
| + | |||
| + | ---- | ||
| ==== The columns in particular ==== | ==== The columns in particular ==== | ||
| Line 26: | Line 33: | ||
| ^**''[[#price]]''**|Currently valid retail price incl. taxes (f.e. currents sales price). Must have a dot (.) as decimal delimiter only. | Yes | No | | ^**''[[#price]]''**|Currently valid retail price incl. taxes (f.e. currents sales price). Must have a dot (.) as decimal delimiter only. | Yes | No | | ||
| ^**''[[#overriddenPrice]]''**|Regular price of the article incl. taxes. | No | No | | ^**''[[#overriddenPrice]]''**|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. | Yes | No | | ^**''[[#url]]''**|Absolute or relative link to the article-detail-page. | Yes | No | | ||
| - | ^**''[[#image]]''**|Absolute or relative link to article image. We recommend to deliver the image in thumbnail-size. Export supports more than 1 product image. Just add another column image0, image1 and so on. Syntax is “imageX” where X is any number. | No | No | | + | ^**''[[#image*]]''**|Absolute or relative link to article image. We recommend to deliver the image in thumbnail-size. Export supports more than 1 product image. Just add another column image0, image1 and so on. Syntax is “imageX” where X is any number. | No | No | |
| - | ^**''[[#attributes]]''**|Categories and attributes (used for filters) of the article. | Yes | Yes | | + | ^**''[[#attrib_*]]''**|Categories and attributes (used for filters) of the article. | Yes | Yes | |
| ^**''[[#keywords]]''**|Keywords, which are related to the article. | No | Yes | | ^**''[[#keywords]]''**|Keywords, which are related to the article. | No | Yes | | ||
| ^**''[[#groups]]''**|Groups, which the article is related to. (f.e. subshops). | No | No | | ^**''[[#groups]]''**|Groups, which the article is related to. (f.e. subshops). | No | No | | ||
| Line 38: | Line 43: | ||
| ^**''[[#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 | | ^**''[[#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 | | ^**''[[#visibilities]]''**| Indicates the visibility of all/some products | No | No | | ||
| - | ^**''[[#properties]]''**| You can define additional information using the properties column.| No | No | | + | ^**''[[#prop_*]]''**| You can define additional information using the properties column.| No | No | |
| ---- | ---- | ||
| Line 105: | Line 110: | ||
| === overriddenPrice === | === overriddenPrice === | ||
| - | 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 gross price shown instead of the base price, for example ''Now only 39.95$ instead of 59.95$'' --> ''base price=59.95, overriddenPrice=39.95''. |
| * The same rules as in the column ''price'' (described above) apply. | * 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. | ||
| ---- | ---- | ||
| Line 134: | Line 126: | ||
| * May be relative or absolute. | * May be relative or absolute. | ||
| * If a relative URL is given, it will be appended to the search result page URL. | * If a relative URL is given, it will be appended to the search result page URL. | ||
| + | * All image columns need to be numbered, starting with image0, continuing with image1, and so on. | ||
| ---- | ---- | ||
| - | === attributes === | + | === attrib_* === |
| * Each attribute gets its own column, that will be used as filters. [[:customer_account:filter_configuration|Here]] you can find our documentation about filter configuration. | * Each attribute gets its own column, that will be used as filters. [[:customer_account:filter_configuration|Here]] you can find our documentation about filter configuration. | ||
| Line 156: | Line 149: | ||
| ---- | ---- | ||
| - | **cat_url** (Category paths for navigation) | + | **attrib_cat_url** (Category paths for navigation) |
| - | In order to use Findologic Navigation with Direct Integration, the parameter ''attrib_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. | + | In order to use Findologic Navigation with Direct Integration, the parameter ''attrib_cat_url'' has to be added with the category path. If a product is shown in several categories, all paths have to be exported. |
| - | <note>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.</note> | + | <note>You have to export both main-''attrib_cat_url's'' and sub-''attrib_cat_url's'' for the main- and sub-categories, that an article is assigned to.</note> |
| For example for a product, which is assigned to the following categories ... | For example for a product, which is assigned to the following categories ... | ||
| Line 168: | Line 161: | ||
| * http://www.example.com/jacken&maentel | * http://www.example.com/jacken&maentel | ||
| * http://www.example.com/de/geschenke/champagner | * http://www.example.com/de/geschenke/champagner | ||
| - | |||
| - | ... these ''cat_url's'' should be added to the "attributes" column | ||
| - | <code xml> | ||
| - | cat_url=/presents&cat_url=/presents/champagne&cat_url=/wedding-presents&cat_url=/jacken%26maentel&cat_url=/de/geschenke/champagner | ||
| - | </code> | ||
| ---- | ---- | ||
| Line 223: | Line 211: | ||
| === date_added === | === date_added === | ||
| The date, on which the article was added. | The date, on which the article was added. | ||
| - | * The date hast to be given in the UNIX-Time format. (Wikipedia: [[https://en.wikipedia.org/wiki/Unix_time|Unix time]]) | + | * The date hast to be given in the Use ISO-8601 format. |
| * This value can be used as a sort criteria. | * This value can be used as a sort criteria. | ||
| Line 243: | Line 231: | ||
| ---- | ---- | ||
| - | === properties === | + | === prop_* === |
| * The values in this column won't be used by for the calculation of the search results. | * The values in this column won't be used by for the calculation of the search results. | ||
| Line 323: | Line 311: | ||
| \\ | \\ | ||
| - | === Demo CSV === | ||
| - | |||
| - | ^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 | | ||
| {{tag>CSV_export CSV}} | {{tag>CSV_export CSV}} | ||