Hello,
I have been playing with the mailing list function and I must say it is quite neat.
However (of course there is a 'however' or I wouldn't be posting), I really would like to get the total order value in the report.
In case any one is interested I am trying to run reports to reward customers for spending between certain amounts. i.e spend over £100 in 2 orders or more and receive 5% discount, spend over £250 in 2 orders or more and receive 10% etc.
It seems I can run a report that will include all orders over £100 in 2 orders and then I was planning to divide it down in excel. Idea then being we add all the customers to groups (yes we are running Business) and apply discounts. Then we can email them and let them know.
Thing is, without the order value my plan is scuppered.
Angi
I have been playing with the mailing list function and I must say it is quite neat.
However (of course there is a 'however' or I wouldn't be posting), I really would like to get the total order value in the report.
In case any one is interested I am trying to run reports to reward customers for spending between certain amounts. i.e spend over £100 in 2 orders or more and receive 5% discount, spend over £250 in 2 orders or more and receive 10% etc.
It seems I can run a report that will include all orders over £100 in 2 orders and then I was planning to divide it down in excel. Idea then being we add all the customers to groups (yes we are running Business) and apply discounts. Then we can email them and let them know.
Thing is, without the order value my plan is scuppered.
Angi
Comment