Translate this Page

How to create a Collections.csv file

The Collections.csv file is the table that contains the description of all collections of products, which are presented in your catalogue. Please pay attention! The file must contain only the descriptions of the COLLECTIONS OF PRODUCTS. Descriptions of groups of products, trademarks, as well as the properties of the products themselves would be contained in the other files.

In order to start filling this file for your database, please download the template, by pressing the link below:


Download the template of the Collections.csv file


Example of filling of the file


Open this file on your computer with Microsoft Office Excel or OpenOffice Calc. File encoding - UTF-8, separator - comma.

Please define which and how many product collections will be in your catalogue. For each collections you need to complete a separate line in the Collections.csv file. ATTENTION! This file ONE for the entire database. It must include ALL collections of ALL trademarks from ALL groups of projects.


The file consists of five columns:


1. First column "Group" - the name of the group of products (or services). ATTENTION! The name in the "Group" column must be exactly the same as the name of this group in the Group.csv file, "Group Name" column. If these names will vary, for example, even by containing one extra space at the end of the word or a single punctuation mark, the application will consider them to be different groups of products.



2. Second column "Trademark" - the name of the trademarks of products (or services). ATTENTION! The name in the "Trademark" column in this file must be exactly the same as the name of this trademark in the Trademarks.csv file, "Trademark" column. If these names will vary, for example, even by containing one extra space at the end of the word or a single punctuation mark, the application will consider them to be different trademarks.



3. Third column "Collection" - the name of the collection of the products. This name will be displayed in the application on the catalogue page as the name of the corresponding collection of products (or services) :



4. Fourth column "Description of a collection" contains the text description of this collection. This description will be displayed in the application on the page of the collection:



For more convenient editing and formatting of the collection's description we recommend that you first create this description in any text editor, and then simply copy and paste it in the desired cell in the table of your Collections.csv file.


5. Fifth column "Link" - the link to the graphic file in the JPG or PNG format, which will be displayed as an icon of the collection in the application and on the page of the catalogue:



ATTENTION! If you specify the full link to the file, like: "http://sitename.com/filename.jpg", the application will take the file, specified by the link at the place of its location. If the cell will contain only the name, like "filename.jpg", the application will search for the file in the same folder, where the "Collections.csv" file is located itself.


After you fill all these 5 columns for all your collections of all trademarks of all product groups, you get the ready to use Collections.csv file. Save it in a folder on your hosting. Please ensure that it has a read access by a direct link. In order to do so, enter the link like the one below into your browser: "http://yourwebsite.com/folderwithcataloguefiles/Collections.csv".


Go to page "How to create"


If you still have questions, you can contact us right now here:

Have a question? Write to us: