Referral Contest talllying?
Referral Contest talllying?
We would like to run a referral contest. When an existing customer refers a new customer and the new customer gives us their referrer's name, we planned to put it on the order as a non-inventory item. The problem is that it looks like the Items and Coupons report does not include 0.00 non-inventory as an option, only > and < 0. So we don't seem to have a way to tally this when the contest is over. Any ideas?
Re: Referral Contest talllying?
You will either need to put a value on the non-inventory item, maybe use an offset, or use a 3rd party SQL tool to look at the 0.00 entries in the database.
An offset would keep things in balance.
Scott
An offset would keep things in balance.
Code: Select all
Refer a friend: .01
John Smith -.01