---
title: "Order Tracking Import"
slug: "order-tracking-import"
tags: ["Store", "Allocations", "Classic WineDirect"]
updated: 2023-06-13T22:21:38Z
published: 2023-06-13T22:21:38Z
canonical: "docs.winedirect.com/order-tracking-import"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.winedirect.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Order Tracking Import

The Order Tracking Import tool lets you easily import Tracking numbers from your fulfillment house. Follow the steps to learn how to import tracking numbers and ship dates to the correct order numbers in WineDirect:

 **PC users:** Excel files must be saved in **.xls format (excel workbook).**   
 **Mac users:** Excel files must be saved in **.xlsx format (excel workbook)**

---

## Download Sample File

1. Navigate to **Settings** **> Import/Export > Order Tracking Import.**

2. In the pop-up window, click **Download Sample File**. This will have the correct formatting to import your tracking numbers and ship dates into WineDirect.

---

## Fill out the Sample File

Below is a table with all of the column headers that you will see and the information that should be input.

All headers must stay the same in your spreadsheet as you have downloaded it. If you d  not have any information to enter into a column, you leave the fields in the column blank but the column header in your sheet. The three columns that must be filled out for a successful import are Order Number, Tracking Number, and ShipDate.WineDirect's Order Tracking Import tool allows you to Import multiple Tracking Numbers simultaneously. You can o so by adding a new line with the same Order Number and then a unique Tracking Number to this line- both Tracking Numbers will display on the designated Order Number. 

| *OrderNumber | The order number for the order being shipped. |
| --- | --- |
| *TrackingNumber | The tracking number for the order being shipped. |
| Carrier | The tracking number for the order being shipped. The carr er name spelling MUST match one of the following: UPS, FedEx, GSO, CanadaPost, or Other. |
| *ShipDate | The date on which the order was shipped. Example: MM/DD/YYYY ( AUS Clients use YYYY-MM-DD ) |

***Mandatory Fields:** OrderNumber, TrackingNumber, ShipDate

---

## Import Order Tracking Data

1. Once the data is complete in the sample file, you can navigate back to **Settings > Import/Export > Order Tracking Importer**.

2. Here, you can indi ate if you want an email to go out to all the email addresses connected to each order number. To do this, check the **Sends Order Tracking Email** box. This will send to all of the orders' billing email addresses, and there is no functionality to edit who the email is sent.

![](https://documentation.vin65.com/assets/client/Image/TrackingImporter1.png)

3. Next, **Browse** your computer for the saved file. Click Import.

For the import to run successfully, you must ensure that your excel file is closed on your computer while running the essence.