How to Import Specific Catalogues

Overview

Upload supplier catalogues and price files that have been specifically formatted for your simPRO system.

Catalogues are usually contained in a CSV or ZIP file. To obtain these files, you need to contact suppliers directly at your local branch or log in to their website. If the supplier is not aware of the simPRO format required they should contact their internal IT department for support.

There are three types of imports you can perform with a supplier-specific catalogue:

Complete

Imports all items from the price file as arranged in the groups and subgroups defined in the file. Select when performing an initial import.

Update and Create New Part

Compares the part numbers of items from the price file with those in the existing catalogue. If a part number in the new price file is not found in the catalogue, a new item entry will be created in the catalogue in a group and subgroup defined by the new price file.

If you are updating your catalogue with your default supplier, trade prices will also be 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 will also be 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 will merge those items into one catalogue item with multiple suppliers. This is useful for comparing prices between different suppliers when raising a purchase order.

If you are unable to obtain a simPRO formatted price file from your supplier, you may wish to import the supplier catalogue as a generic price file or manually enter your most commonly used catalogue items.

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

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.

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 will load the database to your system.

Middy's

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:

Log in to your online Reece trade account on the Reece website using your Email Address and Password.

In My Projects > Products & Pricing, click Download My Price File.

Under Price File Settings, select the File Format.

Under File Layout, select Standard plus categories.

If you do not select this option, the simPRO import will fail.

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 will contain approximately 3,000 products.

Complete Products to generate a price file containing all Reece products in the system. This will contain approximately 25,000 products and takes approximately an hour to generate.

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.

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.

Click Generate.

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

Set up automatic syncing for your Lawrence & Hanson catalogue to perform an initial catalogue import, and then automatically update parts and pricing when Lawrence & Hanson updates their price files.

To use automatic syncing, you will need to have an online Lawrence & Hanson account. If you have already manually imported a Lawrence & Hanson catalogue, you can use automatic syncing to manage future updates.

The Update and Create New Part import option is useful for both your initial import and automatic updates. This import option allows all new parts to be created the first time the sync is performed. For future automatic updates, only new parts will be created with existing parts updated.

Click Update. The catalogue will be updated within an hour.

Your simPRO system will then check for a new Lawrence & Hanson price file every seven days and will update in the system regardless of whether the price file has changed.

To disable automatic syncing, click Deactivate.

To view a history of activity from the automated import, click the Automated Import Log tab.

Set up automatic syncing for your MMEM catalogue to perform an initial catalogue import, and then automatically update parts and pricing when MMEM updates their price files.

To use automatic syncing you need to have an online MMEM account. If you have already manually imported an MMEM catalogue, you can use automatic syncing to manage future updates.

To enable automatic syncing for the MMEM catalogue:

Go to Utilities > Import.

In the left column, hover over Catalogue, then select MMEM.

Enter your MMEM Username and Password.

Click Validate.

Adjust import settings as normal.

If you wish to have different import settings for future updates, return to Utilities > Import > Catalogue > MMEM > Import Options, select options as required, then click Update.

The Update and Create New Part import option is useful for both your initial import and automatic updates. This import option allows all new parts to be created the first time the sync is performed. For future automatic updates, only new parts will be created with existing parts updated.

Click Update.

Your simPRO system will then check for a new MMEM price file every seven days and will update in the system regardless of whether the price file has changed. To disable automatic syncing, click Deactivate.

Do you have an invalid MMEM username or password?

If you have an invalid MMEM username or password, a Catalogue Automated Import Error message will appear. Go to the MMEM website to reset your password, or alternatively, contact your local MMEM to rectify the issue if required.

Set up automatic syncing for your Corys Electrical catalogue to perform an initial catalogue import, and then automatically update parts and pricing when Corys Electrical updates their price files.

To use automatic syncing, you need to have an online Corys Electrical account. If you have already manually imported a Corys Electrical catalogue, you can use automatic syncing to manage future updates.

To enable automatic syncing for the Corys Electrical catalogue:

Go to Utilities > Import > Catalogue > Corys.

Enter your Corys Username, Password and Account No.

Click Validate.

Adjust import settings as normal.

If you wish to have different import settings for future updates, return to Utilities > Import > Catalogue > Corys > Import Options, select options as required, then click Update.

Click Update. The catalogue will be updated within an hour.

Your simPRO system will then check for a new Corys Electrical price file every seven days and will update in the system regardless of whether the price file has changed. To disable automatic syncing, click Deactivate.

To view a history of activity from the automated import, go to Automated Import Log.

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:

Log in to your online Reece trade account on the Reece website using your Email Address and Password.

In My Projects > Products & Pricing, click Download My Price File.

Under Price File Settings, select the File Format.

Under File Layout, select Standard plus categories.

If you do not select this option, the simPRO import will fail.

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 will contain approximately 3,000 products.

Complete Products to generate a price file containing all Reece products in the system. This will contain approximately 25,000 products and takes approximately an hour to generate.

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.

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.

Click Generate.

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