How to Import Generic Supplier Catalogues

Overview

Import a list of your catalogue items into simPRO in a generic format.

You can also import supplier-specific catalogues that have been especially formatted for simPRO. Contact your local branch or log in to a supplier's website to see if they have a supplier-specific catalogue.

You can exclusively update your catalogue item custom fields for all catalogue items regardless of the supplier and without updating any other catalogue data. Learn more in How to Import Custom Fields to Catalogue Items.

There are three types of imports you can perform with a generic catalogue:

Complete

By default, this imports all groups, subgroups and items defined in the import file. Items that currently exist in your simPRO catalogue that are in different groups or subgroups may be duplicated.

Best selected when performing an initial import.

If you map groups during this import, items are updated within any matching groups in simPRO.

Update and Create New Part

Compares the part numbers of items in the import file with those in the existing catalogue. If a part number in the import file is not found in the simPRO catalogue, a new item is created within the group and subgroup defined in the import file.

If the group and subgroup defined in the import file does not exist in the simPRO catalogue, the import creates this along with any new items.

If you are updating your catalogue with your default supplier, trade prices are also updated. This option is useful if you wish to build up your catalogue to include all products from additional suppliers.

Update Only Compares the part numbers of items from the price file with those in the existing catalogue but ignores additional items in the new price file. If you are updating your catalogue with your default supplier, trade prices are also updated.
Custom Fields Only Exclusively update your catalogue item custom fields for all catalogue items regardless of the supplier and without updating any other catalogue data.

If you are updating your catalogue using the Update and Create New Part or Update Only options and matching part numbers are found between the catalogue and the new price file, the import merges those items into one catalogue item with multiple suppliers. This is useful for comparing prices between different suppliers when raising a purchase order.

You may wish to test the import process with one or two catalogue items before importing an entire file.

US only: If you use simPRO in the United States, the term 'vendor' is used instead of 'supplier'.