Unicat.Online - the application for your catalogs

gallery/45765949.fp8u8gi851.w215

Your catalogue of products or services in the form of an iPad and iPhone application.


 Easy. Simple. Convenient. Free.

How to create

So, you have decided to create your catalogue in AppStore. Great! To start, you need to create a folder on an Internet website, which will be accessible for reading for the application from AppStore:
 
Link to the application

 

and where your database for the application will be stored. You can create such folder, for example, by creating a website on any of the website hosting services (wildwestdomains.com,
 networksolutions.com, enom.com, 
1and1.com, hostgator.com, 
bluehost.com, register.com, 
sedoparking.com, hichina.com, 
dnspod.net, registrar-servers.com, ovh.net, 
nameadministration.com, 
dreamhost.com and others).
 
The main thing is that you are able to copy files to this folder, and that they are accessible for reading by http or https.
 
ALL FILES IN THE FOLDER MUST BE ACCESSIBLE BY A DIRECT LINK, THIS IS IMPORTANT!
gallery/unicat широкий
gallery/s1 -2
gallery/s2
gallery/s3
Your database may consist of only 6 files in .csv format, encoding - UTF-8. Yes, the database of your whole catalogue may consist of ONLY 6 FILES:
 
1. Group.csv file It contains descriptions of the groups of products (or services), which are present in your directory. The groups can be any, with any name and any description.

2. Trademarks.csv file. It contains the descriptions of trademarks of products (or services), which are present in your catalogue in all of your product groups.

3. Collections.csv file It contains the descriptions of collections inside the trademarks of products (or services), which are present in your catalogue in all of your product groups.
 
4. The file with the description of products (or services) and their characteristics within one group. Each product (or service) may contain up to 17 characteristics, 13 of which may be set by you arbitrary. Name of this file is taken from the column "Name of the file with data" in the Group.csv file. There should be a separate file with products and their characteristics for each of such groups. There could be a separate set of characteristics for each of such groups of products inside this file. Thus, a single catalogue may contain completely different products (or services), separated by you into an arbitrary groups, with the condition that EACH GROUP OF PRODUCTS (OR SERVICES) MAY HAVE ITS INDIVIDUAL CHARACTERISTICS.

 

Attention! In a name of the file of commodity group there shouldn't be gaps! Otherwise it will lead to emergency completion of operation of application!

5. Company.csv file. It contains information about your company, the name of your catalogue, contact information of your company (addresses, phones, e-mail addresses).

6. Accounts.csv file. It contains links to the accounts of your company in various social networks.
 
As soon as you prepare the necessary files, create a folder in the filestore on your website and copy all of these files to this folder. Now you have to just copy the link to this folder with your files (with your database for the catalogue app), download the application from AppStore to your iPad or iPhone, enter into the settings of this application the path to your database (you can simply use "copy-paste" method) and... Start using your catalogue! Send a link to this database to your clients, friends, acquaintances so that they could start using the catalogue app with your database of products and services.

 

3. Third column "File Name" - name of the file, which will contain all information about the products (or services), which are the part of this group, with all their characteristics and parameters. Please pay attention! The name of the file should be written without the point in the end and without specifying the file extension (without .csv).

 

4. The fourth column contains the text description of this group of products (or services). This description will be displayed in the application on the page of the group:

 

For more convenient editing and formatting of the group'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 Group.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 group in the application and on the page of the catalogue:
 
gallery/s4
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 "Group.csv" file is located itself.

 

After you fill all these 5 columns for all your types of product groups, you get the ready to use "Group.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/Group.csv".

 

Do you still have questions? Please contact us right here: help@unicat.online
 

How to create a Trademarks.csv file

 

The Trademarks.csv file is the table file that contains the description of all product trademarks, which are presented in your catalogue. Please pay attention! The file must contain only the descriptions of the PRODUCT TRADEMARKS. Descriptions of groups of products, collections, 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 Trademarks.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 trademarks will be in your catalogue. For each trademark you need to complete a separate line in the Trademarks.csv file. ATTENTION! This file ONE for the entire database. It must include ALL trademarks from ALL groups of projects.

 

The file consists of four 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.
 
gallery/s5
2. Second column "Trademark" - the name of the trademarks of products (or services). This name will be displayed in the application on the catalogue page as the name of the corresponding trademark of products (or services) :
 
