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

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.

Setting fulfillment based on 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:

Sheet with each line item separately

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

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:

Fulfilleo setting

Refer to the specific cell using Liquid - Fulfilleo settings

Copy this setting

{{ rows[1]["B"] }}

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

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

Set offset in the Fulfilleo

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