It is possible to import products into MICE via an Excel file, and you can export your products from MICE to an Excel file.
Please contact us first if you are planning to make any significant changes.
Product import
You can use an Excel file to import products to the product setup. To do this, you should use the columns mentioned below. Add one line per product (split VAT can be added manually at a later stage).
Please note: Importing products is error-prone! An incorrect setting can quickly lead to duplicate or incorrect products in your system, which can cause undesirable situations.
This function has been specially developed to import new products into your system. The function has not been developed to make changes to existing products.
Data to be imported:
ID number
Product code
Product name
Product category
Price
VAT percentage
Amount per item
General ledger number
Cost price (MICE Pro)
Unit
Price
Amount per item
Short description
Long description
Units explanation:
* Units:
'' => 'None'
'pcs' => 'Piece'
'g' => 'Gram'
'kg' => 'Kilogram'
'l' => 'Liter'
'h' => 'Hour'
'day' => 'Day'
'crate' => 'Crate'
Product import sheet
You can use this Excel sheet (click here) te import new products in MICE. Please make sure that you do not change the column values.
Exporting products
It is possible to export your products from MICE to an Excel file.
Go to “Setup” in the main menu and then to “Products” in the setup menu. Next, click on “More” at the top of the screen and select “Export”.
Please note: The export function is not designed to export existing products, make changes and then re-import them.
The Excel file contains product information, divided into the following columns:
Identification number
Product code
Name
Category
Price excl. VAT
Price incl. VAT
VAT rate
Ledger number
Cost price
Amount per item
Short description
Long description