Import Advanced Prices in Product Files
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:2This 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:
- The price is 1 Euro (with list price 1.2 Euro) if a customer orders 1-2 items.
- The price is 0.9 Euro (with list price 1.1 Euro) if a customer orders 3-5 items.
- The price is 0.8 Euro (with list price 1.0 Euro) if a customer orders 6 or more items.
Field Reference
Section titled “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
Section titled “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.