The CSV format is a universal, cross-platform structure for storing tabular data.
When manually editing and viewing data, the tabular representation of data is more visual and convenient compared to xml.
CSV files can be opened and created by spreadsheet editors such as Microsoft Excel, Google Sheets, and others.
If you don't have any programmers, you can create tables with prices yourself in any spreadsheet editor, save them in csv format and upload them to our system.
Basically, csv is a text format with predefined separating characters and structure, in our case:
- to separate data from each other, we use the comma “,” or semicolon ”;”
- to separate the fractional part of the number from the main part, use a period “.” (do not use a comma for fractional values!)
- the beginning of a new table with prices is considered to be the service string “id_collection/id_template” in the first column - it is not variable and is not translated. In this line, we also indicate in the second column the collection ID (in the scheme “xxx”), in the third column the template ID (in the scheme “yyy”)
- the node of the table itself is the service string “Height/Width” in the first column - below it will be the numerical values of heights with the desired step, to the right - the values of widths with the desired step. The step in height and width is independent of each other and is determined at arbitrary intervals at your discretion
- at the intersection of the height and width values - indicate the cost at such dimensions, if it is impossible to manufacture the structure with such a ratio of width and height - leave an empty cell
- the table for different templates may differ in ranges and number of steps
Please note:
The system will understand the price values of your price grid as entered in the currency of your company (defined in your company settings). Values in other currencies will be recalculated according to the exchange rates you set in the “Pricing” settings
Downloadable file example here