---
title: "Country List Update"
slug: "country-list-update"
description: "Edit this template to update country factors, including product discounts and overrides, and review the impact to the country price list."
updated: 2022-12-13T00:08:17Z
published: 2022-12-13T00:08:17Z
canonical: "docs.zilliant.com/country-list-update"
---

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

# Country List Update template

## Objective

Use the recommendations in this template to update country factors, including product discounts and overrides, and review the impact to the country price list.

## Example flow

![Country List Update template flow](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/Country_List_Update_QS_Template.png?sv=2026-02-06&spr=https&st=2026-11-11T22%3A39%3A01Z&se=2026-11-11T23%3A39%3A01Z&sr=c&sp=r&sig=W6pH%2BrQ7an1DWAT6m3yXwMQR7yg06iSQQHmnNXhC7G8%3D)

## Edit data

1. Open the **Manage Country Prices** scenario workbook.  

When you created the scenario, this workbook was loaded with data from base and decision support workbooks.
2. Open the **Country Price Updates** worksheet.
3. In the **Discount Override**, **Price Override**, or **Margin Override** columns, enter values or upsert data from a CSV file. (If the columns aren't visible, select **>** to expand the **Adjustments** column.)

This calculates the **Proposed Price** or **Proposed Discount** values, as applicable.

1. In the **Proposed Start Date** column, update the date. (If the column isn't visible, select **>** to expand the **Publish Info** column.)

---

The following information shows how other columns, column groups, and KPI cards in this worksheet are calculated. Use this information for additional decision support.

#### Price at Margin Override

```
CASE 
    WHEN 1 - COALESCE ({Margin Override}, 0) = 0 THEN NULL 
    ELSE {Country Cost} / (1 - {Margin Override}) 
END
```

#### Proposed Price

```
COALESCE ({Price at Margin Override}, {Override}, {Discounted Price}, {Country Price})
```

#### Price Change

```
CASE 
    WHEN COALESCE ({Country Price}, 0) = 0 THEN NULL 
    ELSE ({Proposed Price} - {Country Price}) / {Country Price} 
END
```

#### New Discount

```
CASE 
    WHEN COALESCE ({Country List}, 0) = 0 THEN NULL 
    ELSE 1 - ({Proposed Price} / {Country List}) 
END
```

#### Discounted Price

```
{Country List} * (1 - COALESCE ({Discount Override}, {Current Discount}))
```

#### New Margin

```
CASE 
    WHEN COALESCE ({Proposed Price}, 0) = 0 THEN NULL 
    ELSE ({Proposed Price} - {Country Cost}) / {Proposed Price} 
END
```

---

1. In the **Proposed Discounts** and **Price Overrides** worksheets, review a summary of discounts and overrides. By default, these worksheets are filtered to show only records with values.

Update data in these worksheets as needed.

## Publish data

1. In the **Country Price Updates** worksheet, select the **Publish** checkbox for records that represent updated and final data. These records will be published back to the base and master data workbooks.
2. From the **Actions** menu, select **Publish**.

The selected records are synchronized with the **Country Discounts** and **Country Overrides** waterfall element workbooks.