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:17] 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 119: | 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. | ||
| ---- | ---- | ||
| Line 141: | 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 153: | 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 208: | 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 228: | 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 308: | 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}} | ||