SmugMug Price List Spreadsheet

JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
edited December 4, 2016 in SmugMug Pro Sales Support
Howdy,

For anyone that's interested, I have created a spreadsheet with all of the SmugMug products and pricing in it. I'm using it as an offline price list as well as to work out prices and margins before updating them on the Smug interface. I've also included some other automatic calculations like image size ratios, etc.

If anyone would like a copy (to save you the time of typing it up yourself) let me know and I'll figure out a way to get it to you. :thumb

Added Aug-18-2010

Now that I've posted it to my site, I thought I'd add the link up here on the first post so it's easier to find.

SmugMug Price Sheet

Enjoy
James Cole
writer - photographer
www.jcdaydream.com
«1

Comments

  • ChatKatChatKat Registered Users Posts: 1,357 Major grins
    edited August 8, 2010
    Thanks
    I'd love a copy of that spreadsheet. If it's Excel, you can email it.

    Kathy Rappaport
    Flash Frozen Photography, Inc.
    http://flashfrozenphotography.com
  • denisegoldbergdenisegoldberg Administrators Posts: 14,220 moderator
    edited August 8, 2010
    I'd love a copy too.

    Do you have a dropbox account? The free account would work for this. That would be a good place to stash the spreadsheet.

    Thanks.

    --- Denise
  • Art ScottArt Scott Registered Users Posts: 8,959 Major grins
    edited August 8, 2010
    I too would like a copy...

    Thanx
    "Genuine Fractals was, is and will always be the best solution for enlarging digital photos." ....Vincent Versace ... ... COPYRIGHT YOUR WORK ONLINE ... ... My Website

  • JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
    edited August 8, 2010
    Hey Guys,

    Glad to see there's a few of you that would like it. I think I'll put it up on a web page for easy download, save emailing it out separately. That way you'll be able to pick if you want the Excel or iWork versions.
    I've got a couple of shoots on today but will put it up later on tonight or first thing in the morning and then post the link here.

    Thanks for showing an interest :)
    James Cole
    writer - photographer
    www.jcdaydream.com
  • lizziejanelizziejane Registered Users Posts: 39 Big grins
    edited August 9, 2010
    JCDaydream wrote: »
    Hey Guys,

    Glad to see there's a few of you that would like it. I think I'll put it up on a web page for easy download, save emailing it out separately. That way you'll be able to pick if you want the Excel or iWork versions.
    I've got a couple of shoots on today but will put it up later on tonight or first thing in the morning and then post the link here.

    Thanks for showing an interest :)

    I'm definitely interested - I was just thinking what a pain in the butt it was going to be to do up a printed price list... Thanks for offering to share your hard work thumb.gif
  • xiaoyingxiaoying Registered Users Posts: 2 Beginner grinner
    edited August 11, 2010
    yeah thanks! :) I've love to have one too
    Looking forward to your upload!
  • CindyCindy Registered Users Posts: 542 Major grins
    edited August 12, 2010
    JCDaydream wrote: »
    Hey Guys,

    Glad to see there's a few of you that would like it. I think I'll put it up on a web page for easy download, save emailing it out separately. That way you'll be able to pick if you want the Excel or iWork versions.
    I've got a couple of shoots on today but will put it up later on tonight or first thing in the morning and then post the link here.

    Thanks for showing an interest :)

    Looking forward to the spreadsheet and watching for the link. Thanks so much! clap.gif
    Cindy Colbert (Utterback) • Wishing You Co-Bear Love, Hugs & Laughter!!!
  • JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
    edited August 12, 2010
    Howdy guys, Sorry for the delay. I wanted to run it past the SmugMug team first to make sure they didn't have any issues with me giving away this info but they haven't responded. I figure if it's not a clear NO then it must be a YES so here's the link.

    SmugMug Price Sheet

    Enjoy thumb.gif
    James Cole
    writer - photographer
    www.jcdaydream.com
  • KBedoreKBedore Registered Users Posts: 16 Big grins
    edited August 13, 2010
    Thanks for the spreadsheet! This saved me hours of work. I put everything in spreadsheets, but haven't gotten around to this one yet - still working on my site.
  • JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
    edited August 13, 2010
    KBedore wrote: »
    Thanks for the spreadsheet! This saved me hours of work. I put everything in spreadsheets, but haven't gotten around to this one yet - still working on my site.

    You are very welcome :)

    I'm glad that you're finding it useful.
    James Cole
    writer - photographer
    www.jcdaydream.com
  • lisaplisap Registered Users Posts: 294 Major grins
    edited August 14, 2010
    Thanks so much for sharing this :)
  • JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
    edited August 14, 2010
    lisap wrote: »
    Thanks so much for sharing this :)
    You're welcome.

    I'm just happy people are appreciating and using it. Makes the effort worth while :)
    James Cole
    writer - photographer
    www.jcdaydream.com
  • justusjustus Registered Users Posts: 145 Major grins
    edited August 15, 2010
    Spreadsheet
    Thanks ever so much, James! Love your photos too!
    Linda
    Justus Photography
    www.lindasherrill.com
  • pmbpropmbpro Registered Users Posts: 236 Major grins
    edited August 15, 2010
    Thanks again James! I really appreciate your generosity and hard work in creating this database/spreadsheet, sharing it with us. <img src="https://us.v-cdn.net/6029383/emoji/bowdown.gif&quot; border="0" alt="" >

    I haven't upgraded to SmugMug Pro yet, but I see it coming in very handy already! <img src="https://us.v-cdn.net/6029383/emoji/thumb.gif&quot; border="0" alt="" >

    All the best to you, and happy shooting!



    </p.s.>
    pmb images
    Film/TV Stills Photography
    "When your work speaks for itself, don't interrupt." ~ Henry J. Kaiser
  • aaronbrownaaronbrown Registered Users Posts: 146 Major grins
    edited August 17, 2010
    You rule! Let me also add my MANY THANKS!
  • PhotoDavid78PhotoDavid78 Registered Users Posts: 939 Major grins
    edited August 17, 2010
    I would love a copy!!
    David Weiss | Canon 5D Mark III | FujiFilm XT-4 | iPhone
    My Website
    Facebook | Twitter | | VSCOgrid | Instagram |
  • pmbpropmbpro Registered Users Posts: 236 Major grins
    edited August 17, 2010
    dtw78 wrote: »
    I would love a copy!!

    He posted the link a few days ago further up, on Aug 12, so you can grab it now. It's great! thumb.gif
    pmb images
    Film/TV Stills Photography
    "When your work speaks for itself, don't interrupt." ~ Henry J. Kaiser
  • PhotoDavid78PhotoDavid78 Registered Users Posts: 939 Major grins
    edited August 17, 2010
    pmbpro wrote: »
    He posted the link a few days ago further up, on Aug 12, so you can grab it now. It's great! thumb.gif

    great, got it
    David Weiss | Canon 5D Mark III | FujiFilm XT-4 | iPhone
    My Website
    Facebook | Twitter | | VSCOgrid | Instagram |
  • JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
    edited August 17, 2010
    aaronbrown wrote: »
    You rule! Let me also add my MANY THANKS!

    Thanks Aaron, glad you can use it.
    James Cole
    writer - photographer
    www.jcdaydream.com
  • JCDaydreamJCDaydream Registered Users Posts: 13 Big grins
    edited August 17, 2010
    pmbpro wrote: »
    He posted the link a few days ago further up, on Aug 12, so you can grab it now. It's great! thumb.gif

    Thanks for pointing that out, I've now added the link to the first post to make it easier to find for anyone in the future.
    James Cole
    writer - photographer
    www.jcdaydream.com
  • coffenutcoffenut Registered Users Posts: 1 Beginner grinner
    edited October 18, 2010
    Oh bless you for this. I had just asked the heros if something like this existed and they said "no". I was dreading trying to create one!! You have made my day!
  • SpeakoffSpeakoff Registered Users Posts: 39 Big grins
    edited October 21, 2010
    Oh my goodness, this is fantastic. Thank you, JC! I have been avoiding making my price list for weeks! A big virtual high-five to you!
  • Not A BoothNot A Booth Registered Users Posts: 15 Big grins
    edited October 23, 2010
    Thank you for posting this spreadsheet! It is extremely helpful and exactly what I was looking for. The only thing I could imaging better is a "Export pricing to spreadsheet" feature on SM, so I don't have to manually enter my custom prices. :)



    I just have one nitpicky correction to make in the spreadsheet. The way it is, the Markup columns are off by 100%. For example, if you put your sale price for a 4x6 Lustre at EZ Prints as $0.21, it reports the markup as 100%. If you put the price s $0.42, it reports the markup as 200%. They should be 0% and 100% respectively.

    The solution is pretty easy. Just change this formula:

    =(H2/G2)

    to:

    =IF(H2=0,0,(H2/G2)-1)


    Thanks again for making this spreadsheet!
    BD
  • Not A BoothNot A Booth Registered Users Posts: 15 Big grins
    edited October 23, 2010
    Okay, I just got to playing with this a bit more, and I took the liberty of adding columns that calculate your profit if you offer coupons (increments of 5% from 5%-30% off). It shows up in (red) if your profit ends up in the negative due to the coupon.


    Here's a direct link to the Excel file:

    SmugMug Pricing Sheet Excel


    BD
  • joedifjoedif Registered Users Posts: 52 Big grins
    edited October 25, 2010
    Excellent!!

    Thanks so much thumb.gif
    _________________________________
    Joe D.

    My SmugMug
  • PhotosbyKWPhotosbyKW Registered Users Posts: 137 Major grins
    edited October 26, 2010
    JCDaydream wrote: »
    Howdy,

    For anyone that's interested, I have created a spreadsheet with all of the SmugMug products and pricing in it. I'm using it as an offline price list as well as to work out prices and margins before updating them on the Smug interface. I've also included some other automatic calculations like image size ratios, etc.

    If anyone would like a copy (to save you the time of typing it up yourself) let me know and I'll figure out a way to get it to you. thumb.gif

    Added Aug-18-2010

    Now that I've posted it to my site, I thought I'd add the link up here on the first post so it's easier to find.

    SmugMug Price Sheet

    Enjoy


    I'll look forward to seeing this as well. Thanks.
    Consistantly Inconsistant.

    www.PhotosbyKW.smugmug.com
  • TonyLTonyL Registered Users Posts: 169 Major grins
    edited October 27, 2010
    Thanks for the effort and being so kind to share.

    Sent from my HTC Incredible using tapatalk
    -Anthony

    APL Photography || My Gear: Bunch of 4/3rds stuff
    Facebook: Friend / Fan || Twitter: @aplphoto
  • its just jbits just jb Registered Users Posts: 2 Beginner grinner
    edited October 29, 2010
    Thank you!!
    bowdown.gifKUDOS!!

    This is awesome. Now I need to go and perform some unpleasant task (like the one you did making this spreadsheet) for us all and share it with everyone. It's good to give back a bit!

    Thank you for all the effort!!

    joey
  • josweigartjosweigart Registered Users Posts: 4 Beginner grinner
    edited November 2, 2010
    Thanks for sharing. This is great!
  • jchinjchin Registered Users Posts: 713 Major grins
    edited November 21, 2010
    James, thank you for the spreadsheet. I tried to build my own and wasted hours not getting to where you did. Thank you. You've made my day! And saved my day, literally! You rule! Thanks.
    Johnny J. Chin ~ J. Chin Photography
    FacebookFlickrSmugMug
    SmugMug referral coupon code: ix3uDyfBU6xXs
    (use this for a discount off your SmugMug subscription)
Sign In or Register to comment.