Automatic way


If you import a delivery document (see below) and no matching product description exists yet, it will be added automatically and will appear in the Underspecified products report.


In addition, using the action Import product from wholesaler catalogue you can import a product from a wholesaler's catalogue. This immediately gives you the correct spelling. The available data (CNK code, VAT, prices, etc.) is copied over as much as possible.


You fill in the rest of the product file manually, as described below.


Via a generic spreadsheet

You can import product lists using a 'generic' spreadsheet (ImportRekenbladvoorbeeld.xlsx attached). It is important that you use the correct column headings. The order of the columns does not matter. The .xls and .xlsx formats are accepted. The following column headings are recognised:

  • name (required)
  • nameDutch
  • nameFrench
  • nameEnglish
  • type (possible values: TDrug, TAnimalFood,TAnimalFoodSupplement, TCareProduct, TMaterial, TMaterialConsumption, TProductConsumption, TAccessory, TSperm, TOther (=default))
  • label
  • ComplianceLevel
  • cnk (max 10 characters A-Z & 0-9)
  • grossPriceExclVat
  • publicPrice
  • Description
  • vatPercentage (required)
  • priceDetermination (possible values: TFixedPrice, TGainPurchasePrice,TGainGrossPrice, TPublicPrice)
  • gain (whole number)
  • outgoingUnit
  • nbrOfOutgoingUnitsPerProduct (whole number)
  • fixedUnitPrice
  • GroupPriceCategory
  • Ean
  • active (true or false)
  • locked (true or false)
  • defaultAsProvided (true or false)

Additional information about the columns and their content:

id = taken over from Fuga at the moment Fuga already knows this product; only relevant when you edit products using an Excel file, not when you add products using an Excel file. Do not change this!

name = name as in Fuga (i.e. the name as you receive the product from the supplier). Do not change this!

outgoingUnit = the smallest outgoing unit you want to be able to work with. Bear in mind that you cannot work with decimal numbers in Fuga! So if it is an injectable and you want to be able to work to hundredths of accuracy, you must choose an outgoing unit of 0.01 ml.

nbrOfOutgoingUnitsPerProduct = the number of outgoing units in the complete product. Whole number. If, for example, you have an 80 ml bottle and your outgoing unit is 0.01 ml, then the number of outgoing units per product is 8000.

label = label, free to fill in, can be used for analyses / price increases. Optional field. Examples of how you can label:

- let everything for companion animals begin with a G, for farm animals with an L, etc.

- label specifically per type (e.g. eye)

- combinations are possible (e.g. Lreproduction, Gortho), or similar

grossPriceExclVat = gross price excl. VAT

vatPercentage = purchase VAT percentage (if not filled in, high VAT is assumed). When a product is administered it is always sold at high VAT; when the product is dispensed (provided) it is sold at the purchase VAT percentage.

priceDetermination = price setting. Possible values: TFixedPrice (= fixed price), TGainPurchasePrice (= profit margin on purchase price), TGainGrossPrice (= profit margin on gross price)

gain = profit margin (%, whole number, may also be >100)

FixedUnitPrice = fixed price per outgoing unit (only to be filled in when TFixedPrice has been chosen). When you choose this, you therefore fill in nothing under 'gain'.

type = product type, possible values: TDrug (= medicine), TAnimalFood (= animal food), TAnimalFoodSupplement (= animal food supplement), TCareProduct (= care product), TMaterial (= material), TMaterialConsumption (= material (general use)), TProductConsumption (= product (general use)), TAccessory (= accessory), TSperm (= sperm), TOther (= other)


* Unit price as administered, unit price as provided and full price as provided are calculated values that are only correct when a price setting based on TGainGrossPrice has been chosen. You do not need to fill anything in here! These values are also not carried over to Fuga but serve to let you see at a glance what the price will be. Do bear in mind that in a product file you may also add surcharges when the product is administered (e.g. injection cost) / provided (e.g. pharmacist cost); these are not included here.


It is important that you only use text fields (formulas or calculations are not allowed)

Manual way


To create a new product manually you must be in the Stock tab. Under the actions you can then Add a product. It is also possible to create a new product from a product overview by clicking the 'Add' icon ().



