Item Attributes

Attributes provide:

  • A fixed set of features (attributes).
  • A fixed set of units with the conversion calculations prefilled.
  • A description generator with an option to override it. 

Navigation: Main Menu > Setup > Items > Menu (button) > Edit Attributes


Edit Attributes Interface

Buttons Explained

ButtonDescription
Auto Height CheckboxIf checked, it expands the row to include the entire lookup list.
If unchecked, it collapses the row to only show the first item on the lookup list.
EditEnables editing the entries.
SaveSaves any changes.
MenuLayout

Fields Explained: Group Name

All the custom attributes for items must be added to a group. A group can have as many attributes as needed. However, it is better to create many groups with fewer attributes in each group, than one long group that may be difficult to manage afterwards.

The group feature was introduced in October 2025, and existing custom attributes are automatically added to a group named Attributes.

FieldDescription
Field Chooser (*)Allows users to add or remove columns.
IDThe system-generated number for the attribute group
NameA field to enter the group’s name.
WidgetAn option to delete the group.

Fields Explained: Attributes

FieldDescription
Field Chooser (*)Allows users to add or remove columns.
IDThe system-generated number for the attribute.
GroupThe name of the attribute group.
NameThe name is auto generated from the caption but may be changed.
The name must be lowercase.
No spaces or special characters are allowed.
CaptionA field for users to type the caption that is displayed to users.
EditorA field for users to select an attribute option from this list:

Text: Users can type any text.
Number (0 Decimals): Users can type an integer.
Number (2 Decimals): Users can type a number with two decimals.
Number (4 Decimals): Users can type a number with four decimals.
Combobox (Fixed): Users must select an item from the lookup list.
Combobox (Edit): Users can select an item from the lookup list or type a different item (items typed in are not added to the lookup list).
Lookup SQL: Users can write an SQL query to create a lookup list. Right-click the entry and select View/Edit Lookup SQL from the context menu.
LookupsOnly applies to Combo boxes. Allows users to type a lookup list: one entry per line.
CreatedThe date on which the entry was created.
UpdatedThe date on which the entry was updated.
Updated byThe User who updated the entry.
WidgetA submenu, which can also be accessed by right clicking the entry, with the following functions:

View/Edit Lookup SQL: Allows users to write SQL queries that create lookup lists from the output of that query.

Clear Attribute Values on Items: Clears all the values on items for that attribute. This function applies when the Editor field is changed, and the options selected for items are no longer valid.

Delete: Allows users to delete the custom attribute.

Estimating

There is only one option to add Estimating on the Attributes (tab). The estimating option (as listed below) is automatically chosen based on the item’s Extension Type.

Estimating (Materials or Assemblies)

FieldDescription
Qty TypeThe Quantity Type determines how the Quantity field is used in calculating the Unit Cost.
DescriptionA checkbox. If checked the Item’s Description is shown in the Estimate’s Description.
Waste %A field for users to type a number with up to two decimal places for the percentage that is wasted during production.
Round UpA checkbox. If checked will round up the price.
Min QtyA field for users to type a number with up to two decimal places for the Minimum Quantity that can be ordered.
Adj %A field for users to type a number with up to two decimal places for the percentage the Cost Price must be adjusted by.
UnitA lookup list of Units for users to select a unit from. A Unit must be selected.

Estimating (Tasks)

FieldDescription
Qty TypeThe Quantity Type determines how the Quantity field is used in calculating the Unit Cost.
QtyA field for users to type a number with up to two decimal places for the Quantity that is produced.
DescriptionA checkbox. If checked, the Item’s Description is shown on the Estimate’s Description.
Setup (Hrs)A field for users to type a number with up to two decimal places for the time it takes to set up the production.
Speed (Qty/Hr)A field for users to type a number with up to two decimal places for the Quantity that can be produced per hour.
Adj %A field for users to type a number with up to two decimal places for the percentage the Cost Price must be adjusted by.
Cost CentreA lookup list of Cost Centres for users to select one.
Fixed CostA field for users to type a number with up to two decimal places for the Fixed Cost.
Unit CostA field for users to type a number with up to two decimal places for the Unit Cost.
Min CostA field for users to type a number with up to two decimal places for the Minimum Cost.

Estimating (Outwork)

