What are the specific requirements for a CSV file?

  • Field separators can be comma , / TAB / semi-colon ; / pipe |
Default separator is comma ,
    • Attribute value delimiters can be comma , / semi-colon ; / pipe |
    Default attribute value delimiter is pipe |
      • For AttributeList columns, delimiters can be colon : / equals = / comma , / semi-colon ; / pipe |
      Default attributetype:value delimiter is colon :
      Default attribute types delimiter is semi-colon ;

       

      If you have multiple values for the same attribute type, you should duplicate the attributetype:value for all available attribute values.

         

        Default example: 

        attributetype1:value;attributetype2:value;attributetype3:value

        color:blue;size:small;size:medium;size:large;season:summer;season:spring

         

        The chosen field separator must be different from the chosen delimiters however!!!

         

        • Double quotes “” can be used to enclose values which could create conflicts with the above defaults (eg. SalePrice value is comma-delimited too, full text values with commas,...).

         

        CSV Example 1:

        1 line equals 1 product on level of color/price.
        GroupId available for grouping (if needed). When activated in the Verbolia app, the results (image/link) on the Verbolia pages will be shown on this level.
        Different attribute columns (brand, category, sizes,...), values are pipe delimited.
        1 column containing AttributeList per product (attribute types Color, ImageUrl, SalePrice,...), following the above default delimiters.

        CSV Example 2:

        Same as 1a, only more attribute types are integrated into the AttributeList column (eg. size, season, badge,...).

        CSV Example 3:

        Same as 1a, only 1 line equals 1 product on level of color/price and size.