Stock Keeping Units (SKU)

To see and create your Stock Keeping Units (SKUs), click Warehouse in the top menu and select Stock Keeping Units in the drop-down menu.

You have several options for adding data to SKUs. You can read our tutorial for creating SKUs with a simple setup below. This way you will only fill out the mandatory fields.

For advanced setup, we have these additional tutorials:

*Setting up Units of Measure for SKUs *Partner Relations, Stock Keeping Units *Import template for SKUs *Retail prices

Create SKUs the simple way

  1. Click Warehouse in the top menu and select Stock Keeping Units in the drop-down menu.
  2. Click Add new in the upper right corner. The standard setup will occur in a separate window. In the upper part of the window you will see the different tabs for setting up the SKU, allowing advanced settings. To create a SKU quick and easy you just need to fill out some fields in the tabs Names & identity and Measures & Units. Add SKU

    Tip! If you would rather use the Wizard, you can choose to do so. The Wizard will guide you to fill out the mandatory fields. Afterwards you have the opportunity to enrich the SKU with data. This is optional as you can simply click Save if you do not want to add more data to your SKU.

  3. First, enter a SKU Code.

    You can click the green button in the field and get the system to suggest a SKU Code. The SKU Code will appear on documents.

  4. Enter the Name of the SKU.

    This is the global name, which will appear on documents like order confirmations and invoices. You can enter a translation of the SKU name, but this is optional. You can enable more languages in the Company Settings.

  5. Select the Category of the SKU.

    The SKU can be categorized as a Raw material, Intermediate Good or Finished Good. Raw material can be unprocessed goods. Finished goods are goods that are not meant for further processing or production before being sold.

  6. Go to the tab Measures & Units. Add SKU - Measures and units
  7. Define the Primary Unit of measure i.e. the unit you are used to indicate for the SKU when working with the SKU.

    Depending on your Primary Unit of measure you might want to select a Box unit. For example if your primary unit of measure is pieces and you always pack the pieces in boxes of eight pieces, then the box unit is colli.

    To select a Box Unit you need to enable it by selecting Yes in the field Use fixed box unit. When you have set up the SKU with a box unit as the measuring unit, you can not dispose the SKU in orders in another measure or dispose a half box unit i.e. break down the box unit in smaller pieces. If you choose to measure the SKU in a box unit like colli, you need to indicate the Default UoMs (unit of measure) per box unit e.g. the quantity of pieces in a colli.

    If you select kg as the primary unit of measure you can disable the use of box units and instead select a unit of measure like grams in the field Allow decimals down to.

  8. Enter the Net weight and the Gros weight of the SKU according to the Primary unit of measure. The net weight is the weight of the goods without packaging.
  9. The other fields are optional to fill out. If you are finished creating your SKU for now, you can simply click Save. You can always add more data to your SKU later.

 

Below, you can see an explanation for all fields, including advanced setup options.

Additional guide to create a SKU

Fields marked with a star* are mandatory. The others are optional.

Names & identification Explanation
SKU code* Can be: Numbers and text.

Type in the SKU code.
Name* Insert the name of the SKU as you want it to appear on invoices and other documents.
Enable traceability If you want traceability for this SKU, select Yes. SKUs without traceability is typically used, for packaging without direct food contact. This to enable flexability when packing orders, of if orders are edited.
Can new lots be created with this SKU (end-of-life)? Can be: Yes/No.

The SKU will be active as a default, unless you select No. Status will change to obsolete if No is selected.
Category* Can be: Raw material/Intermediate Good/Finished good.

If the SKU is both a raw material and a finished good, it should be categorized as raw material.
EAN, lot unit Enter the EAN number related to the Lot Unit. If the Lot Unit is Colli, it will be the colli EAN.
EAN, unit of measure Enter the EAN number related to the Unit of Measure. If the Unit of Measure is Pieces, it will be the pieces EAN number.
Measures & Units  
Primary Unit of Measure* Can be: Colli/pcs/kg/l/m2 etc.

The primary UoM is the unit that you use to measure your lot. Usually, the primary UoM is colli, kg, l or pcs.

Due to technical reasons, the lot unit needs to be ‘g’ when the unit of measure is ‘kg’.
Use fixed box unit* Can be: Yes/No.

If the SKU is always handled in a fixed box unit, e.g. colli, select Yes.
Box unit* If the UoM is always handled in a specific box unit, you can select the box unit here, e.g. colli, BigBag, pallet, etc.
UoMs pr. box unit* Must be a number.

Enter the quantity of Units of Measure per box unit. E.g. how many pcs are in a colli?

If the boc unit and UoM is the same (e.g. kg), enter 1.
Net weight per UoM* Must be a number.

Indicate the relationship between your Unit of Measure and 1 kg.If your Unit of Measure i kg, enter 1. If your Unit of Measure is Pcs. and one piece weights 97 g, enter 0,097.
Gross Weight per UoM* Must be a number.

