Case Study

Customer segmentation

Viscata: VIP Customer Setup

Viscata needed a way to tell its best customers from the rest, not just its biggest spenders. We set up an automatic VIP tier that rewards customers who spend more than €500 and keep what they buy, with a return rate of 20% or lower.

badge

Total order value

More than €500

Return rate

20% or lower

Setup steps

4

VIP tagging

Automatic

Issue

Viscata had no way to tell its best customers from the rest. Two problems followed.

Spend alone was a poor measure

Customers who spend a lot but return many of their orders can cost more than they earn once shipping and handling are counted.

Loyal customers went unrecognised

Repeat buyers who keep what they buy got the same treatment as everyone else, which risked losing them to competitors.

Our Approach

We set up an automatic VIP tier. A customer qualifies only if both conditions are met.

01
Calculate

Calculate each customer’s total order value, order count and returned-order count.

02
Tag

Tag customers as VIP when both conditions are met.

03
Re-check

Re-check as new orders and returns come in, so customers can gain or lose VIP status.

04
Reward

Use the VIP tag for early access, exclusive offers and priority support.

What the VIP Tag Unlocks

Once a customer is tagged as VIP, the tag is used for three things.

Early access

VIP customers get early access.

Exclusive offers

VIP customers receive exclusive offers.

Priority support

VIP customers get priority support.

Results

The rules now run automatically, with no manual review, and Viscata has a clear VIP segment based on both value and return behaviour.

Real behaviour

VIP customers are identified by real purchase behaviour, not spend alone.

Margins protected

High-return customers no longer qualify.

Data-backed segment

Marketing can target a data-backed segment.

Want to reward your best customers with a VIP tier?

We craft custom solutions for Shopify and help brands build, grow, and optimize their Shopify stores.

© 2026 Mandasa Technologies. All rights reserved.