FieldDescription
Qty TypeThe Quantity Type determines how the Quantity field is used in calculating the Unit Cost.
QtyA field for users to type a number with up to two decimal places for the Quantity that is produced.
DescriptionA checkbox. If checked, the Item’s Description is shown on the Estimate’s Description.
Adj %A field for users to type a number with up to two decimal places for the percentage the Cost Price must be adjusted by.
SupplierA dropdown list of Suppliers for users to select one.
Fixed CostA field for users to type a number with up to two decimal places for the Fixed Cost.
Unit CostA field for users to type a number with up to two decimal places for the Unit Cost.
Min CostA field for users to type a number with up to two decimal places for the Minimum Cost.

Estimating (Costing)

FieldDescription
DescriptionA checkbox. If checked, the item’s description is shown as part of the Estimate’s Description.

Constraints

FieldDescription
TypeA lookup list for users to select Sheets or Reels.
Max DepthA field for users to type a number with up to two decimal places for the Maximum Depth.
Max WidthA field for users to type a number with up to two decimal places for the Maximum Width.
Margin – TopA field for users to type a number with up to two decimal places for the Top Margin.
Margin – BottomA field for users to type a number with up to two decimal places for the Bottom Margin.
Margin – SideA field for users to type a number with up to two decimal places for the Side Margin.

Substrate Waste

FieldDescription
TypeA lookup list for users to select Sheets or Reels.
Setup (units)A field for users to type a number with up to two decimal places for the number of Setup Units required.
Run (%)A field for users to type a number with up to two decimal places for the percentage that is wasted during the run.

Attribute Tutorials

These tutorials explain how to create and manage attributes. The fields in Fixed Attribute sets cannot be removed or renamed. Only the Values can be edited.

When to Add Estimating Attributes

  1. You should add Estimating Attributes if you create Estimates.
  2. There are several Estimating Attributes, and the applicable set is automatically chosen based on the Type of Item.
  3. The following parameters are added:
    1. Tasks:
      1. Qty Type
      2. Qty
      3. Description 
      4. Speed (Qty/Hr)
      5. Adj %
      6. Cost Centre
      7. Fixed Cost
      8. Unit Cost
      9. Min Cost
    2. Outwork:
      1. Qty Type
      2. Qty
      3. Description
      4. Adj %
      5. Supplier
      6. Fixed Cost
      7. Unit Cost
      8. Min Cost
    3. Materials or Assemblies:
      1. Qty Type
      2. Description
      3. Waste %
      4. Round Up
      5. Min Qty
      6. Adj %
      7. Unit 
    4. Costing:
      1. Description 

When to Add Substrate Waste Attributes to Materials

  1. You can consider adding the Substrate Waste Attribute to items, if:
    1. You use substrates that consist of Sheets or Reels.
    2. You use the following parameters:
      • Maximum Depth
      • Maximum Width
      • Margins: Top, Bottom, and Side

When to Add Substrate Waste Attributes to Costings or Assemblies

  1. You can consider adding the Substrate Waste Attribute to items, if:
    1. You use substrates that consist of Sheets or Reels. 
    2. You use the following parameters:
      • Setup (Units)
      • Run %

When to Add Constraint Attributes

  1. You can consider adding the Constraints Attributes to items, if:
    1. You use substrates that consist of Sheets or Reels. 
    2. You use the following parameters:
      • Max Depth
      • Max Width
      • Margins: Top, Bottom and Side

How to Add a Fixed Attribute Set

  1. Navigate to the Item you want to edit (Main Menu > Setup > Items > Double-click the item).
  2. Click Edit (button) on the top row of buttons.
  3. Click Detail (tab).
  4. Click the arrow on Attributes (button), hover your mouse over Add and click one of these options:
    1. Estimating
      • Note: The Item Type determines which Estimating Set is added.
    2. Substrate Waste
    3. Constraints

How to Remove a Fixed Attribute Set

  • Attribute sets are automatically created when you create a new Substrate. These sets cannot be removed.
  • Once an item has been copied to a Variation, the Attributes can no longer be removed.
  1. Navigate to the Item you want to edit (Main Menu > Setup > Items > Double-click the item).
  2. Click Edit (button) on the top row of buttons.
  3. Click Detail (tab).
  4. Click the arrow on Attributes (button) next to Add.
  5. Click Remove and click one of these options:
    1. Estimating
    2. Substrate Waste
    3. Constraints

