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/08/17 10:24] 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 | | ||
| + | ^**''[[#visibilities]]''**| Indicates the visibility of all/some products | No | No | | ||
| ^**''[[#properties]]''**| You can define additional information using the properties column.| No | No | | ^**''[[#properties]]''**| You can define additional information using the properties column.| No | No | | ||
| Line 235: | Line 236: | ||
| * Articles may be sorted ascending or descending after this value. | * Articles may be sorted ascending or descending after this value. | ||
| * This value can also be used as a sort criteria. | * This value can also be used as a sort criteria. | ||
| + | |||
| + | ---- | ||
| + | |||
| + | === visibilities=== | ||
| + | * The visibility must be set in the column visible. | ||
| + | * 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. | ||
| ---- | ---- | ||
| 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. | ||