# Update order tracking from CSV 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

### Fulfill part of order based on vendor When items in an order come from different vendors, you can create fulfillment automations for each vendor. In that case, set the Item Vendor filter, and enter vendor name in the empty field. This way, the order items will be divided into multiple shipments according to the product vendor.

### 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 %} #### Set the row from which the items start If you want Fulfilleo to fuflil specific items, omit rows that do not contain tracking data. In the example below tracking data for individual items starts from row number 3 (red: **SKU**, green: **quantity**, blue: **tracking number**).

List of items to be fulfilled that starts from the row 3 annotated — List of items to be fulfilled that starts from the row 3

Select the row number from which starts the list of items to be fulfilled.

How to set offset in the Fulfilleo — Set offset in the Fulfilleo

This option is available only if you have not selected to fulfil all items.