> For the complete documentation index, see [llms.txt](https://help.tillit.cloud/tillit/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.tillit.cloud/tillit/tools/excel-addin-v2/orders.md).

# Orders

### Overview

The **Orders** button lets you work with TilliT production orders and Scheduler orders in Excel. You can load existing orders from TilliT into a sheet for review or editing, or generate an upload template to create or update orders in bulk.

### Opening Orders

In the **TilliT V2** ribbon tab, click the **Orders** button.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2F0OPnEvr3G558z1iVMuuU%2Fimage.png?alt=media&amp;token=803dcbdb-d9cb-48f1-b56b-249edf856563" alt=""><figcaption></figcaption></figure>

The task pane will show any previously loaded order sheets, along with a **New** button in the header.

### Choosing an Action

Click **New** to open the wizard. The first step asks you to choose an action:

| Action                               | Description                                                                    |
| ------------------------------------ | ------------------------------------------------------------------------------ |
| **Load Orders**                      | Fetch existing TilliT orders into Excel based on asset, date range, and status |
| **Upload Orders (Upsert)**           | Generate a template sheet to create new orders or update existing ones         |
| **Load Scheduler Orders**            | Fetch Scheduler orders for a selected data template and date range             |
| **Upload Scheduler Orders (Upsert)** | Generate a template sheet to create or update Scheduler orders                 |

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FkXUk7hJ1dydbrKGIBPeY%2Fimage.png?alt=media&amp;token=3834a209-44ad-4676-88bd-16f548622237" alt=""><figcaption></figcaption></figure>

***

## Loading TilliT Orders

#### Step 2: Select Assets

Select one or more assets to filter orders by. You can also click **Select All** to include all assets.

Selected assets appear highlighted. Click **Next** when ready.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FgyWmkTm1lNRFJkMJKeyV%2Fimage.png?alt=media&amp;token=814803f5-d0d1-4ab1-8459-d3c203528752" alt=""><figcaption></figcaption></figure>

#### Step 3: Date Range

Choose the date range for the orders. Use a preset or enter custom dates:

* **Today**
* **Yesterday**
* **This Week**
* **Custom** — use the From date and To date pickers

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FnpHbTSd9Ny0ZqQg1JmOn%2Fimage.png?alt=media&amp;token=31e6a39f-cc7a-4b03-947f-1070324b3c0b" alt=""><figcaption></figcaption></figure>

#### Step 4: Filter & Load

Select which order statuses to include. Tap a status to toggle it on (highlighted) or off.

You can also set a custom **Sheet name** for the Excel sheet that will be created.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FlexHMW4mIdZuQq7FNLVU%2Fimage.png?alt=media&amp;token=9f2fab66-f35a-4554-a7e4-2a0ccec5e17a" alt=""><figcaption></figcaption></figure>

Click **Load Orders** when ready.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FTEg46OT7dXimRIQjdUU0%2Fimage.png?alt=media&amp;token=8aa70009-cded-41fe-97c9-4453748aeba2" alt=""><figcaption></figcaption></figure>

***

## Uploading TilliT Orders (Upsert)

#### Step 2: Create Upload Template

This action creates a template sheet in Excel with the required order columns already set up.

Optionally, set a custom **Sheet name**, then click **Create Template**.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2F2VcfeHeXZPLaOrLx2llT%2Fimage.png?alt=media&amp;token=03f41fe2-a612-4fe1-9003-6f24b72809ae" alt=""><figcaption></figcaption></figure>

The template sheet will be created in Excel with the standard order columns.

{% hint style="info" %}
You can add additional columns using dot notation:

* `attribute.Color` — add an order attribute value
* `tolerance.lowerLimit.Temperature` — add a tolerance value
* `property.customField` — add a custom property
  {% endhint %}

Once you have filled in the rows, use the **Upload** button on the order card in the task pane to send them to TilliT.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FqDN7CUYnSLJ6tOVLeU4t%2Fimage.png?alt=media&amp;token=3db27adf-c5e2-4ed7-84de-50bd05b59cdb" alt=""><figcaption></figcaption></figure>

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FTuNI2abVgYWBu1CvGTI9%2Fimage.png?alt=media&amp;token=222666bd-dc8d-4bdd-ab24-8a3036de7438" alt=""><figcaption></figcaption></figure>

***

## Loading Scheduler Orders

#### Step 2: Select Data Template

Choose the Scheduler data template to load orders from. Each template is associated with a location.

{% hint style="warning" %}
If a template has no location configured, a warning will appear indicating that orders will be loaded without a location filter.
{% endhint %}

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2Fr0Lwo4QE1kc8439WWrA5%2Fimage.png?alt=media&amp;token=fc17be54-c877-47f5-a1fb-7761cb7f3c57" alt=""><figcaption></figcaption></figure>

#### Step 3: Date Range

Select the date range using presets (Today, Yesterday, This Week) or custom From/To date pickers. Click **Next**.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FMyIEzM1rgp8EbFhZT6NA%2Fimage.png?alt=media&amp;token=20fc65c0-5cc4-4bec-9fa3-6734325480b2" alt=""><figcaption></figcaption></figure>

#### Step 4: Load

Optionally set a **Sheet name**, then click **Load Scheduler Orders**.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FNmkq02a4Hs3PYu2MZxRN%2Fimage.png?alt=media&amp;token=f5afb9fd-d597-43c4-8311-933168afbbb9" alt=""><figcaption></figcaption></figure>

***

## Uploading Scheduler Orders (Upsert)

#### Step 2: Select Data Template

Choose the Scheduler data template you want to upload orders against.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2F9DngL3SjWwgcj1mLdDwz%2Fimage.png?alt=media&amp;token=d1c07663-90f5-4123-8821-140952b00b97" alt=""><figcaption></figcaption></figure>

#### Step 3: Create Upload Template

A template sheet will be created with the Scheduler order columns. Optionally set a **Sheet name**, then click **Create Template**.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FKt4AioOixCoMTxp6ZKCP%2Fimage.png?alt=media&amp;token=5532762e-b315-4457-89cf-284b7847f50e" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can add additional columns using dot notation (e.g. `property.customField`) after the template is created.
{% endhint %}

Once you have filled in the template rows, use the **Upload** button on the order card in the task pane to send them to the Scheduler.
