> For the complete documentation index, see [llms.txt](https://help.fulfilleo.solvenium.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.fulfilleo.solvenium.com/data-mapping/update-order-tracking-from-csv.md). # Update order tracking from CSV With Fulfilleo you can automatically mark both entire Shopify orders and individual items as fulfilled with a tracking number based on a sheet from your supplier. Basic setup for fulfilling the entire order In order to fulfill all items in the order, you need only its number and a tracking number.

Order and tracking numbers in the sheet from the supplier

For the above example, use the following settings in the **Data Mapping** section. The first row contains the column names, so click on the gear icon and check the option **First row is a header**.

Basic settings to fulfill all items for CSV file

### Using Liquid formulas If you need to modify a value from the CSV file before using it, you can access the value from a specific column using the following syntax: ``` {{ row['column_name'] }} ``` For example, if the `order_number` column contains: ``` 12345 ``` and you need to add the `ABC-` prefix, you can use: ``` ABC-{{ row['order_number'] }} ``` This will result in: ``` ACB-12345 ``` You can also use Liquid filters to further modify values from the CSV file. ### Fulfill each line item separately It may happen that an order is divided into multiple shipments. In such case the sheet from a supplier looks something like this:

In the above sheet, column **A** is the **order number**, **B** contains **tracking numbers**, **C** is the **quantity**, and **D** is the **SKU**. The item list starts with the first row. The **Items start row** field will appear when you select the option that **SKU** is to be taken from a specific **column**. Configure your Data Mapping section as follows:

Fulfilleo settings for CSV when each line item should be fulfilled separately

### Extract data from a specific cell in CSV Referring to a specific cell in a spreadsheet can be applied in the following fields: **Order Number**, **Tracking Number** and **Tracking Company**. For example, in the following sheet, the order number (yellow) is in cell **B2**.

Order number provided in the specific cell in the sheet annotated — Order number provided in the specific cell in the sheet

There are two ways to extract it from this cell. #### Extract data from a single cell using its address The first method is providing the cell address using its column and row indexes. So for the above example, enter **B2** in the **Order Number** field in the **Data Mapping** section:

Refer to the specific cell using its address - Fulfilleo settings

#### Extract data from a single cell using Liquid Another way is to use the **rows** variable in the desired field. Please note that arrays in Liquid are indexed starting from 0, so the **B2** address with the Liquid syntax will look like this: {% tabs %} {% tab title="Fulfilleo setting" %}

How to refer to the specific cell using Liquid - Fulfilleo settings — Refer to the specific cell using Liquid - Fulfilleo settings

{% endtab %} {% tab title="Copy this setting" %} ``` {{ rows[1]["B"] }} ``` {% endtab %} {% endtabs %}