Importing material catalogues

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

FramR FREE offers automatic catalogue updates for a number regions.

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

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 column must have a header mame.

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.

Each code must be unique.

Rows must have data in every column.

There must be data in every column of each row.

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

cost should be net price.

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 FREE 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