gallery/s6
3. Third column "Description of a trademark" contains the text description of this trademark. This description will be displayed in the application on the page of the trademark:
 
gallery/s7

How to create a Group.csv file


The Group file.csv file is the table that contains the description of all groups of products, which are presented in your catalogue. Please pay attention! The file must contain only the descriptions of the GROUPS OF PRODUCTS. Descriptions of trademarks, collections, 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 Group.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.
Decide which and how many groups of products will be in your catalogue. For each group you need to complete a separate line in the Group.csv file.

 

The file consists of five columns:

 

1. First column "№ Group" - the simple sequence number of the group of products (or services), i.e. it should contain the numbers 1,2,3,4,... etc.

 

2. Second column "Group Name" - name of the group of products (or services). It can be any. For example: "Tiles and ceramic granite", "Cellphones", "Fridges" and others. This name will be displayed in the application on the page of the catalogue as the name of the corresponding group of products (or services) :

 

gallery/unicat широкий
For more convenient editing and formatting of the trademark'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 Trademarks.csv file.
 
4. Fourth column "Link" is the link to the graphic file in the JPG or PNG format, which will be displayed as an icon of the trademark in the application and on the page of the catalogue:
 
gallery/s8
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 "Trademarks.csv" file is located itself.

 

After you fill all these 4 columns for all your trademarks of all product groups, you get the ready to use Trademarks.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/Trademarks.csv".
 
Do you still have questions? Please contact us right here: help@unicat.online
 
gallery/unicat широкий

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.
 
gallery/s9
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) :

 

gallery/s11-2
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:

 

gallery/s12
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:
 
gallery/s13
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".

 

Do you still have questions? Please contact us right here: help@unicat.online

 

gallery/unicat широкий

File of a one group

 
File of a one group of products is a table file, which contains the descriptions of all products with all their characteristics, which are present in this group. ATTENTION! The file must contain only the descriptions of the PRODUCTS themselves. Descriptions of groups of products, trademarks, collections of the products are located in the other files. Name of the file with products of the group should be exactly the same, as it is specified for this group of products in the Group.csv file, "File Name" column.
In order to start filling this file for your database, please download the template, by pressing the link below:
 
Download the template of the Goods_of_group.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.
Define which and how many products will be in your catalogue, and which characteristics would they possess. For each product you need to complete a separate line in this file.
 
ATTENTION! Each group of products may possess its own characteristics, totally different from the characteristics of the products in other groups. For each group of products you need to create and fill a separate file with the list and characteristics of these products.
 
Each file of the separate groups of products consists of 30 columns:
 
1. First column "Code" is the individual unique number (code) of the product. If your product does not have such code, you should just make it up. The code may consist of any combination of letters and numbers. It is better if any product has a unique product in your whole database, i.e. it does not repeat for the products in other groups.
 
gallery/s14
2. Second 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, symbol or a single punctuation mark, the application will consider them to be different groups of products.

 

gallery/s15
3. Third 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, symbol or a single punctuation mark, the application will consider them to be different trademarks.

 

 

gallery/s16
4. Fourth column "Collection" - the name of the collection of the products. ATTENTION! The name in the "Collection" column in this file must be exactly the same as the name of this trademark in the Collections.csv file, "Collection" column. If these names will vary, for example, even by containing one extra space at the end of the word, symbol or a single punctuation mark, the application will consider them to be different collections.

 

gallery/s17
5. Fifth column "Goods" should contain the name of your product (or service). It will be displayed on the product page in the application:

 

gallery/s18
6. Sixth column "Description of goods" contains the text description of this product. This description will be displayed in the application on the page of the product:

 

gallery/s19
For more convenient editing and formatting of the product's description we recommend that you first create this description in any text editor, and then simply copy and paste it to the desired cell in the table of your file with products of this group.
 
7. Seventh column "Price" contains the price of this product.

 

gallery/s20
8. Eighth column "Currency" specified the currency of the price for the particular product.

 

gallery/s21
9. Ninth column "Unit" should specify the measurement unit, which is sold for the price, specified for the product (for example, it may be "piece", "sq.m.", "set", etc.).
gallery/s22
10... 22. Columns from 10 to 22 contain any (of your choice) characteristics of the products for this group of products. Write the name of each characteristic in the second line of the file; it will be displayed on the corresponding page of the product in the application together with its value (the value of this characteristic):

 

