Home Get Help Goto App
Switch language: Dansk

Import template for SKUs

When you start up using tracezilla, you can import all your Stock Keeping Units (SKUs) via the Excel import template. This saves you from typing all your SKUs individually.

If, at a later stage, you want to make changes to a number of your SKUs at the same time, you can also use the import template for that.

  1. Click your company name in the upper right corner and select Company Settings in the drop-down menu.
  2. Click Go to in the subsection Stock Keeping Units (SKU).
  3. Click the button Import and then Get Import Template.
  4. The application will now generate an Excel document that you can choose to open or save.
  5. If you already have some SKUs in the application, they will appear as rows in the Excel document. If you have no SKUs, the document will be empty appart from the headers in the first row.
  6. Fill in the column cf. the explanation in the table below. You must have one SKU per row. Fields marked with a star (*) are mandatory. Other fields can be left empty or filled in for SKUs that are relevant.
  7. When all relevant columns are filled correctly, save the Excel document on your computer and import it to tracezilla like this: Go to your SKUs, click the button Import and then Upload file.
  8. Your SKUs will now appear in tracezilla. If there are any problems with the setup of the Excel document, the application will let you know what the problem is and in which row and column. When you have made the corrections, try to import again.

Guide for the import template for SKUs

To the left in the below, you have the headers of the Excel sheet. The right column provides explanations for each header.

Column header  
ID This ID is used by the application to recognize the SKU when the Excel sheet imported to the application. It ensures that the correct SKU will be updated with correct data.

Do NOT change or delete the ID.

If you don’t have any SKUs in tracezilla, the ID column will be empty.
SKU code* Enter SKU code
Name* Insert the name of the SKU as you want it to appear on invoices and other documents.
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.
Category* Can be: Raw material/Finished good

If the SKU is both a raw material and a finished good, it should be categorized as raw material.
Measures and units  
Lot Unit* Can be: Colli/pcs/kg/l/m2 etc.

The Lot Unit is the unit that you use to measure your lot. Usual Lot Units are colli, kg, l or pcs.
Force Lot Unit* Can be: Yes/No.

If you always use the same Lot Unit for this SKU, enter Yes. If it sometimes differ and you use another Lot Unit for this SKU, enter No.
Unit of Measure* Can be: Colli/pcs/kg/l/m2 etc.

The Unit of Measure is the unit that you use to measure this SKU across lots. Usual Units of Measure are kg, l or pcs.
Default UoMs per lot unit* Must be a number.

Enter the default number of Units of Measure per Lot Unit. E.g. how many pcs are in a colli?

If the Lot Unit and Unit of Measure is the same (e.g. kg), enter 1.
Lock relationship between UoM and lot unit* Can be: Yes/No.

If the number of Units of Measure per Lot Unit is always the same, Enter Yes. If the number differs from lot to lot, enter No.

We recommend that you lock the relationship, if possible, as this allows you to see e.g. reorder point in your lot unit.
Net weight per unit of measure* 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 unit of measure* Must be a number.

Same as above but for Gross Weight, i.e. the weight of one Unit of Measure incl. packaging.
Lead time Must be an integer.

Indicate how many days it will take to get this SKU on stock. All days count, also weekends and holidays.
Reorder Point Must be an integer.

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

If the relationship between Unit of Measure and Lot Unit is locked, the Reorder point will be calculated in Lot Units (e.g. colli). Otherwise, it will be calculated in the Unit of Measure (e.g. pcs.).
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.
Active Yes/No.

The SKU will be active as a default, unless you enter No in this column.
Certification Bodies  
Certification Body #1 Must be a Partner that already exists in tracezilla.

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 Body #2 If the product is certified by more than one certification body, you can indicate a second certification body here.

Same as above.
Certification Body #3 Same as above.
Attributes Read about attributes
Customs status, Enable Can be: Yes/No.

Customs status is relevant if you trade with third countries.

If Customs status is relevant, tick the box Enable.
Customs status, Default Value 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, Enable Can be: Yes/No.
If EU tariff code is relevant, tick the box Enable.
EU Tariff Code, Default Value 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.
Packaging, Enable Can be: Yes/No.

This attribute is relevant if packaging may vary from lot to lot.

If Packaging is relevant, tick the box Enable.
Packaging, Default Value 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, Enable Can be: Yes/No.

This attribute is relevant if the quality may vary from lot to lot.

If Quality is relevant, tick the box Enable.
Quality, Default Value 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, Enable Can be: Yes/No.

This attribute is relevant if the size may vary from lot to lot.

If Size is relevant, tick the box Enable.
Size, Default value Can be: Text and numbers.

Hvis du har aktiveret Størrelse, kan du her angive hvilken størrelse, varearten som udgangspunkt har (fx 2-3 mm eller 4-5 cm etc. Størrelsen kan ændres på varepartiet.
Specification, Enable This attribute is relevant if it may be necessary to add further specifications to the individual lot.

If Specification is relevant, tick the box Enable.
Specification, Default value 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, Enable Can be: Yes/No.

This attribute is relevant if the lots are not always located in the same place (storage bin) in your warehouse. It makes it possible to make some simple warehouse management and makes it easy to make a picking list.If Storage bin is relevant, tick the box Enable.
Storage Bin, Default value 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.
Supplier SKU, Enable Can be: Yes/No.

This attribute is relevant if you need to have your suppliers SKU code on documents, e.g. in relation to a sending an order to a producer.

If Suppliers SKU code is relevant, tick the box Enable.
Supplier SKU, Default value Can be: Text and numbers.

When Suppliers SKU code is enabled, you can enter the SKU code of your supplier.

The SKU code can be changed on the individual lot.
Translations, da Can be: Text and numbers.

Here you can make translations of the SKU name to the relevant language, here Danish.
Translations, en Can be: Text and numbers

Here you can make translations of the SKU name to the relevant language, here Danish.
Tag 1 Can be: Text and numbers.

You can add a tag to your SKU. If the tag does not already exist, it will be created automatically Read about tags.
Tag 2 Can be: Text and numbers.

You can add a tag to your SKU. If the tag does not already exist, it will be created automatically Read about tags.
Tag 3 Can be: Text and numbers.

You can add a tag to your SKU. If the tag does not already exist, it will be created automatically Read about tags.
Tag 4 Can be: Text and numbers.

You can add a tag to your SKU. If the tag does not already exist, it will be created automatically Read about tags.
Tag 5 Can be: Text and numbers.

You can add a tag to your SKU. If the tag does not already exist, it will be created automatically Read about tags.
×

Tilmeld dig nyhedsbrev

Få de nyeste vejledninger i din indbakke.

Tutorials

Get Started

Import & Export of Data

Integrations

Master Data

Settings

Order Management

Inventory Management

Financials

Reports

Miscellaneous