Product Data Import

In Mamut Business Software you can import products and update prices on existing products by using the import of product data function. You can import product and price lists from your suppliers or create your own lists in Microsoft excel that you import. Import of products will be time saving compared to entering all the products manually into the product register.

Before you start

Always perform backup before importing data. If importing does not go according to plan, you can easily back copy the backup to the starting point you were before you imported the data.

Create a Warehouse

All products you wish to import must have a Warehouse assigned. If the Warehouse does not exist, you have to create one.

  1. Go to View - Warehouse - Warehouse.
  2. Click on the button Warehouse Register.
  3. Click New.

More information: The Warehouse Register

Product in multiple locations

If you wish to store product on multiple locations in the same warehouse or in multiple warehouses, go to View - Settings - Company - Settings per Modul - Product and select the field The company stores the same product in several places within the same warehouse.

More information: Company Settings for Product

Suppliers and product numbers

All imports must be associated to a supplier. Updating of prices is done towards the suppliers product number. When the import is coordinating the product from the import file towards products already existing in Mamut Business Software, the search is done with the suppliers product number as key.

If you have an import file that contains the suppliers product number, but that number is not entered in the Mamut-database, it is best to use the additional feature Import/Export that has more specific formats for importing.

Import

Remember that the file you are importing must be closed, if not it will not import.

To import product data click New and create a new import routine. In Import settings you define how the file is created, what will be updated and rules for new products.

When you have selected import settings, you click Start Import to begin reading products/prices in the file you selected to import. An overview of Import read products will be displayed for you to import.

Refer to the Mamut Support page at www.mamut.ie/tutorials to access this information in the form of an online tutorial. Mamut's tutorials provide you and your colleagues with short videos of Frequently Asked Questions (FAQs) free of charge. These videos include short and easy-to-follow instructions demonstrating different processes within the system.

Read more about:

Settings for the Import of Product Data

Import Read

Backup