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 Last revision Both sides next revision | ||
csv_export_documentation:csv_format [2021/07/21 10:35] florian |
csv_export_documentation:csv_format [2023/02/22 12:04] rihad old revision restored (2022/05/11 14:19) |
||
---|---|---|---|
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. |