Tutorials

Documentation of tracezilla

Import of order lines

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.

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 incoming lines contain the following:

sku_code|
sku_id|
free_units|
quantity|
origin_country|
uom_conversion|
unit_price|
uoms_per_price_unit|
line_text|
trace_batch_number|
trace_lot_number|

 

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 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.

 

Outline