---
title: "Create constraints"
slug: "create-constraints"
description: "Create bound and spread constraints—specific conditions that the variables in the optimization problem must satisfy."
updated: 2024-01-16T17:27:27Z
published: 2024-01-16T17:27:27Z
canonical: "docs.zilliant.com/create-constraints"
---

> ## 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.

# Create constraints

Important

          

This topic is designed for use only by configuration teams.

Constraints are specific conditions that the variables in the optimization problem must satisfy.

Learn how to:

- [Create a bound constraint](/v1/docs/create-constraints#create-a-bound-constraint)
- [Create a spread constraint](/v1/docs/create-constraints#create-a-spread-constraint)

          Note

          

To apply new constraint configurations in an existing scenario, [optimize prices](/v1/docs/optimize-prices) in it. You don't have to rebuild the scenario.

## Create a bound constraint

Bound constraints usually operate within a segment, setting upper or lower limits for markup, discounts from the list price, margin rates, or prices. For example, these constraints ensure that price recommendations neither fall below the cost nor exceed the competitor prices.

To create a bound constraint:

1. From the Price IQ Manager Dashboard, expand the **Setup** folder.
2. Select the **Scenario Config** workbook.
3. On the **Fields** worksheet, locate a row with the column you want to use as a bound constraint and select the **Solver Parameter** checkbox.
4. On the **Constraint Setup** worksheet, select Insert Row.
5. Enter information or make selections to create a constraint. To learn how to fill in the fields, read about the [Constraint Setup](/v1/docs/price-iq-scenario-configuration#constraint-setup) worksheet.
6. Select **Save**.

## Create a spread constraint

Spread constraints typically operate across segments, establishing a minimum or maximum gap between two values of a field. For example, a spread constraint can ensure that price recommendations for large customers are at least 2% lower than those for small customers. Additionally, spread constraints regulate the minimum and maximum gaps between the start and target or between the target and floor price points.

To create a spread constraint:

1. From the Price IQ Manager Dashboard, expand the **Setup** folder.
2. Select the **Scenario Config** workbook.
3. On the **Constraint Setup** worksheet, select Insert Row.
4. Enter information or make selections to create a constraint. To learn how to fill in the fields, read about the [Constraint Setup](/v1/docs/price-iq-scenario-configuration#constraint-setup) worksheet.
5. Select **Save**.
6. On the **Spread Mapping** worksheet, select Insert Row.
7. Enter information or make selections to configure a constraint. To learn how to fill in the fields, read about the [Spread Mapping](/v1/docs/price-iq-scenario-configuration#spread-mapping) worksheet.
8. Select **Save**.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/add_60.png?sv=2026-02-06&spr=https&st=2026-11-12T13%3A12%3A07Z&se=2026-11-12T14%3A12%3A07Z&sr=c&sp=r&sig=l%2F7IYgQgsk9pDWjnim%2FtWI%2F64FdbzxEJUC8kCvtJsTw%3D)

Insert Row