---
title: Import Advanced Prices in Product Files
description: How to import advanced prices as part of a product update in Shopware 6 using the advanced_prices column.
---

Use this page when you import advanced prices through a product file instead of the separate Advanced Prices entity.

You can import advanced prices to Shopware 6 as part of a product update. Add the price-tier data to the `advanced_prices` column in your product CSV.

The value in this column should look as follows:

```
ruleId:046ca0774ef543d8b606c2e2cfd0d43d,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:0.8,priceGross:0.8,listPriceNet:1.0,listPriceGross:1.19,quantityStart:6,quantityEnd:|ruleId:046ca0774ef543d8b606c2e2cfd0d43d,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:0.9,priceGross:0.9,listPriceNet:1.1,listPriceGross:1.31,quantityStart:3,quantityEnd:5|ruleId:046ca0774ef543d8b606c2e2cfd0d43d,currencyId:b7d2554b0ce847cd82f3ac9bd1c0dfca,priceNet:1,priceGross:1,listPriceNet:1.2,listPriceGross:1.43,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 (with list price 1.2 Euro) if a customer orders 1-2 items.
2. The price is 0.9 Euro (with list price 1.1 Euro) if a customer orders 3-5 items.
3. The price is 0.8 Euro (with list price 1.0 Euro) if a customer orders 6 or more items.

## 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* |
| **listPriceNet** | A product list net price (MSRP/RRP before discount) used in this rule. Optional. | *1.0* |
| **listPriceGross** | A product list gross price (MSRP/RRP before discount) used in this rule. Optional. | *1.19* |
| **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* |

## Important Notes

- You can provide only **priceNet** OR **priceGross** — the system will automatically calculate the missing value using the product's tax rate.
- You can provide only **listPriceNet** OR **listPriceGross** — the system will automatically calculate the missing value using the product's tax rate.
- For automatic tax calculation to work, the product must already exist in Shopware with an assigned tax rate.
- **listPriceNet** and **listPriceGross** are optional fields used to show customers the original price before discount (commonly known as MSRP or RRP).

To replace existing advanced prices with the values from your CSV, enable **Replace Advanced Prices**.