csv_export_documentation:csv_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_format [2021/07/21 10:35] florian |
csv_export_documentation:csv_format [2023/02/22 12:04] (current) rihad |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Findologic CSV export format ===== | + | ===== Findologic CSV 1.0 export format ===== |
| 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. | 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. | ||
| Line 40: | Line 40: | ||
| ^**''[[#date_added]]''**|The date, on which the article was added to the shop. | 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 | | ^**''[[#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 | | ||
| - | ^**''[[#optional_additional_columns|...]]''**| You can define additional columns freely.| No | No | | + | ^**''[[#visibilities]]''**| Indicates the visibility of all/some products | No | No | |
| + | ^**''[[#properties]]''**| You can define additional information using the properties column.| No | No | | ||
| ---- | ---- | ||
| Line 238: | Line 239: | ||
| ---- | ---- | ||
| - | === optional_additional_columns === | + | === visibilities=== |
| - | These columns can have freely choosable names, which can be used as properties: | + | * The visibility must be set in the column visible. |
| - | * The values in these columns won't be used by for the calculation of the search results. | + | * The column **visible** is an optional column, if it did not exist all products will be visible. |
| + | * The column **visible** must contain lowercase **true** (or **1** as a replacement) for visible initial state or lowercase **false** (or **0** as a replacement) for invisible initial state. | ||
| + | * If the column value is blank or one of the values (True, faLse, yes, no, -1 ….) , this will cause validation warnings, and will use **true** as fallback value. | ||
| + | |||
| + | ---- | ||
| + | |||
| + | === properties === | ||
| + | These values can have freely choosable names, which can be used as properties: | ||
| + | * The values in this column won't be used by for the calculation of the search results. | ||
| * All informations given here can be used for your specific needs. | * All informations given here can be used for your specific needs. | ||
| * F.e.: stock information, shipping details, etc. | * F.e.: stock information, shipping details, etc. | ||
| Line 307: | Line 316: | ||
| * A parent product must contain all ordernumbers of its variants and the variants must not contain any ordernumber at all. | * A parent product must contain all ordernumbers of its variants and the variants must not contain any ordernumber at all. | ||
| * A variant export must contain a column called parent_id | * A variant export must contain a column called parent_id | ||
| + | * Variant products must follow the parent product immediately, without any other parent products in between. | ||
| * Header column names (id, parent_id, price etc.) shouldn't be wrapped in quotes/parentheses. | * Header column names (id, parent_id, price etc.) shouldn't be wrapped in quotes/parentheses. | ||
| * Only the attributes of the parent have a effect on the outputAttributes. | * Only the attributes of the parent have a effect on the outputAttributes. | ||