---
title: "Customer Import National Contracts"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28402820/Customer%20Import%20National%20Contracts"
format: markdown
---
# Overview

The** Customer Import National Contracts **option allows users with access to the *<span style="color: #000000">CustomerContractImportSched</span>*<span style="color: #ff0000"> </span>activity to mass import via .csv a list of Customers and assign them to National Contracts.

# <span style="color: #003366">Accessing Customer Import National Contracts</span>

<span style="color: #333333">To access Customer Import National Contracts, perform the following:</span>

Click **Frameworks **and navigate to **Inventory > Tier Pricing > Customer Import - National Contracts **from the navigation tree. 

# <span style="color: #003366">Importing Customer National Contracts</span>

<span style="color: #333333">The format of .csv file to be imported (Sample file: </span>[<span style="color: #333333">nationalCustomersTierContract.csv</span>](https://sterlandsupport.atlassian.net/wiki/download/attachments/28402820/nationalCustomersTierContract.csv?version=1&modificationDate=1731643933689&cacheVersion=1&api=v2)<span style="color: #333333">) must be in the following format: </span>

1. <span style="color: #333333">Row 1 = The Header row with the Column names</span>
2. Column A = Contract ID – XXXXXXXXXXXXXX – (Mandatory)
3. Column B = Customer Number – 999999 – (Mandatory)
4. Column C = Default – TRUE/FALSE (Mandatory)
5. Column D = Auto-select – TRUE/FALSE (Mandatory)

To import customers to national contracts from a .csv file, perform the following:

> Macro (include)

# Additional information

> ✅ Refer to [Creating a Frameworks User ID](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28386228) to add the *<span style="color: #000000">CustomerContractImportSched</span>*<span style="color: #ff0000"> </span>activity to the program Security Group for the User.