Advanced discounts let you give a customer different discount percentages for specific subbrands, product categories, or a combination of the two — instead of a single flat discount. You set them up in the customer import sheet, alongside the rest of the customer's data.
This guide assumes you already know how to fill out and upload the customer import sheet. If not, start with Fill out the customer import sheet and How to map the customer import sheet in Traede (linked below).
Before you start
- The base Discount column applies one percentage to everything the customer buys. Advanced discounts override it for the products they match.
- Subbrands are identified by their ERP code and must already exist in TRAEDE.
- Categories are identified by name and must already exist in TRAEDE.
- Enter percentages as plain numbers, without a
%sign (e.g.10for 10%).
There are three optional columns. Each holds one or more rules, with commas separating multiple rules. Leave them blank if you only use the base discount.
Subbrand discount %
Sets a percentage per subbrand. Use the subbrand's ERP code, then a colon, then the percentage.
Example: subbrand-a:10,subbrand-b:5 gives 10% on Subbrand A and 5% on Subbrand B.
Category discount %
Sets a percentage per category. Use the category name, then the percentage. To target a sub-category, list the top category first, then the sub-category, then the percentage — each separated by a colon.
Example: Shoes:5,Shoes:Sneakers:10 gives 5% on the Shoes category and 10% on the Sneakers sub-category.
Advanced discount rules
Use this column when a discount depends on both a subbrand and a category, or when you want all of a customer's rules in one place. Each rule is built from labelled parts separated by semicolons:
subbrand=the subbrand ERP codecategory=the category name (use>to point to a sub-category, e.g.Shoes>Sneakers)discount=the percentage
Each rule needs a discount and at least one of subbrand or category. Separate multiple rules with commas.
Example: subbrand=subbrand-a;category=Shoes>Sneakers;discount=10,category=Shoes;discount=5 gives 10% on Sneakers from Subbrand A, and 5% on everything else in the Shoes category.
How discounts are applied
If a product matches one of these rules, that rule's percentage is used instead of the base Discount for that product. Products that don't match any rule keep the base discount.
Tip: Avoid creating rules that could match the same product in more than one way (for example, a subbrand rule and a category rule that both cover the same product).
Important: When you re-import a customer using the Advanced discount rules column, it replaces that customer's full set of advanced discounts — any rule you leave out of the sheet is removed. Always include all of a customer's rules each time you import.
Discount columns at a glance
| Column | What it does | Example |
|---|---|---|
| Discount | Base discount applied to everything | 10 |
| Subbrand discount % | Discount per subbrand, identified by ERP code | subbrand-a:10,subbrand-b:5 |
| Category discount % | Discount per category or sub-category | Shoes:5,Shoes:Sneakers:10 |
| Advanced discount rules | Combine subbrand and category in a single rule | subbrand=subbrand-a;category=Shoes>Sneakers;discount=10 |