How to Import Specific Catalogues

All countries

In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System > Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:

Import Suppliers

Before performing the steps detailed below, ensure that this part of your build is set up correctly. The relevant steps to set up the features and workflows detailed in this article can be found here:

How to Use the Catalogue

Before you import a supplier-specific catalogue, you need to import suppliers or create them individually. Learn more in How to Import Suppliers and How to Create Suppliers.

Types of imports

There are three types of imports you can perform with a supplier-specific 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	This import compares the part numbers of items in the import file with those in the existing simPRO catalogue. If a part number in the import file is not found in the simPRO catalogue, a new item entry is created within the group 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 need 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.

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 can import minimum stock levels, restock levels and storage locations for existing catalogue items and update these details in bulk. Learn more in How to Import Storage Locations and Stock Levels.

Perform an initial import

When performing an initial import of a supplier-specific catalogue, it is recommended to import the catalogue of your primary supplier, or alternatively, a major supplier with a well-structured catalogue.

Some suppliers support automatic catalogue syncing. Learn more in How to Use Automatic Catalogue Syncing - AU and NZ Only.

To perform an initial import of a supplier-specific catalogue:

1. Go to Utilities > Import.
2. Click Catalogue and then select the supplier whose catalogue you need to import.
3. Select Set as Default Supplier if required.
4. Under Import Options, click Complete.
5. Click Browse.
6. Find and click the supplied file, then click Open.
7. Under Attached File, a icon indicates the file has uploaded successfully. Verify the name and size of the file.
8. Click Next.

When the catalogue has finished importing, an Import Catalogue Summary shows the number of Line Items Loaded, Catalogue Items Created and Catalogue Items Updated.

It is recommended that you check the catalogue to ensure the import has been successful prior to importing additional supplier catalogues.

Update the catalogue

Update your existing catalogue to import additional items from any supplier, update items with additional supplier part numbers and prices, or simply update trade prices.

To update the catalogue:

1. Go to Utilities > Import.
2. Click Catalogue and select the supplier whose catalogue you need to import.
3. Select Update Trade Prices if required when updating the catalogue for your default supplier.
4. Under Import Options:
   • Click Update Only to update existing items with supplier part numbers and prices.
   • Click Update and Create New Part to update existing items with supplier part numbers and prices, and to add additional items.
5. Click Browse.
6. Find and click the supplied file, then click Open.
7. Under Attached File, a icon indicates the file has uploaded successfully. Verify that the correct file has been loaded.
8. Click Next.

When the catalogue has finished importing, an Import Catalogue Summary shows the number of Line Items Loaded, Catalogue Items Created and Catalogue Items Updated.

Download and import a simPRO-formatted price file from the following suppliers. These suppliers also support automatic importing. Learn more in How to Use Automatic Catalogue Syncing - AU and NZ Only.

• Cetnaj
  • Only available with certain branches. Contact your local branch for information.
• CNW
• Electrical Distributors
• Go Electrical
• Ideal Electrical
• John R Turks
• Lawrence & Hanson
• Lear & Smith
• Middy’s
  • The Middy's import is currently in a closed BETA. Middy's will contact all customers when they are ready to go live.
• MMEM
• P&R Electrical
• Reece
• Rexel
• Samios
• Sherriff
• Tradelink

Download and import a simPRO-formatted price file from the following suppliers:

• Cooks Plumbing
• Espro
• Flamestop
• NHP
• Sparky Direct
• TradeZone

Download and import a simPRO-formatted price file from the following suppliers. These suppliers also support automatic importing. Learn more in How to Use Automatic Catalogue Syncing - AU and NZ Only:

• Active Electrical
• Corys
• J. A. Russell
• Ideal Electrical
• IES
• Mico
• Telfers

Download and import a simPRO-formatted price file from the following suppliers:

• Advance Electrical
• Cetnaj
• Chesters
• Franklins Group
• MasterTrade
• PlaceMakers
• Plumbing World
• Redpaths
• Reece
• Voltex

Download and import a simPRO-formatted price file from the following suppliers:

• Yesss Electrical
• Plumbase
• Rexel
• City Electrical Factors

Espro

If you wish to import from Espro, a database of electrical contracting pre-builds, you can import a sample of 200 items. To import the full database, you need to purchase it from Spearhead, then provide proof of purchase to simPRO Support, and simPRO loads the database to your system.

Import your other supplier catalogues before Espro, so that the Espro import will create pre-builds out of existing catalogue items instead of creating new items. If you have imported Espro first, when importing your other supplier catalogues make sure to select Update and Create New Part. Then, if simPRO detects any items in the new import that matches the part number of an Espro part, the part is not duplicated.

Reece

To import a Reece price file specifically formatted for simPRO, you can register or log in to your Reece trade account, specify the type of products you wish to include in the file, and generate the file in a Standard plus categories layout.

To generate a Reece price file:

1. Log in to your online Reece trade account on the Reece website using your Email Address and Password.
2. In My Projects > Products & Pricing, click Download My Price File.
3. Under Price File Settings, select the File Format.
4. Under File Layout, select Standard plus categories.
   • If you do not select this option, the simPRO import fails.
5. Under Products in List, select one of the following options:
   • Minimal Products to generate a price file containing the products you have purchased within the last 12 months.
   • Typical Products to generate a price file containing the products you have purchased within the last 12 months in addition to Reece's most popular products. This contains approximately 3,000 products.
   • Complete Products to generate a price file containing all Reece products in the system. This contains approximately 25,000 products and takes approximately an hour to generate.
6. Under Email Notification Settings, select whether you wish to receive an email notification when your price file is updated and ready to download each month.
7. Under My Price File, select the email address you wish to have the generated price file sent to.
   • Alternatively, enter and select an Additional Email Address.
8. Click Generate.

The length of time it takes for Reece to generate the file and email it to the defined email address depend on the selected Products in List option.

When you receive the price file, you can then import a supplier-specific catalogue as normal. Learn more in Import a supplier-specific catalogue.

If you do not select Standard plus categories in Price File Settings > File Layout, the simPRO import fails.