When setting up a .CSV file as a price list for Handyman Office you have to adhere to our specific template.
The necessary columns in order
The column titles are not important, it is the order that matters. The first line is skipped during import.
|Item number (Varenummer)
|The primary number of the article
|Must be unique within one Supplier
|Item number 2 (Varenr2)
|Optional secondary item number
|Does not have to be unique within supplier
|Item group (Varegruppe)
|Reference to group for the item
|The item group structure must exist for this field to have an effect. This must be imported separately (See separate article)
|Max 110 characters
|Max 10 characters
|Ordering unit (Package size)
|Smallest quantity in one package
|Used when sending purchase orders to supplier
|Sales Price (Price)
|Decimal point should follow local standards.
|Net Price (Net price)
|List Price (List price)
The column for item groups (Varegruppe) can only link to existing groups in the database and can not be used to create new groups when importing the pricelist.
Use a spreadsheet program like Microsoft Excel to set up the list with all the values you need and then choose save as a .CSV file.
To import the file you can follow the normal steps for clearing out old entries for the supplier from our import guide.
When importing price list in this way, the price calculation options in the Price List Import app will have no effect. Final prices must be set in the CSV file. This will be changed in a later Handyman version.
When you open the explorer window to locate the file it will automatically be set to look for .TXT files.
Use the drop-down menu in the bottom right to change the file type to .CSV.
Once the file has been added you can continue with the normal procedure form the ‘Pricelist’ section where you update the prices and choose what type of mark-up to use.
When sending CSV files via email they should be wrapped in a container like .ZIP, or similar, to preserve the character set formatting.