> 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/guides-or-how-to.../configure-order-template-upload-to-erp.md).

# Configure order template (upload to ERP)

### Order spreadsheet

Customize the XLSX file Atlo attaches to order-received emails and makes available on the deal page. 

**The goal:** get an order file your ERP can import directly, so sending an order confirmation to your retail partner takes seconds.

{% embed url="<https://youtu.be/bn-Sthuu6mQ>" %}

#### Column mapping

Map an Atlo data field (left) to the column name your ERP expects (right).

* The source fields on the left come from your PIM and ERP data already connected to Atlo, so product IDs, EANs, prices, and attributes use the exact naming your systems use
* On the right, type the column header your ERP expects

#### Two ways to set it up

Option 1: Auto-map from file

* Upload your existing order template (the one you use today)
* Atlo reads the column headers and matches them against available source fields automatically
* Review, adjust if needed, save
* Fastest way to get set up

Option 2: Map manually

* Pick a source field on the left, type the target column name on the right
* Good for when you're setting up a new template from scratch
* Image options

#### Preview before you save

Click "Download sample.xlsx" to see exactly what the generated file looks like with your current mapping.

Use "Reset" to clear back to Atlo's defaults. "Save" applies the mapping to all future order files.

Image options Example of an order file generated with your custom mapping