---
title: "Import Commercial Files"
canonical: "https://kb.myframeworks.com.au/space/CO/30508942/Import%20Commercial%20Files"
format: markdown
---
Import Commercial files containing product information, usage codes, comments, quantities, and prices into sales orders or quotes. This import format is specific to Brett's operations.

> 📝 ## Prerequisites
> 📝 
> 📝 Before importing a Commercial file:
> 📝 
> 📝 - Customer account must exist in Frameworks system
> 📝 - Commercial file must be in Excel format with required column structure
> 📝 - User must have permission to create sales orders
> 📝 - Product codes in the file should match Frameworks product codes

## File Format Requirements

The Commercial import file must be an Excel spreadsheet with columns configured as follows:

- Column A = Customer Account Number
- Column B = Usage Codes
- Column C = Product ID
- Column D = Product Description
- Column E = Comments
- Column F = Quantity
- Column G = Cost Price
- Column H = Unit Sell Price
- Column I = Customer Order Number (line 1 only)

**Important format notes:**

- There is no header row explaining the columns within the file
- If Cost Price is 0, the import uses the system cost
- If Cost Price contains a value, that cost is imported as specified in the file
- Products are imported in the exact sequence from the Excel file (row 1, then row 2, then row 3, etc.)

---

## Import Commercial File

1. From the **Frameworks Menu**, navigate to **Sales > Transaction Processing > Sales Orders**.
2. Click **New** to create a new sales order or search for an existing order using the **Find** button.
3. In the **Cust No.** field, enter the customer number or click the **search** icon to find the customer.
4. Click **Actions**, select **File Imports**, then **Commercial File**.
5. Click **Choose File**, navigate to the Commercial file on your computer, and click **Open**.
6. Click **Upload** to import the file.
7. When the **Import Status** window displays, review the import results and click **Close**.

## Result

The **Import Status** window displays:

- Number of product lines successfully imported
- Number of unresolved import lines requiring attention

Commercial product codes that match existing Frameworks products are added to the order automatically. Product codes that don't match display in the **Resolve Product Mapping** window and require resolution before the order can be processed.

If unresolved import lines exist, the **Resolve Import **icon appears next to the **Actions** button to open the **Resolve Product Mapping** window.

> ✅ ## Related Tasks
> ✅ 
> ✅ - <u>[Create a Sales Order](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30529072)</u> - How to create new sales orders
> ✅ - <u>[Find an Open Sales Order or Quote](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30520258)</u> - How to search for existing orders
> ✅ - <u>[Resolve Import Issues in Sales Orders](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/459079694)</u> - How to resolve unmatched product codes

## Related Information

<details>
<summary>System Settings</summary>

The following system flags control Commercial file import behaviour:

**SOPUsageBr** - Format 20 Quotes sort and break by Usage

- Controls whether quotes are sorted and broken by usage codes

**SOPUsageSBr** - Quotes sort by usage sequence number

- Controls whether quotes are sorted by usage sequence number

**SopUsgePrt** - Print usage heading on quotes & picking slip

- Controls whether usage headers print on quotes and picking slips

> ✅ [Sales Order Related System Settings](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28381092) - Configure usage code behaviour
</details>