Run a report for all sales for a season with zip codes

(Last Updated On: November 13, 2013)

In Wintix, go to:

  • Mailing List
  • Generate a Mailing List
  • Export Email –  That brings up the ‘Exporting email addresses window’
  • Choose spreadsheet
  • Uncheck the boxes labeled ‘skip records with a blank email address’ and ‘include only records that have opted in’
  • Click on the ‘Edit the query tab’
  • Highlight the text in that box and delete it
  • Then, copy and paste the query below in the box, by copying from this email, then with the cursor in that box, hold your CTRL key and hit v.  That will paste the query in that screen.
  • Click Export List
  • The list will be saved to your desktop and the name will be EmailExport_7-24-2013
  • That will give you a spread sheet listing all sales, with the zip code.
  • You can then sort the spread sheet by zip code and total up each zip using the spreadsheet tools.

select
customer.first, customer.last, customer.zip, customer.email
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.today_date >= ’20XX-XX-XX’ and mainsale.today_date <= ’20XX-XX-XX)
group by customer.customer_id
order by customer.last, customer.first

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

Leave a Reply