> For the complete documentation index, see [llms.txt](https://atlo-1.gitbook.io/atlo-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://atlo-1.gitbook.io/atlo-docs/getting-started/upload-order-data-erp-export.md).

# Upload order data (ERP export)

When you start your onboarding, or want to update your data, you need to upload an export of your ERP data.

Your ERP is where you keep all customer orders, invoicing, inventory, etc. It's the backbone of any wholesale company. Examples can be SPY, SAP, Microsoft Business Central, etc. 

### Here's how you upload

[Direct link to onboarding](https://admin.atlo.io/onboarding)

#### 1. Click "Get Started"

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FJYitcWQMev4kVLrMdyUl%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2010.44.59.png?alt=media&amp;token=d4b04149-72cd-46c0-aa54-65a6f03c11cb" alt="" width="563"><figcaption><p>How it looks when you start onboarding</p></figcaption></figure>

#### 2. Download example file

{% hint style="info" %}
You can download an example file of an upload file, if you manually have to select fields to export from your ERP. \
\
Remember, it's better just to upload everything. Don't change any of the data. Our system automatically filters everything so it's easy for you to set up.
{% endhint %}

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FjhpC8oELuBuea1JqXVXQ%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2010.48.35.png?alt=media&amp;token=2cf2344a-c233-471b-8432-af034eccc5ce" alt=""><figcaption></figcaption></figure>

<div align="left"><figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FJzZOrLddE9wqBbFqWDjx%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2010.57.12.png?alt=media&amp;token=75de4d7b-a579-4bf1-abd7-2fdddc24edc5" alt="" width="495"><figcaption><p>Screenshot of the ERP data example file</p></figcaption></figure></div>

Use the example file to check the data of your ERP.

#### 3. Click "Orders/ERP"

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FJuw9uHtWehCxQuJAlD4w%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2010.48.35.png?alt=media&amp;token=6be294fa-d985-48bf-8059-802fb2ffa61d" alt=""><figcaption></figcaption></figure>

#### 4. Upload ERP data

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FCuPVK3esWFxq16D1cIps%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2011.00.59.png?alt=media&amp;token=94c21e98-4ec6-48ec-b857-e49034232892" alt=""><figcaption></figcaption></figure>

**Required columns**

* Order ID
  * The unique order ID from a single customer - same number can contain multiple products on multiple lines
* Product ID&#x20;
  * The unique product ID. Can also be called your external product ID (this has to match the same ID you share in your product data upload/PIM)
* Customer ID
  * Unique ID for a single customer
* Line Quantity
  * The total number of products in a given order
* Line Total
  * The total amount paid by your customer for the total order, or the unique line with a single product
* Order Date
  * The date the order was shipped. Not when it was ordered.

**Optional columns**

* Customer Name
  * E.g. "Connox", "Nordic Nest", etc. It's the legal used for invoicing in your ERP.
* Currency
  * The currency the order is offered in&#x20;

#### 5. Review and map each column

Your ERP data is uploaded and each column identified. Now, just map out each one so each field above matches what it's called in your ERP data export.

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FTGKm0lJ0wzKPXzqjkxcu%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2011.49.35.png?alt=media&amp;token=bcb9b516-8765-44e8-8cfc-180300fb7bd6" alt=""><figcaption></figcaption></figure>

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FQ34SgiqOQK1wUcqz8zm6%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2011.49.30.png?alt=media&amp;token=d4326bb7-c37b-40ac-ab4f-2acf5dce7deb" alt=""><figcaption></figcaption></figure>

Click "Confirm" when everything has been mapped.

#### 6. Review and upload&#x20;

Review and click "Upload" if everything looks good.

If not, click "Back" and make sure each field is mapped out correctly.

<figure><img src="https://4094335229-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9H1XekXw7rbczFp51NxN%2Fuploads%2FjVRK8C4VFZeogsnTOsYI%2FSk%C3%A6rmbillede%202026-01-30%20kl.%2011.51.32.png?alt=media&amp;token=ce314923-d2df-43e8-97fb-f3ff087b76fe" alt=""><figcaption></figcaption></figure>

You're now for the product data upload.