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

# Historical Order Upload

> How to create and upload a historical order file to Mention Me, including Shopify-specific instructions.

By uploading your customers' historical order data, you can access advanced features such as Extended Customer Revenue (ECR) and Predicted ECR sooner, as the algorithms will have enough data to start segmenting and predicting.

## Standard upload

To upload order data to Mention Me:

1. Create a CSV file
2. Populate it with data from the past three years using the fields below
3. **Important**: Ensure the merchant order IDs match exactly the IDs passed via other integrations

| Field             | Type                                                                                | Example                             |
| ----------------- | ----------------------------------------------------------------------------------- | ----------------------------------- |
| Customer Email    | Email (can be [hashed](/knowledge/security/data-management/hash-historical-emails)) | [name@xyz.com](mailto:name@xyz.com) |
| Merchant Order ID | Text                                                                                | Test001                             |
| Total             | Numeric                                                                             | 123.00                              |
| Currency          | [ISO 4217](https://en.wikipedia.org/wiki/ISO_4217)                                  | GBP                                 |
| Order Date String | [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601)                                  | 2023-01-19T12:41:43+00:00           |

4. Upload the CSV via [Secure Document Transfer](/knowledge/security/data-management/send-data-securely)
5. Name the file: `Brand name - Historical Order`
6. The Mention Me team will perform the upload and contact you when complete

## Hashed emails

If you prefer to send historical order data with hashed emails, see [Hash Historical Customer Emails](/knowledge/security/data-management/hash-historical-emails).

## Shopify export

If you use Shopify, follow these steps to export order data:

### 1. Navigate to Orders and export

Go to **Orders** in the left menu of your Shopify Store. Click **Export** above the orders list.

<img src="https://mintcdn.com/mentionme/GjiDi6ZwHP27Pu0w/images/knowledge/security/data-management/17811106812957.png?fit=max&auto=format&n=GjiDi6ZwHP27Pu0w&q=85&s=7cbd2f783f152d68529ed11d2c9f9898" alt="Shopify Orders page with Export button" width="3068" height="934" data-path="images/knowledge/security/data-management/17811106812957.png" />

### 2. Select export options

* **Export**: Orders by Date
* **Date range**: Select the start of the month three years ago through to the most recent order date (previous day).
* **Export as**: Plain CSV File
* Click **Export Orders**

<img src="https://mintcdn.com/mentionme/GjiDi6ZwHP27Pu0w/images/knowledge/security/data-management/17811106814749.png?fit=max&auto=format&n=GjiDi6ZwHP27Pu0w&q=85&s=3e630996bbedd76fea3fa009b46f7493" alt="Shopify export orders dialog with date range and CSV options" width="1538" height="1434" data-path="images/knowledge/security/data-management/17811106814749.png" />

<img src="https://mintcdn.com/mentionme/GjiDi6ZwHP27Pu0w/images/knowledge/security/data-management/17811069977757.png?fit=max&auto=format&n=GjiDi6ZwHP27Pu0w&q=85&s=5e6a66bb80941c21a4fb45a3cb7d573d" alt="Shopify export confirmation with email notification" width="1526" height="1452" data-path="images/knowledge/security/data-management/17811069977757.png" />

You will receive an email from Shopify with the CSV file to download.

### 3. Upload to Mention Me

Upload the CSV file to your Mention Me account via [Secure Document Transfer](/knowledge/security/data-management/send-data-securely) or directly at [Secure File Transfer](https://mention-me.com/merchant/~/files).

## Subscription model

If your business uses a Subscription Model, ensure the true value of your customers and their referrals can be tracked after onboarding. See [Subscription Data for Advocacy Features](/knowledge/reporting/advocacy/ecr) for more information.