---
title: Advanced Prices Column Format
description: The advanced_prices column format for importing quantity-based price tiers as part of a product CSV in Shopware 6.
---

Use this format when your product import file includes the `advanced_prices` column.

You can import advanced prices to Shopware 6 as part of a product update by adding the required tier data to the `advanced_prices` column.

![](https://firebearstudio.com/blog/wp-content/uploads/2024/02/advanced-prices.jpg)

The value in this column should look as follows:

```
ruleId:046ca0774ef543d8b606c2e2cfd0d43d,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:0.8,priceGross:0.8,quantityStart:6,quantityEnd:|ruleId:046ca0774ef543d8b606c2e2cfd0d43d,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:0.9,priceGross:0.9,quantityStart:3,quantityEnd:5|ruleId:046ca0774ef543d8b606c2e2cfd0d43d,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:1,priceGross:1,quantityStart:1,quantityEnd:2
```

This complex value consists of attributes and values that describe multiple rules or price tiers. Tiers are separated by a pipe (`|`), and the attributes within each tier are separated by a comma (`,`).

The value above represents the following three price tiers:

1. The price is 1 Euro if a customer orders 1-2 items.
2. The price is 0.9 Euro if a customer orders 3-5 items.
3. The price is 0.8 Euro if a customer orders 6 or more items.

![](https://firebearstudio.com/blog/wp-content/uploads/2024/02/tiers.jpg)

## Field Reference

| Column Name | Description | Value |
| --- | --- | --- |
| `ruleId` | The alphanumerical rule ID used in Shopware. | *046ca0774ef543d8b606c2e2cfd0d43d* |
| `currencyId` | The alphanumerical currency ID used in Shopware. | *b7d2554b0ce847cd82f3ac9bd1c0dfca* |
| `priceNet` | A product net price used in this rule. | *0.8* |
| `priceGross` | A product gross price used in this rule. | *0.8* |
| `quantityStart` | The minimum amount of items that should be purchased to apply the rule. | *6* |
| `quantityEnd` | The maximum amount of items that should be purchased to apply the rule. Leave blank to set the upper limit to infinity. | *8* |

Note that you can replace the existing advanced prices with the ones specified in your CSV by activating the **Replace Advanced Prices** feature.

![](https://firebearstudio.com/blog/wp-content/uploads/2024/02/replace-advanced-prices.jpg)