Same as above but for Gross Weight, i.e. the weight of one Unit of Measure incl. packaging.
Safety Stock The safety stock sets the minimum quantity that should be available and that cannot be disposes by integrations such as webshops.
Reorder Point Must be an integer.

What is the minimum you should have on stock of this SKU?

By entering a reorder point, a warning can appear on the front page of the application, when the order point is crossed. Please notice! The widget Below order point must be enabled for this warning to appear.
Lead time Must be an integer.

Indicate how many days you expect it to take to get the SKU in stock again. All days count, also weekends and holidays.
Expiry date type Choose the correct date type for your product. Foods may be safe to eat after the Best before date, but the sensory quality may have changed after the date. You can eat foods with a Use by date until that date, but not after because of food safety.
Days until best before Must be an integer.

If you fill in this field, the Best Before date will automatically be calculated for each lot based on production date.
Days until use by Must be an integer.

If you fill in this field, the Use By date will automatically be calculated for each lot based on production date.
Attributes Read about attributes. You need to Enable the attribute to write something in the field Default Value.
Catch Method Can be: Text and numbers.

If you have enabled Catch Method, you can indicate the catch method for the SKU. Catch Method can be changed on the individual lot.
Customs status Can be: Text and numbers.

When Customs status is enabled, you can enter a default value for the customs status. Customs status can be changed on the individual lot.
EU Tariff Code Can be: Text and numbers.

When EU tariff code is enabled, you can enter a default value for the EU tariff code. EU tariff code can be changed on the individual lot.
EWC code Can be: Text and numbers.

When EWC code is enabled, you can enter a default value for the European Waste Code. EWC code can be changed on the individual lot.
FAO Catch Zone Can be: Text and numbers.

If you have enabled FAO Catch Zone, you can type in the fishing area applying to the SKU. Catch Zone can be changed on the individual lot.
Origin Can be: Text and numbers.

If you have enabled Origin, you can type in the origin applying for the SKU. Origin can be changed on the individual lot.
Farmer/Grower Can be: Text and numbers.

If you have enabled Farmer/Grower, you can indicate the primary producer of the SKU. Farmer/Grower can be changed on the individual lot.
Breeder Can be: Text and numbers.

If you have enabled Breeder, you can indicate the breeder of the SKU. Breeder can be changed on the individual lot.
Packaging Can be: Text and numbers.

When Packaging is enabled, you can enter a default value for the packaging (e.g. 20 kg bags or big bags etc.). Packaging can be changed on the individual lot.
Quality Can be: Text and numbers.

When Quality is enabled, you can enter a default value for the quality (e.g. Quality 2, 1st sorting etc.). Quality can be changed on the individual lot.
Size Can be: Text and numbers.

If you have enabled Size, you can indicate the size of the lot e.g. 5x7 inches. Size can be changed on the individual lot.
Specification Can be: Text and numbers.

When Specification is enabled, you can enter a default value/specification. Specification can be changed on the individual lot.
Storage Bin Can be: Text and numbers.

When Storage bin is enabled, you can enter a default value for storage bin (i.e. location in your warehouse). Storage bin can be changed on the individual lot. Storage bin attributes can be assigned to both SKUs with and without traceability.
Permissions  
Allow By ticking the boxes, you allow for the SKU to be used in different types of orders.
Partner relations Read more in the tutorial Partner Relations, Stock Keeping Units.
Quantity Declarations Read more in the tutorial Excise duties report for sales orders
Certification Bodies  
Certification Body #1 Can be: Partner.

If the product is certified by a certification body (e.g. Organic, Fair Trade, MSC, etc.), enter the certification body here. The certification body must exist as a partner in tracezilla before you import the Excel sheet.
Certification Scheme Select the relevant certification scheme.
Misc.  
Default Origin Country Select a country from the drop-down menu.

If the SKU always has the same origin, e.g. coffee beans from Indonesia, you can select the country here.
Only show sums on invoices Tick off if relevant.

By ticking this box, only summarized quantities of the SKU will appear on invoices, instead of traceability for all lots of the same SKU.
Hide on documents Tick the box if you want the SKU to be hidden on documents.
Enable parcel quantity on inbound orders (purchase, production) Tick if relevant.

This will enable specifyng parcel sizes on purchase orders and production orders.
Enable parcel quantity on outbound orders (sales, production, movements) Tick if relevant.

This will enable specifying parcel sizes on sales orders, warehouse orders and production orders.
Lock parcel size on outbound order based on inbound order By ticking this box, the parcel size from the inbound order, can not be changed.
Average parcel size Enter an average parcel size. You can read more about parcels here
Force parcel size on inbound orders (purchase, production) When ticking this box, the average parcel size will always be entered on purchase orders and production orders.

 

 

Product Information

When a SKU has been created, you can add additional product information in the form of descriptions, dimensions, and nutritional information. In the SKU overview you can click the button with an arrow and three small dots on the right, and the select Product information.

Descriptions

