The CSV format is explained in the following section.
If larger CSV sample file is required, you can obtain these from epoq on request.
You can also create the catalog in CSV format. This format was fundamentally standardized with RFC 4180. There are three main points:
- Use the double inverted comma as field delimiter for all fields: "
- Separate all fields with a comma: ,
- Replace all double inverted commas within the data with two double inverted commas: ""
If you implement the above points, then you can use any character and character combination when maintaining your products. Also html snippets etc. are possible without any problems.
Please also note the following points:
- The CSV file is a pure text file
- The coding of the content must be uniform ("UTF-8" or "ISO-8859-15",..)
- As a line break "\n" should be used by default.
- Please use a header, which defines the column names.
- Please make sure that the data matches the header
- The number of columns in each row must be the same and identical to the number of headers.
The header is variable and could look like the one described below. This is followed by the lines with the products and their values. The meaning and number of the individual parameters are the same as those of the XML format, only some of the names change.
Catalog format CSV
"productId","name","productUrl","price","smallImage","description","category","brand","variantOf",
"recommendable","quantity","condition","color","size","largeImage","locaKey","currency","deliveryTimeInDays",
"newArticle","accessories","ean"
"item_stick_16456","brandA USB stick 1GB","http://www.shopXYZ.de/products?id=16456","16.50",
"www.shopXYZ.de/imgs/usb_1GB_small.jpg","This ... thanks to USB 2.0 standard ""new worlds"" experience.",
"Hardware>Storage Media>USB-Sticks","brand A",192141,"true",1,"new","black",,,"en","dollar",10,"true",,9783462341516