> For the complete documentation index, see [llms.txt](https://docs.eu-pactum.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.eu-pactum.com/price-lists/onboarding/prepare-your-data.md).

# Prepare your data

What to export from your ERP, which fields matter and what to check before you send it. There are two kinds of data:

* **Purchasing data** fills Portfolio and drives opportunities. Pactum imports it. See [Deliver your data](https://docs.eu-pactum.com/price-lists/onboarding/deliver-your-data.md).
* **A negotiation spreadsheet** creates negotiations directly. You upload it on **Negotiations**. See [The negotiation spreadsheet](#the-negotiation-spreadsheet).

## Data readiness checklist

* [ ] Purchase order lines for at least the last two full years, three if you have them.
* [ ] Every line has a material number, supplier, order date, quantity, price and currency.
* [ ] Agreed prices (info records or contract prices) with the date each price became valid.
* [ ] A monthly demand forecast for the coming months, if you plan one.
* [ ] An email address for at least one contact at each supplier you want to negotiate with.
* [ ] Returns and credits included, not filtered out.

Two full years let Price Lists compare the last 12 months with the 12 before (**Δ Price YoY**); three calendar years give **CAGR (3yr)**. See the [Glossary](https://docs.eu-pactum.com/price-lists/reference/glossary.md).

## Purchasing data

Pactum can map your own ERP export, so you don't need to rename columns. Without a fixed export, two formats work as they are:

* **SAP purchase order export**: one sheet of PO lines with the standard SAP column headers. Ask the Pactum Assistant "Do you have a template?" to get an empty file with the exact headers. See [Deliver your data](https://docs.eu-pactum.com/price-lists/onboarding/deliver-your-data.md#upload-a-file-to-the-assistant).
* **ERP workbook**: one Excel file with four sheets: purchase order lines, purchasing info records (agreed prices), vendor master and a monthly demand forecast. Ask your Pactum contact for the column list. Order lines load only when an info record exists for the same supplier, material and plant, so orders without one are left out.

| Field                                  | Required?                                           | Typically found in        | Notes                                                                                                                                                                                                    |
| -------------------------------------- | --------------------------------------------------- | ------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Material number                        | Required                                            | PO lines, material master | Lines without one are skipped.                                                                                                                                                                           |
| Material description                   | Recommended                                         | Material master           | Shown as the material's name. In the SAP export the Short Text column must be present; the value can be empty.                                                                                           |
| Supplier ID and name                   | Required                                            | PO lines, vendor master   | In the SAP export, both sit in one cell, ID first, separated by at least two spaces.                                                                                                                     |
| Order date                             | Required                                            | PO lines                  |                                                                                                                                                                                                          |
| Order quantity                         | Required                                            | PO lines                  | Returns and credits: as negative quantities, or in the ERP workbook as positive quantities with the return flag set.                                                                                     |
| Net price, price unit, currency        | Required                                            | PO lines                  | A price per 100 or 1,000 is fine: Price Lists divides by the price unit. 3-letter currency codes.                                                                                                        |
| Unit of measure                        | Recommended                                         | PO lines                  | In the SAP export the Order Unit column must be present; the value can be empty.                                                                                                                         |
| PO number and line                     | Required in the SAP export, recommended otherwise   | PO lines                  | Lets a re-delivered line update the existing one instead of adding a copy.                                                                                                                               |
| Plant                                  | Recommended (required in the ERP workbook)          | PO lines, info records    | Prices often differ by plant. See **Plant** in the [Glossary](https://docs.eu-pactum.com/price-lists/reference/glossary.md). In the SAP export the Plant column must be present; the value can be empty. |
| Agreed price and valid-from date       | Required in the ERP workbook, recommended otherwise | Info records, contracts   | Sets the [current price](https://docs.eu-pactum.com/price-lists/reference/glossary.md) when it is newer than your latest order.                                                                          |
| Sales unit conversion                  | Recommended if pack sizes differ                    | Info records              | See **Sales unit** in the [Glossary](https://docs.eu-pactum.com/price-lists/reference/glossary.md).                                                                                                      |
| Monthly demand forecast                | Recommended                                         | Planning (MRP)            | Fills **Forecasted spend** and supports demand-based opportunities.                                                                                                                                      |
| Supplier contact email                 | Recommended                                         | Vendor master             | Needed to negotiate. You can also add contacts later on the supplier's page.                                                                                                                             |
| Material group or category             | Optional                                            | Material master           | Groups materials by category. In the SAP export the Material Group column must be present; the value can be empty.                                                                                       |
| Delivery dates and received quantities | Optional                                            | PO lines                  | Used to spot late or short deliveries.                                                                                                                                                                   |
| Contract end dates                     | Optional                                            | Contracts                 | Flags contracts due for renewal.                                                                                                                                                                         |

## Quality checks before you send

* **One header row, in the first row, with the same headers every delivery.** Headers are matched exactly, including capitals.
* **The same material number everywhere.** Numbers with letters must match character for character across files. Purely numeric numbers match with or without leading zeros.
* **Deleted or cancelled order lines filtered out.** The ERP workbook skips lines whose deletion flag is set; the SAP export loads every line it gets.
* **Prices are believable.** Spot-check a few materials: net price divided by price unit should be what you pay per unit.
* **Currency on every line.**
* **Full history in every scheduled delivery.** Depending on your format, a scheduled import may replace the order history Price Lists holds for each material and supplier in the file, so a file with only last month's orders can remove the earlier ones. Order and forecast rows you added or edited in Price Lists are kept. See [Materials](https://docs.eu-pactum.com/price-lists/portfolio/materials.md).

Credits and returns reduce spend. Where an order has a quantity but no price, Price Lists fills in an **Estimated** amount. See [Portfolio metrics](https://docs.eu-pactum.com/price-lists/reference/savings-spend-and-metrics.md#portfolio-metrics).

## The negotiation spreadsheet

Get the current template in the app: on **Negotiations**, click **Upload negotiations**, choose **Fill in Data Manually**, then **Download**. Each sheet describes its columns. For the upload steps, see [Create negotiations](https://docs.eu-pactum.com/price-lists/negotiations/create-negotiations.md).

| Sheet                   | Required?                                   | Notes                                                                                                                                                                                                                                                                                      |
| ----------------------- | ------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Negotiation details     | Required                                    | One row per negotiation. Needs **Negotiation title**, **Negotiation ID**, buyer name, email and organization, **Supplier company name**, **Supplier email**, **Negotiation trigger type** and **Negotiation deadline** (YYYY-MM-DD). A past deadline becomes 15 days from the upload date. |
| Materials               | Required                                    | One row per material, linked by **Negotiation ID**. Needs **Material ID** (unique within the negotiation), **Material name**, **Material price** (above 0), **Currency**, **Unit of measure** and **Material competition likelihood** (NONE, SOME, SIGNIFICANT or UNKNOWN).                |
| Historic demand         | Required in practice                        | Yearly volume per material. Every material needs at least one row, or the negotiation can't be created.                                                                                                                                                                                    |
| Price history           | Optional                                    | Monthly prices. The template calls it a required sheet, but you can leave it empty.                                                                                                                                                                                                        |
| Overall volume forecast | Optional                                    | Yearly forecast volume.                                                                                                                                                                                                                                                                    |
| Project volume forecast | Required for Project Volume Demand Increase | Replaces historic demand for that trigger: every material needs at least one row. Also fill **Start of production date** on the Materials sheet.                                                                                                                                           |

* **Leave unused cells completely empty**, not 0 or a space.
* A blank **Acceptance limit** is set 1% below the material price. A blank **Goal price** is calculated for you.
* **Material cost components** use codes from the "(Reference data) Commodity Indices" sheet, for example `steel-us-01|30%`. You can leave them out: Price Lists proposes cost structures itself.

## Related

* [How onboarding works](https://docs.eu-pactum.com/price-lists/onboarding.md)
* [Deliver your data](https://docs.eu-pactum.com/price-lists/onboarding/deliver-your-data.md)
* [Create negotiations](https://docs.eu-pactum.com/price-lists/negotiations/create-negotiations.md)
* [Savings, spend and metrics](https://docs.eu-pactum.com/price-lists/reference/savings-spend-and-metrics.md)
* [Glossary](https://docs.eu-pactum.com/price-lists/reference/glossary.md)
