In tracezilla you can extract selected data from files you receive from customers or suppliers and import these data directly into the system. For example, you can import order lines from a long order from a customer sent to you as an excel file.
It will typically require a minimum of data, such as item number and quantity. In addition, the order header must be completed.
To import the order lines, you must define a template for the import. This is called an import script.
Import of order lines into an order
You can import order lines to all types of orders in tracezilla. The procedure is the same for all order types. However, there are different import scripts for incoming and outgoing orders.
1. Go to the order type to which you would like to import order lines. (Click the relevant tab in the top menu, eg. Sales and then select Orders in the drop-down menu).
2. Create a new order. (You can read the instructions here: Purchase order, Production order, Warehouse Order or Sales order).
3. Fill in the order details. Click Save to create the order.
4. On the empty order you have now created, click on the Import button on the right side of the screen. (The button is located in the first of the lower tabs that relates to the order itself ei the tab concerning the lots. This is also the tab you land on immediately after you have created the order header and clicked Save).
5. Click Upload File. The file format must be of type ods, xlsx, xls, csv, txt.
6. You can define an import template on the basis of the uploaded file by clicking Define importTemplate. The import template will then be saved to the partner profile (supplier/customer) for future orders of the same type.
7. Enter a recognizable text in the Memo field.
8. In the field First row you can choose on which line the first data should be written. In an xlsx-file, the first row will often be a header, so that the first row with data will be row 2.
9. In the field Preview you will now be able to see the columns contained in the file. The import template is created in the basis of the columns. The import template uses Liquid Open Source template language. You can find the instructions to Liquid here.
10. In the field Importscript is defined which data should be contained in which columns in the file that you are importing data from. The first time you open the import template the import script will contain the following lines:
sku_code| sku_id| free_units| quantity| uom_conversion| unit_price| uoms_per_price_unit| line_text|
The importscript for the inbound lines contain the following:
sku_code| partner_sku_code| lookup_discount| partner_quantity| sku_id| free_units| quantity| origin_country| uom_conversion| unit_price| corrected_unit_price| corrected_line_text| uoms_per_price_unit| line_text| expiry_date| trace_batch_number| trace_lot_number| trace_pallet_number| trace_other| attribute_internal| attribute_quality| attribute_size| attribute_state| attribute_specification| attribute_storage_bin| attribute_storage_bin_loc2| attribute_storage_bin_loc3| attribute_storage_bin_loc4| attribute_customs_status| attribute_eu_tariff_code| attribute_preservation| attribute_presentation| attribute_catch_method| attribute_fao_species_code| attribute_fao_fishing_area| attribute_product_destination| attribute_ewc_code| attribute_origin| attribute_origin_farm| attribute_origin_breeder| attribute_cutting| attribute_trim| attribute_pistol| attribute_age_of_animal| attribute_packaging| attribute_supplier_sku| attribute_extended_date| attribute_effective_ph| attribute_effective_temperature| attribute_enzyme_activity| if_batch_exists| if_no_batch|
11. Insert the name of the column next to a line in the import script, eg.:
sku_code|{{[COL_5]}}
The quantity is set to be gram. In case you would like the unit of measure of a SKU to be kilogram, you can multiply with 1000 by typing:
quantity|{{[COL_3] | plus: 0 | times: 1000 }}
12. Delete the remaining lines in the script to which no column has been defined.
13. Click Save and go to nextstep. Then click Start import in order to add the lot lines from the file.
Import SSCC to a delivery
Import SSCC to a delivery
If you receive a file from your warehouse or a manufacturer with SSCC that you want to import onto a delivery linked to an order, this is also possible using the import order lines feature on the order.
This can be used in cases where your company does not generate SSCC codes, but they are generated by a supplier. Especially when there are many lines, this can save time and reduce the risk of manual entry errors. It makes it easier to create delivery notes that should be sent via EDI (DESADV), but it can also be used if you are printing pallet labels or generating them.
The SSCC-specific lines must be specified with line_type|sscc in the import script in order to be imported correctly. See the example below.
sku_code|{{ [COL_1] }}
quantity_uom|{{ [COL_2] | plus: 0 }}
line_type|sscc
sscc|{{ [COL_3] }}
batch_number_overwrite|{{ [COL_4] }}
expiry_date_overwrite|{{ [COL_5] | date_from_xlsx }}
Updated date: 2026-17-08 11:26:00