Column header Explanation
SKU, ID Do not change the information or fill in this field.
SKU Code Copy and paste the SKU code of the SKU for which you want to enter the information.
SKU, Global name Copy and paste the global name of the SKU for which you want to enter the information.
Enable descriptions If you wish to enable the Descriptions section, enter Yes.

If you wish to disable the Descriptions section, enter No.
Product description Enter a product description of choice.
Ingredients Enter a text including all ingredients.
Allergens Enter all allergens.
Storage Enter a text about how the product should be stored.
Shelf life Enter a text about the shelf life of the product.
Expiry date placement Enter a short text about where the expiration date is located on the product.
Manufacturing date placement Enter a short text about where the manufactoring date is located on the product.

 

Dimensions

The tab Dimensions can be used to store information about box dimensions and unit dimensions. Here you can specify the size of a SKU. This can be useful, if you need to know the size of a colli when packing a pallet.

Column header Explanation
SKU, ID Do not change the information or fill in this field.
SKU code Copy and paste the SKU code and name that belong to the SKU for which you want to enter the information.
Name Copy and paste the SKU code and name that belong to the SKU for which you want to enter the information.
Enable box dimensions Can be: Yes/No.

In order to fill in the following fields, you must enter Yes.
Box dimensions (parcel, colli), Height Can be: Numbers with up to two decimals.

The Box Unit can be e.g. colli. In this field you can enter the height of the Box Unit.
Box dimensions (parcel, colli), Width Can be: Numbers with up to two decimals.

The Box Unit can be e.g. colli. In this field you can enter the width of the Box Unit.
Box dimensions (parcel, colli), Depth Can be: Numbers with up to two decimals.

The Box Unit can be e.g. colli. In this field you can enter the depth of the Box Unit.
Enable unit dimensions Can be Yes/No.

In order to fill in the following fields, you must enter Yes.
Unit-dimensions (pcs), Height Can be: Numbers with up to two decimals.

The Unit is the SKU UoM, e.g. pcs, kg, etc. In this field you can enter the height of the Unit.
Unit-dimensions (pcs), Width Can be: Numbers with up to two decimals.

The Unit is the SKU UoM, e.g. pcs, kg, etc. In this field you can enter the width of the Unit.
Unit-dimensions (pcs), Depth Can be: Numbers with up to two decimals.

The Unit is the SKU UoM, e.g. pcs, kg, etc. In this field you can enter the depth of the Unit.

 

Nutrition

Column header Explanation
SKU, ID Do not change the information or fill in this field.
SKU Code Copy and paste the SKU code of the SKU for which you want to enter the information.
SKU, Global name Copy and paste the global name of the SKU for which you want to enter the information.
Turn on Nutrition Declaration If you wish to enable the nutrition declaration, enter Yes.

If you wish to disable the nutrition declaration, enter No.
Per Can be: 100g or 100ml.
Serving Size In this field you can enter a serving size of the finished product. The nutrition info will automatically be calculated.
Energy, kcal Enter kcal / 100g (or 100ml) of finished product.
Fats Enter the fat content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Hereof saturates Enter the saturates content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Hereof mono-unsaturates Enter the mono-unsaturates content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Hereof poly-unsaturates Enter the poly-unsaturates content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Carbohydrate Enter the carbohydrate content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Hereof sugars Enter the sugar content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Hereof polyols Enter the polyol content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Hereof starch Enter the starch content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Fibre Enter the fibre content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Protein Enter the protein content of the finished product. The data must be entered in g / 100g (or ml / 100ml).
Salt Enter the salt content of the finished product. The data must be entered in g / 100g (or ml / 100ml).

 

Retail prices

Column header Explanation
Retail price Enter the retail price of the sales unit. The first line will always be you default currency.
Currency If needed, select another currency, select Add Retail Price and enter the retail price of this currency.

 

 

Copy a SKU

If you want to create a new SKU that are similar to an existing SKU, you can copy it.

  1. Click Warehouse in the top menu. Select Stock Keeping Units.
  2. Use the filters on the left to search for the SKU you want to copy.
  3. Click the blue button next to the SKU and select Copy. Create a copy of a SKU
  4. Give the new SKU a different SKU code and name.
  5. Correct or add the other information that differentiates this SKU from the one being copied from. Click Save.

 

 

Hide specific lot lines on documents

It is possible to hide specific SKU lot lines on [documents][https://www.tracezilla.com/en/tutorials/documents] such as order confirmations, and invoices. This can be relevant for transportation pallets and more, when these must be pulled from stock, but not appear on the documents.

  1. When a SKU must be hidden on documents, you must first go to Warehouse and select Stock Keeping Units in the drop-down menu.
  2. Find the SKU that is to be hidden on documents, and click Configure by the SKU.
  3. Click the tab Misc.
  4. Tick the box by Hide on documents
  5. Click Save.
  6. By this, the SKU will not appear on order confirmations, delivery notes an invoices. Please not!: The SKU will only stay hidden, if no price is entered in the lot line (Total Price = 0,-).

Outline