How to run a report for all sales done using a specific promo code

(Last Updated On: September 23, 2015)

In Wintix:

  • Select Mailing list | Generate a mailing list | Export email
  • Click on the Edit the query tab
  • Check to make sure Spreadsheet is selected as your Output file type

edit query

  • You will need to copy and paste the following into the query box:

select
mainsale.sale_num, customer.first, customer.last, customer.email, mainsale.promocode, mainsale.abbrev, mainsale.show_date, mainsale.spec_tix, mainsale.spec_price
from mainsale
left join customer on customer.customer_id=mainsale.customer_id
left join master on mainsale.master_id=master.master_id
left join shows on mainsale.shows_id=shows.shows_id
where mainsale.promocode=”abc”
order by customer.last, customer.first

  • The only other thing you will need to do after copying and pasting this query into the Export email function in Wintix, is to change:
    • mainsale.promocode=”abc”
    • change “abc” to whatever promo code you’re running the report for

promo code 5

  • The above query lists the customer name, email address and sale number.  If those items are not necessary for your report, then just remove them from the query.
  • Here is an example of how the report looks:

promo code 6

This entry was posted in Desktop Software, Reports, Wintix5 and tagged . Bookmark the permalink.

Leave a Reply