A new screen appears. In this screen you must fill in various details relating to the product. Not all specifications are necessary for a product. The name, the CNK code, the outgoing unit, the number of outgoing units per product and the price setting are, however, required details before you can use the product in Fuga.

  • Name - Here you enter the name of the product, optionally in several languages. For automatic ordering and importing of deliveries it is important that you do not change this name. There is one exception allowed here: you can precede the name with a prefix separated by an '_' from the original name. This allows you to call up products using your own shortcuts.
  • Label - This field is free to fill in and allows you to divide products into categories as you see fit. In the Outgoing register report you can search on this label, where it need not be the full label. This mechanism therefore allows you to divide products according to a hierarchy. An example to clarify: suppose you have to make an outgoing register for different types of antibiotics, then you could give the different antibiotic types a different label, e.g. A1, A2, A3 and A4. If antibiotic type A3 could be further subdivided into two subtypes, you could label those A3A and A3B for example. If in such a case you search the outgoing register on the label 'A', you get all antibiotics. If, however, you search on 'A2' you get all antibiotics of type 'A2' and if you search on 'A3' you get all antibiotics of type 'A3' (including those with label 'A3A' and 'A3B'). Finally, if you search on 'A3B', you get only the antibiotics whose label begins with 'A3B'.
  • CNK code - Here you enter the CNK code of the product.
  • EAN code - The EAN code is a European Article Number. The string of digits appears under the barcode on a product and is a unique characteristic of a product (not of a batch!). We have compiled a database with the EAN codes of a great many veterinary products. You can add these codes to your existing product files using the action Complete EAN code. For newly added products the EAN code is completed automatically if it is known to Fuga. Once the EAN code has been added to the product file you can also dispense products by scanning the code. Fuga will then take the batch of this product that expires first, or if there is no expiry date the oldest batch.
  • Depot - If you work with several depots, you can make the product definition depot-specific, which means you can enter a different price setting, different minimum and maximum stock values, etc. per depot. If you do not want different settings per depot, you leave this field empty. See here for more information.
  • Outgoing unit - This is the unit in which this product is used. These units can be defined under Settings => Practice data => Stock or you can select 'New' in the list. A pop-up opens with which you can add a new unit.
  • Number of outgoing units per product - Fill in here the number of units available per product. It is important for the price calculation that this field is filled in correctly. Example: for a product the 'outgoing unit' is 0.1 ml. Per bottle (product batch) 10 ml is available. Then the 'number of outgoing units per product' will be 100 (100 * 0.1 ml = 10 ml).
  • Minimum/maximum stock (outgoing units) - This minimum stock is needed to get a warning when the stock is too low. This number is expressed in 'Outgoing units'. The 'Maximum stock' is in addition used when reordering. By default the difference between the maximum and the current stock will be filled in. Example: for a product the 'outgoing unit' is 0.1 ml. Per bottle (product batch) 10 ml is available. Suppose you want to have at least two bottles in stock and at most ten bottles, then for 'minimum stock' you will specify 200 (10 ml per bottle / 0.1 ml * 2 bottles = 200 ml) and for 'maximum stock' 1000 (10 ml per bottle / 0.1 ml * 10 bottles = 1000 ml). See here for more information.
  • Ignore deliveries - If you tick this, Fuga will not import the deliveries of this product.
  • Default as provided - Indicates whether this product is primarily intended for sale or for administration. Based on this setting, the consultation file will by default indicate whether the product is for sale when adding 'Outgoing products'.
  • Client card
  • Show in shop
  • Use purchase price of previous batch
  • Order on behalf of client
  • AB Register - Here you can enter the number of outgoing units per AB Register unit.
  • Financial
    • Purchase VAT rate - Here you can enter the VAT rate that applies to the product at purchase. If the VAT rate of the wholesaler does not match the one in Fuga, you get an error message (click here for more information). Note: it is best to leave this price unchanged.
    • Product price setting - Select how the price is determined. Read more about it here .
    • Antibiotics tax
    • Price deviation provided (%) - Select a price deviation on the sale of provided products. That price deviation can, incidentally, be either positive or negative.
    • Price deviation administration (%) - Select a price deviation on administration. That price deviation can, incidentally, be either positive or negative. 
    • Administration surcharge (euro) - This function has the effect that a fixed amount is added when a product is administered via 'Products' in the consultation. This happens independently of the administered quantity. If the administration uses several batches, the surcharge will be distributed proportionally over these batches. For products administered via a protocol you can choose whether or not the surcharge is charged. 'Bulk discount' or 'Price deviation administration' have no influence on this surcharge. The 'Reduction on services' at client level is, however, applied to this surcharge.
    • Bulk discount - Allows you to set five levels of bulk discount for a product: for this you indicate from how many outgoing units the discount must be applied and what percentage must be used. Note: if the same product is added several times, these quantities are not added together for a higher bulk discount.
  • Type