---
title: "IHG Supplier Data Import"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28404188/IHG%20Supplier%20Data%20Import"
format: markdown
---
# Overview

The** IHG Supplier Data Import **scheduled task allows you to scan the defined file **Path Name** for any files with a file extension of **.dat** or **.DAT** where the details of the supplier files will be used to **update existing supplier details** or **create a new supplier record**. 

<details>
<summary>To know more about the import .dat file, click here. </summary>

| Field | Start Position | End Position | No. of Characters | Notes |
| --- | --- | --- | --- | --- |
| **Supplier ID** | 2 | 11 | 10 | Import is matched in this **Supplier ID **or the **Buying Group**. |
| **Supplier Name** | 24 | 63 | 40 |  |
| **Shipping Address 1 (Shipping Address Name)** | 64 | 93 | 30 | - If Supplier has existing Shipping Address Name with the **{Supplier Name} – Sales** then the shipping address will be updated update.
- If the Shipping Address Name is **As for Head Office** the address will not be imported.
- If the Shipping Address Name differs to the above it will be imported as an additional address. |
| **Shipping Address 2 ** | 94 | 123 | 30 | plus positions 124 - 143 |
| **Shipping Address 3** | 144 | 146 | 3 |  |
| **Supplier Postcode** | 147 | 150 | 4 |  |
| **Supplier Phone** | 179 | 188 | 10 | Overridden by 189-200 if not blank |
| **Supplier Fax** | 201 | 210 | 10 |  |
| **Address** | 211 | 240 | 30 | plus positions 241 - 270 |
| **Suburb** | 271 | 290 | 20 |  |
| **State** | 291 | 293 | 3 |  |
| **Postcode** | 294 | 287 | 4 |  |
| **Contact Name** | 298 | 322 | 25 |  |
| **Phone Number** | 326 | 335 | 10 |  |
| **Fax Number** | 248 | 357 | 10 |  |
| **Min Order Value** | 258 | 364 | 7 |  |
| **Status** | 265 | 365 | 1 | If the Status is not 2 then a new supplier can be created. |
| **Email Address** | 366 | 621 | 256 |  |
| **Buying Group** | 878 | 881 | 4 |  |
</details>

# Importing IHG Supplier Data. 

To import IHG Supplier Data via Frameworks, perform the following:

1. Add the activity **ihgsupplierdataimportsched **as a shortcut and open the **IHG Supplier Data Import **screen.

<details>
<summary>For more information on adding a shortcut, click here.</summary>

> Macro (include)
</details>

2. On the **Import Criteria** tab update the following parameters as required:
  1. **Path Name: **Enter the file path where the .dat or .DAT files will be located. The default path is defined in [System Control File Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401568).
  2. **Create New:** If the create new checkbox is enabled a new supplier will be created if the **supplier Id** or **Buying Group Id **doesn't exist. If disable only existing suppliers will be updated and any new suppliers will NOT be added.
3. Go to the **Schedule** tab and set the required import schedule parameters (eg once only, daily, weekly).
4. Click **Submit** to run the scheduled task. Once complete the **Output** tab will display a .csv file with a summary of the Supplier Data Imported including any that failed to import.

![image]()

> ✅ Refer to [Scheduled Task - Scheduling and Output](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402256) for more information.

# Additional Information

> ✅ Refer to [System Control File Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401568) for more information about setting the default import path.