gallery/s23
23. Column 23 "Analogs": for each product your may specify comma separated unique codes (from the "Code" column) of the analogous goods; in this case such goods will be shown on the page of this product in the application:

 

gallery/s24
24. Column 24 "Joint products": for each product your may specify comma separated unique codes (from the "Code" column) of the joint products for the product (for example, for a cell phone it will be suitable cases and chargers); in this case such goods will be shown on the page of this product in the application:

 

gallery/s25
25... 30. In the columns from 25 to 30 you may specify links to the product photos. Column 25 will contain a link to the main photo of the product, columns from 26 to 30 - links to five additional photos. All links should be a DIRECT links to JPG or PNG files, which will be displayed as a main or as an additional product photo on the product's page in the application:

 

gallery/s26
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 file of this group of products is located itself.
 
After you fill all these 30 columns for all your products from a single group, you will have the ready to use file of this group of products. 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/
filename_of_the_group_of_products.csv".
 
If you have more than one group of products in your database, repeat the steps above for each group of products, create a separate file for each group of products.
 
Do you still have questions? Please contact us right here: help@unicat.online

 

gallery/unicat широкий

How to create a Company.csv file

 

Company.csv file is a file-table, which contains information on the company, whose products (or services) are represented in the catalogue.
In order to start filling this file for your database, please download the template, by pressing the link below:
 
Download the template of the Company.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.
 
The file consists of five columns:
 
1. "Catalogs Name" - the name of your catalogue of products (or services). It will be displayed on the "About" page in the "Name" field. You can make up any name for your catalogue.
 
gallery/s28
2. "About company" - the text about your company, which is further displayed on the "About the company" page. You can write any text about your company. For your convenience we recommend that you first enter the text in any text editor, and then copy and paste it in the appropriate cell in the table. This way you get the text, separated into paragraphs.

 

gallery/s29
3. "e-mail for order" - in this cell of the table you should specify the your e-mail, to which users of the application will send their requests (by default) right from this application, regarding whether you have a particular product (or service) available.

 

gallery/s30
4. "Contacts" - in this cell you should specify the contact information of your company. These data will be visible in the application on the "Contacts" page. Contact data can be written in an arbitrary manner. Here you can specify phones, addresses, e-mail addresses of your offices, shops, warehouses, etc. For your convenience we recommend that you first enter the text in any text editor, and then copy and paste it in the appropriate cell in the table. This way you get the text, separated into paragraphs.

 

gallery/s31
5. "Text of catalog"- the text written in this cell will be displayed in the application on the "Catalog" page. For your convenience we recommend that you first enter the text in any text editor, and then copy and paste it in the appropriate cell in the table. This way you get the text, separated into paragraphs.

 

gallery/s32
When you complete all 5 columns, you will have the ready to use file with the information about your company - Company.csv. 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/Company.csv".
 
Do you still have questions? Please contact us right here: help@unicat.online

 

gallery/unicat широкий

How to create an Accounts.csv file

 

An Accounts.csv file is a table-file, which contains links to the accounts of your company in the popular social networks.
In order to start filling this file for your database, please download the template, by pressing the link below:
 
Download the template of the Accounts.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.
 
The file consists of three columns:
 
1. First column "№" - simple sequence number of the line with an account in a social network in this table.
2. Second column "Social network name" - name (title) of the particular social network.
3. Third column "Links" - link to the page of your company is a social network.
 
There are 6 lines in the Accounts.csv file, which may contain links:
1) line number 1 in the "Links" column - link to the Facebook page
2) line number 2 in the "Links" column - link to the Twitter page
3) line number 3 in the "Links" column - link to the page in "VKontakte" (popular Russian social network)
4) line number 4 in the "Links" column - link to the Instagram page
5) line number 5 in the "Links" column - link to the Google+ page
6) line number 6 in the "Links" column - link to the page in "Odnoklassniki" (popular Russian social network)
 
Links to your pages in social networks will be displayed on the "Contacts" page and can be opened directly from the application if a user taps the corresponding button:
 
gallery/s27
Please pay attention! Links to the pages in social networks should appear in the file in this exact order. If your company does not have a page in one or several of the specified networks, just leave the cell blank.

 

Do you still have questions? Please contact us right here: help@unicat.online

 

gallery/s10