Can I track sales by gallery in Smugmug?

KavikaKavika Registered Users Posts: 42 Big grins
edited August 29, 2007 in SmugMug Pro Sales Support
I shoot at a dozen schools in the fall, and I want to track sales by school, which is to say by gallery. Smugmug sends individual sales emails, and lumps all sales together in the cumulative sales report. How can I segregate my sales by school???

Comments

  • dragon300zxdragon300zx Registered Users Posts: 2,575 Major grins
    edited August 28, 2007
    Seeing as this is a smugmug specific question I have moved it to the smugmug pro specific thread for you. This should help you get better, faster replies.
    Everyone Has A Photographic Memory. Some Just Do Not Have Film.
    www.zxstudios.com
    http://creativedragonstudios.smugmug.com
  • AllenAllen Registered Users Posts: 10,013 Major grins
    edited August 28, 2007
    Kavika wrote:
    I shoot at a dozen schools in the fall, and I want to track sales by school, which is to say by gallery. Smugmug sends individual sales emails, and lumps all sales together in the cumulative sales report. How can I segregate my sales by school???
    Go into your control panel and click "sales details". At the top click "download".
    The Excell file will have a column for image. Just sort that column and you'll
    then have it sorted by gallery.
    Al - Just a volunteer here having fun
    My Website index | My Blog
  • AndyAndy Registered Users Posts: 50,016 Major grins
    edited August 28, 2007
    SmugSales is a neat spreadsheet app, too thumb.gif

    http://www.smugtools.com/SmugSales/Index.htm
    Andy

    Portfolio • Workshops • Facebook • Twitter
  • KavikaKavika Registered Users Posts: 42 Big grins
    edited August 28, 2007
    thanks guys
    :ivar I knew there had to be a way to do this ... just never found it before. Onward and upward!
    Allen wrote:
    Go into your control panel and click "sales details". At the top click "download".
    The Excell file will have a column for image. Just sort that column and you'll
    then have it sorted by gallery.
  • KavikaKavika Registered Users Posts: 42 Big grins
    edited August 29, 2007
    question #2 on tracking sales by gallery
    This may be elementary, but as I am not up to speed with using Excel for tracking sales ..... How do I limit that download of sales details from Smugmug to just sales going forward from today? I don't want to see all of last year's information, just new sales. Thanks very much!
    Allen wrote:
    Go into your control panel and click "sales details". At the top click "download".
    The Excell file will have a column for image. Just sort that column and you'll
    then have it sorted by gallery.
  • AndyAndy Registered Users Posts: 50,016 Major grins
    edited August 29, 2007
    Kavika wrote:
    This may be elementary, but as I am not up to speed with using Excel for tracking sales ..... How do I limit that download of sales details from Smugmug to just sales going forward from today? I don't want to see all of last year's information, just new sales. Thanks very much!
    You can't limit the download but you can sort or eliminate within Excel - there's a date column, so just trash or ignore what you don't want?
    Andy

    Portfolio • Workshops • Facebook • Twitter
Sign In or Register to comment.