Import Advanced Pricing
It is possible to import advanced pricing to Shopware 6 as part of your product update. The corresponding information can be added to a product CSV in the advanced_prices column.
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).
Note that you can replace the existing advanced prices with the ones specified in your CSV by activating the Replace Advanced Prices feature.