Item
  • 18 Dec 2024
  • 31 Minutes to read

Item


Article summary

Understanding Item

What is an Item in Canary7?

It is a product that will be stored within the warehouse and assigned a variety of information in which to clearly identify it.

Items will have unique Item Codes (also known as a Stock Keeping Unit) and Item Descriptions.

Items will have a Reference, relating to a barcode in which to identify it. Note: As the same item may have multiples due to varying suppliers or packaging types, Canary7 allows you to assigned multiple references to a single item.

Items will have a Unit of Measure (UOM) in order to detail the the medium it is found in and the consequent factor of the item within. Note: Items may have multiple UOMs within Canary7 in order to delineate between the various ways it may be sold. For example: An item may be a Pallet (Factor 96), Carton (Factor 12) and Each (Factor 1).

Items may also be grouped into Item Groups (In order to delineate between physical characteristics such as Large and Small) and Item Selections (Can be used to group items based on a client or process within your warehouse).


Accessing Item

Within the Navigation menu, click on the search bar and type ''Item'' and click on "Item". Item is also in Configuration, under Functional Area Setup > Inventory Control Setup > Item.

Searching within Item

You can search for information assigned to an item, which are within three tabs:

  • Item tab - used to find general item information 
  • UOM tab - used to find the item unit of measure information.
  • References - used to find item reference information. 

Searching for General Item Information

For example, you want to find a specific item and see its data. To get a list of all items, leave all fields blank.

image tab search

Enterable fields:

  •  Item Code
  •  Company Id
  •  Item Description
  •  Item Reference

Once you have entered all the information, you need to find your results click on the search buttonsearch button to continue.

item search results

This is what the search results will look like and will contain the following:

  •  Item ID
  •  Item Code
  •  Company Code
  •  Item Group
  •  Description
  •  Long Description
  •  Status

All of these results may not be on screen at once. You can simply scroll using the horizontal scroll bar to access the other results.

Searching for item Unit of Measure Information

For example, you want to find a Unit of Measure of an Item. 

UOM search

Enterable fields:

  •  Unit of Measure
  •  Item Code

Once you have entered all the information, you need to find your results click on the search buttonsearch button to continue.

UOM results

This is what the search results will look like and will contain the following:

  •  Item Code
  •  Company
  •  Item Description
  •  Unit of Measure
  •  Factor
  •  Length(cm)
  •  Width(cm)
  •  Height(cm)
  •  Weight(kg)

All of these results may not be on screen at once. You can simply scroll using the horizontal scroll bar to access the other results.

Searching for Item References

For example, you want to find a Reference for an item.

reference search

Enterable fields:

  •  Item Code
  •  Company Code
  •  Unit of Measure
  •  Reference

Once you have entered all the information, you need to find your results click on the search buttonsearch button to continue.

reference results

This is what the search results will look like and will contain the following:

  •  Reference
  •  Item Code
  •  Item Description
  •  Company Code
  •  Unit of Measure

All of these results may not be on screen at once. You can simply scroll using the horizontal scroll bar to access the other results.

Adding Items via import CSV

This section will help you ensure that your CSV file meets the required format and standards for successfully importing items into the system.


 Item Code Description UOM Reference
ExampleGU1D3-1223User GuideEachPO123456789

Template Download: 

Note: Row 2 provides an example of typical inputs.

Importing the CSV

Click on the Red Action Buttonred action button. This will bring up a drop-down menu, and select "Import CSV".

2 import csv

Selecting the import type

Using the drop-menu select "Item/UOM/reference Insert"

select import type

Choosing File

The next step is to click on "Choose File"

3 choose file

Locate and choose your file by clicking on "Open"

3 select file

Select the company relating to the item.

select compnay

Once you have selected and entered the required fields, click on the Import buttonImport button to upload your file.

Reference Insert CSV import

This section helps ensure that your CSV file meets the required format and criteria for successfully importing item reference data into the system.


 Item Code Unit of Measure Reference
ExampleGU1D3-1223EachPO123456789

Template download:

Importing the CSV

Click on the Red Action Buttonred action button. This will bring up a drop-down menu, and select "Import CSV".

2 import csv

Selecting the import type

Using the drop-menu select "Reference Insert"

Choosing File

The next step is to click on "Choose File"

Locate and choose your file by clicking on "Open"

Select the company relating to the item.

Once you have selected and entered the required fields, click on the Import buttonImport button to upload your file.

Adding Items via User input

Click on the Red Action Buttonred action button, this will bring up a drop-down menu, and select "Add"

1. add receipt

Enter in Mandatory Fields

4 enter mandatory fields

Enter or Select the following

  1.  Item Code
  2.  Company
  3.  Description
  4.  Item Group

The other fields are optional but not required. It is recommended to provide as much information as possible for enhanced traceability and analytics. When adding an image the requirements are a .jpeg file up to 500 KB in size.

Once you have selected and entered the required fields, click on the submit buttonsubmit button(1) to add.

Adding Unit of Measure

 Search for your item. Here is a guide to Searching within Item.

When the item has been located, click on the three dotsThree dots and click edit.

7 click edit

Click on the Unit of Measures Tab

8 click uom

You will now need to add the Unit Of Measures, click on the Red Action Buttonred action button, this will bring up a drop-down menu, and select "Add"

9 add uom

Enter Mandatory Fields

inputing unit of measure

Enter or Select the following:

  1.  Unit of Measure
  2.  Factor

Once you are satisfied with all the data you have input into the item and ensure that it is correct, click on the submit buttonsubmit button(1) to continue.


Was this article helpful?