VetAIS support import existing pricelist in CSV format.
\nExisting Excel file can be easily transfered from Excel compatible format but need to including these columns.<\/p>\n
itemname —\u00a0<\/em>mandatory field including name of item withour quotes like » or ‘ Before import please store your Excel file into text CSV format in UTF-8 codepage. We recommended to use LibreOffice or OpenOffice to store into CSV.<\/p>\n During import default settings will be used for VAT and unit. Units in CVS will be automatically created in VetAIS.<\/p>\n Important notes:<\/strong>
\nunit\u00a0<\/em>— mandatory field, for example piece<\/em>, mililiter<\/em> etd.
\nprice —\u00a0<\/em>mandatory field including just number without<\/strong> currency! currency is selected in VetAIS before import
\nmrm_producer —\u00a0<\/em>not mandatory field, you can leave it empty
\nmrm_code —\u00a0<\/em>not mandatory field, you can leave it empty
\nitemcode —\u00a0<\/em>not mandatory field, you can leave it empty or you can use any string as code
\neancode —\u00a0<\/em>not mandatory field, you can leave it empty or use simple number as EAN code
\ndescription —\u00a0<\/em>not mandatory field, you can leave it empty<\/p>\n
\n— field delimiter should be semicollon ;
\n— do not use any quotes like » or .
\n— decimal divider in number should be dot .
\n— for each item have to be just one price
\n— price have to be number! formats like «up — to» for example «100 — 300» is not allowed or expession like «from XY»
\n— price as thousands can\u00b4t be divided by special character, for example «2 250» is not allowed
\n— please keep in mind that most changes you can do by selecting all rows in price column in LibreOffice\/OpenOffice and change cell format or cell type
\n— first line need to specified all fields, no matter is some are empty or not, for example: «itemname;unit;price;mrm_producer;mrm_code;itemcode;eancode;description»
\n— order of fields is not mandatory
\n— if error occured please see log file or error message<\/p>\n