How to Create Custom Attributes

  • Custom Attributes are used to provide additional information on items. For example, if you sell clothing, you might want attributes for features such as size, colour, designer, material, distributor, and country of origin.
  • It is important to enter all the possible attributes you might need before creating any Variations. Once variations are created, no more attributes can be added or removed. However, their values can still be edited.
  • Custom Attributes must be added to a group. You can create as many groups as you need.
  1. Navigate to Main Menu > Setup > Items.
  2. Click Menu (button) > Edit Attributes.
  3. Click Attributes (tab).
  4. Click Edit (button) on the top row.
  5. Fill in the top row as follows:
    1. Group (group section left) = Type a name for the group if you are creating a new group.
    2. Group (attribute section) = Select a group from the dropdown list or leave blank if you are creating a new group (the group name is added after you click Save (button).
    3. Name = Type a name for the attribute using lowercase letters and no special characters.
    4. Caption = Type a caption that users will see.
    5. Editor = Select an option from the lookup list by typing the fields.
      1. Text:  Users must type text.
      2. Number (0 Decimals): Users must type a number with no decimals.
      3. Number (2 Decimals): Users must type a number and can include up to 2 decimals.
      4. Number (4 Decimals): Users must type a number and can include up to 4 decimals.
      5. Combobox (Fixed): The user must select an option from the lookup list.
      6. Combobox (Edit): The user may select an option from the lookup list, or type a different option.
      7. Lookup SQL: Creates a lookup list and restricts users to select one.
        1. Right-click the field and select View/Edit Lookup SQL.
        2. Edit the SQL as needed, Test and Save it. 
    6. Lookups = Create a Lookup list if a Combobox (Edit) or Combobox (Fixed) was selected under Editor.
      1. Type a field (lookup item), press Enter, type the next field and so on.
      2. Click the checkbox next to Auto Height to display/hide the full lookup lists.
  6. Click Save (button).

How to Delete Custom Attributes

If Custom Attributes have been added to items, they must first be removed from the items before they can be deleted.

  1. Navigate to Main Menu > Setup > Items.
  2. Click Menu (button) > Edit Attributes.
  3. Click Attributes (tab).
  4. Right-click the Attribute to delete and select Delete from the context menu.
  5. Confirm the deletion on the popup.

How to Delete Custom Attribute Groups

  1. Navigate to Main Menu > Setup > Items.
  2. Click Menu (button) > Edit Attributes.
  3. Click Attributes (tab).
  4. Follow the instructions above (How to Delete Custom Attributes) and remove all the attributes from the group.
  5. Right click the applicable group name and select Delete on the context menu.
  6. Confirm the deletion on the popup.

How to Edit Custom Attributes

  • This procedure is to edit the created Attribute.
  • For example, if you have an Attribute Colour and a lookup list, this tutorial explains how to edit the lookup list or change the Caption: Colour.
  1. Navigate to Main Menu > Setup > Items.
  2. Click Menu (button) > Edit Attributes.
  3. Click Attributes (tab).
  4. Click Edit (button) on the top row.
  5. Make any changes.
  6. Click Save (button).

How to Add Custom Attributes to Items

It is important to add all the possible Attributes you might need before creating any Variations. Once variations are created, the attribute lists are fixed (i.e. no more attributes can be added or removed). However, the fields in the Value column can still be edited.

  1. Navigate to Main Menu > Setup > Items.
  2. Double click an item to edit it, or click the New (button) to create a new Item.
  3. Click Edit (button) on the top row if it is not greyed out.
  4. Click Detail (tab).
  5. On the second section, click Attributes (button) itself, and click all the Attributes you want to add (Use Ctrl + left click to multi-select).
  6. Click Select (button) on the bottom right.
  7. Once the Attributes are added:
    1. Click the arrow next to Attributes to expand the list.
    2. Edit the fields in the Value column.

How to Remove a Custom Attribute from an Item

Once an item has been copied to a Variation, the attributes can no longer be removed.

  1. Navigate to the item you want to edit (Main Menu > Setup > Items > Double-click the item).
  2. Click Edit (button) on the top row of buttons.
  3. Click Detail (tab).
  4. On the Attribute section, right-click the Attribute you want to remove and select Delete from the Context menu.
    • Note: This feature removes the Attribute from the item, it does not delete it from the list of Custom Attributes.

Related Articles