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 Last revision Both sides next revision | ||
csv_export_documentation:csv_2_format [2023/03/28 10:09] rihad |
csv_export_documentation:csv_2_format [2023/03/29 10:23] rihad old revision restored (2023/03/28 16:35) |
||
---|---|---|---|
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 ==== | ||
+ | * You can find an example for a rightly formatted CSV-file [[https://export.demo.findologic.com/demo_feed.csv|here]]. | ||
+ | |||
+ | ---- | ||
==== The columns in particular ==== | ==== The columns in particular ==== | ||
Line 26: | Line 32: | ||
^**''[[#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 | | ||
- | ^**''[[#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 37: | Line 42: | ||
^**''[[#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 104: | Line 109: | ||
=== 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 133: | Line 125: | ||
* 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 155: | Line 148: | ||
---- | ---- | ||
- | **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 167: | Line 160: | ||
* 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 222: | Line 210: | ||
=== 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 242: | Line 230: | ||
---- | ---- | ||
- | === 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 322: | Line 310: | ||
\\ | \\ | ||
- | === 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}} |