Skip to main content

Customer Sales History & Customer Orders Subseclection

The extension adds an ability to add a condition according to the customer's sales history.

Completed Orders Count​

The “Completed Order Count” is the number of customer’s orders with state “complete”, ie – shipped and non-fully refunded orders. (For more information about order states, see our article about the order state and status flow in Magento)

Lifetime Paid Amount​

The “Lifetime Paid Amount” is the sum of (total_paid – total_refunded) on all customer’s orders, in other words – lifetime paid amount (in store currency) of customer’s orders, excluding refunded amount.

Customer Orders Subselection​

If the previous two conditions are too limited for you, you can customize your condition using the "Customer Orders Subselection". Using this functionality, you can create advanced conditions based on customer orders.

Customer orders subselection condition in the dropdown

Fields Explanation​

  • If (number of created orders / average order grandtotal / sum of grandtotals) is – the aggregator on the orders matching the sub condition

The first field in the Customer Orders Subselection

  • For a subselection of orders matching ALL of these conditions – condition that defines the matching orders, on which the aggregator will be applied.

The second field in the Customer Orders Subselection

Condition Example​

The second field in the Customer Orders Subselection

This condition will only apply to customers who placed at least 2 orders that have status “Complete” or “Processing” in the last 10 days. Another way to read this condition is – customers who have at least 2 paid orders from the last 10 days.