Three tables behind every order

A store keeps its promotions, shipping and returns in three decision tables (23 rules). Change the customer, the basket or where it ships, and every answer comes back live with the rule that decided it. The bars show the same order at every basket value, so you can see where each threshold sits.

Customer
Category
Ships to
Answers
–
Round trip
–

Promotion

–

–

This order at every basket value, €10 to €400

Shipping

–

–

This order at every basket value, €10 to €400

Return

–

–

This return on every day after delivery, 0 to 90

How it works

  1. Three tables for one order

    Promotions decide the discount from the customer tier, basket value and category. Shipping decides the option and price from the destination, weight and basket. Returns decide what a return gets back from the category, the days since delivery and the tier.

  2. Every basket value at once

    Each change sends the order at every basket value from €10 to €400 in €5 steps (and every return day up to 90) in one batch per table. The bars show where each threshold sits.

  3. The rule that decided

    Every answer comes back with the position of the rule that matched, so a merchandiser can see why a basket got its discount or its shipping price.

  4. Change a campaign by editing a row

    Moving a discount threshold, a no-charge shipping limit or a return window is a change to one row, previewed on every case and live without a release of the store.

1 · Promotions 9 rules · first match wins

Policy summaryNo discount on electronics under €200. VIP: 20% off from €100, otherwise 15%. Electronics: 5% off. Members: 15% off from €150, 10% from €75, otherwise 5%. New customers: 10% off a first order from €50. Otherwise no discount.

# Customer tierBasket valueCategory Discount Hits
1 ·< 200Electronics No discount
2 VIP≥ 100· 20% off
3 VIP·· 15% off
4 ··Electronics 5% off
5 Member≥ 150· 15% off
6 Member≥ 75· 10% off
7 New≥ 50· 10% off first order
8 Member·· 5% off
9 ··· No discount
2 · Shipping 8 rules · first match wins

Policy summaryOver 30 kg goes by freight, priced on request. Domestic: no charge from €50, otherwise €4.95. EU: no charge from €100, otherwise €9.95. UK: €14.95 with duties shown at checkout. US: €39 express over 10 kg, otherwise €24.

# DestinationWeight (kg)Basket value Shipping Hits
1 ·> 30· Freight, priced on request
2 Domestic·≥ 50 Standard, no charge
3 Domestic·· Standard, €4.95
4 EU·≥ 100 Standard, no charge
5 EU·· Standard, €9.95
6 UK·· Standard, €14.95 with duties
7 US> 10· Express, €39
8 US·· Express, €24
3 · Returns 6 rules · first match wins

Policy summaryBeauty can't be returned after 14 days. Nothing after 60 days. VIPs get a refund within 60 days. After 30 days, store credit. Electronics after 14 days: exchange only. Otherwise a refund.

# CategoryDays since deliveryCustomer tier Outcome Hits
1 Beauty> 14· Not returnable
2 ·> 60· Not returnable
3 ··VIP Refund
4 ·> 30· Store credit
5 Electronics> 14· Exchange only
6 ··· Refund

Prices, thresholds and return windows are illustrative.

Try it on your own checkout. In our cloud or on your server.

Try it in our cloud for 14 days with no card needed, or run it on your own server.