Via a generic spreadsheet


Download the list of products

Before you adapt any products, we recommend first downloading the full product list via the action 'Download the list of products' (Stock => Actions => Download the list of products).

You can then choose which list to export, with the following options:

  • Depot-specific, or all products that are active across all depots
  • Ignore inactive products (optional)

Then click 'Download'. The generated file becomes available and can later be used to re-upload the products via the function 'Adapt products via spreadsheet with specific header'.


Adapt products via spreadsheet with specific header

With a 'generic' spreadsheet (the example UpdateRekenbladvoorbeeld.xlsx in attachment) or with the file you obtained via 'Download the list of products', you can adapt a list of products. It is important to use the correct column headers. The order of the columns does not matter. Both .xls and .xlsx are accepted. The following column headers are recognised, and the column ID is a mandatory field (it is needed to find the correct product):

  • ID (mandatory)
  • name
  • type (possible values: TDrug, TAnimalFood, TAnimalFoodSupplement, TCareProduct, TMaterial, TMaterialConsumption, TProductConsumption, TAccessory, TSperm, TOther (=default))
  • label
  • cnk
  • grossPriceExclVat
  • publicPrice
  • vatPercentage (if the VAT rate is not specified, the high rate is assumed)
  • priceDetermination (possible values: TFixedPrice, TGainPurchasePrice, TGainGrossPrice, TPublicPrice)
  • gain (integer)
  • outgoingUnit
  • nbrOfOutgoingUnitsPerProduct (integer) (cannot be changed once the product is locked)
  • fixedUnitPrice
  • surchargeProvided (surcharge when the product is supplied/dispensed, in euro, excl. VAT)
  • surchargeAdministered (surcharge when the product is administered, in euro, excl. VAT)
  • GroupPriceCategory
  • GroupId
  • Compliance

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


Manual method

To adapt a product manually, go to the Stock tab. Search for the product and then select the 'edit' icon.

A new screen appears showing all the data already entered for the product. Here you can adapt various product details. Some specifications cannot be changed once the product is locked (the number of outgoing units, the outgoing unit). The name, the CNK code and the price determination are required and cannot be left empty.

  • Name - The name of the product, optionally in several languages. For automatic ordering and reading in of deliveries it is important not to change this name. One exception is allowed: you may precede the name with a prefix separated from the original name by an '_'. This lets you call up products with your own shortcuts.
  • Label - A free field that lets you divide products into categories at your discretion. In the Outgoing register report you can search on this label (it does not have to be the full label), which allows a hierarchical classification (e.g. searching 'A3' returns A3, A3A and A3B).
  • CNK code - The CNK code of the product.
  • EAN code - The European Article Number found under the barcode; a unique characteristic of a product (not of a lot). Codes can be added via the action 'Add EAN code'. Once added, you can also dispense products by scanning the code.
  • Depot - If you work with several depots, you can make the product definition depot-specific (different pricing, min/max stock, etc. per depot). Leave empty if you do not want different settings per depot.
  • Outgoing unit - The unit in which this product is used. Units are defined under Settings => Practice data => Stock, or select 'New' in the list.
  • Minimum/maximum stock (outgoing units) - The minimum stock triggers a low-stock warning; the maximum stock is used when reordering. Expressed in outgoing units.
  • Ignore deliveries - If ticked, Fuga will not read in deliveries of this product.
  • Supplied by default - Indicates whether the product is primarily intended for sale or for administration; used as the default in the consultation when adding 'Outgoing products'.
  • Loyalty card / Show in shop / Use purchase price of previous lot / Order on behalf of the client
  • Financial
    • Purchase VAT rate - The VAT rate applicable to the product at purchase. If the wholesaler's VAT rate does not match the one in Fuga, you get an error message. It is best to leave this unchanged.
    • Price determination - Select how the price is determined.
    • Price deviation provided (%) - A price deviation when supplying the product; can be positive or negative.
    • Price deviation administration (%) - A price deviation when administering the product; can be positive or negative.
    • Surcharge administered (euro) - Adds a fixed amount when a product is administered via 'Products' in the consultation, independent of the administered quantity. Spread proportionally over the lots used. For products used via a protocol you can choose whether or not the surcharge is applied. 'Bulk discount' and 'Price deviation administration' do not affect this surcharge; the client-level 'Services reduction' does apply.
    • Surcharge provided (euro) - Adds a fixed amount when a product is supplied/dispensed.
    • Bulk discount - Lets you define five levels of bulk discount per product (from how many outgoing units the discount applies and which percentage). Note: quantities added separately are not summed for a higher bulk discount.
  • Type