---
metadata:
  - name: generator
    content: Diplodoc Platform v5.19.6
alternate:
  - https://docs.routeq.com/doc/en/delivery/functions/order-contents.md
---
> **Documentation Index:** Fetch the complete configuration index at https://docs.routeq.com/doc/en/llms.txt


# Order items

{% note info %}

Order items can only be uploaded for orders with the `delivery` type.

{% endnote %}

You can upload to Track & Trace the items of each order, including:

* Number of items.
* Product name, quantity, and price of each item.

This way, you can:

* Reduce the number of errors and losses when processing returns.
* Streamline the return management process for couriers.
* Stop using printouts.
* Reduce the number of manual operations.

You can upload order items:

* Via [Routing Workspace](#order-contents-interface).
* Via the [API](#order-contents-api). 



## Uploading order items via the interface {#order-items-interface}

### Data upload template {#template}

To upload order items, use an Excel file filled out using this [template](https://doc-static.yandex.net/src/dev/routing/templates/mvrp-example-orders-items-en.xlsx).

You can also download the template via Routing Workspace. To do this:
1. Open [Routing Workspace](https://yandex.com/courier/companies).
2. Go to **Track & Trace** → **Dashboard**.
3. In the top right corner of the screen, click **Import** → **Order items**.
4. Click **Download template**.

   ![](./../_images/order-contents-download.png)
   
5. Fill out the Excel file according to the template.

    {% note info %}

    In the file, the order number in the **Order number** field (`location_id` in the API) on the **Items** sheet should match the order number in Track & Trace (you can view it in the order card).

    {% endnote %}

    {% include [duplicates](../_includes/duplicates-a5af884da9a7.md) %}

    {% include [comparison](../_includes/comparison-0f5587655484.md) %}

### Uploading data from a file {#load-file}

{% note info %}

For order items to be uploaded correctly, you must already have a route loaded in Track & Trace. For more information, see [Uploading data](https://docs.routeq.com/doc/en/delivery/load-data.md).

{% endnote %}

1. Open [Routing Workspace](https://yandex.com/courier/companies).
1. Go to **Track & Trace** → **Dashboard**.
1. In the top right corner of the screen, click **Import** → **Order items**.
1. Click **Upload template** and select the file you filled out using the [template](#template).

    In case of upload errors, fix them in the interface or download the error file, fix the errors, and upload the fixed file.
  
1. Click **Import**. 

![](./../_images/order-contents-upload.png)

You can upload up to 10,000 products at once across all orders.

Fields to complete:

#|
||**Field name** |**Parameter** | **Required** | **Description** ||
||Order number | `location_id` | Yes | Order number in Track & Trace. ||
||Unique number | `item_number` | Yes | Product or service ID. All product numbers within a given order must be unique. ||
||SKU | `item_code` | No | Product or service item code. Within a single order, item numbers may be duplicated. For example, if the same product is sold at different prices: regular and promotional. ||
||Name | `item_name` | Yes | Product or service name up to 100 characters long. ||
||Quantity | `item_count` | Yes | Quantity of a product or service. The default is 1. ||
||Price | `item_price` | Yes | Unit price of a product or service. The default is 0. ||
|#


### Viewing order items {#open-card}

1. Go to **Track & Trace** → **Dashboard**.
2. Select the route and order.
3. In the order card, click the link with the number of items in the **Order items** field.

    {% cut "Link to order items in the order card" %}
    
    ![](./../_images/order-contents-open-link.png)

    {% endcut %}
    
You'll see the item code, name, quantity, price, and total on the list.

![](./../_images/order-contents-list.png)

### Viewing a delivered order {#open-delivered-order}

You can view detailed information about the delivered items for the order. To do this:

1. Go to **Track & Trace** → **Dashboard**.
2. Select the route and order.
3. Click the link with the number of items in the **Order items** field.
 
If the courier added a photo to any of the items, the **Photo** column will contain links to the photos.

![](./../_images/order-contents-back.png)

Order items can also be viewed by the companies added as [observers](https://docs.routeq.com/doc/en/delivery/functions/shared.md).

### Order with a partial return {#partial-delivery}

If a client returns some of the orders, the courier marks this with a comment in the Yandex Courier app and can also add photos for each item. For more information, see [Partial delivery if order items are specified](https://docs.routeq.com/doc/en/courier-app/functions/options.md#partial-delivery-contents).

To view information about delivered items and returns:

1. Go to **Track & Trace** → **Dashboard**.
2. Select the route and order. The **Order items** field will display a message that some items were returned.
3. Click the link with the number of items.

By default, the order items table displays all items.
   
Click **Items to return** to hide delivered items from the table. You'll see:

* Number of items to return.
* Number of products to return.
* Cost per item and total cost of returns.

![](./../_images/order-contents-back-filter.png)

If the courier added a photo to any of the items, the **Photo** column will contain links to the photos.

## Uploading order items via the API {#order-items-api}

You can upload and update order items information via the API:

<!-- * [добавить товарный состав заказа](https://yandex.ru/routing/doc/en/delivery/redoc/index.html#operation/addsOrderItems); -->
* [Get order items](https://yandex.ru/routing/doc/en/delivery/redoc/index.html#operation/getsOrderItems).
* [Add information about product returns](https://yandex.ru/routing/doc/en/delivery/redoc/index.html#operation/returnsOrderItems).
* [Delete item](https://yandex.ru/routing/doc/en/delivery/redoc/index.html#operation/deletesOrderItem).
<!-- * [удалить весь товарный состав заказа](https://yandex.ru/routing/doc/en/delivery/redoc/index.html#operation/deletesOrderItems). -->

{% include [warehouse-feedback](../_includes/feedback-7b71896f9bc3.md) %}