---
title: "Global List Update"
slug: "global-list-update"
description: "Edit this template to make global price list updates, which flow into country price lists."
updated: 2022-12-13T00:09:06Z
published: 2022-12-13T00:09:06Z
canonical: "docs.zilliant.com/global-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.

# Global List Update

## Objective

Use the recommendations in this template for global price list updates, which flow into country price lists.

## Example flow

![Global List Update template flow: global price list](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/Global_List_Update_template_flow_1.png?sv=2026-02-06&spr=https&st=2026-11-11T22%3A39%3A00Z&se=2026-11-11T23%3A39%3A00Z&sr=c&sp=r&sig=hT%2F1M%2FLnH9vQOgt%2FNs%2Bvcgg6LdUtksutXfjQvkHfuBY%3D)

![Global List Update template flow: country price lists](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/Global_List_Update_template_flow_2.png?sv=2026-02-06&spr=https&st=2026-11-11T22%3A39%3A00Z&se=2026-11-11T23%3A39%3A00Z&sr=c&sp=r&sig=hT%2F1M%2FLnH9vQOgt%2FNs%2Bvcgg6LdUtksutXfjQvkHfuBY%3D)

## Edit data

1. Open the **Manage Global List Prices** scenario workbook.

When you created the scenario, this workbook was loaded with data from base and decision support workbooks.

1. Open the **Update List Prices** worksheet.
2. In the **Proposed List** column, enter a value manually or upsert data from a CSV file.
3. In the **Proposed Start Date** column, select a start date.

---

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 Change

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

---

## Publish data

1. In the **Update List Prices** 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 **Global List** waterfall element workbook.