This feature is only available for subscribers. Subscriptions start from as little as 9.99.

Note: Currency and terminology may differ depending on your region.

FramR offers automatic catalogue updates for a number regions.

However, you can import your own or other supplier catalogues into FramR.

Catalogues can be imported to a Supplier you added.

To import the catalogues, go to Stock/Suppliers/[your supplier] and click on Import [catalogue type].

There's a few simple guidelines to follow to ensure your catalogue imports correctly.

Your catalogue data needs to be in a CSV file format.

Each column must have a Header Name. These Header Names are Case sensitive and must not contain spaces. We have provided these Header names for each catalogue type below.

Each code must be unique among those you use and also different from any supplier codes already on the system. Duplicate codes will not get added to the system.

Rows must have data in every column.

ItemCost is net price (before sales tax) and must not contain a currency symbol.

To differentiate Chop and Assembled moulding codes from linear metre codes, we recommend appending the codes with the following:

Chopped

/CH

Assembled

/AS

For pre-cut glazing codes we recommend appending them with the following:

Pre-Cut

/PC

Backings

Header names

ItemCode, ItemDescription, ItemWidth, ItemLength, ItemCost, ComponentType

ItemCode:

Alpha-numeric and special characters.

ItemDescription:

Alpha-numeric and special characters.

ItemWidth:

Numeric (size in mm).

ItemLength:

Numeric (size in mm).

ItemCost:

Decimal (No currency symbol).

ComponentType: (use use one of below per item, these are case sensitive and have no spaces).

BackingBoard.

BackingPaper.

A sample can be found here.

Glazings

Header names

ItemCode, ItemDescription, ItemWidth, ItemLength, ItemCost, ComponentType

ItemCode:

Alpha-numeric and special characters.

ItemDescription:

Alpha-numeric and special characters.

ItemWidth:

Numeric (size in mm). *

ItemLength:

Numeric (size in mm). *

ItemCost:

Decimal (No currency symbol). +

ComponentType: (use one of below per item, these are case sensitive and have no spaces).

GlassSheet.

GlassPreCut.

AcrylicSheet.

AcrylicPreCut.

MirrorSheet.

MirrorPreCut.

Laminate.

* Pre-Cut glass must also provide the full width and length of the sheet. FramR will warn if the job exceeds the full sheet size.

+ ItemCost: Full Sheet materials have their prices entered as full sheet cost. Pre-Cut materials are entered as a SQM cost.

A sample can be found here.

Mouldings

Header names

ItemCode, ItemDescription, ItemWidth, RebateWidth, ItemCost, ChopType

ItemCode:

Alpha-numeric and special characters.

ItemDescription:

Alpha-numeric and special characters.

ItemWidth:

Numeric or decimal (size in mm).

RebateWidth:

Numeric or decimal (size in mm).

ItemCost:

Decimal (No currency symbol).

ChopType: (use use one of below per item, these are case sensitive).

Linear.

Chopped.

Assembled.

A sample can be found here.

Matboards

Header names

ItemCode, ItemDescription, MatboardRange, ItemWidth, ItemLength, ItemCost

ItemCode:

Alpha-numeric and special characters.

ItemDescription:

Alpha-numeric and special characters.

MatboardRange:

Alpha-numeric and special characters.

ItemWidth:

Numeric (size in mm).

ItemLength:

Numeric (size in mm).

ItemCost:

Decimal (No currency symbol).

A sample can be found here.

Importing Items into the Items catalogue